<?php
$_SESSION['m1']=11; $_SESSION['m2']=0;

//	error_reporting(E_ALL);
	ini_set('display_errors', 1);


$tagname = array("Sonntag", "Montag", "Dienstag", "Mittwoch", "Donnerstag", "Freitag", "Samstag");

$wtag = date("w");//// wochentag als zahl

$ma_info = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$_SESSION['benutzer']."'");

$tp1 = strtotime("+0 day"); $tag1_tag = date("d",$tp1); $tag1_monat = date("m",$tp1); $tag1_jahr = date("Y",$tp1); $tag1=$tagname[date("w",$tp1)].", den ".$tag1_tag.".".$tag1_monat.".".$tag1_jahr;
$tp2 = strtotime("+1 day"); $tag2_tag = date("d",$tp2); $tag2_monat = date("m",$tp2); $tag2_jahr = date("Y",$tp2); $tag2=$tagname[date("w",$tp2)].", den ".$tag2_tag.".".$tag2_monat.".".$tag2_jahr; 
$tp3 = strtotime("+2 day"); $tag3_tag = date("d",$tp3); $tag3_monat = date("m",$tp3); $tag3_jahr = date("Y",$tp3); $tag3=$tagname[date("w",$tp3)].", den ".$tag3_tag.".".$tag3_monat.".".$tag3_jahr;
$tp4 = strtotime("+3 day"); $tag4_tag = date("d",$tp4); $tag4_monat = date("m",$tp4); $tag4_jahr = date("Y",$tp4); $tag4=$tagname[date("w",$tp4)].", den ".$tag4_tag.".".$tag4_monat.".".$tag4_jahr;
$tp5 = strtotime("+4 day"); $tag5_tag = date("d",$tp5); $tag5_monat = date("m",$tp5); $tag5_jahr = date("Y",$tp5); $tag5=$tagname[date("w",$tp5)].", den ".$tag5_tag.".".$tag5_monat.".".$tag5_jahr;
$tp6 = strtotime("+5 day"); $tag6_tag = date("d",$tp6); $tag6_monat = date("m",$tp6); $tag6_jahr = date("Y",$tp6); $tag6=$tagname[date("w",$tp6)].", den ".$tag6_tag.".".$tag6_monat.".".$tag6_jahr;
$tp7 = strtotime("+6 day"); $tag7_tag = date("d",$tp7); $tag7_monat = date("m",$tp7); $tag7_jahr = date("Y",$tp7); $tag7=$tagname[date("w",$tp7)].", den ".$tag7_tag.".".$tag7_monat.".".$tag7_jahr;
$tp8 = strtotime("+7 day"); $tag8_tag = date("d",$tp8); $tag8_monat = date("m",$tp8); $tag8_jahr = date("Y",$tp8); $tag8=$tagname[date("w",$tp8)].", den ".$tag8_tag.".".$tag8_monat.".".$tag8_jahr;
$tp9 = strtotime("+8 day"); $tag9_tag = date("d",$tp9); $tag9_monat = date("m",$tp9); $tag9_jahr = date("Y",$tp9); $tag9=$tagname[date("w",$tp9)].", den ".$tag9_tag.".".$tag9_monat.".".$tag9_jahr;

