class.ilLDAPRoleGroupMappingSetting.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
class ilLDAPRoleGroupMappingSetting
{
    private ilDBInterface $db;
    private ilObjectDataCache $ilObjDataCache;
    private ilRbacReview $rbacreview;
 
    private int $mapping_id;
    private int $server_id;
 
    private ?string $url;
    private ?string $dn;
    private ?string $member_attribute;
    private ?bool $mapping_info_type;
    private ?bool $member_isdn;
    private ?int $role;
    private ?string $mapping_info;
 
    public function __construct(int $a_mapping_id)
    {
        global $DIC;
 
        $this->db = $DIC->database();
        $this->ilObjDataCache = $DIC['ilObjDataCache'];
        $this->rbacreview = $DIC['rbacreview'];
        $this->mapping_id = $a_mapping_id;
    }
 
    public function read(): void
    {
        $query = "SELECT * FROM ldap_rg_mapping "
                . "WHERE mapping_id = " . $this->db->quote($this->getMappingId(), 'integer');
        $set = $this->db->query($query);
        $rec = $this->db->fetchAssoc($set);
        $this->setMappingId((int) $rec["mapping_id"]);
        $this->setServerId((int) $rec["server_id"]);
        $this->setURL($rec["url"]);
        $this->setDN($rec["dn"]);
        $this->setMemberAttribute($rec["member_attribute"]);
        $this->setMemberISDN((bool) $rec["member_isdn"]);
        $this->setRole((int) $rec["role"]);
        $this->setMappingInfo($rec["mapping_info"]);
        $this->setMappingInfoType((bool) $rec["mapping_info_type"]);
    }
 
    public function delete(): void
    {
        $query = "DELETE FROM ldap_rg_mapping " .
            "WHERE mapping_id = " . $this->db->quote($this->getMappingId(), 'integer');
        $this->db->manipulate($query);
    }
 
    public function update(): void
    {
        $query = "UPDATE ldap_rg_mapping " .
                    "SET server_id = " . $this->db->quote($this->getServerId(), 'integer') . ", " .
                    "url = " . $this->db->quote($this->getURL(), 'text') . ", " .
                    "dn =" . $this->db->quote($this->getDN(), 'text') . ", " .
                    "member_attribute = " . $this->db->quote($this->getMemberAttribute(), 'text') . ", " .
                    "member_isdn = " . $this->db->quote($this->getMemberISDN(), 'integer') . ", " .
                    "role = " . $this->db->quote($this->getRole(), 'integer') . ", " .
                    "mapping_info = " . $this->db->quote($this->getMappingInfo(), 'text') . ", " .
                    "mapping_info_type = " . $this->db->quote($this->getMappingInfoType(), 'integer') . " " .
                    "WHERE mapping_id = " . $this->db->quote($this->getMappingId(), 'integer');
        $this->db->manipulate($query);
    }
 
    public function save(): void
    {
        $this->setMappingId($this->db->nextId('ldap_rg_mapping'));
        $query = "INSERT INTO ldap_rg_mapping (mapping_id,server_id,url,dn,member_attribute,member_isdn,role,mapping_info,mapping_info_type) " .
                    "VALUES ( " .
                    $this->db->quote($this->getMappingId(), 'integer') . ", " .
                    $this->db->quote($this->getServerId(), 'integer') . ", " .
                    $this->db->quote($this->getURL(), 'text') . ", " .
                    $this->db->quote($this->getDN(), 'text') . ", " .
                    $this->db->quote($this->getMemberAttribute(), 'text') . ", " .
                    $this->db->quote($this->getMemberISDN(), 'integer') . ", " .
                    $this->db->quote($this->getRole(), 'integer') . ", " .
                    $this->db->quote($this->getMappingInfo(), 'text') . ", " .
                    $this->db->quote($this->getMappingInfoType(), 'integer') .
                    ")";
        $this->db->manipulate($query);
    }
 
    public function getMappingId(): int
    {
        return $this->mapping_id;
    }
 
    public function setMappingId(int $a_value): void
    {
        $this->mapping_id = $a_value;
    }
 
    public function getServerId(): int
    {
        return $this->server_id;
    }
 
    public function setServerId(int $a_value): void
    {
        $this->server_id = $a_value;
    }
 
    public function getURL(): string
    {
        return $this->url;
    }
 
    public function setURL(string $a_value): void
    {
        $this->url = $a_value;
    }
 
    public function getDN(): string
    {
        return $this->dn;
    }
 
    public function setDN(string $a_value): void
    {
        $this->dn = $a_value;
    }
 
    public function getMemberAttribute(): string
    {
        return $this->member_attribute;
    }
 
    public function setMemberAttribute(string $a_value): void
    {
        $this->member_attribute = $a_value;
    }
 
    public function getMemberISDN(): bool
    {
        return $this->member_isdn;
    }
 
    public function setMemberISDN(bool $a_value): void
    {
        $this->member_isdn = $a_value;
    }
 
    public function getRole(): int
    {
        return $this->role;
    }
 
    public function setRole(int $a_value): void
    {
        $this->role = $a_value;
    }
 
    public function getRoleName(): string
    {
        return $this->ilObjDataCache->lookupTitle($this->role);
    }
 
    public function setRoleByName(string $a_value): void
    {
        $this->role = $this->rbacreview->roleExists(ilUtil::stripSlashes($a_value));
    }
 
    public function getMappingInfo(): string
    {
        return $this->mapping_info;
    }
 
    public function setMappingInfo(string $a_value): void
    {
        $this->mapping_info = $a_value;
    }
 
    public function getMappingInfoType(): bool
    {
        return $this->mapping_info_type;
    }
 
    public function setMappingInfoType(bool $a_value): void
    {
        $this->mapping_info_type = $a_value;
    }
}