<?php
    include "../db/headerApi.php";
    include "../db/connection_main.php";

    $json = file_get_contents('php://input');
    $data = json_decode($json);

    switch($data->LOCATION) {
        case "GPA": 
            $location = " AND tmb_org_id = '86' ";
            break;

        case "GPL":
            $location = " AND tmb_org_id = '102' ";
            break;

        case "YTYL":
            $location = " AND tmb_org_id = '84' ";
            break;

        case "YTYA":
            $location = " AND tmb_org_id = '122' ";
            break;
    }

    if (!empty($data->MONTH)) {
        $dt = " AND trunc(tmb_julian_date, 'MONTH') = trunc(to_date('".date('Y-m-d', strtotime($data->MONTH. ' +1 day'))."', 'YYYY-MM-DD'), 'MONTH') ";
    
    } else {
        if (!empty($data->QUARTER) && !empty($data->YEAR)) {
            $dt = " AND trunc(tmb_julian_date,'YEAR') = trunc(to_date('".date('Y-m-d', strtotime($data->YEAR. ' +1 day'))."', 'YYYY-MM-DD'), 'YEAR')  
                    AND to_char(tmb_julian_date,'Q') = '".$data->QUARTER."' ";

        } else {
            if (!empty($data->YEAR)) {
                $dt = " AND trunc(tmb_julian_date,'YEAR') = trunc(to_date('".date('Y-m-d', strtotime($data->YEAR. ' +1 day'))."', 'YYYY-MM-DD'), 'YEAR') ";
            }

        }
    }

    $sql = "SELECT NVL(SUM(tmb_bin_tot_pcs),0) tmb_bin_tot_pcs, NVL((sum(tmb_bin_wt_aft_dry) / 1000),0) mt
              FROM production.tumbler_master
             WHERE nvl(tmb_cancel_fl, 'N') = 'N'
               ".$dt."
               ".$location;
    //die($sql);

    $sqlarr = oci_parse($dbcon , $sql);
    $r = oci_execute($sqlarr);
    $resMsg = "OK";

    if (!$r) {
         $e = oci_error($sqlarr);
         $resMsg = json_encode($e['message']);
    }
    oci_fetch_all($sqlarr, $rows_main, null, null, OCI_FETCHSTATEMENT_BY_ROW);

    $result[] = [
        "message" => $resMsg,
        "data" => $rows_main
    ];

    print json_encode($result);
?>