ILIAS\Survey\Survey360\AppraiseeDBRepository Class Reference

Apraisee / Rater DB repository Tables: svy_360_rater, svy_360_appr. More...

Collaboration diagram for ILIAS\Survey\Survey360\AppraiseeDBRepository:

Public Member Functions
	__construct (\ilDBInterface $db=null)
	getAppraiseesForRater (int $rater_id)
	getClosedAppraiseesForSurveys (array $survey_ids)
	Get closed appraisees for a number of surveys. More...
	getUnclosedSurveysForAppraisee (int $appr_user_id)
	Get all unclosed surveys of an appraisee. More...

Protected Attributes
ilDBInterface	$db

Detailed Description

Apraisee / Rater DB repository Tables: svy_360_rater, svy_360_appr.

Author

Alexander Killing killi.nosp@m.ng@l.nosp@m.eifos.nosp@m..de

Definition at line 26 of file AppraiseeDBRepository.php.

Constructor & Destructor Documentation

__construct()

ILIAS\Survey\Survey360\AppraiseeDBRepository::__construct

(

\ilDBInterface

$db = null

)

Definition at line 30 of file AppraiseeDBRepository.php.

References ILIAS\Survey\Survey360\AppraiseeDBRepository\$db, and $DIC.

      {
        global $DIC;

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

Member Function Documentation

getAppraiseesForRater()

ILIAS\Survey\Survey360\AppraiseeDBRepository::getAppraiseesForRater

(

int

$rater_id

)

Parameters

int

$rater_id

Returns

array{survey_id: int, appr_id: int}[]

Definition at line 44 of file AppraiseeDBRepository.php.

References ILIAS\Survey\Survey360\AppraiseeDBRepository\$db, ILIAS\Repository\int(), and ilDBInterface\queryF().

     : array {
        $db = $this->db;

        $set = $db->queryF(
            "SELECT obj_id, appr_id FROM svy_360_rater " .
            " WHERE user_id = %s ",
            ["integer"],
            [$rater_id]
        );
        $appraisee = [];
        while ($rec = $db->fetchAssoc($set)) {
            $appraisee[] = [
                "survey_id" => (int) $rec["obj_id"],
                "appr_id" => (int) $rec["appr_id"]
            ];
        }
        return $appraisee;
    }

Here is the call graph for this function:

getClosedAppraiseesForSurveys()

ILIAS\Survey\Survey360\AppraiseeDBRepository::getClosedAppraiseesForSurveys

(

array

$survey_ids

)

Get closed appraisees for a number of surveys.

Parameters

int[]

$survey_ids

Returns

array{survey_id: int, appr_id: int}[]

Definition at line 71 of file AppraiseeDBRepository.php.

References ILIAS\Survey\Survey360\AppraiseeDBRepository\$db, ILIAS\Repository\int(), and ilDBInterface\queryF().

     : array {
        $db = $this->db;

        $set = $db->queryF(
            "SELECT obj_id, user_id FROM svy_360_appr " .
            " WHERE " . $db->in("obj_id", $survey_ids, false, "integer") .
            "AND has_closed = %s",
            ["integer"],
            [1]
        );
        $closed_appraisees = [];
        while ($rec = $db->fetchAssoc($set)) {
            $closed_appraisees[] = [
                "survey_id" => (int) $rec["obj_id"],
                "appr_id" => (int) $rec["user_id"]
            ];
        }
        return $closed_appraisees;
    }

Here is the call graph for this function:

getUnclosedSurveysForAppraisee()

ILIAS\Survey\Survey360\AppraiseeDBRepository::getUnclosedSurveysForAppraisee

(

int

$appr_user_id

)

Get all unclosed surveys of an appraisee.

Returns

int[]

Definition at line 97 of file AppraiseeDBRepository.php.

References ILIAS\Survey\Survey360\AppraiseeDBRepository\$db, ILIAS\Repository\int(), and ilDBInterface\queryF().

     : array {
        $db = $this->db;

        $set = $db->queryF(
            "SELECT DISTINCT obj_id FROM svy_360_appr " .
            "WHERE user_id = %s " .
            "AND has_closed = %s",
            ["integer", "integer"],
            [$appr_user_id, 0]
        );
        $unclosed_surveys = [];
        while ($rec = $db->fetchAssoc($set)) {
            $unclosed_surveys[] = (int) $rec["obj_id"];
        }
        return $unclosed_surveys;
    }

Here is the call graph for this function:

Field Documentation

$db

ilDBInterface ILIAS\Survey\Survey360\AppraiseeDBRepository::$db

protected

Definition at line 28 of file AppraiseeDBRepository.php.

Referenced by ILIAS\Survey\Survey360\AppraiseeDBRepository\__construct(), ILIAS\Survey\Survey360\AppraiseeDBRepository\getAppraiseesForRater(), ILIAS\Survey\Survey360\AppraiseeDBRepository\getClosedAppraiseesForSurveys(), and ILIAS\Survey\Survey360\AppraiseeDBRepository\getUnclosedSurveysForAppraisee().

---

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

• Modules/Survey/Survey360/AppraiseeDBRepository.php