ILIAS\Container\Skills\ContainerMemberSkillDBRepository Class Reference

Collaboration diagram for ILIAS\Container\Skills\ContainerMemberSkillDBRepository:

Public Member Functions
	__construct (?\ilDBInterface $db=null, ?SkillInternalFactoryService $factory_service=null,)
	add (int $cont_obj_id, int $user_id, int $skill_id, int $tref_id, int $level_id)
	remove (int $cont_obj_id, int $user_id, int $skill_id, int $tref_id)
	removeAll (int $cont_obj_id, int $user_id)
	removeForSkill (int $skill_node_id, bool $is_reference)
	publish (int $cont_obj_id, int $user_id)
	getPublished (int $cont_obj_id, int $user_id)
	getAll (int $cont_obj_id, int $user_id)
	getLevel (int $cont_obj_id, int $user_id, int $skill_id, int $tref_id)

Protected Member Functions
	getContainerMemberSkillFromRecord (array $rec)

Protected Attributes
ilDBInterface	$db
SkillInternalFactoryService	$factory_service

Detailed Description

Definition at line 23 of file class.ContainerMemberSkillDBRepository.php.

Constructor & Destructor Documentation

__construct()

ILIAS\Container\Skills\ContainerMemberSkillDBRepository::__construct	(	?\ilDBInterface	$db = null,
		?SkillInternalFactoryService	$factory_service = null
	)

Definition at line 28 of file class.ContainerMemberSkillDBRepository.php.

      {
        global $DIC;
 
        $this->db = ($db) ?: $DIC->database();
        $this->factory_service = ($factory_service) ?: $DIC->skills()->internalContainer()->factory();
    }

References ILIAS\Container\Skills\ContainerMemberSkillDBRepository\$db, $DIC, and ILIAS\Container\Skills\ContainerMemberSkillDBRepository\$factory_service.

Member Function Documentation

add()

ILIAS\Container\Skills\ContainerMemberSkillDBRepository::add	(	int	$cont_obj_id,
		int	$user_id,
		int	$skill_id,
		int	$tref_id,
		int	$level_id
	)

Definition at line 38 of file class.ContainerMemberSkillDBRepository.php.

                                                                                                   : void
    {
        $this->db->replace(
            "cont_member_skills",
            [
                "obj_id" => ["integer", $cont_obj_id],
                "user_id" => ["integer", $user_id],
                "skill_id" => ["integer", $skill_id],
                "tref_id" => ["integer", $tref_id]
            ],
            [
                "level_id" => ["integer", $level_id],
                "published" => ["integer", 0]
            ]
        );
    }

References $user_id.

getAll()

ILIAS\Container\Skills\ContainerMemberSkillDBRepository::getAll	(	int	$cont_obj_id,
		int	$user_id
	)

Returns

ContainerMemberSkill[]

Definition at line 108 of file class.ContainerMemberSkillDBRepository.php.

                                                          : array
    {
        $mem_skills = [];
        $set = $this->db->query(
            "SELECT * FROM cont_member_skills " .
            " WHERE obj_id = " . $this->db->quote($cont_obj_id, "integer") .
            " AND user_id = " . $this->db->quote($user_id, "integer")
        );
        while ($rec = $this->db->fetchAssoc($set)) {
            $mem_skills[] = $this->getContainerMemberSkillFromRecord($rec);
        }
        return $mem_skills;
    }

References $user_id, and ILIAS\Container\Skills\ContainerMemberSkillDBRepository\getContainerMemberSkillFromRecord().

Here is the call graph for this function:

getContainerMemberSkillFromRecord()

ILIAS\Container\Skills\ContainerMemberSkillDBRepository::getContainerMemberSkillFromRecord ( array  $rec )

protected

Definition at line 137 of file class.ContainerMemberSkillDBRepository.php.

                                                                    : ContainerMemberSkill
    {
        $rec["obj_id"] = (int) $rec["obj_id"];
        $rec["user_id"] = (int) $rec["user_id"];
        $rec["skill_id"] = (int) $rec["skill_id"];
        $rec["tref_id"] = (int) $rec["tref_id"];
        $rec["level_id"] = (int) $rec["level_id"];
        $rec["published"] = (bool) $rec["published"];
 
        return $this->factory_service->containerSkill()->memberSkill(
            $rec["obj_id"],
            $rec["user_id"],
            $rec["skill_id"],
            $rec["tref_id"],
            $rec["level_id"],
            $rec["published"]
        );
    }

References ILIAS\Repository\int().

Referenced by ILIAS\Container\Skills\ContainerMemberSkillDBRepository\getAll().

Here is the call graph for this function:

Here is the caller graph for this function:

getLevel()

