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)
	Constructor. More...

	getAppraiseesForRater (int $rater_id)
	Get surveys for Rater. More...

	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
	$db

Detailed Description

Apraisee / Rater DB repository Tables: svy_360_rater, svy_360_appr.

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

Definition at line 13 of file AppraiseeDBRepository.php.

Constructor & Destructor Documentation

◆ __construct()

ILIAS\Survey\Survey360\AppraiseeDBRepository::__construct ( \ilDBInterface $db = null )

Constructor.

Definition at line 23 of file AppraiseeDBRepository.php.

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

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

Member Function Documentation

◆ getAppraiseesForRater()

ILIAS\Survey\Survey360\AppraiseeDBRepository::getAppraiseesForRater ( int $rater_id )

Get surveys for Rater.

Parameters

int $rater_id

Returns: array

Definition at line 38 of file AppraiseeDBRepository.php.

                                                         : 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" => $rec["obj_id"],
                "appr_id" => $rec["appr_id"]
            ];
        }
        return $appraisee;
    }

References ILIAS\Survey\Survey360\AppraiseeDBRepository\$db.

◆ getClosedAppraiseesForSurveys()

ILIAS\Survey\Survey360\AppraiseeDBRepository::getClosedAppraiseesForSurveys ( array $survey_ids )

Get closed appraisees for a number of surveys.

Parameters

int[] $survey_ids

Returns: array

Definition at line 65 of file AppraiseeDBRepository.php.

    {
        $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" => $rec["obj_id"],
                "appr_id" => $rec["user_id"]
            ];
        }
        return $closed_appraisees;
    }

References ILIAS\Survey\Survey360\AppraiseeDBRepository\$db.

◆ getUnclosedSurveysForAppraisee()

ILIAS\Survey\Survey360\AppraiseeDBRepository::getUnclosedSurveysForAppraisee ( int $appr_user_id )

Get all unclosed surveys of an appraisee.

Parameters

int $appr_user_id

Returns: int[]

Definition at line 92 of file AppraiseeDBRepository.php.

                                                                      : 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[] = $rec["obj_id"];
        }
        return $unclosed_surveys;
    }