我正在嘗試顯示潛在客戶中每個類別的數量。但我無法展示它。感謝您的幫助。
我正在學習 django 和 python。嘗試了很多opiton,但失敗了。
下面是我的代碼。
模型:
class Leads(models.Model):
first_name = models.CharField(max_length=20)
last_name = models.CharField(max_length=20)
age = models.IntegerField(default=0)
orginasation = models.ForeignKey(UserProfile, on_delete=models.CASCADE)
agent = models.ForeignKey("Agent",null=True, blank= True ,on_delete=models.SET_NULL)
category = models.ForeignKey("Category", related_name="leads", on_delete= models.SET_NULL, null=True, blank=True)
def __str__(self):
return f"{self.first_name} {self.last_name}"
class Category(models.Model):
name = models.CharField(max_length=30,) # New, Contact, Converted, Unconverted
orginasation = models.ForeignKey(UserProfile, on_delete=models.CASCADE)
def __str__(self):
return self.name
看法:
class CategoryListView(LoginRequiredMixin, generic.ListView):
template_name = "leads/category_list.html"
context_object_name = "category_list"
def get_queryset(self, **kwargs):
user = self.request.user
#initial query set for entire organisation
if user.is_organisor:
queryset = models.Category.objects.filter(orginasation=user.userprofile)
else:
queryset = models.Category.objects.filter(orginasation=user.agent.orginasation)
# count = models.Leads.objects.filter(category = 3).count()
return queryset
模板
{% for category in category_list %}
<tr>
<td>{{category.name}}/td>
<td>{{category.count}}</td>
</tr>
{% endfor %}
uj5u.com熱心網友回復:
如果我理解您的問題,您應該嘗試在模板中更改{{category.count}}from {{ category.leads.all.count }}。
轉載請註明出處,本文鏈接:https://www.uj5u.com/houduan/416251.html
標籤:
下一篇:Django:頁面之一沒有打開
