models.py 5.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153
  1. # coding=utf-8
  2. import requests
  3. from django.db import transaction
  4. from django.db import models
  5. from django.utils import timezone
  6. from django.conf import settings
  7. from apps.images.models import Images
  8. from utils.wx.wechat import WeChat
  9. from utils.wx.WXBizDataCrypt import WXBizDataCrypt
  10. from utils.exceptions import CustomError
  11. from apps.foundation.models import Config
  12. from apps.account.models import User
  13. class Customer(models.Model):
  14. user = models.ForeignKey(settings.AUTH_USER_MODEL, editable=False, on_delete=models.PROTECT, verbose_name=u'用户')
  15. name = models.CharField(max_length=100, verbose_name=u"姓名")
  16. tel = models.CharField(max_length=50, verbose_name=u'电话')
  17. gender = models.PositiveSmallIntegerField(choices=settings.GENDER_CHOICES, verbose_name=u'性别', null=True)
  18. create_time = models.DateTimeField(verbose_name=u"添加时间", default=timezone.now, editable=False)
  19. face = models.ForeignKey(Images, verbose_name=u'头像', on_delete=models.PROTECT, null=True)
  20. class Meta:
  21. db_table = "customer"
  22. verbose_name = u"客户管理"
  23. ordering = ['-id']
  24. index_together = (
  25. 'name',
  26. 'tel',
  27. )
  28. default_permissions = ()
  29. @staticmethod
  30. def getOrRegister(user):
  31. customer = Customer.objects.filter(user=user).first()
  32. if customer:
  33. return customer
  34. with transaction.atomic():
  35. customer = Customer.objects.create(user=user, tel=user.username, name=user.username)
  36. return customer
  37. def setInfo(self, nickName, gender, avatarUrl):
  38. self.name = nickName
  39. if gender == 1:
  40. self.gender = settings.MALE
  41. elif gender == 2:
  42. self.gender = settings.FEMALE
  43. else:
  44. self.gender = settings.UNKNOW
  45. if self.face == None and avatarUrl != None:
  46. self.face = Images.downLoadFace(self, avatarUrl)
  47. self.save()
  48. class CustomerWechat(models.Model):
  49. customer = models.ForeignKey(Customer, verbose_name=u'客户', on_delete=models.PROTECT, editable=False, null=True)
  50. openid = models.CharField(max_length=512, verbose_name=u"openid")
  51. session_key = models.CharField(max_length=512, verbose_name=u'session_key',null=True)
  52. class Meta:
  53. db_table = 'customer_wechat'
  54. verbose_name = u'微信客户'
  55. unique_together = [
  56. ('openid')
  57. ]
  58. default_permissions = ()
  59. @staticmethod
  60. def login(code):
  61. secret = Config.getConfigValue(Config.KEY_WECHAT_SESSION_KEY)
  62. appid = Config.getConfigValue(Config.KEY_WECHAT_APPID)
  63. res = WeChat.code2Session(appid, secret, code)
  64. instance = CustomerWechat.objects.filter(openid=res['openid']).first()
  65. if not instance:
  66. instance = CustomerWechat.objects.create(
  67. openid=res['openid'],
  68. session_key=res['session_key']
  69. )
  70. else:
  71. instance.session_key = res['session_key']
  72. instance.save()
  73. return instance
  74. @staticmethod
  75. def bindWechat(appid, openid, phoneEncryptedData, phoneIv):
  76. customer_wechat = CustomerWechat.objects.filter(openid=openid).first()
  77. if not customer_wechat:
  78. raise CustomError(u'未找到相应的微信客户!')
  79. pc = WXBizDataCrypt(appid, customer_wechat.session_key)
  80. phon_data = pc.decrypt(phoneEncryptedData, phoneIv)
  81. tel = phon_data['purePhoneNumber']
  82. if customer_wechat.customer:
  83. if customer_wechat.customer.user.username != tel:
  84. raise CustomError(u'微信绑定的手机号与系统记录的不符!')
  85. else:
  86. return customer_wechat.customer
  87. customer = Customer.objects.filter(tel=tel).first()
  88. if not customer:
  89. Customer.objects.create(tel=tel, name=tel)
  90. user = User.objects.filter(username=tel).first()
  91. if not user:
  92. user = User.objects.create_customer(tel, password='')
  93. try:
  94. with transaction.atomic():
  95. customer = Customer.getOrRegister(user=user)
  96. except:
  97. raise CustomError(u'用户注册失败!')
  98. customer_wechat.customer = customer
  99. customer_wechat.save()
  100. return customer
  101. class CustomerVehicle(models.Model):
  102. customer = models.ForeignKey(Customer, verbose_name=u'客户', on_delete=models.PROTECT)
  103. name = models.CharField(max_length=100, verbose_name=u"姓名")
  104. tel = models.CharField(max_length=50, verbose_name=u'电话')
  105. vin = models.CharField(max_length=20)
  106. number = models.CharField(max_length=20)
  107. model = models.CharField(max_length=200)
  108. class Meta:
  109. db_table = 'customer_vehicle'
  110. verbose_name = u'客户车辆'
  111. ordering = ['-id']
  112. default_permissions = ()
  113. class CustomerAddress(models.Model):
  114. customer = models.ForeignKey(Customer, verbose_name=u'客户', on_delete=models.PROTECT)
  115. name = models.CharField(max_length=100, verbose_name=u"姓名")
  116. tel = models.CharField(max_length=50, verbose_name=u'电话')
  117. area = models.CharField(max_length=200, verbose_name=u"地区")
  118. addr = models.CharField(max_length=500, verbose_name=u"详细地址")
  119. is_default = models.BooleanField(verbose_name=u"默认", default=False)
  120. delete = models.BooleanField(verbose_name=u"删除", default=False)
  121. create_time = models.DateTimeField(verbose_name=u"添加时间", default=timezone.now, editable=False)
  122. class Meta:
  123. db_table = 'customer_address'
  124. verbose_name = u'客户地址'
  125. ordering = ['-id']
  126. default_permissions = ()