"""Shared loan maths used by both dashboards (same rules as Loan Reports)."""
from decimal import Decimal

from django.db.models import DecimalField, Sum, Value
from django.db.models.functions import Coalesce

from NexusApp.utils.loan_schedule import loan_position

MONEY = DecimalField(max_digits=14, decimal_places=2)
ZERO = Decimal('0')


def with_paid(qs):
    return qs.annotate(
        paid=Coalesce(Sum('payments__amount'), Value(0), output_field=MONEY)
    )


def loan_due_state(loan, today):
    """Return (status, next_due_date, overdue_amount) for an annotated loan."""
    pos = loan_position(loan, loan.paid, today)
    return pos['status'], pos['next_due'], pos['overdue'] if pos['status'] == 'Overdue' else ZERO


def portfolio_summary(loans_qs, today):
    """Counts / amounts for a set of loans (any queryset of Loan)."""
    summary = {
        'active_loans': 0, 'completed_loans': 0,
        'overdue_loans': 0, 'overdue_amount': ZERO, 'overdue_customers': 0,
        'due_today': 0, 'upcoming_dues': 0,
        'payable': ZERO, 'paid': ZERO,
    }
    overdue_customers = set()
    for loan in with_paid(loans_qs.order_by()):
        summary['payable'] += loan.total_payable
        summary['paid'] += loan.paid or ZERO
        status, next_due, overdue_amount = loan_due_state(loan, today)
        if status == 'Completed':
            summary['completed_loans'] += 1
            continue
        summary['active_loans'] += 1
        if status == 'Overdue':
            summary['overdue_loans'] += 1
            summary['overdue_amount'] += overdue_amount
            overdue_customers.add(loan.customer_id)
        elif status == 'Due Today':
            summary['due_today'] += 1
        elif next_due and (next_due - today).days <= 7:
            summary['upcoming_dues'] += 1
    summary['overdue_customers'] = len(overdue_customers)
    summary['pending'] = max(summary['payable'] - summary['paid'], ZERO)
    summary['recovery_rate'] = (
        int(round(summary['paid'] * 100 / summary['payable'])) if summary['payable'] > 0 else 0
    )
    return summary


def inr(value):
    """12345678.5 -> '1,23,45,679' (Indian digit grouping, no decimals)."""
    import re
    n = int(Decimal(str(value or 0)).quantize(Decimal('1')))
    sign = '-' if n < 0 else ''
    s = str(abs(n))
    if len(s) > 3:
        head, tail = s[:-3], s[-3:]
        head = re.sub(r'(\d)(?=(\d\d)+$)', r'\1,', head)
        s = head + ',' + tail
    return sign + s
