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 Module_permission_model extends CI_Model {
public function create($data = array())
{
$this->db->where('fk_user_id', $data[0]['fk_user_id'])->delete('module_permission');
return $this->db->insert_batch('module_permission', $data);
}
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 single($id = null)
{
return $this->db->select("
module_permission.*,
module.name as module_name,
CONCAT_WS(' ',user.firstname,user.lastname) AS user_name
")
->from('module_permission')
->join('module', 'module.id = module_permission.fk_module_id', 'left')
->join('user','user.id = module_permission.fk_user_id', 'left')
->where('module_permission.fk_user_id', $id)
->get()
->result();
}
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("
module_permission.*,
module.name as module_name
")
->from('module_permission')
->join('module', 'module.id = module_permission.fk_module_id', 'left')
->where('module_permission.fk_user_id', $id)
->where('module_permission.fk_module_id', $value->id)
->get()
->row();
$mod[$value->id] = (object)array(
'name' => $value->name,
'fk_module_id' => $value->id,
'fk_user_id' => $id,
'create' => (!empty($modWisPer->create)?$modWisPer->create:0),
'read' => (!empty($modWisPer->read)?$modWisPer->read:0),
'update' => (!empty($modWisPer->update)?$modWisPer->update:0),
'delete' => (!empty($modWisPer->delete)?$modWisPer->delete:0)
);
}
return $mod;
}
public function delete($id = null)
{
return $this->db->where('fk_user_id', $id)
->delete("module_permission");
}
}