<?php
error_reporting(0);
include "../includes/config/config.php";
include "functions.php";
include 'log_entry.php';


$response = array();

$date = date_format(date_create($_REQUEST["date"]), "Y-m-d");

// $d=date_format($_REQUEST["date"] , "Y/m/d");

$time = $_REQUEST["time"];

$emp_id = $_REQUEST["emp_id"];

$ohc_type_id = $_REQUEST["ohc_type_id"];

$day = $_REQUEST["day"];

$doctor_id = $_REQUEST["doctor_id"];

$type = $_REQUEST["type"];

// $query="INSERT INTO `appointment_details`( `date`, `time`, `day`,`doctor_id`,`emp_id`) VALUES ('$date','$time','$day','$doctor_id','$emp_id')";
// $exe=mysqli_query($conn,$query);
// $arr=[];
// if($exe){
// $arr["sucess"]="true";
// }else{
//     $arr["sucess"]="false";
// }
// print(json_encode($arr))
$sql = "SELECT * FROM appointment_details WHERE emp_id='$emp_id' AND doctor_id='$doctor_id' AND `date` = '$date' AND `time` = '$time'";
error_log("API LOGIN DM : " . $sql);
$check = mysqli_query($conn, $sql);

if ($check->num_rows > 0) {
    if ($check) {
        $arr = "false";
    }
} else {
    // If not, save the date and time to the database
    $insertSql = "INSERT INTO `appointment_details`( `date`, `time`, `day`,`doctor_id`,`emp_id` ,`ohc_type_id` , `status` ,`app_type`) VALUES ('$date','$time','$day','$doctor_id','$emp_id' , '$ohc_type_id' , 'BOOKED' , '$type')";
    error_log("API LOGIN DM : " . $insertSql);
    $exe = mysqli_query($conn, $insertSql);


    $Update_Doc_Status = "UPDATE `doc_slots` SET `status` = 'BOOKED' WHERE doc_slot_id = '$time' AND ohc_type_id = '$ohc_type_id'";
    error_log("Update_Doc_Status: " . $Update_Doc_Status);
    $update_exe = mysqli_query($conn, $Update_Doc_Status);

    if ($exe) {
        $arr = "true";
    } else {
        $arr = "false";
    }
}
    echo json_encode($arr);
?>