OSE

Other Route Parameters

 array:1 [
  "view" => "TblPaiement debug"
]

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.000498056411743164

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.00206279754638672

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.000581979751586914

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.00142884254455566

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.000668048858642578

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.000265121459960938

Appel Paiement/src/Tbl/Process/PaiementProcess.php(90): Paiement\Tbl\Process\PaiementProcess->heuresAPayerSql()
SQL SELECT TEXT FROM USER_VIEWS WHERE VIEW_NAME = 'V_TBL_PAIEMENT' Params Types Time 0.00153207778930664

Appel Paiement/src/Tbl/Process/PaiementProcess.php(94): Doctrine\DBAL\Connection->executeQuery()
SQL SELECT * FROM (SELECT -- heures d'enseignement par volume horaire payées ou non 'e' || '-' || s.id || '-' || COALESCE(thens.id,th.id) KEY, CASE WHEN si.mode_enseignement_realise = 'semestriel' THEN 1 ELSE 0 END calcul_semestriel, vh.id a_payer_id, i.annee_id annee_id, frvh.service_id service_id, NULL service_referentiel_id, NULL mission_id, vh.id volume_horaire_id, si.type_intervenant_id type_intervenant_id, i.id intervenant_id, str.id structure_id, COALESCE(thens.id,th.id) type_heures_id, COALESCE(e.domaine_fonctionnel_id, str.domaine_fonctionnel_id, ose_parametre.get_domaine_fonc_ens_ext) def_domaine_fonctionnel_id, COALESCE(ccep.centre_cout_id,str.centre_cout_id) def_centre_cout_id, COALESCE(ep.taux_remu_id, si.taux_remu_id, ose_parametre.get_taux_remu) taux_remu_id, 1 taux_conges_payes, CASE th.code WHEN 'fi' THEN frvh.heures_compl_fi WHEN 'fa' THEN frvh.heures_compl_fa WHEN 'fc' THEN frvh.heures_compl_fc WHEN 'primes' THEN frvh.heures_primes WHEN 'enseignement' THEN frvh.heures_compl_fi + frvh.heures_compl_fa + frvh.heures_compl_fc + frvh.heures_primes END heures, prd.id periode_ens_id, prd.code periode_ens_code, COALESCE(vh.horaire_debut, add_months(a.date_debut, prd.ecart_mois)) horaire_debut, COALESCE(vh.horaire_fin, add_months(a.date_debut, prd.ecart_mois + 5)) horaire_fin, mep.id mise_en_paiement_id, mep.date_mise_en_paiement date_mise_en_paiement, mep.periode_paiement_id periode_paiement_id, mep.centre_cout_id mep_centre_cout_id, mep.heures mep_heures, mep.domaine_fonctionnel_id mep_domaine_fonctionnel_id FROM formule_resultat_volume_horaire frvh JOIN parametre p ON p.nom = 'distinction_fi_fa_fc' JOIN parametre ccp ON ccp.nom = 'centres_couts_paye' JOIN volume_horaire vh ON vh.id = frvh.volume_horaire_id JOIN type_volume_horaire tvh ON tvh.code = 'REALISE' JOIN etat_volume_horaire evh ON evh.code = 'valide' JOIN type_heures th ON (p.valeur = '1' AND th.code IN ('fi', 'fa', 'fc', 'primes')) OR (p.valeur = '0' AND th.code = 'enseignement') JOIN formule_resultat_intervenant fr ON fr.id = frvh.formule_resultat_intervenant_id AND fr.type_volume_horaire_id = tvh.id AND fr.etat_volume_horaire_id = evh.id JOIN periode prd ON prd.id = vh.periode_id JOIN intervenant i ON i.id = fr.intervenant_id JOIN annee a ON a.id = i.annee_id JOIN statut si ON si.id = i.statut_id JOIN type_intervenant ti ON ti.id = si.type_intervenant_id JOIN service s ON s.id = frvh.service_id LEFT JOIN type_heures thens ON thens.code = 'enseignement' AND p.valeur = '0' LEFT JOIN element_pedagogique ep ON ep.id = s.element_pedagogique_id LEFT JOIN etape e ON e.id = ep.etape_id LEFT JOIN centre_cout_ep ccep ON ccep.histo_destruction IS NULL AND ccep.element_pedagogique_id = ep.id AND ccep.type_heures_id = th.type_heures_element_id LEFT JOIN mise_en_paiement mep ON mep.histo_destruction IS NULL AND mep.service_id = frvh.service_id AND COALESCE(thens.id,mep.type_heures_id) = COALESCE(thens.id,th.id) LEFT JOIN STRUCTURE str ON str.id = CASE WHEN ccp.valeur = 'enseignement' OR ti.code = 'E' THEN COALESCE( ep.structure_id, i.structure_id ) ELSE i.structure_id END WHERE 1=1 AND fr.intervenant_id = 32779 /*@ANNEE_ID=i.annee_id*/ /*@SERVICE_ID=frvh.service_id*/ UNION ALL SELECT -- paiements sur d'anciens volumes horaires d'enseignement 'e' || '-' || mep.service_id || '-' || mep.type_heures_id KEY, CASE WHEN si.mode_enseignement_realise = 'semestriel' THEN 1 ELSE 0 END calcul_semestriel, mep.id a_payer_id, i.annee_id annee_id, s.id service_id, NULL service_referentiel_id, NULL mission_id, NULL volume_horaire_id, si.type_intervenant_id type_intervenant_id, i.id intervenant_id, str.id structure_id, mep.type_heures_id type_heures_id, NULL def_domaine_fonctionnel_id, str.centre_cout_id def_centre_cout_id, COALESCE(ep.taux_remu_id, si.taux_remu_id, ose_parametre.get_taux_remu) taux_remu_id, 1 taux_conges_payes, 0 heures, NULL periode_ens_id, NULL periode_ens_code, a.date_debut horaire_debut, a.date_fin horaire_fin, mep.id mise_en_paiement_id, mep.date_mise_en_paiement date_mise_en_paiement, mep.periode_paiement_id periode_paiement_id, mep.centre_cout_id mep_centre_cout_id, mep.heures mep_heures, mep.domaine_fonctionnel_id mep_domaine_fonctionnel_id FROM mise_en_paiement mep JOIN service s ON s.id = mep.service_id JOIN intervenant i ON i.id = s.intervenant_id JOIN annee a ON a.id = i.annee_id JOIN statut si ON si.id = i.statut_id JOIN type_intervenant ti ON ti.id = si.type_intervenant_id JOIN parametre ccp ON ccp.nom = 'centres_couts_paye' JOIN type_volume_horaire tvh ON tvh.code = 'REALISE' JOIN etat_volume_horaire evh ON tvh.code = 'valide' LEFT JOIN element_pedagogique ep ON ep.id = s.element_pedagogique_id AND ccp.valeur = 'enseignement' OR ti.code = 'E' LEFT JOIN STRUCTURE str ON str.id = COALESCE( ep.structure_id, i.structure_id ) LEFT JOIN formule_resultat_intervenant fri ON fri.type_volume_horaire_id = tvh.id AND fri.etat_volume_horaire_id = evh.id AND fri.intervenant_id = i.id LEFT JOIN formule_resultat_volume_horaire frvh ON frvh.formule_resultat_intervenant_id = fri.id AND frvh.service_id = s.id WHERE mep.histo_destruction IS NULL AND frvh.id IS NULL AND i.id = 32779 /*@ANNEE_ID=i.annee_id*/ /*@SERVICE_ID=s.id*/ UNION ALL SELECT -- paiements sur des heures de référentiel 'r' || '-' || sr.id || '-' || th.id KEY, 1 calcul_semestriel, frvh.volume_horaire_ref_id a_payer_id, i.annee_id annee_id, NULL service_id, frvh.service_referentiel_id service_referentiel_id, NULL mission_id, frvh.volume_horaire_ref_id volume_horaire_id, si.type_intervenant_id type_intervenant_id, i.id intervenant_id, str.id structure_id, th.id type_heures_id, fr.domaine_fonctionnel_id def_domaine_fonctionnel_id, str.centre_cout_id def_centre_cout_id, COALESCE(si.taux_remu_id, ose_parametre.get_taux_remu) taux_remu_id, 1 taux_conges_payes, frvh.heures_compl_referentiel heures, NULL periode_ens_id, NULL periode_ens_code, a.date_debut horaire_debut, a.date_fin horaire_fin, mep.id mise_en_paiement_id, mep.date_mise_en_paiement date_mise_en_paiement, mep.periode_paiement_id periode_paiement_id, mep.centre_cout_id mep_centre_cout_id, mep.heures mep_heures, mep.domaine_fonctionnel_id mep_domaine_fonctionnel_id FROM formule_resultat_volume_horaire frvh JOIN type_volume_horaire tvh ON tvh.code = 'REALISE' JOIN etat_volume_horaire evh ON evh.code = 'valide' JOIN type_heures th ON th.code = 'referentiel' JOIN formule_resultat_intervenant fri ON fri.id = frvh.formule_resultat_intervenant_id AND fri.type_volume_horaire_id = tvh.id AND fri.etat_volume_horaire_id = evh.id JOIN parametre ccp ON ccp.nom = 'centres_couts_paye' JOIN intervenant i ON i.id = fri.intervenant_id JOIN annee a ON a.id = i.annee_id JOIN statut si ON si.id = i.statut_id JOIN type_intervenant ti ON ti.id = si.type_intervenant_id JOIN service_referentiel sr ON sr.id = frvh.service_referentiel_id JOIN fonction_referentiel fr ON fr.id = sr.fonction_id LEFT JOIN mise_en_paiement mep ON mep.histo_destruction IS NULL AND mep.service_referentiel_id = frvh.service_referentiel_id AND mep.type_heures_id = th.id LEFT JOIN STRUCTURE str ON str.id = CASE WHEN ccp.valeur = 'enseignement' OR ti.code = 'E' THEN sr.structure_id ELSE i.structure_id END WHERE 1=1 AND i.id = 32779 /*@ANNEE_ID=i.annee_id*/ /*@SERVICE_REFERENTIEL_ID=frsr.service_referentiel_id*/ UNION ALL SELECT -- paiements sur d'anciens volumes horaires référentiels 'e' || '-' || sr.id || '-' || mep.type_heures_id KEY, CASE WHEN si.mode_enseignement_realise = 'semestriel' THEN 1 ELSE 0 END calcul_semestriel, mep.id a_payer_id, i.annee_id annee_id, NULL service_id, sr.id service_referentiel_id, NULL mission_id, NULL volume_horaire_id, si.type_intervenant_id type_intervenant_id, i.id intervenant_id, str.id structure_id, mep.type_heures_id type_heures_id, NULL def_domaine_fonctionnel_id, str.centre_cout_id def_centre_cout_id, COALESCE(si.taux_remu_id, ose_parametre.get_taux_remu) taux_remu_id, 1 taux_conges_payes, 0 heures, NULL periode_ens_id, NULL periode_ens_code, a.date_debut horaire_debut, a.date_fin horaire_fin, mep.id mise_en_paiement_id, mep.date_mise_en_paiement date_mise_en_paiement, mep.periode_paiement_id periode_paiement_id, mep.centre_cout_id mep_centre_cout_id, mep.heures mep_heures, mep.domaine_fonctionnel_id mep_domaine_fonctionnel_id FROM mise_en_paiement mep JOIN service_referentiel sr ON sr.id = mep.service_referentiel_id JOIN intervenant i ON i.id = sr.intervenant_id JOIN annee a ON a.id = i.annee_id JOIN statut si ON si.id = i.statut_id JOIN type_intervenant ti ON ti.id = si.type_intervenant_id JOIN parametre ccp ON ccp.nom = 'centres_couts_paye' JOIN type_volume_horaire tvh ON tvh.code = 'REALISE' JOIN etat_volume_horaire evh ON tvh.code = 'valide' LEFT JOIN STRUCTURE str ON str.id = CASE WHEN ccp.valeur = 'enseignement' OR ti.code = 'E' THEN COALESCE( sr.structure_id, i.structure_id ) ELSE i.structure_id END LEFT JOIN formule_resultat_intervenant fri ON fri.type_volume_horaire_id = tvh.id AND fri.etat_volume_horaire_id = evh.id AND fri.intervenant_id = i.id LEFT JOIN formule_resultat_volume_horaire frvh ON frvh.formule_resultat_intervenant_id = fri.id AND frvh.service_referentiel_id = sr.id WHERE mep.histo_destruction IS NULL AND frvh.id IS NULL AND i.id = 32779 /*@ANNEE_ID=i.annee_id*/ /*@SERVICE_ID=s.id*/ UNION ALL SELECT -- paiements sur des heures de mission 'm' || '-' || m.id || '-' || th.id KEY, 0 calcul_semestriel, vhm.id a_payer_id, tm.annee_id annee_id, NULL service_id, NULL service_referentiel_id, m.id mission_id, vhm.id volume_horaire_id, si.type_intervenant_id type_intervenant_id, tm.intervenant_id intervenant_id, str.id structure_id, th.id type_heures_id, str.domaine_fonctionnel_id def_domaine_fonctionnel_id, str.centre_cout_id def_centre_cout_id, CASE WHEN TO_CHAR( vhm.horaire_debut, 'HH24:MI' ) >= ose_parametre.get_horaire_nocturne -- horaire nocturne OR jf.id IS NOT NULL -- jour ferie OR TO_CHAR(vhm.horaire_debut, 'DAY', 'NLS_DATE_LANGUAGE=FRENCH') = 'DIMANCHE' -- dimanche THEN COALESCE(m.taux_remu_majore_id, m.taux_remu_id) ELSE m.taux_remu_id END taux_remu_id, ose_parametre.get_taux_conges_payes+1 taux_conges_payes, vhm.heures heures, NULL periode_ens_id, NULL periode_ens_code, COALESCE(vhm.horaire_debut,m.date_debut) horaire_debut, COALESCE(vhm.horaire_fin,m.date_fin) horaire_fin, mep.id mise_en_paiement_id, mep.date_mise_en_paiement date_mise_en_paiement, mep.periode_paiement_id periode_paiement_id, mep.centre_cout_id mep_centre_cout_id, mep.heures mep_heures, mep.domaine_fonctionnel_id mep_domaine_fonctionnel_id FROM tbl_mission tm JOIN mission m ON m.id = tm.mission_id JOIN intervenant i ON i.id = m.intervenant_id JOIN statut si ON si.id = i.statut_id JOIN type_intervenant ti ON ti.id = si.type_intervenant_id JOIN volume_horaire_mission vhm ON vhm.histo_destruction IS NULL AND vhm.mission_id = tm.mission_id JOIN type_volume_horaire tvh ON tvh.id = vhm.type_volume_horaire_id AND tvh.code ='REALISE' JOIN type_heures th ON th.code = 'mission' JOIN parametre ccp ON ccp.nom = 'centres_couts_paye' LEFT JOIN validation_vol_horaire_miss vvhm ON vvhm.volume_horaire_mission_id = vhm.id LEFT JOIN validation v ON v.id = vvhm.validation_id AND v.histo_destruction IS NULL LEFT JOIN jour_ferie jf ON TO_CHAR( jf.date_jour, 'dd/mm/YYYY' ) = TO_CHAR( vhm.horaire_debut, 'dd/mm/YYYY' ) LEFT JOIN mise_en_paiement mep ON mep.histo_destruction IS NULL AND mep.mission_id = m.id AND mep.type_heures_id = th.id LEFT JOIN STRUCTURE str ON str.id = CASE WHEN ccp.valeur = 'enseignement' OR ti.code = 'E' THEN COALESCE( m.structure_id, i.structure_id ) ELSE i.structure_id END WHERE tm.valide = 1 /*@ANNEE_ID=tm.annee_id*/ AND tm.intervenant_id = 32779 /*@MISSION_ID=tm.mission_id*/ AND (vhm.auto_validation = 1 OR v.id IS NOT NULL) ORDER BY intervenant_id, horaire_debut, a_payer_id, mise_en_paiement_id) t WHERE INTERVENANT_ID = 32779 Params Types Time 0.346516132354736

