"""Local teaching fixture. No network, model calls, customer messages or writes."""
import csv
import io
import json
from datetime import date
from decimal import Decimal, InvalidOperation

DATA = '''id,currency,total,paid,due,disputed
A,USD,100.00,20.00,2026-10-01,false
B,USD,50.00,50.00,2026-10-01,false
C,USD,30.00,0.00,2026-12-01,false
D,USD,40.00,0.00,2026-10-01,true
E,USD,60.00,0.00,2026-11-09,false
F,EUR,25.00,0.00,2026-10-02,false
'''
FIELDS = {'id', 'currency', 'total', 'paid', 'due', 'disputed'}

def money(value):
    try:
        n = Decimal(value)
    except InvalidOperation as exc:
        raise ValueError('invalid money') from exc
    if not n.is_finite() or n < 0 or n != n.quantize(Decimal('0.01')):
        raise ValueError('money must be finite, nonnegative, exact cents')
    return n

def report(raw, as_of):
    """Whole batch fails on malformed rows; disputes are held, not resolved."""
    reader = csv.DictReader(io.StringIO(raw))
    if set(reader.fieldnames or []) != FIELDS or len(reader.fieldnames) != len(FIELDS):
        raise ValueError('unexpected schema')
    seen, accepted, excluded, totals = set(), [], [], {}
    for row in reader:
        if None in row or any(v is None for v in row.values()):
            raise ValueError('malformed row')
        key = row['id']
        if not key or key in seen:
            raise ValueError('empty or duplicate id')
        seen.add(key)
        if row['currency'] not in {'USD', 'EUR'}:
            raise ValueError('unsupported currency')
        if row['disputed'] not in {'true', 'false'}:
            raise ValueError('invalid dispute flag')
        total, paid = money(row['total']), money(row['paid'])
        if paid > total:
            raise ValueError('overpayment needs a separate policy')
        balance = total - paid
        due = date.fromisoformat(row['due'])
        reason = ('disputed' if row['disputed'] == 'true' else
                  'settled' if balance == 0 else
                  'not_overdue' if due >= as_of else None)
        if reason:
            excluded.append({'id': key, 'reason': reason})
            continue
        accepted.append({'id': key, 'currency': row['currency'], 'balance': str(balance)})
        totals[row['currency']] = totals.get(row['currency'], Decimal('0')) + balance
    return {'as_of': as_of.isoformat(), 'accepted': accepted, 'excluded': excluded,
            'totals': {k: str(v) for k, v in sorted(totals.items())}}

def must_reject(raw):
    try:
        report(raw, date(2026, 11, 9))
    except ValueError:
        return
    raise AssertionError('invalid input was accepted')

if __name__ == '__main__':
    result = report(DATA, date(2026, 11, 9))
    assert [r['id'] for r in result['accepted']] == ['A', 'F']
    assert result['totals'] == {'EUR': '25.00', 'USD': '80.00'}
    assert {r['id']: r['reason'] for r in result['excluded']} == {
        'B': 'settled', 'C': 'not_overdue', 'D': 'disputed', 'E': 'not_overdue'}
    assert result == report(DATA, date(2026, 11, 9))
    for raw in [DATA + 'A,USD,1.00,0.00,2026-10-01,false\n',
                DATA.replace('100.00', 'NaN'), DATA.replace('100.00', '-1.00'),
                DATA.replace('20.00', '120.00'), DATA.replace('100.00', '100.001')]:
        must_reject(raw)
    print(json.dumps(result, indent=2))
    print('9 checks passed; synthetic data only.')
