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-02'
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_MI = 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 = 'MI'
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.idCCAA = '12'
Event: dbquery
Events
0.01 ms
Query
Database
0.15 ms
SELECTCOUNT(*) AS `numrows`
FROM `establecimientos`
WHERE `ID_establecimiento` IN ('1032','1359')
AND `logotipo_establecimiento` ISNOTNULLAND `logotipo_establecimiento` != ''
Event: dbquery
Events
0.01 ms
Query
Database
0.24 ms
SELECT *
FROM `establecimientos`
WHERE `ID_establecimiento` IN ('1032','1359')
AND `logotipo_establecimiento` ISNOTNULLAND `logotipo_establecimiento` != ''
ORDERBY `nombre_establecimiento` ASC, `fecha_creacion_establecimiento` ASCLIMIT 4
Event: dbquery
Events
0.01 ms
Query
Database
0.21 ms
SELECT `nomCVIA`, `numVIA`, `CPOS`, `nomPOB`, `nomPRO`
FROM `establecimientos_localizaciones`
WHERE `ID_establecimiento` = '1359'
Event: dbquery
Events
0.01 ms
Query
Database
0.14 ms
SELECT `URL_foto`
FROM `establecimientos_fotos`
WHERE `ID_establecimiento` = '1359'
ORDERBY `ORDER_foto` ASCLIMIT 1
Event: dbquery
Events
0.01 ms
Query
Database
0.10 ms
SELECT `establecimientos_ambientes`.`ID_ambiente`
FROM `establecimientos_ambientes`
LEFTJOIN `ambientes` ON `ambientes`.`ID_ambiente` = `establecimientos_ambientes`.`ID_ambiente`
WHERE `establecimientos_ambientes`.`ID_establecimiento` = '1359'
Event: dbquery
Events
0.01 ms
Query
Database
0.10 ms
SELECT `establecimientos_tipo_negocio`.`ID_tipo_negocio`
FROM `establecimientos_tipo_negocio`
LEFTJOIN `tipos_negocio` ON `tipos_negocio`.`ID_tipo_negocio` = `establecimientos_tipo_negocio`.`ID_tipo_negocio`
WHERE `establecimientos_tipo_negocio`.`ID_establecimiento` = '1359'
Event: dbquery
Events
0.01 ms
Query
Database
0.11 ms
SELECT `establecimientos_caracteristicas`.`ID_caracteristicas`
FROM `establecimientos_caracteristicas`
LEFTJOIN `caracteristicas` ON `caracteristicas`.`ID_caracteristicas` = `establecimientos_caracteristicas`.`ID_caracteristicas`
WHERE `establecimientos_caracteristicas`.`ID_establecimiento` = '1359'
Event: dbquery
Events
0.01 ms
Query
Database
0.08 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` = '1359'
Event: dbquery
Events
0.01 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` = '1359'
Event: dbquery
Events
0.01 ms
Query
Database
0.29 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` = '1359'
Event: dbquery
Events
0.01 ms
Query
Database
0.11 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` = '1359'
Event: dbquery
Events
0.00 ms
Query
Database
0.20 ms
SELECT `establecimientos_guias`.`ID_guia`
FROM `establecimientos_guias`
LEFTJOIN `guias` ON `guias`.`ID_guia` = `establecimientos_guias`.`ID_guia`
WHERE `establecimientos_guias`.`ID_establecimiento` = '1359'
Event: dbquery
Events
0.00 ms
Query
Database
0.14 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` = '1359'
Event: dbquery
Events
0.01 ms
Query
Database
0.15 ms
SELECT `establecimientos_idioma`.`ID_idioma`
FROM `establecimientos_idioma`
LEFTJOIN `idiomas` ON `idiomas`.`ID_idioma` = `establecimientos_idioma`.`ID_idioma`
WHERE `establecimientos_idioma`.`ID_establecimiento` = '1359'
Event: dbquery
Events
0.01 ms
Query
Database
0.08 ms
SELECT `MI_apertura` AS `apertura`, `MI_H1_ini` AS `H1ini`, `MI_H1_fin` AS `H1fin`, `MI_H2_ini` AS `H2ini`, `MI_H2_fin` AS `H2fin`, `MI_HC_ini` AS `HCini`, `MI_HC_fin` AS `HCfin`
FROM `establecimientos_horarios_habituales`
WHERE `ID_establecimiento` = '1359'
Event: dbquery
Events
0.01 ms
Query
Database
0.10 ms
SELECT `ID_establecimiento`, `id_md_diario`
FROM `md_diario`
WHERE `ID_establecimiento` IN ('1359')
AND `md_fecha` = '2025-04-02'
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 ('1359')
AND `md_estado` = 1
AND md_fecha_MI=1
Event: dbquery
Events
0.01 ms
Query
Database
21.30 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 (1359)
AND md_fecha = '2025-04-02' 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-02' 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 (388,393)
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-02' 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 (1359)
AND md_asignaciones_defecto.ID_establecimiento NOTIN (1359,1359)
AND md_asignaciones_defecto.dia='MI' ANDNOT FIND_IN_SET('MDDG', IFNULL(acronimos_tipologia, ''))
)
Event: dbquery
Events
0.01 ms
Query
Database
0.24 ms
SELECT `nomCVIA`, `numVIA`, `CPOS`, `nomPOB`, `nomPRO`
FROM `establecimientos_localizaciones`
WHERE `ID_establecimiento` = '1032'
Event: dbquery
Events
0.01 ms
Query
Database
0.13 ms
SELECT `URL_foto`
FROM `establecimientos_fotos`
WHERE `ID_establecimiento` = '1032'
ORDERBY `ORDER_foto` ASCLIMIT 1
Event: dbquery
Events
0.01 ms
Query
Database
0.09 ms
SELECT `establecimientos_ambientes`.`ID_ambiente`
FROM `establecimientos_ambientes`
LEFTJOIN `ambientes` ON `ambientes`.`ID_ambiente` = `establecimientos_ambientes`.`ID_ambiente`
WHERE `establecimientos_ambientes`.`ID_establecimiento` = '1032'
Event: dbquery
Events
0.01 ms
Query
Database
0.18 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` = '1032'
Event: dbquery
Events
0.01 ms
Query
Database
0.09 ms
SELECT `establecimientos_caracteristicas`.`ID_caracteristicas`
FROM `establecimientos_caracteristicas`
LEFTJOIN `caracteristicas` ON `caracteristicas`.`ID_caracteristicas` = `establecimientos_caracteristicas`.`ID_caracteristicas`
WHERE `establecimientos_caracteristicas`.`ID_establecimiento` = '1032'
Event: dbquery
Events
0.01 ms
Query
Database
0.13 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` = '1032'
Event: dbquery
Events
0.01 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` = '1032'
Event: dbquery
Events
0.01 ms
Query
Database
0.42 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` = '1032'
Event: dbquery
Events
0.01 ms
Query
Database
0.36 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` = '1032'
Event: dbquery
Events
0.01 ms
Query
Database
0.14 ms
SELECT `establecimientos_guias`.`ID_guia`
FROM `establecimientos_guias`
LEFTJOIN `guias` ON `guias`.`ID_guia` = `establecimientos_guias`.`ID_guia`
WHERE `establecimientos_guias`.`ID_establecimiento` = '1032'
Event: dbquery
Events
0.01 ms
Query
Database
0.22 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` = '1032'
Event: dbquery
Events
0.01 ms
Query
Database
0.17 ms
SELECT `establecimientos_idioma`.`ID_idioma`
FROM `establecimientos_idioma`
LEFTJOIN `idiomas` ON `idiomas`.`ID_idioma` = `establecimientos_idioma`.`ID_idioma`
WHERE `establecimientos_idioma`.`ID_establecimiento` = '1032'
Event: dbquery
Events
0.01 ms
Query
Database
0.43 ms
SELECT `MI_apertura` AS `apertura`, `MI_H1_ini` AS `H1ini`, `MI_H1_fin` AS `H1fin`, `MI_H2_ini` AS `H2ini`, `MI_H2_fin` AS `H2fin`, `MI_HC_ini` AS `HCini`, `MI_HC_fin` AS `HCfin`
FROM `establecimientos_horarios_habituales`
WHERE `ID_establecimiento` = '1032'
Event: dbquery
Events
0.01 ms
Query
Database
0.29 ms
SELECT `ID_establecimiento`, `id_md_diario`
FROM `md_diario`
WHERE `ID_establecimiento` IN ('1032')
AND `md_fecha` = '2025-04-02'
Event: dbquery
Events
0.01 ms
Query
Database
0.28 ms
SELECT `ID_establecimiento`, `id_md_diario`
FROM `md_diario_habituales`
WHERE `ID_establecimiento` IN ('1032')
AND `md_estado` = 1
AND md_fecha_MI=1
Event: dbquery
Events
0.01 ms
Query
Database
5.63 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 (1032)
AND md_fecha = '2025-04-02' 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-02' 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 (136)
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-02' 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 (1032)
AND md_asignaciones_defecto.ID_establecimiento NOTIN (1032)
AND md_asignaciones_defecto.dia='MI' ANDNOT FIND_IN_SET('MDDG', IFNULL(acronimos_tipologia, ''))
)
Event: dbquery
Events
0.01 ms
Query
Database
0.11 ms
SELECT `idCCAA`, `nomCCAA`, `slugCCAA`
FROM `ES_ccaa`
WHERE `idCCAA` = '12'
ORDERBY `nomCCAA` ASC
Event: dbquery
Events
0.01 ms
Query
Database
0.19 ms
SELECT `ES_provincias`.`idPRO`, `ES_provincias`.`nomPRO`, `ES_provincias`.`slugPRO`, `ES_ccaa`.`idCCAA`, `ES_ccaa`.`nomCCAA`, `ES_ccaa`.`slugCCAA`
FROM `ES_provincias`
INNERJOIN `ES_ccaa` ON `ES_provincias`.`idCCAA` = `ES_ccaa`.`idCCAA`
WHERE `ES_provincias`.`idCCAA` = '12'
ORDERBY `ES_provincias`.`nomPRO` ASC
Event: dbquery
Events
0.01 ms
Query
Database
0.21 ms
SELECT `idCCAA`, `nomCCAA`, `slugCCAA`
FROM `ES_ccaa`
ORDERBY `nomCCAA` 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-02'
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_MI = 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 = 'MI'
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.idCCAA = '12'
SELECTCOUNT(*) AS `numrows`
FROM `establecimientos`
WHERE `ID_establecimiento` IN ('1032','1359')
AND `logotipo_establecimiento` ISNOTNULLAND `logotipo_establecimiento` != ''
SELECT *
FROM `establecimientos`
WHERE `ID_establecimiento` IN ('1032','1359')
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` = '1359'
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` = '1359'
SELECT `establecimientos_caracteristicas`.`ID_caracteristicas`
FROM `establecimientos_caracteristicas`
LEFTJOIN `caracteristicas` ON `caracteristicas`.`ID_caracteristicas` = `establecimientos_caracteristicas`.`ID_caracteristicas`
WHERE `establecimientos_caracteristicas`.`ID_establecimiento` = '1359'
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` = '1359'
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` = '1359'
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` = '1359'
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` = '1359'
SELECT `establecimientos_guias`.`ID_guia`
FROM `establecimientos_guias`
LEFTJOIN `guias` ON `guias`.`ID_guia` = `establecimientos_guias`.`ID_guia`
WHERE `establecimientos_guias`.`ID_establecimiento` = '1359'
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` = '1359'
SELECT `establecimientos_idioma`.`ID_idioma`
FROM `establecimientos_idioma`
LEFTJOIN `idiomas` ON `idiomas`.`ID_idioma` = `establecimientos_idioma`.`ID_idioma`
WHERE `establecimientos_idioma`.`ID_establecimiento` = '1359'
SELECT `MI_apertura` AS `apertura`, `MI_H1_ini` AS `H1ini`, `MI_H1_fin` AS `H1fin`, `MI_H2_ini` AS `H2ini`, `MI_H2_fin` AS `H2fin`, `MI_HC_ini` AS `HCini`, `MI_HC_fin` AS `HCfin`
FROM `establecimientos_horarios_habituales`
WHERE `ID_establecimiento` = '1359'
(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 (1359)
AND md_fecha = '2025-04-02' 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-02' 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 (388,393)
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-02' 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 (1359)
AND md_asignaciones_defecto.ID_establecimiento NOTIN (1359,1359)
AND md_asignaciones_defecto.dia='MI' ANDNOT FIND_IN_SET('MDDG', IFNULL(acronimos_tipologia, ''))
)
SELECT `establecimientos_ambientes`.`ID_ambiente`
FROM `establecimientos_ambientes`
LEFTJOIN `ambientes` ON `ambientes`.`ID_ambiente` = `establecimientos_ambientes`.`ID_ambiente`
WHERE `establecimientos_ambientes`.`ID_establecimiento` = '1032'
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` = '1032'
SELECT `establecimientos_caracteristicas`.`ID_caracteristicas`
FROM `establecimientos_caracteristicas`
LEFTJOIN `caracteristicas` ON `caracteristicas`.`ID_caracteristicas` = `establecimientos_caracteristicas`.`ID_caracteristicas`
WHERE `establecimientos_caracteristicas`.`ID_establecimiento` = '1032'
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` = '1032'
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` = '1032'
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` = '1032'
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` = '1032'
SELECT `establecimientos_guias`.`ID_guia`
FROM `establecimientos_guias`
LEFTJOIN `guias` ON `guias`.`ID_guia` = `establecimientos_guias`.`ID_guia`
WHERE `establecimientos_guias`.`ID_establecimiento` = '1032'
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` = '1032'
SELECT `establecimientos_idioma`.`ID_idioma`
FROM `establecimientos_idioma`
LEFTJOIN `idiomas` ON `idiomas`.`ID_idioma` = `establecimientos_idioma`.`ID_idioma`
WHERE `establecimientos_idioma`.`ID_establecimiento` = '1032'
SELECT `MI_apertura` AS `apertura`, `MI_H1_ini` AS `H1ini`, `MI_H1_fin` AS `H1fin`, `MI_H2_ini` AS `H2ini`, `MI_H2_fin` AS `H2fin`, `MI_HC_ini` AS `HCini`, `MI_HC_fin` AS `HCfin`
FROM `establecimientos_horarios_habituales`
WHERE `ID_establecimiento` = '1032'
(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 (1032)
AND md_fecha = '2025-04-02' 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-02' 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 (136)
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-02' 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 (1032)
AND md_asignaciones_defecto.ID_establecimiento NOTIN (1032)
AND md_asignaciones_defecto.dia='MI' ANDNOT FIND_IN_SET('MDDG', IFNULL(acronimos_tipologia, ''))
)
Local decorado con estética americana de los años 60 perteneciente a la franquicia Peggy Sue's. Comida estadounidense y panamericana elaborada con recetas caseras fieles al espíritu artesanal de Peggy Sue's.
Descubre nuestras hamburguesas elaboradas con carne de buey Angus importada desde Escocia y que por su color, jugosidad y textura es considerada por los expertos una de las mejores del mundo.
Local decorated with American aesthetics of the 60 belonging to Peggy Sue's franchise. American and Pan American cuisine made with homemade recipes, faithful to the traditional spirit of Peggy Sue's.
See our hamburgers made with Angus beef imported from Scotland and by its color, juiciness and texture is considered by experts one of the best in the world.
especialidades_establecimiento_EN -> string (47) "American and Pan American, lunch meat, desserts"
md_nom_platos_cat1 => UTF-8 string (117) "Ensalada César||Ensalada de lechuga, tomate, queso y cebolla frita||Ensalada...
$value[1]['md_nom_platos_cat1']
Ensalada César||Ensalada de lechuga, tomate, queso y cebolla frita||Ensalada de tomate||Quesadillas de bacon y queso
md_nom_platos_cat2 => string (163) "Carne de hamburguesa con patatas y ensalada||Huevos fritos con patatas||Pech...
$value[1]['md_nom_platos_cat2']
Carne de hamburguesa con patatas y ensalada||Huevos fritos con patatas||Pechuga de pollo a la plancha con patatas y ensalada||Pechuga de pollo empanado con patatas
md_nom_platos_cat1_EN => string (114) "Caesar dressing salad||Salad of lettuce, tomato, cheese and fried onions||to...
$value[1]['md_nom_platos_cat1_EN']
Caesar dressing salad||Salad of lettuce, tomato, cheese and fried onions||tomato salad||Bacon & Cheese Quesadillas
md_nom_platos_cat2_EN => string (151) "Hamburger steak with potatoes and salad||Fried eggs with potatoes||Chicken b...
$value[1]['md_nom_platos_cat2_EN']
Hamburger steak with potatoes and salad||Fried eggs with potatoes||Chicken breast grilled with potatoes and salad||Chicken breast breaded with potatoes
Local decorado con estética americana de los años 60 perteneciente a la franquicia Peggy Sue's. Comida estadounidense y panamericana elaborada con recetas caseras fieles al espíritu artesanal de Peggy Sue's.
Descubre nuestras hamburguesas elaboradas con carne de buey Angus importada desde Escocia y que por su color, jugosidad y textura es considerada por los expertos una de las mejores del mundo.
Local decorated with American aesthetics of the 60 belonging to Peggy Sue's franchise. American and Pan American cuisine made with homemade recipes, faithful to the traditional spirit of Peggy Sue's.
See our hamburgers made with Angus beef imported from Scotland and by its color, juiciness and texture is considered by experts one of the best in the world.
especialidades_establecimiento_EN -> string (47) "American and Pan American, lunch meat, desserts"
md_nom_platos_cat1 => string (155) "CALAMARES A LA ROMANA||CHIPIRONES FRITOS||CREMA DE LA CASA||CROQUETAS CASERA...
$value[2]['md_nom_platos_cat1']
CALAMARES A LA ROMANA||CHIPIRONES FRITOS||CREMA DE LA CASA||CROQUETAS CASERAS||ENSALADA MIXTA||ENSALADILLA RUSA||SALPICON DE LA CASA||VERDURAS A LA PLANCHA
md_nom_platos_cat2 => string (96) "ESPAGUETI MARINERA||MERLUZA A LA VIZCAINA||MILANESA DE POLLO||SALMON A LA RI...
$value[2]['md_nom_platos_cat2']
ESPAGUETI MARINERA||MERLUZA A LA VIZCAINA||MILANESA DE POLLO||SALMON A LA RIOJANA||TERNERA ASADA
md_nom_platos_cat3 => string (125) "FLAN DE CAFE||FLAN DE HUEVO||FLAN DE QUESO||TARTA DE MANZANA||TARTA DE QUESO...
$value[2]['md_nom_platos_cat3']
FLAN DE CAFE||FLAN DE HUEVO||FLAN DE QUESO||TARTA DE MANZANA||TARTA DE QUESO||TARTA HELADA||TARTA SELVA NEGRA||TARTA TIRAMISU
md_nom_platos_cat4 => string (41) "AGUA||CERVEZA||REFRESCOS||VINO DE LA CASA"
Restaurant à la carte, menu of the day, celebration of weddings, communions, christenings, anniversaries and all kinds of events with a view to the sea
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 (41) "https://conmenu.com/menus/ccaa/12-galicia"
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
Spanish
Inglés
