🔄 Migration SQLite → MySQL 📦 Migration de 'users' (2 lignes)... ⚠️ Erreur sur 'users': SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'users.PRIMARY' (Connection: mysql, SQL: insert into `users` (`created_at`, `email`, `email_verified_at`, `est_actif`, `est_admin`, `id`, `name`, `nom`, `password`, `permissions`, `remember_token`, `updated_at`) values (2025-08-29 14:39:50, admin@gmail.com, 2025-08-29 14:39:50, 1, 1, 1, Administrateur, Admin, $2y$12$1rswlgkX8ZZ/0C6iXI1qM.88kOUytFjfqGRIL2RbVQPM6p/eL1phu, ?, ?, 2025-08-29 14:39:50), (2025-08-29 14:39:50, user@gmail.com, 2025-08-29 14:39:50, 1, 0, 2, Utilisateur Standard, Utilisateur, $2y$12$aej.r8G47SPHBFohgXZH7eX.KI6I.GidCG3ndHVTEgy6RwYvdTihO, ?, ?, 2025-08-29 14:39:50)) 📦 Migration de 'clients' (111 lignes)... ⚠️ Erreur sur 'clients': SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'nom' at row 12 (Connection: mysql, SQL: insert into `clients` (`adresse`, `created_at`, `email`, `id`, `nom`, `odoo_client_id`, `source_id`, `telephone`, `updated_at`) values (123 Rue de la Paix, Cotonou, 2025-08-29 14:39:51, contact@abc-sarl.bj, 1, Entreprise ABC Sarl, ?, 0, +229 21 30 45 67, 2025-08-29 14:39:51), (456 Avenue de l'Independence, Porto-Novo, 2025-08-29 14:39:51, info@construction-xyz.bj, 2, Construction XYZ, ?, 0, +229 22 21 34 56, 2025-08-29 14:39:51), (789 Boulevard du 1er Novembre, Parakou, 2025-08-29 14:39:51, contact@btp-pro.bj, 3, Services BTP Pro, ?, 0, +229 23 61 45 78, 2025-08-29 14:39:51), (OUAGADOUGOU, 2025-08-29 14:58:52, 0, 4, KABRE MOHAMADI, 6, 1, +226 56 81 91 89, 2025-09-01 11:17:42), (, 2025-08-29 14:58:52, 0, 5, ESOFT BURKINA SARL, 1, 1, 0, 2025-10-28 11:32:52), (OUAGA CENTRE VILLE, OUAGA, 2025-08-29 14:58:52, 0, 7, nabivo, 7, 1, +226 66 81 86 96, 2025-09-01 11:17:42), (123 Avenue de l'Ind�pendance, Ouagadougou, 2025-08-29 21:30:26, contact@societetest.com, 8, Soci�t� Test Compl�te, 9, 1, +226 25 36 47 58, 2025-08-29 21:30:26), (OUAGA PERSIL, 2025-08-29 21:37:22, comdeco@gmail.com, 9, Compore deco, 11, 1, +226 66 76 48 39, 2025-08-29 21:37:22), (OUAGA, 2025-08-29 21:38:41, coco@gmail.com, 10, coco beate, ?, 0, +226 818697, 2025-08-29 21:38:41), (123, OUAGA 3S, 2025-08-29 21:50:36, client2@gmail.com, 11, client2, 12, 1, +226 68 970 09, 2025-08-29 21:50:36), (, 2025-09-11 09:24:12, 0, 12, 2IE, 102, 1, 0, 2025-10-28 11:32:50), (, 2025-09-11 09:24:12, 0, 13, Institut International d'Ingénierie de l'Eau et de l'Environnement (2IE) Adresse : Rue de la Science - 01 BP 594 Ouagadougou 01 - BURKINA FASO IFU: 00007748B Téléphone : +226 25 49 28 00 E-mail : 2ie@2ie-edu.org, 108, 1, 0, 2025-10-28 11:32:53), (, 2025-09-11 09:24:12, 0, 14, 2IE Adresse : Rue de la Science - 01 BP 594 Ouagadougou 01 - BURKINA FASO Téléphone : +226 25 49 28 00 E-mail : 2ie@2ie-edu.org, 107, 1, 0, 2025-10-28 11:32:50), (, 2025-09-11 09:24:12, 2ie@2ie-edu.org, 15, 2ie@2ie-edu.org, 115, 1, 0, 2025-10-28 11:32:50), (, 2025-09-11 09:24:12, 2ie@2ie-edu.org, 16, 2ie@2ie-edu.org, 106, 1, 0, 2025-10-28 11:32:50), (, 2025-09-11 09:24:12, 2ie@2ie-edu.org, 17, 2ie@2ie-edu.org, 105, 1, 0, 2025-10-28 11:32:50), (, 2025-09-11 09:24:12, 2ie@2ie-edu.org, 18, 2ie@2ie-edu.org, 104, 1, 0, 2025-10-28 11:32:50), (, 2025-09-11 09:24:12, 2ie@2ie-edu.org, 19, 2ie@2ie-edu.org, 103, 1, 0, 2025-10-28 11:32:50), (Tel : +226 25 37 89 40 Karpala, Secteur 51, Ouagadougou, Ouagadougou, 2025-09-11 09:24:12, 0, 20, ACFIME, 24, 1, 0, 2025-10-28 11:32:50), (Bureau de Ouaga Villa N66, Rue Baor Ganga Secteur N13 Zone du Bois Ouagadougou 11, Ouagadougou, 2025-09-11 09:24:12, 0, 21, AFRICAN UNDERGROUND MINING SERVICES, 15, 1, 0, 2025-10-28 11:32:51), (Burkina faso sarl 11 BP 1145 CMS OUAGADOUGOU 11 Secteur 22, Zone du bois -Baor Ganga,lot 33, Parcelle 04, Section EO SARL, OUAGADOUGOU, 2025-09-11 09:24:12, MOuarme@aumsgh.com, 22, AFRICAN UNDERGROUND MINING SERVICES (AUMS), 33, 1, +226 25 36 11 09, 2025-09-11 09:24:12), (, 2025-09-11 09:24:12, 0, 23, AGENCE NATIONALE DES ENERGIES RENOUVELABLES ET DE L’EFFICACITE ENERGETIQUE, 37, 1, 0, 2025-10-28 11:32:51), (, 2025-09-11 09:24:12, 0, 24, AMUS BURKINA, 120, 1, 0, 2025-10-28 11:32:51), (Cité AN 3, avenue du Capitaine KOUANDA, 2025-09-11 09:24:12, sales@ascompanytech.com, 25, AS COMPANY TECHNOLOGIE SARL, 116, 1, +226 25334254/25407033, 2025-09-11 09:24:12), (9 BP 1651 Ouagadougou 09, Ouagadougou, 2025-09-11 09:24:12, 0, 26, AUMARCHE, 96, 1, 0, 2025-10-28 11:32:51), (, 2025-09-11 09:24:12, 0, 27, Académie Militaire Georges Namoano de PO, 139, 1, 0, 2025-10-28 11:32:51), (, 2025-09-11 09:24:12, 0, 28, Adresse géographique : Ouagadougou/ ZAD /secteur 24/Parcelle 06/1 / Lot 27/Section TK Adresse postale : 12 BP 94 Ouaga 12 Tél : 78 34 22 42, 66 88 84 30 RCCM : BF OUA 2013 A 4974 N° IFU : 00050235T, Régime d’imposition : REGIME NORMAL D’IMPOSITION Division fiscale : DME CENTRE II, 59, 1, 0, 2025-10-28 11:32:51), (Secteur52,Avenue Mohammar KADHAFI , 11 BP 1912 Ouagadougou CMS 11, OUAGADOUGOU, 2025-09-11 09:24:12, infos@agetib.net/ agetib@fasonet.bf, 29, Agence desTravaux d'Infrastructures du Burkina, 34, 1, +226 25 37 72 23, 2025-09-11 09:24:12), (, 2025-09-11 09:24:12, 0, 30, Amadou OUATTARA, 54, 1, 0, 2025-10-28 11:32:51), (, 2025-09-11 09:24:13, 0, 31, Association Mains Unies du Sahel 01 BP 5925 Ouagadougou Kadiogo Centre, 93, 1, 0, 2025-10-28 11:32:51), (01 BP 5925 OUAGADOUGOU 01, 2025-09-11 09:24:13, 0, 32, Association les Mains Unies du Sahel (AMUS), 94, 1, (+226) 68 22 35 35 / 70 25 96 93, 2025-10-28 11:32:51), (, 2025-09-11 09:24:13, 0, 33, BEIG-TOPO.SARL, 70, 1, 0, 2025-10-28 11:32:51), (, 2025-09-11 09:24:13, 0, 34, BEIG-TOPO.SARL, Arrondissement 11, Secteur 51, Lot 31,Parcelle 01, 14, 71, 1, 0, 2025-10-28 11:32:51), (, 2025-09-11 09:24:13, 0, 35, BEIG-TOPO.SARL, Arrondissement 11, Secteur 51, Lot 31,Parcelle 01, 14 BV 303667 OUAGA ZAD, Ouagadougou, Burkina Faso, RCCM:BF-OUA-01-2024 B12-00385 I N°IFU: 00221822G, Régime Fiscal: Régime Simplifié d'Imposition (RSI), 72, 1, 0, 2025-10-28 11:32:51), (, 2025-09-11 09:24:13, 0, 36, Banque africaine de développement (BAD) Bureau national du Burkina Faso Immeuble ARCEP, 5e étage, Ouaga 2000 Tél. : +226 25 37 57 50, 137, 1, 0, 2025-10-28 11:32:51), (, 2025-09-11 09:24:13, 0, 37, Banque africaine de développement (BAD) Bureau national du Burkina Faso, 134, 1, 0, 2025-10-28 11:32:51), (, 2025-09-11 09:24:13, 0, 38, Banque africaine de développement (BAD) Bureau national du Burkina Faso Immeuble ARCEP, 5e étage, Ouaga 2000, 135, 1, 0, 2025-10-28 11:32:51), (, 2025-09-11 09:24:13, 0, 39, Banque africaine de développement (BAD) Bureau national du Burkina Faso Immeuble ARCEP, 5e étage, Ouaga 2000 Tél. : +226 25 37 57 50, 136, 1, 0, 2025-10-28 11:32:51), (, 2025-09-11 09:24:13, 0, 40, Boungou Gold Operations, 45, 1, 0, 2025-10-28 11:32:51), (, 2025-09-11 09:24:13, bfs@bfs.bf, 41, Bridge Fiber Solutions (BFS), 22, 1, 0, 2025-10-28 11:32:51), (, 2025-09-11 09:24:13, 0, 42, Bureau international des droits des enfants (IBCR), 121, 1, 0, 2025-10-28 11:32:52), (, 2025-09-11 09:24:13, 0, 43, Bureau international des droits des enfants (IBCR) Burkina Faso Zone du Bois 03 BP 7041 Ouagadougou 03 Téléphone : +226 25 36 34 59, 122, 1, 0, 2025-10-28 11:32:52), (, 2025-09-11 09:24:13, wfp.ouagadougou@wfp.org, 44, Burkina Faso Ouagadougou Burkina Faso Téléphone +226 25306077 Fax +226 25313817 Messagerie électronique, 42, 1, 0, 2025-10-28 11:32:52), (Ouagadougou,Burkina Faso, 2025-09-11 09:24:13, 0, 45, CABINET HOPE CONSULT SARL , RCCM N° BF OUA B 6797; 01 BP 4427 Ouagadougou 01; 1200 Logements; N°IFU: 000094900H ;Régime fiscal:RNI ;Division fiscal:DME CENTRE II, 18, 1, +226 61 01 15 15, 2025-10-28 11:32:52), (01 BP 6460 Ouagadougou 01, Quartier de la Rotonde, Porte 154, au croisement de la Rue Alwata LAMIZANE et de l’Avenue Bernanrd TiboOUEDRAOGO, 2025-09-11 09:24:13, 0, 46, COMMISSION NATIONALE DES DROITS HUMAINS DU BURKINA FASO (CNDH), 63, 1, Tél : +226 25 33 07 61/62/63/64, 2025-10-28 11:32:52), (, 2025-09-11 09:24:13, 0, 47, COMMISSION NATIONALE DES DROITS HUMAINS DU BURKINA FASO, 74, 1, 0, 2025-10-28 11:32:52), (, 2025-09-11 09:24:13, 0, 48, COMMISSION NATIONALE DES DROITS HUMAINS DU BURKINA FASO 01 BP 6460 Ouagadougou 01, Quartier de la Rotonde, Porte 154, au croisement de La Rue Alwata LAMIZANE et de l’Avenue Bernanrd Tibo OUEDRAOGO, en face du terrain de l’Etoile Filante de Ouagadougou (EFO) Tél : +226 25 33 07 61/62/63/64, 77, 1, 0, 2025-10-28 11:32:52), (, 2025-09-11 09:24:13, 0, 49, COMMISSION NATIONALE DES DROITS HUMAINS DU BURKINA FASO 01 BP 6460 Ouagadougou 01, Quartier de la Rotonde, Porte 154, au croisement de la Rue Alwata LAMIZANE et de l’Avenue Bernanrd Tibo OUEDRAOGO, en face du terrain de l’Etoile Filante de Ouagadougou (EFO) Tél :+226 25 33 07 61/62/63/64, 75, 1, 0, 2025-10-28 11:32:52), (, 2025-09-11 09:24:13, 0, 50, COMMISSION NATIONALE DES DROITS HUMAINS DU BURKINA FASO Une autorité publique indépendante de promotion, protection et de défense des droits humains, 73, 1, 0, 2025-10-28 11:32:52), (Boite Postale: 03 BP 7130 Ouagadougou 03, 2025-09-11 09:24:13, cenamafs@education.gov.bf--boitepostale, 51, Centre National des Manuels et Fournitures Scolaires ( CENAMAFS), 131, 1, +226 25 37 20 62, 2025-11-05 22:54:35), (11 B.P 1437 Ouagadougou 11 Tél : +226 50 35 11 35 E-mail : wrmc_cgre@ecowas.int, Ouagadougou, 2025-09-11 09:24:15, 0, 52, Centre de Gestion des Ressources en Eau (CGRE) Water Resources Management Center (WRMC) CEDEAO - ECOWAS, 27, 1, +226 50 35 11 35, 2025-10-28 11:32:52), (, 2025-09-11 09:24:15, 0, 53, Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH Rue Jacqueline Ki-Zerbo 01 BP 1485 Ouagadougou 01 Burkina Faso T + 226 25 31 16 72/73 ou 25 31 40 27 I www.giz.de, 99, 1, 0, 2025-10-28 11:32:52), (, 2025-09-11 09:24:15, 0, 54, Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH Rue Jacqueline Ki-Zerbo 01 BP 1485 Ouagadougou 01 Burkina Faso T + 226 25 31 16 72/73 ou 25 31 40 27 I www.giz.de, 62, 1, 0, 2025-10-28 11:32:52), (Quartier Dassasgho, Rue 27-67, Porte 150 – 06 BP 10776 Ouagadougou 06 Téléphone : +226 25 36 47 80 RCCM N° BF OUA 2018 M 7159 IFU : 00041136 D DIVISION DES GRANDES ENTREPRISES (DGE) REGIME DU REEL NORMAL, Ouagadougou, 2025-09-11 09:24:15, 0, 55, EPIROC BURKINA FASO SARL, 28, 1, +226 25 36 47 80, 2025-10-28 11:32:52), (11 BP 192 CMS Ouaga 11, OUAGADOUGOU, 2025-09-11 09:24:15, E-Mail.: kafandoamado10@gmail.com, 56, Ets Tatama Commerces Général, 84, 1, 78 35 83 15 / 70 70 02 40 /65 03 02 40, 2025-09-11 09:24:15), (Tel: +226 25 338 888 Fax: +226 25 300 760 BP 6648 OUAGA 01, 2025-09-11 09:24:15, 0, 57, GLOBUS RE, 29, 1, 0, 2025-10-28 11:32:52), (, 2025-09-11 09:24:16, 0, 58, GRAS, 38, 1, 0, 2025-10-28 11:32:52), (, 2025-09-11 09:24:16, 0, 59, GRAS Burkina, 110, 1, 0, 2025-10-28 11:32:52), (06 BP 10248 Ouagadougou 06, BURKINA FASO Secteur 19, Somgandé Tél: (+226) 25 35 56 90 Fax : (+226) 25 35 56 73, Ouagadougou, 2025-09-11 09:24:16, 0, 60, GROUPE DE RECHERCHE ACTION EN SANTE, 25, 1, +226 25 35 56 90, 2025-10-28 11:32:52), (, 2025-09-11 09:24:16, 0, 61, Groupe de Recherche Action Santé (GRAS), 78, 1, 0, 2025-10-28 11:32:52), (, 2025-09-11 09:24:16, 0, 62, Groupe de Recherche Action en Santé (GRAS), 06 BP 10248 Ouagadougou 06, Burkina Faso Secteur 19, Somgandé Tél : (+226) 25-35-56-90 Fax : (+226) 25-35-56-73 E-mail: gras@fasonet.bf Site Web: www.gras.bf, 81, 1, 0, 2025-10-28 11:32:52), (Tel : Tel. (+226) 25363292 Cité 1200 Logements 01 BP 1612 Ouagadougou 01, Ouagadougou, 2025-09-11 09:24:16, 0, 63, HUMAN PROJECT, 26, 1, 0, 2025-10-28 11:32:53), (, 2025-09-11 09:24:16, herve.kabore@gmail.com, 64, Hervé KABORE, 56, 1, Tel: 72795254, 2025-09-11 09:24:16), (, 2025-09-11 09:24:16, 0, 65, Hervé KABORE, 55, 1, 0, 2025-10-28 11:32:53), (PROJET D'HARMONISATION ET D'AMELIORATION DES STATISTIQUES EN AFRIQUE DE L'OUEST (PHASAO), 2025-09-11 09:24:16, 0, 66, INSTITUT NATIONAL DE LA STATISTIQUE ET DE LA DEMOGRAPHIE (INSD), 52, 1, 0, 2025-10-28 11:32:53), (rue de Pissy, Ouagadougou, 2025-09-11 09:24:16, 0, 67, Institut International d’Ingénierie de l’Eau et de l’Environnement, 23, 1, 0, 2025-10-28 11:32:53), (+22676228022, Ouagadougou, 2025-09-11 09:24:16, 0, 68, Ismael OUEDRAOGO, 21, 1, 0, 2025-10-28 11:32:53), (, 2025-09-11 09:24:16, 0, 69, Loterie Nationale Burkinabè (LONAB), 123, 1, 0, 2025-10-28 11:32:53), (, 2025-09-11 09:24:16, lonab@lonab.bfwww.facebook.com/lonab.bf, 70, Loterie Nationale Burkinabè (LONAB) 01 BP 68 Ouaga 01.436 rue du grand marché (+226) 25 30 61 21 / 22 ou 25 49 72 00 Fax : +226 25 31 19 42 Email : lonab@lonab.bf www.facebook.com/lonab.bf, 125, 1, 0, 2025-10-28 11:32:53), (, 2025-09-11 09:24:16, 0, 71, Loterie Nationale Burkinabè (LONAB) 01 BP 68 Ouaga 01.436 rue du grand marché (+226) 25 30 61 21 / 22 ou 25 49 72 00 Fax : +226 25 31 19 42 Email : lonab@lonab.bf www.facebook.com/lonab.bf, 124, 1, 0, 2025-10-28 11:32:53), (Ouagadougou Burkina Faso Tél : 25 37 40 82 56 73, Ouagadougou, 2025-09-11 09:24:16, 0, 72, Lutheran World Relief, 30, 1, 0, 2025-10-28 11:32:53), (, 2025-09-11 09:24:16, 0, 73, MINISTERE DE LA DEFENSE, 49, 1, 0, 2025-10-28 11:32:53), (, 2025-09-11 09:24:16, 0, 74, MINISTERE DE LA DEFENSE ET DES ANCIENS COMBATANTS, 50, 1, 0, 2025-10-28 11:32:53), (, 2025-09-11 09:24:16, 0, 75, MINISTERE DE LA DEFENSE ET DES ANCIENS COMBATANTS/SG/DMP/AMGN, 51, 1, 0, 2025-10-28 11:32:53), (SECRETARIAT GENERAL, DIRECTION DES MARCHES PUBLICS, PROJET DE RENFORCEMENT DE LA RESILIENCE CLIMATIQUE ( HYDROMET), 2025-09-11 09:24:16, 0, 76, MINISTERE DES TRANSPORTS, DE LA MOBILITE URBAINE ET DE LA SECURITE ROUTIERE, 92, 1, 0, 2025-10-28 11:32:53), (SECRETARIAT GENERAL, DIRECTION DES MARCHES PUBLICS, PROJET DE RENFORCEMENT DE LA RESILIENCE CLIMATIQUE ( HYDROMET), 2025-09-11 09:24:16, 0, 77, MINISTERE DES TRANSPORTS, DE LA MOBILITE URBAINE ET DE LA SECURITE ROUTIERE, 90, 1, 0, 2025-10-28 11:32:53), (, 2025-09-11 09:24:16, 0, 78, MINISTERES DES INFRASTRUCTURES--SECRETARIAT GENERAL--PROJET DE MOBILITE ET DE DEVELOPPEMENT URBAIN DES VILLES SECONDAIRES (PMDUVS), 111, 1, 0, 2025-10-28 11:32:53), (, 2025-09-11 09:24:16, 0, 79, Mahamadi Kaboré, 44, 1, 0, 2025-10-28 11:32:53), (, 2025-09-11 09:24:17, 0, 80, Neemba Burkina Gampela, 01 route de Niamey - Nationale 4 - Km 17, 01 BP 1476, Ouagadougou 01 - Burkina Faso, 112, 1, 0, 2025-10-28 11:32:53), (, 2025-09-11 09:24:17, 0, 81, ONG CONCERN WORLDWIDE, 53, 1, 0, 2025-10-28 11:32:53), (, 2025-09-11 09:24:17, 0, 82, ONU Programme Alimentaire Mondial (PAM), 40, 1, 0, 2025-10-28 11:32:53), (, 2025-09-11 09:24:17, 0, 83, ONU Programme Alimentaire Mondial (PAM) 66, Angle Av. Georges Konseiga et Av.du Général Aboubacar S. Lamizana, 11 BP 1754 Ouagadougou 11, Burkina Faso Ouagadougou Burkina Faso+226 25306077, 43, 1, 0, 2025-10-28 11:32:54), (, 2025-09-11 09:24:17, sopafer-b@sopafer-b.gov.bf, 84, Ouagadougou Burkina Faso, 69, 1, 0, 2025-10-28 11:32:54), (12 BP 99 Ouagadougou 12, 2025-09-11 09:24:17, 0, 85, PROJET D'APPUI A L'INCLUSION FINANCIERE ET L'ACCES AU FINANCEMENT DES PETITES ET MOYENNES ENTREPRISES (PAIF-PME), 47, 1, +226 61 58 24 24, 2025-10-28 11:32:54), (Ouagadougou, 2025-09-11 09:24:17, 0, 86, PROJET DE RENFORCEMENT DE LA RESILIENCE DES PETITS PRODUCTEURS RESI-2P 15 BP 233 Ouagadougou 15 Ouaga 2000, Ouagadougou Tel: 25 40 93 63, 76, 1, +226 25 40 93 63, 2025-10-28 11:32:54), (Ouagadougou, 2025-09-11 09:24:17, 0, 87, PROJET MULTI-SECTORIEL DANS LES REGIONS DU NORD, EST, BOUCLE DU MOUHOUN ET CENTRE-EST Ouagadougou Zone du Bois Parcelle B, lot22 Rue Pazana, Porte n° 282 Ouagadougou Burkina Faso Tel : 05 00 41 11 Arrêté portant autorisation d’exerce n°2021-000037/MATD/SG/DGLPAAP/DOASOC Numéro IFU : 00240038G Régime fiscal : Non Déterminé Direction fiscale : DME C IV, 41, 1, +226 05 00 41 11, 2025-10-28 11:32:54), (, 2025-09-11 09:24:17, 0, 88, REGUL, 86, 1, 0, 2025-10-28 11:32:54), (, 2025-09-11 09:24:17, 0, 89, SAPIENTIA, 60, 1, 0, 2025-10-28 11:32:54), (, 2025-09-11 09:24:17, 0, 90, SAPIENTIA -Ouagadougou/ ZAD /secteur 24/Parcelle 06/1 / Lot 27/Section TK Adresse postale : 12 BP 94 Ouaga 12 Tél : 78 34 22 42, 66 88 84 30 RCCM : BF OUA 2013 A 4974 N° IFU : 00050235T, Régime d’imposition : REGIME NORMAL D’IMPOSITION Division fiscale : DME CENTRE II, 61, 1, 0, 2025-10-28 11:32:54), (, 2025-09-11 09:24:17, 0, 91, SECRETARIAT GENERAL, DIRECTION DES MARCHES PUBLICS, 91, 1, 0, 2025-10-28 11:32:54), (, 2025-09-11 09:24:17, 0, 92, SEMAFO BOUNGOU SA Avenue Gérard Kango OUEDRAOGO, Ouaga 2000, Zone B Secteur 54, Section G, Lot 41, Parcelle 03, 01 BP 1334 Ouagadougou 01 Burkina Faso RCCM:BFOUA012023M14048 IFU : 00079626 A Régime d'imposition : Réel Normal Division Fiscale: Direction des Grandes Entreprises (DGE), 85, 1, +226 25 36 04 86, 2025-10-28 11:32:54), (, 2025-09-11 09:24:17, 0, 93, SEMAFO BOUNGOU SA Avenue Gérard Kango OUEDRAOGO, Ouaga 2000, Zone B Secteur 54, Section G, Lot 41, Parcelle 03, 01 BP 1334 Ouagadougou 01 Burkina Faso RCCM:BFOUA012023M14048 IFU : 00079626 A Régime d'imposition : Réel Normal Division Fiscale: Direction des Grandes Entreprises (DGE), 46, 1, +226 25 37 59 44, 2025-10-28 11:32:54), (, 2025-09-11 09:24:17, 0, 94, SEMAFO BOUNGOU SA 11 BP 1196 CMS OUAGADOUGOU 11 Avenue Gérard Kango OUEDRAOGO Ouaga 2000, Secteur 54, Zone B3, Section G Lot 41, Parcelle 03 AvenueTel : +226 25 37 59 44 RCCM : BFOUA012023M14048 IFU : 00079626 A, 117, 1, 0, 2025-10-28 11:32:54), (, 2025-09-11 09:24:17, 0, 95, SNV (Netherlands Développent Organisation Ouaga 2000 Sect.54 Av. SAR Elie, Porte 437 | 01 BP : 625 Ouagadougou 01 | Burkina Faso | www.snv.org | + 226 25 40 92 63 /+226 05 05 16 86,• Doit : PROJET GREEN MANGO, 128, 1, 0, 2025-10-28 11:32:54), (, 2025-09-11 09:24:17, 0, 96, SNV (Netherlands Développent Organisation Ouaga 2000 Sect.54 Av. SARE Elie, Porte 437 | 01 BP : 625 Ouagadougou 01 | Burkina Faso | www.snv.org | + 226 25 40 92 63 /+226 05 05 16 86,• Doit : PROJET GREEN MANGO, 129, 1, 0, 2025-10-28 11:32:54), (, 2025-09-11 09:24:17, info@snv.org, 97, SNV (Netherlands Développent Organisation Ouaga 2000 Sect.54 Av. SARE Elie, Porte 437 | 01 BP : 625 Ouagadougou 01 | Burkina Faso | www.snv.org | + 226 25 40 92 63 /+226 05 05 16 86, 48, 1, 0, 2025-10-03 04:32:34), (, 2025-09-11 09:24:17, 0, 98, SNV (Netherlands Développent Organisation Ouaga 2000 Sect.54 Av. SARPROJET GREEN MANGOE Elie, Porte 437 | 01 BP : 625 Ouagadougou 01 | Burkina Faso | www.snv.org | + 226 25 40 92 63 /+226 05 05 16 86, 126, 1, 0, 2025-10-03 04:32:34), (, 2025-09-11 09:24:17, 0, 99, SNV (Netherlands Développent Organisation Ouaga 2000 Sect.54 Av. SARPROJET GREEN MANGOE Elie, Porte 437 | 01 BP : 625 Ouagadougou 01 | Burkina Faso | www.snv.org | + 226 25 40 92 63 /+226 05 05 16 86,• Doit : PROJET GREEN MANGO, 127, 1, 0, 2025-09-11 09:24:17), (, 2025-09-26 10:21:25, 0, 100, MINISTERE DE L’ECONOMIE ET DES FINANCES ---------------------------------- INSTITUT NATIONAL DE LA STATISTIQUE ET DE LA DEMOGRAPHIE (INSD) ---------------------------------- PROJET D’HARMONISATION ET D’AMELIORATION DES STATISTIQUES EN AFRIQUE DE L’OUEST (PHASAO), 140, 1, 0, 2025-10-28 11:32:53), (ouaga 13, 2025-10-05 23:21:16, abdoul@gmail.com, 101, OUEDRAOGO ABDOUL RAZACK, ?, 0, 66818696, 2025-10-05 23:21:16)) 📦 Migration de 'fournisseurs' (9 lignes)... ⚠️ Erreur sur 'fournisseurs': SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'fournisseurs.PRIMARY' (Connection: mysql, SQL: insert into `fournisseurs` (`adresse`, `compte_bancaire`, `created_at`, `email`, `id`, `nom`, `pays`, `secteur_activite`, `statut`, `telephone`, `type_compte`, `type_compte_autre`, `updated_at`) values (15 Avenue de la République, 75011 Paris, ?, 2025-08-29 14:39:51, contact@electricite-moderne.fr, 1, SARL ELECTRICITE MODERNE, ?, ?, actif, 01 48 05 22 33, ?, ?, 2025-08-29 14:39:51), (42 Rue des Artisans, 69007 Lyon, ?, 2025-08-29 14:39:51, devis@btp-construction.com, 2, BTP CONSTRUCTION SA, ?, ?, actif, 04 78 90 12 34, ?, ?, 2025-08-29 14:39:51), (88 Boulevard Industriel, 59000 Lille, ?, 2025-08-29 14:39:51, commercial@equipements-nord.fr, 3, EQUIPEMENTS INDUSTRIELS NORD, ?, ?, actif, 03 20 45 67 89, ?, ?, 2025-08-29 14:39:51), (7 Zone Industrielle Sud, 13013 Marseille, ?, 2025-08-29 14:39:51, info@materiaux-fournitures.com, 4, MATERIAUX & FOURNITURES, ?, ?, actif, 04 91 88 77 66, ?, ?, 2025-08-29 14:39:51), (23 Rue de Bretagne, 35000 Rennes, ?, 2025-08-29 14:39:51, contact@services-ouest.fr, 5, SERVICES TECHNIQUES DE L'OUEST, ?, ?, actif, 02 99 12 34 56, ?, ?, 2025-08-29 14:39:51), (156 Avenue des Technologies, 31000 Toulouse, ?, 2025-08-29 14:39:52, ventes@info-bureau.fr, 6, INFORMATIQUE & BUREAUTIQUE PRO, ?, ?, actif, 05 61 23 45 67, ?, ?, 2025-08-29 14:39:52), (9 Rue du Port, 76000 Le Havre, ?, 2025-08-29 14:39:52, dispatch@transport-express.com, 7, TRANSPORT & LOGISTIQUE EXPRESS, ?, ?, actif, 02 35 78 90 12, ?, ?, 2025-08-29 14:39:52), (33 Impasse de la Sécurité, 67000 Strasbourg, ?, 2025-08-29 14:39:52, alarmes@securite-systems.fr, 8, SECURITE ALARMES SYSTEMS, ?, ?, actif, 03 88 44 55 66, ?, ?, 2025-08-29 14:39:52), (OUAGA, ?, 2025-11-05 22:05:57, abdoulrazackouedraogo@gmail.com, 9, Ouedrago Aboul Razack, Burkina Faso, BTP, actif, 668186965, ?, ?, 2025-11-05 22:05:57)) 📦 Migration de 'banques' (10 lignes)... ⚠️ Erreur sur 'banques': SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3' for key 'banques.PRIMARY' (Connection: mysql, SQL: insert into `banques` (`created_at`, `id`, `nom`, `updated_at`) values (2025-09-29 15:42:46, 3, ECOBANK, 2025-09-29 15:42:46), (2025-09-29 15:42:46, 9, NSIA Banque, 2025-09-29 15:42:46), (2025-09-29 15:42:46, 10, Banque Populaire de Côte d'Ivoire, 2025-09-29 15:42:46), (2025-10-06 03:18:08, 11, SGBCI - Société Générale, 2025-10-06 03:18:08), (2025-10-06 03:18:09, 12, BICICI - Banque Internationale pour le Commerce, 2025-10-06 03:18:09), (2025-10-06 03:18:09, 13, BOA - Bank of Africa, 2025-10-06 03:18:09), (2025-10-06 03:18:09, 14, ECOBANK Côte d'Ivoire, 2025-10-06 03:18:09), (2025-10-06 03:18:09, 15, Bridge Bank Group, 2025-10-06 03:18:09), (2025-10-06 03:18:09, 16, UBA - United Bank for Africa, 2025-10-06 03:18:09), (2025-10-06 03:18:09, 17, Banque Atlantique, 2025-10-06 03:18:09)) 📦 Migration de 'garantie_bonne_executions' (69 lignes)... ⚠️ Erreur sur 'garantie_bonne_executions': SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`esoftbursuivifac`.`garantie_bonne_executions`, CONSTRAINT `garantie_bonne_executions_banque_id_foreign` FOREIGN KEY (`banque_id`) REFERENCES `banques` (`id`) ON DELETE SET NULL) (Connection: mysql, SQL: insert into `garantie_bonne_executions` (`banque_id`, `commentaire_liberation`, `created_at`, `date_debut`, `date_echeance`, `date_liberation`, `document_joint`, `document_liberation`, `id`, `intitule_marche`, `montant_garantie`, `montant_marche`, `pourcentage`, `reference_marche`, `statut`, `updated_at`) values (3, ?, 2025-09-29 16:51:38, 2025-09-29 00:00:00, 2026-09-29 00:00:00, ?, ?, ?, 1, Aquisition de marchandise, 11988, 120000, 9.99, MARCHE64, ACTIVE, 2025-09-29 16:51:38), (3, ?, 2025-09-29 16:57:01, 2025-09-29 00:00:00, 2026-09-29 00:00:00, ?, ?, ?, 2, Aquisition de marchandise, 99999.999, 999999.99, 10, MARCHE67, ACTIVE, 2025-09-29 16:57:01), (?, ?, 2025-10-06 00:27:52, 2025-10-06 00:00:00, 2026-10-06 00:00:00, ?, ?, ?, 3, Acquisition d'un écran HP 532SF, 20000, 200000, 10, 144424, ACTIVE, 2025-10-06 00:27:52), (3, ?, 2025-10-06 01:47:53, 2025-10-06 00:00:00, 2026-10-06 00:00:00, ?, ?, ?, 4, Acquisition de matériel informatique, 6000, 60000, 10, 000542, ACTIVE, 2025-10-06 01:47:53), (17, ?, 2025-10-06 03:18:09, 2024-12-06 00:00:00, 2025-10-21 00:00:00, ?, ?, ?, 5, Aménagement de stades - Zone A, 41192678.3, 411926783, 10, MARCHE-0001-2025, ACTIVE, 2025-10-06 03:18:09), (13, ?, 2025-10-06 03:18:09, 2025-02-06 00:00:00, 2025-10-12 00:00:00, ?, ?, ?, 6, Travaux d'électrification - Secteur Sud, 68548371.75, 456989145, 15, MARCHE-0002-2025, ACTIVE, 2025-10-06 03:18:09), (9, ?, 2025-10-06 03:18:09, 2024-02-06 00:00:00, 2025-08-03 00:00:00, ?, ?, ?, 7, Fourniture de matériel informatique - Zone B, 26202781.5, 262027815, 10, MARCHE-0003-2025, EXPIRE, 2025-10-06 03:18:09), (14, ?, 2025-10-06 03:18:09, 2023-03-06 00:00:00, 2025-05-06 00:00:00, ?, ?, ?, 8, Travaux de voirie - Zone A, 10892263.65, 72615091, 15, MARCHE-0004-2025, LIBEREE, 2025-10-06 03:18:09), (15, ?, 2025-10-06 03:18:09, 2025-08-06 00:00:00, 2026-12-06 00:00:00, ?, ?, ?, 9, Travaux de voirie - Secteur Nord, 41184932.6, 411849326, 10, MARCHE-0005-2025, ACTIVE, 2025-10-06 03:18:09), (12, ?, 2025-10-06 03:18:09, 2025-03-06 00:00:00, 2025-10-28 00:00:00, ?, ?, ?, 10, Aménagement urbain - Secteur Sud, 5694906.2, 56949062, 10, MARCHE-0006-2025, ACTIVE, 2025-10-06 03:18:09), (11, ?, 2025-10-06 03:18:09, 2024-12-06 00:00:00, 2025-10-07 00:00:00, ?, ?, ?, 11, Réhabilitation d'écoles - Zone C, 24061737.45, 160411583, 15, MARCHE-0007-2025, ACTIVE, 2025-10-06 03:18:09), (13, ?, 2025-10-06 03:18:09, 2024-06-06 00:00:00, 2025-07-09 00:00:00, 2025-10-22 00:00:00, ?, ?, 12, Installation de panneaux solaires - Secteur Sud, 45976242.6, 229881213, 20, MARCHE-0008-2025, NON_RECOUVRE, 2025-10-22 00:41:03), (17, ?, 2025-10-06 03:18:09, 2023-05-06 00:00:00, 2025-05-06 00:00:00, ?, ?, ?, 13, Construction de route - Secteur Nord, 28461683.6, 284616836, 10, MARCHE-0009-2025, LIBEREE, 2025-10-06 03:18:09), (17, ?, 2025-10-06 03:18:09, 2025-08-06 00:00:00, 2027-01-06 00:00:00, ?, ?, ?, 14, Construction de route - Zone A, 22456082.7, 149707218, 15, MARCHE-0010-2025, ACTIVE, 2025-10-06 03:18:09), (13, ?, 2025-10-06 03:18:09, 2024-12-06 00:00:00, 2025-11-04 00:00:00, ?, ?, ?, 15, Aménagement urbain - Zone A, 4233221.8, 21166109, 20, MARCHE-0011-2025, ACTIVE, 2025-10-06 03:18:09), (13, ?, 2025-10-06 03:18:09, 2025-01-06 00:00:00, 2025-10-07 00:00:00, ?, ?, ?, 16, Construction de ponts - Zone A, 14968097.55, 99787317, 15, MARCHE-0012-2025, ACTIVE, 2025-10-06 03:18:09), (15, ?, 2025-10-06 03:18:09, 2023-10-06 00:00:00, 2025-07-27 00:00:00, ?, ?, ?, 17, Fourniture de mobilier de bureau - Secteur Sud, 10368160.75, 207363215, 5, MARCHE-0013-2025, EXPIRE, 2025-10-06 03:18:09), (15, ?, 2025-10-06 03:18:09, 2023-03-06 00:00:00, 2024-12-06 00:00:00, ?, ?, ?, 18, Aménagement urbain - Zone A, 3006822.8, 60136456, 5, MARCHE-0014-2025, LIBEREE, 2025-10-06 03:18:09), (11, ?, 2025-10-06 03:18:09, 2025-09-06 00:00:00, 2026-08-06 00:00:00, ?, ?, ?, 19, Construction de ponts - Zone B, 20263304.6, 202633046, 10, MARCHE-0015-2025, ACTIVE, 2025-10-06 03:18:09), (15, ?, 2025-10-06 03:18:09, 2025-04-06 00:00:00, 2025-11-04 00:00:00, ?, ?, ?, 20, Aménagement de stades - Zone A, 69307854.9, 462052366, 15, MARCHE-0016-2025, ACTIVE, 2025-10-06 03:18:09), (17, ?, 2025-10-06 03:18:11, 2024-10-06 00:00:00, 2025-10-13 00:00:00, ?, ?, ?, 21, Fourniture de mobilier de bureau - Zone B, 5684763.6, 28423818, 20, MARCHE-0017-2025, ACTIVE, 2025-10-06 03:18:11), (9, ?, 2025-10-06 03:18:11, 2024-10-06 00:00:00, 2025-09-08 00:00:00, ?, ?, ?, 22, Travaux de voirie - Zone A, 34278959.4, 342789594, 10, MARCHE-0018-2025, EXPIRE, 2025-10-06 03:18:11), (15, ?, 2025-10-06 03:18:11, 2024-03-06 00:00:00, 2025-01-06 00:00:00, ?, ?, ?, 23, Aménagement de stades - Secteur Sud, 44811374.4, 224056872, 20, MARCHE-0019-2025, LIBEREE, 2025-10-06 03:18:11), (12, ?, 2025-10-06 03:18:11, 2025-04-06 00:00:00, 2026-09-06 00:00:00, ?, ?, ?, 24, Installation de panneaux solaires - Zone C, 1659310.4, 33186208, 5, MARCHE-0020-2025, ACTIVE, 2025-10-06 03:18:11), (17, ?, 2025-10-06 03:18:12, 2025-04-06 00:00:00, 2025-10-17 00:00:00, ?, ?, ?, 25, Installation de panneaux solaires - Zone C, 5261725.25, 105234505, 5, MARCHE-0021-2025, ACTIVE, 2025-10-06 03:18:12), (12, ?, 2025-10-06 03:18:12, 2024-12-06 00:00:00, 2025-10-11 00:00:00, ?, ?, ?, 26, Travaux d'électrification - Secteur Nord, 5783858.2, 57838582, 10, MARCHE-0022-2025, ACTIVE, 2025-10-06 03:18:12), (14, ?, 2025-10-06 03:18:12, 2024-10-06 00:00:00, 2025-09-22 00:00:00, ?, ?, ?, 27, Aménagement urbain - Zone A, 2562000.1, 51240002, 5, MARCHE-0023-2025, EXPIRE, 2025-10-06 03:18:12), (17, ?, 2025-10-06 03:18:12, 2024-06-06 00:00:00, 2025-05-06 00:00:00, ?, ?, ?, 28, Travaux de voirie - Secteur Nord, 21235713.35, 424714267, 5, MARCHE-0024-2025, LIBEREE, 2025-10-06 03:18:12), (9, ?, 2025-10-06 03:18:12, 2025-01-06 00:00:00, 2025-10-18 00:00:00, ?, ?, ?, 30, Réhabilitation d'écoles - Zone B, 18110247.25, 362204945, 5, MARCHE-0026-2025, ACTIVE, 2025-10-06 03:18:12), (15, ?, 2025-10-06 03:18:12, 2024-12-06 00:00:00, 2025-10-07 00:00:00, 2025-10-20 00:00:00, ?, ?, 31, Aménagement de stades - Zone A, 12783937.05, 85226247, 15, MARCHE-0027-2025, LIBEREE, 2025-10-20 01:15:33), (14, ?, 2025-10-06 03:18:12, 2024-08-06 00:00:00, 2025-08-25 00:00:00, ?, ?, ?, 32, Construction de ponts - Secteur Sud, 21225100.95, 424502019, 5, MARCHE-0028-2025, EXPIRE, 2025-10-06 03:18:12), (13, ?, 2025-10-06 03:18:12, 2023-07-06 00:00:00, 2025-05-06 00:00:00, ?, ?, ?, 33, Travaux de voirie - Zone C, 39258100.8, 261720672, 15, MARCHE-0029-2025, LIBEREE, 2025-10-06 03:18:12), (11, ?, 2025-10-06 03:18:12, 2025-08-06 00:00:00, 2026-09-06 00:00:00, ?, ?, ?, 34, Construction d'hôpital - Zone A, 45304893, 302032620, 15, MARCHE-0030-2025, ACTIVE, 2025-10-06 03:18:12), (13, ?, 2025-10-06 03:18:12, 2025-02-06 00:00:00, 2025-10-31 00:00:00, ?, ?, ?, 35, Construction d'hôpital - Zone C, 41047658.55, 273651057, 15, MARCHE-0031-2025, ACTIVE, 2025-10-06 03:18:12), (9, ?, 2025-10-06 03:18:12, 2025-04-06 00:00:00, 2025-10-08 00:00:00, ?, ?, ?, 36, Aménagement urbain - Secteur Nord, 19729069.5, 394581390, 5, MARCHE-0032-2025, ACTIVE, 2025-10-06 03:18:12), (13, ?, 2025-10-06 03:18:12, 2024-07-06 00:00:00, 2025-09-09 00:00:00, ?, ?, ?, 37, Installation de panneaux solaires - Zone B, 62963253.15, 419755021, 15, MARCHE-0033-2025, EXPIRE, 2025-10-06 03:18:12), (15, ?, 2025-10-06 03:18:12, 2023-11-06 00:00:00, 2025-05-06 00:00:00, ?, ?, ?, 38, Construction d'hôpital - Secteur Nord, 22704704.7, 151364698, 15, MARCHE-0034-2025, LIBEREE, 2025-10-06 03:18:12), (17, ?, 2025-10-06 03:18:12, 2025-07-06 00:00:00, 2026-11-06 00:00:00, ?, ?, ?, 39, Construction de ponts - Secteur Nord, 15161922.6, 303238452, 5, MARCHE-0035-2025, ACTIVE, 2025-10-06 03:18:12), (14, ?, 2025-10-06 03:18:12, 2025-01-06 00:00:00, 2025-10-20 00:00:00, ?, ?, ?, 40, Réhabilitation d'écoles - Zone C, 19034467.4, 380689348, 5, MARCHE-0036-2025, ACTIVE, 2025-10-06 03:18:12), (13, ?, 2025-10-06 03:18:12, 2024-10-06 00:00:00, 2025-10-08 00:00:00, ?, ?, ?, 41, Travaux d'électrification - Zone A, 2817732.85, 56354657, 5, MARCHE-0037-2025, ACTIVE, 2025-10-06 03:18:12), (16, ?, 2025-10-06 03:18:12, 2023-12-06 00:00:00, 2025-09-25 00:00:00, ?, ?, ?, 42, Travaux de voirie - Zone C, 18911057.8, 189110578, 10, MARCHE-0038-2025, EXPIRE, 2025-10-06 03:18:12), (17, ?, 2025-10-06 03:18:12, 2024-02-06 00:00:00, 2025-02-06 00:00:00, ?, ?, ?, 43, Fourniture de mobilier de bureau - Secteur Nord, 26052770, 130263850, 20, MARCHE-0039-2025, LIBEREE, 2025-10-06 03:18:12), (16, ?, 2025-10-06 03:18:12, 2025-06-06 00:00:00, 2026-12-06 00:00:00, ?, ?, ?, 44, Fourniture de matériel informatique - Secteur Nord, 19011258.65, 380225173, 5, MARCHE-0040-2025, ACTIVE, 2025-10-06 03:18:12), (12, ?, 2025-10-06 03:18:13, 2024-12-06 00:00:00, 2025-10-14 00:00:00, ?, ?, ?, 45, Travaux de plomberie - Zone B, 39290624, 392906240, 10, MARCHE-0041-2025, ACTIVE, 2025-10-06 03:18:13), (12, ?, 2025-10-06 03:18:13, 2025-02-06 00:00:00, 2025-10-13 00:00:00, ?, ?, ?, 46, Travaux de voirie - Zone C, 9444352.1, 94443521, 10, MARCHE-0042-2025, ACTIVE, 2025-10-06 03:18:13), (13, ?, 2025-10-06 03:18:13, 2024-05-06 00:00:00, 2025-08-16 00:00:00, ?, ?, ?, 47, Construction d'hôpital - Zone B, 63864922.35, 425766149, 15, MARCHE-0043-2025, EXPIRE, 2025-10-06 03:18:13), (15, ?, 2025-10-06 03:18:13, 2024-06-06 00:00:00, 2024-10-06 00:00:00, ?, ?, ?, 48, Aménagement de stades - Secteur Sud, 17013391.5, 170133915, 10, MARCHE-0044-2025, LIBEREE, 2025-10-06 03:18:13), (11, ?, 2025-10-06 03:18:13, 2025-08-06 00:00:00, 2026-11-06 00:00:00, ?, ?, ?, 49, Travaux de plomberie - Zone A, 14019526.9, 140195269, 10, MARCHE-0045-2025, ACTIVE, 2025-10-06 03:18:13), (15, ?, 2025-10-06 03:18:13, 2025-04-06 00:00:00, 2025-10-28 00:00:00, 2025-10-28 00:00:00, ?, ?, 50, Installation de panneaux solaires - Zone C, 14065124.8, 281302496, 5, MARCHE-0046-2025, LIBEREE, 2025-10-28 10:44:31), (14, ?, 2025-10-06 03:18:13, 2025-02-06 00:00:00, 2025-10-07 00:00:00, ?, ?, ?, 51, Construction de route - Secteur Sud, 51527195, 257635975, 20, MARCHE-0047-2025, ACTIVE, 2025-10-06 03:18:13), (11, ?, 2025-10-06 03:18:13, 2024-01-06 00:00:00, 2025-09-28 00:00:00, ?, ?, ?, 52, Construction de ponts - Zone B, 1546593.5, 30931870, 5, MARCHE-0048-2025, EXPIRE, 2025-10-06 03:18:13), (17, ?, 2025-10-06 03:18:13, 2023-11-06 00:00:00, 2025-01-06 00:00:00, ?, ?, ?, 53, Construction d'hôpital - Zone B, 24772691.7, 247726917, 10, MARCHE-0049-2025, LIBEREE, 2025-10-06 03:18:13), (16, ?, 2025-10-06 03:18:13, 2025-05-06 00:00:00, 2026-07-06 00:00:00, ?, ?, ?, 54, Construction de ponts - Zone A, 2954842.1, 59096842, 5, MARCHE-0050-2025, ACTIVE, 2025-10-06 03:18:13), (3, ?, 2025-10-08 02:25:42, 2025-10-08 00:00:00, 2026-01-08 00:00:00, ?, garanties/1759890341_000543.pdf, ?, 55, Achat d'un ordinateur HP Core I9, 12000, 300000, 4, 000543, ACTIVE, 2025-10-08 02:25:42), (3, ?, 2025-10-08 12:46:15, 2024-09-01 00:00:00, 2025-09-01 00:00:00, ?, garanties/1759927575_10000395.pdf, ?, 56, Développement d'un logiciel de factures, 1000000, 10000000, 10, 10000395, ACTIVE, 2025-10-08 12:46:15), (3, ?, 2025-10-08 13:12:16, 2025-10-08 00:00:00, 2026-07-08 00:00:00, ?, garanties/1759929136_10000396.pdf, ?, 57, Achat de Téle Samsung, 30000, 300000, 10, 10000396, ACTIVE, 2025-10-08 13:12:16), (3, ?, 2025-10-08 13:28:21, 2025-10-08 00:00:00, 2026-10-08 00:00:00, ?, garanties/1759930101_10000397.pdf, ?, 58, Ordinateur ASUS GAMING, 1000000, 10000000, 10, 10000397, ACTIVE, 2025-10-08 13:28:21), (3, ?, 2025-10-08 15:55:33, 2025-10-08 00:00:00, 2026-10-08 00:00:00, ?, garanties/1759938933_70167445.pdf, ?, 59, Acquisition d'équipements informatiques pour la CNDH, 162500, 1625000, 10, 70167445, ACTIVE, 2025-10-08 15:55:33), (13, ?, 2025-10-16 14:43:16, 2025-10-16 00:00:00, 2026-10-16 00:00:00, ?, garanties/1760625795_70188130.pdf, ?, 60, Acquisition de matériels informatique pour PROJET CERF, 312750, 6255000, 5, 70188130, ACTIVE, 2025-10-16 14:43:16), (3, ?, 2025-10-20 11:35:55, 2024-10-27 00:00:00, 2025-10-27 00:00:00, ?, garanties/1760960154_REF-808080.pdf, ?, 61, Aquisition de marchandise, 50000, 1000000, 5, REF-808080, ACTIVE, 2025-10-20 11:38:30), (3, ?, 2025-10-20 15:34:56, 2025-10-20 00:00:00, 2026-10-20 00:00:00, ?, garanties/1760974495_145203.pdf, ?, 62, Achat de matériels informatiques, 81250, 1625000, 5, 145203, ACTIVE, 2025-10-20 15:34:56), (3, ?, 2025-10-21 14:19:35, 2025-10-21 00:00:00, 2026-10-21 00:00:00, ?, garanties/1761056373_143881.pdf, ?, 63, Acquisition de Jabra Speak 710 MS, 32250, 645000, 5, 143881, ACTIVE, 2025-10-21 14:19:35), (3, ?, 2025-10-21 19:49:14, 2025-10-26 00:00:00, 2026-10-26 00:00:00, ?, garanties/1761076149_REF-00001.pdf, ?, 64, Acquisition de matériels informatique pour LORATECH, 5000, 100000, 5, REF-00001, ACTIVE, 2025-10-21 19:49:14), (3, ?, 2025-10-23 16:48:15, 2025-10-23 00:00:00, 2026-10-23 00:00:00, ?, garanties/1761238094_OK-BON-02.pdf, ?, 65, Facture de test pour les paiement partielles avec GBE, 10000, 100000, 10, OK-BON-02, ACTIVE, 2025-10-23 16:48:15), (3, ?, 2025-10-23 23:06:51, 2025-10-23 00:00:00, 2026-10-23 00:00:00, ?, ?, ?, 66, facture de test de des vue de paiment parielles, 500000, 10000000, 5, OK-BON-03, ACTIVE, 2025-10-23 23:06:51), (3, ?, 2025-11-05 14:16:37, 2025-11-05 00:00:00, 2026-11-05 00:00:00, ?, ?, ?, 67, Acquisition de matériels informatique au profit du département centre des métiers de l'électricité, 310500, 6210000, 5, 1012/C0AD0000/25, ACTIVE, 2025-11-05 14:16:37), (9, ?, 2025-11-05 15:45:25, 2025-11-05 00:00:00, 2026-11-05 00:00:00, ?, ?, ?, 68, Achat d'un disque externe HDD 1 TB, 2000, 40000, 5, ESB/2025/00031, ACTIVE, 2025-11-05 15:45:25), (3, ?, 2025-11-08 08:29:44, 2025-11-08 00:00:00, 2026-11-08 00:00:00, ?, ?, ?, 69, Acquisition de matériels informatiques, 56250, 1125000, 5, BCE-BFA-01014-001, ACTIVE, 2025-11-08 08:29:44), (3, ?, 2025-11-08 13:42:20, 2025-11-09 00:00:00, 2026-11-09 00:00:00, ?, ?, ?, 70, Acquisition de câble HDMI, 6250, 125000, 5, 145633, ACTIVE, 2025-11-08 13:42:20)) 📦 Migration de 'type_paiements' (5 lignes)... ⚠️ Erreur sur 'type_paiements': SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'type_paiements.PRIMARY' (Connection: mysql, SQL: insert into `type_paiements` (`created_at`, `description`, `id`, `libelle`, `updated_at`) values (2025-08-29 14:39:50, Paiement par virement bancaire, 1, Virement bancaire, 2025-08-29 14:39:50), (2025-08-29 14:39:50, Paiement par chèque, 2, Chèque, 2025-08-29 14:39:50), (2025-08-29 14:39:50, Paiement en espèces, 3, Espèces, 2025-08-29 14:39:50), (2025-08-29 14:39:51, Paiement par carte bancaire, 4, Carte bancaire, 2025-08-29 14:39:51), (2025-08-29 14:39:51, Paiement par mobile money, 5, Mobile Money, 2025-08-29 14:39:51)) 📦 Migration de 'type_retenues' (4 lignes)... ⚠️ Erreur sur 'type_retenues': SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'type_retenues.PRIMARY' (Connection: mysql, SQL: insert into `type_retenues` (`base_application`, `created_at`, `description`, `id`, `libelle`, `taux`, `updated_at`) values (HT, 2025-08-29 14:39:51, Retenue de garantie pour bonne exécution, 1, Retenue de garantie, 10, 2025-08-29 14:39:51), (HT, 2025-08-29 14:39:51, Retenue à la source pour impôts, 2, Retenue fiscale, 5, 2025-08-29 14:39:51), (TVA, 2025-08-29 14:39:51, Retenue sur la TVA, 3, Retenue TVA, 18, 2025-08-29 14:39:51), (TTC, 2025-08-29 14:39:51, Avance versée au démarrage du marché, 4, Avance sur marché, 20, 2025-08-29 14:39:51)) 📦 Migration de 'modes_paiement' (4 lignes)... ⚠️ Erreur sur 'modes_paiement': SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'modes_paiement.PRIMARY' (Connection: mysql, SQL: insert into `modes_paiement` (`actif`, `created_at`, `id`, `nom`, `updated_at`) values (1, 2025-10-07 23:52:45, 1, Virement, 2025-10-07 23:52:45), (1, 2025-10-07 23:52:45, 2, Chèque, 2025-10-07 23:52:45), (1, 2025-11-13 01:47:18, 3, Espèces, 2025-11-13 01:47:18), (1, 2025-11-13 01:47:53, 4, Mobile Money, 2025-11-13 01:47:53)) 📦 Migration de 'facture_clients' (130 lignes)... ⚠️ Erreur sur 'facture_clients': SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`esoftbursuivifac`.`facture_clients`, CONSTRAINT `facture_clients_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE SET NULL) (Connection: mysql, SQL: insert into `facture_clients` (`client_id`, `created_at`, `date_depot`, `date_echeance`, `date_etablissement`, `est_sous_gbe`, `id`, `id_gbe`, `intitule`, `montant_ht`, `montant_ttc`, `montant_tva`, `num_bon_commande`, `odoo_client_id`, `odoo_id`, `reference`, `source_odoo`, `statut`, `updated_at`) values (1, 2025-08-29 14:39:51, 2025-06-24 14:39:51, 2025-08-01 14:39:51, 2025-07-08 14:39:51, 0, 1, ?, Fourniture et installation équipements, 850000, 1003000, 153000, BC-2024-833, ?, ?, FAC-001-001, 0, PAYE_COMPLET, 2025-10-24 01:02:50), (1, 2025-08-29 14:39:51, 2025-08-08 14:39:51, 2025-09-18 14:39:51, 2025-08-14 14:39:51, 0, 2, ?, Services de maintenance, 450000, 531000, 81000, BC-2024-980, ?, ?, FAC-001-002, 0, PAYER_PARTIEL, 2025-08-29 14:39:51), (2, 2025-08-29 14:39:51, 2025-06-14 14:39:51, 2025-08-09 14:39:51, 2025-06-10 14:39:51, 0, 3, ?, Fourniture et installation équipements, 850000, 1003000, 153000, BC-2024-238, ?, ?, FAC-002-001, 0, PAYE_COMPLET, 2025-10-08 11:56:46), (2, 2025-08-29 14:39:51, 2025-08-13 14:39:51, 2025-09-15 14:39:51, 2025-07-24 14:39:51, 0, 4, ?, Services de maintenance, 450000, 531000, 81000, BC-2024-257, ?, ?, FAC-002-002, 0, PAYER_PARTIEL, 2025-08-29 14:39:51), (3, 2025-08-29 14:39:51, 2025-06-15 14:39:51, 2025-08-10 14:39:51, 2025-07-04 14:39:51, 0, 5, ?, Fourniture et installation équipements, 850000, 1003000, 153000, BC-2024-531, ?, ?, FAC-003-001, 0, PAYE_COMPLET, 2025-10-24 00:57:23), (3, 2025-08-29 14:39:51, 2025-07-31 14:39:51, 2025-09-21 14:39:51, 2025-07-18 14:39:51, 0, 6, ?, Services de maintenance, 450000, 531000, 81000, BC-2024-913, ?, ?, FAC-003-002, 0, PAYE_COMPLET, 2025-10-24 00:57:23), (4, 2025-08-29 22:56:04, ?, 2025-08-07 00:00:00, 2025-08-07 00:00:00, 0, 7, ?, Test facture depuis Odoo, 100, 118, 18, ?, ?, ?, TEST-INV-1756508164, 0, PAYER_PARTIEL, 2025-10-28 10:59:51), (4, 2025-08-29 23:03:21, ?, 2025-08-07 00:00:00, 2025-08-07 00:00:00, 0, 8, ?, Facture importée depuis Odoo, 100, 118, 18, ?, ?, ?, FINAL-TEST-1756508601, 0, PAYER_PARTIEL, 2025-10-28 10:59:51), (4, 2025-08-31 02:26:21, 2025-08-31 00:00:00, 2025-09-30 00:00:00, 2025-08-31 00:00:00, 0, 9, ?, Facture de test avec tous les champs, 100, 118, 18, BC-2025-001, ?, ?, TEST-COMPLET-1756607181, 0, PAYER_PARTIEL, 2025-10-28 10:59:51), (11, 2025-08-31 03:04:38, ?, 2025-09-28 00:00:00, 2025-08-29 00:00:00, 0, 10, ?, Achat de marchandises, 19000, 22420, 3420, ?, ?, ?, INV/2025/00002, 0, DEPOSEE, 2025-08-31 03:04:38), (1, 2025-08-31 03:13:22, 2025-08-01 00:00:00, 2025-08-31 00:00:00, 2025-08-01 00:00:00, 0, 11, ?, Facture de test existante, 1000, 1200, 200, ?, ?, ?, INV/2025/00001, 0, PAYE_COMPLET, 2025-10-24 01:02:50), (92, 2025-10-03 04:40:44, 2025-10-03 00:00:00, 2025-01-28 00:00:00, 2025-01-28 00:00:00, 0, 12, ?, Acquisition d'un onduleur APC 5 KVA, 3950000, 4661000, 711000, 10000395, ?, ?, ESB/2025/00003, 0, PAYE_COMPLET, 2025-10-24 00:55:49), (92, 2025-10-03 05:15:46, ?, 2025-02-03 00:00:00, 2025-02-03 00:00:00, 0, 13, ?, Acquisition de téléphone Samsung A24, 150000, 177000, 27000, 10001065, ?, ?, ESB/2025/00007, 0, PAYE_COMPLET, 2025-10-24 00:55:49), (62, 2025-10-03 05:24:13, ?, 2025-06-05 00:00:00, 2025-06-05 00:00:00, 0, 14, ?, Achat de matériel informatique, 800000, 944000, 144000, ESB202504230, ?, ?, ESB/2025/00030, 0, PAYE_COMPLET, 2025-10-24 01:15:20), (92, 2025-10-05 23:59:25, 2025-10-05 00:00:00, 2025-08-08 00:00:00, 2025-08-08 00:00:00, 0, 15, ?, Acquisition de téléphone Samsung, 180000, 212400, 32400, 10002487, ?, ?, ESB/2025/00054, 0, PAYE_COMPLET, 2025-10-23 17:04:09), (102, 2025-10-06 00:27:52, 2025-10-06 00:00:00, 2025-09-09 00:00:00, 2025-09-09 00:00:00, 0, 16, 3, Acquisition d'un écran HP 532SF, 200000, 236000, 36000, 144424, ?, ?, ESB/2025/00060, 0, PAYER_SOUS_GBE, 2025-10-23 13:35:34), (101, 2025-10-06 01:47:53, 2025-10-06 00:00:00, 2025-11-05 00:00:00, 2025-10-06 00:00:00, 0, 17, 4, Acquisition de matériel informatique, 60000, 70800, 10800, 000542, ?, ?, TEST/2025/00002, 0, PAYER_SOUS_GBE, 2025-10-20 16:14:46), (7, 2025-10-08 02:25:42, 2025-10-08 00:00:00, 2025-11-07 00:00:00, 2025-10-08 00:00:00, 0, 18, 55, Achat d'un ordinateur HP Core I9, 300000, 354000, 54000, 000543, ?, ?, TEST/2025/00003, 0, PAYER_SOUS_GBE, 2025-10-24 01:34:50), (7, 2025-10-08 12:46:15, 2025-10-08 00:00:00, 2025-11-07 00:00:00, 2025-10-08 00:00:00, 0, 19, 56, Développement d'un logiciel de factures, 10000000, 11800000, 1800000, 10000395, ?, ?, TEST/2025/00004, 0, PAYE_COMPLET, 2025-10-08 13:01:08), (7, 2025-10-08 13:12:16, 2025-10-08 00:00:00, 2025-11-07 00:00:00, 2025-10-08 00:00:00, 0, 20, 57, Achat de Téle Samsung, 300000, 354000, 54000, 10000396, ?, ?, TEST/2025/00005, 0, PAYER_SOUS_GBE, 2025-10-24 01:34:50), (7, 2025-10-08 13:28:21, 2025-10-08 00:00:00, 2025-11-07 00:00:00, 2025-10-08 00:00:00, 0, 21, 58, Ordinateur ASUS GAMING, 10000000, 11800000, 1800000, 10000397, ?, ?, TEST/2025/00006, 0, PAYER_SOUS_GBE, 2025-10-08 13:29:29), (7, 2025-10-23 16:39:49, 2025-10-23 00:00:00, 2025-11-22 00:00:00, 2025-10-22 00:00:00, 0, 26, ?, Facture de test pour les paiment partielles sans gbe, 100000, 118000, 18000, OK-BON-01, ?, ?, OK-REF-01, 0, PAYE_COMPLET, 2025-10-23 16:42:00), (7, 2025-10-23 16:48:16, 2025-10-23 00:00:00, 2025-11-22 00:00:00, 2025-10-21 00:00:00, 0, 27, 65, Facture de test pour les paiement partielles avec GBE, 100000, 118000, 18000, OK-BON-02, ?, ?, OK-REF-02, 0, PAYER_SOUS_GBE, 2025-10-23 16:50:41), (7, 2025-10-23 23:06:51, 2025-10-23 00:00:00, 2025-11-22 00:00:00, 2025-10-23 00:00:00, 0, 28, 66, facture de test de des vue de paiment parielles, 10000000, 11800000, 1800000, OK-BON-03, ?, ?, OK-REF-03, 0, PAYER_SOUS_GBE, 2025-10-24 01:34:50), (22, 2025-10-27 20:41:29, ?, 2025-11-26 20:41:29, 2025-10-27 20:41:29, 0, 29, ?, Test de synchronisation BC, 1000000, 1180000, 180000, BC202500001, ?, ?, TEST-BC-SYNC-001, 0, PAYE_COMPLET, 2025-10-27 20:41:53), (7, 2025-10-27 22:20:20, 2025-10-27 00:00:00, 2025-11-26 00:00:00, 2025-10-27 00:00:00, 0, 30, ?, j'ai oublier , l'intilulé, 100000, 118000, 18000, BC202500051, ?, ?, Test/2025/00051, 0, PAYE_COMPLET, 2025-10-27 22:21:42), (103, 2025-10-27 22:34:47, 2025-10-27 00:00:00, 2025-11-26 00:00:00, 2025-10-27 00:00:00, 0, 31, ?, achat de 4*4, 100000, 118000, 18000, BC202500052, ?, ?, TEST/2025/00052, 0, PAYE_COMPLET, 2025-10-27 22:35:11), (53, 2025-10-28 10:56:49, 2025-10-28 00:00:00, 2025-11-27 00:00:00, 2025-10-27 00:00:00, 0, 32, ?, Acquisition de ventilateur de lenovo ThinkPad X1, 85000, 100300, 15300, ESB/2025/00072, ?, ?, ESB/2025/00072, 0, PAYE_COMPLET, 2025-10-28 11:07:20), (25, 2025-10-28 11:23:16, 2025-10-28 00:00:00, 2025-11-27 00:00:00, 2025-10-28 00:00:00, 0, 33, ?, achat, 250000, 295000, 45000, BC202500053, ?, ?, TEST/2025/000001, 0, PAYE_COMPLET, 2025-10-28 11:26:04), (7, 2025-10-31 15:44:04, 2025-10-31 00:00:00, 2025-11-30 00:00:00, 2025-10-31 00:00:00, 0, 34, ?, 01, 100, 118, 18, 01, ?, ?, 01, 0, PAYER_PARTIEL, 2025-10-31 15:50:18), (10, 2025-10-31 16:00:22, 2025-10-31 00:00:00, 2025-11-30 00:00:00, 2025-10-31 00:00:00, 0, 35, 64, 02, 100000, 118000, 18000, 02, ?, ?, 02, 0, PAYER_SOUS_GBE, 2025-10-31 16:04:10), (7, 2025-10-31 16:18:18, 2025-10-31 00:00:00, 2025-11-30 00:00:00, 2025-10-31 00:00:00, 0, 36, ?, 03, 100000, 118000, 18000, 03, ?, ?, 03, 0, DEPOSEE, 2025-10-31 16:18:18), (106, 2025-11-05 11:07:08, 2025-11-05 00:00:00, 2025-12-05 00:00:00, 2025-09-12 00:00:00, 0, 37, ?, Acquisition de cartouches d'encre, 690000, 814200, 124200, WFP/BFCO/2025/4400377824, ?, ?, ESB/2025/00062, 0, PAYE_COMPLET, 2025-11-05 12:38:35), (13, 2025-11-05 13:03:44, 2025-11-05 00:00:00, 2025-09-12 00:00:00, 2025-09-12 00:00:00, 0, 39, ?, Fourniture d'un objectif d'appareil de photo, 1575000, 1858500, 283500, Contrat N° SAM-2025-149, ?, ?, ESB/2025/00063, 0, PAYER_PARTIEL, 2025-11-05 13:05:57), (76, 2025-11-05 13:21:05, 2025-11-05 00:00:00, 2025-09-13 00:00:00, 2025-09-13 00:00:00, 0, 40, ?, Acquisition d'un onduleur central au profit de la Direction Générale des Ressources en Eau ( DGRE), 16250000, 19175000, 2925000, MARCHE N°32/00/01/04/80/2024/00032, ?, ?, ESB/2025/00064, 0, PAYER_PARTIEL, 2025-11-05 13:22:37), (25, 2025-11-05 13:32:38, 2025-11-05 00:00:00, 2025-09-16 00:00:00, 2025-09-16 00:00:00, 0, 41, ?, Achat de matériels informatique, 3950000, 4661000, 711000, ESB/2025/00065, ?, ?, ESB/2025/00065, 0, PAYER_PARTIEL, 2025-11-05 13:34:55), (100, 2025-11-05 13:38:09, 2025-11-05 00:00:00, 2025-09-22 00:00:00, 2025-09-22 00:00:00, 0, 42, ?, Recrutement d’un cabinet en vue de la conception d’une plateforme de suivi du Plan de Travail Annuel (PTA), 3812400, 4498632, 686232, MARCHE N°EPE-INSD-PHASAO/00/01/04/80/2025/00019, ?, ?, ESB/2025/00066, 0, PAYER_PARTIEL, 2025-11-05 13:39:05), (102, 2025-11-05 13:43:00, 2025-11-05 00:00:00, 2025-09-24 00:00:00, 2025-09-24 00:00:00, 0, 43, ?, Acquisition de Samsung Galaxy A35 et A16, 945000, 1115100, 170100, 145090, ?, ?, ESB/2025/00067, 0, PAYER_PARTIEL, 2025-11-05 14:00:15), (103, 2025-11-05 14:10:36, 2025-11-05 00:00:00, 2025-10-02 00:00:00, 2025-10-02 00:00:00, 0, 44, ?, Acquisition de matériels informatique pour le bureau Burkina, 6950000, 8201000, 1251000, 70194426, ?, ?, ESB/2025/00068, 0, DEPOSEE, 2025-11-05 14:10:36), (107, 2025-11-05 14:16:37, 2025-11-05 00:00:00, 2025-10-02 00:00:00, 2025-10-02 00:00:00, 0, 45, 67, Acquisition de matériels informatique au profit du département centre des métiers de l'électricité, 6210000, 7327800, 1117800, 1012/C0AD0000/25, ?, ?, ESB/2025/00069, 0, PAYER_SOUS_GBE, 2025-11-05 14:19:05), (45, 2025-11-05 22:54:35, ?, 2025-10-03 00:00:00, 2025-10-03 00:00:00, 0, 49, ?, Offre d'Herbergement +mail er nom domaine, 100000, 118000, 18000, ESB/2025/00070, ?, 119, ESB/2025/00070, 1, NON_SUIVIE, 2025-11-05 22:54:35), (102, 2025-11-05 22:54:35, ?, 2025-09-08 00:00:00, 2025-09-08 00:00:00, 0, 50, ?, Acquisition de HP EliteOne 840 G9, 900000, 1062000, 162000, 144654, ?, 108, ESB/2025/00059, 1, NON_SUIVIE, 2025-11-05 22:54:35), (93, 2025-11-05 22:54:35, ?, 2025-09-08 00:00:00, 2025-09-08 00:00:00, 0, 51, ?, Acquisition de Samsung Galaxy A26 et A16, 660000, 778800, 118800, 10002391, ?, 107, ESB/2025/00058, 1, NON_SUIVIE, 2025-11-05 22:54:35), (25, 2025-11-05 22:54:35, ?, 2025-08-19 00:00:00, 2025-08-19 00:00:00, 0, 52, ?, Achat de matériel informatique, 3700000, 4366000, 666000, ESB/2025/00057, ?, 106, ESB/2025/00057, 1, NON_SUIVIE, 2025-11-05 22:54:35), (51, 2025-11-05 22:54:35, ?, 2025-08-12 00:00:00, 2025-08-12 00:00:00, 0, 53, ?, Acquisition d'un logiciel d'édition en mathématiques au profit du CENAMAFS, 2000000, 2360000, 360000, MARCHE PUBLIC N°EPE-CENAMAFS/00/01/04/00/2025/00032, ?, 104, ESB/2025/00055, 1, NON_SUIVIE, 2025-11-05 22:54:35), (70, 2025-11-05 22:54:35, ?, 2025-08-08 00:00:00, 2025-08-08 00:00:00, 0, 54, ?, Acquisition de rames de papier A4, 75000, 88500, 13500, ESB/2025/00052, ?, 101, ESB/2025/00052, 1, NON_SUIVIE, 2025-11-05 22:54:35), (53, 2025-11-05 22:54:35, ?, 2025-08-08 00:00:00, 2025-08-08 00:00:00, 0, 55, ?, Acquisition de batterie d'ordinateur LENOVO, 75000, 88500, 13500, ESB/2025/00053, ?, 102, ESB/2025/00053, 1, NON_SUIVIE, 2025-11-05 22:54:35), (70, 2025-11-05 22:54:35, ?, 2025-07-29 00:00:00, 2025-07-29 00:00:00, 0, 56, ?, Acquisition de rames de papier A4, 75000, 88500, 13500, ESB/2025/00050, ?, 99, ESB/2025/00050, 1, NON_SUIVIE, 2025-11-05 22:54:35), (32, 2025-11-05 22:54:35, ?, 2025-07-24 00:00:00, 2025-07-24 00:00:00, 0, 57, ?, Acquisition d'un ordinateur HP PROBOOK, 450000, 531000, 81000, ESB/2025/00049, ?, 98, ESB/2025/00049, 1, NON_SUIVIE, 2025-11-05 22:54:35), (102, 2025-11-05 22:54:36, ?, 2025-07-22 00:00:00, 2025-07-22 00:00:00, 0, 58, ?, Acquisition de consommables informatiques, 350000, 413000, 63000, 142115, ?, 97, ESB/2025/00048, 1, NON_SUIVIE, 2025-11-05 22:54:36), (13, 2025-11-05 22:54:36, ?, 2025-07-21 00:00:00, 2025-07-21 00:00:00, 0, 59, ?, Acquisition de consommables pour la rentrée de septembre 2025 lot1, 437500, 516250, 78750, N°MAG_2025-342, ?, 95, ESB/2025/00045, 1, NON_SUIVIE, 2025-11-05 22:54:36), (25, 2025-11-05 22:54:36, ?, 2025-07-21 00:00:00, 2025-07-21 00:00:00, 0, 60, ?, Acquisition d'un ordinateur HP VICTUS 16, 850000, 1003000, 153000, ESB/2025/00047, ?, 93, ESB/2025/00047, 1, NON_SUIVIE, 2025-11-05 22:54:36), (13, 2025-11-05 22:54:36, ?, 2025-07-21 00:00:00, 2025-07-21 00:00:00, 0, 61, ?, Acquisition de consommables pour la rentrée de septembre 20225 lot2, 437500, 516250, 78750, N°MAG_2025-341, ?, 96, ESB/2025/00046, 1, NON_SUIVIE, 2025-11-05 22:54:36), (13, 2025-11-05 22:54:36, ?, 2025-07-21 00:00:00, 2025-07-21 00:00:00, 0, 62, ?, Acquisition de consommables pour la rentrée de septembre 2025 lot3, 437500, 516250, 78750, N°MAG_2025-340, ?, 94, ESB/2025/00044, 1, NON_SUIVIE, 2025-11-05 22:54:36), (107, 2025-11-05 22:54:36, ?, 2025-07-17 00:00:00, 2025-07-17 00:00:00, 0, 63, ?, Acquisition de disque dur et écrans d'ordinateur, 830000, 979400, 149400, N°1392/CCC00001/25, ?, 92, ESB/2025/00043, 1, NON_SUIVIE, 2025-11-05 22:54:36), (102, 2025-11-05 22:54:36, ?, 2025-07-14 00:00:00, 2025-07-14 00:00:00, 0, 64, ?, Acquisition de téléphone Samsung, 160000, 188800, 28800, 143815, ?, 91, ESB/2025/00042, 1, NON_SUIVIE, 2025-11-05 22:54:36), (25, 2025-11-05 22:54:36, ?, 2025-07-14 00:00:00, 2025-07-14 00:00:00, 0, 65, ?, Acquisition de matériels informatiques, 3450000, 4071000, 621000, ESB/2025/00040, ?, 89, ESB/2025/00040, 1, NON_SUIVIE, 2025-11-05 22:54:36), (107, 2025-11-05 22:54:36, ?, 2025-07-02 00:00:00, 2025-07-02 00:00:00, 0, 67, ?, Acquisition de consommables informatiques, 815000, 961700, 146700, N°1219/CCC00001/25, ?, 88, ESB/2025/00039, 1, NON_SUIVIE, 2025-11-05 22:54:36), (14, 2025-11-05 22:54:37, ?, 2025-06-30 00:00:00, 2025-06-30 00:00:00, 0, 68, ?, Acquisition de matériels informatique et audiovisuels, 6900000, 8142000, 1242000, N°SAM-2025-088/Marché N°2025/007/DSI-LuxDev/AF, ?, 87, ESB/2025/00038, 1, NON_SUIVIE, 2025-11-05 22:54:37), (13, 2025-11-05 22:54:37, ?, 2025-06-30 00:00:00, 2025-06-30 00:00:00, 0, 69, ?, Acquisition des ordinateurs de bureau, 20000000, 23600000, 3600000, N°SAM-2025-069/Marché N°2025/006/DSI-2iE/AF, ?, 86, ESB/2025/00037, 1, NON_SUIVIE, 2025-11-05 22:54:37), (110, 2025-11-05 22:54:37, ?, 2025-06-23 00:00:00, 2025-06-23 00:00:00, 0, 70, ?, Acquisition de consommables informatiques, 2508000, 2959440, 451440, PONC102501333, ?, 85, ESB/2025/00036, 1, NON_SUIVIE, 2025-11-05 22:54:37), (93, 2025-11-05 22:54:37, ?, 2025-06-16 00:00:00, 2025-06-16 00:00:00, 0, 71, ?, Achat de téléphone portable Samsung, 90000, 106200, 16200, 10002021, ?, 82, ESB/2025/00033, 1, NON_SUIVIE, 2025-11-05 22:54:37), (86, 2025-11-05 22:54:37, ?, 0, 2025-06-16 00:00:00, 0, 72, ?, Conception de Site Web et prestations de services connexes dans le cadre de RESI-2P, 4350000, 5133000, 783000, MARCHE N°27/00/01/04/99/2024/00047, ?, 84, ESB/2025/00035, 1, NON_SUIVIE, 2025-11-05 22:54:37), (93, 2025-11-05 22:54:37, ?, 2025-06-16 00:00:00, 2025-06-16 00:00:00, 0, 73, ?, Achat de téléphone Samsung A06, 90000, 106200, 16200, 10002110, ?, 81, ESB/2025/00032, 1, NON_SUIVIE, 2025-11-05 22:54:37), (102, 2025-11-05 22:54:37, ?, 2025-06-02 00:00:00, 2025-06-02 00:00:00, 0, 74, ?, Achat de cartouches de batterie APCRBC152, 5850000, 6903000, 1053000, 142171, ?, 76, ESB/2025/00027, 1, NON_SUIVIE, 2025-11-05 22:54:37), (8, 2025-11-05 22:54:37, ?, 2025-06-02 00:00:00, 2025-06-02 00:00:00, 0, 75, ?, Achat d'équipements informatiques pour le bureau UNFPA affecté à Tago Emmanuel, 1040000, 1227200, 187200, 70180305, ?, 78, ESB/2025/00029, 1, NON_SUIVIE, 2025-11-05 22:54:37), (102, 2025-11-05 22:54:37, ?, 2025-06-02 00:00:00, 2025-06-02 00:00:00, 0, 76, ?, Achat d'écran HP, 400000, 472000, 72000, 143141, ?, 77, ESB/2025/00028, 1, NON_SUIVIE, 2025-11-05 22:54:37), (107, 2025-11-05 22:54:37, ?, 2025-05-26 00:00:00, 2025-05-26 00:00:00, 0, 77, ?, Acquisition de matériels informatiques, 840000, 991200, 151200, N°1445/CCC00001/25, ?, 75, ESB/2025/00026, 1, NON_SUIVIE, 2025-11-05 22:54:37), (107, 2025-11-05 22:54:38, ?, 2025-05-26 00:00:00, 2025-05-26 00:00:00, 0, 78, ?, Acquisition d'une imprimante et disque dur, 825000, 973500, 148500, N°1400/CCC00001/25, ?, 74, ESB/2025/00025, 1, NON_SUIVIE, 2025-11-05 22:54:38), (93, 2025-11-05 22:54:38, ?, 2025-05-14 00:00:00, 2025-05-14 00:00:00, 0, 79, ?, Acquisition de batterie pour HP Probook, 50000, 59000, 9000, 10001840, ?, 73, ESB/2025/00024, 1, NON_SUIVIE, 2025-11-05 22:54:38), (78, 2025-11-05 22:54:38, ?, 2025-05-05 00:00:00, 2025-05-05 00:00:00, 0, 80, ?, Acquisition et installation d'équipements de mise en place d'un réseau informatique et téléphonique, 38028000, 44873040, 6845040, Marché N°30/00/01/04/80/2025/00006 DU 23/01/2025, ?, 72, ESB/2025/00023, 1, NON_SUIVIE, 2025-11-05 22:54:38), (102, 2025-11-05 22:54:38, ?, 2025-04-30 00:00:00, 2025-04-30 00:00:00, 0, 81, ?, Acquisition de matériels informatiques, 4150000, 4897000, 747000, 142520, ?, 71, ESB/2025/00022, 1, NON_SUIVIE, 2025-11-05 22:54:38), (32, 2025-11-05 22:54:38, ?, 2025-04-17 00:00:00, 2025-04-17 00:00:00, 0, 83, ?, Acquisition d'un ordinateur portable et de bureau, 875000, 1032500, 157500, N°007/2025/AMUS/PAFA-4R, ?, 68, ESB/2025/00019, 1, NON_SUIVIE, 2025-11-05 22:54:38), (53, 2025-11-05 22:54:38, ?, 2025-04-16 00:00:00, 2025-04-16 00:00:00, 0, 84, ?, Achat de batterie pour lenovo Thinkpad X1 7 th Génération, 50000, 59000, 9000, ESB/2025/00018, ?, 67, ESB/2025/00018, 1, NON_SUIVIE, 2025-11-05 22:54:38), (93, 2025-11-05 22:54:38, ?, 2025-04-15 00:00:00, 2025-04-15 00:00:00, 0, 85, ?, Achat de Headphone Stereo USB, 440000, 519200, 79200, 10001647, ?, 66, ESB/2025/00017, 1, NON_SUIVIE, 2025-11-05 22:54:38), (107, 2025-11-05 22:54:38, ?, 2025-04-08 00:00:00, 2025-04-08 00:00:00, 0, 86, ?, Acquisition de huit (08) ordinateurs portable hybride microsoft surface pro9, 11880000, 14018400, 2138400, 0045/CCC00001/25, ?, 64, ESB/2025/00015, 1, NON_SUIVIE, 2025-11-05 22:54:38), (107, 2025-11-05 22:54:38, ?, 2025-04-08 00:00:00, 2025-04-08 00:00:00, 0, 87, ?, Achat de barrettes mémoire SDRAM DDR42666, 350000, 413000, 63000, 0318/JB040001/25, ?, 65, ESB/2025/00016, 1, NON_SUIVIE, 2025-11-05 22:54:38), (85, 2025-11-05 22:54:38, ?, 2025-04-07 00:00:00, 2025-04-07 00:00:00, 0, 88, ?, Conception d'une plateforme intégrée d'éducation financière au profit du secrétariat technique pour la promotion de l'inclusion financière (ST-PIF), 33677347, 39739269, 6061922, Contrat n° 14/00/02/07/80/2024/00076, ?, 63, ESB/2025/00014, 1, NON_SUIVIE, 2025-11-05 22:54:38), (77, 2025-11-05 22:54:38, ?, 2025-03-25 00:00:00, 2025-03-25 00:00:00, 0, 89, ?, Acquisition d'un onduleur central au profit de la DGRE, 16250000, 19175000, 2925000, MARCHE N°32/00/01/04/80/2024/00032, ?, 62, ESB/2025/00013, 1, NON_SUIVIE, 2025-11-05 22:54:38), (93, 2025-11-05 22:54:38, ?, 2025-03-11 00:00:00, 2025-03-20 00:00:00, 0, 90, ?, Acquisition d'un ordinateur HP zBOOK PowerG11, 2100000, 2478000, 378000, 10001139, ?, 61, ESB/2025/00012, 1, NON_SUIVIE, 2025-11-05 22:54:38), (88, 2025-11-05 22:54:38, ?, 2025-02-27 00:00:00, 2025-02-27 00:00:00, 0, 91, ?, ESB/2025/00010, 0, 0, 0, ESB/2025/00010, ?, 60, ESB/2025/00010, 1, NON_SUIVIE, 2025-11-05 22:54:38), (62, 2025-11-05 22:54:39, ?, 2025-02-11 00:00:00, 2025-02-11 00:00:00, 0, 92, ?, 0, 185000, 218300, 33300, 0, ?, 58, 0, 1, NON_SUIVIE, 2025-11-05 22:54:39), (102, 2025-11-05 22:54:39, ?, 2025-02-03 00:00:00, 2025-02-03 00:00:00, 0, 93, ?, Acquisition de jabra speak 710, 250000, 295000, 45000, 137393, ?, 54, ESB/2025/00006, 1, NON_SUIVIE, 2025-11-05 22:54:39), (93, 2025-11-05 22:54:39, ?, 2025-02-03 00:00:00, 2025-02-03 00:00:00, 0, 94, ?, Acquisition de téléphone Samsung A24, 150000, 177000, 27000, 10001065, ?, 55, ESB/2025/00008, 1, NON_SUIVIE, 2025-11-05 22:54:39), (107, 2025-11-05 22:54:39, ?, 2025-01-30 00:00:00, 2025-01-30 00:00:00, 0, 95, ?, Acquisition de matériels code barre et consommables, 9950000, 11741000, 1791000, N°2085/EC010000/24, ?, 53, ESB/2025/00005, 1, NON_SUIVIE, 2025-11-05 22:54:39), (102, 2025-11-05 22:54:39, ?, 2025-01-28 00:00:00, 2025-01-28 00:00:00, 0, 96, ?, Acquisition de matériels informatiques, 1650000, 1947000, 297000, 141091, ?, 52, ESB/2025/00004, 1, NON_SUIVIE, 2025-11-05 22:54:39), (8, 2025-11-05 22:54:39, ?, 2025-01-27 00:00:00, 2025-01-27 00:00:00, 0, 97, ?, Achat de matériels informatiques, 22075000, 26048500, 3973500, 70165016, ?, 50, ESB/2025/00002, 1, NON_SUIVIE, 2025-11-05 22:54:39), (54, 2025-11-05 22:54:39, ?, 2024-12-31 00:00:00, 2024-12-31 00:00:00, 0, 99, ?, Achat de batteries LENOVO, 100000, 118000, 18000, ESB/2024/00026, ?, 48, ESB/2024/00026, 1, NON_SUIVIE, 2025-11-05 22:54:39), (48, 2025-11-05 22:54:39, ?, 2025-02-07 00:00:00, 2024-12-31 00:00:00, 0, 100, ?, /, 0, 0, 0, /, ?, 57, /, 1, NON_SUIVIE, 2025-11-05 22:54:39), (111, 2025-11-05 22:54:39, ?, 2024-12-31 00:00:00, 2024-12-31 00:00:00, 0, 101, ?, Acquisition de matériels informatiques, 14350000, 16933000, 2583000, MARCHE N°SE-SOPAFER-B/00/01/04/00/2024-00024, ?, 46, ESB/2024/00024, 1, NON_SUIVIE, 2025-11-05 22:54:39), (35, 2025-11-05 22:54:39, ?, 2024-12-30 00:00:00, 2024-12-30 00:00:00, 0, 102, ?, Hébergements et conception d'un site web, 300000, 354000, 54000, ESB/2024/00025, ?, 47, ESB/2024/00025, 1, NON_SUIVIE, 2025-11-05 22:54:39), (8, 2025-11-05 22:54:39, ?, 2024-12-20 00:00:00, 2024-12-20 00:00:00, 0, 104, ?, Acquisition de tablettes Samsung, 11275000, 13304500, 2029500, 70156049, ?, 45, ESB/2024/00023, 1, NON_SUIVIE, 2025-11-05 22:54:39), (102, 2025-11-05 22:54:39, ?, 2024-12-18 00:00:00, 2024-12-18 00:00:00, 0, 105, ?, Achat de disques dur 2To et 4To, 130000, 153400, 23400, 140908, ?, 43, ESB/2024/00021, 1, NON_SUIVIE, 2025-11-05 22:54:39), (102, 2025-11-05 22:54:39, ?, 2024-12-18 00:00:00, 2024-12-18 00:00:00, 0, 106, ?, Achat de disques dur externe 2 To, 100000, 118000, 18000, 140969, ?, 42, ESB/2024/00020, 1, NON_SUIVIE, 2025-11-05 22:54:39), (81, 2025-11-05 22:54:39, ?, 2024-12-18 00:00:00, 2024-12-18 00:00:00, 0, 107, ?, Acquisition de régulateurs de tension 2000V A, 150000, 177000, 27000, BF_OUA_12_2024_373, ?, 41, ESB/2024/00019, 1, NON_SUIVIE, 2025-11-05 22:54:39), (90, 2025-11-05 22:54:40, ?, 2024-12-04 00:00:00, 2024-12-04 00:00:00, 0, 108, ?, ESB/2024/00018, 675000, 796500, 121500, ESB/2024/00018, ?, 40, ESB/2024/00018, 1, NON_SUIVIE, 2025-11-05 22:54:40), (81, 2025-11-05 22:54:40, ?, 2024-11-27 00:00:00, 2024-11-27 00:00:00, 0, 109, ?, Acquisition de vidéo projecteur EPSON, 300000, 354000, 54000, BF_OUA_11_2024_349, ?, 39, ESB/2024/00017, 1, NON_SUIVIE, 2025-11-05 22:54:40), (81, 2025-11-05 22:54:40, ?, 2024-11-18 00:00:00, 2024-11-18 00:00:00, 0, 110, ?, Acquisition de consommables informatique, 499000, 588820, 89820, BF_OUA_11_2024_339, ?, 38, ESB/2024/00016, 1, NON_SUIVIE, 2025-11-05 22:54:40), (97, 2025-11-05 22:54:40, ?, 2024-11-14 00:00:00, 2024-11-14 00:00:00, 0, 111, ?, Acquisition de matériels informatiques, 2135000, 2519300, 384300, : BC-BF24-005, ?, 36, ESB/2024/00014, 1, NON_SUIVIE, 2025-11-05 22:54:40), (93, 2025-11-05 22:54:40, ?, 2024-11-14 00:00:00, 2024-11-14 00:00:00, 0, 112, ?, Acquisition de téléphone samsung galaxy, 150000, 177000, 27000, : PO 10000774, ?, 37, ESB/2024/00015, 1, NON_SUIVIE, 2025-11-05 22:54:40)) ⏭️ 'facture_fournisseurs' est vide 📦 Migration de 'paiement_clients' (61 lignes)... ⚠️ Erreur sur 'paiement_clients': SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`esoftbursuivifac`.`paiement_clients`, CONSTRAINT `paiement_clients_facture_client_id_foreign` FOREIGN KEY (`facture_client_id`) REFERENCES `facture_clients` (`id`) ON DELETE CASCADE) (Connection: mysql, SQL: insert into `paiement_clients` (`commentaire`, `created_at`, `date_enregistrement`, `date_paiement`, `facture_client_id`, `file_name`, `id`, `mode_paiement_id`, `montant_total_recu`, `piece_jointe`, `reference`, `retenue_en`, `retenue_montant`, `retenue_paiement_id`, `retenue_tva`, `retenue_type`, `type_paiement_id`, `updated_at`, `user_id`) values (Paiement partiel par virement bancaire, 2025-08-29 14:39:51, 2025-08-14 14:39:51, 2025-08-24 14:39:51, 2, ?, 1, ?, 318600, ?, PAY-2-001, montant, 0, ?, 0, HT, 1, 2025-08-29 14:39:51, 1), (Paiement partiel par virement bancaire, 2025-08-29 14:39:51, 2025-08-21 14:39:51, 2025-08-24 14:39:51, 4, ?, 2, ?, 318600, ?, PAY-4-001, montant, 0, ?, 0, HT, 1, 2025-08-29 14:39:51, 1), (Paiement partiel par virement bancaire, 2025-08-29 14:39:51, 2025-08-20 14:39:51, 2025-08-17 14:39:51, 6, ?, 3, ?, 318600, ?, PAY-6-001, montant, 0, ?, 0, HT, 1, 2025-08-29 14:39:51, 1), (payer le 08 de ce mois, 2025-10-08 02:35:54, 2025-10-08 02:35:54, 2025-10-08 00:00:00, 18, 1759890954_quittance_paiement_L2.pdf, 4, 1, 9999.98, paiements_clients/1759890954_quittance_paiement_L2.pdf, PAI-20251008023554-3539, montant, 0, ?, 0, HT, ?, 2025-10-08 02:35:54, 1), (?, 2025-10-08 11:56:46, 2025-10-08 11:56:46, 2025-10-08 00:00:00, 3, 1759924606_quittance_paiement_L2.pdf, 5, 2, 1003000, paiements_clients/1759924606_quittance_paiement_L2.pdf, PAI-20251008115646-8141, montant, 0, ?, 0, HT, ?, 2025-10-08 11:56:46, 1), (?, 2025-10-08 13:01:08, 2025-10-08 13:01:08, 2025-10-08 00:00:00, 19, 1759928468_quitance 2.pdf, 6, 1, 11800000, paiements_clients/1759928468_quitance 2.pdf, PAI-20251008130108-2298, montant, 0, ?, 0, HT, ?, 2025-10-08 13:01:08, 1), (?, 2025-10-08 13:18:25, 2025-10-08 13:18:25, 2025-10-08 00:00:00, 20, 1759929505_quitance 2.pdf, 7, 2, 324000, paiements_clients/1759929505_quitance 2.pdf, PAI-20251008131825-6840, montant, 0, ?, 0, HT, ?, 2025-10-08 13:18:25, 1), (?, 2025-10-08 13:29:29, 2025-10-08 13:29:29, 2025-10-08 00:00:00, 21, 1759930169_quitance 2.pdf, 8, 2, 10800000, paiements_clients/1759930169_quitance 2.pdf, PAI-20251008132929-8119, montant, 0, ?, 0, HT, ?, 2025-10-08 13:29:29, 1), (?, 2025-10-20 16:14:46, 2025-10-20 16:14:46, 2025-10-20 00:00:00, 17, 1760976886_accord de stage.pdf, 12, 2, 64800, paiements_clients/1760976886_accord de stage.pdf, PAI-20251020161446-6662, pourcentage, 0, ?, 5, TVA, ?, 2025-10-20 16:14:46, 1), (?, 2025-10-23 13:35:34, 2025-10-23 13:35:34, 2025-10-23 00:00:00, 16, ?, 14, 2, 216000, ?, PAI-20251023133534-8326, pourcentage, 10000, ?, 0, HT, ?, 2025-10-23 13:35:34, 1), (?, 2025-10-23 16:21:04, 2025-10-23 16:21:04, 2025-10-23 00:00:00, 18, ?, 15, 2, 10000, ?, PAI-20251023162104-4821, montant, 0, ?, 0, HT, ?, 2025-10-23 16:21:04, 1), (?, 2025-10-23 16:22:23, 2025-10-23 16:22:23, 2025-10-23 00:00:00, 18, ?, 16, 2, 322000, ?, PAI-20251023162223-1506, montant, 0, ?, 0, HT, ?, 2025-10-23 16:22:23, 1), (?, 2025-10-23 16:40:59, 2025-10-23 16:40:59, 2025-10-23 00:00:00, 26, ?, 17, 1, 10000, ?, PAI-20251023164059-6449, montant, 0, ?, 0, HT, ?, 2025-10-23 16:40:59, 1), (?, 2025-10-23 16:41:59, 2025-10-23 16:41:59, 2025-10-28 00:00:00, 26, ?, 18, 1, 108000, ?, PAI-20251023164159-3014, montant, 0, ?, 0, HT, ?, 2025-10-23 16:41:59, 1), (?, 2025-10-23 16:49:45, 2025-10-23 16:49:45, 2025-10-23 00:00:00, 27, ?, 19, 2, 10000, ?, PAI-20251023164945-9902, montant, 0, ?, 0, HT, ?, 2025-10-23 16:49:45, 1), (?, 2025-10-23 16:50:41, 2025-10-23 16:50:41, 2025-10-23 00:00:00, 27, ?, 20, 2, 98000, ?, PAI-20251023165041-4344, montant, 0, ?, 0, HT, ?, 2025-10-23 16:50:41, 1), (?, 2025-10-23 17:04:09, 2025-10-23 17:04:09, 2025-10-23 00:00:00, 15, ?, 21, 2, 212400, ?, PAI-20251023170409-1040, montant, 0, ?, 0, HT, ?, 2025-10-23 17:04:09, 1), (?, 2025-10-23 23:08:00, 2025-10-23 23:08:00, 2025-10-23 00:00:00, 28, ?, 22, 2, 10000, ?, PAI-20251023230800-2907, montant, 0, ?, 0, HT, ?, 2025-10-23 23:08:00, 1), (?, 2025-10-24 00:52:11, 2025-10-24 00:52:11, 2025-10-24 00:00:00, 5, 1761267130_LETTRE acorde de stage.pdf, 23, 2, 1003000, paiements_clients/1761267130_LETTRE acorde de stage.pdf, PAI-20251024005211-9418, pourcentage, 85000, ?, 0, HT, ?, 2025-10-24 00:52:11, 1), (?, 2025-10-24 00:52:12, 2025-10-24 00:52:12, 2025-10-24 00:00:00, 6, 1761267130_LETTRE acorde de stage.pdf, 24, 2, 212400, paiements_clients/1761267130_LETTRE acorde de stage.pdf, PAI-20251024005212-4034, pourcentage, 45000, ?, 0, HT, ?, 2025-10-24 00:52:12, 1), (?, 2025-10-24 00:55:49, 2025-10-24 00:55:49, 2025-10-24 00:00:00, 12, ?, 25, 2, 4661000, ?, PAI-20251024005549-1301, montant, 0, ?, 0, HT, ?, 2025-10-24 00:55:49, 1), (?, 2025-10-24 00:55:49, 2025-10-24 00:55:49, 2025-10-24 00:00:00, 13, ?, 26, 2, 177000, ?, PAI-20251024005549-5272, montant, 0, ?, 0, HT, ?, 2025-10-24 00:55:49, 1), (?, 2025-10-24 00:57:23, 2025-10-24 00:57:23, 2025-10-24 00:00:00, 5, ?, 27, 2, 85000, ?, PAI-20251024005723-8467, montant, 0, ?, 0, HT, ?, 2025-10-24 00:57:23, 1), (?, 2025-10-24 00:57:23, 2025-10-24 00:57:23, 2025-10-24 00:00:00, 6, ?, 28, 2, 45000, ?, PAI-20251024005723-5269, montant, 0, ?, 0, HT, ?, 2025-10-24 00:57:23, 1), (?, 2025-10-24 01:02:50, 2025-10-24 01:02:50, 2025-10-24 00:00:00, 1, ?, 29, 2, 1003000, ?, PAI-20251024010250-4318, montant, 0, ?, 0, HT, ?, 2025-10-24 01:02:50, 1), (?, 2025-10-24 01:02:50, 2025-10-24 01:02:50, 2025-10-24 00:00:00, 11, ?, 30, 2, 1200, ?, PAI-20251024010250-4379, montant, 0, ?, 0, HT, ?, 2025-10-24 01:02:50, 1), (?, 2025-10-24 01:06:45, 2025-10-24 01:06:45, 2025-10-24 00:00:00, 28, ?, 31, 2, 10000, ?, PAI-20251024010645-2472, montant, 0, ?, 0, HT, ?, 2025-10-24 01:06:45, 1), (?, 2025-10-24 01:08:15, 2025-10-24 01:08:15, 2025-10-24 00:00:00, 28, ?, 32, 2, 10000, ?, PAI-20251024010815-1137, montant, 0, ?, 0, HT, ?, 2025-10-24 01:08:15, 1), (?, 2025-10-24 01:11:58, 2025-10-24 01:11:58, 2025-10-24 00:00:00, 28, ?, 33, 2, 10000, ?, PAI-20251024011158-3328, montant, 0, ?, 0, HT, ?, 2025-10-24 01:11:58, 1), (?, 2025-10-24 01:14:29, 2025-10-24 01:14:29, 2025-10-24 00:00:00, 28, ?, 34, 2, 10000, ?, PAI-20251024011429-5731, montant, 0, ?, 0, HT, ?, 2025-10-24 01:14:29, 1), (?, 2025-10-24 01:15:20, 2025-10-24 01:15:20, 2025-10-24 00:00:00, 14, ?, 35, 2, 944000, ?, PAI-20251024011520-7020, montant, 0, ?, 0, HT, ?, 2025-10-24 01:15:20, 1), (?, 2025-10-24 01:18:55, 2025-10-24 01:18:55, 2025-10-24 00:00:00, 28, ?, 36, 2, 10000, ?, PAI-20251024011855-2632, montant, 0, ?, 0, HT, ?, 2025-10-24 01:18:55, 1), (?, 2025-10-24 01:24:38, 2025-10-24 01:24:38, 2025-10-24 00:00:00, 28, ?, 37, 2, 10000, ?, PAI-20251024012438-3801, montant, 0, ?, 0, HT, ?, 2025-10-24 01:24:38, 1), (?, 2025-10-24 01:28:58, 2025-10-24 01:28:58, 2025-10-24 00:00:00, 28, ?, 38, 1, 10000, ?, PAI-20251024012858-6299, montant, 0, ?, 0, HT, ?, 2025-10-24 01:28:58, 1), (?, 2025-10-24 01:31:07, 2025-10-24 01:31:07, 2025-10-24 00:00:00, 28, ?, 39, 2, 10000, ?, PAI-20251024013107-9209, montant, 0, ?, 0, HT, ?, 2025-10-24 01:31:07, 1), (?, 2025-10-24 01:33:27, 2025-10-24 01:33:27, 2025-10-24 00:00:00, 28, ?, 40, 2, 10000, ?, PAI-20251024013327-1421, montant, 0, ?, 0, HT, ?, 2025-10-24 01:33:27, 1), (?, 2025-10-24 01:34:50, 2025-10-24 01:34:50, 2025-10-24 00:00:00, 18, ?, 41, 2, 0.020000000018626, ?, PAI-20251024013450-2815, montant, 0, ?, 0, HT, ?, 2025-10-24 01:34:50, 1), (?, 2025-10-24 01:34:50, 2025-10-24 01:34:50, 2025-10-24 00:00:00, 20, ?, 42, 2, 0, ?, PAI-20251024013450-9226, montant, 0, ?, 0, HT, ?, 2025-10-24 01:34:50, 1), (?, 2025-10-24 01:34:50, 2025-10-24 01:34:50, 2025-10-24 00:00:00, 28, ?, 43, 2, 11200000, ?, PAI-20251024013450-1608, montant, 0, ?, 0, HT, ?, 2025-10-24 01:34:50, 1), (Test de synchronisation automatique BC, 2025-10-27 20:41:52, 2025-10-27 20:41:52, 2025-10-27 20:41:52, 29, ?, 44, 1, 1180000, ?, PAY-TEST-BC-001, montant, 0, ?, 0, HT, ?, 2025-10-27 20:41:52, 1), (?, 2025-10-27 22:21:42, 2025-10-27 22:21:42, 2025-10-27 00:00:00, 30, ?, 45, 2, 118000, ?, PAI-20251027222142-6999, montant, 0, ?, 0, HT, ?, 2025-10-27 22:21:42, 1), (?, 2025-10-27 22:35:11, 2025-10-27 22:35:11, 2025-10-27 00:00:00, 31, ?, 46, 1, 118000, ?, PAI-20251027223511-7946, montant, 0, ?, 0, HT, ?, 2025-10-27 22:35:11, 1), (?, 2025-10-28 10:59:50, 2025-10-28 10:59:50, 2025-10-28 00:00:00, 7, ?, 47, 1, 118, ?, PAI-20251028105950-4160, montant, 18, ?, 0, TTC, ?, 2025-10-28 10:59:50, 1), (?, 2025-10-28 10:59:51, 2025-10-28 10:59:51, 2025-10-28 00:00:00, 8, ?, 48, 1, 118, ?, PAI-20251028105951-3688, montant, 18, ?, 0, TTC, ?, 2025-10-28 10:59:51, 1), (?, 2025-10-28 10:59:51, 2025-10-28 10:59:51, 2025-10-28 00:00:00, 9, ?, 49, 1, 118, ?, PAI-20251028105951-4832, montant, 18, ?, 0, TTC, ?, 2025-10-28 10:59:51, 1), (?, 2025-10-28 11:05:08, 2025-10-28 11:05:08, 2025-10-28 00:00:00, 32, 1761649506_accord de stage.pdf, 50, 2, 100300, paiements_clients/1761649506_accord de stage.pdf, PAI-20251028110508-8573, pourcentage, 4250, ?, 0, HT, ?, 2025-10-28 11:05:08, 1), (?, 2025-10-28 11:07:20, 2025-10-28 11:07:20, 2025-10-28 00:00:00, 32, ?, 51, 2, 4250, ?, PAI-20251028110720-8323, montant, 0, ?, 0, HT, ?, 2025-10-28 11:07:20, 1), (?, 2025-10-28 11:26:04, 2025-10-28 11:26:04, 2025-10-28 00:00:00, 33, ?, 52, 1, 295000, ?, PAI-20251028112604-1843, montant, 0, ?, 0, HT, ?, 2025-10-28 11:26:04, 1), (?, 2025-10-31 15:50:18, 2025-10-31 15:50:18, 2025-10-31 00:00:00, 34, ?, 53, 1, 118, ?, PAI-20251031155018-8203, pourcentage, 7, ?, 0, HT, ?, 2025-10-31 15:50:18, 1), (?, 2025-10-31 16:04:10, 2025-10-31 16:04:10, 2025-10-31 00:00:00, 35, ?, 54, 1, 113000, ?, PAI-20251031160410-1897, pourcentage, 10000, ?, 0, HT, ?, 2025-10-31 16:04:10, 1), (?, 2025-11-05 12:38:34, 2025-11-05 12:38:34, 2025-11-05 00:00:00, 37, ?, 55, 2, 814200, ?, PAI-20251105123834-3133, montant, 0, ?, 0, HT, ?, 2025-11-05 12:38:34, 1), (?, 2025-11-05 13:05:57, 2025-11-05 13:05:57, 2025-11-05 00:00:00, 39, ?, 57, 1, 1701000, ?, PAI-20251105130557-8898, montant, 0, ?, 0, HT, ?, 2025-11-05 13:05:57, 1), (?, 2025-11-05 13:22:37, 2025-11-05 13:22:37, 2025-11-05 00:00:00, 40, ?, 58, 1, 19174990, ?, PAI-20251105132237-7612, montant, 0, ?, 0, HT, ?, 2025-11-05 13:22:37, 1), (?, 2025-11-05 13:34:55, 2025-11-05 13:34:55, 2025-11-05 00:00:00, 41, ?, 59, 1, 4463495, ?, PAI-20251105133455-4642, montant, 0, ?, 0, HT, ?, 2025-11-05 13:34:55, 1), (?, 2025-11-05 13:39:05, 2025-11-05 13:39:05, 2025-11-05 00:00:00, 42, ?, 60, 1, 4308007, ?, PAI-20251105133905-6967, montant, 0, ?, 0, HT, ?, 2025-11-05 13:39:05, 1), (?, 2025-11-05 13:44:21, 2025-11-05 13:44:21, 2025-11-05 00:00:00, 43, ?, 61, 1, 0, ?, PAI-20251105134421-6333, montant, 0, ?, 0, HT, ?, 2025-11-05 13:58:00, 1), (?, 2025-11-05 13:58:55, 2025-11-05 13:58:55, 2025-11-05 00:00:00, 43, ?, 62, 1, 100, ?, PAI-20251105135855-2270, montant, 0, ?, 0, HT, ?, 2025-11-05 14:00:15, 1), (?, 2025-11-05 14:17:44, 2025-11-05 14:17:44, 2025-11-05 00:00:00, 45, ?, 63, 2, 7017290, ?, PAI-20251105141744-4427, montant, 0, ?, 0, HT, ?, 2025-11-05 14:19:05, 1), (?, 2025-11-09 15:01:53, 2025-11-09 15:01:53, 2025-11-09 00:00:00, 133, ?, 68, 2, 147495, ?, PAI-20251109150153-8424, montant, 0, ?, 0, HT, ?, 2025-11-09 15:01:53, 1), (?, 2025-11-10 08:22:49, 2025-11-10 08:22:49, 2025-11-10 00:00:00, 135, 1762762968_fature_Devis .pdf, 70, 2, 7068150, paiements_clients/1762762968_fature_Devis .pdf, PAI-20251110082249-4092, montant, 0, ?, 0, HT, ?, 2025-11-10 08:22:49, 1), (?, 2025-11-13 09:19:23, 2025-11-13 09:19:23, 2025-11-13 00:00:00, 159, ?, 71, 2, 3633750, ?, PAI-20251113091923-5144, montant, 0, ?, 0, HT, ?, 2025-11-13 09:19:23, 1)) ⏭️ 'paiement_fournisseurs' est vide ⏭️ 'retenue_paiements' est vide 📦 Migration de 'retenues_paiement_client' (15 lignes)... ⚠️ Erreur sur 'retenues_paiement_client': SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2' for key 'retenues_paiement_client.PRIMARY' (Connection: mysql, SQL: insert into `retenues_paiement_client` (`created_at`, `id`, `mode_calcul`, `montant_calcule`, `motif`, `paiement_client_id`, `type`, `updated_at`, `valeur`) values (2025-11-05 12:38:35, 1, pourcentage, 40710, motif 1, 55, TTC, 2025-11-05 12:38:35, 5), (2025-11-05 12:38:35, 2, pourcentage, 34500, Motif 2, 55, HT, 2025-11-05 12:38:35, 5), (2025-11-05 13:05:57, 5, pourcentage, 78750, retenue 1, 57, HT, 2025-11-05 13:05:57, 5), (2025-11-05 13:05:57, 6, pourcentage, 78750, retenue 2, 57, HT, 2025-11-05 13:05:57, 5), (2025-11-05 13:22:37, 7, montant, 5, retenu 1, 58, HT, 2025-11-05 13:22:37, 5), (2025-11-05 13:22:37, 8, montant, 5, retenue 2, 58, HT, 2025-11-05 13:22:37, 5), (2025-11-05 13:34:55, 9, pourcentage, 197500, retenue 1, 59, HT, 2025-11-05 13:34:55, 5), (2025-11-05 13:34:55, 10, montant, 5, retenue 1, 59, HT, 2025-11-05 13:34:55, 5), (2025-11-05 13:39:05, 11, pourcentage, 190620, retenue 1, 60, HT, 2025-11-05 13:39:05, 5), (2025-11-05 13:39:05, 12, montant, 5, retenue 2, 60, HT, 2025-11-05 13:39:05, 5), (2025-11-05 14:19:05, 15, montant, 5, retenue 1, 63, HT, 2025-11-05 14:19:05, 5), (2025-11-05 14:19:05, 16, montant, 5, retenue 2, 63, HT, 2025-11-05 14:19:05, 5), (2025-11-09 15:01:53, 22, montant, 5, FOnds de souteein parriotique, 68, HT, 2025-11-09 15:01:53, 5), (2025-11-10 08:22:49, 24, pourcentage, 312750, FSP, 70, HT, 2025-11-10 08:22:49, 5), (2025-11-13 09:19:23, 25, pourcentage, 191250, pénalité, 71, HT, 2025-11-13 09:19:23, 5)) 📦 Migration de 'bon_commandes' (53 lignes)... ⚠️ Erreur sur 'bon_commandes': SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`esoftbursuivifac`.`bon_commandes`, CONSTRAINT `bon_commandes_entreprise_id_foreign` FOREIGN KEY (`entreprise_id`) REFERENCES `clients` (`id`)) (Connection: mysql, SQL: insert into `bon_commandes` (`created_at`, `date_bon_commande`, `date_livraison_effective`, `date_livraison_prevue`, `date_paiement`, `designation`, `entreprise_id`, `id`, `montant_ht`, `montant_ttc`, `notes`, `reference`, `statut_paiement`, `statut_traitement`, `tva`, `updated_at`) values (2025-10-27 20:39:26, 2025-06-09 00:00:00, ?, 2025-06-30 00:00:00, ?, Fourniture de matériel informatique - Nam veniam voluptas odio cupiditate porro., 22, 1, 3509177, 4140828.86, ?, BC202500001, partiel, en_cours, 18, 2025-10-27 20:39:26), (2025-10-27 20:39:26, 2025-06-24 00:00:00, ?, 2025-08-18 00:00:00, ?, Achat de mobilier de bureau - Autem id qui est et., 24, 2, 4485791, 5293233.38, ?, BC202500002, non_paye, en_cours, 18, 2025-10-27 20:39:26), (2025-10-27 20:39:27, 2025-05-07 00:00:00, ?, 2025-06-11 00:00:00, ?, Services de formation professionnelle - Sint excepturi quibusdam qui rerum provident inventore voluptatem., 85, 3, 4413495, 5207924.1, Notes pour le BC 3, BC202500003, non_paye, en_cours, 18, 2025-10-27 20:39:27), (2025-10-27 20:39:27, 2025-06-12 00:00:00, ?, 2025-07-05 00:00:00, ?, Travaux de rénovation - Earum laboriosam ducimus mollitia., 91, 4, 4257371, 5023697.78, Notes pour le BC 4, BC202500004, non_paye, en_cours, 18, 2025-10-27 20:39:27), (2025-10-27 20:39:27, 2025-05-07 00:00:00, ?, 2025-06-25 00:00:00, ?, Prestation de services de maintenance - Iste sed qui ab iste repellat., 78, 5, 1508480, 1780006.4, ?, BC202500005, non_paye, en_cours, 18, 2025-10-27 20:39:27), (2025-10-27 20:39:27, 2025-07-05 00:00:00, ?, 2025-08-14 00:00:00, ?, Achat de fournitures de bureau - Dolor sapiente rerum quia dolores sequi exercitationem quia quam., 68, 6, 1301522, 1535795.96, ?, BC202500006, partiel, en_cours, 18, 2025-10-27 20:39:27), (2025-10-27 20:39:27, 2025-09-13 00:00:00, ?, 2025-11-12 00:00:00, ?, Fourniture d'équipements électriques - Necessitatibus quo quae iusto earum et porro., 19, 7, 2457367, 2899693.06, Notes pour le BC 7, BC202500007, non_paye, en_cours, 18, 2025-10-27 20:39:27), (2025-10-27 20:39:28, 2025-07-24 00:00:00, ?, 2025-08-22 00:00:00, ?, Achat de mobilier de bureau - Et voluptate ipsam consequatur deleniti laborum., 24, 8, 4325230, 5103771.4, ?, BC202500008, non_paye, en_cours, 18, 2025-10-27 20:39:28), (2025-10-27 20:39:28, 2025-10-20 00:00:00, 2025-10-27 00:00:00, 2025-12-19 00:00:00, ?, Services de formation professionnelle - Fuga voluptatibus placeat facilis aut ipsum cum., 95, 9, 2633109, 3107068.62, ?, BC202500009, non_paye, en_cours, 18, 2025-10-27 23:54:56), (2025-10-27 20:39:28, 2025-06-04 00:00:00, ?, 2025-08-01 00:00:00, ?, Prestations de nettoyage - Laudantium aut omnis temporibus quo., 66, 10, 2567623, 3029795.14, Notes pour le BC 10, BC202500010, non_paye, en_cours, 18, 2025-10-27 20:39:28), (2025-10-27 20:39:28, 2025-07-06 00:00:00, ?, 2025-08-20 00:00:00, ?, Achat de fournitures de bureau - Consequuntur temporibus quia distinctio pariatur nam in qui iure., 46, 11, 2671981, 3152937.58, Notes pour le BC 11, BC202500011, partiel, en_cours, 18, 2025-10-27 20:39:28), (2025-10-27 20:39:28, 2025-07-28 00:00:00, ?, 2025-08-16 00:00:00, ?, Travaux de rénovation - Non ullam quidem quibusdam ea est adipisci maxime., 96, 12, 494698, 583743.64, ?, BC202500012, non_paye, en_cours, 18, 2025-10-27 20:39:28), (2025-10-27 20:39:28, 2025-06-19 00:00:00, ?, 2025-08-08 00:00:00, ?, Installation de système de sécurité - Eos minus non libero quam dolorum ducimus., 47, 13, 2763642, 3261097.56, ?, BC202500013, non_paye, en_cours, 18, 2025-10-27 20:39:28), (2025-10-27 20:39:29, 2025-06-27 00:00:00, ?, 2025-08-15 00:00:00, ?, Achat de fournitures de bureau - Et rem et aliquam delectus., 80, 14, 4444391, 5244381.38, ?, BC202500014, non_paye, en_cours, 18, 2025-10-27 20:39:29), (2025-10-27 20:39:29, 2025-09-22 00:00:00, ?, 2025-11-14 00:00:00, ?, Services de formation professionnelle - Ut perferendis sed eum quia culpa molestiae., 67, 15, 2973934, 3509242.12, ?, BC202500015, non_paye, en_attente_fournisseur, 18, 2025-10-28 00:13:45), (2025-10-27 20:39:29, 2025-09-23 00:00:00, 2025-10-27 00:00:00, 2025-11-21 00:00:00, ?, Installation de système de sécurité - Voluptatem dolor eius natus error nisi nesciunt tenetur., 49, 16, 2392690, 2823374.2, ?, BC202500016, partiel, livre, 18, 2025-10-27 23:24:49), (2025-10-27 20:39:29, 2025-07-23 00:00:00, ?, 2025-09-15 00:00:00, ?, Fourniture de matériel informatique - Itaque quos distinctio architecto voluptatibus ipsam est earum., 99, 17, 838843, 989834.74, ?, BC202500017, non_paye, en_cours, 18, 2025-10-27 20:39:29), (2025-10-27 20:39:29, 2025-07-30 00:00:00, ?, 2025-09-23 00:00:00, ?, Prestations de nettoyage - Inventore dolor cupiditate dignissimos tenetur voluptas., 19, 18, 2166558, 2556538.44, ?, BC202500018, non_paye, en_cours, 18, 2025-10-27 20:39:29), (2025-10-27 20:39:30, 2025-07-15 00:00:00, ?, 2025-08-21 00:00:00, ?, Fourniture de matériel informatique - Qui rerum laudantium dolor veritatis culpa quas voluptates., 17, 19, 4389568, 5179690.24, ?, BC202500019, non_paye, en_cours, 18, 2025-10-27 20:39:30), (2025-10-27 20:39:30, 2025-05-12 00:00:00, ?, 2025-06-07 00:00:00, ?, Installation de système de sécurité - Sint omnis eveniet doloremque dolor pariatur voluptas vitae., 5, 20, 1369310, 1615785.8, Notes pour le BC 20, BC202500020, partiel, en_cours, 18, 2025-10-27 20:39:30), (2025-10-27 20:39:30, 2025-09-25 00:00:00, ?, 2025-11-16 00:00:00, ?, Achat de mobilier de bureau - A repellat aut iste consequatur rerum., 25, 21, 2865181, 3380913.58, ?, BC202500021, non_paye, en_attente_fournisseur, 18, 2025-10-27 20:39:30), (2025-10-27 20:39:30, 2025-09-09 00:00:00, ?, 2025-10-11 00:00:00, ?, Achat de fournitures de bureau - Et dolorum porro quia aperiam placeat sit laudantium dolor., 25, 22, 696694, 822098.92, Notes pour le BC 22, BC202500022, non_paye, en_attente_fournisseur, 18, 2025-10-27 20:39:30), (2025-10-27 20:39:31, 2025-09-14 00:00:00, ?, 2025-10-25 00:00:00, ?, Fourniture d'équipements électriques - Eligendi aspernatur ut beatae labore fugit beatae., 22, 23, 1474989, 1740487.02, ?, BC202500023, partiel, en_attente_fournisseur, 18, 2025-10-27 20:39:31), (2025-10-27 20:39:31, 2025-10-25 00:00:00, 2025-10-28 00:00:00, 2025-12-07 00:00:00, ?, Fourniture de matériel informatique - Iste ducimus id voluptatem beatae., 88, 24, 2276281, 2686011.58, ?, BC202500024, non_paye, livre, 18, 2025-10-28 07:35:46), (2025-10-27 20:39:31, 2025-05-15 00:00:00, ?, 2025-05-31 00:00:00, ?, Prestations de nettoyage - Explicabo ex et enim eum minus maxime., 81, 25, 3153914, 3721618.52, ?, BC202500025, non_paye, en_attente_fournisseur, 18, 2025-10-27 20:39:31), (2025-10-27 20:39:31, 2025-08-07 00:00:00, ?, 2025-09-21 00:00:00, ?, Fourniture de consommables - Explicabo reprehenderit voluptatem eligendi., 102, 26, 4281596, 5052283.28, ?, BC202500026, non_paye, en_attente_fournisseur, 18, 2025-10-27 20:39:31), (2025-10-27 20:39:33, 2025-07-14 00:00:00, ?, 2025-08-14 00:00:00, ?, Fourniture de consommables - Perspiciatis aut vel non rerum., 28, 27, 3234954, 3817245.72, ?, BC202500027, partiel, en_attente_fournisseur, 18, 2025-10-27 20:39:33), (2025-10-27 20:39:34, 2025-08-02 00:00:00, ?, 2025-08-24 00:00:00, ?, Achat de fournitures de bureau - Animi aperiam consequatur nisi sint et perspiciatis autem., 80, 28, 2262909, 2670232.62, ?, BC202500028, partiel, en_attente_fournisseur, 18, 2025-10-27 20:39:34), (2025-10-27 20:39:34, 2025-10-16 00:00:00, ?, 2025-12-12 00:00:00, ?, Achat de mobilier de bureau - Labore ipsam assumenda nobis molestias veniam vitae facilis., 11, 29, 2330987, 2750564.66, ?, BC202500029, non_paye, en_attente_fournisseur, 18, 2025-10-27 20:39:34), (2025-10-27 20:39:34, 2025-07-05 00:00:00, ?, 2025-08-11 00:00:00, ?, Fourniture de consommables - Temporibus praesentium vel dicta maiores soluta rem., 74, 30, 2043903, 2411805.54, Notes pour le BC 30, BC202500030, non_paye, en_attente_fournisseur, 18, 2025-10-27 20:39:34), (2025-10-27 20:39:34, 2025-08-14 00:00:00, 2025-09-16 00:00:00, 2025-10-12 00:00:00, 2025-10-19 00:00:00, Fourniture de consommables - Exercitationem omnis error labore nihil ab consequatur., 71, 31, 3479613, 4105943.34, ?, BC202500031, paye, livre, 18, 2025-10-27 20:39:34), (2025-10-27 20:39:35, 2025-05-03 00:00:00, 2025-06-01 00:00:00, 2025-06-23 00:00:00, ?, Achat de fournitures de bureau - Corrupti reprehenderit perferendis et dolorum sed et veniam ipsa., 95, 32, 2902127, 3424509.86, ?, BC202500032, partiel, livre, 18, 2025-10-27 20:39:35), (2025-10-27 20:39:35, 2025-06-25 00:00:00, 2025-07-19 00:00:00, 2025-07-26 00:00:00, 2025-07-21 00:00:00, Services de formation professionnelle - Beatae praesentium et consequuntur delectus voluptatibus qui odit., 52, 33, 4372122, 5159103.96, Notes pour le BC 33, BC202500033, paye, livre, 18, 2025-10-27 20:39:35), (2025-10-27 20:39:35, 2025-07-23 00:00:00, 2025-08-22 00:00:00, 2025-09-12 00:00:00, ?, Installation de système de sécurité - Dolore est excepturi accusantium exercitationem perferendis nostrum., 100, 34, 3148125, 3714787.5, ?, BC202500034, non_paye, livre, 18, 2025-10-27 20:39:35), (2025-10-27 20:39:36, 2025-05-26 00:00:00, 2025-06-23 00:00:00, 2025-07-04 00:00:00, ?, Fourniture de matériel informatique - Ut perspiciatis libero doloremque quia et ab qui., 90, 35, 3120565, 3682266.7, Notes pour le BC 35, BC202500035, non_paye, livre, 18, 2025-10-27 20:39:36), (2025-10-27 20:39:36, 2025-05-15 00:00:00, 2025-06-12 00:00:00, 2025-06-23 00:00:00, ?, Services de formation professionnelle - Tempora exercitationem consequatur deleniti ipsa., 85, 36, 2624252, 3096617.36, Notes pour le BC 36, BC202500036, partiel, livre, 18, 2025-10-27 20:39:36), (2025-10-27 20:39:36, 2025-10-25 00:00:00, 2025-11-19 00:00:00, 2025-12-01 00:00:00, ?, Services de formation professionnelle - Voluptas delectus blanditiis earum libero omnis., 89, 37, 2155321, 2543278.78, ?, BC202500037, partiel, livre, 18, 2025-10-27 20:39:36), (2025-10-27 20:39:36, 2025-06-10 00:00:00, 2025-06-30 00:00:00, 2025-07-07 00:00:00, ?, Prestations de nettoyage - Placeat odit maxime deleniti., 15, 38, 1856188, 2190301.84, Notes pour le BC 38, BC202500038, non_paye, livre, 18, 2025-10-27 20:39:36), (2025-10-27 20:39:37, 2025-06-14 00:00:00, 2025-07-25 00:00:00, 2025-07-20 00:00:00, ?, Prestations de nettoyage - Vel occaecati animi est voluptas expedita et pariatur., 36, 39, 851614, 1004904.52, Notes pour le BC 39, BC202500039, non_paye, livre, 18, 2025-10-27 20:39:37), (2025-10-27 20:39:37, 2025-05-04 00:00:00, 2025-06-11 00:00:00, 2025-06-04 00:00:00, ?, Achat de mobilier de bureau - Harum distinctio quia consectetur totam ratione laudantium., 19, 40, 1430288, 1687739.84, ?, BC202500040, partiel, livre, 18, 2025-10-27 20:39:37), (2025-10-27 20:39:37, 2025-10-26 00:00:00, 2025-11-11 00:00:00, 2025-12-11 00:00:00, ?, Prestations de nettoyage - Voluptatibus aut officiis est et tenetur minus alias qui., 62, 41, 2868804, 3385188.72, Notes pour le BC 41, BC202500041, partiel, livre, 18, 2025-10-27 20:39:37), (2025-10-27 20:39:38, 2025-10-20 00:00:00, 2025-11-23 00:00:00, 2025-11-23 00:00:00, 2026-01-06 00:00:00, Travaux de rénovation - Deleniti eius itaque earum sed quod quia animi et., 103, 42, 238674, 281635.32, ?, BC202500042, paye, livre, 18, 2025-10-27 20:39:38), (2025-10-27 20:39:38, 2025-10-20 00:00:00, 2025-11-07 00:00:00, 2025-11-04 00:00:00, ?, Prestation de services de maintenance - Reprehenderit eius ducimus id ut fugiat eligendi sit nisi., 86, 43, 2313717, 2730186.06, ?, BC202500043, partiel, en_cours, 18, 2025-10-27 23:54:45), (2025-10-27 20:39:38, 2025-08-17 00:00:00, 2025-09-17 00:00:00, 2025-10-09 00:00:00, 2025-09-24 00:00:00, Installation de système de sécurité - Rerum odit consequatur commodi ducimus ullam autem blanditiis., 10, 44, 993517, 1172350.06, ?, BC202500044, paye, livre, 18, 2025-10-27 20:39:38), (2025-10-27 20:39:39, 2025-08-14 00:00:00, 2025-09-24 00:00:00, 2025-09-20 00:00:00, 2025-09-30 00:00:00, Fourniture de matériel informatique - Quis pariatur et laudantium corrupti dolores., 68, 45, 1564476, 1846081.68, Notes pour le BC 45, BC202500045, paye, livre, 18, 2025-10-27 20:39:39), (2025-10-27 20:39:39, 2025-05-27 00:00:00, ?, 2025-07-23 00:00:00, ?, Prestation de services de maintenance - Dolor voluptatem velit corrupti consequatur est consequatur commodi., 93, 46, 1787758, 2109554.44, ?, BC202500046, non_paye, en_cours, 18, 2025-10-28 11:11:56), (2025-10-27 20:39:39, 2025-05-01 00:00:00, ?, 2025-06-15 00:00:00, ?, Fourniture de matériel informatique - Quas quis amet autem aut in in eos., 90, 47, 2929552, 3456871.36, ?, BC202500047, non_paye, annule, 18, 2025-10-27 20:39:39), (2025-10-27 20:39:39, 2025-10-19 00:00:00, ?, 2025-11-25 00:00:00, ?, Fourniture de matériel informatique - Corrupti nihil quam corporis officia., 60, 48, 2311583, 2727667.94, ?, BC202500048, non_paye, en_cours, 18, 2025-10-27 23:51:13), (2025-10-27 20:39:39, 2025-08-24 00:00:00, ?, 2025-10-15 00:00:00, ?, Installation de système de sécurité - Voluptas accusantium est voluptas recusandae alias., 73, 49, 3916587, 4621572.66, ?, BC202500049, non_paye, annule_garde_stock, 18, 2025-10-27 20:39:39), (2025-10-27 20:39:40, 2025-05-31 00:00:00, ?, 2025-07-15 00:00:00, ?, Travaux de rénovation - Tempora ut ipsum qui magni., 3, 50, 1648854, 1945647.72, ?, BC202500050, non_paye, annule_garde_stock, 18, 2025-10-27 20:39:40), (2025-10-27 22:16:47, 2025-10-27 00:00:00, 2025-10-27 00:00:00, 2025-10-29 00:00:00, ?, ofrre de service a nabinov, 103, 51, 100000, 118000, non j'ai pas de note non, BC202500051, non_paye, livre, 18, 2025-10-27 23:40:33), (2025-10-27 22:32:51, 2025-10-27 00:00:00, 2025-10-27 00:00:00, ?, 2025-10-27 00:00:00, achat de 4*4, 103, 52, 100000, 118000, ?, BC202500052, paye, livre, 18, 2025-10-27 23:27:10), (2025-10-28 11:17:19, 2025-10-28 00:00:00, ?, 2025-11-08 00:00:00, 2025-10-28 00:00:00, Fourniture de téléphone IP, 25, 53, 250000, 295000, ?, BC202500053, paye, livre, 18, 2025-10-28 11:26:04)) 📦 Migration de 'bon_commande_fournisseur' (51 lignes)... ⚠️ Erreur sur 'bon_commande_fournisseur': SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`esoftbursuivifac`.`bon_commande_fournisseur`, CONSTRAINT `bon_commande_fournisseur_bon_commande_id_foreign` FOREIGN KEY (`bon_commande_id`) REFERENCES `bon_commandes` (`id`) ON DELETE CASCA (Connection: mysql, SQL: insert into `bon_commande_fournisseur` (`bon_commande_id`, `created_at`, `date_contact`, `fournisseur_id`, `id`, `notes`, `updated_at`) values (1, 2025-10-27 20:39:26, ?, 4, 1, ?, 2025-10-27 20:39:26), (1, 2025-10-27 20:39:26, ?, 7, 2, ?, 2025-10-27 20:39:26), (2, 2025-10-27 20:39:26, ?, 2, 3, ?, 2025-10-27 20:39:26), (2, 2025-10-27 20:39:26, ?, 8, 4, ?, 2025-10-27 20:39:26), (4, 2025-10-27 20:39:27, ?, 3, 5, ?, 2025-10-27 20:39:27), (4, 2025-10-27 20:39:27, ?, 5, 6, ?, 2025-10-27 20:39:27), (6, 2025-10-27 20:39:27, ?, 3, 7, ?, 2025-10-27 20:39:27), (9, 2025-10-27 20:39:28, ?, 4, 8, ?, 2025-10-27 20:39:28), (10, 2025-10-27 20:39:28, ?, 2, 9, ?, 2025-10-27 20:39:28), (10, 2025-10-27 20:39:28, ?, 4, 10, ?, 2025-10-27 20:39:28), (11, 2025-10-27 20:39:28, ?, 5, 11, ?, 2025-10-27 20:39:28), (12, 2025-10-27 20:39:28, ?, 1, 12, ?, 2025-10-27 20:39:28), (13, 2025-10-27 20:39:28, ?, 1, 13, ?, 2025-10-27 20:39:28), (14, 2025-10-27 20:39:29, ?, 4, 14, ?, 2025-10-27 20:39:29), (14, 2025-10-27 20:39:29, ?, 5, 15, ?, 2025-10-27 20:39:29), (15, 2025-10-27 20:39:29, ?, 2, 16, ?, 2025-10-27 20:39:29), (18, 2025-10-27 20:39:29, ?, 2, 17, ?, 2025-10-27 20:39:29), (18, 2025-10-27 20:39:29, ?, 7, 18, ?, 2025-10-27 20:39:29), (19, 2025-10-27 20:39:30, ?, 8, 19, ?, 2025-10-27 20:39:30), (20, 2025-10-27 20:39:30, ?, 3, 20, ?, 2025-10-27 20:39:30), (20, 2025-10-27 20:39:30, ?, 7, 21, ?, 2025-10-27 20:39:30), (21, 2025-10-27 20:39:30, ?, 1, 22, ?, 2025-10-27 20:39:30), (21, 2025-10-27 20:39:30, ?, 7, 23, ?, 2025-10-27 20:39:30), (23, 2025-10-27 20:39:31, ?, 1, 24, ?, 2025-10-27 20:39:31), (24, 2025-10-27 20:39:31, ?, 1, 25, ?, 2025-10-27 20:39:31), (24, 2025-10-27 20:39:31, ?, 5, 26, ?, 2025-10-27 20:39:31), (26, 2025-10-27 20:39:31, ?, 1, 27, ?, 2025-10-27 20:39:31), (27, 2025-10-27 20:39:33, ?, 5, 28, ?, 2025-10-27 20:39:33), (27, 2025-10-27 20:39:33, ?, 7, 29, ?, 2025-10-27 20:39:33), (28, 2025-10-27 20:39:34, ?, 1, 30, ?, 2025-10-27 20:39:34), (29, 2025-10-27 20:39:34, ?, 2, 31, ?, 2025-10-27 20:39:34), (29, 2025-10-27 20:39:34, ?, 7, 32, ?, 2025-10-27 20:39:34), (30, 2025-10-27 20:39:34, ?, 2, 33, ?, 2025-10-27 20:39:34), (31, 2025-10-27 20:39:34, ?, 2, 34, ?, 2025-10-27 20:39:34), (31, 2025-10-27 20:39:34, ?, 7, 35, ?, 2025-10-27 20:39:34), (32, 2025-10-27 20:39:35, ?, 5, 36, ?, 2025-10-27 20:39:35), (33, 2025-10-27 20:39:35, ?, 4, 37, ?, 2025-10-27 20:39:35), (35, 2025-10-27 20:39:36, ?, 2, 38, ?, 2025-10-27 20:39:36), (35, 2025-10-27 20:39:36, ?, 6, 39, ?, 2025-10-27 20:39:36), (36, 2025-10-27 20:39:36, ?, 4, 40, ?, 2025-10-27 20:39:36), (36, 2025-10-27 20:39:36, ?, 6, 41, ?, 2025-10-27 20:39:36), (38, 2025-10-27 20:39:36, ?, 5, 42, ?, 2025-10-27 20:39:36), (39, 2025-10-27 20:39:37, ?, 8, 43, ?, 2025-10-27 20:39:37), (41, 2025-10-27 20:39:38, ?, 4, 44, ?, 2025-10-27 20:39:38), (41, 2025-10-27 20:39:38, ?, 5, 45, ?, 2025-10-27 20:39:38), (43, 2025-10-27 20:39:38, ?, 3, 46, ?, 2025-10-27 20:39:38), (44, 2025-10-27 20:39:38, ?, 2, 47, ?, 2025-10-27 20:39:38), (44, 2025-10-27 20:39:38, ?, 5, 48, ?, 2025-10-27 20:39:38), (46, 2025-10-27 20:39:39, ?, 7, 49, ?, 2025-10-27 20:39:39), (47, 2025-10-27 20:39:39, ?, 3, 50, ?, 2025-10-27 20:39:39), (49, 2025-10-27 20:39:39, ?, 5, 51, ?, 2025-10-27 20:39:39)) 📦 Migration de 'bon_commande_historiques' (164 lignes)... ⚠️ Erreur sur 'bon_commande_historiques': SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`esoftbursuivifac`.`bon_commande_historiques`, CONSTRAINT `bon_commande_historiques_bon_commande_id_foreign` FOREIGN KEY (`bon_commande_id`) REFERENCES `bon_commandes` (`id`) ON DELETE CASCA (Connection: mysql, SQL: insert into `bon_commande_historiques` (`ancien_statut`, `bon_commande_id`, `commentaire`, `created_at`, `id`, `nouveau_statut`, `type_statut`, `user_id`) values (?, 1, Création du bon de commande, 2025-10-27 20:39:26, 1, en_cours, traitement, 1), (?, 1, Création du bon de commande, 2025-10-27 20:39:26, 2, non_paye, paiement, 1), (?, 2, Création du bon de commande, 2025-10-27 20:39:26, 3, en_cours, traitement, 1), (?, 2, Création du bon de commande, 2025-10-27 20:39:26, 4, non_paye, paiement, 1), (?, 3, Création du bon de commande, 2025-10-27 20:39:27, 5, en_cours, traitement, 1), (?, 3, Création du bon de commande, 2025-10-27 20:39:27, 6, non_paye, paiement, 1), (?, 4, Création du bon de commande, 2025-10-27 20:39:27, 7, en_cours, traitement, 1), (?, 4, Création du bon de commande, 2025-10-27 20:39:27, 8, non_paye, paiement, 1), (?, 5, Création du bon de commande, 2025-10-27 20:39:27, 9, en_cours, traitement, 1), (?, 5, Création du bon de commande, 2025-10-27 20:39:27, 10, non_paye, paiement, 1), (?, 6, Création du bon de commande, 2025-10-27 20:39:27, 11, en_cours, traitement, 1), (?, 6, Création du bon de commande, 2025-10-27 20:39:27, 12, non_paye, paiement, 1), (?, 7, Création du bon de commande, 2025-10-27 20:39:27, 13, en_cours, traitement, 1), (?, 7, Création du bon de commande, 2025-10-27 20:39:27, 14, non_paye, paiement, 1), (?, 8, Création du bon de commande, 2025-10-27 20:39:28, 15, en_cours, traitement, 1), (?, 8, Création du bon de commande, 2025-10-27 20:39:28, 16, non_paye, paiement, 1), (?, 9, Création du bon de commande, 2025-10-27 20:39:28, 17, en_cours, traitement, 1), (?, 9, Création du bon de commande, 2025-10-27 20:39:28, 18, non_paye, paiement, 1), (?, 10, Création du bon de commande, 2025-10-27 20:39:28, 19, en_cours, traitement, 1), (?, 10, Création du bon de commande, 2025-10-27 20:39:28, 20, non_paye, paiement, 1), (?, 11, Création du bon de commande, 2025-10-27 20:39:28, 21, en_cours, traitement, 1), (?, 11, Création du bon de commande, 2025-10-27 20:39:28, 22, non_paye, paiement, 1), (?, 12, Création du bon de commande, 2025-10-27 20:39:28, 23, en_cours, traitement, 1), (?, 12, Création du bon de commande, 2025-10-27 20:39:28, 24, non_paye, paiement, 1), (?, 13, Création du bon de commande, 2025-10-27 20:39:29, 25, en_cours, traitement, 1), (?, 13, Création du bon de commande, 2025-10-27 20:39:29, 26, non_paye, paiement, 1), (?, 14, Création du bon de commande, 2025-10-27 20:39:29, 27, en_cours, traitement, 1), (?, 14, Création du bon de commande, 2025-10-27 20:39:29, 28, non_paye, paiement, 1), (?, 15, Création du bon de commande, 2025-10-27 20:39:29, 29, en_cours, traitement, 1), (?, 15, Création du bon de commande, 2025-10-27 20:39:29, 30, non_paye, paiement, 1), (?, 16, Création du bon de commande, 2025-10-27 20:39:29, 31, en_cours, traitement, 1), (?, 16, Création du bon de commande, 2025-10-27 20:39:29, 32, non_paye, paiement, 1), (?, 17, Création du bon de commande, 2025-10-27 20:39:29, 33, en_cours, traitement, 1), (?, 17, Création du bon de commande, 2025-10-27 20:39:29, 34, non_paye, paiement, 1), (?, 18, Création du bon de commande, 2025-10-27 20:39:29, 35, en_cours, traitement, 1), (?, 18, Création du bon de commande, 2025-10-27 20:39:29, 36, non_paye, paiement, 1), (?, 19, Création du bon de commande, 2025-10-27 20:39:30, 37, en_cours, traitement, 1), (?, 19, Création du bon de commande, 2025-10-27 20:39:30, 38, non_paye, paiement, 1), (?, 20, Création du bon de commande, 2025-10-27 20:39:30, 39, en_cours, traitement, 1), (?, 20, Création du bon de commande, 2025-10-27 20:39:30, 40, non_paye, paiement, 1), (?, 21, Création du bon de commande, 2025-10-27 20:39:30, 41, en_cours, traitement, 1), (?, 21, Création du bon de commande, 2025-10-27 20:39:30, 42, non_paye, paiement, 1), (en_cours, 21, En attente de réponse du fournisseur, 2025-11-03 20:39:30, 43, en_attente_fournisseur, traitement, 1), (?, 22, Création du bon de commande, 2025-10-27 20:39:30, 44, en_cours, traitement, 1), (?, 22, Création du bon de commande, 2025-10-27 20:39:30, 45, non_paye, paiement, 1), (en_cours, 22, En attente de réponse du fournisseur, 2025-11-01 20:39:30, 46, en_attente_fournisseur, traitement, 1), (?, 23, Création du bon de commande, 2025-10-27 20:39:31, 47, en_cours, traitement, 1), (?, 23, Création du bon de commande, 2025-10-27 20:39:31, 48, non_paye, paiement, 1), (en_cours, 23, En attente de réponse du fournisseur, 2025-10-31 20:39:31, 49, en_attente_fournisseur, traitement, 1), (non_paye, 23, Synchronisation automatique depuis facture, 2025-12-05 20:39:31, 50, partiel, paiement, ?), (?, 24, Création du bon de commande, 2025-10-27 20:39:31, 51, en_cours, traitement, 1), (?, 24, Création du bon de commande, 2025-10-27 20:39:31, 52, non_paye, paiement, 1), (en_cours, 24, En attente de réponse du fournisseur, 2025-10-30 20:39:31, 53, en_attente_fournisseur, traitement, 1), (?, 25, Création du bon de commande, 2025-10-27 20:39:31, 54, en_cours, traitement, 1), (?, 25, Création du bon de commande, 2025-10-27 20:39:31, 55, non_paye, paiement, 1), (en_cours, 25, En attente de réponse du fournisseur, 2025-11-05 20:39:31, 56, en_attente_fournisseur, traitement, 1), (?, 26, Création du bon de commande, 2025-10-27 20:39:31, 57, en_cours, traitement, 1), (?, 26, Création du bon de commande, 2025-10-27 20:39:31, 58, non_paye, paiement, 1), (en_cours, 26, En attente de réponse du fournisseur, 2025-10-30 20:39:31, 59, en_attente_fournisseur, traitement, 1), (?, 27, Création du bon de commande, 2025-10-27 20:39:33, 60, en_cours, traitement, 1), (?, 27, Création du bon de commande, 2025-10-27 20:39:34, 61, non_paye, paiement, 1), (en_cours, 27, En attente de réponse du fournisseur, 2025-11-06 20:39:33, 62, en_attente_fournisseur, traitement, 1), (non_paye, 27, Synchronisation automatique depuis facture, 2025-11-21 20:39:33, 63, partiel, paiement, ?), (?, 28, Création du bon de commande, 2025-10-27 20:39:34, 64, en_cours, traitement, 1), (?, 28, Création du bon de commande, 2025-10-27 20:39:34, 65, non_paye, paiement, 1), (en_cours, 28, En attente de réponse du fournisseur, 2025-10-31 20:39:34, 66, en_attente_fournisseur, traitement, 1), (non_paye, 28, Synchronisation automatique depuis facture, 2025-11-26 20:39:34, 67, partiel, paiement, ?), (?, 29, Création du bon de commande, 2025-10-27 20:39:34, 68, en_cours, traitement, 1), (?, 29, Création du bon de commande, 2025-10-27 20:39:34, 69, non_paye, paiement, 1), (en_cours, 29, En attente de réponse du fournisseur, 2025-10-31 20:39:34, 70, en_attente_fournisseur, traitement, 1), (?, 30, Création du bon de commande, 2025-10-27 20:39:34, 71, en_cours, traitement, 1), (?, 30, Création du bon de commande, 2025-10-27 20:39:34, 72, non_paye, paiement, 1), (en_cours, 30, En attente de réponse du fournisseur, 2025-11-06 20:39:34, 73, en_attente_fournisseur, traitement, 1), (?, 31, Création du bon de commande, 2025-10-27 20:39:34, 74, en_cours, traitement, 1), (?, 31, Création du bon de commande, 2025-10-27 20:39:35, 75, non_paye, paiement, 1), (en_cours, 31, Livraison effectuée, 2025-11-24 20:39:34, 76, livre, traitement, 1), (non_paye, 31, Synchronisation automatique depuis facture, 2025-12-21 20:39:34, 77, paye, paiement, ?), (?, 32, Création du bon de commande, 2025-10-27 20:39:35, 78, en_cours, traitement, 1), (?, 32, Création du bon de commande, 2025-10-27 20:39:35, 79, non_paye, paiement, 1), (en_cours, 32, Livraison effectuée, 2025-11-11 20:39:35, 80, livre, traitement, 1), (non_paye, 32, Synchronisation automatique depuis facture, 2025-11-24 20:39:35, 81, partiel, paiement, ?), (?, 33, Création du bon de commande, 2025-10-27 20:39:35, 82, en_cours, traitement, 1), (?, 33, Création du bon de commande, 2025-10-27 20:39:35, 83, non_paye, paiement, 1), (en_cours, 33, Livraison effectuée, 2025-12-04 20:39:35, 84, livre, traitement, 1), (non_paye, 33, Synchronisation automatique depuis facture, 2025-12-28 20:39:35, 85, paye, paiement, ?), (?, 34, Création du bon de commande, 2025-10-27 20:39:35, 86, en_cours, traitement, 1), (?, 34, Création du bon de commande, 2025-10-27 20:39:36, 87, non_paye, paiement, 1), (en_cours, 34, Livraison effectuée, 2025-12-05 20:39:35, 88, livre, traitement, 1), (?, 35, Création du bon de commande, 2025-10-27 20:39:36, 89, en_cours, traitement, 1), (?, 35, Création du bon de commande, 2025-10-27 20:39:36, 90, non_paye, paiement, 1), (en_cours, 35, Livraison effectuée, 2025-11-30 20:39:36, 91, livre, traitement, 1), (?, 36, Création du bon de commande, 2025-10-27 20:39:36, 92, en_cours, traitement, 1), (?, 36, Création du bon de commande, 2025-10-27 20:39:36, 93, non_paye, paiement, 1), (en_cours, 36, Livraison effectuée, 2025-12-01 20:39:36, 94, livre, traitement, 1), (non_paye, 36, Synchronisation automatique depuis facture, 2025-12-09 20:39:36, 95, partiel, paiement, ?), (?, 37, Création du bon de commande, 2025-10-27 20:39:36, 96, en_cours, traitement, 1), (?, 37, Création du bon de commande, 2025-10-27 20:39:36, 97, non_paye, paiement, 1), (en_cours, 37, Livraison effectuée, 2025-11-20 20:39:36, 98, livre, traitement, 1), (non_paye, 37, Synchronisation automatique depuis facture, 2025-12-07 20:39:36, 99, partiel, paiement, ?), (?, 38, Création du bon de commande, 2025-10-27 20:39:37, 100, en_cours, traitement, 1)) 📦 Migration de 'conf_odoos' (1 lignes)... ⚠️ Erreur sur 'conf_odoos': SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'conf_odoos.PRIMARY' (Connection: mysql, SQL: insert into `conf_odoos` (`apiKey`, `created_at`, `db`, `id`, `isActive`, `updated_at`, `url`, `userName`) values (d932eaad46a533f56b451651344731cc67d55cd8, 2025-08-29 14:39:51, esoft, 1, 1, 2025-11-12 21:21:51, https://esoft.odoo.com, esoftbf@gmail.com)) 📦 Migration de 'configurations_metier' (4 lignes)... ⚠️ Erreur sur 'configurations_metier': SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'configurations_metier.PRIMARY' (Connection: mysql, SQL: insert into `configurations_metier` (`cle`, `created_at`, `description`, `groupe`, `id`, `type`, `updated_at`, `valeur`) values (taux_tva, 2025-10-05 23:38:36, Taux de TVA en pourcentage (Burkina Faso: 18%), fiscalite, 1, number, 2025-10-05 23:38:36, 18), (devise, 2025-10-05 23:38:38, Nom complet de la devise utilisée, monetaire, 2, string, 2025-10-05 23:38:38, Franc CFA), (code_devise, 2025-10-05 23:38:38, Code ISO de la devise (XOF = Franc CFA), monetaire, 3, string, 2025-10-05 23:38:38, XOF), (symbole_devise, 2025-10-05 23:38:38, Symbole affiché pour la devise, monetaire, 4, string, 2025-10-05 23:38:38, XOF)) ✅ Migration terminée !