<?php
    include "../db/headerApi.php";
    include "../db/connection_main.php";

    $json = file_get_contents('php://input');
    $data = json_decode($json);

    $sql = " SELECT a.id, a.customer_id, a.brand_id, a.brand_name, a.carton_w, a.carton_l, a.carton_h,  
                    a.validation_code, a.loading_pattern, a.dose_loc_min, a.dose_loc_max, a.dose_req_min,
                    a.dose_req_max, a.carton_density, a.packing_density
               FROM ytycustom.gth_customer_brand_master a
              WHERE a.id = :bmid";

    $sqlarr = oci_parse($dbcon , $sql);
    oci_bind_by_name($sqlarr, ':bmid', $data->bmid);
    $r = oci_execute($sqlarr);
    if (!$r) {
         $e = oci_error($sqlarr);
         print json_encode($e['message']);
    }
    oci_fetch_all($sqlarr, $rows_main, null, null, OCI_FETCHSTATEMENT_BY_ROW);
    
    //Customer
    $sql = "SELECT customer_id id, customer_name text
              FROM apps.xxyty_cust_gth_v
             WHERE customer_id = :customerid";
    $sqlarr = oci_parse($dbcon , $sql);
    oci_bind_by_name($sqlarr, ':customerid', $rows_main[0]["CUSTOMER_ID"]);
    oci_execute($sqlarr);
    oci_fetch_all($sqlarr, $customer, null, null, OCI_FETCHSTATEMENT_BY_ROW);

    $rows_main[0]["CUSTOMER_ID"] = $customer[0];

    $result[] = [
                    "main" => $rows_main,
                    "message" => $err_msg
                ];    

    print json_encode($result);
?>