|
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/libraries/../models/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php defined('BASEPATH') OR exit('No direct script access allowed');
/**
*
*/
class Settings_model extends BaseModel
{
function __constuct(){
parent::__construct();
}
public function _get_system_links($param,$single_row=TRUE,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='system_links';
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 store_system_links($data,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='system_links';
return $this->store($data,FALSE,$return_query);
}
public function update_system_links($data,$param,$batch=FALSE,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='system_links';
return $this->modify($data,$param,$batch,$return_query);
}
//Settings
public function get_system_settings($param,$single_row=TRUE,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_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);
}
}
public function get_system_payment_gateways($param,$single_row=TRUE,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='system_payment_gateways';
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 store_system_settings($data,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_settings';
return $this->store($data,FALSE,$return_query);
}
public function update_system_settings($data,$param,$batch=FALSE,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_settings';
return $this->modify($data,$param,$batch,$return_query);
}
public function delete_system_settings($param,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_settings';
return $this->remove($param,0,$return_query);
}
public function store_payment_gateway_institutes_settings($data,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='system_payment_gateways_institutes';
return $this->store($data,FALSE,$return_query);
}
public function delete_payment_gateway_institutes_settings($param,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='system_payment_gateways_institutes';
return $this->remove($param,0,$return_query);
}
public function update_payment_gateway_institutes_settings($data,$param,$batch=FALSE,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='system_payment_gateways_institutes';
return $this->modify($data,$param,$batch,$return_query);
}
public function get_payment_gateway_institutes_settings($param,$single_row=TRUE,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='system_payment_gateways_institutes';
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_payment_gateway_settings($param,$single_row=TRUE,$return_query=FALSE){
$this->_db->select('system_payment_gateways.*,system_payment_gateways_institutes.payment_gateway_inst_id,system_payment_gateways_institutes.payment_gateway_status');
$this->_db->join('system_payment_gateways_institutes','system_payment_gateways_institutes.payment_gateway_id=system_payment_gateways.gateway_id','LEFT');
$this->_db->where($param);
$result=$this->_db->get('system_payment_gateways');
if($single_row==TRUE){
if($return_query==FALSE){
return $result->first_row();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}else if($single_row==FALSE){
if($return_query==FALSE){
return $result->result();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
}
//Settings
//Storage
public function store_file($data,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='storage';
return $this->store($data,FALSE,$return_query);
}
public function delete_file($param,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='storage';
return $this->remove($param,0,$return_query);
}
public function update_file($data,$param,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='storage';
return $this->modify($data,$param,FALSE,$return_query);
}
public function get_file($param=null,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='storage';
return $this->get_one($param,'',$return_query);
}
public function get_files($param,$order_by=null,$order='DESC',$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='storage';
return $this->get_many($param,$order_by,$order,$return_query);
}
public function get_file_in($param,$param_val,$return_query=FALSE){
$this->table='storage';
return $this->sm->get_in($param,$param_val,$return_query);
}
//Countries
public function _get_countries($param=null,$single_row=TRUE,$return_query=FALSE){
$this->table='countries';
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);
}
}
//States
public function _get_states($param=null,$single_row=TRUE,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='states';
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);
}
}
//Districts
public function _get_districts($param=null,$single_row=TRUE,$return_query=FALSE){
$this->table='districts';
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);
}
}
//Booking Types
public function _get_booking_types($param=null,$single_row=TRUE,$return_query=FALSE){
$this->table='booking_type';
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_blood_groups($param=null,$single_row=TRUE,$return_query=FALSE){
$this->table='blood_groups';
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_occupations($param=null,$single_row=TRUE,$return_query=FALSE){
$this->table='occupations';
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);
}
}
//Application Types
public function _get_application_types($param=null,$single_row=TRUE,$return_query=FALSE){
$this->table='institute_application_type';
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);
}
}
//Banks
public function store_bank_data($data,$return_query=FALSE){
$this->table='institute_banks';
return $this->store($data,FALSE,$return_query);
}
public function update_bank_data($data,$param,$batch=FALSE,$return_query=FALSE){
$this->table='institute_banks';
return $this->modify($data,$param,$batch,$return_query);
}
public function get_banks($param=null,$single_row=TRUE,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_banks';
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_banks($post=array(),$param=array(),$count=FALSE,$return_query=FALSE){
$this->_db->select('institute_banks.*');
$i = 0;
if(isset($param['bank_inst_id'])){
$this->_db->where('bank_inst_id',$param['bank_inst_id']);
}
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_banks');
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_banks');
if($return_query==FALSE){
return $query->num_rows();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
}
//Banks Balance
public function store_bank_balance_data($data,$return_query=FALSE){
$this->table='institute_banks_balance';
return $this->store($data,FALSE,$return_query);
}
public function update_bank_balance_data($data,$param,$batch=FALSE,$return_query=FALSE){
$this->table='institute_banks_balance';
return $this->modify($data,$param,$batch,$return_query);
}
public function get_bank_balance($param=null,$single_row=TRUE,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_banks_balance';
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_bank_balance($post=array(),$param=array(),$count=FALSE,$return_query=FALSE){
$this->_db->select('institute_banks.*,institute_banks_balance.*');
$this->_db->join('institute_banks','institute_banks.bank_id=institute_banks_balance.balance_bank_id','LEFT');
$i = 0;
if(isset($param['bank_inst_id'])){
$this->_db->where('balance_inst_id',$param['bank_inst_id']);
}
if(isset($param['bank_id'])){
$this->_db->where('balance_bank_id',$param['bank_id']);
}
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_banks_balance');
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_banks_balance');
if($return_query==FALSE){
return $query->num_rows();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
}
//Cash Balance
public function store_cash_balance_data($data,$return_query=FALSE){
$this->table='institute_cash_balance';
return $this->store($data,FALSE,$return_query);
}
public function update_cash_balance_data($data,$param,$batch=FALSE,$return_query=FALSE){
$this->table='institute_cash_balance';
return $this->modify($data,$param,$batch,$return_query);
}
public function get_cash_balance($param=null,$single_row=TRUE,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_cash_balance';
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 delete_cash_data($param,$return_query=FALSE){
$this->table='institute_cash_balance';
return $this->remove($param,0,$return_query);
}
public function _get_cash_balance($post=array(),$param=array(),$count=FALSE,$return_query=FALSE){
$this->_db->select('institute_cash_balance.*');
$i = 0;
if(isset($param['inst_id'])){
$this->_db->where('balance_inst_id',$param['inst_id']);
}
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_cash_balance');
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_cash_balance');
if($return_query==FALSE){
return $query->num_rows();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
}
//Notifications
public function store_notification($data,$return_query=FALSE){
$this->table='notifications';
return $this->store($data,FALSE,$return_query);
}
public function delete_notification($param,$return_query=FALSE){
$this->table='notifications';
return $this->remove($param,0,$return_query);
}
public function update_notification($data,$param,$return_query=FALSE){
$this->table='notifications';
return $this->modify($data,$param,FALSE,$return_query);
}
public function get_notification($param=null,$return_query=FALSE){
$this->table='notifications';
return $this->get_one($param,$return_query);
}
public function _get_notification($post=array(),$param=array(),$count=FALSE,$return_query=FALSE){
$this->_db->select('notifications.*');
$i = 0;
if($count==FALSE){
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(isset($param['length']) && $param['length'] != -1){
$this->_db->limit($param['length'],$param['start']);
}
$query = $this->_db->get('notifications');
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('notifications');
if($return_query==FALSE){
return $query->num_rows();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
}
//Users Positions
public function get_user_position($param=null,$single_row=TRUE,$return_query=FALSE){
$this->table='system_users_position';
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);
}
}
//Packages
public function get_packages($param=null,$single_row=TRUE,$return_query=FALSE){
$this->table='system_package';
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_packages($param=null,$single_row=TRUE,$return_query=FALSE){
$this->_db->select('system_package.*,system_package_details.package_details');
$this->_db->join('system_package_details','system_package_details.pacakge_id=system_package.package_id','LEFT');
$this->_db->where($param);
$result=$this->_db->get('system_package');
if($single_row==TRUE){
if($return_query==FALSE){
return $result->first_row();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}else if($single_row==FALSE){
if($return_query==FALSE){
return $result->result();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
}
//Agent Commission Model
public function store_agent_commission_settings($data,$return_query=FALSE){
$this->table='institute_agent_commission_settings';
return $this->store($data,FALSE,$return_query);
}
public function delete_agent_commission_settings($param,$return_query=FALSE){
$this->table='institute_agent_commission_settings';
return $this->remove($param,0,$return_query);
}
public function update_agent_commission_settings($data,$param,$return_query=FALSE){
$this->table='institute_agent_commission_settings';
return $this->modify($data,$param,FALSE,$return_query);
}
public function get_agent_commission_settings($param=null,$single_row=TRUE,$return_query=FALSE){
$this->table='institute_agent_commission_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);
}
}
public function _get_agent_commission_settings($post=array(),$param=array(),$count=FALSE,$return_query=FALSE){
$this->_db->select('institute_agent_commission_settings.*,institute_sessions.session_start_year,institute_sessions.session_end_year,institute_courses.course_name');
$this->_db->join('institute_sessions','institute_sessions.session_id=institute_agent_commission_settings.com_session_id','LEFT');
$this->_db->join('institute_courses','institute_courses.course_id=institute_agent_commission_settings.com_course_id','LEFT');
$i = 0;
if(isset($param['com_inst_id'])){
$this->db->where('com_inst_id',$param['com_inst_id']);
}
if(isset($param['com_inst_type'])){
$this->db->where('com_inst_type',$param['com_inst_type']);
}
if(isset($param['com_session_id'])){
$this->db->where('com_session_id',$param['com_session_id']);
}
if(isset($param['com_course_id'])){
$this->db->where('com_course_id',$param['com_course_id']);
}
if($count==FALSE){
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(isset($param['length']) && $param['length'] != -1){
$this->_db->limit($param['length'],$param['start']);
}
$query = $this->_db->get('institute_agent_commission_settings');
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_agent_commission_settings');
if($return_query==FALSE){
return $query->num_rows();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
}
public function get_college_seat_settings($param,$single_row=TRUE,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_seats';
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 store_college_seat_settings($data,$return_query=FALSE){
$this->table='institute_seats';
return $this->store($data,FALSE,$return_query);
}
public function update_college_seat_settings($data,$param,$batch=FALSE,$return_query=FALSE){
$this->table='institute_seats';
return $this->modify($data,$param,$batch,$return_query);
}
public function delete_college_seat_settings($param,$return_query=FALSE){
$this->table='institute_seats';
return $this->remove($param,0,$return_query);
}
public function _get_college_seat_settings($post=array(),$param=array(),$count=FALSE,$return_query=FALSE){
$this->_db->select('institute_seats.*,institute_sessions.session_start_year,institute_sessions.session_end_year,institute_courses.course_name');
$this->_db->join('institute_sessions','institute_sessions.session_id=institute_seats.seats_sess_id','LEFT');
$this->_db->join('institute_courses','institute_courses.course_id=institute_seats.seats_course_id','LEFT');
$i = 0;
if(isset($param['seats_inst_id'])){
$this->db->where('seats_inst_id',$param['seats_inst_id']);
}
if(isset($param['seats_sess_id'])){
$this->db->where('seats_sess_id',$param['seats_sess_id']);
}
if(isset($param['seats_course_id'])){
$this->db->where('seats_course_id',$param['seats_course_id']);
}
if($count==FALSE){
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(isset($param['length']) && $param['length'] != -1){
$this->_db->limit($param['length'],$param['start']);
}
$query = $this->_db->get('institute_seats');
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_seats');
if($return_query==FALSE){
return $query->num_rows();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
}
//Cards Printing Data
public function store_cards_print_data($data,$return_query=FALSE){
$this->table='institute_templates_generated';
return $this->store($data,FALSE,$return_query);
}
public function update_cards_print_data($data,$param,$batch=FALSE,$return_query=FALSE){
$this->table='institute_templates_generated';
return $this->modify($data,$param,$batch,$return_query);
}
public function delete_cards_print_data($param,$return_query=FALSE){
$this->table='institute_templates_generated';
return $this->remove($param,0,$return_query);
}
public function get_cards_print_data($param,$single_row=TRUE,$return_query=FALSE){
$this->table='institute_templates_generated';
if($single_row==TRUE){
// print_obj($this->get_one($param,'',$return_query));
return $this->get_one($param,'',$return_query);
}else if($single_row==FALSE){
return $this->get_many($param,null,null,$return_query);
}
}
public function get_cards_template_data($param,$single_row=TRUE,$return_query=FALSE){
$this->table='institute_card_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);
}
}
public function store_unit($data,$return_query=FALSE){
$this->table='institute_units';
return $this->store($data,FALSE,$return_query);
}
public function update_unit($data,$param,$batch=FALSE,$return_query=FALSE){
$this->table='institute_units';
return $this->modify($data,$param,$batch,$return_query);
}
public function delete_unit($param,$return_query=FALSE){
$this->table='institute_units';
return $this->remove($param,0,$return_query);
}
public function get_unit($param=null,$single_row=TRUE,$return_query=FALSE){
$this->table='institute_units';
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);
}
}
//System Fixed Salary Components
public function get_salary_components($param=null,$single_row=TRUE,$return_query=FALSE){
$this->table='system_salary_component_types';
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);
}
}
//Store Logs
public function store_log($data,$return_query=FALSE){
$this->table='user_log';
return $this->store($data,FALSE,$return_query);
}
public function get_log($param=null,$single_row=TRUE,$return_query=FALSE){
$this->table='user_log';
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);
}
}
/*****CRON */
public function get_system_cron($param,$single_row=TRUE,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='cron_logs';
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 store_system_cron($data,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='cron_logs';
return $this->store($data,FALSE,$return_query);
}
public function update_system_cron($data,$param,$batch=FALSE,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='cron_logs';
return $this->modify($data,$param,$batch,$return_query);
}
}