<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-9">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.apple-style-span
{mso-style-name:apple-style-span;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span lang=TR>hello,<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR>First of all i am using Asterisk 1.6.2.9-2<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR>The following problem seem like a bug to me
but im not sure.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR>Any help or comment will be great..<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=TR>We are trying to implement our own billing
software with AGI - Php Scripts.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=TR>When a hangup received, i am calling a script
to calculate the bill and we are trying to write the results to cdr database.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR>We added two fileds to cdr table as rate and
cost.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=TR>When we call a number and the other party
doesnt hang up, rate (the targets rate according to our rates table) and cost
(calculated cost according to rate and billable seconds) is written to database
correctly.(sure cost is 0 because of hangup.)<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=TR>But, if other party picks up the phone, and
makes the call, even at debug of php, i can see all the data correctly, it
doesnt update the cdr fileds correct.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=TR>Here is the php script output and cdr output
of the calls.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=TR>No answer:<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR>aftercall.php: [agi_context] =>
DLPN_WorldcallDial<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php: [agi_extension] => h<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php: [agi_priority] => 2<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php: [agi_enhanced] => 0.0<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php: [agi_accountcode] =><o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php: [agi_threadid] =>
139906110289680<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php: >code<: 200<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php: >result<: 1<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php: >data<:<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php: >code<: 200<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php: >result<: 1<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php: >data<: 0.04830<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php:
>>>>>>>>>>rate:0.04830<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php:
>>>>>>>>>>duration:<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> -- AGI Script Executing Application: (set)
Options: (CDR(userfield)=0)<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> -- AGI Script Executing Application: (set)
Options: (CDR(rate)=0.04830)<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> -- AGI Script Executing Application: (set)
Options: (CDR(cost)=0)<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php:
>>>>>>>>>>>>>>>>cost:0<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> -- <SIP/10010-0000000c>AGI Script
aftercall.php completed, returning 0<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR>and at the cdr rate is filled as </span><span
class=apple-style-span><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:black'>0.04830 and cost is 0 as it should be.<o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-size:10.0pt;
font-family:"Arial","sans-serif";color:black'><o:p> </o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-size:10.0pt;
font-family:"Arial","sans-serif";color:black'>This is answered state:<o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-size:10.0pt;
font-family:"Arial","sans-serif";color:black'><o:p> </o:p></span></span></p>
<p class=MsoNormal><span lang=TR>aftercall.php: [agi_context] =>
DLPN_WorldcallDial<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php: [agi_extension] => h<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php: [agi_priority] => 2<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php: [agi_enhanced] => 0.0<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php: [agi_accountcode] =><o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php: [agi_threadid] =>
139906110289680<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php: >code<: 200<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php: >result<: 1<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php: >data<: 5<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php: >code<: 200<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php: >result<: 1<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php: >data<: 0.04830<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php:
>>>>>>>>>>rate:0.04830<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php:
>>>>>>>>>>duration:5<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> -- AGI Script Executing Application: (set)
Options: (CDR(userfield)=0.0483)<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> -- AGI Script Executing Application: (set)
Options: (CDR(rate)=0.04830)<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> -- AGI Script Executing Application: (set)
Options: (CDR(cost)=0.0483)<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR> aftercall.php:
>>>>>>>>>>>>>>>>cost:0.0483<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=TR>But the cdr rate and cost fields are both "0".<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR>And this is the php scripts filed update part.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR>$agi->exec("set",
"CDR(userfield)={$cost}");<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR>$agi->exec("set",
"CDR(rate)={$rateArray['data']}");<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR>$agi->exec("set",
"CDR(cost)={$cost}");<o:p></o:p></span></p>
<p class=MsoNormal><span lang=TR>$agi->conlog(">>>>>>>>>>>>>>>>cost:".
$cost);<o:p></o:p></span></p>
</div>
</body>
</html>