【Django-Talent系统】去除查询参数结尾的0--20220609

employee_dept = employee_dept.strip(‘0’)
employee_dept__istartswith=employee_dept

def student_list(request):
    '''整体看板-明细查询'''

    employee_dept = request.POST.get('employee_dept', '')
    employee_id = request.POST.get('employee_id', '')
    EmployeeUser_all = EmployeeUser.objects.all()

    print('employee_dept',employee_dept)
    print('employee_id',employee_id)


    #查看用户权限
    u = User.objects.get(username=request.user)

    #如果是超级管理员，就全部查看；否则就按部门查看和role
    if u.is_superuser:
        EmployeeUser_self1 = EmployeeUser_all
    elif u.last_name == 'HR':
        #如果是一般管理员，根据权限来查看的数据
        EmployeeUser_self1 = EmployeeUser_all.filter(site=u.first_name)
    else:
        # 非管理员默认只能查自己工号的数据
        EmployeeUser_self1 = EmployeeUser_all.filter(Q(employee_id=request.user.employeeuser.employee_id))


    # 处理下employee_dept，去掉最后的0
    employee_dept = employee_dept.strip('0')

    # 根据筛选条件来得出object
    if employee_dept == '' and employee_id == '':
        employee_list = EmployeeUser_all & EmployeeUser_self1
    elif employee_dept == '' and employee_id != '':
        employee_list = EmployeeUser_all.filter(Q(employee_id=employee_id)) & EmployeeUser_self1
    elif employee_dept != '' and employee_id == '':
        employee_list = EmployeeUser_all.filter(Q(employee_dept__istartswith=employee_dept)) & EmployeeUser_self1
    elif employee_dept != '' and employee_id != '':
        employee_list = EmployeeUser_all.filter(Q(employee_dept__istartswith=employee_dept) & Q(employee_id=employee_id)) & EmployeeUser_self1


    return render(request, 'student_list.html',locals())