select_campo_tabla_parametros('BBDD_ALIAS', 'VALOR'); $res = $Schema->executeQuery('SELECT V.MOSTRAR, V.CODIGO AS COD_VEH, V.CODE_EXT, P.ACTIVO, P.EXPORTADO, P.VEHICULO, P.INICIO FROM VEHICULOS V LEFT JOIN VEHICULOS_PUBLICACIONES P ON V.CODIGO = P.VEHICULO AND P.PORTAL = ? AND P.ACTIVO = ? WHERE V.ACTIVO = ? AND V.VENTA_TOTALSINDTO <> ? AND V.PAPELERA = ? ' . $condition . ' ORDER BY V.MOSTRAR ASC', $type, $values); if($res->num_rows) { $nr = 0; while($row = $res->fetch_array()) { $nr++; $fecha_publicacion = empty($row['INICIO']) ? '' : date('d/m/Y', strtotime($row['INICIO'])); $app_code_ext = empty($row['CODE_EXT']) ? $inside_code : $row['CODE_EXT']; $check = $row['VEHICULO'] != NULL ? 'checked' : FALSE; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; } } else { $html .= ''; } echo $html; ?>
'; $html .= ''; $html .= ''; $html .= '
' . $row['MOSTRAR'] . '' . $fecha_publicacion . '
' . $sin_resultados_lg . '