<?php
    global $dbcon;
    include "../db/headerApi.php";
    include "../db/connection_main.php";

    $json = file_get_contents('php://input');
    $data = json_decode($json);

    //Request Data
    $sql = "SELECT ID, REQUESTER, REQ_FOR, R_LEVEL, SUPPORTING_NOTE, UPDATES_NOTE,
                   ATTACHMENT_FILE1, ATTACHMENT_FILE2, ATTACHMENT_FILE3, DATE_REQUEST,
                   NVL(STATUS, 0) STATUS, HW_AVAIL, HW_SELECTED, POS_TITLE, DEPARTMENT, HOD, 
                   TO_CHAR(JOIN_DATE,'YYYY-MM-DD') JOIN_DATE, WORK_LOCATION, WORK_ROLE, CONTACT_NO, 
                   EMAIL_ADDRESS, POS_GROUP, REQUEST_TYPE, REQ_FOR_EMP, REQ_ID, COUNTRY_CODE, 
                   OFC_EMAIL_ADDRESS, OFC_CONTACT_NO, OFC_COUNTRY_CODE, PREFERRED_NAME,
                   APPROVER_REMARKS, CURRENT_APPROVAL, null CURRENT_APPROVER
              FROM ITINV_REQUEST
             WHERE ID = :ID";
    
    $sqlarr = oci_parse($dbcon , $sql);
    oci_bind_by_name($sqlarr, ':ID', $data->ID);
    $r = oci_execute($sqlarr);

    $rows_main = [];
    oci_fetch_all($sqlarr, $rows_main, 0, 0, OCI_FETCHSTATEMENT_BY_ROW);

    if (!empty($rows_main[0]["HW_SELECTED"])) {
        $hw = explode(', ', $rows_main[0]["HW_SELECTED"]);
        $rows_main[0]["HW_SELECTED"] = $hw;
    }

    if (!empty($rows_main[0]["HW_AVAIL"])) {
        $hw = explode(', ', $rows_main[0]["HW_AVAIL"]);
        $newarr = array_map(function($item) {
            return [
                "ID" => $item, 
                "TEXT" => $item
            ];
        }, $hw);
        $rows_main[0]["HW_AVAIL"] = $newarr;
    }

    $approver_emp_id = "";
    if (!empty($rows_main[0]["CURRENT_APPROVAL"])) {
        $sql = "SELECT approver_emp_id
                  FROM YTYCUSTOM.USER_REG_APP_TRANS
                 WHERE doc_type_code = '2009'
                   AND doc_no = :doc_no
                   AND appr_level = :appr_level
                   AND action IS NULL";

        $sqlarr = oci_parse($dbcon , $sql);
        oci_bind_by_name($sqlarr, ':doc_no', $rows_main[0]["REQ_ID"]);
        oci_bind_by_name($sqlarr, ':appr_level', $rows_main[0]["CURRENT_APPROVAL"]);
        $r = oci_execute($sqlarr);
        
        while ($row = oci_fetch_array($sqlarr, OCI_ASSOC+OCI_RETURN_NULLS)) {
            $approver_emp_id = $row['APPROVER_EMP_ID'];
        }
        $rows_main[0]["CURRENT_APPROVER"] = $approver_emp_id;
    }

    //Hardware Assign
    $sql = "SELECT B.ID, B.COMPANY, B.IV_LOCATION, B.IV_CATEGORY, B.IV_TIER, B.IV_STATUS, B.IV_HOST, B.IV_USER, 
                   B.IV_DEPT, B.IV_LEVEL, B.OPEN_DATE, B.OPEN_YEAR, B.SERVICE_TAG, B.IV_BRAND, B.IV_MODEL, 
                   B.IV_QUANTITY, B.IV_OS, B.IV_YEAR, B.OFFICE_APP
              FROM ITINV_REQUEST_ASSIGN A, ITINV_DATA B
             WHERE A.INVENTORY_ID = B.ID
               AND A.REQUEST_ID = :REQUEST_ID";

    $sqlarr = oci_parse($dbcon , $sql);
    oci_bind_by_name($sqlarr, ':REQUEST_ID', $data->ID);
    $r = oci_execute($sqlarr);

    $rows_hw = [];
    oci_fetch_all($sqlarr, $rows_hw, 0, 0, OCI_FETCHSTATEMENT_BY_ROW);

    array_walk_recursive($rows_hw, function (&$value) {
        if (is_string($value)) {
            $value = iconv('CP1252', 'UTF-8//IGNORE', $value);
        }
    });

    print json_encode([
        "request" => $rows_main,
        "hardware" => $rows_hw
    ]);
?>  