OSE

Other Route Parameters

 array:1 [
  "view" => "test4"
]

Appel Application/src/Service/PrivilegeService.php(79): Application\Service\PrivilegeService->makePrivilegesRoles()
SQL ALTER SESSION SET NLS_TIME_FORMAT = 'HH24:MI:SS' NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD HH24:MI:SS TZH:TZM' NLS_NUMERIC_CHARACTERS = '.,' Params Types Time 0.000602960586547852

Appel Application/src/Service/PrivilegeService.php(79): Application\Service\PrivilegeService->makePrivilegesRoles()
SQL SELECT cp.code || '-' || p.code privilege, r.code role FROM role_privilege rp JOIN privilege p ON p.id = rp.privilege_id JOIN categorie_privilege cp ON cp.id = p.categorie_id JOIN role r ON r.id = rp.role_id AND r.histo_destruction IS NULL Params Types Time 0.00226211547851562

Appel Application/src/Service/PrivilegeService.php(79): Application\Service\PrivilegeService->makePrivilegesRoles()
SQL SELECT t0.DATE_DEBUT AS DATE_DEBUT_1, t0.DATE_FIN AS DATE_FIN_2, t0.LIBELLE AS LIBELLE_3, t0.ACTIVE AS ACTIVE_4, t0.ID AS ID_5 FROM ANNEE t0 WHERE t0.ID = ? Params 0 => int(2026)
Types 0 => string(7) "integer"
Time 0.000727176666259766

