Django管理界面显示相关字段的计数

huangapple
go评论105阅读模式
英文:

Django Admin display Count of related field

问题

I am building a Django project for a workshop (car/motorcycle).

Have a customer class in models and a service class. In the admin I want to display the number of services per customer, I am taught to use the get_queryset and define a variable for that count, but it doesn't want to work, probably it's like a really easy fix but I can't get my head around it! Hope someone here knows, thanks a lot! Django管理界面显示相关字段的计数

MODELS.PY

  1. from django.db import models
  3. # Create your models here.
  4. class Fordonsregister(models.Model):
  5.     regnr = models.CharField(max_length=6, primary_key=True, null=False, blank=False)
  6.     namn = models.CharField(max_length=255, null=True, blank=True)
  7.     tel = models.CharField(max_length=255, default='070-000 00 00', null=True, blank=True)
  8.     email = models.EmailField(null=True, blank=True)
  9.     kund_sedan = models.DateTimeField(auto_now=True)
  10.     kund_points = models.IntegerField(default=0)
  12.     def __str__(self):
  13.         return self.regnr
  15.     class Meta:
  16.         ordering = ['regnr']
  18. class ServiceTypes(models.Model):
  19.     typ = models.CharField(max_length=255, primary_key=True, blank=False)
  20.     pris = models.DecimalField(decimal_places=2, max_digits=6, null=False, blank=False)
  21.     beskrivning = models.CharField(max_length=255, null=True, blank=True)
  23.     def __str__(self):
  24.         return self.typ
  26.     class Meta:
  27.         ordering = ['typ']
  30. class FordonsService(models.Model):
  31.     regnr = models.ForeignKey(Fordonsregister, on_delete=models.CASCADE)
  32.     typ = models.ForeignKey(ServiceTypes, on_delete=models.CASCADE)
  33.     service_datum = models.DateTimeField()
  34.     bokat_datum = models.DateTimeField(auto_now=True)
  35.     kommentar = models.CharField(max_length=1000)
  37.     class Meta:
  38.         ordering = ['-service_datum']

ADMIN.PY

  1. from django.contrib import admin
  2. from django.db.models import Count
  3. from django.http import HttpRequest
  4. from .models import Fordonsregister, ServiceTypes, FordonsService
  6. # Register your models here.
  7. @admin.register(Fordonsregister)
  8. class FordonsregisterAdmin(admin.ModelAdmin):
  9.     list_display = ['regnr', 'namn', 'tel', 'email', 'post_count']
  10.     search_fields = ['regnr__istartswith']
  11.     # list_select_related = ['fordonsservice']
  13.     def post_count(self, obj):
  14.         return obj.post_count
  16.     def get_queryset(self, request):
  17.         queryset = super().get_queryset(request)
  18.         queryset = queryset.annotate(post_count=Count("fordonsservice"))
  19.         return queryset
  22. @admin.register(FordonsService)
  23. class FordonsServiceAdmin(admin.ModelAdmin):
  24.     list_display = ['regnr', 'typ', 'service_datum', 'bokat_datum']
  27. @admin.register(ServiceTypes)
  28. class ServiceTypesAdmin(admin.ModelAdmin):
  29.     list_display = ['typ', 'pris']

The error thrown is:

FieldError at /admin/main/fordonsregister/
Cannot resolve keyword 'service_datum' into field. Choices are: email, fordonsservice, kund_points, kund_sedan, namn, regnr, standardoffert, tel

I am quite good with Python but mainly data analysis, quite new to Django Django管理界面显示相关字段的计数

英文:

I am building a Django project for a workshop (car/motorcycle).

Have a customer class in models and a service class. In the admin I want to display the number of services per customer, I am taught to use the get_queryset and define a variable for that count, but it doesn't want to work, probably its like a really easy fix but I can't get my head around it! Hope someone here knows, thanks a lot! Django管理界面显示相关字段的计数

