class BookingFilters(filters.FilterSet): lr_number = ListFilter(field_name='lr_numbers__id', label="Lr Number") shipment_date_between = filters.DateFromToRangeFilter( field_name="shipment_date", label="Shipment date Between", lookup_expr='range') charged_weight_range = filters.NumericRangeFilter( field_name="charged_weight", label="charged_weight_Range", lookup_expr='range') party_rate_range = filters.NumericRangeFilter(field_name="party_rate", label="party_rate_Range", lookup_expr='range') total_amount_to_company_range = filters.NumericRangeFilter( field_name="total_amount_to_company", label="total_amount_to_company_Range", lookup_expr='range') vehicle_id = ListFilter(field_name='vehicle_id', label='vehicle') source_office_id = ListFilter(field_name='source_office_id', label='Source Office') destination_office_id = ListFilter(field_name='destination_office_id', label='Destination Office') to_city_fk_id = ListFilter(field_name='to_city_fk_id', label='To City') from_city_fk_id = ListFilter(field_name='from_city_fk_id', label='From City') class Meta: model = ManualBooking fields = []
class PostFilter(filters.FilterSet): date__gte = filters.NumericRangeFilter(field_name="pub_date", lookup_expr='gte') date__lte = filters.NumericRangeFilter(field_name="pub_date", lookup_expr='lte') class Meta: model = Post
class IngredientRangeFilter(filters.FilterSet): min_number = filters.NumericRangeFilter(field_name="number", lookup_expr='gte') max_number = filters.NumericRangeFilter(field_name="number", lookup_expr='lte') class Meta: model = Ingredient fields = ['title']
class SucursalFilter(filters.FilterSet): latitud = filters.NumericRangeFilter(field_name='latitud', lookup_expr='range') longitud = filters.NumericRangeFilter(field_name='longitud', lookup_expr='range') class Meta: model = Sucursal fields = ('empresa', 'municipio', 'latitud', 'longitud')
class ContractRouteFilter(filters.FilterSet): id = filters.NumberFilter(name="id", label="ID", lookup_expr="exact") id_range = filters.RangeFilter(name="id", label="ID Between") source = filters.CharFilter(name="source__name", label="Source City name", lookup_expr="icontains") source_null = filters.BooleanFilter(name="source", label="Is Source name Null", lookup_expr='isnull') destination = filters.CharFilter(name="destination__name", label="Destination name", lookup_expr="icontains") destination_null = filters.BooleanFilter(name="destination", label="Is Destination name Null", lookup_expr="isnull") rate_type = filters.CharFilter(name="rate_type__name", label="Rate Type name", lookup_expr="icontains") rate_type_null = filters.BooleanFilter(name="rate_type", label="Is Rate Type name Null", lookup_expr="isnull") rate_range = filters.NumericRangeFilter(name="rate", label="Rate Range") created_on = filters.IsoDateTimeFilter(name="created_on", label="Created on") created_between = filters.DateTimeFromToRangeFilter( name="created_on", label="Created Between") class Meta: model = ContractRoute fields = []
class TipoColaFilter(filters.FilterSet): capacidad = filters.NumericRangeFilter(field_name='capacidad', lookup_expr='range') class Meta: model = TipoCola fields = ('empresa', 'capacidad')
class StudentFilter(filters.FilterSet): birthdate = filters.DateFromToRangeFilter() att_score = filters.NumericRangeFilter(lookup_expr='range') examins_score = filters.NumericRangeFilter(lookup_expr='range') spec_name = filters.CharFilter(method='filter_direction') colledge_name = filters.CharFilter(method='filter_colledge') prof_name = filters.CharFilter(method='filter_prof') def filter_direction(self, queryset, name, values): fil = Q() for value in values.split(','): for direction in DirectionModel.objects.filter( spec_name=value.strip()): fil |= Q(direction=direction) return queryset.filter(fil) def filter_colledge(self, queryset, name, values): fil = Q() for value in values.split(','): for direction in DirectionModel.objects.filter( colledge_name=value.strip()): fil |= Q(direction=direction) return queryset.filter(fil) def filter_prof(self, queryset, name, values): fil = Q() for value in values.split(','): for direction in DirectionModel.objects.filter( prof_name=value.strip()): fil |= Q(direction=direction) return queryset.filter(fil) o = filters.OrderingFilter(fields=( ('birthdate', 'birthdate'), ('att_score', 'att_score'), ('receipt_date', 'receipt_date'), ('current_curse', 'current_curse'), )) class Meta: model = StudentModel fields = [ 'birthdate', 'att_score', 'examins_score', 'is_disabled', 'is_orphan', 'is_served', 'needs_home', 'region', 'male', 'spec_name', 'colledge_name', 'prof_name' ]
class EventFilter(filters.FilterSet): datetime_after = filters.DateTimeFilter( field_name="datetime_created", lookup_expr='gte', label="After datetime (e.g. 2018-12-08T16:24:10)") datetime_before = filters.DateTimeFilter( field_name="datetime_created", lookup_expr='lte', label="Before datetime (e.g. 2018-12-08T16:24:10)") latitude = filters.NumericRangeFilter(field_name="latitude", widget=RangeWidget()) longitude = filters.NumericRangeFilter(field_name="longitude", widget=RangeWidget()) class Meta: model = Event fields = [ 'country_name', 'country_iso', 'latitude', 'longitude', 'city', 'datetime_before', 'datetime_after' ]
class PatientFilterSet(filters.FilterSet): source = filters.ChoiceFilter(choices=PatientRegistration.SourceChoices) disease_status = CareChoiceFilter(choice_dict=DISEASE_STATUS_DICT) facility = filters.UUIDFilter(field_name="facility__external_id") phone_number = filters.CharFilter(field_name="phone_number") allow_transfer = filters.BooleanFilter(field_name="allow_transfer") name = filters.CharFilter(field_name="name", lookup_expr="icontains") ip_no = filters.CharFilter(field_name="last_consultation__ip_no", lookup_expr="icontains") gender = filters.BooleanFilter(field_name="gender") age = filters.NumericRangeFilter(field_name="age") category = filters.ChoiceFilter(field_name="last_consultation__category", choices=CATEGORY_CHOICES)
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 UserFilter(filters.FilterSet): """User filter class.""" min_reputation = filters.NumericRangeFilter() class Meta: """Meta class.""" model = User fields = ( 'username', 'profile__verified', 'profile__born_date', # 'profile__profile_worker__reputation', )
class ProfessionalListFilterSet(filters.FilterSet): """The filter class for the professional list viewset class.""" pk_in = NumberInFilter(field_name="id", lookup_expr="in") experience = filters.NumericRangeFilter( field_name="experience", lookup_expr="range", ) class Meta: """The professional list filterset class serializer META class.""" model = Professional fields = ("pk_in", "subcategory", "subcategory__category", "level")
class ModelFilter(filters.FilterSet): vendor = filters.CharFilter(field_name='vendor', lookup_expr='icontains') model_number = filters.CharFilter(field_name='model_number', lookup_expr='icontains') height = filters.NumericRangeFilter(field_name='height', lookup_expr='range') color = filters.CharFilter(field_name='display_color', lookup_expr='iexact') network_ports_num = filters.NumericRangeFilter( field_name='network_ports_num', lookup_expr='range') power_ports = filters.NumericRangeFilter(field_name='power_ports', lookup_expr='range') cpu = filters.CharFilter(field_name='cpu', lookup_expr='icontains') memory = filters.NumericRangeFilter(field_name='memory', lookup_expr='range') storage = filters.CharFilter(field_name='storage', lookup_expr='icontains') comment = filters.CharFilter(field_name='comment', lookup_expr='icontains') class Meta: model = Model fields = [ 'vendor', 'model_number', 'height', 'color', 'network_ports_num', 'power_ports', 'cpu', 'memory', 'storage', 'comment' ]
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 SmeFilter(filters.FilterSet): id = filters.NumberFilter(name="id", label="ID", lookup_expr="exact") id_range = filters.RangeFilter(name="id", label="ID Between") name = filters.CharFilter(name="name__username", label="Sme name", lookup_expr='icontains') name_null = filters.BooleanFilter(name="name", label="Is Name Null", lookup_expr="isnull") company_name = filters.CharFilter(name="name__profile__name", label="Customer name", lookup_expr='icontains') email_tasks = filters.CharFilter(name='email_tasks__name', label="Name of Email Task", lookup_expr="icontains") company_code = filters.CharFilter(name='company_code', label="Company Code", lookup_expr="iexact") company_code_null = filters.BooleanFilter(name="company_code", label="Is Company Code Null", lookup_expr="isnull") latest_lr_serial_number = filters.NumberFilter( name="latest_lr_serial_number", label="Latest LR Serial Number") latest_lr_serial_number_between = filters.NumericRangeFilter( name="latest_lr_serial_number", label="Latest LR Serial Number Between") lr_format_type = filters.ChoiceFilter(name="lr_format_type", choices=LR_FORMAT_CHOICE) address = filters.CharFilter(name="address__line1", label="Sme address", lookup_expr='icontains') address_null = filters.BooleanFilter(name="address", label="Is Address Null", lookup_expr="isnull") customer_address = filters.CharFilter(name="customer_address", label="Customer Address") customer_address_null = filters.BooleanFilter( name="customer_address", label="Is Customer Address Null", lookup_expr="isnull") credit_period = filters.CharFilter(name="credit_period", label="Credit Period", lookup_expr='icontains') credit_period_null = filters.BooleanFilter(name="credit_period", label="Credit Period", lookup_expr="isnull") aaho_poc = ListFilter(name="aaho_poc__id", label="Aaho POC") aaho_poc_null = filters.BooleanFilter(name="aaho_poc", label="Is Aaho POC Null", lookup_expr="isnull") city = filters.CharFilter(name="city__name", label="City Name", lookup_expr='icontains') city_null = filters.BooleanFilter(name="city", label="Is City Null", lookup_expr="isnull") pin = filters.CharFilter(name="pin", label="PIN", lookup_expr='icontains') pin_null = filters.BooleanFilter(name="pin", label="Is PIN Null", lookup_expr="isnull") gstin = filters.CharFilter(name="gstin", label="GSTIN", lookup_expr='icontains') gstin_null = filters.BooleanFilter(name="gstin", label="Is GSTIN Null", lookup_expr="isnull") is_gst_applicable = filters.ChoiceFilter(name="is_gst_applicable", label="Is GST Applicable", choices=IS_GST_APPLICABLE_CHOICE) id_proof = filters.CharFilter(name="id_proof", label="ID Proof", lookup_expr='icontains') id_proof_null = filters.BooleanFilter(name="id_proof", label="Is ID Proof Null", lookup_expr="isnull") account_details_null = filters.BooleanFilter( name="account_details", label="Is Account Details Null", lookup_expr="isnull") account_number = filters.CharFilter(name="account_details__acount_number", label="Account Number", lookup_expr='exact') bank_name = filters.CharFilter(name="account_details__bank", label="Bank Name", lookup_expr='icontains') ifsc = filters.CharFilter(name="account_details__ifsc", label="IFSC Code", lookup_expr='icontains') service_tax_number = filters.CharFilter( name="taxation_details__service_tax_number", label="Service Tax Number", lookup_expr='exact') taxation_details_null = filters.BooleanFilter( name="taxation_details", label="Is Taxation Details Null", lookup_expr="isnull") status = filters.ChoiceFilter(name="status", choices=(('active', 'active'), ('inactive', 'inactive')), label="Status") created_on = filters.IsoDateTimeFilter(name="created_on", label="Created on") created_between = filters.DateTimeFromToRangeFilter( name="created_on", label="Created Between") # Reverse relations cheque_number = filters.CharFilter(name="cheque_files__cheque_number", label="Cheque Files Cheque Number", lookup_expr="icontains") cheque_date = filters.DateFilter(name="cheque_files__cheque_date", label="Cheque Files Cheque Date") serial = filters.CharFilter(name="cheque_files__serial", label="Cheque Files Serial", lookup_expr="icontains") aaho_office = ListFilter(field_name='aaho_office_id', label="Aaho Office") aaho_office_null = filters.NumberFilter(field_name='aaho_office', label="Aaho Office", lookup_expr='isnull') class Meta: model = Sme fields = []
class ChequeFileFilter(filters.FilterSet): id = filters.NumberFilter(name="id", label="ID", lookup_expr="exact") id_range = filters.RangeFilter(name="id", label="ID Between") uploaded_by = filters.CharFilter(name="uploaded_by__username", label="Uploaded By name", lookup_expr="icontains") uploaded_by_null = filters.BooleanFilter(name="uploaded_by", label="Is Uploaded By Null", lookup_expr="isnull") resolved_by = filters.CharFilter(name="resolved_by__username", label="Resolved By name", lookup_expr="icontains") resolved_by_null = filters.BooleanFilter(name="resolved_by", label="Is Resolved By Null", lookup_expr="isnull") customer_name = filters.CharFilter(name="customer_name", label="Customer Name", lookup_expr="icontains") customer_name_null = filters.BooleanFilter(name="customer_name", label="Is Customer Name Null", lookup_expr="isnull") customer_null = filters.BooleanFilter(name="customer", label="Is Customer Null", lookup_expr="isnull") customer = filters.CharFilter(name="customer__name__username", label="Customer", lookup_expr="icontains") amount = filters.NumberFilter(name="amount", label="Amount", lookup_expr="exact") amount_between = filters.NumericRangeFilter(name="amount", label="Amount Range") cheque_number_null = filters.BooleanFilter(name="cheque_number", label="Is Cheque Number Null", lookup_expr="isnull") cheque_number = filters.CharFilter(name="cheque_number", label="Cheque Number", lookup_expr="icontains") cheque_date_null = filters.BooleanFilter(name="cheque_date", label="Is Cheque Date Null", lookup_expr="isnull") cheque_date = filters.DateFilter(name="cheque_date", label="Cheque Date ") cheque_date_between = filters.DateTimeFromToRangeFilter( name="cheque_date", label="Cheque Date Between") remarks = filters.CharFilter(name="remarks", label="Remarks", lookup_expr='icontains') remarks_null = filters.BooleanFilter(name="remarks", label="Is Remarks Null", lookup_expr="isnull") s3_upload = filters.CharFilter(name="s3_upload__filename", label="S3 Upload Filename", lookup_expr='icontains') s3_upload_null = filters.BooleanFilter(name="s3_upload", label="Is S3 Upload", lookup_expr="isnull") serial = filters.CharFilter(name="serial", label="Serial Url", lookup_expr='icontains') resolved = filters.BooleanFilter(name="resolved", label="Resolved", lookup_expr='exact') is_valid = filters.BooleanFilter(name="is_valid", label="Is Valid", lookup_expr='exact') resolved_datetime = filters.IsoDateTimeFilter(name="resolved_datetime", label="resolved datetime") resolved_datetime_between = filters.DateTimeFromToRangeFilter( name="resolved_datetime", label="resolved Datetime Between") 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 = ChequeFile fields = []
class RequirementFilter(filters.FilterSet): REQ_STATUS = ( ('open', 'Open'), ('cancelled', 'Cancelled'), ('fulfilled', 'Fulfilled'), ('unverified', 'Unverified'), ('lapsed', 'Lapsed'), ) id = filters.NumberFilter(name="id", label="ID", lookup_expr="exact") id_range = filters.RangeFilter(name="id", label="ID Between") client = filters.CharFilter(name="client__name__username", label=" Client", lookup_expr='icontains') client_null = filters.BooleanFilter(name="client", label="Is Client Null", lookup_expr="isnull") from_shipment_date = filters.DateFilter(field_name="from_shipment_date", label="from_shipment_date") from_shipment_date_between = filters.DateFromToRangeFilter(field_name="from_shipment_date", label="from_shipment_date Between") from_shipment_date_null = filters.BooleanFilter(field_name="from_shipment_date", label="Is from_shipment_date Null", lookup_expr="isnull") to_shipment_date = filters.DateFilter(field_name="to_shipment_date", label="to_shipment_date") to_shipment_date_between = filters.DateFromToRangeFilter(field_name="to_shipment_date", label="to_shipment_date Between") to_shipment_date_null = filters.BooleanFilter(field_name="to_shipment_date", label="Is to_shipment_date Null", lookup_expr="isnull") from_city = filters.CharFilter(field_name="from_city__name", label="From City", lookup_expr="icontains") from_city_null = filters.BooleanFilter(field_name="from_city", label="Is From City Null", lookup_expr="isnull") to_city = filters.CharFilter(field_name="to_city__name", label="to_city", lookup_expr="icontains") to_city_null = filters.BooleanFilter(field_name="to_city", label="Is to_city Null", lookup_expr="isnull") aaho_office = filters.CharFilter(name="aaho_office__branch_name", label="Aaho Office", lookup_expr='icontains') aaho_office_id = filters.NumberFilter(name="aaho_office__id", label="Aaho Office ID", lookup_expr='exact') aaho_office_null = filters.BooleanFilter(name="aaho_office", label="Is Aaho Office Null", lookup_expr="isnull") tonnage = filters.NumberFilter(field_name="tonnage", label="tonnage") tonnage_range = filters.NumericRangeFilter(field_name="tonnage", label="tonnage_Range") tonnage_null = filters.BooleanFilter(field_name="tonnage", label="Is tonnage Null", lookup_expr="isnull") no_of_vehicles = filters.NumberFilter(field_name="no_of_vehicles", label="no_of_vehicles") no_of_vehicles_range = filters.NumericRangeFilter(field_name="no_of_vehicles", label="no_of_vehicles_Range") no_of_vehicles_null = filters.BooleanFilter(field_name="no_of_vehicles", label="Is no_of_vehicles Null", lookup_expr="isnull") rate = filters.NumberFilter(field_name="rate", label="rate") rate_range = filters.NumericRangeFilter(field_name="rate", label="rate_Range") rate_null = filters.BooleanFilter(field_name="rate", label="Is rate Null", lookup_expr="isnull") material = filters.CharFilter(name="material", label="Material", lookup_expr='icontains') material_null = filters.BooleanFilter(name="material", label="Is Material Null", lookup_expr="isnull") type_of_vehicle = filters.CharFilter(name="type_of_vehicle__vehicle_type", label="Vehicle Type", lookup_expr='icontains') type_of_vehicle_null = filters.BooleanFilter(name="type_of_vehicle", label="Is Vehicle Type Null", lookup_expr="isnull") status = filters.ChoiceFilter(name="req_status", label="Req Status", choices=REQ_STATUS) req_status_null = filters.BooleanFilter(name="req_status", label="Is Req Status Null", lookup_expr="isnull") 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(field_name="created_on", label="Created Between") class Meta: model = Requirement fields = []
class OwnerVehicleFilter(filters.FilterSet): vehicle_status_choice = (('free', 'FREE'), ('in_transit', 'In Transit'), ('to_pickup', 'TO be Pick Up'), ('delivery', 'To be Delivered')) body_type_choice = ( ('open', 'Open'), ('closed', 'Closed'), ('semi', 'Semi'), ('half', 'Half'), ('containerized', 'Containerized'), ) id = filters.NumberFilter(name="id", label="ID", lookup_expr="exact") id_range = filters.RangeFilter(name="id", label="ID Between") owner = ListFilter(name="owner__id", label="Owner name") owner_null = filters.BooleanFilter(name="owner", label="Is Owner Null", lookup_expr="isnull") driver = ListFilter(name="driver__id", label="Driver name") driver_null = filters.BooleanFilter(name="driver", label="Is Driver Null", lookup_expr="isnull") vehicle_number = filters.CharFilter(name="vehicle_number", label="Vehicle Number", lookup_expr='icontains') route_source = filters.CharFilter(name="route__source__name", label="Route Source", lookup_expr='icontains') route_destination = filters.CharFilter(name="route__destination__name", label="Route Destination", lookup_expr='icontains') route_null = filters.BooleanFilter(name="route", label="Is Route Null", lookup_expr="isnull") rc_number = filters.CharFilter(name="rc_number", label="RC Number", lookup_expr='icontains') rc_number_null = filters.BooleanFilter(name="rc_number", label="Is RC Number Null", lookup_expr="isnull") permit = filters.CharFilter(name="permit", label="Permit", lookup_expr='icontains') permit_null = filters.BooleanFilter(name="permit", label="Is Permit Null", lookup_expr="isnull") permit_validity = filters.DateFilter(name="permit_validity", label="Permit Validity", lookup_expr='icontains') permit_validity_null = filters.BooleanFilter( name="permit_validity", label="Is Permit Validity Null", lookup_expr="isnull") permit_type = filters.CharFilter(name="permit_type", label="Permit Type", lookup_expr='icontains') permit_type_null = filters.BooleanFilter(name="permit_type", label="Is Permit Type Null", lookup_expr="isnull") 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") body_type = filters.ChoiceFilter(name="body_type", label="Body Type", choices=body_type_choice) body_type_null = filters.BooleanFilter(name="body_type", label="Is Body Type Null", lookup_expr="isnull") vehicle_model = filters.CharFilter(name="vehicle_model", label="Vehicle Model", lookup_expr='icontains') 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") insurer = filters.CharFilter(name="insurer", label="Insurer", lookup_expr='icontains') insurance_number = filters.CharFilter(name="insurance_number", label="Insurance Number", lookup_expr='icontains') insurance_validity = filters.DateFilter(name="insurance_validity", label="Insurance Validity", lookup_expr='icontains') insurance_validity_null = filters.BooleanFilter( name="insurance_validity", label="Is Insurance Validity 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") fitness_certificate_number = filters.CharFilter( name="fitness_certificate_number", label="Fitness Certificate Number", lookup_expr='icontains') fitness_certificate_number_null = filters.BooleanFilter( name="fitness_certificate_number", label="Is Fitness Certificate Number Null", lookup_expr="isnull") fitness_certificate_issued_on = filters.DateFilter( name="fitness_certificate_issued_on", label="Fitness Certificate issued on", lookup_expr='icontains') fitness_certificate_issued_on_range = filters.DateFromToRangeFilter( name="fitness_certificate_issued_on", label="Fitness Certificate issued on Range") puc_certificate_number = filters.CharFilter( name="puc_certificate_number", label="PUC Certificate Number Null", lookup_expr='icontains') puc_certificate_number_null = filters.BooleanFilter( name="puc_certificate_number", label="Is PUC Certificate Number Null", lookup_expr="isnull") puc_certificate_issued_on = filters.DateFilter( name="puc_certificate_issued_on", label="PUC Certificate issued on", lookup_expr='icontains') puc_certificate_issued_on_range = filters.DateFromToRangeFilter( name="puc_certificate_issued_on", label="PUC Certificate issued on Range") status = filters.ChoiceFilter(name="status", label="Status", choices=vehicle_status_choice) status_null = filters.BooleanFilter(name="status", label="Is Status Null", lookup_expr="isnull") 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") # Reverse relations serial = filters.CharFilter(name="vehicle_files__serial", label="Vehicle Files Serial", lookup_expr="icontains") verified = filters.BooleanFilter(name="vehicle_files__verified", label="Vehicle Files Verified", lookup_expr="exact") class Meta: model = Vehicle fields = []