如何使用.filter()/。get()来查看值是否在外部模型中以在Django中进行验证?

我从模型(EmployeeWorkAreaLog)中创建了一个表格,用户可以在其中输入员工编号,然后按Enter / Leave,它会在数据库中搜索一个单独的模型(推销员)以确保此人是有效的员工,如果不是这样,则会从html一侧弹出一条消息,指出该消息无效。

现在,我正在尝试添加另一个约束,例如,如果员工不在“ WF”团队中,那么它也会给出错误,并说要联系经理。我尝试从表单中执行此操作,但始终出现此错误:

int() argument must be a string,a bytes-like object or a number,not 'Salesman'

根据追溯,它来自if Salesman.objects.get(id=employee_number).count():

为什么会发生此错误?有没有更有效/更好的方法来检查员工团队?

models.py

class EmployeeWorkAreaLog(TimeStampedmodel,SoftDeleteModel,models.Model):
    employee_number = models.ForeignKey(Salesman,on_delete=models.SET_NULL,null=True,blank=False)
    ...

    def __str__(self):
        return self.employee_number

我进行过滤的部分,因此只有Salesman的员工编号位于小部件的attrs下,如下所示

forms.py

class WarehouseForm(AppsModelForm):
    class Meta:
        model = EmployeeWorkAreaLog
        widgets = {
            'employee_number': ForeignKeyRawIdWidget(EmployeeWorkAreaLog._meta.get_field('employee_number').remote_field,site,attrs={'id':'employee_number_field'}),}
        fields = ('employee_number','work_area','station_number')

    def clean_employee_number(self):
        employee_number = self.cleaned_data.get('employee_number')

        if Salesman.objects.filter(id=employee_number).team is 'WF':
            raise forms.ValidationError(_("Employee not valid,please contact manager"))
        return employee_number

views.py

class EnterExitArea(CreateView):
    model = EmployeeWorkAreaLog
    template_name = "operations/enter_exit_area.html"
    form_class = WarehouseForm

    def form_valid(self,form):
        emp_num = form.cleaned_data['employee_number']
        area = form.cleaned_data['work_area']
        station = form.cleaned_data['station_number']

        if 'enter_area' in self.request.POST:
            form.save()
            return HttpResponseRedirect(self.request.path_info)

        elif 'leave_area' in self.request.POST:
            form.save()
            return HttpResponseRedirect(self.request.path_info)
samleiming99n 回答:如何使用.filter()/。get()来查看值是否在外部模型中以在Django中进行验证?

get()返回一个Salesman对象,而filter()返回一个查询集。

要检查推销员是否存在给定的employee_number和具有get()的团队“ WF”:

def clean_employee_number(self):
    employee_number = self.cleaned_data.get('employee_number')

    try:
        salesman = Salesman.objects.get(id=employee_number,team='WF')
    except Salesman.DoesNotExist:
        raise forms.ValidationError(_("Employee not valid,please contact manager"))
    return employee_number

with filter():

  def clean_employee_number(self):
    employee_number = self.cleaned_data.get('employee_number')

    salesman = Salesman.objects.filter(id=employee_number,team='WF').first()
    if not salesman:
        raise forms.ValidationError(_("Employee not valid,please contact manager"))
    return employee_number
本文链接:https://www.f2er.com/3157240.html

大家都在问