Files
ms1inscription-v5/sql/MSIN-4405-bib-anomalies-orphan-cause.sql
stephan 0d01affb89 Refactor cancellation cause handling and localization for orphan bibs, update version code to 4.72.773
This commit simplifies the cancellation cause logic by removing references to 'modif' and updating related localization keys to focus on 'annule' and 'transfert'. CSS comments and SQL scripts are also adjusted to reflect these changes, enhancing clarity and consistency in the user interface. The version code is incremented to 4.72.773 to reflect these updates.
2026-07-09 10:47:53 -04:00

19 lines
2.2 KiB
SQL

-- MSIN-4405 — Orphelins dossards : libellés alignés sur fxGetAnnulationCause (annule / transfert)
-- Idempotent
INSERT INTO info (info_clef, info_langue, info_texte, info_aide, info_prg, info_description, info_trie, info_actif, info_option1, info_option2, info_option3, info_creation)
SELECT 'bib_v4_anomalies_orphan_annule', 'fr', 'Annulée — dossard encore en séquence', 'Inscription annulée dont le numéro occupe encore une place dans la séquence.', 'compte.php', '', 0, 1, '', '', '', NOW()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'bib_v4_anomalies_orphan_annule' AND info_langue = 'fr' AND info_prg = 'compte.php');
INSERT INTO info (info_clef, info_langue, info_texte, info_aide, info_prg, info_description, info_trie, info_actif, info_option1, info_option2, info_option3, info_creation)
SELECT 'bib_v4_anomalies_orphan_annule', 'en', 'Cancelled — bib still in sequence', 'Cancelled registration whose bib number still occupies a slot in the sequence.', 'compte.php', '', 0, 1, '', '', '', NOW()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'bib_v4_anomalies_orphan_annule' AND info_langue = 'en' AND info_prg = 'compte.php');
INSERT INTO info (info_clef, info_langue, info_texte, info_aide, info_prg, info_description, info_trie, info_actif, info_option1, info_option2, info_option3, info_creation)
SELECT 'bib_v4_anomalies_orphan_transfert', 'fr', 'Transférée — dossard conservé', 'Ancienne transaction transférée, numéro encore dans la séquence.', 'compte.php', '', 0, 1, '', '', '', NOW()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'bib_v4_anomalies_orphan_transfert' AND info_langue = 'fr' AND info_prg = 'compte.php');
INSERT INTO info (info_clef, info_langue, info_texte, info_aide, info_prg, info_description, info_trie, info_actif, info_option1, info_option2, info_option3, info_creation)
SELECT 'bib_v4_anomalies_orphan_transfert', 'en', 'Transferred — bib kept', 'Former transferred transaction, bib still in the sequence.', 'compte.php', '', 0, 1, '', '', '', NOW()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'bib_v4_anomalies_orphan_transfert' AND info_langue = 'en' AND info_prg = 'compte.php');