<?php
    include "../db/headerApi.php";
    include "../db/connection_main.php";

    $json = file_get_contents('php://input');
    $data = json_decode($json);

    if (!empty($data)) {
        $sql = "SELECT req_id 
                  FROM ytycustom.medical_visit
                 WHERE visit_id = :visit_id";

        $sqlarr = oci_parse($dbcon , $sql);
        oci_bind_by_name($sqlarr, ':visit_id', $data->VISIT_ID);
        $r = oci_execute($sqlarr, OCI_NO_AUTO_COMMIT);
        if (!$r) {
            $e = oci_error($sqlarr);
            $resMsg = json_encode($e['message']);
        }
        oci_fetch_all($sqlarr, $rows_visit, null, null, OCI_FETCHSTATEMENT_BY_ROW);

        $req_id = $rows_visit[0]["REQ_ID"];
        if (!empty($req_id)) {
            $sql = "UPDATE ytycustom.emp_leave_entry_hd
                       SET status = 'REJECTED',
                           cancel_flag = 'Y'
                     WHERE req_id = :req_id";
    
            $sqlarr = oci_parse($dbcon, $sql);
            oci_bind_by_name($sqlarr, ':req_id', $req_id);
            $r = oci_execute($sqlarr, OCI_NO_AUTO_COMMIT);
    
            if (!$r) {
                $e = oci_error($sqlarr);
                $errorMsg = json_encode($e['message']);
                goto finalStep;
            }
        }
        
        //Deleted record will go to ytycustom.medical_visit_hist 
        $sql = "DELETE FROM ytycustom.medical_visit
                      WHERE visit_id = :visit_id";

        $sqlarr = oci_parse($dbcon, $sql);
        oci_bind_by_name($sqlarr, ':visit_id', $data->VISIT_ID);
        $r = oci_execute($sqlarr, OCI_NO_AUTO_COMMIT);

        if (!$r) {
            $e = oci_error($sqlarr);
            $errorMsg = json_encode($e['message']);
            goto finalStep;
        }

        $sql = "UPDATE ytycustom.medical_visit_hist
                   SET deleted_by = :user_id
                 WHERE visit_id = :visit_id";
        
        $sqlarr = oci_parse($dbcon, $sql);
        oci_bind_by_name($sqlarr, ':user_id', $data->USER_ID);
        oci_bind_by_name($sqlarr, ':visit_id', $data->VISIT_ID);
        $r = oci_execute($sqlarr, OCI_NO_AUTO_COMMIT);

        if (!$r) {
            $e = oci_error($sqlarr);
            $errorMsg = json_encode($e['message']);
            goto finalStep;
        }
    }

finalStep:
    $result = [];
    if ($errorMsg == "") {
        oci_commit($dbcon);
        $result[] = [
            "message" => "Success",
            "id" => $req_id
        ];
    } else {
        oci_rollback($dbcon);
        $result[] = [
            "message" => $errorMsg,
            "id" => ""
        ];
    }
    print json_encode($result);
?>