Changeset c9c6a2d in Klonkt for src/routes

Timestamp:

06/21/2026 06:38:24 PM (3 months ago)

Author:

roboburr <roboburr@…>

Branches:

main

Children:

9a34d31

Parents:

d41f4be

Message:

feat(meldingen): notifications — reply on comment, comment on post, like on post

For every logged-in user (Google visitors/fans and admin). Bell icon in the
header with unread counter + notifications page /notifications (via user menu
desktop + profile sheet mobile; badge also on the mobile Profile tab). Opening =
read. Triggers in comments (reply→comment author, top-level→post author) and
like (→post author); notify() skips notifying yourself. Table notifications
+ NotificationService. NL/EN/DE.

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

Location:

src/routes

Files:

• comments.js (modified) (4 diffs)
• notifications.js (added)
• posts.js (modified) (3 diffs)

src/routes/comments.js

@@ -19 +19 @@
 import { requireAuth } from '../middleware/auth.js';
 import PermissionsService from '../services/PermissionsService.js';
+import { notify } from '../services/NotificationService.js';
 
 const router = express.Router();
@@ -39 +40 @@
 
   const post = db.prepare(
-    'SELECT id, slug FROM posts WHERE site_id = ? AND slug = ? AND status = ?'
+    'SELECT id, slug, title, author_id FROM posts WHERE site_id = ? AND slug = ? AND status = ?'
   ).get(site.id, postSlug, 'published');
   if (!post) return res.status(404).send('Post not found');
@@ -50 +51 @@
   // up to the top-level parent so we never go deeper than 1)
   let resolvedParent = null;
+  let parentAuthorId = null;
   if (parentId) {
     const parent = db.prepare(
-      'SELECT id, parent_comment_id FROM comments WHERE id = ? AND post_id = ?'
+      'SELECT id, parent_comment_id, author_id FROM comments WHERE id = ? AND post_id = ?'
     ).get(parentId, post.id);
     if (!parent) return res.status(400).send('Invalid parent comment');
     resolvedParent = parent.parent_comment_id || parent.id;
+    parentAuthorId = parent.author_id; // ontvanger van de "antwoord"-melding
   }
 
@@ -73 +76 @@
     VALUES (?, ?, ?, ?, ?, ?)
   `).run(commentId, post.id, req.session.user.id, resolvedParent, rawContent, status);
+
+  // Melding (alleen bij een zichtbare reactie): antwoord → de auteur van de reactie
+  // waarop gereageerd is; top-level reactie → de auteur van de post. notify() slaat
+  // jezelf-notificeren over.
+  if (status === 'approved') {
+    const url = `${res.locals.siteUrlBase || ''}/${post.slug}#comment-${commentId}`;
+    const actorId = req.session.user.id;
+    const actorName = req.session.user.username;
+    if (parentId) {
+      notify({ userId: parentAuthorId, actorId, actorName, type: 'reply', postSlug: post.slug, postTitle: post.title, url });
+    } else {
+      notify({ userId: post.author_id, actorId, actorName, type: 'comment', postSlug: post.slug, postTitle: post.title, url });
+    }
+  }
 
   // Where to land after submit:

src/routes/posts.js

@@ -10 +10 @@
 import { renderPage } from '../middleware/render.js';
 import { recordPageview, recordPostView } from '../services/StatsService.js';
+import { notify } from '../services/NotificationService.js';
 import PermissionsService from '../services/PermissionsService.js';
 import MarkdownService from '../services/MarkdownService.js';
@@ -405 +406 @@
 router.post('/posts/:id/like', requireAuth, (req, res) => {
   const userId = req.session.user.id;
-  const post = db.prepare('SELECT id, status FROM posts WHERE id = ?').get(req.params.id);
+  const post = db.prepare('SELECT id, status, slug, title, author_id FROM posts WHERE id = ?').get(req.params.id);
   if (!post) return res.status(404).send('Post niet gevonden');
   if (post.status !== 'published') return res.status(403).send('Niet beschikbaar');
@@ -414 +415 @@
   } else {
     db.prepare('INSERT OR IGNORE INTO post_likes (post_id, user_id) VALUES (?, ?)').run(post.id, userId);
+    // Melding voor de post-auteur (notify slaat jezelf-liken over).
+    notify({
+      userId: post.author_id, actorId: userId, actorName: req.session.user.username, type: 'like',
+      postSlug: post.slug, postTitle: post.title, url: (res.locals.siteUrlBase || '') + '/' + post.slug,
+    });
   }
   const likeCount = db.prepare('SELECT COUNT(*) AS c FROM post_likes WHERE post_id = ?').get(post.id).c;