TCPDF / MYSQL / PRINTING UPTO 2 COLUMNS AND 2 ROWS PER PAGE AND BEYOND IF NEEDED..
Posted on 2011-03-17
I'm a pretty advanced programmer but lazy at figuring out new technology so you don't need to hold my hand, I just want an example.I have a mysql table named rx_queue with each row represent a prescription. The paper it is being printed on is 8x11 (standard letter size paper designed so upto 4 prescriptions can be printed at one time (the paper is preperforated, each prescription is 4.00x5.50 in size.
I need the code to look through each row and create the proper amount of columns and rows and pages (if beyond 4 prescriptions are queued)
The order doesn't matter... if there is 1 prescription or 4, a table with 2 rows and 2 columns 4.00x5.50 in size in each cell must be created. If there's only 1 prescription, the code should print the word VOID in the center of the unused columns.
If there is 13 prescriptions queued (just for arguments sake), the program will need to print 4 pages with the first three pages containing 4 prescriptions each and the 4th one only one prescription and the rest of the cell on that page must have the word VOID printed on it due to sate/federal law (self explanatory).
The prescriptions themself (what will go inside each cell--I will design myself, as long as the foundation is in place so the script works as needed. Just note that in each cell I will be creating tables to properly format the data (table in a table--I intend to use tcpdf method or just plain writing html tables, please advise on this)