<?php defined('BASEPATH') OR exit('No direct script access allowed');

/**
 * 
 */
class Payment_model extends BaseModel
{
    function __constuct(){
        parent::__construct(); 
    }
    
    public function store_payment_data($data,$db_group=null,$return_query=FALSE){
        if($db_group!==null){
            $this->_db=$this->load->database($db_group, TRUE);
        }
        $this->table='institute_ctm_payments';
        return $this->store($data,FALSE,$return_query);
    }

    public function update_payment_data($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_ctm_payments';
        return $this->modify($data,$param,$batch,$return_query);
    }

    public function delete_payment_data($param,$db_group=null,$return_query=FALSE){
        if($db_group!==null){
            $this->_db=$this->load->database($db_group, TRUE);
        }
        $this->table='institute_ctm_payments';
        return $this->remove($param,0,$return_query);
    }

    public function get_payment_data($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_ctm_payments';
        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_data_total($param,$db_group=null,$return_query=FALSE){
        if($db_group!==null){
            $this->_db=$this->load->database($db_group, TRUE);
        }
        $this->table='institute_ctm_payments';
        return $this->get_sum('ctm_payment_amount','total',$param,$return_query);
    }

    public function _get_payment_data($param=array(),$db_group=null,$return_query=FALSE){
        if($db_group!==null){
            $this->_db=$this->load->database($db_group, TRUE);
        }
        $this->_db->select('institute_ctm_payments.*,institute_ctm_vendors.vendor_name,institute_ctm_vendors_category.category_name,institute_ctm_vendors_category.category_description');
        $this->_db->join('institute_ctm_vendors','institute_ctm_vendors.vendor_id=institute_ctm_payments.ctm_vendor_id','LEFT');
        $this->_db->join('institute_ctm_vendors_category','institute_ctm_vendors_category.category_id=institute_ctm_payments.ctm_vendor_category_id','LEFT');

        $i = 0;

        if(isset($param['inst_id'])){
            $this->_db->where('ctm_inst_id',$param['inst_id']);
        }

        if(isset($param['inst_parent_id'])){
            $this->_db->where('ctm_inst_parent_id',$param['inst_parent_id']);
        }

        if(isset($param['inst_inst_type'])){
            $this->_db->where('ctm_inst_type',$param['inst_inst_type']);
        }

        if(isset($param['int_vendor_id'])){
            $this->_db->where('ctm_vendor_id',$param['int_vendor_id']);
        }


        if(isset($param['payment_status'])){
            $this->_db->where('ctm_payment_paid',$param['payment_status']);
        }

        if(isset($param['bill_date_from']) && isset($param['bill_date_from'])){
            $this->_db->where('DATE(created_at) BETWEEN "'.$param['bill_date_from'].'" AND "'.$param['bill_date_to'].'"');
        }else if(isset($param['bill_date_from']) && !isset($param['bill_date_from'])){
            $this->_db->where('DATE(created_at)',$param['bill_date_from']);
        }else if(!isset($param['bill_date_to']) && isset($param['bill_date_to'])){
            $this->_db->where('DATE(created_at)',$param['bill_date_to']);
        }
            
        $this->_db->order_by('ctm_payment_id', 'ASC');

        $query = $this->_db->get('institute_ctm_payments');

        if($return_query==FALSE){
            return $query->result();
        }else if($return_query==TRUE){
            return $this->_db->last_query();
        } 
    }

    public function __get_payment_data($post=array(),$param=array(),$count=FALSE,$db_group=null,$return_query=FALSE){
        if($db_group!==null){
            $this->_db=$this->load->database($db_group, TRUE);
        }
        $this->_db->select('institute_ctm_payments.*,institute_ctm_vendors.vendor_name,institute_ctm_vendors_category.category_name,institute_ctm_vendors_category.category_description');
        $this->_db->join('institute_ctm_vendors','institute_ctm_vendors.vendor_id=institute_ctm_payments.ctm_vendor_id','LEFT');
        $this->_db->join('institute_ctm_vendors_category','institute_ctm_vendors_category.category_id=institute_ctm_payments.ctm_vendor_category_id','LEFT');

        $i = 0;

        if(isset($param['inst_id'])){
            $this->_db->where('ctm_inst_id',$param['inst_id']);
        }

        if(isset($param['inst_parent_id'])){
            $this->_db->where('ctm_inst_parent_id',$param['inst_parent_id']);
        }

        if(isset($param['inst_inst_type'])){
            $this->_db->where('ctm_inst_type',$param['inst_inst_type']);
        }

        if(isset($param['int_vendor_id'])){
            $this->_db->where('ctm_vendor_id',$param['int_vendor_id']);
        }


        if(isset($param['payment_status'])){
            $this->_db->where('ctm_payment_paid',$param['payment_status']);
        }

        if(isset($param['bill_date_from']) && isset($param['bill_date_from'])){
            $this->_db->where('DATE(created_at) BETWEEN "'.$param['bill_date_from'].'" AND "'.$param['bill_date_to'].'"');
        }else if(isset($param['bill_date_from']) && !isset($param['bill_date_from'])){
            $this->_db->where('DATE(created_at)',$param['bill_date_from']);
        }else if(!isset($param['bill_date_to']) && isset($param['bill_date_to'])){
            $this->_db->where('DATE(created_at)',$param['bill_date_to']);
        }

        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_ctm_payments');

            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_ctm_payments');
            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_ctm_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_ctm_cash_balance';
        return $this->modify($data,$param,$batch,$return_query);
    }

    public function delete_cash_balance_data($param,$return_query=FALSE){
        $this->table='institute_ctm_cash_balance';
        return $this->remove($param,0,$return_query);
    }

    public function get_cash_balance($param=null,$single_row=TRUE,$return_query=FALSE){
        $this->table='institute_ctm_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 _get_cash_balance($post=array(),$param=array(),$count=FALSE,$db_group=null,$return_query=FALSE){
        if($db_group!==null){
            $this->_db=$this->load->database($db_group, TRUE);
        }
        $this->_db->select('institute_ctm_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_ctm_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_ctm_cash_balance');
            if($return_query==FALSE){
                return $query->num_rows();
            }else if($return_query==TRUE){
                return $this->_db->last_query();
            }           
        }
    }


