I need a report builder in MySQL/PHP that can do the following reports.
Closed Checks, Open Checks, Check Tender Detail, Clock Activity, Coupons, Charge Cards, Discounts, Gross Receipts, Revenue, Tax, Product Mix, Labor Cost, Refund, Shift, Tender, Employee, Customer, Transaction Time, Tables
Entries
Should also provide bar, line, and pie graphs to represent tenders, refunds, employees, item/product mix, discounts, [login to view URL] are [login to view URL] report should have a date start select and a date stop select, which should be a calendar picker. It should also allow you to specify a start time and a stop [login to view URL] the appropriate reports, I should be able to select specific items, customers, employees, tenders, groups, categories, and other fields to limit the results by. The system should be very very flexible and allow me to make the reports very generic or specific. It should also let me save reports in a Favorites screen so that I can go back to them and view them without resetting all of the options again.
I have attached all of the SQL tables that you will need to build the reports. Some additional tables and fields may be needed to get the desired results, and we will have to work on the graphs, summaries, columns, and such, but this should be pretty straight forward for someone who knows reporting well.
The reports should be based off of these tables (others may be required):
rpt_transactions and rpt_transaction_details
saved_transactions and saved_transaction_details
timeclock_entries
## Deliverables
Must be graphically nice with nice icons, alternating row colors, and all around a nice professional look and feel.