<?php
    include "../db/headerApi.php";
    include "../db/connection_main.php";

    $json = file_get_contents('php://input');
    $data = json_decode($json);

    $sql = "SELECT emp_id ID, employee_name TEXT
              FROM production.employee_master
             WHERE (department LIKE '%SALES%' 
                OR designation LIKE '%SALES%' 
                OR emp_id IN ('099160067', '099100068'))
               AND nvl(emp_status, 'N') = 'N'
          ORDER BY employee_name";

    $sqlarr = oci_parse($dbcon , $sql);
    $r = oci_execute($sqlarr);
    oci_fetch_all($sqlarr, $rows_main, null, null, OCI_FETCHSTATEMENT_BY_ROW);

    if (!$r) {
        $e = oci_error($sqlarr);
        print json_encode($e['message']);
    }

    print json_encode($rows_main);
?>