Changeset b9dc94c in Klonkt for src/routes/posts.js

Timestamp:

06/19/2026 04:28:02 AM (3 months ago)

Author:

roboburr <roboburr@…>

Branches:

main

Children:

8d32dcf

Parents:

6be57b4

Message:

Release scheduling + fan-only previews (premium feature #3)

• DB: posts.publish_at (scheduled go-live) + posts.fan_only.
• Release scheduling: published + future publish_at -> status 'scheduled' (excluded from public status='published' queries). Scheduler.js publishes them when the time is reached (setInterval 60s + on boot) + adds them to posts_fts. No public queries changed -> low risk.
• Fan-only: posts.fan_only; the single-post view shows anonymous visitors a clean login gate (pages/fan-gate.ejs, link /auth/login?next=) instead of the content; logged-in fans see everything. Listings show the teaser.
• create/save: read publish_at + fan_only; FTS excludes 'scheduled'.
• editor (post-edit): premium-gated fields "Fans only" + "Publish on" (datetime-local) + "scheduled for" notice.
• server.js: startScheduler() after initializeDatabase.

node --check passed.

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

File:

• src/routes/posts.js (modified) (7 diffs)

src/routes/posts.js

@@ -154 +154 @@
 
   const { title, slug, content, excerpt, status, pinned, cover_image_url, tags, noindex, type } = req.body;
+  const fanOnly = req.body.fan_only ? 1 : 0;
 
   // Content arrives as user-authored HTML from the WYSIWYG editor — sanitize
@@ -177 +178 @@
   const postId = uuid();
   const now = new Date().toISOString();
-  const finalStatus = status || 'draft';
-  const publishedAt = finalStatus === 'published' ? now : null;
+  let finalStatus = status || 'draft';
+  let publishedAt = finalStatus === 'published' ? now : null;
+  // Release-planning: gepubliceerd + een toekomstige publish_at -> 'scheduled'
+  // (de Scheduler zet 'm live op het moment zelf). Verleden/leeg -> meteen live.
+  let publishAt = null;
+  const pa = Date.parse(req.body.publish_at || '');
+  if (finalStatus === 'published' && Number.isFinite(pa) && pa > Date.now()) {
+    finalStatus = 'scheduled';
+    publishAt = new Date(pa).toISOString();
+    publishedAt = null;
+  }
 
   db.prepare(`
     INSERT INTO posts (
       id, site_id, slug, author_id, title, content, excerpt,
-      status, cover_image_url, pinned, tags, type, noindex,
+      status, cover_image_url, pinned, tags, type, noindex, fan_only, publish_at,
       created_at, updated_at, published_at
-    ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
+    ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
   `).run(
     postId, site.id, finalSlug, req.session.user.id,
@@ -191 +201 @@
     finalStatus, cover_image_url || null, parsePinnedRank(pinned),
     JSON.stringify((tags || '').split(',').map(t => t.trim()).filter(Boolean)),
-    finalType, noindex ? 1 : 0,
+    finalType, noindex ? 1 : 0, fanOnly, publishAt,
     now, now, publishedAt
   );
@@ -255 +265 @@
 
   const { title, content, excerpt, status, pinned, cover_image_url, tags, noindex, type } = req.body;
+  const fanOnly = req.body.fan_only ? 1 : 0;
   const newSlug = req.body.slug;
   const action = req.body.action || 'save';
@@ -281 +292 @@
   }
 
+  // Release-planning: gepubliceerd + toekomstige publish_at -> 'scheduled'.
+  let publishAt = null;
+  const pa = Date.parse(req.body.publish_at || '');
+  if (finalStatus === 'published' && Number.isFinite(pa) && pa > Date.now()) {
+    finalStatus = 'scheduled';
+    publishAt = new Date(pa).toISOString();
+    publishedAt = null;
+  }
+
   db.prepare(`
     UPDATE posts SET
       title = ?, content = ?, excerpt = ?, status = ?,
       cover_image_url = ?, pinned = ?, tags = ?,
-      type = ?, noindex = ?,
+      type = ?, noindex = ?, fan_only = ?, publish_at = ?,
       slug = ?, published_at = ?, updated_at = ?
     WHERE id = ?
@@ -292 +312 @@
     cover_image_url || null, parsePinnedRank(pinned),
     JSON.stringify((tags || '').split(',').map(t => t.trim()).filter(Boolean)),
-    finalType, noindex ? 1 : 0,
+    finalType, noindex ? 1 : 0, fanOnly, publishAt,
     finalSlug, publishedAt, now, post.id
   );
@@ -393 +413 @@
     const canEdit = req.session?.user && PermissionsService.canEditPost(req.session.user, post, site);
     if (!canEdit) return res.status(403).send('Not published');
+  }
+
+  // Fan-only preview (premium #3): volledige inhoud alleen voor ingelogde fans.
+  // Anonieme bezoekers krijgen een nette login-gate i.p.v. de inhoud (de titel/
+  // teaser mag elders wel als lokkertje verschijnen).
+  if (post.fan_only && !(req.session && req.session.user)) {
+    return renderPage(req, res, 'pages/fan-gate', {
+      pageTitle: post.title || 'Alleen voor fans',
+      bodyClass: 'on-special',
+      fgTitle: post.title || '',
+      fgNext: (res.locals.siteUrlBase || '') + '/' + post.slug,
+    });
   }