<?php


$tagp = strtotime("+0 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day1=$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()) {
		$maf1[$key]['tag']=$tag;
		$maf1[$key]['monat']=$row['monat'];
		$maf1[$key]['jahr']=$row['jahr'];								
		$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++;
	}
$tagp = strtotime("+1 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day2=$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()) {
		$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++;
	}
$tagp = strtotime("+2 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day3=$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()) {
		$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++;
	}
$tagp = strtotime("+3 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day4=$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()) {
		$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++;
	}
$tagp = strtotime("+4 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day5=$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()) {
		$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++;
	}				
$tagp = strtotime("+5 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day6=$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()) {
		$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++;
	}	
$tagp = strtotime("+6 day"); $tag = date("d",$tagp); $monat = date("m",$tagp); $jahr = date("Y",$tagp); $day7=$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()) {
		$maf7[$key]['tag']=$tag;
		$maf7[$key]['monat']=$row['monat'];
		$maf7[$key]['jahr']=$row['jahr'];								
		$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++;
	}			
	

//			$success="Neu: Kalender (Urlaub-frei-krank) ***** Datenbank anpassung Feiertage 2014 ***** PIN Touren 04/12/14-a added";
//			$template->assign('information', $success);

//------------------------------------------------------------------------- änder kw !!!!!!!!!!!!
$tag1_jahr = date("Y"); 
$tag1_monat = date("m"); 
$tag1_tag = date("d"); 
//----------------------------  änderungen !!!!!!!!!!
$wtag = date("w");
if($wtag == "0") { 
	$tp1 = strtotime("+1 day");
	$tp2 = strtotime("+2 day"); 
} else if($wtag == "6") {
	$tp1 = strtotime("+0 day");
	$tp2 = strtotime("+2 day");
} else {
	$tp1 = strtotime("+0 day");
	$tp2 = strtotime("+1 day");
}
$tag1 = date("d.m.Y", $tp1); $tag1_tag = date("d",$tp1); $tag1_monat = date("m",$tp1); $tag1_jahr = date("Y",$tp1);
$tag2 = date("d.m.Y", $tp2); $tag2_tag = date("d",$tp2); $tag2_monat = date("m",$tp2); $tag2_jahr = date("Y",$tp2);
//---------------------------- heute änderungen !!!!!!!!!!
	$tour1 = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$tag1_tag."' AND monat='".$tag1_monat."' AND jahr='".$tag1_jahr."'"); $key=0;
	while($row = $tour1->fetch_assoc()) {
		$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
        $stamma=$row_tour['s_auto']; 
		$stammf=$row_tour['s_fahrer'];
		if($stamma != $row['auto'] OR $stammf != $row['fahrer']) { 
			if($row['typ']==3) {
				$gh1[$key]['id']=$row['id'];
				$gh1[$key]['tour']=$row_tour['tour'];
				$row_fahrer1 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'"); 
				$gh1[$key]['fahrer']=$row_fahrer1['name'];
				$row_auto1 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'"); 
				$gh1[$key]['kennz']=$row_auto1['kz']; $key++;
			}
			if($row['typ']==4) {
				$lvz1[$key]['id']=$row['id'];
				$lvz1[$key]['tour']=$row_tour['tour'];
				$row_fahrer1 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'"); 
				$lvz1[$key]['fahrer']=$row_fahrer1['name'];
				$row_auto1 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'"); 
				$lvz1[$key]['kennz']=$row_auto1['kz']; $key++;
			}
			if($row['typ']==5) {
				$pin1[$key]['id']=$row['id'];
				$pin1[$key]['tour']=$row_tour['tour'];
				$row_fahrer1 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'"); 
				$pin1[$key]['fahrer']=$row_fahrer1['name'];
				$row_auto1 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'"); 
				$pin1[$key]['kennz']=$row_auto1['kz']; $key++;
			}
			if($row['typ']==6) {
				$post1[$key]['id']=$row['id'];
				$post1[$key]['tour']=$row_tour['tour'];
				$row_fahrer1 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'"); 
				$post1[$key]['fahrer']=$row_fahrer1['name'];
				$row_auto1 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'"); 
				$post1[$key]['kennz']=$row_auto1['kz']; $key++;
			}	
			if($row['typ']>6) {
				$werb1[$key]['id']=$row['id'];
				$werb1[$key]['tour']=$row_tour['tour'];
				$row_fahrer1 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'"); 
				$werb1[$key]['fahrer']=$row_fahrer1['name'];
				$row_auto1 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'"); 
				$werb1[$key]['kennz']=$row_auto1['kz']; $key++;
			}				
		}
	}
//---------------------------- morgen änderungen !!!!!!!!!!
	$tour1 = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$tag2_tag."' AND monat='".$tag2_monat."' AND jahr='".$tag2_jahr."'"); $key=0;
	while($row = $tour1->fetch_assoc()) {
		$row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
        $stamma=$row_tour['s_auto']; 
		$stammf=$row_tour['s_fahrer'];
		if($stamma != $row['auto'] OR $stammf != $row['fahrer']) { 
			if($row['typ']==3) {
				$gh2[$key]['id']=$row['id'];
				$gh2[$key]['tour']=$row_tour['tour'];
				$row_fahrer1 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'"); 
				$gh2[$key]['fahrer']=$row_fahrer1['name'];
				$row_auto1 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'"); 
				$gh2[$key]['kennz']=$row_auto1['kz']; $key++;
			}
			if($row['typ']==4) {
				$lvz2[$key]['id']=$row['id'];
				$lvz2[$key]['tour']=$row_tour['tour'];
				$row_fahrer1 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'"); 
				$lvz2[$key]['fahrer']=$row_fahrer1['name'];
				$row_auto1 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'"); 
				$lvz2[$key]['kennz']=$row_auto1['kz']; $key++;
			}
			if($row['typ']==5) {
				$pin2[$key]['id']=$row['id'];
				$pin2[$key]['tour']=$row_tour['tour'];
				$row_fahrer1 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'"); 
				$pin2[$key]['fahrer']=$row_fahrer1['name'];
				$row_auto1 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'"); 
				$pin2[$key]['kennz']=$row_auto1['kz']; $key++;
			}
			if($row['typ']==6) {
				$post2[$key]['id']=$row['id'];
				$post2[$key]['tour']=$row_tour['tour'];
				$row_fahrer1 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'"); 
				$post2[$key]['fahrer']=$row_fahrer1['name'];
				$row_auto2 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'"); 
				$post2[$key]['kennz']=$row_auto2['kz']; $key++;
			}	
			if($row['typ']>6) {
				$werb2[$key]['id']=$row['id'];
				$werb2[$key]['tour']=$row_tour['tour'];
				$row_fahrer2 = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'"); 
				$werb2[$key]['fahrer']=$row_fahrer2['name'];
				$row_auto2 = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'"); 
				$werb2[$key]['kennz']=$row_auto2['kz']; $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('gh1', $gh1);
	$template->assign('lvz1', $lvz1);
	$template->assign('pin1', $pin1);
	$template->assign('post1', $post1);
	$template->assign('werb1', $werb1);
	$template->assign('gh2', $gh2);
	$template->assign('lvz2', $lvz2);
	$template->assign('pin2', $pin2);
	$template->assign('post2', $post2);
	$template->assign('werb2', $werb2);
	$template->assign('tag1', $tag1);
	$template->assign('tag2', $tag2);
	
	
	$template->assign('content', 'tpl/kalender99.tpl');
//$template->assign('content', 'tpl/home9.tpl');	
?>