-- ============================================================
-- XUNTU — Hausa UI Translation Strings
-- Table: translations (columns: lang, t_key, t_value)
-- Run after political_website.sql to populate Hausa strings.
-- ============================================================
-- NOTE: These are placeholder translations. All Hausa text
-- MUST be reviewed and verified by a native Hausa speaker
-- or certified translator before publication.
-- ============================================================

INSERT INTO translations (lang, t_key, t_value) VALUES

-- ── Navigation ───────────────────────────────────────────────────────────────
('ha', 'nav_home',           'Gida'),
('ha', 'nav_about',          'Game da Mu'),
('ha', 'nav_journey',        'Tafiyar Shugabanci'),
('ha', 'nav_projects',       'Ayyuka'),
('ha', 'nav_priorities',     'Fifikon Manufa'),
('ha', 'nav_communities',    'Al\'ummomin'),
('ha', 'nav_news',           'Labarai'),
('ha', 'nav_media',          'Kafafen Yada Labarai'),
('ha', 'nav_events',         'Taron'),
('ha', 'nav_contact',        'Tuntuɓa'),
('ha', 'nav_submit_request', 'Ƙaddamar da Buƙatar Al\'umma'),

-- ── Common buttons ───────────────────────────────────────────────────────────
('ha', 'btn_read_more',      'Karanta Ƙari'),
('ha', 'btn_view_all',       'Duba Duka'),
('ha', 'btn_back',           'Komawa'),
('ha', 'btn_submit',         'Ƙaddamar'),
('ha', 'btn_share',          'Raba'),
('ha', 'btn_download',       'Zazzaɓi'),
('ha', 'btn_print',          'Bugawa'),

-- ── Homepage sections ────────────────────────────────────────────────────────
('ha', 'hero_subtitle',      'Tsohon Shugaban LGA na Kubau & Tsohon Babban Mai Ƙididdiga na Jihar Kaduna'),
('ha', 'hero_intro',         'Ginin ƙwarewa ta gudanarwa, kula da kudi, da bunƙasar al\'umma a fadin Kubau da Ikara.'),
('ha', 'btn_view_profile',   'Duba Tarihin Shugabanci'),
('ha', 'btn_explore_projects', 'Bincika Ayyukan Al\'umma'),

('ha', 'section_about',      'Aiki a Hidimar Jama\'a'),
('ha', 'section_projects',   'Ayyukan Raya Al\'umma'),
('ha', 'section_priorities', 'Manufofin Jagoran'),
('ha', 'section_news',       'Labarai da Wayar da Jama\'a'),
('ha', 'section_events',     'Tarurruka Masu Zuwa'),
('ha', 'section_gallery',    'Dakin Hotuna'),
('ha', 'section_request',    'Raba Buƙatar Raya Al\'umma'),
('ha', 'section_testimonials', 'Muryoyin Al\'umma'),

-- ── Projects ─────────────────────────────────────────────────────────────────
('ha', 'projects_filter_all',     'Dukan Ayyuka'),
('ha', 'projects_filter_kubau',   'Kubau LGA'),
('ha', 'projects_filter_ikara',   'Ikara LGA'),
('ha', 'projects_no_results',     'Ba a sami ayyuka da suka dace ba.'),
('ha', 'project_status_proposed',         'An Tsara'),
('ha', 'project_status_planned',          'An Shirya'),
('ha', 'project_status_ongoing',          'Yana Gudana'),
('ha', 'project_status_completed',        'An Kammala'),
('ha', 'project_status_commissioned',     'An Buɗe'),
('ha', 'project_status_under_maintenance','Cikin Kulawa'),
('ha', 'project_status_delayed',          'An Jinkira'),
('ha', 'project_status_suspended',        'An Dakatar'),
('ha', 'project_status_archived',         'An Adana'),
('ha', 'project_beneficiaries',   'Masu Amfana'),
('ha', 'project_budget',          'Kasafin Kuɗi'),
('ha', 'project_location',        'Wuri'),
('ha', 'project_lga',             'Gundumar Kananan Hukumomi'),
('ha', 'project_completion',      'Gudummawar Kammala'),

-- ── News ─────────────────────────────────────────────────────────────────────
('ha', 'news_read_full',     'Karanta Cikakken Labari'),
('ha', 'news_published',     'An Buga'),
('ha', 'news_author',        'Marubuci'),
('ha', 'news_share',         'Raba Wannan Labari'),
('ha', 'news_related',       'Labarai Masu Dangantaka'),

-- ── Events ───────────────────────────────────────────────────────────────────
('ha', 'event_date',         'Kwanan Wata'),
('ha', 'event_time',         'Lokaci'),
('ha', 'event_venue',        'Wuri na Taron'),
('ha', 'event_add_calendar', 'Ƙara zuwa Kalandar'),
('ha', 'event_free',         'Kyauta'),
('ha', 'event_register',     'Yi Rajista'),

