check_sim_card_not_own.py 1.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354
  1. # -*- coding: utf-8 -*-
  2. #!/usr/bin/env python
  3. import threading
  4. import uuid,os
  5. import simplejson as json
  6. import sys,time
  7. import datetime
  8. PROJECT_ROOT = os.path.join(os.path.abspath(os.path.split(os.path.realpath(__file__))[0] + "/.."), '..')
  9. sys.path.insert(0, PROJECT_ROOT)
  10. os.environ.update({"DJANGO_SETTINGS_MODULE": "configs.production"})
  11. import django
  12. django.setup()
  13. from script.base import init_env, get_logger
  14. logger = get_logger(__name__)
  15. from apps.web.device.models import SIMCard,Device
  16. from apilib.utils_datetime import to_datetime
  17. from apps.web.dealer.models import DealerRechargeRecord
  18. from apps.web.constant import Const
  19. #sim卡的全同步脚本
  20. logger.info('start update_device_sim_info_from_jieyang ......... ')
  21. devs = Device.objects.all().only('iccid','ownerId','groupId')
  22. iccids = []
  23. for dev in devs:
  24. if dev.driverCode in ['9001001','900100']:
  25. continue
  26. if not dev.iccid or not dev.ownerId or not dev.groupId:
  27. continue
  28. iccids.append(str(dev.iccid))
  29. #把这个月充值的设备的状态统一改回来,否则用户充值了,系统还会让别人充值
  30. print('finish device iccds')
  31. simIccids = []
  32. sims = SIMCard.objects.all().only('iccid')
  33. for sim in sims:
  34. if not sim.iccid:
  35. continue
  36. simIccids.append(str(sim.iccid).lower())
  37. simIccids.append(str(sim.iccid).upper())
  38. print('finish sim iccids')
  39. fetalIccids = list(set(iccids) - set(simIccids))
  40. for f in fetalIccids:
  41. print f
  42. print 'all num',len(fetalIccids)
  43. logger.info('finished update_device_sim_info_from_jieyang')