class.ilLDAPRoleGroupMappingSetting.php

Go to the documentation of this file.

<?php

/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */

class ilLDAPRoleGroupMappingSetting
{
    public function __construct($a_mapping_id)
    {
        global $ilDB;
        $this->db = $ilDB;
        $this->mapping_id = $a_mapping_id;
    }
    
    public function read()
    {
        $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($rec["mapping_id"]);
        $this->setServerId($rec["server_id"]);
        $this->setURL($rec["url"]);
        $this->setDN($rec["dn"]);
        $this->setMemberAttribute($rec["member_attribute"]);
        $this->setMemberISDN($rec["member_isdn"]);
        $this->setRole($rec["role"]);
        $this->setMappingInfo($rec["mapping_info"]);
        $this->setMappingInfoType($rec["mapping_info_type"]);
    }
    
    public function delete()
    {
        $query = "DELETE FROM ldap_rg_mapping " .
            "WHERE mapping_id = " . $this->db->quote($this->getMappingId(), 'integer');
        $res = $this->db->manipulate($query);
    }
    
    public function update()
    {
        $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');
        $res = $this->db->manipulate($query);
    }
    
    public function save()
    {
        $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') .
                    ")";
        $res = $this->db->manipulate($query);
    }
    
    public function getMappingId()
    {
        return $this->mapping_id;
    }
    
    public function setMappingId($a_value)
    {
        $this->mapping_id = $a_value;
    }
    
    public function getServerId()
    {
        return $this->server_id;
    }
    
    public function setServerId($a_value)
    {
        $this->server_id = $a_value;
    }
    
    public function getURL()
    {
        return $this->url;
    }
    
    public function setURL($a_value)
    {
        $this->url = $a_value;
    }
    
    public function getDN()
    {
        return $this->dn;
    }
    
    public function setDN($a_value)
    {
        $this->dn = $a_value;
    }
    
    public function getMemberAttribute()
    {
        return $this->member_attribute;
    }
    
    public function setMemberAttribute($a_value)
    {
        $this->member_attribute = $a_value;
    }
    
    public function getMemberISDN()
    {
        return $this->member_isdn;
    }
    
    public function setMemberISDN($a_value)
    {
        $this->member_isdn = $a_value;
    }
    
    public function getRole()
    {
        return $this->role;
    }
    
    public function setRole($a_value)
    {
        $this->role = $a_value;
    }
    
    public function getRoleName()
    {
        global $ilObjDataCache;
        return $ilObjDataCache->lookupTitle($this->role);
    }
    
    public function setRoleByName($a_value)
    {
        global $rbacreview;
        $this->role = $rbacreview->roleExists(ilUtil::stripSlashes($a_value));
    }
    
    public function getMappingInfo()
    {
        return $this->mapping_info;
    }
    
    public function setMappingInfo($a_value)
    {
        $this->mapping_info = $a_value;
    }
    
    public function getMappingInfoType()
    {
        return $this->mapping_info_type;
    }
    
    public function setMappingInfoType($a_value)
    {
        $this->mapping_info_type = $a_value;
    }
}