<?php
    include "../db/headerApi.php";
    include "../db/connection_main.php";

    $json = file_get_contents('php://input');
    $data = json_decode($json);

    if ($data->mode == "Entry") {
      $sql = "SELECT COUNT(access_stage) ctr
                FROM ytycustom.ple_access
               WHERE emp_id = :emp_id
                 AND access_stage = :stage";
                 
      $sqlarr = oci_parse($dbcon , $sql);
      oci_bind_by_name($sqlarr, ':emp_id', $data->emp_id);
      oci_bind_by_name($sqlarr, ':stage', $data->stage);
      $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);
    
    } else if ($data->mode == "Minimum") {
    
      $sql = "SELECT MIN(access_stage) access_stage
                FROM ytycustom.ple_access
               WHERE emp_id = :emp_id
                 AND access_stage != '0'";
                 
      $sqlarr = oci_parse($dbcon , $sql);
      oci_bind_by_name($sqlarr, ':emp_id', $data->emp_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);
    
    }

    print json_encode($rows);
?>