Php/mysql Xml Parsing Project 16.11.08
Please note that the report needed is already created. It pulls the data from the database but now we want to pull the data from an xml file so some report tweaking and xml parsing will be needed.
a. Index Page: On this page the admin will select what he’d like to do:
a. Upload a file & create a new report
b. Pull an old report
b. Create a page to do the following:
a. Enter a unique name of the xml document (alphanumeric)
b. Browse and upload the xml document
c. Create 2 tables in database:
a. Table 1: Will keep track the name and date of the xml file.
b. Table 2: Will capture all the data of the xml file
d. Reports Page:
a. For new uploads the admin will be taken here directly to view the report.
b. For old reports admin will choose the date range and all the available reports will come up. These are reports that are already processed by the system. Each report will be linked to it’s xml so that we can easily separate them. Even though the data for each xml will be stored in 1 table the reports will still be separated. Once the report is pulled it gets saved on the file server so that we don’t need to pull it again from the database.
e. A summary Report which will give us a total of how many orders we got with total dollar amounts. See file attached.
