I need to generate a report on the fly using PHP accessing a MySQL database (
Sample html and view or report layout are included in the zipped PDF file).
The report is derived from two tables: “isalesumary?? and ??salesrecords??.
Both tables have two common fields: NUMBERTICKETS and ZIPCODE. I would like to use these two tables to create a zip code report by:
* validating that the value in the zip code field is valid by accessing a table names zipcodes ??" if the zip code is blank or invalid the NUMBERTICKETS is ignored.
* order in descending order the results based on the sum of the number tickets sold by zipcode.
I have included the layout of the three tables: “isalessummary??, “salesrecords?? and “zipcodes??.
I also would like to create a report that shows totals by State ??" foreign country ??" not specified. The table “salesrecords?? has a field COCOUNTRY that specifies the foreign country code of an attendee. The State information may be taken from the fields STATE that also is a common field in both files.
I need commented code and may have a few questions about the results.
You will have access to a test bed site to write the reports.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
linux
php