Skill tresholds for 360 surveys. More...

Collaboration diagram for ilSurveySkillThresholds:

Public Member Functions
	__construct (ilObjSurvey $a_survey)

	read ()

	getThresholds ()

	writeThreshold (int $a_base_skill_id, int $a_tref_id, int $a_level_id, int $a_threshold)

	cloneTo (ilObjSurvey $target_survey, array $mapping)

Protected Attributes
ilObjSurvey	$survey

ilDBInterface	$db

array	$threshold = []

Detailed Description

Skill tresholds for 360 surveys.

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

Definition at line 25 of file class.ilSurveySkillThresholds.php.

Constructor & Destructor Documentation

◆ __construct()

ilSurveySkillThresholds::__construct ( ilObjSurvey $a_survey )

Definition at line 32 of file class.ilSurveySkillThresholds.php.

    {
        global $DIC;
 
        $this->db = $DIC->database();
        $this->survey = $a_survey;
        $this->read();
    }

References $DIC, and read().

Here is the call graph for this function:

Member Function Documentation

◆ cloneTo()

ilSurveySkillThresholds::cloneTo	(	ilObjSurvey	$target_survey,
		array	$mapping
	)

Definition at line 81 of file class.ilSurveySkillThresholds.php.

                                                                       : void
    {
        $target_thresholds = new self($target_survey);
        $set = $this->db->queryF(
            "SELECT * FROM svy_skill_threshold " .
            " WHERE survey_id = %s ",
            ["integer"],
            [$this->survey->getId()]
        );
        while ($rec = $this->db->fetchAssoc($set)) {
            $target_thresholds->writeThreshold(
                (int) $rec["base_skill_id"],
                (int) $rec["tref_id"],
                (int) $rec["level_id"],
                (int) $rec["threshold"]
            );
        }
    }

References ILIAS\Repository\int().

Here is the call graph for this function:

◆ getThresholds()

ilSurveySkillThresholds::getThresholds ( )

Returns: array<int, array<int, int>>

Definition at line 57 of file class.ilSurveySkillThresholds.php.

                                   : array
    {
        return $this->threshold;
    }

References $threshold.

◆ read()

ilSurveySkillThresholds::read ( )

Definition at line 41 of file class.ilSurveySkillThresholds.php.

                          : void
    {
        $ilDB = $this->db;
 
        $set = $ilDB->query(
            "SELECT * FROM svy_skill_threshold " .
            " WHERE survey_id = " . $ilDB->quote($this->survey->getId(), "integer")
        );
        while ($rec = $ilDB->fetchAssoc($set)) {
            $this->threshold[(int) $rec['level_id']][(int) $rec['tref_id']] = (int) $rec['threshold'];
        }
    }

References $db, $ilDB, and ILIAS\Repository\int().

Referenced by __construct().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ writeThreshold()

ilSurveySkillThresholds::writeThreshold	(	int	$a_base_skill_id,
		int	$a_tref_id,
		int	$a_level_id,
		int	$a_threshold
	)

Definition at line 62 of file class.ilSurveySkillThresholds.php.

     : void {
        $ilDB = $this->db;
 
        $ilDB->replace(
            "svy_skill_threshold",
            array("survey_id" => array("integer", $this->survey->getId()),
                  "base_skill_id" => array("integer", $a_base_skill_id),
                  "tref_id" => array("integer", $a_tref_id),
                  "level_id" => array("integer", $a_level_id)
                ),
            array("threshold" => array("integer", $a_threshold))
        );
    }