DB repo for survey run. More...

Collaboration diagram for ILIAS\Survey\Execution\RunDBRepository:

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

	getFinishedSurveysOfUser (int $user_id)
	Get all finished surveys of a user. More...

	getUnfinishedSurveysOfUser (int $user_id)
	Get all unfinished surveys of a user. More...

	getFinishedAppraiseesForRater (int $rater_id)
	Get finished appraisees for a rater. More...

Protected Attributes
	$db

Detailed Description

DB repo for survey run.

Table svy_finished.

Please note that there are lots of accesses to svy_finished in other classes.

Author: killi.nosp@m.ng@l.nosp@m.eifos.nosp@m..de

Definition at line 15 of file class.RunDBRepository.php.

Constructor & Destructor Documentation

◆ __construct()

ILIAS\Survey\Execution\RunDBRepository::__construct ( \ilDBInterface $db = null )

Constructor.

Definition at line 25 of file class.RunDBRepository.php.

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

References ILIAS\Survey\Execution\RunDBRepository\$db, and $DIC.

Member Function Documentation

◆ getFinishedAppraiseesForRater()

ILIAS\Survey\Execution\RunDBRepository::getFinishedAppraiseesForRater ( int $rater_id )

Get finished appraisees for a rater.

Parameters

int $rater_id

Returns: array

Definition at line 87 of file class.RunDBRepository.php.

                                                                 : array
    {
        $db = $this->db;
 
        $set = $db->queryF(
            "SELECT survey_fi, appr_id FROM svy_finished " .
            " WHERE user_fi = %s AND state = %s",
            ["integer", "integer"],
            [$rater_id, 1]
        );
        $appraisee = [];
        while ($rec = $db->fetchAssoc($set)) {
            $appraisee[] = [
                "survey_id" => $rec["survey_fi"],
                "appr_id" => $rec["appr_id"]
            ];
        }
        return $appraisee;
    }

References ILIAS\Survey\Execution\RunDBRepository\$db.

◆ getFinishedSurveysOfUser()

ILIAS\Survey\Execution\RunDBRepository::getFinishedSurveysOfUser ( int $user_id )

Get all finished surveys of a user.

Parameters

int $user_id user id

Returns: int[] survey ids

Definition at line 41 of file class.RunDBRepository.php.

                                                           : array
    {
        $db = $this->db;
 
        $set = $db->queryF(
            "SELECT survey_fi FROM svy_finished " .
            " WHERE user_fi = %s AND state = %s",
            ["integer", "integer"],
            [$user_id, 1]
        );
        $items = [];
        while ($rec = $db->fetchAssoc($set)) {
            $items[] = (int) $rec["survey_fi"];
        }
        return $items;
    }

References ILIAS\Survey\Execution\RunDBRepository\$db.

◆ getUnfinishedSurveysOfUser()

ILIAS\Survey\Execution\RunDBRepository::getUnfinishedSurveysOfUser ( int $user_id )

Get all unfinished surveys of a user.

Parameters

int $user_id user id

Returns: int[] survey ids

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

                                                             : array
    {
        $db = $this->db;
 
        $set = $db->queryF(
            "SELECT survey_fi FROM svy_finished " .
            " WHERE user_fi = %s AND state = %s",
            ["integer", "integer"],
            [$user_id, 0]
        );
        $items = [];
        while ($rec = $db->fetchAssoc($set)) {
            $items[] = $rec["survey_fi"];
        }
        return $items;
    }