Changeset 6e0249f in Klonkt for src/routes/hub.js

Timestamp:

06/14/2026 03:21:25 PM (3 months ago)

Author:

roboburr <roboburr@…>

Branches:

main

Children:

4c5169f

Parents:

743bb81

Message:

hub: generic home page (not owned by any user) + admin-managed branding

The hub home page was the oldest site (a user's PrutFolio). Now it is a
generic page: title/tagline/intro come from global settings (hub_title/
hub_tagline/hub_intro), editable in Admin -> Settings (hub only). The roster
now shows ALL users (including the admin's own PrutFolio under /user/<slug>)
— no site is singled out as "the company" any more.

POST /admin/settings only updates tenancy when the field is present (a
separate branding form no longer accidentally flips the mode).

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

File:

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

src/routes/hub.js

@@ -10 +10 @@
 import db from '../config/database.js';
 import { renderPage } from '../middleware/render.js';
-import { getTenancy } from '../services/SettingsService.js';
+import { getTenancy, getSetting } from '../services/SettingsService.js';
 
 const router = express.Router();
@@ -35 +35 @@
   `).all();
 
-  // De PrutFolio's (sites) voor de gebruikers-lijst.
-  const sites = db.prepare(`
-    SELECT s.slug, s.title, s.profile_photo,
-           u.username AS owner_username,
+  // ALLE PrutFolio's (elke user, incl. de admin z'n eigen site) voor de roster.
+  const artists = db.prepare(`
+    SELECT s.slug, s.title, s.tagline, s.profile_photo,
            (SELECT COUNT(*) FROM posts WHERE site_id = s.id AND status = 'published') AS post_count
     FROM sites s
-    LEFT JOIN users u ON u.id = s.owner_id
     ORDER BY s.created_at ASC
   `).all();
 
-  // De primaire/oudste site geldt als de bedrijfssite (label). De roster toont
-  // alleen de artiesten (alle overige sites), niet de bedrijfssite zelf.
-  const company = res.locals.site || null;
-  const artists = company ? sites.filter((s) => s.slug !== company.slug) : sites;
+  // De hub-pagina is GENERIEK (van geen enkele user) — branding komt uit globale
+  // instellingen die de admin in Beheer beheert, niet uit een site.
+  const hub = {
+    title: getSetting('hub_title') || 'Overzicht',
+    tagline: getSetting('hub_tagline') || '',
+    intro: getSetting('hub_intro') || '',
+  };
 
   renderPage(req, res, 'pages/hub-home', {
-    pageTitle: company ? company.title : 'Overzicht',
-    socialDescr: (company && (company.description || company.tagline)) || '',
+    pageTitle: hub.title,
+    socialDescr: hub.intro || hub.tagline || '',
     bodyClass: 'on-home on-hub',
-    company,
+    hub,
     artists,
     posts,