File: /home/cafsindia/allyindian_com/sbltt/application/controllers/Analaysis_report.php
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
require_once("Secure_Controller.php");
class Analaysis_report extends Secure_Controller{
public function __construct(){
parent::__construct('analaysis_report');
$this->load->model('Analaysis_report_model');
}
public function index(){
if(!$this->Appconfig->isAppvalid()){
redirect('config');
}
$data['process_info'] = array('' => '--Select Process--','enquiry'=>'Enquiry','booking' => 'Booking','operation' => 'Operation','accounts' => 'Accounts');
$data['lead_sts'] = array('1' => 'Follow Up','2' => 'Confirm','3' => 'Cancelled','4' => 'Completed','5' => 'On Progress');
$data['referral_type'] = array('Direct'=>'Direct','Walkin_Customer'=>'Walkin Customer','Staff'=>'Staff','Driver'=>'Driver','Vehicle'=>'Vehicle','Web_Portal'=>'Web Portal','Advertisement'=>'Advertisement');
foreach($this->Analaysis_report_model->get_booking_type() as $row){
$booking_type[$this->xss_clean($row->booking_type_id)] = $this->xss_clean($row->booking_type_name);
}
$data['booking_type'] = $booking_type;
foreach($this->Analaysis_report_model->get_trip_type() as $row){
$trip_type[$this->xss_clean($row->trip_type_id)] = $this->xss_clean($row->trip_type_name);
}
$data['trip_type'] = $trip_type;
foreach($this->Analaysis_report_model->get_vehicle_type() as $row){
$vehicle_type[$this->xss_clean($row->veh_type_id)] = $this->xss_clean($row->veh_type." - ".$row->veh_category);
}
$data['vehicle_type'] = $vehicle_type;
$referral_by['0'] = "Others";
foreach($this->Analaysis_report_model->get_referral() as $row){
$referral_by[$this->xss_clean($row->person_id)] = $this->xss_clean($row->first_name."-".$row->role_name);
}
$data['referral_by'] = $referral_by;
$this->load->view('analaysis_report/manage', $data);
}
public function get_source(){
$search = $this->input->get('term');
$suggestions = $this->xss_clean($this->Analaysis_report_model->get_source($search));
echo json_encode($suggestions);
}
public function get_vehicle_no(){
$vehicle_type = $this->input->post('vehicle_type');
$vehicle_list = $this->Analaysis_report_model->get_vehicle_no($vehicle_type);
echo json_encode(array('status' =>"SUCCESS",'vehicle_list' => $vehicle_list));
}
public function search(){
$start_date = $this->input->post('start_date');
$end_date = $this->input->post('end_date');
$table_name = $this->input->post('process');
$lead_sts = $this->input->post('lead_sts');
$booking_type = $this->input->post('booking_type');
$trip_type = $this->input->post('trip_type');
$vehicle_type = $this->input->post('vehicle_type');
$vehicle_no = $this->input->post('vehicle_no');
$referral_by = $this->input->post('referral_by');
$referral_type = $this->input->post('referral_type');
$orgin = $this->input->post('orgin');
$destination = $this->input->post('destination');
$search_info = $this->Analaysis_report_model->search($start_date,$end_date,$table_name,$lead_sts,$booking_type,$trip_type,$vehicle_type,$vehicle_no,$referral_by,$referral_type,$orgin,$destination);
$tr_line = "";
foreach($search_info as $rslt){
$sts_info = array('enquiry'=>'enquiry_sts','booking'=>'booking_sts','operation'=>'operation_sts','accounts'=>'accounts_sts');
$sts_name = array('1'=>'Follow Up','2'=>'Confirm','3'=>'Cancelled','4'=>'Completed','5'=>'On Progress');
$sts = $sts_info[$table_name];
$sts_rslt = $rslt->$sts;
$status = $sts_name[$sts_rslt];
$from_date = date('d-m-Y',strtotime($rslt->from_date));
$to_date = date('d-m-Y',strtotime($rslt->to_date));
$referral_type = str_replace("_"," ",$rslt->referral_type);
$ncd = date('d-m-Y',strtotime($rslt->ncd));
$referred_by = "Others";
if($rslt->referral !== "0"){
$referred_by = $rslt->referred_by;
}
$created_date = date('d-m-Y',strtotime($rslt->created_date));
if($table_name === "enquiry"){
$tr_line .= "<tr>
<td>$rslt->customer_name</td>
<td>$rslt->phone_number</td>
<td style='white-space:nowrap;'>$from_date</td>
<td style='white-space:nowrap;'>$to_date</td>
<td>$rslt->frm_city_name</td>
<td>$rslt->to_city_name</td>
<td>$rslt->bus_count</td>
<td>$rslt->pax</td>
<td>$rslt->trip_days</td>
<td>$rslt->booking_amount</td>
<td>$rslt->trip_type_name</td>
<td>$referral_type</td>
<td>$rslt->booking_type_name</td>
<td>$rslt->veh_type</td>
<td>$referred_by</td>
<td>$rslt->remark</td>
<td>$rslt->avg_km</td>
<td>$rslt->billing_name</td>
<td>$rslt->report_address</td>
<td>$rslt->landmark</td>
<td>$rslt->cancel_reson</td>
<td>$rslt->trip_details</td>
<td style='white-space:nowrap;'>$ncd</td>
<td>$status</td>
<td style='white-space:nowrap;'>$created_date</td>
</tr>";
}else
if($table_name === "booking"){
$payment_type = str_replace("_"," ",$rslt->payment_type);
$toll = "NO";
if($rslt->toll === "1"){
$toll = "Yes";
}
$parking = "NO";
if($rslt->parking === "1"){
$parking = "Yes";
}
$driver_batta = "NO";
if($rslt->driver_batta === "1"){
$driver_batta = "Yes";
}
$state_tax = "NO";
if($rslt->state_tax === "1"){
$state_tax = "Yes";
}
$catering = "Non package";
if($rslt->catering === "1"){
$catering = "Package";
}
$operation_type = "Only Driver";
if($rslt->operation_type === "1"){
$operation_type = "Vehicle with driver";
}
$reporting_time = date("G:i", strtotime($rslt->reporting_time));
$shed_out_time = date("G:i", strtotime($rslt->shed_out_time));
$tr_line .= "<tr>
<td>$rslt->customer_name</td>
<td>$rslt->phone_number</td>
<td>$rslt->tour_no</td>
<td style='white-space:nowrap;'>$from_date</td>
<td style='white-space:nowrap;'>$to_date</td>
<td>$rslt->frm_city_name</td>
<td>$rslt->to_city_name</td>
<td>$rslt->bus_count</td>
<td>$rslt->pax</td>
<td>$rslt->trip_days</td>
<td>$rslt->trip_type_name</td>
<td>$referral_type</td>
<td>$rslt->booking_type_name</td>
<td>$rslt->veh_type</td>
<td>$referred_by</td>
<td>$rslt->remark</td>
<td>$rslt->avg_km</td>
<td>$rslt->billing_name</td>
<td>$rslt->report_address</td>
<td>$rslt->landmark</td>
<td>$rslt->cancel_reson</td>
<td>$rslt->trip_details</td>
<td>$toll</td>
<td>$parking</td>
<td>$driver_batta</td>
<td>$state_tax</td>
<td>$catering</td>
<td>$operation_type</td>
<td>$rslt->tp_info</td>
<td>$reporting_time Hrs</td>
<td>$shed_out_time Hrs</td>
<td>$rslt->book_amount</td>
<td>$rslt->cat_amt</td>
<td>$rslt->stay_amt</td>
<td>$rslt->adv_amt</td>
<td>$rslt->paid_tot</td>
<td>$rslt->dis_amt</td>
<td>$rslt->tax_precentage</td>
<td>$rslt->bal_amt</td>
<td>$payment_type</td>
<td>$status</td>
<td style='white-space:nowrap;'>$created_date</td>
</tr>";
}else
if($table_name === "operation"){
$payment_type = str_replace("_"," ",$rslt->payment_type);
$toll = "NO";
if($rslt->toll === "1"){
$toll = "Yes";
}
$parking = "NO";
if($rslt->parking === "1"){
$parking = "Yes";
}
$driver_batta = "NO";
if($rslt->driver_batta === "1"){
$driver_batta = "Yes";
}
$state_tax = "NO";
if($rslt->state_tax === "1"){
$state_tax = "Yes";
}
$catering = "Non package";
if($rslt->catering === "1"){
$catering = "Package";
}
$operation_type = "Only Driver";
if($rslt->operation_type === "1"){
$operation_type = "Vehicle with driver";
}
$reporting_time = date("G:i", strtotime($rslt->reporting_time));
$shed_out_time = date("G:i", strtotime($rslt->shed_out_time));
$suspence_amt = $rslt->suspence_amt + $rslt->op_suspence_amt;
$driver_suspence_amount = $rslt->driver_suspence_amount;
$tr_line .= "<tr>
<td>$rslt->customer_name</td>
<td>$rslt->billing_name</td>
<td>$rslt->phone_number</td>
<td>$rslt->tour_no</td>
<td style='white-space:nowrap;'>$from_date</td>
<td style='white-space:nowrap;'>$to_date</td>
<td>$rslt->frm_city_name</td>
<td>$rslt->to_city_name</td>
<td>$rslt->bus_count</td>
<td>$rslt->pax</td>
<td>$rslt->trip_days</td>
<td>$rslt->trip_type_name</td>
<td>$referral_type</td>
<td>$rslt->booking_type_name</td>
<td>$rslt->vehicle_no</td>
<td>$rslt->veh_type</td>
<td>$rslt->vendor_name</td>
<td>$rslt->book_amount</td>
<td>$rslt->cat_amt</td>
<td>$rslt->stay_amt</td>
<td>$rslt->adv_amt</td>
<td>$rslt->paid_tot</td>
<td>$rslt->dis_amt</td>
<td>$rslt->tax_precentage</td>
<td>$rslt->bal_amt</td>
<td>$rslt->op_driver_name</td>
<td>$rslt->op_driver_number</td>
<td>$suspence_amt</td>
<td>$driver_suspence_amount</td>
<td>$rslt->diesel_amt</td>
<td>$referred_by</td>
<td>$rslt->remark</td>
<td>$rslt->avg_km</td>
<td>$rslt->report_address</td>
<td>$rslt->landmark</td>
<td>$rslt->trip_details</td>
<td>$toll</td>
<td>$parking</td>
<td>$driver_batta</td>
<td>$state_tax</td>
<td>$catering</td>
<td>$operation_type</td>
<td>$rslt->tp_info</td>
<td>$reporting_time Hrs</td>
<td>$shed_out_time Hrs</td>
<td>$rslt->trip_start_km</td>
<td>$rslt->trip_end_km</td>
<td>$rslt->op_extra_km</td>
<td>$rslt->op_extra_pre_km</td>
<td>$rslt->op_extra_amt</td>
<td>$payment_type</td>
<td>$status</td>
<td style='white-space:nowrap;'>$created_date</td>
</tr>";
}else
if($table_name === "accounts"){
$payment_type = str_replace("_"," ",$rslt->payment_type);
$toll = "NO";
if($rslt->toll === "1"){
$toll = "Yes";
}
$parking = "NO";
if($rslt->parking === "1"){
$parking = "Yes";
}
$driver_batta = "NO";
if($rslt->driver_batta === "1"){
$driver_batta = "Yes";
}
$state_tax = "NO";
if($rslt->state_tax === "1"){
$state_tax = "Yes";
}
$catering = "Non package";
if($rslt->catering === "1"){
$catering = "Package";
}
$operation_type = "Only Driver";
if($rslt->operation_type === "1"){
$operation_type = "Vehicle with driver";
}
$reporting_time = date("G:i", strtotime($rslt->reporting_time));
$shed_out_time = date("G:i", strtotime($rslt->shed_out_time));
$suspence_amt = $rslt->suspence_amt + $rslt->op_suspence_amt;
$driver_suspence_amount = $rslt->driver_suspence_amount;
$tr_line .= "<tr>
<td>$rslt->customer_name</td>
<td>$rslt->billing_name</td>
<td>$rslt->phone_number</td>
<td>$rslt->tour_no</td>
<td style='white-space:nowrap;'>$from_date</td>
<td style='white-space:nowrap;'>$to_date</td>
<td>$rslt->frm_city_name</td>
<td>$rslt->to_city_name</td>
<td>$rslt->bus_count</td>
<td>$rslt->pax</td>
<td>$rslt->trip_days</td>
<td>$rslt->trip_type_name</td>
<td>$referral_type</td>
<td>$rslt->booking_type_name</td>
<td>$rslt->vehicle_no</td>
<td>$rslt->veh_type</td>
<td>$rslt->vendor_name</td>
<td>$rslt->book_amount</td>
<td>$rslt->cat_amt</td>
<td>$rslt->stay_amt</td>
<td>$rslt->adv_amt</td>
<td>$rslt->paid_tot</td>
<td>$rslt->dis_amt</td>
<td>$rslt->tax_precentage</td>
<td>$rslt->bal_amt</td>
<td>$rslt->op_driver_name</td>
<td>$rslt->op_driver_number</td>
<td>$suspence_amt</td>
<td>$driver_suspence_amount</td>
<td>$rslt->diesel_amt</td>
<td>$referred_by</td>
<td>$rslt->remark</td>
<td>$rslt->avg_km</td>
<td>$rslt->report_address</td>
<td>$rslt->landmark</td>
<td>$rslt->trip_details</td>
<td>$toll</td>
<td>$parking</td>
<td>$driver_batta</td>
<td>$state_tax</td>
<td>$catering</td>
<td>$operation_type</td>
<td>$rslt->tp_info</td>
<td>$reporting_time Hrs</td>
<td>$shed_out_time Hrs</td>
<td>$rslt->trip_start_km</td>
<td>$rslt->trip_end_km</td>
<td>$rslt->op_extra_km</td>
<td>$rslt->op_extra_pre_km</td>
<td>$rslt->op_extra_amt</td>
<td>$payment_type</td>
<td>$status</td>
<td style='white-space:nowrap;'>$created_date</td>
</tr>";
}
}
if($table_name === "enquiry"){
$th_line = "<tr>
<th class='search_th'>Customer Name</th>
<th class='search_th'>Mobile</th>
<th class='search_th'>From</th>
<th class='search_th'>To</th>
<th class='search_th'>Origin</th>
<th class='search_th'>Destination</th>
<th class='search_th'>Vehicle Count</th>
<th class='search_th'>Pax</th>
<th class='search_th'>Days</th>
<th class='search_th'>Amount</th>
<th class='search_th'>Trip Type</th>
<th class='search_th'>Referral Type</th>
<th class='search_th'>Customer Type</th>
<th class='search_th'>Vehicle Type</th>
<th class='search_th'>Referred By</th>
<th class='search_th'>Remark</th>
<th class='search_th'>Avg KM</th>
<th class='search_th'>Billing Name</th>
<th class='search_th'>Report Address</th>
<th class='search_th'>Landmark</th>
<th class='search_th'>Cancel Reson</th>
<th class='search_th'>Trip Details</th>
<th class='search_th'>NCD</th>
<th class='search_th'>Status</th>
<th class='search_th'>Created On</th>
</tr>";
}else
if($table_name === "booking"){
$th_line = "<tr>
<th class='search_th'>Customer Name</th>
<th class='search_th'>Mobile</th>
<th class='search_th'>Tour NO</th>
<th class='search_th'>From</th>
<th class='search_th'>To</th>
<th class='search_th'>Origin</th>
<th class='search_th'>Destination</th>
<th class='search_th'>Vehicle Count</th>
<th class='search_th'>Pax</th>
<th class='search_th'>Days</th>
<th class='search_th'>Trip Type</th>
<th class='search_th'>Referral Type</th>
<th class='search_th'>Customer Type</th>
<th class='search_th'>Vehicle Type</th>
<th class='search_th'>Referred By</th>
<th class='search_th'>Remark</th>
<th class='search_th'>Avg KM</th>
<th class='search_th'>Billing Name</th>
<th class='search_th'>Report Address</th>
<th class='search_th'>Landmark</th>
<th class='search_th'>Cancel Reson</th>
<th class='search_th'>Trip Details</th>
<th class='search_th'>Toll</th>
<th class='search_th'>Parking</th>
<th class='search_th'>Driver Batta</th>
<th class='search_th'>State Tax</th>
<th class='search_th'>Package</th>
<th class='search_th'>Operation Type</th>
<th class='search_th'>TP</th>
<th class='search_th'>Reporting time</th>
<th class='search_th'>Shed out time</th>
<th class='search_th'>Booking Amount</th>
<th class='search_th'>Catering Amount</th>
<th class='search_th'>Stay Amount</th>
<th class='search_th'>Advance Amount</th>
<th class='search_th'>Paid Amount</th>
<th class='search_th'>Discount Amount</th>
<th class='search_th'>Tax Precentage</th>
<th class='search_th'>Balance Amount</th>
<th class='search_th'>Payment Type</th>
<th class='search_th'>Status</th>
<th class='search_th'>Created On</th>
</tr>";
}else
if($table_name === "operation"){
$th_line = "<tr>
<th class='search_th'>Customer Name</th>
<th class='search_th'>Billing Name</th>
<th class='search_th'>Mobile</th>
<th class='search_th'>Tour NO</th>
<th class='search_th'>From</th>
<th class='search_th'>To</th>
<th class='search_th'>Origin</th>
<th class='search_th'>Destination</th>
<th class='search_th'>Vehicle Count</th>
<th class='search_th'>Pax</th>
<th class='search_th'>Days</th>
<th class='search_th'>Trip Type</th>
<th class='search_th'>Referral Type</th>
<th class='search_th'>Customer Type</th>
<th class='search_th'>Vehicle No</th>
<th class='search_th'>Vehicle Type</th>
<th class='search_th'>Travels</th>
<th class='search_th'>Booking Amount</th>
<th class='search_th'>Catering Amount</th>
<th class='search_th'>Stay Amount</th>
<th class='search_th'>Advance Amount</th>
<th class='search_th'>Paid Amount</th>
<th class='search_th'>Discount Amount</th>
<th class='search_th'>Tax Precentage</th>
<th class='search_th'>Balance Amount</th>
<th class='search_th'>Driver Name</th>
<th class='search_th'>Driver Mobile</th>
<th class='search_th'>Suspense Amount</th>
<th class='search_th'>Diesel Amount</th>
<th class='search_th'>Driver Suspense</th>
<th class='search_th'>Referred By</th>
<th class='search_th'>Remark</th>
<th class='search_th'>Avg KM</th>
<th class='search_th'>Report Address</th>
<th class='search_th'>Landmark</th>
<th class='search_th'>Trip Details</th>
<th class='search_th'>Toll</th>
<th class='search_th'>Parking</th>
<th class='search_th'>Driver Batta</th>
<th class='search_th'>State Tax</th>
<th class='search_th'>Package</th>
<th class='search_th'>Operation Type</th>
<th class='search_th'>TP</th>
<th class='search_th'>Reporting time</th>
<th class='search_th'>Shed out time</th>
<th class='search_th'>Start KM</th>
<th class='search_th'>End KM</th>
<th class='search_th'>Extra KM</th>
<th class='search_th'>Extra Per KM Amount</th>
<th class='search_th'>Extra Amount</th>
<th class='search_th'>Payment Type</th>
<th class='search_th'>Status</th>
<th class='search_th'>Created On</th>
</tr>";
}else
if($table_name === "accounts"){
$th_line = "<tr>
<th class='search_th'>Customer Name</th>
<th class='search_th'>Billing Name</th>
<th class='search_th'>Mobile</th>
<th class='search_th'>Tour NO</th>
<th class='search_th'>From</th>
<th class='search_th'>To</th>
<th class='search_th'>Origin</th>
<th class='search_th'>Destination</th>
<th class='search_th'>Vehicle Count</th>
<th class='search_th'>Pax</th>
<th class='search_th'>Days</th>
<th class='search_th'>Trip Type</th>
<th class='search_th'>Referral Type</th>
<th class='search_th'>Customer Type</th>
<th class='search_th'>Vehicle No</th>
<th class='search_th'>Vehicle Type</th>
<th class='search_th'>Travels</th>
<th class='search_th'>Booking Amount</th>
<th class='search_th'>Catering Amount</th>
<th class='search_th'>Stay Amount</th>
<th class='search_th'>Advance Amount</th>
<th class='search_th'>Paid Amount</th>
<th class='search_th'>Discount Amount</th>
<th class='search_th'>Tax Precentage</th>
<th class='search_th'>Balance Amount</th>
<th class='search_th'>Driver Name</th>
<th class='search_th'>Driver Mobile</th>
<th class='search_th'>Suspense Amount</th>
<th class='search_th'>Diesel Amount</th>
<th class='search_th'>Driver Suspense</th>
<th class='search_th'>Referred By</th>
<th class='search_th'>Remark</th>
<th class='search_th'>Avg KM</th>
<th class='search_th'>Report Address</th>
<th class='search_th'>Landmark</th>
<th class='search_th'>Trip Details</th>
<th class='search_th'>Toll</th>
<th class='search_th'>Parking</th>
<th class='search_th'>Driver Batta</th>
<th class='search_th'>State Tax</th>
<th class='search_th'>Package</th>
<th class='search_th'>Operation Type</th>
<th class='search_th'>TP</th>
<th class='search_th'>Reporting time</th>
<th class='search_th'>Shed out time</th>
<th class='search_th'>Start KM</th>
<th class='search_th'>End KM</th>
<th class='search_th'>Extra KM</th>
<th class='search_th'>Extra Per KM Amount</th>
<th class='search_th'>Extra Amount</th>
<th class='search_th'>Payment Type</th>
<th class='search_th'>Status</th>
<th class='search_th'>Created On</th>
</tr>";
}
$table_info = "<style>.search_th{color: #ffffff;background-color: #d84f57 !important;}</style>
<table class='table table-bordered table-hover table-striped' id='analysis_tbl'>
<thead>
$th_line
</thead>
<tbody>
$tr_line
</tbody>
</table>";
echo "$table_info";
}
}
?>