OBJECTIVE: feed an invoicing system with data from MYSQL - 04/12/2017 12:45 EST

There is a Mysql table where calls logs are stored. It contains typical fields such as: -Username -Date -Duration -Price (2h) The idea is to AUTOMATICALLY (cronjob) run a query to make some counts and sums in a customizable per customer timely basis : Group by Username CountPrice SumPrice We need to add time base parameter used to program cronjob, example : run process each : 1,7,15,30,60,90,120,180,360 days Is necessary to create this new field in DB and also to inclde appropiate control in a user´s form. (2h) Then once we have above data we can store it and send it to an invoicing system [login to view URL] using API. (1h)Then we will use method to create an invoice: [login to view URL] (1h) Then we will use this other method to send email to Customer with invoice: [login to view URL] That´s all (2h) assorted tasks, finshments ,etc