71 lines
2.2 KiB
PHP
71 lines
2.2 KiB
PHP
<?php
|
|
error_reporting(E_ALL);
|
|
require_once("../config.inc.php");
|
|
require('../fpdf186/fpdf.php');
|
|
require_once('../fpdf186/FPDI-master/src/autoload.php');
|
|
use setasign\Fpdi\Fpdi;
|
|
$pdf = new FPDI('P','mm','A4');
|
|
$pdf->SetAutoPageBreak(false);
|
|
$art = $_GET['art'];
|
|
|
|
# Notenbuch =B
|
|
# Einzelnoten = E
|
|
if($art == 'B'){
|
|
$zsid = $_GET['zsid'];
|
|
$query = "SELECT liednr, filename, titel
|
|
FROM jumi_noten_daten a, jumi_noten_uploads b, jumi_noten_zusammenstellung_zuord c
|
|
WHERE b.jndid=c.jndid
|
|
AND a.jndid=b.jndid
|
|
AND c.zsid=$zsid
|
|
AND lower(filename) LIKE '%.pdf'
|
|
ORDER BY CAST(liednr AS UNSIGNED), liednr";
|
|
$result = $db->query ($query)
|
|
or die ("Cannot execute query");
|
|
$query_titel = $db->query ("SELECT bezeichnung
|
|
FROM jumi_noten_zusammenstellung
|
|
WHERE zsid =$zsid");
|
|
$row_titel = $query_titel->fetch_array();
|
|
}
|
|
if($art == 'E'){
|
|
$jndid = $_GET['jndid'];
|
|
$query = "SELECT liednr, filename, titel
|
|
FROM jumi_noten_daten a, jumi_noten_uploads b
|
|
WHERE a.jndid=b.jndid
|
|
AND a.jndid=$jndid
|
|
AND lower(filename) LIKE '%.pdf'
|
|
ORDER BY CAST(liednr AS UNSIGNED), liednr
|
|
LIMIT 1";
|
|
$result = $db->query ($query)
|
|
or die ("Cannot execute query");
|
|
$query_titel = $db->query ("SELECT titel bezeichnung
|
|
FROM jumi_noten_daten
|
|
WHERE jndid =$jndid");
|
|
$row_titel = $query_titel->fetch_array();
|
|
}
|
|
|
|
while ($row = $result->fetch_array()){
|
|
|
|
$pages_count = $pdf->setSourceFile("$row[filename]");
|
|
|
|
for($i = 1; $i <= $pages_count; $i++)
|
|
{
|
|
$pdf->AddPage();
|
|
|
|
$tplIdx = $pdf->importPage($i);
|
|
|
|
$pdf->useTemplate($tplIdx, 0, 0);
|
|
|
|
if($i == 1){
|
|
$pdf->SetFont('Arial','B',26);
|
|
$pdf->SetY(3);
|
|
$pdf->Cell( 0, 10, "$row[liednr]", 0, 0, 'R' );
|
|
}
|
|
$pdf->SetFont('Arial','B',10);
|
|
$pdf->SetY(-5);
|
|
$pdf->Cell( 0, 0, "- ".utf8_decode($row['titel'])." ($i/$pages_count) -", 0, 0, 'C' );
|
|
#$pdf->Write(0, "$i");
|
|
}
|
|
}
|
|
|
|
$pdf->Output('I',utf8_decode($row_titel['bezeichnung']));
|
|
?>
|