我希望扩展用户（供应商）只能在仪表板上看到其产品、订单和客户

Question

我一直在尝试过滤一些数据，以便从父模型中获得一定的结果，并显示在仪表板上，但没有任何结果。我得到一个错误显示

Cannot query "the distributors name": Must be "User" instance.

仪表板视图

def dashboard(request):
    orders = Order.objects.filter(Distributor__user=request.user.Distributor)
    customers = Customer.objects.all()

    total_customers = customers.count()

    total_orders = orders.count()
    Completed = orders.filter(status='Completed').count()
    OnShipping = orders.filter(status='OnShipping').count()

    context = {'orders': orders, 'customers': customers, 'total_customers': total_customers,
               'total_orders': total_orders, 'Completed': Completed,
               'OnShipping': OnShipping}

    return render(request, 'dashboard.html', context)

分销商的用户模型

class User(AbstractUser):
    is_distributor = models.BooleanField(default=False)
    is_customer = models.BooleanField(default=False)


class Distributor(models.Model):
    user = models.OneToOneField(User, on_delete=models.CASCADE, related_name='Distributor', primary_key=True)
    name = models.CharField(max_length=200, null=True)
    first_name = models.CharField(blank=True, max_length=150)
    last_name = models.CharField(blank=True, max_length=150)
    phone = PhoneNumberField(max_length=200, null=True)
    email = models.CharField(max_length=200, null=True)
    Tax_compliance_certificate = models.FileField(upload_to='distaxcerts/', null=False, blank=False)
    profile_pic = models.ImageField(upload_to='profile/', default="profile1.png", null=True, blank=True)
    date_created = models.DateTimeField(auto_now_add=True, null=True)
    till_no = models.CharField(max_length=20, null=True, blank=True)

    def __str__(self):
        return self.user.username

    def user_name(self):
        return self.user.first_name + ' ' + self.user.last_name + ' [' + self.user.username + '] '

    def image_tag(self):
        return mark_safe('<img src="{}" height="50"/>'.format(self.profile_pic.url))

    image_tag.short_description = 'Image'

产品型号

class Product(models.Model):
    delivery = (
        ('Daily', 'Daily'),
        ('Bi-Weekly', 'Bi-Weekly'),
        ('Weekly', 'Weekly'),
        ('Monthly', 'Monthly'),
        ('Quarterly', 'Quarterly'),
        ('Semi-Annually', 'Semi-Annually'),
        ('Annually', 'Annually'),
        ('Custom', 'Custom'),
    )
    VARIANTS = (
        ('None', 'None'),
        ('Weight', 'Weight'),
        ('Size', 'Size'),
        ('Color', 'Color'),
        ('Size-Color', 'Size-Color'),

    )
    category = models.ForeignKey(Category, on_delete=models.CASCADE)  # many to one relation with Category
    title = models.CharField(max_length=150)
    keywords = models.CharField(max_length=255)
    promote = models.BooleanField(default=False)
    description = models.TextField(max_length=255)
    image = models.ImageField(upload_to='images/', null=False)
    price = models.DecimalField(max_digits=12, decimal_places=2, default=0)
    minamount = models.IntegerField(default=3)
    amount = models.IntegerField(default=0)
    delivery = models.CharField(max_length=200, null=True, choices=delivery)
    detail = RichTextUploadingField()
    variant = models.CharField(max_length=10, choices=VARIANTS, default='None')

    slug = models.SlugField(null=False, unique=True)
    create_at = models.DateTimeField(auto_now_add=True)
    update_at = models.DateTimeField(auto_now=True)

    def __str__(self):
        return self.title

    # method to create a fake table field in read only mode
    def image_tag(self):
        if self.image.url is not None:
            return mark_safe('<img src="{}" height="50"/>'.format(self.image.url))
        else:
            return ""

    def get_absolute_url(self):
        return reverse('category_detail', kwargs={'slug': self.slug})

    def averagereview(self):
        reviews = Comment.objects.filter(product=self, status='True').aggregate(avarage=Avg('rate'))
        avg = 0
        if reviews["average"] is not None:
            avg = float(reviews["average"])
        return avg

    def countreview(self):
        reviews = Comment.objects.filter(product=self, status='True').aggregate(count=Count('id'))
        cnt = 0
        if reviews["count"] is not None:
            cnt = int(reviews["count"])
        return cnt

订单模式

class Order(models.Model):
    STATUS = (
        ('New', 'New'),
        ('Accepted', 'Accepted'),
        ('Preparing', 'Preparing'),
        ('OnShipping', 'OnShipping'),
        ('Completed', 'Completed'),
        ('Canceled', 'Canceled'),
    )
    Distributor = models.OneToOneField(settings.AUTH_USER_MODEL, on_delete=models.CASCADE,
                                       null=True)
    Customer = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE,
                                 null=True, related_name='customer_client')
    code = models.CharField(max_length=5, editable=False)
    first_name = models.CharField(max_length=10)
    last_name = models.CharField(max_length=10)
    phone = models.CharField(blank=True, max_length=20)
    address = models.CharField(blank=True, max_length=150)
    city = models.CharField(blank=True, max_length=20)
    country = models.CharField(blank=True, max_length=20)
    total = models.FloatField()
    status = models.CharField(max_length=10, choices=STATUS, default='New')
    ip = models.CharField(blank=True, max_length=20)
    adminnote = models.CharField(blank=True, max_length=100)
    create_at = models.DateTimeField(auto_now_add=True)
    update_at = models.DateTimeField(auto_now=True)

    def __str__(self):
        return self.code

Answer 1

我认为您对Django中的外键引用有点误解。
当你这样做的时候：

class Order(models.Model):
    distributor = models.OneToOneField(settings.AUTH_USER_MODEL, 
        on_delete=models.CASCADE, null=True) 

distributor是一个用户实例，因此您应该执行以下操作：

order = Order.objects.filter(distributor=request.user)