UnicomComboController.py 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704
  1. # -*- encoding: utf-8 -*-
  2. """
  3. @File : UnicomComboController.py
  4. @Time : 2022/6/23 9:18
  5. @Author : stephen
  6. @Email : zhangdongming@asj6.wecom.work
  7. @Software: PyCharm
  8. """
  9. import datetime
  10. import json
  11. import logging
  12. import time
  13. import traceback
  14. from decimal import Decimal
  15. from django.db import transaction
  16. from django.http import HttpResponse, JsonResponse
  17. from django.views.generic.base import View
  18. from Model.models import UnicomDeviceInfo, UnicomCombo, Pay_Type, Order_Model, Store_Meal, AiStoreMeal, \
  19. UnicomComboOrderInfo, UnicomComboExperienceHistory
  20. from Object.ResponseObject import ResponseObject
  21. from Object.TokenObject import TokenObject
  22. from Object.UnicomObject import UnicomObjeect
  23. from Object.utils import LocalDateTimeUtil
  24. from Object.utils.PayUtil import PayService
  25. from Service.CommonService import CommonService
  26. class UnicomComboView(View):
  27. def get(self, request, *args, **kwargs):
  28. request.encoding = 'utf-8'
  29. operation = kwargs.get('operation')
  30. return self.validation(request.GET, request, operation)
  31. def post(self, request, *args, **kwargs):
  32. request.encoding = 'utf-8'
  33. operation = kwargs.get('operation')
  34. return self.validation(request.POST, request, operation)
  35. def validation(self, request_dict, request, operation):
  36. response = ResponseObject('cn')
  37. if operation == 'query-usage-history':
  38. return self.query_device_usage_history(request_dict, response)
  39. elif operation == 'test-notify':
  40. order_id = request_dict.get('orderId', None)
  41. activate_type = request_dict.get('activateType', 0)
  42. iccid = request_dict.get('iccid', None)
  43. combo_id = request_dict.get('comboId', None)
  44. self.create_combo_order_info(order_id, int(activate_type), iccid, int(combo_id))
  45. return HttpResponse('SUCCESS')
  46. elif operation == 'device-queue-monitoring':
  47. return self.device_queue_monitoring_push(request_dict, request)
  48. elif operation == 'device-status-change':
  49. return self.device_status_change_push(request_dict, request)
  50. elif operation == 'device-bind':
  51. return self.device_add(request_dict, response)
  52. elif operation == 'device-status':
  53. return self.update_device_status(request_dict, response)
  54. else:
  55. token = TokenObject(request.META.get('HTTP_AUTHORIZATION'))
  56. lang = request_dict.get('lang', token.lang)
  57. response = ResponseObject(lang)
  58. if token.code != 0:
  59. return response.json(token.code)
  60. user_id = token.userID
  61. if operation == 'combo-save':
  62. return self.save_unicom_combo(request_dict, response)
  63. elif operation == 'combo-pay':
  64. return self.buy_unicom_combo(user_id, request_dict, request, response)
  65. elif operation == 'combo-list':
  66. return self.query_package_list(response)
  67. elif operation == 'get-device-info':
  68. return self.get_device_info(request_dict, response)
  69. elif operation == 'user-combo-query':
  70. return self.user_combo_query(user_id, request_dict, response)
  71. @classmethod
  72. def user_combo_query(cls, user_id, request_dict, response):
  73. """
  74. 查询套餐流量列表或者正在使用流量详情
  75. @param user_id:
  76. @param request_dict:
  77. @param response:
  78. @return:
  79. """
  80. try:
  81. q_type = request_dict.get('type', None)
  82. iccid = request_dict.get('iccid', None)
  83. if not all([q_type, iccid]):
  84. return response.json(444)
  85. unicom_device_info_qs = UnicomDeviceInfo.objects.filter(iccid=iccid)
  86. if not unicom_device_info_qs.exists():
  87. return response.json(173)
  88. if not unicom_device_info_qs[0].user_id:
  89. unicom_device_info_qs.update(user_id=user_id)
  90. unicom_api = UnicomObjeect()
  91. today = datetime.datetime.today()
  92. year = today.year
  93. month = today.month
  94. if q_type == 'combo':
  95. cls.update_combo_order_sort(iccid)
  96. combo_list = []
  97. combo_order_qs = UnicomComboOrderInfo.objects.filter(iccid=iccid, is_del=False) \
  98. .values('iccid', 'status', 'combo__combo_name', 'combo__flow_total',
  99. 'combo__remark', 'combo__expiration_days', 'combo__expiration_type', 'flow_total_usage',
  100. 'expire_time').order_by('sort', 'created_time')
  101. for item in combo_order_qs:
  102. combo_list.append({
  103. 'iccid': iccid,
  104. 'comboName': item['combo__combo_name'],
  105. 'flowTotal': item['combo__flow_total'],
  106. 'comboRemark': item['combo__remark'],
  107. 'expirationDays': item['combo__expiration_days'],
  108. 'expirationType': item['combo__expiration_type'],
  109. 'flowTotalUsage': item['flow_total_usage'],
  110. 'expireTime': item['expire_time'],
  111. })
  112. return response.json(0, combo_list)
  113. elif q_type == 'usage':
  114. combo_order_qs = UnicomComboOrderInfo.objects.filter(iccid=iccid, status=1, is_del=False) \
  115. .values('iccid', 'status', 'combo__status', 'combo__combo_name', 'combo__combo_type',
  116. 'combo__flow_total', 'combo__remark', 'combo__expiration_days', 'combo__expiration_type',
  117. 'year', 'month', 'flow_total_usage', 'expire_time')
  118. if combo_order_qs.exists():
  119. combo_order = combo_order_qs.first()
  120. flow_details = {
  121. 'iccid': iccid,
  122. 'comboName': combo_order['combo__combo_name'],
  123. 'comboType': combo_order['combo__combo_type'],
  124. 'flowTotal': combo_order['combo__flow_total'],
  125. 'comboRemark': combo_order['combo__remark'],
  126. 'expirationDays': combo_order['combo__expiration_days'],
  127. 'expirationType': combo_order['combo__expiration_type'],
  128. 'year': combo_order['year'],
  129. 'month': combo_order['month'],
  130. 'flowTotalUsage': combo_order['flow_total_usage'],
  131. 'expireTime': combo_order['expire_time'],
  132. }
  133. if flow_details['year'] == year and flow_details['month'] == month:
  134. month_flow = unicom_api.get_flow_usage_total(year, month, iccid)
  135. # 当月流量减去 套餐激活时用量
  136. month_flow = month_flow - float(flow_details['flowTotalUsage'])
  137. flow = flow_details['flowTotal'] - month_flow
  138. flow_details['usableFlow'] = flow
  139. else:
  140. now_month_flow = unicom_api.get_flow_usage_total(year, month, iccid)
  141. last_month_flow = unicom_api.get_flow_usage_total(flow_details['year'], flow_details['month'],
  142. iccid)
  143. flow = now_month_flow + last_month_flow - float(flow_details['flowTotalUsage'])
  144. flow_details['usableFlow'] = flow_details['flowTotal'] - flow
  145. flow_details['usableFlow'] = \
  146. flow_details['flowTotal'] if flow_details['usableFlow'] <= 0 else flow_details['usableFlow']
  147. flow_details['usableFlow'] = Decimal(flow_details['usableFlow']).quantize(Decimal('0.00'))
  148. return response.json(0, flow_details)
  149. return response.json(0)
  150. except Exception as e:
  151. print(e.args)
  152. ex = traceback.format_exc()
  153. print(ex)
  154. return response.json(177, ex)
  155. @classmethod
  156. def update_combo_order_sort(cls, iccd):
  157. """
  158. 修改套餐排序
  159. @param iccd: 联通20位ICCID
  160. @return:
  161. """
  162. combo_order_qs = UnicomComboOrderInfo.objects.filter(iccid=iccd, is_del=False)
  163. if combo_order_qs.exists():
  164. unused_qs = combo_order_qs.filter(status=0)
  165. if unused_qs.exists():
  166. unused_qs.update(sort=50)
  167. used_qs = combo_order_qs.filter(status=1)
  168. if used_qs.exists():
  169. used_qs.update(sort=1)
  170. expire_qs = combo_order_qs.filter(status=2)
  171. if expire_qs.exists():
  172. expire_qs.update(sort=100)
  173. @classmethod
  174. def update_device_status(cls, request_dict, response):
  175. """
  176. 修改绑定设备状态,如产生免费套餐用量则删除
  177. @param request_dict:
  178. @param response:
  179. @return:
  180. """
  181. logger = logging.getLogger('info')
  182. serial_no = request_dict.get('serialNo', None)
  183. iccid = request_dict.get('iccid', None)
  184. time_stamp = request_dict.get('timeStamp', None)
  185. sign = request_dict.get('sign', None)
  186. if not all([iccid, serial_no, sign, time_stamp]):
  187. return response.json(444)
  188. logger.info('PC工具进入重置ICCID{}'.format(iccid))
  189. try:
  190. if not CommonService.check_time_stamp_token(sign, time_stamp):
  191. return response.json(13)
  192. now_time = int(time.time())
  193. with transaction.atomic():
  194. device_info_qs = UnicomDeviceInfo.objects.filter(iccid=iccid, serial_no=serial_no)
  195. if device_info_qs.exists():
  196. device_info_qs.update(status=1, updated_time=now_time)
  197. combo_order_qs = UnicomComboOrderInfo.objects.filter(iccid=iccid)
  198. if combo_order_qs.exists():
  199. combo_order_qs.delete()
  200. combo_experience_history_qs = UnicomComboExperienceHistory.objects.filter(iccid=iccid)
  201. if combo_experience_history_qs.exists():
  202. combo_experience_history_qs.delete()
  203. return response.json(0)
  204. except Exception as e:
  205. print(e.args)
  206. ex = traceback.format_exc()
  207. print(ex)
  208. logger.info('PC工具重置异常ICCID{},msg={}'.format(iccid, ex))
  209. return response.json(177, ex)
  210. @classmethod
  211. def get_device_info(cls, request_dict, response):
  212. """
  213. 获取设备信息
  214. @param request_dict:
  215. @param response:
  216. @return:
  217. """
  218. serial_no = request_dict.get('serialNumber', None)
  219. if not serial_no:
  220. return response.json(444)
  221. unicom_device_info_qs = UnicomDeviceInfo.objects.filter(serial_no=serial_no).values()
  222. if not unicom_device_info_qs.exists():
  223. return response.json(173)
  224. return response.json(0, dict(unicom_device_info_qs.first()))
  225. @classmethod
  226. def device_add(cls, request_dict, response):
  227. """
  228. 设备绑定iccid
  229. @param request_dict:
  230. @param response:
  231. @return:
  232. """
  233. iccid = request_dict.get('iccid', None)
  234. serial_no = request_dict.get('serialNo', None)
  235. time_stamp = request_dict.get('timeStamp', None)
  236. sign = request_dict.get('sign', None)
  237. if not all([iccid, serial_no, sign, time_stamp]):
  238. return response.json(444)
  239. # 时间戳token校验
  240. if not CommonService.check_time_stamp_token(sign, time_stamp):
  241. return response.json(13)
  242. n_time = int(time.time())
  243. try:
  244. with transaction.atomic():
  245. # 待完善代码 根据uid与用户id验证系统设备
  246. unicom_device_qs = UnicomDeviceInfo.objects.filter(iccid=iccid)
  247. if unicom_device_qs.exists():
  248. if unicom_device_qs.first().status == 1 and unicom_device_qs.first().serial_no == serial_no:
  249. cls.user_activate_flow(iccid)
  250. return response.json(174)
  251. unicom_obj = UnicomObjeect()
  252. result = unicom_obj.verify_device(iccid=iccid)
  253. if result.status_code == 200 and result.text:
  254. res_dict = json.loads(result.text)
  255. if res_dict['success']:
  256. if res_dict['data']['status'] == 0:
  257. return response.json(173)
  258. params = {'iccid': iccid, 'serial_no': serial_no, 'updated_time': n_time,
  259. 'created_time': n_time}
  260. unicom_obj.change_device_to_activate(iccid)
  261. UnicomDeviceInfo.objects.create(**params)
  262. return response.json(0)
  263. else:
  264. return response.json(173)
  265. except Exception as e:
  266. print(e)
  267. return response.json(177, repr(e))
  268. @classmethod
  269. def user_activate_flow(cls, iccid):
  270. """
  271. 用户激活初始化流量套餐
  272. @param iccid:
  273. @return:
  274. """
  275. logger = logging.getLogger('info')
  276. try:
  277. while transaction.atomic():
  278. now_time = int(time.time())
  279. unicom_device_info_qs = UnicomDeviceInfo.objects.filter(iccid=iccid)
  280. if not unicom_device_info_qs.exists():
  281. return False
  282. unicom_device_info_qs = unicom_device_info_qs.first()
  283. if unicom_device_info_qs.status != 1:
  284. logger.info('用户激活iccid={},业务系统状态为{}'.format(iccid, unicom_device_info_qs.status))
  285. return False
  286. # 联通业务逻辑
  287. unicom_api = UnicomObjeect()
  288. unicom_api.change_device_to_activate(iccid)
  289. # 查看是否体验过免费套餐
  290. experience_history_qs = UnicomComboExperienceHistory.objects.filter(iccid=iccid)
  291. if not experience_history_qs.exists():
  292. logger.info('用户首次激活iccid={}'.format(iccid))
  293. combo_qs = UnicomCombo.objects.filter(combo_type=1, status=0, is_del=False) \
  294. .values('id', 'expiration_type', 'expiration_days', 'combo_type')
  295. if combo_qs.exists():
  296. combo_qs = combo_qs.first()
  297. # 保存体验记录
  298. experience_history_vo = {'iccid': iccid, 'experience_type': 0, 'do_time': now_time}
  299. UnicomComboExperienceHistory.objects.create(**experience_history_vo)
  300. # 保存套餐激活信息
  301. cls.create_combo_order_info('', 0, iccid, combo_qs['id'])
  302. # 修改业务联通卡设备激活信息
  303. UnicomDeviceInfo.objects.filter(iccid=iccid).update(status=2, updated_time=now_time)
  304. return True
  305. except Exception as e:
  306. print(e)
  307. return False
  308. @classmethod
  309. def save_unicom_combo(cls, request_dict, response):
  310. """
  311. 联通套餐保存
  312. @param request_dict:
  313. @param response:
  314. @return:
  315. """
  316. combo_id = request_dict.get('id', None)
  317. combo_name = request_dict.get('comboName', None)
  318. flow_total = request_dict.get('flowTotal', None)
  319. expiration_days = request_dict.get('expirationDays', None)
  320. expiration_type = request_dict.get('expirationType', None)
  321. price = request_dict.get('price', None)
  322. remark = request_dict.get('remark', None)
  323. pay_type = request_dict.get('payType', '').split(',')
  324. if not all([pay_type, combo_name, flow_total, expiration_days, expiration_type, price]):
  325. return response.json(444)
  326. try:
  327. flow_total = int(flow_total)
  328. expiration_days = int(expiration_days)
  329. expiration_type = int(expiration_type)
  330. with transaction.atomic():
  331. re_data = {
  332. 'combo_name': combo_name,
  333. 'flow_total': flow_total,
  334. 'expiration_days': expiration_days,
  335. 'expiration_type': expiration_type,
  336. 'price': price,
  337. }
  338. if remark:
  339. re_data['remark'] = remark
  340. if combo_id:
  341. UnicomCombo.objects.filter(id=combo_id).update(**re_data)
  342. UnicomCombo.objects.get(id=combo_id).pay_type.set(pay_type)
  343. return response.json(0)
  344. UnicomCombo.objects.create(**re_data).pay_type.set(pay_type)
  345. return response.json(0)
  346. except Exception as e:
  347. print(e)
  348. return response.json(177, repr(e))
  349. @classmethod
  350. def query_package_list(cls, response):
  351. """
  352. 查询套餐列表
  353. @return:
  354. """
  355. try:
  356. combo_qs = UnicomCombo.objects.filter(is_show=1, status=0, is_del=False) \
  357. .order_by('sort').values('id', 'combo_name',
  358. 'flow_total',
  359. 'expiration_days',
  360. 'expiration_type', 'price',
  361. 'remark')
  362. if not combo_qs.exists():
  363. return response.json(0, [])
  364. combo_list = []
  365. for item in combo_qs:
  366. # 获取支付方式列表
  367. pay_type_qs = Pay_Type.objects.filter(unicomcombo=item['id']).values('id', 'payment')
  368. combo_list.append({
  369. 'id': item['id'],
  370. 'comboName': item['combo_name'],
  371. 'flowTotal': item['flow_total'],
  372. 'expirationDays': item['expiration_days'],
  373. 'expirationType': item['expiration_type'],
  374. 'price': item['price'],
  375. 'remark': item['remark'],
  376. 'payTypes': list(pay_type_qs),
  377. })
  378. return response.json(0, combo_list)
  379. except Exception as e:
  380. print(e)
  381. return response.json(177, repr(e))
  382. @classmethod
  383. def buy_unicom_combo(cls, user_id, request_dict, request, response):
  384. """
  385. 购买联通套餐
  386. @return:
  387. """
  388. try:
  389. with transaction.atomic():
  390. iccid = request_dict.get('iccid', None)
  391. combo_id = request_dict.get('id', None)
  392. pay_type = request_dict.get('payType', None)
  393. activate_type = request_dict.get('activateType', 0)
  394. if not all([iccid, combo_id, pay_type]):
  395. return response.json(444)
  396. combo_id = int(combo_id)
  397. pay_type = int(pay_type)
  398. now_time = int(time.time())
  399. unicom_combo_qs = UnicomCombo.objects.filter(id=combo_id, pay_type=pay_type, is_show=1, is_del=False,
  400. status=0) \
  401. .values('id', 'combo_name', 'price', 'remark')
  402. if not unicom_combo_qs.exists():
  403. return response.json(173)
  404. unicom_device_qs = UnicomDeviceInfo.objects.filter(iccid=iccid) \
  405. .values('serial_no')
  406. if not unicom_device_qs.exists():
  407. return response.json(173)
  408. unicom_combo_qs = unicom_combo_qs.first()
  409. price = unicom_combo_qs['price']
  410. if not price:
  411. return response.json(173)
  412. unicom_device_qs = unicom_device_qs.first()
  413. device_uid = CommonService.query_uid_with_serial(unicom_device_qs['serial_no'])
  414. order_id = CommonService.createOrderID()
  415. rank_id, ai_rank_id = cls.get_cloud_or_ai_combo()
  416. order_dict = {'rank_id': rank_id, 'ai_rank_id': ai_rank_id, 'orderID': order_id, 'UID': device_uid,
  417. 'userID_id': user_id, 'desc': unicom_combo_qs['combo_name'], 'payType': pay_type,
  418. 'payTime': now_time, 'price': price, 'currency': 'CNY', 'addTime': now_time,
  419. 'updTime': now_time,
  420. 'unify_combo_id': str(unicom_combo_qs['id']), 'order_type': 2,
  421. }
  422. params = 'lang=cn' + '&activateType=' + activate_type
  423. result = {'result_code': 0, 'reason': 'success', 'error_code': 0}
  424. if pay_type == 2: # 支付宝
  425. pay_price = PayService.get_two_float(price, 2)
  426. notify_url = 'unicom/wap/pay/ali-notify'
  427. order_dict['pay_url'] = PayService.create_alipay_payment(params, order_id, pay_price,
  428. unicom_combo_qs['combo_name'],
  429. notify_url,
  430. unicom_combo_qs['remark'], response)
  431. res_data = {'redirectUrl': order_dict['pay_url'], 'orderID': order_id}
  432. elif pay_type == 3: # 微信支付
  433. notify_url = 'unicom/wap/pay/wechat-notify'
  434. ip = CommonService.get_ip_address(request)
  435. params = 'activateType=' + activate_type
  436. sign_params = PayService.create_wechat_payment(params, order_id,
  437. price, ip,
  438. notify_url,
  439. unicom_combo_qs['remark'],
  440. response)
  441. result['result'] = sign_params
  442. else:
  443. return response.json(444, {'param': 'pay_type'})
  444. Order_Model.objects.create(**order_dict)
  445. if pay_type == 3:
  446. return JsonResponse(status=200, data=result)
  447. return response.json(0, res_data)
  448. except Exception as e:
  449. print(e)
  450. return response.json(500, repr(e))
  451. @staticmethod
  452. def get_cloud_or_ai_combo():
  453. """
  454. 获取云存或者AI套餐id
  455. @return:
  456. """
  457. rank_id = Store_Meal.objects.all().order_by('sort').values().first()['id']
  458. ai_rank_id = AiStoreMeal.objects.all().values().first()['id']
  459. return rank_id, ai_rank_id
  460. @classmethod
  461. def query_device_usage_history(cls, request_dict, response):
  462. """
  463. 查询用量历史
  464. @return:
  465. """
  466. today = datetime.datetime.today()
  467. year = today.year
  468. month = today.month
  469. year = request_dict.get('year', year)
  470. month = request_dict.get('month', month)
  471. iccid = request_dict.get('iccid', None)
  472. if not iccid:
  473. return response.json(444)
  474. unicom_api = UnicomObjeect()
  475. flow = unicom_api.get_flow_usage_total(int(year), int(month), iccid)
  476. return response.json(0, flow)
  477. @staticmethod
  478. def package_callback_notify(request_dict, request):
  479. """
  480. 异步套餐订购回调
  481. @param request_dict:
  482. @param request:
  483. @return:
  484. """
  485. logger = logging.getLogger('info')
  486. try:
  487. logger.info('联通异步套餐订购回调参数{}'.format(request_dict))
  488. body = request.body.decode("utf-8")
  489. if body:
  490. dict_data = json.loads(body)
  491. sign = dict_data['sign']
  492. logger.info('设备订购异步回调请求参数{}'.format(dict_data))
  493. dict_data.pop('sign')
  494. unicom_obj = UnicomObjeect()
  495. generate_sign = unicom_obj.createSign(**dict_data)
  496. logger.info('设备订购请求签名{}'.format(sign))
  497. logger.info('设备订购生成签名{}'.format(generate_sign))
  498. r_data = {'success': True, 'msg': '成功'}
  499. return HttpResponse(json.dumps(r_data, ensure_ascii=False), content_type="application/json,charset=utf-8")
  500. except Exception as e:
  501. print(repr(e))
  502. r_data = {'success': False, 'msg': '失败'}
  503. return HttpResponse(json.dumps(r_data, ensure_ascii=False), content_type="application/json,charset=utf-8")
  504. @staticmethod
  505. def device_queue_monitoring_push(request_dict, request):
  506. """
  507. 设备套餐队列用完或者到期推送
  508. @param request_dict:
  509. @param request:
  510. @return:
  511. """
  512. logger = logging.getLogger('info')
  513. try:
  514. logger.info('设备套餐队列推送{}'.format(request_dict))
  515. body = request.body.decode("utf-8")
  516. if body:
  517. dict_data = json.loads(body)
  518. sign = dict_data['sign']
  519. logger.info('设备套餐队列回调请求参数{}'.format(dict_data))
  520. dict_data.pop('sign')
  521. unicom_obj = UnicomObjeect()
  522. generate_sign = unicom_obj.createSign(**dict_data)
  523. logger.info('设备套餐队列请求签名{}'.format(sign))
  524. logger.info('设备套餐队列生成签名{}'.format(generate_sign))
  525. r_data = {'success': True, 'msg': '成功'}
  526. return HttpResponse(json.dumps(r_data, ensure_ascii=False), content_type="application/json,charset=utf-8")
  527. except Exception as e:
  528. print(repr(e))
  529. r_data = {'success': False, 'msg': '失败'}
  530. return HttpResponse(json.dumps(r_data, ensure_ascii=False), content_type="application/json,charset=utf-8")
  531. @staticmethod
  532. def device_status_change_push(request_dict, request):
  533. """
  534. 设备状态变更推送执行场景说明
  535. @param request_dict:
  536. @param request:
  537. @return:
  538. """
  539. logger = logging.getLogger('info')
  540. try:
  541. logger.info('设备状态变更推送{}'.format(request_dict))
  542. body = request.body.decode("utf-8")
  543. if body:
  544. dict_data = json.loads(body)
  545. sign = dict_data['sign']
  546. logger.info('设备状态变更推送请求参数{}'.format(dict_data))
  547. dict_data.pop('sign')
  548. unicom_obj = UnicomObjeect()
  549. generate_sign = unicom_obj.createSign(**dict_data)
  550. logger.info('设备状态变更推送请求签名{}'.format(sign))
  551. logger.info('设备状态变更推送生成签名{}'.format(generate_sign))
  552. r_data = {'success': True, 'msg': '成功'}
  553. return HttpResponse(json.dumps(r_data, ensure_ascii=False), content_type="application/json,charset=utf-8")
  554. except Exception as e:
  555. print(repr(e))
  556. r_data = {'success': False, 'msg': '失败'}
  557. return HttpResponse(json.dumps(r_data, ensure_ascii=False), content_type="application/json,charset=utf-8")
  558. @classmethod
  559. def create_combo_order_info(cls, order_id, activate_type, iccid, combo_id):
  560. """
  561. 创建套餐生效记录
  562. @param order_id: 订单id
  563. @param activate_type: 激活类型
  564. @param iccid: 联通20位iccid
  565. @param combo_id: 套餐id
  566. @return: True Or False
  567. """
  568. logger = logging.getLogger('info')
  569. logger.info('创建联通订单套餐信息,订单id{}'.format(order_id))
  570. try:
  571. today = datetime.datetime.today()
  572. year = today.year
  573. month = today.month
  574. with transaction.atomic():
  575. unicom_combo_qs = UnicomCombo.objects.filter(id=int(combo_id)).values()
  576. if unicom_combo_qs.exists():
  577. unicom_combo = unicom_combo_qs.first()
  578. now_time = int(time.time())
  579. combo_order_qs = UnicomComboOrderInfo.objects.filter(status=1, iccid=iccid)
  580. status = 0
  581. if not combo_order_qs.exists():
  582. status = 1
  583. combo_order_data = {'iccid': iccid, 'status': status, 'combo_id': int(combo_id),
  584. 'updated_time': now_time,
  585. 'created_time': now_time,
  586. 'year': year, 'month': month}
  587. if order_id:
  588. combo_order_data['order_id'] = order_id
  589. # 有效期类型 1 等于自然月,0天数
  590. if unicom_combo['expiration_type'] == 1:
  591. # 激活类型 1=下月激活 否则等于当月激活
  592. if activate_type == 1:
  593. combo_order_data['next_month_activate'] = True
  594. next_start_time, end_time = cls.get_next_month_data_time()
  595. combo_order_data['activation_time'] = next_start_time
  596. combo_order_data['expire_time'] = end_time
  597. combo_order_data['status'] = 0
  598. else:
  599. start_time, month_end_time = cls.get_month_start_and_end_time()
  600. combo_order_data['activation_time'] = now_time
  601. combo_order_data['expire_time'] = month_end_time
  602. elif unicom_combo['expiration_type'] == 0:
  603. days = unicom_combo['expiration_days']
  604. zero_today, end_time = cls.get_data_time(days)
  605. combo_order_data['activation_time'] = now_time
  606. combo_order_data['expire_time'] = end_time
  607. # 联通业务逻辑
  608. unicom_api = UnicomObjeect()
  609. if status == 1:
  610. unicom_api.change_device_to_activate(iccid)
  611. flow_total_usage = unicom_api.get_flow_usage_total(year, month, iccid)
  612. combo_order_data['flow_total_usage'] = str(flow_total_usage)
  613. UnicomComboOrderInfo.objects.create(**combo_order_data)
  614. logger.info('保存套餐支付信息success')
  615. return True
  616. except Exception as e:
  617. print(e)
  618. return False
  619. @staticmethod
  620. def get_next_month_data_time():
  621. """
  622. 获取下个月开始时间与结束时间戳
  623. @return: next_start_time,end_time
  624. """
  625. next_month_start = LocalDateTimeUtil.get_next_month_start()
  626. next_start_time, next_end_time = LocalDateTimeUtil.get_start_and_end_time(next_month_start, '%Y-%m-%d')
  627. next_month_end = LocalDateTimeUtil.get_next_month_end()
  628. start_time, end_time = LocalDateTimeUtil.get_start_and_end_time(next_month_end, '%Y-%m-%d')
  629. return next_start_time, end_time
  630. @staticmethod
  631. def get_data_time(days):
  632. """
  633. 获取今天开始时间以及days后日期结束时间戳
  634. @return: next_start_time,end_time
  635. """
  636. zero_today, last_today = LocalDateTimeUtil.get_today_date(True)
  637. now_time = int(time.time())
  638. after_time = LocalDateTimeUtil.get_after_days_timestamp(now_time, days)
  639. time_array = time.localtime(after_time)
  640. start_time, end_time = LocalDateTimeUtil.get_start_and_end_time(time.strftime("%Y-%m-%d", time_array),
  641. '%Y-%m-%d')
  642. return zero_today, end_time
  643. @staticmethod
  644. def get_month_start_and_end_time():
  645. """
  646. 获取当天开始时间与当月结束时间戳
  647. @return:
  648. """
  649. zero_today, last_today = LocalDateTimeUtil.get_today_date(True)
  650. month_end = LocalDateTimeUtil.get_cur_month_end()
  651. start_time, month_end_time = LocalDateTimeUtil.get_start_and_end_time(month_end, '%Y-%m-%d')
  652. return zero_today, month_end_time
  653. @classmethod
  654. def get_test_sign(cls, request_dict, response):
  655. """
  656. 测试盐加密解密
  657. @param request_dict:
  658. @param response:
  659. @return:
  660. """
  661. verify = request_dict.get('verify', False)
  662. if verify:
  663. sign = request_dict.get('sign')
  664. time_stamp = request_dict.get('timeStamp')
  665. sign = CommonService.check_time_stamp_token(sign, time_stamp)
  666. if not sign:
  667. return response.json(13)
  668. return response.json(0)
  669. now_time = int(time.time())
  670. sign = CommonService.encode_data(str(now_time))
  671. return response.json(0, {'sign': sign, 'timeStamp': now_time})