<?php
    include "../db/headerApi.php";
    include "../db/connection_main.php";

    $json = file_get_contents('php://input');
    $data = json_decode($_POST["data"]);
    $userid = $_POST["userid"];
    $filename1 = null;
    $filename2 = null;

    $target_dir = "uploads/dispose/";
    $target_file = $target_dir . basename($_FILES["upload1"]["name"]);
    if (move_uploaded_file($_FILES["upload1"]["tmp_name"], $target_file)) {
        $filename1 = basename($_FILES["upload1"]["name"]);
    }

    $target_file = $target_dir . basename($_FILES["upload2"]["name"]);
    if (move_uploaded_file($_FILES["upload2"]["tmp_name"], $target_file)) {
        $filename2 = basename($_FILES["upload2"]["name"]);
    }

    if (empty($data->ID)) {

        //New data
        $sql = "INSERT INTO ITINV_DISPOSE 
                            (COMPANY, DIS_LOCATION, DIS_CATEGORY, DIS_BRAND, DIS_MODEL,
                             BATCH_NO, SERIAL_NO, DIS_QUANTITY, PURCHASE_YEAR, LAST_REF_ID,
                             DIS_JUSTIFICATION, RO_NUMBER, RELEASE_DATE, STATUS, INV_ID, SERVICE_TAG,
                             DISPOSED_DATE, ATTACHMENT_FILE1, ATTACHMENT_FILE2, CREATED_DATE, CREATED_BY)
                     VALUES (:COMPANY, :DIS_LOCATION, :DIS_CATEGORY, :DIS_BRAND, :DIS_MODEL,
                             :BATCH_NO, :SERIAL_NO, :DIS_QUANTITY, :PURCHASE_YEAR, :LAST_REF_ID, 
                             :DIS_JUSTIFICATION, :RO_NUMBER, TO_DATE(:RELEASE_DATE,'YYYY-MM-DD'), 0,
                             :INV_ID, :SERVICE_TAG, TO_DATE(:DISPOSED_DATE,'YYYY-MM-DD'), 
                             :ATTACHMENT_FILE1, :ATTACHMENT_FILE2, SYSDATE, :CREATED_BY)
          RETURNING ID INTO :NEWID";

        $sqlarr = oci_parse($dbcon , $sql);
        oci_bind_by_name($sqlarr, ':COMPANY', $data->COMPANY);
        oci_bind_by_name($sqlarr, ':DIS_LOCATION', $data->DIS_LOCATION);
        oci_bind_by_name($sqlarr, ':DIS_CATEGORY', $data->DIS_CATEGORY);
        oci_bind_by_name($sqlarr, ':DIS_BRAND', $data->DIS_BRAND);
        oci_bind_by_name($sqlarr, ':DIS_MODEL', $data->DIS_MODEL);
        oci_bind_by_name($sqlarr, ':BATCH_NO', $data->BATCH_NO);
        oci_bind_by_name($sqlarr, ':SERIAL_NO', $data->SERIAL_NO);
        oci_bind_by_name($sqlarr, ':DIS_QUANTITY', $data->DIS_QUANTITY);
        oci_bind_by_name($sqlarr, ':PURCHASE_YEAR', $data->PURCHASE_YEAR);
        oci_bind_by_name($sqlarr, ':LAST_REF_ID', $data->LAST_REF_ID);
        oci_bind_by_name($sqlarr, ':DIS_JUSTIFICATION', $data->DIS_JUSTIFICATION);
        oci_bind_by_name($sqlarr, ':RO_NUMBER', $data->RO_NUMBER);
        oci_bind_by_name($sqlarr, ':RELEASE_DATE', $data->RELEASE_DATE);
        oci_bind_by_name($sqlarr, ':DISPOSED_DATE', $data->DISPOSED_DATE);
        oci_bind_by_name($sqlarr, ':INV_ID', $data->INV_ID);
        oci_bind_by_name($sqlarr, ':SERVICE_TAG', $data->SERVICE_TAG);
        oci_bind_by_name($sqlarr, ':ATTACHMENT_FILE1', $data->ATTACHMENT_FILE1);
        oci_bind_by_name($sqlarr, ':ATTACHMENT_FILE2', $data->ATTACHMENT_FILE2);
        oci_bind_by_name($sqlarr, ':CREATED_BY', $userid);
        oci_bind_by_name($sqlarr, ':NEWID', $newid, 20);
        $r = oci_execute($sqlarr, OCI_NO_AUTO_COMMIT);

        if (!$r) {
            $e = oci_error($sqlarr);
            $errorMsg = json_encode($e['message']);
            goto finalStep;
        }

    } else {

        $newid = $data->ID;

        $attach_set1 = "";
        if (!empty($filename1)) {
            $attach_set1 = " ATTACHMENT_FILE1 = '".$filename1."', ";
        }

        $attach_set2 = "";
        if (!empty($filename2)) {
            $attach_set2 = " ATTACHMENT_FILE2 = '".$filename2."', ";
        }

        //Update data
        $sql = "UPDATE ITINV_DISPOSE 
                   SET COMPANY = :COMPANY,
                       DIS_LOCATION = :DIS_LOCATION,
                       DIS_CATEGORY = :DIS_CATEGORY,
                       DIS_BRAND = :DIS_BRAND,
                       DIS_MODEL = :DIS_MODEL,
                       BATCH_NO = :BATCH_NO,
                       SERIAL_NO = :SERIAL_NO,
                       SERVICE_TAG = :SERVICE_TAG,
                       DIS_QUANTITY = :DIS_QUANTITY,
                       PURCHASE_YEAR = :PURCHASE_YEAR,
                       LAST_REF_ID = :LAST_REF_ID,
                       DIS_JUSTIFICATION = :DIS_JUSTIFICATION,
                       RO_NUMBER = :RO_NUMBER,
                       RELEASE_DATE = TO_DATE(:RELEASE_DATE,'YYYY-MM-DD'),
                       DISPOSED_DATE = TO_DATE(:DISPOSED_DATE,'YYYY-MM-DD'),
                       INV_ID = :INV_ID,
                       ".$attach_set1."
                       ".$attach_set2."
                       MODIFIED_DATE = SYSDATE,
                       MODIFIED_BY = :MODIFIED_BY
                 WHERE ID = :ID";

        $hardware_array = array();
        foreach ($hardware as $txt) {
            array_push($hardware_array, $txt);
        }
        $hardware_text = implode(', ', $hardware_array);

        $sqlarr = oci_parse($dbcon , $sql);
        oci_bind_by_name($sqlarr, ':COMPANY', $data->COMPANY);
        oci_bind_by_name($sqlarr, ':DIS_LOCATION', $data->DIS_LOCATION);
        oci_bind_by_name($sqlarr, ':DIS_CATEGORY', $data->DIS_CATEGORY);
        oci_bind_by_name($sqlarr, ':DIS_BRAND', $data->DIS_BRAND);
        oci_bind_by_name($sqlarr, ':DIS_MODEL', $data->DIS_MODEL);
        oci_bind_by_name($sqlarr, ':BATCH_NO', $data->BATCH_NO);
        oci_bind_by_name($sqlarr, ':SERIAL_NO', $data->SERIAL_NO);
        oci_bind_by_name($sqlarr, ':SERVICE_TAG', $data->SERVICE_TAG);
        oci_bind_by_name($sqlarr, ':DIS_QUANTITY', $data->DIS_QUANTITY);
        oci_bind_by_name($sqlarr, ':PURCHASE_YEAR', $data->PURCHASE_YEAR);
        oci_bind_by_name($sqlarr, ':LAST_REF_ID', $data->LAST_REF_ID);
        oci_bind_by_name($sqlarr, ':DIS_JUSTIFICATION', $data->DIS_JUSTIFICATION);
        oci_bind_by_name($sqlarr, ':RO_NUMBER', $data->RO_NUMBER);
        oci_bind_by_name($sqlarr, ':RELEASE_DATE', $data->RELEASE_DATE);
        oci_bind_by_name($sqlarr, ':DISPOSED_DATE', $data->DISPOSED_DATE);
        oci_bind_by_name($sqlarr, ':INV_ID', $data->INV_ID);
        oci_bind_by_name($sqlarr, ':ATTACHMENT_FILE1', $data->ATTACHMENT_FILE1);
        oci_bind_by_name($sqlarr, ':ATTACHMENT_FILE2', $data->ATTACHMENT_FILE2);
        oci_bind_by_name($sqlarr, ':MODIFIED_BY', $userid);
        oci_bind_by_name($sqlarr, ':ID', $newid);
        $r = oci_execute($sqlarr, OCI_NO_AUTO_COMMIT);

        if (!$r) {
            $e = oci_error($sqlarr);
            $errorMsg = json_encode($e['message']);
            goto finalStep;
        }
    }

finalStep:
    $result = [];
    if ($errorMsg == "") {
        oci_commit($dbcon);
        $result[] = [
            "message" => "Success",
            "id" => $newid
        ];
    } else {
        oci_rollback($dbcon);
        $result[] = [
            "message" => $errorMsg,
            "id" => ""
        ];
    }
    print json_encode($result);
?>  