Find this useful? Enter your email to receive occasional updates for securing PHP code.
Signing you up...
Thank you for signing up!
PHP Decode
<?php eval(gzinflate(substr(base64_decode('H4sIAAAAAAAEAOy9a3vbNtIw/Ln3dT3/AeHjraSWPv..
Decoded Output download
class Real_PDO extends PDO {
public function quote($value, $parameter_type = PDO::PARAM_STR ) {
if( is_null($value) ) {
return "NULL";
}
return parent::quote($value, $parameter_type);
}
public function escape($value){
return stripslashes(str_replace(array('\', "", "
", "
", "'", '"', ""), array("", '', '
', '
', "\'", '\"', '\Z'), $value));
}
// public function query($sql){
//// file_put_contents("./query_log.log","SQL DEBUG: ".$sql."
",FILE_APPEND);
//// return parent::query($sql);
// }
}
class DateTime_52 extends DateTime{
/**
* Set the time of the datetime object by a unix timestamp
* @param int $unixtimestamp
* @return DateTime_52
*/
public function setTimestamp($unixtimestamp){
if(!is_numeric($unixtimestamp) && !is_null($unixtimestamp)){
trigger_error('DateTime::setTimestamp() expects parameter 1 to be long, '.gettype($unixtimestamp).' given', E_USER_WARNING);
} else {
$this->setDate(date('Y', $unixtimestamp), date('n', $unixtimestamp), date('d', $unixtimestamp));
$this->setTime(date('G', $unixtimestamp), date('i', $unixtimestamp), date('s', $unixtimestamp));
}
return $this;
}
/**
* Get the time of the datetime object as a unix timestamp
* @return int a unix timestamp representing the time in the datetime object
*/
public function getTimestamp(){
return $this->format('U');
}
}
$forversion = 0;
function ConstructT($s){
return eval(base64_decode($s));
}
class DB {
protected $db;
function __construct() {
require_once(realpath(dirname(__FILE__))."/config.php");
try{
global $DB_HOST,$DB_NAME,$DB_USER,$DB_PASS;
if(strpos($DB_HOST,":") !== false) {
$parts = explode(":",$DB_HOST);
$_DB_HOST = $parts[0].";unix_socket=".$parts[1];
}else{
$_DB_HOST = $DB_HOST;
}
$this->db = new Real_PDO("mysql:host=".$_DB_HOST.";dbname=".$DB_NAME, $DB_USER, $DB_PASS);
$rows = $this->db->query("SELECT @@sql_mode;");
$rows = $rows->fetch(PDO::FETCH_ASSOC);
if(strpos($rows['@@sql_mode'],"STRICT_TRANS_TABLES") !== -1){
$this->db->exec("SET @@SESSION.sql_mode=''");
}
}catch(PDOException $ex)
{
die('<font color="red" face="dotum" style="margin-left:5px;"><b>[Database Error]</b></font> <pre style="background:#eee; padding:5px;">'.$ex.'</pre>');
}
}
public function getDb(){
return $this->db;
}
/**
* @param $phone
* @return string
*/
public function format_phone_db($phone)
{
if(substr($phone,0,2)=="+1")
$phone = substr($phone,2,(strlen($phone)-2));
if(substr($phone,0,1)=="+")
$phone = substr($phone,1,(strlen($phone)-1));
return str_replace(" ","",$phone);
}
public function query($query) {
return $this->db->query($query);
}
function save_outgoing_call_api ($call_data)
{
$stmt = $this->db->prepare("INSERT INTO outbound_calls (CallSid,AccountSid,CallStatus,CallTo,CallFrom,RecordingUrl,Direction,ApiVersion,DialCallSid,CallDuration,DialCallStatus,DateCreated,AnsweredBy,MadeUsing,UserSource) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);");
if($stmt->execute($call_data))
return true;
else
return false;
}
function save_call_api ($call_data)
{
$stmt = $this->db->prepare("INSERT INTO calls (CallSid,AccountSid,CallStatus,CallTo,CallFrom,RecordingUrl,Direction,ApiVersion,DialCallSid,DialCallDuration,DialCallStatus,DateCreated,DialCallTo) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?);");
if($stmt->execute($call_data))
return true;
else
return false;
}
function format_phone_us($phone = '', $convert = true, $trim = true)
{
if (empty($phone)) {
return false;
}
$phone = preg_replace("/[^0-9A-Za-z]/", "", $phone);
$OriginalPhone = $phone;
if ($trim == true && strlen($phone)>11) {
$phone = substr($phone, 0, 11);
}
if ($convert == true && !is_numeric($phone)) {
$replace = array('2'=>array('a','b','c'),
'3'=>array('d','e','f'),
'4'=>array('g','h','i'),
'5'=>array('j','k','l'),
'6'=>array('m','n','o'),
'7'=>array('p','q','r','s'),
'8'=>array('t','u','v'),
'9'=>array('w','x','y','z'));
foreach($replace as $digit=>$letters) {
$phone = str_ireplace($letters, $digit, $phone);
}
}
$length = strlen($phone);
switch ($length) {
case 7:
// Format: xxx-xxxx
return preg_replace("/([0-9a-zA-Z]{3})([0-9a-zA-Z]{4})/", "$1-$2", $phone);
case 10:
// Format: (xxx) xxx-xxxx
return preg_replace("/([0-9a-zA-Z]{3})([0-9a-zA-Z]{3})([0-9a-zA-Z]{4})/", "($1) $2-$3", $phone);
case 11:
// Format: x(xxx) xxx-xxxx
return preg_replace("/([0-9a-zA-Z]{1})([0-9a-zA-Z]{3})([0-9a-zA-Z]{3})([0-9a-zA-Z]{4})/", "$1($2) $3-$4", $phone);
default:
// Return original phone if not 7, 10 or 11 digits long
return $OriginalPhone;
}
}
/**
* @return array|PDOException
*/
function save_call() {
require_once("config.php");
//http://www.twilio.com/docs/api/twiml/twilio_request#synchronous-request-parameters
try{
$CallSid = @$_REQUEST['CallSid'];
$AccountSid=@$_REQUEST['AccountSid'];
$CallFrom=@$_REQUEST['From'];
$CallTo=@$_REQUEST['To'];
$CallStatus=@$_REQUEST['CallStatus'];
$ApiVersion=@$_REQUEST['ApiVersion'];
$Direction=@$_REQUEST['Direction'];
$CallFrom = str_replace(" ", "+", $CallFrom);
$CallTo = str_replace(" ", "+", $CallTo);
if (isset($_REQUEST['FromCity'])){
$FromCity=$_REQUEST['FromCity'];
$FromState=$_REQUEST['FromState'];
$FromZip=$_REQUEST['FromZip'];
$FromCountry=$_REQUEST['FromCountry'];
} else {
$FromCity="";
$FromState="";
$FromZip="";
$FromCountry="";
}
if (isset($_REQUEST['FromCity'])){
$ToCity=$_REQUEST['ToCity'];
$ToState=$_REQUEST['ToState'];
$ToZip=$_REQUEST['ToZip'];
$ToCountry=$_REQUEST['ToCountry'];
}else{
$ToCity="";
$ToState="";
$ToZip="";
$FromCountry="";
$ToCountry="";
}
if(@$_REQUEST['DateCreated']!=""){
$DateCreated = $_REQUEST['DateCreated'];
}else{
$DateCreated = date('Y-m-d H:i:s',time());
}
$DialCallStatus = empty($_REQUEST['DialCallStatus']) ? "no-answer" : $_REQUEST['DialCallStatus'];
$SpId = (int)$this->getNumberDetails($CallTo);
if (!empty($SpId)) {
$urls = $this->getVisitedUrls($SpId);
$i = count($urls) - 1;
$urls[$i]['made_call'] = true;
$urls = serialize($urls);
$stmt = $this->db->prepare('UPDATE url_visited set urls = :urls WHERE sp_id = :sp_id');
$stmt->execute(array(':urls' => $urls, ':sp_id' => $SpId));
}
$stmt = $this->db->prepare('INSERT INTO calls (DateCreated,CallSid,AccountSid,SpId,CallFrom,CallTo,CallStatus,ApiVersion,Direction,FromCity,FromState,FromZip,FromCountry,ToCity,ToState,ToZip,ToCountry,DialCallStatus) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);');
$vars=array( $DateCreated,$CallSid,$AccountSid,$SpId,$CallFrom,$CallTo,$CallStatus,$ApiVersion,$Direction,$FromCity,$FromState,$FromZip,$FromCountry,$ToCity,$ToState,$ToZip,$ToCountry,$DialCallStatus);
$stmt->execute($vars);
}catch(PDOException $ex){
return $ex;
}
$arr = $stmt->errorInfo();
return $arr;
}
function save_outgoing_call() {
require_once(realpath(dirname(__FILE__))."/config.php");
//http://www.twilio.com/docs/api/twiml/twilio_request#synchronous-request-parameters
try{
$CallSid = @$_REQUEST['CallSid'];
$AccountSid=@$_REQUEST['AccountSid'];
$CallFrom=@$_REQUEST['From'];
$CallTo=@$_REQUEST['To'];
$CallStatus=@$_REQUEST['CallStatus'];
$ApiVersion=@$_REQUEST['ApiVersion'];
$Direction=@$_REQUEST['Direction'];
if (isset($_REQUEST['FromCity'])){
$FromCity=$_REQUEST['FromCity'];
$FromState=$_REQUEST['FromState'];
$FromZip=$_REQUEST['FromZip'];
$FromCountry=$_REQUEST['FromCountry'];
} else {
$FromCity="";
$FromState="";
$FromZip="";
$FromCountry="";
}
if (isset($_REQUEST['FromCity'])){
$ToCity=$_REQUEST['ToCity'];
$ToState=$_REQUEST['ToState'];
$ToZip=$_REQUEST['ToZip'];
$ToCountry=$_REQUEST['ToCountry'];
}else{
$ToCity="";
$ToState="";
$ToZip="";
$FromCountry="";
$ToCountry="";
}
if(@$_REQUEST['DateCreated']!=""){
$DateCreated = $_REQUEST['DateCreated'];
}else{
$DateCreated = date('Y-m-d H:i:s',time());
}
$DialCallSid=@$_REQUEST['DialCallSid'];
$DialCallDuration=@$_REQUEST['DialCallDuration'];
$DialCallStatus=@$_REQUEST['DialCallStatus'];
$RecordingUrl=@$_REQUEST['RecordingUrl'];
if ($this->getVar("mask_recordings") == "true") {
$RecordingUrl = Util::maskRecordingURL($RecordingUrl);
}
$userid = @$_REQUEST['userid'];
$app = @$_REQUEST['app'];
$phone_code = 0;
if(isset($_REQUEST['PhoneCode']))
$phone_code = $_REQUEST['PhoneCode'];
//error_log("PhoneCode: ".$phone_code);
$stmt = $this->db->prepare('INSERT INTO outbound_calls (DateCreated,CallSid,AccountSid,CallFrom,CallTo,CallStatus,ApiVersion,Direction,FromCity,FromState,FromZip,FromCountry,ToCity,ToState,ToZip,ToCountry,DialCallSid,DialCallStatus,RecordingUrl,CallDuration,UserSource,MadeUsing,PhoneCode) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)');
$vars=array( $DateCreated,$CallSid,$AccountSid,$CallFrom,$CallTo,$CallStatus,$ApiVersion,$Direction,$FromCity,$FromState,$FromZip,$FromCountry,$ToCity,$ToState,$ToZip,$ToCountry,$DialCallSid,$DialCallStatus,$RecordingUrl,$DialCallDuration,$userid,$app,$phone_code);
$stmt->execute($vars);
$company_id = $this->getCompanyofOutgoingCall($_REQUEST['CallSid']);
$stmt = $this->db->prepare("SELECT * FROM zapier_subscriptions WHERE `event`='incoming_call_browserphone' AND company_id = ?");
$stmt->execute(array($company_id));
$subs = $stmt->fetchAll(PDO::FETCH_OBJ);
if(is_array($subs) || is_object($subs))
foreach($subs as $sub){
$check1 = false;
$check2 = false;
if(!$this->isUserAdmin($_REQUEST['userid'])){
if($sub->user_id == $_REQUEST['userid'])
$check1 = true;
$outgoing_numbers = $this->getUserOutgoingAccessNumbers($sub->user_id);
if(count($outgoing_numbers)==0)
$check2 = true;
else{
foreach($outgoing_numbers as $num)
if($num->number == $_REQUEST['From'])
$check2 = true;
}
}else{
$check1 = true;
$check2 = true;
}
if($check1 && $check2){
global $TIMEZONE;
$_obj = new stdClass();
$_obj->CallSid = $_REQUEST['CallSid'];
$_date = new DateTime($DateCreated,new DateTimeZone("UTC"));
$_date->setTimezone(new DateTimeZone($TIMEZONE));
$_obj->DateCreated = $_date->format("D n\/d Y g\:iA T");
$_obj->Status = ucfirst($DialCallStatus);
$_obj->Duration = $DialCallDuration != null ? $DialCallDuration : "0";
$_obj->TrackingNumber = $CallFrom;
$_obj->To = $CallTo;
$_obj->Recording = $RecordingUrl;
$pcs = $this->getPhoneCodes($company_id,2);
$_obj->PhoneCode = "None";
if(is_array($pcs) || is_object($pcs))
foreach($pcs as $pc){
if($pc->idx == $phone_code)
$_obj->PhoneCode = $pc->name;
}
$data_string = json_encode($_obj);
$ch = curl_init($sub->subscription_url);
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
curl_setopt($ch, CURLOPT_POSTFIELDS, $data_string);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_HTTPHEADER, array(
'Content-Type: application/json',
'Content-Length: ' . strlen($data_string))
);
$result = curl_exec($ch);
$responseInfo = curl_getinfo($ch);
if($responseInfo['http_code']!=200){
$stmt = $this->customExecute("DELETE FROM zapier_subscriptions WHERE id = ?");
$stmt->execute(array($sub->id));
}
}
}
}catch(PDOException $ex){
return $ex;
}
$arr = $stmt->errorInfo();
return $arr;
}
/**
* @return bool|PDOException
*/
function save_dialed_call() {
try{
$CallSid = @$_REQUEST['CallSid'];
$DialCallSid= @$_REQUEST['DialCallSid'];
$DialCallTo = @$_REQUEST['DialCallTo'];
$DialCallDuration= @$_REQUEST['DialCallDuration'];
$DialCallStatus= @$_REQUEST['DialCallStatus'];
$RecordingUrl= @$_REQUEST['RecordingUrl'];
$pc = $this->getVar("browserphone_".$_REQUEST['CallSid']);
if($pc!=false){
$_REQUEST['PhoneCode'] = $pc;
$this->deleteVar("browserphone_".$_REQUEST['CallSid']);
}
if(isset($_REQUEST['PhoneCode']))
$phone_code = $_REQUEST['PhoneCode'];
else
$phone_code = 0;
$VoiceMail = @$_REQUEST['voicemail'];
//if($VoiceMail==1) $DialCallStatus = "voicemail";
$CallerID = "";
$opencnam_AccountSid = $this->getVar("opencnam_AccountSid");
$opencnam_AuthKey = $this->getVar("opencnam_AuthKey");
if ($opencnam_AccountSid != false || $opencnam_AccountSid != ""){
$retn = json_decode($this->curlGetData("https://$opencnam_AccountSid:[email protected]/v2/phone/".@$_REQUEST['From']."?format=json&ref=act"));
if(isset($retn->name) && $retn->name != ""){
$CallerID = $retn->name;
}
}
if (empty($CallerID)) $CallerID = $_REQUEST['From'];
$stmt = $this->db->prepare('UPDATE calls set DialCallSid=?, DialCallTo=?, DialCallStatus=?, CallerID=?, PhoneCode = ? WHERE CallSid=?');
$stmt->execute(array($DialCallSid, $DialCallTo, $DialCallStatus, $CallerID, $phone_code, $CallSid));
$stmt = $this->db->prepare('SELECT RecordingUrl FROM calls WHERE CallSid=?');
$stmt->execute(array($CallSid));
$call = $stmt->fetch();
if (empty($call['RecordingUrl'])) {
$stmt = $this->db->prepare('UPDATE calls set DialCallDuration=?, RecordingUrl=? WHERE CallSid=?');
$stmt->execute(array($DialCallDuration, $RecordingUrl, $CallSid));
}
else {
$stmt = $this->db->prepare('INSERT INTO call_recordings(CallSid, DialCallDuration, RecordingUrl) VALUES(?, ?, ?)');
$stmt->execute(array($CallSid, $DialCallDuration, $RecordingUrl));
}
}catch(PDOException $ex){
return $ex;
}
if(isset($_REQUEST['callsync']) && $_REQUEST['callsync']==true){
}else{
if ($this->getVar("mask_recordings") == "true") {
$RecordingUrl = Util::maskRecordingURL($RecordingUrl);
}
require_once("class.emailtemplates.php");
// Run Email Notification Worker
$company = $this->getCompanyofCall($CallSid);
$users = $this->customQuery("SELECT * FROM users WHERE email IS NOT NULL");
$stmt = $this->db->prepare('SELECT * FROM calls WHERE CallSid=?');
$stmt->execute(array($CallSid));
$call = $stmt->fetch();
if (empty($call)) return false;
$CallTo = $call['CallTo'];
$CallFrom = $call['CallFrom'];
$company_name = $this->getCompanyName($company);
$status_str = array(
'failed' => array(
"A call failed!",
"You have received a call from ".$CallFrom." to ".$company_name." ".$CallTo." that did not go through."
)
);
foreach($users as $user)
{
$notification_type = $user['notification_type'];
$email_contents = null;
switch($notification_type)
{
case 0:// NONE
{
break;
}
case 1:// ALL
{
if($DialCallStatus=="failed")
{
$email_contents = $status_str[$DialCallStatus];
}elseif($DialCallStatus=="busy" || $DialCallStatus=="no-answer"){
$email_contents = 6;
}elseif($DialCallStatus=="completed"){
$email_contents = 5;
}
break;
}
case 2:// Missed
{
if($DialCallStatus=="failed")
{
$email_contents = $status_str[$DialCallStatus];
}elseif($DialCallStatus=="busy" || $DialCallStatus=="no-answer"){
$email_contents = 6;
}
break;
}
case 3:// Answered
{
if($DialCallStatus=="completed")
$email_contents = 7;
break;
}
case 4:// Over 30 sec
{
if($DialCallStatus=="completed" && $DialCallDuration >= 30)
$email_contents = 8;
break;
}
case 5:// Over 45 sec
{
if($DialCallStatus=="completed" && $DialCallDuration >= 45)
$email_contents = 9;
break;
}
case 6:// Over 60 sec
{
if($DialCallStatus=="completed" && $DialCallDuration >= 60)
$email_contents = 10;
break;
}
case 7:// Over 90 sec
{
if($DialCallStatus=="completed" && $DialCallDuration >= 90)
$email_contents = 11;
break;
}
case 8:// Over 2 min
{
if($DialCallStatus=="completed" && $DialCallDuration >= 120)
$email_contents = 12;
break;
}
}
if($email_contents!=null)
{
if(is_numeric($email_contents)){
$template = new EmailTemplate();
$email_template = $template->getEmailTemplate($email_contents);
$msg = str_replace("[from]",$CallFrom,$email_template->content);
$msg = str_replace("[to]",$CallTo,$msg);
$msg = str_replace("[company]",$company_name,$msg);
if($email_contents != 6){
$msg = str_replace("[duration]",$DialCallDuration,$msg);
$msg = str_replace("[recordingurl]",$RecordingUrl,$msg);
}
$email_contents = array($email_template->subject,$msg);
//error_log("T2 ".print_r($email_contents,true));
}
if($user['access_lvl']>0)
{
$email_params = array(
"subject" => $email_contents[0],
"msg" => $email_contents[1],
"emails" => array($user['email'])
);
if (isset($user['extra_notification_emails'])) {
$extra_emails = explode(",", $user['extra_notification_emails']);
foreach ($extra_emails as $email_address) {
if (!empty($email_address)) $email_params['emails'][] = $email_address;
}
}
Util::sendEmail($email_params);
}else{
if($this->isUserInCompany($company,$user['idx']))
{
$send = true;
$disabled_numbers = $this->getUserAccessNumbers($user['idx']);
foreach($disabled_numbers as $disabled_number)
{
if($disabled_number->number==$CallTo)
$send = false;
}
if($send)
{
$send = false;
$filter_numbers = $this->getUserOutgoingAccessNumbers($user['idx']);
if(count($filter_numbers)>0){
if( is_array($filter_numbers) || is_object($filter_numbers) )
{
foreach($filter_numbers as $filter_number)
{
if($filter_number->number == $DialCallTo)
$send = true;
}
}else{
$send = true;
}
}else{
$send = true;
}
if($send)
{
$email_params = array(
"subject" => $email_contents[0],
"msg" => $email_contents[1],
"emails" => array($user['email'])
);
if (isset($user['extra_notification_emails'])) {
$extra_emails = explode(",", $user['extra_notification_emails']);
foreach ($extra_emails as $email_address) {
if (!empty($email_address)) $email_params['emails'][] = $email_address;
}
}
Util::sendEmail($email_params);
}
}
}
}
}
}
}
$stmt = $this->db->prepare("SELECT * FROM calls WHERE CallSid = ?");
$stmt->execute(array($_REQUEST['CallSid']));
$data = $stmt->fetch(PDO::FETCH_OBJ);
return $data;
}
function getCallRecordings($CallSid) {
$stmt = $this->db->prepare("SELECT * FROM call_recordings WHERE CallSid = ?");
$stmt->execute(array($CallSid));
$data = $stmt->fetchAll();
return $data;
}
/**
* @return array
*/
function get_calls(){
$result = $this->db->query('SELECT * FROM calls ORDER BY DateCreated DESC');
$calls=array();
foreach ($result as $row)
{
$call['CallSid'] = $row['CallSid'];
$call['CallFrom'] = $row['CallFrom'];
$call['CallTo'] = $row['CallTo'];
$call['FromCity'] = $row['FromCity'];
$call['FromState'] = $row['FromState'];
$call['FromZip'] = $row['FromZip'];
$call['DialCallTo'] = $row['DialCallTo'];
$call['DialCallSid'] = $row['DialCallSid'];
$call['DialCallDuration'] = $row['DialCallDuration'];
$call['DialCallStatus'] = $row['DialCallStatus'];
$call['RecordingUrl'] = $row['RecordingUrl'];
$call['DateCreated'] = $row['DateCreated'];
$calls[] = $call;
}
return $calls;
}
/**
* @param $cid
* @return bool|mixed
*/
function getCallDetails($cid)
{
$cid = $this->db->escape($cid);
$result = $this->db->query("SELECT * FROM calls WHERE CallSid='$cid'");
$data = $result->fetch();
if($data)
{
return $data;
}else
return false;
}
/**
* @param $cid
* @return bool|mixed
*/
function getOutgoingCallDetails($cid)
{
$cid = $this->db->escape($cid);
$result = $this->db->query("SELECT * FROM outbound_calls WHERE CallSid='$cid'");
if($result)
$data = $result->fetch();
else
return false;
if($data)
{
return $data;
}else
return false;
}
/**
* Gets all the calls from a Company.
*
* @param int $company_id Company's ID
* @param object $pagination Pagination Object
* @return array Returns calls in array.
*
*/
function cget_calls($company_id, $pagination){
try{
require_once('Pagination.php');
$company_id = $this->db->escape($company_id);
$resultValidNum = $this->db->query("SELECT number,international FROM company_num WHERE company_id='$company_id'");
$numbers = "";
$calls=array();
foreach ($resultValidNum as $row)
{
$disabled = false;
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$disabled_numbers = $this->getUserAccessNumbers($_SESSION['user_id']);
$number_array = array();
foreach($disabled_numbers as $disabled_number)
{
$number_array[] = $disabled_number->number;
}
if(count($number_array)>0)
{
foreach($number_array as $d_number)
{
if($row['international']==0)
$number_ = "+1".$row['number'];
else
$number_ = $row['number'];
if($number_===$d_number)
$disabled = true;
}
}
}
}
if($disabled)
continue;
if($row['international']==0)
$numbers .= "'+1".$row['number']."', ";
else
$numbers .= "'+".$row['number']."', ";
}
$ringto_numbers = "";
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$filter_ringto_numbers = $this->getUserOutgoingAccessNumbers($_SESSION['user_id']);
if(count($filter_ringto_numbers)>0)
{
foreach($filter_ringto_numbers as $ringto_num)
{
$ringto_numbers .= "'".$ringto_num->number."', ";
}
$ringto_numbers = substr($ringto_numbers,0,-2);
$ringto_numbers = " AND DialCallTo IN (".$ringto_numbers.")";
}
}
}
$numbers = substr($numbers, 0, -2);
$date_access_range = "";
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$access_range = $this->getUserAccessRange($_SESSION['user_id']);
if($access_range!=false)
{
if($access_range[1]==1)
$when = ">";
elseif($access_range[1]==2)
$when = "<";
else
$when = ">";
$date_access_range = " AND DateCreated ".$when." '".$access_range[0]."'";
}
}
}
$count = $this->db->query('SELECT COUNT(*) as total FROM calls WHERE CallTo IN ('.$numbers.')'.$ringto_numbers.$date_access_range.' ORDER BY DateCreated DESC');
if($count) {
$count = $count->fetch();
$count = $count['total'];
}
else
$count = 0;
$result = $this->db->query('SELECT * FROM calls WHERE CallTo IN ('.$numbers.')'.$ringto_numbers.$date_access_range.' ORDER BY DateCreated DESC '.$pagination->getLimitSql());
if($result)
{
foreach ($result as $row)
{
$call['CallSid'] = $row['CallSid'];
$call['CallFrom'] = $row['CallFrom'];
$call['CallTo'] = $row['CallTo'];
$call['FromCity'] = $row['FromCity'];
$call['FromState'] = $row['FromState'];
$call['FromZip'] = $row['FromZip'];
$call['DialCallDuration'] = $row['DialCallDuration'];
$call['DialCallStatus'] = $row['DialCallStatus'];
$call['RecordingUrl'] = $row['RecordingUrl'];
$call['DateCreated'] = $row['DateCreated'];
$call['PhoneCode'] = $row['PhoneCode'];
$calls[] = $row;
}
}
else
return false;
return array($calls,$count);
}catch(PDOException $ex)
{
//echo $ex->getMessage();
return $ex->getMessage();
}
}
function cget_all_calls($company_id, $outgoing = false){
try{
$company_id = $this->db->escape($company_id);
$resultValidNum = $this->db->query("SELECT number,international FROM company_num WHERE company_id='$company_id'");
$numbers = "";
$calls=array();
foreach ($resultValidNum as $row)
{
$disabled = false;
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$disabled_numbers = $this->getUserAccessNumbers($_SESSION['user_id']);
$number_array = array();
foreach($disabled_numbers as $disabled_number)
{
$number_array[] = $disabled_number->number;
}
if(count($number_array)>0)
{
foreach($number_array as $d_number)
{
if($row['international']==0)
$number_ = "+1".$row['number'];
else
$number_ = $row['number'];
if($number_===$d_number)
$disabled = true;
}
}
}
}
if($disabled)
continue;
if($row['international']==0)
$numbers .= "'+1".$row['number']."', ";
else
$numbers .= "'+".$row['number']."', ";
}
$ringto_numbers = "";
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$filter_ringto_numbers = $this->getUserOutgoingAccessNumbers($_SESSION['user_id']);
if(count($filter_ringto_numbers)>0)
{
foreach($filter_ringto_numbers as $ringto_num)
{
$ringto_numbers .= "'".$ringto_num->number."', ";
}
$ringto_numbers = substr($ringto_numbers,0,-2);
$ringto_numbers = " AND DialCallTo IN (".$ringto_numbers.")";
}
}
}
$numbers = substr($numbers, 0, -2);
$access_range_date = "";
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$access_range = $this->getUserAccessRange($_SESSION['user_id']);
if($access_range!=false)
{
if($access_range[1]==1)
$when = ">";
elseif($access_range[1]==2)
$when = "<";
else
$when = ">";
$access_range_date = " AND DateCreated ".$when." '".$access_range[0]."'";
}
}
}
$extra_ad = "";
if($outgoing==false){
$table = "calls";
$target_field = "CallTo";
}else{
$table = "outbound_calls";
$target_field = "CallFrom";
if (empty($_GET['agent']))
$extra_ad = " AND MadeUsing != 'autodialer' ";
}
$count = $this->db->query('SELECT COUNT(*) FROM '.$table.' WHERE '.$target_field.' IN ('.$numbers.')'.$extra_ad.$ringto_numbers.$access_range_date.' ORDER BY DateCreated DESC');
if($count) {
$count = $count->fetch();
$count = $count['total'];
}
else
$count = 0;
$result = $this->db->query('SELECT * FROM '.$table.' WHERE '.$target_field.' IN ('.$numbers.')'.$extra_ad.$ringto_numbers.$access_range_date.' ORDER BY DateCreated DESC');
if($result)
{
$twilio_numbers = Util::get_all_twilio_numbers();
foreach ($result as $row)
{
if (array_key_exists(format_phone($row['CallTo']), $twilio_numbers))
{
$campaign=(string)$twilio_numbers[format_phone($row['CallTo'])];
}
else
$campaign="";
$call['CallSid'] = $row['CallSid'];
$call['CallFrom'] = $row['CallFrom'];
$call['CallTo'] = $row['CallTo'];
$call['Campaign'] = $campaign;
$call['FromCity'] = $row['FromCity'];
$call['FromState'] = $row['FromState'];
$call['FromZip'] = $row['FromZip'];
$call['FromCountry'] = $row['FromCountry'];
if($outgoing==false){
$call['DialCallDuration'] = $row['DialCallDuration'];
}else{
$call['DialCallDuration'] = $row['CallDuration'];
}
$call['DialCallStatus'] = $row['DialCallStatus'];
$call['RecordingUrl'] = $row['RecordingUrl'];
$call['DateCreated'] = $row['DateCreated'];
$call['PhoneCode'] = $row['PhoneCode'];
$call['DialCallTo'] = @$row['DialCallTo'];
$call['CallerID'] = $row['CallerID'];
$calls[] = $call;
}
}
else
return false;
return array($calls,$count);
}catch(PDOException $ex)
{
//echo $ex->getMessage();
return $ex->getMessage();
}
}
function getAllCallsFromNumber($company_id,$fromnumber){
try{
$company_id = $this->db->escape($company_id);
$resultValidNum = $this->db->query("SELECT number,international FROM company_num WHERE company_id='$company_id'");
$numbers = "";
$calls=array();
foreach ($resultValidNum as $row)
{
$disabled = false;
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$disabled_numbers = $this->getUserAccessNumbers($_SESSION['user_id']);
$number_array = array();
foreach($disabled_numbers as $disabled_number)
{
$number_array[] = $disabled_number->number;
}
if(count($number_array)>0)
{
foreach($number_array as $d_number)
{
if($row['international']==0)
$number_ = "+1".$row['number'];
else
$number_ = $row['number'];
if($number_===$d_number)
$disabled = true;
}
}
}
}
if($disabled)
continue;
if($row['international']==0)
$numbers .= "'+1".$row['number']."', ";
else
$numbers .= "'+".$row['number']."', ";
}
$ringto_numbers = "";
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$filter_ringto_numbers = $this->getUserOutgoingAccessNumbers($_SESSION['user_id']);
if(count($filter_ringto_numbers)>0)
{
foreach($filter_ringto_numbers as $ringto_num)
{
$ringto_numbers .= "'".$ringto_num->number."', ";
}
$ringto_numbers = substr($ringto_numbers,0,-2);
$ringto_numbers = " AND DialCallTo IN (".$ringto_numbers.")";
}
}
}
$numbers = substr($numbers, 0, -2);
$access_range_date = "";
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$access_range = $this->getUserAccessRange($_SESSION['user_id']);
if($access_range!=false)
{
if($access_range[1]==1)
$when = ">";
elseif($access_range[1]==2)
$when = "<";
else
$when = ">";
$access_range_date = " AND DateCreated ".$when." '".$access_range[0]."'";
}
}
}
$count = $this->db->query('SELECT COUNT(*) as total FROM calls WHERE CallTo IN ('.$numbers.')'.$ringto_numbers.$access_range_date.' AND CallFrom = '.$fromnumber.' ORDER BY DateCreated DESC');
if($count) {
$count = $count->fetch();
$count = $count['total'];
}
else
$count = 0;
$result = $this->db->query('SELECT * FROM calls WHERE CallTo IN ('.$numbers.')'.$ringto_numbers.$access_range_date.' AND CallFrom = '.$fromnumber.' ORDER BY DateCreated DESC');
if($result)
{
$twilio_numbers = Util::get_all_twilio_numbers();
foreach ($result as $row)
{
if (array_key_exists(format_phone($row['CallTo']), $twilio_numbers))
{
$campaign=(string)$twilio_numbers[format_phone($row['CallTo'])];
}
else
$campaign="";
$call['CallSid'] = $row['CallSid'];
$call['CallFrom'] = $row['CallFrom'];
$call['CallTo'] = $row['CallTo'];
$call['Campaign'] = $campaign;
$call['FromCity'] = $row['FromCity'];
$call['FromState'] = $row['FromState'];
$call['FromZip'] = $row['FromZip'];
$call['DialCallDuration'] = $row['DialCallDuration'];
$call['DialCallStatus'] = $row['DialCallStatus'];
$call['RecordingUrl'] = $row['RecordingUrl'];
$call['DateCreated'] = $row['DateCreated'];
$call['PhoneCode'] = $row['PhoneCode'];
$calls[] = $call;
}
}
else
return false;
return array($calls,$count);
}catch(PDOException $ex)
{
//echo $ex->getMessage();
return $ex->getMessage();
}
}
function getAllCallsToNumber($company_id,$tonumber){
try{
$company_id = $this->db->escape($company_id);
$resultValidNum = $this->db->query("SELECT number,international FROM company_num WHERE company_id='$company_id'");
$numbers = "";
$calls=array();
foreach ($resultValidNum as $row)
{
$disabled = false;
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$disabled_numbers = $this->getUserAccessNumbers($_SESSION['user_id']);
$number_array = array();
foreach($disabled_numbers as $disabled_number)
{
$number_array[] = $disabled_number->number;
}
if(count($number_array)>0)
{
foreach($number_array as $d_number)
{
if($row['international']==0)
$number_ = "+1".$row['number'];
else
$number_ = $row['number'];
if($number_===$d_number)
$disabled = true;
}
}
}
}
if($disabled)
continue;
if($row['international']==0)
$numbers .= "'+1".$row['number']."', ";
else
$numbers .= "'+".$row['number']."', ";
}
$ringto_numbers = "";
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$filter_ringto_numbers = $this->getUserOutgoingAccessNumbers($_SESSION['user_id']);
if(count($filter_ringto_numbers)>0)
{
foreach($filter_ringto_numbers as $ringto_num)
{
$ringto_numbers .= "'".$ringto_num->number."', ";
}
$ringto_numbers = substr($ringto_numbers,0,-2);
$ringto_numbers = " AND DialCallTo IN (".$ringto_numbers.")";
}
}
}
$numbers = substr($numbers, 0, -2);
$access_range_date = "";
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$access_range = $this->getUserAccessRange($_SESSION['user_id']);
if($access_range!=false)
{
if($access_range[1]==1)
$when = ">";
elseif($access_range[1]==2)
$when = "<";
else
$when = ">";
$access_range_date = " AND DateCreated ".$when." '".$access_range[0]."'";
}
}
}
$count = $this->db->query('SELECT COUNT(*) as total FROM outbound_calls WHERE CallFrom IN ('.$numbers.')'.$ringto_numbers.$access_range_date.' AND CallTo = '.$tonumber.' ORDER BY DateCreated DESC');
if($count) {
$count = $count->fetch();
$count = $count['total'];
}
else
$count = 0;
$result = $this->db->query('SELECT * FROM outbound_calls WHERE CallFrom IN ('.$numbers.')'.$ringto_numbers.$access_range_date.' AND CallTo = '.$tonumber.' ORDER BY DateCreated DESC');
if($result)
{
$twilio_numbers = Util::get_all_twilio_numbers();
foreach ($result as $row)
{
if (array_key_exists(format_phone($row['CallFrom']), $twilio_numbers))
{
$campaign=(string)$twilio_numbers[format_phone($row['CallFrom'])];
}
else
$campaign="";
$call['CallSid'] = $row['CallSid'];
$call['CallFrom'] = $row['CallFrom'];
$call['CallTo'] = $row['CallTo'];
$call['Campaign'] = $campaign;
$call['FromCity'] = $row['FromCity'];
$call['FromState'] = $row['FromState'];
$call['FromZip'] = $row['FromZip'];
$call['DialCallDuration'] = $row['CallDuration'];
$call['DialCallStatus'] = $row['DialCallStatus'];
$call['RecordingUrl'] = $row['RecordingUrl'];
$call['DateCreated'] = $row['DateCreated'];
$call['PhoneCode'] = $row['PhoneCode'];
$calls[] = $call;
}
}
else
return false;
return array($calls,$count);
}catch(PDOException $ex)
{
//echo $ex->getMessage();
return $ex->getMessage();
}
}
function cget_all_outgoing_calls($company_id){
try{
$company_id = $this->db->escape($company_id);
$resultValidNum = $this->db->query("SELECT number,international FROM company_num WHERE company_id='$company_id'");
$numbers = "";
$calls=array();
foreach ($resultValidNum as $row)
{
$disabled = false;
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$disabled_numbers = $this->getUserAccessNumbers($_SESSION['user_id']);
$number_array = array();
foreach($disabled_numbers as $disabled_number)
{
$number_array[] = $disabled_number->number;
}
if(count($number_array)>0)
{
foreach($number_array as $d_number)
{
if($row['international']==0)
$number_ = "+1".$row['number'];
else
$number_ = $row['number'];
if($number_===$d_number)
$disabled = true;
}
}
}
}
if($disabled)
continue;
if($row['international']==0)
$numbers .= "'+1".$row['number']."', ";
else
$numbers .= "'+".$row['number']."', ";
}
$numbers = substr($numbers, 0, -2);
$access_range_date = "";
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$access_range = $this->getUserAccessRange($_SESSION['user_id']);
if($access_range!=false)
{
if($access_range[1]==1)
$when = ">";
elseif($access_range[1]==2)
$when = "<";
else
$when = ">";
$access_range_date = " AND DateCreated ".$when." '".$access_range[0]."'";
}
}
}
$extra_ad = "";
if (empty($_GET['agent']))
$extra_ad = " AND MadeUsing != 'autodialer' ";
$count = $this->db->query('SELECT COUNT(*) FROM outbound_calls WHERE CallFrom IN ('.$numbers.')'.$extra_ad.$access_range_date.' ORDER BY DateCreated DESC');
if($count) {
$count = $count->fetch();
$count = $count['total'];
}
else
$count = 0;
$result = $this->db->query('SELECT * FROM outbound_calls WHERE CallFrom IN ('.$numbers.')'.$extra_ad.$access_range_date.' ORDER BY DateCreated DESC');
if($result)
{
$twilio_numbers = Util::get_all_twilio_numbers();
foreach ($result as $row)
{
$new_row = array();
foreach($row as $key => $value)
{
if($key==="CallFrom")
{
if (array_key_exists(format_phone($value), $twilio_numbers))
{
$campaign=(string)$twilio_numbers[format_phone($value)];
}
else
$campaign="";
$new_row["Campaign"] = $campaign;
}
if(!is_numeric($key))
$new_row[$key] = $value;
}
$calls[] = $new_row;
}
}
else
return false;
return array($calls,$count);
}catch(PDOException $ex)
{
//echo $ex->getMessage();
return $ex->getMessage();
}
}
function cget_outgoing_calls($company_id, $pagination){
try{
require_once('Pagination.php');
$company_id = $this->db->escape($company_id);
$resultValidNum = $this->db->query("SELECT number,international FROM company_num WHERE company_id='$company_id'");
$numbers = "";
$calls=array();
foreach ($resultValidNum as $row)
{
$disabled = false;
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$disabled_numbers = $this->getUserAccessNumbers($_SESSION['user_id']);
$number_array = array();
foreach($disabled_numbers as $disabled_number)
{
$number_array[] = $disabled_number->number;
}
if(count($number_array)>0)
{
foreach($number_array as $d_number)
{
if($row['international']==0)
$number_ = "+1".$row['number'];
else
$number_ = $row['number'];
if($number_===$d_number)
$disabled = true;
}
}
}
}
if($disabled)
continue;
if($row['international']==0)
$numbers .= "'+1".$row['number']."', ";
else
$numbers .= "'+".$row['number']."', ";
}
$numbers = substr($numbers, 0, -2);
$access_range_date = "";
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$access_range = $this->getUserAccessRange($_SESSION['user_id']);
if($access_range!=false)
{
if($access_range[1]==1)
$when = ">";
elseif($access_range[1]==2)
$when = "<";
else
$when = ">";
$access_range_date = " AND DateCreated ".$when." '".$access_range[0]."'";
}
}
}
$extra_ad = "";
if (empty($_GET['agent']))
$extra_ad = " AND MadeUsing != 'autodialer' ";
$count = $this->db->query('SELECT COUNT(*) as total FROM outbound_calls WHERE CallFrom IN ('.$numbers.')'.$extra_ad.$access_range_date.' ORDER BY DateCreated DESC');
if($count) {
$count = $count->fetch();
$count = $count['total'];
}
else
$count = 0;
$result = $this->db->query('SELECT * FROM outbound_calls WHERE CallFrom IN ('.$numbers.')'.$extra_ad.$access_range_date.' ORDER BY DateCreated DESC '.$pagination->getLimitSql());
if($result)
{
foreach ($result as $row)
$calls[] = $row;
}
else
return false;
return array($calls,$count);
}catch(Exception $ex)
{
//echo $ex->getMessage();
return $ex->getMessage();
}
}
function get_voicemail($company_id, $pagination){
try{
require_once('Pagination.php');
$company_id = $this->db->escape($company_id);
$count = $this->db->query("SELECT COUNT(*) as total FROM messages WHERE message_frn_vmb_extension ='$company_id'");
if($count) {
$count = $count->fetch();
$count = $count['total'];
}
else
$count = 0;
$result = $this->db->query('SELECT * FROM messages WHERE message_frn_vmb_extension ='. $company_id .' ORDER BY message_date DESC '.$pagination->getLimitSql());
if(!$result) return false;
$voicemails= $result->fetchAll();
return array($voicemails,$count);
}catch(Exception $ex)
{
//echo $ex->getMessage();
return $ex->getMessage();
}
}
/**
* @param $company_id
* @return array
*/
function cget_calls_count($company_id){
$company_id = $this->db->escape($company_id);
//error_log("quoted: ".$company_id);
$resultValidNum = $this->db->query("SELECT number FROM company_num WHERE company_id='$company_id'");
$access_range_date = "";
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$access_range = $this->getUserAccessRange($_SESSION['user_id']);
if($access_range[0]!="")
{
if($access_range[1]==1)
$when = ">";
elseif($access_range[1]==2)
$when = "<";
else
$when = ">";
$access_range_date = " AND DateCreated ".$when." '".$access_range[0]."'";
}
$disabled_numbers = $this->getUserAccessNumbers($_SESSION['user_id']);
$number_array = array();
foreach($disabled_numbers as $disabled_number)
{
$number_array[] = $disabled_number->number;
}
if(count($number_array)>0)
{
if($access_range!=false)
$addon_sql = " AND CallTo NOT IN (";
else
$addon_sql = " AND CallTo NOT IN (";
foreach($number_array as $d_number)
{
$addon_sql .= "'".$d_number."',";
}
$addon_sql = substr($addon_sql, 0, -1).")";
$access_range_date .= $addon_sql;
}
$allowed_outgoing_numbers = $this->getUserOutgoingAccessNumbers($_SESSION['user_id']);
if(count($allowed_outgoing_numbers)>0)
{
if($access_range!=false || strlen($addon_sql)>0)
$addon_sql2 = " AND DialCallTo IN (";
else{
$addon_sql2 = " AND DialCallTo IN (";
}
if( is_array($allowed_outgoing_numbers) || is_object($allowed_outgoing_numbers) )
foreach($allowed_outgoing_numbers as $outgoing_num)
{
$addon_sql2 .= "'".$outgoing_num->number."',";
}
$addon_sql2 = substr($addon_sql2, 0 , -1).")";
$access_range_date .= $addon_sql2;
}
}
}
//echo 'SELECT count(*) as cnt, CallTo FROM calls'.$access_range_date.' GROUP BY CallTo ORDER BY cnt DESC';
$result = $this->db->query('SELECT count(*) as cnt, CallTo FROM calls WHERE DialCallStatus != "voicemail2" '.$access_range_date.' GROUP BY CallTo ORDER BY cnt DESC');
$validNumbers = array();
$calls=array();
foreach ($resultValidNum as $row)
{
$validNumbers[] = $row['number'];
}
if( is_array($result) || is_object($result) )
foreach ($result as $row1)
{
if(in_array($this->format_phone_db($row1['CallTo']), $validNumbers))
{
$call['cnt'] = $row1['cnt'];
$call['CallTo'] = $row1['CallTo'];
$calls[] = $call;
}
}
return $calls;
}
function cget_outgoing_calls_count($company_id){
$company_id = $this->db->escape($company_id);
$resultValidNum = $this->db->query("SELECT number FROM company_num WHERE company_id='$company_id'");
$access_range_date = "";
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$access_range = $this->getUserAccessRange($_SESSION['user_id']);
if($access_range!=false)
{
if($access_range[1]==1)
$when = ">";
elseif($access_range[1]==2)
$when = "<";
else
$when = ">";
$access_range_date = " WHERE DateCreated ".$when." '".$access_range[0]."'";
}
$disabled_numbers = $this->getUserAccessNumbers($_SESSION['user_id']);
$number_array = array();
foreach($disabled_numbers as $disabled_number)
{
$number_array[] = $disabled_number->number;
}
if(count($number_array)>0)
{
if($access_range!=false)
$addon_sql = " AND CallFrom NOT IN (";
else
$addon_sql = " WHERE CallFrom NOT IN (";
foreach($number_array as $d_number)
{
$addon_sql .= "'".$d_number."',";
}
$addon_sql = substr($addon_sql, 0, -1).")";
$access_range_date .= $addon_sql;
}
}
}
$extra_ad = "";
if (empty($_GET['agent'])) {
$extra_ad = " ".(strlen($access_range_date) == 0 ? "WHERE":"AND")." MadeUsing != 'autodialer' ";
}
$result = $this->db->query('SELECT count(*) as cnt, CallFrom FROM outbound_calls'.$access_range_date.$extra_ad.' GROUP BY CallFrom ORDER BY cnt DESC');
$validNumbers = array();
$calls=array();
foreach ($resultValidNum as $row)
{
$validNumbers[] = $row['number'];
}
if( is_array($result) || is_object($result) )
foreach ($result as $row1)
{
if(in_array($this->format_phone_db($row1['CallFrom']), $validNumbers))
{
$call['cnt'] = $row1['cnt'];
$call['CallFrom'] = $row1['CallFrom'];
$calls[] = $call;
}
}
return $calls;
}
/**
* @param $call_sid
* @return array
*/
function getCallNotes($call_sid){
$call_sid = $this->db->escape($call_sid);
$query = $this->db->query("SELECT * FROM call_notes WHERE CallSid='$call_sid' ORDER BY DateAdded ASC");
return $query->fetchAll();
}
/**
* @return int
*/
function getCompanyCount(){
$result = $this->db->query("SELECT * FROM companies;");
$count = 0;
foreach ($result as $row)
{
$count++;
}
return $count;
}
/**
* @param $number
* @return mixed
*/
function getOutgoingNumber($number)
{
$number = $this->db->escape($number);
$query = $this->db->query("SELECT company_id FROM company_num WHERE number='$number'");
$company_id = $query->fetch(); $company_id = $company_id['company_id'];
$query = $this->db->query("SELECT assigned_number,international FROM companies WHERE idx='$company_id'");
if($query === false)
return "";
else{
$number = $query->fetch();
}
if($number['international']==1)
return $number['assigned_number'];
else
return "+1".$number['assigned_number'];
}
/**
* @param $number
* @return mixed
*/
function getOutgoingNumberDetails($number)
{
$number = $this->db->escape($number);
$query = $this->db->query("SELECT * FROM company_num WHERE number='$number'");
if($query === false)
return "";
else{
return $query->fetch();
}
}
function getCompanyOfNumber($number)
{
$stmt = $this->db->prepare("SELECT company_id FROM company_num WHERE number=:num OR number=:num2");
if($stmt->execute(array(":num"=>$number, ":num2"=>"1".$number)))
{
if($result = $stmt->fetch(PDO::FETCH_OBJ))
return $result->company_id;
else
return false;
}else{
return false;
}
}
function getNumbersOfCompany($company_id, $pool = false)
{
$pool_criteria = ($pool) ? "" : " AND pool_id IS NULL";
$stmt = $this->db->prepare("SELECT number FROM company_num WHERE company_id=:company_id ".$pool_criteria);
if($stmt->execute(array(":company_id"=>$company_id)))
{
$result = $stmt->fetchAll(PDO::FETCH_OBJ);
return $result;
}else{
return false;
}
}
function getLiveCalls($numbers)
{
$stmt = $this->db->prepare("SELECT CallSid,`Index`, CallFrom, CallTo, DateCreated FROM calls WHERE DateCreated LIKE '%".date("Y-m-d")."%' AND CallStatus = 'ringing' AND (DialCallStatus IS NULL OR DialCallStatus = '') AND CallTo IN ".$numbers);
if($stmt->execute())
{
$calls = array();
$result = $stmt->fetchAll(PDO::FETCH_OBJ);
foreach($result as $call){
$date = new DateTime("now",new DateTimeZone("UTC"));
$now = $date->modify("-1 hour");
$call_date = new DateTime($call->DateCreated, new DateTimeZone("UTC"));
if($call_date < $now) continue;
$calls[] = $call;
}
return $calls;
}else{
return false;
}
}
/**
* @param $number
* @param $company_id
* @return bool
*/
function setfowardNumber($number,$sec ,$intl,$company_id)
{
$number = $this->db->escape($number);
$company_id = $this->db->escape($company_id);
$sec = $this->db->escape($sec);
$intl = $this->db->escape($intl);
$result = $this->db->query("UPDATE companies SET international='$intl',forward_sec ='$sec', forward_number='$number' where idx ='$company_id'");
}
function setOutgoingNumber($number, $company_id,$intl,$voicemail)
{
$number = $this->db->escape($number);
$company_id = $this->db->escape($company_id);
$result = $this->db->prepare("UPDATE companies SET assigned_number=?,international=?,voicemail=? WHERE idx=?");
if($result->execute(array($number,$intl,$voicemail,$company_id)))
{
if ( $voicemail)
{
$result = $this->db->query("insert into voicemailbox set vmb_extension='$company_id',vmb_description ='compnay extension',vmb_passcode ='$company_id'");
}else{
$result = $this->db->query("delete from voicemailbox where vmb_extension='$company_id'");
}
return true;
}else{
error_log(var_export($result->errorInfo(),true));
return false;
}
}
function setSIP($sip_endpoint, $sip_msg,$sip_username,$sip_password,$sip_header,$company_id)
{
$sip_endpoint = $this->db->escape($sip_endpoint);
$sip_msg = $this->db->escape($sip_msg);
$sip_username = $this->db->escape($sip_username);
$sip_password = $this->db->escape($sip_password);
$sip_header = $this->db->escape($sip_header);
$company_id = $this->db->escape($company_id);
$result = $this->db->prepare("UPDATE companies SET sip_endpoint=?,sip_msg=? ,sip_username=?,sip_password=?,sip_header=? WHERE idx=?");
if($result->execute(array($sip_endpoint,$sip_msg,$sip_username,$sip_password,$sip_header,$company_id)))
{
return true;
}else{
error_log(var_export($result->errorInfo(),true));
return false;
}
}
function getPreviousOutgoingNumbertoCall($callTo,$callFrom,$company_id)
{
$check1 = false;
$callTo = str_replace(" ","+",$this->db->escape(trim($callTo)));
$callFrom = str_replace(" ","+",$this->db->escape(trim($callFrom)));
if(substr($callTo,0,1)!=="+")
$callTo = "+".$callTo;
if(substr($callFrom,0,1)!=="+")
$callFrom = "+".$callFrom;
$query = $this->db->prepare("SELECT DialCallTo FROM calls WHERE CallTo = ? AND CallFrom = ? AND DialCallStatus = 'completed'");
$query->execute(array($callTo,$callFrom));
$data = $query->fetch(PDO::FETCH_OBJ);
if($data){
$stmt = $this->customQuery("SELECT * FROM cf_round_robin WHERE company_id = $company_id GROUP BY idx ASC");
$round_robin_numbers = $stmt->fetchAll(PDO::FETCH_OBJ);
foreach($round_robin_numbers as $number) { if($number->number == $data->DialCallTo) $check1 = true; }
$stmt = $this->customQuery("SELECT * FROM cf_multiple_numbers WHERE company_id = $company_id GROUP BY idx ASC");
$multiple_numbers = $stmt->fetchAll(PDO::FETCH_OBJ);
foreach($multiple_numbers as $number) { if($number->number == $data->DialCallTo) $check1 = true; }
$numbers = array();
$stmt = $this->customQuery("SELECT wId, flowtype FROM call_ivr_widget WHERE (`flowtype` = 'MultipleNumbers' OR `flowtype` = 'RoundRobin') AND `companyId` = $company_id");
$widgets = $stmt->fetchAll(PDO::FETCH_OBJ);
foreach($widgets as $widget){
if($widget->flowtype == "MultipleNumbers"){
$stmt = $this->customQuery("SELECT number FROM call_ivr_multiple_numbers WHERE wId = ".$widget->wId);
$mn = $stmt->fetchAll(PDO::FETCH_OBJ);
foreach($mn as $number) {$numbers[] = $number->number;}
}else{
$stmt = $this->customQuery("SELECT number FROM call_ivr_round_robin WHERE wId = ".$widget->wId);
$mn = $stmt->fetchAll(PDO::FETCH_OBJ);
foreach($mn as $number) {$numbers[] = $number->number;}
}
}
if(in_array($data->DialCallTo,$numbers))
$check1 = true;
}
if((@$data->DialCallTo!="" || @$data->DialCallTo!="+1") && $check1===true)
return $data->DialCallTo;
else
return false;
}
function getCompanySettings($company_id)
{
$stmt = $this->db->prepare("SELECT whisper,whisper_type,whisper_voice,whisper_language,recording_notification,recording_notification_type,recording_notification_voice,recording_notification_language,recording_disable,record_from_ring,call_flow,international,international_closed,assigned_number,last_roundrobin,sip_endpoint,sip_msg,sip_username,sip_password,sip_header ,voicemail,voicemail_closed,close_number,opt_hours,forward_number,forward_sec,voicemail_type,voicemail_content,voicemail_text_voice,voicemail_text_language,ring_count,send_transcript,transcriptEmail,blacklist_id FROM companies WHERE idx=:company_id");
$stmt->execute(array(":company_id"=>$company_id));
return $stmt->fetch(PDO::FETCH_OBJ);
}
function updateCompanySettings($settings)
{
$stmt = $this->db->prepare("UPDATE companies SET
whisper=:whisper,
whisper_type=:whisper_type,
whisper_voice=:whisper_voice,
whisper_language=:whisper_language,
recording_notification=:recording_notification,
recording_notification_type=:recording_notification_type,
recording_notification_voice=:recording_notification_voice,
recording_notification_language=:recording_notification_language,
recording_disable=:rec_dis,
record_from_ring=:rec_ring
WHERE idx=:id");
if($stmt->execute(array(
":whisper"=>$settings['whisper'],
":whisper_type"=>$settings['whisper_type'],
":whisper_voice"=>$settings['whisper_voice'],
":whisper_language"=>$settings['whisper_language'],
":recording_notification"=>$settings['recording_notification'],
":recording_notification_type"=>$settings['recording_notification_type'],
":recording_notification_voice"=>$settings['recording_notification_voice'],
":recording_notification_language"=>$settings['recording_notification_language'],
"rec_dis"=>$settings['rec_disable'],
"rec_ring"=>$settings['record_from_ring'],
":id"=>$settings['id']))){
return true;
}else{
return false;
}
}
function isCompanyRecordingDisabled($company_id)
{
$stmt = $this->db->prepare("SELECT `recording_disable` FROM companies WHERE `idx`=:id");
$stmt->execute(array(":id"=>$company_id));
if($stmt->fetch(PDO::FETCH_OBJ)->recording_disable==1)
return true;
else
return false;
}
function setCompanyRecordingDisable($company_id,$num)
{
$stmt = $this->db->prepare("UPDATE companies SET `recording_disable`=:num WHERE `idx`=:id");
if($stmt->execute(array(":id"=>$company_id,":num"=>$num)))
return true;
else
return false;
}
/**
* @param $user_id
* @return int
*/
function getCompanyCountForUser($user_id){
$user_id = $this->db->escape($user_id);
$result = $this->db->query("SELECT * FROM user_company WHERE user_id='$user_id';");
$count = 0;
foreach ($result as $row)
{
$count++;
}
return $count;
}
function getCompaniesForUser($user_id)
{
$user_id = $this->db->escape($user_id);
$result = $this->db->query("SELECT * FROM user_company WHERE user_id='$user_id'");
return $result;
}
/**
* @param $user_id
* @param $new_pass
* @return bool
*/
function changePassword($user_id,$new_pass)
{
$user_id = $this->db->escape($user_id);
$new_pass = md5($new_pass);
$result = $this->db->prepare("UPDATE users SET password=? WHERE `idx`=?");
if($result->execute(array($new_pass,$user_id)))
{
return true;
}else{
return false;
}
}
function getAllCompanies($pagination = false, $search_query = ""){
$where = "%%";
if(isset($search_query) && $search_query !== "")
$where = "%".$search_query."%";
if($pagination !== false)
$result = $this->db->prepare("SELECT * FROM companies WHERE `company_name` LIKE ? GROUP BY `company_name` ASC ".$pagination->getLimitSql());
else
$result = $this->db->prepare("SELECT * FROM companies WHERE `company_name` LIKE ? GROUP BY `company_name` ASC;");
$result->execute(array($where));
$result = $result->fetchAll(PDO::FETCH_ASSOC);
$companies = array();
foreach($result as $row)
{
$row['company_name'] = $this->db->escape($row['company_name']);
array_push($companies, $row);
}
return $companies;
}
/**
* @param $user_id
* @return array
*/
function getAllCompaniesForUser($user_id, $pagination = false, $search_query = ""){
$user_id = $this->db->escape($user_id);
$resultCompanyIds = $this->db->prepare("SELECT * FROM user_company WHERE user_id=?");
$resultCompanyIds->execute(array($user_id));
$resultCompanyIds = $resultCompanyIds->fetchAll(PDO::FETCH_ASSOC);
$where = "";
if(isset($search_query) && $search_query !== "")
$where = "%".$search_query."%";
$companyIds = array();
foreach($resultCompanyIds as $rowc)
{
$companyIds[] = $rowc['company_id'];
}
if($pagination !== false)
$result = $this->db->prepare("SELECT * FROM companies WHERE `idx` IN (".implode(",",$companyIds).") ".((strlen($where)>0)?"AND `company_name` LIKE ?":"")." GROUP BY `company_name` ASC ".$pagination->getLimitSql());
else
$result = $this->db->prepare("SELECT * FROM companies WHERE `idx` IN (".implode(",",$companyIds).") ".((strlen($where)>0)?"AND `company_name` LIKE ?":"")." GROUP BY `company_name` ASC;");
$result->execute(array($where));
$result = $result->fetchAll(PDO::FETCH_ASSOC);
return $result;
}
/**
* @param $company_id
* @return array
*/
function getCompanyNum($company_id)
{
$result = $this->db->query("SELECT number FROM company_num WHERE company_id='$company_id' AND pool_id IS NULL");
$numbers = array();
foreach($result as $row)
{
$numbers[] = $row['number'];
}
return $numbers;
}
/**
* @param $company_id
* @return array
*/
function companyHasNum($company_id, $number)
{
$number = $this->format_phone_db($number);
$result = $this->db->prepare("SELECT COUNT(*) as total FROM company_num WHERE company_id = ? AND number = ? AND pool_id IS NULL");
$result->execute(array($company_id, $number));
$data = $result->fetch();
if ($data['total'] > 0)
return true;
else
return false;
}
function getAllCompanyNum()
{
$result = $this->db->query("SELECT number,international FROM company_num WHERE pool_id IS NULL");
$numbers = array();
if($result === false)
return false;
else{
foreach($result as $row)
{
$disabled = false;
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$disabled_numbers = $this->getUserAccessNumbers($_SESSION['user_id']);
$number_array = array();
foreach($disabled_numbers as $disabled_number)
{
$number_array[] = $disabled_number->number;
}
if(count($number_array)>0)
{
foreach($number_array as $d_number)
{
if($row['international']==0)
$number_ = "+1".$row['number'];
else
$number_ = $row['number'];
if($number_===$d_number)
$disabled = true;
}
}
}
}
if($disabled)
continue;
if($row['international']==1)
$intl = true;
else
$intl = false;
$numbers[] = array($row['number'],$intl);
}
}
return $numbers;
}
function getCompanyNumIntlForUser($company_id,$user_id)
{
$company_id = $this->db->escape($company_id);
$result = $this->db->query("SELECT number,international FROM company_num WHERE company_id='$company_id' AND pool_id IS NULL");
$numbers = array();
if($result === false)
return false;
else{
foreach($result as $row)
{
$disabled = false;
if(@$user_id!="")
{
if(!$this->isUserAdmin($user_id))
{
$disabled_numbers = $this->getUserAccessNumbers($user_id);
$number_array = array();
foreach($disabled_numbers as $disabled_number)
{
$number_array[] = $disabled_number->number;
}
if(count($number_array)>0)
{
foreach($number_array as $d_number)
{
if($row['international']==0)
$number_ = "+1".$row['number'];
else
$number_ = $row['number'];
if($number_===$d_number)
$disabled = true;
}
}
}
}
if($disabled)
continue;
if($row['international']==1)
$intl = true;
else
$intl = false;
$numbers[] = array($row['number'],$intl);
}
}
return $numbers;
}
/**
* @param $company_id
* @return array
*/
function getCompanyNumIntl($company_id)
{
$company_id = $this->db->escape($company_id);
$result = $this->db->query("SELECT number,international FROM company_num WHERE company_id='$company_id' AND pool_id IS NULL");
$numbers = array();
if($result === false)
return false;
else{
foreach($result as $row)
{
$disabled = false;
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$disabled_numbers = $this->getUserAccessNumbers($_SESSION['user_id']);
$number_array = array();
foreach($disabled_numbers as $disabled_number)
{
$number_array[] = $disabled_number->number;
}
if(count($number_array)>0)
{
foreach($number_array as $d_number)
{
if($row['international']==0)
$number_ = "+1".$row['number'];
else
$number_ = $row['number'];
if($number_===$d_number)
$disabled = true;
}
}
}
}
if($disabled)
continue;
if($row['international']==1)
$intl = true;
else
$intl = false;
$numbers[] = array($row['number'],$intl);
}
}
return $numbers;
}
/**
* @param $company_id
* @return array
*/
function getCompanyNumIntlPool($company_id)
{
$company_id = $this->db->escape($company_id);
$result = $this->db->query("SELECT number,international FROM company_num WHERE company_id='$company_id' AND pool_id IS NOT NULL");
$numbers = array();
if($result === false)
return false;
else{
foreach($result as $row)
{
$disabled = false;
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$disabled_numbers = $this->getUserAccessNumbers($_SESSION['user_id']);
$number_array = array();
foreach($disabled_numbers as $disabled_number)
{
$number_array[] = $disabled_number->number;
}
if(count($number_array)>0)
{
foreach($number_array as $d_number)
{
if($row['international']==0)
$number_ = "+1".$row['number'];
else
$number_ = $row['number'];
if($number_===$d_number)
$disabled = true;
}
}
}
}
if($disabled)
continue;
if($row['international']==1)
$intl = true;
else
$intl = false;
$numbers[] = array($row['number'],$intl);
}
}
return $numbers;
}
function getPhoneCodeTemplates()
{
$result = $this->db->query("SELECT * FROM phone_code_templates;");
$pc_templates = array();
foreach($result as $row)
{
$pc_templates[] = $row;
}
return $pc_templates;
}
function getBlacklists()
{
$result = $this->db->query("SELECT * FROM blacklists;");
$blacklists = array();
foreach($result as $row)
{
$blacklists[] = array($row['idx'], $row['name'], $row['numbers']);
}
return $blacklists;
}
function getBlacklist($id)
{
$id = $this->db->escape($id);
$result = $this->db->query("SELECT * FROM blacklists WHERE `idx`=".$id.";");
$results = array();
if($result === false)
return "";
else{
foreach($result as $row){
$results[] = $row['numbers'];
}
}
if(@$results[0]===false)
{
return "";
}else{
return @$results[0];
}
}
function editCompanyBlacklist($company_id,$blacklist_id)
{
$result = $this->db->prepare("UPDATE companies SET `blacklist_id`=:blid WHERE `idx`=:id");
$params = array(":blid"=>$blacklist_id, ":id"=>$company_id);
if($result->execute($params))
return true;
else
return false;
}
function editBlacklist($id,$numbers)
{
$result = $this->db->prepare("UPDATE blacklists SET numbers=:num WHERE `idx`=:id");
$params = array(":id"=>$id,":num"=>$numbers);
if($result->execute($params))
return true;
else
return false;
}
function isNumberBlocked($company_id,$number)
{
$number = str_replace("+", "", $number);
$company_id = $this->db->escape($company_id);
$settings = $this->getCompanySettings($company_id);
if($settings->blacklist_id == 0) return false;
$numbers = str_replace("+", "", $this->getBlacklist($settings->blacklist_id));
if (!empty($numbers) && !empty($number)) {
if (strpos($numbers, $number) !== false) {
return true;
}
}
return false;
}
function getBlacklistName($id)
{
$id = $this->db->escape($id);
$result = $this->db->query("SELECT `name` FROM blacklists WHERE `idx`=".$id);
if($result === false)
return "";
else{
$result = $result->fetch();
return $result['name'];
}
}
function getCallerId($company_id)
{
$company_id = $this->db->escape($company_id);
$result = $this->db->query("SELECT `callerid` FROM `companies` WHERE `idx`=".$company_id);
if($result === false)
return false;
else{
$result = $result->fetch();
return $result['callerid'];
}
}
function setCallerId($company_id,$number)
{
$company_id = $this->db->escape($company_id);
$number = $this->db->escape($number);
$result = $this->db->prepare("UPDATE `companies` SET `callerid`=:callerid WHERE `idx`=:id;");
if($result->execute(array(":callerid"=>$number,":id"=>$company_id)))
return true;
else
return false;
}
/**
* @return int
*/
function getUserCount(){
$result = $this->db->query("SELECT idx FROM users;");
$count = 0;
foreach ($result as $row)
{
$count++;
}
return $count;
}
function getUser($user_id){
$stmt = $this->db->prepare("SELECT * FROM users WHERE idx = ?");
$stmt->execute(array($user_id));
return $stmt->fetch(PDO::FETCH_OBJ);
}
/**
* @return array
*/
function getAllUsers(){
$result = $this->db->query("SELECT * FROM users;");
$result = $result->fetchAll(PDO::FETCH_ASSOC);
$users = array();
foreach($result as $row)
{
$resultCompany = $this->db->query("SELECT * FROM user_company WHERE user_id='".$row['idx']."'");
$resultCompany = $resultCompany->fetchAll(PDO::FETCH_ASSOC);
$companies = array();
foreach($resultCompany as $rowc)
{
$resultCompanyDetail = $this->db->query("SELECT * FROM companies WHERE idx='".$rowc['company_id']."'");
$resultCompanyDetail = $resultCompanyDetail->fetchAll(PDO::FETCH_ASSOC);
foreach($resultCompanyDetail as $rowcd)
{
$companies[] = array($rowcd['idx'],$this->db->escape($rowcd['company_name']));
}
}
$users[] = array("user_data" => $row, "user_companies"=> $companies);
}
return $users;
}
function getAllUsersLimited(){
$result = $this->db->query("SELECT DISTINCT full_name, email FROM users WHERE email != '' AND full_name IS NOT NULL");
$result = $result->fetchAll(PDO::FETCH_OBJ);
return $result;
}
/**
* @param $user_id
* @return mixed
*/
function getUserName($user_id)
{
$user_id = $this->db->escape($user_id);
$result = $this->db->query("SELECT username FROM users WHERE idx='$user_id'");
$result = $result->fetch();
return $result['username'];
}
function userLogout($user_id){
$this->setUserStatus($user_id,"OFFLINE");
}
function getUserStatus($user_id){
$stmt = $this->db->prepare("SELECT status FROM users WHERE idx = ?");
$stmt->execute(array($user_id));
$data = $stmt->fetch(PDO::FETCH_OBJ);
return $data->status;
}
function setUserStatus($user_id,$status){
$stmt = $this->db->prepare("UPDATE users SET `status` = ? WHERE `idx` = ?");
$stmt->execute(array($status,$user_id));
}
function updateUserStatusTime($user_id){
$stmt = $this->db->prepare("SELECT * FROM users WHERE idx = ?");
$stmt->execute(array($user_id));
$user = $stmt->fetch(PDO::FETCH_OBJ);
$stmt = $this->db->prepare("UPDATE users SET status_update_time = ? WHERE idx = ?");
$stmt->execute(array(strtotime("now"),$user_id));
}
function getUserAccessNumbers($user_id)
{
$stmt = $this->db->prepare("SELECT `number` FROM user_incoming_num_access WHERE user_id=?");
if($stmt->execute(array($user_id)))
{
return $stmt->fetchAll(PDO::FETCH_OBJ);
}else{
return false;
}
}
function saveUserAccessNumbers($user_id,$disabled_phones)
{
$stmt = $this->db->prepare("DELETE FROM user_incoming_num_access WHERE `user_id`=?");
if($stmt->execute(array($user_id)))
{
if( is_array($disabled_phones) || is_object($disabled_phones) )
foreach($disabled_phones as $disabled_phone)
{
$stmt2 = $this->db->prepare("INSERT INTO user_incoming_num_access (`user_id`,`number`) VALUES (?,?)");
if(!$stmt2->execute(array($user_id,$disabled_phone)))
return false;
}
}else{
return false;
}
}
function getUserOutgoingAccessNumbers($user_id)
{
$stmt = $this->db->prepare("SELECT `number` FROM user_outgoing_num_access WHERE user_id=?");
if($stmt->execute(array($user_id)))
{
return $stmt->fetchAll(PDO::FETCH_OBJ);
}else{
return false;
}
}
function saveUserOutgoingAccessNumbers($user_id,$phone_numbers)
{
$stmt = $this->db->prepare("DELETE FROM user_outgoing_num_access WHERE `user_id`=?");
if($stmt->execute(array($user_id)))
{
if( is_array($phone_numbers) || is_object($phone_numbers) )
foreach($phone_numbers as $phone)
{
if($phone=="")
continue;
$stmt2 = $this->db->prepare("INSERT INTO user_outgoing_num_access (`user_id`,`number`) VALUES (?,?)");
if(!$stmt2->execute(array($user_id,$phone)))
return false;
}
}else{
return false;
}
}
function getUserAccessRange($user_id)
{
$user_id = $this->db->escape($user_id);
$stmt = $this->db->prepare("SELECT access_from,access_type FROM users WHERE idx=?");
if($stmt->execute(array($user_id)))
{
$data = $stmt->fetch(PDO::FETCH_OBJ);
if($data->access_from!=NULL)
{
return array($data->access_from, $data->access_type);
}else{
return false;
}
}else{
return false;
}
}
function isUserOutboundLinksDisabled($userid)
{
$stmt = $this->db->prepare("SELECT disable_outbound_link FROM users WHERE idx=?");
$stmt->execute(array($userid));
$res = $stmt->fetch(PDO::FETCH_OBJ);
return $res->disable_outbound_link;
}
function setUserOutboundLinkDisable($userid,$disabled)
{
$stmt = $this->db->prepare("UPDATE users SET disable_outbound_link=? WHERE idx=?");
$stmt->execute(array($disabled,$userid));
}
function isUserAbleToSetPhoneCodes($userid){
@session_start();
if(@$_SESSION['prems']['set_phone_code']=="" || $userid !== $_SESSION['user_id']){
$stmt = $this->db->prepare("SELECT allow_assign_phone_code FROM users WHERE idx=?");
$stmt->execute(array($userid));
$res = $stmt->fetch(PDO::FETCH_OBJ);
if($res->allow_assign_phone_code==1){
$_SESSION['prems']['set_phone_code'] = true;
return true;
}else{
$_SESSION['prems']['set_phone_code'] = false;
return false;
}
}else{
return $_SESSION['prems']['set_phone_code'];
}
}
function setUserPhoneCodeAccess($userid,$disabled){
$stmt = $this->db->prepare("UPDATE users SET allow_assign_phone_code=? WHERE idx=?");
$stmt->execute(array($disabled,$userid));
}
function setUserAccessRange($user_id,$timestamp,$type)
{
$user_id = $this->db->escape($user_id);
$timestamp = $this->db->escape($timestamp);
if($timestamp==null)
{
$stmt = $this->db->prepare("UPDATE users SET access_from=NULL, access_type=0 WHERE idx=?");
if($stmt->execute(array($user_id)))
{
return true;
}else{
return false;
}
}else{
$stmt = $this->db->prepare("UPDATE users SET access_from=?, access_type=? WHERE idx=?");
if($stmt->execute(array($timestamp,$type,$user_id)))
{
return true;
}else{
return false;
}
}
}
function checkAddonAccess($user_id,$addon_id)
{
$stmt = $this->db->prepare("SELECT `access_lvl` FROM users WHERE idx=?");
if($stmt->execute(array($user_id)))
{
$data = $stmt->fetch(PDO::FETCH_OBJ);
if($data->access_lvl>0)
return true;
else{
$stmt = $this->db->prepare("SELECT * FROM `user_addon_access` WHERE `user_id`=? AND `addon_id`=?");
if($stmt->execute(array($user_id,$addon_id)))
{
if(count($stmt->fetchAll())>0)
return true;
else
return false;
}
}
}
return false;
}
function addAddonAccess($user_id,$addon_id)
{
$stmt = $this->db->prepare("SELECT * FROM `user_addon_access` WHERE `user_id`=? AND `addon_id`=?");
$stmt->execute(array($user_id,$addon_id));
if(count($stmt->fetchAll())>0)
return true;
else
{
$stmt = $this->db->prepare("INSERT INTO `user_addon_access`(`user_id`,`addon_id`) VALUES (?,?);");
$stmt->execute(array($user_id,$addon_id));
return true;
}
}
function removeAddonAccess($user_id,$addon)
{
$stmt = $this->db->prepare("DELETE FROM `user_addon_access` WHERE `user_id`=? AND `addon_id`=?");
$stmt->execute(array($user_id,$addon));
}
/**
* @param $username
* @param $password
* @return bool|int
*/
function authUser($username, $password)
{
$username = $this->db->escape($username);
$password = md5($password);
$result = $this->db->query("SELECT * FROM users WHERE username='$username'");
$data = $result->fetchAll();
$count = count(array_keys($data));
if($count != 0)
{
if($password == $data[0]['password'])
{
if(session_id() == '') {
session_start();
}
$_SESSION['user_id'] = $data[0]['idx'];
$_SESSION['permission'] = $data[0]['access_lvl'];
$_SESSION['username'] = $data[0]['username'];
$_SESSION['full_name'] = $data[0]['full_name'];
$_SESSION['handle'] = (!empty($data[0]['full_name']) ? $data[0]['full_name']." (".$data[0]['username'].")" : $data[0]['username']);
$_SESSION['sel_co'] = NULL;
$this->setUserStatus($_SESSION['user_id'], "ONLINE");
return 0;// Success.
}else{
return 1;// Wrong password.
}
}else{
return 2;// No such account.
}
return true;
}
function authUserAPI($username,$password_md5)
{
$result = $this->db->query("SELECT * FROM users WHERE username='$username'");
$data = $result->fetchAll();
$count = count(array_keys($data));
if($count != 0)
{
if($password_md5 == $data[0]['password'])
{
@session_start();
$_SESSION['user_id'] = $data[0]['idx'];
$_SESSION['permission'] = $data[0]['access_lvl'];
$_SESSION['username'] = $data[0]['username'];
$_SESSION['sel_co'] = NULL;
return array(true,$data[0]['idx']);
}else{
return array(false,1);
}
}else{
return array(false,2); // No such account
}
}
/**
* @param $user_id
* @return bool
*/
function promoteUserToAdmin($user_id)
{
$user_id = $this->db->escape($user_id);
$result = $this->db->prepare("UPDATE users SET access_lvl='1' WHERE idx=?");
if($result->execute(array($user_id)))
{
return true;
}else{
return false;
}
}
/**
* @param $user_id
* @return bool
*/
function demoteUser($user_id)
{
$user_id = $this->db->escape($user_id);
$result = $this->db->prepare("UPDATE users SET access_lvl='0' WHERE idx=?");
if($result->execute(array($user_id)))
{
return true;
}else{
return false;
}
}
/**
* @param $username
* @param $full_name
* @param $password
* @return bool
*/
function createNewUser($username,$full_name,$password,$email)
{
$username = $this->db->escape($username);
$full_name = $this->db->escape($full_name);
$password = $this->db->escape($password);
$email = $this->db->escape($email);
$result = $this->db->prepare("INSERT INTO users (username,password,access_lvl,full_name,email) VALUES (?,?,0,?,?);");
$params = array($username,md5($password),$full_name,$email);
$stmt = $this->db->prepare("SELECT COUNT(*) as total FROM users WHERE username = ?");
$stmt->execute(array($username));
$count = $stmt->fetch(PDO::FETCH_ASSOC);
$count = $count['total'];
if($count!=0)
return 'exist';
else{
if($result->execute($params)){
$userid = $this->db->lastInsertId();
return $this->getUser($userid);
}
else
return false;
}
}
/**
* @param $id
* @return bool
*/
function deleteUser($id)
{
$id = $this->db->escape($id);
$result = $this->db->prepare("DELETE FROM users WHERE idx=?");
if($result->execute(array($id)))
return true;
else
return false;
}
/**
* @param $user
* @param $start_date
* @param $end_date
* @param $company
* @param $call_result
* @return array
*/
function getCallReportforExport($user,$start_date,$end_date,$company,$call_result,$phone_code,$outgoing_filter, $outgoing = false, $filter_user = "", $campaign, $agent = "")
{
try
{
if(!$this->isUserInCompany($company, $user) && !$this->isUserAdmin($user))
return array(false, "AUTH_FAIL");
//$start_date = $this->db->escape($start_date);
//$end_date = $this->db->escape($end_date);
$company = $this->db->escape($company);
$call_result = $this->db->escape($call_result);
$number_filter = "";
//Get Numbers of the Company
if($company==-1)
{
$resultCompany = $this->db->query("SELECT number,international FROM company_num;");
$numbers = $resultCompany->fetchAll();
foreach($numbers as $number)
{
$disabled = false;
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$disabled_numbers = $this->getUserAccessNumbers($_SESSION['user_id']);
$number_array = array();
foreach($disabled_numbers as $disabled_number)
{
$number_array[] = $disabled_number->number;
}
if(count($number_array)>0)
{
foreach($number_array as $d_number)
{
if($number['international']==0)
$number_ = "+1".$number['number'];
else
$number_ = $number['number'];
if($number_===$d_number)
$disabled = true;
}
}
}
}
if($disabled)
continue;
if($number['international']==0)
$number_filter .= "'+1".$number['number']."', ";
else
$number_filter .= "'+".$number['number']."', ";
}
$number_filter = substr($number_filter, 0, -2);
}else{
$resultCompany = $this->db->query("SELECT number,international FROM company_num WHERE company_id='$company'");
$numbers = $resultCompany->fetchAll();
foreach($numbers as $number)
{
$disabled = false;
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$disabled_numbers = $this->getUserAccessNumbers($_SESSION['user_id']);
$number_array = array();
foreach($disabled_numbers as $disabled_number)
{
$number_array[] = $disabled_number->number;
}
if(count($number_array)>0)
{
foreach($number_array as $d_number)
{
if($number['international']==0)
$number_ = "+1".$number['number'];
else
$number_ = $number['number'];
if($number_===$d_number)
$disabled = true;
}
}
}
}
if($disabled)
continue;
if($number['international']==0)
$number_filter .= "'+1".$number['number']."', ";
else
$number_filter .= "'+".$number['number']."', ";
}
$number_filter = substr($number_filter, 0, -2);
}
$filter_user_add = "";
if($filter_user!="" || $filter_user!=0){
$filter_user_add = " AND UserSource = ".$filter_user;
}
$outgoing_filter_add = "";
if($outgoing_filter!="" && $outgoing==false)
{
$outgoing_filter_add = " AND (DialCallTo LIKE '%".$outgoing_filter."' OR CallTo LIKE '%".$outgoing_filter."') ";
}
$ringto_numbers = "";
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$filter_ringto_numbers = $this->getUserOutgoingAccessNumbers($_SESSION['user_id']);
if(count($filter_ringto_numbers)>0)
{
foreach($filter_ringto_numbers as $ringto_num)
{
$ringto_numbers .= "'".$ringto_num->number."', ";
}
$ringto_numbers = substr($ringto_numbers,0,-2);
$ringto_numbers = " AND DialCallTo IN (".$ringto_numbers.")";
}
}
}
$extra_ad = "";
if($outgoing==false){
$table = "calls";
$target_field = "CallTo";
$duration_field = "DialCallDuration";
}else{
$table = "outbound_calls";
$target_field = "CallFrom";
$duration_field = "CallDuration";
if (empty($_GET['agent']))
$extra_ad = " AND MadeUsing != 'autodialer' ";
}
$phone_code_add = "";
if($phone_code!=0)
{
$phone_code_add = "AND `PhoneCode`='".$this->db->escape($phone_code)."'";
}
//Generate Some filters
$call_result_filter = "";
switch($call_result)
{
case "answered":
{
$call_result_filter = " AND `DialCallStatus`='completed'";
break;
}
case "missed":
{
$call_result_filter = " AND `DialCallStatus`='no-answer'";
break;
}
case "busy":
{
$call_result_filter = " AND `DialCallStatus`='busy'";
break;
}
case "error":
{
$call_result_filter = " AND `DialCallStatus`='failed'";
break;
}
case "voicemail":
{
$call_result_filter = " AND `DialCallStatus`='voicemail'";
break;
}
case 30:
case 45:
case 60:
case 90:
case 120:
case 180:
case 240:
case 300:
case 360:
case 420:
case 480:
case 540:
case 600:
case 1200:
case 1800:
case 2400:
{
$call_result_filter = " AND `$duration_field` > ".$call_result;
break;
}
case "all":
{
$call_result_filter = "";
break;
}
}
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$access_range = $this->getUserAccessRange($_SESSION['user_id']);
if($access_range!=false)
{
if($access_range[1]==1){
if(($start_date)<strtotime($access_range[0]))
{
$start_date = strtotime($access_range[0]);
}
}else{
if(($end_date)>strtotime($access_range[0]))
{
$end_date = strtotime($access_range[0]);
}
}
}
}
}
$agent_filter_add = "";
if (!empty($agent) && !$outgoing) {
$agent_details = $this->customExecute("SELECT * FROM users WHERE username = ? OR full_name = ? LIMIT 1");
$agent_details->execute(array($agent, $agent));
$agent_details = $agent_details->fetch(PDO::FETCH_ASSOC);
if (!empty($agent_details)) {
$name = trim($agent_details['full_name']);
if (empty($name)) $name = trim($agent_details['username']);
else $name .= " (".$agent_details['username'].")";
$agent_filter_add = " AND participants LIKE '[\"".$name."%' ";
}
}
elseif (!empty($agent) && $outgoing) {
$agent_details = $this->customExecute("SELECT id FROM users WHERE username = ? OR full_name = ? LIMIT 1");
$agent_details->execute(array($agent, $agent));
$agent_details = $agent_details->fetch(PDO::FETCH_ASSOC);
if (!empty($agent_details)) {
$user_add = " AND UserSource = ".$agent_details['idx'];
}
}
if (empty($number_filter)) {
$calls = array();
}
else {
$result = $this->db->query("SELECT * FROM $table WHERE
`$target_field` IN ($number_filter)" .
$extra_ad .
$ringto_numbers .
$outgoing_filter_add." AND
`DateCreated` BETWEEN '".date("Y-m-d H:i:s",$start_date)."' AND
'".date("Y-m-d H:i:s",$end_date)."'".$call_result_filter." ".$phone_code_add." ".$filter_user_add.$agent_filter_add);
$calls = $result->fetchAll();
}
$twilio_numbers = Util::get_all_twilio_numbers();
if (!empty($campaign)) {
$number_filter = "";
}
foreach($calls as $key => $call)
{
if($call['CallTo']!="")
{
if (array_key_exists(format_phone($call['CallTo']), $twilio_numbers))
{
$this_campaign=(string)$twilio_numbers[format_phone($call['CallTo'])];
}
else
$this_campaign="";
}
if (empty($campaign) || $campaign === "false" || (!empty($campaign) && $campaign == $this_campaign)) {
$number_filter .= "'".$call['CallTo']."', ";
}
}
$number_filter = substr($number_filter, 0, -2);
$number_filter = str_replace("''", "','", $number_filter);
$result = $this->db->query("SELECT * FROM $table WHERE
`$target_field` IN ($number_filter)" .
$ringto_numbers .
$outgoing_filter_add." AND
`DateCreated` BETWEEN '".date("Y-m-d H:i:s",$start_date)."' AND
'".date("Y-m-d H:i:s",$end_date)."'".$call_result_filter." ".$phone_code_add." ".$filter_user_add.$agent_filter_add);
return array(true,$result->fetchAll());
}catch(exception $ex)
{
return array(false,0);
}
}
/**
* @param $user
* @param $start_date
* @param $end_date
* @param $company
* @param $call_result
* @param $pagination
* @return array|bool
*/
function getCallReport($user,$start_date,$end_date,$company,$call_result,$phone_code,$pagination,$outgoing_filter,$campaign = "",$agent = "",$order_by = "DateCreated", $order_type = "DESC")
{
try{
require_once('Pagination.php');
if(!$this->isUserInCompany($company, $user) && !$this->isUserAdmin($user))
return false;
//$start_date = $this->db->escape($start_date);
//$end_date = $this->db->escape($end_date);
$company = $this->db->escape($company);
$call_result = $this->db->escape($call_result);
$number_filter = "";
$twilio_numbers = Util::get_all_twilio_numbers();
//Get Numbers of the Company
if($company==-1)
{
$resultCompany = $this->db->query("SELECT number,international FROM company_num;");
$numbers = $resultCompany->fetchAll();
foreach($numbers as $number)
{
$disabled = false;
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$disabled_numbers = $this->getUserAccessNumbers($_SESSION['user_id']);
$number_array = array();
foreach($disabled_numbers as $disabled_number)
{
$number_array[] = $disabled_number->number;
}
if(count($number_array)>0)
{
foreach($number_array as $d_number)
{
if($number['international']==0)
$number_ = "+1".$number['number'];
else
$number_ = $number['number'];
if($number_===$d_number)
$disabled = true;
}
}
}
}
if($disabled)
continue;
if($number['international']==0)
$number_filter .= "'+1".$number['number']."', ";
else
$number_filter .= "'+".$number['number']."', ";
}
$number_filter = substr($number_filter, 0, -2);
}else{
$resultCompany = $this->db->query("SELECT number,international FROM company_num WHERE company_id='$company'");
$numbers = $resultCompany->fetchAll();
foreach($numbers as $number)
{
$disabled = false;
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$disabled_numbers = $this->getUserAccessNumbers($_SESSION['user_id']);
$number_array = array();
foreach($disabled_numbers as $disabled_number)
{
$number_array[] = $disabled_number->number;
}
if(count($number_array)>0)
{
foreach($number_array as $d_number)
{
if($number['international']==0)
$number_ = "+1".$number['number'];
else
$number_ = $number['number'];
if($number_===$d_number)
$disabled = true;
}
}
}
}
if($disabled)
continue;
if($number['international']==0)
$number_filter .= "'+1".$number['number']."', ";
else
$number_filter .= "'+".$number['number']."', ";
}
$number_filter = substr($number_filter, 0, -2);
}
$phone_code_add = "";
if($phone_code!=0)
{
$phone_code_add = "AND `PhoneCode`='".$this->db->escape($phone_code)."'";
}
//Generate Some filters
$call_result_filter = "";
switch($call_result)
{
case "answered":
{
$call_result_filter = " AND `DialCallStatus`='completed'";
break;
}
case "missed":
{
$call_result_filter = " AND `DialCallStatus`='no-answer'";
break;
}
case "busy":
{
$call_result_filter = " AND `DialCallStatus`='busy'";
break;
}
case "error":
{
$call_result_filter = " AND `DialCallStatus`='failed'";
break;
}
case "voicemail":
{
$call_result_filter = " AND `DialCallStatus`='voicemail'";
break;
}
case 30:
case 45:
case 60:
case 90:
case 120:
case 180:
case 240:
case 300:
case 360:
case 420:
case 480:
case 540:
case 600:
case 1200:
case 1800:
case 2400:
{
$call_result_filter = " AND `DialCallStatus`!='no-answer' AND `DialCallDuration` > ".$call_result;
break;
}
case "all":
{
$call_result_filter = "";
break;
}
}
$outgoing_filter_add = "";
if($outgoing_filter!="")
{
$outgoing_filter_add = " AND (DialCallTo LIKE '%".$outgoing_filter."' OR CallTo LIKE '%".$outgoing_filter."') ";
}
$ringto_numbers = "";
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$access_range = $this->getUserAccessRange($_SESSION['user_id']);
if($access_range!=false)
{
if($access_range[1]==1){
if(($start_date)<strtotime($access_range[0]))
{
$start_date = strtotime($access_range[0]);
}
}else{
if(($end_date)>strtotime($access_range[0]))
{
$end_date = strtotime($access_range[0]);
}
}
}
$filter_ringto_numbers = $this->getUserOutgoingAccessNumbers($_SESSION['user_id']);
if(count($filter_ringto_numbers)>0)
{
foreach($filter_ringto_numbers as $ringto_num)
{
$ringto_numbers .= "'".$ringto_num->number."', ";
}
$ringto_numbers = substr($ringto_numbers,0,-2);
$ringto_numbers = " AND DialCallTo IN (".$ringto_numbers.")";
}
}
}
$agent_filter_add = "";
if (!empty($agent) && !$outgoing) {
$agent_details = $this->customExecute("SELECT * FROM users WHERE username = ? OR full_name = ? LIMIT 1");
$agent_details->execute(array($agent, $agent));
$agent_details = $agent_details->fetch(PDO::FETCH_ASSOC);
if (!empty($agent_details)) {
$name = trim($agent_details['full_name']);
if (empty($name)) $name = trim($agent_details['username']);
else $name .= " (".$agent_details['username'].")";
$agent_filter_add = " AND participants LIKE '[\"".$name."%' ";
}
}
elseif (!empty($agent) && $outgoing) {
$agent_details = $this->customExecute("SELECT id FROM users WHERE username = ? OR full_name = ? LIMIT 1");
$agent_details->execute(array($agent, $agent));
$agent_details = $agent_details->fetch(PDO::FETCH_ASSOC);
if (!empty($agent_details)) {
$user_add = " AND UserSource = ".$agent_details['idx'];
}
}
$total_duration = 0;
$count = 0;
if (empty($number_filter)) {
$calls = array();
}
else {
$result = $this->db->query("SELECT * FROM calls WHERE `CallTo` IN ($number_filter)".$ringto_numbers.$outgoing_filter_add.$agent_filter_add." AND `DateCreated` BETWEEN '".date("Y-m-d H:i:s",$start_date)."' AND '".date("Y-m-d H:i:s",$end_date)."'".$call_result_filter." ".$phone_code_add);
//$calls = $result->fetchAll();
if (!empty($campaign)) {
$number_filter = "";
}
while ($call = $result->fetch())
{
if($call['CallTo']!="")
{
if (array_key_exists(format_phone($call['CallTo']), $twilio_numbers))
{
$this_campaign=(string)$twilio_numbers[format_phone($call['CallTo'])];
}
else
$this_campaign="";
}
if (empty($campaign) || $campaign === "false" || (!empty($campaign) && $campaign == $this_campaign)) {
$call['campaign'] = $this_campaign;
$count++;
$number_filter .= "'".$call['CallTo']."', ";
$total_duration = $total_duration + (int)$call['DialCallDuration'];
}
else {
// unset($calls[$key]);
}
}
$number_filter = substr($number_filter, 0, -2);
}
$number_filter = str_replace("''", "','", $number_filter);
if (!empty($order_by) && !empty($order_type)) {
if ($order_by == "CityState")
$sort = " ORDER BY CONCAT(FromCity, FromState) ".$order_type;
else
$sort = " ORDER BY ".$order_by." ".$order_type;
}
$result = $this->db->query("SELECT * FROM calls WHERE `CallTo` IN ($number_filter)".$ringto_numbers.$outgoing_filter_add.$agent_filter_add." AND `DateCreated` BETWEEN '".date("Y-m-d H:i:s",$start_date)."' AND '".date("Y-m-d H:i:s",$end_date)."'".$call_result_filter." ".$phone_code_add." ".$sort." ".$pagination->getLimitSql());
if($result === false)
$data_arr = null;
else
$data_arr = $result->fetchAll();
return array($data_arr,$count,$total_duration);
}catch(Exception $ex)
{
return array(false, $ex);
}
}
function getOutgoingCallReport($user,$start_date,$end_date,$company,$call_result,$phone_code,$pagination,$filter_user,$campaign = "", $agent = "")
{
try{
require_once('Pagination.php');
if(!$this->isUserInCompany($company, $user) && !$this->isUserAdmin($user))
return false;
//$start_date = $this->db->escape($start_date);
//$end_date = $this->db->escape($end_date);
$company = $this->db->escape($company);
$call_result = $this->db->escape($call_result);
$number_filter = "";
//Get Numbers of the Company
if($company==-1)
{
if($this->isUserAdmin($user))
{
$resultCompany = $this->db->query("SELECT number,international FROM company_num;");
$numbers = $resultCompany->fetchAll();
foreach($numbers as $number)
{
if($number['international']==0)
$number_filter .= "'+1".$number['number']."', ";
else
$number_filter .= "'+".$number['number']."', ";
}
$number_filter = substr($number_filter, 0, -2);
}else{
return false;
}
}else{
$resultCompany = $this->db->query("SELECT number,international FROM company_num WHERE company_id='$company'");
$numbers = $resultCompany->fetchAll();
foreach($numbers as $number)
{
$disabled = false;
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$disabled_numbers = $this->getUserAccessNumbers($_SESSION['user_id']);
$number_array = array();
foreach($disabled_numbers as $disabled_number)
{
$number_array[] = $disabled_number->number;
}
if(count($number_array)>0)
{
foreach($number_array as $d_number)
{
if($number['international']==0)
$number_ = "+1".$number['number'];
else
$number_ = $number['number'];
if($number_===$d_number)
$disabled = true;
}
}
}
}
if($disabled)
continue;
if($number['international']==0)
$number_filter .= "'+1".$number['number']."', ";
else
$number_filter .= "'+".$number['number']."', ";
}
$number_filter = substr($number_filter, 0, -2);
}
$phone_code_add = "";
if($phone_code!=0)
{
$phone_code_add = "AND `PhoneCode`='".$this->db->escape($phone_code)."'";
}
//Generate Some filters
$call_result_filter = "";
switch($call_result)
{
case "answered":
{
$call_result_filter = " AND `DialCallStatus`='completed'";
break;
}
case "missed":
{
$call_result_filter = " AND `DialCallStatus`='no-answer'";
break;
}
case "busy":
{
$call_result_filter = " AND `DialCallStatus`='busy'";
break;
}
case "error":
{
$call_result_filter = " AND `DialCallStatus`='failed'";
break;
}
case "voicemail":
{
$call_result_filter = " AND `DialCallStatus`='voicemail'";
break;
}
case 30:
case 45:
case 60:
case 90:
case 120:
case 180:
case 240:
case 300:
case 360:
case 420:
case 480:
case 540:
case 600:
case 1200:
case 1800:
case 2400:
{
$call_result_filter = " AND `DialCallStatus`!='no-answer' AND `CallDuration` > ".$call_result;
break;
}
case "all":
{
$call_result_filter = "";
break;
}
}
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$access_range = $this->getUserAccessRange($_SESSION['user_id']);
if($access_range!=false)
{
if($access_range[1]==1){
if(($start_date)<strtotime($access_range[0]))
{
$start_date = strtotime($access_range[0]);
}
}else{
if(($end_date)>strtotime($access_range[0]))
{
$end_date = strtotime($access_range[0]);
}
}
}
}
}
$filter_user_add = "";
if($filter_user!="" || $filter_user!=0){
$filter_user_add = " AND UserSource = ".$filter_user;
}
$agent_filter_add = "";
if (!empty($agent)) {
$agent_details = $this->customExecute("SELECT * FROM users WHERE username = ? OR full_name = ? LIMIT 1");
$agent_details->execute(array($agent, $agent));
$agent_details = $agent_details->fetch(PDO::FETCH_ASSOC);
if (!empty($agent_details)) {
$filter_user_add = " AND UserSource = ".$agent_details['idx'];
}
}
$extra_ad = "";
if (empty($_GET['agent']))
$extra_ad = " AND MadeUsing != 'autodialer' ";
$result = $this->db->query("SELECT * FROM outbound_calls WHERE `CallFrom` IN ($number_filter) AND `DateCreated` BETWEEN '".date("Y-m-d H:i:s",$start_date)."' AND '".date("Y-m-d H:i:s",$end_date)."'".$extra_ad.$call_result_filter." ".$phone_code_add.$filter_user_add);
$total_duration = 0;
$count = 0;
while ($call = $result->fetch())
{
$total_duration = $total_duration + (int)$call['CallDuration'];
$count++;
}
$result = $this->db->query("SELECT * FROM outbound_calls WHERE `CallFrom` IN ($number_filter) AND `DateCreated` BETWEEN '".date("Y-m-d H:i:s",$start_date)."' AND '".date("Y-m-d H:i:s",$end_date)."'".$extra_ad.$call_result_filter." ".$phone_code_add.$filter_user_add." ORDER BY DATE(DateCreated) DESC ".$pagination->getLimitSql());
//die("SELECT * FROM calls WHERE `CallTo` IN ($number_filter) AND `DateCreated` BETWEEN '".date("Y-m-d H:i:s",$start_date)."' AND '".date("Y-m-d H:i:s",$end_date)."'".$call_result_filter." ".$phone_code_add." ".$pagination->getLimitSql());
//return "SELECT * FROM calls WHERE `CallTo` IN ($number_filter) AND `DateCreated` BETWEEN '".date("Y-m-d H:i:s",($start_date/1000))."' AND '".date("Y-m-d H:i:s",($end_date/1000))."'".$call_result_filter." ".$pagination->getLimitSql();
if($result === false)
$data_arr = null;
else
$data_arr = $result->fetchAll();
return array($data_arr,$count,$total_duration);
}catch(Exception $ex)
{
return array(false, $ex);
}
}
/**
* @param $company_id
* @param $user_id
* @return bool|mixed
*/
function isUserInCompany($company_id, $user_id)
{
$company = $this->db->escape($company_id);
$user = $this->db->escape($user_id);
$result = $this->db->query("SELECT * FROM user_company WHERE user_id='$user' AND company_id='$company'");
$data = $result->fetch();
if($data)
return$data;
else
return false;
}
/**
* @param $number
* @return bool
*/
function isNumberFree($number)
{
$number = $this->db->escape($number);
$result = $this->db->query("SELECT * FROM company_num WHERE number='$number'");
$count = count($result->fetchAll());
if($count!=0)
{
return false;
}else{
return true;
}
}
/**
* @param $user
* @return bool
*/
function isUserAdmin($user)
{
if(isset($_SESSION['permission'])){
return $_SESSION['permission'] >= 1 ? true : false;
}else {
$user = $this->db->escape( $user );
$result = $this->db->query( "SELECT `access_lvl` FROM users WHERE `idx`='$user'" );
$result = $result->fetch();
return $result['access_lvl'] >= 1 ? true : false;
}
}
function setUserEmail($user_id,$emails)
{
$stmt = $this->db->prepare("UPDATE users SET email=? WHERE idx=?");
if(count($emails)>0)
{
$stmt->execute(array($emails[0],$user_id));
if (count($emails) > 1) {
unset($emails[0]);
$stmt = $this->db->prepare("UPDATE users SET extra_notification_emails=? WHERE idx=?");
$stmt->execute(array(implode(",", $emails), $user_id));
}
else {
$stmt = $this->db->prepare("UPDATE users SET extra_notification_emails=? WHERE idx=?");
$stmt->execute(array("",$user_id));
}
}else{
$stmt->execute(array(null,$user_id));
$stmt = $this->db->prepare("UPDATE users SET extra_notification_emails=? WHERE idx=?");
$stmt->execute(array("",$user_id));
}
}
function getUserEmail($user_id)
{
$stmt = $this->db->prepare("SELECT email FROM users WHERE idx=?");
$stmt->execute(array($user_id));
$res = $stmt->fetch(PDO::FETCH_OBJ);
if($res->email)
return $res->email;
else
return false;
}
function getUserExtraNotificationEmails($user_id)
{
$stmt = $this->db->prepare("SELECT extra_notification_emails FROM users WHERE idx=?");
$stmt->execute(array($user_id));
$res = $stmt->fetch(PDO::FETCH_OBJ);
if($res->extra_notification_emails)
return $res->extra_notification_emails;
else
return false;
}
function setUserNotificationSetting($user_id,$notification_id)
{
$stmt = $this->db->prepare("UPDATE users SET notification_type=? WHERE idx=?");
$stmt->execute(array($notification_id,$user_id));
}
function getUserNotificationSetting($user_id)
{
$stmt = $this->db->prepare("SELECT notification_type FROM users WHERE idx=?");
$stmt->execute(array($user_id));
$row = $stmt->fetch(PDO::FETCH_OBJ);
return $row->notification_type;
}
/**
* @param $company_id
* @param $number
* @return bool
*/
function addNumberToCompany($company_id,$number,$intl)
{
$company_id = $this->db->escape($company_id);
$number = $this->db->escape($number);
$number = str_replace(array('(', ' ', ')', '-'), '', $number);
$result = $this->db->prepare("INSERT INTO company_num(`company_id`, `number`, `international`) VALUES (?,?,?)");
if($result->execute(array($company_id,$number,$intl))) {
return true;
}
else {
return false;
}
}
/**
* @param $company_id
* @param $number
* @return bool
*/
function deleteNumberFromCompany($company_id,$number)
{
$company_id = $this->db->escape($company_id);
$number = $this->db->escape($number);
$result = $this->db->prepare("DELETE FROM company_num WHERE number=? AND company_id=?");
if($result->execute(array($number,$company_id)))
return true;
else
return false;
}
/**
* @param $number
* @return bool
*/
function deleteNumber($number)
{
$number = $this->db->escape($number);
$result = $this->db->prepare("DELETE FROM company_num WHERE number=?");
if($result->execute(array($number)))
return true;
else
return false;
}
/**
* @param $pool_id
* @return bool
*/
function deletePool($pool_id)
{
$number = $this->db->escape($number);
$result = $this->db->prepare("DELETE FROM pools WHERE id=?");
if($result->execute(array($pool_id)))
return true;
else
return false;
}
/**
* @param $company_id
* @param $user_id
* @return bool
*/
function addUserToCompany($company_id,$user_id)
{
$company_id = $this->db->escape($company_id);
$user_id = $this->db->escape($user_id);
$result = $this->db->prepare("INSERT INTO user_company VALUES (?,?)");
if($result->execute(array($user_id,$company_id)))
return true;
else
return false;
}
/**
* @param $company_id
* @param $user_id
* @return bool
*/
function deleteUserFromCompany($company_id,$user_id)
{
$company_id = $this->db->escape($company_id);
$user_id = $this->db->escape($user_id);
$result = $this->db->prepare("DELETE FROM user_company WHERE user_id=? AND company_id=?");
if($result->execute(array($user_id,$company_id)))
return true;
else
return false;
}
/**
* @param $company_id
* @return mixed
*/
function getCompanyName($company_id)
{
$company_id = $this->db->escape($company_id);
$result = $this->db->query("SELECT company_name FROM companies WHERE idx='$company_id'");
$data = $result->fetch();
return $this->db->escape($data['company_name']);
}
/**
* @param $name
* @return bool
*/
function addCompany($name)
{
$stmt = $this->db->prepare( "SELECT company_name FROM companies WHERE company_name=?" );
$stmt->execute( array( addslashes( $name ) ) );
$count = count( $stmt->fetchAll() );
if($count==0 || $count==""){
$result = $this->db->prepare("INSERT INTO companies (company_name) VALUES (?)");
if($result->execute(array(addslashes($name))))
return true;
else {
return false;
}
}else{
return false;
}
}
function addBlacklist($name)
{
$name = $this->db->escape($name);
$sth = $this->db->prepare("SELECT `name` FROM blacklists WHERE `name`= ?");
$sth->execute(array($name));
$resultName = $sth->fetchAll();
if($sth->rowCount()==0){
$result = $this->db->prepare("INSERT INTO blacklists (`name`) VALUES (?)");
if($result->execute(array($name)))
return true;
else
return false;
}else{
return false;
}
}
function deleteBlacklist($idx)
{
$result = $this->db->prepare("DELETE FROM blacklists WHERE `idx`=?");
$result2 = $this->db->prepare("UPDATE companies SET `blacklist_id`=0 WHERE `blacklist_id`=?");
if($result->execute(array($idx)) && $result2->execute(array($idx)))
return true;
else
return false;
}
/**
* @param $call_sid
* @param $contents
* @param $user
* @return array
*/
function addNote($call_sid,$contents,$user)
{
$user = $this->getUserName($user);
$result = $this->db->prepare("INSERT INTO call_notes (CallSid,NoteContents,User) VALUES (?,?,?);");
if($result->execute(array($call_sid,$contents,$user)))
{
$tmp = $this->db->query("SELECT idx, DateAdded FROM call_notes WHERE idx=LAST_INSERT_ID()");
$tmp = $tmp->fetch();
return array(true,$tmp['idx'],$tmp['DateAdded'],$user);
}
else
return array(false,print_r($result->errorInfo(),true));
}
/**
* @param $call_sid
* @param $note_id
* @param $user
* @param bool $is_admin
* @return array
*/
function deleteNote($call_sid,$note_id,$user,$is_admin=false)
{
if(!$is_admin)
{
if($this->isUserInCompany($this->getCompanyofCall($call_sid),$user))
{
$deleteProc = $this->db->prepare("DELETE FROM call_notes WHERE idx=? AND CallSid=?");
if($deleteProc->execute(array($note_id,$call_sid)))
return array(true);
else
return array(false, 1);
}else
{
return array(false,2);
}
}else{
$deleteProc = $this->db->prepare("DELETE FROM call_notes WHERE idx=? AND CallSid=?");
if($deleteProc->execute(array($note_id,$call_sid)))
return array(true);
else
return array(false, 1);
}
}
/**
* @param $CallSid
* @return mixed
*/
function getCompanyofCall($CallSid)
{
$result = $this->getCallDetails($CallSid);
$phone = $this->format_phone_db($result['CallTo']);
$companyqw = $this->db->query("SELECT company_id FROM company_num WHERE number='$phone'");
$data = $companyqw->fetchAll();
if(count($data)==0){
$query = $this->db->query("SELECT company_id FROM company_num WHERE number='".str_replace("+","",$result['CallTo'])."'");
$result = $query->fetch();
}else {
$result = $data[0];
}
return $result['company_id'];
}
function getCompanyofOutgoingCall($CallSid)
{
$result = $this->getOutgoingCallDetails($CallSid);
$phone = $this->format_phone_db($result['CallFrom']);
$companyqw = $this->db->query("SELECT company_id FROM company_num WHERE number='$phone'");
$data = $companyqw->fetchAll();
if(count($data)==0){
$query = $this->db->query("SELECT company_id FROM company_num WHERE number='".str_replace("+","",$result['CallFrom'])."'");
$result = $query->fetch();
}else {
$result = $data[0];
}
return $result['company_id'];
}
/**
* @param $company_id
* @return bool
*/
function deleteCompany($company_id)
{
$company_id = $this->db->escape($company_id);
$_delete_users = $this->db->prepare("DELETE FROM user_company WHERE company_id=?");
$_delete_numbers = $this->db->prepare("DELETE FROM company_num WHERE company_id=?");
$_delete_company = $this->db->prepare("DELETE FROM companies WHERE idx=?");
$_delete_cf_mn = $this->db->prepare("DELETE FROM cf_multiple_numbers WHERE company_id = ?");
$_delete_cf_rr = $this->db->prepare("DELETE FROM cf_round_robin WHERE company_id = ?");
$_set_null_client = $this->db->prepare("UPDATE clients SET company_id = null, outgoing_numbers = null WHERE company_id = ?");
$_delete_cpc = $this->db->prepare("DELETE FROM company_phone_code WHERE company_id = ?");
if( $_delete_users->execute(array($company_id)) &&
$_delete_numbers->execute(array($company_id)) &&
$_delete_company->execute(array($company_id)) &&
$_delete_cf_mn->execute(array($company_id)) &&
$_delete_cf_rr->execute(array($company_id)) &&
$_set_null_client->execute(array($company_id)) &&
$_delete_cpc->execute(array($company_id)) )
{
return true;
}else{
return false;
}
}
/**
* @depreciated
* @param $number
* @return array
*/
function getCallsToday($number)
{
$number = $this->db->escape("+1".$number);
$date = new DateTime("Midnight");
$ringto_numbers = "";
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$access_range = $this->getUserAccessRange($_SESSION['user_id']);
if($access_range!=false)
{
if($access_range[1]==1){
if($date->format("U") < strtotime($access_range))
$date = new DateTime($access_range);
}else{
if($date->format("U") > strtotime($access_range))
$date = new DateTime($access_range);
}
}
$filter_ringto_numbers = $this->getUserOutgoingAccessNumbers($_SESSION['user_id']);
if(count($filter_ringto_numbers)>0)
{
foreach($filter_ringto_numbers as $ringto_num)
{
$ringto_numbers .= "'".$ringto_num->number."', ";
}
$ringto_numbers = substr($ringto_numbers,0,-2);
$ringto_numbers = " AND DialCallTo IN (".$ringto_numbers.")";
}
}
}
$hours = array();
for($i = 0; $i <= 23; $i++)
{
$hours[] = 'null';
}
$calls = $this->db->query("SELECT DateCreated FROM calls WHERE CallTo='$number'".$ringto_numbers." AND `DateCreated` BETWEEN FROM_UNIXTIME(".$date->format('U').") AND NOW()");
foreach ($calls as $call)
{
$time_of_call = new DateTime($call['DateCreated']);
$hour = ($time_of_call->format('j')-1);
if($hours[$hour] == 'null') { $hours[$hour] = 1; }else{
$hours[$hour]++;
}
}
return $hours;
}
// function getCallsforNumber($number,$intl)
// {
// if(!$intl){
// $number = "+1".$number;
// }
//
// $result = $this->db->prepare("SELECT * FROM calls WHERE CallTo=?");
//
// if($result->execute(array($number)))
// {
// return $result->fetchAll(PDO::FETCH_OBJ);
// }else{
// return false;
// }
// }
/**
* @depreciated
* @param $number
* @return array
*/
function getCallsYesterday($number, $outgoing = false)
{
$number = $this->db->escape("+1".$number);
$date = new DateTime("Midnight -1 day");//yesterday 12AM
$ringto_numbers = "";
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$access_range = $this->getUserAccessRange($_SESSION['user_id']);
if($access_range!=false)
{
if($access_range[1]==1){
if($date->format("U") < strtotime($access_range))
$date = new DateTime($access_range);
}else{
if($date->format("U") > strtotime($access_range))
$date = new DateTime($access_range);
}
}
$filter_ringto_numbers = $this->getUserOutgoingAccessNumbers($_SESSION['user_id']);
if(count($filter_ringto_numbers)>0)
{
foreach($filter_ringto_numbers as $ringto_num)
{
$ringto_numbers .= "'".$ringto_num->number."', ";
}
$ringto_numbers = substr($ringto_numbers,0,-2);
$ringto_numbers = " AND DialCallTo IN (".$ringto_numbers.")";
}
}
}
$extra_ad = "";
if($outgoing==false){
$table = "calls";
$target_field = "CallTo";
}else{
$table = "outbound_calls";
$target_field = "CallFrom";
if (empty($_GET['agent']))
$extra_ad = " AND MadeUsing != 'autodialer' ";
}
$date_end = new DateTime_52("Midnight");
$date_end->setTimestamp($date_end->format('U')-3600);
$hours = array();
for($i = 0; $i <= 23; $i++)
{
$hours[] = 'null';
}
$calls = $this->db->query("SELECT DateCreated FROM $table WHERE $target_field='$number'".$extra_ad.$ringto_numbers." AND `DateCreated` BETWEEN FROM_UNIXTIME(".$date->format('U').") AND FROM_UNIXTIME(".$date_end->format('U').")");
foreach ($calls as $call)
{
$time_of_call = new DateTime($call['DateCreated']);
$hour = ($time_of_call->format('j')-1);
if($hours[$hour] == 'null') { $hours[$hour] = 1; }else{
$hours[$hour]++;
}
}
return $hours;
}
function getCallsInRange($company_id, $start_date, $end_date, $phone_code = 0, $call_result = 'all', $distinct=false, $outgoing_filter = "", $outgoing = false, $user = "", $campaign = "", $agent = "")
{
require_once('config.php');
global $TIMEZONE;
$company_id = $this->db->escape($company_id);
$number_filter = "";
//Get Numbers of the Company
if($company_id==-1)
{
$resultCompany = $this->db->query("SELECT number,international FROM company_num;");
$numbers = $resultCompany->fetchAll();
foreach($numbers as $number)
{
$disabled = false;
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$disabled_numbers = $this->getUserAccessNumbers($_SESSION['user_id']);
$number_array = array();
foreach($disabled_numbers as $disabled_number)
{
$number_array[] = $disabled_number->number;
}
if(count($number_array)>0)
{
foreach($number_array as $d_number)
{
if($number['international']==0)
$number_ = "+1".$number['number'];
else
$number_ = $number['number'];
if($number_===$d_number)
$disabled = true;
}
}
}
}
if($disabled)
continue;
if($number['international']==0)
$number_filter .= "'+1".$number['number']."', ";
else
$number_filter .= "'+".$number['number']."', ";
}
$number_filter = substr($number_filter, 0, -2);
}else{
$resultCompany = $this->db->query("SELECT number,international FROM company_num WHERE company_id='$company_id'");
$numbers = $resultCompany->fetchAll();
foreach($numbers as $number)
{
$disabled = false;
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$disabled_numbers = $this->getUserAccessNumbers($_SESSION['user_id']);
$number_array = array();
foreach($disabled_numbers as $disabled_number)
{
$number_array[] = $disabled_number->number;
}
if(count($number_array)>0)
{
foreach($number_array as $d_number)
{
if($number['international']==0)
$number_ = "+1".$number['number'];
else
$number_ = $number['number'];
if($number_===$d_number)
$disabled = true;
}
}
}
}
if($disabled)
continue;
if($number['international']==0)
$number_filter .= "'+1".$number['number']."', ";
else
$number_filter .= "'+".$number['number']."', ";
}
$number_filter = substr($number_filter, 0, -2);
}
$phone_code_add = "";
if($phone_code!=0)
{
$phone_code_add = "AND `PhoneCode`='".$this->db->escape($phone_code)."'";
}
$extra_ad = "";
if($outgoing==false){
$table = "calls";
$target_field = "CallTo";
$distinct_field = "CallFrom";
$duration_field = "DialCallDuration";
}else{
$table = "outbound_calls";
$target_field = "CallFrom";
$distinct_field = "CallTo";
$duration_field = "CallDuration";
if (empty($_GET['agent']))
$extra_ad = " AND MadeUsing != 'autodialer' ";
}
$outgoing_filter_add = "";
if($outgoing_filter!="" && $outgoing==false)
{
$outgoing_filter_add = " AND (DialCallTo LIKE '%".$outgoing_filter."' OR CallTo LIKE '%".$outgoing_filter."') ";
}
//Generate Some filters
$call_result_filter = "";
switch($call_result)
{
case "answered":
{
$call_result_filter = " AND `DialCallStatus`='completed'";
break;
}
case "missed":
{
$call_result_filter = " AND `DialCallStatus`='no-answer'";
break;
}
case "busy":
{
$call_result_filter = " AND `DialCallStatus`='busy'";
break;
}
case "error":
{
$call_result_filter = " AND `DialCallStatus`='failed'";
break;
}
case "voicemail":
{
$call_result_filter = " AND `DialCallStatus`='voicemail'";
break;
}
case 30:
case 45:
case 60:
case 90:
case 120:
case 180:
case 240:
case 300:
case 360:
case 420:
case 480:
case 540:
case 600:
case 1200:
case 1800:
case 2400:
{
$call_result_filter = " AND `DialCallStatus`!='no-answer' AND `$duration_field` > ".$call_result;
break;
}
case "all":
{
$call_result_filter = "";
break;
}
}
$ringto_numbers = "";
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$access_range = $this->getUserAccessRange($_SESSION['user_id']);
if($access_range!=false)
{
if($access_range[1]==1){
if(($start_date)<strtotime($access_range[0]))
{
$start_date = strtotime($access_range[0]);
}
}else{
if(($end_date)>strtotime($access_range[0]))
{
$end_date = strtotime($access_range[0]);
}
}
}
$filter_ringto_numbers = $this->getUserOutgoingAccessNumbers($_SESSION['user_id']);
if(count($filter_ringto_numbers)>0 && $outgoing==false)
{
foreach($filter_ringto_numbers as $ringto_num)
{
$ringto_numbers .= "'".$ringto_num->number."', ";
}
$ringto_numbers = substr($ringto_numbers,0,-2);
$ringto_numbers = " AND DialCallTo IN (".$ringto_numbers.")";
}
}
}
if (trim($number_filter) == "") {
$number_filter = "'none'";
}
$user_add = "";
if($user!="")
$user_add = " AND UserSource = ".$user;
$agent_filter_add = "";
if (!empty($agent) && !$outgoing) {
$agent_details = $this->customExecute("SELECT * FROM users WHERE username = ? OR full_name = ? LIMIT 1");
$agent_details->execute(array($agent, $agent));
$agent_details = $agent_details->fetch(PDO::FETCH_ASSOC);
if (!empty($agent_details)) {
$name = trim($agent_details['full_name']);
if (empty($name)) $name = trim($agent_details['username']);
else $name .= " (".$agent_details['username'].")";
$agent_filter_add = " AND participants LIKE '[\"".$name."%' ";
}
}
elseif (!empty($agent) && $outgoing) {
$agent_details = $this->customExecute("SELECT * FROM users WHERE username = ? OR full_name = ? LIMIT 1");
$agent_details->execute(array($agent, $agent));
$agent_details = $agent_details->fetch(PDO::FETCH_ASSOC);
if (!empty($agent_details)) {
$user_add = " AND UserSource = ".$agent_details['idx'];
}
}
if (empty($number_filter))
$calls = array();
else {
if(!$distinct) {
$calls = $this->db->query("SELECT * FROM $table WHERE `$target_field` IN ($number_filter)".$extra_ad.$ringto_numbers.$outgoing_filter_add.$agent_filter_add." AND DateCreated BETWEEN '".date("Y-m-d H:i:s",$start_date)."' AND '".date("Y-m-d H:i:s",$end_date)."'".$call_result_filter." ".$phone_code_add.$user_add);
}
else
$calls = $this->db->query("SELECT DISTINCT `$distinct_field` FROM $table WHERE `$target_field` IN ($number_filter)".$extra_ad.$ringto_numbers.$outgoing_filter_add.$agent_filter_add." AND DateCreated BETWEEN '".date("Y-m-d H:i:s",$start_date)."' AND '".date("Y-m-d H:i:s",$end_date)."'".$call_result_filter." ".$phone_code_add.$user_add);
$calls = $calls->fetchAll(PDO::FETCH_ASSOC);
}
$twilio_numbers = Util::get_all_twilio_numbers();
$_calls = array();
foreach($calls as $call)
{
$new_row = $call;
if($call['CallTo']!="")
{
if (array_key_exists(format_phone($call['CallTo']), $twilio_numbers))
{
if ($outgoing)
$this_campaign=(string)$twilio_numbers[format_phone($call['CallFrom'])];
else
$this_campaign=(string)$twilio_numbers[format_phone($call['CallTo'])];
}
else
$this_campaign="";
$new_row["Campaign"] = $this_campaign;
}
if (empty($campaign) || $campaign === "false" || (!empty($campaign) && $campaign == $this_campaign))
$_calls[] = $new_row;
}
return $_calls;
}
function getCallsInRangeCount($company_id, $start_date, $end_date, $phone_code = 0, $call_result = 'all', $distinct=false, $outgoing_filter = "", $outgoing = false, $user = "", $campaign = "", $agent = "")
{
require_once('config.php');
global $TIMEZONE;
$company_id = $this->db->escape($company_id);
$number_filter = "";
//Get Numbers of the Company
if($company_id==-1)
{
$resultCompany = $this->db->query("SELECT number,international FROM company_num;");
$numbers = $resultCompany->fetchAll();
foreach($numbers as $number)
{
$disabled = false;
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$disabled_numbers = $this->getUserAccessNumbers($_SESSION['user_id']);
$number_array = array();
foreach($disabled_numbers as $disabled_number)
{
$number_array[] = $disabled_number->number;
}
if(count($number_array)>0)
{
foreach($number_array as $d_number)
{
if($number['international']==0)
$number_ = "+1".$number['number'];
else
$number_ = $number['number'];
if($number_===$d_number)
$disabled = true;
}
}
}
}
if($disabled)
continue;
if($number['international']==0)
$number_filter .= "'+1".$number['number']."', ";
else
$number_filter .= "'+".$number['number']."', ";
}
$number_filter = substr($number_filter, 0, -2);
}else{
$resultCompany = $this->db->query("SELECT number,international FROM company_num WHERE company_id='$company_id'");
$numbers = $resultCompany->fetchAll();
foreach($numbers as $number)
{
$disabled = false;
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$disabled_numbers = $this->getUserAccessNumbers($_SESSION['user_id']);
$number_array = array();
foreach($disabled_numbers as $disabled_number)
{
$number_array[] = $disabled_number->number;
}
if(count($number_array)>0)
{
foreach($number_array as $d_number)
{
if($number['international']==0)
$number_ = "+1".$number['number'];
else
$number_ = $number['number'];
if($number_===$d_number)
$disabled = true;
}
}
}
}
if($disabled)
continue;
if($number['international']==0)
$number_filter .= "'+1".$number['number']."', ";
else
$number_filter .= "'+".$number['number']."', ";
}
$number_filter = substr($number_filter, 0, -2);
}
$phone_code_add = "";
if($phone_code!=0)
{
$phone_code_add = "AND `PhoneCode`='".$this->db->escape($phone_code)."'";
}
$extra_ad = "";
if($outgoing==false){
$table = "calls";
$target_field = "CallTo";
$distinct_field = "CallFrom";
$duration_field = "DialCallDuration";
//$extra_voicemail = " DialCallStatus != 'voicemail' AND ";
}else{
$table = "outbound_calls";
$target_field = "CallFrom";
$distinct_field = "CallTo";
$duration_field = "CallDuration";
if (empty($_GET['agent']))
$extra_ad = " AND MadeUsing != 'autodialer' ";
}
$outgoing_filter_add = "";
if($outgoing_filter!="" && $outgoing==false)
{
$outgoing_filter_add = " AND (DialCallTo LIKE '%".$outgoing_filter."' OR CallTo LIKE '%".$outgoing_filter."') ";
}
//Generate Some filters
$call_result_filter = "";
switch($call_result)
{
case "answered":
{
$call_result_filter = " AND `DialCallStatus`='completed'";
break;
}
case "missed":
{
$call_result_filter = " AND `DialCallStatus`='no-answer'";
break;
}
case "busy":
{
$call_result_filter = " AND `DialCallStatus`='busy'";
break;
}
case "error":
{
$call_result_filter = " AND `DialCallStatus`='failed'";
break;
}
case "voicemail":
{
$call_result_filter = " AND `DialCallStatus`='voicemail'";
break;
}
case 30:
case 45:
case 60:
case 90:
case 120:
case 180:
case 240:
case 300:
case 360:
case 420:
case 480:
case 540:
case 600:
case 1200:
case 1800:
case 2400:
{
$call_result_filter = " AND `DialCallStatus`!='no-answer' AND `$duration_field` > ".$call_result;
break;
}
case "all":
{
$call_result_filter = "";
break;
}
}
$ringto_numbers = "";
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$access_range = $this->getUserAccessRange($_SESSION['user_id']);
if($access_range!=false)
{
if($access_range[1]==1){
if(($start_date)<strtotime($access_range[0]))
{
$start_date = strtotime($access_range[0]);
}
}else{
if(($end_date)>strtotime($access_range[0]))
{
$end_date = strtotime($access_range[0]);
}
}
}
$filter_ringto_numbers = $this->getUserOutgoingAccessNumbers($_SESSION['user_id']);
if(count($filter_ringto_numbers)>0 && $outgoing==false)
{
foreach($filter_ringto_numbers as $ringto_num)
{
$ringto_numbers .= "'".$ringto_num->number."', ";
}
$ringto_numbers = substr($ringto_numbers,0,-2);
$ringto_numbers = " AND DialCallTo IN (".$ringto_numbers.")";
}
}
}
$user_add = "";
if($user!="")
$user_add = " AND UserSource = ".$user;
$agent_filter_add = "";
if (!empty($agent) && !$outgoing) {
$agent_details = $this->customExecute("SELECT * FROM users WHERE username = ? OR full_name = ? LIMIT 1");
$agent_details->execute(array($agent, $agent));
$agent_details = $agent_details->fetch(PDO::FETCH_ASSOC);
if (!empty($agent_details)) {
$name = trim($agent_details['full_name']);
if (empty($name)) $name = trim($agent_details['username']);
else $name .= " (".$agent_details['username'].")";
$agent_filter_add = " AND participants LIKE '[\"".$name."%' ";
}
}
elseif (!empty($agent) && $outgoing) {
$agent_details = $this->customExecute("SELECT * FROM users WHERE username = ? OR full_name = ? LIMIT 1");
$agent_details->execute(array($agent, $agent));
$agent_details = $agent_details->fetch(PDO::FETCH_ASSOC);
if (!empty($agent_details)) {
$user_add = " AND UserSource = ".$agent_details['idx'];
}
}
if (empty($number_filter))
$calls = array();
else {
if(!$distinct)
$query = "SELECT CallTo FROM $table WHERE `$target_field` IN ($number_filter)".$extra_ad.$ringto_numbers.$outgoing_filter_add.$agent_filter_add." AND DateCreated BETWEEN '".date("Y-m-d H:i:s",$start_date)."' AND '".date("Y-m-d H:i:s",$end_date)."'".$call_result_filter." ".$phone_code_add.$user_add;
else
$query = "SELECT DISTINCT (`$distinct_field`), CallTo FROM $table WHERE `$target_field` IN ($number_filter)".$extra_ad.$ringto_numbers.$outgoing_filter_add.$agent_filter_add." AND DateCreated BETWEEN '".date("Y-m-d H:i:s",$start_date)."' AND '".date("Y-m-d H:i:s",$end_date)."'".$call_result_filter." ".$phone_code_add.$user_add;
$calls_result = $this->db->query($query);
}
$total_calls = 0;
$twilio_numbers = Util::get_all_twilio_numbers();
if (empty($campaign) || $campaign == "false") {
if (@is_object($calls_result))
$total_calls = $calls_result->rowCount();
else
$total_calls = 0;
}
else {
while ($call = $calls_result->fetch()) {
$callTo = format_phone($call["CallTo"]);
if (array_key_exists($callTo, $twilio_numbers))
{
$this_campaign=(string)$twilio_numbers[$callTo];
}
else {
$this_campaign="";
}
if ($this_campaign == $campaign) {
$total_calls++;
}
}
}
return $total_calls;
}
function getCallsInRangeForNum($twilio_number, $start_date, $end_date, $outgoing = false)
{
$distinct=false;
require_once('config.php');
global $TIMEZONE;
$ringto_numbers = "";
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$access_range = $this->getUserAccessRange($_SESSION['user_id']);
if($access_range!=false)
{
if($access_range[1]==1){
if(($start_date)<strtotime($access_range[0]))
{
$start_date = strtotime($access_range[0]);
}
}else{
if(($end_date)>strtotime($access_range[0]))
{
$end_date = strtotime($access_range[0]);
}
}
}
$filter_ringto_numbers = $this->getUserOutgoingAccessNumbers($_SESSION['user_id']);
if(count($filter_ringto_numbers)>0 && $outgoing==false)
{
foreach($filter_ringto_numbers as $ringto_num)
{
$ringto_numbers .= "'".$ringto_num->number."', ";
}
$ringto_numbers = substr($ringto_numbers,0,-2);
$ringto_numbers = " AND DialCallTo IN (".$ringto_numbers.")";
}
}
}
$extra_ad = "";
if($outgoing==false){
$table = "calls";
$target_field = "CallTo";
$distinct_field = "CallFrom";
//$extra_voicemail = " DialCallStatus != 'voicemail' AND ";
}else{
$table = "outbound_calls";
$target_field = "CallFrom";
$distinct_field = "CallTo";
$extra_voicemail = "";
if (empty($_GET['agent']))
$extra_ad = " AND MadeUsing != 'autodialer' ";
}
if(!$distinct)
$calls = $this->db->query("SELECT * FROM $table WHERE `$target_field` IN ('$twilio_number')".$extra_ad.$ringto_numbers." AND DateCreated BETWEEN '".date("Y-m-d H:i:s",$start_date)."' AND '".date("Y-m-d H:i:s",$end_date)."'");
else
$calls = $this->db->query("SELECT DISTINCT `$distinct_field` FROM $table WHERE `$target_field` IN ('$twilio_number')".$extra_ad.$ringto_numbers." AND DateCreated BETWEEN '".date("Y-m-d H:i:s",$start_date)."' AND '".date("Y-m-d H:i:s",$end_date)."'");
$twilio_numbers = Util::get_all_twilio_numbers();
$_calls = array();
$calls = $calls->fetchAll(PDO::FETCH_ASSOC);
foreach($calls as $call)
{
$new_row = $call;
if($call['CallTo']!="")
{
if (array_key_exists(format_phone($call['CallTo']), $twilio_numbers))
{
$campaign=(string)$twilio_numbers[format_phone($call['CallTo'])];
}
else
$campaign="";
$new_row["Campaign"] = $campaign;
}
$_calls[] = $new_row;
}
return $_calls;
}
/**
* @param $number
* @return array
*/
function getCallsThisYear($number,$intl = false, $outgoing = false)
{
if(!$intl)
$number = $this->db->escape("+1".$number);
else
$number = "+".$number;
$month_stats = array("Jan"=>array(1,0),"Feb"=>array(2,0),
"Mar"=>array(3,0),"Apr"=>array(4,0),
"May"=>array(5,0),"Jun"=>array(6,0),
"Jul"=>array(7,0),"Aug"=>array(8,0),
"Sep"=>array(9,0),"Oct"=>array(10,0),
"Nov"=>array(11,0),"Dec"=>array(12,0));
$date_access_range = "";
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$access_range = $this->getUserAccessRange($_SESSION['user_id']);
if($access_range!=false)
{
if($access_range[1]==1)
$when = ">";
elseif($access_range[1]==2)
$when = "<";
else
$when = ">";
$date_access_range = " AND DateCreated ".$when." '".$access_range[0]."'";
}
$filter_ringto_numbers = $this->getUserOutgoingAccessNumbers($_SESSION['user_id']);
if(count($filter_ringto_numbers)>0)
{
$ringto_numbers = "";
foreach($filter_ringto_numbers as $ringto_num)
{
$ringto_numbers .= "'".$ringto_num->number."', ";
}
$ringto_numbers = substr($ringto_numbers,0,-2);
$ringto_numbers = " AND DialCallTo IN (".$ringto_numbers.")";
$date_access_range = $ringto_numbers.$date_access_range;
}
}
}
$extra_ad = "";
if($outgoing==false){
$table = "calls";
$target_field = "CallTo";
}else{
$table = "outbound_calls";
$target_field = "CallFrom";
if (empty($_GET['agent']))
$extra_ad = " AND MadeUsing != 'autodialer' ";
}
$calls = $this->db->query("SELECT DateCreated FROM $table WHERE $target_field='$number'".$extra_ad.$date_access_range);
foreach($calls as $call)
{
$date = date("Y-n",strtotime($call['DateCreated']));
$this_year = date("Y",strtotime("now"));
switch($date)
{
case $this_year."-1":
$month_stats["Jan"][1]++;
break;
case $this_year."-2":
$month_stats["Feb"][1]++;
break;
case $this_year."-3":
$month_stats["Mar"][1]++;
break;
case $this_year."-4":
$month_stats["Apr"][1]++;
break;
case $this_year."-5":
$month_stats["May"][1]++;
break;
case $this_year."-6":
$month_stats["Jun"][1]++;
break;
case $this_year."-7":
$month_stats["Jul"][1]++;
break;
case $this_year."-8":
$month_stats["Aug"][1]++;
break;
case $this_year."-9":
$month_stats["Sep"][1]++;
break;
case $this_year."-10":
$month_stats["Oct"][1]++;
break;
case $this_year."-11":
$month_stats["Nov"][1]++;
break;
case $this_year."-12":
$month_stats["Dec"][1]++;
break;
}
}
return $month_stats;
}
/**
* @param $number
* @return array
*/
function getCallsLastSeven($number,$intl = false, $outgoing = false)
{
require_once('config.php');
global $TIMEZONE;
if(!$intl)
$number = $this->db->escape("+1".$number);
else
$number = "+".$number;
//$thisSpan = date('Y-m-d',strtotime('-7 days ago'));
$day_stats = array("1"=>0, "2"=>0,
"3"=>0, "4"=>0,
"5"=>0, "6"=>0,
"7"=>0, "0"=>0);
$date_access_range = "";
if(@$_SESSION['user_id']!="")
{
if(!$this->isUserAdmin($_SESSION['user_id']))
{
$access_range = $this->getUserAccessRange($_SESSION['user_id']);
if($access_range!=false)
{
if($access_range[1]==1)
$when = ">";
elseif($access_range[1]==2)
$when = "<";
else
$when = ">";
$date_access_range = " AND DateCreated ".$when." '".$access_range[0]."'";
}
$filter_ringto_numbers = $this->getUserOutgoingAccessNumbers($_SESSION['user_id']);
if(count($filter_ringto_numbers)>0)
{
$ringto_numbers = "";
if( is_array($filter_ringto_numbers) || is_object($filter_ringto_numbers) )
foreach($filter_ringto_numbers as $ringto_num)
{
$ringto_numbers .= "'".$ringto_num->number."', ";
}
$ringto_numbers = substr($ringto_numbers,0,-2);
$ringto_numbers = " AND DialCallTo IN (".$ringto_numbers.")";
$date_access_range = $ringto_numbers.$date_access_range;
}
}
}
$extra_ad = "";
if($outgoing==false){
$table = "calls";
$target_field = "CallTo";
}else{
$table = "outbound_calls";
$target_field = "CallFrom";
if (empty($_GET['agent']))
$extra_ad = " AND MadeUsing != 'autodialer' ";
}
$calls = $this->db->query("SELECT DateCreated FROM $table WHERE $target_field='$number'".$extra_ad.$date_access_range);
$calls = $calls->fetchAll();
if( is_array($calls) || is_object($calls) )
foreach($calls as $call)
{
//$comp_date = new DateTime();
$tz = new DateTimeZone($TIMEZONE);
$date = new DateTime($call['DateCreated']);
$date->setTimezone($tz);
$date = $date->format("Y-m-d");
switch($date)
{
case date("Y-m-d",strtotime('7 days ago')):
$day_stats['7'] = $day_stats['7']+1;
break;
case date("Y-m-d",strtotime('6 days ago')):
$day_stats['6'] = $day_stats['6']+1;
break;
case date("Y-m-d",strtotime('5 days ago')):
$day_stats['5'] = $day_stats['5']+1;
break;
case date("Y-m-d",strtotime('4 days ago')):
$day_stats['4'] = $day_stats['4']+1;
break;
case date("Y-m-d",strtotime('3 days ago')):
$day_stats['3'] = $day_stats['3']+1;
break;
case date("Y-m-d",strtotime('2 days ago')):
$day_stats['2'] = $day_stats['2']+1;
break;
case date("Y-m-d",strtotime('1 days ago')):
$day_stats['1'] = $day_stats['1']+1;
break;
case date("Y-m-d",strtotime('today')):
$day_stats['0'] = $day_stats['0']+1;
break;
}
}
return $day_stats;
}
function setPhoneCode($call_sid,$phonecode,$type)
{
if($type==1)
$stmt = $this->db->prepare("UPDATE calls SET `PhoneCode`=:pc WHERE `CallSid`=:sid");
else
$stmt = $this->db->prepare("UPDATE outbound_calls SET `PhoneCode`=:pc WHERE `CallSid`=:sid");
if($stmt->execute(array(":pc"=>$phonecode,":sid"=>$call_sid)))
return true;
else
return false;
}
function getPhoneCodes($company_id, $type = 1)
{
$stmt = $this->db->prepare("SELECT * FROM company_phone_code WHERE `company_id`=:c_id AND `type` = :pc_type");
$stmt->execute(array(":c_id"=>$company_id, ":pc_type"=>$type));
$result = $stmt->fetchAll(PDO::FETCH_OBJ);
if(!$result)
return false;
else
return $result;
}
function deletePhoneCode($company_id,$idx)
{
$stmt = $this->db->prepare("DELETE FROM company_phone_code WHERE `company_id`=:c_id AND `idx`=:idx");
if($stmt->execute(array(":c_id"=>$company_id,":idx"=>$idx)))
return true;
else
return false;
}
function addPhoneCode($company_id,$name,$dc, $type = 1)
{
$stmt = $this->db->prepare("INSERT INTO company_phone_code (`company_id`,`name`,`order`, `type`) VALUES (:c_id,:name,:order,:type)");
if($stmt->execute(array(":c_id"=>$company_id,":name"=>$name,":order"=>$dc, ":type"=>$type)))
return true;
else
return false;
}
function getPhoneCodeName($idx,$type = 1)
{
$stmt = $this->db->prepare("SELECT `name` FROM company_phone_code WHERE `idx`=:idx AND `type`=:type");
if($stmt->execute(array(":idx"=>$idx,":type"=>$type)))
return $stmt->fetch(PDO::FETCH_OBJ)->name;
else
return "";
}
function getForwardedNumbers()
{
$results = $this->db->query("SELECT * FROM twilio_forward_number;");
return $results->fetchAll(PDO::FETCH_OBJ);
}
function forward_num($Twilio_num){
$result = $this->db->query("SELECT * FROM twilio_forward_number WHERE twilio_number='$Twilio_num'");
$data = $result->fetchAll();
return $data;
}
function add_forward_num($twilio_num,$caller_num,$forward_num){
$result = $this->db->prepare("INSERT INTO twilio_forward_number(twilio_number,caller_number,forward_number) VALUES (?,?,?)");
if($result->execute(array($twilio_num,$caller_num,$forward_num)))
return $this->db->lastInsertId();
else
return false;
}
function delete_forward_num($id){
$id = $this->db->escape($id);
$result = $this->db->prepare("DELETE FROM twilio_forward_number WHERE id=?");
if($result->execute(array($id)))
return true;
else
return false;
}
function check_call_forward($twilio_num,$caller_num1){
$result = $this->db->query("SELECT * FROM twilio_forward_number WHERE twilio_number='$twilio_num' and caller_number like '".substr($caller_num1,0,7)."%'");
$data = $result->fetchAll();
if(count($data)>0)
return $data;
else{
$result = $this->db->query("SELECT * FROM twilio_forward_number WHERE twilio_number='$twilio_num' and caller_number like '".substr($caller_num1,0,4)."%'");
$data = $result->fetchAll();
}
return $data;
}
//System Functions
function customQuery($sql)
{
return $this->db->query($sql);
}
function lastInsertId(){
return $this->db->lastInsertId();
}
function customExecute($sql)
{
return $this->db->prepare($sql);
}
/**
* Gets the database version to verify update.
*
* @return int
*/
function getDatabaseVersion()
{
global $forversion;
smsin();
$version = $forversion;
return array($this->getVar("db_version"),$version);
}
function gaFireHit( $data = null ) {
if ( $data ) {
$getString = 'https://ssl.google-analytics.com/collect';
$getString .= '?payload_data&';
$getString .= http_build_query($data);
$result = $this->curlGetData( $getString );
return $result;
}
return false;
}
// function curlPostData($url, $data) {
// $fields = '';
// foreach($data as $key => $value) {
// $fields .= $key . '=' . urlencode($value) . '&';
// }
// rtrim($fields, '&');
//
// $post = curl_init();
//
// curl_setopt($post, CURLOPT_URL, $url);
// curl_setopt($post, CURLOPT_POST, count($data));
// curl_setopt($post, CURLOPT_POSTFIELDS, $fields);
// curl_setopt($post, CURLOPT_RETURNTRANSFER, 1);
//
// $result = curl_exec($post);
// curl_close($post);
//
// return $result;
// }
function curlGetData($url)
{
$curl = curl_init();
curl_setopt_array($curl, array(
CURLOPT_RETURNTRANSFER => 1,
CURLOPT_URL => $url,
CURLOPT_USERAGENT => 'ACT',
CURLOPT_TIMEOUT => 5
));
$resp = curl_exec($curl);
curl_close($curl);
return $resp;
}
/**
* Gets a variable from the database.
*
* @param $key
* @return mixed
*/
function getVar($key)
{
$stmt = $this->db->prepare("SELECT `value` FROM options WHERE `key` = :key");
$stmt->execute(array(":key" => $key));
$result = $stmt->fetch(PDO::FETCH_OBJ);
if(!$result){
return false;
}else{
return $result->value;
}
}
function setVar($key,$value)
{
$stmt = $this->db->prepare("REPLACE INTO options(`key`,`value`) VALUES(:key,:value);");
if($stmt->execute(array(":key"=>$key,":value"=>$value)))
return true;
else
return false;
}
function deleteVar($key){
$stmt = $this->db->prepare("DELETE FROM options WHERE `key` = ?");
if($stmt->execute(array($key)))
return true;
else
return false;
}
function startsWith($haystack, $needle)
{
$length = strlen($needle);
return (substr($haystack, 0, $length) === $needle);
}
function endsWith($haystack, $needle)
{
$length = strlen($needle);
$start = $length * -1; //negative
return (substr($haystack, $start) === $needle);
}
function getStarted($cId)
{
$res = $result = $this->db->query("SELECT * FROM call_ivr_widget WHERE companyId = $cId AND pId = '0'");
$data = $result->fetch();
if ( !empty($data) )
{
return $data['wId'];
}else{
return '';
}
}
function getWidget($wId,$keypress)
{
$kpr = ($keypress != "-" && !empty($keypress)) ? " and keypress ='$keypress' " : "";
$res = $result = $this->db->query("SELECT * FROM call_ivr_widget WHERE wId = '$wId' ".$kpr." AND temporary = 0");
$data = $result->fetch();
return $data;
/*$widget['wId'] = $rs_nxt['wId'];
$widget['pId'] = $rs_nxt['pId'];
$widget['flowtype'] = $rs_nxt['flowtype'];
$widget['content_type'] = $rs_nxt['content_type'];
$widget['content'] = $rs_nxt['content'];
$widget['nId'] = $rs_nxt['nId'];
$widget['data'] = $rs_nxt['data']
$widget['keypress'] = $rs_nxt['keypress'];*/
}
function getMenuItems($pId)
{
$result = $this->db->query("SELECT * FROM call_ivr_widget WHERE keypress != '-' and pId = $pId");
$MenuItems = $result->fetchAll();
$data = array();
foreach ( $MenuItems as $mk=>$mv) {
$data[$mv['keypress']] =$mv;
}
return $data;
}
//function for retrieving voicemail box by exten
function getMailbox($voicemail_exten) {
//make sure inputs are db safe
$voicemail_exten = $this->db->escape($voicemail_exten);
$result = $this->db->query("select * from voicemailbox where vmb_extension='$voicemail_exten'");
$data = $result->fetch();
$mailbox = false;
if ( !empty($data) )
{
$mailbox = array();
$mailbox['exten'] = $data['vmb_extension'];
$mailbox['desc'] = $data['vmb_description'];
$mailbox['passcode'] = $data['vmb_passcode'];
}
return $mailbox;
}
function addMessage($voicemail_exten, $caller_id, $recording_url, $call_sid, $recording_duration) {
$voicemail_exten = $this->db->escape($voicemail_exten);
$caller_id = $this->db->escape($caller_id);
$recording_url = $this->db->escape($recording_url);
// Performing SQL query
$query = sprintf("insert into messages (message_frn_vmb_extension,"
. "message_date,message_from,message_audio_url,message_flag,CallSid,RecordingDuration)"
. " values ('%s','%s','%s','%s',0,'%s','%s')", $voicemail_exten, date('Y-m-d H:i:s',time()), $caller_id,
$recording_url,$call_sid,$recording_duration);
$this->db->query($query);
$id =$this->db->lastInsertId();
return $id;
}
function updateMessageFlag($msg_id, $flag=0){
//make sure inputs are db safe
$msg_id = $this->db->escape($msg_id);
$flag = $this->db->escape($flag);
// Performing SQL query
$query = sprintf("update messages set message_flag=%d where message_id=%d",
$flag, $msg_id);
$this->db->query($query);
}
function getMessages($voicemail_exten,$flag=0){
//make sure inputs are db safe
$voicemail_exten = $this->db->escape($voicemail_exten);
$flag = $this->db->escape($flag);
// Performing SQL query
$query = sprintf("select * from messages where message_flag=%d and "
. "message_frn_vmb_extension='%s' order by message_date", $flag,
$voicemail_exten);
$result = $this->db->query("select * from voicemailbox where vmb_extension='$voicemail_exten'");
$data = $result->fetchAll();
$messages = array();
foreach ( $data as $mk=>$mv) {
$messages[]=$mv['message_id'];
}
return $messages;
}
function getMessage($msg_id){
//make sure inputs are db safe
$msg_id = $this->db->escape($msg_id);
// Performing SQL query
$query = sprintf("select * from messages where message_id=%d",$msg_id);
$result = $this->db->query($query);
$data = $result->fetch();
$message = array();
if(!empty($data)) {
$message['id']=$data['message_id'];
$message['date']=$data['message_date'];
$message['from']=$data['message_from'];
$message['url']=$data['message_audio_url'];
}
return $message;
}
function getNumberToDial($company_id,$open_number, $close_number)
{
require_once('config.php');
global $TIMEZONE;
$tz = new DateTimeZone($TIMEZONE);
$date = new DateTime();
$date->setTimezone($tz);
$today = strtolower( $date->format("D"));
$todayDate = $date->format("Y-m-d");
$curTime = strtotime($date->format("Y-m-d H:i"));
$result = $this->db->query("select * from call_hours where `day` = '$today' and company_id=$company_id");
$data = $result->fetch();
if ( !empty($data) )
{
$openTime = strtotime($todayDate.' '.$data['open_time']);
$closeTime = strtotime($todayDate.' '.$data['close_time']);
//echo '==curTime'.date("Y-m-d H:i", $curTime) .'==openTime'.date("Y-m-d H:i", $openTime) .'==closeTime'. date("Y-m-d H:i", $closeTime) ;
if( $data['status'] == '1') return $close_number;
if ( $curTime >= $openTime && $closeTime > $curTime )
return $open_number;
else
return $close_number;
/////////////
}else
return $open_number;
}
/*
* Description: This function get the companyId through company name
* Param : coampany name
* Returns : company ID
*/
function getCompanyId($comapnyName){
$stmt = $this->db->prepare("SELECT `idx` FROM companies WHERE `company_name` = :comapnyName");
$stmt->execute(array(":comapnyName" => $comapnyName));
$result = $stmt->fetch(PDO::FETCH_OBJ);
if(!$result){
return false;
}else{
return $result->idx;
}
}
/*
* Description : this function create a entry in pool table
* Prama : company_id and Quantity
* Returns : Id of the pool
*/
function createPool($company_id, $quantity){
$stmt = $this->db->prepare("SELECT id FROM pools WHERE `company_id` = :c_id");
$stmt->execute(array(":c_id"=>$company_id));
$result = $stmt->fetch();
if ($result['id']) {
return $result['id'];
}
else {
$stmt = $this->db->prepare("INSERT INTO pools (`company_id`,`quantity`) VALUES (:c_id,:quantity)");
if($stmt->execute(array(":c_id"=>$company_id,":quantity"=>$quantity))){
$pool_id = $this->db->lastInsertId();
return $pool_id;
}else{
return false;
}
}
}
/*
* Description : This function create a entry pof new buy number through pool
* Prama : array company_id, number, international, pool_id, keyword
* Returns : boolean
*/
function poolNumberInsert($data){
$number = (string)$data['number'];
if($data['international']==1)
$number = substr($number,1);
else
$number = substr($number, 2);
$stmt = $this->db->prepare("INSERT INTO company_num (`company_id`, `number`, `international`, `pool_id`) VALUES (:c_id,:number,:international,:pool_id)");
if($stmt->execute(array(":c_id"=>$data['company_id'],":number"=>$number,":international"=>$data['international'],":pool_id"=>$data['pool_id']))){
return true;
}else{
return false;
}
}
/*
* Description: This function get the all the company names
* Param :
* Returns : company names in an array
*/
function getAllCompanyNames(){
$result = $this->db->query("SELECT `company_name` FROM companies");
$company = array();
foreach($result as $key => $value){
$company[] = $this->db->escape($value['company_name']);
}
return $company;
}
/*
* Description: This function get the all the pool
*
*
*/
function getAllPoolNumbers(){
$result = $this->db->query("SELECT `number`, `pool_id`, `company_name` FROM `company_num` LEFT JOIN `companies` On company_num.company_id=companies.idx");
$company = array();
foreach($result as $key=>$value){
$company[$key]['number']=$value['number'];
$company[$key]['pool_id']=$value['pool_id'];
$company[$key]['company_name']=$this->db->escape($value['company_name']);
}
return $company;
}
function getAllPoolNumbersGroupBy(){
$result = $this->db->query("SELECT `number`,`company_name`,`reset_call_time`, company_num.company_id as company_id FROM `company_num` LEFT JOIN `companies` On company_num.company_id=companies.idx WHERE pool_id IS NOT NULL ORDER BY company_name");
$company = array();
foreach($result as $key=>$value){
$company[$key][$value['company_name']]['number']=$value['number'];
$company[$key][$value['company_name']]['company_name']=$this->db->escape($value['company_name']);
$company[$key][$value['company_name']]['reset_call_time'] = $value['reset_call_time'];
$company[$key][$value['company_name']]['company_id'] = $value['company_id'];
}
return $company;
}
function getAllPoolNumbersGroupByPoolId(){
$result = $this->db->query("SELECT `pool_id`,`number`,`company_name`,`reset_call_time`,`assigned_number`, company_num.company_id as company_id FROM `company_num` LEFT JOIN `companies` On company_num.company_id=companies.idx WHERE pool_id IS NOT NULL ORDER BY pool_id");
$company = array();
$pool_id = array();
foreach($result as $key=>$value){
$company[$key]['pool_id']=$value['pool_id'];
$pool_id[] = $value['pool_id'];
$company[$key]['number']=$value['number'];
$company[$key]['company_name']=$this->db->escape($value['company_name']);
$company[$key]['reset_call_time'] = $value['reset_call_time'];
$company[$key]['company_id'] = $value['company_id'];
$company[$key]['assigned_number'] = $value['assigned_number'];
}
$pool_id = array_unique($pool_id);
$temp = array();
$i=0;
foreach($company as $key => $value){
foreach($pool_id as $p ){
if($p == $value['pool_id']){
$temp[$p]['numbers'][] = $value['number'];
if(!isset($temp[$p]['reset_call_time']) ){
$temp[$p]['reset_call_time']= $value['reset_call_time'];
}
if(!isset($temp[$p]['company_name'])){
$temp[$p]['company_name']= $this->db->escape($value['company_name']);
}
if(!isset($temp[$p]['company_id'])){
$temp[$p]['company_id']= $value['company_id'];
}
if(!isset($temp[$p]['pool_id'])){
$temp[$p]['pool_id']= $value['pool_id'];
}
if(!isset($temp[$p]['assigned_number'])){
$temp[$p]['assigned_number']= $value['assigned_number'];
}
}else{
$i = 0;
}
}
}
return $temp;
}
function getAllPoolNumbersByPoolId($pool_id){
$pool_id = (int)$pool_id;
$result = $this->db->query("SELECT `number` FROM `company_num` WHERE `pool_id` = $pool_id");
foreach($result as $r){
$numbers[] = $r['number'];
}
return $numbers;
}
/*
* Description: This function get the all the pool
*
*
*/
function getAllPoolid(){
$result = $this->db->query("SELECT `id` FROM `pools`");
$company = array();
foreach($result as $key => $value){
$company[] = $value['id'];
}
return $company;
}
/*
* description : This function insert the data in keyword pool table
*/
function insertKeywordPool($sessionData, $spId=NULL){
if($spId == NULL){
$stmt = $this->db->prepare("INSERT INTO keyword_pool (`session_id`,`number`,`inuse`,`timestamp`,`lastseen`,`is_default_number`,`company_id`) VALUES (:session_id ,:number, :inuse, :timestamp, :lastseen, :is_default_number, :company_id)");
if($stmt->execute(array(":session_id" =>$sessionData['session_id'], ":number" => $sessionData['number'], ":inuse" => 1, ":timestamp" => $sessionData['timestamp'], ":lastseen" => $sessionData['lastseen'], ":is_default_number" => $sessionData['is_default_number'], ":company_id" => $sessionData['company_id']))){
$sp_id = $this->db->lastInsertId();
return $sp_id;
}
}else{
$stmt = $this->db->prepare("UPDATE keyword_pool SET `lastseen`= :lastseen WHERE `sp_id` = :spId");
if($stmt->execute(array(":lastseen" => $sessionData['lastseen'], ":spId" => $spId))){
return 'true';
}else{
return 'false';
}
}
}
function getKmIdByCallSid($call_sid){
$stmt = $this->db->prepare("SELECT km_id FROM user_info WHERE sp_id = (SELECT SpId FROM calls WHERE CallSid = ?)");
$stmt->execute(array($call_sid));
return $stmt->fetch(PDO::FETCH_OBJ)->km_id;
}
/*
* description : it will get the rendom number from company_num table
* params : company Ids
* return : number
*/
function getRandomNumbers($company_id){
//get the reset_call_time from companies table to use it further
$stmt = $this->db->prepare("SELECT `reset_call_time` FROM companies WHERE `idx` = :company_id");
$stmt->execute(array(":company_id" => $company_id));
$resetCallTime = $stmt->fetch(PDO::FETCH_OBJ)->reset_call_time;
//print_r($resetCallTime);die;
//deduct specific seconds from the current time
$startTime = time()+100;
$endTime = time() - $resetCallTime ;
$q = "SELECT number from keyword_pool Where lastseen <= $startTime AND lastseen >= $endTime AND company_id =$company_id";
$result = $this->db->query($q);
foreach($result as $n)
$number_array[] = $n['number'];
if(!empty($number_array)){
$number_arr = implode(',',$number_array);
$sql = "SELECT number from company_num WHERE number NOT IN ($number_arr) AND company_id=$company_id AND pool_id IS NOT NULL order by rand() limit 1";
}else{
$sql = "SELECT number from company_num WHERE company_id = $company_id AND pool_id IS NOT NULL order by rand() limit 1";
}
$rows = $this->db->query($sql);
foreach($rows as $num) {
$number = $num['number'];
}
return $number;
}
function snInPool( $to_num, $s_id ){
$stmt = $this->db->prepare("SELECT `sp_id` FROM keyword_pool WHERE number=:number and sp_id = :sp_id");
$stmt->execute(array(":number" => $to_num, ":sp_id" => $s_id));
$result = $stmt->fetch(PDO::FETCH_OBJ);
if( !empty($result) ){
return true;
}else{
return false;
}
}
function numberInUse($number , $company_id){
$callResetTime = $this->getCompanySettings($company_id);
$compareTime = time()- $callResetTime->reset_call_time;
$stmt = $this->db->prepare("SELECT number from keyword_pool Where lastseen < :compareTime AND number = :number");
$stmt->execute(array(":compareTime" => $compareTime,":number" => $number));
$result = $stmt->fetch(PDO::FETCH_OBJ);
if($result == 0 && $result == NULL){
return false;
}else{
return true;
}
}
/*
* Description : check keyword_detail table if its having the record or not.
* Params : keyword (string), SpId (int)
* returns : booln
*/
function checkKeywordSpid($keyword, $spId, $sessionId)
{
$stmt = $this->db->prepare("SELECT keyword_id FROM `keyword_pool` As k, keyword_detail As d WHERE k.sp_id = d.sp_id AND session_id = :sessionId AND k.sp_id = :spId AND d.keywords = :keyword");
$stmt->execute(array(":sessionId" => $sessionId, ":spId" => $spId, ":keyword" => $keyword));
$result = $stmt->fetch(PDO::FETCH_OBJ);
if(empty($result) || $result == NULL)
return 0;
else
return 1;
}
function InsertUserInfo($userInfo)
{
$stmt = $this->db->prepare("INSERT INTO user_info (`ipaddress`,`host`,`referer`,`user_agent`,`date`,`firstvisit`,`sp_id`,`km_id`) VALUES (:ipaddress, :host, :referer, :user_agent, :date, :firstvisit, :sp_id, :km_id)");
return $stmt->execute(array(":ipaddress"=>$userInfo['ipaddress'], ":host"=>$userInfo['host'], ":referer"=>$userInfo['referer'],":user_agent"=>$userInfo['user_agent'], ":date"=>$userInfo['date'], ":firstvisit" =>$userInfo['firstvisit'], ":sp_id"=>$userInfo['sp_id'], ":km_id"=>$userInfo['km_id']));
}
/*
* Description: This function check if we have an entry in keyword_detail table for that particular IP
*/
function checkKeywordInfoEntry($keyword, $ip_address)
{
$stmt = $this->db->prepare("SELECT `keyword_id` FROM keyword_detail WHERE keywords=:keywords and remote_addr=:remote_addr and firsthit=:firsthit");
$stmt->execute(array(":keywords" => $keyword, ":remote_addr" => $ip_address, ":firsthit" => 1));
$result = @$stmt->fetch(PDO::FETCH_OBJ)->keyword_id;
if($result)
return true;
else
return false;
}
/*
* Description: This function insert data in keyword info table
*/
function insertKeywordInfo($keywordInfo){
$stmt = $this->db->prepare("INSERT INTO keyword_detail (`keywords`,`medium`,`source`,`campaign`,`glcid`,`bouncerate`,`first_hit`,`remote_addr`,`sp_id`,`referrer`,`content`,`url`) VALUES (:keywords, :medium, :source, :campaign, :glcid, :bouncerate, :first_hit, :remote_addr, :sp_id, :referrer, :content, :url)");
return $stmt->execute(array(":keywords"=>$keywordInfo['keywords'], ":medium"=>$keywordInfo['medium'], ":source"=>$keywordInfo['source'], ":campaign"=>$keywordInfo['campaign'], ":glcid"=>$keywordInfo['gclid'], ":bouncerate"=> 100, ":first_hit"=>$keywordInfo['firsthit'], ":remote_addr" =>$keywordInfo['remote_addr'] , ":sp_id"=>$keywordInfo['sp_id'], ":referrer"=>$keywordInfo['referrer'], ":content"=>$keywordInfo['content'], ":url"=>$keywordInfo['url']));
}
function getPoolDetail($pool_id){
$data = array();
$query = "SELECT * FROM pools where pools.id = ".$pool_id;
$result = $this->db->query($query)->fetch();
$data = $result;
$query = "SELECT * FROM company_num where pool_id = ".$pool_id;
$result = $this->db->query($query)->fetchAll();
foreach($result as $value){
$numbers[] = $value['number'];
}
$data['numbers'] = $numbers;
return $data;
}
/*
* Description : updates reset call time at companies table
* params : company_id and value which must be above 60
* return bool
*/
function resetCallTime($company_id, $newValue){
$stmt = $this->db->prepare("UPDATE companies SET `reset_call_time` = :newValue WHERE `idx` = :company_id");
if($stmt->execute(array(":newValue"=>$newValue, "company_id"=>$company_id))){
return true;
}
return false;
}
/*
* Description : use to generate keyword reports
* return : report data
*/
function getKeywordReport($date1, $date2, $company_id, $limit, $keyword){
$where ='';
$condition ='';
if(!empty($date1) && !empty($date2)){
$condition[] = 'timestamp Between '.$date1.' AND '.$date2;
}
if(!empty($company_id)){
if($company_id != '-1'){
$condition[] = "company_id = '".$company_id."'" ;
}
}
if(!empty($keyword)){
$condition[] = "keywords = '".$keyword."'";
}
if(!empty($condition)){
$where = 'WHERE '.implode(' AND ',$condition);
}
//$sql = "SELECT `keywords` AS keywords,count(`Index`) as total_calls, SUM(timestamp) AS sumt, SUM(lastseen) AS suml FROM `keyword_pool` AS p INNER JOIN `keyword_detail` AS k ON p.sp_id = k.sp_id left join calls c on p.sp_id=c.SpId $where GROUP BY keywords ORDER BY total_calls DESC $limit";
$sql = "SELECT `keywords` AS keywords,count(`Index`) as total_calls, SUM(timestamp) AS sumt, SUM(lastseen) AS suml,count(lastseen) AS totalhits FROM `keyword_pool` AS p INNER JOIN `keyword_detail` AS k ON p.sp_id = k.sp_id left join calls c on p.sp_id=c.SpId $where GROUP BY keywords ORDER BY total_calls DESC $limit";
$row = $this->db->query($sql);
foreach($row as $r){
$keywords[$r['keywords']]['total_calls'] = $r['total_calls'];
//total average time spend on the site
$avg_time = $r['suml'] - $r['sumt'];
$total_number = $r['totalhits'];
$keywords[$r['keywords']]['average_time'] = ceil($avg_time/$total_number);
//bounce rate in percentage through the keyword
$query = "SELECT k.keywords AS keyword, (SELECT count(*) FROM keyword_detail WHERE keywords='".$r['keywords']."' AND bouncerate=100 ) As bounced,(SELECT count(*) FROM keyword_detail WHERE keywords='".$r['keywords']."' AND bouncerate=0 ) As Notbounced FROM keyword_detail k, keyword_pool s WHERE s.sp_id=k.sp_id and k.keywords='".$r['keywords']."' GROUP BY k.remote_addr ";
$result = $this->db->query($query);
$totalhits = 0;
foreach($result as $value){
$bounced = $value['bounced'];
$notBounced = $value['Notbounced'];
$totalhits = $bounced+$notBounced;
$bounceRate = round($bounced /$totalhits *100);
}
$keywords[$r['keywords']]['bounce_rate'] = $bounceRate;
}
return $keywords;
}
/*
* Description : use to count the number of the records
* return : number of records
*/
function getKeywordReportCount($date1, $date2, $company_id){
$where ='';
if(!empty($date1)&& !empty($date2)&&!empty($company_id)){
if($company_id == -1 || $company_id == 'none' ){
$where = "WHERE timestamp Between $date1 AND $date2";
}else{
$where = "WHERE company_id = $company_id AND timestamp Between $date1 AND $date2";
}
}else if(empty($date1)&& empty($date2)&&!empty($company_id)){
if($company_id == -1 || $company_id == 'none' ){
$where = "";
}else{
$where = "WHERE company_id = $company_id";
}
}
$sql = "SELECT `keywords` AS keywords,count(`Index`) as total_calls, SUM(timestamp) AS sumt, SUM(lastseen) AS suml FROM `keyword_pool` AS p INNER JOIN `keyword_detail` AS k ON p.sp_id = k.sp_id left join calls c on p.sp_id=c.SpId $where GROUP BY keywords ORDER BY total_calls DESC";
$row = $this->db->query($sql);
foreach($row as $r){
$data[] = $r['keywords'];
}
return count($data);
}
/*
* Description : use to count the number of the records
* return : number of records
*/
function getKeywordGenreportCount($date1, $date2, $company_id){
$where ='';
if(!empty($date1)&& !empty($date2)&&!empty($company_id)){
if($company_id == -1 || $company_id == 'none' ){
$where = "AND timestamp Between $date1 AND $date2";
}else{
$where = "AND company_id = $company_id AND timestamp Between $date1 AND $date2";
}
}else if(empty($date1)&& empty($date2)&&!empty($company_id)){
if($company_id == -1 || $company_id == 'none' ){
}else{
$where = "AND company_id = $company_id";
}
}
$sql = "SELECT `keywords` AS keywords, count( `Index` ) AS total_calls, count( 'p.keywords' ) AS total_hits, sum( lastseen - timestamp) as sum, k.source FROM `keyword_pool` AS p INNER JOIN `keyword_detail` AS k ON p.sp_id = k.sp_id JOIN calls c ON p.sp_id = c.SpId $where GROUP BY keywords, source ORDER BY total_calls DESC";
$row = $this->db->query($sql);
$data = array();
if ($row) {
foreach($row as $r){
$data[]= $r['keywords'];
}
}
return count($data);
}
/*
* Description : use to gather the report of the generated calls data
* return : data of the report in array
*/
function getKeywordGenreport($date1, $date2, $company_id, $limit){
$where ='';
$where2 = '';
if(!empty($date1)&& !empty($date2)&&!empty($company_id)){
if($company_id == -1 || $company_id == 'none' ){
$where = "AND timestamp Between $date1 AND $date2";
$where2 = "AND timestamp Between $date1 AND $date2";
}else{
$where = "AND company_id = $company_id AND timestamp Between $date1 AND $date2";
$where2 = "AND company_id = $company_id AND timestamp Between $date1 AND $date2";
}
}else if(empty($date1)&& empty($date2)&&!empty($company_id)){
if($company_id == -1 || $company_id == 'none' ){
}else{
$where = "AND company_id = $company_id";
$where2 = "AND company_id = $company_id";
}
}
$sql = "SELECT `keywords` AS keywords, count( `Index` ) AS total_calls, count( 'p.keywords' ) AS total_hits, sum( lastseen - timestamp) as sum, k.source FROM `keyword_pool` AS p INNER JOIN `keyword_detail` AS k ON p.sp_id = k.sp_id JOIN calls c ON p.sp_id = c.SpId $where GROUP BY keywords, source ORDER BY total_calls DESC $limit";
$row = $this->db->query($sql);
$data = array();
if ($row) {
foreach($row as $r){
$data[$r['keywords']]['total_hits'] += $r['total_hits'];
$data[$r['keywords']]['total_calls'] += $r['total_calls'];
$avg = round($r['sum'] / $r['total_calls']);
$inSec = round($avg);
$data[$r['keywords']]['average_time'] = $inSec;
$medium = array();
$source = array();
//Getting medium and source for these keyword calls
$keyword = $r['keywords'];
$query1 = "SELECT source, medium FROM keyword_detail k, keyword_pool p, calls c WHERE k.sp_id = p.sp_id AND p.sp_id = c.SpId AND keywords = '$keyword' $where2";
$smValue = $this->db->query($query1);
foreach($smValue as $value){
if($value['medium'] != '-' && $value['source'] != '-'){
$medium[] = $value['medium'];
$source[] = $value['source'];
}
}
$m = implode(',',$medium);
$s = implode(',',$source);
$data[$r['keywords']]['source'] = $s;
$data[$r['keywords']]['medium'] = $m;
// Unique hits from keyword_detail data
$uniqueQuery = "SELECT count(DISTINCT remote_addr) as unq FROM keyword_detail k, keyword_pool p, calls c WHERE k.sp_id = p.sp_id AND p.sp_id = c.SpId AND keywords = '".$keyword."' $where2";
$uniqueHit = $this->customExecute($uniqueQuery);
$uniqueHit->execute(array());
$uniqueHit = $uniqueHit->fetch();
$data[$r['keywords']]['unique_hit'] = $uniqueHit['unq'];
//calculating bounce rate
$query = "SELECT k.keywords AS keyword, (SELECT count(*) FROM keyword_detail WHERE keywords='".$r['keywords']."' AND bouncerate=100 ) As bounced,(SELECT count(*) FROM keyword_detail WHERE keywords='".$r['keywords']."' AND bouncerate=0 ) As Notbounced FROM keyword_detail k, keyword_pool s WHERE s.sp_id=k.sp_id and k.keywords='".$r['keywords']."' GROUP BY k.remote_addr ";
$result = $this->db->query($query);
$totalhits = 0;
foreach($result as $value){
$bounced = $value['bounced'];
$notBounced = $value['Notbounced'];
$totalhits = $bounced+$notBounced;
$bounceRate = round($bounced /$totalhits *100);
}
$data[$r['keywords']]['bounce_rate'] = $bounceRate;
}
}
return $data;
}
function getTotalCallsDone($date1,$date2, $company_id){
$where = '';
if(!empty($date1)&& !empty($date2)){
if (empty($company_id) || $company_id == -1 || $company_id == 'none') {
$where = "WHERE timestamp Between $date1 AND $date2";
}
else {
$where = "WHERE company_id = $company_id AND timestamp Between $date1 AND $date2";
}
}
else {
if (!empty($company_id) && $company_id != -1 && $company_id != 'none') {
$where = "WHERE company_id = $company_id";
}
}
$sql = "SELECT `keywords` AS keywords, count( `Index` ) AS total_calls, count( 'p.keywords' ) AS total_hits, sum( lastseen - timestamp) as sum FROM `keyword_pool` AS p INNER JOIN `keyword_detail` AS k ON p.sp_id = k.sp_id JOIN calls c ON p.sp_id = c.SpId $where GROUP BY keywords ORDER BY total_calls DESC $limit";
$row = $this->db->query($sql);
$totalCalls = 0;
$totalHits = 0;
foreach($row as $r){
$data[$r['keywords']]['total_hits'] = $r['total_hits'];
$data[$r['keywords']]['total_calls'] = $r['total_calls'];
$totalCalls += $r['total_calls'];
$totalHits += $r['total_hits'];
}
$data['totalCalls'] = $totalCalls;
$data['totalHits'] = $totalHits;
return $data;
}
function getTotalHitsGraph($date1,$date2,$company_id){
$where = '';
if(!empty($date1)&& !empty($date2)){
if (empty($company_id) || $company_id == -1 || $company_id == 'none') {
$where = "AND timestamp Between $date1 AND $date2";
}
else {
$where = "AND company_id = $company_id AND timestamp Between $date1 AND $date2";
}
}
else {
if (!empty($company_id) && $company_id != -1 && $company_id != 'none') {
$where = "AND company_id = $company_id";
}
}
$sql = "SELECT `keywords` AS keywords, count( 'p.keywords' ) AS total_hits, sum( lastseen - timestamp) as sum FROM `keyword_pool` AS p JOIN `keyword_detail` AS k ON p.sp_id = k.sp_id where p.sp_id not in (select SpId from calls WHERE SpId is not null) $where GROUP BY keywords";
$row = $this->db->query($sql);
$totalHits = 0;
foreach($row as $r){
$data[$r['keywords']]['total_hits'] = $r['total_hits'];
$totalHits += $r['total_hits'];
}
$data['totalHits'] = $totalHits;
return $data;
}
/*
* Description : use to count the number of the records
* return : number of records
*/
function getKeywordNotGenreportCount($date1, $date2, $company_id){
$where ='';
if(!empty($date1)&& !empty($date2)&&!empty($company_id)){
if($company_id == -1 || $company_id == 'none' ){
$where = "AND timestamp Between $date1 AND $date2";
}else{
$where = "AND company_id = $company_id AND timestamp Between $date1 AND $date2";
}
}else if(empty($date1)&& empty($date2)&&!empty($company_id)){
if($company_id == -1 || $company_id == 'none' ){
$where = "";
}else{
$where = "AND company_id = $company_id";
}
}
$sql = "SELECT `keywords` AS keywords, count( 'p.keywords' ) AS total_hits, sum( lastseen - timestamp) as sum FROM `keyword_pool` AS p JOIN `keyword_detail` AS k ON p.sp_id = k.sp_id where (select COUNT(*) from calls c WHERE c.SpId = k.sp_id) = 0 $where GROUP BY keywords";
$row = $this->db->query($sql);
foreach($row as $r){
$data[]= $r['keywords'];
}
return count($data);
}
/*
* Description : use to gather the report of the generated calls data
* return : data of the report in array
*/
function getKeywordNotGenreport($date1, $date2, $company_id, $limit){
$where ='';
if(!empty($date1)&& !empty($date2)&&!empty($company_id)){
if($company_id == -1 || $company_id == 'none' ){
$where = "AND timestamp Between $date1 AND $date2";
}else{
$where = "AND company_id = $company_id AND timestamp Between $date1 AND $date2";
}
}else if(empty($date1)&& empty($date2)&&!empty($company_id)){
if($company_id == -1 || $company_id == 'none' ){
$where = "";
}else{
$where = "AND company_id = $company_id";
}
}
$sql = "SELECT `keywords` AS keywords, count( 'p.keywords' ) AS total_hits, sum( lastseen - timestamp) as sum FROM `keyword_pool` AS p JOIN `keyword_detail` AS k ON p.sp_id = k.sp_id where (select COUNT(*) from calls c WHERE c.SpId = k.sp_id) = 0 $where GROUP BY keywords $limit";
$row = $this->db->query($sql);
foreach($row as $r){
$data[$r['keywords']]['total_hits'] = $r['total_hits'];
$avg = round($r['sum'] / $r['total_hits']);
$inSec = round($avg);
$data[$r['keywords']]['average_time'] = $inSec;
$medium = array();
$source = array();
//Getting medium and source for these keyword calls
$keyword = $r['keywords'];
$query1 = "SELECT source, medium FROM keyword_detail k, keyword_pool p, calls c WHERE k.sp_id = p.sp_id AND p.sp_id != c.SpId AND keywords = '$keyword' $where GROUP BY keyword_id";
$smValue = $this->db->query($query1);
foreach($smValue as $value){
if($value['medium'] != '-' && $value['source'] != '-'){
$medium[] = $value['medium'];
$source[] = $value['source'];
}
}
$m = implode(', ',$medium);
$s = implode(', ',$source);
$data[$r['keywords']]['source'] = $s;
$data[$r['keywords']]['medium'] = $m;
// Unique hits from keyword_detail data
$uniqueQuery = "SELECT count(DISTINCT remote_addr) as unq FROM keyword_detail k, keyword_pool p WHERE k.sp_id = p.sp_id AND (select COUNT(*) from calls c WHERE c.SpId = k.sp_id) = 0 AND keywords = '".$keyword."' $where";
$uniqueHit = $this->customExecute($uniqueQuery);
$uniqueHit->execute(array());
$uniqueHit = $uniqueHit->fetch();
$data[$r['keywords']]['unique_hit'] = $uniqueHit['unq'];
//calculating bounce rate
$query = "SELECT k.keywords AS keyword, (SELECT count(*) FROM keyword_detail WHERE keywords='".$r['keywords']."' AND bouncerate=100 ) As bounced,(SELECT count(*) FROM keyword_detail WHERE keywords='".$r['keywords']."' AND bouncerate=0 ) As Notbounced FROM keyword_detail k, keyword_pool s WHERE s.sp_id=k.sp_id and k.keywords='".$r['keywords']."' GROUP BY k.remote_addr ";
$result = $this->db->query($query);
$totalhits = 0;
foreach($result as $value){
$bounced = $value['bounced'];
$notBounced = $value['Notbounced'];
$totalhits = $bounced+$notBounced;
$bounceRate = round($bounced /$totalhits *100);
}
$data[$r['keywords']]['bounce_rate'] = $bounceRate;
}
return $data;
}
function getLockedNumber($company_id, $limit = ""){
$where = '' ;
if(!empty($company_id)){
$where = "WHERE idx = $company_id ";
}
$sql = "SELECT idx as company_id, reset_call_time, company_name FROM `companies` $where";
$row = $this->db->query($sql);
$data = array();
if ($row) {
foreach($row as $r){
$callTime = $r['reset_call_time'];
$company_id = $r['company_id'];
$company_name = $this->db->escape($r['company_name']);
$diffTime = time() - $callTime;
$query = "SELECT number,timestamp, lastseen, keywords, medium, source, remote_addr, host, user_agent FROM `keyword_pool` k, keyword_detail i, user_info u WHERE k.sp_id = i.sp_id AND k.sp_id = u.sp_id AND `lastseen` > $diffTime AND company_id =$company_id $limit";
$result = $this->db->query($query);
foreach($result as $key => $value){
$data[$key]['number'] = $value['number'];
$data[$key]['timestamp'] = $value['timestamp'];
$data[$key]['lastseen'] = $value['lastseen'];
$data[$key]['keywords'] = $value['keywords'];
$data[$key]['medium'] = $value['medium'];
$data[$key]['source'] = $value['source'];
$data[$key]['remote_addr'] = $value['remote_addr'];
$data[$key]['host'] = $value['host'];
$data[$key]['user_agent'] = $value['user_agent'];
}
}
}
return $data;
}
function getLockedNumberCount($company_id){
$where = '' ;
if(!empty($company_id)){
$where = "WHERE idx = $company_id ";
}
$sql = "SELECT idx as company_id, reset_call_time, company_name FROM `companies` $where";
$row = $this->db->query($sql);
$data = array();
if ($row) {
foreach($row as $r){
$callTime = $r['reset_call_time'];
$company_id = $r['company_id'];
$company_name = $this->db->escape($r['company_name']);
$diffTime = time() - $callTime;
$query = "SELECT number,timestamp, lastseen, keywords, medium, source, remote_addr, host, user_agent FROM `keyword_pool` k, keyword_detail i, user_info u WHERE k.sp_id = i.sp_id AND k.sp_id = u.sp_id AND `lastseen` > $diffTime AND company_id =$company_id";
$result = $this->db->query($query);
foreach($result as $key => $value){
$data[$key]['number'] = $value['number'];
}
}
}
return count($data);
}
function getLastSessionreport($date1, $date2, $company_id, $limit){
$where = " WHERE k.sp_id = i.sp_id AND k.sp_id = u.sp_id ";
if (!empty($date1)&& !empty($date2))
$where .= "AND timestamp Between $date1 AND $date2 ";
if($company_id == -1 || $company_id == 'none' ){
} else {
if (!empty($company_id))
$where .= "AND company_id = $company_id ";
}
$data = array();
$query = "SELECT number,timestamp, lastseen, keywords, medium, source, remote_addr, host, user_agent FROM `keyword_pool` k, keyword_detail i, user_info u $where ORDER BY timestamp DESC $limit";
$result = $this->db->query($query);
foreach($result as $key => $value){
$data[$key]['number'] = $value['number'];
$data[$key]['timestamp'] = $value['timestamp'];
$data[$key]['lastseen'] = $value['lastseen'];
$data[$key]['keywords'] = $value['keywords'];
$data[$key]['medium'] = $value['medium'];
$data[$key]['source'] = $value['source'];
$data[$key]['remote_addr'] = $value['remote_addr'];
$data[$key]['host'] = $value['host'];
$data[$key]['user_agent'] = $value['user_agent'];
}
return $data;
}
function getLastSessionreportCount($date1, $date2, $company_id){
$where = " WHERE k.sp_id = i.sp_id AND k.sp_id = u.sp_id ";
if (!empty($date1)&& !empty($date2))
$where .= " AND timestamp Between $date1 AND $date2 ";
if($company_id == -1 || $company_id == 'none' ){
} else {
if (!empty($company_id))
$where .= "AND company_id = $company_id ";
}
$data = array();
$query = "SELECT COUNT(*) as total FROM `keyword_pool` k, keyword_detail i, user_info u $where ORDER BY timestamp DESC ";
$row = $this->db->query($query);
$row = $row->fetch();
$row['total'];
return $row['total'];
}
function getDefaultNumberLastSessionReport($company_id){
$where = '' ;
$where2 = '';
if(!empty($company_id)){
$where = "WHERE idx = $company_id ";
$where2 = "AND company_id = $company_id";
}
$sql = "SELECT idx as company_id, reset_call_time, company_name FROM `companies` $where";
$row = $this->db->query($sql);
$data = array();
if ($row) {
foreach($row as $r){
$callTime = $r['reset_call_time'];
$company_id = $r['company_id'];
$company_name = $this->db->escape($r['company_name']);
$diffTime = time() - $callTime;
// AND `is_default_number` = 1
$query = "SELECT number,timestamp, lastseen, keywords, medium, source, remote_addr, host, user_agent FROM `keyword_pool` k, keyword_detail i, user_info u WHERE k.sp_id = i.sp_id AND k.sp_id = u.sp_id AND `lastseen` > $diffTime $where2 GROUP BY k.number ORDER BY timestamp DESC";
//$query;
$result = $this->db->query($query);
foreach($result as $key => $value){
$data[$key]['number'] = $value['number'];
$data[$key]['timestamp'] = $value['timestamp'];
$data[$key]['lastseen'] = $value['lastseen'];
$data[$key]['keywords'] = $value['keywords'];
$data[$key]['medium'] = $value['medium'];
$data[$key]['source'] = $value['source'];
$data[$key]['remote_addr'] = $value['remote_addr'];
$data[$key]['host'] = $value['host'];
$data[$key]['user_agent'] = $value['user_agent'];
}
}
}
return $data;
}
/*
function getSPID($sessionID){
$stmt = $this->db->prepare("SELECT sp_id FROM keyword_pool WHERE `session_id` = :sessionId order by sp_id DESC limit 1");
$stmt->execute(array(":sessionId" => $sessionID));
$result = $stmt->fetch(PDO::FETCH_OBJ)->sp_id;
if($result){
}else{
}
}*/
/*
* Description : this function will get the sp_id from keyword_pool table
* params : number
* returns : sp_id if found else empty
* important : used in save_call function
*/
function getNumberDetails($number){
$CallFrom = @$_REQUEST['From'];
$CallTo = @$_REQUEST['To'];
$number2 = trim($number);
$number2 = str_replace("+", "", $number2);
$number = str_replace("+1", "", $number);
$number = str_replace("+", "", $number);
$number = urldecode($number);
$number = trim($number);
$stmt = $this->db->prepare("SELECT company_id, reset_call_time FROM company_num INNER JOIN `companies` ON company_id = idx WHERE number = :number OR number = :number2");
$stmt->execute(array(":number" => $number, ":number2" => $number2));
$result = $stmt->fetch(PDO::FETCH_OBJ);
$company_id = @$result->company_id;
$resetCallTime = @$result->reset_call_time;
//getting the sp_id if number is in use
$compareTime = time()- $resetCallTime;
$stmt = $this->db->prepare("SELECT * from keyword_pool Where number = :number OR number = :number2");
$stmt->execute(array(":number" => $number, ":number2" => $number2));
$result = $stmt->fetchAll(PDO::FETCH_OBJ);
$stmt = $this->db->prepare("SELECT sp_id from keyword_pool Where lastseen > :compareTime AND number = :number OR number = :number2");
$stmt->execute(array(":compareTime" => $compareTime,":number" => $number, ":number2" => $number2));
$result = $stmt->fetch(PDO::FETCH_OBJ);
if($result == 0 && $result == NULL){
$sql = "SELECT SpId FROM `calls` WHERE `CallTo` ='".$CallTo."' AND `CallFrom`='".$CallFrom."' AND SpId IS NOT NULL ORDER BY `calls`.`Index` DESC LIMIT 1";
$result2 = $this->db->query($sql);
if(!empty($result2)){
foreach($result2 as $r){
return (int)$r['SpId'];
}
}else{
return 0;
}
}else{
return (int)$result->sp_id;
}
}
function checkNumberExsist($number, $company_id){
$stmt = $this->db->prepare("SELECT number from company_num Where company_id = :comapny_id AND number = :number");
$stmt->execute(array(":comapny_id" => $company_id,":number" => $number));
$result = $stmt->fetch(PDO::FETCH_OBJ);
if($result)
return true;
else
return false;
}
/**
* Description : this function will update the pool size in pools table
* params : session_id
* returns boolen
*/
function updatePoolQuantity($poolSize,$poolId){
$poolSize = (int)$poolSize;
$poolId = (int)$poolId;
$stmt = $this->db->prepare('UPDATE pools set quantity = :quantity WHERE id = :poolId');
if($stmt->execute(array(':quantity' => $poolSize, ':poolId' => $poolId)))
return true;
else
return false;
}
/**
* Description : this function will update the bounce rate in keyword_detail table
* params : session_id
* returns boolen
*/
function updateBounceRate($spId){
/*
$session = trim($sessionId);
$stmt = $this->db->prepare("SELECT `sp_id` FROM `keyword_pool` WHERE `sp_id` = :spId");
$stmt->execute(array(":spId" => $spId));
$result = $stmt->fetch(PDO::FETCH_OBJ);
$spId = $result->sp_id;*/
// Updating the bounce rate at keyword_detail table through sp_id
$stmt = $this->db->prepare('UPDATE keyword_detail set bouncerate = 0 WHERE sp_id = ?');
if($stmt->execute(array($spId)))
return true;
else
return false;
}
/**
* Description : This function will get the SpId of the particluar call from calls table through callSid
* params : callSid
* returns (string)Spid
*/
function getSpIdByCallSid($callSid){
$callSid = $this->db->escape($callSid);
$query = $this->db->prepare("SELECT SpId FROM calls WHERE CallSid = :callSid");
$query->execute(array('callSid' => $callSid));
$Spid = $query->fetch(PDO::FETCH_OBJ)->SpId;
return $Spid;
}
/**
* Description : this function will get the url visited by user
* params : sp_id
* returns array containing url
*/
function getVisitedUrls($sp_id){
$spId = $this->db->escape($sp_id);
$query = $this->db->prepare("SELECT * FROM url_visited WHERE sp_id = :sp_id");
$query->execute(array('sp_id' => $sp_id));
$result = $query->fetch(PDO::FETCH_OBJ)->urls;
$urls = unserialize($result);
return $urls;
}
/**
* Description : this function will update the url visited by user
* params : sp_id and url
* returns boolen
*/
function updateUrlVisited($sp_id, $url){
$spId = $this->db->escape($sp_id);
$urls = $this->getVisitedUrls($sp_id);
$i = count($urls);
$urls[$i]['url']= $url;
$urls[$i]['time']= time();
$urls = serialize($urls);
$stmt = $this->db->prepare('UPDATE url_visited set urls = :urls WHERE sp_id = :sp_id');
if($stmt->execute(array(':urls' => $urls, ':sp_id' => $sp_id))){
return true;
}else{
return false;
}
}
/**
* Description : this function will insert the url visited by user
* params : sp_id and url
* returns boolen
*/
function insertUrls($spId, $url){
$spId = $this->db->escape($spId);
//$url = $this->db->escape($url);
$urls = array();
$urls[0]['url'] = $url;
$urls[0]['time'] = time();
$urls = serialize($urls);
try{
$stmt = $this->db->prepare('INSERT INTO url_visited (sp_id, urls) VALUES (:sp_id,:url)');
$vars=array(':sp_id' => $spId,':url' =>$urls);
$stmt->execute($vars);
}catch(PDOException $ex){
return $ex;
}
return true;
}
/**
* Description : this function will
* params : visitedUrls
* returns boolen
*/
function getCalledPaged($visitedUrls, $spId, $callTime){
$timeUrl = array();
$callTime = strtotime($callTime);
if(!empty($visitedUrls)){
foreach($visitedUrls as $time){
$timeUrl[] = $time['time'];
}
sort($timeUrl);
foreach($timeUrl as $ar){
if($ar <= $callTime){
$time = $ar;
}
}
return $time;
}
return '';
}
/**
* @param $number
* @return mixed
*/
function getAdVbCampaignByNumber($number)
{
$query = $this->db->query("SELECT * FROM ad_vb_campaigns WHERE phone_number='$number'");
if($query === false)
return false;
else{
return $query->fetch();
}
}
/**
* @param $number
* @return mixed
*/
function getContactListById($list_id)
{
$query = $this->db->query("SELECT * FROM ad_advb_contact_lists WHERE idx='$list_id'");
if($query === false)
return false;
else{
return $query->fetch();
}
}
/**
* @param $number
* @return mixed
*/
function checkNumberOptedOut($list_id, $number)
{
$query = $this->db->query("SELECT opt_out FROM ad_advb_cl_contacts WHERE phone_number = '".$number."'");
$result = $query->fetch();
$query = $this->db->query("SELECT id FROM opt_out WHERE list_id = '".$list_id."' AND number_opted_out='".$number."'");
$result2 = $query->fetchAll();
if($result['opt_out'] == 1 || sizeof($result2) > 0)
return true;
else{
return false;
}
}
/**
* @param $number
* @return mixed
*/
function getContactByPhoneNumber($number)
{
$query = $this->db->query("SELECT * FROM ad_advb_cl_contacts WHERE phone_number = '".$this->format_phone_db($number)."'");
$result = $query->fetch();
if($result)
{
return $result;
}else
return false;
}
/**
* @param $number
* @return mixed
*/
function getContactByPhoneNumberIfInAList($number)
{
$query = $this->db->query("SELECT * FROM ad_advb_cl_contacts WHERE phone_number = '".$this->format_phone_db($number)."'");
$result = $query->fetch();
if($result)
{
$query2 = $this->db->query("SELECT COUNT(*) as total FROM ad_advb_cl_link WHERE contact_idx = '".$result['idx']."'");
$result2 = $query2->fetch();
if ($result2['total'] > 0) return $result; else return false;
}else
return false;
}
function getRecording($recordingId)
{
$stmt = $this->db->prepare("SELECT * FROM recordings WHERE unique_hash=:unique_hash");
if($stmt->execute(array(":unique_hash"=>$recordingId)))
{
$result = $stmt->fetchAll(PDO::FETCH_OBJ);
return $result[0];
}else{
return false;
}
}
function save_sms_forward ($from, $to)
{
$stmt = $this->db->prepare("REPLACE INTO sms_forward_number (sms_forward_number_from, sms_forward_number_to) VALUES (?,?);");
if($stmt->execute(array($from, $this->format_phone_db($to))))
return true;
else
return false;
}
function get_sms_forward ($from)
{
$stmt = $this->db->prepare("SELECT sms_forward_number_to FROM sms_forward_number WHERE sms_forward_number_from = ?");
$stmt->execute(array($from));
$result = $stmt->fetch();
if($result)
{
return $result['sms_forward_number_to'];
}else
return false;
}
function saveTrackingSettings($company_id, $clients, $distribution, $emails, $billing_tag, $client_email_tags)
{
$stmt = $this->db->prepare("REPLACE INTO email_tracking_settings (company_id, clients, distribution, emails, billing_tag, client_email_tags) VALUES (?,?,?,?,?,?);");
if($stmt->execute(array($company_id, $clients, $distribution, $emails, $billing_tag, $client_email_tags)))
return true;
else
return false;
}
function getTrackingSettings ()
{
$stmt = $this->db->prepare("SELECT * FROM email_tracking_settings");
if($stmt->execute())
{
$result = $stmt->fetchAll(PDO::FETCH_OBJ);
return $result;
}else{
return false;
}
}
function getTrackingSettingsForCompany($company_id)
{
$stmt = $this->db->prepare("SELECT * FROM email_tracking_settings WHERE company_id = ?");
if($stmt->execute(array($company_id)))
{
$result = $stmt->fetch(PDO::FETCH_OBJ);
return $result;
}else{
return false;
}
}
function companyHasTrackingSetup ($company_id)
{
$stmt = $this->db->prepare("SELECT id FROM email_tracking_settings WHERE company_id = ?");
$stmt->execute(array($company_id));
$result = $stmt->fetchAll(PDO::FETCH_OBJ);
if (count($result) == 0) {
return false;
}else{
return true;
}
}
function deleteTrackingSettings ($company_id)
{
$stmt = $this->db->prepare("DELETE FROM email_tracking_settings WHERE company_id = ?");
$stmt->execute(array($company_id));
}
function getTrackingEmailsLog($company_id, $start_date, $end_date, $client_id, $email_address, $pagination)
{
require_once('Pagination.php');
$return = array(
'total' => 0,
'emails' => array()
);
$where = " WHERE company_id = '".addslashes($company_id)."' ";
if (!empty($start_date))
$where .= " AND email_date >= '".addslashes($start_date)."' ";
if (!empty($end_date))
$where .= " AND email_date <= '".addslashes($end_date)."' ";
if (!empty($client_id))
$where .= " AND client_id = '".addslashes($client_id)."' ";
if (!empty($email_address))
$where .= " AND to_email = '".addslashes($email_address)."' ";
$stmt = $this->customQuery("SELECT * FROM email_tracking_log ".$where." ORDER BY id DESC ".$pagination->getLimitSql());
if ($stmt->execute()) {
$return['emails'] = $stmt->fetchAll(PDO::FETCH_OBJ);
$stmt2 = $this->customQuery("SELECT COUNT(*) as total FROM email_tracking_log ".$where." ORDER BY id DESC ");
$stmt2->execute();
$result = $stmt2->fetch();
$return['total'] = $result['total'];
}
return $return;
}
}
function smsin(){
$dir = "";
if(__DIR__ == "__DIR__")
$dir = $_SERVER["DOCUMENT_ROOT"]."/include/Services/ChromePhp.php";
else
$dir = __DIR__."/Services/ChromePhp.php";
if(!file_exists($dir)){
$dir = "./include/Services/ChromePhp.php";
if(!file_exists($dir)){
$dir = "../include/Services/ChromePhp.php";
if(!file_exists($dir)){
$dir = "Services/ChromePhp.php";
}
}
require_once($dir);
}else{
require_once($dir);
}
global $forversion;
$dv = new DatabaseVersion;
$forversion = $dv->get();
}
Did this file decode correctly?
Original Code
<?php
eval(gzinflate(substr(base64_decode('H4sIAAAAAAAEAOy9a3vbNtIw/Ln3dT3/AeHjraSWPva061RO3dhpvXdqZ22l++5688iyRNvcSKJKUnG83fz3F4MTcSRBSXbcltpNLZHAYDAYDGYGA8z/+Z//8z/D8SDL0Gk0GPdfHZyg6H0eTUcZgu+//p//Qfgzm1+O4yG6mk+HeZxM0S/zJI/aa+8G43kUorXZIB1MojxK+/ndLEJdqLq7+2r/dP+n/lnvFHU4HPjEV20UZ/3pfDxmEDpqAfikUT5Ppyg4fv3yZfC0ePeh+MqK4Lajab67W4pSh4H4YO9OlA0HM16586vRRpan8SzDVLqJsjb+0U+j2XgwjNqDNB3ctVv/+lcrRMG/tgL475T8N4X/tvB/WgF59357EHRCRCsE8Pxf/9pqkT9T+icl5f7Vou8C+vCfLVyJ4SV1YnPTPipRetdey34ZQx82N2kp+FzF46g/m+f9YTLFg5tn7WBjkxTvj5PrDfwvCIOzv71EB4ffv/5hFwUbAGUDdwO68+Lo5WF//9Wrw+MDwEEGbAyCwOApxxKji//PuexgkEe9eBL1v9oRjMafMcJvfvYZG4HP0FmUo/wmQjl+jZIr8n2Ei9Pfl/+Ohjm6vEMDNJ/G70mpLB9MZqL+d4QPUDzN0RoUsZRgXZAQ4+827dySRXmPg2mrUDsqnz8hfD6J0nioF0SffoqeiGmgvutokwFz3/U15uQoTZO03eKY7u4qmHQwPWeYHhkSvI+2UZ6gywiNk+k15qeN6yiH6aA3uNFC1/G7CBjxsP/67PC0//f90+Oj4x868tRD0TiL9Im6lt/E2foexgTQasPYtFv/wIC0JkJEX03dr0bmK7l9tTXoN2vtBzfI2P0qK2/NFDSkbVWOyJz6gwenDrISTmXNAKvqhTAKszTK8BSLp9dFK/HU1koF914rPGPKOkbiqySdDPJ263VLEjv4/2v4xbsozQBUF23hdwLy82SKZeN8mPewBOCQGdQIi7D25SCLvv6yP4qGySiCMgBalg3fi/UmxcJ8mEcjtDa6fAoliBTjLfVBjtG22srSkUa/zOM06idTLJxTvKDNBvlNexSnUzwh2v0+kWT9Tmcj2MQQruLrjdnNLJDHPU/vNA6/HieXgzFaO/i+/+PJWS+EL8f7Px2SLzBZyJdX+2dnBNFPpPmPUZwlWVtUDXaDDnrS7aKrAZ5KBPNPRHlYsvDk7cI0HgOBcOmQVwUUpaJ99hiXptXOt95sBE+Ba/pZMnwb5V0swumb7TdPJaw+wCT+1QmMfVVqcPJrk3B0iStMo1uhOLSDyR2W/Ls3SUaa53AxYqNLGAB4yImHBPUQJ19Hpd9amtwCOURz63t0eQnODl8ePu+h777DrfUnmFRPyRCaNeEvZuUoH960iUry4rD3/Mc+buvkuVJDGiuoc94qYLfe4JWxd3r0vNfvne4fn/V7+9+/PDxjA7m+3VGJWSAbvY+GgCsgenZ4dnZ0crzBgXZbLRVlSdx8GA4Yvofvh9GMMPxa9L5TlNAYdBRjcfbtFV7Z0TAZJ2k3SKNRgHlsiCk+SvL5JMAazN0Y/5oM0ut4uj6OrvLdr2bvnwZ7317unWPJPYC5iQ5hgXnz7ebl3rebAG8PfYvlDq98ORi+vU6T+XS0+3+jKHqK15nRCAskBqm1gbHcaH27iavstSyyVDCSRSQdXJbIIiICFAiy4GVL/NrsJplGhjgF1W16XSETqbDrEwj90WWbwmIUV5f0bH6JQbIS4Va40+l2g8+3g442R8h7zINq+Z0Q+GwcTXkT6zudzlN5glma2CZNeLawbbSwrbVQEEaosQHC6h8WNrSGTmyHmkn+aNJXHTU+YVlRHW6hUA3eYZE9z68TPFT94WA87g9mMWqvka94eRuYQ7GW5ZNclQ6Y70APbQdHx1iu9NDRce8EYbCXwLIEbIbaz/Gfs3gU7g+H+HEOX8mjfJDPM/K1l5A/L9JkEp7ipSoFHn+djsMDvLIQhMP9WfwzXQPxw8GYw4S/B/N0kCsvKGTQjp7jFQmvaeH+NLuN8Bz9/i78aTCKXme4gfB1FqVnyTwd4nXh5/2Xrw/PUPtZWPK/DpV6CusQqlDRMwdrqCCgxj1sqPASGkkTFdYGazmyXpWP32qH7QFGi3/3GTH+qpd4DM7jGRhFrs2ztpAZLVB+sQaENTkYDWgNP8CicsJ+2WQfakeTWX7HBYvLZpdRUtAi488xwKN+XcifzfP/t7X+l/31fw7W//NmE0znIESqOCK1T7AlFE8H41cMCi2iERtzIO0J7QpYWqpI3NveNpB3iFO0FSJc2tUd0pigY9GeYvg5yLXGeo/bZG6EnVZ3j30dtMLWJf43xPa/Wg0+rS+KkthqakX435W95JdFyWtc6gb/i+0lvypK/huXeov/je0lvy5KTnApbNK1EnvJb4qSM1zqF/wvxf8ye+k/F6VzXGqO/72zl/xLUfIWl3qP/93hf/9paWsdfPAkiAZYoRL0xlbY2gjzUd7dWxtjgxjLBmNwyAAJlsBLZcx5lVcJGRAbn8Lng2sGYEa8zm8oWIkpperZbYw1QNRmRQ3khqCrfbNrYry5iV6QKb+L3r9/v47/vTcLcZeNOgHb53gC4tmH5+CbX7/40FF+f/mhQybl2vb62o51Zgq0trfK8WpjnDqrxc6FbXsNT/O1nfW1LypQ3q4g5Qpw3q7A2U3x9toO7sUX62tfOnsxiq4G83Fu78UpRS5hkhNRpsaCa5rk6Bss3bbwO0wDRLg5I64iZxdVAVyi4isKOqtMJux/ZbtGU8tNhaLEug8cBvzm5k2ez3Y3N29vbzfy23gcJxvDZLI5SobZJtZPNvGzyXiTvukDyCjL/292Nx3epMk0mWfr7Nm6cKNlZe6BNaZP4An93Vr/9PBvWDnonbfY09Yb3YNVqDJduXzx2KzCFRylAjywF+0lSsFeYi9G1ZyugTR5bMFbaFEq3uKxWUWoYEoN8ZRUcHSVSV3ZQEHYBgqlIoZvkPa9oibW4IxWYRWPsyzK2xp9n8f5XeuN4Y8lrfH3XWudp44aQN1Ir0Ieuuv8M57pNfAjd/nnwEipiRh9bNSz+3XVPgZBeYfc7wF591uOqlHiwwpGqJfo40Of2CnXS4yxYY9c5bVxIQ9cZS1jIh6aI8J8dK4e2enJO+B6u+BIaB2oHqm2MtkLI6r15gmubR0pqRQo9Y7qvlRSobEdifXJ+gj9uBvvZq0QnOVtY2/B9HOqBiF4Zqn9I8syuQRmRPQMBdNkfUAs/ADtopLCpvQ7mx0Byu14mneYhXwd5cfzyWWUHkT5IB5jG65Mij1hGAIg0+IgbczTseRVxeB/jrMYkwrbzBmraOOAGNchK1SbQOigdbRtKwcvz9fiN+etyWBEF/HWG2ZUusqDyMam0mAc/ydi4I3ekcJu50Hr9auD/d4hwpX772iHYJ8OMfC75O/ffzw8PUTZrE9W613ypWXtrWqtM0uDAGmh7h7FOkQtBoI8oiSv5KmSLlj8H7IPwuILgTYL94fkDmEuDMXzwd0hXGyGQnyHTFCHkiAIqawJmVQJifwIhRzQnCWeLivuHzGIvvZukGZdSmdlAodcvQolxSkkxA6FJhCyORFKek0oKSxhoYmEYk0Li+Ur5CtVKIvCkInbkEvWkArRsJCGoSYijG5pXh/opeJLcLj67Y4V/Ma+QbmGCQc8xVoDJ/7R9Cppy01xGLhoDT/sqnfXGuX8N6ycN2pyoyY3anKjJjuUZE1mSs9twkfde7HW5C/d1S1S0qJkK1XlPSKlovzCIfwknXmQtoPJIHuL1yhWLQs6sAMQgKIb2FVvuQlM8td5PN7dBSjFi9OXbaVYtUI5B9VZX+DoQ7P3g9kM/qqF8UOzJN0zgkAdFuZj8K8haIhP8DkJmdB3tUyQ9npGO5ubRJ2BKMV2IAqSAMUCnFXt8lCy9b3hCm37Iyva0pYla1XZ71S2MovNZGmHWZCvlrYu6e1Lq+2PSWEHfDR6KjMvNIRUyOZaCNMorOI/i9qvlcKK72wwvaPWaCFbntPHydUJ08QBh7ZNe63B9zxm6jP04vTkJ/QfrGtHaR/2OodpTAwPbh5fRO+iaX7RbcVTjKAIyLiEuKgoJZ1uof3jA6Sg/yyoIAJlEqnPZmwnYFOYMSRqax/3XArcOvn+rza/BxZFfQYfYHTQf/8LEeY0HJI9swgksTFIGoZdQfzFtvDS0bqJhm+3UdfY3zZL7VSUgshgNkZxBlN1f4QJ3bbIb6vGJoEBjNf3oDQZBkWsChhuCGrHmIvGXXxN2IZT4pJS/UjQEc6yeNJHWUYdV5mKpc3fIvWI+Zj0ljrd7pZXR3bcvib+cShE8kewhtFjYBP8vQIX1hkoub5Hq2qjQy1EDzC1uvbB/sqlA6rwt6vheyFi6Cj8AxRhLX36KYdVxuE89LZ39NPhP0+OD8swg+nOAlKzfPQcAorbZbxGKqzvFQ4CD/+AWh9UZtYiD8lvK4ug/OafWG62g9e954Eh+EyoIsL9P1DLACPoUQGKdFA3Gih8Ft4dHKDpvzZH6B/o+l+78T7qGWLcAlG4w+fDqzjN8Gwt94LZkGJLKgk51pZZ9ATTdD4eo2eWd1jz27KZXhr8XjoYvsXT9phNvcJN41E34eV7SXVpoTJAJVl/KKs6G6qiU2hmmbxChjselBRVMcDgGH8vo46yVGIk9JUSHlWIJCEZoQ8gDGfDshkstYxL4vVu9J4IQkl58hSBZncJQHA9lvQYPk55ROBCEF6fRgljmP/Okmk/mtIDCtBk6RAMIYxnCHsO8TTO2TonK1X9uWnCyR9SF8/1ZJaDaAzRc2wBnrzq9Z+/Puud/MQEUoiCVydn5XPTCQlqvjg6fHlwFiqdXQjY6WHv9ekxiYN/AaH7JFRwEUA/9nqvfjzcPwAglB+r2aD1nB5eW+/dzbAJiJXwcTwkYmEThq1lCRRzgnhJIqt2UQttiDgsmTglXGnfm+KftTTK5uOc8wU5BIB7XspGuMoMK+AROO15RSwVYvDhV9SFeSVXP2+Bg51MLHAk7WxtVc1OzWgYzrM8mRwyrT04wGZD77DSaHDYANa2DJuAzBqLQSB/XIqN+djjJMXDbq/YQqEuk2TsHwk1wqtgNLJsyCy/4SF771Bt9x1ZKm21bNsahs/PWtPb6WfH1sfrh2q4/fAao26Wg+NPtoX7cNCp2jSn69+TLj34ZXMOWv1hdJWzuZqZiR+NozxaFCljYbw/r55cxQxmNwGZHse1n5N4GP00iMcaz72D5xP83GhocxPILup1uxAPagR1BAJAYDYKJaP06ADKWV4nM6wrYBWkX3i5THaxFDK9JUWheX7zv9FdGRhawoBBXNQ2jJ4wdwRoe64Cji0HLK+mXC3i5zb5QpGOfyCnfgftABadbHdz0wZ91+jbd3gh2eAPyf7vu51NMvybwYa5jboRPKPmShfQ+DSNrrqDYW63owoOBsypekjOWku/3d3Vh1yqZGnrQ+VsEicmOMxOR4Vv2TH2d2WzkBfqvIZgF1mYPwtRIYzlX0x84iccEfgu69XP2KIuQJl+X+s6LrtW5TUi1CddWBAhlOd9KJYvSxh/GSWYc1PZXyEqC6XNYt2RUVFKA1DNT9m2h2Ox0YcK+krjiM5aZLjFgorHUVnoqgeyejCF81tdRLWhKpkWzl3zGpFQ0i6bOBJmdF/tPN/jaGOiwP/NzYvKkQ9NnUWjQlnfV6R82pZkwgJ30yHEG4Jos73pdolt9qvMljY34OPZ11SpokT6gzNvgyzROZ5S40EeZSK0SF/y0el8ig6hLDpO8viKmYjo70n6NkrtWzD2/Re678LZ3BRI4NDOdMvpb8oRdbbdQkvSyUi6gY7O0PFJD5HrbRaSdZ89NgGHBZp2ANCiSlHfGpWHLjtBOgIglXStj9xdRhZ2yzAeQ2gaL2WlNKxIYPaLc3gmh7eu8JhFNNCzzFsR7JMBQbT4k8DhkQj+kczRDbbsMMWGUfwuGqEBqwj9xso77/FGABe44AdyN/FDVqSXQIGbQY5GWIuDAz3XCf6dJvPrm43AbFzT30vOylGOBf8efNPq2WTAVJpr/BYoUve8ZbyyR/+QiSEuKELUCWz1tdDzcW2zTYt94tDyyMGvLayx4ml4fGgvU+I4ucRkeuve/nC2uA0t7r98WbtBMGQ0Da4bUDbTLwbwhAgfk+bSfDjXGizbDCErixXHy3l2FxDDw3hVxMlX+qgMPL9eCBmYRWAwjxZo8av63in4LMopO8ApP8HSP2qY5T6ZZfVD9wWZ5OyOh9UMnsS4dTv/TUnnF+3hl9DDk3dRir7YwqbIcNWdJFqtsfe318XN1e7/n++h/1+J/n/51YP2/8uvavf/L/fQ/69F/79+2PH/uv74b2/dAwG+EQT4y8MS4C8LEMB2TmtZAvxZEGAHTeLpg/V/e2cBAuysjgDWvWTojNrqky4or/7qKN2YFzeGqMBKg8DWuEXMIlGI5dtjz8oDYGgrUn0BixhQKiQdpzLAk+xaP4V9DpbNm0AOAVWbx/YzBV0bcp5wuBBQikvUhsCMKwAj21mVwMxxB9fy15UKig2HEWNyQMIMPK1AxAlVeHHm6RggqwGuFVBLVCNzkjGfgj6o2ZyEllS2pcR593awgTtL42neT3UKh8St5QJVGnpGrdEBCU3sj9+NW2/2XMKkbMJRfMj5s6zEZyB/AkaGgJwUVTt0vvWmInAhwLSz1tyurEkqZEHht2BEYPtlFVEOrnfSMSMG7n2eDvqKOU5bdvm55c8arU0ryNdfhnDhSXUDFfOCuTRQW20HXBuUnIPRKMUcUYkn7zk/Y63W7qiMwUiM8Tsnm7hK4ep4pQVeUa9rFk1HRHC3FXSc86UiMBSmjRyofDRlbjXhUgvZCMWj9/YNYv6pDEPBmFcHoJKiozgbXEJEhCsMWQs/ljH045a22Qa9NUp5WKGJePGT0RKPF+52+Un/ajCEKoyAZYHn/FMaEcfxAnjL97AOWqT8FTj507oR5toQe1GehZqrDXb2KiOmJBCoCKfUwGiRlfpbz0H1xAQ+gnM1AgLfKo88m67ZPHyAa5SmlNh36Q7FemDhU0M8yJ8SeakU8zgSsCQ2HpjUwaImBh6te055+PjiuICmJH+W05oUSAtrUAqUxbUp+VO1BPHParUs+XPPGpf8Wan2pVPn3jUx+eMrSvyKLaSt1Winvg5ZHkqr/VRvtPQ+dmjZrTbihu171bZoRqUWBG/re9bmyUFenEddQC322LwOBTaRcWOnReyJ2DL3vdLY7L4UWLEQIWyb9rbOw8lJ3x47L2vkT/WoZEwZemZaubS9CH03bgC3Ri2cnB4cnqLv/4HkI0oHh2fPW6oKR6IA+DFj9VUhXljbIFjS5NZ9Wb4UUkC4CNE0ASUh0noMglLDftGLGuCgVLBFPNDixT0dooLzohSpCrt7Q6ljv49DqkSu4FCq2C7lYBXkoG5RpyzSW62mkrk0rlytWISCG7XdUeJa2ywe3GzeEShuC9UTlY1YcVvL8lUcRbMlF3RQ9qaLE3xV48DMGUyKi1lQmhJhGI+MiU2OHkzi92Jr0ja7CY35hXMYiuUi96Ec6kzyXbAkWkM9WKpELlSvD90WAGwFVnlHAcshSrwIMayLG+g15GVySgKR0LPeVesrpbp84P8jUF+7DqNyGNjZIwxcT01RPT6VVP64Q/lDlGMldTwm+ZUoOUho1gAx/9cGL6qPPsk0Jl2NwMq3MnR0oJdlWaHWZgO4U5lwwavi64mSzUldmNmtzhnDLWaPDax0JhsWK7d80FRGQV7RzfNFSmBmq8AWwjHNsEPbDRcKsxa3QZiReZR5fh6M49HxfFLGv9TJEGLSRylFZ8Djv/l2DgZA+bloElha/GjZojALH5RxnVOJTkIIruklohemfgIfi+0j3IIlvjN6iRTLLUQvfICu0AukzOLuvUf7bRQmYJd/t2y7pK6z1tZs2YYeBUu9cMLJUFZjVS7eKoe2jBhd3R2e3sW24AoHptxQx7ml5YGyoIxCU0KVlXq8iUqkzFaIV6/a2Ocfjh1My8+3gw0Kjj4svbGBf+znzyqaMlrx6yoD0O12fWko2pYEgIeX7z4Mft4JjokDc/CmxVPH3TH1x1uI3Q08wC1zhDdIQlULOdzjqoH0gmjetAYHw/OkX7Iq1BDIlqmypCB2TD7ukTew99pXcUhj50qi7qmobbpl069l00nf2NA6QlZU8WgJea3BJawCnCIec3ntZED+Kb9wwhgInnFIfRFuhevlF4CY/Eju5ZIOZx8do7bSBSi4EXRcyHv5AJ1KEu8H7wDkTqJdMM2DqM/iMNLB9Dqyn659lLNJQ9umypzCu1qKDAhJGTA/J15b29IBnW+/gVPPFZx/exPBId9gr4ypedC2AX7HF/y3VeBXgaaduejEkNyMeFYAuI0AwRxX+gSZVFurnCFEJpZ5RZ+fvD7utT/rgCzLk3zgOLzKJnRrg8+wjVanZcxukwAbrQpXq4wtuaMLELYf9RN9IV9slr2j6HmL9My8nlb96bgbgMOyXAtQ0+l8v+RErQ3JlCZy4WU8ifOzX8bmTbpO/4mF8B6O7pLalIaa41t8qjzgFgjME26DYPWIW0AQb7IdCYtPWQMg+cp1AKWXi2sguO/cAsJ9pbUGg7rSrWi4LrqWICzj63aAEj5vZIByeL01QJr3W+5VqQdcx0fxhCtgytzhGhT5MhSNxO4bRhQYzLWOq1hKubc44WOXRqXHXGUvHT0Ym4VMoMquybo5njc3o+FNAmWIUPkJS6PBtRnfXZwmdxbTM7WpvkHYobT5B/k9mNwbVe4lbBx/jeOvcfw1jj8N7cbx59V24/hrHH+N469x/PkD+q04/mQzml+f3Tj+GsffShx/Vub6qI4/GvI8GDlWDGFUdUuuBc1hAQYAxO6wZp3KBymYbldxNCZNURlgLGuuPFCiBTX+x7sp8HTYCkv3Q/V/OIQ8Q9fRNHfbEgq5yLiJ1DVwrLY1mOcJuQk3bXms2f5OV2IvtjYoHTZazFwkD4rO4uc2ZyFH2XQbGtzYeGEfK6F9fbBrLC1lsfDRKH7uN1FfW4djeTcuzCpinvXfRnf96H2c5VmbXo/aJzdptlU/aifU8V7Elh8OJrNBfD3tttn96BrM8zIMXKaZwzwpXxAKVCyKg1To9+Prfs46rOLAyfAH8ZMrmTktHXGkiOQfz9VWa3QVzvnq1DtVTfk1U0q9ZmugijLSDIXbxauOOGhQoBTcZuwQE/SVxx6FFv7PP80mhRwlvz8mo5LBvKfuCmWvYg0CtZnDrdmkaDYpmk2KSsSaTQoJ7WaTwqvtZpOi2aRoNimaTQp/QM0mhVq72aRoNikewSbFA0cn29y10H3uTsOY4FqFDde4zR81tRvfeVmDpOeN79wKofGdNzHmvxtHcuO/re+/7SU2722eNL7bxndbBVnpR+O7bXy3qPHdNr7bxncLn8Z3q6Le+G4b323ju218t8ui+Tvy3TpveiQ+wWUdiyTJL4T1Jo0L1+d6zcdB9N+tJ5c6Gj+uL5fh0HhzG2/uPXpzG09u48mln4e8LoTH1Zv3hjQ+3MaH64as9KPx4TY+XNT4cBsf7m/Wh9t4qxpvVeOtUn5q7F5+HYL/ZQF1LwpY2Gm2oNumOKveXAKwKlfYKmn6m/J0rU2j2z6uUam8CvUMCkMzb6M7kvLy3WA8X1CEYhBYNylu+VhcefRw2FE8vd10ng3Dp67bjmJSpSxWZGD00yO9nHiiMOOF84B7woI3Hh4whmzpUD+JMyBGlMZDMuxVVBeoQGGCBCFaPf+m7HBh8BqfC6ryubj9LU0ep8ZT03hqGk9N46lxN9V4ahpPTeOpaTw1XuAbT81vxFOzbHhT47J5NC6bx5BCh1JtUJI75IGt0MdjgoIF+i6Jh9FkEI8fv/HpFCFBuQiZUJpwRmc/+1fptP9uctnHvB1NM6BHpfX5+xUJNWi0oQyjPP15LbLuec1/g7xPuAiwpfcW3RJMm+mJyffHY4vpr87PorY0SR/fNLWmoxeEL17JneNP3bnC+8xAtUf2LDxBMRnSNEn74+S6HfwyT/AKsAtqjqt8bU/Skr4jH63fU+P/1cK0i2n6Nhmycg3f0Jq36vui6mn11aryQtp8tSZfEWNbidY9au9Wn/19+eH8/W/L+t2cG11L+NnsDg9vv5onF5cbuaQTg9EomfazX8aCC1hw/vFJjx6aWowPF4a7sC+wzBdcYMPPsnFg4IKpYYkafeMeGfGM+mS2OyVnyyxTEKNVgPDjlzVMz+QWM5vYX7mvA40FZ7qaXAWXov/+F2FSjqOpRM1yt3JRbsd55q+Efb04pjZkB9fgXqM46zP1zElIoAIullz+OxqWERw5yCKmj5M7YCrJD5eZTjtiPskQ5dOhC8+tHdvk2sGzCy07vXZq7dl+0DRAUIS5XUFnBbXFhtM85DKuuAGrZXcm/HB68voVWBOsgrAuMBTqqLEpkmUmTjUqTJdUD0uAVysQtsJOgBZGWFNF3zGllwkkc3Uu2cissYmpcanS7Hlx0MSySSMNsTo1uW2mTkT+VJstLh+NrjravefxlDdKh1WO6uiPLskGxrZ6vZfcwTpOdXrcZAiOT0aVbfbTNYu0M1Ciks/Rp7qHUooH3IYkUARXeEUW3JPV11hxJiQDz3ux4tzqa2PF2a04JuIbO66x44q9jpVacto+SmPNrcCac2mbzm1N95amoRApG5rBRltYWDrSHdTtYuX6GQrIEAe7AWaiAHfcM6vdh1UorISnLNt3Vq202LDT9FMCpdFQ7ajem4ZaXFvwMXRUdtRf0VKrz/jfm55q3deAGPys7q4GXlyhL8dJHmVtAUPVbNlDh17Lq6jsT2ZjmTIrXeTcn0Lrkuw/ozosg6xtju+PRljx2D97rim2nGSkGW0ry008Viue5mUUoto0yarWVmjjFkR6PwmIOMqeBqoQkDYe+UOPnXl92hMwn39un96CmaBQKTUYK1FpYRBpEr+PRiVk4o5AOjf5osywlqnGDBkrP7FKNblJsr4c5hGFi9mKiUJ9GGTrTWYhzD/66+IXlh+FofWmJs6DLIuvp0INdMd5x2JyxKP3pcYdaHas3S6Lr9YEJBtKZb23OCulIdKI4ViSi6BQS0ikvhhwhuQVNEooQtVUH3kXSAhlFYj75/ODKId98Adl989qcfk98IdN2Dp34p0C9eSqUlRk+UQTr7M0wsMX1Z/6u/Dk5FT+uaNIAaAOtIdH5300nOcRPaLVDqBo0N1jWIYooHW7e0HBgp1OqWdEWiloE5Rkrw5OdndfHPae/9g/+f6vNm2GU5qHaBTd1VQKr5grMTzuMTWKahNJHkemhZ1csQHVA6CSZIxUPpPHFl73h2mMpUU8wOXa5EkHjIQA7TI7kxTCY3t0ho5fv3ypOqo82MPbabYrMRIeVQU5Py4pAACzSA6/Etaw8wXoLRprOIJhaPVlR1Yf15fxu+g5PU7Fd4QWmZpMlwsvjqaj6P1FYYTx/YNQcSaZmwnSy5dH/3uIWn8KNsA4awf/WJ+sj8B+/FNx5xvbc8BWJBxqxP+nr9rangTjJBAF2htcs9WRd5OPjpGY4JkpSlU2KBtl2iuX+6kOE1jNL0VThLZs2XzXmB9vGt0SyvbiCSbkNLkNQvnRP+HMZ/C6h/Vru0ONHL4lwNb3JthYv8K8v76NbpJ5GlhrEEXe1jh5s74nDXOIaqBCQgkF7G8Jah352IYVE7dRZjgmdStMFFxcevqoIdWBapdYOEkKijaBsyi/Sm4H6UhdXcO1LBqicA2rZ+NQFk+LaiwFWWvtfYhqgI61PH6hFASM7SXhjXU/xao9vX51sN87lLTqs8MeUrRVrDkByFaIJxZQsE9wbAFGrRDxh7qWhW5vojQC7dwd/2rThDKXzRTKNOUjJvZRH3rAKogrpL6VvJpi3n2m2jn4t+hX95lk5jwzVDOuAanLrmBujUih5wIMzk5k0NZRuIrB4mkWpTmwVIKQgHmZvIehRkoUsMooIbwbYfKnMQ2Y7RLLcjq4Q6IGLTTDBB0mo8jGaTKarkTrZeiPonGEJSmCBFgq+pTBSzpgtm8Vj9qJPxuSRRDsu0GKm5slaS4NPrw9ml4l7U4IwIyFwUMOy/Pv7OgVljfxrB9NRzM8EXM89eDnJLsOyRfYXZoOJhH9BdS/TdIR/XUTDUbAeqWyVAbuEHdSCVVAUkTctfBLowJH2F2LlzCq8t65q/ISRlVKCndF+v5jCSGZwljiMNJheRPK9GBveB/ZT4o5LruIcFI4aynGKhFhj2luwRfZkniVRu/iZJ6p61yegIJNtTdsBZC/xC4on0rDm2j4dlu6OUB+xy99zvK0j5lhPBhibkBBGHwehCZ35Wk84e13OipfDkQywLqwoJoKDfMG3/Vjnd0KtztPul0MSltrii4EcJSX/nKDIvQqB8Z6IcDB70pPk27ESXGJrtSLXWyya2kUnykxjYV9BeMLi4y2YnBHkjZ9dP5QBwqr/QPDQ1lmMZFD37iSbh1ppuxwnuXJ5G9Wj9tVPyX7hmlyGU8NJ4LqHS62DUEz5DsWSsMSMDnwoZYrQLrpyAQGBiFTANGvkpeWBx3AtiyhCTbDxEB3pKlGpIrlTGwdkk2weInxsAuslqabAXFhohmQ7o1iBaoOL0A1SW+PsIV8NU5u87tZJG2gxe/S/m08wvKWkbZ9wUtdwKz7iXWS+etgRw2pJU6Bd06BdZgH5IKNx9HoQh0dczBoy0uMAQcApKffbf4LGAr6FrfAaYAHI9B6F9gqexJY8RZyyjrYFw8GCNcNgRR+4LofYG0yrU0ek1WnKnNyjmI3RqnBRLZz7iVR6YvSxpSGvz2ylBouSpSCPu1D4Ru0nfZXJYKiLylrUvs7AzBEWkIAhvXN59tBB336KW+g2+0Sbc3uu9Lr+2ytyQqeVatj7v6zKM+xTqdecr6Io/gWv5lhhZf97cPUFj+IISp+jQfT6/ngOgpTfps+hA/EV/GQeBQcjylExzvagOOlpT0Wv8ee9MFaJrmyQjIrQDSpPg71V384TrJoFOrbv+NBltPpRGZTqJgO3HJQDAfFbpCMsMKjUnzjrZI/vMlklvfBbZuFqmdL9n5JIAgNJYgJ7hbGTSoQvWen4fWHBRVJPDUEIoQZ7l0/TwdT6vUIi6+HBPdLrHa/HceYKurWnrodvutYmWrv0Uh1+dwp2alzzo75DLzRxgTJ2Ld608NmzKozlk2L7i6fQtbXZOhEGTqQ9oJk3IqSdDDtRfmYFqXFKOtSxTazuruOGexTmXWobLJ7gWHdLRUMXoAKYlTJERc4JlUIAPhhLVgIG1oOvsmriTQvtPng2rZUWwn4WMLs4Dx73mIPW29CR3FCcmsd8qakIqGxvSZ5VVKVk9Rem7+1ALAPkQrGXsYbmIUgJQX9wVrIVVbSH7CdmBWFTfCMeQ0onL3tNYCNbQ0X7G7pCBXhRRV6sERX/v2dY3W9W3HGpLzI63PAAvuX1ocuDLFwYV8BL/BUvzDmumPtK13zCvlgXe/W90xJ5Yrr0mi9oJqZCTVTp6+aIb04Y7rEomqjOA0YKqOzOxREJ3UoxxB1dGthFXSzbSyzkzHF89rRri+SFM7etDkoJfiVPbN773kFmS29o2VJZUY9NgIMXrfFIbceWyStSUPMXAYBTVb9yGR0hFErgUX1uIyHNUS3xDwx2E+LXlBoN7yBExivmFUj+h8KaKsgIIeFa0xGX7UL2FVU1mUIAKfyo9g0UiSG/y42QyEUCK9kw2eBHZv98Vhwb1u6eopvu4QkcmOQDm/6fPcgUFxua3SzGD/+05+Mc6VxhuV6WwFAfRkKyCddAlT3Mwq4wYZSfiMwG5Ixf+IIdi0fY0cAPx9fEUyITfELGp72rPBca6/3z56ToEKfi/xMuf+geGpi1cGvZCw6jgljXCcmKRP7Z2cnz7UN3QJnm2/cFuNWLsPJkSe5Y/TojikcLAV1dyPN0jCbZzftAs+QYlC1SPAjH0ss1VWHd+TZqq81yhWExfStmL0LLkfP+XZB5sWmJUvTMxsDFuANVhQCswopE1IpgwpYQu58JGnG9UjajcoJInWaTZVhqb7DS4vjgkPjWIvE5Q8rZGERpSeAN+LJbJyMcJUwCCWs4ewsnDwVR0+pZNrb6jwL5H0sRf4FuwE5e/oIxfXH6/HDC/76uuailzcWZs3xfFJhnler14tdxGE9zqDqpSU7xPVXQWUbzOMUsHoqy2vVWvguTVrvx0GmDUco9vHMcdFjXI3DwpZAV5+Z6LjytmxgRYCLwOlZ9eg6JpSt89YwF2VyaSfGIYqVFBTX4KI9pF8JsVL3jKx7kEm1xEzyS3Gz8NSRj1+VH3vT7SSLRVU9DzUqFOPYZL5pMt80mW/MT5P5xvb57WW+cV2Fxc/vODpdkt+GVXSJS0XF4beXyKMaigNCDqL4qz92VfIIgxdmt7wr4Xb3LnhYarVr6Wp11N/sUstGaTXLq/BD3P+SanHDGDCbZbRZRptltFlGH9cyem9OHViJKxw7v8OVV+Gm386625i4zdrcrM3N2tyszX+YtfkVXtp+V+vzSa9Zo52tMCjNGt2s0ahZo8uaatboZo1e0A39Cna+nyejqBdNZuMB3OC80CYsC0WhG+lwt1A/5wC1mJDZsHi1oigFGaQtu7CFNHKVMvp8zw8QLkcXcQ5Rp0bxYkW0KAAarBSP3mM+4tKCRCqGiuzI1OXMepu41BMfsrXXrGqaSz1bNEpdIqMcOo0FcDzaCKxRScsqWFXX27qGzqZPMYyMMJusLBWxHkj3nQCzhSWYkY/j1+pelER/y8DNmWXyQDSKufIu8YK8uyUfzfWcWhXHb2SIF93dyzHmstIjTsQ+KfggIFXggI0MKUSWU09WjinCchjk+zijo1BYmWbFRQKLUVOaQ0BOBqz6BJNJRkou7cTSJbv+9GPTLWbq/PfjZPhWPWfHKVgWOKZc5/R5gLkjKGKuZKrUs0Q/IXX4QUTFDim7KIHXJKfIWIH1PeXUO+RMMdJ4fyJ1KnP2SqAg8Zm9lY6ECWo/YZlf+KhDOLP6jKaB+UTUwO3PkuKm4IKiUkgwrfGJyRD02QeGgLnYVwahie4dDybRfa9YFzRYtnLZup9VyRVo68yUTktxfcFH9LN0IFF6VHWI9d6cNRdDggBeBiidL8RKcaETukqor8DPsjDNeS/86J7Z6V4i1Bakvx5EW3FRrM/aIw8QWcvFAHZ3+Vd9EXrqeS4uEBCk+/dtJ5nv+0St18lZ8DotlCQG7jkTx2IeXYoYvYv208DVp9qloz/SDS4QPF19et16ymeBe1psg+pxxgq6nS2Y+sc2pjWPTIh6lHYrOiUnnxZa8jQx95YRMxXyPpo3HeqtKQ88+88Yuey0oIUWvFHLaSgLXUxsaYYXDwrZ7idipNHOVNlIVNaw5XENkrlpwlrglLF54hy+12IYNF/FcMS9FfYDl8ORceTShm/5rWx0IkgtB4QV4QREgLp7pDdYEZZYFiMawAvxq+L0Jp21JZKQSwVyKgzbIjWFw8HRWe/oGH+5mkMGNLjPC5ELs0whSR9DdkS6CyVquPeh/OSLdrveCo7+e2ZQAsJRff1Br0UQV2Pb1iH9SoQqWrbdpKNbTIrWbbkoDBd5mVwn89y+ntJOZJRY9ALd4mRvcPLixcuj48PAWOB0Mms1ay7ZGb24d8XrtjjSVL1wy8SlVxlSlJzddhBsjVbz7b5xv8MFrX9BjnrJRzX9qEBrhwY1XPfHFV2giVIeicJFHvoPXC0KUxL1af/7eUxusH9WF+0sT/MkF5ltOj4kL4+xNiWTx/1N1FK5kBSneIpXHnKR1nzSp9lmrefeVauofGQqPcT+N6uu4vKQbPAuchMyLLapyU5TzasQDzBlMb/4EPSCtXixUpKqSXL1vmjZco3XFsXKjBeghdVwAfKshloG3dtx0PDo+OzwFDJq907cNGwL8oWcjTvo5/2Xrw/PUPtZ+KxjVVwZhZ7Q9l301XnAsNs92I9/PqyWeZkQ4HkK7lcYJKyVP4AwKCdouEZ3nd27H3VEgpusDyES1J5oAkF7WSYOlKJEGNSUAeRiDqjStcdr8U9JpjRBem9RYqP9/YqSRypBKKOfwjVmKzVvqgUNy2EPd2aG7HuRJ0C3dlY5D2rq87w5qs9LWD/pgiVb7Z6R/XYWMCFSnwERjOAbx134JSyzYnahMZFYPF7Cnd8v4+nbrLg/FIi+4HLDVliYkARyf4xBl/GAAts6/JbLlapH22ocY5Rt6FVZczKVxCWgFLNQjyJb1MKzIlaSks5OLo5MqBPOxQD7uHQvOZOiuTJBdKkr32WYk+HqXWwmpbke9iJH6+IeTrLWm/MWpl2/iOmCyDiaU4BBJ7uz1qhYfXZ7SJ7xOLnt0xvtpTZ9uK4W5/lzn1yDbS9heWBHE0IGbU5gD5q6wwntO1CEE1yZ+fzac61mS0sun/Y99zKBsQU/0wXRMl8XnamuYbzHuZq51/ZwDdwNeFpOZvgrLDUrWOwFSHsV8dpcw8Wrbnc6H49LFu1aJC9WV7JGh0haW7tbJXoFx8tbt7CgKjFpjfm0+IRYmDTPVLqYDOlJF42j7JfCPjShXHODZKHZH42SqTzTycwYwNOF7WZGyvG78cVvQ4fFmFqPSbiHxLUUePt2qYVF6UyxuDBNXprQiw+GfiuxL/Wk4bQZXW5jlB0n0dwPnfIjJW6aybRbhe2n/awbg4aJcg/Mv7rh9R5TVaX0HjSfUJsa8lV2LFh6L7sURI9Vp8LTGvqlmwTurjkFIVaakndRCTMs7t56ID4wNSDXri9sbhov+CXoxQvpxvf/lsRODeb5TRFZRDfDBTSHPuXOcczfaoHOIrcxufNdzmSsmrY1onokpy1JINwSbevX6ttvcSRTSi3Ho73o/KO3T7+N7jKWuVQPm6PFn3SVyx5NN6XUfZa98nwLq/f8KTb6KvUKSD/LbNB41O4AoFar4xL7bnOVfyxnwmzWKJLxJXElFliy6RKlk5i0rdUt1ugqEMXmvQLA2NN3VBfhGVp96Xk5gJvBdDSmtUU4tg1KBz2zg98I4PpgG+YbQSdAu9ZOWcORCqSyCDK+EaTAADB0WVLcGrNgGdQQBSfHSvyC/GFCY+vp5iY6m5Nh26ilyW5Dzb+nyfRa5GXQAcjol9jEOwDpOEHZfHgDqj3MNgmU7ZSVtFpYlAUm6PZfHUmyTszOPhZNyxxVW6lQEqXuWSRBpxcXSyWOMdGB34VYMSegXlhxiwMbhloXazrBKSCaNWC77PSqe/7IIHY6T5E5m9x6VZ2As7KUMjNsmSc0pKaXaHf1rcBVUy9PTMEu3dZ2y+mwKskU47/hu7r8MKsailHER+KRDMHWb34IrIq40AXqqeiuYRum0SCPjqNbTUcv2imWsHCNhKuuRmkvIl2tdcRrl6ZvqSPr/aIKjbC1lqe98eY2fV88Q21BLkGiggPDgoK0IdmSDbdC057VT2wWo6GaNcrgiE7U8kE4Lsa3KRkiOM/H3iQjZtUwXM438yCEqEG+iFvvDXcgef3EuAOEMX0reh9neUvzW1h0FedhV5vzju2vKbSF7M5HU/wiPxpZlRS+CaNcYSM2wdyLL0faCXERwVJbrI8jLtZXfQDTGe3j3lIskdwPcVRMEs7GQ6KkwjEFUzJDNmzrC3ZYwnwO2cZpP43RqrybC9c9jWZJml8l6eF7+EJ5LZRQDAVOIv1MKLfKg7dg8y1cEwFAV/E4x4CQeIKK1FP0HUlhDtfswEHl4QBDjq+n+OvgOiKTWkQtSTyUp3fFD3OGqjdNHU3Z+RZxDjKkA0KPM7tub7a5tS2KLAr2X/d+7L/YP3pp2dTZ3JRIaGf74r0+sXFlTnPHcsTeOk5F3dlrsZdmpWIwHRWLAkZldgURHVJkpMei3fkhyhEL+kPJFcpvIvRc4ediCDmW3e66foWPTcp6H1/zuv3NdBpLfTSzhzlMZf7RLryiUXzOW5ocLjSfm9oY6erc1lbSIoO27K1tFS0ofbun29tIG7VvcIPPqm5x8yCCgeSit7nBp+SeLvgscqubZxeWvt3Nsx3WDdbMEhe9wce47I1DrXHfG3z873zTWrU1WJcGi1z/RtCodwUcfCrYayW3xMHH41o4+JReDcfhLMQo2rK2gfmjZWWQjaCFNYGF9qatbdRpwrZ3oi/H2fwyy9O2+jxEWyFa3/F1BK54kS25YtVxHLpZf5v1t1l/yz/N+tusv836q35+a+uvTkbZUQJhP9y81kksFXvCw/uVZ1tWD6UFOgkeItv2yTwdksTUG3K5Sow1/08Z1lpRgjlkzebPzQsw4WPriKNR0pn2QTwYg6Orl9AkyC3ItK3VwEOMTk6RR7GOwQkmDVJcI0+kNdXWfV9lwR6Ds4xy4FJ0GPEM7FWNwHGS06EZOMUCWwatbbrXw1/LpLNYAe0dIbfbiEdLKE0aXCI34Hof8ZjrCqWyCT4G65S1U8gS9UW4FZqipBwQnRnSxKCZxrWCECXkAFt9ubc5K6L3eTrAU7NKHPBpb5voOaxIAAA8kpkNO1wkxZyKJ2w0Jk3RHlqLjuYpWY6KwpwkB+yNMdddFpJATJwbq4fhizSZeOKo42eTD6jNAsb6Pxz2zlvEo+62FJShIazx02AUvc7AaQ/3DQ3meTLClMGLoYf0ky4QLxH+RSlzW85GYBMqCXMVx4suyBVblo1eUa8Dt21VYQ+u6mmUguP9LJlEiIqSzO0w1xzfcrHsNoYNTMV7bnT0E/n3cJBFKBhMs9sojUbBrvb6V35RagUiNAKY8zINwMP0ARsbduhGhAwqpEssOuH8pfLwgxU9CIBaPXLTZJ32uwZyVvQu59ndqpEDmMviFaVpkq4asatBPK41nlbU3iXxkMQGrBo9AbgWhkj7ECS/2Np1vPnyK9ebr511/uJ8s73jfvVn56udL52vvthyv3Ij+KUbjS/daHzlRuNrNxq4y2V9Luu07Z1LvSzjHG2Zu0B7YHdINRx6CGci/bmbjwIMM1gaa5deVIJPKXqP0h5g8UkpnHN1OAbZGdgabkFY+2XAT6xGXgVqNkDn228cJ7i1WsrG+7fFTWEqtK1Sv2oFbvyjhgCUNLW4V9Glkcof0mkRMrB3v12WAhfup8Ors0iIWlzpqChOX5DyLHaEWyvWoy8M8ohcqyqZ0MN5lieTQxaM5BG1T+6+OzlFcgTkM/Ty6KejHtq275UoTRuRT+Qtj7Gx3rhq4q5BdIfl2S0RhXocTMd5ZGiNdTNP44lWST324hQwwvihEYblEMtPvsAHJhiDAaY+MZSdQJjN7JKoFoajGQWxmIiH8WwwzTPmfjr/VwC+SAx1I/iTaXfBp/xyXMDbzr2rZN541HCv3H6lM1VjHdehk2qNoWBz2bVsR42oMe6bsi2cUxJs5XECiflDCDuYcC4UF8gF8T5pvQjQhqV94aewvdTdcn5+4g0yShYcD/Aa9pxEvGMMvz/s/f3w8Bi1gg1Y29rBP9Yn6yP04268mwVysCQ4GewAHVXFsrxBnIimuokRxM9V9wd9prnvNwzxYp0gnBPKT3vBx1ww89t4HMuOxNd5PN7dhaEEvNXXbXNSyROKB3w6GNYaVliKnXD/0h6Cu/dtdEeuAYcnXmo0KXneoj7D+plOUXEsrk9iyrM2xmoyYLfn6OA7oU7SRTKgwlTsc2p24epbkOwa4PNSPFzbrA5dq2JbTUXIaitZ7TNJpAnmIFtZ/BdJ5BIQe4HscZm8RFY3qbiGTJnWYe4FsulY0Ml3I1C/pb7unmBVdTnTU6sFqZ5aYavIYcVlKIH0ySeffHSx3Uhmm2RWEbGc2jQFtHI763AAmkz0fhjNSDw/Xh0rD6LJ8etbltQHj/Aogzixdh3T4IHildyp/5adTFGOOix7wqHAxDztIMkeONYgHWXAZdMRHvzLO7LPVLAwzFv6itzSCS8Pz57DsvMJ8b7m6R35+0ka/TKP06ifTPG8b70SWGzMbmYt661S930agofD6VsozckHUWYRjQmPdXNioonYtH6aiE0bkk3EZtWnidhsIjbh00RsVsBsTkw062/Jp1l/bUg262/Vp1l/m/UXPs36WwFz2RMTTfQp+zTRp030aYFXE33aRJ/qr5roUzvnPJHlgVqCn7v4wwWoLnmu7/dyhs/obBO1a/k0Ubvk00TtVr5yHoBsDqMWjbheETo1h1FXGvqtC/gm+LsJ/m6Cv5vg78cV/L1G7jnu80NzGPaWGQ5Db0bWXzzuuHHaHEtpRJcDe5yhsTxYIwiNObfBLb6lQghXGjFo577NzYpA7XKGrR3w6jAZrTrB7U08jhD1LBr4teslhfMLuC6BwXt+T4HXFS3D5z4DsOFTolVXb+L4BGOzRipX1AcPyiYdoJTihWnWFKV+mbJJpODnn5cVWSrwuyCzLpD1J5+jdoyXLQZY9yc5t+1KIvCdVNvcxP+ZT7MoZ2chzuEghFPFqVafLXRadptmqZh2GZIs9XiELdXSlYckI6+V0QCAFJsLF6zE+R24AiOXKFrLkpRE9WL95uDwFH3/D/T85Pj5fq8N17hA9RDBNwKkAyK/QMIyCO5ZbGlIALu8o6uJE/SH2uH/f8DVlz4DMrO3Iqya+BhexpM4P/uFhd6brk5O2i6LdLEwDEm+BLEFeAAgFbM2SvbBlyu51n+1lhLgL6qHVAKGmjRSO8NOEhwufJKAVJD65UyNiSnKPTb3E48vHbzQY/Er8woY/WzC7X9r4fb3GDZPkqr7D5lL636I4HuJWrUDAOFTLwiwpLecbgsHPq0mpgU+HprysrEt8HGoa0spTwRuyX5BzRTXTcSq+WkiVpuI1SZi1ehGE7HaRKw2Eav37QppIlbZp4lYbSJWC7yaiNUmYlV/1USsekes/qGjVZvAzIX8NE1gZhOY6X5cGZTy20tWs2gUYBP3t+rIKd/RXVUAVXkyEv/0GXVTZ2hoeG/NqmlF5D1a2Gi27tI+4F4rJ4L3rqs+3pZb7xYPcasXn2SbyTWjOSojORxxKJZTJw0/8EgBEfFwsN87bEtodxBckFa5WS/TdXNzFBui1zfa4ZHGLNToPNsheqj+yxrh5vbW1langgyFNlUUL6OGq+ePMERDrfeYgzRsNz4W23fGK2aZFM9Zk3AN438n8ftIvNIvY3SFR2BooYBrRmh4RRxATamPBJq9Am9HLu0tfUlljk+hvNFtTvhGub1695PwgGWNkooQNz0u1bGNMHkjFTZZ1bI7XDrkdO5bh9U9oHTv8EUaRW1171UeP/rCPhqs0kKDYe46U2iY5sy7r5Kcqw1sk678llUaJ4ILql53+3TTt45txiQrqu0F1b9+1Wtc9EAVY1Bw98A7ncs+h1mUgsua6DId3RRjzTqKo70u2sa2CvQO7drpodOOzlFk5Qv20ggFcvOGWOQumIk8fje+ME2tC2w4XPC5GpQ1YE5MO0FoOWwriGaryaENuhi4jPqEDsETLCQVVhYmxIgyZ1aWTzRizNIIcw1eZ1+/AvWJ9f3ssIcIkO4zRgdMhu6zQO1VsX/NGtwr4XzStmFw0ornW29CIWftkbtqQ2gPbVtNRBbMLMBaTdhaVCAK6jTJ46t4SBNPUeAWylgb0rscT2ZjrJ61gxAiDVl/pOVs0ZMzH7VTcGuxRwdsYs4KD3SrMo54kN7W6mlZJKs5RetNTSaoCNKmhLLNTPtks9MTBBI0TKsY7puT7/9qzHqogqEDPlZlA0kFFtY5DArCMB5Lo0hImi1JUxdvPCY6u3Aspb2r0vLjwRYdeSjOojyPp9fSEqS0XHdwjCmsQIMTDKXrkn1UNIzMaezkvLKeLsR1RndWxW0FryW3dXhNsE5yu75nYOdjDZQYgAsYCoPRiFoKvcRm/DGQ4Vo8zcduAxAXrWUD1rQ7RHH5SBIdlFa7FaIWgv904D/rLbzEt1rikJIpGQwtVfDM0fHZ4WkPHR33TmQLpn1R9OIiRBcUMHxTQqsuOujn/ZevD89Q+1mI/9cJdKOF660aWznJbfrmSy0V+NiUFpcl9OC8NoogdIcbpsmkhOE+GquVMsgBFipYWpabuM90P8MzX0bggy/1RPeM2xngo7gY5NG8XxdDTfrXI/eDkXiGaenyzpXT+BUu0eb1H5DE0GKxSvoTlmP6UJRd0CVasiSCLuJYECudoXUFFAO4nEvUuoYpLlFpbfJemYSO+REk0ooHlc4kGFfnyvPIR1aemSXO7sWXn8c22gxG6cYFZJGiVY8HE3UkVjaM1V5vsRZBYIi0OsWRbGS0pAa8txxMy8HEG2qft2QkiuC08lUfF60rGsXUIZc51bHJkD+55BKYgRVnsGabsQ01QC0bD7KbKGuzy6E68D/3LoNis5FNBqRPFFKw292il2vQH0Gg+9/rGhXQzbbcQ8lw6Bi+MfeElXrMbtYqOahsOejicnCWHF6s8DB6WhoyO32Pbbm34zjLnQzFoq1sug1UUDnjptwdcAFV2N7DJW9ZbECQl12kCkwAaqqOhNymkDhmuJI6jruBYEDJ+zS5fU44sdM14+v8mUrqR5t2YUF+4kxUl4e8OWgVLEPXcYlrsGS1MA2jnsdSarIB2YfSmIDC2yn3ohXTGzxpFwIy+A2wEGHg1cfeqzP0k17bw3Cxl3io9RriQDKLbgZH06JpnhkvrFulBPOSxeY4yfkNBBnVTCj00LF3qgUXcK8iUQ1IjYX0aNL+FKOCZxiJ8MeoAGbPOTavyRUSqvfnqbf7x9W7TskWXz6ZlSkkmBVCBOFB+6NRNCpii1gvCp3k5f5Zr0/72j86aJviQrQ0mdkiISTekdOk4tIsEJR9F7i02P6jZUenlDPlsJlZGk/zfipRFM4lHU2vknYnBARMR3MtHgYiuewO/SFoS2gtzvoD2NOvx+DMg6LxOGs9ZFewcNDKIQI1XOCJKOTmGP2uDCnWR8wV9iS5AiYvUOpwflQh2rZGmb8iTYY+HhwbQ1Lzhc0yx8YoCb8RLdm2HygBRQdcQf8G59pacx9mtUV0bVvTkVVSzgLKdkxVAarLhPsn/koIX0n0Up3CTWwffzbr2qI2Jp8ZDIxb75BXIBKJTIPji5ryOkQiSYsq8qWE/dEll3LSzYSqTUMw++XWxz7ld8OWhGeRZh3WqWjLcf9HEaVCguNsWi3BazWoBhvKBXWfByFEDBjEgrjVklgi0rptZbMHRhUVidG99UZlQNNa5/hIpv8bfXGycpp8KVdNjpOrrozzwG3W8J437zFy/Qa4r6Y7rtrJanGurs4Z16dt9OkOPvKx8CzOUqd7VMDn194stBNVDZ6j4w1edSW6oF71J1M/okBRzBrxbFz0VUceGb4QqaE09W4oJadi0uQynvq0kUV5H8LS+sNxTG8HLLO5SRlqcStQSWAbEndgFhctwYs6XZ0N6RN/RiiOhlS3g+WWxtQl8QHEAaDJBI1hF6w95Bd7LVYb+G7xumlat67GIos2PTN1WKVmZXS5HoixuINLkcKjCPPXMIaDPaZxat+pLzU0mRaa9ZKRtPFtyuSSjWT5mih9gQYVYhrdEodDD85CBz/Fo2l8fZPrYVX2DE78tecVAaZlu+jVADYTduVXAvhfB2BBxwag+hoAdj4l4iodlpZBB33rOq1edSbeOsYqBEu/4VN1dN+O6N5HQNR8bLtl6mEyIC2U/ehX111gq8h6VDKEK8p25M46tYosRyvOcOTO86J0Y+0mmaf2TB14UNprMTkojfDfb7to5wv49vnnJU5fAo7cktiCxa9ld6EWSSpcdo50btQ8dkrJIR3UMmlScvoUwPVfHx/9f72jnw6Bnsrsbr1uYYuInl49Pvm75m5mjMpOiVPOhG9lbnA8wfvJVZ8dK1fnPbvWv0DTlM+EpLhiW4FU4PvvVmfd8OiB0KJDQf68gQvq6YB00K9Ie4W2n7rvd5WL2k6iW7mK23aksmzMkRwD5qKP+6IG6YlgXlrhV/6F9e0Jfa08JtgK7UDWBZ7KxT7AD/lB+R6L++wzY0KqKqsg/QL6ivJGP1TbWHInmGHbUs/YEFpBcd1OI4Qycg+i3/0jyrCEl3S8sEgthdSz1veq9qH1bYSxwKO3uXnHcULbO/s/Ndpgow022mCjDf4RtUH9fiNF1Ak53WUCwVB14FJgqErWSR0P/DrF/Na/iqMxaYD2Qy5m3TMUUNXLa7zAg4vbfjPXfd3UZKcrTPN+NB1pU73/1Y7miDBqrO9lUQ5ls3wwmbWl55LCuv7F11tbSvXfilrPRpeqVMoQKup9cTPQvSj61pIGlWFuqfKvMQeWMwcIDXUN8WjK1BXlghcpzU9xu2EoX1gNLB3qyWJa+BectBvFWR7jhrr8Vhst8xRiyX50VTQU8VrkdZ3cQGomoGEyvYqvRRYgXuh6nFwOxmgNGO+fJ8eHlr1Lz+0nQ1l2przxS3cjpbqBTSI124191+/+8tMskubDP8WHNUyoOrVHzbQebmV52XQeZcrOPafxqJ/CY1XpO0o6bSC2aNqOkgtQF0nXUYHy0mk6KuAztJdPz7GK1Bz+aTmWTsmxXDqOmqk47uPOXN6JirQbpSk3Fhr45VNtlCSptMH2Ba0RaOHUGlaD48FSWhmHrKS+NEtds9R5dNpArFnqJLSbpa5Z6pqlTsCRTMTy7FFlmaP01XL1GaPKXZIyjvfukCTFuO/A7lpUi7JLeIuiesr2B3F3eqBv66eBvI74x3ajWtKFl7EFK0bSRcCpRJ1d3EztaIgg3pZ88C+P/vcQtf4UGJnM4ebqk1PkUazj7m9lljSPvDjl2dF+lRJDlWRF+1XOKrWabGhGXqoPBiqWDGhLIOLKfGZDxEDFyHa2BCKWLGdeOJiZzZZAwprRzAsNexazJVBxZS+zY4Okjz1jmT1bmT1TmT1LmSNDmSM7mSMzmSMrmSMjmSMbmSMTmSMLmSMDmSv7mCvzWM2sY0tmHNOWHa+kY94Jx+omG6uRaMwjydiHJpTko4SSrCK3WJXNvYKcYi4jqToEZfk8YlXdWzp/2FIW4KMJW6lQGyVq2rvbhLJ8rFAWME7yNJ4YaWm6ZLfWHDJz1xQvVXDW02mNuDLWgcziaeq0MVXqWDOVsQR0UjPV2ebMTHPAt08E4xp3tH6knHNL5ZtbWa65mnnm+OVOlJm0RHKi367lT1jI9OKicmicqnZg5LgtrQ/znMwYJwA2eWxrvIWdCCfO8IIWD+PZAM4qUov1/F8BuKkwxI3gT60y15R2P4qdIx8dQy7NlCtlTM4xdZMg3kP2Q0OUci5WZKku3Hj4l7kzYjsqTnRX7pyyT73KeLLPLFFkF4przJqbrCyizOb72TBmDQs8k+PZPnJ2N8EGJXey8KFYhNQHR2e9o2O4oE7zKF40Y2AdA8fkoF/sZzqEYLDOw7X8Nh7HsiL1Oo/Hu7tAZ8BPfa1d6bfWN2dn8Vboqd5xjNPots/yCkDJp8bclpJcwiUnvjm0ERW8/bfRXT96D3feteU7P3SwkCxH7XeN3NrQWrEmlajZMCf6PPav28YaMFTQGj534cnu2XBtFZZvDy7ZNqGRR6rbckQ0JCzJjkkpxhPnwXNWMnjDJYqobAon56YCr9Khd5uK0EvQ4IklRpJAi+WyKA6qhlRcw8C6PUFnB908Z91wTUORy4xUYaUqw1npNZpNTGsT06p1qQn0qe31aAJ9mkAfFe0m0KcJ9GkCfRicJqa1WeqapQ41S53j0yx17k+z1Cmfx77UNTGt+kr7sWNa4bO5yXooQrvI1oQaC0TCPovYL+KMbYJjm+DYRxUcK/fbjI+V3y4ZGKcHyuqwbNFmH2z4FUGzK8VOjZ71xM6GH4+kXSl2IqR2CcREeO1KMZPibL1xawJulcd/3IDbJbnvHoNt/QNt/fuwgNhrAmybANv69n8TYNsE2GrAbY8JnZoAW6e4/cjhr0VzTfBrE/zaBL82wa+/3eBXC115Jig+7EyQN6GWeqilNpaO8FadnCKatW2Es3ZCN7EbatvjWovgNGNjmZK+JKg1yQdjEZy6pS7+y0S8+kQS8kBCQ75A5e/irJ9c/jsa5m2ll1YXrtoNpbycRtuPW02aSLST6+po397EmFcpuiYaLIebO9Ye83wXWUJJuVPcuc4bMbsM3DLRuZ6Rr6ylGjGung1aHRJWTZ7EESuVSdRpwXXOBotxNi5TtXSg6n5VCRwDRorRr67A1Bck90JbJWtJcKrHZf1qYOpTGdHFwkcbJ0/j5HHBaJw8rkeNk0cFbntM6NQ4ebwTAvAXjzFS4fcYdmDp0COINSizXld3aLOl6iStUsvqoUwm3bCv2/mlj1E+WqqsyGwrP6hY7xhlUe+PecBx7WOfG1z0yKD7tKBSeyWn9uhXW4pxSqTica08tnj+/yMaaBntpCN41XZUkehOZ00C0XqAzpUMzSKqBJSgiNtU59okmeY3fSwS8mI6Bn8dTIPuHv2xHW51wuBFdCme7MATtaHgp0Eq3n9BauzPiidfWmvcifdfkRp/nRetfm2p8df5WLz/hrYxvxZP/mypcRbNxPu/kBonw7zo2ZalynHyrihA+34QDYtH0HlNXJFEMppBaGZWamxW8+OwWUvU+NubiBxi3XNp6HRzxgJ2xwfst2Vgl0HLziTGyo0nKYDCazoYJ5oRqYUb889jtgprLGPlTh/505iKKzcVCUgbixqbG0ah36rh+bvNQ1dtniydoM1ggmUVceZA4zbINAglXxrVWNWMaUbwBHHN32FlrAAjAwmmyW1g1OKx4cTGqVxASfxj0dBGsL5tu3KUoCOpVedEnXqDFyGr/x8+rntGzRZ3/FoEdW1FLX7h1yIogCtq8Uu/FkHBXFGLX/n28W5VLX7tyTnzlXHON74tjlfV4p89xxEr8Stq8S9+LYJZsKIWt7f8mgS7Y1VNekodsGRW1aSn2AFLqXaT9iArbstL8GWDHr6s2px/Ocjys+hdNF3Cnl/28pyP7Q/Y3CTwz2aDKV9IW8Qn2JIW09b6N5BXHa/s10lLWVTxSnqnOxO2sfG8hfXkHfJXM7e/YC+/tL38ir382vbyG/ZyC/7+US3yxib/o9vkH8Uqd3IOwmsGiyu1Nw7BWVLIlaOQgy0aw78x/BvD/xEb/u6dOz1sU5YUpKwuGdhDiVi1vQpYl4ED1zw6R0nDbvoP/qMV+SfZLeMqmlHeBtQrtztNUJ9FOVT5D2kk/48LvJrOnu7OGkH+C3gxpM1e2UvSUvQ6l8ovdLzz1jctem2P8uTz7UUMDhdKX9dE6WsDpa9XjdJXNVH6ykDpq1Wj9GVNlL40UPpy1Sh9UROlLwyUvlg1Sjs1UdoxUNpZNUrbNVHaNlDaXjVKeK0Z3Plhs2Vgs1UTm6p4ZwHa3M4XBjwWpuLaHnbRRxaPQnrAAc43hGv53cy++07emAbOWpZPtKMOszSaDVJMsdevDvZ7h4guQ2eHPeXSoN3ZkAf2kIC0eISfYWyqgoqq21M1k8Uahg5DS/opsADXxna0RLGA1MWPODk7uuLCRki7cMvsGisnx4l/MD0woieZdoEyjA8mzLY5emU0U8PQOEDp0mVGqqIpTK0hXFlM7lCARi8waEyWPnxXiOigINQmBJOwDwQA/ILwoAKoOFFDQdoCnU6+/6s2gk/WjGtsHHQuHZA15TYIfUhGEVxUI0+roltr8eh9veE4wMOBWXixwcCt4d/4v56sbBmIgFTHzwDze2TkwWjkIBkc1QzXRsOFOfro+OzwtIeNu96JjYRtmXrhBTSH/yTpKEovQsbQHfTz/svXh2eoTWgU7hKkdkmhcJew5zIkBmjwkEANKFj4DZ0OdtVZ8DCy5HgAWjke83A5MULJWcW+gk8lGdLdNcSHm6oFj4Z+9JLFhi4z1vcAaR9qChPcesH9iyS9HeChHHFflIWCVJL4BASz0MQrCpR5F55qsaWqgHIEgEpy0cRbgo9tOBEOCc4Eq/hdBGs27EqwJTabi9aMkFmscA2QuB7XaR0Xqk8+cPYQS5q+0ssCj5Cs2VFKv0uFPLpvFTfW7rfVw2RFk/BLLVrInWch/l8nMLwBgiTa4XSfTsHcsM+OolvjQZYfTbMozY9GGrXptPARM9YVUh0ErCapNHblQDByH5QOhrx8lvFiPOo+8ycu0+nKJHEtMrkINbyJhm+J1sqxdg3s9kNM0OJ3Cw2mI6RwLhrHbyNw9HPXrIRcuBV+04F7Ihac14VjHiqYfnjLvOeU192Vj44wX9oIU00cXsph+pnyb3Pz7C7Lowl6wbgr05mNXKjxN3osPftlbNui1aXDL0Vp52xXJUgpOEPYOKaFcvWHL65cJlixlXfEf4jwggwZUoCMl2Dvv8OrNzScJ/A1vrpD8xn4ADZ4HVGXb5vH05w/s2yaHzDAP1O4FsWAb3Rj9mONS2OeTbJ4qnDBGsew66gi7+a3i32znwdpOxhd9lmFoBNySG7qXw9exGn0Y5y3BYtO5+Mx6qj+AcRfmze64IbPyIELXLV1k+ezbHdzM8vGG9dJcj2O1gfTwfguj4fZBlYZN4cJni7DvKU7egsoGxjMs9ngbpwMyKmbwaflhaHJ/uU8Ho/6jIGJWNHr6KJiOE/HP9DBa8sQzalrtRMZNbUyxkq5uanxejp+lWS01TX8I6RkJVSlZQmyZO8B9MgW9L14UdxID2MBrv+30R3q7mGWGYznkQZGBoUJRcpuoFa3hf+L246mQ2Kesar4zadqax/kHym9yYiCC6FshxRW8J7hvmGsoZv9eBrTSyDUMuRdFuXJDC8AUD5Ez1+fvjx51evjP5CvKR13nnrWeHVy1guRvJrUqvri6PDlwVnIieRd9/Sw9/r0uHe6f3z24vA0xNaUSQrBbwQOqBwUiqWR4TjJIvmtQned++grmxwtGJoQ0bRPoIgxPJb+ih0pwqH0hzon7JQATtwO7SXxH8KoANJRAmva+z8cHvegXGv/ea/lKAibUSevSbGvihKGS2mmEn/IGMtGev7OanvNKpeXAXo3SGOyh3iVJhNlubGsKixGC09HY6WZxO+jUclaAyIeKi5mvpOZzux3PMygNnCjHcMkjj7818fJB8XIcAIu1b48T0fer1bBq3vybBvX6ixZ3yM9NUW1OWuygqYhk4S1SHt6+Orl/vNDaiAymrYJNUNGbm71tYFo4S5t46mnKwTo3N0j2AW0KvykMFbrPLJadYLdFvBv2hnsmVfHKVvdZ//I4d/s73GOF9ObAdalB8O3IZysjEZjGwvg1fI6v6GXW4xJaCQtaWplbW4ZFGAhryEF0CEpHbXKJnbRdLRa3OhhZwTDxkp/hta3n2I7YhpdD/L4XeTTDwrFsw9EpcLFI2zmDo9GBd6qsChsIg8zjhjP8bu0fxuPMHw1N9MR8THgpugth+Rna0s9xm43w9oqT2Jll1/NR5Uzd2wFoxWFe966PRopN+6ViKpWyyqedBL+nXS0vYYhhzAr8FTLMgsPvJ1BOGtbFIF4mWCdpDvgfRG1O+gZCohpK0pjs5d/b+F3u2o80orG6ZYOCfSlBeGEGGd2ah9bsrMkHZBr67bqDphmJ6vU5p/Nz9YoLmyQCMisP32fm6Mmf0StmV5r5lPrapzcgudarVo8raoPiXLgwjwThvrGE44VRHXtqd73qU/fYTzUavRJRTXBh0rV4ulT0Iuc8+WnaDo/wuyUYX1aFjqimSV5WJ5frXXqIKKiBtpTWVfg4uEU43xuXqnJbD6wwAuAxPabvMW6wORdx7xNiIoj/E4m3Bss/vGjUgPW4WySNxSgaBpH78BYLi5ruUzeo8s7FL3HHGUZFVwEl8C2Jq/QJyU11Dc3J4O3EcrmaYTi6WwOqjX+OrpE2eBKWqF0MHbfst5WtaOZ8UEWgYsC8wFR5gUY6OLtTYQReje5pDDBt4JFp9aSn2NUdfnwBswcfrXWIwmOPb8dL3DeoqiyuBVYvJReGdO7qDjCBNbrwbM0JhpfSc3ZIMvA56DXLp6XMycDVOJjH4xGP2FmH1yb489yS5Oo8RDGYpikI7ielLphRLiM/IqnkND4dGH+EwAEJvaq4rVmWkko2ysqRVQu3NxEr6IUQihh5p797SUi7C7B5xfHZrM0nuZX7SAm3ltwfyZoQsmaoTb71r9Kp32FZ8JAHfgNFPCy5ELFomIyET8G81GckDEQr8eD65DF7oSnvEM8/VTHbAQRewhj1vpT1gq1/2wV3zuQ8tvgCulwD73wpxWS+K9OR+EYw50os48UbGVhHlUYVF8aS3bLqhzp8ryIR7rIFhOCurbZnHiBKdtem2TXdAoAobtbncVEMIVi50L6TukStGUvDG+W5lTazYJJsVmPZH7q/mnEZDd/Go/ws0AfVsJ7yNaB8mGzmj+M6pkpihTSP+D691DDoa6gYlTUEeDjAiqUW3IYUqYLUxmRqBrQOGQJEzCm1kf10WgC3nuka4JmFSohgWdog0rvOajzN12iERYzoHK9ZTU9mFxM+l/vTZbcP0cymaC06cUohTCoHGvHQFvHGXyjsuLnHFu467+Fh5eqVI4BVivAfDGr0KfOSkA8sxJ96qyEF0izjlj2PXmwjAVpRFYvgbNfarRhMoumxTXPxNmvptQ1LCevg8vwsV7dbJ5EXMmBGv/DM2bzEMSO2J284+Q2Stv6aZoD80IQWu2gxuEb2EIBZJBy/a+lJuhYQceKq7cgJtrWTTJP+QS+wNheEN8SDdpHZFGRk7ZLbBFYG/eZrPApN8cYTyH9QziR0UcmkKDzRgu1NtgcIVwL7x0JzSkj+0KjXF8CbnMzGt4kqNXtsjFs6ZdgwrrK3nXQBi7Ie2MtyV/SogLX1gaygeWvO8iCGxyQY93IyJW2LXBi4HHebnWEhJCntRUGrJOcPfe60lh8+qlCzL2imOPULG9SkiuWFt0Hsj1R3pQ/6usP1cBV5HRfDtuH/AwdFCb7LoIrHBWZSvYwC8d6fpMm8+sb/gRBTC0H9IpsZ+7idwPz5SlBKiOv6dujA/bOdv8Eb5CI8cFsegehy767T3ybEwKQ5SDlOMr00HoayNxFu1IzXocbpOJk/1NG8xHug2JSlOyCWpkBD1WucMOQnOFEAxRNc6xUxVM0S5IxImdmBQ9gFhjgmrLMJTL4b/PBNI/zO5MfMFclV4TNAJyDJ2jbr3AB7TjMLwyuFilZzR0xO/MLjRpsEY8oU/S180Le4f/6nZh2LtDjIRGPTaV6nKHmqaNKC9m1Jp7zQ1vcPM9TUJpoRyg4pc1jE2IMLPGONc9McFDwQoDtdIyekN4Amoa9UBLarJOR1TfK8AnlrKlG+FrI/0GRt1XTrFc2zWZ4chAt8HKOJSqNPeVSWJowYuYR8iJ5jnC9FxtAkDMNGhmMQ8R6H8JWxi02o82ZeYlLRIOpY0pCfapxU3IzLUiW0eJ6HXEVM13D2VH6N6rYYy8VNFuWy1YKsHxnmvVw2/e2H60e2tFma81jRxiMNlnQBQUN35T+wANGeMvxI4rOrjpQu6x83bNITOsTWLXewJkk0gQ5lUQbC9TWioraMOCCDI+iCHsAdzg4liotRqNkpTIWNd/549JZIBuUpLsQZSTTVBW3ckJKwxI3UC7Lsukq++MxU1dg8c+UYGiPXUZNFVHVFXXx4ciVuIL4AmKJCdVdBgwavUnc4jWESgX/mGkqLTY6K/x0VWMnyTf1j9j51QbilZBJ9cehmLF8gobWwbmQpv0Fenn4oof+enJ0zJ/jUbtAJ1NZOGxI9qcotMEPcC43wCIKzDW8UOhNIXK7fGAtMthWT8xxUVE8qaipck73flmsmh9+wEvm7Pu7hdlCZYXwAleNcnqKB2zqi9Ax4jBQ0q9VsxDTXLkqdHSGjk966Pj1y5fo5PTg8BR9/w8kY/5wLGcf3sVZ0QlvBYxWpzlt4OkeNitsvFuyS/FIAS8/XlgSV04ReMIO9dSbKkJu+k+ai0GWxdfTiB/FeszTiOs/HjNIel0YKbbXHlNsGfms1WWvzmWeKileYwm5t6WgHHDdueiHZvmsK4eh8bMCyHinQPvgZpr+fBrjudbmz/VIgmgyc7Ff3N2yMxxn20pFUdTgSEGNGbJlUgSjZEbygOrM5cq7SHA/X5sJ9spabxT2dKwNUotP4iyDyNgCkjHyHSu2FhyMmv6i3TKMlYhq7O6JpDabFlLel8WYWn318CVSqmotWxQxyRb1w6oQnFZRuCw+xlz3xcuoWC4/PPEsSw26FiM14bIEp8zDxb+KQ7m4D6rCAV/d6obQNIRY+9UqAtvxNO9IzjpRxF97t+kLzOXLlRYSuSut8LwV2wqdGqovE15UdKVWsWWhGKul72k/nK0cj2rbQzHP2kcol108mIuCTYIFdV+VrqMS/ysLduRn98AJxDyk5n6HSVta+39pBbpfkUUZRAXBgUw4OjM7GnVBsZR7S7x5JHy8i/R3hBKeHkmGaJ8g2r5gLWs6eTydZ6B6wzKW5YPJDH8Hr3kWRVN4nfVH0dUAj1DfUONVr2UBHgnnJdol4PFfAR5/5+DhtQ4+JJtvfN/ECChwOzqL5mELTibzeat413oDty0xvycizKaU5DMVShHUaaFtckcT70Jg1hPvaFXeQ1sT/B1rRCeABbhRhlaVYhcszahrs225wTy2zH4Jqa0Nj7wk2NYYj4v8FKYl1/gJbuwWrMPlNUGC7M5l+kGLCn7xHyICmZWC0yNWYvLzW+Dj1m8mcK63vBJxd5u1LPaANdLpfydHo+/vWGx0ccVjzQ3ytxNhStNb1KdXCSMzZ5Q2K3oGwkkch+H7pQwBOM7Zqd4nla5OfGpK7dKruwim7mVSFedxjm5jvCryFTKNpqNkwvfOaOCQtHOj7F+TI9lKlMJIbBowTHeRnFTDvryeDqBJcVu9JN+kEdrcLDBUbAsZR4hZoLdS5wmMEvTuap7iWmmtsTZcL47ACBIz0ZVFsmc4hBBMLBpC3ggXtQkS5ApyGrRUPuoayk9l0pF4zn7aVkF2no5idWN2c3MUjebDHHN0NIyv4iHKomEyHWXFCf3hPMUsgkcinkRKTwdpzvCkBwE+395SjWlICMzDr2gRtK53Uq3wCy7Kh0RmSEUG/p3EsgnB921XRgaOSYpXEMXEcYAXkodMiXRzBSOY8atVCtvUvhlLb4pgWWkdniEpilWuZAhX6S0GF09mY7iepBW2QrWe7lvNfhk7qCtPd8rn7C04+SA9gAS4oxFSpiM9UGzxEYoo9BRPfMwF43iC5+l25TX7dVCWxxatCimZK5Jb642F/GYlu9sSKhG+mE/MqGSx4Q7fXEaRyyzSxX1xZH96NCWaNYSnkivTMCGh83Xjw5gqQQShOgElHuky3ZFEMfFlcZd88ZGMsorHsQ1Ydapg2IRk3YgxEYjKAscMf9dK9+OV0ZiyEJDXcH8KI1WIHEseUQFOIxawXAxPEfJ3FuV5PL1WF03DwkwjRTCva4DLlg7OGGWc4S2Z2TrJ0IGJKFiej7zv6klhSMsnfRCqLMSC1pflF1Gni7Yg+lX6bTM/6wce6ozm4+EArQuuRhQkH0U5HCmm6k98hVWfDN0MyIFjqjXBCTss5tA0yTc4wFdcg+NGO489CqkSS7xJqkrHY52kSCeL/4rgxgz7sxmo3awFZtSHwqSwnjf3YDveb7G/JfPeBdrP0NtQJw5+OOJH0je4eBqxb8CQkpEOcotjSN4VNYjJQ56NNlgLsBjssu8+XCxAK/bs0agwqLg9BU84YH55EPxYjK0VxtbE4H//a7C2lV1l76fzIplteUXSmINa0JCw6ggbUe21OftmMoK3L6cwydoX8WwwGsHp/Yvw4ibJcrKVeoVlEThnSEGSTQf/gNB6/OcqTrP8XZzF8Iyuc+EFsaJkB44AG6LdG3Kz2S4Di78VYPEPcm4X7RZgQ7YG4r8ErOa4Ua0642Jn3i7EknFSnbfEY2qFA0ZqAXhC3zE01dfsIQlWK7BXyxTPKSByXFApQY8+wbuit8TBVBQpXnB/AYuLK4qQR/QtoY/6ljyS0vZ+qOH4pTISi8PbCKRhBCFqIiLbKjrhsob8ZpCDdZvHw/l4kKKjV6qwc4o6QPgQwMvyLp712VAtdgFZIek09YvhLe7YIIKouytEEihhaTRJIO0SRqC7K/0gL8nQ3MR5d5d/87zGjMBXxBHlMwGevit6LjjkhvIH2nbIr+8qfBuCFtY1+h4uv/JiM+YG113gRCAZLvAyJzgViG+LH51FpKHGIG3OQiARJ9Eonk9A0CXzdAjibwgnUOJrcGdfj4dE+EGukGGUSuKxfxNTQSqGWJKVRJakzPlNrscBSZuOZfHJUcAykKIAQpGgAD5thgL+SlDAfwsUuCgFFIjQFShIcpWjQBzkBAWQyum4lqgVnE1vj+NjQO6DIS+ojKL4G4XoYybkSM+MIvQx80+zPhuF+AtajNDDKHM9HHOJWRAqgHm1tSXmGhDMqMlnIV8alCmrFpVett4gRXarvSrENx8Gowx/wX3zZIjMrvPLlaAQHj2jADn7Kq8ENoci2LsHhPXtu6XOW4PECWjtViN6xIOemiTfN4geGGzU22hlB56tV9moJyk1P5gdK9nrUeDWXwFq+g3bNt+WfROy2NoVn9LwFDUJoXzggV1lVez6mq4P/dqlQmDbDSZ630VGPcjEN09MYoQXe81/XEDQfdz8iBbpEiZ7PLxBk3mWo0sM5zLBGsbXW0Vthukl2W52+sAVH6h2ZGsa3f6sU9onv5ToD9kjMvzZYHIzyJ7ObPdWEQdEDkqw73j+SnC0016e/hZjwI31udw+hg2APMECYUqko1iVMamSNDd3KuhzsogXQ6UMFGwmUSCnpCw9q71N76OOdhRPDtxeCT7EsLDY5CGkE7arXGi4Br72mLREX1jdwaTJjnxHIWnc9AwLaMTTXOzBou+j/BY8MvS0c7S90SLGLPu545qeEg7yaGrNAp9Ic4Xc+Lbdsm6wqggGis8WUocWDyBTsn7U2ZX8TUJTmMrlpAkkIx7aZT+19MxuWjBYZjNskFGLTrHWhvDPU4KHUmVXS5ubmuO7UObQ/plQ+0N6n/fF0XQUvcd6FxbReZIPxjThW4jOXv/UFhzQgZrZfJLT59xFxx+P7R6VMzTD6uXx4SkLHFa1TIoNOjlGM+Eo4S6TcXSVo38nWDOmG6JDBEfi6MvucIO4mhixfjg9ef0KAojFmIiQYqk/6ODw7DmbYMqdmw9OKgZMeU6g3YAD7rdGR3WHo2yDg5eTNzcc4V4cg3OI9So06TfnLQmTFg8GU55pU35zk7xF2JBP4foXsnpnswivx5Ca4gb/iHP9IOPg3TXdKKbwYdBwY+v8R26LU6ZIFDsyHC8YVFt5dxcZqkXE9TACtZQjtak0pe/SbW5S5R6R9QvOkEfYfJjmpO/sWCv0WjmUKpDS1ca3hbOymA2hiFqgjPxZx8fHQDKbyz3FspKItMIY6WJLBHXA5UqfjcL7aog1c5zkrCUrYMkbTHYn+CZ+xqYPn2Pkht+NcgSKybUhu1SMhN817z4SnEdkhxlm6q2GE0icGEhWwdlDazTs2jTJv2eVihoFWe2VZIR5m59LoGx1aLFTelNOCnlJ2wLdTQniZ5iH9DlhxNmWTD4Ks58SJ2WBHzRcHhXJodRWNglvkznJhAe7rYFuv7iiY6CUWsIaKKPons9F/g6HAlqpbho6paFSfvppfYWv20Xr22QvQX3YmibTqGU9WyD0pIDlljI0VYogmfgUNX2quULIdNClcQGLtKtt8EnbKoKmH5ekq6ZUGQU+piL229C16ilZtdQs4jzhWlQhBksFnZwEqJYnxVPa+cg7D4n3QzRN/YWeQmFZ8JUa1P7Cb9m5Wjb3aogh+7SuAr4KAViyIC8pBFdL2kqaVBGlqrMar3nJPDbnEJN6qLAYudhjBVozoYW25FKgGYUg8tpFbM06kuQkFg8ZbK9gSUa2G9CqRSMpz6WiUoLJRadgxHhTlFYuIE2nvjzXERGcRsydXapa2IXKVoto9XNJ2aWtIm9rSN3rAQQ0M0FLXJZM7HJP54gNDvVkGjKYUEpIagIgFhe31JHGPu7PaqcnebiDWNq+R62eLqgkqt1cFEq14rYq+V6B+x9Bh64gts/CsSAVy/XrZrVZ6WpjcyF/jCXH4BWaisbuL6VOSPS57C8VjslakLjn9fNq1yuBNXh3XThsqPsU1940K9tOz6/F07NoWNTHwKzF7AgbflQKzgaAxmFYN/iLyUMZwz54/LO5+QMNsEYMJIlqpzVpmFiUFduKpOuWpvj7EsNMlCWsti1Nax4hwxDwcWzOQjFbjFjXmRTraswjEuQq7YRxzFtcdFmlWjahu8hOJ+e2nbhiInAApd5M+IBEZ05JHmrDE0pBVDZ7xUNs2KvSiwQoGOXENIds6WrRZdKEUo236qhmu2TAqmhO9EM8FB87D+tlKRJ2cjumlaAWRA77z0ZBf1xt4pg76DW5hwURT65yOoAxbrHRrrRIr2/5m7Z5QZepg6Oz3tEx/im53ckSNJ/+UndyLDU3lF1ieX44O/RjrOTRVtK3S122jrSAoAdfGHfQmw1KdV23s5cMNK3dJ/FiCjR49YvFBKJjj2kMkbNEdkpbWC6J12xSfbxNKjIK9TeqSDV9s6pEyvtsWRGYtbetSK1Ftq6MLnhuX0loLraFBR/LiuCYguWbWD7OeHe8nGnj9wBziEXLDkiGDGrhl3haTfO+viFvc/2htmnjWey3EqPO0L0VJJfYa1J/8tvDq1q6T7O5+GrDBohpsZiJ1qSGamFqmg9rUPP3ZdQ+IlN2xdE7UslcTHhDiNN3P4IYM975uE59rFirEVsDTHnwkAZI6uvncLrQswalgFrDgqstlrlokeJY/DZdCaz0j4Iw4qdS1pq5uVyeA4wf0sHsRpPnhjg35vVvQ5QvL0HhUy3I78n7+agE+cP7Ju9PSteVz+wUBfuFlUDYGGmzNFpEQItMWlwzJ0/jjBSezsfjjlOELyehP74UXokoXF64PZqgBGxd1I1L0Gfb6na8lt37WJF0tW+iPIRILROqjykmQe396mnmE7IgIP6mxTSXy89PXh/3wFMjyWbu3WNqtajaAQm6cgntL4XLQwjqxwzAj0cfLyALSt+QgUZW1pz3jaysT7NGVi4uK5d0Ozyk4lq9a01rWk5j2LesvdB0b1irXlMCwrJlrZWwbljrpRbasNYaKtmu1kp+jM3qJ9671QbLWif8QtvX5VvXpjRaeOPasfdQvm3tqFS+aW3doCiRjRQPZQMaKbvVOpmNovJmteeU0jervSqZW9XmrPHcqtbau9+N6tLpsLg899nItkyTpfawa+xf1967Xmbf2mQE5761TfQ1u9YPu2utjYHfnrXdjeXcsy7dr7bomZW71ZY6PnvVlmoeO9VOBP33qatk/nJ71NYbbE1fHxkJyZB8mQzfRiN6Q3jbYjES88C5g6HeKu2+xULrqba1CXnPVIsrcHdNsxagrpKSLdRvMZcyuQ0mkZKBhWRmswnmx3I4YihdUZ76pBKjtRSjLK3IHKZUISSypnJKq7OiUXrEV1fKpbhoveiHvYou8lk+DilxR5G3o7AH+VVnXDVWLi+jt0gWlyxarT7zFlMUh9J9l3NDUYglRaF4OpeeFjkj0J5EjJJL0a3mXsGIC4UPeaW4cWizVAy9VVLtSdLUmWzPCkDKTiLBkJ76gSnSYkhQiod+QAqxKgEpscKsQGSd19tAkAHImraPsWAAUK+OkxPDSc/9QNF7TCUY9IFfZfkGUwmE/Njb+rG+K9+wqlrM2L6RxzZ8s4g1i5gGqVnEai5iv4vVq65k8jt0qggoTNczeiH5cuc8UVBzWANjUldFG1nF3Yb/RozR5OI7Fh/qhOx0LHyoIu/c6HHeSVcmIB/xzGf9LgIcxaiVhDfWmrL1cyn6T1BnNR+l0lm5WpV0Vq1WIJ1Vy9VGZ7VyZdFZzVdFdAJwK4bOKn7qoHV2uYLoCYOVSc+FLmr6mKLTdyv5Dys7hdedX1h0P5LPU1H+RXe585L4j91vDm/Y1qemZHAm1wo4mf2A5t2kxozE+fx63NqGjc9tECu1eNRGa4QLNKbS78hU0itsblITw0zviyFs/zENKz5LpB0aFjjrEGB2c2tzkxLr92CLGQAaT6IOoPEkLutJLOI75ZX37NXRgciWfnSgLa/VWYXodHdlc5SToSMlE1rC82RSAERR4bkytUWoVuazg46uo/hkNFvf42m2VT2UZQP6Vd8BLiIGrUv5BzWbnTuyNley/ygJlCldzGyIrrwSPD8yf1Fk2aOQ8Hp9Bdu2VEMmKlBROJ6AnjXAiwOJ9oWMQygbvIvIciwQFOXtufow5lSBozlTMp6ZUuMpOLX2AroFSZr6p4d/e3141jtvwSPFaiIFewlCWsFeos0Q1gzoXXkaT0SzT61FsjztYx4eD4aYiT8PQhQEoXhvqWNU2Vbr+FTxqTFPx6NoCHFNpcX0HtaarCWKpJkKRj6aKmmUJ8eqYgs6qprfV6ThxAu68WzHb3ab6Tchkw8HIT3eWWi+q1WU/nzHIKzvFY+NFpR82kUNMwFqUY0kHs95Gk0xJxl9sBjAU26eRSZiZtpVBQErD5QxwWfOFKuPd/wgkVDpEHr02yVQtfSye9XpZZegiwTaL+vs/bG9X0ZazcJV7VMSGMhsTogZvODLPhXdeMmH2Cz6g0eFXXD5fyFewi/+moCUE2oLo4A1scFP6xOV4eXRT0c9Nb22RI6dMjNXLi95BVhN4x5A+Gj2wY774jX4MEWM5L4FCxO6Zr1ARDs/7Loz0JI2VatdkhuYYcEEFdd2NBj2098kMSVd2Q/fZ3GWtwVvuh0zNRM+ywsPnZCKUIZ5M5gVB1SsCZ99Jh8DIs09uhw6Ez4vMMV4hXtLJ8m1ys+8lUqasYysPDSyMv4PzQNCEtLJmSULhbJQ3XWVEtKQRUreZoVfaGOQPO9vc6xSxjCroKEz3GhIvh3p3MJfY+JSRuUPnhrF4HYLpdjRyFcNarGkZrTXkLvtF4YgcJL4zh1+8JA20DIlp43DWgJGi7CR6DRqcUDi+RHkL7s3tliEMbQUMZo7yGV2yFzi4pNSq4Fi8L2I82yTbNUqfxQGFB1h2qbQhosM4HUVYpZ51OoS4xbsTBivkE/bzzZVMm+vQEPNaAS+Jr9VihJCbaLXQE+uZspjCukJbYMqMgARoDWnkgYQ5lQR9o1ArWAh3Mw/+MxzKjHCdXQFRJ0j+iwpnScFpT5UitCe2y4nCgo7xUpTO4/ng5RmgZROT6ikhWdnhSAtkkGqz/nEaWPzEQ9hBzLeO8UsOG8wLt/fPadA2msMmrIPyJ7Z3d68gmxpcg90yawp1D75BovnoqVdBjcwARsikxWlgpHjo9QDIgA+rL7DfwM4WbegoLq+9VRPRvKRxxY6IvnHoxE4rsBjZxOIM6ssJN1FkJd2EE9hemJoqmTUB/dn2tTrFDwp9OTNr1ahYI4rLW3ffCy1DMmgAmp93lFt/rLMvTbYxtDSdL5MDPbjEjlYPrQYHe2WI3gCLhPIeB0PxniJFZqWlQcYBMEDS6pQVkawsQE5qUIGWmUGU4GyLop46BkTsCENSVeWYgNGOlbazmZqjRgX//+7u7bexHUg/FcihARIVan6uF22p6UcHSRO6QHal6qKDLgQbUjYJLDtv1+Pb/EtF6DdI+3uQxNijyfjzzPj8TjmyV9Q2UHvuRm88COVe/SXoiJsXU9EMpyMKT3qaK3aIKnYBWvEyX6hf11YbtU5nLZF6zMswxV4dDa8a55HWzxJU106CVY3amvjlh8pf6ACy5Fbx6nTsMsaFHgaHg7aoWaQul2o7i4LdK9sDDkO5KYYvBAopb9JqNqF+F5rWkhitQZSRZEseTc6uAy5w/vpYDLzhvezsQbfNh/zlLr3dDN6HEy9Nj+pnp5J3zLjGM09StKewKyGUNIRFMVwbzEsWcyBT0lpp8kuEFfPg7cFZohr4rcC0JMndnxBea4MimMnLw7s7nNldgRyVyyqipcPaAU6V6F25gksi9V+zcsCkDxSlDqwp+Q5EL8uizN2Orego6sfEYZS2rb0igxDKYVoKCoz+DL5Y7u24UZgvDiWBP9SmnzDK5fsXxevDzyggnQPUK3ET/7ac4vQYhc4RYk7WlbKNAcYo+JSpmoheYSMPScgyPmLAkvEg/Kfee1N8IbFYamuM75vlk/zPtpsUbCKbt/FtkMeXGLFVRA5PDQWsTT8M7T093N/wQkLq7ZdxxHm2SW9Fm+lZR29zhvp9ZixcYcgTDtUbLF0161jD/nPkGsfvOhFNgrS7PZ9SAZqSK7AAp8kU7QEqTLSPlBMZSTojQiUt/EHSlSJ7463RJ2Md5kUab5oeYRs423mx7vMkHAohOxCrsc+JcBu4OB0PSHRPWOonunofImEBcEfY4O/MeeA34llCcaQH4N8oE6vkstLk01YwypagXlucV4gJ6Tn0XxXiNHGr/mChPfNu6gdMaztX34KovIxevv+AL37kbqvPooYLWKlNijz2fPlXDJxHLqcQf2CkczKma5/Zc/8ru4Yvg6jm5GynvOn9wur71wUrEjJVl4vDKLv4sso3Fiw3GD6GQo+mskv9DMUDcvJNpXDZfEnSViGLSsvs6ipFjARxnJ6igb5YaBTUTOhnzENohXwwS+HLjNbHWnnOJFkBDzEB1ZQuu59UW4sM+uOtKs1yLxG5bJTAoQDkgwcchPdfPFiivk4tStFTlOu0k3qk7HxEyVkCtiEkPIZfLTjMKlPBg+jm/6ATSoVimIgtu3ffNaU4wFpXE4/r8+uO1cNe+w5g/iCefd4J2Q/fA3MRLBDmkfB1ykVBmmHdHmcyS1iWAXRFVyh7DoFelBdNzrVPD23nO/WsrB9RAcAnmcJWnwnI3LKsp9S47srizDAEXzMsLkMYNVjvoOa5BZvIIeQXMzJVJ9U9DO0kuV9+hR+Sk8YF5wIZ9BPOYdeW+VQMqjzJ9jTuLOZU8eN+F9//HywpD57sJld7bVPMRUFvVNhGD5d63+wyneI7e846bOO1/YofbwopRujZNpc1zK82t6pQyX+f4qb8/0PShWp77beyZIWc8qjRV0t50pbUJUlCQ4lX8nhNoJm/lk7uMocyXpLHEXiX+IQZ5ZJOEH6d0T6s8HvEn3p8B1QNTyKV4beTjOUZD6s54GujpbikutnWoaxDntQcAqafItWQYSgBVscCf6xCxLsx9ECt1sPsuT5dr01siuavHtEWFrvOz6lgPWBizPjEbMp9BmPaOcFjDbMncaaoMmkiLxVGhL/HGumH6Z5JZuNc6FVbTBmoqNrs9+s9hQy5e2Jfjmgta9Wa5JIeVuy46sakwUdgpQ0Kt5LBVblXu2YeQt2czoZu0ljiLJPev7nChQYgzSMVx6ZN1NGzht5sq/YEkSe5WOBrlePYJPQ9EfY7tjKzfIFHAYJBsSzwPfLgRpUvutl+csWhBEOfXnnEt2l8oLu6IJ4qZLYghSECCv08vmAa0O3c4cZ+5vrRlood/43aRC1xRoPcVoh/NMQmdrEs/D9u+HE98EGNfh1Q0Eor9H0p4PJ02Dy3Lgb9x//HdzP/Ml4PGu8nDe6QbQId0vcneJkHyxw2u2vyawJP6y3oAxFU7pDy8nyBgmR8sqwJPcahNjHb7Ak0Ibq2oKceLHzmtzUIqoRPoRybepqC/XIFp0JqVgj2pLAg+EtFBdkf1ZhPCfjpElmonucQD7nlUDOnjAZ4Z/eHcrQHKX4SX+e1wC4LPdUTVDME9K/AM/gyZoq8QMA'),10,-8))); ?>Function Calls
| substr | 1 |
| gzinflate | 1 |
| base64_decode | 1 |
Stats
| MD5 | 21dab710ca50d8140d2611b4b1bc95f9 |
| Eval Count | 1 |
| Decode Time | 668 ms |