Appel Application/src/Service/PrivilegeService.php(79): Application\Service\PrivilegeService->makePrivilegesRoles()
SQL SELECT s0_.CODE AS CODE_0, s0_.LIBELLE AS LIBELLE_1, s0_.ORDRE AS ORDRE_2, s0_.PRIORITAIRE_INDICATEURS AS PRIORITAIRE_INDICATEURS_3, s0_.SERVICE_STATUTAIRE AS SERVICE_STATUTAIRE_4, s0_.DEPASSEMENT_SERVICE_DU_SANS_HC AS PASSEMENT_SERVICE_DU_SANS_HC_5, s0_.TAUX_CHARGES_PATRONALES AS TAUX_CHARGES_PATRONALES_6, s0_.TAUX_CHARGES_TTC AS TAUX_CHARGES_TTC_7, s0_.DOSSIER AS DOSSIER_8, s0_.DOSSIER_VISUALISATION AS DOSSIER_VISUALISATION_9, s0_.DOSSIER_EDITION AS DOSSIER_EDITION_10, s0_.DOSSIER_SELECTIONNABLE AS DOSSIER_SELECTIONNABLE_11, s0_.DOSSIER_IDENTITE_COMP AS DOSSIER_IDENTITE_COMP_12, s0_.DOSSIER_CONTACT AS DOSSIER_CONTACT_13, s0_.DOSSIER_TEL_PERSO AS DOSSIER_TEL_PERSO_14, s0_.DOSSIER_EMAIL_PERSO AS DOSSIER_EMAIL_PERSO_15, s0_.DOSSIER_SITUATION_MATRIMONIALE AS SIER_SITUATION_MATRIMONIALE_16, s0_.DOSSIER_EMPLOYEUR_FACULTATIF AS OSSIER_EMPLOYEUR_FACULTATIF_17, s0_.DOSSIER_ADRESSE AS DOSSIER_ADRESSE_18, s0_.DOSSIER_BANQUE AS DOSSIER_BANQUE_19, s0_.DOSSIER_INSEE AS DOSSIER_INSEE_20, s0_.DOSSIER_STATUT AS DOSSIER_STATUT_21, s0_.DOSSIER_EMPLOYEUR AS DOSSIER_EMPLOYEUR_22, s0_.DOSSIER_AUTRE_1 AS DOSSIER_AUTRE_1_23, s0_.DOSSIER_AUTRE_1_VISUALISATION AS SSIER_AUTRE_1_VISUALISATION_24, s0_.DOSSIER_AUTRE_1_EDITION AS DOSSIER_AUTRE_1_EDITION_25, s0_.DOSSIER_AUTRE_2 AS DOSSIER_AUTRE_2_26, s0_.DOSSIER_AUTRE_2_VISUALISATION AS SSIER_AUTRE_2_VISUALISATION_27, s0_.DOSSIER_AUTRE_2_EDITION AS DOSSIER_AUTRE_2_EDITION_28, s0_.DOSSIER_AUTRE_3 AS DOSSIER_AUTRE_3_29, s0_.DOSSIER_AUTRE_3_VISUALISATION AS SSIER_AUTRE_3_VISUALISATION_30, s0_.DOSSIER_AUTRE_3_EDITION AS DOSSIER_AUTRE_3_EDITION_31, s0_.DOSSIER_AUTRE_4 AS DOSSIER_AUTRE_4_32, s0_.DOSSIER_AUTRE_4_VISUALISATION AS SSIER_AUTRE_4_VISUALISATION_33, s0_.DOSSIER_AUTRE_4_EDITION AS DOSSIER_AUTRE_4_EDITION_34, s0_.DOSSIER_AUTRE_5 AS DOSSIER_AUTRE_5_35, s0_.DOSSIER_AUTRE_5_VISUALISATION AS SSIER_AUTRE_5_VISUALISATION_36, s0_.DOSSIER_AUTRE_5_EDITION AS DOSSIER_AUTRE_5_EDITION_37, s0_.PJ_ACTIVE AS PJ_ACTIVE_38, s0_.PJ_VISUALISATION AS PJ_VISUALISATION_39, s0_.PJ_EDITION AS PJ_EDITION_40, s0_.CONSEIL_RESTREINT AS CONSEIL_RESTREINT_41, s0_.CONSEIL_RESTREINT_VISU AS CONSEIL_RESTREINT_VISU_42, s0_.CONSEIL_RESTREINT_DUREE_VIE AS CONSEIL_RESTREINT_DUREE_VIE_43, s0_.CONSEIL_ACA AS CONSEIL_ACA_44, s0_.CONSEIL_ACA_VISUALISATION AS CONSEIL_ACA_VISUALISATION_45, s0_.CONSEIL_ACA_DUREE_VIE AS CONSEIL_ACA_DUREE_VIE_46, s0_.CONTRAT AS CONTRAT_47, s0_.CONTRAT_VISUALISATION AS CONTRAT_VISUALISATION_48, s0_.CONTRAT_DEPOT AS CONTRAT_DEPOT_49, s0_.CONTRAT_GENERATION AS CONTRAT_GENERATION_50, s0_.SERVICE_PREVU AS SERVICE_PREVU_51, s0_.SERVICE_PREVU_VISU AS SERVICE_PREVU_VISU_52, s0_.SERVICE_PREVU_EDITION AS SERVICE_PREVU_EDITION_53, s0_.SERVICE_REALISE AS SERVICE_REALISE_54, s0_.SERVICE_REALISE_VISU AS SERVICE_REALISE_VISU_55, s0_.SERVICE_REALISE_EDITION AS SERVICE_REALISE_EDITION_56, s0_.SERVICE_EXTERIEUR AS SERVICE_EXTERIEUR_57, s0_.REFERENTIEL_PREVU AS REFERENTIEL_PREVU_58, s0_.REFERENTIEL_PREVU_VISU AS REFERENTIEL_PREVU_VISU_59, s0_.REFERENTIEL_PREVU_EDITION AS REFERENTIEL_PREVU_EDITION_60, s0_.REFERENTIEL_REALISE AS REFERENTIEL_REALISE_61, s0_.REFERENTIEL_REALISE_VISU AS REFERENTIEL_REALISE_VISU_62, s0_.REFERENTIEL_REALISE_EDITION AS REFERENTIEL_REALISE_EDITION_63, s0_.MISSION AS MISSION_64, s0_.MISSION_VISUALISATION AS MISSION_VISUALISATION_65, s0_.MISSION_EDITION AS MISSION_EDITION_66, s0_.MISSION_REALISE_EDITION AS MISSION_REALISE_EDITION_67, s0_.MISSION_DECRET AS MISSION_DECRET_68, s0_.OFFRE_EMPLOI_POSTULER AS OFFRE_EMPLOI_POSTULER_69, s0_.MISSION_INDEMNITEES AS MISSION_INDEMNITEES_70, s0_.CLOTURE AS CLOTURE_71, s0_.MODIF_SERVICE_DU AS MODIF_SERVICE_DU_72, s0_.MODIF_SERVICE_DU_VISUALISATION AS IF_SERVICE_DU_VISUALISATION_73, s0_.PAIEMENT AS PAIEMENT_74, s0_.PAIEMENT_VISUALISATION AS PAIEMENT_VISUALISATION_75, s0_.MOTIF_NON_PAIEMENT AS MOTIF_NON_PAIEMENT_76, s0_.FORMULE_VISUALISATION AS FORMULE_VISUALISATION_77, s0_.CODES_CORRESP_1 AS CODES_CORRESP_1_78, s0_.CODES_CORRESP_2 AS CODES_CORRESP_2_79, s0_.CODES_CORRESP_3 AS CODES_CORRESP_3_80, s0_.CODES_CORRESP_4 AS CODES_CORRESP_4_81, s0_.MODE_ENSEIGNEMENT_PREVISIONNEL AS E_ENSEIGNEMENT_PREVISIONNEL_82, s0_.MODE_ENSEIGNEMENT_REALISE AS MODE_ENSEIGNEMENT_REALISE_83, s0_.MODE_CALCUL AS MODE_CALCUL_84, s0_.CODE_INDEMNITE AS CODE_INDEMNITE_85, s0_.TYPE_PAIE AS TYPE_PAIE_86, s0_.MODE_CALCUL_PRIME AS MODE_CALCUL_PRIME_87, s0_.CODE_INDEMNITE_PRIME AS CODE_INDEMNITE_PRIME_88, s0_.TYPE_PAIE_PRIME AS TYPE_PAIE_PRIME_89, s0_.HISTO_CREATION AS HISTO_CREATION_90, s0_.HISTO_MODIFICATION AS HISTO_MODIFICATION_91, s0_.HISTO_DESTRUCTION AS HISTO_DESTRUCTION_92, s0_.ID AS ID_93, s0_.TYPE_INTERVENANT_ID AS TYPE_INTERVENANT_ID_94, s0_.ANNEE_ID AS ANNEE_ID_95, s0_.CONTRAT_ETAT_SORTIE_ID AS CONTRAT_ETAT_SORTIE_ID_96, s0_.AVENANT_ETAT_SORTIE_ID AS AVENANT_ETAT_SORTIE_ID_97, s0_.HISTO_CREATEUR_ID AS HISTO_CREATEUR_ID_98, s0_.HISTO_MODIFICATEUR_ID AS HISTO_MODIFICATEUR_ID_99, s0_.HISTO_DESTRUCTEUR_ID AS HISTO_DESTRUCTEUR_ID_100, s0_.TAUX_REMU_ID AS TAUX_REMU_ID_101 FROM STATUT s0_ WHERE s0_.ANNEE_ID = ? AND s0_.HISTO_DESTRUCTION IS NULL ORDER BY s0_.ORDRE ASC Params 0 => int(2026)
Types 0 => string(7) "integer"
Time 0.0015418529510498

