<?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 FEASIBLE_WO_DEV = :FEASIBLE_WO_DEV, 
                        PROD_DEV_REMARKS = :PROD_DEV_REMARKS,
                        EXPECT_CHANGES_FORM = :EXPECT_CHANGES_FORM, 
                        FORMULATION_REMARKS = :FORMULATION_REMARKS,
                        EXPECT_CHANGES_PROC = :EXPECT_CHANGES_PROC, 
                        COST_CHANGE = :COST_CHANGE, 
                        TRIAL_REQ = :TRIAL_REQ,
                        QUALIFICATION_REQ = :QUALIFICATION_REQ,
                        OQ = :OQ,
                        PQ = :PQ,
                        TIMING_PROTOTYPE = :TIMING_PROTOTYPE, 
                        TIMING_TRIAL = :TIMING_TRIAL,
                        TIMING_OQ = :TIMING_OQ,
                        TIMING_PQ = :TIMING_PQ,
                        RESOURCES_REQUIRED = :RESOURCES_REQUIRED, 
                        TECHNICAL_RECOMMEND = :TECHNICAL_RECOMMEND, 
                        DISCUSS_WITH_OPS = :DISCUSS_WITH_OPS,
                        STAGE3_REMARKS = :STAGE3_REMARKS,
                        STAGE_POS = 3,
                        MODIFIED_BY = :MODIFIED_BY,
                        MODIFIED_DATE = SYSDATE
                    WHERE ID = :ID";
        $sqlarr = oci_parse($dbcon , $sql);
        oci_bind_by_name($sqlarr, ':FEASIBLE_WO_DEV', $data->datastage->FEASIBLE_WO_DEV);
        oci_bind_by_name($sqlarr, ':PROD_DEV_REMARKS', $data->datastage->PROD_DEV_REMARKS);
        oci_bind_by_name($sqlarr, ':EXPECT_CHANGES_FORM', $data->datastage->EXPECT_CHANGES_FORM);
        oci_bind_by_name($sqlarr, ':FORMULATION_REMARKS', $data->datastage->FORMULATION_REMARKS);
        oci_bind_by_name($sqlarr, ':EXPECT_CHANGES_PROC', $data->datastage->EXPECT_CHANGES_PROC);
        oci_bind_by_name($sqlarr, ':COST_CHANGE', $data->datastage->COST_CHANGE);
        oci_bind_by_name($sqlarr, ':TRIAL_REQ', $data->datastage->TRIAL_REQ);
        oci_bind_by_name($sqlarr, ':QUALIFICATION_REQ', $data->datastage->QUALIFICATION_REQ);
        oci_bind_by_name($sqlarr, ':OQ', $data->datastage->OQ);
        oci_bind_by_name($sqlarr, ':PQ', $data->datastage->PQ);
        oci_bind_by_name($sqlarr, ':TIMING_PROTOTYPE', $data->datastage->TIMING_PROTOTYPE);
        oci_bind_by_name($sqlarr, ':TIMING_TRIAL', $data->datastage->TIMING_TRIAL);
        oci_bind_by_name($sqlarr, ':TIMING_OQ', $data->datastage->TIMING_OQ);
        oci_bind_by_name($sqlarr, ':TIMING_PQ', $data->datastage->TIMING_PQ);
        oci_bind_by_name($sqlarr, ':RESOURCES_REQUIRED', $data->datastage->RESOURCES_REQUIRED);
        oci_bind_by_name($sqlarr, ':TECHNICAL_RECOMMEND', $data->datastage->TECHNICAL_RECOMMEND);
        oci_bind_by_name($sqlarr, ':DISCUSS_WITH_OPS', $data->datastage->DISCUSS_WITH_OPS);
        oci_bind_by_name($sqlarr, ':STAGE3_REMARKS', $data->datastage->STAGE3_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);
?>