Enhance PHP POS with Reports

My in-house Café POS is already running on PHP and MySQL; now I need two new screens built into the same code-base.

First, a Sales Report page rendered in a clean table format. The table must let me toggle between:
• Daily sales
• Monthly sales
• Top selling products and product wise sales report as well

Queries should run efficiently on existing order and product tables, and totals must recalculate instantly when I change the date range.

Second, a simple Customer Details page that stores and displays each guest’s name and contact information. No loyalty or purchase history for now—just reliable add, edit and search functions with basic validation.

Deliverables
1. Fully integrated PHP/HTML/CSS/JS code for both pages, matching the current UI style.
2. Any new MySQL tables or ALTER scripts required.
3. Brief setup notes so I can deploy to my staging server.

I’ll provide a Git pull of the current project on award; please keep all changes in modular commits so I can review easily.