Changeset e6ad948 in Klonkt for src/routes/admin-epk.js

Timestamp:

06/20/2026 06:47:41 AM (3 months ago)

Author:

roboburr <roboburr@…>

Branches:

main

Children:

08cfdaa

Parents:

57b1843

Message:

feat(epk): choose up to 5 tracks for the press kit (instead of auto top-5)

Press kit editor now has a track picker (checkboxes, max 5). /pers shows the
chosen tracks in that order; no selection → automatically the top 5 most
played. Stored as epk_tracks_<siteId> (validated on site + max 5).

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

File:

• src/routes/admin-epk.js (modified) (5 diffs)

src/routes/admin-epk.js

@@ -10 +10 @@
 
 import express from 'express';
+import db from '../config/database.js';
 import { renderPage } from '../middleware/render.js';
 import { requireGod } from '../middleware/auth.js';
@@ -17 +18 @@
 const router = express.Router();
 
+const MAX_EPK_TRACKS = 5;
+
 router.get('/', requireGod, (req, res) => {
   const site = res.locals.site;
@@ -23 +26 @@
     return res.status(403).send('Perskit is een premium-functie.');
   }
+  const allTracks = db.prepare(
+    `SELECT id, title, artist FROM audio_tracks WHERE site_id = ? ORDER BY position ASC, created_at ASC`
+  ).all(site.id);
+  let chosen = [];
+  try { const r = JSON.parse(getSetting('epk_tracks_' + site.id, '') || '[]'); if (Array.isArray(r)) chosen = r; } catch (e) {}
   renderPage(req, res, 'pages/admin-epk', {
     pageTitle: 'Perskit bewerken',
@@ -29 +37 @@
     epkBio: getSetting('epk_bio_' + site.id, '') || '',
     epkContact: getSetting('epk_contact_' + site.id, '') || '',
+    allTracks,
+    chosenTracks: chosen,
+    maxEpkTracks: MAX_EPK_TRACKS,
     success: req.query.success || null,
   });
@@ -38 +49 @@
   setSetting('epk_bio_' + site.id, (req.body.epk_bio || '').toString().slice(0, 1000).trim());
   setSetting('epk_contact_' + site.id, (req.body.epk_contact || '').toString().slice(0, 300).trim());
+  // Gekozen nummers: alleen ids van DEZE site, max 5, in de aangeleverde volgorde.
+  let ids = req.body.epk_tracks;
+  if (!Array.isArray(ids)) ids = ids ? [ids] : [];
+  const valid = new Set(db.prepare('SELECT id FROM audio_tracks WHERE site_id = ?').all(site.id).map((r) => r.id));
+  ids = ids.map(String).filter((id) => valid.has(id)).slice(0, MAX_EPK_TRACKS);
+  setSetting('epk_tracks_' + site.id, JSON.stringify(ids));
   res.redirect('/admin/epk?success=' + encodeURIComponent('Perskit opgeslagen'));
 });