CloudTest.py 5.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150
  1. # -*- coding: utf-8 -*-
  2. """
  3. @Time : 2020/12/16 8:44
  4. @Auth : Locky
  5. @File :CloudTest.py
  6. @IDE :PyCharm
  7. """
  8. import time
  9. from django.views.generic.base import View
  10. from Model.models import Device_User, Device_Info, Order_Model, UID_Bucket, Store_Meal, StsCrdModel
  11. from Object.ResponseObject import ResponseObject
  12. from Object.TokenObject import TokenObject
  13. class cloudTestView(View):
  14. def get(self, request, *args, **kwargs):
  15. request.encoding = 'utf-8'
  16. operation = kwargs.get('operation')
  17. return self.validation(request.GET, request, operation)
  18. def post(self, request, *args, **kwargs):
  19. request.encoding = 'utf-8'
  20. operation = kwargs.get('operation')
  21. return self.validation(request.POST, request, operation)
  22. def validation(self, request_dict, request, operation):
  23. response = ResponseObject()
  24. if operation is None:
  25. return response.json(444, 'error path')
  26. else:
  27. token = request_dict.get('token', None)
  28. # 设备主键uid
  29. tko = TokenObject(token)
  30. response.lang = tko.lang
  31. if tko.code != 0:
  32. return response.json(tko.code)
  33. userID = tko.userID
  34. if operation == 'deviceTransfer':
  35. return self.deviceTransfer(request_dict, response)
  36. elif operation == 'mealTransfer':
  37. return self.mealTransfer(request_dict, response)
  38. def deviceTransfer(self, request_dict, response):
  39. # 设备转移
  40. oldUserID = request_dict.get("oldUserID", None)
  41. username = request_dict.get("username", None)
  42. uid = request_dict.get('uid', None)
  43. try:
  44. # 查询设备是否存在
  45. deviceInfo_qs = Device_Info.objects.filter(userID_id=oldUserID, UID=uid, isExist=1)
  46. if deviceInfo_qs[0]:
  47. deviceUser_qs = Device_User.objects.filter(username=username).values('userID')
  48. userID = deviceUser_qs[0]['userID']
  49. # 判断该用户的userID是否跟转移的一样
  50. if userID == oldUserID:
  51. return response.json(10008)
  52. # 更新设备信息
  53. else:
  54. deviceInfo_qs.update(userID=userID)
  55. except Exception as e:
  56. # print(e)
  57. return response.json(500, repr(e))
  58. else:
  59. return response.json(0)
  60. def mealTransfer(self, request_dict, response):
  61. # 云存套餐转移
  62. username = request_dict.get("username", None)
  63. old_uid = request_dict.get("old_uid", None)
  64. new_uid = request_dict.get("new_uid", None)
  65. try:
  66. # 查询两个UID是否在同一账号下
  67. deviceUser_qs = Device_User.objects.filter(username=username).values('userID')
  68. userID = deviceUser_qs[0]['userID']
  69. old_deviceInfo_qs = Device_Info.objects.filter(userID_id=userID,UID=old_uid).values('isExist','Online')
  70. new_deviceInfo_qs = Device_Info.objects.filter(userID_id=userID, UID=new_uid).values('isExist')
  71. if not(old_deviceInfo_qs.exists() and new_deviceInfo_qs.exists()):
  72. return response.json(10009)
  73. # 转出设备已删除或不在线才能进行转移
  74. old_isExist = old_deviceInfo_qs[0]['isExist']
  75. old_Online = old_deviceInfo_qs[0]['Online']
  76. new_isExist = new_deviceInfo_qs[0]['isExist']
  77. if old_isExist or old_Online or not new_isExist:
  78. return response.json(10010)
  79. # 确认转入设备套餐是否过期,通过orders表的userID_id和UID确定uid_bucket_id
  80. new_orderModel_qs = Order_Model.objects.filter(userID_id=userID, UID=new_uid).values('uid_bucket_id')
  81. new_uid_bucket_id = new_orderModel_qs[0]['uid_bucket_id']
  82. # 转入设备开通过套餐且套餐已过期才能进行转移,通过vod_uid_bucket表关联的id(关联orders表的uid_bucket_id)确定过期时间endTime
  83. new_UIDbucket_qs = UID_Bucket.objects.filter(id=new_uid_bucket_id).values('endTime')
  84. if not new_UIDbucket_qs.exists():
  85. return response.json(10011)
  86. nowTime = int(time.time())
  87. new_endTime = new_UIDbucket_qs[0]['endTime']
  88. if new_endTime > nowTime:
  89. return response.json(10012)
  90. # 只能转移购买的的套餐(支付类型为体验套餐和激活码不能转移,即pay_type不能为10,11)
  91. old_orderModel_qs = Order_Model.objects.filter(userID_id=userID,UID=old_uid).values('payType','uid_bucket_id')
  92. payType = old_orderModel_qs[0]['payType']
  93. old_uid_bucket_id = old_orderModel_qs[0]['uid_bucket_id']
  94. if payType == 10 or payType == 11:
  95. return response.json(10013)
  96. # 套餐转移,转出设备服务显示过期,转入设备套餐类型和过期时间更新
  97. # 更新转出设备套餐过期时间
  98. old_uidBucket_qs = UID_Bucket.objects.filter(id=old_uid_bucket_id).values('bucket_id','endTime')
  99. old_bucket_id = old_uidBucket_qs[0]['bucket_id']
  100. old_endTime = old_uidBucket_qs[0]['endTime']
  101. UID_Bucket.objects.filter(id=old_uid_bucket_id).update(endTime=0)
  102. # 更新转入设备套餐类型和过期时间
  103. new_UIDbucket_qs.update(bucket_id=old_bucket_id,endTime=old_endTime)
  104. # 删除转出设备stscrd表关联数据
  105. StsCrdModel.objects.filter(uid=old_uid).delete()
  106. except Exception as e:
  107. print(e)
  108. return response.json(500, repr(e))
  109. else:
  110. return response.json(0)