CRITICAL ILLNESS WISE EMPLOYEE REPORT For =$year1[$j]?> |
Run Date : echo date("d-M-Y"); ?> |
User : echo $username ?> |
Filters Applied-
Range: echo $start_date;?> to echo $end_date ;?>,
EMPLOYER/CONTRACTOR:,
Gender:,
OHC Location:,
Patient Category:,
Department:,
Illness:,
Designation:,
Employee Cadre:,
Month:,
Year:
|
Illness Name |
Patient Name |
error_reporting(E_ERROR | E_PARSE);
$param_query = "select param_id, param_name from history_parameter $qry_filter1";
$result_param = mysqli_query($conn, $param_query);
while($param_row = mysqli_fetch_assoc($result_param)){
$param_id = $param_row['param_id'];
?>
=$param_row['param_name']?> |
$id_query = "select id from patient_master where status='Active' $qry_filter";
$id_result = mysqli_query($conn, $id_query);
while($row_id = mysqli_fetch_assoc($id_result)){
// $pat_info = "select patient_id from medical_examination where past_present_illness in ($param_id) and medical_exam_id = (select max(medical_exam_id) from medical_examination where patient_id='".$row_id['id']."') $qry_date1 $qry_date";
// $pat_result = mysqli_query($conn, $pat_info);
// $pat_row = mysqli_fetch_assoc($pat_result);
$count_bmi = "select patient_name from patient_master where id = (select patient_id from medical_examination where past_present_illness in ($param_id) and medical_exam_id = (select max(medical_exam_id) from medical_examination where patient_id='".$row_id['id']."') $qry_date1 $qry_date)";
$bmi_result = mysqli_query($conn, $count_bmi);
error_log("count_bmi::".$pat_info);
while($row_bmi = mysqli_fetch_assoc($bmi_result)){
?>
=$param_row['param_name']?> |
= $row_bmi['patient_name']?> |
}
}
?>
}
}
}else{
if(isset($year2) && $year2!=''){
$qry_date1.=" and year(medical_entry_date) ='".$year2."'";
}
?>
CRITICAL ILLNESS WISE EMPLOYEE REPORT |
Run Date : echo date("d-M-Y"); ?> |
User : echo $username ?> |
Filters Applied-
Range: echo $start_date;?> to echo $end_date ;?>,
EMPLOYER/CONTRACTOR:,
Gender:,
OHC Location:,
Patient Category:,
Department:,
Illness:,
Designation:,
Employee Cadre:,
Month:,
Year:
|
ILLNESS NAME |
PATIENT NAME |
error_reporting(E_ERROR | E_PARSE);
$param_query = "select param_id,param_name from history_parameter $qry_filter1";
$result_param = mysqli_query($conn, $param_query);
while($param_row = mysqli_fetch_assoc($result_param)){
$param_id = $param_row['param_id'];
?>
|
$id_query = "select id from patient_master where status='Active' $qry_filter";
$id_result = mysqli_query($conn, $id_query);
while($row_id = mysqli_fetch_assoc($id_result)){
// $pat_info = "select patient_id from medical_examination where past_present_illness in ($param_id) and medical_exam_id = (select max(medical_exam_id) from medical_examination where patient_id='".$row_id['id']."') $qry_date1";
// $pat_result = mysqli_query($conn, $pat_info);
// $pat_row = mysqli_fetch_assoc($pat_result);
$count_bmi = "select patient_name from patient_master where id = (select patient_id from medical_examination where past_present_illness in ($param_id) and medical_exam_id = (select max(medical_exam_id) from medical_examination where patient_id='".$row_id['id']."') $qry_date1)";
$bmi_result = mysqli_query($conn, $count_bmi);
error_log("count_bmi::".$count_bmi);
while($row_bmi = mysqli_fetch_assoc($bmi_result)){
?>
=$param_row['param_name']?> |
= $row_bmi['patient_name']?> |
}
}
?>
}
}
?>