ilExcSubmissionRepository Class Reference

Submission repository. More...

Inheritance diagram for ilExcSubmissionRepository:

Collaboration diagram for ilExcSubmissionRepository:

Public Member Functions
	__construct (ilDBInterface $db=null)
	ilExcSubmissionRepository constructor. More...
	getUserId (int $submission_id)
	Get User who submitted. Parameters int $submission_id Returns int More...
	hasSubmissions (int $ass_id)
	Get number of submissions from assignment id. Parameters int $assignment_id Returns int More...
	updateWebDirAccessTime (int $assignment_id, int $member_id)
	Update web_dir_access_time. More...

Data Fields
const	TABLE_NAME = "exc_returned"

Protected Attributes
	$db

Detailed Description

Submission repository.

Author

Jesús López lopez.nosp@m.@lei.nosp@m.fos.c.nosp@m.om

Definition at line 10 of file class.ilExcSubmissionRepository.php.

Constructor & Destructor Documentation

__construct()

ilExcSubmissionRepository::__construct

(

ilDBInterface

$db = null

)

ilExcSubmissionRepository constructor.

Parameters

ilDBInterface

$db

Definition at line 23 of file class.ilExcSubmissionRepository.php.

References $db, and $DIC.

    {
        global $DIC;

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

Member Function Documentation

getUserId()

ilExcSubmissionRepository::getUserId

(

int

$submission_id

)

Get User who submitted.

Parameters

int

$submission_id

Returns

int

Implements ilExcSubmissionRepositoryInterface.

Definition at line 35 of file class.ilExcSubmissionRepository.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);
        return $this->db->fetchAssoc($usr_set);
    }

hasSubmissions()

ilExcSubmissionRepository::hasSubmissions

(

int

$ass_id

)

Get number of submissions from assignment id.

Parameters

int

$assignment_id

Returns

int

Implements ilExcSubmissionRepositoryInterface.

Definition at line 46 of file class.ilExcSubmissionRepository.php.

References $query, and $res.

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

updateWebDirAccessTime()

ilExcSubmissionRepository::updateWebDirAccessTime	(	int	$assignment_id,
		int	$member_id
	)

Update web_dir_access_time.

It defines last HTML opening data.

Parameters

int	$assignment_id
int	$member_id

Definition at line 61 of file class.ilExcSubmissionRepository.php.

References ilUtil\now().

    {
        $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"));
    }

Here is the call graph for this function:

Field Documentation

$db

ilExcSubmissionRepository::$db

protected

Definition at line 17 of file class.ilExcSubmissionRepository.php.

Referenced by __construct().

TABLE_NAME

const ilExcSubmissionRepository::TABLE_NAME = "exc_returned"

Definition at line 12 of file class.ilExcSubmissionRepository.php.

---

The documentation for this class was generated from the following file:

• Modules/Exercise/Submission/classes/class.ilExcSubmissionRepository.php