480 lines
50 KiB
PHP
480 lines
50 KiB
PHP
<?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');
|
|
|
|
?>
|