Changeset 5e61b17 in Klonkt for src/routes/lang.js

Timestamp:

06/21/2026 03:16:51 PM (3 months ago)

Author:

roboburr <roboburr@…>

Branches:

main

Children:

11b3ba5

Parents:

4885eab

Message:

feat(i18n): admin-configurable language — personal + default for visitors

• users.lang column: personal interface language per account (follows across devices/sessions). Switcher (/lang/:code) and Account select both write it.
• app_setting default_lang: admin picks the default language for visitors in Admin → Settings (overrides env/browser; empty = automatic).
• resolveLang priority: session choice → users.lang → default_lang (DB) → env KLONKT_DEFAULT_LANG → browser → nl.
• Account: language select; admin-settings: default language select. NL/EN/DE keys.

Co-Authored-By: Claude <noreply@…>

File:

• src/routes/lang.js (modified) (2 diffs)

src/routes/lang.js

@@ -3 +3 @@
 import express from 'express';
 import { SUPPORTED } from '../services/i18n.js';
+import db from '../config/database.js';
 
 const router = express.Router();
@@ -9 +10 @@
   const code = SUPPORTED.includes(req.params.code) ? req.params.code : 'nl';
   if (req.session) req.session.lang = code;
+  // Ingelogd? Bewaar de keuze ook op het account zodat 'ie meereist over
+  // apparaten/sessies (niet alleen deze sessie-cookie).
+  if (req.session && req.session.user && req.session.user.id) {
+    try {
+      db.prepare('UPDATE users SET lang = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ?').run(code, req.session.user.id);
+      req.session.user.lang = code;
+    } catch { /* lang-kolom ontbreekt op een oude DB → sessie-only, geen breuk */ }
+  }
   // Veilige terug-URL: alleen een intern pad (geen open redirect).
   let back = (typeof req.query.r === 'string') ? req.query.r : '';