163 lines
No EOL
7.8 KiB
PHP
163 lines
No EOL
7.8 KiB
PHP
<?php
|
|
header("Content-Type: text/html; charset=utf-8");
|
|
|
|
require('lib/config.php');
|
|
session_name(CONFIG_SESSION); session_start();
|
|
require('lib/mysql.class.php');
|
|
include('lib/class.mysms.php');
|
|
$GLOBALS['mysql'] = new mysql(CONFIG_MYSQL_HOST,CONFIG_MYSQL_USER,CONFIG_MYSQL_PW,CONFIG_MYSQL_DB);
|
|
date_default_timezone_set('Europe/London');
|
|
//----------------------------------------------------------------------------------------------------------------
|
|
//------------------------------------------------- Eingehende SMS -----------------------------------------------
|
|
//----------------------------------------------------------------------------------------------------------------
|
|
|
|
/*
|
|
|
|
$api_key = 'OvHiwonvVKneoYttEOE64g'; // Jörg
|
|
$mysms = new mysms($api_key);
|
|
$login_data = array('msisdn' => '491783481356', 'password' => 'laden');
|
|
$login = $mysms->ApiCall('json', '/user/login', $login_data);
|
|
$user_info = json_decode($login);
|
|
$_SESSION['AuthToken'] = $user_info->authToken;
|
|
$mysms->setAuthToken($user_info->authToken);
|
|
$msisdn = "+491783481356"; //jörg
|
|
$req_data = array('apiKey' => $api_key,'authToken' => $_SESSION['AuthToken'],'address' => $msisdn,'offset' => 0,'limit' => 10); //providing
|
|
$ergebnis = $mysms->ApiCall('json', '/user/message/get/by/conversation', $req_data); //calling method ->ApiCall
|
|
|
|
$tmp1=$jsonrow->messages[0]->messageId;
|
|
$tmp2=$jsonrow->messages[0]->status;
|
|
$tmp3=$jsonrow->messages[0]->dateStatus; $tmp3=substr($tmp3, 0, -3);
|
|
|
|
*/
|
|
|
|
//----------------------------------------------------------------------------------------------------------------
|
|
//------------------------------------------------- abfragen neu versendet --------------------------------------
|
|
//----------------------------------------------------------------------------------------------------------------
|
|
$smstime = time();
|
|
$tmptime=$smstime-259200;
|
|
$abfrage = $GLOBALS['mysql']->query_single("SELECT * FROM log_sms WHERE test=0 and messageId>0 and status!=2 and incoming!=1 and senddate>'".$tmptime."'");
|
|
if($abfrage['num_rows'] != 0) {
|
|
// echo $abfrage['smsID'];
|
|
// echo "<pre>"; print_r($abfrage); echo "</pre>";
|
|
$row_sender = $GLOBALS['mysql']->query_single("SELECT * FROM gateway WHERE id='".$abfrage['sender_id']."'");
|
|
if($row_sender['num_rows']!=0) {
|
|
//---- testvariable schreiben
|
|
$GLOBALS['mysql']->insert("UPDATE log_sms SET test=1 WHERE smsID='".$abfrage['smsID']."'");
|
|
//-------------------------------------------------------------
|
|
$mysms = new mysms($row_sender['api-key']);
|
|
$login_data = array('msisdn' => $row_sender['nummer'], 'password' => $row_sender['password']);
|
|
$login = $mysms->ApiCall('json', '/user/login', $login_data);
|
|
$user_info = json_decode($login);
|
|
$token = $user_info->authToken; // $_SESSION['AuthToken'] = $user_info->authToken; // unklar wofür
|
|
$req_data = array('address' => $abfrage['nummer'],'apiKey' => $row_sender['api-key'],'authToken' => $token,'offset' => 0,'limit' => 10);
|
|
$ergebnis = $mysms->ApiCall('json', '/user/message/get/by/conversation', $req_data); //calling method ->ApiCall
|
|
//-------------------------------------------------------------- unread phone
|
|
$req_data2 = array('apiKey' => $api_key,'authToken' => $_SESSION['AuthToken']);
|
|
$unread = $mysms->ApiCall('json', '/user/call/count/unread', $req_data2);
|
|
//echo "<pre>"; print_r($req_data); echo "</pre>";
|
|
$jsondata=json_decode($unread);
|
|
$GLOBALS['mysql']->insert("UPDATE gateway SET unread_tel='".$jsondata->unreadCount."' WHERE id='".$abfrage['sender_id']."'");
|
|
|
|
|
|
|
|
|
|
//------------------------------------------------------------------------
|
|
$jrow=json_decode($ergebnis);
|
|
$anzahl=count($jrow->messages);
|
|
if($anzahl!=0) {
|
|
for($i=0; $i < $anzahl; $i++) {
|
|
$tmp1=$jrow->messages[$i]->messageId;
|
|
$tmp2=$jrow->messages[$i]->status;
|
|
// if($tmp2==0) { $tmp2=1; }
|
|
$tmp3=$jrow->messages[$i]->dateStatus; $tmp3=substr($tmp3,0,-3);
|
|
echo $jrow->messages[$i]->message." - Status: ".$tmp2."</br>";
|
|
$GLOBALS['mysql']->insert("UPDATE log_sms SET status='".$tmp2."',statusdate='".$tmp3."' WHERE messageId='".$tmp1."'");
|
|
// $GLOBALS['mysql']->insert("UPDATE log_sms SET status='".$tmp2."', WHERE messageId='".$tmp1."'");
|
|
// $GLOBALS['mysql']->insert("UPDATE log_sms SET statusdate='".$tmp3."' WHERE messageId='".$tmp1."'");
|
|
if($abfrage['tId']>0) {
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatus='".$tmp2."' WHERE smsid='".$tmp1."'");
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatusdate='".$tmp3."' WHERE smsid='".$tmp1."'");
|
|
}
|
|
}
|
|
}
|
|
}
|
|
} else {
|
|
$GLOBALS['mysql']->insert("UPDATE log_sms SET test=0 WHERE logtime>'".$tmptime."'");
|
|
echo "keine SMS zu prüfen...";
|
|
}
|
|
//---------------------------------------------------------------------------------------------------------------------------
|
|
|
|
//---------------------------------------------------------------------------------------------------------------------------
|
|
$tmp = $GLOBALS['mysql']->query_single("SELECT * FROM verkehr WHERE status=1");
|
|
if($tmp['num_rows'] != 0) {
|
|
$lat= $tmp['lat'];
|
|
$lng= $tmp['lng'];
|
|
$page1='http://nominatim.openstreetmap.org/reverse?format=json&lat='.$lat.'&lon='.$lng.'&email=frank@first-mp.de';
|
|
$html2 = file_get_contents($page1);
|
|
$jsonrow2=json_decode($html2);
|
|
if(isset($jsonrow2->address->town)) {
|
|
$datastreet=($jsonrow2->address->town);
|
|
} else {
|
|
if(isset($jsonrow2->address->city)) {
|
|
$datastreet=($jsonrow2->address->city);
|
|
} else {
|
|
if(isset($jsonrow2->address->city_district)) {
|
|
$datastreet=($jsonrow2->address->city_district);
|
|
} else {
|
|
$datastreet=($jsonrow2->address->village);
|
|
}
|
|
}
|
|
}
|
|
$datastreet=utf8_decode($datastreet);
|
|
if(strlen($tmp['street'])<5) {
|
|
$street=$tmp['street'].', '.$datastreet;
|
|
} else {
|
|
$street=$datastreet.', '.$tmp['street'];
|
|
}
|
|
|
|
$GLOBALS['mysql']->insert("UPDATE verkehr SET street='".$street."' WHERE id='".$tmp['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE verkehr SET status=2 WHERE id='".$tmp['id']."'");
|
|
echo "Versbezeichnung:".$street;
|
|
|
|
|
|
|
|
//---------------------------------------------------------------------------------------------------------------------------
|
|
} else {
|
|
echo "keine geocoordinaten zu prüfen...";
|
|
|
|
}
|
|
//---------------------------------------------------------------------------------------------------------------------------
|
|
|
|
//----------------------------------------------------------- unread call
|
|
/*
|
|
for($i=1; $i < 4; $i++) {
|
|
echo'---'.$i.'---';
|
|
|
|
$gw = $GLOBALS['mysql']->query_single("SELECT * FROM gateway WHERE id='".$i."'");
|
|
$api_key = $gw['api-key'];
|
|
$msisdn = $gw['nummer'];
|
|
$smspass= $gw['password'];
|
|
$mysms = new mysms($api_key);
|
|
$login_data = array('msisdn' => $msisdn , 'password' => $smspass);
|
|
$login = $mysms->ApiCall('json', '/user/login', $login_data);
|
|
$user_info = json_decode($login);
|
|
$_SESSION['AuthToken'] = $user_info->authToken;
|
|
$mysms->setAuthToken($user_info->authToken);
|
|
|
|
$req_data = array('apiKey' => $api_key,'authToken' => $_SESSION['AuthToken']);
|
|
$unread = $mysms->ApiCall('json', '/user/call/count/unread', $req_data);
|
|
echo "<pre>"; print_r($req_data); echo "</pre>";
|
|
$jsondata=json_decode($unread);
|
|
echo "</pre>"; print_r($unread); echo "</pre>";
|
|
$GLOBALS['mysql']->insert("UPDATE gateway SET unread_tel='".$jsondata."' WHERE id='".$i."'");
|
|
$jrow=json_decode($ergebnis);
|
|
|
|
}
|
|
*/
|
|
|
|
//---------------------------------------------------------------------------------------------------------------------------
|
|
//---------------------------------------------------------------------------------------------------------------------------
|
|
//---------------------------------------------------------------------------------------------------------------------------
|
|
//---------------------------------------------------------------------------------------------------------------------------
|
|
|
|
?>
|