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

174 lines
No EOL
6.8 KiB
PHP
Raw Permalink Blame History

<?php
require('fpdf.php');
error_reporting(1);
$monat = (int)date('n');
$jahr = (int)date('Y');
$kw_aktuell = (int)date('W');
if(isset($_POST['save'])) {
if($_POST['ma5']=="0147025803") { //passwort
$maid=$_POST['ma1'];
$row_fahrerx = $GLOBALS['mysql']->query_single("SELECT * FROM firmen WHERE id='".$_POST['ma1']."'");
$a_name=$row_fahrerx['name'];
$a_monat=$_POST['ma2'];
$a_jahr=$_POST['ma3'];
//--------------------------------
//-------------------- pdf starten
//--------------------------------
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 ©2012','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->Image('Image5.png', 0, 5,230,30);
$pdf->Write(20,"\n\n");
$pdf->SetFont('Helvetica','BU',7); $pdf->SetTextColor(0,0,0); $pdf->SetFillColor(255,255,255);
$pdf->Cell(110,3,"JB-Transport - Bautzner Str. 76 - 04347 Leipzig",'0','1','L','1');
$pdf->SetFont('');
$pdf->Cell(110,3," ",'0','1','L','1');
$adr = $GLOBALS['mysql']->query_single("SELECT * FROM firmen WHERE id='".$_POST['ma1']."'");
$pdf->SetFont('Helvetica','B',10); $pdf->SetTextColor(0,0,0); $pdf->SetFillColor(255,255,255);
$pdf->Cell(110,5,($adr['a1']),'0','1','L','0');
$pdf->Cell(110,5,($adr['a2']),'0','1','L','0');
$pdf->Cell(110,5,($adr['a3']),'0','1','L','0');
$pdf->Cell(110,5,($adr['a4']),'0','1','L','1');
$pdf->Write(8,"\n");
$pdf->SetFont('Helvetica','BI',20);
$pdf->Cell(110,8,"Monatsansicht ".($a_monat)."/".($a_jahr),'0','1','L','1');
$pdf->SetFont('');
$pdf->Write(4,"\n");
$pdf->SetFont('Helvetica','B',10);
$pdf->Cell(25,5,"Tour",'B','0','L','1');
$pdf->Cell(90,5,"Bezeichnung",'B','0','L','1');
$pdf->Cell(20,5,"Anzahl",'B','0','R','1');
$pdf->Cell(30,5,"E.-Preis",'B','0','R','1');
$pdf->Cell(30,5,"G.-Preis",'B','1','R','1');
$pdf->Write(2,"\n");
//--------------- neu 1. touren auslesen zu arbeitgeber , danach mit option die tourenliste
$keyfirma=0; $keytour=0; $firmapreis=0; $tourmenge=0;
$firmatouren = $GLOBALS['mysql']->query("SELECT * FROM touren WHERE afirma='".$_POST['ma1']."' ORDER BY typ");
while($rowfirma = $firmatouren->fetch_assoc()) {
$tour1[$keytour]['id']=$rowfirma['id'];
$tour1[$keytour]['tour']=$rowfirma['tour'];
$tour1[$keytour]['retyp']=$rowfirma['retyp'];
$tour1[$keytour]['infotitel']=$rowfirma['infotitel'];
$tour1[$keytour]['preis']=$rowfirma['preis'];
$keytour++;
}
for($key = 0; $key < $keytour; $key++) {
$tourx = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE monat='".$_POST['ma2']."' AND jahr='".$_POST['ma3']."' AND tour='".$tour1[$key]['id']."' ") ;
while($row2 = $tourx->fetch_assoc()) {
if($tour1[$key]['retyp']==5) {
$tourmenge=$tourmenge+$row2['exemplare'];
$tmppreis=$tour1[$key]['preis']*$row2['exemplare'];
$tourpreis=$tourpreis+$tmppreis;
$firmapreis=$firmapreis+$tmppreis;
}
elseif($tour1[$key]['retyp']==4) {
$tourmenge++;
if ($tourmenge==1) {
$tourpreis=$tourpreis+$tour1[$key]['preis'];
$firmapreis=$firmapreis+$tour1[$key]['preis'];
}
} else {
$tourmenge++;
$tourpreis=$tourpreis+$tour1[$key]['preis'];
$firmapreis=$firmapreis+$tour1[$key]['preis'];
}
}
if($tourmenge>0) {
$pdf->SetFont('Courier','B',10); $pdf->SetFont('');
$pdf->Cell(25,4,($tour1[$key]['tour']),'0','0','L','1');
$pdf->Cell(90,4,($tour1[$key]['infotitel']),'0','0','L','1');
if($tour1[$key]['retyp']==4) {
$pdf->Cell(20,4," ",'0','0','R','1');
$pdf->Cell(30,4," ",'0','0','R','1');
} else {
$pdf->Cell(20,4,($tourmenge)." x",'0','0','R','1');
$pdf->Cell(30,4,"a. ".(sprintf("%01.2f",$tour1[$key]['preis']))." Euro",'0','0','R','1');
}
$pdf->Cell(30,4,(sprintf("%01.2f",$tourpreis))." Euro",'0','1','R','1');
}
$tourpreis=0; $tourmenge=0;
}
//gesamtsumme
// $pdf->Cell(25,8," ",'0','1','R','1');
$pdf->Cell(195,4," ",'0','1','R','1');
$pdf->Cell(195,4,"------------",'0','1','R','1');
$pdf->Cell(108,4," ",'0','0','L','1');
$pdf->Cell(50,4,"Zwischensumme:",'0','0','R','1');
$pdf->Cell(37,4,(sprintf("%01.2f",$firmapreis))." Euro",'0','1','R','1');
$steuer=$firmapreis*19/100;
$pdf->Cell(108,4," ",'0','0','L','1');
$pdf->Cell(50,4,"+19% MwSt.",'0','0','R','1');
$pdf->Cell(37,4,(sprintf("%01.2f",$steuer))." Euro",'0','1','R','1');
$betrag=$firmapreis+$steuer;
$pdf->Cell(108,4," ",'0','0','L','1');
$pdf->Cell(50,4,"Gesamtbetrag:",'0','0','R','1');
$pdf->Cell(37,4,(sprintf("%01.2f",$betrag))." Euro",'0','1','R','1');
if($betrag>9999) {
$pdf->Cell(195,4,"===========",'0','1','R','1');
} else {
$pdf->Cell(195,4,"============",'0','1','R','1');
}
//---------
$pdf->Output('rechnung_'.($datum).'.pdf','I');
exit();
} else {
$template->assign('error', "falsches Passwort");
$ma1 = $GLOBALS['mysql']->query_array("SELECT * FROM firmen ORDER BY name");
$ma2['id']= array(1,2,3,4,5,6,7,8,9,10,11,12);
$ma2['name']=array("Januar","Februar","M&auml;rz","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember");
$ma2['monat']=$monat;
$ma3['id']= array(2012,2013,2014,2015,2016,2017,2018,2019,2020);
$ma3['name']=array(2012,2013,2014,2015,2016,2017,2018,2019,2020);
$ma3['jahr']=$jahr;
$template->assign('ma1', $ma1);
$template->assign('ma2', $ma2);
$template->assign('ma3', $ma3);
$template->assign('a_name', $a_name);
$template->assign('a_monat', $a_monat);
$template->assign('a_jahr', $a_jahr);
$template->assign('content', 'tpl/a_firma1.tpl'); //_list
}
} else {
$ma1 = $GLOBALS['mysql']->query_array("SELECT * FROM firmen ORDER BY name");
$ma2['id']= array(1,2,3,4,5,6,7,8,9,10,11,12);
$ma2['name']=array("Januar","Februar","M&auml;rz","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember");
$ma2['monat']=$monat;
$ma3['id']= array(2012,2013,2014,2015,2016,2017,2018,2019,2020);
$ma3['name']=array(2012,2013,2014,2015,2016,2017,2018,2019,2020);
$ma3['jahr']=$jahr;
$template->assign('ma1', $ma1);
$template->assign('ma2', $ma2);
$template->assign('ma3', $ma3);
$template->assign('a_name', $a_name);
$template->assign('a_monat', $a_monat);
$template->assign('a_jahr', $a_jahr);
$template->assign('content', 'tpl/a_firma1.tpl'); //_list
}
?>
Reference in a new issue View git blame Copy permalink