"""
Staff panel overdue loans: same rules as the admin Overdue page, limited to
the loans of the places assigned to the logged-in staff member.
"""
import logging

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
from controllers.Admin.AdminloanreportController import MONEY, _build_row, _int
from controllers.Admin.AdminoverdueController import (
    SORT_KEYS, _collect_rows, _overdue_numbers, overdue_xlsx,
)

from django.db.models import Sum, Value
from django.db.models.functions import Coalesce

logger = logging.getLogger(__name__)

VIEW_URL = 'staff:view_overdue_loan'


def _rows(request):
    return _collect_rows(request, base_qs=staff_loans(request), view_url_name=VIEW_URL)


def staff_overdue_loan_data(request):
    if request.headers.get('x-requested-with') != 'XMLHttpRequest':
        return JsonResponse({'status': 'error', 'message': 'Invalid request.'}, status=400)

    draw = _int(request.GET.get('draw'), 1)
    try:
        start = max(_int(request.GET.get('start'), 0), 0)
        length = _int(request.GET.get('length'), 10)
        rows, total = _rows(request)
        filtered = len(rows)

        order_col = _int(request.GET.get('order[0][column]'), -1)
        if order_col in SORT_KEYS:
            rows.sort(key=SORT_KEYS[order_col],
                      reverse=request.GET.get('order[0][dir]', 'asc') == 'desc')
        else:
            rows.sort(key=lambda r: r['overdue_days'], reverse=True)

        page = rows[start:] if length == -1 else rows[start:start + max(length, 1)]
        for i, row in enumerate(page, start=start + 1):
            row['DT_RowIndex'] = i
        return JsonResponse({'draw': draw, 'recordsTotal': total,
                             'recordsFiltered': filtered, 'data': page})
    except Exception:
        logger.exception('staff_overdue_loan_data failed')
        return JsonResponse({'draw': draw, 'recordsTotal': 0, 'recordsFiltered': 0,
                             'data': [], 'error': 'Could not load overdue loans.'}, status=500)


def staff_overdue_loan_export(request):
    """Excel of the staff member's overdue loans matching the filters."""
    rows, _ = _rows(request)
    return overdue_xlsx(request, rows)


def staff_view_overdue_loan(request):
    loan_id = request.GET.get('id', '').strip()
    if not loan_id.isdigit():
        return redirect('staff:overdue_loan')

    loan = staff_loans(
        request,
        Loan.objects.select_related('place', 'customer').annotate(
            paid=Coalesce(Sum('payments__amount'), Value(0), output_field=MONEY)),
    ).filter(pk=int(loan_id)).first()
    if loan is None:
        return redirect('staff:overdue_loan')

    today = timezone.localdate()
    summary = _build_row(loan, today, 'staff')
    overdue_dues, overdue_amount, overdue_days = _overdue_numbers(loan, summary, today)

    return render(request, 'staffpanel/view_overdue_loan.html', {
        'loan': loan,
        'summary': summary,
        'place_name': loan.place.name,
        'total_amount': float(loan.total_payable),
        'overdue_amount': float(overdue_amount),
        'overdue_dues': overdue_dues,
        'overdue_days': overdue_days,
    })
