EquipmentInfo.py 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319
  1. from django.views.generic.base import View
  2. from django.utils.decorators import method_decorator
  3. from django.views.decorators.csrf import csrf_exempt
  4. from Service.ModelService import ModelService
  5. from Service.CommonService import CommonService
  6. from Model.models import Equipment_Info, Device_Info, Device_User
  7. import traceback
  8. from Object.ResponseObject import ResponseObject
  9. from Object.TokenObject import TokenObject
  10. from django.views.generic import TemplateView
  11. from Ansjer.config import UID_TOKEN_KEY, SERVER_DOMAIN
  12. from Object.UidTokenObject import UidTokenObject
  13. '''
  14. http://192.168.136.45:8077/equipment/info?token=test&devUid=2N1K3LE78TYJ38CE111A&Channel=0&eventType=1&eventTime=1234567890&operation=add&alarm=21342134&receiveTime=1234567891234567
  15. http://test.dvema.com/equipment/info?token=test&operation=query&page=1&line=10
  16. http://192.168.136.45:8077/equipment/info?token=test&operation=delete&devUid=UKPAH63V23U4ZHEB111A&id=5&id=6&id=7
  17. http://192.168.136.40:8077/equipment/info?token=test&operation=update&devUid=UKPAH63V23U4ZHEB111A&id=3&id=4
  18. http://192.168.136.45:8077/equipment/info?token=test&operation=queryByAdmin&page=1&line=10&userID_id=151547867345163613800138001
  19. http://192.168.136.45:8077/equipment/info?token=test&operation=deleteByAdmin&id=5&id=6&id=7
  20. '''
  21. class EquipmentInfo(View):
  22. @method_decorator(csrf_exempt)
  23. def dispatch(self, *args, **kwargs):
  24. return super(EquipmentInfo, self).dispatch(*args, **kwargs)
  25. def get(self, request, *args, **kwargs):
  26. request.encoding = 'utf-8'
  27. return self.validation(request_dict=request.GET)
  28. def post(self, request, *args, **kwargs):
  29. request.encoding = 'utf-8'
  30. return self.validation(request_dict=request.POST)
  31. def validation(self, request_dict, *args, **kwargs):
  32. token = request_dict.get('token', None)
  33. response = ResponseObject()
  34. tko = TokenObject(token)
  35. tko.valid()
  36. if tko.code != 0:
  37. return response.json(tko.code)
  38. userID = tko.userID
  39. operation = request_dict.get('operation', None)
  40. if not userID:
  41. return response.json(444, 'operation')
  42. if operation == 'query':
  43. return self.query_info(request_dict, userID, response)
  44. elif operation == 'add':
  45. return self.add_info(request_dict, userID, response)
  46. elif operation == 'update':
  47. return self.update_info(request_dict, userID, response)
  48. elif operation == 'delete':
  49. return self.delete_info(request_dict, userID, response)
  50. elif operation == 'findByTime':
  51. return self.findByTime_info(request_dict, userID, response)
  52. if operation == 'queryByAdmin':
  53. return self.query_all_info(request_dict, userID, response)
  54. if operation == 'deleteByAdmin':
  55. return self.delete_by_admin(request_dict, userID, response)
  56. else:
  57. return response.json(444, 'operation')
  58. def add_info(self, request_dict, userID, response):
  59. devUid = request_dict.get('devUid', None)
  60. Channel = request_dict.get('Channel', None)
  61. eventType = request_dict.get('eventType', None)
  62. eventTime = request_dict.get('eventTime', None)
  63. receiveTime = request_dict.get('receiveTime', None)
  64. alarm = request_dict.get('alarm', None)
  65. if not devUid or not Channel or not eventType or not eventTime or not alarm or not receiveTime:
  66. return response.json(444, 'devUid, Channel, eventType, eventTime, alarm, receiveTime')
  67. own_device = ModelService.check_own_device(userID, UID=devUid)
  68. if own_device is not True:
  69. return response.json(14)
  70. device_info = Device_Info.objects.filter(UID=devUid, userID_id=userID)
  71. if not device_info.exists():
  72. return response.json(14)
  73. try:
  74. equipment_info = Equipment_Info(
  75. userID=Device_User.objects.get(userID=userID),
  76. devUid=devUid,
  77. Channel=Channel,
  78. eventType=eventType,
  79. receiveTime=receiveTime,
  80. eventTime=eventTime,
  81. devNickName=device_info[0].NickName,
  82. alarm=alarm
  83. )
  84. equipment_info.save()
  85. except Exception:
  86. errorInfo = traceback.format_exc()
  87. print(errorInfo)
  88. return response.json(500, errorInfo)
  89. else:
  90. if equipment_info.id:
  91. return response.json(0, {'infoID': equipment_info.id,
  92. 'devUid': devUid,
  93. 'Channel': Channel,
  94. 'alarm': alarm,
  95. 'eventType': eventType,
  96. 'eventTime': eventTime,
  97. 'receiveTime': receiveTime,
  98. 'devNickName': equipment_info.devNickName})
  99. else:
  100. return response.json(500)
  101. def query_info(self, request_dict, userID, response):
  102. page = int(request_dict.get('page', None))
  103. line = int(request_dict.get('line', None))
  104. if not page or not line:
  105. return response.json(444, 'page,line')
  106. qs = Equipment_Info.objects.filter(userID_id=userID)
  107. uid = request_dict.get('uid', None)
  108. if uid:
  109. qs.filter(devUid=uid)
  110. if not qs.exists():
  111. return response.json(0, {'datas': [], 'count': 0})
  112. count = qs.count()
  113. res = qs[(page - 1) * line:page * line]
  114. send_json = CommonService.qs_to_dict(res)
  115. send_json['count'] = count
  116. return response.json(0, send_json)
  117. def update_info(self, request_dict, userID, response):
  118. id_list = request_dict.getlist('id[]', None)
  119. if id_list is None or len(id_list) < 1:
  120. id_list = request_dict.getlist('id', None)
  121. param_flag = CommonService.get_param_flag(data=[id_list])
  122. if param_flag is True:
  123. count = 0
  124. for id in id_list:
  125. try:
  126. eq = Equipment_Info.objects.filter(id=int(id))
  127. if eq.exists():
  128. own_dev = ModelService.check_own_device(userID, eq[0].devUid)
  129. if own_dev is True:
  130. count += 1
  131. eq.update(status=1)
  132. except Exception as e:
  133. print(repr(e))
  134. return response.json(0, {'update_success': count})
  135. else:
  136. return response.json(444)
  137. def delete_info(self, request_dict, userID, response):
  138. id_list = request_dict.getlist('id[]', None)
  139. if id_list is None or len(id_list) < 1:
  140. id_list = request_dict.getlist('id', None)
  141. param_flag = CommonService.get_param_flag(data=[id_list])
  142. if param_flag is True:
  143. try:
  144. for id in id_list:
  145. eq = Equipment_Info.objects.filter(id=id)
  146. if eq.exists():
  147. own_dev = ModelService.check_own_device(userID, eq[0].devUid)
  148. if own_dev is True:
  149. eq.delete()
  150. except Exception as e:
  151. errorInfo = traceback.format_exc()
  152. print(errorInfo)
  153. return response.json(424, repr(e))
  154. else:
  155. return response.json(0)
  156. else:
  157. return response.json(444)
  158. def findByTime_info(self, request_dict, userID, response):
  159. startTime = request_dict.get('startTime')
  160. endTime = request_dict.get('endTime')
  161. page = int(request_dict.get('page', None))
  162. line = int(request_dict.get('line', None))
  163. if not startTime or not endTime or not page or not line:
  164. return response.json(444, 'startTime, endTime, page, line')
  165. uid_list = Device_Info.objects.filter(userID_id=userID).values_list('UID', flat=True)
  166. if not len(uid_list):
  167. return response.json(0, {'datas': [], 'count': 0})
  168. qs = Equipment_Info.objects.filter(userID_id=userID,
  169. eventTime__range=(startTime, endTime)).order_by('-id')
  170. if qs.exists():
  171. count = qs.count()
  172. res = qs[(page - 1) * line:page * line]
  173. send_json = CommonService.qs_to_dict(res)
  174. send_json['count'] = count
  175. return response.json(0, send_json)
  176. def query_all_info(self, request_dict, userID, response):
  177. page = int(request_dict.get('page', None))
  178. line = int(request_dict.get('line', None))
  179. userID_id = request_dict.get('userID_id', None)
  180. if not page or not line:
  181. return response.json(444, 'page,line')
  182. check_perm = ModelService.check_permission(userID=userID, permID=30)
  183. if not check_perm:
  184. return response.json(404)
  185. uid_list = Device_Info.objects.filter(userID_id=userID_id).values_list('UID', flat=True)
  186. if not len(uid_list):
  187. return response.json(0, {'datas': [], 'count': 0})
  188. qs = Equipment_Info.objects.filter(userID_id=userID_id).order_by('-id')
  189. if not qs.exists():
  190. return response.json(0, {'datas': [], 'count': 0})
  191. count = qs.count()
  192. res = qs[(page - 1) * line:page * line]
  193. send_json = CommonService.qs_to_dict(res)
  194. send_json['count'] = count
  195. return response.json(0, send_json)
  196. def delete_by_admin(self, request_dict, userID, response):
  197. id_list = request_dict.getlist('id', None)
  198. if not len(id_list):
  199. return response.json(444, 'id is None or not list')
  200. check_perm = ModelService.check_permission(userID=userID, permID=10)
  201. if check_perm is True:
  202. try:
  203. is_delete = Equipment_Info.objects.filter(id__in=id_list).delete()
  204. except Exception as e:
  205. errorInfo = traceback.format_exc()
  206. print(errorInfo)
  207. return response.json(424, {'details': repr(e)})
  208. else:
  209. return response.json(0, {'delete_count': is_delete[0]})
  210. else:
  211. return response.json(404)
  212. # http://192.168.136.40:8077/detect/add?UID=FTSLL8HM437Z38WU111A&Channel=0&eventType=1&eventTime=1234567890
  213. # 设备推送信息添加接口
  214. class AddDetectionView(TemplateView):
  215. @method_decorator(csrf_exempt)
  216. def dispatch(self, *args, **kwargs):
  217. return super(AddDetectionView, self).dispatch(*args, **kwargs)
  218. def get(self, request, *args, **kwargs):
  219. request.encoding = 'utf-8'
  220. return self.validation(request_dict=request.GET)
  221. def post(self, request, *args, **kwargs):
  222. request.encoding = 'utf-8'
  223. return self.validation(request_dict=request.POST)
  224. def validation(self, request_dict, *args, **kwargs):
  225. response = ResponseObject()
  226. # 设备添加token
  227. uidToken = request_dict.get('uidToken', None)
  228. Channel = request_dict.get('Channel', None)
  229. eventType = request_dict.get('eventType', None)
  230. eventTime = request_dict.get('eventTime', None)
  231. utko = UidTokenObject(uidToken)
  232. if utko.flag is False:
  233. return response.json(444, 'tidToken is wrong')
  234. UID = utko.UID
  235. if not Channel or not eventType or not eventTime:
  236. return response.json(444, 'uidToken,Channel,eventType,eventTime')
  237. dv_qs = Device_Info.objects.filter(UID=UID, iSNotification=True).values("userID_id", "NickName")
  238. if not dv_qs.exists():
  239. return response.json(10, 'device not detect')
  240. qs_list = []
  241. for dv in dv_qs:
  242. add_data = {
  243. 'userID_id': dv["userID_id"],
  244. 'devUid': UID,
  245. 'Channel': Channel,
  246. 'eventType': eventType,
  247. 'eventTime': eventTime,
  248. 'devNickName': dv["NickName"],
  249. }
  250. qs_list.append(Equipment_Info(**add_data))
  251. if qs_list:
  252. print(1)
  253. Equipment_Info.objects.bulk_create(qs_list)
  254. print(2)
  255. return response.json(0)
  256. else:
  257. return response.json(10, '无设备开启')
  258. # http://192.168.136.40:8077/detect/status?token=local&id=138001380001543918745881545&iSNotification=0
  259. # 设备推送开关
  260. class DetectStatusView(View):
  261. @method_decorator(csrf_exempt)
  262. def dispatch(self, *args, **kwargs):
  263. return super(DetectStatusView, self).dispatch(*args, **kwargs)
  264. def get(self, request, *args, **kwargs):
  265. request.encoding = 'utf-8'
  266. return self.validation(request_dict=request.GET)
  267. def post(self, request, *args, **kwargs):
  268. request.encoding = 'utf-8'
  269. return self.validation(request_dict=request.POST)
  270. def validation(self, request_dict, *args, **kwargs):
  271. token = request_dict.get('token', None)
  272. id = request_dict.get('id', None)
  273. iSNotification = request_dict.get('iSNotification', None)
  274. response = ResponseObject()
  275. if token is None:
  276. return response.json(309)
  277. tko = TokenObject(token)
  278. tko.valid()
  279. response.lang = tko.lang
  280. if tko.code != 0:
  281. return response.json(tko.code)
  282. userID = tko.userID
  283. return self.do_update(userID, id, iSNotification, response)
  284. def do_update(self, userID, id, iSNotification, response):
  285. qs = Device_Info.objects.filter(id=id, userID_id=userID)
  286. if qs.exists():
  287. qs.update(iSNotification=iSNotification)
  288. data = {'uid': qs[0].UID}
  289. utko = UidTokenObject()
  290. uid_token = utko.generate(data)
  291. return response.json(0, {'uid_token': uid_token,
  292. 'push_url': '{SERVER_DOMAIN}detect/add'.format(SERVER_DOMAIN=SERVER_DOMAIN)})
  293. else:
  294. return response.json(13)