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

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

    if (!empty($data->CUSTOMER->ID)) {
        $additional = " AND cc_party_id = :customer_id ";
    }

    $sql = "SELECT NVL(ROUND(AVG(COUNT(CC_ID)),0),0) avg_complaints
              FROM YTYCUSTOM.customer_complaint_hd
             WHERE TRUNC(cc_received_on,'MONTH') BETWEEN TO_DATE(:from_dt, 'YYYY-MM-DD') AND TO_DATE(:to_dt, 'YYYY-MM-DD')
                   ".$additional."
          GROUP BY TRUNC(cc_received_on,'MONTH')";

    $sqlarr = oci_parse($dbcon , $sql);
    oci_bind_by_name($sqlarr, ':from_dt', date('Y-m-d', strtotime($data->FROM_DATE. ' +1 day')));
    oci_bind_by_name($sqlarr, ':to_dt', date('Y-m-d', strtotime($data->TO_DATE. ' +1 day')));
    if (!empty($data->CUSTOMER->ID)) {
     oci_bind_by_name($sqlarr, ':customer_id', $data->CUSTOMER->ID);
    }
    $r = oci_execute($sqlarr);

    if (!$r) {
         $e = oci_error($sqlarr);
         print json_encode($e['message']);
    }
    
    oci_fetch_all($sqlarr, $rows, null, null, OCI_FETCHSTATEMENT_BY_ROW);
    
    $result[] = [
         "message" => $resMsg,
         "data" => $rows
    ];

    print json_encode($result);
?>