<?php
require('fpdf.php');
error_reporting(1);
$monat = (int)date('n');
$jahr = (int)date('Y');
$kw_aktuell = (int)date('W');	

if(isset($_POST['save'])) {
	if($_POST['ma5']=="0147025803") { //passwort
		
		$maid=$_POST['ma1'];
		$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM firmen WHERE id='".$_POST['ma1']."'"); 
		$a_name=$row_fahrerx['name'];
		$a_monat=$_POST['ma2'];
		$a_jahr=$_POST['ma3'];
	
	//--------------------------------
	//-------------------- pdf starten 
	//--------------------------------
		
		class PDF extends FPDF {  
			function Footer() {  
				$this->SetY(-15);  
				$this->SetFont('Helvetica','I',6);  
				$this->Cell(190,3,'JB-Transport.de - Bautzner Str. 67 - 04347 Leipzig                                        ***** Interne Liste - NON Public *****                                        by. F. Teichert ©2012','1','0','C','1');  
			}  
		}  
		$pdf = new PDF('P','mm','A4');
		$pdf->AddPage();
		//	blau (0,160,230)
		//	Orange (240,150, 0)
		//  grau (200,200,200)
		$pdf->Image('Image5.png', 0, 5,230,30); 	
		$pdf->Write(20,"\n\n");
	
		$pdf->SetFont('Helvetica','BU',7); $pdf->SetTextColor(0,0,0); $pdf->SetFillColor(255,255,255);
		$pdf->Cell(110,3,"JB-Transport  -  Bautzner Str. 76  -  04347 Leipzig",'0','1','L','1');
		$pdf->SetFont('');
		$pdf->Cell(110,3," ",'0','1','L','1');	
	
		$adr = $GLOBALS['mysql']->query_single("SELECT * FROM firmen WHERE id='".$_POST['ma1']."'");
	
		$pdf->SetFont('Helvetica','B',10); $pdf->SetTextColor(0,0,0); $pdf->SetFillColor(255,255,255);
		$pdf->Cell(110,5,($adr['a1']),'0','1','L','0');	
		$pdf->Cell(110,5,($adr['a2']),'0','1','L','0');		
		$pdf->Cell(110,5,($adr['a3']),'0','1','L','0');	
		$pdf->Cell(110,5,($adr['a4']),'0','1','L','1');			
	
		$pdf->Write(8,"\n");	
		$pdf->SetFont('Helvetica','BI',20);
		$pdf->Cell(110,8,"Monatsansicht ".($a_monat)."/".($a_jahr),'0','1','L','1');
		$pdf->SetFont('');
		$pdf->Write(4,"\n");
		
		$pdf->SetFont('Helvetica','B',10);
		$pdf->Cell(25,5,"Tour",'B','0','L','1');
		$pdf->Cell(90,5,"Bezeichnung",'B','0','L','1');
		$pdf->Cell(20,5,"Anzahl",'B','0','R','1');
		$pdf->Cell(30,5,"E.-Preis",'B','0','R','1');
		$pdf->Cell(30,5,"G.-Preis",'B','1','R','1');	
				
		$pdf->Write(2,"\n");			
	
	//--------------- neu 1. touren auslesen zu arbeitgeber , danach mit option die tourenliste
		$keyfirma=0; $keytour=0; $firmapreis=0;  $tourmenge=0;
		$firmatouren = $GLOBALS['mysql']->query("SELECT * FROM touren WHERE afirma='".$_POST['ma1']."' ORDER BY typ");
		while($rowfirma = $firmatouren->fetch_assoc()) {
			$tour1[$keytour]['id']=$rowfirma['id'];
			$tour1[$keytour]['tour']=$rowfirma['tour'];
			$tour1[$keytour]['retyp']=$rowfirma['retyp'];		
			$tour1[$keytour]['infotitel']=$rowfirma['infotitel'];
			$tour1[$keytour]['preis']=$rowfirma['preis'];
			
			$keytour++;
		}
		for($key = 0; $key < $keytour; $key++) {
			$tourx = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$_POST['ma2']."' AND jahr='".$_POST['ma3']."' AND tour='".$tour1[$key]['id']."' ") ;
			while($row2 = $tourx->fetch_assoc()) {
				if($tour1[$key]['retyp']==5) { 
					$tourmenge=$tourmenge+$row2['exemplare']; 
					$tmppreis=$tour1[$key]['preis']*$row2['exemplare'];
					$tourpreis=$tourpreis+$tmppreis;
					$firmapreis=$firmapreis+$tmppreis;
				} 
				elseif($tour1[$key]['retyp']==4) { 
					$tourmenge++; 
					if ($tourmenge==1) {
						$tourpreis=$tourpreis+$tour1[$key]['preis']; 
						$firmapreis=$firmapreis+$tour1[$key]['preis'];
					}
				} else { 
					$tourmenge++; 
					$tourpreis=$tourpreis+$tour1[$key]['preis']; 
					$firmapreis=$firmapreis+$tour1[$key]['preis'];
				}				
			}
	
			if($tourmenge>0) {	
				$pdf->SetFont('Courier','B',10); $pdf->SetFont('');
				$pdf->Cell(25,4,($tour1[$key]['tour']),'0','0','L','1');
				$pdf->Cell(90,4,($tour1[$key]['infotitel']),'0','0','L','1');
				
				if($tour1[$key]['retyp']==4) {
					$pdf->Cell(20,4," ",'0','0','R','1');
					$pdf->Cell(30,4," ",'0','0','R','1');
				} else {
					$pdf->Cell(20,4,($tourmenge)." x",'0','0','R','1');
					$pdf->Cell(30,4,"a. ".(sprintf("%01.2f",$tour1[$key]['preis']))." Euro",'0','0','R','1');
				}
				$pdf->Cell(30,4,(sprintf("%01.2f",$tourpreis))." Euro",'0','1','R','1');															
			}
			$tourpreis=0; $tourmenge=0;
		}
	//gesamtsumme
	//	$pdf->Cell(25,8," ",'0','1','R','1');															
		$pdf->Cell(195,4," ",'0','1','R','1');	
		$pdf->Cell(195,4,"------------",'0','1','R','1');															
		$pdf->Cell(108,4," ",'0','0','L','1');															
		$pdf->Cell(50,4,"Zwischensumme:",'0','0','R','1');															
		$pdf->Cell(37,4,(sprintf("%01.2f",$firmapreis))." Euro",'0','1','R','1');																
		$steuer=$firmapreis*19/100;
		$pdf->Cell(108,4," ",'0','0','L','1');															
		$pdf->Cell(50,4,"+19% MwSt.",'0','0','R','1');																	
		$pdf->Cell(37,4,(sprintf("%01.2f",$steuer))." Euro",'0','1','R','1');																
		$betrag=$firmapreis+$steuer; 
		$pdf->Cell(108,4," ",'0','0','L','1');															
		$pdf->Cell(50,4,"Gesamtbetrag:",'0','0','R','1');															
		$pdf->Cell(37,4,(sprintf("%01.2f",$betrag))." Euro",'0','1','R','1');																
		if($betrag>9999) { 
			$pdf->Cell(195,4,"===========",'0','1','R','1');																	
		} else {
			$pdf->Cell(195,4,"============",'0','1','R','1');																	
		}
		//---------

		$pdf->Output('rechnung_'.($datum).'.pdf','I');
		exit();
	} else {
		$template->assign('error', "falsches Passwort");	
		$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('content', 'tpl/a_firma1.tpl');		//_list	
	
	
	}

} else {
	$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('content', 'tpl/a_firma1.tpl');		//_list	
}
?>