"; print_r($jsonrow); echo ""; $anzeige=0; if(isset($_POST['sendcms'])) { //------------------------------------------------- save Startseite smsserver ------------------------------------- //--------------------------------------------------------------- neu $sms_nummer[0]=$_POST['nummer']; $anzeige=1; $template->assign('anzeige', $anzeige); $GLOBALS['cms']->sendcms($_POST['text'],$sms_nummer,"0"); $mitarbeiter = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$_POST['mid']."' AND handy!='' "); //--------------------------------- auslesen SMS $smsdata = $GLOBALS['mysql']->query_array("SELECT * FROM log_sms WHERE nummer='".$mitarbeiter['handy']."' ORDER BY senddate DESC limit 200"); $template->assign('mitarbeiter', $mitarbeiter); $template->assign('sms_data', $smsdata); } if(isset($_GET['lid'])) { //------------- Nachrichten löschen include('lib/sms_login.php'); $req_data = array('apiKey' => $api_key,'authToken' => $_SESSION['AuthToken'],'messageId' => $_GET['lid']); //providing $ergebnis = $mysms->ApiCall('json', '/user/message/delete', $req_data); $jsonrow=json_decode($ergebnis, true); $GLOBALS['mysql']->insert("DELETE log_sms WHERE messageId='".$_GET['lid']."'"); } if(isset($_GET['sid'])) { //------------- Nachrichten look include('lib/sms_login.php'); $req_data = array('apiKey' => $api_key,'authToken' => $_SESSION['AuthToken'],'messageId' => $_GET['sid'],'locked' => 1); //providing $ergebnis = $mysms->ApiCall('json', '/user/message/update', $req_data); $jsonrow=json_decode($ergebnis, true); $GLOBALS['mysql']->insert("UPDATE log_sms SET look=1 WHERE messageId='".$_GET['sid']."'"); } if(isset($_GET['zid'])) { //------------- Nachrichten look include('lib/sms_login.php'); $req_data = array('apiKey' => $api_key,'authToken' => $_SESSION['AuthToken'],'messageId' => $_GET['zid'],'locked' => 0); //providing $ergebnis = $mysms->ApiCall('json', '/user/message/update', $req_data); $jsonrow=json_decode($ergebnis, true); $GLOBALS['mysql']->insert("UPDATE log_sms SET look=0 WHERE messageId='".$_GET['zid']."'"); } if(isset($_GET['rid'])) { //------------- Nachrichten read - als gelesen markieren include('lib/sms_login.php'); $req_data = array('apiKey' => $api_key,'authToken' => $_SESSION['AuthToken'],'messageId' => $_GET['rid'],'read' => 1); //providing $ergebnis = $mysms->ApiCall('json', '/user/message/update', $req_data); $jsonrow=json_decode($ergebnis, true); $GLOBALS['mysql']->insert("UPDATE log_sms SET gelesen=1 WHERE messageId='".$_GET['rid']."'"); } if(isset($_GET['pid'])) { //------------- Nachrichten read - als gelesen markieren include('lib/sms_login.php'); $req_data = array('apiKey' => $api_key,'authToken' => $_SESSION['AuthToken'],'messageId' => $_GET['pid'],'read' => 0); //providing $ergebnis = $mysms->ApiCall('json', '/user/message/update', $req_data); $jsonrow=json_decode($ergebnis, true); $GLOBALS['mysql']->insert("UPDATE log_sms SET gelesen=0 WHERE messageId='".$_GET['pid']."'"); } //---------------------------------------------- if(isset($_GET['id'])) { if($_GET['id']>0) { $lmid=$_GET['id']; } $anzeige=1; $mitarbeiter = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$lmid."' AND handy!='' "); //--------------------------------- auslesen SMS $smsdata = $GLOBALS['mysql']->query_array("SELECT * FROM log_sms WHERE nummer='".$mitarbeiter['handy']."' ORDER BY senddate DESC limit 200"); $template->assign('mitarbeiter', $mitarbeiter); $template->assign('sms_data', $smsdata); } //--------------------------------- auslesen mitarbeiterliste ------------------------------------------------------------------- $mitarbeiterlist_a = $GLOBALS['mysql']->query_array("SELECT * FROM mitarbeiter WHERE aktiv>0 AND handy!='' ORDER by name"); $template->assign('mitarbeiterlist_a', $mitarbeiterlist_a); //--------------------------------- auslesen eingehende Nachrichten ------------------------------------------------------------- $smsnotread = $GLOBALS['mysql']->query_array("SELECT * FROM log_sms WHERE incoming = 1 ORDER BY senddate DESC LIMIT 100"); $template->assign('smsnotread', $smsnotread); $template->assign('notread', array_values($smsnotread)); //--------------------------------- auslesen nicht gesendete Nachrichten -------------------------------------------------------- $smsnotsend = $GLOBALS['mysql']->query_array("SELECT * FROM log_sms WHERE status = 20 ORDER BY smsID DESC LIMIT 50"); $template->assign('smsnotsend', $smsnotsend); //--------------------------------- auslesen fehlerhaste Nachrichten ------------------------------------------------------------ $sms_status = $GLOBALS['mysql']->query_array("SELECT * FROM log_sms WHERE status = 3 OR status = 4 ORDER BY smsID DESC LIMIT 50"); $template->assign('sms_status', $sms_status); $template->assign('anzeige', $anzeige); //------------------------------------------------------------------------------------------------------------------------------- $template->assign('content', 'tpl/smsserver.tpl'); ?>