'use strict'; /* POST /messages/read { ids } or { all: true }: mark received messages read. Already-read ones are left alone. */ module.exports = function messageRead(ctx, { userId, ids, all, worldId }) { const { db, now } = ctx; const ops = db.all(worldId !== undefined ? 'SELECT id FROM operators WHERE user_id = ? AND world_id = ?' : 'SELECT id FROM operators WHERE user_id = ?', userId, ...(worldId !== undefined ? [worldId] : [])); let changed = 0; for (const o of ops) { if (all) changed += db.run('UPDATE message_recipients SET read_at = ? WHERE operator_id = ? AND read_at IS NULL AND deleted_at IS NULL', now, o.id).changes; else for (const id of ids || []) changed += db.run('UPDATE message_recipients SET read_at = ? WHERE operator_id = ? AND message_id = ? AND read_at IS NULL AND deleted_at IS NULL', now, o.id, id).changes; } return { changed: Number(changed) }; };