dev-chiefworks
52 lines
1.5 KiB
PHP
52 lines
1.5 KiB
PHP
<?php if (!defined('BASEPATH')) {
|
|
exit('No direct script access allowed');
|
|
}
|
|
|
|
class Acl_Whitelist_Extra_model extends CI_Model {
|
|
|
|
private $read_replica;
|
|
|
|
public function __construct()
|
|
{
|
|
parent::__construct();
|
|
$this->read_replica = $this->load->database('savvy_replica', TRUE);
|
|
}
|
|
|
|
public function getRecordAclWhiteListExtraByParamNameAndParamValueAndAclWhiteListID($data) {
|
|
$this->read_replica->select('id');
|
|
$this->read_replica->from('bko_acl_whitelist_extra');
|
|
$this->read_replica->where('bko_acl_whitelist_id', $data['bko_acl_whitelist_id']);
|
|
$this->read_replica->where('parameter_name', $data['parameter_name']);
|
|
$this->read_replica->where('parameter_value', $data['parameter_value']);
|
|
|
|
return $this->read_replica->get()->num_rows();
|
|
}
|
|
|
|
public function insertAclWhitelistExtra($data) {
|
|
|
|
$this->db->insert('bko_acl_whitelist_extra', $data);
|
|
return $this->db->insert_id();
|
|
|
|
}
|
|
|
|
public function getRecordAclWhitelistExtraByID($data) {
|
|
return $this->read_replica->get_where('bko_acl_whitelist_extra', $data)->num_rows();
|
|
}
|
|
|
|
public function updateAclWhitelistExtra($data) {
|
|
$this->db->set('parameter_name', $data['parameter_name']);
|
|
$this->db->set('parameter_value', $data['parameter_value']);
|
|
$this->db->where('id', $data['id']);
|
|
$this->db->update('bko_acl_whitelist_extra');
|
|
|
|
return $this->db->affected_rows();
|
|
}
|
|
|
|
public function deleteAclWhitelistExtra($id) {
|
|
|
|
$this->db->where('id', $id);
|
|
$this->db->delete('bko_acl_whitelist_extra');
|
|
|
|
return $this->db->affected_rows();
|
|
}
|
|
} |