"""
Saved row order for drag-and-drop tables (static/js/table_reorder.js).

  GET  table_order/?page=/admin/staff_list/   -> {"orders": {table_key: [row keys]}}
  POST table_order/  table_key=..., keys=[...] (JSON)   -> save
  POST table_order/  table_key=..., reset=1             -> back to the default order

Orders are stored per logged-in admin / staff member, so they stay the same
after logging out and in again, on any device.
"""
import json

from django.http import JsonResponse

from NexusApp.models import TableRowOrder

MAX_KEYS = 5000


def _owner(request):
    staff = getattr(request, 'staff', None)
    if request.path.startswith('/staff/') and staff is not None:
        return 'staff', staff.pk
    user = getattr(request, 'user', None)
    if request.path.startswith('/admin/') and getattr(user, 'pk', None):
        return 'admin', user.pk
    return None, None


def table_order(request):
    owner_type, owner_id = _owner(request)
    if owner_type is None:
        return JsonResponse({'status': 'error', 'message': 'Login required.'}, status=401)
    mine = TableRowOrder.objects.filter(owner_type=owner_type, owner_id=owner_id)

    if request.method == 'GET':
        page = request.GET.get('page', '')[:200]
        rows = mine.filter(table_key__startswith=page + '#') if page else mine.none()
        return JsonResponse({'orders': {r.table_key: r.keys for r in rows}})

    if request.method != 'POST':
        return JsonResponse({'status': 'error', 'message': 'Invalid method.'}, status=405)

    table_key = request.POST.get('table_key', '').strip()[:255]
    if not table_key or '#' not in table_key:
        return JsonResponse({'status': 'error', 'message': 'Table is missing.'}, status=400)

    if request.POST.get('reset'):
        mine.filter(table_key=table_key).delete()
        return JsonResponse({'status': 'success'})

    try:
        keys = json.loads(request.POST.get('keys', '[]'))
    except ValueError:
        return JsonResponse({'status': 'error', 'message': 'Invalid order.'}, status=400)
    if not isinstance(keys, list):
        return JsonResponse({'status': 'error', 'message': 'Invalid order.'}, status=400)
    keys = [str(k)[:100] for k in keys][:MAX_KEYS]

    TableRowOrder.objects.update_or_create(
        owner_type=owner_type, owner_id=owner_id, table_key=table_key,
        defaults={'keys': keys})
    return JsonResponse({'status': 'success'})
