<?php
    include "../db/headerApi.php";
    include "../db/connection_main.php";

    $json = file_get_contents('php://input');
    $data = json_decode($json);

    if (!empty($data)) {
        if (!$data->ID) {
            $sql = "INSERT INTO ytycustom.ple_header 
                                (SKU_REQUIREMENT, VOLUME_EXP1, VOLUME_EXP2, VOLUME_EXP3, PRICE_EXP, CUSTOMER, CUSTOMER_CODE, SEGMENT_TERRITORY, PROTOTYPE_REQUIRED, STAGE_POS, CERT_REQUIRED, AQL_REQUIREMENT, CREATED_BY, CREATED_DATE)
                         VALUES (:SKU_REQUIREMENT, :VOLUME_EXP1, :VOLUME_EXP2, :VOLUME_EXP3, :PRICE_EXP, :CUSTOMER, :CUSTOMER_CODE, :SEGMENT_TERRITORY, :PROTOTYPE_REQUIRED, '1', :CERT_REQUIRED, :AQL_REQUIREMENT, :CREATED_BY, SYSDATE)
                      RETURNING ID INTO :NEWID";
            
            $sqlarr = oci_parse($dbcon , $sql);
            oci_bind_by_name($sqlarr, ':SKU_REQUIREMENT', $data->SKU_REQUIREMENT);
            oci_bind_by_name($sqlarr, ':VOLUME_EXP1', $data->VOLUME_EXP1);
            oci_bind_by_name($sqlarr, ':VOLUME_EXP2', $data->VOLUME_EXP2);
            oci_bind_by_name($sqlarr, ':VOLUME_EXP3', $data->VOLUME_EXP3);
            oci_bind_by_name($sqlarr, ':PRICE_EXP', $data->PRICE_EXP);
            oci_bind_by_name($sqlarr, ':CUSTOMER', $data->CUSTOMER);
            oci_bind_by_name($sqlarr, ':CUSTOMER_CODE', $data->CUSTOMER_CODE);
            oci_bind_by_name($sqlarr, ':SEGMENT_TERRITORY', $data->SEGMENT_TERRITORY);
            oci_bind_by_name($sqlarr, ':PROTOTYPE_REQUIRED', $data->PROTOTYPE_REQUIRED);
            oci_bind_by_name($sqlarr, ':CERT_REQUIRED', $data->CERT_REQUIRED);
            oci_bind_by_name($sqlarr, ':AQL_REQUIREMENT', $data->AQL_REQUIREMENT);
            oci_bind_by_name($sqlarr, ':CREATED_BY', $data->CREATED_BY);
            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;

            $sql = "UPDATE ytycustom.ple_header 
                       SET SKU_REQUIREMENT = :SKU_REQUIREMENT, 
                           VOLUME_EXP1 = :VOLUME_EXP1, 
                           VOLUME_EXP2 = :VOLUME_EXP2, 
                           VOLUME_EXP3 = :VOLUME_EXP3, 
                           PRICE_EXP = :PRICE_EXP, 
                           CUSTOMER = :CUSTOMER, 
                           CUSTOMER_CODE = :CUSTOMER_CODE, 
                           SEGMENT_TERRITORY = :SEGMENT_TERRITORY, 
                           PROTOTYPE_REQUIRED = :PROTOTYPE_REQUIRED,
                           STAGE_POS = 1,
                           CERT_REQUIRED = :CERT_REQUIRED,
                           AQL_REQUIREMENT = :AQL_REQUIREMENT,
                           MODIFIED_BY = :MODIFIED_BY,
                           MODIFIED_DATE = SYSDATE
                     WHERE ID = :ID";
            $sqlarr = oci_parse($dbcon , $sql);
            oci_bind_by_name($sqlarr, ':SKU_REQUIREMENT', $data->SKU_REQUIREMENT);
            oci_bind_by_name($sqlarr, ':VOLUME_EXP1', $data->VOLUME_EXP1);
            oci_bind_by_name($sqlarr, ':VOLUME_EXP2', $data->VOLUME_EXP2);
            oci_bind_by_name($sqlarr, ':VOLUME_EXP3', $data->VOLUME_EXP3);
            oci_bind_by_name($sqlarr, ':PRICE_EXP', $data->PRICE_EXP);
            oci_bind_by_name($sqlarr, ':CUSTOMER', $data->CUSTOMER);
            oci_bind_by_name($sqlarr, ':CUSTOMER_CODE', $data->CUSTOMER_CODE);
            oci_bind_by_name($sqlarr, ':SEGMENT_TERRITORY', $data->SEGMENT_TERRITORY);
            oci_bind_by_name($sqlarr, ':PROTOTYPE_REQUIRED', $data->PROTOTYPE_REQUIRED);
            oci_bind_by_name($sqlarr, ':CERT_REQUIRED', $data->CERT_REQUIRED);
            oci_bind_by_name($sqlarr, ':AQL_REQUIREMENT', $data->AQL_REQUIREMENT);
            oci_bind_by_name($sqlarr, ':MODIFIED_BY', $data->MODIFIED_BY); 
            oci_bind_by_name($sqlarr, ':ID', $data->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);
?>