ILIAS\Container\Skills\ContainerMemberSkillDBRepository::getLevel	(	int	$cont_obj_id,
		int	$user_id,
		int	$skill_id,
		int	$tref_id
	)

Definition at line 122 of file class.ContainerMemberSkillDBRepository.php.

                                                                                         : ?int
    {
        $set = $this->db->query(
            "SELECT * FROM cont_member_skills " .
            " WHERE obj_id = " . $this->db->quote($cont_obj_id, "integer") .
            " AND user_id = " . $this->db->quote($user_id, "integer") .
            " AND skill_id = " . $this->db->quote($skill_id, "integer") .
            " AND tref_id = " . $this->db->quote($tref_id, "integer")
        );
        if ($rec = $this->db->fetchAssoc($set)) {
            return (int) $rec["level_id"];
        }
        return null;
    }

References $user_id.

getPublished()

ILIAS\Container\Skills\ContainerMemberSkillDBRepository::getPublished	(	int	$cont_obj_id,
		int	$user_id
	)

Definition at line 90 of file class.ContainerMemberSkillDBRepository.php.

                                                                : bool
    {
        $set = $this->db->query(
            "SELECT published FROM cont_member_skills " .
            " WHERE obj_id = " . $this->db->quote($cont_obj_id, "integer") .
            " AND user_id = " . $this->db->quote($user_id, "integer")
        );
        while ($rec = $this->db->fetchAssoc($set)) {
            if ((bool) $rec["published"] === true) { // this is a little weak, but the value should be the same for all save skills
                return true;
            }
        }
        return false;
    }

References $user_id.

publish()

ILIAS\Container\Skills\ContainerMemberSkillDBRepository::publish	(	int	$cont_obj_id,
		int	$user_id
	)

Definition at line 82 of file class.ContainerMemberSkillDBRepository.php.

                                                           : void
    {
        $this->db->manipulate("UPDATE cont_member_skills SET " .
            " published = " . $this->db->quote(1, "integer") .
            " WHERE obj_id = " . $this->db->quote($cont_obj_id, "integer") .
            " AND user_id = " . $this->db->quote($user_id, "integer"));
    }

References $user_id.

remove()

ILIAS\Container\Skills\ContainerMemberSkillDBRepository::remove	(	int	$cont_obj_id,
		int	$user_id,
		int	$skill_id,
		int	$tref_id
	)

Definition at line 55 of file class.ContainerMemberSkillDBRepository.php.

                                                                                       : void
    {
        $this->db->manipulate("DELETE FROM cont_member_skills " .
            " WHERE obj_id = " . $this->db->quote($cont_obj_id, "integer") .
            " AND user_id = " . $this->db->quote($user_id, "integer") .
            " AND skill_id = " . $this->db->quote($skill_id, "integer") .
            " AND tref_id = " . $this->db->quote($tref_id, "integer"));
    }

References $user_id.

removeAll()

ILIAS\Container\Skills\ContainerMemberSkillDBRepository::removeAll	(	int	$cont_obj_id,
		int	$user_id
	)

Definition at line 64 of file class.ContainerMemberSkillDBRepository.php.

                                                             : void
    {
        $this->db->manipulate("DELETE FROM cont_member_skills " .
            " WHERE obj_id = " . $this->db->quote($cont_obj_id, "integer") .
            " AND user_id = " . $this->db->quote($user_id, "integer"));
    }

References $user_id.

removeForSkill()

ILIAS\Container\Skills\ContainerMemberSkillDBRepository::removeForSkill	(	int	$skill_node_id,
		bool	$is_reference
	)

Definition at line 71 of file class.ContainerMemberSkillDBRepository.php.

                                                                          : void
    {
        if (!$is_reference) {
            $this->db->manipulate("DELETE FROM cont_member_skills " .
                " WHERE skill_id = " . $this->db->quote($skill_node_id, "integer"));
        } else {
            $this->db->manipulate("DELETE FROM cont_member_skills " .
                " WHERE tref_id = " . $this->db->quote($skill_node_id, "integer"));
        }
    }

Field Documentation

$db

ilDBInterface ILIAS\Container\Skills\ContainerMemberSkillDBRepository::$db

protected

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

Referenced by ILIAS\Container\Skills\ContainerMemberSkillDBRepository\__construct().

$factory_service

SkillInternalFactoryService ILIAS\Container\Skills\ContainerMemberSkillDBRepository::$factory_service

protected

Definition at line 26 of file class.ContainerMemberSkillDBRepository.php.

Referenced by ILIAS\Container\Skills\ContainerMemberSkillDBRepository\__construct().

---

The documentation for this class was generated from the following file:

• components/ILIAS/Container/Skills/classes/class.ContainerMemberSkillDBRepository.php