<?php
    session_start();
    $usuarioSession = $_SESSION['USUARIO'];
    $grupo = $_SESSION['GRUPO'];
    $contacto = $_SESSION['CONTACTO'];
    $awa_session_id = $_SESSION['AWA_SESION_ID'];
    include('../includes/conex.php');
    include('../includes/eat.php');
    include('../includes/functions.php');
    include('../class/Schema.php');
    include('../class/MotherCar.php');
    if(!isset($usuarioSession) or $awa_session_id != $awa_id)
    {
      eatCookies();
      header('Location:../index.php');
    }
    if(isset($_COOKIE['usuario']) AND $_COOKIE['usuario'] != $staticUsu )
    {
      eatCookies();
      header('Loction:../index.php');
    }
    if(isset($_COOKIE['idioma']))
    {
      include('../lg/LG_' . $_COOKIE['idioma'] . '.php');
    }
    else
    {
      include('../lg/LG_SP.php');
    }
    
    $variable = '';
    $tipo = 'isis';
    $array = [1, 'VO', 0, 'STK'];
    $Schema = new Schema($con);
    $sql = "SELECT DISTINCT V.CODIGO AS CODIGO, V.ALTA, V.IDCAR, V.PRECIO_VENTA, V.KM, M.DESCRIPCION AS MARCAS, MO.DESCRIPCION AS MODELOS, V.RESERVA, V.VENTA_DTO,
    L1.DESCRIPCION_$lg AS DESCRIPCION_LG1, 
    L2.DESCRIPCION_$lg AS DESCRIPCION_LG2,
    L3.DESCRIPCION_$lg AS DESCRIPCION_LG3,
    L3.EXTRA1 AS EXTRA_COLOR_PRINCIPAL
    FROM (((((VEHICULOS V
    LEFT JOIN VEHICULOS_MARCAS M ON M.CODIGO = V.MARCA)
    LEFT JOIN VEHICULOS_MODELOS MO ON MO.CODIGO = V.MODELO)
    LEFT JOIN VEHICULOS_LITERALES L1 ON L1.CODIGO = V.COMBUSTIBLE AND L1.TIPO = 'TIP_COM')
    LEFT JOIN VEHICULOS_LITERALES L2 ON L2.CODIGO = V.CAJACAMBIOS AND L2.TIPO = 'TIP_CAJ')
    LEFT JOIN VEHICULOS_LITERALES L3 ON L3.CODIGO = V.COLOR_PRINCIPAL AND L3.TIPO = 'COL_PRI')
    WHERE V.ACTIVO = ?  
    AND V.TIPO = ?
    AND V.PAPELERA = ?
    AND V.ESTADO = ? ";
    $res = $Schema->executeQuery($sql, $tipo, $array);
    while($row = $res->fetch_array())
    {
        echo $row['CODIGO'] . "<br>";
    }
    
?>

