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'), ) )