SubDeviceController.py 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647
  1. # -*- coding: utf-8 -*-
  2. """
  3. @Author : Rocky
  4. @Time : 2022/5/25 15:17
  5. @File :SubDeviceController.py
  6. """
  7. import time
  8. from collections import OrderedDict
  9. from django.db import transaction
  10. from django.db.models import Count, Q
  11. from django.views import View
  12. from Ansjer.Config.gatewaySensorConfig import SMART_SCENE_TOPIC, SENSOR_TYPE, EVENT_TYPE
  13. from Model.models import Device_Info, GatewaySubDevice, FamilyRoomDevice, SensorRecord, SmartScene, SceneLog, FamilyRoom
  14. from Service.CommonService import CommonService
  15. class GatewaySubDeviceView(View):
  16. def get(self, request, *args, **kwargs):
  17. request.encoding = 'utf-8'
  18. operation = kwargs.get('operation')
  19. return self.validation(request.GET, request, operation)
  20. def post(self, request, *args, **kwargs):
  21. request.encoding = 'utf-8'
  22. operation = kwargs.get('operation')
  23. return self.validation(request.POST, request, operation)
  24. def validation(self, request_dict, request, operation):
  25. token_code, user_id, response = CommonService.verify_token_get_user_id(request_dict, request)
  26. if token_code != 0:
  27. return response.json(token_code)
  28. if operation == 'add': # 添加子设备
  29. return self.add_sub_device(request_dict, user_id, response)
  30. elif operation == 'detail': # 查询子设备信息
  31. return self.query_sub_device(request_dict, response)
  32. elif operation == 'update': # 更新子设备信息
  33. return self.sensor_update(request_dict, response)
  34. elif operation == 'delete': # 删除子设备
  35. return self.delete_sub_device(request_dict, response)
  36. elif operation == 'records/tem-hum': # 查询温湿度传感器记录
  37. return self.records_tem_hum(request_dict, response)
  38. elif operation == 'records': # 查询其他传感器记录
  39. return self.records(request_dict, response)
  40. elif operation == 'records-date': # 查询传感器记录日期
  41. return self.records_date(request_dict, response)
  42. elif operation == 'home': # 查询传感器主页信息
  43. return self.sensor_home_info(request_dict, response)
  44. elif operation == 'update-emergency-status': # 更新智能按钮紧急开关状态
  45. return self.update_emergency_status(request_dict, response)
  46. elif operation == 'list': # 获取子设备信息
  47. return self.get_sensor_list(request_dict, response)
  48. elif operation == 'device-list': # 获取设备信息
  49. return self.get_device_list(request_dict, response)
  50. else:
  51. return response.json(414)
  52. @staticmethod
  53. def add_sub_device(request_dict, user_id, response):
  54. """
  55. 添加子设备
  56. @param request_dict: 请求参数
  57. @request_dict serialNumber: 序列号
  58. @request_dict deviceType: 设备类型
  59. @request_dict nickName: 设备名
  60. @request_dict ieeeAddr: 长地址
  61. @request_dict mac: mac地址
  62. @request_dict deviceModel: 设备型号
  63. @request_dict manufacturer: 制造商
  64. @request_dict sensorSerial: 传感器序列号
  65. @request_dict firmwareVersion: 固件版本
  66. @request_dict hardwareVersion: 硬件版本
  67. @request_dict familyId: 家庭id
  68. @request_dict roomId: 房间id
  69. @param user_id: 用户id
  70. @param response: 响应对象
  71. @return: response 响应对象
  72. """
  73. serial_number = request_dict.get('serialNumber', None)
  74. device_type = int(request_dict.get('deviceType', None))
  75. nickname = request_dict.get('nickName', None)
  76. ieee_addr = request_dict.get('ieeeAddr', None)
  77. mac = request_dict.get('mac', '')
  78. device_model = request_dict.get('deviceModel', '')
  79. manufacturer = request_dict.get('manufacturer', '')
  80. sensor_serial = request_dict.get('sensorSerial', '')
  81. firmware_version = request_dict.get('firmwareVersion', '')
  82. hardware_version = request_dict.get('hardwareVersion', '')
  83. family_id = request_dict.get('familyId', None)
  84. room_id = request_dict.get('roomId', 0)
  85. if not all([serial_number, device_type, nickname, family_id]):
  86. return response.json(444)
  87. now_time = int(time.time())
  88. is_tampered = 1 if device_type == SENSOR_TYPE['smart_button'] else 0 # 智能按钮默认开启紧急开关
  89. try:
  90. # 查询网关设备数据
  91. device_info_qs = Device_Info.objects.filter(userID_id=user_id, serial_number=serial_number).values('id')
  92. if not device_info_qs.exists():
  93. return response.json(14)
  94. device_id = device_info_qs[0]['id']
  95. # 查询是否已添加过该子设备
  96. sub_device_qs = GatewaySubDevice.objects.filter(device_id=device_id, ieee_addr=ieee_addr)
  97. if sub_device_qs.exists():
  98. return response.json(174)
  99. if device_type == SENSOR_TYPE['smart_button']:
  100. sub_device_qs = GatewaySubDevice.objects.filter(device_id=device_id, device_type=device_type)
  101. if sub_device_qs.count() >= 3:
  102. return response.json(181)
  103. with transaction.atomic():
  104. sub_device = GatewaySubDevice.objects.create(device_id=device_id, device_type=device_type,
  105. nickname=nickname, ieee_addr=ieee_addr,
  106. status=1, mac=mac, device_model=device_model,
  107. manufacturer=manufacturer, sensor_serial=sensor_serial,
  108. firmware_version=firmware_version, is_tampered=is_tampered,
  109. hardware_version=hardware_version,
  110. created_time=now_time, updated_time=now_time)
  111. if device_type == 216:
  112. sub_device.is_tampered = 1
  113. sub_device.save()
  114. family_room_device_qs = FamilyRoomDevice.objects.filter(family_id=family_id, category=0).values(
  115. 'category_sort')
  116. if family_room_device_qs.exists():
  117. FamilyRoomDevice.objects.create(family_id=family_id, room_id=room_id, device_id=device_id,
  118. sub_device=sub_device.id, created_time=now_time,
  119. updated_time=now_time,
  120. category_sort=family_room_device_qs[0]['category_sort'])
  121. else:
  122. FamilyRoomDevice.objects.create(family_id=family_id, room_id=room_id, device_id=device_id,
  123. sub_device=sub_device.id, created_time=now_time,
  124. updated_time=now_time)
  125. return response.json(0)
  126. except Exception as e:
  127. return response.json(500, repr(e))
  128. @staticmethod
  129. def query_sub_device(request_dict, response):
  130. """
  131. 查询子设备信息
  132. @param request_dict: 请求参数
  133. @request_dict gatewaySubId: 子设备id
  134. @param response: 响应对象
  135. @return: response
  136. """
  137. sub_device_id = request_dict.get('gatewaySubId', None)
  138. if not all([sub_device_id]):
  139. return response.json(444)
  140. try:
  141. gateway_sub_device_qs = GatewaySubDevice.objects.filter(id=sub_device_id).values('manufacturer',
  142. 'device_model',
  143. 'mac', 'sensor_serial',
  144. 'device_type',
  145. 'is_tampered')
  146. if not gateway_sub_device_qs.exists():
  147. return response.json(173)
  148. res = {
  149. 'manufacturer': gateway_sub_device_qs[0]['manufacturer'],
  150. 'device_model': gateway_sub_device_qs[0]['device_model'],
  151. 'mac': gateway_sub_device_qs[0]['mac'],
  152. 'sensor_serial': gateway_sub_device_qs[0]['sensor_serial'],
  153. }
  154. if gateway_sub_device_qs[0]['device_type'] == SENSOR_TYPE['smart_button']: # 智能按钮返回紧急开关状态
  155. res['emergency_status'] = gateway_sub_device_qs[0]['is_tampered']
  156. return response.json(0, res)
  157. except Exception as e:
  158. return response.json(500, repr(e))
  159. @classmethod
  160. def sensor_update(cls, request_dict, response):
  161. """
  162. 传感器修改
  163. @param request_dict: 请求参数
  164. @request_dict gateway_sub_id: 子设备id
  165. @request_dict nickName: 设备名
  166. @request_dict room_id: 房间id
  167. @param response: 响应结果
  168. @return: list
  169. """
  170. gateway_sub_id = int(request_dict.get('gatewaySubId', None))
  171. nickName = request_dict.get('nickName', None)
  172. room_id = request_dict.get('roomId', None)
  173. if not all([gateway_sub_id]):
  174. return response.json(444)
  175. try:
  176. gateway_sub_qs = GatewaySubDevice.objects.filter(id=gateway_sub_id)
  177. if not gateway_sub_qs.exists():
  178. return response.json(173)
  179. if nickName:
  180. gateway_sub_qs.update(nickname=nickName)
  181. if room_id:
  182. FamilyRoomDevice.objects.filter(sub_device=gateway_sub_id).update(room_id=room_id)
  183. return response.json(0)
  184. except Exception as e:
  185. print(e.args)
  186. return response.json(500, repr(e))
  187. @staticmethod
  188. def delete_sub_device(request_dict, response):
  189. """
  190. 更新子设备信息
  191. @param request_dict: 请求参数
  192. @request_dict sub_device_id: 子设备id
  193. @param response: 响应对象
  194. @return: response
  195. """
  196. sub_device_id = request_dict.get('subDeviceId', None)
  197. if not all([sub_device_id]):
  198. return response.json(444)
  199. try:
  200. with transaction.atomic():
  201. GatewaySubDevice.objects.filter(id=sub_device_id).delete()
  202. smart_scene_qs = SmartScene.objects.filter(sub_device_id=sub_device_id)
  203. if smart_scene_qs.exists():
  204. smart_scene_qs.delete()
  205. scene_log_qs = SceneLog.objects.filter(sub_device_id=sub_device_id)
  206. if scene_log_qs.exists():
  207. scene_log_qs.delete()
  208. return response.json(0)
  209. except Exception as e:
  210. return response.json(500, repr(e))
  211. @classmethod
  212. def records_tem_hum(cls, request_dict, response):
  213. """
  214. 查询温湿度传感器记录
  215. @param request_dict: 请求参数
  216. @request_dict gatewaySubId: 子设备id
  217. @request_dict cycle: 时间周期
  218. @request_dict eventType: 事件类型, 2200:温度,2201:湿度
  219. @param response: 响应对象
  220. @return: response
  221. """
  222. sub_device_id = request_dict.get('gatewaySubId', None)
  223. cycle = request_dict.get('cycle', None)
  224. event_type = request_dict.get('eventType', None)
  225. if not all([sub_device_id, cycle, event_type]):
  226. return response.json(444, {'error param': 'gatewaySubId or cycle or eventType'})
  227. now_time = int(time.time())
  228. # 判断event_type
  229. event_type = int(event_type)
  230. if event_type != EVENT_TYPE['temperature'] and event_type != EVENT_TYPE['humidity']:
  231. return response.json(444, {'invalid eventType': event_type})
  232. try:
  233. record_dict = cls.get_record_dict(cycle, now_time, sub_device_id, event_type)
  234. record_list = []
  235. if record_dict:
  236. # 组织响应数据列表,value为每 小时/天 的平均值
  237. for k, v in record_dict.items():
  238. record_list.append({'key': k, 'value': round(sum(v) / len(v), 1)})
  239. res = {
  240. 'records': record_list,
  241. 'time': now_time
  242. }
  243. return response.json(0, res)
  244. except Exception as e:
  245. return response.json(500, repr(e))
  246. @staticmethod
  247. def get_record_dict(cycle, now_time, sub_device_id, event_type):
  248. """
  249. 获取记录数据
  250. @param cycle: 时间周期
  251. @param now_time: 当前时间
  252. @param sub_device_id: 子设备id
  253. @param event_type: 事件类型, 2200:温度,2201:湿度
  254. @return: record_dict: 记录数据
  255. """
  256. record_dict = OrderedDict()
  257. if cycle == 'Hours':
  258. start_time = now_time - 24 * 60 * 60
  259. sensor_record_qs = SensorRecord.objects.filter(gateway_sub_device_id=sub_device_id,
  260. event_type=event_type,
  261. created_time__range=(start_time, now_time)). \
  262. values('alarm', 'created_time').order_by('created_time')
  263. if not sensor_record_qs.exists():
  264. return record_dict
  265. for sensor_record in sensor_record_qs:
  266. created_time = time.strftime('%m/%d %H:%M %w', time.localtime(sensor_record['created_time']))
  267. hour = int(created_time[-7:-5])
  268. minute = int(created_time[-4:-2])
  269. if hour != 23 and minute > 30: # 不为23时且分钟大于30,hour+1
  270. hour += 1
  271. alarm = float(sensor_record['alarm'])
  272. # 组织数据,record_dict:{"0": [1.0, 2.0, 3.0], "1": [1.0, 2.0, 3.0]...}
  273. if str(hour) in record_dict:
  274. record_dict[str(hour)].append(alarm)
  275. else:
  276. record_dict[str(hour)] = [alarm]
  277. elif cycle == 'Week':
  278. start_time = now_time - 24 * 60 * 60 * 7
  279. sensor_record_qs = SensorRecord.objects.filter(gateway_sub_device_id=sub_device_id,
  280. event_type=event_type,
  281. created_time__range=(start_time, now_time)). \
  282. values('alarm', 'created_time').order_by('created_time')
  283. if not sensor_record_qs.exists():
  284. return record_dict
  285. for sensor_record in sensor_record_qs:
  286. created_time = time.strftime('%m/%d %H:%M %w', time.localtime(sensor_record['created_time']))
  287. week = int(created_time[-1:])
  288. alarm = float(sensor_record['alarm'])
  289. # 组织数据,record_dict:{"0": [1.0, 2.0, 3.0], "1": [1.0, 2.0, 3.0]...}
  290. if str(week) in record_dict:
  291. record_dict[str(week)].append(alarm)
  292. else:
  293. record_dict[str(week)] = [alarm]
  294. elif cycle == 'Month':
  295. start_time = now_time - 24 * 60 * 60 * 30
  296. sensor_record_qs = SensorRecord.objects.filter(gateway_sub_device_id=sub_device_id,
  297. event_type=event_type,
  298. created_time__range=(start_time, now_time)). \
  299. values('alarm', 'created_time').order_by('created_time')
  300. if not sensor_record_qs.exists():
  301. return record_dict
  302. for sensor_record in sensor_record_qs:
  303. created_time = time.strftime('%m/%d %H:%M %w', time.localtime(sensor_record['created_time']))
  304. month = int(created_time[:2])
  305. day = int(created_time[3:5])
  306. date = str(month) + '/' + str(day)
  307. alarm = float(sensor_record['alarm'])
  308. # 组织数据,record_dict:{"1/1": [1.0, 2.0, 3.0], "1/2": [1.0, 2.0, 3.0]...}
  309. if date in record_dict:
  310. record_dict[date].append(alarm)
  311. else:
  312. record_dict[date] = [alarm]
  313. return record_dict
  314. @staticmethod
  315. def records(request_dict, response):
  316. """
  317. 查询其他传感器记录
  318. @param request_dict: 请求参数
  319. @request_dict gatewaySubId: 子设备id
  320. @request_dict page: 页数
  321. @request_dict size: 条数
  322. @request_dict startTime: 开始时间
  323. @request_dict endTime: 结束时间
  324. @param response: 响应对象
  325. @return: response
  326. """
  327. sub_device_id = request_dict.get('gatewaySubId', None)
  328. page = request_dict.get('page', None)
  329. size = request_dict.get('size', None)
  330. if not all([sub_device_id, page, size]):
  331. return response.json(444, {'error param': 'gatewaySubId or page or size'})
  332. start_time = request_dict.get('startTime', None)
  333. end_time = request_dict.get('endTime', None)
  334. try:
  335. page, size = int(page), int(size)
  336. if start_time and end_time:
  337. sensor_record_qs = SensorRecord.objects.filter(gateway_sub_device_id=sub_device_id,
  338. created_time__range=(start_time, end_time)). \
  339. values('alarm', 'event_type', 'created_time').order_by('-created_time')[
  340. (page - 1) * size:page * size]
  341. else:
  342. sensor_record_qs = SensorRecord.objects.filter(gateway_sub_device_id=sub_device_id). \
  343. values('alarm', 'event_type', 'created_time').order_by('-created_time')[
  344. (page - 1) * size:page * size]
  345. if not sensor_record_qs.exists():
  346. return response.json(0, [])
  347. return response.json(0, list(sensor_record_qs))
  348. except Exception as e:
  349. return response.json(500, repr(e))
  350. @staticmethod
  351. def records_date(request_dict, response):
  352. """
  353. 查询传感器记录日期
  354. @param request_dict: 请求参数
  355. @request_dict gatewaySubId: 子设备id
  356. @request_dict startTime: 开始时间
  357. @request_dict endTime: 结束时间
  358. @param response: 响应对象
  359. @return: response
  360. """
  361. sub_device_id = request_dict.get('gatewaySubId', None)
  362. if not sub_device_id:
  363. return response.json(444, {'error param': 'gatewaySubId'})
  364. try:
  365. sensor_record_qs = SensorRecord.objects.extra(
  366. select={'date': "FROM_UNIXTIME(created_time,'%%Y-%%m-%%d')"}).values('date'). \
  367. filter(gateway_sub_device_id=sub_device_id). \
  368. annotate(count=Count('created_time')). \
  369. order_by('-date')[:31]
  370. record_date_list = []
  371. for sensor_record in sensor_record_qs:
  372. record_date_list.append({
  373. 'timestamp': CommonService.str_to_timestamp(sensor_record['date'], '%Y-%m-%d'),
  374. 'count': sensor_record['count'],
  375. 'format': sensor_record['date'],
  376. })
  377. return response.json(0, record_date_list)
  378. except Exception as e:
  379. return response.json(500, repr(e))
  380. @staticmethod
  381. def sensor_home_info(request_dict, response):
  382. """
  383. 查询子设备首页信息
  384. @param request_dict: 请求参数
  385. @request_dict gatewaySubId: 子设备id
  386. @param response: 响应对象
  387. @return: response
  388. """
  389. sub_device_id = request_dict.get('gatewaySubId', None)
  390. if not sub_device_id:
  391. return response.json(444, {'error param': 'gatewaySubId'})
  392. try:
  393. sub_device_qs = GatewaySubDevice.objects.filter(id=sub_device_id).values('device_type', 'status',
  394. 'is_tampered')
  395. if not sub_device_qs.exists():
  396. return response.json(173)
  397. scene_count = SmartScene.objects.filter(sub_device_id=sub_device_id).count()
  398. res = {
  399. 'scene_count': scene_count,
  400. 'status': sub_device_qs[0]['status']
  401. }
  402. device_type = sub_device_qs[0]['device_type']
  403. # 门磁,烟雾,人体传感器返回拆动状态
  404. if device_type == SENSOR_TYPE['door_magnet'] or device_type == SENSOR_TYPE['smoke_sensor'] or \
  405. device_type == SENSOR_TYPE['body_sensor']:
  406. res['is_tampered'] = sub_device_qs[0]['is_tampered']
  407. # 温湿度传感器返回温湿度数据
  408. elif device_type == SENSOR_TYPE['tem_hum_sensor']:
  409. tem_record_qs = SensorRecord.objects.filter(gateway_sub_device_id=sub_device_id,
  410. event_type=EVENT_TYPE['temperature']).order_by(
  411. '-created_time').values('alarm')[:1]
  412. hum_record_qs = SensorRecord.objects.filter(gateway_sub_device_id=sub_device_id,
  413. event_type=EVENT_TYPE['humidity']).order_by(
  414. '-created_time').values('alarm')[:1]
  415. temperature = tem_record_qs[0]['alarm'] if tem_record_qs.exists() else ''
  416. humidity = hum_record_qs[0]['alarm'] if tem_record_qs.exists() else ''
  417. res['temperature'] = temperature
  418. res['humidity'] = humidity
  419. return response.json(0, res)
  420. except Exception as e:
  421. return response.json(500, repr(e))
  422. @staticmethod
  423. def update_emergency_status(request_dict, response):
  424. """
  425. 更新智能按钮紧急开关状态
  426. @param request_dict: 请求参数
  427. @request_dict gatewaySubId: 子设备id
  428. @request_dict emergencyStatus: 紧急开关状态,0:关,1:开
  429. @param response: 响应对象
  430. @return: response
  431. """
  432. sub_device_id = request_dict.get('gatewaySubId', None)
  433. emergency_status = request_dict.get('emergencyStatus', None)
  434. if not all([sub_device_id, emergency_status]):
  435. return response.json(444, {'error param': 'gatewaySubId or emergency_status'})
  436. try:
  437. emergency_status = int(emergency_status)
  438. sub_device_qs = GatewaySubDevice.objects.filter(id=sub_device_id)
  439. if not sub_device_qs.exists():
  440. response.json(173)
  441. with transaction.atomic():
  442. # 更新智能按钮紧急开关状态
  443. sub_device_qs.update(is_tampered=emergency_status)
  444. # 获取序列号
  445. sub_device_qs = sub_device_qs.values('device_id', 'src_addr', 'device__serial_number')
  446. serial_number = sub_device_qs[0]['device__serial_number']
  447. topic_name = SMART_SCENE_TOPIC.format(serial_number)
  448. gateway_sub_device_qs = GatewaySubDevice.objects.filter(device_id=sub_device_qs[0]['device_id'],
  449. device_type=SENSOR_TYPE['smart_button']).values(
  450. 'src_addr')
  451. sos_count = gateway_sub_device_qs.count()
  452. sos_num = 1
  453. for index, gateway_sub_device in enumerate(gateway_sub_device_qs):
  454. if sub_device_qs[0]['src_addr'] == gateway_sub_device['src_addr']:
  455. sos_num += index
  456. # 通知设备修改sos状态
  457. msg = {
  458. 'sos_count': sos_count, # 该网关下的智能按钮数量
  459. 'sos_num': sos_num, # 第几个按钮
  460. 'sensor_src': int(sub_device_qs[0]['src_addr'], 16),
  461. 'sos_select': emergency_status
  462. }
  463. success = CommonService.req_publish_mqtt_msg(serial_number, topic_name, msg)
  464. try:
  465. assert success
  466. except AssertionError:
  467. return response.json(10044)
  468. time.sleep(0.3)
  469. # 如果打开紧急开关,关闭已开启的场景
  470. if emergency_status == 1:
  471. smart_scene_qs = SmartScene.objects.filter(sub_device_id=sub_device_id, is_enable=True)
  472. if not smart_scene_qs.exists():
  473. return response.json(0)
  474. for smart_scene in smart_scene_qs:
  475. # 通知设备关闭场景
  476. msg = {
  477. 'scene_id': smart_scene.id,
  478. 'scene_status': 0
  479. }
  480. success = CommonService.req_publish_mqtt_msg(serial_number, topic_name, msg)
  481. try:
  482. assert success
  483. except AssertionError:
  484. return response.json(10044)
  485. time.sleep(0.3)
  486. smart_scene_qs.update(is_enable=False)
  487. return response.json(0)
  488. except Exception as e:
  489. return response.json(500, repr(e))
  490. @staticmethod
  491. def get_sensor_list(request_dict, response):
  492. """
  493. 获取子设备信息
  494. @param request_dict: 请求参数
  495. @request_dict familyId: 家庭id
  496. @param response: 响应对象
  497. @return: response
  498. """
  499. family_id = request_dict.get('familyId', None)
  500. room_id = request_dict.get('roomId', None)
  501. if not family_id:
  502. return response.json(444, {'error param': 'familyId'})
  503. try:
  504. family_room_device_qs = FamilyRoomDevice.objects.filter(Q(family_id=family_id), ~Q(sub_device=0)).values(
  505. 'sub_device', 'room_id').order_by('sort', '-device__data_joined')
  506. if room_id:
  507. family_room_device_qs = family_room_device_qs.filter(room_id=room_id)
  508. device_list = []
  509. for item in family_room_device_qs:
  510. room_qs = FamilyRoom.objects.filter(id=item['room_id']).values('name')
  511. room_name = room_qs[0]['name'] if room_qs.exists() else ''
  512. device_qs = GatewaySubDevice.objects.filter(id=item['sub_device']).values('id', 'nickname',
  513. 'device_type', 'src_addr',
  514. 'status', 'created_time')
  515. if device_qs.exists():
  516. res = {
  517. 'gatewaySubId': device_qs[0]['id'],
  518. 'nickName': device_qs[0]['nickname'],
  519. 'deviceType': device_qs[0]['device_type'],
  520. 'srcAddr': device_qs[0]['src_addr'],
  521. 'status': device_qs[0]['status'],
  522. 'createdTime': device_qs[0]['created_time'],
  523. 'roomName': room_name,
  524. 'familyId': family_id
  525. }
  526. device_list.append(res)
  527. return response.json(0, device_list)
  528. except Exception as e:
  529. return response.json(500, repr(e))
  530. @staticmethod
  531. def get_device_list(request_dict, response):
  532. """
  533. 获取设备信息
  534. @param request_dict: 请求参数
  535. @request_dict familyId: 家庭id
  536. @param response: 响应对象
  537. @return: response
  538. """
  539. family_id = request_dict.get('familyId', None)
  540. room_id = request_dict.get('roomId', None)
  541. if not family_id:
  542. return response.json(444, {'error param': 'familyId'})
  543. try:
  544. family_room_device_qs = FamilyRoomDevice.objects.filter(family_id=family_id, sub_device=0,
  545. device__Type=200).values(
  546. 'device_id', 'device__NickName').order_by('-device__data_joined')
  547. if room_id:
  548. family_room_device_qs = family_room_device_qs.filter(room_id=room_id)
  549. device_list = []
  550. for item in family_room_device_qs:
  551. device_dict = {
  552. 'deviceId': item['device_id'],
  553. 'deviceType': 200,
  554. 'deviceNickName': item['device__NickName'],
  555. }
  556. sub_device = []
  557. family_room_sub_device_qs = FamilyRoomDevice.objects.filter(Q(family_id=family_id), ~Q(sub_device=0),
  558. Q(device_id=item['device_id'])).values(
  559. 'sub_device', 'room_id').order_by('sort')
  560. if family_room_sub_device_qs.exists():
  561. for each in family_room_sub_device_qs:
  562. room_qs = FamilyRoom.objects.filter(id=each['room_id']).values('name')
  563. room_name = room_qs[0]['name'] if room_qs.exists() else ''
  564. device_qs = GatewaySubDevice.objects.filter(id=each['sub_device']).values('id', 'nickname',
  565. 'device_type',
  566. 'src_addr',
  567. 'status',
  568. 'created_time')
  569. if device_qs.exists():
  570. sub_device.append({
  571. 'gatewaySubId': device_qs[0]['id'],
  572. 'nickName': device_qs[0]['nickname'],
  573. 'deviceType': device_qs[0]['device_type'],
  574. 'srcAddr': device_qs[0]['src_addr'],
  575. 'status': device_qs[0]['status'],
  576. 'createdTime': device_qs[0]['created_time'],
  577. 'roomName': room_name,
  578. 'familyId': family_id
  579. })
  580. device_dict['subDevice'] = sub_device
  581. device_list.append(device_dict)
  582. return response.json(0, device_list)
  583. except Exception as e:
  584. return response.json(500, repr(e))
  585. #
  586. # ___====-_ _-====___
  587. # _--^^^#####// \\#####^^^--_
  588. # _-^##########// ( ) \\##########^-_
  589. # -############// |\^^/| \\############-
  590. # _/############// (@::@) \\############\_
  591. # /#############(( \\// ))#############\
  592. # -###############\\ (oo) //###############-
  593. # -#################\\ / VV \ //#################-
  594. # -###################\\/ \//###################-
  595. # _#/|##########/\######( /\ )######/\##########|\#_
  596. # |/ |#/\#/\#/\/ \#/\##\ | | /##/\#/ \/\#/\#/\#| \|
  597. # ` |/ V V ` V \#\| | | |/#/ V ' V V \| '
  598. # ` ` ` ` / | | | | \ ' ' ' '
  599. # ( | | | | )
  600. # __\ | | | | /__
  601. # (vvv(VVV)(VVV)vvv)
  602. # 神兽保佑
  603. # 代码无BUG!
  604. #