prepare($sqlMAIN);
$stmt->bind_param('s',$_SESSION['codigo_inactivo']);
$stmt->execute();
$res = $stmt->get_result();
$filaMAIN = $res->fetch_array();
$nr = $filaMAIN['VEHICULO'];
$nombre = $filaMAIN['MOSTRAR'];
$telefono = $filaMAIN['TLFNO1'];
$email = $filaMAIN['EMAIL1'];
$otro = $filaMAIN['NOTAS'];
$tas = $filaMAIN['TASACION'];
$sql = "SELECT DISTINCT V.CODIGO AS CODIGO_COCHE, V.ALTA, V.IDCAR, V.PRECIO_VENTA, V.KM, V.MOSTRAR, V.PRECIO_COMPRA, V.MARCA AS M, V.MODELO AS VEHMOD, V.MATRICULA, V.ANO_FAB, V.MATRICULACION, V.BASTIDOR, V.KM, V.CARROCERIA, V.COMBUSTIBLE, V.COLOR_PRINCIPAL, V.COLOR_COMERCIAL, V.VERSION, V.CAJACAMBIOS, V.ALTA, V.BAJA, V.ITV_ULTIMA, V.ITV_PROXIMA, V.PRECIO_COMPRA, V.PRECIO_VENTA, V.GARANTIA, V.VENTA_BASE, V.COMPRA_BASE, V.VENTA_DTO, V.NOTAS, V.VENTA_OPCIONES, V.VELOCIDADES, V.LLAVES, V.MANUAL, V.POTENCIA, V.LIBRO_MANT, V.IMPORTACION, V.OTROS_EQUIP,
L5.EXTRA1,T.*, V.COLOR_CODIGO,
M.DESCRIPCION AS M_DESC,
MO.DESCRIPCION AS MO_DESC,
L1.DESCRIPCION_$lg AS DESCRIPCION_LG1,
L2.DESCRIPCION_$lg AS DESCRIPCION_LG2,
L3.DESCRIPCION_$lg AS DESCRIPCION_LG3,
L4.DESCRIPCION_$lg AS DESCRIPCION_LG4,
L5.DESCRIPCION_$lg AS DESCRIPCION_LG5,
L6.DESCRIPCION_$lg AS DESCRIPCION_LG6
FROM VEHICULOS V
LEFT JOIN VEHICULOS_MARCAS M ON M.CODIGO = V.MARCA
LEFT JOIN VEHICULOS_MODELOS MO ON MO.CODIGO = V.MODELO
LEFT JOIN VEHICULOS_LITERALES L1 ON L1.CODIGO = V.COMBUSTIBLE AND L1.TIPO = 'TIP_COM'
LEFT JOIN VEHICULOS_LITERALES L2 ON L2.CODIGO = V.CAJACAMBIOS AND L2.TIPO = 'TIP_CAJ'
LEFT JOIN VEHICULOS_LITERALES L3 ON L3.CODIGO = V.CARROCERIA AND L3.TIPO = 'TIP_CAR'
LEFT JOIN VEHICULOS_LITERALES L4 ON L4.CODIGO = V.COMBUSTIBLE AND L4.TIPO = 'TIP_COM'
LEFT JOIN VEHICULOS_LITERALES L5 ON L5.CODIGO = V.COLOR_CODIGO AND L5.TIPO = 'COL_PRI'
LEFT JOIN VEHICULOS_LITERALES L6 ON L6.CODIGO = V.COLOR_COMERCIAL AND L6.TIPO = 'COL_COM'
LEFT JOIN VEHICULOS_TASACIONES T ON T.VEHICULO = V.CODIGO
WHERE V.ACTIVO = 1
AND V.TIPO = 'VO'
AND T.CODIGO = ?";
$stmt = $con->prepare($sql);
$stmt->bind_param('s',$_SESSION['codigo_inactivo']);
$stmt->execute();
$res = $stmt->get_result();
$fila = $res->fetch_array();
$detalles_array = [];
if($fila['L1'] != "")
{
$lado .= "L1: " . $fila['L1'] . "
";
array_push($detalles_array, 'L1');
}
if($fila['L2'] != "")
{
$lado .= "L2: " . $fila['L2'] . "
";
array_push($detalles_array, 'L2');
}
if($fila['L3'] != "")
{
$lado .= "L3: " . $fila['L3'] . "
";
array_push($detalles_array, 'L3');
}
if($fila['L4'] != "")
{
$lado .= "L4: " . $fila['L4'] . "
";
array_push($detalles_array, 'L4');
}
if($fila['R1'] != "")
{
$lado .= "R1: " . $fila['R1'] . "
";
array_push($detalles_array, 'R1');
}
if($fila['R2'] != "")
{
$lado .= "R2: " . $fila['R2'] . "
";
array_push($detalles_array, 'R2');
}
if($fila['R3'] != "")
{
$lado .= "R3: " . $fila['R3'] . "
";
array_push($detalles_array, 'R3');
}
if($fila['R4'] != "")
{
$lado .= "R4: " . $fila['R4'] . "
";
array_push($detalles_array, 'R4');
}
if($fila['F1'] != "")
{
$lado .= "F1: " . $fila['F1'] . "
";
array_push($detalles_array, 'F1');
}
if($fila['B1'] != "")
{
$lado .= "B1: " . $fila['B1'] . "
";
array_push($detalles_array, 'B1');
}
$tip_opc = 'TIP_OPC';
$sqlOP = "SELECT L.DESCRIPCION_$lg AS DESCRIPCION_LG99, L.CODIGO, O.OPCION
FROM VEHICULOS_LITERALES L
LEFT JOIN VEHICULOS_OPCIONES O ON L.CODIGO = O.OPCION
WHERE L.TIPO = ?
AND O.VEHICULO = ?";
$stmt = $con->prepare($sqlOP);
$stmt->bind_param('si',$tip_opc,$nr);
$stmt->execute();
$resOP = $stmt->get_result();
if($resOP->num_rows)
{
while($filaOP = $resOP->fetch_array())
{
$p .= "" . utf8_encode($filaOP['DESCRIPCION_LG99']) . "
";
}
}
else
{
$p = $sin_equipamiento_lg;
}
$html .= "
";
$html .= "
";
$html .= "$fechaHoy - " . ucfirst($usuarioSession) . "
";
$html .= "$datos_cliente_lg
";
$html .= "
$cliente_lg: " . $nombre . "
" .
"$vehiculo_lg: " . $fila['M_DESC'] . " " . $fila['MO_DESC'] . "
" .
"$telefono_lg: " . $telefono . "
" .
"$email_lg: " . $email . "
" .
"$otra_informacion_lg: " . $otro . "
" .
"
";
$html .= "
$datos_principales_lg
- $precio_lg: $precio €
- $carroceria_lg: " . $fila['DESCRIPCION_LG3'] . "
- $km_lg: " . $fila['KM'] . "
- $matricula_lg: " . $fila['MATRICULA'] . "
- $cambio_lg: " . utf8_encode($fila['DESCRIPCION_LG2']) . "
- $version_lg: " . $fila['VERSION'] . "
- $combustible_lg: " . utf8_encode($fila['DESCRIPCION_LG4']) . "
- $color_lg: " . utf8_encode($fila['DESCRIPCION_LG5']) . "
- $potencia_lg: " . $fila['POTENCIA'] . "
- $ano_matriculacion_lg: " . $fila['MATRICULACION'] . "
- $fecha_itv_lg: " . $fila['ITV_ULTIMA'] . "
- $velocidades_lg: " . $fila['VELOCIDADES'] . "
- $llaves_lg: " . $fila['LLAVES'] . "
- $manual_lg: " . $fila['MANUAL'] . "
- $libro_mantenimiento_lg: " . $fila['LIBRO_MANT'] . "
- $importacion_lg: " . $fila['IMPORTACION'] . "
";
$html .= "
$equipamiento_lg
" . $p . "
" . $fila['OTROS_EQUIP'] . "
";
if(!empty($detalles_array))
{
$html .= "
$detalles_lg
" . $lado . "
";
}
$esquema = get_esquemas_y_esquemas_estructuras($con)[0];
$grupoe = get_esquemas_y_esquemas_estructuras($con)[1];
$sqlClave = "SELECT E.CLAVE, E.NOMBRE, E.SUFIJO, E.PARTES, E.POS
FROM BIBLIOTECA_ELEMENTOS E
LEFT JOIN BIBLIOTECA_ETIQUETAS T ON E.CLAVE = T.CLAVE
LEFT JOIN VEHICULOS_TASACIONES_DOCS D ON D.DOCUMENTO = E.CLAVE AND D.TASACION = '$tas'
WHERE T.ESQUEMA = " . $esquema . " AND T.GRUPOE = " . $grupoe . " AND T.DESCRIPCION = '$nr' AND E.PAPELERA = 0
AND EXTENSION <> 'PDF'
AND E.CLAVE IN (SELECT DOCUMENTO FROM VEHICULOS_TASACIONES_DOCS)
ORDER BY E.POS ASC";
$resClave = $con->query($sqlClave);
if($resClave->num_rows)
{
$html .= "$imagenes_lg
";
$html .= '';
while($filaClave = $resClave->fetch_array())
{
$sufijo = $filaClave['SUFIJO'];
$tmp_img = 'tmp_img/' . $filaClave['NOMBRE'];
if(file_exists($tmp_img))
{
unlink($tmp_img);
}
$create_img = fopen($tmp_img,'a');
$values = $filaClave['PARTES'];
for($i = 1; $i <= $values; $i++)
{
$sqlPartes = "SELECT FICHERO
FROM FICHEROS_$sufijo
WHERE CLAVE = " . $filaClave['CLAVE'] . "
AND PARTE = $i
AND VERSION = '0'";
$resPartes = $con->query($sqlPartes);
$filaPartes = $resPartes->fetch_array();
$img = fwrite($create_img,$filaPartes['FICHERO']);
}
fclose($create_img);
$html .= '
';
}
$html .= '