Changeset 91094a4 in Klonkt

Timestamp:

06/19/2026 01:09:15 AM (3 months ago)

Author:

roboburr <roboburr@…>

Branches:

main

Children:

37edecd

Parents:

2e247e4

Message:

Download-for-email (premium feature #2)

Fan leaves their email -> receives the file; address is added to the mailing list
(source 'download', single opt-in so the download is not behind a confirm barrier).
Reuses SubscriberService (#1).

• DB: audio_tracks.downloadable (default 0).
• admin-audio: per-track no-JS toggle (POST /admin/audio/:id/downloadable) + ⬇ button in the admin list (premium-gated); downloadable also in the /api/:id whitelist.
• routes/download.js (premium-gated): GET /downloads (list), GET /download/:id (capture page), POST /download/:id (save email + session grant), GET /download/:id/bestand (serves attachment from storage/audio, 15-min session window, path-traversal guards).
• views: pages/downloads.ejs + pages/download.ejs (form/ready, auto-start download).
• admin dashboard: ⬇ Downloads link (premium, non-hub).

node --check passed. Nothing else reuses this; #8 notify reuses subscribers.

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

Location:

src

Files:

• config/database.js (modified) (1 diff)
• routes/admin-audio.js (modified) (3 diffs)
• routes/download.js (added)
• server.js (modified) (2 diffs)
• views/pages/admin-audio.ejs (modified) (1 diff)
• views/pages/admin.ejs (modified) (1 diff)
• views/pages/download.ejs (added)
• views/pages/downloads.ejs (added)

src/config/database.js

@@ -87 +87 @@
   ensureColumn('posts', 'view_count', 'INTEGER DEFAULT 0');         // weergaven per post
   ensureColumn('audio_tracks', 'play_count', 'INTEGER DEFAULT 0');  // plays per track
+  ensureColumn('audio_tracks', 'downloadable', 'INTEGER DEFAULT 0'); // download-voor-email (premium #2)
 
   // Playlists (v9 feature) — first-class entity. CREATE IF NOT EXISTS is

src/routes/admin-audio.js

@@ -78 +78 @@
   const rows = db.prepare(`
     SELECT t.id, t.title, t.artist, t.album, t.duration, t.cover_url,
-           t.position, t.created_at, m.filename, m.size, m.mime_type
+           t.position, t.created_at, t.downloadable, m.filename, m.size, m.mime_type
     FROM audio_tracks t
     LEFT JOIN media m ON m.id = t.media_id
@@ -241 +241 @@
     });
   });
+});
+
+// Download-voor-email per track aan/uit (premium #2). Zonder-JS toggle vanaf de
+// audio-beheerlijst → flip + terug.
+router.post('/:id/downloadable', requireGod, (req, res) => {
+  const site = res.locals.site;
+  if (!site) return res.status(404).send('Site required');
+  const row = db.prepare('SELECT downloadable FROM audio_tracks WHERE id = ? AND site_id = ?').get(req.params.id, site.id);
+  if (row) {
+    db.prepare('UPDATE audio_tracks SET downloadable = ? WHERE id = ? AND site_id = ?')
+      .run(row.downloadable ? 0 : 1, req.params.id, site.id);
+  }
+  res.redirect('/admin/audio');
 });
 
@@ -413 +426 @@
   }
 
+  if (Object.prototype.hasOwnProperty.call(body, 'downloadable')) {
+    fields.push('downloadable = ?'); values.push(body.downloadable ? 1 : 0);
+  }
+
   if (fields.length === 0) {
     return res.status(400).json({ error: 'Niks om te updaten' });

src/server.js

@@ -55 +55 @@
 import newsletterRoutes from './routes/newsletter.js';
 import adminNewsletterRoutes from './routes/admin-newsletter.js';
+import downloadRoutes from './routes/download.js';
 
 if (!process.env.SESSION_SECRET) {
@@ -271 +272 @@
 app.use('/', epkRoutes); // /pers perskit (premium; niet-premium: next() -> 404)
 app.use('/', newsletterRoutes); // /nieuwsbrief in/uitschrijven (premium; niet-premium: next())
+app.use('/', downloadRoutes); // /downloads + /download/:id download-voor-email (premium)
 app.use('/', postsRoutes);
 

src/views/pages/admin-audio.ejs

@@ -101 +101 @@
               <% } %>
               <button type="button" class="ax-icon-btn" data-track-edit data-id="<%= t.id %>" aria-label="Bewerken" title="Bewerken">✎</button>
+              <% if (typeof premiumUnlocked === 'undefined' || premiumUnlocked) { %>
+                <form action="/admin/audio/<%= t.id %>/downloadable" method="post" class="ax-track-delete" style="display:inline">
+                  <button type="submit" class="ax-icon-btn" aria-label="Download-voor-email" title="<%= t.downloadable ? 'Download-voor-email staat AAN — klik om uit te zetten' : 'Download-voor-email staat uit — klik om aan te zetten' %>" style="<%= t.downloadable ? 'color:var(--accent,#6b8f71)' : 'opacity:.5' %>">⬇</button>
+                </form>
+              <% } %>
               <form action="/admin/audio/<%= t.id %>/delete" method="post" onsubmit="return confirm('Track verwijderen?')" class="ax-track-delete">
                 <button type="submit" class="ax-icon-btn ax-icon-btn-danger" aria-label="Verwijderen" title="Verwijderen">🗑</button>

src/views/pages/admin.ejs

@@ -35 +35 @@
       <a href="/admin/newsletter" class="btn">✉️ Nieuwsbrief</a>
       <% if (tenancy !== 'hub' && primarySite) { %><a href="/pers" class="btn" target="_blank">📰 Perskit</a><% } %>
+      <% if (tenancy !== 'hub' && primarySite) { %><a href="/downloads" class="btn" target="_blank">⬇ Downloads</a><% } %>
     <% } %>
     <a href="/admin/updates" class="btn">🔄 Updates</a>