File: /home/cafsindia/allyindian_com/sbltt/application/helpers/table_helper.php
<?php
function transform_headers_readonly($array){
$result = array();
foreach($array as $key => $value)
{
$result[] = array('field' => $key, 'title' => $value, 'sortable' => $value != '', 'switchable' => !preg_match('(^$| )', $value));
}
return json_encode($result);
}
function transform_headers($array){
$result = array();
$array = array_merge(array(array('checkbox' => 'select', 'sortable' => FALSE)),
$array, array(array('edit' => '')));
foreach($array as $element)
{
$result[] = array('field' => key($element),
'title' => current($element),
'switchable' => isset($element['switchable']) ?
$element['switchable'] : !preg_match('(^$| )', current($element)),
'sortable' => isset($element['sortable']) ?
$element['sortable'] : current($element) != '',
'checkbox' => isset($element['checkbox']) ?
$element['checkbox'] : FALSE,
'class' => isset($element['checkbox']) || preg_match('(^$| )', current($element)) ?
'print_hide' : '');
}
return json_encode($result);
}
function get_people_manage_table_headers(){
$CI =& get_instance();
$headers = array(
//array('cust_id' => $CI->lang->line('common_id')),
array('customer_name' => $CI->lang->line('common_cust_name')),
array('cust_address' => $CI->lang->line('common_cust_address')),
array('cust_email' => $CI->lang->line('common_email')),
array('phone_number' => $CI->lang->line('common_phone_number')),
array('cust_type' => "Type"),
array('dob' => "DOB"),
array('allow_contract' => "Contract")
);
return transform_headers($headers);
}
function get_person_data_row($person, $controller){
$CI =& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'cust_id' => $person->cust_id,
'customer_name' => $person->customer_name,
'cust_address' => $person->cust_address,
'cust_email' => empty($person->cust_email) ? '' : mailto($person->cust_email, $person->cust_email),
'phone_number' => $person->phone_number,
'cust_type' => $person->booking_type_name,
'dob' => date('d-m-Y',strtotime($person->dob)),
'allow_contract' => $person->allow_contract,
'edit' => anchor($controller_name."/view/$person->cust_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
));
}
function get_employee_manage_table_headers(){
$CI =& get_instance();
$headers = array(
//array('people.person_id' => "S No"),
array('username' => "Employee ID"),
array('created_on' => "Date Of Joining"),
array('first_name' => $CI->lang->line('common_first_name')),
array('last_name' => $CI->lang->line('common_last_name')),
array('email' => $CI->lang->line('common_email')),
array('phone_number' => $CI->lang->line('common_phone_number'))
);
if($CI->Employee->has_grant('messages', $CI->session->userdata('person_id'))){
$headers[] = array('messages' => '', 'sortable' => FALSE);
}
return transform_headers($headers);
}
function get_employee_data_row($person, $controller){
$CI =& get_instance();
$controller_name=strtolower(get_class($CI));
$created_on = date("jS M, Y", strtotime($person->join_date));
return array (
'people.person_id' => $person->person_id,
'username' => $person->username,
'created_on' => $created_on,
'first_name' => $person->first_name,
'last_name' => $person->last_name,
'email' => empty($person->email) ? '' : mailto($person->email, $person->email),
'phone_number' => $person->phone_number,
'messages' => empty($person->phone_number) ? '' : anchor("Messages/view/$person->person_id", '<span class="glyphicon glyphicon-phone"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line('messages_sms_send'))),
'edit' => anchor($controller_name."/view/$person->person_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
));
}
function GetBranchTableHeaders()
{
$CI=& get_instance();
$headers=array(
// array('branch_id'=>"Branch ID"),
array('branch_code'=>"Code"),
array('branch_name'=>"Name"),
array('branch_mob'=>"Mobile #"),
array('branch_address'=>"Address"),
array('branch_desc'=>"Description"),
);
return transform_headers($headers);
}
function GetBranchDataRows($person,$controller)
{
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'branch_id' => $person->branch_id,
'branch_code' => $person->branch_code,
'branch_name' => $person->branch_name,
'branch_mob' => $person->branch_mob,
'branch_address' => $person->branch_address,
'branch_desc' => $person->branch_desc,
'edit' => anchor($controller_name."/view/$person->branch_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
));
}
function get_veh_category_headers(){
$CI=& get_instance();
$headers=array(
// array('id'=>"ID"),
array('veh_category'=>"Vehicle Category"));
return transform_headers($headers);
}
function get_veh_category_datarows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'id' => $person->veh_cat_id,
'veh_category' => $person->veh_category,
'edit' => anchor($controller_name."/view/$person->veh_cat_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
));
}
function get_veh_type_headers(){
$CI=& get_instance();
$headers=array(
// array('id'=>"ID"),
array('veh_category'=>"Vehicle Category"),
array('veh_type'=>"Vehicle type"));
return transform_headers($headers);
}
function get_veh_type_datarows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'id' => $person->veh_type_id,
'veh_category' => $person->veh_category,
'veh_type' => $person->veh_type,
'edit' => anchor($controller_name."/view/$person->veh_type_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
));
}
function get_trip_type_headers(){
$CI=& get_instance();
$headers=array(
//array('id'=>"ID"),
array('trip_basis'=>"Trip Basis"),
array('trip_type_name'=>"Trip Type"));
return transform_headers($headers);
}
function get_trip_type_datarows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'id' => $person->trip_type_id,
'trip_basis' => $person->trip_basis,
'trip_type_name' => $person->trip_type_name,
'edit' => anchor($controller_name."/view/$person->trip_type_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
));
}
function get_permit_type_headers(){
$CI=& get_instance();
$headers=array(
//array('id'=>"ID"),
array('permit_type_name'=>"Permit"));
return transform_headers($headers);
}
function get_permit_type_datarows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'id' => $person->permit_type_id,
'permit_type_name' => $person->permit_type_name,
'edit' => anchor($controller_name."/view/$person->permit_type_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
));
}
function get_booking_type_headers(){
$CI=& get_instance();
$headers=array(
//array('id'=>"ID"),
array('booking_type_name'=>"Booking Type"));
return transform_headers($headers);
}
function get_booking_type_datarows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'id' => $person->booking_type_id,
'booking_type_name' => $person->booking_type_name,
'edit' => anchor($controller_name."/view/$person->booking_type_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
));
}
function get_demand_date_headers(){
$CI=& get_instance();
$headers=array(
//array('id'=>"ID"),
array('demand_month'=>"Demand Date"),
array('percentage'=>"Percentage"));
return transform_headers($headers);
}
function get_demand_date_datarows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'id' => $person->demand_date_id,
'demand_month' => date('F,Y',strtotime($person->demand_month)),
'percentage' => $person->percentage,
'edit' => anchor($controller_name."/view/$person->demand_date_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
));
}
function get_kickbacks_headers(){
$CI=& get_instance();
$headers=array(
//array('id'=>"ID"),
array('kick_state'=>"State"),
array('kick_city'=>"City"),
array('kick_amt'=>"Amount"));
return transform_headers($headers);
}
function get_kickbacks_datarows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'id' => $person->kick_id,
'kick_state' => $person->state_name,
'kick_city' => $person->kick_city,
'kick_amt' => $person->kick_amt,
'edit' => anchor($controller_name."/view/$person->kick_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
));
}
function get_rate_headers(){
$CI=& get_instance();
$headers=array(
//array('id'=>"ID"),
array('rate_vendor'=>"Vendor"),
array('rate_trip_type'=>"Trip Type"),
array('rate_vehicle_type'=>"Vehicle Type"),
array('upto_hrs'=>"Upto Hrs"),
array('upto_km'=>"Upto KM"),
array('upto_amt'=>"Upto Amount"),
array('extra_km_amt'=>"Pre KM Amount"),
array('extra_amt'=>"Extra Amount"));
return transform_headers($headers);
}
function get_rate_datarows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'id' => $person->rate_id,
'rate_vendor' => $person->vendor_name,
'rate_trip_type' => $person->trip_type_name,
'rate_vehicle_type' => $person->veh_type,
'upto_hrs' => $person->upto_hrs,
'upto_km' => $person->upto_km,
'upto_amt' => $person->upto_amt,
'extra_km_amt' => $person->extra_km_amt,
'extra_amt' => $person->extra_amt,
'edit' => anchor($controller_name."/view/$person->rate_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
));
}
function get_enquiry_headers(){
$CI=& get_instance();
$headers=array(
array('id'=>"ID"),
array('customer_name'=>"Name"),
array('phone_number'=>"Mobile#"),
array('bus_count'=>"Count"),
array('from_date'=>"From Date"),
array('to_date'=>"To Date"),
array('orgin'=>"Origin"),
array('destination'=>"Destination"),
array('trip_type'=>"Trip"),
array('vehicle_type'=>"Vehicle"),
array('booking_type_name'=>"Booking"),
array('ncd'=>"Call Date"),
array('enquiry_sts'=>"Status"),
array('quotation'=>""),
array('enquiry_log'=>""));
return transform_headers($headers);
}
function get_enquiry_datarows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
if($person->enquiry_sts === "1"){
$enquiry_sts = "Follow Up";
}else
if($person->enquiry_sts === "2"){
$enquiry_sts = "Confirm";
}else
if($person->enquiry_sts === "3"){
$enquiry_sts = "Cancelled";
}
if($person->prospect === "1"){
$prospect = "Hot";
}else
if($person->prospect === "2"){
$prospect = "Warm";
}else
if($person->prospect === "3"){
$prospect = "Dropped";
}
return array (
'id' => $person->enquiry_id,
'customer_name' => $person->customer_name,
'phone_number' => $person->phone_number,
'bus_count' => $person->bus_count,
'booking_type_name' => $person->booking_type_name,
'orgin' => $person->frm_city_name,
'destination' => $person->to_city_name,
'from_date' => date('d-m-Y',strtotime($person->from_date)),
'to_date' => date('d-m-Y',strtotime($person->to_date)),
'trip_type' => $person->trip_type_name,
'vehicle_type' => $person->veh_type,
'enquiry_sts' => $enquiry_sts,
'ncd' => date('d-m-Y',strtotime($person->ncd)),
//'prospect' => $prospect,
//'trip_details' => $person->trip_details,
'edit' => anchor($controller_name."/view/$person->enquiry_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))),
'quotation' => anchor($controller_name."/quotation/$person->enquiry_id", '<span class="fa fa-print fa-lg"></span>',array( 'title'=>'Print Quotation')),
'enquiry_log' => anchor($controller_name."/enquiry_log/$person->enquiry_id", '<span class="fa fa-book fa-lg"></span>',
array('class'=>'modal-dlg', 'title'=>"Enquiry History")),
);
}
//reporting_time @GS @ 19june2018
function get_booking_headers(){
$CI=& get_instance();
$headers=array(
//array('id'=>"ID"),
array('tour_no'=>"Tour #"),
array('customer_name'=>"Name"),
array('phone_number'=>"Mobile#"),
array('bus_count'=>"Count"),
array('from_date'=>"From Date"),
array('to_date'=>"To Date"),
array('reporting_time'=>"Rep. Time"),
array('orgin'=>"Origin"),
array('destination'=>"Destination"),
array('trip_type'=>"Trip"),
array('vehicle_type'=>"Vehicle"),
array('booking_type_name'=>"Booking"),
array('booking_sts'=>"Status"),
array('balance_amount'=>"Balance"),
array('sms'=>""),
array('email'=>""),
array('catering'=>""),
array('print'=>""),
array('balance_log'=>""),
array('booking_log'=>""));
return transform_headers($headers);
}
//reporting_time @GS @ 19june2018
function get_booking_datarows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
if($person->booking_sts === "1"){
$booking_sts = "Follow Up";
}else
if($person->booking_sts === "2"){
$booking_sts = "Confirm";
}else
if($person->booking_sts === "3"){
$booking_sts = "Cancelled";
}else
if($person->booking_sts === "4"){
$booking_sts = "Completed";
}else
if($person->booking_sts === "5"){
$booking_sts = "On Progress";
}
$catering = "";
if($person->catering === "1"){
$catering = anchor($controller_name."/update_catering/$person->booking_id", '<span class="fa fa-coffee fa-lg"></span>',
array('class'=>'modal-dlg', 'title'=>"Update Catering"));
}
$balance_log = anchor($controller_name."/balance_log/$person->booking_id", '<span class="fa fa-inr fa-lg"></span>',
array('class'=>'modal-dlg', 'title'=>"Add Balance"));
return array (
'id' => $person->booking_id,
'tour_no' => $person->tour_no,
'customer_name' => $person->customer_name,
'phone_number' => $person->phone_number,
'bus_count' => $person->bus_count,
'booking_type_name' => $person->booking_type_name,
'orgin' => $person->frm_city_name,
'destination' => $person->to_city_name,
'from_date' => date('d-m-Y',strtotime($person->from_date)),
'to_date' => date('d-m-Y',strtotime($person->to_date)),
'reporting_time' => date("H:i", strtotime($person->reporting_time)).' Hrs',
'trip_type' => $person->trip_type_name,
'vehicle_type' => $person->veh_type,
'booking_sts' => $booking_sts,
'balance_amount' => $person->balance_amount,
'edit' => anchor($controller_name."/view/$person->booking_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))),
'balance_log' => $balance_log,
'print' => anchor($controller_name."/print_booking/$person->booking_id", '<span class="fa fa-print fa-lg"></span>',array( 'title'=>'Print Booking Sheet')),
'catering' => $catering,
'sms' => anchor($controller_name."/resend_sms/$person->booking_id", '<span class="fa fa-mobile fa-2x"></span>',array('class'=>'modal-dlg','title'=>'Resend SMS')),
'email' => anchor($controller_name."/resend_email/$person->booking_id", '<span class="fa fa-envelope fa-lg"></span>',array('class'=>'modal-dlg','title'=>'Resend Email')),
'booking_log' => anchor($controller_name."/booking_log/$person->booking_id", '<span class="fa fa-book fa-lg"></span>',array('class'=>'modal-dlg','title'=>'Booking History')),
);
}
function get_operation_headers(){
$CI=& get_instance();
$headers=array(
//array('id'=>"ID"),
array('tour_no'=>"Tour #"),
array('customer_name'=>"Name"),
array('phone_number'=>"Mobile#"),
array('bus_count'=>" Count"),
array('from_date'=>"From Date"),
array('to_date'=>"To Date"),
array('orgin'=>"Origin"),
array('destination'=>"Destination"),
array('trip_type'=>"Trip"),
array('vehicle_type'=>"Vehicle"),
array('booking_type_name'=>"Booking"),
array('reporting_time'=>"Rep Time"),
//array('op_driver_name'=>"Drives"),
array('vehicle_list'=>"Assigned"),
array('operation_sts'=>"Status"),
array('balance_amount'=>"Balance"),
array('print'=>""));
return transform_headers($headers);
}
function get_operation_datarows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
if($person->operation_sts === "1"){
$operation_sts = "Follow Up";
}else
if($person->operation_sts === "2"){
$operation_sts = "Confirm";
}else
if($person->operation_sts === "3"){
$operation_sts = "Cancelled";
}else
if($person->operation_sts === "4"){
$operation_sts = "Completed";
}else
if($person->operation_sts === "5"){
$operation_sts = "On Progress";
}
$reporting_time = date("G:i", strtotime($person->reporting_time)).' '.'Hrs';
return array (
'id' => $person->operation_id,
'tour_no' => $person->tour_no,
'customer_name' => $person->customer_name,
'phone_number' => $person->phone_number,
'bus_count' => $person->bus_count,
'booking_type_name' => $person->booking_type_name,
'orgin' => $person->frm_city_name,
'destination' => $person->to_city_name,
'from_date' => date('d-m-Y',strtotime($person->from_date)),
'to_date' => date('d-m-Y',strtotime($person->to_date)),
'trip_type' => $person->trip_type_name,
'vehicle_type' => $person->veh_type,
//'op_driver_name' => $person->op_driver_name,
'reporting_time' => $reporting_time,
'vehicle_list' => $person->vehicle_list,
'operation_sts' => $operation_sts,
'balance_amount' => $person->balance_amount,
'edit' => anchor($controller_name."/view/$person->operation_id", '<span class="fa fa-pencil-square-o"></span>',array('class'=>'modal-dlg', 'title'=>$CI->lang->line($controller_name.'_update'))),
);
}
function get_accounts_headers(){
$CI=& get_instance();
$headers=array(
//array('id'=>"ID"),
array('inv_number'=>"Invoice#"),
array('tour_no'=>"Tour#"),
array('customer_name'=>"Name"),
array('phone_number'=>"Mobile#"),
array('bus_count'=>"Count"),
array('from_date'=>"Trip Date"),
array('orgin'=>"Trip"),
array('booking_amount'=>"Hire"),
array('stayamt'=>"Hotel"),
array('foodamt'=>"Food"),
array('balance_amount'=>"Balance"),
array('includ_gst'=>"GST"),
array('operation_sts'=>"Operation"),
array('accounts_sts'=>"Status"),
array('cash_bill'=>""),
array('print'=>""),
array('balance_log'=>""));
return transform_headers($headers);
}
function get_accounts_datarows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
if($person->accounts_sts === "1"){
$accounts_sts = "Follow Up";
}else
if($person->accounts_sts === "2"){
$accounts_sts = "Confirm";
}else
if($person->accounts_sts === "3"){
$accounts_sts = "Cancelled";
}else
if($person->accounts_sts === "4"){
$accounts_sts = "Completed";
}else
if($person->accounts_sts === "5"){
$accounts_sts = "On Progress";
}
if($person->operation_sts === "1"){
$operation_sts = "Follow Up";
}else
if($person->operation_sts === "2"){
$operation_sts = "Confirm";
}else
if($person->operation_sts === "3"){
$operation_sts = "Cancelled";
}else
if($person->operation_sts === "4"){
$operation_sts = "Completed";
}else
if($person->operation_sts === "5"){
$operation_sts = "On Progress";
}
$balance_log = anchor($controller_name."/balance_log/$person->booking_id", '<span class="fa fa-inr fa-lg"></span>',
array('class'=>'modal-dlg', 'title'=>"Add Balance"));
$trip_place = "$person->frm_city_name to $person->to_city_name<br/>$person->trip_type_name<br/>$person->veh_type";
$from_date = date('d-m-Y',strtotime($person->from_date));
$to_date = date('d-m-Y',strtotime($person->to_date));
$trip_date = "$from_date <br/> $to_date";
$includ_gst = "-";
if($person->includ_gst === "1"){
$includ_gst = "GST";
}
return array (
'inv_number' => $person->inv_number,
'accounts_id' => $person->accounts_id,
'tour_no' => $person->tour_no,
'customer_name' => $person->customer_name,
'phone_number' => $person->phone_number,
'bus_count' => $person->bus_count,
'booking_type_name' => $person->booking_type_name,
'orgin' => $trip_place,
'from_date' => $trip_date,
'operation_sts' => $operation_sts,
'accounts_sts' => $accounts_sts,
'booking_amount' => $person->booking_amount,
'stayamt' => $person->stayamt,
'foodamt' => $person->foodamt,
'balance_amount' => $person->balance_amount,
'includ_gst' => $includ_gst,
'balance_log' => $balance_log,
'cash_bill' => anchor($controller_name."/print_cash_bill/$person->booking_id", '<span class="fa fa-money fa-lg"></span>',array( 'title'=>'Print cash bill')),
'print' => anchor($controller_name."/print_acccounts/$person->booking_id", '<span class="fa fa-print fa-lg"></span>',array( 'title'=>'Print GST Invoice')),
'edit' => anchor($controller_name."/view/$person->accounts_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))),
);
}
function get_city_headers(){
$CI=& get_instance();
$headers=array(
//array('id'=>"ID"),
array('city_name'=>"City Name"));
return transform_headers($headers);
}
function get_city_datarows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'id' => $person->city_id,
'city_name' => $person->city_name,
'edit' => anchor($controller_name."/view/$person->city_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
));
}
function get_supplier_headers(){
$CI=& get_instance();
$headers=array(
//array('id'=>"ID"),
array('supplier_code'=>"Code"),
array('supplier_name'=>"Name"),
array('supplier_mob'=>"Mobile #"),
array('supplier_pan'=>"PAN"),
array('supplier_gst'=>"GST"),
array('supplier_address'=>"Address"),
);
return transform_headers($headers);
}
function get_supplier_datarows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'id' => $person->supplier_id,
'supplier_code' => $person->supplier_code,
'supplier_name' => $person->supplier_name,
'supplier_mob' => $person->supplier_mob,
'supplier_pan' => $person->supplier_pan,
'supplier_gst' => $person->supplier_gst,
'supplier_address' => $person->supplier_address,
'supplier_remarks' => $person->supplier_remarks,
'edit' => anchor($controller_name."/view/$person->supplier_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
));
}
function get_average_km_headers(){
$CI=& get_instance();
$headers=array(
//array('id'=>"ID"),
array('frm_city'=>"From City"),
array('to_city'=>"To City"),
array('km'=>"KM"),
);
return transform_headers($headers);
}
function get_average_km_datarows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'id' => $person->average_km_id,
'frm_city' => $person->frm_city_name,
'to_city' => $person->to_city_name,
'km' => $person->km,
'edit' => anchor($controller_name."/view/$person->average_km_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
));
}
function get_catering_menu_headers(){
$CI=& get_instance();
$headers=array(
//array('id'=>"ID"),
array('name'=>"Name"),
array('menu'=>"Menu"),
);
return transform_headers($headers);
}
function get_catering_menu_datarows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'id' => $person->catering_menu_id,
'name' => $person->name,
'menu' => $person->menu,
'edit' => anchor($controller_name."/view/$person->catering_menu_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'title'=>$CI->lang->line($controller_name.'_update'))
));
}
function get_catering_headers(){
$CI=& get_instance();
$headers=array(
array('cat_out_id'=>"ID"),
array('customer_name'=>"Name"),
array('booking_type_name'=>"Customer Type"),
array('catering_type'=>"Type"),
array('from_date'=>"From Date"),
array('to_date'=>"To Date"),
array('days_count'=>"Days"),
array('tax_precentage'=>"Tax"),
array('pax'=>"Pax"),
array('catering_amount'=>"Amount"),
array('balance'=>"Balance"),
array('catering_sts'=>"Status"),
array('print'=>""),
array('balance_log'=>""),
array('catering_order'=>""),
);
return transform_headers($headers);
}
function get_catering_datarows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
if($person->catering_type === "1"){
$catering_type = "Over All Package";
}else
if($person->catering_type === "2"){
$catering_type = "Catering";
}
$catering_order = anchor($controller_name."/catering_info/$person->cat_out_id", '<span class="fa fa-coffee fa-lg"></span>',array('class'=>'modal-dlg', 'title'=>"Add Menu"));
$balance_log = anchor($controller_name."/balance_log/$person->cat_out_id", '<span class="fa fa-inr fa-lg"></span>',
array('class'=>'modal-dlg', 'title'=>"Add Balance"));
return array (
'cat_out_id' => $person->cat_out_id,
'customer_name' => $person->customer_name,
'booking_type_name' => $person->booking_type_name,
'catering_type' => $catering_type,
'from_date' => date('d-m-Y',strtotime($person->from_date)),
'to_date' => date('d-m-Y',strtotime($person->to_date)),
'days_count' => $person->days_count,
'tax_precentage' => $person->tax_precentage,
'pax' => $person->pax,
'catering_amount' => $person->catering_amount,
'balance' => $person->balance,
'catering_sts' => $person->catering_sts,
'print' => anchor($controller_name."/print_catering/$person->cat_out_id", '<span class="fa fa-print fa-lg"></span>',array( 'title'=>'Print Booking Sheet')),
'balance_log' => $balance_log,
'catering_order' => $catering_order,
'edit' => anchor($controller_name."/view/$person->cat_out_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>'Update Outside Catering')
));
}
function get_maintenance_headers(){
$CI=& get_instance();
$headers=array(
array('maintenance_id'=>"Job#"),
array('maintenance_date'=>"In Date"),
array('vehicle_no'=>"Vehicle#"),
array('maintenance_type'=>"Type"),
array('service_center'=>"Service Center"),
array('driver_name'=>"Driver"),
array('driver_number'=>"Mobile#"),
array('service_remarks'=>"Service"),
array('maintenance_remarks'=>"Remarks"),
//array('insurance_claim'=>"Claim"),
array('delivery_date'=>"Delivery on"),
array('delivery_amount'=>"Amount"),
array('service_print'=>""),
array('add_service'=>""),
array('main_print'=>""),
);
return transform_headers($headers);
}
function get_maintenance_datarows($person,$controller){
$CI=& get_instance();
if($person->maintenance_type === "1"){
$type = "Break Down";
}else
if($person->maintenance_type === "2"){
$type = "General Service";
}
$controller_name=strtolower(get_class($CI));
return array (
'maintenance_id' => $person->maintenance_id,
'maintenance_date' => date('d-m-Y',strtotime($person->maintenance_date)),
'vehicle_no' => $person->vehicle_no,
'maintenance_type' => $type,
'service_center' => $person->supplier_name,
'check_list' => $person->check_list,
'spare_weel' => $person->spare_weel,
'odometer_reading' => $person->odometer_reading,
'diesel_level' => $person->diesel_level,
'driver_name' => $person->name,
'driver_number' => $person->driver_number,
'insurance_claim' => $person->insurance_claim,
'delivery_date' => date('d-m-Y',strtotime($person->delivery_date)),
'delivery_amount' => $person->delivery_amount,
'service_remarks' => $person->service_remarks,
'maintenance_remarks' => $person->maintenance_remarks,
'edit' => anchor($controller_name."/view/$person->maintenance_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))),
'main_print' => anchor($controller_name."/main_print/$person->maintenance_id", '<span class="fa fa-print fa-lg"></span>',array( 'title'=>'Print job Sheet')),
'add_service' => anchor($controller_name."/add_service/$person->maintenance_id", '<span class="fa fa-plus fa-lg"></span>',
array('class'=>'modal-dlg', 'title'=>'Add Spare')),
'service_print' => anchor($controller_name."/service_print/$person->maintenance_id", '<span class="fa fa-print fa-lg"></span>',array( 'title'=>'Print Service Sheet')),
);
}
function get_package_headers(){
$CI=& get_instance();
$headers=array(
//array('id'=>"ID"),
array('package_name'=>"Name"),
array('from_date'=>"From date"),
array('to_date'=>"To date"),
array('trip_days'=>"Trip days"),
array('bus_count'=>"Bus Count"),
array('person_count'=>"Person Count"),
array('package_sts'=>"Status"),
array('add_package'=>""),
);
return transform_headers($headers);
}
function get_package_datarows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
if($person->package_sts === "1"){
$package_sts = "Pending";
}else
if($person->package_sts === "2"){
$package_sts = "Completed";
}else
if($person->package_sts === "3"){
$package_sts = "Cancelled";
}
return array (
'id' => $person->package_id,
'package_name' => $person->package_name,
'from_date' => date('d-m-Y',strtotime($person->from_date)),
'to_date' => date('d-m-Y',strtotime($person->to_date)),
'trip_days' => $person->trip_days,
'bus_count' => $person->bus_count,
'person_count' => $person->person_count,
'package_sts' => $package_sts,
'add_package' => anchor($controller_name."/add_package/$person->package_id", '<span class="fa fa-plus"></span>',
array('class'=>'modal-dlg', 'title'=>"Add Package Customer")),
'edit' => anchor($controller_name."/view/$person->package_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update')))
);
}
function get_temple_enquiry_headers(){
$CI=& get_instance();
$headers=array(
//array('id'=>"ID"),
array('temple_enquiry_id'=>"ID"),
array('cust_name'=>"Name"),
array('phone_number'=>"Mobile#"),
array('package_name'=>"Package"),
array('enquiry_date'=>"Date"),
array('enquiry_month'=>"Month"),
array('ticket_count'=>"Tickets"),
array('pickup_point'=>"Pickup Point"),
// array('discount'=>"Discount"),
array('sourcing'=>"sourcing"),
array('enquiry_sts'=>"Status"),
);
return transform_headers($headers);
}
function get_temple_enquiry_datarows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
if($person->enquiry_sts === "1"){
$enquiry_sts = "Pending";
}else
if($person->enquiry_sts === "2"){
$enquiry_sts = "Confirm";
}else
if($person->enquiry_sts === "3"){
$enquiry_sts = "Cancelled";
}
return array (
'temple_enquiry_id' => $person->temple_enquiry_id,
'cust_name' => $person->customer_name,
'phone_number' => $person->phone_number,
'package_name' => $person->package_name,
'enquiry_date' => date('d-m-Y',strtotime($person->enquiry_date)),
'enquiry_month' => $person->enquiry_month,
'ticket_count' => $person->ticket_count,
'pickup_point' => $person->pickup_point,
//'discount' => $person->discount,
'sourcing' => $person->sourcing,
'enquiry_sts' => $enquiry_sts,
'edit' => anchor($controller_name."/view/$person->temple_enquiry_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
));
}
function get_vendor_headers(){
$CI=& get_instance();
$headers=array(
//array('id'=>"ID"),
array('vendor_code'=>"Vendor Code"),
array('vendor_type'=>"Vendor Type"),
array('vendor_name'=>"Vendor Name"),
array('vendor_mob'=>"Mobile #"),
array('vendor_pan'=>"PAN"),
array('vendor_gst'=>"GST"),
array('vendor_address'=>"Address"),
);
return transform_headers($headers);
}
function get_vendor_datarows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'id' => $person->vendor_id,
'vendor_type' => $person->vendor_type,
'vendor_code' => $person->vendor_code,
'vendor_name' => $person->vendor_name,
'vendor_mob' => $person->vendor_mob,
'vendor_pan' => $person->vendor_pan,
'vendor_gst' => $person->vendor_gst,
'vendor_address' => $person->vendor_address,
'vendor_remarks' => $person->vendor_remarks,
'edit' => anchor($controller_name."/view/$person->vendor_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
));
}
function get_driver_headers(){
$CI=& get_instance();
$headers=array(
array('tour_no'=>"Tour#"),
array('date'=>"Date"),
array('place'=>"Trip"),
array('sts'=>"Status"),
array('break_close'=>""),
);
return transform_headers($headers);
}
function get_driver_datarows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
$date_info = date("d-m-Y", strtotime($person->from_date))."<br/>".date("d-m-Y", strtotime($person->to_date));
$place = $person->frm_city_name."<br/>".$person->to_city_name;
$edit = anchor($controller_name."/view/$person->operation_id", '<span class="fa fa-pencil-square-o"></span>',array('class'=>'modal-dlg', 'title'=>"Update Trip Information"));
$break_close = anchor($controller_name."/trip_status/$person->operation_id", '<span class="fa fa-bus fa-lg"></span>',array('class'=>'modal-dlg', 'title'=>"Trip Status"));
$driver_sts = $person->driver_sts;
if($driver_sts === "1"){
$driver_sts = "<span style='color:#f6b361;font-weight:bold !important;'>Up coming</span>";
}else
if($driver_sts === "2"){
$driver_sts = "<span style='color:#CC3366;font-weight:bold !important;'>On Progerss</span>";
}else
if($driver_sts === "3"){
$edit = "";
$break_close = "";
$driver_sts = "<span style='color:#4cae4c;font-weight:bold !important;'>Completed</span>";
}
return array (
'date' => "<span style='white-space:nowrap;'>$date_info</span>",
'tour_no' => $person->tour_no ,
'vehicle_no' => $person->vehicle_no ,
'place' => $place,
'sts' => $driver_sts,
'break_close' => $break_close,
'edit' => $edit,
);
}
function get_expence_type_headers(){
$CI=& get_instance();
$headers=array(
//array('id'=>"ID"),
array('expence_type_name'=>"Spare"));
return transform_headers($headers);
}
function get_expence_type_datarows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'id' => $person->expence_type_id,
'expence_type_name' => $person->expence_type_name,
'edit' => anchor($controller_name."/view/$person->expence_type_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
));
}
function get_vehicle_headers(){
$CI=& get_instance();
$headers=array(
//array('id'=>"ID"),
array('vehicle_no'=>"Number"),
array('vehicle_type'=>"Type"),
array('fule_type'=>"Fuel"),
array('owned_by'=>"Owner"),
array('driver_name'=>"Driver"),
array('auth_date'=>"Authorisation"),
array('fc_date'=>"FC"),
array('insur_date'=>"Insurance"),
array('permit_date'=>"Permit"),
array('pollution_date'=>"Pollution"),
array('misc'=>"Misc"));
return transform_headers($headers);
}
function get_vehicle_datarows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'id' => $person->vehicle_id,
'vehicle_no' => $person->vehicle_no,
'vehicle_type' => $person->veh_type,
'fule_type' => $person->fule_type,
'owned_by' => $person->vendor_name,
'driver_name' => $person->first_name,
'fc_date' => date('d-m-Y',strtotime($person->fc_date)),
'auth_date' => date('d-m-Y',strtotime($person->auth_date)),
'insur_date' => date('d-m-Y',strtotime($person->insur_date)) . "<br/>" . $person->insur_company,
'permit_date' => date('d-m-Y',strtotime($person->permit_date)) . "<br/>" . $person->permit_type_name,
'pollution_date' => date('d-m-Y',strtotime($person->pollution_date)),
'edit' => anchor($controller_name."/view/$person->vehicle_id", '<span class="fa fa-pencil-square-o"></span>',array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))),
'misc' => anchor($controller_name."/misc/$person->vehicle_id", '<span class="fa fa-plus-circle fa-lg"></span>',array('class'=>'modal-dlg', 'title'=>'Other Updates'))
);
}
function get_hsn_headers(){
$CI=& get_instance();
$headers=array(
//array('id'=>"ID"),
array('hsn_name'=>"ACS Code"),
array('igst'=>"IGST"),
array('sgst'=>"SGST"),
array('cgst'=>"CGST"),
array('cess'=>"CESS"));
return transform_headers($headers);
}
function get_hsn_datarows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'id' => $person->hsn_id,
'hsn_name' => $person->hsn_name,
'igst' => $person->igst,
'sgst' => $person->sgst,
'cgst' => $person->cgst,
'cess' => $person->cess,
'edit' => anchor($controller_name."/view/$person->hsn_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>$CI->lang->line($controller_name.'_update'))
));
}
function get_abstrack_report_table_headers(){
$CI =& get_instance();
$headers = array(
array('abstrack_report' => "Abstrack Reports")
);
return transform_headers(array_merge($headers, array(array('receipt' => ' ', 'sortable' => FALSE))));
}
function get_vehicle_report_table_headers(){
$CI =& get_instance();
$headers = array(
array('abstrack_report' => "Vehicle Reports")
);
return transform_headers(array_merge($headers, array(array('receipt' => ' ', 'sortable' => FALSE))));
}
function get_vehicle_running_report_table_headers(){
$CI =& get_instance();
$headers = array(
array('abstrack_report' => "Vehicle Running Reports")
);
return transform_headers(array_merge($headers, array(array('receipt' => ' ', 'sortable' => FALSE))));
}
function get_software_update_table_headers(){
$CI =& get_instance();
$headers = array(
array('abstrack_report' => "Software Update Reports")
);
return transform_headers(array_merge($headers, array(array('receipt' => ' ', 'sortable' => FALSE))));
}
function get_Vehicle_type_report_table_headers(){
$CI =& get_instance();
$headers = array(
array('vehicle_type' => "Vehicle Type")
);
return transform_headers(array_merge($headers, array(array('receipt' => ' ', 'sortable' => FALSE))));
}
function get_aggregate_sales_table_headers(){
$CI =& get_instance();
$headers = array(
array('vehicle_type' => "Vehicle Type")
);
return transform_headers(array_merge($headers, array(array('receipt' => ' ', 'sortable' => FALSE))));
}
function get_sabarimalai_pkg_table_headers(){
$CI =& get_instance();
$headers = array(
array('sabarimalai_package' => "Sabarimalai Package")
);
return transform_headers(array_merge($headers, array(array('receipt' => ' ', 'sortable' => FALSE))));
}
function get_Er_report_table_headers(){
$CI =& get_instance();
$headers = array(
array('customer_name' => "Customer Name"),
array('billing_name' => "Billing Name"),
array('phone_number' => "Mob No"),
array('report_address' => "Report Address"),
array('booking_type_name' => "Customer Type"),
array('cust_sts' => "Customer Status"),
array('frm_city_name' => "Origin"),
array('to_city_name' => "Destination"),
array('from_date' => "From Date"),
array('to_date' => "To Date"),
array('first_name' => "Referred By"),
array('trip_type_name' => "trip Type"),
array('avg_km' => "Avg Km"),
array('veh_type' => "Vehicle Type"),
array('bus_count' => "No of Vehicle"),
array('trip_days' => "No of Days"),
array('enquiry_sts' => "Enquiry Status"),
array('prospect' => "Prospect"),
array('trip_details' => "Trip Info"));
return transform_headers($headers);
}
function get_Er_report_data_row($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
if($person->enquiry_sts === "1"){
$enquiry_sts = "Follow Up";
}else
if($person->enquiry_sts === "2"){
$enquiry_sts = "Confirm";
}else
if($person->enquiry_sts === "3"){
$enquiry_sts = "Cancelled";
}
if($person->prospect === "1"){
$prospect = "Hot";
}else
if($person->prospect === "2"){
$prospect = "Warm";
}else
if($person->prospect === "3"){
$prospect = "Dropped";
}
return array (
'customer_name' => $person->customer_name,
'billing_name' => $person->billing_name,
'phone_number' => $person->phone_number,
'report_address' => $person->report_address,
'cust_sts' => $person->cust_sts,
'booking_type_name' => $person->booking_type_name,
'frm_city_name' => $person->frm_city_name,
'to_city_name' => $person->to_city_name,
'from_date' => date('d-m-Y',strtotime($person->from_date)),
'to_date' => date('d-m-Y',strtotime($person->to_date)),
'trip_type_name' => $person->trip_type_name,
'first_name' => $person->first_name,
'avg_km' => $person->avg_km,
'veh_type' => $person->veh_type,
'bus_count' => $person->bus_count,
'trip_days' => $person->trip_days,
'enquiry_sts' => $enquiry_sts,
'prospect' => $prospect,
'booking_amount' => $person->booking_amount,
'trip_details' => $person->trip_details,
'edit' => '',
);
}
function get_Br_report_table_headers(){
$CI =& get_instance();
$headers = array(
array('tour_no' => "Tour No"),
array('customer_name' => "Customer Name"),
array('billing_name' => "Billing Name"),
array('phone_number' => "Mob No"),
array('report_address' => "Report Address"),
array('booking_type_name' => "Customer Type"),
array('cust_sts' => "Customer Status"),
array('frm_city_name' => "Origin"),
array('to_city_name' => "Destination"),
array('from_date' => "From Date"),
array('to_date' => "To Date"),
array('reporting_time' => "Reporting Time"),
array('first_name' => "Referred By"),
array('trip_type_name' => "trip Type"),
array('avg_km' => "Avg Km"),
array('veh_type' => "Vehicle Type"),
array('bus_count' => "No of Vehicle"),
array('trip_days' => "No of Days"),
array('booking_sts' => "Booking Status"),
array('trip_details' => "Trip Info"),
array('booking_amount' => "Booking Amount"),
array('advance_amount' => "Advance"),
array('discount_amount' => "Discount"),
array('balance_amount' => "Balance"),
array('payment_type' => "Payment type"),
array('operation_type' => "Operation Type"),
array('catering' => "Food/Accomedation"),
array('tp_info' => "Temp Permit"));
return transform_headers($headers);
}
function get_Br_report_data_row($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
if($person->booking_sts === "1"){
$booking_sts = "Follow Up";
}else
if($person->booking_sts === "2"){
$booking_sts = "Confirm";
}else
if($person->booking_sts === "3"){
$booking_sts = "Cancelled";
}
if($person->catering === "1"){
$catering = "Yes";
}
if($person->operation_type === "1"){
$operation_type = "Vehicle with driver";
}else
if($person->operation_type === "2"){
$operation_type = "Only driver";
}
return array (
'tour_no' => $person->tour_no,
'customer_name' => $person->customer_name,
'billing_name' => $person->billing_name,
'phone_number' => $person->phone_number,
'report_address' => $person->report_address,
'cust_sts' => $person->cust_sts,
'booking_type_name' => $person->booking_type_name,
'frm_city_name' => $person->frm_city_name,
'to_city_name' => $person->to_city_name,
'from_date' => date('d-m-Y',strtotime($person->from_date)),
'to_date' => date('d-m-Y',strtotime($person->to_date)),
'trip_type_name' => $person->trip_type_name,
'first_name' => $person->first_name,
'avg_km' => $person->avg_km,
'reporting_time' => $person->reporting_time,
'veh_type' => $person->veh_type,
'bus_count' => $person->bus_count,
'trip_days' => $person->trip_days,
'booking_sts' => $booking_sts,
'booking_amount' => $person->booking_amount,
'advance_amount' => $person->advance_amount,
'discount_amount' => $person->discount_amount,
'balance_amount' => $person->balance_amount,
'payment_type' => $person->payment_type,
'operation_type' => $operation_type,
'catering' => $catering,
'tp_info' => $person->tp_info,
'trip_details' => $person->trip_details,
'edit' => '',
);
}
function get_Op_report_table_headers(){
$CI =& get_instance();
$headers = array(
array('tour_no' => "Tour No"),
array('customer_name' => "Customer Name"),
array('billing_name' => "Billing Name"),
array('phone_number' => "Mob No"),
array('booking_type_name' => "Customer Type"),
array('trip_type_name' => "trip Type"),
array('veh_type' => "Vehicle Type"),
array('frm_city_name' => "Origin"),
array('to_city_name' => "Destination"),
array('avg_km' => "Avg Km"),
array('from_date' => "From Date"),
array('to_date' => "To Date"),
array('trip_days' => "No of Days"),
array('vehicle_no' => "Vehicle No"),
array('driver_name' => "Driver Name"),
array('driver_num' => "Driver Mobile"),
array('reporting_time' => "Reporting Time"),
array('report_address' => "Report Address"),
array('trip_details' => "Trip Info"),
array('first_name' => "Referred By"),
array('trip_start_km' => "Start km"),
array('trip_end_km' => "End Km"),
array('tot_km' => "Total Km"),
array('booking_amount' => "Booking Amount"),
array('advance_amount' => "Advance"),
array('amount' => "Catering Amount"),
array('stay_tot_amt' => "Stay Amount"),
array('discount_amount' => "Discount"),
array('op_extra_km' => "Extra Km"),
array('op_extra_amt' => "Extra Amt"),
array('balance_amount' => "Balance"),
array('payment_type' => "Payment type"),
array('operation_type' => "Operation Type"),
array('tp_info' => "Temp Permit"),
array('op_suspence_amt' => "Suspence Amt"),
array('diesel_amt' => "Diesel Amt"),
array('bus_count' => "No of Vehicle"),
array('operation_sts' => "Operation Status"),
// array('catering' => "Food/Accomedation")
);
return transform_headers($headers);
}
function get_Op_report_data_row($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
if($person->operation_sts === "1"){
$operation_sts = "Follow Up";
}else
if($person->operation_sts === "2"){
$operation_sts = "Confirm";
}else
if($person->operation_sts === "3"){
$operation_sts = "Cancelled";
}
if($person->operation_type === "1"){
$operation_type = "Vehicle with driver";
}else
if($person->operation_type === "2"){
$operation_type = "Only driver";
}
//Calculate total km
$trip_start_km = $person->trip_start_km;
$trip_end_km = $person->trip_end_km;
$tot_km = $trip_end_km - $trip_start_km;
$reporting_time = date("G:i", strtotime($person->reporting_time)).' '.'Hrs';
return array (
'tour_no' => $person->tour_no,
'customer_name' => $person->customer_name,
'billing_name' => $person->billing_name,
'phone_number' => $person->phone_number,
'booking_type_name' => $person->booking_type_name,
'trip_type_name' => $person->trip_type_name,
'veh_type' => $person->veh_type,
'frm_city_name' => $person->frm_city_name,
'to_city_name' => $person->to_city_name,
'avg_km' => $person->avg_km,
'from_date' => date('d-m-Y',strtotime($person->from_date)),
'to_date' => date('d-m-Y',strtotime($person->to_date)),
'trip_days' => $person->trip_days,
'vehicle_no' => $person->vehicle_no,
'driver_name' => $person->op_driver_name,
'driver_num' => $person->op_driver_number,
'reporting_time' => $reporting_time,
'report_address' => $person->report_address,
'trip_details' => $person->trip_details,
'first_name' => $person->first_name,
'trip_start_km' => $person->trip_start_km,
'trip_end_km' => $person->trip_end_km,
'tot_km' => $tot_km,
'booking_amount' => $person->booking_amount,
'advance_amount' => $person->advance_amount,
'amount' => $person->amount,
'stay_tot_amt' => $person->stay_tot_amt,
'discount_amount' => $person->discount_amount,
'op_extra_km' => $person->op_extra_km,
'op_extra_amt' => $person->op_extra_amt,
'balance_amount' => $person->balance_amount,
'payment_type' => $person->payment_type,
'operation_type' => $operation_type,
'tp_info' => $person->tp_info,
'op_suspence_amt' => $person->op_suspence_amt,
'diesel_amt' => $person->diesel_amt,
'cust_sts' => $person->cust_sts,
'bus_count' => $person->bus_count,
'operation_sts' => $operation_sts,
'edit' => '',
);
}
function get_Acc_report_table_headers(){
$CI =& get_instance();
$headers = array(
array('tour_no' => "Tour No"),
array('customer_name' => "Customer Name"),
array('billing_name' => "Billing Name"),
array('phone_number' => "Mob No"),
array('booking_type_name' => "Customer Type"),
array('trip_type_name' => "trip Type"),
array('veh_type' => "Vehicle Type"),
array('vendor_name' => "Travels Name"),
array('frm_city_name' => "Origin"),
array('to_city_name' => "Destination"),
array('avg_km' => "Avg Km"),
array('from_date' => "From Date"),
array('to_date' => "To Date"),
array('trip_days' => "No of Days"),
array('vehicle_no' => "Vehicle No"),
array('driver_name' => "Driver Name"),
array('driver_num' => "Driver Mobile"),
array('reporting_time' => "Reporting Time"),
array('report_address' => "Report Address"),
array('trip_details' => "Trip Info"),
array('first_name' => "Referred By"),
array('trip_start_km' => "Start km"),
array('trip_end_km' => "End Km"),
array('tot_km' => "Total Km"),
array('extra_km' => "Extra Km"),
array('tax_rate' => "GST Rate"),
array('booking_amount' => "Hire Charge"),
array('amount' => "Catering Amount"),
array('stay_tot_amt' => "Stay Amount"),
array('extra_amt' => "Extra KM Amount"),
array('total_hire_charger' => "Total Hire Charge"),
array('gst_amount' => "GST"),
array('total_inc_gst' => "Total Inc GST"),
array('discount_amount' => "Discount"),
array('advance_amount' => "Receipt"),
array('balance_amount' => "Balance"),
array('payment_type' => "Payment type"),
array('operation_type' => "Operation Type"),
array('tp_info' => "Temp Permit"),
array('op_suspence_amt' => "Suspence Amt"),
array('diesel_amt' => "Diesel Amt"),
array('bus_count' => "No of Vehicle"),
array('accounts_sts' => "Accounts Status"),
// array('catering' => "Food/Accomedation")
);
return transform_headers($headers);
}
function get_Acc_report_data_row($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
if($person->accounts_sts === "1"){
$accounts_sts = "Follow Up";
}else
if($person->accounts_sts === "2"){
$accounts_sts = "Confirm";
}else
if($person->accounts_sts === "3"){
$accounts_sts = "Cancelled";
}else
if($person->accounts_sts === "4"){
$accounts_sts = "Completed";
}else
if($person->accounts_sts === "5"){
$accounts_sts = "On Progress";
}
if($person->operation_type === "1"){
$operation_type = "Vehicle with driver";
}else
if($person->operation_type === "2"){
$operation_type = "Only driver";
}
$advance_amount = $person->advance_amount;
$booking_id = $person->booking_id;
$catering_order = $CI->Acc_report_model->get_catering($booking_id);
$stay_info = $CI->Acc_report_model->get_stay($booking_id);
$amount = $catering_order->amount; //catering
$stay_tot_amt = $stay_info->stay_tot_amt; //accommodation
$balance_amount = $CI->Acc_report_model->get_total_trip_amount($booking_id);
$booking_log = $CI->Acc_report_model->get_bal_log_amount($booking_id);
$advance_amt = $booking_log->bal_log_amt;
$advance_amount = $advance_amt + $advance_amount;
//Total Hire Charges calculation and gst calculation
$booking_amt = $CI->Acc_report_model->get_booking_amount($booking_id);
$total_booking_amt = $booking_amt->booking_amount;
$extra_km_amt = $CI->Acc_report_model->get_extra_amount($booking_id);
$extra_amt = $extra_km_amt->extra_amt;
$tax_percent = $CI->Acc_report_model->get_tax_percent($booking_id);
$tax_rate = $tax_percent->tax_precentage;
//total amount
$total_hire_charger = $total_booking_amt + $amount + $stay_tot_amt + $extra_amt;
//gst amount
$gst_amount = ($total_hire_charger * $tax_rate)/100;
//include gst in total amount
$total_inc_gst = $total_hire_charger + $gst_amount;
$km = $person->tk;
$km = explode(",",$km);
foreach($km as $t){
$tot_km += $t;
}
//Calculate total km
$trip_start_km = $person->trip_start_km;
$trip_end_km = $person->trip_end_km;
return array (
'tour_no' => $person->tour_no,
'customer_name' => $person->customer_name,
'billing_name' => $person->billing_name,
'phone_number' => $person->phone_number,
'booking_type_name' => $person->booking_type_name,
'trip_type_name' => $person->trip_type_name,
'veh_type' => $person->veh_type,
'vendor_name' => $person->vendor_name,
'frm_city_name' => $person->frm_city_name,
'to_city_name' => $person->to_city_name,
'avg_km' => $person->avg_km,
'from_date' => date('d-m-Y',strtotime($person->from_date)),
'to_date' => date('d-m-Y',strtotime($person->to_date)),
'trip_days' => $person->trip_days,
'vehicle_no' => $person->vehicle_no,
'driver_name' => $person->op_driver_name,
'driver_num' => $person->op_driver_number,
'reporting_time' => $person->reporting_time,
'report_address' => $person->report_address,
'trip_details' => $person->trip_details,
'first_name' => $person->first_name,
'trip_start_km' => $person->trip_start_km,
'trip_end_km' => $person->trip_end_km,
'tot_km' => $tot_km,
'extra_km' => $person->extra_km,
'tax_rate' => $tax_rate,
'booking_amount' => $person->booking_amount,
'amount' => $amount,
'stay_tot_amt' => $stay_tot_amt,
'extra_amt' => $extra_amt,
'total_hire_charger' => $total_hire_charger,
'gst_amount' => $gst_amount,
'total_inc_gst' => $total_inc_gst,
'advance_amount' => $advance_amount,
'discount_amount' => $person->discount_amount,
'balance_amount' => $balance_amount,
'payment_type' => $person->payment_type,
'operation_type' => $operation_type,
'tp_info' => $person->tp_info,
'op_suspence_amt' => $person->op_suspence_amt,
'diesel_amt' => $person->diesel_amt,
'cust_sts' => $person->cust_sts,
'bus_count' => $person->bus_count,
'accounts_sts' => $accounts_sts,
'edit' => '',
);
}
function get_Pkg_er_report_table_headers(){
$CI =& get_instance();
$headers = array(
array('customer_name' => "Customer Name"),
//array('billing_name' => "Billing Name"),
array('phone_number' => "Mob No"),
array('enquiry_date' => "Enquiry Date"),
array('ticket_count' => "Ticket Count"),
array('pickup_point' => "Pickup Point"),
array('discount' => "Discount"),
array('sourcing' => "Sourcing"),
array('enquiry_sts' => "Enquiry Status"),
array('package_name' => "Package Name"));
return transform_headers($headers);
}
function get_Pkg_er_report_data_row($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
if($person->enquiry_sts === "1"){
$enquiry_sts = "Follow Up";
}else
if($person->enquiry_sts === "2"){
$enquiry_sts = "Confirm";
}else
if($person->enquiry_sts === "3"){
$enquiry_sts = "Cancelled";
}
return array (
'customer_name' => $person->customer_name,
// 'billing_name' => $person->billing_name,
'phone_number' => $person->phone_number,
'package_name' => $person->package_name,
'enquiry_date' => date('d-m-Y',strtotime($person->enquiry_date)),
'ticket_count' => $person->ticket_count,
'pickup_point' => $person->pickup_point,
'discount' => $person->discount,
'sourcing' => $person->sourcing,
'enquiry_sts' => $enquiry_sts,
'edit' => '',
);
}
function get_Tour_fb_report_table_headers(){
$CI =& get_instance();
$headers = array(
array('tour_no' => "Tour No"),
array('customer_name' => "Customer Name"),
array('booking_type_name' => "Booking Type"),
array('trip_type_name' => "Trip Type"),
array('veh_type' => "Vehicle Type"),
array('vehicle_no' => "Vehicle No"),
array('op_driver_name' => "Driver Name"),
array('from_date' => "From Date"),
array('to_date' => "To Date"),
array('vch_quality' => "Vehicle Quality"),
array('vch_media' => "Vehicle Media"),
array('vch_seat' => "Vehicle Seat"),
array('driving_skill' => "Driving Skill"),
array('driver_behaviour' => "Behaviour"),
array('sightseeing' => "Site seeing"));
return transform_headers($headers);
}
function get_Tour_fb_report_data_row($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'tour_no' => $person->tour_no,
'customer_name' => $person->customer_name,
'booking_type_name' => $person->booking_type_name,
'trip_type_name' => $person->trip_type_name,
'veh_type' => $person->veh_type,
'vehicle_no' => $person->vehicle_no,
// 'billing_name' => $person->billing_name,
'op_driver_name' => $person->op_driver_name,
'vch_quality' => $person->vch_quality,
'from_date' => date('d-m-Y',strtotime($person->from_date)),
'to_date' => date('d-m-Y',strtotime($person->to_date)),
'vch_media' => str_replace("_"," ",$person->vch_media),
'vch_seat' => str_replace("_"," ",$person->vch_seat),
'driving_skill' => str_replace("_"," ",$person->driving_skill),
'driver_behaviour' => str_replace("_"," ",$person->driver_behaviour),
'sightseeing' => str_replace("_"," ",$person->sightseeing),
'edit' => '',
);
}
function get_trip_wise_headers(){
$CI=& get_instance();
$headers=array(
array('tour_no'=>"Tour #"),
array('customer_name'=>"Name"),
array('from_date'=>"From Date"),
array('to_date'=>"To Date"),
array('orgin'=>"Origin"),
array('destination'=>"Destination"),
array('booking_type_name'=>"Booking"),
array('trip_type_name'=>"Trip Type"),
array('veh_type'=>"Vehicle"),
array('vehicle_no'=>"Vehicle#"),
array('op_driver_name'=>"Primary Driver"),
array('second_driver_name'=>"Secondary Driver"),
array('hire_charges'=>"Hire Amount"),
array('trip_start_km'=>"Start KM"),
array('trip_end_km'=>"End KM"),
array('op_extra_km'=>"Extra KM"),
array('op_extra_pre_km'=>"Per KM"),
array('op_extra_amt'=>"Extra Amount"),
array('diesel_amt'=>"Diesel Amount"),
array('suspence_amt'=>"Suspence Amount"),
//array('driver_susp_amt'=>"driver_susp_amt"),
);
return transform_headers($headers);
}
function get_trip_wise_datarows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
$total_driver_sup = (int)$person->op_suspence_amt + (int)$person->driver_susp_amt;
return array (
'tour_no' => $person->tour_no,
'customer_name' => $person->customer_name,
'from_date' => date('d-m-Y',strtotime($person->from_date)),
'to_date' => date('d-m-Y',strtotime($person->to_date)),
'orgin' => $person->frm_city_name,
'destination' => $person->to_city_name,
'booking_type_name' => $person->booking_type_name,
'trip_type_name' => $person->trip_type_name,
'veh_type' => $person->veh_type,
'vehicle_no' => $person->vehicle_no,
'op_driver_name' => $person->op_driver_name,
'second_driver_name' => $person->second_driver_name,
'hire_charges' => $person->hire_charges,
'trip_start_km' => $person->trip_start_km,
'trip_end_km' => $person->trip_end_km,
'op_extra_km' => $person->op_extra_km,
'op_extra_pre_km' => $person->op_extra_pre_km,
'op_extra_amt' => $person->op_extra_amt,
'diesel_amt' => $person->diesel_amt,
'suspence_amt' => $person->suspence_amt,
'driver_susp_amt' => $total_driver_sup,
);
}
function get_pk_cust_report_headers(){
$CI=& get_instance();
$headers=array(
array('customer_name'=>"Name"),
array('pack_info'=>"Package Information"),
array('pnr'=>"PNR"),
array('seat_no'=>"Seat No"),
array('pickup_point'=>"Pickup Point"),
array('payment_type'=>"Payment Type"),
array('sourcing'=>"Sourcing"),
array('amount'=>"Amount"),
array('discount'=>"Discount"),
array('balance'=>"Balance"),
array('enquiry_sts'=>"Enquiry Status"),
array('feedback'=>"Feedback"),
array('driving_driver'=>"Driver"),
array('feed_vehicle'=>"Vehicle"),
array('feed_food'=>"Food"),
array('feed_accomodation'=>"Accomodation"),
array('feed_overall'=>"Overall"),
array('remark'=>"Remarks"),
);
return transform_headers($headers);
}
function get_pk_cust_report_datarows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
$package_name = $person->package_name;
$from_date = date('d-m-Y',strtotime($person->from_date));
$to_date = date('d-m-Y',strtotime($person->to_date));
$pack_info = "$package_name <br/> $from_date to $to_date";
if($person->enquiry_sts === "1"){
$enquiry_sts = "Pending";
}else
if($person->enquiry_sts === "2"){
$enquiry_sts = "Confirm";
}else
if($person->enquiry_sts === "3"){
$enquiry_sts = "Cancelled";
}
return array (
'customer_name' => $person->customer_name,
'pack_info' => $pack_info,
'pnr' => $person->pnr,
'seat_no' => $person->seat_no,
'pickup_point' => $person->pickup_point,
'payment_type' => str_replace("_"," ",$person->payment_type),
'sourcing' => str_replace("_"," ",$person->sourcing),
'amount' => $person->amount,
'discount' => $person->discount,
'balance' => $person->balance,
'enquiry_sts' => $enquiry_sts,
'feedback' => str_replace("_"," ",$person->feedback),
'driving_driver' => str_replace("_"," ",$person->driving_driver),
'feed_vehicle' => str_replace("_"," ",$person->feed_vehicle),
'feed_food' => str_replace("_"," ",$person->feed_food),
'feed_accomodation' => str_replace("_"," ",$person->feed_accomodation),
'feed_overall' => str_replace("_"," ",$person->feed_overall),
'remark' => $person->remark,
);
}
function get_suspense_report_headers(){
$CI=& get_instance();
$headers=array(
/*
array('op_driver_id'=>"op_driver_id"),
array('op_driver_name'=>"Driver Name"),
array('op_suspence_amt'=>"Total Amount"),
array('driver_suspence_amount'=>"check"),
array('suspence_amt'=>"suspence_amt"),
array('diesel_amt'=>"diesel_amt"),
*/
array('tour_no'=>"Tour No"),
array('driver_suspence_date'=>"Date"),
array('vehicle_no'=>"Vehicle No"),
array('customer_name'=>"Party Name"),
array('to_city_name'=>"Destination"),
array('from_date'=>"From"),
array('to_date'=>"To"),
array('first_name'=>"Name"),
array('trip_days'=>"Days"),
array('tot_amt'=>"Total Suspence"),
array('expense_amt'=>"Total Expense"),
array('bal_amt'=>"Balance"),
);
return transform_headers($headers);
}
function get_suspense_report_datarows($person,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
$bal_amt = (int)$person->tot_amt - (int)$person->expense_amt;
$driver_name = $person->first_name;
if($person->op_driver_id === "0"){
$driver_name = "Other Driver";
}
$count = count(get_object_vars($person));
return array (
/*
'op_driver_id' => $person->op_driver_id,
'op_driver_name' => $person->op_driver_name,
'op_suspence_amt' => $person->op_suspence_amt,
'driver_suspence_amount' => $person->driver_suspence_amount,
'suspence_amt' => $person->suspence_amt,
'diesel_amt' => $person->diesel_amt,
*/
//'count' => $person+1,
'driver_suspence_date' => date('d-M-Y',strtotime($person->driver_suspence_date)),
'tour_no' => $person->tour_no,
'vehicle_no' => $person->vehicle_no,
'customer_name' => $person->customer_name,
'to_city_name' => $person->to_city_name,
'first_name' => $driver_name,
'from_date' => date('d-m-Y',strtotime($person->from_date)),
'to_date' => date('d-m-Y',strtotime($person->to_date)),
'trip_days' => $person->trip_days,
'tot_amt' => $person->tot_amt,
'expense_amt' => $person->expense_amt,
'bal_amt' => $bal_amt,
);
}
?>