CloudStorage.py 30 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689
  1. #!/usr/bin/env python3
  2. # -*- coding: utf-8 -*-
  3. """
  4. @Copyright (C) ansjer cop Video Technology Co.,Ltd.All rights reserved.
  5. @AUTHOR: ASJRD018
  6. @NAME: AnsjerFormal
  7. @software: PyCharm
  8. @DATE: 2018/12/5 9:30
  9. @Version: python3.6
  10. @MODIFY DECORD:ansjer dev
  11. @file: CloudVod.py
  12. @Contact: chanjunkai@163.com
  13. """
  14. import json
  15. import math
  16. import time
  17. import urllib
  18. from Object.AliPayObject import AliPayObject
  19. import oss2
  20. import paypalrestsdk
  21. import boto3
  22. from aliyunsdkcore import client
  23. from aliyunsdksts.request.v20150401 import AssumeRoleRequest
  24. from django.http import JsonResponse, HttpResponseRedirect, HttpResponse
  25. from django.utils.decorators import method_decorator
  26. from django.views.decorators.csrf import csrf_exempt
  27. from django.views.generic.base import View
  28. from Ansjer.config import OSS_STS_ACCESS_KEY, OSS_STS_ACCESS_SECRET, OSS_ROLE_ARN, SERVER_DOMAIN, PAYPAL_CRD, \
  29. SERVER_DOMAIN_SSL
  30. from Model.models import Device_Info, Order_Model, Store_Meal, VodHlsModel, OssCrdModel, UID_Bucket, StsCrdModel
  31. from Object.ResponseObject import ResponseObject
  32. from Object.TokenObject import TokenObject
  33. from Object.UidTokenObject import UidTokenObject
  34. from Service.CommonService import CommonService
  35. from Service.ModelService import ModelService
  36. from Object.ETkObject import ETkObject
  37. SERVER_DOMAIN = 'http://cloudstroage.dvema.com/'
  38. # 设备信息添加
  39. class CloudStorageView(View):
  40. def get(self, request, *args, **kwargs):
  41. request.encoding = 'utf-8'
  42. operation = kwargs.get('operation')
  43. return self.validation(request.GET, request, operation)
  44. def post(self, request, *args, **kwargs):
  45. request.encoding = 'utf-8'
  46. operation = kwargs.get('operation')
  47. return self.validation(request.POST, request, operation)
  48. def validation(self, request_dict, request, operation):
  49. response = ResponseObject()
  50. if operation is None:
  51. return response.json(444, 'error path')
  52. elif operation == 'dopaypalcallback':
  53. return self.do_pay_by_paypal_callback(request_dict, response)
  54. elif operation == 'doalicallback':
  55. return self.do_pay_by_ali_callback(request)
  56. elif operation == 'getsignsts':
  57. ip = CommonService.get_ip_address(request)
  58. return self.do_get_sign_sts(request_dict, ip, response)
  59. elif operation == 'storeplaylist':
  60. return self.do_store_playlist(request_dict, response)
  61. else:
  62. token = request_dict.get('token', None)
  63. # 设备主键uid
  64. tko = TokenObject(token)
  65. response.lang = tko.lang
  66. if tko.code != 0:
  67. return response.json(tko.code)
  68. userID = tko.userID
  69. if operation == 'createpayorder':
  70. return self.do_create_pay_order(request_dict, userID, response)
  71. elif operation == 'changevodstatus':
  72. return self.do_change_vod_status(request_dict, userID, response)
  73. elif operation == 'queryvodlist':
  74. return self.do_query_vod_list(request_dict, userID, response)
  75. else:
  76. return response.json(414)
  77. def do_get_sign_sts(self, request_dict, ip, response):
  78. uidToken = request_dict.get('uidToken', None)
  79. utko = UidTokenObject(uidToken)
  80. if utko.flag is False:
  81. return response.json(444, 'uidToken')
  82. uid = utko.UID
  83. channel = utko.channel
  84. print(channel)
  85. print(uid)
  86. now_time = int(time.time())
  87. ubqs = UID_Bucket.objects.filter(uid=uid, channel=channel, endTime__gte=now_time). \
  88. values("bucket__mold", "bucket__bucket", "bucket__endpoint", "bucket__region")
  89. if ubqs.exists():
  90. if ubqs[0]["bucket__mold"] == 0:
  91. # 阿里云 oss sts
  92. oc_qs = OssCrdModel.objects.filter(uid=uid, channel=channel). \
  93. values("addTime", "data")
  94. if oc_qs.exists():
  95. endTime = int(oc_qs[0]["addTime"]) + 3500
  96. if endTime > now_time:
  97. print(endTime)
  98. print(now_time)
  99. res = json.loads(oc_qs[0]["data"])
  100. return JsonResponse(status=200, data=res)
  101. # 套餐id
  102. storage = '{uid}/vod{channel}/'.format(uid=uid, channel=channel)
  103. bucket_name = ubqs[0]['bucket__bucket']
  104. endpoint = ubqs[0]['bucket__endpoint']
  105. access_key_id = OSS_STS_ACCESS_KEY
  106. access_key_secret = OSS_STS_ACCESS_SECRET
  107. region_id = ubqs[0]['bucket__region']
  108. role_arn = OSS_ROLE_ARN
  109. clt = client.AcsClient(access_key_id, access_key_secret, region_id)
  110. req = AssumeRoleRequest.AssumeRoleRequest()
  111. # 设置返回值格式为JSON。
  112. req.set_accept_format('json')
  113. req.set_RoleArn(role_arn)
  114. req.set_RoleSessionName(uid + '_' + channel)
  115. req.set_DurationSeconds(3600)
  116. Resource_access = "acs:oss:*:*:{bucket_name}/{uid_channel}*". \
  117. format(bucket_name=bucket_name, uid_channel=storage)
  118. print(Resource_access)
  119. policys = {
  120. "Version": "1",
  121. "Statement": [
  122. {
  123. "Action": ["oss:PutObject", "oss:DeleteObject", ],
  124. "Resource": [Resource_access],
  125. "Effect": "Allow",
  126. "Condition": {
  127. "IpAddress": {"acs:SourceIp": ip}
  128. # "IpAddress": {"acs:SourceIp": "120.237.157.184"}
  129. # "IpAddress": {"acs:SourceIp": "*"}
  130. }
  131. }
  132. ]
  133. }
  134. req.set_Policy(Policy=json.dumps(policys))
  135. body = clt.do_action(req)
  136. # 使用RAM账号的AccessKeyId和AccessKeySecret向STS申请临时token。
  137. token = json.loads(body.decode('utf-8'))
  138. print(token)
  139. res = {
  140. 'AccessKeyId': token['Credentials']['AccessKeyId'],
  141. 'AccessKeySecret': token['Credentials']['AccessKeySecret'],
  142. 'SecurityToken': token['Credentials']['SecurityToken'],
  143. 'Expiration': token['Credentials']['Expiration'],
  144. 'expire': '3600',
  145. 'endpoint': endpoint,
  146. 'bucket_name': bucket_name,
  147. 'arn': token['AssumedRoleUser']['Arn'],
  148. 'code': 0,
  149. 'storage': storage,
  150. 'endTime': ubqs[0]['endTime'],
  151. 'ip': ip}
  152. if oc_qs.exists():
  153. oc_qs.update(data=json.dumps(res), addTime=now_time)
  154. else:
  155. OssCrdModel.objects.create \
  156. (uid=uid, channel=channel, data=json.dumps(res), addTime=now_time)
  157. return JsonResponse(status=200, data=res)
  158. elif ubqs[0]["bucket__mold"] == 1:
  159. # 亚马逊 s3 sts
  160. sts_qs = StsCrdModel.objects.filter(uid=uid, channel=channel). \
  161. values("addTime", "data")
  162. if sts_qs.exists():
  163. endTime = int(sts_qs[0]["addTime"]) + 3500
  164. if endTime > now_time:
  165. print(endTime)
  166. print(now_time)
  167. res = json.loads(sts_qs[0]["data"])
  168. return JsonResponse(status=200, data=res)
  169. # 套餐id
  170. storage = '{uid}/vod{channel}/'.format(uid=uid, channel=channel)
  171. bucket_name = ubqs[0]['bucket__bucket']
  172. endpoint = ubqs[0]['bucket__endpoint']
  173. region_id = ubqs[0]['bucket__region']
  174. ###############
  175. REGION_NAME = region_id
  176. boto3_sts = boto3.client(
  177. 'sts',
  178. aws_access_key_id='AKIA2E67UIMD45Y3HL53',
  179. aws_secret_access_key='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',
  180. region_name=REGION_NAME
  181. )
  182. Policy = {
  183. "Version": "2012-10-17",
  184. "Statement": [
  185. {
  186. "Effect": "Allow",
  187. "Action": "s3:*",
  188. "Resource": ["arn:aws:s3:::azvod1/{uid_channel}/*".
  189. format(uid_channel=storage)]
  190. }
  191. ]
  192. }
  193. response = boto3_sts.get_federation_token(
  194. Name='{role_name}'.format(role_name=uid + '_' + channel),
  195. Policy=json.dumps(Policy),
  196. DurationSeconds=7200
  197. )
  198. ###############
  199. res = {
  200. 'AccessKeyId': response['Credentials']['AccessKeyId'],
  201. 'AccessKeySecret': response['Credentials']['SecretAccessKey'],
  202. 'SessionToken': response['Credentials']['SessionToken'],
  203. 'Expiration': response['Credentials']['Expiration'],
  204. 'expire': '3600',
  205. 'endpoint': endpoint,
  206. 'bucket_name': bucket_name,
  207. 'arn': response['FederatedUser']['Arn'],
  208. 'code': 0,
  209. 'storage': storage,
  210. 'endTime': ubqs[0]['endTime'],
  211. 'ip': ip,
  212. }
  213. if sts_qs.exists():
  214. sts_qs.update(data=json.dumps(res), addTime=now_time)
  215. else:
  216. StsCrdModel.objects.create(uid=uid, channel=channel, data=json.dumps(res), addTime=now_time, type=1)
  217. return JsonResponse(status=200, data=res)
  218. else:
  219. res = {'code': 404, 'msg': 'data not exists!'}
  220. return HttpResponse(json.dumps(res, ensure_ascii=False),
  221. content_type="application/json,charset=utf-8")
  222. def do_query_vod_list(self, request_dict, userID, response):
  223. startTime = int(request_dict.get('startTime',None))
  224. endTime = int(request_dict.get('endTime',None))
  225. uid =request_dict.get('uid',None)
  226. channel = request_dict.get('channel',None)
  227. dv_qs = Device_Info.objects.filter(UID=uid,userID_id=userID,isShare=False)
  228. if not dv_qs.exists():
  229. return response.json(12)
  230. now_time = int(time.time())
  231. vh_qs = VodHlsModel.objects.filter(uid=uid,channel=channel,time__range=(startTime,endTime))
  232. def do_store_playlist(self, request_dict, response):
  233. uidToken = request_dict.get('uidToken', None)
  234. storeTime = request_dict.get('time', None)
  235. sec = request_dict.get('sec', None)
  236. fg = request_dict.get('fg', None)
  237. utko = UidTokenObject(uidToken)
  238. if utko.flag is False:
  239. return response.json(444, 'uidToken')
  240. if not uidToken or not storeTime or not sec:
  241. return response.json(0)
  242. pass
  243. UID = utko.UID
  244. channel = utko.channel
  245. print('UID:')
  246. print(UID)
  247. print('channel:')
  248. print(channel)
  249. now_time = int(time.time())
  250. ubqs = UID_Bucket.objects.filter(uid=UID, channel=channel, endTime__gte=now_time). \
  251. values("bucket__mold", "bucket__bucket", "bucket__endpoint", "bucket__region", "status", "bucket__storeDay")
  252. if ubqs.exists():
  253. ub_qs_data = ubqs[0]
  254. store_day = ub_qs_data['bucket__storeDay']
  255. bucket_id = ub_qs_data['bucket_id']
  256. end_time = int(storeTime) + store_day * 86400
  257. if ub_qs_data['status'] == 1:
  258. if ub_qs_data["bucket__mold"] == 0:
  259. oss_crd_qs = OssCrdModel.objects.filter(uid=UID, channel=channel)
  260. if oss_crd_qs.exists():
  261. VodHlsModel.objects.create(
  262. uid=UID,
  263. channel=channel,
  264. time=storeTime,
  265. endTime=end_time,
  266. bucket_id=bucket_id
  267. )
  268. res = {'code': 0, 'msg': '存储成功'}
  269. return HttpResponse(json.dumps(res, ensure_ascii=False),
  270. content_type="application/json,charset=utf-8")
  271. else:
  272. res = {'code': 404, 'msg': '设备未购买'}
  273. return HttpResponse(json.dumps(res, ensure_ascii=False),
  274. content_type="application/json,charset=utf-8")
  275. elif ub_qs_data['bucket__mold'] == 1:
  276. sts_qs = StsCrdModel.objects.filter(uid=UID, channel=channel, type=1). \
  277. values("addTime", "data")
  278. if sts_qs.exists():
  279. VodHlsModel.objects.create(
  280. uid=UID,
  281. channel=channel,
  282. time=storeTime,
  283. endTime=end_time,
  284. bucket_id=bucket_id,
  285. fg=fg,
  286. )
  287. res = {'code': 0, 'msg': '存储成功'}
  288. return HttpResponse(json.dumps(res, ensure_ascii=False),
  289. content_type="application/json,charset=utf-8")
  290. else:
  291. res = {'code': 404, 'msg': '设备未购买'}
  292. return HttpResponse(json.dumps(res, ensure_ascii=False),
  293. content_type="application/json,charset=utf-8")
  294. else:
  295. res = {'code': 404, 'msg': '设备未开启'}
  296. return HttpResponse(json.dumps(res, ensure_ascii=False), content_type="application/json,charset=utf-8")
  297. else:
  298. res = {'code': 404, 'msg': '设备未购买'}
  299. return HttpResponse(json.dumps(res, ensure_ascii=False), content_type="application/json,charset=utf-8")
  300. def do_change_vod_status(self, request_dict, userID, response):
  301. uid = request_dict.get('uid', None)
  302. status = request_dict.get('status', None)
  303. channel = request_dict.get('channel', None)
  304. if not all([uid, status, channel]):
  305. dv_qs = Device_Info.objects.filter(UID=uid, userID_id=userID, isShare=False, isExist=1)
  306. if dv_qs.exists():
  307. now_time = int(time.time())
  308. try:
  309. ubqs = UID_Bucket.objects.filter(uid=uid, channel=channel, endTime__gte=now_time).first()
  310. except Exception as e:
  311. print(repr(e))
  312. return response.json(10, '未购买')
  313. else:
  314. ubqs.update(status=status)
  315. if status == 0:
  316. return response.json(0)
  317. else:
  318. utko = UidTokenObject()
  319. utko.generate(data={'uid': uid, 'channel': channel})
  320. uidTK = utko.toke
  321. uidTkUrl = "{SERVER_DOMAIN}cloudstorage/getsignsts?uidToken={uidToken}". \
  322. format(uidToken=uidTK, SERVER_DOMAIN=SERVER_DOMAIN)
  323. storeHlsUrl = "{SERVER_DOMAIN}cloudstorage/storeplaylist?uidToken={uidToken}". \
  324. format(uidToken=uidTK, SERVER_DOMAIN=SERVER_DOMAIN)
  325. return response.json(0, {'uidTkUrl': uidTkUrl, 'storeHlsUrl': storeHlsUrl})
  326. else:
  327. return response.json(12)
  328. else:
  329. return response.json(444, 'uid,status,channel')
  330. def do_pay_error(self):
  331. response = HttpResponse()
  332. response.content = '''
  333. <!DOCTYPE html>
  334. <html>
  335. <head>
  336. <!--浏览器不缓存-->
  337. <meta http-equiv="Pragma" content="no-cache">
  338. <meta http-equiv="Cache-Control" content="no-cache">
  339. <meta http-equiv="Expires" content="0">
  340. <!--utf-8-->
  341. <meta http-equiv="content-type" content="text/html;charset=utf-8">
  342. <!-- viewport的<meta>标签,这个标签可以修改在大部分的移动设备上面的显示,为了确保适当的绘制和触屏缩放。-->
  343. <meta name="viewport" content="width=device-width, initial-scale=1.0">
  344. <link rel="shortcut icon" href="https://test.dvema.com/web/images/favicon.ico" type="image/x-icon" charset="utf-8"/>
  345. <title>Trading particulars</title>
  346. <style>
  347. .title_head{
  348. height: 50px;
  349. border-radius: 5px;
  350. background-color: #c3c6c7;
  351. text-align: center;
  352. line-height: 50px;
  353. }
  354. .content{
  355. text-align: center;
  356. margin-top: 50px;
  357. font-size: 20px;
  358. color : #ec7648
  359. }
  360. .content_img{
  361. width: 60px;
  362. height: 60px;
  363. }
  364. .bottom{
  365. margin-bottom: 10px;
  366. margin-top: 250px;
  367. color : #ec7648
  368. }
  369. .bottom_div{
  370. border: 1px solid #ec7648;
  371. line-height: 38px;
  372. text-align: center;
  373. width: 100px;
  374. height: 38px;
  375. border-radius: 5px;
  376. }
  377. .bottom_div:hover{
  378. background-color: #dde4e2;
  379. }
  380. </style>
  381. </head>
  382. <body>
  383. <div class="title_head">Trading particulars</div>
  384. <div class="content">
  385. <p >
  386. <img src="https://test.dvema.com/web/images/failed.jpg" class="content_img">
  387. <br />
  388. Payment failure
  389. </p>
  390. </div>
  391. <center class="bottom">
  392. <div class="bottom_div" onclick="payOKButton()">
  393. Finish
  394. </div>
  395. </center>
  396. <script> // 点击付款成功按钮
  397. function payOKButton() {
  398. // 复杂数据
  399. console.log('success')
  400. window.webkit.messageHandlers.jsCallOC.postMessage({"status": 0});
  401. }
  402. </script>
  403. </body>
  404. </html>
  405. '''
  406. return response
  407. def do_pay_ok(self):
  408. response = HttpResponse()
  409. response.content = '''
  410. <!DOCTYPE html>
  411. <html>
  412. <head>
  413. <!--浏览器不缓存-->
  414. <meta http-equiv="Pragma" content="no-cache">
  415. <meta http-equiv="Cache-Control" content="no-cache">
  416. <meta http-equiv="Expires" content="0">
  417. <!--utf-8-->
  418. <meta http-equiv="content-type" content="text/html;charset=utf-8">
  419. <!-- viewport的<meta>标签,这个标签可以修改在大部分的移动设备上面的显示,为了确保适当的绘制和触屏缩放。-->
  420. <meta name="viewport" content="width=device-width, initial-scale=1.0">
  421. <link rel="shortcut icon" href="https://test.dvema.com/web/images/favicon.ico" type="image/x-icon" charset="utf-8"/>
  422. <title>Trading particulars</title>
  423. <style>
  424. .title_head{
  425. height: 50px;
  426. border-radius: 5px;
  427. background-color: #c3c6c7;
  428. text-align: center;
  429. line-height: 50px;
  430. }
  431. .content{
  432. text-align: center;
  433. margin-top: 50px;
  434. font-size: 20px;
  435. color : green
  436. }
  437. .content_img{
  438. width: 60px;
  439. height: 60px;
  440. }
  441. .bottom{
  442. margin-bottom: 10px;
  443. margin-top: 250px;
  444. color : green
  445. }
  446. .bottom_div{
  447. border: 1px solid green;
  448. line-height: 38px;
  449. text-align: center;
  450. width: 100px;
  451. height: 38px;
  452. border-radius: 5px;
  453. }
  454. .bottom_div:hover{
  455. background-color: #dde4e2;
  456. }
  457. </style>
  458. </head>
  459. <body>
  460. <div class="title_head">Trading particulars</div>
  461. <div class="content">
  462. <p >
  463. <img src="https://test.dvema.com/web/images/timg.jpg" class="content_img">
  464. <br />
  465. Successful payment
  466. </p>
  467. </div>
  468. <center class="bottom">
  469. <div class="bottom_div" onclick="payOKButton()">
  470. Finish
  471. </div>
  472. </center>
  473. <script> // 点击付款成功按钮
  474. function payOKButton() {
  475. // 复杂数据
  476. console.log('success')
  477. window.webkit.messageHandlers.jsCallOC.postMessage({"status": 1});
  478. }
  479. </script>
  480. </body>
  481. </html>
  482. '''
  483. return response
  484. def do_pay_by_ali_callback(self, request):
  485. response = ResponseObject()
  486. data = request.POST.dict()
  487. signature = data["sign"]
  488. data.pop('sign')
  489. orderID = data['out_trade_no']
  490. order_qs = Order_Model.objects.filter(orderID=orderID, status=0)
  491. print(order_qs)
  492. if not order_qs.exists():
  493. return response.json(404)
  494. print(json.dumps(data))
  495. print(signature)
  496. # verify
  497. aliPayObj = AliPayObject()
  498. alipay = aliPayObj.conf()
  499. success = alipay.verify(data, signature)
  500. if success and data["trade_status"] in ("TRADE_SUCCESS", "TRADE_FINISHED"):
  501. print("trade succeed")
  502. nowTime = int(time.time())
  503. order_list = order_qs.values("UID", "commodity_code", "channel")
  504. UID = order_list[0]['UID']
  505. channel = order_list[0]['channel']
  506. commodity_code = order_list[0]['commodity_code']
  507. order_qs.update(status=1, updTime=nowTime)
  508. smqs = Store_Meal.objects.filter(commodity_code=commodity_code). \
  509. values("day", "bucket_id", "bucket__storeDay")
  510. bucketId = smqs[0]['bucket_id']
  511. if not smqs.exists():
  512. return response.json(0, '套餐已删除')
  513. addTime = int(smqs[0]["day"]) * 24 * 3600
  514. ubqs = UID_Bucket.objects.filter(uid=UID, channel=channel). \
  515. values("bucket_id", "endTime", "bucket__storeDay")
  516. nowTime = int(time.time())
  517. if ubqs.exists():
  518. ubqs_count = ubqs.count()
  519. ubq = ubqs[ubqs_count - 1, ubqs_count]
  520. new_starTime = ubq['endTime'] + 1
  521. ub_cqs = UID_Bucket.objects.create(uid=UID, channel=channel, bucket_id=bucketId,
  522. endTime=new_starTime + addTime)
  523. uid_bucket_id = ub_cqs.id
  524. else:
  525. ub_cqs = UID_Bucket.objects.create(uid=UID, channel=channel, bucket_id=bucketId,
  526. endTime=nowTime + addTime)
  527. uid_bucket_id = ub_cqs.id
  528. order_qs.update \
  529. (payTime=nowTime, status=1, updTime=nowTime, uid_bucket_id=uid_bucket_id)
  530. red_url = "{SERVER_DOMAIN}cloudVod/payOK".format(SERVER_DOMAIN=SERVER_DOMAIN)
  531. return HttpResponseRedirect(red_url)
  532. return response.json(0, signature)
  533. def do_pay_by_paypal_callback(self, request_dict, response):
  534. paymentId = request_dict.get('paymentId', None)
  535. PayerID = request_dict.get('PayerID', None)
  536. orderID = request_dict.get('orderID', None)
  537. if not paymentId or not PayerID or not orderID:
  538. red_url = "{SERVER_DOMAIN}cloudVod/payError".format(SERVER_DOMAIN=SERVER_DOMAIN)
  539. return HttpResponseRedirect(red_url)
  540. paypalrestsdk.configure(PAYPAL_CRD)
  541. # ID of the payment. This ID is provided when creating payment.
  542. payment = paypalrestsdk.Payment.find(paymentId)
  543. payres = payment.execute({"payer_id": PayerID})
  544. print(payres)
  545. if not payres:
  546. red_url = "{SERVER_DOMAIN}cloudVod/payError".format(SERVER_DOMAIN=SERVER_DOMAIN)
  547. return HttpResponseRedirect(red_url)
  548. print("Payment execute successfully")
  549. order_qs = Order_Model.objects.filter(orderID=orderID)
  550. nowTime = int(time.time())
  551. order_list = order_qs.values("UID", "channel", "commodity_code")
  552. UID = order_list[0]['UID']
  553. channel = order_list[0]['channel']
  554. commodity_code = order_list[0]['commodity_code']
  555. smqs = Store_Meal.objects.filter(commodity_code=commodity_code). \
  556. values("day", "bucket_id", "bucket__storeDay")
  557. bucketId = smqs[0]['bucket_id']
  558. if not smqs.exists():
  559. return response.json(0, '套餐已删除')
  560. addTime = int(smqs[0]["day"]) * 24 * 3600
  561. # ##
  562. ubqs = UID_Bucket.objects.filter(uid=UID, channel=channel, endTime__gte=nowTime). \
  563. values("bucket__storeDay", "bucket__region", "endTime")
  564. if ubqs.exists():
  565. ubqs_count = ubqs.count()
  566. ubq = ubqs[ubqs_count - 1, ubqs_count]
  567. new_starTime = ubq['endTime'] + 1
  568. ub_cqs = UID_Bucket.objects.create(uid=UID, channel=channel, bucket_id=bucketId,
  569. endTime=new_starTime + addTime)
  570. uid_bucket_id = ub_cqs.id
  571. else:
  572. ub_cqs = UID_Bucket.objects.create(uid=UID, channel=channel, bucket_id=bucketId, endTime=nowTime + addTime)
  573. uid_bucket_id = ub_cqs.id
  574. order_qs.update(status=1, updTime=nowTime, uid_bucket_id=uid_bucket_id)
  575. # return response.json(0)
  576. red_url = "{SERVER_DOMAIN}cloudVod/payOK".format(SERVER_DOMAIN=SERVER_DOMAIN)
  577. return HttpResponseRedirect(red_url)
  578. def do_create_pay_order(self, request_dict, userID, response):
  579. uid = request_dict.get('uid', None)
  580. channel = request_dict.get('channel', None)
  581. commodity_code = request_dict.get('commodity_code', None)
  582. pay_type = int(request_dict.get('pay_type', None))
  583. dv_qs = Device_Info.objects.filter(userID_id=userID, UID=uid, isShare=False, isExist=1)
  584. if not dv_qs.exists():
  585. return response.json(12)
  586. smqs = Store_Meal.objects.filter(commodity_code=commodity_code, type=pay_type). \
  587. values('currency', 'price', 'content', 'day', 'commodity_type', 'title', 'content')
  588. if not smqs.exists():
  589. return response.json(10, '套餐不存在')
  590. currency = smqs[0]['currency']
  591. price = smqs[0]['price']
  592. content = smqs[0]['content']
  593. day = smqs[0]['day']
  594. commodity_type = smqs[0]['commodity_type']
  595. # ubqs = UID_Bucket.objects.filter(uid=uid, channel=channel, endTime__gte=nowTime). \
  596. # values("bucket__storeDay", "bucket__region", "endTime")
  597. # if ubqs.exists():
  598. # ubqs_count = ubqs.count()
  599. # ubq = ubqs[ubqs_count - 1, ubqs_count]
  600. # new_starTime = ubq['endTime'] + 1
  601. nowTime = int(time.time())
  602. orderID = CommonService.createOrderID()
  603. if pay_type == 0:
  604. call_sub_url = "{SERVER_DOMAIN}cloudVod/dopaypalcallback?orderID={orderID}". \
  605. format(SERVER_DOMAIN=SERVER_DOMAIN, orderID=orderID)
  606. # call_sub_url = "http://192.168.136.40:8077/cloudVod/payExecute?orderID={orderID}".format(
  607. # SERVER_DOMAIN=SERVER_DOMAIN, orderID=orderID)
  608. call_clc_url = "{SERVER_DOMAIN}cloudVod/payError".format(SERVER_DOMAIN=SERVER_DOMAIN)
  609. paypalrestsdk.configure(PAYPAL_CRD)
  610. payment = paypalrestsdk.Payment({
  611. "intent": "sale",
  612. "payer": {"payment_method": "paypal"},
  613. "redirect_urls": {"return_url": call_sub_url, "cancel_url": call_clc_url},
  614. "transactions": [{
  615. "item_list": {"items": [
  616. {"name": "Cloud video", "sku": "1", "price": price, "currency": "USD", "quantity": 1}]},
  617. "amount": {"total": price, "currency": currency},
  618. "description": content}]})
  619. if payment.create():
  620. print("Payment created successfully")
  621. else:
  622. print(payment.error)
  623. return response.json(10, payment.error)
  624. print(payment)
  625. for link in payment.links:
  626. if link.rel == "approval_url":
  627. approval_url = str(link.href)
  628. print("Redirect for approval: %s" % (approval_url))
  629. Order_Model.objects.create(orderID=orderID, UID=uid, channel=channel, userID_id=userID,
  630. desc=content, payType=pay_type, payTime=nowTime,
  631. price=price, currency=currency, addTime=nowTime, updTime=nowTime,
  632. endTime=(nowTime + int(day) * 3600 * 24), pay_url=approval_url,
  633. commodity_code=commodity_code, commodity_type=commodity_type)
  634. return response.json(0, {"redirectUrl": approval_url, "orderID": orderID})
  635. return response.json(10, 'generate_order_false')
  636. else:
  637. try:
  638. aliPayObj = AliPayObject()
  639. alipay = aliPayObj.conf()
  640. subject = smqs[0]['title'] + smqs[0]['content']
  641. order_string = alipay.api_alipay_trade_wap_pay(
  642. out_trade_no=orderID,
  643. total_amount=price,
  644. subject=subject,
  645. return_url="{SERVER_DOMAIN_SSL}cloudVod/payOK".format(SERVER_DOMAIN_SSL=SERVER_DOMAIN_SSL),
  646. notify_url="{SERVER_DOMAIN_SSL}cloudVod/doalicallback".format(SERVER_DOMAIN_SSL=SERVER_DOMAIN_SSL)
  647. # return_url="http://192.168.136.40/cloudVod/payOK",
  648. # notify_url="http://192.168.136.40/cloudVod/aliPayCallback"
  649. )
  650. except Exception as e:
  651. print(repr(e))
  652. return response.json(10, repr(e))
  653. else:
  654. if order_string:
  655. redirectUrl = aliPayObj.alipay_prefix + order_string
  656. Order_Model.objects.create(orderID=orderID, UID=uid, channel=channel, userID_id=userID,
  657. desc=content, payType=pay_type, payTime=nowTime,
  658. price=price, currency=currency, addTime=nowTime, updTime=nowTime,
  659. endTime=(nowTime + int(day) * 3600 * 24), pay_url=redirectUrl,
  660. commodity_code=commodity_code, commodity_type=commodity_type)
  661. return JsonResponse(status=200, data={'result_code': 0, 'reason': 'success',
  662. 'result': {"redirectUrl": redirectUrl, "orderID": orderID},
  663. 'error_code': 0})
  664. else:
  665. return response.json(10, '生成订单错误')