<?php
class Cancel_ticket_model extends CI_Model{
	public function get_packages(){
		$this->db->from('package');
		$this->db->where('status',1);
		return $this->db->get()->result_array();
	}
	public function get_package_data($search_by,$search_text,$package){
		$this->db->from('ticketorder');
		$this->db->join('customers', 'customers.custid = ticketorder.custid');
		$this->db->join('passlist', 'passlist.ticketorderid = ticketorder.orderid');
		if($search_by === "1"){
			$this->db->where('passlist.pnrno', $search_text);
		}else
		if($search_by === "2"){
			$this->db->where('orderid', $search_text);
		}else
		if($search_by === "3"){
			$this->db->where('packid', $package);
		}	
		$this->db->group_start();
		$this->db->where('passstatus', 0)->or_where('passstatus', 2);
		$this->db->group_end();
		$this->db->where_in('ticketorder.orderstat', array('1','2','4'));
		$this->db->group_by('ticketorderid');	
		$this->db->order_by('ticketorderid',DESC);		
		return $this->db->get()->result_array();
	}
	public function get_ticket_data($orderid){
		$this->db->select('*,passlist.discount as discount');	
		$this->db->from('ticketorder');	
		$this->db->join('customers', 'customers.custid = ticketorder.custid');
		$this->db->join('passlist', 'passlist.ticketorderid = ticketorder.orderid');
		$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->where('orderid', $orderid);	
		return $this->db->get()->result_array();
		//echo $this->db->last_query();
	}
	public function get_discount_data(){
		$this->db->from('cancelfee');	
		return $this->db->get()->result_array();
	}
	public function cancel_pass_ticket($passid,$cancel_data){		
		$order_id = $cancel_data['bookorderid'];
		$this->db->insert('cancelorder',$cancel_data);
		$cancel_order_id = $this->db->insert_id();
		
		$pass_data = array(
			'passstatus'       => 1,
			'cancelfee'        => $cancel_data['cancelfee'],
			'cancelamt'        => $cancel_data['cancelamt'],
			'ticketrefundamt'  => $cancel_data['refundamt'],
			'cashcancelamt'    => $cancel_data['cancelamt'],
			'cashrefundamt'    => $cancel_data['refundamt'],
			'cancelorderid'    => $cancel_order_id,
			'fincashrefundamt' => $cancel_data['refundamt']
		);
		if($cancel_order_id){
			$this->db->where('passid', $passid);
		 	return $this->db->update('passlist',$pass_data);		 	
		}else{
			return false;
		}
	}
	public function get_cancel_details($passid){
		$this->db->from('cancelorder');	
		$this->db->join('customers', 'customers.custid = cancelorder.custid');
		$this->db->where('pass_id', $passid);
		return $this->db->get()->result_array();
	}
	
}
?>