Files
ms1inscription-v5/sql/MSIN-4401-inscr-gestion-bib-scan-i18n.sql

62 lines
5.0 KiB
SQL

-- MSIN-4401 — Libellés Info scan dossard + pastille filtres liste
-- Prérequis : aucun (complète MSIN-inscriptions-mobile-qr-i18n / v2-info-complet)
-- Idempotent (DELETE + INSERT). Corrige les textes manquants ou corrompus (clef brute).
DELETE FROM info
WHERE info_prg = 'compte.php'
AND info_clef IN (
'inscr_gestion_bib_scan_btn',
'inscr_gestion_bib_scan_hint',
'inscr_gestion_bib_scan_ready',
'inscr_gestion_bib_scan_tap',
'inscr_gestion_bib_scan_scanning',
'inscr_gestion_bib_scan_loading',
'inscr_gestion_bib_scan_found',
'inscr_gestion_bib_scan_found_search',
'inscr_gestion_bib_scan_invalid',
'inscr_gestion_bib_ocr_not_configured',
'inscr_gestion_bib_ocr_vision_prefix',
'inscr_gestion_bib_ocr_image_invalid',
'inscr_gestion_bib_ocr_network',
'inscr_gestion_list_filter_kv',
'inscr_gestion_bib_match_exact',
'inscr_gestion_bib_match_partial',
'inscr_gestion_bib_match_aria'
);
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_scan_btn', 'fr', 'Scanner le numéro', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_scan_btn', 'en', 'Scan number', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_scan_hint', 'fr', 'Cadrez le numéro dans le cadre, puis touchez l''image.', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_scan_hint', 'en', 'Frame the number in the box, then tap the image.', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_scan_ready', 'fr', 'Touchez l''image pour lire', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_scan_ready', 'en', 'Tap the image to read', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_scan_tap', 'fr', 'Touchez pour lire', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_scan_tap', 'en', 'Tap to read', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_scan_scanning', 'fr', 'Lecture en cours...', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_scan_scanning', 'en', 'Reading...', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_scan_loading', 'fr', 'Initialisation (1re fois)...', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_scan_loading', 'en', 'Initializing (first time)...', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_scan_found', 'fr', 'Numéro %s détecté — validez avec OK.', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_scan_found', 'en', 'Number %s detected — press OK.', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_scan_found_search', 'fr', 'Numéro %s détecté — recherche...', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_scan_found_search', 'en', 'Number %s detected — searching...', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_scan_invalid', 'fr', 'Numéro illisible. Cadrez un seul numéro.', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_scan_invalid', 'en', 'Unreadable number. Frame a single number.', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_ocr_not_configured', 'fr', 'OCR non configuré (clé Vision absente sur le serveur).', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_ocr_not_configured', 'en', 'OCR not configured (Vision API key missing on server).', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_ocr_vision_prefix', 'fr', 'Erreur Vision : ', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_ocr_vision_prefix', 'en', 'Vision error: ', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_ocr_image_invalid', 'fr', 'Image invalide.', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_ocr_image_invalid', 'en', 'Invalid image capture.', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_ocr_network', 'fr', 'Erreur réseau ou capture.', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_ocr_network', 'en', 'Network or capture error.', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_list_filter_kv', 'fr', '%s : %s', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_list_filter_kv', 'en', '%s: %s', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_match_exact', 'fr', 'Exact', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_match_exact', 'en', 'Exact', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_match_partial', 'fr', 'Partiel', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_match_partial', 'en', 'Partial', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_match_aria', 'fr', 'Mode de recherche du dossard', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
('inscr_gestion_bib_match_aria', 'en', 'Bib search mode', '', 'compte.php', '', 0, 1, '', '', '', NOW());