
import re
import logging
from decimal import Decimal

from django.contrib import messages
from django.http import JsonResponse
from django.shortcuts import redirect, render
from django.utils import timezone

from NexusApp.models import Loan

logger = logging.getLogger(__name__)

ZERO = Decimal('0')


# -------------------------------------------------------------
# MONEY FORMATTER
# -------------------------------------------------------------

def _money(value):
    value = Decimal(str(value or 0))

    sign = '-' if value < 0 else ''
    value = abs(value)

    whole = int(value)
    paise = value - whole

    s = str(whole)

    if len(s) > 3:
        head, tail = s[:-3], s[-3:]
        s = re.sub(r'(\d)(?=(\d\d)+$)', r'\1,', head) + ',' + tail

    if paise:
        s += f'.{int(paise * 100):02d}'

    return f'{sign}₹{s}'


# -------------------------------------------------------------
# WHATSAPP NUMBER
# -------------------------------------------------------------

def _whatsapp_number(phone):
    digits = re.sub(r'\D', '', phone or '')
    return '91' + digits[-10:] if len(digits) >= 10 else ''


# -------------------------------------------------------------
# GET PAYMENT HISTORY ROWS FOR AJAX
# -------------------------------------------------------------

def build_invoice_payment_rows(loan):

    payments = loan.payments.select_related(
        'collected_by'
    ).order_by('payment_date', 'id')

    rows = []

    running_paid = ZERO
    due_amount = loan.due_amount or ZERO
    total_payable = loan.total_payable or ZERO

    for number, payment in enumerate(payments, start=1):

        running_paid += payment.amount

        extra = (
            max(payment.amount - due_amount, ZERO)
            if due_amount > 0 else ZERO
        )

        balance = max(total_payable - running_paid, ZERO)

        rows.append({
            'sno': number,
            'date': payment.payment_date.strftime('%d %b %Y'),
            'amount': _money(payment.amount),

            'method': payment.get_payment_method_display(),
            'method_key': payment.payment_method,

            'collected_by': (
                payment.collected_by.name
                if payment.collected_by else '-'
            ),

            'extra': _money(extra),
            'has_extra': extra > 0,

            'balance': _money(balance),
            'has_balance': balance > 0,

            'status': payment.get_payment_status_display(),
            'is_completed': payment.payment_status == 'completed',
        })

    return rows


# -------------------------------------------------------------
# INVOICE SUMMARY DATA
# -------------------------------------------------------------

def build_invoice_context(loan):

    due_amount = loan.due_amount or ZERO
    total_payable = loan.total_payable or ZERO

    payments = loan.payments.select_related(
        'collected_by'
    ).order_by('payment_date', 'id')

    total_paid = ZERO
    total_extra = ZERO
    total_payments = 0

    for payment in payments:

        total_payments += 1
        total_paid += payment.amount

        extra = (
            max(payment.amount - due_amount, ZERO)
            if due_amount > 0 else ZERO
        )

        total_extra += extra

    total_pending = max(total_payable - total_paid, ZERO)

    if due_amount > 0:
        paid_dues = min(
            int(total_paid // due_amount),
            loan.number_of_dues
        )
    else:
        paid_dues = 0

    return {
        'loan': loan,

        'invoice_no': f'NEXUS-{loan.id:03d}',
        'invoice_date': timezone.localdate().strftime('%d %b %Y'),

        'branch': loan.place.name,
        'whatsapp_number': _whatsapp_number(loan.phone_number),

        'loan_amount': _money(loan.loan_amount),
        'due_amount': _money(due_amount),

        'payment_type': loan.get_payment_type_display(),

        'total_dues': loan.number_of_dues,
        'paid_dues': paid_dues,
        'pending_dues': loan.number_of_dues - paid_dues,

        'total_payments': total_payments,
        'total_paid': _money(total_paid),
        'total_pending': _money(total_pending),
        'total_extra': _money(total_extra),
    }


# -------------------------------------------------------------
# PAYMENT INVOICE PAGE
# GET /admin/payment_invoice/?id=LOAN_ID
# -------------------------------------------------------------

def payment_invoice(request):

    loan_id = request.GET.get('id', '').strip()

    try:
        loan = Loan.objects.select_related('place', 'customer').get(
            id=int(loan_id)
        )

    except (Loan.DoesNotExist, ValueError, TypeError):

        messages.error(request, 'Loan not found.')
        return redirect('admin:loan_reports')

    try:
        context = build_invoice_context(loan)

    except Exception:

        logger.exception(
            'payment_invoice failed for loan %s',
            loan_id
        )

        messages.error(
            request,
            'Unable to load the payment statement.'
        )

        return redirect('admin:loan_reports')

    return render(
        request,
        'adminpanel/payment_invoice.html',
        context
    )


# -------------------------------------------------------------
# PAYMENT HISTORY AJAX DATA
# GET /admin/payment_invoice_data/?id=LOAN_ID
# -------------------------------------------------------------

def payment_invoice_data(request):

    loan_id = request.GET.get('id', '').strip()

    try:
        loan = Loan.objects.get(id=int(loan_id))

        rows = build_invoice_payment_rows(loan)

        return JsonResponse({
            'success': True,
            'data': rows,
        })

    except (Loan.DoesNotExist, ValueError, TypeError):

        return JsonResponse({
            'success': False,
            'message': 'Loan not found.',
            'data': [],
        }, status=404)

    except Exception:

        logger.exception(
            'payment_invoice_data failed for loan %s',
            loan_id
        )

        return JsonResponse({
            'success': False,
            'message': 'Unable to load payment history.',
            'data': [],
        }, status=500)
