<?php

class Course_TopicsController extends AuthenticatedController
{
    protected $allow_nobody = true;
    protected $_autobind = true;

    public function before_filter(&$action, &$args)
    {
        PageLayout::setHelpKeyword('Basis/InVeranstaltungAblauf');

        parent::before_filter($action, $args);

        checkObject();
        checkObjectModule("schedule");

        Navigation::activateItem('/course/schedule/topics');
        PageLayout::setTitle(sprintf('%s - %s', Course::findCurrent()->getFullname(), _("Themen")));

        $seminar = new Seminar(Course::findCurrent());
        $this->forum_activated = $seminar->getSlotModule('forum');
        $this->documents_activated = $seminar->getSlotModule('documents');

        if ($action !== 'index' && !$GLOBALS['perm']->have_studip_perm('tutor', Context::getId())) {
            throw new AccessDeniedException();
        }

        $this->setupSidebar($action);
    }

    public function index_action()
    {
        $this->topics = CourseTopic::findBySeminar_id(Context::getId());
        $this->cancelled_dates_locked = LockRules::Check(Context::getId(), 'cancelled_dates');
    }

    public function delete_action(CourseTopic $topic)
    {
        if (!Request::isPost()) {
            throw new MethodNotAllowedException();
        }

        if ($topic->seminar_id && ($topic->seminar_id !== Context::getId())) {
            throw new AccessDeniedException();
        }

        if ($topic->delete()) {
            PageLayout::postSuccess(_('Thema gelöscht.'));
        }

        $this->redirect('course/topics');
    }

    public function edit_action(CourseTopic $topic = null)
    {
        PageLayout::setTitle($topic->isNew() ? _('Neues Thema erstellen') : sprintf(_('Bearbeiten: %s'), $topic->title));

        $this->dates = CourseDate::findBySeminar_id(Context::getId());
    }

    public function store_action(CourseTopic $topic = null)
    {
        if (!Request::isPost()) {
            throw new MethodNotAllowedException();
        }

        if ($topic->seminar_id && ($topic->seminar_id !== Context::getId())) {
            throw new AccessDeniedException();
        }

        $topic->title         = Request::i18n("title");
        $topic->description   = Request::i18n('description', null, function ($string) {
            return Studip\Markup::purifyHtml($string);

        });
        $topic->paper_related = Request::bool('paper_related', false);
        if ($topic->isNew()) {
            $topic->seminar_id = Context::getId();
        }
        $topic->store();

        //change dates for this topic
        $former_date_ids = $topic->dates->pluck('termin_id');
        $new_date_ids = array_keys(Request::getArray('date'));
        foreach (array_diff($former_date_ids, $new_date_ids) as $delete_termin_id) {
            $topic->dates->unsetByPk($delete_termin_id);
        }
        foreach (array_diff($new_date_ids, $former_date_ids) as $add_termin_id) {
            $date = CourseDate::find($add_termin_id);
            if ($date) {
                $topic->dates[] = $date;
            }
        }
        $topic->store();

        if (Request::bool('folder')) {
            $topic->connectWithDocumentFolder();
        }

        // create a connection to the module forum (can be anything)
        // will update title and description automagically
        if (Request::bool('forumthread')) {
            $topic->connectWithForumThread();
        }

        PageLayout::postSuccess(_('Thema gespeichert.'));
        $this->redirect($this->indexURL(['open' => $topic->id]));
    }

    public function move_up_action(CourseTopic $topic)
    {
        if (!Request::isPost()) {
            throw new MethodNotAllowedException();
        }

        $topic->increasePriority();

        $this->redirect($this->indexURL(['open' => $topic->id]));
    }

    public function move_down_action(CourseTopic $topic)
    {
        if (!Request::isPost()) {
            throw new MethodNotAllowedException();
        }

        $topic->decreasePriority();

        $this->redirect($this->indexURL(['open' => $topic->id]));
    }

    public function allow_public_action()
    {
        $config = CourseConfig::get(Context::getId());
        $config->store('COURSE_PUBLIC_TOPICS', !$config->COURSE_PUBLIC_TOPICS);
        $this->redirect("course/topics");
    }

