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
