721 lines
No EOL
41 KiB
PHP
721 lines
No EOL
41 KiB
PHP
<?php
|
|
//error_reporting(E_ALL); ini_set('display_errors',1);
|
|
require('lib/fpdf.php');
|
|
class PDF extends FPDF {
|
|
function Footer() {
|
|
$this->SetY(-15);
|
|
$this->SetFont('Helvetica','I',6);
|
|
$this->Cell(190,3,'JB-Transport.de - Bautzner Str. 67 - 04347 Leipzig ***** Interne Liste - NON Public ***** F.Teichert 2016','1','0','C','1');
|
|
}
|
|
function Header() {
|
|
$this->SetFont('Helvetica','B',20);
|
|
$this->SetTextColor(70,130,180);
|
|
$fahrer = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$_GET['ma']."'");
|
|
$this->SetFillColor(255,255,255);
|
|
$this->Cell(54,8,"Lohnvorschlag aus EDV",'0','1','L','1');
|
|
$this->Cell(85,8,utf8_decode($fahrer['name']),'0','0','L','0'); $this->Cell(28,8,$_GET['monat']."/".$_GET['jahr'],'0','1','L','1');
|
|
$this->SetFont('Helvetica','BI',20);
|
|
$this->Image('jb_logo2.png', 125, 7);
|
|
$this->Write(1,"\n");
|
|
}
|
|
}
|
|
$pdf = new PDF('P','mm','A4');
|
|
$pdf->AddPage();
|
|
$pdf->Write(1,"\n"); $summe=0;
|
|
|
|
// echo "<pre>"; print_r($tarifi); echo "</pre>";
|
|
//--------------------------------------------------------------------- Daten auslesen -----------
|
|
//------------------------------------------------------------------------------------------------
|
|
//------------------------------------------------------------------------------------ Fahrerdaten
|
|
$fahrer = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$_GET['ma']."'");
|
|
$tarifi = $GLOBALS['mysql']->query_single("SELECT * FROM tariftyp WHERE id='".$fahrer['tarifgtyp']."'");
|
|
$planer = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."'");
|
|
|
|
//------------------------------------------------------------------------------------- Tage ist/soll
|
|
$monatstage = date("t",mktime(0, 0, 0,$_GET['monat'], 1,$_GET['jahr'])); $nachttage=0; $pintage=0; $rpintage=0; $aft=0;
|
|
for ($i = 1; $i <= $monatstage; $i++) {
|
|
$ft = $GLOBALS['mysql']->query_single("SELECT * FROM feiertage WHERE tag='".$i."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."'");
|
|
if($ft['num_rows']>0) {
|
|
$aft++;
|
|
} else {
|
|
if (date("N",mktime(0, 0, 0,$_GET['monat'],$i,$_GET['jahr']))<7) { $nachttage++; } // 6 Tage Mo-Sa.
|
|
if (date("N",mktime(0, 0, 0,$_GET['monat'],$i,$_GET['jahr']))<7 && date("N",mktime(0, 0, 0,$_GET['monat'],$i,$_GET['jahr']))>1 ) { $pintage++; } // 5 Tage Di-Sa.
|
|
if (date("N",mktime(0, 0, 0,$_GET['monat'],$i,$_GET['jahr']))<6) { $rpintage++; } // 5 Tage Mo-Fr.
|
|
}
|
|
}
|
|
|
|
//---------------------------------------------------------- Berechnung soll ist tage nach tourentyp
|
|
if($fahrer['typ']==3 || $fahrer['typ']==4) {
|
|
//-------- Nachtfahrer Zeitung
|
|
$zaehler=0; $solltage=$nachttage;
|
|
$abfrage = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ=3");
|
|
$zaehler=$zaehler+$abfrage['num_rows'];
|
|
$abfrage = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ=4");
|
|
$zaehler=$zaehler+$abfrage['num_rows'];
|
|
}
|
|
if($fahrer['typ']==5) {
|
|
//-------- postfahrer Zeitung
|
|
$zaehler=0; $solltage=$pintage;
|
|
$abfrage = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ=5");
|
|
$zaehler=$zaehler+$abfrage['num_rows'];
|
|
}
|
|
if($fahrer['typ']==6) {
|
|
//-------- rtourfahrer Zeitung
|
|
$zaehler=0; $solltage=$rpintage;
|
|
$abfrage = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ=6");
|
|
$zaehler=$zaehler+$abfrage['num_rows'];
|
|
}
|
|
//******************************************************************************************************************************************************
|
|
//-------------------------------------
|
|
//-------------- kalender ausrechnen
|
|
//-------------------------------------
|
|
$zz=0; $mark=1;
|
|
//------------- neu Kalendereinträge zusammengefasst
|
|
|
|
$tmp=[];
|
|
//--------------- zusammenfassung
|
|
$temp1 = $GLOBALS['mysql']->query("SELECT * FROM planer_bez WHERE id<80");
|
|
while($row = $temp1->fetch_assoc()) {
|
|
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund='".$row['id']."'");
|
|
if($kd['num_rows']>0) {
|
|
$zz++;
|
|
$tmp[$zz]['a']=$kd['num_rows']." x";
|
|
$tmp[$zz]['b']=" ";
|
|
$tmp[$zz]['c']=$row['bez'];
|
|
$tmp[$zz]['x']=$kd['num_rows']." x ".$row['bez']; // neu !!!
|
|
$tmp[$zz]['m']=1;
|
|
}
|
|
}
|
|
//******************************************************************************************************************************************************
|
|
//---------------------------- leerzeile ????????????????????????????????????????????????
|
|
$zz++; $tmp[$zz]['a']=" "; $tmp[$zz]['b']=" "; $tmp[$zz]['c']=" ";
|
|
//---------------------------------------- Einzelanzeige
|
|
$kdata = $GLOBALS['mysql']->query("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund>0 ORDER BY tag"); $key=0;
|
|
while($row = $kdata->fetch_assoc()) {
|
|
$zz++;
|
|
$tmp[$zz]['a']=$row['tag'].".".$row['monat'];
|
|
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$row['grund']."'");
|
|
$tmp[$zz]['b']=" ";
|
|
$tmp[$zz]['c']=$kg['bez'];
|
|
$tmp[$zz]['x']=$row['tag'].".".$row['monat']." ".$kg['bez']; // neu !!!
|
|
}
|
|
//echo "<pre>"; print_r($tmp); echo "</pre>";
|
|
//------------------------------------------------------------------------------------------------------ kalenderrechnung ende
|
|
$za=0; $key=0; $ze=0;
|
|
//******************************************************************************************************************************************************
|
|
//******************************************************************************************************* Einzelanzeige Zusatzarbeit *******************
|
|
$temp7=$GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE fahrer='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND tarif>0 ORDER BY typ,time");
|
|
while($row = $temp7->fetch_assoc()) {
|
|
$tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'");
|
|
$etour[$key]['datum']=$row['tag'].".".$row['monat'].".".$row['jahr'];
|
|
$etour[$key]['tour']=$tour['tour'];
|
|
$etour[$key]['tarif']=$row['tarif'];
|
|
$key++;
|
|
}
|
|
|
|
// _pdf_lohn_extra.php
|
|
|
|
//******************************************************************************************************************************************************
|
|
//******************************************************************************************************************************************************
|
|
//******************************************************************************************************************************************************
|
|
//----------------------------------------------------------------------------------------------------- Zwischentabellenüberschrift
|
|
$pdf->SetFillColor(120,120,120); $pdf->SetFont('Helvetica','BI',10); $pdf->SetTextColor(255,255,255);
|
|
$pdf->Cell(100,4,"Mitarbeiterdaten",'0','0','L','1');
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
$pdf->Cell(80,4,"Festvertrag Fahrdaten",'0','1','L','1'); $pdf->Write(3,"\n"); $pdf->SetTextColor(0,0,0);
|
|
// Lohnzusammenfassung
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 1 Name
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(40,4,("Name:"),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,(utf8_decode($fahrer['name'])),'0','0','L','0');
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//-------- zeile 1 rechts
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(25,4,("Nachttage "),'0','0','L','0');
|
|
$pdf->Cell(25,4,($_GET['monat']."/".$_GET['jahr']),'0','0','L','0');
|
|
$pdf->Cell(30,4,($nachttage." x (Mo.-Sa.)"),'0','1','R','0');
|
|
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 2 Adresse - Strasse
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(40,4,("Strasse:"),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,(utf8_decode($fahrer['strasse'])),'0','0','L','0');
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//-------- zeile 2 rechts
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(25,4,("Post-Tage "),'0','0','L','0');
|
|
$pdf->Cell(25,4,($_GET['monat']."/".$_GET['jahr']),'0','0','L','0');
|
|
$pdf->Cell(30,4,($pintage." x (Di.-Sa.)"),'0','1','R','0');
|
|
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 3 PLZ+Ort
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(40,4,("Wohnort:"),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,(utf8_decode($fahrer['plz'])." ".utf8_decode($fahrer['ort'])),'0','0','L','0');
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//-------- zeile 3 rechts
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(25,4,("RTourtage "),'0','0','L','0');
|
|
$pdf->Cell(25,4,($_GET['monat']."/".$_GET['jahr']),'0','0','L','0');
|
|
$pdf->Cell(30,4,($rpintage." x (Mo.-Fr.)"),'0','1','R','0');
|
|
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 4 links telefonnummer
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(40,4,("Telefon 1:"),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['handy']),'0','0','L','0');
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//-------- zeile 4 rechts
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(25,4,("Feiertage "),'0','0','L','0');
|
|
$pdf->Cell(25,4,($_GET['monat']."/".$_GET['jahr']),'0','0','L','0');
|
|
$pdf->Cell(30,4,(" ".$aft." x (Mo.-Fr.)"),'0','1','R','0');
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 5
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(40,4,("Telefon 2:"),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['festnetz']),'0','0','L','0');
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//-------- zeile 5 rechts
|
|
$pdf->Cell(80,4,(" "),'0','1','L','0');
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 6
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(40,4,("Geb.-tag:"),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['gebtag'].".".$fahrer['gebmonat'].".".$fahrer['gebjahr']),'0','0','L','0');
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 6 rechts
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(20,4,("soll Touren: "),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(20,4,($solltage." x"),'0','0','L','0');
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(28,4,("ist Touren: "),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(27,4,($zaehler." x"),'0','1','L','0');
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 7
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(40,4,("Eintritt:"),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['eintag'].".".$fahrer['einmonat'].".".$fahrer['einjahr']),'0','0','L','0');
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 7 rechts
|
|
$pdf->Cell(80,4,(" "),'0','1','L','0');
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 8
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(40,4,("Steuer Nr.:"),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['steuerid']),'0','0','L','0');
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 8 rechts
|
|
$pdf->SetFillColor(120,120,120); $pdf->SetFont('Helvetica','BI',10); $pdf->SetTextColor(255,255,255);
|
|
$pdf->Cell(80,4,"Festvertrag Fahrdaten",'0','1','L','1'); $pdf->SetTextColor(0,0,0);
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 9
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(40,4,("S.V.Nr.:"),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['svnummer']),'0','0','L','0');
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 9 rechts
|
|
$pdf->Cell(80,4,(" "),'0','1','L','0');
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 10
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(40,4,("Krankenkasse:"),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,utf8_decode($fahrer['kkasse']),'0','0','L','0');
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 10 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 11
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(40,4,("KK V.Nr.:"),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,utf8_decode($fahrer['kkassennr']),'0','0','L','0');
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 11 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 12
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(40,4,("Steuerklasse:"),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['steuerkl']),'0','0','L','0');
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 12 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 13
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(40,4,("Freibetrag:"),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['kinderfb']),'0','0','L','0');
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 13 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 14
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(40,4,("Bank-Iban:"),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['iban']),'0','0','L','0');
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 14 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 15
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(40,4,("Bank-BIC:"),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['BIC']),'0','0','L','0');
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 15 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 27 Links leerzeile // platzhalter
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(100,4,(" "),'0','0','L','0');
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 27 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 28 links
|
|
$pdf->SetFillColor(120,120,120); $pdf->SetTextColor(255,255,255);
|
|
$pdf->SetFont('Helvetica','BI',10); $pdf->Cell(100,4,"Eintrag im Kalender",'0','0','L','1');
|
|
$pdf->SetFont('Courier','B',10); $pdf->SetTextColor(0,0,0);
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//-------- zeile 28 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 29 Links leerzeile // platzhalter
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(100,4,(" "),'0','0','L','0');
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 29 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 30
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_data.php';
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 30 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 31
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_data.php';
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 31 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 32
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_data.php';
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 32 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 33
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_data.php';
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 33 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 34
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_data.php';
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 34 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 35
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_data.php';
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 35 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 36
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_data.php';
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 36 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 37
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_data.php';
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 37 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 38
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_data.php';
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 38 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 39
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_data.php';
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 39 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 40
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_data.php';
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 40 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 41
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_data.php';
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 41 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 42
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_data.php';
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 42 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 43
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_data.php';
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 43 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 44
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_data.php';
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 44 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 45
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_data.php';
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 45 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 46
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_data.php';
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 46 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 47
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_data.php';
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 47 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 48
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_data.php';
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 48 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
//**************************************************************************
|
|
//************************************************************************** Kalender ende
|
|
//**************************************************************************
|
|
// ausgleichszeilen Abzüge !!
|
|
$pdf->SetFont('Courier','B',10);
|
|
$ma_minus = $GLOBALS['mysql']->query_single("SELECT * FROM ma_abzahlung WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."'");
|
|
if($ma_minus['num_rows']<1) { include '_pdf_lohn_data.php'; $pdf->Cell(10,4," ",'0','0','L','0'); $pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php'; }
|
|
if($ma_minus['num_rows']<2) { include '_pdf_lohn_data.php'; $pdf->Cell(10,4," ",'0','0','L','0'); $pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php'; }
|
|
if($ma_minus['num_rows']<3) { include '_pdf_lohn_data.php'; $pdf->Cell(10,4," ",'0','0','L','0'); $pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php'; }
|
|
if($ma_minus['num_rows']<4) { include '_pdf_lohn_data.php'; $pdf->Cell(10,4," ",'0','0','L','0'); $pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php'; }
|
|
if($ma_minus['num_rows']<5) { include '_pdf_lohn_data.php'; $pdf->Cell(10,4," ",'0','0','L','0'); $pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php'; }
|
|
if($ma_minus['num_rows']<6) { include '_pdf_lohn_data.php'; $pdf->Cell(10,4," ",'0','0','L','0'); $pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php'; }
|
|
if($ma_minus['num_rows']<7) { include '_pdf_lohn_data.php'; $pdf->Cell(10,4," ",'0','0','L','0'); $pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php'; }
|
|
if($ma_minus['num_rows']<8) { include '_pdf_lohn_data.php'; $pdf->Cell(10,4," ",'0','0','L','0'); $pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php'; }
|
|
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 49 links
|
|
$pdf->SetFillColor(120,120,120); $pdf->SetTextColor(255,255,255);
|
|
$pdf->SetFont('Helvetica','BI',10); $pdf->Cell(100,4,"Lohnvorschlag",'0','0','L','1');
|
|
$pdf->SetFont('Courier','B',10); $pdf->SetTextColor(0,0,0);
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//-------- zeile 49 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 50 Links leerzeile // platzhalter
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(100,4,(" "),'0','0','L','0');
|
|
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 50 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
// Lohnzusammenfassung
|
|
|
|
|
|
//******************************************************************************************************************************************************
|
|
//****************************************************************** else als Zeile wenn neu eingestellt - leer zeile später
|
|
//-------- zeile 51 Grundlohn
|
|
if ($fahrer['einmonat']==$_GET['monat'] && $fahrer['einjahr']==$_GET['jahr']) {
|
|
$monatstage= date( 't', mktime ( 0, 0, 0, $_GET['monat'], 1, $_GET['jahr'] ));
|
|
$gtage=$monatstage-$fahrer['eintag']+1; $glohn=($fahrer['tarifg']/$monatstage); $glohn=$glohn*$gtage; $glohn=round($glohn,0);
|
|
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(40,4,("anteil. Grundlohn - ".$gtage." Tage - ".$fahrer['tarifg'].",00 EUR"),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($glohn.",00 EUR"),'0','0','R','0');
|
|
} else {
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(40,4,("monatl. Grundlohn:"),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['tarifg'].",00 EUR"),'0','0','R','0');
|
|
$glohn=$fahrer['tarifg'];
|
|
}
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 51 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
|
|
|
|
//******************************************************************************************************************************************************
|
|
//------------- Zählerausrechnung
|
|
$zz=0;
|
|
if($fahrer['tarifgtyp']!=88) {
|
|
$temp2 = $GLOBALS['mysql']->query("SELECT * FROM tourentyp");
|
|
while($row = $temp2->fetch_assoc()) {
|
|
$tl=$GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE fahrer='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND typ='".$row['tid']."' AND utyp!=9 AND tour<8001 || fahrer='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND typ='".$row['tid']."' AND utyp!=9 AND tour>8999");
|
|
|
|
if($tl['num_rows']>0) { $tmpl=0;
|
|
$ldaten = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE fahrer='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND typ='".$row['tid']."' AND utyp!=9 AND tour<8001 || fahrer='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND typ='".$row['tid']."' AND utyp!=9 AND tour>8999 ORDER BY tag");
|
|
while($rowl = $ldaten->fetch_assoc()) { $tmpl=$tmpl+$rowl['tarif']; } $glohn=$glohn+$tmpl; $zz++;
|
|
$tml[$zz]['a']=$row['tname'];
|
|
$tml[$zz]['b']=$tl['num_rows']." Touren";
|
|
$tml[$zz]['c']=number_format($tmpl, 2, '.', '')." EUR";
|
|
}
|
|
$tl=$GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE fahrer='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND typ='".$row['tid']."' AND utyp=9 || fahrer='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND typ='".$row['tid']."' AND tour>8001 AND tour<8999");
|
|
if($tl['num_rows']>0) { $tmpl=0;
|
|
$ldaten = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE fahrer='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND typ='".$row['tid']."' AND utyp=9 || fahrer='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND typ='".$row['tid']."' AND tour>8001 AND tour<8999 ORDER BY tag");
|
|
while($rowl = $ldaten->fetch_assoc()) { $tmpl=$tmpl+$rowl['tarif']; } $glohn=$glohn+$tmpl; $zz++;
|
|
$tml[$zz]['a']=$row['tname']." -Abn.";
|
|
$tml[$zz]['b']=$tl['num_rows']." Touren";
|
|
$tml[$zz]['c']=number_format($tmpl, 2, ',', '')." EUR";
|
|
}
|
|
}
|
|
}
|
|
$zb=1;
|
|
//******************************************************************************************************************************************************
|
|
//******************************************************************************************************************************************************
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 52
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','R','0');
|
|
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0');
|
|
$za++; $zb++;
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 52 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 53
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','R','0');
|
|
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0');
|
|
$za++; $zb++;
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 53 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 54
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','R','0');
|
|
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0');
|
|
$za++; $zb++;
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 54 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 55
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','R','0');
|
|
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0');
|
|
$za++; $zb++;
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 55 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 56
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','R','0');
|
|
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0');
|
|
$za++; $zb++;
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 56 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 57
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','R','0');
|
|
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0');
|
|
$za++; $zb++;
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 57 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 58
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','R','0');
|
|
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0');
|
|
$za++; $zb++;
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 58 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 59
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','R','0');
|
|
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0');
|
|
$za++; $zb++;
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 59 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 60
|
|
$pdf->SetFont('Helvetica','',10); $pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0');
|
|
$pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','R','0');
|
|
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0');
|
|
$za++; $zb++;
|
|
$pdf->Cell(10,4," ",'0','0','L','0'); //---------------------- Mittelstreifen ----------------------
|
|
|
|
//------- zeile 60 rechts
|
|
$pdf->SetFont('Courier','B',10); include '_pdf_lohn_extra.php';
|
|
//******************************************************************************************************************************************************
|
|
//******************************************************************************************************************************************************
|
|
//******************************************************************************************************************************************************
|
|
//******************************************************************************************************************************************************
|
|
//-------- zeile 61 **
|
|
$glohn=number_format($glohn, 2, ',', '');
|
|
$pdf->Cell(70,5,("Zwischenumme:"),'0','0','R','0'); $pdf->Cell(30,5,($glohn." EUR"),'0','1','R','0');
|
|
|
|
|
|
//lohnabzug
|
|
$ma_minus = $GLOBALS['mysql']->query_single("SELECT * FROM ma_abzahlung WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."'");
|
|
|
|
if($ma_minus['num_rows']>0) {
|
|
$temp8 = $GLOBALS['mysql']->query("SELECT * FROM ma_abzahlung WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."'");
|
|
while($row = $temp8->fetch_assoc()) {
|
|
$minuslohn=number_format($row['summe'], 2, ',', ''); // 2 nachkommastellen
|
|
if ($row['zuschlag']>0) {
|
|
$pdf->Cell(70,5,utf8_decode("(Zuzahlung) ".$row['grund'].": "),'0','0','R','0'); $pdf->Cell(30,5,($minuslohn." EUR"),'0','1','R','0');
|
|
$glohn=$glohn+$minuslohn;
|
|
} else {
|
|
$pdf->Cell(70,5,utf8_decode("(Abzug) ".$row['grund'].": "),'0','0','R','0'); $pdf->Cell(30,5,("-".$minuslohn." EUR"),'0','1','R','0');
|
|
$glohn=$glohn-$minuslohn;
|
|
}
|
|
}
|
|
$glohn=number_format($glohn, 2, ',', ''); // 2 nachkommastellen
|
|
}
|
|
if($tarifi['netto']>0) {
|
|
$pdf->Cell(70,5,("NETTO-Summe:"),'0','0','R','0'); $pdf->Cell(30,5,($glohn." EUR"),'0','0','R','0');
|
|
} else {
|
|
$pdf->SetFillColor(255,211,155);
|
|
$pdf->Cell(70,5,("Brutto-Summe:"),'0','0','R','1'); $pdf->Cell(30,5,($glohn." EUR"),'0','0','R','0');
|
|
$pdf->SetFillColor(180,180,180);
|
|
}
|
|
|
|
$pdf->Cell(10,4,(" "),'0','0','R','0'); $za++;
|
|
$pdf->Cell(10,4,(" "),'0','0','R','0');
|
|
$pdf->Cell(50,4,(" "),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
|
|
//--------------------------------------------- ausgabe
|
|
$fahrer = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$_GET['ma']."'");
|
|
$pdf->Output('Lohnvorschlag_'.($fahrer['name']).'.pdf','I');
|
|
|
|
?>
|