" . $sql_link); $results_calibration = mysqli_query($conn, $sql_link); rollback(); $count = ($page - 1) * $rp + 1; // echo $sql_ailment; // echo $access_level; while ($row1 = mysqli_fetch_assoc($results_calibration)) { $id = $row1['link_id']; $detail = ""; $param_name = getFieldFromTable('parameter_name', 'checkup_parameter', 'checkup_parameter_id', $row1['checkup_parameter_id']); $section_id = getFieldFromTable('checkup_form_section_id', 'checkup_parameter', 'checkup_parameter_id', $row1['checkup_parameter_id']); $section_name = getFieldFromTable('section_name', 'checkup_form_section', 'section_id', $section_id); $detail = " Section=> (" . $section_name . ") (Parameter Name=> " . $param_name . ")"; $device = getFieldFromTable('device_name', 'device_master', 'device_id', $row1['device_id']); // echo $Department_id; $view_link = ""; $edit_link = ""; $delete_link = ""; $links = ""; // if ($hasReadAccess) { // $view_link = ""; // } if ($hasWriteAccess) { $edit_link = ""; } if ($hasExecuteAccess) { $delete_link = ""; } $space = "   "; $links = $assign_link . $space . $view_link . $space . $edit_link . $space . $delete_link; // error_log("calibration_equp".$calibration_equp); $data['rows'][] = array( 'id' => $row1['id'], 'cell' => array( $links, $count++, $detail, $device, $row1['device_param_code'] ) ); } commit(); $data['rows'][] = array( 'id' => $row['filterkey'], 'cell' => array('', "", "", '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '') ); echo json_encode($data); ?>