如何覆盖在list_filter中给出过滤器的查询器? [英] How to override the queryset giving the filters in list_filter?
问题描述
给定以下模型
class AnotherModel(models.Model):
n = models.IntegerField()
class MyModel(models.Model):
somefield = models.ForeignKey(AnotherModel)
和admin
class MyModelAdmin(admin.ModelAdmin):
list_filter =('somefield' ,)
如何过滤 AnotherModel
只显示管理员过滤器中给定的 n
值的那些
我需要像: / p>
过滤器
By somefield
all
[给定n的AnotherModel实例的列表]
请参阅 ModelAdmin.queryset 和< a href =https://docs.djangoproject.com/en/dev/ref/con trib / admin /#django.contrib.admin.ModelAdmin.formfield_for_foreignkeyrel =nofollow noreferrer> ModelAdmin.formfield_for_foreignkey 。从文档中:
ModelAdmin上的查询方法返回可由管理站点编辑的所有模型实例的QuerySet。覆盖此方法的一个用例是显示登录用户拥有的对象:
class MyModelAdmin(admin.ModelAdmin):
def queryset(self,request):
qs = super(MyModelAdmin,self).queryset(request)
如果request.user.is_superuser:
return qs
return qs.filter(author = request.user)
ModelAdmin上的formfield_for_foreignkey方法允许您覆盖外键字段的默认表单域。例如,根据用户返回该外键字段的对象子集:
class MyModelAdmin(admin.ModelAdmin):
def formfield_for_foreignkey(self,db_field,request,** kwargs):
如果db_field.name ==car:
kwargs [queryset ] = Car.objects.filter(owner = request.user)
return super(MyModelAdmin,self).formfield_for_foreignkey(db_field,request,** kwargs)
这使用HttpRequest实例过滤汽车外键字段,只显示用户实例拥有的汽车。
[更新]
对不起,我没有阅读过滤器部分。在Django> = 1.4中,您可以在 django.contrib.admin.SimpleListFilter 的子类dev / ref / contrib / admin /#django.contrib.admin.ModelAdmin.list_filterrel =nofollow noreferrer> list_filter参数列表,您可以使用它来覆盖查找和查询方法。从django.contrib导入admin
从django.utils.translation中获取
从datetime导入日期
导入ugettext_lazy为_
类DecadeBornListFilter(admin.SimpleListFilter):
#人类可读的标题将显示在
#右侧管理员侧边栏上方的过滤器选项上方。
title = _('decade born')
#在URL查询中使用的过滤器的参数。
parameter_name ='decade'
def lookups(self,request,model_admin):
返回一个元组列表,每个
tuple是
出现在URL查询中的选项的编码值,第二个元素是
可读的名称,该选项将在右侧栏中显示
return(
('80s',_('在八十年代)),
('90s',_('在九十年代' )
)
def queryset(self,request,queryset):
返回过滤的查询集,基于
查询字符串,并通过
`self.value()`。
#将请求的值('80s'或'90s')
#决定如何过滤查询。
如果self.value()=='80s':
return queryset.filter(birthday__gte = date(1980,1,1))
birthday__lte = date(1989,12,31) )
如果self.value()=='90s':
return queryset.filter(birthday__gte = date(1990,1,1),
birthday__lte = date(1999,12,31 )
class PersonAdmin(admin.ModelAdmin):
list_filter =(DecadeBornListFilter,)
Given the following models
class AnotherModel(models.Model):
n = models.IntegerField()
class MyModel(models.Model):
somefield = models.ForeignKey(AnotherModel)
and admin
class MyModelAdmin(admin.ModelAdmin):
list_filter = ('somefield',)
how can I filter the instances of AnotherModel
to show only those with a given n
value in my admin filter?
I need something like:
Filter
By somefield
all
[list of AnotherModel instances with given n]
See ModelAdmin.queryset and ModelAdmin.formfield_for_foreignkey. From the docs:
The queryset method on a ModelAdmin returns a QuerySet of all model instances that can be edited by the admin site. One use case for overriding this method is to show objects owned by the logged-in user:
class MyModelAdmin(admin.ModelAdmin):
def queryset(self, request):
qs = super(MyModelAdmin, self).queryset(request)
if request.user.is_superuser:
return qs
return qs.filter(author=request.user)
The formfield_for_foreignkey method on a ModelAdmin allows you to override the default formfield for a foreign keys field. For example, to return a subset of objects for this foreign key field based on the user:
class MyModelAdmin(admin.ModelAdmin):
def formfield_for_foreignkey(self, db_field, request, **kwargs):
if db_field.name == "car":
kwargs["queryset"] = Car.objects.filter(owner=request.user)
return super(MyModelAdmin, self).formfield_for_foreignkey(db_field, request, **kwargs)
This uses the HttpRequest instance to filter the Car foreign key field to only display the cars owned by the User instance.
[update]
Sorry, I failed to read the "filter" part. In Django >= 1.4 you can pass a subclass of django.contrib.admin.SimpleListFilter
in the list_filter argument list, which you can use in order to override the lookups and queryset methods.
from datetime import date
from django.contrib import admin
from django.utils.translation import ugettext_lazy as _
class DecadeBornListFilter(admin.SimpleListFilter):
# Human-readable title which will be displayed in the
# right admin sidebar just above the filter options.
title = _('decade born')
# Parameter for the filter that will be used in the URL query.
parameter_name = 'decade'
def lookups(self, request, model_admin):
"""
Returns a list of tuples. The first element in each
tuple is the coded value for the option that will
appear in the URL query. The second element is the
human-readable name for the option that will appear
in the right sidebar.
"""
return (
('80s', _('in the eighties')),
('90s', _('in the nineties')),
)
def queryset(self, request, queryset):
"""
Returns the filtered queryset based on the value
provided in the query string and retrievable via
`self.value()`.
"""
# Compare the requested value (either '80s' or '90s')
# to decide how to filter the queryset.
if self.value() == '80s':
return queryset.filter(birthday__gte=date(1980, 1, 1),
birthday__lte=date(1989, 12, 31))
if self.value() == '90s':
return queryset.filter(birthday__gte=date(1990, 1, 1),
birthday__lte=date(1999, 12, 31))
class PersonAdmin(admin.ModelAdmin):
list_filter = (DecadeBornListFilter,)
这篇关于如何覆盖在list_filter中给出过滤器的查询器?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!