49 lines
3.2 KiB
SQL
49 lines
3.2 KiB
SQL
-- MSIN-4448 — Edition inline dossard / remis dans la liste + libelles droits / Info
|
|
-- Prefrequis : permissions inscriptions_gestion.bib_edit / bib_remis (phase 2 acces v2)
|
|
-- Idempotent (UPDATE permissions + DELETE/INSERT info)
|
|
|
|
/* ------------------------------------------------------------------
|
|
1. Clarifier les droits kits : lecture seule = sans la case ;
|
|
lecture-ecriture = case cochee (liste + fiche).
|
|
------------------------------------------------------------------ */
|
|
UPDATE `inscriptions_eve_permissions`
|
|
SET
|
|
`perm_label_fr` = 'Gestion inscription : no dossard (liste + fiche)',
|
|
`perm_label_en` = 'Registration mgmt: bib number (list + sheet)',
|
|
`perm_description_fr` = 'Modifier le numero de dossard dans la liste et sur la fiche (lecture seule si non coche)',
|
|
`perm_description_en` = 'Edit bib number in the list and on the sheet (read-only if unchecked)'
|
|
WHERE `perm_key` = 'inscriptions_gestion.bib_edit';
|
|
|
|
UPDATE `inscriptions_eve_permissions`
|
|
SET
|
|
`perm_label_fr` = 'Gestion inscription : dossard remis (liste + fiche)',
|
|
`perm_label_en` = 'Registration mgmt: bib handed out (list + sheet)',
|
|
`perm_description_fr` = 'Marquer dossard remis dans la liste et sur la fiche (lecture seule si non coche)',
|
|
`perm_description_en` = 'Mark bib handed out in the list and on the sheet (read-only if unchecked)'
|
|
WHERE `perm_key` = 'inscriptions_gestion.bib_remis';
|
|
|
|
/* ------------------------------------------------------------------
|
|
2. Libelles Info (confirmation remis + OK)
|
|
------------------------------------------------------------------ */
|
|
DELETE FROM info
|
|
WHERE info_prg = 'compte.php'
|
|
AND info_clef IN (
|
|
'inscr_gestion_bib_ok',
|
|
'inscr_gestion_remis_confirm_title',
|
|
'inscr_gestion_remis_confirm_msg',
|
|
'inscr_gestion_remis_confirm_ok',
|
|
'inscr_gestion_remis_confirm_cancel'
|
|
);
|
|
|
|
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) VALUES
|
|
('inscr_gestion_bib_ok', 'fr', 'OK', '', 'compte.php', 'MSIN-4448', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_bib_ok', 'en', 'OK', '', 'compte.php', 'MSIN-4448', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_remis_confirm_title', 'fr', 'Confirmation', '', 'compte.php', 'MSIN-4448', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_remis_confirm_title', 'en', 'Confirmation', '', 'compte.php', 'MSIN-4448', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_remis_confirm_msg', 'fr', 'Êtes-vous certain de vouloir retirer la mention « dossard récupéré » pour ce participant ?', '', 'compte.php', 'MSIN-4448', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_remis_confirm_msg', 'en', 'Are you sure you want to remove the "bib retrieved" status for this participant?', '', 'compte.php', 'MSIN-4448', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_remis_confirm_ok', 'fr', 'Retirer', '', 'compte.php', 'MSIN-4448', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_remis_confirm_ok', 'en', 'Remove', '', 'compte.php', 'MSIN-4448', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_remis_confirm_cancel', 'fr', 'Annuler', '', 'compte.php', 'MSIN-4448', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_remis_confirm_cancel', 'en', 'Cancel', '', 'compte.php', 'MSIN-4448', 0, 1, '', '', '', NOW());
|