#!/usr/bin/env python3
"""Учебная оценка реактивации, Python3.9+, stdlib. Не клиент CRM-платформы."""
from pathlib import Path
import csv,json,sys
from decimal import Decimal

def load(path):
 with path.open(encoding='utf-8') as f:return list(csv.DictReader(f,delimiter=';'))
def evaluate(folder):
 assigned=load(folder/'assignments.csv');orders=load(folder/'orders.csv');contacts=load(folder/'contacts.csv');bad_contacts=load(folder/'contacts-contaminated.csv');rules=json.loads((folder/'rules.json').read_text())
 ids=[x['customer_id'] for x in assigned];assert len(ids)==len(set(ids)),'Duplicate assignment';groups={x['customer_id']:x['group'] for x in assigned};assert set(groups.values())=={'test','control'}
 order_ids=[x['order_id'] for x in orders];assert len(order_ids)==len(set(order_ids)),'Duplicate order'
 assert all(x['customer_id'] in groups for x in orders),'Unassigned order'
 for row in orders:
  for k in ['paid_day','gross_RUB','discount_RUB','cogs_RUB','fulfillment_RUB','refund_RUB','recovered_cogs_RUB','return_logistics_RUB','refund_day']:row[k]=int(row[k]);assert row[k]>=0
  assert row['discount_RUB']<=row['gross_RUB'] and row['refund_RUB']<=row['gross_RUB']-row['discount_RUB'],'Impossible revenue/refund'
  assert row['recovered_cogs_RUB']<=row['cogs_RUB'],'Recovered cost exceeds original'
 result={}
 for as_of in [7,30]:
  metrics={}
  for group in ['test','control']:
   members=[x['customer_id'] for x in assigned if x['group']==group];paid=[x for x in orders if groups[x['customer_id']]==group and 1<=x['paid_day']<=7 and x['paid_day']<=as_of]
   gross=sum(x['gross_RUB'] for x in paid);discount=sum(x['discount_RUB'] for x in paid);cogs=sum(x['cogs_RUB'] for x in paid);fulfill=sum(x['fulfillment_RUB'] for x in paid)
   mature=[x for x in paid if x['refund_day'] and x['refund_day']<=as_of];refund=sum(x['refund_RUB'] for x in mature);recovered=sum(x['recovered_cogs_RUB'] for x in mature);retlog=sum(x['return_logistics_RUB'] for x in mature)
   campaign=rules['campaign_cost_RUB'][group];profit=gross-discount-refund-cogs+recovered-fulfill-retlog-campaign
   metrics[group]={'assigned':len(members),'ever_paid_buyers':len({x['customer_id'] for x in paid}),'gross_RUB':gross,'discount_RUB':discount,'refund_RUB':refund,'net_revenue_RUB':gross-discount-refund,'cogs_RUB':cogs,'recovered_cogs_RUB':recovered,'fulfillment_RUB':fulfill,'return_logistics_RUB':retlog,'campaign_cost_RUB':campaign,'contribution_RUB':profit,'per_assigned_RUB':str(Decimal(profit)/len(members))}
  result[str(as_of)]={'groups':metrics,'difference_per_assigned_RUB':str(Decimal(metrics['test']['per_assigned_RUB'])-Decimal(metrics['control']['per_assigned_RUB']))}
 reached={x['customer_id'] for x in contacts if x['delivered']=='1' and x['campaign']=='reactivation'}
 contaminated={x['customer_id'] for x in bad_contacts if x['delivered']=='1' and groups[x['customer_id']]=='control'}
 # Ошибочный many-to-one join для демонстрации; правильный расчёт выше его не использует.
 naive=sum(o['gross_RUB'] for o in orders for c in contacts if o['customer_id']==c['customer_id'] and c['delivered']=='1')
 return {'snapshots':result,'unique_reached_test':len(reached),'other_contact_in_control':sorted(contaminated),'naive_join_gross_test_RUB':naive,'correct_test_orders':len([x for x in orders if groups[x['customer_id']]=='test'])}
if __name__=='__main__':
 base=Path(sys.argv[1]) if len(sys.argv)>1 else Path(__file__).resolve().parent;dest=Path(sys.argv[2]) if len(sys.argv)>2 else base/'result.json';r=evaluate(base);dest.write_text(json.dumps(r,ensure_ascii=False,indent=2),encoding='utf-8');print(json.dumps(r,ensure_ascii=False))
