<?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('../includes/historial.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');
    }
    $letra = htmlspecialchars(mysqli_real_escape_string($con,$_POST['letra']));
    if(!empty($letra))
    {
        
        $sql = "SELECT COUNT(T.MATRICULA) AS CONTADOR, V.MOSTRAR AS VEHICULO_NOMBRE
        FROM VEHICULOS_TASACIONES T
        INNER JOIN VEHICULOS V ON T.VEHICULO = V.CODIGO
        WHERE T.MATRICULA = ?";
        $stmt = $con->prepare($sql);
        $stmt->bind_param('s',$letra);
        $stmt->execute();
        $res = $stmt->get_result();
        if($res->num_rows)
        {
            $fila = $res->fetch_array();
            $contador = $fila['CONTADOR'];
            $titulo = !empty($fila['VEHICULO_NOMBRE']) ? '(' . strtoupper($fila['VEHICULO_NOMBRE']) . ')' : '';
        }
        else
        {
            $contador = 0;
        }


        echo '
            <div class="col-12 mt-5">
                <h5 class="d-flex justify-content-between align-items-center mb-3 border-bottom pb-2">
                    <span class="text-muted"><i class="fas fa-exclamation-triangle mr-2"></i>' . $tasaciones_realizadas_lg . ' <span class="font-weight-light">' . $titulo . '</span></span>
                    <span class="badge badge-secondary badge-pill">' . $contador . '</span>
                </h5>
                <ul class="list-group mb-3">';

                $sql = "SELECT T.*, C.MOSTRAR
                FROM VEHICULOS_TASACIONES T
                INNER JOIN CONTACTOS C ON T.CONTACTO = C.CODIGO
                WHERE T.MATRICULA = ?
                ORDER BY T.FECHA DESC";
                $stmt = $con->prepare($sql);
                $stmt->bind_param('s',$letra);
                $stmt->execute();
                $res = $stmt->get_result();
                if($res->num_rows)
                {
                    while($fila = $res->fetch_array())
                    {
                        $precio = $fila['PRECIO'] != 0 ? $fila['PRECIO'] . ' €' : $sin_asignar_lg;
                        echo '
                            <li class="list-group-item d-flex justify-content-between lh-condensed">
                                    <small class="text-muted w-25">' . $fila['FECHA'] . '</small>
                                    <small class="text-muted w-25">' . utf8_encode($fila['MOSTRAR']) . '</small>
                                    <small class="text-muted d-none d-md-block w-25">' . $precio . '</small>
                                    <a href="tasacion-listado.php?codigo=' . $fila['CODIGO'] . '"><small class="text-muted"><i class="fas fa-eye d-block float-right" data-toggle="tooltip" data-placement="top" title="' . $ver_lg . '"></i></small></a>
                            </li>';
                    }
                }
                else
                {
                    echo '<li class="list-group-item text-center"><small>' . $sin_resultados_crear_tasacion_lg . '</small></li>';
                }

                    
        echo    '
                </ul>
                <button formaction="tasacion-cliente.php" type="submit" class="btn btn-primary rounded float-right">' . $crear_tasacion_lg . '</button>
            </div>';
    }
?>