Changeset fa08981 in Klonkt for src/routes/audio.js

Timestamp:

06/20/2026 01:52:46 AM (3 months ago)

Author:

roboburr <roboburr@…>

Branches:

main

Children:

8f6225c

Parents:

230e446

Message:

fix(player): scroll-to-track works for site-wide tracks too

Site-wide tracks (PCMS_SITE_TRACKS) were not getting an id → no anchor; and
no postUrl → no jump. Now: id included in the queue; mini-player click uses
postUrl when known, otherwise looks up the post via new endpoint
GET /audio/track/:id/post (newest post with [[track:<id>]]) and jumps +
scrolls to the track. audio-player.js?v=18.

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

File:

• src/routes/audio.js (modified) (1 diff)

src/routes/audio.js

@@ -141 +141 @@
 });
 
+// Welke post bevat deze track? (voor de mini-speler → "spring naar de post +
+// scroll naar de track".) Pakt de nieuwste gepubliceerde post met [[track:<id>]].
+router.get('/track/:id/post', (req, res) => {
+  const id = String(req.params.id || '');
+  if (!/^[A-Za-z0-9_-]+$/.test(id)) return res.status(400).json({ error: 'bad id' });
+  const isHub = res.locals.tenancy === 'hub';
+  const row = db.prepare(`
+    SELECT p.slug, s.slug AS site_slug
+    FROM posts p JOIN sites s ON s.id = p.site_id
+    WHERE p.status = 'published' AND p.content LIKE ?
+    ORDER BY p.published_at DESC LIMIT 1
+  `).get('%[[track:' + id + ']]%');
+  if (!row) return res.status(404).json({ error: 'not found' });
+  const url = isHub ? `/user/${row.site_slug}/${row.slug}` : `/${row.slug}`;
+  res.json({ url });
+});
+
 export default router;