<?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');
    }
    $papelera = 0;
    $ctrl = htmlspecialchars(mysqli_real_escape_string($con,$_POST['ctrl']));
    $vehiculo = htmlspecialchars(mysqli_real_escape_string($con,$_POST['vehiculo']));
    $esquema = get_esquemas_y_esquemas_estructuras($con)[0];
    $grupoe = get_esquemas_y_esquemas_estructuras($con)[1];
    $sql = "SELECT E.CLAVE AS BIBLIOTECA_CLAVE, E.NOMBRE, E.SUFIJO, E.PARTES, E.POS, D.ALIAS
            FROM BIBLIOTECA_ELEMENTOS E
            INNER JOIN BIBLIOTECA_ETIQUETAS T ON E.CLAVE = T.CLAVE
            INNER JOIN VEHICULOS_TASACIONES_DOCS D ON E.CLAVE = D.DOCUMENTO AND D.ALIAS = ?
            WHERE T.ESQUEMA = ? AND T.GRUPOE = ? AND T.DESCRIPCION = ? AND E.PAPELERA = ?
            AND E.CLAVE IN (SELECT DOCUMENTO FROM VEHICULOS_TASACIONES_DOCS)
            ORDER BY E.POS";
    $stmt = $con->prepare($sql);
    $stmt->bind_param('siisi', $ctrl, $esquema, $grupoe, $vehiculo, $papelera);
    $stmt->execute();
    $res = $stmt->get_result();
    if($res->num_rows)
    {
        while($fila = $res->fetch_array())
        {
            $sufijo = $fila['SUFIJO']; 
            
            $tmp_img = "../tmp_img/" .  $fila['NOMBRE'];
            if(file_exists($tmp_img))
            {
                unlink($tmp_img);
            }
            $create_img = fopen($tmp_img,'a');
            $values = $fila['PARTES'];
            for($i = 1; $i <= $values; $i++)
            {
                $sqlPartes = "SELECT FICHERO
                            FROM FICHEROS_$sufijo 
                            WHERE CLAVE = " . $fila['BIBLIOTECA_CLAVE'] . " 
                            AND PARTE = $i
                            AND VERSION = '0'";
                $resPartes = $con->query($sqlPartes);
                $filaPartes = $resPartes->fetch_array();
                $img = fwrite($create_img,$filaPartes['FICHERO']);
            }
            fclose($create_img);
            $splited = str_split($fila['BIBLIOTECA_CLAVE'],9);
            echo '
                <div class="mb-2 p-relative w-50 h-100 d-block float-left p-2">';

                if(!isset($_POST['dlt']))
                {
                    echo'
                    <a class="position-absolute extra-btn ml-n2 mt-n1" data-toggle="tooltip" data-placement="top" title="' . $eliminar_lg . '">
                        <i class="fas fa-trash fa-lg text-danger" data-toggle="modal" data-target=".bd-example-modal-sm" onclick="eliminarFoto(\'' . $splited[0] . '\'' . ', \'' . $splited[1] . '\')"></i>
                    </a>';

                }
                    
            echo '<img class="card-img-top img-fit" src="' . "tmp_img/" . $fila['NOMBRE'] . '" width="100%"/>
                </div>';
        }
    }
    else
    {
        echo '<div class="text-center"><i class="fas fa-image fa-3x text-muted"></i></div>';
    }

?>