Advertisement
Guest User

Untitled

a guest
Mar 10th, 2020
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.48 KB | None | 0 0
  1. self.get_queryset() \
  2.             .annotate(created_at_date=TruncDate('created_at')) \
  3.             .values('created_at_date') \
  4.             .order_by('created_at_date') \
  5.             .annotate(
  6.             income=ExpressionWrapper((F('items__price') - F('items__product__cost_price'))
  7.                                      * F('items__total_quantity'),
  8.                                      output_field=models.DecimalField()),
  9.             total_quantity=Sum('items__total_quantity')) \
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement