CloudStorage.py 36 KB

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