File: //home/cafsindia/allyindian_com/backend/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_all_leads_table_headers(){
$CI =& get_instance();
$headers = array(
array('lead_id' => "ID"),
array('company' => "Company"),
array('first_name' => "First Name"),
array('mobile' => "Mobile #"),
array('lead_status' => "Status"),
array('lead_company' => "Industry"),
);
return transform_headers($headers);
}
function get_people_manage_table_headers(){
$CI =& get_instance();
$headers = array(
array('people.person_id' => $CI->lang->line('common_id')),
array('cust_name' => $CI->lang->line('common_cust_name')),
array('cust_address' => $CI->lang->line('common_cust_address')),
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_person_data_row($person, $controller){
$CI =& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'people.person_id' => $person->custid,
'cust_name' => $person->custfname." ".$person->custlname,
'cust_address' => $person->custaddress,
'email' => empty($person->custemail) ? '' : mailto($person->custemail, $person->custemail),
'phone_number' => $person->custmobile,
'edit' => anchor($controller_name."/view/$person->custid", '<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,
'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 boarding_point_headers(){
$CI =& get_instance();
$headers = array(
array('board_point_id' => "S No"),
array('boarding_name' => "Boarding name"),
array('status' => "Status")
);
return transform_headers($headers);
}
function boarding_point_data_row($board_point, $controller){
$CI =& get_instance();
$controller_name=strtolower(get_class($CI));
$status = $board_point->status;
if($status === "1"){
$clr = "style = 'color: #06ff06'";
$status = "Active";
}else{
$clr = "style = 'color:red'";
$status = "In Active";
}
return array(
'board_point_id' => $board_point->board_point_id,
'boarding_name' => $board_point->boarding_name,
'status' => "<span $clr>$status</span>",
'edit' => anchor($controller_name."/view/$board_point->board_point_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>"Update Board Point"))
);
}
function boarding_headers(){
$CI =& get_instance();
$headers = array(
array('boarding_id' => "S No"),
array('boarding_name' => "Boarding name"),
array('vehicle_no' => "Vehicle No"),
array('veh_type' => "Vehicle Type"),
array('status' => "Status")
);
return transform_headers($headers);
}
function boarding_data_row($board_point, $controller){
$CI =& get_instance();
$controller_name=strtolower(get_class($CI));
$status = $board_point->status;
if($status === "1"){
$clr = "style = 'color: #06ff06'";
$status = "Active";
}else{
$clr = "style = 'color:red'";
$status = "In Active";
}
return array(
'boarding_id' => $board_point->boarding_id,
'boarding_name' => $board_point->boarding_name,
'vehicle_no' => $board_point->vehicle_no,
'veh_type' => $board_point->veh_type,
'status' => "<span $clr>$status</span>",
'edit' => anchor($controller_name."/view/$board_point->boarding_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>"Update Board Point"))
);
}
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($type,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'id' => $type->veh_type_id,
'veh_category' => $type->veh_category,
'veh_type' => $type->veh_type,
'edit' => anchor($controller_name."/view/$type->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_cancel_headers(){
$CI=& get_instance();
$headers=array(
array('cancelfeedetail'=>"Cancel fee Detail"),
array('cancelmindays'=>"Min days"),
array('cancelmaxdays'=>"Max Days"),
array('cancelfees'=>"Fees"));
return transform_headers($headers);
}
function get_cancel_datarows($type,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'cancelfeeid' => $type->cancelfeeid,
'cancelfeedetail' => $type->cancelfeedetail,
'cancelmindays' => $type->cancelmindays,
'cancelmaxdays' => $type->cancelmaxdays,
'cancelfees' => $type->cancelfees,
'edit' => anchor($controller_name."/view/$type->cancelfeeid", '<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'=>"Vehicle No"),
array('vehicle_type'=>"Type"),
array('fuel_type'=>"Fuel"),
array('seat_capacity'=>"Capacity"),
array('count'=>"Seat Mapped"),
array('view_seats'=>"Seat Mapping"));
return transform_headers($headers);
}
function get_vehicle_datarows($vehicle,$controller){
$CI=& get_instance();
$controller_name =strtolower(get_class($CI));
$seat_capacity = $vehicle->seat_capacity;
$lower = $vehicle->vehicle_lower;
$upper = $vehicle->vehicle_upper;
if($lower === null){
$lower_mapped = 0;
}else{
$lower = explode(",",$lower);
$lower_mapped = count($lower) - array_count_values(array_map('strval',$lower))['0'];
}
if($upper === null){
$upper_mapped = 0;
}else{
$upper = explode(",",$upper);
$upper_mapped = count($upper) - array_count_values(array_map('strval',$upper))['0'];
}
$tot = $lower_mapped + $upper_mapped;
$style = "";
if($seat_capacity > $tot){
$style = "style = 'color:red;font-weight:bold;'";
}
return array (
'id' => $vehicle->vehicle_id,
'vehicle_no' => $vehicle->vehicle_no,
'vehicle_type' => $vehicle->veh_type,
'fuel_type' => $vehicle->fuel_type,
'seat_capacity'=> $seat_capacity,
'count' => "<span $style>$tot</span>",
'view_seats' => anchor($controller_name."/view_seats/$vehicle->vehicle_id", '<span class="btn btn-info btn-sm">Add Seat no</span>',array('class'=>'modal-dlg', 'title'=>"View Seats")),
'edit' => anchor($controller_name."/view/$vehicle->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')))
);
}
function get_package_type_headers(){
$CI=& get_instance();
$headers=array(
array('id'=>"ID"),
array('package_type'=>"Package type"));
return transform_headers($headers);
}
function get_package_type_datarows($package,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
return array (
'id' => $package->package_type_id,
'package_type' => $package->package_type,
'edit' => anchor($controller_name."/view/$package->package_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 package_headers(){
$CI =& get_instance();
$headers = array(
array('package_id' => "S No"),
array('package_title' => "Package name"),
array('status' => "Status"),
array('itinerary' => "Itinerary")
);
return transform_headers($headers);
}
function package_data_row($package, $controller){
$CI =& get_instance();
$controller_name=strtolower(get_class($CI));
$status = $package->status;
if($status === "1"){
$status = "Active";
}else{
$status = "In Active";
}
$pkg = $package->package_title." ".$package->package_title2." (".$package->package_title3.")";
return array(
'package_id' => $package->package_id,
'package_title' => $pkg,
'status' => "<span style='font-weight:bold;'>$status</span>",
'itinerary' => anchor($controller_name."/view_itinery/$package->package_id", '<span style="float:center;" class="fa fa-plus"></span>',
array('class'=>'modal-dlg','title'=>"Update Details")),
'edit' => anchor($controller_name."/view/$package->package_id", '<span class="fa fa-pencil-square-o"></span>',
array('class'=>'modal-dlg', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>"Update Package"))
);
}
?>