<?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');
?>