PIN Set Codes not showing in the CDR
Submitted by tseymour on Fri, 03/07/2008 - 10:06am.
Can anyone help me with this? Set the pin codes, check to record in CDR, but not showing the code next to long distance calls. The PBX is asking for the code and completing the calls correctly. Just nothing to show in the report! Their CFO would like to know how to bill their time!! *wink*
Please help!
Thanks!
t
PIN sets
Mon, 03/24/2008 - 6:19pm
Well, I'm wondering why bother putting the option in the PIN sets module to include a PIN code in your report if it doesn't work?!?! I have been working with a well verse person in PHP and he is just as confused!
Where to you write the code? which PHP file is it you customize?
Please advise!
Thanks!
T
vi
Wed, 05/14/2008 - 11:55am
vi /var/www/html/admin/cdr/call-log.php
and add after this line:
$FG_TABLE_COL[]=array ("Duration", "duration", "6%", "center", "SORT", "30", "", "", "", "", "", "$minute_function");
this line:
$FG_TABLE_COL[]=array ("Pin", "accountcode", "14%", "center", "SORT", "30");
and then after this line:
//$FG_COL_QUERY='calldate, channel, src, clid, lastapp, lastdata, dst, dst, serverid, disposition, duration';
modify the next line to match the following one:
$FG_COL_QUERY='calldate, channel, src, clid, dst, disposition, duration, accountcode';
and you're set!
:)
Regards!
It really works!!
Thu, 10/02/2008 - 4:04pm
Tommaso,
Be careful and check that you aren't modifying the code that is commented.
The block of code that you need to change is this (you see here the changes made):
/* --AMP Begin-- */
$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");
$FG_TABLE_COL[]=array ("Dst", "dst", "14%", "center", "SORT", "30");
$FG_TABLE_COL[]=array ("Disposition", "disposition", "9%", "center", "", "30");
if ((!isset($resulttype)) || ($resulttype=="min")) $minute_function= "display_minute";
$FG_TABLE_COL[]=array ("Duration", "duration", "6%", "center", "SORT", "30", "", "", "", "", "", "$minute_function");
$FG_TABLE_COL[]=array ("Pin", "accountcode", "14%", "center", "SORT", "30");
$FG_TABLE_DEFAULT_ORDER = "calldate";
$FG_TABLE_DEFAULT_SENS = "DESC";
// This Variable store the argument for the SQL query
//$FG_COL_QUERY='calldate, channel, src, clid, lastapp, lastdata, dst, dst, serverid, disposition, duration';
$FG_COL_QUERY='calldate, channel, src, clid, dst, disposition, duration, accountcode';
/* --AMP End -- */
Note that the block to modify isn't the one that starts with:
/* --original--
$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", "10%", "center", "", "30");
$FG_TABLE_COL[]=array ("Clid", "clid", "12%", "center", "", "30");
$FG_TABLE_COL[]=array ("Lastapp", "lastapp", "8%", "center", "", "30");............
I hope this tip helps you!!!
AJ
Member Since:
2006-11-18