class GalleryFilterSet(FilterSet):
date_after = DateFilter("taken_at", lookup_expr="gte")
date_before = DateFilter("taken_at", lookup_expr="lte")
class Meta:
model = Gallery
fields = ("date_after", "date_before", "event")
class GalleryFilterSet(FilterSet):
date_after = DateFilter('taken_at', lookup_expr='gte')
date_before = DateFilter('taken_at', lookup_expr='lte')
class Meta:
model = Gallery
fields = ('date_after', 'date_before', 'event')
class OrderFilter(FilterSet):
start_date = DateFilter(field_name="date_created", lookup_expr='gte')
end_date = DateFilter(field_name="date_created", lookup_expr='lte')
class Meta:
model = Order
fields = '__all__'
exclude = ['customer', 'date_created']
class OrderFilter(django_filters.FilterSet):
start_date = DateFilter(field_name='date_created', lookup_expr='gte')
end_date = DateFilter(field_name='date_created', lookup_expr='lte')
class Meta:
model = Order
fields = '__all__'
exclude = ['student', 'date_created']
class OrderFilter(django_filters.FilterSet):
start_date = DateFilter(field_name="date_created", lookup_expr='gte')
end_date = DateFilter(field_name="date_created", lookup_expr='lte')
note = CharFilter(field_name="note", lookup_expr='icontains')
class Meta:
model = Order
fields = '__all__'
exclude = ['customer', 'date_created']
class BalanceFilter(django_filters.FilterSet):
start_date1 = DateFilter(field_name="Date", lookup_expr='gte')
end_date1 = DateFilter(field_name="Date", lookup_expr='lte')
class Meta:
model = Payment
fields = ['supplierName', 'Date','start_date1','end_date1']
class IncomeFilter(django_filters.FilterSet):
greater_than = DateFilter(field_name="date_received", lookup_expr='gte', widget=DateInput(attrs={'type': 'date'}))
less_than = DateFilter(field_name="date_received", lookup_expr='lte', widget=DateInput(attrs={'type': 'date'}))
class Meta:
model = Income
fields = {
'source_name': ['icontains'],
}
class attendenceFilter(django_filters.FilterSet):
start_date = DateFilter(field_name="date_created", lookup_expr='gte')
end_date = DateFilter(field_name="date_created", lookup_expr='lte')
class Meta:
model = attendence
fields = '__all__'
exclude = ['comments']
class OrderFilter(django_filters.FilterSet):
start_date = DateFilter(field_name="date_created", lookup_expr="gte")
end_date = DateFilter(field_name="date_created", lookup_expr="lte")
class Meta:
model = Order
fields = '__all__'
exclude = ['customer', 'date_created']
class OrderFilter(django_filters.FilterSet):
startdate = DateFilter(field_name='date_posted', lookup_expr='gte')
enddate = DateFilter(field_name='date_posted', lookup_expr='lte')
fac_fname = CharFilter(field_name='fac_fname', lookup_expr='icontains')
department = CharFilter(field_name='department', lookup_expr='icontains')
class Meta:
model = Faculty
fields = ('fac_fname','department','faculty_id')
class EventsFilterSet(FilterSet):
date_after = DateFilter('start_time', lookup_expr='gte')
date_before = DateFilter('start_time', lookup_expr='lte')
company = CharFilter('company')
class Meta:
model = Event
fields = ('date_after', 'date_before')
class DocDateFilter(FilterSet):
start_date = DateFilter(name="date", lookup_expr='gte')
end_date = DateFilter(name="date", lookup_expr='lte')
q = SearchQueryFilter()
class Meta:
model = Document
fields = ['id', 'date', 'media_type', 'q']
class ProblemFilter(django_filters.FilterSet):
start_date = DateFilter(field_name="date_created", lookup_expr="gte")
end_date = DateFilter(field_name="date_created", lookup_expr="lte")
class Meta:
model = Solutions
fields = '__all__'
exclude = ['Patients', 'date_created', 'Add_solution']
class OrderFilter(django_filters.FilterSet):
start_date = DateFilter(field_name="date", lookup_expr='gte')
end_date = DateFilter(field_name="date", lookup_expr='lte')
class Meta:
model = Booking
fields = ['service', 'time', 'status']
exclude = ['customer']
class productfilter(django_filters.FilterSet):
start_date = DateFilter(field_name='date_created', lookup_expr='gte')
end_date = DateFilter(field_name='date_created', lookup_expr='lte')
class Meta:
model = Product
fields = '__all__'
exclude = ['date_created', 'discription', 'tags']
class ProductDiscountFilter(filters.FilterSet):
product__name = CharFilter(lookup_expr='icontains')
fdate = DateFilter(widget=TextInput(attrs={'type': 'date'}))
ldate = DateFilter(widget=TextInput(attrs={'type': 'date'}))
class Meta:
model = ProductDiscount
fields = ('product__name', 'price', 'fdate', 'ldate')
class FilterServeds(django_filters.FilterSet):
startDate =DateFilter(field_name ='Date',lookup_expr='gte')
endDate =DateFilter(field_name ='Date',lookup_expr='lte')
#endDate =CharFilter(field_name ='note',lookup_expr='icontain')
class Meta:
model = Reports
fields= 'Product',
exclude = ['date_created']
class Meta:
start_date = DateFilter(field_name="date_created", lookup_expr='gte')
end_date = DateFilter(field_name="date_created", lookup_expr='lte')
note = CharFilter(field_name='note', lookup_expr='icontains')
model = Order
fields = '__all__'
exclude = ['customer', 'date_created']
class TransactionFilter(django_filters.FilterSet):
date_from = DateFilter(field_name="transaction_date", lookup_expr="gte")
date_to = DateFilter(field_name="transaction_date", lookup_expr='lte')
#rental_unit = RentalUnit.objects.filter(owner = self.request.user)
class Meta:
model = Transaction
fields = []
class BorrowFilter(django_filters.FilterSet):
start_date = DateFilter(field_name="borrowedDate", lookup_expr='gte')
end_date = DateFilter(field_name="borrowedDate", lookup_expr='lte')
class Meta:
model = Borrowed
fields = '__all__'
exclude = ['user', 'dueDate', 'borrowedDate']
class paymentFilter(django_filters.FilterSet):
Comment = django_filters.CharFilter(lookup_expr='icontains')
start_date = DateFilter(field_name="Date", lookup_expr='gte')
end_date = DateFilter(field_name="Date", lookup_expr='lte')
class Meta:
model = Payment
fields = ['supplierName', 'paidIn', 'Date', 'Comment','credit','start_date','end_date',]
class EventsFilterSet(FilterSet):
date_after = DateFilter("start_time", lookup_expr="gte")
date_before = DateFilter("start_time", lookup_expr="lte")
company = CharFilter("company")
class Meta:
model = Event
fields = ("date_after", "date_before")
class TrnFilter(django_filters.FilterSet):
start_date = DateFilter(field_name='date',lookup_expr="gte")
end_date = DateFilter(field_name="date",lookup_expr="lte")
name = CharFilter(field_name="name",lookup_expr="icontains")
class Meta:
model = Trasaction
fields = "__all__"
exclude =['date','profile ']
class DogFilter(django_filters.FilterSet):
start_date = DateFilter(field_name="birth_date", lookup_expr='gte')
end_date = DateFilter(field_name="birth_date", lookup_expr='lte')
body = CharFilter(field_name='body', lookup_expr='icontains')
class Meta:
model = Dog
fields = '__all__'
exclude = ['image', 'body', 'trekkhundreg']
class OrderFilter(django_filters.FilterSet):
start_date = DateFilter(field_name='date_created', lookup_expr='gte')
end_date = DateFilter(field_name='date_created', lookup_expr='lte')
note = CharFilter(field_name='note', lookup_expr='icontains')
class Meta:
model = Order
fields = ['product', 'status']
class CashFlowFilter(django_filters.FilterSet):
start_date = DateFilter(field_name="date",lookup_expr='gte')
end_date = DateFilter(field_name="date", lookup_expr='lte')
desc = CharFilter(field_name='desc',lookup_expr='icontains')
class Meta:
model = cashFlow
fields = '__all__'
exclude = ['date', 'saldoCredit', 'saldoDebit']
class TransactionFilter(django_filters.FilterSet):
Date_start = DateFilter(field_name="date", lookup_expr='gte')
Date_end = DateFilter(field_name="date", lookup_expr='lte')
class Meta:
model = BuySellTransaction
fields = ['property', 'buyer', 'owner']
widgets = {'date': DateInput()}
class PermissionFilter(django_filters.FilterSet):
start_date = DateFilter(field_name='date_created', lookup_expr='gte')
end_date = DateFilter(field_name='date_created', lookup_expr='lte')
class Meta:
model = Permission
fields = '__all__'
exclude = ['customer', 'date_created']
class RecordFilter(FilterSet):
start_date = DateFilter(field_name='time', lookup_expr='gt')
end_date = DateFilter(field_name='time', lookup_expr='lt')
time_range = DateRangeFilter(field_name='time')
class Meta:
model = Record
fields = ('time', )
class BudgetFilter(FilterSet):
budget_period_start = DateFilter(lookup_type='gte', name='period_start')
budget_period_end = DateFilter(lookup_type='lte', name='period_end')
class Meta:
model = Budget
