<?php
    include "../db/headerApi.php";
    include "../db/connection_main.php";

    $json = file_get_contents('php://input');
    $data = json_decode($json);

    $sql = " SELECT visit_id, to_char(visit_date, 'YYYY-MM-DD') visit_date,
                    emp_id, employee_name, clinic_id, mc_flag,
                    to_char(ldp_from_date, 'DD/MM/YYYY') ldp_from_date,
                    to_char(ldp_to_date, 'DD/MM/YYYY') ldp_to_date, reason,
                    medication, charges, remarks, clinic_name, req_id
               FROM ytycustom.medical_visit
              WHERE emp_id = :emp_id
                AND visit_id = :visit_id";

    $sqlarr = oci_parse($dbcon, $sql);
    oci_bind_by_name($sqlarr, ':emp_id', $data->EMP_ID->ID);
    oci_bind_by_name($sqlarr, ':visit_id', $data->VISIT_ID);
    $r = oci_execute($sqlarr);

    if (!$r) {
         $e = oci_error($sqlarr);
         print json_encode($e['message']);
    }
    
    oci_fetch_all($sqlarr, $rows, null, null, OCI_FETCHSTATEMENT_BY_ROW);
    print json_encode($rows);
?>