Tómese el tiempo que necesite para degustar un extenso recorrido compuesto de dieciséis creaciones gastronómicas que le conducirán a través de una experiencia irrepetible.
Impuestos no incluidos.
Este menú No se servirá después de las 15:00 horas, ni después de las 22:00 horas.
Seleccionar Ubicación
Haz clic en el botón para obtener tu ubicación actual.
SELECT T.ID_establecimiento
FROM (
(
SELECT d.ID_establecimiento
FROM md_diario d
JOIN establecimientos e ON d.ID_establecimiento = e.ID_establecimiento
WHERE d.md_fecha = '2025-04-05'
AND d.acronimo_clasificacion_gral = 'MD' AND e.estado_establecimiento = 1
ANDNOT FIND_IN_SET('MDDG', IFNULL(d.acronimos_tipologia, ''))
)
UNION
(
SELECT h.ID_establecimiento
FROM md_diario_habituales h
JOIN establecimientos e ON h.ID_establecimiento = e.ID_establecimiento
WHERE h.md_fecha_SA = 1 AND e.estado_establecimiento = 1
AND h.acronimo_clasificacion_gral = 'MD' AND h.md_estado = 1
ANDNOT FIND_IN_SET('MDDG', IFNULL(h.acronimos_tipologia, ''))
)
UNION
(
SELECT ad.ID_establecimiento
FROM md_asignaciones_defecto AS ad
JOIN md_configuraciones_tipo AS c
ON ad.id_md_config_tipo = c.id_md_config_tipo
JOIN establecimientos e ON ad.ID_establecimiento = e.ID_establecimiento
WHERE ad.dia = 'SA'
AND c.acronimo_clasificacion_gral = 'MD' AND e.estado_establecimiento = 1
ANDNOT FIND_IN_SET('MDDG', IFNULL(c.acronimos_tipologia, ''))
)
) AS T
JOIN establecimientos_localizaciones AS L
ON L.ID_establecimiento = T.ID_establecimiento
WHERE L.idPRO = '0737'
Event: dbquery
Events
0.01 ms
Query
Database
0.32 ms
SELECTCOUNT(*) AS `numrows`
FROM `establecimientos`
WHERE `ID_establecimiento` IN ('1508','1517')
AND `logotipo_establecimiento` ISNOTNULLAND `logotipo_establecimiento` != ''
Event: dbquery
Events
0.01 ms
Query
Database
0.47 ms
SELECT *
FROM `establecimientos`
WHERE `ID_establecimiento` IN ('1508','1517')
AND `logotipo_establecimiento` ISNOTNULLAND `logotipo_establecimiento` != ''
ORDERBY `nombre_establecimiento` ASC, `fecha_creacion_establecimiento` ASCLIMIT 4
Event: dbquery
Events
0.01 ms
Query
Database
0.13 ms
SELECT `nomCVIA`, `numVIA`, `CPOS`, `nomPOB`, `nomPRO`
FROM `establecimientos_localizaciones`
WHERE `ID_establecimiento` = '1517'
Event: dbquery
Events
0.01 ms
Query
Database
0.17 ms
SELECT `URL_foto`
FROM `establecimientos_fotos`
WHERE `ID_establecimiento` = '1517'
ORDERBY `ORDER_foto` ASCLIMIT 1
Event: dbquery
Events
0.01 ms
Query
Database
0.21 ms
SELECT `establecimientos_ambientes`.`ID_ambiente`
FROM `establecimientos_ambientes`
LEFTJOIN `ambientes` ON `ambientes`.`ID_ambiente` = `establecimientos_ambientes`.`ID_ambiente`
WHERE `establecimientos_ambientes`.`ID_establecimiento` = '1517'
Event: dbquery
Events
0.01 ms
Query
Database
0.22 ms
SELECT `establecimientos_tipo_negocio`.`ID_tipo_negocio`
FROM `establecimientos_tipo_negocio`
LEFTJOIN `tipos_negocio` ON `tipos_negocio`.`ID_tipo_negocio` = `establecimientos_tipo_negocio`.`ID_tipo_negocio`
WHERE `establecimientos_tipo_negocio`.`ID_establecimiento` = '1517'
Event: dbquery
Events
0.02 ms
Query
Database
0.16 ms
SELECT `establecimientos_caracteristicas`.`ID_caracteristicas`
FROM `establecimientos_caracteristicas`
LEFTJOIN `caracteristicas` ON `caracteristicas`.`ID_caracteristicas` = `establecimientos_caracteristicas`.`ID_caracteristicas`
WHERE `establecimientos_caracteristicas`.`ID_establecimiento` = '1517'
Event: dbquery
Events
0.01 ms
Query
Database
0.21 ms
SELECT `establecimientos_tipo_elaboracion`.`ID_tipo_elaboracion`
FROM `establecimientos_tipo_elaboracion`
LEFTJOIN `tipo_cocina_elaboracion` ON `tipo_cocina_elaboracion`.`ID_tipo_elaboracion` = `establecimientos_tipo_elaboracion`.`ID_tipo_elaboracion`
WHERE `establecimientos_tipo_elaboracion`.`ID_establecimiento` = '1517'
Event: dbquery
Events
0.02 ms
Query
Database
0.17 ms
SELECT `establecimientos_tipo_origen`.`ID_tipo_origen`
FROM `establecimientos_tipo_origen`
LEFTJOIN `tipo_cocina_origen` ON `tipo_cocina_origen`.`ID_tipo_origen` = `establecimientos_tipo_origen`.`ID_tipo_origen`
WHERE `establecimientos_tipo_origen`.`ID_establecimiento` = '1517'
Event: dbquery
Events
0.00 ms
Query
Database
0.20 ms
SELECT `establecimientos_tarjetas`.`ID_tarjeta`
FROM `establecimientos_tarjetas`
LEFTJOIN `tarjetas_credito` ON `tarjetas_credito`.`ID_tarjeta` = `establecimientos_tarjetas`.`ID_tarjeta`
WHERE `establecimientos_tarjetas`.`ID_establecimiento` = '1517'
Event: dbquery
Events
0.01 ms
Query
Database
0.16 ms
SELECT `establecimientos_cheques`.`ID_cheque`
FROM `establecimientos_cheques`
LEFTJOIN `cheques_restaurante` ON `cheques_restaurante`.`ID_cheque` = `establecimientos_cheques`.`ID_cheque`
WHERE `establecimientos_cheques`.`ID_establecimiento` = '1517'
Event: dbquery
Events
0.01 ms
Query
Database
0.43 ms
SELECT `establecimientos_guias`.`ID_guia`
FROM `establecimientos_guias`
LEFTJOIN `guias` ON `guias`.`ID_guia` = `establecimientos_guias`.`ID_guia`
WHERE `establecimientos_guias`.`ID_establecimiento` = '1517'
Event: dbquery
Events
0.01 ms
Query
Database
0.24 ms
SELECT `establecimientos_calidad`.`ID_sistema`
FROM `establecimientos_calidad`
LEFTJOIN `sistemas_calidad` ON `sistemas_calidad`.`ID_sistema` = `establecimientos_calidad`.`ID_sistema`
WHERE `establecimientos_calidad`.`ID_establecimiento` = '1517'
Event: dbquery
Events
0.01 ms
Query
Database
0.23 ms
SELECT `establecimientos_idioma`.`ID_idioma`
FROM `establecimientos_idioma`
LEFTJOIN `idiomas` ON `idiomas`.`ID_idioma` = `establecimientos_idioma`.`ID_idioma`
WHERE `establecimientos_idioma`.`ID_establecimiento` = '1517'
Event: dbquery
Events
0.01 ms
Query
Database
0.26 ms
SELECT `SA_apertura` AS `apertura`, `SA_H1_ini` AS `H1ini`, `SA_H1_fin` AS `H1fin`, `SA_H2_ini` AS `H2ini`, `SA_H2_fin` AS `H2fin`, `SA_HC_ini` AS `HCini`, `SA_HC_fin` AS `HCfin`
FROM `establecimientos_horarios_habituales`
WHERE `ID_establecimiento` = '1517'
Event: dbquery
Events
0.01 ms
Query
Database
0.20 ms
SELECT `ID_establecimiento`, `id_md_diario`
FROM `md_diario`
WHERE `ID_establecimiento` IN ('1517')
AND `md_fecha` = '2025-04-05'
Event: dbquery
Events
0.01 ms
Query
Database
0.20 ms
SELECT `ID_establecimiento`, `id_md_diario`
FROM `md_diario_habituales`
WHERE `ID_establecimiento` IN ('1517')
AND `md_estado` = 1
AND md_fecha_SA=1
Event: dbquery
Events
0.01 ms
Query
Database
8.87 ms
(SELECT 1 AS tipo,
md_diario.ID_establecimiento AS ID_establecimiento,
md_diario.id_md_diario AS id_md_diario,
md_diario.md_fecha AS md_fecha,
'X' AS md_fecha_LU,
'X' AS md_fecha_MA,
'X' AS md_fecha_MI,
'X' AS md_fecha_JU,
'X' AS md_fecha_VI,
'X' AS md_fecha_SA,
'X' AS md_fecha_DO,
-- resto de columnas menús diarios
md_diario.md_nombre AS md_nombre,
md_diario.md_nombre_EN AS md_nombre_EN,
md_diario.md_servicio AS md_servicio,
md_diario.md_PR_comida AS md_PR_comida,
md_diario.md_PR_cena AS md_PR_cena,
md_diario.md_PR_jornada AS md_PR_jornada,
md_diario.md_LL_servicio AS md_LL_servicio,
md_diario.md_MM1_servicio AS md_MM1_servicio,
md_diario.md_MM2_servicio AS md_MM2_servicio,
md_diario.md_tipo_cat AS md_tipo_cat,
md_diario.md_platos_cat1 AS md_platos_cat1,
md_diario.md_platos_cat2 AS md_platos_cat2,
md_diario.md_platos_cat3 AS md_platos_cat3,
md_diario.md_platos_cat4 AS md_platos_cat4,
md_diario.md_platos_cat5 AS md_platos_cat5,
md_diario.md_platos_cat6 AS md_platos_cat6,
md_diario.md_observaciones AS md_observaciones,
md_diario.md_observaciones_EN AS md_observaciones_EN,
md_diario.md_LL_nombre AS md_LL_nombre,
md_diario.md_LL_nombre_EN AS md_LL_nombre_EN,
md_diario.md_LL_PR_comida AS md_LL_PR_comida,
md_diario.md_LL_PR_cena AS md_LL_PR_cena,
md_diario.md_LL_PR_jornada AS md_LL_PR_jornada,
md_diario.md_LL_observaciones AS md_LL_observaciones,
md_diario.md_LL_observaciones_EN AS md_LL_observaciones_EN,
md_diario.md_MM1_nombre AS md_MM1_nombre,
md_diario.md_MM1_nombre_EN AS md_MM1_nombre_EN,
md_diario.md_MM1_PR_comida AS md_MM1_PR_comida,
md_diario.md_MM1_PR_cena AS md_MM1_PR_cena,
md_diario.md_MM1_PR_jornada AS md_MM1_PR_jornada,
md_diario.md_MM1_observaciones AS md_MM1_observaciones,
md_diario.md_MM1_observaciones_EN AS md_MM1_observaciones_EN,
md_diario.md_MM2_nombre AS md_MM2_nombre,
md_diario.md_MM2_nombre_EN AS md_MM2_nombre_EN,
md_diario.md_MM2_PR_comida AS md_MM2_PR_comida,
md_diario.md_MM2_PR_cena AS md_MM2_PR_cena,
md_diario.md_MM2_PR_jornada AS md_MM2_PR_jornada,
md_diario.md_MM2_observaciones AS md_MM2_observaciones,
md_diario.md_MM2_observaciones_EN AS md_MM2_observaciones_EN,
md_diario.acronimos_tipologia AS acronimos_tipologia,
md_diario.md_cat1 AS md_cat1,
md_diario.md_cat2 AS md_cat2,
md_diario.md_cat3 AS md_cat3,
md_diario.md_cat4 AS md_cat4,
md_diario.md_cat5 AS md_cat5,
md_diario.md_cat6 AS md_cat6,
md_diario.md_nom_cat1 AS md_nom_cat1,
md_diario.md_nom_cat2 AS md_nom_cat2,
md_diario.md_nom_cat3 AS md_nom_cat3,
md_diario.md_nom_cat4 AS md_nom_cat4,
md_diario.md_nom_cat5 AS md_nom_cat5,
md_diario.md_nom_cat6 AS md_nom_cat6,
md_diario.md_nom_platos AS md_nom_platos,
md_diario.md_nom_platos_cat1 AS md_nom_platos_cat1,
md_diario.md_nom_platos_cat2 AS md_nom_platos_cat2,
md_diario.md_nom_platos_cat3 AS md_nom_platos_cat3,
md_diario.md_nom_platos_cat4 AS md_nom_platos_cat4,
md_diario.md_nom_platos_cat5 AS md_nom_platos_cat5,
md_diario.md_nom_platos_cat6 AS md_nom_platos_cat6,
md_diario.md_nom_cat1_EN AS md_nom_cat1_EN,
md_diario.md_nom_cat2_EN AS md_nom_cat2_EN,
md_diario.md_nom_cat3_EN AS md_nom_cat3_EN,
md_diario.md_nom_cat4_EN AS md_nom_cat4_EN,
md_diario.md_nom_cat5_EN AS md_nom_cat5_EN,
md_diario.md_nom_cat6_EN AS md_nom_cat6_EN,
md_diario.md_nom_platos_cat1_EN AS md_nom_platos_cat1_EN,
md_diario.md_nom_platos_cat2_EN AS md_nom_platos_cat2_EN,
md_diario.md_nom_platos_cat3_EN AS md_nom_platos_cat3_EN,
md_diario.md_nom_platos_cat4_EN AS md_nom_platos_cat4_EN,
md_diario.md_nom_platos_cat5_EN AS md_nom_platos_cat5_EN,
md_diario.md_nom_platos_cat6_EN AS md_nom_platos_cat6_EN,
md_diario.md_menus_especiales AS md_menus_especiales
FROM md_diario
WHERE ID_establecimiento IN (1517)
AND md_fecha = '2025-04-05' ANDNOT FIND_IN_SET('MDDG', IFNULL(acronimos_tipologia, ''))
)
UNION
(SELECT 2 AS tipo,
md_diario_habituales.ID_establecimiento AS ID_establecimiento,
md_diario_habituales.id_md_diario AS id_md_diario,
'2025-04-05' AS md_fecha,
md_diario_habituales.md_fecha_LU AS md_fecha_LU,
md_diario_habituales.md_fecha_MA AS md_fecha_MA,
md_diario_habituales.md_fecha_MI AS md_fecha_MI,
md_diario_habituales.md_fecha_JU AS md_fecha_JU,
md_diario_habituales.md_fecha_VI AS md_fecha_VI,
md_diario_habituales.md_fecha_SA AS md_fecha_SA,
md_diario_habituales.md_fecha_DO AS md_fecha_DO,
-- resto de columnas
md_diario_habituales.md_nombre AS md_nombre,
md_diario_habituales.md_nombre_EN AS md_nombre_EN,
md_diario_habituales.md_servicio AS md_servicio,
md_diario_habituales.md_PR_comida AS md_PR_comida,
md_diario_habituales.md_PR_cena AS md_PR_cena,
md_diario_habituales.md_PR_jornada AS md_PR_jornada,
md_diario_habituales.md_LL_servicio AS md_LL_servicio,
md_diario_habituales.md_MM1_servicio AS md_MM1_servicio,
md_diario_habituales.md_MM2_servicio AS md_MM2_servicio,
md_diario_habituales.md_tipo_cat AS md_tipo_cat,
md_diario_habituales.md_platos_cat1 AS md_platos_cat1,
md_diario_habituales.md_platos_cat2 AS md_platos_cat2,
md_diario_habituales.md_platos_cat3 AS md_platos_cat3,
md_diario_habituales.md_platos_cat4 AS md_platos_cat4,
md_diario_habituales.md_platos_cat5 AS md_platos_cat5,
md_diario_habituales.md_platos_cat6 AS md_platos_cat6,
md_diario_habituales.md_observaciones AS md_observaciones,
md_diario_habituales.md_observaciones_EN AS md_observaciones_EN,
md_diario_habituales.md_LL_nombre AS md_LL_nombre,
md_diario_habituales.md_LL_nombre_EN AS md_LL_nombre_EN,
md_diario_habituales.md_LL_PR_comida AS md_LL_PR_comida,
md_diario_habituales.md_LL_PR_cena AS md_LL_PR_cena,
md_diario_habituales.md_LL_PR_jornada AS md_LL_PR_jornada,
md_diario_habituales.md_LL_observaciones AS md_LL_observaciones,
md_diario_habituales.md_LL_observaciones_EN AS md_LL_observaciones_EN,
md_diario_habituales.md_MM1_nombre AS md_MM1_nombre,
md_diario_habituales.md_MM1_nombre_EN AS md_MM1_nombre_EN,
md_diario_habituales.md_MM1_PR_comida AS md_MM1_PR_comida,
md_diario_habituales.md_MM1_PR_cena AS md_MM1_PR_cena,
md_diario_habituales.md_MM1_PR_jornada AS md_MM1_PR_jornada,
md_diario_habituales.md_MM1_observaciones AS md_MM1_observaciones,
md_diario_habituales.md_MM1_observaciones_EN AS md_MM1_observaciones_EN,
md_diario_habituales.md_MM2_nombre AS md_MM2_nombre,
md_diario_habituales.md_MM2_nombre_EN AS md_MM2_nombre_EN,
md_diario_habituales.md_MM2_PR_comida AS md_MM2_PR_comida,
md_diario_habituales.md_MM2_PR_cena AS md_MM2_PR_cena,
md_diario_habituales.md_MM2_PR_jornada AS md_MM2_PR_jornada,
md_diario_habituales.md_MM2_observaciones AS md_MM2_observaciones,
md_diario_habituales.md_MM2_observaciones_EN AS md_MM2_observaciones_EN,
md_diario_habituales.acronimos_tipologia AS acronimos_tipologia,
md_diario_habituales.md_cat1 AS md_cat1,
md_diario_habituales.md_cat2 AS md_cat2,
md_diario_habituales.md_cat3 AS md_cat3,
md_diario_habituales.md_cat4 AS md_cat4,
md_diario_habituales.md_cat5 AS md_cat5,
md_diario_habituales.md_cat6 AS md_cat6,
md_diario_habituales.md_nom_cat1 AS md_nom_cat1,
md_diario_habituales.md_nom_cat2 AS md_nom_cat2,
md_diario_habituales.md_nom_cat3 AS md_nom_cat3,
md_diario_habituales.md_nom_cat4 AS md_nom_cat4,
md_diario_habituales.md_nom_cat5 AS md_nom_cat5,
md_diario_habituales.md_nom_cat6 AS md_nom_cat6,
md_diario_habituales.md_nom_platos AS md_nom_platos,
md_diario_habituales.md_nom_platos_cat1 AS md_nom_platos_cat1,
md_diario_habituales.md_nom_platos_cat2 AS md_nom_platos_cat2,
md_diario_habituales.md_nom_platos_cat3 AS md_nom_platos_cat3,
md_diario_habituales.md_nom_platos_cat4 AS md_nom_platos_cat4,
md_diario_habituales.md_nom_platos_cat5 AS md_nom_platos_cat5,
md_diario_habituales.md_nom_platos_cat6 AS md_nom_platos_cat6,
md_diario_habituales.md_nom_cat1_EN AS md_nom_cat1,
md_diario_habituales.md_nom_cat2_EN AS md_nom_cat2,
md_diario_habituales.md_nom_cat3_EN AS md_nom_cat3,
md_diario_habituales.md_nom_cat4_EN AS md_nom_cat4,
md_diario_habituales.md_nom_cat5_EN AS md_nom_cat5,
md_diario_habituales.md_nom_cat6_EN AS md_nom_cat6,
md_diario_habituales.md_nom_platos_cat1_EN AS md_nom_platos_cat1_EN,
md_diario_habituales.md_nom_platos_cat2_EN AS md_nom_platos_cat2_EN,
md_diario_habituales.md_nom_platos_cat3_EN AS md_nom_platos_cat3_EN,
md_diario_habituales.md_nom_platos_cat4_EN AS md_nom_platos_cat4_EN,
md_diario_habituales.md_nom_platos_cat5_EN AS md_nom_platos_cat5_EN,
md_diario_habituales.md_nom_platos_cat6_EN AS md_nom_platos_cat6_EN,
md_diario_habituales.md_menus_especiales AS md_menus_especiales
FROM md_diario_habituales
WHERE id_md_diario IN (781,784)
AND md_estado = 1 ANDNOT FIND_IN_SET('MDDG', IFNULL(acronimos_tipologia, ''))
)
UNION
(SELECT 3 AS tipo,
md_asignaciones_defecto.ID_establecimiento AS ID_establecimiento,
md_asignaciones_defecto.id AS id_md_diario,
'2025-04-05' AS md_fecha,
'X' AS md_fecha_LU,
'X' AS md_fecha_MA,
'X' AS md_fecha_MI,
'X' AS md_fecha_JU,
'X' AS md_fecha_VI,
'X' AS md_fecha_SA,
'X' AS md_fecha_DO,
md_configuraciones_tipo.md_nombre AS md_nombre,
md_configuraciones_tipo.md_nombre_EN AS md_nombre_EN,
md_configuraciones_tipo.md_servicio AS md_servicio,
md_configuraciones_tipo.md_PR_comida AS md_PR_comida,
md_configuraciones_tipo.md_PR_cena AS md_PR_cena,
md_configuraciones_tipo.md_PR_jornada AS md_PR_jornada,
md_configuraciones_tipo.md_LL_servicio AS md_LL_servicio,
md_configuraciones_tipo.md_MM1_servicio AS md_MM1_servicio,
md_configuraciones_tipo.md_MM2_servicio AS md_MM2_servicio,
'1' AS md_tipo_cat,
'Y' AS md_platos_cat1,
'Y' AS md_platos_cat2,
'Y' AS md_platos_cat3,
'Y' AS md_platos_cat4,
'Y' AS md_platos_cat5,
'Y' AS md_platos_cat6,
md_configuraciones_tipo.md_observaciones AS md_observaciones,
md_configuraciones_tipo.md_observaciones_EN AS md_observaciones_EN,
md_configuraciones_tipo.md_LL_nombre AS md_LL_nombre,
md_configuraciones_tipo.md_LL_nombre_EN AS md_LL_nombre_EN,
md_configuraciones_tipo.md_LL_PR_comida AS md_LL_PR_comida,
md_configuraciones_tipo.md_LL_PR_cena AS md_LL_PR_cena,
md_configuraciones_tipo.md_LL_PR_jornada AS md_LL_PR_jornada,
md_configuraciones_tipo.md_LL_observaciones AS md_LL_observaciones,
md_configuraciones_tipo.md_LL_observaciones_EN AS md_LL_observaciones_EN,
md_configuraciones_tipo.md_MM1_nombre AS md_MM1_nombre,
md_configuraciones_tipo.md_MM1_nombre_EN AS md_MM1_nombre_EN,
md_configuraciones_tipo.md_MM1_PR_comida AS md_MM1_PR_comida,
md_configuraciones_tipo.md_MM1_PR_cena AS md_MM1_PR_cena,
md_configuraciones_tipo.md_MM1_PR_jornada AS md_MM1_PR_jornada,
md_configuraciones_tipo.md_MM1_observaciones AS md_MM1_observaciones,
md_configuraciones_tipo.md_MM1_observaciones_EN AS md_MM1_observaciones_EN,
md_configuraciones_tipo.md_MM2_nombre AS md_MM2_nombre,
md_configuraciones_tipo.md_MM2_nombre_EN AS md_MM2_nombre_EN,
md_configuraciones_tipo.md_MM2_PR_comida AS md_MM2_PR_comida,
md_configuraciones_tipo.md_MM2_PR_cena AS md_MM2_PR_cena,
md_configuraciones_tipo.md_MM2_PR_jornada AS md_MM2_PR_jornada,
md_configuraciones_tipo.md_MM2_observaciones AS md_MM2_observaciones,
md_configuraciones_tipo.md_MM2_observaciones_EN AS md_MM2_observaciones_EN,
md_configuraciones_tipo.acronimos_tipologia AS acronimos_tipologia,
md_configuraciones_tipo.md_cat1 AS md_cat1,
md_configuraciones_tipo.md_cat2 AS md_cat2,
md_configuraciones_tipo.md_cat3 AS md_cat3,
md_configuraciones_tipo.md_cat4 AS md_cat4,
md_configuraciones_tipo.md_cat5 AS md_cat5,
md_configuraciones_tipo.md_cat6 AS md_cat6,
CASE WHEN md_configuraciones_tipo.md_cat1 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat1
LIMIT 1
)
END AS md_nom_cat1,
CASE WHEN md_configuraciones_tipo.md_cat2 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat2
LIMIT 1
)
END AS md_nom_cat2,
CASE WHEN md_configuraciones_tipo.md_cat3 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat3
LIMIT 1
)
END AS md_nom_cat3,
CASE WHEN md_configuraciones_tipo.md_cat4 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat4
LIMIT 1
)
END AS md_nom_cat4,
CASE WHEN md_configuraciones_tipo.md_cat5 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat5
LIMIT 1
)
END AS md_nom_cat5,
CASE WHEN md_configuraciones_tipo.md_cat6 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat6
LIMIT 1
)
END AS md_nom_cat6,
'Y' AS md_nom_platos,
'Y' AS md_nom_platos_cat1,
'Y' AS md_nom_platos_cat2,
'Y' AS md_nom_platos_cat3,
'Y' AS md_nom_platos_cat4,
'Y' AS md_nom_platos_cat5,
'Y' AS md_nom_platos_cat6,
CASE WHEN md_configuraciones_tipo.md_cat1 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria_EN
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat1
LIMIT 1
)
END AS md_nom_cat1_EN,
CASE WHEN md_configuraciones_tipo.md_cat2 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria_EN
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat2
LIMIT 1
)
END AS md_nom_cat2_EN,
CASE WHEN md_configuraciones_tipo.md_cat3 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria_EN
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat3
LIMIT 1
)
END AS md_nom_cat3_EN,
CASE WHEN md_configuraciones_tipo.md_cat4 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria_EN
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat4
LIMIT 1
)
END AS md_nom_cat4_EN,
CASE WHEN md_configuraciones_tipo.md_cat5 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria_EN
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat5
LIMIT 1
)
END AS md_nom_cat5_EN,
CASE WHEN md_configuraciones_tipo.md_cat6 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria_EN
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat6
LIMIT 1
)
END AS md_nom_cat6_EN,
'Y' AS md_nom_platos_cat1_EN,
'Y' AS md_nom_platos_cat2_EN,
'Y' AS md_nom_platos_cat3_EN,
'Y' AS md_nom_platos_cat4_EN,
'Y' AS md_nom_platos_cat5_EN,
'Y' AS md_nom_platos_cat6_EN,
'0' AS md_menus_especiales
FROM md_asignaciones_defecto
JOIN md_configuraciones_tipo
ON md_configuraciones_tipo.id_md_config_tipo = md_asignaciones_defecto.id_md_config_tipo
WHERE md_asignaciones_defecto.ID_establecimiento IN (1517)
AND md_asignaciones_defecto.ID_establecimiento NOTIN (1517,1517)
AND md_asignaciones_defecto.dia='SA' ANDNOT FIND_IN_SET('MDDG', IFNULL(acronimos_tipologia, ''))
)
Event: dbquery
Events
0.01 ms
Query
Database
0.13 ms
SELECT `nomCVIA`, `numVIA`, `CPOS`, `nomPOB`, `nomPRO`
FROM `establecimientos_localizaciones`
WHERE `ID_establecimiento` = '1508'
Event: dbquery
Events
0.01 ms
Query
Database
0.21 ms
SELECT `URL_foto`
FROM `establecimientos_fotos`
WHERE `ID_establecimiento` = '1508'
ORDERBY `ORDER_foto` ASCLIMIT 1
Event: dbquery
Events
0.01 ms
Query
Database
0.15 ms
SELECT `establecimientos_ambientes`.`ID_ambiente`
FROM `establecimientos_ambientes`
LEFTJOIN `ambientes` ON `ambientes`.`ID_ambiente` = `establecimientos_ambientes`.`ID_ambiente`
WHERE `establecimientos_ambientes`.`ID_establecimiento` = '1508'
Event: dbquery
Events
0.01 ms
Query
Database
0.10 ms
SELECT `establecimientos_tipo_negocio`.`ID_tipo_negocio`
FROM `establecimientos_tipo_negocio`
LEFTJOIN `tipos_negocio` ON `tipos_negocio`.`ID_tipo_negocio` = `establecimientos_tipo_negocio`.`ID_tipo_negocio`
WHERE `establecimientos_tipo_negocio`.`ID_establecimiento` = '1508'
Event: dbquery
Events
0.01 ms
Query
Database
0.21 ms
SELECT `establecimientos_caracteristicas`.`ID_caracteristicas`
FROM `establecimientos_caracteristicas`
LEFTJOIN `caracteristicas` ON `caracteristicas`.`ID_caracteristicas` = `establecimientos_caracteristicas`.`ID_caracteristicas`
WHERE `establecimientos_caracteristicas`.`ID_establecimiento` = '1508'
Event: dbquery
Events
0.01 ms
Query
Database
0.10 ms
SELECT `establecimientos_tipo_elaboracion`.`ID_tipo_elaboracion`
FROM `establecimientos_tipo_elaboracion`
LEFTJOIN `tipo_cocina_elaboracion` ON `tipo_cocina_elaboracion`.`ID_tipo_elaboracion` = `establecimientos_tipo_elaboracion`.`ID_tipo_elaboracion`
WHERE `establecimientos_tipo_elaboracion`.`ID_establecimiento` = '1508'
Event: dbquery
Events
0.01 ms
Query
Database
0.11 ms
SELECT `establecimientos_tipo_origen`.`ID_tipo_origen`
FROM `establecimientos_tipo_origen`
LEFTJOIN `tipo_cocina_origen` ON `tipo_cocina_origen`.`ID_tipo_origen` = `establecimientos_tipo_origen`.`ID_tipo_origen`
WHERE `establecimientos_tipo_origen`.`ID_establecimiento` = '1508'
Event: dbquery
Events
0.01 ms
Query
Database
0.11 ms
SELECT `establecimientos_tarjetas`.`ID_tarjeta`
FROM `establecimientos_tarjetas`
LEFTJOIN `tarjetas_credito` ON `tarjetas_credito`.`ID_tarjeta` = `establecimientos_tarjetas`.`ID_tarjeta`
WHERE `establecimientos_tarjetas`.`ID_establecimiento` = '1508'
Event: dbquery
Events
0.00 ms
Query
Database
0.12 ms
SELECT `establecimientos_cheques`.`ID_cheque`
FROM `establecimientos_cheques`
LEFTJOIN `cheques_restaurante` ON `cheques_restaurante`.`ID_cheque` = `establecimientos_cheques`.`ID_cheque`
WHERE `establecimientos_cheques`.`ID_establecimiento` = '1508'
Event: dbquery
Events
0.02 ms
Query
Database
0.10 ms
SELECT `establecimientos_guias`.`ID_guia`
FROM `establecimientos_guias`
LEFTJOIN `guias` ON `guias`.`ID_guia` = `establecimientos_guias`.`ID_guia`
WHERE `establecimientos_guias`.`ID_establecimiento` = '1508'
Event: dbquery
Events
0.00 ms
Query
Database
0.23 ms
SELECT `establecimientos_calidad`.`ID_sistema`
FROM `establecimientos_calidad`
LEFTJOIN `sistemas_calidad` ON `sistemas_calidad`.`ID_sistema` = `establecimientos_calidad`.`ID_sistema`
WHERE `establecimientos_calidad`.`ID_establecimiento` = '1508'
Event: dbquery
Events
0.01 ms
Query
Database
0.13 ms
SELECT `establecimientos_idioma`.`ID_idioma`
FROM `establecimientos_idioma`
LEFTJOIN `idiomas` ON `idiomas`.`ID_idioma` = `establecimientos_idioma`.`ID_idioma`
WHERE `establecimientos_idioma`.`ID_establecimiento` = '1508'
Event: dbquery
Events
0.01 ms
Query
Database
0.13 ms
SELECT `SA_apertura` AS `apertura`, `SA_H1_ini` AS `H1ini`, `SA_H1_fin` AS `H1fin`, `SA_H2_ini` AS `H2ini`, `SA_H2_fin` AS `H2fin`, `SA_HC_ini` AS `HCini`, `SA_HC_fin` AS `HCfin`
FROM `establecimientos_horarios_habituales`
WHERE `ID_establecimiento` = '1508'
Event: dbquery
Events
0.01 ms
Query
Database
0.10 ms
SELECT `ID_establecimiento`, `id_md_diario`
FROM `md_diario`
WHERE `ID_establecimiento` IN ('1508')
AND `md_fecha` = '2025-04-05'
Event: dbquery
Events
0.00 ms
Query
Database
0.11 ms
SELECT `ID_establecimiento`, `id_md_diario`
FROM `md_diario_habituales`
WHERE `ID_establecimiento` IN ('1508')
AND `md_estado` = 1
AND md_fecha_SA=1
Event: dbquery
Events
0.01 ms
Query
Database
4.99 ms
(SELECT 1 AS tipo,
md_diario.ID_establecimiento AS ID_establecimiento,
md_diario.id_md_diario AS id_md_diario,
md_diario.md_fecha AS md_fecha,
'X' AS md_fecha_LU,
'X' AS md_fecha_MA,
'X' AS md_fecha_MI,
'X' AS md_fecha_JU,
'X' AS md_fecha_VI,
'X' AS md_fecha_SA,
'X' AS md_fecha_DO,
-- resto de columnas menús diarios
md_diario.md_nombre AS md_nombre,
md_diario.md_nombre_EN AS md_nombre_EN,
md_diario.md_servicio AS md_servicio,
md_diario.md_PR_comida AS md_PR_comida,
md_diario.md_PR_cena AS md_PR_cena,
md_diario.md_PR_jornada AS md_PR_jornada,
md_diario.md_LL_servicio AS md_LL_servicio,
md_diario.md_MM1_servicio AS md_MM1_servicio,
md_diario.md_MM2_servicio AS md_MM2_servicio,
md_diario.md_tipo_cat AS md_tipo_cat,
md_diario.md_platos_cat1 AS md_platos_cat1,
md_diario.md_platos_cat2 AS md_platos_cat2,
md_diario.md_platos_cat3 AS md_platos_cat3,
md_diario.md_platos_cat4 AS md_platos_cat4,
md_diario.md_platos_cat5 AS md_platos_cat5,
md_diario.md_platos_cat6 AS md_platos_cat6,
md_diario.md_observaciones AS md_observaciones,
md_diario.md_observaciones_EN AS md_observaciones_EN,
md_diario.md_LL_nombre AS md_LL_nombre,
md_diario.md_LL_nombre_EN AS md_LL_nombre_EN,
md_diario.md_LL_PR_comida AS md_LL_PR_comida,
md_diario.md_LL_PR_cena AS md_LL_PR_cena,
md_diario.md_LL_PR_jornada AS md_LL_PR_jornada,
md_diario.md_LL_observaciones AS md_LL_observaciones,
md_diario.md_LL_observaciones_EN AS md_LL_observaciones_EN,
md_diario.md_MM1_nombre AS md_MM1_nombre,
md_diario.md_MM1_nombre_EN AS md_MM1_nombre_EN,
md_diario.md_MM1_PR_comida AS md_MM1_PR_comida,
md_diario.md_MM1_PR_cena AS md_MM1_PR_cena,
md_diario.md_MM1_PR_jornada AS md_MM1_PR_jornada,
md_diario.md_MM1_observaciones AS md_MM1_observaciones,
md_diario.md_MM1_observaciones_EN AS md_MM1_observaciones_EN,
md_diario.md_MM2_nombre AS md_MM2_nombre,
md_diario.md_MM2_nombre_EN AS md_MM2_nombre_EN,
md_diario.md_MM2_PR_comida AS md_MM2_PR_comida,
md_diario.md_MM2_PR_cena AS md_MM2_PR_cena,
md_diario.md_MM2_PR_jornada AS md_MM2_PR_jornada,
md_diario.md_MM2_observaciones AS md_MM2_observaciones,
md_diario.md_MM2_observaciones_EN AS md_MM2_observaciones_EN,
md_diario.acronimos_tipologia AS acronimos_tipologia,
md_diario.md_cat1 AS md_cat1,
md_diario.md_cat2 AS md_cat2,
md_diario.md_cat3 AS md_cat3,
md_diario.md_cat4 AS md_cat4,
md_diario.md_cat5 AS md_cat5,
md_diario.md_cat6 AS md_cat6,
md_diario.md_nom_cat1 AS md_nom_cat1,
md_diario.md_nom_cat2 AS md_nom_cat2,
md_diario.md_nom_cat3 AS md_nom_cat3,
md_diario.md_nom_cat4 AS md_nom_cat4,
md_diario.md_nom_cat5 AS md_nom_cat5,
md_diario.md_nom_cat6 AS md_nom_cat6,
md_diario.md_nom_platos AS md_nom_platos,
md_diario.md_nom_platos_cat1 AS md_nom_platos_cat1,
md_diario.md_nom_platos_cat2 AS md_nom_platos_cat2,
md_diario.md_nom_platos_cat3 AS md_nom_platos_cat3,
md_diario.md_nom_platos_cat4 AS md_nom_platos_cat4,
md_diario.md_nom_platos_cat5 AS md_nom_platos_cat5,
md_diario.md_nom_platos_cat6 AS md_nom_platos_cat6,
md_diario.md_nom_cat1_EN AS md_nom_cat1_EN,
md_diario.md_nom_cat2_EN AS md_nom_cat2_EN,
md_diario.md_nom_cat3_EN AS md_nom_cat3_EN,
md_diario.md_nom_cat4_EN AS md_nom_cat4_EN,
md_diario.md_nom_cat5_EN AS md_nom_cat5_EN,
md_diario.md_nom_cat6_EN AS md_nom_cat6_EN,
md_diario.md_nom_platos_cat1_EN AS md_nom_platos_cat1_EN,
md_diario.md_nom_platos_cat2_EN AS md_nom_platos_cat2_EN,
md_diario.md_nom_platos_cat3_EN AS md_nom_platos_cat3_EN,
md_diario.md_nom_platos_cat4_EN AS md_nom_platos_cat4_EN,
md_diario.md_nom_platos_cat5_EN AS md_nom_platos_cat5_EN,
md_diario.md_nom_platos_cat6_EN AS md_nom_platos_cat6_EN,
md_diario.md_menus_especiales AS md_menus_especiales
FROM md_diario
WHERE ID_establecimiento IN (1508)
AND md_fecha = '2025-04-05' ANDNOT FIND_IN_SET('MDDG', IFNULL(acronimos_tipologia, ''))
)
UNION
(SELECT 2 AS tipo,
md_diario_habituales.ID_establecimiento AS ID_establecimiento,
md_diario_habituales.id_md_diario AS id_md_diario,
'2025-04-05' AS md_fecha,
md_diario_habituales.md_fecha_LU AS md_fecha_LU,
md_diario_habituales.md_fecha_MA AS md_fecha_MA,
md_diario_habituales.md_fecha_MI AS md_fecha_MI,
md_diario_habituales.md_fecha_JU AS md_fecha_JU,
md_diario_habituales.md_fecha_VI AS md_fecha_VI,
md_diario_habituales.md_fecha_SA AS md_fecha_SA,
md_diario_habituales.md_fecha_DO AS md_fecha_DO,
-- resto de columnas
md_diario_habituales.md_nombre AS md_nombre,
md_diario_habituales.md_nombre_EN AS md_nombre_EN,
md_diario_habituales.md_servicio AS md_servicio,
md_diario_habituales.md_PR_comida AS md_PR_comida,
md_diario_habituales.md_PR_cena AS md_PR_cena,
md_diario_habituales.md_PR_jornada AS md_PR_jornada,
md_diario_habituales.md_LL_servicio AS md_LL_servicio,
md_diario_habituales.md_MM1_servicio AS md_MM1_servicio,
md_diario_habituales.md_MM2_servicio AS md_MM2_servicio,
md_diario_habituales.md_tipo_cat AS md_tipo_cat,
md_diario_habituales.md_platos_cat1 AS md_platos_cat1,
md_diario_habituales.md_platos_cat2 AS md_platos_cat2,
md_diario_habituales.md_platos_cat3 AS md_platos_cat3,
md_diario_habituales.md_platos_cat4 AS md_platos_cat4,
md_diario_habituales.md_platos_cat5 AS md_platos_cat5,
md_diario_habituales.md_platos_cat6 AS md_platos_cat6,
md_diario_habituales.md_observaciones AS md_observaciones,
md_diario_habituales.md_observaciones_EN AS md_observaciones_EN,
md_diario_habituales.md_LL_nombre AS md_LL_nombre,
md_diario_habituales.md_LL_nombre_EN AS md_LL_nombre_EN,
md_diario_habituales.md_LL_PR_comida AS md_LL_PR_comida,
md_diario_habituales.md_LL_PR_cena AS md_LL_PR_cena,
md_diario_habituales.md_LL_PR_jornada AS md_LL_PR_jornada,
md_diario_habituales.md_LL_observaciones AS md_LL_observaciones,
md_diario_habituales.md_LL_observaciones_EN AS md_LL_observaciones_EN,
md_diario_habituales.md_MM1_nombre AS md_MM1_nombre,
md_diario_habituales.md_MM1_nombre_EN AS md_MM1_nombre_EN,
md_diario_habituales.md_MM1_PR_comida AS md_MM1_PR_comida,
md_diario_habituales.md_MM1_PR_cena AS md_MM1_PR_cena,
md_diario_habituales.md_MM1_PR_jornada AS md_MM1_PR_jornada,
md_diario_habituales.md_MM1_observaciones AS md_MM1_observaciones,
md_diario_habituales.md_MM1_observaciones_EN AS md_MM1_observaciones_EN,
md_diario_habituales.md_MM2_nombre AS md_MM2_nombre,
md_diario_habituales.md_MM2_nombre_EN AS md_MM2_nombre_EN,
md_diario_habituales.md_MM2_PR_comida AS md_MM2_PR_comida,
md_diario_habituales.md_MM2_PR_cena AS md_MM2_PR_cena,
md_diario_habituales.md_MM2_PR_jornada AS md_MM2_PR_jornada,
md_diario_habituales.md_MM2_observaciones AS md_MM2_observaciones,
md_diario_habituales.md_MM2_observaciones_EN AS md_MM2_observaciones_EN,
md_diario_habituales.acronimos_tipologia AS acronimos_tipologia,
md_diario_habituales.md_cat1 AS md_cat1,
md_diario_habituales.md_cat2 AS md_cat2,
md_diario_habituales.md_cat3 AS md_cat3,
md_diario_habituales.md_cat4 AS md_cat4,
md_diario_habituales.md_cat5 AS md_cat5,
md_diario_habituales.md_cat6 AS md_cat6,
md_diario_habituales.md_nom_cat1 AS md_nom_cat1,
md_diario_habituales.md_nom_cat2 AS md_nom_cat2,
md_diario_habituales.md_nom_cat3 AS md_nom_cat3,
md_diario_habituales.md_nom_cat4 AS md_nom_cat4,
md_diario_habituales.md_nom_cat5 AS md_nom_cat5,
md_diario_habituales.md_nom_cat6 AS md_nom_cat6,
md_diario_habituales.md_nom_platos AS md_nom_platos,
md_diario_habituales.md_nom_platos_cat1 AS md_nom_platos_cat1,
md_diario_habituales.md_nom_platos_cat2 AS md_nom_platos_cat2,
md_diario_habituales.md_nom_platos_cat3 AS md_nom_platos_cat3,
md_diario_habituales.md_nom_platos_cat4 AS md_nom_platos_cat4,
md_diario_habituales.md_nom_platos_cat5 AS md_nom_platos_cat5,
md_diario_habituales.md_nom_platos_cat6 AS md_nom_platos_cat6,
md_diario_habituales.md_nom_cat1_EN AS md_nom_cat1,
md_diario_habituales.md_nom_cat2_EN AS md_nom_cat2,
md_diario_habituales.md_nom_cat3_EN AS md_nom_cat3,
md_diario_habituales.md_nom_cat4_EN AS md_nom_cat4,
md_diario_habituales.md_nom_cat5_EN AS md_nom_cat5,
md_diario_habituales.md_nom_cat6_EN AS md_nom_cat6,
md_diario_habituales.md_nom_platos_cat1_EN AS md_nom_platos_cat1_EN,
md_diario_habituales.md_nom_platos_cat2_EN AS md_nom_platos_cat2_EN,
md_diario_habituales.md_nom_platos_cat3_EN AS md_nom_platos_cat3_EN,
md_diario_habituales.md_nom_platos_cat4_EN AS md_nom_platos_cat4_EN,
md_diario_habituales.md_nom_platos_cat5_EN AS md_nom_platos_cat5_EN,
md_diario_habituales.md_nom_platos_cat6_EN AS md_nom_platos_cat6_EN,
md_diario_habituales.md_menus_especiales AS md_menus_especiales
FROM md_diario_habituales
WHERE id_md_diario IN (748,749)
AND md_estado = 1 ANDNOT FIND_IN_SET('MDDG', IFNULL(acronimos_tipologia, ''))
)
UNION
(SELECT 3 AS tipo,
md_asignaciones_defecto.ID_establecimiento AS ID_establecimiento,
md_asignaciones_defecto.id AS id_md_diario,
'2025-04-05' AS md_fecha,
'X' AS md_fecha_LU,
'X' AS md_fecha_MA,
'X' AS md_fecha_MI,
'X' AS md_fecha_JU,
'X' AS md_fecha_VI,
'X' AS md_fecha_SA,
'X' AS md_fecha_DO,
md_configuraciones_tipo.md_nombre AS md_nombre,
md_configuraciones_tipo.md_nombre_EN AS md_nombre_EN,
md_configuraciones_tipo.md_servicio AS md_servicio,
md_configuraciones_tipo.md_PR_comida AS md_PR_comida,
md_configuraciones_tipo.md_PR_cena AS md_PR_cena,
md_configuraciones_tipo.md_PR_jornada AS md_PR_jornada,
md_configuraciones_tipo.md_LL_servicio AS md_LL_servicio,
md_configuraciones_tipo.md_MM1_servicio AS md_MM1_servicio,
md_configuraciones_tipo.md_MM2_servicio AS md_MM2_servicio,
'1' AS md_tipo_cat,
'Y' AS md_platos_cat1,
'Y' AS md_platos_cat2,
'Y' AS md_platos_cat3,
'Y' AS md_platos_cat4,
'Y' AS md_platos_cat5,
'Y' AS md_platos_cat6,
md_configuraciones_tipo.md_observaciones AS md_observaciones,
md_configuraciones_tipo.md_observaciones_EN AS md_observaciones_EN,
md_configuraciones_tipo.md_LL_nombre AS md_LL_nombre,
md_configuraciones_tipo.md_LL_nombre_EN AS md_LL_nombre_EN,
md_configuraciones_tipo.md_LL_PR_comida AS md_LL_PR_comida,
md_configuraciones_tipo.md_LL_PR_cena AS md_LL_PR_cena,
md_configuraciones_tipo.md_LL_PR_jornada AS md_LL_PR_jornada,
md_configuraciones_tipo.md_LL_observaciones AS md_LL_observaciones,
md_configuraciones_tipo.md_LL_observaciones_EN AS md_LL_observaciones_EN,
md_configuraciones_tipo.md_MM1_nombre AS md_MM1_nombre,
md_configuraciones_tipo.md_MM1_nombre_EN AS md_MM1_nombre_EN,
md_configuraciones_tipo.md_MM1_PR_comida AS md_MM1_PR_comida,
md_configuraciones_tipo.md_MM1_PR_cena AS md_MM1_PR_cena,
md_configuraciones_tipo.md_MM1_PR_jornada AS md_MM1_PR_jornada,
md_configuraciones_tipo.md_MM1_observaciones AS md_MM1_observaciones,
md_configuraciones_tipo.md_MM1_observaciones_EN AS md_MM1_observaciones_EN,
md_configuraciones_tipo.md_MM2_nombre AS md_MM2_nombre,
md_configuraciones_tipo.md_MM2_nombre_EN AS md_MM2_nombre_EN,
md_configuraciones_tipo.md_MM2_PR_comida AS md_MM2_PR_comida,
md_configuraciones_tipo.md_MM2_PR_cena AS md_MM2_PR_cena,
md_configuraciones_tipo.md_MM2_PR_jornada AS md_MM2_PR_jornada,
md_configuraciones_tipo.md_MM2_observaciones AS md_MM2_observaciones,
md_configuraciones_tipo.md_MM2_observaciones_EN AS md_MM2_observaciones_EN,
md_configuraciones_tipo.acronimos_tipologia AS acronimos_tipologia,
md_configuraciones_tipo.md_cat1 AS md_cat1,
md_configuraciones_tipo.md_cat2 AS md_cat2,
md_configuraciones_tipo.md_cat3 AS md_cat3,
md_configuraciones_tipo.md_cat4 AS md_cat4,
md_configuraciones_tipo.md_cat5 AS md_cat5,
md_configuraciones_tipo.md_cat6 AS md_cat6,
CASE WHEN md_configuraciones_tipo.md_cat1 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat1
LIMIT 1
)
END AS md_nom_cat1,
CASE WHEN md_configuraciones_tipo.md_cat2 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat2
LIMIT 1
)
END AS md_nom_cat2,
CASE WHEN md_configuraciones_tipo.md_cat3 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat3
LIMIT 1
)
END AS md_nom_cat3,
CASE WHEN md_configuraciones_tipo.md_cat4 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat4
LIMIT 1
)
END AS md_nom_cat4,
CASE WHEN md_configuraciones_tipo.md_cat5 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat5
LIMIT 1
)
END AS md_nom_cat5,
CASE WHEN md_configuraciones_tipo.md_cat6 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat6
LIMIT 1
)
END AS md_nom_cat6,
'Y' AS md_nom_platos,
'Y' AS md_nom_platos_cat1,
'Y' AS md_nom_platos_cat2,
'Y' AS md_nom_platos_cat3,
'Y' AS md_nom_platos_cat4,
'Y' AS md_nom_platos_cat5,
'Y' AS md_nom_platos_cat6,
CASE WHEN md_configuraciones_tipo.md_cat1 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria_EN
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat1
LIMIT 1
)
END AS md_nom_cat1_EN,
CASE WHEN md_configuraciones_tipo.md_cat2 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria_EN
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat2
LIMIT 1
)
END AS md_nom_cat2_EN,
CASE WHEN md_configuraciones_tipo.md_cat3 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria_EN
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat3
LIMIT 1
)
END AS md_nom_cat3_EN,
CASE WHEN md_configuraciones_tipo.md_cat4 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria_EN
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat4
LIMIT 1
)
END AS md_nom_cat4_EN,
CASE WHEN md_configuraciones_tipo.md_cat5 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria_EN
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat5
LIMIT 1
)
END AS md_nom_cat5_EN,
CASE WHEN md_configuraciones_tipo.md_cat6 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria_EN
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat6
LIMIT 1
)
END AS md_nom_cat6_EN,
'Y' AS md_nom_platos_cat1_EN,
'Y' AS md_nom_platos_cat2_EN,
'Y' AS md_nom_platos_cat3_EN,
'Y' AS md_nom_platos_cat4_EN,
'Y' AS md_nom_platos_cat5_EN,
'Y' AS md_nom_platos_cat6_EN,
'0' AS md_menus_especiales
FROM md_asignaciones_defecto
JOIN md_configuraciones_tipo
ON md_configuraciones_tipo.id_md_config_tipo = md_asignaciones_defecto.id_md_config_tipo
WHERE md_asignaciones_defecto.ID_establecimiento IN (1508)
AND md_asignaciones_defecto.ID_establecimiento NOTIN (1508,1508)
AND md_asignaciones_defecto.dia='SA' ANDNOT FIND_IN_SET('MDDG', IFNULL(acronimos_tipologia, ''))
)
Event: dbquery
Events
0.01 ms
Query
Database
0.22 ms
SELECT `ES_provincias`.`idPRO`, `ES_provincias`.`nomPRO`, `ES_provincias`.`slugPRO`, `ES_ccaa`.`idCCAA`, `ES_ccaa`.`nomCCAA`, `ES_ccaa`.`slugCCAA`
FROM `ES_provincias`
INNERJOIN `ES_ccaa` ON `ES_provincias`.`idCCAA` = `ES_ccaa`.`idCCAA`
WHERE `ES_provincias`.`idPRO` = '0737'
ORDERBY `ES_provincias`.`nomPRO` ASC
Event: dbquery
Events
0.01 ms
Query
Database
0.37 ms
SELECT `ES_comarcas`.`idCOM`, `ES_comarcas`.`nomCOM`, `ES_comarcas`.`slugCOM`, `ES_provincias`.`idPRO`, `ES_provincias`.`nomPRO`, `ES_provincias`.`slugPRO`, `ES_ccaa`.`idCCAA`, `ES_ccaa`.`nomCCAA`, `ES_ccaa`.`slugCCAA`
FROM `ES_comarcas`
INNERJOIN `ES_provincias` ON `ES_comarcas`.`idPRO` = `ES_provincias`.`idPRO`
INNERJOIN `ES_ccaa` ON `ES_provincias`.`idCCAA` = `ES_ccaa`.`idCCAA`
WHERE `ES_comarcas`.`idPRO` = '0737'
ORDERBY `ES_comarcas`.`nomCOM` ASC
Event: dbquery
Events
0.01 ms
Query
Database
0.19 ms
SELECT `ES_provincias`.`idPRO`, `ES_provincias`.`nomPRO`, `ES_provincias`.`slugPRO`, `ES_ccaa`.`idCCAA`, `ES_ccaa`.`nomCCAA`, `ES_ccaa`.`slugCCAA`
FROM `ES_provincias`
INNERJOIN `ES_ccaa` ON `ES_provincias`.`idCCAA` = `ES_ccaa`.`idCCAA`
WHERE `ES_provincias`.`idCCAA` = '07'
ORDERBY `ES_provincias`.`nomPRO` ASC
Event: dbquery
Events
0.01 ms
Query
Database
11.25 ms
SELECT `ES_municipios`.`idMUN`, `ES_municipios`.`nomMUN`, `ES_municipios`.`slugMUN`, `ES_comarcas`.`idCOM`, `ES_comarcas`.`nomCOM`, `ES_comarcas`.`slugCOM`, `ES_provincias`.`idPRO`, `ES_provincias`.`nomPRO`, `ES_provincias`.`slugPRO`, `ES_ccaa`.`idCCAA`, `ES_ccaa`.`nomCCAA`, `ES_ccaa`.`slugCCAA`
FROM `ES_municipios`
INNERJOIN `ES_comarcas` ON `ES_municipios`.`idCOM` = `ES_comarcas`.`idCOM`
INNERJOIN `ES_provincias` ON `ES_comarcas`.`idPRO` = `ES_provincias`.`idPRO`
INNERJOIN `ES_ccaa` ON `ES_provincias`.`idCCAA` = `ES_ccaa`.`idCCAA`
WHERE `ES_municipios`.`idPRO` = '0737'
ORDERBY `ES_municipios`.`nomMUN` ASC
SELECT T.ID_establecimiento
FROM (
(
SELECT d.ID_establecimiento
FROM md_diario d
JOIN establecimientos e ON d.ID_establecimiento = e.ID_establecimiento
WHERE d.md_fecha = '2025-04-05'
AND d.acronimo_clasificacion_gral = 'MD' AND e.estado_establecimiento = 1
ANDNOT FIND_IN_SET('MDDG', IFNULL(d.acronimos_tipologia, ''))
)
UNION
(
SELECT h.ID_establecimiento
FROM md_diario_habituales h
JOIN establecimientos e ON h.ID_establecimiento = e.ID_establecimiento
WHERE h.md_fecha_SA = 1 AND e.estado_establecimiento = 1
AND h.acronimo_clasificacion_gral = 'MD' AND h.md_estado = 1
ANDNOT FIND_IN_SET('MDDG', IFNULL(h.acronimos_tipologia, ''))
)
UNION
(
SELECT ad.ID_establecimiento
FROM md_asignaciones_defecto AS ad
JOIN md_configuraciones_tipo AS c
ON ad.id_md_config_tipo = c.id_md_config_tipo
JOIN establecimientos e ON ad.ID_establecimiento = e.ID_establecimiento
WHERE ad.dia = 'SA'
AND c.acronimo_clasificacion_gral = 'MD' AND e.estado_establecimiento = 1
ANDNOT FIND_IN_SET('MDDG', IFNULL(c.acronimos_tipologia, ''))
)
) AS T
JOIN establecimientos_localizaciones AS L
ON L.ID_establecimiento = T.ID_establecimiento
WHERE L.idPRO = '0737'
SELECTCOUNT(*) AS `numrows`
FROM `establecimientos`
WHERE `ID_establecimiento` IN ('1508','1517')
AND `logotipo_establecimiento` ISNOTNULLAND `logotipo_establecimiento` != ''
SELECT *
FROM `establecimientos`
WHERE `ID_establecimiento` IN ('1508','1517')
AND `logotipo_establecimiento` ISNOTNULLAND `logotipo_establecimiento` != ''
ORDERBY `nombre_establecimiento` ASC, `fecha_creacion_establecimiento` ASCLIMIT 4
SELECT `establecimientos_ambientes`.`ID_ambiente`
FROM `establecimientos_ambientes`
LEFTJOIN `ambientes` ON `ambientes`.`ID_ambiente` = `establecimientos_ambientes`.`ID_ambiente`
WHERE `establecimientos_ambientes`.`ID_establecimiento` = '1517'
SELECT `establecimientos_tipo_negocio`.`ID_tipo_negocio`
FROM `establecimientos_tipo_negocio`
LEFTJOIN `tipos_negocio` ON `tipos_negocio`.`ID_tipo_negocio` = `establecimientos_tipo_negocio`.`ID_tipo_negocio`
WHERE `establecimientos_tipo_negocio`.`ID_establecimiento` = '1517'
SELECT `establecimientos_caracteristicas`.`ID_caracteristicas`
FROM `establecimientos_caracteristicas`
LEFTJOIN `caracteristicas` ON `caracteristicas`.`ID_caracteristicas` = `establecimientos_caracteristicas`.`ID_caracteristicas`
WHERE `establecimientos_caracteristicas`.`ID_establecimiento` = '1517'
SELECT `establecimientos_tipo_elaboracion`.`ID_tipo_elaboracion`
FROM `establecimientos_tipo_elaboracion`
LEFTJOIN `tipo_cocina_elaboracion` ON `tipo_cocina_elaboracion`.`ID_tipo_elaboracion` = `establecimientos_tipo_elaboracion`.`ID_tipo_elaboracion`
WHERE `establecimientos_tipo_elaboracion`.`ID_establecimiento` = '1517'
SELECT `establecimientos_tipo_origen`.`ID_tipo_origen`
FROM `establecimientos_tipo_origen`
LEFTJOIN `tipo_cocina_origen` ON `tipo_cocina_origen`.`ID_tipo_origen` = `establecimientos_tipo_origen`.`ID_tipo_origen`
WHERE `establecimientos_tipo_origen`.`ID_establecimiento` = '1517'
SELECT `establecimientos_tarjetas`.`ID_tarjeta`
FROM `establecimientos_tarjetas`
LEFTJOIN `tarjetas_credito` ON `tarjetas_credito`.`ID_tarjeta` = `establecimientos_tarjetas`.`ID_tarjeta`
WHERE `establecimientos_tarjetas`.`ID_establecimiento` = '1517'
SELECT `establecimientos_cheques`.`ID_cheque`
FROM `establecimientos_cheques`
LEFTJOIN `cheques_restaurante` ON `cheques_restaurante`.`ID_cheque` = `establecimientos_cheques`.`ID_cheque`
WHERE `establecimientos_cheques`.`ID_establecimiento` = '1517'
SELECT `establecimientos_guias`.`ID_guia`
FROM `establecimientos_guias`
LEFTJOIN `guias` ON `guias`.`ID_guia` = `establecimientos_guias`.`ID_guia`
WHERE `establecimientos_guias`.`ID_establecimiento` = '1517'
SELECT `establecimientos_calidad`.`ID_sistema`
FROM `establecimientos_calidad`
LEFTJOIN `sistemas_calidad` ON `sistemas_calidad`.`ID_sistema` = `establecimientos_calidad`.`ID_sistema`
WHERE `establecimientos_calidad`.`ID_establecimiento` = '1517'
SELECT `establecimientos_idioma`.`ID_idioma`
FROM `establecimientos_idioma`
LEFTJOIN `idiomas` ON `idiomas`.`ID_idioma` = `establecimientos_idioma`.`ID_idioma`
WHERE `establecimientos_idioma`.`ID_establecimiento` = '1517'
SELECT `SA_apertura` AS `apertura`, `SA_H1_ini` AS `H1ini`, `SA_H1_fin` AS `H1fin`, `SA_H2_ini` AS `H2ini`, `SA_H2_fin` AS `H2fin`, `SA_HC_ini` AS `HCini`, `SA_HC_fin` AS `HCfin`
FROM `establecimientos_horarios_habituales`
WHERE `ID_establecimiento` = '1517'
(SELECT 1 AS tipo,
md_diario.ID_establecimiento AS ID_establecimiento,
md_diario.id_md_diario AS id_md_diario,
md_diario.md_fecha AS md_fecha,
'X' AS md_fecha_LU,
'X' AS md_fecha_MA,
'X' AS md_fecha_MI,
'X' AS md_fecha_JU,
'X' AS md_fecha_VI,
'X' AS md_fecha_SA,
'X' AS md_fecha_DO,
-- resto de columnas menús diarios
md_diario.md_nombre AS md_nombre,
md_diario.md_nombre_EN AS md_nombre_EN,
md_diario.md_servicio AS md_servicio,
md_diario.md_PR_comida AS md_PR_comida,
md_diario.md_PR_cena AS md_PR_cena,
md_diario.md_PR_jornada AS md_PR_jornada,
md_diario.md_LL_servicio AS md_LL_servicio,
md_diario.md_MM1_servicio AS md_MM1_servicio,
md_diario.md_MM2_servicio AS md_MM2_servicio,
md_diario.md_tipo_cat AS md_tipo_cat,
md_diario.md_platos_cat1 AS md_platos_cat1,
md_diario.md_platos_cat2 AS md_platos_cat2,
md_diario.md_platos_cat3 AS md_platos_cat3,
md_diario.md_platos_cat4 AS md_platos_cat4,
md_diario.md_platos_cat5 AS md_platos_cat5,
md_diario.md_platos_cat6 AS md_platos_cat6,
md_diario.md_observaciones AS md_observaciones,
md_diario.md_observaciones_EN AS md_observaciones_EN,
md_diario.md_LL_nombre AS md_LL_nombre,
md_diario.md_LL_nombre_EN AS md_LL_nombre_EN,
md_diario.md_LL_PR_comida AS md_LL_PR_comida,
md_diario.md_LL_PR_cena AS md_LL_PR_cena,
md_diario.md_LL_PR_jornada AS md_LL_PR_jornada,
md_diario.md_LL_observaciones AS md_LL_observaciones,
md_diario.md_LL_observaciones_EN AS md_LL_observaciones_EN,
md_diario.md_MM1_nombre AS md_MM1_nombre,
md_diario.md_MM1_nombre_EN AS md_MM1_nombre_EN,
md_diario.md_MM1_PR_comida AS md_MM1_PR_comida,
md_diario.md_MM1_PR_cena AS md_MM1_PR_cena,
md_diario.md_MM1_PR_jornada AS md_MM1_PR_jornada,
md_diario.md_MM1_observaciones AS md_MM1_observaciones,
md_diario.md_MM1_observaciones_EN AS md_MM1_observaciones_EN,
md_diario.md_MM2_nombre AS md_MM2_nombre,
md_diario.md_MM2_nombre_EN AS md_MM2_nombre_EN,
md_diario.md_MM2_PR_comida AS md_MM2_PR_comida,
md_diario.md_MM2_PR_cena AS md_MM2_PR_cena,
md_diario.md_MM2_PR_jornada AS md_MM2_PR_jornada,
md_diario.md_MM2_observaciones AS md_MM2_observaciones,
md_diario.md_MM2_observaciones_EN AS md_MM2_observaciones_EN,
md_diario.acronimos_tipologia AS acronimos_tipologia,
md_diario.md_cat1 AS md_cat1,
md_diario.md_cat2 AS md_cat2,
md_diario.md_cat3 AS md_cat3,
md_diario.md_cat4 AS md_cat4,
md_diario.md_cat5 AS md_cat5,
md_diario.md_cat6 AS md_cat6,
md_diario.md_nom_cat1 AS md_nom_cat1,
md_diario.md_nom_cat2 AS md_nom_cat2,
md_diario.md_nom_cat3 AS md_nom_cat3,
md_diario.md_nom_cat4 AS md_nom_cat4,
md_diario.md_nom_cat5 AS md_nom_cat5,
md_diario.md_nom_cat6 AS md_nom_cat6,
md_diario.md_nom_platos AS md_nom_platos,
md_diario.md_nom_platos_cat1 AS md_nom_platos_cat1,
md_diario.md_nom_platos_cat2 AS md_nom_platos_cat2,
md_diario.md_nom_platos_cat3 AS md_nom_platos_cat3,
md_diario.md_nom_platos_cat4 AS md_nom_platos_cat4,
md_diario.md_nom_platos_cat5 AS md_nom_platos_cat5,
md_diario.md_nom_platos_cat6 AS md_nom_platos_cat6,
md_diario.md_nom_cat1_EN AS md_nom_cat1_EN,
md_diario.md_nom_cat2_EN AS md_nom_cat2_EN,
md_diario.md_nom_cat3_EN AS md_nom_cat3_EN,
md_diario.md_nom_cat4_EN AS md_nom_cat4_EN,
md_diario.md_nom_cat5_EN AS md_nom_cat5_EN,
md_diario.md_nom_cat6_EN AS md_nom_cat6_EN,
md_diario.md_nom_platos_cat1_EN AS md_nom_platos_cat1_EN,
md_diario.md_nom_platos_cat2_EN AS md_nom_platos_cat2_EN,
md_diario.md_nom_platos_cat3_EN AS md_nom_platos_cat3_EN,
md_diario.md_nom_platos_cat4_EN AS md_nom_platos_cat4_EN,
md_diario.md_nom_platos_cat5_EN AS md_nom_platos_cat5_EN,
md_diario.md_nom_platos_cat6_EN AS md_nom_platos_cat6_EN,
md_diario.md_menus_especiales AS md_menus_especiales
FROM md_diario
WHERE ID_establecimiento IN (1517)
AND md_fecha = '2025-04-05' ANDNOT FIND_IN_SET('MDDG', IFNULL(acronimos_tipologia, ''))
)
UNION
(SELECT 2 AS tipo,
md_diario_habituales.ID_establecimiento AS ID_establecimiento,
md_diario_habituales.id_md_diario AS id_md_diario,
'2025-04-05' AS md_fecha,
md_diario_habituales.md_fecha_LU AS md_fecha_LU,
md_diario_habituales.md_fecha_MA AS md_fecha_MA,
md_diario_habituales.md_fecha_MI AS md_fecha_MI,
md_diario_habituales.md_fecha_JU AS md_fecha_JU,
md_diario_habituales.md_fecha_VI AS md_fecha_VI,
md_diario_habituales.md_fecha_SA AS md_fecha_SA,
md_diario_habituales.md_fecha_DO AS md_fecha_DO,
-- resto de columnas
md_diario_habituales.md_nombre AS md_nombre,
md_diario_habituales.md_nombre_EN AS md_nombre_EN,
md_diario_habituales.md_servicio AS md_servicio,
md_diario_habituales.md_PR_comida AS md_PR_comida,
md_diario_habituales.md_PR_cena AS md_PR_cena,
md_diario_habituales.md_PR_jornada AS md_PR_jornada,
md_diario_habituales.md_LL_servicio AS md_LL_servicio,
md_diario_habituales.md_MM1_servicio AS md_MM1_servicio,
md_diario_habituales.md_MM2_servicio AS md_MM2_servicio,
md_diario_habituales.md_tipo_cat AS md_tipo_cat,
md_diario_habituales.md_platos_cat1 AS md_platos_cat1,
md_diario_habituales.md_platos_cat2 AS md_platos_cat2,
md_diario_habituales.md_platos_cat3 AS md_platos_cat3,
md_diario_habituales.md_platos_cat4 AS md_platos_cat4,
md_diario_habituales.md_platos_cat5 AS md_platos_cat5,
md_diario_habituales.md_platos_cat6 AS md_platos_cat6,
md_diario_habituales.md_observaciones AS md_observaciones,
md_diario_habituales.md_observaciones_EN AS md_observaciones_EN,
md_diario_habituales.md_LL_nombre AS md_LL_nombre,
md_diario_habituales.md_LL_nombre_EN AS md_LL_nombre_EN,
md_diario_habituales.md_LL_PR_comida AS md_LL_PR_comida,
md_diario_habituales.md_LL_PR_cena AS md_LL_PR_cena,
md_diario_habituales.md_LL_PR_jornada AS md_LL_PR_jornada,
md_diario_habituales.md_LL_observaciones AS md_LL_observaciones,
md_diario_habituales.md_LL_observaciones_EN AS md_LL_observaciones_EN,
md_diario_habituales.md_MM1_nombre AS md_MM1_nombre,
md_diario_habituales.md_MM1_nombre_EN AS md_MM1_nombre_EN,
md_diario_habituales.md_MM1_PR_comida AS md_MM1_PR_comida,
md_diario_habituales.md_MM1_PR_cena AS md_MM1_PR_cena,
md_diario_habituales.md_MM1_PR_jornada AS md_MM1_PR_jornada,
md_diario_habituales.md_MM1_observaciones AS md_MM1_observaciones,
md_diario_habituales.md_MM1_observaciones_EN AS md_MM1_observaciones_EN,
md_diario_habituales.md_MM2_nombre AS md_MM2_nombre,
md_diario_habituales.md_MM2_nombre_EN AS md_MM2_nombre_EN,
md_diario_habituales.md_MM2_PR_comida AS md_MM2_PR_comida,
md_diario_habituales.md_MM2_PR_cena AS md_MM2_PR_cena,
md_diario_habituales.md_MM2_PR_jornada AS md_MM2_PR_jornada,
md_diario_habituales.md_MM2_observaciones AS md_MM2_observaciones,
md_diario_habituales.md_MM2_observaciones_EN AS md_MM2_observaciones_EN,
md_diario_habituales.acronimos_tipologia AS acronimos_tipologia,
md_diario_habituales.md_cat1 AS md_cat1,
md_diario_habituales.md_cat2 AS md_cat2,
md_diario_habituales.md_cat3 AS md_cat3,
md_diario_habituales.md_cat4 AS md_cat4,
md_diario_habituales.md_cat5 AS md_cat5,
md_diario_habituales.md_cat6 AS md_cat6,
md_diario_habituales.md_nom_cat1 AS md_nom_cat1,
md_diario_habituales.md_nom_cat2 AS md_nom_cat2,
md_diario_habituales.md_nom_cat3 AS md_nom_cat3,
md_diario_habituales.md_nom_cat4 AS md_nom_cat4,
md_diario_habituales.md_nom_cat5 AS md_nom_cat5,
md_diario_habituales.md_nom_cat6 AS md_nom_cat6,
md_diario_habituales.md_nom_platos AS md_nom_platos,
md_diario_habituales.md_nom_platos_cat1 AS md_nom_platos_cat1,
md_diario_habituales.md_nom_platos_cat2 AS md_nom_platos_cat2,
md_diario_habituales.md_nom_platos_cat3 AS md_nom_platos_cat3,
md_diario_habituales.md_nom_platos_cat4 AS md_nom_platos_cat4,
md_diario_habituales.md_nom_platos_cat5 AS md_nom_platos_cat5,
md_diario_habituales.md_nom_platos_cat6 AS md_nom_platos_cat6,
md_diario_habituales.md_nom_cat1_EN AS md_nom_cat1,
md_diario_habituales.md_nom_cat2_EN AS md_nom_cat2,
md_diario_habituales.md_nom_cat3_EN AS md_nom_cat3,
md_diario_habituales.md_nom_cat4_EN AS md_nom_cat4,
md_diario_habituales.md_nom_cat5_EN AS md_nom_cat5,
md_diario_habituales.md_nom_cat6_EN AS md_nom_cat6,
md_diario_habituales.md_nom_platos_cat1_EN AS md_nom_platos_cat1_EN,
md_diario_habituales.md_nom_platos_cat2_EN AS md_nom_platos_cat2_EN,
md_diario_habituales.md_nom_platos_cat3_EN AS md_nom_platos_cat3_EN,
md_diario_habituales.md_nom_platos_cat4_EN AS md_nom_platos_cat4_EN,
md_diario_habituales.md_nom_platos_cat5_EN AS md_nom_platos_cat5_EN,
md_diario_habituales.md_nom_platos_cat6_EN AS md_nom_platos_cat6_EN,
md_diario_habituales.md_menus_especiales AS md_menus_especiales
FROM md_diario_habituales
WHERE id_md_diario IN (781,784)
AND md_estado = 1 ANDNOT FIND_IN_SET('MDDG', IFNULL(acronimos_tipologia, ''))
)
UNION
(SELECT 3 AS tipo,
md_asignaciones_defecto.ID_establecimiento AS ID_establecimiento,
md_asignaciones_defecto.id AS id_md_diario,
'2025-04-05' AS md_fecha,
'X' AS md_fecha_LU,
'X' AS md_fecha_MA,
'X' AS md_fecha_MI,
'X' AS md_fecha_JU,
'X' AS md_fecha_VI,
'X' AS md_fecha_SA,
'X' AS md_fecha_DO,
md_configuraciones_tipo.md_nombre AS md_nombre,
md_configuraciones_tipo.md_nombre_EN AS md_nombre_EN,
md_configuraciones_tipo.md_servicio AS md_servicio,
md_configuraciones_tipo.md_PR_comida AS md_PR_comida,
md_configuraciones_tipo.md_PR_cena AS md_PR_cena,
md_configuraciones_tipo.md_PR_jornada AS md_PR_jornada,
md_configuraciones_tipo.md_LL_servicio AS md_LL_servicio,
md_configuraciones_tipo.md_MM1_servicio AS md_MM1_servicio,
md_configuraciones_tipo.md_MM2_servicio AS md_MM2_servicio,
'1' AS md_tipo_cat,
'Y' AS md_platos_cat1,
'Y' AS md_platos_cat2,
'Y' AS md_platos_cat3,
'Y' AS md_platos_cat4,
'Y' AS md_platos_cat5,
'Y' AS md_platos_cat6,
md_configuraciones_tipo.md_observaciones AS md_observaciones,
md_configuraciones_tipo.md_observaciones_EN AS md_observaciones_EN,
md_configuraciones_tipo.md_LL_nombre AS md_LL_nombre,
md_configuraciones_tipo.md_LL_nombre_EN AS md_LL_nombre_EN,
md_configuraciones_tipo.md_LL_PR_comida AS md_LL_PR_comida,
md_configuraciones_tipo.md_LL_PR_cena AS md_LL_PR_cena,
md_configuraciones_tipo.md_LL_PR_jornada AS md_LL_PR_jornada,
md_configuraciones_tipo.md_LL_observaciones AS md_LL_observaciones,
md_configuraciones_tipo.md_LL_observaciones_EN AS md_LL_observaciones_EN,
md_configuraciones_tipo.md_MM1_nombre AS md_MM1_nombre,
md_configuraciones_tipo.md_MM1_nombre_EN AS md_MM1_nombre_EN,
md_configuraciones_tipo.md_MM1_PR_comida AS md_MM1_PR_comida,
md_configuraciones_tipo.md_MM1_PR_cena AS md_MM1_PR_cena,
md_configuraciones_tipo.md_MM1_PR_jornada AS md_MM1_PR_jornada,
md_configuraciones_tipo.md_MM1_observaciones AS md_MM1_observaciones,
md_configuraciones_tipo.md_MM1_observaciones_EN AS md_MM1_observaciones_EN,
md_configuraciones_tipo.md_MM2_nombre AS md_MM2_nombre,
md_configuraciones_tipo.md_MM2_nombre_EN AS md_MM2_nombre_EN,
md_configuraciones_tipo.md_MM2_PR_comida AS md_MM2_PR_comida,
md_configuraciones_tipo.md_MM2_PR_cena AS md_MM2_PR_cena,
md_configuraciones_tipo.md_MM2_PR_jornada AS md_MM2_PR_jornada,
md_configuraciones_tipo.md_MM2_observaciones AS md_MM2_observaciones,
md_configuraciones_tipo.md_MM2_observaciones_EN AS md_MM2_observaciones_EN,
md_configuraciones_tipo.acronimos_tipologia AS acronimos_tipologia,
md_configuraciones_tipo.md_cat1 AS md_cat1,
md_configuraciones_tipo.md_cat2 AS md_cat2,
md_configuraciones_tipo.md_cat3 AS md_cat3,
md_configuraciones_tipo.md_cat4 AS md_cat4,
md_configuraciones_tipo.md_cat5 AS md_cat5,
md_configuraciones_tipo.md_cat6 AS md_cat6,
CASE WHEN md_configuraciones_tipo.md_cat1 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat1
LIMIT 1
)
END AS md_nom_cat1,
CASE WHEN md_configuraciones_tipo.md_cat2 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat2
LIMIT 1
)
END AS md_nom_cat2,
CASE WHEN md_configuraciones_tipo.md_cat3 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat3
LIMIT 1
)
END AS md_nom_cat3,
CASE WHEN md_configuraciones_tipo.md_cat4 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat4
LIMIT 1
)
END AS md_nom_cat4,
CASE WHEN md_configuraciones_tipo.md_cat5 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat5
LIMIT 1
)
END AS md_nom_cat5,
CASE WHEN md_configuraciones_tipo.md_cat6 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat6
LIMIT 1
)
END AS md_nom_cat6,
'Y' AS md_nom_platos,
'Y' AS md_nom_platos_cat1,
'Y' AS md_nom_platos_cat2,
'Y' AS md_nom_platos_cat3,
'Y' AS md_nom_platos_cat4,
'Y' AS md_nom_platos_cat5,
'Y' AS md_nom_platos_cat6,
CASE WHEN md_configuraciones_tipo.md_cat1 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria_EN
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat1
LIMIT 1
)
END AS md_nom_cat1_EN,
CASE WHEN md_configuraciones_tipo.md_cat2 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria_EN
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat2
LIMIT 1
)
END AS md_nom_cat2_EN,
CASE WHEN md_configuraciones_tipo.md_cat3 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria_EN
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat3
LIMIT 1
)
END AS md_nom_cat3_EN,
CASE WHEN md_configuraciones_tipo.md_cat4 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria_EN
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat4
LIMIT 1
)
END AS md_nom_cat4_EN,
CASE WHEN md_configuraciones_tipo.md_cat5 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria_EN
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat5
LIMIT 1
)
END AS md_nom_cat5_EN,
CASE WHEN md_configuraciones_tipo.md_cat6 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria_EN
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat6
LIMIT 1
)
END AS md_nom_cat6_EN,
'Y' AS md_nom_platos_cat1_EN,
'Y' AS md_nom_platos_cat2_EN,
'Y' AS md_nom_platos_cat3_EN,
'Y' AS md_nom_platos_cat4_EN,
'Y' AS md_nom_platos_cat5_EN,
'Y' AS md_nom_platos_cat6_EN,
'0' AS md_menus_especiales
FROM md_asignaciones_defecto
JOIN md_configuraciones_tipo
ON md_configuraciones_tipo.id_md_config_tipo = md_asignaciones_defecto.id_md_config_tipo
WHERE md_asignaciones_defecto.ID_establecimiento IN (1517)
AND md_asignaciones_defecto.ID_establecimiento NOTIN (1517,1517)
AND md_asignaciones_defecto.dia='SA' ANDNOT FIND_IN_SET('MDDG', IFNULL(acronimos_tipologia, ''))
)
SELECT `establecimientos_ambientes`.`ID_ambiente`
FROM `establecimientos_ambientes`
LEFTJOIN `ambientes` ON `ambientes`.`ID_ambiente` = `establecimientos_ambientes`.`ID_ambiente`
WHERE `establecimientos_ambientes`.`ID_establecimiento` = '1508'
SELECT `establecimientos_tipo_negocio`.`ID_tipo_negocio`
FROM `establecimientos_tipo_negocio`
LEFTJOIN `tipos_negocio` ON `tipos_negocio`.`ID_tipo_negocio` = `establecimientos_tipo_negocio`.`ID_tipo_negocio`
WHERE `establecimientos_tipo_negocio`.`ID_establecimiento` = '1508'
SELECT `establecimientos_caracteristicas`.`ID_caracteristicas`
FROM `establecimientos_caracteristicas`
LEFTJOIN `caracteristicas` ON `caracteristicas`.`ID_caracteristicas` = `establecimientos_caracteristicas`.`ID_caracteristicas`
WHERE `establecimientos_caracteristicas`.`ID_establecimiento` = '1508'
SELECT `establecimientos_tipo_elaboracion`.`ID_tipo_elaboracion`
FROM `establecimientos_tipo_elaboracion`
LEFTJOIN `tipo_cocina_elaboracion` ON `tipo_cocina_elaboracion`.`ID_tipo_elaboracion` = `establecimientos_tipo_elaboracion`.`ID_tipo_elaboracion`
WHERE `establecimientos_tipo_elaboracion`.`ID_establecimiento` = '1508'
SELECT `establecimientos_tipo_origen`.`ID_tipo_origen`
FROM `establecimientos_tipo_origen`
LEFTJOIN `tipo_cocina_origen` ON `tipo_cocina_origen`.`ID_tipo_origen` = `establecimientos_tipo_origen`.`ID_tipo_origen`
WHERE `establecimientos_tipo_origen`.`ID_establecimiento` = '1508'
SELECT `establecimientos_tarjetas`.`ID_tarjeta`
FROM `establecimientos_tarjetas`
LEFTJOIN `tarjetas_credito` ON `tarjetas_credito`.`ID_tarjeta` = `establecimientos_tarjetas`.`ID_tarjeta`
WHERE `establecimientos_tarjetas`.`ID_establecimiento` = '1508'
SELECT `establecimientos_cheques`.`ID_cheque`
FROM `establecimientos_cheques`
LEFTJOIN `cheques_restaurante` ON `cheques_restaurante`.`ID_cheque` = `establecimientos_cheques`.`ID_cheque`
WHERE `establecimientos_cheques`.`ID_establecimiento` = '1508'
SELECT `establecimientos_guias`.`ID_guia`
FROM `establecimientos_guias`
LEFTJOIN `guias` ON `guias`.`ID_guia` = `establecimientos_guias`.`ID_guia`
WHERE `establecimientos_guias`.`ID_establecimiento` = '1508'
SELECT `establecimientos_calidad`.`ID_sistema`
FROM `establecimientos_calidad`
LEFTJOIN `sistemas_calidad` ON `sistemas_calidad`.`ID_sistema` = `establecimientos_calidad`.`ID_sistema`
WHERE `establecimientos_calidad`.`ID_establecimiento` = '1508'
SELECT `establecimientos_idioma`.`ID_idioma`
FROM `establecimientos_idioma`
LEFTJOIN `idiomas` ON `idiomas`.`ID_idioma` = `establecimientos_idioma`.`ID_idioma`
WHERE `establecimientos_idioma`.`ID_establecimiento` = '1508'
SELECT `SA_apertura` AS `apertura`, `SA_H1_ini` AS `H1ini`, `SA_H1_fin` AS `H1fin`, `SA_H2_ini` AS `H2ini`, `SA_H2_fin` AS `H2fin`, `SA_HC_ini` AS `HCini`, `SA_HC_fin` AS `HCfin`
FROM `establecimientos_horarios_habituales`
WHERE `ID_establecimiento` = '1508'
(SELECT 1 AS tipo,
md_diario.ID_establecimiento AS ID_establecimiento,
md_diario.id_md_diario AS id_md_diario,
md_diario.md_fecha AS md_fecha,
'X' AS md_fecha_LU,
'X' AS md_fecha_MA,
'X' AS md_fecha_MI,
'X' AS md_fecha_JU,
'X' AS md_fecha_VI,
'X' AS md_fecha_SA,
'X' AS md_fecha_DO,
-- resto de columnas menús diarios
md_diario.md_nombre AS md_nombre,
md_diario.md_nombre_EN AS md_nombre_EN,
md_diario.md_servicio AS md_servicio,
md_diario.md_PR_comida AS md_PR_comida,
md_diario.md_PR_cena AS md_PR_cena,
md_diario.md_PR_jornada AS md_PR_jornada,
md_diario.md_LL_servicio AS md_LL_servicio,
md_diario.md_MM1_servicio AS md_MM1_servicio,
md_diario.md_MM2_servicio AS md_MM2_servicio,
md_diario.md_tipo_cat AS md_tipo_cat,
md_diario.md_platos_cat1 AS md_platos_cat1,
md_diario.md_platos_cat2 AS md_platos_cat2,
md_diario.md_platos_cat3 AS md_platos_cat3,
md_diario.md_platos_cat4 AS md_platos_cat4,
md_diario.md_platos_cat5 AS md_platos_cat5,
md_diario.md_platos_cat6 AS md_platos_cat6,
md_diario.md_observaciones AS md_observaciones,
md_diario.md_observaciones_EN AS md_observaciones_EN,
md_diario.md_LL_nombre AS md_LL_nombre,
md_diario.md_LL_nombre_EN AS md_LL_nombre_EN,
md_diario.md_LL_PR_comida AS md_LL_PR_comida,
md_diario.md_LL_PR_cena AS md_LL_PR_cena,
md_diario.md_LL_PR_jornada AS md_LL_PR_jornada,
md_diario.md_LL_observaciones AS md_LL_observaciones,
md_diario.md_LL_observaciones_EN AS md_LL_observaciones_EN,
md_diario.md_MM1_nombre AS md_MM1_nombre,
md_diario.md_MM1_nombre_EN AS md_MM1_nombre_EN,
md_diario.md_MM1_PR_comida AS md_MM1_PR_comida,
md_diario.md_MM1_PR_cena AS md_MM1_PR_cena,
md_diario.md_MM1_PR_jornada AS md_MM1_PR_jornada,
md_diario.md_MM1_observaciones AS md_MM1_observaciones,
md_diario.md_MM1_observaciones_EN AS md_MM1_observaciones_EN,
md_diario.md_MM2_nombre AS md_MM2_nombre,
md_diario.md_MM2_nombre_EN AS md_MM2_nombre_EN,
md_diario.md_MM2_PR_comida AS md_MM2_PR_comida,
md_diario.md_MM2_PR_cena AS md_MM2_PR_cena,
md_diario.md_MM2_PR_jornada AS md_MM2_PR_jornada,
md_diario.md_MM2_observaciones AS md_MM2_observaciones,
md_diario.md_MM2_observaciones_EN AS md_MM2_observaciones_EN,
md_diario.acronimos_tipologia AS acronimos_tipologia,
md_diario.md_cat1 AS md_cat1,
md_diario.md_cat2 AS md_cat2,
md_diario.md_cat3 AS md_cat3,
md_diario.md_cat4 AS md_cat4,
md_diario.md_cat5 AS md_cat5,
md_diario.md_cat6 AS md_cat6,
md_diario.md_nom_cat1 AS md_nom_cat1,
md_diario.md_nom_cat2 AS md_nom_cat2,
md_diario.md_nom_cat3 AS md_nom_cat3,
md_diario.md_nom_cat4 AS md_nom_cat4,
md_diario.md_nom_cat5 AS md_nom_cat5,
md_diario.md_nom_cat6 AS md_nom_cat6,
md_diario.md_nom_platos AS md_nom_platos,
md_diario.md_nom_platos_cat1 AS md_nom_platos_cat1,
md_diario.md_nom_platos_cat2 AS md_nom_platos_cat2,
md_diario.md_nom_platos_cat3 AS md_nom_platos_cat3,
md_diario.md_nom_platos_cat4 AS md_nom_platos_cat4,
md_diario.md_nom_platos_cat5 AS md_nom_platos_cat5,
md_diario.md_nom_platos_cat6 AS md_nom_platos_cat6,
md_diario.md_nom_cat1_EN AS md_nom_cat1_EN,
md_diario.md_nom_cat2_EN AS md_nom_cat2_EN,
md_diario.md_nom_cat3_EN AS md_nom_cat3_EN,
md_diario.md_nom_cat4_EN AS md_nom_cat4_EN,
md_diario.md_nom_cat5_EN AS md_nom_cat5_EN,
md_diario.md_nom_cat6_EN AS md_nom_cat6_EN,
md_diario.md_nom_platos_cat1_EN AS md_nom_platos_cat1_EN,
md_diario.md_nom_platos_cat2_EN AS md_nom_platos_cat2_EN,
md_diario.md_nom_platos_cat3_EN AS md_nom_platos_cat3_EN,
md_diario.md_nom_platos_cat4_EN AS md_nom_platos_cat4_EN,
md_diario.md_nom_platos_cat5_EN AS md_nom_platos_cat5_EN,
md_diario.md_nom_platos_cat6_EN AS md_nom_platos_cat6_EN,
md_diario.md_menus_especiales AS md_menus_especiales
FROM md_diario
WHERE ID_establecimiento IN (1508)
AND md_fecha = '2025-04-05' ANDNOT FIND_IN_SET('MDDG', IFNULL(acronimos_tipologia, ''))
)
UNION
(SELECT 2 AS tipo,
md_diario_habituales.ID_establecimiento AS ID_establecimiento,
md_diario_habituales.id_md_diario AS id_md_diario,
'2025-04-05' AS md_fecha,
md_diario_habituales.md_fecha_LU AS md_fecha_LU,
md_diario_habituales.md_fecha_MA AS md_fecha_MA,
md_diario_habituales.md_fecha_MI AS md_fecha_MI,
md_diario_habituales.md_fecha_JU AS md_fecha_JU,
md_diario_habituales.md_fecha_VI AS md_fecha_VI,
md_diario_habituales.md_fecha_SA AS md_fecha_SA,
md_diario_habituales.md_fecha_DO AS md_fecha_DO,
-- resto de columnas
md_diario_habituales.md_nombre AS md_nombre,
md_diario_habituales.md_nombre_EN AS md_nombre_EN,
md_diario_habituales.md_servicio AS md_servicio,
md_diario_habituales.md_PR_comida AS md_PR_comida,
md_diario_habituales.md_PR_cena AS md_PR_cena,
md_diario_habituales.md_PR_jornada AS md_PR_jornada,
md_diario_habituales.md_LL_servicio AS md_LL_servicio,
md_diario_habituales.md_MM1_servicio AS md_MM1_servicio,
md_diario_habituales.md_MM2_servicio AS md_MM2_servicio,
md_diario_habituales.md_tipo_cat AS md_tipo_cat,
md_diario_habituales.md_platos_cat1 AS md_platos_cat1,
md_diario_habituales.md_platos_cat2 AS md_platos_cat2,
md_diario_habituales.md_platos_cat3 AS md_platos_cat3,
md_diario_habituales.md_platos_cat4 AS md_platos_cat4,
md_diario_habituales.md_platos_cat5 AS md_platos_cat5,
md_diario_habituales.md_platos_cat6 AS md_platos_cat6,
md_diario_habituales.md_observaciones AS md_observaciones,
md_diario_habituales.md_observaciones_EN AS md_observaciones_EN,
md_diario_habituales.md_LL_nombre AS md_LL_nombre,
md_diario_habituales.md_LL_nombre_EN AS md_LL_nombre_EN,
md_diario_habituales.md_LL_PR_comida AS md_LL_PR_comida,
md_diario_habituales.md_LL_PR_cena AS md_LL_PR_cena,
md_diario_habituales.md_LL_PR_jornada AS md_LL_PR_jornada,
md_diario_habituales.md_LL_observaciones AS md_LL_observaciones,
md_diario_habituales.md_LL_observaciones_EN AS md_LL_observaciones_EN,
md_diario_habituales.md_MM1_nombre AS md_MM1_nombre,
md_diario_habituales.md_MM1_nombre_EN AS md_MM1_nombre_EN,
md_diario_habituales.md_MM1_PR_comida AS md_MM1_PR_comida,
md_diario_habituales.md_MM1_PR_cena AS md_MM1_PR_cena,
md_diario_habituales.md_MM1_PR_jornada AS md_MM1_PR_jornada,
md_diario_habituales.md_MM1_observaciones AS md_MM1_observaciones,
md_diario_habituales.md_MM1_observaciones_EN AS md_MM1_observaciones_EN,
md_diario_habituales.md_MM2_nombre AS md_MM2_nombre,
md_diario_habituales.md_MM2_nombre_EN AS md_MM2_nombre_EN,
md_diario_habituales.md_MM2_PR_comida AS md_MM2_PR_comida,
md_diario_habituales.md_MM2_PR_cena AS md_MM2_PR_cena,
md_diario_habituales.md_MM2_PR_jornada AS md_MM2_PR_jornada,
md_diario_habituales.md_MM2_observaciones AS md_MM2_observaciones,
md_diario_habituales.md_MM2_observaciones_EN AS md_MM2_observaciones_EN,
md_diario_habituales.acronimos_tipologia AS acronimos_tipologia,
md_diario_habituales.md_cat1 AS md_cat1,
md_diario_habituales.md_cat2 AS md_cat2,
md_diario_habituales.md_cat3 AS md_cat3,
md_diario_habituales.md_cat4 AS md_cat4,
md_diario_habituales.md_cat5 AS md_cat5,
md_diario_habituales.md_cat6 AS md_cat6,
md_diario_habituales.md_nom_cat1 AS md_nom_cat1,
md_diario_habituales.md_nom_cat2 AS md_nom_cat2,
md_diario_habituales.md_nom_cat3 AS md_nom_cat3,
md_diario_habituales.md_nom_cat4 AS md_nom_cat4,
md_diario_habituales.md_nom_cat5 AS md_nom_cat5,
md_diario_habituales.md_nom_cat6 AS md_nom_cat6,
md_diario_habituales.md_nom_platos AS md_nom_platos,
md_diario_habituales.md_nom_platos_cat1 AS md_nom_platos_cat1,
md_diario_habituales.md_nom_platos_cat2 AS md_nom_platos_cat2,
md_diario_habituales.md_nom_platos_cat3 AS md_nom_platos_cat3,
md_diario_habituales.md_nom_platos_cat4 AS md_nom_platos_cat4,
md_diario_habituales.md_nom_platos_cat5 AS md_nom_platos_cat5,
md_diario_habituales.md_nom_platos_cat6 AS md_nom_platos_cat6,
md_diario_habituales.md_nom_cat1_EN AS md_nom_cat1,
md_diario_habituales.md_nom_cat2_EN AS md_nom_cat2,
md_diario_habituales.md_nom_cat3_EN AS md_nom_cat3,
md_diario_habituales.md_nom_cat4_EN AS md_nom_cat4,
md_diario_habituales.md_nom_cat5_EN AS md_nom_cat5,
md_diario_habituales.md_nom_cat6_EN AS md_nom_cat6,
md_diario_habituales.md_nom_platos_cat1_EN AS md_nom_platos_cat1_EN,
md_diario_habituales.md_nom_platos_cat2_EN AS md_nom_platos_cat2_EN,
md_diario_habituales.md_nom_platos_cat3_EN AS md_nom_platos_cat3_EN,
md_diario_habituales.md_nom_platos_cat4_EN AS md_nom_platos_cat4_EN,
md_diario_habituales.md_nom_platos_cat5_EN AS md_nom_platos_cat5_EN,
md_diario_habituales.md_nom_platos_cat6_EN AS md_nom_platos_cat6_EN,
md_diario_habituales.md_menus_especiales AS md_menus_especiales
FROM md_diario_habituales
WHERE id_md_diario IN (748,749)
AND md_estado = 1 ANDNOT FIND_IN_SET('MDDG', IFNULL(acronimos_tipologia, ''))
)
UNION
(SELECT 3 AS tipo,
md_asignaciones_defecto.ID_establecimiento AS ID_establecimiento,
md_asignaciones_defecto.id AS id_md_diario,
'2025-04-05' AS md_fecha,
'X' AS md_fecha_LU,
'X' AS md_fecha_MA,
'X' AS md_fecha_MI,
'X' AS md_fecha_JU,
'X' AS md_fecha_VI,
'X' AS md_fecha_SA,
'X' AS md_fecha_DO,
md_configuraciones_tipo.md_nombre AS md_nombre,
md_configuraciones_tipo.md_nombre_EN AS md_nombre_EN,
md_configuraciones_tipo.md_servicio AS md_servicio,
md_configuraciones_tipo.md_PR_comida AS md_PR_comida,
md_configuraciones_tipo.md_PR_cena AS md_PR_cena,
md_configuraciones_tipo.md_PR_jornada AS md_PR_jornada,
md_configuraciones_tipo.md_LL_servicio AS md_LL_servicio,
md_configuraciones_tipo.md_MM1_servicio AS md_MM1_servicio,
md_configuraciones_tipo.md_MM2_servicio AS md_MM2_servicio,
'1' AS md_tipo_cat,
'Y' AS md_platos_cat1,
'Y' AS md_platos_cat2,
'Y' AS md_platos_cat3,
'Y' AS md_platos_cat4,
'Y' AS md_platos_cat5,
'Y' AS md_platos_cat6,
md_configuraciones_tipo.md_observaciones AS md_observaciones,
md_configuraciones_tipo.md_observaciones_EN AS md_observaciones_EN,
md_configuraciones_tipo.md_LL_nombre AS md_LL_nombre,
md_configuraciones_tipo.md_LL_nombre_EN AS md_LL_nombre_EN,
md_configuraciones_tipo.md_LL_PR_comida AS md_LL_PR_comida,
md_configuraciones_tipo.md_LL_PR_cena AS md_LL_PR_cena,
md_configuraciones_tipo.md_LL_PR_jornada AS md_LL_PR_jornada,
md_configuraciones_tipo.md_LL_observaciones AS md_LL_observaciones,
md_configuraciones_tipo.md_LL_observaciones_EN AS md_LL_observaciones_EN,
md_configuraciones_tipo.md_MM1_nombre AS md_MM1_nombre,
md_configuraciones_tipo.md_MM1_nombre_EN AS md_MM1_nombre_EN,
md_configuraciones_tipo.md_MM1_PR_comida AS md_MM1_PR_comida,
md_configuraciones_tipo.md_MM1_PR_cena AS md_MM1_PR_cena,
md_configuraciones_tipo.md_MM1_PR_jornada AS md_MM1_PR_jornada,
md_configuraciones_tipo.md_MM1_observaciones AS md_MM1_observaciones,
md_configuraciones_tipo.md_MM1_observaciones_EN AS md_MM1_observaciones_EN,
md_configuraciones_tipo.md_MM2_nombre AS md_MM2_nombre,
md_configuraciones_tipo.md_MM2_nombre_EN AS md_MM2_nombre_EN,
md_configuraciones_tipo.md_MM2_PR_comida AS md_MM2_PR_comida,
md_configuraciones_tipo.md_MM2_PR_cena AS md_MM2_PR_cena,
md_configuraciones_tipo.md_MM2_PR_jornada AS md_MM2_PR_jornada,
md_configuraciones_tipo.md_MM2_observaciones AS md_MM2_observaciones,
md_configuraciones_tipo.md_MM2_observaciones_EN AS md_MM2_observaciones_EN,
md_configuraciones_tipo.acronimos_tipologia AS acronimos_tipologia,
md_configuraciones_tipo.md_cat1 AS md_cat1,
md_configuraciones_tipo.md_cat2 AS md_cat2,
md_configuraciones_tipo.md_cat3 AS md_cat3,
md_configuraciones_tipo.md_cat4 AS md_cat4,
md_configuraciones_tipo.md_cat5 AS md_cat5,
md_configuraciones_tipo.md_cat6 AS md_cat6,
CASE WHEN md_configuraciones_tipo.md_cat1 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat1
LIMIT 1
)
END AS md_nom_cat1,
CASE WHEN md_configuraciones_tipo.md_cat2 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat2
LIMIT 1
)
END AS md_nom_cat2,
CASE WHEN md_configuraciones_tipo.md_cat3 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat3
LIMIT 1
)
END AS md_nom_cat3,
CASE WHEN md_configuraciones_tipo.md_cat4 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat4
LIMIT 1
)
END AS md_nom_cat4,
CASE WHEN md_configuraciones_tipo.md_cat5 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat5
LIMIT 1
)
END AS md_nom_cat5,
CASE WHEN md_configuraciones_tipo.md_cat6 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat6
LIMIT 1
)
END AS md_nom_cat6,
'Y' AS md_nom_platos,
'Y' AS md_nom_platos_cat1,
'Y' AS md_nom_platos_cat2,
'Y' AS md_nom_platos_cat3,
'Y' AS md_nom_platos_cat4,
'Y' AS md_nom_platos_cat5,
'Y' AS md_nom_platos_cat6,
CASE WHEN md_configuraciones_tipo.md_cat1 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria_EN
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat1
LIMIT 1
)
END AS md_nom_cat1_EN,
CASE WHEN md_configuraciones_tipo.md_cat2 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria_EN
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat2
LIMIT 1
)
END AS md_nom_cat2_EN,
CASE WHEN md_configuraciones_tipo.md_cat3 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria_EN
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat3
LIMIT 1
)
END AS md_nom_cat3_EN,
CASE WHEN md_configuraciones_tipo.md_cat4 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria_EN
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat4
LIMIT 1
)
END AS md_nom_cat4_EN,
CASE WHEN md_configuraciones_tipo.md_cat5 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria_EN
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat5
LIMIT 1
)
END AS md_nom_cat5_EN,
CASE WHEN md_configuraciones_tipo.md_cat6 = 0 THEN ''
ELSE (
SELECT cat.nombre_md_categoria_EN
FROM md_categorias cat
WHERE cat.id_md_categoria = md_configuraciones_tipo.md_cat6
LIMIT 1
)
END AS md_nom_cat6_EN,
'Y' AS md_nom_platos_cat1_EN,
'Y' AS md_nom_platos_cat2_EN,
'Y' AS md_nom_platos_cat3_EN,
'Y' AS md_nom_platos_cat4_EN,
'Y' AS md_nom_platos_cat5_EN,
'Y' AS md_nom_platos_cat6_EN,
'0' AS md_menus_especiales
FROM md_asignaciones_defecto
JOIN md_configuraciones_tipo
ON md_configuraciones_tipo.id_md_config_tipo = md_asignaciones_defecto.id_md_config_tipo
WHERE md_asignaciones_defecto.ID_establecimiento IN (1508)
AND md_asignaciones_defecto.ID_establecimiento NOTIN (1508,1508)
AND md_asignaciones_defecto.dia='SA' ANDNOT FIND_IN_SET('MDDG', IFNULL(acronimos_tipologia, ''))
)
md_observaciones => UTF-8 string (60) "Incluye pan, bebida (agua o vino o cerveza) y postre o café"
$value[0]['md_observaciones']
md_observaciones_EN => string (69) "It includes food, drink (water or wine or beer) and dessert or coffee"
$value[0]['md_observaciones_EN']
md_LL_nombre => string (0) ""
$value[0]['md_LL_nombre']
md_LL_nombre_EN => string (63) "NO QUERY SPECIFIED. EXAMPLE REQUEST: GET?Q=HELLO&LANGPAIR=EN|IT"
$value[0]['md_LL_nombre_EN']
md_LL_PR_comida => string (4) "0.00"
$value[0]['md_LL_PR_comida']
md_LL_PR_cena => string (4) "0.00"
$value[0]['md_LL_PR_cena']
md_LL_PR_jornada => string (4) "0.00"
$value[0]['md_LL_PR_jornada']
md_LL_observaciones => string (0) ""
$value[0]['md_LL_observaciones']
md_LL_observaciones_EN => string (63) "NO QUERY SPECIFIED. EXAMPLE REQUEST: GET?Q=HELLO&LANGPAIR=EN|IT"
$value[0]['md_LL_observaciones_EN']
md_MM1_nombre => string (0) ""
$value[0]['md_MM1_nombre']
md_MM1_nombre_EN => string (63) "NO QUERY SPECIFIED. EXAMPLE REQUEST: GET?Q=HELLO&LANGPAIR=EN|IT"
$value[0]['md_MM1_nombre_EN']
md_MM1_PR_comida => string (4) "0.00"
$value[0]['md_MM1_PR_comida']
md_MM1_PR_cena => string (4) "0.00"
$value[0]['md_MM1_PR_cena']
md_MM1_PR_jornada => string (4) "0.00"
$value[0]['md_MM1_PR_jornada']
md_MM1_observaciones => string (0) ""
$value[0]['md_MM1_observaciones']
md_MM1_observaciones_EN => string (63) "NO QUERY SPECIFIED. EXAMPLE REQUEST: GET?Q=HELLO&LANGPAIR=EN|IT"
$value[0]['md_MM1_observaciones_EN']
md_MM2_nombre => string (0) ""
$value[0]['md_MM2_nombre']
md_MM2_nombre_EN => string (63) "NO QUERY SPECIFIED. EXAMPLE REQUEST: GET?Q=HELLO&LANGPAIR=EN|IT"
$value[0]['md_MM2_nombre_EN']
md_MM2_PR_comida => string (4) "0.00"
$value[0]['md_MM2_PR_comida']
md_MM2_PR_cena => string (4) "0.00"
$value[0]['md_MM2_PR_cena']
md_MM2_PR_jornada => string (4) "0.00"
$value[0]['md_MM2_PR_jornada']
md_MM2_observaciones => string (0) ""
$value[0]['md_MM2_observaciones']
md_MM2_observaciones_EN => string (63) "NO QUERY SPECIFIED. EXAMPLE REQUEST: GET?Q=HELLO&LANGPAIR=EN|IT"
$value[0]['md_MM2_observaciones_EN']
acronimos_tipologia => string (4) "MDDI"
$value[0]['acronimos_tipologia']
md_cat1 => string (4) "1037"
$value[0]['md_cat1']
md_cat2 => string (4) "1038"
$value[0]['md_cat2']
md_cat3 => string (1) "0"
$value[0]['md_cat3']
md_cat4 => string (1) "0"
$value[0]['md_cat4']
md_cat5 => string (1) "0"
$value[0]['md_cat5']
md_cat6 => string (1) "0"
$value[0]['md_cat6']
md_nom_cat1 => string (15) "Primeros platos"
$value[0]['md_nom_cat1']
md_nom_cat2 => string (15) "Segundos platos"
$value[0]['md_nom_cat2']
md_nom_cat3 => string (1) "0"
$value[0]['md_nom_cat3']
md_nom_cat4 => string (1) "0"
$value[0]['md_nom_cat4']
md_nom_cat5 => string (1) "0"
$value[0]['md_nom_cat5']
md_nom_cat6 => string (1) "0"
$value[0]['md_nom_cat6']
md_nom_platos => UTF-8 string (339) "Berenjena al horno con setas y champiñón||Carrilleras ibéricas al Pedro Ximé...
$value[0]['md_nom_platos']
Berenjena al horno con setas y champiñón||Carrilleras ibéricas al Pedro Ximénez||Falafel con salsa de tzatziki||Filete de ternera a la plancha con patatas||Lasagna vegetal||Lubina a la espalda con ensalada||Moussaka (con carne)||Pechugas empanadas al roquefort||Salmón en papillote con mostaza||Solomillo ibérico con salsa de mostaza
md_nom_platos_cat1 => UTF-8 string (515) "Arroz negro con calamar y langostinos||Crema de calabaza con pipas de calaba...
$value[0]['md_nom_platos_cat1']
Arroz negro con calamar y langostinos||Crema de calabaza con pipas de calabaza||Ensalada de canónigos, rulo de cabra caramelizado, tomate y aceitunas||Ensalada de lechuga, manzana, variedad de quesos, módena y miel||Hojaldre de pollo con verduras acompañado de ensalada||Pastel de calabacín y zanahoria con salsa de reineta||Patatas meneadas con torreznos||Pimientos del piquillo rellenos de espinacas y almendra caramelizada||Tallarines con boletus y cebolla caramelizada (opción con tomate frito y parmesano)
md_nom_platos_cat2 => UTF-8 string (339) "Berenjena al horno con setas y champiñón||Carrilleras ibéricas al Pedro Ximé...
$value[0]['md_nom_platos_cat2']
Berenjena al horno con setas y champiñón||Carrilleras ibéricas al Pedro Ximénez||Falafel con salsa de tzatziki||Filete de ternera a la plancha con patatas||Lasagna vegetal||Lubina a la espalda con ensalada||Moussaka (con carne)||Pechugas empanadas al roquefort||Salmón en papillote con mostaza||Solomillo ibérico con salsa de mostaza
md_nom_platos_cat3 => string (0) ""
$value[0]['md_nom_platos_cat3']
md_nom_platos_cat4 => string (0) ""
$value[0]['md_nom_platos_cat4']
md_nom_platos_cat5 => string (0) ""
$value[0]['md_nom_platos_cat5']
md_nom_platos_cat6 => string (0) ""
$value[0]['md_nom_platos_cat6']
md_nom_cat1_EN => string (8) "Starters"
$value[0]['md_nom_cat1_EN']
md_nom_cat2_EN => string (14) "Second courses"
$value[0]['md_nom_cat2_EN']
md_nom_cat3_EN => string (1) "0"
$value[0]['md_nom_cat3_EN']
md_nom_cat4_EN => string (1) "0"
$value[0]['md_nom_cat4_EN']
md_nom_cat5_EN => string (1) "0"
$value[0]['md_nom_cat5_EN']
md_nom_cat6_EN => string (1) "0"
$value[0]['md_nom_cat6_EN']
md_nom_platos_cat1_EN => string (451) "Black rice with squid and prawns||Cream of pumpkin soup with pumpkin seeds||...
$value[0]['md_nom_platos_cat1_EN']
Black rice with squid and prawns||Cream of pumpkin soup with pumpkin seeds||Lettuce salad, caramelized goat roller, tomatoes and olives||Lettuce, apple, assorted cheeses, balsamic and honey||Pastry chicken with vegetables with salad||Zucchini and carrot cake with sauce pomfret||Shakeds potatoes with bacon||Peppers stuffed with spinach and caramelized almonds||Noodles with mushrooms and caramelized onions (optional with fried tomatoes and parmesan)
Baked Eggplant with porcini mushrooms||Pedro Ximenez Iberian Cheeks||Falafel with tzatziki sauce||Grilled fillet of beef||Vegetable Lasagna||Sea bass back with salad||Moussaka (meat)||Breaded chicken breasts with blue cheese||Salmon en papillote with mustard||Iberian sirloin with mustard sauce
Nuestro local se compone de varias zonas, a diferentes alturas y con dos accesos desde la calle. En la amplia barra mostramos toda la variedad de pinchos y tapas, y el dulce y vistoso escaparate de las tartas. A nivel de la calle tenemos varias espacios cómodos de mesas y sillas, decoradas a nuestro estilo y con obras de arte como el árbol de la entrada principal. Para acceder a la zona más alta del local, hay que subir unas pequeñas escaleras de cuyo techo cuelga una de las lamparas más bonitas y que más llaman la atención.
Our local consists of several areas at different heights and with two entrances from the street. In the spacious bar shows the full range of snacks and tapas, and the sweet and colorful showcase of cakes.
At street level we have several comfortable spaces with tables and chairs, our style and decorated with artwork like the tree of the main entrance. To access the highest part of the room, you have to climb a small staircase from the ceiling hangs one of the most beautiful lamps and more attention.
md_observaciones => UTF-8 string (60) "Incluye pan, bebida (agua o vino o cerveza) y postre o café"
$value[1]['md_observaciones']
md_observaciones_EN => string (69) "It includes food, drink (water or wine or beer) and dessert or coffee"
$value[1]['md_observaciones_EN']
md_LL_nombre => string (0) ""
$value[1]['md_LL_nombre']
md_LL_nombre_EN => string (63) "NO QUERY SPECIFIED. EXAMPLE REQUEST: GET?Q=HELLO&LANGPAIR=EN|IT"
$value[1]['md_LL_nombre_EN']
md_LL_PR_comida => string (4) "0.00"
$value[1]['md_LL_PR_comida']
md_LL_PR_cena => string (4) "0.00"
$value[1]['md_LL_PR_cena']
md_LL_PR_jornada => string (4) "0.00"
$value[1]['md_LL_PR_jornada']
md_LL_observaciones => string (0) ""
$value[1]['md_LL_observaciones']
md_LL_observaciones_EN => string (63) "NO QUERY SPECIFIED. EXAMPLE REQUEST: GET?Q=HELLO&LANGPAIR=EN|IT"
$value[1]['md_LL_observaciones_EN']
md_MM1_nombre => string (0) ""
$value[1]['md_MM1_nombre']
md_MM1_nombre_EN => string (63) "NO QUERY SPECIFIED. EXAMPLE REQUEST: GET?Q=HELLO&LANGPAIR=EN|IT"
$value[1]['md_MM1_nombre_EN']
md_MM1_PR_comida => string (4) "0.00"
$value[1]['md_MM1_PR_comida']
md_MM1_PR_cena => string (4) "0.00"
$value[1]['md_MM1_PR_cena']
md_MM1_PR_jornada => string (4) "0.00"
$value[1]['md_MM1_PR_jornada']
md_MM1_observaciones => string (0) ""
$value[1]['md_MM1_observaciones']
md_MM1_observaciones_EN => string (63) "NO QUERY SPECIFIED. EXAMPLE REQUEST: GET?Q=HELLO&LANGPAIR=EN|IT"
$value[1]['md_MM1_observaciones_EN']
md_MM2_nombre => string (0) ""
$value[1]['md_MM2_nombre']
md_MM2_nombre_EN => string (63) "NO QUERY SPECIFIED. EXAMPLE REQUEST: GET?Q=HELLO&LANGPAIR=EN|IT"
$value[1]['md_MM2_nombre_EN']
md_MM2_PR_comida => string (4) "0.00"
$value[1]['md_MM2_PR_comida']
md_MM2_PR_cena => string (4) "0.00"
$value[1]['md_MM2_PR_cena']
md_MM2_PR_jornada => string (4) "0.00"
$value[1]['md_MM2_PR_jornada']
md_MM2_observaciones => string (0) ""
$value[1]['md_MM2_observaciones']
md_MM2_observaciones_EN => string (63) "NO QUERY SPECIFIED. EXAMPLE REQUEST: GET?Q=HELLO&LANGPAIR=EN|IT"
$value[1]['md_MM2_observaciones_EN']
acronimos_tipologia => string (4) "MDDI"
$value[1]['acronimos_tipologia']
md_cat1 => string (4) "1037"
$value[1]['md_cat1']
md_cat2 => string (4) "1038"
$value[1]['md_cat2']
md_cat3 => string (1) "0"
$value[1]['md_cat3']
md_cat4 => string (1) "0"
$value[1]['md_cat4']
md_cat5 => string (1) "0"
$value[1]['md_cat5']
md_cat6 => string (1) "0"
$value[1]['md_cat6']
md_nom_cat1 => string (15) "Primeros platos"
$value[1]['md_nom_cat1']
md_nom_cat2 => string (15) "Segundos platos"
$value[1]['md_nom_cat2']
md_nom_cat3 => string (1) "0"
$value[1]['md_nom_cat3']
md_nom_cat4 => string (1) "0"
$value[1]['md_nom_cat4']
md_nom_cat5 => string (1) "0"
$value[1]['md_nom_cat5']
md_nom_cat6 => string (1) "0"
$value[1]['md_nom_cat6']
md_nom_platos => UTF-8 string (90) "Berenjena al horno con setas y champiñón||Falafel con salsa de tzatziki||Las...
$value[1]['md_nom_platos']
Berenjena al horno con setas y champiñón||Falafel con salsa de tzatziki||Lasagna vegetal
md_nom_platos_cat1 => UTF-8 string (388) "Crema de calabaza con pipas de calabaza||Ensalada de canónigos, rulo de cabr...
$value[1]['md_nom_platos_cat1']
Crema de calabaza con pipas de calabaza||Ensalada de canónigos, rulo de cabra caramelizado, tomate y aceitunas||Ensalada de lechuga, manzana, variedad de quesos, módena y miel||Pastel de calabacín y zanahoria con salsa de reineta||Pimientos del piquillo rellenos de espinacas y almendra caramelizada||Tallarines con boletus y cebolla caramelizada (opción con tomate frito y parmesano)
md_nom_platos_cat2 => UTF-8 string (90) "Berenjena al horno con setas y champiñón||Falafel con salsa de tzatziki||Las...
$value[1]['md_nom_platos_cat2']
Berenjena al horno con setas y champiñón||Falafel con salsa de tzatziki||Lasagna vegetal
md_nom_platos_cat3 => string (0) ""
$value[1]['md_nom_platos_cat3']
md_nom_platos_cat4 => string (0) ""
$value[1]['md_nom_platos_cat4']
md_nom_platos_cat5 => string (0) ""
$value[1]['md_nom_platos_cat5']
md_nom_platos_cat6 => string (0) ""
$value[1]['md_nom_platos_cat6']
md_nom_cat1_EN => string (8) "Starters"
$value[1]['md_nom_cat1_EN']
md_nom_cat2_EN => string (14) "Second courses"
$value[1]['md_nom_cat2_EN']
md_nom_cat3_EN => string (1) "0"
$value[1]['md_nom_cat3_EN']
md_nom_cat4_EN => string (1) "0"
$value[1]['md_nom_cat4_EN']
md_nom_cat5_EN => string (1) "0"
$value[1]['md_nom_cat5_EN']
md_nom_cat6_EN => string (1) "0"
$value[1]['md_nom_cat6_EN']
md_nom_platos_cat1_EN => string (345) "Cream of pumpkin soup with pumpkin seeds||Lettuce salad, caramelized goat ro...
$value[1]['md_nom_platos_cat1_EN']
Cream of pumpkin soup with pumpkin seeds||Lettuce salad, caramelized goat roller, tomatoes and olives||Lettuce, apple, assorted cheeses, balsamic and honey||Zucchini and carrot cake with sauce pomfret||Peppers stuffed with spinach and caramelized almonds||Noodles with mushrooms and caramelized onions (optional with fried tomatoes and parmesan)
md_nom_platos_cat2_EN => string (85) "Baked Eggplant with porcini mushrooms||Falafel with tzatziki sauce||Vegetabl...
$value[1]['md_nom_platos_cat2_EN']
Baked Eggplant with porcini mushrooms||Falafel with tzatziki sauce||Vegetable Lasagna
Nuestro local se compone de varias zonas, a diferentes alturas y con dos accesos desde la calle. En la amplia barra mostramos toda la variedad de pinchos y tapas, y el dulce y vistoso escaparate de las tartas. A nivel de la calle tenemos varias espacios cómodos de mesas y sillas, decoradas a nuestro estilo y con obras de arte como el árbol de la entrada principal. Para acceder a la zona más alta del local, hay que subir unas pequeñas escaleras de cuyo techo cuelga una de las lamparas más bonitas y que más llaman la atención.
Our local consists of several areas at different heights and with two entrances from the street. In the spacious bar shows the full range of snacks and tapas, and the sweet and colorful showcase of cakes.
At street level we have several comfortable spaces with tables and chairs, our style and decorated with artwork like the tree of the main entrance. To access the highest part of the room, you have to climb a small staircase from the ceiling hangs one of the most beautiful lamps and more attention.
Tres son los pilares sobre los que estamos convencidos que debe asentarse nuestra cocina: producto, técnica y sentimiento. De la unión de estos vectores emana una línea de trabajo que se antoja cada día diferente y evolutiva.
Queremos sorprenderte con una experiencia única, avalada por la Estrella Michelín que mantenemos desde 2004, la más longeva de Castilla y León, y los dos Soles recientemente otorgados por la Guía Repsol.
Alma española, corazón peruano y matices del mundo para dar a conocer los sabores de tres continentes en un entorno privilegiado de la ciudad de Salamanca. Te esperamos en el nuevo espacio gastronómico que acoge el Restaurante Víctor Gutiérrez, frente al Palacio de Congresos y Exposiciones, a un cómodo paseo de la Plaza Mayor y muy cerca de las catedrales.
especialidades_establecimiento -> string (37) "Cocina de autor con sabores del mundo"
There are three pillars that we believe that should settle our kitchen: product, technical and sentiment. From the union of these vectors emanating a line of work that seems different and evolving every day.
We want to surprise you with a unique experience, backed by the Michelin Star we have had since 2004, the longest of Castilla and Leon, and both recently granted by the Repsol Guide Soles.
Spanish soul, heart and nuances Peruvian world to introduce the flavors of three continents in a privileged environment of the city of Salamanca. See you in the new space that houses the restaurant Victor Gutierrez, opposite the Palace of Congresses and Exhibitions, a comfortable walk from the Plaza Mayor and very close to the cathedral.
especialidades_establecimiento_EN -> string (33) "Cuisine with flavors of the world"
md_nombre_EN => string (30) "Menu Our Roots (a spicy story)"
$value[3]['md_nombre_EN']
md_servicio => string (1) "3"
$value[3]['md_servicio']
md_PR_comida => string (5) "80.00"
$value[3]['md_PR_comida']
md_PR_cena => string (5) "80.00"
$value[3]['md_PR_cena']
md_PR_jornada => string (4) "0.00"
$value[3]['md_PR_jornada']
md_LL_servicio => string (1) "0"
$value[3]['md_LL_servicio']
md_MM1_servicio => string (1) "0"
$value[3]['md_MM1_servicio']
md_MM2_servicio => string (1) "0"
$value[3]['md_MM2_servicio']
md_tipo_cat => string (1) "0"
$value[3]['md_tipo_cat']
md_platos_cat1 => string (0) ""
$value[3]['md_platos_cat1']
md_platos_cat2 => string (0) ""
$value[3]['md_platos_cat2']
md_platos_cat3 => string (0) ""
$value[3]['md_platos_cat3']
md_platos_cat4 => string (0) ""
$value[3]['md_platos_cat4']
md_platos_cat5 => string (0) ""
$value[3]['md_platos_cat5']
md_platos_cat6 => string (0) ""
$value[3]['md_platos_cat6']
md_observaciones => UTF-8 string (110) "Impuestos no incluidos. Este menú No se servirá después de las 15:00 horas, ...
$value[3]['md_observaciones']
Impuestos no incluidos.
Este menú No se servirá después de las 15:00 horas, ni después de las 22:00 horas.
md_observaciones_EN => string (71) "Taxes not included. This menu is not served after 15:00 or after 22:00."
$value[3]['md_observaciones_EN']
md_LL_nombre => string (0) ""
$value[3]['md_LL_nombre']
md_LL_nombre_EN => string (0) ""
$value[3]['md_LL_nombre_EN']
md_LL_PR_comida => string (4) "0.00"
$value[3]['md_LL_PR_comida']
md_LL_PR_cena => string (4) "0.00"
$value[3]['md_LL_PR_cena']
md_LL_PR_jornada => string (4) "0.00"
$value[3]['md_LL_PR_jornada']
md_LL_observaciones => string (0) ""
$value[3]['md_LL_observaciones']
md_LL_observaciones_EN => string (0) ""
$value[3]['md_LL_observaciones_EN']
md_MM1_nombre => string (0) ""
$value[3]['md_MM1_nombre']
md_MM1_nombre_EN => string (0) ""
$value[3]['md_MM1_nombre_EN']
md_MM1_PR_comida => string (4) "0.00"
$value[3]['md_MM1_PR_comida']
md_MM1_PR_cena => string (4) "0.00"
$value[3]['md_MM1_PR_cena']
md_MM1_PR_jornada => string (4) "0.00"
$value[3]['md_MM1_PR_jornada']
md_MM1_observaciones => string (0) ""
$value[3]['md_MM1_observaciones']
md_MM1_observaciones_EN => string (0) ""
$value[3]['md_MM1_observaciones_EN']
md_MM2_nombre => string (0) ""
$value[3]['md_MM2_nombre']
md_MM2_nombre_EN => string (0) ""
$value[3]['md_MM2_nombre_EN']
md_MM2_PR_comida => string (4) "0.00"
$value[3]['md_MM2_PR_comida']
md_MM2_PR_cena => string (4) "0.00"
$value[3]['md_MM2_PR_cena']
md_MM2_PR_jornada => string (4) "0.00"
$value[3]['md_MM2_PR_jornada']
md_MM2_observaciones => string (0) ""
$value[3]['md_MM2_observaciones']
md_MM2_observaciones_EN => string (0) ""
$value[3]['md_MM2_observaciones_EN']
acronimos_tipologia => string (4) "MDDE"
$value[3]['acronimos_tipologia']
md_cat1 => string (1) "0"
$value[3]['md_cat1']
md_cat2 => string (1) "0"
$value[3]['md_cat2']
md_cat3 => string (1) "0"
$value[3]['md_cat3']
md_cat4 => string (1) "0"
$value[3]['md_cat4']
md_cat5 => string (1) "0"
$value[3]['md_cat5']
md_cat6 => string (1) "0"
$value[3]['md_cat6']
md_nom_cat1 => string (0) ""
$value[3]['md_nom_cat1']
md_nom_cat2 => string (0) ""
$value[3]['md_nom_cat2']
md_nom_cat3 => string (0) ""
$value[3]['md_nom_cat3']
md_nom_cat4 => string (0) ""
$value[3]['md_nom_cat4']
md_nom_cat5 => string (0) ""
$value[3]['md_nom_cat5']
md_nom_cat6 => string (0) ""
$value[3]['md_nom_cat6']
md_nom_platos => UTF-8 string (176) "Tómese el tiempo que necesite para degustar un extenso recorrido compuesto d...
$value[3]['md_nom_platos']
Tómese el tiempo que necesite para degustar un extenso recorrido compuesto de dieciséis creaciones gastronómicas que le conducirán a través de una experiencia irrepetible.
Tres son los pilares sobre los que estamos convencidos que debe asentarse nuestra cocina: producto, técnica y sentimiento. De la unión de estos vectores emana una línea de trabajo que se antoja cada día diferente y evolutiva.
Queremos sorprenderte con una experiencia única, avalada por la Estrella Michelín que mantenemos desde 2004, la más longeva de Castilla y León, y los dos Soles recientemente otorgados por la Guía Repsol.
Alma española, corazón peruano y matices del mundo para dar a conocer los sabores de tres continentes en un entorno privilegiado de la ciudad de Salamanca. Te esperamos en el nuevo espacio gastronómico que acoge el Restaurante Víctor Gutiérrez, frente al Palacio de Congresos y Exposiciones, a un cómodo paseo de la Plaza Mayor y muy cerca de las catedrales.
especialidades_establecimiento -> string (37) "Cocina de autor con sabores del mundo"
There are three pillars that we believe that should settle our kitchen: product, technical and sentiment. From the union of these vectors emanating a line of work that seems different and evolving every day.
We want to surprise you with a unique experience, backed by the Michelin Star we have had since 2004, the longest of Castilla and Leon, and both recently granted by the Repsol Guide Soles.
Spanish soul, heart and nuances Peruvian world to introduce the flavors of three continents in a privileged environment of the city of Salamanca. See you in the new space that houses the restaurant Victor Gutierrez, opposite the Palace of Congresses and Exhibitions, a comfortable walk from the Plaza Mayor and very close to the cathedral.
especialidades_establecimiento_EN -> string (33) "Cuisine with flavors of the world"
public __construct(?string $uri = null) Constructor.
/**
* Constructor.
*
* @param string|null $uri The URI to parse.
*
* @throws HTTPException
*
* @TODO null for param $uri should be removed.
* See https://www.php-fig.org/psr/psr-17/#26-urifactoryinterface
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:256
public setSilent(bool $silent = true): URI If $silent == true, then will not throw exceptions and will attempt to contin...
/**
* If $silent == true, then will not throw exceptions and will
* attempt to continue gracefully.
*
* @deprecated 4.4.0 Method not in PSR-7
*
* @return URI
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:271
public useRawQueryString(bool $raw = true): URI If $raw == true, then will use parseStr() method instead of native parse_str(...
/**
* If $raw == true, then will use parseStr() method
* instead of native parse_str() function.
*
* Note: Method not in PSR-7
*
* @return URI
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:286
public setURI(?string $uri = null): URI Sets and overwrites any current URI information.
/**
* Sets and overwrites any current URI information.
*
* @return URI
*
* @throws HTTPException
*
* @deprecated 4.4.0 This method will be private.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:302
public getScheme(): string Retrieve the scheme component of the URI.
/**
* Retrieve the scheme component of the URI.
*
* If no scheme is present, this method MUST return an empty string.
*
* The value returned MUST be normalized to lowercase, per RFC 3986
* Section 3.1.
*
* The trailing ":" character is not part of the scheme and MUST NOT be
* added.
*
* @see https://tools.ietf.org/html/rfc3986#section-3.1
*
* @return string The URI scheme.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:336
public getAuthority(bool $ignorePort = false): string Retrieve the authority component of the URI.
/**
* Retrieve the authority component of the URI.
*
* If no authority information is present, this method MUST return an empty
* string.
*
* The authority syntax of the URI is:
*
* <pre>
* [user-info@]host[:port]
* </pre>
*
* If the port component is not set or is the standard port for the current
* scheme, it SHOULD NOT be included.
*
* @see https://tools.ietf.org/html/rfc3986#section-3.2
*
* @return string The URI authority, in "[user-info@]host[:port]" format.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:360
public getUserInfo(): string|null The URI user information, in "username[:password]" format. Retrieve the user information component of the URI.
/**
* Retrieve the user information component of the URI.
*
* If no user information is present, this method MUST return an empty
* string.
*
* If a user is present in the URI, this will return that value;
* additionally, if the password is also present, it will be appended to the
* user value, with a colon (":") separating the values.
*
* NOTE that be default, the password, if available, will NOT be shown
* as a security measure as discussed in RFC 3986, Section 7.5. If you know
* the password is not a security issue, you can force it to be shown
* with $this->showPassword();
*
* The trailing "@" character is not part of the user information and MUST
* NOT be added.
*
* @return string|null The URI user information, in "username[:password]" format.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:403
public showPassword(bool $val = true): URI Temporarily sets the URI to show a password in userInfo. Will reset itself af...
/**
* Temporarily sets the URI to show a password in userInfo. Will
* reset itself after the first call to authority().
*
* Note: Method not in PSR-7
*
* @return URI
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:422
public getHost(): string Retrieve the host component of the URI.
/**
* Retrieve the host component of the URI.
*
* If no host is present, this method MUST return an empty string.
*
* The value returned MUST be normalized to lowercase, per RFC 3986
* Section 3.2.2.
*
* @see http://tools.ietf.org/html/rfc3986#section-3.2.2
*
* @return string The URI host.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:441
public getPort(): int|null The URI port. Retrieve the port component of the URI.
/**
* Retrieve the port component of the URI.
*
* If a port is present, and it is non-standard for the current scheme,
* this method MUST return it as an integer. If the port is the standard port
* used with the current scheme, this method SHOULD return null.
*
* If no port is present, and no scheme is present, this method MUST return
* a null value.
*
* If no port is present, but a scheme is present, this method MAY return
* the standard port for that scheme, but SHOULD return null.
*
* @return int|null The URI port.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:461
public getPath(): string Retrieve the path component of the URI.
/**
* Retrieve the path component of the URI.
*
* The path can either be empty or absolute (starting with a slash) or
* rootless (not starting with a slash). Implementations MUST support all
* three syntaxes.
*
* Normally, the empty path "" and absolute path "/" are considered equal as
* defined in RFC 7230 Section 2.7.3. But this method MUST NOT automatically
* do this normalization because in contexts with a trimmed base path, e.g.
* the front controller, this difference becomes significant. It's the task
* of the user to handle both "" and "/".
*
* The value returned MUST be percent-encoded, but MUST NOT double-encode
* any characters. To determine what characters to encode, please refer to
* RFC 3986, Sections 2 and 3.3.
*
* As an example, if the value should include a slash ("/") not intended as
* delimiter between path segments, that value MUST be passed in encoded
* form (e.g., "%2F") to the instance.
*
* @see https://tools.ietf.org/html/rfc3986#section-2
* @see https://tools.ietf.org/html/rfc3986#section-3.3
*
* @return string The URI path.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:492
public getQuery(array $options = array()): string Retrieve the query string
/**
* Retrieve the query string
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:500
public getFragment(): string Retrieve a URI fragment
/**
* Retrieve a URI fragment
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:534
public getSegments(): array Returns the segments of the path as an array.
/**
* Returns the segments of the path as an array.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:542
public getSegment(int $number, string $default = ''): string Returns the value of a specific segment of the URI path. Allows to get only e...
/**
* Returns the value of a specific segment of the URI path.
* Allows to get only existing segments or the next one.
*
* @param int $number Segment number starting at 1
* @param string $default Default value
*
* @return string The value of the segment. If you specify the last +1
* segment, the $default value. If you specify the last +2
* or more throws HTTPException.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:558
public setSegment(int $number, $value): $this Set the value of a specific segment of the URI path. Allows to set only exist...
/**
* Set the value of a specific segment of the URI path.
* Allows to set only existing segments or add new one.
*
* Note: Method not in PSR-7
*
* @param int $number Segment number starting at 1
* @param int|string $value
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:586
public getTotalSegments(): int Returns the total number of segments.
/**
* Returns the total number of segments.
*
* Note: Method not in PSR-7
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:615
public __toString(): string Formats the URI as a string.
/**
* Formats the URI as a string.
*
* Warning: For backwards-compatability this method
* assumes URIs with the same host as baseURL should
* be relative to the project's configuration.
* This aspect of __toString() is deprecated and should be avoided.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:628
private changeSchemeAndPath(string $scheme, string $path): array Change the path (and scheme) assuming URIs with the same host as baseURL shou...
/**
* Change the path (and scheme) assuming URIs with the same host as baseURL
* should be relative to the project's configuration.
*
* @deprecated This method will be deleted.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:651
public setAuthority(string $str): $this Parses the given string and saves the appropriate authority pieces.
/**
* Parses the given string and saves the appropriate authority pieces.
*
* Note: Method not in PSR-7
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:685
public setScheme(string $str): $this Sets the scheme for this URI.
/**
* Sets the scheme for this URI.
*
* Because of the large number of valid schemes we cannot limit this
* to only http or https.
*
* @see https://www.iana.org/assignments/uri-schemes/uri-schemes.xhtml
*
* @return $this
*
* @deprecated 4.4.0 Use `withScheme()` instead.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:715
public withScheme(string $scheme): static A new instance with the specified scheme. Return an instance with the specified scheme.
/**
* Return an instance with the specified scheme.
*
* This method MUST retain the state of the current instance, and return
* an instance that contains the specified scheme.
*
* Implementations MUST support the schemes "http" and "https" case
* insensitively, and MAY accommodate other schemes if required.
*
* An empty scheme is equivalent to removing the scheme.
*
* @param string $scheme The scheme to use with the new instance.
*
* @return static A new instance with the specified scheme.
*
* @throws InvalidArgumentException for invalid or unsupported schemes.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:740
public setUserInfo(string $user, string $pass): $this Sets the userInfo/Authority portion of the URI.
/**
* Sets the userInfo/Authority portion of the URI.
*
* @param string $user The user's username
* @param string $pass The user's password
*
* @return $this
*
* @TODO PSR-7: Should be `withUserInfo($user, $password = null)`.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:761
public setHost(string $str): $this Sets the host name to use.
/**
* Sets the host name to use.
*
* @return $this
*
* @TODO PSR-7: Should be `withHost($host)`.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:776
public setPort(?int $port = null): $this Sets the port portion of the URI.
/**
* Sets the port portion of the URI.
*
* @return $this
*
* @TODO PSR-7: Should be `withPort($port)`.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:790
public setPath(string $path): $this Sets the path portion of the URI.
/**
* Sets the path portion of the URI.
*
* @return $this
*
* @TODO PSR-7: Should be `withPath($port)`.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:816
public setBaseURL(string $baseURL): void Sets the current baseURL.
/**
* Sets the current baseURL.
*
* @interal
*
* @deprecated Use SiteURI instead.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:834
public getBaseURL(): string Returns the current baseURL.
/**
* Returns the current baseURL.
*
* @interal
*
* @deprecated Use SiteURI instead.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:846
public refreshPath(): $this Sets the path portion of the URI based on segments.
/**
* Sets the path portion of the URI based on segments.
*
* @return $this
*
* @deprecated This method will be private.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:862
public setQuery(string $query): $this Sets the query portion of the URI, while attempting to clean the various part...
/**
* Sets the query portion of the URI, while attempting
* to clean the various parts of the query keys and values.
*
* @return $this
*
* @TODO PSR-7: Should be `withQuery($query)`.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:881
public setQueryArray(array $query): URI A convenience method to pass an array of items in as the Query portion of the...
/**
* A convenience method to pass an array of items in as the Query
* portion of the URI.
*
* @return URI
*
* @TODO: PSR-7: Should be `withQueryParams(array $query)`
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:913
public addQuery(string $key, $value = null): $this Adds a single new element to the query vars.
/**
* Adds a single new element to the query vars.
*
* Note: Method not in PSR-7
*
* @param int|string|null $value
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:929
public stripQuery($params): $this Removes one or more query vars from the URI.
/**
* Removes one or more query vars from the URI.
*
* Note: Method not in PSR-7
*
* @param string ...$params
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:945
public keepQuery($params): $this Filters the query variables so that only the keys passed in are kept. The res...
/**
* Filters the query variables so that only the keys passed in
* are kept. The rest are removed from the object.
*
* Note: Method not in PSR-7
*
* @param string ...$params
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:964
public setFragment(string $string): $this Sets the fragment portion of the URI.
/**
* Sets the fragment portion of the URI.
*
* @see https://tools.ietf.org/html/rfc3986#section-3.5
*
* @return $this
*
* @TODO PSR-7: Should be `withFragment($fragment)`.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:990
protected filterPath(?string $path = null): string Encodes any dangerous characters, and removes dot segments. While dot segment...
/**
* Encodes any dangerous characters, and removes dot segments.
* While dot segments have valid uses according to the spec,
* this URI class does not allow them.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:1002
protected applyParts(array $parts): void Saves our parts from a parse_url call.
/**
* Saves our parts from a parse_url call.
*
* @return void
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:1036
public resolveRelativeURI(string $uri): URI Combines one URI string with this one based on the rules set out in RFC 3986 ...
/**
* Combines one URI string with this one based on the rules set out in
* RFC 3986 Section 2
*
* @see http://tools.ietf.org/html/rfc3986#section-5.2
*
* @return URI
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:1087
protected mergePaths(self $base, self $reference): string Given 2 paths, will merge them according to rules set out in RFC 2986, Sectio...
/**
* Given 2 paths, will merge them according to rules set out in RFC 2986,
* Section 5.2
*
* @see http://tools.ietf.org/html/rfc3986#section-5.2.3
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:1143
protected parseStr(string $query): array This is equivalent to the native PHP parse_str() function. This version allow...
/**
* This is equivalent to the native PHP parse_str() function.
* This version allows the dot to be used as a key of the query string.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:1165
public static CodeIgniter\HTTP\URI::createURIString(?string $scheme = null, ?string $authority = null, ?string $path = null, ?string $query = null, ?string $fragment = null): string Builds a representation of the string from the component parts.
/**
* Builds a representation of the string from the component parts.
*
* @param string|null $scheme URI scheme. E.g., http, ftp
*
* @return string URI string with only passed parts. Maybe incomplete as a URI.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:161
public static CodeIgniter\HTTP\URI::removeDotSegments(string $path): string Used when resolving and merging paths to correctly interpret and remove singl...
/**
* Used when resolving and merging paths to correctly interpret and
* remove single and double dot segments from the path per
* RFC 3986 Section 5.2.4
*
* @see http://tools.ietf.org/html/rfc3986#section-5.2.4
*
* @internal
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:203
public const CodeIgniter\HTTP\URI::CHAR_SUB_DELIMS :: string (16) "!\$&'\(\)\*\+,;="
public const CodeIgniter\HTTP\URI::CHAR_UNRESERVED :: string (15) "a-zA-Z0-9_\-\.~"
/**
* @param string $relativePath URI path relative to baseURL. May include
* queries or fragments.
* @param string|null $host Optional current hostname.
* @param string|null $scheme Optional scheme. 'http' or 'https'.
* @phpstan-param 'http'|'https'|null $scheme
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:94
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:193
private setBasePath(): void Sets basePathWithoutIndexPage and baseSegments.
/**
* Sets basePathWithoutIndexPage and baseSegments.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:212
public setBaseURL(string $baseURL): void
/**
* @deprecated
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:226
public setURI(?string $uri = null)
/**
* @deprecated
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:234
public getBaseURL(): string Returns the baseURL.
/**
* Returns the baseURL.
*
* @interal
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:244
public getRoutePath(): string Returns the URI path relative to baseURL.
/**
* Returns the URI path relative to baseURL.
*
* @return string The Route path.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:254
public __toString(): string Formats the URI as a string.
/**
* Formats the URI as a string.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:262
public setPath(string $path): $this Sets the route path (and segments).
/**
* Sets the route path (and segments).
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:278
private setRoutePath(string $routePath): void Sets the route path (and segments).
/**
* Sets the route path (and segments).
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:288
private convertToSegments(string $path): array Converts path to segments
/**
* Converts path to segments
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:304
public refreshPath(): $this Sets the path portion of the URI based on segments.
/**
* Sets the path portion of the URI based on segments.
*
* @return $this
*
* @deprecated This method will be private.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:318
protected applyParts(array $parts): void Saves our parts from a parse_url() call.
/**
* Saves our parts from a parse_url() call.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:335
public baseUrl($relativePath = '', ?string $scheme = null): string For base_url() helper.
/**
* For base_url() helper.
*
* @param array|string $relativePath URI string or array of URI segments.
* @param string|null $scheme URI scheme. E.g., http, ftp. If empty
* string '' is set, a protocol-relative
* link is returned.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:379
/**
* @param array|string $relativePath URI string or array of URI segments
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:401
public siteUrl($relativePath = '', ?string $scheme = null, ?Config\App $config = null): string For site_url() helper.
/**
* For site_url() helper.
*
* @param array|string $relativePath URI string or array of URI segments.
* @param string|null $scheme URI scheme. E.g., http, ftp. If empty
* string '' is set, a protocol-relative
* link is returned.
* @param App|null $config Alternate configuration to use.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:419
public setSilent(bool $silent = true): URI If $silent == true, then will not throw exceptions and will attempt to contin...
/**
* If $silent == true, then will not throw exceptions and will
* attempt to continue gracefully.
*
* @deprecated 4.4.0 Method not in PSR-7
*
* @return URI
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:271
public useRawQueryString(bool $raw = true): URI If $raw == true, then will use parseStr() method instead of native parse_str(...
/**
* If $raw == true, then will use parseStr() method
* instead of native parse_str() function.
*
* Note: Method not in PSR-7
*
* @return URI
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:286
public getScheme(): string Retrieve the scheme component of the URI.
/**
* Retrieve the scheme component of the URI.
*
* If no scheme is present, this method MUST return an empty string.
*
* The value returned MUST be normalized to lowercase, per RFC 3986
* Section 3.1.
*
* The trailing ":" character is not part of the scheme and MUST NOT be
* added.
*
* @see https://tools.ietf.org/html/rfc3986#section-3.1
*
* @return string The URI scheme.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:336
public getAuthority(bool $ignorePort = false): string Retrieve the authority component of the URI.
/**
* Retrieve the authority component of the URI.
*
* If no authority information is present, this method MUST return an empty
* string.
*
* The authority syntax of the URI is:
*
* <pre>
* [user-info@]host[:port]
* </pre>
*
* If the port component is not set or is the standard port for the current
* scheme, it SHOULD NOT be included.
*
* @see https://tools.ietf.org/html/rfc3986#section-3.2
*
* @return string The URI authority, in "[user-info@]host[:port]" format.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:360
public getUserInfo(): string|null The URI user information, in "username[:password]" format. Retrieve the user information component of the URI.
/**
* Retrieve the user information component of the URI.
*
* If no user information is present, this method MUST return an empty
* string.
*
* If a user is present in the URI, this will return that value;
* additionally, if the password is also present, it will be appended to the
* user value, with a colon (":") separating the values.
*
* NOTE that be default, the password, if available, will NOT be shown
* as a security measure as discussed in RFC 3986, Section 7.5. If you know
* the password is not a security issue, you can force it to be shown
* with $this->showPassword();
*
* The trailing "@" character is not part of the user information and MUST
* NOT be added.
*
* @return string|null The URI user information, in "username[:password]" format.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:403
public showPassword(bool $val = true): URI Temporarily sets the URI to show a password in userInfo. Will reset itself af...
/**
* Temporarily sets the URI to show a password in userInfo. Will
* reset itself after the first call to authority().
*
* Note: Method not in PSR-7
*
* @return URI
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:422
public getHost(): string Retrieve the host component of the URI.
/**
* Retrieve the host component of the URI.
*
* If no host is present, this method MUST return an empty string.
*
* The value returned MUST be normalized to lowercase, per RFC 3986
* Section 3.2.2.
*
* @see http://tools.ietf.org/html/rfc3986#section-3.2.2
*
* @return string The URI host.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:441
public getPort(): int|null The URI port. Retrieve the port component of the URI.
/**
* Retrieve the port component of the URI.
*
* If a port is present, and it is non-standard for the current scheme,
* this method MUST return it as an integer. If the port is the standard port
* used with the current scheme, this method SHOULD return null.
*
* If no port is present, and no scheme is present, this method MUST return
* a null value.
*
* If no port is present, but a scheme is present, this method MAY return
* the standard port for that scheme, but SHOULD return null.
*
* @return int|null The URI port.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:461
public getPath(): string Retrieve the path component of the URI.
/**
* Retrieve the path component of the URI.
*
* The path can either be empty or absolute (starting with a slash) or
* rootless (not starting with a slash). Implementations MUST support all
* three syntaxes.
*
* Normally, the empty path "" and absolute path "/" are considered equal as
* defined in RFC 7230 Section 2.7.3. But this method MUST NOT automatically
* do this normalization because in contexts with a trimmed base path, e.g.
* the front controller, this difference becomes significant. It's the task
* of the user to handle both "" and "/".
*
* The value returned MUST be percent-encoded, but MUST NOT double-encode
* any characters. To determine what characters to encode, please refer to
* RFC 3986, Sections 2 and 3.3.
*
* As an example, if the value should include a slash ("/") not intended as
* delimiter between path segments, that value MUST be passed in encoded
* form (e.g., "%2F") to the instance.
*
* @see https://tools.ietf.org/html/rfc3986#section-2
* @see https://tools.ietf.org/html/rfc3986#section-3.3
*
* @return string The URI path.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:492
public getQuery(array $options = array()): string Retrieve the query string
/**
* Retrieve the query string
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:500
public getFragment(): string Retrieve a URI fragment
/**
* Retrieve a URI fragment
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:534
public getSegments(): array Returns the segments of the path as an array.
/**
* Returns the segments of the path as an array.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:542
public getSegment(int $number, string $default = ''): string Returns the value of a specific segment of the URI path. Allows to get only e...
/**
* Returns the value of a specific segment of the URI path.
* Allows to get only existing segments or the next one.
*
* @param int $number Segment number starting at 1
* @param string $default Default value
*
* @return string The value of the segment. If you specify the last +1
* segment, the $default value. If you specify the last +2
* or more throws HTTPException.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:558
public setSegment(int $number, $value): $this Set the value of a specific segment of the URI path. Allows to set only exist...
/**
* Set the value of a specific segment of the URI path.
* Allows to set only existing segments or add new one.
*
* Note: Method not in PSR-7
*
* @param int $number Segment number starting at 1
* @param int|string $value
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:586
public getTotalSegments(): int Returns the total number of segments.
/**
* Returns the total number of segments.
*
* Note: Method not in PSR-7
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:615
public setAuthority(string $str): $this Parses the given string and saves the appropriate authority pieces.
/**
* Parses the given string and saves the appropriate authority pieces.
*
* Note: Method not in PSR-7
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:685
public setScheme(string $str): $this Sets the scheme for this URI.
/**
* Sets the scheme for this URI.
*
* Because of the large number of valid schemes we cannot limit this
* to only http or https.
*
* @see https://www.iana.org/assignments/uri-schemes/uri-schemes.xhtml
*
* @return $this
*
* @deprecated 4.4.0 Use `withScheme()` instead.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:715
public withScheme(string $scheme): static A new instance with the specified scheme. Return an instance with the specified scheme.
/**
* Return an instance with the specified scheme.
*
* This method MUST retain the state of the current instance, and return
* an instance that contains the specified scheme.
*
* Implementations MUST support the schemes "http" and "https" case
* insensitively, and MAY accommodate other schemes if required.
*
* An empty scheme is equivalent to removing the scheme.
*
* @param string $scheme The scheme to use with the new instance.
*
* @return static A new instance with the specified scheme.
*
* @throws InvalidArgumentException for invalid or unsupported schemes.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:740
public setUserInfo(string $user, string $pass): $this Sets the userInfo/Authority portion of the URI.
/**
* Sets the userInfo/Authority portion of the URI.
*
* @param string $user The user's username
* @param string $pass The user's password
*
* @return $this
*
* @TODO PSR-7: Should be `withUserInfo($user, $password = null)`.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:761
public setHost(string $str): $this Sets the host name to use.
/**
* Sets the host name to use.
*
* @return $this
*
* @TODO PSR-7: Should be `withHost($host)`.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:776
public setPort(?int $port = null): $this Sets the port portion of the URI.
/**
* Sets the port portion of the URI.
*
* @return $this
*
* @TODO PSR-7: Should be `withPort($port)`.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:790
public setQuery(string $query): $this Sets the query portion of the URI, while attempting to clean the various part...
/**
* Sets the query portion of the URI, while attempting
* to clean the various parts of the query keys and values.
*
* @return $this
*
* @TODO PSR-7: Should be `withQuery($query)`.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:881
public setQueryArray(array $query): URI A convenience method to pass an array of items in as the Query portion of the...
/**
* A convenience method to pass an array of items in as the Query
* portion of the URI.
*
* @return URI
*
* @TODO: PSR-7: Should be `withQueryParams(array $query)`
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:913
public addQuery(string $key, $value = null): $this Adds a single new element to the query vars.
/**
* Adds a single new element to the query vars.
*
* Note: Method not in PSR-7
*
* @param int|string|null $value
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:929
public stripQuery($params): $this Removes one or more query vars from the URI.
/**
* Removes one or more query vars from the URI.
*
* Note: Method not in PSR-7
*
* @param string ...$params
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:945
public keepQuery($params): $this Filters the query variables so that only the keys passed in are kept. The res...
/**
* Filters the query variables so that only the keys passed in
* are kept. The rest are removed from the object.
*
* Note: Method not in PSR-7
*
* @param string ...$params
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:964
public setFragment(string $string): $this Sets the fragment portion of the URI.
/**
* Sets the fragment portion of the URI.
*
* @see https://tools.ietf.org/html/rfc3986#section-3.5
*
* @return $this
*
* @TODO PSR-7: Should be `withFragment($fragment)`.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:990
protected filterPath(?string $path = null): string Encodes any dangerous characters, and removes dot segments. While dot segment...
/**
* Encodes any dangerous characters, and removes dot segments.
* While dot segments have valid uses according to the spec,
* this URI class does not allow them.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:1002
public resolveRelativeURI(string $uri): URI Combines one URI string with this one based on the rules set out in RFC 3986 ...
/**
* Combines one URI string with this one based on the rules set out in
* RFC 3986 Section 2
*
* @see http://tools.ietf.org/html/rfc3986#section-5.2
*
* @return URI
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:1087
protected mergePaths(self $base, self $reference): string Given 2 paths, will merge them according to rules set out in RFC 2986, Sectio...
/**
* Given 2 paths, will merge them according to rules set out in RFC 2986,
* Section 5.2
*
* @see http://tools.ietf.org/html/rfc3986#section-5.2.3
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:1143
protected parseStr(string $query): array This is equivalent to the native PHP parse_str() function. This version allow...
/**
* This is equivalent to the native PHP parse_str() function.
* This version allows the dot to be used as a key of the query string.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:1165
private changeSchemeAndPath(string $scheme, string $path): array Change the path (and scheme) assuming URIs with the same host as baseURL shou...
/**
* Change the path (and scheme) assuming URIs with the same host as baseURL
* should be relative to the project's configuration.
*
* @deprecated This method will be deleted.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:651
public static CodeIgniter\HTTP\URI::createURIString(?string $scheme = null, ?string $authority = null, ?string $path = null, ?string $query = null, ?string $fragment = null): string Builds a representation of the string from the component parts.
/**
* Builds a representation of the string from the component parts.
*
* @param string|null $scheme URI scheme. E.g., http, ftp
*
* @return string URI string with only passed parts. Maybe incomplete as a URI.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:161
public static CodeIgniter\HTTP\URI::removeDotSegments(string $path): string Used when resolving and merging paths to correctly interpret and remove singl...
/**
* Used when resolving and merging paths to correctly interpret and
* remove single and double dot segments from the path per
* RFC 3986 Section 5.2.4
*
* @see http://tools.ietf.org/html/rfc3986#section-5.2.4
*
* @internal
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:203
public const CodeIgniter\HTTP\URI::CHAR_SUB_DELIMS :: string (16) "!\$&'\(\)\*\+,;="
public const CodeIgniter\HTTP\URI::CHAR_UNRESERVED :: string (15) "a-zA-Z0-9_\-\.~"
public __construct(?string $uri = null) Constructor.
/**
* Constructor.
*
* @param string|null $uri The URI to parse.
*
* @throws HTTPException
*
* @TODO null for param $uri should be removed.
* See https://www.php-fig.org/psr/psr-17/#26-urifactoryinterface
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:256
public setSilent(bool $silent = true): URI If $silent == true, then will not throw exceptions and will attempt to contin...
/**
* If $silent == true, then will not throw exceptions and will
* attempt to continue gracefully.
*
* @deprecated 4.4.0 Method not in PSR-7
*
* @return URI
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:271
public useRawQueryString(bool $raw = true): URI If $raw == true, then will use parseStr() method instead of native parse_str(...
/**
* If $raw == true, then will use parseStr() method
* instead of native parse_str() function.
*
* Note: Method not in PSR-7
*
* @return URI
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:286
public setURI(?string $uri = null): URI Sets and overwrites any current URI information.
/**
* Sets and overwrites any current URI information.
*
* @return URI
*
* @throws HTTPException
*
* @deprecated 4.4.0 This method will be private.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:302
public getScheme(): string Retrieve the scheme component of the URI.
/**
* Retrieve the scheme component of the URI.
*
* If no scheme is present, this method MUST return an empty string.
*
* The value returned MUST be normalized to lowercase, per RFC 3986
* Section 3.1.
*
* The trailing ":" character is not part of the scheme and MUST NOT be
* added.
*
* @see https://tools.ietf.org/html/rfc3986#section-3.1
*
* @return string The URI scheme.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:336
public getAuthority(bool $ignorePort = false): string Retrieve the authority component of the URI.
/**
* Retrieve the authority component of the URI.
*
* If no authority information is present, this method MUST return an empty
* string.
*
* The authority syntax of the URI is:
*
* <pre>
* [user-info@]host[:port]
* </pre>
*
* If the port component is not set or is the standard port for the current
* scheme, it SHOULD NOT be included.
*
* @see https://tools.ietf.org/html/rfc3986#section-3.2
*
* @return string The URI authority, in "[user-info@]host[:port]" format.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:360
public getUserInfo(): string|null The URI user information, in "username[:password]" format. Retrieve the user information component of the URI.
/**
* Retrieve the user information component of the URI.
*
* If no user information is present, this method MUST return an empty
* string.
*
* If a user is present in the URI, this will return that value;
* additionally, if the password is also present, it will be appended to the
* user value, with a colon (":") separating the values.
*
* NOTE that be default, the password, if available, will NOT be shown
* as a security measure as discussed in RFC 3986, Section 7.5. If you know
* the password is not a security issue, you can force it to be shown
* with $this->showPassword();
*
* The trailing "@" character is not part of the user information and MUST
* NOT be added.
*
* @return string|null The URI user information, in "username[:password]" format.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:403
public showPassword(bool $val = true): URI Temporarily sets the URI to show a password in userInfo. Will reset itself af...
/**
* Temporarily sets the URI to show a password in userInfo. Will
* reset itself after the first call to authority().
*
* Note: Method not in PSR-7
*
* @return URI
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:422
public getHost(): string Retrieve the host component of the URI.
/**
* Retrieve the host component of the URI.
*
* If no host is present, this method MUST return an empty string.
*
* The value returned MUST be normalized to lowercase, per RFC 3986
* Section 3.2.2.
*
* @see http://tools.ietf.org/html/rfc3986#section-3.2.2
*
* @return string The URI host.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:441
public getPort(): int|null The URI port. Retrieve the port component of the URI.
/**
* Retrieve the port component of the URI.
*
* If a port is present, and it is non-standard for the current scheme,
* this method MUST return it as an integer. If the port is the standard port
* used with the current scheme, this method SHOULD return null.
*
* If no port is present, and no scheme is present, this method MUST return
* a null value.
*
* If no port is present, but a scheme is present, this method MAY return
* the standard port for that scheme, but SHOULD return null.
*
* @return int|null The URI port.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:461
public getPath(): string Retrieve the path component of the URI.
/**
* Retrieve the path component of the URI.
*
* The path can either be empty or absolute (starting with a slash) or
* rootless (not starting with a slash). Implementations MUST support all
* three syntaxes.
*
* Normally, the empty path "" and absolute path "/" are considered equal as
* defined in RFC 7230 Section 2.7.3. But this method MUST NOT automatically
* do this normalization because in contexts with a trimmed base path, e.g.
* the front controller, this difference becomes significant. It's the task
* of the user to handle both "" and "/".
*
* The value returned MUST be percent-encoded, but MUST NOT double-encode
* any characters. To determine what characters to encode, please refer to
* RFC 3986, Sections 2 and 3.3.
*
* As an example, if the value should include a slash ("/") not intended as
* delimiter between path segments, that value MUST be passed in encoded
* form (e.g., "%2F") to the instance.
*
* @see https://tools.ietf.org/html/rfc3986#section-2
* @see https://tools.ietf.org/html/rfc3986#section-3.3
*
* @return string The URI path.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:492
public getQuery(array $options = array()): string Retrieve the query string
/**
* Retrieve the query string
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:500
public getFragment(): string Retrieve a URI fragment
/**
* Retrieve a URI fragment
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:534
public getSegments(): array Returns the segments of the path as an array.
/**
* Returns the segments of the path as an array.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:542
public getSegment(int $number, string $default = ''): string Returns the value of a specific segment of the URI path. Allows to get only e...
/**
* Returns the value of a specific segment of the URI path.
* Allows to get only existing segments or the next one.
*
* @param int $number Segment number starting at 1
* @param string $default Default value
*
* @return string The value of the segment. If you specify the last +1
* segment, the $default value. If you specify the last +2
* or more throws HTTPException.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:558
public setSegment(int $number, $value): $this Set the value of a specific segment of the URI path. Allows to set only exist...
/**
* Set the value of a specific segment of the URI path.
* Allows to set only existing segments or add new one.
*
* Note: Method not in PSR-7
*
* @param int $number Segment number starting at 1
* @param int|string $value
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:586
public getTotalSegments(): int Returns the total number of segments.
/**
* Returns the total number of segments.
*
* Note: Method not in PSR-7
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:615
public __toString(): string Formats the URI as a string.
/**
* Formats the URI as a string.
*
* Warning: For backwards-compatability this method
* assumes URIs with the same host as baseURL should
* be relative to the project's configuration.
* This aspect of __toString() is deprecated and should be avoided.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:628
private changeSchemeAndPath(string $scheme, string $path): array Change the path (and scheme) assuming URIs with the same host as baseURL shou...
/**
* Change the path (and scheme) assuming URIs with the same host as baseURL
* should be relative to the project's configuration.
*
* @deprecated This method will be deleted.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:651
public setAuthority(string $str): $this Parses the given string and saves the appropriate authority pieces.
/**
* Parses the given string and saves the appropriate authority pieces.
*
* Note: Method not in PSR-7
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:685
public setScheme(string $str): $this Sets the scheme for this URI.
/**
* Sets the scheme for this URI.
*
* Because of the large number of valid schemes we cannot limit this
* to only http or https.
*
* @see https://www.iana.org/assignments/uri-schemes/uri-schemes.xhtml
*
* @return $this
*
* @deprecated 4.4.0 Use `withScheme()` instead.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:715
public withScheme(string $scheme): static A new instance with the specified scheme. Return an instance with the specified scheme.
/**
* Return an instance with the specified scheme.
*
* This method MUST retain the state of the current instance, and return
* an instance that contains the specified scheme.
*
* Implementations MUST support the schemes "http" and "https" case
* insensitively, and MAY accommodate other schemes if required.
*
* An empty scheme is equivalent to removing the scheme.
*
* @param string $scheme The scheme to use with the new instance.
*
* @return static A new instance with the specified scheme.
*
* @throws InvalidArgumentException for invalid or unsupported schemes.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:740
public setUserInfo(string $user, string $pass): $this Sets the userInfo/Authority portion of the URI.
/**
* Sets the userInfo/Authority portion of the URI.
*
* @param string $user The user's username
* @param string $pass The user's password
*
* @return $this
*
* @TODO PSR-7: Should be `withUserInfo($user, $password = null)`.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:761
public setHost(string $str): $this Sets the host name to use.
/**
* Sets the host name to use.
*
* @return $this
*
* @TODO PSR-7: Should be `withHost($host)`.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:776
public setPort(?int $port = null): $this Sets the port portion of the URI.
/**
* Sets the port portion of the URI.
*
* @return $this
*
* @TODO PSR-7: Should be `withPort($port)`.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:790
public setPath(string $path): $this Sets the path portion of the URI.
/**
* Sets the path portion of the URI.
*
* @return $this
*
* @TODO PSR-7: Should be `withPath($port)`.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:816
public setBaseURL(string $baseURL): void Sets the current baseURL.
/**
* Sets the current baseURL.
*
* @interal
*
* @deprecated Use SiteURI instead.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:834
public getBaseURL(): string Returns the current baseURL.
/**
* Returns the current baseURL.
*
* @interal
*
* @deprecated Use SiteURI instead.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:846
public refreshPath(): $this Sets the path portion of the URI based on segments.
/**
* Sets the path portion of the URI based on segments.
*
* @return $this
*
* @deprecated This method will be private.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:862
public setQuery(string $query): $this Sets the query portion of the URI, while attempting to clean the various part...
/**
* Sets the query portion of the URI, while attempting
* to clean the various parts of the query keys and values.
*
* @return $this
*
* @TODO PSR-7: Should be `withQuery($query)`.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:881
public setQueryArray(array $query): URI A convenience method to pass an array of items in as the Query portion of the...
/**
* A convenience method to pass an array of items in as the Query
* portion of the URI.
*
* @return URI
*
* @TODO: PSR-7: Should be `withQueryParams(array $query)`
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:913
public addQuery(string $key, $value = null): $this Adds a single new element to the query vars.
/**
* Adds a single new element to the query vars.
*
* Note: Method not in PSR-7
*
* @param int|string|null $value
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:929
public stripQuery($params): $this Removes one or more query vars from the URI.
/**
* Removes one or more query vars from the URI.
*
* Note: Method not in PSR-7
*
* @param string ...$params
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:945
public keepQuery($params): $this Filters the query variables so that only the keys passed in are kept. The res...
/**
* Filters the query variables so that only the keys passed in
* are kept. The rest are removed from the object.
*
* Note: Method not in PSR-7
*
* @param string ...$params
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:964
public setFragment(string $string): $this Sets the fragment portion of the URI.
/**
* Sets the fragment portion of the URI.
*
* @see https://tools.ietf.org/html/rfc3986#section-3.5
*
* @return $this
*
* @TODO PSR-7: Should be `withFragment($fragment)`.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:990
protected filterPath(?string $path = null): string Encodes any dangerous characters, and removes dot segments. While dot segment...
/**
* Encodes any dangerous characters, and removes dot segments.
* While dot segments have valid uses according to the spec,
* this URI class does not allow them.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:1002
protected applyParts(array $parts): void Saves our parts from a parse_url call.
/**
* Saves our parts from a parse_url call.
*
* @return void
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:1036
public resolveRelativeURI(string $uri): URI Combines one URI string with this one based on the rules set out in RFC 3986 ...
/**
* Combines one URI string with this one based on the rules set out in
* RFC 3986 Section 2
*
* @see http://tools.ietf.org/html/rfc3986#section-5.2
*
* @return URI
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:1087
protected mergePaths(self $base, self $reference): string Given 2 paths, will merge them according to rules set out in RFC 2986, Sectio...
/**
* Given 2 paths, will merge them according to rules set out in RFC 2986,
* Section 5.2
*
* @see http://tools.ietf.org/html/rfc3986#section-5.2.3
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:1143
protected parseStr(string $query): array This is equivalent to the native PHP parse_str() function. This version allow...
/**
* This is equivalent to the native PHP parse_str() function.
* This version allows the dot to be used as a key of the query string.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:1165
public static CodeIgniter\HTTP\URI::createURIString(?string $scheme = null, ?string $authority = null, ?string $path = null, ?string $query = null, ?string $fragment = null): string Builds a representation of the string from the component parts.
/**
* Builds a representation of the string from the component parts.
*
* @param string|null $scheme URI scheme. E.g., http, ftp
*
* @return string URI string with only passed parts. Maybe incomplete as a URI.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:161
public static CodeIgniter\HTTP\URI::removeDotSegments(string $path): string Used when resolving and merging paths to correctly interpret and remove singl...
/**
* Used when resolving and merging paths to correctly interpret and
* remove single and double dot segments from the path per
* RFC 3986 Section 5.2.4
*
* @see http://tools.ietf.org/html/rfc3986#section-5.2.4
*
* @internal
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:203
public const CodeIgniter\HTTP\URI::CHAR_SUB_DELIMS :: string (16) "!\$&'\(\)\*\+,;="
public const CodeIgniter\HTTP\URI::CHAR_UNRESERVED :: string (15) "a-zA-Z0-9_\-\.~"
/**
* @param string $relativePath URI path relative to baseURL. May include
* queries or fragments.
* @param string|null $host Optional current hostname.
* @param string|null $scheme Optional scheme. 'http' or 'https'.
* @phpstan-param 'http'|'https'|null $scheme
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:94
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:193
private setBasePath(): void Sets basePathWithoutIndexPage and baseSegments.
/**
* Sets basePathWithoutIndexPage and baseSegments.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:212
public setBaseURL(string $baseURL): void
/**
* @deprecated
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:226
public setURI(?string $uri = null)
/**
* @deprecated
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:234
public getBaseURL(): string Returns the baseURL.
/**
* Returns the baseURL.
*
* @interal
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:244
public getRoutePath(): string Returns the URI path relative to baseURL.
/**
* Returns the URI path relative to baseURL.
*
* @return string The Route path.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:254
public __toString(): string Formats the URI as a string.
/**
* Formats the URI as a string.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:262
public setPath(string $path): $this Sets the route path (and segments).
/**
* Sets the route path (and segments).
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:278
private setRoutePath(string $routePath): void Sets the route path (and segments).
/**
* Sets the route path (and segments).
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:288
private convertToSegments(string $path): array Converts path to segments
/**
* Converts path to segments
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:304
public refreshPath(): $this Sets the path portion of the URI based on segments.
/**
* Sets the path portion of the URI based on segments.
*
* @return $this
*
* @deprecated This method will be private.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:318
protected applyParts(array $parts): void Saves our parts from a parse_url() call.
/**
* Saves our parts from a parse_url() call.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:335
public baseUrl($relativePath = '', ?string $scheme = null): string For base_url() helper.
/**
* For base_url() helper.
*
* @param array|string $relativePath URI string or array of URI segments.
* @param string|null $scheme URI scheme. E.g., http, ftp. If empty
* string '' is set, a protocol-relative
* link is returned.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:379
/**
* @param array|string $relativePath URI string or array of URI segments
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:401
public siteUrl($relativePath = '', ?string $scheme = null, ?Config\App $config = null): string For site_url() helper.
/**
* For site_url() helper.
*
* @param array|string $relativePath URI string or array of URI segments.
* @param string|null $scheme URI scheme. E.g., http, ftp. If empty
* string '' is set, a protocol-relative
* link is returned.
* @param App|null $config Alternate configuration to use.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/SiteURI.php:419
public setSilent(bool $silent = true): URI If $silent == true, then will not throw exceptions and will attempt to contin...
/**
* If $silent == true, then will not throw exceptions and will
* attempt to continue gracefully.
*
* @deprecated 4.4.0 Method not in PSR-7
*
* @return URI
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:271
public useRawQueryString(bool $raw = true): URI If $raw == true, then will use parseStr() method instead of native parse_str(...
/**
* If $raw == true, then will use parseStr() method
* instead of native parse_str() function.
*
* Note: Method not in PSR-7
*
* @return URI
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:286
public getScheme(): string Retrieve the scheme component of the URI.
/**
* Retrieve the scheme component of the URI.
*
* If no scheme is present, this method MUST return an empty string.
*
* The value returned MUST be normalized to lowercase, per RFC 3986
* Section 3.1.
*
* The trailing ":" character is not part of the scheme and MUST NOT be
* added.
*
* @see https://tools.ietf.org/html/rfc3986#section-3.1
*
* @return string The URI scheme.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:336
public getAuthority(bool $ignorePort = false): string Retrieve the authority component of the URI.
/**
* Retrieve the authority component of the URI.
*
* If no authority information is present, this method MUST return an empty
* string.
*
* The authority syntax of the URI is:
*
* <pre>
* [user-info@]host[:port]
* </pre>
*
* If the port component is not set or is the standard port for the current
* scheme, it SHOULD NOT be included.
*
* @see https://tools.ietf.org/html/rfc3986#section-3.2
*
* @return string The URI authority, in "[user-info@]host[:port]" format.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:360
public getUserInfo(): string|null The URI user information, in "username[:password]" format. Retrieve the user information component of the URI.
/**
* Retrieve the user information component of the URI.
*
* If no user information is present, this method MUST return an empty
* string.
*
* If a user is present in the URI, this will return that value;
* additionally, if the password is also present, it will be appended to the
* user value, with a colon (":") separating the values.
*
* NOTE that be default, the password, if available, will NOT be shown
* as a security measure as discussed in RFC 3986, Section 7.5. If you know
* the password is not a security issue, you can force it to be shown
* with $this->showPassword();
*
* The trailing "@" character is not part of the user information and MUST
* NOT be added.
*
* @return string|null The URI user information, in "username[:password]" format.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:403
public showPassword(bool $val = true): URI Temporarily sets the URI to show a password in userInfo. Will reset itself af...
/**
* Temporarily sets the URI to show a password in userInfo. Will
* reset itself after the first call to authority().
*
* Note: Method not in PSR-7
*
* @return URI
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:422
public getHost(): string Retrieve the host component of the URI.
/**
* Retrieve the host component of the URI.
*
* If no host is present, this method MUST return an empty string.
*
* The value returned MUST be normalized to lowercase, per RFC 3986
* Section 3.2.2.
*
* @see http://tools.ietf.org/html/rfc3986#section-3.2.2
*
* @return string The URI host.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:441
public getPort(): int|null The URI port. Retrieve the port component of the URI.
/**
* Retrieve the port component of the URI.
*
* If a port is present, and it is non-standard for the current scheme,
* this method MUST return it as an integer. If the port is the standard port
* used with the current scheme, this method SHOULD return null.
*
* If no port is present, and no scheme is present, this method MUST return
* a null value.
*
* If no port is present, but a scheme is present, this method MAY return
* the standard port for that scheme, but SHOULD return null.
*
* @return int|null The URI port.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:461
public getPath(): string Retrieve the path component of the URI.
/**
* Retrieve the path component of the URI.
*
* The path can either be empty or absolute (starting with a slash) or
* rootless (not starting with a slash). Implementations MUST support all
* three syntaxes.
*
* Normally, the empty path "" and absolute path "/" are considered equal as
* defined in RFC 7230 Section 2.7.3. But this method MUST NOT automatically
* do this normalization because in contexts with a trimmed base path, e.g.
* the front controller, this difference becomes significant. It's the task
* of the user to handle both "" and "/".
*
* The value returned MUST be percent-encoded, but MUST NOT double-encode
* any characters. To determine what characters to encode, please refer to
* RFC 3986, Sections 2 and 3.3.
*
* As an example, if the value should include a slash ("/") not intended as
* delimiter between path segments, that value MUST be passed in encoded
* form (e.g., "%2F") to the instance.
*
* @see https://tools.ietf.org/html/rfc3986#section-2
* @see https://tools.ietf.org/html/rfc3986#section-3.3
*
* @return string The URI path.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:492
public getQuery(array $options = array()): string Retrieve the query string
/**
* Retrieve the query string
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:500
public getFragment(): string Retrieve a URI fragment
/**
* Retrieve a URI fragment
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:534
public getSegments(): array Returns the segments of the path as an array.
/**
* Returns the segments of the path as an array.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:542
public getSegment(int $number, string $default = ''): string Returns the value of a specific segment of the URI path. Allows to get only e...
/**
* Returns the value of a specific segment of the URI path.
* Allows to get only existing segments or the next one.
*
* @param int $number Segment number starting at 1
* @param string $default Default value
*
* @return string The value of the segment. If you specify the last +1
* segment, the $default value. If you specify the last +2
* or more throws HTTPException.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:558
public setSegment(int $number, $value): $this Set the value of a specific segment of the URI path. Allows to set only exist...
/**
* Set the value of a specific segment of the URI path.
* Allows to set only existing segments or add new one.
*
* Note: Method not in PSR-7
*
* @param int $number Segment number starting at 1
* @param int|string $value
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:586
public getTotalSegments(): int Returns the total number of segments.
/**
* Returns the total number of segments.
*
* Note: Method not in PSR-7
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:615
public setAuthority(string $str): $this Parses the given string and saves the appropriate authority pieces.
/**
* Parses the given string and saves the appropriate authority pieces.
*
* Note: Method not in PSR-7
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:685
public setScheme(string $str): $this Sets the scheme for this URI.
/**
* Sets the scheme for this URI.
*
* Because of the large number of valid schemes we cannot limit this
* to only http or https.
*
* @see https://www.iana.org/assignments/uri-schemes/uri-schemes.xhtml
*
* @return $this
*
* @deprecated 4.4.0 Use `withScheme()` instead.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:715
public withScheme(string $scheme): static A new instance with the specified scheme. Return an instance with the specified scheme.
/**
* Return an instance with the specified scheme.
*
* This method MUST retain the state of the current instance, and return
* an instance that contains the specified scheme.
*
* Implementations MUST support the schemes "http" and "https" case
* insensitively, and MAY accommodate other schemes if required.
*
* An empty scheme is equivalent to removing the scheme.
*
* @param string $scheme The scheme to use with the new instance.
*
* @return static A new instance with the specified scheme.
*
* @throws InvalidArgumentException for invalid or unsupported schemes.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:740
public setUserInfo(string $user, string $pass): $this Sets the userInfo/Authority portion of the URI.
/**
* Sets the userInfo/Authority portion of the URI.
*
* @param string $user The user's username
* @param string $pass The user's password
*
* @return $this
*
* @TODO PSR-7: Should be `withUserInfo($user, $password = null)`.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:761
public setHost(string $str): $this Sets the host name to use.
/**
* Sets the host name to use.
*
* @return $this
*
* @TODO PSR-7: Should be `withHost($host)`.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:776
public setPort(?int $port = null): $this Sets the port portion of the URI.
/**
* Sets the port portion of the URI.
*
* @return $this
*
* @TODO PSR-7: Should be `withPort($port)`.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:790
public setQuery(string $query): $this Sets the query portion of the URI, while attempting to clean the various part...
/**
* Sets the query portion of the URI, while attempting
* to clean the various parts of the query keys and values.
*
* @return $this
*
* @TODO PSR-7: Should be `withQuery($query)`.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:881
public setQueryArray(array $query): URI A convenience method to pass an array of items in as the Query portion of the...
/**
* A convenience method to pass an array of items in as the Query
* portion of the URI.
*
* @return URI
*
* @TODO: PSR-7: Should be `withQueryParams(array $query)`
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:913
public addQuery(string $key, $value = null): $this Adds a single new element to the query vars.
/**
* Adds a single new element to the query vars.
*
* Note: Method not in PSR-7
*
* @param int|string|null $value
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:929
public stripQuery($params): $this Removes one or more query vars from the URI.
/**
* Removes one or more query vars from the URI.
*
* Note: Method not in PSR-7
*
* @param string ...$params
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:945
public keepQuery($params): $this Filters the query variables so that only the keys passed in are kept. The res...
/**
* Filters the query variables so that only the keys passed in
* are kept. The rest are removed from the object.
*
* Note: Method not in PSR-7
*
* @param string ...$params
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:964
public setFragment(string $string): $this Sets the fragment portion of the URI.
/**
* Sets the fragment portion of the URI.
*
* @see https://tools.ietf.org/html/rfc3986#section-3.5
*
* @return $this
*
* @TODO PSR-7: Should be `withFragment($fragment)`.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:990
protected filterPath(?string $path = null): string Encodes any dangerous characters, and removes dot segments. While dot segment...
/**
* Encodes any dangerous characters, and removes dot segments.
* While dot segments have valid uses according to the spec,
* this URI class does not allow them.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:1002
public resolveRelativeURI(string $uri): URI Combines one URI string with this one based on the rules set out in RFC 3986 ...
/**
* Combines one URI string with this one based on the rules set out in
* RFC 3986 Section 2
*
* @see http://tools.ietf.org/html/rfc3986#section-5.2
*
* @return URI
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:1087
protected mergePaths(self $base, self $reference): string Given 2 paths, will merge them according to rules set out in RFC 2986, Sectio...
/**
* Given 2 paths, will merge them according to rules set out in RFC 2986,
* Section 5.2
*
* @see http://tools.ietf.org/html/rfc3986#section-5.2.3
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:1143
protected parseStr(string $query): array This is equivalent to the native PHP parse_str() function. This version allow...
/**
* This is equivalent to the native PHP parse_str() function.
* This version allows the dot to be used as a key of the query string.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:1165
private changeSchemeAndPath(string $scheme, string $path): array Change the path (and scheme) assuming URIs with the same host as baseURL shou...
/**
* Change the path (and scheme) assuming URIs with the same host as baseURL
* should be relative to the project's configuration.
*
* @deprecated This method will be deleted.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:651
public static CodeIgniter\HTTP\URI::createURIString(?string $scheme = null, ?string $authority = null, ?string $path = null, ?string $query = null, ?string $fragment = null): string Builds a representation of the string from the component parts.
/**
* Builds a representation of the string from the component parts.
*
* @param string|null $scheme URI scheme. E.g., http, ftp
*
* @return string URI string with only passed parts. Maybe incomplete as a URI.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:161
public static CodeIgniter\HTTP\URI::removeDotSegments(string $path): string Used when resolving and merging paths to correctly interpret and remove singl...
/**
* Used when resolving and merging paths to correctly interpret and
* remove single and double dot segments from the path per
* RFC 3986 Section 5.2.4
*
* @see http://tools.ietf.org/html/rfc3986#section-5.2.4
*
* @internal
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/HTTP/URI.php:203
public const CodeIgniter\HTTP\URI::CHAR_SUB_DELIMS :: string (16) "!\$&'\(\)\*\+,;="
public const CodeIgniter\HTTP\URI::CHAR_UNRESERVED :: string (15) "a-zA-Z0-9_\-\.~"
uri string (50) "https://conmenu.com/menus/provincia/0737-salamanca"
public __construct() Will attempt to get environment variables with names that match the propertie...
/**
* Will attempt to get environment variables with names
* that match the properties of the child class.
*
* The "shortPrefix" is the lowercase-only config class name.
*/
Inherited from CodeIgniter\Config\BaseConfig
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Config/BaseConfig.php:114
/**
* Retrieve an environment-specific configuration setting
*
* @return string|null
*/
Inherited from CodeIgniter\Config\BaseConfig
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Config/BaseConfig.php:189
protected registerProperties(): void Provides external libraries a simple way to register one or more options into...
/**
* Provides external libraries a simple way to register one or more
* options into a config file.
*
* @return void
*
* @throws ReflectionException
*/
Inherited from CodeIgniter\Config\BaseConfig
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Config/BaseConfig.php:237
public static CodeIgniter\Config\BaseConfig::__set_state(array $array)
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Config/BaseConfig.php:72
public static CodeIgniter\Config\BaseConfig::setModules(Config\Modules $modules): void
/**
* @internal For testing purposes only.
* @testTag
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Config/BaseConfig.php:91
public static CodeIgniter\Config\BaseConfig::reset(): void
/**
* @internal For testing purposes only.
* @testTag
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Config/BaseConfig.php:100
public static CodeIgniter\Config\BaseConfig::$registrars :: array (0)
public static CodeIgniter\Config\BaseConfig::$override :: boolean true
Inherited from CodeIgniter\Modules\Modules
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Modules/Modules.php:46
public shouldDiscover(string $alias): bool Should the application auto-discover the requested resource.
/**
* Should the application auto-discover the requested resource.
*/
Inherited from CodeIgniter\Modules\Modules
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Modules/Modules.php:54
public static CodeIgniter\Modules\Modules::__set_state(array $array)
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Modules/Modules.php:63
public initialize(Config\Autoload $config, Config\Modules $modules): $this Reads in the configuration array (described above) and stores the valid parts...
/**
* Reads in the configuration array (described above) and stores
* the valid parts that we'll need.
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/Autoloader.php:102
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/Autoloader.php:137
public register(): void Register the loader with the SPL autoloader stack.
/**
* Register the loader with the SPL autoloader stack.
*
* @return void
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/Autoloader.php:162
public unregister(): void Unregister autoloader.
/**
* Unregister autoloader.
*
* This method is for testing.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/Autoloader.php:181
public addNamespace($namespace, ?string $path = null): $this Registers namespaces with the autoloader.
/**
* Registers namespaces with the autoloader.
*
* @param array<string, list<string>|string>|string $namespace
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/Autoloader.php:194
public getNamespace(?string $prefix = null): array<string, list<string>>|list<string> Get namespaces with prefixes as keys and paths as values.
/**
* Get namespaces with prefixes as keys and paths as values.
*
* If a prefix param is set, returns only paths to the given prefix.
*
* @return array<string, list<string>>|list<string>
* @phpstan-return ($prefix is null ? array<string, list<string>> : list<string>)
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/Autoloader.php:225
public removeNamespace(string $namespace): $this Removes a single namespace from the psr4 settings.
/**
* Removes a single namespace from the psr4 settings.
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/Autoloader.php:239
public loadClassmap(string $class): void Load a class using available class mapping.
/**
* Load a class using available class mapping.
*
* @internal For `spl_autoload_register` use.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/Autoloader.php:253
public loadClass(string $class): void Loads the class file for a given class name.
/**
* Loads the class file for a given class name.
*
* @internal For `spl_autoload_register` use.
*
* @param string $class The fully qualified class name.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/Autoloader.php:269
protected loadInNamespace(string $class): false|string The mapped file name on success, or boolean false on fail Loads the class file for a given class name.
/**
* Loads the class file for a given class name.
*
* @param string $class The fully-qualified class name
*
* @return false|string The mapped file name on success, or boolean false on fail
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/Autoloader.php:281
protected includeFile(string $file): false|string The filename on success, false if the file is not loaded A central way to include a file. Split out primarily for testing purposes.
/**
* A central way to include a file. Split out primarily for testing purposes.
*
* @return false|string The filename on success, false if the file is not loaded
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/Autoloader.php:313
public sanitizeFilename(string $filename): string Check file path.
/**
* Check file path.
*
* Checks special characters that are illegal in filenames on certain
* operating systems and special characters requiring special escaping
* to manipulate at the command line. Replaces spaces and consecutive
* dashes with a single dash. Trim period, dash and underscore from beginning
* and end of filename.
*
* @return string The sanitized filename
*
* @deprecated No longer used. See https://github.com/codeigniter4/CodeIgniter4/issues/7055
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/Autoloader.php:337
/**
* @param array{only?: list<string>, exclude?: list<string>} $composerPackages
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/Autoloader.php:372
protected discoverComposerNamespaces(): void Locates autoload information from Composer, if available.
/**
* Locates autoload information from Composer, if available.
*
* @deprecated No longer used.
*
* @return void
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/Autoloader.php:453
public loadHelpers(): void Loads helpers
/**
* Loads helpers
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/Autoloader.php:487
public initializeKint(bool $debug = false): void Initializes Kint
/**
* Initializes Kint
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/Autoloader.php:495
private autoloadKint(): void
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/Autoloader.php:508
private configureKint(): void
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/Autoloader.php:530
private invalidClassnames -> array (0)
public __construct(CodeIgniter\Autoloader\Autoloader $autoloader)
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/FileLocator.php:38
public locateFile(string $file, ?string $folder = null, string $ext = 'php'): false|string The path to the file, or false if not found. Attempts to locate a file by examining the name for a namespace and looking t...
/**
* Attempts to locate a file by examining the name for a namespace
* and looking through the PSR-4 namespaced files that we know about.
*
* @param string $file The relative file path or namespaced file to
* locate. If not namespaced, search in the app
* folder.
* @param non-empty-string|null $folder The folder within the namespace that we should
* look for the file. If $file does not contain
* this value, it will be appended to the namespace
* folder.
* @param string $ext The file extension the file should have.
*
* @return false|string The path to the file, or false if not found.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/FileLocator.php:58
public getClassname(string $file): string Examines a file and returns the fully qualified class name.
/**
* Examines a file and returns the fully qualified class name.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/FileLocator.php:129
public search(string $path, string $ext = 'php', bool $prioritizeApp = true): array Searches through all of the defined namespaces looking for a file. Returns an...
/**
* Searches through all of the defined namespaces looking for a file.
* Returns an array of all found locations for the defined file.
*
* Example:
*
* $locator->search('Config/Routes.php');
* // Assuming PSR4 namespaces include foo and bar, might return:
* [
* 'app/Modules/foo/Config/Routes.php',
* 'app/Modules/bar/Config/Routes.php',
* ]
*
* @return list<string>
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/FileLocator.php:189
protected ensureExt(string $path, string $ext): string Ensures a extension is at the end of a filename
/**
* Ensures a extension is at the end of a filename
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/FileLocator.php:223
protected getNamespaces(): array<int, array<string, string>> Return the namespace mappings we know about.
/**
* Return the namespace mappings we know about.
*
* @return array<int, array<string, string>>
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/FileLocator.php:241
public findQualifiedNameFromPath(string $path): false|string The qualified name or false if the path is not found Find the qualified name of a file according to the namespace of the first mat...
/**
* Find the qualified name of a file according to
* the namespace of the first matched namespace path.
*
* @return false|string The qualified name or false if the path is not found
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/FileLocator.php:275
public listFiles(string $path): array Scans the defined namespaces, returning a list of all files that are containe...
/**
* Scans the defined namespaces, returning a list of all files
* that are contained within the subpath specified by $path.
*
* @return list<string> List of file paths
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/FileLocator.php:328
public listNamespaceFiles(string $prefix, string $path): array Scans the provided namespace, returning a list of all files that are containe...
/**
* Scans the provided namespace, returning a list of all files
* that are contained within the sub path specified by $path.
*
* @return list<string> List of file paths
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/FileLocator.php:362
protected legacyLocate(string $file, ?string $folder = null): false|string The path to the file, or false if not found. Checks the app folder to see if the file can be found. Only for use with file...
/**
* Checks the app folder to see if the file can be found.
* Only for use with filenames that DO NOT include namespacing.
*
* @param non-empty-string|null $folder
*
* @return false|string The path to the file, or false if not found.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Autoloader/FileLocator.php:399
public __construct($config, bool $debug = true) Constructor.
/**
* Constructor.
*
* @param \Config\Logger $config
*
* @throws RuntimeException
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Log/Logger.php:124
public emergency(Stringable|string $message, array $context = array()): void System is unusable.
/**
* System is unusable.
*
* @param string $message
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Log/Logger.php:162
public alert(Stringable|string $message, array $context = array()): void Action must be taken immediately.
/**
* Action must be taken immediately.
*
* Example: Entire website down, database unavailable, etc. This should
* trigger the SMS alerts and wake you up.
*
* @param string $message
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Log/Logger.php:175
public critical(Stringable|string $message, array $context = array()): void Critical conditions.
public error(Stringable|string $message, array $context = array()): void Runtime errors that do not require immediate action but should typically be l...
/**
* Runtime errors that do not require immediate action but should typically
* be logged and monitored.
*
* @param string $message
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Log/Logger.php:198
public warning(Stringable|string $message, array $context = array()): void Exceptional occurrences that are not errors.
/**
* Exceptional occurrences that are not errors.
*
* Example: Use of deprecated APIs, poor use of an API, undesirable things
* that are not necessarily wrong.
*
* @param string $message
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Log/Logger.php:211
public notice(Stringable|string $message, array $context = array()): void Normal but significant events.
/**
* Normal but significant events.
*
* @param string $message
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Log/Logger.php:221
public info(Stringable|string $message, array $context = array()): void Interesting events.
/**
* Interesting events.
*
* Example: User logs in, SQL logs.
*
* @param string $message
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Log/Logger.php:233
/**
* Detailed debug information.
*
* @param string $message
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Log/Logger.php:243
public log($level, Stringable|string $message, array $context = array()): void Logs with an arbitrary level.
/**
* Logs with an arbitrary level.
*
* @param string $level
* @param string $message
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Log/Logger.php:254
protected interpolate($message, array $context = array()): string Replaces any placeholders in the message with variables from the context, as ...
/**
* Replaces any placeholders in the message with variables
* from the context, as well as a few special items like:
*
* {session_vars}
* {post_vars}
* {get_vars}
* {env}
* {env:foo}
* {file}
* {line}
*
* @param string $message
*
* @return string
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Log/Logger.php:318
public determineFile(): array Determines the file and line that the logging call was made from by analyzing...
/**
* Determines the file and line that the logging call
* was made from by analyzing the backtrace.
* Find the earliest stack frame that is part of our logging system.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Log/Logger.php:374
public __construct() Merge the built-in and developer-configured filters and plugins, with prefere...
/**
* Merge the built-in and developer-configured filters and plugins,
* with preference to the developer ones.
*/
Inherited from CodeIgniter\Config\View
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Config/View.php:129
/**
* Retrieve an environment-specific configuration setting
*
* @return string|null
*/
Inherited from CodeIgniter\Config\BaseConfig
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Config/BaseConfig.php:189
protected registerProperties(): void Provides external libraries a simple way to register one or more options into...
/**
* Provides external libraries a simple way to register one or more
* options into a config file.
*
* @return void
*
* @throws ReflectionException
*/
Inherited from CodeIgniter\Config\BaseConfig
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Config/BaseConfig.php:237
public static CodeIgniter\Config\BaseConfig::__set_state(array $array)
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Config/BaseConfig.php:72
public static CodeIgniter\Config\BaseConfig::setModules(Config\Modules $modules): void
/**
* @internal For testing purposes only.
* @testTag
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Config/BaseConfig.php:91
public static CodeIgniter\Config\BaseConfig::reset(): void
/**
* @internal For testing purposes only.
* @testTag
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Config/BaseConfig.php:100
public static CodeIgniter\Config\BaseConfig::$registrars :: array (0)
public static CodeIgniter\Config\BaseConfig::$override :: boolean true
Inherited from CodeIgniter\Modules\Modules
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Modules/Modules.php:46
public shouldDiscover(string $alias): bool Should the application auto-discover the requested resource.
/**
* Should the application auto-discover the requested resource.
*/
Inherited from CodeIgniter\Modules\Modules
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Modules/Modules.php:54
public static CodeIgniter\Modules\Modules::__set_state(array $array)
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Modules/Modules.php:63
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/View/View.php:135
public render(string $view, ?array $options = null, ?bool $saveData = null): string Builds the output based upon a file name and any data that has already been set.
/**
* Builds the output based upon a file name and any
* data that has already been set.
*
* Valid $options:
* - cache Number of seconds to cache for
* - cache_name Name to use for cache
*
* @param string $view File name of the view source
* @param array<string, mixed>|null $options Reserved for 3rd-party uses since
* it might be needed to pass additional info
* to other template engines.
* @param bool|null $saveData If true, saves data for subsequent calls,
* if false, cleans the data after displaying,
* if null, uses the config setting.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/View/View.php:166
public renderString(string $view, ?array $options = null, ?bool $saveData = null): string Builds the output based upon a string and any data that has already been set....
/**
* Builds the output based upon a string and any
* data that has already been set.
* Cache does not apply, because there is no "key".
*
* @param string $view The view contents
* @param array<string, mixed>|null $options Reserved for 3rd-party uses since
* it might be needed to pass additional info
* to other template engines.
* @param bool|null $saveData If true, saves data for subsequent calls,
* if false, cleans the data after displaying,
* if null, uses the config setting.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/View/View.php:307
public excerpt(string $string, int $length = 20): string Extract first bit of a long string and add ellipsis
/**
* Extract first bit of a long string and add ellipsis
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/View/View.php:330
public setData(array $data = array(), ?string $context = null): CodeIgniter\View\RendererInterface Sets several pieces of view data at once.
/**
* Sets several pieces of view data at once.
*
* @param non-empty-string|null $context The context to escape it for.
* If 'raw', no escaping will happen.
* @phpstan-param null|'html'|'js'|'css'|'url'|'attr'|'raw' $context
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/View/View.php:342
public setVar(string $name, $value = null, ?string $context = null): CodeIgniter\View\RendererInterface Sets a single piece of view data.
/**
* Sets a single piece of view data.
*
* @param mixed $value
* @param non-empty-string|null $context The context to escape it for.
* If 'raw', no escaping will happen.
* @phpstan-param null|'html'|'js'|'css'|'url'|'attr'|'raw' $context
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/View/View.php:362
public resetData(): CodeIgniter\View\RendererInterface Removes all of the view data from the system.
/**
* Removes all of the view data from the system.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/View/View.php:377
public getData(): array Returns the current data that will be displayed in the view.
/**
* Returns the current data that will be displayed in the view.
*
* @return array<string, mixed>
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/View/View.php:389
public extend(string $layout): void Specifies that the current view should extend an existing layout.
/**
* Specifies that the current view should extend an existing layout.
*
* @return void
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/View/View.php:399
public section(string $name): void Starts holds content for a section within the layout.
/**
* Starts holds content for a section within the layout.
*
* @param string $name Section name
*
* @return void
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/View/View.php:411
public endSection(): void Captures the last section
/**
* Captures the last section
*
* @return void
*
* @throws RuntimeException
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/View/View.php:425
public renderSection(string $sectionName, bool $saveData = false): string Renders a section's contents.
/**
* Renders a section's contents.
*
* @param bool $saveData If true, saves data for subsequent calls,
* if false, cleans the data after displaying.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/View/View.php:449
public include(string $view, ?array $options = null, $saveData = true): string Used within layout views to include additional views.
/**
* Used within layout views to include additional views.
*
* @param array<string, mixed>|null $options
* @param bool $saveData
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/View/View.php:473
public getPerformanceData(): array Returns the performance data that might have been collected during the execut...
/**
* Returns the performance data that might have been collected
* during the execution. Used primarily in the Debug Toolbar.
*
* @return list<array{start: float, end: float, view: string}>
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/View/View.php:484
protected logPerformance(float $start, float $end, string $view): void Logs performance data for rendering a view.
/**
* Logs performance data for rendering a view.
*
* @return void
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/View/View.php:494
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/View/View.php:505
protected decorateOutput(string $html): string Runs the generated output through any declared view decorators.
/**
* Runs the generated output through any declared
* view decorators.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/View/ViewDecoratorTrait.php:25
protected only -> null
public __construct(Config\Pager $config, CodeIgniter\View\RendererInterface $view) Constructor.
new \CodeIgniter\Pager\Pager()
/**
* Constructor.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Pager/Pager.php:72
public links(string $group = 'default', string $template = 'default_full'): string Handles creating and displaying the
$value->links()
/**
* Handles creating and displaying the
*
* @param string $template The output template alias to render.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Pager/Pager.php:83
public simpleLinks(string $group = 'default', string $template = 'default_simple'): string Creates simple Next/Previous links, instead of full pagination.
$value->simpleLinks()
/**
* Creates simple Next/Previous links, instead of full pagination.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Pager/Pager.php:93
public makeLinks(int $page, ?int $perPage, int $total, string $template = 'default_full', int $segment = 0, ?string $group = 'default'): string Allows for a simple, manual, form of pagination where all of the data is prov...
$value->makeLinks()
/**
* Allows for a simple, manual, form of pagination where all of the data
* is provided by the user. The URL is the current URI.
*
* @param string $template The output template alias to render.
* @param int $segment (whether page number is provided by URI segment)
* @param string|null $group optional group (i.e. if we'd like to define custom path)
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Pager/Pager.php:108
protected displayLinks(string $group, string $template): string Does the actual work of displaying the view file. Used internally by links(),...
/**
* Does the actual work of displaying the view file. Used internally
* by links(), simpleLinks(), and makeLinks().
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Pager/Pager.php:121
public store(string $group, int $page, ?int $perPage, int $total, int $segment = 0): $this Stores a set of pagination data for later display. Most commonly used by the ...
$value->store()
/**
* Stores a set of pagination data for later display. Most commonly used
* by the model to automate the process.
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Pager/Pager.php:139
public setSegment(int $number, string $group = 'default'): $this Sets segment for a group.
$value->setSegment()
/**
* Sets segment for a group.
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Pager/Pager.php:167
public setPath(string $path, string $group = 'default'): $this Sets the path that an aliased group of links will use.
$value->setPath()
/**
* Sets the path that an aliased group of links will use.
*
* @return $this
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Pager/Pager.php:183
public getTotal(string $group = 'default'): int Returns the total number of items in data store.
$value->getTotal()
/**
* Returns the total number of items in data store.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Pager/Pager.php:195
public getPageCount(string $group = 'default'): int Returns the total number of pages.
$value->getPageCount()
/**
* Returns the total number of pages.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Pager/Pager.php:205
public getCurrentPage(string $group = 'default'): int Returns the number of the current page of results.
$value->getCurrentPage()
/**
* Returns the number of the current page of results.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Pager/Pager.php:215
public hasMore(string $group = 'default'): bool Tells whether this group of results has any more pages of results.
$value->hasMore()
/**
* Tells whether this group of results has any more pages of results.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Pager/Pager.php:225
public getLastPage(string $group = 'default'): int|null Returns the last page, if we have a total that we can calculate with.
$value->getLastPage()
/**
* Returns the last page, if we have a total that we can calculate with.
*
* @return int|null
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Pager/Pager.php:237
public getFirstPage(string $group = 'default'): int Determines the first page # that should be shown.
$value->getFirstPage()
/**
* Determines the first page # that should be shown.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Pager/Pager.php:251
public getPageURI(?int $page = null, string $group = 'default', bool $returnObject = false): string|URI Returns the URI for a specific page for the specified group.
$value->getPageURI()
/**
* Returns the URI for a specific page for the specified group.
*
* @return string|URI
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Pager/Pager.php:264
public getNextPageURI(string $group = 'default', bool $returnObject = false): string|null Returns the full URI to the next page of results, or null.
$value->getNextPageURI()
/**
* Returns the full URI to the next page of results, or null.
*
* @return string|null
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Pager/Pager.php:307
public getPreviousPageURI(string $group = 'default', bool $returnObject = false): string|null Returns the full URL to the previous page of results, or null.
$value->getPreviousPageURI()
/**
* Returns the full URL to the previous page of results, or null.
*
* @return string|null
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Pager/Pager.php:331
public getPerPage(string $group = 'default'): int Returns the number of results per page that should be shown.
$value->getPerPage()
/**
* Returns the number of results per page that should be shown.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Pager/Pager.php:353
public getDetails(string $group = 'default'): array Returns an array with details about the results, including total, per_page, c...
$value->getDetails()
/**
* Returns an array with details about the results, including
* total, per_page, current_page, last_page, next_url, prev_url, from, to.
* Does not include the actual data. This data is suitable for adding
* a 'data' object to with the result set and converting to JSON.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Pager/Pager.php:366
public only(array $queries): self Sets only allowed queries on pagination links.
$value->only()
/**
* Sets only allowed queries on pagination links.
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Pager/Pager.php:384
protected ensureGroup(string $group, ?int $perPage = null): void Ensures that an array exists for the group specified.
/**
* Ensures that an array exists for the group specified.
*
* @return void
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Pager/Pager.php:396
protected calculateCurrentPage(string $group): void Calculating the current page
/**
* Calculating the current page
*
* @return void
*/
Defined in <ROOT>/system/vendor/codeigniter4/framework/system/Pager/Pager.php:424
perPage
$value integer 4
total
$value integer 2
breadcrumb_items
<li class="breadcrumb-item">CCAA
<a href="/menus/ccaa/07-castilla-y-leon" class="text-decoration-none">Castilla y León</a>
</li>
<li class="breadcrumb-item active" aria-current="page">Province
<a href="#" class="text-decoration-none text-dark" data-bs-toggle="modal" data-bs-target="#provinciaModal"><strong>Salamanca (2)</strong></a>
</li>
<li class="breadcrumb-item">
<a href="#" class="text-decoration-none text-primary" data-bs-toggle="modal" data-bs-target="#nucleosModal">
County <i class="fa-solid fa-angle-down"></i>
</a>
</li>
<li class="breadcrumb-item">
<a href="#" class="text-decoration-none text-primary" data-bs-toggle="modal" data-bs-target="#municipiosModal">
Municipality <i class="fa-solid fa-angle-down"></i>
</a>
</li>
<div class="modal fade" id="nucleosModal" tabindex="-1" aria-labelledby="nucleosModalLabel" aria-hidden="true">
<div class="modal-dialog modal-lg modal-dialog-centered modal-dialog-scrollable">
<div class="modal-content border-0 shadow-lg">
<div class="modal-header bg-light">
<h6 class="modal-title text-center w-100" id="nucleosModalLabel">
Counties in Province <span id="nombrePoblacion">Salamanca</span>
</h6>
</div>
<div class="modal-body p-2">
<div class="list-group small" id="listaNucleos">
<div class='list-group-item'><a href='/menus/comarca/073706-alba-de-tormes' class='text-dark'>Alba de Tormes</a></div><div class='list-group-item'><a href='/menus/comarca/073707-ciudad-rodrigo' class='text-dark'>Ciudad Rodrigo</a></div><div class='list-group-item'><a href='/menus/comarca/073705-fuente-de-san-esteban' class='text-dark'>Fuente de San Esteban</a></div><div class='list-group-item'><a href='/menus/comarca/073708-la-sierra' class='text-dark'>La Sierra</a></div><div class='list-group-item'><a href='/menus/comarca/073702-ledesma' class='text-dark'>Ledesma</a></div><div class='list-group-item'><a href='/menus/comarca/073704-penaranda-de-bracamonte' class='text-dark'>Peñaranda de Bracamonte</a></div><div class='list-group-item'><a href='/menus/comarca/073703-salamanca' class='text-dark'>Salamanca</a></div><div class='list-group-item'><a href='/menus/comarca/073701-vitigudino' class='text-dark'>Vitigudino</a></div>
</div>
</div>
</div>
</div>
</div>
<div class="modal fade" id="provinciaModal" tabindex="-1" aria-labelledby="provinciaModalLabel" aria-hidden="true">
<div class="modal-dialog modal-lg modal-dialog-centered modal-dialog-scrollable">
<div class="modal-content border-0 shadow-lg">
<div class="modal-header bg-light">
<h6 class="modal-title text-center w-100" id="provinciaModalLabel">
Provinces in Castilla y León
</h6>
</div>
<div class="modal-body p-2">
<div class="list-group small" id="listaNucleos">
<div class='list-group-item'><a href='/menus/provincia/0705-avila' class='text-dark'>Avila</a></div><div class='list-group-item'><a href='/menus/provincia/0709-burgos' class='text-dark'>Burgos</a></div><div class='list-group-item'><a href='/menus/provincia/0724-leon' class='text-dark'>León</a></div><div class='list-group-item'><a href='/menus/provincia/0734-palencia' class='text-dark'>Palencia</a></div><div class='list-group-item'><a href='/menus/provincia/0737-salamanca' class='text-dark'>Salamanca</a></div><div class='list-group-item'><a href='/menus/provincia/0740-segovia' class='text-dark'>Segovia</a></div><div class='list-group-item'><a href='/menus/provincia/0742-soria' class='text-dark'>Soria</a></div><div class='list-group-item'><a href='/menus/provincia/0747-valladolid' class='text-dark'>Valladolid</a></div><div class='list-group-item'><a href='/menus/provincia/0749-zamora' class='text-dark'>Zamora</a></div>
</div>
</div>
</div>
</div>
</div>
<div class="modal fade" id="municipiosModal" tabindex="-1" aria-labelledby="municipiosModalLabel" aria-hidden="true">
<div class="modal-dialog modal-lg modal-dialog-centered modal-dialog-scrollable">
<div class="modal-content border-0 shadow-lg">
<div class="modal-header bg-light">
<h6 class="modal-title text-center w-100" id="municipiosModalLabel">
Municipalities in Province <span id="nombrePoblacion">Salamanca</span>
</h6>
</div>
<div class="modal-body p-2">
<div class="list-group small" id="listaNucleos">
<div class='list-group-item'><a href='/menus/municipio/073705001-abusejo' class='text-dark'>ABUSEJO</a></div><div class='list-group-item'><a href='/menus/municipio/073707002-agallas' class='text-dark'>AGALLAS</a></div><div class='list-group-item'><a href='/menus/municipio/073701003-ahigal-de-los-aceiteros' class='text-dark'>AHIGAL DE LOS ACEITEROS</a></div><div class='list-group-item'><a href='/menus/municipio/073701004-ahigal-de-villarino' class='text-dark'>AHIGAL DE VILLARINO</a></div><div class='list-group-item'><a href='/menus/municipio/073707005-alameda-de-gardon-la' class='text-dark'>ALAMEDA DE GARDÓN (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/073707006-alamedilla-la' class='text-dark'>ALAMEDILLA (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/073704007-alaraz' class='text-dark'>ALARAZ</a></div><div class='list-group-item'><a href='/menus/municipio/073706008-alba-de-tormes' class='text-dark'>ALBA DE TORMES</a></div><div class='list-group-item'><a href='/menus/municipio/073707009-alba-de-yeltes' class='text-dark'>ALBA DE YELTES</a></div><div class='list-group-item'><a href='/menus/municipio/073708010-alberca-la' class='text-dark'>ALBERCA (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/073707011-albergueria-de-arganan-la' class='text-dark'>ALBERGUERÍA DE ARGAÑÁN (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/073704012-alconada' class='text-dark'>ALCONADA</a></div><div class='list-group-item'><a href='/menus/municipio/073707015-aldea-del-obispo' class='text-dark'>ALDEA DEL OBISPO</a></div><div class='list-group-item'><a href='/menus/municipio/073708013-aldeacipreste' class='text-dark'>ALDEACIPRESTE</a></div><div class='list-group-item'><a href='/menus/municipio/073701014-aldeadavila-de-la-ribera' class='text-dark'>ALDEADÁVILA DE LA RIBERA</a></div><div class='list-group-item'><a href='/menus/municipio/073703016-aldealengua' class='text-dark'>ALDEALENGUA</a></div><div class='list-group-item'><a href='/menus/municipio/073703017-aldeanueva-de-figueroa' class='text-dark'>ALDEANUEVA DE FIGUEROA</a></div><div class='list-group-item'><a href='/menus/municipio/073708018-aldeanueva-de-la-sierra' class='text-dark'>ALDEANUEVA DE LA SIERRA</a></div><div class='list-group-item'><a href='/menus/municipio/073702019-aldearrodrigo' class='text-dark'>ALDEARRODRIGO</a></div><div class='list-group-item'><a href='/menus/municipio/073703020-aldearrubia' class='text-dark'>ALDEARRUBIA</a></div><div class='list-group-item'><a href='/menus/municipio/073706021-aldeaseca-de-alba' class='text-dark'>ALDEASECA DE ALBA</a></div><div class='list-group-item'><a href='/menus/municipio/073704022-aldeaseca-de-la-frontera' class='text-dark'>ALDEASECA DE LA FRONTERA</a></div><div class='list-group-item'><a href='/menus/municipio/073703023-aldeatejada' class='text-dark'>ALDEATEJADA</a></div><div class='list-group-item'><a href='/menus/municipio/073706024-aldeavieja-de-tormes' class='text-dark'>ALDEAVIEJA DE TORMES</a></div><div class='list-group-item'><a href='/menus/municipio/073705025-aldehuela-de-la-boveda' class='text-dark'>ALDEHUELA DE LA BÓVEDA</a></div><div class='list-group-item'><a href='/menus/municipio/073705026-aldehuela-de-yeltes' class='text-dark'>ALDEHUELA DE YELTES</a></div><div class='list-group-item'><a href='/menus/municipio/073702027-almenara-de-tormes' class='text-dark'>ALMENARA DE TORMES</a></div><div class='list-group-item'><a href='/menus/municipio/073701028-almendra' class='text-dark'>ALMENDRA</a></div><div class='list-group-item'><a href='/menus/municipio/073706029-anaya-de-alba' class='text-dark'>ANAYA DE ALBA</a></div><div class='list-group-item'><a href='/menus/municipio/073702030-anover-de-tormes' class='text-dark'>AÑOVER DE TORMES</a></div><div class='list-group-item'><a href='/menus/municipio/073703031-arabayona-de-mogica' class='text-dark'>ARABAYONA DE MÓGICA</a></div><div class='list-group-item'><a href='/menus/municipio/073703032-arapiles' class='text-dark'>ARAPILES</a></div><div class='list-group-item'><a href='/menus/municipio/073703033-arcediano' class='text-dark'>ARCEDIANO</a></div><div class='list-group-item'><a href='/menus/municipio/073702034-arco-el' class='text-dark'>ARCO (EL)</a></div><div class='list-group-item'><a href='/menus/municipio/073706035-armenteros' class='text-dark'>ARMENTEROS</a></div><div class='list-group-item'><a href='/menus/municipio/073707037-atalaya-la' class='text-dark'>ATALAYA (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/073703038-babilafuente' class='text-dark'>BABILAFUENTE</a></div><div class='list-group-item'><a href='/menus/municipio/073701039-banobarez' class='text-dark'>BAÑOBÁREZ</a></div><div class='list-group-item'><a href='/menus/municipio/073703040-barbadillo' class='text-dark'>BARBADILLO</a></div><div class='list-group-item'><a href='/menus/municipio/073705041-barbalos' class='text-dark'>BARBALOS</a></div><div class='list-group-item'><a href='/menus/municipio/073701042-barceo' class='text-dark'>BARCEO</a></div><div class='list-group-item'><a href='/menus/municipio/073701044-barruecopardo' class='text-dark'>BARRUECOPARDO</a></div><div class='list-group-item'><a href='/menus/municipio/073708045-bastida-la' class='text-dark'>BASTIDA (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/073708046-bejar' class='text-dark'>BÉJAR</a></div><div class='list-group-item'><a href='/menus/municipio/073706047-belena' class='text-dark'>BELEÑA</a></div><div class='list-group-item'><a href='/menus/municipio/073701049-bermellar' class='text-dark'>BERMELLAR</a></div><div class='list-group-item'><a href='/menus/municipio/073705050-berrocal-de-huebra' class='text-dark'>BERROCAL DE HUEBRA</a></div><div class='list-group-item'><a href='/menus/municipio/073706051-berrocal-de-salvatierra' class='text-dark'>BERROCAL DE SALVATIERRA</a></div><div class='list-group-item'><a href='/menus/municipio/073705052-boada' class='text-dark'>BOADA</a></div><div class='list-group-item'><a href='/menus/municipio/073707054-bodon-el' class='text-dark'>BODÓN (EL)</a></div><div class='list-group-item'><a href='/menus/municipio/073701055-bogajo' class='text-dark'>BOGAJO</a></div><div class='list-group-item'><a href='/menus/municipio/073707056-bouza-la' class='text-dark'>BOUZA (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/073704057-boveda-del-rio-almar' class='text-dark'>BÓVEDA DEL RÍO ALMAR</a></div><div class='list-group-item'><a href='/menus/municipio/073701058-brincones' class='text-dark'>BRINCONES</a></div><div class='list-group-item'><a href='/menus/municipio/073705059-buenamadre' class='text-dark'>BUENAMADRE</a></div><div class='list-group-item'><a href='/menus/municipio/073706060-buenavista' class='text-dark'>BUENAVISTA</a></div><div class='list-group-item'><a href='/menus/municipio/073708061-cabaco-el' class='text-dark'>CABACO (EL)</a></div><div class='list-group-item'><a href='/menus/municipio/073708063-cabeza-de-bejar-la' class='text-dark'>CABEZA DE BÉJAR (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/073701065-cabeza-del-caballo' class='text-dark'>CABEZA DEL CABALLO</a></div><div class='list-group-item'><a href='/menus/municipio/073703062-cabezabellosa-de-la-calzada' class='text-dark'>CABEZABELLOSA DE LA CALZADA</a></div><div class='list-group-item'><a href='/menus/municipio/073703067-cabrerizos' class='text-dark'>CABRERIZOS</a></div><div class='list-group-item'><a href='/menus/municipio/073705068-cabrillas' class='text-dark'>CABRILLAS</a></div><div class='list-group-item'><a href='/menus/municipio/073703069-calvarrasa-de-abajo' class='text-dark'>CALVARRASA DE ABAJO</a></div><div class='list-group-item'><a href='/menus/municipio/073706070-calvarrasa-de-arriba' class='text-dark'>CALVARRASA DE ARRIBA</a></div><div class='list-group-item'><a href='/menus/municipio/073708071-calzada-de-bejar-la' class='text-dark'>CALZADA DE BÉJAR (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/073703072-calzada-de-don-diego' class='text-dark'>CALZADA DE DON DIEGO</a></div><div class='list-group-item'><a href='/menus/municipio/073703073-calzada-de-valdunciel' class='text-dark'>CALZADA DE VALDUNCIEL</a></div><div class='list-group-item'><a href='/menus/municipio/073707074-campillo-de-azaba' class='text-dark'>CAMPILLO DE AZABA</a></div><div class='list-group-item'><a href='/menus/municipio/073704077-campo-de-penaranda-el' class='text-dark'>CAMPO DE PEÑARANDA (EL)</a></div><div class='list-group-item'><a href='/menus/municipio/073708078-candelario' class='text-dark'>CANDELARIO</a></div><div class='list-group-item'><a href='/menus/municipio/073703079-canillas-de-abajo' class='text-dark'>CANILLAS DE ABAJO</a></div><div class='list-group-item'><a href='/menus/municipio/073708080-cantagallo' class='text-dark'>CANTAGALLO</a></div><div class='list-group-item'><a href='/menus/municipio/073704081-cantalapiedra' class='text-dark'>CANTALAPIEDRA</a></div><div class='list-group-item'><a href='/menus/municipio/073704082-cantalpino' class='text-dark'>CANTALPINO</a></div><div class='list-group-item'><a href='/menus/municipio/073704083-cantaracillo' class='text-dark'>CANTARACILLO</a></div><div class='list-group-item'><a href='/menus/municipio/073703085-carbajosa-de-la-sagrada' class='text-dark'>CARBAJOSA DE LA SAGRADA</a></div><div class='list-group-item'><a href='/menus/municipio/073707086-carpio-de-azaba' class='text-dark'>CARPIO DE AZABA</a></div><div class='list-group-item'><a href='/menus/municipio/073703087-carrascal-de-barregas' class='text-dark'>CARRASCAL DE BARREGAS</a></div><div class='list-group-item'><a href='/menus/municipio/073705088-carrascal-del-obispo' class='text-dark'>CARRASCAL DEL OBISPO</a></div><div class='list-group-item'><a href='/menus/municipio/073706089-casafranca' class='text-dark'>CASAFRANCA</a></div><div class='list-group-item'><a href='/menus/municipio/073708090-casas-del-conde-las' class='text-dark'>CASAS DEL CONDE (LAS)</a></div><div class='list-group-item'><a href='/menus/municipio/073707091-casillas-de-flores' class='text-dark'>CASILLAS DE FLORES</a></div><div class='list-group-item'><a href='/menus/municipio/073703092-castellanos-de-moriscos' class='text-dark'>CASTELLANOS DE MORISCOS</a></div><div class='list-group-item'><a href='/menus/municipio/073703185-castellanos-de-villiquera' class='text-dark'>CASTELLANOS DE VILLIQUERA</a></div><div class='list-group-item'><a href='/menus/municipio/073707096-castillejo-de-martin-viejo' class='text-dark'>CASTILLEJO DE MARTÍN VIEJO</a></div><div class='list-group-item'><a href='/menus/municipio/073705097-castraz' class='text-dark'>CASTRAZ</a></div><div class='list-group-item'><a href='/menus/municipio/073708098-cepeda' class='text-dark'>CEPEDA</a></div><div class='list-group-item'><a href='/menus/municipio/073708099-cereceda-de-la-sierra' class='text-dark'>CERECEDA DE LA SIERRA</a></div><div class='list-group-item'><a href='/menus/municipio/073701100-cerezal-de-penahorcada' class='text-dark'>CEREZAL DE PEÑAHORCADA</a></div><div class='list-group-item'><a href='/menus/municipio/073701101-cerralbo' class='text-dark'>CERRALBO</a></div><div class='list-group-item'><a href='/menus/municipio/073708102-cerro-el' class='text-dark'>CERRO (EL)</a></div><div class='list-group-item'><a href='/menus/municipio/073706103-cespedosa-de-tormes' class='text-dark'>CESPEDOSA DE TORMES</a></div><div class='list-group-item'><a href='/menus/municipio/073706114-chagarcia-medianero' class='text-dark'>CHAGARCÍA MEDIANERO</a></div><div class='list-group-item'><a href='/menus/municipio/073708104-cilleros-de-la-bastida' class='text-dark'>CILLEROS DE LA BASTIDA</a></div><div class='list-group-item'><a href='/menus/municipio/073701106-ciperez' class='text-dark'>CIPÉREZ</a></div><div class='list-group-item'><a href='/menus/municipio/073707107-ciudad-rodrigo' class='text-dark'>CIUDAD RODRIGO</a></div><div class='list-group-item'><a href='/menus/municipio/073706108-coca-de-alba' class='text-dark'>COCA DE ALBA</a></div><div class='list-group-item'><a href='/menus/municipio/073708109-colmenar-de-montemayor' class='text-dark'>COLMENAR DE MONTEMAYOR</a></div><div class='list-group-item'><a href='/menus/municipio/073703110-cordovilla' class='text-dark'>CORDOVILLA</a></div><div class='list-group-item'><a href='/menus/municipio/073708112-cristobal' class='text-dark'>CRISTÓBAL</a></div><div class='list-group-item'><a href='/menus/municipio/073701113-cubo-de-don-sancho-el' class='text-dark'>CUBO DE DON SANCHO (EL)</a></div><div class='list-group-item'><a href='/menus/municipio/073707115-dios-le-guarde' class='text-dark'>DIOS LE GUARDE</a></div><div class='list-group-item'><a href='/menus/municipio/073702116-doninos-de-ledesma' class='text-dark'>DOÑINOS DE LEDESMA</a></div><div class='list-group-item'><a href='/menus/municipio/073703117-doninos-de-salamanca' class='text-dark'>DOÑINOS DE SALAMANCA</a></div><div class='list-group-item'><a href='/menus/municipio/073706118-ejeme' class='text-dark'>ÉJEME</a></div><div class='list-group-item'><a href='/menus/municipio/073707119-encina-la' class='text-dark'>ENCINA (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/073702120-encina-de-san-silvestre' class='text-dark'>ENCINA DE SAN SILVESTRE</a></div><div class='list-group-item'><a href='/menus/municipio/073703121-encinas-de-abajo' class='text-dark'>ENCINAS DE ABAJO</a></div><div class='list-group-item'><a href='/menus/municipio/073706122-encinas-de-arriba' class='text-dark'>ENCINAS DE ARRIBA</a></div><div class='list-group-item'><a href='/menus/municipio/073701123-encinasola-de-los-comendadores' class='text-dark'>ENCINASOLA DE LOS COMENDADORES</a></div><div class='list-group-item'><a href='/menus/municipio/073708124-endrinal' class='text-dark'>ENDRINAL</a></div><div class='list-group-item'><a href='/menus/municipio/073708125-escurial-de-la-sierra' class='text-dark'>ESCURIAL DE LA SIERRA</a></div><div class='list-group-item'><a href='/menus/municipio/073701126-espadana' class='text-dark'>ESPADAÑA</a></div><div class='list-group-item'><a href='/menus/municipio/073707127-espeja' class='text-dark'>ESPEJA</a></div><div class='list-group-item'><a href='/menus/municipio/073703128-espino-de-la-orbada' class='text-dark'>ESPINO DE LA ORBADA</a></div><div class='list-group-item'><a href='/menus/municipio/073703129-florida-de-liebana' class='text-dark'>FLORIDA DE LIÉBANA</a></div><div class='list-group-item'><a href='/menus/municipio/073703130-forfoleda' class='text-dark'>FORFOLEDA</a></div><div class='list-group-item'><a href='/menus/municipio/073708131-frades-de-la-sierra' class='text-dark'>FRADES DE LA SIERRA</a></div><div class='list-group-item'><a href='/menus/municipio/073701132-fregeneda-la' class='text-dark'>FREGENEDA (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/073708133-fresnedoso' class='text-dark'>FRESNEDOSO</a></div><div class='list-group-item'><a href='/menus/municipio/073706134-fresno-alhandiga' class='text-dark'>FRESNO ALHÁNDIGA</a></div><div class='list-group-item'><a href='/menus/municipio/073705135-fuente-de-san-esteban-la' class='text-dark'>FUENTE DE SAN ESTEBAN (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/073707136-fuenteguinaldo' class='text-dark'>FUENTEGUINALDO</a></div><div class='list-group-item'><a href='/menus/municipio/073701137-fuenteliante' class='text-dark'>FUENTELIANTE</a></div><div class='list-group-item'><a href='/menus/municipio/073706138-fuenterroble-de-salvatierra' class='text-dark'>FUENTERROBLE DE SALVATIERRA</a></div><div class='list-group-item'><a href='/menus/municipio/073706139-fuentes-de-bejar' class='text-dark'>FUENTES DE BÉJAR</a></div><div class='list-group-item'><a href='/menus/municipio/073707140-fuentes-de-onoro' class='text-dark'>FUENTES DE OÑORO</a></div><div class='list-group-item'><a href='/menus/municipio/073706141-gajates' class='text-dark'>GAJATES</a></div><div class='list-group-item'><a href='/menus/municipio/073703142-galindo-y-perahuy' class='text-dark'>GALINDO Y PERAHUY</a></div><div class='list-group-item'><a href='/menus/municipio/073706143-galinduste' class='text-dark'>GALINDUSTE</a></div><div class='list-group-item'><a href='/menus/municipio/073706144-galisancho' class='text-dark'>GALISANCHO</a></div><div class='list-group-item'><a href='/menus/municipio/073707145-gallegos-de-arganan' class='text-dark'>GALLEGOS DE ARGAÑÁN</a></div><div class='list-group-item'><a href='/menus/municipio/073706146-gallegos-de-solmiron' class='text-dark'>GALLEGOS DE SOLMIRÓN</a></div><div class='list-group-item'><a href='/menus/municipio/073708147-garcibuey' class='text-dark'>GARCIBUEY</a></div><div class='list-group-item'><a href='/menus/municipio/073706148-garcihernandez' class='text-dark'>GARCIHERNÁNDEZ</a></div><div class='list-group-item'><a href='/menus/municipio/073705149-garcirrey' class='text-dark'>GARCIRREY</a></div><div class='list-group-item'><a href='/menus/municipio/073702150-gejuelo-del-barro' class='text-dark'>GEJUELO DEL BARRO</a></div><div class='list-group-item'><a href='/menus/municipio/073702151-golpejas' class='text-dark'>GOLPEJAS</a></div><div class='list-group-item'><a href='/menus/municipio/073703152-gomecello' class='text-dark'>GOMECELLO</a></div><div class='list-group-item'><a href='/menus/municipio/073701154-guadramiro' class='text-dark'>GUADRAMIRO</a></div><div class='list-group-item'><a href='/menus/municipio/073706155-guijo-de-avila' class='text-dark'>GUIJO DE ÁVILA</a></div><div class='list-group-item'><a href='/menus/municipio/073706156-guijuelo' class='text-dark'>GUIJUELO</a></div><div class='list-group-item'><a href='/menus/municipio/073707157-herguijuela-de-ciudad-rodrigo' class='text-dark'>HERGUIJUELA DE CIUDAD RODRIGO</a></div><div class='list-group-item'><a href='/menus/municipio/073708158-herguijuela-de-la-sierra' class='text-dark'>HERGUIJUELA DE LA SIERRA</a></div><div class='list-group-item'><a href='/menus/municipio/073708159-herguijuela-del-campo' class='text-dark'>HERGUIJUELA DEL CAMPO</a></div><div class='list-group-item'><a href='/menus/municipio/073701160-hinojosa-de-duero' class='text-dark'>HINOJOSA DE DUERO</a></div><div class='list-group-item'><a href='/menus/municipio/073708161-horcajo-de-montemayor' class='text-dark'>HORCAJO DE MONTEMAYOR</a></div><div class='list-group-item'><a href='/menus/municipio/073706162-horcajo-medianero' class='text-dark'>HORCAJO MEDIANERO</a></div><div class='list-group-item'><a href='/menus/municipio/073708163-hoya-la' class='text-dark'>HOYA (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/073703164-huerta' class='text-dark'>HUERTA</a></div><div class='list-group-item'><a href='/menus/municipio/073701165-iruelos' class='text-dark'>IRUELOS</a></div><div class='list-group-item'><a href='/menus/municipio/073707166-ituero-de-azaba' class='text-dark'>ITUERO DE AZABA</a></div><div class='list-group-item'><a href='/menus/municipio/073702167-juzbado' class='text-dark'>JUZBADO</a></div><div class='list-group-item'><a href='/menus/municipio/073708168-lagunilla' class='text-dark'>LAGUNILLA</a></div><div class='list-group-item'><a href='/menus/municipio/073706169-larrodrigo' class='text-dark'>LARRODRIGO</a></div><div class='list-group-item'><a href='/menus/municipio/073702170-ledesma' class='text-dark'>LEDESMA</a></div><div class='list-group-item'><a href='/menus/municipio/073708171-ledrada' class='text-dark'>LEDRADA</a></div><div class='list-group-item'><a href='/menus/municipio/073708172-linares-de-riofrio' class='text-dark'>LINARES DE RIOFRÍO</a></div><div class='list-group-item'><a href='/menus/municipio/073701173-lumbrales' class='text-dark'>LUMBRALES</a></div><div class='list-group-item'><a href='/menus/municipio/073703175-machacon' class='text-dark'>MACHACÓN</a></div><div class='list-group-item'><a href='/menus/municipio/073704174-macotera' class='text-dark'>MACOTERA</a></div><div class='list-group-item'><a href='/menus/municipio/073708176-madronal' class='text-dark'>MADROÑAL</a></div><div class='list-group-item'><a href='/menus/municipio/073707177-maillo-el' class='text-dark'>MAÍLLO (EL)</a></div><div class='list-group-item'><a href='/menus/municipio/073704178-malpartida' class='text-dark'>MALPARTIDA</a></div><div class='list-group-item'><a href='/menus/municipio/073704179-mancera-de-abajo' class='text-dark'>MANCERA DE ABAJO</a></div><div class='list-group-item'><a href='/menus/municipio/073701180-manzano-el' class='text-dark'>MANZANO (EL)</a></div><div class='list-group-item'><a href='/menus/municipio/073707181-martiago' class='text-dark'>MARTIAGO</a></div><div class='list-group-item'><a href='/menus/municipio/073705183-martin-de-yeltes' class='text-dark'>MARTÍN DE YELTES</a></div><div class='list-group-item'><a href='/menus/municipio/073706182-martinamor' class='text-dark'>MARTINAMOR</a></div><div class='list-group-item'><a href='/menus/municipio/073701184-masueco' class='text-dark'>MASUECO</a></div><div class='list-group-item'><a href='/menus/municipio/073702186-mata-de-ledesma-la' class='text-dark'>MATA DE LEDESMA (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/073705187-matilla-de-los-canos-del-rio' class='text-dark'>MATILLA DE LOS CAÑOS DEL RÍO</a></div><div class='list-group-item'><a href='/menus/municipio/073706188-maya-la' class='text-dark'>MAYA (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/073705189-membribe-de-la-sierra' class='text-dark'>MEMBRIBE DE LA SIERRA</a></div><div class='list-group-item'><a href='/menus/municipio/073701190-mieza' class='text-dark'>MIEZA</a></div><div class='list-group-item'><a href='/menus/municipio/073701191-milano-el' class='text-dark'>MILANO (EL)</a></div><div class='list-group-item'><a href='/menus/municipio/073703192-miranda-de-azan' class='text-dark'>MIRANDA DE AZÁN</a></div><div class='list-group-item'><a href='/menus/municipio/073708193-miranda-del-castanar' class='text-dark'>MIRANDA DEL CASTAÑAR</a></div><div class='list-group-item'><a href='/menus/municipio/073708194-mogarraz' class='text-dark'>MOGARRAZ</a></div><div class='list-group-item'><a href='/menus/municipio/073708195-molinillo' class='text-dark'>MOLINILLO</a></div><div class='list-group-item'><a href='/menus/municipio/073708196-monforte-de-la-sierra' class='text-dark'>MONFORTE DE LA SIERRA</a></div><div class='list-group-item'><a href='/menus/municipio/073708197-monleon' class='text-dark'>MONLEÓN</a></div><div class='list-group-item'><a href='/menus/municipio/073702198-monleras' class='text-dark'>MONLERAS</a></div><div class='list-group-item'><a href='/menus/municipio/073707199-monsagro' class='text-dark'>MONSAGRO</a></div><div class='list-group-item'><a href='/menus/municipio/073706200-montejo' class='text-dark'>MONTEJO</a></div><div class='list-group-item'><a href='/menus/municipio/073708201-montemayor-del-rio' class='text-dark'>MONTEMAYOR DEL RÍO</a></div><div class='list-group-item'><a href='/menus/municipio/073703202-monterrubio-de-armuna' class='text-dark'>MONTERRUBIO DE ARMUÑA</a></div><div class='list-group-item'><a href='/menus/municipio/073706203-monterrubio-de-la-sierra' class='text-dark'>MONTERRUBIO DE LA SIERRA</a></div><div class='list-group-item'><a href='/menus/municipio/073707204-morasverdes' class='text-dark'>MORASVERDES</a></div><div class='list-group-item'><a href='/menus/municipio/073705205-morille' class='text-dark'>MORILLE</a></div><div class='list-group-item'><a href='/menus/municipio/073703206-morinigo' class='text-dark'>MORÍÑIGO</a></div><div class='list-group-item'><a href='/menus/municipio/073703207-moriscos' class='text-dark'>MORISCOS</a></div><div class='list-group-item'><a href='/menus/municipio/073701208-moronta' class='text-dark'>MORONTA</a></div><div class='list-group-item'><a href='/menus/municipio/073703209-mozarbez' class='text-dark'>MOZÁRBEZ</a></div><div class='list-group-item'><a href='/menus/municipio/073705211-narros-de-matalayegua' class='text-dark'>NARROS DE MATALAYEGUA</a></div><div class='list-group-item'><a href='/menus/municipio/073706213-nava-de-bejar' class='text-dark'>NAVA DE BÉJAR</a></div><div class='list-group-item'><a href='/menus/municipio/073708214-nava-de-francia' class='text-dark'>NAVA DE FRANCIA</a></div><div class='list-group-item'><a href='/menus/municipio/073704215-nava-de-sotrobal' class='text-dark'>NAVA DE SOTROBAL</a></div><div class='list-group-item'><a href='/menus/municipio/073708212-navacarros' class='text-dark'>NAVACARROS</a></div><div class='list-group-item'><a href='/menus/municipio/073706216-navales' class='text-dark'>NAVALES</a></div><div class='list-group-item'><a href='/menus/municipio/073708217-navalmoral-de-bejar' class='text-dark'>NAVALMORAL DE BÉJAR</a></div><div class='list-group-item'><a href='/menus/municipio/073708218-navamorales' class='text-dark'>NAVAMORALES</a></div><div class='list-group-item'><a href='/menus/municipio/073708219-navarredonda-de-la-rinconada' class='text-dark'>NAVARREDONDA DE LA RINCONADA</a></div><div class='list-group-item'><a href='/menus/municipio/073707221-navasfrias' class='text-dark'>NAVASFRÍAS</a></div><div class='list-group-item'><a href='/menus/municipio/073703222-negrilla-de-palencia' class='text-dark'>NEGRILLA DE PALENCIA</a></div><div class='list-group-item'><a href='/menus/municipio/073701223-olmedo-de-camaces' class='text-dark'>OLMEDO DE CAMACES</a></div><div class='list-group-item'><a href='/menus/municipio/073703224-orbada-la' class='text-dark'>ORBADA (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/073703225-pajares-de-la-laguna' class='text-dark'>PAJARES DE LA LAGUNA</a></div><div class='list-group-item'><a href='/menus/municipio/073702226-palacios-del-arzobispo' class='text-dark'>PALACIOS DEL ARZOBISPO</a></div><div class='list-group-item'><a href='/menus/municipio/073704228-palaciosrubios' class='text-dark'>PALACIOSRUBIOS</a></div><div class='list-group-item'><a href='/menus/municipio/073703229-palencia-de-negrilla' class='text-dark'>PALENCIA DE NEGRILLA</a></div><div class='list-group-item'><a href='/menus/municipio/073703230-parada-de-arriba' class='text-dark'>PARADA DE ARRIBA</a></div><div class='list-group-item'><a href='/menus/municipio/073703231-parada-de-rubiales' class='text-dark'>PARADA DE RUBIALES</a></div><div class='list-group-item'><a href='/menus/municipio/073704232-paradinas-de-san-juan' class='text-dark'>PARADINAS DE SAN JUAN</a></div><div class='list-group-item'><a href='/menus/municipio/073707233-pastores' class='text-dark'>PASTORES</a></div><div class='list-group-item'><a href='/menus/municipio/073707234-payo-el' class='text-dark'>PAYO (EL)</a></div><div class='list-group-item'><a href='/menus/municipio/073706235-pedraza-de-alba' class='text-dark'>PEDRAZA DE ALBA</a></div><div class='list-group-item'><a href='/menus/municipio/073706236-pedrosillo-de-alba' class='text-dark'>PEDROSILLO DE ALBA</a></div><div class='list-group-item'><a href='/menus/municipio/073706237-pedrosillo-de-los-aires' class='text-dark'>PEDROSILLO DE LOS AIRES</a></div><div class='list-group-item'><a href='/menus/municipio/073703238-pedrosillo-el-ralo' class='text-dark'>PEDROSILLO EL RALO</a></div><div class='list-group-item'><a href='/menus/municipio/073703239-pedroso-de-la-armuna-el' class='text-dark'>PEDROSO DE LA ARMUÑA (EL)</a></div><div class='list-group-item'><a href='/menus/municipio/073703240-pelabravo' class='text-dark'>PELABRAVO</a></div><div class='list-group-item'><a href='/menus/municipio/073705241-pelarrodriguez' class='text-dark'>PELARRODRÍGUEZ</a></div><div class='list-group-item'><a href='/menus/municipio/073706242-pelayos' class='text-dark'>PELAYOS</a></div><div class='list-group-item'><a href='/menus/municipio/073701243-pena-la' class='text-dark'>PEÑA (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/073708244-penacaballera' class='text-dark'>PEÑACABALLERA</a></div><div class='list-group-item'><a href='/menus/municipio/073707245-penaparda' class='text-dark'>PEÑAPARDA</a></div><div class='list-group-item'><a href='/menus/municipio/073704246-penaranda-de-bracamonte' class='text-dark'>PEÑARANDA DE BRACAMONTE</a></div><div class='list-group-item'><a href='/menus/municipio/073706247-penarandilla' class='text-dark'>PEÑARANDILLA</a></div><div class='list-group-item'><a href='/menus/municipio/073701248-peralejos-de-abajo' class='text-dark'>PERALEJOS DE ABAJO</a></div><div class='list-group-item'><a href='/menus/municipio/073701249-peralejos-de-arriba' class='text-dark'>PERALEJOS DE ARRIBA</a></div><div class='list-group-item'><a href='/menus/municipio/073701250-perena-de-la-ribera' class='text-dark'>PEREÑA DE LA RIBERA</a></div><div class='list-group-item'><a href='/menus/municipio/073708251-peromingo' class='text-dark'>PEROMINGO</a></div><div class='list-group-item'><a href='/menus/municipio/073708252-pinedas' class='text-dark'>PINEDAS</a></div><div class='list-group-item'><a href='/menus/municipio/073703253-pino-de-tormes-el' class='text-dark'>PINO DE TORMES (EL)</a></div><div class='list-group-item'><a href='/menus/municipio/073703254-pitiegua' class='text-dark'>PITIEGUA</a></div><div class='list-group-item'><a href='/menus/municipio/073706255-pizarral' class='text-dark'>PIZARRAL</a></div><div class='list-group-item'><a href='/menus/municipio/073704256-poveda-de-las-cintas' class='text-dark'>POVEDA DE LAS CINTAS</a></div><div class='list-group-item'><a href='/menus/municipio/073701257-pozos-de-hinojo' class='text-dark'>POZOS DE HINOJO</a></div><div class='list-group-item'><a href='/menus/municipio/073707258-puebla-de-azaba' class='text-dark'>PUEBLA DE AZABA</a></div><div class='list-group-item'><a href='/menus/municipio/073708259-puebla-de-san-medel' class='text-dark'>PUEBLA DE SAN MEDEL</a></div><div class='list-group-item'><a href='/menus/municipio/073705260-puebla-de-yeltes' class='text-dark'>PUEBLA DE YELTES</a></div><div class='list-group-item'><a href='/menus/municipio/073708261-puente-del-congosto' class='text-dark'>PUENTE DEL CONGOSTO</a></div><div class='list-group-item'><a href='/menus/municipio/073701262-puertas' class='text-dark'>PUERTAS</a></div><div class='list-group-item'><a href='/menus/municipio/073708263-puerto-de-bejar' class='text-dark'>PUERTO DE BÉJAR</a></div><div class='list-group-item'><a href='/menus/municipio/073707264-puerto-seguro' class='text-dark'>PUERTO SEGURO</a></div><div class='list-group-item'><a href='/menus/municipio/073704265-ragama' class='text-dark'>RÁGAMA</a></div><div class='list-group-item'><a href='/menus/municipio/073701266-redonda-la' class='text-dark'>REDONDA (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/073705267-retortillo' class='text-dark'>RETORTILLO</a></div><div class='list-group-item'><a href='/menus/municipio/073708268-rinconada-de-la-sierra-la' class='text-dark'>RINCONADA DE LA SIERRA (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/073707269-robleda' class='text-dark'>ROBLEDA</a></div><div class='list-group-item'><a href='/menus/municipio/073705270-robliza-de-cojos' class='text-dark'>ROBLIZA DE COJOS</a></div><div class='list-group-item'><a href='/menus/municipio/073702271-rollan' class='text-dark'>ROLLÁN</a></div><div class='list-group-item'><a href='/menus/municipio/073707272-saelices-el-chico' class='text-dark'>SAELICES EL CHICO</a></div><div class='list-group-item'><a href='/menus/municipio/073705273-sagrada-la' class='text-dark'>SAGRADA (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/073707303-sahugo-el' class='text-dark'>SAHUGO (EL)</a></div><div class='list-group-item'><a href='/menus/municipio/073703274-salamanca' class='text-dark'>SALAMANCA</a></div><div class='list-group-item'><a href='/menus/municipio/073701275-saldeana' class='text-dark'>SALDEANA</a></div><div class='list-group-item'><a href='/menus/municipio/073704276-salmoral' class='text-dark'>SALMORAL</a></div><div class='list-group-item'><a href='/menus/municipio/073706277-salvatierra-de-tormes' class='text-dark'>SALVATIERRA DE TORMES</a></div><div class='list-group-item'><a href='/menus/municipio/073703278-san-cristobal-de-la-cuesta' class='text-dark'>SAN CRISTÓBAL DE LA CUESTA</a></div><div class='list-group-item'><a href='/menus/municipio/073708284-san-esteban-de-la-sierra' class='text-dark'>SAN ESTEBAN DE LA SIERRA</a></div><div class='list-group-item'><a href='/menus/municipio/073701285-san-felices-de-los-gallegos' class='text-dark'>SAN FELICES DE LOS GALLEGOS</a></div><div class='list-group-item'><a href='/menus/municipio/073708286-san-martin-del-castanar' class='text-dark'>SAN MARTÍN DEL CASTAÑAR</a></div><div class='list-group-item'><a href='/menus/municipio/073708287-san-miguel-de-valero' class='text-dark'>SAN MIGUEL DE VALERO</a></div><div class='list-group-item'><a href='/menus/municipio/073708036-san-miguel-del-robledo' class='text-dark'>SAN MIGUEL DEL ROBLEDO</a></div><div class='list-group-item'><a href='/menus/municipio/073703288-san-morales' class='text-dark'>SAN MORALES</a></div><div class='list-group-item'><a href='/menus/municipio/073705289-san-munoz' class='text-dark'>SAN MUÑOZ</a></div><div class='list-group-item'><a href='/menus/municipio/073705291-san-pedro-de-rozados' class='text-dark'>SAN PEDRO DE ROZADOS</a></div><div class='list-group-item'><a href='/menus/municipio/073702290-san-pedro-del-valle' class='text-dark'>SAN PEDRO DEL VALLE</a></div><div class='list-group-item'><a href='/menus/municipio/073702292-san-pelayo-de-guarena' class='text-dark'>SAN PELAYO DE GUAREÑA</a></div><div class='list-group-item'><a href='/menus/municipio/073701280-sanchon-de-la-ribera' class='text-dark'>SANCHÓN DE LA RIBERA</a></div><div class='list-group-item'><a href='/menus/municipio/073705281-sanchon-de-la-sagrada' class='text-dark'>SANCHÓN DE LA SAGRADA</a></div><div class='list-group-item'><a href='/menus/municipio/073708282-sanchotello' class='text-dark'>SANCHOTELLO</a></div><div class='list-group-item'><a href='/menus/municipio/073707279-sancti-spiritus' class='text-dark'>SANCTI-SPÍRITUS</a></div><div class='list-group-item'><a href='/menus/municipio/073702283-sando' class='text-dark'>SANDO</a></div><div class='list-group-item'><a href='/menus/municipio/073702293-santa-maria-de-sando' class='text-dark'>SANTA MARÍA DE SANDO</a></div><div class='list-group-item'><a href='/menus/municipio/073703294-santa-marta-de-tormes' class='text-dark'>SANTA MARTA DE TORMES</a></div><div class='list-group-item'><a href='/menus/municipio/073704296-santiago-de-la-puebla' class='text-dark'>SANTIAGO DE LA PUEBLA</a></div><div class='list-group-item'><a href='/menus/municipio/073708297-santibanez-de-bejar' class='text-dark'>SANTIBÁÑEZ DE BÉJAR</a></div><div class='list-group-item'><a href='/menus/municipio/073708298-santibanez-de-la-sierra' class='text-dark'>SANTIBÁÑEZ DE LA SIERRA</a></div><div class='list-group-item'><a href='/menus/municipio/073702299-santiz' class='text-dark'>SANTIZ</a></div><div class='list-group-item'><a href='/menus/municipio/073708300-santos-los' class='text-dark'>SANTOS (LOS)</a></div><div class='list-group-item'><a href='/menus/municipio/073702301-sardon-de-los-frailes' class='text-dark'>SARDÓN DE LOS FRAILES</a></div><div class='list-group-item'><a href='/menus/municipio/073701302-saucelle' class='text-dark'>SAUCELLE</a></div><div class='list-group-item'><a href='/menus/municipio/073705304-sepulcro-hilario' class='text-dark'>SEPULCRO-HILARIO</a></div><div class='list-group-item'><a href='/menus/municipio/073708305-sequeros' class='text-dark'>SEQUEROS</a></div><div class='list-group-item'><a href='/menus/municipio/073707306-serradilla-del-arroyo' class='text-dark'>SERRADILLA DEL ARROYO</a></div><div class='list-group-item'><a href='/menus/municipio/073707307-serradilla-del-llano' class='text-dark'>SERRADILLA DEL LLANO</a></div><div class='list-group-item'><a href='/menus/municipio/073708309-sierpe-la' class='text-dark'>SIERPE (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/073706310-sieteiglesias-de-tormes' class='text-dark'>SIETEIGLESIAS DE TORMES</a></div><div class='list-group-item'><a href='/menus/municipio/073701311-sobradillo' class='text-dark'>SOBRADILLO</a></div><div class='list-group-item'><a href='/menus/municipio/073708312-sorihuela' class='text-dark'>SORIHUELA</a></div><div class='list-group-item'><a href='/menus/municipio/073708313-sotoserrano' class='text-dark'>SOTOSERRANO</a></div><div class='list-group-item'><a href='/menus/municipio/073702314-tabera-de-abajo' class='text-dark'>TABERA DE ABAJO</a></div><div class='list-group-item'><a href='/menus/municipio/073706315-tala-la' class='text-dark'>TALA (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/073705316-tamames' class='text-dark'>TAMAMES</a></div><div class='list-group-item'><a href='/menus/municipio/073704317-tarazona-de-guarena' class='text-dark'>TARAZONA DE GUAREÑA</a></div><div class='list-group-item'><a href='/menus/municipio/073703318-tardaguila' class='text-dark'>TARDÁGUILA</a></div><div class='list-group-item'><a href='/menus/municipio/073708319-tejado-el' class='text-dark'>TEJADO (EL)</a></div><div class='list-group-item'><a href='/menus/municipio/073708320-tejeda-y-segoyuela' class='text-dark'>TEJEDA Y SEGOYUELA</a></div><div class='list-group-item'><a href='/menus/municipio/073707321-tenebron' class='text-dark'>TENEBRÓN</a></div><div class='list-group-item'><a href='/menus/municipio/073706322-terradillos' class='text-dark'>TERRADILLOS</a></div><div class='list-group-item'><a href='/menus/municipio/073703323-topas' class='text-dark'>TOPAS</a></div><div class='list-group-item'><a href='/menus/municipio/073704324-tordillos' class='text-dark'>TORDILLOS</a></div><div class='list-group-item'><a href='/menus/municipio/073708325-tornadizo-el' class='text-dark'>TORNADIZO (EL)</a></div><div class='list-group-item'><a href='/menus/municipio/073703327-torresmenudas' class='text-dark'>TORRESMENUDAS</a></div><div class='list-group-item'><a href='/menus/municipio/073701328-trabanca' class='text-dark'>TRABANCA</a></div><div class='list-group-item'><a href='/menus/municipio/073702329-tremedal-de-tormes' class='text-dark'>TREMEDAL DE TORMES</a></div><div class='list-group-item'><a href='/menus/municipio/073706330-valdecarros' class='text-dark'>VALDECARROS</a></div><div class='list-group-item'><a href='/menus/municipio/073708331-valdefuentes-de-sangusin' class='text-dark'>VALDEFUENTES DE SANGUSÍN</a></div><div class='list-group-item'><a href='/menus/municipio/073708332-valdehijaderos' class='text-dark'>VALDEHIJADEROS</a></div><div class='list-group-item'><a href='/menus/municipio/073708333-valdelacasa' class='text-dark'>VALDELACASA</a></div><div class='list-group-item'><a href='/menus/municipio/073708334-valdelageve' class='text-dark'>VALDELAGEVE</a></div><div class='list-group-item'><a href='/menus/municipio/073702335-valdelosa' class='text-dark'>VALDELOSA</a></div><div class='list-group-item'><a href='/menus/municipio/073706336-valdemierque' class='text-dark'>VALDEMIERQUE</a></div><div class='list-group-item'><a href='/menus/municipio/073701337-valderrodrigo' class='text-dark'>VALDERRODRIGO</a></div><div class='list-group-item'><a href='/menus/municipio/073703338-valdunciel' class='text-dark'>VALDUNCIEL</a></div><div class='list-group-item'><a href='/menus/municipio/073708339-valero' class='text-dark'>VALERO</a></div><div class='list-group-item'><a href='/menus/municipio/073708343-vallejera-de-riofrio' class='text-dark'>VALLEJERA DE RIOFRÍO</a></div><div class='list-group-item'><a href='/menus/municipio/073701340-valsalabroso' class='text-dark'>VALSALABROSO</a></div><div class='list-group-item'><a href='/menus/municipio/073708341-valverde-de-valdelacasa' class='text-dark'>VALVERDE DE VALDELACASA</a></div><div class='list-group-item'><a href='/menus/municipio/073703342-valverdon' class='text-dark'>VALVERDÓN</a></div><div class='list-group-item'><a href='/menus/municipio/073705344-vecinos' class='text-dark'>VECINOS</a></div><div class='list-group-item'><a href='/menus/municipio/073702345-vega-de-tirados' class='text-dark'>VEGA DE TIRADOS</a></div><div class='list-group-item'><a href='/menus/municipio/073705346-veguillas-las' class='text-dark'>VEGUILLAS (LAS)</a></div><div class='list-group-item'><a href='/menus/municipio/073703347-velles-la' class='text-dark'>VELLÉS (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/073704348-ventosa-del-rio-almar' class='text-dark'>VENTOSA DEL RÍO ALMAR</a></div><div class='list-group-item'><a href='/menus/municipio/073701349-vidola-la' class='text-dark'>VÍDOLA (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/073704351-villaflores' class='text-dark'>VILLAFLORES</a></div><div class='list-group-item'><a href='/menus/municipio/073703352-villagonzalo-de-tormes' class='text-dark'>VILLAGONZALO DE TORMES</a></div><div class='list-group-item'><a href='/menus/municipio/073705353-villalba-de-los-llanos' class='text-dark'>VILLALBA DE LOS LLANOS</a></div><div class='list-group-item'><a href='/menus/municipio/073703354-villamayor' class='text-dark'>VILLAMAYOR</a></div><div class='list-group-item'><a href='/menus/municipio/073708355-villanueva-del-conde' class='text-dark'>VILLANUEVA DEL CONDE</a></div><div class='list-group-item'><a href='/menus/municipio/073707356-villar-de-arganan' class='text-dark'>VILLAR DE ARGAÑÁN</a></div><div class='list-group-item'><a href='/menus/municipio/073707357-villar-de-ciervo' class='text-dark'>VILLAR DE CIERVO</a></div><div class='list-group-item'><a href='/menus/municipio/073704358-villar-de-gallimazo' class='text-dark'>VILLAR DE GALLIMAZO</a></div><div class='list-group-item'><a href='/menus/municipio/073707359-villar-de-la-yegua' class='text-dark'>VILLAR DE LA YEGUA</a></div><div class='list-group-item'><a href='/menus/municipio/073701360-villar-de-peralonso' class='text-dark'>VILLAR DE PERALONSO</a></div><div class='list-group-item'><a href='/menus/municipio/073701361-villar-de-samaniego' class='text-dark'>VILLAR DE SAMANIEGO</a></div><div class='list-group-item'><a href='/menus/municipio/073703362-villares-de-la-reina' class='text-dark'>VILLARES DE LA REINA</a></div><div class='list-group-item'><a href='/menus/municipio/073701363-villares-de-yeltes' class='text-dark'>VILLARES DE YELTES</a></div><div class='list-group-item'><a href='/menus/municipio/073701364-villarino-de-los-aires' class='text-dark'>VILLARINO DE LOS AIRES</a></div><div class='list-group-item'><a href='/menus/municipio/073702365-villarmayor' class='text-dark'>VILLARMAYOR</a></div><div class='list-group-item'><a href='/menus/municipio/073701366-villarmuerto' class='text-dark'>VILLARMUERTO</a></div><div class='list-group-item'><a href='/menus/municipio/073701367-villasbuenas' class='text-dark'>VILLASBUENAS</a></div><div class='list-group-item'><a href='/menus/municipio/073702368-villasdardo' class='text-dark'>VILLASDARDO</a></div><div class='list-group-item'><a href='/menus/municipio/073702369-villaseco-de-los-gamitos' class='text-dark'>VILLASECO DE LOS GAMITOS</a></div><div class='list-group-item'><a href='/menus/municipio/073702370-villaseco-de-los-reyes' class='text-dark'>VILLASECO DE LOS REYES</a></div><div class='list-group-item'><a href='/menus/municipio/073707371-villasrubias' class='text-dark'>VILLASRUBIAS</a></div><div class='list-group-item'><a href='/menus/municipio/073703372-villaverde-de-guarena' class='text-dark'>VILLAVERDE DE GUAREÑA</a></div><div class='list-group-item'><a href='/menus/municipio/073701373-villavieja-de-yeltes' class='text-dark'>VILLAVIEJA DE YELTES</a></div><div class='list-group-item'><a href='/menus/municipio/073704374-villoria' class='text-dark'>VILLORIA</a></div><div class='list-group-item'><a href='/menus/municipio/073703375-villoruela' class='text-dark'>VILLORUELA</a></div><div class='list-group-item'><a href='/menus/municipio/073701350-vilvestre' class='text-dark'>VILVESTRE</a></div><div class='list-group-item'><a href='/menus/municipio/073701376-vitigudino' class='text-dark'>VITIGUDINO</a></div><div class='list-group-item'><a href='/menus/municipio/073701377-yecla-de-yeltes' class='text-dark'>YECLA DE YELTES</a></div><div class='list-group-item'><a href='/menus/municipio/073707378-zamarra' class='text-dark'>ZAMARRA</a></div><div class='list-group-item'><a href='/menus/municipio/073702379-zamayon' class='text-dark'>ZAMAYÓN</a></div><div class='list-group-item'><a href='/menus/municipio/073702380-zarapicos' class='text-dark'>ZARAPICOS</a></div><div class='list-group-item'><a href='/menus/municipio/073701381-zarza-de-pumareda-la' class='text-dark'>ZARZA DE PUMAREDA (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/073704382-zorita-de-la-frontera' class='text-dark'>ZORITA DE LA FRONTERA</a></div>
</div>
</div>
</div>
</div>
</div>
Spanish
Inglés
