query("SELECT * FROM tourenliste WHERE time>'".$vonzeit."' and time<'".$biszeit."' ORDER BY time"); $key=0;
while($row = $laufend->fetch_assoc()) { //echo ""; print_r($row); echo "
";
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
$row_fahrer = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'");
$row_auto = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'");
if($row_fahrer['uewach']>0) {
$kartenlog = $GLOBALS['mysql']->query_single("SELECT * FROM kartenlog WHERE user='".$row['fahrer']."' ORDER BY zeit DESC LIMIT 0,1");
if($kartenlog['zeit']>$kontrollzeit) {
$gruenzeit=$kartenlog['zeit']+900;
if($gruenzeit>$a_zeit) {
$xtour1[$key]['tour']=$row_tour['tour'];
$xtour1[$key]['name']=$row_fahrer['name'];
$xtour1[$key]['kennz']=$row_auto['kz'];
}
} else {
$gelbzeit=$a_zeit+7800;
if($gelbzeit>$row['time'] and $a_zeit<$row['time']) { // echo ""; print_r($row_tour['tour']); echo "
";
$xtour2[$key]['tour']=$row_tour['tour'];
$xtour2[$key]['name']=$row_fahrer['name'];
$xtour2[$key]['kennz']=$row_auto['kz'];
}
elseif($row['time']<$a_zeit) {
$xtour3[$key]['tour']=$row_tour['tour'];
$xtour3[$key]['name']=$row_fahrer['name'];
$xtour3[$key]['kennz']=$row_auto['kz'];
}
}
}
$key++;
}
$template->assign('hilfe', $hilfe);
$template->assign('xtour1', $xtour1);
$template->assign('xtour2', $xtour2);
$template->assign('xtour3', $xtour3);
$template->assign('content', 'tpl/ajax/x_tour.tpl');