diff --git a/library/cdr_opensips.php b/library/cdr_opensips.php
index b978454..db12212 100644
--- a/library/cdr_opensips.php
+++ b/library/cdr_opensips.php
@@ -1,5350 +1,5363 @@
 <?php
 class CDRS_opensips extends CDRS
 {
     public $table                 = "radacct";
     public $CDR_class             = "CDR_opensips";
     public $subscriber_table      = "subscriber";
     public $ENUMtld               = '';
     public $maxCDRsNormalizeWeb   = 500;
     public $sipTrace              = 'sip_trace';
     public $mediaTrace            = 'media_trace';
     public $missed_calls_group    = 'missed-calls';
     public $rate_on_net_group     = 'rate-on-net';
     public $callerid_cache        = array();
 
     public $CDRFields = array(
         'id'              => 'RadAcctId',
         'callId'          => 'AcctSessionId',
         'duration'        => 'AcctSessionTime',
         'startTime'       => 'AcctStartTime',
         'stopTime'        => 'AcctStopTime',
         'inputTraffic'    => 'AcctInputOctets',
         'outputTraffic'   => 'AcctOutputOctets',
         'flow'            => 'ServiceType',
         'tlscn'           => 'AcctAuthentic',
         'aNumber'         => 'CallingStationId',
         'username'        => 'UserName',
         'domain'          => 'Realm',
         'cNumber'         => 'CalledStationId',
         'timestamp'       => 'timestamp',
         'SipMethod'       => 'SipMethod',
         'disconnect'      => 'SipResponseCode',
         'disconnectOrig'  => 'AcctTerminateCause',
         'SipFromTag'      => 'SipFromTag',
         'SipToTag'        => 'SipToTag',
         'RemoteAddress'   => 'SipTranslatedRequestURI',
         'SipCodec'        => 'SipCodecs',
         'SipUserAgents'   => 'SipUserAgents',
         'application'     => 'SipApplicationType',
         'BillingPartyId'  => 'UserName',
         'SipRPID'         => 'SipRPID',
         'SipProxyServer'  => 'NASIPAddress',
         'MediaProxy'      => 'FramedIPAddress',
         'gateway'         => 'SourceIP',
         'SourceIP'        => 'SourceIP',
         'SourcePort'      => 'SourcePort',
         'CanonicalURI'    => 'CanonicalURI',
         'normalized'      => 'Normalized',
         'rate'            => 'Rate',
         'price'           => 'Price',
         'DestinationId'   => 'DestinationId',
         'ResellerId'      => 'BillingId',
         'MediaInfo'       => 'MediaInfo',
         'RTPStatistics'   => 'RTPStatistics',
         'ENUMtld'         => 'ENUMtld',
         'UserAgent'       => 'UserAgent',
         'FromHeader'      => 'FromHeader'
     );
 
     public $CDRNormalizationFields = array(
         'id'              => 'RadAcctId',
         'callId'          => 'AcctSessionId',
         'username'        => 'UserName',
         'domain'          => 'Realm',
         'gateway'         => 'SourceIP',
         'duration'        => 'AcctSessionTime',
         'startTime'       => 'AcctStartTime',
         'stopTime'        => 'AcctStopTime',
         'inputTraffic'    => 'AcctInputOctets',
         'outputTraffic'   => 'AcctOutputOctets',
         'aNumber'         => 'CallingStationId',
         'cNumber'         => 'CalledStationId',
         'timestamp'       => 'timestamp',
         'disconnect'      => 'SipResponseCode',
         'RemoteAddress'   => 'SipTranslatedRequestURI',
         'CanonicalURI'    => 'CanonicalURI',
         'SipRPID'         => 'SipRPID',
         'SipMethod'       => 'SipMethod',
         'application'     => 'SipApplicationType',
         'flow'            => 'ServiceType',
         'BillingPartyId'  => 'UserName',
         'ResellerId'      => 'BillingId',
         'price'           => 'Price',
         'DestinationId'   => 'DestinationId',
         'ENUMtld'         => 'ENUMtld'
     );
 
     public $GROUPBY = array(
         'UserName'             => 'SIP Billing Party',
         'CallingStationId'     => 'SIP Caller Party',
         'SipRPID'              => 'SIP Remote Party Id',
         'CanonicalURI'         => 'SIP Canonical URI',
         'DestinationId'        => 'SIP Destination Id',
         'NASIPAddress'         => 'SIP Proxy',
         'FramedIPAddress'      => 'Media Proxy',
         'MediaInfo'            => 'Media Information',
         'AcctAuthentic'        => 'TLS Common Name',
         'SourceIP'             => 'Source IP',
         'Realm'                => 'SIP Billing domain',
         'UserAgent'            => 'User Agent',
         'SipCodecs'            => 'Codec type',
         'SipApplicationType'   => 'Application',
         'SipResponseCode'      => 'SIP status code',
         'BillingId'            => 'Tech prefix',
         'ServiceType'          => 'Call Flow',
         ' '                    => '-------------',
         'hour'                 => 'Hour of day',
         'DAYOFWEEK'            => 'Day of Week',
         'DAYOFMONTH'           => 'Day of Month',
         'DAYOFYEAR'            => 'Day of Year',
         'BYMONTH'              => 'Month',
         'BYYEAR'               => 'Year'
     );
 
     public $FormElements = array(
         "begin_hour","begin_min","begin_month","begin_day","begin_year","begin_datetime","begin_time","end_time",
         "end_hour","end_min","end_month","end_day","end_year","end_datetime","end_date","begin_date",
         "call_id","sip_proxy", "media_proxy", "tlscn",
         "a_number","a_number_comp","UserName","UserName_comp","BillingId",
         "c_number","c_number_comp","DestinationId","ExcludeDestinations",
         "NASPortId","Realm","Realms",
         "SipMethod","SipCodec","SipRPID","UserAgent",
         "application","sip_status","sip_status_class","gateway",
         "duration","action","MONTHYEAR",
         "order_by","order_type","group_by",
         "cdr_source","trace",
         "ReNormalize","media_info","cdr_table","maxrowsperpage", "flow"
     );
 
     public function LoadDisconnectCodes()
     {
         $query = "select * from sip_status order by code";
         $this->disconnectCodesElements[] = array("label"=>"Any Status","value"=>"");
         $this->disconnectCodesElements[] = array("label"=>"Undefined (0)","value"=>"0");
         $this->disconnectCodesClassElements[] = array("label"=>"Any Status Class","value"=>"");
         $seen = array();
         if ($this->cdrtool->query($query)) {
             while ($this->cdrtool->next_record()) {
                 $key         = $this->cdrtool->f('code');
                 $value       = $this->cdrtool->f('description');
                 $value_print = $this->cdrtool->f('description')." (".$this->cdrtool->f('code').")";
 
                 if (preg_match("/^[^2-6]/", $key)) {
                     continue;
                 }
                 $this->disconnectCodesElements[] = array("label"=>$value_print,"value"=>$key);
                 $this->disconnectCodesDescription[$key] = $value;
 
                 $class = substr($key, 0, 1);
                 $class_text = substr($key, 0, 1)."XX (".$this->cdrtool->f('code_type').")";
                 if (!in_array($class, $seen)) {
                     $this->disconnectCodesClassElements[] = array("label"=>$class_text,"value"=>substr($key, 0, 1));
                     $this->disconnectCodesClassDescription[substr($key, 0, 1)] = $class_text;
                     $seen[] = $class;
                 }
                 $i++;
             }
         }
     }
 
     function showTableHeader()
     {
         print "
         <table class='table table-hover table-condensed'>
             <thead>
                 <tr>
                     <th>Id</th>
                     <th>Start Time</th>
                     <th>Media/Flow</th>
                     <th>SIP Caller</th>
                     <th>Caller Location</th>
                     <th>Sip Proxy</th>
                     <th>Media Proxy</th>
                     <th>SIP Destination</th>
                     <th>Dur</th>
                     <th>Price</th>
                     <th>KBIn</th>
                     <th>KBOut</th>
                     <th class='pull-right'>Status</th>
                 </tr>
             </thead>
         ";
     }
 
     function showExportHeader()
     {
         global $perm;
 
         $fields = array(
             "id",
             "StartTime",
             "StopTime",
             "BillingParty",
             "BillingDomain",
             "CallerParty",
             "CalledParty",
             "DestinationId",
             "DestinationName",
             "RemoteAddress",
             "CanonicalURI",
             "Duration",
             "Price",
             "SIPProxy",
             "Caller KBIn",
             "Called KBIn",
             "CallingUserAgent",
             "CalledUserAgent",
             "StatusCode",
             "StatusName",
             "Codec",
             "MediaProxy",
             "TLSCN"
             );
 
         if ($perm->have_perm("showCallerId")) {
             array_push($fields, 'PAssertedIdentity');
         }
         printf("%s\n", implode(',', $fields));
     }
 
     function showTableHeaderSubscriber()
     {
         if (!$this->export) {
             print  "
             <table class='table table-striped table-condensed'>
                 <thead>
                     <tr>
                         <th>Id</th>
                         <th>Start Time</th>
                         <th>SIP Caller</th>
                         <th>Caller Location</th>
                         <th>Sip Proxy</th>
                         <th>SIP Destination</th>
                         <th>Duration</th>
                         <th>Price</th>
                         <th>KBIn</th>
                         <th>KBOut</th>
                     </tr>
                 </thead>
             ";
         } else {
             print "id,StartTime,StopTime,SIPBillingParty,SIPBillingDomain,CallerParty,CalledParty,DestinationId,DestinationName,RemoteAddress,CanonicalURI,Duration,Price,SIPProxy,Applications,Caller KBIn,Called KBIn,CallingUserAgent,CalledUserAgent,StatusCode,StatusName,Codec,Application\n";
         }
     }
 
     function showTableHeaderStatistics()
     {
         $group_byPrint = $this->GROUPBY[$this->group_byOrig];
 
         if (!$this->export) {
             print "
             <table class='table table-striped table-condensed'>
                 <thead>
                     <tr>
                         <th></th>
                         <th>Calls</th>
                         <th>Seconds</th>
                         <th>Minutes</th>
                         <th>Hours</th>
                         <th>Price</th>
                         <th>TrafficIn(MB)</th>
                         <th>TrafficOut(MB)</th>
                         <th colspan=2>Success</th>
                         <th colspan=2>Failure</th>
                         <th>$group_byPrint</th>
                         <th>Description</th>
                         <th>Action</th>
                     </tr>
                 </thead>
             ";
         } else {
             print "id,Calls,Seconds,Minutes,Hours,Price,TrafficIn(MB),TrafficOut(MB),Success(%),Success(calls),Failure(%),Failure(calls),$group_byPrint,Description\n";
         }
     }
 
 
     function initForm()
     {
         // form els added below must have global vars
         foreach ($this->FormElements as $_el) {
             global ${$_el};
             ${$_el} = trim($_REQUEST[$_el]);
         }
 
         $action = "search";
 
         if ($this->CDRTool['filter']['gateway']) {
             $gateway = $this->CDRTool["filter"]["gateway"];
         }
 
         if ($this->CDRTool['filter']['aNumber']) {
             $UserName = $this->CDRTool['filter']['aNumber'];
         }
 
         if ($this->CDRTool['filter']['domain']) {
             $Realm  = $this->CDRTool['filter']['domain'];
         }
 
         if (!$maxrowsperpage) {
             $maxrowsperpage = 15;
         }
 
         $this->f = new form;
 
         if (isset($this->CDRTool['dataSourcesAllowed'])) {
             foreach ($this->CDRTool['dataSourcesAllowed'] as $k => $v) {
                 if ($this->DATASOURCES[$v]['invisible']) continue;
                 $cdr_source_els[]=array("label"=>$this->DATASOURCES[$v]['name'],"value"=>$v);
             }
         }
 
         if (!$cdr_source) {
             $cdr_source=$cdr_source_els[0]['value'];
         }
 
         $this->f->add_element(
             array(
                 "name"=>"cdr_source",
                 "type"=>"select",
                 "options"=>$cdr_source_els,
                 "size"=>"1",
                 "extrahtml"=>"class=span2 onChange=\"document.datasource.submit.disabled = true; location.href = 'callsearch.phtml?cdr_source=' + this.options[this.selectedIndex].value\"",
                 "value"=>"$cdr_source"
             )
         );
 
         $cdr_table_els = array();
         foreach ($this->tables as $_table) {
             if (preg_match("/^.*(\d{6})$/", $_table, $m)) {
                 $cdr_table_els[]=array("label"=>$m[1],"value"=>$_table);
             } else {
                 $cdr_table_els[]=array("label"=>$_table,"value"=>$_table);
             }
         }
 
         $this->f->add_element(
             array(
                 "name"=>"cdr_table",
                 "type"=>"select",
                 "options"=>$cdr_table_els,
                 "size"=>"1",
                 "class"=>"span2",
                 "value"=>$cdr_table,
                 "extrahtml"=>"class=span2"
             )
         );
 
         if ($begin_datetime) {
             preg_match("/^(\d\d\d\d)-(\d+)-(\d+)\s+(\d\d):(\d\d)/", "$begin_datetime", $parts);
             $begin_year    = date("Y", $begin_datetime);
             $begin_month   = date("m", $begin_datetime);
             $begin_day     = date("d", $begin_datetime);
             $begin_hour    = date("H", $begin_datetime);
             $begin_min     = date("i", $begin_datetime);
         } else {
             $begin_day      = $_REQUEST["begin_day"];
             $begin_month    = $_REQUEST["begin_month"];
             $begin_year     = $_REQUEST["begin_year"];
             $begin_hour     = $_REQUEST["begin_hour"];
             $begin_min      = $_REQUEST["begin_min"];
             list($begin_hour, $begin_min)=explode(":", $begin_time);
             list($begin_year, $begin_month, $begin_day)=explode("-", $begin_date);
         }
 
         if ($end_datetime) {
             preg_match("/^(\d\d\d\d)-(\d+)-(\d+)\s+(\d\d):(\d\d)/", "$end_datetime", $parts);
             $end_year    = date("Y", $end_datetime);
             $end_month   = date("m", $end_datetime);
             $end_day     = date("d", $end_datetime);
             $end_hour    = date("H", $end_datetime);
             $end_min     = date("i", $end_datetime);
         } else {
             $end_day        = $_REQUEST["end_day"];
             $end_month      = $_REQUEST["end_month"];
             $end_year       = $_REQUEST["end_year"];
             $end_hour       = $_REQUEST["end_hour"];
             $end_min        = $_REQUEST["end_min"];
             list($end_hour, $end_min)=explode(":", $end_time);
             list($end_year, $end_month, $end_day)=explode("-", $end_date);
         }
 
         // corect last day of the month to be valid day
         $begin_day = validDay($begin_month, $begin_day, $begin_year);
         $end_day   = validDay($end_month, $end_day, $end_year);
 
         $default_year  = Date("Y");
         $default_month = Date("m");
         $default_day   = Date("d");
         $default_hour  = Date("H", time());
 
         if ($default_hour > 1) {
             $default_hour=$default_hour-1;
         }
 
         $default_hour = preg_replace("/^(\d)$/", "0$1", $default_hour);
         $default_min  = Date("i");
 
         if ($default_min > 10) {
             $default_min = $default_min-10;
             $default_min = preg_replace("/^(\d)$/", "0$1", $default_min);
         }
 
         if (!$begin_hour)  $begin_hour  = $default_hour;
         if (!$begin_min)   $begin_min   = $default_min;
         if (!$begin_day)   $begin_day   = $default_day;
         if (!$begin_month) $begin_month = $default_month;
         if (!$begin_year)  $begin_year  = $default_year;
 
         if (!$end_hour)  $end_hour  = 23;
         if (!$end_min)   $end_min   = 55;
         if (!$end_day)   $end_day   = $default_day;
         if (!$end_month) $end_month = $default_month;
         if (!$end_year)  $end_year  = $default_year;
 
         $this->f->add_element(
             array(
                 "name"=>"begin_time",
                 "size"=>"1",
                 "type"=>"text",
                 "extrahtml"=>"id='timepicker1' class=\"input-small\" data-show-meridian='false' data-minute-step='1' data-default-time='$begin_hour:$begin_min'"
             )
         );
         $this->f->add_element(
             array(
                 "name"=>"end_time",
                 "size"=>"1",
                 "type"=>"text",
                 "extrahtml"=>"id='timepicker2' class=\"input-small\" data-show-meridian='false' data-minute-step='1' data-default-time='$end_hour:$end_min'"
             )
         );
         $this->f->add_element(
             array(
                 "name"=>"call_id",
                 "type"=>"text",
                 "size"=>"50",
                 "maxlength"=>"100",
                 "extrahtml"=>"class=span4"
             )
         );
 
         $this->f->add_element(
             array(
                 "name"=>"UserName",
                 "type"=>"text",
                 "size"=>"25",
                 "maxlength"=>"255",
                 "extrahtml"=>"class=span2"
             )
         );
 
         $this->f->add_element(
             array(
                 "name"=>"a_number",
                 "type"=>"text",
                 "size"=>"25",
                 "maxlength"=>"255",
                 "extrahtml"=>"class=span2"
             )
         );
         $this->f->add_element(
             array(
                 "name"=>"BillingId",
                 "type"=>"text",
                 "size"=>"25",
                 "maxlength"=>"255",
                 "extra_html"=>"class=span2"
             )
         );
         $this->f->add_element(
             array(
                 "name"=>"c_number",
                 "type"=>"text",
                 "size"=>"25",
                 "maxlength"=>"255",
                 "extrahtml"=>"class=span2"
             )
         );
         $this->f->add_element(
             array(
                 "name"      => "sip_status",
                 "type"      => "select",
                 "options"   => $this->disconnectCodesElements,
                 "size"      => "1",
                 "value"     => $sip_status,
                 "extrahtml" => "class=span3"
             )
         );
         $this->f->add_element(
             array(
                 "name"      => "sip_status_class",
                 "type"      => "select",
                 "options"   => $this->disconnectCodesClassElements,
                 "size"      => "1",
                 "extrahtml" => "class=span3"
             )
         );
 
         if (!$this->CDRTool['filter']['aNumber']) {
             $durations_els = array(
                 array("label"=>"All calls","value"=>""),
                 array("label"=>"0 seconds","value"=>"zero"),
                 array("label"=>"non 0 seconds","value"=>"nonzero"),
                 array("label"=>"non 0 seconds without price","value"=>"zeroprice"),
                 array("label"=>"less than 5 seconds","value"=>"< 5"),
                 array("label"=>"more than 5 seconds","value"=>"> 5"),
                 array("label"=>"less than 60 seconds","value"=>"< 60"),
                 array("label"=>"more than 2 minutes","value"=>"> 120"),
                 array("label"=>"greater than 1 hour","value"=>"> 3600"),
                 array("label"=>"one hour","value"=>"onehour"),
                 array("label"=>"greater than 5 hours","value"=>"> 18000"),
                 array("label"=>"Un-normalized calls","value"=>"unnormalized"),
                 array("label"=>"Un-normalized calls > 0s","value"=>"unnormalized_duration"),
                 array("label"=>"One way media","value"=>"onewaymedia"),
                 array("label"=>"No media","value"=>"nomedia")
             );
         } else {
             $durations_els = array(
                 array("label"=>"All calls","value"=>""),
                 array("label"=>"0 seconds call","value"=>"zero"),
                 array("label"=>"Succesfull calls","value"=>"nonzero"),
                 array("label"=>"less than 60 seconds","value"=>"< 60"),
                 array("label"=>"greater than 1 hour","value"=>"> 3600")
                 );
             $this->GROUPBY = array(
                 'UserName'             => 'SIP Billing Party',
                 'CallingStationId'     => 'SIP Caller Party',
                 'DestinationId'        => 'SIP Destination Id',
                 'SipApplicationType'   => 'Application',
                 ' '                => '-------------',
                 'hour'                 => 'Hour of day',
                 'DAYOFWEEK'            => 'Day of Week',
                 'DAYOFMONTH'           => 'Day of Month',
                 'DAYOFYEAR'            => 'Day of Year',
                 'BYMONTH'              => 'Month',
                 'BYYEAR'               => 'Year'
             );
         }
 
         $flow_els = array(
                 array("label"=>"Any Call Flow","value"=>""),
                 array("label"=>"On Net","value"=>"on-net"),
                 array("label"=>"Incoming","value"=>"incoming"),
                 array("label"=>"Outgoing","value"=>"outgoing"),
                 array("label"=>"Transit","value"=>"transit"),
                 array("label"=>"Diverted On Net","value"=>"diverted-on-net"),
                 array("label"=>"Diverted Off Net","value"=>"diverted-off-net"),
                 array("label"=>"On Net Diverted On Net","value"=>"on-net-diverted-on-net"),
                 array("label"=>"On Net Diverted Off Net","value"=>"on-net-diverted-off-net"),
                 array("label"=>"Unknown Flow","value"=>"Sip-Session")
                 );
 
         $this->f->add_element(array(    "name"=>"flow",
                                 "type"=>"select",
                                 "options"=>$flow_els,
                                 "value"=>"",
                                 "size"=>"1",
                                 "extrahtml"=>"class=span3"
                     ));
 
         $this->f->add_element(array(    "name"=>"duration",
                                 "type"=>"select",
                                 "options"=>$durations_els,
                                 "value"=>"All",
                                 "size"=>"1",
                                 "extrahtml"=>"class=span3"
                     ));
         $comp_ops_els = array(
                 array("label"=>"Begins with","value"=>"begin"),
                 array("label"=>"Contains","value"=>"contain"),
                 array("label"=>"Is empty","value"=>"empty"),
                 array("label"=>"Equal","value"=>"equal")
                 );
         $this->f->add_element(array(    "name"=>"a_number_comp",
                                 "type"=>"select",
                                 "options"=>$comp_ops_els,
                                 "value"=>"begin",
                                 "size"=>"1",
                                 "extrahtml"=>"class=span2"
                     ));
         $this->f->add_element(array(    "name"=>"c_number_comp",
                                 "type"=>"select",
                                 "options"=>$comp_ops_els,
                                 "value"=>"begin",
                                 "size"=>"1",
                                 "extrahtml"=>"class=span2"
                     ));
         $this->f->add_element(array(    "name"=>"UserName_comp",
                                 "type"=>"select",
                                 "options"=>$comp_ops_els,
                                 "value"=>"begin",
                                 "size"=>"1",
                                 "extrahtml"=>"class=span2"
                     ));
         $this->f->add_element(array(    "name"=>"Realm",
                                 "type"=>"text",
                                 "size"=>"25",
                                 "maxlength"=>"25",
                                 "extrahtml"=>"class=span2"
                     ));
 
         $media_info_els=array(
                 array("label"=>"","value"=>""),
                         array("label"=>"Timeout","value"=>"timeout"),
                         array("label"=>"ICE session","value"=>"ICE session")
                 );
 
         $this->f->add_element(array(    "name"=>"media_info",
                                 "type"=>"select",
                                 "options"=>$media_info_els,
                                 "size"=>"1",
                                 "value"=>"",
                                 "extrahtml"=>"class=span2"
                     ));
 
         $this->f->add_element(array("type"=>"submit",
                               "name"=>"submit",
                               "value"=>"Search","extrahtml"=>"class=btn"
                     ));
         $max_els = array(
                 array("label"=>"5","value"=>"5"),
                         array("label"=>"10","value"=>"10"),
                         array("label"=>"15","value"=>"15"),
                         array("label"=>"25","value"=>"25"),
                         array("label"=>"50","value"=>"50"),
                         array("label"=>"100","value"=>"100"),
                         array("label"=>"500","value"=>"500")
                 );
         $this->f->add_element(array(    "name"=>"maxrowsperpage",
                                 "type"=>"select",
                                 "options"=>$max_els,
                                 "size"=>"1",
                                 "value"=>"25",
                                 "extrahtml"=>"class = span2"
                     ));
         $order_type_els = array(
                         array("label"=>"Descending","value"=>"DESC"),
                         array("label"=>"Ascending","value"=>"ASC")
                         );
         $this->f->add_element(array(    "name"=>"order_type",
                                 "type"=>"select",
                                 "options"=>$order_type_els,
                                 "size"=>"1",
                                 "extrahtml"=>"class=span2"
                     ));
         $this->f->add_element(array("type"=>"hidden",
                               "name"=>"action",
                               "value"=>$action
                 ));
 
         $order_by_els = array(array("label"=>"Id","value"=>"RadAcctId"),
                             array("label"=>"Date","value"=>"AcctStopTime"),
                             array("label"=>"Billing Party","value"=>"UserName"),
                             array("label"=>"Remote Party Id","value"=>"SipRPID"),
                             array("label"=>"Caller Party","value"=>"CallingStationId"),
                             array("label"=>"Destination","value"=>"CalledStationId"),
                             array("label"=>"Duration","value"=>"AcctSessionTime"),
                             array("label"=>"Input traffic","value"=>"AcctInputOctets"),
                             array("label"=>"Output traffic","value"=>"AcctOutputOctets"),
                             array("label"=>"Price","value"=>"Price"),
                             array("label"=>"Failures(%)","value"=>"zeroP"),
                             array("label"=>"Success(%)","value"=>"nonzeroP"),
                             array("label"=>"Group by","value"=>"group_by")
         );
 
         $group_by_els[] = array("label"=>"", "value"=>"");
 
         global $perm;
 
         if (!$perm->have_perm("showCallerId")) {
             $order_by_els = array_filter(
                 $order_by_els,
                 function ($element) {
                     return $element['label'] != "Remote Party Id";
                 }
             );
             unset($this->GROUPBY['SipRPID']);
         }
 
         foreach ($this->GROUPBY as $k => $v) {
             $group_by_els[]=array("label"=>$v,"value"=>$k);
         }
 
         $this->f->add_element(
             array(
                 "name" => "order_by",
                 "type" => "select",
                 "options" => $order_by_els,
                 "value" => $order_by,
                 "size" => "1",
                 "extrahtml" => "class=span3"
             )
         );
 
         $this->f->add_element(
             array(
                 "name"=> "group_by",
                 "type" => "select",
                 "options" => $group_by_els,
                 "value" => $group_by,
                 "size" => "1",
                 "extrahtml" => "class=span3"
             )
         );
 
         $application_els = array(
             array(
                 "label" => "Any Application",
                 "value" => ""
             ),
             array(
                 "label" => "Audio",
                 "value" => "audio"
             ),
             array(
                 "label" => "Video",
                 "value"=>"video"
             ),
             array(
                 "label" => "Message",
                 "value" => "message"
             ),
             array(
                 "label" => "IM Chat" ,
                 "value" => "chat"
             ),
             array(
                 "label" => "Audio + Chat" ,
                 "value" => "audio=2C chat"
             ),
             array(
                 "label" => "File Transfer",
                 "value" => "file-transfer"
             )
         );
 
         $this->f->add_element(array("name"=>"application",
                                     "type"=>"select",
                                     "options"=>$application_els,
                                     "value"=>$application,
                                     "size"=>"1",
                                     "extrahtml"=>"class=span2"
                                 ));
         $this->f->add_element(array("name"=>"UserAgent",
                                     "type"=>"text",
                                     "size"=>"25",
                                     "maxlength"=>"50",
                                     "value"=>$UserAgent,
                                     "extrahtml"=>"class=span2"
                     ));
         $this->f->add_element(array("name"=>"SipCodec",
                                     "type"=>"text",
                                     "size"=>"10",
                                     "maxlength"=>"50",
                                     "value"=>$SipCodec,
                                     "extrahtml"=>"class=span2"
                     ));
         $this->f->add_element(
             array(
                 "name"=>"sip_proxy",
                 "type"=>"text",
                 "size"=>"25",
                 "maxlength"=>"255",
                 "value"=>$sip_proxy,
                 "extrahtml"=>"class=span2"
             )
         );
         $this->f->add_element(
             array(
                 "name"=>"media_proxy",
                 "type"=>"text",
                 "size"=>"25",
                 "maxlength"=>"255",
                 "value"=>$media_proxy,
                 "extrahtml"=>"class=span2"
             )
         );
         $this->f->add_element(
             array(
                 "name"=>"tlscn",
                 "type"=>"text",
                 "size"=>"25",
                 "maxlength"=>"255",
                 "value"=>$tlscn,
                 "extrahtml"=>"class=span2"
             )
         );
         $this->f->add_element(
             array(
                 "name"=>"gateway",
                 "type"=>"text",
                 "size"=>"25",
                 "maxlength"=>"255",
                 "value"=>$gateway,
                 "extrahtml"=>"class=span2"
             )
         );
         $this->f->add_element(
             array(
                 "name"=>"DestinationId",
                 "type"=>"text",
                 "size"=>"10",
                 "extrahtml"=>"class=span3"
             )
         );
         $this->f->add_element(
             array(
                 "name"=>"ExcludeDestinations",
                 "type"=>"text",
                 "size"=>"20",
                 "maxlength"=>"255",
                 "extrahtml"=>"class=span3"
             )
         );
         $this->f->load_defaults();
         $this->f->add_element(
             array(
                 "name"=>"begin_date",
                 "size"=>"10",
                 "maxlength"=>"10",
                 "type"=>"text",
                 "value" => "$begin_year-$begin_month-$begin_day",
                 "extrahtml"=>"id='begin_date' data-date-format=\"yyyy-mm-dd\" class=\"span2\""
             )
         );
         $this->f->add_element(array(
                     "name"=>"end_date",
                     "size"=>"1",
                     "type"=>"text",
                     "value"=>"$end_year-$end_month-$end_day",
                     "extrahtml"=>"id='end_date' data-date-format=\"yyyy-mm-dd\" class=\"span2\""
                     ));
     }
 
     public function searchForm()
     {
         global $perm;
 
         $this->initForm();
         $this->f->start("", "POST", "", "", "datasource");
 
         print "<table id='search' class='table table-bordered table-condensed' cellpadding=5 width=100% align=center>";
 
         $this->showDataSources($this->f);
         $this->showDateTimeElements($this->f);
         $ff = array();
         // freeze some form els
         if ($this->CDRTool['filter']['aNumber']) {
             $ff[]="a_number";
             $ff[]="a_number_comp";
             $ff[]="UserName";
             $ff[]="UserName_comp";
         }
 
         if ($this->CDRTool['filter']['domain']) {
             $Realm=$this->CDRTool['filter']['domain'];
             $ff[]="Realm";
         }
 
         if ($this->CDRTool['filter']['gateway']) {
             $gateway=$this->CDRTool['filter']['gateway'];
             $ff[]="gateway";
         }
 
         if (count($ff)) {
             $this->f->freeze($ff);
         }
 
         print "
         <tr>
             <td align=left>
             <b>SIP Call Id / Source IP</b>
             </td>
             <td>
             <div class=\"input-prepend\">
             <div class=\"input-append\">";
         $this->f->show_element("call_id", "");
         print "<span class=\"add-on\">/</span></div>";
         $this->f->show_element("gateway", "");
         print "</div>
             Sip Proxy ";
 
         $this->f->show_element("sip_proxy", "");
         print "
             </td>
         </tr>
         <tr>
         </tr>
         ";
 
         print "
         <tr>
             <td align=left>
             <b>User Agent / Media Codecs</b>
             </td>
             <td >
             ";
         $this->f->show_element("UserAgent", "");
         print " Codec: ";
         $this->f->show_element("SipCodec", "");
         print " Media Proxy:";
         $this->f->show_element("media_proxy", "");
         print "
             </td>
             </tr>
         <tr>
         </tr>
         ";
 
         print "
         <tr>
             <td align=left>
             <b>SIP Billing Party (Username)</b>
             </td>
             <td>
             ";
         $this->f->show_element("UserName_comp", "");
         print "
                 <div class=\"input-prepend\">
                 <div class=\"input-append\">
             ";
         $this->f->show_element("UserName", "");
         print "<span class=\"add-on\">@</span></div>";
         $this->f->show_element("Realm", "");
         print "</div> Tech prefix: ";
         $this->f->show_element("BillingId", "");
         print "</div>
             </td>
         </tr>
         <tr>
         </tr>
         ";
 
         print "
         <tr>
             <td align=left>
             <b>
             SIP Caller Party (From URI)
             </b>
             </td>
             <td valign=top>
             ";
         $this->f->show_element("a_number_comp", "");
         print "&nbsp;";
         $this->f->show_element("a_number");
         print "&nbsp; TLS CN:";
         $this->f->show_element("tlscn");
         print "
             </td>
         </tr>
         <tr>
         </tr>
         ";
 
         print "
         <tr>
             <td align=left>
             <b>SIP Destination (Canonical URI)
             </b>
             </td>
             <td valign=top>   ";
         $this->f->show_element("c_number_comp", "");
         print "&nbsp;";
 
         $this->f->show_element("c_number", "");
         print " Exclude: ";
         $this->f->show_element("ExcludeDestinations_comp");
         $this->f->show_element("ExcludeDestinations", "");
         print "
             </td>
         </tr>
         <tr>
         </tr>
         ";
 
         print "
         <tr>
             <td align=left><b>Application / Call Flow</b></td>
             <td valign=top>   ";
         $this->f->show_element("flow", "");
         print "&nbsp;";
         $this->f->show_element("application", "");
         print " Media Info: ";
         $this->f->show_element("media_info", "");
         print "
             </td>
         </tr>
         ";
 
         print "
         <tr>
             <td align=left><b>Duration / Status</b></td>
             <td valign=top>   ";
         $this->f->show_element("duration", "");
         print "&nbsp;";
         $this->f->show_element("sip_status", "");
         print "&nbsp;";
         $this->f->show_element("sip_status_class", "");
         print "
             </td>
         </tr>
         ";
         print "
         <tr>
             <td align=left>
             <b>Order by / Group by</b>
             </td>
             <td valign=top>
              ";
         $this->f->show_element("order_by", "");
         print "&nbsp;";
         $this->f->show_element("order_type", "");
 
         if ($perm->have_perm("statistics")) {
             print " Group by ";
             $this->f->show_element("group_by", "");
         }
 
         print " Max results per page ";
         $this->f->show_element("maxrowsperpage", "");
 
         print "</nobr>&nbsp";
 
         if (!$perm->have_perm('readonly')) {
             print ";&nbsp;&nbsp; <nobr>ReNormalize ";
             print "<input type=checkbox name=ReNormalize value=1>
                 ";
         }
 
         print "
             </td>
         </tr>
         ";
 
         print "
         </table>
         <p>
         <center>
         ";
 
         $this->f->show_element("submit", "");
         $this->f->finish();
 
         print "
         </center>
         ";
     }
 
     function searchFormSubscriber()
     {
         global $perm;
 
         $this->initForm();
         $this->f->start("", "POST", "", "", "datasource");
 
         print "
         <table id='search' class='table table-bordered table-condensed' cellpadding=5 width=100% align=center>
         ";
         $this->showDataSources($this->f);
         $this->showDateTimeElements($this->f);
 
         // freeze some form els
         if ($this->CDRTool['filter']['aNumber']) {
             $ff[]="UserName";
         }
 
         if ($this->CDRTool['filter']['domain']) {
             $ff[]="Realm";
         }
 
         if ($this->CDRTool["filter"]["gateway"]) {
             $ff[]="gateway";
         }
 
         if (count($ff)) {
             $this->f->freeze($ff);
         }
 
         print "
         <tr>
             <td align=left>
             <b>
             SIP Caller Party
             </b>
             </td>
             <td valign=top>
             ";
         $this->f->show_element("a_number", "");
         print "
             </td>
         </tr>
         <tr>
         </tr>
         ";
 
         print "
         <tr>
             <td align=left>
             <b>
             SIP Billing Party
             </b>
             </td>
             <td valign=top>
             ";
         $this->f->show_element("UserName", "");
         print "
             </td>
         </tr>
         <tr>
         </tr>
         ";
 
         print "
         <tr>
             <td align=left>
             <b>
             SIP Destination
             </b>
             </td>
             <td valign=top>   ";
         $this->f->show_element("c_number_comp", "");
         $this->f->show_element("c_number", "");
             //$this->f->show_element("DestinationId","");
         print "
             </td>
         </tr>
         <tr>
         </tr>
         ";
 
         print "
         <tr>
             <td align=left>
             <b>SIP Session duration</b>
             </td>
             <td valign=top>   ";
         $this->f->show_element("duration", "");
         print " Application ";
         $this->f->show_element("application", "");
         print "
             </td>
         </tr>
         ";
         print "
         <tr>
             <td align=left>
             <b>Order by</b>
             </td>
             <td valign=top>
              ";
         $this->f->show_element("order_by", "");
         $this->f->show_element("order_type", "");
 
         if ($perm->have_perm("statistics")) {
             print " Group by ";
             $this->f->show_element("group_by", "");
         }
 
         print " Max results per page ";
         $this->f->show_element("maxrowsperpage", "");
         print "
              </td>
         </tr>
         ";
 
         print "
         </table>
         <p>
         <center>
         ";
 
         $this->f->show_element("submit", "");
         $this->f->finish();
 
         print "
         </center>
         ";
     }
 
     function show()
     {
         global $perm;
 
         if (!is_object($this->CDRdb)) {
             $log = sprintf("Error: CDR database is not initalized");
             print $log;
             return false;
         }
 
         foreach ($this->FormElements as $_el) {
             ${$_el} = trim($_REQUEST[$_el]);
         }
 
         if ($begin_time) {
             list($begin_hour, $begin_min)=explode(":", $begin_time);
         }
 
         if ($end_time) {
             list($end_hour, $end_min)=explode(":", $end_time);
         }
 
         if ($begin_date) {
             list($begin_year, $begin_month, $begin_day)=explode("-", $begin_date);
         }
 
         if ($end_date) {
             list($end_year, $end_month, $end_day)=explode("-", $end_date);
         }
         // overwrite some elements based on user rights
         if ($this->CDRTool['filter']['gateway']) {
             $gateway =$this->CDRTool['filter']['gateway'];
         }
 
         if (!$this->export) {
             if (!$begin_datetime) {
                 $begin_datetime="$begin_year-$begin_month-$begin_day $begin_hour:$begin_min";
                 $begin_datetime_timestamp = mktime($begin_hour, $begin_min, 0, $begin_month, $begin_day, $begin_year);
             } else {
                 $begin_datetime_timestamp=$begin_datetime;
                 $begin_datetime = Date("Y-m-d H:i", $begin_datetime);
             }
 
             if (!$end_datetime) {
                 $end_datetime_timestamp = mktime($end_hour, $end_min, 0, $end_month, $end_day, $end_year);
                 $end_datetime="$end_year-$end_month-$end_day $end_hour:$end_min";
             } else {
                 $end_datetime_timestamp=$end_datetime;
                 $end_datetime = Date("Y-m-d H:i", $end_datetime);
             }
         } else {
             $begin_datetime = Date("Y-m-d H:i", $begin_datetime);
             $end_datetime = Date("Y-m-d H:i", $end_datetime);
         }
 
         if (!$order_by || (!$group_by && $order_by == "group_by")) {
             $order_by=$this->idField;
         }
 
         if (!$cdr_table) {
             $cdr_table=$this->table;
         }
 
         $this->url = sprintf("?cdr_source=%s&cdr_table=%s", $this->cdr_source, $cdr_table);
 
         if ($this->CDRTool['filter']['domain']) {
             $this->url  .= sprintf("&Realms=%s", urlencode($this->CDRTool['filter']['domain']));
             $Realms      = explode(" ", $this->CDRTool['filter']['domain']);
         } elseif ($Realms) {
             $this->url   .= sprintf("&Realms=%s", urlencode($Realms));
             $Realms      = explode(" ", $Realms);
         }
 
         if ($this->CDRTool['filter']['aNumber']) {
             $this->url   .= sprintf("&UserName=%s", urlencode($this->CDRTool['filter']['aNumber']));
         }
 
         if ($this->CDRTool['filter']['after_date']) {
             $where .= sprintf(" and %s >= '%s' ", addslashes($this->startTimeField), addslashes($this->CDRTool['filter']['after_date']));
         }
 
         if ($order_by) {
             $this->url.=sprintf("&order_by=%s&order_type=%s", addslashes($order_by), addslashes($order_type));
         }
 
         $this->url.=sprintf("&begin_datetime=%s", urlencode($begin_datetime_timestamp));
         $this->url.=sprintf("&end_datetime=%s", urlencode($end_datetime_timestamp));
 
         if (!$call_id && $begin_datetime && $end_datetime) {
             $where .= sprintf(
                 " (%s >= '%s' and %s < '%s') ",
                 addslashes($this->startTimeField),
                 addslashes($begin_datetime),
                 addslashes($this->startTimeField),
                 addslashes($end_datetime)
             );
         } else {
             $where .= sprintf(" (%s >= '1970-01-01' ) ", addslashes($this->startTimeField));
         }
 
         if ($MONTHYEAR) {
             $where .=  sprintf(" and %s like '%s%s' ", addslashes($this->startTimeField), addslashes($MONTHYEAR), '%');
             $this->url.= sprintf("&MONTHYEAR=%s", urlencode($MONTHYEAR));
         }
 
         if ($flow) {
             $this->url.=sprintf("&flow=%s", urlencode($flow));
             $where .=  sprintf(" and %s = '%s' ", addslashes($this->flowField), addslashes($flow));
         }
 
         if ($this->CDRTool['filter']['aNumber']) {
             // force user to see only CDRS with his a_numbers
             $where .= sprintf(
                 " and ( %s = '%s' or %s = '%s') ",
                 addslashes($this->usernameField),
                 addslashes($this->CDRTool['filter']['aNumber']),
                 addslashes($this->CanonicalURIField),
                 addslashes($this->CDRTool['filter']['aNumber'])
             );
             $UserName_comp='equal';
             $UserName=$this->CDRTool['filter']['aNumber'];
         }
 
         if ($UserName_comp == "empty") {
             $where .= sprintf(" and %s = ''", addslashes($this->usernameField));
             $this->url.=sprintf("&UserName_comp=%s", urlencode($UserName_comp));
         } elseif (strlen($UserName) && !$this->CDRTool['filter']['aNumber']) {
             if (!$UserName_comp) {
                 $UserName_comp='begin';
             }
 
             if ($UserName_comp=="begin") {
                 $where .= sprintf(" and %s like '%s%s'", addslashes($this->usernameField), addslashes($UserName), '%');
             } elseif ($UserName_comp=="contain") {
                 $where .= sprintf(" and %s like '%s%s%s'", addslashes($this->usernameField), '%', addslashes($UserName), '%');
             } elseif ($UserName_comp=="equal") {
                 $where .= sprintf(" and %s = '%s'", addslashes($this->usernameField), addslashes($UserName));
             } else {
                 $where .= sprintf(" and %s = ''", addslashes($this->usernameField));
             }
 
             $this->url.= sprintf("&UserName=%s&UserName_comp=%s", urlencode($UserName), $UserName_comp);
         }
 
         $a_number = trim($a_number);
         if ($a_number_comp == "empty") {
             $where .= sprintf(" and %s = ''", addslashes($this->aNumberField));
             $this->url.=sprintf("&a_number_comp=%s", urlencode($a_number_comp));
         } elseif (strlen($a_number)) {
             $a_number = urldecode($a_number);
             if (!$a_number_comp) {
                 $a_number_comp = "equal";
             }
 
             $this->url.=sprintf("&a_number=%s", urlencode($a_number));
 
             if ($a_number_comp=="begin") {
                 $where .= sprintf(" and %s like '%s%s'", addslashes($this->aNumberField), addslashes($a_number), '%');
             } elseif ($a_number_comp=="contain") {
                 $where .= sprintf(" and %s like '%s%s%s'", addslashes($this->aNumberField), '%', addslashes($a_number), '%');
             } elseif ($a_number_comp=="equal") {
                 $where .= sprintf(" and %s = '%s'", addslashes($this->aNumberField), addslashes($a_number));
             }
 
             $this->url.=sprintf("&a_number_comp=%s", urlencode($a_number_comp));
         }
 
         $c_number = trim($c_number);
         if ($c_number_comp == "empty") {
             $where .= sprintf(" and %s = ''", addslashes($this->CanonicalURIField));
             $this->url.=sprintf("&c_number_comp=%s", urlencode($c_number_comp));
         } elseif (strlen($c_number)) {
             $c_number = urldecode($c_number);
             if (!$c_number_comp) {
                 $c_number_comp = "begin";
             }
 
             if (!$c_number_comp || $c_number_comp == "begin") {
                 $where .= sprintf(" and %s like '%s%s'", addslashes($this->CanonicalURIField), addslashes($c_number), '%');
             } elseif ($c_number_comp=="contain") {
                 $where .= sprintf(" and %s like '%s%s%s'", addslashes($this->CanonicalURIField), '%', addslashes($c_number), '%');
             } elseif ($c_number_comp=="equal") {
                 $where .= sprintf(" and %s = '%s'", addslashes($this->CanonicalURIField), addslashes($c_number));
             }
             $this->url.=sprintf("&c_number=%s&c_number_comp=%s", urlencode($c_number), urlencode($c_number_comp));
         }
 
         $Realm = trim($Realm);
 
         if ($Realms) {
             $where .= sprintf(" and (");
             $count_realms = count($Realms);
             $j = 1;
             foreach ($Realms as $realm) {
                 $where .= sprintf(" ( %s like '%%%s' or %s like '%%%s' ) ", $this->domainField, addslashes($realm), $this->CanonicalURIField, addslashes($realm));
 
                 if ($j < $count_realms) {
                     $where .= " or ";
                 }
                 $j = $j + 1;
             }
             $where .= ") ";
         } elseif ($Realm) {
             $Realm = urldecode($Realm);
             $where .= sprintf(" and %s like '%s' ", $this->domainField, addslashes($Realm));
             $this->url.=sprintf("&Realm=%s", urlencode($Realm));
         }
 
         $BillingId = trim($BillingId);
         if (preg_match("/^\d+$/", $BillingId) && $this->BillingIdField) {
             $where .= " and $this->BillingIdField = '".addslashes($BillingId)."'";
             $this->url.=sprintf("&BillingId=%s", urlencode($BillingId));
         }
 
         if ($application) {
             $where .= " and $this->applicationField like '%".addslashes($application)."%'";
             $this->url.=sprintf("&application=%s", urlencode($application));
         }
 
         if ($DestinationId) {
             if ($DestinationId=="empty") {
                 $DestinationIdSQL = "";
             } else {
                 $DestinationIdSQL = $DestinationId;
             }
             $where .= " and $this->DestinationIdField = '".addslashes($DestinationIdSQL)."'";
             $this->url.=sprintf("&DestinationId=%s", urlencode($DestinationId));
         }
 
         if (strlen(trim($ExcludeDestinations))) {
             $ExcludeDestArray = explode(" ", trim($ExcludeDestinations));
 
             foreach ($ExcludeDestArray as $exclDst) {
                 if (preg_match("/^0+(\d+)$/", $exclDst, $m)) {
                     $exclDest_id = $m[1];
                 } else {
                     $exclDest_id = $exclDst;
                 }
 
                 $where .= " and ".
                 $this->CanonicalURIField.
                 " not like '".
                 addslashes(trim($exclDst)).
                 "'";
             }
 
             $this->url .= sprintf("&ExcludeDestinations=%s", urlencode($ExcludeDestinations));
         }
 
         $call_id = trim($call_id);
 
         if ($call_id) {
             $call_id = urldecode($call_id);
             $where .= " and $this->callIdField = '".addslashes($call_id)."'";
             $this->url.=sprintf("&call_id=%s", urlencode($call_id));
         }
 
         if ($sip_proxy) {
             $sip_proxy = urldecode($sip_proxy);
             $where .= " and $this->SipProxyServerField = '".addslashes($sip_proxy)."'";
             $this->url.=sprintf("&sip_proxy=%s", urlencode($sip_proxy));
         }
 
         if ($media_proxy) {
             $media_proxy = urldecode($media_proxy);
             $where .= " and $this->MediaProxyField = '".addslashes($media_proxy)."'";
             $this->url.=sprintf("&media_proxy=%s", urlencode($media_proxy));
         }
 
         if ($tlscn) {
             $tlscn = urldecode($tlscn);
             $where .= " and $this->tlscnField = '".addslashes($tlscn)."'";
             $this->url.=sprintf("&tlscn=%s", urlencode($tlscn));
         }
 
         if ($SipCodec) {
             $this->url.=sprintf("&SipCodec=%s", urlencode($SipCodec));
             if ($SipCodec != "empty") {
                 $where .= " and $this->SipCodecField = '".addslashes($SipCodec)."'";
             } else {
                 $where .= " and $this->SipCodecField = ''";
             }
         }
 
         if ($SipRPID) {
             $this->url.=sprintf("&SipRPID=%s", urlencode($SipRPID));
             if ($SipRPID != "empty") {
                 $where .= " and $this->SipRPIDField = '".addslashes($SipRPID)."'";
             } else {
                 $where .= " and $this->SipRPIDField = ''";
             }
         }
 
         if ($UserAgent) {
             $where .= " and $this->UserAgentField like '%".addslashes($UserAgent)."%'";
             $this->url.=sprintf("&UserAgent=%s", urlencode($UserAgent));
         }
 
         if (strlen($sip_status)) {
             $where .= " and $this->disconnectField ='".addslashes($sip_status)."'";
             $this->url.=sprintf("&sip_status=%s", urlencode($sip_status));
         }
 
         if ($sip_status_class) {
             $where .= " and $this->disconnectField like '$sip_status_class%'";
             $this->url.=sprintf("&sip_status_class=%s", urlencode($sip_status_class));
         }
 
         if ($this->CDRTool['filter']["gateway"]) {
             $gatewayFilter=$this->CDRTool[filter]["gateway"];
             $where .= " and $this->gatewayField = '".addslashes($gatewayFilter)."'";
         } elseif ($gateway) {
             $gateway = urldecode($gateway);
             $where .= " and $this->gatewayField = '".addslashes($gateway)."'";
             $this->url.=sprintf("&gateway=%s", urlencode($gateway));
         }
 
         if ($duration) {
             if (preg_match("/\d+/", $duration)) {
                 $where .= " and ($this->durationField > 0 and $this->durationField $duration) ";
             } elseif (preg_match("/onehour/", $duration)) {
                 $where .= " and ($this->durationField < 3610 and $this->durationField > 3530) ";
             } elseif ($duration == "zero") {
                 $where .= " and $this->durationField = 0";
             } elseif ($duration == "zeroprice" && $this->priceField) {
                 $where .= " and $this->durationField > 0 and ($this->priceField = '' or $this->priceField is NULL)";
             } elseif ($duration == "nonzero") {
                 $where .= " and $this->durationField > 0";
             } elseif ($duration == "onewaymedia") {
                 $where .= " and (($this->inputTrafficField > 0 && $this->outputTrafficField = 0) || ($this->inputTrafficField = 0 && $this->outputTrafficField > 0)) " ;
             } elseif ($duration == "nomedia") {
                 $where .= " and ($this->inputTrafficField = 0 && $this->outputTrafficField = 0) " ;
             }
             $this->url.=sprintf("&duration=%s", urlencode($duration));
         }
 
         if ($media_info) {
             $this->url.=sprintf("&media_info=%s", urlencode($media_info));
             $where .= sprintf(" and %s = '%s' ", addslashes($this->MediaInfoField), addslashes($media_info));
         }
 
         $this->url.=sprintf("&maxrowsperpage=%s", addslashes($this->maxrowsperpage));
         $url_calls = $this->scriptFile.$this->url."&action=search";
 
         if ($group_by) {
             $this->url.=sprintf("&group_by=%s", urlencode($group_by));
         }
 
         $this->url_edit   = $this->scriptFile.$this->url."&action=edit";
         $this->url_run    = $this->scriptFile.$this->url."&action=search";
         $this->url_export = $_SERVER["PHP_SELF"].$this->url."&action=search&export=1";
 
         if ($duration == "unnormalized") {
             $where .= " and $this->normalizedField = '0' ";
         }
 
         if ($duration == "unnormalized_duration") {
             $where .= " and $this->normalizedField = '0' and $this->durationField > 0 ";
         }
 
         if ($group_by) {
             $this->group_byOrig=$group_by;
 
             if ($group_by=="hour") {
                 $group_by="HOUR(AcctStartTime)";
             } elseif (preg_match("/^DAY/", $group_by)) {
                 $group_by="$group_by(AcctStartTime)";
             } elseif (preg_match("/BYMONTH/", $group_by)) {
                 $group_by="DATE_FORMAT(AcctStartTime,'%Y-%m')";
             } elseif (preg_match("/BYYEAR/", $group_by)) {
                 $group_by="DATE_FORMAT(AcctStartTime,'%Y')";
             } elseif ($group_by=="UserAgentType") {
                 $group_by="SUBSTRING_INDEX($this->SipUserAgentsField, ' ', '1')";
             }
 
             $this->group_by=$group_by;
 
             if ($group_by==$this->callIdField) {
                 $having = sprintf(" having count(%s) > 1 ", addslashes($group_by));
             }
 
             $query= sprintf(
                 "
                 select
                     sum(%s) as duration,
                     SEC_TO_TIME(sum(%s)) as duration_print,
                     count(%s) as calls,
                     %s
                 from
                     %s
                 where
                     %s
                 group by
                     %s %s
                 ",
                 addslashes($this->durationField),
                 addslashes($this->durationField),
                 $group_by,
                 $group_by,
                 addslashes($cdr_table),
                 $where,
                 $group_by,
                 $having
             );
         } else {
             $query = sprintf("select count(*) as records from %s where ", addslashes($cdr_table)). $where;
         }
 
         dprint_sql($query);
 
         if ($this->CDRdb->query($query)) {
             $this->CDRdb->next_record();
             if ($group_by) {
                 $rows = $this->CDRdb->num_rows();
             } else {
                 $rows = $this->CDRdb->f('records');
             }
         } else {
             printf("%s", $this->CDRdb->Error);
             $rows = 0;
         }
 
         $this->rows=$rows;
 
         if ($this->CDRTool['filter']['aNumber']) {
             $this->showResultsMenuSubscriber('0', $begin_datetime, $end_datetime);
         } else {
             $this->showResultsMenu('0', $begin_datetime, $end_datetime);
         }
 
         if (!$this->next) {
             $i=0;
             $this->next=0;
         } else {
             $i = intval($this->next);
         }
         $j=0;
         $z=0;
 
 
         if ($rows > 0) {
             if ($call_id && $ReNormalize) {
                 $query = sprintf(
                     "
                     update
                         %s
                     set
                         %s = '0'
                     where
                         %s = '%s'
                     ",
                     addslashes($cdr_table),
                     addslashes($this->normalizedField),
                     addslashes($this->callIdField),
                     addslashes($call_id)
                 );
 
                 $this->CDRdb->query($query);
             }
 
             if ($UnNormalizedCalls = $this->getUnNormalized($where, $cdr_table)) {
                 if (!$this->DATASOURCES[$this->cdr_source]['skipNormalizeOnPageLoad']) {
                     if ($UnNormalizedCalls < $this->maxCDRsNormalizeWeb) {
                         $this->NormalizeCDRS($where, $cdr_table);
                         if (!$this->export && $this->status['normalized']) {
                             print "<div class=\"alert alert-info\">";
                             print "<i class='icon-info-sign icon-large'></i>&nbsp;&nbsp;";
                             printf("<b><span class=\"alert-heading\">%d</span></b> CDRs normalized. ", $this->status['normalized']);
                             if ($this->status['cached_keys']['saved_keys']) {
                                 printf("Quota usage updated for <b><span class=\"alert-heading\">%d</span></b> accounts. ", $this->status['cached_keys']['saved_keys']);
                             }
                             print "</div>";
                         }
                     }
                 }
             }
 
             if ($rows > $this->maxrowsperpage) {
                 $maxrows = $this->maxrowsperpage + $this->next;
                 if ($maxrows > $rows) {
                     $maxrows = $rows;
                     $prev_rows = $maxrows;
                 }
             } else {
                 $maxrows = $rows;
             }
 
             if ($duration == "unnormalized") {
                 // if display un normalized calls we must substract
                 // the amount of calls normalized above
                 $maxrows=$maxrows-$this->status['normalized'];
             }
 
             if ($group_by) {
                 if ($order_by == "group_by") {
                     $order_by1 = $group_by;
                 } else {
                     if ($order_by == $this->inputTrafficField
                         || $order_by == $this->outputTrafficField
                         || $order_by == $this->durationField
                         || $order_by == $this->priceField
                         || $order_by == "zeroP"
                         || $order_by == "nonzeroP"
                     ) {
                         $order_by1 = $order_by;
                     } else {
                         $order_by1 = "calls";
                     }
                 }
 
                 $this->SipMethodField = $this->CDRFields['SipMethod'];
                 $query = "
                     select
                         sum($this->durationField) as $this->durationField,
                         SEC_TO_TIME(sum($this->durationField)) as hours,
                         count($group_by) as calls,
                         $this->SipMethodField,
                         2*sum($this->inputTrafficField)/1024/1024 as $this->inputTrafficField,
                         2*sum($this->outputTrafficField)/1024/1024 as $this->outputTrafficField,
                         SUM($this->durationField = '0') as zero,
                         SUM($this->durationField > '0') as nonzero,";
 
                 if ($order_by=="zeroP" || $order_by=="nonzeroP") {
                     $query .= "
                         SUM($this->durationField = '0')/count($group_by)*100 as zeroP,
                         SUM($this->durationField > '0')/count($group_by)*100 as nonzeroP,";
                 }
 
                 $query .= "
                         sum($this->inputTrafficField)*8*2/1024/sum($this->durationField) as netrate_in,
                         sum($this->outputTrafficField)*8*2/1024/sum($this->durationField) as netrate_out";
 
                 if ($this->priceField) {
                     $query .= ", sum($this->priceField) as $this->priceField
                     ";
                 }
 
                 $_max_rows = intval($this->maxrowsperpage);
                 if (!$_max_rows) {
                     $_max_rows = 10;
                 }
                 /*
                 $query.= "
                 , $group_by as mygroup
                 from $cdr_table
                 where $where
                 group by $group_by
                 $having
                 order by $order_by1 $order_type
                 limit $i,$_max_rows
                 ";
                 */
 
                 $query.= sprintf(
                     "
                     , %s as mygroup from %s
                     where
                         %s
                     group by
                         %s
                         %s
                     order by
                         %s %s
                     limit %d, %d
                     ",
                     $group_by,
                     addslashes($cdr_table),
                     $where,
                     $group_by,
                     addslashes($having),
                     addslashes($order_by1),
                     addslashes($order_type),
                     $i,
                     $_max_rows
                 );
                 dprint_sql($query);
 
                 $this->CDRdb->query($query);
 
                 $this->showTableHeaderStatistics();
                 while ($i<$maxrows) {
                     $found = $i + 1;
                     $this->CDRdb->next_record();
 
                     $calls              = $this->CDRdb->f('calls');
                     $seconds            = $this->CDRdb->f($this->durationField);
                     $seconds            = $this->CDRdb->f($this->durationField);
                     $seconds_print      = number_format($this->CDRdb->f($this->durationField), 0);
                     $minutes            = number_format($this->CDRdb->f($this->durationField)/60, 0, "", "");
                     $minutes_print      = number_format($this->CDRdb->f($this->durationField)/60, 0);
                     $hours              = $this->CDRdb->f('hours');
 
                     $AcctInputOctets    = number_format($this->CDRdb->f($this->inputTrafficField), 2, ".", "");
                     $AcctOutputOctets   = number_format($this->CDRdb->f($this->outputTrafficField), 2, ".", "");
                     $NetRateIn          = $this->CDRdb->f('netrate_in');
                     $NetRateOut         = $this->CDRdb->f('netrate_out');
                     $SipMethod          = $this->CDRdb->f($this->callTypeField);
                     $AcctTerminateCause = $this->CDRdb->f($this->disconnectField);
                     $mygroup            = $this->CDRdb->f('mygroup');
 
                     $zero               = $this->CDRdb->f('zero');
                     $nonzero            = $this->CDRdb->f('nonzero');
                     $success            = number_format($nonzero/$calls*100, 2, ".", "");
                     $failure            = number_format($zero/$calls*100, 2, ".", "");
 
                     $NetworkRateIn      = number_format($NetRateIn, 2);
                     $NetworkRateOut     = number_format($NetRateOut, 2);
                     $NetworkRate        = max($NetworkRateIn, $NetworkRateOut);
 
                     if ($this->priceField) {
                         $price          = $this->CDRdb->f($this->priceField);
                     }
 
                     $rr = floor($found/2);
                     $mod=$found-$rr*2;
 
                     if ($mod ==0) {
                         $inout_color="lightgrey";
                     } else {
                         $inout_color="white";
                     }
 
                     $traceValue="";
                     $mygroup_print = quoted_printable_decode($mygroup);
 
                     if ($this->group_byOrig==$this->DestinationIdField) {
                         if ($this->CDRTool['filter']['domain'] && $this->destinations[$this->CDRTool['filter']['domain']]) {
                             list($_dst_id, $_dst_name) = $this->getPSTNDestinationId($mygroup, '', $this->CDRTool['filter']['domain']);
                             $description=$_dst_name;
                         } else {
                             $description=$this->destinations[0]["default"][$mygroup]["name"];
                             //list($_dst_id,$_dst_name)=$this->getPSTNDestinationId($mygroup);
                             //$description=$_dst_name;
                         }
 
                         if ($mygroup) {
                             $traceValue=$mygroup;
                         } else {
                             $traceValue="empty";
                         }
                     } elseif ($this->group_byOrig==$this->aNumberField) {
                         // Normalize Called Station Id
                         $N=$this->NormalizeNumber($mygroup);
                         $mygroup_print=$N['username']."@".$N[domain];
                         $description="";
                         $traceField="a_number";
                         $traceValue = urlencode($mygroup);
                     } elseif ($this->group_byOrig==$this->CanonicalURIField) {
                         $traceField="c_number";
                         $traceValue = urlencode($mygroup);
                     } elseif ($this->group_byOrig==$this->SipProxyServerField) {
                         $traceField="sip_proxy";
                         $traceValue = urlencode($mygroup);
                     } elseif ($this->group_byOrig==$this->MediaProxyField) {
                         $traceField="media_proxy";
                         $traceValue = urlencode($mygroup);
                     } elseif ($this->group_byOrig==$this->tlscnField) {
                         $traceField="tlscn";
                         $traceValue = urlencode($mygroup);
                     } elseif ($this->group_byOrig==$this->SipCodecField) {
                         $traceField="SipCodec";
                     } elseif (preg_match("/UserAgent/", $this->group_byOrig)) {
                         $traceField="UserAgent";
                     } elseif (preg_match("/^BY/", $this->group_byOrig)) {
                         $traceField="MONTHYEAR";
                     } elseif ($this->group_byOrig==$this->callIdField) {
                         $traceField="call_id";
                     } elseif ($this->group_byOrig=="DAYOFWEEK") {
                         if ($mygroup == "1") {
                             $description="Sunday";
                         } elseif ($mygroup == "2") {
                             $description="Monday";
                         } elseif ($mygroup == "3") {
                             $description="Tuesday";
                         } elseif ($mygroup == "4") {
                             $description="Wednesday";
                         } elseif ($mygroup == "5") {
                             $description="Thursday";
                         } elseif ($mygroup == "6") {
                             $description="Friday";
                         } elseif ($mygroup == "7") {
                             $description="Saturday";
                         }
                     } elseif ($this->group_byOrig=="DAYOFMONTH") {
                         $description    =$this->CDRdb->f('day');
                     } elseif ($this->group_byOrig=="DAYOFYEAR") {
                         $description    =$this->CDRdb->f('day');
                     } elseif ($this->group_byOrig=="SourceIP") {
                         $traceField="gateway";
                     } elseif ($this->group_byOrig=="SipResponseCode") {
                         $description    =$this->disconnectCodesDescription[$mygroup];
                         $traceField="sip_status";
                     } elseif ($this->group_byOrig=="SipApplicationType") {
                         $traceField="application";
                     } elseif ($this->group_byOrig=="ServiceType") {
                         $traceField="flow";
                     } else {
                         $description="";
                     }
 
                     if (!$traceField) {
                         $traceField    = $group_by;
                     }
 
                     if (!$traceValue) {
                         $traceValue    = $mygroup;
                     }
 
                     if (!$traceValue) {
                         $traceValue="";
                         $comp_type="empty";
                     } else {
                         $comp_type="begin";
                     }
 
                     $traceValue_enc = urlencode($traceValue);
 
                     if (!$this->export) {
                         print "
                             <tr>
                             <td><b>$found</b></td>
                             <td align=right>$calls</td>
                             <td align=right>$seconds_print</td>
                             <td align=right>$minutes_print</td>
                             <td align=right>$hours</td>
                             ";
                         if ($perm->have_perm("showPrice")) {
                             $pricePrint = number_format($price, 4, ".", "");
                         } else {
                             $pricePrint = 'x.xxx';
                         }
                         print "
                             <td align=right>$pricePrint</td>
                             <td align=right>$AcctInputOctets</td>
                             <td align=right>$AcctOutputOctets</td>
                             <td align=right>$success%</td>
                             <td align=right>($nonzero calls)</td>
                             <td align=right>$failure%</td>
                             <td align=right>($zero calls)</td>
                             <td>$mygroup_print</td>
                             <td>$description</td>
                             <td>";
                         printf(
                             "<a href=%s&%s=%s&%s_comp=%s target=_new>Display calls</a></td>",
                             $url_calls,
                             $traceField,
                             $traceValue_enc,
                             $traceField,
                             $comp_type
                         );
                         print "</tr>";
                     } else {
                         print "$found,";
                         print "$calls,";
                         print "$seconds,";
                         print "$minutes,";
                         print "$hours,";
                         if ($perm->have_perm("showPrice")) {
                             $pricePrint=$price;
                         } else {
                             $pricePrint='x.xxx';
                         }
                         print "$pricePrint,";
                         print "$AcctInputOctets,";
                         print "$AcctOutputOctets,";
                         print "$success,";
                         print "$nonzero,";
                         print "$failure,";
                         print "$zero,";
                         print "$mygroup_print,";
                         print "$description";
                         print "\n";
                     }
                     $i++;
                 }
 
                 if (!$this->export) {
                     print "</table>";
                 }
             } else {
                 if (!$this->export) {
                     // printf ("<div class='alert alert-info'><i style='font-size:13px' class='icon-info-sign'></i> For more information about each call click on its Id column.</div>");
                 }
 
                 if ($order_by=="zeroP" || $order_by=="nonzeroP") {
                     $order_by="timestamp";
                 }
                 $_max_rows = intval($this->maxrowsperpage);
                 if (!$_max_rows) {
                     $_max_rows = 10;
                 }
                 $query = sprintf(
                     "select *, UNIX_TIMESTAMP($this->startTimeField) as timestamp from %s where %s order by %s %s limit %d, %d",
                     addslashes($cdr_table),
                     $where,
                     addslashes($order_by),
                     addslashes($order_type),
                     intval($i),
                     $_max_rows
                 );
 
                 $this->CDRdb->query($query);
 
                 if ($this->CDRTool['filter']['aNumber']) {
                     $this->showTableHeaderSubscriber();
                 } else {
                     if (!$this->export) {
                         $this->showTableHeader();
                     } else {
                         $this->showExportHeader();
                     }
                 }
 
                 while ($i<$maxrows) {
                     global $found;
                     $found = $i + 1;
                     $this->CDRdb->next_record();
 
                     $Structure = $this->_readCDRFieldsFromDB();
                     //dprint_r($Structure);
                     $CDR = new $this->CDR_class($this, $Structure);
 
                     if ($this->CDRTool['filter']['aNumber']) {
                         $CDR->showSubscriber();
                     } else {
                         if (!$this->export) {
                             $CDR->show();
                         } else {
                             $CDR->export();
                         }
                     }
                     $i++;
                 }
 
                 if (!$this->export) {
                     print "</table>";
                 }
             }
             $this->showPagination($this->next, $maxrows);
         }
     }
 
     function LoadDomains()
     {
 
         if (!$this->db_subscribers) {
             $log = printf("Error: Cannot load domains because db_subscribers is not defined in datasource %s", $this->cdr_source);
             print $log;
             syslog(LOG_NOTICE, $log);
             return false;
         }
 
         if (!is_object($this->AccountsDB)) {
             $log = printf("Error: AccountsDB is not a valid database object");
             print $log;
             syslog(LOG_NOTICE, $log);
             return false;
         }
 
         if (strlen($this->DATASOURCES[$this->cdr_source]['enableThor'])) {
             $this->domain_table          = "sip_domains";
         } else {
             $this->domain_table          = "domain";
         }
 
         $query = sprintf("select * from %s", $this->domain_table);
 
         if ($this->CDRTool['filter']['aNumber']) {
             $els = explode("@", $this->CDRTool['filter']['aNumber']);
             $query.= sprintf(" where domain = '%s' ", addslashes($els[1]));
         } elseif ($this->CDRTool['filter']['domain']) {
             $fdomain = $this->CDRTool['filter']['domain'];
             $query.=sprintf(" where domain = '%s' ", addslashes($fdomain));
         }
 
         if (!$this->AccountsDB->query($query)) {
             $log=sprintf("Database %s error: %s (%d) %s\n", $this->db_subscribers, $this->AccountsDB->Error, $this->AccountsDB->Errno, $query);
             print $log;
             syslog(LOG_NOTICE, $log);
             return false;
         }
 
         while ($this->AccountsDB->next_record()) {
             if ($this->AccountsDB->f('domain')) {
                 $this->localDomains[$this->AccountsDB->f('domain')] = array(
                     'name'     => $this->AccountsDB->f('domain'),
                     'reseller' => intval($this->AccountsDB->f('reseller_id'))
                 );
             }
         }
 
         return count($this->localDomains);
     }
 
     function LoadTrustedPeers()
     {
 
         if (!$this->db_subscribers) {
             $log = printf(
                 "Error: Cannot load trusted peers because db_subscribers is not defined in datasource %s",
                 $this->cdr_source
             );
             print $log;
             syslog(LOG_NOTICE, $log);
             return false;
         }
 
         if (!is_object($this->AccountsDB)) {
             $log = printf("Error: AccountsDB is not a valid database object");
             print $log;
             syslog(LOG_NOTICE, $log);
             return false;
         }
 
         if (strlen($this->DATASOURCES[$this->cdr_source]['enableThor'])) {
             $this->trusted_table = "sip_trusted";
         } else {
             $this->trusted_table = "trusted_peers";
         }
 
         $query=sprintf("select * from %s", addslashes($this->trusted_table));
 
         if (!$this->AccountsDB->query($query)) {
             $log = sprintf("Database %s error: %s (%d) %s\n", $this->db_subscribers, $this->AccountsDB->Error, $this->AccountsDB->Errno, $query);
             print $log;
             syslog(LOG_NOTICE, $log);
             return false;
         }
 
         while ($this->AccountsDB->next_record()) {
             if ($this->AccountsDB->f('ip')) {
                 $this->trustedPeers[$this->AccountsDB->f('ip')] = array(
                     'ip'     => $this->AccountsDB->f('ip'),
                     'reseller' => intval($this->AccountsDB->f('reseller_id'))
                 );
             }
         }
 
         return count($this->trustedPeers);
     }
 
     function getQuota($account)
     {
 
         if (!$this->quotaEnabled) {
             return true;
         }
 
         if (!$account) {
             return;
         }
 
         if (!is_object($this->AccountsDB)) {
             $log = printf("Error: AccountsDB is not a valid database object");
             print $log;
             syslog(LOG_NOTICE, $log);
             return false;
         }
 
         list($username, $domain) = explode("@", $account);
 
         if ($this->enableThor) {
             $query = sprintf("select * from sip_accounts where username = '%s' and domain = '%s'", addslashes($username), addslashes($domain));
 
             if (!$this->AccountsDB->query($query)) {
                 $log = sprintf(
                     "Database error for query 1 %s: %s (%s)",
                     $query,
                     $this->AccountsDB->Error,
                     $this->AccountsDB->Errno
                 );
                 syslog(LOG_NOTICE, $log);
                 return 0;
             }
 
             if ($this->AccountsDB->num_rows()) {
                 $this->AccountsDB->next_record();
                 $_profile=json_decode(trim($this->AccountsDB->f('profile')));
                 return $_profile->quota;
             } else {
                 return 0;
             }
         } else {
             $query=sprintf("select quota from subscriber where username = '%s' and domain = '%s'", addslashes($username), addslashes($domain));
 
             if (!$this->AccountsDB->query($query)) {
                 $log = sprintf(
                     "Database error for query %s: %s (%s)",
                     $query,
                     $this->AccountsDB->Error,
                     $this->AccountsDB->Errno
                 );
                 syslog(LOG_NOTICE, $log);
                 return 0;
             }
 
             if ($this->AccountsDB->num_rows()) {
                 $this->AccountsDB->next_record();
                 return $this->AccountsDB->f('quota');
             } else {
                 return 0;
             }
         }
     }
 
     function getBlockedByQuotaStatus($account)
     {
         if (!$this->quotaEnabled) {
             return true;
         }
 
         if (!$account) {
             return 0;
         }
 
         if (!is_object($this->AccountsDB)) {
             $log = printf("Error: AccountsDB is not a valid database object");
             print $log;
             syslog(LOG_NOTICE, $log);
             return false;
         }
 
         list($username, $domain) = explode("@", $account);
 
         if ($this->enableThor) {
             $query = sprintf("select * from sip_accounts where username = '%s' and domain = '%s'", addslashes($username), addslashes($domain));
 
             if (!$this->AccountsDB->query($query)) {
                 $log = sprintf(
                     "Database error for query2 %s: %s (%s)",
                     $query,
                     $this->AccountsDB->Error,
                     $this->AccountsDB->Errno
                 );
                 syslog(LOG_NOTICE, $log);
                 return 0;
             }
 
             if ($this->AccountsDB->num_rows()) {
                 $this->AccountsDB->next_record();
 
                 $_profile=json_decode(trim($this->AccountsDB->f('profile')));
                 if (in_array('quota', $_profile->groups)) {
                     return 1;
                 } else {
                     return 0;
                 }
             } else {
                 return 0;
             }
         } else {
             $query=sprintf("select CONCAT(username,'@',domain) as account from grp where grp = 'quota' and username = '%s' and domain = '%s'", addslashes($username), addslashes($domain));
 
             if (!$this->AccountsDB->query($query)) {
                 $log = sprintf("Database error for query %s: %s (%s)", $query, $this->AccountsDB->Error, $this->AccountsDB->Errno);
                 syslog(LOG_NOTICE, $log);
                 return 0;
             }
 
             if ($this->AccountsDB->num_rows()) {
                 return 1;
             } else {
                 return 0;
             }
         }
 
         return 0;
     }
 
     public function notifyLastSessions($count='200', $account='')
     {
         // send emails with last missed and received sessions to subscribers in group $this->missed_calls_group
 
         $lockName = sprintf("%s:notifySessions", $this->cdr_source);
 
         if (!$this->getNormalizeLock($lockName)) {
             return true;
         }
 
         if (strlen($account)) {
             list($username, $domain) = explode('@', $account);
             if (!strlen($username) || !strlen($domain)) {
                 return false;
             }
         } else {
             $query=sprintf("select * from memcache where `key` = '%s'", 'notifySessionsLastRun');
             $this->cdrtool->query($query);
             if ($this->cdrtool->num_rows()) {
                 $this->cdrtool->next_record();
                 $lastRun=$this->cdrtool->f('value');
                 if (Date('Y-m-d') == $lastRun) {
                     $log=sprintf("Notify sessions script already run for date %s\n", $lastRun);
                     print $log;
                     syslog(LOG_NOTICE, $log);
                     return true;
                 }
             }
         }
 
         $this->notifySubscribers=array();
 
         require_once('Mail.php');
         require_once('Mail/mime.php');
 
         if ($this->enableThor) {
             $query=sprintf("select * from sip_accounts");
             if (strlen($account)) {
                 $query=sprintf("select * from sip_accounts where username = '%s' and domain = '%s'", addslashes($username), addslashes($domain));
             }
 
             if (!$this->AccountsDB->query($query)) {
                 $log = sprintf(
                     "Database error for query %s: %s (%s)",
                     $query,
                     $this->AccountsDB->Error,
                     $this->AccountsDB->Errno
                 );
                 syslog(LOG_NOTICE, $log);
                 return 0;
             }
 
             if ($this->AccountsDB->num_rows()) {
                 while ($this->AccountsDB->next_record()) {
                     $_profile=json_decode(trim($this->AccountsDB->f('profile')));
                     if (in_array($this->missed_calls_group, $_profile->groups)) {
                         $this->notifySubscribers[$this->AccountsDB->f('username').'@'.$this->AccountsDB->f('domain')]=array('email'=>$this->AccountsDB->f('email'),'timezone' => $_profile->timezone);
                     }
                 }
             } else {
                 return 0;
             }
         } else {
             $query = sprintf(
                 "select CONCAT(username,'@',domain) as account,email_address,timezone from grp join subscriber on grp.subscriber_id =subscriber.id where grp = '%s'",
                 addslashes($this->missed_calls_group)
             );
             if (strlen($account)) {
                 $query.= sprintf(" and username = '%s' and domain = '%s' ", $username, $domain);
             }
 
             if (!$this->AccountsDB->query($query)) {
                 $log = sprintf("Database error for query %s: %s (%s)", $query, $this->AccountsDB->Error, $this->AccountsDB->Errno);
                 syslog(LOG_NOTICE, $log);
                 return 0;
             }
 
             if ($this->AccountsDB->num_rows()) {
                 while ($this->AccountsDB->next_record()) {
                     $this->notifySubscribers[$this->AccountsDB->f('account')]=array('email'=>$this->AccountsDB->f('email_address'),'timezone' => $this->AccountsDB->f('timezone'));
                 }
             } else {
                 return 0;
             }
         }
 
         if (!count($this->notifySubscribers)) {
             return 0;
         }
 
         $j = 0;
         foreach (array_keys($this->notifySubscribers) as $_subscriber) {
             $j++;
             $_last_sessions=array();
             unset($textBody);
             unset($htmlBody);
 
             $query = sprintf(
                 "
                 SELECT
                     *,
                     UNIX_TIMESTAMP(%s) as timestamp
                 FROM
                     %s
                 where
                     (%s = '%s' or %s = '%s')
                     and %s > DATE_ADD(NOW(), INTERVAL -1 day)
                 order by %s desc
                 limit 200",
                 addslashes($this->startTimeField),
                 addslashes($this->table),
                 addslashes($this->usernameField),
                 addslashes($_subscriber),
                 addslashes($this->CanonicalURIField),
                 addslashes($_subscriber),
                 addslashes($this->startTimeField),
                 addslashes($this->startTimeField)
             );
 
             if (!$this->CDRdb->query($query)) {
                 $log = sprintf("Database error for query %s: %s (%s)", $query, $this->CDRdb->Error, $this->CDRdb->Errno);
                 syslog(LOG_NOTICE, $log);
                 print $log;
                 return 0;
             }
 
             if (Date('d') == 1) {
                 while ($this->CDRdb->next_record()) {
                     $_last_sessions[] = array(
                         'duration'  => $this->CDRdb->f($this->durationField),
                         'from'      => $this->CDRdb->f($this->aNumberField),
                         'to'        => $this->CDRdb->f($this->cNumberField),
                         'username'  => $this->CDRdb->f($this->usernameField),
                         'canonical' => $this->CDRdb->f($this->CanonicalURIField),
                         'date'      => getlocaltime($this->notifySubscribers[$_subscriber]['timezone'], $this->CDRdb->f('timestamp'))
                     );
                 }
 
                 if (preg_match("/^(\w+)(\d{4})(\d{2})$/", $this->table, $m)) {
                     $previousTable=$m[1].date('Ym', mktime(0, 0, 0, $m[3]-1, "01", $m[2]));
                     $query = sprintf(
                         "
                         SELECT
                             *,
                             UNIX_TIMESTAMP(%s) as timestamp
                         FROM
                             %s
                         where
                             %s = '%s'
                             and %s > DATE_ADD(NOW(), INTERVAL -1 day)
                         order by
                             %s desc
                         limit 200
                         ",
                         addslashes($this->startTimeField),
                         addslashes($previousTable),
                         addslashes($this->CanonicalURIField),
                         addslashes($_subscriber),
                         addslashes($this->startTimeField),
                         addslashes($this->startTimeField)
                     );
 
                     if (!$this->CDRdb->query($query)) {
                         $log = sprintf("Database error for query %s: %s (%s)", $query, $this->CDRdb->Error, $this->CDRdb->Errno);
                         syslog(LOG_NOTICE, $log);
                         print $log;
                         return 0;
                     }
 
                     while ($this->CDRdb->next_record()) {
                         $_last_sessions[] = array(
                             'duration'   => $this->CDRdb->f($this->durationField),
                             'from'       => $this->CDRdb->f($this->aNumberField),
                             'to'         => $this->CDRdb->f($this->cNumberField),
                             'username'   => $this->CDRdb->f($this->usernameField),
                             'canonical'  => $this->CDRdb->f($this->CanonicalURIField),
                             'date'       => getlocaltime($this->notifySubscribers[$_subscriber]['timezone'], $this->CDRdb->f('timestamp'))
                         );
                     }
                 }
             } else {
                 while ($this->CDRdb->next_record()) {
                     $_last_sessions[] = array(
                         'duration'  => $this->CDRdb->f($this->durationField),
                         'from'      => $this->CDRdb->f($this->aNumberField),
                         'to'        => $this->CDRdb->f($this->cNumberField),
                         'username'  => $this->CDRdb->f($this->usernameField),
                         'canonical' => $this->CDRdb->f($this->CanonicalURIField),
                         'date'      => getlocaltime($this->notifySubscribers[$_subscriber]['timezone'], $this->CDRdb->f('timestamp'))
                     );
                 }
             }
 
             if (!count($_last_sessions)) {
                 continue;
             }
 
             $sessions=array(
                 'missed'   => array(),
                 'received' => array(),
                 'diverted' => array()
             );
 
             $have_sessions=0;
 
             foreach ($_last_sessions as $_s) {
                 if ($_s['duration'] == 0 && $_s['canonical'] == $_subscriber) {
                     $sessions['missed'][]=$_s;
                     $have_sessions++;
                     continue;
                 }
 
                 if ($_s['duration'] > 0 && $_s['canonical'] == $_subscriber) {
                     $sessions['received'][]=$_s;
                     $have_sessions++;
                     continue;
                 }
 
                 if ($_s['from'] != $_subscriber && $_s['canonical'] != $_subscriber) {
                     $sessions['diverted'][]=$_s;
                     $have_sessions++;
                     continue;
                 }
             }
 
             if (!$have_sessions) {
                 continue;
             }
 
             if (count($sessions['missed'])) {
                 // missed sessions
                 $textBody .= sprintf(
                     "
                     Missed sessions\n\n
                     Id,Date,From,Duration\n
                     "
                 );
 
                 $htmlBody .= sprintf("<h2>Missed Calls</h2>
                 <p>
                 <table border=0>
                 <tr>
                 <th>
                 </th>
                 <th>Date and Time
                 </th>
                 <th>Caller
                 </th>
                 </tr>
                 ");
 
                 $i=0;
                 foreach ($sessions['missed'] as $_session) {
                     $i++;
                     if ($i >= $count) {
                         break;
                     }
                     $htmlBody .= sprintf(
                         "
                         <tr>
                             <td>%s</td>
                             <td>%s</td>
                             <td><a href=sip:%s>sip:%s</a></td>
                         </tr>
                         ",
                         $i,
                         $_session['date'],
                         $_session['from'],
                         $_session['from']
                     );
 
 
                     $txtBody.=sprintf(
                         "%s,%s,%s,%s,%s\n",
                         $i,
                         $_session['date'],
                         $_session['from'],
                         $_session['to']
                     );
                 }
 
                 $htmlBody.="</table>";
             }
 
             if (count($sessions['diverted'])) {
                 // diverted sessions
                 $textBody .= sprintf("Diverted Calls\n\n
                 Id,Date,From,Diverted to\n
                 ");
 
                 $htmlBody .= sprintf("<h2>Diverted Calls</h2>
                 <p>
                 <table border=0>
                 <tr>
                 <th>
                 </th>
                 <th>Date and Time
                 </th>
                 <th>Caller
                 </th>
                 <th>Diverted to
                 </th>
                 </tr>
                 ");
 
                 $i=0;
                 foreach ($sessions['diverted'] as $_session) {
                     $i++;
                     if ($i >= $count) break;
 
                     $htmlBody.=sprintf(
                         "
                         <tr>
                             <td>%s</td>
                             <td>%s</td>
                             <td><a href=sip:%s>sip:%s</a></td>
                             <td>%s</td>
                         </tr>
                         ",
                         $i,
                         $_session['date'],
                         $_session['from'],
                         $_session['from'],
                         $_session['canonical']
                     );
 
                     $txtBody .= sprintf(
                         "%s,%s,%s,%s\n",
                         $i,
                         $_session['date'],
                         $_session['from'],
                         $_session['canonical']
                     );
                 }
 
                 $htmlBody.="</table>";
             }
 
             if (count($sessions['received'])) {
                 // received sessions
                 $textBody .= sprintf("Received Calls\n\nId,Date,From,Duration\n");
 
                 $htmlBody .= sprintf(
                     "<h2>Received Calls</h2>
                     <p>
                     <table border=0>
                     <tr>
                         <th></th>
                         <th>Date and Time</th>
                         <th>Caller</th>
                         <th>Duration</th>
                     </tr>"
                 );
 
                 $i=1;
                 foreach ($sessions['received'] as $_session) {
                     if ($i >= $count) {
                         break;
                     }
 
                     $htmlBody .= sprintf(
                         "<tr><td>%s</td><td>%s</td><td><a href=sip:%s>sip:%s</a></td><td>%s</td></tr>",
                         $i,
                         $_session['date'],
                         $_session['from'],
                         $_session['from'],
                         $_session['duration']
                     );
 
 
                     $txtBody .= sprintf(
                         "%s,%s,%s,%s\n",
                         $i,
                         $_session['date'],
                         $_session['from'],
                         $_session['duration']
                     );
 
                     $i++;
                 }
 
                 $htmlBody.="</table>";
             }
 
             $htmlBody.="<p>This is an automatically generated message, do not reply.";
             $txtBody.="\nThis is an automatically generated message, do not reply.\n";
 
             $crlf = "\n";
             $hdrs = array(
                 'From'=> $this->CDRTool['provider']['fromEmail'],
                 'Subject' => sprintf("Incoming Calls for %s on %s", $_subscriber, date('Y-m-d'))
             );
 
             $mime = new Mail_mime($crlf);
             $mime->setTXTBody($textBody);
             $mime->setHTMLBody($htmlBody);
 
             $body = $mime->get();
             $hdrs = $mime->headers($hdrs);
 
             $mail =& Mail::factory('mail');
             if (version_compare(PHP_VERSION, '8.0.0') >= 0) {
                 $mail->sep = "\r\n";
             }
             $mail->send($this->notifySubscribers[$_subscriber]['email'], $hdrs, $body);
 
             $log=sprintf(
                 "Notify %s at %s with last %d sessions\n",
                 $_subscriber,
                 $this->notifySubscribers[$_subscriber]['email'],
                 count($_last_sessions)
             );
             print $log;
             syslog(LOG_NOTICE, $log);
         }
 
         $query = sprintf("update memcache set `value` = '%s' where `key` = '%s'", Date('Y-m-d'), 'notifySessionsLastRun');
 
         if (!$this->cdrtool->query($query)) {
             $log = sprintf("Database error for query %s: %s (%s)", $query, $this->cdrtool->Error, $this->cdrtool->Errno);
             print $log;
             syslog(LOG_NOTICE, $log);
             return false;
         }
 
         if (!$this->cdrtool->affected_rows()) {
             $query=sprintf("insert into memcache (`value`,`key`) values ('%s','%s')", Date('Y-m-d'), 'notifySessionsLastRun');
             if (!$this->cdrtool->query($query)) {
                 if ($this->cdrtool->Errno != 1062) {
                     $log=sprintf("Database error for query %s: %s (%s)", $query, $this->cdrtool->Error, $this->cdrtool->Errno);
                     print $log;
                     syslog(LOG_NOTICE, $log);
                     return false;
                 }
             }
         }
     }
 
     function getCallerId($account)
     {
         if (!$account) {
             return null;
         }
 
         if ($this->callerid_cache[$account]) {
             return $this->callerid_cache[$account];
         }
 
         list($username, $domain) = explode('@', $account);
 
         if ($this->enableThor) {
             $query=sprintf("select * from sip_accounts where username = '%s' and domain = '%s'", addslashes($username), addslashes($domain));
 
             if (!$this->AccountsDB->query($query)) {
                 $log=sprintf("Database error for query %s: %s (%s)", $query, $this->AccountsDB->Error, $this->AccountsDB->Errno);
                 syslog(LOG_NOTICE, $log);
                 return null;
             }
 
             if ($this->AccountsDB->num_rows()) {
                 $this->AccountsDB->next_record();
                 $_profile=json_decode(trim($this->AccountsDB->f('profile')));
                 $this->callerid_cache[$account]=$_profile->rpid;
                 return $_profile->rpid;
             }
         } else {
             $query=sprintf("select rpid from subscriber where username = '%s' and domain = '%s'", addslashes($username), addslashes($domain));
 
             if (!$this->AccountsDB->query($query)) {
                 $log=sprintf("Database error for query %s: %s (%s)", $query, $this->AccountsDB->Error, $this->AccountsDB->Errno);
                 syslog(LOG_NOTICE, $log);
                 return null;
             }
 
             if ($this->AccountsDB->num_rows()) {
                 $this->AccountsDB->next_record();
                 $rpid = $this->AccountsDB->f('rpid');
                 $this->callerid_cache[$account]=$rpid;
                 return $rpid;
             }
         }
         return null;
     }
 
     function rate_on_net_enabled($username, $domain)
     {
         if ($this->enableThor) {
             $query=sprintf("select * from sip_accounts where username = '%s' and domain = '%s'", addslashes($username), addslashes($domain));
             if (!$this->AccountsDB->query($query)) {
                 $log=sprintf("Database error for query %s: %s (%s)", $query, $this->AccountsDB->Error, $this->AccountsDB->Errno);
                 syslog(LOG_NOTICE, $log);
                 return false;
             }
 
             if ($this->AccountsDB->num_rows()) {
                 while ($this->AccountsDB->next_record()) {
                     $_profile = json_decode(trim($this->AccountsDB->f('profile')));
                     if (in_array($this->rate_on_net_group, $_profile->groups)) {
                         return true;
                     }
                 }
             }
         }
         return false;
     }
 }
 
 class CDR_opensips extends CDR
 {
     public function __construct($parent, $CDRfields)
     {
         $this->CDRS = $parent;
 
         $this->cdr_source  = $this->CDRS->cdr_source;
 
         foreach (array_keys($this->CDRS->CDRFields) as $field) {
             $this->$field = $CDRfields[$this->CDRS->CDRFields[$field]];
         }
 
         if ($this->CanonicalURI) {
             $this->CanonicalURI   = quoted_printable_decode($this->CanonicalURI);
         }
 
         if ($this->RemoteAddress) {
             $this->RemoteAddress  = quoted_printable_decode($this->RemoteAddress);
         }
 
         if ($this->BillingPartyId) {
             $this->BillingPartyId = quoted_printable_decode($this->BillingPartyId);
         }
 
         if ($this->aNumber) {
             $this->aNumber        = quoted_printable_decode($this->aNumber);
         }
 
         if ($this->cNumber) {
             $this->cNumber        = quoted_printable_decode($this->cNumber);
         }
 
         if ($this->SipRPID) {
             $this->SipRPID        = quoted_printable_decode($this->SipRPID);
         }
 
         if (!$this->application && $this->SipMethod) {
             $_method=strtolower($this->SipMethod);
             if ($_method == 'message') {
                 $this->application = 'message';
                 $this->stopTimeNormalized=$this->startTime;
             } else {
                 $this->application = 'audio';
             }
         }
 
         if ($this->application == 'message') {
             $this->stopTimeNormalized=$this->startTime;
         }
 
         $this->application=strtolower($this->application);
 
         $this->application_print=quoted_printable_decode($this->application);
 
         $this->FromHeaderPrint = quoted_printable_decode($this->FromHeader);
         if (strstr($this->FromHeaderPrint, ';')) {
             $_els=explode(";", $this->FromHeaderPrint);
             $this->FromHeaderPrint = $_els[0];
         }
 
         $this->FromHeaderPrint = htmlentities($this->FromHeaderPrint);
 
         $this->UserAgentPrint  = quoted_printable_decode($this->UserAgent);
 
         $app_prefix = preg_replace('/[.].*$/', '', $this->application);
         if (!in_array($app_prefix, $this->supportedApplicationTypes)) {
             $log=sprintf("Changing application from %s to %s\n", $this->application, $this->defaultApplicationType);
             logger($log);
             $this->application = $this->defaultApplicationType;
         }
 
         //$this->applicationNormalized=$this->application;
 
         if ($this->aNumber) {
             $NormalizedNumber        = $this->CDRS->NormalizeNumber($this->aNumber, "source");
             $this->aNumberPrint      = $NormalizedNumber['NumberPrint'];
             $this->aNumberNormalized = $NormalizedNumber['Normalized'];
             $this->aNumberUsername   = $NormalizedNumber['username'];
             $this->aNumberDomain     = $NormalizedNumber['domain'];
         }
 
         if (!$this->BillingPartyId || $this->BillingPartyId == 'n/a') {
             $this->BillingPartyId=$this->aNumberPrint;
         }
 
         $this->ResellerId=0;
         // calculate reseller
         $_billing_party_els=explode("@", $this->BillingPartyId);
         if ($this->isBillingPartyLocal()) {
             $this->ResellerId = $this->CDRS->localDomains[$_billing_party_els[1]]['reseller'];
         } else {
             if (!strlen($_billing_party_els[0])) {
                 $this->BillingPartyId=$_billing_party_els[1];
             }
             if (count($_billing_party_els) == 2) {
                 if (!$this->domain) {
                     $this->domain=$_billing_party_els[1];
                 }
                 if ($this->CDRS->localDomains[$_billing_party_els[1]]['reseller']) {
                     $this->ResellerId = $this->CDRS->localDomains[$_billing_party_els[1]]['reseller'];
                 } elseif ($this->CDRS->trustedPeers[$_billing_party_els[1]]['reseller']) {
                     $this->ResellerId = $this->CDRS->trustedPeers[$_billing_party_els[1]]['reseller'];
                 }
             } elseif (count($_billing_party_els)==1) {
                 $this->ResellerId=$this->CDRS->trustedPeers[$_billing_party_els[0]]['reseller'];
             }
         }
 
         if (!strlen($this->ResellerId)) {
             $this->ResellerId = 0;
         }
 
         $this->BillingPartyId=strtolower($this->BillingPartyId);
 
         $this->BillingPartyIdPrint = $this->BillingPartyId;
 
         $this->domainNormalized = $this->domain;
 
         if (is_array($this->CDRS->DATASOURCES[$this->cdr_source]['domainTranslation_SourceIP'])
             && isset($this->CDRS->DATASOURCES[$this->cdr_source]['domainTranslation_SourceIP'][$this->SourceIP])
             && strlen($this->CDRS->DATASOURCES[$this->cdr_source]['domainTranslation_SourceIP'][$this->SourceIP])
         ) {
             $this->domainNormalized=$this->CDRS->DATASOURCES[$this->cdr_source]['domainTranslation_SourceIP'][$this->SourceIP];
         } elseif (is_array($this->CDRS->DATASOURCES[$this->cdr_source]['domainTranslation'])
             && isset($this->CDRS->DATASOURCES[$this->cdr_source]['domainTranslation'][$this->domain])
             && strlen($this->CDRS->DATASOURCES[$this->cdr_source]['domainTranslation'][$this->domain])
         ) {
             $this->domainNormalized=$this->CDRS->DATASOURCES[$this->cdr_source]['domainTranslation'][$this->domain];
         }
 
         $this->domainNormalized=strtolower($this->domainNormalized);
 
         $this->RemoteAddressPrint=quoted_printable_decode($this->RemoteAddress);
 
         $_timestamp_stop=$this->timestamp+$this->duration;
 
         $this->dayofweek       = date("w", $this->timestamp);
         $this->hourofday       = date("G", $this->timestamp);
         $this->dayofyear       = date("Y-m-d", $this->timestamp);
 
         // Called Station ID or cNumber should not be used for rating purposes because
         // it is chosen by the subscriber but the Proxy rewrites it into a different
         // final destination (the Canonical URI)
 
         // Canonical URI is the final logical SIP destination after all
         //   lookups like aliases, usrloc , call forwarding, ENUM
         //   mappings or PSTN gateways but before the DNS lookup
         //   Canonical URI must be saved in the SIP Proxy and added as an extra
         //   Radius attribute in the Radius START packet
 
         if (!$this->CanonicalURI) {
             if ($this->RemoteAddress) {
                 $this->CanonicalURI=$this->RemoteAddress;
             } elseif ($this->cNumber) {
                 $this->CanonicalURI=$this->cNumber;
             }
         }
 
         if ($this->CanonicalURI) {
             $this->CanonicalURIPrint            = $this->CanonicalURI;
             $NormalizedNumber                   = $this->CDRS->NormalizeNumber(
                 $this->CanonicalURI,
                 "destination",
                 $this->BillingPartyId,
                 $this->domain,
                 $this->gateway,
                 '',
                 $this->ENUMtld,
                 $this->ResellerId
             );
             $this->CanonicalURINormalized       = $NormalizedNumber['Normalized'];
             $this->CanonicalURIUsername         = $NormalizedNumber['username'];
             $this->CanonicalURIDomain           = $NormalizedNumber['domain'];
             $this->CanonicalURIPrint            = $NormalizedNumber['NumberPrint'];
             $this->CanonicalURIDelimiter        = $NormalizedNumber['delimiter'];
             $this->CanonicalURIE164             = $NormalizedNumber['E164'];
 
             // Destination Id is used for rating purposes
             $this->DestinationId                = $NormalizedNumber['DestinationId'];
             $this->destinationName              = $NormalizedNumber['destinationName'];
             $this->region                       = $NormalizedNumber['region'];
         }
 
         if ($this->cNumber) {
             $NormalizedNumber                   = $this->CDRS->NormalizeNumber(
                 $this->cNumber,
                 "destination",
                 $this->BillingPartyId,
                 $this->domain,
                 $this->gateway,
                 '',
                 $this->ENUMtld,
                 $this->ResellerId
             );
             $this->cNumberNormalized            = $NormalizedNumber['Normalized'];
             $this->cNumberUsername              = $NormalizedNumber['username'];
             $this->cNumberDomain                = $NormalizedNumber['domain'];
             $this->cNumberPrint                 = $NormalizedNumber['username'].$NormalizedNumber['delimiter'].$NormalizedNumber['domain'];
             $this->cNumberDelimiter             = $NormalizedNumber['delimiter'];
             $this->cNumberE164                  = $NormalizedNumber['E164'];
         }
 
         if ($this->RemoteAddress) {
             // Next hop is the real destination after all lookups including DNS
             $NormalizedNumber                   = $this->CDRS->NormalizeNumber(
                 $this->RemoteAddress,
                 "destination",
                 $this->BillingPartyId,
                 $this->domain,
                 $this->gateway,
                 '',
                 $this->ENUMtld,
                 $this->ResellerId
             );
             $this->RemoteAddressPrint           = $NormalizedNumber['NumberPrint'];
             $this->RemoteAddressNormalized      = $NormalizedNumber['Normalized'];
             $this->RemoteAddressDestinationId   = $NormalizedNumber['DestinationId'];
             $this->RemoteAddressDestinationName = $NormalizedNumber['destinationName'];
             $this->RemoteAddressUsername        = $NormalizedNumber['username'];
             $this->RemoteAddressDelimiter       = $NormalizedNumber['delimiter'];
             $this->RemoteAddressE164            = $NormalizedNumber['E164'];
 
             $this->remoteGateway                = $NormalizedNumber['domain'];
             $this->remoteUsername               = $NormalizedNumber['username'];
         }
 
         $this->isCalleeLocal();
         $this->isCallerLocal();
 
         if ($this->CallerIsLocal) {
             if ($this->aNumberPrint == $this->BillingPartyId) {
                 // call is not diverted
 
                 if ($this->CalleeIsLocal) {
                     $this->flow = 'on-net';
                 } else {
                     $this->flow = 'outgoing';
                 }
             } else {
                 // call is diverted
                 if ($this->CalleeIsLocal) {
                     $this->flow = 'on-net-diverted-on-net';
                 } else {
                     $this->flow = 'on-net-diverted-off-net';
                 }
             }
         } else {
             if ($this->isBillingPartyLocal()) {
                 // call is diverted by local user
                 if ($this->CalleeIsLocal) {
                     $this->flow = 'diverted-on-net';
                 } else {
                     $this->flow = 'diverted-off-net';
                 }
             } elseif ($this->CalleeIsLocal) {
                 $this->flow = 'incoming';
             } else {
                 // transit from trusted peer
                 $this->flow = 'transit';
             }
         }
 
         if ((
                 $this->flow == 'on-net'
                 || $this->flow == 'diverted-on-net'
                 || $this->flow == 'on-net-diverted-on-net'
             )
             && $this->application == 'audio'
             && $this->CDRS->rating_settings['rate_on_net_calls']
             && $this->CDRS->rate_on_net_enabled($_billing_party_els[0], $_billing_party_els[1])
             && !$this->DestinationId
             && $this->CalleeCallerId
         ) {
             $_dest = preg_replace("/^\+(\d+)$/", "00$1", $this->CalleeCallerId);
             $NormalizedNumber = $this->CDRS->NormalizeNumber(
                 $_dest,
                 "destination",
                 $this->BillingPartyId,
                 $this->domain,
                 $this->gateway,
                 '',
                 $this->ENUMtld,
                 $this->ResellerId
             );
             $this->DestinationId = $NormalizedNumber['DestinationId'];
             $this->destinationName = $NormalizedNumber['destinationName'];
         }
 
         if ($this->CDRS->rating_settings['rate_on_net_calls']
             && $this->CDRS->rating_settings['rate_on_net_diverted_calls']
             && ( $this->flow == 'on-net-diverted-off-net'
                 || $this->flow == 'on-net-diverted-on-net'
                 || $this->flow == 'diverted-on-net'
                 || $this->flow == 'diverted-off-net'
             )
             && !$this->normalized
             && $this->duration != '0'
             && $this->disconnect == $this->disconnectOrig
         ) {
             $query = sprintf(
                 "
                 update
                     %s
                 set
                         AcctStopTime ='%s',
                         Normalized='0',
                         AcctSessionTime='%s',
                         SipResponseCode='200'
                 where
                         AcctSessionId='%s'
                         and SipFromTag='%s'
                         and SipToTag!='%s'
                         and (
                             ServiceType='on-net'
                             or ServiceType='on-net-diverted-on-net'
                             or ServiceType='diverted-on-net'
                             or ServiceType='incoming')
                         and AcctSessionTime=''
                 ",
                 $this->CDRS->table,
                 $this->stopTime,
                 $this->duration,
                 $this->callId,
                 $this->SipFromTag,
                 $this->SipToTag
             );
             $this->tdb = new DB_radius;
             dprint_sql($query);
             $this->tdb->query($query);
         }
 
         if ($this->application == "presence") {
             $this->destinationPrint     = $this->cNumberUsername.$this->cNumberDelimiter.$this->cNumberDomain;
             $this->DestinationForRating = $this->cNumberNormalized;
         } else {
             if (!$this->DestinationId) {
                 if ($this->CanonicalURIDomain) {
                     $this->destinationPrint = $this->CanonicalURIUsername.$this->CanonicalURIDelimiter.$this->CanonicalURIDomain;
                 } else {
                     $this->destinationPrint = $this->cNumberUsername.$this->cNumberDelimiter.$this->cNumberDomain;
                 }
 
                 if (strstr($this->CanonicalURINormalized, '@')) {
                     $this->DestinationForRating = $this->CanonicalURINormalized;
                 } else {
                     $this->DestinationForRating = $this->RemoteAddressNormalized;
                 }
             } else {
                 $this->DestinationForRating = $this->CanonicalURINormalized;
                 $this->destinationPrint = $this->CanonicalURIPrint;
             }
         }
 
         if ($this->inputTraffic) {
             $this->inputTrafficPrint  = number_format($this->inputTraffic/1024, 2);
         } else {
             $this->inputTrafficPrint = 0;
         }
 
         if ($this->outputTraffic) {
             $this->outputTrafficPrint = number_format($this->outputTraffic/1024, 2);
         } else {
             $this->outputTrafficPrint = 0;
         }
 
         if (!$CDRfields['skip_fix_prepaid_duration']) {
             if (!$this->normalized && $this->callId) {
                 // fix the duration of prepaid sessions if the prepaid duration is different than radius calculated duration
                 $query = sprintf(
                     "
                     select
                         duration
                     from
                         prepaid_history
                     where
                         session = '%s'
                         and destination = '%s'
                     order by id
                     desc limit 1
                     ",
                     addslashes($this->callId),
                     addslashes($this->destinationPrint)     // must be synced with maxsession time
                 );
 
                 if ($this->CDRS->cdrtool->query($query)) {
                     if ($this->CDRS->cdrtool->num_rows()) {
                         $this->CDRS->cdrtool->next_record();
                         $this->durationNormalized = $this->CDRS->cdrtool->f('duration');
                         $this->durationPrint      = sec2hms($this->durationNormalized);
                     } else {
                         $this->durationPrint      = sec2hms($this->duration);
                     }
                 } else {
                     $log = sprintf(
                         "Database error for query %s: %s (%s)",
                         $query,
                         $this->CDRS->cdrtool->Error,
                         $this->CDRS->cdrtool->Errno
                     );
                     syslog(LOG_NOTICE, $log);
                 }
             } else {
                 $this->durationPrint      = sec2hms($this->duration);
             }
         } else {
             $this->durationPrint      = sec2hms($this->duration);
         }
 
         if ($this->disconnect) {
             $this->disconnectPrint    = $this->NormalizeDisconnect($this->disconnect);
         }
 
         if ($this->disconnectOrig != $this->disconnect
             && $this->disconnect
             && $this->CDRS->rating_settings['rate_on_net_diverted_calls']) {
             $this->disconnectOrigPrint = $this->CDRS->disconnectCodesDescription[$this->disconnectOrig]." (".$this->disconnectOrig.")";
         }
 
         $this->traceIn();
         $this->traceOut();
 
         $this->obfuscateCallerId();
 
         if ($this->CDRS->rating) {
             global $perm;
             if (is_object($perm) && $perm->have_perm("showPrice")) {
                 $this->pricePrint=$this->price;
             } else {
                 $this->pricePrint='x.xxx';
             }
         }
     }
 
     private function buildCDRdetail()
     {
         global $perm;
         global $found;
 
         if (!is_object($perm)) return;
 
         $this->geo_location = $this->lookupGeoLocation($this->SourceIP);
 
         $this->cdr_details = "
         <div class=\"alert alert-info\" style='color: black'>
           <div class='row-fluid'>
             <div class='span4'>
                 <h5>SIP Signalling</h5>
 
         ";
 
         $this->cdr_details .= sprintf(
             "<a href=%s&call_id=%s><font color=orange>Click here to show only this call id</font></a>",
             $this->CDRS->url_run,
             urlencode($this->callId)
         );
 
         if ($this->CDRS->sipTrace) {
             $trace_query = array(
                 'cdr_source'    => $this->CDRS->sipTrace,
                 'callid'        => quoted_printable_decode($this->callId),
                 'fromtag'       => quoted_printable_decode($this->SipFromTag),
                 'totag'         => quoted_printable_decode($this->SipToTag),
                 'proxyIP'       => $this->SipProxyServer
             );
 
             $this->traceLink = sprintf(
                 "<a href=\"javascript:void(null);\" onClick=\"return window.open('sip_trace.phtml?%s', '_blank','toolbar=0,status=0,menubar=0,scrollbars=1,resizable=1,width=1300px,height=600')\">
                 <font color=red>Click here for the SIP trace</font></a> &nbsp;",
                 http_build_query($trace_query)
             );
 
             $this->cdr_details .= "
                 <div class=\"row-fluid\">
                 <div class=\"span3\">Call id:</div>
                 <div class=\"span9\">$this->callId </div>
             </div>
             ";
         }
 
         $this->cdr_details .= sprintf(
             "
             <div class=\"row-fluid\">
                 <div class=\"span12\">%s</div>
             </div>
             ",
             $this->traceLink
         );
 
         $this->cdr_details .= "
         <div class=\"row-fluid\">
             <div class=\"span3\">From tag: </div>
             <div class=\"span9\">$this->SipFromTag</div>
         </div>
         <div class=\"row-fluid\">
             <div class=\"span3\">To tag: </div>
             <div class=\"span9\">$this->SipToTag</div>
         </div>
         <div class=\"row-fluid\">
             <div class=\"span3\">Start Time:</div>
             <div class=\"span9\">$this->startTime $providerTimezone</div>
         </div>
         <div class=\"row-fluid\">
             <div class=\"span3\">Stop Time:</div>
             <div class=\"span9\">$this->stopTime</div>
         </div>
         ";
 
         $this->cdr_details .= sprintf(
             "
             <div class=\"row-fluid\">
                 <div class=\"span3\">Country:</div>
                     <div class=\"span9\">%s</div>
                 </div>
             ",
             $this->geo_location
         );
 
         $this->cdr_details .= "
         <div class=\"row-fluid\">
             <div class=\"span3\">Method:</div>
             <div class=\"span9\">$this->SipMethod from <i>$this->SourceIP:$this->SourcePort</i></div>
         </div>
         <div class=\"row-fluid\">
             <div class=\"span3\">From:</div>
             <div class=\"span9\">$this->aNumberPrint</div>
         </div>
 
         <div class=\"row-fluid\">
             <div class=\"span3\">From Header:</div>
             <div class=\"span9\">$this->FromHeaderPrint</div>
         </div>
         <div class=\"row-fluid\">
             <div class=\"span3\">User Agent:</div>
             <div class=\"span9\">$this->UserAgentPrint</div>
         </div>
         <div class=\"row-fluid\">
             <div class=\"span3\">Domain:</div>
             <div class=\"span9\">$this->domain</div>
         </div>
         <div class=\"row-fluid\">
             <div class=\"span3\">To (dialed URI):</div>
             <div class=\"span9\">$this->cNumberPrint</div>
         </div>
         ";
 
         if ($perm->have_perm("showCallerId") && $this->SipRPID) {
             $this->cdr_details .= sprintf(
                 "
                 <div class=\"row-fluid\">
                     <div class=\"span3\">PAI Header: </div>
                     <div class=\"span9\">%s</div>
                 </div>
                 ",
                 htmlentities($this->SipRPIDPrint)
             );
         }
 
         if ($this->tlscn) {
             $this->cdr_details .= sprintf(
                 "
                 <div class=\"row-fluid\">
                     <div class=\"span3\">TLS Common Name: </div>
                     <div class=\"span9\">%s</div>
                 </div>
                 ",
                 htmlentities($this->tlscn)
             );
         }
 
         if ($this->CanonicalURI) {
             $this->cdr_details .= sprintf(
                 "
                 <div class=\"row-fluid\">
                     <div class=\"span3\">Canonical URI: </div>
                     <div class=\"span9\">%s</div>
                 </div>
                 ",
                 htmlentities($this->CanonicalURI)
             );
         }
 
         $this->cdr_details .= sprintf(
             "
             <div class=\"row-fluid\">
                 <div class=\"span3\">Next Hop URI:</div>
                 <div class=\"span9\">%s</div>
             </div>
             ",
             htmlentities($this->RemoteAddress)
         );
 
         if ($this->DestinationId) {
             $this->cdr_details .= "
                 <div class=\"row-fluid\">
                     <div class=\"span3\">Destination: </div>
                     <div class=\"span9\">$this->destinationName ($this->DestinationId)</div>
                 </div>
             ";
         }
 
         if ($this->ENUMtld && $this->ENUMtld != 'none' && $this->ENUMtld != 'N/A') {
             $this->cdr_details .= "
                 <div class=\"row-fluid\">
                     <div class=\"span3\">ENUM TLD: </div>
                     <div class=\"span9\">$this->ENUMtld</div>
                 </div>
             ";
         }
 
         if ($this->CalleeCallerId) {
             $this->cdr_details .= "
                 <div class=\"row-fluid\">
                     <div class=\"span3\">Called ID:  </div>
                     <div class=\"span9\">$this->CalleeCallerId</div>
                 </div>
             ";
         }
 
         $this->cdr_details .= "
         <div class=\"row-fluid\">
             <div class=\"span3\">Billing Party:</div>
             <div class=\"span9\"><font color=brown>$this->BillingPartyIdPrint</font></div>
         </div>
         <div class=\"row-fluid\">
             <div class=\"span3\">Reseller:</div>
             <div class=\"span9\"><font color=brown>$this->ResellerId</font></div>
         </div>
         </div>
         ";
 
         $this->cdr_details .= "<div class='span3'>";
 
         if ($this->application != 'message') {
             $this->cdr_details .= "<h5>Media Streams</h5>";
 
             if ($this->CDRS->mediaTrace) {
                 $media_query = array(
                     'cdr_source'    => $this->CDRS->mediaTrace,
                     'callid'        => quoted_printable_decode($this->callId),
                     'fromtag'       => quoted_printable_decode($this->SipFromTag),
                     'totag'         => quoted_printable_decode($this->SipToTag),
                     'proxyIP'       => $this->SipProxyServer
                 );
 
                 $this->mediaTraceLink = sprintf(
                     "<a href=\"javascript:void(null);\" onClick=\"return window.open('media_trace.phtml?%s', '_blank',
                     'toolbar=0,status=0,menubar=0,scrollbars=1,resizable=1,width=800,height=730')\">Click here for media information</a> &nbsp;",
                     http_build_query($media_query)
                 );
 
                 $this->cdr_details .= sprintf(
                     "
                     <div class=\"row-fluid\">
                         <div class='span12'>%s</div>
                     </div>
                     ",
                     $this->mediaTraceLink
                 );
             }
 
             $sessionId = rtrim(base64_encode(hash('md5', $this->callId, true)), "=");
             $this->cdr_details .= "
                 <div class=\"row-fluid\">
                     <div class=\"span5\">Session ID: </div>
                     <div class=\"span7\">$sessionId</div>
                 </div>
             ";
 
             $this->SipCodec = quoted_printable_decode($this->SipCodec);
 
             if ($this->SipCodec) {
                 $this->cdr_details .= "
                 <div class=\"row-fluid\">
                     <div class=\"span5\">Codecs: </div>
                     <div class=\"span7\">$this->SipCodec</div>
                 </div>
                 ";
             }
 
             $this->cdr_details .= "
                 <div class=\"row-fluid\">
                     <div class=\"span5\">Caller RTP: </div>
                     <div class=\"span7\">$this->inputTrafficPrint KB</div>
                 </div>
                 <div class=\"row-fluid\">
                     <div class=\"span5\">Called RTP: </div>
                     <div class=\"span7\">$this->outputTrafficPrint KB</div>
                 </div>
             ";
 
             if ($this->MediaInfo) {
                 $this->cdr_details .= "
                 <div class=\"row-fluid\">
                     <div class=\"span5\">Media Info:</div>
                     <div class=\"span7\"><font color=red>$this->MediaInfo</font></div>
                 </div>
                 ";
             }
 
             $this->cdr_details .= "
             <div class=\"row-fluid\">
                 <div class=\"span5\">Applications: </div>
                 <div class=\"span7\">$this->application_print</div>
             </div>
             ";
         }
 
 
         if ($this->SipUserAgents) {
             $this->SipUserAgents = quoted_printable_decode($this->SipUserAgents);
 
             $callerAgents = explode("+", $this->SipUserAgents);
             $callerUA = htmlentities($callerAgents[0]);
             $calledUA = htmlentities($callerAgents[1]);
 
             $this->cdr_details.= "
             <div class=\"row-fluid\">
                 <div class=\"span5\">Caller SIP UA: </div>
                 <div class=\"span7\">$callerUA</div>
             </div>
             <div class=\"row-fluid\">
                 <div class=\"span5\">Called SIP UA: </div>
                 <div class=\"span7\">$calledUA</div>
             </div>
             ";
         }
 
         $this->cdr_details.= "
         </div>";
 
 
         if ($perm->have_perm("showPrice") && $this->normalized) {
             $this->cdr_details.= "
             <div class=\"span3\">
                     <h5>Rating</h5>
             ";
 
             if ($this->price > 0 || $this->rate) {
                 $this->ratePrint=nl2br($this->rate);
                 $this->cdr_details.= "
                     <div class=\"row-fluid\">
                     $this->ratePrint
                     </div>
                 ";
             } else {
                 $this->cdr_details.= "
                 <div class=\"row-fluid\">
                 Free call
                 </div>
                 ";
             }
 
             $this->cdr_details.= "
             </div>
             ";
         }
 
         $this->cdr_details.=  "
         </div>
         </div>
         ";
     }
 
     function traceIn()
     {
         $datasource=$this->CDRS->traceInURL[$this->SourceIP];
         global $DATASOURCES;
 
         if (!$datasource || !$DATASOURCES[$datasource]) {
             return;
         }
 
         $tplus     = $this->timestamp+$this->duration+300;
         $tmin      = $this->timestamp-300;
         $c_number  = $this->remoteUsername;
         $cdr_table = Date('Ym', time($this->timestamp));
 
         $this->traceIn =
             "<a href=callsearch.phtml".
             "?cdr_source=$datasource".
             "&cdr_table=$cdr_table".
             "&trace=1".
             "&action=search".
             "&c_number=$c_number".
             "&c_number_comp=begins".
             "&begin_datetime=$tmin".
             "&end_datetime=$tplus".
             " target=bottom>".
             "In".
             "</a>";
     }
 
     function traceOut()
     {
         $datasource = $this->CDRS->traceOutURL[$this->remoteGateway];
         global $DATASOURCES;
 
         if (!$datasource || !$DATASOURCES[$datasource]) {
             return;
         }
 
         $tplus     = $this->timestamp+$this->duration+300;
         $tmin      = $this->timestamp-300;
         $c_number  = preg_replace("/^(0+)/", "", $this->remoteUsername);
         $cdr_table = Date('Ym', time($this->timestamp));
 
         $this->traceOut=
                         "<a href=callsearch.phtml".
                         "?cdr_source=$datasource".
                         "&cdr_table=$cdr_table".
                         "&trace=1".
                         "&action=search".
                         "&c_number=$c_number".
                         "&c_number_comp=contain".
                         "&begin_datetime=$tmin".
                         "&end_datetime=$tplus".
                         " target=bottom>".
                         "Out".
                         "</a>";
     }
 
     public function show()
     {
         $this->buildCDRdetail();
 
         global $found;
         global $perm;
 
         $rr = floor($found / 2);
         $mod = $found - $rr * 2;
 
         if ($mod == 0) {
             $inout_color = "#F9F9F9";
         } else {
             $inout_color = "white";
         }
 
         $this->ratePrint = nl2br($this->rate);
 
         if ($this->CDRS->Accounts[$this->BillingPartyId]['timezone']) {
             $timezone_print = $this->CDRS->Accounts[$this->BillingPartyId]['timezone'];
         } else {
             $timezone_print = $this->CDRS->CDRTool['provider']['timezone'];
         }
 
         $found_print = $found;
 
         if ($this->normalized) {
             $found_print .= 'N';
         }
 
         $providerTimezone = $this->CDRS->CDRTool['provider']['timezone'];
 
         print "
         <tr rel=tooltip data-placement='bottom' data-original-title='For more information about this call click the row.'>
         <td valign=top onClick=\"return toggleVisibility('row$found')\"><a href=#>$found_print</a></td>
         <td valign=top onClick=\"return toggleVisibility('row$found')\"><nobr>$this->startTime</nobr></td>
         <td valign=top onClick=\"return toggleVisibility('row$found')\"><nobr>$this->application $this->flow</nobr></td>
         <td valign=top onClick=\"return toggleVisibility('row$found')\"><nobr>$this->aNumberPrint</td>
         <td valign=top onClick=\"return toggleVisibility('row$found')\"><nobr>$this->geo_location</td>
         <td valign=top onClick=\"return toggleVisibility('row$found')\">$this->SipProxyServer</td>
         <td valign=top onClick=\"return toggleVisibility('row$found')\">$this->MediaProxy</td>
         <td valign=top><nobr>$this->destinationPrint</nobr>
         ";
 
         if ($this->DestinationId) {
             if ($this->DestinationId != $this->CanonicalURI) {
                 print " ($this->destinationName $this->DestinationId)";
             } else {
                 print " ($this->destinationName)";
             }
         }
 
         print "</td>";
 
         if (!$this->normalized) {
             if ($this->duration > 0) {
                  print "<td valign=top align=left colspan=4><font color=red>$this->duration(s)</a></td>";
             } else {
                 print "<td valign=top align=left colspan=4><font color=red>in progress</a></td>";
             }
         } else {
             print "
             <td valign=top align=right>$this->durationPrint</td>
             <td valign=top align=right>$this->pricePrint</td>
             <td valign=top align=right>$this->inputTrafficPrint </td>
             <td valign=top align=right>$this->outputTrafficPrint</td>
             ";
         }
 
         $SIPclass=substr($this->disconnect, 0, 1);
 
         if ($SIPclass=="6") {
             $status_color="<span class=\"pull-right label label-important\">";
         } elseif ($SIPclass == "5") {
             $status_color="<span class=\"pull-right label label-important\">";
         } elseif ($SIPclass == "4") {
             $status_color="<span class=\"pull-right label label-info\">";
         } elseif ($SIPclass == "3") {
             $status_color="<span class=\"pull-right label label-success\">";
         } elseif ($SIPclass == "2") {
             $status_color="<span class=\"pull-right label label-success\">";
         } else {
             $status_color="<span class=\"pull-right label\">";
         }
 
         if ($this->disconnectOrig != $this->disconnect
             && $this->CDRS->rating_settings['rate_on_net_diverted_calls']) {
             $disclass = substr($this->disconnectOrig, 0, 1);
             if ($disclass == "6" || $disclass == "5") {
                 $status1_color="<span class=\"pull-right label label-important\">";
             } elseif ($disclass == "4") {
                 $status1_color="<span class=\"pull-right label label-info\">";
             } elseif ($disclass == "3") {
                 $status1_color="<span class=\"pull-right label label-success\">";
             } elseif ($disclass == "2") {
                 $status1_color="<span class=\"pull-right label label-success\">";
             } else {
                 $status1_color="<span class=\"pull-right label\">";
             }
         }
 
         print "
         <td valign=top align=right>$status_color $this->disconnectPrint</span>";
         if ($this->disconnectOrig != $this->disconnect
             && $this->CDRS->rating_settings['rate_on_net_diverted_calls']) {
                 print "$status1_color $this->disconnectOrigPrint</span>";
         }
         print "</td>
         </tr>
         <tr class=extrainfo id='row$found'>
         <td></td>
         <td colspan=13>$this->cdr_details</td>
         </tr>
 
         ";
     }
 
     function export()
     {
         global $found;
         global $perm;
 
         $disconnectName   = $this->CDRS->disconnectCodesDescription[$this->disconnect];
         $UserAgents       = explode("+", $this->SipUserAgents);
         $CallingUserAgent = trim($UserAgents[0]);
         $CalledUserAgent  = trim($UserAgents[1]);
 
         print "$found";
         print ",$this->startTime";
         print ",$this->stopTime";
         print ",$this->BillingPartyIdPrint";
         print ",$this->domain";
         print ",$this->aNumberPrint";
         print ",$this->destinationPrint";
         print ",$this->DestinationId";
         print ",$this->destinationName";
         print ",$this->RemoteAddressPrint";
         print ",$this->CanonicalURIPrint";
         print ",$this->duration";
         print ",$this->price";
         print ",$this->SipProxyServer";
         print ",$this->inputTraffic";
         print ",$this->outputTraffic";
         printf(",%s", preg_replace("/,/", "/", quoted_printable_decode($CallingUserAgent)));
         printf(",%s", preg_replace("/,/", "/", quoted_printable_decode($CalledUserAgent)));
         print ",$this->disconnect";
         print ",$disconnectName";
         printf(",%s", preg_replace("/,/", "/", quoted_printable_decode($this->SipCodec)));
         print ",$this->application";
         print ",$this->MediaProxy";
         print ",$this->tlscn";
 
         if ($perm->have_perm("showCallerId")) {
             print ",$this->SipRPIDPrint";
         }
         print "\n";
     }
 
     function showSubscriber()
     {
         $this->buildCDRdetail();
         global $found;
 
         $rr=floor($found/2);
         $mod=$found-$rr*2;
 
         if ($mod ==0) {
             $inout_color="lightgrey";
         } else {
             $inout_color="white";
         }
 
         if (!$this->CDRS->export) {
             $timezone_print=$this->CDRS->CDRTool['provider']['timezone'];
 
             $found_print=$found;
 
             if ($this->normalized) {
                 $found_print.='N';
             }
 
             print "
             <tr rel=tooltip data-placement='bottom' data-original-title='For more information about this call click the row.'>
             <td valign=top onClick=\"return toggleVisibility('row$found')\"><a href=#>$found_print</a></td>
             <td valign=top onClick=\"return toggleVisibility('row$found')\"><nobr>$this->startTime $timezone_print</nobr></td>
             <td valign=top><nobr>$this->aNumberPrint</nobr></td>
             <td valign=top onClick=\"return toggleVisibility('row$found')\"><nobr>$this->geo_location</td>
             <td valign=top onClick=\"return toggleVisibility('row$found')\">$this->SipProxyServer</td>
             <td valign=top><nobr>$this->destinationPrint $this->destinationName</td>
             <td valign=top align=right>$this->durationPrint</td>
             ";
 
             if ($this->CDRS->rating) {
                 print "<td valign=top align=right>$this->pricePrint</td>";
             }
 
             print "
             <td valign=top align=right>$this->inputTrafficPrint </td>
             <td valign=top align=right>$this->outputTrafficPrint</td>
             </tr>
             ";
             print "
             <tr class=extrainfo id='row$found'>
             <td></td>
             <td colspan=11>$this->cdr_details</td>
             </tr>
             ";
         } else {
             $disconnectName = $this->CDRS->disconnectCodesDescription[$this->disconnect];
             $UserAgents = explode("+", $this->SipUserAgents);
             $CallingUserAgent = trim($UserAgents[0]);
             $CalledUserAgent = trim($UserAgents[1]);
             print "$found";
             print ",$this->startTime";
             print ",$this->stopTime";
             print ",$this->BillingPartyId";
             print ",$this->domain";
             print ",$this->aNumberPrint";
             print ",$this->cNumberPrint";
             print ",$this->DestinationId";
             print ",$this->destinationName";
             print ",$this->RemoteAddressPrint";
             print ",$this->duration";
             print ",$this->price";
             print ",$this->SipProxyServer";
             print ",$this->inputTraffic";
             print ",$this->outputTraffic";
             print ",$CallingUserAgent";
             print ",$CalledUserAgent";
             print ",$this->disconnect";
             print ",$disconnectName";
             print ",$this->SipCodec";
             print ",$this->application\n";
         }
     }
 
     function isBillingPartyLocal()
     {
         $els = explode("@", $this->BillingPartyId);
 
         if ($els[1] && isset($this->CDRS->localDomains[$els[1]])) {
             return true;
         }
 
         return false;
     }
 
     function isCallerLocal()
     {
         if (isset($this->CDRS->localDomains[$this->aNumberDomain])) {
             $this->CallerIsLocal = true;
             $this->SipRPID = $this->CDRS->getCallerId($this->BillingPartyId);
             #$this->SipRPIDPrint = quoted_printable_decode($this->SipRPID);
         }
         $this->SipRPIDPrint = $this->SipRPID;
     }
 
     function isCalleeLocal()
     {
         if (isset($this->CDRS->localDomains[$this->CanonicalURIDomain]) && !preg_match("/^0/", $this->CanonicalURIUsername)) {
             $this->CalleeIsLocal = true;
             $this->CalleeCallerId = $this->CDRS->getCallerId($this->CanonicalURI);
         }
     }
 
     function obfuscateCallerId()
     {
         global $obfuscateCallerId;
         if ($obfuscateCallerId) {
             //Caller party
             $caller_els=explode("@", $this->aNumberPrint);
 
             if (is_numeric($caller_els[0]) && strlen($caller_els[0]>3)) {
                 $_user = substr($caller_els[0], 0, strlen($caller_els[0])-3).'xxx';
             } else {
                 $_user = 'caller';
             }
 
             if (count($caller_els) == 2) {
                 $this->aNumberPrint = $_user.'@'.$caller_els[1];
             } else {
                 $this->aNumberPrint = $_user;
             }
 
             //Billing party
             $caller_els = explode("@", $this->BillingPartyIdPrint);
 
             if (is_numeric($caller_els[0]) && strlen($caller_els[0]>3)) {
                 $_user = substr($caller_els[0], 0, strlen($caller_els[0])-3).'xxx';
             } else {
                 $_user = 'party';
             }
 
             $this->BillingPartyIdPrint = $_user.'@'.$caller_els[1];
 
             // Destination
             $caller_els = explode("@", $this->destinationPrint);
 
             if (is_numeric($caller_els[0]) && strlen($caller_els[0]>3)) {
                 $_user = substr($caller_els[0], 0, strlen($caller_els[0])-3).'xxx';
             } else {
                 $_user = 'destination';
             }
 
             if (count($caller_els) == 2) {
                 $this->destinationPrint = $_user.'@'.$caller_els[1];
             } else {
                 $this->destinationPrint = $_user;
             }
 
             $caller_els = explode("@", $this->cNumberPrint);
 
             if (is_numeric($caller_els[0]) && strlen($caller_els[0]>3)) {
                 $_user = substr($caller_els[0], 0, strlen($caller_els[0])-3).'xxx';
             } else {
                 $_user = 'dialedNumber';
             }
 
             if (count($caller_els) == 2) {
                 $this->cNumberPrint = $_user.'@'.$caller_els[1];
             } else {
                 $this->cNumberPrint = $_user;
             }
 
             $caller_els = explode("@", $this->RemoteAddressPrint);
 
             if (is_numeric($caller_els[0]) && strlen($caller_els[0]>3)) {
                 $_user = substr($caller_els[0], 0, strlen($caller_els[0])-3).'xxx';
             } else {
                 $_user = 'remoteAddress';
             }
 
             if (count($caller_els) == 2) {
                 $this->RemoteAddressPrint = $_user.'@'.$caller_els[1];
             } else {
                 $this->RemoteAddressPrint = $_user;
             }
 
             // Canonical URI
             $caller_els = explode("@", $this->CanonicalURIPrint);
 
             if (is_numeric($caller_els[0]) && strlen($caller_els[0]>3)) {
                 $_user = substr($caller_els[0], 0, strlen($caller_els[0])-3).'xxx';
             } else {
                 $_user = 'canonicalURI';
             }
 
             if (count($caller_els) == 2) {
                 $this->CanonicalURIPrint = $_user.'@'.$caller_els[1];
             } else {
                 $this->CanonicalURIPrint = $_user;
             }
 
             if (is_numeric($this->SipRPIDPrint) && strlen($this->SipRPIDPrint) > 3) {
                 $this->SipRPIDPrint = substr($this->SipRPID, 0, strlen($this->SipRPID)-3).'xxx';
             } else {
                 $_user = 'callerId';
             }
 
             // IP address
             $this->SourceIP = 'xxx.xxx.xxx.xxx';
         }
     }
 }
 
 class SIP_trace
 {
     public $enableThor  = false;
     public $trace_array = array();
     public $traced_ip   = array();
     public $SIPProxies  = array();
     public $mediaTrace  = false;
     public $thor_nodes  = array();
     public $hostnames   = array();
+    public $proxyGroups = array();
 
     public function __construct($cdr_source)
     {
         global $DATASOURCES, $auth;
         require_once 'errors.php';
 
         $this->cdr_source = $cdr_source;
         $this->cdrtool    = new DB_CDRTool();
 
         if (!is_array($DATASOURCES[$this->cdr_source])) {
             $log = sprintf("Error: datasource '%s' is not defined\n", $this->cdr_source);
             print $log;
             throw new DataSourceUndefinedError($log);
             return 0;
         }
 
         if (strlen($DATASOURCES[$this->cdr_source]['enableThor'])) {
             $this->enableThor = $DATASOURCES[$this->cdr_source]['enableThor'];
         }
 
         if (strlen($DATASOURCES[$this->cdr_source]['mediaTrace'])) {
             $this->mediaTrace = $DATASOURCES[$this->cdr_source]['mediaTrace'];
         }
 
+        if (is_array($DATASOURCES[$this->cdr_source]['proxyGroups'])) {
+            $this->proxyGroups = $DATASOURCES[$this->cdr_source]['proxyGroups'];
+        }
+
         if ($this->enableThor) {
             require '/etc/cdrtool/ngnpro_engines.inc';
             require_once 'ngnpro_soap_library.php';
             if ($DATASOURCES[$this->cdr_source]['soapEngineId'] && in_array($DATASOURCES[$this->cdr_source]['soapEngineId'], array_keys($soapEngines))) {
                 $this->soapEngineId=$DATASOURCES[$this->cdr_source]['soapEngineId'];
 
                 $this->SOAPlogin = array(
                     "username"    => $soapEngines[$this->soapEngineId]['username'],
                     "password"    => $soapEngines[$this->soapEngineId]['password'],
                     "admin"       => true
                 );
 
                 $this->SOAPurl=$soapEngines[$this->soapEngineId]['url'];
 
                 $this->SoapAuth = array('auth', $this->SOAPlogin , 'urn:AGProjects:NGNPro', 0, '');
 
                 // Instantiate the SOAP client
                 $this->soapclient = new WebService_NGNPro_SipPort($this->SOAPurl);
 
                 $this->soapclient->setOpt('curl', CURLOPT_TIMEOUT, 5);
                 $this->soapclient->setOpt('curl', CURLOPT_SSL_VERIFYPEER, 0);
                 $this->soapclient->setOpt('curl', CURLOPT_SSL_VERIFYHOST, 0);
 
                 if (is_array($soapEngines[$this->soapEngineId]['hostnames'])) {
                     $this->hostnames=$soapEngines[$this->soapEngineId]['hostnames'];
                 }
             } else {
                 printf("<p><font color=red>Error: soapEngineID not defined in datasource %s</font>", $this->cdr_source);
                 return false;
             }
         } else {
             $this->table             = $DATASOURCES[$this->cdr_source]['table'];
             $db_class                = $DATASOURCES[$this->cdr_source]['db_class'];
             $this->purgeRecordsAfter = $DATASOURCES[$this->cdr_source]['purgeRecordsAfter'];
 
             if (class_exists($db_class)) {
                 $this->db                = new $db_class;
             } else {
                 printf("<p><font color=red>Error: database class '%s' is not defined</font>", $db_class);
                 return false;
             }
         }
 
         if (is_object($auth)) {
             $this->isAuthorized=1;
         }
 
         if (is_array($DATASOURCES[$this->cdr_source]['SIPProxies'])) {
             $this->SIPProxies = $DATASOURCES[$this->cdr_source]['SIPProxies'];
         }
     }
 
     private function isProxy($ip, $sip_proxy = '')
     {
         if (!$ip) {
             return false;
         }
 
         if (!$this->enableThor) {
             if (!is_array($this->SIPProxies)) {
                 return false;
             }
 
             if (in_array($ip, array_keys($this->SIPProxies))) {
                 return true;
             }
         } elseif ($sip_proxy) {
             if (isset($this->thor_nodes[$ip])) {
                 return true;
             } else {
                 if (isThorNode($ip, $sip_proxy) || isThorNode($ip, $sip_proxy, 'msteams_gateway')) {
                     $this->thor_nodes[$ip]=1;
                     return true;
                 } else {
                     return false;
                 }
             }
         }
 
         return false;
     }
 
     private function getTrace($proxyIP, $callid, $fromtag, $totag)
     {
         if ($this->enableThor) {
             // get trace using soap request
             if (!$proxyIP || !$callid || !$fromtag) {
                 return false;
             }
 
             global $DATASOURCES;
             if (is_array($DATASOURCES[$this->cdr_source]['proxyTranslation_IP'])
                 && isset($DATASOURCES[$this->cdr_source]['proxyTranslation_IP'][$proxyIP])
                 && strlen($DATASOURCES[$this->cdr_source]['proxyTranslation_IP'][$proxyIP])
             ) {
                 $proxyIP = $DATASOURCES[$this->cdr_source]['proxyTranslation_IP'][$proxyIP];
             }
             if (!is_object($this->soapclient)) {
                 print "Error: soap client is not defined.";
                 return false;
             }
 
             $filter = array(
                 'nodeIp'  => $proxyIP,
                 'callId'  => $callid,
                 'fromTag' => $fromtag,
                 'toTag'   => $totag
             );
             $this->soapclient->addHeader($this->SoapAuth);
 
             $result = $this->soapclient->getSipTrace($filter);
 
             if ((new PEAR)->isError($result)) {
                 $error_msg   = $result->getMessage();
                 $error_fault = $result->getFault();
                 $error_code  = $result->getCode();
 
                 printf(
                     "
                     <div style='display: flex; align-items: center; justify-content: center;'>
                         <div class='span10' style='padding-top:40px;'>
                             <div class='alert alert-danger'><h4>Error from %s</h4><br/>%s (%s)</div>
                         </div>
                     </div>
                     ",
                     $this->SOAPurl,
                     $error_fault->detail->exception->errorstring,
                     $error_fault->detail->exception->errorcode
                 );
                 return false;
             }
 
             $columns = 0;
 
             $traces = json_decode($result);
 
             $trace_array = array();
 
             foreach ($traces as $_trace) {
                 if (preg_match("/^(udp|tcp|tls):(.*):(.*)$/", $_trace->to_ip, $m)) {
                     $toip      = $m[2];
                     $transport = $m[1];
                     $toport    = $m[3];
                 } elseif (preg_match("/^(.*):(.*)$/", $_trace->to_ip, $m)) {
                     $toip      = $m[1];
                     $transport = 'udp';
                     $toport    = $m[2];
                 } else {
                     $toip      = $_trace->to_ip;
                     $transport = $_trace->to_proto;
                     $toport    = $_trace->to_port;
                 }
 
                 if (preg_match("/^(udp|tcp|tls):(.*):(.*)$/", $_trace->from_ip, $m)) {
                     $fromip    = $m[2];
                     $fromport  = $m[3];
                 } elseif (preg_match("/^(.*):(.*)$/", $_trace->from_ip, $m)) {
                     $fromip    = $m[1];
                     $fromport  = $m[2];
                 } else {
                     $fromip    = $_trace->from_ip;
                     $fromport  = $_trace->from_port;
                 }
 
+                if (isset($this->proxyGroups[$fromip])) {
+                    $fromip = $this->proxyGroups[$fromip];
+                }
+
+                if (isset($this->proxyGroups[$toip])) {
+                    $toip = $this->proxyGroups[$toip];
+                }
+
                 if (!isset($this->column[$fromip])) {
                     $this->column[$fromip] = $columns + 1;
                     $this->column_port[$fromip] = $fromport;
                     $columns++;
                 }
 
                 if (!isset($this->column[$toip])) {
                     $this->column[$toip]   = $columns+1;
                     $this->column_port[$toip] = $toport;
                     $columns++;
                 }
 
                 preg_match("/^(\d+)-(\d+)-(\d+) (\d+):(\d+):(\d+)$/", $_trace->time_stamp, $m);
                 $timestamp = mktime($m[4], $m[5], $m[6], $m[2], $m[3], $m[1]);
 
                 $idx=$proxyIP.'_'.$_trace->id;
 
                 $trace_array[$idx] = array (
                     'id'         => $idx,
                     'direction'  => $_trace->direction,
                     'fromip'     => $fromip,
                     'toip'       => $toip,
                     'fromport'   => $fromport,
                     'toport'     => $toport,
                     'method'     => $_trace->method,
                     'transport'  => $transport,
                     'date'       => $_trace->time_stamp,
                     'status'     => $_trace->status,
                     'timestamp'  => $timestamp,
                     'msg'        => $_trace->message,
                     'md5'        => md5($_trace->message)
                 );
             }
 
             $this->trace_array=$trace_array;
             $this->rows = count($this->trace_array);
         } else {
             // get trace from SQL
 
             if (!is_object($this->db)) {
                 print "<p><font color=red>Error: no database connection defined</font>";
                 return false;
             }
 
             $query = sprintf(
                 "
                 select
                     *,
                     UNIX_TIMESTAMP(time_stamp) as timestamp
                 from
                     %s
                 where
                     callid = '%s'
                 order by id asc
                 ",
                 addslashes($this->table),
                 addslashes($callid)
             );
 
             if (!$this->db->query($query)) {
                 printf("Database error for query %s: %s (%s)", $query, $this->db->Error, $this->db->Errno);
                 return false;
             }
 
             $this->rows = $this->db->num_rows();
 
             $columns = 0;
 
             while ($this->db->next_record()) {
                 if (preg_match("/^(udp|tcp|tls):(.*):(.*)$/", $this->db->f('toip'), $m)) {
                     $toip      = $m[2];
                     $transport = $m[1];
                     $toport    = $m[3];
                 } elseif (preg_match("/^(.*):(.*)$/", $this->db->f('toip'), $m)) {
                     $toip      = $m[1];
                     $transport = 'udp';
                     $toport    = $m[2];
                 } else {
                     $toip = $this->db->f('toip');
                     $toport    = '5060';
                 }
 
                 if (preg_match("/^(udp|tcp|tls):(.*):(.*)$/", $this->db->f('fromip'), $m)) {
                     $fromip   = $m[2];
                     $fromport = $m[3];
                 } elseif (preg_match("/^(.*):(.*)$/", $this->db->f('fromip'), $m)) {
                     $fromip   = $m[1];
                     $fromport = $m[2];
                 } else {
                     $fromip = $this->db->f('fromip');
                     $transport = 'udp';
                     $fromport = '5060';
                 }
 
                 if (!$this->column[$fromip]) {
                     $this->column[$fromip]=$columns+1;
                     $this->column_port[$fromip]=$fromport;
                     $columns++;
                 }
 
                 if (!$this->column[$toip]) {
                     $this->column[$toip] = $columns + 1;
                     $this->column_port[$toip]=$toport;
                     $columns++;
                 }
 
                 $this->trace_array[$this->db->f('id')] =
                     array (
                         'id'        => $this->db->f('id'),
                         'direction' => $this->db->f('direction'),
                         'fromip'    => $fromip,
                         'toip'      => $toip,
                         'method'    => $this->db->f('method'),
                         'fromport'  => $fromport,
                         'toport'    => $toport,
                         'transport' => $transport,
                         'date'      => $this->db->f('time_stamp'),
                         'status'    => $this->db->f('status'),
                         'timestamp' => $this->db->f('timestamp'),
                         'msg'       => $this->db->f('msg'),
                         'md5'       => md5($this->db->f('msg'))
                     );
             }
         }
     }
 
     private function printLabelProtocolPort($transport, $port)
     {
         echo '<span class="label">';
         if ($transport == 'tls') {
             echo "<span><i class='icon-lock'></i></span>&nbsp;";
         }
         printf('%s: %d', strtoupper($transport), $port);
         echo '</span>';
     }
 
     public function show($proxyIP, $callid, $fromtag, $totag)
     {
         $action           = $_REQUEST['action'];
         $toggleVisibility = $_REQUEST['toggleVisibility'];
 
         if ($action == 'toggleVisibility') {
             $this->togglePublicVisibility($callid, $fromtag, $toggleVisibility);
         }
 
         if ($_SERVER['HTTPS'] == "on") {
             $protocolURL = "https://";
         } else {
             $protocolURL = "http://";
         }
 
         $this->getTrace($proxyIP, $callid, $fromtag, $totag);
 
         /* No trace can be found */
 
         if (!count($this->trace_array)) {
             echo "
                 <div style='display: flex; align-items: center; justify-content: center;'>
                     <div class='span10' style='padding-top:40px;'>
                         <p class='alert'>SIP trace for session id <strong>$callid</strong> is not available.</p>
                     </div>
                 </div>
             ";
             return;
         }
 
         echo "
             <div class=container-fluid>
                 <div id=trace class=main>
                     <h1 class='page-header'>CDRTool SIP trace<br /><small>Call ID: $callid $authorize</small></h1>
                         <div class=row-fluid>
                             <div class=span9>
         ";
         $basicURL = $protocolURL.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'];
 
         $fullURL = $basicURL;
         print "URLs for this trace: <a href=$fullURL>HTML</a> | <a href=$fullURL&format=text>TEXT</a></td>";
 
         if ($this->mediaTrace) {
             $media_query = array(
                 'cdr_source'    => $this->mediaTrace,
                 'callid'        => $callid,
                 'fromtag'       => $fromtag,
                 'totag'         => $totag,
                 'proxyIP'       => $proxyIP
             );
             $this->mediaTraceLink = sprintf(
                 "<p class=pull-right>
                     <a href=\"javascript:void(null);\" onClick=\"return window.open('media_trace.phtml?%s', 'mediatrace','toolbar=0,status=0,menubar=0,scrollbars=1,resizable=1,width=800,height=730')\">
                     Click here for RTP media information
                     </a>
                 </p>",
                 http_build_query($media_query)
             );
         }
 
         print "
             </div>
             <div class='span3'>
                 <p class='pull-right'>Click on each packet to expand its body content</p>
                 $this->mediaTraceLink
             </div>
         </div>
         ";
 
         foreach (array_keys($this->trace_array) as $key) {
             $this->trace_array[$key]['isProxy'] = 0;
             
             if ($this->trace_array[$key]['direction'] == 'in') {
                 if (is_array($this->SIPProxies)) {
                     $thisIP=explode(":", $this->trace_array[$key]['fromip']);
                     if ($this->isProxy($thisIP[0], $proxyIP)) {
                         $this->trace_array[$key]['isProxy'] = 1;
                     }
                 }
                 
                 $this->trace_array[$key]['msg_possition']   = $this->column[$this->trace_array[$key]['toip']];
                 $this->trace_array[$key]['arrow_possition'] = $this->column[$this->trace_array[$key]['fromip']];
                 $this->trace_array[$key]['arrow_direction'] = $arrow_direction;
 
                 // handle self-generated BYE
                 if ($this->trace_array[$key]['fromip'] == $this->trace_array[$key]['toip']) {
                     if ($this->trace_array[$key]['method'] == 'BYE') {
                         $bye_ip = $this->trace_array[$key]['fromip'];
                         $bye_lines = preg_split('/\n|\r\n?/', $this->trace_array[$key]['msg']);
 
                         $bye_line = $bye_lines[0];
                         $fi=$this->trace_array[$key]['fromip'];
                         $fp=$this->trace_array[$key]['fromport'];
                         $ti=$this->trace_array[$key]['toip'];
                         $tp=$this->trace_array[$key]['toport']; 
 
                         if (preg_match("/^BYE (sip:|sips:)(.*)\@(.*):(\d*)(.*)$/", $bye_line, $m)) {
                             $bye_ip = $m[3];
                             $bye_port = $m[4];  
                             if ($this->column[$bye_ip]){
                                 $this->trace_array[$key]['fromip'] = $bye_ip;
                                 $this->trace_array[$key]['fromport'] = $bye_port;
                                 $this->trace_array[$key]['arrow_possition'] = $this->column[$bye_ip]; 
                             } else {
                                 $found_bye_ip = false;
                                 foreach ($bye_lines as $_line) {
                                     if (preg_match("/^Route:(.*)$/", $_line, $mr)) {
                                         $line = str_replace(array('<', '>'), "", $mr[1]);
                                         $routes = explode(",", $line);
                                         foreach ($routes as $r) {
                                             if (preg_match("/(.*sip:|sips:)(.*):(\d+)(.*)$/", $r, $mm)) {
                                                 $bye_ip = $mm[2];
                                                 $bye_port = $mm[3];
                                                 if ($this->column[$bye_ip]){
                                                     $this->trace_array[$key]['fromip'] = $bye_ip;
                                                     $this->trace_array[$key]['fromport'] = $bye_port;
                                                     $this->trace_array[$key]['arrow_possition'] = $this->column[$bye_ip]; 
                                                     $found_bye_ip = true;
                                                     break;
                                                 }
                                             }
                                         }
                                         
                                         if ($found_bye_ip) {
                                             break;
                                         } 
                                     }
                                 }
                             }
                         } else {
                             $arrow_direction = "loop";
                         }
 
                         if ($this->column[$this->trace_array[$key]['fromip']] < $this->column[$proxyIP]) {
                             $arrow_direction = "left";
                         } else {
                             $arrow_direction = "right";
                         }
                     } else {
                         $arrow_direction = "loop";
                     }
                 } elseif ($this->column[$this->trace_array[$key]['fromip']] < $this->column[$this->trace_array[$key]['toip']]) {
                     $arrow_direction = "right";
                 } else {
                     $arrow_direction = "left";
                 }
                 
                 $this->trace_array[$key]['arrow_direction'] = $arrow_direction;
                 
             } else {
                 if ($this->trace_array[$key]['fromip'] == $this->trace_array[$key]['toip']) {
                     $arrow_direction = "loop";
                 } elseif ($this->column[$this->trace_array[$key]['fromip']] < $this->column[$this->trace_array[$key]['toip']]) {
                     $arrow_direction = "right";
                 } else {
                     $arrow_direction = "left";
                 }
 
                 $this->trace_array[$key]['msg_possition']   = $this->column[$this->trace_array[$key]['fromip']];
                 $this->trace_array[$key]['arrow_possition'] = $this->column[$this->trace_array[$key]['toip']];
                 $this->trace_array[$key]['arrow_direction'] = $arrow_direction;
             }
         }
         echo "
             <table class='table siptrace'>
             <thead>
                 <tr>
                     <th>Packet</th>
                     <th>Time</th>
         ";
 
         $_seen_timeline = array();
         foreach (array_keys($this->column) as $_key) {
             $IPels = explode(":", $_key);
 
             if (isset($this->hostnames[$IPels[0]])) {
                 $_hostname = $this->hostnames[$IPels[0]];
             } else {
                 $_hostname = $_key;
             }
 
             print "<th style='text-align: center' colspan=\"2\">";
             if ($proxyIP != $IPels[0] && $this->isProxy($IPels[0], $proxyIP)) {
                 $trace_query = array(
                     'cdr_source'    => $this->cdr_source,
                     'callid'        => $callid,
                     'fromtag'       => $fromtag,
                     'totag'         => $totag,
                     'proxyIP'       => $IPels[0]
                 );
                 $trace_link = sprintf(
                     "<a href=\"javascript:void(null);\" onClick=\"return window.open('sip_trace.phtml?%s', '_self',
                     'toolbar=0,status=1,menubar=1,scrollbars=1,resizable=1,width=1000,height=600')\">%s:%s</a>",
                     http_build_query($trace_query),
                     $_hostname,
                     $this->column_port[$_key]
                 );
                 printf("%s", $trace_link);
             } else {
                 printf("%s", $_hostname);
             }
             print "</th>";
         }
 
         print "</tr>
             </thead>";
 
         /* Rows */
 
         $i=0;
         foreach (array_keys($this->trace_array) as $key) {
             $i++;
 
             $id        = $this->trace_array[$key]['id'];
             $msg       = $this->trace_array[$key]['msg'];
             $fromip    = $this->trace_array[$key]['fromip'];
             $toip      = $this->trace_array[$key]['toip'];
             $date      = substr($this->trace_array[$key]['date'], 11);
             $status    = $this->trace_array[$key]['status'];
             $direction = $this->trace_array[$key]['direction'];
             $timestamp = $this->trace_array[$key]['timestamp'];
             $method    = $this->trace_array[$key]['method'];
             $isProxy   = $this->trace_array[$key]['isProxy'];
             $transport = $this->trace_array[$key]['transport'];
 
             $msg_possition   = $this->trace_array[$key]['msg_possition'];
             $arrow_possition = $this->trace_array[$key]['arrow_possition'];
             $arrow_direction = $this->trace_array[$key]['arrow_direction'];
             $md5             = $this->trace_array[$key]['md5'];
 
             if ($i == 1) {
                 $begin_timestamp = $timestamp;
             }
             $timeline = $timestamp - $begin_timestamp;
 
             $sip_phone_img = getImageForUserAgent($msg);
 
             if ($seen_msg[$md5]) {
                 continue;
             }
 
             $SIPclass = substr($status, 0, 1);
             switch ($SIPclass) {
                 case 6:
                     $status_color = "red";
                     break;
                 case 5:
                     $status_color = "red";
                     break;
                 case 4:
                     $status_color = "red";
                     break;
                 case 3:
                     $status_color = "green";
                     break;
                 case 2:
                     $status_color = "green";
                     break;
                 case 1:
                     $status_color = "orange";
                     break;
                 default:
                     $status_color = "blue";
                     if ($method == "ACK") {
                         $status_color = 'cyan';
                     } else if ($method == "CANCEL") {
                         $status_color = 'magenta';
                     }
                     break;
             }
 
             $_lines = explode("\n", $msg);
 
             if (preg_match("/^(.*) SIP/", $_lines[0], $m)) {
                 $_lines[0] = $m[1];
             } elseif (preg_match("/^SIP\/2\.0 (.*)/", $_lines[0], $m)) {
                 $_lines[0] = $m[1];
             }
 
             unset($media);
             unset($diversions);
 
             $media_index=0;
             $search_ice=0;
             $search_ip=0;
             $contact_header='';
 
             foreach ($_lines as $_line) {
                 if (preg_match("/^(Diversion: ).*;(.*)$/", $_line, $m)) {
                     $diversions[]=$m[1].$m[2];
                 }
 
                 if (preg_match("/^Cseq:\s*\d+\s*(.*)$/i", $_line, $m)) {
                     $status_for_method=$m[1];
                 }
 
                 if (preg_match("/^c=IN \w+ ([\d|\w\.]+)/i", $_line, $m)) {
                     $media['ip']=$m[1];
                 }
 
                 if (preg_match("/^m=(\w+) (\d+) /i", $_line, $m)) {
                     $media_index++;
                     $search_ice=1;
                     $search_ip=1;
                     $media['streams'][$media_index] = array(
                         'type' => $m[1],
                         'ip'   => $media['ip'],
                         'port' => $m[2],
                         'ice'  => ''
                     );
                 }
 
                 if ($search_ip && preg_match("/^c=IN \w+ ([\d|\w\.]+)/i", $_line, $m)) {
                     $media['streams'][$media_index]['ip']=$m[1];
                     $search_ip=0;
                 }
 
                 if ($search_ice && preg_match("/^a=ice/i", $_line, $m)) {
                     $media['streams'][$media_index]['ice']="ICE";
                     $search_ice=0;
                 }
             }
 
 
             $_els = explode(";", $_lines[0]);
 
             $cell_content = "<div id=\"packet$i\"><span>$_els[0]</span>";
 
             if ($status) {
                 $cell_content .= " <font color=black>for ".$status_for_method."</font>";
             }
 
             if (is_array($diversions)) {
                 foreach ($diversions as $_diversion) {
                     $cell_content.="<br><em class='gray'>$_diversion</em>";
                 }
             }
 
             if (is_array($media['streams'])) {
                 foreach (array_keys($media['streams']) as $_key) {
                     $_stream = sprintf(
                         "%s: %s:%s %s",
                         $media['streams'][$_key]['type'],
                         $media['streams'][$_key]['ip'],
                         $media['streams'][$_key]['port'],
                         $media['streams'][$_key]['ice']
                     );
                     if ($media['streams'][$_key]['port']) {
                         $cell_content.="<br><em class='gray'>$_stream</em>";
                     } else {
                         $cell_content.="<br><em style='text-decoration: line-through'>$_stream</em>";
                     }
                 }
             }
 
             $cell_content.="
             </div>
             ";
 
             print "
                 <tr onClick=\"return toggleVisibility('row$i')\">
             ";
 
             $packet_length = strlen($msg);
 
             print "
                 <td><span>$i/$this->rows&nbsp;</span></td>
                 <td><span><nobr>$date</nobr></span>";
             if ($timeline && !isset($_seen_timeline[$timeline])) {
                 printf("&nbsp;&nbsp;<span class='badge badge-info'>+%ds</span>", $timeline);
                 $_seen_timeline[$timeline] = 1;
             }
 
             print "<br /><nobr>$packet_length bytes</nobr></td>
             ";
 
             $column_current = 1;
             while ($column_current <= count($this->column)) {
                 if ($arrow_possition == $column_current) {
                     /* First cell, first port, append extra cell */
                     if ($column_current < count($this->column) && $column_current < $msg_possition) {
                         print "<td style='text-align: right' class='span2'>";
                         if ($direction == 'in') {
                             $this->printLabelProtocolPort($transport, $this->trace_array[$key]['fromport']);
                         } else {
                             $this->printLabelProtocolPort($transport, $this->trace_array[$key]['toport']);
                         }
                         echo "</td>";
                     }
 
                     $arrowColor = $status_color;
 
                     if ($arrow_direction == 'loop') {
                         print "<td><i style='font-size: 2.4em' class=\"icon-refresh pull-right\"></i></td>";
                     }
 
                     if ($arrow_possition >= 2 * $msg_possition) {
                         $arrow_span = ($arrow_possition * 2) - 4;
                         echo "<td colspan='$arrow_span' style='border-left: 2px solid #95b3d0; border-right: 2px solid #95b3d0; width:66%'>";
                     } else {
                         echo "<td colspan='2' style='border-left: 2px solid #95b3d0; border-right: 2px solid #95b3d0; width:33%'>";
                     }
 
 
                     if ($arrow_direction != 'loop') {
                         print "<div class='sarrow $arrowColor $arrow_direction'></div>";
                     }
 
                     if ($arrow_direction == "left") {
                         print "<div style='text-align: right; padding-right:16px;'>$cell_content</div>";
                     } else {
                         print "<div style='float:left; padding-left:16px;'>$cell_content</div>";
                     }
                     echo "</td>";
 
                     if ($column_current < count($this->column) && $column_current > $msg_possition) {
                         print "<td class='span2'>";
                         if ($direction == 'in') {
                             $this->printLabelProtocolPort($transport, $this->trace_array[$key]['fromport']);
                         } else {
                             $this->printLabelProtocolPort($transport, $this->trace_array[$key]['toport']);
                         }
                         echo "</td>";
                     }
                 } else {
                     if ($msg_possition == $column_current) {
                         if ($msg_possition < $arrow_possition) {
                             print "<td style='width: 17%;text-align: right'>";
                             if ($direction == 'out') {
                                 $this->printLabelProtocolPort($transport, $this->trace_array[$key]['fromport']);
                             } else {
                                 $this->printLabelProtocolPort($transport, $this->trace_array[$key]['toport']);
                             }
                         } else {
                             print "<td style='width: 17%'>";
                             if ($direction == 'out') {
                                 $this->printLabelProtocolPort($transport, $this->trace_array[$key]['fromport']);
                             } else {
                                 $this->printLabelProtocolPort($transport, $this->trace_array[$key]['toport']);
                             }
                         }
                     } elseif ($arrow_possition != $column_current
                         && ( $column_current == 1
                         || ( $arrow_possition < $column_current
                         && $arrow_possition != $msg_possition)
                     )) {
                         print "<td style='width: 17%; border-right: 2px solid #95b3d0'>";
                         print "</td><td>";
                         print "&nbsp;";
                     } elseif ($arrow_possition == $msg_possition) {
                         echo "<td></td>";
                     #} elseif ($column_current != $this->column[$fromip] && $column_current != $this->column[$toip]) {
                     #    echo "<td colspan=2 border-left: 2px solid #95b3d0'></td>";
                     }
                     echo "</td>";
                 }
 
                 if ($arrow_possition == $column_current && $column_current == count($this->column)) {
                     echo "<td style='width:17%'>";
                     if ($direction == 'in') {
                         $this->printLabelProtocolPort($transport, $this->trace_array[$key]['fromport']);
                     } else {
                         $this->printLabelProtocolPort($transport, $this->trace_array[$key]['toport']);
                     }
                     echo "</td>";
                 }
                 $column_current++;
                 if ($arrow_direction == 'loop') {
                     $seen_msg[$md5]++;
                 }
             }
 
             echo "</tr>";
 
             if (is_array($this->SIPProxies)) {
                 $IPels = explode(":", $fromip);
                 $justIP = $IPels[0];
                 foreach (array_keys($this->SIPProxies) as $localProxy) {
                     if ($localProxy == $justIP) {
                         $direction="out";
                         break;
                     }
                 }
             }
 
             /* Details */
 
             $trace_span = count($this->column) * 2 + 3;
 
             print "
             <tr class='extrainfo $status_color' id=row$i>
                 <td colspan=$trace_span>
                     <div class='row-fluid'>
                         <div class='span2' style='max-width: 120px; padding-left: 15px;'>
             ";
 
             if ($direction == "out" or $isProxy) {
                 print "<nobr><h1>SIP Proxy</h1></nobr>";
             } else {
                 if ($sip_phone_img && $sip_phone_img!='unknown.png') {
                     print "<img style='max-width:none' src=images/$sip_phone_img>";
                 } else {
                     print "<i style=\"font-size:28px\" class=\"icon-question\"></i>";
                 }
             }
             print "<br />";
             if ($timeline > 0) {
                 printf("<p>+%s s<br>(%s)</p>", $timeline, sec2hms($timeline));
             }
             print "</div><div class=span10 style='font-family: monospace; color: #333333;'>";
 
             $msg = nl2br(htmlentities($msg));
 
             print "<span>$msg</span>
                 </div>
                 </div>";
 
             echo "
                 </td>
             </tr>
             ";
         }
 
         print "
         </table>
         ";
     }
 
     public function showText($proxyIP, $callid, $fromtag, $totag)
     {
         $this->getTrace($proxyIP, $callid, $fromtag, $totag);
         print "<pre>";
 
         if (!count($this->trace_array)) {
             print "SIP trace for session id $callid is not available.";
             return false;
         }
 
         printf("SIP trace on proxy %s for session %s\n--\n\n", $proxyIP, $callid);
 
         foreach (array_keys($this->trace_array) as $key) {
             $i++;
             printf(
                 "Packet %d at %s from %s to %s (%s)\n",
                 $i,
                 $this->trace_array[$key]['date'],
                 $this->trace_array[$key]['fromip'],
                 $this->trace_array[$key]['toip'],
                 $this->trace_array[$key]['direction']
             );
             printf(
                 "\n%s\n",
                 htmlspecialchars($this->trace_array[$key]['msg'])
             );
             print "---\n";
         }
         print "</pre>";
     }
 
     public function togglePublicVisibility($callid, $fromtag, $public = '0')
     {
         $key="callid-".trim($callid).trim($fromtag);
 
         if (!$public) {
             $query = sprintf("delete from memcache where `key` = '%s'", addslashes($key));
             $this->cdrtool->query($query);
         } else {
             $query = sprintf("delete from memcache where `key` = '%s'", addslashes($key));
             $this->cdrtool->query($query);
             $query = sprintf("insert into memcache values ('%s','public')", addslashes($key));
             $this->cdrtool->query($query);
         }
     }
 
     public function purgeRecords($days = '')
     {
         if ($this->enableThor) {
             return true;
         }
 
         $b=time();
 
         if ($days) {
             $this->purgeRecordsAfter = $days;
         } elseif (!$this->purgeRecordsAfter) {
             $this->purgeRecordsAfter = 15;
         }
 
         $beforeDate=Date("Y-m-d", time()-$this->purgeRecordsAfter*3600*24);
 
         $query = sprintf(
             "SELECT id as min, time_stamp FROM %s ORDER BY id ASC limit 1",
             addslashes($this->table)
         );
 
         if ($this->db->query($query)) {
             if ($this->db->num_rows()) {
                 $this->db->next_record();
                 $min=$this->db->f('min');
                 $begindate=$this->db->f('date');
             } else {
                 $log = sprintf("No records found in %s\n", $this->table);
                 print $log;
                 syslog(LOG_NOTICE, $log);
                 return false;
             }
         } else {
             $log = sprintf("Error: %s (%s)\n", $this->db->Error, $query);
             print $log;
             syslog(LOG_NOTICE, $log);
             return false;
         }
 
         $query=sprintf(
             "select id as max from %s where time_stamp < '%s' order by id DESC limit 1",
             addslashes($this->table),
             addslashes($beforeDate)
         );
 
         if ($this->db->query($query) && $this->db->num_rows()) {
             $this->db->next_record();
             $max=$this->db->f('max');
         } else {
             $log=sprintf(
                 "No records found in %s before %s, records start after %s\n",
                 $this->table,
                 $beforeDate,
                 $begindate
             );
             syslog(LOG_NOTICE, $log);
             print $log;
             return false;
         }
 
         $deleted = 0;
         $i = $min;
 
         $interval = 1000;
 
         $rows2delete = $max - $min;
         $found = 0;
 
         print "$rows2delete traces to delete between $min and $max\n";
 
         while ($i<=$max) {
             $found=$found+$interval;
 
             if ($i + $interval < $max) {
                 $top=$i;
             } else {
                 $top=$max;
             }
             $query=sprintf(
                 "delete low_priority from %s where id >= '%d' and id <='%d'",
                 addslashes($this->table),
                 addslashes($min),
                 addslashes($top)
             );
             if ($this->db->query($query)) {
                 $deleted = $deleted + $this->db->affected_rows();
             } else {
                 $log = sprintf("Error: %s (%s)", $this->db->Error, $this->db->Errno);
                 syslog(LOG_NOTICE, $log);
                 return false;
             }
 
             if ($found > $progress * $rows2delete / 100) {
                 $progress++;
                 if ($progress % 10 == 0) {
                     print "$progress% ";
                 }
                 flush();
             }
 
             $i = $i + $interval;
         }
 
         print "\n";
 
         $e = time();
         $d = $e - $b;
         $rps = 0;
 
         if ($deleted && $d) {
             $rps=$deleted/$d;
         }
 
         $log = sprintf(
             "%s records before %s from %s deleted in %d s @ %.0f rps\n",
             $deleted,
             $beforeDate,
             $this->table,
             $d,
             $rps
         );
         syslog(LOG_NOTICE, $log);
         print $log;
 
         return true;
     }
 }
 
 class Media_trace
 {
     public $enableThor  = false;
     public $table       = 'media_sessions';
 
     public function __construct($cdr_source)
     {
         global $DATASOURCES;
 
         require_once 'errors.php';
 
         $this->cdr_source = $cdr_source;
         $this->cdrtool  = new DB_CDRTool();
 
         if (!is_array($DATASOURCES[$this->cdr_source])) {
             $log = sprintf("Error: datasource '%s' is not defined", $this->cdr_source);
             print $log;
             throw new DataSourceUndefinedError($log);
             return 0;
         }
 
         if (strlen($DATASOURCES[$this->cdr_source]['enableThor'])) {
             $this->enableThor = $DATASOURCES[$this->cdr_source]['enableThor'];
         }
 
         if ($this->enableThor) {
             require '/etc/cdrtool/ngnpro_engines.inc';
             require_once 'ngnpro_soap_library.php';
 
             if ($DATASOURCES[$this->cdr_source]['soapEngineId'] && in_array($DATASOURCES[$this->cdr_source]['soapEngineId'], array_keys($soapEngines))) {
                 $this->soapEngineId=$DATASOURCES[$this->cdr_source]['soapEngineId'];
 
                 $this->SOAPlogin = array(
                     "username"    => $soapEngines[$this->soapEngineId]['username'],
                     "password"    => $soapEngines[$this->soapEngineId]['password'],
                     "admin"       => true
                 );
 
                 $this->SOAPurl=$soapEngines[$this->soapEngineId]['url'];
 
                 $this->SoapAuth = array('auth', $this->SOAPlogin , 'urn:AGProjects:NGNPro', 0, '');
 
                 // Instantiate the SOAP client
                 $this->soapclient = new WebService_NGNPro_SipPort($this->SOAPurl);
 
                 $this->soapclient->setOpt('curl', CURLOPT_TIMEOUT, 5);
                 $this->soapclient->setOpt('curl', CURLOPT_SSL_VERIFYPEER, 0);
                 $this->soapclient->setOpt('curl', CURLOPT_SSL_VERIFYHOST, 0);
             } else {
                 print "Error: soapEngineID not defined in datasource $this->cdr_source";
                 return false;
             }
         } else {
             if ($DATASOURCES[$this->cdr_source]['table']) {
                 $this->table = $DATASOURCES[$this->cdr_source]['table'];
             }
 
             $db_class = $DATASOURCES[$this->cdr_source]['db_class'];
             if (class_exists($db_class)) {
                 $this->db = new $db_class;
             } else {
                 printf("<p><font color=red>Error: database class %s is not defined in datasource %s</font>", $db_class, $this->cdr_source);
                 return false;
             }
         }
     }
 
     private function getTrace($proxyIP, $callid, $fromtag, $totag)
     {
         if ($this->enableThor) {
             // get trace using soap request
             if (!$proxyIP || !$callid || !$fromtag) {
                 echo "
                     <div style='display: flex; align-items: center; justify-content: center;'>
                         <div class='span10' style='padding-top:40px;'>
                             <p class='alert alert-danger'><strong>Error</strong>: proxyIP or callid or fromtag are not defined</p>
                         </div>
                     </div>
                 ";
                 return false;
             }
 
             global $DATASOURCES;
             if (is_array($DATASOURCES[$this->cdr_source]['proxyTranslation_IP'])
                 && isset($DATASOURCES[$this->cdr_source]['proxyTranslation_IP'][$proxyIP])
                 && strlen($DATASOURCES[$this->cdr_source]['proxyTranslation_IP'][$proxyIP])
             ) {
                 $proxyIP = $DATASOURCES[$this->cdr_source]['proxyTranslation_IP'][$proxyIP];
             }
 
             if (!is_object($this->soapclient)) {
                 print "<p><font color=red>Error: soap client is not defined</font>";
                 return false;
             }
 
             $filter = array(
                 'nodeIp'  => $proxyIP,
                 'callId'  => $callid,
                 'fromTag' => $fromtag,
                 'toTag'   => $totag
             );
 
             $this->soapclient->addHeader($this->SoapAuth);
 
             $result = $this->soapclient->getMediaTrace($filter);
 
             if ((new PEAR)->isError($result)) {
                 $error_msg   = $result->getMessage();
                 $error_fault = $result->getFault();
                 $error_code  = $result->getCode();
 
                 if ($error_fault->detail->exception->errorcode != 1060) {
                     printf(
                         "
                         <div style='display: flex; align-items: center; justify-content: center;'>
                             <div class='span10' style='padding-top:40px;'>
                                 <div class='alert alert-danger'><h4>Error from %s</h4><br/>%s (%s)</div>
                             </div>
                         </div>
                         ",
                         $this->SOAPurl,
                         $error_fault->detail->exception->errorstring,
                         $error_fault->detail->exception->errorcode
                     );
                 }
                 return false;
             }
 
             $this->info = json_decode($result);
         } else {
             if (!is_object($this->db)) {
                 print "<p><font color=red>Error: no database connection defined</font>";
                 return false;
             }
 
             // get trace from SQL
             $query = sprintf(
                 "select info from %s where call_id = '%s' and from_tag = '%s' and to_tag= '%s'",
                 addslashes($this->table),
                 addslashes($callid),
                 addslashes($fromtag),
                 addslashes($totag)
             );
 
             if (!$this->db->query($query)) {
                 printf(
                     "<p><font color=red>Database error for query %s: %s (%s)</font>",
                     $query,
                     $this->db->Error,
                     $this->db->Errno
                 );
                 return false;
             }
 
             if ($this->db->num_rows()) {
                 $this->db->next_record();
                 $this->info = json_decode($this->db->f('info'));
             }
         }
     }
 
     public function show($proxyIP, $callid, $fromtag, $totag)
     {
 
         if ($_SERVER['HTTPS'] == "on") {
             $protocolURL = "https://";
         } else {
             $protocolURL = "http://";
         }
 
         $this->getTrace($proxyIP, $callid, $fromtag, $totag);
 
         if (!is_object($this->info)) {
             echo "
                 <div style='display: flex; align-items: center; justify-content: center;'>
                     <div class='span10' style='padding-top:40px;'>
                         <div class='alert'>No information available</div>
                     </div>
                 </div>
             ";
             return false;
         }
 
         if (empty($this->info->streams)) {
             echo "
                 <div style='display: flex; align-items: center; justify-content: center;'>
                     <div class='span10' style='padding-top:40px;'>
                         <div class='alert alert-info'>No RTP media streams have been established</div>
                     </div>
                 </div>
             ";
             return;
         }
 
         print "<div class='container-fluid'><div id=trace class='main'>";
         $sessionId = rtrim(base64_encode(hash('md5', $callid, true)), "=");
         print "<h1 class=page-header>CDRTool Media Trace<br/><small>Call ID: $callid</small><br /><small>Media Session ID: $sessionId</small></h1>";
 
         foreach (array_values($this->info->streams) as $_val) {
             $_diff=$_val->end_time-$_val->timeout_wait;
             $seen_stamp[$_val->start_time]++;
             $seen_stamp[$_val->end_time]++;
             $seen_stamp[$_diff]++;
             $media_types[]=$_val->media_type;
         }
 
         print "<h2>Media Information</h2>";
 
         print "<table border=0>";
         printf("<tr><td class=border>Call duration</td><td class=border>%s</td></tr>", $this->info->duration);
         list($relay_ip, $relay_port)=explode(":", $this->info->streams[0]->caller_local);
         printf("<tr><td class=border>Media relay</td><td class=border>%s</td></tr>", $relay_ip);
         print "</table>";
 
         print "<h2>Media Streams</h2>";
 
         print "<table class='table table-condensed table-striped' style='width:600px' border=0>";
         print "<thead><tr><th></th>";
 
         foreach (array_values($media_types) as $_type) {
             printf("<th>%s</th>", ucfirst($_type));
         }
 
         print "</tr></thead>";
 
         foreach ($this->info->streams[0] as $_val => $_value) {
             printf("<tr><td class=border>%s</td>", ucfirst(preg_replace("/_/", " ", $_val)));
             $j=0;
             while ($j < count($media_types)) {
                 printf("<td class=border>%s</td>", $this->info->streams[$j]->$_val);
                 $j++;
             }
 
             printf("</tr>\n");
         }
 
         print "</table>";
 
         print "<br><h2>Stream Succession</h2>";
 
         $w_legend_bar = 500;
         $w_text = 30;
         $stamps = array_keys($seen_stamp);
         sort($stamps);
 
         $w_table = $w_legend_bar + $w_text;
 
         print "<table border=0 cellpadding=1 cellspacing=1 width=$w_table>";
 
         $j = 0;
 
         $_index = 0;
         foreach (array_values($this->info->streams) as $_val) {
             if ($_val->status == 'unselected ice candidate') {
                 continue;
             }
 
             $_index = $_index+$_val->start_time;
 
             $_duration   = $_val->end_time-$_val->start_time;
             $_timeout    = $_val->timeout_wait;
 
             $duration_print = $_duration;
 
             if ($_val->status == 'conntrack timeout') {
                 $w_duration   = intval(($_duration-$_timeout)*$w_legend_bar/$this->info->duration);
                 $w_timeout    = intval($_timeout*$w_legend_bar/$this->info->duration);
                 $duration_print = $_duration - $_timeout;
             } elseif ($_val->status == 'no-traffic timeout') {
                 $w_duration   = intval($_duration*$w_legend_bar/$this->info->duration);
                 $w_timeout    = intval($_timeout*$w_legend_bar/$this->info->duration);
             } elseif ($_val->status == 'closed') {
                 $w_duration   = intval($_duration * $w_legend_bar / $this->info->duration);
                 $w_timeout    = 0;
             }
 
 
             $w_start_time = intval($_index*$w_legend_bar/$this->info->duration);
             $w_rest       = $w_legend_bar-$w_duration-$w_timeout-$w_start_time;
             $w_duration_p = ($w_legend_bar/$w_duration) * 100;
             $w_timeout = 0;
             if ($w_timeout > 0) {
                 $w_timeout_p  = ($w_legend_bar/$w_timeout) * 100;
             }
             $w_start_p = 0;
             if ($w_start_time > 0) {
                 $w_start_p  = ($w_legend_bar/$w_start_time)* 100;
             }
             //printf ("%s, %s, %s, %s<br>\n",$w_start_p,$w_duration_p,$w_timeout_p,$w_rest);
 
             if ($_val->caller_packets != '0' && $_val->callee_packets != '0') {
                 print "<tr><td width=$w_text class=border>$_val->media_type</td>";
                 print "<td width=$w_legend_bar>\n";
                 //print "<table width=100% border=0 cellpadding=0 cellspacing=0><tr>\n";
                 print "<div class='progress progress-striped'>";
                 print "<div class=bar style='width:$w_start_p%'></div>\n";
                 print "<div class='bar bar-success'  style='width:$w_duration_p% ; text-align:center'><font color=white>$duration_print</font></div>\n";
 
                 if ($_val->timeout_wait) {
                     print "<div class='bar bar-danger' style='width:$w_timeout%; text-align:center'><font color=white>$_timeout</font></div>\n";
                 } else {
                     print "<div class='bar bar-warning' style='width:$w_timeout%; text-align:center'></div>\n";
                 }
                 //print "<td width=$w_rest bgcolor=white align=center></td>\n";
 
                 //print "</table>\n";
 
                 print "</td></tr>";
             } elseif ($_val->status == 'unselected ICE candidate') {
                 print "<tr><td>ICE session</td></tr>";
             } else {
                 print "<tr><td>No stream data found</td></tr>";
             }
         }
 
         print "</table>";
 
         print "<br><strong>Legend</strong>";
         print "<p><table border=0>
         <tr><td width=50><div class='progress progress-striped progress-success'><div class='bar' style='width:100%'></div></div></td><td>Session data</td></tr>
         <tr><td><div class='progress progress-striped progress-danger'><div class='bar' style='width:100%'></div></div></td><td>Timeout period</td></tr>
         </table></p></div></div>
         ";
     }
 }
 
 include_once "phone_images.php";
 
 function getImageForUserAgent($msg)
 {
     global $userAgentImages;
 
     $msg_lines = explode("\n", $msg);
     foreach ($msg_lines as $line) {
         $els = explode(":", $line);
         if (strtolower($els[0]) == 'user-agent' || strtolower($els[0]) == 'server') {
             foreach ($userAgentImages as $agentRegexp => $image) {
                 if (preg_match("/^(user-agent|server):.*$agentRegexp/i", $line)) {
                     return $image;
                 }
             }
         }
     }
     return "unknown.png";
 }
 
 function isThorNode($ip, $sip_proxy, $role="sip_proxy")
 {
     if (!$ip || !$sip_proxy) {
         return false;
     }
 
     $socket = fsockopen($sip_proxy, 9500, $errno, $errstr, 1);
 
     if (!$socket) {
         return false;
     }
 
     $request=sprintf("is_online %s as %s", $ip, $role);
 
     if (fputs($socket, "$request\r\n") !== false) {
         $ret = trim(fgets($socket, 4096));
         fclose($socket);
     } else {
         fclose($socket);
         return false;
     }
 
     if ($ret == 'Yes') {
         return true;
     } else {
         return false;
     }
 }
 
 ?>
diff --git a/setup/global.inc.complex.sample b/setup/global.inc.complex.sample
index 2792cfe..761a039 100644
--- a/setup/global.inc.complex.sample
+++ b/setup/global.inc.complex.sample
@@ -1,366 +1,368 @@
 <?php
 /**
  * This file contains examples for all possible settings for CDRTool
  *
  * 1. Change all hostnames and passwords according to the installation
  * 2. Copy this file to /etc/cdrtool/global.inc
  */
 
 /**
  * System and web paths
  */
 $CDRTool['tld']    = "/CDRTool";
 $CDRTool['Path']   = "/var/www/CDRTool";
 $_PHPLIB['libdir'] = $CDRTool['Path']. "/phplib/";
 include($_PHPLIB["libdir"] . "prepend.php3");
 
 /**
  * PHP Error reporting
  */
 $errorReporting = (E_ALL & ~E_NOTICE);
 $errorReporting = 1;                    // comment this out to enable PHP warnings
 error_reporting($errorReporting);
 
 /**
  * Service provider information
  */
 $CDRTool['provider']['name']                    = "SIP provider";
 $CDRTool['provider']['service']                 = "SIP service";
 $CDRTool['provider']['timezone']                = "Europe/Amsterdam";
 $CDRTool['provider']['fromEmail']               = "support@example.com";
 $CDRTool['provider']['toEmail']                 = "support@example.com";
 $CDRTool['provider']['sampleLoginSubscriber']   = "317100000@example.com";
 $CDRTool['provider']['sampleLoginDomain']       = "317100001@subdomain.example.com";
 $CDRTool['provider']['clear_text_passwords']    = "0";
 
 /**
  * Rating engine settings
  */
 $RatingEngine = array(
     "socketIP"                      => "IP.address.of.the.private.interface.of.cdrtool.example.com",
     "socketPort"                    => "9024",
     "cdr_source"                    => "opensips_radius",   // points to a defined DATASOURCE
     "log_delay"                     => 0.05,
     "split_rating_table"            => false,               // when true individual rating tables are automatically created for each rate id
     "csv_delimiter"                 => ",",                 // when importing CSV files
     "priceDenominator"              => 10000,               // e.g. 1 Eur = 10000 units
     "priceDecimalDigits"            => 4,                   // how many digits to round the prices to
     "durationPeriodRated"           => 60,                  // the prices from the rating table are calculated per this period
     "trafficSizeRated"              => 1024,                // same as above but for data traffic
     "reportMissingRates"            => 0,                   // send email notifications if rates are missing from the ratingEngine
     "rate_longer_than"              => 0,                   // minimum duration to rate, if call duration is shorter the price is zero
     "allow"                         => array ('10.','192.168.0.1','127.0.0.1'),     // list with clients allowed to connect
     "MaxSessionTime"                => 36000,               // limit all prepaid calls to maximum 10 hours
     "rate_on_net_calls"             => false,
     "rate_on_net_diverted_calls"    => false
 );
 
 /*
 // temporary testing mongo backend capabilities
 "database_backend"   => "mongo",
                      "mongo_db"           => array("uri" => "mongo1.example.com, mongo2.example.com",
                                                    "database"   => "rating",
                                                    "replicaSet" => "sipthor",
                                                    "safe"       => 1)
 
 $CDRTool['mongo_db']['sipthor'] = array("uri"        => "mongo1.example.com, mongo2.example.com",
                                         "database"   => "accounting",
                                         "replicaSet" => "sipthor");
 */
 
 /**
  * Normalize engine settings
  */
 $CDRTool['normalize']['defaultCountryCode'] = "31";
 
 /**
  * Where to retrieve the reseller settings from
  */
 $CDRTool['ngnpro_reseller_engine'] = 'sip';
 
 /**
  * Build graphical statistics for these domains:
  */
 $CDRTool['statistics']['domains'] = array("example.com");
 
 /**
  * Carrier selection codes, strip first digits
  * and allocate custom Billing Party
  */
 $CDRTool['normalize']['CS_CODES'] = array(
     "1684" => array(
         "name"              => "test@Call",
         "BillingPartyId"    => "call@example.com",
         "BillingDomain"     => "example.com",
         "minimumLength"     => "9"
     )
 );
 
 /**
  * Anti-fraud settings
  * Create group quota in SER and deny calls to users in this group
  */
 $UserQuota["default"]["traffic"]  = 5000;              // MBytes
 $UserQuota["default"]["cost"]     = 1000;              // Euro
 
 /**
  * CDRTool databases
  */
 class DB_CDRTool extends DB_Sql
 {
     public $Host     = "sipdb";
     public $Database = "cdrtool";
     public $User     = "cdradmin";
     public $Password = "PASSWORD";
     public $Halt_On_Error ="yes";
 }
 
 class DB_Locker extends DB_Sql
 {
     public $Host     = "sipdb";
     public $Database = "cdrtool";
     public $User     = "locker";
     public $Password = "PASSWORD";
     public $Halt_On_Error ="yes";
 }
 
 class DB_radius extends DB_Sql
 {
     public $Host     = "sipdb";
     public $Database = "radius";
     public $User     = "radius";
     public $Password = "PASSWORD";
     public $Halt_On_Error ="no";
 }
 
 class DB_opensips extends DB_Sql
 {
     public $Host     = "sipdb";
     public $Database = "opensips";
     public $User     = "opensips";
     public $Password = "PASSWORD";
     public $Halt_On_Error ="yes";
 }
 
 class DB_siptrace extends DB_Sql
 {
     public $Host     = "sipdb";
     public $Database = "siptrace";
     public $User     = "opensips";
     public $Password = "PASSWORD";
     public $Halt_On_Error ="yes";
 }
 
 class DB_mediaproxy extends DB_Sql
 {
     public $Host     = "sipdb";
     public $Database = "mediaproxy";
     public $User     = "mediaproxy";
     public $Password = "PASSWORD";
     public $Halt_On_Error ="yes";
 }
 
 $replicated_databases = array(
     'cluster1' => array(
         "db1" => array(
             'ip'                    => '10.0.0.131',
             'slave_of'              => 'db2',
             'user'                  => 'process',
             'password'              => 'password',
             'replication_user'      => 'replication',
             'replication_password'  => 'password',
             'active_master'         => true
         ),
         "db2" => array(
             'ip'                    => '10.0.0.132',
             'slave_of'              => 'db1',
             'user'                  => 'process',
             'password'              => 'password',
             'replication_user'      => 'replication',
             'replication_password'  => 'password'
         )
     )
 );
 
 
 /**
  * To allow subscribers to login and access their own CDRs. See
  * OpenSIPS_DomainAuth from phplib/local.inc as example
  */
 class DomainAuthLocal extends OpenSIPS_DomainAuth
 {
 }
 
 class PageLayoutLocal extends PageLayout
 {
 }
 
 /**
  * CDRTool datasources
  */
 class CDRS_opensips_custom extends CDRS_opensips
 {
         /**
          * this shows how you can modify the default behavior of standard CDRS_opensips class
          * you can overwrite any function from that class here
          * to use this class set the data source 'class' setting to the name of this class
          */
 }
 
 $DATASOURCES = array(
     "unknown" => array(
         "class"              => "CDRS_unknown"          // do not delete this datasource
     ),
     "opensips_radius" => array(
         "name"                  => "OpenSIPS",
         "class"                 => "CDRS_opensips_custom",
         "db_class"              => array(
             "DB_radius2",
             "DB_radius"
         ),
         "table"                 => "radacct",           // or "radacct".date("Ym") if sql.conf uses the mysql procedure to auto-rotate tables
         "rating"                => "1",                 // enable rating
         "rateField"             => "Rate",              // which field stores the rating info
         "E164_class"            => "E164_custom",       // define a custom class to determine the E164 for a telephone number
                                                         // see E164 classes as example in library/cdr_generic.php
         "priceField"            => "Price",
         "DestinationIdField"    => "DestinationId",
         "normalizedField"       => "Normalized",
         "skipNormalizeOnPageLoad" => 0,
         "skipNormalize"         => 0,                   // set it it to true to disable the normalization process
         "BillingPartyIdField"   => "UserName",
         "db_susbcribers"        => "DB_opensips",
         #"mongo_db"             => "sipthor",           // experimental/testing purposes only
         "domain_table"          => "domain",            // table of db_susbcribers that holds domains served by the sip proxy
         "subscriber_table"      => "subscriber",        // table of db_susbcribers that holds susbcribers served by the sip proxy
         "intAccessCode"         => "00",                // international acess code, numbers prefixed with this are considered international destinations
         "natAccessCode"         => "0",                 // international acess code, numbers prefixed with this are considered national destinations
         "sipTrace"              => "sip_trace",         // which datasource is used for display of sip trace
         "mediaTrace"            => "media_trace",       // which datasource is used for display of media trace
         "UserQuotaClass"        => "OpenSIPSQuota",
         "daily_quota"           => "0",                 // a percentage [1 to 99] of monthly quota to check for daily usage, 0 means disabled
         "UserQuotaNotify"       => "1",                 // send e-mail notifications when quota is exceeded
         "notifyLastSessions"    => true,                // send e-mail notifications with sessions received in the last 24 hours
         "soapEngineId"          => '',                  // used by Multimedia Service Platform
         "domainTranslation_SourceIP"  => array(
             "10.0.0.1"      => "gateway.example.com"    // translate Realm for sessions originating from IP address 10.0.0.1
         ),
         "domainTranslation"  => array(
             "gw02.domain.com"      => "pstn.domain.com" // translate Realm
         ),
         "domainTranslationDestination"  => array(
             "gw02.domain.com"      => "pstn.domain.com" // translate destination
         ),
         "proxyTranslation_IP"  => array(
             "10.0.0.1"      => "10.0.0.2"               // translate proxy ip for trace links
         ),
         "purgeCDRsAfter"        => 120,                     // how many days to keep old CDRs, valid only when Radius tables are not atomatically rotated
         "db_registrar"          => "DB_opensips",           // opensips location database
         "enableThor"            => false,                   // set to true if using SIP Thor
         "mediaSessions"         => "sipthor",               // NGNPro engine id used by SIP Thor
         "networkStatus"         => "sipthor",               // NGNPro engine id used by SIP Thor
         "mediaDispatcher"       => "tls:10.0.0.1:25061",    // Where to get the active media sessions from MediaProxy 2.0
                                                             // Create /etc/cdrtool/mediaproxy.pem containing the certificate and private key
         "mediaServers"          => array(
             "10.0.0.2",
             "10.0.0.3"
         ),                                              // where to get the active sessions from MediaRroxy 1.x
         "skipStatistics"        => 0,                   // Skip usage graphs,
         "db_ngnpro_stats"       => "DB_CDRTool"         // Database for provisioning stats
     ),
     "cisco" => array(
         "name"                  => "Cisco gateway",
         "class"                 => "CDRS_cisco",
         "db_class"              => "DB_cisco",
         "table"                 => "radacct",
         "rateField"             => "Rate",
         "rating"                => "1",
         "priceField"            => "Price",
         "DestinationIdField"    => "DestinationId",
         "normalizedField"       => "Normalized",
         "traceInURL"            => array(
             "10.0.0.2" => "opensips_radius",
             "Asterisk" => "asterisk"
         ),
         "traceOutURL"           => array(
             "10.0.0.2" => "opensips_radius"
         ),
         "purgeCDRsAfter"        => 180          // how many days to keep the CDRs
     ),
     "asterisk" => array(
         "name"                  => "Asterisk server",
         "class"                 => "CDRS_asterisk",
         "table"                 => "asterisk_cdr",
         "db_class"              => "DB_radius",
         "rateField"             => "Rate",
         "rating"                => "1",
         "priceField"            => "Price",
         "DestinationIdField"    => "DestinationId",
         "normalizedField"       => "Normalized",
         "contexts"              => array(
             "SIP" => array(
                 "WEBName" => "SIP Provider 1"
             ),
             "PSTN" => array(
                 "WEBName" => "PSTN 2 ENUM"
             )
         ),
         "traceInURL"            => array(
             "SIP" => "opensips_radius"
         ),
         "traceOutURL"           => array(
             "SIP" => "opensips_radius"
         ),
         "purgeCDRsAfter"        => 180          // how many days to keep the CDRs
     ),
     "sip_trace" => array(
         "name"              => "SIP trace",
         "db_class"          => "DB_siptrace",
         "table"             => "sip_trace",
         "purgeRecordsAfter" => "7",
         "SIPProxies"        => array(
             "10.0.0.1" => "SIP Proxy 1",
             "10.0.0.2" => "SIP Proxy 2"
         ),
         "invisible"         => 1,               // hide this datasource in call search page / datasource selection
         "mediaTrace"        => "media_trace"
     ),
 
     "sip_trace_thor" => array(
         "name"              => "SIP trace Thor",
         "enableThor"        => true,
         "soapEngineId"      => "sipthor",
+        "proxyGroups"       => array("10.204.3.72" => "20.3.56.20",
+                                    "20.3.56.20" => "20.3.56.20"),
         "mediaTrace"        => "media_trace_thor",
         "invisible"         => 1,
     ),
     "media_trace" => array(
         "name"              => "Media trace",
         "db_class"          => "DB_mediaproxy",
         "enableThor"        => false,
         "invisible"         => 1
     ),
     "media_trace_thor" => array(
         "name"              => "Media trace Thor",
         "enableThor"        => true,
         "soapEngineId"      => "sipthor",
         "invisible"         => 1
     )
 );
 
 // load other CDRTool libraries
 $CDRToolModules = array(
     "opensips",
     "asterisk"
 );
 
 $tz = $CDRTool['provider']['timezone'];
 putenv("TZ=$tz");
 
 if ($_SERVER['REMOTE_ADDR'] == "10.0.0.1") {
     // display debug information only from this host
     //$verbose=1;
 } else {
     // prevent set of verbose via post/get
     unset($verbose);
 }
 ?>