steven/jb-data.de
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions
jb-data.de/a_lohnpdf.php
steven 72a26edcff init
2025-08-11 22:23:30 +02:00

417 lines
No EOL
34 KiB
PHP
Raw Permalink Blame History

<?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,$fahrer['name'],'0','0','L','0'); $this->Cell(28,8,$_GET['monat']."/".$_GET['jahr'],'0','1','L','1');
$this->SetFont('Helvetica','BI',20);
$this->Image('jb_logo2.png', 125, 7);
$this->Write(3,"\n");
}
}
$pdf = new PDF('P','mm','A4');
$pdf->AddPage();
$pdf->Write(3,"\n"); $summe=0;
$pdf->SetFillColor(180,180,180); $pdf->SetFont('Helvetica','BI',10); $pdf->SetTextColor(255,255,255);
$pdf->Cell(100,5,"Mitarbeiterdaten",'1','0','L','1');
$pdf->Cell(10,4," ",'0','0','L','0');
$pdf->Cell(80,5,"Festvertrag Fahrdaten",'1','1','L','1'); $pdf->Write(3,"\n");
$fahrer = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$_GET['ma']."'");
$tarifi = $GLOBALS['mysql']->query_single("SELECT * FROM tariftyp WHERE id='".$fahrer['tarifgtyp']."'");
// echo "<pre>"; print_r($tarifi); echo "</pre>";
$planer = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."'");
//---------------------------------------------------------------------------------------------------------------------------------------------------------
$monatstage = date("t",mktime(0, 0, 0,$_GET['monat'], 1,$_GET['jahr'])); $nachttage=0; $pintage=0; $rpintage=0; $aft=0;
for ($i = 1; $i <= $monatstage; $i++) {
$ft = $GLOBALS['mysql']->query_single("SELECT * FROM feiertage WHERE tag='".$i."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."'");
if($ft['num_rows']>0) {
$aft++;
} else {
if (date("N",mktime(0, 0, 0,$_GET['monat'],$i,$_GET['jahr']))<7) { $nachttage++; } // 6 Tage Mo-Sa.
if (date("N",mktime(0, 0, 0,$_GET['monat'],$i,$_GET['jahr']))<7 && date("N",mktime(0, 0, 0,$_GET['monat'],$i,$_GET['jahr']))>1 ) { $pintage++; } // 5 Tage Di-Sa.
if (date("N",mktime(0, 0, 0,$_GET['monat'],$i,$_GET['jahr']))<6) { $rpintage++; } // 5 Tage Mo-Fr.
}
}
$pdf->SetTextColor(0,0,0); $pdf->SetFont('Helvetica','',9);
//-------- zeile 1 // Festdaten !!!!!!!!!! Anzahl Nachttage
$pdf->Cell(40,4,("Name:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['name']),'0','0','L','0'); $pdf->Cell(10,4,(" "),'0','0','L','0');
$pdf->Cell(10,4,($nachttage." x"),'0','0','R','0'); $pdf->Cell(50,4,(" Nachttage ".$_GET['monat']."/".$_GET['jahr']),'0','0','L','0'); $pdf->Cell(20,4,("(Mo.-Sa.)"),'0','1','L','0');
$pdf->SetFont('Helvetica','',9);
//-------- zeile 2 // Festdaten !!!!!!!!!! Anzahl post
$pdf->Cell(40,4,("Strasse:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['strasse']),'0','0','L','0'); $pdf->Cell(10,4,(" "),'0','0','L','0');
$pdf->Cell(10,4,($pintage." x"),'0','0','R','0'); $pdf->Cell(50,4,(" Post-Tage ".$_GET['monat']."/".$_GET['jahr']),'0','0','L','0'); $pdf->Cell(20,4,("(Di.-Sa.)"),'0','1','L','0');
$pdf->SetFont('Helvetica','',9);
//-------- zeile 3 // Festdaten !!!!!!!!!! Anzahl rtour
$pdf->Cell(40,4,("Wohnort:"),'0','0','L','0');$pdf->SetFont('Courier','B',10);$pdf->Cell(60,4,($fahrer['plz']." ".$fahrer['ort']),'0','0','L','0');$pdf->Cell(10,4,(" "),'0','0','L','0');
$pdf->Cell(10,4,($rpintage." x"),'0','0','R','0'); $pdf->Cell(50,4,(" RTourtage ".$_GET['monat']."/".$_GET['jahr']),'0','0','L','0'); $pdf->Cell(20,4,("(Mo.-Fr.)"),'0','1','L','0');
$pdf->SetFont('Helvetica','',9);
//-------- zeile 4 feiertage
$pdf->Cell(40,4,("Telefon 1:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['handy']),'0','0','L','0'); $pdf->Cell(10,4,(" "),'0','0','L','0');
$pdf->Cell(10,4,($aft." x"),'0','0','R','0'); $pdf->Cell(50,4,(" Feiertage ".$_GET['monat']."/".$_GET['jahr']),'0','0','L','0'); $pdf->Cell(20,4,(" "),'0','1','L','0');
$pdf->SetFont('Helvetica','',9);
//-------- zeile 5 - 2. spalte leer !!!!!!!!!!
$pdf->Cell(40,4,("Telefon 2:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['tel']),'0','0','L','0'); $pdf->Cell(10,4,(" "),'0','0','L','0');
$pdf->Cell(80,4,(" "),'0','1','L','0'); $pdf->SetFont('Helvetica','',9);
//-------- zeile 6
$pdf->Cell(40,4,("Geb.-tag:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['gebtag'].".".$fahrer['gebmonat'].".".$fahrer['gebjahr']),'0','0','L','0');
$pdf->Cell(10,4,(" "),'0','0','L','0');
$pdf->SetFillColor(180,180,180); $pdf->SetFont('Helvetica','BI',10); $pdf->SetTextColor(255,255,255);
$pdf->Cell(80,5,"Typrechnung soll / ist",'1','1','L','1'); $pdf->SetTextColor(0,0,0); $pdf->SetFont('Helvetica','',9);
//-------- zeile 7
$pdf->Cell(40,4,("Eintritt:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['eintag'].".".$fahrer['einmonat'].".".$fahrer['einjahr']),'0','0','L','0');
$pdf->Cell(10,4,(" "),'0','0','L','0'); $pdf->Cell(80,4,(" "),'0','1','L','0'); $pdf->SetFont('Helvetica','',9);
//-----------
if($fahrer['typ']==3 || $fahrer['typ']==4) {
//-------- Nachtfahrer Zeitung
$zaehler=0; $solltage=$nachttage;
$abfrage = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ=3");
$zaehler=$zaehler+$abfrage['num_rows'];
$abfrage = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ=4");
$zaehler=$zaehler+$abfrage['num_rows'];
}
if($fahrer['typ']==5) {
//-------- postfahrer Zeitung
$zaehler=0; $solltage=$pintage;
$abfrage = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ=5");
$zaehler=$zaehler+$abfrage['num_rows'];
}
if($fahrer['typ']==6) {
//-------- rtourfahrer Zeitung
$zaehler=0; $solltage=$rpintage;
$abfrage = $GLOBALS['mysql']->query_single("SELECT * FROM tourenliste WHERE monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND fahrer='".$_GET['ma']."' AND typ=6");
$zaehler=$zaehler+$abfrage['num_rows'];
}
//-------- zeile 8
$pdf->Cell(40,4,("Steuer Nr.:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['steuernr']),'0','0','L','0'); $pdf->Cell(10,4,(" "),'0','0','L','0');
$pdf->Cell(10,4,($zaehler." x"),'0','0','R','0'); $pdf->Cell(50,4,(" gefahren - soll Touren: "),'0','0','L','0'); $pdf->Cell(20,4,($solltage." x"),'0','1','R','0');
$pdf->SetFont('Helvetica','',9);
//-------- zeile 9
$pdf->Cell(40,4,("S.V.Nr.:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['svnr']),'0','0','L','0'); $pdf->Cell(10,4,(" "),'0','0','L','0');
$pdf->Cell(10,4,(" "),'0','0','L','0'); $pdf->Cell(80,4,(" "),'0','1','L','0'); $pdf->SetFont('Helvetica','',9);
//-------- zeile 10
$pdf->Cell(40,4,("Krankenkasse:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['kk']),'0','0','L','0'); $pdf->Cell(10,4,(" "),'0','0','L','0');
$pdf->SetFillColor(180,180,180); $pdf->SetFont('Helvetica','BI',10); $pdf->SetTextColor(255,255,255);
$pdf->Cell(80,5,"Eintrag im Kalender",'1','1','L','1'); $pdf->SetTextColor(0,0,0); $pdf->SetFont('Helvetica','',9);
//-------- zeile 11
$pdf->Cell(40,4,("KK V.Nr.:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['kkvnr']),'0','0','L','0'); $pdf->Cell(10,4,(" "),'0','0','L','0');
$pdf->Cell(10,4,(" "),'0','0','L','0'); $pdf->Cell(80,4,(" "),'0','1','L','0'); $pdf->SetFont('Helvetica','',9);
//-------------------------------------
//-------------- kalender ausrechnen
//-------------------------------------
$zz=0;
//------------- neu Kalendereinträge zusammengefasst
//--------------- zusammenfassung
$temp1 = $GLOBALS['mysql']->query("SELECT * FROM planer_bez WHERE id<80");
while($row = $temp1->fetch_assoc()) {
$kd = $GLOBALS['mysql']->query_single("SELECT * FROM planer WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."' AND grund='".$row['id']."'");
if($kd['num_rows']>0) {
$zz++;
$tmp[$zz]['a']=$kd['num_rows']." x";
$tmp[$zz]['b']=" ";
$tmp[$zz]['c']=$row['bez']." x";
}
}
//---------------------------- 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"); $key=0;
while($row = $kdata->fetch_assoc()) {
$zz++;
$tmp[$zz]['a']=$row['tag'].".".$row['monat'];
$kg = $GLOBALS['mysql']->query_single("SELECT * FROM planer_bez WHERE id='".$row['grund']."'"); $tmp[$zz]['b']=$kg['bez'];
$tmp[$zz]['c']=$row['info'];
}
//------------------------------------------------------------------------------------------------------ kalenderrechnung ende
$za=0;
//-------- zeile 12
$pdf->Cell(40,4,("Steuerklasse:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['stkl']),'0','0','L','0'); $pdf->Cell(10,4,(" "),'0','0','L','0');
$za++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
//-------- zeile 13
$pdf->Cell(40,4,("Freibetrag:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['stfb']),'0','0','L','0'); $pdf->Cell(10,4,(" "),'0','0','L','0');
$za++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
//-------- zeile 14
$pdf->Cell(40,4,("Bank-Iban:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['iban']),'0','0','L','0'); $pdf->Cell(10,4,(" "),'0','0','L','0');
$za++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
//-------- zeile 15
$pdf->Cell(40,4,("Bank-BIC:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($fahrer['bic']),'0','0','L','0'); $pdf->Cell(10,4,(" "),'0','0','L','0');
$za++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
//-------- zeile 16
$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,(" "),'0','0','L','0'); $pdf->Cell(10,4,(" "),'0','0','L','0');
$za++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
//-------- zeile 17
$pdf->SetFillColor(180,180,180); $pdf->SetFont('Helvetica','BI',10); $pdf->SetTextColor(255,255,255);
$pdf->Cell(100,5,"Lohnzusammenfassung",'1','0','L','1'); $pdf->Cell(10,4,(" "),'0','0','L','0');
$pdf->SetFillColor(180,180,180); $pdf->SetFont('Courier','B',10); $pdf->SetTextColor(0,0,0);
$za++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
//-------- zeile 18
$pdf->Cell(40,4,(" "),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,(" "),'0','0','L','0'); $pdf->Cell(10,4,(" "),'0','0','L','0');
$za++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
//-----------------------
//--------------- Lohn
//-----------------------
//-------- zeile 19 ** Grundlohn
if ($fahrer['einmonat']==$_GET['monat'] && $fahrer['einjahr']==$_GET['jahr']) {
$gtage=27-$fahrer['eintag']; $glohn=($fahrer['tarifg']/26); $glohn=$glohn*$gtage; $glohn=round($glohn,0);
$pdf->Cell(40,4,("Grundlohn:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($gtage." Tage"),'0','0','L','0'); $pdf->Cell(30,5,($glohn.".00 EUR"),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0');
} else { $glohn=$fahrer['tarifg'];
$pdf->Cell(40,4,("Grundlohn:"),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(60,4,($glohn.",00 EUR"),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0');
}
$za++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
//------------- Zählerausrechnung
$zz=0;
$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");
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 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");
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 ORDER BY tag");
while($rowl = $ldaten->fetch_assoc()) { $tmpl=$tmpl+$rowl['tarif']; } $glohn=$glohn+$tmpl; $zz++;
$tml[$zz]['a']=$row['tname']." -Abn.";
$tml[$zz]['b']=$tl['num_rows']." Touren";
$tml[$zz]['c']=number_format($tmpl, 2, ',', '')." EUR";
}
}
$zb=1;
//-------- zeile 20
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
//-------- zeile 21
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
//-------- zeile 22
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);//-------- zeile 23
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);//-------- zeile 24
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);//-------- zeile 25
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);//-------- zeile 26
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);//-------- zeile 27
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);//-------- zeile 28
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);//-------- zeile 29
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);//-------- zeile 30
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);//-------- zeile 31
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);//-------- zeile 32
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);//-------- zeile 33
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);//-------- zeile 34
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);//-------- zeile 35
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);//-------- zeile 36
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);//-------- zeile 37
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);//-------- zeile 38
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);//-------- zeile 39
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);//-------- zeile 40 **
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);//-------- zeile 41 **
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
//-------- zeile 42 **
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
//-------- zeile 43 **
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
//-------- zeile 44 **
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
//-------- zeile 45 **
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
//-------- zeile 46 **
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
//-------- zeile 47 **
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
//-------- zeile 48 **
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
//-------- zeile 49 **
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
//-------- zeile 50 **
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
/*
//-------- zeile 51 **
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; ;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
//-------- zeile 52 **
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
//-------- zeile 53 **
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
*/
//lohnabzug
$ma_minus = $GLOBALS['mysql']->query_single("SELECT * FROM ma_abzahlung WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."'");
if($ma_minus['num_rows']==0) {
//-------- zeile 51 **
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; ;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
//-------- zeile 52 **
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
//-------- zeile 53 **
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}
if($ma_minus['num_rows']==1) {
//-------- zeile 51 **
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; ;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
//-------- zeile 52 **
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}
if($ma_minus['num_rows']==2) {
//-------- zeile 51 **
$pdf->Cell(40,4,($tml[$zb]['a']),'0','0','L','0'); $pdf->SetFont('Courier','B',10); $pdf->Cell(30,5,($tml[$zb]['b']),'0','0','L','0');
$pdf->Cell(30,5,($tml[$zb]['c']),'0','0','R','0'); $pdf->Cell(10,4,(" "),'0','0','L','0'); $za++; $zb++; ;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
}
//-------- zeile summe ** Gesamtsumme
$pdf->SetFillColor(180,180,180); $pdf->SetFont('Helvetica','BI',10); $pdf->SetTextColor(255,255,255);
$pdf->Cell(100,5,"Lohnvorschlag",'1','1','L','1');
$pdf->SetFillColor(180,180,180); $pdf->SetFont('Courier','B',10); $pdf->SetTextColor(0,0,0);
// $pdf->Cell(100,5," ",'0','1','L','0');
$glohn=number_format($glohn, 2, ',', ''); // 2 nachkommastellen
if($stundenanzeige>0) {
$pdf->Cell(10,4,("Stunden-Summe: "),'0','0','R','0'); $pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0');
$pdf->Cell(70,5,("Stunden-Summe: "),'0','0','R','0'); $pdf->Cell(30,5,($glohn." EUR"),'0','0','R','0');
}
//zwischensumme
$pdf->Cell(70,5,("Zwischenumme: "),'0','0','R','0'); $pdf->Cell(30,5,($glohn." EUR"),'0','1','R','0');
if($ma_minus['num_rows']>0) {
$temp8 = $GLOBALS['mysql']->query("SELECT * FROM ma_abzahlung WHERE mid='".$_GET['ma']."' AND monat='".$_GET['monat']."' AND jahr='".$_GET['jahr']."'");
while($row = $temp8->fetch_assoc()) {
$minuslohn=number_format($row['summe'], 2, ',', ''); // 2 nachkommastellen
$pdf->Cell(70,5,("(Abzug) ".$row['grund'].": "),'0','0','R','0'); $pdf->Cell(30,5,("-".$minuslohn." EUR"),'0','1','R','0'); $glohn=$glohn-$minuslohn;
}
$glohn=number_format($glohn, 2, ',', ''); // 2 nachkommastellen
}
// $glohn=number_format($glohn, 2, ',', ''); // 2 nachkommastellen
if($tarifi['netto']>0) {
$pdf->Cell(70,5,("NETTO-Summe: "),'0','0','R','0'); $pdf->Cell(30,5,($glohn." EUR"),'0','0','R','0');
} else {
$pdf->Cell(70,5,("Brutto-Summe: "),'0','0','R','0'); $pdf->Cell(30,5,($glohn." EUR"),'0','0','R','0');
}
$pdf->Cell(10,4,(" "),'0','0','R','0'); $za++;
$pdf->Cell(10,4,($tmp[$za]['a']),'0','0','R','0');
$pdf->Cell(50,4,($tmp[$za]['b']),'0','0','L','0'); $pdf->Cell(20,4,($tmp[$za]['c']),'0','1','R','0'); $pdf->SetFont('Helvetica','',9);
$fahrer = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$_GET['ma']."'");
$pdf->Output('Lohnvorschlag_'.($fahrer['name']).'.pdf','I');
?>
Reference in a new issue View git blame Copy permalink