49 lines
No EOL
1.9 KiB
PHP
49 lines
No EOL
1.9 KiB
PHP
<?php
|
|
|
|
ini_set('display_errors', 0);
|
|
|
|
$a_zeit=time();
|
|
|
|
$biszeit =$a_zeit+14400; // + 10 Stunden
|
|
$vonzeit =$a_zeit-14400; // - 10 Stunden ////////////// 1 Stunde
|
|
$gelbzeit=$a_zeit+7800; // Anzeige in sekunden vor dem Start 7800 = 2h vor start anzeigen
|
|
|
|
$kontrollzeit=$a_zeit-14400; // +nächsten 10 Stunden
|
|
$laufend = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE time>'".$vonzeit."' and time<'".$biszeit."' ORDER BY time"); $key=0;
|
|
while($row = $laufend->fetch_assoc()) { //echo "<pre>"; print_r($row); echo "</pre>";
|
|
$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 "<pre>"; print_r($row_tour['tour']); echo "</pre>";
|
|
$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'); |