Multi-Wallet Management

type WalletSummary = {
  id: string
  name: string
  balance: number        // Net balance (income - expenses)
  income: number         // Total income
  expense: number        // Total expenses
  transactionCount: number
  positiveCount: number  // Number of income transactions
  negativeCount: number  // Number of expense transactions
  status: "Activa" | "Sin movimientos"
}

const formatBcvAmount = (usdAmount: number) => {
  if (!bcvRate || usdAmount === 0) {
    return null
  }
  return formatCurrency(usdAmount * bcvRate, "VES")
}

status: wallet.transactionCount > 0 ? "Activa" : "Sin movimientos"

for (const tx of transactions) {
  const amount = Number(tx.monto ?? 0)
  if (tx.tipo === "ingreso") {
    wallet.income += amount
    wallet.balance += amount
    wallet.positiveCount += 1
  } else if (tx.tipo === "gasto") {
    wallet.expense += amount
    wallet.balance -= amount
    wallet.negativeCount += 1
  }
  wallet.transactionCount += 1
  wallet.status = "Activa"
}

// Check for linked transactions before deletion
const { count } = await supabase
  .from("transacciones")
  .select("id", { count: "exact", head: true })
  .eq("billetera_id", walletId)

if (count > 0) {
  throw new Error("Cannot delete wallet with transactions")
}

// Broadcast wallet updates
window.dispatchEvent(new CustomEvent("wallets:updated"))

// Listen for updates from other components
window.addEventListener("wallet:changed", handleWalletChanged)

CREATE TABLE billeteras (
  id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
  nombre VARCHAR(13) NOT NULL,
  usuario_id UUID NOT NULL REFERENCES auth.users(id),
  created_at TIMESTAMP WITH TIME ZONE DEFAULT now()
);