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

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

    $sql = "SELECT period_name id, period_name text
              FROM APPS.YTY_G_PRC_PERIOD_LOV
             WHERE trunc(start_date, 'MONTH') >= trunc(add_months(trunc(SYSDATE),1), 'MONTH')
          ORDER BY start_date DESC";

    $sqlarr = oci_parse($dbcon , $sql);
    $r = oci_execute($sqlarr);
    $resMsg = "OK";

    if (!$r) {
         $e = oci_error($sqlarr);
         $resMsg = json_encode($e['message']);
         goto finalStep;
    }
    oci_fetch_all($sqlarr, $rows_main, null, null, OCI_FETCHSTATEMENT_BY_ROW);

finalStep:
    $result[] = [
        "message" => $resMsg,
        "data" => $rows_main
    ];

    print json_encode($result);
?>