<?php

$tour = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE id='".$_POST['id']."'");
//echo "<pre>"; print_r($tour); echo "</pre>";		
if ($tour['smsstatus']!=2) {
	$sms1 = $GLOBALS['mysql']->query_single("SELECT * FROM log_sms WHERE messageId='".$tour['smsid']."'");
	//rückgabe sms1['text']
	$row_sender = $GLOBALS['mysql']->query_single("SELECT * FROM benutzer WHERE id='".$sms1['sender_id']."'");	
	if($row_sender['num_rows']!=0) {
		if($row_sender['num_rows']!=0) {
			$mysms = new mysms($row_sender['api-key']);
			$login_data = array('msisdn' => $row_sender['nummer'], 'password' => $row_sender['passwd']);
			$login = $mysms->ApiCall('json', '/user/login', $login_data);
			$user_info = json_decode($login); $_SESSION['AuthToken'] = $user_info->authToken;
			$req_data = array('authToken' => $_SESSION['AuthToken'], 'address'=> $sms1['nummer'], 'query'=> utf8_decode($sms1['text']));
			$ergbniss = $mysms->ApiCall('json', '/user/message/search', $req_data); 
//			echo "<pre>"; print_r(json_decode($ergbniss)); echo "</pre>";			
			$jsonrow=json_decode($ergbniss);	
	//-----------------------------------------------------------
//	echo count($jsonrow->messages);
			if(isset($jsonrow->messages[0])) { ///// 
				for($i=0; $i < count($jsonrow->messages); $i++) {
					if(isset($jsonrow->messages[$i])) { 
						$tmp1=$jsonrow->messages[$i]->messageId; $tmp2=$jsonrow->messages[$i]->status; $tmp3=$jsonrow->messages[$i]->dateStatus; $tmp3=substr($tmp3, 0, -3); 	
						if($tmp1==$sms1['messageId']) { 
							$GLOBALS['mysql']->insert("UPDATE log_sms SET status='".$tmp2."' WHERE smsID='".$sms1['smsID']."'"); 
							$GLOBALS['mysql']->insert("UPDATE log_sms SET statusdate='".$tmp3."' WHERE smsID='".$sms1['smsID']."'"); 
				
							$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatus='".$tmp2."' WHERE id='".$tour['id']."'"); 
							$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatusdate='".$tmp3."' WHERE id='".$tour['id']."'"); 	
							$tour = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE id='".$_POST['id']."'");			
						}
					}
				}
			}
		}
	}
}
$template->assign('test',$_POST['id']);


$template->assign('content', 'tpl/ajax/smsstatus.tpl');
?>