0) {
while ($row = mysqli_fetch_assoc($result)) {
$app_q=" select date(appointment_date) + INTERVAL chronic_day DAY AS DATE,date(appointment_date) as app_date,appointment_id,ohc_type_id,emp_id from employee_appointment where appointment_id=(select max(appointment_id) from employee_appointment where emp_id='".$row['emp_id']."' and chronic_day!=0 ) ";
if (!$result_app_q = @mysqli_query($conn,$app_q)) {
rollback();
exit(mysqli_error($conn));
}
if(mysqli_num_rows($result_app_q) > 0) {
while ($row_app_q = mysqli_fetch_assoc($result_app_q)) {
$emp_mail = getTableFieldValue('patient_master','offiial_email_id','id',$row_app_q['emp_id']);
$emp_name = getTableFieldValue('patient_master','patient_name','id',$row_app_q['emp_id']);
$ohc = getTableFieldValue('ohc_type','ohc_type_name','ohc_type_id',$row_app_q['ohc_type_id']);
$cronic_date=$row_app_q['DATE'];
if($cronic_dateopen_mail('".$emp_mail."','".$emp_name."','".$ohc."','".$row_app_q['appointment_id']."','".date($row_app_q['app_date'])."')";
}
}
}
}
$data['status'] = "succes";
$data['message'] = "Assign menu done!";
}
else
{
$data['status'] = 200;
$data['message'] = "Data not found!";
}
commit();
echo json_encode($data);
?>