import calendar
import logging
from datetime import date, datetime, timedelta

from django.http import JsonResponse
from django.utils import timezone

from NexusApp.models import Staff, StaffCheckIn
from NexusApp.models.attendance_model import AttendanceMaster
from NexusApp.utils.excel import date_range, range_label, xlsx_response

logger = logging.getLogger(__name__)

WEEKDAYS = ['Monday', 'Tuesday', 'Wednesday', 'Thursday',
            'Friday', 'Saturday', 'Sunday']


def _parse_date(value, default):
    try:
        return datetime.strptime((value or '').strip(), '%Y-%m-%d').date()
    except ValueError:
        return default


def _working_days():
    """Working weekday names from the active Attendance Master (Mon-Sat if none)."""
    master = AttendanceMaster.objects.filter(is_active=True).first()
    if master and master.working_days:
        return set(master.working_days)
    return set(WEEKDAYS[:6])


def _is_working_day(day, working_days):
    return WEEKDAYS[day.weekday()] in working_days


def _active_staff():
    return Staff.objects.filter(status__iexact='Active').order_by('name')


def _fmt_time(dt):
    return timezone.localtime(dt).strftime('%I:%M %p') if dt else '-'


def _fmt_date(d):
    return d.strftime('%d %b %Y')


def _map_url(lat, lng):
    return f'https://www.google.com/maps?q={lat},{lng}' if lat is not None and lng is not None else ''


def checkin_locations(c):
    """Location fields shared by the admin and staff attendance tables."""
    return {
        'check_in_map': _map_url(c.check_in_latitude, c.check_in_longitude),
        'check_in_accuracy': c.check_in_accuracy,
        'check_in_location_note': c.check_in_location_note or '',
        'check_out_map': _map_url(c.check_out_latitude, c.check_out_longitude),
        'check_out_accuracy': c.check_out_accuracy,
        'check_out_location_note': c.check_out_location_note or '',
    }


def _checkin_row(c):
    late = c.status == 'late'
    return {
        'staff_name': c.staff.name,
        'employee_id': c.staff.employee_id,
        'date': c.check_in_date.isoformat(),
        'date_label': _fmt_date(c.check_in_date),
        'check_in': _fmt_time(c.check_in_time),
        'check_out': _fmt_time(c.check_out_time),
        'working_hours': c.working_hours_label if c.check_out_time else
                         ('Not checked out' if c.check_in_date < timezone.localdate() else 'Working'),
        'status': 'Late' if late else 'Present',
        'late_minutes': c.late_minutes if late else 0,
        'late_reason': (c.late_reason or '') if late else '',
        **checkin_locations(c),
    }


def _absent_row(staff, day):
    return {
        'staff_name': staff.name,
        'employee_id': staff.employee_id,
        'date': day.isoformat(),
        'date_label': _fmt_date(day),
        'check_in': '-',
        'check_out': '-',
        'working_hours': '-',
        'status': 'Absent',
        'late_minutes': 0,
        'late_reason': '',
    }


def admin_attendance_summary(request):
    """Cards at the top of the page - always for TODAY."""
    today = timezone.localdate()
    staff_qs = _active_staff()
    total = staff_qs.count()

    checkins = StaffCheckIn.objects.filter(
        check_in_date=today, staff__in=staff_qs
    )
    present = checkins.count()
    late = checkins.filter(status='late').count()
    absent = (
        max(total - present, 0)
        if _is_working_day(today, _working_days()) else 0
    )
    return {'total_staff': total, 'present': present,
            'absent': absent, 'late': late}


def _attendance_rows(request):
    """
    GET ?period=daily|monthly|range|all &date=YYYY-MM-DD &from_date= &to_date=
        &status=Present|Late|Absent &search=<staff name / employee id>
    Present = checked in on time, Late = checked in late,
    Absent = no check-in on a working day.
    A From / To date always wins over the period (it switches to 'range').
    Returns (rows, start, end).
    """
    today = timezone.localdate()
    period = request.GET.get('period', 'daily')
    if period not in ('daily', 'monthly', 'range', 'all'):
        period = 'daily'
    selected = _parse_date(request.GET.get('date'), today)
    status_filter = request.GET.get('status', '').strip()
    search = request.GET.get('search', '').strip().lower()
    range_from, range_to = date_range(request)
    if range_from or range_to:
        period = 'range'

    staff_list = list(_active_staff())
    checkins = StaffCheckIn.objects.select_related('staff')

    if period == 'daily':
        start = end = selected
    elif period == 'monthly':
        start = selected.replace(day=1)
        end = selected.replace(
            day=calendar.monthrange(selected.year, selected.month)[1])
    elif period == 'range':
        # empty From = same day as To, empty To = today; nothing picked = today
        end = range_to or max(range_from or today, today)
        start = range_from or end
        if start > end:
            start, end = end, start
    else:
        start = end = None

    if start:
        checkins = checkins.filter(check_in_date__range=(start, end))
    rows = [_checkin_row(c) for c in checkins]

    # ---- add Absent rows (working days only, never future days) ----------
    if start:
        working_days = _working_days()
        done = {(c.staff_id, c.check_in_date) for c in checkins}
        last_day = min(end, today)
        day = start
        while day <= last_day:
            if _is_working_day(day, working_days):
                for s in staff_list:
                    if s.joining_date and day < s.joining_date:
                        continue
                    if (s.id, day) not in done:
                        rows.append(_absent_row(s, day))
            day += timedelta(days=1)

    if status_filter:
        rows = [r for r in rows if r['status'] == status_filter]
    if search:
        rows = [r for r in rows
                if search in (r['staff_name'] or '').lower()
                or search in (r['employee_id'] or '').lower()]

    rows.sort(key=lambda r: (r['date'], r['staff_name']), reverse=True)
    return rows, start, end


def admin_attendance_data(request):
    rows, _, _ = _attendance_rows(request)
    return JsonResponse({
        'data': rows,
        'summary': admin_attendance_summary(request),
    })


def admin_attendance_export(request):
    """Excel of the attendance rows matching the current filters."""
    rows, start, end = _attendance_rows(request)
    body = [[
        i, r['staff_name'], r['employee_id'], r['date_label'], r['check_in'], r['check_out'],
        r['working_hours'], r['status'], r['late_minutes'] or '', r['late_reason'],
        r.get('check_in_map', ''), r.get('check_out_map', ''),
    ] for i, r in enumerate(rows, start=1)]
    return xlsx_response(
        'staff_attendance', 'Staff Attendance',
        ['S.No', 'Staff Name', 'Employee ID', 'Date', 'Check In', 'Check Out', 'Working Hours',
         'Status', 'Late Minutes', 'Late Reason', 'Check In Location', 'Check Out Location'],
        body, subtitle=range_label(start, end) if start else 'All records')
