?> <tr> <td style="vertical-align: top" colspan="2"> <? // Grunddaten des Seminars printf("<b>" . _("Untertitel:") . "</b><br>%s", htmlReady($seminar['Untertitel'])); ?> </td> </tr> <? } ?> <tr> <td style="vertical-align: top"> <? printf("<b>" . _("Zeit:") . "</b><br>%s", htmlReady(view_turnus($_SESSION['archiv_assi_data']['sems'][$_SESSION['archiv_assi_data']['pos']]['id'], FALSE))); ?> </td> <td style="vertical-align: top"> <? printf("<b>" . _("Semester:") . "</b><br>%s", get_semester($_SESSION['archiv_assi_data']['sems'][$_SESSION['archiv_assi_data']['pos']]['id'])); ?> </td> </tr> <tr> <td style="vertical-align: top"> <? printf("<b>" . _("Erster Termin:") . "</b><br>%s", veranstaltung_beginn($_SESSION['archiv_assi_data']["sems"][$_SESSION['archiv_assi_data']["pos"]]["id"])); ?> </td> <td style="vertical-align: top">
/** * This function numbers a waiting list * * Use this functions, if a person was moved from the waiting list or there were other changes * to the waiting list. The User gets a message, if the parameter is set and the position * on the waiting list has changed. * * @param string seminar_id the seminar_id of the seminar to calculate * @param boolean send_message should a system-message be send? * */ function renumber_admission ($seminar_id, $send_message = TRUE) { $messaging = new messaging; $seminar = Seminar::GetInstance($seminar_id); if ($seminar->isAdmissionEnabled()) { //Liste einlesen $query = "SELECT user_id FROM admission_seminar_user WHERE seminar_id = ? AND status = 'awaiting' ORDER BY position"; $statement = DBManager::get()->prepare($query); $statement->execute(array($seminar->id)); $user_ids = $statement->fetchAll(PDO::FETCH_COLUMN); // Prepare statement that updates the position $query = "UPDATE admission_seminar_user SET position = ? WHERE user_id = ? AND seminar_id = ?"; $update_statement = DBManager::get()->prepare($query); $position = 1; //Liste neu numerieren foreach ($user_ids as $user_id) { $update_statement->execute(array($position, $user_id, $seminar->id)); //User benachrichten if ($update_statement->rowCount() && $send_message) { //Usernamen auslesen $username = get_username($user_id); setTempLanguage($user_id); $message = sprintf(_('Sie sind in der Warteliste der Veranstaltung **%s (%s)** hochgestuft worden. Sie stehen zur Zeit auf Position %s.'), $seminar->name, view_turnus($seminar->seminar_id), $position); $subject = sprintf(_('Ihre Position auf der Warteliste der Veranstaltung %s wurde verändert'), $seminar->name); restoreLanguage(); $messaging->insert_message($message, $username, '____%system%____', FALSE, FALSE, '1', FALSE, $subject); } $position += 1; } } }