Pending

"; }else if($fetch['status']=='DRP'){ $fetch['status'] = "

Pending

"; }else if($fetch['status']=='DRA'){ $fetch['status'] = "

Completed

"; }else if($fetch['status']=='CANCELLED'){ $fetch['status'] = "

Cancelled

"; } array_push($data ,array( 'id' => $fetch['id'], 'app_type' => $fetch['app_type'], 'status' => $fetch['status'], 'date' => date_format(date_create($fetch['date']), "d-m-Y ") , 'patient_name' => getTableFieldValue('patient_master', 'patient_name', 'id', $fetch['emp_id']), 'doctor_name' => getTableFieldValue('patient_master', 'patient_name', 'id', $fetch['doctor_id']), 'time' => getCommaSeperatedValuesForInClause("select TIME_FORMAT(slot, '%h:%i %p') as slot from appoinment_slots ", "slot_id", $fetch['time']), )); } $data['count']=$count; error_log('apps' . print_r($data, true)); echo json_encode($data);