$key=0;
//-------------- 1. Tag 
$tour_array = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$tag1_tag."' AND monat='".$tag1_monat."' AND jahr='".$tag1_jahr."' and fahrer='".$_SESSION['benutzer']."'");
while($row = $tour_array->fetch_assoc()) {
	$row_tourn = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
	$ma_tour1[$key]['tour']=$row_tourn['tour'];
	$ma_tour1[$key]['zeit']=$row['zeit']; 									if($row['zeit']='') { $ma_tour1[$key]['zeit']="00:00"; }
	$ma_tour1[$key]['gewicht']=$row['gewicht'];  							if($row['gewicht']='') { $ma_tour1[$key]['gewicht']="0"; }
    $row_autox = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'"); 
	$ma_tour1[$key]['auto']=$row_autox['kz'];
	$ma_tour1[$key]['infotext']=$row['infotext'];		
	$key++;	
}
$normp1 = $GLOBALS['mysql']->query_single("SELECT * FROM normplan WHERE tag='".$tag1_tag."' AND monat='".$tag1_monat."' AND jahr='".$tag1_jahr."'");
//-------------- 2. Tag 
$tour_array = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$tag2_tag."' AND monat='".$tag2_monat."' AND jahr='".$tag2_jahr."' and fahrer='".$_SESSION['benutzer']."'");
while($row = $tour_array->fetch_assoc()) {
	$row_tourn = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
	$ma_tour2[$key]['tour']=$row_tourn['tour'];
	$ma_tour2[$key]['zeit']=$row['zeit']; 									if($row['zeit']='') { $ma_tour2[$key]['zeit']="00:00"; }
	$ma_tour2[$key]['gewicht']=$row['gewicht'];  							if($row['gewicht']='') { $ma_tour2[$key]['gewicht']="0"; }
    $row_autox = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'"); 
	$ma_tour2[$key]['auto']=$row_autox['kz'];
	$ma_tour2[$key]['infotext']=$row['infotext'];		
	$key++;	
}
$normp2 = $GLOBALS['mysql']->query_single("SELECT * FROM normplan WHERE tag='".$tag2_tag."' AND monat='".$tag2_monat."' AND jahr='".$tag2_jahr."'");
//-------------- 3. Tag 
$tour_array = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$tag3_tag."' AND monat='".$tag3_monat."' AND jahr='".$tag3_jahr."' and fahrer='".$_SESSION['benutzer']."'");
while($row = $tour_array->fetch_assoc()) {
	$row_tourn = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
	$ma_tour3[$key]['tour']=$row_tourn['tour'];
	$ma_tour3[$key]['zeit']=$row['zeit']; 									if($row['zeit']='') { $ma_tour3[$key]['zeit']="00:00"; }
	$ma_tour3[$key]['gewicht']=$row['gewicht'];  							if($row['gewicht']='') { $ma_tour3[$key]['gewicht']="0"; }
    $row_autox = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'"); 
	$ma_tour3[$key]['auto']=$row_autox['kz'];
	$ma_tour3[$key]['infotext']=$row['infotext'];		
	$key++;	
}
//-------------- 4. Tag 
$tour_array = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE tag='".$tag4_tag."' AND monat='".$tag4_monat."' AND jahr='".$tag4_jahr."' and fahrer='".$_SESSION['benutzer']."'");
while($row = $tour_array->fetch_assoc()) {
	$row_tourn = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
	$ma_tour4[$key]['tour']=$row_tourn['tour'];
	$ma_tour4[$key]['zeit']=$row['zeit']; 									if($row['zeit']='') { $ma_tour4[$key]['zeit']="00:00"; }
	$ma_tour4[$key]['gewicht']=$row['gewicht'];  							if($row['gewicht']='') { $ma_tour4[$key]['gewicht']="0"; }
    $row_autox = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'"); 
	$ma_tour4[$key]['auto']=$row_autox['kz'];
	$ma_tour4[$key]['infotext']=$row['infotext'];		
	$key++;	
}
//-------------------------------------------------------------------
//------------------------------ kalende pro mitarbeiter pro Monat
$key=0;	
$kal_array = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE jahr='".$tag1_jahr."' AND monat='".$tag1_monat."' and mid='".$_SESSION['benutzer']."'");
while($row = $kal_array->fetch_assoc()) {
	$kal[$key]['datum']=$row['tag'].".".$row['monat'].".".$row['jahr'];
	$row_kal = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$row['grund']."'"); 
	$kal[$key]['grund']=$row_kal['bez'];
	$kal[$key]['icon']=$row_kal['icon'];
	$key++;
}
//-------------------------------------------------------------------

	$template->assign('normp1', $normp1);
	$template->assign('normp2', $normp2);	

	$template->assign('monat', $tag1_monat);
	$template->assign('jahr', $tag1_jahr);
	
	$template->assign('kal', $kal);

	$template->assign('tag1', $tag1);
	$template->assign('tag2', $tag2);
	$template->assign('tag3', $tag3);
	$template->assign('tag4', $tag4);
	
	$template->assign('ma_tour1', $ma_tour1);
	$template->assign('ma_tour2', $ma_tour2);
	$template->assign('ma_tour3', $ma_tour3);
	$template->assign('ma_tour4', $ma_tour4);
	
	$template->assign('ma_info', $ma_info);
	
	
	$template->assign('content', 'tpl/11_index.tpl');
?>