stephan
27e581c40a
This commit introduces a locking feature for bib ranges, allowing users to lock or unlock sequences via a new AJAX endpoint. The PHP code is updated to check for locked statuses before performing actions, enhancing data integrity. Additionally, new JavaScript functions are added to handle user interactions for locking and unlocking, along with corresponding CSS styles for visual feedback. This improves the user experience by preventing modifications to locked sequences and providing clear confirmation messages.
44 lines
6.0 KiB
SQL
44 lines
6.0 KiB
SQL
-- MSIN-4379 — i18n verrouillage séquences de dossards
|
|
|
|
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_col_lock', 'fr', '', 'Verrouiller ou déverrouiller la séquence.', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'bib_v4_col_lock' 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_col_lock', 'en', '', 'Lock or unlock the sequence.', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'bib_v4_col_lock' 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_tip_lock_open', 'fr', 'Séquence ouverte', 'Cliquez pour verrouiller : la plage, les dossards et les assignations ne pourront plus être modifiés.', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'bib_v4_tip_lock_open' 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_tip_lock_open', 'en', 'Sequence unlocked', 'Click to lock: range, bibs and assignments can no longer be changed.', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'bib_v4_tip_lock_open' 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_tip_lock_closed', 'fr', 'Séquence verrouillée', 'Cliquez pour déverrouiller (confirmation requise).', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'bib_v4_tip_lock_closed' 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_tip_lock_closed', 'en', 'Sequence locked', 'Click to unlock (confirmation required).', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'bib_v4_tip_lock_closed' 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_lock_confirm', 'fr', 'Verrouiller cette séquence ?\n\nTant qu''elle est verrouillée, vous ne pourrez plus modifier la plage de numéros, supprimer la séquence, réinitialiser les dossards ni l''utiliser pour l''assignation automatique ou groupée.', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'bib_v4_js_lock_confirm' 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_lock_confirm', 'en', 'Lock this sequence?\n\nWhile locked, you cannot change the number range, delete the sequence, reset bibs, or use it for automatic or batch assignment.', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'bib_v4_js_lock_confirm' 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_unlock_confirm', 'fr', 'Déverrouiller cette séquence ?\n\nAttention : des dossards peuvent déjà avoir été imprimés ou communiqués. Déverrouiller pourrait compromettre la cohérence de vos données.\n\nConfirmez-vous le déverrouillage ?', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'bib_v4_js_unlock_confirm' 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_unlock_confirm', 'en', 'Unlock this sequence?\n\nWarning: bibs may already have been printed or distributed. Unlocking could compromise your data.\n\nDo you confirm unlocking?', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'bib_v4_js_unlock_confirm' 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_ajax_range_locked', 'fr', 'Cette séquence est verrouillée et ne peut pas être modifiée', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'bib_v4_ajax_range_locked' 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_range_locked', 'en', 'This sequence is locked and cannot be modified', '', 'compte.php', '', 0, 1, '', '', '', NOW()
|
|
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'bib_v4_ajax_range_locked' AND info_langue = 'en' AND info_prg = 'compte.php');
|