|
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, ... |