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

255 lines
14 KiB
PHP
Raw Permalink Blame History

<?php
// UTF8 erzwingen
@setlocale(LC_CTYPE, 'de_DE.utf8', 'de_DE.UTF-8', 'en_US.utf8', 'en_US.UTF-8', 'en_GB.utf8', 'en_GB.UTF-8', 'de_AT.utf8', 'de_AT.UTF-8', 'de_CH.utf8', 'de_CH.UTF-8');
if( function_exists('mb_internal_encoding') )
{
mb_internal_encoding('utf-8');
}
header('Content-type: text/html; charset=utf-8');
error_reporting(E_ALL); ini_set('display_errors', 0);
$ma = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$_GET['id']."'");
$ko = $GLOBALS['mysql']->query_single("SELECT * FROM konfessionen WHERE id='".$ma['konfessionen']."'");
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 ***** by. F. Teichert ©2017','1','0','C','1');
}
}
$pdf = new PDF('P','mm','A4');
$pdf->AddPage();
// blau (0,160,230)
// Orange (240,150, 0)
// grau (200,200,200)
$pdf->SetFont('Helvetica','B',20);
$pdf->SetTextColor(100,100,100);
$pdf->SetFillColor(240,150,0);
$pdf->Write(9,"\n");
$pdf->Cell(115,8,($ma['name']),'0','1','R','0');
$pdf->SetFont('Helvetica','B',18);
$pdf->SetTextColor(0,0,140);
$pdf->Image('template/images/profil.png', 10, 5,25,25);
$pdf->Image('template/images/jb_logo2.png', 125, 7);
$pdf->Write(1,"\n\n");
$pdf->SetFont('Helvetica','B',6);
$pdf->SetFillColor(36,89,165);
//---------------------------------------------------------------------------------------------------
//---------------------------------------------------------------------------------------------------
$pdf->SetTextColor(255,255,255);
$pdf->Cell(90,5,"zur Person ",'LTR','0','L','1'); //blau
$pdf->Cell(10,5," ",'0' ,'0','L','0');
$pdf->Cell(90,5,"Kommunikation ",'LTR','1','L','1'); //blau
$pdf->Cell(90,2," ",'LTR','0','L','0'); //frei aber rand
$pdf->Cell(10,2," ",'0' ,'0','L','0');
$pdf->Cell(90,2," ",'LTR','1','L','0');
//MA-Daten
$pdf->SetTextColor(0,0,0);
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"Name:",'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,utf8_decode($ma['name']),'R','0','L','0');
$pdf->Cell(10,5," ",'0' ,'0','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"E-Mail:",'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,utf8_decode($ma['mail']),'R','1','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,utf8_decode("Straße:"),'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,utf8_decode($ma['strasse']),'R','0','L','0');
$pdf->Cell(10,5," ",'0' ,'0','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"Mobil:",'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,utf8_decode($ma['handy']),'R','1','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"Zusatz:",'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,utf8_decode($ma['azusatz']),'R','0','L','0');
$pdf->Cell(10,5," ",'0' ,'0','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"2.Tel:",'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,utf8_decode($ma['tel2']),'R','1','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"PLZ/Ort:",'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,utf8_decode($ma['plz']." ".$ma['ort']),'R','0','L','0');
$pdf->Cell(10,5," ",'0' ,'0','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"Festnetz:",'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,utf8_decode($ma['festnetz']),'R','1','L','0');
$pdf->Cell(90,5," ",'T','0'); $pdf->Cell(10,5," ",'0','0'); $pdf->Cell(90,5," ",'T','1');
//------------------------------------------------------------------------------------------------------------------
//---------------------------------------------------------------------------------------------------
$pdf->SetTextColor(255,255,255); $pdf->SetFont('Helvetica','B',6);
$pdf->Cell(90,5,"Erkennungsdaten ",'LTR','0','L','1'); //blau
$pdf->Cell(10,5," ",'0' ,'0','L','0');
$pdf->Cell(90,5,"Bank ",'LTR','1','L','1'); //blau
$pdf->Cell(90,2," ",'LTR','0','L','0'); //frei aber rand
$pdf->Cell(10,2," ",'0' ,'0','L','0');
$pdf->Cell(90,2," ",'LTR','1','L','0');
//MA-Daten
$pdf->SetTextColor(0,0,0);
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"Geburtstag:",'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,utf8_decode($ma['gebtag'].".".$ma['gebmonat'].".".$ma['gebjahr']),'R','0','L','0');
$pdf->Cell(10,5," ",'0' ,'0','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"Bankname:",'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,utf8_decode($ma['bankname']),'R','1','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"Geburtsort:",'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,utf8_decode($ma['gebort']),'R','0','L','0');
$pdf->Cell(10,5," ",'0' ,'0','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"Kontoinhaber:",'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,utf8_decode($ma['kontoinh']),'R','1','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,("Geburtsname:"),'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,utf8_decode($ma['gebname']),'R','0','L','0');
$pdf->Cell(10,5," ",'0' ,'0','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"IBAN:",'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,($ma['iban']),'R','1','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,utf8_decode("Nationalität:"),'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,utf8_decode($ma['staata']),'R','0','L','0');
$pdf->Cell(10,5," ",'0' ,'0','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"BIC:",'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,($ma['BIC']),'R','1','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"BPA-Nummer:",'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,$ma['bpa'],'R','0','L','0');
$pdf->Cell(10,5," ",'0' ,'0','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"Bankinfo:",'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,utf8_decode($ma['bzusatz']),'R','1','L','0');
$pdf->Cell(90,5," ",'T','0'); $pdf->Cell(10,5," ",'0','0'); $pdf->Cell(90,5," ",'T','1');
//------------------------------------------------------------------------------------------------------------------
//---------------------------------------------------------------------------------------------------
$pdf->SetTextColor(255,255,255); $pdf->SetFont('Helvetica','B',6);
$pdf->Cell(90,5,"Angaben zur Familie ",'LTR','0','L','1'); //blau
$pdf->Cell(10,5," ",'0' ,'0','L','0');
$pdf->Cell(90,5,"Steuer ",'LTR','1','L','1'); //blau
$pdf->Cell(90,2," ",'LTR','0','L','0'); //frei aber rand
$pdf->Cell(10,2," ",'0' ,'0','L','0');
$pdf->Cell(90,2," ",'LTR','1','L','0');
//MA-Daten
$pdf->SetTextColor(0,0,0);
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"Familienstand:",'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,utf8_decode($ma['famstand']),'R','0','L','0');
$pdf->Cell(10,5," ",'0' ,'0','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"Steuer-ID:",'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(30,5,($ma['steuerid']),'0','0','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(20,5,"Steuerkl:",'0','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(10,5,($ma['steuerkl']),'R','1','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"Anzahl Kinder:",'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,utf8_decode($ma['kinder']),'R','0','L','0');
$pdf->Cell(10,5," ",'0' ,'0','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"Konfession:",'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,($ko['abk']." - ".$ko['bezeichnung']),'R','1','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,("Kinderfreibetrag:"),'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,($ma['kinderfb']),'R','0','L','0');
$pdf->Cell(10,5," ",'0' ,'0','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"Sozialvers. Nr.:",'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,($ma['svnummer']),'R','1','L','0');
$pdf->Cell(90,5," ",'T','0'); $pdf->Cell(10,5," ",'0','0'); $pdf->Cell(90,5," ",'T','1');
//------------------------------------------------------------------------------------------------------------------
//---------------------------------------------------------------------------------------------------
$pdf->SetTextColor(255,255,255); $pdf->SetFont('Helvetica','B',6);
$pdf->Cell(90,5,utf8_decode("Sonderfälle "),'LTR','0','L','1'); //blau
$pdf->Cell(10,5," ",'0' ,'0','L','0');
$pdf->Cell(90,5,utf8_decode("Führerschein"),'LTR','1','L','1'); //blau
$pdf->Cell(90,2," ",'LTR','0','L','0'); //frei aber rand
$pdf->Cell(10,2," ",'0' ,'0','L','0');
$pdf->Cell(90,2," ",'LTR','1','L','0');
//MA-Daten
$pdf->SetTextColor(0,0,0);
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"Rentner:",'L','0','L','0');
if($ma['rentner']>0) { $pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,utf8_decode("ja ".$ma['rentnerinfo']),'R','0','L','0');
} else { $pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,"nein",'R','0','L','0'); }
$pdf->Cell(10,5," ",'0' ,'0','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,utf8_decode("Führerschein:"),'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,($ma['fschein']),'R','1','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"schwerbehindert:",'L','0','L','0');
if($ma['sbehind']>0) { $pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,utf8_decode("ja ".$ma['sbehind2']),'R','0','L','0');
} else { $pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,"nein",'R','0','L','0'); }
$pdf->Cell(10,5," ",'0' ,'0','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"Ablauffrist:",'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,($ma['ffrist']),'R','1','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,("Student:"),'L','0','L','0');
if($ma['student']>0) { $pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,utf8_decode("ja ".$ma['studentinfo']),'R','0','L','0');
} else { $pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,"nein",'R','0','L','0'); }
$pdf->Cell(10,5," ",'0' ,'0','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"Fahrerkarte LKW.:",'L','0','L','0');
if($ma['fkarte']>0) { $pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,"ja",'R','0','L','0');
} else { $pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,"nein",'R','1','L','0'); }
$pdf->Cell(90,5," ",'T','0'); $pdf->Cell(10,5," ",'0','0'); $pdf->Cell(90,5," ",'T','1');
//------------------------------------------------------------------------------------------------------------------
//---------------------------------------------------------------------------------------------------
$pdf->SetTextColor(255,255,255); $pdf->SetFont('Helvetica','B',6);
$pdf->Cell(90,5,"Krankenkasse ",'LTR','0','L','1'); //blau
$pdf->Cell(10,5," ",'0' ,'0','L','0');
$pdf->Cell(90,5,"Laufbahn ",'LTR','1','L','1'); //blau
$pdf->Cell(90,2," ",'LTR','0','L','0'); //frei aber rand
$pdf->Cell(10,2," ",'0' ,'0','L','0');
$pdf->Cell(90,2," ",'LTR','1','L','0');
//MA-Daten
$pdf->SetTextColor(0,0,0);
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"Krankenkasse:",'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,utf8_decode($ma['kkasse']),'R','0','L','0');
$pdf->Cell(10,5," ",'0' ,'0','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"Eintrittstag:",'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,utf8_decode($ma['eintag'].".".$ma['einmonat'].".".$ma['einjahr']),'R','1','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"Mitg.-Nr.:",'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,utf8_decode($ma['kkassennr']),'R','0','L','0');
$pdf->Cell(10,5," ",'0' ,'0','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"Austrittstag:",'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,utf8_decode($ma['austag'].".".$ma['ausmonat'].".".$ma['ausjahr']),'R','1','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,("fam.mitversichert:"),'L','0','L','0');
if($ma['famversichert']>0) { $pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,"ja",'R','0','L','0');
} else { $pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,"nein",'R','0','L','0'); }
$pdf->Cell(10,5," ",'0' ,'0','L','0');
$pdf->SetFont('Helvetica','', 8); $pdf->Cell(30,5,"befristet bis:",'L','0','L','0');
$pdf->SetFont('Helvetica','B',10); $pdf->Cell(60,5,utf8_decode($ma['beftag'].".".$ma['befmonat'].".".$ma['befjahr']),'R','1','L','0');
$pdf->Cell(90,5," ",'T','0'); $pdf->Cell(10,5," ",'0','0'); $pdf->Cell(90,5," ",'T','1');
//------------------------------------------------------------------------------------------------------------------
$pdf->Output('Personalbogen_'.($ma['name']).'.pdf','I');
?>
Reference in a new issue View git blame Copy permalink