<?php
    global $dbcon;
    include "../db/headerApi.php";
    include "../db/connection_main.php";

    $json = file_get_contents('php://input');
    $data = json_decode($json);

    $sql = "SELECT a.ID, a.COMPANY, a.DIS_LOCATION, a.DIS_CATEGORY, a.DIS_BRAND, a.DIS_MODEL,
                   a.BATCH_NO, a.PURCHASE_YEAR, a.LAST_REF_ID, a.DIS_QUANTITY,
                   a.DIS_JUSTIFICATION, a.RO_NUMBER, a.STATUS, a.SERVICE_TAG,
                   a.CREATED_DATE, a.CREATED_BY, a.MODIFIED_DATE, a.MODIFIED_BY, a.INV_ID,
                   CASE WHEN :emp_id = b.approver_emp_id THEN 1 ELSE 0 END CAN_APPROVE
              FROM itinv_dispose a, 
                   (SELECT *
                       FROM YTYCUSTOM.USER_REG_APP_TRANS
                      WHERE doc_type_code = '2005'
                        AND approver_emp_id = :emp_id
                        AND action is null) b
             WHERE a.ID = b.DOC_NO(+)
               AND a.current_approval = b.appr_level(+)
               AND ID = :ID";
    
    $sqlarr = oci_parse($dbcon , $sql);
    oci_bind_by_name($sqlarr, ':ID', $data->ID);
    oci_bind_by_name($sqlarr, ':emp_id', $data->userid);
    $r = oci_execute($sqlarr);
    $rows_main = [];
    oci_fetch_all($sqlarr, $rows_main, null, null, OCI_FETCHSTATEMENT_BY_ROW);

    print json_encode($rows_main);
?>  