Fullwallboard tweaking what counts as an outbound call
We have a client with FreePBX/PBXact, FOP2 and Callcenter Stats Pro.
If one extension calls another extension, it adds 1 to their outbound calls number in the queue.
The client would like internal calls, and internal transfers to not count as an outbound call.
My thoughts are to edit the getstatsfromasternic.php file, possibly on line 481, to only include context=macro-dialout-trunk
I dont know the MySQL code yet but it could look something like this - I have my extra bit in bold.
Does this sound like it could work, or has anyone a better idea?
/* $query = "SELECT agent,count,talktime FROM ( "; $query.= "SELECT a.name AS agent,count(*) AS count, sum(billsec) AS talktime "; $query.= "FROM asterisk.users a "; $query.= "INNER JOIN ( SELECT * FROM asteriskcdrdb.cdr WHERE calldate >= $mydate) b "; $query.= "ON extension=src AND lastapp='Dial' **AND context='macro-dialout-trunk'** GROUP BY a.name "; $query.=") j WHERE 1=1 $condagent"; */