File: /home/cafsindia/login_cafsindia_com/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 === "portfolio"){
$headers[]['send_email'] = '';
}
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($access_update === 1){
$view_id = $search_data->$prime_id;
if($controller_name === "portfolio"){
$rm_status = $data_row['rm_status'];
$login_status = $data_row['login_status'];
$logged_role = (int)$CI->session->userdata('logged_role');
if(($rm_status === 'Completed') && ($logged_role === 3)){
$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','title'=>"Update $page_name"));
}else{
$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(($rm_status === 'Completed') && ($logged_role != 3) && ($login_status === 'Login')){
$data_row['send_email'] = "<a onclick = 'send_mail($view_id)' class = 'btn btn-xs btn-edit'><span class='fa fa-envelope-square'></span> Send Mail </a>";
}
}else{
$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"));
}
}
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);
}
$headers[]['trans_created_date'] = 'Created date';
$headers[]['trans_updated_date'] = 'Updated date';
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&";
}
//print_r($search_data); die;
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 === "30/11/-0001")){
$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
if((int)$field_type === 13){
$value = date('d/m/Y',strtotime($search_data->$label_name));
if(($value === "01/01/1970")||($value === "30/11/-0001")){
$value = "-";
}else{
$value = date('d/m/Y H:i:s',strtotime($search_data->$label_name));
}
}else{
if($value){
if($label_name === 'contact_number' || $label_name === 'alter_contact_number' || $label_name === 'contact_no' || $label_name === 'proposer_mobile_no' || $label_name === 'assured_mobile_no' || $label_name === "life_assured_alter_number"){
$value = "**********";
}else
if($report_name === "Health Report" && $label_name === "policy_number"){
$value = "'".$search_data->$label_name."'";
}else{
$value = $search_data->$label_name;
}
}else{
$value = "-";
}
}
$data_row[$label_name] = $value;
}
if($report_name === "Insurance Details" || $report_name === "Health Report" || $report_name === "Life Renewals Report" || $report_name === "Health Renewals Report"){
$data_row['trans_created_date'] = date("d-m-Y H:i:s",strtotime($search_data->trans_created_date));
$data_row['trans_updated_date'] = date("d-m-Y H:i:s",strtotime($search_data->trans_updated_date));
}
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 days_difference($check_date){
$begin_date = new DateTime();
$begin_date = $begin_date->format("Y-m-d");
$end_date = new DateTime($check_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);
$d1 = new DateTime();
$d2 = new DateTime($check_date);
if($d1 > $d2){
$diff = "-".$diff;
}
return $diff;
}
?>