Collaboration diagram for ILIAS\Skill\Personal\AssignedMaterialDBRepository:

Public Member Functions
	__construct (\ilDBInterface $db=null, Service\SkillInternalFactoryService $factory_service=null)

	assign (int $user_id, int $top_skill_id, int $tref_id, int $basic_skill_id, int $level_id, int $wsp_id)
	Assign material to skill level. More...

	get (int $user_id, int $tref_id, int $level_id)
	Get assigned materials (for a skill level and user) More...

	getAll (int $user_id, int $skill_id, int $tref_id)
	Get all assigned materials (for a skill and user) More...

	count (int $user_id, int $tref_id, int $level_id)
	Count assigned materials (for a skill level and user) More...

	remove (int $user_id, int $tref_id, int $level_id, int $wsp_id)

	removeAllForUser (int $user_id)

	removeAllForSkill (int $skill_node_id, bool $is_reference)

Protected Member Functions
	getFromRecord (array $rec)

Protected Attributes
ilDBInterface	$db

Service SkillInternalFactoryService	$factory_service

Detailed Description

Author: Thomas Famula famul.nosp@m.a@le.nosp@m.ifos..nosp@m.de

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

Constructor & Destructor Documentation

◆ __construct()

ILIAS\Skill\Personal\AssignedMaterialDBRepository::__construct	(	\ilDBInterface	$db = `null`,
		Service\SkillInternalFactoryService	$factory_service = `null`
	)

Definition at line 34 of file class.AssignedMaterialDBRepository.php.

References ILIAS\Skill\Personal\AssignedMaterialDBRepository\$db, $DIC, and ILIAS\Skill\Personal\AssignedMaterialDBRepository\$factory_service.

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

Member Function Documentation

◆ assign()

ILIAS\Skill\Personal\AssignedMaterialDBRepository::assign	(	int	$user_id,
		int	$top_skill_id,
		int	$tref_id,
		int	$basic_skill_id,
		int	$level_id,
		int	$wsp_id
	)

Assign material to skill level.

Parameters

int	$user_id	user id
int	$top_skill_id	the "selectable" top skill
int	$tref_id	template reference id
int	$basic_skill_id	the basic skill the level belongs to
int	$level_id	level id
int	$wsp_id	workspace object

Definition at line 54 of file class.AssignedMaterialDBRepository.php.

References ILIAS\Skill\Personal\AssignedMaterialDBRepository\$db, and $ilDB.

      : void {
         $ilDB = $this->db;
 
         $set = $ilDB->query(
             "SELECT * FROM skl_assigned_material " .
             " WHERE user_id = " . $ilDB->quote($user_id, "integer") .
             " AND top_skill_id = " . $ilDB->quote($top_skill_id, "integer") .
             " AND tref_id = " . $ilDB->quote($tref_id, "integer") .
             " AND skill_id = " . $ilDB->quote($basic_skill_id, "integer") .
             " AND level_id = " . $ilDB->quote($level_id, "integer") .
             " AND wsp_id = " . $ilDB->quote($wsp_id, "integer")
         );
         if (!$ilDB->fetchAssoc($set)) {
             $ilDB->manipulate("INSERT INTO skl_assigned_material " .
                 "(user_id, top_skill_id, tref_id, skill_id, level_id, wsp_id) VALUES (" .
                 $ilDB->quote($user_id, "integer") . "," .
                 $ilDB->quote($top_skill_id, "integer") . "," .
                 $ilDB->quote($tref_id, "integer") . "," .
                 $ilDB->quote($basic_skill_id, "integer") . "," .
                 $ilDB->quote($level_id, "integer") . "," .
                 $ilDB->quote($wsp_id, "integer") .
                 ")");
         }
     }

◆ count()

ILIAS\Skill\Personal\AssignedMaterialDBRepository::count	(	int	$user_id,
		int	$tref_id,
		int	$level_id
	)

Count assigned materials (for a skill level and user)

Definition at line 150 of file class.AssignedMaterialDBRepository.php.

References ILIAS\Skill\Personal\AssignedMaterialDBRepository\$db, and $ilDB.

                                                                     : int
     {
         $ilDB = $this->db;
 
         $set = $ilDB->query(
             "SELECT count(*) as cnt FROM skl_assigned_material " .
             " WHERE level_id = " . $ilDB->quote($level_id, "integer") .
             " AND tref_id = " . $ilDB->quote($tref_id, "integer") .
             " AND user_id = " . $ilDB->quote($user_id, "integer")
         );
         $rec = $ilDB->fetchAssoc($set);
         return (int) $rec["cnt"];
     }

◆ get()

ILIAS\Skill\Personal\AssignedMaterialDBRepository::get	(	int	$user_id,
		int	$tref_id,
		int	$level_id
	)

Get assigned materials (for a skill level and user)

Returns: AssignedMaterial[]

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

References ILIAS\Skill\Personal\AssignedMaterialDBRepository\$db, $ilDB, and ILIAS\Skill\Personal\AssignedMaterialDBRepository\getFromRecord().

                                                                   : array
     {
         $ilDB = $this->db;
 
         $set = $ilDB->query(
             "SELECT * FROM skl_assigned_material " .
             " WHERE level_id = " . $ilDB->quote($level_id, "integer") .
             " AND tref_id = " . $ilDB->quote($tref_id, "integer") .
             " AND user_id = " . $ilDB->quote($user_id, "integer")
         );
         $mat = [];
         while ($rec = $ilDB->fetchAssoc($set)) {
             $mat[] = $this->getFromRecord($rec);
         }
         return $mat;
     }

