/** * 2.1.0: the Feedback page (services/feedback.ts) — results per event, anonymous forms that stay * anonymous, and "Remind" with its 24-hour rule (utils/feedback.js sendFeedbackReminders). 2.1.1: * "Remind" answers straight away and the emails go out in a background task (runFeedbackTask). */ const mockDb: any = { feedbackForm: { findUnique: jest.fn(), findMany: jest.fn() }, feedbackInvite: { findMany: jest.fn(), updateMany: jest.fn(), count: jest.fn(), create: jest.fn(), groupBy: jest.fn() }, feedbackAnswer: { findMany: jest.fn() }, ticket: { findMany: jest.fn() }, registration: { findMany: jest.fn() }, user: { findMany: jest.fn() }, }; jest.mock('../src/config/db', () => mockDb); const mockMail = jest.fn(async () => undefined); jest.mock('../src/utils/email', () => ({ sendMail: (...a: unknown[]) => (mockMail as jest.Mock)(...a), emailWrapper: (h: string) => h, ctaButton: () => '', fallbackLink: () => '' })); jest.mock('../src/utils/notify', () => ({ waTextAny: jest.fn(async () => undefined) })); jest.mock('../src/utils/whatsapp', () => ({ isValidZAPhone: () => false })); const mockEnqueue = jest.fn(async () => ({ queued: true })); jest.mock('../src/jobs', () => ({ enqueueTask: (...a: unknown[]) => (mockEnqueue as jest.Mock)(...a) })); import * as feedback from '../src/services/feedback'; // eslint-disable-next-line @typescript-eslint/no-require-imports const { sendFeedbackReminders, runFeedbackTask } = require('../src/utils/feedback'); const NOW = new Date('2026-11-10T12:00:00Z'); const hoursAgo = (h: number) => new Date(NOW.getTime() - h * 3600e3); const EVENT = { id: 'ev1', title: 'Men\'s Breakfast', startDate: new Date('2026-11-01T07:00:00Z'), endDate: new Date('2026-11-01T10:00:00Z') }; const FIELDS = [ { id: 'f1', type: 'rating', label: 'Overall', options: null }, { id: 'f2', type: 'text', label: 'What could be better?', options: null }, { id: 'f0', type: 'statement', label: 'Thanks for coming', options: null }, ]; const person = (id: string, name: string) => ({ id, name, email: `${id}@example.com`, phoneNumber: null }); function form(extra: object = {}) { return { id: 'form1', eventId: 'ev1', event: EVENT, anonymous: false, audience: 'checked_in', intro: null, sendAt: hoursAgo(72), sentAt: hoursAgo(72), reminderSentAt: null, fields: FIELDS, responses: [ { id: 'r1', createdAt: hoursAgo(60), user: { name: 'Anna' }, answers: [{ fieldId: 'f1', value: '5' }, { fieldId: 'f2', value: 'Longer coffee break' }] }, { id: 'r2', createdAt: hoursAgo(50), user: { name: 'Ben' }, answers: [{ fieldId: 'f1', value: '4' }] }, ], invites: [ { userId: 'u1', user: person('u1', 'Anna'), sentAt: hoursAgo(72), remindedAt: null, reminderCount: 0, respondedAt: hoursAgo(60) }, { userId: 'u2', user: person('u2', 'Ben'), sentAt: hoursAgo(72), remindedAt: null, reminderCount: 0, respondedAt: hoursAgo(50) }, { userId: 'u3', user: person('u3', 'Cara'), sentAt: hoursAgo(72), remindedAt: hoursAgo(2), reminderCount: 1, respondedAt: null }, { userId: 'u4', user: person('u4', 'Dumi'), sentAt: hoursAgo(72), remindedAt: null, reminderCount: 0, respondedAt: null }, { userId: 'u5', user: person('u5', 'Eve'), sentAt: hoursAgo(1), remindedAt: null, reminderCount: 0, respondedAt: null }, ], ...extra, }; } beforeEach(() => { jest.clearAllMocks(); mockDb.ticket.findMany.mockResolvedValue([]); mockDb.registration.findMany.mockResolvedValue([]); mockDb.user.findMany.mockResolvedValue([]); mockDb.feedbackInvite.updateMany.mockResolvedValue({ count: 1 }); }); describe('averageRating', () => { test('averages every valid star rating, to one decimal', () => { expect(feedback.averageRating(['5', '4', '4'])).toBe(4.3); expect(feedback.averageRating(['x', '9', '0'])).toBeNull(); expect(feedback.averageRating([])).toBeNull(); }); }); describe('one event\'s feedback', () => { test('a named form: names on answers, everyone asked, not answered first', async () => { mockDb.feedbackForm.findUnique.mockResolvedValue(form()); const data = await feedback.eventFeedback('ev1', NOW); expect(data.counts).toMatchObject({ invited: 5, answered: 2, notAnswered: 3, responseRate: 40 }); expect(data.averageRating).toBe(4.5); expect(data.fields.map((f: any) => f.id)).toEqual(['f1', 'f2']); // statements aren't questions expect(data.responses[0]).toMatchObject({ name: 'Anna', answers: { f1: '5', f2: 'Longer coffee break' } }); expect(data.people!.map((p: any) => p.name)).toEqual(['Cara', 'Dumi', 'Eve', 'Anna', 'Ben']); }); test('nobody is remindable within 24 hours of the form or a reminder', async () => { mockDb.feedbackForm.findUnique.mockResolvedValue(form()); const data = await feedback.eventFeedback('ev1', NOW); const can = Object.fromEntries(data.people!.map((p: any) => [p.name, p.canRemind])); expect(can).toEqual({ Cara: false, Dumi: true, Eve: false, Anna: false, Ben: false }); expect(data.counts).toMatchObject({ canRemind: 1, remindedRecently: 2 }); }); test('an anonymous form: no names anywhere, and no list of who has answered', async () => { mockDb.feedbackForm.findUnique.mockResolvedValue(form({ anonymous: true })); const data = await feedback.eventFeedback('ev1', NOW); expect(data.people).toBeNull(); expect(data.responses.every((r: any) => r.name === null)).toBe(true); expect(JSON.stringify(data)).not.toMatch(/Anna|Ben|Cara|u1@example/); expect(data.counts.notAnswered).toBe(3); }); test('an event without a form is a 404', async () => { mockDb.feedbackForm.findUnique.mockResolvedValue(null); await expect(feedback.eventFeedback('ev1', NOW)).rejects.toMatchObject({ statusCode: 404 }); }); }); describe('Remind', () => { test('not before the form has gone out', async () => { mockDb.feedbackForm.findUnique.mockResolvedValue(form({ sentAt: null })); await expect(feedback.remindFeedback('ev1')).rejects.toMatchObject({ statusCode: 409 }); }); test('not one by one on an anonymous form', async () => { mockDb.feedbackForm.findUnique.mockResolvedValue(form({ anonymous: true })); await expect(feedback.remindFeedback('ev1', { userIds: ['u4'] })).rejects.toMatchObject({ statusCode: 400 }); }); // count() is called for: everyone not answered, then those remindable now (the 24-hour rule). const counts = (notAnswered: number, remindable: number) => mockDb.feedbackInvite.count.mockResolvedValueOnce(notAnswered).mockResolvedValueOnce(remindable); test('answers straight away with who it will remind; the emails go in the background', async () => { mockDb.feedbackForm.findUnique.mockResolvedValue(form()); counts(3, 1); mockDb.feedbackInvite.findMany.mockResolvedValue([{ userId: 'u3' }, { userId: 'u4' }, { userId: 'u5' }]); const out = await feedback.remindFeedback('ev1', {}, NOW); expect(out).toMatchObject({ reminded: 1, newlyInvited: 0, skipped: 2, queued: true }); expect(out.message).toBe('Reminding 1 person. It carries on in the background. 2 people were sent the form or a reminder in the last 24 hours, so not again yet.'); const where = mockDb.feedbackInvite.count.mock.calls[1][0].where; expect(where).toMatchObject({ formId: 'form1', respondedAt: null }); expect(where.sentAt.lt).toEqual(new Date(NOW.getTime() - 24 * 3600e3)); expect(where.OR).toHaveLength(2); expect(mockEnqueue).toHaveBeenCalledWith('feedback-send', { formId: 'form1', kind: 'remind', userIds: null }); expect(mockMail).not.toHaveBeenCalled(); // not in the request }); test('people who can have the form but haven\'t yet are counted too', async () => { mockDb.feedbackForm.findUnique.mockResolvedValue(form()); counts(1, 0); mockDb.feedbackInvite.findMany.mockResolvedValue([{ userId: 'u1' }]); mockDb.ticket.findMany.mockResolvedValue([{ userId: 'u1' }, { userId: 'u9' }]); mockDb.user.findMany.mockResolvedValue([{ id: 'u1' }, { id: 'u9' }]); const out = await feedback.remindFeedback('ev1', {}, NOW); expect(out).toMatchObject({ reminded: 0, newlyInvited: 1, queued: true }); expect(out.message).toBe('Sending the form to 1 person for the first time. It carries on in the background. 1 person was sent the form or a reminder in the last 24 hours, so not again yet.'); }); test('one person on a named form', async () => { mockDb.feedbackForm.findUnique.mockResolvedValue(form()); counts(1, 1); const out = await feedback.remindFeedback('ev1', { userIds: ['u4'] }, NOW); expect(out.message).toBe('Reminding 1 person. It carries on in the background.'); expect(mockDb.feedbackInvite.count.mock.calls[0][0].where.userId).toEqual({ in: ['u4'] }); expect(mockEnqueue).toHaveBeenCalledWith('feedback-send', { formId: 'form1', kind: 'remind', userIds: ['u4'] }); }); test('everyone already reminded today: nothing queued', async () => { mockDb.feedbackForm.findUnique.mockResolvedValue(form()); counts(2, 0); mockDb.feedbackInvite.findMany.mockResolvedValue([]); const out = await feedback.remindFeedback('ev1', {}, NOW); expect(out.message).toBe('Everyone who hasn\'t answered was sent the form or a reminder in the last 24 hours. Try again tomorrow.'); expect(mockEnqueue).not.toHaveBeenCalled(); }); }); describe('the background task', () => { test('remind: invites the newly eligible, then reminds with the 24-hour rule', async () => { mockDb.feedbackForm.findUnique.mockResolvedValue(form()); mockDb.feedbackInvite.findMany.mockResolvedValue([{ id: 'i4', userId: 'u4', user: person('u4', 'Dumi') }]); expect(await runFeedbackTask({ formId: 'form1', kind: 'remind' })).toEqual({ invited: 0, reminded: 1 }); const where = mockDb.feedbackInvite.findMany.mock.calls[0][0].where; expect(where.sentAt.lt).toBeInstanceOf(Date); expect(mockDb.feedbackInvite.updateMany.mock.calls[0][0].data.reminderCount).toEqual({ increment: 1 }); // Claimed with the same rule, so a second task running at once skips them. expect(mockDb.feedbackInvite.updateMany.mock.calls[0][0].where).toMatchObject({ id: 'i4', respondedAt: null, sentAt: expect.any(Object), OR: expect.any(Array) }); expect(mockMail).toHaveBeenCalledWith(expect.objectContaining({ to: 'u4@example.com', subject: 'Reminder: How was Men\'s Breakfast?' })); }); test('remind one person: no new invites', async () => { mockDb.feedbackForm.findUnique.mockResolvedValue(form()); mockDb.feedbackInvite.findMany.mockResolvedValue([{ id: 'i4', userId: 'u4', user: person('u4', 'Dumi') }]); await runFeedbackTask({ formId: 'form1', kind: 'remind', userIds: ['u4'] }); expect(mockDb.feedbackInvite.findMany.mock.calls[0][0].where.userId).toEqual({ in: ['u4'] }); expect(mockDb.feedbackInvite.create).not.toHaveBeenCalled(); }); test('someone who answers while reminders go out isn\'t reminded', async () => { mockDb.feedbackForm.findUnique.mockResolvedValue(form()); mockDb.feedbackInvite.findMany.mockResolvedValue([{ id: 'i4', userId: 'u4', user: person('u4', 'Dumi') }]); mockDb.feedbackInvite.updateMany.mockResolvedValue({ count: 0 }); expect((await runFeedbackTask({ formId: 'form1', kind: 'remind', userIds: ['u4'] })).reminded).toBe(0); expect(mockMail).not.toHaveBeenCalled(); }); }); describe('the automatic reminder', () => { test('still goes only to people never reminded, and counts it', async () => { mockDb.feedbackForm.findUnique.mockResolvedValue(form()); mockDb.feedbackInvite.findMany.mockResolvedValue([{ id: 'i4', userId: 'u4', user: person('u4', 'Dumi') }]); expect(await sendFeedbackReminders('form1')).toBe(1); expect(mockDb.feedbackInvite.findMany.mock.calls[0][0].where).toEqual({ formId: 'form1', respondedAt: null, remindedAt: null }); expect(mockDb.feedbackInvite.updateMany.mock.calls[0][0].data.reminderCount).toEqual({ increment: 1 }); }); }); describe('overview', () => { test('newest event first, with status, response rate, average rating and last reminder', async () => { const older = { ...EVENT, id: 'ev0', title: 'Camp', startDate: new Date('2026-06-01T00:00:00Z') }; mockDb.feedbackForm.findMany.mockResolvedValue([ { id: 'form0', event: older, sendAt: null, sentAt: null, anonymous: true, _count: { invites: 0, responses: 0 } }, { id: 'form1', event: EVENT, sendAt: hoursAgo(72), sentAt: hoursAgo(72), anonymous: false, _count: { invites: 4, responses: 3 } }, ]); mockDb.feedbackAnswer.findMany.mockResolvedValue([{ value: '5', field: { formId: 'form1' } }, { value: '3', field: { formId: 'form1' } }]); mockDb.feedbackInvite.groupBy.mockResolvedValue([{ formId: 'form1', _max: { remindedAt: hoursAgo(5) } }]); const rows = await feedback.feedbackOverview({}); expect(rows.map((r: any) => [r.event.title, r.status, r.responseRate, r.averageRating])).toEqual([ ['Men\'s Breakfast', 'sent', 75, 4], ['Camp', 'not_scheduled', null, null], ]); expect(rows[0].lastReminderAt).toEqual(hoursAgo(5)); }); });