<?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 COST_OF_CERT = :COST_OF_CERT, 
                        TIMING_CERT = :TIMING_CERT,
                        STAGE2_REMARKS = :STAGE2_REMARKS,
                        STAGE_POS = 2,
                        MODIFIED_BY = :MODIFIED_BY,
                        MODIFIED_DATE = SYSDATE
                    WHERE ID = :ID";
        
        $sqlarr = oci_parse($dbcon , $sql);
        oci_bind_by_name($sqlarr, ':COST_OF_CERT', $data->datastage->COST_OF_CERT);
        oci_bind_by_name($sqlarr, ':TIMING_CERT', $data->datastage->TIMING_CERT);
        oci_bind_by_name($sqlarr, ':STAGE2_REMARKS', $data->datastage->STAGE2_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);
?>