/**
* adds a user to the seminar with the given status
* @param user_id string: ID of the user
* @param status string: status of the user for the seminar "user", "autor", "tutor", "dozent"
* @param force bool: if false (default) the user will only be upgraded and not degraded in his/her status
*/
public function addMember($user_id, $status = 'autor', $force = false)
{
if (in_array(get_global_perm($user_id), array("admin", "root"))) {
$this->createError(_("Admin und Root dürfen nicht Mitglied einer Veranstaltung sein."));
return false;
}
$db = DBManager::get();
$rangordnung = array_flip(array('user', 'autor', 'tutor', 'dozent'));
if ($rangordnung[$status] > $rangordnung['autor'] && SeminarCategories::getByTypeId($this->status)->only_inst_user) {
//überprüfe, ob im richtigen Institut:
$user_institute_stmt = $db->prepare(
"SELECT Institut_id " .
"FROM user_inst " .
"WHERE user_id = :user_id " .
"");
$user_institute_stmt->execute(array('user_id' => $user_id));
$user_institute = $user_institute_stmt->fetchAll(PDO::FETCH_COLUMN, 0);
if (!in_array($this->institut_id, $user_institute) && !count(array_intersect($user_institute, $this->getInstitutes()))) {
$this->createError(_("Einzutragender Nutzer stammt nicht einem beteiligten Institut an."));
return false;
}
}
if (!$force) {
$query = "SELECT status FROM seminar_user WHERE user_id = ? AND Seminar_id = ?";
$statement = DBManager::get()->prepare($query);
$statement->execute(array($user_id, $this->id));
$old_status = $statement->fetchColumn();
}
$query = "SELECT MAX(position) + 1 FROM seminar_user WHERE status = ? AND Seminar_id = ?";
$statement = DBManager::get()->prepare($query);
$statement->execute(array($status, $this->id));
$new_position = $statement->fetchColumn();
$query = "SELECT COUNT(*) FROM seminar_user WHERE Seminar_id = ? AND status = 'dozent'";
$statement = DBManager::get()->prepare($query);
$statement->execute(array($this->id));
$numberOfTeachers = $statement->fetchColumn();
if (!$old_status) {
$query = "INSERT INTO seminar_user (Seminar_id, user_id, status, position, gruppe, visible, mkdate)
VALUES (?, ?, ?, ?, ?, ?, UNIX_TIMESTAMP())";
$statement = DBManager::get()->prepare($query);
$statement->execute(array(
$this->id,
$user_id,
$status,
$new_position ?: 0,
(int)select_group($this->getSemesterStartTime()),
in_array($status, words('tutor dozent')) ? 'yes' : 'unknown',
));
// delete the entries, user is now in the seminar
$stmt = DBManager::get()->prepare('DELETE FROM admission_seminar_user
WHERE user_id = ? AND seminar_id = ?');
$stmt->execute(array($user_id, $this->getId()));
if ($stmt->rowCount()) {
//renumber the waiting/accepted/lot list, a user was deleted from it
renumber_admission($this->getId());
}
$cs = $this->getCourseSet();
if ($cs) {
$prio_delete = AdmissionPriority::unsetPriority($cs->getId(), $user_id, $this->getId());
}
removeScheduleEntriesMarkedAsVirtual($user_id, $this->getId());
NotificationCenter::postNotification("CourseDidGetMember", $this, $user_id);
NotificationCenter::postNotification('UserDidEnterCourse', $this->id, $user_id);
StudipLog::log('SEM_USER_ADD', $this->id, $user_id, $status, 'Wurde in die Veranstaltung eingetragen');
$this->course->resetRelation('members');
$this->course->resetRelation('admission_applicants');
return $this;
} elseif (($force || $rangordnung[$old_status] < $rangordnung[$status])
&& ($old_status !== "dozent" || $numberOfTeachers > 1)) {
$query = "UPDATE seminar_user
SET status = ?, visible = IFNULL(?, visible), position = ?
WHERE Seminar_id = ? AND user_id = ?";
$statement = DBManager::get()->prepare($query);
$statement->execute(array(
$status,
in_array($status, words('tutor dozent')) ? 'yes' : null,
$new_position,
$this->id,
$user_id,
));
if ($old_status === 'dozent') {
$query = "SELECT termin_id FROM termine WHERE range_id = ?";
$statement = DBManager::get()->prepare($query);
$statement->execute(array($this->id));
$termine = $statement->fetchAll(PDO::FETCH_COLUMN);
$query = "DELETE FROM termin_related_persons WHERE range_id = ? AND user_id = ?";
$statement = DBManager::get()->prepare($query);
foreach ($termine as $termin_id) {
$statement->execute(array($termin_id, $user_id));
}
}
NotificationCenter::postNotification("CourseDidChangeMember", $this, $user_id);
$this->course->resetRelation('members');
$this->course->resetRelation('admission_applicants');
return $this;
} else {
if ($old_status === "dozent" && $numberOfTeachers <= 1) {
$this->createError(sprintf(_("Die Veranstaltung muss wenigstens <b>einen/eine</b> VeranstaltungsleiterIn (%s) eingetragen haben!"),
get_title_for_status('dozent', 1, $this->status)) .
' ' . _("Tragen Sie zunächst einen anderen ein, um diesen herabzustufen."));
}
return false;
}
}
/**
* Insert a user into a seminar with optional log-message and contingent
*
* @param string $seminar_id
* @param string $user_id
* @param string $status status of user in the seminar (user, autor, tutor, dozent)
* @param boolean $copy_studycourse if true, the studycourse is copied from admission_seminar_user
* to seminar_user. Overrides the $contingent-parameter
* @param string $contingent optional studiengang_id, if no id is given, no contingent is considered
* @param string $log_message optional log-message. if no log-message is given a default one is used
* @return void
*/
function insert_seminar_user($seminar_id, $user_id, $status, $copy_studycourse = false, $contingent = false, $log_message = false) {
// get the seminar-object
$sem = Seminar::GetInstance($seminar_id);
$admission_status = '';
$admission_comment = '';
$mkdate = time();
$stmt = DBManager::get()->prepare("SELECT * FROM admission_seminar_user
WHERE seminar_id = ? AND user_id = ?");
$stmt->execute(array($seminar_id, $user_id));
if ($data = $stmt->fetch(PDO::FETCH_ASSOC)) {
// copy the studycourse from admission_seminar_user
if ($copy_studycourse && $data['studiengang_id']) {
$contingent = $data['studiengang_id'];
}
$admission_status = $data['status'];
$admission_comment = ($data['comment'] == NULL) ? '' : $data['comment'];
$mkdate = $data['mkdate'];
}
// check if there are places left in the submitted contingent (if any)
//ignore if preliminary
if ($admission_status != 'accepted' && $contingent && $sem->isAdmissionEnabled() && !$sem->getFreeAdmissionSeats($contingent)) {
return false;
}
// get coloured group as used on meine_seminare
$colour_group = $sem->getDefaultGroup();
// LOGGING
// if no log message is submitted use a default one
if (!$log_message) {
$log_message = 'Wurde in die Veranstaltung eingetragen, admission_status: '. $admission_status . ' Kontingent: ' . $contingent;
}
log_event('SEM_USER_ADD', $seminar_id, $user_id, $status, $log_message);
// actually insert the user into the seminar
$stmt = DBManager::get()->prepare('INSERT IGNORE INTO seminar_user
(Seminar_id, user_id, status, comment, gruppe, mkdate)
VALUES (?, ?, ?, ?, ?, ?)');
$stmt->execute(array($seminar_id, $user_id, $status, $admission_comment, $colour_group, $mkdate));
NotificationCenter::postNotification('UserDidEnterCourse', $seminar_id, $user_id);
if ($admission_status) {
// delete the entries, user is now in the seminar
$stmt = DBManager::get()->prepare('DELETE FROM admission_seminar_user
WHERE user_id = ? AND seminar_id = ?');
$stmt->execute(array($user_id, $seminar_id));
//renumber the waiting/accepted/lot list, a user was deleted from it
renumber_admission($seminar_id);
}
$cs = $sem->getCourseSet();
if ($cs) {
$prio_delete = AdmissionPriority::unsetPriority($cs->getId(), $user_id, $sem->getId());
}
removeScheduleEntriesMarkedAsVirtual($user_id, $seminar_id);
// reload the seminar, the contingents have changed
$sem->restore();
return true;
}