class QuestionFilter(django_filters.FilterSet):
# created_date_time = filters.DateFilter(field_name='created_date_time', label='date')
order = filters.OrderingFilter(fields=(('created_date_time', 'date time'),
('id', 'question id')))
datetime_range = filters.DateFromToRangeFilter(name='created_date_time', widget=RangeWidget)
tags = filters.AllValuesMultipleFilter(name='tags')
creator = filters.ModelMultipleChoiceFilter(name='creator', to_field_name='id', queryset=User.objects.all())
content = filters.CharFilter(name='content_description', lookup_expr='contains')
class Meta:
model = models.Question
fields = []
class NotificationFilter(django_filters.FilterSet):
unread_choices = (
(True, _('unread')),
(False, _('read'))
)
all = filters.ChoiceFilter(name='unread', choices=unread_choices, empty_label=_('All'))
level = filters.ChoiceFilter(name='level', choices=Notification.LEVELS, empty_label=_('Level'))
description = filters.CharFilter(name='description', lookup_expr='contains')
timestamp = filters.DateFromToRangeFilter(name='timestamp', widget=RangeWidget)
class Meta:
model = Notification
fields = []
class EventFilterSet(django_filters.FilterSet):
calendars = filters.ModelMultipleChoiceFilter(
field_name="calendars",
queryset=Calendar.objects.all(),
label="Calendriers")
date = filters.DateFromToRangeFilter(field_name="start_time",
lookup_expr="range",
label="Entre les dates")
subtype = django_filters.filterset.ModelMultipleChoiceFilter(
queryset=EventSubtype.objects.all())
class Meta:
model = Event
fields = ["visibility"]
class HupuFilterSerializer(FilterSet):
# 查询需要参数（条件）
_date = filters.DateFromToRangeFilter(field_name='create_dt')
_channel_names = filters.BaseInFilter(field_name='channel_names')
_team = filters.BaseInFilter(field_name='team')
_account_type = filters.BaseInFilter(field_name='account_type')
_status = filters.BaseInFilter(field_name='status')
_used = filters.BaseInFilter(field_name='is_usable')
_deleted = filters.BaseInFilter(field_name='deleted')
_jieba_title = filters.CharFilter(field_name='jieba_title', lookup_expr='icontains')
class Meta:
# 查询表
model = Source
fields = ['_date', '_channel_names', '_team', '_account_type', '_jieba_title', '_status', '_used', '_deleted']
class CRNFilter(FilterSet):
created_at = filters.DateFromToRangeFilter(
widget=RangeWidget(attrs={
'placeholder': 'YYYY/MM/DD',
'type': 'date'
}),
label='CRN Date Between')
#cr_station = forms.ModelChoiceField(queryset=Station.objects.all().order_by('station_name'), widget=Select2Widget(attrs={'class': 'select2-selection select2-selection--single', }))
class Meta:
model = Crn
fields = ('cr_station', 'created_at')
class OrderFilter(FilterSet):
order_cost = filters.RangeFilter(label='фівфів')
order_date = filters.DateFromToRangeFilter()
order_payment = filters.ChoiceFilter(choices=Order.payment_list)
order_shipment = filters.ChoiceFilter(choices=Order.shipment_list)
order_status = filters.MultipleChoiceFilter(choices=Order.status_list)
def filter_search(self, qs, search, value):
search_fields = Q(order_number__icontains=value) | Q(
orderitem__product__name__icontains=value)
result = qs.filter(search_fields).distinct()
return result
search = filters.CharFilter(method='filter_search')
#qs = Order.objects.filter(user=?)
class Meta:
model = Order
fields = ['id']
class DayFilter(filterset.FilterSet):
date = filters.DateFromToRangeFilter()
class Meta:
model = Day
fields = ['date']