ILIAS\Survey\Execution\RunDBRepository Class Reference

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.

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

    {
        global $DIC;

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

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.

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

                                                                 : 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;
    }

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.

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

                                                           : 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;
    }

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.

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

                                                             : 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;
    }

Field Documentation

$db

ILIAS\Survey\Execution\RunDBRepository::$db

protected

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

Referenced by ILIAS\Survey\Execution\RunDBRepository\__construct(), ILIAS\Survey\Execution\RunDBRepository\getFinishedAppraiseesForRater(), ILIAS\Survey\Execution\RunDBRepository\getFinishedSurveysOfUser(), and ILIAS\Survey\Execution\RunDBRepository\getUnfinishedSurveysOfUser().

---

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

• Modules/Survey/Execution/class.RunDBRepository.php