$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>'; }