564 lines
No EOL
25 KiB
PHP
564 lines
No EOL
25 KiB
PHP
<?php
|
|
error_reporting(E_ALL); ini_set('display_errors', 0);
|
|
|
|
$tp1 = strtotime("+0 day"); $tag1 = date("d.m.Y", $tp1); $tag1_tag = date("d",$tp1); $tag1_monat = date("m",$tp1); $tag1_jahr = date("Y",$tp1);
|
|
$tp2 = strtotime("+1 day"); $tag2 = date("d.m.Y", $tp2); $tag2_tag = date("d",$tp2); $tag2_monat = date("m",$tp2); $tag2_jahr = date("Y",$tp2);
|
|
$kw = (int)date('W');
|
|
|
|
//-- wiederkehrende abfragen
|
|
$a_touren = $GLOBALS['a_touren'];
|
|
$a_fahrzg = $GLOBALS['a_fahrzg'];
|
|
$a_fahrer = $GLOBALS['a_fahrer'];
|
|
$a_planbz = $GLOBALS['a_planbz'];
|
|
$a_planbf = $GLOBALS['a_planbf'];
|
|
|
|
// noch prüfen
|
|
|
|
$a_planb_m = $GLOBALS['mysql']->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=[]; $smse2=[]; $fehler19=0;
|
|
//*****************************************
|
|
//***************** Heute *****************
|
|
//*****************************************
|
|
//***************** 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=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) {
|
|
$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'];
|
|
}
|
|
$smss=array();
|
|
$smss['0']=0; $smss['1']=0; $smss['2']=0; $smss['3']=0; $smss['4']=0; $smss['5']=0;
|
|
//-------------------- 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['21']++; $icon[24]++; $icon['121']=$c; $icon['124']=$c; }
|
|
if($row['typ']==21) { $icon['21']++; $icon[24]++; $icon['121']=$c; $icon['124']=$c; }
|
|
if($row['typ']==22) { $icon['21']++; $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'<pre>'; print_r($smst); echo'</pre>'; 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']==22) { $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('icon' , $icon);
|
|
$template->assign('ss', $smss);
|
|
$template->assign('t2c' , "#ffffff");
|
|
$template->assign('t2c' , "#ffffff");
|
|
|
|
//-----------------------------------------------------------------------------------------------------------------------------
|
|
//--------------------------------------------------- Normplan heute
|
|
$nplan1 = $GLOBALS['mysql']->query_single("SELECT * FROM normplan WHERE tag='".$tag1_tag."' AND monat='".$tag1_monat."' AND jahr='".$tag1_jahr."'");
|
|
$template->assign('np1',$nplan1);
|
|
//--------------------------------------------------- Normplan heute
|
|
$nplan2 = $GLOBALS['mysql']->query_single("SELECT * FROM normplan WHERE tag='".$tag2_tag."' AND monat='".$tag2_monat."' AND jahr='".$tag2_jahr."'");
|
|
$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 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"));
|
|
$template->assign('smsnread', $GLOBALS['mysql']->summe("SELECT * FROM log_sms WHERE incoming=1 and gelesen=0"));
|
|
$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 ----------------------------------------------------------------------------------------------------------------
|
|
$tempcar = $GLOBALS['mysql']->query("SELECT * FROM fahrzeuge WHERE aktiv>0 and besitz<3 and sanidate>1 ORDER BY kz"); $key=0; $wert=0; $sum=0;
|
|
while($row = $tempcar->fetch_assoc()) {
|
|
if($row['sanidate']<=$temptime) {
|
|
if($wert!=8) {
|
|
if ($wert % 2 != 0) {
|
|
$sanidata[$key]['kz1']=$row['kz']; $sanidata[$key]['sanidate1']=$row['sanidate'];
|
|
if($row['sanidate']<=time()) { $sanidata[$key]['typ1']=1; }else{ $sanidata[$key]['typ1']=2; $sanidata[$key]['anz']=1; } $key++;
|
|
} else {
|
|
$sanidata[$key]['kz2']=$row['kz']; $sanidata[$key]['sanidate2']=$row['sanidate'];
|
|
if($row['sanidate']<=time()) { $sanidata[$key]['typ2']=1; }else{ $sanidata[$key]['typ2']=2; $sanidata[$key]['anz']=0; }
|
|
}
|
|
$wert++;
|
|
}
|
|
$sum++;
|
|
}
|
|
}
|
|
if($key!=0) { $template->assign('sanidata', $sanidata); $template->assign('sanisum', $sum); }
|
|
//------------------ HU / AU -------------------------------------------------------------------------------------------------------------------
|
|
$tempcar2 = $GLOBALS['mysql']->query("SELECT * FROM fahrzeuge WHERE aktiv>0 and besitz<3 and hudate>1 ORDER BY kz"); $key=0; $wert=0; $sum=0;
|
|
while($row = $tempcar2->fetch_assoc()) {
|
|
if($row['hudate']<=time()) {
|
|
if($wert!=8) {
|
|
if ($wert % 2 != 0) {
|
|
$hudata[$key]['kz1']=$row['kz']; $hudata[$key]['hudate1']=$row['hudate'];
|
|
if($row['hudate']<=time()) { $hudata[$key]['typ1']=1; }else{ $hudata[$key]['typ1']=2; $hudata[$key]['anz']=1; } $key++;
|
|
} else {
|
|
$hudata[$key]['kz2']=$row['kz']; $hudata[$key]['hudate2']=$row['hudate'];
|
|
if($row['hudate']<=time()) { $hudata[$key]['typ2']=1; }else{ $hudata[$key]['typ2']=2; $hudata[$key]['anz']=0; }
|
|
}
|
|
$wert++;
|
|
}
|
|
$sum++;
|
|
}
|
|
}
|
|
if($key!=0) { $template->assign('hudata', $hudata); $template->assign('husum', $sum); }
|
|
//----------------------------------------------------------------------------------------------------------------------------------------------
|
|
$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++;
|
|
}
|
|
$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,'','.');
|
|
$template->assign('ic19','#666666');
|
|
$template->assign('tc19','#aaaaaa');
|
|
$template->assign('p19',$pa19.' Pakete ('.$row['norm'].'er)');
|
|
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 { $template->assign('p19',' keine Daten.'); $template->assign('tc19','#666666'); }
|
|
|
|
if($key>0) {
|
|
//$d19=number_format($tmp,-2,'','.');
|
|
$template->assign('d19',$d19);
|
|
$template->assign('m19',$key);
|
|
}
|
|
//----------------------------------------------------------------------------------------------------------------
|
|
$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"); $key=0;
|
|
$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)");
|
|
|
|
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);
|
|
}
|
|
//-------------------------------------------------------------------------------------------------------------
|
|
/*
|
|
$key=0; $time=time();
|
|
$cars=$GLOBALS['mysql']->query("SELECT * FROM fahrzeuge WHERE leasing!=0 ORDER BY kz");
|
|
while($row = $cars->fetch_assoc()) {
|
|
// Kennzeichen
|
|
$data[$key]['kz']=$row['kz'];
|
|
// km Laufzeit Berechnung
|
|
$ez = mktime(0, 0, 0, $row['jbmonat'], $row['jbtag'], $row['jbjahr']); $now =time();
|
|
$t1=$now-$ez; $t1=round($t1/86400); $t2=$row['leasing']/365;
|
|
$data[$key]['pkm']=$t1*$t2; $data[$key]['pkm']=round($data[$key]['pkm']);
|
|
//istkm ************* einmal auslesen
|
|
$tmp1=$GLOBALS['mysql']->query_single("SELECT * FROM fahrzeug_log WHERE utyp=3 AND fid='".$row['id']."' ORDER BY date DESC Limit 1");
|
|
$data[$key]['ikm']=$tmp1['km'];
|
|
//ca.km nach letztem check
|
|
$tmp5 = $GLOBALS['mysql']->query_single("SELECT SUM(km) FROM tourenliste WHERE auto='".$row['id']."' and time>'".$tmp1[date]."' and time<'".$time."'");
|
|
$data[$key]['ckm']=$tmp5['SUM(km)']+$tmp1['km'];
|
|
//km vom vorletztes tanken
|
|
$tmp2=$GLOBALS['mysql']->query_single("SELECT * FROM fahrzeug_log WHERE utyp=3 AND fid='".$row['id']."' ORDER BY date DESC Limit 1,1");
|
|
$data[$key]['tkm']=$tmp1['km']-$tmp2['km'];
|
|
//geschätze km vom letzten tanken
|
|
$tmp3=$GLOBALS['mysql']->query_single("SELECT SUM(km) FROM tourenliste WHERE auto='".$row['id']."' and time>'".$tmp2[date]."' AND time<'".$tmp1[date]."'");
|
|
$data[$key]['rkm']=$tmp3['SUM(km)'];
|
|
|
|
$data[$key]['tanz']=0;
|
|
$t1=$tmp1['km']-$tmp2['km'];
|
|
if($t1!=0) { $data[$key]['dvb']=round(($tmp1['tank']/($t1))*100, 1); }
|
|
else { $data[$key]['dvb']=0; }
|
|
// $data[$key]['dvb']=round(($tmp1['tank']/($tmp1['km']-$tmp2['km']))*100, 1);
|
|
if($data[$key]['dvb']<12) { $data[$key]['tanz']=1; }
|
|
if($data[$key]['dvb']>12) { $data[$key]['tanz']=2; }
|
|
if($data[$key]['dvb']< 7) { $data[$key]['tanz']=3; }
|
|
if($data[$key]['dvb']>16) { $data[$key]['tanz']=4; }
|
|
//$data[$key]['dvb']="Ø ".$data[$key]['dvb']." ltr.";
|
|
|
|
|
|
$key++;
|
|
}
|
|
|
|
|
|
|
|
$template->assign('kmdata', $data);
|
|
*/
|
|
//-------------------------------------------------------------------------------------------------------------
|
|
|
|
//echo'<pre>'; print_r($row); echo'</pre>';
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$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/home/ue_h24.tpl');
|
|
?>
|