60 lines
2.8 KiB
PHP
60 lines
2.8 KiB
PHP
<?php
|
|
$_SESSION['m1']=0; $_SESSION['m2']=1;
|
|
//$heute_jahr = date("Y");
|
|
//$heute_monat = date("m");
|
|
//$heute_tag = date("d");
|
|
$tagp = strtotime("+1 day");
|
|
$morgen = date("Ymd", $tagp);
|
|
$heute_tag = date("d",$tagp);
|
|
$heute_monat = date("m",$tagp);
|
|
$heute_jahr = date("Y",$tagp);
|
|
$heute = "$heute_tag.$heute_monat.$heute_jahr";
|
|
|
|
|
|
//-------------- GH
|
|
$tour1 = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$heute_tag."' AND monat='".$heute_monat."' AND jahr='".$heute_jahr."' AND typ=3"); $key=0;
|
|
while($row = $tour1->fetch_assoc()) {
|
|
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
|
|
$aender1[$key]['id']=$row['id'];
|
|
$aender1[$key]['tour']=$row_tour['tour'];
|
|
$row_fahrer1 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'");
|
|
$aender1[$key]['fahrer']=$row_fahrer1['name'];
|
|
$row_auto1 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'");
|
|
$aender1[$key]['kennz']=$row_auto1['kz'];
|
|
$aender1[$key]['infotext']=$row['infotext'];
|
|
$key++;
|
|
}
|
|
//-------------- LVZ
|
|
$tour2 = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$heute_tag."' AND monat='".$heute_monat."' AND jahr='".$heute_jahr."' AND typ=4"); $key=0;
|
|
while($row = $tour2->fetch_assoc()) {
|
|
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
|
|
$aender2[$key]['id']=$row['id'];
|
|
$aender2[$key]['tour']=$row_tour['tour'];
|
|
$row_fahrer2 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'");
|
|
$aender2[$key]['fahrer']=$row_fahrer2['name'];
|
|
$row_auto2 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'");
|
|
$aender2[$key]['kennz']=$row_auto2['kz'];
|
|
$aender2[$key]['infotext']=$row['infotext'];
|
|
$key++;
|
|
}
|
|
//-------------- PIN
|
|
$tour3 = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$heute_tag."' AND monat='".$heute_monat."' AND jahr='".$heute_jahr."' AND typ=5"); $key=0;
|
|
while($row = $tour3->fetch_assoc()) {
|
|
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
|
|
$aender3[$key]['id']=$row['id'];
|
|
$aender3[$key]['tour']=$row_tour['tour'];
|
|
$row_fahrer3 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'");
|
|
$aender3[$key]['fahrer']=$row_fahrer3['name'];
|
|
$row_auto3 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'");
|
|
$aender3[$key]['kennz']=$row_auto2['kz'];
|
|
$aender3[$key]['infotext']=$row['infotext'];
|
|
$key++;
|
|
}
|
|
|
|
$template->assign('aender1', $aender1);
|
|
$template->assign('aender2', $aender2);
|
|
$template->assign('aender3', $aender3);
|
|
$template->assign('heute', $heute);
|
|
$template->assign('content', 'tpl/morgen.tpl');
|
|
|
|
?>
|