82 lines
No EOL
4.6 KiB
PHP
82 lines
No EOL
4.6 KiB
PHP
<?php
|
|
|
|
require('lib/config.php');
|
|
require('lib/mysql.class.php');
|
|
$GLOBALS['mysql'] = new mysql(CONFIG_MYSQL_HOST,CONFIG_MYSQL_USER,CONFIG_MYSQL_PW,CONFIG_MYSQL_DB);
|
|
include_once('lib/class.mysms.php');
|
|
include_once('lib/mysmsapi.php');
|
|
|
|
header("Content-Type: text/html; charset=utf-8");
|
|
|
|
$tag = (int)date('d');
|
|
$kw = (int)date('W');
|
|
$jahr = (int)date('Y');
|
|
$key=0; $tmp2=0;
|
|
$abfrage = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE kw='".$kw."' and jahr='".$jahr."' and tag='".$tag."' and smsid>0 and smsstatus<2");
|
|
//$abfrage = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE jahr='".$jahr."' and smsid>0 and smsstatus=0");
|
|
|
|
while($row = $abfrage->fetch_assoc()) {
|
|
// echo "<pre>"; print_r($row); echo "</pre>";
|
|
|
|
$row_logsms = $GLOBALS['mysql']->query_single("SELECT * FROM log_sms WHERE messageId='".$row['smsid']."' and sender_id>0"); // and sender_id>0
|
|
if($row_logsms['num_rows']!=0) {
|
|
|
|
|
|
// echo "<pre>"; print_r($row_logsms); echo "</pre>";
|
|
// echo $row_logsms['sender_id'];
|
|
|
|
$row_sender = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE name='".$row_logsms['sender']."'");
|
|
if($row_logsms['sender_id']==2) {
|
|
$api_key = 'EPOcWC8smWfdOWNHzSLANw';
|
|
$mysms = new mysms($api_key);
|
|
$login_data = array('msisdn' => '4916094934507', 'password' => 'maxdata-01');
|
|
$login = $mysms->ApiCall('json', '/user/login', $login_data); //providing REST type(json/xml), resource from http://api.mysms.com/index.html and POST data
|
|
$user_info = json_decode($login); //decode json string to get AuthToken
|
|
$_SESSION['AuthToken'] = $user_info->authToken; //saving auth Token in session for more calls
|
|
$sms_nummer=$row_logsms['nummer'];
|
|
$req_data = array('authToken' => $_SESSION['AuthToken'], 'apiKey'=> $api_key, 'address'=> $sms_nummer, 'query'=> $row_logsms['text']); //
|
|
// $req_data = array('authToken' => $_SESSION['AuthToken'], 'apiKey'=> $api_key, 'address'=> $sms_nummer, 'query'=> '*'); //
|
|
$ergbniss = $mysms->ApiCall('json', '/user/message/search', $req_data);
|
|
echo "<pre>"; print_r(json_decode($ergbniss)); echo "</pre>";
|
|
$jsonrow=json_decode($ergbniss);
|
|
$tmp2=$jsonrow->messages[0]->status;
|
|
|
|
}
|
|
if($row_logsms['sender_id']==18) {
|
|
$api_key = 'OvHiwonvVKneoYttEOE64g';
|
|
$mysms = new mysms($api_key);
|
|
$login_data = array('msisdn' => '491783481356', 'password' => 'laden');
|
|
$login = $mysms->ApiCall('json', '/user/login', $login_data); //providing REST type(json/xml), resource from http://api.mysms.com/index.html and POST data
|
|
$user_info = json_decode($login); //decode json string to get AuthToken
|
|
$_SESSION['AuthToken'] = $user_info->authToken; //saving auth Token in session for more calls
|
|
$sms_nummer=$row_logsms['nummer'];
|
|
$req_data = array('authToken' => $_SESSION['AuthToken'], 'apiKey'=> $api_key, 'address'=> $sms_nummer, 'query'=> $row_logsms['text']); //
|
|
// $req_data = array('authToken' => $_SESSION['AuthToken'], 'apiKey'=> $api_key, 'address'=> $sms_nummer, 'query'=> '*'); //
|
|
$ergbniss = $mysms->ApiCall('json', '/user/message/search', $req_data); $jsonrow=json_decode($ergbniss); $tmp2=$jsonrow->messages[0]->status;
|
|
|
|
}
|
|
if($row_logsms['sender_id']==116) {
|
|
$api_key = 'OvHiwonvVKneoYttEOE64g';
|
|
$mysms = new mysms($api_key);
|
|
$login_data = array('msisdn' => '4915754357504', 'password' => 'Aly1Any');
|
|
$login = $mysms->ApiCall('json', '/user/login', $login_data); //providing REST type(json/xml), resource from http://api.mysms.com/index.html and POST data
|
|
$user_info = json_decode($login); //decode json string to get AuthToken
|
|
$_SESSION['AuthToken'] = $user_info->authToken; //saving auth Token in session for more calls
|
|
$sms_nummer=$row_logsms['nummer'];
|
|
$req_data = array('authToken' => $_SESSION['AuthToken'], 'apiKey'=> $api_key, 'address'=> $sms_nummer, 'query'=> $row_logsms['text']); //
|
|
// $req_data = array('authToken' => $_SESSION['AuthToken'], 'apiKey'=> $api_key, 'address'=> $sms_nummer, 'query'=> '*'); //
|
|
$ergbniss = $mysms->ApiCall('json', '/user/message/search', $req_data); $jsonrow=json_decode($ergbniss); $tmp2=$jsonrow->messages[0]->status;
|
|
}
|
|
if($row_logsms['sender_id']>0) {
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatus='".$tmp2."' WHERE id='".$row['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE log_sms SET status='".$tmp2."' WHERE smsID='".$row_logsms['smsID']."'");
|
|
|
|
echo "<pre>"; print_r(json_decode($ergbniss)); echo "</pre>";
|
|
}
|
|
}
|
|
// $GLOBALS['mysql']->insert("UPDATE tourenliste SET timestamp='".date("Y-m-d H:i:s", $startzeit)."' WHERE id='".$row['id']."'");
|
|
}
|
|
|
|
|
|
echo"fertig";
|
|
?>
|