116 lines
No EOL
6.5 KiB
PHP
116 lines
No EOL
6.5 KiB
PHP
<?php
|
|
$_SESSION['m1']=0; $_SESSION['m2']=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); $tna1=$tagname[date("w",$tagp)]; $tag1=$tna1.", ".$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']."'");
|
|
$faf1[$key]['fahrer']=$row_fahrerx['kz'];
|
|
$row_icon = $GLOBALS['mysql']->query_single("SELECT * FROM fplaner_bez WHERE id='".$row['grund']."'");
|
|
$faf1[$key]['bez']=$row_icon['bez'];
|
|
$faf1[$key]['icon']=$row_icon['icon'];
|
|
$key++;
|
|
}
|
|
//---------------------------- heute änderungen !!!!!!!!!!
|
|
//-------------------------------------------------------------------------------------------
|
|
//-------------------------------------------------------------------------------------------
|
|
//-------------------------------------------------------------------------------------------
|
|
//-------------------------------------------------------------------------------------------
|
|
//-------------------------------------------------------------------------------------------
|
|
//-------------------------------------------------------------------------------------------
|
|
//-------------------------------------------------------------------------------------------
|
|
//-------------------------------------------------------------------------------------------
|
|
//-------------------------------------------------------------------------------------------
|
|
//-------------------------------------------------------------------------------------------
|
|
//-------------------------------------------------------------------------------------------
|
|
$key=0; $test=0; $tag1_jahr = date("Y"); $tag1_monat = date("m"); $tag1_tag = date("d");
|
|
for ($i = 1; $i <= 19; $i++) {
|
|
$tag_tour = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$tag1_tag."' and monat='".$tag1_monat."' and jahr='".$tag1_jahr."' and typ='".$i."' ORDER BY id");
|
|
while($row = $tag_tour->fetch_assoc()) {
|
|
$tag_tour2[$key]['tid']=$key; $test++;
|
|
$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
|
|
$tag_tour2[$key]['id']=$row['id'];
|
|
$tag_tour2[$key]['zeit']=$row['zeit'];
|
|
$tag_tour2[$key]['tour']=$row_tour['tour'];
|
|
|
|
|
|
|
|
$tag_tour2[$key]['$fahrernichtda']=0;
|
|
$row_nichtda = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$row['fahrer']."' AND tag='".$tag1_tag."' AND monat='".$tag1_monat."' AND jahr='".$tag1_jahr."'");
|
|
if($row_nichtda['num_rows'] > 0) {
|
|
|
|
// echo'<pre>';
|
|
// print_r($row_nichtda);
|
|
// echo'</pre>';
|
|
|
|
|
|
$row_gnichtda = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$row_nichtda['grund']."'");
|
|
|
|
if($row_gnichtda['nichtda']==1) { //-- fahrer den ganzen tag nicht da
|
|
$tag_tour2[$key]['fahrernichtda']=1;
|
|
} else {
|
|
if($row['fahrer']!=$row_tour['s_fahrer']) {
|
|
$tag_tour2[$key]['fahrernichtda']=2;
|
|
}
|
|
if($row_gnichtda['nichtda']==$row['typ']) { //-- kein dieser touren typ nicht der fahrer da
|
|
$tag_tour2[$key]['fahrernichtda']=1;
|
|
}
|
|
}
|
|
} else {
|
|
if($row['fahrer']!=$row_tour['s_fahrer']) { $tag_tour2[$key]['fahrernichtda']=2; }
|
|
}
|
|
//----------- auto
|
|
$tag_tour2[$key]['autonichtda']=0;
|
|
$row_anichtda = $GLOBALS['mysql']->query_single("SELECT * FROM fplaner WHERE fid='".$row['auto']."' AND tag='".$tag1_tag."' AND monat='".$tag1_monat."' AND jahr='".$tag1_jahr."'");
|
|
if($row_anichtda['num_rows'] != 0) { $tag_tour2[$key]['autonichtda']=1; }
|
|
if($tag_tour2[$key]['autonichtda']!=1) { if($row['auto']!=$row_tour['s_auto']) { $tag_tour2[$key]['autonichtda']=2; }}
|
|
|
|
$tag_tour2[$key]['infotext']=$row['infotext'];
|
|
|
|
$data_fahrer1 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'"); $tag_tour2[$key]['fahrer_name']=$data_fahrer1['name'];
|
|
$data_auto1 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'"); $tag_tour2[$key]['kennz']=$data_auto1['kz'];
|
|
|
|
$key++;
|
|
}
|
|
if ($test>0) { $test=0; $tag_tour2[$key]['tour']=99999999; $key++; }// trennlinie
|
|
}
|
|
//-------------------------------------------------------------------------------------------
|
|
//-------------------------------------------------------------------------------------------
|
|
//-------------------------------------------------------------------------------------------
|
|
//-------------------------------------------------------------------------------------------
|
|
//-------------------------------------------------------------------------------------------
|
|
//-------------------------------------------------------------------------------------------
|
|
//-------------------------------------------------------------------------------------------
|
|
//-------------------------------------------------------------------------------------------
|
|
//-------------------------------------------------------------------------------------------
|
|
//-------------------------------------------------------------------------------------------
|
|
//-------------------------------------------------------------------------------------------
|
|
$template->assign('tag', $tag);
|
|
$template->assign('monat', $monat);
|
|
$template->assign('jahr', $jahr);
|
|
|
|
$template->assign('maf1', $maf1);
|
|
$template->assign('faf1', $faf1);
|
|
$template->assign('tag1', $tag1);
|
|
$template->assign('tag_tour2', $tag_tour2);
|
|
|
|
$template->assign('content', 'tpl/heute.tpl');
|
|
?>
|