<?php
$_SESSION['m1']=3; $_SESSION['m2']=14;
echo "test";
	error_reporting(E_ALL);	error_reporting(1);

//--------- jahrauswahl

$pjahr=date('W', (mktime(0, 0, 0, 1, 1, $jahr+1) - 4*86400)); 
$ijahr=date('W', (mktime(0, 0, 0, 1, 1, $jahr) - 4*86400)); 
$mjahr=date('W', (mktime(0, 0, 0, 1, 1, $jahr-1) - 4*86400)); 
if($_GET['wahl']==1) { 
	if($_GET['kw']==1) { 
		$kw=$mjahr; $jahr=$_GET['jahr']-1;
	} else { 
		$kw=$_GET['kw']-1; $jahr=$_GET['jahr'];
	}
}
elseif($_GET['wahl']==2) { 
	if($_GET['kw']==$ijahr) { 
		$kw=1; $jahr=$_GET['jahr']+1; 
	} else { 
		$kw=$_GET['kw']+1; $jahr=$_GET['jahr']; 
	}
} else {   
	if(isset($_GET['jahr'])) {  $jahr = $_GET['jahr']; } else { $jahr = (int)date('Y'); }
	if(isset($_GET['kw'])) {    $kw   = $_GET['kw'];   } else { $kw = (int)date('W'); }
		
}


//-----------------------------------------------
//      echo "<pre>";       print_r($ssz);       echo "</pre>";
//------------------------------------------------------------------------------------------------------------

//------------------------------------------------------------------------------------------------------------

