在Django中计算订单总价时出现“Cannot resolve keyword”错误如何解决？

我正在开发一个仅允许登录用户下单的电商网站，结算时想获取所有未支付、未配送订单的总价（即order_price_total），但出现如下错误：

Cannot resolve keyword 'order_price_total' into field. Choices are: delivered, id, order_date, paid, product, product_id, quantity, ready_for_delivery, shipped, user, user_id

代码片段 #

模型定义 #

class Product(models.Model):
    supplier = models.ForeignKey(Shop, on_delete=models.CASCADE)
    product_name = models.CharField(max_length=100, null=True, blank=True)
    brand_name = models.CharField(max_length=100, null=True, blank=True)
    image = models.FileField(upload_to='meadia/product-image', null=True)
    key_features = models.TextField(max_length=1000, null=True, blank=True)
    specifications = models.TextField(max_length=1000, null=True, blank=True)
    description = models.TextField(max_length=1000, null=True, blank=True)
    creation_date = models.DateTimeField(auto_now_add=True)
    
    def __str__(self):
        return self.product_name


class Order(models.Model):
    user = models.ForeignKey(CustomUser, on_delete=models.DO_NOTHING)
    product = models.ForeignKey(Product, on_delete=models.DO_NOTHING)
    quantity = models.IntegerField(default=1, null=True, blank=True)
    order_date = models.DateTimeField(auto_now_add=True)
    
    paid = models.BooleanField(default=False)
    shipped = models.BooleanField(default=False)
    ready_for_delivery = models.BooleanField(default=False)
    delivered = models.BooleanField(default=False)

    def order_price_total(self):
        if self.paid == False:
            total_price = self.product.current_price * self.quantity
        return (total_price)
        
    def __str__(self):
        return self.product.product_name

视图代码 #

@login_required(login_url='login')
def orders(request):
    order = Order.objects.filter(user=request.user)
    total_amount = Order.objects.filter(user=request.user, paid=False, delivered=False).aggregate(TOTAL = Sum('order_price_total'))['TOTAL'] or 0

    context={
            'order':order,
            'total_amount':total_amount,
        }
    return render(request, 'mainapp/cart.html', context)

问题原因 #

order_price_total是Order模型定义的实例方法，并非数据库中实际存在的字段。Django的ORM聚合操作（如Sum）只能作用于数据库字段，无法直接调用模型方法进行计算，因此会报错无法解析该关键字。

解决方法 #

方法一：Python层面计算总价 #

先筛选符合条件的订单，再逐个调用方法累加总价：

@login_required(login_url='login')
def orders(request):
    orders = Order.objects.filter(user=request.user)
    # 筛选未支付、未配送的订单
    target_orders = Order.objects.filter(user=request.user, paid=False, delivered=False)
    total_amount = sum(order.order_price_total() for order in target_orders) or 0

    context={
        'orders': orders,
        'total_amount': total_amount,
    }
    return render(request, 'mainapp/cart.html', context)

注意：此方法会将订单数据全部加载到内存中计算，适合订单量较小的场景。

方法二：ORM数据库表达式计算（推荐） #

直接通过数据库字段运算计算总价，性能更优：

from django.db.models import F, Sum

@login_required(login_url='login')
def orders(request):
    orders = Order.objects.filter(user=request.user)
    total_amount = Order.objects.filter(user=request.user, paid=False, delivered=False).aggregate(
        TOTAL=Sum(F('product__current_price') * F('quantity'))
    )['TOTAL'] or 0

    context={
        'orders': orders,
        'total_amount': total_amount,
    }
    return render(request, 'mainapp/cart.html', context)

使用F()表达式直接引用数据库字段，通过外键关联Product的current_price字段，整个计算在数据库中完成，避免内存开销。

额外优化：修复模型方法的潜在问题 #

原order_price_total方法在paid=True时会因total_price未定义报错，建议修改为：

def order_price_total(self):
    if not self.paid:
        return self.product.current_price * self.quantity
    return 0

内容的提问来源于stack exchange，提问作者alphies pro