    //Bank Balance
    public function store_bank_balance_data($data,$return_query=FALSE){
        $this->table='institute_ctm_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_ctm_banks_balance';
        return $this->modify($data,$param,$batch,$return_query);
    }

    public function delete_bank_balance_data($param,$return_query=FALSE){
        $this->table='institute_ctm_banks_balance';
        return $this->remove($param,0,$return_query);
    }

    public function get_bank_balance($param=null,$single_row=TRUE,$return_query=FALSE){
        $this->table='institute_ctm_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,$db_group=null,$return_query=FALSE){
        if($db_group!==null){
            $this->_db=$this->load->database($db_group, TRUE);
        }
        $this->_db->select('institute_ctm_banks_balance.*,institute_banks.bank_name,institute_banks.bank_account_no');
        $this->_db->join('institute_banks','institute_banks.bank_id=institute_ctm_banks_balance.balance_bank_id','LEFT');

        $i = 0;

        if(isset($param['inst_id'])){
            $this->_db->where('balance_inst_id',$param['inst_id']);
        }

        if(isset($param['inst_type'])){
            $this->_db->where('balance_inst_type',$param['inst_type']);
        }


        if(isset($param['column_search'])){
            foreach ($param['column_search'] as $item)
            {
                if(isset($post['search']['value']) && $post['search']['value'])
                {
                    
                    if($i===0)
                    {
                        $this->_db->group_start();
                        $this->_db->like($item, $post['search']['value']);
                    }
                    else
                    {
                        $this->_db->or_like($item, $post['search']['value']);
                    }

                    if(count($param['column_search']) - 1 == $i)
                        $this->_db->group_end();
                }
                
                $i++;
            }
        }
            
        if(isset($post['order']))
        {
            $column_order=$param['column_order'];
            $this->_db->order_by($column_order[$post['order']['0']['column']], $post['order']['0']['dir']);
        } 
        else if(isset($param['order']))
        {
            $order = $param['order'];
            $this->_db->order_by(key($order), $order[key($order)]);
        }

        if($count==FALSE){
            if(isset($post['length']) && $post['length'] != -1){
                $this->_db->limit($post['length'],$post['start']);   
            }
            
            $query = $this->_db->get('institute_ctm_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_ctm_banks_balance');
            if($return_query==FALSE){
                return $query->num_rows();
            }else if($return_query==TRUE){
                return $this->_db->last_query();
            }           
        }
    }



    //Order & Payment
    public function store_order_data($data,$batch=FALSE,$db_group=null,$return_query=FALSE){
        if($db_group!==null){
            $this->_db=$this->load->database($db_group, TRUE);
        }
        $this->table='institute_ctm_vendors_orders';
        return $this->store($data,$batch,$return_query);
    }

    public function update_order_data($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_ctm_vendors_orders';
        return $this->modify($data,$param,$batch,$return_query);
    }

    public function delete_order_data($param,$db_group=null,$return_query=FALSE){
        if($db_group!==null){
            $this->_db=$this->load->database($db_group, TRUE);
        }
        $this->table='institute_ctm_vendors_orders';
        return $this->remove($param,0,$return_query);
    }


    public function get_order_data($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_ctm_vendors_orders';
        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);
        }       
    }

}