<?php 
$today = date ( 'Y-m-d H:i:s' , strtotime ( '+0 minute' , strtotime (date("Y-m-d H:i:s"))));
$token_key = substr($_SERVER["HTTP_AUTHORIZATION_TOKEN"], 7);
if ( $_SERVER['REQUEST_METHOD'] === "POST" ) {
    $request_service = $_POST["service"];
}elseif ( $_SERVER['REQUEST_METHOD'] === "GET" ) {
    $request_uri = explode('/', $_SERVER['REQUEST_URI']);
	$request_service = ! empty($request_uri[3]) ? $request_uri[3] : '';
}
$auth = autCliente($bd_conn, $_SERVER["HTTP_CLIENT_ID"], $request_service, $token_key, $_SERVER["HTTP_P0_API_KEY"], $today );
function autCliente($bd, $client_id, $service, $token, $serv_key, $today)
{
    $sql =  "   SELECT COUNT(A.CLIENTE) AS TOTAL
                FROM API_ACCESS A
                INNER JOIN API_CLIENTES C ON C.CLIENTE = A.CLIENTE
                INNER JOIN API_TOKEN T ON T.CLIENTE = A.CLIENTE
                WHERE C.CLIENT_ID = ? AND A.SERVICIO = ? AND A.SERV_KEY = ? AND ( T.TOKEN = ? AND T.BAJA >= ? ) ";
    $base = $bd->prepare($sql);
    $client_id = mysqli_real_escape_string($bd, $client_id);
    $service = mysqli_real_escape_string($bd, $service);
    $serv_key = mysqli_real_escape_string($bd, $serv_key);
    $token = mysqli_real_escape_string($bd, $token);
    $today = mysqli_real_escape_string($bd, $today);
    $base->bind_param('sssss', $client_id, $service, $serv_key, $token, $today);
    $base->execute();
    $result = mysqli_fetch_array($base->get_result());
    $base->close();
    return $result["TOTAL"];
}
?>