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 24 of file class.ContainerMemberSkillDBRepository.php.

Constructor & Destructor Documentation

◆ __construct()

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

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

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

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

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 39 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]
             ]
         );
     }

◆ getAll()

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

Returns: ContainerMemberSkill[]

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

References ILIAS\Container\Skills\ContainerMemberSkillDBRepository\getContainerMemberSkillFromRecord().

                                                           : 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;
     }

Here is the call graph for this function:

◆ getContainerMemberSkillFromRecord()

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

protected

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

References ILIAS\Repository\int().

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

                                                                     : 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"]
         );
     }

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 123 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;
     }

◆ getPublished()

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

Definition at line 91 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;
     }

◆ publish()

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

Definition at line 83 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"));
     }

◆ remove()

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

Definition at line 56 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"));
     }

◆ removeAll()

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

Definition at line 65 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"));
     }

◆ removeForSkill()

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

Definition at line 72 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"));
         }
     }