Changeset 544e9c2 in Klonkt for src/services/ActivityPubService.js

Timestamp:

07/19/2026 11:58:47 PM (7 weeks ago)

Author:

Robin <roboburr@…>

Branches:

main

Children:

162c7a7

Parents:

8ed65a6

Message:

Feature: Messages "poll finished" notification (klonkt-demo-93o)

Closed own polls surface a poll_done item in Messages with the final tally (bar+pct per option, voter count), derived read-time from poll_json.closed via ownPollView. i18n msg.poll_done/msg.poll_total (NL/EN/DE). Tests in messages.test.js.

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

File:

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

src/services/ActivityPubService.js

@@ -2691 +2691 @@
     }
   } catch { /* ignore */ }
+  // Your own polls that have closed → a "results are in" item, derived read-time
+  // from poll_json (Scheduler marks closed=1) with the tally via ownPollView.
+  try {
+    const site = db.prepare('SELECT id FROM sites WHERE slug = ?').get(slug);
+    if (site) {
+      const polls = db.prepare(`
+        SELECT id, slug, title, poll_json FROM posts
+        WHERE site_id = ? AND poll_json IS NOT NULL
+          AND json_extract(poll_json, '$.closed') = 1
+          AND json_extract(poll_json, '$.endTime') IS NOT NULL
+        ORDER BY json_extract(poll_json, '$.endTime') DESC LIMIT 20`).all(site.id);
+      for (const p of polls) {
+        const view = ownPollView(p);
+        if (!view) continue;
+        let endTime = null; try { endTime = JSON.parse(p.poll_json).endTime; } catch { /* keep null */ }
+        out.push({ type: 'poll_done', post_slug: p.slug, post_title: p.title, poll: view, created_at: endTime || null });
+      }
+    }
+  } catch { /* ignore */ }
   // NaN-safe sort: one row with a missing/garbled created_at would otherwise make the
   // comparator return NaN and scramble the WHOLE ordering (seen live: follow rows landing