<?php  if ( ! defined('BASEPATH')) exit('No direct script is allowed');
require_once("Secure_Controller.php");
class Package extends Secure_Controller{	
	public function __construct(){
		parent::__construct('package');
		$this->load->model('Package_model');
	}
	public function index(){
		if(!$this->Appconfig->isAppvalid())
		{
			redirect('config');
		}		
		$data['table_headers']=$this->xss_clean(package_headers());
		$this->load->view('package/manage',$data);
	}

	public function search(){
		$search=$this->input->get('search');
		$limit=$this->input->get('limit');
		$offset=$this->input->get('offset');
		$sort=$this->input->get('sort');
		$order=$this->input->get('order');

		$package=$this->Package_model->search($search,$limit,$offset,$sort,$order);
		$TotalRows=$this->Package_model->get_found_rows($search);

		$DataRows=array();

		foreach ($package->result() as $board_point) 
		{	
			$DataRows[]= package_data_row($board_point,$this);
		}
		//$DataRows=$this->xss_clean($DataRows);
		echo json_encode(array('total'=>$TotalRows,'rows'=>$DataRows));
	}

	public function view($package_id=-1){
		$package_info = $this->Package_model->GetInfo($package_id);
			foreach(get_object_vars($package_info) as $property => $value){
				$package_info->$property = $this->xss_clean($value);
			}
		$data['package_info'] = $package_info;	

		$cancelfee_info[""] = "---- Select Tariff ----";
		$cancelfee_data = $this->Package_model->get_cancelfee();
		foreach($cancelfee_data as $row){
		    $cancelfee_info[$this->xss_clean($row['cancelfeeid'])] = $this->xss_clean($row['cancelfeedetail']).$this->xss_clean($row['cancelfees'])."%";
		}	
		$data['cancelfee_info'] = $cancelfee_info ;	
		$this->load->view("package/form",$data);
	}
	public function view_itinery($package_id){
		$package_info = $this->Package_model->GetInfo($package_id);
			foreach(get_object_vars($package_info) as $property => $value){
				$package_info->$property = $this->xss_clean($value);
			}
		$data['package_data'] = $package_info;
		$data['boarding_info'] = $boarding_info;
		$bp_info[""] = "---- Select Boarding Point ----";
		$boarding_data = $this->Package_model->get_boarding();
		foreach($boarding_data as $row){
		    $bp_info[$this->xss_clean($row['board_point_id'])] = $this->xss_clean($row['boarding_name']);
		}
		$data['bp_info'] = $bp_info;

		$vehicle_category_info[""] = "---- Select Vehicle ----";
		$category_data = $this->Package_model->get_vehicle_category();
		foreach($category_data as $row){
		    $vehicle_category_info[$this->xss_clean($row['veh_cat_id'])] = $this->xss_clean($row['veh_category']);
		}
		$data['vehicle_category_info'] = $vehicle_category_info;
		
		$vehicle_info[""] = "---- Select Vehicle ----";
		$vehicle_data = $this->Package_model->get_vehicle();
		foreach($vehicle_data as $row){
		    $vehicle_info[$this->xss_clean($row['vehicle_id'])] = $this->xss_clean($row['vehicle_no']);
		}
		$data['vehicle_info']   = $vehicle_info;
		$pack_type_info[""] = "---- Select Tariff ----";
		$pack_type_data = $this->Package_model->get_package_type();
		foreach($pack_type_data as $row){
		    $pack_type_info[$this->xss_clean($row['package_type_id'])] = $this->xss_clean($row['package_type']);
		}
		$data['pack_type_info']   = $pack_type_info;		
		$data['trip_data']      = $this->Package_model->get_trip_data($package_id);
		$data['boarding_data']  = $this->Package_model->get_boarding_data($package_id);
		$data['tariff_data']    = $this->Package_model->get_tariff_data($package_id);
		$data['ilinerary_data'] = $this->Package_model->get_itinerary_data($package_id);
		$this->load->view("package/itinerary_details",$data);
	}	
	public function get_vehicle_type($id){
			$type = $this->Package_model->get_vehicle_type($id);
			echo json_encode(array('status' =>"SUCCESS",'type' => $type));
	}
	public function get_vehicle($id){
		$vehicle = $this->Package_model->get_vehicles($id);
		echo json_encode(array('status' =>"SUCCESS",'vehicle' => $vehicle));
	}	
	public function save_package($package_id=-1){		
		$package_data = array(				
			'region'          => $this->input->post('region'),
			'package_title'   => $this->input->post('package_title'),
			'package_title2'  => $this->input->post('package_title2'),
			'package_title3'  => $this->input->post('package_title3'),
			'duration'        => $this->input->post('duration'),
			'dep_type'        => $this->input->post('dep_type'),
			'packagein'       => $this->input->post('packagein'),
			'packageex'       => $this->input->post('packageex'),
			'dep_date'        => $this->input->post('dep_date'),
			'discount'        => $this->input->post('discount'),
			'discountdetail'  => $this->input->post('discountdetail'),
			'servicetax'      => $this->input->post('gst'),
			'cancelfee'       => implode(",",$this->input->post('cancelfeedetail')),
			'status'          => $this->input->post('status'),			
			'created_by'      => $this->session->userdata('emp_id'),
			'created_date'    => date('Y-m-d h:i:s')
		);	
		$package = $this->Package_model->save_package($package_data,$package_id);

		if($package){
				if($package_id === -1){
					echo json_encode(array('success' => 'TRUE', 'message' => "Package Successfully Created", 'id' => $package_id));
				}else{
					echo json_encode(array('success' => 'TRUE', 'message' => "Package Successfully Updated", 'id' => $package_id));
				}
			}else{				
				echo json_encode(array('success' => FALSE, 'message' => "Please Try After Sometime", 'pack_id' => -1));
			}
	}
/** START  Trip Details Insert / Update **/
public function save_trip_details(){		
	$trip_id = $this->input->post('trip_id');	
	$trip_data = array(			
		'trippackid'      => $this->input->post('package_id'),
		'seatmap'         => $this->input->post('seatdata'),
		'vehicleid'       => $this->input->post('vehicle'));	

	$trip = $this->Package_model->save_trip_details($trip_data,$trip_id);
	if($trip){
			echo json_encode(array('success' => 'TRUE', 'message' => "Trip Successfully Created", 'trip_data' => $trip));
		}else{				
			echo json_encode(array('success' => FALSE, 'message' => "Please Try After Sometime", 'trip_data' => -1));
		}
}
public function get_trips($tripid){
	$trips_data = $this->Package_model->get_trips($tripid);
	echo json_encode(array('success' => 'TRUE', 'message' => "Success", 'trips_data' => $trips_data));
}

/** END  Trip Details Insert / Update **/

/** START  Boarding Details Insert / Update **/
public function save_boarding_details(){		
	$boarding_id = $this->input->post('boarding_id');	
	$boarding_data = array(			
		'package_id'            => $this->input->post('package_id'),
		'board_point_id'        => $this->input->post('board_point_id'),
		'dep_time'              => $this->input->post('dep_time'),
		'status'                => $this->input->post('status'));	

	$boarding = $this->Package_model->save_boarding_details($boarding_data,$boarding_id);
	if($boarding){
			echo json_encode(array('success' => 'TRUE', 'message' => "Boarding Successfully Created/Updated", 'boarding_data' => $boarding));
		}else{				
			echo json_encode(array('success' => FALSE, 'message' => "Please Try After Sometime", 'boarding_data' => -1));
		}
}
public function get_boarding($boarding_id){
	$boarding_data = $this->Package_model->get_boarding_up($boarding_id);
	echo json_encode(array('success' => 'TRUE', 'message' => "Success", 'boarding_data' => $boarding_data));
}
/** END  Boarding Details Insert / Update **/
/** START  Boarding Details Insert / Update **/
public function save_tariff_details(){		
	$pcostid     = $this->input->post('pcostid');	
	$tariff_data = array(			
		'packid'            => $this->input->post('package_id'),
		'packtypeid'        => $this->input->post('pack_type'),
		'pamount'           => $this->input->post('tariff_cost'),
		'pcoststatus'       => 1);	

	$tariff = $this->Package_model->save_tariff_details($tariff_data,$pcostid);
	if($tariff){
			echo json_encode(array('success' => 'TRUE', 'message' => "Tariff Successfully Created/Updated", 'tariff_data' => $tariff));
		}else{				
			echo json_encode(array('success' => FALSE, 'message' => "Please Try After Sometime", 'tariff_data' => -1));
		}
}
public function get_tariff($pcostid){
	$tariff_data = $this->Package_model->get_tariff_up($pcostid);
	echo json_encode(array('success' => 'TRUE', 'message' => "Success", 'tariff_data' => $tariff_data));
}

/** END  Boarding Details Insert / Update **/
public function save_itinerary(){		
$itinerary_id = $this->input->post('itinerary_id');	
$itinerary_data = array(			
	'itpackid'       => $this->input->post('package_id'),
	'itslno'         => $this->input->post('days'),
	'itday'          => "Day"." ".$this->input->post('days'),
	'itdaydetail'    => $this->input->post('itinerary_details'),
	'itnight'        => $this->input->post('night_stay'),		
	'itstatus'       => '1');	

$itinerary_data = $this->Package_model->save_itinerary($itinerary_data,$itinerary_id);
if($itinerary_data){
			echo json_encode(array('success' => 'TRUE', 'message' => "itinerary Successfully Created/Updated", 'itinerary_data' => $itinerary_data));
	}else{				
		echo json_encode(array('success' => FALSE, 'message' => "Please Try After Sometime", 'pack_id' => -1));
	}
}
public function get_ilinerary($itid){
	$ilinerary_data = $this->Package_model->get_itinerary($itid);
	echo json_encode(array('success' => 'TRUE', 'message' => "itinerary Successfully Created", 'itinerary_data' => $ilinerary_data));
}
	
	public function delete(){
		$package_id = $this->xss_clean($this->input->post('ids'));
		if($this->Package_model->delete_list($package_id)){
			echo json_encode(array('success' => TRUE, 'message' => "Package Deleted Successfully"));
		}else{
			echo json_encode(array('success' => FALSE, 'message' => "Package Cannot be Deleted"));	
		}
	}
}

?>