I have some database tables and queries that I've turned into a clunky SUM and COUNT operation for activities coming from a single Jobs table.
Have to be clever with flat table query building and AJAX, as they want to use a date picker to give a date range and auto-update these summary tables (one viewable by admins and one by estimators of only their own stats) plus company wide calculations in the format seen here:
[login to view URL]
login: admin
pw: admin
Just that main page, plus then a second page with weekly breakdowns - attached docs describe in detail
## Deliverables
So two pages:
Index, part of the zip file, modified with asynchronous date range filtering for calculation tables and then a weekly breakdown page like the Excel file attached.
All looped and COUNTED for all records associated to a give UserType = 2 User.