def search_by_address_origin(self, query): if is_valid_queryparams(query): filters = (Q(address_origin__address__icontains=query) | Q(address_origin__district__icontains=query) | Q(address_origin__full_name__icontains=query) | Q(address_origin__cell_phone__icontains=query)) return self.filter(filters) return self
def search_driver(self, query): if is_valid_queryparams(query): filters = (Q(driver__dni__icontains=query) | Q(driver__code__icontains=query) | Q(driver__first_name__icontains=query) | Q(driver__last_name__icontains=query)) return self.filter(filters) return self
def search_driver(self, query): if is_valid_queryparams(query): filters = (Q(driver__dni__icontains=query) | Q(driver__code__icontains=query) | Q(full_name__icontains=query)) return self.annotate( full_name=Concat('driver__first_name', Value(' '), 'driver__last_name'), ).filter(filters) return self
def search_detail_and_client(self, query): if is_valid_queryparams(query): filters = Q(tracking_code__icontains=query) | Q( full_name__icontains=query) | Q( client__cell_phone__icontains=query) return self.annotate( full_name=Concat('client__first_name', Value(' '), 'client__last_name'), ).filter(filters, ) return self
def search(self, query): if is_valid_queryparams(query): filters = (Q(first_name__icontains=query) | Q(last_name__icontains=query) | Q(cell_phone__icontains=query) | Q(driver_code__icontains=query)) return self.filter(filters) return self
def search_type_ticket(self, query): if is_valid_queryparams(query): return self.filter(order__type_ticket=query) return self
def search_date_to(self, query_date): if is_valid_queryparams(query_date): return self.filter(created_at__lt=query_date) return self
def search_by_date(self, query): if is_valid_queryparams(query): return self.filter(created_at__date=query) return self
def search_by_status(self, query): if is_valid_queryparams(query): return self.filter(status=query) return self