25 Commits

Author SHA1 Message Date
f2ca7fc2cc MSIN-4520 — Implement lightweight Excel sheet inventory and sampling functions to avoid timeouts on large multi-sheet files. Update version code to 4.72.901. 2026-07-29 15:53:57 -04:00
b9623f6c62 MSIN-4520 — Improve AJAX status refresh functionality with visual feedback during database updates. Increment version code to 4.72.899. 2026-07-29 12:09:37 -04:00
4f686375d6 MSIN-4521 — Add emergency contact fields to participant profiles, including name and telephone. Update related UI elements and SQL queries for data handling. Increment version code to 4.72.897. 2026-07-29 12:07:48 -04:00
e8b92c9d9f MSIN-4520 — Fix reset import button: visible feedback, clear stuck busy overlay, recount via AJAX.
Co-authored-by: Cursor <cursoragent@cursor.com>
2026-07-29 11:59:38 -04:00
549fcc0dc5 MSIN-4520 — Add UI enhancements for anomaly handling during import, including a banner for displaying anomaly counts and a download button for CSV files. Update version code to 4.72.895. 2026-07-29 11:53:26 -04:00
865c5be52c MSIN-4520 — Enhance birthdate parsing to support various formats and add functionality for downloading CSV of import anomalies. Update version code to 4.72.894. 2026-07-29 11:42:21 -04:00
98dd17379d MSIN-4514 — Enhance question sorting to include participant info fields and improve SQL queries for better handling of NULL values. Increment version code to 4.72.891. 2026-07-29 10:43:35 -04:00
c86c1ed215 MSIN-4520 — Implement dropdown mappings for countries and provinces in the import process. Enhance mapping logic to support both automatic and manual resolution of country and province IDs. Increment version code to 4.72.885. 2026-07-29 09:33:39 -04:00
1590295f6e MSIN-4520 — Add support for region (pro_id) and country (pay_id) in import process. Implement functions to repair mojibake issues and normalize keys for bilingual headers. Increment version code to 4.72.884. 2026-07-29 09:27:31 -04:00
6fa9377397 Enhance Excel import process by implementing automatic reapplication of event profiles based on sheet configurations. Update metadata handling to include sheet details and improve mapping logic for multi-sheet scenarios. Increment version code to 4.72.883. 2026-07-28 21:26:38 -04:00
dc86373b2a Enhance Excel import functionality by adding support for multi-sheet selection and improved metadata handling. Update AJAX import process to accommodate new sheet options. Increment version code to 4.72.882. 2026-07-28 18:12:27 -04:00
a68f54be80 Refactor fxImportResultatsSaveQuestionAnswer to ensure que_actif is set correctly during question updates and insertions. Simplify SQL logic for handling pec_id and improve error handling for database queries in fxInscrGestionFetchFicheProfile. Increment version code. 2026-07-24 17:53:03 -04:00
038bd7bd26 Implement fxImportResultatsEnsureQuestionsVisibleFiche function to activate questions during import for MSIN-4482. Update SQL queries to manage visibility of questions based on event type and ensure correct filtering of pec_id. Adjust logic in fxInscrGestionFetchFicheProfile to accommodate non-online registration scenarios. Increment version code. 2026-07-24 17:49:14 -04:00
69a97c0044 Enhance import functionality for events without online registration in MSIN-4482. Introduce new SQL queries and functions to manage event types and guard against invalid imports. Update AJAX handling to enforce type restrictions and improve user feedback in the event panel. Increment version code. 2026-07-24 17:45:47 -04:00
26a470fe1e Refactor fxImportResultatsCommit to improve handling of pec_id and pec_id_original during imports for MSIN-4482. Update SQL queries to ensure pec_actif is set correctly and prevent collisions with unique constraints. Enhance logic for updating participant records based on active status and original IDs. Increment version code. 2026-07-24 17:31:48 -04:00
80c791c7e1 Enhance fxImportResultatsCommit and fxImportResultatsReset functions for MSIN-4482 by updating SQL queries to ensure correct handling of pec_id_original and pec_actif flags during imports. Refactor participant deletion logic to improve performance using subqueries. Add diagnostic SQL for verifying import integrity. Increment version code. 2026-07-24 17:20:19 -04:00
05ce600e09 Refactor fxImportResultatsResetPreview to improve SQL query readability and performance by storing the escaped origin in a variable. Add diagnostic SQL query to count visible participants in the list based on active PEC status. Enhance the event panel UI to display database status with refresh functionality. Increment version code. 2026-07-24 17:06:46 -04:00
c6477f7757 Enhance result import functionality for MSIN-4482 by adding reset and preview capabilities. Implement fxImportResultatsResetPreview to count potential deletions and fxImportResultatsReset to remove imported data based on confirmation. Update AJAX handling in ajax_import_resultats.php to support these new actions. Ensure pec_actif is set to 1 for active entries in the import process. Increment version code. 2026-07-24 17:02:55 -04:00
8498af24f9 Implement fxImportResultatsGroupBlockedByType function to categorize and handle blocked import rows in fxImportResultats for MSIN-4482. Enhance error reporting by adding detailed messages for header rows, missing unique identifiers, unmapped races, and database update failures. Update the commit function to utilize the new error handling structure. Increment version code. 2026-07-24 16:26:45 -04:00
171a48a411 Add temporary unique ID generation for pec_id_original and par_id_original in fxImportResultats for MSIN-4482. Implement fxImportResultatsTempOriginalId function to ensure non-zero unique values during insertion. Update SQL queries to utilize generated IDs. Increment version code. 2026-07-24 16:22:28 -04:00
d63c92e36a Implement header row filtering and unique identifier generation in fxImportResultats for MSIN-4482. Add functions to detect header-like rows and create unique panier/commande identifiers. Enhance error handling during database operations. Increment version code. 2026-07-24 16:19:54 -04:00
8929236e85 Enhance participant import functionality in MSIN-4482 by updating the import phases and adding new fields for emergency contact details. Implement commit action in AJAX handling for result mapping validation. Increment version code. 2026-07-24 16:16:00 -04:00
84e65340b6 Enhance fxImportResultatsRenderEventPanel and ajax_import_resultats.php for improved AJAX handling in MSIN-4482. Update AJAX URL construction to include domain, add error handling for JSON parsing, and ensure panel visibility. Implement output buffering to prevent HTML pollution in JSON responses. Increment version code. 2026-07-24 16:09:37 -04:00
a1b6fa8911 Refactor fxImportResultatsComIdForEve to use org_id instead of com_id for event sharing templates in MSIN-4482. Update SQL queries and comments for clarity. Ensure compatibility with legacy data structures. Increment version code. 2026-07-24 15:44:25 -04:00
1ca75a4ed4 Implement UI enhancements for participant import without transaction in MSIN-4482. Add new styles for import dropzone and integrate import functionality into event management panel. Update navigation for improved access to import features. Increment version code. 2026-07-24 15:39:50 -04:00