Inheritance diagram for ILIAS\Exercise\Submission\SubmissionDBRepository:

Collaboration diagram for ILIAS\Exercise\Submission\SubmissionDBRepository:

Public Member Functions
	__construct (\ilDBInterface $db=null)

	getUserId (int $submission_id)

	hasSubmissions (int $assignment_id)

	updateWebDirAccessTime (int $assignment_id, int $member_id)

	getUserSubmissionState (int $user_id, array $assignment_ids)
	Checks if a user has submitted anything for a number of assignments. More...

	getUserId (int $submission_id)

	hasSubmissions (int $assignment_id)

Protected Attributes
const	TABLE_NAME = "exc_returned"

const	TEAM_TABLE_NAME = "il_exc_team"

ilDBInterface	$db

Detailed Description

Submission repository.

Author: Jesús López lopez.nosp@m.@lei.nosp@m.fos.c.nosp@m.om; Alexander Killing killi.nosp@m.ng@l.nosp@m.eifos.nosp@m..de

Definition at line 27 of file class.SubmissionDBRepository.php.

Constructor & Destructor Documentation

◆ __construct()

ILIAS\Exercise\Submission\SubmissionDBRepository::__construct ( \ilDBInterface $db = null )

Definition at line 34 of file class.SubmissionDBRepository.php.

    {
        global $DIC;
 
        $this->db = (is_null($db))
            ? $DIC->database()
            : $db;
    }

References ILIAS\Exercise\Submission\SubmissionDBRepository\$db, and $DIC.

Member Function Documentation

◆ getUserId()

ILIAS\Exercise\Submission\SubmissionDBRepository::getUserId ( int $submission_id )

Implements ILIAS\Exercise\Submission\SubmissionRepositoryInterface.

Definition at line 43 of file class.SubmissionDBRepository.php.

                                                 : int
    {
        $q = "SELECT user_id FROM " . self::TABLE_NAME .
            " WHERE returned_id = " . $this->db->quote($submission_id, "integer");
        $usr_set = $this->db->query($q);
 
        $rec = $this->db->fetchAssoc($usr_set);
        return (int) ($rec["user_id"] ?? 0);
    }

◆ getUserSubmissionState()

ILIAS\Exercise\Submission\SubmissionDBRepository::getUserSubmissionState	(	int	$user_id,
		array	$assignment_ids
	)

Checks if a user has submitted anything for a number of assignments.

This function should be performant, because it is being used for task determination. It assumes, that team db entries only exist for team assignment types and thus does not read the assignment types at all.

Definition at line 78 of file class.SubmissionDBRepository.php.

                                                                               : array
    {
        $db = $this->db;
 
        $submitted = [];
        foreach ($assignment_ids as $id) {
            $submitted[(int) $id] = false;
        }
 
        $set = $db->queryF(
            "SELECT ass_id FROM  " . self::TABLE_NAME .
            " WHERE " . $db->in("ass_id", $assignment_ids, false, "integer") .
            " AND user_id = %s " .
            " AND (filename IS NOT NULL OR atext IS NOT NULL)" .
            " AND ts IS NOT NULL",
            ["integer"],
            [$user_id]
        );
        while ($rec = $db->fetchAssoc($set)) {
            $submitted[(int) $rec["ass_id"]] = true;
        }
 
        $set = $db->queryF(
            "SELECT ret.ass_id FROM  " . self::TABLE_NAME . " ret JOIN " .
            self::TEAM_TABLE_NAME . " team ON (ret.team_id = team.id AND ret.ass_id = team.ass_id) " .
            " WHERE " . $db->in("ret.ass_id", $assignment_ids, false, "integer") .
            " AND team.user_id = %s " .
            " AND (ret.filename IS NOT NULL OR ret.atext IS NOT NULL)" .
            " AND ret.ts IS NOT NULL",
            ["integer"],
            [$user_id]
        );
        while ($rec = $db->fetchAssoc($set)) {
            $submitted[(int) $rec["ass_id"]] = true;
        }
 
        return $submitted;
    }

References ILIAS\Exercise\Submission\SubmissionDBRepository\$db, $id, ilDBInterface\fetchAssoc(), ilDBInterface\in(), ILIAS\Repository\int(), and ilDBInterface\queryF().

Here is the call graph for this function:

◆ hasSubmissions()

ILIAS\Exercise\Submission\SubmissionDBRepository::hasSubmissions ( int $assignment_id )

Implements ILIAS\Exercise\Submission\SubmissionRepositoryInterface.

Definition at line 53 of file class.SubmissionDBRepository.php.

                                                      : int
    {
        $query = "SELECT * FROM " . self::TABLE_NAME .
            " WHERE ass_id = " . $this->db->quote($assignment_id, "integer") .
            " AND (filename IS NOT NULL OR atext IS NOT NULL)" .
            " AND ts IS NOT NULL";
        $res = $this->db->query($query);
        return $res->numRows();
    }

References $query, and $res.

◆ updateWebDirAccessTime()

ILIAS\Exercise\Submission\SubmissionDBRepository::updateWebDirAccessTime	(	int	$assignment_id,
		int	$member_id
	)

Definition at line 64 of file class.SubmissionDBRepository.php.

                                                                              : void
    {
        $this->db->manipulate("UPDATE " . self::TABLE_NAME .
            " SET web_dir_access_time = " . $this->db->quote(\ilUtil::now(), "timestamp") .
            " WHERE ass_id = " . $this->db->quote($assignment_id, "integer") .
            " AND user_id = " . $this->db->quote($member_id, "integer"));
    }