|
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/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php defined('BASEPATH') OR exit('No direct script access allowed');
/**
*
*/
class Fees_model extends BaseModel
{
function __constuct(){
parent::__construct();
}
public function store_fees_type($data,$return_query=FALSE){
$this->table='institute_fees_types';
return $this->store($data,FALSE,$return_query);
}
public function update_fees_type($data,$param,$batch=FALSE,$return_query=FALSE){
$this->table='institute_fees_types';
return $this->modify($data,$param,$batch,$return_query);
}
public function delete_fees_type($param,$return_query=FALSE){
$this->table='institute_fees_types';
return $this->remove($param,0,$return_query);
}
public function get_fees_type($param,$single_row=TRUE,$return_query=FALSE){
$this->table='institute_fees_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);
}
}
public function __get_fees_type($param,$single_row=TRUE,$return_query=FALSE){
$this->_db->select('institute_fees_types.fees_type_id,institute_fees_types.fees_type,institute_fees_types_data.fees_value');
$this->_db->join('institute_fees_types_data','institute_fees_types_data.fees_type_id=institute_fees_types.fees_type_id','LEFT');
$this->_db->where($param);
$query = $this->_db->get('institute_fees_types');
if($return_query==FALSE){
return $query->result();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
public function __get_fees_type_data($param,$single_row=TRUE,$return_query=FALSE){
$this->_db->select('institute_fees_types.fees_type_id,institute_fees_types.fees_type,institute_fees_types_data.fees_value');
$this->_db->join('institute_fees_types','institute_fees_types_data.fees_type_id=institute_fees_types.fees_type_id','LEFT');
$this->_db->where($param);
$query = $this->_db->get('institute_fees_types_data');
if($return_query==FALSE){
return $query->result();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
public function _get_fees_type($post=array(),$param=array(),$count=FALSE,$return_query=FALSE){
$this->_db->select('institute_fees_types.*');
$i = 0;
if(isset($param['inst_id'])){
$this->_db->where('fees_type_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_fees_types');
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_fees_types');
if($return_query==FALSE){
return $query->num_rows();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
}
public function store_fees_type_data($data,$batch=FALSE,$return_query=FALSE){
$this->table='institute_fees_types_data';
return $this->store($data,$batch,$return_query);
}
public function update_fees_type_data($data,$param,$batch=FALSE,$return_query=FALSE){
$this->table='institute_fees_types_data';
return $this->modify($data,$param,$batch,$return_query);
}
public function delete_fees_type_data($param,$return_query=FALSE){
$this->table='institute_fees_types_data';
return $this->remove($param,0,$return_query);
}
public function get_fees_type_data($param,$single_row=TRUE,$return_query=FALSE){
$this->table='institute_fees_types_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);
}
}
public function _get_fees_type_data($post=array(),$param=array(),$count=FALSE,$return_query=FALSE){
$this->_db->select('institute_fees_types_data.*,institute_sessions.session_start_year,institute_sessions.session_end_year,institute_courses.course_name,institute_sessions_years.year_value,,SUM(fees_value) as total_fees_value');
$this->_db->join('institute_sessions','institute_sessions.session_id=institute_fees_types_data.fees_session_id','LEFT');
$this->_db->join('institute_courses','institute_courses.course_id=institute_fees_types_data.fees_course_id','LEFT');
$this->_db->join('institute_sessions_years','institute_sessions_years.year_id=institute_fees_types_data.fees_year_id','LEFT');
$i = 0;
if(isset($param['inst_id'])){
$this->_db->where('fees_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)]);
}
$this->_db->group_by('fees_year_id');
$this->_db->group_by('fees_course_id');
if($count==FALSE){
if(isset($post['length']) && $post['length'] != -1){
$this->_db->limit($post['length'],$post['start']);
}
$query = $this->_db->get('institute_fees_types_data');
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_fees_types_data');
if($return_query==FALSE){
return $query->num_rows();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
}
public function _get_fees_total($param,$return_query=FALSE){
$this->table='institute_fees_types_data';
return $this->get_sum('fees_value','total',$param,$return_query)[0]->total;
}
//Late fees
public function store_late_fees($data,$return_query=FALSE){
$this->table='institute_admission_late_fees';
return $this->store($data,FALSE,$return_query);
}
public function update_late_fees($data,$param,$batch=FALSE,$return_query=FALSE){
$this->table='institute_admission_late_fees';
return $this->modify($data,$param,$batch,$return_query);
}
public function delete_late_fees($param,$return_query=FALSE){
$this->table='institute_admission_late_fees';
return $this->remove($param,0,$return_query);
}
public function get_late_fees($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_admission_late_fees';
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_late_fees_total($param,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_admission_late_fees';
return $this->get_sum('late_fee','total',$param,$return_query)[0]->total;
}
//Discount fees
public function store_discount_fees($data,$return_query=FALSE){
$this->table='institute_admission_discounts_fees';
return $this->store($data,FALSE,$return_query);
}
public function update_discount_fees($data,$param,$batch=FALSE,$return_query=FALSE){
$this->table='institute_admission_discounts_fees';
return $this->modify($data,$param,$batch,$return_query);
}
public function delete_discount_fees($param,$return_query=FALSE){
$this->table='institute_admission_discounts_fees';
return $this->remove($param,0,$return_query);
}
public function get_discount_fees($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_admission_discounts_fees';
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_discount_fees_total($param,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_admission_discounts_fees';
return $this->get_sum('discount_fee','total',$param,$return_query)[0]->total;
}
//Installments
public function store_installments($data,$batch=false,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_payments_admission_fees_installments';
return $this->store($data,$batch,$return_query);
}
public function update_installments($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_payments_admission_fees_installments';
return $this->modify($data,$param,$batch,$return_query);
}
public function delete_installments($param,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_payments_admission_fees_installments';
return $this->remove($param,0,$return_query);
}
public function get_installments($param,$single_row=TRUE,$order_by='installment_sess_year',$order='ASC',$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_payments_admission_fees_installments';
if($single_row==TRUE){
return $this->get_one($param,'',$return_query);
}else if($single_row==FALSE){
return $this->get_many($param,$order_by,$order,$return_query);
}
}
public function _get_installments_total($param,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_payments_admission_fees_installments';
return $this->get_sum('installment_value','installment_total',$param,$return_query);//[0]->total;
}
public function __get_installments($param,$return_query=FALSE){
$this->_db->select('institute_payments_admission_fees_installments.*,institute_courses.course_name,institute_subjects.subject_name,institute_sessions.session_start_year,institute_sessions.session_end_year,institute_students.stu_first_name,institute_students.stu_mid_name,institute_students.stu_last_name,institute_students.stu_ph_no,institute_students.stu_email');
$this->_db->join('institute_courses','institute_courses.course_id=institute_payments_admission_fees_installments.installment_course_id','LEFT');
$this->_db->join('institute_subjects','institute_subjects.subject_id=institute_payments_admission_fees_installments.installment_subject_id','LEFT');
$this->_db->join('institute_sessions','institute_sessions.session_id=institute_payments_admission_fees_installments.installment_sess_id','LEFT');
$this->_db->join('institute_students','institute_students.stu_user_id=institute_payments_admission_fees_installments.installment_stu_id','LEFT');
$this->_db->where($param);
$query = $this->_db->get('institute_payments_admission_fees_installments');
if($return_query==FALSE){
return $query->result();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
public function __get_installments_total($stu_id,$return_query=FALSE) {
$this->_db->select('
i.installment_id,
i.installment_stu_id,
i.installment_inst_id,
i.installment_sess_id,
i.installment_course_id,
i.installment_date,
i.installment_value,
COALESCE(SUM(d.details_amount), 0) as total_paid,
i.installment_value - COALESCE(SUM(d.details_amount), 0) as total_due
');
$this->_db->from('nt_institute_payments_admission_fees_installments i');
$this->_db->join('nt_institute_payments_details d', 'i.installment_id = d.details_installment_id AND d.details_stu_id = ' . $stu_id . ' AND d.details_type = "new_admission"', 'left');
$this->_db->where('i.installment_stu_id', $stu_id);
$this->_db->group_by('i.installment_id');
$query = $this->_db->get();
if($return_query==FALSE){
return $query->result();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
public function get_installment($param,$return_query=FALSE){
$this->_db->select('institute_payments_admission_fees_installments.*,institute_courses.course_name,institute_subjects.subject_name,institute_sessions.session_start_year,institute_sessions.session_end_year,institute_students.stu_first_name,institute_students.stu_mid_name,institute_students.stu_last_name,institute_students.stu_ph_no,institute_students.stu_email,institute_students.stu_user_code');
$this->_db->join('institute_courses','institute_courses.course_id=institute_payments_admission_fees_installments.installment_course_id','LEFT');
$this->_db->join('institute_subjects','institute_subjects.subject_id=institute_payments_admission_fees_installments.installment_subject_id','LEFT');
$this->_db->join('institute_sessions','institute_sessions.session_id=institute_payments_admission_fees_installments.installment_sess_id','LEFT');
$this->_db->join('institute_students','institute_students.stu_user_id=institute_payments_admission_fees_installments.installment_stu_id','LEFT');
$this->_db->where($param);
$query = $this->_db->get('institute_payments_admission_fees_installments');
if($return_query==FALSE){
return $query->first_row();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
public function _get_installments($post=array(),$param=array(),$db_group=null,$count=FALSE,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->_db->select('institute_payments_admission_fees_installments.*,institute_courses.course_name,institute_subjects.subject_name,institute_sessions.session_start_year,institute_sessions.session_end_year,institute_students.stu_first_name,institute_students.stu_mid_name,institute_students.stu_last_name');
$this->_db->join('institute_courses','institute_courses.course_id=institute_payments_admission_fees_installments.installment_course_id','LEFT');
$this->_db->join('institute_subjects','institute_subjects.subject_id=institute_payments_admission_fees_installments.installment_subject_id','LEFT');
$this->_db->join('institute_sessions','institute_sessions.session_id=institute_payments_admission_fees_installments.installment_sess_id','LEFT');
$this->_db->join('institute_students','institute_students.stu_user_id=institute_payments_admission_fees_installments.installment_stu_id','LEFT');
$i=0;
if(isset($param['inst_id'])){
$this->_db->where('installment_inst_id',$param['inst_id']);
}
if(isset($param['stu_id'])){
$this->_db->where('installment_stu_id',$param['stu_id']);
}
if(isset($param['admission_id'])){
$this->_db->where('installment_admission_id',$param['admission_id']);
}
if(isset($param['sess_id'])){
$this->_db->where('installment_sess_id',$param['sess_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_payments_admission_fees_installments');
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_payments_admission_fees_installments');
if($return_query==FALSE){
return $query->num_rows();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
}
//Installments balance
public function store_installments_balance($data,$batch=false,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_payments_balance_details';
return $this->store($data,$batch,$return_query);
}
public function update_installments_balance($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_payments_balance_details';
return $this->modify($data,$param,$batch,$return_query);
}
public function delete_installments_balance($param,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_payments_balance_details';
return $this->remove($param,0,$return_query);
}
public function get_installments_balance($param,$single_row=TRUE,$order_by='inst_year',$order='ASC',$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_payments_balance_details';
if($single_row==TRUE){
return $this->get_one($param,'',$return_query);
}else if($single_row==FALSE){
return $this->get_many($param,$order_by,$order,$return_query);
}
}
public function get_installments_balance_last($param,$return_query=FALSE){
$this->table='institute_payments_balance_details';
return $this->get_max('inst_payment_balance','last_balance',$param,$return_query);
}
public function _get_installments_balance_last($param,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_payments_balance_details';
return $this->get_last($param,'balance_id',$return_query);
}
public function get_installments_paid_total($param,$return_query=FALSE){
$this->table='institute_payments_balance_details';
return $this->get_sum('inst_payment_total','total',$param,$return_query);
}
public function get_installments_balance_total($param,$return_query=FALSE){
$this->table='institute_payments_balance_details';
return $this->get_sum('inst_payment_balance','total',$param,$return_query);
}
public function get_installment_split_total_paid($param,$return_query=FALSE){
$this->table='institute_payments_balance_details';
return $this->get_sum('inst_payment_total','total',$param,$return_query);
}
public function get_installments_balance_count($param=null,$group_by=NULL,$find_in_set=NULL,$return_query=FALSE){
$this->table='institute_payments_balance_details';
return $this->get_total_count($param,$group_by,$find_in_set,$return_query);
}
public function _get_installments_balance($post=array(),$param=array(),$count=FALSE,$return_query=FALSE){
$this->_db->select('institute_payments_balance_details.*,institute_courses.course_name,institute_sessions.session_start_year,institute_sessions.session_end_year,institute_students.stu_first_name,institute_students.stu_mid_name,institute_students.stu_last_name,institute_students.stu_user_code');
$this->_db->join('institute_courses','institute_courses.course_id=institute_payments_balance_details.inst_course_id','LEFT');
$this->_db->join('institute_sessions','institute_sessions.session_id=institute_payments_balance_details.inst_session_id','LEFT');
$this->_db->join('institute_students','institute_students.stu_user_id=institute_payments_balance_details.inst_stu_id','LEFT');
$i=0;
if(isset($param['inst_id'])){
$this->_db->where('institute_payments_balance_details.inst_id',$param['inst_id']);
}
if(isset($param['stu_id'])){
$this->_db->where('institute_payments_balance_details.inst_stu_id',$param['stu_id']);
}
if(isset($param['sess_id'])){
$this->_db->where('institute_payments_balance_details.inst_session_id',$param['sess_id']);
}
if(isset($param['course_id'])){
$this->_db->where('institute_payments_balance_details.inst_course_id',$param['course_id']);
}
if(isset($param['paid_status'])){
$this->_db->where('institute_payments_balance_details.inst_balance_paid',$param['paid_status']);
}
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_payments_balance_details');
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_payments_balance_details');
if($return_query==FALSE){
return $query->num_rows();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
}
//Fees details
public function _store_fees_details($data,$batch=false,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_payments_admission_fees';
return $this->store($data,$batch,$return_query);
}
public function _update_fees_details($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_payments_admission_fees';
return $this->modify($data,$param,$batch,$return_query);
}
public function _delete_fees_details($param,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_payments_admission_fees';
return $this->remove($param,0,$return_query);
}
public function _get_fees_details($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_payments_admission_fees';
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_fees_details_total($param,$return_query=FALSE){
$this->table='institute_payments_admission_fees';
return $this->get_sum('payment_fees_value','total',$param,$return_query);
}
public function _get_fees_details_last($param,$return_query=FALSE){
$this->table='institute_payments_admission_fees_details';
return $this->get_last($param,'payment_fees_details_id',$return_query);
}
public function store_fees_details($data,$batch=false,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_payments_admission_fees_details';
return $this->store($data,$batch,$return_query);
}
public function update_fees_details($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_payments_admission_fees_details';
return $this->modify($data,$param,$batch,$return_query);
}
public function delete_fees_details($param,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_payments_admission_fees_details';
return $this->remove($param,0,$return_query);
}
public function get_fees_details($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_payments_admission_fees_details';
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_fees_details_total($param,$field,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_payments_details';
return $this->get_sum($field,'total',$param,$return_query);
}
//Agent Payments
public function store_agent_payment($data,$batch=false,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_payments_agents';
return $this->store($data,$batch,$return_query);
}
public function update_agent_payment($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_payments_agents';
return $this->modify($data,$param,$batch,$return_query);
}
public function delete_agent_payment($param,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_payments_agents';
return $this->remove($param,0,$return_query);
}
public function get_agent_payment($param,$single_row=TRUE,$return_query=FALSE,$db_group=null){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_payments_agents';
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_payment($param,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->_db->select('institute_payments_agents.*,institute_agents.agent_name');
// $this->_db->join('institute_agents','institute_agents.agent_user_id=institute_payments_agents.agent_id','LEFT');
$this->_db->join('institute_agents','institute_agents.agent_id=institute_payments_agents.agent_id','LEFT');
$this->_db->where($param);
$query=$this->_db->get('institute_payments_agents');
if($return_query==FALSE){
return $query->first_row();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
//Paymmen
public function store_payment_details($data,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_payments_details';
return $this->store($data,FALSE,$return_query);
}
public function update_payment_details($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_payments_details';
return $this->modify($data,$param,$batch,$return_query);
}
public function delete_payment_details($param,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_payments_details';
return $this->remove($param,0,$return_query);
}
public function get_payment_details($param,$db_group=null,$single_row=TRUE,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_payments_details';
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_details($param,$fields="*",$single_row=TRUE,$return_query=FALSE){
$this->table='institute_payments_details';
if($single_row==TRUE){
return $this->get_one($param,'',$return_query);
}else if($single_row==FALSE){
return $this->get_many_specific($fields,$param,null,null,$return_query);
}
}
//Payment Details Failure
public function store_payment_details_failures($data,$return_query=FALSE){
$this->table='institute_payments_details_failures';
return $this->store($data,FALSE,$return_query);
}
public function update_payment_details_failures($data,$param,$batch=FALSE,$return_query=FALSE){
$this->table='institute_payments_details_failures';
return $this->modify($data,$param,$batch,$return_query);
}
public function delete_payment_details_failures($param,$return_query=FALSE){
$this->table='institute_payments_details_failures';
return $this->remove($param,0,$return_query);
}
public function get_payment_details_failures($param,$single_row=TRUE,$return_query=FALSE){
$this->table='institute_payments_details_failures';
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_details_last($param,$return_query=FALSE){
$this->table='institute_payments_details';
return $this->get_last($param,'details_id',$return_query);
}
public function _get_payment_details($param,$single_row=TRUE,$return_query=FALSE){
$this->_db->select('institute_payments_details.*,institute_students.stu_user_id,institute_students.stu_first_name,institute_students.stu_mid_name,institute_students.stu_last_name,institute_students.stu_email,institute_students.stu_ph_no,institute_students.stu_user_code,institute_sessions.session_start_year,institute_sessions.session_end_year,institute_courses.course_name,institute_subjects.subject_name');
$this->_db->join('institute_students','institute_students.stu_user_id=institute_payments_details.details_stu_id','LEFT');
$this->_db->join('institute_courses','institute_courses.course_id=institute_payments_details.details_course_id','LEFT');
$this->_db->join('institute_subjects','institute_subjects.subject_id=institute_payments_details.details_subject_id','LEFT');
$this->_db->join('institute_sessions','institute_sessions.session_id=institute_payments_details.details_sess_id','LEFT');
$this->_db->where($param);
$result=$this->_db->get('institute_payments_details');
if($return_query==FALSE){
if($single_row==TRUE){
return $result->first_row();
}else if($single_row==FALSE){
return $result->result();
}
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
public function ___get_payment_details($param, $or_param = null, $single_row = true, $return_query = false)
{
$this->_db->select('ipd.*, stu.stu_user_id, stu.stu_first_name, stu.stu_mid_name, stu.stu_last_name, stu.stu_email, stu.stu_ph_no, stu.stu_user_code, sess.session_start_year, sess.session_end_year, course.course_name, subj.subject_name');
$this->_db->from('institute_payments_details as ipd');
$this->_db->join('institute_students as stu', 'stu.stu_user_id = ipd.details_stu_id', 'LEFT');
$this->_db->join('institute_courses as course', 'course.course_id = ipd.details_course_id', 'LEFT');
$this->_db->join('institute_subjects as subj', 'subj.subject_id = ipd.details_subject_id', 'LEFT');
$this->_db->join('institute_sessions as sess', 'sess.session_id = ipd.details_sess_id', 'LEFT');
$this->_db->where($param);
if(!empty($or_param)){
$this->_db->group_start();
foreach($or_param as $key => $v){
$this->_db->or_where($v,$key);
}
$this->_db->group_end();
}
$result = $this->_db->get();
if ($return_query) {
return $this->_db->last_query();
}
if ($single_row) {
return $result->row();
}
return $result->result();
}
public function _get_payments_total($param,$db_group=null,$return_query=FALSE){
$db_group=!empty($db_group)?$db_group:DB_GROUP;
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_payments_details';
return $this->get_sum('details_amount','total',$param,$return_query);//[0]->total;
}
public function _get_payments_in_total($param=null,$param_in,$param_val=null,$return_query=FALSE){
$this->table='institute_payments_details';
return $this->get_in_sum('details_amount','total',$param,$param_in,$param_val,$return_query);//[0]->total;
}
public function get_seat_booking_payment_details($param,$single_row=TRUE,$return_query=FALSE){
$this->table='institute_seat_bookings';
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_seat_booking_payments_details($param,$return_query=FALSE){
$this->_db->select('institute_seat_bookings.*,
institute_students.stu_user_code,
institute_students.stu_first_name,
institute_students.stu_mid_name,
institute_students.stu_last_name,
institute_students.stu_email,
institute_students.stu_ph_no,
institute_payments_details.details_type,
institute_payments_details.details_type_id,
institute_payments_details.details_payment_type,
institute_payments_details.details_txn_id,
institute_payments_details.details_amount,
institute_payments_details.details_payment_platform,
institute_payments_details.details_stu_id,
institute_payments_details.details_sess_id,
institute_payments_details.details_course_id,
institute_payments_details.details_subject_id,
institute_payments_details.details_inst_id,
institute_courses.course_name,
institute_courses.course_code,
institute_sessions.session_start_year,
institute_sessions.session_end_year,
institute_payments_seat_bookings.booking_payment,
institute_payments_seat_bookings.booking_pay_mode,
institute_payments_seat_bookings.booking_payment_recieved_date');
$this->_db->join('institute_payments_details','institute_payments_details.details_type_id=institute_seat_bookings.booking_id','LEFT');
$this->_db->join('institute_courses','institute_courses.course_id=institute_seat_bookings.booking_course_id','LEFT');
$this->_db->join('institute_sessions','institute_sessions.session_id=institute_seat_bookings.booking_sess_id','LEFT');
$this->_db->join('institute_students','institute_students.stu_id=institute_seat_bookings.booking_stu_profile_id','LEFT');
$this->_db->join('institute_payments_seat_bookings','institute_payments_seat_bookings.booking_pk_id=institute_seat_bookings.booking_id');
$this->_db->where('details_type','seat_booking');
$this->_db->where($param);
$query=$this->_db->get('institute_seat_bookings');
if($return_query==FALSE){
return $query->first_row();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
public function __get_payments_details($post=array(),$param=array(),$group_by=FALSE,$count=FALSE,$return_query=FALSE){
$this->_db->select('institute_payments_details.*,institute_sessions.session_start_year,institute_sessions.session_end_year,institute_courses.course_name,institute_courses.course_code,institute_courses.course_duration,institute_students.stu_first_name,institute_students.stu_mid_name,institute_students.stu_last_name,institute_students.stu_user_code,institute_ctm_accounts_category.category_name,institute_vendors.vendor_name');
// $this->_db->join('institute_admissions','institute_admissions.admission_id=institute_payments_details.details_type_id','LEFT');
$this->_db->join('institute_sessions','institute_sessions.session_id=institute_payments_details.details_sess_id','LEFT');
$this->_db->join('institute_courses','institute_courses.course_id=institute_payments_details.details_course_id','LEFT');
$this->_db->join('institute_students','institute_students.stu_user_id=institute_payments_details.details_stu_id','LEFT');
$this->_db->join('institute_ctm_accounts_category','institute_ctm_accounts_category.category_id=institute_payments_details.details_accounting_type_id','LEFT');
$this->_db->join('institute_vendors','institute_vendors.vendor_id=institute_payments_details.details_vendor_id','LEFT');
$i = 0;
if(isset($param['inst_id'])){
$this->_db->where('details_inst_id',$param['inst_id']);
}
if(isset($param['session_id'])){
$this->_db->where('details_sess_id',$param['session_id']);
}
if(isset($param['course_id'])){
$this->_db->where('details_course_id',$param['course_id']);
}
if(isset($param['student_id'])){
$this->_db->where('details_stu_id',$param['student_id']);
}
if(isset($param['start_date']) && isset($param['end_date'])){
$this->_db->where('DATE(details_created_at) BETWEEN "'.$param['start_date'].'" AND "'.$param['end_date'].'"');
}else if(isset($param['start_date']) && !isset($param['end_date'])){
$this->_db->where('DATE(details_created_at)',$param['start_date']);
}else if(!isset($param['end_date']) && isset($param['end_date'])){
$this->_db->where('DATE(details_created_at)',$param['end_date']);
}
if(isset($param['accounting_type'])){
$this->_db->where('institute_payments_details.details_accounting_type',$param['accounting_type']);
}
if(isset($param['details_type'])){
$this->_db->where('institute_payments_details.details_type',$param['details_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($group_by==TRUE){
$this->_db->group_by('details_type_id');
}
if($count==FALSE){
if(isset($post['length']) && $post['length'] != -1){
$this->_db->limit($post['length'],$post['start']);
}
$query = $this->_db->get('institute_payments_details');
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_payments_details');
if($return_query==FALSE){
return $query->num_rows();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
}
public function ___get_payments_details($param,$group_by=FALSE,$count=FALSE,$single=TRUE,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->_db->select('institute_payments_details.*,institute_sessions.session_start_year,institute_sessions.session_end_year,institute_courses.course_name,institute_courses.course_code,institute_courses.course_duration,institute_students.stu_first_name,institute_students.stu_mid_name,institute_students.stu_last_name,institute_students.stu_user_code');
// $this->_db->join('institute_admissions','institute_admissions.admission_id=institute_payments_details.details_type_id','LEFT');
$this->_db->join('institute_sessions','institute_sessions.session_id=institute_payments_details.details_sess_id','LEFT');
$this->_db->join('institute_courses','institute_courses.course_id=institute_payments_details.details_course_id','LEFT');
$this->_db->join('institute_students','institute_students.stu_user_id=institute_payments_details.details_stu_id','LEFT');
if(isset($param['details_id'])){
$this->_db->where('details_id',$param['details_id']);
}
if(isset($param['details_type'])){
$this->_db->where('details_type',$param['details_type']);
}
if(isset($param['inst_id'])){
$this->_db->where('details_inst_id',$param['inst_id']);
}
if(isset($param['session_id'])){
$this->_db->where('details_sess_id',$param['session_id']);
}
if(isset($param['course_id'])){
$this->_db->where('details_course_id',$param['course_id']);
}
if(isset($param['student_id'])){
$this->_db->where('details_stu_id',$param['student_id']);
}
if(isset($param['agent_id'])){
$this->_db->where('details_agent_id',$param['agent_id']);
}
if(isset($param['payment_id'])){
$this->_db->where('details_payment_id',$param['payment_id']);
}
if(isset($param['start_date']) && isset($param['end_date'])){
$this->_db->where('DATE(details_created_at) BETWEEN "'.$param['start_date'].'" AND "'.$param['end_date'].'"');
}else if(isset($param['start_date']) && !isset($param['end_date'])){
$this->_db->where('DATE(details_created_at)',$param['start_date']);
}else if(!isset($param['end_date']) && isset($param['end_date'])){
$this->_db->where('DATE(details_created_at)',$param['end_date']);
}
if(isset($param['accounting_type'])){
$this->_db->where('institute_payments_details.details_accounting_type',$param['accounting_type']);
}
if(isset($param['details_type'])){
$this->_db->where('institute_payments_details.details_type',$param['details_type']);
}
if($group_by==TRUE){
$this->_db->group_by('details_type_id');
}
$query = $this->_db->get('institute_payments_details');
if($return_query==FALSE){
if($single==TRUE){
return $query->first_row();
}else if($single==FALSE){
return $query->result();
}
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
public function _____get_payments_details($param,$single=TRUE,$return_query=FALSE){
$this->_db->select('institute_payments_details.*');
if(isset($param['details_id'])){
$this->_db->where('details_id',$param['details_id']);
}
if(isset($param['details_type'])){
$this->_db->where('details_type',$param['details_type']);
}
if(isset($param['inst_id'])){
$this->_db->where('details_inst_id',$param['inst_id']);
}
if(isset($param['session_id'])){
$this->_db->where('details_sess_id',$param['session_id']);
}
if(isset($param['course_id'])){
$this->_db->where('details_course_id',$param['course_id']);
}
if(isset($param['student_id'])){
$this->_db->where('details_stu_id',$param['student_id']);
}
if(isset($param['agent_id'])){
$this->_db->where('details_agent_id',$param['agent_id']);
}
if(isset($param['payment_id'])){
$this->_db->where('details_payment_id',$param['payment_id']);
}
//if(isset($param['start_date']) && isset($param['end_date'])){
if(!empty($param['start_date']) && !empty($param['end_date'])){
$this->_db->where('DATE(details_created_at_actual) BETWEEN "'.$param['start_date'].'" AND "'.$param['end_date'].'"');
}else if(!empty($param['start_date']) && empty($param['end_date'])){
$this->_db->where('DATE(details_created_at_actual)',$param['start_date']);
}else if(empty($param['end_date']) && !empty($param['end_date'])){
$this->_db->where('DATE(details_created_at_actual)',$param['end_date']);
}
//}
// if(isset($param['start_date']) && isset($param['end_date'])){
// $this->_db->where('DATE(details_created_at) BETWEEN "'.$param['start_date'].'" AND "'.$param['end_date'].'"');
// }else if(isset($param['start_date']) && !isset($param['end_date'])){
// $this->_db->where('DATE(details_created_at)',$param['start_date']);
// }else if(!isset($param['end_date']) && isset($param['end_date'])){
// $this->_db->where('DATE(details_created_at)',$param['end_date']);
// }
if(isset($param['accounting_type'])){
$this->_db->where('institute_payments_details.details_accounting_type',$param['accounting_type']);
}
if(isset($param['details_type'])){
$this->_db->where('institute_payments_details.details_type',$param['details_type']);
}
$query = $this->_db->get('institute_payments_details');
if($return_query==FALSE){
if($single==TRUE){
return $query->first_row();
}else if($single==FALSE){
return $query->result();
}
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
public function _get_payments_details($post=array(),$param=array(),$count=FALSE,$return_query=FALSE){
$this->_db->select('institute_payments_details.*,SUM(details_amount) as details_amount,institute_admissions.admission_id,institute_admissions.admission_code,institute_sessions.session_start_year,institute_sessions.session_end_year');
$this->_db->join('institute_admissions','institute_admissions.admission_id=institute_payments_details.details_type_id','LEFT');
$this->_db->join('institute_sessions','institute_sessions.session_id=institute_admissions.admission_sess_id','LEFT');
$i = 0;
if(isset($param['inst_id'])){
$this->_db->where('details_inst_id',$param['inst_id']);
}
if(isset($param['accounting_type'])){
$this->_db->where('institute_payments_details.details_accounting_type',$param['accounting_type']);
}
if(isset($param['details_type'])){
$this->_db->where('institute_payments_details.details_type',$param['details_type']);
}
if(isset($post['sess_id']) && $post['sess_id']!=''){
$this->_db->where('details_sess_id',$post['sess_id']);
}
if(isset($post['course_id']) && $post['course_id']>0){
$this->_db->where('details_course_id',$post['course_id']);
}
if(isset($post['pay_dates']) && $post['pay_dates']!='0'){
if($post['pay_dates']=='today'){
$this->_db->where('DATE(`details_created_at`)=CURDATE()');
}else if($post['pay_dates']=='yesterday'){
$this->_db->where('DATE(`details_created_at`)=DATE_SUB(CURDATE(), INTERVAL 1 DAY)');
}else if($post['pay_dates']=='7days'){
$this->_db->where('DATE(`details_created_at`) >= DATE_SUB(CURDATE(), INTERVAL 7 DAY)');
}else if($post['pay_dates']=='30days'){
$this->_db->where('DATE(`details_created_at`) >= DATE_SUB(CURDATE(), INTERVAL 30 DAY)');
}else if($post['pay_dates']=='90days'){
$this->_db->where('DATE(`details_created_at`) >= DATE_SUB(CURDATE(), INTERVAL 90 DAY)');
}else if($post['pay_dates']=='180days'){
$this->_db->where('DATE(`details_created_at`) >= DATE_SUB(CURDATE(), INTERVAL 180 DAY)');
}
}
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)]);
}
$this->_db->group_by('details_type_id');
if($count==FALSE){
if(isset($post['length']) && $post['length'] != -1){
$this->_db->limit($post['length'],$post['start']);
}
$query = $this->_db->get('institute_payments_details');
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_payments_details');
if($return_query==FALSE){
return $query->num_rows();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
}
public function ____get_payments_details($post=array(),$param=array(),$count=FALSE,$return_query=FALSE){
$this->_db->select('institute_payments_details.*,details_amount,institute_admissions.admission_id,institute_admissions.admission_code,institute_sessions.session_start_year,institute_sessions.session_end_year');
$this->_db->join('institute_admissions','institute_admissions.admission_id=institute_payments_details.details_type_id','LEFT');
$this->_db->join('institute_sessions','institute_sessions.session_id=institute_admissions.admission_sess_id','LEFT');
$i = 0;
if(isset($param['inst_id'])){
$this->_db->where('details_inst_id',$param['inst_id']);
}
if(isset($param['accounting_type'])){
$this->_db->where('institute_payments_details.details_accounting_type',$param['accounting_type']);
}
if(isset($param['details_type'])){
$this->_db->where('institute_payments_details.details_type',$param['details_type']);
}
if(isset($post['sess_id']) && $post['sess_id']!=''){
$this->_db->where('details_sess_id',$post['sess_id']);
}
if(isset($post['course_id']) && $post['course_id']>0){
$this->_db->where('details_course_id',$post['course_id']);
}
if(isset($post['pay_dates']) && $post['pay_dates']!='0'){
if($post['pay_dates']=='today'){
$this->_db->where('DATE(`details_created_at`)=CURDATE()');
}else if($post['pay_dates']=='yesterday'){
$this->_db->where('DATE(`details_created_at`)=DATE_SUB(CURDATE(), INTERVAL 1 DAY)');
}else if($post['pay_dates']=='7days'){
$this->_db->where('DATE(`details_created_at`) >= DATE_SUB(CURDATE(), INTERVAL 7 DAY)');
}else if($post['pay_dates']=='30days'){
$this->_db->where('DATE(`details_created_at`) >= DATE_SUB(CURDATE(), INTERVAL 30 DAY)');
}else if($post['pay_dates']=='90days'){
$this->_db->where('DATE(`details_created_at`) >= DATE_SUB(CURDATE(), INTERVAL 90 DAY)');
}else if($post['pay_dates']=='180days'){
$this->_db->where('DATE(`details_created_at`) >= DATE_SUB(CURDATE(), INTERVAL 180 DAY)');
}
}
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)]);
}
//$this->_db->group_by('details_type_id');
if($count==FALSE){
if(isset($post['length']) && $post['length'] != -1){
$this->_db->limit($post['length'],$post['start']);
}
$query = $this->_db->get('institute_payments_details');
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_payments_details');
if($return_query==FALSE){
return $query->num_rows();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
}
public function _get_payments_details_total($param=array(),$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_payments_details';
return $this->get_sum('details_amount','total',$param,$return_query);
}
public function _get_agent_payments_total($param,$return_query=FALSE,$db_group=null){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_payments_agents';
return $this->get_sum('amount_value','total',$param,$return_query);
}
public function get_agent_payments_total($param,$return_query=FALSE){
$this->table='institute_payments_agents';
return $this->get_sum('amount_value','total',$param,$return_query);
}
public function _get_agent_booking_count($param=null,$group_by=NULL,$find_in_set=NULL,$return_query=FALSE){
$this->table='institute_payments_agents';
return $this->get_total_count($param,$group_by,$find_in_set,$return_query);
}
public function _get_agent_payments($post=array(),$param=array(),$count=FALSE,$return_query=FALSE,$db_group=null){
$db_group=!empty($db_group)?$db_group:DB_GROUP;
$this->_db=$this->load->database($db_group, TRUE);
$this->_db->select('institute_payments_agents.*,institute_agents.agent_name,institute_agents.agent_code,institute_sessions.session_start_year,institute_sessions.session_end_year,institute_courses.course_name,,institute_courses.course_code,institute_subjects.subject_name');
$this->_db->join('institute_agents','institute_agents.agent_id=institute_payments_agents.agent_id','LEFT');
$this->_db->join('institute_sessions','institute_sessions.session_id=institute_payments_agents.session_id','LEFT');
$this->_db->join('institute_courses','institute_courses.course_id=institute_payments_agents.course_id','LEFT');
$this->_db->join('institute_subjects','institute_subjects.subject_id=institute_payments_agents.subject_id','LEFT');
$i = 0;
if(isset($param['inst_id'])){
$this->_db->where('inst_id',$param['inst_id']);
}
if(isset($param['agent_id'])){
$this->_db->where('institute_payments_agents.agent_id',$param['agent_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_payments_agents');
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_payments_agents');
if($return_query==FALSE){
return $query->num_rows();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
}
public function __get_agent_payments($post=array(),$param=array(),$count=FALSE,$return_query=FALSE){
$this->_db->select('institute_payments_details.*,SUM(details_amount) as details_amount,institute_agents.agent_name,institute_agents.agent_user_id,institute_agents.agent_code,institute_agents.agent_email,institute_agents.agent_ph');
$this->_db->join('institute_agents','institute_agents.agent_user_id=institute_payments_details.details_agent_id','LEFT');
$i = 0;
$this->_db->where('details_type','agent_payment');
if(isset($param['inst_id'])){
$this->_db->where('details_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++;
}
}
$this->_db->group_by('details_type_id');
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_payments_details');
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_payments_details');
if($return_query==FALSE){
return $query->num_rows();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
}
public function ___get_agent_payments($post=array(),$param=array(),$count=FALSE,$return_query=FALSE,$db_group=null){
$db_group=!empty($db_group)?$db_group:DB_GROUP;
$this->_db=$this->load->database($db_group, TRUE);
$this->_db->select('institute_agents.agent_name,institute_agents.agent_user_id,institute_agents.agent_code,institute_agents.agent_email,institute_agents.agent_ph,SUM(details_amount) as details_amount');
$this->_db->join('institute_agents','institute_agents.agent_user_id=institute_payments_details.details_agent_id','LEFT');
$i = 0;
$this->_db->where('details_type','seat_booking');
if(isset($param['inst_id'])){
$this->_db->where('details_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++;
}
}
$this->_db->group_by('details_agent_id');
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_payments_details');
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_payments_details');
if($return_query==FALSE){
return $query->num_rows();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
}
//Temp Fees Details
public function store_temp_payment($data,$return_query=FALSE){
$this->table='temp_payment_details';
return $this->store($data,FALSE,$return_query);
}
public function update_temp_payment($data,$param,$batch=FALSE,$return_query=FALSE){
$this->table='temp_payment_details';
return $this->modify($data,$param,$batch,$return_query);
}
public function delete_temp_payment($param,$return_query=FALSE){
$this->table='temp_payment_details';
return $this->remove($param,0,$return_query);
}
public function get_temp_payment($param,$single_row=TRUE,$return_query=FALSE){
$this->table='temp_payment_details';
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);
}
}
//Hostel Fees
public function store_hostel_fees_payment($data,$batch=FALSE,$return_query=FALSE){
$this->table='institute_payments_hostels';
return $this->store($data,$batch,$return_query);
}
public function update_hostel_fees_payment($data,$param,$batch=FALSE,$return_query=FALSE){
$this->table='institute_payments_hostels';
return $this->modify($data,$param,$batch,$return_query);
}
public function delete_hostel_fees_payment($param,$return_query=FALSE){
$this->table='institute_payments_hostels';
return $this->remove($param,0,$return_query);
}
public function get_hostel_fees_payment($param,$single_row=TRUE,$is_group='',$return_query=FALSE){
$this->table='institute_payments_hostels';
if($single_row==TRUE){
return $this->get_one($param,$is_group,$return_query);
}else if($single_row==FALSE){
return $this->get_many($param,null,null,$return_query);
}
}
public function __get_hostel_fees_payment($param=array(),$return_query=FALSE){
$this->_db->select('institute_payments_hostels.*,institute_hostels.hostel_name,institute_hostels.hostel_address,institute_students.stu_first_name,institute_students.stu_mid_name,institute_students.stu_last_name,institute_students.stu_email,institute_students.stu_ph_no,institute_sessions.session_start_year,institute_sessions.session_end_year,institute_courses.course_name');
$this->_db->join('institute_hostels','institute_hostels.hostel_id=institute_payments_hostels.payment_hostel_id','LEFT');
$this->_db->join('institute_students','institute_students.stu_user_id=institute_payments_hostels.payment_hostel_stu_id','LEFT');
$this->_db->join('institute_sessions','institute_sessions.session_id=institute_payments_hostels.payment_hostel_sess_id','LEFT');
$this->_db->join('institute_courses','institute_courses.course_id=institute_payments_hostels.payment_hostel_course_id','LEFT');
$this->_db->where($param);
$query = $this->_db->get('institute_payments_hostels');
if($return_query==FALSE){
return $query->first_row();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
public function _get_hostel_fees_payment($post=array(),$param=array(),$count=FALSE,$return_query=FALSE){
$this->_db->select('institute_payments_hostels.*,institute_hostels.hostel_name,institute_students.stu_first_name,institute_students.stu_mid_name,institute_students.stu_last_name,institute_students.stu_user_code,institute_sessions.session_start_year,institute_sessions.session_end_year,institute_courses.course_name');
$this->_db->join('institute_hostels','institute_hostels.hostel_id=institute_payments_hostels.payment_hostel_id','LEFT');
$this->_db->join('institute_students','institute_students.stu_user_id=institute_payments_hostels.payment_hostel_stu_id','LEFT');
$this->_db->join('institute_sessions','institute_sessions.session_id=institute_payments_hostels.payment_hostel_sess_id','LEFT');
$this->_db->join('institute_courses','institute_courses.course_id=institute_payments_hostels.payment_hostel_course_id','LEFT');
$i = 0;
if(isset($param['inst_id'])){
$this->_db->where('payment_hostel_inst_id',$param['inst_id']);
}
if(isset($param['stu_id'])){
$this->_db->where('payment_hostel_stu_id',$param['stu_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_payments_hostels');
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_payments_hostels');
if($return_query==FALSE){
return $query->num_rows();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
}
//Cheque Details
public function store_cheque_details($data,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_payment_cheques_details';
return $this->store($data,FALSE,$return_query);
}
public function update_cheque_details($data,$param,$db_group=null,$batch=FALSE,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_payment_cheques_details';
return $this->modify($data,$param,$batch,$return_query);
}
public function delete_cheque_details($param,$db_group=null,$return_query=FALSE){
if($db_group!==null){
$this->_db=$this->load->database($db_group, TRUE);
}
$this->table='institute_payment_cheques_details';
return $this->remove($param,0,$return_query);
}
public function get_cheque_details($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_payment_cheques_details';
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);
}
}
/***Fund Transfer***/
public function store_fund_transfer($data,$return_query=FALSE){
$this->table='institute_amount_transfers';
return $this->store($data,FALSE,$return_query);
}
public function update_fund_transfer($data,$param,$batch=FALSE,$return_query=FALSE){
$this->table='institute_amount_transfers';
return $this->modify($data,$param,$batch,$return_query);
}
public function delete_fund_transfer($param,$return_query=FALSE){
$this->table='institute_amount_transfers';
return $this->remove($param,0,$return_query);
}
public function get_fund_transfer($param,$single_row=TRUE,$return_query=FALSE){
$this->table='institute_amount_transfers';
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_fund_transfer($post=array(),$param=array(),$count=FALSE,$return_query=FALSE){
$this->_db->select('institute_amount_transfers.*');
$i = 0;
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_amount_transfers');
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_amount_transfers');
if($return_query==FALSE){
return $query->num_rows();
}else if($return_query==TRUE){
return $this->_db->last_query();
}
}
}
}