-- ── Contact form ─────────────────────────────────────────────────────────────
('ha', 'contact_name',       'Cikakken Suna'),
('ha', 'contact_email',      'Adireshin Email'),
('ha', 'contact_phone',      'Lambar Waya'),
('ha', 'contact_subject',    'Jigo'),
('ha', 'contact_message',    'Sako'),
('ha', 'contact_send',       'Aika Sako'),
('ha', 'contact_success',    'Na gode da saƙonku. Za mu mayar da amsa a cikin kwanaki 2–3 na aiki.'),
('ha', 'contact_error',      'An sami kuskure. Don Allah sake gwadawa.'),

-- ── Community request ────────────────────────────────────────────────────────
('ha', 'request_name',       'Cikakken Suna'),
('ha', 'request_phone',      'Lambar Waya'),
('ha', 'request_email',      'Adireshin Email (Ba tilas ba)'),
('ha', 'request_lga',        'Gundumar Kananan Hukumomi'),
('ha', 'request_ward',       'Wad'),
('ha', 'request_community',  'Al\'umma'),
('ha', 'request_category',   'Nau\'in Buƙata'),
('ha', 'request_title',      'Take na Buƙata'),
('ha', 'request_description','Bayani Mai Ƙari'),
('ha', 'request_location',   'Wuri ko Alama ta Ƙasa'),
('ha', 'request_anonymous',  'Ƙaddamar ba tare da bayyana sunana ba'),
('ha', 'request_consent',    'Na yarda da ƙaddamar da wannan buƙata'),
('ha', 'request_submit',     'Ƙaddamar da Buƙata'),
('ha', 'request_tracking',   'Lambar Bin Diddigin'),
('ha', 'request_success',    'An sami buƙatarku da kyau. Lambar bin diddiginku ita ce:'),

-- ── Newsletter ───────────────────────────────────────────────────────────────
('ha', 'newsletter_heading', 'Kasance Cikin Sani'),
('ha', 'newsletter_sub',     'Karɓi sabuntawar da aka tabbatar game da ayyukan al\'umma, tarurruka, da tarattaren jama\'a.'),
('ha', 'newsletter_name',    'Cikakken Suna'),
('ha', 'newsletter_email',   'Adireshin Email'),
('ha', 'newsletter_btn',     'Yi Biyan Diyya'),
('ha', 'newsletter_consent', 'Na yarda da karɓar sabuntawa. Zan iya soke biyan diyya a kowane lokaci.'),
('ha', 'newsletter_success', 'Na gode! An tabbatar da biyan diyyarku.'),

-- ── Footer ───────────────────────────────────────────────────────────────────
('ha', 'footer_quick_links', 'Hanyoyin Gaggawa'),
('ha', 'footer_media',       'Labarai da Kafafen Yada Labarai'),
('ha', 'footer_info',        'Bayani'),
('ha', 'footer_contact',     'Tuntuɓa'),
('ha', 'footer_disclaimer',  'Bayanan ayyuka a wannan shafin ya dogara ne akan rikodin da aka tabbatar kuma manajan shafin ya amince dasu.'),

-- ── Verification badges ──────────────────────────────────────────────────────
('ha', 'verif_unverified',           'Ba a Tabbatar'),
('ha', 'verif_under_verification',   'Ana Tabbatarwa'),
('ha', 'verif_verified_internally',  'An Tabbatar Cikin Gida'),
('ha', 'verif_verified_with_docs',   'An Tabbatar da Takardun'),
('ha', 'verif_independently_confirmed', 'An Tabbatar Kai Tsaye'),
('ha', 'verif_disputed',             'Akwai Sabani'),
('ha', 'verif_withdrawn',            'An Janye'),

-- ── Accessibility ────────────────────────────────────────────────────────────
('ha', 'a11y_increase_text',   'Ƙara Girman Rubutu'),
('ha', 'a11y_decrease_text',   'Rage Girman Rubutu'),
('ha', 'a11y_high_contrast',   'Canjawa zuwa Babban Bambanci'),
('ha', 'a11y_grayscale',       'Canjawa zuwa Farin-Baki'),
('ha', 'a11y_underline_links', 'Layi Ƙarƙashin Hanyoyin Haɗi'),
('ha', 'a11y_reset',           'Mayar da Saitunan Isa'),

-- ── Translation fallback notice ──────────────────────────────────────────────
('ha', 'translation_pending',  'Ana shirya fassarar Hausa.')

ON DUPLICATE KEY UPDATE t_value = VALUES(t_value);

-- ── Additional navigation strings ────────────────────────────────────────────
INSERT INTO translations (lang, t_key, t_value) VALUES
('ha', 'nav_search',         'Bincika…')
ON DUPLICATE KEY UPDATE t_value = VALUES(t_value);