citywebshop_cms/application/models/admin_roles_model.php

<?php

class admin_roles_model extends Model {
    
    
    public function getRoles() {
        $result = $this->query("select * from azonics_roles where role_status='1';");
        return $result;
    }
    
    
    public function loadRole() {
        $role_id = $this->escapeString($_REQUEST['id']);
        $row = $this->query("select * from azonics_roles where role_id='".$role_id."';");
        return $row[0];
    }
    
    
    public function saveRole() {
        $data = $this->escapeArray($_REQUEST);
        
        if ($data['role_id']!='') {
            $this->execute("update azonics_roles set "
                    . "role_name='".$data['role_name']."' "
                    . "where role_id='".$data['role_id']."';");
            
            return true;
        }
        else {
            $checkAlredy = $this->query("select * from azonics_roles where "
                    . "role_name='".$data['role_name']."' and "
                    . "role_status='1';");
            
            if (sizeof($checkAlredy)>0) {
                return false;
            }
            else {
                $this->execute("insert into azonics_roles set role_name='".$data['role_name']."', role_status='1';");
                return true;
            }
        }
    }
    
    
    public function deleteRole() {
        $role_id = $this->escapeString($_REQUEST['id']);
        $this->execute("update azonics_roles set role_status='0' where role_id='".$role_id."';");
        return true;
    }
    
    
    public function setModuleRole() {
        $roleID = $this->escapeString($_REQUEST['roleID']);
        $moduleID = $this->escapeString($_REQUEST['moduleID']);
        
        if ($roleID!='' && $moduleID!='') {
            $result = $this->query("select * from azonics_modules_role where "
                    . "modrole_role_id='".$roleID."' and "
                    . "modrole_module_id='".$moduleID."' and "
                    . "modrole_status='1';");
            
            if (sizeof($result)>0) {
                $this->execute("delete from azonics_modules_role where "
                        . "modrole_role_id='".$roleID."' and "
                        . "modrole_module_id='".$moduleID."' and "
                        . "modrole_status='1';");
                
                return true;
            }
            else {
                $this->execute("insert into azonics_modules_role set "
                        . "modrole_role_id='".$roleID."', "
                        . "modrole_module_id='".$moduleID."', "
                        . "modrole_status='1';");
                
                return true;
            }
        }
        else {
            return false;
        }
    }
    
    
}