Reports , Displaying 'billsec' value instead of 'duration'!

FreePBX Tips and Tricks
1

in reports tab, CDR-is showing result incorectly, it is showing “duration” field from CDR, it means that it showing calling time, busy time and other. (when NOT ANSWERED, duration is about 30 sec or more :slight_smile: )

If you want it to show only talk time you should use asterisk CSV-file, or use other billing sysytem (like a2b).

I did it another way, I changed PHP-files, so they now are showing only talk time (on BUSY or NOT ANSWERED there is now 0 sec):

In folder “/var/www/html/admin/cdr” I changed 4 PHP-files:
‘call-comp.php’
‘call-daily-load.php’
‘call-last-month.php’
‘call-log.php’

In these files I changed word ‘duration’ (CASE SENSITIVE) on word ‘billsec’

‘billsec’–in asterisk CDR is talk time,

It’s all… :slight_smile:

2

diff call-log.php call-log.php.20111229

71a72

86,89c87,90
< $FG_TABLE_COL=array (“Calldate”, “calldate”, “16%”, “center”, “SORT”, “19”);
< $FG_TABLE_COL=array (“Channel”, “channel”, “18%”, “center”, “”, “30”);
< $FG_TABLE_COL=array (“Source”, “src”, “12%”, “center”, “”, “30”);
< $FG_TABLE_COL=array (“Clid”, “clid”, “12%”, “center”, “”, “80”,‘’,‘’,‘’,‘’,‘’,‘filter_html’);

$FG_TABLE_COL=array (“Calldate”, “calldate”, “18%”, “center”, “SORT”, “19”);
$FG_TABLE_COL=array (“Channel”, “channel”, “13%”, “center”, “”, “30”, “”, “”, “”, “”, “”, “display_acronym”);
$FG_TABLE_COL=array (“Source”, “src”, “14%”, “center”, “”, “30”);
$FG_TABLE_COL=array (“Clid”, “clid”, “26%”, “center”, “”, “80”,‘’,‘’,‘’,‘’,‘’,‘filter_html’);
91c92
< $FG_TABLE_COL=array (“Dst”, “dst”, “20%”, “center”, “SORT”, “30”);

$FG_TABLE_COL=array (“Dst”, “dst”, “14%”, “center”, “SORT”, “30”);
93c94
< $FG_TABLE_COL=array (“Disposition”, “disposition”, “10%”, “center”, “”, “30”);

$FG_TABLE_COL=array (“Disposition”, “disposition”, “9%”, “center”, “”, “30”);
96d96
< $FG_TABLE_COL=array (“Billsec”, “billsec”, “6%”, “center”, “SORT”, “30”, “”, “”, “”, “”, “”, “$minute_function”);
104c104
< $FG_COL_QUERY=‘calldate, channel, src, clid, dst, disposition, duration, billsec’;

$FG_COL_QUERY=‘calldate, channel, src, clid, dst, disposition, duration’;