';
$sql = "SELECT E.CLAVE, E.NOMBRE, E.SUFIJO, E.PARTES, E.POS
FROM BIBLIOTECA_ELEMENTOS E
INNER JOIN BIBLIOTECA_ETIQUETAS T ON E.CLAVE = T.CLAVE
WHERE T.ESQUEMA = ? AND T.GRUPOE = ? AND T.DESCRIPCION = ? AND PAPELERA = ?
AND E.CLAVE NOT IN (SELECT DOCUMENTO FROM VEHICULOS_TASACIONES_DOCS)
ORDER BY E.POS ASC";
$res = $select->executeQuery($sql, 'iisi', [$esquema, $grupoe, $idCAR, 0]);
if($res->num_rows)
{
while($row = $res->fetch_assoc())
{
$sufijo = $row['SUFIJO'];
$tmp_img = 'tmp_img/' . $row['NOMBRE'];
Statics::fileExists($tmp_img);
$create_img = fopen($tmp_img,'a');
$values = $row['PARTES'];
for($i = 1; $i <= $values; $i++)
{
$sqlPartes = "SELECT FICHERO
FROM FICHEROS_$sufijo
WHERE CLAVE = ?
AND PARTE = ?
AND VERSION = ?";
$resPartes = $select->executeQuery($sqlPartes, 'sis', [ $row['CLAVE'], $i, '0']);
$rowPartes = $resPartes->fetch_array();
$img = fwrite($create_img,$rowPartes['FICHERO']);
}
fclose($create_img);
$active_slider = $row['POS'] == 1 ? 'active' : '';
$html .= '
';
}
}
else
{
$html .= '
';
}
$html .= '