aschwarz/dvm
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
dvm/admin/liste_tn.php
aschwarz e552a15912 Server geändert
2023-04-25 13:15:15 +02:00

262 lines
7.1 KiB
PHP
Executable File
Raw Permalink Blame History

<?php
session_start();
include_once '../classes/TestProjektSmarty.class_subdir.php';
require_once("../config.inc.php");
$templatename = substr(basename($_SERVER['PHP_SELF']),0,-3)."html";
$smarty = new SmartyAdmin();
require_once "../language/german.inc.php";
if (isset($_GET['action'])) {
$action = $_GET['action'];
} else {
$action = '';
}
if ($action == '') {
$german = $db->query("SET lc_time_names = 'de_DE';");
$query1 = "SELECT a.tm_id, date_format(tm_datum, '%a, %d.%m.%Y - %H:%i Uhr')tm_datum_form, tm_standort
FROM dvm_termine a, dvm_term_kand b
WHERE a.tm_id=b.tm_id
AND a.tm_datum > ADDDATE(now(), -7)
GROUP BY a.tm_id, tm_datum_form, tm_standort
ORDER BY tm_datum ASC";
$result1 = $db->query($query1) or die("Cannot execute query1");
while ($row1 = $result1->fetch_array()) {
if($row1['tm_standort'] == 'L'){
$standort = 'Ludwigsburg';
}
if($row1['tm_standort'] == 'K'){
$standort = 'Kehl';
}
$row1['tm_standort'] = $standort;
$table_data1[] = $row1;
}
$smarty->assign('table_data1', $table_data1);
}
if ($action == 'ausgabe') {
$testtermin = $_POST["testtermin"];
$german = $db->query("SET lc_time_names = 'de_DE';");
$query_termin = $db->query("SELECT date_format(tm_datum, '%a, %d.%m.%Y - %H:%i Uhr')tm_datum_form, tm_standort
FROM dvm_termine
WHERE tm_id = $testtermin");
$row_get_termin = $query_termin->fetch_array();
if($row_get_termin['tm_standort'] == 'L'){
$standort = 'Ludwigsburg';
}
if($row_get_termin['tm_standort'] == 'K'){
$standort = 'Kehl';
}
$buffer = '<page backtop="7mm" backbottom="10mm" style="font-size: 11pt">';
$buffer .= "<style type='text/css'>
.td1 { border:0.3px solid black; }
.td_foot { border: none; }
body { font-size: 14px; }
h1 { font-size: 22px; }
table { font-size: 12px; }
td{padding: 3px;}
table.page_footer {width: 100%; border: none; padding: 20mm}
.fcol{color: #0C25BF;}
.td2 { border:0.3px solid black;
height:1.0cm;
}
</style>";
$buffer.="<h1><p align='center'>$row_get_termin[tm_datum_form], $standort</p></h1>
<table cellspacing='0' cellpadding='0' border='0.3'>
<thead>
<tr>
<td class='td1' width='180'>
<b>Name</b>
</td>
<td class='td1' width='80'>
<b>Geburtstag</b>
</td>
<td class='td1' width='80'>
<b>Minderjährig</b>
</td>
<td class='td1' width='100'>
<b>ID</b>
</td>
<td class='td1' width='140'>
<b>Mail</b>
</td>
<td class='td1' width='60'>
<b>TAN</b>
</td>
<td class='td1' width='100'>
<b>Link</b>
</td>
</tr>
</thead>";
$query1 = "SELECT anrede, perso, vorname, nachname, str, plz, ort, alter18, id, date_format(gebdat,'%d.%m.%Y') gebdat_form, tan, tinyurl, mail
FROM dvm_term_kand a, dvm_tanpool b, dvm_kandidat c
WHERE a.tp_id= b.tp_id
AND a.ka_id = c.ka_id
AND a.tm_id = $testtermin
ORDER BY nachname, vorname
";
$result1 = $db->query($query1) or die("Cannot execute query1");
$smarty->assign('termine_aktdat', date("d.m.Y H:i", time() ) ) ;
while ($row1 = $result1->fetch_array()) {
if($row1['alter18'] == 0){
$minderj = 'ja';
}
if($row1['alter18'] == 1){
$minderj = 'nein';
}
if($row1['perso'] != ''){
$ausweis = "<br>Ausweis: $row1[perso]";
}else{
$ausweis = "";
}
$buffer.="
<tr>
<td class='td1' width='180'>
$row1[nachname], $row1[vorname] ($row1[anrede])<br>
$row1[str]<br>
$row1[plz] $row1[ort]
$ausweis
</td>
<td class='td1' width='80'>
$row1[gebdat_form]
</td>
<td class='td1' width='80'>
$minderj
</td>
<td class='td1' width='100'>
$row1[id]
</td>
<td class='td1' width='140'>
$row1[mail]
</td>
<td class='td1' width='60'>
$row1[tan]
</td>
<td class='td1' width='100'>
$row1[tinyurl]
</td>
</tr>";
}
$buffer.="
</table>
</page>";
require_once("../mpdf/vendor/autoload.php");
$mpdf = new \Mpdf\Mpdf([
'mode' => 'utf-8',
'format' => 'A4',
'orientation' => 'P',
'margin_top' => 10,
'margin_bottom' => 10,
'margin_left' => 10,
'margin_right' => 16,
'default_font' => 'arial'
]);
$query2 = "SELECT anrede, vorname, nachname, str, plz, ort, alter18, id, date_format(gebdat,'%d.%m.%Y') gebdat_form, tan, tinyurl, mail, hochschule
FROM dvm_term_kand a, dvm_tanpool b, dvm_kandidat c
WHERE a.tp_id= b.tp_id
AND a.ka_id = c.ka_id
AND a.tm_id = $testtermin
ORDER BY nachname, vorname
";
$result2 = $db->query($query2) or die("Cannot execute query2");
$smarty->assign('termine_aktdat', date("d.m.Y H:i", time() ) ) ;
while ($row2 = $result2->fetch_array()) {
if($row2['alter18'] == 0){
$minderj = 'ja';
}
if($row2['alter18'] == 1){
$minderj = 'nein';
}
if($row2['hochschule'] == 'Ludwigsburg'){
$link = "https://www.hs-ludwigsburg.de/studium/digitales-verwaltungsmanagement-ba/bewerbung-zugang.html";
}
if($row2['hochschule'] == 'Kehl'){
$link = "https://www.hs-kehl.de/studieninteressierte/bachelor-studiengaenge/digitales-verwaltungsmanagement-ba/bewerbung/";
}
if($row2['hochschule'] == 'NA'){
$link = "https://www.hs-kehl.de/studieninteressierte/bachelor-studiengaenge/digitales-verwaltungsmanagement-ba/bewerbung/ bzw.<br>https://www.hs-ludwigsburg.de/studium/digitales-verwaltungsmanagement-ba/bewerbung-zugang.html";
}
$buffer.="
<pagebreak>
<page backtop='7mm' backbottom='10mm' style='font-size: 11pt'>
<h1>Anmeldedaten für $row2[vorname] $row2[nachname] ($row2[gebdat_form])</h1>
<br><br>
Bitte bewahren Sie die nachfolgenden Anmeldedaten für das gesamte Bewerbungsverfahren auf.
<br>
<br>
<table cellspacing='0' cellpadding='0' border='0.3'>
<thead>
<tr>
<td class='td2' width='350'>
<b>Persönliche ID</b>
</td>
<td class='td2' width='350'>
<b>Passwort/TAN</b>
</td>
</tr>
</thead>
<tr>
<td class='td2'>
$row2[id]
</td>
<td class='td2'>
$row2[tan]
</td>
</tr>
</table>
<br>
<br>
Weiterf&uuml;hrende Links:
<table cellspacing='0' cellpadding='0' border='0.3'>
<tr>
<td class='td2' width='150'>
<b>Weitere Informationen: </b>
</td>
<td class='td2' width='550'>
$link
</td>
</tr>
</table>
</page>";
}
#$mpdf->setFooter("Teilnehmerliste|$row_get_termin[tm_datum_form], $standort|{PAGENO} / {nb}");
$mpdf->setFooter("Testteilnehmer||$row_get_termin[tm_datum_form], $standort");
$mpdf->WriteHTML($buffer);
// Output a PDF file directly to the browser
$mpdf->Output();
}
$smarty->assign('action', "$action");
$smarty->display("$template/admin/$templatename");
?>
Reference in New Issue View Git Blame Copy Permalink