from .constants import ASSIGNMENT_ACTIVE
from .models import ClubStaffAssignment, StaffCapabilityEvent, StaffMember, TeamTrainingStaffSnapshot


def get_club_staff(*, club_id):
    return ClubStaffAssignment.objects.filter(club_id=club_id, status=ASSIGNMENT_ACTIVE).select_related(
        "staff_member", "staff_member__capability"
    ).order_by("role")


def get_staff_history(*, staff_member_id):
    return StaffCapabilityEvent.objects.filter(staff_member_id=staff_member_id).order_by("revision")


def get_training_staff_snapshot(*, session_id):
    return TeamTrainingStaffSnapshot.objects.filter(session_id=session_id).first()