</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);