<?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');
    include('../includes/esquemas.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');
    }
    
    $ctrl = htmlspecialchars(mysqli_real_escape_string($con,$_POST['ctrl']));

    switch($ctrl)
    {
        case 1:
            $revision = 'T.ESTADO_DOCUMENTAL = 0';
            $url = 'tasacion-revision-documental.php';
            $descripcion = $revision_documental_lg;
        break;
        case 2:
            $revision = 'T.ESTADO_FOTO = 0';
            $url = 'tasacion-revision-carroceria.php';
            $descripcion = $revision_carroceria_interior_lg;
        break;
        case 3:
            $revision = 'T.ESTADO_TALLER = 0';
            $url = 'tasacion-revision-mecanica.php';
            $descripcion = $revision_mecanica_lg;
        break;
        case 4:
            $revision = 'T.ESTADO_DOCUMENTAL = 1 AND T.ESTADO_FOTO = 1 AND T.ESTADO_TALLER = 1';
            $url = 'tasacion-revision-economica.php';
            $descripcion = $revision_economica_lg;
        break;   
    }


    $sql = "SELECT T.* , V.MATRICULA, C.MOSTRAR, M.DESCRIPCION AS M_DESC, MO.DESCRIPCION AS MO_DESC
            FROM VEHICULOS_TASACIONES T
            INNER JOIN CONTACTOS C ON T.CONTACTO = C.CODIGO
            INNER JOIN VEHICULOS V ON T.VEHICULO = V.CODIGO
            INNER JOIN VEHICULOS_MARCAS M ON V.MARCA = M.CODIGO
            INNER JOIN VEHICULOS_MODELOS MO ON V.MODELO = MO.CODIGO
            WHERE T.ACTIVO = 0
            AND $revision";
    $res = $con->query($sql);



    echo '
    <ul class="list-group mb-3">';

        echo '
            <li class="list-group-item d-flex justify-content-between bg-light">
                <div class="text-dark">
                    <h6 class="my-0">' . $descripcion . '</h6>
                </div>
            </li>';

        while($fila = $res->fetch_array())
        {
            echo '
                <li class="list-group-item d-flex justify-content-between lh-condensed">
                    <div>
                        <h6 class="my-0">' . $fila['TASACION'] . ': <span class="font-weight-normal">' . utf8_encode($fila['M_DESC']) . " " . utf8_encode($fila['MO_DESC']) .  " - " . strtoupper($fila['MATRICULA']) .  '</span></h6>
                        <small class="text-muted">' . date('H:i:s d/m/Y', strtotime($fila['FECHA'])) . '</small>
                    </div>
                    <a href="' . $url . '?matricula=' . $fila['MATRICULA'] . '&codigo_inactivo=' . $fila['CODIGO'] .'">
                        <span class="text-muted c-pointer" data-toggle="tooltip" data-placement="top" title="<?php echo $editar_lg?>">
                            <i class="fas fa-pen"></i>
                        </span>
                    </a>
                </li>';
        }
    echo '</ul>';
?>