<?php
error_reporting(E_ALL);
ini_set('display_errors',0);
require('lib/fpdf.php');
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 *****                           F.Teichert 2016','1','0','C','1');  
    }  
	function Header() { 
		$this->SetFont('Helvetica','B',20); 
		$this->SetTextColor(70,130,180);
		$fahrer = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$_GET['ma']."'");
		$this->SetFillColor(255,255,255);
		$this->Cell(54,8,"Lohnvorschlag aus EDV",'0','1','L','1');
		$this->Cell(85,8,utf8_decode($fahrer['name']),'0','0','L','0'); $this->Cell(28,8,$_GET['monat']."/".$_GET['jahr'],'0','1','L','1');
		$this->SetFont('Helvetica','BI',20);
		$this->Image('jb_logo2.png', 125, 7); 
		$this->Write(3,"\n");
	}
}  
$pdf = new PDF('P','mm','A4');
$pdf->AddPage();
$pdf->Write(3,"\n"); $summe=0;
$pdf->SetFillColor(180,180,180);  $pdf->SetFont('Helvetica','BI',10); $pdf->SetTextColor(255,255,255);
$pdf->Cell(100,5,"Mitarbeiterdaten",'1','0','L','1');
$pdf->Cell(10,4," ",'0','0','L','0');
$pdf->Cell(80,5,"Festvertrag Fahrdaten",'1','1','L','1'); $pdf->Write(3,"\n");
$fahrer = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$_GET['ma']."'");
$tarifi = $GLOBALS['mysql']->query_single("SELECT * FROM tariftyp WHERE id='".$fahrer['tarifgtyp']."'");


//      echo "<pre>"; print_r($tarifi); echo "</pre>";


