File: /home/cafsindia/allyindian_com/backend/application/controllers/Print_chart.php
<?php if ( ! defined('BASEPATH')) exit('No direct script is allowed');
require_once("Secure_Controller.php");
class Print_chart extends Secure_Controller{
public function __construct(){
parent::__construct('print_chart');
$this->load->model('Print_chart_model');
$this->load->model('Vehicle_model');
}
public function index(){
if(!$this->Appconfig->isAppvalid()){
redirect('config');
}
$data['table_headers']="";
$pack_data=$this->Print_chart_model->get_packages();
$pack_info[""] = "---- Select Package ----";
foreach($pack_data as $row){
$pack_info[$this->xss_clean($row['package_id'])] = $this->xss_clean($row['package_title']."-".$row['package_title2']);
}
$data['package_info']=$pack_info;
$boarding_data=$this->Print_chart_model->get_boarding_point();
$boarding_point_info[""] = "---- Select Boarding Point ----";
foreach($boarding_data as $row){
$boarding_point_info[$this->xss_clean($row['board_point_id'])] = $this->xss_clean($row['boarding_name']);
}
$data['boarding_point_info']=$boarding_point_info;
$this->load->view('print_chart/manage',$data);
}
public function get_dep_date(){
$package_id = $this->input->post('package_id');
$package_date = $this->Print_chart_model->get_dep_date($package_id);
//$trip_code = $this->Print_chart_model->get_dep_date($package_id);
//print_r($package_date);
echo json_encode(array('status' =>"SUCCESS",'package_date' => $package_date));
}
public function search(){
$package_id = $this->input->post('package_id');
$dep_date = $this->input->post('dep_date');
$trip_id = $this->input->post('trip_code');
$board_point_id = $this->input->post('boarding_point');
$print_chart = $this->Print_chart_model->search($package_id,$dep_date,$trip_id,$board_point_id);
$booking_count = $this->Print_chart_model->get_booking_count($package_id,$dep_date,$trip_id);
$tr_line="";
foreach($print_chart as $rslt){
$seat_capacity = $rslt['seat_capacity'];
$trip_code = $rslt['tripcode'];
$trippackid = $rslt['trippackid'];
$package_title = $rslt['package_title'];
$tripid = $rslt['tripid'];
$vehicle_id = $rslt['vehicle_id'];
$available_seat = $seat_capacity - $booking_count;
$url = site_url('print_chart');
$tr_line .= "<tr>
<td style='white-space:nowrap;'>$dep_date</td>
<td>$trip_code</td>
<td>$trippackid</td>
<td>$package_title</td>
<td>$seat_capacity</td>
<td>$booking_count</td>
<td>$available_seat</td>
<td><button onClick=get_customer('$trippackid','$dep_date','$tripid'); class='btn btn-info btn-sm'>View Chart</button></td>
<td><button onClick=update_info($tripid); class='btn btn-primary btn-sm'>Update Info</button></td>
<td><a href='$url/view_seats/$vehicle_id/$trippackid/$dep_date/$tripid' type='button' class='btn btn-success btn-sm'>Layout</a></td>
</tr>";
}
echo json_encode(array('success' => TRUE, 'print_data' => $tr_line));
}
public function view_seats($vehicle_id,$package_id,$dep_date,$tripid){
$data['vehicle_data'] = $this->Print_chart_model->get_vehicle_data($tripid);
$data['package_id'] = $package_id;
$pack = $this->Print_chart_model->package_name($package_id);
$data['package_name'] = $pack->package_name."-".$dep_date;
$data['package_date'] = $dep_date;
$data['trip_id'] = $tripid;
$this->load->view("print_chart/view_chart_layout",$data);
}
public function get_seat_data(){
$trip_id = $this->input->post('trip_id');
$seat_data = $this->Print_chart_model->get_vehicle_data($trip_id);
echo json_encode(array('success' => true, 'seat_data'=>$seat_data));
}
public function get_passenger_data(){
$package_id = $this->input->post('package_id');
$package_date = $this->input->post('package_date');
$trip_id = $this->input->post('trip_id');
$pass_data = $this->Print_chart_model->get_passenger_data($package_id,$package_date,$trip_id);
echo json_encode(array('success' => true, 'pass_data'=>$pass_data));
}
public function get_update_info(){
$tripid = $this->input->post('tripid');
$trip_data = $this->Print_chart_model->get_update_info($tripid);
echo json_encode(array('success' => true, 'trip_data'=>$trip_data));
}
public function save_trip_info(){
$tripid = $this->input->post('tripid');
$trip_data=array(
'guruswamy_name' => $this->input->post('g_name'),
'guruswamy_mobile' => $this->input->post('g_mobile'),
'driver_name' => $this->input->post('d_name'),
'driver_mobile' => $this->input->post('d_mobile'),
'cleaner_name' => $this->input->post('c_name'),
'cleaner_mobile' => $this->input->post('c_mobile'),
'vehicle_no' => $this->input->post('c_vehicle_no')
);
$data = $this->Print_chart_model->save_trip_info($tripid,$trip_data);
if($data){
echo json_encode(array('success' => true, 'message'=>'Trip Data Saved Successfully'));
}else{
echo json_encode(array('success' => false, 'message'=>'Please Try after sometime'));
}
}
}
?>