= date(NOW()-INTERVAL 7 DAY) and ohc_type_id='" . $_SESSION['current_ohcttype'] . "' ";
error_log("qqqq:" . $sevenday);
$result_sevenday = mysqli_query($conn, $sevenday);
$row_sevenday = @mysqli_fetch_array($result_sevenday);
$month = "select count(appointment_id) count from employee_appointment where appointment_type='O' and DATE(appointment_date) >= date(NOW()-INTERVAL 30 DAY) and ohc_type_id='" . $_SESSION['current_ohcttype'] . "' ";
// error_log("row count:" . $yesterday);
$result_month = mysqli_query($conn, $month);
$row_month = @mysqli_fetch_array($result_month);
$year = "select count(appointment_id) count from employee_appointment where appointment_type='O' and DATE(appointment_date) >= date(NOW()-INTERVAL 365 DAY) ";
// error_log("row count:" . $yesterday);
$result_year = mysqli_query($conn, $year);
$row_year = @mysqli_fetch_array($result_year);
$twoyear = "select count(appointment_id) count from employee_appointment where appointment_type='O' and DATE(appointment_date) >= date(NOW()-INTERVAL 730 DAY) and ohc_type_id='" . $_SESSION['current_ohcttype'] . "' ";
// error_log("row count:" . $twoyear);
$result_twoyear = mysqli_query($conn, $twoyear);
$row_twoyear = @mysqli_fetch_array($result_twoyear);
?>
OPD
DASHBOARD
No Of
Patients
| LAST 365 DAY |
LAST 730 DAY |
|
|
Ailment System Wise
Trends
Ailment System Wise
Trends(Designation)
|
Select Ailment
|
Select Designation
|
Ailment System Wise
Trends ( Compare
Designation
Wise)
|
Select Ailment
|
Select Designation
|
Select Designation
|
Ailment System wise trend(with division)
Ailment System wise trend(with department)
Select Department
Ailment System Wise
Trends ( Compare
Department
Wise)
|
Select Ailment
|
Select Department
|
Select Department
|