</td></tr></table>
<br/>';
if ($stg_kz != '') {
echo '<table id="t1" class="tablesorter">
<thead>
<tr>
<th>Dokumentname</th>
<th>Online-Bewerbung</th>
<th>Pflicht</th>
<th></th>
</tr>
</thead>
<tbody>';
$dokStg = new dokument();
$dokStg->getDokumente($stg_kz);
$zugewieseneDokumente = array();
foreach ($dokStg->result as $dok) {
$zugewieseneDokumente[] = $dok->dokument_kurzbz;
$checked_onlinebewerbung = $dok->onlinebewerbung ? 'true' : 'false';
$checked_pflicht = $dok->pflicht ? 'true' : 'false';
echo '<tr>
<td>' . $dok->bezeichnung . '</td>
<td><a href="' . $_SERVER['PHP_SELF'] . '?action=toggleonline&dokument_kurzbz=' . $dok->dokument_kurzbz . '&stg_kz=' . $stg_kz . '"><img src="../../skin/images/' . $checked_onlinebewerbung . '.png" /></a></td>
<td><a href="' . $_SERVER['PHP_SELF'] . '?action=togglepflicht&dokument_kurzbz=' . $dok->dokument_kurzbz . '&stg_kz=' . $stg_kz . '"><img src="../../skin/images/' . $checked_pflicht . '.png" /></a></td>
<td><a href="' . $_SERVER['PHP_SELF'] . '?action=delete&dokument_kurzbz=' . $dok->dokument_kurzbz . '&stg_kz=' . $stg_kz . '">Zuordnung löschen</a></td>
</td>
</tr>';
}
echo '
</tbody>
$format_center->setAlign('merge');
$format_rotate =& $workbook->addFormat();
$format_rotate->setTextRotation(270);
$format_rotate->setAlign('center');
$spalte = 0;
$zeile = 0;
$worksheet->write($zeile, $spalte, 'NACHNAME', $format_bold);
$maxlength[$spalte] = 8;
$worksheet->write($zeile, ++$spalte, 'VORNAME', $format_bold);
$maxlength[$spalte] = 7;
$worksheet->write($zeile, ++$spalte, 'STATUS', $format_bold);
$maxlength[$spalte] = 6;
$worksheet->write($zeile, ++$spalte, 'SEMESTER', $format_bold);
$maxlength[$spalte] = 8;
$dokumente = new dokument();
$dokumente->getDokumente($studiengang_kz);
$dokumente_arr = array();
foreach ($dokumente->result as $row) {
$worksheet->write($zeile, ++$spalte, $row->bezeichnung, $format_rotate);
$maxlength[$spalte] = 3;
$dokumente_arr[$row->dokument_kurzbz] = $spalte;
}
// Daten holen
$qry = "SELECT DISTINCT nachname, vorname, prestudent_id, public.get_rolle_prestudent(prestudent_id, NULL) AS status, tbl_studentlehrverband.semester FROM \n\t\t\t\tpublic.tbl_person JOIN public.tbl_prestudent USING(person_id)\n\t\t\t\tLEFT JOIN public.tbl_student USING (prestudent_id)\n\t\t\t\tLEFT JOIN public.tbl_studentlehrverband USING (student_uid)\n\t\t\tWHERE \n\t\t\t\tprestudent_id IN(\n\t\t\t\tSELECT \n\t\t\t\t\tdistinct prestudent_id \n\t\t\t\tFROM \n\t\t\t\t\tpublic.tbl_prestudent JOIN public.tbl_prestudentstatus USING(prestudent_id)\n\t\t\t\tWHERE \n\t\t\t\t\t(SELECT count(*) as anzahl FROM public.tbl_dokumentstudiengang \n\t\t\t\t\t WHERE \n\t\t\t\t\t \tdokument_kurzbz NOT IN(\tSELECT dokument_kurzbz FROM tbl_dokumentprestudent WHERE \n\t\t\t\t\t \t\t\t\t\t\t\tprestudent_id=tbl_prestudent.prestudent_id) AND studiengang_kz='" . addslashes($studiengang_kz) . "')<>0 \n\t\t\t\t\t \tAND tbl_prestudentstatus.studiensemester_kurzbz='" . addslashes($studiensemester_kurzbz) . "' AND studiengang_kz='" . addslashes($studiengang_kz) . "'\n\t\t\t)\n\t\t\tAND (tbl_studentlehrverband.studiensemester_kurzbz='" . addslashes($studiensemester_kurzbz) . "' OR tbl_studentlehrverband.studiensemester_kurzbz is null)\n\t\t\t\n\t\t\tORDER BY nachname, vorname, semester\n\t\t ";
if ($result = $db->db_query($qry)) {
while ($row = $db->db_fetch_object($result)) {
$zeile++;
$spalte = 0;
$worksheet->write($zeile, $spalte, $row->nachname);
if (mb_strlen($row->nachname) > $maxlength[$spalte]) {
$maxlength[$spalte] = mb_strlen($row->nachname);
