";
// }
//if($hasExecuteAccess){
$delete_link = "";
// }
// if($hasReadAccess){
$view_link = "";
// }
$pdf_link = "";
$emp_name = getTableFieldValue('employee',"CONCAT(fname,' ',lname)",'id',$row['emp_id']);
$checkupDate = date_format(date_create($row['checkup_date']),"d-M-Y h:i:sa ");
$hygieneId = $row['hygiene_id'];
$parameter_name="";
$hyg_param_val="";
$range="";
$sql_human_hyg_parameter="select * from emp_hyg_check_items i left join hygiene h on i.hyg_para_id=h.hygiene_id where hyg_check_id='".$id."'";
//echo $sql_human_hyg_parameter;
$results_human_hyg_parameter =@mysqli_query($conn,$sql_human_hyg_parameter);
while ($row_human_hyg_parameter=@mysqli_fetch_assoc($results_human_hyg_parameter)) {
$parameter_name = $parameter_name.' '.getTableFieldValue('hygiene','hygiene_parameter','hygiene_id',$row_human_hyg_parameter['hyg_para_id']).'
';
$hyg_param_val=$hyg_param_val.' '.$row_human_hyg_parameter['hyg_param_val'].'
';
$emp_min_range=$row_human_hyg_parameter['human_min_range'];
$emp_max_range=$row_human_hyg_parameter['human_max_range'];
$range=$range.''.$emp_min_range."-".$emp_max_range.'
';
}
// getTreatmentText($row_employee_appointment['hyg_check_id']);
$space = " ";
$links = $view_link . $space . $edit_link . $space . $delete_link . $space . $pdf_link;
$data['rows'][] = array(
'hygiene_id' => $row['hygiene_id'],
'cell' => array(
$count ++,
$emp_name,
$parameter_name,
$range,
$hyg_param_val,
$checkupDate,
$links
)
);
}
echo json_encode($data);
?>