Changeset b9dc94c in Klonkt

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@…>

Location:

src

Files:

• config/database.js (modified) (1 diff)
• routes/posts.js (modified) (7 diffs)
• server.js (modified) (2 diffs)
• services/Scheduler.js (added)
• views/pages/fan-gate.ejs (added)
• views/pages/post-edit.ejs (modified) (1 diff)

src/config/database.js

@@ -82 +82 @@
   // Per-post noindex + type
   ensureColumn('posts', 'noindex', 'INTEGER DEFAULT 0');
+  ensureColumn('posts', 'publish_at', 'DATETIME');         // release-planning (premium #3): geplande go-live
+  ensureColumn('posts', 'fan_only', 'INTEGER DEFAULT 0');  // fan-only preview (premium #3)
   ensureColumn('posts', 'type',    "TEXT DEFAULT 'post'");  // post | foto | video | audio
 

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,
+    });
   }
 

src/server.js

@@ -16 +16 @@
 import http from 'http';
 import db, { initializeDatabase } from './config/database.js';
+import { startScheduler } from './services/Scheduler.js';
 import { SqliteSessionStore } from './services/SqliteSessionStore.js';
 import { ensurePrimarySite } from './services/ensurePrimarySite.js';
@@ -140 +141 @@
 // → crash-loop op de allereerste boot).
 initializeDatabase();
+startScheduler(); // release-planning: zet geplande posts live zodra publish_at bereikt is
 
 // Vangnet: garandeer dat er altijd een primaire site is (solo/hub/circle).

src/views/pages/post-edit.ejs

@@ -193 +193 @@
           <span>🚫 noindex (verberg voor zoekmachines)</span>
         </label>
+        <% if (typeof premiumUnlocked === 'undefined' || premiumUnlocked) { %>
+          <label class="pe-checkbox">
+            <input type="checkbox" name="fan_only" value="1" <%= post.fan_only ? 'checked' : '' %>>
+            <span>🔒 Alleen voor ingelogde fans</span>
+          </label>
+          <div style="margin-top:8px">
+            <label style="display:block;font-size:12.5px;opacity:.8;margin-bottom:4px">📅 Publiceren op (laat leeg = direct)</label>
+            <input type="datetime-local" name="publish_at" value="<%= post.publish_at ? String(post.publish_at).replace(' ','T').slice(0,16) : '' %>" style="padding:8px 10px;border-radius:8px;border:1px solid var(--rule,rgba(128,128,128,.4));background:transparent;color:inherit">
+            <% if (post.status === 'scheduled' && post.publish_at) { %><div style="font-size:12px;opacity:.7;margin-top:4px">⏳ Ingepland voor <%= post.publish_at %></div><% } %>
+          </div>
+        <% } %>
       </div>
     </section>