<?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/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');
    }

    $vehiculo = htmlspecialchars(mysqli_real_escape_string($con, $_POST['key']));
    $codigo_exp_tipo =  expediente_tipo($con,'VEHICULO_STOCK')[0];
    $codigo_esq_estr = esquemas_estructura($con,'VEHICULO');
    $clave_expediente_vehiculo = get_clave_biblioteca_expedientes_vehiculo($con, $codigo_exp_tipo, $codigo_esq_estr, $vehiculo);


    $sql = "SELECT E.NOMBRE, E.SUFIJO, E.PARTES, T.* 
    FROM BIBLIOTECA_ELEMENTOS E 
    INNER JOIN BIBLIOTECA_ETIQUETAS T ON E.CLAVE = T.CLAVE 
    WHERE T.DESCRIPCION = '$clave_expediente_vehiculo'
    AND E.PAPELERA = 0
    AND E.EXTENSION = 'PDF'
    ORDER BY E.FECHA DESC";
    $res = $con->query($sql);
    if($res->num_rows)
    {
        $fila = $res->fetch_array();
        echo '<a class="dropdown-item text-dark" href="php_o/tasaciones-download-pdf.php?doc=' . $fila['CLAVE'] . '&vehiculo=' . $vehiculo . '"><i class="fas fa-file-pdf text-danger mr-2"></i>' . $fila['NOMBRE'] . '</a>';
    }
?>

