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
 
The pin code is already on
Sun, 03/16/2008 - 11:46am
The pin code is already on the Mysql table. It is just not showing on the report :)
You may try to modify the php scripts or write your own app...
 
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!
 
Didn't work for me
Fri, 07/11/2008 - 1:32pm
I tried adding those lines and it still does not show me the Pin sets code in my cdr reports. I am trying to keep record for tracking records for specific users. Is there something missing?
Thanks
Tommaso
 
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
 
It Works!
Wed, 09/09/2009 - 1:22am
For the completion of this forum, frnty's adding of scripts does work, just pay attention where you add it in your call-log.php file.
In total, you add one line, and modify one aditional line.
Regards
 
Will not work For me :(
Sun, 05/09/2010 - 11:03pm
I have added the code in between the AMP Begins and Ends as per below. But it still will not display in my CDR??
I have tried a couple of browsers but to no avail. Any ideas?
/* --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 -- */
 
Member Since:
2006-11-18