Changeset 2e247e4 in Klonkt for src/server.js

Timestamp:

06/19/2026 12:00:48 AM (3 months ago)

Author:

roboburr <roboburr@…>

Branches:

main

Children:

91094a4

Parents:

255e3d3

Message:

Newsletter / mailing list (premium feature #1) + SMTP wiring

Email infrastructure reuses src/config/mailer.js (env SMTP_*, graceful: without
SMTP no sending, sign-ups still work via single opt-in).

• DB: subscribers table (per-site, status pending/confirmed/unsub, token) + newsletters table (send history). Idempotent in initializeDatabase.
• SubscriberService: addSubscriber (double opt-in if SMTP, otherwise single), confirm, unsubscribe, confirmedFor, counts. Email validation + dedupe per (site, email).
• routes/newsletter.js (public, premium-gated; unsubscribe always works): GET/POST /nieuwsbrief, /nieuwsbrief/bevestigen/:token, /nieuwsbrief/uitschrijven/:token. Confirm/unsub links absolute via PUBLIC_BASE_URL + siteUrlBase.
• routes/admin-newsletter.js (site admin + premium): GET /admin/newsletter (compose + counts + history + shareable signup link + SMTP warning), POST /admin/newsletter/send (to confirmed subscribers, unsubscribe link per email, history written).
• views: pages/newsletter.ejs (multi-state) + pages/admin-newsletter.ejs.
• admin dashboard: premium links Newsletter + Press kit added.

Feature #2 (download-for-email) and #8 (notify) reuse subscribers. node --check
passed; local test suite missing better-sqlite3 (runs on the VPS).

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

File:

• src/server.js (modified) (3 diffs)

src/server.js

@@ -53 +53 @@
 import circleRoutes from './routes/circle.js';
 import epkRoutes from './routes/epk.js';
+import newsletterRoutes from './routes/newsletter.js';
+import adminNewsletterRoutes from './routes/admin-newsletter.js';
 
 if (!process.env.SESSION_SECRET) {
@@ -252 +254 @@
 app.use('/admin/patreon', adminPatreonRoutes);
 app.use('/admin/stats', adminStatsRoutes);
+app.use('/admin/newsletter', adminNewsletterRoutes);
 app.use('/admin', adminRoutes);
 app.use('/prutter', prutterRoutes);
@@ -267 +270 @@
 app.use('/', circleRoutes); // /cirkel-feed (solo/hub: next() -> postsRoutes)
 app.use('/', epkRoutes); // /pers perskit (premium; niet-premium: next() -> 404)
+app.use('/', newsletterRoutes); // /nieuwsbrief in/uitschrijven (premium; niet-premium: next())
 app.use('/', postsRoutes);