| |
|
= date('$start_date_time') and time(appointment_date) >= time('$start_date_time') and ohc_type_id='" . $_SESSION['current_ohcttype'] . "'";
$result_sql_injury = @mysqli_query($conn, $sql_injury);
error_log("sql_injury : " . $sql_injury);
$row_injury = @mysqli_fetch_assoc($result_sql_injury);
?>
= date('$start_date_time') and time(appointment_date) >= time('$start_date_time') and ohc_type_id='" . $_SESSION['current_ohcttype'] . "'";
$result_sql_not_injury = @mysqli_query($conn, $sql_not_injury);
error_log("sql_not_injury: " . $sql_not_injury);
$row_not_injury = @mysqli_fetch_assoc($result_sql_not_injury);
?>
= date('$start_date_time') and time(appointment_date) >= time('$start_date_time') and ohc_type_id='" . $_SESSION['current_ohcttype'] . "'";
error_log("emergency_query:" . $sql_serious);
$result_serious = mysqli_query($conn, $sql_serious);
$row_serious = mysqli_fetch_array($result_serious);
?>
= date('$start_date_time') and time(appointment_date) >= time('$start_date_time') and ohc_type_id='" . $_SESSION['current_ohcttype'] . "'";
$result_referral = mysqli_query($conn, $sql_referral);
$row_referral = mysqli_fetch_array($result_referral);
error_log("sql_referral" . $sql_referral);
?>
= date('$start_date_time') and time(appointment_date) >= time('$start_date_time') and ohc_type_id='" . $_SESSION['current_ohcttype'] . "'";
$result_followup = mysqli_query($conn, $sql_followup);
$row_followup = mysqli_fetch_array($result_followup);
error_log("serious : " . $sql_followup);
?>
= date('$start_date_time') and time(sickness_date) >= time('$start_date_time') and ohc_type_id='" . $_SESSION['current_ohcttype'] . "'";
$result_sickness1 = mysqli_query($conn, $sql_sickness1);
$row_sickness1 = mysqli_fetch_array($result_sickness1);
error_log("sql_sickness1: " . $sql_sickness1);
?>
= date('$start_date_time') and time(checkup_date) >= time('$start_date_time') and ohc_type_id='" . $_SESSION['current_ohcttype'] . "'";
$result_ime_long = mysqli_query($conn, $sql_ime_long);
$row_ime_long = mysqli_fetch_array($result_ime_long);
error_log("sql_ime_long" . $sql_ime_long);
?>
= date('$start_date_time') and ohc_type_id='" . $_SESSION['current_ohcttype'] . "' and form_type='chs'";
$result_ime_short = mysqli_query($conn, $sql_ime_short);
$row_ime_short = mysqli_fetch_array($result_ime_short);
error_log("sql_ime_short" . $sql_ime_short);
?>
= date('$start_date_time') and ohc_type_id='" . $_SESSION['current_ohcttype'] . "' and form_type='khs'";
$result_pme = mysqli_query($conn, $sql_pme);
$row_pme = mysqli_fetch_array($result_pme);
error_log("sql_pme" . $sql_pme);
?>
= date('$start_date_time')";
$result_pme = mysqli_query($conn, $sql_pme);
$row_pme = mysqli_fetch_array($result_pme);
error_log("sql_pme" . $sql_pme);
?>
= date('$start_date_time') and time(sickness_date) >= time('$start_date_time') and ohc_type_id='" . $_SESSION['current_ohcttype'] . "'";
$result_sickness = mysqli_query($conn, $sql_sickness);
$row_sickness = mysqli_fetch_array($result_sickness);
error_log("sql_sickness: " . $sql_sickness);
?>
= date('$start_date_time') and time(last_modified) >= time('$start_date_time')";
$result_covid = mysqli_query($conn, $sql_covid);
$row_covid = mysqli_fetch_array($result_covid);
error_log("covid sql: " . $sql_covid);
?>
|