dev-chiefworks
101 lines
3.6 KiB
PHP
101 lines
3.6 KiB
PHP
<?php if (!defined('BASEPATH')) {
|
|
exit('No direct script access allowed');
|
|
}
|
|
|
|
class Acl_Whitelist_model extends CI_Model {
|
|
|
|
private $read_replica;
|
|
|
|
public function __construct()
|
|
{
|
|
parent::__construct();
|
|
$this->read_replica = $this->load->database('savvy_replica', TRUE);
|
|
}
|
|
|
|
public function getControllerAndMethod() {
|
|
$this->read_replica->select('acl_wl.id AS bko_acl_whitelist_id, CONCAT(acl.class_name, \' - \', acl.method_name) AS class_method');
|
|
$this->read_replica->from('bko_acl_whitelist acl_wl');
|
|
$this->read_replica->join('bko_acl acl', 'acl.id = acl_wl.bko_acl_id');
|
|
|
|
$query = $this->read_replica->get();
|
|
|
|
return array_column($query->result_array(), 'class_method', 'bko_acl_whitelist_id');
|
|
}
|
|
|
|
// Fetch records
|
|
public function getData($rowno,$rowperpage, $filters = []) {
|
|
|
|
$this->read_replica->select( 'acl.id AS acl_id,
|
|
acl_wl_ext.id AS acl_wl_ext_id,
|
|
acl_wl.id AS acl_wl_id,
|
|
acl.method_name AS method_name,
|
|
acl.class_name AS class_name,
|
|
pl.name AS name,
|
|
acl_wl_ext.parameter_name AS parameter_name,
|
|
acl_wl_ext.parameter_value AS parameter_value');
|
|
$this->read_replica->from('bko_acl acl');
|
|
$this->read_replica->join('bko_acl_permission_level', 'acl.id = bko_acl_permission_level.bko_acl_id ');
|
|
$this->read_replica->join('bko_permission_level pl', 'bko_acl_permission_level.plevel = pl.plevel ');
|
|
$this->read_replica->join('bko_acl_whitelist acl_wl', 'acl_wl.bko_acl_id = acl.id ');
|
|
$this->read_replica->join('bko_acl_whitelist_extra acl_wl_ext', 'acl_wl_ext.bko_acl_whitelist_id = acl_wl.id ');
|
|
|
|
foreach($filters as $key => $value) {
|
|
if ($key === 'card_class_filter') {
|
|
|
|
$this->read_replica->where('lower(acl.class_name)', strtolower($value));
|
|
|
|
} else if ($key === 'method_filter') {
|
|
|
|
$this->read_replica->like('acl.method_name', strtolower($value));
|
|
|
|
} else {
|
|
|
|
$this->read_replica->where('pl.plevel', $value);
|
|
|
|
}
|
|
}
|
|
|
|
$this->read_replica->order_by('acl_id');
|
|
$this->read_replica->limit($rowperpage, $rowno);
|
|
$query = $this->read_replica->get();
|
|
|
|
return $query->result_array();
|
|
}
|
|
|
|
// Select total records
|
|
public function getrecordCount($filters = []) {
|
|
|
|
$this->read_replica->select('count(*) as allcount');
|
|
$this->read_replica->from('bko_acl acl');
|
|
$this->read_replica->join('bko_acl_permission_level', 'acl.id = bko_acl_permission_level.bko_acl_id ');
|
|
$this->read_replica->join('bko_permission_level pl', 'bko_acl_permission_level.plevel = pl.plevel ');
|
|
$this->read_replica->join('bko_acl_whitelist acl_wl', 'acl_wl.bko_acl_id = acl.id ');
|
|
$this->read_replica->join('bko_acl_whitelist_extra acl_wl_ext', 'acl_wl_ext.bko_acl_whitelist_id = acl_wl.id ');
|
|
|
|
foreach($filters as $key => $value) {
|
|
if ($key === 'card_class_filter') {
|
|
|
|
$this->read_replica->where('lower(acl.class_name)', strtolower($value));
|
|
|
|
} else if ($key === 'method_filter') {
|
|
|
|
$this->read_replica->like('acl.method_name', strtolower($value));
|
|
|
|
} else {
|
|
|
|
$this->read_replica->where('pl.plevel', $value);
|
|
|
|
}
|
|
}
|
|
|
|
$query = $this->read_replica->get();
|
|
$result = $query->result_array();
|
|
|
|
return $result[0]['allcount'];
|
|
}
|
|
|
|
public function getRecordAclWhitelistById($data) {
|
|
$this->read_replica->get_where('bko_acl_whitelist', $data);
|
|
return $this->read_replica->affected_rows();
|
|
}
|
|
} |