Symfony Profiler

[
  "route" => "app_paie_stc_insert"
  "route_parameters" => [
    "_route" => "app_paie_stc_insert"
    "_controller" => "App\Controller\Paie\StcController::app_paie_stc_insert"
  ]
  "request_uri" => "http://drh-fcz.ma/paie/stc/app_paie_stc_insert"
  "method" => "POST"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "sirh-db.chlyq6uxnmog.eu-west-1.rds.amazonaws.com"
    "port" => 3306
    "user" => "Dev"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "sirh"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.enable AS enable_7, t0.created AS created_8, t0.email AS email_9, t0.updated AS updated_10, t0.user_updated_id AS user_updated_id_11, t0.dossier_responsable_id AS dossier_responsable_id_12 FROM users t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "g.safouane"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\SecurityAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\SecurityAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.designation AS designation_2, t0.active AS active_3 FROM pdevise t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.designation AS designation_2, t0.abreviation AS abreviation_3, t0.active AS active_4 FROM ppaiement t0 WHERE t0.id = ?"
  "params" => [
    1 => "1"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.abreviation AS abreviation_3, t0.date AS date_4, t0.is_valider AS is_valider_5, t0.is_integrer AS is_integrer_6 FROM periode t0 WHERE t0.code = ? LIMIT 1"
  "params" => [
    1 => "032025"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.facture AS facture_4, t0.paiement AS paiement_5, t0.fournisseur AS fournisseur_6, t0.id_article AS id_article_7, t0.honoraire AS honoraire_8, t0.indeminite AS indeminite_9, t0.prets AS prets_10, t0.sens AS sens_11, t0.absence AS absence_12, t0.fixe AS fixe_13, t0.journal AS journal_14, t0.flag_input AS flag_input_15, t0.site_id AS site_id_16, t0.partenaire_id AS partenaire_id_17, t0.regul_article_ugouv_id AS regul_article_ugouv_id_18, t0.imposable AS imposable_19, t0.active AS active_20, t0.echeance AS echeance_21, t0.famille AS famille_22, t0.type AS type_23, t0.ord AS ord_24, t0.rubthm0 AS rubthm0_25, t0.old_designation AS old_designation_26 FROM prubrique t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.designation AS designation_2, t0.abreviation AS abreviation_3, t0.code AS code_4, t0.groupement AS groupement_5, t0.dossier_ugouv_id AS dossier_ugouv_id_6, t0.abreviation2 AS abreviation2_7, t0.abreviation_ugouv AS abreviation_ugouv_8, t0.fcy0 AS fcy0_9, t0.cpy0 AS cpy0_10, t0.partenaire_id AS partenaire_id_11, t0.affiliation AS affiliation_12, t0.statut_cimr AS statut_cimr_13, t0.image AS image_14, t0.adresse AS adresse_15, t0.ice AS ice_16, t0.num_if AS num_if_17, t0.fax AS fax_18, t0.telephone AS telephone_19, t0.active AS active_20, t0.das AS das_21, t0.fcy_id AS fcy_id_22 FROM pdossier t0 WHERE t0.id = ?"
  "params" => [
    1 => "63"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.designation AS designation_2, t0.abreviation AS abreviation_3 FROM ppiece t0 WHERE t0.id = ?"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.active AS active_4, t0.abreviation AS abreviation_5, t0.partenaire_id AS partenaire_id_6, t0.taux_ir AS taux_ir_7, t0.abattement AS abattement_8, t0.type_id AS type_id_9 FROM pnature_contract t0 WHERE t0.id = ?"
  "params" => [
    1 => "1"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.designation AS designation_2, t0.icon AS icon_3, t0.type AS type_4 FROM pstatut t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.active AS active_5, t0.date_sortie AS date_sortie_6, t0.motif_sortie AS motif_sortie_7, t0.date_anciennete AS date_anciennete_8, t0.prise_en_charge AS prise_en_charge_9, t0.salairegrille AS salairegrille_10, t0.salaireaffecte AS salaireaffecte_11, t0.ppc AS ppc_12, t0.rpc AS rpc_13, t0.matricule_ancien AS matricule_ancien_14, t0.date_desactiver AS date_desactiver_15, t0.cnss AS cnss_16, t0.date_cnss AS date_cnss_17, t0.cimr AS cimr_18, t0.date_cimr AS date_cimr_19, t0.created AS created_20, t0.updated AS updated_21, t0.carte_auto_entrepreneur AS carte_auto_entrepreneur_22, t0.date_debut_carte_entrepreneur AS date_debut_carte_entrepreneur_23, t0.date_fin_carte_entrepreneur AS date_fin_carte_entrepreneur_24, t0.stagiaire AS stagiaire_25, t0.employe_id AS employe_id_26, t0.pnature_contract_id AS pnature_contract_id_27, t0.dossier_id AS dossier_id_28, t0.bareme_id AS bareme_id_29, t0.fonction_id AS fonction_id_30, t0.piece_id AS piece_id_31, t0.user_desactiver_id AS user_desactiver_id_32, t0.duree_contract_id AS duree_contract_id_33, t0.user_updated_id AS user_updated_id_34, t0.user_created_id AS user_created_id_35 FROM lcontract t0 WHERE t0.id = ?"
  "params" => [
    1 => 2122
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.designation AS designation_2, t0.abreviation AS abreviation_3 FROM ppiece t0 WHERE t0.id = ?"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.facture AS facture_4, t0.paiement AS paiement_5, t0.fournisseur AS fournisseur_6, t0.id_article AS id_article_7, t0.honoraire AS honoraire_8, t0.indeminite AS indeminite_9, t0.prets AS prets_10, t0.sens AS sens_11, t0.absence AS absence_12, t0.fixe AS fixe_13, t0.journal AS journal_14, t0.flag_input AS flag_input_15, t0.site_id AS site_id_16, t0.partenaire_id AS partenaire_id_17, t0.regul_article_ugouv_id AS regul_article_ugouv_id_18, t0.imposable AS imposable_19, t0.active AS active_20, t0.echeance AS echeance_21, t0.famille AS famille_22, t0.type AS type_23, t0.ord AS ord_24, t0.rubthm0 AS rubthm0_25, t0.old_designation AS old_designation_26 FROM prubrique t0 WHERE t0.id = ?"
  "params" => [
    1 => 64
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.matricule AS matricule_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.date_naissance AS date_naissance_6, t0.lieu_naissance AS lieu_naissance_7, t0.sexe AS sexe_8, t0.nombre_enfants AS nombre_enfants_9, t0.nbr_pris_en_charge AS nbr_pris_en_charge_10, t0.cin AS cin_11, t0.adresse1 AS adresse1_12, t0.adresse2 AS adresse2_13, t0.code_postal AS code_postal_14, t0.ville AS ville_15, t0.pays AS pays_16, t0.nationalite AS nationalite_17, t0.tel1 AS tel1_18, t0.tel2 AS tel2_19, t0.email AS email_20, t0.active AS active_21, t0.created AS created_22, t0.contacturgent AS contacturgent_23, t0.prenomurgence AS prenomurgence_24, t0.nomurgence AS nomurgence_25, t0.degredeparente AS degredeparente_26, t0.adresseurgence AS adresseurgence_27, t0.teleurgence AS teleurgence_28, t0.villeurgence AS villeurgence_29, t0.prenomconjoint AS prenomconjoint_30, t0.nomconjoint AS nomconjoint_31, t0.datenaiconjoint AS datenaiconjoint_32, t0.nomprenompere AS nomprenompere_33, t0.nomprenommere AS nomprenommere_34, t0.stc AS stc_35, t0.updated AS updated_36, t0.roles AS roles_37, t0.password AS password_38, t0.nombre_jour_conge AS nombre_jour_conge_39, t0.is_first_login AS is_first_login_40, t0.situation_familiale_id_id AS situation_familiale_id_id_41, t0.user_updated_id AS user_updated_id_42, t43.id AS id_44, t43.cin AS cin_45, t43.cin_path AS cin_path_46, t43.acte_naissance AS acte_naissance_47, t43.acte_naissance_path AS acte_naissance_path_48, t43.formulaire AS formulaire_49, t43.formulaire_path AS formulaire_path_50, t43.contrat AS contrat_51, t43.contrat_path AS contrat_path_52, t43.dossier_medical AS dossier_medical_53, t43.dossier_medical_path AS dossier_medical_path_54, t43.bac AS bac_55, t43.bac_path AS bac_path_56, t43.diplome AS diplome_57, t43.diplome_path AS diplome_path_58, t43.cv AS cv_59, t43.cv_path AS cv_path_60, t43.rib AS rib_61, t43.rib_path AS rib_path_62, t43.fiche_anthropometrique AS fiche_anthropometrique_63, t43.fiche_anthropometrique_path AS fiche_anthropometrique_path_64, t43.photo AS photo_65, t43.photo_path AS photo_path_66, t43.emprunte AS emprunte_67, t43.emprunte_path AS emprunte_path_68, t43.acte_mariage AS acte_mariage_69, t43.acte_mariage_path AS acte_mariage_path_70, t43.cin_conjoint AS cin_conjoint_71, t43.cin_conjoint_path AS cin_conjoint_path_72, t43.acte_naissance_enfants AS acte_naissance_enfants_73, t43.acte_naissance_enfants_path AS acte_naissance_enfants_path_74, t43.cin_enfants AS cin_enfants_75, t43.cin_enfants_path AS cin_enfants_path_76, t43.cin_parents AS cin_parents_77, t43.cin_parents_path AS cin_parents_path_78, t43.employe_id AS employe_id_79 FROM pemploye t0 LEFT JOIN pemploye_document t43 ON t43.employe_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 1137
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "INSERT INTO pbordereau (created, type, code, nature, observation, active, date_integration, unique_id, motif_annulation, periode_id, user_created_id, dossier_id, paiement_id, piece_id, nature_contract_id, statut_id, devise_id, user_integration_id, user_annulation_id, rubrique_indiminite_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "2025-03-19 09:17:28"
    2 => "stc"
    3 => null
    4 => null
    5 => "SOLD DE TOUT COMPTE"
    6 => 1
    7 => null
    8 => null
    9 => null
    10 => 46
    11 => 3
    12 => 63
    13 => 1
    14 => 14
    15 => 1
    16 => 1
    17 => 1
    18 => null
    19 => null
    20 => null
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 5
    7 => 2
    8 => 2
    9 => 2
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
  ]
]

[
  "sql" => "INSERT INTO tbulletin (annee, code, observation, active, motif_annulation, taux_cotis_cimr, categorie_cimr, periode_id, contract_id, dossier_id, devise_id, paiement_id, bordereau_id, piece_id, user_annulation_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => null
    2 => null
    3 => "SOLD DE TOUT COMPTE"
    4 => 1
    5 => null
    6 => null
    7 => null
    8 => 46
    9 => 2122
    10 => 63
    11 => 1
    12 => 1
    13 => 7317
    14 => 13
    15 => null
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
    4 => 5
    5 => 2
    6 => 1
    7 => 2
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
  ]
]

[
  "sql" => "INSERT INTO tbulletin_lg (montant, sens, active, montant_devise, bulletin_id, rubrique_id) VALUES (?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 876.24
    2 => 1.0
    3 => 1
    4 => null
    5 => 108093
    6 => 5
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 5
    4 => 2
    5 => 1
    6 => 1
  ]
]

[
  "sql" => "INSERT INTO tbulletin_lg (montant, sens, active, montant_devise, bulletin_id, rubrique_id) VALUES (?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 876.24
    2 => 1.0
    3 => 1
    4 => null
    5 => 108093
    6 => 64
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 5
    4 => 2
    5 => 1
    6 => 1
  ]
]

[
  "sql" => "UPDATE pemploye SET stc = ? WHERE id = ?"
  "params" => [
    1 => 1
    2 => 1137
  ]
  "types" => [
    1 => 5
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.designation AS designation_2, t0.abreviation AS abreviation_3, t0.code AS code_4, t0.groupement AS groupement_5, t0.dossier_ugouv_id AS dossier_ugouv_id_6, t0.abreviation2 AS abreviation2_7, t0.abreviation_ugouv AS abreviation_ugouv_8, t0.fcy0 AS fcy0_9, t0.cpy0 AS cpy0_10, t0.partenaire_id AS partenaire_id_11, t0.affiliation AS affiliation_12, t0.statut_cimr AS statut_cimr_13, t0.image AS image_14, t0.adresse AS adresse_15, t0.ice AS ice_16, t0.num_if AS num_if_17, t0.fax AS fax_18, t0.telephone AS telephone_19, t0.active AS active_20, t0.das AS das_21, t0.fcy_id AS fcy_id_22 FROM pdossier t0 WHERE t0.id = ?"
  "params" => [
    1 => "84"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.active AS active_5, t0.date_sortie AS date_sortie_6, t0.motif_sortie AS motif_sortie_7, t0.date_anciennete AS date_anciennete_8, t0.prise_en_charge AS prise_en_charge_9, t0.salairegrille AS salairegrille_10, t0.salaireaffecte AS salaireaffecte_11, t0.ppc AS ppc_12, t0.rpc AS rpc_13, t0.matricule_ancien AS matricule_ancien_14, t0.date_desactiver AS date_desactiver_15, t0.cnss AS cnss_16, t0.date_cnss AS date_cnss_17, t0.cimr AS cimr_18, t0.date_cimr AS date_cimr_19, t0.created AS created_20, t0.updated AS updated_21, t0.carte_auto_entrepreneur AS carte_auto_entrepreneur_22, t0.date_debut_carte_entrepreneur AS date_debut_carte_entrepreneur_23, t0.date_fin_carte_entrepreneur AS date_fin_carte_entrepreneur_24, t0.stagiaire AS stagiaire_25, t0.employe_id AS employe_id_26, t0.pnature_contract_id AS pnature_contract_id_27, t0.dossier_id AS dossier_id_28, t0.bareme_id AS bareme_id_29, t0.fonction_id AS fonction_id_30, t0.piece_id AS piece_id_31, t0.user_desactiver_id AS user_desactiver_id_32, t0.duree_contract_id AS duree_contract_id_33, t0.user_updated_id AS user_updated_id_34, t0.user_created_id AS user_created_id_35 FROM lcontract t0 WHERE t0.id = ?"
  "params" => [
    1 => 492
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.matricule AS matricule_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.date_naissance AS date_naissance_6, t0.lieu_naissance AS lieu_naissance_7, t0.sexe AS sexe_8, t0.nombre_enfants AS nombre_enfants_9, t0.nbr_pris_en_charge AS nbr_pris_en_charge_10, t0.cin AS cin_11, t0.adresse1 AS adresse1_12, t0.adresse2 AS adresse2_13, t0.code_postal AS code_postal_14, t0.ville AS ville_15, t0.pays AS pays_16, t0.nationalite AS nationalite_17, t0.tel1 AS tel1_18, t0.tel2 AS tel2_19, t0.email AS email_20, t0.active AS active_21, t0.created AS created_22, t0.contacturgent AS contacturgent_23, t0.prenomurgence AS prenomurgence_24, t0.nomurgence AS nomurgence_25, t0.degredeparente AS degredeparente_26, t0.adresseurgence AS adresseurgence_27, t0.teleurgence AS teleurgence_28, t0.villeurgence AS villeurgence_29, t0.prenomconjoint AS prenomconjoint_30, t0.nomconjoint AS nomconjoint_31, t0.datenaiconjoint AS datenaiconjoint_32, t0.nomprenompere AS nomprenompere_33, t0.nomprenommere AS nomprenommere_34, t0.stc AS stc_35, t0.updated AS updated_36, t0.roles AS roles_37, t0.password AS password_38, t0.nombre_jour_conge AS nombre_jour_conge_39, t0.is_first_login AS is_first_login_40, t0.situation_familiale_id_id AS situation_familiale_id_id_41, t0.user_updated_id AS user_updated_id_42, t43.id AS id_44, t43.cin AS cin_45, t43.cin_path AS cin_path_46, t43.acte_naissance AS acte_naissance_47, t43.acte_naissance_path AS acte_naissance_path_48, t43.formulaire AS formulaire_49, t43.formulaire_path AS formulaire_path_50, t43.contrat AS contrat_51, t43.contrat_path AS contrat_path_52, t43.dossier_medical AS dossier_medical_53, t43.dossier_medical_path AS dossier_medical_path_54, t43.bac AS bac_55, t43.bac_path AS bac_path_56, t43.diplome AS diplome_57, t43.diplome_path AS diplome_path_58, t43.cv AS cv_59, t43.cv_path AS cv_path_60, t43.rib AS rib_61, t43.rib_path AS rib_path_62, t43.fiche_anthropometrique AS fiche_anthropometrique_63, t43.fiche_anthropometrique_path AS fiche_anthropometrique_path_64, t43.photo AS photo_65, t43.photo_path AS photo_path_66, t43.emprunte AS emprunte_67, t43.emprunte_path AS emprunte_path_68, t43.acte_mariage AS acte_mariage_69, t43.acte_mariage_path AS acte_mariage_path_70, t43.cin_conjoint AS cin_conjoint_71, t43.cin_conjoint_path AS cin_conjoint_path_72, t43.acte_naissance_enfants AS acte_naissance_enfants_73, t43.acte_naissance_enfants_path AS acte_naissance_enfants_path_74, t43.cin_enfants AS cin_enfants_75, t43.cin_enfants_path AS cin_enfants_path_76, t43.cin_parents AS cin_parents_77, t43.cin_parents_path AS cin_parents_path_78, t43.employe_id AS employe_id_79 FROM pemploye t0 LEFT JOIN pemploye_document t43 ON t43.employe_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 386
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "INSERT INTO pbordereau (created, type, code, nature, observation, active, date_integration, unique_id, motif_annulation, periode_id, user_created_id, dossier_id, paiement_id, piece_id, nature_contract_id, statut_id, devise_id, user_integration_id, user_annulation_id, rubrique_indiminite_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "2025-03-19 09:17:28"
    2 => "stc"
    3 => null
    4 => null
    5 => "SOLD DE TOUT COMPTE"
    6 => 1
    7 => null
    8 => null
    9 => null
    10 => 46
    11 => 3
    12 => 84
    13 => 1
    14 => 14
    15 => 1
    16 => 1
    17 => 1
    18 => null
    19 => null
    20 => null
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 5
    7 => 2
    8 => 2
    9 => 2
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
  ]
]

[
  "sql" => "INSERT INTO tbulletin (annee, code, observation, active, motif_annulation, taux_cotis_cimr, categorie_cimr, periode_id, contract_id, dossier_id, devise_id, paiement_id, bordereau_id, piece_id, user_annulation_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => null
    2 => null
    3 => "SOLD DE TOUT COMPTE"
    4 => 1
    5 => null
    6 => null
    7 => null
    8 => 46
    9 => 492
    10 => 84
    11 => 1
    12 => 1
    13 => 7318
    14 => 13
    15 => null
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
    4 => 5
    5 => 2
    6 => 1
    7 => 2
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
  ]
]

[
  "sql" => "INSERT INTO tbulletin_lg (montant, sens, active, montant_devise, bulletin_id, rubrique_id) VALUES (?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 101.56
    2 => 1.0
    3 => 1
    4 => null
    5 => 108094
    6 => 5
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 5
    4 => 2
    5 => 1
    6 => 1
  ]
]

[
  "sql" => "INSERT INTO tbulletin_lg (montant, sens, active, montant_devise, bulletin_id, rubrique_id) VALUES (?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 101.56
    2 => 1.0
    3 => 1
    4 => null
    5 => 108094
    6 => 64
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 5
    4 => 2
    5 => 1
    6 => 1
  ]
]

[
  "sql" => "UPDATE pemploye SET stc = ? WHERE id = ?"
  "params" => [
    1 => 1
    2 => 386
  ]
  "types" => [
    1 => 5
    2 => 1
  ]
]

[
  "key" => "_security_main"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created AS created_2, t0.type AS type_3, t0.code AS code_4, t0.nature AS nature_5, t0.observation AS observation_6, t0.active AS active_7, t0.date_integration AS date_integration_8, t0.unique_id AS unique_id_9, t0.motif_annulation AS motif_annulation_10, t0.periode_id AS periode_id_11, t0.user_created_id AS user_created_id_12, t0.dossier_id AS dossier_id_13, t0.paiement_id AS paiement_id_14, t0.piece_id AS piece_id_15, t0.nature_contract_id AS nature_contract_id_16, t0.statut_id AS statut_id_17, t0.devise_id AS devise_id_18, t0.user_integration_id AS user_integration_id_19, t0.user_annulation_id AS user_annulation_id_20, t0.rubrique_indiminite_id AS rubrique_indiminite_id_21 FROM pbordereau t0 WHERE t0.id = ?"
  "params" => [
    1 => 7317
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.annee AS annee_2, t0.code AS code_3, t0.observation AS observation_4, t0.active AS active_5, t0.motif_annulation AS motif_annulation_6, t0.taux_cotis_cimr AS taux_cotis_cimr_7, t0.categorie_cimr AS categorie_cimr_8, t0.periode_id AS periode_id_9, t0.contract_id AS contract_id_10, t0.dossier_id AS dossier_id_11, t0.devise_id AS devise_id_12, t0.paiement_id AS paiement_id_13, t0.bordereau_id AS bordereau_id_14, t0.piece_id AS piece_id_15, t0.user_annulation_id AS user_annulation_id_16 FROM tbulletin t0 WHERE t0.bordereau_id = ?"
  "params" => [
    1 => 7317
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.facture AS facture_4, t0.paiement AS paiement_5, t0.fournisseur AS fournisseur_6, t0.id_article AS id_article_7, t0.honoraire AS honoraire_8, t0.indeminite AS indeminite_9, t0.prets AS prets_10, t0.sens AS sens_11, t0.absence AS absence_12, t0.fixe AS fixe_13, t0.journal AS journal_14, t0.flag_input AS flag_input_15, t0.site_id AS site_id_16, t0.partenaire_id AS partenaire_id_17, t0.regul_article_ugouv_id AS regul_article_ugouv_id_18, t0.imposable AS imposable_19, t0.active AS active_20, t0.echeance AS echeance_21, t0.famille AS famille_22, t0.type AS type_23, t0.ord AS ord_24, t0.rubthm0 AS rubthm0_25, t0.old_designation AS old_designation_26 FROM prubrique t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 4
    2 => 6
    3 => 7
    4 => 8
    5 => 9
    6 => 10
    7 => 93
    8 => 11
    9 => 16
    10 => 24
    11 => 25
    12 => 60
    13 => 76
    14 => 94
    15 => 98
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.montant AS montant_2, t0.sens AS sens_3, t0.active AS active_4, t0.montant_devise AS montant_devise_5, t0.bulletin_id AS bulletin_id_6, t0.rubrique_id AS rubrique_id_7 FROM tbulletin_lg t0 WHERE t0.bulletin_id = ? AND t0.active = ? AND t0.rubrique_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 108093
    2 => 1
    3 => 4
    4 => 6
    5 => 7
    6 => 8
    7 => 9
    8 => 10
    9 => 11
    10 => 16
    11 => 24
    12 => 25
    13 => 60
    14 => 76
    15 => 93
    16 => 94
    17 => 98
  ]
  "types" => [
    1 => 1
    2 => 5
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.facture AS facture_4, t0.paiement AS paiement_5, t0.fournisseur AS fournisseur_6, t0.id_article AS id_article_7, t0.honoraire AS honoraire_8, t0.indeminite AS indeminite_9, t0.prets AS prets_10, t0.sens AS sens_11, t0.absence AS absence_12, t0.fixe AS fixe_13, t0.journal AS journal_14, t0.flag_input AS flag_input_15, t0.site_id AS site_id_16, t0.partenaire_id AS partenaire_id_17, t0.regul_article_ugouv_id AS regul_article_ugouv_id_18, t0.imposable AS imposable_19, t0.active AS active_20, t0.echeance AS echeance_21, t0.famille AS famille_22, t0.type AS type_23, t0.ord AS ord_24, t0.rubthm0 AS rubthm0_25, t0.old_designation AS old_designation_26 FROM prubrique t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 5
    2 => 68
    3 => 30
    4 => 31
    5 => 33
    6 => 34
    7 => 35
    8 => 36
    9 => 37
    10 => 38
    11 => 39
    12 => 85
    13 => 80
    14 => 79
    15 => 78
    16 => 77
    17 => 82
    18 => 83
    19 => 45
    20 => 84
    21 => 97
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
    21 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.facture AS facture_4, t0.paiement AS paiement_5, t0.fournisseur AS fournisseur_6, t0.id_article AS id_article_7, t0.honoraire AS honoraire_8, t0.indeminite AS indeminite_9, t0.prets AS prets_10, t0.sens AS sens_11, t0.absence AS absence_12, t0.fixe AS fixe_13, t0.journal AS journal_14, t0.flag_input AS flag_input_15, t0.site_id AS site_id_16, t0.partenaire_id AS partenaire_id_17, t0.regul_article_ugouv_id AS regul_article_ugouv_id_18, t0.imposable AS imposable_19, t0.active AS active_20, t0.echeance AS echeance_21, t0.famille AS famille_22, t0.type AS type_23, t0.ord AS ord_24, t0.rubthm0 AS rubthm0_25, t0.old_designation AS old_designation_26 FROM prubrique t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 29
    2 => 32
    3 => 40
    4 => 41
    5 => 44
    6 => 46
    7 => 59
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, sum(t1_.montant) AS sclr_1, sum(t1_.montant_devise) AS sclr_2, t1_.id AS id_3 FROM tbulletin_lg t1_ INNER JOIN prubrique p0_ ON t1_.rubrique_id = p0_.id WHERE t1_.bulletin_id = ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND t1_.active = 1 GROUP BY p0_.id"
  "params" => [
    1 => 108093
    2 => 5
    3 => 30
    4 => 31
    5 => 33
    6 => 34
    7 => 35
    8 => 36
    9 => 37
    10 => 38
    11 => 39
    12 => 45
    13 => 68
    14 => 77
    15 => 78
    16 => 79
    17 => 80
    18 => 82
    19 => 83
    20 => 84
    21 => 85
    22 => 97
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
    21 => 1
    22 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, sum(t1_.montant) AS sclr_1, sum(t1_.montant_devise) AS sclr_2, t1_.id AS id_3 FROM tbulletin_lg t1_ INNER JOIN prubrique p0_ ON t1_.rubrique_id = p0_.id WHERE t1_.bulletin_id = ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?) AND t1_.active = 1 GROUP BY p0_.id"
  "params" => [
    1 => 108093
    2 => 29
    3 => 32
    4 => 40
    5 => 41
    6 => 44
    7 => 46
    8 => 59
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
  ]
]

[
  "sql" => "UPDATE journal_bulletin_lg SET active = ? WHERE bulletin_id = ? AND active = 1"
  "params" => [
    1 => "0"
    2 => 108093
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.facture AS facture_4, t0.paiement AS paiement_5, t0.fournisseur AS fournisseur_6, t0.id_article AS id_article_7, t0.honoraire AS honoraire_8, t0.indeminite AS indeminite_9, t0.prets AS prets_10, t0.sens AS sens_11, t0.absence AS absence_12, t0.fixe AS fixe_13, t0.journal AS journal_14, t0.flag_input AS flag_input_15, t0.site_id AS site_id_16, t0.partenaire_id AS partenaire_id_17, t0.regul_article_ugouv_id AS regul_article_ugouv_id_18, t0.imposable AS imposable_19, t0.active AS active_20, t0.echeance AS echeance_21, t0.famille AS famille_22, t0.type AS type_23, t0.ord AS ord_24, t0.rubthm0 AS rubthm0_25, t0.old_designation AS old_designation_26 FROM prubrique t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 3
    2 => 12
    3 => 13
    4 => 14
    5 => 15
    6 => 17
    7 => 18
    8 => 22
    9 => 26
    10 => 27
    11 => 61
    12 => 63
    13 => 64
    14 => 65
    15 => 66
    16 => 67
    17 => 69
    18 => 70
    19 => 88
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.montant AS montant_2, t0.sens AS sens_3, t0.active AS active_4, t0.montant_devise AS montant_devise_5, t0.bulletin_id AS bulletin_id_6, t0.rubrique_id AS rubrique_id_7 FROM tbulletin_lg t0 WHERE t0.bulletin_id = ? AND t0.rubrique_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND t0.active = ? LIMIT 1"
  "params" => [
    1 => 108093
    2 => 3
    3 => 12
    4 => 13
    5 => 14
    6 => 15
    7 => 17
    8 => 18
    9 => 22
    10 => 26
    11 => 27
    12 => 61
    13 => 63
    14 => 64
    15 => 65
    16 => 66
    17 => 67
    18 => 69
    19 => 70
    20 => 88
    21 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
    21 => 5
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.montant AS montant_1, t0_.sens AS sens_2, t0_.active AS active_3, t0_.montant_devise AS montant_devise_4, t0_.bulletin_id AS bulletin_id_5, t0_.rubrique_id AS rubrique_id_6 FROM tbulletin_lg t0_ INNER JOIN prubrique p1_ ON t0_.rubrique_id = p1_.id WHERE p1_.id IN (?, ?, ?) AND t0_.bulletin_id = ? AND t0_.active = 1"
  "params" => [
    1 => 50
    2 => 47
    3 => 53
    4 => 108093
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, sum(t1_.montant) AS sclr_1 FROM tbulletin_lg t1_ INNER JOIN prubrique p2_ ON t1_.rubrique_id = p2_.id INNER JOIN tbulletin t0_ ON t1_.bulletin_id = t0_.id WHERE p2_.id IN (?, ?, ?) AND t1_.bulletin_id = ? AND t1_.active = 1 GROUP BY t0_.id"
  "params" => [
    1 => 50
    2 => 47
    3 => 53
    4 => 108093
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.montant AS montant_1, t0_.sens AS sens_2, t0_.active AS active_3, t0_.montant_devise AS montant_devise_4, t0_.bulletin_id AS bulletin_id_5, t0_.rubrique_id AS rubrique_id_6 FROM tbulletin_lg t0_ INNER JOIN prubrique p1_ ON t0_.rubrique_id = p1_.id WHERE p1_.id IN (?) AND t0_.bulletin_id = ? AND t0_.active = 1"
  "params" => [
    1 => 48
    2 => 108093
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, sum(t1_.montant) AS sclr_1 FROM tbulletin_lg t1_ INNER JOIN prubrique p2_ ON t1_.rubrique_id = p2_.id INNER JOIN tbulletin t0_ ON t1_.bulletin_id = t0_.id WHERE p2_.id IN (?) AND t1_.bulletin_id = ? AND t1_.active = 1 GROUP BY t0_.id"
  "params" => [
    1 => 48
    2 => 108093
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.montant AS montant_1, t0_.sens AS sens_2, t0_.active AS active_3, t0_.montant_devise AS montant_devise_4, t0_.bulletin_id AS bulletin_id_5, t0_.rubrique_id AS rubrique_id_6 FROM tbulletin_lg t0_ INNER JOIN prubrique p1_ ON t0_.rubrique_id = p1_.id WHERE p1_.id IN (?) AND t0_.bulletin_id = ? AND t0_.active = 1"
  "params" => [
    1 => 43
    2 => 108093
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, sum(t1_.montant) AS sclr_1 FROM tbulletin_lg t1_ INNER JOIN prubrique p2_ ON t1_.rubrique_id = p2_.id INNER JOIN tbulletin t0_ ON t1_.bulletin_id = t0_.id WHERE p2_.id IN (?) AND t1_.bulletin_id = ? AND t1_.active = 1 GROUP BY t0_.id"
  "params" => [
    1 => 43
    2 => 108093
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.article_ugouv_id AS article_ugouv_id_2, t0.article_ugouv_rh AS article_ugouv_rh_3, t0.compte_comptable AS compte_comptable_4, t0.sens AS sens_5, t0.qte AS qte_6, t0.rubrique_id AS rubrique_id_7, t0.nature_contract_id AS nature_contract_id_8 FROM pcompte_comptable t0 WHERE t0.rubrique_id = ? AND t0.nature_contract_id = ? LIMIT 1"
  "params" => [
    1 => 5
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.article_ugouv_id AS article_ugouv_id_2, t0.article_ugouv_rh AS article_ugouv_rh_3, t0.compte_comptable AS compte_comptable_4, t0.sens AS sens_5, t0.qte AS qte_6, t0.rubrique_id AS rubrique_id_7, t0.nature_contract_id AS nature_contract_id_8 FROM pcompte_comptable t0 WHERE t0.rubrique_id = ? AND t0.nature_contract_id = ? LIMIT 1"
  "params" => [
    1 => 64
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.designation AS designation_2, t0.icon AS icon_3, t0.type AS type_4 FROM pstatut t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created AS created_2, t0.type AS type_3, t0.code AS code_4, t0.nature AS nature_5, t0.observation AS observation_6, t0.active AS active_7, t0.date_integration AS date_integration_8, t0.unique_id AS unique_id_9, t0.motif_annulation AS motif_annulation_10, t0.periode_id AS periode_id_11, t0.user_created_id AS user_created_id_12, t0.dossier_id AS dossier_id_13, t0.paiement_id AS paiement_id_14, t0.piece_id AS piece_id_15, t0.nature_contract_id AS nature_contract_id_16, t0.statut_id AS statut_id_17, t0.devise_id AS devise_id_18, t0.user_integration_id AS user_integration_id_19, t0.user_annulation_id AS user_annulation_id_20, t0.rubrique_indiminite_id AS rubrique_indiminite_id_21 FROM pbordereau t0 WHERE t0.id = ?"
  "params" => [
    1 => 7318
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.annee AS annee_2, t0.code AS code_3, t0.observation AS observation_4, t0.active AS active_5, t0.motif_annulation AS motif_annulation_6, t0.taux_cotis_cimr AS taux_cotis_cimr_7, t0.categorie_cimr AS categorie_cimr_8, t0.periode_id AS periode_id_9, t0.contract_id AS contract_id_10, t0.dossier_id AS dossier_id_11, t0.devise_id AS devise_id_12, t0.paiement_id AS paiement_id_13, t0.bordereau_id AS bordereau_id_14, t0.piece_id AS piece_id_15, t0.user_annulation_id AS user_annulation_id_16 FROM tbulletin t0 WHERE t0.bordereau_id = ?"
  "params" => [
    1 => 7318
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.facture AS facture_4, t0.paiement AS paiement_5, t0.fournisseur AS fournisseur_6, t0.id_article AS id_article_7, t0.honoraire AS honoraire_8, t0.indeminite AS indeminite_9, t0.prets AS prets_10, t0.sens AS sens_11, t0.absence AS absence_12, t0.fixe AS fixe_13, t0.journal AS journal_14, t0.flag_input AS flag_input_15, t0.site_id AS site_id_16, t0.partenaire_id AS partenaire_id_17, t0.regul_article_ugouv_id AS regul_article_ugouv_id_18, t0.imposable AS imposable_19, t0.active AS active_20, t0.echeance AS echeance_21, t0.famille AS famille_22, t0.type AS type_23, t0.ord AS ord_24, t0.rubthm0 AS rubthm0_25, t0.old_designation AS old_designation_26 FROM prubrique t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 4
    2 => 6
    3 => 7
    4 => 8
    5 => 9
    6 => 10
    7 => 93
    8 => 11
    9 => 16
    10 => 24
    11 => 25
    12 => 60
    13 => 76
    14 => 94
    15 => 98
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.montant AS montant_2, t0.sens AS sens_3, t0.active AS active_4, t0.montant_devise AS montant_devise_5, t0.bulletin_id AS bulletin_id_6, t0.rubrique_id AS rubrique_id_7 FROM tbulletin_lg t0 WHERE t0.bulletin_id = ? AND t0.active = ? AND t0.rubrique_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 108094
    2 => 1
    3 => 4
    4 => 6
    5 => 7
    6 => 8
    7 => 9
    8 => 10
    9 => 11
    10 => 16
    11 => 24
    12 => 25
    13 => 60
    14 => 76
    15 => 93
    16 => 94
    17 => 98
  ]
  "types" => [
    1 => 1
    2 => 5
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.facture AS facture_4, t0.paiement AS paiement_5, t0.fournisseur AS fournisseur_6, t0.id_article AS id_article_7, t0.honoraire AS honoraire_8, t0.indeminite AS indeminite_9, t0.prets AS prets_10, t0.sens AS sens_11, t0.absence AS absence_12, t0.fixe AS fixe_13, t0.journal AS journal_14, t0.flag_input AS flag_input_15, t0.site_id AS site_id_16, t0.partenaire_id AS partenaire_id_17, t0.regul_article_ugouv_id AS regul_article_ugouv_id_18, t0.imposable AS imposable_19, t0.active AS active_20, t0.echeance AS echeance_21, t0.famille AS famille_22, t0.type AS type_23, t0.ord AS ord_24, t0.rubthm0 AS rubthm0_25, t0.old_designation AS old_designation_26 FROM prubrique t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 5
    2 => 68
    3 => 30
    4 => 31
    5 => 33
    6 => 34
    7 => 35
    8 => 36
    9 => 37
    10 => 38
    11 => 39
    12 => 85
    13 => 80
    14 => 79
    15 => 78
    16 => 77
    17 => 82
    18 => 83
    19 => 45
    20 => 84
    21 => 97
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
    21 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.facture AS facture_4, t0.paiement AS paiement_5, t0.fournisseur AS fournisseur_6, t0.id_article AS id_article_7, t0.honoraire AS honoraire_8, t0.indeminite AS indeminite_9, t0.prets AS prets_10, t0.sens AS sens_11, t0.absence AS absence_12, t0.fixe AS fixe_13, t0.journal AS journal_14, t0.flag_input AS flag_input_15, t0.site_id AS site_id_16, t0.partenaire_id AS partenaire_id_17, t0.regul_article_ugouv_id AS regul_article_ugouv_id_18, t0.imposable AS imposable_19, t0.active AS active_20, t0.echeance AS echeance_21, t0.famille AS famille_22, t0.type AS type_23, t0.ord AS ord_24, t0.rubthm0 AS rubthm0_25, t0.old_designation AS old_designation_26 FROM prubrique t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 29
    2 => 32
    3 => 40
    4 => 41
    5 => 44
    6 => 46
    7 => 59
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, sum(t1_.montant) AS sclr_1, sum(t1_.montant_devise) AS sclr_2, t1_.id AS id_3 FROM tbulletin_lg t1_ INNER JOIN prubrique p0_ ON t1_.rubrique_id = p0_.id WHERE t1_.bulletin_id = ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND t1_.active = 1 GROUP BY p0_.id"
  "params" => [
    1 => 108094
    2 => 5
    3 => 30
    4 => 31
    5 => 33
    6 => 34
    7 => 35
    8 => 36
    9 => 37
    10 => 38
    11 => 39
    12 => 45
    13 => 68
    14 => 77
    15 => 78
    16 => 79
    17 => 80
    18 => 82
    19 => 83
    20 => 84
    21 => 85
    22 => 97
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
    21 => 1
    22 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, sum(t1_.montant) AS sclr_1, sum(t1_.montant_devise) AS sclr_2, t1_.id AS id_3 FROM tbulletin_lg t1_ INNER JOIN prubrique p0_ ON t1_.rubrique_id = p0_.id WHERE t1_.bulletin_id = ? AND p0_.id IN (?, ?, ?, ?, ?, ?, ?) AND t1_.active = 1 GROUP BY p0_.id"
  "params" => [
    1 => 108094
    2 => 29
    3 => 32
    4 => 40
    5 => 41
    6 => 44
    7 => 46
    8 => 59
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
  ]
]

[
  "sql" => "UPDATE journal_bulletin_lg SET active = ? WHERE bulletin_id = ? AND active = 1"
  "params" => [
    1 => "0"
    2 => 108094
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3, t0.facture AS facture_4, t0.paiement AS paiement_5, t0.fournisseur AS fournisseur_6, t0.id_article AS id_article_7, t0.honoraire AS honoraire_8, t0.indeminite AS indeminite_9, t0.prets AS prets_10, t0.sens AS sens_11, t0.absence AS absence_12, t0.fixe AS fixe_13, t0.journal AS journal_14, t0.flag_input AS flag_input_15, t0.site_id AS site_id_16, t0.partenaire_id AS partenaire_id_17, t0.regul_article_ugouv_id AS regul_article_ugouv_id_18, t0.imposable AS imposable_19, t0.active AS active_20, t0.echeance AS echeance_21, t0.famille AS famille_22, t0.type AS type_23, t0.ord AS ord_24, t0.rubthm0 AS rubthm0_25, t0.old_designation AS old_designation_26 FROM prubrique t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 3
    2 => 12
    3 => 13
    4 => 14
    5 => 15
    6 => 17
    7 => 18
    8 => 22
    9 => 26
    10 => 27
    11 => 61
    12 => 63
    13 => 64
    14 => 65
    15 => 66
    16 => 67
    17 => 69
    18 => 70
    19 => 88
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.montant AS montant_2, t0.sens AS sens_3, t0.active AS active_4, t0.montant_devise AS montant_devise_5, t0.bulletin_id AS bulletin_id_6, t0.rubrique_id AS rubrique_id_7 FROM tbulletin_lg t0 WHERE t0.bulletin_id = ? AND t0.rubrique_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND t0.active = ? LIMIT 1"
  "params" => [
    1 => 108094
    2 => 3
    3 => 12
    4 => 13
    5 => 14
    6 => 15
    7 => 17
    8 => 18
    9 => 22
    10 => 26
    11 => 27
    12 => 61
    13 => 63
    14 => 64
    15 => 65
    16 => 66
    17 => 67
    18 => 69
    19 => 70
    20 => 88
    21 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
    21 => 5
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.montant AS montant_1, t0_.sens AS sens_2, t0_.active AS active_3, t0_.montant_devise AS montant_devise_4, t0_.bulletin_id AS bulletin_id_5, t0_.rubrique_id AS rubrique_id_6 FROM tbulletin_lg t0_ INNER JOIN prubrique p1_ ON t0_.rubrique_id = p1_.id WHERE p1_.id IN (?, ?, ?) AND t0_.bulletin_id = ? AND t0_.active = 1"
  "params" => [
    1 => 50
    2 => 47
    3 => 53
    4 => 108094
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, sum(t1_.montant) AS sclr_1 FROM tbulletin_lg t1_ INNER JOIN prubrique p2_ ON t1_.rubrique_id = p2_.id INNER JOIN tbulletin t0_ ON t1_.bulletin_id = t0_.id WHERE p2_.id IN (?, ?, ?) AND t1_.bulletin_id = ? AND t1_.active = 1 GROUP BY t0_.id"
  "params" => [
    1 => 50
    2 => 47
    3 => 53
    4 => 108094
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 1
    4 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.montant AS montant_1, t0_.sens AS sens_2, t0_.active AS active_3, t0_.montant_devise AS montant_devise_4, t0_.bulletin_id AS bulletin_id_5, t0_.rubrique_id AS rubrique_id_6 FROM tbulletin_lg t0_ INNER JOIN prubrique p1_ ON t0_.rubrique_id = p1_.id WHERE p1_.id IN (?) AND t0_.bulletin_id = ? AND t0_.active = 1"
  "params" => [
    1 => 48
    2 => 108094
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, sum(t1_.montant) AS sclr_1 FROM tbulletin_lg t1_ INNER JOIN prubrique p2_ ON t1_.rubrique_id = p2_.id INNER JOIN tbulletin t0_ ON t1_.bulletin_id = t0_.id WHERE p2_.id IN (?) AND t1_.bulletin_id = ? AND t1_.active = 1 GROUP BY t0_.id"
  "params" => [
    1 => 48
    2 => 108094
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.montant AS montant_1, t0_.sens AS sens_2, t0_.active AS active_3, t0_.montant_devise AS montant_devise_4, t0_.bulletin_id AS bulletin_id_5, t0_.rubrique_id AS rubrique_id_6 FROM tbulletin_lg t0_ INNER JOIN prubrique p1_ ON t0_.rubrique_id = p1_.id WHERE p1_.id IN (?) AND t0_.bulletin_id = ? AND t0_.active = 1"
  "params" => [
    1 => 43
    2 => 108094
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, sum(t1_.montant) AS sclr_1 FROM tbulletin_lg t1_ INNER JOIN prubrique p2_ ON t1_.rubrique_id = p2_.id INNER JOIN tbulletin t0_ ON t1_.bulletin_id = t0_.id WHERE p2_.id IN (?) AND t1_.bulletin_id = ? AND t1_.active = 1 GROUP BY t0_.id"
  "params" => [
    1 => 43
    2 => 108094
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.article_ugouv_id AS article_ugouv_id_2, t0.article_ugouv_rh AS article_ugouv_rh_3, t0.compte_comptable AS compte_comptable_4, t0.sens AS sens_5, t0.qte AS qte_6, t0.rubrique_id AS rubrique_id_7, t0.nature_contract_id AS nature_contract_id_8 FROM pcompte_comptable t0 WHERE t0.rubrique_id = ? AND t0.nature_contract_id = ? LIMIT 1"
  "params" => [
    1 => 5
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.article_ugouv_id AS article_ugouv_id_2, t0.article_ugouv_rh AS article_ugouv_rh_3, t0.compte_comptable AS compte_comptable_4, t0.sens AS sens_5, t0.qte AS qte_6, t0.rubrique_id AS rubrique_id_7, t0.nature_contract_id AS nature_contract_id_8 FROM pcompte_comptable t0 WHERE t0.rubrique_id = ? AND t0.nature_contract_id = ? LIMIT 1"
  "params" => [
    1 => 64
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "INSERT INTO journal_bulletin_lg (montant, code_comptable, qte, active, type, sens, montant_devise, bulletin_id, rubrique_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 876.24
    2 => "443202112001"
    3 => 1
    4 => 1
    5 => "netpaye"
    6 => "-1"
    7 => null
    8 => 108093
    9 => 5
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
    4 => 5
    5 => 2
    6 => 2
    7 => 2
    8 => 1
    9 => 1
  ]
]

[
  "sql" => "INSERT INTO journal_bulletin_lg (montant, code_comptable, qte, active, type, sens, montant_devise, bulletin_id, rubrique_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 876.24
    2 => "617132112004"
    3 => 0
    4 => 1
    5 => "netpaye"
    6 => "1"
    7 => null
    8 => 108093
    9 => 64
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
    4 => 5
    5 => 2
    6 => 2
    7 => 2
    8 => 1
    9 => 1
  ]
]

[
  "sql" => "INSERT INTO journal_bulletin_lg (montant, code_comptable, qte, active, type, sens, montant_devise, bulletin_id, rubrique_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 101.56
    2 => "443202112001"
    3 => 1
    4 => 1
    5 => "netpaye"
    6 => "-1"
    7 => null
    8 => 108094
    9 => 5
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
    4 => 5
    5 => 2
    6 => 2
    7 => 2
    8 => 1
    9 => 1
  ]
]

[
  "sql" => "INSERT INTO journal_bulletin_lg (montant, code_comptable, qte, active, type, sens, montant_devise, bulletin_id, rubrique_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 101.56
    2 => "617132112004"
    3 => 0
    4 => 1
    5 => "netpaye"
    6 => "1"
    7 => null
    8 => 108094
    9 => 64
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
    4 => 5
    5 => 2
    6 => 2
    7 => 2
    8 => 1
    9 => 1
  ]
]

[
  "sql" => "UPDATE pbordereau SET statut_id = ? WHERE id = ?"
  "params" => [
    1 => 2
    2 => 7317
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "UPDATE pbordereau SET statut_id = ? WHERE id = ?"
  "params" => [
    1 => 2
    2 => 7318
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]