<?php
class Print_chart_model extends CI_Model{	
	public function GetInfo($package_id){
		$this->db->from('package');
		$this->db->where('package_id',$package_id);
		$a=$this->db->get();
		if($a->num_rows() === 1){
			return $a->row();		
		}else{
			foreach ($this->db->list_fields('package') as $field){
				$PersonObj->field= '';
			}
			return $PersonObj;
		}
	}
	public function get_found_rows($search){
		$this->db->select('*');
		$this->db->from('package');
		return $this->db->get()->num_rows();
	}	
	public function get_packages(){
		$this->db->from('package');
		$this->db->where('status',1);
		return $this->db->get()->result_array();
	}
	public function package_name($package_id){
		$this->db->select('CONCAT( package_title," ",package_title2, " ", package_title3 ) AS package_name');
		$this->db->from('package');
		$this->db->where('package_id',$package_id);
		return $this->db->get()->row();
	}
	public function get_boarding_point(){
		$this->db->from('boarding_point');
		$this->db->where('status',1);
		return $this->db->get()->result_array();
	}	
	public function get_dep_date($package_id){
		$this->db->select('package_id,dep_date,tripcode,tripid');
		$this->db->from('vehicletrips');
		$this->db->join('package', 'package.package_id = vehicletrips.trippackid');
		$this->db->join('vehicle', 'vehicle.vehicle_id = vehicletrips.vehicleid');
		$this->db->where('package.package_id', $package_id);
		$this->db->where('package.status', 1);	
		$this->db->where('vehicletrips.status', 1);				
		return $this->db->get()->result_array();		 
		//echo $this->db->last_query();
	}
	public function search($package_id,$dep_date,$trip_id,$board_point_id){
		$this->db->select('tripid,tripcode,tripdates,tripboarding,trippackid,seat_capacity,package_title,vehicle_id');
		$this->db->from('vehicletrips');
		$this->db->join('package', 'package.package_id = vehicletrips.trippackid');
		$this->db->join('boarding', 'boarding.package_id = package.package_id');
		$this->db->join('vehicle', 'vehicle.vehicle_id = vehicletrips.vehicleid');
		$this->db->where('package.package_id', $package_id);
		$this->db->where("FIND_IN_SET('$dep_date', sblttweb_package.dep_date)");
		$this->db->where('package.status', 1);	
		if($board_point_id){
			$this->db->where('board_point_id',$board_point_id);
		}
		if($trip_id){
			$this->db->where('vehicletrips.tripid', $trip_id);
			$this->db->group_by('vehicletrips.tripid', $trip_id);
		}
		$result = $this->db->get()->result_array();
		return $result;
	}
	public function get_booking_count($package_id,$dep_date,$trip_id){
		$doj = date("Y-m-d",strtotime($dep_date));
		$this->db->from('passlist');
		$this->db->join('ticketorder', 'ticketorder.orderid = passlist.ticketorderid');
		$this->db->join('vehicletrips', 'vehicletrips.tripid = passlist.passtripid');
		$this->db->where('ticketorder.packid', $package_id);
		$this->db->where('ticketorder.doj', $doj);
		if($trip_id){
			$this->db->where('passlist.passtripid', $trip_id);
		}
		$this->db->group_start();
		$this->db->where('passlist.passstatus', 0)->or_where('passlist.passstatus', 2);
		$this->db->group_end();
		$this->db->where_in('ticketorder.orderstat', array('1','2','4'));
		return $this->db->get()->num_rows();
	}
	// public function get_vehicle_data($vehicle_id) {
	// 	$this->db->from('vehicle');
	// 	$this->db->where('vehicle_id', $vehicle_id);
	// 	return $this->db->get()->result_array();
	// }
	public function get_passenger_data($package_id,$package_date,$trip_id){
		$package_date = date("Y-m-d",strtotime($package_date));
		$this->db->select('CONCAT( passname,",",passmobile, "_", seatno ) AS seats');
		$this->db->from('passlist');
		$this->db->join('ticketorder', 'ticketorder.orderid = passlist.ticketorderid');
		$this->db->where('packid', $package_id);
		$this->db->where('doj', $package_date);	
		$this->db->where('otripid', $trip_id);
		$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'));	
		return $this->db->get()->result_array();
	}
	public function get_update_info($tripid){
		$this->db->select('guruswamy_name,guruswamy_mobile,driver_name,driver_mobile,cleaner_name,cleaner_mobile,vehicle_no');
		$this->db->from('vehicletrips');
		$this->db->where('vehicletrips.tripid', $tripid);
		return $this->db->get()->result_array();
	}
	public function save_trip_info($tripid,$trip_data){
		$this->db->where('tripid',$tripid);
	    $update_trip = $this->db->update('vehicletrips',$trip_data);
	    if($update_trip){
	    	return true;
	    }else{
	    	return false;
	    }
	}
	public function get_vehicle_data($tripid){
		$this->db->from('vehicletrips');
		$this->db->where('tripid', $tripid);
		return $this->db->get()->result_array();
	}
}
?>