<?php
    include "../db/headerApi.php";
    include "../db/connection_main.php";

    $json = file_get_contents('php://input');
    $data = json_decode($json);

    if (!empty($data)) {
        $newid = $data->datastage->ID;

        $sql = " UPDATE ytycustom.ple_header 
                    SET MANUFACTURE_REVIEW = :MANUFACTURE_REVIEW, 
                        TRIAL_RESULT = :TRIAL_RESULT,
                        STAGE4_REMARKS = :STAGE4_REMARKS,
                        STAGE_POS = 4,
                        MODIFIED_BY = :MODIFIED_BY,
                        MODIFIED_DATE = SYSDATE
                    WHERE ID = :ID";
        $sqlarr = oci_parse($dbcon , $sql);
        oci_bind_by_name($sqlarr, ':MANUFACTURE_REVIEW', $data->datastage->MANUFACTURE_REVIEW);
        oci_bind_by_name($sqlarr, ':TRIAL_RESULT', $data->datastage->TRIAL_RESULT);
        oci_bind_by_name($sqlarr, ':STAGE4_REMARKS', $data->datastage->STAGE4_REMARKS);
        oci_bind_by_name($sqlarr, ':MODIFIED_BY', $data->datastage->MODIFIED_BY); 
        oci_bind_by_name($sqlarr, ':ID', $data->datastage->ID); 

        $r = oci_execute($sqlarr, OCI_NO_AUTO_COMMIT);

        if (!$r) {
            $e = oci_error($sqlarr);
            $errorMsg = json_encode($e['message']);
            goto finalStep;
        }
        
    } else {
        $errorMsg = "No data to save";
    }

finalStep:
    $result = [];
    if ($errorMsg == "") {
        oci_commit($dbcon);
        $result[] = [
            "message" => "Success",
            "id" => $newid
        ];
    } else {
        oci_rollback($dbcon);
        $result[] = [
            "message" => $errorMsg,
            "id" => ""
        ];
    }
    print json_encode($result);
?>