i got a mysql db that includes call report (CDR). i can provide a sample db
i need a php script that will display a nice formatted page with the following info:
total amount of calls in selected queues
total amount of answered call in the selected queues
total amount of calls that reached timeout
total amount of agents logged in and thier names (this can be obtianed from /ets/asterisk/[url removed, login to view])
agents first login time and last logoff time and total time he was logged in.
total time each agent was on the phone
total time each agent was on pause
total number of calls each agents answered
total amount of calls each agent made (outbound)
I need the script to run in cron job therefor i need it to read variables from the post/get command like /www/html/[url removed, login to view];queues=queue1&queue&queue3&date=24082010 and etc..
script should also include a send by mail function with list of receipents like ;
also, all info should be printable so it must fit in one page.
if i like your job you will get plenty of enhancments to this script in the future.
18 freelancers are bidding on average $186 for this job
I represent a company Siberian Developers Studio Ltd., which is developing and promoting web sites, software development. Our website [url removed, login to view]
I have successfully implemented and maintained similar system in my previous job. I would like to discuss you requirement in detail to provide more information on delivery plan.