AppraiseeDBRepository.php

Go to the documentation of this file.

<?php

/* Copyright (c) 1998- ILIAS open source, Extended GPL, see docs/LICENSE */

namespace ILIAS\Survey\Survey360;

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

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

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