Project: Printable PDF Report from MySQL Data
I have a PHP-based web application that stores data in a MySQL database. For this project you will create a PHP script that will export a PDF and email to a user when the store ID is included as a variable ([url removed, login to view]) It will generally be run as a cron job and needs to report multiple stores separate reports emailed when more than one is called. ([url removed, login to view],12346,12347,12348).
The format (layout) of the report is predefined and can be seen in the attached sample report. The report will consist of one static image (logo), 3 graphs, text variables and numeric variables from the database and some static text (comments area to allow hand writing on when printed). It is a 1 page A4 report that gets the data from about 10 MySQL tables with quite a number of queries needed to make the report.
I require this ASAP.
If you have any questions or require additional information, please ask. If there is anything that is unclear in my explanation of this project, please ask for clarification. It’s very important that you fully understand the requirements for this project before bidding and have viewed the example.
There are 16 tables as I have decided to only have the most recent sales data in the table1_current tables and the Last Year etc data in table1.
Please see scanned attachement that shows what info is sourced from what table.