}
}
$session->data['table_cdr_sort'] = $sortby_cdr;
}
if (!$sortby_cdr) {
$sortby_cdr = "calldate DESC";
}
$out['SORTBY_CDR'] = $sortby_cdr;
//SEARCH RESULT
if ($db_table) {
$ast_db = mysql_connect($db_host, $db_username, $db_password) or die("Could not connect: " . mysql_error());
mysql_select_db($db_name, $ast_db) or die("Could not select DB: " . mysql_error());
$qry = mysql_query("SELECT * FROM " . $db_table . " WHERE " . $qry_cdr . " ORDER BY " . $sortby_cdr) or die(mysql_error());
mysql_close($ast_db);
} else {
Debmes("Asterisk table CDR not present");
}
while ($res_cdr[] = mysql_fetch_array($qry, MYSQL_ASSOC)) {
$out['CDRRECORDS'] = $res_cdr;
$out['FILEDIR_CDR'] = $filedir_cdr;
}
// PAGING
if ($out['CDRRECORDS'][0]['calldate']) {
paging($out['CDRRECORDS'], $session->data['recperpage'], $out);
// search result paging
}
global $page;
if (!$page) {
$page = $this->session['NUM'];
$out['NUM'] = $page;
} else {
$gpsaction['EXECUTED']=date('Y-m-d H:i:s');
$gpsaction['LOG']=$gpsaction['EXECUTED']." Executed\n".$gpsaction['LOG'];
SQLUpdate('gpsactions', $gpsaction);
if ($gpsaction['SCRIPT_ID']) {
runScript($gpsaction['SCRIPT_ID']);
} elseif ($gpsaction['CODE']) {
eval($gpsaction['CODE']);
}
}
}
} else {
$tmp=SQLSelectOne("SELECT * FROM gpslog WHERE DEVICE_ID='".$device['ID']."' AND ID!='".$rec['ID']."' ORDER BY ADDED DESC LIMIT 1");
if ($tmp['LOCATION_ID']==$locations[$i]['ID']) {
Debmes("Device (".$device['TITLE'].") LEFT location ".$locations[$i]['TITLE']);
// left location
$gpsaction=SQLSelectOne("SELECT * FROM gpsactions WHERE LOCATION_ID='".$locations[$i]['ID']."' AND ACTION_TYPE=0 AND USER_ID='".$device['USER_ID']."'");
if ($gpsaction['ID']) {
$gpsaction['EXECUTED']=date('Y-m-d H:i:s');
$gpsaction['LOG']=$gpsaction['EXECUTED']." Executed\n".$gpsaction['LOG'];
SQLUpdate('gpsactions', $gpsaction);
if ($gpsaction['SCRIPT_ID']) {
runScript($gpsaction['SCRIPT_ID']);
} elseif ($gpsaction['CODE']) {
eval($gpsaction['CODE']);
}
}
}
}
