Code in PHP/MySQL to populate middle tables for reporting

We have a DB for which we need to do Daily/Weekly/Month/Start-Date-End-Date reporting. And we have created a front end where it can be displayed and a set of table (we call these 'middle tables') that can be used to store needed data so it can be displayed on the front end. Now we need the code in PHP/MySQL that will query the production tables (customers, orders, payments, etc) do some calculations and update the 'middle tables' with the correct data. And we need someone to develop this code. More documentation will be available upon request.