1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / 4petalsdemo / application / models /
Filename : Agent_orders_model.php
back
<?php
class Agent_orders_model extends CI_Model{
	
	public function __construct() {
		parent::__construct();
		$this->load->database();
		
		$this->table = 'tbl_orders';       
		$this->column_order = array(
            '0'=>'tbl_orders.id',
			'1'=>'tbl_orders.ord_id',
			'2'=>'tbl_orders.ord_book_date',
			'3'=>'tbl_customer.customer_name',
			'4'=>'tbl_customer.customer_mobile_no',
			'5'=>'tbl_customer_address.cust_address_line1',
			'6'=>'tbl_orders.ord_total',
			'7'=>'tbl_orders_status.status_name'
        );
		$this->column_search = array(
            '0'=>'tbl_orders.id',
			'1'=>'tbl_orders.ord_id',
			'2'=>'tbl_orders.ord_book_date',
			'3'=>'tbl_customer.customer_name',
			'4'=>'tbl_customer.customer_mobile_no',
			'5'=>'tbl_customer_address.cust_address_line1',
			'6'=>'tbl_customer_address.cust_city',
			'7'=>'tbl_customer_address.cust_state',
			'8'=>'tbl_customer_address.cust_pincode',
			'9'=>'tbl_orders.ord_total',
			'10'=>'tbl_orders_status.status_name'
        );
        $this->order = array('tbl_orders.ord_id' => 'DESC');
	}
	
	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 $query->result();
    }
    
    public function countAll($postData){
        $this->db->from($this->table);
		$this->db->where('tbl_orders.ord_agent_id',$this->session->userdata('agent_id'));
		if($postData['condition']==1){
			$this->db->where('tbl_orders.ord_book_date!=',date('Y-m-d'));
		}else if($postData['condition']==2){
			$this->db->where('tbl_orders.ord_agent_confirm',1);
			$this->db->where('tbl_orders.ord_book_date<=',date('Y-m-d'));
			
			$array = ' (tbl_orders.ord_status="3" OR tbl_orders.ord_status="5")';
			$this->db->where($array);
		}else if($postData['condition']==3){
			$this->db->where('tbl_orders.ord_agent_confirm',1);
			
			$array = ' (tbl_orders.ord_status="6" OR tbl_orders.ord_status="7")';
			$this->db->where($array);
		}
        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->select('tbl_customer.*,tbl_customer_address.*,tbl_orders_status.status_name,tbl_orders.*');
        $this->db->from($this->table);
        $this->db->join('tbl_customer','tbl_customer.id=tbl_orders.ord_cust_id','LEFT');
        $this->db->join('tbl_customer_address','tbl_customer_address.id=tbl_orders.ord_address_id','LEFT');
        $this->db->join('tbl_orders_status','tbl_orders_status.id=tbl_orders.ord_status','LEFT');
		
        $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('tbl_orders.ord_agent_id',$this->session->userdata('agent_id'));
		if($postData['condition']==1){
			$this->db->where('tbl_orders.ord_book_date!=',date('Y-m-d'));
		}else if($postData['condition']==2){
			$this->db->where('tbl_orders.ord_agent_confirm',1);
			$this->db->where('tbl_orders.ord_book_date<=',date('Y-m-d'));
			
			$array = ' (tbl_orders.ord_status="3" OR tbl_orders.ord_status="5")';
			$this->db->where($array);
		}else if($postData['condition']==3){
			$this->db->where('tbl_orders.ord_agent_confirm',1);
			
			$array = ' (tbl_orders.ord_status="6" OR tbl_orders.ord_status="7")';
			$this->db->where($array);
		}
		
        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)]);
        }
    }
}
?>