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 ""; print_r($fremdname); echo "
";
$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 ""; print_r($fremdname); echo "
";
$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');
?>