Changeset 8d32dcf in Klonkt

Timestamp:

06/19/2026 06:47:40 AM (3 months ago)

Author:

roboburr <roboburr@…>

Branches:

main

Children:

84325b8

Parents:

b9dc94c

Message:

Show agenda + notify-me (premium feature #8) — last of the 8

• DB: shows (site_id, date, time, city, venue, country, ticket_url, notes).
• routes/shows.js (public, premium-gated): GET /shows (upcoming shows + notify form), POST /shows/notify (subscribers source 'notify', double opt-in if SMTP; confirm/unsub via the generic /nieuwsbrief links).
• routes/admin-shows.js (site admin + premium): GET /admin/shows (list + add form + subscriber count), POST / (add; optional notify email to 'notify' subscribers if SMTP is available), POST /:id/delete.
• SubscriberService.confirmedFor(siteId, source?) — optional source filter ('notify').
• views: pages/shows.ejs + pages/admin-shows.ejs. Dashboard 📅 Agenda link.

Notify email requires SMTP (like #1/#2 sending); without SMTP the show is saved
and sign-ups still work. node --check passed.

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

Location:

src

Files:

• config/database.js (modified) (1 diff)
• routes/admin-shows.js (added)
• routes/shows.js (added)
• server.js (modified) (3 diffs)
• services/SubscriberService.js (modified) (1 diff)
• views/pages/admin-shows.ejs (added)
• views/pages/admin.ejs (modified) (1 diff)
• views/pages/shows.ejs (added)

src/config/database.js

@@ -228 +228 @@
   `);
 
+  // Show-agenda (premium #8): tourdata/optredens per site.
+  db.exec(`
+    CREATE TABLE IF NOT EXISTS shows (
+      id TEXT PRIMARY KEY,
+      site_id TEXT NOT NULL,
+      date TEXT NOT NULL,
+      time TEXT,
+      city TEXT NOT NULL,
+      venue TEXT,
+      country TEXT,
+      ticket_url TEXT,
+      notes TEXT,
+      created_at DATETIME DEFAULT CURRENT_TIMESTAMP
+    );
+    CREATE INDEX IF NOT EXISTS idx_shows_site_date ON shows(site_id, date);
+  `);
+
   // Link-in-bio klikstatistiek (premium #6). Per (site, url) een teller; de
   // link-in-bio-pagina linkt via /links/go/:i dat de klik telt en doorstuurt.

src/server.js

@@ -59 +59 @@
 import linkbioRoutes from './routes/linkbio.js';
 import embedRoutes from './routes/embed.js';
+import showsRoutes from './routes/shows.js';
+import adminShowsRoutes from './routes/admin-shows.js';
 
 if (!process.env.SESSION_SECRET) {
@@ -260 +262 @@
 app.use('/admin/stats', adminStatsRoutes);
 app.use('/admin/newsletter', adminNewsletterRoutes);
+app.use('/admin/shows', adminShowsRoutes);
 app.use('/admin', adminRoutes);
 app.use('/prutter', prutterRoutes);
@@ -279 +282 @@
 app.use('/', linkbioRoutes); // /links link-in-bio + klikstats (premium)
 app.use('/', embedRoutes); // /embed inbedbare audiospeler (premium)
+app.use('/', showsRoutes); // /shows agenda + notify-me (premium)
 app.use('/', postsRoutes);
 

src/services/SubscriberService.js

@@ -69 +69 @@
 }
 
-/** Bevestigde abonnees (email + token) voor een site — voor het versturen. */
-export function confirmedFor(siteId) {
+/** Bevestigde abonnees (email + token) voor een site — voor het versturen.
+ * Optioneel filteren op bron (bv. 'notify' voor show-aankondigingen). */
+export function confirmedFor(siteId, source) {
+  if (source) {
+    return db.prepare("SELECT email, token FROM subscribers WHERE site_id = ? AND status = 'confirmed' AND source = ?").all(siteId, source);
+  }
   return db.prepare("SELECT email, token FROM subscribers WHERE site_id = ? AND status = 'confirmed'").all(siteId);
 }

src/views/pages/admin.ejs

@@ -37 +37 @@
       <% if (tenancy !== 'hub' && primarySite) { %><a href="/downloads" class="btn" target="_blank">⬇ Downloads</a><% } %>
       <% if (tenancy !== 'hub' && primarySite) { %><a href="/links" class="btn" target="_blank">🔗 Link-in-bio</a><% } %>
+      <a href="/admin/shows" class="btn">📅 Agenda</a>
     <% } %>
     <a href="/admin/updates" class="btn">🔄 Updates</a>