#!/usr/bin/env python3
"""Учебный расчёт; Python 3.9+, стандартная библиотека. Все суммы — RUB."""
import csv, json, sys
from decimal import Decimal, ROUND_HALF_UP
from pathlib import Path

def calculate(data):
    output={}
    for scenario, plan in data['scenario_plans'].items():
        free={k:v['opening']-v['restricted'] for k,v in data['entities'].items()}
        debt={k:0 for k in free}; factor=0; intra=0; interest=Decimal(0); rows=[]
        for day in range(1,4):
            for entity in free:
                flow=data['base_flows'][entity][str(day)]
                if scenario=='delayed_receipt' and entity=='B':
                    flow+=-3000000 if day==2 else 3000000 if day==3 else 0
                free[entity]+=flow
            for d,e,kind,amount in plan:
                if d!=day: continue
                if kind=='bank_draw': debt[e]+=amount; free[e]+=amount
                elif kind=='bank_repay': debt[e]-=amount; free[e]-=amount
                elif kind=='loan_out': free[e]-=amount; intra+=amount
                elif kind=='loan_in': free[e]+=amount
                elif kind=='loan_repay': free[e]-=amount; intra-=amount
                elif kind=='loan_return': free[e]+=amount
                elif kind=='factor_draw': free[e]+=amount; factor+=amount
                elif kind=='factor_repay': free[e]-=amount
                else: raise ValueError('Unknown operation: '+kind)
                assert 0<=debt[e]<=data['entities'][e]['credit_limit'], 'Bank limit violated'
                assert 0<=intra<=data['intercompany_limit'], 'Intercompany limit violated'
            for entity in free:
                assert free[entity]>=data['minimum'], 'Minimum violated: '+scenario+'/'+entity+'/'+str(day)
                interest+=Decimal(debt[entity])*Decimal(data['entities'][entity]['annual_rate'])/Decimal(data['day_basis'])
                rows.append({'day':day,'entity':entity,'free_RUB':free[entity],'restricted_RUB':data['entities'][entity]['restricted'],'bank_debt_RUB':debt[entity]})
        assert all(v==0 for v in debt.values()) and intra==0, 'Debt not repaid in horizon'
        # Комиссия факторинга дана условием: 2% от суммы аванса, погашена в Д3.
        fee=Decimal(factor)*Decimal('0.02')
        output[scenario]={'rows':rows,'interest_RUB':str(interest.quantize(Decimal('0.01'),rounding=ROUND_HALF_UP)),'factor_fee_RUB':str(fee.quantize(Decimal('0.01'))),'total_cost_RUB':str((interest+fee).quantize(Decimal('0.01'),rounding=ROUND_HALF_UP))}
    return output

if __name__=='__main__':
    folder=Path(__file__).resolve().parent
    source=Path(sys.argv[1]) if len(sys.argv)>1 else folder/'case.json'
    result=calculate(json.loads(source.read_text(encoding='utf-8')))
    dest=Path(sys.argv[2]) if len(sys.argv)>2 else folder/'result.json'
    dest.write_text(json.dumps(result,ensure_ascii=False,indent=2),encoding='utf-8')
    with dest.with_suffix('.csv').open('w',encoding='utf-8',newline='') as handle:
        writer=csv.writer(handle,delimiter=';');writer.writerow(['scenario','day','entity','free_RUB','restricted_RUB','bank_debt_RUB'])
        for name,value in result.items():
            for row in value['rows']:writer.writerow([name,row['day'],row['entity'],row['free_RUB'],row['restricted_RUB'],row['bank_debt_RUB']])
    print(json.dumps({name:{k:v for k,v in value.items() if k!='rows'} for name,value in result.items()},ensure_ascii=False))
