path: root/app/controllers/oer/market.php

<?php

class Oer_MarketController extends StudipController
{

    protected $with_session = true;

    function before_filter(&$action, &$args)
    {
        parent::before_filter($action, $args);
        if (
            !Config::get()->OERCAMPUS_ENABLED
            || (
                Config::get()->OER_PUBLIC_STATUS !== 'nobody'
                && !$GLOBALS['perm']->have_perm(Config::get()->OER_PUBLIC_STATUS)
            )
        ) {
            throw new AccessDeniedException();
        }
        Helpbar::Get()->addPlainText(
            _("Lernmaterialien"),
            _("Übungszettel, Musterlösungen, Vorlesungsmitschriften oder gar Folien, selbsterstellte Lernkarteikarten oder alte Klausuren. Das alles wird einmal erstellt und dann meist vergessen. Auf dem Lernmaterialienmarktplatz bleiben sie erhalten. Jeder kann was hochladen und jeder kann alles herunterladen. Alle Inhalte hier sind frei verfügbar für jeden.")
        );
        PageLayout::setTitle(_("Lernmaterialien"));
    }

    public function index_action()
    {
        if (Navigation::hasItem("/oer/market")) {
            Navigation::activateItem("/oer/market");
        }
        $tag_matrix_entries_number = 9;
        $this->best_nine_tags = OERTag::findBest($tag_matrix_entries_number);
        $this->tags = [];
        foreach ($this->best_nine_tags as $tag) {
            $this->tags[] = [
                'tag_hash' => $tag->tag_hash,
                'name'     => $tag->name,
            ];
        }
        if (Request::get("tag")) {
            $this->materialien = OERMaterial::findByTag(Request::get("tag"));
        }
        if (Request::get("category")) {
            $this->materialien = OERMaterial::findBySQL("category = ? ORDER BY oer_material.mkdate DESC", [Request::get("category")]);
        }
        if (Request::get("get") === "all") {
            $this->materialien = OERMaterial::findBySQL("1 ORDER BY oer_material.mkdate DESC");
        }

        $this->material_data = false;
        if (!empty($this->materialien)) {
            $this->material_data = [];
            foreach ($this->materialien as $material) {
                $data = $material->toRawArray();

                $data['tags'] = array_map(function($tag) {
                    return $tag['name'];
                }, $material->getTopics());

                $data['logo_url'] = $material->getLogoURL();
                $data['download_url'] = $material->getDownloadUrl();
                $this->material_data[] = $data;
            }
        }
        $this->new_ones = OERMaterial::findBySQL("LEFT JOIN oer_hosts ON (oer_hosts.host_id = oer_material.host_id)
            WHERE draft = '0'
                AND oer_material.host_id IS NULL
            ORDER BY mkdate DESC LIMIT 9");

        $statement = DBManager::get()->prepare("
            SELECT 1
            FROM oer_abo
            WHERE user_id = ?
                AND material_id IS NULL
        ");
        $statement->execute([$GLOBALS['user']->id]);
        $this->abo = (bool) $statement->fetch(PDO::FETCH_COLUMN, 0);

        if ($GLOBALS['perm']->have_perm('autor')) {
            $actions = new ActionsWidget();
            $actions->addLink(
                _('Neues Lernmaterial hochladen'),
                $this->url_for('oer/mymaterial/edit'),
                Icon::create('add'),
                ['data-dialog' => 'size=auto']
            );
            $actions->addLink(
                $this->abo ? _('Neuigkeiten abbestellen') : _('Neuigkeiten abonnieren'),
                $this->aboURL(),
                Icon::create($this->abo ? 'decline' : 'rss'),
                ['data-dialog' => 'size=auto']
            );
            Sidebar::Get()->addWidget($actions);
        }
    }

    public function get_tags_action()
    {
        $tag_matrix_entries_number = 9;
        $tag_subtags_number = 9;

        if (!count(Request::getArray("tags"))) {
            $this->topics = OERTag::findBest($tag_matrix_entries_number);
            $this->materialien = [];
        } else {
            $tags = $this->tag_history = Request::getArray("tags");
            $this->without_tags = [];
            $tag_to_search_for = array_pop($tags);

            OERMaterial::fetchRemoteSearch(
                null,
                $tag_to_search_for
            );

            foreach (OERTag::findBest($tag_matrix_entries_number, true) as $related_tag) {
                if ($related_tag['tag_hash'] !== $this->tag_history[0]) {
                    $this->without_tags[] = $related_tag['tag_hash'];
                }
            }
            foreach ($tags as $tag) {
                foreach (OERTag::findRelated($tag, $this->without_tags, $tag_subtags_number, true) as $related_tag) {
                    $this->without_tags[] = $related_tag['tag_hash'];
                }
            }
            $this->topics = OERTag::findRelated(
                $tag_to_search_for,
                $this->without_tags,
                $tag_subtags_number
            );
            $this->materialien = OERMaterial::findByTagHash($tag_to_search_for);
        }

        $output = [];
        $output['results'] = [
            'materials' => [],
            'tags' => []
        ];
        foreach ($this->materialien as $material) {
            $data = $material->toRawArray();

            $data['tags'] = array_map(function($tag) {
                return $tag['name'];
            }, $material->getTopics());

            $data['logo_url'] = $material->getLogoURL();
            $data['download_url'] = $material->getDownloadUrl();

            $output['results']['materials'][] = $data;
        }

        foreach ($this->topics as $topic) {
            $output['tags'][] = $topic->toArray();
        }

        $this->render_json($output);
    }


    public function search_action()
    {
        if (Navigation::hasItem("/oer/market")) {
            Navigation::activateItem("/oer/market");
        }
        if (Request::get("search") || Request::get("type") || Request::get("tag") || Request::get("difficulty")) {
            if (Request::get("search")) {
                OERMaterial::fetchRemoteSearch(
                    Request::get("search"),
                    Request::get("tag")
                );
            }
            $this->more = false;
            $search = SQLQuery::table("oer_material", "oer_material")
                ->join("oer_hosts", "oer_hosts.host_id = oer_material.host_id", "LEFT JOIN")
                ->where("draft = '0'")
                ->where("(oer_material.host_id IS NULL OR oer_hosts.`active` = '1')")
                ->groupBy("oer_material.material_id")
                ->orderBy("mkdate DESC");
            if (Request::get("type")) {
                $search->where("search_categories", "category = :category", ['category' => Request::get("type")]);
            }
            if (Request::get("search")) {
                //Tags
                $search->join(
                    "oer_tags_material",
                    "oer_material.material_id = oer_tags_material.material_id",
                    "LEFT JOIN"
                );
                $search->join(
                    "oer_tags",
                    "oer_tags_material.tag_hash = oer_tags.tag_hash",
                    "LEFT JOIN"
                );
                $search->join(
                    "oer_material_users",
                    "oer_material_users.material_id = oer_material.material_id",
                    "LEFT JOIN"
                );
                $search->join(
                    "external_users",
                    "oer_material_users.user_id = external_users.external_contact_id AND oer_material_users.external_contact = '1'",
                    "LEFT JOIN"
                );
                $search->join(
                    "auth_user_md5",
                    "oer_material_users.user_id = auth_user_md5.user_id AND oer_material_users.external_contact = '0'",
                    "LEFT JOIN"
                );
                $search->where(
                    "textsearch",
                    "(oer_material.name LIKE :search OR oer_material.description LIKE :search OR oer_material.short_description LIKE :search OR oer_tags.name LIKE :search OR external_users.name LIKE :search OR CONCAT(auth_user_md5.Vorname, ' ', auth_user_md5.Nachname) LIKE :search)",
                    ['search' => '%'.Request::get("search").'%']
                );
            }
            if (Request::get("difficulty")) {
                $difficulty = explode(",", Request::get("difficulty"));
                $search->where(
                    "difficulty",
                    "((difficulty_start <= :difficulty_start AND difficulty_end >= :difficulty_start) OR (difficulty_start <= :difficulty_end AND difficulty_end >= :difficulty_end) OR (difficulty_start <= :difficulty_start AND difficulty_end >= :difficulty_end) OR (difficulty_start >= :difficulty_start AND difficulty_end <= :difficulty_end))",
                    ['difficulty_start' => $difficulty[0], 'difficulty_end' => $difficulty[1]]
                );
            }
            if (Request::get("limit") || Request::get("offset")) {
                $search->limit(
                    Request::int("limit") + 1,
                    Request::int("offset")
                );
            }

            $this->materialien = $search->fetchAll("OERMaterial");
            if (Request::int("limit") && (count($this->materialien) > Request::int("limit"))) {
                $this->more = true;
                array_pop($this->materialien);
            }

            if (Request::isAjax()) {
                $output = [
                    'materials' => [],
                    'more' => $this->more,
                    'offset' => Request::int("offset", 0)
                ];
                if (Request::int("limit")) {
                    $output['limit'] = Request::int("limit");
                }
                foreach ($this->materialien as $material) {
                    $data = $material->toRawArray();

                    $data['tags'] = array_map(function($tag) {
                        return $tag['name'];
                    }, $material->getTopics());

                    $data['logo_url'] = $material->getLogoURL();
                    $data['download_url'] = $material->getDownloadUrl();

                    $output['materials'][] = $data;
                }
                $this->render_json($output);
            }
        } else {
            $this->redirect("oer/market/index");
        }
    }

    public function details_action($material_id)
    {
        if (Navigation::hasItem("/oer/market")) {
            Navigation::activateItem("/oer/market");
        }
        $this->material = OERMaterial::find($material_id);
        if (!$this->material) {
            PageLayout::postError(_('Lernmaterial existiert nicht mehr.'));
            $this->redirect('oer/market');
            return;
        }

        //OpenGraph tags:
        PageLayout::addHeadElement("meta", ['og:title' => $this->material['name']]);

        $base = URLHelper::setBaseURL($GLOBALS['ABSOLUTE_URI_STUDIP']);
        PageLayout::addHeadElement("meta", ['og:url' => $this->url_for("oer/market/details/".$this->material->getId())]);
        PageLayout::addHeadElement("meta", ['og:description' => $this->material['short_description']]);
        PageLayout::addHeadElement("meta", ['og:image' => $this->material->getLogoURL()]);
        if ($this->material->isVideo()) {
            PageLayout::addHeadElement("meta", ['og:type' => "video"]);
            $url = $this->material['host_id']
                ? $this->material->host->url."download/".$this->material['foreign_material_id']
                : $this->url_for("oer/market/download/".$this->material->getId());
            PageLayout::addHeadElement("meta", ['og:video' => $url]);
            PageLayout::addHeadElement("meta", ['og:video:type' => $this->material['content_type']]);
        } elseif($this->material->isAudio()) {
            PageLayout::addHeadElement("meta", ['og:type' => "audio"]);
            $url = $this->material['host_id']
                ? $this->material->host->url."download/".$this->material['foreign_material_id']
                : $this->url_for("oer/market/download/".$this->material->getId());
            PageLayout::addHeadElement("meta", ['og:audio' => $url]);
            PageLayout::addHeadElement("meta", ['og:audio:type' => $this->material['content_type']]);
        } else {
            PageLayout::addHeadElement("meta", ['og:type' => "article"]);
        }
        URLHelper::setBaseURL($base);

        if ($this->material['host_id']) {
            $success = $this->material->fetchData();
            if ($success === false) {
                PageLayout::postInfo(_("Dieses Material stammt von einem anderen Server, der zur Zeit nicht erreichbar ist."));
            } elseif ($success === "deleted") {
                $material = clone $this->material;
                $this->material->delete();
                $this->material = $material;
                PageLayout::postError(_("Dieses Material ist gelöscht worden und wird gleich aus dem Cache verschwinden."));
            }
            $this->material->resetRelation("users");
        }
        $this->material['rating'] = $this->material->calculateRating();
        $this->material->store();

        $infotext = "";
        foreach ($this->material->users as $index => $materialuser)  {
            if ($index > 0) {
                $infotext .= ', ';
            }
            if ($materialuser['external_contact']) {
                $user = $materialuser['oeruser'];
                $infotext .= $user['name'];
            } else {
                $user = User::find($materialuser['user_id']);
                $infotext .= $user ? $user->getFullName() : _('unbekannt');
            }
        }

        $this->contentBarVueApp = \Studip\VueApp::create('ContentBar')->withProps([
            'title' => $this->material['name'],
            'icon' => 'oer-campus',
            'isContentBar' => true,
        ])->withSlot('info-text', htmlReady($infotext));
    }

    public function embed_action($material_id)
    {
        if (Navigation::hasItem("/oer/market")) {
            Navigation::activateItem("/oer/market");
        }

        $this->material = new OERMaterial($material_id);
    }

    public function review_action($material_id = null)
    {
        if (!$GLOBALS['perm']->have_perm("autor")) {
            throw new AccessDeniedException();
        }
        if (Navigation::hasItem("/oer/market")) {
            Navigation::activateItem("/oer/market");
        }
        $this->material = new OERMaterial($material_id);
        $this->review = OERReview::findOneBySQL("context_id = ? AND user_id = ?", [
            $material_id,
            $GLOBALS['user']->id
        ]);
        if (!$this->review) {
            $this->review = new OERReview();
            $this->review['context_id'] = $this->material->getId();
            $this->review['user_id'] = $GLOBALS['user']->id;
            $this->review['display_class'] = "OERReview";
            $this->review['context_type'] = "public";
        }
        if (Request::isPost()) {
            $this->review['content'] = Request::get("review");
            $this->review['metadata'] = [
                'rating' => Request::get("rating")
            ];
            $this->review->store();

            $this->material['rating'] = $this->material->calculateRating();
            $this->material->store();
            PageLayout::postSuccess(_("Danke für das Review!"));
            $this->redirect("oer/market/details/".$material_id);
        }
    }

    public function discussion_action($review_id)
    {
        if (Navigation::hasItem("/oer/market")) {
            Navigation::activateItem("/oer/market");
        }

        $this->thread = new OERReview($review_id);
        if (!$this->thread->isNew()) {
            $this->thread->markAsRead();
        }
    }


    public function licenseinfo_action()
    {

    }

    public function add_to_course_action($material_id)
    {
        if (!$GLOBALS['perm']->have_perm("autor")) {
            throw new AccessDeniedException();
        }
        $this->material = new OERMaterial($material_id);
        if (Request::option("seminar_id") && $GLOBALS['perm']->have_studip_perm("autor", Request::option("seminar_id"))) {
            $this->course = new Course(Request::option("seminar_id"));

            $this->classes = $this->course->tools->filter(function (ToolActivation $tool) {
                $module = $tool->getStudipModule();
                return $module instanceof OERModule
                    && $module::oerModuleWantsToUseMaterial($this->material);
            })->map(function (ToolActivation $tool): string {
                return get_class($tool->getStudipModule());
            });

            if (Request::get('class') || count($this->classes) === 1) {
                $class = Request::get('class') ?? $this->classes[0] ?? '';
                if (class_exists($class) && in_array($class, $this->classes)) {
                    $response = $class::oerModuleIntegrateMaterialToCourse(
                        $this->material,
                        $this->course
                    );

                    if ($response['type'] === 'error') {
                        PageLayout::postError($response['message'], $response['message_detail']);
                    } else {
                        PageLayout::postSuccess($response['message'], $response['message_detail']);
                    }

                    $this->response->add_header('X-Dialog-Close', 1);
                    $this->relocate($response['redirect_url']);

                    return;
                }
            } else {
                $this->render_template("oer/market/add_to_course_select_class");
            }

        }
        if (!$GLOBALS['perm']->have_perm("admin")) {
            $this->courses = Course::findBySQL("INNER JOIN seminar_user USING (Seminar_id)
                WHERE seminar_user.user_id = ?
                ORDER BY seminare.mkdate DESC", [$GLOBALS['user']->id]
            );
        } else {
            $this->courses = [];
            foreach (AdminCourseFilter::get()->getCourses(false) as $coursedata) {
                $this->courses[] = Course::buildExisting($coursedata);
            }
        }
        $this->semesters = [];
        foreach ($this->courses as $course) {
            foreach ($course->semesters as $semester) {
                $this->semesters[$semester->getId()] = $semester;
            }
        }
        usort($this->semesters, function ($a, $b) {
            return $a['beginn'] < $b['beginn'];
        });
    }

    public function profile_action($external_user_id)
    {
        $this->user = new ExternalUser($external_user_id);
        if ($this->user->isNew()) {
            throw new Exception(_("Nutzer ist nicht erfasst."));
        }
        $this->materials = OERMaterial::findBySQL("LEFT JOIN oer_material_users ON (oer_material_users.material_id = oer_material.material_id AND external_contact = 1)
            WHERE oer_material_users.user_id = ?
            ORDER BY oer_material.mkdate DESC", [
            $external_user_id
        ]);
    }

    public function abo_action()
    {
        $statement = DBManager::get()->prepare("
            SELECT 1
            FROM oer_abo
            WHERE user_id = ?
                AND material_id IS NULL
        ");
        $statement->execute([$GLOBALS['user']->id]);
        $this->abo = (bool) $statement->fetch(PDO::FETCH_COLUMN, 0);
        if (Request::isPost()) {
            if (Request::get("abo")) {
                $statement = DBManager::get()->prepare("
                    INSERT IGNORE INTO oer_abo
                    SET user_id = ?,
                        material_id = NULL
                ");
                $statement->execute([$GLOBALS['user']->id]);
                PageLayout::postSuccess(_("Erfolgreich abonniert."));
            } else {
                $statement = DBManager::get()->prepare("
                    DELETE
                    FROM oer_abo
                    WHERE user_id = ?
                        AND (material_id IS NULL OR material_id = '')
                ");
                $statement->execute([$GLOBALS['user']->id]);
                PageLayout::postSuccess(_("Abgemeldet von Neuigkeiten."));
            }

            $this->redirect("oer/market/index");
        }
    }

    protected function getFolderStructure($folder)
    {
        $structure = [];
        foreach (scandir($folder) as $file) {
            if (!in_array($file, [".", ".."])) {
                $attributes = [
                    'is_folder' => is_dir($folder."/".$file) ? 1 : 0
                ];
                if (is_dir($folder."/".$file)) {
                    $attributes['structure'] = $this->getFolderStructure($folder."/".$file);
                } else {
                    $attributes['size'] = filesize($folder."/".$file);
                }
                $structure[$file] = $attributes;
            }
        }
        return $structure;
    }

}