<?php
//	error_reporting(E_ALL);
//	ini_set('display_errors', 1); 
require('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(90,8,$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('Image3.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,5," ",'0','0','L','0');
$pdf->Cell(80,5,"Eintrag im Kalender",'1','1','L','1'); $pdf->Write(3,"\n");
$fahrer = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$_GET['ma']."'");
$planer = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."'");
/*
if($planer['num_rows']>0) { $kalender=$planer['num_rows']; $key=0;
	$planer = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."'");
	while($row = $planer->fetch_assoc()) {
		$kal[$key]['datum']=$row['tag'].".".$row['monat'].".".$row['jahr'];
		$grund = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$row['grund']."'");
		$kal[$key]['grund']=$grund['bez'];		
		$kal[$key]['pinfo']=$row['info'];
		$key++;
	}
}
$key=0;
*/
$pdf->SetTextColor(0,0,0); $pdf->SetFont('Helvetica','',10);
//-------- zeile 1
$pdf->Cell(40,5,("Name:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,5,($fahrer['name']),'0','0','L','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 0, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 2
$pdf->Cell(40,5,("Strasse:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,5,($fahrer['strasse']),'0','0','L','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 1, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 3
$pdf->Cell(40,5,("Wohnort:"),'0','0','L','0');$pdf->SetFont('Courier','B',10);$pdf->Cell(60,5,($fahrer['plz']." ".$fahrer['ort']),'0','0','L','0');$pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 2, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 4
$pdf->Cell(40,5,("Telefon 1:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,5,($fahrer['handy']),'0','0','L','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 3, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 5
$pdf->Cell(40,5,("Telefon 2:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,5,($fahrer['tel']),'0','0','L','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 4, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 6
$pdf->Cell(40,5,("Geb.-tag:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,5,($fahrer['gebtag'].".".$fahrer['gebmonat'].".".$fahrer['gebjahr']),'0','0','L','0');
$pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 5, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 7
$pdf->Cell(40,5,("Eintritt:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,5,($fahrer['eintag'].".".$fahrer['einmonat'].".".$fahrer['einjahr']),'0','0','L','0');
$pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 6, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 8
$pdf->Cell(40,5,("Steuer Nr.:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,5,($fahrer['steuernr']),'0','0','L','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 7, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 9
$pdf->Cell(40,5,("S.V.Nr.:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,5,($fahrer['svnr']),'0','0','L','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 8, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 10
$pdf->Cell(40,5,("Krankenkasse:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,5,($fahrer['kk']),'0','0','L','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 9, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 11
$pdf->Cell(40,5,("KK V.Nr.:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,5,($fahrer['kkvnr']),'0','0','L','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 10, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 12
$pdf->Cell(40,5,("Steuerklasse:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,5,($fahrer['stkl']),'0','0','L','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 11, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 13
$pdf->Cell(40,5,("Freibetrag:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,5,($fahrer['stfb']),'0','0','L','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 12, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 14
$pdf->Cell(40,5,("Bank-Iban:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,5,($fahrer['iban']),'0','0','L','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 13, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 15
$pdf->Cell(40,5,("Bank-BIC:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,5,($fahrer['bic']),'0','0','L','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 14, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 16
$pdf->Cell(40,5,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,5,(" "),'0','0','L','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 15, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- 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,5,(" "),'0','0','L','0'); 
$pdf->SetFillColor(180,180,180); $pdf->SetFont('Courier','B',10); $pdf->SetTextColor(0,0,0); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 16, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 18
$pdf->Cell(40,5,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,5,(" "),'0','0','L','0');  $pdf->Cell(10,5,(" "),'0','0','L','0');
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 17, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//--------------- 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,5,("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,5,(" "),'0','0','L','0');
} else { $glohn=$fahrer['tarifg'];
	$pdf->Cell(40,5,("Grundlohn:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,5,($glohn.",00 EUR"),'0','0','R','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
}
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 18, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 


//-------- zeile 20
$row_tt = $GLOBALS['mysql']->query_single("SELECT * FROM tourentyp WHERE tid=1"); $tmpl=0; $tname=$row_tt['tname'];
$zaehler = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); 
if($zaehler['num_rows']>0) { $ldaten = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' and jahr='".$_GET['jahr']."' and fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); while($row = $ldaten->fetch_assoc()) { $tmpl=$tmpl+$row['tarif']; }} $glohn=$glohn+$tmpl; 
$pdf->Cell(40,5,($tname),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($zaehler['num_rows']." Touren"),'0','0','L','0');  $pdf->Cell(30,5,($tmpl.",00 EUR"),'0','0','R','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 19, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 21
$row_tt = $GLOBALS['mysql']->query_single("SELECT * FROM tourentyp WHERE tid=2"); $tmpl=0; $tname=$row_tt['tname'];
$zaehler = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); 
if($zaehler['num_rows']>0) { $ldaten = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' and jahr='".$_GET['jahr']."' and fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); while($row = $ldaten->fetch_assoc()) { $tmpl=$tmpl+$row['tarif']; }} $glohn=$glohn+$tmpl; 
$pdf->Cell(40,5,($tname),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($zaehler['num_rows']." Touren"),'0','0','L','0');  $pdf->Cell(30,5,($tmpl.",00 EUR"),'0','0','R','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 20, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 22
$row_tt = $GLOBALS['mysql']->query_single("SELECT * FROM tourentyp WHERE tid=3"); $tmpl=0; $tname=$row_tt['tname'];
$zaehler = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); 
if($zaehler['num_rows']>0) { $ldaten = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' and jahr='".$_GET['jahr']."' and fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); while($row = $ldaten->fetch_assoc()) { $tmpl=$tmpl+$row['tarif']; }} $glohn=$glohn+$tmpl; 
$pdf->Cell(40,5,($tname),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($zaehler['num_rows']." Touren"),'0','0','L','0');  $pdf->Cell(30,5,($tmpl.",00 EUR"),'0','0','R','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 21, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 23
$row_tt = $GLOBALS['mysql']->query_single("SELECT * FROM tourentyp WHERE tid=4"); $tmpl=0; $tname=$row_tt['tname'];
$zaehler = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); 
if($zaehler['num_rows']>0) { $ldaten = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' and jahr='".$_GET['jahr']."' and fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); while($row = $ldaten->fetch_assoc()) { $tmpl=$tmpl+$row['tarif']; }} $glohn=$glohn+$tmpl; 
$pdf->Cell(40,5,($tname),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($zaehler['num_rows']." Touren"),'0','0','L','0');  $pdf->Cell(30,5,($tmpl.",00 EUR"),'0','0','R','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 22, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 24
$row_tt = $GLOBALS['mysql']->query_single("SELECT * FROM tourentyp WHERE tid=5"); $tmpl=0; $tname=$row_tt['tname'];
$zaehler = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); 
if($zaehler['num_rows']>0) { $ldaten = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' and jahr='".$_GET['jahr']."' and fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); while($row = $ldaten->fetch_assoc()) { $tmpl=$tmpl+$row['tarif']; }} $glohn=$glohn+$tmpl; 
$pdf->Cell(40,5,($tname),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($zaehler['num_rows']." Touren"),'0','0','L','0');  $pdf->Cell(30,5,($tmpl.",00 EUR"),'0','0','R','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 23, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 25
$row_tt = $GLOBALS['mysql']->query_single("SELECT * FROM tourentyp WHERE tid=6"); $tmpl=0; $tname=$row_tt['tname'];
$zaehler = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); 
if($zaehler['num_rows']>0) { $ldaten = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' and jahr='".$_GET['jahr']."' and fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); while($row = $ldaten->fetch_assoc()) { $tmpl=$tmpl+$row['tarif']; }} $glohn=$glohn+$tmpl; 
$pdf->Cell(40,5,($tname),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($zaehler['num_rows']." Touren"),'0','0','L','0');  $pdf->Cell(30,5,($tmpl.",00 EUR"),'0','0','R','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 24, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 26
$row_tt = $GLOBALS['mysql']->query_single("SELECT * FROM tourentyp WHERE tid=7"); $tmpl=0; $tname=$row_tt['tname'];
$zaehler = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); 
if($zaehler['num_rows']>0) { $ldaten = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' and jahr='".$_GET['jahr']."' and fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); while($row = $ldaten->fetch_assoc()) { $tmpl=$tmpl+$row['tarif']; }} $glohn=$glohn+$tmpl; 
$pdf->Cell(40,5,($tname),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($zaehler['num_rows']." Touren"),'0','0','L','0');  $pdf->Cell(30,5,($tmpl.",00 EUR"),'0','0','R','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 25, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 27
$row_tt = $GLOBALS['mysql']->query_single("SELECT * FROM tourentyp WHERE tid=8"); $tmpl=0; $tname=$row_tt['tname'];
$zaehler = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); 
if($zaehler['num_rows']>0) { $ldaten = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' and jahr='".$_GET['jahr']."' and fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); while($row = $ldaten->fetch_assoc()) { $tmpl=$tmpl+$row['tarif']; }} $glohn=$glohn+$tmpl; 
$pdf->Cell(40,5,($tname),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($zaehler['num_rows']." Touren"),'0','0','L','0');  $pdf->Cell(30,5,($tmpl.",00 EUR"),'0','0','R','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 26, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 28
$row_tt = $GLOBALS['mysql']->query_single("SELECT * FROM tourentyp WHERE tid=9"); $tmpl=0; $tname=$row_tt['tname'];
$zaehler = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); 
if($zaehler['num_rows']>0) { $ldaten = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' and jahr='".$_GET['jahr']."' and fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); while($row = $ldaten->fetch_assoc()) { $tmpl=$tmpl+$row['tarif']; }} $glohn=$glohn+$tmpl; 
$pdf->Cell(40,5,($tname),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($zaehler['num_rows']." Touren"),'0','0','L','0');  $pdf->Cell(30,5,($tmpl.",00 EUR"),'0','0','R','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 27, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 29
$row_tt = $GLOBALS['mysql']->query_single("SELECT * FROM tourentyp WHERE tid=10"); $tmpl=0; $tname=$row_tt['tname'];
$zaehler = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); 
if($zaehler['num_rows']>0) { $ldaten = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' and jahr='".$_GET['jahr']."' and fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); while($row = $ldaten->fetch_assoc()) { $tmpl=$tmpl+$row['tarif']; }} $glohn=$glohn+$tmpl; 
$pdf->Cell(40,5,($tname),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($zaehler['num_rows']." Touren"),'0','0','L','0');  $pdf->Cell(30,5,($tmpl.",00 EUR"),'0','0','R','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 28, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 30
$row_tt = $GLOBALS['mysql']->query_single("SELECT * FROM tourentyp WHERE tid=11"); $tmpl=0; $tname=$row_tt['tname'];
$zaehler = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); 
if($zaehler['num_rows']>0) { $ldaten = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' and jahr='".$_GET['jahr']."' and fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); while($row = $ldaten->fetch_assoc()) { $tmpl=$tmpl+$row['tarif']; }} $glohn=$glohn+$tmpl; 
$pdf->Cell(40,5,($tname),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($zaehler['num_rows']." Touren"),'0','0','L','0');  $pdf->Cell(30,5,($tmpl.",00 EUR"),'0','0','R','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 29, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 31
$row_tt = $GLOBALS['mysql']->query_single("SELECT * FROM tourentyp WHERE tid=12"); $tmpl=0; $tname=$row_tt['tname'];
$zaehler = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); 
if($zaehler['num_rows']>0) { $ldaten = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' and jahr='".$_GET['jahr']."' and fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); while($row = $ldaten->fetch_assoc()) { $tmpl=$tmpl+$row['tarif']; }} $glohn=$glohn+$tmpl; 
$pdf->Cell(40,5,($tname),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($zaehler['num_rows']." Touren"),'0','0','L','0');  $pdf->Cell(30,5,($tmpl.",00 EUR"),'0','0','R','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 30, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 32
$row_tt = $GLOBALS['mysql']->query_single("SELECT * FROM tourentyp WHERE tid=13"); $tmpl=0; $tname=$row_tt['tname'];
$zaehler = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); 
if($zaehler['num_rows']>0) { $ldaten = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' and jahr='".$_GET['jahr']."' and fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); while($row = $ldaten->fetch_assoc()) { $tmpl=$tmpl+$row['tarif']; }} $glohn=$glohn+$tmpl; 
$pdf->Cell(40,5,($tname),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($zaehler['num_rows']." Touren"),'0','0','L','0');  $pdf->Cell(30,5,($tmpl.",00 EUR"),'0','0','R','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 31, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 33
$row_tt = $GLOBALS['mysql']->query_single("SELECT * FROM tourentyp WHERE tid=14"); $tmpl=0; $tname=$row_tt['tname'];
$zaehler = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); 
if($zaehler['num_rows']>0) { $ldaten = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' and jahr='".$_GET['jahr']."' and fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); while($row = $ldaten->fetch_assoc()) { $tmpl=$tmpl+$row['tarif']; }} $glohn=$glohn+$tmpl; 
$pdf->Cell(40,5,($tname),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($zaehler['num_rows']." Touren"),'0','0','L','0');  $pdf->Cell(30,5,($tmpl.",00 EUR"),'0','0','R','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 32, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 34
$row_tt = $GLOBALS['mysql']->query_single("SELECT * FROM tourentyp WHERE tid=15"); $tmpl=0; $tname=$row_tt['tname'];
$zaehler = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); 
if($zaehler['num_rows']>0) { $ldaten = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' and jahr='".$_GET['jahr']."' and fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); while($row = $ldaten->fetch_assoc()) { $tmpl=$tmpl+$row['tarif']; }} $glohn=$glohn+$tmpl; 
$pdf->Cell(40,5,($tname),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($zaehler['num_rows']." Touren"),'0','0','L','0');  $pdf->Cell(30,5,($tmpl.",00 EUR"),'0','0','R','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 33, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 35
$row_tt = $GLOBALS['mysql']->query_single("SELECT * FROM tourentyp WHERE tid=16"); $tmpl=0; $tname=$row_tt['tname'];
$zaehler = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); 
if($zaehler['num_rows']>0) { $ldaten = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' and jahr='".$_GET['jahr']."' and fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); while($row = $ldaten->fetch_assoc()) { $tmpl=$tmpl+$row['tarif']; }} $glohn=$glohn+$tmpl; 
$pdf->Cell(40,5,($tname),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($zaehler['num_rows']." Touren"),'0','0','L','0');  $pdf->Cell(30,5,($tmpl.",00 EUR"),'0','0','R','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 34, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 36
$row_tt = $GLOBALS['mysql']->query_single("SELECT * FROM tourentyp WHERE tid=17"); $tmpl=0; $tname=$row_tt['tname'];
$zaehler = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); 
if($zaehler['num_rows']>0) { $ldaten = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' and jahr='".$_GET['jahr']."' and fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); while($row = $ldaten->fetch_assoc()) { $tmpl=$tmpl+$row['tarif']; }} $glohn=$glohn+$tmpl; 
$pdf->Cell(40,5,($tname),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($zaehler['num_rows']." Touren"),'0','0','L','0');  $pdf->Cell(30,5,($tmpl.",00 EUR"),'0','0','R','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 35, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 37
$row_tt = $GLOBALS['mysql']->query_single("SELECT * FROM tourentyp WHERE tid=18"); $tmpl=0; $tname=$row_tt['tname'];
$zaehler = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); 
if($zaehler['num_rows']>0) { $ldaten = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' and jahr='".$_GET['jahr']."' and fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); while($row = $ldaten->fetch_assoc()) { $tmpl=$tmpl+$row['tarif']; }} $glohn=$glohn+$tmpl; 
$pdf->Cell(40,5,($tname),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($zaehler['num_rows']." Touren"),'0','0','L','0');  $pdf->Cell(30,5,($tmpl.",00 EUR"),'0','0','R','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 36, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 38
$row_tt = $GLOBALS['mysql']->query_single("SELECT * FROM tourentyp WHERE tid=19"); $tmpl=0; $tname=$row_tt['tname'];
$zaehler = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); 
if($zaehler['num_rows']>0) { $ldaten = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' and jahr='".$_GET['jahr']."' and fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); while($row = $ldaten->fetch_assoc()) { $tmpl=$tmpl+$row['tarif']; }} $glohn=$glohn+$tmpl; 
$pdf->Cell(40,5,($tname),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($zaehler['num_rows']." Touren"),'0','0','L','0');  $pdf->Cell(30,5,($tmpl.",00 EUR"),'0','0','R','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 37, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 
//-------- zeile 39
$row_tt = $GLOBALS['mysql']->query_single("SELECT * FROM tourentyp WHERE tid=20"); $tmpl=0; $tname=$row_tt['tname'];
$zaehler = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); 
if($zaehler['num_rows']>0) { $ldaten = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' and jahr='".$_GET['jahr']."' and fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); while($row = $ldaten->fetch_assoc()) { $tmpl=$tmpl+$row['tarif']; }} $glohn=$glohn+$tmpl; 
$pdf->Cell(40,5,($tname),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($zaehler['num_rows']." Touren"),'0','0','L','0');  $pdf->Cell(30,5,($tmpl.",00 EUR"),'0','0','R','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 38, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 


//-------- zeile 40 ** leerzeile
$pdf->Cell(40,5," ",'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,5,(" "),'0','0','R','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 39, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 

//-------- zeile 41 ** Gesamtsumme
$pdf->Cell(40,5," ",'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,5,("Gesamt: ".$glohn.",00 EUR"),'0','0','R','0');  $pdf->Cell(10,5,(" "),'0','0','L','0'); 
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 LIMIT 39, 1");
if($kd['num_rows']>0) {
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$kd['grund']."'");
$pdf->Cell(20,5,($kd['tag'].".".$kd['monat'].".".$kd['jahr']),'0','0','R','0'); $pdf->Cell(25,5,($kg['bez']),'0','0','L','0'); $pdf->Cell(35,5,($info['pinfo']),'0','1','L','0'); 
}else{$pdf->Cell(40,5,(" "),'0','1','L','0'); } $pdf->SetFont('Helvetica','',10); 


//----------------------------------------------- Einzelnachweis -------------------------------------------------
//$pdf = new PDF('P','mm','A4');
$pdf->AddPage();
//	blau (0,160,230)
//	Orange (240,150, 0)
//  grau (200,200,200)
$pdf->Write(3,"\n"); $summe=0;
$pdf->SetFillColor(180,180,180);  $pdf->SetFont('Helvetica','BI',10); $pdf->SetTextColor(255,255,255);
$pdf->Cell(30,5,"Tourtyp",'1','0','L','1');
$pdf->Cell(37,5,"Datum/Zeit",'1','0','L','1');
$pdf->Cell(32,5,"Tour",'1','0','L','1');
$pdf->Cell(20,5,"Lohnv.",'1','0','L','1');
$pdf->Cell(5,5,"X",'1','0','L','1');
$pdf->Cell(10,5," ",'0','0','L','0');
$pdf->Cell(60,5,"Mitarbeiterdaten",'1','1','L','1');
//	$pdf->Write(8,"\n");
$pdf->SetFillColor(255,255,255); $pdf->SetTextColor(0,0,0); $pdf->SetFont('Helvetica','',10);
$zeilen=25;
$typen = $GLOBALS['mysql']->query("SELECT * FROM tourentyp"); 
while($row_tt = $typen->fetch_assoc()) {
	$zaehler = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); $key=0;
	if($zaehler['num_rows']>0) { //prüfen ob eintrag bei aktuellen tourentyp
		$pdf->SetFont('Helvetica','B',10); 
//		$pdf->Cell(104,5,($row_tt['tname']." - ".$row_tt['tinfotitel']),'0','0','L','0'); 
 		$pdf->Cell(30,5,($row_tt['tname']),'T','0','L','0');		
		$pdf->SetFont('Helvetica','',10);
		$noscreen=1; 
		$ldaten = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' and jahr='".$_GET['jahr']."' and fahrer='".$_GET['ma']."' AND typ='".$row_tt['tid']."' ORDER BY tag"); $key=0;
		while($row = $ldaten->fetch_assoc()) {
			if($noscreen==1) { $noscreen=0; } else {  $pdf->Cell(30,5,(" "),'0','0','L','0'); }
			$pdf->Cell(37,5,($row['tag'].".".$row['monat'].".".$row['jahr']." - ".$row['zeit']." Uhr"),'1','0','R','1');
			$tmpd = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
			$pdf->Cell(32,5,($tmpd['tour']),'1','0','L','1');
			$pdf->Cell(20,5,($row['tarif'].",00 EUR"),'1','0','R','1');	$summe=$summe+$row['tarif'];
			$pdf->Cell(5,5,($row['tarifz']),'1','0','R','1');
//---------------------------------------------------------------- 2 Spalte
			if($zeilen>1) {
				$pdf->Cell(10,5,(" "),'0','0','L','0');	 $pdf->Cell(20,5,("x"),'1','0','L','1'); $pdf->Cell(40,5,("xxx"),'1','1','L','1');	
				$zeilen--;
			} else {
				$pdf->Cell(70,5,(" "),'0','1','L','0');	
			}
		}
	}
	$key++;
}
// if 2. spalte null
$pdf->Cell(10,5,(" "),'0','1','L','0');
$pdf->SetFont('Helvetica','B',10); 
$pdf->Cell(30,5,("Summe:"),'T','0','L','0');
$pdf->SetFont('Helvetica','',10);
$pdf->Cell(89,5,($summe.",00 EUR"),'1','0','R','1');
$pdf->Cell(5,5,($row['tarifz']),'1','0','R','1');


$fahrer = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$_GET['ma']."'");
$pdf->Output('Lohnvorschlag_'.($fahrer['name']).'.pdf','I');
 
?>