115 lines
3.6 KiB
PHP
115 lines
3.6 KiB
PHP
<META HTTP-EQUIV="refresh" content="30;URL=index.php?s=tuer">
|
|
<?php
|
|
$_SESSION['m1']=0; $_SESSION['m2']=7;
|
|
date_default_timezone_set('Europe/Berlin'); setlocale(LC_TIME, "de_DE");
|
|
error_reporting(E_ALL); ini_set('display_errors', 1);
|
|
|
|
$heute_jahr = date("Y");
|
|
$heute_monat = date("m");
|
|
$heute_tag = date("d");
|
|
$heute_wtag = date("w");
|
|
|
|
$tagminus = strtotime("-1 day");
|
|
$tagheute = strtotime("-0 day");
|
|
|
|
$gestern_jahr = date("Y",$tagminus);
|
|
$gestern_monat = date("m",$tagminus);
|
|
$gestern_tag = date("d",$tagminus);
|
|
$gestern_wtag = date("w",$tagminus);
|
|
|
|
$tag1v= mktime(0, 0, 0, $heute_monat, $heute_tag, $heute_jahr);
|
|
$tag1b= mktime(23,59,0, $heute_monat, $heute_tag, $heute_jahr);
|
|
|
|
$tag2v= mktime(0, 0, 0, $gestern_monat, $gestern_tag, $gestern_jahr);
|
|
$tag2b= mktime(23,59,0, $gestern_monat, $gestern_tag, $gestern_jahr);
|
|
|
|
|
|
//-------------- TAG heute
|
|
$anlage1 = $GLOBALS['mysql']->query("SELECT * FROM kartenlog WHERE zeit<'".$tag1b."' AND zeit>'".$tag1v."' ORDER BY logID"); $key=0;
|
|
while($row_anlage1 = $anlage1->fetch_assoc()) {
|
|
$row_fahrer = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row_anlage1['user']."'");
|
|
if ($row_anlage1['user']==47 OR $row_anlage1['user']==280) {
|
|
$fremdname = $GLOBALS['mysql']->query_single("SELECT * FROM karten WHERE karte='".$row_anlage1['karte']."'");
|
|
// echo "<pre>"; print_r($fremdname); echo "</pre>";
|
|
$status1[$key]['fahrer']=$row_fahrer['name'].' - '.$fremdname['info'];
|
|
} else {
|
|
$status1[$key]['fahrer']=$row_fahrer['name'];
|
|
}
|
|
$status1[$key]['zeit']=$row_anlage1['zeit'];
|
|
$key++;
|
|
}
|
|
|
|
//-------------- TAG gestern
|
|
$anlage2 = $GLOBALS['mysql']->query("SELECT * FROM kartenlog WHERE zeit<'".$tag2b."' AND zeit>'".$tag2v."' ORDER BY logID"); $key=0;
|
|
while($row_anlage2 = $anlage2->fetch_assoc()) {
|
|
$row_fahrer = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row_anlage2['user']."'");
|
|
if ($row_anlage2['user']==47 OR $row_anlage2['user']==280) {
|
|
$fremdname = $GLOBALS['mysql']->query_single("SELECT * FROM karten WHERE karte='".$row_anlage2['karte']."'");
|
|
// echo "<pre>"; print_r($fremdname); echo "</pre>";
|
|
$status2[$key]['fahrer']=$row_fahrer['name'].' - '.$fremdname['info'];
|
|
} else {
|
|
$status2[$key]['fahrer']=$row_fahrer['name'];
|
|
}
|
|
|
|
$status2[$key]['zeit']=$row_anlage2['zeit'];
|
|
$key++;
|
|
}
|
|
//---------------- Status -----------------
|
|
$anlage = $GLOBALS['mysql']->query("SELECT * FROM kartenlog ORDER BY logID DESC LIMIT 0,9"); $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'];
|
|
$status[$key]['zeit2']=$row_anlage['zeit2'];
|
|
$key++;
|
|
}
|
|
//------------------------- estatus - letzte fehlereinlese ----------
|
|
$anlage2 = $GLOBALS['mysql']->query("SELECT * FROM kartenerror ORDER BY logID DESC LIMIT 0,5"); $key=0;
|
|
while($row_anlage2 = $anlage2->fetch_assoc()) {
|
|
$estatus[$key]['karte']=$row_anlage2['karte'];
|
|
$estatus[$key]['zeit']=$row_anlage2['zeit'];
|
|
$key++;
|
|
}
|
|
//--------------------------------------------
|
|
$alarm="aus";
|
|
//--------------------------------------------
|
|
$tuer="zu";
|
|
|
|
$template->assign('tuer', $tuer);
|
|
$template->assign('alarm', $alarm);
|
|
$template->assign('status', $status);
|
|
$template->assign('estatus', $estatus);
|
|
$template->assign('status1', $status1);
|
|
$template->assign('status2', $status2);
|
|
$template->assign('tag1b', $tag1b);
|
|
$template->assign('tag2b', $tag2b);
|
|
|
|
|
|
$template->assign('content', 'tpl/tuer.tpl');
|
|
|
|
?>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|