Django admin添加自定义筛选器

我会选择定制 FieldListFilter 因为它允许根据您的需求将过滤器绑定到不同的模型字段。

下一步我们要做什么来实现这种过滤器:

• 构建lookup\u kwargs gte和lte,并将其指定为 expected_parameters
• 定义选项以返回空列表,否则 NotImplementedError
• 创建表单以维护字段验证
• 创建只输出表单的自定义模板,例如{{spec.form}}
• 如果表单有效,则将其清除数据,过滤掉Nones并过滤queryset,否则会处理错误(在下面的代码中,错误将被静音)

筛选器代码:

class StartTimeFilter(admin.filters.FieldListFilter):
    # custom template which just outputs form, e.g. {{spec.form}}
    template = 'start_time_filter.html'

    def __init__(self, *args, **kwargs):
        field_path = kwargs['field_path']
        self.lookup_kwarg_since = '%s__gte' % field_path
        self.lookup_kwarg_upto = '%s__lte' % field_path
        super(StartTimeFilter, self).__init__(*args, **kwargs)
        self.form = StartTimeForm(data=self.used_parameters, field_name=field_path)

    def expected_parameters(self):
        return [self.lookup_kwarg_since, self.lookup_kwarg_upto]

    # no predefined choices
    def choices(self, cl):
        return []

    def queryset(self, request, queryset):
        if self.form.is_valid():
            filter_params = {
                p: self.form.cleaned_data.get(p) for p in self.expected_parameters()
                if self.form.cleaned_data.get(p) is not None
            }
            return queryset.filter(**filter_params)
        else:
            return queryset

形式可以简单如下:

class StartTimeForm(forms.Form):

    def __init__(self, *args, **kwargs):
        self.field_name = kwargs.pop('field_name')
        super(StartTimeForm, self).__init__(*args, **kwargs)
        self.fields['%s__gte' % self.field_name] = forms.DateField()
        self.fields['%s__lte' % self.field_name] = forms.DateField()

这并不完全是您所要求的,但您可以在 JobAdDuration 模型管理员。这样,您可以根据 ad_activated 和 ad_finished 领域。我添加了一个链接到 job 字段,以便您可以直接单击它以便于导航。

为了使其成为日期html5过滤器,我使用了 django-admin-rangefilter 图书馆

from django.urls import reverse
from django.contrib import admin
from .models import Job, JobAdDuration
from django.utils.html import format_html
from rangefilter.filter import DateRangeFilter


@admin.register(JobAdDuration)
class JobAdDurationAdmin(admin.ModelAdmin):

    list_filter = (('ad_activated', DateRangeFilter), ('ad_finished', DateRangeFilter))
    list_display = ('id', 'job_link', 'ad_activated', 'ad_finished')

    def job_link(self, obj):
        return format_html('<a href="{}">{}</a>', reverse('admin:job_job_change', args=[obj.job.id]), obj.job.title)
    job_link.short_description = 'Job'

如果您确实想走现有路线(内部过滤 JobAdmin ),那么事情就会变得相当复杂。

我最近遇到了类似的问题,我需要根据另一个模型的值过滤数据。这可以使用SimpleListFilter完成。您只需要在lookup和queryset函数中稍作调整。我建议您安装django调试工具栏,这样您就可以知道django正在内部执行哪些sql查询。

#import your corresponding models first

class StartTimeFilter(SimpleListFilter):
title = ('Start date')
parameter_name = 'ad_finished'

  def lookups(self, request, model_admin):

   data = []
   qs = JobAdDuration.objects.filter()   # Note : if you do not have distinct values of ad_activated apply distinct filter here to only get distinct values
   print qs
   for c in qs:
       data.append([c.ad_activated, c.ad_activated])  # The first c.activated is the queryset condition your filter will execute on your Job model to filter data ... and second c.ad_activated is the data that will be displayed in dropdown in StartTimeFilter
   return data

  def queryset(self, request, queryset):
     if self.value():
       assigned = JobAdDuration.objects.filter(ad_activated__exact = self.value())  # add your custom filter function based on your requirement
       return Job.objects.filter(pk__in=[current.job.id for current in assigned])
     else:
       return queryset

和in list\u过滤器

list_filter = (StartTimeFilter) # no quotes else it will search for a field in the model 'job'.