<?php
    include "../db/headerApi.php";
    include "../db/connection_main.php";

    $json = file_get_contents('php://input');
    $data = json_decode($json);

    if (!empty($data->ID)) {
        //For returning ID
        $newid = $data->ID;

        //Update
        $sql = "Update YTYCUSTOM.GTH_CUSTOMER_BRAND_MASTER
                   Set BRAND_NAME = :BRAND_NAME,
                       CARTON_W = :CARTON_W,
                       CARTON_L = :CARTON_L,
                       CARTON_H = :CARTON_H,
                       VALIDATION_CODE = :VALIDATION_CODE,
                       LOADING_PATTERN = :LOADING_PATTERN,
                       DOSE_LOC_MIN = :DOSE_LOC_MIN,
                       DOSE_LOC_MAX = :DOSE_LOC_MAX,
                       DOSE_REQ_MIN = :DOSE_REQ_MIN,
                       DOSE_REQ_MAX = :DOSE_REQ_MAX,
                       CARTON_DENSITY = :CARTON_DENSITY,
                       PACKING_DENSITY = :PACKING_DENSITY 
                 Where ID = :ID ";

        $sqlarr = oci_parse($dbcon , $sql);
        oci_bind_by_name($sqlarr, ':ID', $data->ID);
        oci_bind_by_name($sqlarr, ':BRAND_NAME', $data->BRAND_NAME);
        oci_bind_by_name($sqlarr, ':CARTON_W', $data->CARTON_W);
        oci_bind_by_name($sqlarr, ':CARTON_L', $data->CARTON_L);
        oci_bind_by_name($sqlarr, ':CARTON_H', $data->CARTON_H);
        oci_bind_by_name($sqlarr, ':VALIDATION_CODE', $data->VALIDATION_CODE);
        oci_bind_by_name($sqlarr, ':LOADING_PATTERN', $data->LOADING_PATTERN);
        oci_bind_by_name($sqlarr, ':DOSE_LOC_MIN', $data->DOSE_LOC_MIN);
        oci_bind_by_name($sqlarr, ':DOSE_LOC_MAX', $data->DOSE_LOC_MAX);
        oci_bind_by_name($sqlarr, ':DOSE_REQ_MIN', $data->DOSE_REQ_MIN);
        oci_bind_by_name($sqlarr, ':DOSE_REQ_MAX', $data->DOSE_REQ_MAX);
        oci_bind_by_name($sqlarr, ':CARTON_DENSITY', $data->CARTON_DENSITY);
        oci_bind_by_name($sqlarr, ':PACKING_DENSITY', $data->PACKING_DENSITY);
        $r = oci_execute($sqlarr, OCI_NO_AUTO_COMMIT);

    } else {

        //Insert
        $sql = "INSERT INTO YTYCUSTOM.GTH_CUSTOMER_BRAND_MASTER 
                            (CUSTOMER_ID, BRAND_ID, BRAND_NAME, CARTON_W, CARTON_L, CARTON_H, VALIDATION_CODE,
                             LOADING_PATTERN, DOSE_LOC_MIN, DOSE_LOC_MAX, DOSE_REQ_MIN, DOSE_REQ_MAX, CARTON_DENSITY, PACKING_DENSITY)
                     VALUES (:CUSTOMER_ID, :BRAND_ID, :BRAND_NAME, :CARTON_W, :CARTON_L, :CARTON_H, :VALIDATION_CODE,
                             :LOADING_PATTERN, :DOSE_LOC_MIN, :DOSE_LOC_MAX, :DOSE_REQ_MIN, :DOSE_REQ_MAX, :CARTON_DENSITY, :PACKING_DENSITY)
                  RETURNING ID INTO :NEWID";
        
        $sqlarr = oci_parse($dbcon , $sql);
        oci_bind_by_name($sqlarr, ':ID', $data->ID);
        oci_bind_by_name($sqlarr, ':CUSTOMER_ID', $data->CUSTOMER_ID->ID);
        oci_bind_by_name($sqlarr, ':BRAND_ID', $data->BRAND_ID);
        oci_bind_by_name($sqlarr, ':BRAND_NAME', $data->BRAND_NAME);
        oci_bind_by_name($sqlarr, ':CARTON_W', $data->CARTON_W);
        oci_bind_by_name($sqlarr, ':CARTON_L', $data->CARTON_L);
        oci_bind_by_name($sqlarr, ':CARTON_H', $data->CARTON_H);
        oci_bind_by_name($sqlarr, ':VALIDATION_CODE', $data->VALIDATION_CODE);
        oci_bind_by_name($sqlarr, ':LOADING_PATTERN', $data->LOADING_PATTERN);
        oci_bind_by_name($sqlarr, ':DOSE_LOC_MIN', $data->DOSE_LOC_MIN);
        oci_bind_by_name($sqlarr, ':DOSE_LOC_MAX', $data->DOSE_LOC_MAX);
        oci_bind_by_name($sqlarr, ':DOSE_REQ_MIN', $data->DOSE_REQ_MIN);
        oci_bind_by_name($sqlarr, ':DOSE_REQ_MAX', $data->DOSE_REQ_MAX);
        oci_bind_by_name($sqlarr, ':CARTON_DENSITY', $data->CARTON_DENSITY);
        oci_bind_by_name($sqlarr, ':PACKING_DENSITY', $data->PACKING_DENSITY);
        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']);
    }  

    $result = [];
    if ($errorMsg == "") {
        oci_commit($dbcon);
        $result[] = [
            "message" => "Success",
            "id" => $newid
        ];
    } else {
        oci_rollback($dbcon);
        $result[] = [
            "message" => $errorMsg,
            "id" => $newid
        ];
    }
    print json_encode($result);
?>