foreach ($stgs as $kz) {
echo '<option ' . ($stg_kz == $kz ? ' selected="selected" ' : '') . ' value="' . $kz . '" >' . $stg_arr[$kz] . '</option>';
}
echo '</SELECT>';
echo ' Studiensemester: <SELECT name="stsem">';
$stsem_obj = new studiensemester();
$stsem_obj->getAll();
foreach ($stsem_obj->studiensemester as $row) {
echo '<option ' . ($stsem == $row->studiensemester_kurzbz ? ' selected="selected" ' : '') . ' value="' . $row->studiensemester_kurzbz . '" >' . $row->studiensemester_kurzbz . '</option>';
}
echo '</SELECT>';
echo '<input type="submit" value="Anzeigen">';
echo '</form>';
echo '<br><br>';
$projekt = new projektarbeit();
$projekt->getProjektarbeitStudiensemester($stg_kz, $stsem);
echo '<form action="' . $_SERVER['PHP_SELF'] . '?stg_kz=' . $stg_kz . '&stsem=' . $stsem . '" method="POST" />';
echo "<table class='liste table-autosort:0 table-stripeclass:alternate table-autostripe'><thead><tr class='liste'>";
echo "<th class='table-sortable:default'>Student</th>\n\t <th class='table-sortable:default'>Typ</th>\n\t <th class='table-sortable:default'>Titel</th>\n\t <th class='table-sortable:default'>Themenbereich</th>\n\t <th class='table-sortable:default'>Betreuer</th>\n\t <th class='table-sortable:default'>Beginn</th>\n\t <th class='table-sortable:default'>Ende</th>\n\t <th class='table-sortable:default'>Gesamtnote</th>";
echo "</tr></thead>";
echo "<tbody>";
foreach ($projekt->result as $row) {
echo '<tr>';
$student = new student();
$student->load($row->student_uid);
echo "<td nowrap>{$student->nachname} {$student->vorname} {$student->titelpre} {$student->titelpost}</td>";
echo "<td>{$row->bezeichnung}</td>";
echo "<td>{$row->titel}" . ($row->titel_english != '' ? '<br>' . $row->titel_english : '') . "</td>";
echo "<td>{$row->themenbereich}</td>";
echo '<td nowrap>';
$qry = "SELECT distinct vorname, nachname, titelpre, titelpost, (SELECT uid FROM public.tbl_benutzer JOIN public.tbl_mitarbeiter on(uid=mitarbeiter_uid) WHERE person_id=tbl_person.person_id LIMIT 1) as uid, betreuerart_kurzbz FROM public.tbl_person JOIN lehre.tbl_projektbetreuer USING(person_id) WHERE projektarbeit_id='" . $row->projektarbeit_id . "'";
