query_array("SELECT * FROM planer WHERE tag='".$tag1_tag."' AND monat='".$tag1_monat."' AND jahr='".$tag1_jahr."'");
$a_planb_f = $GLOBALS['mysql']->query_array("SELECT * FROM fplaner WHERE tag='".$tag1_tag."' AND monat='".$tag1_monat."' AND jahr='".$tag1_jahr."'");
//****************** VAR ******************
$summe=0; $key=0; $n=0; $fertig=0; $sms=0; $aktiv=0; $c=0; $smses=0; $smses2=0; $smse=array(); $smse2=array(); $fehler19=0; $fertig19=0;
//*****************************************
//***************** Heute *****************
//*****************************************
$smss=array();
$smss=array(0=>0,1=>0,2=>0,3=>0,4=>0,5=>0,10=>0,11=>0,12=>0,13=>0,14=>0,15=>0);
$icon=array();
$icon=array(11=>0,12=>0,13=>0,14=>0,15=>0,21=>0,22=>0,23=>0,24=>0,25=>0,31=>0,32=>0,33=>0,34=>0,35=>0,41=>0,42=>0,43=>0,44=>0,45=>0);
for ($i = 111; $i <= 115; $i++) { $icon[$i]='#115270'; }
for ($i = 121; $i <= 125; $i++) { $icon[$i]='#115270'; }
for ($i = 131; $i <= 135; $i++) { $icon[$i]='#115270'; }
for ($i = 141; $i <= 145; $i++) { $icon[$i]='#115270'; }
// echo''; print_r($icon); echo'
';
//*****************************************
//***************** menue Quckbutton
$db=$GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$tag1_tag."' and monat='".$tag1_monat."' and jahr='".$tag1_jahr."' ORDER BY id");
while($row = $db->fetch_assoc()) {
$summe++; $n=0;
//---------------------------------------
//-------------------- Fahrer prüfen
if($row['fahrer']==0) { // kein Fahrer geplant
$n=1;
} else { // Fahrer auf Kalender prüfen
if (in_array($row['fahrer'], $a_planb_m)) {
$ma_pid = array_search($row['fahrer'], array_column($a_planb_m, 'mid'));
if (is_numeric($ma_pid)) {
$grund=$a_planb_m[$ma_pid]['grund'];
$pa_id= array_search($grund, array_column($a_planbz, 'id'));
if($a_planbz[$pa_id]['nichtda']== 1) { $n=1; } //nicht da
if($a_planbz[$pa_id]['nichtda']==88) { $n=1; } //keine N8-Tour
}
}
}
//-------------------- Fahrzeug prüfen
if($row['auto']==0) { // kein Fahrzeug geplant
$n=1;
} else {
if (in_array($row['auto'], $a_planb_f)) {
$fa_id = array_search($row['auto'], array_column($a_planb_f, 'fa_id'));
if (is_numeric($fa_id)) {
$grund=$a_planb_m[$ma_pid]['grund'];
$pa_id= array_search($grund, array_column($a_planbz, 'id'));
if($a_planbf[$fa_id]['aktiv']<2) { $n=1; }
}
}
}
//-------------------- sonder touren bzw nicht aktive Touren
$ta_id= array_search($row['tour'], array_column($a_touren, 'id'));
if ($a_touren[$ta_id]['aktiv']==0 ) {$aktiv++; }
//-------------------- prüfen ob endgültig geplant
if($row['smsstatus']!=0) { $fertig++; }
if($row['smsstatus']==2) { $sms++; }
$c='#115270';
if ($n>0) { $c='#9c0000'; } //rot
elseif ($fertig==0) { $c='#ff8800'; } // gelb/orange
elseif ($fertig==$sms && $aktiv==0) { $c='#358d2f'; } // grün komplett fertig
elseif ($fertig==$sms && $aktiv> 0) { $c='#6495ed'; } // blau -- fertig Fremdtouren aktiv
elseif ($fertig>0 && $aktiv==0) { $c='#358d2f'; } // grün komplett sms fehler
elseif ($fertig>0 && $aktiv> 0) { $c='#6495ed'; } // blau -- fertig Fremdtouren aktiv sms fehler
//-------------------- SMS Fehler
if($row['smsstatus']==3 OR $row['smsstatus']==4 OR $row['smsstatus']==5) {
$smses++;
$smst = $GLOBALS['mysql']->query_single("SELECT * FROM log_sms WHERE messageId='".$row['smsid']."'");
$smse[$smses]['name']=$smst['e_name'];
$smse[$smses]['date']=$smst['statusdate'];
$smse[$smses]['msg'] =$smst['text'];
}
//-------------------- SMS status
if($row['smsstatus']==0) { $smss[0]++; }
if($row['smsstatus']==20) { $smss[1]++; }
if($row['smsstatus']==3) { $smss[2]++; }
if($row['smsstatus']==4) { $smss[2]++; }
if($row['smsstatus']==5) { $smss[2]++; }
if($row['smsstatus']==6) { $smss[2]++; }
if($row['smsstatus']==8) { $smss[3]++; }
if($row['smsstatus']==1) { $smss[4]++; }
if($row['smsstatus']==2) { $smss[5]++; }
//$template->assign('ss' , $smss);
if($row['typ']==3) { $icon[11]++; $icon[12]++; $icon[111]=$c; $icon[112]=$c; }
if($row['typ']==4) { $icon[11]++; $icon[13]++; $icon[111]=$c; $icon[113]=$c; }
if($row['typ']==5) { $icon[11]++; $icon[15]++; $icon[111]=$c; $icon[115]=$c; }
if($row['typ']==6) { $icon[21]++; $icon[22]++; $icon[121]=$c; $icon[122]=$c; }
if($row['typ']==12) { $icon[25]++; $icon[125]=$c; }
if($row['typ']==16) { $icon[21]++; $icon[22]++; $icon[121]=$c; $icon[122]=$c; }
if($row['typ']==17) { $icon[11]++; $icon[14]++; $icon[111]=$c; $icon[114]=$c; }
if($row['typ']==19) { $icon[25]++; $icon[125]=$c; }
if($row['typ']==20) { $icon[11]++; $icon[24]++; $icon[121]=$c; $icon[124]=$c; }
if($row['typ']==21) { $icon[11]++; $icon[24]++; $icon[121]=$c; $icon[124]=$c; }
if($row['typ']==1) { $icon[11]++; $icon[23]++; $icon[121]=$c; $icon[123]=$c; }
}
$template->assign('t1c' , '#ffffff');
//$template->assign('t1c' , '#ffffff');
//*****************************************
//***************** Morgen ****************
//*****************************************
//***************** menue Quckbutton
$db=$GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$tag2_tag."' and monat='".$tag2_monat."' and jahr='".$tag2_jahr."' ORDER BY id");
$summe=0; $key=0; $n=0; $fertig=0; $sms=0; $aktiv=0; $anzeige=0;
while($row = $db->fetch_assoc()) {
$summe++; $n=0;
//---------------------------------------
//-------------------- Fahrer prüfen
if($row['fahrer']==0) { // kein Fahrer geplant
$n=1;
} else { // Fahrer auf Kalender prüfen
if (in_array($row['fahrer'], $a_planb_m)) {
$ma_pid = array_search($row['fahrer'], array_column($a_planb_m, 'mid'));
if (is_numeric($ma_pid)) {
$grund=$a_planb_m[$ma_pid]['grund'];
$pa_id= array_search($grund, array_column($a_planbz, 'id'));
if($a_planbz[$pa_id]['nichtda']== 1) { $n=1; } //nicht da
if($a_planbz[$pa_id]['nichtda']==88) { $n=1; } //keine N8-Tour
}
}
}
//-------------------- Fahrzeug prüfen
if($row['auto']==0) { // kein Fahrzeug geplant
$n=1;
} else {
if (in_array($row['auto'], $a_planb_f)) {
$fa_id = array_search($row['auto'], array_column($a_planb_f, 'fa_id'));
if (is_numeric($fa_id)) {
$grund=$a_planb_m[$ma_pid]['grund'];
$pa_id= array_search($grund, array_column($a_planbz, 'id'));
if($a_planbf[$fa_id]['aktiv']<2) { $n=1; }
}
}
}
//-------------------- sonder touren bzw nicht aktive Touren
$ta_id= array_search($row['tour'], array_column($a_touren, 'id'));
if ($a_touren[$ta_id]['aktiv']==0 ) {$aktiv++; }
//-------------------- prüfen ob endgültig geplant
if($row['smsstatus']!=0) { $fertig++; }
if($row['smsstatus']==2) { $sms++; }
$c=0;
if ($n>0) { $c='#9c0000'; } //rot
elseif ($fertig==0) { $c='#ff8800'; } // gelb/orange
elseif ($fertig==$sms && $aktiv==0) { $c='#358d2f'; } // grün komplett fertig
elseif ($fertig==$sms && $aktiv> 0) { $c='#6495ed'; } // blau -- fertig Fremdtouren aktiv
elseif ($fertig>0 && $aktiv==0) { $c='#358d2f'; } // grün komplett sms fehler
elseif ($fertig>0 && $aktiv> 0) { $c='#6495ed'; } // blau -- fertig Fremdtouren aktiv sms fehler
//-------------------- SMS Fehler
if($row['smsstatus']==3 OR $row['smsstatus']==4 OR $row['smsstatus']==5) {
$smses2++;
$smst2 = $GLOBALS['mysql']->query_single("SELECT * FROM log_sms WHERE messageId='".$row['smsid']."'");
$smse2[$smses2]['name']=$smst2['e_name'];
$smse2[$smses2]['date']=$smst2['senddate'];
$smse2[$smses2]['msg'] =$smst2['text'];
} //echo''; print_r($smst); echo'
'; echo $smses;
//-------------------- SMS status
if($row['smsstatus']==0) { $smss[10]++; }
if($row['smsstatus']==20) { $smss[11]++; }
if($row['smsstatus']==3) { $smss[12]++; }
if($row['smsstatus']==4) { $smss[12]++; }
if($row['smsstatus']==5) { $smss[12]++; }
if($row['smsstatus']==6) { $smss[12]++; }
if($row['smsstatus']==8) { $smss[13]++; }
if($row['smsstatus']==1) { $smss[14]++; }
if($row['smsstatus']==2) { $smss[15]++; }
if($row['typ']==3) { $icon[31]++; $icon[32]++; $icon[131]=$c; $icon[132]=$c; }
if($row['typ']==4) { $icon[31]++; $icon[33]++; $icon[131]=$c; $icon[133]=$c; }
if($row['typ']==5) { $icon[31]++; $icon[35]++; $icon[131]=$c; $icon[135]=$c; }
if($row['typ']==6) { $icon[41]++; $icon[42]++; $icon[141]=$c; $icon[142]=$c; }
if($row['typ']==12) { $icon[45]++; $icon[145]=$c; }
if($row['typ']==16) { $icon[41]++; $icon[42]++; $icon[141]=$c; $icon[142]=$c; }
if($row['typ']==17) { $icon[31]++; $icon[34]++; $icon[131]=$c; $icon[134]=$c; }
if($row['typ']==19) { $icon[45]++; $icon[145]=$c; }
if($row['typ']==20) { $icon[41]++; $icon[44]++; $icon[141]=$c; $icon[144]=$c; }
if($row['typ']==21) { $icon[41]++; $icon[44]++; $icon[141]=$c; $icon[144]=$c; }
if($row['typ']== 1) { $icon[41]++; $icon[43]++; $icon[141]=$c; $icon[143]=$c; }
}
$template->assign('icon' , $icon);
$template->assign('smse' , $smse);
$template->assign('smses' , $smses);
$template->assign('smse2' , $smse2);
$template->assign('smses2' , $smses2);
$template->assign('ss', $smss);
$template->assign('t2c' , "#ffffff");
$template->assign('t2c' , "#ffffff");
//-----------------------------------------------------------------------------------------------------------------------------
$date=date('d').'.'.date('m').'.'.date('Y').'%';
$date2=date('d').'.'.date('m').'.'.date('Y');
$datex=strtotime("-1 day"); $datea=date('d',$datex).'.'.date('m',$datex).'.'.date('Y',$datex);
//-----------------------------------------------------------------------------------------------------------------------------
//--------------------------------------------------------------------------------------------------- ILONEXS -----------------
//-----------------------------------------------------------------------------------------------------------------------------
//--- Vortag ---
$ilotest1=$GLOBALS['mysql']->summe("SELECT * FROM ilonexs WHERE date='".$datea."' and status!=0");
$template->assign('ilotest1', $ilotest1);
if($ilotest1!=0) {
$ilod1=$GLOBALS['mysql']->sql("SELECT * FROM ilonexs WHERE date='".$datea."' and status!=0 ORDER BY datum DESC Limit 200");
while($row = $ilod1->fetch_assoc()) {
$idb1[$key]['id'] = $row['id'];
$idb1[$key]['status'] = $row['status'];
$idb1[$key]['datum'] = $row['datum'];
$idb1[$key]['collie'] = $row['collie'];
$idb1[$key]['statustext1']= $row['statustext1'];
$iloname=substr($row['name'],0,26);
$idb1[$key]['name'] = $iloname;
$key++;
}
$template->assign('idata1', $idb1);
}
//-----------------------------------------------------------------------------------------------------------------------------
//------- Hauptfenster Fehler
$ilotest2=$GLOBALS['mysql']->summe("SELECT * FROM ilonexs WHERE date='".$date2."' and status NOT IN (0,50,210,290)");
$template->assign('ilotest2', $ilotest2);
if($ilotest2!=0) {
$ilod2=$GLOBALS['mysql']->sql("SELECT * FROM ilonexs WHERE date='".$date2."' and status NOT IN (0,50,210,290) ORDER BY datum DESC Limit 200");
while($row = $ilod2->fetch_assoc()) {
$idb2[$key]['id'] = $row['id'];
$idb2[$key]['status'] = $row['status'];
$idb2[$key]['datum'] = $row['datum'];
$idb2[$key]['statustext1']= $row['statustext1'];
$iloname=substr($row['name'],0,25);
$idb2[$key]['name'] = $iloname;
$key++;
}
$template->assign('idata2', $idb2);
}
//-----------------------------------------------------------------------------------------------------------------------------
//------- Hauptfenster Fehler
$ilotest3=$GLOBALS['mysql']->summe("SELECT * FROM ilonexs WHERE date='".$date2."' and status=0");
$template->assign('ilotest3', $ilotest3);
if($ilotest3!=0) {
$ilod3=$GLOBALS['mysql']->sql("SELECT * FROM ilonexs WHERE date='".$date2."' and status=0 ORDER BY datum DESC Limit 200");
while($row = $ilod3->fetch_assoc()) {
$idb3[$key]['id'] = $row['id'];
$idb3[$key]['status'] = $row['status'];
$idb3[$key]['datum'] = $row['datum'];
$idb3[$key]['statustext1']= $row['statustext1'];
$iloname=substr($row['name'],0,25);
$idb3[$key]['name'] = $iloname;
$key++;
}
$template->assign('idata3', $idb3);
}
//--- Ilonexs nextday ---
$ilotest4=$GLOBALS['mysql']->summe("SELECT * FROM ilonexs WHERE date='".$date2."' and status in (11,50,210,290)");
$template->assign('ilotest4', $ilotest4);
if($ilotest4!=0) {
$ilod4=$GLOBALS['mysql']->sql("SELECT * FROM ilonexs WHERE date='".$date2."' and status in (11,50,210,290) ORDER BY datum DESC Limit 200");
while($row = $ilod4->fetch_assoc()) {
$idb4[$key]['id'] = $row['id'];
$idb4[$key]['status'] = $row['status'];
$idb4[$key]['datum'] = $row['datum'];
$idb4[$key]['collie'] = $row['collie'];
$idb4[$key]['statustext1']= $row['statustext1'];
$iloname=substr($row['name'],0,26);
$idb4[$key]['name'] = $iloname;
$key++;
}
$template->assign('idata4', $idb4);
}
//-----------------------------------------------------------------------------------------------------------------------------
//--------------------------------------------------- Normplan heute
$nptest1 = $GLOBALS['mysql']->summe("SELECT * FROM normplan WHERE tag='".$tag1_tag."' AND monat='".$tag1_monat."' AND jahr='".$tag1_jahr."'");
if ($nptest1!=0) {
$nplan1 = $GLOBALS['mysql']->query_single("SELECT * FROM normplan WHERE tag='".$tag1_tag."' AND monat='".$tag1_monat."' AND jahr='".$tag1_jahr."'");
} else { $nplan1=array('lvz_city'=>0,'lvz_bgz'=>0,'lvz_dek'=>0,'lvz_mtk'=>0,'tz'=>0,'daz'=>0,'ovz'=>0,'dnn'=>0); }
$template->assign('np1',$nplan1);
//--------------------------------------------------- Normplan heute
$nptest2 = $GLOBALS['mysql']->summe("SELECT * FROM normplan WHERE tag='".$tag2_tag."' AND monat='".$tag2_monat."' AND jahr='".$tag2_jahr."'");
if ($nptest2!=0) {
$nplan2 = $GLOBALS['mysql']->query_single("SELECT * FROM normplan WHERE tag='".$tag2_tag."' AND monat='".$tag2_monat."' AND jahr='".$tag2_jahr."'");
} else { $nplan2=array('lvz_city'=>0,'lvz_bgz'=>0,'lvz_dek'=>0,'lvz_mtk'=>0,'tz'=>0,'daz'=>0,'ovz'=>0,'dnn'=>0); }
$template->assign('np2',$nplan2);
//-----------------------------------------------------------------------------------------------------------------------------
$test1 = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE tag='".$tag1_tag."' AND monat='".$tag1_monat."' AND jahr='".$tag1_jahr."'");
$key=0;
while($row = $test1->fetch_assoc()) {
$maf1[$key]['fahrer'] = $_SESSION['ma_all'][$row['mid']]['name'];
$maf1[$key]['bez'] = $_SESSION['pbz'][$row['grund']]['bez'];
$maf1[$key]['icon'] = $_SESSION['pbz'][$row['grund']]['fa'];
$maf1[$key]['na'] = $_SESSION['pbz'][$row['grund']]['nichtda'];
$maf1[$key]['info']=$row['info'];
$key++;
}
$bday = $GLOBALS['mysql']->query("SELECT * FROM mitarbeiter WHERE gebtag='".$tag1_tag."' AND aktiv>0 AND gebmonat='".$tag1_monat."'");
while($row = $bday->fetch_assoc()) {
$maf1[$key]['fahrer']=$row['name'];
$jahre=$tag1_jahr-$row['gebjahr'];
$maf1[$key]['bez']=$jahre.". Geburtstag";
$maf1[$key]['icon']="fal fa-birthday-cake";
$key++;
}
$auto = $GLOBALS['mysql']->query("SELECT * FROM fplaner WHERE tag='".$tag1_tag."' AND monat='".$tag1_monat."' AND jahr='".$tag1_jahr."'");
while($row = $auto->fetch_assoc()) {
$maf1[$key]['fahrer'] = $_SESSION['car'][$row['fid']]['kz'];
$maf1[$key]['bez'] = $_SESSION['fbz'][$row['grund']]['bez'];
$maf1[$key]['icon'] = $_SESSION['fbz'][$row['grund']]['fa'];
$maf1[$key]['na'] = $_SESSION['fbz'][$row['grund']]['aktiv'];
$maf1[$key]['info']=$row['info'];
$key++;
}
$template->assign('kal1', $maf1);
//-----------------------------------------------------------------------------------------------------------------------------
$test2 = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE tag='".$tag2_tag."' AND monat='".$tag2_monat."' AND jahr='".$tag2_jahr."'");
$key=0;
while($row = $test2->fetch_assoc()) {
$maf2[$key]['fahrer'] = $_SESSION['ma_all'][$row['mid']]['name'];
$maf2[$key]['bez'] = $_SESSION['pbz'][$row['grund']]['bez'];
$maf2[$key]['icon'] = $_SESSION['pbz'][$row['grund']]['fa'];
$maf2[$key]['na'] = $_SESSION['pbz'][$row['grund']]['nichtda'];
$maf2[$key]['info']=$row['info'];
$key++;
}
$bday = $GLOBALS['mysql']->query("SELECT * FROM mitarbeiter WHERE gebtag='".$tag2_tag."' AND aktiv>0 AND gebmonat='".$tag2_monat."'");
while($row = $bday->fetch_assoc()) {
$maf2[$key]['fahrer']=$row['name'];
$jahre=$tag2_jahr-$row['gebjahr'];
$maf2[$key]['bez']=$jahre.". Geburtstag";
$maf2[$key]['icon']="fal fa-birthday-cake";
$key++;
}
$auto = $GLOBALS['mysql']->query("SELECT * FROM fplaner WHERE tag='".$tag2_tag."' AND monat='".$tag2_monat."' AND jahr='".$tag2_jahr."'");
while($row = $auto->fetch_assoc()) {
$maf2[$key]['fahrer'] = $_SESSION['car'][$row['fid']]['kz'];
$maf2[$key]['bez'] = $_SESSION['fbz'][$row['grund']]['bez'];
$maf2[$key]['icon'] = $_SESSION['fbz'][$row['grund']]['fa'];
$maf2[$key]['na'] = $_SESSION['fbz'][$row['grund']]['aktiv'];
$maf2[$key]['info']=$row['info'];
$key++;
}
$template->assign('kal2', $maf2);
//------------------------------------------------------------- Polizei-Meldungen --
$pdata = $GLOBALS['mysql']->query_array("SELECT * FROM verkehr_polizei");
$template->assign('pol_data', $pdata);
//----------------------------------------------------------------------------------
//---------------- Status -----------------
$anlage = $GLOBALS['mysql']->query("SELECT * FROM kartenlog ORDER BY logID DESC LIMIT 0,5"); $key=0; $anz=0;
while($row_anlage = $anlage->fetch_assoc()) {
$status[$key]['fahrer'] = $_SESSION['ma_all'][$row_anlage['user']]['name'];
$status[$key]['zeit']=$row_anlage['zeit'];
if ($row_anlage['zeit']>time()-(1800)) { $anz=1; }
if ($row_anlage['zeit']>time()-(300)) { $anz=2; }
$key++;
}
$template->assign('anz', $anz);
$template->assign('status', $status);
$template->assign('zeit_online',time()-(1800));
$template->assign('zeit_live',time()-(300));
//------------------------- estatus - letzte fehlereinlese ----------
$eanlage = $GLOBALS['mysql']->query("SELECT * FROM kartenerror WHERE user=0 ORDER BY logID DESC LIMIT 0,5"); $key=0;
while($row_eanlage = $eanlage->fetch_assoc()) {
$estatus[$key]['zeit']=$row_eanlage['zeit'];
$estatus[$key]['karte']=$row_eanlage['karte'];
$key++;
}
//------------------------- Wetter sonnen Auf/Untergang ----------
$system = $GLOBALS['mysql']->query_single("SELECT * FROM system WHERE id=1"); $template->assign('system', $system);
//------------------------- estatus - letzte fehlereinlese ---------------------------------------------------------
$uanlage = $GLOBALS['mysql']->query("SELECT * FROM kartenerror WHERE user>0 ORDER BY logID DESC LIMIT 0,3"); $key=0;
while($row_uanlage = $uanlage->fetch_assoc()) {
$ustatus[$key]['fahrer'] = $_SESSION['ma_all'][$row_uanlage['user']]['name'];
$ustatus[$key]['grund']=$row_uanlage['grund'];
$ustatus[$key]['zeit']=$row_uanlage['zeit'];
$key++;
}
//-------------------------------------------------------------------------------------------------------------------
$abfrage_monline = $GLOBALS['mysql']->query_array("SELECT * FROM benutzer WHERE session_update>0 and id>0 and id!=2 ORDER BY session_update DESC LIMIT 0,5");
$template->assign('abfrage_monline', $abfrage_monline);
//-------------------------------------------------------------------------------------------------------------------
$abfrage_conline = $GLOBALS['mysql']->query("SELECT * FROM karten WHERE status <9 AND status >1 ORDER BY status ASC LIMIT 0,5"); $key=0;
while($row = $abfrage_conline->fetch_assoc()) {
//$abfrage_c[$key]['fahrer'] = $_SESSION['ma_all'][$row['user']]['name'];
$abfrage_c[$key]['name'] = $_SESSION['ma_all'][$row['user']]['name'];
$abfrage_c[$key]['status']=$row['status'];
$abfrage_c[$key]['etime']=$row['edittime'];
$abfrage_c[$key]['lastlog']=$row['lastlog'];
$abfrage_c[$key]['grund']=$row['grund'];
if($row['lastlog']>=$row['edittime']) {
$abfrage_c[$key]['ontour']=1;
} else {
$abfrage_c[$key]['ontour']=0;
}
$key++;
}
$template->assign('abfrage_c', $abfrage_c);
//---------------------------------------------------------------------------------------------------------------------
$template->assign('smssumme', $GLOBALS['mysql']->summe("SELECT * FROM log_sms WHERE sender_id=1"));
$smsnr=$GLOBALS['mysql']->summe("SELECT * FROM log_sms WHERE incoming=1 and gelesen=0"); $template->assign('smsnread', $smsnr);
$template->assign('phonedata',$GLOBALS['mysql']->query_single("SELECT * FROM gateway WHERE id=1"));
//---------------------------------------------------------------------------------------------------------------------
//-------------------------------------------- zeitstempel für Sani und HU
$temptime=time(); $temptime=$temptime+2678400;
//------------------ sanikasten und HU neu 2024 ------------------------------------------------------------------------------------------------
$tdata = $GLOBALS['mysql']->query("SELECT * FROM fahrzeuge WHERE aktiv>0 and besitz<3 ORDER BY kz"); $key=0; $sum=0; $x=0;
while($row = $tdata->fetch_assoc()) {
if($key!=10) {
$x=0;
$sanihu[$key]['kz']=$row['kz'];
if($row['sanidate']<=time()) {
$x=1;
if($row['sanidate']<=$temptime) { $sanihu[$key]['anz1']=2; }
if($row['sanidate']<=time()) { $sanihu[$key]['anz1']=1; }
} else { $sanihu[$key]['anz1']=8; }
//---------- HU
if($row['hudate']<=time()) {
$x=1;
if($row['hudate']<=$temptime) { $sanihu[$key]['anz2']=2; }
if($row['hudate']<=time()) { $sanihu[$key]['anz2']=1; }
} else { $sanihu[$key]['anz2']=8; }
if($x!=0) {
$sanihu[$key]['sanidate']=$row['sanidate'];
$sanihu[$key]['hudate']=$row['hudate'];
$key++;
}
}
}
// echo''; print_r($sanihu); echo'
'; echo $smses;
if($key!=0) { $template->assign('sanihu', $sanihu); }
//----------------------------------------------------------------------------------------------------------------------------------------------
$kfzcar = $GLOBALS['mysql']->query("SELECT * FROM fplaner WHERE tag='".$tag1_tag."' AND monat='".$tag1_monat."' AND jahr='".$tag1_jahr."' ORDER BY pid DESC LIMIT 0,5"); $key=0;
while($row = $kfzcar->fetch_assoc()) {
$kcar[$key]['kz'] = $_SESSION['car'][$row['fid']]['kz'];
$kcar[$key]['info'] = $row['info'];
$kcar[$key]['bez'] = $_SESSION['fbz'][$row['grund']]['bez'];
$kcar[$key]['na'] = $_SESSION['fbz'][$row['grund']]['aktiv'];
$kcar[$key]['info']=$row['info'];
$key++;
}
if (isset($kcar)) { $template->assign('kfzcar', $kcar); }
//----------------------------------------------------------------------------------------------------------------------------------------------
$abfrage = $GLOBALS['mysql']->query_single("SELECT * FROM tanken WHERE anzid>0");
$zufall=rand(1,$abfrage['num_rows']);
$tank = $GLOBALS['mysql']->query_single("SELECT * FROM tanken WHERE anzid='".$zufall."'");
$tankdata['kname']=$tank['kname'];
$tankdata['street']=$tank['street'];
$diesel=$tank['diesel'];
$tankdata['diesel']=substr($diesel, 0, -1);
$tankdata['dieselx']=substr($diesel, -1, 1);
$template->assign('tankdata', $tankdata);
//----------------------------------------------------------------------------------------------------------------------------------------------
$key=0; $tmp=0; $pak=0; $fertig=0; $fehler=0;
$s19_tour = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE jahr='".$tag1_jahr."' and kw='".$kw."' and typ=19");
while($row = $s19_tour->fetch_assoc()) {
$tmp=$tmp+$row['gewicht4'];
$pak=$pak+$row['Pakete'];
$fertig=$fertig+$row['fertig'];
if ($row['gewicht3']!=0) { if ($row['fahrer']==0 || $row['auto']==0) { $fehler++; }}
$key++;
}
$tmp=$tmp/1000; $d19=round($tmp,1); $pa19=number_format($pak,-2,'','.'); $px19=' ';
$template->assign('ic19','#115270');
$template->assign('tc19','#115270');
if (isset($row['norm'])) { $temp=$pa19.' Pakete ('.$row['norm'].'er)'; $template->assign('p19',$temp); }
if ($fehler19>0) { $template->assign('ic19','#9c0000'); }
elseif ($fertig19!=0){ $template->assign('ic19','#358d2f'); }
elseif ($tmp!=0){ $template->assign('ic19','#ff8800'); }
elseif ($tmp!=0){ $template->assign('ic19','#ff8800'); }
else { $px19=' keine Daten.'; }
$template->assign('p19',$px19);
$template->assign('tc19','#666666');
if($key>0) {
//$d19=number_format($tmp,-2,'','.');
$template->assign('d19',$d19);
$template->assign('m19',$key);
}
//------------------------------------------------------------------------ anhänger
$tsdata = $GLOBALS['mysql']->query_single("SELECT * FROM verkehr WHERE type=9");
if($tsdata['num_rows'] != 0) {
$tdata = $GLOBALS['mysql']->query_array("SELECT * FROM verkehr WHERE type=9 ORDER BY type DESC");
$template->assign('ts_data', $tdata);
$template->assign('ts_anz', 1);
}
//---------------------------------------------------- mobile Blitzer ja/nein
$mbdata = $GLOBALS['mysql']->query_single("SELECT * FROM verkehr WHERE type in(0,1,2,3,4,5,6)");
if($mbdata['num_rows'] != 0) {
$mdata = $GLOBALS['mysql']->query_array("SELECT * FROM verkehr WHERE type in(0,1,2,3,4,5,6)");
$template->assign('mb_data', $mdata);
$template->assign('mb_anz', 1);
}
//-------------------------------------------------------------------------------------------------------------
//---------------------------------------------------- Verkersinfo ja/nein
$stdata = $GLOBALS['mysql']->query_single("SELECT * FROM verkehr WHERE type NOT in (0,1,2,3,4,5,6,9)");
$template->assign('st_anz', 0);
if($stdata['num_rows'] != 0) {
$sdata = $GLOBALS['mysql']->query_array("SELECT * FROM verkehr WHERE type NOT in(0,1,2,3,4,5,6,9)");
$template->assign('st_data', $sdata);
$template->assign('st_anz', 1);
}
//-------------------------------------------------------------------------------------------------------------
// Ilonexs
$datum=$tag1_tag.".".$tag1_monat.".".$tag1_jahr;
$ilodata1 = $GLOBALS['mysql']->summe("SELECT * FROM ilonexs WHERE date ='".$datum."'");
$template->assign('ilodata1',$ilodata1);
//-------------------------------------------------------------------------------------------------------------
// eingehende SMS
if($smsnr != 0) {
$smst = $GLOBALS['mysql']->sql("SELECT * FROM log_sms WHERE incoming=1 and gelesen=0"); $key=0;
while($row = $smst->fetch_assoc()) {
$smsxt[$key]['text'] = $row['text'];
$madata = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE handy='".$row['nummer']."'");
$smsxt[$key]['von'] = $madata['name'];
$key++;
}
$template->assign('smsnoread',$smsxt);
}
//-------------------------------------------------------------------------------------------------------------
$template->assign('status', $status);
$template->assign('estatus', $estatus);
$template->assign('ustatus', $ustatus);
//-------------------------------------------
$template->assign('t1bc', "#115270");
$template->assign('t1c' , "#ffffff");
$template->assign('t1', $tag1_tag);
$template->assign('mo1', $tag1_monat);
$template->assign('j1', $tag1_jahr);
$template->assign('t2', $tag2_tag);
$template->assign('mo2', $tag2_monat);
$template->assign('j2', $tag2_jahr);
$template->assign('tag1', $tag1);
$template->assign('datum', $tag1_tag.".".$tag1_monat.".".$tag1_jahr);
$template->assign('tag2', $tag2);
$template->assign('content', 'tpl/ajax/ue_h24.tpl');
?>