";
}
if($appointment_type=='O' && isAccessible($_SESSION['RoleId'],$menu_key,'R')){
$pdf_link="";
}
if(isAccessible($_SESSION['RoleId'],$menu_key,'R'))
{
$view_link="";
}
if(isAccessible($_SESSION['RoleId'],$menu_key,'W'))
{
$edit_link="";
}
$space=" ";
$history_links = $space.$view_link.$space.$edit_link.$space.$pdf_link;
$isEmergency ="";
$isInjury="";
if ($appointment_type == 'I') {
$isInjury = "Yes";
}else{
$isInjury = "No";
}
if ($row_employee_appointment['IsEmergency'] == 1) {
$isEmergency = "Yes";
}else{
$isEmergency = "No";
}
$complaint_ids = $row_employee_appointment['complaints'];
$complaint_ids_array = array();
$complaint_ids_array = explode(",", $complaint_ids);
$complaints = "";
for ($i = 0; $i < count($complaint_ids_array); $i++) {
if ($i == 0) {
if (is_numeric($complaint_ids_array[$i])) {
$complaints = getTableFieldValue('complaints', 'complaint', 'complaint_id', $complaint_ids_array[$i]);
} else {
$complaints = $complaint_ids_array[$i];
}
} else {
if (is_numeric($complaint_ids_array[$i])) {
$complaints = $complaints . "," . getTableFieldValue('complaints', 'complaint', 'complaint_id', $complaint_ids_array[$i]);
} else {
$complaints = $complaints . "," . $complaint_ids_array[$i];
}
}
}
$doctor_attended_flag="No";
if ($row_employee_appointment['doctor_attended_flag'] == 'Y') {
$doctor_attended_flag = "Yes";
}else{
$doctor_attended_flag = "No";
}
$check_results = "SBP:".$row_employee_appointment['bp_sbp'].", DBP:".$row_employee_appointment['bp_dbp'].", FBS:".$row_employee_appointment['blood_sugar_fbs'].", RBS:".$row_employee_appointment['blood_sugar_rbs'].", Temp:".$row_employee_appointment['temperature'].", SPOC2%:".$row_employee_appointment['spo2_percent'];
$referral = getCommaSeperatedValuesForInClause("select referral_point_name from referral_point ", "referral_point_id ", $row_employee_appointment['referral']);
$findings = getCommaSeperatedValuesForInClause("select examination_finding from examination_findings ", "id", $row_employee_appointment['examination_remarks']);
$diagnosis = getCommaSeperatedValuesForInClause("select ailment_name from ailment ", "ailment_id", $row_employee_appointment['ailments_new']);
$data['rows'][] = array(
'id' => $row_employee_appointment['appointment_id'],
'cell' => array($count++,$history_links, date_format(date_create($row_employee_appointment['appointment_date']),"d-M-Y H:i A"),$row_employee_appointment['ticket_no'], $row_employee_appointment['emp_code'],$row_employee_appointment['patient_name'], $isEmergency, $isInjury,$doctor_attended_flag, $complaints,$findings,$diagnosis,getTreatmentText($row_employee_appointment['appointment_id']),$referral,$row_employee_appointment['followup'],$check_results )
);
}
$data['rows'][] = array(
'id' => $row['filterkey'],
'cell' => array('', "", "", '', '','', '', '', '', '', '', '', '','', '', '','', '', '','')
);
echo json_encode($data);
?>