Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2020
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. result = list(transactions.values('customer').annotate(total=Sum('total'), gems=ArrayAgg('item', distinct=True)).order_by('-total')[:5])
  2.  
  3. for item in result:
  4. sorted_gems = []
  5.  
  6. for gem in item['gems']:
  7. for other in result:
  8. if other != item:
  9. if gem in other['gems']:
  10. sorted_gems.append(gem)
  11. break
  12.  
  13. item['gems'] = sorted_gems
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement