Changeset ce8c8c2 in Klonkt for src/routes

Timestamp:

06/14/2026 06:46:13 PM (3 months ago)

Author:

roboburr <roboburr@…>

Branches:

main

Children:

74c2473

Parents:

a3169f5

Message:

feat: hub-home shows main/label account separately (not under Artists)

The main site (oldest = company/main account, e.g. Studio Noord) appeared
among the artists. Now it gets a highlighted "Main page" card above the roster
and is excluded from both the Artists roster and the /artiesten directory
(a label is not an artist).

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

Location:

src/routes

Files:

• artists.js (modified) (1 diff)
• hub.js (modified) (3 diffs)

src/routes/artists.js

@@ -26 +26 @@
   if (!Number.isFinite(page) || page < 1) page = 1;
 
+  // De hoofd-/labelsite (oudste) is geen artiest -> uit de directory weren,
+  // consistent met de hub-home die 'm apart toont.
+  const mainRow = db.prepare('SELECT id FROM sites ORDER BY created_at ASC LIMIT 1').get();
+  const mainId = mainRow ? mainRow.id : '';
+
   // Zoekterm tegen titel/slug/tagline (case-insensitive via LIKE; SQLite LIKE is
   // standaard ongevoelig voor ASCII-hoofdletters). De ESCAPE '\' maakt %, _ en \
   // in de zoekterm letterlijk (anders zouden ze als wildcards werken).
-  const where = q
-    ? "WHERE (s.title LIKE @like ESCAPE '\\' OR s.slug LIKE @like ESCAPE '\\' OR s.tagline LIKE @like ESCAPE '\\')"
-    : '';
   const like = '%' + q.replace(/[\\%_]/g, (m) => '\\' + m) + '%';
-  const params = q ? { like } : {};
+  const conds = ['s.id != @mainId'];
+  if (q) conds.push("(s.title LIKE @like ESCAPE '\\' OR s.slug LIKE @like ESCAPE '\\' OR s.tagline LIKE @like ESCAPE '\\')");
+  const where = 'WHERE ' + conds.join(' AND ');
+  const params = q ? { mainId, like } : { mainId };
 
   const total = db.prepare(`SELECT COUNT(*) AS c FROM sites s ${where}`)

src/routes/hub.js

@@ -35 +35 @@
   `).all();
 
+  // De hoofd-/labelsite (oudste = de bedrijfs-/hoofdaccount) is GEEN artiest;
+  // die tonen we apart bovenaan, niet in de Artiesten-roster.
+  const mainSite = db.prepare(`
+    SELECT s.id, s.slug, s.title, s.tagline, s.profile_photo, s.accent,
+           u.avatar_url AS owner_avatar,
+           (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
+    LIMIT 1
+  `).get() || null;
+  const mainId = mainSite ? mainSite.id : '';
+
   // Uitgelichte PrutFolio's voor de home-roster: meest-actief eerst (aantal
-  // gepubliceerde posts), dan nieuwste. Beperkt tot HOME_ROSTER_LIMIT zodat de
-  // home schaalt — de volledige, doorzoekbare lijst staat op /artiesten.
+  // gepubliceerde posts), dan nieuwste. Excl. de hoofdsite. Beperkt tot
+  // HOME_ROSTER_LIMIT zodat de home schaalt — volledige lijst staat op /artiesten.
   const HOME_ROSTER_LIMIT = 24;
   const artists = db.prepare(`
@@ -45 +58 @@
     FROM sites s
     LEFT JOIN users u ON u.id = s.owner_id
+    WHERE s.id != @mainId
     ORDER BY post_count DESC, s.created_at DESC
-    LIMIT ?
-  `).all(HOME_ROSTER_LIMIT);
-  const totalArtists = db.prepare('SELECT COUNT(*) AS c FROM sites').get().c;
+    LIMIT @limit
+  `).all({ mainId, limit: HOME_ROSTER_LIMIT });
+  const totalArtists = db.prepare('SELECT COUNT(*) AS c FROM sites WHERE id != ?').get(mainId).c;
 
   // De hub-pagina is GENERIEK (van geen enkele user) — branding komt uit globale
@@ -64 +78 @@
     bodyClass: 'on-home on-hub',
     hub,
+    mainSite,
     artists,
     totalArtists,