EquipmentManager.py 34 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895
  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, UidPushModel
  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. if qs.exists():
  189. uid = qs[0].UID
  190. nickname = qs[0].NickName
  191. # 增加设备影子信息修改昵称 start
  192. us_qs = UidSetModel.objects.filter(uid=uid)
  193. if us_qs.exists():
  194. us_qs.update(nickname=nickname)
  195. return response.json(0, res)
  196. def showAllUserEquipmentInterface(request, *callback_args, **callback_kwargs):
  197. request.encoding = 'utf-8'
  198. response = ResponseObject()
  199. if request.method == 'POST':
  200. fieldDict = request.POST
  201. elif request.method == 'GET':
  202. fieldDict = request.GET
  203. else:
  204. return response.json(444)
  205. token = request.POST.get('token', None)
  206. type = request.POST.get('type', None)
  207. tko = TokenObject(token)
  208. response.lang = tko.lang
  209. if tko.code != 0:
  210. return response.json(tko.code)
  211. userID = tko.userID
  212. if not userID:
  213. return response.json(309)
  214. own_perm = ModelService.check_perm(userID=userID, permID=30)
  215. if not own_perm:
  216. return response.json(404)
  217. if type == 'PC':
  218. page = int(fieldDict['page'])
  219. line = int(fieldDict['line'])
  220. qs = Device_Info.objects.all()
  221. count = qs.count()
  222. res = qs[(page - 1) * line:page * line]
  223. sqlDict = CommonService.qs_to_dict(query_set=res)
  224. sqlDict['count'] = count
  225. return response.json(0, sqlDict)
  226. else:
  227. qs = Device_Info.objects.all()
  228. res = CommonService.qs_to_dict(qs)
  229. return response.json(0, res)
  230. def findEquipmentInfoInterface(request, *callback_args, **callback_kwargs):
  231. request.encoding = 'utf-8'
  232. response = ResponseObject()
  233. if request.method == 'GET':
  234. fieldDict = request.GET
  235. elif request.method == 'POST':
  236. fieldDict = request.POST
  237. else:
  238. return response.json(444)
  239. deviceContent = fieldDict.get('content', None)
  240. token = fieldDict.get('token', None)
  241. tko = TokenObject(token)
  242. response.lang = tko.lang
  243. if tko.code != 0:
  244. return response.json(tko.code)
  245. if deviceContent:
  246. try:
  247. searchCondition = json.loads(deviceContent)
  248. except Exception as e:
  249. print(repr(e))
  250. return response.json(10, repr(e))
  251. else:
  252. kwargs = CommonService.get_kwargs(data=searchCondition)
  253. qs = Device_Info.objects.filter(**kwargs)
  254. page = int(fieldDict['page'])
  255. line = int(fieldDict['line'])
  256. count = qs.count()
  257. res = qs[(page - 1) * line:page * line]
  258. send_dict = CommonService.qs_to_dict(query_set=res)
  259. for k, v in enumerate(send_dict["datas"]):
  260. for val in res:
  261. if v['pk'] == val.id:
  262. username = ModelService.get_user_name(send_dict["datas"][k]['fields']['userID'])
  263. send_dict["datas"][k]['fields']['username'] = username
  264. primary = ModelService.get_user_name(send_dict["datas"][k]['fields']['primaryUserID'])
  265. send_dict["datas"][k]['fields']['primaryusername'] = primary
  266. send_dict['count'] = count
  267. return response.json(0, send_dict)
  268. else:
  269. qs = Device_Info.objects.all()
  270. page = int(fieldDict['page'])
  271. line = int(fieldDict['line'])
  272. count = qs.count()
  273. res = qs[(page - 1) * line:page * line]
  274. send_dict = CommonService.qs_to_dict(query_set=res)
  275. for k, v in enumerate(send_dict["datas"]):
  276. for val in res:
  277. if v['pk'] == val.id:
  278. username = ModelService.get_user_name(send_dict["datas"][k]['fields']['userID'])
  279. send_dict["datas"][k]['fields']['username'] = username
  280. primary = ModelService.get_user_name(send_dict["datas"][k]['fields']['primaryUserID'])
  281. send_dict["datas"][k]['fields']['primaryusername'] = primary
  282. send_dict['count'] = count
  283. return response.json(0, send_dict)
  284. # 添加设备字段
  285. def addInterface(request):
  286. request.encoding = 'utf-8'
  287. response = ResponseObject()
  288. if request.method == 'POST':
  289. request_dict = request.POST
  290. elif request.method == 'GET':
  291. request_dict = request.GET
  292. else:
  293. return response.json(444)
  294. token = request_dict.get('token', None)
  295. UID = request_dict.get('UID', None)
  296. NickName = request_dict.get('NickName', None)
  297. View_Account = request_dict.get('View_Account', None)
  298. View_Password = request_dict.get('View_Password', '')
  299. Type = request_dict.get('Type', None)
  300. ChannelIndex = request_dict.get('ChannelIndex', None)
  301. if all([UID, NickName, View_Account, Type, ChannelIndex]):
  302. tko = TokenObject(token)
  303. response.lang = tko.lang
  304. if tko.code == 0:
  305. userID = tko.userID
  306. re_uid = re.compile(r'^[A-Za-z0-9]{20}$')
  307. if re_uid.match(UID):
  308. is_exist = Device_Info.objects.filter(UID=UID, userID_id=userID)
  309. if is_exist:
  310. return response.json(174)
  311. else:
  312. # is_bind = Device_Info.objects.filter(UID=UID, isShare=False)
  313. # # 判断是否有已绑定用户
  314. # if is_bind:
  315. # return response.json(15)
  316. try:
  317. # 判断是否有用户绑定
  318. nowTime = int(time.time())
  319. us_qs = UidSetModel.objects.filter(uid=UID)
  320. if not us_qs.exists():
  321. uid_set_create_dict = {
  322. 'uid': UID,
  323. 'addTime': nowTime,
  324. 'updTime': nowTime,
  325. 'ip': CommonService.get_ip_address(request),
  326. 'channel': ChannelIndex,
  327. 'nickname': NickName,
  328. }
  329. UidSetModel.objects.create(**uid_set_create_dict)
  330. pk = CommonService.getUserID(getUser=False)
  331. userDevice = Device_Info(id=pk, userID_id=userID, UID=UID,
  332. NickName=NickName, View_Account=View_Account,
  333. View_Password=View_Password, Type=Type, ChannelIndex=ChannelIndex)
  334. userDevice.save()
  335. except Exception as e:
  336. return response.json(10, repr(e))
  337. else:
  338. dvqs = Device_Info.objects.filter(id=pk).values('id', 'userID', 'NickName', 'UID',
  339. 'View_Account',
  340. 'View_Password', 'ChannelIndex', 'Type',
  341. 'isShare',
  342. 'primaryUserID', 'primaryMaster',
  343. 'data_joined', 'version',
  344. 'isVod', 'isExist')
  345. dvql = CommonService.qs_to_list(dvqs)
  346. ubqs = UID_Bucket.objects.filter(uid=UID). \
  347. values('bucket__content', 'status', 'channel', 'endTime', 'uid')
  348. res = dvql[0]
  349. res['vod'] = list(ubqs)
  350. return response.json(0, res)
  351. else:
  352. return response.json(444, {'param': 'UID'})
  353. else:
  354. return response.json(tko.code)
  355. else:
  356. return response.json(444, {'param': 'UID,NickName,View_Account,View_Password,Type,ChannelIndex'})
  357. # 添加设备字段
  358. def judgeInterface(request):
  359. request.encoding = 'utf-8'
  360. response = ResponseObject()
  361. if request.method == 'POST':
  362. request_dict = request.POST
  363. elif request.method == 'GET':
  364. request_dict = request.GET
  365. else:
  366. return response.json(444)
  367. token = request_dict.get('token', None)
  368. uid = request_dict.get('uid', None)
  369. if all([uid, token]):
  370. tko = TokenObject(token)
  371. response.lang = tko.lang
  372. if tko.code == 0:
  373. re_uid = re.compile(r'^[A-Za-z0-9]{20}$')
  374. if re_uid.match(uid):
  375. is_bind = Device_Info.objects.filter(UID=uid, isShare=False)
  376. # 判断是否有已绑定用户
  377. if is_bind:
  378. qs = is_bind.values('userID__NickName', 'NickName')
  379. nickname = qs[0]['NickName']
  380. us_qs = UidSetModel.objects.filter(uid=uid).values('nickname')
  381. if us_qs.exists():
  382. nickname = us_qs[0]['NickName']
  383. res = {
  384. 'bind_user': qs[0]['userID__NickName'],
  385. 'bind_device_name': nickname,
  386. }
  387. return response.json(15, res=res)
  388. else:
  389. return response.json(0, 'no bind user')
  390. else:
  391. return response.json(444, {'param': 'UID'})
  392. else:
  393. return response.json(tko.code)
  394. else:
  395. return response.json(444, {'param': 'UID,NickName,View_Account,View_Password,Type,ChannelIndex'})
  396. # 管理员添加
  397. def admin_addInterface(request):
  398. request.encoding = 'utf-8'
  399. response = ResponseObject()
  400. if request.method == 'POST':
  401. request_dict = request.POST
  402. elif request.method == 'GET':
  403. request_dict = request.GET
  404. else:
  405. return response.json(444)
  406. token = request_dict.get('token', None)
  407. deviceContent = request_dict.get('content', None)
  408. username = request_dict.get('username', None)
  409. if not username:
  410. return response.json(444, 'username')
  411. if not deviceContent:
  412. return response.json(444, 'content')
  413. tko = TokenObject(token)
  414. response.lang = tko.lang
  415. if tko.code != 0:
  416. return response.json(tko.code)
  417. userID = tko.userID
  418. own_perm = ModelService.check_perm(userID, 40)
  419. # 权限判断
  420. if own_perm is not True:
  421. return response.json(404)
  422. # 查询id
  423. user = Device_User.objects.filter(Q(username=username) | Q(phone=username) | Q(userEmail=username))
  424. if user.exists():
  425. user_dict = CommonService.qs_to_dict(user)
  426. userID = user_dict.get('datas')[0].get('pk')
  427. else:
  428. return response.json(104)
  429. print(deviceContent)
  430. try:
  431. deviceData = json.loads(deviceContent)
  432. UID = deviceData.get('UID', None)
  433. if not UID:
  434. return response.json(444, 'content')
  435. dValid = Device_Info.objects.filter(userID_id=userID, UID=UID)
  436. if dValid:
  437. return response.json(174)
  438. else:
  439. UID = deviceData.get('UID', '')
  440. re_uid = re.compile(r'^[A-Za-z0-9]{20}$')
  441. if re_uid.match(UID):
  442. userDevice = Device_Info(id=CommonService.getUserID(getUser=False), userID_id=userID,
  443. **deviceData)
  444. userDevice.save()
  445. # is_bind = Device_Info.objects.filter(UID=UID, isShare=False)
  446. # # 判断是否有已绑定用户
  447. # if not is_bind.exists():
  448. # userDevice = Device_Info(id=CommonService.getUserID(getUser=False), userID_id=userID,
  449. # **deviceData)
  450. # userDevice.save()
  451. # else:
  452. # # 分享添加
  453. # if 'isShare' in deviceData:
  454. # deviceData['isShare'] = True
  455. # else:
  456. # deviceData['isShare'] = True
  457. # bind_userID = is_bind[0].userID_id
  458. # userDevice = Device_Info(id=CommonService.getUserID(getUser=False),
  459. # userID_id=userID,
  460. # primaryUserID=bind_userID,
  461. # primaryMaster=ModelService.get_user_name(bind_userID),
  462. # **deviceData)
  463. # userDevice.save()
  464. else:
  465. return response.json(444, 'UID')
  466. except Exception as e:
  467. errorInfo = traceback.format_exc()
  468. print('添加设备错误: %s ' % errorInfo)
  469. return response.json(178, repr(e))
  470. else:
  471. sqlDict = CommonService.qs_to_dict([userDevice])
  472. return response.json(0, sqlDict)
  473. # 超级管理员修改设备
  474. def admin_modifyInterface(request):
  475. response = ResponseObject()
  476. if request.method == 'POST':
  477. request.encoding = 'utf-8'
  478. request_dict = request.POST
  479. elif request.method == 'GET':
  480. request.encoding = 'utf-8'
  481. request_dict = request.GET
  482. else:
  483. return response.json(444)
  484. token = request_dict.get('token', None)
  485. deviceContent = request_dict.get('content', None)
  486. username = request_dict.get('username', None)
  487. if not username:
  488. return response.json(444, 'username')
  489. id = request_dict.get('id', None)
  490. print(deviceContent)
  491. if not deviceContent or not id:
  492. return response.json(444, 'content,id')
  493. tko = TokenObject(token)
  494. response.lang = tko.lang
  495. if tko.code != 0:
  496. return response.json(tko.code)
  497. userID = tko.userID
  498. if userID is None:
  499. return response.json(309)
  500. own_perm = ModelService.check_perm(userID, 50)
  501. # 权限判断
  502. if own_perm is not True:
  503. return response.json(404)
  504. deviceData = json.loads(deviceContent)
  505. print(deviceData['UID'])
  506. dValid = Device_Info.objects.filter(userID_id=userID, UID=deviceData['UID'])
  507. if dValid.exists():
  508. dValid_dict = CommonService.qs_to_dict(dValid)
  509. print(dValid_dict.get('datas')[0].get('pk'))
  510. if dValid_dict.get('datas')[0].get('pk') == id:
  511. print('可以编辑')
  512. else:
  513. return response.json(174)
  514. # 查询id
  515. user = Device_User.objects.filter(Q(username=username) | Q(phone=username) | Q(userEmail=username))
  516. if user.exists():
  517. user_dict = CommonService.qs_to_dict(user)
  518. userID = user_dict.get('datas')[0].get('pk')
  519. try:
  520. # 更改的时间
  521. update_time = timezone.localtime(timezone.now())
  522. Device_Info.objects.filter(userID_id=userID, id=id).update(update_time=update_time, **deviceData)
  523. except Exception as e:
  524. return response.json(177, repr(e))
  525. else:
  526. qs = Device_Info.objects.filter(userID_id=userID, id=id)
  527. res = CommonService.qs_to_dict(qs)
  528. return response.json(0, res)
  529. else:
  530. # 查询id
  531. user = Device_User.objects.filter(Q(username=username) | Q(phone=username) | Q(userEmail=username))
  532. if user.exists():
  533. user_dict = CommonService.qs_to_dict(user)
  534. userID = user_dict.get('datas')[0].get('pk')
  535. try:
  536. # 更改的时间
  537. update_time = timezone.localtime(timezone.now())
  538. Device_Info.objects.filter(userID_id=userID, id=id).update(update_time=update_time, **deviceData)
  539. except Exception as e:
  540. return response.json(177, repr(e))
  541. else:
  542. qs = Device_Info.objects.filter(userID_id=userID, id=id)
  543. res = CommonService.qs_to_dict(qs)
  544. return response.json(0, res)
  545. # 新删除设备
  546. def deleteInterface(request):
  547. '''
  548. 删除用户设备
  549. :param request:
  550. :return:
  551. '''
  552. response = ResponseObject()
  553. request.encoding = 'utf-8'
  554. if request.method == 'POST':
  555. request_dict = request.POST
  556. elif request.method == 'GET':
  557. request_dict = request.GET
  558. else:
  559. return response.json(444)
  560. token = request_dict.get('token', None)
  561. id = request_dict.get('id', None)
  562. if not id:
  563. return response.json(444, 'id')
  564. tko = TokenObject(token)
  565. response.lang = tko.lang
  566. if tko.code != 0:
  567. return response.json(tko.code)
  568. userID = tko.userID
  569. # 主用户删除设备全部删除
  570. if not userID:
  571. return response.json(309)
  572. try:
  573. dv_qs = Device_Info.objects.filter(userID_id=userID, id=id)
  574. if dv_qs.exists():
  575. uid = dv_qs[0].UID
  576. if dv_qs[0].isShare:
  577. dv_qs.delete()
  578. else:
  579. # a.主用户删除设备
  580. dv_qs.delete()
  581. # 删除设备影子信息uid_set 外键关联删除设备推送配置信息 uid_push
  582. up_qs = UidPushModel.objects.filter(uid_set__uid=uid)
  583. if up_qs.count() > 1:
  584. UidPushModel.objects.filter(uid_set__uid=uid, userID_id=userID).delete()
  585. else:
  586. up_qs.delete()
  587. # b.分享获得用户假删除
  588. ud_dv_qs = Device_Info.objects.filter(UID=uid, isShare=True, primaryUserID=userID)
  589. if ud_dv_qs.exists():
  590. ud_dv_qs.update(isExist=0)
  591. # 异步删除推送消息
  592. asy = threading.Thread(target=ModelService.del_eq_info, args=(userID, uid))
  593. asy.start()
  594. else:
  595. return response.json(14)
  596. except Exception as e:
  597. errorInfo = traceback.format_exc()
  598. print('删除数据库记录错误: %s' % errorInfo)
  599. return response.json(176, repr(e))
  600. else:
  601. return response.json(0)
  602. # 新查询设备字段
  603. def queryInterface(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. page = request_dict.get('page', None)
  614. line = request_dict.get('line', None)
  615. NickName = request_dict.get('NickName', None)
  616. uid = request_dict.get('uid', None)
  617. page = int(page)
  618. line = int(line)
  619. tko = TokenObject(token)
  620. response.lang = tko.lang
  621. if page <= 0:
  622. return response.json(0)
  623. if tko.code == 0:
  624. userID = tko.userID
  625. dvqs = Device_Info.objects.filter(userID_id=userID)
  626. if NickName:
  627. dvqs = dvqs.filter(NickName__icontains=NickName)
  628. if uid:
  629. dvqs = dvqs.filter(UID=uid)
  630. # count = dvqs.count()
  631. dvql = dvqs[(page - 1) * line:page * line].values('id', 'userID', 'NickName', 'UID', 'View_Account',
  632. 'View_Password', 'ChannelIndex', 'Type', 'isShare',
  633. 'primaryUserID', 'primaryMaster', 'data_joined', 'version',
  634. 'isVod', 'isExist', 'NotificationMode')
  635. dvls = CommonService.qs_to_list(dvql)
  636. uid_list = []
  637. for dvl in dvls:
  638. uid_list.append(dvl['UID'])
  639. # if dvl['isShare'] is False:
  640. # uid_list.append(dvl['UID'])
  641. ubqs = UID_Bucket.objects.filter(uid__in=uid_list). \
  642. values('bucket__content', 'status', 'channel', 'endTime', 'uid')
  643. upqs = UID_Preview.objects.filter(uid__in=uid_list).order_by('channel').values('id', 'uid', 'channel')
  644. auth = oss2.Auth(OSS_STS_ACCESS_KEY, OSS_STS_ACCESS_SECRET)
  645. bucket = oss2.Bucket(auth, 'oss-cn-hongkong.aliyuncs.com', 'statres')
  646. nowTime = int(time.time())
  647. data = []
  648. # 设备拓展信息表
  649. us_qs = UidSetModel.objects.filter(uid__in=uid_list).values('uid', 'version', 'nickname')
  650. uv_dict = {}
  651. for us in us_qs:
  652. uv_dict[us['uid']] = {'version': us['version'], 'nickname': us['nickname']}
  653. for p in dvls:
  654. p['vod'] = []
  655. for dm in ubqs:
  656. if p['UID'] == dm['uid']:
  657. if dm['endTime'] > nowTime:
  658. p['vod'].append(dm)
  659. p['preview'] = []
  660. for up in upqs:
  661. if p['UID'] == up['uid']:
  662. obj = 'uid_preview/{uid}/channel_{channel}.png'.format(uid=up['uid'], channel=up['channel'])
  663. img_sign = bucket.sign_url('GET', obj, 300)
  664. p['preview'].append(img_sign)
  665. p_uid = p['UID']
  666. if p_uid in uv_dict:
  667. # 设备版本号
  668. p['uid_version'] = uv_dict[p_uid]['version']
  669. # 设备昵称 调用影子信息昵称,先阶段不可
  670. # if uv_dict[p_uid]['nickname']:
  671. # p['NickName'] = uv_dict[p_uid]['nickname']
  672. else:
  673. # 设备版本号
  674. p['uid_version'] = ''
  675. data.append(p)
  676. return response.json(0, data)
  677. else:
  678. return response.json(tko.code)
  679. def uid_status(request):
  680. request.encoding = 'utf-8'
  681. response = ResponseObject()
  682. if request.method == 'POST':
  683. request_dict = request.POST
  684. elif request.method == 'GET':
  685. request_dict = request.GET
  686. else:
  687. return response.json(444)
  688. token = request_dict.get('token', None)
  689. uid = request_dict.get('uid', None)
  690. tko = TokenObject(token)
  691. response.lang = tko.lang
  692. if tko.code != 0:
  693. return response.json(tko.code)
  694. userID = tko.userID
  695. # 判断用户是否绑定设备
  696. qs = UidSetModel.objects.filter(uid=uid).values('uid', 'detect_status', 'detect_interval', 'version', 'ucode',
  697. 'p2p_region', 'tz', 'video_code', 'channel', 'cloud_vod', 'id')
  698. # 判断uid配置表信息是否存在
  699. if qs.exists():
  700. # 获取uid推送是否添加过
  701. us_id = qs[0]['id']
  702. if UidPushModel.objects.filter(uid_set_id=us_id, userID_id=userID).exists():
  703. detect_status = qs[0]['detect_status']
  704. else:
  705. detect_status = 0
  706. data = {
  707. 'push_status': detect_status, # 推送状态
  708. 'push_interval': qs[0]['detect_interval'], # 推送间隔
  709. 'ucode': qs[0]['ucode'],
  710. 'version': qs[0]['version'],
  711. 'p2p_region': qs[0]['p2p_region'],
  712. 'tz': qs[0]['tz'],
  713. 'video_code': qs[0]['video_code'],
  714. 'channel': qs[0]['channel'],
  715. 'cloud_vod': qs[0]['cloud_vod'],
  716. }
  717. # 查询云存储相关信息
  718. ubqs = UID_Bucket.objects.filter(uid=uid). \
  719. values('bucket__content', 'status', 'channel', 'endTime', 'uid')
  720. nowTime = int(time.time())
  721. if ubqs.exists():
  722. if ubqs[0]['endTime'] > nowTime:
  723. data['vod'] = list(ubqs)
  724. return response.json(0, data)
  725. else:
  726. return response.json(0)
  727. def update_uid_set(request):
  728. request.encoding = 'utf-8'
  729. response = ResponseObject()
  730. if request.method == 'POST':
  731. request_dict = request.POST
  732. elif request.method == 'GET':
  733. request_dict = request.GET
  734. else:
  735. return response.json(444)
  736. token = request_dict.get('token', None)
  737. uid = request_dict.get('uid', None)
  738. version = request_dict.get('version', '')
  739. ucode = request_dict.get('ucode', '')
  740. tko = TokenObject(token)
  741. response.lang = tko.lang
  742. if tko.code == 0:
  743. userID = tko.userID
  744. nowTime = int(time.time())
  745. dvqs = Device_Info.objects.filter(userID_id=userID)
  746. if dvqs.exists():
  747. us_qs = UidSetModel.objects.filter(uid=uid)
  748. if us_qs.exists():
  749. uid_set_update_dict = {
  750. 'updTime': nowTime,
  751. 'version': version,
  752. 'ucode': ucode,
  753. }
  754. us_qs.update(**uid_set_update_dict)
  755. else:
  756. uid_set_create_dict = {
  757. 'uid': uid,
  758. 'addTime': nowTime,
  759. 'updTime': nowTime,
  760. 'version': version,
  761. 'ucode': ucode,
  762. }
  763. UidSetModel.objects.create(**uid_set_create_dict)
  764. return response.json(0)
  765. else:
  766. return response.json(14)
  767. else:
  768. return response.json(tko.code)
  769. # 设备影子更新
  770. def update_device_shadow(request):
  771. request.encoding = 'utf-8'
  772. response = ResponseObject()
  773. if request.method == 'POST':
  774. request_dict = request.POST
  775. elif request.method == 'GET':
  776. request_dict = request.GET
  777. else:
  778. return response.json(444)
  779. etk = request_dict.get('etk', None)
  780. eto = ETkObject(etk)
  781. uid = eto.uid
  782. if uid:
  783. ucode = request_dict.get('ucode', None)
  784. version = request_dict.get('version', None)
  785. p2p_region = request_dict.get('p2p_region', None)
  786. tz = request_dict.get('tz', None)
  787. video_code = request_dict.get('video_code', None)
  788. ip = CommonService.get_ip_address(request)
  789. is_reset = request_dict.get('is_reset', None)
  790. channel = request_dict.get('channel', None)
  791. cloud_vod = request_dict.get('cloud_vod', None)
  792. push_status = request_dict.get('push_status', None)
  793. # 传1则重置设备信息
  794. if is_reset == 1:
  795. UidSetModel.objects.filter(uid=uid).delete()
  796. us_qs = UidSetModel.objects.filter(uid=uid)
  797. # 更新
  798. nowTime = int(time.time())
  799. if us_qs.exists():
  800. update_dict = {
  801. 'updTime': nowTime,
  802. 'ip': ip
  803. }
  804. if channel:
  805. update_dict['channel'] = channel
  806. if p2p_region:
  807. update_dict['p2p_region'] = p2p_region
  808. if ucode:
  809. update_dict['ucode'] = ucode
  810. if version:
  811. update_dict['version'] = version
  812. if tz:
  813. update_dict['tz'] = tz
  814. if video_code:
  815. update_dict['video'] = video_code
  816. if cloud_vod:
  817. update_dict['cloud_vod'] = cloud_vod
  818. if push_status:
  819. update_dict['push_status'] = push_status
  820. us_qs.update(**update_dict)
  821. # 如果推送状态开启,返回推送url
  822. data = {}
  823. return JsonResponse(status=200, data={'code': 0, 'msg': 'success', 'data': {}})
  824. # 新增
  825. else:
  826. create_dict = {
  827. 'uid': uid,
  828. 'addTime': nowTime,
  829. 'updTime': nowTime,
  830. 'ip': ip
  831. }
  832. if channel:
  833. create_dict['channel'] = channel
  834. if p2p_region:
  835. create_dict['p2p_region'] = p2p_region
  836. if ucode:
  837. create_dict['ucode'] = ucode
  838. if version:
  839. create_dict['version'] = version
  840. if tz:
  841. create_dict['tz'] = tz
  842. if video_code:
  843. create_dict['video_code'] = video_code
  844. if cloud_vod:
  845. create_dict['cloud_vod'] = cloud_vod
  846. if push_status:
  847. create_dict['push_status'] = push_status
  848. UidSetModel.objects.create(**create_dict)
  849. # 如果推送状态开启,返回推送url
  850. return JsonResponse(status=200, data={'code': 0, 'msg': 'success', 'data': {}})
  851. else:
  852. return JsonResponse(status=200, data={'code': 403, 'msg': 'error etk'})