MODELS.PY

  1. from django.db import models
  3. # Create your models here.
  4. class Fordonsregister(models.Model):
  5.     regnr = models.CharField(max_length=6, primary_key=True, null=False, blank=False)
  6.     namn = models.CharField(max_length=255, null=True, blank=True)
  7.     tel = models.CharField(max_length=255, default='070-000 00 00', null=True, blank=True)
  8.     email = models.EmailField(null=True, blank=True)
  9.     kund_sedan = models.DateTimeField(auto_now=True)
  10.     kund_points = models.IntegerField(default=0)
  12.     def __str__(self) -> str:
  13.         return self.regnr
  15.     class Meta:
  16.         ordering = ['regnr']
  18. class ServiceTypes(models.Model):
  19.     typ = models.CharField(max_length=255, primary_key=True, blank=False)
  20.     pris = models.DecimalField(decimal_places=2, max_digits=6, null=False, blank=False)
  21.     beskrivning = models.CharField(max_length=255, null=True, blank=True)
  23.     def __str__(self) -> str:
  24.         return self.typ
  26.     class Meta:
  27.         ordering = ['typ']
  30. class FordonsService(models.Model):
  31.     regnr = models.ForeignKey(Fordonsregister, on_delete=models.CASCADE)
  32.     typ = models.ForeignKey(ServiceTypes, on_delete=models.CASCADE)
  33.     service_datum = models.DateTimeField()
  34.     bokat_datum = models.DateTimeField(auto_now=True)
  35.     kommentar = models.CharField(max_length=1000)
  37.     class Meta:
  38.         ordering = ['-service_datum']

ADMIN.PY

  1. from django.contrib import admin
  2. from django.db.models import Count
  3. from django.http import HttpRequest
  4. from .models import Fordonsregister, ServiceTypes, FordonsService
  6. # Register your models here.
  7. @admin.register(Fordonsregister)
  8. class FordonsregisterAdmin(admin.ModelAdmin):
  9.     list_display = ['regnr', 'namn', 'tel', 'email', 'post_count']
  10.     search_fields = ['regnr__istartswith']
  11.     # list_select_related = ['fordonsservice']
  13.     def post_count(self, obj):
  14.         return obj.post_count
  16.     def get_queryset(self, request):
  17.         queryset = super().get_queryset(request)
  18.         queryset = queryset.annotate(post_count=Count("regnr"))
  19.         return queryset
  22. @admin.register(FordonsService)
  23. class FordonsServiceAdmin(admin.ModelAdmin):
  24.     list_display = ['regnr', 'typ', 'service_datum', 'bokat_datum']
  27. @admin.register(ServiceTypes)
  28. class ServiceTypesAdmin(admin.ModelAdmin):
  29.     list_display = ['typ', 'pris']

The error thrown is:

FieldError at /admin/main/fordonsregister/
Cannot resolve keyword 'service_datum' into field. Choices are: email, fordonsservice, kund_points, kund_sedan, namn, regnr, standardoffert, tel

I am quite good with Python but mainly data analysis, quite new to Django Django管理界面显示相关字段的计数

答案1

得分: 1

我弄清楚了，我需要在表格和两个下划线前缀列名...

因此，在下面的脚本中:

Count("service_datum")
变成:
Count("fordonsservice__service_datum")

  1. @admin.register(Fordonsregister)
  2. class FordonsregisterAdmin(admin.ModelAdmin):
  3.     list_display = ['regnr', 'namn', 'tel', 'email', 'post_count']
  4.     search_fields = ['regnr__istartswith']
  5.     # list_select_related = ['fordonsservice']
  7.     def post_count(self, fordonregister):
  8.         return fordonregister.post_count
  10.     def get_queryset(self, request):
  11.         queryset = super().get_queryset(request)
  12.         queryset = queryset.annotate(post_count=Count("fordonsservice__service_datum"))
  13.         return queryset
英文:

Ok I figured it out, I needed to prefix the column with the table and two underscores...

So in the script below:

Count("service_datum")
becomes:
Count("fordonsservice__service_datum")

  1. @admin.register(Fordonsregister)
  2. class FordonsregisterAdmin(admin.ModelAdmin):
  3.     list_display = ['regnr', 'namn', 'tel', 'email', 'post_count']
  4.     search_fields = ['regnr__istartswith']
  5.     # list_select_related = ['fordonsservice']
  7.     def post_count(self, fordonregister):
  8.         return fordonregister.post_count
  10.     def get_queryset(self, request):
  11.         queryset = super().get_queryset(request)
  12.         queryset = queryset.annotate(post_count=Count("fordonsservice__service_datum"))
  13.         return queryset ```
  15. </details>

huangapple
  • 本文由 发表于 2023年2月27日 02:03:35
  • 转载请务必保留本文链接：https://go.coder-hub.com/75574008.html
  • django
  • django-admin
  • django-queryset
  • python
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定