query_single("SELECT * FROM ilonexs WHERE status NOT IN (0,88,193) AND checkedv!=1");
//----------------------------------------------------------------------------------------------------------------
if($scandaten['num_rows']==0) {
$GLOBALS['mysql']->insert("UPDATE ilonexs SET checkedv=0 WHERE status!=0"); echo "reset wird ausgeführt!";
} else {
$GLOBALS['mysql']->insert("UPDATE ilonexs SET checkedv=1 WHERE id='".$scandaten['id']."'");
//----------------------------------------------------------------------------------------------------------------
echo "in bearbeitung: ".$scandaten['label']; echo "";
$url='https://api.ilonexs.de/php/schnittstellen_url.php?api=MbL~9X2kZU~&schnittstelle=4&belegnr='.$scandaten['label'].'&';
$headers = @get_headers($url);
if ($headers[0]!='HTTP/1.1 200 OK') { echo "Verbindungsfehler"; break; }
$xml = simplexml_load_file($url);
for ($i = 0; $i <= 100; $i++ ) {
if (strlen($xml->pod[$i]->liefername)<2) { echo 'Abbruch in Zeile: '.$i.''; break; }
$datum=substr($xml->pod[$i]->datum, 0, 10);
echo $datum."";
if (strlen($scandaten['name'])<2) {
$GLOBALS['mysql']->insert("UPDATE ilonexs SET name='".$xml->pod[$i]->liefername."' WHERE id='".$scandaten['id']."'");
$GLOBALS['mysql']->insert("UPDATE ilonexs SET plz='".$xml->pod[$i]->lieferplz."' WHERE id='".$scandaten['id']."'");
$GLOBALS['mysql']->insert("UPDATE ilonexs SET ort='".$xml->pod[$i]->lieferort."' WHERE id='".$scandaten['id']."'");
$GLOBALS['mysql']->insert("UPDATE ilonexs SET collie='".$xml->pod[$i]->collie."' WHERE id='".$scandaten['id']."'");
}
if (strlen($xml->pod[$i]->datum)>0) {
$GLOBALS['mysql']->insert("UPDATE ilonexs SET datum='".$xml->pod[$i]->datum."' WHERE id='".$scandaten['id']."'");
$GLOBALS['mysql']->insert("UPDATE ilonexs SET date='".$datum."' WHERE id='".$scandaten['id']."'");
}
if (strlen($xml->pod[$i]->status)>0) {
$GLOBALS['mysql']->insert("UPDATE ilonexs SET status='".$xml->pod[$i]->status."' WHERE id='".$scandaten['id']."'"); }
if (strlen($xml->pod[$i]->status)>0) {
$GLOBALS['mysql']->insert("UPDATE ilonexs SET statustext1='".$xml->pod[$i]->beschreibung."' WHERE id='".$scandaten['id']."'"); }
if (strlen($xml->pod[$i]->status)>0) {
$GLOBALS['mysql']->insert("UPDATE ilonexs SET scanort='".$xml->pod[$i]->scannort."' WHERE id='".$scandaten['id']."'"); }
$GLOBALS['mysql']->insert("UPDATE ilonexs SET empfaenger='".$xml->pod[$i]->empfaenger."' WHERE id='".$scandaten['id']."'");
echo '-'.$i.'';
if (strlen($xml->pod[$i]->status)>0) {
if ($xml->pod[$i]->status==0) {
break; echo '- Abbruch mit Status 0'.$i.'';
}
}
}
echo "---------------------------------------------------------";
}
/*
foreach($xml->pod as $xmldata) {
echo ""; print_r($xmldata); echo "
";
echo "---------------------------------------------------------";
if (strlen($scandaten['name'])<2) {
$temp=' '; $temp=$xmldata->liefername;
$GLOBALS['mysql']->insert("UPDATE ilonexs SET name='".$temp."' WHERE id='".$scandaten['id']."'");
$temp=' '; $temp=$xmldata->lieferplz;
$GLOBALS['mysql']->insert("UPDATE ilonexs SET plz='".$temp."' WHERE id='".$scandaten['id']."'");
$temp=' '; $temp=$xmldata->lieferort;
$GLOBALS['mysql']->insert("UPDATE ilonexs SET ort='".$temp."' WHERE id='".$scandaten['id']."'");
}
$temp=' '; $temp=$xmldata->datum; echo $temp."";
$GLOBALS['mysql']->insert("UPDATE ilonexs SET datum='".$temp=$xmldata->datum."' WHERE id='".$scandaten['id']."'");
$temp=' '; $temp=$xmldata->zweiteanfahrt; echo $temp."";
$GLOBALS['mysql']->insert("UPDATE ilonexs SET zweiteanfahrt='".$temp."' WHERE id='".$scandaten['id']."'");
$temp=' '; $temp=$xmldata->wartezeit; echo $temp."";
$GLOBALS['mysql']->insert("UPDATE ilonexs SET wartezeit='".$temp."' WHERE id='".$scandaten['id']."'");
$temp=' '; $temp=$xmldata->collie; echo $temp."";
$GLOBALS['mysql']->insert("UPDATE ilonexs SET collie='".$temp."' WHERE id='".$scandaten['id']."'");
$temp=' '; $temp=$xmldata->status; echo $temp."";
$GLOBALS['mysql']->insert("UPDATE ilonexs SET status='".$xmldata->status."' WHERE id='".$scandaten['id']."'");
$temp=' '; $temp=$xmldata->beschreibung; echo $temp."";
$GLOBALS['mysql']->insert("UPDATE ilonexs SET statustext1='".$temp."' WHERE id='".$scandaten['id']."'");
$temp=' '; $temp=$xmldata->scannort; echo $temp."";
$GLOBALS['mysql']->insert("UPDATE ilonexs SET scannort='".$temp."' WHERE id='".$scandaten['id']."'");
//----------------------------------------------------------------------------------------------------
}
}
//echo ""; print_r($xmldata); echo "
";
//echo ""; print_r($output); echo "
";
*/
?>