=str_to_date('" . $start_date . "','%d-%m-%Y') "; } if (isset($end_date) && $end_date != '') { $qry_filter .= " and date(doj) <=str_to_date('" . $end_date . "','%d-%m-%Y') "; } if (isset($month) && $month != '') { $qry_filter .= " and month(doj) in (" . $month . ")"; } ?> 1) { for ($j = 0; $j < sizeof($year1); $j++) { error_log("year:" . $year1[$j] . " size:" . sizeof($year1)); $qry_date = ""; $qry_date .= "and year(doj) <='" . $year1[$j] . "'"; $query = "select patient_name FROM patient_master where (datediff(CURRENT_DATE,doj)/365)>=0 and (datediff(CURRENT_DATE,doj)/365)<2 and status='Active' $qry_date $qry_filter"; $result = mysqli_query($conn, $query); ?> =2 and (datediff(CURRENT_DATE,doj)/365)<5 and status='Active' $qry_date $qry_filter"; $result = mysqli_query($conn, $query); ?> =5 and (datediff(CURRENT_DATE,doj)/365)<10 and status='Active' $qry_date $qry_filter"; $result = mysqli_query($conn, $query); ?> =10 and (datediff(CURRENT_DATE,doj)/365)<15 and status='Active' $qry_date $qry_filter"; $result = mysqli_query($conn, $query); ?> =15 and (datediff(CURRENT_DATE,doj)/365)<20 and status='Active' $qry_date $qry_filter"; $result = mysqli_query($conn, $query); ?> =20 and (datediff(CURRENT_DATE,doj)/365)<25 and status='Active' $qry_date $qry_filter"; $result = mysqli_query($conn, $query); ?> =25 and status='Active' $qry_date $qry_filter"; $result = mysqli_query($conn, $query); ?> =0 and (datediff(CURRENT_DATE,doj)/365)<2 and status='Active' $qry_filter"; $result = mysqli_query($conn, $query); ?> =2 and (datediff(CURRENT_DATE,doj)/365)<5 and status='Active' $qry_filter"; $result = mysqli_query($conn, $query); ?> =5 and (datediff(CURRENT_DATE,doj)/365)<10 and status='Active' $qry_filter"; $result = mysqli_query($conn, $query); ?> =10 and (datediff(CURRENT_DATE,doj)/365)<15 and status='Active' $qry_filter"; $result = mysqli_query($conn, $query); ?> =15 and (datediff(CURRENT_DATE,doj)/365)<20 and status='Active' $qry_filter"; $result = mysqli_query($conn, $query); ?> =20 and (datediff(CURRENT_DATE,doj)/365)<25 and status='Active' $qry_filter"; $result = mysqli_query($conn, $query); ?> =25 and status='Active' $qry_filter"; $result = mysqli_query($conn, $query); ?>

Duration Of Exposure Distribution Employee Report

Run Date :      User :

Filters Applied- Range: to , EMPLOYER/CONTRACTOR:, Gender:, OHC Location:, Patient Category:, Department:, Designation:, Employee Cadre:, Month:, Year:

For year:

Duration in years(00-02)

Patient Name

Duration in years(02-05)

Patient Name

Duration in years(05-10)

Patient Name

Duration in years(10-15)

Patient Name

Duration in years(15-20)

Patient Name

Duration in years(20-25)

Patient Name

Duration in years(>25)

Patient Name

Duration in years(00-02)

Patient Name

Duration in years(02-05)

Patient Name

Duration in years(05-10)

Patient Name

Duration in years(10-15)

Patient Name

Duration in years(15-20)

Patient Name

Duration in years(20-25)

Patient Name

Duration in years(>25)

Patient Name