139 lines
No EOL
6.3 KiB
PHP
139 lines
No EOL
6.3 KiB
PHP
<?php
|
|
$_SESSION['m1']=0; $_SESSION['m2']=0;
|
|
|
|
$tagname = array("Sonntag", "Montag", "Dienstag", "Mittwoch", "Donnerstag", "Freitag", "Samstag");
|
|
//------------------------------------------------ offene Touren
|
|
$tag1 = date("Y"); $monat1 = date("m"); $jahr1 = date("d");
|
|
$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);
|
|
//------------------------------------------------------------------------- änder kw !!!!!!!!!!!!
|
|
$tag1_jahr = date("Y");
|
|
$tag1_monat = date("m");
|
|
$tag1_tag = date("d");
|
|
$tag1_kw = date("W");
|
|
//---------------------------- änderungen !!!!!!!!!!
|
|
$wtag = date("w");//// wochentag als zahl
|
|
|
|
//---------------- Status -----------------
|
|
$anlage = $GLOBALS['mysql']->query("SELECT * FROM kartenlog ORDER BY logID DESC LIMIT 0,5"); $key=0;
|
|
while($row_anlage = $anlage->fetch_assoc()) {
|
|
$status[$key]['fahrer'] = $_SESSION['ma_all'][$row_anlage['user']]['name'];
|
|
$status[$key]['zeit']=$row_anlage['zeit'];
|
|
$key++;
|
|
}
|
|
//------------------------- 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++;
|
|
}
|
|
//------------------------- 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++;
|
|
}
|
|
//--------------------------------------------
|
|
$alarm="aus";
|
|
//--------------------------------------------
|
|
$tuer="zu";
|
|
|
|
|
|
|
|
//-----------------------------------------------
|
|
$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);
|
|
//-----------------------------------------------
|
|
//-----------------------------------------------
|
|
//-----------------------------------------------
|
|
//-----------------------------------------------
|
|
$timepi = $GLOBALS['mysql']->query_single("SELECT * FROM system");
|
|
$time = time();
|
|
$pitime=$timepi['pitime']+330;
|
|
|
|
//echo $pitime."-".$time;
|
|
if($pitime<$time) { $online=0; } else { $online=1; }
|
|
|
|
//--------------------------------------------
|
|
if (date('w')==6) {
|
|
$template->assign('samstag', 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); }
|
|
//----------------------------------------------------------------------------------------------------------------------------------------------
|
|
|
|
$template->assign('status', $status);
|
|
$template->assign('estatus', $estatus);
|
|
$template->assign('ustatus', $ustatus);
|
|
//-------------------------------------------
|
|
$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/ue_home2020.tpl');
|
|
?>
|