EquipmentManager.py 30 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810
  1. import re
  2. import time
  3. import traceback
  4. import threading
  5. import simplejson as json
  6. from django.utils import timezone
  7. from Model.models import Device_User, Device_Info, UID_Bucket, UID_Preview, UidSetModel, Equipment_Info
  8. from django.db.models import Q
  9. from Object.ResponseObject import ResponseObject
  10. from Object.TokenObject import TokenObject
  11. from Service.CommonService import CommonService
  12. from Service.ModelService import ModelService
  13. from Ansjer.config import OSS_STS_ACCESS_SECRET, OSS_STS_ACCESS_KEY
  14. from Object.ETkObject import ETkObject
  15. import oss2
  16. from django.http import JsonResponse
  17. # 查询用户设备
  18. def queryUserEquipmentInterface(request):
  19. request.encoding = 'utf-8'
  20. response = ResponseObject()
  21. if request.method == 'POST':
  22. request_dict = request.POST
  23. elif request.method == 'GET':
  24. request_dict = request.GET
  25. else:
  26. return response.json(444)
  27. token = request_dict.get('token', None)
  28. tko = TokenObject(token)
  29. response.lang = tko.lang
  30. if tko.code != 0:
  31. return response.json(tko.code)
  32. userID = tko.userID
  33. if not userID:
  34. return response.json(309)
  35. dvqs = Device_Info.objects.filter(userID_id=userID)
  36. dvdict = CommonService.qs_to_dict(dvqs)
  37. uid_list = Device_Info.objects.filter(userID_id=userID, isShare=False). \
  38. values_list('UID', flat=True)
  39. ubqs = UID_Bucket.objects.filter(uid__in=uid_list). \
  40. values('bucket__content', 'status', 'channel', 'endTime', 'uid')
  41. res = []
  42. nowTime = int(time.time())
  43. for p in dvdict['datas']:
  44. p['fields']['vod'] = []
  45. for dm in ubqs:
  46. if p['fields']['UID'] == dm['uid']:
  47. if dm['endTime'] > nowTime:
  48. p['fields']['vod'].append(dm)
  49. # dm['valid'] = 1
  50. # else:
  51. # dm['valid'] = 0
  52. # p['fields']['primaryUserID'] = ''
  53. res.append(p)
  54. return response.json(0, {'datas': res})
  55. def addNewUserEquipmentInterface(request):
  56. request.encoding = 'utf-8'
  57. response = ResponseObject()
  58. if request.method == 'POST':
  59. request_dict = request.POST
  60. elif request.method == 'GET':
  61. request_dict = request.GET
  62. else:
  63. return response.json(444)
  64. token = request_dict.get('token', None)
  65. deviceContent = request_dict.get('content', None)
  66. if not deviceContent:
  67. return response.json(444, 'content')
  68. tko = TokenObject(token)
  69. response.lang = tko.lang
  70. if tko.code != 0:
  71. return response.json(tko.code)
  72. userID = tko.userID
  73. try:
  74. deviceData = json.loads(deviceContent)
  75. UID = deviceData.get('UID', None)
  76. if not UID:
  77. return response.json(444, 'content')
  78. dValid = Device_Info.objects.filter(userID_id=userID, UID=UID)
  79. if dValid:
  80. return response.json(174)
  81. else:
  82. UID = deviceData.get('UID', '')
  83. re_uid = re.compile(r'^[A-Za-z0-9]{20}$')
  84. if re_uid.match(UID):
  85. userDevice = Device_Info(id=CommonService.getUserID(getUser=False), userID_id=userID,
  86. **deviceData)
  87. userDevice.save()
  88. # is_bind = Device_Info.objects.filter(UID=UID, isShare=False)
  89. # # 判断是否有已绑定用户
  90. # if not is_bind.exists():
  91. # userDevice = Device_Info(id=CommonService.getUserID(getUser=False), userID_id=userID,
  92. # **deviceData)
  93. # userDevice.save()
  94. # else:
  95. # # 分享添加
  96. # if 'isShare' in deviceData:
  97. # deviceData['isShare'] = True
  98. # else:
  99. # deviceData['isShare'] = True
  100. # bind_userID = is_bind[0].userID_id
  101. # userDevice = Device_Info(id=CommonService.getUserID(getUser=False),
  102. # userID_id=userID,
  103. # primaryUserID=bind_userID,
  104. # primaryMaster=ModelService.get_user_name(bind_userID),
  105. # **deviceData)
  106. # userDevice.save()
  107. else:
  108. return response.json(444, 'UID')
  109. except Exception as e:
  110. errorInfo = traceback.format_exc()
  111. print('添加设备错误: %s ' % errorInfo)
  112. return response.json(178, repr(e))
  113. else:
  114. sqlDict = CommonService.qs_to_dict([userDevice])
  115. return response.json(0, sqlDict)
  116. def delUserEquipmentInterface(request):
  117. '''
  118. 删除用户设备
  119. :param request:
  120. :return:
  121. '''
  122. response = ResponseObject()
  123. request.encoding = 'utf-8'
  124. if request.method == 'POST':
  125. request_dict = request.POST
  126. elif request.method == 'GET':
  127. request_dict = request.GET
  128. else:
  129. return response.json(444)
  130. token = request_dict.get('token', None)
  131. id = request_dict.get('id', None)
  132. if not id:
  133. return response.json(444, 'id')
  134. tko = TokenObject(token)
  135. response.lang = tko.lang
  136. if tko.code != 0:
  137. return response.json(tko.code)
  138. userID = tko.userID
  139. # 主用户删除设备全部删除
  140. try:
  141. dv_qs = Device_Info.objects.filter(userID_id=userID, id=id)
  142. if dv_qs.exists():
  143. uid = dv_qs[0].UID
  144. dv_qs.delete()
  145. asy = threading.Thread(target=ModelService.del_eq_info, args=(userID, uid))
  146. asy.start()
  147. except Exception as e:
  148. errorInfo = traceback.format_exc()
  149. print('删除数据库记录错误: %s' % errorInfo)
  150. return response.json(176, repr(e))
  151. else:
  152. return response.json(0)
  153. def modifyUserEquipmentInterface(request):
  154. '''
  155. 修改用户设备
  156. :param request:
  157. :return:
  158. '''
  159. response = ResponseObject()
  160. if request.method == 'POST':
  161. request.encoding = 'utf-8'
  162. request_dict = request.POST
  163. elif request.method == 'GET':
  164. request.encoding = 'utf-8'
  165. request_dict = request.GET
  166. else:
  167. return response.json(444)
  168. token = request_dict.get('token', None)
  169. deviceContent = request_dict.get('content', None)
  170. id = request_dict.get('id', None)
  171. if not deviceContent or not id:
  172. return response.json(444, 'content,id')
  173. tko = TokenObject(token)
  174. response.lang = tko.lang
  175. if tko.code != 0:
  176. return response.json(tko.code)
  177. userID = tko.userID
  178. if userID is None:
  179. return response.json(309)
  180. try:
  181. deviceData = json.loads(deviceContent)
  182. Device_Info.objects.filter(userID_id=userID, id=id).update(**deviceData)
  183. except Exception as e:
  184. return response.json(177, repr(e))
  185. else:
  186. qs = Device_Info.objects.filter(userID_id=userID, id=id)
  187. res = CommonService.qs_to_dict(qs)
  188. return response.json(0, res)
  189. def showAllUserEquipmentInterface(request, *callback_args, **callback_kwargs):
  190. request.encoding = 'utf-8'
  191. response = ResponseObject()
  192. if request.method == 'POST':
  193. fieldDict = request.POST
  194. elif request.method == 'GET':
  195. fieldDict = request.GET
  196. else:
  197. return response.json(444)
  198. token = request.POST.get('token', None)
  199. type = request.POST.get('type', None)
  200. tko = TokenObject(token)
  201. response.lang = tko.lang
  202. if tko.code != 0:
  203. return response.json(tko.code)
  204. userID = tko.userID
  205. if not userID:
  206. return response.json(309)
  207. own_perm = ModelService.check_perm(userID=userID, permID=30)
  208. if not own_perm:
  209. return response.json(404)
  210. if type == 'PC':
  211. page = int(fieldDict['page'])
  212. line = int(fieldDict['line'])
  213. qs = Device_Info.objects.all()
  214. count = qs.count()
  215. res = qs[(page - 1) * line:page * line]
  216. sqlDict = CommonService.qs_to_dict(query_set=res)
  217. sqlDict['count'] = count
  218. return response.json(0, sqlDict)
  219. else:
  220. qs = Device_Info.objects.all()
  221. res = CommonService.qs_to_dict(qs)
  222. return response.json(0, res)
  223. def findEquipmentInfoInterface(request, *callback_args, **callback_kwargs):
  224. request.encoding = 'utf-8'
  225. response = ResponseObject()
  226. if request.method == 'GET':
  227. fieldDict = request.GET
  228. elif request.method == 'POST':
  229. fieldDict = request.POST
  230. else:
  231. return response.json(444)
  232. deviceContent = fieldDict.get('content', None)
  233. token = fieldDict.get('token', None)
  234. tko = TokenObject(token)
  235. response.lang = tko.lang
  236. if tko.code != 0:
  237. return response.json(tko.code)
  238. if deviceContent:
  239. try:
  240. searchCondition = json.loads(deviceContent)
  241. except Exception as e:
  242. print(repr(e))
  243. return response.json(10, repr(e))
  244. else:
  245. kwargs = CommonService.get_kwargs(data=searchCondition)
  246. qs = Device_Info.objects.filter(**kwargs)
  247. page = int(fieldDict['page'])
  248. line = int(fieldDict['line'])
  249. count = qs.count()
  250. res = qs[(page - 1) * line:page * line]
  251. send_dict = CommonService.qs_to_dict(query_set=res)
  252. for k, v in enumerate(send_dict["datas"]):
  253. for val in res:
  254. if v['pk'] == val.id:
  255. username = ModelService.get_user_name(send_dict["datas"][k]['fields']['userID'])
  256. send_dict["datas"][k]['fields']['username'] = username
  257. primary = ModelService.get_user_name(send_dict["datas"][k]['fields']['primaryUserID'])
  258. send_dict["datas"][k]['fields']['primaryusername'] = primary
  259. send_dict['count'] = count
  260. return response.json(0, send_dict)
  261. else:
  262. qs = Device_Info.objects.all()
  263. page = int(fieldDict['page'])
  264. line = int(fieldDict['line'])
  265. count = qs.count()
  266. res = qs[(page - 1) * line:page * line]
  267. send_dict = CommonService.qs_to_dict(query_set=res)
  268. for k, v in enumerate(send_dict["datas"]):
  269. for val in res:
  270. if v['pk'] == val.id:
  271. username = ModelService.get_user_name(send_dict["datas"][k]['fields']['userID'])
  272. send_dict["datas"][k]['fields']['username'] = username
  273. primary = ModelService.get_user_name(send_dict["datas"][k]['fields']['primaryUserID'])
  274. send_dict["datas"][k]['fields']['primaryusername'] = primary
  275. send_dict['count'] = count
  276. return response.json(0, send_dict)
  277. # 添加设备字段
  278. def addInterface(request):
  279. request.encoding = 'utf-8'
  280. response = ResponseObject()
  281. if request.method == 'POST':
  282. request_dict = request.POST
  283. elif request.method == 'GET':
  284. request_dict = request.GET
  285. else:
  286. return response.json(444)
  287. token = request_dict.get('token', None)
  288. UID = request_dict.get('UID', None)
  289. NickName = request_dict.get('NickName', None)
  290. View_Account = request_dict.get('View_Account', None)
  291. View_Password = request_dict.get('View_Password', '')
  292. Type = request_dict.get('Type', None)
  293. ChannelIndex = request_dict.get('ChannelIndex', None)
  294. if all([UID, NickName, View_Account, Type, ChannelIndex]):
  295. tko = TokenObject(token)
  296. response.lang = tko.lang
  297. if tko.code == 0:
  298. userID = tko.userID
  299. re_uid = re.compile(r'^[A-Za-z0-9]{20}$')
  300. if re_uid.match(UID):
  301. is_exist = Device_Info.objects.filter(UID=UID, userID_id=userID)
  302. if is_exist:
  303. return response.json(174)
  304. else:
  305. # is_bind = Device_Info.objects.filter(UID=UID, isShare=False)
  306. # # 判断是否有已绑定用户
  307. # if is_bind:
  308. # return response.json(15)
  309. try:
  310. pk = CommonService.getUserID(getUser=False)
  311. userDevice = Device_Info(id=pk, userID_id=userID, UID=UID,
  312. NickName=NickName, View_Account=View_Account,
  313. View_Password=View_Password, Type=Type, ChannelIndex=ChannelIndex)
  314. userDevice.save()
  315. except Exception as e:
  316. return response.json(10, repr(e))
  317. else:
  318. dvqs = Device_Info.objects.filter(id=pk).values('id', 'userID', 'NickName', 'UID',
  319. 'View_Account',
  320. 'View_Password', 'ChannelIndex', 'Type',
  321. 'isShare',
  322. 'primaryUserID', 'primaryMaster',
  323. 'data_joined', 'version',
  324. 'isVod', 'isExist')
  325. dvql = CommonService.qs_to_list(dvqs)
  326. ubqs = UID_Bucket.objects.filter(uid=UID). \
  327. values('bucket__content', 'status', 'channel', 'endTime', 'uid')
  328. res = dvql[0]
  329. res['vod'] = list(ubqs)
  330. return response.json(0, res)
  331. else:
  332. return response.json(444, {'param': 'UID'})
  333. else:
  334. return response.json(tko.code)
  335. else:
  336. return response.json(444, {'param': 'UID,NickName,View_Account,View_Password,Type,ChannelIndex'})
  337. # 管理员添加
  338. def admin_addInterface(request):
  339. request.encoding = 'utf-8'
  340. response = ResponseObject()
  341. if request.method == 'POST':
  342. request_dict = request.POST
  343. elif request.method == 'GET':
  344. request_dict = request.GET
  345. else:
  346. return response.json(444)
  347. token = request_dict.get('token', None)
  348. deviceContent = request_dict.get('content', None)
  349. username = request_dict.get('username', None)
  350. if not username:
  351. return response.json(444, 'username')
  352. if not deviceContent:
  353. return response.json(444, 'content')
  354. tko = TokenObject(token)
  355. response.lang = tko.lang
  356. if tko.code != 0:
  357. return response.json(tko.code)
  358. userID = tko.userID
  359. own_perm = ModelService.check_perm(userID, 40)
  360. # 权限判断
  361. if own_perm is not True:
  362. return response.json(404)
  363. # 查询id
  364. user = Device_User.objects.filter(Q(username=username) | Q(phone=username) | Q(userEmail=username))
  365. if user.exists():
  366. user_dict = CommonService.qs_to_dict(user)
  367. userID = user_dict.get('datas')[0].get('pk')
  368. else:
  369. return response.json(104)
  370. print(deviceContent)
  371. try:
  372. deviceData = json.loads(deviceContent)
  373. UID = deviceData.get('UID', None)
  374. if not UID:
  375. return response.json(444, 'content')
  376. dValid = Device_Info.objects.filter(userID_id=userID, UID=UID)
  377. if dValid:
  378. return response.json(174)
  379. else:
  380. UID = deviceData.get('UID', '')
  381. re_uid = re.compile(r'^[A-Za-z0-9]{20}$')
  382. if re_uid.match(UID):
  383. userDevice = Device_Info(id=CommonService.getUserID(getUser=False), userID_id=userID,
  384. **deviceData)
  385. userDevice.save()
  386. # is_bind = Device_Info.objects.filter(UID=UID, isShare=False)
  387. # # 判断是否有已绑定用户
  388. # if not is_bind.exists():
  389. # userDevice = Device_Info(id=CommonService.getUserID(getUser=False), userID_id=userID,
  390. # **deviceData)
  391. # userDevice.save()
  392. # else:
  393. # # 分享添加
  394. # if 'isShare' in deviceData:
  395. # deviceData['isShare'] = True
  396. # else:
  397. # deviceData['isShare'] = True
  398. # bind_userID = is_bind[0].userID_id
  399. # userDevice = Device_Info(id=CommonService.getUserID(getUser=False),
  400. # userID_id=userID,
  401. # primaryUserID=bind_userID,
  402. # primaryMaster=ModelService.get_user_name(bind_userID),
  403. # **deviceData)
  404. # userDevice.save()
  405. else:
  406. return response.json(444, 'UID')
  407. except Exception as e:
  408. errorInfo = traceback.format_exc()
  409. print('添加设备错误: %s ' % errorInfo)
  410. return response.json(178, repr(e))
  411. else:
  412. sqlDict = CommonService.qs_to_dict([userDevice])
  413. return response.json(0, sqlDict)
  414. # 超级管理员修改设备
  415. def admin_modifyInterface(request):
  416. response = ResponseObject()
  417. if request.method == 'POST':
  418. request.encoding = 'utf-8'
  419. request_dict = request.POST
  420. elif request.method == 'GET':
  421. request.encoding = 'utf-8'
  422. request_dict = request.GET
  423. else:
  424. return response.json(444)
  425. token = request_dict.get('token', None)
  426. deviceContent = request_dict.get('content', None)
  427. username = request_dict.get('username', None)
  428. if not username:
  429. return response.json(444, 'username')
  430. id = request_dict.get('id', None)
  431. print(deviceContent)
  432. if not deviceContent or not id:
  433. return response.json(444, 'content,id')
  434. tko = TokenObject(token)
  435. response.lang = tko.lang
  436. if tko.code != 0:
  437. return response.json(tko.code)
  438. userID = tko.userID
  439. if userID is None:
  440. return response.json(309)
  441. own_perm = ModelService.check_perm(userID, 50)
  442. # 权限判断
  443. if own_perm is not True:
  444. return response.json(404)
  445. deviceData = json.loads(deviceContent)
  446. print(deviceData['UID'])
  447. dValid = Device_Info.objects.filter(userID_id=userID, UID=deviceData['UID'])
  448. if dValid.exists():
  449. dValid_dict = CommonService.qs_to_dict(dValid)
  450. print(dValid_dict.get('datas')[0].get('pk'))
  451. if dValid_dict.get('datas')[0].get('pk') == id:
  452. print('可以编辑')
  453. else:
  454. return response.json(174)
  455. # 查询id
  456. user = Device_User.objects.filter(Q(username=username) | Q(phone=username) | Q(userEmail=username))
  457. if user.exists():
  458. user_dict = CommonService.qs_to_dict(user)
  459. userID = user_dict.get('datas')[0].get('pk')
  460. try:
  461. # 更改的时间
  462. update_time = timezone.localtime(timezone.now())
  463. Device_Info.objects.filter(userID_id=userID, id=id).update(update_time=update_time, **deviceData)
  464. except Exception as e:
  465. return response.json(177, repr(e))
  466. else:
  467. qs = Device_Info.objects.filter(userID_id=userID, id=id)
  468. res = CommonService.qs_to_dict(qs)
  469. return response.json(0, res)
  470. else:
  471. # 查询id
  472. user = Device_User.objects.filter(Q(username=username) | Q(phone=username) | Q(userEmail=username))
  473. if user.exists():
  474. user_dict = CommonService.qs_to_dict(user)
  475. userID = user_dict.get('datas')[0].get('pk')
  476. try:
  477. # 更改的时间
  478. update_time = timezone.localtime(timezone.now())
  479. Device_Info.objects.filter(userID_id=userID, id=id).update(update_time=update_time, **deviceData)
  480. except Exception as e:
  481. return response.json(177, repr(e))
  482. else:
  483. qs = Device_Info.objects.filter(userID_id=userID, id=id)
  484. res = CommonService.qs_to_dict(qs)
  485. return response.json(0, res)
  486. # 新删除设备
  487. def deleteInterface(request):
  488. '''
  489. 删除用户设备
  490. :param request:
  491. :return:
  492. '''
  493. response = ResponseObject()
  494. request.encoding = 'utf-8'
  495. if request.method == 'POST':
  496. request_dict = request.POST
  497. elif request.method == 'GET':
  498. request_dict = request.GET
  499. else:
  500. return response.json(444)
  501. token = request_dict.get('token', None)
  502. id = request_dict.get('id', None)
  503. if not id:
  504. return response.json(444, 'id')
  505. tko = TokenObject(token)
  506. response.lang = tko.lang
  507. if tko.code != 0:
  508. return response.json(tko.code)
  509. userID = tko.userID
  510. # 主用户删除设备全部删除
  511. if not userID:
  512. return response.json(309)
  513. try:
  514. dv_qs = Device_Info.objects.filter(userID_id=userID, id=id)
  515. if dv_qs.exists():
  516. uid = dv_qs[0].UID
  517. if dv_qs[0].isShare:
  518. dv_qs.delete()
  519. else:
  520. # 主用户删除设备
  521. dv_qs.delete()
  522. # 分享获得用户假删除
  523. ud_dv_qs = Device_Info.objects.filter(UID=uid, isShare=True, primaryUserID=userID)
  524. if ud_dv_qs.exists():
  525. ud_dv_qs.update(isExist=0)
  526. # 异步删除推送消息
  527. asy = threading.Thread(target=ModelService.del_eq_info, args=(userID, uid))
  528. asy.start()
  529. else:
  530. return response.json(14)
  531. except Exception as e:
  532. errorInfo = traceback.format_exc()
  533. print('删除数据库记录错误: %s' % errorInfo)
  534. return response.json(176, repr(e))
  535. else:
  536. return response.json(0)
  537. # 新查询设备字段
  538. def queryInterface(request):
  539. request.encoding = 'utf-8'
  540. response = ResponseObject()
  541. if request.method == 'POST':
  542. request_dict = request.POST
  543. elif request.method == 'GET':
  544. request_dict = request.GET
  545. else:
  546. return response.json(444)
  547. token = request_dict.get('token', None)
  548. page = request_dict.get('page', None)
  549. line = request_dict.get('line', None)
  550. NickName = request_dict.get('NickName', None)
  551. uid = request_dict.get('uid', None)
  552. page = int(page)
  553. line = int(line)
  554. tko = TokenObject(token)
  555. response.lang = tko.lang
  556. if tko.code == 0:
  557. userID = tko.userID
  558. dvqs = Device_Info.objects.filter(userID_id=userID)
  559. if NickName:
  560. dvqs = dvqs.filter(NickName__icontains=NickName)
  561. if uid:
  562. dvqs = dvqs.filter(UID=uid)
  563. # count = dvqs.count()
  564. dvql = dvqs[(page - 1) * line:page * line].values('id', 'userID', 'NickName', 'UID', 'View_Account',
  565. 'View_Password', 'ChannelIndex', 'Type', 'isShare',
  566. 'primaryUserID', 'primaryMaster', 'data_joined', 'version',
  567. 'isVod', 'isExist', 'NotificationMode')
  568. dvls = CommonService.qs_to_list(dvql)
  569. uid_list = []
  570. for dvl in dvls:
  571. uid_list.append(dvl['UID'])
  572. # if dvl['isShare'] is False:
  573. # uid_list.append(dvl['UID'])
  574. ubqs = UID_Bucket.objects.filter(uid__in=uid_list). \
  575. values('bucket__content', 'status', 'channel', 'endTime', 'uid')
  576. upqs = UID_Preview.objects.filter(uid__in=uid_list).order_by('channel').values('id', 'uid', 'channel')
  577. auth = oss2.Auth(OSS_STS_ACCESS_KEY, OSS_STS_ACCESS_SECRET)
  578. bucket = oss2.Bucket(auth, 'oss-cn-hongkong.aliyuncs.com', 'statres')
  579. nowTime = int(time.time())
  580. data = []
  581. # 设备拓展信息表
  582. us_qs = UidSetModel.objects.filter(uid__in=uid_list).values('uid', 'version')
  583. uv_dict = {}
  584. for us in us_qs:
  585. uv_dict[us['uid']] = us['version']
  586. for p in dvls:
  587. p['vod'] = []
  588. for dm in ubqs:
  589. if p['UID'] == dm['uid']:
  590. if dm['endTime'] > nowTime:
  591. p['vod'].append(dm)
  592. p['preview'] = []
  593. for up in upqs:
  594. if p['UID'] == up['uid']:
  595. obj = 'uid_preview/{uid}/channel_{channel}.png'.format(uid=up['uid'], channel=up['channel'])
  596. img_sign = bucket.sign_url('GET', obj, 300)
  597. p['preview'].append(img_sign)
  598. p['uid_version'] = uv_dict[p['UID']] if p['UID'] in uv_dict else ''
  599. data.append(p)
  600. return response.json(0, data)
  601. else:
  602. return response.json(tko.code)
  603. def uid_status(request):
  604. request.encoding = 'utf-8'
  605. response = ResponseObject()
  606. if request.method == 'POST':
  607. request_dict = request.POST
  608. elif request.method == 'GET':
  609. request_dict = request.GET
  610. else:
  611. return response.json(444)
  612. token = request_dict.get('token', None)
  613. uid = request_dict.get('uid', None)
  614. tko = TokenObject(token)
  615. response.lang = tko.lang
  616. if tko.code != 0:
  617. return response.json(tko.code)
  618. # 判断用户是否绑定设备
  619. qs = UidSetModel.objects.filter(uid=uid).values('uid', 'detect_status', 'detect_interval', 'version', 'ucode',
  620. 'p2p_region', 'tz', 'video_code', 'channel', 'cloud_vod')
  621. # 判断uid配置表信息是否存在
  622. if qs.exists():
  623. data = {
  624. 'push_status': qs[0]['detect_status'], # 推送状态
  625. 'push_interval': qs[0]['detect_interval'], # 推送间隔
  626. 'ucode': qs[0]['ucode'],
  627. 'version': qs[0]['version'],
  628. 'p2p_region': qs[0]['p2p_region'],
  629. 'tz': qs[0]['tz'],
  630. 'video_code': qs[0]['video_code'],
  631. 'channel': qs[0]['channel'],
  632. 'cloud_vod': qs[0]['cloud_vod'],
  633. }
  634. # 查询云存储相关信息
  635. ubqs = UID_Bucket.objects.filter(uid=uid). \
  636. values('bucket__content', 'status', 'channel', 'endTime', 'uid')
  637. nowTime = int(time.time())
  638. if ubqs.exists():
  639. if ubqs[0]['endTime'] > nowTime:
  640. data['vod'] = list(ubqs)
  641. return response.json(0, data)
  642. else:
  643. return response.json(0)
  644. def update_uid_set(request):
  645. request.encoding = 'utf-8'
  646. response = ResponseObject()
  647. if request.method == 'POST':
  648. request_dict = request.POST
  649. elif request.method == 'GET':
  650. request_dict = request.GET
  651. else:
  652. return response.json(444)
  653. token = request_dict.get('token', None)
  654. uid = request_dict.get('uid', None)
  655. version = request_dict.get('version', '')
  656. ucode = request_dict.get('ucode', '')
  657. tko = TokenObject(token)
  658. response.lang = tko.lang
  659. if tko.code == 0:
  660. userID = tko.userID
  661. nowTime = int(time.time())
  662. dvqs = Device_Info.objects.filter(userID_id=userID)
  663. if dvqs.exists():
  664. us_qs = UidSetModel.objects.filter(uid=uid)
  665. if us_qs.exists():
  666. uid_set_update_dict = {
  667. 'updTime': nowTime,
  668. 'version': version,
  669. 'ucode': ucode,
  670. }
  671. us_qs.update(**uid_set_update_dict)
  672. else:
  673. uid_set_create_dict = {
  674. 'uid': uid,
  675. 'addTime': nowTime,
  676. 'updTime': nowTime,
  677. 'version': version,
  678. 'ucode': ucode,
  679. }
  680. UidSetModel.objects.create(**uid_set_create_dict)
  681. return response.json(0)
  682. else:
  683. return response.json(14)
  684. else:
  685. return response.json(tko.code)
  686. # 设备影子更新
  687. def update_device_shadow(request):
  688. request.encoding = 'utf-8'
  689. response = ResponseObject()
  690. if request.method == 'POST':
  691. request_dict = request.POST
  692. elif request.method == 'GET':
  693. request_dict = request.GET
  694. else:
  695. return response.json(444)
  696. etk = request_dict.get('etk', None)
  697. eto = ETkObject(etk)
  698. uid = eto.uid
  699. if uid:
  700. ucode = request_dict.get('ucode', None)
  701. version = request_dict.get('version', None)
  702. p2p_region = request_dict.get('p2p_region', None)
  703. tz = request_dict.get('tz', None)
  704. video_code = request_dict.get('video_code', None)
  705. ip = CommonService.get_ip_address(request)
  706. is_reset = request_dict.get('is_reset', None)
  707. channel = request_dict.get('channel', None)
  708. cloud_vod = request_dict.get('cloud_vod', None)
  709. push_status = request_dict.get('push_status', None)
  710. # 传1则重置设备信息
  711. if is_reset == 1:
  712. UidSetModel.objects.filter(uid=uid).delete()
  713. us_qs = UidSetModel.objects.filter(uid=uid)
  714. # 更新
  715. nowTime = int(time.time())
  716. if us_qs.exists():
  717. update_dict = {
  718. 'updTime': nowTime,
  719. 'ip': ip
  720. }
  721. if channel:
  722. update_dict['channel'] = channel
  723. if p2p_region:
  724. update_dict['p2p_region'] = p2p_region
  725. if ucode:
  726. update_dict['ucode'] = ucode
  727. if version:
  728. update_dict['version'] = version
  729. if tz:
  730. update_dict['tz'] = tz
  731. if video_code:
  732. update_dict['video'] = video_code
  733. if cloud_vod:
  734. update_dict['cloud_vod'] = cloud_vod
  735. if push_status:
  736. update_dict['push_status'] = push_status
  737. us_qs.update(**update_dict)
  738. # 如果推送状态开启,返回推送url
  739. data = {}
  740. return JsonResponse(status=200, data={'code': 0, 'msg': 'success', 'data': {}})
  741. # 新增
  742. else:
  743. create_dict = {
  744. 'uid': uid,
  745. 'addTime': nowTime,
  746. 'updTime': nowTime,
  747. 'ip': ip
  748. }
  749. if channel:
  750. create_dict['channel'] = channel
  751. if p2p_region:
  752. create_dict['p2p_region'] = p2p_region
  753. if ucode:
  754. create_dict['ucode'] = ucode
  755. if version:
  756. create_dict['version'] = version
  757. if tz:
  758. create_dict['tz'] = tz
  759. if video_code:
  760. create_dict['video_code'] = video_code
  761. if cloud_vod:
  762. create_dict['cloud_vod'] = cloud_vod
  763. if push_status:
  764. create_dict['push_status'] = push_status
  765. UidSetModel.objects.create(**create_dict)
  766. # 如果推送状态开启,返回推送url
  767. return JsonResponse(status=200, data={'code': 0, 'msg': 'success', 'data': {}})
  768. else:
  769. return JsonResponse(status=200, data={'code': 403, 'msg': 'error etk'})