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 = '0709'
Event: dbquery
Events
0.01 ms
Query
Database
0.13 ms
SELECTCOUNT(*) AS `numrows`
FROM `establecimientos`
WHERE `ID_establecimiento` IN ('1444')
AND `logotipo_establecimiento` ISNOTNULLAND `logotipo_establecimiento` != ''
Event: dbquery
Events
0.01 ms
Query
Database
0.17 ms
SELECT *
FROM `establecimientos`
WHERE `ID_establecimiento` IN ('1444')
AND `logotipo_establecimiento` ISNOTNULLAND `logotipo_establecimiento` != ''
ORDERBY `nombre_establecimiento` ASC, `fecha_creacion_establecimiento` ASCLIMIT 4
Event: dbquery
Events
0.01 ms
Query
Database
0.11 ms
SELECT `nomCVIA`, `numVIA`, `CPOS`, `nomPOB`, `nomPRO`
FROM `establecimientos_localizaciones`
WHERE `ID_establecimiento` = '1444'
Event: dbquery
Events
0.01 ms
Query
Database
0.12 ms
SELECT `URL_foto`
FROM `establecimientos_fotos`
WHERE `ID_establecimiento` = '1444'
ORDERBY `ORDER_foto` ASCLIMIT 1
Event: dbquery
Events
0.01 ms
Query
Database
0.13 ms
SELECT `establecimientos_ambientes`.`ID_ambiente`
FROM `establecimientos_ambientes`
LEFTJOIN `ambientes` ON `ambientes`.`ID_ambiente` = `establecimientos_ambientes`.`ID_ambiente`
WHERE `establecimientos_ambientes`.`ID_establecimiento` = '1444'
Event: dbquery
Events
0.01 ms
Query
Database
0.14 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` = '1444'
Event: dbquery
Events
0.01 ms
Query
Database
0.23 ms
SELECT `establecimientos_caracteristicas`.`ID_caracteristicas`
FROM `establecimientos_caracteristicas`
LEFTJOIN `caracteristicas` ON `caracteristicas`.`ID_caracteristicas` = `establecimientos_caracteristicas`.`ID_caracteristicas`
WHERE `establecimientos_caracteristicas`.`ID_establecimiento` = '1444'
Event: dbquery
Events
0.01 ms
Query
Database
0.15 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` = '1444'
Event: dbquery
Events
0.00 ms
Query
Database
0.13 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` = '1444'
Event: dbquery
Events
0.01 ms
Query
Database
0.09 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` = '1444'
Event: dbquery
Events
0.01 ms
Query
Database
0.08 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` = '1444'
Event: dbquery
Events
0.01 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` = '1444'
Event: dbquery
Events
0.01 ms
Query
Database
0.07 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` = '1444'
Event: dbquery
Events
0.01 ms
Query
Database
0.08 ms
SELECT `establecimientos_idioma`.`ID_idioma`
FROM `establecimientos_idioma`
LEFTJOIN `idiomas` ON `idiomas`.`ID_idioma` = `establecimientos_idioma`.`ID_idioma`
WHERE `establecimientos_idioma`.`ID_establecimiento` = '1444'
Event: dbquery
Events
0.01 ms
Query
Database
0.10 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` = '1444'
Event: dbquery
Events
0.01 ms
Query
Database
0.14 ms
SELECT `ID_establecimiento`, `id_md_diario`
FROM `md_diario`
WHERE `ID_establecimiento` IN ('1444')
AND `md_fecha` = '2025-04-05'
Event: dbquery
Events
0.01 ms
Query
Database
0.12 ms
SELECT `ID_establecimiento`, `id_md_diario`
FROM `md_diario_habituales`
WHERE `ID_establecimiento` IN ('1444')
AND `md_estado` = 1
AND md_fecha_SA=1
Event: dbquery
Events
0.01 ms
Query
Database
6.14 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 (1444)
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 (575,576,577)
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 (1444)
AND md_asignaciones_defecto.ID_establecimiento NOTIN (1444,1444,1444)
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 `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` = '0709'
ORDERBY `ES_provincias`.`nomPRO` ASC
Event: dbquery
Events
0.01 ms
Query
Database
0.22 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` = '0709'
ORDERBY `ES_comarcas`.`nomCOM` ASC
Event: dbquery
Events
0.01 ms
Query
Database
0.12 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
6.15 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` = '0709'
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 = '0709'
SELECTCOUNT(*) AS `numrows`
FROM `establecimientos`
WHERE `ID_establecimiento` IN ('1444')
AND `logotipo_establecimiento` ISNOTNULLAND `logotipo_establecimiento` != ''
SELECT *
FROM `establecimientos`
WHERE `ID_establecimiento` IN ('1444')
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` = '1444'
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` = '1444'
SELECT `establecimientos_caracteristicas`.`ID_caracteristicas`
FROM `establecimientos_caracteristicas`
LEFTJOIN `caracteristicas` ON `caracteristicas`.`ID_caracteristicas` = `establecimientos_caracteristicas`.`ID_caracteristicas`
WHERE `establecimientos_caracteristicas`.`ID_establecimiento` = '1444'
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` = '1444'
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` = '1444'
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` = '1444'
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` = '1444'
SELECT `establecimientos_guias`.`ID_guia`
FROM `establecimientos_guias`
LEFTJOIN `guias` ON `guias`.`ID_guia` = `establecimientos_guias`.`ID_guia`
WHERE `establecimientos_guias`.`ID_establecimiento` = '1444'
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` = '1444'
SELECT `establecimientos_idioma`.`ID_idioma`
FROM `establecimientos_idioma`
LEFTJOIN `idiomas` ON `idiomas`.`ID_idioma` = `establecimientos_idioma`.`ID_idioma`
WHERE `establecimientos_idioma`.`ID_establecimiento` = '1444'
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` = '1444'
(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 (1444)
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 (575,576,577)
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 (1444)
AND md_asignaciones_defecto.ID_establecimiento NOTIN (1444,1444,1444)
AND md_asignaciones_defecto.dia='SA' ANDNOT FIND_IN_SET('MDDG', IFNULL(acronimos_tipologia, ''))
)
En la cuna del lechazo asado, un acogedor mesón de ambiente familiar ofrece a quienes hasta él se acercan un lechazo superior, elaborado lentamente según manda la tradición y desde la experiencia de los mejores maestros asadores.
especialidades_establecimiento -> string (35) "Lechazo asado al estilo tradicional"
In the birthplace of roast lamb, a cozy family atmosphere inn offers a superior who until lamb, slowly made according to tradition and from the experience of the best teachers grills. Approach
especialidades_establecimiento_EN -> string (26) "The traditional roast lamb"
En la cuna del lechazo asado, un acogedor mesón de ambiente familiar ofrece a quienes hasta él se acercan un lechazo superior, elaborado lentamente según manda la tradición y desde la experiencia de los mejores maestros asadores.
especialidades_establecimiento -> string (35) "Lechazo asado al estilo tradicional"
In the birthplace of roast lamb, a cozy family atmosphere inn offers a superior who until lamb, slowly made according to tradition and from the experience of the best teachers grills. Approach
especialidades_establecimiento_EN -> string (26) "The traditional roast lamb"
En la cuna del lechazo asado, un acogedor mesón de ambiente familiar ofrece a quienes hasta él se acercan un lechazo superior, elaborado lentamente según manda la tradición y desde la experiencia de los mejores maestros asadores.
especialidades_establecimiento -> string (35) "Lechazo asado al estilo tradicional"
In the birthplace of roast lamb, a cozy family atmosphere inn offers a superior who until lamb, slowly made according to tradition and from the experience of the best teachers grills. Approach
especialidades_establecimiento_EN -> string (26) "The traditional roast lamb"
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 (47) "https://conmenu.com/menus/provincia/0709-burgos"
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 1
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>Burgos (1)</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">Burgos</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/070905-arlanza' class='text-dark'>Arlanza</a></div><div class='list-group-item'><a href='/menus/comarca/070908-arlanzon' class='text-dark'>Arlanzón</a></div><div class='list-group-item'><a href='/menus/comarca/070902-bureba-ebro' class='text-dark'>Bureba-Ebro</a></div><div class='list-group-item'><a href='/menus/comarca/070903-demanda' class='text-dark'>Demanda</a></div><div class='list-group-item'><a href='/menus/comarca/070904-la-ribera' class='text-dark'>La Ribera</a></div><div class='list-group-item'><a href='/menus/comarca/070901-merindades' class='text-dark'>Merindades</a></div><div class='list-group-item'><a href='/menus/comarca/070907-paramos' class='text-dark'>Páramos</a></div><div class='list-group-item'><a href='/menus/comarca/070906-pisuerga' class='text-dark'>Pisuerga</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">Burgos</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/070902001-abajas' class='text-dark'>ABAJAS</a></div><div class='list-group-item'><a href='/menus/municipio/070904003-adrada-de-haza' class='text-dark'>ADRADA DE HAZA</a></div><div class='list-group-item'><a href='/menus/municipio/070902006-aguas-candidas' class='text-dark'>AGUAS CÁNDIDAS</a></div><div class='list-group-item'><a href='/menus/municipio/070902007-aguilar-de-bureba' class='text-dark'>AGUILAR DE BUREBA</a></div><div class='list-group-item'><a href='/menus/municipio/070908009-albillos' class='text-dark'>ALBILLOS</a></div><div class='list-group-item'><a href='/menus/municipio/070902010-alcocero-de-mola' class='text-dark'>ALCOCERO DE MOLA</a></div><div class='list-group-item'><a href='/menus/municipio/070901011-alfoz-de-bricia' class='text-dark'>ALFOZ DE BRICIA</a></div><div class='list-group-item'><a href='/menus/municipio/070908907-alfoz-de-quintanaduenas' class='text-dark'>ALFOZ DE QUINTANADUEÑAS</a></div><div class='list-group-item'><a href='/menus/municipio/070901012-alfoz-de-santa-gadea' class='text-dark'>ALFOZ DE SANTA GADEA</a></div><div class='list-group-item'><a href='/menus/municipio/070902013-altable' class='text-dark'>ALTABLE</a></div><div class='list-group-item'><a href='/menus/municipio/070907014-altos-los' class='text-dark'>ALTOS (LOS)</a></div><div class='list-group-item'><a href='/menus/municipio/070902016-ameyugo' class='text-dark'>AMEYUGO</a></div><div class='list-group-item'><a href='/menus/municipio/070904017-anguix' class='text-dark'>ANGUIX</a></div><div class='list-group-item'><a href='/menus/municipio/070904018-aranda-de-duero' class='text-dark'>ARANDA DE DUERO</a></div><div class='list-group-item'><a href='/menus/municipio/070904019-arandilla' class='text-dark'>ARANDILLA</a></div><div class='list-group-item'><a href='/menus/municipio/070903020-arauzo-de-miel' class='text-dark'>ARAUZO DE MIEL</a></div><div class='list-group-item'><a href='/menus/municipio/070903021-arauzo-de-salce' class='text-dark'>ARAUZO DE SALCE</a></div><div class='list-group-item'><a href='/menus/municipio/070903022-arauzo-de-torre' class='text-dark'>ARAUZO DE TORRE</a></div><div class='list-group-item'><a href='/menus/municipio/070908023-arcos' class='text-dark'>ARCOS</a></div><div class='list-group-item'><a href='/menus/municipio/070906024-arenillas-de-riopisuerga' class='text-dark'>ARENILLAS DE RIOPISUERGA</a></div><div class='list-group-item'><a href='/menus/municipio/070901025-arija' class='text-dark'>ARIJA</a></div><div class='list-group-item'><a href='/menus/municipio/070908026-arlanzon' class='text-dark'>ARLANZÓN</a></div><div class='list-group-item'><a href='/menus/municipio/070902027-arraya-de-oca' class='text-dark'>ARRAYA DE OCA</a></div><div class='list-group-item'><a href='/menus/municipio/070908029-atapuerca' class='text-dark'>ATAPUERCA</a></div><div class='list-group-item'><a href='/menus/municipio/070908030-ausines-los' class='text-dark'>AUSINES (LOS)</a></div><div class='list-group-item'><a href='/menus/municipio/070905032-avellanosa-de-muno' class='text-dark'>AVELLANOSA DE MUÑÓ</a></div><div class='list-group-item'><a href='/menus/municipio/070905033-bahabon-de-esgueva' class='text-dark'>BAHABÓN DE ESGUEVA</a></div><div class='list-group-item'><a href='/menus/municipio/070906034-balbases-los' class='text-dark'>BALBASES (LOS)</a></div><div class='list-group-item'><a href='/menus/municipio/070904035-banos-de-valdearados' class='text-dark'>BAÑOS DE VALDEARADOS</a></div><div class='list-group-item'><a href='/menus/municipio/070902036-banuelos-de-bureba' class='text-dark'>BAÑUELOS DE BUREBA</a></div><div class='list-group-item'><a href='/menus/municipio/070903037-barbadillo-de-herreros' class='text-dark'>BARBADILLO DE HERREROS</a></div><div class='list-group-item'><a href='/menus/municipio/070903038-barbadillo-del-mercado' class='text-dark'>BARBADILLO DEL MERCADO</a></div><div class='list-group-item'><a href='/menus/municipio/070903039-barbadillo-del-pez' class='text-dark'>BARBADILLO DEL PEZ</a></div><div class='list-group-item'><a href='/menus/municipio/070906041-barrio-de-muno' class='text-dark'>BARRIO DE MUÑÓ</a></div><div class='list-group-item'><a href='/menus/municipio/070902043-barrios-de-bureba-los' class='text-dark'>BARRIOS DE BUREBA (LOS)</a></div><div class='list-group-item'><a href='/menus/municipio/070908044-barrios-de-colina' class='text-dark'>BARRIOS DE COLINA</a></div><div class='list-group-item'><a href='/menus/municipio/070907045-basconcillos-del-tozo' class='text-dark'>BASCONCILLOS DEL TOZO</a></div><div class='list-group-item'><a href='/menus/municipio/070902046-bascunana' class='text-dark'>BASCUÑANA</a></div><div class='list-group-item'><a href='/menus/municipio/070906047-belbimbre' class='text-dark'>BELBIMBRE</a></div><div class='list-group-item'><a href='/menus/municipio/070902048-belorado' class='text-dark'>BELORADO</a></div><div class='list-group-item'><a href='/menus/municipio/070901050-berberana' class='text-dark'>BERBERANA</a></div><div class='list-group-item'><a href='/menus/municipio/070904051-berlangas-de-roa' class='text-dark'>BERLANGAS DE ROA</a></div><div class='list-group-item'><a href='/menus/municipio/070902052-berzosa-de-bureba' class='text-dark'>BERZOSA DE BUREBA</a></div><div class='list-group-item'><a href='/menus/municipio/070902054-bozoo' class='text-dark'>BOZOÓ</a></div><div class='list-group-item'><a href='/menus/municipio/070904055-brazacorta' class='text-dark'>BRAZACORTA</a></div><div class='list-group-item'><a href='/menus/municipio/070902056-briviesca' class='text-dark'>BRIVIESCA</a></div><div class='list-group-item'><a href='/menus/municipio/070902057-bugedo' class='text-dark'>BUGEDO</a></div><div class='list-group-item'><a href='/menus/municipio/070908058-buniel' class='text-dark'>BUNIEL</a></div><div class='list-group-item'><a href='/menus/municipio/070908059-burgos' class='text-dark'>BURGOS</a></div><div class='list-group-item'><a href='/menus/municipio/070902060-busto-de-bureba' class='text-dark'>BUSTO DE BUREBA</a></div><div class='list-group-item'><a href='/menus/municipio/070905061-cabanes-de-esgueva' class='text-dark'>CABAÑES DE ESGUEVA</a></div><div class='list-group-item'><a href='/menus/municipio/070903062-cabezon-de-la-sierra' class='text-dark'>CABEZÓN DE LA SIERRA</a></div><div class='list-group-item'><a href='/menus/municipio/070904064-caleruega' class='text-dark'>CALERUEGA</a></div><div class='list-group-item'><a href='/menus/municipio/070904065-campillo-de-aranda' class='text-dark'>CAMPILLO DE ARANDA</a></div><div class='list-group-item'><a href='/menus/municipio/070903066-campolara' class='text-dark'>CAMPOLARA</a></div><div class='list-group-item'><a href='/menus/municipio/070903067-canicosa-de-la-sierra' class='text-dark'>CANICOSA DE LA SIERRA</a></div><div class='list-group-item'><a href='/menus/municipio/070902068-cantabrana' class='text-dark'>CANTABRANA</a></div><div class='list-group-item'><a href='/menus/municipio/070903070-carazo' class='text-dark'>CARAZO</a></div><div class='list-group-item'><a href='/menus/municipio/070902071-carcedo-de-bureba' class='text-dark'>CARCEDO DE BUREBA</a></div><div class='list-group-item'><a href='/menus/municipio/070908072-carcedo-de-burgos' class='text-dark'>CARCEDO DE BURGOS</a></div><div class='list-group-item'><a href='/menus/municipio/070908073-cardenadijo' class='text-dark'>CARDEÑADIJO</a></div><div class='list-group-item'><a href='/menus/municipio/070908074-cardenajimeno' class='text-dark'>CARDEÑAJIMENO</a></div><div class='list-group-item'><a href='/menus/municipio/070908075-cardenuela-riopico' class='text-dark'>CARDEÑUELA RIOPICO</a></div><div class='list-group-item'><a href='/menus/municipio/070902076-carrias' class='text-dark'>CARRIAS</a></div><div class='list-group-item'><a href='/menus/municipio/070902077-cascajares-de-bureba' class='text-dark'>CASCAJARES DE BUREBA</a></div><div class='list-group-item'><a href='/menus/municipio/070903078-cascajares-de-la-sierra' class='text-dark'>CASCAJARES DE LA SIERRA</a></div><div class='list-group-item'><a href='/menus/municipio/070906079-castellanos-de-castro' class='text-dark'>CASTELLANOS DE CASTRO</a></div><div class='list-group-item'><a href='/menus/municipio/070902083-castil-de-peones' class='text-dark'>CASTIL DE PEONES</a></div><div class='list-group-item'><a href='/menus/municipio/070902082-castildelgado' class='text-dark'>CASTILDELGADO</a></div><div class='list-group-item'><a href='/menus/municipio/070903084-castrillo-de-la-reina' class='text-dark'>CASTRILLO DE LA REINA</a></div><div class='list-group-item'><a href='/menus/municipio/070904085-castrillo-de-la-vega' class='text-dark'>CASTRILLO DE LA VEGA</a></div><div class='list-group-item'><a href='/menus/municipio/070906088-castrillo-de-riopisuerga' class='text-dark'>CASTRILLO DE RIOPISUERGA</a></div><div class='list-group-item'><a href='/menus/municipio/070908086-castrillo-del-val' class='text-dark'>CASTRILLO DEL VAL</a></div><div class='list-group-item'><a href='/menus/municipio/070906090-castrillo-mota-de-judios' class='text-dark'>CASTRILLO MOTA DE JUDÍOS</a></div><div class='list-group-item'><a href='/menus/municipio/070906091-castrojeriz' class='text-dark'>CASTROJERIZ</a></div><div class='list-group-item'><a href='/menus/municipio/070908063-cavia' class='text-dark'>CAVIA</a></div><div class='list-group-item'><a href='/menus/municipio/070908093-cayuela' class='text-dark'>CAYUELA</a></div><div class='list-group-item'><a href='/menus/municipio/070905094-cebrecos' class='text-dark'>CEBRECOS</a></div><div class='list-group-item'><a href='/menus/municipio/070908095-celada-del-camino' class='text-dark'>CELADA DEL CAMINO</a></div><div class='list-group-item'><a href='/menus/municipio/070902098-cerezo-de-rio-tiron' class='text-dark'>CEREZO DE RÍO TIRÓN</a></div><div class='list-group-item'><a href='/menus/municipio/070902100-cerraton-de-juarros' class='text-dark'>CERRATÓN DE JUARROS</a></div><div class='list-group-item'><a href='/menus/municipio/070905101-ciadoncha' class='text-dark'>CIADONCHA</a></div><div class='list-group-item'><a href='/menus/municipio/070902102-cillaperlata' class='text-dark'>CILLAPERLATA</a></div><div class='list-group-item'><a href='/menus/municipio/070905103-cilleruelo-de-abajo' class='text-dark'>CILLERUELO DE ABAJO</a></div><div class='list-group-item'><a href='/menus/municipio/070905104-cilleruelo-de-arriba' class='text-dark'>CILLERUELO DE ARRIBA</a></div><div class='list-group-item'><a href='/menus/municipio/070905105-ciruelos-de-cervera' class='text-dark'>CIRUELOS DE CERVERA</a></div><div class='list-group-item'><a href='/menus/municipio/070905108-cogollos' class='text-dark'>COGOLLOS</a></div><div class='list-group-item'><a href='/menus/municipio/070902109-condado-de-trevino' class='text-dark'>CONDADO DE TREVIÑO</a></div><div class='list-group-item'><a href='/menus/municipio/070903110-contreras' class='text-dark'>CONTRERAS</a></div><div class='list-group-item'><a href='/menus/municipio/070904112-coruna-del-conde' class='text-dark'>CORUÑA DEL CONDE</a></div><div class='list-group-item'><a href='/menus/municipio/070905113-covarrubias' class='text-dark'>COVARRUBIAS</a></div><div class='list-group-item'><a href='/menus/municipio/070908114-cubillo-del-campo' class='text-dark'>CUBILLO DEL CAMPO</a></div><div class='list-group-item'><a href='/menus/municipio/070902115-cubo-de-bureba' class='text-dark'>CUBO DE BUREBA</a></div><div class='list-group-item'><a href='/menus/municipio/070904117-cueva-de-roa-la' class='text-dark'>CUEVA DE ROA (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/070908119-cuevas-de-san-clemente' class='text-dark'>CUEVAS DE SAN CLEMENTE</a></div><div class='list-group-item'><a href='/menus/municipio/070902120-encio' class='text-dark'>ENCÍO</a></div><div class='list-group-item'><a href='/menus/municipio/070903122-espinosa-de-cervera' class='text-dark'>ESPINOSA DE CERVERA</a></div><div class='list-group-item'><a href='/menus/municipio/070901124-espinosa-de-los-monteros' class='text-dark'>ESPINOSA DE LOS MONTEROS</a></div><div class='list-group-item'><a href='/menus/municipio/070902123-espinosa-del-camino' class='text-dark'>ESPINOSA DEL CAMINO</a></div><div class='list-group-item'><a href='/menus/municipio/070908125-estepar' class='text-dark'>ESTÉPAR</a></div><div class='list-group-item'><a href='/menus/municipio/070905127-fontioso' class='text-dark'>FONTIOSO</a></div><div class='list-group-item'><a href='/menus/municipio/070908128-frandovinez' class='text-dark'>FRANDOVÍNEZ</a></div><div class='list-group-item'><a href='/menus/municipio/070903129-fresneda-de-la-sierra-tiron' class='text-dark'>FRESNEDA DE LA SIERRA TIRÓN</a></div><div class='list-group-item'><a href='/menus/municipio/070902130-fresnena' class='text-dark'>FRESNEÑA</a></div><div class='list-group-item'><a href='/menus/municipio/070904131-fresnillo-de-las-duenas' class='text-dark'>FRESNILLO DE LAS DUEÑAS</a></div><div class='list-group-item'><a href='/menus/municipio/070902132-fresno-de-rio-tiron' class='text-dark'>FRESNO DE RÍO TIRÓN</a></div><div class='list-group-item'><a href='/menus/municipio/070908133-fresno-de-rodilla' class='text-dark'>FRESNO DE RODILLA</a></div><div class='list-group-item'><a href='/menus/municipio/070902134-frias' class='text-dark'>FRÍAS</a></div><div class='list-group-item'><a href='/menus/municipio/070902135-fuentebureba' class='text-dark'>FUENTEBUREBA</a></div><div class='list-group-item'><a href='/menus/municipio/070904136-fuentecen' class='text-dark'>FUENTECÉN</a></div><div class='list-group-item'><a href='/menus/municipio/070904137-fuentelcesped' class='text-dark'>FUENTELCÉSPED</a></div><div class='list-group-item'><a href='/menus/municipio/070904138-fuentelisendo' class='text-dark'>FUENTELISENDO</a></div><div class='list-group-item'><a href='/menus/municipio/070904139-fuentemolinos' class='text-dark'>FUENTEMOLINOS</a></div><div class='list-group-item'><a href='/menus/municipio/070904140-fuentenebro' class='text-dark'>FUENTENEBRO</a></div><div class='list-group-item'><a href='/menus/municipio/070904141-fuentespina' class='text-dark'>FUENTESPINA</a></div><div class='list-group-item'><a href='/menus/municipio/070902143-galbarros' class='text-dark'>GALBARROS</a></div><div class='list-group-item'><a href='/menus/municipio/070903144-gallega-la' class='text-dark'>GALLEGA (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/070906148-grijalba' class='text-dark'>GRIJALBA</a></div><div class='list-group-item'><a href='/menus/municipio/070902149-grisalena' class='text-dark'>GRISALEÑA</a></div><div class='list-group-item'><a href='/menus/municipio/070904151-gumiel-de-izan' class='text-dark'>GUMIEL DE IZÁN</a></div><div class='list-group-item'><a href='/menus/municipio/070904152-gumiel-de-mercado' class='text-dark'>GUMIEL DE MERCADO</a></div><div class='list-group-item'><a href='/menus/municipio/070903154-hacinas' class='text-dark'>HACINAS</a></div><div class='list-group-item'><a href='/menus/municipio/070904155-haza' class='text-dark'>HAZA</a></div><div class='list-group-item'><a href='/menus/municipio/070906159-hontanas' class='text-dark'>HONTANAS</a></div><div class='list-group-item'><a href='/menus/municipio/070904160-hontangas' class='text-dark'>HONTANGAS</a></div><div class='list-group-item'><a href='/menus/municipio/070908162-hontoria-de-la-cantera' class='text-dark'>HONTORIA DE LA CANTERA</a></div><div class='list-group-item'><a href='/menus/municipio/070904164-hontoria-de-valdearados' class='text-dark'>HONTORIA DE VALDEARADOS</a></div><div class='list-group-item'><a href='/menus/municipio/070903163-hontoria-del-pinar' class='text-dark'>HONTORIA DEL PINAR</a></div><div class='list-group-item'><a href='/menus/municipio/070906166-hormazas-las' class='text-dark'>HORMAZAS (LAS)</a></div><div class='list-group-item'><a href='/menus/municipio/070908167-hornillos-del-camino' class='text-dark'>HORNILLOS DEL CAMINO</a></div><div class='list-group-item'><a href='/menus/municipio/070904168-horra-la' class='text-dark'>HORRA (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/070903169-hortiguela' class='text-dark'>HORTIGÜELA</a></div><div class='list-group-item'><a href='/menus/municipio/070904170-hoyales-de-roa' class='text-dark'>HOYALES DE ROA</a></div><div class='list-group-item'><a href='/menus/municipio/070907172-huermeces' class='text-dark'>HUÉRMECES</a></div><div class='list-group-item'><a href='/menus/municipio/070903173-huerta-de-arriba' class='text-dark'>HUERTA DE ARRIBA</a></div><div class='list-group-item'><a href='/menus/municipio/070903174-huerta-de-rey' class='text-dark'>HUERTA DE REY</a></div><div class='list-group-item'><a href='/menus/municipio/070907175-humada' class='text-dark'>HUMADA</a></div><div class='list-group-item'><a href='/menus/municipio/070908176-hurones' class='text-dark'>HURONES</a></div><div class='list-group-item'><a href='/menus/municipio/070908177-ibeas-de-juarros' class='text-dark'>IBEAS DE JUARROS</a></div><div class='list-group-item'><a href='/menus/municipio/070902178-ibrillos' class='text-dark'>IBRILLOS</a></div><div class='list-group-item'><a href='/menus/municipio/070905179-iglesiarrubia' class='text-dark'>IGLESIARRUBIA</a></div><div class='list-group-item'><a href='/menus/municipio/070906180-iglesias' class='text-dark'>IGLESIAS</a></div><div class='list-group-item'><a href='/menus/municipio/070908181-isar' class='text-dark'>ISAR</a></div><div class='list-group-item'><a href='/menus/municipio/070906182-itero-del-castillo' class='text-dark'>ITERO DEL CASTILLO</a></div><div class='list-group-item'><a href='/menus/municipio/070903183-jaramillo-de-la-fuente' class='text-dark'>JARAMILLO DE LA FUENTE</a></div><div class='list-group-item'><a href='/menus/municipio/070903184-jaramillo-quemado' class='text-dark'>JARAMILLO QUEMADO</a></div><div class='list-group-item'><a href='/menus/municipio/070901189-junta-de-traslaloma' class='text-dark'>JUNTA DE TRASLALOMA</a></div><div class='list-group-item'><a href='/menus/municipio/070901190-junta-de-villalba-de-losa' class='text-dark'>JUNTA DE VILLALBA DE LOSA</a></div><div class='list-group-item'><a href='/menus/municipio/070903191-jurisdiccion-de-lara' class='text-dark'>JURISDICCIÓN DE LARA</a></div><div class='list-group-item'><a href='/menus/municipio/070901192-jurisdiccion-de-san-zadornil' class='text-dark'>JURISDICCIÓN DE SAN ZADORNIL</a></div><div class='list-group-item'><a href='/menus/municipio/070905194-lerma' class='text-dark'>LERMA</a></div><div class='list-group-item'><a href='/menus/municipio/070902195-llano-de-bureba' class='text-dark'>LLANO DE BUREBA</a></div><div class='list-group-item'><a href='/menus/municipio/070905196-madrigal-del-monte' class='text-dark'>MADRIGAL DEL MONTE</a></div><div class='list-group-item'><a href='/menus/municipio/070905197-madrigalejo-del-monte' class='text-dark'>MADRIGALEJO DEL MONTE</a></div><div class='list-group-item'><a href='/menus/municipio/070905198-mahamud' class='text-dark'>MAHAMUD</a></div><div class='list-group-item'><a href='/menus/municipio/070904199-mambrilla-de-castrejon' class='text-dark'>MAMBRILLA DE CASTREJÓN</a></div><div class='list-group-item'><a href='/menus/municipio/070903200-mambrillas-de-lara' class='text-dark'>MAMBRILLAS DE LARA</a></div><div class='list-group-item'><a href='/menus/municipio/070903201-mamolar' class='text-dark'>MAMOLAR</a></div><div class='list-group-item'><a href='/menus/municipio/070906202-manciles' class='text-dark'>MANCILES</a></div><div class='list-group-item'><a href='/menus/municipio/070905206-mazuela' class='text-dark'>MAZUELA</a></div><div class='list-group-item'><a href='/menus/municipio/070905208-mecerreyes' class='text-dark'>MECERREYES</a></div><div class='list-group-item'><a href='/menus/municipio/070901209-medina-de-pomar' class='text-dark'>MEDINA DE POMAR</a></div><div class='list-group-item'><a href='/menus/municipio/070906211-melgar-de-fernamental' class='text-dark'>MELGAR DE FERNAMENTAL</a></div><div class='list-group-item'><a href='/menus/municipio/070901213-merindad-de-cuesta-urria' class='text-dark'>MERINDAD DE CUESTA-URRIA</a></div><div class='list-group-item'><a href='/menus/municipio/070901214-merindad-de-montija' class='text-dark'>MERINDAD DE MONTIJA</a></div><div class='list-group-item'><a href='/menus/municipio/070908906-merindad-de-rio-ubierna' class='text-dark'>MERINDAD DE RÍO UBIERNA</a></div><div class='list-group-item'><a href='/menus/municipio/070901215-merindad-de-sotoscueva' class='text-dark'>MERINDAD DE SOTOSCUEVA</a></div><div class='list-group-item'><a href='/menus/municipio/070901216-merindad-de-valdeporres' class='text-dark'>MERINDAD DE VALDEPORRES</a></div><div class='list-group-item'><a href='/menus/municipio/070901217-merindad-de-valdivielso' class='text-dark'>MERINDAD DE VALDIVIELSO</a></div><div class='list-group-item'><a href='/menus/municipio/070904218-milagros' class='text-dark'>MILAGROS</a></div><div class='list-group-item'><a href='/menus/municipio/070902219-miranda-de-ebro' class='text-dark'>MIRANDA DE EBRO</a></div><div class='list-group-item'><a href='/menus/municipio/070902220-miraveche' class='text-dark'>MIRAVECHE</a></div><div class='list-group-item'><a href='/menus/municipio/070908221-modubar-de-la-emparedada' class='text-dark'>MODÚBAR DE LA EMPAREDADA</a></div><div class='list-group-item'><a href='/menus/municipio/070903223-monasterio-de-la-sierra' class='text-dark'>MONASTERIO DE LA SIERRA</a></div><div class='list-group-item'><a href='/menus/municipio/070902224-monasterio-de-rodilla' class='text-dark'>MONASTERIO DE RODILLA</a></div><div class='list-group-item'><a href='/menus/municipio/070903225-moncalvillo' class='text-dark'>MONCALVILLO</a></div><div class='list-group-item'><a href='/menus/municipio/070903226-monterrubio-de-la-demanda' class='text-dark'>MONTERRUBIO DE LA DEMANDA</a></div><div class='list-group-item'><a href='/menus/municipio/070907227-montorio' class='text-dark'>MONTORIO</a></div><div class='list-group-item'><a href='/menus/municipio/070904228-moradillo-de-roa' class='text-dark'>MORADILLO DE ROA</a></div><div class='list-group-item'><a href='/menus/municipio/070904229-nava-de-roa' class='text-dark'>NAVA DE ROA</a></div><div class='list-group-item'><a href='/menus/municipio/070902230-navas-de-bureba' class='text-dark'>NAVAS DE BUREBA</a></div><div class='list-group-item'><a href='/menus/municipio/070905231-nebreda' class='text-dark'>NEBREDA</a></div><div class='list-group-item'><a href='/menus/municipio/070903232-neila' class='text-dark'>NEILA</a></div><div class='list-group-item'><a href='/menus/municipio/070904235-olmedillo-de-roa' class='text-dark'>OLMEDILLO DE ROA</a></div><div class='list-group-item'><a href='/menus/municipio/070905236-olmillos-de-muno' class='text-dark'>OLMILLOS DE MUÑÓ</a></div><div class='list-group-item'><a href='/menus/municipio/070902238-ona' class='text-dark'>OÑA</a></div><div class='list-group-item'><a href='/menus/municipio/070904239-oquillas' class='text-dark'>OQUILLAS</a></div><div class='list-group-item'><a href='/menus/municipio/070908241-orbaneja-riopico' class='text-dark'>ORBANEJA RIOPICO</a></div><div class='list-group-item'><a href='/menus/municipio/070906242-padilla-de-abajo' class='text-dark'>PADILLA DE ABAJO</a></div><div class='list-group-item'><a href='/menus/municipio/070906243-padilla-de-arriba' class='text-dark'>PADILLA DE ARRIBA</a></div><div class='list-group-item'><a href='/menus/municipio/070902244-padrones-de-bureba' class='text-dark'>PADRONES DE BUREBA</a></div><div class='list-group-item'><a href='/menus/municipio/070903246-palacios-de-la-sierra' class='text-dark'>PALACIOS DE LA SIERRA</a></div><div class='list-group-item'><a href='/menus/municipio/070906247-palacios-de-riopisuerga' class='text-dark'>PALACIOS DE RIOPISUERGA</a></div><div class='list-group-item'><a href='/menus/municipio/070908248-palazuelos-de-la-sierra' class='text-dark'>PALAZUELOS DE LA SIERRA</a></div><div class='list-group-item'><a href='/menus/municipio/070906249-palazuelos-de-muno' class='text-dark'>PALAZUELOS DE MUÑÓ</a></div><div class='list-group-item'><a href='/menus/municipio/070906250-pampliega' class='text-dark'>PAMPLIEGA</a></div><div class='list-group-item'><a href='/menus/municipio/070902251-pancorbo' class='text-dark'>PANCORBO</a></div><div class='list-group-item'><a href='/menus/municipio/070904253-pardilla' class='text-dark'>PARDILLA</a></div><div class='list-group-item'><a href='/menus/municipio/070902255-partido-de-la-sierra-en-tobalina' class='text-dark'>PARTIDO DE LA SIERRA EN TOBALINA</a></div><div class='list-group-item'><a href='/menus/municipio/070904256-pedrosa-de-duero' class='text-dark'>PEDROSA DE DUERO</a></div><div class='list-group-item'><a href='/menus/municipio/070908259-pedrosa-de-rio-urbel' class='text-dark'>PEDROSA DE RÍO ÚRBEL</a></div><div class='list-group-item'><a href='/menus/municipio/070906257-pedrosa-del-paramo' class='text-dark'>PEDROSA DEL PÁRAMO</a></div><div class='list-group-item'><a href='/menus/municipio/070906258-pedrosa-del-principe' class='text-dark'>PEDROSA DEL PRÍNCIPE</a></div><div class='list-group-item'><a href='/menus/municipio/070904261-penaranda-de-duero' class='text-dark'>PEÑARANDA DE DUERO</a></div><div class='list-group-item'><a href='/menus/municipio/070905262-peral-de-arlanza' class='text-dark'>PERAL DE ARLANZA</a></div><div class='list-group-item'><a href='/menus/municipio/070902265-piernigas' class='text-dark'>PIÉRNIGAS</a></div><div class='list-group-item'><a href='/menus/municipio/070903266-pineda-de-la-sierra' class='text-dark'>PINEDA DE LA SIERRA</a></div><div class='list-group-item'><a href='/menus/municipio/070905267-pineda-trasmonte' class='text-dark'>PINEDA TRASMONTE</a></div><div class='list-group-item'><a href='/menus/municipio/070903268-pinilla-de-los-barruecos' class='text-dark'>PINILLA DE LOS BARRUECOS</a></div><div class='list-group-item'><a href='/menus/municipio/070903269-pinilla-de-los-moros' class='text-dark'>PINILLA DE LOS MOROS</a></div><div class='list-group-item'><a href='/menus/municipio/070905270-pinilla-trasmonte' class='text-dark'>PINILLA TRASMONTE</a></div><div class='list-group-item'><a href='/menus/municipio/070902272-poza-de-la-sal' class='text-dark'>POZA DE LA SAL</a></div><div class='list-group-item'><a href='/menus/municipio/070902273-pradanos-de-bureba' class='text-dark'>PRÁDANOS DE BUREBA</a></div><div class='list-group-item'><a href='/menus/municipio/070903274-pradoluengo' class='text-dark'>PRADOLUENGO</a></div><div class='list-group-item'><a href='/menus/municipio/070905275-presencio' class='text-dark'>PRESENCIO</a></div><div class='list-group-item'><a href='/menus/municipio/070902276-puebla-de-arganzon-la' class='text-dark'>PUEBLA DE ARGANZÓN (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/070905277-puentedura' class='text-dark'>PUENTEDURA</a></div><div class='list-group-item'><a href='/menus/municipio/070904279-quemada' class='text-dark'>QUEMADA</a></div><div class='list-group-item'><a href='/menus/municipio/070904281-quintana-del-pidio' class='text-dark'>QUINTANA DEL PIDIO</a></div><div class='list-group-item'><a href='/menus/municipio/070902280-quintanabureba' class='text-dark'>QUINTANABUREBA</a></div><div class='list-group-item'><a href='/menus/municipio/070902283-quintanaelez' class='text-dark'>QUINTANAÉLEZ</a></div><div class='list-group-item'><a href='/menus/municipio/070908287-quintanaortuno' class='text-dark'>QUINTANAORTUÑO</a></div><div class='list-group-item'><a href='/menus/municipio/070908288-quintanapalla' class='text-dark'>QUINTANAPALLA</a></div><div class='list-group-item'><a href='/menus/municipio/070903289-quintanar-de-la-sierra' class='text-dark'>QUINTANAR DE LA SIERRA</a></div><div class='list-group-item'><a href='/menus/municipio/070902292-quintanavides' class='text-dark'>QUINTANAVIDES</a></div><div class='list-group-item'><a href='/menus/municipio/070905294-quintanilla-de-la-mata' class='text-dark'>QUINTANILLA DE LA MATA</a></div><div class='list-group-item'><a href='/menus/municipio/070905901-quintanilla-del-agua-y-tordueles' class='text-dark'>QUINTANILLA DEL AGUA Y TORDUELES</a></div><div class='list-group-item'><a href='/menus/municipio/070905295-quintanilla-del-coco' class='text-dark'>QUINTANILLA DEL COCO</a></div><div class='list-group-item'><a href='/menus/municipio/070902298-quintanilla-san-garcia' class='text-dark'>QUINTANILLA SAN GARCÍA</a></div><div class='list-group-item'><a href='/menus/municipio/070908301-quintanilla-vivar' class='text-dark'>QUINTANILLA VIVAR</a></div><div class='list-group-item'><a href='/menus/municipio/070908297-quintanillas-las' class='text-dark'>QUINTANILLAS (LAS)</a></div><div class='list-group-item'><a href='/menus/municipio/070903302-rabanera-del-pinar' class='text-dark'>RABANERA DEL PINAR</a></div><div class='list-group-item'><a href='/menus/municipio/070903303-rabanos' class='text-dark'>RÁBANOS</a></div><div class='list-group-item'><a href='/menus/municipio/070908304-rabe-de-las-calzadas' class='text-dark'>RABÉ DE LAS CALZADAS</a></div><div class='list-group-item'><a href='/menus/municipio/070907306-rebolledo-de-la-torre' class='text-dark'>REBOLLEDO DE LA TORRE</a></div><div class='list-group-item'><a href='/menus/municipio/070902307-redecilla-del-camino' class='text-dark'>REDECILLA DEL CAMINO</a></div><div class='list-group-item'><a href='/menus/municipio/070902308-redecilla-del-campo' class='text-dark'>REDECILLA DEL CAMPO</a></div><div class='list-group-item'><a href='/menus/municipio/070903309-regumiel-de-la-sierra' class='text-dark'>REGUMIEL DE LA SIERRA</a></div><div class='list-group-item'><a href='/menus/municipio/070902310-reinoso' class='text-dark'>REINOSO</a></div><div class='list-group-item'><a href='/menus/municipio/070905311-retuerta' class='text-dark'>RETUERTA</a></div><div class='list-group-item'><a href='/menus/municipio/070908314-revilla-del-campo' class='text-dark'>REVILLA DEL CAMPO</a></div><div class='list-group-item'><a href='/menus/municipio/070906316-revilla-vallejera' class='text-dark'>REVILLA VALLEJERA</a></div><div class='list-group-item'><a href='/menus/municipio/070903312-revilla-y-ahedo-la' class='text-dark'>REVILLA Y AHEDO (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/070908315-revillarruz' class='text-dark'>REVILLARRUZ</a></div><div class='list-group-item'><a href='/menus/municipio/070906317-rezmondo' class='text-dark'>REZMONDO</a></div><div class='list-group-item'><a href='/menus/municipio/070903318-riocavado-de-la-sierra' class='text-dark'>RIOCAVADO DE LA SIERRA</a></div><div class='list-group-item'><a href='/menus/municipio/070904321-roa' class='text-dark'>ROA</a></div><div class='list-group-item'><a href='/menus/municipio/070902323-rojas' class='text-dark'>ROJAS</a></div><div class='list-group-item'><a href='/menus/municipio/070905325-royuela-de-rio-franco' class='text-dark'>ROYUELA DE RÍO FRANCO</a></div><div class='list-group-item'><a href='/menus/municipio/070908326-rubena' class='text-dark'>RUBENA</a></div><div class='list-group-item'><a href='/menus/municipio/070902327-rublacedo-de-abajo' class='text-dark'>RUBLACEDO DE ABAJO</a></div><div class='list-group-item'><a href='/menus/municipio/070902328-rucandio' class='text-dark'>RUCANDIO</a></div><div class='list-group-item'><a href='/menus/municipio/070902329-salas-de-bureba' class='text-dark'>SALAS DE BUREBA</a></div><div class='list-group-item'><a href='/menus/municipio/070903330-salas-de-los-infantes' class='text-dark'>SALAS DE LOS INFANTES</a></div><div class='list-group-item'><a href='/menus/municipio/070908332-saldana-de-burgos' class='text-dark'>SALDAÑA DE BURGOS</a></div><div class='list-group-item'><a href='/menus/municipio/070902334-salinillas-de-bureba' class='text-dark'>SALINILLAS DE BUREBA</a></div><div class='list-group-item'><a href='/menus/municipio/070908335-san-adrian-de-juarros' class='text-dark'>SAN ADRIÁN DE JUARROS</a></div><div class='list-group-item'><a href='/menus/municipio/070904337-san-juan-del-monte' class='text-dark'>SAN JUAN DEL MONTE</a></div><div class='list-group-item'><a href='/menus/municipio/070908338-san-mames-de-burgos' class='text-dark'>SAN MAMÉS DE BURGOS</a></div><div class='list-group-item'><a href='/menus/municipio/070904339-san-martin-de-rubiales' class='text-dark'>SAN MARTÍN DE RUBIALES</a></div><div class='list-group-item'><a href='/menus/municipio/070903340-san-millan-de-lara' class='text-dark'>SAN MILLÁN DE LARA</a></div><div class='list-group-item'><a href='/menus/municipio/070903360-san-vicente-del-valle' class='text-dark'>SAN VICENTE DEL VALLE</a></div><div class='list-group-item'><a href='/menus/municipio/070905343-santa-cecilia' class='text-dark'>SANTA CECILIA</a></div><div class='list-group-item'><a href='/menus/municipio/070904345-santa-cruz-de-la-salceda' class='text-dark'>SANTA CRUZ DE LA SALCEDA</a></div><div class='list-group-item'><a href='/menus/municipio/070903346-santa-cruz-del-valle-urbion' class='text-dark'>SANTA CRUZ DEL VALLE URBIÓN</a></div><div class='list-group-item'><a href='/menus/municipio/070902347-santa-gadea-del-cid' class='text-dark'>SANTA GADEA DEL CID</a></div><div class='list-group-item'><a href='/menus/municipio/070905348-santa-ines' class='text-dark'>SANTA INÉS</a></div><div class='list-group-item'><a href='/menus/municipio/070905350-santa-maria-del-campo' class='text-dark'>SANTA MARÍA DEL CAMPO</a></div><div class='list-group-item'><a href='/menus/municipio/070902351-santa-maria-del-invierno' class='text-dark'>SANTA MARÍA DEL INVIERNO</a></div><div class='list-group-item'><a href='/menus/municipio/070905352-santa-maria-del-mercadillo' class='text-dark'>SANTA MARÍA DEL MERCADILLO</a></div><div class='list-group-item'><a href='/menus/municipio/070902353-santa-maria-ribarredonda' class='text-dark'>SANTA MARÍA RIBARREDONDA</a></div><div class='list-group-item'><a href='/menus/municipio/070902354-santa-olalla-de-bureba' class='text-dark'>SANTA OLALLA DE BUREBA</a></div><div class='list-group-item'><a href='/menus/municipio/070905355-santibanez-de-esgueva' class='text-dark'>SANTIBÁÑEZ DE ESGUEVA</a></div><div class='list-group-item'><a href='/menus/municipio/070905356-santibanez-del-val' class='text-dark'>SANTIBÁÑEZ DEL VAL</a></div><div class='list-group-item'><a href='/menus/municipio/070903358-santo-domingo-de-silos' class='text-dark'>SANTO DOMINGO DE SILOS</a></div><div class='list-group-item'><a href='/menus/municipio/070907361-sargentes-de-la-lora' class='text-dark'>SARGENTES DE LA LORA</a></div><div class='list-group-item'><a href='/menus/municipio/070908362-sarracin' class='text-dark'>SARRACÍN</a></div><div class='list-group-item'><a href='/menus/municipio/070906363-sasamon' class='text-dark'>SASAMÓN</a></div><div class='list-group-item'><a href='/menus/municipio/070904365-sequera-de-haza-la' class='text-dark'>SEQUERA DE HAZA (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/070905366-solarana' class='text-dark'>SOLARANA</a></div><div class='list-group-item'><a href='/menus/municipio/070906368-sordillos' class='text-dark'>SORDILLOS</a></div><div class='list-group-item'><a href='/menus/municipio/070904369-sotillo-de-la-ribera' class='text-dark'>SOTILLO DE LA RIBERA</a></div><div class='list-group-item'><a href='/menus/municipio/070908372-sotragero' class='text-dark'>SOTRAGERO</a></div><div class='list-group-item'><a href='/menus/municipio/070906373-sotresgudo' class='text-dark'>SOTRESGUDO</a></div><div class='list-group-item'><a href='/menus/municipio/070908374-susinos-del-paramo' class='text-dark'>SUSINOS DEL PÁRAMO</a></div><div class='list-group-item'><a href='/menus/municipio/070906375-tamaron' class='text-dark'>TAMARÓN</a></div><div class='list-group-item'><a href='/menus/municipio/070908377-tardajos' class='text-dark'>TARDAJOS</a></div><div class='list-group-item'><a href='/menus/municipio/070905378-tejada' class='text-dark'>TEJADA</a></div><div class='list-group-item'><a href='/menus/municipio/070904380-terradillos-de-esgueva' class='text-dark'>TERRADILLOS DE ESGUEVA</a></div><div class='list-group-item'><a href='/menus/municipio/070903381-tinieblas-de-la-sierra' class='text-dark'>TINIEBLAS DE LA SIERRA</a></div><div class='list-group-item'><a href='/menus/municipio/070906382-tobar' class='text-dark'>TOBAR</a></div><div class='list-group-item'><a href='/menus/municipio/070905384-tordomar' class='text-dark'>TORDÓMAR</a></div><div class='list-group-item'><a href='/menus/municipio/070905386-torrecilla-del-monte' class='text-dark'>TORRECILLA DEL MONTE</a></div><div class='list-group-item'><a href='/menus/municipio/070904387-torregalindo' class='text-dark'>TORREGALINDO</a></div><div class='list-group-item'><a href='/menus/municipio/070903388-torrelara' class='text-dark'>TORRELARA</a></div><div class='list-group-item'><a href='/menus/municipio/070905389-torrepadre' class='text-dark'>TORREPADRE</a></div><div class='list-group-item'><a href='/menus/municipio/070905390-torresandino' class='text-dark'>TORRESANDINO</a></div><div class='list-group-item'><a href='/menus/municipio/070905391-tortoles-de-esgueva' class='text-dark'>TÓRTOLES DE ESGUEVA</a></div><div class='list-group-item'><a href='/menus/municipio/070902392-tosantos' class='text-dark'>TOSANTOS</a></div><div class='list-group-item'><a href='/menus/municipio/070901394-trespaderne' class='text-dark'>TRESPADERNE</a></div><div class='list-group-item'><a href='/menus/municipio/070907395-tubilla-del-agua' class='text-dark'>TUBILLA DEL AGUA</a></div><div class='list-group-item'><a href='/menus/municipio/070904396-tubilla-del-lago' class='text-dark'>TUBILLA DEL LAGO</a></div><div class='list-group-item'><a href='/menus/municipio/070907398-urbel-del-castillo' class='text-dark'>ÚRBEL DEL CASTILLO</a></div><div class='list-group-item'><a href='/menus/municipio/070904400-vadocondes' class='text-dark'>VADOCONDES</a></div><div class='list-group-item'><a href='/menus/municipio/070904403-valdeande' class='text-dark'>VALDEANDE</a></div><div class='list-group-item'><a href='/menus/municipio/070904405-valdezate' class='text-dark'>VALDEZATE</a></div><div class='list-group-item'><a href='/menus/municipio/070905406-valdorros' class='text-dark'>VALDORROS</a></div><div class='list-group-item'><a href='/menus/municipio/070902408-vallarta-de-bureba' class='text-dark'>VALLARTA DE BUREBA</a></div><div class='list-group-item'><a href='/menus/municipio/070908904-valle-de-las-navas' class='text-dark'>VALLE DE LAS NAVAS</a></div><div class='list-group-item'><a href='/menus/municipio/070901908-valle-de-losa' class='text-dark'>VALLE DE LOSA</a></div><div class='list-group-item'><a href='/menus/municipio/070901409-valle-de-manzanedo' class='text-dark'>VALLE DE MANZANEDO</a></div><div class='list-group-item'><a href='/menus/municipio/070901410-valle-de-mena' class='text-dark'>VALLE DE MENA</a></div><div class='list-group-item'><a href='/menus/municipio/070902411-valle-de-oca' class='text-dark'>VALLE DE OCA</a></div><div class='list-group-item'><a href='/menus/municipio/070908902-valle-de-santibanez' class='text-dark'>VALLE DE SANTIBÁÑEZ</a></div><div class='list-group-item'><a href='/menus/municipio/070907905-valle-de-sedano' class='text-dark'>VALLE DE SEDANO</a></div><div class='list-group-item'><a href='/menus/municipio/070901412-valle-de-tobalina' class='text-dark'>VALLE DE TOBALINA</a></div><div class='list-group-item'><a href='/menus/municipio/070901413-valle-de-valdebezana' class='text-dark'>VALLE DE VALDEBEZANA</a></div><div class='list-group-item'><a href='/menus/municipio/070903414-valle-de-valdelaguna' class='text-dark'>VALLE DE VALDELAGUNA</a></div><div class='list-group-item'><a href='/menus/municipio/070907415-valle-de-valdelucio' class='text-dark'>VALLE DE VALDELUCIO</a></div><div class='list-group-item'><a href='/menus/municipio/070901416-valle-de-zamanzas' class='text-dark'>VALLE DE ZAMANZAS</a></div><div class='list-group-item'><a href='/menus/municipio/070906417-vallejera' class='text-dark'>VALLEJERA</a></div><div class='list-group-item'><a href='/menus/municipio/070906418-valles-de-palenzuela' class='text-dark'>VALLES DE PALENZUELA</a></div><div class='list-group-item'><a href='/menus/municipio/070902419-valluercanes' class='text-dark'>VALLUÉRCANES</a></div><div class='list-group-item'><a href='/menus/municipio/070903407-valmala' class='text-dark'>VALMALA</a></div><div class='list-group-item'><a href='/menus/municipio/070902422-vid-de-bureba-la' class='text-dark'>VID DE BUREBA (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/070904421-vid-y-barrios-la' class='text-dark'>VID Y BARRIOS (LA)</a></div><div class='list-group-item'><a href='/menus/municipio/070902423-vilena' class='text-dark'>VILEÑA</a></div><div class='list-group-item'><a href='/menus/municipio/070906427-villadiego' class='text-dark'>VILLADIEGO</a></div><div class='list-group-item'><a href='/menus/municipio/070904428-villaescusa-de-roa' class='text-dark'>VILLAESCUSA DE ROA</a></div><div class='list-group-item'><a href='/menus/municipio/070902429-villaescusa-la-sombria' class='text-dark'>VILLAESCUSA LA SOMBRÍA</a></div><div class='list-group-item'><a href='/menus/municipio/070903430-villaespasa' class='text-dark'>VILLAESPASA</a></div><div class='list-group-item'><a href='/menus/municipio/070903431-villafranca-montes-de-oca' class='text-dark'>VILLAFRANCA MONTES DE OCA</a></div><div class='list-group-item'><a href='/menus/municipio/070905432-villafruela' class='text-dark'>VILLAFRUELA</a></div><div class='list-group-item'><a href='/menus/municipio/070903433-villagalijo' class='text-dark'>VILLAGALIJO</a></div><div class='list-group-item'><a href='/menus/municipio/070908434-villagonzalo-pedernales' class='text-dark'>VILLAGONZALO PEDERNALES</a></div><div class='list-group-item'><a href='/menus/municipio/070905437-villahoz' class='text-dark'>VILLAHOZ</a></div><div class='list-group-item'><a href='/menus/municipio/070904438-villalba-de-duero' class='text-dark'>VILLALBA DE DUERO</a></div><div class='list-group-item'><a href='/menus/municipio/070908439-villalbilla-de-burgos' class='text-dark'>VILLALBILLA DE BURGOS</a></div><div class='list-group-item'><a href='/menus/municipio/070904440-villalbilla-de-gumiel' class='text-dark'>VILLALBILLA DE GUMIEL</a></div><div class='list-group-item'><a href='/menus/municipio/070906441-villaldemiro' class='text-dark'>VILLALDEMIRO</a></div><div class='list-group-item'><a href='/menus/municipio/070905442-villalmanzo' class='text-dark'>VILLALMANZO</a></div><div class='list-group-item'><a href='/menus/municipio/070905443-villamayor-de-los-montes' class='text-dark'>VILLAMAYOR DE LOS MONTES</a></div><div class='list-group-item'><a href='/menus/municipio/070906444-villamayor-de-trevino' class='text-dark'>VILLAMAYOR DE TREVIÑO</a></div><div class='list-group-item'><a href='/menus/municipio/070902445-villambistia' class='text-dark'>VILLAMBISTIA</a></div><div class='list-group-item'><a href='/menus/municipio/070906446-villamedianilla' class='text-dark'>VILLAMEDIANILLA</a></div><div class='list-group-item'><a href='/menus/municipio/070908447-villamiel-de-la-sierra' class='text-dark'>VILLAMIEL DE LA SIERRA</a></div><div class='list-group-item'><a href='/menus/municipio/070905448-villangomez' class='text-dark'>VILLANGÓMEZ</a></div><div class='list-group-item'><a href='/menus/municipio/070908449-villanueva-de-argano' class='text-dark'>VILLANUEVA DE ARGAÑO</a></div><div class='list-group-item'><a href='/menus/municipio/070903450-villanueva-de-carazo' class='text-dark'>VILLANUEVA DE CARAZO</a></div><div class='list-group-item'><a href='/menus/municipio/070904451-villanueva-de-gumiel' class='text-dark'>VILLANUEVA DE GUMIEL</a></div><div class='list-group-item'><a href='/menus/municipio/070902454-villanueva-de-teba' class='text-dark'>VILLANUEVA DE TEBA</a></div><div class='list-group-item'><a href='/menus/municipio/070906455-villaquiran-de-la-puebla' class='text-dark'>VILLAQUIRÁN DE LA PUEBLA</a></div><div class='list-group-item'><a href='/menus/municipio/070906456-villaquiran-de-los-infantes' class='text-dark'>VILLAQUIRÁN DE LOS INFANTES</a></div><div class='list-group-item'><a href='/menus/municipio/070901903-villarcayo-de-merindad-de-castilla-la-vieja' class='text-dark'>VILLARCAYO DE MERINDAD DE CASTILLA LA VIEJA</a></div><div class='list-group-item'><a href='/menus/municipio/070908458-villariezo' class='text-dark'>VILLARIEZO</a></div><div class='list-group-item'><a href='/menus/municipio/070906460-villasandino' class='text-dark'>VILLASANDINO</a></div><div class='list-group-item'><a href='/menus/municipio/070903463-villasur-de-herreros' class='text-dark'>VILLASUR DE HERREROS</a></div><div class='list-group-item'><a href='/menus/municipio/070904464-villatuelda' class='text-dark'>VILLATUELDA</a></div><div class='list-group-item'><a href='/menus/municipio/070905466-villaverde-del-monte' class='text-dark'>VILLAVERDE DEL MONTE</a></div><div class='list-group-item'><a href='/menus/municipio/070906467-villaverde-mogina' class='text-dark'>VILLAVERDE-MOGINA</a></div><div class='list-group-item'><a href='/menus/municipio/070908471-villayerno-morquillas' class='text-dark'>VILLAYERNO MORQUILLAS</a></div><div class='list-group-item'><a href='/menus/municipio/070906472-villazopeque' class='text-dark'>VILLAZOPEQUE</a></div><div class='list-group-item'><a href='/menus/municipio/070906473-villegas' class='text-dark'>VILLEGAS</a></div><div class='list-group-item'><a href='/menus/municipio/070903476-villoruebo' class='text-dark'>VILLORUEBO</a></div><div class='list-group-item'><a href='/menus/municipio/070902424-viloria-de-rioja' class='text-dark'>VILORIA DE RIOJA</a></div><div class='list-group-item'><a href='/menus/municipio/070903425-vilviestre-del-pinar' class='text-dark'>VILVIESTRE DEL PINAR</a></div><div class='list-group-item'><a href='/menus/municipio/070903478-vizcainos' class='text-dark'>VIZCAÍNOS</a></div><div class='list-group-item'><a href='/menus/municipio/070905480-zael' class='text-dark'>ZAEL</a></div><div class='list-group-item'><a href='/menus/municipio/070906482-zarzosa-de-rio-pisuerga' class='text-dark'>ZARZOSA DE RÍO PISUERGA</a></div><div class='list-group-item'><a href='/menus/municipio/070904483-zazuar' class='text-dark'>ZAZUAR</a></div><div class='list-group-item'><a href='/menus/municipio/070902485-zuneda' class='text-dark'>ZUÑEDA</a></div>
</div>
</div>
</div>
</div>
</div>
Spanish
Inglés
