views.py 文件源码

def get(self, request):
        tasks = Task.objects.all().values("slug", "id")
        grades = []
        usernames = get_user_model().objects.all().values_list(
            'username', flat=True)

        for username in usernames:
            user_grades = {'username': username}
            task_submissions = TaskSubmission.objects \
                .filter(user__username=username).values('task_id') \
                .annotate(grade=Max('grade'))

            for grade in task_submissions:
                user_grades[grade['task_id']] = grade['grade']
            grades.append(user_grades)

        context = {
            'grades': grades,
            'tasks': tasks
        }
        return render(request, self.template_name, context, status=200)