组合两个可变滤波器Django

Question

在我的代码中有两个过滤器，学生过滤那个特定班级中的每个人，students_wr是另一个过滤器，它使我的表K8Recess安静下来，它记录了学校那天休息的所有学生。我想做的是把这些过滤器组合起来。

让全班休息一天的同学们看看。我该怎么做？这是我的密码

def K8_Recess_Report(request, classid):
    if request.method == "GET":
       date = datetime.date.today()
       class_name = TeacherClass.objects.get(id=classid)
       getstudents = Student.objects.filter(class_name=classid)
       students = getstudents.all().order_by('student_name')
       students_wr = K8Recess.objects.filter(created_at__date = date )
       my_class_id = request.session['my_class_id']
       context = ({'students': students, 'class_name': class_name, 'my_class_id': my_class_id, 'date': date,})
    return render(request, 'points/k8_recess_report.html', context)  

class K8Points(models.Model):
    date = models.DateField(default=datetime.date.today()) 
    class_name = models.ForeignKey(TeacherClass, on_delete = models.PROTECT, default = "",)
    student_name = models.ForeignKey(Student,on_delete = models.CASCADE, default ="" ,) 
    week_of = models.IntegerField(default=weeknumber)
    day = models.CharField(max_length= 10, default = dayofweek)
    TIME_FRAME_CHOICES = [
        (None, 'PLEASE SELECT TIME FRAME'),  # THIS IS OPTIONAL
        (1, '(1.) 8:45AM - 9:00AM'),
        (2, '(2.) 9:00AM - 9:30AM'),
        (3, '(3.) 9:30AM - 10:00AM'),
        (4, '(4.) REC. I 10:00AM -10:10AM'),
        (5, '(5.) 10:10AM-10:40AM'),
        (6, '(6.) 10:40AM-11:10AM'),
        (7, '(7.) 11:10AM-11:40AM'),
        (8, '(8.) LUNCH 11:40AM-12:00PM'),
        (9, '(9.) REC. II 12:00PM-12:20PM'),
        (10, '(10.) 12:20PM-12:50PM'),
        (11,'(11.) 12:50PM-1:20PM'),
        (12,'(12.) 1:20PM-1:50PM'),
        (13,'(13.) 1:50PM-2:20PM'),
        (14,'(14.) REC. III 2:20PM-2:30PM'),
    ]
    time_frame = models.PositiveSmallIntegerField(choices=TIME_FRAME_CHOICES,)
    behavior = models.IntegerField(default="", validators=[
            MaxValueValidator(5),
            MinValueValidator(1)
        ])
    academic = models.IntegerField(default="", validators=[
            MaxValueValidator(5),
            MinValueValidator(0)
        ] )

    created_at = models.DateTimeField(default=datetime.datetime.now())


    class Meta:
        verbose_name = "K8-Points"


    def __str__(self):
        return self.student_name  

class K8Recess(models.Model):
    student_ps = models.ForeignKey(Student,on_delete = models.CASCADE, default ="" ,) 
    created_at = models.DateTimeField(default=datetime.datetime.now())
    morning_recess = models.BooleanField(blank= True, null = True)
    lunch_recess = models.BooleanField(blank= True, null = True)
    afternoon_recess = models.BooleanField(blank= True, null = True)

​

​

Answer 1

你可以通过：

K8Recess.objects.filter(student_ps__class_name=classid, created_at__date=date)