Django项目中劳工岗位申请的审批状态应添加到哪个模型中?
Django多对多关系新增审批状态的模型设计方案
设计思路
- 你当前使用的是Django默认的多对多中间关联表,仅支持存储两个关联模型的主键ID,无法存储审批状态这类额外业务字段,因此需要自定义多对多中间模型来承载申请相关的扩展属性。
调整后的完整模型代码
from django.db import models from django.contrib.auth.models import User from django.urls import reverse # Create your models here. class UserModel(models.Model): user = models.OneToOneField(User,related_name = 'user_profile',on_delete=models.CASCADE) CATEGORY_CHOICES = (('Labour','Labour'),('Owner','Owner')) category = models.CharField(max_length=100,choices=CATEGORY_CHOICES,default='NA') is_Labour = models.BooleanField(default=False) is_Owner = models.BooleanField(default=False) def __str__(self): return self.user.username def get_absolute_url(self): return reverse("basic_app:landing") class JobModel(models.Model): user = models.ForeignKey(UserModel,related_name='assigned_job',null=True,on_delete=models.CASCADE) title = models.CharField(max_length=255,null=True) description = models.CharField(max_length=500,null=True) def __str__(self): return self.title def get_absolute_url(self): return reverse("basic_app:landing") # 新增自定义多对多中间模型,存储岗位申请信息 class JobApplication(models.Model): STATUS_CHOICES = ( ('pending', '待审核'), ('accepted', '已通过'), ('rejected', '已拒绝'), ) job = models.ForeignKey(JobModel, on_delete=models.CASCADE, related_name='applications') labour = models.ForeignKey('LabourModel', on_delete=models.CASCADE, related_name='job_applications') status = models.CharField(max_length=20, choices=STATUS_CHOICES, default='pending') apply_time = models.DateTimeField(auto_now_add=True) operate_time = models.DateTimeField(auto_now=True) def __str__(self): return f"{self.labour.user.user.username} 申请 {self.job.title} - {self.get_status_display()}" class LabourModel(models.Model): user = models.OneToOneField(UserModel,related_name = 'assigned_labour',null=True,on_delete=models.CASCADE) registered = models.BooleanField(default=False) # 多对多关联指定自定义中间表 jobs = models.ManyToManyField(JobModel, through=JobApplication, related_name = 'labours') def __str__(self): return self.user.user.username def get_absolute_url(self): return reverse("basic_app:landing")
常见操作示例
- 劳工申请岗位:
# 假设已获取当前劳工实例labour,目标岗位实例job JobApplication.objects.create(labour=labour, job=job)
- 岗位发布者审批申请:
# 假设已获取对应申请实例application,操作改为通过/拒绝 application.status = 'accepted' # 或'rejected' application.save()
- 劳工查询自己所有申请的状态:
# 假设已获取当前劳工实例labour applications = labour.job_applications.all() for app in applications: print(app.job.title, app.get_status_display(), app.apply_time)
- 岗位发布者查询某岗位的所有申请:
# 假设已获取岗位实例job job_applications = job.applications.all() for app in job_applications: print(app.labour.user.user.username, app.get_status_display())
内容的提问来源于stack exchange,提问作者Maitri Vora
相关产品推荐
相关产品推荐

