擅长:python、mysql、java
<p>使用<code>RefundHistory</code>的单个查询可以获得每个会员每次付款的退款历史记录:</p>
<pre><code>payments = []
for m in staff.members.all():
payments.extend(m.PaymentHistory.filter(division="Membership").values_list('pk', flat=True))
wanted_refund = RefundHistory.objects.filter(payment__pk__in=payments, refund_date__range=[this_month_start, date])
context = {'wanted_refund' : wanted_refund,}
return render(request, 'refund.html', context)
</code></pre>