<?php
include_once ('auth.php'); 
include_once ('functions.php');
if ($auth == 1) {
    // ==============================================================
    // PARAMETROS DE CONEXION
    // --------------------------------------------------------------
    $host_avanws = "185.37.226.208";
    $user_avanws = "avanbox";
    $pass_avanws = "Documelia2013";
    $name_avanws = "soporte_avance";
    $port_avanws = "3306";
    //INSTANCIO LA BASE DE DATOS DEL AVANWS--------------------------
    $bd = new connexion($host_avanws,$user_avanws,$pass_avanws,$name_avanws,$port_avanws);
    $bd->query("SET NAMES 'utf8'");
    //BASE DE DATOS A ATACAR
    $cod_conex = 1;//PAPEL CERO DEMO
    //CONSULTO LA BASE DE DATOS A CONSULTAR
    $datos_conex = consultarConexion($bd, $cod_conex);
    //VARIABLES DE CONEXCION
    $host_conn = $datos_conex["HOST"];
    $user_conn = $datos_conex["USER"];
    $pass_conn = $datos_conex["PW"];
    $name_conn = $datos_conex["BBDD"];
    $port_conn = $datos_conex["PORT"];
    //ESTABLESCO CONEXCION
    $bd_conn = new connexion($host_conn,$user_conn,$pass_conn,$name_conn,$port_conn);
    //VARABLE INCREMENTAL
    $i = 0;
    //CONSULTO LISTADO DE MARCAS DE VEHICULOS
    $base = consultarListadoMarcasVehiculos($bd_conn);
    $data = array();
    while ($row = $base->fetch_object()){
        $marca_trim = str_replace(" ", "_", $row->DESCRIPCION);
        //CARGO EL ARRAY DE CONEXIONES
        $data[mb_strtoupper($marca_trim, 'UTF-8')] = array ( 
            "codigo" => $row->CODIGO,
            "marca" => mb_strtoupper($row->DESCRIPCION, 'UTF-8'),
            "alias" => $row->ALIAS,
            "modificacion" => $row->MODIFICACION
        );
    }
    mysqli_close($bd_conn);
    header("Content-type: application/json; charset=utf-8");
    //DEVUELVO EL JSON
    echo json_encode($data);
}elseif ($auth == 0) {
    $data = array();
    $data[] = array ( 
        "code" => "unauthorized_client",
        "message" => "Invalid authorization token"
    );
    header("Content-type: application/json; charset=utf-8");
    echo json_encode($data);
}
$bd->close();
$bd_conn->close();
//FUNCIONES=============================================
function consultarListadoMarcasVehiculos($bd)
{
    $sql =  "   SELECT M.CODIGO, M.ALIAS, M.DESCRIPCION, M.MODIFICACION
                FROM VEHICULOS_MARCAS M  ORDER BY M.CODIGO ASC";

    $base = $bd->prepare($sql);
    $base->execute();
    $result = $base->get_result();
    $base->close();
    return $result;
}
function consultarConexion($bd, $cod_conex)
{
    $sql =  "   SELECT C.HOST, C.BBDD, C.USER, C.PW, C.PORT
				FROM AVANWS_CONEXIONES C
                WHERE C.CODIGO = ? AND C.ACTIVO = 1";
    $base = $bd->prepare($sql);
    $base->bind_param('i', $cod_conex);
    $base->execute();
    $result = mysqli_fetch_array($base->get_result());
    $base->close();
    return $result;
}
?>