=str_to_date('" . $start_date . "','%d-%m-%Y') ";
}
if (isset($start_date) && $start_date != '') {
$qry_date1 .= " and date(medical_entry_date) >=str_to_date('" . $start_date . "','%d-%m-%Y') ";
}
if (isset($end_date) && $end_date != '') {
$qry_date1 .= " and date(medical_entry_date) <=str_to_date('" . $end_date . "','%d-%m-%Y') ";
}
if (isset($month) && $month != '') {
$qry_date1 .= " and month(medical_entry_date) in (" . $month . ")";
}
?>
1) {
for ($j = 0; $j < sizeof($year1); $j++) {
$qry_date = "";
$qry_doj = "";
$qry_date .= " and year(medical_entry_date) ='" . $year1[$j] . "'";
$qry_doj .= " and year(doj) <= '".$year1[$j]."'";
?>
| DESIGNATION WISE EMPLOYEE OVERWEIGHT REPORT For
|
| Run Date : User : |
| Filters Applied-
Range: to ,
EMPLOYER/CONTRACTOR:,
Gender:,
OHC Location:,
Patient Category:,
designation:,
Designation:,
Employee Cadre:,
Month:,
Year:
|
| Designation Names |
|
| Patient Name |
=25 and bmi<30 GROUP BY patient_id ORDER BY patient_id asc";
$id_result = mysqli_query($conn, $id_query);
if (mysqli_num_rows($id_result)) {
while ($row_id = mysqli_fetch_assoc($id_result)) {
?>
|
| No Result |
| DESIGNATION WISE EMPLOYEE OVERWEIGHT REPORT |
| Run Date : User : |
|
Filters Applied-
Range: to ,
EMPLOYER/CONTRACTOR:,
Gender:,
OHC Location:,
Patient Category:,
designation:,
Designation:,
Employee Cadre:,
Month:,
Year:
|
| DESIGNATION Names |
|
| Patient Name |
=25 and bmi<30 GROUP BY patient_id ORDER BY patient_id asc";
$id_result = mysqli_query($conn, $id_query);
if (mysqli_num_rows($id_result)) {
while ($row_id = mysqli_fetch_assoc($id_result)) {
?>
|
| No Result |