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 ""; print_r($tarifi); echo "
";
//--------------------------------------------------------------------- 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 ""; print_r($tmp); echo "
";
//------------------------------------------------------------------------------------------------------ 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');
?>