<?php
    session_start();
    $usuarioSession = $_SESSION['USUARIO'];
    $grupo = $_SESSION['GRUPO'];
    $contacto = $_SESSION['CONTACTO'];
    $awa_session_id = $_SESSION['AWA_SESION_ID'];
    include('includes/conex.php');
    include('class/Schema.php');
    include('class/MotherCar.php');
    include('includes/eat.php');
    include('includes/functions.php');
    include('includes/esquemas.php');
    include('lg/config_vo.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');
    }
    $sqlT = "SELECT U.CLAVE_TEMP, A.FECHA 
    FROM USUARIOS U
    LEFT JOIN USUARIOS_ACCESOS A ON A.USUARIO = U.USUARIO  
    WHERE U.CONTACTO = $contacto
    ORDER BY FECHA DESC";
    $resT = $con->query($sqlT);
    $filaT = $resT->fetch_array();
    $MotherCar = new MotherCar($con);
?>
<!doctype html>
<html lang="es">
<head>
  <?php 
    include('includes/head.php');
  ?>
  <title><?php echo $favicon_title_lg?></title>
</head>

<body class='bg-light'>

  <!-- //! Iincludes Top Bar & Menu & Datos Usuario 
  -->
  <?php
    $page = "dashboard";
    include("includes/datosUsuario.php"); 
    include('includes/menu-dashboard.php');
    include('includes/nav.php');
  ?>

  <header class='d-none'>
    <h1>UVEO</h1>
  </header>




  <section class="container" id="sectionContainer">
    <div class="row p-1 m-4"></div>


    <?php 
    
        


    ?>



    <div class="row mx-md-2">
        <div class="col-12">
            <h3 class='text-center p-2'><i class="fas fa-car-side"></i> <?php echo $nombre_concesionario_vo?> - <strong><?php echo $vo_vo?></strong></h3>
        </div>
        <div class="col-12 mb-5 mt-3">
            <form action="#" method='get' class="mx-5" name='formFiltro'>

                <!-- //!Datos Reales 
                -->
                <div id="nowYouSeeMe">
                <div class="input-group">
                    <!-- //!MARCA 
                    -->
                    <select name="marca" class='form-control mr-2 mt-2 rounded a' onchange='this.form.submit()'>
                    <?php
                    if(isset($_REQUEST['marca']))
                    {
                        if($_REQUEST['marca'] != 0)
                        {
                        $marca = $_REQUEST['marca'];
                        $sqlMarca = 'SELECT * FROM VEHICULOS_MARCAS WHERE CODIGO = ' . $_REQUEST['marca'];
                        $resMarca = $con->query($sqlMarca);
                        $filaMarca = $resMarca->fetch_array();
                        echo '<option value="' . $filaMarca['CODIGO'] . '">' . utf8_encode($filaMarca['DESCRIPCION']) . '</option>';
                        echo '<option value="0">' . $marca_lg . '</option>';
                        $sqlMarca = "SELECT * FROM VEHICULOS_MARCAS WHERE CODIGO != $marca ORDER BY VEHICULOS_MARCAS.DESCRIPCION" ;
                        $resMarca = $con->query($sqlMarca);
                        while($filaMarca = $resMarca->fetch_array())
                        {
                            echo '<option value="' . $filaMarca['CODIGO'] . '">' . utf8_encode($filaMarca['DESCRIPCION']) . '</option>';
                        }
                        }
                    }
                    if(!isset($_REQUEST['marca']) or $_REQUEST['marca'] == 0)
                    {
                        $sqlMarca = 'SELECT * FROM VEHICULOS_MARCAS ORDER BY VEHICULOS_MARCAS.DESCRIPCION';
                        $resMarca = $con->query($sqlMarca);
                        echo '<option value="0">' . $marca_lg . '</option>';
                        while($filaMarca = $resMarca->fetch_array())
                        {
                        echo '<option value="' . $filaMarca['CODIGO'] . '">' . utf8_encode($filaMarca['DESCRIPCION']) . '</option>';
                        }
                    }
                    ?>
                    </select>

                    <!-- //!MODELO 
                    -->
                    <select name="modelo" class='form-control mt-2 rounded a'>
                    <?php
                    if(isset($_REQUEST['marca']))
                    {
                        $marca = $_REQUEST['marca'];
                        if($_REQUEST['marca'] != 0)
                        {
                        $sqlModelo = "SELECT VEHICULOS_MARCAS.*,VEHICULOS_MODELOS.* 
                                        FROM VEHICULOS_MARCAS,VEHICULOS_MODELOS
                                        WHERE VEHICULOS_MODELOS.MARCA = VEHICULOS_MARCAS.CODIGO
                                        AND VEHICULOS_MODELOS.MARCA = $marca
                                        ORDER BY VEHICULOS_MODELOS.DESCRIPCION ASC";
                        $resModelo = $con->query($sqlModelo);
                        echo '<option value="0">' . $modelo_lg . '</option>';                                        
                        while($filaModelo = $resModelo->fetch_array())
                        {
                            echo '<option value="' . $filaModelo['CODIGO'] . '">' . $filaModelo['DESCRIPCION'] . '</option>';
                        }                    
                        }
                    }
                    if(!isset($_REQUEST['marca']) or $_REQUEST['marca'] == 0 )
                    {
                        echo '<option value="0">' . $modelo_lg . '</option>';
                    }
                    ?>
                    </select>

                    <select name="combustible" class='form-control ml-2 mt-2 rounded a'>
                    <?php
                        $sql = "SELECT VEHICULOS_LITERALES.*, DESCRIPCION_$lg AS DESCRIPCION_LG FROM VEHICULOS_LITERALES WHERE TIPO = 'TIP_CAJ'";
                        $res = $con->query($sql);
                        echo "<option value='0'>$cambio_lg</option>";
                        while($fila = $res->fetch_array())
                        {
                        echo "<option value='" . $fila['CODIGO'] . "'>" . utf8_encode($fila['DESCRIPCION_LG']) . "</option>";
                        }
                    ?>
                    </select>
                </div>

                <div class="clearfix"></div>

                <div class="input-group">
                    <select name="cambio" class='form-control mt-2 rounded a'>
                    <?php
                        $sql = "SELECT VEHICULOS_LITERALES.*, DESCRIPCION_$lg AS DESCRIPCION_LG FROM VEHICULOS_LITERALES WHERE TIPO = 'TIP_COM'";
                        $res = $con->query($sql);
                        echo "<option value='0'>$combustible_lg</option>";
                        while($fila = $res->fetch_array())
                        {
                        echo "<option value='" . $fila['CODIGO'] . "'>" . utf8_encode($fila['DESCRIPCION_LG']) . "</option>";
                        }
                    ?>
                    </select>

                    <select name="anio" class='form-control ml-2 mt-2 rounded a'>
                    <?php
                    echo "<option value='0'>$ano_matriculacion_lg</option>";
                    for($i = date('Y'); $i>= 1975; $i--)
                    {
                        echo "<option value='$i'>$i</option>"; 
                    }
                    ?>
                    </select>
                </div>

                <div class="input-group">
                    <select name="precioHasta" class='form-control mr-2 mt-2 rounded a'>
                    <?php
                        echo "<option value='0'>$precio_hasta_lg</option>";
                        for($i = 1000; $i <= 200000; $i = $i + 1000)
                        {
                        if($i > 10000)
                        {
                            $i = $i + 9000;
                        }
                        if($i > 100000 AND $i < 200000)
                        {
                            $i = $i + 20000;
                        }
                        echo "<option value='$i'>" . number_format($i,0,',',' ') . "</option>"; 
                        }
                        ?>
                    </select>

                    <select name="kmHasta" class='form-control mt-2 rounded a'>
                    <?php
                    echo "<option value='0'>$km_hasta_lg</option>";
                    for($i = 10000; $i <= 200000; $i = $i + 10000)
                    {
                        echo "<option value='$i'>" . number_format($i,0,',',' ') . "</option>"; 
                    }
                    ?>
                    </select>
                </div>

                <button type="submit" name='filtro' value='filtro' formaction='resultados.php'
                    class="btn btn-primary btn-sm btn-block mt-3 p-2"><strong><?php echo $buscar_lg;?></strong></button>
                </div>
            </form>
        </div>
    </div> 







    <div class="row mx-md-5">
        <?php 
            //CAMBIAR SQL
            $limit = 6;
            $sqlOferta = "SELECT CODIGO,RESERVA,MOSTRAR,VENTA_TOTAL,KM,ANO_FAB,ALTA, VENTA_TOTALSINDTO 
            FROM VEHICULOS 
            WHERE PAPELERA = 0 
            AND ACTIVO = 1 
            AND ESTADO ='STK' 
            AND DESTACADO_VENTA_VO = 1
            ORDER BY ALTA DESC LIMIT 0, $limit";
            $resOferta = $con->query($sqlOferta);
            while($filaOferta = $resOferta->fetch_array())
            {
                $idCAR = $filaOferta['CODIGO'];
                if($filaOferta['RESERVA'] != "")
                {
                $reservado = '<i class="fas fa-exclamation-circle text-danger d-block float-right p-1" data-toggle="tooltip" data-placement="top" title="' .$reservado_lg . '"></i>';
                }
                else
                {
                $reservado = '';
            }
        ?>  

            <div class="col-12 col-sm-6 col-md-4 mb-3">
                <div class="card shadow-sm">
                    <a href="resultados-ficha.php?idCAR=<?php echo $idCAR?>" class="text-dark">
                        <div class="overflow-hidden h-180">
                        <?php
                            $esquema = get_esquemas_y_esquemas_estructuras($con)[0];
                            $grupoe = get_esquemas_y_esquemas_estructuras($con)[1];
                            $sqlClave = "SELECT E.CLAVE, E.NOMBRE, E.SUFIJO, E.PARTES, E.POS
                                        FROM BIBLIOTECA_ELEMENTOS E
                                        INNER JOIN BIBLIOTECA_ETIQUETAS T ON E.CLAVE = T.CLAVE
                                        WHERE T.ESQUEMA = " . $esquema . " AND T.GRUPOE = " . $grupoe . " AND T.DESCRIPCION = '$idCAR' AND PAPELERA = 0
                                        AND E.CLAVE NOT IN (SELECT DOCUMENTO FROM VEHICULOS_TASACIONES_DOCS)
                                        ORDER BY E.POS ASC LIMIT 0,1";
                            $resClave = $con->query($sqlClave);
                            if($resClave->num_rows)
                            {
                            $filaClave = $resClave->fetch_array();
                            $sufijo = $filaClave['SUFIJO']; 
                            $tmp_img = 'tmp_img/' . $filaClave['NOMBRE'];
                            if(file_exists($tmp_img))
                            {
                                unlink($tmp_img);
                            }
                            $create_img = fopen($tmp_img,'a');
                            $values = $filaClave['PARTES'];
                            for($i = 1; $i <= $values; $i++)
                            {
                                $sqlPartes = "SELECT FICHERO
                                            FROM FICHEROS_$sufijo 
                                            WHERE CLAVE = " . $filaClave['CLAVE'] . " 
                                            AND PARTE = $i
                                            AND VERSION = '0'";
                                $resPartes = $con->query($sqlPartes);
                                $filaPartes = $resPartes->fetch_array();
                                $img = fwrite($create_img,$filaPartes['FICHERO']);
                            }
                            fclose($create_img);
                        ?>
                        <img src="tmp_img/<?php echo $filaClave['NOMBRE']?>" class="card-img-top img-fit" alt="img-coche">
                        <?php } else { echo '<div class="text-center"><i class="far fa-image fa-8x mt-4 text-muted"></i></div>'; }?>
                        </div>
                        <div class="card-body h-250">
                        <h6 class="card-title border-bottom pb-2"><?php echo strtoupper(utf8_encode($filaOferta['MOSTRAR'])) . " " . $reservado?></h6>
                        <ul class="list-group">
                            <li class="pb-2 d-flex justify-content-between align-items-center">
                            <span><?php echo $precio_lg;?></span>
                            <?php
                                /* if($filaOferta['VENTA_DTO'] == 0)
                                {
                                    echo '<span class="badge badge-warning">' . number_format($filaOferta['PRECIO_VENTA'],'0','',',') . ' €</span>';
                                }
                                else
                                {
                                    $precio_venta = $filaOferta['PRECIO_VENTA'] - $filaOferta['VENTA_DTO']; 
                                    echo '<span class="badge p-1 text-danger border border-danger"><i class="fas fa-tag fa-sm mr-1"></i>' . number_format($precio_venta,'0','',',') . ' €</span>';
                                } */
                                echo '<span class="badge p-1 text-danger border border-danger"><i class="fas fa-tag fa-sm mr-1"></i>' . $MotherCar->car_price($filaOferta['VENTA_TOTAL'], $filaOferta['VENTA_TOTALSINDTO']) . '</span>';
                            ?>
                            </li>
                            <li class="pb-2 d-flex justify-content-between align-items-center">
                            <span><?php echo $km_lg;?></span>
                            <span class="badge badge-light"><?php echo  number_format($filaOferta['KM'],0,'',',')?></span>
                            </li>
                            <li class="pb-2 d-flex justify-content-between align-items-center">
                            <span><?php echo $ano_fabricacion_lg;?></span>
                            <span class="badge badge-light"><?php echo $filaOferta['ANO_FAB']?></span>
                            </li>
                        </ul>
                        <p class="card-text"><small class="text-muted"><?php echo $alta_con_fecha_lg . " " . date('d/m/Y',strtotime($filaOferta['ALTA']));?></small></p>
                        </div>
                    </a>
                </div>

            </div>
        <?php } ?>
    </div>

    

    <!-- //!Modal temp -->
    <div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
        <div class="modal-dialog" role="document">
        <div class="modal-content">
            <div class="modal-header">
            <h5 class="modal-title text-dark" id="exampleModalLabel"><i class="fas fa-unlock-alt mr-2"></i><?php echo $cambiar_clave_temp_lg?></h5>
            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                <span aria-hidden="true">&times;</span>
            </button>
            </div>
            <form action="dashboard-clave-temp-o.php" method="post" class="needs-validation" novalidate>
                <div class="col-12 mt-3">
                <label for="validationTooltipUsername" class="d-none"><?php echo $nueva_clave_lg?></label>
                <div class="input-group">
                    <div class="input-group-prepend">
                    <span class="input-group-text" id="validationTooltipUsernamePrepend" data-toggle='tooltip' data-placement='bottom' title='<?php echo $clave_fuerte_lg?>'><i class="fas fa-unlock"></i></span>
                    </div>
                    <input name="clave1" type="password" class="form-control" id="c1" placeholder="<?php echo $nueva_clave_lg?>" aria-describedby="validationTooltipUsernamePrepend" required>
                    <div class="invalid-tooltip">
                    <?php echo $clave_fuerte_lg?>
                    </div>
                </div>
                </div>
                <div class="col-12 mt-3">
                <label for="validationTooltipUsername" class="d-none"><?php echo $repite_clave_lg?></label>
                <div class="input-group">
                    <div class="input-group-prepend">
                    <span class="input-group-text" id="validationTooltipUsernamePrepend" data-toggle='tooltip' data-placement='top' title='<?php echo $clave_fuerte_2_lg?>'><i class="fas fa-lock"></i></span>
                    </div>
                    <input name="clave2" type="password" class="form-control" id="c2" placeholder="<?php echo $repite_clave_lg?>" aria-describedby="validationTooltipUsernamePrepend" required>
                    <div class="invalid-tooltip">
                    <?php echo $campo_obligatorio_segunda_clave_lg?>
                    </div>
                </div>
                </div>           
                <div class="modal-footer mt-3">
                <button class="btn btn-primary btn-block" type="submit"><?php echo $restablecer_lg?></button>
                </div>
            </form>
        </div>
        </div>
    </div>
       


  </section>


  <div class="pb-5"></div>

  <!-- //! Footer & Script Links 
  -->
  <?php 
    include('includes/footer.php');
    include('includes/footer-script.php');
  ?>   
  <script>
    (function() {
      'use strict';
      window.addEventListener('load', function() {
          var forms = document.getElementsByClassName('needs-validation');
          var validation = Array.prototype.filter.call(forms, function(form) {
          form.addEventListener('submit', function(event) {
              var c1 = document.getElementById("c1");
              var c2 = document.getElementById("c2");
              var a = document.getElementsByClassName('a');
              if (form.checkValidity() === false) 
              {
                event.preventDefault();
                event.stopPropagation();
              }
              else if(c1.value.length < 8 || c1.value.search(/[0-9]/) === -1 ||  c1.value.search(/[a-z]/) === -1 ||  c1.value.search(/[A-Z]/) === -1)
              {
                event.preventDefault();
                event.stopPropagation();
                form.c1.classList.add('is-invalid');
              }
              else if(c1.value !== c2.value)
              {
                event.preventDefault();
                event.stopPropagation();
                form.c2.classList.add('is-invalid');
              }
              else
              {
                form.classList.add('was-validated');
              }
          }, false);
          });
      }, false);
      })();

    //? Target modal temp pass
    <?php if($filaT['CLAVE_TEMP'] == 1){ ?>
      $('#exampleModal').modal('show');
    <?php }?>

    $(window).on("load",function(){
        $(".loader-wrapper").fadeOut("slow");
    });

    

  </script>

  <?php 
    eat_all_files("ofertas/tmp_pdf/");
    eat_all_files("ofertas/pdf/");
    eat_all_files("ofertas/tasaciones/");
    $con->close(); 
  ?>

  </body>
</html>