stephan
0c1fc53331
This commit adds new JavaScript functions to manage pending bib assignments and alert users when automatic activation is blocked due to unassigned registrations. The PHP code is updated to include a new function that verifies all bibs are assigned before allowing auto activation. Additionally, the version code is incremented to 4.72.664 to reflect these changes, improving the overall functionality and user experience in the bib assignment process.
18 lines
2.3 KiB
SQL
18 lines
2.3 KiB
SQL
-- MSIN-4379 — Assignation auto : refus si des inscriptions n'ont pas encore de dossard
|
|
|
|
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_ajax_auto_pending_bibs', 'fr', 'Terminez d''assigner les dossards à toutes les inscriptions de cette épreuve avant d''activer l''assignation automatique.\n\n%d inscription(s) sans dossard.', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'bib_v4_ajax_auto_pending_bibs' 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_ajax_auto_pending_bibs', 'en', 'Finish assigning bib numbers to all registrations in this race before enabling automatic assignment.\n\n%d registration(s) without a bib number.', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'bib_v4_ajax_auto_pending_bibs' 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_js_auto_pending_bibs', 'fr', 'Terminez d''assigner les dossards à toutes les inscriptions de cette épreuve avant d''activer l''assignation automatique.\n\n%d inscription(s) sans dossard.', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'bib_v4_js_auto_pending_bibs' 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_js_auto_pending_bibs', 'en', 'Finish assigning bib numbers to all registrations in this race before enabling automatic assignment.\n\n%d registration(s) without a bib number.', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'bib_v4_js_auto_pending_bibs' AND info_langue = 'en' AND info_prg = 'compte.php');
|