gpt4 book ai didi

python - 如何使用 django-tables2 和 django-filter 过滤初始表?

转载 作者:行者123 更新时间:2023-12-05 06:02:37 26 4
gpt4 key购买 nike

我正在使用 django-tables2 和 django-filter 从模型中列出员工。我在过滤呈现的初始表时遇到问题。它包括所有记录。我希望初始表仅包含状态 = 1 的员工。然后,让过滤器接管。

View .py

from .models import Employee
from .tables import EmployeeTable
from .filters import EmployeeFilter
from .forms import EmployeeSearchForm

class EmployeeListView(SingleTableMixin, FilterView):
model = Employee
table_class = EmployeeTable
template_name = 'employees/employee_list.html'

filterset_class = EmployeeFilter

def get_table_data(self):
return Employee.objects.filter(status=1)

过滤器.py:

from django.db.models import Value, Q
from django import forms

from .models import Employee

class EmployeeFilter(django_filters.FilterSet):
search = django_filters.CharFilter(label='Search', method='search_filter')
inactive = django_filters.BooleanFilter(widget=forms.CheckboxInput, label='Inactive', method='include_inactive')

def search_filter(self, queryset, name, value):
return queryset.annotate(fullname=Concat('first_name', Value(' '), 'last_name')).filter(
Q(fullname__icontains=value) | Q(g_number__icontains=value)
)

def include_inactive(self, queryset, name, value):
expression = Q(status__in=[1,2,5]) if value else Q(status__in=[1,5])
return queryset.filter(expression)

class Meta:
model = Employee
fields = ['search', 'inactive']

表格.py:

from django.utils.html import format_html
from django.urls import reverse

import django_tables2 as tables

from .models import Employee

class EmployeeTable(tables.Table):
full_name = tables.Column(order_by=("first_name", "last_name"))
g_number = tables.Column(linkify=True)
selection = tables.columns.CheckBoxColumn(
accessor='pk',
attrs = { "th__input": {"onclick": "toggle(this)"}},
orderable=False
)
term = tables.Column(verbose_name=("Action"), empty_values=())

class Meta:
model = Employee

template_name = "django_tables2/bootstrap.html"
fields = ("selection", "g_number","full_name", 'org', 'job', 'status', 'term')
attrs = {
"class": "table table-hover",
"thead": {"class": "thead-dark"}
}
order_by = '-g_number'

最佳答案

从 Django 过滤器文档中,您可以在过滤器类上过滤主要查询集。更新:要根据 self.request 中的属性设置 qs,只需检查该属性并相应地进行过滤。

https://django-filter.readthedocs.io/en/master/guide/usage.html#filtering-the-primary-qs

class EmployeeFilter(django_filters.FilterSet):

[...]

@property
def qs(self):
parent = super().qs
filter_inactive = getattr(self.request, 'inactive', False)

if not filter_inactive:
return parent.filter(status=1)

return parent

关于python - 如何使用 django-tables2 和 django-filter 过滤初始表?,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/66889644/

26 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com