File: /home/cafsindia/allyindian_com/sbltt/application/controllers/Pk_cust_report.php
<?php if ( ! defined('BASEPATH')) exit('No direct script is allowed');
require_once("Secure_Controller.php");
class Pk_cust_report extends Secure_Controller{
public function __construct(){
parent::__construct('pk_cust_report');
$this->load->model('Pk_cust_report_model');
}
public function index(){
if(!$this->Appconfig->isAppvalid()){
redirect('config');
}
$data['table_headers'] = $this->xss_clean(get_pk_cust_report_headers());
$data['package_list'] = $this->Pk_cust_report_model->get_package();
$this->load->view('pk_cust_report/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');
$filters = array('start_date' => $this->input->get('start_date'),'end_date' => $this->input->get('end_date'));
$package_list = $this->Pk_cust_report_model->get_package();
foreach($package_list as $package){
$package_name = $package->package_name;
$filters[$package_name] = false;
}
$filledup = array_fill_keys($this->input->get('filters'), TRUE);
$filters = array_merge($filters, $filledup);
$trip_wise=$this->Pk_cust_report_model->search($search,$filters,$limit,$offset,$sort,$order);
$TotalRows=$this->Pk_cust_report_model->get_found_rows($search,$filters);
$DataRows=array();
foreach ($trip_wise->result() as $person){
$DataRows[]=get_pk_cust_report_datarows($person,$this);
}
$DataRows=$this->xss_clean($DataRows);
echo json_encode(array('total'=>$TotalRows,'rows'=>$DataRows));
}
public function excel($start_date, $end_date){
$this->load->library('excel');
$obj = new Excel();
// Add new sheet
$objWorkSheet = $obj->createSheet(0); //Setting index when creating
$obj->setActiveSheetIndex(0); //First sheet open in excel sheet
//Write cells head column name
$objWorkSheet->setCellValue('A1', 'Si.No')
->setCellValue('B1', 'Customer Name')
->setCellValue('C1', 'Customer Mobile')
->setCellValue('D1', 'Customer Address')
->setCellValue('E1', 'Email')
->setCellValue('F1', 'Package Name')
->setCellValue('G1', 'From Date')
->setCellValue('H1', 'To Date')
->setCellValue('I1', 'Pickup Point')
->setCellValue('J1', 'PNR')
->setCellValue('K1', 'Seat No')
->setCellValue('L1', 'Sourcing')
->setCellValue('M1', 'Amount')
->setCellValue('N1', 'Discount')
->setCellValue('O1', 'Balance')
->setCellValue('P1', 'Feedback')
->setCellValue('Q1', 'Payment Type')
->setCellValue('R1', 'Status');
/*->setCellValueS('Q1', 'Vehicle No')
->setCellValue('R1', 'Tp info')
->setCellValue('S1', 'Vehicle No')
->setCellValue('T1', 'Ref By')
->setCellValue('U1', 'Travels Name')
->setCellValue('V1', 'Start KM')
->setCellValue('W1', 'End KM')
->setCellValue('X1', 'Total KM')
->setCellValue('Y1', 'Booking Amount')
->setCellValue('Z1', 'Receipt')
->setCellValue('AA1', 'Catering Amount')
->setCellValue('AB1', 'Stay Amount')
->setCellValue('AC1', 'Discount Amount')
->setCellValue('AD1', 'Extra KM')
->setCellValue('AE1', 'Extra Amount')
->setCellValue('AF1', 'Tax Percentage')
->setCellValue('AG1', 'Hire Charge')
->setCellValue('AH1', 'Balance Amount')
->setCellValue('AI1', 'Status');*/
// set database value
$data = $this->Pk_cust_report_model->excel_package_type_report($start_date, $end_date);
//print_r($data); die;
$i=2;
$k=1;
foreach ($data as $key => $value) {
$serial = $k;
$from_date = date('d-m-Y', strtotime($value['from_date']));
$to_date = date('d-m-Y', strtotime($value['to_date']));
$name = $value['customer_name'];
$mob = $value['phone_number'];
$origin = $value['frm_city_name'];
$destination = $value['to_city_name'];
$trip_days = $value['trip_days'];
$bus_count = $value['bus_count'];
$tour_no = $value['tour_no'];
$report_address = $value['report_address'];
$billing_name = $value['billing_name'];
$avg_km = $value['avg_km'];
$trip_type_name = $value['trip_type_name'];
$veh_type = $value['veh_type'];
$type = $value['booking_type_name'];
$trip_details = $value['trip_details'];
$operation_type = $value['operation_type'];
$booking_amount = $value['booking_amount'];
$advance_amount = $value['advance_amount'];
$balance_amount = $value['balance_amount'];
$discount_amount = $value['discount_amount'];
$op_suspence_amt = $value['op_suspence_amt'];
$hire_charges = $value['hire_charges'];
$op_driver_name = $value['op_driver_name'];
$vehicle_no = $value['vehicle_no'];
$operation_sts = $value['operation_sts'];
$first_name = $value['first_name'];
$tp_info = $value['tp_info'];
$stay_tot_amt = $value['stay_tot_amt'];
$trip_start_km = $value['trip_start_km'];
$trip_end_km = $value['trip_end_km'];
$extra_km = $value['extra_km'];
$extra_amt = $value['extra_amt'];
$tax_precentage = $value['tax_precentage'];
$catering_amount = $value['catering_amount'];
$package_sts = $value['package_sts'];
$enquiry_sts = $value['enquiry_sts'];
$pnr = $value['pnr'];
$seat = $value['package_sts'];
$package_name = $value['package_name'];
$pickup_point = $value['pickup_point'];
$discount = $value['discount'];
$amount = $value['amount'];
$balance = $value['balance'];
$payment_type = $value['payment_type'];
$sourcing = $value['sourcing'];
$feedback = $value['feedback'];
$feed_vehicle = $value['feed_vehicle'];
$driving_driver = $value['driving_driver'];
$feed_food = $value['feed_food'];
$feed_accomodation = $value['feed_accomodation'];
$feed_overall = $value['feed_overall'];
$cust_email = $value['cust_email'];
$cust_address = $value['cust_address'];
if($enquiry_sts === "1"){
$enquiry_sts = "Pending";
}else
if($enquiry_sts === "2"){
$enquiry_sts = "Confirm";
}else
if($enquiry_sts === "3"){
$enquiry_sts = "Cancelled";
}
$objWorkSheet->setCellValue('A'.$i, $serial)
->setCellValue('B'.$i, $name)
->setCellValue('C'.$i, $mob)
->setCellValue('D'.$i, $cust_address)
->setCellValue('E'.$i, $email)
->setCellValue('F'.$i, $package_name)
->setCellValue('G'.$i, $from_date)
->setCellValue('H'.$i, $to_date)
->setCellValue('I'.$i, $pickup_point)
->setCellValue('J'.$i, $pnr)
->setCellValue('K'.$i, $seat)
->setCellValue('L'.$i, $sourcing)
->setCellValue('M'.$i, $amount)
->setCellValue('N'.$i, $discount)
->setCellValue('O'.$i, $balance)
->setCellValue('P'.$i, $feedback)
->setCellValue('Q'.$i, $payment_type)
->setCellValue('R'.$i, $enquiry_sts);
/*->setCellValue('Q'.$i, $operation_type)
->setCellValue('R'.$i, $tp_info)
->setCellValue('S'.$i, $vehicle_no)
->setCellValue('T'.$i, $first_name)
->setCellValue('U'.$i, $vendor_name)
->setCellValue('V'.$i, $trip_start_km)
->setCellValue('W'.$i, $trip_end_km)
->setCellValue('X'.$i, $total_km)
->setCellValue('Y'.$i, $booking_amount)
->setCellValue('Z'.$i, $advance_amount)
->setCellValue('AA'.$i, $catering_amount)
->setCellValue('AB'.$i, $stay_tot_amt)
->setCellValue('AC'.$i, $discount_amount)
->setCellValue('AD'.$i, $extra_km)
->setCellValue('AE'.$i, $extra_amt)
->setCellValue('AF'.$i, $tax_precentage)
->setCellValue('AG'.$i, $hire_charges)
->setCellValue('AH'.$i, $balance_amount)
->setCellValue('AI'.$i, $operation_sts);
->setCellValue('AJ'.$i, $extra_amt);
->setCellValue('AB'.$i, $stay_tot_amt)
->setCellValue('AF'.$i, $amount);*/
$k++;
$i++;
}
// Rename worksheet name
$objWorkSheet->setTitle("Detailed");
$filename="Package Report_".date('d-m-Y').".xls"; //save our workbook as this file name
header('Content-Type: application/vnd.ms-excel'); //mime type
header('Content-Disposition: attachment;filename="'.$filename.'"'); //tell browser what's the file name
header('Cache-Control: max-age=0'); //no cache
//save it to Excel5 format (excel 2003 .XLS file), change this to 'Excel2007' (and adjust the filename extension, also the header mime type)
//if you want to save it as .XLSX Excel 2007 format
$objWriter = PHPExcel_IOFactory::createWriter($obj, 'Excel5');
//force user to download the Excel file without writing it to server's HD
$objWriter->save('php://output');
}
}
?>