<?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');
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 = "";
$marca = htmlspecialchars(mysqli_real_escape_string($con,$_POST['marca']));
$modelo = htmlspecialchars(mysqli_real_escape_string($con,$_POST['modelo']));
$combustible = htmlspecialchars(mysqli_real_escape_string($con,$_POST['combustible']));
$caja = htmlspecialchars(mysqli_real_escape_string($con,$_POST['cambio']));
$precioHasta = htmlspecialchars(mysqli_real_escape_string($con,$_POST['precioHasta']));
$kmHasta = htmlspecialchars(mysqli_real_escape_string($con,$_POST['kmHasta']));
$anio = htmlspecialchars(mysqli_real_escape_string($con,$_POST['anio']));

if($marca != 0)
{
  $variable .= " AND V.MARCA = $marca";
}
if($modelo != 0)
{
  $variable .= " AND V.MODELO = $modelo";
}
if($combustible != 0)
{
  $variable .= " AND V.COMBUSTIBLE = $combustible";
}
if($caja != 0)
{
  $variable .= " AND V.CAJACAMBIOS = $caja";
}
if($precioHasta != 0)
{
  $variable .= " AND V.PRECIO_VENTA BETWEEN 0 AND $precioHasta";
}
if($kmHasta != 0)
{
  $variable .= " AND V.KM BETWEEN 0 AND $kmHasta";
}
if($anio != 0)
{
  $variable .= " AND YEAR(MATRICULACION) BETWEEN 1975 AND $anio";
}
$check = 0;
$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 = 1 
AND V.TIPO = 'VO'
AND V.PAPELERA = 0
AND V.ESTADO = 'STK'
$variable";
$res = $con->query($sql);
echo '
    
    <table id="listado" class="table table-hover table-striped table-sm">
        <thead class="text-light bg-secondary">
        <tr>
            <th scope="col" class="text-center">
                &#10003;
            </th>
            <th scope="col">#</th>
            <th scope="col">' . $marca_lg . '</th>
            <th scope="col">' . $modelo_lg . '</th>
            <th scope="col">' . $cambio_lg . '</th>
            <th scope="col">' . $precio_lg . '</th>
            <th scope="col">' . $km_lg . '</th>
            <th scope="col" class="text-center">' . $otro_lg . '</th>
        </tr>
        </thead>
        <tbody>';
        if($res->num_rows)
        {
            while($fila = $res->fetch_array())
            {
                $check++;
                if($fila['VENTA_DTO'] == 0)
                {
                    $precioDisplay = number_format($fila['PRECIO_VENTA'],0,'.',',');
                }
                else
                {
                    $precio = $fila['PRECIO_VENTA'] - $fila['VENTA_DTO'];
                    $precioDisplay = '<i class="fas fa-tag text-danger fa-sm mr-1" data-toggle="tooltip" data-placement="top" title="' . $descuento_activo_lg . '"></i>' . number_format($precio,0,'.',',');
                }



                if($fila['RESERVA'] != "")
                {
                    $reservado = '<i class="fas fa-exclamation-circle text-danger p-1" data-toggle="tooltip" data-placement="top" title="' . $reservado_lg . '"></i>';
                }
                else
                {
                    $reservado = '';
                }



                if($fila['EXTRA_COLOR_PRINCIPAL'] == "")
                {
                    $color_icon = '<i class="fas fa-ban text-muted " data-toggle="tooltip" data-placement="top" title="' . $fila['DESCRIPCION_LG3'] . '"></i>';
                }
                else
                {
                    $color_icon = '<i class="fas fa-fill-drip ' . $fila['EXTRA_COLOR_PRINCIPAL'] . ' " data-toggle="tooltip" data-placement="top" title="'. $color_lg . ': ' . ucfirst(strtolower($fila['DESCRIPCION_LG3'])) . '"></i><span class="d-none">' . $fila['DESCRIPCION_LG3'] . '</span>';
                }



                if(strtoupper(utf8_encode($fila['DESCRIPCION_LG1'])) == "DIESEL" OR strtoupper(utf8_encode($fila['DESCRIPCION_LG1'])) == "GASOLINA")
                {
                    $iconCombustible = '<i class="fas fa-gas-pump text-dark mr-1" data-toggle="tooltip" data-placement="top" title="' . strtoupper(utf8_encode($fila['DESCRIPCION_LG1'])) . '"></i><span class="d-none">' . strtoupper(utf8_encode($fila['DESCRIPCION_LG1'])) . '</span>';
                }
                elseif(strtoupper(utf8_encode($fila['DESCRIPCION_LG1'])) == "ELÉCTRICO")
                {
                    $iconCombustible = '<i class="fas fa-charging-station text-dark  mr-1" data-toggle="tooltip" data-placement="top" title="' . strtoupper(utf8_encode($fila['DESCRIPCION_LG1'])) . '"></i><span class="d-none">' . strtoupper(utf8_encode($fila['DESCRIPCION_LG1'])) . '</span>';
                }
                elseif(strtoupper(utf8_encode($fila['DESCRIPCION_LG1'])) == "[SIN ASIGNAR]")
                {
                    $iconCombustible = '<i class="fas fa-gas-pump text-muted mr-1" data-toggle="tooltip" data-placement="top" title="' . strtoupper(utf8_encode($fila['DESCRIPCION_LG1'])) . '"></i><span class="d-none">' . strtoupper(utf8_encode($fila['DESCRIPCION_LG1'])) . '</span>';
                }





                echo  '
                <tr>
                    <td class="text-center">
                        <div class="custom-control custom-checkbox mr-sm-2 text-center" style="cursor:default;" >
                            <input type="checkbox" class="custom-control-input" onclick="checkBox(' . $fila['CODIGO'] . ')" id="customControlAutosizing' . $fila['CODIGO'] . '" name="agendaRelacionCheck" >
                            <label class="custom-control-label" for="customControlAutosizing' . $fila['CODIGO'] . '" style="cursor:pointer;"></label>
                        </div>
                    </td>
                    <td>' . $reservado . $fila['IDCAR'] . '</td>
                    <td>' . strtoupper(utf8_encode($fila['MARCAS'])) . '</td>
                    <td>' . strtoupper(utf8_encode($fila['MODELOS'])) . '</td>
                    <td>' . strtoupper(utf8_encode($fila['DESCRIPCION_LG2'])) . '</td>
                    <td>' . $precioDisplay . '</td>
                    <td>' . number_format($fila['KM'],0,'.',',') . '</td>
                    <td class="p-1 text-center">
                    ' . $iconCombustible . $color_icon . '
                    <i class="fas fa-hourglass-end text-muted" data-toggle="tooltip" data-placement="top" title="' . $tiempo_en_concesionario_lg . ': ' . hastaHoy($fila['ALTA']) . ' días"></i>
                    <i class="fas fa-map-marker-alt text-danger" data-toggle="tooltip" data-placement="top" title="' . $ubicacion_lg . '"></i>
                    <a href="resultados-ficha.php?idCAR=' . $fila['CODIGO'] . '" style="text-decoration:none">
                        <i class="far fa-eye" data-toggle="tooltip" data-placement="top" title="' . $ver_lg . '"></i>
                    </a>
                    </td>
                </tr>';
            }
        }
        
    echo '
        </tbody>
    </table>
    ';

?>
