如何在Django中使用两个模型管理已批准的待处理字段

Question

我有一个名为Authorized的Django模型，它具有sales_itemforeignKey如果销售人员在数据库中添加新的销售，授权人员如何通过在销售对象上添加一些评论来批准或拒绝销售？我无法理解在哪里可以添加approved or decline属性

型号.py

class Authorize(models.Model):
managers = models.ForeignKey(User, on_delete=models.CASCADE, null=True)
sales_item = models.ForeignKey(Sale, on_delete=models.CASCADE, null=True, blank=True)
comments = models.TextField(max_length=1000, blank=True)
created_at = models.DateTimeField(auto_now_add=True)
status = models.BooleanField(default=True)

class Sale(models.Model):
saler = models.ForeignKey(User, on_delete=models.CASCADE, null=True, blank=True)
customers = models.ForeignKey(Customer, on_delete=models.CASCADE, null=True, blank=True)
products = models.ManyToManyField(Product)
content = models.TextField(blank=True)
created_on = models.DateTimeField(auto_now_add=True)
status = models.BooleanField(default=True)

Answer 1

用Authorize表创建一对一关系的Sale表。

class Authorize(models.Model):
managers = models.ForeignKey(User, on_delete=models.CASCADE, null=True)
sales_item = models.ForeignKey(Sale, on_delete=models.CASCADE, null=True, blank=True)
comments = models.TextField(max_length=1000, blank=True)
created_at = models.DateTimeField(auto_now_add=True)
status = models.BooleanField(default=True)
sale = models.OneToOneField(
Sale,
primary_key=True,
db_column="id",
parent_link=True,
on_delete=models.CASCADE
)

每个表中都有状态字段。使用"授权"表中的状态来存储状态和注释以供审批。