Get Payout Report

curl https://api.bio.re/api/v1/payouts/report \
  -H "Authorization: Bearer $ACCESS_TOKEN"

curl 'https://api.bio.re/api/v1/payouts/report?month=2026-04' \
  -H "Authorization: Bearer $ACCESS_TOKEN"

type PayoutStatus =
  | 'PENDING' | 'APPROVED' | 'PROCESSING' | 'PROCESSED'
  | 'FAILED' | 'CANCELLED' | 'REJECTED';

type PayoutReportItem = {
  id: string;
  creatorId: string;
  amount: string;            // Decimal as string
  method: 'STRIPE_CONNECT' | 'BANK_TRANSFER';
  status: PayoutStatus;
  createdAt: string;
  approvedAt: string | null;
  processedAt: string | null;
  stripePayoutId: string | null;
  commissionRate: number | null;
  commissionAmount: string | null;
  netAmount: string | null;
};

type PayoutReport = {
  payouts: PayoutReportItem[];
  total: number;             // sums ALL statuses
  count: number;
};

async function getPayoutReport(
  accessToken: string,
  month?: string,            // YYYY-MM
): Promise<PayoutReport> {
  const url = new URL('https://api.bio.re/api/v1/payouts/report');
  if (month) url.searchParams.set('month', month);

  const res = await fetch(url, {
    headers: { Authorization: `Bearer ${accessToken}` },
  });
  const json = await res.json();
  if (!res.ok || !json.success) {
    throw Object.assign(new Error(json?.error?.message ?? 'Report failed'), {
      code: json?.error?.code,
    });
  }
  return json.data;
}

// "Actually paid out" — server's `total` includes rejected/cancelled, so derive yourself:
function actuallyPaid(report: PayoutReport): number {
  return report.payouts
    .filter(p => p.status === 'PROCESSED')
    .reduce((s, p) => s + Number(p.netAmount ?? p.amount), 0);
}

import { useQuery } from '@tanstack/react-query';

export const payoutKeys = {
  report: (month?: string) => ['payout', 'report', month ?? 'all'] as const,
};

export function usePayoutReport(month?: string) {
  return useQuery({
    queryKey: payoutKeys.report(month),
    queryFn: async () => {
      const url = new URL('/api/v1/payouts/report', location.origin);
      if (month) url.searchParams.set('month', month);
      const res = await fetch(url);
      const json = await res.json();
      if (!res.ok || !json.success) {
        throw Object.assign(new Error(json?.error?.message ?? 'Report failed'), {
          code: json?.error?.code,
        });
      }
      return json.data as PayoutReport;
    },
    staleTime: 60_000,
  });
}