<?php
class Discount_report_model extends CI_Model{
    public function get_packages(){
		$this->db->from('package');
		return $this->db->get()->result_array();
    }
    public function get_customer_suggestions($term){		
		$this->db->from('customers');	
        $this->db->like('custfname',$term);
        $this->db->or_like('custlname',$term);
        $this->db->or_like('custmobile',$term);
		$suggestions = array();
		foreach($this->db->get()->result() as $row){
			$suggestions[] = array('label' => "$row->custfname $row->custlname-$row->custmobile", 'custid' => $row->custid,'customer_name' => $row->custfname." ".$row->custlname ,'custmobile' => $row->custmobile);
		}
		return $suggestions;
    }
    public function search($package_name,$custid){
        $package_name =implode(",",$package_name);
		$this->db->select('orderid,sblttweb_ticketorder.custid as custid,custfname,custlname,custmobile,IFNULL(sum(sblttweb_passlist.ticketamt),0) as ticketamt,IFNULL(sum(sblttweb_passlist.discountamt),0) as discountamt,IFNULL(sum(sblttweb_passlist.admin_discountamt),0) as admn_discountamt,sblttweb_passlist.cashpaid as cashpaid,IFNULL(sum(sblttweb_passlist.cashdue),0) as cashdue,package_title,package_title2,package_title3,doj,count(passid) as nopass,boarding_name,tripcode,passtripid');
        $this->db->from('passlist');
        $this->db->join('ticketorder', 'ticketorder.orderid = passlist.ticketorderid');
        $this->db->join('package', 'package.package_id =    ticketorder.packid');
        $this->db->join('customers', 'customers.custid =    ticketorder.custid');	
        $this->db->join('boarding', 'boarding.boarding_id = ticketorder.boarding'); 
        $this->db->join('boarding_point', 'boarding_point.board_point_id = boarding.board_point_id');   
        $this->db->join('vehicletrips', 'vehicletrips.tripid = passlist.passtripid');
        //$this->db->where('DATE_FORMAT(sblttweb_ticketorder.doj, "%Y-%m-%d")  BETWEEN '. $this->db->escape($start_date).' AND  '.$this->db->escape($end_date));
        if($package_name){
            $this->db->where_in('package.package_id', $package_name); 
            $this->db->group_by('passlist.passtripid');            
        }
        if($custid){
            $this->db->where('ticketorder.custid', $custid);
            $this->db->group_by('ticketorder.custid'); 
        }                
        $this->db->where('sblttweb_ticketorder.pnrno >', 0);
        $this->db->group_start();
        $this->db->where('passstatus',0)->or_where('passlist.passstatus', 2);
        $this->db->group_end();
        $this->db->where_in('ticketorder.orderstat', array('1','2','4'));
        $this->db->group_by('passlist.passtripid');
        $result = $this->db->get()->result_array();
	    return $result; 
    }
}
?>