$planer = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."'");
//--------------------------------------------------------------------------------------------------------------------------------------------------------- 
$monatstage = date("t",mktime(0, 0, 0,$_GET['monat'], 1,$_GET['jahr'])); $nachttage=0; $pintage=0; $rpintage=0; $aft=0;
for ($i = 1; $i <= $monatstage; $i++) { 
	$ft = $GLOBALS['mysql']->query_single("SELECT * FROM feiertage WHERE tag='".$i."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."'");
	if($ft['num_rows']>0) {
		$aft++;	
	} else {
		if (date("N",mktime(0, 0, 0,$_GET['monat'],$i,$_GET['jahr']))<7) { $nachttage++; } // 6 Tage Mo-Sa.
		if (date("N",mktime(0, 0, 0,$_GET['monat'],$i,$_GET['jahr']))<7 && date("N",mktime(0, 0, 0,$_GET['monat'],$i,$_GET['jahr']))>1 ) { $pintage++; } // 5 Tage Di-Sa.
		if (date("N",mktime(0, 0, 0,$_GET['monat'],$i,$_GET['jahr']))<6) { $rpintage++; } // 5 Tage Mo-Fr.
	}
}

$pdf->SetTextColor(0,0,0); $pdf->SetFont('Helvetica','',9);
//-------- zeile 1 // Festdaten !!!!!!!!!! Anzahl Nachttage
$pdf->Cell(40,4,("Name:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,(utf8_decode($fahrer['name'])),'0','0','L','0');  $pdf->Cell(10,4,(" "),'0','0','L','0'); 
$pdf->Cell(10,4,($nachttage." x"),'0','0','R','0'); $pdf->Cell(50,4,(" Nachttage ".$_GET['monat']."/".$_GET['jahr']),'0','0','L','0'); $pdf->Cell(20,4,("(Mo.-Sa.)"),'0','1','L','0'); 
$pdf->SetFont('Helvetica','',9);
//-------- zeile 2 // Festdaten !!!!!!!!!! Anzahl post
$pdf->Cell(40,4,("Strasse:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,(utf8_decode($fahrer['strasse'])),'0','0','L','0');  $pdf->Cell(10,4,(" "),'0','0','L','0'); 
$pdf->Cell(10,4,($pintage." x"),'0','0','R','0'); $pdf->Cell(50,4,(" Post-Tage ".$_GET['monat']."/".$_GET['jahr']),'0','0','L','0'); $pdf->Cell(20,4,("(Di.-Sa.)"),'0','1','L','0'); 
$pdf->SetFont('Helvetica','',9);
//-------- zeile 3 // Festdaten !!!!!!!!!! Anzahl rtour
$pdf->Cell(40,4,("Wohnort:"),'0','0','L','0');$pdf->SetFont('Courier','B',10);$pdf->Cell(60,4,(utf8_decode($fahrer['plz'])." ".utf8_decode($fahrer['ort'])),'0','0','L','0');$pdf->Cell(10,4,(" "),'0','0','L','0'); 
$pdf->Cell(10,4,($rpintage." x"),'0','0','R','0'); $pdf->Cell(50,4,(" RTourtage ".$_GET['monat']."/".$_GET['jahr']),'0','0','L','0'); $pdf->Cell(20,4,("(Mo.-Fr.)"),'0','1','L','0'); 
$pdf->SetFont('Helvetica','',9);
//-------- zeile 4 feiertage
$pdf->Cell(40,4,("Telefon 1:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['handy']),'0','0','L','0');  $pdf->Cell(10,4,(" "),'0','0','L','0'); 
$pdf->Cell(10,4,($aft." x"),'0','0','R','0'); $pdf->Cell(50,4,(" Feiertage ".$_GET['monat']."/".$_GET['jahr']),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','L','0'); 
$pdf->SetFont('Helvetica','',9);
//-------- zeile 5 - 2. spalte leer !!!!!!!!!!
$pdf->Cell(40,4,("Telefon 2:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['festnetz']),'0','0','L','0');  $pdf->Cell(10,4,(" "),'0','0','L','0'); 
$pdf->Cell(80,4,(" "),'0','1','L','0'); $pdf->SetFont('Helvetica','',9); 
//-------- zeile 6
$pdf->Cell(40,4,("Geb.-tag:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['gebtag'].".".$fahrer['gebmonat'].".".$fahrer['gebjahr']),'0','0','L','0');
$pdf->Cell(10,4,(" "),'0','0','L','0'); 
$pdf->SetFillColor(180,180,180);  $pdf->SetFont('Helvetica','BI',10); $pdf->SetTextColor(255,255,255);
$pdf->Cell(80,5,"Typrechnung soll / ist",'1','1','L','1'); $pdf->SetTextColor(0,0,0); $pdf->SetFont('Helvetica','',9);
//-------- zeile 7
$pdf->Cell(40,4,("Eintritt:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['eintag'].".".$fahrer['einmonat'].".".$fahrer['einjahr']),'0','0','L','0');
$pdf->Cell(10,4,(" "),'0','0','L','0'); $pdf->Cell(80,4,(" "),'0','1','L','0'); $pdf->SetFont('Helvetica','',9); 
//-----------


if($fahrer['typ']==3 || $fahrer['typ']==4) {
	//-------- Nachtfahrer Zeitung
	$zaehler=0;	$solltage=$nachttage;
	$abfrage = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ=3"); 
	$zaehler=$zaehler+$abfrage['num_rows'];
	$abfrage = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ=4"); 
	$zaehler=$zaehler+$abfrage['num_rows'];
}
if($fahrer['typ']==5) {
	//-------- postfahrer Zeitung
	$zaehler=0;	$solltage=$pintage;
	$abfrage = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ=5"); 
	$zaehler=$zaehler+$abfrage['num_rows'];
}
if($fahrer['typ']==6) {
	//-------- rtourfahrer Zeitung
	$zaehler=0;	$solltage=$rpintage;
	$abfrage = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ=6"); 
	$zaehler=$zaehler+$abfrage['num_rows'];
}
//-------- zeile 8
$pdf->Cell(40,4,("Steuer Nr.:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['steuerid']),'0','0','L','0');  $pdf->Cell(10,4,(" "),'0','0','L','0'); 
$pdf->Cell(10,4,($zaehler." x"),'0','0','R','0'); $pdf->Cell(50,4,(" gefahren - soll Touren: "),'0','0','L','0'); $pdf->Cell(20,4,($solltage." x"),'0','1','R','0'); 
$pdf->SetFont('Helvetica','',9); 
//-------- zeile 9
$pdf->Cell(40,4,("S.V.Nr.:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['svnummer']),'0','0','L','0');  $pdf->Cell(10,4,(" "),'0','0','L','0'); 
$pdf->Cell(10,4,(" "),'0','0','L','0'); $pdf->Cell(80,4,(" "),'0','1','L','0'); $pdf->SetFont('Helvetica','',9); 
//-------- zeile 10
$pdf->Cell(40,4,("Krankenkasse:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['kkasse']),'0','0','L','0');  $pdf->Cell(10,4,(" "),'0','0','L','0'); 
$pdf->SetFillColor(180,180,180);  $pdf->SetFont('Helvetica','BI',10); $pdf->SetTextColor(255,255,255);
$pdf->Cell(80,5,"Eintrag im Kalender",'1','1','L','1'); $pdf->SetTextColor(0,0,0); $pdf->SetFont('Helvetica','',9);
//-------- zeile 11
$pdf->Cell(40,4,("KK V.Nr.:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['kkassennr']),'0','0','L','0');  $pdf->Cell(10,4,(" "),'0','0','L','0'); 
$pdf->Cell(10,4,(" "),'0','0','L','0'); $pdf->Cell(80,4,(" "),'0','1','L','0'); $pdf->SetFont('Helvetica','',9); 

//-------------------------------------
//-------------- kalender ausrechnen
//-------------------------------------
$zz=0; $mark=1;
//------------- neu Kalendereinträge zusammengefasst


//--------------- zusammenfassung
$temp1 = $GLOBALS['mysql']->query("SELECT * FROM planer_bez WHERE id<80"); 
while($row = $temp1->fetch_assoc()) { 
	$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund='".$row['id']."'");	
	if($kd['num_rows']>0) {	
		$zz++;	
		$tmp[$zz]['a']=$kd['num_rows']." x";
		$tmp[$zz]['b']=" ";
		$tmp[$zz]['c']=$row['bez']." x";	
		$tmp[$zz]['m']=1;	
	}
}
//---------------------------- leerzeile
$zz++;	$tmp[$zz]['a']=" "; $tmp[$zz]['b']=" "; $tmp[$zz]['c']=" "; 
//---------------------------------------- Einzelanzeige
$kdata = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 ORDER BY tag"); $key=0;
while($row = $kdata->fetch_assoc()) { 
	$zz++;	
	$tmp[$zz]['a']=$row['tag'].".".$row['monat'];
	$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$row['grund']."'"); 
	$tmp[$zz]['b']=$kg['bez'];
	$tmp[$zz]['c']=$row['info'];	
}
//------------------------------------------------------------------------------------------------------ kalenderrechnung ende
$za=0;
//-------- zeile 12
$pdf->Cell(40,4,("Steuerklasse:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['steuerkl']),'0','0','L','0');  $pdf->Cell(10,4,(" "),'0','0','L','0'); 
$za++; 
if (isset($tmp[$za]['a'])) {
	if ($tmp[$za]['m']>0) { 
		$pdf->SetFillColor(255,211,155);
		$pdf->Cell(10,4,(utf8_decode($tmp[$za]['a'])),'0','0','R','1'); $pdf->Cell(50,4,(utf8_decode($tmp[$za]['b'])),'0','0','L','1'); $pdf->Cell(20,4,(utf8_decode($tmp[$za]['c'])),'0','1','R','1'); $pdf->SetFont('Helvetica','',9);			$pdf->SetFillColor(180,180,180);	   
	} else {
		$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,(utf8_decode($tmp[$za]['b'])),'0','0','L','0'); $pdf->Cell(20,4,(utf8_decode($tmp[$za]['c'])),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
	}	
}else{
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}
//-------- zeile 13
$pdf->Cell(40,4,("Freibetrag:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['kinderfb']),'0','0','L','0');  $pdf->Cell(10,4,(" "),'0','0','L','0'); 
$za++; 
if (isset($tmp[$za]['a'])) {
	if ($tmp[$za]['m']>0) { 
		$pdf->SetFillColor(255,211,155);
		$pdf->Cell(10,4,(utf8_decode($tmp[$za]['a'])),'0','0','R','1'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','1'); $pdf->Cell(20,4,(utf8_decode($tmp[$za]['c'])),'0','1','R','1'); $pdf->SetFont('Helvetica','',9);			$pdf->SetFillColor(180,180,180);	   
	} else {
		$pdf->Cell(10,4,(utf8_decode($tmp[$za]['a'])),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,(utf8_decode($tmp[$za]['c'])),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
	}	
}else{
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}
//-------- zeile 14
$pdf->Cell(40,4,("Bank-Iban:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['iban']),'0','0','L','0');  $pdf->Cell(10,4,(" "),'0','0','L','0'); 
$za++; 
if (isset($tmp[$za]['a'])) {
	if ($tmp[$za]['m']>0) { 
		$pdf->SetFillColor(255,211,155);
		$pdf->Cell(10,4,(utf8_decode($tmp[$za]['a'])),'0','0','R','1'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','1'); $pdf->Cell(20,4,(utf8_decode($tmp[$za]['c'])),'0','1','R','1'); $pdf->SetFont('Helvetica','',9);			$pdf->SetFillColor(180,180,180);	   
	} else {
		$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,(utf8_decode($tmp[$za]['c'])),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
	}	
}else{
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}
//-------- zeile 15
$pdf->Cell(40,4,("Bank-BIC:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['BIC']),'0','0','L','0');  $pdf->Cell(10,4,(" "),'0','0','L','0'); 
$za++; 
if (isset($tmp[$za]['a'])) {
	if ($tmp[$za]['m']>0) { 
		$pdf->SetFillColor(255,211,155);
		$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','1'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','1'); $pdf->Cell(20,4,(utf8_decode($tmp[$za]['c'])),'0','1','R','1'); $pdf->SetFont('Helvetica','',9);			$pdf->SetFillColor(180,180,180);	   
	} else {
		$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,(utf8_decode($tmp[$za]['c'])),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
	}	
}else{
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}
//-------- zeile 16
$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,(" "),'0','0','L','0');  $pdf->Cell(10,4,(" "),'0','0','L','0'); 
$za++; 
if (isset($tmp[$za]['a'])) {
	if ($tmp[$za]['m']>0) { 
		$pdf->SetFillColor(255,211,155);
		$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','1'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','1'); $pdf->Cell(20,4,(utf8_decode($tmp[$za]['c'])),'0','1','R','1'); $pdf->SetFont('Helvetica','',9);			$pdf->SetFillColor(180,180,180);	   
	} else {
		$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,(utf8_decode($tmp[$za]['c'])),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
	}	
}else{
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}
//-------- zeile 17
$pdf->SetFillColor(180,180,180); $pdf->SetFont('Helvetica','BI',10); $pdf->SetTextColor(255,255,255); 
$pdf->Cell(100,5,"Lohnzusammenfassung",'1','0','L','1');  $pdf->Cell(10,4,(" "),'0','0','L','0'); 
$pdf->SetFillColor(180,180,180); $pdf->SetFont('Courier','B',10); $pdf->SetTextColor(0,0,0); 
$za++; 
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,(utf8_decode($tmp[$za]['c'])),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else{
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}
//-------- zeile 18
$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,(" "),'0','0','L','0');  $pdf->Cell(10,4,(" "),'0','0','L','0');
$za++; 
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else{
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}
//-----------------------
//--------------- Lohn
//-----------------------

//-------- zeile 19 ** Grundlohn
if ($fahrer['einmonat']==$_GET['monat'] && $fahrer['einjahr']==$_GET['jahr']) {
	$gtage=27-$fahrer['eintag']; $glohn=($fahrer['tarifg']/26); $glohn=$glohn*$gtage; $glohn=round($glohn,0);  
$pdf->Cell(40,4,("Grundlohn:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($gtage." Tage"),'0','0','L','0'); $pdf->Cell(30,5,($glohn.".00 EUR"),'0','0','R','0');  $pdf->Cell(10,4,(" "),'0','0','L','0');
} else { $glohn=$fahrer['tarifg'];
	$pdf->Cell(40,4,("Grundlohn:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($glohn.",00 EUR"),'0','0','R','0');  $pdf->Cell(10,4,(" "),'0','0','L','0'); 
}
$za++; 
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else{
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}
//------------- Zählerausrechnung
$zz=0;
if($fahrer['tarifgtyp']!=88) {
	$temp2 = $GLOBALS['mysql']->query("SELECT * FROM tourentyp"); 
	while($row = $temp2->fetch_assoc()) { 
		$tl=$GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE fahrer='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND typ='".$row['tid']."' AND utyp!=9 AND tour<8001 || fahrer='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND typ='".$row['tid']."' AND utyp!=9 AND tour>8999");	
		
		if($tl['num_rows']>0) {	$tmpl=0;
			$ldaten = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE fahrer='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND typ='".$row['tid']."' AND utyp!=9 AND tour<8001 || fahrer='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND typ='".$row['tid']."' AND utyp!=9 AND tour>8999 ORDER BY tag"); 
			while($rowl = $ldaten->fetch_assoc()) { $tmpl=$tmpl+$rowl['tarif']; } $glohn=$glohn+$tmpl; $zz++; 
			$tml[$zz]['a']=$row['tname'];
			$tml[$zz]['b']=$tl['num_rows']." Touren";
			$tml[$zz]['c']=number_format($tmpl, 2, '.', '')." EUR";	
		}
		
		
		$tl=$GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE fahrer='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND typ='".$row['tid']."' AND utyp=9 || fahrer='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND typ='".$row['tid']."' AND tour>8001 AND tour<8999");
		if($tl['num_rows']>0) {	$tmpl=0;
			$ldaten = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE fahrer='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND typ='".$row['tid']."' AND utyp=9  || fahrer='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND typ='".$row['tid']."' AND tour>8001 AND tour<8999 ORDER BY tag"); 
			while($rowl = $ldaten->fetch_assoc()) { $tmpl=$tmpl+$rowl['tarif']; } $glohn=$glohn+$tmpl; $zz++;	
			$tml[$zz]['a']=$row['tname']." -Abn.";
			$tml[$zz]['b']=$tl['num_rows']." Touren";
			$tml[$zz]['c']=number_format($tmpl, 2, ',', '')." EUR";
		}
	}
}
$zb=1;

//-------- zeile 20
if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}//-------- zeile 21
if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}//-------- zeile 22
if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}
//-------- zeile 23
if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}

if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}
//-------- zeile 25
if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}
//-------- zeile 26
if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}

if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}//-------- zeile 42 ** 
if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}//-------- zeile 43 ** 
if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}//-------- zeile 44 ** 
if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}//-------- zeile 45 ** 
if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}//-------- zeile 46 ** 
if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}//-------- zeile 47 ** 
if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}//-------- zeile 48 ** 
if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}//-------- zeile 49 ** 
if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}//-------- zeile 50 ** 
if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}/*
//-------- zeile 51 ** 
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; ; 
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
//-------- zeile 52 ** 
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;  
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
//-------- zeile 53 ** 
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);

*/


//lohnabzug
$ma_minus = $GLOBALS['mysql']->query_single("SELECT * FROM ma_abzahlung WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."'");
if($ma_minus['num_rows']==0) {
//-------- zeile 51 ** 
if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}//-------- zeile 52 ** 
if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}//-------- zeile 53 ** 
if (isset($tml[$zb]['a'])) {
	$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
	$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}else {
	$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
	$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
}
if (isset($tmp[$za]['a'])) {
	$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}else {
	$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}}
if($ma_minus['num_rows']==1) {
//-------- zeile 51 ** 
	if (isset($tml[$zb]['a'])) {
		$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
		$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
	}else {
		$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
		$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
	}
	if (isset($tmp[$za]['a'])) {
		$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
	}else {
		$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
	}//-------- zeile 52 ** 
	if (isset($tml[$zb]['a'])) {
		$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
		$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
	}else {
		$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
		$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
	}
	if (isset($tmp[$za]['a'])) {
		$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
	}else {
		$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
	}
}
	if($ma_minus['num_rows']==2) {
//-------- zeile 51 ** 
	if (isset($tml[$zb]['a'])) {
		$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');  
		$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
	}else {
		$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,(" "),'0','0','L','0');  
		$pdf->Cell(30,5,(" "),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; 
	}
	if (isset($tmp[$za]['a'])) {
		$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
	}else {
		$pdf->Cell(10,4,(" "),'0','0','R','0'); $pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
	}
}


//-------- zeile summe ** Gesamtsumme
$pdf->SetFillColor(180,180,180); $pdf->SetFont('Helvetica','BI',10); $pdf->SetTextColor(255,255,255); 
$pdf->Cell(100,5,"Lohnvorschlag",'1','1','L','1');  
$pdf->SetFillColor(180,180,180); $pdf->SetFont('Courier','B',10); $pdf->SetTextColor(0,0,0); 

//		$pdf->Cell(100,5," ",'0','1','L','0'); 

$glohn=number_format($glohn, 2, ',', ''); // 2 nachkommastellen

//if($stundenanzeige>0) {
//	$pdf->Cell(10,4,("Stunden-Summe: "),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); 
//	$pdf->Cell(70,5,("Stunden-Summe: "),'0','0','R','0'); $pdf->Cell(30,5,($glohn." EUR"),'0','0','R','0'); 
//}
//zwischensumme
$pdf->Cell(70,5,("Zwischenumme: "),'0','0','R','0'); $pdf->Cell(30,5,($glohn." EUR"),'0','1','R','0'); 

if($ma_minus['num_rows']>0) {
	$temp8 = $GLOBALS['mysql']->query("SELECT * FROM ma_abzahlung WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."'");
	while($row = $temp8->fetch_assoc()) { 
		$minuslohn=number_format($row['summe'], 2, ',', ''); // 2 nachkommastellen
		$pdf->Cell(70,5,("(Abzug) ".$row['grund'].": "),'0','0','R','0'); $pdf->Cell(30,5,("-".$minuslohn." EUR"),'0','1','R','0'); $glohn=$glohn-$minuslohn;
	}
	$glohn=number_format($glohn, 2, ',', ''); // 2 nachkommastellen
}
//	$glohn=number_format($glohn, 2, ',', ''); // 2 nachkommastellen 
if($tarifi['netto']>0) { 
	$pdf->Cell(70,5,("NETTO-Summe: "),'0','0','R','0'); $pdf->Cell(30,5,($glohn." EUR"),'0','0','R','0'); 
} else {
	$pdf->SetFillColor(255,211,155);
	$pdf->Cell(70,5,("Brutto-Summe: "),'0','0','R','1'); $pdf->Cell(30,5,($glohn." EUR"),'0','0','R','0');
	$pdf->SetFillColor(180,180,180);
}

$pdf->Cell(10,4,(" "),'0','0','R','0'); $za++; 
$pdf->Cell(10,4,(" "),'0','0','R','0'); 
$pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
//--------------------------------------------- ausgabe
$fahrer = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$_GET['ma']."'");
$pdf->Output('Lohnvorschlag_'.($fahrer['name']).'.pdf','I');
 
?>