='".$start_date."' ";
$qry_date.=" and medical_entry_date >=str_to_date('".$start_date."','%d-%m-%Y') ";
}
if(isset($end_date) && $end_date!=''){
//$qry_date.=" and checkup_date <='".$end_date."' ";
$qry_date.=" and medical_entry_date <=str_to_date('".$end_date."','%d-%m-%Y') ";
}
/* starting from 18 to 25 */
$query1="select id FROM patient_master where YEAR(CURDATE())-year(doj)>=0 and YEAR(CURDATE())-year(doj)<2 ".$qry_bu;
$query="SELECT count(DISTINCT(patient_id)) as total from medical_examination where (air_cond_left is not null AND air_cond_left!='') AND (air_cond_right is not null AND air_cond_right!='') AND (bone_cond_left is not null AND bone_cond_left!='') AND (bone_cond_right is not null AND bone_cond_right!='') and patient_id in ($query1) $qry_date";
//echo $query;
$query="SELECT patient_master.patient_name from medical_examination INNER JOIN patient_master ON medical_examination.patient_id = patient_master.id where (air_cond_left='abnormal' or air_cond_right='abnormal' or bone_cond_left='abnormal' or bone_cond_right='abnormal' ) and patient_id in ($query1) $qry_date";
$result = mysqli_query($conn,$query);
//echo $query;
?>
DURATION OF SERVICE AND ABNORMAL AUDIOMETRY REPORT
=2 and YEAR(CURDATE())-year(doj)<5 ".$qry_bu;
$query="SELECT count(*) as total from medical_examination where (air_cond_left is not null AND air_cond_left!='') AND (air_cond_right is not null AND air_cond_right!='') AND (bone_cond_left is not null AND bone_cond_left!='') AND (bone_cond_right is not null AND bone_cond_right!='') and patient_id in ($query1) $qry_date";
//echo $query;
$query="SELECT patient_master.patient_name from medical_examination INNER JOIN patient_master ON medical_examination.patient_id = patient_master.id where (air_cond_left='abnormal' or air_cond_right='abnormal' or bone_cond_left='abnormal' or bone_cond_right='abnormal' ) and patient_id in ($query1) $qry_date ";
//echo $query;
$result = mysqli_query($conn,$query);
//echo $query;
?>
Duration of service(2-5)
Patient Name
=5 and YEAR(CURDATE())-year(doj)<10 ".$qry_bu;
$query="SELECT count(*) as total from medical_examination where (air_cond_left is not null AND air_cond_left!='') AND (air_cond_right is not null AND air_cond_right!='') AND (bone_cond_left is not null AND bone_cond_left!='') AND (bone_cond_right is not null AND bone_cond_right!='') and patient_id in ($query1) $qry_date";
// echo $query;
//echo $query;
$query="SELECT patient_master.patient_name from medical_examination INNER JOIN patient_master ON medical_examination.patient_id = patient_master.id where (air_cond_left='abnormal' or air_cond_right='abnormal' or bone_cond_left='abnormal' or bone_cond_right='abnormal' ) and patient_id in ($query1) $qry_date";
//echo $query;
$result = mysqli_query($conn,$query);
//echo $query;
?>
Duration of service(5-10)
Patient Name
=10 and YEAR(CURDATE())-year(doj)<15 ".$qry_bu;
$query="SELECT count(*) as total from medical_examination where (air_cond_left is not null AND air_cond_left!='') AND (air_cond_right is not null AND air_cond_right!='') AND (bone_cond_left is not null AND bone_cond_left!='') AND (bone_cond_right is not null AND bone_cond_right!='') and patient_id in ($query1) $qry_date";
$query="SELECT patient_master.patient_name from medical_examination INNER JOIN patient_master ON medical_examination.patient_id = patient_master.id where (air_cond_left='abnormal' or air_cond_right='abnormal' or bone_cond_left='abnormal' or bone_cond_right='abnormal' ) and patient_id in ($query1) $qry_date";
//echo $query;
$result = mysqli_query($conn,$query);
//echo $query;
?>
Duration of service(10-15)
Patient Name
=15 and YEAR(CURDATE())-year(doj)<20 ".$qry_bu;
$query="SELECT count(*) as total from medical_examination where (air_cond_left is not null AND air_cond_left!='') AND (air_cond_right is not null AND air_cond_right!='') AND (bone_cond_left is not null AND bone_cond_left!='') AND (bone_cond_right is not null AND bone_cond_right!='') and patient_id in ($query1) $qry_date";
$query="SELECT patient_master.patient_name from medical_examination INNER JOIN patient_master ON medical_examination.patient_id = patient_master.id where (air_cond_left='abnormal' or air_cond_right='abnormal' or bone_cond_left='abnormal' or bone_cond_right='abnormal' ) and patient_id in ($query1) $qry_date";
//echo $query;
$result = mysqli_query($conn,$query);
//echo $query;
?>
Duration of service(15-20)
Patient Name
=20 and YEAR(CURDATE())-year(doj)<25 ".$qry_bu;
$query="SELECT count(*) as total from medical_examination where (air_cond_left is not null AND air_cond_left!='') AND (air_cond_right is not null AND air_cond_right!='') AND (bone_cond_left is not null AND bone_cond_left!='') AND (bone_cond_right is not null AND bone_cond_right!='') and patient_id in ($query1) $qry_date";
$query="SELECT patient_master.patient_name from medical_examination INNER JOIN patient_master ON medical_examination.patient_id = patient_master.id where (air_cond_left='abnormal' or air_cond_right='abnormal' or bone_cond_left='abnormal' or bone_cond_right='abnormal' ) and patient_id in ($query1) $qry_date";
//echo $query;
$result = mysqli_query($conn,$query);
//echo $query;
?>
Duration of service(20-25)
Patient Name
25".$qry_bu;
$query="SELECT count(*) as total from medical_examination where (air_cond_left is not null AND air_cond_left!='') AND (air_cond_right is not null AND air_cond_right!='') AND (bone_cond_left is not null AND bone_cond_left!='') AND (bone_cond_right is not null AND bone_cond_right!='') and patient_id in ($query1) $qry_date";
$query="SELECT patient_master.patient_name from medical_examination INNER JOIN patient_master ON medical_examination.patient_id = patient_master.id where (air_cond_left='abnormal' or air_cond_right='abnormal' or bone_cond_left='abnormal' or bone_cond_right='abnormal' ) and patient_id in ($query1) $qry_date";
//echo $query;
$result = mysqli_query($conn,$query);
//echo $query;
?>