Changeset 8d32dcf in Klonkt for src/services/SubscriberService.js

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

File:

• src/services/SubscriberService.js (modified) (1 diff)

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