Appel Application/src/Provider/Role/RoleProvider.php(49): Application\Provider\Role\RoleProvider->makeRoles()
SQL SELECT t0.CODE AS CODE_1, t0.LIBELLE AS LIBELLE_2, t0.ID AS ID_3 FROM TYPE_INTERVENANT t0 WHERE t0.ID = ? Params 0 => int(2)
Types 0 => string(7) "integer"
Time 0.000610828399658203

Appel Application/src/Provider/Role/RoleProvider.php(49): Application\Provider\Role\RoleProvider->makeRoles()
SQL SELECT t0.CODE AS CODE_1, t0.LIBELLE AS LIBELLE_2, t0.ID AS ID_3 FROM TYPE_INTERVENANT t0 WHERE t0.ID = ? Params 0 => int(1)
Types 0 => string(7) "integer"
Time 0.000297069549560547

Appel Formule/src/Tbl/Process/FormuleProcess.php(102): Formule\Tbl\Process\FormuleProcess->init()
SQL SELECT nom, valeur FROM parametre Params Types Time 0.000982999801635742

Appel Formule/src/Tbl/Process/FormuleProcess.php(102): Formule\Tbl\Process\FormuleProcess->init()
SQL SELECT f0_.CODE AS CODE_0, f0_.LIBELLE AS LIBELLE_1, f0_.DELEGATION_ANNEE AS DELEGATION_ANNEE_2, f0_.DELEGATION_FORMULE AS DELEGATION_FORMULE_3, f0_.PHP_CLASS AS PHP_CLASS_4, f0_.ACTIVE AS ACTIVE_5, f0_.SQL_INTERVENANT AS SQL_INTERVENANT_6, f0_.SQL_VOLUME_HORAIRE AS SQL_VOLUME_HORAIRE_7, f0_.HEURES_SERVICE_FI_COL AS HEURES_SERVICE_FI_COL_8, f0_.HEURES_SERVICE_FA_COL AS HEURES_SERVICE_FA_COL_9, f0_.HEURES_SERVICE_FC_COL AS HEURES_SERVICE_FC_COL_10, f0_.HEURES_SERVICE_REFERENTIEL_COL AS RES_SERVICE_REFERENTIEL_COL_11, f0_.HEURES_COMPL_FI_COL AS HEURES_COMPL_FI_COL_12, f0_.HEURES_COMPL_FA_COL AS HEURES_COMPL_FA_COL_13, f0_.HEURES_COMPL_FC_COL AS HEURES_COMPL_FC_COL_14, f0_.HEURES_COMPL_REFERENTIEL_COL AS EURES_COMPL_REFERENTIEL_COL_15, f0_.HEURES_PRIMES_COL AS HEURES_PRIMES_COL_16, f0_.HEURES_NON_PAYABLE_FI_COL AS HEURES_NON_PAYABLE_FI_COL_17, f0_.HEURES_NON_PAYABLE_FA_COL AS HEURES_NON_PAYABLE_FA_COL_18, f0_.HEURES_NON_PAYABLE_FC_COL AS HEURES_NON_PAYABLE_FC_COL_19, f0_.HEURES_NON_PAYABLE_REFERENTIEL_COL AS NON_PAYABLE_REFERENTIEL_COL_20, f0_.I_PARAM_1_LIBELLE AS I_PARAM_1_LIBELLE_21, f0_.I_PARAM_2_LIBELLE AS I_PARAM_2_LIBELLE_22, f0_.I_PARAM_3_LIBELLE AS I_PARAM_3_LIBELLE_23, f0_.I_PARAM_4_LIBELLE AS I_PARAM_4_LIBELLE_24, f0_.I_PARAM_5_LIBELLE AS I_PARAM_5_LIBELLE_25, f0_.VH_PARAM_1_LIBELLE AS VH_PARAM_1_LIBELLE_26, f0_.VH_PARAM_2_LIBELLE AS VH_PARAM_2_LIBELLE_27, f0_.VH_PARAM_3_LIBELLE AS VH_PARAM_3_LIBELLE_28, f0_.VH_PARAM_4_LIBELLE AS VH_PARAM_4_LIBELLE_29, f0_.VH_PARAM_5_LIBELLE AS VH_PARAM_5_LIBELLE_30, f0_.ID AS ID_31 FROM FORMULE f0_ Params Types Time 0.000946998596191406

