擅长:python、mysql、java
<p>我相信您只需要另一个注释来计算该房间的预订数量。您可以使用反向外键路径/相关名称,在本例中,我认为它是<code>roomtype_set</code></p>
<pre><code>roomsByDate = RoomType.objects.annotate(
modulo=numAdult % F('room_capacity')
).filter(
q_city, q_room_capacity1, modulo=0
).annotate(
times_booked=Count("roomtype_set__id", filter=Q(booked_from__in=day), distinct=True)
).exclude(
number_of_rooms__lte=F('times_booked')
)
</code></pre>