<?php
require('fpdf.php');
	error_reporting(E_ALL);
	error_reporting(E_ALL ^ E_NOTICE);
	// Melde alle PHP Fehler
	error_reporting(1);	

$temp = strtotime("next Sunday");
$stag=date('d', $temp); 
$smonat=date('m', $temp); 
$sjahr=date('Y', $temp);
$sasodatum=$stag.".".$smonat.".".$sjahr;	
echo $sasodatum;


if(isset($_GET['id'])) {
	$saso_tour = $GLOBALS['mysql']->query_single("SELECT * FROM torenplan WHERE tour='".$_GET['id']."' and tag='".$stag."' and monat='".$smonat."' and jahr='".$sjahr."'");
	$mengeabl=$saso_tour['num_rows'];
	$lname=$saso_tour['tour'];
	
	echo "<pre>";       print_r($saso_tour);       echo "</pre>";
//----------------------------
	class PDF extends FPDF {  
		function Footer() {  
			$this->SetY(-15);  
			$this->SetFont('Helvetica','I',8);  
			$this->Cell(190,5,'Zustellservice Heinicke GmbH - Handelsplatz 4 - 04319 Leipzig  *** ZSH - interne Liste - Nach Gebrauch vernichten ***    F. T.2014','1','0','C','0');  
		}  
	}  
	$pdf = new PDF('P','mm','A4');
	$pdf->AddPage();
	//	blau (0,160,230)
	//	Orange (240,150, 0)
	//  grau (200,200,200)
			
			
	$key=0; $abl=0;
//	$rs_tour = $GLOBALS['mysql']->query_single("SELECT * FROM zsh_touren WHERE id='".$_POST['ansicht']."'");
//	$lnummer=$rs_tour['nummer'];
//	$lname=$rs_tour['tour'];
	$pdf->SetFont('Helvetica','B',14); 
	// $pdf->SetTextColor(0,160,230);
	$pdf->SetFillColor(200,200,200);
	$pdf->Cell(60,6,($lname),'0','0','C','1');
	$pdf->Cell(50,6,' ','0','0','C','0'); $pdf->SetFont('Helvetica','',10);
	$pdf->Cell(30,6,'Listennr.: '.($smonat),'0','0','C','1');
	$pdf->Cell(8,6,' ','0','0','C','0');
	$pdf->Cell(40,6,'Ausgabe:  '.($sasodatum),'0','1','R','1');
	$pdf->Cell(24,2,' ','0','1','L','0');


//	$gmenge=0; $gmengea=0; $gmengeb=0; $gmengec=0;			

/*
	$saso_tour = $GLOBALS['mysql']->query_single("SELECT * FROM torenplan WHERE id='".$_GET['id']."' and tag='".$stag."' and monat='".$smonat."' and jahr='".$sjahr."'");


	if($saso_tour['num_rows']) {
	
			$rs_tour2 = $GLOBALS['mysql']->query("SELECT * FROM zsh_tourenliste WHERE tid='".$_POST['tid']."' and nummer='".$lnummer."' AND ablage='".$rowa['id']."' ORDER BY bereich");
			//------------ 
			$pdf->SetFillColor(0,0,0); $pdf->Cell(190,1,' ','0','1','L','1');
			$pdf->SetFont('Helvetica','B',12); $pdf->Cell(110,5,($rowa['strasse'].' - '.$rowa['plz'].' '.$rowa['ort']),'0','0','L','0'); 
			$pdf->SetFont('Helvetica','',10); $pdf->Cell(80,5,$rowa['infotext'],'0','1','R','0');

			while($row = $rs_tour2->fetch_assoc()) {
	//if stammablage ? 
				$pdf->SetFont('Helvetica','B',10);
				$pdf->Cell(88,5,$row['infotext'],'0','0','R','0'); $pdf->SetFont('Helvetica','',10);
				$pdf->Cell(17,5,$row['bereich'],'0','0','R','0');  	
				$pdf->Cell(10,5,$row['norm'].'er','0','0','R','0'); $gnorm=$row['norm'];	
				$pdf->Cell(29,5,$row['exemplare'].' Exemplare','0','0','L','0');  
				$gmenge=$gmenge+$row['exemplare'];
				$pdf->SetFont('Helvetica','B',10);
				$pdf->Cell(5,5,$row['typ'],'0','0','C','0');  	
				if($row['typ']=='A') { $gmenge1=$gmenge1+$row['exemplare']; }
				if($row['typ']=='B') { $gmenge2=$gmenge2+$row['exemplare']; }
				if($row['typ']=='C') { $gmenge3=$gmenge3+$row['exemplare']; }				
				if($row['typ']=='D') { $gmenge4=$gmenge4+$row['exemplare']; }				
				if($row['typ']=='E') { $gmenge5=$gmenge5+$row['exemplare']; }				
				if($row['typ']=='F') { $gmenge6=$gmenge6+$row['exemplare']; }
				if($row['typ']=='G') { $gmenge7=$gmenge7+$row['exemplare']; }				
				if($row['typ']=='H') { $gmenge8=$gmenge8+$row['exemplare']; }												
				$pdf->Cell(3,5,' ','0','0','C','0'); 
				$voll=$row['exemplare']/$row['norm']; $pak2=floor($voll);	
				if($pak2 ==0) { $pdf->Cell(19,5,' ','0','0','R','0'); }
				if($pak2 ==1) { $pdf->Cell(19,5,$pak2.' Paket  ','0','0','R','0'); }
				if($pak2 > 1) { $pdf->Cell(19,5,$pak2.' Pakete','0','0','R','0'); }	
				$tmp2=$pak2*$row['norm']; $tmp3=$row['exemplare']-$tmp2;
				$pdf->Cell(19,5,$tmp3.' Spitze','0','1','R','0'); $pdf->SetFont('Helvetica','',10);

				if($row['mita']>0) {
					$pdf->Cell(88,5,$row['infotext'],'0','0','R','0');
					$pdf->Cell(17,5,' ','0','0','C','0');  	
					$pdf->Cell(10,5,$rs_mitn['mengea'].'er','0','0','C','0'); $gnorma=$rs_mitn['mengea'];	
					$gmengea=$gmengea+$row['mita'];  	
					$pdf->SetFont('Helvetica','B',10);
					$pdf->Cell(37,5,$row['mita'].' '.$rs_mitn['namea'],'0','0','L','0');  
					$voll=$row['mita']/$rs_mitn['mengea']; $pak2=floor($voll);	
					if($pak2 ==0) { $pdf->Cell(19,5,' ','0','0','R','0'); }
					if($pak2 ==1) { $pdf->Cell(19,5,$pak2.' Paket  ','0','0','R','0'); }
					if($pak2 > 1) { $pdf->Cell(19,5,$pak2.' Pakete','0','0','R','0'); }										
					$tmp2=$pak2*$rs_mitn['mengea']; $tmp3=$row['mita']-$tmp2;
					$pdf->Cell(19,5,$tmp3.' Spitze','0','1','R','0'); $pdf->SetFont('Helvetica','',10);				
				}						
				if($row['mitb']>0) {
					$pdf->Cell(88,5,$row['infotext'],'0','0','R','0');
					$pdf->Cell(17,5,' ','0','0','C','0');  	
					$pdf->Cell(10,5,$rs_mitn['mengeb'].'er','0','0','C','0'); $gnormb=$rs_mitn['mengeb'];
					$gmengeb=$gmengeb+$row['mitb'];  						 	
					$pdf->SetFont('Helvetica','B',10);
					$pdf->Cell(37,5,$row['mitb'].' '.$rs_mitn['nameb'],'0','0','L','0');  
					$voll=$row['mitb']/$rs_mitn['mengeb']; $pak2=floor($voll);	
					if($pak2 ==0) { $pdf->Cell(19,5,' ','0','0','R','0'); }
					if($pak2 ==1) { $pdf->Cell(19,5,$pak2.' Paket  ','0','0','R','0'); }
					if($pak2 > 1) { $pdf->Cell(19,5,$pak2.' Pakete','0','0','R','0'); }	
					$tmp2=$pak2*$rs_mitn['mengeb']; $tmp3=$row['mitb']-$tmp2;
					$pdf->Cell(19,5,$tmp3.' Spitze','0','1','R','0'); $pdf->SetFont('Helvetica','',10);				
				}						
				if($row['mitc']>0) {
					$pdf->Cell(88,5,$row['infotext'],'0','0','R','0');
					$pdf->Cell(17,5,' ','0','0','C','0');  	
					$pdf->Cell(10,5,$rs_mitn['mengec'].'er','0','0','C','0'); $gnormc=$rs_mitn['mengec']; 	
					$gmengec=$gmengec+$row['mitc'];  						
					$pdf->SetFont('Helvetica','B',10);
					$pdf->Cell(37,5,$row['mitc'].' '.$rs_mitn['namec'],'0','0','L','0');  
					$voll=$row['mitc']/$rs_mitn['mengec']; $pak2=floor($voll);	
					if($pak2 ==0) { $pdf->Cell(19,5,' ','0','0','R','0'); }
					if($pak2 ==1) { $pdf->Cell(19,5,$pak2.' Paket  ','0','0','R','0'); }
					if($pak2 > 1) { $pdf->Cell(19,5,$pak2.' Pakete','0','0','R','0'); }	
					$tmp2=$pak2*$rs_mitn['mengec']; $tmp3=$row['mitc']-$tmp2;
					$pdf->Cell(19,5,$tmp3.' Spitze','0','1','R','0'); $pdf->SetFont('Helvetica','',10);				
				}						

//				else { $pdf->Cell(1,4,' ','0','1','C','0'); $pdf->SetFont('Helvetica','',10); }
			}
	//		$pdf->Cell(24,2,' ','0','1','L','0');
		}
	}
	$pdf->Cell(88,8,' ','B','0','L','0'); $pdf->Cell(102,8,' ','B','1','L','0'); // ende mit unterstrich

//----------------------------------------------------------------- einzelne Gesamtsaso nach Markierung !!!!!!
//------------- Typ A
	if($gmenge1>0) {
		$pdf->Cell(88,5,' ','0','0','L','0');		
		$pdf->Cell(23,5,'SaSo TYP A: ','0','0','L','0');		
		$pdf->Cell(33,5,$gmenge1.' Exemplare','0','0','R','0');		
		$gvoll=$gmenge1/$gnorm; $gpak2=floor($gvoll);	
		$pdf->SetFont('Helvetica','B',10); $pdf->Cell(5,5,'A','0','0','R','0'); $pdf->SetFont('Helvetica','',10); ////////////// TYP
		$pdf->Cell(22,5,$gpak2.' Pakete','0','0','R','0');
		$tmp2=$gpak2*$gnorm; $tmp3=$gmenge1-$tmp2;
		$pdf->Cell(19,5,$tmp3.' Spitze','0','1','R','0');
	}
//------------- Typ B
	if($gmenge2>0) {
		$pdf->Cell(88,5,' ','0','0','L','0');		
		$pdf->Cell(23,5,'SaSo TYP B: ','0','0','L','0');		
		$pdf->Cell(33,5,$gmenge2.' Exemplare','0','0','R','0');		
		$gvoll=$gmenge2/$gnorm; $gpak2=floor($gvoll);	
		$pdf->SetFont('Helvetica','B',10); $pdf->Cell(5,5,'B','0','0','R','0'); $pdf->SetFont('Helvetica','',10); ////////////// TYP
		$pdf->Cell(22,5,$gpak2.' Pakete','0','0','R','0');
		$tmp2=$gpak2*$gnorm; $tmp3=$gmenge2-$tmp2;
		$pdf->Cell(19,5,$tmp3.' Spitze','0','1','R','0');
}
//------------- Typ C
	if($gmenge3>0) {
		$pdf->Cell(88,5,' ','0','0','L','0');		
		$pdf->Cell(23,5,'SaSo TYP C: ','0','0','L','0');		
		$pdf->Cell(33,5,$gmenge3.' Exemplare','0','0','R','0');		
		$gvoll=$gmenge3/$gnorm; $gpak2=floor($gvoll);	
		$pdf->SetFont('Helvetica','B',10); $pdf->Cell(5,5,'C','0','0','R','0'); $pdf->SetFont('Helvetica','',10); ////////////// TYP
		$pdf->Cell(22,5,$gpak2.' Pakete','0','0','R','0');
		$tmp2=$gpak2*$gnorm; $tmp3=$gmenge3-$tmp2;
		$pdf->Cell(19,5,$tmp3.' Spitze','0','1','R','0');
	}
//------------- Typ D
	if($gmenge4>0) {
		$pdf->Cell(88,5,' ','0','0','L','0');		
		$pdf->Cell(23,5,'SaSo TYP D: ','0','0','L','0');		
		$pdf->Cell(33,5,$gmenge4.' Exemplare','0','0','R','0');		
		$gvoll=$gmenge4/$gnorm; $gpak2=floor($gvoll);	
		$pdf->SetFont('Helvetica','B',10); $pdf->Cell(5,5,'D','0','0','R','0'); $pdf->SetFont('Helvetica','',10); ////////////// TYP
		$pdf->Cell(22,5,$gpak2.' Pakete','0','0','R','0');
		$tmp2=$gpak2*$gnorm; $tmp3=$gmenge4-$tmp2;
		$pdf->Cell(19,5,$tmp3.' Spitze','0','1','R','0');
	}
//------------- Typ E
	if($gmenge5>0) {
		$pdf->Cell(88,5,' ','0','0','L','0');		
		$pdf->Cell(23,5,'SaSo TYP E: ','0','0','L','0');		
		$pdf->Cell(33,5,$gmenge5.' Exemplare','0','0','R','0');		
		$gvoll=$gmenge5/$gnorm; $gpak2=floor($gvoll);	
		$pdf->SetFont('Helvetica','B',10); $pdf->Cell(5,5,'E','0','0','R','0'); $pdf->SetFont('Helvetica','',10); ////////////// TYP
		$pdf->Cell(22,5,$gpak2.' Pakete','0','0','R','0');
		$tmp2=$gpak2*$gnorm; $tmp3=$gmenge5-$tmp2;
		$pdf->Cell(19,5,$tmp3.' Spitze','0','1','R','0');
	}
//------------- Typ F
	if($gmenge6>0) {
		$pdf->Cell(88,5,' ','0','0','L','0');		
		$pdf->Cell(23,5,'SaSo TYP F: ','0','0','L','0');		
		$pdf->Cell(33,5,$gmenge6.' Exemplare','0','0','R','0');		
		$gvoll=$gmenge6/$gnorm; $gpak2=floor($gvoll);	
		$pdf->SetFont('Helvetica','B',10); $pdf->Cell(5,5,'F','0','0','R','0'); $pdf->SetFont('Helvetica','',10); ////////////// TYP
		$pdf->Cell(22,5,$gpak2.' Pakete','0','0','R','0');
		$tmp2=$gpak2*$gnorm; $tmp3=$gmenge6-$tmp2;
		$pdf->Cell(19,5,$tmp3.' Spitze','0','1','R','0');
	}
//------------- Typ G
	if($gmenge7>0) {
		$pdf->Cell(88,5,' ','0','0','L','0');		
		$pdf->Cell(23,5,'SaSo TYP G: ','0','0','L','0');		
		$pdf->Cell(33,5,$gmenge7.' Exemplare','0','0','R','0');		
		$gvoll=$gmenge7/$gnorm; $gpak2=floor($gvoll);	
		$pdf->SetFont('Helvetica','B',10); $pdf->Cell(5,5,'G','0','0','R','0'); $pdf->SetFont('Helvetica','',10); ////////////// TYP
		$pdf->Cell(22,5,$gpak2.' Pakete','0','0','R','0');
		$tmp2=$gpak2*$gnorm; $tmp3=$gmenge7-$tmp2;
		$pdf->Cell(19,5,$tmp3.' Spitze','0','1','R','0');					
	}
//------------- Typ H
	if($gmenge8>0) {
		$pdf->Cell(88,5,' ','0','0','L','0');		
		$pdf->Cell(23,5,'SaSo TYP H: ','0','0','L','0');		
		$pdf->Cell(33,5,$gmenge8.' Exemplare','0','0','R','0');		
		$gvoll=$gmenge8/$gnorm; $gpak2=floor($gvoll);	
		$pdf->SetFont('Helvetica','B',10); $pdf->Cell(5,5,'H','0','0','R','0'); $pdf->SetFont('Helvetica','',10); ////////////// TYP
		$pdf->Cell(22,5,$gpak2.' Pakete','0','0','R','0');
		$tmp2=$gpak2*$gnorm; $tmp3=$gmenge8-$tmp2;
		$pdf->Cell(19,5,$tmp3.' Spitze','0','1','R','0');					
	}
////////////////////////

//----------- Gesamtsaso
	$pdf->SetFont('Helvetica','B',10);
	$pdf->Cell(88,5,' ','0','0','L','0');		
	$pdf->Cell(23,5,'SaSo gesamt: ','0','0','L','0');		$pdf->SetFont('Helvetica','',10);
	$pdf->Cell(33,5,$gmenge.' Exemplare','0','0','R','0'); 		
	$gvoll=$gmenge/$gnorm; $gpak2=floor($gvoll);	
	$pdf->Cell(5,5,' ','0','0','C','0');  $pdf->SetFont('Helvetica','B',10);					////////////// TYP
	$pdf->Cell(22,5,$gpak2.' Pakete','0','0','R','0');
	$tmp2=$gpak2*$gnorm; $tmp3=$gmenge-$tmp2;
	$pdf->Cell(19,5,$tmp3.' Spitze','0','1','R','0');
	$pdf->SetFont('Helvetica','',10);
//------------------------------
//-------------- mitnahmen mit angabe VP !
	if($gmengea>0 || $gmengeb>0 || $gmengec>0) {	
//		$pdf->Cell(190,8,' ','B','1','L','0');	// ende mit unterstrich
//		$pdf->Cell(20,5,'Mitnahmen: ','T','0','L','0'); 
		if($gmengea>0) {
			$w1voll=$gmengea/$gnorma; $gpakw1=floor($w1voll); $tmp2=$gpakw1*$gnorma; $tmp3=$gmengea-$tmp2;
			$pdf->Cell(88,5,' ','0','0','L','0'); 		
			$pdf->Cell(23,5,$rs_mitn['namea'].' :','T','0','L','0'); 	
			$pdf->Cell(33,5,$gmengea.' Exemplare','T','0','R','0'); 				
			$pdf->Cell(5,5,' ','T','0','C','0'); 
			if($gpakw1 ==0) { $pdf->Cell(22,5,' ','T','0','R','0'); }
			if($gpakw1 ==1) { $pdf->Cell(22,5,$gpakw1.' Paket  ','T','0','R','0'); }
			if($gpakw1 > 1) { $pdf->Cell(22,5,$gpakw1.' Pakete','T','0','R','0'); }	
			$pdf->Cell(19,5,$tmp3.' Spitze','T','1','R','0'); 		
		}
		if($gmengeb>0) {
			$w2voll=$gmengeb/$gnormb; $gpakw2=floor($w2voll); $tmp2=$gpakw2*$gnormb; $tmp3=$gmengeb-$tmp2;
			$pdf->Cell(88,5,' ','0','0','L','0'); 		
			$pdf->Cell(23,5,$rs_mitn['nameb'].' :','0','0','L','0'); 	
			$pdf->Cell(33,5,$gmengeb.' Exemplare','0','0','R','0'); 				
			$pdf->Cell(5,5,' ','0','0','C','0'); 
			if($gpakw2 ==0) { $pdf->Cell(22,5,' ','0','0','R','0'); }
			if($gpakw2 ==1) { $pdf->Cell(22,5,$gpakw2.' Paket  ','0','0','R','0'); }
			if($gpakw2 > 1) { $pdf->Cell(22,5,$gpakw2.' Pakete','0','0','R','0'); }	
			$pdf->Cell(19,5,$tmp3.' Spitze','0','1','R','0');			
		}
		if($gmengec>0) {
			$w3voll=$gmengec/$gnormc; $gpakw3=floor($w3voll); $tmp2=$gpakw3*$gnormc; $tmp3=$gmengec-$tmp2;
			$pdf->Cell(88,5,' ','0','0','L','0'); 		
			$pdf->Cell(23,5,$rs_mitn['namec'].' :','0','0','L','0'); 	
			$pdf->Cell(33,5,$gmengec.' Exemplare','0','0','R','0'); 				
			$pdf->Cell(5,5,' ','0','0','C','0'); 
			if($gpakw3 ==0) { $pdf->Cell(22,5,' ','0','0','R','0'); }
			if($gpakw3 ==1) { $pdf->Cell(22,5,$gpakw3.' Paket  ','0','0','R','0'); }
			if($gpakw3 > 1) { $pdf->Cell(22,5,$gpakw3.' Pakete','0','0','R','0'); }	
			$pdf->Cell(19,5,$tmp3.' Spitze','0','1','R','0'); 
		}
	}
	$pdf->Cell(190,8,'-Ende- ','T','1','L','0');	// ende mit unterstrich

	$datum=date("d")."_".date("m")."_".date("Y");
	$gdatum=date("d").".".date("m").".".date("Y");

	if(isset($_POST['ansicht'])) {
		$pdf->Output($lname.'__'.($datum).'.pdf','I');
	}
	else if(isset($_POST['teilen'])) {
		$pdf->Output($lname.'__'.($datum).'.pdf','F');
		$pdf_anhang = $pdf->Output('','S');	
	//---------------------------- PDF umspeichern
		$rs_tour3 = $GLOBALS['mysql']->query("SELECT * FROM zsh_tourenliste WHERE tid='".$_POST['tid']."' and nummer='".$lnummer."'");
		while($row = $rs_tour3->fetch_assoc()) {
			
			$GLOBALS['mysql']->insert("INSERT INTO zsh_tourenliste (tid,bereich,ablage,norm,exemplare,nummer,typ,mita,mitb,mitc,infotext) 
			VALUES(
			'".$row['tid']."',
			'".$row['bereich']."',
			'".$row['ablage']."',
			'".$row['norm']."',			
			'".$row['exemplare']."',
			'".$snummer."',
			'".$typ."',	
			'".$mita."',					
			'".$mitb."',					
			'".$mitc."',											
			'".$row['infotext']."')
			"); 
		}
		$GLOBALS['mysql']->insert("INSERT INTO zsh_mitnahme (tid,nummer) VALUES('".$_POST['tid']."','".$snummer."')"); 
	//------------ nummer in tliste erhöhen	
		$GLOBALS['mysql']->insert("UPDATE zsh_touren SET nummer='".$snummer."' WHERE id='".$_POST['teilen']."'"); 
		$GLOBALS['mysql']->insert("UPDATE zsh_touren SET gdatum='".$gdatum."' WHERE id='".$_POST['teilen']."'"); 
	//----------mail versenden !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
	
		$betreff = "Tourenliste ".$lname;
		$Dateiname = $lname.'__'.($datum).'.pdf';
		$Header = "From: Zustellservice Heinicke GmbH <Vertrieb@Zustellservice-Heinicke.de>";
		$Trenner = md5(uniqid(time()));
		$Header .= "\nMIME-Version: 1.0";
		$Header .= "\nContent-Type: multipart/mixed; boundary=$Trenner";
		$Header .= "\n\nThis is a multi-part message in MIME format";
		$Header .= "\n--$Trenner";
		$Header .= "\nContent-Type: text/plain";
		$Header .= "\nContent-Transfer-Encoding: 8bit";
		$Header .= "\n\n";
		$Header .= "Tourenliste  ".$lname ." für den ".$sasodatum." als Anlage\n\nMfG Zustellservice Heinicke GmbH";//**************Mailtext
		$Header .= "\n--$Trenner";
		$Header .= "\nContent-Type: application/pdf; name=$Dateiname";
		$Header .= "\nContent-Transfer-Encoding: base64";
		$Header .= "\nContent-Disposition: attachment; filename=$Dateiname";
		$file_content = chunk_split(base64_encode($pdf_anhang));
		$Header .= "\n\n$file_content";
		$Header .= "\n\n";
		$Header .= "\n--$Trenner--";
		
	
		if($empfaenger1 != "") { mail($empfaenger1, $betreff, $text, $Header); $success[]='Liste '.$lname.' wurde gespeichert und versendet an: '.$empfaenger1; $template->assign('success', $success); }
		if($empfaenger2 != "") { mail($empfaenger2, $betreff, $text, $Header); $success[]='Liste '.$lname.' wurde gespeichert und versendet an: '.$empfaenger2; $template->assign('success', $success); }
		if($empfaenger3 != "") { mail($empfaenger3, $betreff, $text, $Header); $success[]='Liste '.$lname.' wurde gespeichert und versendet an: '.$empfaenger3; $template->assign('success', $success); }
	}
}
//----------------------------------------- PDF anzeigen version 2--------------------------------------------
//----------------------------------------- PDF anzeigen version 2--------------------------------------------
//----------------------------------------- PDF anzeigen version 2--------------------------------------------
//----------------------------------------- PDF anzeigen version 2--------------------------------------------
//----------------------------------------- PDF anzeigen version 2--------------------------------------------


else if(isset($_POST['version2'])) {
	$saso_tour = $GLOBALS['mysql']->query_single("SELECT * FROM zsh_touren WHERE id='".$_POST['tid']."'");
	$lnummer=$saso_tour['nummer'];
	$snummer=$lnummer+1;
	$lname=$saso_tour['tour'];
	$mname=$saso_tour['mailname'];
//----------------------------
	class PDF extends FPDF {  
		function Footer() {  
			$this->SetY(-15);  
			$this->SetFont('Helvetica','I',8);  
			$this->Cell(190,5,'Zustellservice Heinicke GmbH - Handelsplatz 4 - 04319 Leipzig  *** ZSH - interne Liste - Nach Gebrauch vernichten ***    F. T.2014','1','0','C','0');  
		}  
	}  
	$pdf = new PDF('P','mm','A4');
	$pdf->AddPage();

	$pdf->SetFont('Helvetica','B',14); 
	$pdf->SetFillColor(200,200,200);
	$pdf->Cell(60,6,($_POST['tour']),'0','0','C','1');
	$pdf->Cell(50,6,' ','0','0','C','0'); $pdf->SetFont('Helvetica','',10);
	$pdf->Cell(30,6,'Listennr.: '.($lnummer),'0','0','C','1');
	$pdf->Cell(8,6,' ','0','0','C','0');
	$pdf->Cell(40,6,'Ausgabe:  '.($saso_tour['gdatum']),'0','1','R','1');
	$pdf->Cell(24,2,' ','0','1','L','0');

	$abl = $GLOBALS['mysql']->query("SELECT * FROM zsh_ablagen WHERE tour='".$_POST['tid']."' OR tour2='".$_POST['tid']."' OR tour3='".$_POST['tid']."' OR tour4='".$_POST['tid']."' ORDER BY rfolge");
	while($rowa = $abl->fetch_assoc()) {
//		$pdf->SetFont('Helvetica','B',10);
		$rs_tour = $GLOBALS['mysql']->query_single("SELECT * FROM zsh_tourenliste WHERE tid='".$_POST['tid']."' and nummer='".$lnummer."' AND ablage='".$rowa['id']."'");
		$rs_mitn = $GLOBALS['mysql']->query_single("SELECT * FROM zsh_mitnahme WHERE tid='".$_POST['tid']."' and nummer='".$lnummer."'");

		if ($rs_tour['bereich']>0) {
			$rs_tour2 = $GLOBALS['mysql']->query("SELECT * FROM zsh_tourenliste WHERE tid='".$_POST['tid']."' and nummer='".$lnummer."' AND ablage='".$rowa['id']."' ORDER BY bereich");
			//------------ 
			$pdf->SetFillColor(0,0,0); $pdf->Cell(190,1,' ','0','1','L','1');
			$pdf->SetFont('Helvetica','B',10); $pdf->Cell(55,5,($rowa['strasse']),'1','0','L','0'); $pdf->SetFont('Helvetica','',10);
			

//			$pdf->SetFont('Helvetica','',10); $pdf->Cell(80,5,$rowa['infotext'],'0','1','R','0');
			$tmp=0;
			while($row = $rs_tour2->fetch_assoc()) {


	//if stammablage ? 
				if($tmp==1) { $tmp++; $pdf->SetFont('Helvetica','',10); $pdf->Cell(55,5,($rowa['plz'].' '.$rowa['ort']),'0','0','L','0'); $pdf->SetFont('Helvetica','',10); }
				if($tmp==2) { $tmp++; $pdf->SetFont('Helvetica','',10);  $pdf->Cell(55,5,$rowa['infotext'],'0','0','R','0'); $pdf->SetFont('Helvetica','',10); }					
				if($tmp >2) { $pdf->Cell(55,5,' ','0','0','C','0'); }	
				$pdf->SetFont('Helvetica','',10);
				$pdf->Cell(20,5,$row['bereich'],'0','0','R','0');  	
				$pdf->Cell(11,5,$row['norm'].'er','0','0','R','0');  	
				$pdf->Cell(26,5,$row['exemplare'].' Exemplare','1','0','R','0');  
				$pdf->SetFont('Helvetica','B',10);
				$pdf->Cell(5,5,$row['typ'],'0','0','C','0');  					
//				$pdf->Cell(3,5,$row[' '],'0','0','C','0');  
				$voll=$row['exemplare']/$row['norm']; $pak2=floor($voll);	
				if($pak2 ==0) { $pdf->Cell(14,5,' ','1','0','R','0'); }
				if($pak2 > 0) { $pdf->Cell(14,5,$pak2.' VP','1','0','R','0'); }	
					$tmp2=$pak2*$row['norm']; $tmp3=$row['exemplare']-$tmp2;
				$pdf->Cell(14,5,$tmp3.' Sp.','1','0','R','0'); 
				$pdf->SetFont('Helvetica','',10);
				$pdf->Cell(60,5,$row['infotext'],'1','1','L','0');
				
				if($row['mita']>0 & $rs_mitn['mengea']>0) {
					$pdf->Cell(20,5,$rs_mitn['mengea'].'er','0','0','R','0');  	
					$pdf->SetFont('Helvetica','B',10);
					$pdf->Cell(37,5,$row['mita'].' '.$rs_mitn['namea'],'0','0','L','0');  
						$voll=$row['mita']/$rs_mitn['mengea']; $pak2=floor($voll);	
					if($pak2 ==0) { $pdf->Cell(14,5,' ','0','0','R','0'); }
					if($pak2 > 0) { $pdf->Cell(14,5,$pak2.' VP','0','0','R','0'); }										
						$tmp2=$pak2*$rs_mitn['mengea']; $tmp3=$row['mita']-$tmp2;
					$pdf->Cell(14,5,$tmp3.' Sp.','0','0','R','0'); $pdf->SetFont('Helvetica','',10);				
					$pdf->Cell(60,5,$row['infotext'],'0','1','L','0');	
					if($tmp==0) { $tmp++; $pdf->SetFont('Helvetica','B',10); $pdf->Cell(65,5,($rowa['plz'].' '.$rowa['ort']),'0','0','L','0'); $pdf->SetFont('Helvetica','',10); }
					elseif($tmp==1) { $tmp++; $pdf->SetFont('Helvetica','',10);  $pdf->Cell(65,5,$rowa['infotext'],'0','0','L','0'); $pdf->SetFont('Helvetica','',10); }					
					elseif($tmp >1) { $pdf->Cell(65,5,' ','0','0','R','0'); }
				}						
				if($row['mitb']>0 & $rs_mitn['mengeb']>0) {
					$pdf->Cell(20,5,$rs_mitn['mengea'].'er','0','0','C','0');  	
					$pdf->SetFont('Helvetica','B',10);
					$pdf->Cell(37,5,$row['mita'].' '.$rs_mitn['namea'],'0','0','L','0');  
					$voll=$row['mitb']/$rs_mitn['mengeb']; $pak2=floor($voll);	
					if($pak2 ==0) { $pdf->Cell(14,5,' ','0','0','R','0'); }
					if($pak2 > 0) { $pdf->Cell(14,5,$pak2.' VP','0','0','R','0'); }	
					$tmp2=$pak2*$rs_mitn['mengeb']; $tmp3=$row['mitb']-$tmp2;
					$pdf->Cell(14,5,$tmp3.' Sp.','0','0','R','0'); $pdf->SetFont('Helvetica','',10);				
					$pdf->Cell(60,5,$row['infotext'],'0','1','L','0');		
					if($tmp==0) { $tmp++; $pdf->SetFont('Helvetica','B',10); $pdf->Cell(65,5,($rowa['plz'].' '.$rowa['ort']),'0','0','L','0'); $pdf->SetFont('Helvetica','',10); }
					elseif($tmp==1) { $tmp++; $pdf->SetFont('Helvetica','',10);  $pdf->Cell(65,5,$rowa['infotext'],'0','0','R','0'); $pdf->SetFont('Helvetica','',10); }					
					elseif($tmp >1) { $pdf->Cell(65,5,' ','0','0','C','0'); }
				}						
				if($row['mitc']>0 & $rs_mitn['mengec']>0) {
					$pdf->Cell(20,5,$rs_mitn['mengea'].'er','0','0','C','0');  	
					$pdf->SetFont('Helvetica','B',10);
					$pdf->Cell(37,5,$row['mita'].' '.$rs_mitn['namea'],'0','0','L','0');  
					$voll=$row['mitc']/$rs_mitn['mengec']; $pak2=floor($voll);	
					if($pak2 ==0) { $pdf->Cell(14,5,' ','0','0','R','0'); }
					if($pak2 > 0) { $pdf->Cell(14,5,$pak2.' VP','0','0','R','0'); }	
					$tmp2=$pak2*$rs_mitn['mengec']; $tmp3=$row['mitc']-$tmp2;
					$pdf->Cell(14,5,$tmp3.' Sp.','0','0','R','0'); $pdf->SetFont('Helvetica','',10);				
					$pdf->Cell(60,5,$row['infotext'],'0','1','L','0');			
					if($tmp==0) { $tmp++; $pdf->SetFont('Helvetica','B',10); $pdf->Cell(65,5,($rowa['plz'].' '.$rowa['ort']),'0','0','L','0'); $pdf->SetFont('Helvetica','',10); }
					elseif($tmp==1) { $tmp++; $pdf->SetFont('Helvetica','',10);  $pdf->Cell(65,5,$rowa['infotext'],'0','0','R','0'); $pdf->SetFont('Helvetica','',10); }					
					elseif($tmp >1) { $pdf->Cell(65,5,' ','0','0','C','0'); }					
				}						
				$tmp++;
				if($tmp==1) { $pdf->SetFont('Helvetica','B',10); $pdf->Cell(55,5,($rowa['plz'].' '.$rowa['ort']),'0','1','L','0'); }
				if($tmp==2) { $pdf->SetFont('Helvetica','',10);  $pdf->Cell(55,5,$rowa['infotext'],'0','1','R','0'); }
//				else { $pdf->Cell(1,4,' ','0','1','C','0'); $pdf->SetFont('Helvetica','',10); }
			}
	//		$pdf->Cell(24,2,' ','0','1','L','0');
//			$pdf->Cell(190,5,' ','0','1','L','0');		
		}
	}
	
	$pdf->Cell(24,8,'-Ende-','0','1','L','0');

	$datum=date("d")."_".date("m")."_".date("Y");
	$gdatum=date("d").".".date("m").".".date("Y");

	$pdf->Output($lname.'__'.($datum).'.pdf','I');
}


else if(isset($_POST['history'])) {
	$slist = $GLOBALS['mysql']->query_array("SELECT * FROM zsh_touren WHERE id='".$_POST['history']."'"); 
	$template->assign('tour', $_POST['tour']);	
	$template->assign('slist', $slist);	
	$template->assign('content', 'tpl/zsh_saso_archiv.tpl');

}
elseif(isset($_POST['sasonorm'])) { 
	if($_POST['sasonorm']!=0) { 
		$list2 = $GLOBALS['mysql']->query("SELECT * FROM zsh_touren WHERE typ=8");
		while($row = $list2->fetch_assoc()) {
			$GLOBALS['mysql']->insert("UPDATE zsh_tourenliste SET norm='".$_POST['sasonorm']."' WHERE tid='".$row['id']."' and nummer='".$row['nummer']."'");
		}
		$template->assign('success', 'Die Norm wurde angepasst und alle Touren fuer den kommenden Sonntag neu berechnet...');
	} else {
		$template->assign('error', 'Die Norm darf nicht null sein !!!!!!');
	}

} //else {
*/	
	$slist = $GLOBALS['mysql']->query_array("SELECT * FROM zsh_touren WHERE typ=8");	
	
	$temp = strtotime("next Sunday");
	$tag=date('d', $temp); $monat=date('m', $temp); $jahr=date('Y', $temp);
	$sasodatum=$tag.".".$monat.".".$jahr;
	$sasonorm=$GLOBALS['mysql']->query_single("SELECT * FROM zsh_tourenliste WHERE tid=802 ORDER BY id DESC LIMIT 0,1 ");
	$saso_norm=$sasonorm['norm'];
	
	$template->assign('sasodatum', $sasodatum);	
	$template->assign('saso_tour2', $saso_tour2);	
	$template->assign('saso_norm', $saso_norm);
 
	$template->assign('slist', $slist);	
	$template->assign('content', 'tpl/zsh_p_saso.tpl');
//}
?>