On 2009-10-02 11:46, Task-By Christian Lathion wrote:
Develop a php script. You can start on your local computer or in a web page.
It must launch queries remotely in the billing slave server, to calculate the ASR and ACD for the last 100 minutes for the destination "Armenia-Yerevan" (prefix 37410). Example of implementation of the php script:
- one request retrieves the number of calls and average duration for the last 100 minutes (in table CDR_Vendors)
- one request retrieves the number of failed call attempts in the last 100 minutes (in table CDR_Vendors_Failed)
- ACD is obtained directly with the first request
- to compute ASR (the ratio "successful calls/failed calls"), you must combine the results of both requests
- store the obtained results in a table on the server (you'll have to create a database and a table for this)
This must be done for two vendors: verizon (i_vendor=55) and colt (i_vendor=62)
Start with small steps. First, some "hello world" php script to test the php installation. Then, a simple query to the remote server to test the mysql connection, ...