���� JFIF �� � ( %"1"%)+...383,7(-.-
![]() Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /var/www/html/adimi/application/modules/dashboard/models/ |
<?php defined('BASEPATH') OR exit('No direct script access allowed'); class Role_model extends CI_Model { public function create($data = array()) { $this->db->where('role_id', $data[0]['role_id'])->delete('sec_role_permission'); return $this->db->insert_batch('sec_role_permission', $data); } public function get_role_module_list() { return $this->db->select('*')->from('sec_menu_item')->group_by('module')->order_by('menu_id','asc')->get()->result(); } public function update($data = array()) { $this->db->where('fk_role_id', $data[0]['fk_role_id'])->delete('user_role_access_tbl'); return $this->db->insert_batch('user_role_access_tbl', $data); } public function get_all_role() { return $this->db->select("user_role_setup_tbl.*,user_role_access_tbl.*") ->from('user_role_setup_tbl') ->join('user_role_access_tbl','user_role_access_tbl.fk_role_id = user_role_setup_tbl.role_id', 'left') ->group_by('user_role_setup_tbl.role_id') ->order_by('user_role_setup_tbl.role_id','asc') ->get() ->result(); } public function read() { return $this->db->select(" module_permission.fk_user_id, CONCAT_WS(' ', user.firstname,user.lastname) AS user_name, ") ->from('module_permission') ->join('user','user.id = module_permission.fk_user_id', 'left') ->group_by('module_permission.fk_user_id') ->order_by('user.firstname','asc') ->get() ->result(); } public function view($id = null) { $result = $this->db->select(" user_role_access_tbl.*, module.name as module_name ") ->from('user_role_access_tbl') ->join('module', 'module.id = user_role_access_tbl.fk_module_id', 'left') ->where('user_role_access_tbl.fk_role_id', $id) ->get() ->result(); return $result; } public function get_role_by_id($id = null) { return $this->db->select("*") ->from('user_role_setup_tbl') ->where('role_id', $id) ->get() ->row(); } public function permission_edit($id = null) { $modules = $this->db->select("id, name") ->from("module") ->where("status", 1) ->get() ->result(); $mod = array(); foreach ($modules as $value) { $modWisPer = $this->db->select(" user_role_access_tbl.*, module.name as module_name ") ->from('user_role_access_tbl') ->join('module', 'module.id = user_role_access_tbl.fk_module_id', 'left') ->where('user_role_access_tbl.fk_role_id', $id) ->where('user_role_access_tbl.fk_module_id', $value->id) ->get() ->row(); $mod[$value->id] = (object)array( 'name' => $value->name, 'fk_module_id' => $value->id, 'fk_role_id' => $id, 'create' => (!empty($modWisPer->_permission)?$modWisPer->_permission:0), 'read' => (!empty($modWisPer->view_permission)?$modWisPer->view_permission:0), 'update' => (!empty($modWisPer->update_permission)?$modWisPer->update_permission:0), 'delete' => (!empty($modWisPer->delete_permission)?$modWisPer->delete_permission:0) ); } return $mod; } public function delete($role_id = null) { $this->db->where('role_id', $role_id) ->delete("user_role_setup_tbl"); return $this->db->where('fk_role_id', $role_id) ->delete("user_role_access_tbl"); } }