Skip to content

Instantly share code, notes, and snippets.

@souldeux
Last active August 29, 2015 14:13
Show Gist options
  • Save souldeux/bdc4e2e194e958ad96eb to your computer and use it in GitHub Desktop.
Save souldeux/bdc4e2e194e958ad96eb to your computer and use it in GitHub Desktop.
def get_queryset(self):
min_amount = self.request.GET.get('min_amount', None)
max_amount = self.request.GET.get('max_amount', None)
dc_contains = self.request.GET.get('dc', None)
min_date = self.request.GET.get('min_date', None)
max_date = self.request.GET.get('max_date', None)
expenses = expense.objects.all()
if min_amount:
expenses = expenses.filter(amount__gte=min_amount)
if max_amount:
expenses = expenses.filter(amount__lte=max_amount)
if dc_contains:
expenses = expenses.filter(Q(description__icontains=dc_contains) | Q(comment__icontains=dc_contains))
if min_date:
expenses = expenses.filter(date__gte=min_date)
if max_date:
expenses = expenses.filter(date__lte=max_date)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment