Django:按日期分组，然后计算每个日期的金额总和

from django.db import models

class Transaction(models.Model):
    date = models.DateField()
    amount = models.DecimalField(max_digits=10, decimal_places=2)

from django.db.models import Sum
from django.shortcuts import render

def group_by_date(request):
    grouped_transactions = Transaction.objects.values('date').annotate(total_amount=Sum('amount'))
    return render(request, 'group_by_date.html', {'grouped_transactions': grouped_transactions})

<!-- group_by_date.html -->
{% for transaction in grouped_transactions %}
    <p>Date: {{ transaction.date }}</p>
    <p>Total Amount: {{ transaction.total_amount }}</p>
{% endfor %}