204 lines
9.5 KiB
PHP
204 lines
9.5 KiB
PHP
<?php
|
|
|
|
$_SESSION['m1']=0; $_SESSION['m2']=3;
|
|
$tag1_jahr = date("Y");
|
|
$tag1_monat = date("m");
|
|
$tag1_tag = date("d");
|
|
//$tag1 = "$heute_tag.$heute_monat.$heute_jahr";
|
|
$wtag = date("w");
|
|
if($wtag == "0") {
|
|
$tp1 = strtotime("+1 day");
|
|
$tp2 = strtotime("+2 day");
|
|
$tp3 = strtotime("+3 day");
|
|
$tp4 = strtotime("+4 day");
|
|
$tp5 = strtotime("+5 day");
|
|
$tp6 = strtotime("+6 day");
|
|
} else if($wtag == "1") {
|
|
$tp1 = strtotime("+0 day");
|
|
$tp2 = strtotime("+1 day");
|
|
$tp3 = strtotime("+2 day");
|
|
$tp4 = strtotime("+3 day");
|
|
$tp5 = strtotime("+4 day");
|
|
$tp6 = strtotime("+5 day");
|
|
} else if($wtag == "2") {
|
|
$tp1 = strtotime("+0 day");
|
|
$tp2 = strtotime("+1 day");
|
|
$tp3 = strtotime("+2 day");
|
|
$tp4 = strtotime("+3 day");
|
|
$tp5 = strtotime("+4 day");
|
|
$tp6 = strtotime("+6 day");
|
|
} else if($wtag == "3") {
|
|
$tp1 = strtotime("+0 day");
|
|
$tp2 = strtotime("+1 day");
|
|
$tp3 = strtotime("+2 day");
|
|
$tp4 = strtotime("+3 day");
|
|
$tp5 = strtotime("+5 day");
|
|
$tp6 = strtotime("+6 day");
|
|
} else if($wtag == "4") {
|
|
$tp1 = strtotime("+0 day");
|
|
$tp2 = strtotime("+1 day");
|
|
$tp3 = strtotime("+2 day");
|
|
$tp4 = strtotime("+4 day");
|
|
$tp5 = strtotime("+5 day");
|
|
$tp6 = strtotime("+6 day");
|
|
} else if($wtag == "5") {
|
|
$tp1 = strtotime("+0 day");
|
|
$tp2 = strtotime("+1 day");
|
|
$tp3 = strtotime("+3 day");
|
|
$tp4 = strtotime("+4 day");
|
|
$tp5 = strtotime("+5 day");
|
|
$tp6 = strtotime("+6 day");
|
|
} else {
|
|
$tp1 = strtotime("+0 day");
|
|
$tp2 = strtotime("+2 day");
|
|
$tp3 = strtotime("+3 day");
|
|
$tp4 = strtotime("+4 day");
|
|
$tp5 = strtotime("+5 day");
|
|
$tp6 = strtotime("+6 day");
|
|
}
|
|
|
|
$tag1 = date("d.m.Y", $tp1); $tag1_tag = date("d",$tp1); $tag1_monat = date("m",$tp1); $tag1_jahr = date("Y",$tp1);
|
|
$tag2 = date("d.m.Y", $tp2); $tag2_tag = date("d",$tp2); $tag2_monat = date("m",$tp2); $tag2_jahr = date("Y",$tp2);
|
|
$tag3 = date("d.m.Y", $tp3); $tag3_tag = date("d",$tp3); $tag3_monat = date("m",$tp3); $tag3_jahr = date("Y",$tp3);
|
|
$tag4 = date("d.m.Y", $tp4); $tag4_tag = date("d",$tp4); $tag4_monat = date("m",$tp4); $tag4_jahr = date("Y",$tp4);
|
|
$tag5 = date("d.m.Y", $tp5); $tag5_tag = date("d",$tp5); $tag5_monat = date("m",$tp5); $tag5_jahr = date("Y",$tp5);
|
|
$tag6 = date("d.m.Y", $tp6); $tag6_tag = date("d",$tp6); $tag6_monat = date("m",$tp6); $tag6_jahr = date("Y",$tp6);
|
|
|
|
|
|
//-------------- TAG 1
|
|
$tour1 = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$tag1_tag."' AND monat='".$tag1_monat."' AND jahr='".$tag1_jahr."' AND typ=3 OR tag='".$tag1_tag."' AND monat='".$tag1_monat."' AND jahr='".$tag1_jahr."' AND typ=4 OR tag='".$tag1_tag."' AND monat='".$tag1_monat."' AND jahr='".$tag1_jahr."' AND typ=5"); $key=0;
|
|
while($row = $tour1->fetch_assoc()) {
|
|
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
|
|
$stamma=$row_tour['s_auto'];
|
|
$stammf=$row_tour['s_fahrer'];
|
|
$gleich=0;
|
|
if($stamma == $row['auto']) { $gleich++; }
|
|
if ($stammf == $row['fahrer']) { $gleich++; }
|
|
if ($gleich<2) {
|
|
$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++;
|
|
}
|
|
}
|
|
//-------------- TAG 2
|
|
$tour2 = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$tag2_tag."' AND monat='".$tag2_monat."' AND jahr='".$tag2_jahr."' AND typ=3 OR tag='".$tag2_tag."' AND monat='".$tag2_monat."' AND jahr='".$tag2_jahr."' AND typ=4 OR tag='".$tag2_tag."' AND monat='".$tag2_monat."' AND jahr='".$tag2_jahr."' AND typ=5"); $key=0;
|
|
while($row = $tour2->fetch_assoc()) {
|
|
$row_tour2 = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
|
|
$stamma=$row_tour2['s_auto'];
|
|
$stammf=$row_tour2['s_fahrer'];
|
|
$gleich=0;
|
|
if($stamma == $row['auto']) { $gleich++; }
|
|
if ($stammf == $row['fahrer']) { $gleich++; }
|
|
if ($gleich<2) {
|
|
$aender2[$key]['id']=$row['id'];
|
|
$aender2[$key]['tour']=$row_tour2['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++;
|
|
}
|
|
}
|
|
//-------------- TAG 3
|
|
$tour3 = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$tag3_tag."' AND monat='".$tag3_monat."' AND jahr='".$tag3_jahr."' AND typ=3 OR tag='".$tag3_tag."' AND monat='".$tag3_monat."' AND jahr='".$tag3_jahr."' AND typ=4 OR tag='".$tag3_tag."' AND monat='".$tag3_monat."' AND jahr='".$tag3_jahr."' AND typ=5"); $key=0;
|
|
while($row = $tour3->fetch_assoc()) {
|
|
$row_tour3 = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
|
|
$stamma=$row_tour3['s_auto'];
|
|
$stammf=$row_tour3['s_fahrer'];
|
|
$gleich=0;
|
|
if($stamma == $row['auto']) { $gleich++; }
|
|
if ($stammf == $row['fahrer']) { $gleich++; }
|
|
if ($gleich<2) {
|
|
$aender3[$key]['id']=$row['id'];
|
|
$aender3[$key]['tour']=$row_tour3['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_auto3['kz'];
|
|
$aender3[$key]['infotext']=$row['infotext'];
|
|
$key++;
|
|
}
|
|
}
|
|
//-------------- TAG 4
|
|
$tour4 = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$tag4_tag."' AND monat='".$tag4_monat."' AND jahr='".$tag4_jahr."' AND typ=3 OR tag='".$tag4_tag."' AND monat='".$tag4_monat."' AND jahr='".$tag4_jahr."' AND typ=4 OR tag='".$tag4_tag."' AND monat='".$tag4_monat."' AND jahr='".$tag4_jahr."' AND typ=5"); $key=0;
|
|
while($row = $tour4->fetch_assoc()) {
|
|
$row_tour4 = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
|
|
$stamma=$row_tour4['s_auto'];
|
|
$stammf=$row_tour4['s_fahrer'];
|
|
$gleich=0;
|
|
if($stamma == $row['auto']) { $gleich++; }
|
|
if ($stammf == $row['fahrer']) { $gleich++; }
|
|
if ($gleich<2) {
|
|
$aender4[$key]['id']=$row['id'];
|
|
$aender4[$key]['tour']=$row_tour4['tour'];
|
|
$row_fahrer4 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'");
|
|
$aender4[$key]['fahrer']=$row_fahrer4['name'];
|
|
$row_auto4 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'");
|
|
$aender4[$key]['kennz']=$row_auto4['kz'];
|
|
$aender4[$key]['infotext']=$row['infotext'];
|
|
$key++;
|
|
}
|
|
}
|
|
//-------------- TAG 5
|
|
$tour5 = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$tag5_tag."' AND monat='".$tag5_monat."' AND jahr='".$tag5_jahr."' AND typ=3 OR tag='".$tag5_tag."' AND monat='".$tag5_monat."' AND jahr='".$tag5_jahr."' AND typ=4 OR tag='".$tag5_tag."' AND monat='".$tag5_monat."' AND jahr='".$tag5_jahr."' AND typ=5"); $key=0;
|
|
while($row = $tour5->fetch_assoc()) {
|
|
$row_tour5 = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
|
|
$stamma=$row_tour5['s_auto'];
|
|
$stammf=$row_tour5['s_fahrer'];
|
|
$gleich=0;
|
|
if($stamma == $row['auto']) { $gleich++; }
|
|
if ($stammf == $row['fahrer']) { $gleich++; }
|
|
if ($gleich<2) {
|
|
$aender5[$key]['id']=$row['id'];
|
|
$aender5[$key]['tour']=$row_tour5['tour'];
|
|
$row_fahrer5 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'");
|
|
$aender5[$key]['fahrer']=$row_fahrer5['name'];
|
|
$row_auto5 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'");
|
|
$aender5[$key]['kennz']=$row_auto5['kz'];
|
|
$aender5[$key]['infotext']=$row['infotext'];
|
|
$key++;
|
|
}
|
|
}
|
|
//-------------- TAG 6
|
|
$tour6 = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$tag6_tag."' AND monat='".$tag6_monat."' AND jahr='".$tag6_jahr."' AND typ=3 OR tag='".$tag6_tag."' AND monat='".$tag6_monat."' AND jahr='".$tag6_jahr."' AND typ=4 OR tag='".$tag6_tag."' AND monat='".$tag6_monat."' AND jahr='".$tag6_jahr."' AND typ=5"); $key=0;
|
|
while($row = $tour6->fetch_assoc()) {
|
|
$row_tour6 = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
|
|
$stamma=$row_tour6['s_auto'];
|
|
$stammf=$row_tour6['s_fahrer'];
|
|
$gleich=0;
|
|
if($stamma == $row['auto']) { $gleich++; }
|
|
if ($stammf == $row['fahrer']) { $gleich++; }
|
|
if ($gleich<2) {
|
|
$aender6[$key]['id']=$row['id'];
|
|
$aender6[$key]['tour']=$row_tour6['tour'];
|
|
$row_fahrer6 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'");
|
|
$aender6[$key]['fahrer']=$row_fahrer6['name'];
|
|
$row_auto6 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'");
|
|
$aender6[$key]['kennz']=$row_auto6['kz'];
|
|
$aender6[$key]['infotext']=$row['infotext'];
|
|
$key++;
|
|
}
|
|
}
|
|
|
|
$template->assign('aender1', $aender1);
|
|
$template->assign('aender2', $aender2);
|
|
$template->assign('aender3', $aender3);
|
|
$template->assign('aender4', $aender4);
|
|
$template->assign('aender5', $aender5);
|
|
$template->assign('aender6', $aender6);
|
|
$template->assign('tag1', $tag1);
|
|
$template->assign('tag2', $tag2);
|
|
$template->assign('tag3', $tag3);
|
|
$template->assign('tag4', $tag4);
|
|
$template->assign('tag5', $tag5);
|
|
$template->assign('tag6', $tag6);
|
|
|
|
$template->assign('content', 'tpl/aenderkw_list.tpl');
|
|
|
|
?>
|