EquipmentInfo.py 14 KB

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