OSE

Other Route Parameters

^ array:1 [
  "view" => "test3"
]

Appel Application/Application.php(117): Application::start()
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.0012891292572021

Appel Application/Application.php(117): Application::start()
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.0017209053039551

Appel Application/Application.php(117): Application::start()
SQL SELECT nom, valeur FROM parametre Params Types Time 0.0016460418701172

Appel Application/Application.php(117): Application::start()
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(2023)
Types 0 => string(7) "integer"
Time 0.0019998550415039

Appel Application/Application.php(117): Application::start()
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_EMPLOYEUR_FACULTATIF AS OSSIER_EMPLOYEUR_FACULTATIF_16, s0_.DOSSIER_ADRESSE AS DOSSIER_ADRESSE_17, s0_.DOSSIER_BANQUE AS DOSSIER_BANQUE_18, s0_.DOSSIER_INSEE AS DOSSIER_INSEE_19, s0_.DOSSIER_STATUT AS DOSSIER_STATUT_20, s0_.DOSSIER_EMPLOYEUR AS DOSSIER_EMPLOYEUR_21, s0_.DOSSIER_AUTRE_1 AS DOSSIER_AUTRE_1_22, s0_.DOSSIER_AUTRE_1_VISUALISATION AS SSIER_AUTRE_1_VISUALISATION_23, s0_.DOSSIER_AUTRE_1_EDITION AS DOSSIER_AUTRE_1_EDITION_24, s0_.DOSSIER_AUTRE_2 AS DOSSIER_AUTRE_2_25, s0_.DOSSIER_AUTRE_2_VISUALISATION AS SSIER_AUTRE_2_VISUALISATION_26, s0_.DOSSIER_AUTRE_2_EDITION AS DOSSIER_AUTRE_2_EDITION_27, s0_.DOSSIER_AUTRE_3 AS DOSSIER_AUTRE_3_28, s0_.DOSSIER_AUTRE_3_VISUALISATION AS SSIER_AUTRE_3_VISUALISATION_29, s0_.DOSSIER_AUTRE_3_EDITION AS DOSSIER_AUTRE_3_EDITION_30, s0_.DOSSIER_AUTRE_4 AS DOSSIER_AUTRE_4_31, s0_.DOSSIER_AUTRE_4_VISUALISATION AS SSIER_AUTRE_4_VISUALISATION_32, s0_.DOSSIER_AUTRE_4_EDITION AS DOSSIER_AUTRE_4_EDITION_33, s0_.DOSSIER_AUTRE_5 AS DOSSIER_AUTRE_5_34, s0_.DOSSIER_AUTRE_5_VISUALISATION AS SSIER_AUTRE_5_VISUALISATION_35, s0_.DOSSIER_AUTRE_5_EDITION AS DOSSIER_AUTRE_5_EDITION_36, s0_.PJ_VISUALISATION AS PJ_VISUALISATION_37, s0_.PJ_EDITION AS PJ_EDITION_38, s0_.CONSEIL_RESTREINT AS CONSEIL_RESTREINT_39, s0_.CONSEIL_RESTREINT_VISU AS CONSEIL_RESTREINT_VISU_40, s0_.CONSEIL_RESTREINT_DUREE_VIE AS CONSEIL_RESTREINT_DUREE_VIE_41, s0_.CONSEIL_ACA AS CONSEIL_ACA_42, s0_.CONSEIL_ACA_VISUALISATION AS CONSEIL_ACA_VISUALISATION_43, s0_.CONSEIL_ACA_DUREE_VIE AS CONSEIL_ACA_DUREE_VIE_44, s0_.CONTRAT AS CONTRAT_45, s0_.CONTRAT_VISUALISATION AS CONTRAT_VISUALISATION_46, s0_.CONTRAT_DEPOT AS CONTRAT_DEPOT_47, s0_.CONTRAT_GENERATION AS CONTRAT_GENERATION_48, s0_.SERVICE_PREVU AS SERVICE_PREVU_49, s0_.SERVICE_PREVU_VISU AS SERVICE_PREVU_VISU_50, s0_.SERVICE_PREVU_EDITION AS SERVICE_PREVU_EDITION_51, s0_.SERVICE_REALISE AS SERVICE_REALISE_52, s0_.SERVICE_REALISE_VISU AS SERVICE_REALISE_VISU_53, s0_.SERVICE_REALISE_EDITION AS SERVICE_REALISE_EDITION_54, s0_.SERVICE_EXTERIEUR AS SERVICE_EXTERIEUR_55, s0_.REFERENTIEL_PREVU AS REFERENTIEL_PREVU_56, s0_.REFERENTIEL_PREVU_VISU AS REFERENTIEL_PREVU_VISU_57, s0_.REFERENTIEL_PREVU_EDITION AS REFERENTIEL_PREVU_EDITION_58, s0_.REFERENTIEL_REALISE AS REFERENTIEL_REALISE_59, s0_.REFERENTIEL_REALISE_VISU AS REFERENTIEL_REALISE_VISU_60, s0_.REFERENTIEL_REALISE_EDITION AS REFERENTIEL_REALISE_EDITION_61, s0_.MISSION AS MISSION_62, s0_.MISSION_VISUALISATION AS MISSION_VISUALISATION_63, s0_.MISSION_EDITION AS MISSION_EDITION_64, s0_.MISSION_REALISE_EDITION AS MISSION_REALISE_EDITION_65, s0_.MISSION_DECRET AS MISSION_DECRET_66, s0_.OFFRE_EMPLOI_POSTULER AS OFFRE_EMPLOI_POSTULER_67, s0_.CLOTURE AS CLOTURE_68, s0_.MODIF_SERVICE_DU AS MODIF_SERVICE_DU_69, s0_.MODIF_SERVICE_DU_VISUALISATION AS IF_SERVICE_DU_VISUALISATION_70, s0_.PAIEMENT AS PAIEMENT_71, s0_.PAIEMENT_VISUALISATION AS PAIEMENT_VISUALISATION_72, s0_.MOTIF_NON_PAIEMENT AS MOTIF_NON_PAIEMENT_73, s0_.FORMULE_VISUALISATION AS FORMULE_VISUALISATION_74, s0_.CODES_CORRESP_1 AS CODES_CORRESP_1_75, s0_.CODES_CORRESP_2 AS CODES_CORRESP_2_76, s0_.CODES_CORRESP_3 AS CODES_CORRESP_3_77, s0_.CODES_CORRESP_4 AS CODES_CORRESP_4_78, s0_.MODE_ENSEIGNEMENT_PREVISIONNEL AS E_ENSEIGNEMENT_PREVISIONNEL_79, s0_.MODE_ENSEIGNEMENT_REALISE AS MODE_ENSEIGNEMENT_REALISE_80, s0_.MODE_CALCUL AS MODE_CALCUL_81, s0_.CODE_INDEMNITE AS CODE_INDEMNITE_82, s0_.TYPE_PAIE AS TYPE_PAIE_83, s0_.MODE_CALCUL_PRIME AS MODE_CALCUL_PRIME_84, s0_.CODE_INDEMNITE_PRIME AS CODE_INDEMNITE_PRIME_85, s0_.TYPE_PAIE_PRIME AS TYPE_PAIE_PRIME_86, s0_.HISTO_CREATION AS HISTO_CREATION_87, s0_.HISTO_MODIFICATION AS HISTO_MODIFICATION_88, s0_.HISTO_DESTRUCTION AS HISTO_DESTRUCTION_89, s0_.ID AS ID_90, s0_.TYPE_INTERVENANT_ID AS TYPE_INTERVENANT_ID_91, s0_.ANNEE_ID AS ANNEE_ID_92, s0_.CONTRAT_ETAT_SORTIE_ID AS CONTRAT_ETAT_SORTIE_ID_93, s0_.AVENANT_ETAT_SORTIE_ID AS AVENANT_ETAT_SORTIE_ID_94, s0_.HISTO_CREATEUR_ID AS HISTO_CREATEUR_ID_95, s0_.HISTO_MODIFICATEUR_ID AS HISTO_MODIFICATEUR_ID_96, s0_.HISTO_DESTRUCTEUR_ID AS HISTO_DESTRUCTEUR_ID_97, s0_.TAUX_REMU_ID AS TAUX_REMU_ID_98 FROM STATUT s0_ WHERE s0_.ANNEE_ID = ? AND s0_.HISTO_DESTRUCTION IS NULL ORDER BY s0_.ORDRE ASC Params 0 => int(2023)
Types 0 => string(7) "integer"
Time 0.0028059482574463

