111 lines
No EOL
4.5 KiB
PHP
111 lines
No EOL
4.5 KiB
PHP
<?php
|
|
// echo "<pre>"; print_r($tw3); echo "</pre>";
|
|
$_SESSION['m1']=0; $_SESSION['m2']=0;
|
|
|
|
error_reporting(E_ALL); ini_set('display_errors',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
|
|
|
|
|
|
//---------------- rundschau -----------------
|
|
/*
|
|
$rsges = $GLOBALS['mysql']->query("SELECT DISTINCT tourenliste.gewicht, tourenliste.fertig FROM tourenliste
|
|
JOIN touren
|
|
WHERE touren.aktiv=1 AND tourenliste.typ=7 and tourenliste.kw='".$tag1_kw."' and tourenliste.jahr='".$tag1_jahr."'");
|
|
while($row_rs = $rsges->fetch_assoc()) {
|
|
$rsgewicht=$rsgewicht+$row_rs['gewicht'];
|
|
if($row_rs['fertig']==1) { $rsfertig=1; } else { $rsfertig=9; }
|
|
}
|
|
if($rsgewicht<1) { $rsfertig=8; }
|
|
*/
|
|
//---------------- Saso -----------------
|
|
$ssges = $GLOBALS['mysql']->query("SELECT DISTINCT tourenliste.gewicht, tourenliste.fertig FROM tourenliste
|
|
JOIN touren
|
|
WHERE touren.aktiv=1 AND tourenliste.typ=19 and tourenliste.kw='".$tag1_kw."' and tourenliste.jahr='".$tag1_jahr."'");
|
|
while($row_ss = $ssges->fetch_assoc()) {
|
|
$sasogewicht=$sasogewicht+$row_ss['gewicht'];
|
|
if($row_ss['fertig']==1) { $ssfertig=1; } else { $ssfertig=9; }
|
|
}
|
|
if($sasogewicht<1) { $ssfertig=8; }
|
|
//---------------- Status -----------------
|
|
$anlage = $GLOBALS['mysql']->query("SELECT * FROM kartenlog ORDER BY logID DESC LIMIT 0,5"); $key=0;
|
|
while($row_anlage = $anlage->fetch_assoc()) {
|
|
$row_fahrer = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row_anlage['user']."'");
|
|
$status[$key]['fahrer']=$row_fahrer['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()) {
|
|
$row_fahrer= $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row_uanlage['user']."'");
|
|
$ustatus[$key]['user']=$row_fahrer['name'];
|
|
$ustatus[$key]['grund']=$row_uanlage['grund'];
|
|
$ustatus[$key]['zeit']=$row_uanlage['zeit'];
|
|
$key++;
|
|
}
|
|
//--------------------------------------------
|
|
$alarm="aus";
|
|
//--------------------------------------------
|
|
$tuer="zu";
|
|
|
|
|
|
|
|
//-----------------------------------------------
|
|
|
|
//-----------------------------------------------
|
|
//-----------------------------------------------
|
|
//-----------------------------------------------
|
|
//-----------------------------------------------
|
|
//-----------------------------------------------
|
|
$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; }
|
|
|
|
//--------------------------------------------
|
|
|
|
//--------------------------------------------
|
|
//--------------------------------------------
|
|
|
|
|
|
//--------------------------------------------
|
|
// $template->assign('rsgewicht', number_format($rsgewicht,0, '', '.'));
|
|
$template->assign('sasogewicht', number_format($sasogewicht,0, '', '.'));
|
|
// $template->assign('rsfertig', $rsfertig);
|
|
$template->assign('ssfertig', $ssfertig);
|
|
$template->assign('status', $status);
|
|
$template->assign('estatus', $estatus);
|
|
$template->assign('ustatus', $ustatus);
|
|
//-------------------------------------------
|
|
$template->assign('tag1', $tag1);
|
|
$template->assign('tag2', $tag2);
|
|
|
|
|
|
$template->assign('content', 'tpl/ue_home.tpl');
|
|
?>
|