
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
from NexusApp.utils.staff_scope import staff_loans

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 = staff_loans(request, Loan.objects.select_related('place', 'customer')).get(
            id=int(loan_id)
        )

    except (Loan.DoesNotExist, ValueError, TypeError):

        messages.error(request, 'Loan not found.')
        return redirect('staff:loan_registers')

    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('staff:loan_registers')

    return render(
        request,
        'staffpanel/payment_invoice.html',
        context
    )


# -------------------------------------------------------------
# PAYMENT HISTORY AJAX DATA
# GET /admin/payment_invoice_data/?id=LOAN_ID
# -------------------------------------------------------------

def staff_payment_invoice_data(request):

    loan_id = request.GET.get('id', '').strip()

    try:
        loan = staff_loans(request).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)
