<?php
include_once (ROOT . FOLDER_CORE .'/auth.php'); 
if ($auth == 1) {
    $search_type = ! empty($uri[4]) ? $uri[4] : '';
    if ($search_type === 'BASTIDOR') {
        $bastidor = ! empty($uri[5]) ? $uri[5] : 'no_bastidor';
        if ($bastidor === 'no_bastidor') {
            $data = array();
                $data["document"] = array ( 
                    "status" => "message: error",
                    "message" => "Missing search value"
                );
        } else {
            $base = consultaCarBastidor($bd_conn, $bastidor);
            if (! empty($base["IDCAR"])) {
                $data = array();
                //CARGO EL ARRAY DE CONEXIONES
                $data[$base["IDCAR"]] = array ( 
                    "car_id" => $base["IDCAR"],
                    "car_marca" => $base["MARCA"],
                    "car_modelo" => $base["MODELO"],
                    "car_version" => mb_strtoupper($base["VERSION"], 'UTF-8'),
                    "car_gama" => mb_strtoupper($base["GAMA"], 'UTF-8'),
                    "car_mostrar" => $base["MOSTRAR"],
                    "car_matrcicula" => $base["MATRICULA"],
                    "car_bastidor" => $base["BASTIDOR"],
                    "car_km" => $base["KM"],
                    "car_cajacambios" => $base["CAJACAMBIOS"],
                    "car_fabridado" => $base["ANO_FAB"],
                    "car_color" => mb_strtoupper($base["COLOR"], 'UTF-8')
                );
            }else{
                $data = array();
                $data["document"] = array ( 
                    "status" => "message: error",
                    "message" => "Car not found"
                );
            }
        }
    }elseif ($search_type === 'CODIGO') {
        $code_ext = ! empty($uri[5]) ? $uri[5] : 'no_code_ext';
        $id_ext = ! empty($uri[6]) ? $uri[6] : 'no_id_ext';
        if ($code_ext === 'no_code_ext' OR $id_ext === 'no_id_ext') {
            $data = array();
                $data["document"] = array ( 
                    "status" => "message: error",
                    "message" => "Missing search value"
                );
        } else {
            $base = consultaCarCodigo($bd_conn, $code_ext, $id_ext);
            if (! empty($base["IDCAR"])) {
                $data = array();
                //CARGO EL ARRAY DE CONEXIONES
                $data[$base["IDCAR"]] = array ( 
                    "car_id" => $base["IDCAR"],
                    "car_marca" => $base["MARCA"],
                    "car_modelo" => $base["MODELO"],
                    "car_version" => mb_strtoupper($base["VERSION"], 'UTF-8'),
                    "car_gama" => mb_strtoupper($base["GAMA"], 'UTF-8'),
                    "car_mostrar" => $base["MOSTRAR"],
                    "car_matrcicula" => $base["MATRICULA"],
                    "car_bastidor" => $base["BASTIDOR"],
                    "car_km" => $base["KM"],
                    "car_cajacambios" => $base["CAJACAMBIOS"],
                    "car_fabridado" => $base["ANO_FAB"],
                    "car_color" => mb_strtoupper($base["COLOR"], 'UTF-8')
                );
            }else{
                $data = array();
                $data["document"] = array ( 
                    "status" => "message: error",
                    "message" => "Car not found"
                );
            }
        }
    }else{
        $data = array();
        $data["document"] = array ( 
            "status" => "message: error",
            "message" => "Invalid search method"
        );
    }
    header("Content-type: application/json; charset=utf-8");
    echo json_encode($data);
}elseif ($auth == 0) {
    $data = array();
    $data[] = array ( 
        "status" => "unauthorized_client",
        "message" => "Invalid authorization token"
    );
    header("Content-type: application/json; charset=utf-8");
    echo json_encode($data);
}
//FUNCIONES=============================================
function consultaCarBastidor($bd, $bastidor)
{
    $sql =  "   SELECT V.IDCAR, VM.DESCRIPCION AS MARCA, VD.DESCRIPCION AS MODELO, V.VERSION, V.GAMA, V.MOSTRAR, V.MATRICULA, V.BASTIDOR, V.KM, V.CAJACAMBIOS, V.ANO_FAB, V.COLOR
                FROM VEHICULOS V
                LEFT JOIN VEHICULOS_MARCAS VM ON VM.CODIGO = V.MARCA
                LEFT JOIN VEHICULOS_MODELOS VD ON VD.CODIGO = V.MODELO
                WHERE V.BASTIDOR = ? LIMIT 1";
    $base = $bd->prepare($sql);
    $bastidor = mysqli_real_escape_string($bd, $bastidor);
    $base->bind_param('s', $bastidor);
    $base->execute();
    $result =mysqli_fetch_array($base->get_result());
    $base->close();
    return $result;
}
function consultaCarCodigo($bd, $code_ext, $id_ext)
{
    $sql =  "   SELECT V.IDCAR, VM.DESCRIPCION AS MARCA, VD.DESCRIPCION AS MODELO, V.VERSION, V.GAMA, V.MOSTRAR, V.MATRICULA, V.BASTIDOR, V.KM, V.CAJACAMBIOS, V.ANO_FAB, V.COLOR
                FROM VEHICULOS V
                LEFT JOIN VEHICULOS_MARCAS VM ON VM.CODIGO = V.MARCA
                LEFT JOIN VEHICULOS_MODELOS VD ON VD.CODIGO = V.MODELO
                WHERE V.CODE_EXT = ? AND V.ID_EXT = ? LIMIT 1";
    $base = $bd->prepare($sql);
    $code_ext = mysqli_real_escape_string($bd, $code_ext);
    $id_ext = mysqli_real_escape_string($bd, $id_ext);
    $base->bind_param('ss', $code_ext, $id_ext);
    $base->execute();
    $result =mysqli_fetch_array($base->get_result());
    $base->close();
    return $result;
}  
?>