167 lines
No EOL
8.7 KiB
PHP
167 lines
No EOL
8.7 KiB
PHP
<?php
|
|
header("Content-Type: text/html; charset=utf-8");
|
|
error_reporting(E_ALL); ini_set('display_errors',0);
|
|
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');
|
|
//----------------------------------------------------------------------------------------------------------------
|
|
//------------------------------------------------- versenden ----------------------------------------------------
|
|
//----------------------------------------------------------------------------------------------------------------
|
|
$smstime = time();
|
|
$GLOBALS['mysql']->insert("UPDATE system SET smstime='".$smstime."'");
|
|
$tmptime=$smstime-604800;
|
|
for($i=0; $i < 3; $i++) {
|
|
$abfrage = $GLOBALS['mysql']->query_single("SELECT * FROM log_sms WHERE status=20 and logtime>'".$tmptime."' and errorzahl!=9 limit 1");
|
|
if($abfrage['num_rows'] != 0) {
|
|
// echo "<pre>"; print_r($abfrage); echo "</pre>";
|
|
$smssender = $GLOBALS['mysql']->query_single("SELECT * FROM gateway WHERE id='".$abfrage['sender_id']."'");
|
|
$mysms = new mysms($smssender['api-key']);
|
|
$login_data = array('msisdn' => $smssender['nummer'], 'password' => $smssender['password']);
|
|
$login = $mysms->ApiCall('json', '/user/login', $login_data);
|
|
$user_info = json_decode($login);
|
|
$_SESSION['AuthToken'] = $user_info->authToken;
|
|
$mysms->setAuthToken($user_info->authToken);
|
|
$sms_nummer[0]=$abfrage['nummer'];
|
|
$sms_text=utf8_encode ($abfrage['text'] );
|
|
$req_data = array('authToken' => $_SESSION['AuthToken'],'recipients' => $sms_nummer,'message' => $sms_text,'encoding' => 0,'smsConnectorId' => 0,'store'=>true);
|
|
$ergebnis = $mysms->ApiCall('json', '/remote/sms/send', $req_data);
|
|
|
|
//-----------------------------------------------------------
|
|
|
|
$jsonrow=json_decode($ergebnis);
|
|
|
|
if($jsonrow->errorCode==0) {
|
|
//-------- if lein fehler oder msageid >0 dann schreiben 8 in datenbank oder halt fehler
|
|
// echo $ergebnis;
|
|
$GLOBALS['mysql']->insert("UPDATE log_sms SET status=8 WHERE smsID='".$abfrage['smsID']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE log_sms SET messageId='".$jsonrow->remoteSmsSendAcks[0]->messageId."' WHERE smsID='".$abfrage['smsID']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE log_sms SET errorId='".$jsonrow->errorCode."' WHERE smsID='".$abfrage['smsID']."' ");
|
|
if($abfrage['tId']>0) {
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatus=8 WHERE id='".$abfrage['tId']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsid='".$jsonrow->remoteSmsSendAcks[0]->messageId."' WHERE id='".$abfrage['tId']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET smsstatusdate='".$smstime."' WHERE id='".$abfrage['tId']."'");
|
|
}
|
|
} else {
|
|
$GLOBALS['mysql']->insert("UPDATE log_sms SET errorzahl='".$abfrage['errorzahl']."' WHERE smsID='".$abfrage['smsID']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE log_sms SET errorId='".$jsonrow->errorCode."' WHERE smsID='".$abfrage['smsID']."' ");
|
|
}
|
|
sleep (10);
|
|
}
|
|
}
|
|
//mysql_close($GLOBALS['mysql']);
|
|
|
|
//--------------------------------------------------------------------------------- saso copy ------------------------------------------
|
|
$jahr = (int)date('Y');
|
|
$kw = (int)date('W');
|
|
// $saso = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE kw='".$kw."' AND jahr='".$jahr."' AND typ=19 AND erl>80 limit 1");
|
|
$saso = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE kw='".$kw."' AND jahr='".$jahr."' AND typ=19 AND erl>80");
|
|
if($saso['num_rows'] != 0) {
|
|
$rasql = new mysql(CONFIG_RASQL_HOST,CONFIG_RASQL_USER,CONFIG_RASQL_PW,CONFIG_RASQL_DB);
|
|
$sdata = $rasql->query_single("SELECT * FROM tliste WHERE kw='".$kw."' AND jahr='".$jahr."' AND tour='".$saso['tour'] ."'");
|
|
if($sdata['num_rows'] != 0) {
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET Norm='".$sdata['norm']."' WHERE id='".$saso['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET Pakete='".$sdata['pakete']."' WHERE id='".$saso['id']."'");
|
|
if ($saso['pakete2']==0) {
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET pakete2='".$sdata['pakete']."' WHERE id='".$saso['id']."'");
|
|
}
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET exemplare='".$sdata['exemplare']."' WHERE id='".$saso['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET gewicht3='".$sdata['gewicht']."' WHERE id='".$saso['id']."'");
|
|
// $GLOBALS['mysql']->insert("UPDATE tourenliste SET erl='".$sdata['ablock']."' WHERE id='".$saso['id']."'");
|
|
if ($saso['gewicht']==0) {
|
|
$temp=$sdata['gewicht']+($sdata['amtsblatt']*0.068);
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET gewicht='".$temp."' WHERE id='".$saso['id']."'");
|
|
$gew2=$sdata['gewicht'] /$sdata['pakete'];
|
|
$gew5=$temp/$sdata['pakete'];
|
|
}
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET gewicht2='".$gew2."' WHERE id='".$saso['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET gewicht5='".$gew5."' WHERE id='".$saso['id']."'");
|
|
if($sdata['amtsblatt'] != 0) {
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET amtsblatt='".$sdata['amtsblatt']."' WHERE id='".$saso['id']."'");
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET abnorm='".$sdata['abnorm']."' WHERE id='".$saso['id']."'");
|
|
}
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET zeit='".$sdata['zeit']."' WHERE id='".$saso['id']."'");
|
|
|
|
//---------------------------------------------------------------------------------
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET erl='".$sdata['ablock']."' WHERE id='".$saso['id']."'");
|
|
} else {
|
|
$GLOBALS['mysql']->insert("UPDATE tourenliste SET erl=0 WHERE id='".$saso['id']."'");
|
|
}
|
|
echo "noch SaSo zu prüfen: ".$saso['num_rows'];
|
|
// echo'<pre>'; print_r($sdata); echo'</pre>';
|
|
}
|
|
//--------------------------------------------------------------------------------- saso copy ------------------------------------------
|
|
|
|
|
|
|
|
|
|
|
|
|
|
//------------------------------------------------------------------ Polizeimeldungen
|
|
$GLOBALS['mysql']->insert("UPDATE verkehr_polizei SET status=7 WHERE status=2 ");
|
|
$GLOBALS['mysql']->insert("UPDATE verkehr_polizei SET status=6 WHERE status=1 ");
|
|
|
|
$pmeld='https://cdn3.atudo.net/api/4.0/pois.php?type=vwd,traffic&z=50&box=51.201291,11.919478999999999,51.512161,13.226166';
|
|
$html = file_get_contents($pmeld);
|
|
$jsonrow=json_decode($html);
|
|
// echo "<pre>"; print_r($jsonrow); echo "</pre>";
|
|
|
|
for($i=0; $i < 100; $i++) {
|
|
if(isset($jsonrow->pois[$i])) {
|
|
if($jsonrow->pois[$i]->style!=0) {
|
|
$lat=($jsonrow->pois[$i]->lat); //MeldungsID
|
|
//$test=str_replace('.',',', $lat);
|
|
$vdata = $GLOBALS['mysql']->query_single("SELECT * FROM verkehr_polizei WHERE lat='".$lat."'");
|
|
|
|
if($vdata['num_rows']!= 0) {
|
|
$reason=utf8_decode($jsonrow->pois[$i]->reason); //Textupdate
|
|
$GLOBALS['mysql']->insert("UPDATE verkehr_polizei SET reason='".$reason."' WHERE id='".$vdata['id']."'");
|
|
$confirm=($jsonrow->pois[$i]->confirm_date); //bestätigungszeit
|
|
if($vdata['status']== 6) { $GLOBALS['mysql']->insert("UPDATE verkehr_polizei SET status=1 WHERE id='".$vdata['id']."'"); }
|
|
if($vdata['status']== 7) { $GLOBALS['mysql']->insert("UPDATE verkehr_polizei SET status=2 WHERE id='".$vdata['id']."'"); }
|
|
} else {
|
|
$bid=($jsonrow->pois[$i]->id);
|
|
$lat=($jsonrow->pois[$i]->lat);
|
|
$lng=($jsonrow->pois[$i]->lng);
|
|
$street=utf8_decode($jsonrow->pois[$i]->street);
|
|
$reason=utf8_decode($jsonrow->pois[$i]->reason);
|
|
$strasse=utf8_decode($jsonrow->pois[$i]->LocationLocRoadNumber);
|
|
$ort=utf8_decode($jsonrow->pois[$i]->address->city);
|
|
$counter=($jsonrow->pois[$i]->counter); //counter
|
|
$status=1;
|
|
|
|
$GLOBALS['mysql']->insert("INSERT INTO verkehr_polizei (bid,lat,lng,adresse1,adresse2,street,reason,counter,status)
|
|
VALUES(
|
|
'".$bid."',
|
|
'".$lat."',
|
|
'".$lng."',
|
|
'".$ort."',
|
|
'".$strasse."',
|
|
'".$street."',
|
|
'".$reason."',
|
|
'".$counter."',
|
|
'".$status."')
|
|
");
|
|
}
|
|
}
|
|
} else {
|
|
break;
|
|
}
|
|
}
|
|
//----------------------------------------------------------------------------------------------------------
|
|
$GLOBALS['mysql']->query("DELETE FROM verkehr_polizei WHERE status=8");
|
|
$GLOBALS['mysql']->query("DELETE FROM verkehr_polizei WHERE status=9");
|
|
//----------------------------------------------------------------------------------------------------------
|
|
$GLOBALS['mysql']->insert("UPDATE verkehr_polizei SET status=9 WHERE status=7 ");
|
|
$GLOBALS['mysql']->insert("UPDATE verkehr_polizei SET status=8 WHERE status=6 ");
|
|
//----------------------------------------------------------------------------------------------------------
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
?>
|