class.ilContainerGlobalProfiles.php

Go to the documentation of this file.

<?php
 
/* Copyright (c) 1998-2020 ILIAS open source, Extended GPL, see docs/LICENSE */
 
class ilContainerGlobalProfiles
{
    protected $db;
 
    protected $profiles = array();
 
    protected $obj_id;
 
    protected $mem_rol_id;
 
    public function __construct(int $a_obj_id)
    {
        global $DIC;
 
        $this->db = $DIC->database();
        $this->setObjId($a_obj_id);
 
        if ($this->getObjId() > 0) {
            $this->setMemberRoleId();
            $this->read();
        }
    }
 
    protected function setObjId(int $a_obj_id)
    {
        $this->obj_id = $a_obj_id;
    }
 
    protected function getObjId() : int
    {
        return $this->obj_id;
    }
 
    protected function setMemberRoleId()
    {
        $refs = ilObject::_getAllReferences($this->getObjId());
        $ref_id = end($refs);
        $this->mem_rol_id = ilParticipants::getDefaultMemberRole($ref_id);
    }
 
    protected function getMemberRoleId() : int
    {
        return $this->mem_rol_id;
    }
 
    public function resetProfiles()
    {
        $this->profiles = array();
    }
 
    public function addProfile(int $a_profile_id)
    {
        $this->profiles[$a_profile_id] = array(
            "profile_id" => $a_profile_id
        );
    }
 
    public function removeProfile(int $a_profile_id)
    {
        unset($this->profiles[$a_profile_id]);
    }
 
    public function getProfiles() : array
    {
        return $this->profiles;
    }
 
    protected function read()
    {
        $db = $this->db;
 
        $this->profiles = array();
        $set = $db->query(
            "SELECT spr.profile_id, spr.role_id, sp.title FROM skl_profile_role spr INNER JOIN skl_profile sp " .
            " ON spr.profile_id = sp.id " .
            " WHERE sp.ref_id = 0 " .
            " AND role_id  = " . $db->quote($this->getMemberRoleId(), "integer")
        );
        while ($rec = $db->fetchAssoc($set)) {
            $this->profiles[$rec["profile_id"]] = $rec;
        }
    }
 
    protected function delete()
    {
        $db = $this->db;
 
        $db->manipulate(
            "DELETE spr FROM skl_profile_role spr INNER JOIN skl_profile sp " .
            " ON spr.profile_id = sp.id " .
            " WHERE sp.ref_id = 0 " .
            " AND role_id = " . $db->quote($this->getMemberRoleId(), "integer")
        );
    }
 
    public function save()
    {
        $db = $this->db;
 
        $this->delete();
        foreach ($this->profiles as $p) {
            $db->manipulate("INSERT INTO skl_profile_role " .
                "(role_id, profile_id) VALUES (" .
                $db->quote($this->getMemberRoleId(), "integer") . "," .
                $db->quote($p["profile_id"], "integer") . ")");
        }
    }
}