Skip to content

A local-first personal finance app

3.8 KB
Raw Blame
import type { DataEntity } from '@actual-app/core/types/models';
import { renderHook } from '@testing-library/react';

import type { QueryDataEntity } from '#components/reports/ReportOptions';
import { SpreadsheetProvider, useSpreadsheet } from '#hooks/useSpreadsheet';

import { createCustomSpreadsheet } from './custom-spreadsheet';
import { fetchSpreadsheetQueryData } from './fetchSpreadsheetQueryData';

vi.mock('@actual-app/core/platform/client/connection', () => ({
  send: vi.fn().mockResolvedValue({ filters: [] }),
  listen: vi.fn(() => vi.fn()),
}));
vi.mock('./fetchSpreadsheetQueryData');

const transaction: QueryDataEntity = {
  date: '2026-01',
  category: 'category',
  categoryHidden: false,
  categoryGroup: 'group',
  categoryGroupHidden: false,
  account: 'account',
  accountOffBudget: false,
  payee: 'payee',
  transferAccount: '',
  notes: '#red #circle',
  amount: -100,
};

it.each([
  { categoryHidden: true },
  { categoryGroupHidden: true },
  { accountOffBudget: true },
  { category: null },
])(
  'does not create empty combinations from excluded transactions %j',
  async excluded => {
    vi.mocked(fetchSpreadsheetQueryData).mockResolvedValue({
      assets: [],
      debts: [
        { ...transaction, ...excluded },
        { ...transaction, notes: '#red', amount: -50 },
        { ...transaction, notes: '#red', amount: -25, date: '2026-02' },
      ],
    });
    const { result } = renderHook(useSpreadsheet, {
      wrapper: SpreadsheetProvider,
    });
    const setData = vi.fn<(data: DataEntity) => void>();
    await createCustomSpreadsheet({
      startDate: '2026-01',
      endDate: '2026-02',
      interval: 'Monthly',
      categories: { list: [], grouped: [] },
      conditions: [],
      conditionsOp: 'and',
      showEmpty: true,
      showOffBudget: false,
      showHiddenCategories: false,
      showUncategorized: false,
      trimIntervals: false,
      groupBy: 'Tag',
      tags: [
        { id: 'red', tag: 'red' },
        { id: 'circle', tag: 'circle' },
      ],
    })(result.current, setData);

    const data = setData.mock.calls[0][0];
    expect(data.data?.map(group => group.name)).toEqual(
      expect.arrayContaining(['#red', '#circle', 'Untagged']),
    );
    expect(data.data).toHaveLength(3);
    expect(data.totalDebts).toBe(-75);
    expect(data.intervalData.map(interval => interval.totalDebts)).toEqual([
      -50, -25,
    ]);
  },
);

it('rolls monthly rows up into calendar quarters for Quarterly reports', async () => {
  vi.mocked(fetchSpreadsheetQueryData).mockResolvedValue({
    assets: [],
    debts: [
      { ...transaction, notes: '#red', amount: -50, date: '2026-01' },
      { ...transaction, notes: '#red', amount: -25, date: '2026-03' },
      { ...transaction, notes: '#red', amount: -10, date: '2026-04' },
      { ...transaction, notes: '#red', amount: -5, date: '2026-09' },
    ],
  });
  const { result } = renderHook(useSpreadsheet, {
    wrapper: SpreadsheetProvider,
  });
  const setData = vi.fn<(data: DataEntity) => void>();
  await createCustomSpreadsheet({
    startDate: '2026-01-01',
    endDate: '2026-09-30',
    interval: 'Quarterly',
    categories: { list: [], grouped: [] },
    conditions: [],
    conditionsOp: 'and',
    showEmpty: false,
    showOffBudget: false,
    showHiddenCategories: false,
    showUncategorized: false,
    trimIntervals: false,
    groupBy: 'Tag',
    tags: [{ id: 'red', tag: 'red' }],
  })(result.current, setData);

  const data = setData.mock.calls[0][0];
  expect(data.intervalData.map(interval => interval.date)).toEqual([
    "Q1 '26",
    "Q2 '26",
    "Q3 '26",
  ]);
  expect(data.intervalData.map(interval => interval.totalDebts)).toEqual([
    -75, -10, -5,
  ]);
  expect(data.intervalData.map(interval => interval.intervalEndDate)).toEqual([
    '2026-03-31',
    '2026-06-30',
    '2026-09-30',
  ]);
  expect(data.totalDebts).toBe(-90);
});