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 = '04'
Event: dbquery
Events
0.01 ms
Query
Database
0.25 ms
SELECTCOUNT(*) AS `numrows`
FROM `establecimientos`
WHERE `ID_establecimiento` IN ('1083','1130')
AND `logotipo_establecimiento` ISNOTNULLAND `logotipo_establecimiento` != ''
Event: dbquery
Events
0.01 ms
Query
Database
0.36 ms
SELECT *
FROM `establecimientos`
WHERE `ID_establecimiento` IN ('1083','1130')
AND `logotipo_establecimiento` ISNOTNULLAND `logotipo_establecimiento` != ''
ORDERBY `nombre_establecimiento` ASC, `fecha_creacion_establecimiento` ASCLIMIT 4
Event: dbquery
Events
0.01 ms
Query
Database
0.50 ms
SELECT `nomCVIA`, `numVIA`, `CPOS`, `nomPOB`, `nomPRO`
FROM `establecimientos_localizaciones`
WHERE `ID_establecimiento` = '1130'
Event: dbquery
Events
0.01 ms
Query
Database
0.35 ms
SELECT `URL_foto`
FROM `establecimientos_fotos`
WHERE `ID_establecimiento` = '1130'
ORDERBY `ORDER_foto` ASCLIMIT 1
Event: dbquery
Events
0.01 ms
Query
Database
0.19 ms
SELECT `establecimientos_ambientes`.`ID_ambiente`
FROM `establecimientos_ambientes`
LEFTJOIN `ambientes` ON `ambientes`.`ID_ambiente` = `establecimientos_ambientes`.`ID_ambiente`
WHERE `establecimientos_ambientes`.`ID_establecimiento` = '1130'
Event: dbquery
Events
0.02 ms
Query
Database
0.16 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` = '1130'
Event: dbquery
Events
0.01 ms
Query
Database
0.15 ms
SELECT `establecimientos_caracteristicas`.`ID_caracteristicas`
FROM `establecimientos_caracteristicas`
LEFTJOIN `caracteristicas` ON `caracteristicas`.`ID_caracteristicas` = `establecimientos_caracteristicas`.`ID_caracteristicas`
WHERE `establecimientos_caracteristicas`.`ID_establecimiento` = '1130'
Event: dbquery
Events
0.01 ms
Query
Database
0.29 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` = '1130'
Event: dbquery
Events
0.01 ms
Query
Database
0.23 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` = '1130'
Event: dbquery
Events
0.01 ms
Query
Database
0.17 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` = '1130'
Event: dbquery
Events
0.01 ms
Query
Database
0.20 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` = '1130'
Event: dbquery
Events
0.01 ms
Query
Database
0.60 ms
SELECT `establecimientos_guias`.`ID_guia`
FROM `establecimientos_guias`
LEFTJOIN `guias` ON `guias`.`ID_guia` = `establecimientos_guias`.`ID_guia`
WHERE `establecimientos_guias`.`ID_establecimiento` = '1130'
Event: dbquery
Events
0.01 ms
Query
Database
0.16 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` = '1130'
Event: dbquery
Events
0.01 ms
Query
Database
0.18 ms
SELECT `establecimientos_idioma`.`ID_idioma`
FROM `establecimientos_idioma`
LEFTJOIN `idiomas` ON `idiomas`.`ID_idioma` = `establecimientos_idioma`.`ID_idioma`
WHERE `establecimientos_idioma`.`ID_establecimiento` = '1130'
Event: dbquery
Events
0.01 ms
Query
Database
0.19 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` = '1130'
Event: dbquery
Events
0.01 ms
Query
Database
0.25 ms
SELECT `ID_establecimiento`, `id_md_diario`
FROM `md_diario`
WHERE `ID_establecimiento` IN ('1130')
AND `md_fecha` = '2025-04-02'
Event: dbquery
Events
0.00 ms
Query
Database
0.29 ms
SELECT `ID_establecimiento`, `id_md_diario`
FROM `md_diario_habituales`
WHERE `ID_establecimiento` IN ('1130')
AND `md_estado` = 1
AND md_fecha_MI=1
Event: dbquery
Events
0.01 ms
Query
Database
18.73 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 (1130)
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 (371)
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 (1130)
AND md_asignaciones_defecto.ID_establecimiento NOTIN (1130)
AND md_asignaciones_defecto.dia='MI' ANDNOT FIND_IN_SET('MDDG', IFNULL(acronimos_tipologia, ''))
)
Event: dbquery
Events
0.01 ms
Query
Database
0.20 ms
SELECT `nomCVIA`, `numVIA`, `CPOS`, `nomPOB`, `nomPRO`
FROM `establecimientos_localizaciones`
WHERE `ID_establecimiento` = '1083'
Event: dbquery
Events
0.01 ms
Query
Database
0.26 ms
SELECT `URL_foto`
FROM `establecimientos_fotos`
WHERE `ID_establecimiento` = '1083'
ORDERBY `ORDER_foto` ASCLIMIT 1
Event: dbquery
Events
0.01 ms
Query
Database
0.32 ms
SELECT `establecimientos_ambientes`.`ID_ambiente`
FROM `establecimientos_ambientes`
LEFTJOIN `ambientes` ON `ambientes`.`ID_ambiente` = `establecimientos_ambientes`.`ID_ambiente`
WHERE `establecimientos_ambientes`.`ID_establecimiento` = '1083'
Event: dbquery
Events
0.01 ms
Query
Database
0.20 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` = '1083'
Event: dbquery
Events
0.01 ms
Query
Database
0.19 ms
SELECT `establecimientos_caracteristicas`.`ID_caracteristicas`
FROM `establecimientos_caracteristicas`
LEFTJOIN `caracteristicas` ON `caracteristicas`.`ID_caracteristicas` = `establecimientos_caracteristicas`.`ID_caracteristicas`
WHERE `establecimientos_caracteristicas`.`ID_establecimiento` = '1083'
Event: dbquery
Events
0.01 ms
Query
Database
0.23 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` = '1083'
Event: dbquery
Events
0.01 ms
Query
Database
0.22 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` = '1083'
Event: dbquery
Events
0.01 ms
Query
Database
0.19 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` = '1083'
Event: dbquery
Events
0.01 ms
Query
Database
0.23 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` = '1083'
Event: dbquery
Events
0.01 ms
Query
Database
0.23 ms
SELECT `establecimientos_guias`.`ID_guia`
FROM `establecimientos_guias`
LEFTJOIN `guias` ON `guias`.`ID_guia` = `establecimientos_guias`.`ID_guia`
WHERE `establecimientos_guias`.`ID_establecimiento` = '1083'
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` = '1083'
Event: dbquery
Events
0.01 ms
Query
Database
0.19 ms
SELECT `establecimientos_idioma`.`ID_idioma`
FROM `establecimientos_idioma`
LEFTJOIN `idiomas` ON `idiomas`.`ID_idioma` = `establecimientos_idioma`.`ID_idioma`
WHERE `establecimientos_idioma`.`ID_establecimiento` = '1083'
Event: dbquery
Events
0.01 ms
Query
Database
0.19 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` = '1083'
Event: dbquery
Events
0.01 ms
Query
Database
0.22 ms
SELECT `ID_establecimiento`, `id_md_diario`
FROM `md_diario`
WHERE `ID_establecimiento` IN ('1083')
AND `md_fecha` = '2025-04-02'
Event: dbquery
Events
0.01 ms
Query
Database
0.18 ms
SELECT `ID_establecimiento`, `id_md_diario`
FROM `md_diario_habituales`
WHERE `ID_establecimiento` IN ('1083')
AND `md_estado` = 1
AND md_fecha_MI=1
Event: dbquery
Events
0.01 ms
Query
Database
7.03 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 (1083)
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_establecimiento IN (1083)
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 (1083)
AND md_asignaciones_defecto.dia='MI' ANDNOT FIND_IN_SET('MDDG', IFNULL(acronimos_tipologia, ''))
)
Event: dbquery
Events
0.01 ms
Query
Database
0.13 ms
SELECT `idCCAA`, `nomCCAA`, `slugCCAA`
FROM `ES_ccaa`
WHERE `idCCAA` = '04'
ORDERBY `nomCCAA` ASC
Event: dbquery
Events
0.01 ms
Query
Database
0.22 ms
SELECT `ES_provincias`.`idPRO`, `ES_provincias`.`nomPRO`, `ES_provincias`.`slugPRO`, `ES_ccaa`.`idCCAA`, `ES_ccaa`.`nomCCAA`, `ES_ccaa`.`slugCCAA`
FROM `ES_provincias`
INNERJOIN `ES_ccaa` ON `ES_provincias`.`idCCAA` = `ES_ccaa`.`idCCAA`
WHERE `ES_provincias`.`idCCAA` = '04'
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 = '04'
SELECTCOUNT(*) AS `numrows`
FROM `establecimientos`
WHERE `ID_establecimiento` IN ('1083','1130')
AND `logotipo_establecimiento` ISNOTNULLAND `logotipo_establecimiento` != ''
SELECT *
FROM `establecimientos`
WHERE `ID_establecimiento` IN ('1083','1130')
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` = '1130'
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` = '1130'
SELECT `establecimientos_caracteristicas`.`ID_caracteristicas`
FROM `establecimientos_caracteristicas`
LEFTJOIN `caracteristicas` ON `caracteristicas`.`ID_caracteristicas` = `establecimientos_caracteristicas`.`ID_caracteristicas`
WHERE `establecimientos_caracteristicas`.`ID_establecimiento` = '1130'
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` = '1130'
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` = '1130'
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` = '1130'
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` = '1130'
SELECT `establecimientos_guias`.`ID_guia`
FROM `establecimientos_guias`
LEFTJOIN `guias` ON `guias`.`ID_guia` = `establecimientos_guias`.`ID_guia`
WHERE `establecimientos_guias`.`ID_establecimiento` = '1130'
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` = '1130'
SELECT `establecimientos_idioma`.`ID_idioma`
FROM `establecimientos_idioma`
LEFTJOIN `idiomas` ON `idiomas`.`ID_idioma` = `establecimientos_idioma`.`ID_idioma`
WHERE `establecimientos_idioma`.`ID_establecimiento` = '1130'
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` = '1130'
(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 (1130)
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 (371)
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 (1130)
AND md_asignaciones_defecto.ID_establecimiento NOTIN (1130)
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` = '1083'
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` = '1083'
SELECT `establecimientos_caracteristicas`.`ID_caracteristicas`
FROM `establecimientos_caracteristicas`
LEFTJOIN `caracteristicas` ON `caracteristicas`.`ID_caracteristicas` = `establecimientos_caracteristicas`.`ID_caracteristicas`
WHERE `establecimientos_caracteristicas`.`ID_establecimiento` = '1083'
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` = '1083'
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` = '1083'
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` = '1083'
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` = '1083'
SELECT `establecimientos_guias`.`ID_guia`
FROM `establecimientos_guias`
LEFTJOIN `guias` ON `guias`.`ID_guia` = `establecimientos_guias`.`ID_guia`
WHERE `establecimientos_guias`.`ID_establecimiento` = '1083'
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` = '1083'
SELECT `establecimientos_idioma`.`ID_idioma`
FROM `establecimientos_idioma`
LEFTJOIN `idiomas` ON `idiomas`.`ID_idioma` = `establecimientos_idioma`.`ID_idioma`
WHERE `establecimientos_idioma`.`ID_establecimiento` = '1083'
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` = '1083'
(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 (1083)
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_establecimiento IN (1083)
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 (1083)
AND md_asignaciones_defecto.dia='MI' ANDNOT FIND_IN_SET('MDDG', IFNULL(acronimos_tipologia, ''))
)
Desde hace ya más de 20 años en El Castillo del Bosque les ofrecemos una gran variedad de carnes y pescados frescos acompañados por los mejores vinos del mercado.
Disfruta de nuestros platos en un entorno tranquilo y agradable.
Disponemos de parking privado para nuestros clientes y de un parque infantil para que puedan jugar los más pequeños.
especialidades_establecimiento -> string (25) "carnes y pescados frescos"
Since more than 20 years in the castle of the forest we offer a wide variety of meats and fresh fish accompanied by the best wines on the market. Enjoy our dishes in a pleasant and quiet environment. We have a children's playground and private parking for our clients so that they can play the little ones.
especialidades_establecimiento_EN -> string (19) "meat and fresh fish"
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 (48) "https://conmenu.com/menus/ccaa/04-islas-baleares"
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
