<?php
    include "../db/headerApi.php";
    include "../db/connection_main.php";

    $json = file_get_contents('php://input');
    $data = json_decode($json);

    if (!empty($data)) {
        
        //HEADER
        if (empty($data->datastage->ID)) {
        
            $sql = "INSERT INTO ytycustom.ple_header 
                                (SKU, 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,
                                 CUSTOMER_ADDRESS, GLOVE_COLOUR, GLOVE_TYPE, TARGET_WEIGHT, GLOVE_LENGTH, GLOVE_SIZE, GLOVE_SURFACE, 
                                 GLOVE_DONNING, SPECIAL_FEATURES, SPECIAL_REQUEST, ATTENTION_TO, DELV_ADDRESS, CONTACT_NUMBER, SEND_OUT_BY_DATE,
                                 GEOGRAPHICAL, COUNTRY, STAGE1_REMARKS, MEDICAL, FOOD_GRADE, PPE, INDUSTRIAL, SEGMENT_OTH, VOLUME_REMARKS, CLOSE_ON,
                                 SALES_ID)
                         VALUES (:SKU, :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,
                                 :CUSTOMER_ADDRESS, :GLOVE_COLOUR, :GLOVE_TYPE, :TARGET_WEIGHT, :GLOVE_LENGTH, :GLOVE_SIZE, :GLOVE_SURFACE,
                                 :GLOVE_DONNING, :SPECIAL_FEATURES, :SPECIAL_REQUEST, :ATTENTION_TO, :DELV_ADDRESS, :CONTACT_NUMBER, TO_DATE(:SEND_OUT_BY_DATE,'YYYY-MM-DD'),
                                 :GEOGRAPHICAL, :COUNTRY, :STAGE1_REMARKS, :MEDICAL, :FOOD_GRADE, :PPE, :INDUSTRIAL, :SEGMENT_OTH, :VOLUME_REMARKS, TO_DATE(:CLOSE_ON,'YYYY-MM-DD'),
                                 :SALES_ID)
                      RETURNING ID INTO :NEWID";

            //Customer
            if (!empty($data->datastage->CUSTOMER->ID)) {
                $customer = $data->datastage->CUSTOMER->ID;
            } else {
                $customer = $data->datastage->CUSTOMER;
            }

            //SKU
            if (!empty($data->datastage->SKU->ID)) {
                $sku = $data->datastage->SKU->ID;
            } else {
                $sku = $data->datastage->SKU;
            }

            //Colour
            if (!empty($data->datastage->GLOVE_COLOUR->ID)) {
                $gcolour = $data->datastage->GLOVE_COLOUR->ID;
            } else {
                $gcolour = $data->datastage->GLOVE_COLOUR;
            }

            //Size
            $sizee = array();
            foreach ($data->datastage->GLOVE_SIZE as $txt) {
                array_push($sizee, $txt->ID);
            }
            $gsize = implode(', ', $sizee);

            //Segment
            // if (!empty($data->datastage->SEGMENT_TERRITORY->ID)) {
            //     $segment = $data->datastage->SEGMENT_TERRITORY->ID;
            // } else {
            //     $segment = $data->datastage->SEGMENT_TERRITORY;
            // }
            $segg = array();
            foreach ($data->datastage->SEGMENT_TERRITORY as $txt) {
                array_push($segg, $txt->ID);
            }
            $segment = implode(', ', $segg);

            //Geographical
            if (!empty($data->datastage->GEOGRAPHICAL->ID)) {
                $geo = $data->datastage->GEOGRAPHICAL->ID;
            } else {
                $geo = $data->datastage->GEOGRAPHICAL;
            }

            //Country
            if (!empty($data->datastage->COUNTRY->ID)) {
                $country = $data->datastage->COUNTRY->ID;
            } else {
                $country = $data->datastage->COUNTRY;
            }

            //Special Feature
            if (is_array($datastage->SPECIAL_FEATURES)) {
                $spec_feat = implode(', ', $data->datastage->SPECIAL_FEATURES);
            }            

            $sqlarr = oci_parse($dbcon , $sql);
            oci_bind_by_name($sqlarr, ':SKU', $sku);
            oci_bind_by_name($sqlarr, ':SKU_REQUIREMENT', $data->datastage->SKU_REQUIREMENT);
            oci_bind_by_name($sqlarr, ':VOLUME_EXP1', $data->datastage->VOLUME_EXP1);
            oci_bind_by_name($sqlarr, ':VOLUME_EXP2', $data->datastage->VOLUME_EXP2);
            oci_bind_by_name($sqlarr, ':VOLUME_EXP3', $data->datastage->VOLUME_EXP3);
            oci_bind_by_name($sqlarr, ':PRICE_EXP', $data->datastage->PRICE_EXP);
            oci_bind_by_name($sqlarr, ':CUSTOMER', $customer);
            oci_bind_by_name($sqlarr, ':CUSTOMER_CODE', $data->datastage->CUSTOMER_CODE);
            oci_bind_by_name($sqlarr, ':SEGMENT_TERRITORY', $segment);
            oci_bind_by_name($sqlarr, ':MEDICAL', $data->datastage->MEDICAL);
            oci_bind_by_name($sqlarr, ':FOOD_GRADE', $data->datastage->FOOD_GRADE);
            oci_bind_by_name($sqlarr, ':PPE', $data->datastage->PPE);
            oci_bind_by_name($sqlarr, ':INDUSTRIAL', $data->datastage->INDUSTRIAL);
            oci_bind_by_name($sqlarr, ':SEGMENT_OTH', $data->datastage->SEGMENT_OTH);
            oci_bind_by_name($sqlarr, ':PROTOTYPE_REQUIRED', $data->datastage->PROTOTYPE_REQUIRED);
            oci_bind_by_name($sqlarr, ':CERT_REQUIRED', $data->datastage->CERT_REQUIRED);
            oci_bind_by_name($sqlarr, ':AQL_REQUIREMENT', $data->datastage->AQL_REQUIREMENT);
            oci_bind_by_name($sqlarr, ':CREATED_BY', $data->datastage->CREATED_BY);
            oci_bind_by_name($sqlarr, ':CUSTOMER_ADDRESS', $data->datastage->CUSTOMER_ADDRESS);
            oci_bind_by_name($sqlarr, ':GLOVE_COLOUR', $gcolour);
            oci_bind_by_name($sqlarr, ':GLOVE_TYPE', $data->datastage->GLOVE_TYPE);
            oci_bind_by_name($sqlarr, ':TARGET_WEIGHT', $data->datastage->TARGET_WEIGHT);
            oci_bind_by_name($sqlarr, ':GLOVE_LENGTH', $data->datastage->GLOVE_LENGTH);
            oci_bind_by_name($sqlarr, ':GLOVE_SIZE', $gsize);
            oci_bind_by_name($sqlarr, ':GLOVE_SURFACE', $data->datastage->GLOVE_SURFACE);
            oci_bind_by_name($sqlarr, ':GLOVE_DONNING', $data->datastage->GLOVE_DONNING);
            oci_bind_by_name($sqlarr, ':SPECIAL_FEATURES', $spec_feat);
            oci_bind_by_name($sqlarr, ':SPECIAL_REQUEST', $data->datastage->SPECIAL_REQUEST);
            oci_bind_by_name($sqlarr, ':ATTENTION_TO', $data->datastage->ATTENTION_TO);
            oci_bind_by_name($sqlarr, ':DELV_ADDRESS', $data->datastage->DELV_ADDRESS);
            oci_bind_by_name($sqlarr, ':CONTACT_NUMBER', $data->datastage->CONTACT_NUMBER);
            oci_bind_by_name($sqlarr, ':SEND_OUT_BY_DATE', $data->datastage->SEND_OUT_BY_DATE);
            oci_bind_by_name($sqlarr, ':GEOGRAPHICAL', $geo);
            oci_bind_by_name($sqlarr, ':COUNTRY', $country);
            oci_bind_by_name($sqlarr, ':STAGE1_REMARKS', $data->datastage->STAGE1_REMARKS);
            oci_bind_by_name($sqlarr, ':VOLUME_REMARKS', $data->datastage->VOLUME_REMARKS);
            oci_bind_by_name($sqlarr, ':CLOSE_ON', $data->datastage->CLOSE_ON);
            oci_bind_by_name($sqlarr, ':SALES_ID', $data->datastage->SALES_ID->ID);
            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->datastage->ID;

            //Customer
            if (!empty($data->datastage->CUSTOMER->ID)) {
                $customer = $data->datastage->CUSTOMER->ID;
            } else {
                $customer = $data->datastage->CUSTOMER;
            }

            //SKU
            if (!empty($data->datastage->SKU->ID)) {
                $sku = $data->datastage->SKU->ID;
            } else {
                $sku = $data->datastage->SKU;
            }

            //Colour
            if (!empty($data->datastage->GLOVE_COLOUR->ID)) {
                $gcolour = $data->datastage->GLOVE_COLOUR->ID;
            } else {
                $gcolour = $data->datastage->GLOVE_COLOUR;
            }

            //Size
            $sizee = array();
            foreach ($data->datastage->GLOVE_SIZE as $txt) {
                array_push($sizee, $txt->ID);
            }
            $gsize = implode(', ', $sizee);

            //Segment
            // if (!empty($data->datastage->SEGMENT_TERRITORY->ID)) {
            //     $segment = $data->datastage->SEGMENT_TERRITORY->ID;
            // } else {
            //     $segment = $data->datastage->SEGMENT_TERRITORY;
            // }
            $segg = array();
            foreach ($data->datastage->SEGMENT_TERRITORY as $txt) {
                array_push($segg, $txt->ID);
            }
            $segment = implode(', ', $segg);

            //Geographical
            if (!empty($data->datastage->GEOGRAPHICAL->ID)) {
                $geo = $data->datastage->GEOGRAPHICAL->ID;
            } else {
                $geo = $data->datastage->GEOGRAPHICAL;
            }

            //Country
            if (!empty($data->datastage->COUNTRY->ID)) {
                $country = $data->datastage->COUNTRY->ID;
            } else {
                $country = $data->datastage->COUNTRY;
            }

            //Special Feature
            if (is_array($datastage->SPECIAL_FEATURES)) {
                $spec_feat = implode(', ', $data->datastage->SPECIAL_FEATURES);
            }

            $sql = "UPDATE ytycustom.ple_header 
                       SET SKU = :SKU,
                           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, 
                           MEDICAL = :MEDICAL,
                           FOOD_GRADE = :FOOD_GRADE,
                           PPE = :PPE,
                           INDUSTRIAL = :INDUSTRIAL,
                           SEGMENT_OTH = :SEGMENT_OTH,
                           PROTOTYPE_REQUIRED = :PROTOTYPE_REQUIRED,
                           STAGE_POS = 1,
                           CERT_REQUIRED = :CERT_REQUIRED,
                           AQL_REQUIREMENT = :AQL_REQUIREMENT,
                           MODIFIED_BY = :MODIFIED_BY,
                           MODIFIED_DATE = SYSDATE,
                           CUSTOMER_ADDRESS = :CUSTOMER_ADDRESS,
                           GLOVE_COLOUR = :GLOVE_COLOUR,
                           GLOVE_TYPE = :GLOVE_TYPE,
                           TARGET_WEIGHT = :TARGET_WEIGHT, 
                           GLOVE_LENGTH = :GLOVE_LENGTH, 
                           GLOVE_SIZE = :GLOVE_SIZE, 
                           GLOVE_SURFACE = :GLOVE_SURFACE, 
                           GLOVE_DONNING = :GLOVE_DONNING, 
                           SPECIAL_FEATURES = :SPECIAL_FEATURES, 
                           SPECIAL_REQUEST = :SPECIAL_REQUEST, 
                           ATTENTION_TO = :ATTENTION_TO, 
                           DELV_ADDRESS = :DELV_ADDRESS, 
                           CONTACT_NUMBER = :CONTACT_NUMBER, 
                           SEND_OUT_BY_DATE = TO_DATE(:SEND_OUT_BY_DATE,'YYYY-MM-DD'),
                           GEOGRAPHICAL = :GEOGRAPHICAL, 
                           COUNTRY = :COUNTRY, 
                           STAGE1_REMARKS = :STAGE1_REMARKS,
                           VOLUME_REMARKS = :VOLUME_REMARKS, 
                           CLOSE_ON = TO_DATE(:CLOSE_ON,'YYYY-MM-DD'),
                           SALES_ID = :SALES_ID
                     WHERE ID = :ID";

            $sqlarr = oci_parse($dbcon , $sql);
            oci_bind_by_name($sqlarr, ':SKU', $sku);
            oci_bind_by_name($sqlarr, ':SKU_REQUIREMENT', $data->datastage->SKU_REQUIREMENT);
            oci_bind_by_name($sqlarr, ':VOLUME_EXP1', $data->datastage->VOLUME_EXP1);
            oci_bind_by_name($sqlarr, ':VOLUME_EXP2', $data->datastage->VOLUME_EXP2);
            oci_bind_by_name($sqlarr, ':VOLUME_EXP3', $data->datastage->VOLUME_EXP3);
            oci_bind_by_name($sqlarr, ':PRICE_EXP', $data->datastage->PRICE_EXP);
            oci_bind_by_name($sqlarr, ':CUSTOMER', $customer);
            oci_bind_by_name($sqlarr, ':CUSTOMER_CODE', $data->datastage->CUSTOMER_CODE);
            oci_bind_by_name($sqlarr, ':SEGMENT_TERRITORY', $segment);
            oci_bind_by_name($sqlarr, ':MEDICAL', $data->datastage->MEDICAL);
            oci_bind_by_name($sqlarr, ':FOOD_GRADE', $data->datastage->FOOD_GRADE);
            oci_bind_by_name($sqlarr, ':PPE', $data->datastage->PPE);
            oci_bind_by_name($sqlarr, ':INDUSTRIAL', $data->datastage->INDUSTRIAL);
            oci_bind_by_name($sqlarr, ':SEGMENT_OTH', $data->datastage->SEGMENT_OTH);
            oci_bind_by_name($sqlarr, ':PROTOTYPE_REQUIRED', $data->datastage->PROTOTYPE_REQUIRED);
            oci_bind_by_name($sqlarr, ':CERT_REQUIRED', $data->datastage->CERT_REQUIRED);
            oci_bind_by_name($sqlarr, ':AQL_REQUIREMENT', $data->datastage->AQL_REQUIREMENT);
            oci_bind_by_name($sqlarr, ':MODIFIED_BY', $data->MODIFIED_BY); 
            oci_bind_by_name($sqlarr, ':CUSTOMER_ADDRESS', $data->datastage->CUSTOMER_ADDRESS);
            oci_bind_by_name($sqlarr, ':GLOVE_COLOUR', $gcolour);
            oci_bind_by_name($sqlarr, ':GLOVE_TYPE', $data->datastage->GLOVE_TYPE);
            oci_bind_by_name($sqlarr, ':TARGET_WEIGHT', $data->datastage->TARGET_WEIGHT);
            oci_bind_by_name($sqlarr, ':GLOVE_LENGTH', $data->datastage->GLOVE_LENGTH);
            oci_bind_by_name($sqlarr, ':GLOVE_SIZE', $gsize);
            oci_bind_by_name($sqlarr, ':GLOVE_SURFACE', $data->datastage->GLOVE_SURFACE);
            oci_bind_by_name($sqlarr, ':GLOVE_DONNING', $data->datastage->GLOVE_DONNING);
            oci_bind_by_name($sqlarr, ':SPECIAL_FEATURES', $spec_feat);
            oci_bind_by_name($sqlarr, ':SPECIAL_REQUEST', $data->datastage->SPECIAL_REQUEST);
            oci_bind_by_name($sqlarr, ':ATTENTION_TO', $data->datastage->ATTENTION_TO);
            oci_bind_by_name($sqlarr, ':DELV_ADDRESS', $data->datastage->DELV_ADDRESS);
            oci_bind_by_name($sqlarr, ':CONTACT_NUMBER', $data->datastage->CONTACT_NUMBER);
            oci_bind_by_name($sqlarr, ':SEND_OUT_BY_DATE', $data->datastage->SEND_OUT_BY_DATE);
            oci_bind_by_name($sqlarr, ':GEOGRAPHICAL', $geo);
            oci_bind_by_name($sqlarr, ':COUNTRY', $country);
            oci_bind_by_name($sqlarr, ':STAGE1_REMARKS', $data->datastage->STAGE1_REMARKS);
            oci_bind_by_name($sqlarr, ':VOLUME_REMARKS', $data->datastage->VOLUME_REMARKS);
            oci_bind_by_name($sqlarr, ':CLOSE_ON', $data->datastage->CLOSE_ON);
            oci_bind_by_name($sqlarr, ':SALES_ID', $data->datastage->SALES_ID->ID);
            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;
            }
        }

        //REGULATORY
        $sql = "SELECT COUNT(1) CTR
                  FROM ytycustom.ple_regulatory
                 WHERE header_id = :header_id";

        $sqlarr = oci_parse($dbcon , $sql);
        oci_bind_by_name($sqlarr, ':header_id', $newid);
        $r = oci_execute($sqlarr);
        while ($row = oci_fetch_array($sqlarr)) {
            $exists = $row['CTR'];
        }
        
        if ($exists == "0") {
            $sql = "INSERT INTO ytycustom.ple_regulatory
                                (HEADER_ID, C_510K, ASTM_D6319, EN_455, ASTM_EN_455, ISO_11193, AS_NZS_4011, EN_16523_1, 
                                 PPE_EU, ASTM_D6978, ISO_10993_5, ELUTION_TEST, HEAVY_METAL, JAPAN, CHINA, EU, US, 
                                 OTHERS_REQ, ASTM_F1671, ENDOTOXIN_LAL, PYROGEN, BIOBURDEN, SILICONE_OIL, DRAIZE_95, 
                                 AS_NZS_4011_1, COEFICIENT_FRICTION, BIO_COMPATIBILITY, SEM, VOC, GRIP_TEST, NFPA_1999, 
                                 ISO_10993_11, OTHERS_CC)
                         VALUES (:HEADER_ID, :C_510K, :ASTM_D6319, :EN_455, :ASTM_EN_455, :ISO_11193, :AS_NZS_4011, :EN_16523_1, 
                                 :PPE_EU, :ASTM_D6978, :ISO_10993_5, :ELUTION_TEST, :HEAVY_METAL, :JAPAN, :CHINA, :EU, :US, 
                                 :OTHERS_REQ, :ASTM_F1671, :ENDOTOXIN_LAL, :PYROGEN, :BIOBURDEN, :SILICONE_OIL, :DRAIZE_95, 
                                 :AS_NZS_4011_1, :COEFICIENT_FRICTION, :BIO_COMPATIBILITY, :SEM, :VOC, :GRIP_TEST, :NFPA_1999, 
                                 :ISO_10993_11, :OTHERS_CC)";

        } else {
        
            $sql = "UPDATE ytycustom.ple_regulatory
                       SET C_510K = :C_510K, 
                           ASTM_D6319 = :ASTM_D6319, 
                           EN_455 = :EN_455, 
                           ASTM_EN_455 = :ASTM_EN_455, 
                           ISO_11193 = :ISO_11193, 
                           AS_NZS_4011 = :AS_NZS_4011, 
                           EN_16523_1 = :EN_16523_1, 
                           PPE_EU = :PPE_EU, 
                           ASTM_D6978 = :ASTM_D6978, 
                           ISO_10993_5 = :ISO_10993_5, 
                           ELUTION_TEST = :ELUTION_TEST, 
                           HEAVY_METAL = :HEAVY_METAL, 
                           JAPAN = :JAPAN, 
                           CHINA = :CHINA, 
                           EU = :EU, 
                           US = :US, 
                           OTHERS_REQ = :OTHERS_REQ, 
                           ASTM_F1671 = :ASTM_F1671, 
                           ENDOTOXIN_LAL = :ENDOTOXIN_LAL, 
                           PYROGEN = :PYROGEN, 
                           BIOBURDEN =:BIOBURDEN, 
                           SILICONE_OIL = :SILICONE_OIL, 
                           DRAIZE_95 = :DRAIZE_95, 
                           AS_NZS_4011_1 = :AS_NZS_4011_1, 
                           COEFICIENT_FRICTION = :COEFICIENT_FRICTION, 
                           BIO_COMPATIBILITY = :BIO_COMPATIBILITY, 
                           SEM = :SEM, 
                           VOC = :VOC, 
                           GRIP_TEST = :GRIP_TEST, 
                           NFPA_1999 = :NFPA_1999, 
                           ISO_10993_11 = :ISO_10993_11, 
                           OTHERS_CC = :OTHERS_CC
                     WHERE HEADER_ID = :HEADER_ID";
        }

        $sqlarr = oci_parse($dbcon , $sql);
        oci_bind_by_name($sqlarr, ':HEADER_ID', $newid);
        oci_bind_by_name($sqlarr, ':C_510K', $data->dataregulatory->C_510K);
        oci_bind_by_name($sqlarr, ':ASTM_D6319', $data->dataregulatory->ASTM_D6319);
        oci_bind_by_name($sqlarr, ':EN_455', $data->dataregulatory->EN_455);
        oci_bind_by_name($sqlarr, ':ASTM_EN_455', $data->dataregulatory->ASTM_EN_455);
        oci_bind_by_name($sqlarr, ':ISO_11193', $data->dataregulatory->ISO_11193);
        oci_bind_by_name($sqlarr, ':AS_NZS_4011', $data->dataregulatory->AS_NZS_4011);
        oci_bind_by_name($sqlarr, ':EN_16523_1', $data->dataregulatory->EN_16523_1);
        oci_bind_by_name($sqlarr, ':PPE_EU', $data->dataregulatory->PPE_EU);
        oci_bind_by_name($sqlarr, ':ASTM_D6978', $data->dataregulatory->ASTM_D6978);
        oci_bind_by_name($sqlarr, ':ISO_10993_5', $data->dataregulatory->ISO_10993_5);
        oci_bind_by_name($sqlarr, ':ELUTION_TEST', $data->dataregulatory->ELUTION_TEST);
        oci_bind_by_name($sqlarr, ':HEAVY_METAL', $data->dataregulatory->HEAVY_METAL);
        oci_bind_by_name($sqlarr, ':JAPAN', $data->dataregulatory->JAPAN);
        oci_bind_by_name($sqlarr, ':CHINA', $data->dataregulatory->CHINA);
        oci_bind_by_name($sqlarr, ':EU', $data->dataregulatory->EU);
        oci_bind_by_name($sqlarr, ':US', $data->dataregulatory->US);
        oci_bind_by_name($sqlarr, ':OTHERS_REQ', $data->dataregulatory->OTHERS_REQ);
        oci_bind_by_name($sqlarr, ':ASTM_F1671', $data->dataregulatory->ASTM_F1671);
        oci_bind_by_name($sqlarr, ':ENDOTOXIN_LAL', $data->dataregulatory->ENDOTOXIN_LAL);
        oci_bind_by_name($sqlarr, ':PYROGEN', $data->dataregulatory->PYROGEN);
        oci_bind_by_name($sqlarr, ':BIOBURDEN', $data->dataregulatory->BIOBURDEN);
        oci_bind_by_name($sqlarr, ':SILICONE_OIL', $data->dataregulatory->SILICONE_OIL);
        oci_bind_by_name($sqlarr, ':DRAIZE_95', $data->dataregulatory->DRAIZE_95);
        oci_bind_by_name($sqlarr, ':AS_NZS_4011_1', $data->dataregulatory->AS_NZS_4011_1);
        oci_bind_by_name($sqlarr, ':COEFICIENT_FRICTION', $data->dataregulatory->COEFICIENT_FRICTION);
        oci_bind_by_name($sqlarr, ':BIO_COMPATIBILITY', $data->dataregulatory->BIO_COMPATIBILITY);
        oci_bind_by_name($sqlarr, ':SEM', $data->dataregulatory->SEM);
        oci_bind_by_name($sqlarr, ':VOC', $data->dataregulatory->VOC);
        oci_bind_by_name($sqlarr, ':GRIP_TEST', $data->dataregulatory->GRIP_TEST);
        oci_bind_by_name($sqlarr, ':NFPA_1999', $data->dataregulatory->NFPA_1999);
        oci_bind_by_name($sqlarr, ':ISO_10993_11', $data->dataregulatory->ISO_10993_11);
        oci_bind_by_name($sqlarr, ':OTHERS_CC', $data->dataregulatory->OTHERS_CC);
        $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);
?>