234 lines
No EOL
12 KiB
PHP
234 lines
No EOL
12 KiB
PHP
<?php
|
|
$_SESSION['m1']=6; $_SESSION['m2']=1;
|
|
error_reporting(E_ALL); ini_set('display_errors',0);
|
|
$tagname = array("Sonntag", "Montag", "Dienstag", "Mittwoch", "Donnerstag", "Freitag", "Samstag");
|
|
|
|
$tagp = strtotime("+0 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day1=$tag.".".$monat.".".$jahr; $tna1=$tagname[date("w",$tagp)];
|
|
$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()) {
|
|
$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++;
|
|
}
|
|
$tagp = strtotime("+1 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day2=$tag.".".$monat.".".$jahr; $tna2=$tagname[date("w",$tagp)];
|
|
$test = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
|
|
$key=0;
|
|
while($row = $test->fetch_assoc()) {
|
|
$maf2[$key]['tag']=$tag;
|
|
$maf2[$key]['monat']=$row['monat'];
|
|
$maf2[$key]['jahr']=$row['jahr'];
|
|
$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'];
|
|
$maf2[$key]['info']=$row['info'];
|
|
$key++;
|
|
}
|
|
$bday = $GLOBALS['mysql']->query("SELECT * FROM mitarbeiter WHERE gebtag='".$tag."' AND gebmonat='".$monat."'");
|
|
while($row = $bday->fetch_assoc()) {
|
|
$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++;
|
|
}
|
|
$tagp = strtotime("+2 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day3=$tag.".".$monat.".".$jahr; $tna3=$tagname[date("w",$tagp)];
|
|
$test = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
|
|
$key=0;
|
|
while($row = $test->fetch_assoc()) {
|
|
$maf3[$key]['tag']=$tag;
|
|
$maf3[$key]['monat']=$row['monat'];
|
|
$maf3[$key]['jahr']=$row['jahr'];
|
|
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['mid']."'");
|
|
$maf3[$key]['fahrer']=$row_fahrerx['name'];
|
|
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$row['grund']."'");
|
|
$maf3[$key]['bez']=$row_icon['bez'];
|
|
$maf3[$key]['icon']=$row_icon['icon'];
|
|
$maf3[$key]['info']=$row['info'];
|
|
$key++;
|
|
}
|
|
$bday = $GLOBALS['mysql']->query("SELECT * FROM mitarbeiter WHERE gebtag='".$tag."' AND gebmonat='".$monat."'");
|
|
while($row = $bday->fetch_assoc()) {
|
|
$maf3[$key]['fahrer']=$row['name']; $jahre=$jahr-$row['gebjahr']; $maf3[$key]['bez']=$jahre.". Geburtstag"; $maf3[$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']."'");
|
|
$maf3[$key]['fahrer']=$row_fahrerx['kz'];
|
|
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM fplaner_bez WHERE id='".$row['grund']."'");
|
|
$maf3[$key]['bez']=$row_icon['bez'];
|
|
$maf3[$key]['icon']=$row_icon['icon'];
|
|
$key++;
|
|
}
|
|
$tagp = strtotime("+3 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day4=$tag.".".$monat.".".$jahr; $tna4=$tagname[date("w",$tagp)];
|
|
$test = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
|
|
$key=0;
|
|
while($row = $test->fetch_assoc()) {
|
|
$maf4[$key]['tag']=$tag;
|
|
$maf4[$key]['monat']=$row['monat'];
|
|
$maf4[$key]['jahr']=$row['jahr'];
|
|
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['mid']."'");
|
|
$maf4[$key]['fahrer']=$row_fahrerx['name'];
|
|
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$row['grund']."'");
|
|
$maf4[$key]['bez']=$row_icon['bez'];
|
|
$maf4[$key]['icon']=$row_icon['icon'];
|
|
$maf4[$key]['info']=$row['info'];
|
|
$key++;
|
|
}
|
|
$bday = $GLOBALS['mysql']->query("SELECT * FROM mitarbeiter WHERE gebtag='".$tag."' AND gebmonat='".$monat."'");
|
|
while($row = $bday->fetch_assoc()) {
|
|
$maf4[$key]['fahrer']=$row['name']; $jahre=$jahr-$row['gebjahr']; $maf4[$key]['bez']=$jahre.". Geburtstag"; $maf4[$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']."'");
|
|
$maf4[$key]['fahrer']=$row_fahrerx['kz'];
|
|
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM fplaner_bez WHERE id='".$row['grund']."'");
|
|
$maf4[$key]['bez']=$row_icon['bez'];
|
|
$maf4[$key]['icon']=$row_icon['icon'];
|
|
$key++;
|
|
}
|
|
$tagp = strtotime("+4 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day5=$tag.".".$monat.".".$jahr; $tna5=$tagname[date("w",$tagp)];
|
|
$test = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
|
|
$key=0;
|
|
while($row = $test->fetch_assoc()) {
|
|
$maf5[$key]['tag']=$tag;
|
|
$maf5[$key]['monat']=$row['monat'];
|
|
$maf5[$key]['jahr']=$row['jahr'];
|
|
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['mid']."'");
|
|
$maf5[$key]['fahrer']=$row_fahrerx['name'];
|
|
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$row['grund']."'");
|
|
$maf5[$key]['bez']=$row_icon['bez'];
|
|
$maf5[$key]['icon']=$row_icon['icon'];
|
|
$maf5[$key]['info']=$row['info'];
|
|
$key++;
|
|
}
|
|
$bday = $GLOBALS['mysql']->query("SELECT * FROM mitarbeiter WHERE gebtag='".$tag."' AND gebmonat='".$monat."'");
|
|
while($row = $bday->fetch_assoc()) {
|
|
$maf5[$key]['fahrer']=$row['name']; $jahre=$jahr-$row['gebjahr']; $maf5[$key]['bez']=$jahre.". Geburtstag"; $maf5[$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']."'");
|
|
$maf5[$key]['fahrer']=$row_fahrerx['kz'];
|
|
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM fplaner_bez WHERE id='".$row['grund']."'");
|
|
$maf5[$key]['bez']=$row_icon['bez'];
|
|
$maf5[$key]['icon']=$row_icon['icon'];
|
|
$key++;
|
|
}
|
|
$tagp = strtotime("+5 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day6=$tag.".".$monat.".".$jahr; $tna6=$tagname[date("w",$tagp)];
|
|
$test = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
|
|
$key=0;
|
|
while($row = $test->fetch_assoc()) {
|
|
$maf6[$key]['tag']=$tag;
|
|
$maf6[$key]['monat']=$row['monat'];
|
|
$maf6[$key]['jahr']=$row['jahr'];
|
|
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['mid']."'");
|
|
$maf6[$key]['fahrer']=$row_fahrerx['name'];
|
|
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$row['grund']."'");
|
|
$maf6[$key]['bez']=$row_icon['bez'];
|
|
$maf6[$key]['icon']=$row_icon['icon'];
|
|
$maf6[$key]['info']=$row['info'];
|
|
$key++;
|
|
}
|
|
$bday = $GLOBALS['mysql']->query("SELECT * FROM mitarbeiter WHERE gebtag='".$tag."' AND gebmonat='".$monat."'");
|
|
while($row = $bday->fetch_assoc()) {
|
|
$maf6[$key]['fahrer']=$row['name']; $jahre=$jahr-$row['gebjahr']; $maf6[$key]['bez']=$jahre.". Geburtstag"; $maf6[$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']."'");
|
|
$maf6[$key]['fahrer']=$row_fahrerx['kz'];
|
|
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM fplaner_bez WHERE id='".$row['grund']."'");
|
|
$maf6[$key]['bez']=$row_icon['bez'];
|
|
$maf6[$key]['icon']=$row_icon['icon'];
|
|
$key++;
|
|
}
|
|
$tagp = strtotime("+6 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day7=$tag.".".$monat.".".$jahr; $tna7=$tagname[date("w",$tagp)];
|
|
$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']."'");
|
|
$maf7[$key]['fahrer']=$row_fahrerx['name'];
|
|
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$row['grund']."'");
|
|
$maf7[$key]['bez']=$row_icon['bez'];
|
|
$maf7[$key]['icon']=$row_icon['icon'];
|
|
$maf7[$key]['info']=$row['info'];
|
|
$key++;
|
|
}
|
|
$bday = $GLOBALS['mysql']->query("SELECT * FROM mitarbeiter WHERE gebtag='".$tag."' AND gebmonat='".$monat."'");
|
|
while($row = $bday->fetch_assoc()) {
|
|
$maf7[$key]['fahrer']=$row['name']; $jahre=$jahr-$row['gebjahr']; $maf7[$key]['bez']=$jahre.". Geburtstag"; $maf7[$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']."'");
|
|
$maf7[$key]['fahrer']=$row_fahrerx['kz'];
|
|
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM fplaner_bez WHERE id='".$row['grund']."'");
|
|
$maf7[$key]['bez']=$row_icon['bez'];
|
|
$maf7[$key]['icon']=$row_icon['icon'];
|
|
$key++;
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
$template->assign('maf1', $maf1);
|
|
$template->assign('maf2', $maf2);
|
|
$template->assign('maf3', $maf3);
|
|
$template->assign('maf4', $maf4);
|
|
$template->assign('maf5', $maf5);
|
|
$template->assign('maf6', $maf6);
|
|
$template->assign('maf7', $maf7);
|
|
$template->assign('day1', $day1);
|
|
$template->assign('day2', $day2);
|
|
$template->assign('day3', $day3);
|
|
$template->assign('day4', $day4);
|
|
$template->assign('day5', $day5);
|
|
$template->assign('day6', $day6);
|
|
$template->assign('day7', $day7);
|
|
|
|
$template->assign('tna1', $tna1);
|
|
$template->assign('tna2', $tna2);
|
|
$template->assign('tna3', $tna3);
|
|
$template->assign('tna4', $tna4);
|
|
$template->assign('tna5', $tna5);
|
|
$template->assign('tna6', $tna6);
|
|
$template->assign('tna7', $tna7);
|
|
|
|
|
|
|
|
// $template->assign('content', 'tpl/kalender99.tpl');
|
|
$template->assign('content', 'tpl/ue_hm.tpl');
|
|
?>
|