} } $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']); } } } }