<?php
class Cancelation_report_model extends CI_Model{
    public function get_packages(){
		$this->db->from('package');
		return $this->db->get()->result_array();
    }
	public function search($start_date,$end_date,$package_id){
		$this->db->select('passname,passgender,passage,passmobile,boarding_name,ticketorderid,passlist.pnrno,package_title,ticketorder.doj,seatno,sblttweb_passlist.ticketamt as ticketamt,sblttweb_passlist.cashpaid as cashpaid,passlist.cancelfee,passlist.cancelamt,refund_percentage,amount,payment.paytype,settlestatus'); 
		$this->db->from('passlist');
		$this->db->join('ticketorder', 'ticketorder.orderid = passlist.ticketorderid');
		$this->db->join('package', 'package.package_id = ticketorder.packid');		
		$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('payment', 'payment.orderid = passlist.cancelorderid','left');		
		$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_id){
			$this->db->where_in('ticketorder.packid', $package_id);
		}		
		$this->db->where('passstatus', 1);			  
		return $this->db->get()->result_array(); 
		// echo $this->db->last_query();
	}
	
}
?>