CloudStorage.py 29 KB

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