<?php
    include "../db/headerApi.php";
    include "../db/connection_main.php";

    $json = file_get_contents('php://input');
    $data = json_decode($json);

    $sql = "SELECT a.emp_id ID, a.employee_name TEXT 
              FROM production.employee_master a
             WHERE NVL(emp_status,'N') = 'N'
               --AND NVL(virtual_flag,'N') = 'N'
          ORDER BY 2";

    $sqlarr = oci_parse($dbcon , $sql);
    $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);
    $dt = mb_convert_encoding($rows, 'UTF-8', 'UTF-8');
    print json_encode($dt);
    //die(json_last_error_msg());
?>