class.SkillProfileLevelsDBRepository.php

Go to the documentation of this file.

<?php

namespace ILIAS\Skill\Profile;

class SkillProfileLevelsDBRepository
{
    protected \ilDBInterface $db;

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

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

    public function getProfileLevels(int $profile_id): array
    {
        $ilDB = $this->db;

        $set = $ilDB->query(
            "SELECT * FROM skl_profile_level " .
            " WHERE profile_id = " . $ilDB->quote($profile_id, "integer")
        );

        $levels = [];
        while ($rec = $ilDB->fetchAssoc($set)) {
            $levels[] = [
                "base_skill_id" => (int) $rec["base_skill_id"],
                "tref_id" => (int) $rec["tref_id"],
                "level_id" => (int) $rec["level_id"],
                "order_nr" => (int) $rec["order_nr"]
            ];
        }

        return $levels;
    }

    public function createProfileLevels(int $profile_id, array $levels): void
    {
        $ilDB = $this->db;

        foreach ($levels as $level) {
            $ilDB->replace(
                "skl_profile_level",
                array("profile_id" => array("integer", $profile_id),
                      "tref_id" => array("integer", (int) $level["tref_id"]),
                      "base_skill_id" => array("integer", (int) $level["base_skill_id"])
                ),
                array("order_nr" => array("integer", (int) $level["order_nr"]),
                      "level_id" => array("integer", (int) $level["level_id"])
                )
            );
        }
    }

    public function updateProfileLevels(int $profile_id, array $levels): void
    {
        $ilDB = $this->db;

        $ilDB->manipulate(
            "DELETE FROM skl_profile_level WHERE " .
            " profile_id = " . $ilDB->quote($profile_id, "integer")
        );
        foreach ($levels as $level) {
            $ilDB->replace(
                "skl_profile_level",
                array("profile_id" => array("integer", $profile_id),
                      "tref_id" => array("integer", (int) $level["tref_id"]),
                      "base_skill_id" => array("integer", (int) $level["base_skill_id"])
                ),
                array("order_nr" => array("integer", (int) $level["order_nr"]),
                      "level_id" => array("integer", (int) $level["level_id"])
                )
            );
        }
    }

    public function deleteProfileLevels(int $profile_id): void
    {
        $ilDB = $this->db;

        $ilDB->manipulate(
            "DELETE FROM skl_profile_level WHERE " .
            " profile_id = " . $ilDB->quote($profile_id, "integer")
        );
    }

    public function updateSkillOrder(int $profile_id, array $order): void
    {
        $ilDB = $this->db;

        $cnt = 1;
        foreach ($order as $id => $o) {
            $id_arr = explode("_", $id);
            $ilDB->manipulate(
                "UPDATE skl_profile_level SET " .
                " order_nr = " . $ilDB->quote(($cnt * 10), "integer") .
                " WHERE base_skill_id = " . $ilDB->quote($id_arr[0], "integer") .
                " AND tref_id = " . $ilDB->quote($id_arr[1], "integer") .
                " AND profile_id = " . $ilDB->quote($profile_id, "integer")
            );
            $cnt++;
        }
    }

    public function fixSkillOrderNumbering(int $profile_id): void
    {
        $ilDB = $this->db;

        $set = $ilDB->query(
            "SELECT profile_id, base_skill_id, tref_id, order_nr FROM skl_profile_level WHERE " .
            " profile_id = " . $ilDB->quote($profile_id, "integer") .
            " ORDER BY order_nr ASC"
        );
        $cnt = 1;
        while ($rec = $ilDB->fetchAssoc($set)) {
            $ilDB->manipulate(
                "UPDATE skl_profile_level SET " .
                " order_nr = " . $ilDB->quote(($cnt * 10), "integer") .
                " WHERE profile_id = " . $ilDB->quote($rec["profile_id"], "integer") .
                " AND base_skill_id = " . $ilDB->quote($rec["base_skill_id"], "integer") .
                " AND tref_id = " . $ilDB->quote($rec["tref_id"], "integer")
            );
            $cnt++;
        }
    }

    public function getMaxLevelOrderNr(int $profile_id): int
    {
        $ilDB = $this->db;

        $set = $ilDB->query(
            "SELECT MAX(order_nr) mnr FROM skl_profile_level WHERE " .
            " profile_id = " . $ilDB->quote($profile_id, "integer")
        );
        $rec = $ilDB->fetchAssoc($set);
        return (int) $rec["mnr"];
    }
}