90 lines
2.5 KiB
PHP
Executable File
90 lines
2.5 KiB
PHP
Executable File
<?php
|
|
|
|
include("kurs/datenbankanbindung.php"); // fügt die Datenbankanbindung ein: Sys:\php\includes\kurs\datenbankanbindung.php
|
|
|
|
$uid1=$_COOKIE["uid1"];
|
|
|
|
|
|
|
|
|
|
|
|
error_reporting (E_ALL);
|
|
|
|
|
|
|
|
define('FPDF_FONTPATH','font/');
|
|
|
|
require('as_utf_class.php');
|
|
|
|
|
|
|
|
$pdf= new utfFPDF();
|
|
|
|
|
|
|
|
|
|
|
|
$pagecount = $pdf->setSourceFile("praxisstellen.pdf");
|
|
|
|
|
|
|
|
$tplidx = $pdf->ImportPage(1);
|
|
|
|
|
|
|
|
$db = dbconnect();
|
|
|
|
|
|
|
|
$res = $db->query("SELECT mtknr, nachname, vorname, postrasse, poort, poplz FROM stud WHERE uid='$uid1'");
|
|
|
|
$row = $res->fetch_array();
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$pdf->addPage();
|
|
|
|
$pdf->useTemplate($tplidx,0,0,0);
|
|
|
|
$pdf->SetFont('Arial', '', 11);
|
|
|
|
$pdf->SetY(26);
|
|
|
|
$pdf->SetX(24);
|
|
|
|
$pdf->Cell(0, 3, "Matrikelnr.: $row[mtknr]" , 0, 0, 'L');
|
|
|
|
|
|
|
|
|
|
|
|
$pdf->SetFont('Arial', '', 7);
|
|
|
|
$pdf->SetY(52);
|
|
|
|
$pdf->SetX(24);
|
|
|
|
$pdf->Cell(0, 3, "$row[vorname] $row[nachname] - $row[postrasse] - $row[poplz] $row[poort]", 0, 0, 'L');
|
|
|
|
|
|
|
|
|
|
|
|
$pdf->SetLineWidth(0.2);
|
|
|
|
|
|
|
|
// Linie zeichnen
|
|
|
|
$pdf->Line(23, 55, 100, 55);
|
|
|
|
|
|
|
|
|
|
|
|
$query = "SELECT bezeichnung, bereich, str, plz, ort, sachbereich, DATE_FORMAT(beginn, '%d.%m.%Y') beginn, DATE_FORMAT(beginn, '%Y%m%d') beginnform, DATE_FORMAT(ende, '%d.%m.%Y') ende
|
|
|
|
FROM stan_antrag t1
|
|
|
|
WHERE t1.status = (
|
|
|
|
SELECT MAX(t2.status)
|
|
|
|
FROM stan_antrag t2
|
|
|
|
WHERE t1.aendid = t2.aendid
|
|
|
|
)
|
|
|
|
AND t1.uid = '$uid1'
|
|
|
|
AND (t1.zuweisung is NULL OR t1.zuweisung='Z')
|
|
|
|
ORDER BY beginnform";
|
|
|
|
|
|
|
|
$result = $db->query ($query)
|
|
|
|
or die ("Cannot execute query");
|
|
|
|
$ln_Y = 128;
|
|
|
|
while ($row1 = $result->fetch_array()){
|
|
|
|
|
|
|
|
$res2 = $db->query("SELECT bezeichnung FROM stan_stellenbereiche WHERE sbid='$row1[sachbereich]'");
|
|
|
|
$row2 = $res2->fetch_array();
|
|
|
|
|
|
|
|
$pdf->SetY($ln_Y);
|
|
|
|
$pdf->SetX(30);
|
|
|
|
$pdf->SetFont('Arial', '', 10);
|
|
|
|
$pdf->MultiCell(38, 3,"$row1[bezeichnung]\n$row1[str]\n$row1[plz] $row1[ort]", 0, 'L');
|
|
|
|
|
|
|
|
$pdf->SetY($ln_Y);
|
|
|
|
$pdf->SetX(70);
|
|
|
|
$pdf->SetFont('Arial', '', 10);
|
|
|
|
$pdf->MultiCell(39, 4,"$row1[bereich]", 0, 'L');
|
|
|
|
|
|
|
|
$pdf->SetY($ln_Y);
|
|
|
|
$pdf->SetX(110);
|
|
|
|
$pdf->SetFont('Arial', '', 10);
|
|
|
|
$pdf->MultiCell(39, 4,"$row2[bezeichnung]", 0, 'L');
|
|
|
|
|
|
|
|
$pdf->SetY($ln_Y);
|
|
|
|
$pdf->SetX(150);
|
|
|
|
$pdf->SetFont('Arial', '', 10);
|
|
|
|
$pdf->MultiCell(39, 4,"$row1[beginn] - $row1[ende]", 0, 'L');
|
|
|
|
|
|
|
|
$ln_Y = $ln_Y + '20'; // 20mm nach unten verschieben bei jedem durchlauf
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
$pdf->Output("newpdf.pdf","i");
|
|
|
|
$pdf->closeParsers();
|
|
|
|
?>
|