Appel Formule/src/Tbl/Process/FormuleProcess.php(104): Formule\Tbl\Process\FormuleProcess->load()
SQL SELECT TEXT FROM USER_VIEWS WHERE VIEW_NAME = 'V_FORMULE_VOLUME_HORAIRE' Params Types Time 0.000807046890258789

Appel Formule/src/Tbl/Process/FormuleProcess.php(104): Formule\Tbl\Process\FormuleProcess->load()
SQL SELECT fvh.*, CASE fvh.structure_is_exterieur WHEN 1 THEN 'Oui' ELSE 'Non' END param_1, fr.code param_2, NULL param_3, NULL param_4, NULL param_5 FROM (SELECT fri.id formule_resultat_intervenant_id, s.intervenant_id intervenant_id, vh.type_volume_horaire_id type_volume_horaire_id, vhe.etat_volume_horaire_id etat_volume_horaire_id, vh.id volume_horaire_id, NULL volume_horaire_ref_id, s.id service_id, NULL service_referentiel_id, str.code structure_code, ti.code type_intervention_code, CASE WHEN COALESCE(str.id,0) = COALESCE(to_number(p.valeur),0) THEN 1 ELSE 0 END structure_is_univ, CASE WHEN s.element_pedagogique_id IS NULL THEN 1 ELSE 0 END structure_is_exterieur, COALESCE(tf.service_statutaire,1) service_statutaire, CASE WHEN vh.motif_non_paiement_id IS NULL THEN 0 ELSE 1 END non_payable, CASE WHEN ep.id IS NOT NULL THEN ep.taux_fi ELSE 1 END taux_fi, CASE WHEN ep.id IS NOT NULL THEN ep.taux_fa ELSE 0 END taux_fa, CASE WHEN ep.id IS NOT NULL THEN ep.taux_fc ELSE 0 END taux_fc, COALESCE(tis.taux_hetd_service,ti.taux_hetd_service,1) taux_service_du, COALESCE(tis.taux_hetd_complementaire,ti.taux_hetd_complementaire,1) taux_service_compl, COALESCE(modu.ponderation_service_du,1) ponderation_service_du, COALESCE(modu.ponderation_service_compl,1) ponderation_service_compl, vh.heures heures, vh.horaire_debut horaire_debut, vh.horaire_fin horaire_fin FROM volume_horaire vh JOIN parametre p ON p.nom = 'structure_univ' JOIN service s ON s.id = vh.service_id JOIN intervenant i ON i.id = s.intervenant_id JOIN statut si ON si.id = i.statut_id JOIN type_intervention ti ON ti.id = vh.type_intervention_id JOIN v_vol_horaire_etat_multi vhe ON vhe.volume_horaire_id = vh.id JOIN type_volume_horaire tvh ON tvh.id = vh.type_volume_horaire_id LEFT JOIN element_pedagogique ep ON ep.id = s.element_pedagogique_id LEFT JOIN mv_modulateur modu ON modu.element_pedagogique_id = ep.id LEFT JOIN STRUCTURE str ON str.id = ep.structure_id LEFT JOIN etape e ON e.id = ep.etape_id LEFT JOIN type_formation tf ON tf.id = e.type_formation_id LEFT JOIN type_intervention_statut tis ON tis.type_intervention_id = ti.id AND tis.statut_id = i.statut_id LEFT JOIN formule_resultat_intervenant fri ON fri.intervenant_id = s.intervenant_id AND fri.type_volume_horaire_id = vh.type_volume_horaire_id AND fri.etat_volume_horaire_id = vhe.etat_volume_horaire_id WHERE vh.histo_destruction IS NULL AND s.histo_destruction IS NULL AND vh.heures <> 0 AND i.id = 781239 /*@STATUT_ID=si.id*/ /*@TYPE_INTERVENANT_ID=si.type_intervenant_id*/ /*@ANNEE_ID=i.annee_id*/ /*@TYPE_VOLUME_HORAIRE_ID=vh.type_volume_horaire_id*/ /*@ETAT_VOLUME_HORAIRE_ID<=vhe.etat_volume_horaire_id*/ UNION ALL SELECT fri.id formule_resultat_intervenant_id, sr.intervenant_id intervenant_id, vhr.type_volume_horaire_id type_volume_horaire_id, evh.id etat_volume_horaire_id, NULL volume_horaire_id, vhr.id volume_horaire_ref_id, NULL service_id, sr.id service_referentiel_id, s.code structure_code, NULL type_intervention_code, CASE WHEN COALESCE(sr.structure_id,0) = COALESCE(to_number(p.valeur),0) THEN 1 ELSE 0 END structure_is_univ, 0 structure_is_exterieur, COALESCE(fr.service_statutaire,1) service_statutaire, CASE WHEN sr.motif_non_paiement_id IS NULL THEN 0 ELSE 1 END non_payable, 1 taux_fi, 0 taux_fa, 0 taux_fc, 1 taux_service_du, 1 taux_service_compl, 1 ponderation_service_du, 1 ponderation_service_compl, vhr.heures heures, vhr.horaire_debut horaire_debut, vhr.horaire_fin horaire_fin FROM volume_horaire_ref vhr JOIN parametre p ON p.nom = 'structure_univ' JOIN service_referentiel sr ON sr.id = vhr.service_referentiel_id JOIN intervenant i ON i.id = sr.intervenant_id JOIN statut si ON si.id = i.statut_id JOIN v_vol_horaire_ref_etat_multi vher ON vher.volume_horaire_ref_id = vhr.id JOIN etat_volume_horaire evh ON evh.id = vher.etat_volume_horaire_id JOIN fonction_referentiel fr ON fr.id = sr.fonction_id JOIN type_volume_horaire tvh ON tvh.id = vhr.type_volume_horaire_id LEFT JOIN STRUCTURE s ON s.id = sr.structure_id LEFT JOIN formule_resultat_intervenant fri ON fri.intervenant_id = sr.intervenant_id AND fri.type_volume_horaire_id = vhr.type_volume_horaire_id AND fri.etat_volume_horaire_id = evh.id WHERE vhr.histo_destruction IS NULL AND sr.histo_destruction IS NULL AND vhr.heures <> 0 AND i.id = 781239 /*@STATUT_ID=si.id*/ /*@TYPE_INTERVENANT_ID=si.type_intervenant_id*/ /*@ANNEE_ID=i.annee_id*/ /*@TYPE_VOLUME_HORAIRE_ID=vhr.type_volume_horaire_id*/ /*@ETAT_VOLUME_HORAIRE_ID<=evh.id*/ ORDER BY horaire_fin, horaire_debut, volume_horaire_id, volume_horaire_ref_id) fvh LEFT JOIN service_referentiel sr ON sr.id = fvh.service_referentiel_id LEFT JOIN fonction_referentiel fr ON fr.id = sr.fonction_id Params Types Time 0.256287097930908

