Method "Symfony\Component\DependencyInjection\Extension\ExtensionInterface::load()" might add "void" as a native return type declaration in the future. Do the same in implementation "Sensio\Bundle\FrameworkExtraBundle\DependencyInjection\SensioFrameworkExtraExtension" now to avoid errors or add an explicit @return annotation to suppress this message.
Method "Symfony\Component\DependencyInjection\Compiler\CompilerPassInterface::process()" might add "void" as a native return type declaration in the future. Do the same in implementation "Sensio\Bundle\FrameworkExtraBundle\DependencyInjection\Compiler\AddParamConverterPass" now to avoid errors or add an explicit @return annotation to suppress this message.
Method "Symfony\Component\DependencyInjection\Compiler\CompilerPassInterface::process()" might add "void" as a native return type declaration in the future. Do the same in implementation "Sensio\Bundle\FrameworkExtraBundle\DependencyInjection\Compiler\OptimizerPass" now to avoid errors or add an explicit @return annotation to suppress this message.
Method "Symfony\Component\DependencyInjection\Compiler\CompilerPassInterface::process()" might add "void" as a native return type declaration in the future. Do the same in implementation "Sensio\Bundle\FrameworkExtraBundle\DependencyInjection\Compiler\AddExpressionLanguageProvidersPass" now to avoid errors or add an explicit @return annotation to suppress this message.
Method "Symfony\Component\Form\AbstractType::getBlockPrefix()" might add "string" as a native return type declaration in the future. Do the same in child class "App\Form\RechercheEtablissementType" now to avoid errors or add an explicit @return annotation to suppress this message.
Method "Symfony\Component\Form\AbstractType::getBlockPrefix()" might add "string" as a native return type declaration in the future. Do the same in child class "App\Form\RechercheStructureType" now to avoid errors or add an explicit @return annotation to suppress this message.
Method "Symfony\Component\Form\AbstractType::finishView()" might add "void" as a native return type declaration in the future. Do the same in child class "App\Form\Type\GalleryType" now to avoid errors or add an explicit @return annotation to suppress this message.
Method "Symfony\Component\Form\AbstractType::finishView()" might add "void" as a native return type declaration in the future. Do the same in child class "App\Form\Type\KeywordType" now to avoid errors or add an explicit @return annotation to suppress this message.
User Deprecated: Since symfony/validator 6.4: Method "Symfony\Component\Validator\ValidatorBuilder::setDoctrineAnnotationReader()" is deprecated without replacement.
User Deprecated: Doctrine\DBAL\Platforms\PostgreSQLPlatform::usesSequenceEmulatedIdentityColumns is deprecated. (PostgreSQLPlatform.php:217 called by ClassMetadataFactory.php:643, https://github.com/doctrine/dbal/pull/5513, package doctrine/dbal)
User Deprecated: Context: Loading metadata for class App\Entity\Etablissement
Problem: Using identity columns emulated with a sequence is deprecated and will not be possible in Doctrine ORM 3.0.
Solution: Use the SEQUENCE generator strategy instead. (ClassMetadataFactory.php:644 called by ClassMetadataFactory.php:160, https://github.com/doctrine/orm/issues/8850, package doctrine/orm)
"""
\n\n select DISTINCT up.numec as numec_up, tu.id_gabriel as type_up_id, up.code_rne, up.id_gabriel, up.nom_courant, up.etablissement, adresse_cap.locality as ville , CONCAT_WS(' ',adresse_cap.street_number,adresse_cap.street_number_ext,adresse_cap.street_name) as adresse1, ac.telephone1,adresse_cap.postal_code as cp, ac.mail1, ac.fax1, ac.site_web,\ndep_up.id_gabriel as departement, tu.libelle_long as type_up,up.latitude,up.longitude, e.nom_courant as etb_nom, co.libelle_long as contrat, st.nom_usage as academie, st.id_gabriel as academie_id, s.nom_usage as diocese, s.id_gabriel as diocese_id, de.libelle_long as degre, up.statut, up.projet,\ninte.libelle_long as internat, up.internat_desc, up.etude, up.etude_desc, up.horaire_ouverture, up.horaire_fermeture, mi.libelle_long as ministere_tutelle, up.ecole_circonscription, ntu.libelle_long as type_tutelle,\nup.accueil_peri_scolaire_matin, accueil_peri_scolaire_soir, aff.libelle_long as affiliation, up.photo, up.nb_filles, up.nb_garcons, up.effectifs_total, up.effectifs_total_items, up.effectif_hors_contrat, civ.libelle_long as civilite, i.prenom_usuel\nas prenom, i.nom as nom, struct.nom_usage as ogec, up.ogec as id_ogec, torg.libelle_long as organisme, up.transport, up.demi_pension, ntp.libelle_long as lib_pension, up.internat as internat_code, njo.libelle_long jours,\n\t\t\tCASE\n\t\t\t\tWHEN up.latitude = 0 THEN NULL\n\t\t\t\tWHEN up.latitude = 99 THEN NULL\n\t\t\t\tWHEN up.latitude IS NULL THEN NULL\n\t\t\t\tELSE CONCAT(up.latitude ,',',up.longitude)\n\t\t\tEND AS coord,\n\t\t\t(SELECT DISTINCT array_agg(nl.libelle_langue)\n\t\t\t\tFROM annuaire._n_langues as nl\n\t\t\t\tINNER JOIN annuaire._a_langue_up as alu2 ON alu2.langue_id = nl.id_gabriel\n\t\t\t\tWHERE alu2.up_id = up.id_gabriel)\n\t\t\tas langues,\n\t\t\t(SELECT DISTINCT array_agg(nd.libelle_dispositif)\n\t\t\t\tFROM annuaire._n_dispositif as nd\n\t\t\t\tINNER JOIN annuaire._a_dispositif_up as adu2 ON adu2.dispositif_id = nd.id_gabriel\n\t\t\t\tWHERE adu2.up_id = up.id_gabriel)\n\t\t\tas dispositifs,\n\t\t\t(SELECT DISTINCT array_agg(';' || alu3.langue_id || ';')\n\t\t\t\tFROM annuaire._a_langue_up as alu3\n\t\t\t\tWHERE alu3.up_id = up.id_gabriel)\n\t\t\tas langues_id,\n\t\t\t(SELECT array_agg(concat(source || ' - ' || formation))\n\t\t\t\tFROM annuaire._n_formations AS nf\n\t\t\t\tINNER JOIN annuaire._a_formation_up AS afu2 ON afu2.formation_id = nf.id_gabriel\n\t\t\t\tWHERE afu2.up_id = up.id_gabriel)\n\t\t\tas formations,\n case when (\n\t\t\t\tSELECT \tpo.id_gabriel\n\t\t\t\tFROM annuaire.portes_ouvertes po\n\t\t\t\tINNER JOIN annuaire._a_formations_portes_ouvertes afpo on afpo.id_portes_ouvertes = po.id_gabriel\n\t\t\t\tINNER JOIN annuaire._n_formations_portes_ouvertes nfpo on nfpo.id_gabriel = afpo.id_formations\n\t\t\t\tWHERE po.id_up = up.id_gabriel and po.date_debut between CURRENT_DATE - interval '1 month' and CURRENT_DATE + interval '1 year'\n\t\t\t\tlimit 1\n\t\t\t) is null then 0 else 1 end as portes_ouvertes,\n\t\t\t(SELECT array_agg(filiere)\n\t\t\t\tFROM annuaire._n_option_matiere nom\n\t\t\t\tINNER JOIN annuaire._a_specificite_up AS asu2 ON asu2.specificite_id = nom.id_gabriel\n\t\t\t\tWHERE asu2.up_id = up.id_gabriel)\n\t\t\tas specificites, r.libelle_edition AS region, up.type_structure, up.validation_items_id\n\n\t\t\tfrom annuaire.up\n\t\t\t\n\t\t\tinner join annuaire.etablissement e on e.id_gabriel = up.etablissement\n\t\t\tinner join annuaire.adresse_communication ac on ac.id_gabriel = up.adresse\n\t\t\tLEFT JOIN annuaire.adresse_cap adresse_cap ON adresse_cap.numec = up.numec AND adresse_cap.doublon IS NULL\n\t\t\tLEFT JOIN annuaire._n_departement dep_up ON dep_up.code_departement = adresse_cap.code_departement\n\t\t\tleft join annuaire._n_region r on dep_up.code_region_interne = r.id_gabriel\n\t\t\tleft join annuaire._n_type_organisme torg on torg.id_gabriel = e.type_organisme\n\t\t\tleft join annuaire.structure struct on struct.id_gabriel = up.ogec\n\t\t\tleft join annuaire.individu i ON i.id_gabriel = up.cetb_id\n\t\t\tleft join annuaire._n_civilite civ on civ.id_gabriel = i.civilite\n\t\t\tleft join annuaire._n_affiliation aff on aff.id_gabriel = up.affiliation\n\t\t\tleft join annuaire._n_nat_tutelle ntu on ntu.id_gabriel = up.type_tutelle\n\t\t\tleft join annuaire._n_ministere mi on mi.id_gabriel = up.ministere_tutelle\n\t\t\tleft join annuaire._n_internat inte on inte.id_gabriel = up.internat\n\t\t\tleft join annuaire._n_degre de on de.id_gabriel = up.degre\n\t\t\tleft join annuaire.structure s on s.id_gabriel = up.diocese\n\t\t\tleft join annuaire.structure st on st.id_gabriel = dep_up.code_academie_interne\n\t\t\tleft join annuaire._n_type_up tu on up.type_structure = tu.id_gabriel\n\t\t\tleft join annuaire._n_contrat co on co.id_gabriel = up.contrat\n\t\t\tleft join annuaire._n_type_pension ntp on ntp.id_gabriel = up.demi_pension\n\t\t\tleft join annuaire._a_up_jour auj on auj.up_id = up.id_gabriel\n\t\t\tleft join annuaire._n_jour_ouverture njo on njo.id_gabriel=auj.jour_ouverture_id\n\t\t\tWHERE up.statut != 'f' AND up.code_rne = ?\n\t\t\t\n limit 1 offset 0\n
"""
(parameters:
[1 => "0280815J"
]
, types:
[1 => 2]
)
doctrine
[
"sql" => """
\n\n select DISTINCT up.numec as numec_up, tu.id_gabriel as type_up_id, up.code_rne, up.id_gabriel, up.nom_courant, up.etablissement, adresse_cap.locality as ville , CONCAT_WS(' ',adresse_cap.street_number,adresse_cap.street_number_ext,adresse_cap.street_name) as adresse1, ac.telephone1,adresse_cap.postal_code as cp, ac.mail1, ac.fax1, ac.site_web,\ndep_up.id_gabriel as departement, tu.libelle_long as type_up,up.latitude,up.longitude, e.nom_courant as etb_nom, co.libelle_long as contrat, st.nom_usage as academie, st.id_gabriel as academie_id, s.nom_usage as diocese, s.id_gabriel as diocese_id, de.libelle_long as degre, up.statut, up.projet,\ninte.libelle_long as internat, up.internat_desc, up.etude, up.etude_desc, up.horaire_ouverture, up.horaire_fermeture, mi.libelle_long as ministere_tutelle, up.ecole_circonscription, ntu.libelle_long as type_tutelle,\nup.accueil_peri_scolaire_matin, accueil_peri_scolaire_soir, aff.libelle_long as affiliation, up.photo, up.nb_filles, up.nb_garcons, up.effectifs_total, up.effectifs_total_items, up.effectif_hors_contrat, civ.libelle_long as civilite, i.prenom_usuel\nas prenom, i.nom as nom, struct.nom_usage as ogec, up.ogec as id_ogec, torg.libelle_long as organisme, up.transport, up.demi_pension, ntp.libelle_long as lib_pension, up.internat as internat_code, njo.libelle_long jours,\n\t\t\tCASE\n\t\t\t\tWHEN up.latitude = 0 THEN NULL\n\t\t\t\tWHEN up.latitude = 99 THEN NULL\n\t\t\t\tWHEN up.latitude IS NULL THEN NULL\n\t\t\t\tELSE CONCAT(up.latitude ,',',up.longitude)\n\t\t\tEND AS coord,\n\t\t\t(SELECT DISTINCT array_agg(nl.libelle_langue)\n\t\t\t\tFROM annuaire._n_langues as nl\n\t\t\t\tINNER JOIN annuaire._a_langue_up as alu2 ON alu2.langue_id = nl.id_gabriel\n\t\t\t\tWHERE alu2.up_id = up.id_gabriel)\n\t\t\tas langues,\n\t\t\t(SELECT DISTINCT array_agg(nd.libelle_dispositif)\n\t\t\t\tFROM annuaire._n_dispositif as nd\n\t\t\t\tINNER JOIN annuaire._a_dispositif_up as adu2 ON adu2.dispositif_id = nd.id_gabriel\n\t\t\t\tWHERE adu2.up_id = up.id_gabriel)\n\t\t\tas dispositifs,\n\t\t\t(SELECT DISTINCT array_agg(';' || alu3.langue_id || ';')\n\t\t\t\tFROM annuaire._a_langue_up as alu3\n\t\t\t\tWHERE alu3.up_id = up.id_gabriel)\n\t\t\tas langues_id,\n\t\t\t(SELECT array_agg(concat(source || ' - ' || formation))\n\t\t\t\tFROM annuaire._n_formations AS nf\n\t\t\t\tINNER JOIN annuaire._a_formation_up AS afu2 ON afu2.formation_id = nf.id_gabriel\n\t\t\t\tWHERE afu2.up_id = up.id_gabriel)\n\t\t\tas formations,\n case when (\n\t\t\t\tSELECT \tpo.id_gabriel\n\t\t\t\tFROM annuaire.portes_ouvertes po\n\t\t\t\tINNER JOIN annuaire._a_formations_portes_ouvertes afpo on afpo.id_portes_ouvertes = po.id_gabriel\n\t\t\t\tINNER JOIN annuaire._n_formations_portes_ouvertes nfpo on nfpo.id_gabriel = afpo.id_formations\n\t\t\t\tWHERE po.id_up = up.id_gabriel and po.date_debut between CURRENT_DATE - interval '1 month' and CURRENT_DATE + interval '1 year'\n\t\t\t\tlimit 1\n\t\t\t) is null then 0 else 1 end as portes_ouvertes,\n\t\t\t(SELECT array_agg(filiere)\n\t\t\t\tFROM annuaire._n_option_matiere nom\n\t\t\t\tINNER JOIN annuaire._a_specificite_up AS asu2 ON asu2.specificite_id = nom.id_gabriel\n\t\t\t\tWHERE asu2.up_id = up.id_gabriel)\n\t\t\tas specificites, r.libelle_edition AS region, up.type_structure, up.validation_items_id\n\n\t\t\tfrom annuaire.up\n\t\t\t\n\t\t\tinner join annuaire.etablissement e on e.id_gabriel = up.etablissement\n\t\t\tinner join annuaire.adresse_communication ac on ac.id_gabriel = up.adresse\n\t\t\tLEFT JOIN annuaire.adresse_cap adresse_cap ON adresse_cap.numec = up.numec AND adresse_cap.doublon IS NULL\n\t\t\tLEFT JOIN annuaire._n_departement dep_up ON dep_up.code_departement = adresse_cap.code_departement\n\t\t\tleft join annuaire._n_region r on dep_up.code_region_interne = r.id_gabriel\n\t\t\tleft join annuaire._n_type_organisme torg on torg.id_gabriel = e.type_organisme\n\t\t\tleft join annuaire.structure struct on struct.id_gabriel = up.ogec\n\t\t\tleft join annuaire.individu i ON i.id_gabriel = up.cetb_id\n\t\t\tleft join annuaire._n_civilite civ on civ.id_gabriel = i.civilite\n\t\t\tleft join annuaire._n_affiliation aff on aff.id_gabriel = up.affiliation\n\t\t\tleft join annuaire._n_nat_tutelle ntu on ntu.id_gabriel = up.type_tutelle\n\t\t\tleft join annuaire._n_ministere mi on mi.id_gabriel = up.ministere_tutelle\n\t\t\tleft join annuaire._n_internat inte on inte.id_gabriel = up.internat\n\t\t\tleft join annuaire._n_degre de on de.id_gabriel = up.degre\n\t\t\tleft join annuaire.structure s on s.id_gabriel = up.diocese\n\t\t\tleft join annuaire.structure st on st.id_gabriel = dep_up.code_academie_interne\n\t\t\tleft join annuaire._n_type_up tu on up.type_structure = tu.id_gabriel\n\t\t\tleft join annuaire._n_contrat co on co.id_gabriel = up.contrat\n\t\t\tleft join annuaire._n_type_pension ntp on ntp.id_gabriel = up.demi_pension\n\t\t\tleft join annuaire._a_up_jour auj on auj.up_id = up.id_gabriel\n\t\t\tleft join annuaire._n_jour_ouverture njo on njo.id_gabriel=auj.jour_ouverture_id\n\t\t\tWHERE up.statut != 'f' AND up.code_rne = ?\n\t\t\t\n limit 1 offset 0\n
"""
"params" => [1 => "0280815J"
]
"types" => [1 => 2]
]
debug
Executing statement:
"SELECT t0_.id_gabriel AS id_gabriel_0, t0_.id_gabriel_exploit AS id_gabriel_exploit_1, t0_.id_ange AS id_ange_2, t0_.id_ecol AS id_ecol_3, t0_.id_men AS id_men_4, t0_.formation AS formation_5, t0_.niveau AS niveau_6, t0_.type AS type_7, t0_.famille AS famille_8, t0_.source AS source_9, t0_.date_ouverture AS date_ouverture_10, t0_.date_fermeture AS date_fermeture_11, t0_.date_creation AS date_creation_12, t0_.date_intervention AS date_intervention_13, t0_.commentaires AS commentaires_14 FROM annuaire._n_formations t0_ INNER JOIN annuaire._a_formation_up t1_ ON t0_.id_gabriel = t1_.formation_id WHERE (t0_.date_fermeture > ? OR t0_.date_fermeture IS NULL) AND t1_.up_id = ? ORDER BY t0_.id_gabriel ASC"
(parameters:
[1 => "2025-09-28 20:02:00"
2 => 5089]
, types:
[1 => 22 => 1]
)
doctrine
[
"sql" => "SELECT t0_.id_gabriel AS id_gabriel_0, t0_.id_gabriel_exploit AS id_gabriel_exploit_1, t0_.id_ange AS id_ange_2, t0_.id_ecol AS id_ecol_3, t0_.id_men AS id_men_4, t0_.formation AS formation_5, t0_.niveau AS niveau_6, t0_.type AS type_7, t0_.famille AS famille_8, t0_.source AS source_9, t0_.date_ouverture AS date_ouverture_10, t0_.date_fermeture AS date_fermeture_11, t0_.date_creation AS date_creation_12, t0_.date_intervention AS date_intervention_13, t0_.commentaires AS commentaires_14 FROM annuaire._n_formations t0_ INNER JOIN annuaire._a_formation_up t1_ ON t0_.id_gabriel = t1_.formation_id WHERE (t0_.date_fermeture > ? OR t0_.date_fermeture IS NULL) AND t1_.up_id = ? ORDER BY t0_.id_gabriel ASC"
"params" => [1 => "2025-09-28 20:02:00"
2 => 5089]
"types" => [1 => 22 => 1]
]
debug
Executing statement:
"SELECT t0_.id_gabriel AS id_gabriel_0, t0_.id_gabriel_exploit AS id_gabriel_exploit_1, t0_.id_ange AS id_ange_2, t0_.id_ecole AS id_ecole_3, t0_.id_men AS id_men_4, t0_.libelle_langue AS libelle_langue_5, t0_.niveau AS niveau_6, t0_.date_ouverture AS date_ouverture_7, t0_.date_fermeture AS date_fermeture_8, t0_.date_creation AS date_creation_9, t0_.date_intervention AS date_intervention_10, t0_.commentaires AS commentaires_11 FROM annuaire._n_langues t0_ INNER JOIN annuaire._a_langue_up t1_ ON t0_.id_gabriel = t1_.langue_id WHERE (t0_.date_fermeture > ? OR t0_.date_fermeture IS NULL) AND t1_.up_id = ? ORDER BY t0_.id_gabriel ASC"
(parameters:
[1 => "2025-09-28 20:02:00"
2 => 5089]
, types:
[1 => 22 => 1]
)
doctrine
[
"sql" => "SELECT t0_.id_gabriel AS id_gabriel_0, t0_.id_gabriel_exploit AS id_gabriel_exploit_1, t0_.id_ange AS id_ange_2, t0_.id_ecole AS id_ecole_3, t0_.id_men AS id_men_4, t0_.libelle_langue AS libelle_langue_5, t0_.niveau AS niveau_6, t0_.date_ouverture AS date_ouverture_7, t0_.date_fermeture AS date_fermeture_8, t0_.date_creation AS date_creation_9, t0_.date_intervention AS date_intervention_10, t0_.commentaires AS commentaires_11 FROM annuaire._n_langues t0_ INNER JOIN annuaire._a_langue_up t1_ ON t0_.id_gabriel = t1_.langue_id WHERE (t0_.date_fermeture > ? OR t0_.date_fermeture IS NULL) AND t1_.up_id = ? ORDER BY t0_.id_gabriel ASC"
"params" => [1 => "2025-09-28 20:02:00"
2 => 5089]
"types" => [1 => 22 => 1]
]
debug
Executing statement:
"SELECT t0_.id_gabriel AS id_gabriel_0, t0_.id_gabriel_exploit AS id_gabriel_exploit_1, t0_.id_ange AS id_ange_2, t0_.id_ecole AS id_ecole_3, t0_.id_men AS id_men_4, t0_.filiere AS filiere_5, t0_.type AS type_6, t0_.famille AS famille_7, t0_.date_ouverture AS date_ouverture_8, t0_.date_fermeture AS date_fermeture_9, t0_.date_creation AS date_creation_10, t0_.date_intervention AS date_intervention_11, t0_.commentaires AS commentaires_12 FROM annuaire._n_option_matiere t0_ INNER JOIN annuaire._a_specificite_up t1_ ON t0_.id_gabriel = t1_.specificite_id WHERE (t0_.date_fermeture > ? OR t0_.date_fermeture IS NULL) AND t1_.up_id = ? ORDER BY t0_.id_gabriel ASC"
(parameters:
[1 => "2025-09-28 20:02:00"
2 => 5089]
, types:
[1 => 22 => 1]
)
doctrine
[
"sql" => "SELECT t0_.id_gabriel AS id_gabriel_0, t0_.id_gabriel_exploit AS id_gabriel_exploit_1, t0_.id_ange AS id_ange_2, t0_.id_ecole AS id_ecole_3, t0_.id_men AS id_men_4, t0_.filiere AS filiere_5, t0_.type AS type_6, t0_.famille AS famille_7, t0_.date_ouverture AS date_ouverture_8, t0_.date_fermeture AS date_fermeture_9, t0_.date_creation AS date_creation_10, t0_.date_intervention AS date_intervention_11, t0_.commentaires AS commentaires_12 FROM annuaire._n_option_matiere t0_ INNER JOIN annuaire._a_specificite_up t1_ ON t0_.id_gabriel = t1_.specificite_id WHERE (t0_.date_fermeture > ? OR t0_.date_fermeture IS NULL) AND t1_.up_id = ? ORDER BY t0_.id_gabriel ASC"
"params" => [1 => "2025-09-28 20:02:00"
2 => 5089]
"types" => [1 => 22 => 1]
]
Uncaught PHP Exception ErrorException: "Warning: Cannot modify header information - headers already sent by (output started at /home/desktop/www/gabriel2/vendor/dompdf/dompdf/src/Adapter/CPDF.php:922)" at SessionUtils.php line 52
User Deprecated: Since symfony/serializer 6.4: Passing a "Doctrine\Common\Annotations\PsrCachedReader" instance as argument 1 to "Symfony\Component\Serializer\Mapping\Loader\AttributeLoader::__construct()" is deprecated, pass null or omit the parameter instead.
User Deprecated: Relying on non-optimal defaults for ID generation is deprecated, and IDENTITY
results in SERIAL, which is not recommended.
Instead, configure identifier generation strategies explicitly through
configuration.
We currently recommend "SEQUENCE" for "Doctrine\DBAL\Platforms\PostgreSqlPlatform", so you should use
$configuration->setIdentityGenerationPreferences([
"Doctrine\DBAL\Platforms\PostgreSqlPlatform" => ClassMetadata::GENERATOR_TYPE_SEQUENCE,
]); (ClassMetadataFactory.php:760 called by ClassMetadataFactory.php:631, https://github.com/doctrine/orm/issues/8893, package doctrine/orm)