public function approve_action($plugin_id)
{
$this->marketplugin = new MarketPlugin($plugin_id);
if ($this->marketplugin['approved']) {
throw new Exception("Plugin ist schon reviewt.");
}
$this->marketplugin['approved'] = (int) Request::int("approved");
if (!$this->marketplugin['approved']) {
$this->marketplugin['publiclyvisible'] = 0;
}
if ($this->marketplugin['approved'] && $this->marketplugin['publiclyvisible']) {
$this->marketplugin['published'] = time();
}
$this->marketplugin->store();
$messaging = new messaging();
$messaging->insert_message(sprintf(_("Ihr Plugin %s wurde reviewt:"), $this->marketplugin['name']) . "\n\n" . ($this->marketplugin['approved'] ? _("Es ist in den Marktplatz aufgenommen worden!") : _("Es ist leider noch nicht in den Marktplatz aufgenommen.")) . "\n\n" . (Request::get("review") ? _("Begründung:") . "\n\n" . Request::get("review") : _("Ein ausführliches Review wurde nicht angegeben und muss bei Bedarf direkt angefragt werden.")), get_username($this->marketplugin['user_id']), '', '', '', '', '', _("Pluginreview"), true, 'normal', "pluginreview");
PageLayout::postMessage(MessageBox::success(_("Review wurde gespeichert.")));
$this->redirect('approving/overview');
}
/**
* @param string $comment
* @param array $dates SingleDate
*/
function raumzeit_send_cancel_message($comment, $dates)
{
if (!is_array($dates)) {
$dates = array($dates);
}
$course = Course::find($dates[0]->range_id);
if ($course) {
$subject = sprintf(_("[%s] Terminausfall"), $course->name);
$recipients = $course->members->pluck('username');
$lecturers = $course->members->findBy('status', 'dozent')->pluck('nachname');
$message = sprintf(_("In der Veranstaltung %s fällt der/die folgende(n) Termine aus:"), $course->name . ' (' . join(',', $lecturers) . ') ' . $course->start_semester->name);
$message .= "\n\n- ";
$message .= join("\n- ", array_map(function ($a) {
return $a->toString();
}, $dates));
if ($comment) {
$message .= "\n\n" . $comment;
}
$msg = new messaging();
return $msg->insert_message($message, $recipients, '____%system%____', '', '', '', '', $subject, true);
}
}
public static function mention($markup, $matches)
{
$mention = $matches[0];
$thread_id = self::$mention_thread_id;
$username = stripslashes(substr($mention, 1));
if ($username[0] !== '"') {
$user_id = get_userid($username);
} else {
$name = substr($username, 1, strlen($username) - 2);
$db = DBManager::get();
$user_id = $db->query("SELECT user_id FROM auth_user_md5 WHERE CONCAT(Vorname, ' ', Nachname) = " . $db->quote($name) . " " . "")->fetch(PDO::FETCH_COLUMN, 0);
}
$thread = new ForumPosting($thread_id);
if (!$thread->isNew() && $user_id && $user_id !== $GLOBALS['user']->id) {
$user = new User($user_id);
$messaging = new messaging();
$url = $GLOBALS['ABSOLUTE_URI_STUDIP'] . "plugins.php/blubber/forum/thread/" . $thread_id . ($thread['context_type'] === "course" ? '?cid=' . $thread['Seminar_id'] : "");
$messaging->insert_message(sprintf(_("%s hat Sie in einem Blubber erwähnt. Zum Beantworten klicken auf Sie auf folgenen Link:\n\n%s\n"), get_fullname(), $url), get_username($user_id), $GLOBALS['user']->id, null, null, null, null, _("Sie wurden erwähnt."));
DBManager::get()->exec("INSERT IGNORE INTO blubber_mentions " . "SET user_id = " . DBManager::get()->quote($user_id) . ", " . "topic_id = " . DBManager::get()->quote($thread_id) . ", " . "mkdate = UNIX_TIMESTAMP() " . "");
return '[' . $user['Vorname'] . " " . $user['Nachname'] . ']' . $GLOBALS['ABSOLUTE_URI_STUDIP'] . "about.php?username=" . $user['username'] . ' ';
} else {
return stripslashes($mention);
}
}
/**
* Sends an internal mail with the provided subject and message to all
* users with a global permission of "root".
*
* @param String $subject The subject of the message
* @param String $message The message itself
*/
private function sendMailToRoots($subject, $message)
{
$temp = User::findByPerms('root');
$roots = SimpleORMapCollection::createFromArray($temp)->pluck('username');
$msging = new messaging();
$msging->insert_message($message, $roots, '____%system%____', null, null, null, null, $subject, false, 'high');
}
public function edit_posting_action()
{
$posting = new ForumPosting(Request::get("topic_id"));
$thread = new ForumPosting($posting['root_id']);
if ($posting['user_id'] !== $GLOBALS['user']->id && !$GLOBALS['perm']->have_studip_perm("tutor", $posting['Seminar_id'])) {
throw new AccessDeniedException("Kein Zugriff");
}
$old_content = $posting['description'];
$messaging = new messaging();
ForumPosting::$mention_thread_id = $thread->getId();
StudipTransformFormat::addStudipMarkup("mention1", '@\\"[^\\n\\"]*\\"', "", "ForumPosting::mention");
StudipTransformFormat::addStudipMarkup("mention2", '@[^\\s]*[\\d\\w_]+', "", "ForumPosting::mention");
$new_content = transformBeforeSave(studip_utf8decode(Request::get("content")));
//$new_content = preg_replace("/(@\"[^\n\"]*\")/e", "ForumPosting::mention('\\1', '".$thread->getId()."')", $new_content);
//$new_content = preg_replace("/(@[^\s]+)/e", "ForumPosting::mention('\\1', '".$thread->getId()."')", $new_content);
if ($new_content && $old_content !== $new_content) {
$posting['description'] = $new_content;
if ($posting['topic_id'] === $posting['root_id']) {
if (strpos($new_content, "\n") !== false) {
$posting['name'] = substr($new_content, 0, strpos($new_content, "\n"));
} else {
if (strlen($new_content) > 255) {
$posting['name'] = "";
} else {
$posting['name'] = $new_content;
}
}
}
$posting->store();
if ($posting['user_id'] !== $GLOBALS['user']->id) {
$messaging->insert_message(sprintf(_("%s hat als Moderator gerade Ihren Beitrag im Blubberforum editiert.\n\nDie alte Version des Beitrags lautete:\n\n%s\n\nDie neue lautet:\n\n%s\n"), get_fullname(), $old_content, $posting['description']), get_username($posting['user_id']), $GLOBALS['user']->id, null, null, null, null, _("Änderungen an Ihrem Posting."));
}
} elseif (!$new_content) {
if ($posting['user_id'] !== $GLOBALS['user']->id) {
$messaging->insert_message(sprintf(_("%s hat als Moderator gerade Ihren Beitrag im Blubberforum GELÖSCHT.\n\nDer alte Beitrag lautete:\n\n%s\n"), get_fullname(), $old_content), get_username($posting['user_id']), $GLOBALS['user']->id, null, null, null, null, _("Ihr Posting wurde gelöscht."));
}
$posting->delete();
}
ForumPosting::$course_hashes = $thread['user_id'] !== $thread['Seminar_id'] ? $thread['Seminar_id'] : false;
$this->render_text(studip_utf8encode(ForumPosting::format($posting['description'])));
}
/**
* Builds news dialog for editing / adding news
*
* @param string $id news id (in case news already exists; otherwise set to "new")
* @param string $context_range range id (only for new news; set to 'template' for copied news)
* @param string $template_id template id (source of news template)
*
*/
function edit_news_action($id = '', $context_range = '', $template_id = '')
{
// initialize
$this->news_isvisible = array('news_basic' => true, 'news_comments' => false, 'news_areas' => false);
$ranges = array();
$this->ranges = array();
$this->area_options_selectable = array();
$this->area_options_selected = array();
$this->may_delete = false;
$this->route = "news/edit_news/{$id}";
if ($context_range) {
$this->route .= "/{$context_range}";
if ($template_id) {
$this->route .= "/{$template_id}";
}
}
$msg_object = new messaging();
if ($id == "new") {
unset($id);
$this->title = _("Ankündigung erstellen");
} else {
$this->title = _("Ankündigung bearbeiten");
}
// user has to have autor permission at least
if (!$GLOBALS['perm']->have_perm(autor)) {
$this->set_status(401);
return $this->render_nothing();
}
// Output as dialog (Ajax-Request) or as Stud.IP page?
if (Request::isXhr()) {
$this->set_layout(null);
header('X-Title: ' . $this->title);
} else {
$this->set_layout($GLOBALS['template_factory']->open('layouts/base'));
}
// load news and comment data and check if user has permission to edit
$news = new StudipNews($id);
if (!$news->isNew()) {
$this->comments = StudipComment::GetCommentsForObject($id);
}
if (!$news->havePermission('edit') and !$news->isNew()) {
$this->set_status(401);
PageLayout::postMessage(MessageBox::error(_('Keine Berechtigung!')));
return $this->render_nothing();
}
// if form sent, get news data by post vars
if (Request::get('news_isvisible')) {
// visible categories, selected areas, topic, and body are utf8 encoded when sent via ajax
$this->news_isvisible = unserialize(Request::get('news_isvisible'));
if (Request::isXhr()) {
$this->area_options_selected = unserialize(studip_utf8decode(Request::get('news_selected_areas')));
$this->area_options_selectable = unserialize(studip_utf8decode(Request::get('news_selectable_areas')));
$topic = studip_utf8decode(Request::get('news_topic'));
$body = transformBeforeSave(Studip\Markup::purifyHtml(studip_utf8decode(Request::get('news_body'))));
} else {
$this->area_options_selected = unserialize(Request::get('news_selected_areas'));
$this->area_options_selectable = unserialize(Request::get('news_selectable_areas'));
$topic = Request::get('news_topic');
$body = transformBeforeSave(Studip\Markup::purifyHtml(Request::get('news_body')));
}
$date = $this->getTimeStamp(Request::get('news_startdate'), 'start');
$expire = $this->getTimeStamp(Request::get('news_enddate'), 'end') ? $this->getTimeStamp(Request::get('news_enddate'), 'end') - $this->getTimeStamp(Request::get('news_startdate'), 'start') : '';
$allow_comments = Request::get('news_allow_comments') ? 1 : 0;
if (Request::submitted('comments_status_deny')) {
$this->anker = 'news_comments';
$allow_comments = 0;
} elseif (Request::submitted('comments_status_allow')) {
$this->anker = 'news_comments';
$allow_comments = 1;
}
if ($news->getValue('topic') != $topic or $news->getValue('body') != $body or $news->getValue('date') != $date or $news->getValue('allow_comments') != $allow_comments or $news->getValue('expire') != $expire) {
$changed = true;
}
$news->setValue('topic', $topic);
$news->setValue('body', $body);
$news->setValue('date', $date);
$news->setValue('expire', $expire);
$news->setValue('allow_comments', $allow_comments);
} elseif ($id) {
// if news id given check for valid id and load ranges
if ($news->isNew()) {
PageLayout::postMessage(MessageBox::error(_('Die Ankündigung existiert nicht!')));
return $this->render_nothing();
}
$ranges = $news->news_ranges->toArray();
} elseif ($template_id) {
// otherwise, load data from template
$news_template = new StudipNews($template_id);
if ($news_template->isNew()) {
PageLayout::postMessage(MessageBox::error(_('Die Ankündigung existiert nicht!')));
return $this->render_nothing();
}
// check for permission
if (!$news_template->havePermission('edit')) {
$this->set_status(401);
return $this->render_nothing();
}
$ranges = $news_template->news_ranges->toArray();
// remove those ranges for which user doesn't have permission
foreach ($ranges as $key => $news_range) {
if (!$news->haveRangePermission('edit', $news_range['range_id'])) {
$changed_areas++;
$this->news_isvisible['news_areas'] = true;
unset($ranges[$key]);
}
}
if ($changed_areas == 1) {
PageLayout::postMessage(MessageBox::info(_('1 zugeordneter Bereich wurde nicht übernommen, weil Sie dort keine Ankündigungen erstellen dürfen.')));
} elseif ($changed_areas) {
PageLayout::postMessage(MessageBox::info(sprintf(_('%s zugeordnete Bereiche wurden nicht übernommen, weil Sie dort keine Ankündigungen erstellen dürfen.'), $changed_areas)));
}
$news->setValue('topic', $news_template->getValue('topic'));
$news->setValue('body', $news_template->getValue('body'));
$news->setValue('date', $news_template->getValue('date'));
$news->setValue('expire', $news_template->getValue('expire'));
$news->setValue('allow_comments', $news_template->getValue('allow_comments'));
} else {
// for new news, set startdate to today and range to dialog context
$news->setValue('date', strtotime(date('Y-m-d')));
// + 12*60*60;
$news->setValue('expire', 604800);
if ($context_range != '' and $context_range != 'template') {
$add_range = new NewsRange(array('', $context_range));
$ranges[] = $add_range->toArray();
}
}
// build news var for template
$this->news = $news->toArray();
// treat faculties and institutes as one area group (inst)
foreach ($ranges as $range) {
switch ($range['type']) {
case 'fak':
$this->area_options_selected['inst'][$range['range_id']] = $range['name'];
break;
default:
$this->area_options_selected[$range['type']][$range['range_id']] = $range['name'];
}
}
// define search presets
$this->search_presets['user'] = _('Meine Profilseite');
if ($GLOBALS['perm']->have_perm('autor') and !$GLOBALS['perm']->have_perm('admin')) {
$my_sem = $this->search_area('__THIS_SEMESTER__');
if (count($my_sem['sem'])) {
$this->search_presets['sem'] = _('Meine Veranstaltungen im aktuellen Semester') . ' (' . count($my_sem['sem']) . ')';
}
}
if ($GLOBALS['perm']->have_perm('dozent') and !$GLOBALS['perm']->have_perm('root')) {
$my_inst = $this->search_area('__MY_INSTITUTES__');
if (count($my_inst)) {
$this->search_presets['inst'] = _('Meine Einrichtungen') . ' (' . count($my_inst['inst']) . ')';
}
}
if ($GLOBALS['perm']->have_perm('root')) {
$this->search_presets['global'] = $this->area_structure['global']['title'];
}
// perform search
if (Request::submitted('area_search') or Request::submitted('area_search_preset')) {
$this->anker = 'news_areas';
$this->search_term = studip_utf8decode(Request::get('area_search_term'));
if (Request::submitted('area_search')) {
$this->area_options_selectable = $this->search_area($this->search_term);
} else {
$this->current_search_preset = Request::option('search_preset');
if ($this->current_search_preset == 'inst') {
$this->area_options_selectable = $my_inst;
} elseif ($this->current_search_preset == 'sem') {
$this->area_options_selectable = $my_sem;
} elseif ($this->current_search_preset == 'user') {
$this->area_options_selectable = array('user' => array($GLOBALS['auth']->auth['uid'] => get_fullname()));
} elseif ($this->current_search_preset == 'global') {
$this->area_options_selectable = array('global' => array('studip' => _('Stud.IP')));
}
}
if (!count($this->area_options_selectable)) {
unset($this->search_term);
} else {
// already assigned areas won't be selectable
foreach ($this->area_options_selected as $type => $data) {
foreach ($data as $id => $title) {
unset($this->area_options_selectable[$type][$id]);
}
}
}
}
// delete comment(s)
if (Request::submitted('delete_marked_comments')) {
$this->anker = 'news_comments';
$this->flash['question_text'] = delete_comments(Request::optionArray('mark_comments'));
$this->flash['question_param'] = array('mark_comments' => Request::optionArray('mark_comments'), 'delete_marked_comments' => 1);
// reload comments
if (!$this->flash['question_text']) {
$this->comments = StudipComment::GetCommentsForObject($id);
$changed = true;
}
}
if ($news->havePermission('delete')) {
$this->comments_admin = true;
}
if (is_array($this->comments)) {
foreach ($this->comments as $key => $comment) {
if (Request::submitted('news_delete_comment_' . $comment['comment_id'])) {
$this->anker = 'news_comments';
$this->flash['question_text'] = delete_comments($comment['comment_id']);
$this->flash['question_param'] = array('mark_comments' => array($comment['comment_id']), 'delete_marked_comments' => 1);
}
}
}
// open / close category
foreach ($this->news_isvisible as $category => $value) {
if (Request::submitted('toggle_' . $category) or Request::get($category . '_js')) {
$this->news_isvisible[$category] = $this->news_isvisible[$category] ? false : true;
$this->anker = $category;
}
}
// add / remove areas
if (Request::submitted('news_add_areas') and is_array($this->area_options_selectable)) {
$this->anker = 'news_areas';
foreach (Request::optionArray('area_options_selectable') as $range_id) {
foreach ($this->area_options_selectable as $type => $data) {
if (isset($data[$range_id])) {
$this->area_options_selected[$type][$range_id] = $data[$range_id];
unset($this->area_options_selectable[$type][$range_id]);
}
}
}
}
if (Request::submitted('news_remove_areas') and is_array($this->area_options_selected)) {
$this->anker = 'news_areas';
foreach (Request::optionArray('area_options_selected') as $range_id) {
foreach ($this->area_options_selected as $type => $data) {
if (isset($data[$range_id])) {
$this->area_options_selectable[$type][$range_id] = $data[$range_id];
unset($this->area_options_selected[$type][$range_id]);
}
}
}
}
// prepare to save news
if (Request::submitted('save_news') and Request::isPost()) {
CSRFProtection::verifySecurityToken();
//prepare ranges array for already assigned news_ranges
foreach ($news->getRanges() as $range_id) {
$this->ranges[$range_id] = get_object_type($range_id, array('global', 'fak', 'inst', 'sem', 'user'));
}
// check if new ranges must be added
foreach ($this->area_options_selected as $type => $area_group) {
foreach ($area_group as $range_id => $area_title) {
if (!isset($this->ranges[$range_id])) {
if ($news->haveRangePermission('edit', $range_id)) {
$news->addRange($range_id);
$changed = true;
} else {
PageLayout::postMessage(MessageBox::error(sprintf(_('Sie haben keine Berechtigung zum Ändern der Bereichsverknüpfung für "%s".'), htmlReady($area_title))));
$error++;
}
}
}
}
// check if assigned ranges must be removed
foreach ($this->ranges as $range_id => $range_type) {
if ($range_type === 'fak' && !isset($this->area_options_selected['inst'][$range_id]) || $range_type !== 'fak' && !isset($this->area_options_selected[$range_type][$range_id])) {
if ($news->havePermission('unassign', $range_id)) {
$news->deleteRange($range_id);
$changed = true;
} else {
PageLayout::postMessage(MessageBox::error(_('Sie haben keine Berechtigung zum Ändern der Bereichsverknüpfung.')));
$error++;
}
}
}
// save news
if ($news->validate() and !$error) {
if ($news->getValue('user_id') != $GLOBALS['auth']->auth['uid']) {
$news->setValue('chdate_uid', $GLOBALS['auth']->auth['uid']);
setTempLanguage($news->getValue('user_id'));
$msg = sprintf(_('Ihre Ankündigung "%s" wurde von %s verändert.'), $news->getValue('topic'), get_fullname() . ' (' . get_username() . ')') . "\n";
$msg_object->insert_message($msg, get_username($news->getValue('user_id')), "____%system%____", FALSE, FALSE, "1", FALSE, _("Systemnachricht:") . " " . _("Ankündigung geändert"));
restoreLanguage();
} else {
$news->setValue('chdate_uid', '');
}
$news->store();
PageLayout::postMessage(MessageBox::success(_('Die Ankündigung wurde gespeichert.')));
// in fallback mode redirect to edit page with proper news id
if (!Request::isXhr() and !$id) {
$this->redirect('news/edit_news/' . $news->getValue('news_id'));
} elseif (Request::isXhr()) {
$this->render_nothing();
}
}
}
// check if user has full permission on news object
if ($news->havePermission('delete')) {
$this->may_delete = true;
}
}
/**
* Sends a message to the owner of the calendar that this event was deleted
* by another user.
*
* @param CalendarEvent $event The deleted event.
*/
protected function sendDeleteMessage($event)
{
$message = new messaging();
$event_data = '';
$subject = strftime(_('Termin am %c gelöscht'), $event->getStart());
$msg_text = sprintf(_("%s hat folgenden Termin in Ihrem Kalender gelöscht:"), get_fullname());
$msg_text .= "\n\n";
$msg_text .= '**' . _('Zeit:') . '**' . strftime(' %c - ', $event->getStart()) . strftime('%c', $event->getEnd()) . "\n";
$msg_text .= '**' . _("Zusammenfassung:") . '** ' . $event->getTitle() . "\n";
if ($event_data = $event->getDescription()) {
$msg_text .= '**' . _("Beschreibung:") . "** {$event_data}\n";
}
if ($event_data = $event->toStringCategories()) {
$msg_text .= '**' . _("Kategorie:") . "** {$event_data}\n";
}
if ($event_data = $event->toStringPriority()) {
$msg_text .= '**' . _("Priorität:") . "** {$event_data}\n";
}
if ($event_data = $event->toStringAccessibility()) {
$msg_text .= '**' . _("Zugriff:") . "** {$event_data}\n";
}
if ($event_data = $event->toStringRecurrence()) {
$msg_text .= '**' . _("Wiederholung:") . "** {$event_data}\n";
}
$message->insert_message($msg_text, get_username($event->range_id), '____%system%____', '', '', '', '', $subject);
}
/**
* generates proper text for confirmation question and deletes news
*
*
* @param mixed $delete_news_array (single id or array)
* @return string text for confirmation question or empty string after deletion
*/
function delete_news($delete_news_array)
{
$text = '';
$confirmed = false;
if (!is_array($delete_news_array)) {
$delete_news_array = array($delete_news_array);
}
if (Request::submitted('yes') and Request::isPost()) {
CSRFProtection::verifySecurityToken();
$confirmed = true;
}
foreach ($delete_news_array as $news_id) {
if ($news_id) {
$delete_news = new StudipNews($news_id);
$delete_news_titles[] = $delete_news->getValue('topic');
if ($confirmed) {
$msg_object = new messaging();
if ($delete_news->havePermission('delete')) {
PageLayout::postMessage(MessageBox::success(sprintf(_('Ankündigung "%s" wurde gelöscht.'), htmlReady($delete_news->getValue('topic')))));
if ($delete_news->getValue('user_id') != $GLOBALS['auth']->auth['uid']) {
setTempLanguage($delete_news->getValue('user_id'));
$msg = sprintf(_('Ihre Ankündigung "%s" wurde von der Administration gelöscht!.'), $delete_news->getValue('topic'), get_fullname() . ' (' . get_username() . ')') . "\n";
$msg_object->insert_message($msg, get_username($delete_news->getValue('user_id')), "____%system%____", FALSE, FALSE, "1", FALSE, _("Systemnachricht:") . " " . _("Ankündigung geändert"));
restoreLanguage();
}
$delete_news->delete();
} else {
PageLayout::postMessage(MessageBox::error(sprintf(_('Keine Berechtigung zum Löschen der Ankündigung "%s".'), htmlReady($delete_news->getValue('topic')))));
}
}
}
}
if (!$confirmed) {
if (count($delete_news_titles) == 1) {
$text = sprintf(_('- Die Ankündigung "%s" wird unwiderruflich gelöscht.'), $delete_news_titles[0]) . "\n";
} elseif (count($delete_news_titles) > 1) {
$text = sprintf(_('- Die %s Ankündigungen "%s" werden unwiderruflich gelöscht.'), count($delete_news_titles), implode('", "', $delete_news_titles)) . "\n";
}
}
return $text;
}
public function afterUpdate($object, $line)
{
if (FleximportConfig::get("SEMIRO_SEND_MESSAGES")) {
$messaging = new messaging();
//Email an Dozenten:
foreach ((array) $this->new_dozenten as $user_id) {
$message = sprintf(_('Sie wurden von Semiro als DozentIn in die Veranstaltung **%s** eingetragen.'), $object->name);
$messaging->insert_message($message, get_username($user_id), '____%system%____', FALSE, FALSE, '1', FALSE, sprintf('%s %s', _('Systemnachricht:'), _('Eintragung in Veranstaltung')), TRUE);
}
}
$teilnehmergruppe = $line['teilnehmergruppe'];
$import_type = "semiro_participant_import_" . $object->getId() . "_" . md5($teilnehmergruppe);
$imported_items = array();
if ($teilnehmergruppe && $object->getId()) {
$seminar = new Seminar($object->getId());
$datafield = Datafield::findOneByName(FleximportConfig::get("SEMIRO_USER_DATAFIELD_NAME"));
$dilp_kennung_feld = FleximportConfig::get("SEMIRO_DILP_KENNUNG_FIELD");
if (!$dilp_kennung_feld) {
$dilp_kennung_feld = "dilp_teilnehmer";
}
if ($datafield) {
$statement = DBManager::get()->prepare("\n SELECT `" . addslashes($dilp_kennung_feld) . "`\n FROM fleximport_semiro_participant_import\n WHERE teilnehmergruppe = ?\n ");
$statement->execute(array($teilnehmergruppe));
while ($id_teilnehmer = $statement->fetch(PDO::FETCH_COLUMN, 0)) {
//$ids = $statement->fetchAll(PDO::FETCH_COLUMN, 0);
//foreach ($ids as $id_teilnehmer) {
$entry = DatafieldEntryModel::findOneBySQL("datafield_id = ? AND content = ? ", array($datafield->getId(), $id_teilnehmer));
if ($entry) {
$was_member = CourseMember::findOneBySQL("seminar_id = ? AND user_id = ?", array($object->getId(), $entry['range_id']));
$seminar->addMember($entry['range_id']);
if (!$was_member && FleximportConfig::get("SEMIRO_SEND_MESSAGES")) {
$message = sprintf(_('Sie wurden von Semiro als TeilnehmerIn in die Veranstaltung **%s** eingetragen.'), $seminar->name);
$messaging->insert_message($message, get_username($entry['range_id']), '____%system%____', FALSE, FALSE, '1', FALSE, sprintf('%s %s', _('Systemnachricht:'), _('Eintragung in Veranstaltung')), TRUE);
}
//Zu Statusgruppe hinzufügen:
$gruppe = Statusgruppen::findOneBySQL("range_id = ? AND name = ?", array($object->getId(), $teilnehmergruppe));
if (!$gruppe) {
$gruppe = new Statusgruppen();
$gruppe['range_id'] = $object->getId();
$gruppe['name'] = $teilnehmergruppe;
$gruppe->store();
}
if (!$gruppe->isMember($entry['range_id'])) {
$gruppe->addUser($entry['range_id']);
}
//$gruppe->updateFolder(true);
if (!$gruppe->hasFolder()) {
create_folder(_("Dateiordner der Gruppe:") . ' ' . $teilnehmergruppe, _("Ablage für Ordner und Dokumente dieser Gruppe"), $gruppe->id, 15, $object->getId());
}
$item_id = $entry['range_id'];
if (!in_array($item_id, $imported_items)) {
$mapped = FleximportMappedItem::findbyItemId($item_id, $import_type) ?: new FleximportMappedItem();
$mapped['import_type'] = $import_type;
$mapped['item_id'] = $item_id;
$mapped['chdate'] = time();
$mapped->store();
$imported_items[] = $item_id;
}
}
}
}
//Dozent zu Statusgruppe hinzufügen:
$gruppe = Statusgruppen::findOneBySQL("range_id = ? AND name = ?", array($object->getId(), $teilnehmergruppe));
foreach ($object->members->filter(function ($member, $value) {
return $member['status'] === "dozent";
}) as $teacher) {
if (!$gruppe->isMember($teacher->getId())) {
$gruppe->addUser($teacher->getId());
}
}
$items = FleximportMappedItem::findBySQL("import_type = :import_type AND item_id NOT IN (:ids)", array('import_type' => $import_type, 'ids' => $imported_items ?: ""));
foreach ($items as $item) {
$user_id = $item['item_id'];
//check if user is in another group of this course
$statement = DBManager::get()->prepare("\n SELECT 1\n FROM fleximport_semiro_participant_import\n INNER JOIN fleximport_semiro_course_import ON (fleximport_semiro_course_import.teilnehmergruppe = fleximport_semiro_participant_import.teilnehmergruppe)\n WHERE `" . addslashes($dilp_kennung_feld) . "` = :user_dilp\n AND fleximport_semiro_course_import.name_veranstaltung = :name\n ");
$dilp_entry = DatafieldEntryModel::findOneBySQL("datafield_id = ? AND range_id = ? ", array($datafield->getId(), $user_id));
$statement->execute(array('user_dilp' => $dilp_entry['content'], 'name' => $object['name']));
$is_still_in_course = $statement->fetch(PDO::FETCH_COLUMN, 0);
if (!$is_still_in_course) {
$seminar->deleteMember($user_id);
}
$item->delete();
}
}
}
function callSafeguard($evalAction, $evalID = "", $showrangeID = NULL, $search = NULL, $referer = NULL)
{
global $perm, $auth, $user;
if (!($evalAction || $evalAction == "search")) {
return " ";
}
if (!$perm->have_studip_perm("tutor", $showrangeID) && $user->id != $showrangeID && !(isDeputyEditAboutActivated() && isDeputy($user->id, $showrangeID, true))) {
return $this->createSafeguard("ausruf", sprintf(_("Sie haben keinen Zugriff auf diesen Bereich.")));
}
$evalDB = new EvaluationDB();
$evalChanged = NULL;
$safeguard = " ";
/* Actions without any permissions ---------------------------------- */
switch ($evalAction) {
case "search_template":
$search = trim($search);
$templates = $evalDB->getPublicTemplateIDs($search);
if (strlen($search) < EVAL_MIN_SEARCHLEN) {
$report = EvalCommon::createReportMessage(sprintf(_("Bitte einen Suchbegriff mit mindestens %d Buchstaben eingeben."), EVAL_MIN_SEARCHLEN), EVAL_PIC_ERROR, EVAL_CSS_ERROR);
} elseif (count($templates) == 0) {
$report = EvalCommon::createReportMessage(_("Es wurden keine passenden öffentlichen Evaluationsvorlagen gefunden."), EVAL_PIC_ERROR, EVAL_CSS_ERROR);
} else {
$report = EvalCommon::createReportMessage(sprintf(_("Es wurde(n) %d passende öffentliche Evaluationsvorlagen gefunden."), count($templates)), EVAL_PIC_SUCCESS, EVAL_CSS_SUCCESS);
}
$safeguard .= $report->createContent();
return $safeguard;
case "export_request":
/* Check permissions ------------------------------------------- */
$haveNoPerm = YES;
$eval = new Evaluation($evalID, NULL, EVAL_LOAD_NO_CHILDREN);
$haveNoPerm = EvaluationObjectDB::getEvalUserRangesWithNoPermission($eval);
if ($haveNoPerm == YES) {
$report = EvalCommon::createReportMessage(_("Sie haben nicht die Berechtigung diese Evaluation zu exportieren."), EVAL_PIC_ERROR, EVAL_CSS_ERROR);
return $report->createContent();
}
/* -------------------------------------- end: check permissions */
/* Export evaluation ------------------------------------------- */
$exportManager = new EvaluationExportManagerCSV($evalID);
$exportManager->export();
/* -------------------------------------- end: export evaluation */
/* Create link ------------------------------------------------- */
$link = new HTML("a");
$link->addAttr('href', GetDownloadLink($exportManager->getTempFilename(), $exportManager->getFilename(), 2));
$link->addHTMLContent(GetFileIcon('csv')->asImg());
$link->addContent(_("auf diese Verknüpfung"));
/* -------------------------------------------- end: create link */
/* Create report ----------------------------------------------- */
if ($exportManager->isError()) {
$report = EvalCommon::createErrorReport($exportManager, _("Fehler beim Exportieren"));
} else {
$report = EvalCommon::createReportMessage(_("Die Daten wurden erfolgreich exportiert. Sie können die Ausgabedatei jetzt herunterladen."), EVAL_PIC_SUCCESS, EVAL_CSS_SUCCESS);
$report = $report->createContent();
$report .= sprintf(_("Bitte klicken Sie %s um die Datei herunter zu laden.") . "<br><br>", $link->createContent());
}
$safeguard .= $report;
/* ------------------------------------------ end: create report */
return $safeguard;
}
/* ----------------------------------- end: actions without permissions */
$eval = new Evaluation($evalID, NULL, EVAL_LOAD_NO_CHILDREN);
$evalName = htmlready($eval->getTitle());
/* Check for errors while loading ------------------------------------- */
if ($eval->isError()) {
EvalCommon::createErrorReport($eval);
return $this->createSafeguard("", EvalCommon::createErrorReport($eval));
}
/* -------------------------------------- end: errorcheck while loading */
/* Check for permissions in all ranges of the evaluation -------------- */
if (!$eval->isTemplate() && $user->id != $eval->getAuthorID()) {
$no_permisson = EvaluationObjectDB::getEvalUserRangesWithNoPermission($eval);
if ($no_permisson > 0) {
if ($no_permisson == 1) {
$no_permission_msg .= sprintf(_("Die Evaluation <b>%s</b> ist einem Bereich zugeordnet, für den Sie keine Veränderungsrechte besitzen."), $evalName);
} else {
$no_permission_msg .= sprintf(_("Die Evaluation <b>%s</b> ist %s Bereichen zugeordnet, für die Sie keine Veränderungsrechte besitzen."), $evalName, $no_permisson);
}
if ($evalAction != "save") {
$no_permission_msg .= " " . _("Der Besitzer wurde durch eine systeminterne Nachricht informiert.");
$sms = new messaging();
$sms->insert_message(sprintf(_("Benutzer **%s** hat versucht eine unzulässige Änderung an Ihrer Evaluation **%s** vorzunehmen."), get_username($auth->auth["uid"]), $eval->getTitle()), get_username($eval->getAuthorID()), "____%system%____", FALSE, FALSE, "1", FALSE, _("Versuchte Änderung an Ihrer Evaluation"));
}
}
} else {
if ($eval->isTemplate() && $user->id != $eval->getAuthorID() && $evalAction != "copy_public_template" && $evalAction != "search_showrange") {
$sms = new messaging();
$sms->insert_message(sprintf(_("Benutzer **%s** hat versucht eine unzulässige Änderung an Ihrem Template **%s** vorzunehmen."), get_username($auth->auth["uid"]), $eval->getTitle()), get_username($eval->getAuthorID()), "____%system%____", FALSE, FALSE, "1", FALSE, _("Versuchte Änderung an Ihrem Template"));
return $this->createSafeguard("ausruf", sprintf(_("Sie besitzen keine Rechte für das Tempate <b>%s</b>. Der Besitzer wurde durch eine systeminterne Nachricht informiert."), $evalName));
}
}
/* ----------------------------------------- end: check for permissions */
switch ($evalAction) {
case "share_template":
if ($eval->isShared()) {
$eval->setShared(NO);
$eval->save();
if ($eval->isError()) {
$safeguard .= $this->createSafeguard("", EvalCommon::createErrorReport($eval));
return $safeguard;
}
$safeguard .= $this->createSafeguard("ok", sprintf(_("Die Evaluationsvorlage <b>%s</b> kann jetzt nicht mehr von anderen Benutzern gefunden werden."), $evalName));
} else {
$eval->setShared(YES);
$eval->save();
if ($eval->isError()) {
$safeguard .= $this->createSafeguard("", EvalCommon::createErrorReport($eval));
return $safeguard;
}
$safeguard .= $this->createSafeguard("ok", sprintf(_("Die Evaluationsvorlage <b>%s</b> kann jetzt von anderen Benutzern gefunden werden."), $evalName));
}
break;
case "copy_public_template":
$eval = new Evaluation($evalID, NULL, EVAL_LOAD_ALL_CHILDREN);
$newEval = $eval->duplicate();
$newEval->setAuthorID($auth->auth["uid"]);
$newEval->setShared(NO);
$newEval->setStartdate(NULL);
$newEval->setStopdate(NULL);
$newEval->setTimespan(NULL);
$newEval->removeRangeIDs();
$newEval->save();
if ($newEval->isError()) {
$safeguard .= $this->createSafeguard("", EvalCommon::createErrorReport($newEval));
return $safeguard;
}
$safeguard .= $this->createSafeguard("ok", sprintf(_("Die öffentliche Evaluationsvorlage <b>%s</b> wurde zu den eigenen Evaluationsvorlagen kopiert."), $evalName));
break;
case "start":
if ($no_permission_msg) {
return $this->createSafeguard("ausruf", $no_permission_msg . "<br>" . _("Die Evaluation wurde nicht gestartet."));
}
$eval->setStartdate(time() - 500);
$eval->save();
if ($eval->isError()) {
$safeguard .= $this->createSafeguard("", EvalCommon::createErrorReport($eval));
return $safeguard;
}
$safeguard .= $this->createSafeguard("ok", sprintf(_("Die Evaluation <b>%s</b> wurde gestartet."), $evalName));
$evalChanged = YES;
break;
case "stop":
if ($no_permission_msg) {
return $this->createSafeguard("ausruf", $no_permission_msg . "<br>" . _("Die Evaluation wurde nicht beendet."));
}
$eval->setStopdate(time());
$eval->save();
if ($eval->isError()) {
EvalCommon::createErrorReport($eval);
$safeguard .= $this->createSafeguard("", EvalCommon::createErrorReport($eval));
return $safeguard;
}
$safeguard .= $this->createSafeguard("ok", sprintf(_("Die Evaluation <b>%s</b> wurde beendet."), $evalName));
$evalChanged = YES;
break;
case "continue":
if ($no_permission_msg) {
return $this->createSafeguard("ausruf", $no_permission_msg . "<br>" . _("Die Evaluation wurde nicht fortgesetzt."));
}
$eval->setStopdate(NULL);
$eval->setStartdate(time() - 500);
$eval->save();
if ($eval->isError()) {
$safeguard .= $this->createSafeguard("", EvalCommon::createErrorReport($eval));
return $safeguard;
}
$safeguard .= $this->createSafeguard("ok", sprintf(_("Die Evaluation <b>%s</b> wurde fortgesetzt."), $evalName));
$evalChanged = YES;
break;
case "restart_request":
if ($no_permission_msg) {
return $this->createSafeguard("ausruf", $no_permission_msg . "<br>" . _("Die Evaluation wurde nicht zurücksetzen."));
}
$safeguard .= $this->createSafeguard("ausruf", sprintf(_("Die Evaluation <b>%s</b> wirklich zurücksetzen? Dabei werden alle bisher abgegebenen Antworten gelöscht!"), $evalName), "restart_request", $evalID, $showrangeID, $referer);
break;
case "restart_confirmed":
if ($no_permission_msg) {
return $this->createSafeguard("ausruf", $no_permission_msg . "<br>" . _("Die Evaluation wurde nicht zurücksetzen."));
}
$eval = new Evaluation($evalID, NULL, EVAL_LOAD_ALL_CHILDREN);
$eval->resetAnswers();
$evalDB->removeUser($eval->getObjectID());
$eval->setStartdate(NULL);
$eval->setStopdate(NULL);
$eval->save();
if ($eval->isError()) {
$safeguard .= $this->createSafeguard("", EvalCommon::createErrorReport($eval));
return $safeguard;
}
$safeguard .= $this->createSafeguard("ok", sprintf(_("Die Evaluation <b>%s</b> wurde zurückgesetzt."), $evalName));
$evalChanged = YES;
break;
case "restart_aborted":
$safeguard .= $this->createSafeguard("ok", sprintf(_("Die Evaluation <b>%s</b> wurde nicht zurückgesetzt."), $evalName), "", "", "", $referer);
break;
case "copy_own_template":
$eval = new Evaluation($evalID, NULL, EVAL_LOAD_ALL_CHILDREN);
$newEval = $eval->duplicate();
$newEval->setShared(NO);
$newEval->save();
if ($newEval->isError()) {
$safeguard .= $this->createSafeguard("", EvalCommon::createErrorReport($newEval));
return $safeguard;
}
$safeguard .= $this->createSafeguard("ok", sprintf(_("Die Evaluationsvorlage <b>%s</b> wurde kopiert."), $evalName));
break;
case "delete_request":
if ($no_permission_msg) {
return $this->createSafeguard("ausruf", $no_permission_msg . "<br>" . _("Die Evaluation wurde nicht gelöscht."));
}
$text = $eval->isTemplate() ? sprintf(_("Die Evaluationsvorlage <b>%s </b>wirklich löschen?"), $evalName) : sprintf(_("Die Evaluation <b>%s </b>wirklich löschen?"), $evalName);
$safeguard .= $this->createSafeguard("ausruf", $text, "delete_request", $evalID, $showrangeID, $referer);
break;
case "delete_confirmed":
if ($no_permission_msg) {
return $this->createSafeguard("ausruf", $no_permission_msg . "<br>" . _("Die Evaluation wurde nicht gelöscht."));
}
$eval = new Evaluation($evalID, NULL, EVAL_LOAD_ALL_CHILDREN);
$eval->delete();
if ($eval->isError()) {
$safeguard .= $this->createSafeguard("", EvalCommon::createErrorReport($eval));
return $safeguard;
}
$text = $eval->isTemplate() ? _("Die Evaluationsvorlage <b>%s</b> wurde gelöscht.") : _("Die Evaluation <b>%s</b> wurde gelöscht.");
$safeguard .= $this->createSafeguard("ok", sprintf($text, $evalName), "", "", "", $referer);
$evalChanged = YES;
break;
case "delete_aborted":
$text = $eval->isTemplate() ? _("Die Evaluationsvorlage <b>%s</b> wurde nicht gelöscht.") : _("Die Evaluation <b>%s</b> wurde nicht gelöscht.");
$safeguard .= $this->createSafeguard("ok", sprintf($text, $evalName), "", "", "", $referer);
break;
case "unlink_delete_aborted":
$text = _("Die Evaluation <b>%s</b> wurde nicht verändert.");
$safeguard .= $this->createSafeguard("ok", sprintf($text, $evalName), "", "", "", $referer);
break;
case "unlink_and_move":
if ($no_permission_msg) {
return $this->createSafeguard("ausruf", $no_permission_msg . "<br>" . _("Die Evaluation wurde nicht ausgehängt und zu den eigenen Evaluationsvorlagen verschoben."));
}
$eval = new Evaluation($evalID, NULL, EVAL_LOAD_ALL_CHILDREN);
$eval->removeRangeIDs();
$eval->setAuthorID($auth->auth["uid"]);
$eval->resetAnswers();
$evalDB->removeUser($eval->getObjectID());
$eval->setStartdate(NULL);
$eval->setStopdate(NULL);
$eval->save();
if ($eval->isError()) {
$safeguard .= $this->createSafeguard("", EvalCommon::createErrorReport($eval));
return $safeguard;
}
$text = _("Die Evaluation <b>%s</b> wurde aus allen Bereichen ausgehängt und zu den eigenen Evaluationsvorlagen verschoben.");
$safeguard .= $this->createSafeguard("ok", sprintf($text, $evalName), "", "", "", $referer);
break;
case "created":
$safeguard .= $this->createSafeguard("ok", sprintf(_("Die Evaluation <b>%s</b> wurde angelegt."), $evalName));
break;
case "save2":
case "save":
$eval = new Evaluation($evalID, NULL, EVAL_LOAD_ALL_CHILDREN);
$update_message = sprintf(_("Die Evaluation <b>%s</b> wurde mit den Veränderungen gespeichert."), $evalName);
/* Timesettings ---------------------------------------------------- */
if (Request::option("startMode")) {
switch (Request::option("startMode")) {
case "manual":
$startDate = NULL;
break;
case "timeBased":
$startDate = EvalCommon::date2timestamp(Request::int("startDay"), Request::int("startMonth"), Request::int("startYear"), Request::int("startHour"), Request::int("startMinute"));
break;
case "immediate":
$startDate = time() - 1;
break;
}
if ($no_permission_msg && $eval->getStartdate != $startDate) {
$time_msg = $no_permission_msg . "<br>" . _("Die Einstellungen zur Startzeit wurden nicht verändert.");
}
}
if (Request::option("stopMode")) {
switch (Request::option("stopMode")) {
case "manual":
$stopDate = NULL;
$timeSpan = NULL;
break;
case "timeBased":
$stopDate = EvalCommon::date2timestamp(Request::int("stopDay"), Request::int("stopMonth"), Request::int("stopYear"), Request::int("stopHour"), Request::int("stopMinute"));
$timeSpan = NULL;
break;
case "timeSpanBased":
$stopDate = NULL;
$timeSpan = Request::get("timeSpan");
break;
}
if ($no_permission_msg && ($eval->getStopdate != $stopDate && $eval->getTimespan != $timeSpan)) {
$time_msg = $time_msg ? $time_msg . "<br>" : $no_permission_msg;
$time_msg .= _("Die Einstellungen zur Endzeit wurden nicht verändert.");
}
}
/* ----------------------------------------------- end: timesettings */
/* link eval to ranges --------------------------------------------- */
$link_range_Array = Request::optionArray("link_range");
if ($link_range_Array) {
$isTemplate = $eval->isTemplate();
if ($isTemplate) {
$newEval = $eval->duplicate();
if ($newEval->isError()) {
$safeguard .= $this->createSafeguard("", EvalCommon::createErrorReport($newEval));
return $safeguard;
}
$update_message = sprintf(_("Die Evaluationsvorlage <b>%s</b> wurde als Evaluation angelegt."), $evalName);
$newEval->setStartdate($startDate);
$newEval->setStopdate($stopDate);
$newEval->setTimespan($timeSpan);
$newEval->setShared(NO);
} else {
$newEval =& $eval;
}
$counter_linked = 0;
foreach ($link_range_Array as $link_rangeID => $v) {
if ($userid = get_userid($link_rangeID)) {
$link_rangeID = $userid;
}
$newEval->addRangeID($link_rangeID);
$counter_linked++;
}
if ($isTemplate) {
$newEval->save();
}
if ($newEval->isError()) {
$safeguard .= $this->createSafeguard("ausruf", _("Fehler beim Einhängen von Bereichen.") . EvalCommon::createErrorReport($newEval));
return $safeguard;
}
$message .= $message ? "<br>" : " ";
$message .= $counter_linked > 1 ? sprintf(_("Die Evaluation wurde in %s Bereiche eingehängt."), $counter_linked) : sprintf(_("Die Evaluation wurde in einen Bereich eingehängt."), $counter_linked);
}
/* ---------------------------------------- end: link eval to ranges */
/* copy eval to ranges --------------------------------------------- */
$copy_range_Array = Request::optionArray("copy_range");
if (!empty($copy_range_Array)) {
$counter_copy = 0;
foreach ($copy_range_Array as $copy_rangeID => $v) {
if ($userid = get_userid($copy_rangeID)) {
$copy_rangeID = $userid;
}
$newEval = $eval->duplicate();
if (Request::option("startMode")) {
$newEval->setStartdate($startDate);
}
if (Request::get("stopMode")) {
$newEval->setStopdate($stopDate);
$newEval->setTimespan($timeSpan);
}
$newEval->setShared(NO);
$newEval->removeRangeIDs();
$evalDB->removeUser($newEval->getObjectID());
$newEval->addRangeID($copy_rangeID);
$newEval->save();
$counter_copy++;
if ($newEval->isError()) {
$safeguard .= $this->createSafeguard("ausruf", _("Fehler beim Kopieren von Evaluationen in Bereiche.") . EvalCommon::createErrorReport($newEval));
return $safeguard;
}
}
$message .= $message ? "<br>" : " ";
$message .= $counter_copy > 1 ? sprintf(_("Die Evaluation wurde in %s Bereiche kopiert."), $counter_copy) : sprintf(_("Die Evaluation wurde in einen Bereich kopiert."), $counter_copy);
}
/* ------------------------------------------- end: copy eval to ranges */
/* unlink ranges ------------------------------------------------------- */
$remove_range_Array = Request::optionArray("remove_range");
if (!empty($remove_range_Array)) {
/* if all rangeIDs will be removed, so ask if it should be deleted -- */
if (sizeof($remove_range_Array) == $eval->getNumberRanges()) {
$text = _("Sie wollen die Evaluation <b>%s</b> aus allen ihr zugeordneten Bereichen aushängen.<br>Soll die Evaluation gelöscht oder zu Ihren eigenen Evaluationsvorlagen verschoben werden?");
$safeguard .= $this->createSafeguard("ausruf", sprintf($text, $evalName), "unlink_delete_request", $evalID, $showrangeID, $referer);
$update_message = NULL;
return $safeguard;
}
/* -------------------------------- end: ask if it should be deleted */
$no_permission_ranges = EvaluationObjectDB::getEvalUserRangesWithNoPermission($eval, YES);
$counter_no_permisson = 0;
if (is_array($no_permission_ranges)) {
foreach ($remove_range_Array as $remove_rangeID => $v) {
if ($userid = get_userid($remove_rangeID)) {
$remove_rangeID = $userid;
}
// no permisson to unlink this range
if (in_array($remove_rangeID, $no_permission_ranges)) {
$counter_no_permisson++;
}
}
}
// if there are no_permisson_ranges to unlink, return
if ($counter_no_permisson > 0) {
if ($counter_no_permisson == 1) {
$safeguard .= $this->createSafeguard("ausruf", _("Sie wollen die Evaluation aus einem Bereich aushängen, für den Sie keine Berechtigung besitzten.<br> Die Aktion wurde nicht ausgeführt."));
} else {
$safeguard .= $this->createSafeguard("ausruf", sprintf(_("Sie wollen die Evaluation aus %d Bereichen aushängen, für die Sie keine Berechtigung besitzten.<br> Die Aktion wurde nicht ausgeführt."), $counter_no_permisson));
}
return $safeguard;
}
reset($remove_range_Array);
$counter_copy = 0;
foreach ($remove_range_Array as $remove_rangeID => $v) {
if ($userid = get_userid($remove_rangeID)) {
$remove_rangeID = $userid;
}
// the current range will be removed
if ($showrangeID == $remove_rangeID) {
$current_range_removed = 1;
}
$eval->removeRangeID($remove_rangeID);
$counter_copy++;
}
if ($eval->isError()) {
$safeguard .= $this->createSafeguard("ausruf", _("Fehler beim Aushängen von Bereichen.") . EvalCommon::createErrorReport($eval));
return $safeguard;
}
$message .= $message ? "<br>" : " ";
$message .= $counter_copy > 1 ? sprintf(_("Die Evaluation wurde aus %s Bereichen ausgehängt."), $counter_copy) : sprintf(_("Die Evaluation wurde aus einem Bereich ausgehängt."), $counter_copy);
if ($eval->getNumberRanges() == 0) {
$message .= $message ? "<br>" : "";
$message .= _("Sie ist nun keinem Bereich mehr zugeordnet und wurde zu den eigenen Evaluationsvorlagen verschoben.");
$eval->setStartdate(NULL);
$eval->setStopdate(NULL);
$evalDB->removeUser($eval->getObjectID());
if ($eval->isError()) {
$safeguard .= $this->createSafeguard("ausruf", _("Fehler beim Kopieren von Evaluationen in Bereiche.") . EvalCommon::createErrorReport($newEval));
return $safeguard;
}
} else {
$no_permission_ranges = EvaluationObjectDB::getEvalUserRangesWithNoPermission($eval);
$number_of_ranges = $eval->getNumberRanges();
if ($number_of_ranges == $no_permission_ranges) {
$return["msg"] = $this->createSafeguard("ausruf", $message . "<br>" . sprintf(_("Sie haben die Evaluation <b>%s</b> aus allen ihren Bereichen ausgehängt."), $evalName));
$return["option"] = DISCARD_OPENID;
$eval->save();
if ($eval->isError()) {
$safeguard = $this->createSafeguard("ausruf", _("Fehler beim Aushängen einer Evaluationen aus allen Bereichen auf die Sie Zugriff haben.") . EvalCommon::createErrorReport($newEval));
return $safeguard;
}
return $return;
}
}
}
if ($eval->isTemplate()) {
if (empty($link_range) && empty($copy_range) && empty($remove_range)) {
$update_message = sprintf(_("Es wurden keine Veränderungen an der Evaluationsvorlage <b>%s</b> gespeichert."), $evalName);
}
} else {
// nothing changed
if (!Request::option('startMode') && !Request::option('stopMode') && empty($link_range) && empty($copy_range) && empty($remove_range)) {
$update_message = _("Es wurden keine Veränderungen gespeichert.");
}
// set new start date
if (Request::option("startMode") && !$time_msg) {
$eval->setStartDate($startDate);
if ($startDate != NULL && $startDate <= time() - 1) {
$message .= $message ? "<br>" : " ";
$message .= _("Die Evaluation wurde gestartet.");
}
}
// set new stop date
if (Request::get("stopMode") && !$time_msg) {
$eval->setStopDate($stopDate);
$eval->setTimeSpan($timeSpan);
if ($stopDate != NULL && $stopDate <= time() - 1 || $timeSpan != NULL && $eval->getStartdate() != NULL && $eval->getStartdate() + $timeSpan <= time() - 1) {
$message .= $message ? "<br>" : " ";
$message .= _("Die Evaluation wurde beendet.");
}
}
if ($eval->isError()) {
$safeguard .= $this->createSafeguard("", EvalCommon::createErrorReport($eval));
return $safeguard;
}
$eval->save();
}
$evalChanged = YES;
// start/endtime aren't saved, because of ranges with no permisson
if ($time_msg) {
$safeguard .= $this->createSafeguard("ausruf", $time_msg);
}
// everything is just fine so print the all messages
if ($update_message && !$time_msg) {
$safeguard .= $this->createSafeguard("ok", $update_message . "<br>" . $message);
} elseif ($time_msg && $message) {
$safeguard .= $this->createSafeguard("ok", $message);
}
break;
case "search_showrange":
case "search_range":
$search = Request::get("search");
if (EvaluationObjectDB::getGlobalPerm(YES) < 31) {
$safeguard = $this->createSafeguard("ausruf", _("Sie besitzen keine Berechtigung eine Suche durchzuführen."));
return $safeguard;
}
$results = $evalDB->search_range($search);
if (empty($search)) {
$safeguard .= $this->createSafeguard("ausruf", _("Bitte einen Suchbegriff eingeben."), $search);
} elseif (sizeof($results) == 0) {
$safeguard .= $this->createSafeguard("ausruf", sprintf(_("Es wurde kein Bereich gefunden, der den Suchbegriff <b>%s</b> enthält."), htmlReady($search)), $search);
} else {
$safeguard .= $this->createSafeguard("ok", sprintf(_("Es wurden %s Bereiche gefunden, die den Suchbegriff <b>%s</b> enthalten."), sizeof($results), htmlReady($search)), $search);
}
break;
case "check_abort_creation":
# check if the evaluation is new and not yet edited
$eval = new Evaluation($evalID, NULL, EVAL_LOAD_NO_CHILDREN);
$abort_creation = false;
if ($eval->getTitle() == _("Neue Evaluation") && $eval->getText() == "") {
# the evaluationen may be not edited yet ... so continue checking
$eval = new Evaluation($evalID, NULL, EVAL_LOAD_ALL_CHILDREN);
$number_of_childs = $eval->getNumberChildren();
$child = $eval->getNextChild();
if ($number_of_childs == 1 && $child && $child->getTitle() == _("Erster Gruppierungsblock") && $child->getChildren() == NULL && $child->getText() == "") {
$abort_creation = true;
}
}
if ($abort_creation != true) {
break;
}
# continue abort_creation
# continue abort_creation
case "abort_creation":
$eval = new Evaluation($evalID, NULL, EVAL_LOAD_ALL_CHILDREN);
$eval->delete();
// error_ausgabe
if ($eval->isError()) {
$safeguard .= $this->createSafeguard("", EvalCommon::createErrorReport($eval));
return $safeguard;
}
$safeguard .= $this->createSafeguard("ok", _("Die Erstellung einer Evaluation wurde abgebrochen."), "", "", "", $referer);
break;
case "nothing":
break;
default:
$safeguard .= $this->createSafeguard("ausruf", _("Fehler! Es wurde versucht, eine nicht vorhandene Aktion auszuführen."));
break;
}
/* Send SMS when eval has been modified by admin/root ----------------- */
if ($evalChanged && $eval->getAuthorID() != $auth->auth["uid"]) {
$sms = new messaging();
$sms->insert_message(sprintf(_("An Ihrer Evaluation \"%s\" wurden von %s Änderungen vorgenommen."), $eval->getTitle(), get_username($auth->auth["uid"])), get_username($eval->getAuthorID()), "____%system%____", FALSE, FALSE, "1");
}
/* ------------------------------------------------------ end: send SMS */
// the current range has been removed from the eval
if ($current_range_removed) {
$return["msg"] = $safeguard;
$return["option"] = DISCARD_OPENID;
return $return;
} else {
return $safeguard;
}
}
/**
* Imports a line of the table into the Stud.IP database if the check returns no errors.
* @param array $line : array of fields
* @return array : array('found' => true|false, 'errors' => "Error message", 'pk' => "primary key")
*/
public function importLine($line)
{
$plugin = $this->getPlugin();
$classname = $this['import_type'];
if (!$classname) {
return array();
}
$data = $this->getMappedData($line);
$pk = $this->getPrimaryKey($data);
//Last chance to quit:
$error = $this->checkLine($line, $data, $pk);
$output = array();
$object = new $classname($pk);
if (!$object->isNew()) {
$output['found'] = true;
$output['pk'] = $pk;
foreach ((array) $this['tabledata']['ignoreonupdate'] as $fieldname) {
unset($data[$fieldname]);
}
} else {
$output['found'] = false;
}
foreach ($data as $fieldname => $value) {
if ($value !== false && in_array($fieldname, $this->getTargetFields())) {
$object[$fieldname] = $value;
if ($classname === "User" && $fieldname === "password") {
$object[$fieldname] = UserManagement::getPwdHasher()->HashPassword($value);
}
}
}
if (method_exists($object, "getFullName")) {
$error['name'] = $output['name'] = $object->getFullName();
} elseif ($object->isField("name")) {
$error['name'] = $output['name'] = $object['name'];
} elseif ($object->isField("title")) {
$error['name'] = $output['name'] = $object['title'];
}
if ($error && $error['errors']) {
//exit here to have the name of the object in the log
return $error;
}
if ($plugin) {
$plugin->beforeUpdate($object, $line, $data);
}
$object->store();
$output['pk'] = (array) $object->getId();
//Dynamic special fields:
switch ($classname) {
case "Course":
//fleximport_dozenten
foreach ($data['fleximport_dozenten'] as $dozent_id) {
$seminar = new Seminar($object->getId());
$seminar->addMember($dozent_id, 'dozent');
}
//fleximport_related_institutes
if (!$data['fleximport_related_institutes']) {
$data['fleximport_related_institutes'] = array($object['institut_id']);
} else {
if (!in_array($object['institut_id'], $data['fleximport_related_institutes'])) {
$data['fleximport_related_institutes'][] = $object['institut_id'];
}
}
foreach ($data['fleximport_related_institutes'] as $institut_id) {
$insert = DBManager::get()->prepare("\n INSERT IGNORE INTO seminar_inst\n SET seminar_id = :seminar_id,\n institut_id = :institut_id\n ");
$insert->execute(array('seminar_id' => $object->getId(), 'institut_id' => $institut_id));
}
if ($this['tabledata']['simplematching']["fleximport_course_userdomains"]['column'] || in_array("fleximport_course_userdomains", $this->fieldsToBeDynamicallyMapped())) {
$statement = DBManager::get()->prepare("\n SELECT userdomain_id\n FROM seminar_userdomains\n WHERE seminar_id = ?\n ");
$statement->execute(array($object->getId()));
$olddomains = $statement->fetchAll(PDO::FETCH_COLUMN, 0);
foreach (array_diff($data['fleximport_user_inst'], $olddomains) as $to_add) {
$domain = new UserDomain($to_add);
$domain->addSeminar($object->getId());
}
foreach (array_diff($olddomains, $data['fleximport_user_inst']) as $to_remove) {
$domain = new UserDomain($to_remove);
$domain->removeSeminar($object->getId());
}
}
break;
case "User":
if ($this['tabledata']['simplematching']["fleximport_user_inst"]['column'] || in_array("fleximport_user_inst", $this->fieldsToBeDynamicallyMapped())) {
if ($object['perms'] !== "root") {
foreach ($data['fleximport_user_inst'] as $institut_id) {
$member = new InstituteMember(array($object->getId(), $institut_id));
$member['inst_perms'] = $object['perms'];
$member->store();
}
}
}
if ($this['tabledata']['simplematching']["fleximport_userdomains"]['column'] || in_array("fleximport_userdomains", $this->fieldsToBeDynamicallyMapped())) {
$olddomains = UserDomain::getUserDomainsForUser($object->getId());
foreach ($olddomains as $olddomain) {
if (!in_array($olddomain->getID(), (array) $data['fleximport_userdomains'])) {
$olddomain->removeUser($object->getId());
}
}
foreach ($data['fleximport_userdomains'] as $userdomain) {
$domain = new UserDomain($userdomain);
$domain->addUser($object->getId());
}
AutoInsert::instance()->saveUser($object->getId());
foreach ($data['fleximport_userdomains'] as $domain_id) {
if (!in_array($domain_id, $olddomains)) {
$welcome = FleximportConfig::get("USERDOMAIN_WELCOME_" . $domain_id);
if ($welcome) {
foreach ($object->toArray() as $field => $value) {
$welcome = str_replace("{{" . $field . "}}", $value, $welcome);
}
foreach ($line as $field => $value) {
$welcome = str_replace("{{" . $field . "}}", $value, $welcome);
}
if (strpos($welcome, "\n") === false) {
$subject = _("Willkommen!");
} else {
$subject = strstr($welcome, "\n", true);
$welcome = substr($welcome, strpos($welcome, "\n") + 1);
}
$messaging = new messaging();
$count = $messaging->insert_message($welcome, $object->username, '____%system%____', null, null, null, null, $subject, true, 'normal');
}
}
}
}
if ($this['tabledata']['simplematching']["fleximport_expiration_date"]['column'] || in_array("fleximport_expiration_date", $this->fieldsToBeDynamicallyMapped())) {
if ($data['fleximport_expiration_date']) {
UserConfig::get($object->getId())->store("EXPIRATION_DATE", $data['fleximport_expiration_date']);
} else {
UserConfig::get($object->getId())->delete("EXPIRATION_DATE");
}
}
if ($output['found'] === false && $data['fleximport_welcome_message'] !== "none") {
$user_language = getUserLanguagePath($object->getId());
setTempLanguage(false, $user_language);
if ($data['fleximport_welcome_message'] && FleximportConfig::get($data['fleximport_welcome_message'])) {
$message = FleximportConfig::get($data['fleximport_welcome_message']);
foreach ($data as $field => $value) {
$message = str_replace("{{" . $field . "}}", $value, $message);
}
foreach ($line as $field => $value) {
if (!in_array($field, $data)) {
$message = str_replace("{{" . $field . "}}", $value, $message);
}
}
if (strpos($message, "\n") === false) {
$subject = dgettext($user_language, "Anmeldung Stud.IP-System");
} else {
$subject = strstr($message, "\n", true);
$message = substr($message, strpos($message, "\n") + 1);
}
} else {
$Zeit = date("H:i:s, d.m.Y", time());
$this->user_data = array('auth_user_md5.username' => $object['username'], 'auth_user_md5.perms' => $object['perms'], 'auth_user_md5.Vorname' => $object['vorname'], 'auth_user_md5.Nachname' => $object['nachname'], 'auth_user_md5.Email' => $object['email']);
$password = $data['password'];
//this is the not hashed password in cleartext
include "locale/{$user_language}/LC_MAILS/create_mail.inc.php";
$message = $mailbody;
}
if ($message) {
$mail = new StudipMail();
$mail->addRecipient($object['email'], $object->getFullName());
$mail->setSubject($subject);
$mail->setBodyText($message);
$mail->setBodyHtml(formatReady($message));
if (Config::get()->MAILQUEUE_ENABLE) {
MailQueueEntry::add($mail);
} else {
$mail->send();
}
}
restoreLanguage();
}
break;
}
//Datafields:
$datafields = array();
switch ($classname) {
case "Course":
$datafields = Datafield::findBySQL("object_type = 'sem'");
break;
case "User":
$datafields = Datafield::findBySQL("object_type = 'user'");
break;
case "CourseMember":
$datafields = Datafield::findBySQL("object_type = 'usersemdata'");
break;
}
foreach ($datafields as $datafield) {
$fieldname = $datafield['name'];
if (isset($data[$fieldname])) {
$entry = new DatafieldEntryModel(array($datafield->getId(), $object->getId(), ""));
$entry['content'] = $data[$fieldname];
$entry->store();
}
}
if ($classname === "Course") {
if ($this['tabledata']['simplematching']["fleximport_studyarea"]['column'] || in_array("fleximport_studyarea", $this->fieldsToBeDynamicallyMapped())) {
//Studienbereiche:
$remove = DBManager::get()->prepare("\n DELETE FROM seminar_sem_tree\n WHERE seminar_id = :seminar_id\n ");
$remove->execute(array('seminar_id' => $object->getId()));
if ($GLOBALS['SEM_CLASS'][$GLOBALS['SEM_TYPE'][$data['status']]['class']]['bereiche']) {
foreach ($data['fleximport_studyarea'] as $sem_tree_id) {
$insert = DBManager::get()->prepare("\n INSERT IGNORE INTO seminar_sem_tree\n SET sem_tree_id = :sem_tree_id,\n seminar_id = :seminar_id\n ");
$insert->execute(array('sem_tree_id' => $sem_tree_id, 'seminar_id' => $object->getId()));
}
}
}
if ($this['tabledata']['simplematching']["fleximport_locked"]['column'] || in_array("fleximport_locked", $this->fieldsToBeDynamicallyMapped())) {
//Lock or unlock course
if ($data['fleximport_locked']) {
CourseSet::addCourseToSet(CourseSet::getGlobalLockedAdmissionSetId(), $object->getId());
} elseif (in_array($data['fleximport_locked'], array("0", 0)) && $data['fleximport_locked'] !== "") {
CourseSet::removeCourseFromSet(CourseSet::getGlobalLockedAdmissionSetId(), $object->getId());
}
}
$folder_exist = DBManager::get()->prepare("\n SELECT 1 FROM folder WHERE range_id = ?\n ");
$folder_exist->execute(array($object->getId()));
if (!$folder_exist->fetch()) {
$insert_folder = DBManager::get()->prepare("\n INSERT IGNORE INTO folder\n SET folder_id = MD5(CONCAT(:seminar_id, 'allgemeine_dateien')),\n range_id = :seminar_id,\n user_id = :user_id,\n name = :name,\n description = :description,\n mkdate = UNIX_TIMESTAMP(),\n chdate = UNIX_TIMESTAMP()\n ");
$insert_folder->execute(array('seminar_id' => $object->getId(), 'user_id' => $GLOBALS['user']->id, 'name' => _("Allgemeiner Dateiordner"), 'description' => _("Ablage für allgemeine Ordner und Dokumente der Veranstaltung")));
}
}
if ($plugin && !$object->isNew()) {
$plugin->afterUpdate($object, $line);
}
return $output;
}
/**
* Sends a message and redirects the user.
*/
public function send_action()
{
PageLayout::setTitle(_("Nachricht verschicken"));
if (Request::isPost() && count(array_filter(Request::getArray("message_to"))) && Request::submitted("message_body")) {
$messaging = new messaging();
$rec_uname = array();
foreach (Request::getArray("message_to") as $user_id) {
if ($user_id) {
$rec_uname[] = get_username($user_id);
}
}
$messaging->provisonal_attachment_id = Request::option("message_id");
$messaging->send_as_email = Request::int("message_mail");
$messaging->insert_message(Studip\Markup::purifyHtml(Request::get("message_body")), $rec_uname, $GLOBALS['user']->id, '', '', '', null, Request::get("message_subject"), "", 'normal', trim(Request::get("message_tags")) ?: null);
if (Request::option('answer_to')) {
$old_message = Message::find(Request::option('answer_to'));
if ($old_message) {
$old_message->originator->answered = 1;
$old_message->store();
}
}
PageLayout::postMessage(MessageBox::success(_("Nachricht wurde verschickt.")));
} else {
if (!count(array_filter(Request::getArray('message_to')))) {
PageLayout::postMessage(MessageBox::error(_('Sie haben nicht angegeben, wer die Nachricht empfangen soll!')));
}
}
}
/**
* The after filter handles the sending of private messages via email, if
* present. Also, if an action requires the user to be logged out, this is
* accomplished here.
*
* @param String $action Name of the action that has been invoked
* @param Array $args Arguments of the action
*/
public function after_filter($action, $args)
{
if ($this->restricted && count($this->private_messages) > 0) {
setTempLanguage($this->user->user_id);
$message = _("Ihre persönliche Seite wurde von Admin verändert.\n " . "Folgende Veränderungen wurden vorgenommen:\n \n") . '- ' . implode("\n- ", $this->private_messages);
$subject = _('Systemnachricht:') . ' ' . _('Profil verändert');
restoreLanguage();
$messaging = new messaging();
$messaging->insert_message($message, $this->user->username, '____%system%____', null, null, true, '', $subject);
}
// Check whether the user should be logged out, the token is
// neccessary since the user could reload the page and will be logged
// out immediately after, resulting in a login/logout-loop.
$should_logout = $action === 'logout' && $this->flash['logout-token'] === Request::get('token');
if ($should_logout) {
$GLOBALS['sess']->delete();
$GLOBALS['auth']->logout();
}
parent::after_filter($action, $args);
if ($should_logout) {
$GLOBALS['user']->set_last_action(time() - 15 * 60);
}
}
public function addMember($user_id, $accepted = null, $consider_contingent = null, $cmd = 'add_user')
{
global $perm, $SEM_CLASS, $SEM_TYPE;
$user = UserModel::getUser($user_id);
$messaging = new messaging();
$status = 'autor';
// insert
$copy_course = $accepted || $consider_contingent ? TRUE : FALSE;
$admission_user = insert_seminar_user($this->course_id, $user_id, $status, $copy_course, $consider_contingent, true);
// create fullname of user of given user informations
$fullname = $user['Vorname'] . ' ' . $user['Nachname'];
if ($admission_user) {
setTempLanguage($user_id);
if ($cmd == 'add_user') {
$message = sprintf(_('Sie wurden vom einem/einer %s oder Admin
in die Veranstaltung **%s** eingetragen.'), get_title_for_status('dozent', 1), $this->course_title);
} else {
if (!$accepted) {
$message = sprintf(_('Sie wurden vom einem/einer %s oder Admin
aus der Warteliste in die Veranstaltung **%s** aufgenommen und sind damit zugelassen.'), get_title_for_status('dozent', 1), $this->course_title);
} else {
$message = sprintf(_('Sie wurden von einem/einer %s oder Admin vom Status
**vorläufig akzeptiert** auf "**teilnehmend** in der Veranstaltung **%s**
hochgestuft und sind damit zugelassen.'), get_title_for_status('dozent', 1), $this->course_title);
}
}
restoreLanguage();
$messaging->insert_message($message, $user['username'], '____%system%____', FALSE, FALSE, '1', FALSE, sprintf('%s %s', _('Systemnachricht:'), _('Eintragung in Veranstaltung')), TRUE);
}
//Warteliste neu sortieren
renumber_admission($this->course_id);
if ($admission_user) {
if ($cmd == "add_user") {
$msg = MessageBox::success(sprintf(_('%s wurde in die Veranstaltung mit dem Status
<b>%s</b> eingetragen.'), $fullname, $status));
} else {
if (!$accepted) {
$msg = MessageBox::success(sprintf(_('%s wurde aus der Anmelde bzw. Warteliste
mit dem Status <b>%s</b> in die Veranstaltung eingetragen.'), $fullname, $status));
} else {
$msg = MessageBox::success(sprintf(_('%s wurde mit dem Status <b>%s</b>
endg?ltig akzeptiert und damit in die Veranstaltung aufgenommen.'), $fullname, $status));
}
}
} else {
if ($consider_contingent) {
$msg = MessageBox::error(_('Es stehen keine weiteren Plätze mehr im Teilnehmerkontingent zur Verfügung.'));
} else {
$msg = MessageBox::error(_('Beim Eintragen ist ein Fehler aufgetreten.
Bitte versuchen Sie es erneut oder wenden Sie sich an einen Systemadministrator'));
}
}
return $msg;
}
public static function send($sender, $recipients, $subject, $message)
{
$messaging = new \messaging();
$result = $messaging->insert_message($message, $recipients, $sender, time(), $message_id = md5(uniqid('message', true)), false, '', $subject);
return $result ? self::find($message_id) : null;
}
/**
* Old version of CSV import (copy and paste from teilnehmer.php
* @return type
* @throws AccessDeniedException
*/
public function set_autor_csv_action()
{
// Security Check
if (!$this->is_tutor) {
throw new AccessDeniedException('Sie haben leider keine ausreichende Berechtigung, um auf diesen Bereich von Stud.IP zuzugreifen.');
}
CSRFProtection::verifyUnsafeRequest();
// prepare CSV-Lines
$messaging = new messaging();
$csv_request = preg_split('/(\\n\\r|\\r\\n|\\n|\\r)/', trim(Request::get('csv_import')));
$csv_mult_founds = array();
$csv_count_insert = 0;
$csv_count_multiple = 0;
$datafield_id = null;
if (Request::get('csv_import_format') && !in_array(Request::get('csv_import_format'), words('realname username'))) {
foreach (DataField::getDataFields('user', 1 | 2 | 4 | 8, true) as $df) {
if ($df->accessAllowed() && in_array($df->getId(), $GLOBALS['TEILNEHMER_IMPORT_DATAFIELDS']) && $df->getId() == Request::quoted('csv_import_format')) {
$datafield_id = $df->getId();
break;
}
}
}
if (Request::get('csv_import')) {
// remove duplicate users from csv-import
$csv_lines = array_unique($csv_request);
$csv_count_contingent_full = 0;
foreach ($csv_lines as $csv_line) {
$csv_name = preg_split('/[,\\t]/', substr($csv_line, 0, 100), -1, PREG_SPLIT_NO_EMPTY);
$csv_nachname = trim($csv_name[0]);
$csv_vorname = trim($csv_name[1]);
if ($csv_nachname) {
if (Request::quoted('csv_import_format') == 'realname') {
$csv_users = $this->members->getMemberByIdentification($csv_nachname, $csv_vorname);
} elseif (Request::quoted('csv_import_format') == 'username') {
$csv_users = $this->members->getMemberByUsername($csv_nachname);
} else {
$csv_users = $this->members->getMemberByDatafield($csv_nachname, $datafield_id);
}
}
// if found more then one result to given name
if (count($csv_users) > 1) {
// if user have two accounts
$csv_count_present = 0;
foreach ($csv_users as $row) {
if ($row['is_present']) {
$csv_count_present++;
} else {
$csv_mult_founds[$csv_line][] = $row;
}
}
if (is_array($csv_mult_founds[$csv_line])) {
$csv_count_multiple++;
}
} elseif (count($csv_users) > 0) {
$row = reset($csv_users);
if (!$row['is_present']) {
$consider_contingent = Request::option('consider_contingent_csv');
if (insert_seminar_user($this->course_id, $row['user_id'], 'autor', isset($consider_contingent), $consider_contingent)) {
$csv_count_insert++;
setTempLanguage($this->user_id);
$message = sprintf(_('Sie wurden in die Veranstaltung **%s** eingetragen.'), $this->course_title);
restoreLanguage();
$messaging->insert_message($message, $row['username'], '____%system%____', FALSE, FALSE, '1', FALSE, sprintf('%s %s', _('Systemnachricht:'), _('Eintragung in Veranstaltung')), TRUE);
} elseif (isset($consider_contingent)) {
$csv_count_contingent_full++;
}
} else {
$csv_count_present++;
}
} else {
// not found
$csv_not_found[] = stripslashes($csv_nachname) . ($csv_vorname ? ', ' . stripslashes($csv_vorname) : '');
}
}
}
$selected_users = Request::getArray('selected_users');
if (!empty($selected_users) && count($selected_users) > 0) {
foreach ($selected_users as $selected_user) {
if ($selected_user) {
if (insert_seminar_user($this->course_id, get_userid($selected_user), 'autor', isset($consider_contingent), $consider_contingent)) {
$csv_count_insert++;
setTempLanguage($this->user_id);
if ($GLOBALS['SEM_CLASS'][$GLOBALS['SEM_TYPE'][$_SESSION['SessSemName']['art_num']]['class']]['workgroup_mode']) {
$message = sprintf(_('Sie wurden manuell in die Veranstaltung **%s** eingetragen.'), $this->course_title);
} else {
$message = sprintf(_('Sie wurden manuell in die Veranstaltung **%s** eingetragen.'), $this->course_title);
}
restoreLanguage();
$messaging->insert_message($message, $selected_user, '____%system%____', FALSE, FALSE, '1', FALSE, sprintf('%s %s', _('Systemnachricht:'), _('Eintragung in Veranstaltung')), TRUE);
} elseif (isset($consider_contingent)) {
$csv_count_contingent_full++;
}
}
}
}
// no results
if (!sizeof($csv_lines) && !sizeof($selected_users)) {
PageLayout::postMessage(MessageBox::error(_("Niemanden gefunden!")));
}
if ($csv_count_insert) {
PageLayout::postMessage(MessageBox::success(sprintf(_('%s Personen in die Veranstaltung
eingetragen!'), $csv_count_insert)));
}
if ($csv_count_present) {
PageLayout::postMessage(MessageBox::info(sprintf(_('%s Personen waren bereits in der Veranstaltung
eingetragen!'), $csv_count_present)));
}
// redirect to manual assignment
if ($csv_mult_founds) {
PageLayout::postMessage(MessageBox::info(sprintf(_('%s Personen konnten <b>nicht eindeutig</b>
zugeordnet werden! Nehmen Sie die Zuordnung bitte manuell vor.'), $csv_count_multiple)));
$this->flash['csv_mult_founds'] = $csv_mult_founds;
$this->redirect('course/members/csv_manual_assignment');
return;
}
if (count($csv_not_found) > 0) {
PageLayout::postMessage(MessageBox::error(sprintf(_('%s konnten <b>nicht</b> zugeordnet werden!'), htmlReady(join(',', $csv_not_found)))));
}
if ($csv_count_contingent_full) {
PageLayout::postMessage(MessageBox::error(sprintf(_('%s Personen konnten <b>nicht</b> zugeordnet werden,
da das ausgewählte Kontingent keine freien Plätze hat.'), $csv_count_contingent_full)));
}
$this->redirect('course/members/index');
}
public static function sendSystemMessage($recipient, $message_title, $message_body)
{
$m = new messaging();
$user = User::toObject($recipient);
return $m->insert_message($message_body, $user['username'], '____%system%____', FALSE, FALSE, '1', FALSE, $message_title);
}
/**
* This function updates an admission procedure
*
* The function checks, if user could be insert to the seminar.
* The User gets a message, if he is inserted to the seminar
*
* @param string seminar_id the seminar_id of the seminar to calculate
* @param boolean send_message should a system-message be send?
*
*/
function normal_update_admission($seminar_id, $send_message = TRUE)
{
$messaging=new messaging;
//Daten holen / Abfrage ob ueberhaupt begrenzt
$seminar = Seminar::GetInstance($seminar_id);
if($seminar->isAdmissionEnabled()){
$sem_preliminary = ($seminar->admission_prelim == 1);
$cs = $seminar->getCourseSet();
//Veranstaltung einfach auffuellen (nach Lostermin und Ende der Kontingentierung)
if (!$seminar->admission_disable_waitlist_move && $cs->hasAlgorithmRun()) {
//anzahl der freien Plaetze holen
$count = (int)$seminar->getFreeAdmissionSeats();
//Studis auswaehlen, die jetzt aufsteigen koennen
$query = "SELECT user_id, username
FROM admission_seminar_user
LEFT JOIN auth_user_md5 USING (user_id)
WHERE seminar_id = ? AND status = 'awaiting'
ORDER BY position
LIMIT " . (int)$count;
$statement = DBManager::get()->prepare($query);
$statement->execute(array($seminar->getId()));
$temp = $statement->fetchAll(PDO::FETCH_ASSOC);
foreach ($temp as $row) {
//ok, here ist the "colored-group" meant (for grouping on meine_seminare), not the grouped seminars as above!
$group = select_group($seminar->getSemesterStartTime());
if (!$sem_preliminary) {
$query = "INSERT INTO seminar_user
(user_id, Seminar_id, status, gruppe, mkdate)
VALUES (?, ?, 'autor', ?, UNIX_TIMESTAMP())";
$statement = DBManager::get()->prepare($query);
$statement->execute(array(
$row['user_id'],
$seminar->getId(),
$group
));
$affected = $statement->rowCount();
NotificationCenter::postNotification('UserDidEnterCourse', $seminar->getId(), $row['user_id']);
} else {
$query = "UPDATE admission_seminar_user
SET status = 'accepted'
WHERE user_id = ? AND seminar_id = ?";
$statement = DBManager::get()->prepare($query);
$statement->execute(array(
$row['user_id'],
$seminar->getId()
));
$affected = $statement->rowCount();
}
if ($affected > 0) {
$log_message = 'Wurde automatisch aus der Warteliste in die Veranstaltung eingetragen.';
StudipLog::log('SEM_USER_ADD', $seminar->getId(), $row['user_id'], $sem_preliminary ? 'accepted' : 'autor', $log_message);
if (!$sem_preliminary) {
$query = "DELETE FROM admission_seminar_user
WHERE user_id = ? AND seminar_id = ?";
$statement = DBManager::get()->prepare($query);
$statement->execute(array(
$row['user_id'],
$seminar->getId()
));
$affected = $statement->rowCount();
} else {
$affected = 0;
}
//User benachrichtigen
if (($sem_preliminary || $affected > 0) && $send_message) {
setTempLanguage($row['user_id']);
if (!$sem_preliminary) {
$message = sprintf (_('Sie sind in die Veranstaltung **%s (%s)** eingetragen worden, da für Sie ein Platz frei geworden ist. Ab sofort finden Sie die Veranstaltung in der Übersicht Ihrer Veranstaltungen. Damit sind Sie auch für die Präsenzveranstaltung zugelassen.'), $seminar->getName(), $seminar->getFormattedTurnus(true));
} else {
$message = sprintf (_('Sie haben den Status vorläufig akzeptiert in der Veranstaltung **%s (%s)** erhalten, da für Sie ein Platz freigeworden ist.'), $seminar->getName(), $seminar->getFormattedTurnus(true));
}
$subject = sprintf(_("Teilnahme an der Veranstaltung %s"),$seminar->getName());
restoreLanguage();
$messaging->insert_message($message, $row['username'], '____%system%____', FALSE, FALSE, '1', FALSE, $subject, true);
}
}
}
//Warteposition der restlichen User neu eintragen
renumber_admission($seminar_id, FALSE);
}
$seminar->restore();
}
}
/**
* Notifies the user with Stud.IP-message that/he/she was mentioned in a
* blubber-posting.
* @param type $posting
*/
public function mention($posting)
{
$messaging = new messaging();
setTempLanguage($this->getId());
$url = $GLOBALS['ABSOLUTE_URI_STUDIP'] . "plugins.php/blubber/streams/thread/" . $posting['root_id'] . ($posting['context_type'] === "course" ? '?cid=' . $posting['Seminar_id'] : "");
$body = sprintf(gettext("%s hat Sie in einem Blubber erwähnt. Zum Beantworten klicken auf Sie auf folgenen Link:\n\n%s\n"), get_fullname(), $url);
if ($posting['context_type'] === "course" && !$GLOBALS['perm']->have_studip_perm("user", $posting['Seminar_id'], $this->getId())) {
$body .= "\n\n" . _("Sie sind noch kein Mitglied der zugehörigen Veranstaltung. Melden Sie sich erst hier an, damit Sie den Blubber sehen können: ") . ($GLOBALS['SEM_CLASS'][$GLOBALS['SEM_TYPE'][Course::find($posting['Seminar_id'])->status]['class']]['studygroup_mode'] ? $GLOBALS['ABSOLUTE_URI_STUDIP'] . "dispatch.php/course/studygroup/details/" . $posting['Seminar_id'] : $GLOBALS['ABSOLUTE_URI_STUDIP'] . "dispatch.php/course/details?sem_id=" . $posting['Seminar_id']);
}
$mention_text = _("Sie wurden erwähnt.");
restoreLanguage();
$messaging->insert_message($body, $this['username'], $GLOBALS['user']->id, null, null, null, null, $mention_text);
}
private function sendEditMail($blubber, $subject, $message)
{
$messaging = new \messaging();
setTempLanguage($blubber['user_id']);
$messaging->insert_message($message, get_username($blubber['user_id']), $GLOBALS['user']->id, null, null, null, null, $subject);
restoreLanguage();
}
if ($reqObj->getMetadateId()) {
$cycle = SeminarCycleDate::find($reqObj->getMetadateId());
$message .= "\n\n". _("Betroffene Zeit:") . "\n" . $cycle->toString('full');
}
// fetch the names of the lecutrers to display them in the message
foreach($semObj->getMembers('dozent') as $dozenten){
$title[] = $dozenten['Nachname'];
}
if($semObj->seminar_number) $title[] = $semObj->seminar_number;
$title[] = mila($semObj->getName(),30);
$reqObj->setReplyComment($decline_message);
$reqObj->store();
foreach ($users as $userid) {
setTempLanguage($userid);
$messaging->insert_message($message, get_username($userid), $user->id, FALSE, FALSE, FALSE, FALSE,
_("Raumanfrage abgelehnt:") .' '. implode(', ', $title), TRUE, 'high');
restoreLanguage();
}
}
// the room-request has been resolved
else {
// create appropriate message
if ($semObj->seminar_number)
$message = sprintf (_("Ihre Raumanfrage zur Veranstaltung %s (%s) wurde bearbeitet.")." \n"._("Für folgende Belegungszeiten wurde der jeweils angegebene Raum gebucht:")."\n\n", $semObj->getName(), $semObj->seminar_number);
else
$message = sprintf (_("Ihre Raumanfrage zur Veranstaltung %s wurde bearbeitet.")." \n"._("Für folgende Belegungszeiten wurde der jeweils angegebene Raum gebucht:")."\n\n", $semObj->getName());
//send the message into stud.ip message system
// only if there are assigned dates
static function send($empf, $betreff, $nachricht, $abs)
{
//Nachricht Objekt erstellen
$message = new \messaging();
// wenn empfänger kein array, mach ein draus
if (is_array($empf)) {
$empf_array = array(0 => $empf);
} else {
$empf_array = $empf;
}
//senden der Nachricht
$send = $message->insert_message(mysql_escape_string(utf8_decode($nachricht)), mysql_escape_string($empf_array), mysql_escape_string($abs), '', '', '', '', mysql_escape_string(utf8_decode($betreff)), '', 'normal');
if ($send > 0) {
return true;
}
return false;
}