Appel Formule/src/Tbl/Process/FormuleProcess.php(104): Formule\Tbl\Process\FormuleProcess->load()
SQL SELECT TEXT FROM USER_VIEWS WHERE VIEW_NAME = 'V_FORMULE_INTERVENANT' Params Types Time 0.000680208206176758

Appel Formule/src/Tbl/Process/FormuleProcess.php(104): Formule\Tbl\Process\FormuleProcess->load()
SQL SELECT fi.*, NULL param_1, NULL param_2, NULL param_3, NULL param_4, NULL param_5 FROM (SELECT i.id intervenant_id, i.annee_id annee_id, ti.id type_intervenant_id, CASE WHEN ti.code = 'P' THEN s.code ELSE NULL END structure_code, si.service_statutaire heures_service_statutaire, COALESCE( SUM( msd.heures * mms.multiplicateur ), 0 ) heures_service_modifie, CASE WHEN si.depassement_service_du_sans_hc = 1 OR COALESCE( SUM( msd.heures * mms.multiplicateur * mms.decharge ), 0 ) <> 0 THEN 1 ELSE 0 END depassement_service_du_sans_hc, i.formule_calcul_arrondisseur arrondisseur FROM intervenant i JOIN statut si ON si.id = i.statut_id JOIN type_intervenant ti ON ti.id = si.type_intervenant_id LEFT JOIN structure s ON s.id = i.structure_id LEFT JOIN modification_service_du msd ON msd.intervenant_id = i.id AND msd.histo_destruction IS NULL LEFT JOIN motif_modification_service mms ON mms.id = msd.motif_id WHERE 1=1 AND i.id = 781239 /*@STATUT_ID=si.id*/ /*@TYPE_INTERVENANT_ID=ti.id*/ /*@ANNEE_ID=i.annee_id*/ /*@MOTIF_MODIFICATION_SERVICE_ID=mms.id*/ GROUP BY i.id, i.annee_id, i.structure_id, ti.id, ti.code, s.code, si.service_statutaire, si.depassement_service_du_sans_hc, i.formule_calcul_arrondisseur) fi Params Types Time 0.0120019912719727

Appel Application/view/layout/layout.phtml(15): Laminas\View\Renderer\PhpRenderer->__call()
SQL SELECT id FROM offre_emploi WHERE histo_destruction IS NULL AND validation_id IS NOT NULL Params Types Time 0.000454902648925781

Appel Application/view/layout/layout.phtml(84): Laminas\View\Renderer\PhpRenderer->__call()
SQL SELECT id, libelle FROM annee WHERE active = 1 ORDER BY id Params Types Time 0.00049591064453125