?>
<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;
}
}
}
