<?php
    include "../db/headerApi.php";
    include "../db/connection_main.php";

    $json = file_get_contents('php://input');
    $data = json_decode($json);

    if (!empty($data->ID)) {
        
        //Just for return value
        $newid = $data->ID;

        //Existing Data
        $sql = "UPDATE YTYCUSTOM.XX_YTY_INCOMING_OUTGOING_INSPECTION_TBL
                   SET LOG_PREPARED_BY = :LOG_PREPARED_BY,
                       LOG_PREPARED_DATE = TO_DATE(:LOG_PREPARED_DATE,'YYYY-MM-DD'),
                       LOG_CHECKED_BY = :LOG_CHECKED_BY,
                       LOG_CHECKED_DATE = TO_DATE(:LOG_CHECKED_DATE,'YYYY-MM-DD'),
                       LOG_VERIFIED_BY = :LOG_VERIFIED_BY,
                       LOG_VERIFIED_DATE = TO_DATE(:LOG_VERIFIED_DATE,'YYYY-MM-DD'),
                       MODIFIED_BY = :MODIFIED_BY,
                       MODIFIED_AT = SYSDATE
                 WHERE ID = :INSP_ID";

        $sqlarr = oci_parse($dbcon , $sql);
        oci_bind_by_name($sqlarr, ':LOG_PREPARED_BY', $data->LOG_PREPARED_BY->ID);
        oci_bind_by_name($sqlarr, ':LOG_PREPARED_DATE', $data->LOG_PREPARED_DATE);
        oci_bind_by_name($sqlarr, ':LOG_CHECKED_BY', $data->LOG_CHECKED_BY->ID);
        oci_bind_by_name($sqlarr, ':LOG_CHECKED_DATE', $data->LOG_CHECKED_DATE);
        oci_bind_by_name($sqlarr, ':LOG_VERIFIED_BY', $data->LOG_VERIFIED_BY->ID);
        oci_bind_by_name($sqlarr, ':LOG_VERIFIED_DATE', $data->LOG_VERIFIED_DATE);
        oci_bind_by_name($sqlarr, ':MODIFIED_BY', $data->USERID);
        oci_bind_by_name($sqlarr, ':INSP_ID', $data->ID);
        $r = oci_execute($sqlarr, OCI_NO_AUTO_COMMIT);

        if (!$r) {
            $e = oci_error($sqlarr);
            $errorMsg = json_encode($e['message']);
            goto finalStep;
        }  

        //Details
        if (!empty($newid) && empty($errorMsg) && !empty($data->details)) {
            $sql = "DELETE FROM YTYCUSTOM.XX_YTY_INCOMING_OUTGOING_INSPECTION_OP
                     WHERE INSPECTION_ID = :INSP_ID";
                
            $sqlarr = oci_parse($dbcon , $sql);
            oci_bind_by_name($sqlarr, ':INSP_ID', $data->ID);
            $r = oci_execute($sqlarr, OCI_NO_AUTO_COMMIT);

            if (!$r) {
                $e = oci_error($sqlarr);
                $errorMsg = json_encode($e['message']);
                goto finalStep;
            }

            foreach ($data->details as $det) {

                //DateTime
                $loading_dt = $det->LOADING_DT." ".json_encode($det->LOADING_TM->hours).":".json_encode($det->LOADING_TM->minutes);
                
                if (!empty($det->UNLOADING_DT) && !empty($det->UNLOADING_TM)) {
                    $unloading_dt = $det->UNLOADING_DT." ".json_encode($det->UNLOADING_TM->hours).":".json_encode($det->UNLOADING_TM->minutes);

                    $sql_det = "INSERT INTO YTYCUSTOM.XX_YTY_INCOMING_OUTGOING_INSPECTION_OP
                                            (INSPECTION_ID, TOTE_NO, QUANTITY, LOADING_LOC, LOADING_DATE, LOADING_BY, UNLOADING_LOC, UNLOADING_DATE, UNLOADING_BY, REMARKS, IRRD)
                                    VALUES (:INSPECTION_ID, :TOTE_NO, :QUANTITY, :LOADING_LOC, TO_DATE(:LOADING_DATE,'YYYY-MM-DD HH24:MI'), :LOADING_BY,
                                            :UNLOADING_LOC, TO_DATE(:UNLOADING_DATE,'YYYY-MM-DD HH24:MI'), :UNLOADING_BY, :REMARKS, :IRRD)";
                    $sqlarr_det = oci_parse($dbcon , $sql_det);
                    oci_bind_by_name($sqlarr_det, ':UNLOADING_LOC', $det->UNLOADING_LOC);
                    oci_bind_by_name($sqlarr_det, ':UNLOADING_DATE', $unloading_dt);
                    oci_bind_by_name($sqlarr_det, ':UNLOADING_BY', $det->UNLOADING_BY->ID);
                
                } else {

                    $sql_det = "INSERT INTO YTYCUSTOM.XX_YTY_INCOMING_OUTGOING_INSPECTION_OP
                                            (INSPECTION_ID, TOTE_NO, QUANTITY, LOADING_LOC, LOADING_DATE, LOADING_BY, REMARKS, IRRD)
                                    VALUES (:INSPECTION_ID, :TOTE_NO, :QUANTITY, :LOADING_LOC, TO_DATE(:LOADING_DATE,'YYYY-MM-DD HH24:MI'), :LOADING_BY,
                                            :REMARKS, :IRRD)";
                    $sqlarr_det = oci_parse($dbcon , $sql_det);
                } 

                oci_bind_by_name($sqlarr_det, ':INSPECTION_ID', $data->ID);
                oci_bind_by_name($sqlarr_det, ':TOTE_NO', $det->TOTE_NO);
                oci_bind_by_name($sqlarr_det, ':QUANTITY', $det->QUANTITY);
                oci_bind_by_name($sqlarr_det, ':LOADING_LOC', $det->LOADING_LOC);
                oci_bind_by_name($sqlarr_det, ':LOADING_DATE', $loading_dt);
                oci_bind_by_name($sqlarr_det, ':LOADING_BY', $det->LOADING_BY->ID);
                oci_bind_by_name($sqlarr_det, ':REMARKS', $det->REMARKS);
                oci_bind_by_name($sqlarr_det, ':IRRD', $det->IRRD);
                $r = oci_execute($sqlarr_det, OCI_NO_AUTO_COMMIT);

                if (!$r) {
                    $e = oci_error($sqlarr_det);
                    $errorMsg = json_encode($e['message']);
                    goto finalStep;
                }
            }
        } 
        else 
        {
            $sql_det = "UPDATE YTYCUSTOM.XX_YTY_INCOMING_OUTGOING_INSPECTION_OP
                           SET IRRD = :IRRD
                         WHERE INSPECTION_ID = :INSPECTION_ID";
            $sqlarr_det = oci_parse($dbcon , $sql_det);
            oci_bind_by_name($sqlarr_det, ':INSPECTION_ID', $data->ID);
            oci_bind_by_name($sqlarr_det, ':IRRD', $det->IRRD);
            $r = oci_execute($sqlarr_det, OCI_NO_AUTO_COMMIT);

            if (!$r) {
                $e = oci_error($sqlarr_det);
                $errorMsg = json_encode($e['message']);
                goto finalStep;
            }
        } 

        //Empty the rack
        $sql_det = " UPDATE ytycustom.gth_rack_master
                        SET occupied = NULL, 
                            ref_no = NULL, 
                            customer = NULL,
                            brand = NULL, 
                            size_code = NULL,
                            quantity = NULL,
                            inspection_id = NULL,
                            line_id = NULL
                    WHERE rack_code IN (SELECT racking_no
                                          FROM ytycustom.xx_yty_incoming_outgoing_inspection_detail_tbl
                                         WHERE inspection_id = :INSPECTION_ID)";
        $sqlarr_det = oci_parse($dbcon , $sql_det);
        oci_bind_by_name($sqlarr_det, ':INSPECTION_ID', $data->ID);
        $r = oci_execute($sqlarr_det, OCI_NO_AUTO_COMMIT);

        if (!$r) {
            $e = oci_error($sqlarr_det);
            $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);
?>