lige.py 1.4 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344
  1. # -*- coding: utf-8 -*-
  2. # !/usr/bin/env python
  3. import os
  4. from base import init_env
  5. os.environ.setdefault("DJANGO_SETTINGS_MODULE", "configs.production")
  6. init_env(interactive = False)
  7. from apps.web.device.models import Group
  8. from apps.web.agent.models import Agent
  9. from apps.web.dealer.models import Dealer
  10. from apps.web.management.models import Manager
  11. from apps.web.user.models import MyUser, Card
  12. agent = Agent.objects(username = '15801750954').get()
  13. manager = Manager.objects(primeAgentId = str(agent.id)).get()
  14. agent_id_list = [str(agent.id) for agent in Agent.objects(managerId = str(manager.id)).all()]
  15. print('has {} agents.'.format(len(agent_id_list)))
  16. dealer_id_list = [str(dealer.id) for dealer in Dealer.objects(agentId__in = agent_id_list)]
  17. print('has {} dealers.'.format(len(dealer_id_list)))
  18. card_id_list1 = [str(card.id) for card in Card.objects(dealerId__in = dealer_id_list)]
  19. card_id_list2 = [str(card.id) for card in Card.objects(agentId__in = agent_id_list)]
  20. card_id_list = set(card_id_list1) | set(card_id_list2)
  21. print('has {} cards'.format(len(card_id_list)))
  22. group_id_list = [str(group.id) for group in Group.objects(ownerId__in = dealer_id_list).all()]
  23. print('has {} groups'.format(len(group_id_list)))
  24. users = [user for user in MyUser.objects(groupId__in = group_id_list, balance__gt = 0).all()]
  25. print('has {} users'.format(len(users)))
  26. for user in users: # type: MyUser
  27. print('{} has {}'.format(repr(user), user.balance))