=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++) { error_log("year:" . $year1[$j] . " size:" . sizeof($year1)); $qry_date = ""; $qry_doj = ""; $qry_date .= "and year(medical_entry_date) ='" . $year1[$j] . "'"; $qry_doj .= "and year(doj) <= '" . $year1[$j] . "'"; $query = "SELECT max(medical_exam_id),m.smoking,p.patient_name from medical_examination m right join patient_master p on m.patient_id = p.id where patient_id in (SELECT id FROM patient_master p where status='Active' $qry_filter $qry_doj) $qry_date1 $qry_date and m.smoking='1' GROUP by patient_id"; $result = mysqli_query($conn, $query); ?>
EMPLOYEE HABIT DISTRIBUTION REPORT
Run Date :      User :
Filters Applied- Range: to , EMPLOYER/CONTRACTOR:, Gender:, OHC Location:, Patient Category:, Department:, Designation:, Employee Cadre:, Month:, Year:
For Year
SMOKING
Patient Name
No Records
ALCOHOL
Patient Name
No Records
TOBACCO
Patient Name
No Records
SMOKING + TOBACCO
Patient Name
No Records
SMOKING + ALCOHOL
Patient Name
No Records
TOBACCO + ALCOHOL
Patient Name
No Records
SMOKING + TOBACCO + ALCOHOL
Patient Name
No Records
For Year
SMOKING
Patient Name
No Records
ALCOHOL
Patient Name
No Records
TOBACCO
Patient Name
No Records
SMOKING + TOBACCO
Patient Name
No Records
SMOKING + ALCOHOL
Patient Name
No Records
TOBACCO + ALCOHOL
Patient Name
No Records
SMOKING + TOBACCO + ALCOHOL
Patient Name
No Records