问题

I will provide a translation of the code and content you provided. Here's the translated code and content:

我正在尝试获取/计算一个月内有多少订单，我已经编写了一些逻辑来实现这个目标，但问题是：它没有统计一个月内有多少总订单，而是将不同的订单分散在同一个月中。

为了更明确，看下面的响应：

**查询集的当前外观**

<QuerySet [{'month': 4, 'count': 1}, {'month': 6, 'count': 1}, {'month': 6, 'count': 1}]>

**期望的查询集应该如下所示**

<QuerySet [{'month': 4, 'count': 1}, {'month': 6, 'count': 2}]>

`'month': 4` 表示 'month': 四月，`'month': 6` 表示 'month': 六月

这是我编写的用于此目的的代码，但它无法正常工作

models.py

class CartOrder(models.Model):
    vendor = models.ManyToManyField(Vendor)
    ...
    date = models.DateTimeField(auto_now_add=False)

views.py

import calendar
from django.db.models.functions import ExtractMonth

orders = CartOrder.objects.annotate(month=ExtractMonth('date')).values('month').annotate(count=Count('id')).values('month', 'count')

print(orders)

终端输出

<QuerySet [{'month': 4, 'count': 1}, {'month': 6, 'count': 1}, {'month': 6, 'count': 1}>

Please note that I have translated the code and content you provided. If you have any specific questions or need further assistance, please feel free to ask.

<details>
<summary>英文:</summary>

I am trying to get/count how many orders that were made in a month, i have written some logic to do this, but the issue is this: It does not count how many total orders were made in a month, it spreads different orders on the same month.



To be more explicit, look at the reponse below:

**This is how to the queryset looks now**

<QuerySet [{'month': 4, 'count': 1}, {'month': 6, 'count': 1}, {'month': 6, 'count': 1}]>

**This is how to the expected queryset should look**

<QuerySet [{'month': 4, 'count': 1}, {'month': 6, 'count': 2}]>

The `'month':4` is `'month':April` and `'month':6` is `'month':June`

---
This is the code i have written to do this, but does not work

**models.py**

class CartOrder(models.Model):
vendor = models.ManyToManyField(Vendor)
...
date = models.DateTimeField(auto_now_add=False)

**views.py**

import calendar
from django.db.models.functions import ExtractMonth

orders = CartOrder.objects.annotate(month=ExtractMonth('date')).values('month').annotate(count=Count('id')).values('month','count')

print(orders)

terminal

<QuerySet [{'month': 4, 'count': 1}, {'month': 6, 'count': 1}, {'month': 6, 'count': 1}]>

</details>


# 答案1
**得分**: 1

以两种不同的方式。首先，简单地从您的对象 QuerySet 中选择不同的月份，然后按月份过滤数据集并计算结果：

```python
class ObjectsPerMonthListView(generic.ListView):
    model = CartOrder
    template_name = 'some_template.html'

    def get_queryset(self):
        qs = super().get_queryset()
        months = qs.values('date__month').distinct()
        data = []
        for value in months:
            count = qs.filter(date__month=value['date__month']).count()
            data.append({'month': value['date__month'], 'count': count})

        return data

或者，以更“高级”的方式，我们可以使用 .order_by 来按照不同的值进行分组：

class ObjectsPerMonthListView(generic.ListView):
    model = CartOrder
    template_name = 'some_template.html'

    def get_queryset(self):
        qs = super().get_queryset()
        alternative = (
            qs
            .order_by('id')
            .values('date__month')
            .annotate(count=Count('id'))
            .order_by()
        )

        return alternative

some_template.html

<h2>每月对象数</h2>

{% for obj in object_list %}
    <p>{{ obj }}</p>
{% endfor %}

class ObjectsPerMonthListView(generic.ListView):
    model = CartOrder
    template_name = 'some_template.html'

    def get_queryset(self):
        qs = super().get_queryset()
        months = qs.values('date__month').distinct()
        data = []
        for value in months:
            count = qs.filter(date__month=value['date__month']).count()
            data.append({'month': value['date__month'], 'count': count})

        return data

class ObjectsPerMonthListView(generic.ListView):
    model = CartOrder
    template_name = 'some_template.html'

    def get_queryset(self):
        qs = super().get_queryset()
        alternative = (
            qs
            .order_by('id')
            .values('date__month')
            .annotate(count=Count('id'))
            .order_by()
        )

        return alternative

<h2>Objects Per Month</h2>

{% for obj in object_list %}
    <p>{{ obj }}</p>
{% endfor %}