';
$sql = "SELECT E.CLAVE AS BIBLIOTECA_CLAVE, E.NOMBRE, E.SUFIJO, E.PARTES, E.POS, E.EXTENSION, 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 = '$key'
WHERE T.ESQUEMA = " . $esquema . " AND T.GRUPOE = " . $grupoe . " AND T.DESCRIPCION = '$vehiculo' AND E.PAPELERA = 0
AND E.CLAVE IN (SELECT DOCUMENTO FROM VEHICULOS_TASACIONES_DOCS)
ORDER BY E.POS";
$res = $con->query($sql);
if($res->num_rows)
{
while($fila = $res->fetch_array())
{
if(in_array(strtoupper($fila['EXTENSION']), $array_path))
{
$tmp_doc = "../tmp_img/" . $fila['NOMBRE'];
}
else
{
$tmp_doc = '../ofertas/tmp_pdf/' . $fila['NOMBRE'];
}
if(file_exists($tmp_doc))
{
unlink($tmp_doc);
}
$create_doc = fopen($tmp_doc,'a');
$values = $fila['PARTES'];
for($i = 1; $i <= $values; $i++)
{
$sqlPartes = "SELECT FICHERO
FROM FICHEROS_" . $fila['SUFIJO'] . "
WHERE CLAVE = " . $fila['BIBLIOTECA_CLAVE'] . "
AND PARTE = $i
AND VERSION = '0'";
$resPartes = $con->query($sqlPartes);
$filaPartes = $resPartes->fetch_array();
$doc = fwrite($create_doc,$filaPartes['FICHERO']);
}
fclose($create_doc);
$filename = 'ofertas/tmp_pdf/' . $fila['NOMBRE'];
$splited = str_split($fila['BIBLIOTECA_CLAVE'],9);
if(in_array(strtoupper($fila['EXTENSION']), $array_path))
{
$html .= '
';
}
else
{
$html .= '
';
$html .= '
';
}
}
}
else
{
$html .= $sin_resultados_lg;
}
$html .= '