Expense splitting app

18export default function HomeScreen() {
19  const primary = useThemeColor('--primary');
20  const primaryDeep = useThemeColor('--primary', { shade: -0.35 });
21  const accent = useThemeColor('--accent');
22  const mutedFg = useThemeColor('--muted-foreground');
23  const { client } = useApp();
24  const { user } = useAuth();
25
26  const groupsQ = useQuery({
27    queryKey: ['groups', user?.id],
28    queryFn: async () => {
29      const { data, error } = await client.from('groups').select('*').order('created_at');
30      if (error) throw error;
31      return data ?? [];
32    },
33    enabled: !!user,
34  });
35
36  const expensesQ = useQuery({
37    queryKey: ['expenses', user?.id],
38    queryFn: async () => {
39      const { data, error } = await client.from('expenses').select('*').order('created_at', { ascending: false });
40      if (error) throw error;
41      return data ?? [];
42    },
43    enabled: !!user,
44  });
45
46  const splitsQ = useQuery({
47    queryKey: ['expense-splits', user?.id],
48    queryFn: async () => {
49      const { data, error } = await client.from('expense_splits').select('*');
50      if (error) throw error;
51      return data ?? [];

41export function computeNetBalance(
42  userId: string,
43  expenses: Expense[],
44  splits: ExpenseSplit[],
45  settlements: Settlement[],
46): number {
47  let net = 0;
48  for (const e of expenses) {
49    if (e.paid_by === userId) net += e.amount_cents;
50    for (const s of splits) {
51      if (s.expense_id === e.id && s.user_id === userId) {
52        net -= s.share_cents;
53      }
54    }
55  }
56  for (const st of settlements) {
57    if (st.from_user === userId) net -= st.amount_cents;
58    if (st.to_user === userId) net += st.amount_cents;
59  }
60  return net;
61}
62
63export function useAllBalances(
64  groups: Group[] | undefined,
65  expenses: Expense[] | undefined,
66  splits: ExpenseSplit[] | undefined,
67  settlements: Settlement[] | undefined,
68) {
69  const { user } = useAuth();
70  return useMemo(() => {
71    if (!groups || !expenses || !splits || !settlements || !user) {
72      return { groupBalances: new Map<string, number>(), totalOwed: 0, totalOwes: 0 };
73    }
74    const groupBalances = new Map<string, number>();

6create or replace function public.is_group_member(gid text)
7returns boolean
8language sql
9stable
10security definer
11set search_path = public
12as $$
13  select exists (
14    select 1 from group_members
15    where group_members.user_id = auth.uid()
16      and group_members.group_id = gid
17  );
18$$;
19
20-- ============================================================
21-- group_members
22-- ============================================================
23drop policy if exists group_members_select on group_members;
24create policy group_members_select on group_members
25  for select using (
26    user_id = auth.uid() or is_group_member(group_id)
27  );
28
29drop policy if exists group_members_insert on group_members;
30create policy group_members_insert on group_members
31  for insert with check (
32    user_id = auth.uid() or is_group_member(group_id)
33  );
34
35drop policy if exists group_members_delete on group_members;
36create policy group_members_delete on group_members
37  for delete using (
38    user_id = auth.uid() or is_group_member(group_id)
39  );

39export const lightTheme = vars({
40  "--radius": "16",
41
42  "--background": "245 250 249",
43  "--foreground": "16 42 39",
44
45  "--card": "255 255 255",
46  "--card-foreground": "16 42 39",
47
48  "--popover": "255 255 255",
49  "--popover-foreground": "16 42 39",
50
51  "--primary": "13 148 136",
52  "--primary-foreground": "255 255 255",
53
54  "--secondary": "204 251 241",
55  "--secondary-foreground": "6 70 63",
56
57  "--muted": "226 240 237",
58  "--muted-foreground": "91 117 112",
59
60  "--accent": "245 158 11",
61  "--accent-foreground": "66 42 2",
62
63  "--destructive": "220 38 38",
64
65  "--border": "221 236 232",
66  "--input": "221 236 232",
67  "--ring": "13 148 136",
68
69  "--chart-1": "13 148 136",
70  "--chart-2": "245 158 11",
71  "--chart-3": "124 58 237",
72  "--chart-4": "236 72 153",