Simple Transaction Report in PHP

I would like to create a report using php. We have a very simple webpage that downloads transaction records and we would like someone to create a report based on this information. Requirement: 1. User goes to our webpage and runs transaction report. 2. When report is finished, user uploads "payment confirmation report" (simple csv) 3. JOIN the two reports/files using an order number. The "payment confirmation report" shows which cc payments have been successful. 4. Create the two following reports. Report 1 Output every transaction in the format with an additional column (above) to show successful payments. Report 2 Create monthly totals broken down by product and payment type,eg: Transaction in August : Payment type Credit Card Product Name Units Sold Price Tax Total Product a nnn $ [login to view URL] $ [login to view URL] $ [login to view URL] Product b nnn $ [login to view URL] $ [login to view URL] $ [login to view URL] Product c nnn $ [login to view URL] $ [login to view URL] $ [login to view URL] Product x nnn $ [login to view URL] $ [login to view URL] $ [login to view URL] Product y nnn $ [login to view URL] $ [login to view URL] $ [login to view URL] Product z nnn $ [login to view URL] $ [login to view URL] $ [login to view URL] Total nnn $ [login to view URL] $ [login to view URL] $ [login to view URL] Notes: - There are only 4 payment types (coded in a column 1-4) - Not all products include tax. We must provide a list of product codes that you must show tax. ie. order may have product "a" as $10. You must show price ex. tax $9.09 and tax $0.91. Sample files will be provided to the succesful bidder. Access to our existing website and php coder will also be provided. ## Deliverables Additional information! Sample Data [login to view URL] - this the information currently created by our website (extracted from our database) [login to view URL] - this is the information the user will upload as part of the report generation process. Fields required for report from: [login to view URL] orderID = Order Id (Key) productId = Product Id units = Number of units unitPrice = Unit price paymentMethodTypeID = Method of payment (1= credit card, 2=cheque, 3=cash, 4=EFT) amount = Amount Paid Fields required for report from: [login to view URL] "Invoice Reference" = Order Id (Key) Result = Transaction successfull NOTES: 1) The sucessfull bidder will have access to the page creating the data for sampledata_fromweb.csv. 2) Deliverables for this project: A working php page that creates the reports requested in downloadable csv files. * * *This broadcast message was sent to all bidders on Monday Sep 12, 2011 10:28:31 AM: Hi Bidders, I've just edited the project to include additional documentation and sample files. Regards, Troy.