//------------------------------------------------------------------------------------------------------------
if(isset($_POST['msg'])) {
	$infotest = $GLOBALS['mysql']->query_single("SELECT * FROM fazinfo WHERE abonr='".$_POST['abonr']."'");
	if($infotest['num_rows']==0) {
		$GLOBALS['mysql']->insert("INSERT INTO fazinfo (abonr,info) 
		VALUES(
		'".$_POST['abonr']."',
		'".$_POST['msg']."')
		"); 					 
		
	} else {
		$GLOBALS['mysql']->insert("UPDATE fazinfo SET info='".$_POST['msg']."' WHERE abonr='".$_POST['abonr']."'");		
	}
}	
//------------------------------------------------------------------------------------------------------------
//------------------------------------------------------------------------------------------------------------

//------------------------------------------------------------------------------------------------------------
//------------------------------------------ auswahla Auslesen
if(isset($_GET['edit'])) { 
	$template->assign('edit',$_GET['edit']); 
	//$haupt = $GLOBALS['mysql']->query_array("SELECT * FROM fazs WHERE plz='".$anz."' and jahr='".$jahr."' and kw='".$kw."' order by strasse"); 
	//$template->assign('haupt', $haupt);
	if(isset($_GET['iabo'])) {
		$infoanz = $GLOBALS['mysql']->query_single("SELECT * FROM fazs WHERE auftragnr='".$_GET['iabo']."'");
		$template->assign('infoanz', $infoanz);
		//-------------- informationen für Zusteller
		$i_tour=$GLOBALS['mysql']->query_single("SELECT * FROM fazinfo WHERE abonr='".$_GET['iabo']."'");
		if($i_tour['num_rows'] !=0) { 
			$template->assign('kdnrinfo', $i_tour['info']);
			$template->assign('ubk', $i_tour['unbekannt']);			
		}
		$fazw_tour = $GLOBALS['mysql']->query("SELECT * FROM fazs WHERE auftragnr='".$_GET['iabo']."'"); $key=0;
		//echo "<pre>";       print_r($fazw_tour);       echo "</pre>";
		while($row = $fazw_tour->fetch_assoc()) {
			$aboinfo[$key]['datum']=	$row['zustelldate'];
			$aboinfo[$key]['meldung']=	$row['meldung'];
			$aboinfo[$key]['abo']=	$row['abo'];
			$aboinfo[$key]['id']=	$row['id'];
			$aboinfo[$key]['rekla']=$row['rekla'];
			$aboinfo[$key]['nl']=	$row['nl'];
			//-------------- wer ist wann gefahren id auslesen
			$tliste1 = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE tag='".$row['tag']."' and monat='".$row['monat']."' and jahr='".$row['jahr']."' and tour='".$row['plz']."'");
			//-------------- wer ist wann gefahren id in Namen umwandeln
			$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$tliste1['fahrer']."'"); 
			$aboinfo[$key]['fahrer']=	$row_fahrerx['name'];
			
			$aboinfo[$key]['name']=		$row['name'];
			$key++;	
			$template->assign('aboinfo', $aboinfo);
			//echo "<pre>";       print_r($row);       echo "</pre>";
			
		}
	}

//		$testa = $GLOBALS['mysql']->query("SELECT * FROM fazs WHERE plz='".$row['tour3']."' and kw='".$kw."' and jahr='".$jahr."'"); $menge=0;			
//		$aboanz = $GLOBALS['mysql']->query_single("SELECT * FROM fazs WHERE plz='".$anz."' and jahr='".$jahr."' and kw='".$kw."' order by strasse"); 
}
if(isset($_GET['anz'])) {
	$anz=$_GET['anz']; 
	if($anz>0) {
		$haupt = $GLOBALS['mysql']->query_array("SELECT * FROM fazs WHERE plz='".$anz."' and jahr='".$jahr."' and kw='".$kw."' order by strasse"); 
		$template->assign('haupt', $haupt);
	} 
} else {
	$anz=0; 
}
$template->assign('anz', $anz);  
//------------------------------------------------------------------------------------------------------------
//	echo'<pre>'; print_r($rowf); echo'</pre>'; 
//----------------------------------------------------------------------------------------------------------------------------------------
$menue1 = $GLOBALS['mysql']->query_array("SELECT * FROM touren WHERE typ=15 and utyp=1"); $template->assign('menue1', $menue1);
$menue2 = $GLOBALS['mysql']->query_array("SELECT * FROM touren WHERE typ=15 and utyp=2"); $template->assign('menue2', $menue2);
$menue3 = $GLOBALS['mysql']->query_array("SELECT * FROM touren WHERE typ=15 and utyp=3"); $template->assign('menue3', $menue3);
$menue4 = $GLOBALS['mysql']->query_array("SELECT * FROM touren WHERE typ=15 and utyp=4"); $template->assign('menue4', $menue4); 
//----------------------------------------------------------------------------------------------------------------------------------------
//----------------------------------------- Stückzahlen eingestellt KW -------------------------------------------------------------------
//----------------------------------------------------------------------------------------------------------------------------------------
$fazw_tour = $GLOBALS['mysql']->query("SELECT * FROM touren WHERE typ=15 and utyp=1"); $mengeW=0; 
while($row = $fazw_tour->fetch_assoc()) {
	$testa = $GLOBALS['mysql']->query("SELECT * FROM fazs WHERE plz='".$row['tour3']."' and kw='".$kw."' and jahr='".$jahr."'"); $menge=0;	
	while($rowf = $testa->fetch_assoc()) {
		$menge=$menge+$rowf['abo'];
	}
	$mengeW=$mengeW+$menge;
}
//----------------------------------------------------------------------------------------------------------------------------------------
$fazn_tour = $GLOBALS['mysql']->query("SELECT * FROM touren WHERE typ=15 and utyp=2"); $mengeN=0;
while($row = $fazn_tour->fetch_assoc()) {
	$testa = $GLOBALS['mysql']->query("SELECT * FROM fazs WHERE plz='".$row['tour3']."' and kw='".$kw."' and jahr='".$jahr."'"); $menge=0;	
	while($rowf = $testa->fetch_assoc()) {
		$menge=$menge+$rowf['abo'];
	}
	$mengeN=$mengeN+$menge;
}
//----------------------------------------------------------------------------------------------------------------------------------------
$fazs_tour = $GLOBALS['mysql']->query("SELECT * FROM touren WHERE typ=15 and utyp=3"); $mengeS=0;
while($row = $fazs_tour->fetch_assoc()) {
	$testa = $GLOBALS['mysql']->query("SELECT * FROM fazs WHERE plz='".$row['tour3']."' and kw='".$kw."' and jahr='".$jahr."'"); $menge=0;	
	while($rowf = $testa->fetch_assoc()) {
		$menge=$menge+$rowf['abo'];
	}
	$mengeS=$mengeS+$menge;
}
//----------------------------------------------------------------------------------------------------------------------------------------
$fazs_tour = $GLOBALS['mysql']->query("SELECT * FROM touren WHERE typ=15 and utyp=4"); $mengeO=0;
while($row = $fazs_tour->fetch_assoc()) {
	$testa = $GLOBALS['mysql']->query("SELECT * FROM fazs WHERE plz='".$row['tour3']."' and kw='".$kw."' and jahr='".$jahr."'"); $menge=0;	
	while($rowf = $testa->fetch_assoc()) {
		$menge=$menge+$rowf['abo'];
	}
	$mengeO=$mengeO+$menge;
}
//----------------------------------------------------------------------------------------------------------------------------------------
$mengeG=$mengeW+$mengeN+$mengeS+$mengeO; 
$template->assign('mengeW', $mengeW);
$template->assign('mengeN', $mengeN);
$template->assign('mengeS', $mengeS);
$template->assign('mengeO', $mengeO);
$template->assign('mengeG', $mengeG);
//----------------------------------------------------------------------------------------------------------------------------------------
//----------------------------------------- Veränderungen --------------------------------------------------------------------------------
//----------------------------------------------------------------------------------------------------------------------------------------
$fazw_tour = $GLOBALS['mysql']->query("SELECT * FROM touren WHERE typ=15 and utyp=1"); $mengeVW=0; 
while($row = $fazw_tour->fetch_assoc()) {
	$testa = $GLOBALS['mysql']->query("SELECT * FROM fazv WHERE plz='".$row['tour3']."' and kw='".$kw."' and jahr='".$jahr."'"); 	
	while($rowf = $testa->fetch_assoc()) {
		$mengeVW++;
	}
}
//----------------------------------------------------------------------------------------------------------------------------------------
$fazn_tour = $GLOBALS['mysql']->query("SELECT * FROM touren WHERE typ=15 and utyp=2"); $mengeVN=0;
while($row = $fazn_tour->fetch_assoc()) {
	$testa = $GLOBALS['mysql']->query("SELECT * FROM fazv WHERE plz='".$row['tour3']."' and kw='".$kw."' and jahr='".$jahr."'"); 	
	while($rowf = $testa->fetch_assoc()) {
		$mengeVN++;
	}
}
//----------------------------------------------------------------------------------------------------------------------------------------
$fazs_tour = $GLOBALS['mysql']->query("SELECT * FROM touren WHERE typ=15 and utyp=3"); $mengeVS=0;
while($row = $fazs_tour->fetch_assoc()) {
	$testa = $GLOBALS['mysql']->query("SELECT * FROM fazv WHERE plz='".$row['tour3']."' and kw='".$kw."' and jahr='".$jahr."'"); 	
	while($rowf = $testa->fetch_assoc()) {
		$mengeVS++;
	}
}
//----------------------------------------------------------------------------------------------------------------------------------------
$fazs_tour = $GLOBALS['mysql']->query("SELECT * FROM touren WHERE typ=15 and utyp=4"); $mengeVO=0;
while($row = $fazs_tour->fetch_assoc()) {
	$testa = $GLOBALS['mysql']->query("SELECT * FROM fazv WHERE plz='".$row['tour3']."' and kw='".$kw."' and jahr='".$jahr."'"); 	
	while($rowf = $testa->fetch_assoc()) {
		$mengeVO++;
	}
}
//----------------------------------------------------------------------------------------------------------------------------------------
$mengeVG=$mengeVW+$mengeVN+$mengeVS+$mengeVO; 
$template->assign('mengeVW', $mengeVW);
$template->assign('mengeVN', $mengeVN);
$template->assign('mengeVS', $mengeVS);
$template->assign('mengeVO', $mengeVO);
$template->assign('mengeVG', $mengeVG);
//----------------------------------------------------------------------------------------------------------------------------------------
//-------------- Datensätze zählen
$data1 = $GLOBALS['mysql']->query_single("SELECT * FROM fazs WHERE kw='".$kw."' and jahr='".$jahr."'"); $datas=0;
if($data1['num_rows'] != 0) { $datas++; $template->assign('danz1', $data1['num_rows']); }
$data2 = $GLOBALS['mysql']->query_single("SELECT * FROM fazv WHERE kw='".$kw."' and jahr='".$jahr."'");
if($data2['num_rows'] != 0) { $datas++; $template->assign('danz2', $data2['num_rows']); }
if($datas != 0) { $template->assign('dataanz', $datas); }
//----------------------------------------------------------------------------------------------------------------------------------------
//-----------------------------------------------

//-----------------------------------------------
$template->assign('jahr', $jahr);	      
$template->assign('kw', $kw);	
$template->assign('datum', $datum);	  
$template->assign('content', 'tpl/ifazs.tpl');	  
?>