diff options
Diffstat (limited to 'app/controllers/course/connectedstudygroups.php')
| -rw-r--r-- | app/controllers/course/connectedstudygroups.php | 315 |
1 files changed, 315 insertions, 0 deletions
diff --git a/app/controllers/course/connectedstudygroups.php b/app/controllers/course/connectedstudygroups.php new file mode 100644 index 0000000..9ef6b92 --- /dev/null +++ b/app/controllers/course/connectedstudygroups.php @@ -0,0 +1,315 @@ +<?php + +class Course_ConnectedstudygroupsController extends AuthenticatedController +{ + + public function before_filter(&$action, &$args) + { + parent::before_filter($action, $args); + + if (!$GLOBALS['perm']->have_studip_perm('tutor', Context::getId())) { + throw new AccessDeniedException(); + } + } + + public function index_action() + { + Navigation::activateItem('/course/admin/connectedstudygroups'); + $this->connected = StudygroupCourse::findBySQL( + 'INNER JOIN seminare ON (seminare.Seminar_id = studygroup_courses.studygroup_id) WHERE studygroup_courses.course_id = ? ORDER BY seminare.name ASC', + [ + Context::getId() + ] + ); + $this->proposals = StudygroupCourseProposal::findBySQL( + 'INNER JOIN seminare ON (seminare.Seminar_id = studygroup_courses_proposals.studygroup_id) WHERE studygroup_courses_proposals.course_id = ? ORDER BY seminare.name ASC', + [ + Context::getId() + ] + ); + $this->buildSidebar(); + + } + + public function connect_action($course_id = null) + { + Navigation::activateItem('/course/admin/connectedstudygroups'); + PageLayout::setTitle(_('Studiengruppe suchen und verknüpfen')); + if (Request::isPost() && (Request::option('course_id') || $course_id)) { + CSRFProtection::verifySecurityToken(); + $course_id = $course_id ?? Request::option('course_id'); + $proposal = StudygroupCourseProposal::findOneBySQL('course_id = ? AND studygroup_id = ?', [ + Context::getId(), + $course_id + ]); + if ($GLOBALS['perm']->have_studip_perm('tutor', $course_id) || $proposal['proposed_from'] === 'studygroup') { + $connection = StudygroupCourse::findOneBySQL('course_id = ? AND studygroup_id = ?', [ + Context::getId(), + $course_id + ]); + if (!$connection) { + $connection = new StudygroupCourse(); + $connection['course_id'] = Context::getId(); + $connection['studygroup_id'] = $course_id; + $connection->store(); + } + if ($proposal) { + if ($proposal['proposed_from'] === 'studygroup') { + $statement = DBManager::get()->prepare(" + SELECT `username`, `user_id` + FROM `auth_user_md5` + INNER JOIN `seminar_user` USING (`user_id`) + WHERE `seminar_user`.`Seminar_id` = ? AND `seminar_user`.`status` IN ('tutor', 'dozent') + "); + $statement->execute([$course_id]); + $messaging = new messaging(); + + foreach ($statement->fetchAll(PDO::FETCH_ASSOC) as $user_data) { + setTempLanguage($user_data['user_id']); + $messaging->insert_message( + sprintf( + _('Ihr Vorschlag, die Studiengruppe „%1$s“ mit der Veranstaltung „%2$s“ zu verknüpfen, wurde angenommen.'), + Context::get()->getFullname(), + Course::find($course_id)->getFullname() + ), + $user_data['username'], + '____%system%____', + '', + '', + '', + '', + _('Verknüpfungsvorschlag angenommen'), + '', + 'normal', + ['Studiengruppe'] + ); + restoreLanguage(); + } + } + $proposal->delete(); + } + PageLayout::postSuccess(_('Veranstaltung wurde verknüpft.')); + } else { + //send message: + if (!$proposal) { + $proposal = new StudygroupCourseProposal(); + $proposal['course_id'] = Context::getId(); + $proposal['studygroup_id'] = $course_id; + $proposal['proposed_from'] = 'course'; + $proposal['user_id'] = User::findCurrent()->id; + $proposal->store(); + + $statement = DBManager::get()->prepare(" + SELECT `username`, `user_id` + FROM `auth_user_md5` + INNER JOIN `seminar_user` USING (`user_id`) + WHERE `seminar_user`.`Seminar_id` = ? AND `seminar_user`.`status` IN ('tutor', 'dozent') + "); + $statement->execute([$course_id]); + $messaging = new messaging(); + $oldbase = URLHelper::setBaseURL($GLOBALS['ABSOLUTE_URI_STUDIP']); + + foreach ($statement->fetchAll(PDO::FETCH_ASSOC) as $user_data) { + setTempLanguage($user_data['user_id']); + $messaging->insert_message( + sprintf( + _('Es wurde vorgeschlagen, die Veranstaltung „%1$s“ mit Ihrer Studiengruppe „%2$s“ zu verknüpfen. Sie können den Vorschlag unter folgendem Link annehmen oder ablehnen:'), + Context::get()->getFullname(), + Course::find($course_id)->getFullname() + )."\n\n".URLHelper::getURL('dispatch.php/course/connectedcourses/index', ['cid' => $course_id]), + $user_data['username'], + '____%system%____', + '', + '', + '', + '', + _('Verknüpfung Ihrer Studiengruppe zu einer Veranstaltung'), + '', + 'normal', + ['Studiengruppe'] + ); + restoreLanguage(); + } + + URLHelper::setBaseURL($oldbase); + } + PageLayout::postSuccess(_('Antrag wurde gestellt.')); + } + $this->redirect('course/connectedstudygroups/index'); + return; + } + + $connected = StudygroupCourse::findBySQL( + 'INNER JOIN seminare ON (seminare.Seminar_id = studygroup_courses.studygroup_id) WHERE studygroup_courses.course_id = ? ORDER BY seminare.name ASC', + [ + Context::getId() + ] + ); + $proposals = StudygroupCourseProposal::findBySQL( + 'INNER JOIN seminare ON (seminare.Seminar_id = studygroup_courses_proposals.course_id) WHERE studygroup_courses_proposals.course_id = ? ORDER BY seminare.name ASC', + [ + Context::getId() + ] + ); + $already_covered = array_map(function ($c) { + return $c->course_id; + }, $connected); + $already_covered = $already_covered + array_map(function ($c) { + return $c->course_id; + }, $proposals); + + $studygroup_ids = []; + foreach (SemClass::getClasses() as $sem_class) { + if ($sem_class['studygroup_mode'] > 0) { + foreach ($sem_class->getSemTypes() as $sem_type) { + $studygroup_ids[] = $sem_type['id']; + } + } + } + + if (Request::get('search') && Request::get('search') != 1) { + $query = SQLQuery::table('seminare') + ->where('search', '`name` LIKE :search', ['search' => '%' . Request::get('search') . '%']) + ->where( + 'studygroups', + '`seminare`.`status` IN (:sem_type_ids)', + ['sem_type_ids' => $studygroup_ids] + ) + ->groupBy('`seminare`.`Seminar_id`'); + if (count($already_covered) > 0) { + $query->where( + 'ignore', + '`seminare`.`Seminar_id` NOT IN (:ignore)', + ['ignore' => $already_covered] + ); + } + if (!empty(Request::get('semester_id'))) { + $query->join( + 'semester_courses', + 'semester_courses', + '`semester_courses`.`course_id` = `seminare`.`Seminar_id`', + 'LEFT JOIN' + ); + $query->where( + 'semester_id', + 'semester_courses.semester_id = :semester_id OR semester_courses.semester_id IS NULL', + ['semester_id' => Request::get('semester_id')] + ); + } + $this->searchresults = $query->fetchAll(Course::class); + } else { + + $this->my_studygroups = []; + if (!$GLOBALS['perm']->have_perm('admin')) { + $this->my_studygroups = Course::findBySQL('INNER JOIN `seminar_user` USING (`Seminar_id`) + WHERE `seminar_user`.`user_id` = :user_id + AND `seminare`.`status` IN (:studygroup_sem_types) + AND `seminare`.`Seminar_id` NOT IN (:ignore) + ORDER BY `seminare`.`name` ASC ', + [ + 'user_id' => User::findCurrent()->id, + 'studygroup_sem_types' => $studygroup_ids, + 'ignore' => count($already_covered) ? $already_covered : '' + ]); + foreach ($this->my_studygroups as $my_studygroup) { + $already_covered[] = $my_studygroup->id; + } + } + + //get all studygroups with a lot of members in the current course: + $statement = DBManager::get()->prepare(" + SELECT `seminare`.* + FROM `seminar_user` + INNER JOIN `seminare` ON (`seminare`.`Seminar_id` = `seminar_user`.`Seminar_id`) + LEFT JOIN `seminar_user` AS `su2` ON (`su2`.`user_id` = `seminar_user`.`user_id` AND `su2`.`Seminar_id` = :course_id) + LEFT JOIN `studygroup_courses` ON (`studygroup_courses`.`studygroup_id` = `seminare`.`Seminar_id` AND `studygroup_courses`.`course_id` = `su2`.`Seminar_id`) + WHERE `seminare`.`status` IN (:studygroup_sem_types) + AND `studygroup_courses`.`id` IS NULL + GROUP BY `seminare`.`Seminar_id` + HAVING COUNT(`seminar_user`.`user_id`) > 1 + ORDER BY COUNT(`seminar_user`.`user_id`) DESC + LIMIT 20 + "); + $statement->execute([ + 'course_id' => Context::getId(), + 'studygroup_sem_types' => $studygroup_ids + ]); + $this->suggestions = $statement->fetchAll(PDO::FETCH_ASSOC); + $this->suggestions = array_map(function ($d) { + return Course::buildExisting($d); + }, $this->suggestions); + } + } + + public function remove_action($course_id) + { + if (Request::isPost() && $course_id) { + CSRFProtection::verifySecurityToken(); + $connection = StudygroupCourse::deleteBySQL('course_id = ? AND studygroup_id = ?', [ + Context::getId(), + $course_id + ]); + PageLayout::postSuccess(_('Verknüpfung zu der Studiengruppe wurde aufgehoben.')); + } + $this->redirect('course/connectedstudygroups/index'); + } + + public function decline_action(StudygroupCourseProposal $proposal) + { + if (Request::isPost()) { + CSRFProtection::verifySecurityToken(); + if ($GLOBALS['perm']->have_studip_perm('tutor', $proposal['course_id']) || $GLOBALS['perm']->have_studip_perm('tutor', $proposal['studygroup_id'])) { + if ($proposal['proposed_from'] === 'studygroup') { + PageLayout::postSuccess(_('Vorschlag wurde abgewiesen.')); + $statement = DBManager::get()->prepare(" + SELECT `username`, `user_id` + FROM `auth_user_md5` + INNER JOIN `seminar_user` USING (`user_id`) + WHERE `seminar_user`.`Seminar_id` = ? AND `seminar_user`.`status` IN ('tutor', 'dozent') + "); + $statement->execute([$proposal['studygroup_id']]); + $messaging = new messaging(); + + foreach ($statement->fetchAll(PDO::FETCH_ASSOC) as $user_data) { + setTempLanguage($user_data['user_id']); + $messaging->insert_message( + sprintf( + _('Ihr Vorschlag, die Studiengruppe „%1$s“ mit der Veranstaltung „%2$s“ zu verknüpfen, wurde leider abgewiesen.'), + $proposal->studygroup->getFullname(), + Context::get()->getFullname() + ), + $user_data['username'], + '____%system%____', + '', + '', + '', + '', + _('Verknüpfungsvorschlag abgewiesen'), + '', + 'normal', + ['Studiengruppe'] + ); + + restoreLanguage(); + } + } else { + PageLayout::postSuccess(_('Vorschlag wurde zurückgezogen.')); + } + $proposal->delete(); + } + } + $this->redirect('course/connectedstudygroups/index'); + } + + protected function buildSidebar() + { + $actions = new ActionsWidget(); + $actions->addLink( + _('Studiengruppe verknüpfen'), + $this->url_for('course/connectedstudygroups/connect'), + Icon::create('add'), + ['data-dialog' => 1] + ); + Sidebar::Get()->addWidget($actions); + } +} |