102 lines
5 KiB
PHP
102 lines
5 KiB
PHP
<?php
|
|
$_SESSION['m1']=1; $_SESSION['m2']=5;
|
|
//------------------ PIN heute
|
|
$tagp = strtotime("+0 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day2=$tag.".".$monat.".".$jahr;
|
|
$datum1=$tag.".".$monat.".".$jahr;
|
|
$key=0;
|
|
$pin_tour = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$tag."' and monat='".$monat."' and jahr='".$jahr."' and typ=6") ;
|
|
while($row = $pin_tour->fetch_assoc()) {
|
|
$row_tour3 = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
|
|
$pin_tour1[$key]['id']=$row['id'];
|
|
$pin_tour1[$key]['zeit']=$row['zeit'];
|
|
$pin_tour1[$key]['tour']=$row_tour3['tour'];
|
|
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'");
|
|
$pin_tour1[$key]['fahrer']=$row_fahrerx['name'];
|
|
$row_autox = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'");
|
|
$pin_tour1[$key]['kennz']=$row_autox['kz'];
|
|
$pin_tour1[$key]['auto_id']=$row['auto'];
|
|
$template->assign('pin_tour1', $pin_tour1);
|
|
$key++;
|
|
}
|
|
//---------- kalender heute
|
|
$test = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
|
|
$key=0;
|
|
while($row = $test->fetch_assoc()) {
|
|
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['mid']."'");
|
|
$maf1[$key]['fahrer']=$row_fahrerx['name'];
|
|
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$row['grund']."'");
|
|
$maf1[$key]['bez']=$row_icon['bez'];
|
|
$maf1[$key]['icon']=$row_icon['icon'];
|
|
$key++;
|
|
}
|
|
$bday = $GLOBALS['mysql']->query("SELECT * FROM mitarbeiter WHERE gebtag='".$tag."' AND gebmonat='".$monat."'");
|
|
while($row = $bday->fetch_assoc()) {
|
|
if($row['gebjahr']>0) {
|
|
$maf1[$key]['fahrer']=$row['name']; $jahre=$jahr-$row['gebjahr']; $maf1[$key]['bez']=$jahre.". Geburtstag"; $maf1[$key]['icon']="bday.png";
|
|
$key++;
|
|
}}
|
|
$auto = $GLOBALS['mysql']->query("SELECT * FROM fplaner WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
|
|
while($row = $auto->fetch_assoc()) {
|
|
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['fid']."'");
|
|
$maf1[$key]['fahrer']=$row_fahrerx['kz'];
|
|
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM fplaner_bez WHERE id='".$row['grund']."'");
|
|
$maf1[$key]['bez']=$row_icon['bez'];
|
|
$maf1[$key]['icon']=$row_icon['icon'];
|
|
$key++;
|
|
}
|
|
|
|
//------------------ PIN morgen
|
|
$tagp = strtotime("+1 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day2=$tag.".".$monat.".".$jahr;
|
|
$datum2=$tag.".".$monat.".".$jahr;
|
|
$key=0;
|
|
$pin_tour = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$tag."' and monat='".$monat."' and jahr='".$jahr."' and typ=6") ;
|
|
while($row = $pin_tour->fetch_assoc()) {
|
|
$row_tour3 = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
|
|
$pin_tour2[$key]['id']=$row['id'];
|
|
$pin_tour2[$key]['zeit']=$row['zeit'];
|
|
$pin_tour2[$key]['tour']=$row_tour3['tour'];
|
|
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'");
|
|
$pin_tour2[$key]['fahrer']=$row_fahrerx['name'];
|
|
$row_autox = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'");
|
|
$pin_tour2[$key]['kennz']=$row_autox['kz'];
|
|
$pin_tour2[$key]['auto_id']=$row['auto'];
|
|
$key++;
|
|
$template->assign('pin_tour2', $pin_tour2);
|
|
}
|
|
//----------------- kalender morgen
|
|
$test = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
|
|
$key=0;
|
|
while($row = $test->fetch_assoc()) {
|
|
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['mid']."'");
|
|
$maf2[$key]['fahrer']=$row_fahrerx['name'];
|
|
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$row['grund']."'");
|
|
$maf2[$key]['bez']=$row_icon['bez'];
|
|
$maf2[$key]['icon']=$row_icon['icon'];
|
|
$key++;
|
|
}
|
|
$bday = $GLOBALS['mysql']->query("SELECT * FROM mitarbeiter WHERE gebtag='".$tag."' AND gebmonat='".$monat."'");
|
|
while($row = $bday->fetch_assoc()) {
|
|
// if($row['gebjahr']>0) {
|
|
$maf2[$key]['fahrer']=$row['name']; $jahre=$jahr-$row['gebjahr']; $maf2[$key]['bez']=$jahre.". Geburtstag"; $maf2[$key]['icon']="bday.png";
|
|
$key++;
|
|
// }
|
|
}
|
|
$auto = $GLOBALS['mysql']->query("SELECT * FROM fplaner WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
|
|
while($row = $auto->fetch_assoc()) {
|
|
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['fid']."'");
|
|
$maf2[$key]['fahrer']=$row_fahrerx['kz'];
|
|
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM fplaner_bez WHERE id='".$row['grund']."'");
|
|
$maf2[$key]['bez']=$row_icon['bez'];
|
|
$maf2[$key]['icon']=$row_icon['icon'];
|
|
$key++;
|
|
}
|
|
//---------------------------
|
|
$heute = "$tag.$monat.$jahr";
|
|
$template->assign('datum1', $datum1);
|
|
$template->assign('datum2', $datum2);
|
|
$template->assign('maf1', $maf1);
|
|
$template->assign('maf2', $maf2);
|
|
|
|
|
|
$template->assign('content', 'tpl/ppost.tpl');
|
|
?>
|