ILIAS\Skill\Personal\AssignedMaterialDBRepository Class Reference

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 28 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 33 of file class.AssignedMaterialDBRepository.php.

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

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

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 53 of file class.AssignedMaterialDBRepository.php.

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

References $ilDB, and $user_id.

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 149 of file class.AssignedMaterialDBRepository.php.

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

References ILIAS\$db, $ilDB, and $user_id.

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 89 of file class.AssignedMaterialDBRepository.php.

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

References ILIAS\$db, $ilDB, and $user_id.

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 110 of file class.AssignedMaterialDBRepository.php.

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

References ILIAS\$db, $ilDB, and $user_id.

getFromRecord()

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

protected

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

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

References ILIAS\Repository\int().

Here is the call 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 163 of file class.AssignedMaterialDBRepository.php.

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

References ILIAS\$db, $ilDB, and $user_id.

removeAllForSkill()

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

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

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

References ILIAS\$db, and $ilDB.

removeAllForUser()

ILIAS\Skill\Personal\AssignedMaterialDBRepository::removeAllForUser

(

int

$user_id

)

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

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

References ILIAS\$db, $ilDB, and $user_id.

Field Documentation

$db

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

protected

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

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

$factory_service

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

protected

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

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

---

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

• components/ILIAS/Skill/Personal/class.AssignedMaterialDBRepository.php