<?php
	error_reporting(E_ALL);
//	error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE);
	ini_set('display_errors', 0); 

$monat = (int)date('n');
$jahr = (int)date('Y');
//$mitarbeiter=1;
$kw_aktuell = (int)date('W');	

if(isset($_POST['save'])) {

    $row_firmax = $GLOBALS['mysql']->query_single("SELECT * FROM firmen WHERE id='".$_POST['ma1']."'"); 
    $a_name=$row_firmax['name'];
	$a_monat=$_POST['ma2'];
	$a_jahr=$_POST['ma3'];


//------------------ GH
	$key=0; $keytour=0; $zahl=0;
	$firmatouren = $GLOBALS['mysql']->query("SELECT * FROM touren WHERE afirma='".$_POST['ma1']."' ORDER BY tour");
	while($rowfirma = $firmatouren->fetch_assoc()) {
		$tour[$keytour]['id']=$rowfirma['id'];
		$tour[$keytour]['tour']=$rowfirma['tour'];
		$tour[$keytour]['stammf']=$rowfirma['s_fahrer'];		
		$tour[$keytour]['infotitel']=$rowfirma['infotitel'];
		
		$keytour++;
	}
	for($zahl = 0; $zahl < $keytour; $zahl++) {
		$tmptour = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$_POST['ma2']."' AND jahr='".$_POST['ma3']."' AND tour='".$tour[$zahl]['id']."' ORDER BY tag");
		while($row = $tmptour->fetch_assoc()) {
			$tour1[$key]['tour']=$tour[$zahl]['tour'];
			if($tour[$zahl]['stammf'] == $row['fahrer']) { $tour1[$key]['fremd']=1; } else { $tour1[$key]['fremd']=0; }
			$tour1[$key]['id']=$row['id'];
			$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'"); 
			$tour1[$key]['fahrer']=$row_fahrerx['name'];
			$tour1[$key]['tag']=$row['tag'];
			$tour1[$key]['monat']=$row['monat'];
			$tour1[$key]['jahr']=$row['jahr'];
			$row_autox = $GLOBALS['mysql']->query_single("SELECT * FROM fahrzeuge WHERE id='".$row['auto']."'"); 
			$tour1[$key]['kennz']=$row_autox['kz'];
			$tour1[$key]['infotext']=$row['infotext'];
			$key++;
		}
	}
}


$ma1 = $GLOBALS['mysql']->query_array("SELECT * FROM firmen ORDER BY name");
$ma2['id']=	array(1,2,3,4,5,6,7,8,9,10,11,12);
$ma2['name']=array("Januar","Februar","M&auml;rz","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember");	
$ma2['monat']=$monat;
$ma3['id']=	array(2012,2013,2014,2015,2016,2017,2018,2019,2020);
$ma3['name']=array(2012,2013,2014,2015,2016,2017,2018,2019,2020);
$ma3['jahr']=$jahr;

$template->assign('ma1', $ma1);	
$template->assign('ma2', $ma2);	
$template->assign('ma3', $ma3);		
$template->assign('a_name', $a_name);
$template->assign('a_monat', $a_monat);
$template->assign('a_jahr', $a_jahr);
$template->assign('tour1', $tour1);
$template->assign('keytour', $keytour);

$template->assign('content', 'tpl/a_tour.tpl');		//_list

?>