Changeset f45fc82 in Klonkt for src/routes/admin.js

Timestamp:

06/15/2026 01:14:02 AM (3 months ago)

Author:

roboburr <roboburr@…>

Branches:

main

Children:

bd7f10d

Parents:

b50a885

Message:

feat: posts/drafts list on the dashboard — drafts findable again

Drafts (status!=published) were nowhere to be found: the timeline only shows
published posts and the dashboard had no posts list. Now a Posts block on the
god/solo and artist dashboard with DRAFTS ON TOP, a draft badge, and
mode-aware Edit/View links.

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

File:

• src/routes/admin.js (modified) (5 diffs)

src/routes/admin.js

@@ -12 +12 @@
 
 const router = express.Router();
+
+// Recente posts van één site, CONCEPTEN BOVENAAN, met mode-bewuste edit/view-URLs.
+// Lost op dat drafts (status != published) nergens terug te vinden waren: de
+// tijdlijn toont alleen gepubliceerde posts.
+function sitePosts(siteId, siteSlug, tenancy, limit = 60) {
+  const base = tenancy === 'hub' ? `/user/${siteSlug}` : '';
+  return db.prepare(`
+    SELECT slug, title, status, published_at, created_at, updated_at
+    FROM posts WHERE site_id = ?
+    ORDER BY (status != 'published') DESC, COALESCE(updated_at, published_at, created_at) DESC
+    LIMIT ?
+  `).all(siteId, limit).map((p) => ({
+    ...p,
+    isDraft: p.status !== 'published',
+    editUrl: `${base}/posts/${p.slug}/edit`,
+    viewUrl: `${base}/${p.slug}`,
+  }));
+}
 
 router.get('/', requireAuth, (req, res) => {
@@ -35 +53 @@
       mySite,
       mine,
+      posts: sitePosts(mySite.id, mySite.slug, 'hub'), // my-site is hub-only
     });
   }
@@ -41 +60 @@
 
   // De primaire/owner-site — in solo dé site, in hub de hoofdsite. Geeft de
-  // "Uiterlijk"-tegel z'n edit-link.
+  // "Uiterlijk"-tegel z'n edit-link + de posts/concepten-lijst.
   const primarySite = db.prepare(
-    'SELECT slug, title FROM sites ORDER BY created_at ASC LIMIT 1'
+    'SELECT id, slug, title FROM sites ORDER BY created_at ASC LIMIT 1'
   ).get() || null;
 
@@ -71 +90 @@
   `).all() : [];
 
+  // Posts/concepten van de primaire site (in solo = de site; in hub = de
+  // hoofdsite van de admin). Concepten staan bovenaan zodat ze vindbaar zijn.
+  const posts = primarySite ? sitePosts(primarySite.id, primarySite.slug, tenancy) : [];
+
   renderPage(req, res, 'pages/admin', {
     pageTitle: 'Beheer',
@@ -78 +101 @@
     stats,
     sites,
+    posts,
     users,
   });