Write a basic database and API linking

We need a system that will capture voip calling records, post the calls to a mysql database and display it for users to view. At the end of each month, the system will need to post the monthly billing total to our billing software. Capturing Call records: 1) A cron job on our web server will run every 5 minutes 2) An http post / get query is run against the CDR server. It contains the fields required to query the CDR server (including the starting call number) 3) The CDR records are returned as CSV 4) The records within the CSV are posted to the sql database 5) Next time the cron job is run, the query will include the new starting call number (last call record + 1) so old records are not redownloaded over and over again. Posting billing information When each call is posted to the sql database, the call cost field is looked at and a couple of extra fields are posted also. 1) call cost + XX% and 2) call cost + YY% Configuration We need a page where we can go and give each line a customer number, XX% and YY% Viewing call logs 1) Customer is presented with a login page. They are asked for Customer Number, username and password 2) When the customer clicks LOGIN, a restful api query is run against our billing server which will allow you to check the username and password are valid. 3) If the user/pass are valid, all lines configured for that customer number are displayed with call records by month It shows the call from/to/cost + XX% A motel mode exists so the customer can switch to a second screen where it displays each line and calls grouped by day from midday to midday and the from/to/cost + YY% pricing instead of the cost + XX% All information is provided in the CSV including the base cost field. The only calculations that need to be made as the calls are downloaded and posted to the database are the two call cost fields - that is base cost + XX% and base cost + YY% The XX and YY are set on each individual line on our configuration / setup page. End of Month cronjob On the 29th of each month, a cronjob will run which will 1) Take the XX cost for the calls on each line and post it to our billing system using the rest API 2) Delete old database call records that are older than 120 days Test Mode cronjob We need to have a seperate cron job (we can edit the php code) that simply posts a charge to a specific customer account so we can ensure that the API is going to work. Our web host ip address sometimes changes so when it does, we can run the test against a demo account in our billing system to ensure that the monthly cron is still going to work and post the charges to the accounts on the billing server. The monthly charge is a total of the calls for each line - and not each individual call. The motel mode display which displays calls by line > day will come later and is not required in the original project. So if you could please quote a price to add this display page on later that would be good. In the attached document are a few things to show you what we are after.