"; print_r($saso_tour); echo ""; //---------------------------- class PDF extends FPDF { function Header() { $isodate = sprintf("%02d", $_GET['kw']); $temp = strtotime("{$_GET['jahr']}-W{$isodate}-7"); $stag=(int)date('d', $temp); $smonat=(int)date('m', $temp); $sjahr=(int)date('y', $temp); $sasodatum=$stag.".".$smonat.".".$sjahr; // $this->SetY(-15); $row_tour = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$_GET['tour']."'"); $tour_info = $GLOBALS['mysql']->query_single("SELECT * FROM tourenplan WHERE tag='".$stag."' and monat='".$smonat."' and jahr='".$sjahr."' and tour='".$_GET['tour']."'"); $this->Image('template/images/saso.png',70, 5); $this->Image('template/images/jb_logo2.png', 125, 7); $this->SetFont('Helvetica','B',32); $this->Cell(24,8,($row_tour['tour']),'0','1','L','0'); $this->SetFont('Helvetica','B',16); $this->Cell(24,8,($stag.".".$smonat.".20".$sjahr." - Norm: ".$tour_info['norm']),'0','0','L','0'); // tour_info $this->Write(20,"\n"); } function Footer() { $this->SetY(-15); $this->SetFont('Helvetica','I',8); $this->Cell(190,5,'Zustellservice Heinicke GmbH - Handelsplatz 4 - 04319 Leipzig *** ZSH - interne Liste - Nach Gebrauch vernichten *** F. T.2014','1','0','C','0'); } } $pdf = new PDF('P','mm','A4'); $pdf->AddPage(); // blau (0,160,230) // Orange (240,150, 0) // grau (200,200,200) //---------- Kopf --------------------- //$pdf->SetFont('Helvetica','B',20); // $pdf->SetTextColor(0,160,230); // $pdf->SetFillColor(240,150,0); // $pdf->Cell(24,8,($kw_aktuell).".KW",'1','0','L','1'); // $pdf->Write(8,"\n"); // $pdf->SetFont('Helvetica','BI',16); // $pdf->SetFillColor(0,0,140); // $pdf->SetTextColor(240,150,0); //$pdf->Cell(110,8,"Sachsen-Sonntag",'1','0','C','1'); $pdf->SetFillColor(80,80,80); $pdf->SetTextColor(255,255,255); $pdf->SetFont('Helvetica','B',10); $pdf->Cell(120,6,("Anlieferung / Adresse"),'0','0','L','1'); $pdf->Cell(60,6,("Vollpakete-Spitze / Typ"),'0','1','R','1'); $pdf->Cell(60,2,(" "),'0','1','R','0'); $key=0; $abl=0; $saso_tour = $GLOBALS['mysql']->query("SELECT * FROM tourenplan WHERE tag='".$stag."' and monat='".$smonat."' and jahr='".$sjahr."' and tour='".$_GET['tour']."'"); while($row = $saso_tour->fetch_assoc()) { //echo "
";       print_r($row);       echo "
"; $pdf->SetFont('Helvetica','B',14); $pdf->SetTextColor(0,0,0); $pdf->SetFillColor(255,255,255); $vp=floor($row['exemplare']/$row['norm']); $spitze=$row['exemplare']-($vp*$row['norm']); $pdf->SetFont('Helvetica','B',14); $pdf->Cell(120,6,($row['adresse']),'0','0','L','1'); $pdf->Cell(45,6,($vp." -"),'0','0','R','1'); $pdf->Cell(7,6,($spitze),'0','0','R','1'); $pdf->Cell(8,6,($row['typ']),'0','1','R','1'); $pdf->SetFont('Helvetica','B',10); $pdf->Cell(120,6,($row['info']),'B','0','L','1'); $pdf->SetFont('Helvetica','',10); $pdf->Cell(60,6,("Bereich: ".$row['bereich']),'B','1','R','1'); $pdf->Cell(24,2,' ','0','1','L','0'); $key++; } $pdf->Output('Einsatzplan_Nachts_'.($vdatum).'.pdf','I'); ?>