";
// }
if($hasWriteAccess )
{
$edit_link="";
}
if($hasExecuteAccess)
{
$delete_link="";
}
$date_time = date_format(date_create($row1['date']), "d-m-Y ");
$time_app = getCommaSeperatedValuesForInClause("select TIME_FORMAT(slot, '%h:%i %p') as slot from appoinment_slots ","slot_id",$row1['time']);
if($row1['app_type']=='FIT'){
$row1['app_type']='Sickness/Fitness';
}else if($row1['app_type']=='MED'){
$row1['app_type']='Periodic Health Checkup';
}
$patient_name = getTableFieldValue('patient_master', 'patient_name', 'id', $row1['emp_id']);
$doctor_name = getTableFieldValue('patient_master', 'patient_name', 'id', $row1['doctor_id']);
if($row1['status']=='BOOKED'){
$status = " Pending
";
}else if($row1['status']=='DRP'){
$status = " Pending
";
}else if($row1['status']=='DRA'){
$status = " Completed
";
}else if($row1['status']=='CANCELLED'){
$status = " Cancelled
";
}
$space=" ";
$links = $assign_link.$space.$view_link.$space.$edit_link.$space.$delete_link;
$data['rows'][] = array(
'id' => $row1['city_id'],
'cell' => array($count++,$date_time,$time_app,$patient_name,$doctor_name,$row1['app_type'],$status,$links));
}
$data['rows'][] = array(
'id' => $row['filterkey'],
'cell' => array('', "", "", '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '')
);
echo json_encode($data);
?>