Here is the call graph for this function:

◆ getAll()

ILIAS\Skill\Personal\AssignedMaterialDBRepository::getAll	(	int	$user_id,
		int	$skill_id,
		int	$tref_id
	)

Get all assigned materials (for a skill and user)

Returns: AssignedMaterial[]

Definition at line 111 of file class.AssignedMaterialDBRepository.php.

References ILIAS\Skill\Personal\AssignedMaterialDBRepository\$db, $ilDB, and ILIAS\Skill\Personal\AssignedMaterialDBRepository\getFromRecord().

                                                                      : array
     {
         $ilDB = $this->db;
 
         $set = $ilDB->query(
             "SELECT * FROM skl_assigned_material " .
             " WHERE skill_id = " . $ilDB->quote($skill_id, "integer") .
             " AND tref_id = " . $ilDB->quote($tref_id, "integer") .
             " AND user_id = " . $ilDB->quote($user_id, "integer")
         );
         $mat = [];
         while ($rec = $ilDB->fetchAssoc($set)) {
             $mat[] = $this->getFromRecord($rec);
         }
         return $mat;
     }

Here is the call graph for this function:

◆ getFromRecord()

ILIAS\Skill\Personal\AssignedMaterialDBRepository::getFromRecord ( array $rec )

protected

Definition at line 128 of file class.AssignedMaterialDBRepository.php.

References ILIAS\Repository\int().

Referenced by ILIAS\Skill\Personal\AssignedMaterialDBRepository\get(), and ILIAS\Skill\Personal\AssignedMaterialDBRepository\getAll().

                                                 : AssignedMaterial
     {
         $rec['user_id'] = (int) $rec['user_id'];
         $rec['top_skill_id'] = (int) $rec['top_skill_id'];
         $rec['skill_id'] = (int) $rec['skill_id'];
         $rec['level_id'] = (int) $rec['level_id'];
         $rec['wsp_id'] = (int) $rec['wsp_id'];
         $rec['tref_id'] = (int) $rec['tref_id'];
 
         return $this->factory_service->personal()->assignedMaterial(
             $rec['user_id'],
             $rec['top_skill_id'],
             $rec['skill_id'],
             $rec['level_id'],
             $rec['wsp_id'],
             $rec['tref_id']
         );
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ remove()

ILIAS\Skill\Personal\AssignedMaterialDBRepository::remove	(	int	$user_id,
		int	$tref_id,
		int	$level_id,
		int	$wsp_id
	)

Definition at line 164 of file class.AssignedMaterialDBRepository.php.

References ILIAS\Skill\Personal\AssignedMaterialDBRepository\$db, and $ilDB.

                                                                                   : void
     {
         $ilDB = $this->db;
 
         $t = "DELETE FROM skl_assigned_material WHERE " .
             " user_id = " . $ilDB->quote($user_id, "integer") .
             " AND tref_id = " . $ilDB->quote($tref_id, "integer") .
             " AND level_id = " . $ilDB->quote($level_id, "integer") .
             " AND wsp_id = " . $ilDB->quote($wsp_id, "integer");
 
         $ilDB->manipulate($t);
     }

◆ removeAllForSkill()

ILIAS\Skill\Personal\AssignedMaterialDBRepository::removeAllForSkill	(	int	$skill_node_id,
		bool	$is_reference
	)

Definition at line 186 of file class.AssignedMaterialDBRepository.php.

References ILIAS\Skill\Personal\AssignedMaterialDBRepository\$db, and $ilDB.

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

◆ removeAllForUser()

ILIAS\Skill\Personal\AssignedMaterialDBRepository::removeAllForUser ( int $user_id )

Definition at line 177 of file class.AssignedMaterialDBRepository.php.

References ILIAS\Skill\Personal\AssignedMaterialDBRepository\$db, and $ilDB.

                                                   : void
     {
         $ilDB = $this->db;
 
         $t = "DELETE FROM skl_assigned_material WHERE " .
             " user_id = " . $ilDB->quote($user_id, "integer");
         $ilDB->manipulate($t);
     }

Field Documentation

◆ $db

ilDBInterface ILIAS\Skill\Personal\AssignedMaterialDBRepository::$db

protected

Definition at line 31 of file class.AssignedMaterialDBRepository.php.

◆ $factory_service

Service SkillInternalFactoryService ILIAS\Skill\Personal\AssignedMaterialDBRepository::$factory_service

protected

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

Referenced by ILIAS\Skill\Personal\AssignedMaterialDBRepository\__construct().

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

Services/Skill/Personal/class.AssignedMaterialDBRepository.php

Public Member Functions

Protected Member Functions

Protected Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ assign()

◆ count()

◆ get()

◆ getAll()

◆ getFromRecord()

◆ remove()

◆ removeAllForSkill()

◆ removeAllForUser()

Field Documentation

◆ $db

◆ $factory_service