This project involves creating a Microsoft Word template and adding the functionality to import data from a MySQL database to the template. The template will consist of text and a few images and some php coding and knowledge of MySQL databases will be necessary. Most of the text within the template will be fixed but some of the text will be need to be imported from a MySQL database that resides on our web server.
The way this would work is as follows-
Within our web app, the user will select the client for which the report is needed and then click the “Print Report” button. The report should then be generated in Word and populated with the appropriate data from the database.
The template will consist of 4 pages but 2 of the pages may be repeated several times within the report as indicated below.
1) The first page will be a cover page with 3 fixed images and one line of fixed text. There will be only 1 cover page per report.
2) The second page will be a form letter to the client and will consist of fixed text, text from the database and 3 fixed images. There will be approximately 20 fields that will need to be imported from the database. The length of the letter may cause this page to span 2 pages instead of 1. There will be only 1 letter per report.
3) The third page type will be a 2-column table with data from the database. The number of lines in the table and the information that will be contained in this table will be dependant on the number of items that meet certain criteria so some php code will be required to populate the table with the correct information. Since the number of rows in the table will vary, this page may actually span more than 1 page. Also, depending on the client, there may be more than 1 table per report. Again, php code would need to check certain conditions to determine how many tables will need to be printed.
4) The fourth page is a summary page that will combine standard text with data from the database. This page will only be one page long (it won’t spill over to a second page) but a separate summary page will need to be printed for each table (page 3) that was printed.
To better explain this, a client may have 3 items. The first item contains 20 parts, the second item contains 15 parts and the third item contains 40 parts. When the report is generated for this client, the following items will need to be included in the report: (a) 1 cover page, (b) 1 form letter, (c) 3 tables – the first table will have 20 rows, the second will have 15 rows and the third will have 40 rows, (d) 3 summary pages (1 for each table).
The user should be able to edit and save the Word file for the particular client.
If you have any questions or require additional information, please ask.