2. PHPRunner General questions
  3. Generate forms suitable for printing...
This topic is locked

Generate forms suitable for printing...

 		1/1/2007 4:41:08 PM
PHPRunner General questions
J
 Jkelleyus author

Hello again all...
My project for the charity I'm working with using phpRunner is working out so nicely they want to do MORE!
Great... I said as I scratched my head a little.
We have successfully implemented a full-blown system for tracking production and scrap for this little manufacturing operation, snd now they want to track shipping as well. Most of this was a snap with phpRunner... but I'm stuck on how to generate custom packing slips and 'Bills of Lading' (shipping documents) so that they can be printed and used.
I'm aware this would take some custom coding and is probably outside the scope of phpRunner... but perhaps someone could make a suggestion as to what tools to use here?
I know a little HTML and a little php... just enough to really mess this up, I'm afraid. Are there other software tools similar to phpRunner that would interact well enough so say... a user generates a 'shipment record' with phpRunner and then can print it out in a decent looking, presentable fashion?
As always, your help and guidance is appreciated...
Jake
T
 		thesofa 1/1/2007

Hi

Have a look here it is a post about the same sort of thing
J
 		Jkelleyus author 1/2/2007

Hi

Have a look here it is a post about the same sort of thing


Thanks theSofa.... interesting....
Do you think I could use Microsoft Word to generate a HTML document in the same manner and edit it to insert values from the database (MySql) using a plaintext editor (kind of like Alexey described)?
Say I have used phpRunner to generate an application with Master/Detail relationships. In this case, the Master record is a shipment, and the details have various part quantities and other information. This works great with phpRunner... but I want to take all that information and 'merge' it with fields on my Word generated HTML?
Maybe I'm making this more complicated than it needs to be?
I look forward to your responses... and THANKS for the great community.
Jake
T
 		thesofa 1/2/2007

read the last post in that thread, Alexy talks about using a word template.

As for printing master slave documents, I have no idea, but you could play and try!!!
J
 		Jkelleyus author 1/2/2007

Thanks again, theSofa.
After playing with the HTML generated by phpRunner on the 'printer friendly' page listing the Master/Detail records, I'm getting closer to what I want.
I'm still stuck on the 'Master' table record, though. phpRunner includes "$showmasterfile" to display the master record.
I need to reach that data somehow and display it as I'd like in the custom HTML.
The detail records... pieces, description and weight are all from the detail record and I can manipulate THAT table however I want... but I'd have to dig into the '$showmasterfile' to get other data from the master.... in this case a ship_to_name, ship_to_address, ship_carrier, etc.
Any idea how that's done while editing the 'printer friendly' page that displays both a master and related detail records?
Thanks,
Jake
Admin 1/2/2007

Jake,
you can edit master record page in Visual Editor.

Proceed to the master table in Visual Editor and edit Master table info (print).