"""Payroll Cost Desk v1. Decimal event model; all dates/cash illustrative."""
from decimal import Decimal, ROUND_HALF_UP
from copy import deepcopy
import json, csv
from pathlib import Path
from datetime import date as Date
D=lambda x:Decimal(str(x))
def money(x): return D(x).quantize(D('.01'),rounding=ROUND_HALF_UP)
def employment(salaries):
    return [{'salary':D(s),'ni':max(D(s)-5000,D(0))*D('.15'),'pension':max(min(D(s),D(50270))-6240,D(0))*D('.03')} for s in salaries]
def run(case):
    missing=[k for k in ('opening_usd','buffer_usd','rate_usd_per_gbp','deposit_gbp','monthly_fee_usd','deposit_date','funding_dates','receipts','salaries_gbp') if case.get(k) is None or case.get(k)=='']
    if missing:return {'status':'unresolved','missing':missing,'first_buffer_failure':None,'first_cash_shortfall':None}
    try:
        numbers=[case[k] for k in ('opening_usd','buffer_usd','rate_usd_per_gbp','deposit_gbp','monthly_fee_usd')]+case['salaries_gbp']+[a for d,a in case['receipts']]+[case.get('monthly_extra_gbp',0)]
        if not case['salaries_gbp'] or not case['funding_dates']:raise ValueError('salaries and funding events required')
        if any(not D(n).is_finite() or D(n)<0 for n in numbers) or D(case['rate_usd_per_gbp'])<=0:raise ValueError('amounts must be nonnegative and rate positive')
        for d in [case['deposit_date'],*case['funding_dates'],*[d for d,a in case['receipts']]]:
            if Date.fromisoformat(d).isoformat()!=d or not '2026-11-24'<=d<='2027-04-05':raise ValueError('date outside supported 24 Nov 2026-5 Apr 2027 period')
    except (ValueError,TypeError,KeyError,ArithmeticError) as e:
        return {'status':'invalid inputs','reason':str(e)}
    rate=D(case['rate_usd_per_gbp']); annual=sum(sum(r.values()) for r in employment(case['salaries_gbp']))
    monthly=annual/12+D(case.get('monthly_extra_gbp',0)); fee=D(case['monthly_fee_usd'])
    events=[{'date':case['deposit_date'],'kind':'deposit','out':money(D(case['deposit_gbp'])*rate),'in':D(0),'claim':'C-TEA-DEPOSIT / C-REM-RESERVE / C-DEEL-DEPOSIT per scenario'}]
    for date in case['funding_dates']:events.append({'date':date,'kind':'employment and fee','out':money(monthly*rate+fee),'in':D(0),'claim':'C-NI, C-PENSION; fee/rate/date assumptions'})
    for date,amount in case['receipts']:events.append({'date':date,'kind':'buyer receipt','out':D(0),'in':D(amount),'claim':'A-CASH'})
    # Mandatory outflows before same-date receipts: intraday availability not assumed.
    events.sort(key=lambda e:(e['date'],0 if e['out'] else 1))
    balance=D(case['opening_usd']); buffer=D(case['buffer_usd']); minimum=balance; first_buffer='2026-11-24 (opening)' if balance<buffer else None; first_cash=None
    for e in events:
        balance+=e['in']-e['out'];minimum=min(minimum,balance)
        e['balance_usd']=money(balance);e['buffer_headroom_usd']=money(balance-buffer)
        if balance<buffer and not first_buffer:first_buffer=e['date']
        if balance<0 and not first_cash:first_cash=e['date']
    return {'status':'fails cash' if first_cash else 'fails buffer' if first_buffer else 'fundable under assumptions','annual_employment_gbp':money(annual),'monthly_employment_gbp_unrounded':monthly,'monthly_funding_usd':money(monthly*rate+fee),'annual_expense_usd':money((annual+D(case.get('monthly_extra_gbp',0))*12)*rate+fee*12),'deposit_usd':money(D(case['deposit_gbp'])*rate),'held_at_horizon_gbp':D(case['deposit_gbp']),'minimum_balance_usd':money(minimum),'extra_opening_needed_usd':money(max(buffer-minimum,D(0))),'first_buffer_failure':first_buffer,'first_cash_shortfall':first_cash,'events':events}
def serial(x):
    if isinstance(x,Decimal):return str(x)
    raise TypeError(type(x))
BASE={'label':'Illustrative common funding calendar, not a supplier quote','salaries_gbp':[70000,85000,100000],'opening_usd':75000,'buffer_usd':10000,'rate_usd_per_gbp':'1.30','monthly_fee_usd':1797,'deposit_gbp':21250,'deposit_date':'2026-11-24','funding_dates':['2026-11-30','2026-12-23','2027-01-25'],'receipts':[['2026-12-15',35000],['2027-01-15',35000]],'monthly_extra_gbp':0}
def cases():
    monthly=sum(sum(r.values()) for r in employment(BASE['salaries_gbp']))/12
    out={}
    for name,dep in [('teamed_policy',D(21250)),('remote_standard_policy',monthly),('remote_waiver_condition',D(0)),('deel_1x_policy',monthly+D(1797)/D('1.30')),('deel_1_5x_policy',(monthly+D(1797)/D('1.30'))*D('1.5')),('gp_unresolved',None)]:
        out[name]={**deepcopy(BASE),'deposit_gbp':dep}
    out['teamed_70000_opening']={**deepcopy(out['teamed_policy']),'opening_usd':70000}
    out['teamed_1_40_rate']={**deepcopy(out['teamed_policy']),'rate_usd_per_gbp':'1.40'}
    out['teamed_late_receipt']=deepcopy(out['teamed_policy']);out['teamed_late_receipt']['receipts'][0][0]='2026-12-24'
    out['teamed_extra_3000_gbp_monthly']={**deepcopy(out['teamed_policy']),'monthly_extra_gbp':3000}
    return out
if __name__=='__main__':
    import argparse
    ap=argparse.ArgumentParser();ap.add_argument('output_directory');ap.add_argument('--input',help='JSON mapping of case names to complete case inputs');args=ap.parse_args()
    dest=Path(args.output_directory);dest.mkdir(parents=True,exist_ok=True)
    cs=json.loads(Path(args.input).read_text()) if args.input else cases()
    results={k:run(v) for k,v in cs.items()}
    (dest/'scenarios.json').write_text(json.dumps(cs,default=serial,indent=2)+'\n')
    (dest/'results.json').write_text(json.dumps(results,default=serial,indent=2)+'\n')
    with (dest/'funding-ledger.csv').open('w') as f:
        w=csv.writer(f);w.writerow(['scenario','date','kind','out_usd','in_usd','balance_usd','headroom_usd','binding'])
        for key,r in results.items():
            for e in r.get('events',[]):w.writerow([key,e['date'],e['kind'],e['out'],e['in'],e['balance_usd'],e['buffer_headroom_usd'],e['claim']])
    print(json.dumps({k:{x:v for x,v in r.items() if x!='events'} for k,r in results.items()},default=serial,indent=2))
