class.ilWikiContributor.php

Go to the documentation of this file.

<?php

class ilWikiContributor
{
    public const STATUS_NOT_GRADED = 0;
    public const STATUS_PASSED = 1;
    public const STATUS_FAILED = 2;

    public static function _lookupStatus(
        int $a_obj_id,
        int $a_user_id
    ): ?int {
        global $DIC;

        $ilDB = $DIC->database();

        $set = $ilDB->queryF(
            "SELECT status FROM il_wiki_contributor " .
            "WHERE wiki_id = %s and user_id = %s",
            array("integer", "integer"),
            array($a_obj_id, $a_user_id)
        );
        if ($row = $ilDB->fetchAssoc($set)) {
            return (int) $row["status"];
        }
        return null;
    }

    public static function _lookupStatusTime(
        int $a_obj_id,
        int $a_user_id
    ): ?string {
        global $DIC;

        $ilDB = $DIC->database();

        $set = $ilDB->queryF(
            "SELECT status_time FROM il_wiki_contributor " .
            "WHERE wiki_id = %s and user_id = %s",
            array("integer", "integer"),
            array($a_obj_id, $a_user_id)
        );
        if ($row = $ilDB->fetchAssoc($set)) {
            return $row["status_time"];
        }
        return null;
    }

    public static function _writeStatus(
        int $a_obj_id,
        int $a_user_id,
        int $a_status
    ): void {
        global $DIC;

        $ilDB = $DIC->database();

        $ilDB->manipulate("DELETE FROM il_wiki_contributor WHERE " .
            " wiki_id = " . $ilDB->quote($a_obj_id, "integer") .
            " AND user_id = " . $ilDB->quote($a_user_id, "integer"));

        $ilDB->manipulateF(
            "INSERT INTO il_wiki_contributor (status, wiki_id, user_id, status_time) " .
            "VALUES (%s,%s,%s,%s)",
            array("integer", "integer", "integer", "timestamp"),
            array($a_status, $a_obj_id, $a_user_id, ilUtil::now())
        );
    }
}