1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / bank_loan / application / models / admin /
Filename : Package_model.php
back
<?php
class Package_model extends CI_Model{
	
	public function __construct() {
		parent::__construct();
		$this->load->database();
		
		$this->table = 'tbl_package';
        $this->table1 = 'tbl_package_details';
		$this->column_order = array(
            '0'=>'id',
            '1'=>'package_name',
            '2'=>'package_price',
            '3'=>'no_of_dates',
            '4'=>'total_no_of_user'
        );
		$this->column_search = array(
            '0'=>'package_name',
            '1'=>'package_price',
            '2'=>'no_of_dates',
            '3'=>'total_no_of_user'
        );
        $this->order = array('package_name' => 'ASC');
	}
	
	public function getRows($postData){
        $this->_get_datatables_query($postData);
        if($postData['length'] != -1){
            $this->db->limit($postData['length'], $postData['start']);
        }
        $query 	= $this->db->get();
        return pdpadecryptdata_multi_array($query->result());
    }
    public function getViewPurchase($package_id){
        $this->db->select('tbl_package_details.*,tbl_package.package_name,tbl_package.package_price,tbl_package.no_of_dates');
        $this->db->from('tbl_package_details');
        $this->db->join('tbl_package','tbl_package.id = tbl_package_details.package_id','left');
        $this->db->where('tbl_package_details.package_id',$package_id);
        $query = $this->db->get();
        return pdpadecryptdata_multi_array($query->result());
    }
    public function Purchasecount($package_id) {
        $this->db->select_sum('no_of_user_purchase');
        $this->db->from('tbl_package_details');
        $this->db->where('package_id', $package_id);
        $query = $this->db->get();
        if ($query->num_rows() > 0) {
            return $query->row()->no_of_user_purchase;
        } else {
            return 0;
        }
    }
    
    public function countAll($postData){
        $this->db->from($this->table);
		$this->db->where('deleted','0');
        return $this->db->count_all_results();
    }
    
    public function countFiltered($postData){
        $this->_get_datatables_query($postData);
        $query = $this->db->get();
        return $query->num_rows();
    }

    private function _get_datatables_query($postData){
        $this->db->from($this->table);
		
        $i = 0;
        foreach($this->column_search as $item){
            if($postData['search']['value']){
                if($i===0){
                    $this->db->group_start();
                    $this->db->like($item, $postData['search']['value']);
                }else{
                    $this->db->or_like($item, $postData['search']['value']);
                }
                
                if(count($this->column_search) - 1 == $i){
                    $this->db->group_end();
                }
            }
            $i++;
        }
		$this->db->where('deleted','0');
        if(isset($postData['order'])){
			$this->db->order_by($this->column_order[$postData['order']['0']['column']], $postData['order']['0']['dir']);
        }else if(isset($this->order)){
            $order = $this->order;
            $this->db->order_by(key($order), $order[key($order)]);
        }
    }
}
?>