    public function copy_action()
    {
        if (Request::submitted("copy")) {
            $prio = 1;
            foreach (Course::find(Context::getId())->topics as $topic) {
                $prio = max($prio, $topic['priority']);
            }
            foreach (Request::getArray("topic") as $topic_id => $value) {
                $topic = new CourseTopic($topic_id);
                $topic = clone $topic;
                $topic['seminar_id'] = Context::getId();
                $topic['priority'] = $prio;
                $prio++;
                $topic->setId($topic->getNewId());
                $topic->setNew(true);
                $topic->store();

                NotificationCenter::postNotification('TopicDidCopy', $topic_id, $topic->id);
            }
            PageLayout::postMessage(MessageBox::success(sprintf(_("%s Themen kopiert."), count(Request::getArray("topic")))));
            $this->redirect("course/topics");
        }
        $semester_sql = " CONCAT('(',IFNULL(GROUP_CONCAT(DISTINCT semester_data.name ORDER BY semester_data.beginn SEPARATOR '-'),'" . _('unbegrenzt') . "'),')')";
        if ($GLOBALS['perm']->have_perm("root")) {
            $this->courseSearch = new SQLSearch("
                SELECT seminare.Seminar_id, CONCAT_WS(' ', seminare.VeranstaltungsNummer, seminare.name, $semester_sql, '(', COUNT(issue_id), ')')
                FROM seminare
                LEFT JOIN semester_courses ON (seminare.Seminar_id = semester_courses.course_id)
                LEFT JOIN semester_data ON (semester_data.semester_id = semester_courses.semester_id)
                INNER JOIN themen ON themen.seminar_id = seminare.Seminar_id
                WHERE seminare.VeranstaltungsNummer LIKE :input OR seminare.name LIKE :input
                GROUP BY seminare.Seminar_id
                ORDER BY semester_data.beginn DESC, seminare.VeranstaltungsNummer ASC, seminare.name ASC
                ",
                _("Veranstaltung suchen"),
                "seminar_id"
            );
        } elseif ($GLOBALS['perm']->have_perm("admin")) {
            $this->courseSearch = new SQLSearch("
                SELECT seminare.Seminar_id, CONCAT_WS(' ', seminare.VeranstaltungsNummer, seminare.name, $semester_sql, '(', COUNT(issue_id), ')')
                FROM seminare
                    INNER JOIN seminar_inst ON (seminare.Seminar_id = seminar_inst.seminar_id)
                    INNER JOIN user_inst ON (user_inst.Institut_id = seminar_inst.institut_id)
                    LEFT JOIN semester_courses ON (seminare.Seminar_id = semester_courses.course_id)
                    LEFT JOIN semester_data ON (semester_data.semester_id = semester_courses.semester_id)
                    INNER JOIN themen ON themen.seminar_id = seminare.Seminar_id

                WHERE seminare.VeranstaltungsNummer LIKE :input OR seminare.name LIKE :input
                    AND user_inst.user_id = ".DBManager::get()->quote($GLOBALS['user']->id)."
                    AND user_inst.inst_perms = 'admin'
                GROUP BY seminare.Seminar_id
                ORDER BY semester_data.beginn DESC, seminare.VeranstaltungsNummer ASC, seminare.name ASC
                ",
                _("Veranstaltung suchen"),
                "seminar_id"
            );
        } else {
            $this->courseSearch = new SQLSearch("
                SELECT seminare.Seminar_id, CONCAT_WS(' ', seminare.VeranstaltungsNummer, seminare.name, $semester_sql, '(', COUNT(issue_id), ')')
                FROM seminare
                    INNER JOIN seminar_user ON (seminare.Seminar_id = seminar_user.Seminar_id)
                    LEFT JOIN semester_courses ON (seminare.Seminar_id = semester_courses.course_id)
                    LEFT JOIN semester_data ON (semester_data.semester_id = semester_courses.semester_id)
                    INNER JOIN themen ON themen.seminar_id = seminare.Seminar_id
                WHERE seminare.VeranstaltungsNummer LIKE :input OR seminare.name LIKE :input
                    AND seminar_user.status IN ('tutor', 'dozent')
                    AND seminar_user.user_id = ".DBManager::get()->quote($GLOBALS['user']->id)."
                GROUP BY seminare.Seminar_id
                ORDER BY semester_data.beginn DESC, seminare.VeranstaltungsNummer ASC, seminare.name ASC
                ",
                _("Veranstaltung suchen"),
                "seminar_id"
            );
        }
        PageLayout::setTitle(_("Themen aus Veranstaltung kopieren"));
    }

    public function fetch_topics_action()
    {
        $this->topics = CourseTopic::findBySeminar_id(Request::option("seminar_id"));
        $output = [
            'html' => $this->render_template_as_string("course/topics/_topiclist.php")
        ];
        $this->render_json($output);
    }

    private function setupSidebar($action)
    {
        $sidebar = Sidebar::get();

        $actions = $sidebar->addWidget(new ActionsWidget());
        if ($action === 'index') {
            $actions->addLink(
                _('Alle Themen aufklappen'),
                $this->url_for('course/topics/show'),
                Icon::create('arr_1down'),
                ['onclick' => "jQuery('table.withdetails > tbody > tr:not(.details):not(.open) > :first-child a').click(); return false;"]
            );
            $actions->addLink(
                _('Alle Themen zuklappen'),
                $this->url_for('course/topics/hide'),
                Icon::create('arr_1right'),
                ['onclick' => "jQuery('table.withdetails > tbody > tr:not(.details).open > :first-child a').click(); return false;"]
            );
        }
        if ($GLOBALS['perm']->have_studip_perm('tutor', Context::getId())) {
            $actions->addLink(
                _('Neues Thema erstellen'),
                $this->url_for('course/topics/edit'),
                Icon::create('add')
            )->asDialog();
            $actions->addLink(
                _('Themen aus Veranstaltung kopieren'),
                $this->url_for('course/topics/copy'),
                Icon::create('clipboard')
            )->asDialog();
        }

        if ($GLOBALS['perm']->have_studip_perm('tutor', Context::getId())) {
            $options = $sidebar->addWidget(new OptionsWidget());
            $options->addCheckbox(
                _('Themen öffentlich einsehbar'),
                (bool) CourseConfig::get(Context::getId())->COURSE_PUBLIC_TOPICS,
                $this->url_for('course/topics/allow_public')
            );
        }
    }
}