Appel Application/Application.php(117): Application::start()
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.0025160312652588

Appel Application/Application.php(117): Application::start()
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.0015738010406494

Appel Application/Application.php(117): Application::start()
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.0010848045349121

Appel Application/Application.php(118): Laminas\Mvc\Application->run()
SQL SELECT TEXT FROM USER_VIEWS WHERE VIEW_NAME = 'V_TBL_PAIEMENT' Params Types Time 0.02846097946167

Appel Application/Application.php(118): Laminas\Mvc\Application->run()
SQL SELECT * FROM (SELECT 'e' || '-' || frs.id || '-' || COALESCE(thens.id,th.id) || '-' || prd.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, frs.service_id service_id, NULL service_referentiel_id, NULL mission_id, frs.id formule_res_service_id, NULL formule_res_service_ref_id, i.id intervenant_id, COALESCE( ep.structure_id, i.structure_id ) structure_id, COALESCE(thens.id,th.id) type_heures_id, COALESCE(e.domaine_fonctionnel_id, ose_parametre.get_domaine_fonc_ens_ext) def_domaine_fonctionnel_id, ccep.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 frs.heures_compl_fi WHEN 'fa' THEN frs.heures_compl_fa WHEN 'fc' THEN frs.heures_compl_fc WHEN 'fc_majorees' THEN frs.heures_compl_fc_majorees WHEN 'enseignement' THEN frs.heures_compl_fi + frs.heures_compl_fa + frs.heures_compl_fc + frs.heures_compl_fc_majorees END heures, 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 'fc_majorees' THEN frvh.heures_compl_fc_majorees WHEN 'enseignement' THEN frvh.heures_compl_fi + frvh.heures_compl_fa + frvh.heures_compl_fc + frvh.heures_compl_fc_majorees END lap_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_service frs JOIN parametre p ON p.nom = 'distinction_fi_fa_fc' JOIN formule_resultat_vh frvh ON frvh.formule_resultat_id = frs.formule_resultat_id JOIN volume_horaire vh ON vh.id = frvh.volume_horaire_id AND vh.service_id = frs.service_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', 'fc_majorees')) OR (p.valeur = '0' AND th.code = 'enseignement') JOIN formule_resultat fr ON fr.id = frs.formule_resultat_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 service s ON s.id = frs.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.id LEFT JOIN mise_en_paiement mep ON mep.histo_destruction IS NULL AND mep.formule_res_service_id = frs.id AND COALESCE(thens.id,mep.type_heures_id) = COALESCE(thens.id,th.id) WHERE 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 'fc_majorees' THEN frvh.heures_compl_fc_majorees WHEN 'enseignement' THEN frvh.heures_compl_fi + frvh.heures_compl_fa + frvh.heures_compl_fc + frvh.heures_compl_fc_majorees END <> 0 AND fr.intervenant_id = 882254 /*@ANNEE_ID=i.annee_id*/ AND frs.service_id = 258206 /*@FORMULE_RES_SERVICE_ID=frs.id*/ UNION ALL SELECT 'e' || '-' || frs.id || '-' || mep.type_heures_id || '-0' 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, frs.service_id service_id, NULL service_referentiel_id, NULL mission_id, frs.id formule_res_service_id, NULL formule_res_service_ref_id, i.id intervenant_id, COALESCE( ep.structure_id, i.structure_id ) structure_id, mep.type_heures_id type_heures_id, NULL def_domaine_fonctionnel_id, NULL 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, 0 lap_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 type_heures th ON th.id = mep.type_heures_id JOIN formule_resultat_service frs ON frs.id = mep.formule_res_service_id JOIN formule_resultat fr ON fr.id = frs.formule_resultat_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 service s ON s.id = frs.service_id JOIN parametre p ON p.nom = 'distinction_fi_fa_fc' LEFT JOIN element_pedagogique ep ON ep.id = s.element_pedagogique_id WHERE mep.histo_destruction IS NULL AND CASE WHEN th.code = 'fi' THEN frs.heures_compl_fi WHEN th.code = 'fa' THEN frs.heures_compl_fa WHEN th.code = 'fc' THEN frs.heures_compl_fc WHEN th.code = 'fc_majorees' THEN frs.heures_compl_fc_majorees WHEN p.valeur = '1' AND th.code = 'enseignement' THEN 0 WHEN p.valeur = '0' AND th.code = 'enseignement' THEN frs.heures_compl_fi + frs.heures_compl_fa + frs.heures_compl_fc + frs.heures_compl_fc_majorees END = 0 AND fr.intervenant_id = 882254 /*@ANNEE_ID=i.annee_id*/ AND frs.service_id = 258206 /*@FORMULE_RES_SERVICE_ID=frs.id*/ UNION ALL SELECT 'r' || '-' || frsr.id || '-' || th.id key, 1 calcul_semestriel, sr.id a_payer_id, i.annee_id annee_id, NULL service_id, frsr.service_referentiel_id service_referentiel_id, NULL mission_id, NULL formule_res_service_id, frsr.id formule_res_service_ref_id, i.id intervenant_id, sr.structure_id structure_id, th.id type_heures_id, fr.domaine_fonctionnel_id def_domaine_fonctionnel_id, NULL def_centre_cout_id, COALESCE(si.taux_remu_id, ose_parametre.get_taux_remu) taux_remu_id, 1 taux_conges_payes, NULL heures, frsr.heures_compl_referentiel lap_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_service_ref frsr 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 fr ON fr.id = frsr.formule_resultat_id AND fr.type_volume_horaire_id = tvh.id AND fr.etat_volume_horaire_id = evh.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 service_referentiel sr ON sr.id = frsr.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.formule_res_service_ref_id = frsr.id AND mep.type_heures_id = th.id WHERE frsr.heures_compl_referentiel <> 0 AND i.id = 882254 /*@ANNEE_ID=i.annee_id*/ /*@SERVICE_REFERENTIEL_ID=frsr.service_referentiel_id*/ /*@FORMULE_RES_SERVICE_REF_ID=frsr.id*/ UNION ALL SELECT '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, NULL formule_res_service_id, NULL formule_res_service_ref_id, tm.intervenant_id intervenant_id, m.structure_id structure_id, th.id type_heures_id, NULL def_domaine_fonctionnel_id, NULL 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, NULL heures, vhm.heures lap_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 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' 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 WHERE tm.valide = 1 /*@ANNEE_ID=tm.annee_id*/ AND tm.intervenant_id = 882254 /*@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 = 882254 AND SERVICE_ID = 258206 Params Types Time 0.46243500709534

Appel Application/Application.php(118): Laminas\Mvc\Application->run()
SQL SELECT * FROM (SELECT 'e' || '-' || frs.id || '-' || COALESCE(thens.id,th.id) || '-' || prd.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, frs.service_id service_id, NULL service_referentiel_id, NULL mission_id, frs.id formule_res_service_id, NULL formule_res_service_ref_id, i.id intervenant_id, COALESCE( ep.structure_id, i.structure_id ) structure_id, COALESCE(thens.id,th.id) type_heures_id, COALESCE(e.domaine_fonctionnel_id, ose_parametre.get_domaine_fonc_ens_ext) def_domaine_fonctionnel_id, ccep.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 frs.heures_compl_fi WHEN 'fa' THEN frs.heures_compl_fa WHEN 'fc' THEN frs.heures_compl_fc WHEN 'fc_majorees' THEN frs.heures_compl_fc_majorees WHEN 'enseignement' THEN frs.heures_compl_fi + frs.heures_compl_fa + frs.heures_compl_fc + frs.heures_compl_fc_majorees END heures, 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 'fc_majorees' THEN frvh.heures_compl_fc_majorees WHEN 'enseignement' THEN frvh.heures_compl_fi + frvh.heures_compl_fa + frvh.heures_compl_fc + frvh.heures_compl_fc_majorees END lap_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_service frs JOIN parametre p ON p.nom = 'distinction_fi_fa_fc' JOIN formule_resultat_vh frvh ON frvh.formule_resultat_id = frs.formule_resultat_id JOIN volume_horaire vh ON vh.id = frvh.volume_horaire_id AND vh.service_id = frs.service_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', 'fc_majorees')) OR (p.valeur = '0' AND th.code = 'enseignement') JOIN formule_resultat fr ON fr.id = frs.formule_resultat_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 service s ON s.id = frs.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.id LEFT JOIN mise_en_paiement mep ON mep.histo_destruction IS NULL AND mep.formule_res_service_id = frs.id AND COALESCE(thens.id,mep.type_heures_id) = COALESCE(thens.id,th.id) WHERE 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 'fc_majorees' THEN frvh.heures_compl_fc_majorees WHEN 'enseignement' THEN frvh.heures_compl_fi + frvh.heures_compl_fa + frvh.heures_compl_fc + frvh.heures_compl_fc_majorees END <> 0 AND fr.intervenant_id = 882254 /*@ANNEE_ID=i.annee_id*/ AND frs.service_id = 258206 /*@FORMULE_RES_SERVICE_ID=frs.id*/ UNION ALL SELECT 'e' || '-' || frs.id || '-' || mep.type_heures_id || '-0' 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, frs.service_id service_id, NULL service_referentiel_id, NULL mission_id, frs.id formule_res_service_id, NULL formule_res_service_ref_id, i.id intervenant_id, COALESCE( ep.structure_id, i.structure_id ) structure_id, mep.type_heures_id type_heures_id, NULL def_domaine_fonctionnel_id, NULL 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, 0 lap_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 type_heures th ON th.id = mep.type_heures_id JOIN formule_resultat_service frs ON frs.id = mep.formule_res_service_id JOIN formule_resultat fr ON fr.id = frs.formule_resultat_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 service s ON s.id = frs.service_id JOIN parametre p ON p.nom = 'distinction_fi_fa_fc' LEFT JOIN element_pedagogique ep ON ep.id = s.element_pedagogique_id WHERE mep.histo_destruction IS NULL AND CASE WHEN th.code = 'fi' THEN frs.heures_compl_fi WHEN th.code = 'fa' THEN frs.heures_compl_fa WHEN th.code = 'fc' THEN frs.heures_compl_fc WHEN th.code = 'fc_majorees' THEN frs.heures_compl_fc_majorees WHEN p.valeur = '1' AND th.code = 'enseignement' THEN 0 WHEN p.valeur = '0' AND th.code = 'enseignement' THEN frs.heures_compl_fi + frs.heures_compl_fa + frs.heures_compl_fc + frs.heures_compl_fc_majorees END = 0 AND fr.intervenant_id = 882254 /*@ANNEE_ID=i.annee_id*/ AND frs.service_id = 258206 /*@FORMULE_RES_SERVICE_ID=frs.id*/ UNION ALL SELECT 'r' || '-' || frsr.id || '-' || th.id key, 1 calcul_semestriel, sr.id a_payer_id, i.annee_id annee_id, NULL service_id, frsr.service_referentiel_id service_referentiel_id, NULL mission_id, NULL formule_res_service_id, frsr.id formule_res_service_ref_id, i.id intervenant_id, sr.structure_id structure_id, th.id type_heures_id, fr.domaine_fonctionnel_id def_domaine_fonctionnel_id, NULL def_centre_cout_id, COALESCE(si.taux_remu_id, ose_parametre.get_taux_remu) taux_remu_id, 1 taux_conges_payes, NULL heures, frsr.heures_compl_referentiel lap_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_service_ref frsr 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 fr ON fr.id = frsr.formule_resultat_id AND fr.type_volume_horaire_id = tvh.id AND fr.etat_volume_horaire_id = evh.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 service_referentiel sr ON sr.id = frsr.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.formule_res_service_ref_id = frsr.id AND mep.type_heures_id = th.id WHERE frsr.heures_compl_referentiel <> 0 AND i.id = 882254 /*@ANNEE_ID=i.annee_id*/ /*@SERVICE_REFERENTIEL_ID=frsr.service_referentiel_id*/ /*@FORMULE_RES_SERVICE_REF_ID=frsr.id*/ UNION ALL SELECT '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, NULL formule_res_service_id, NULL formule_res_service_ref_id, tm.intervenant_id intervenant_id, m.structure_id structure_id, th.id type_heures_id, NULL def_domaine_fonctionnel_id, NULL 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, NULL heures, vhm.heures lap_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 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' 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 WHERE tm.valide = 1 /*@ANNEE_ID=tm.annee_id*/ AND tm.intervenant_id = 882254 /*@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 = 882254 AND SERVICE_ID = 258206 Params Types Time 0.001990795135498

Appel Application/Application.php(118): Laminas\Mvc\Application->run()
SQL SELECT id FROM offre_emploi WHERE histo_destruction IS NULL AND validation_id IS NOT NULL Params Types Time 0.002662181854248

Appel Application/Application.php(118): Laminas\Mvc\Application->run()
SQL SELECT id, libelle FROM annee WHERE active = 1 ORDER BY id Params Types Time 0.0016341209411621

Data en entrée

Résultat