Friday, September 26, 2014

Steps to handling the call forwarding (from call group)

The current a2billing doesn't support the call forwarding and incoming call rating. Hence, we will have to write our own rating engine and also update the a2billing tables according.
Based on the following SQL, we shall able to identify all the call fowarding traffic but then it has to be match to the individual calling number to determine the account no.

mysql> select calldate, dst, dcontext, dst, billsec, (billsec/60) into outfile "/tmp/DS20141005_04" FIELDS TERMINATED BY '|' from cdr where channel like '%from-internal%' and dcontext = "from-internal" and dst = "60182258257" and calldate > "2014-09-01 00:00:00" and calldate <= "2014-09-30 23:59:59" order by calldate;

No comments:

Post a Comment