$stg_obj = new studiengang();
$stg_obj->getAll('typ, kurzbz');
echo "\n", 'Studiengang <SELECT name="studiengang_kz">
<OPTION value="">-- Alle --</OPTION>';
foreach ($stg_obj->result as $row) {
if ($row->studiengang_kz == $studiengang_kz) {
$selected = 'selected';
} else {
$selected = '';
}
echo '<OPTION value="' . $row->studiengang_kz . '" ' . $selected . '>' . $row->kuerzel . ' (' . $row->kurzbzlang . ')</OPTION>';
}
echo '</SELECT>';
echo ' <input type="submit" name="show" value="OK"></form>';
$stsem = new studiensemester();
$stsem->getFinished();
foreach ($stsem->studiensemester as $row) {
$qry = "SELECT \n\t\t\tdistinct vorname, nachname, studiengang_kz, UPPER(tbl_studiengang.typ || tbl_studiengang.kurzbz) as stg\n\t\t FROM \n\t\t \tpublic.tbl_prestudent \n\t\t \tJOIN public.tbl_prestudentstatus USING(prestudent_id)\n\t\t \tJOIN public.tbl_person USING(person_id)\n\t\t \tJOIN public.tbl_studiengang USING(studiengang_kz)\n\t\t WHERE\n\t\t \ttbl_prestudentstatus.status_kurzbz='Incoming'\n\t\t \tAND tbl_prestudentstatus.studiensemester_kurzbz='" . $row->studiensemester_kurzbz . "'";
if ($studiengang_kz != '') {
$qry .= " AND tbl_prestudent.studiengang_kz='" . addslashes($studiengang_kz) . "'";
}
$qry .= " ORDER BY stg";
if ($result = $db->db_query($qry)) {
$anzahl = $db->db_num_rows($result);
echo '<h3>' . $row->studiensemester_kurzbz . ' Anzahl: ' . $anzahl . '</h3>';
if ($anzahl > 0) {
echo '
<script type="text/javascript">
$(document).ready(function()
{
$("#' . $row->studiensemester_kurzbz . '").tablesorter(
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<<<<<<< HEAD
<option value="4">5</option>
<option value="4">6</option>
=======
<option value="5">5</option>
<option value="6">6</option>
>>>>>>> fee287127566cd5d18c55b556d178b661711c694
</select>
</td></tr><tr>
<td valign="middle" >';
$studiensemester = new studiensemester();
$studiensemester->getFinished();
echo '<SELECT style="width:200px;" name="begin" id="studiensemester">';
echo '<OPTION value="" selected>' . $p->t('lvplan/studiensemesterAuswaehlen') . '</OPTION>';
foreach ($studiensemester->studiensemester as $row) {
$studiensemester->getTimestamp($row->studiensemester_kurzbz);
echo '<OPTION value="' . $studiensemester->begin->start . '&ende=' . $studiensemester->ende->ende . '">' . $row->studiensemester_kurzbz . '</OPTION>';
}
echo '</SELECT>';
echo '</td>
<td colspan="3" valign="bottom">
<input type="button" name="Abschicken" value="' . $p->t('lvplan/semesterplanLaden') . '" onClick="jumpKalender()">
</td>
</tr>
</table>
</form>';
}
