filters.py 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443
  1. """
  2. This encapsulates the logic for displaying filters in the Django admin.
  3. Filters are specified in models with the "list_filter" option.
  4. Each filter subclass knows how to display a filter for a field that passes a
  5. certain test -- e.g. being a DateField or ForeignKey.
  6. """
  7. import datetime
  8. from django.contrib.admin.options import IncorrectLookupParameters
  9. from django.contrib.admin.utils import (
  10. get_model_from_relation, prepare_lookup_value, reverse_field_path,
  11. )
  12. from django.core.exceptions import ImproperlyConfigured, ValidationError
  13. from django.db import models
  14. from django.utils import timezone
  15. from django.utils.encoding import force_text
  16. from django.utils.translation import ugettext_lazy as _
  17. class ListFilter(object):
  18. title = None # Human-readable title to appear in the right sidebar.
  19. template = 'admin/filter.html'
  20. def __init__(self, request, params, model, model_admin):
  21. # This dictionary will eventually contain the request's query string
  22. # parameters actually used by this filter.
  23. self.used_parameters = {}
  24. if self.title is None:
  25. raise ImproperlyConfigured(
  26. "The list filter '%s' does not specify "
  27. "a 'title'." % self.__class__.__name__)
  28. def has_output(self):
  29. """
  30. Returns True if some choices would be output for this filter.
  31. """
  32. raise NotImplementedError('subclasses of ListFilter must provide a has_output() method')
  33. def choices(self, changelist):
  34. """
  35. Returns choices ready to be output in the template.
  36. `changelist` is the ChangeList to be displayed.
  37. """
  38. raise NotImplementedError('subclasses of ListFilter must provide a choices() method')
  39. def queryset(self, request, queryset):
  40. """
  41. Returns the filtered queryset.
  42. """
  43. raise NotImplementedError('subclasses of ListFilter must provide a queryset() method')
  44. def expected_parameters(self):
  45. """
  46. Returns the list of parameter names that are expected from the
  47. request's query string and that will be used by this filter.
  48. """
  49. raise NotImplementedError('subclasses of ListFilter must provide an expected_parameters() method')
  50. class SimpleListFilter(ListFilter):
  51. # The parameter that should be used in the query string for that filter.
  52. parameter_name = None
  53. def __init__(self, request, params, model, model_admin):
  54. super(SimpleListFilter, self).__init__(
  55. request, params, model, model_admin)
  56. if self.parameter_name is None:
  57. raise ImproperlyConfigured(
  58. "The list filter '%s' does not specify "
  59. "a 'parameter_name'." % self.__class__.__name__)
  60. if self.parameter_name in params:
  61. value = params.pop(self.parameter_name)
  62. self.used_parameters[self.parameter_name] = value
  63. lookup_choices = self.lookups(request, model_admin)
  64. if lookup_choices is None:
  65. lookup_choices = ()
  66. self.lookup_choices = list(lookup_choices)
  67. def has_output(self):
  68. return len(self.lookup_choices) > 0
  69. def value(self):
  70. """
  71. Returns the value (in string format) provided in the request's
  72. query string for this filter, if any. If the value wasn't provided then
  73. returns None.
  74. """
  75. return self.used_parameters.get(self.parameter_name)
  76. def lookups(self, request, model_admin):
  77. """
  78. Must be overridden to return a list of tuples (value, verbose value)
  79. """
  80. raise NotImplementedError(
  81. 'The SimpleListFilter.lookups() method must be overridden to '
  82. 'return a list of tuples (value, verbose value)')
  83. def expected_parameters(self):
  84. return [self.parameter_name]
  85. def choices(self, changelist):
  86. yield {
  87. 'selected': self.value() is None,
  88. 'query_string': changelist.get_query_string({}, [self.parameter_name]),
  89. 'display': _('All'),
  90. }
  91. for lookup, title in self.lookup_choices:
  92. yield {
  93. 'selected': self.value() == force_text(lookup),
  94. 'query_string': changelist.get_query_string({self.parameter_name: lookup}, []),
  95. 'display': title,
  96. }
  97. class FieldListFilter(ListFilter):
  98. _field_list_filters = []
  99. _take_priority_index = 0
  100. def __init__(self, field, request, params, model, model_admin, field_path):
  101. self.field = field
  102. self.field_path = field_path
  103. self.title = getattr(field, 'verbose_name', field_path)
  104. super(FieldListFilter, self).__init__(
  105. request, params, model, model_admin)
  106. for p in self.expected_parameters():
  107. if p in params:
  108. value = params.pop(p)
  109. self.used_parameters[p] = prepare_lookup_value(p, value)
  110. def has_output(self):
  111. return True
  112. def queryset(self, request, queryset):
  113. try:
  114. return queryset.filter(**self.used_parameters)
  115. except ValidationError as e:
  116. raise IncorrectLookupParameters(e)
  117. @classmethod
  118. def register(cls, test, list_filter_class, take_priority=False):
  119. if take_priority:
  120. # This is to allow overriding the default filters for certain types
  121. # of fields with some custom filters. The first found in the list
  122. # is used in priority.
  123. cls._field_list_filters.insert(
  124. cls._take_priority_index, (test, list_filter_class))
  125. cls._take_priority_index += 1
  126. else:
  127. cls._field_list_filters.append((test, list_filter_class))
  128. @classmethod
  129. def create(cls, field, request, params, model, model_admin, field_path):
  130. for test, list_filter_class in cls._field_list_filters:
  131. if not test(field):
  132. continue
  133. return list_filter_class(field, request, params, model, model_admin, field_path=field_path)
  134. class RelatedFieldListFilter(FieldListFilter):
  135. def __init__(self, field, request, params, model, model_admin, field_path):
  136. other_model = get_model_from_relation(field)
  137. self.lookup_kwarg = '%s__%s__exact' % (field_path, field.target_field.name)
  138. self.lookup_kwarg_isnull = '%s__isnull' % field_path
  139. self.lookup_val = request.GET.get(self.lookup_kwarg)
  140. self.lookup_val_isnull = request.GET.get(self.lookup_kwarg_isnull)
  141. super(RelatedFieldListFilter, self).__init__(
  142. field, request, params, model, model_admin, field_path)
  143. self.lookup_choices = self.field_choices(field, request, model_admin)
  144. if hasattr(field, 'verbose_name'):
  145. self.lookup_title = field.verbose_name
  146. else:
  147. self.lookup_title = other_model._meta.verbose_name
  148. self.title = self.lookup_title
  149. self.empty_value_display = model_admin.get_empty_value_display()
  150. @property
  151. def include_empty_choice(self):
  152. """
  153. Return True if a "(None)" choice should be included, which filters
  154. out everything except empty relationships.
  155. """
  156. return self.field.null or (self.field.is_relation and self.field.many_to_many)
  157. def has_output(self):
  158. if self.include_empty_choice:
  159. extra = 1
  160. else:
  161. extra = 0
  162. return len(self.lookup_choices) + extra > 1
  163. def expected_parameters(self):
  164. return [self.lookup_kwarg, self.lookup_kwarg_isnull]
  165. def field_choices(self, field, request, model_admin):
  166. return field.get_choices(include_blank=False)
  167. def choices(self, changelist):
  168. yield {
  169. 'selected': self.lookup_val is None and not self.lookup_val_isnull,
  170. 'query_string': changelist.get_query_string(
  171. {},
  172. [self.lookup_kwarg, self.lookup_kwarg_isnull]
  173. ),
  174. 'display': _('All'),
  175. }
  176. for pk_val, val in self.lookup_choices:
  177. yield {
  178. 'selected': self.lookup_val == force_text(pk_val),
  179. 'query_string': changelist.get_query_string({
  180. self.lookup_kwarg: pk_val,
  181. }, [self.lookup_kwarg_isnull]),
  182. 'display': val,
  183. }
  184. if self.include_empty_choice:
  185. yield {
  186. 'selected': bool(self.lookup_val_isnull),
  187. 'query_string': changelist.get_query_string({
  188. self.lookup_kwarg_isnull: 'True',
  189. }, [self.lookup_kwarg]),
  190. 'display': self.empty_value_display,
  191. }
  192. FieldListFilter.register(lambda f: f.remote_field, RelatedFieldListFilter)
  193. class BooleanFieldListFilter(FieldListFilter):
  194. def __init__(self, field, request, params, model, model_admin, field_path):
  195. self.lookup_kwarg = '%s__exact' % field_path
  196. self.lookup_kwarg2 = '%s__isnull' % field_path
  197. self.lookup_val = request.GET.get(self.lookup_kwarg)
  198. self.lookup_val2 = request.GET.get(self.lookup_kwarg2)
  199. super(BooleanFieldListFilter, self).__init__(field, request, params, model, model_admin, field_path)
  200. if (self.used_parameters and self.lookup_kwarg in self.used_parameters and
  201. self.used_parameters[self.lookup_kwarg] in ('1', '0')):
  202. self.used_parameters[self.lookup_kwarg] = bool(int(self.used_parameters[self.lookup_kwarg]))
  203. def expected_parameters(self):
  204. return [self.lookup_kwarg, self.lookup_kwarg2]
  205. def choices(self, changelist):
  206. for lookup, title in (
  207. (None, _('All')),
  208. ('1', _('Yes')),
  209. ('0', _('No'))):
  210. yield {
  211. 'selected': self.lookup_val == lookup and not self.lookup_val2,
  212. 'query_string': changelist.get_query_string({
  213. self.lookup_kwarg: lookup,
  214. }, [self.lookup_kwarg2]),
  215. 'display': title,
  216. }
  217. if isinstance(self.field, models.NullBooleanField):
  218. yield {
  219. 'selected': self.lookup_val2 == 'True',
  220. 'query_string': changelist.get_query_string({
  221. self.lookup_kwarg2: 'True',
  222. }, [self.lookup_kwarg]),
  223. 'display': _('Unknown'),
  224. }
  225. FieldListFilter.register(
  226. lambda f: isinstance(f, (models.BooleanField, models.NullBooleanField)),
  227. BooleanFieldListFilter
  228. )
  229. class ChoicesFieldListFilter(FieldListFilter):
  230. def __init__(self, field, request, params, model, model_admin, field_path):
  231. self.lookup_kwarg = '%s__exact' % field_path
  232. self.lookup_kwarg_isnull = '%s__isnull' % field_path
  233. self.lookup_val = request.GET.get(self.lookup_kwarg)
  234. self.lookup_val_isnull = request.GET.get(self.lookup_kwarg_isnull)
  235. super(ChoicesFieldListFilter, self).__init__(
  236. field, request, params, model, model_admin, field_path)
  237. def expected_parameters(self):
  238. return [self.lookup_kwarg, self.lookup_kwarg_isnull]
  239. def choices(self, changelist):
  240. yield {
  241. 'selected': self.lookup_val is None,
  242. 'query_string': changelist.get_query_string(
  243. {}, [self.lookup_kwarg, self.lookup_kwarg_isnull]
  244. ),
  245. 'display': _('All')
  246. }
  247. none_title = ''
  248. for lookup, title in self.field.flatchoices:
  249. if lookup is None:
  250. none_title = title
  251. continue
  252. yield {
  253. 'selected': force_text(lookup) == self.lookup_val,
  254. 'query_string': changelist.get_query_string(
  255. {self.lookup_kwarg: lookup}, [self.lookup_kwarg_isnull]
  256. ),
  257. 'display': title,
  258. }
  259. if none_title:
  260. yield {
  261. 'selected': bool(self.lookup_val_isnull),
  262. 'query_string': changelist.get_query_string({
  263. self.lookup_kwarg_isnull: 'True',
  264. }, [self.lookup_kwarg]),
  265. 'display': none_title,
  266. }
  267. FieldListFilter.register(lambda f: bool(f.choices), ChoicesFieldListFilter)
  268. class DateFieldListFilter(FieldListFilter):
  269. def __init__(self, field, request, params, model, model_admin, field_path):
  270. self.field_generic = '%s__' % field_path
  271. self.date_params = {k: v for k, v in params.items() if k.startswith(self.field_generic)}
  272. now = timezone.now()
  273. # When time zone support is enabled, convert "now" to the user's time
  274. # zone so Django's definition of "Today" matches what the user expects.
  275. if timezone.is_aware(now):
  276. now = timezone.localtime(now)
  277. if isinstance(field, models.DateTimeField):
  278. today = now.replace(hour=0, minute=0, second=0, microsecond=0)
  279. else: # field is a models.DateField
  280. today = now.date()
  281. tomorrow = today + datetime.timedelta(days=1)
  282. if today.month == 12:
  283. next_month = today.replace(year=today.year + 1, month=1, day=1)
  284. else:
  285. next_month = today.replace(month=today.month + 1, day=1)
  286. next_year = today.replace(year=today.year + 1, month=1, day=1)
  287. self.lookup_kwarg_since = '%s__gte' % field_path
  288. self.lookup_kwarg_until = '%s__lt' % field_path
  289. self.links = (
  290. (_('Any date'), {}),
  291. (_('Today'), {
  292. self.lookup_kwarg_since: str(today),
  293. self.lookup_kwarg_until: str(tomorrow),
  294. }),
  295. (_('Past 7 days'), {
  296. self.lookup_kwarg_since: str(today - datetime.timedelta(days=7)),
  297. self.lookup_kwarg_until: str(tomorrow),
  298. }),
  299. (_('This month'), {
  300. self.lookup_kwarg_since: str(today.replace(day=1)),
  301. self.lookup_kwarg_until: str(next_month),
  302. }),
  303. (_('This year'), {
  304. self.lookup_kwarg_since: str(today.replace(month=1, day=1)),
  305. self.lookup_kwarg_until: str(next_year),
  306. }),
  307. )
  308. if field.null:
  309. self.lookup_kwarg_isnull = '%s__isnull' % field_path
  310. self.links += (
  311. (_('No date'), {self.field_generic + 'isnull': 'True'}),
  312. (_('Has date'), {self.field_generic + 'isnull': 'False'}),
  313. )
  314. super(DateFieldListFilter, self).__init__(
  315. field, request, params, model, model_admin, field_path)
  316. def expected_parameters(self):
  317. params = [self.lookup_kwarg_since, self.lookup_kwarg_until]
  318. if self.field.null:
  319. params.append(self.lookup_kwarg_isnull)
  320. return params
  321. def choices(self, changelist):
  322. for title, param_dict in self.links:
  323. yield {
  324. 'selected': self.date_params == param_dict,
  325. 'query_string': changelist.get_query_string(param_dict, [self.field_generic]),
  326. 'display': title,
  327. }
  328. FieldListFilter.register(
  329. lambda f: isinstance(f, models.DateField), DateFieldListFilter)
  330. # This should be registered last, because it's a last resort. For example,
  331. # if a field is eligible to use the BooleanFieldListFilter, that'd be much
  332. # more appropriate, and the AllValuesFieldListFilter won't get used for it.
  333. class AllValuesFieldListFilter(FieldListFilter):
  334. def __init__(self, field, request, params, model, model_admin, field_path):
  335. self.lookup_kwarg = field_path
  336. self.lookup_kwarg_isnull = '%s__isnull' % field_path
  337. self.lookup_val = request.GET.get(self.lookup_kwarg)
  338. self.lookup_val_isnull = request.GET.get(self.lookup_kwarg_isnull)
  339. self.empty_value_display = model_admin.get_empty_value_display()
  340. parent_model, reverse_path = reverse_field_path(model, field_path)
  341. # Obey parent ModelAdmin queryset when deciding which options to show
  342. if model == parent_model:
  343. queryset = model_admin.get_queryset(request)
  344. else:
  345. queryset = parent_model._default_manager.all()
  346. self.lookup_choices = (queryset
  347. .distinct()
  348. .order_by(field.name)
  349. .values_list(field.name, flat=True))
  350. super(AllValuesFieldListFilter, self).__init__(
  351. field, request, params, model, model_admin, field_path)
  352. def expected_parameters(self):
  353. return [self.lookup_kwarg, self.lookup_kwarg_isnull]
  354. def choices(self, changelist):
  355. yield {
  356. 'selected': self.lookup_val is None and self.lookup_val_isnull is None,
  357. 'query_string': changelist.get_query_string({}, [self.lookup_kwarg, self.lookup_kwarg_isnull]),
  358. 'display': _('All'),
  359. }
  360. include_none = False
  361. for val in self.lookup_choices:
  362. if val is None:
  363. include_none = True
  364. continue
  365. val = force_text(val)
  366. yield {
  367. 'selected': self.lookup_val == val,
  368. 'query_string': changelist.get_query_string({
  369. self.lookup_kwarg: val,
  370. }, [self.lookup_kwarg_isnull]),
  371. 'display': val,
  372. }
  373. if include_none:
  374. yield {
  375. 'selected': bool(self.lookup_val_isnull),
  376. 'query_string': changelist.get_query_string({
  377. self.lookup_kwarg_isnull: 'True',
  378. }, [self.lookup_kwarg]),
  379. 'display': self.empty_value_display,
  380. }
  381. FieldListFilter.register(lambda f: True, AllValuesFieldListFilter)
  382. class RelatedOnlyFieldListFilter(RelatedFieldListFilter):
  383. def field_choices(self, field, request, model_admin):
  384. pk_qs = model_admin.get_queryset(request).distinct().values_list('%s__pk' % self.field_path, flat=True)
  385. return field.get_choices(include_blank=False, limit_choices_to={'pk__in': pk_qs})