File: /home/cafsindia/ntc_cafsinfotech_in/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);
}
/* COMMON TABLE HEADER BASED ON SCREEN & SETTING */
function get_dbtable_headers($table_info){
$CI =&get_instance();
$access_data = $CI->session->userdata('access_data');
$controller_name = strtolower(get_class($CI));
$headers = array();
foreach($table_info as $table){
$headers[] = array($table->label_name => $table->view_name);
}
if($controller_name === "enquiry"){
$headers[]['print'] = '';
}
return transform_headers($headers);
}
/* COMMON TABLE ROW BASED ON SCREEN SETTING */
function get_dbdata_row($search_data,$table_info,$controller){
$CI =&get_instance();
$access_data = $CI->session->userdata('access_data');
$controller_name = strtolower(get_class($CI));
$access_update = (int)$access_data[$controller_name]['access_update'];
$prime_id = "prime_".$controller_name."_id";
$cf_id = "prime_".$controller_name."_cf_id";
$page_name = ucwords(str_replace("_"," ",$controller_name));
//$table_info = explode(",",$table_info);
$data_row = array();
$data_row[$prime_id] = $search_data->$prime_id;
$show_renewal = true;
foreach($table_info as $table){
$label_name = $table->label_name;
$field_type = $table->field_type;
$value = $search_data->$label_name;
if((int)$field_type === 4){
$value = date('d-m-Y',strtotime($search_data->$label_name));
if($value === "01-01-1970"){
$value = "-";
}
}else
if((int)$field_type === 6){
$value = "No";
if((int)$search_data->$label_name === 1){
$value = "Yes";
}
}else
if((int)$field_type === 7){
if($search_data->$label_name){
$value = $search_data->$label_name.",..";
}else{
$value = "-";
}
}else
if((int)$field_type === 13){
$value = date('d-m-Y H:i:s',strtotime($search_data->$label_name));
if(strpos($value, '01-01-1970') !== false) {
$value = date("d-m-Y H:i:s");
}
}else{
$value = $search_data->$label_name;
}
$data_row[$label_name] = $value;
}
$data_row['edit'] = "";
if(($controller_name == 'customer_request') && $data_row['status'] != 'Scheduled'){
$data_row['edit'] = "";
}else{
if($access_update === 1){
$view_id = $search_data->$prime_id;
$data_row['edit'] = anchor("$controller_name/view/$view_id", '<span class="fa fa-pencil-square-o"></span>Edit',array('class'=>'modal-dlg btn btn-xs btn-edit', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>"Update $page_name"));
if($controller_name === 'enquiry'){
$data_row['print'] = anchor("$controller_name/print_enquiry/$view_id", '<span class="fa fa-print "></span>',array('class'=>'btn btn-xs btn-edit', 'title'=>"Print $page_name"));
}
}
}
return $data_row;
}
/* FORM SETTING - START */
function get_form_setting_headers(){
$CI=& get_instance();
$headers = array(
array('module_name'=>"Module Name"),
array('menu_name'=>"Menu"),
array('module_type'=>"Module Type"),
array('show_module'=>"Module Status"),
);
return transform_headers($headers);
}
function get_form_setting_datarows($page_setting,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
$page_name = ucwords(str_replace("_"," ",$controller_name));
$access_data = $CI->session->userdata('access_data');
$access_update = (int)$access_data[$controller_name]['access_update'];
$edit_opt = "";
if($access_update === 1){
$title = "Update " . ucwords($page_setting->module_name);
if($controller_name === "module_setting"){
$edit_opt = anchor($controller_name."/module_view/$page_setting->module_id", '<span class="fa fa-pencil-square-o"></span> Edit',array('class'=>'modal-dlg btn btn-xs btn-edit', 'title'=>"$title"));
}else
if($controller_name === "form_setting"){
$edit_opt = anchor($controller_name."/view/$page_setting->module_id", '<span class="fa fa-pencil-square-o"></span> Edit',array('class'=>'modal-dlg btn btn-xs btn-edit', 'title'=>"$title"));
}else{
$edit_opt = anchor($controller_name."/view/$page_setting->module_id", '<span class="fa fa-pencil-square-o"></span> Edit',array('class'=>'modal-dlg btn btn-xs btn-edit', 'title'=>"$title"));
}
}
$name = ucwords(str_replace("_"," ",$page_setting->module_id));
$show_module = "Active";
if((int)$page_setting->show_module === 0){
$show_module = "In Active";
}
return array (
'module_name' => ucwords($page_setting->module_name),
'menu_name' => ucwords($page_setting->menu_name),
'module_type' => ucwords(strtolower($page_setting->module_type)),
'show_module' => $show_module,
'edit' => $edit_opt
);
}
/* FORM SETTING - END */
/* REPORT SETTING - START */
function get_report_setting_headers(){
$CI=& get_instance();
$headers = array(
//array('prime_report_setting_id'=>"Report ID"),
array('report_name'=>"Report Name"),
);
return transform_headers($headers);
}
function get_report_setting_datarows($report_setting,$controller){
$CI =&get_instance();
$access_data = $CI->session->userdata('access_data');
$controller_name = strtolower(get_class($CI));
$access_update = (int)$access_data[$controller_name]['access_update'];
$page_name = ucwords(str_replace("_"," ",$controller_name));
return array (
'prime_report_setting_id' => $report_setting->prime_report_setting_id,
'report_name' => $report_setting->report_name,
'edit' => anchor($controller_name."/view/$report_setting->prime_report_setting_id", '<span class="fa fa-pencil-square-o"></span> Edit',
array('class'=>'modal-dlg btn btn-xs btn-edit', 'title'=>" Update $page_name")),
);
}
/* COMMON TABLE HEADER BASED ON REPORT SETTING */
function get_report_headers($table_info){
$CI =&get_instance();
$controller_name = strtolower(get_class($CI));
$headers = array();
foreach($table_info as $table){
$headers[] = array($table->label_name => $table->view_name);
}
return transform_headers($headers);
}
/* COMMON TABLE ROW BASED ON REPORT SETTING */
function get_report_row($search_data,$table_info,$report_data,$controller){
$CI =&get_instance();
$access_data = $CI->session->userdata('access_data');
$controller_name = strtolower(get_class($CI));
$access_update = (int)$access_data[$controller_name]['access_update'];
$data_row = array();
$report_view_count = (int)$report_data[0]->report_view_count;
$report_name = ucwords($report_data[0]->report_name);
$send_val = "?";
$report_prime_column = $report_data[0]->report_prime_column;
$report_prime_column = explode(",",$report_prime_column);
foreach($report_prime_column as $input_columns){
$input_columns = explode(".",$input_columns);
$input_columns = $input_columns[1];
$input_value = $search_data->$input_columns;
$data_row[$input_columns] = $input_value;
$send_val .= "$input_columns=$input_value&";
}
foreach($table_info as $table){
$label_name = $table->label_name;
$field_type = $table->field_type;
$value = $search_data->$label_name;
if((int)$field_type === 4){
$value = date('d-m-Y',strtotime($search_data->$label_name));
if($value === "01-01-1970"){
$value = "-";
}
}else
if((int)$field_type === 6){
$value = "No";
if((int)$search_data->$label_name === 1){
$value = "Yes";
}
}else
if((int)$field_type === 7){
$value = "-";
if($search_data->$label_name){
$value = $search_data->$label_name.",..";
}
}else{
$value = $search_data->$label_name;
}
$data_row[$label_name] = $value;
}
if($report_view_count > 0){
$data_row['edit'] = anchor("$controller_name/report_view/$send_val", '<span class="fa fa-pencil-square-o"></span> View',array('class'=>'modal-dlg btn btn-xs btn-edit', 'title'=>"View $report_name"));
}else{
$data_row['edit'] = "";
}
return $data_row;
}
/* REPORT SETTING - END */
/* BSK EMPLOYEE PERMISSION HEADERS CUSTOM START */
function get_permission_headers(){
$CI =& get_instance();
$headers = array(
array('role_name' => "Role")
);
return transform_headers($headers);
}
function get_permission_dbdata_row($permission, $controller){
$CI =& get_instance();
$controller_name=strtolower(get_class($CI));
return array(
'role' => $permission->role,
'role_name' => $permission->role_name,
'edit' => anchor("$controller_name/view/$permission->role", '<span class="fa fa-pencil-square-o"></span> Edit',array('class'=>'modal-dlg btn btn-xs btn-edit', 'data-btn-submit' => $CI->lang->line('common_submit'), 'title'=>"Update Permission")));
}
/* BSK EMPLOYEE PERMISSION HEADERS CUSTOM END */
function total_year($end_date, $begin_date){
$begin_date = new DateTime($begin_date);
$begin_date = $begin_date->format("Y-m-d");
$end_date = new DateTime($end_date);
$end_date = $end_date->format("Y-m-d");
$date_parts1 = explode("-", $begin_date);
$date_parts2 = explode("-", $end_date);
$start_date = gregoriantojd($date_parts1[1], $date_parts1[2], $date_parts1[0]);
$end_date = gregoriantojd($date_parts2[1], $date_parts2[2], $date_parts2[0]);
$diff = abs($end_date - $start_date);
if((int)$diff === 365){
$years = 1;
}else{
$years = floor($diff / 365.25);
}
return $years;
}
/* SAB LOAD - START */
function get_ntc_load_headers(){
$CI=& get_instance();
$headers = array(
array('from_date'=>"From Date"),
array('to_date'=>"To Date"),
array('horse'=>"Horse"),
array('load_customer_type'=>"Load Customer Type"),
array('trip_status'=>"Trip Status"),
array('delivery_note'=>"Delivery Note"),
array('return_note'=>"Return Note"),
array('remarks'=>"Remarks"),
);
return transform_headers($headers);
}
function get_ntc_load_datarows($ntc_load,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
$page_name = ucwords(str_replace("_"," ",$controller_name));
$access_data = $CI->session->userdata('access_data');
$access_update = (int)$access_data[$controller_name]['access_update'];
$edit_opt = "";
if($access_update === 1){
$edit_opt = anchor($controller_name."/view/$ntc_load->prime_ntc_load_id", '<span class="fa fa-eye"></span> View',array('class'=>'modal-dlg btn btn-xs btn-edit', 'title'=>"View NTC Load"));
}
$trip_status_list = array(1 => 'Schedule',2 => 'Confirm',3 => 'Onprogress',4 => 'Cancelled',5 => 'Completed',6 => 'Incompleted');
$trip_status = $trip_status_list[$ntc_load->trip_status];
$remarks = "";
if($ntc_load->note){
$remarks = $ntc_load->note;
}else
if($ntc_load->cancel_note){
$remarks = $ntc_load->cancel_note;
}else
if($ntc_load->incomplete_note){
$remarks = $ntc_load->incomplete_note;
}
return array(
'prime_ntc_load_id' => $ntc_load->prime_ntc_load_id,
'from_date' => date('d-m-Y',strtotime($ntc_load->from_date)),
'to_date' => date('d-m-Y',strtotime($ntc_load->to_date)),
'horse' => $ntc_load->reg_no."-".$ntc_load->register_no,
'load_customer_type' => $ntc_load->load_customer_type,
'trip_status' => $trip_status,
'delivery_note' => $ntc_load->delivery_note,
'return_note' => $ntc_load->return_note,
'remarks' => $remarks,
'edit' => $edit_opt
);
}
/* SAB LOAD - END */
/* RECEIVING HISTORY - START */
function get_receiving_headers(){
$CI=& get_instance();
$headers = array(
array('entry_date' => "Entry Date"),
array('customer_name' => "Customer Name"),
array('sku_no' => "SKU"),
array('view' => "Option"),
);
return transform_headers($headers);
}
function get_receiving_datarows($receiving_data,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
$page_name = ucwords(str_replace("_"," ",$controller_name));
$access_data = $CI->session->userdata('access_data');
$access_update = (int)$access_data[$controller_name]['access_update'];
$edit_opt = "";
$view_opt = anchor($controller_name."/view/$receiving_data->order_receiving_id", '<span class="fa fa-eye"></span> View',array('class'=>'modal-dlg btn btn-xs btn-edit', 'title'=>"View Receiving History"));
return array(
'order_receiving_id' => $receiving_data->prime_ntc_load_id,
'entry_date' => date('d-m-Y',strtotime($receiving_data->entry_date)),
'customer_name' => $receiving_data->customer_name,
'sku_no' => $receiving_data->sku_no,
'view' => $view_opt
);
}
/* RECEIVING HISTORY - END */
/* DISPATCH HISTORY - START */
function get_dispatch_headers(){
$CI=& get_instance();
$headers = array(
array('dispatch_date' => "Dispatch Date"),
array('customer_name' => "Customer Name"),
array('sku_no' => "SKU"),
array('view' => "Option"),
);
return transform_headers($headers);
}
function get_dispatch_datarows($receiving_data,$controller){
$CI=& get_instance();
$controller_name=strtolower(get_class($CI));
$page_name = ucwords(str_replace("_"," ",$controller_name));
$access_data = $CI->session->userdata('access_data');
$access_update = (int)$access_data[$controller_name]['access_update'];
$edit_opt = "";
$view_opt = anchor($controller_name."/view/$receiving_data->order_dispatch_id", '<span class="fa fa-eye"></span> View',array('class'=>'modal-dlg btn btn-xs btn-edit', 'title'=>"View Dispatch History"));
return array(
'order_dispatch_id' => $receiving_data->prime_ntc_load_id,
'dispatch_date' => date('d-m-Y',strtotime($receiving_data->dispatch_date)),
'customer_name' => $receiving_data->customer_name,
'sku_no' => $receiving_data->sku_no,
'view' => $view_opt
);
}
/* DISPATCH HISTORY - END */
/* PRODUCT AVAILABILITY START */
function get_product_availability_headers(){
$CI=& get_instance();
$headers = array(
array('our_vendor_no' => "Vendor No"),
array('customer_name' => "Customer Name"),
array('mobile_number' => "Mobile No"),
array('email' => "Email"),
array('view' => "Option")
);
return transform_headers($headers);
}
function get_product_availability_datarows($receiving_data,$controller){
$CI=& get_instance();
$controller_name = strtolower(get_class($CI));
$page_name = ucwords(str_replace("_"," ",$controller_name));
$access_data = $CI->session->userdata('access_data');
$access_update = (int)$access_data[$controller_name]['access_update'];
$edit_opt = "";
$our_vendor_no = $receiving_data->our_vendor_no;
$customer_name = $receiving_data->customer_name;
$mobile_number = $receiving_data->mobile_number;
$email = $receiving_data->email;
if(!$our_vendor_no){
$our_vendor_no = "-";
}
if(!$customer_name){
$customer_name = "-";
}
if(!$mobile_number){
$mobile_number = "-";
}
if(!$email){
$email = "-";
}
$view_opt = anchor($controller_name."/view/$receiving_data->prime_customer_id", '<span class="fa fa-eye"></span> View',array('class'=>'modal-dlg btn btn-xs btn-edit', 'title'=>"View Product Availability"));
return array(
'our_vendor_no' => $our_vendor_no,
'customer_name' => $customer_name,
'mobile_number' => $mobile_number,
'email' => $email,
'view' => $view_opt
);
}
/* PRODUCT AVAILABILITY END */
/* GATE PASS START */
function get_gate_pass_headers(){
$CI=& get_instance();
$headers = array(
array('gate_pass_no' => "Gate Pass Number "),
array('date' => "Date"),
array('company' => "Company"),
array('driver' => "Driver"),
array('vehicle' => "Vehicle"),
array('entry_reason' => "Entry Reason"),
array('view' => "Option")
);
return transform_headers($headers);
}
function get_gate_pass_datarows($receiving_data,$controller){
$CI=& get_instance();
$controller_name = strtolower(get_class($CI));
$page_name = ucwords(str_replace("_"," ",$controller_name));
$access_data = $CI->session->userdata('access_data');
$access_update = (int)$access_data[$controller_name]['access_update'];
$edit_opt = "";
$gate_pass_no = $receiving_data->gate_pass_no;
$date = date('d-m-Y h:m:s',strtotime($receiving_data->date));
$company = $receiving_data->company;
if($receiving_data->driver == '' && $receiving_data->vehicle == ''){
$driver = $receiving_data->ntc_driver;
$vehicle = $receiving_data->ntc_vehicle;
}else
if($receiving_data->ntc_driver == '' && $receiving_data->ntc_vehicle == ''){
$driver = $receiving_data->driver;
$vehicle = $receiving_data->vehicle;
}
$driver = $driver;
$vehicle = $vehicle;
$entry_reason = $receiving_data->entry_reason;
if(!$gate_pass_no){
$gate_pass_no = "-";
}
if(!$customer_name){
$customer_name = "-";
}
if(!$driver){
$driver = "-";
}
if(!$vehicle){
$vehicle = "-";
}
$company_list = array(1 => 'NTC',2 => 'Others');
$view_opt = anchor($controller_name."/view/$receiving_data->prime_gate_pass_id", '<span class="fa fa-pencil-square-o"></span> Edit',array('class'=>'modal-dlg btn btn-xs btn-edit', 'title'=>"View Gate Pass"));
$print_opt = anchor("$controller_name/view_print/$receiving_data->prime_gate_pass_id", '<span class="fa fa-print "></span>Print',array('class'=>'btn btn-xs btn-edit', 'title'=>"Print Gate Pass"));
return array(
'gate_pass_no' => $gate_pass_no,
'date' => $date,
'company' => $company_list[$company],
'driver' => $driver,
'vehicle' => $vehicle,
'entry_reason' => $entry_reason,
'view' => $print_opt." ".$view_opt,
'edit' => ""
);
}
/* GATE PASS END */
/* JOB SCHEDULE START */
function get_Job_schedule_headers(){
$CI=& get_instance();
$headers = array(
array('job_card_number' => "Job Order Number"),
array('service_type' => "Service Type"),
array('company' => "Company"),
array('vehicle_no' => "Vehicle No"),
array('date' => "Date"),
array('driver' => "Driver"),
array('km' => "Km"),
array('job_status' => "Job Status"),
array('view' => "Option")
);
return transform_headers($headers);
}
function get_Job_schedule_datarows($receiving_data,$controller){
$CI=& get_instance();
$controller_name = strtolower(get_class($CI));
$page_name = ucwords(str_replace("_"," ",$controller_name));
$access_data = $CI->session->userdata('access_data');
$access_update = (int)$access_data[$controller_name]['access_update'];
$edit_opt = "";
$prime_maintenance_job_schedule_id = $receiving_data->prime_maintenance_job_schedule_id;
$job_card_number = $receiving_data->job_card_number;
$service_type = $receiving_data->service_type;
$company = $receiving_data->company;
if($receiving_data->register_no){
$vehicle_no = $receiving_data->register_no;
}else{
$vehicle_no = $receiving_data->vehicle_no;
}
$date = date('d-m-Y',strtotime($receiving_data->date));
$driver = $receiving_data->driver;
$km = $receiving_data->km;
$company_list = array(1 => 'NTC',2 => 'Others');
$status = $receiving_data->job_status;
$job_status = array(1 => 'Pending',2 => 'Onprogress',3 => 'completed');
if((int)$status != 3){
$view_opt = anchor($controller_name."/view/$receiving_data->prime_maintenance_job_schedule_id", '<span class="fa fa-pencil-square-o"></span> Edit',array('class'=>'modal-dlg btn btn-xs btn-edit', 'title'=>"View Job Schedule"));
}else{
$view_opt = '';
}
$print_opt = anchor("$controller_name/view_print/$receiving_data->prime_maintenance_job_schedule_id", '<span class="fa fa-print "></span>Print',array('class'=>'btn btn-xs btn-edit', 'title'=>"Print Job Card"));
return array(
'job_card_number' => $job_card_number,
'service_type' => $service_type,
'company' => $company_list[$company],
'vehicle_no' => $vehicle_no,
'date' => $date,
'driver' => $driver,
'km' => $km,
'job_status' => $job_status[$status],
'view' => $print_opt." ".$view_opt,
'edit' => ""
);
}
/*JOB SCHEDULE END */
/* FAULT REPORT START */
function get_fault_report_headers(){
$CI=& get_instance();
$headers = array(
array('driver_name' => "Driver Name "),
array('vehicle_type' => "Vehicle Type"),
array('vehicle_no' => "Vehicle Number"),
array('status' => "Status"),
array('view' => "Option")
);
return transform_headers($headers);
}
function get_fault_report_datarows($faults_data,$controller){
$CI=& get_instance();
$controller_name = strtolower(get_class($CI));
$page_name = ucwords(str_replace("_"," ",$controller_name));
$access_data = $CI->session->userdata('access_data');
$access_update = (int)$access_data[$controller_name]['access_update'];
$edit_opt = "";
$prime_maintenance_fault_report_id = $faults_data->prime_maintenance_fault_report_id;
$driver_name = $faults_data->ntc_driver;
$vehicle_no = $faults_data->ntc_vehicle;
$vehicle_type = $faults_data->vehicle_type;
$status = $faults_data->fault_status;
$fault_status = array(1 => 'Pending',2 => 'Onprogress',3 => 'Completed');
$view_opt = '';
if((int)$status === 1){
$view_opt = anchor($controller_name."/view/$faults_data->prime_maintenance_fault_report_id", '<span class="fa fa-pencil-square-o"></span> Edit',array('class'=>'modal-dlg btn btn-xs btn-edit', 'title'=>"View Faults",'style' => 'width:59px;'));
}else{
$view_opt = "<button onclick = 'view_info($faults_data->prime_maintenance_fault_report_id)' class = 'btn btn-xs btn-edit'><span class='fa fa-eye'></span> View </button>";
}
return array(
'driver_name' => $driver_name,
'vehicle_no' => $vehicle_no,
'vehicle_type' => $vehicle_type,
'status' => $fault_status[$status],
'view' => $view_opt,
'edit' => ""
);
}
/* FAULT REPORT END */
/* WORK ORDER START */
function get_work_order_headers(){
$CI=& get_instance();
$headers = array(
array('job_card_number' => "Job Card Number"),
array('service_type' => "Service Type"),
array('vehicle_no' => "Vehicle No"),
array('date' => "Date"),
array('view' => "Option")
);
return transform_headers($headers);
}
function get_work_order_datarows($receiving_data,$controller){
$CI=& get_instance();
$controller_name = strtolower(get_class($CI));
$page_name = ucwords(str_replace("_"," ",$controller_name));
$access_data = $CI->session->userdata('access_data');
$access_update = (int)$access_data[$controller_name]['access_update'];
$edit_opt = "";
$prime_maintenance_job_schedule_id = $receiving_data->prime_maintenance_job_schedule_id;
$job_card_number = $receiving_data->job_card_number;
$service_type = $receiving_data->service_type;
if($receiving_data->register_no){
$vehicle_no = $receiving_data->register_no;
}else{
$vehicle_no = $receiving_data->vehicle_no;
}
$date = date('d-m-y',strtotime($receiving_data->date));
$driver = $receiving_data->driver;
$km = $receiving_data->km;
$view_option = anchor($controller_name."/view/$receiving_data->prime_maintenance_job_schedule_id", '<span class="fa fa-pencil-square-o"></span> Edit',array('class'=>'modal-dlg btn btn-xs btn-edit', 'title'=>"View Work Order Information"));
return array(
'job_card_number' => $job_card_number,
'service_type' => $service_type,
'vehicle_no' => $vehicle_no,
'date' => $date,
'view' => $view_option,
'edit' => ""
);
}
/* WORK ORDER END */
/* TRANSFORM HEADERS WITHOUT CHECKBOX */
function transform_headers_noncheckbox($array){
$result = array();
foreach($array as $element){
$result[] = array('field' => key($element), 'title' => current($element), 'switchable' => isset($element['switchable']) ? $element['switchable'] : !preg_match('(^$| )', current($element)), 'class' => isset($element['checkbox']) || preg_match('(^$| )', current($element)) ? 'print_hide' : '');
}
return json_encode($result);
}
/* MATERIAL REQUEST START */
function get_material_request_headers(){
$CI=& get_instance();
$headers = array(
array('job_card_number' => "Job Card Number "),
array('request_no' => "Request Number"),
array('request_date' => "Date"),
array('service_category' => "Service Category"),
array('company' => "Company"),
array('vehicle_no' => "Vehicle"),
array('status' => "Status"),
array('view' => "Option")
);
return transform_headers_noncheckbox($headers);
}
function get_material_request_datarows($receiving_data,$controller){
$CI=& get_instance();
$controller_name = strtolower(get_class($CI));
$page_name = ucwords(str_replace("_"," ",$controller_name));
$access_data = $CI->session->userdata('access_data');
$access_update = (int)$access_data[$controller_name]['access_update'];
$edit_opt = "";
$prime_material_request_id = $receiving_data->prime_material_request_id;
$job_card_number = $receiving_data->job_card_number;
$request_no = $receiving_data->request_no;
$request_date = date('d-m-Y',strtotime($receiving_data->request_date));
$company = $receiving_data->company;
$service_category = $receiving_data->service_category;
$vehicle_no = $receiving_data->vehicle_no;
$quantity = $receiving_data->quantity;
$status = $receiving_data->status;
$company_list = array(1 => 'NTC',2 => 'Others');
$view_opt = "";
if($status == "on process"){
$view_opt = anchor($controller_name."/view/$receiving_data->prime_material_request_id", '<span class="fa fa-pencil-square-o"></span> Edit',array('class'=>'modal-dlg btn btn-xs btn-edit', 'title'=>"View Material Request",'style' => 'width:59px;'));
}else{
$view_opt = "<button onclick = 'view_info($receiving_data->prime_material_request_id)' class = 'btn btn-xs btn-edit'><span class='fa fa-eye'></span> View </button>";
}
return array(
'job_card_number' => $job_card_number,
'request_no' => $request_no,
'request_date' => $request_date,
'service_category'=> $service_category,
'company' => $company_list[$company],
'vehicle_no' => $vehicle_no,
'status' => $status,
'view' => $view_opt,
'edit' => ""
);
}
/* MATERIAL REQUEST END */
/* REQUEST RECEIVING START */
function get_request_receiving_headers(){
$CI=& get_instance();
$headers = array(
array('job_card_number' => "Job Card Number "),
array('request_no' => "Request Number"),
array('request_date' => "Date"),
array('company' => "Company"),
array('status' => "Status"),
array('view' => "Option")
);
return transform_headers($headers);
}
function get_request_receiving_datarows($receiving_data,$controller){
$CI=& get_instance();
$controller_name = strtolower(get_class($CI));
$page_name = ucwords(str_replace("_"," ",$controller_name));
$access_data = $CI->session->userdata('access_data');
$access_update = (int)$access_data[$controller_name]['access_update'];
$edit_opt = "";
$prime_material_request_id = $receiving_data->prime_material_request_id;
$job_card_number = $receiving_data->job_card_number;
$request_no = $receiving_data->request_no;
$request_date = date('Y-m-d',strtotime($receiving_data->request_date));
$company = $receiving_data->company;
$status = $receiving_data->status;
$company_list = array(1 => 'NTC',2 => 'Others');
$view_opt = "*****";
if($status == "on process"){
$view_opt = anchor($controller_name."/view/$receiving_data->prime_material_request_id", '<span class="fa fa-pencil-square-o"></span> Edit',array('class'=>'modal-dlg btn btn-xs btn-edit', 'title'=>"View Request Receiving",'style' => 'width:59px;'));
}else{
$view_opt = "<button onclick = 'view_items($receiving_data->prime_material_request_id)' class = 'btn btn-xs btn-edit'><span class='fa fa-eye'></span> View </button>";
}
return array(
'job_card_number' => $job_card_number,
'request_no' => $request_no,
'request_date' => $request_date,
'company' => $company_list[$company],
'status' => $status,
'view' => $view_opt,
'edit' => ""
);
}
/* REQUEST RECEIVING END */
/* PURCHASE HISTORY START */
function get_purchase_history_headers(){
$CI=& get_instance();
$headers = array(
array('pod_number' => "PO Number"),
array('supplier_name' => "Supplier Name"),
array('entry_date' => "Entry Date"),
array('total_amount' => "Total Amount"),
array('po_status' => "Status"),
array('view' => "Option")
);
return transform_headers($headers);
}
function get_purchase_history_datarows($purchase_data,$controller){
$CI=& get_instance();
$controller_name = strtolower(get_class($CI));
$page_name = ucwords(str_replace("_"," ",$controller_name));
$access_data = $CI->session->userdata('access_data');
$access_update = (int)$access_data[$controller_name]['access_update'];
$edit_opt = "";
$prime_purchase_item_id = $purchase_data->prime_purchase_item_id;
$prime_purchase_order_id = $purchase_data->prime_purchase_order_id;
$pod_number = $purchase_data->pod_number;
$supplier_name = $purchase_data->supplier_name;
$po_status = $purchase_data->po_status;
$total_amount = $purchase_data->total_amount;
$entry_date = date('d-m-Y',strtotime($purchase_data->entry_date));
if((int)$po_status === 1){
$edit_opt = "<button onclick = 'edit_pod_info($prime_purchase_order_id)' class = 'btn btn-xs btn-edit'><span class='fa fa-pencil-square-o'></span> Edit </button>";
}else{
$edit_opt = anchor($controller_name."/view_info/$prime_purchase_order_id", '<span class="fa fa-eye"></span> View',array('class'=>'modal-dlg btn btn-xs btn-edit', 'title'=>"View Purchase History ",'style' => 'width:59px;'));
}
$status_list = array(1 => "Pending",2 => "Received",3 => "Return");
$po_status = $status_list[$po_status];
return array(
'pod_number' => $pod_number,
'supplier_name' => $supplier_name,
'entry_date' => $entry_date,
'total_amount' => $total_amount,
'po_status' => $po_status,
'view' => $edit_opt,
'edit' => ""
);
}
/* PURCHASE HISTORY END */
/* TYRE SURVEY REPORT START */
function get_tyre_survey_headers(){
$CI=& get_instance();
$headers = array(
//array('survey_type' => "Survey Type"),
array('name' => "Name"),
array('date' => "Date"),
array('vehicle_no' => "Vehicle Number"),
array('total_positions'=> "Total Survey"),
array('pending' => "Pending"),
array('view' => "Option")
);
return transform_headers($headers);
}
function get_tyre_survey_datarows($survey,$controller){
$CI=& get_instance();
$controller_name = strtolower(get_class($CI));
$page_name = ucwords(str_replace("_"," ",$controller_name));
$access_data = $CI->session->userdata('access_data');
$access_update = (int)$access_data[$controller_name]['access_update'];
$total_no_of_tyre = $survey->total_no_of_tyre;
$spare_count = $survey->spare_count;
$total_positions = $total_no_of_tyre;
$prime_tyre_survey_id = $survey->prime_tyre_survey_id;
$name = $survey->name;
$date = date('d-m-Y',strtotime($survey->date));
$vehicle_no = $survey->vehicle_no;
$num_rows = $survey->num_rows;
$pending = (int)$total_positions - (int)$num_rows;
$type = $survey->survey_type;
$survey_type = array(1 => 'Att tyre',2 => 'Ntc tyre');
$view_opt = '';
$view_opt = anchor($controller_name."/view/$survey->prime_tyre_survey_id", '<span class="fa fa-pencil-square-o"></span> Edit',array('class'=>'modal-dlg btn btn-xs btn-edit', 'title'=>"View Survey",'style' => 'width:59px;'));
return array(
'name' => $name,
'date' => $date,
'vehicle_no' => $vehicle_no,
'total_positions' => (int)$total_positions,
'pending' => $pending,
'view' => $view_opt,
'edit' => ""
);
}
/* TYRE SURVEY REPORT END */
/* REMOVING AND FITTING START */
function get_removing_and_fitting_headers(){
$CI=& get_instance();
$headers = array(
array('date' => "Date"),
array('vehicle_no' => "Vehicle Number"),
array('survey_status' => "Survey Status"),
array('tyre_position' => "Tyre Position"),
array('tyre_status' => "Tyre Status"),
array('status' => "Overall Status"),
array('view' => "Option")
);
return transform_headers($headers);
}
function get_removing_and_fitting_datarows($result_data,$controller){
$CI=& get_instance();
$controller_name = strtolower(get_class($CI));
$page_name = ucwords(str_replace("_"," ",$controller_name));
$access_data = $CI->session->userdata('access_data');
$access_update = (int)$access_data[$controller_name]['access_update'];
$date = date('d-m-Y',strtotime($result_data->date));
$vehicle_no = $result_data->vehicle_no;
$tyre_position = $result_data->tyre_position;
$survey_status = $result_data->survey_status;
$tyre_status_list = array(1=> 'New',2 => 'Recap1',3 => 'Recap2',4 => 'Recap3');
if($result_data->fitting_tyre_status){
$tyre_status = $tyre_status_list[$result_data->fitting_tyre_status];
}else{
$tyre_status = "Not Updated";
}
$status = $result_data->status;
$survey_status_list = array(1 => 'Recap',2 => 'Repair',3=> 'Claim',4 => 'Permanently Remove');
$status_list = array(1 => 'Pending',2 => 'Completed');
$view_opt = anchor($controller_name."/view/$result_data->prime_removing_fitting_id", '<span class="fa fa-pencil-square-o"></span> Edit',array('class'=>'modal-dlg btn btn-xs btn-edit', 'title'=>"View Removing And Fitting",'style' => 'width:59px;'));
return array(
'date' => $date,
'vehicle_no' => $vehicle_no,
'survey_status' => $survey_status_list[$survey_status],
'tyre_position' => "Position ".$tyre_position,
'tyre_status' => $tyre_status,
'status' => $status_list[$status],
'view' => $view_opt
);
}
/* TYRE SURVEY REPORT END */
/* TYRE SCRAP START */
function get_tyre_scrap_headers(){
$CI=& get_instance();
$headers = array(
//array('date' => "Date"),
//array('suplier_type' => "Supplier Type"),
array('vehicle_no' => "Vehicle Number"),
array('tyre_position' => "Tyre Position"),
array('serial_number' => "Serial number"),
array('brand' => "Brand"),
array('status' => "Status"),
array('view' => "Option")
);
return transform_headers($headers);
}
function get_tyre_scrap_datarows($result_data,$controller){
$CI=& get_instance();
$controller_name = strtolower(get_class($CI));
$page_name = ucwords(str_replace("_"," ",$controller_name));
$access_data = $CI->session->userdata('access_data');
$access_update = (int)$access_data[$controller_name]['access_update'];
$date = date('d-m-Y',strtotime($result_data->date));
$vehicle_no = $result_data->vehicle_no;
$tyre_position = $result_data->tyre_position;
$supplier_type = $result_data->supplier_type;
$status = $result_data->status;
$serial_number = $result_data->serial_number;
$brand = $result_data->brand_name;
$supplier_type_list = array(1 => 'Att',2 => 'Leader Tread');
$status_list = array(1 => 'Pending',2 => 'Completed');
$view_opt = anchor($controller_name."/view/$result_data->prime_tyre_scrap_id", '<span class="fa fa-pencil-square-o"></span> Edit',array('class'=>'modal-dlg btn btn-xs btn-edit', 'title'=>"View Tyre scrap",'style' => 'width:59px;'));
return array(
//'date' => $date,
//'suplier_type' => $supplier_type_list[$supplier_type],
'vehicle_no' => $vehicle_no,
'tyre_position' => "Position ".$tyre_position,
'serial_number' => $serial_number,
'brand' => $brand,
'status' => $status_list[$status],
'view' => $view_opt
);
}
/* TYRE SCRAP END */
/* EQUIPMENT REQUEST START */
function get_equipment_request_headers(){
$CI=& get_instance();
$headers = array(
array('equipment_name' => "Equipment Name"),
array('labour_name' => "Labour Name"),
array('start_date' => "Start Date"),
array('estimate_date' => "Estimate date"),
array('status' => "Status"),
array('view' => "Option")
);
return transform_headers($headers);
}
function get_equipment_request_datarows($result_data,$controller){
$CI=& get_instance();
$controller_name = strtolower(get_class($CI));
$page_name = ucwords(str_replace("_"," ",$controller_name));
$access_data = $CI->session->userdata('access_data');
$access_update = (int)$access_data[$controller_name]['access_update'];
$start_date = date('d-m-Y',strtotime($result_data->start_date));
$estimate_date = date('d-m-Y',strtotime($result_data->estimate_date));
$equipment_name = $result_data->equipment_name;
$labour_name = $result_data->employee_name;
$supplier_type = $result_data->supplier_type;
$status = $result_data->status;
$status_list = array(1 => 'On Process',2 => 'return');
$view_opt = anchor($controller_name."/view/$result_data->prime_equipment_request_id", '<span class="fa fa-pencil-square-o"></span> Edit',array('class'=>'modal-dlg btn btn-xs btn-edit', 'title'=>"View Equipment Request",'style' => 'width:59px;'));
return array(
'equipment_name' => $equipment_name,
'labour_name' => $labour_name,
'start_date' => $start_date,
'estimate_date' => $estimate_date,
'status' => $status_list[$status],
'view' => $view_opt
);
}
/* EQUIPMENT REQUEST END */
?>