110 lines
No EOL
4.8 KiB
PHP
110 lines
No EOL
4.8 KiB
PHP
<?php
|
|
error_reporting(E_ALL); ini_set('display_errors',0);
|
|
|
|
//----------- Montag
|
|
$tagp = strtotime("next monday"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $datum1=$tag.".".$monat.".".$jahr;
|
|
$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'];
|
|
$maf1[$key]['info']=$row['info'];
|
|
$key++;
|
|
}
|
|
$template->assign('datum1', $datum1);
|
|
$template->assign('kal1', $maf1);
|
|
|
|
//----------- Dienstag
|
|
$tagp = strtotime("+1 day", $tagp); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $datum2=$tag.".".$monat.".".$jahr;
|
|
$test = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
|
|
$key=0; unset($maf1);
|
|
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'];
|
|
$maf1[$key]['info']=$row['info'];
|
|
$key++;
|
|
}
|
|
$template->assign('datum2', $datum2);
|
|
$template->assign('kal2', $maf1);
|
|
|
|
//----------- Mittwoch
|
|
$tagp = strtotime("+1 day", $tagp); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $datum3=$tag.".".$monat.".".$jahr;
|
|
$test = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
|
|
$key=0; unset($maf1);
|
|
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'];
|
|
$maf1[$key]['info']=$row['info'];
|
|
$key++;
|
|
}
|
|
$template->assign('datum3', $datum3);
|
|
$template->assign('kal3', $maf1);
|
|
|
|
//----------- do
|
|
$tagp = strtotime("+1 day", $tagp); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $datum4=$tag.".".$monat.".".$jahr;
|
|
$test = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
|
|
$key=0; unset($maf1);
|
|
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'];
|
|
$maf1[$key]['info']=$row['info'];
|
|
$key++;
|
|
}
|
|
$template->assign('datum4', $datum4);
|
|
$template->assign('kal4', $maf1);
|
|
|
|
//----------- fr
|
|
$tagp = strtotime("+1 day", $tagp); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $datum5=$tag.".".$monat.".".$jahr;
|
|
$test = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
|
|
$key=0; unset($maf1);
|
|
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'];
|
|
$maf1[$key]['info']=$row['info'];
|
|
$key++;
|
|
}
|
|
$template->assign('datum5', $datum5);
|
|
$template->assign('kal5', $maf1);
|
|
|
|
//----------- sa
|
|
$tagp = strtotime("+1 day", $tagp); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $datum6=$tag.".".$monat.".".$jahr;
|
|
$test = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE tag='".$tag."' AND monat='".$monat."' AND jahr='".$jahr."'");
|
|
$key=0; unset($maf1);
|
|
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'];
|
|
$maf1[$key]['info']=$row['info'];
|
|
$key++;
|
|
}
|
|
$template->assign('datum6', $datum6);
|
|
$template->assign('kal6', $maf1);
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$template->assign('content', 'tpl/ajax/kal_ue_nw.tpl');
|
|
?>
|