<?php 
function queryUpdate($bd, $_req, $_set, $_where)
{
    $query = $_req . $_set . $_where;
    mysqli_query($bd, $query);
    return mysqli_affected_rows($bd);
}
function queryInsert($bd, $_req, $_set, $_values)
{
    $query = $_req . $_set . $_values;
    mysqli_query($bd, $query);
    return mysqli_affected_rows($bd);
}
function querySelect($bd, $_select, $_from, $_where)
{
    $sql =  $_select . $_from . $_where;
    $base = $bd->query($sql);
    $row = mysqli_fetch_array($base);
    $result = $row['RESULT'];
    return $result;
}
function querySelectMultiple($bd, $_select, $_from, $_where)
{
    $sql =  $_select . $_from . $_where;
    $base = $bd->query($sql);
    $row = mysqli_fetch_array($base);
    return $row;
}	
function getClientToken($bd, $grant_type, $client_secret, $client_id, $service, $code)
{
    $sql =  "   SELECT C.CLIENTE
                FROM API_CLIENTES C
                INNER JOIN API_ACCESS A ON C.CLIENTE = A.CLIENTE
                WHERE C.GRANT_TYPE = ? AND C.CLIENT_SECRET = ? AND C.CLIENT_ID = ? AND A.SERVICIO = ? AND A.SERV_KEY = ? ";
    $base = $bd->prepare($sql);
    $base->bind_param('sssss', $grant_type, $client_secret, $client_id, $service, $code);
    $base->execute();
    $result = mysqli_fetch_array($base->get_result());
    $base->close();
    return $result;
}
function maxCodigoVeniculo($bd)
{
    $sql =  "   SELECT MAX(V.CODIGO) AS PROX_COD
                FROM VEHICULOS V";
    $base = $bd->prepare($sql);
    $base->execute();
    $result = mysqli_fetch_array($base->get_result());
    $base->close();
    return $result["PROX_COD"];
}	
function existMarcaVehiculo($bd, $cod_marca)
{
    $sql =  "   SELECT COUNT(V.CODIGO) AS COD_EXIST
                FROM VEHICULOS_MARCAS V
                WHERE V.CODIGO = $cod_marca";
    $base = $bd->prepare($sql);
    $base->bind_param('i', $cod_marca);
    $base->execute();
    $result = mysqli_fetch_array($base->get_result());
    $base->close();
    return $result["COD_EXIST"];
}
function existModeloVehiculo($bd, $cod_marca, $cod_modelo)
{
    $sql =  "   SELECT COUNT(MO.CODIGO) AS COD_EXIST
                FROM VEHICULOS_MODELOS MO
                INNER JOIN VEHICULOS_MARCAS MA ON MO.MARCA = MA.CODIGO
                WHERE MA.CODIGO = ? AND MO.CODIGO = ?";
    $base = $bd->prepare($sql);
    $base->bind_param('ii', $cod_marca, $cod_modelo);
    $base->execute();
    $result = mysqli_fetch_array($base->get_result());
    $base->close();
    return $result["COD_EXIST"];
}
function insertVehiculo($bd,$cod_car,$cli_user,$car_tipo,$car_id,$car_marca,$car_modelo,$car_version,$car_gama,$car_matricula,$car_bastidor,$car_color,$car_notas,$car_km,$car_year, $mostrar, $car_precio_venta, $car_venta_base, $car_venta_opciones, $car_venta_pff, $car_venta_transporte, $car_venta_tipoiva, $car_venta_tipoiedmt, $car_precio_compra, $car_compra_pff, $car_compra_opciones, $car_compra_transporte, $car_compra_base, $car_compra_tipoiva)
{
    $activo = 1;
    $estado = "PRS";
    $sql =  " INSERT INTO VEHICULOS (CODIGO, USUARIO, TIPO, IDCAR, MARCA, MODELO, VERSION, GAMA, MATRICULA, BASTIDOR, COLOR, NOTAS, KM, ANO_FAB, ALTA, ACTIVO, ESTADO, MOSTRAR, PRECIO_VENTA, VENTA_BASE, VENTA_OPCIONES, VENTA_PFF, VENTA_TRANSPORTE, VENTA_TIPOIVA, VENTA_TIPOIEDMT, PRECIO_COMPRA, COMPRA_PFF, COMPRA_OPCIONES, COMPRA_TRANSPORTE, COMPRA_BASE, COMPRA_TIPOIVA) 
              VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, now(), ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
    $base = $bd->prepare($sql);
    $base->bind_param('isssiissssssiiissddddiiddddii', $cod_car, $cli_user, $car_tipo, $car_id, $car_marca, $car_modelo, $car_version, $car_gama, $car_matricula, $car_bastidor, $car_color, $car_notas, $car_km, $car_year, $activo, $estado, $mostrar, $car_precio_venta, $car_venta_base, $car_venta_opciones, $car_venta_pff, $car_venta_transporte, $car_venta_tipoiva, $car_venta_tipoiedmt, $car_precio_compra, $car_compra_pff, $car_compra_opciones, $car_compra_transporte, $car_compra_base, $car_compra_tipoiva);
    $base->execute();
}
function get_id_unico() 
{
	return date( "YmdHis" ) . sprintf( "%04d", rand( 0, 9999 ) );
}
function createToken($bd,$cliente,$token,$date)
{
	$sql =  " INSERT INTO API_TOKEN (CLIENTE, TOKEN, BAJA) 
              VALUES ( ?, ?, ?)";
    $base = $bd->prepare($sql);
    $base->bind_param('sss', $cliente, $token, $date);
    $base->execute();
}
function descripcionMarca($bd, $car_marca){
    $sql =  "   SELECT M.DESCRIPCION
                FROM VEHICULOS_MARCAS M
                WHERE M.CODIGO = ? LIMIT 1";
    $base = $bd->prepare($sql);
    $base->bind_param('i', $car_marca);
    $base->execute();
    $result = mysqli_fetch_array($base->get_result());
    $base->close();
    return $result["DESCRIPCION"];
}
function descripcionModelo($bd, $car_modelo)
{
    $sql =  "   SELECT M.DESCRIPCION
                FROM VEHICULOS_MODELOS M
                WHERE M.CODIGO = ? LIMIT 1";
    $base = $bd->prepare($sql);
    $base->bind_param('i', $car_modelo);
    $base->execute();
    $result = mysqli_fetch_array($base->get_result());
    $base->close();
    return $result["DESCRIPCION"];
}
function validaBastidor($bd, $car_bastidor)
{
    $sql =  "   SELECT COUNT(V.BASTIDOR) AS TOTAL
                FROM VEHICULOS V
                WHERE V.BASTIDOR = ? AND V.ACTIVO = 1";
    $base = $bd->prepare($sql);
    $base->bind_param('s', $car_bastidor);
    $base->execute();
    $result = mysqli_fetch_array($base->get_result());
    $base->close();
    return $result["TOTAL"];
}
?>