class PostSearchFilter(filters.FilterSet):
title = filters.CharFilter(lookup_expr='icontains')
date = filters.DateFilter(lookup_expr='icontains')
author = filters.CharFilter()
class Meta:
model = models.Publications
fields = ['title', 'date']
class VotesFilter(filters.FilterSet):
created = filters.DateFilter(field_name='created', lookup_expr='date')
class Meta:
model = models.Vote
fields = [
"created",
]
class TasksFilter(filters.FilterSet):
"""
Фильтрация Task по статусу и запланированной дате завершения
"""
status = filters.ChoiceFilter(choices=STATUS_CHOICES)
completion_date = filters.DateFilter(field_name='completion_date')
completion_date_from = filters.DateFilter(field_name='completion_date',
lookup_expr='gte')
completion_date_to = filters.DateFilter(field_name='completion_date',
lookup_expr='lte')
class Meta:
model = Task
fields = [
'status',
'completion_date',
]
class SalesInvoiceFilter(FilterSet):
# customer = CharFilter('customer')
start_date = filters.DateFilter(method="filter_by_start_date")
end_date = filters.DateFilter(method="filter_by_end_date")
class Meta:
model = models.SalesInvoice
fields = "__all__"
# fields = ["customer","date"]
def filter_by_start_date(self, queryset, name, value):
queryset = queryset.filter(date__gte = value)
return queryset
def filter_by_end_date(self, queryset, name, value):
queryset = queryset.filter(date__lte = value)
return queryset
class ReviewFilter(filters.FilterSet):
"""FilterSet for the Review API endpoint."""
user = filters.ModelChoiceFilter(queryset=User.objects.all())
film = filters.ModelChoiceFilter(queryset=Film.objects.all())
date_submitted = filters.DateFilter('date_submitted',
lookup_expr='contains')
submitted_before = filters.DateFilter('date_submitted', lookup_expr='lte')
submitted_after = filters.DateFilter('date_submitted', lookup_expr='gte')
review = filters.CharFilter('review', lookup_expr='icontains')
rating = filters.NumberFilter('rating', lookup_expr='exact')
ordering = filters.OrderingFilter(fields=[
('user', 'user'),
('film', 'film'),
('date_submitted', 'date_submitted'),
('rating', 'rating'),
])
class ShiftFilter(filters.FilterSet):
start_date_gte = filters.DateFilter(field_name="start_date",
lookup_expr='gte')
start_date_lte = filters.DateFilter(field_name="start_date",
lookup_expr='lte')
start_date_time_gte = filters.DateTimeFilter(field_name="start_date",
lookup_expr='gte')
start_date_time_lte = filters.DateTimeFilter(field_name="start_date",
lookup_expr='lte')
status = filters.MultipleChoiceFilter(choices=Shift.STATUS, )
class Meta:
model = Shift
fields = [
'id', 'name', 'event', 'location', 'start_date', 'end_date',
'start_date_gte', 'start_date_lte', 'status',
'start_date_time_gte', 'start_date_time_lte'
]
class ReservaFilter(filters.FilterSet):
data_reserva = filters.DateFilter(name="dataReserva",
lookup_expr='dataReserva')
class Meta:
model = Reserva
fields = '__all__'
class AnnouncementFilter(filters.FilterSet):
id = filters.UUIDFilter(field_name="id")
publication_date = filters.DateFilter(field_name="publication_date",
lookup_expr="gte")
# To add Category Filter
class Meta:
model = Announcement
fields = ["id", "publication_date"]
class ProductReviewFilters(filters.FilterSet):
author_id = filters.RangeFilter()
product_id = filters.RangeFilter()
created_at = filters.DateFilter()
class Meta:
model = ProductReview
fields = ("author_id", "product_id", "created_at")
class TweetFilter(filters.FilterSet):
DEMOCRAT = 'Democrat'
REPUBLICAN = 'Republican'
POLITICAL_PARTY_CHOICES = ((DEMOCRAT, 'Democrat'), (REPUBLICAN,
'Republican'))
MALE = 'Male'
FEMALE = 'Female'
OTHER = 'Other'
GENDER_CHOICES = ((MALE, 'Male'), (FEMALE, 'Female'), (OTHER, 'Other'))
twitterUser__id = filters.NumberFilter(field_name='twitterUser__id',
lookup_expr='exact')
politician__id = filters.NumberFilter(field_name='politician__id',
lookup_expr='exact')
politician__last_name = filters.CharFilter(
field_name='politician__last_name', lookup_expr='exact')
politician__gender = filters.ChoiceFilter(choices=GENDER_CHOICES)
politician__political_party = filters.ChoiceFilter(
choices=POLITICAL_PARTY_CHOICES)
# politician__active = filters.BooleanFilter(field_name='politician__active', lookup_expr='exact')
# location = MyCharFilter(field_name='location', exclude=True)
is_retweet = filters.BooleanFilter(field_name='is_retweet',
lookup_expr='exact')
# created_at = filters.DateFilter(field_name='created_at', lookup_expr='exact')
start_date = filters.DateFilter(field_name='date',
lookup_expr=('gte'),
label='Start Date')
end_date = filters.DateFilter(field_name='date',
lookup_expr=('lt'),
label='End Date')
date_range = filters.DateRangeFilter(field_name='date', label='Date Range')
date = filters.DateFilter(field_name='date', lookup_expr='exact')
class Meta:
model = Tweet
fields = {
# 'created_at': ['year__lt', 'year__gt', 'month__gt', 'month__lt', 'day__gt', 'day__lt'],
'tweet_id': ['exact'],
'location': ['exact'],
# 'sentiment': ['gt', 'lt', 'exact'],
'toxicity': ['gte'],
'sexually_explicit': ['gte'],
'identity_attack': ['gte'],
'is_retweet': ['exact']
}
class QuestionnaireFilter(filters.FilterSet):
min_created = filters.DateTimeFilter(name='created',
lookup_expr='gte',
label='Дата создания от')
max_created = filters.DateTimeFilter(name='created',
lookup_expr='lte',
label='Дата создания до')
min_birth_date = filters.DateFilter(name='birth_date',
lookup_expr='gte',
label='Дата рождения от')
max_birth_date = filters.DateFilter(name='birth_date',
lookup_expr='lte',
label='Дата рождения до')
min_score = filters.NumberFilter(name='score',
lookup_expr='gte',
label='Минимальный скоринговый балл')
max_score = filters.NumberFilter(name='score',
lookup_expr='lte',
label='Максимальный скоринговый балл')
order = filters.OrderingFilter(fields=(
('surname', 'surname'),
('first_name', 'name'),
('birth_date', 'birth'),
('score', 'score'),
('created', 'created'),
),
field_labels={
'surname': 'По фамилии',
'first_name': 'По имени',
'birth_date': 'По дате рождения',
'score': 'По скоринговому баллу',
'created': 'По дате создания анкеты',
})
class Meta:
model = Questionnaire
fields = (
'min_created',
'max_created',
'min_birth_date',
'max_birth_date',
'min_score',
'max_score',
)
class TableFilter(filters.FilterSet):
date = filters.DateFilter(
field_name='reservation__date',
exclude=True,
required=True,
)
class Meta:
model = Table
fields = ['date']
class ReviewFilter(filters.FilterSet):
rating = filters.NumberFilter()
title = filters.CharFilter()
summary = filters.CharFilter()
ip_address = filters.CharFilter()
submission_date = filters.DateFilter()
class Meta:
model = Review
fields = ('rating', 'title', 'submissionDate')
class BaseContainerFilter(filters.FilterSet):
date_from = filters.DateFilter(field_name="date_from", lookup_expr='lte')
date_till = filters.DateFilter(field_name="date_till", lookup_expr='gte')
type = filters.NumberFilter(field_name='type')
location = NumberInFilter(to_field_name='id',
queryset=Station.objects.all())
location__city = NumberInFilter(to_field_name='id',
queryset=City.objects.all())
location__city__region = NumberInFilter(to_field_name='id',
queryset=Region.objects.all())
count = filters.NumberFilter(field_name='count')
address = filters.CharFilter(field_name='address', lookup_expr='icontains')
class Meta:
models = BaseContainer
fields = [
'type', 'address', 'location', 'location__city',
'location__city__region', 'date_from', 'date_till', 'count'
]
class ProductReviewFilter(filters.FilterSet):
"""Класс для определения фильтров для модели ProductReview."""
ID_user = filters.NumberFilter(field_name="ID_review_author")
ID_product = filters.NumberFilter(field_name="ID_product")
create_date = filters.DateFilter(field_name="creation_date")
class Meta:
model = ProductReview
fields = ["ID_user", "ID_product", "create_date"]
class TransactionFilterset(filters.FilterSet):
amount__eq = filters.NumberFilter(field_name="amount")
amount__gt = filters.NumberFilter(field_name="amount", lookup_expr="gt")
amount__lt = filters.NumberFilter(field_name="amount", lookup_expr="lt")
budget = filters.CharFilter(field_name="budget__id", lookup_expr="exact")
budget__name = filters.CharFilter(field_name="budget__name",
lookup_expr="exact")
description__exact = filters.CharFilter(field_name="description",
lookup_expr="exact")
description__icontains = filters.CharFilter(field_name="description",
lookup_expr="icontains")
date = filters.DateFilter(field_name="date")
date__gte = filters.DateFilter(field_name="date", lookup_expr="gte")
date__lte = filters.DateFilter(field_name="date", lookup_expr="lte")
tags = CharListFilter(field_name="tags__name", lookup_expr="iexact")
class ImageFilter(filters.FilterSet):
"""
Provides filtering functionality for the
:class:`~django_dicom.views.image.ImageViewSet`.
Available filters are:
* *id*: Primary key
* *series_uid*: Series instance UID (contains)
* *series_description*: Series description (contains)
* *number*: Series number (exact)
* *created_after_date*: Create after date
* *created_before_date*: Create before date
* *created_after_time*: Create after time
* *created_before_time*: Create before time
"""
series_uid = filters.CharFilter(
"series__uid", lookup_expr="contains", label="Series UID"
)
series_description = filters.CharFilter(
"series__description",
lookup_expr="contains",
label="Series description contains",
)
created_after_date = filters.DateFilter("date", lookup_expr="gte")
created_before_date = filters.DateFilter("date", lookup_expr="lte")
created_after_time = filters.DateFilter("time", lookup_expr="gte")
created_before_time = filters.DateFilter("time", lookup_expr="lte")
class Meta:
model = Image
fields = (
"id",
"uid",
"series_uid",
"series_description",
"created_after_date",
"created_before_date",
"created_after_time",
"created_before_time",
"number",
)
class OrderFilter(filters.FilterSet):
ORDER_STATUS_CHOICES = [
('pending', 'Pending'),
('complete', 'Complete'),
('on-hold', 'On Hold'),
('special-order', 'Special Order'),
('cancelled', 'Cancelled'),
]
order = filters.CharFilter(field_name='order_no',
label='Order Number',
lookup_expr='icontains')
billing_lastname = filters.CharFilter(field_name='billing_lastname',
label='Billing Surname',
lookup_expr='icontains')
order_status = filters.ChoiceFilter(field_name='order_status',
label='Order Status',
choices=ORDER_STATUS_CHOICES)
start_date = filters.DateFilter(
field_name='date',
lookup_expr=('gt'),
label='Date From',
widget=forms.DateInput(attrs={
'type': 'date',
'class': 'date-input',
'id': 'dateFromInput'
}))
end_date = filters.DateFilter(
field_name='date',
lookup_expr=('lt'),
label='to',
widget=forms.DateInput(attrs={
'type': 'date',
'class': 'date-input',
'id': 'dateToInput'
}))
class Meta:
model = Order
fields = [
'order', 'billing_lastname', 'order_status', 'start_date',
'end_date'
]
class NewsFilter(filters.FilterSet):
heading = filters.CharFilter(name='heading', lookup_expr='iexact')
creation_date = filters.DateFilter(
name='creation_date', lookup_expr=['lte', 'gte', 'exact'])
author = filters.CharFilter(name='author__name', lookup_expr='iexact')
category = filters.CharFilter(
name='category__name', lookup_expr='iexact')
class Meta:
model = News
fields = ['heading', 'creation_date', 'author', 'category']
class DeveloperFilter(filters.FilterSet):
joined_after = filters.DateFilter(field_name="date_joined",
lookup_expr='gte')
joined_before = filters.DateFilter(field_name="date_joined",
lookup_expr='lte')
app_count = filters.NumberFilter(field_name="app_count",
label="Application Count")
min_app_count = filters.NumberFilter(field_name="app_count",
lookup_expr='gte',
label="Min Application Count")
max_app_count = filters.NumberFilter(field_name="app_count",
lookup_expr='lte',
label="Max Application Count")
class Meta:
model = User
fields = [
'joined_after', 'joined_before', 'app_count', 'min_app_count',
'max_app_count'
]
class MatchFilter(filters.FilterSet):
player = MatchHasPlayer()
players = MatchHasAnyPlayers()
start_date = filters.DateFilter()
max = filters.Filter(field_name='id', method=limit_filter)
match_after = AfterDateFilter(field_name="match_date")
class Meta:
model = api_models.Match
fields = '__all__'
exclude = ['details']
class UserFilter(serializers.ModelSerializer):
username = filters.CharFilter(name="username", lookup_expr='contains')
start_date = filters.DateFilter(lookup_expr="gte")
end_date = filters.DateFilter(lookup_expr="lte")
class Meta:
model = User
fields = '__all__'
fields = ("username", "start_date", "end_date")
extra_kwargs = {
"username": {
"required": False
},
'start_date': {
'required': False
},
"end_date": {
"required": False
}
}
class EventFilter(filters.FilterSet):
name = filters.CharFilter(lookup_expr='icontains')
sport = filters.CharFilter(field_name='sport_id__name')
start_date__gte = filters.DateFilter(field_name='event_start',
lookup_expr='gte')
class Meta:
model = Event
fields = [
'name',
]
class EmployeeFilter(filters.FilterSet):
salary = filters.NumberFilter(field_name="salary", lookup_expr='iexact')
salary__gt = filters.NumberFilter(field_name="salary", lookup_expr='gt')
salary__gte = filters.NumberFilter(field_name="salary", lookup_expr='gte')
salary__lt = filters.NumberFilter(field_name="salary", lookup_expr='lt')
salary__lte = filters.NumberFilter(field_name="salary", lookup_expr='lte')
date = filters.DateFromToRangeFilter(field_name='date_of_birth')
date_of_birth = filters.DateFilter(field_name="date_of_birth")
date_of_birth__gte = filters.DateFilter(field_name="date_of_birth",
lookup_expr='gte')
date_of_birth__gt = filters.DateFilter(field_name="date_of_birth",
lookup_expr='gt')
date_of_birth__lte = filters.DateFilter(field_name="date_of_birth",
lookup_expr='lte')
date_of_birth__lt = filters.DateFilter(field_name="date_of_birth",
lookup_expr='lt')
name = filters.CharFilter(field_name="name", lookup_expr='iexact')
name__contains = filters.CharFilter(field_name="name",
lookup_expr='icontains')
class MasterRunFilter(filters.FilterSet):
"""Filter master runs"""
date = filters.DateFilter(field_name='date', lookup_expr='gte')
comments = filters.CharFilter(lookup_expr='icontains')
search = filters.CharFilter(field_name='search',
method=master_run_filter_search)
class Meta:
model = MasterRun
fields = ['date', 'am', 'pm', 'comments']
class EventFilter(AutoSubsetFilterSet):
min_start = django_filters.DateFilter(field_name="start_date", lookup_expr='gte')
max_start = django_filters.DateFilter(field_name="start_date", lookup_expr='lte')
registration_status = django_filters.ChoiceFilter(
field_name="registration_status",
label="Registration status",
choices=(
('future', 'future'),
('open', 'open'),
('unknown', 'unknown'),
('closed', 'closed'),
),
)
realisation_status = django_filters.ChoiceFilter(
field_name="realisation_status",
label="Realisation status",
choices=(
('future', 'future'),
('past', 'past'),
('ongoing', 'ongoing'),
),
)
class Meta:
model = models.Event
fields = [
'type',
'min_start',
'max_start',
'costs',
'topics',
'keywords',
'prerequisites',
'elixirPlatforms',
'communities',
'organisedByTeams',
'organisedByOrganisations',
'sponsoredBy',
'is_draft',
'courseMode',
]
class VehicleFilter(filters.FilterSet):
id = filters.NumberFilter(name="id", label="ID", lookup_expr="exact")
id_range = filters.RangeFilter(name="id", label="ID Between")
owner = ListFilter(name="suppliervehicle__supplier_id", label="Owner name")
owner_null = filters.BooleanFilter(name="supplier", label="Is Owner Null", lookup_expr="isnull")
vehicle_number = filters.CharFilter(name="vehicle_number", label="Vehicle Number", lookup_expr='icontains')
vehicle_type = filters.NumberFilter(name="vehicle_type__id", label="Vehicle Type", lookup_expr='exact')
vehicle_type_null = filters.BooleanFilter(name="vehicle_type", label="Is Vehicle Type Null", lookup_expr="isnull")
vehicle_capacity = filters.NumberFilter(name="vehicle_capacity", label="vehicle Capacity", lookup_expr='icontains')
vehicle_capacity_range = filters.NumericRangeFilter(name="vehicle_capacity", label="vehicle Capacity")
chassis_number = filters.CharFilter(name="chassis_number", label="Chasis Number", lookup_expr='icontains')
chassis_number_null = filters.BooleanFilter(name="chassis_number", label="Is Chasis Number Null",
lookup_expr="isnull")
engine_number = filters.CharFilter(name="engine_number", label="Engine Number", lookup_expr='icontains')
engine_number_null = filters.BooleanFilter(name="engine_number", label="Is Engine Number Null",
lookup_expr="isnull")
registration_year = filters.DateFilter(name="registration_year", label="Registration year", lookup_expr='icontains')
registration_year_null = filters.BooleanFilter(name="registration_year", label="Is Registration Year Null",
lookup_expr="isnull")
registration_year_range = filters.DateFromToRangeFilter(name="registration_year", label="Registration Year range")
registration_validity = filters.DateFilter(name="registration_validity", label="Registration Validity",
lookup_expr='icontains')
registration_validity_range = filters.DateFromToRangeFilter(name="registration_validity",
label="Registration Validity Range")
gps_enabled = filters.BooleanFilter(name="gps_enabled", label="Is GPS Enable", lookup_expr="exact")
created_by = filters.CharFilter(name="created_by__username", label="Created By name", lookup_expr="icontains")
created_by_null = filters.BooleanFilter(name="created_by", label="Is Created By Null", lookup_expr="isnull")
created_on = filters.IsoDateTimeFilter(name="created_on", label="Created on")
created_between = filters.DateTimeFromToRangeFilter(name="created_on", label="Created Between")
class Meta:
model = Vehicle
fields = []
class ProjectFilter(filters.FilterSet):
client_name = filters.ModelChoiceFilter(field_name='client_name',
queryset=Client.objects.all())
date_line = filters.DateFilter(field_name='date_line')
is_active = filters.BooleanFilter(field_name='is_active')
budget = filters.NumericRangeFilter(field_name='budget')
status = filters.ChoiceFilter(field_name='pay_purpose',
choices=Evolution.task_status())
class Meta:
model = Project
fields = ['client_name', 'date_line', 'is_active', 'status', 'budget']
class EnergySupplierPriceFilter(filters.FilterSet):
start__gte = filters.DateFilter(
field_name='start',
lookup_expr='gte',
label='Contract start date must be after or equal to `X`')
start__lte = filters.DateFilter(
field_name='start',
lookup_expr='lte',
label='Contract start date must be before or equal to `X`')
end__gte = filters.DateFilter(
field_name='end',
lookup_expr='gte',
label='Contract end date must be after or equal to `X`')
end__lte = filters.DateFilter(
field_name='end',
lookup_expr='lte',
label='Contract end date must be before or equal to `X`')
class Meta:
model = EnergySupplierPrice
fields = []
class RecordListFilter(filters.FilterSet):
"""
Filters for RecordList view.
"""
category = NumberInFilter(field_name='category__pk', lookup_expr='in')
level = NumberInFilter(field_name='level__pk', lookup_expr='in')
type = NumberInFilter(field_name='type__pk', lookup_expr='in')
sport = NumberInFilter(field_name='type__sport__pk', lookup_expr='in')
historical = filters.BooleanFilter(field_name='historical', widget=BooleanWidget())
approved = filters.BooleanFilter(field_name='approved', widget=BooleanWidget())
start = filters.DateFilter(field_name='date_start', lookup_expr='gte')
end = filters.DateFilter(field_name='date_end', lookup_expr='lte')
o = filters.OrderingFilter(
fields=(
('type', 'type'),
('category', 'category'),
('approved', 'approved'),
('level', 'level'),
)
)
