|
Medical Exam. Date |
Follow-up Date |
Name |
ECode/G.Pass |
Designation |
Devision |
Department |
Ute |
Section |
Mobile No. |
Case Type |
Complaints |
Diagnosis |
Body System |
Disease Type |
Treatment |
Health Advice |
Additional Recommendation if any |
Ecg Finding |
Doctor Recommended Test |
Additional Precaution |
Follow-up Remark if Any |
=0;$j--){
if($j!=0){
$madExamStart=$examination_finded_arr[$empid][$j];
$madExamend= $examination_finded_arr[$empid][$j-1];
$sql_follow_up="select e.*,p.*,e.appointment_date as follow_up_date from employee_appointment e join patient_master p on e.emp_id=p.id where date_format(date(e.appointment_date),'%Y-%m-%d') between STR_TO_DATE('".$examination_finded_arr[$empid][$j]."','%Y-%m-%d') and STR_TO_DATE('".$examination_finded_arr[$empid][$j-1]."','%Y-%m-%d') and e.emp_id='".$empid."' and e.case_type='EFUP' ";
}else{
$madExamStart=$examination_finded_arr[$empid][$j];
$madExamend= $end;
$sql_follow_up="select e.*,p.*,e.appointment_date as follow_up_date from employee_appointment e join patient_master p on e.emp_id=p.id where date_format(date(e.appointment_date),'%Y-%m-%d') between STR_TO_DATE('".$examination_finded_arr[$empid][$j]."','%Y-%m-%d') and STR_TO_DATE('".$end."','%d-%m-%Y') and e.emp_id='".$empid."' and e.case_type='EFUP' "; }
error_log($empid.'follow-up_sql'.$sql_follow_up);
$result_sql_follow_up = mysqli_query($conn,$sql_follow_up);
// $num_rows = mysqli_num_rows($result_sqll);
while( $row_follow_up = mysqli_fetch_assoc($result_sql_follow_up)){
error_log($empid.'follow-up'.$row_follow_up['follow_up_date']);
?>