AppraiseeDBRepository.php

Go to the documentation of this file.

<?php

namespace ILIAS\Survey\Survey360;

class AppraiseeDBRepository
{
    protected \ilDBInterface $db;

    public function __construct(
        \ilDBInterface $db = null
    ) {
        global $DIC;

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

    public function getAppraiseesForRater(
        int $rater_id
    ): 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;
    }


    public function getClosedAppraiseesForSurveys(
        array $survey_ids
    ): 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;
    }

    public function getUnclosedSurveysForAppraisee(
        int $appr_user_id
    ): 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;
    }
}