我想知道在 ListView 中添加背景關系的每次培訓的受訓人數。
我已經搜索了如何參考 ListView 中的每個專案，以便對每個專案執行進一步的查詢。
如果有人知道更有效的方法，我將不勝感激
class TrainingsView(ListView):
model = NewHireTraining
template_name = 'nht/trainings.html'
context_object_name = 'trainings'
def get_context_data(self, **kwargs):
context = super().get_context_data(**kwargs)
context['headcount'] = Trainee.objects.filter(new_hire_training = self.SOMETHING).count()
return context
添加 NewHireTraining 和 Trainee 模型：
class NewHireTraining(models.Model):
location = models.ForeignKey(Location, on_delete=models.CASCADE)
program = models.ForeignKey(Program, on_delete=models.CASCADE)
project = models.ForeignKey(Project, on_delete=models.CASCADE)
trainer = models.ForeignKey(Trainer, on_delete=models.RESTRICT)
start_date = models.DateField()
nesting_date = models.DateField()
production_date = models.DateField()
def __str__(self):
return str(self.program) ' ' str(self.project) ' ' str(self.start_date)
class Trainee(models.Model):
first_name = models.CharField(max_length=55)
last_name = models.CharField(max_length=55)
employee_number = models.IntegerField()
hire_date = models.DateField()
is_term = models.BooleanField(default=False)
new_hire_training = models.ForeignKey(NewHireTraining, on_delete=models.CASCADE, default="")
def __str__(self):
return self.first_name ' ' self.last_name
uj5u.com熱心網友回復：
您可以使用Trainees的數量注釋查詢集：
from django.db.models import Count
class TrainingsView(ListView):
model = NewHireTraining
template_name = 'nht/trainings.html'
context_object_name = 'trainings'
queryset = NewHireTraining.objects.annotate(headcount=Count('trainee'))NewHireTraining從此查詢集產生的物件將有一個額外的屬性.headcount，其中包含相關Trainees的總數。
因此，在模板中，您可以使用以下方式呈現：
{% for training in trainings %}
{{ trailing }}: {{ trailing.headcount }}
{% endfor %}轉載請註明出處，本文鏈接：https://www.uj5u.com/net/342520.html
下一篇：將焦點設定到第一個串列視圖項