exportRundenzeiten.php

<?php

require('Classes/fpdf/fpdf.php');
include("function.php");
$link = connectDB();
session_start();

$_GET = filterParameters($_GET);
$_POST = filterParameters($_POST);

class PDF extends FPDF
{
	function exportRundenzeiten($id) {

		$numBefore = 0;
		$fill = false;
		$linesPerPage = 45;
		$pageheader = $this->getHeader($_SESSION['vID'], $id);

		$rd = getRennenData($id);
		$startZeit = $rd['startZeit'];
		
		
		$this->setHeader($pageheader);
		$this->setMyFont();

		if($rd['use_lID'] == 1) {
			$sql_lID = " and z.lID = $id";
		} else { $sql_lID = "";
		}
		
		
		$sql = "SELECT stnr, nachname, vorname, verein from teilnehmer where vID = ".$_SESSION['vID']." and lID = $id and platz <> 0";
		$result = dbRequest($sql, 'SELECT');

		if($result[1] > 0) {
			foreach ($result[0] as $row) {
				// Fuer Folgeseiten neue Seite samt Header anfangen, auf erster nicht
				if(isset($r)){
					$this->AddPage();
					$this->setHeader($pageheader);
					$this->setMyFont();
				}
				if($row['nachname'].$row['vorname'] != "") { $team = "  |  ".htmlspecialchars_decode(utf8_decode($row['nachname']), ENT_QUOTES).", ".htmlspecialchars_decode(utf8_decode($row['vorname']), ENT_QUOTES)." - ".htmlspecialchars_decode(utf8_decode($row['verein']), ENT_QUOTES); }
				$header = "StNr: ".$row['stnr']." ".$team;
				$this->setGroupHeader($header);
				$r = 1;
				$fill=false;
				$zeitBefore = $startZeit;
	
				$sql2 = "select zeit from zeit z where zeit > '".$startZeit."' and vID = ".$_SESSION['vID']." $sql_lID and nummer = '".$row['stnr']."' order by zeit asc";
				$result2 = dbRequest($sql2, 'SELECT');
				
				if($result2[1] > 0) {
					foreach ($result2[0] as $row2) {
		
						$rundenzeit = getRealTime($zeitBefore, $row2['zeit']);
							
						$this->Cell(15,5,$r,0,0,'R',$fill);
						$this->Cell(20,5,substr($row2['zeit'],10),0,0,'R',$fill);
						$this->Cell(25,5,$rundenzeit,0,0,'R',$fill);
						$this->Ln();
						$fill=!$fill;
						$zeitBefore = $row2['zeit'];
						$r++;
					}
				}
			}
		}
		
	}

	function setGroupHeader($header) {
		$this->Ln(5);
		$this->SetFillColor(220,220,220);
		$this->Cell(120,5,$header,'',0,'L',1);
		$this->Ln();
		
		$this->Cell(15,5,"Runde",'B',0,'R',1);
		$this->Cell(20,5,"Uhrzeit",'B',0,'R',1);
		$this->Cell(25,5,"Rundenzeit",'B',0,'R',1);
		$this->Cell(60,5,"",'B',0,'R',1);
		$this->Ln();
		$this->SetFillColor(224,235,255);
	}

	function setMyFont() {
		$this->SetTextColor(0);
		$this->SetFont('Arial','',10);
		//$this->SetDrawColor(0,0,0);
		//$this->SetLineWidth(.5);
	}

	function getHeader($veranstaltung, $rennen) {
		$sql = "select titel, untertitel, datum from veranstaltung where id = $veranstaltung";
		$result = dbRequest($sql, 'SELECT');

		if($result[1] > 0) {
			foreach ($result[0] as $row) {
				$header['titel'] 		= htmlspecialchars_decode($row['titel'], ENT_QUOTES);
				$header['untertitel'] 	= htmlspecialchars_decode($row['untertitel'], ENT_QUOTES);
				$header['datum'] 		= htmlspecialchars_decode($row['datum'], ENT_QUOTES);
			}
		}

		$sql = "select titel, untertitel from lauf where id = $rennen";
		$result = dbRequest($sql, 'SELECT');

		if($result[1] > 0) {
			foreach ($result[0] as $row) {
				$header['lauf'] 		= htmlspecialchars_decode($row['titel'], ENT_QUOTES);
				$header['lauf2'] 		= htmlspecialchars_decode($row['untertitel'], ENT_QUOTES);
			}
		}

		return $header;
	}

	function setHeader($header) {
		$this->SetTextColor(0);
		$this->SetY(1);
		$this->SetFont('Arial','',10);
		$this->Ln(5);
		$this->Cell(160);
		$d = explode("-",$header['datum']);
		$this->Cell(30,10,$d[2].".".$d[1].".".$d[0],0,0,'R');
		$this->Ln(5);

		$this->SetFont('Arial','BI',16);
		$this->Cell(80);
		$this->Cell(30,10,utf8_decode($header['titel']),0,0,'C');
		if($header['untertitel'] != "") {
			$this->SetFont('Arial','BI',12);
			$this->Ln(5);
			$this->Cell(80);
			$this->Cell(30,10,utf8_decode($header['untertitel']),0,0,'C');
		}

		$this->Ln(5);
		$this->SetFont('Arial','BI',10);
		$this->Cell(80);
		$this->Cell(30,10,utf8_decode($header['lauf']),0,0,'C');
		$this->Ln(5);
		$this->Cell(80);
		$this->Cell(30,10,utf8_decode($header['lauf2']),0,0,'C');
		$this->Ln(5);
	}

	function Footer() {
		$this->SetY(-15);
		$this->SetFont('Arial','I',8);
		$this->Cell(0,10,'Page '.$this->PageNo().'/{nb}',0,0,'C');
	}

}


//$filename = $_GET['action'].'.pdf';
$filename = 'Rundenzeiten.pdf';

$pdf=new PDF();
$pdf->AliasNbPages();
$pdf->AddPage('Portrait', 'A4');
$pdf->exportRundenzeiten($_GET['id']);

$pdf->Output($filename,"I");

$pdf->Output();
$link->close();
?>