Appel Paiement/src/Tbl/Process/PaiementProcess.php(77): Paiement\Tbl\Process\PaiementProcess->init()
SQL SELECT nom, valeur FROM parametre Params Types Time 0.000962972640991211

Appel Paiement/src/Tbl/Process/PaiementProcess.php(78): Paiement\Tbl\Process\PaiementProcess->loadAPayer()
SQL SELECT * FROM (SELECT -- heures d'enseignement par volume horaire payées ou non 'e' || '-' || s.id || '-' || COALESCE(thens.id,th.id) KEY, CASE WHEN si.mode_enseignement_realise = 'semestriel' THEN 1 ELSE 0 END calcul_semestriel, vh.id a_payer_id, i.annee_id annee_id, frvh.service_id service_id, NULL service_referentiel_id, NULL mission_id, vh.id volume_horaire_id, si.type_intervenant_id type_intervenant_id, i.id intervenant_id, str.id structure_id, COALESCE(thens.id,th.id) type_heures_id, COALESCE(e.domaine_fonctionnel_id, str.domaine_fonctionnel_id, ose_parametre.get_domaine_fonc_ens_ext) def_domaine_fonctionnel_id, COALESCE(ccep.centre_cout_id,str.centre_cout_id) def_centre_cout_id, COALESCE(ep.taux_remu_id, si.taux_remu_id, ose_parametre.get_taux_remu) taux_remu_id, 1 taux_conges_payes, CASE th.code WHEN 'fi' THEN frvh.heures_compl_fi WHEN 'fa' THEN frvh.heures_compl_fa WHEN 'fc' THEN frvh.heures_compl_fc WHEN 'primes' THEN frvh.heures_primes WHEN 'enseignement' THEN frvh.heures_compl_fi + frvh.heures_compl_fa + frvh.heures_compl_fc + frvh.heures_primes END heures, prd.id periode_ens_id, prd.code periode_ens_code, COALESCE(vh.horaire_debut, add_months(a.date_debut, prd.ecart_mois)) horaire_debut, COALESCE(vh.horaire_fin, add_months(a.date_debut, prd.ecart_mois + 5)) horaire_fin, mep.id mise_en_paiement_id, mep.date_mise_en_paiement date_mise_en_paiement, mep.periode_paiement_id periode_paiement_id, mep.centre_cout_id mep_centre_cout_id, mep.heures mep_heures, mep.domaine_fonctionnel_id mep_domaine_fonctionnel_id FROM formule_resultat_volume_horaire frvh JOIN parametre p ON p.nom = 'distinction_fi_fa_fc' JOIN parametre ccp ON ccp.nom = 'centres_couts_paye' JOIN volume_horaire vh ON vh.id = frvh.volume_horaire_id JOIN type_volume_horaire tvh ON tvh.code = 'REALISE' JOIN etat_volume_horaire evh ON evh.code = 'valide' JOIN type_heures th ON (p.valeur = '1' AND th.code IN ('fi', 'fa', 'fc', 'primes')) OR (p.valeur = '0' AND th.code = 'enseignement') JOIN formule_resultat_intervenant fr ON fr.id = frvh.formule_resultat_intervenant_id AND fr.type_volume_horaire_id = tvh.id AND fr.etat_volume_horaire_id = evh.id JOIN periode prd ON prd.id = vh.periode_id JOIN intervenant i ON i.id = fr.intervenant_id JOIN annee a ON a.id = i.annee_id JOIN statut si ON si.id = i.statut_id JOIN type_intervenant ti ON ti.id = si.type_intervenant_id JOIN service s ON s.id = frvh.service_id LEFT JOIN type_heures thens ON thens.code = 'enseignement' AND p.valeur = '0' LEFT JOIN element_pedagogique ep ON ep.id = s.element_pedagogique_id LEFT JOIN etape e ON e.id = ep.etape_id LEFT JOIN centre_cout_ep ccep ON ccep.histo_destruction IS NULL AND ccep.element_pedagogique_id = ep.id AND ccep.type_heures_id = th.type_heures_element_id LEFT JOIN mise_en_paiement mep ON mep.histo_destruction IS NULL AND mep.service_id = frvh.service_id AND COALESCE(thens.id,mep.type_heures_id) = COALESCE(thens.id,th.id) LEFT JOIN STRUCTURE str ON str.id = CASE WHEN ccp.valeur = 'enseignement' OR ti.code = 'E' THEN COALESCE( ep.structure_id, i.structure_id ) ELSE i.structure_id END WHERE 1=1 AND fr.intervenant_id = 32779 /*@ANNEE_ID=i.annee_id*/ /*@SERVICE_ID=frvh.service_id*/ UNION ALL SELECT -- paiements sur d'anciens volumes horaires d'enseignement 'e' || '-' || mep.service_id || '-' || mep.type_heures_id KEY, CASE WHEN si.mode_enseignement_realise = 'semestriel' THEN 1 ELSE 0 END calcul_semestriel, mep.id a_payer_id, i.annee_id annee_id, s.id service_id, NULL service_referentiel_id, NULL mission_id, NULL volume_horaire_id, si.type_intervenant_id type_intervenant_id, i.id intervenant_id, str.id structure_id, mep.type_heures_id type_heures_id, NULL def_domaine_fonctionnel_id, str.centre_cout_id def_centre_cout_id, COALESCE(ep.taux_remu_id, si.taux_remu_id, ose_parametre.get_taux_remu) taux_remu_id, 1 taux_conges_payes, 0 heures, NULL periode_ens_id, NULL periode_ens_code, a.date_debut horaire_debut, a.date_fin horaire_fin, mep.id mise_en_paiement_id, mep.date_mise_en_paiement date_mise_en_paiement, mep.periode_paiement_id periode_paiement_id, mep.centre_cout_id mep_centre_cout_id, mep.heures mep_heures, mep.domaine_fonctionnel_id mep_domaine_fonctionnel_id FROM mise_en_paiement mep JOIN service s ON s.id = mep.service_id JOIN intervenant i ON i.id = s.intervenant_id JOIN annee a ON a.id = i.annee_id JOIN statut si ON si.id = i.statut_id JOIN type_intervenant ti ON ti.id = si.type_intervenant_id JOIN parametre ccp ON ccp.nom = 'centres_couts_paye' JOIN type_volume_horaire tvh ON tvh.code = 'REALISE' JOIN etat_volume_horaire evh ON tvh.code = 'valide' LEFT JOIN element_pedagogique ep ON ep.id = s.element_pedagogique_id AND ccp.valeur = 'enseignement' OR ti.code = 'E' LEFT JOIN STRUCTURE str ON str.id = COALESCE( ep.structure_id, i.structure_id ) LEFT JOIN formule_resultat_intervenant fri ON fri.type_volume_horaire_id = tvh.id AND fri.etat_volume_horaire_id = evh.id AND fri.intervenant_id = i.id LEFT JOIN formule_resultat_volume_horaire frvh ON frvh.formule_resultat_intervenant_id = fri.id AND frvh.service_id = s.id WHERE mep.histo_destruction IS NULL AND frvh.id IS NULL AND i.id = 32779 /*@ANNEE_ID=i.annee_id*/ /*@SERVICE_ID=s.id*/ UNION ALL SELECT -- paiements sur des heures de référentiel 'r' || '-' || sr.id || '-' || th.id KEY, 1 calcul_semestriel, frvh.volume_horaire_ref_id a_payer_id, i.annee_id annee_id, NULL service_id, frvh.service_referentiel_id service_referentiel_id, NULL mission_id, frvh.volume_horaire_ref_id volume_horaire_id, si.type_intervenant_id type_intervenant_id, i.id intervenant_id, str.id structure_id, th.id type_heures_id, fr.domaine_fonctionnel_id def_domaine_fonctionnel_id, str.centre_cout_id def_centre_cout_id, COALESCE(si.taux_remu_id, ose_parametre.get_taux_remu) taux_remu_id, 1 taux_conges_payes, frvh.heures_compl_referentiel heures, NULL periode_ens_id, NULL periode_ens_code, a.date_debut horaire_debut, a.date_fin horaire_fin, mep.id mise_en_paiement_id, mep.date_mise_en_paiement date_mise_en_paiement, mep.periode_paiement_id periode_paiement_id, mep.centre_cout_id mep_centre_cout_id, mep.heures mep_heures, mep.domaine_fonctionnel_id mep_domaine_fonctionnel_id FROM formule_resultat_volume_horaire frvh JOIN type_volume_horaire tvh ON tvh.code = 'REALISE' JOIN etat_volume_horaire evh ON evh.code = 'valide' JOIN type_heures th ON th.code = 'referentiel' JOIN formule_resultat_intervenant fri ON fri.id = frvh.formule_resultat_intervenant_id AND fri.type_volume_horaire_id = tvh.id AND fri.etat_volume_horaire_id = evh.id JOIN parametre ccp ON ccp.nom = 'centres_couts_paye' JOIN intervenant i ON i.id = fri.intervenant_id JOIN annee a ON a.id = i.annee_id JOIN statut si ON si.id = i.statut_id JOIN type_intervenant ti ON ti.id = si.type_intervenant_id JOIN service_referentiel sr ON sr.id = frvh.service_referentiel_id JOIN fonction_referentiel fr ON fr.id = sr.fonction_id LEFT JOIN mise_en_paiement mep ON mep.histo_destruction IS NULL AND mep.service_referentiel_id = frvh.service_referentiel_id AND mep.type_heures_id = th.id LEFT JOIN STRUCTURE str ON str.id = CASE WHEN ccp.valeur = 'enseignement' OR ti.code = 'E' THEN sr.structure_id ELSE i.structure_id END WHERE 1=1 AND i.id = 32779 /*@ANNEE_ID=i.annee_id*/ /*@SERVICE_REFERENTIEL_ID=frsr.service_referentiel_id*/ UNION ALL SELECT -- paiements sur d'anciens volumes horaires référentiels 'e' || '-' || sr.id || '-' || mep.type_heures_id KEY, CASE WHEN si.mode_enseignement_realise = 'semestriel' THEN 1 ELSE 0 END calcul_semestriel, mep.id a_payer_id, i.annee_id annee_id, NULL service_id, sr.id service_referentiel_id, NULL mission_id, NULL volume_horaire_id, si.type_intervenant_id type_intervenant_id, i.id intervenant_id, str.id structure_id, mep.type_heures_id type_heures_id, NULL def_domaine_fonctionnel_id, str.centre_cout_id def_centre_cout_id, COALESCE(si.taux_remu_id, ose_parametre.get_taux_remu) taux_remu_id, 1 taux_conges_payes, 0 heures, NULL periode_ens_id, NULL periode_ens_code, a.date_debut horaire_debut, a.date_fin horaire_fin, mep.id mise_en_paiement_id, mep.date_mise_en_paiement date_mise_en_paiement, mep.periode_paiement_id periode_paiement_id, mep.centre_cout_id mep_centre_cout_id, mep.heures mep_heures, mep.domaine_fonctionnel_id mep_domaine_fonctionnel_id FROM mise_en_paiement mep JOIN service_referentiel sr ON sr.id = mep.service_referentiel_id JOIN intervenant i ON i.id = sr.intervenant_id JOIN annee a ON a.id = i.annee_id JOIN statut si ON si.id = i.statut_id JOIN type_intervenant ti ON ti.id = si.type_intervenant_id JOIN parametre ccp ON ccp.nom = 'centres_couts_paye' JOIN type_volume_horaire tvh ON tvh.code = 'REALISE' JOIN etat_volume_horaire evh ON tvh.code = 'valide' LEFT JOIN STRUCTURE str ON str.id = CASE WHEN ccp.valeur = 'enseignement' OR ti.code = 'E' THEN COALESCE( sr.structure_id, i.structure_id ) ELSE i.structure_id END LEFT JOIN formule_resultat_intervenant fri ON fri.type_volume_horaire_id = tvh.id AND fri.etat_volume_horaire_id = evh.id AND fri.intervenant_id = i.id LEFT JOIN formule_resultat_volume_horaire frvh ON frvh.formule_resultat_intervenant_id = fri.id AND frvh.service_referentiel_id = sr.id WHERE mep.histo_destruction IS NULL AND frvh.id IS NULL AND i.id = 32779 /*@ANNEE_ID=i.annee_id*/ /*@SERVICE_ID=s.id*/ UNION ALL SELECT -- paiements sur des heures de mission 'm' || '-' || m.id || '-' || th.id KEY, 0 calcul_semestriel, vhm.id a_payer_id, tm.annee_id annee_id, NULL service_id, NULL service_referentiel_id, m.id mission_id, vhm.id volume_horaire_id, si.type_intervenant_id type_intervenant_id, tm.intervenant_id intervenant_id, str.id structure_id, th.id type_heures_id, str.domaine_fonctionnel_id def_domaine_fonctionnel_id, str.centre_cout_id def_centre_cout_id, CASE WHEN TO_CHAR( vhm.horaire_debut, 'HH24:MI' ) >= ose_parametre.get_horaire_nocturne -- horaire nocturne OR jf.id IS NOT NULL -- jour ferie OR TO_CHAR(vhm.horaire_debut, 'DAY', 'NLS_DATE_LANGUAGE=FRENCH') = 'DIMANCHE' -- dimanche THEN COALESCE(m.taux_remu_majore_id, m.taux_remu_id) ELSE m.taux_remu_id END taux_remu_id, ose_parametre.get_taux_conges_payes+1 taux_conges_payes, vhm.heures heures, NULL periode_ens_id, NULL periode_ens_code, COALESCE(vhm.horaire_debut,m.date_debut) horaire_debut, COALESCE(vhm.horaire_fin,m.date_fin) horaire_fin, mep.id mise_en_paiement_id, mep.date_mise_en_paiement date_mise_en_paiement, mep.periode_paiement_id periode_paiement_id, mep.centre_cout_id mep_centre_cout_id, mep.heures mep_heures, mep.domaine_fonctionnel_id mep_domaine_fonctionnel_id FROM tbl_mission tm JOIN mission m ON m.id = tm.mission_id JOIN intervenant i ON i.id = m.intervenant_id JOIN statut si ON si.id = i.statut_id JOIN type_intervenant ti ON ti.id = si.type_intervenant_id JOIN volume_horaire_mission vhm ON vhm.histo_destruction IS NULL AND vhm.mission_id = tm.mission_id JOIN type_volume_horaire tvh ON tvh.id = vhm.type_volume_horaire_id AND tvh.code ='REALISE' JOIN type_heures th ON th.code = 'mission' JOIN parametre ccp ON ccp.nom = 'centres_couts_paye' LEFT JOIN validation_vol_horaire_miss vvhm ON vvhm.volume_horaire_mission_id = vhm.id LEFT JOIN validation v ON v.id = vvhm.validation_id AND v.histo_destruction IS NULL LEFT JOIN jour_ferie jf ON TO_CHAR( jf.date_jour, 'dd/mm/YYYY' ) = TO_CHAR( vhm.horaire_debut, 'dd/mm/YYYY' ) LEFT JOIN mise_en_paiement mep ON mep.histo_destruction IS NULL AND mep.mission_id = m.id AND mep.type_heures_id = th.id LEFT JOIN STRUCTURE str ON str.id = CASE WHEN ccp.valeur = 'enseignement' OR ti.code = 'E' THEN COALESCE( m.structure_id, i.structure_id ) ELSE i.structure_id END WHERE tm.valide = 1 /*@ANNEE_ID=tm.annee_id*/ AND tm.intervenant_id = 32779 /*@MISSION_ID=tm.mission_id*/ AND (vhm.auto_validation = 1 OR v.id IS NOT NULL) ORDER BY intervenant_id, horaire_debut, a_payer_id, mise_en_paiement_id) t WHERE INTERVENANT_ID = 32779 Params Types Time 0.00106692314147949

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.000814199447631836

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.000612974166870117

Data en entrée

Résultat