GatewayFamilyMemberController.py 24 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560
  1. # -*- encoding: utf-8 -*-
  2. """
  3. @File : GatewayFamilyMemberController.py
  4. @Time : 2022/5/25 10:21
  5. @Author : stephen
  6. @Email : zhangdongming@asj6.wecom.work
  7. @Software: PyCharm
  8. """
  9. import json
  10. import time
  11. from django.db import transaction
  12. from django.views.generic.base import View
  13. from Ansjer.config import SERVER_DOMAIN
  14. from Controller.SensorGateway.EquipmentFamilyController import EquipmentFamilyView
  15. from Model.models import UserFamily, FamilyMemberJoin, FamilyMember, SysMsgModel, FamilyMemberPermission, \
  16. Device_User, FamilyRoomDevice, FamilyRoom
  17. from Object.RedisObject import RedisObject
  18. from Object.ResponseObject import ResponseObject
  19. from Object.TokenObject import TokenObject
  20. from Service.CommonService import CommonService
  21. # 家庭房间管理
  22. class GatewayFamilyMemberView(View):
  23. def get(self, request, *args, **kwargs):
  24. request.encoding = 'utf-8'
  25. operation = kwargs.get('operation')
  26. return self.validation(request.GET, request, operation)
  27. def post(self, request, *args, **kwargs):
  28. request.encoding = 'utf-8'
  29. operation = kwargs.get('operation')
  30. return self.validation(request.POST, request, operation)
  31. def validation(self, request_dict, request, operation):
  32. token = request.META.get('HTTP_AUTHORIZATION')
  33. token = TokenObject(token)
  34. lang = request_dict.get('lang', None)
  35. response = ResponseObject(lang) if lang else ResponseObject(token.lang)
  36. if token.code != 0:
  37. return response.json(token.code)
  38. app_user_id = token.userID
  39. # 添加设备关联房间
  40. if operation == 'join':
  41. return self.member_join(app_user_id, request_dict, response)
  42. elif operation == 'join/page':
  43. return self.member_join_page(request_dict, response)
  44. elif operation == 'qrcode/generate':
  45. return self.family_generate_token(app_user_id, request_dict, response)
  46. elif operation == 'qrcode/check':
  47. return self.check_qrcode(request_dict, response)
  48. elif operation == 'join/info':
  49. return self.member_join_info(request_dict, response)
  50. elif operation == 'join/update':
  51. return self.user_join_confirm(request_dict, response)
  52. elif operation == 'del':
  53. return self.member_del(app_user_id, request_dict, response)
  54. elif operation == 'created':
  55. return self.family_created(app_user_id, request_dict, response)
  56. elif operation == 'del/home':
  57. return self.del_home(app_user_id, request_dict, response)
  58. elif operation == 'join/del':
  59. return self.member_join_del(app_user_id, request_dict, response)
  60. @classmethod
  61. def member_join_del(cls, app_user_id, request_dict, response):
  62. """
  63. 删除最近联系人
  64. @param app_user_id:
  65. @param request_dict:
  66. @param response:
  67. @return:
  68. """
  69. join_ids = request_dict.get('joinIds', None)
  70. family_id = request_dict.get('familyId', None)
  71. if not join_ids:
  72. return response.json()
  73. is_owner = EquipmentFamilyView.get_family_owner(app_user_id, family_id)
  74. if not is_owner:
  75. return response.json(404)
  76. try:
  77. with transaction.atomic():
  78. items = join_ids.split(',')
  79. for item in items:
  80. family_member_join_qs = FamilyMemberJoin.objects.filter(id=int(item))
  81. if family_member_join_qs.exists():
  82. family_member_join_qs.delete()
  83. return response.json(0)
  84. except Exception as e:
  85. print(e)
  86. return response.json(177, repr(e))
  87. @classmethod
  88. def del_home(cls, app_user_id, request_dict, response):
  89. """
  90. 删除家庭
  91. @param app_user_id:
  92. @param request_dict:
  93. @param response:
  94. @return:
  95. """
  96. family_id = request_dict.get('familyId', None)
  97. if not family_id:
  98. return response.json(444)
  99. is_owner = EquipmentFamilyView.get_family_owner(app_user_id, family_id)
  100. if not is_owner:
  101. return response.json(404)
  102. family_id = int(family_id)
  103. try:
  104. with transaction.atomic():
  105. family_count = UserFamily.objects.filter(user_id=app_user_id).count()
  106. if family_count <= 1:
  107. return response.json(10058)
  108. family_member_qs = FamilyMember.objects.filter(family_id=family_id, identity=0)
  109. if family_member_qs.exists():
  110. return response.json(10057)
  111. family_room_dev_qs = FamilyRoomDevice.objects.filter(family_id=family_id)
  112. if family_room_dev_qs.exists():
  113. return response.json(10057)
  114. family_room_qs = FamilyRoom.objects.filter(family_id=family_id)
  115. if family_room_qs.exists():
  116. family_room_qs.delete()
  117. FamilyMember.objects.filter(family_id=family_id).delete()
  118. user_family_qs = UserFamily.objects.filter(id=family_id)
  119. if user_family_qs.exists():
  120. user_family_qs.delete()
  121. return response.json(0)
  122. return response.json(176)
  123. except Exception as e:
  124. print(e)
  125. return response.json(177, repr(e))
  126. @classmethod
  127. def family_created(cls, app_user_id, request_dict, response):
  128. """
  129. 创建家庭
  130. @param app_user_id:
  131. @param request_dict:
  132. @param response:
  133. @return:
  134. """
  135. family_name = request_dict.get('familyName', None)
  136. if not family_name:
  137. return response.json(444)
  138. n_time = int(time.time())
  139. location = request_dict.get('location', '')
  140. room_names = request_dict.get('roomNames', None)
  141. user_family_qs = UserFamily.objects.filter(name=family_name, user_id=app_user_id)
  142. if user_family_qs.exists():
  143. return response.json(174)
  144. try:
  145. with transaction.atomic():
  146. member_permission_qs = FamilyMemberPermission.objects.filter(no='001').values('id')
  147. user_family = UserFamily.objects.create(user_id=app_user_id, name=family_name,
  148. location=location,
  149. updated_time=n_time,
  150. created_time=n_time)
  151. if user_family.id:
  152. device_user = Device_User.objects.get(userID=app_user_id)
  153. permission_id = member_permission_qs.first()['id']
  154. FamilyMember.objects.create(family_id=user_family.id, user_id=app_user_id,
  155. user_name=device_user.username, identity=1,
  156. permission_id=int(permission_id), sort=1, updated_time=n_time,
  157. created_time=n_time)
  158. if room_names:
  159. names = room_names.split(',')
  160. rooms = []
  161. for index, item in enumerate(names):
  162. rooms.append(FamilyRoom(
  163. name=item,
  164. family_id=user_family.id,
  165. sort=index,
  166. updated_time=n_time,
  167. created_time=n_time
  168. ))
  169. FamilyRoom.objects.bulk_create(rooms)
  170. return response.json(0)
  171. except Exception as e:
  172. print(e)
  173. return response.json(177, repr(e))
  174. @classmethod
  175. def member_del(cls, app_user_id, request_dict, response):
  176. """
  177. 成员删除或退出
  178. @param app_user_id:
  179. @param request_dict:
  180. @param response:
  181. @return:
  182. """
  183. member_id = request_dict.get('memberId', None)
  184. family_id = request_dict.get('familyId', None)
  185. if not family_id:
  186. return response.json(444)
  187. try:
  188. family_id = int(family_id)
  189. with transaction.atomic():
  190. # 家庭所有者删除成员
  191. if member_id:
  192. is_owner = EquipmentFamilyView.get_family_owner(app_user_id, family_id)
  193. if not is_owner:
  194. return response.json(404)
  195. member_id = int(member_id)
  196. family_member_qs = FamilyMember.objects.filter(id=member_id)
  197. if not family_member_qs.exists():
  198. return response.json(173)
  199. family_member_qs.delete()
  200. return response.json(0)
  201. else:
  202. # 成员退出当前家庭
  203. family_member = FamilyMember.objects.filter(family_id=family_id, user_id=app_user_id, identity=1)
  204. if family_member.exists():
  205. return response.json(173)
  206. family_member_qs = FamilyMember.objects.filter(family_id=family_id, user_id=app_user_id)
  207. if not family_member_qs.exists():
  208. return response.json(173)
  209. family_member_qs.delete()
  210. return response.json(0)
  211. except Exception as e:
  212. return response.json(177, repr(e))
  213. @classmethod
  214. def user_join_confirm(cls, request_dict, response):
  215. """
  216. 用户加入家庭确认
  217. @param request_dict:
  218. @param response:
  219. @return:
  220. """
  221. join_id = request_dict.get('joinId', None)
  222. confirm = request_dict.get('confirm', None)
  223. lang = request_dict.get('lang', 'en')
  224. if not all([join_id, confirm]):
  225. return response.json(444)
  226. join_id = int(join_id)
  227. family_join = FamilyMemberJoin.objects.filter(id=join_id, status=0)
  228. if not family_join.exists():
  229. return response.json(173)
  230. family_member = FamilyMember.objects.filter(family_id=family_join.first().family_id,
  231. user_id=family_join.first().user_id)
  232. if family_member.exists():
  233. return response.json(174)
  234. try:
  235. now_time = int(time.time())
  236. with transaction.atomic():
  237. family_join.update(status=2 if confirm == 'confirm' else 1)
  238. family_join = FamilyMemberJoin.objects.filter(id=join_id)
  239. family_join = family_join.values('id', 'user_id', 'user__username', 'user__NickName', 'family__name',
  240. 'family_id', 'family__user_id', 'status', 'type', 'updated_time')
  241. family_join = family_join.first()
  242. nick_name = family_join['user__NickName']
  243. family_name = family_join['family__name']
  244. join_type = family_join['type']
  245. data = {
  246. 'addTime': now_time,
  247. 'updTime': now_time,
  248. 'userID_id': family_join['user_id'] if join_type == 1 else family_join['family__user_id'],
  249. 'eventType': 0
  250. }
  251. if confirm == 'confirm':
  252. msg_text = cls.get_confirm_text(nick_name, family_name, join_type, True, lang)
  253. p_id = FamilyMemberPermission.objects.filter(no='002').values('id').first()
  254. p_id = p_id['id']
  255. FamilyMember.objects.create(family_id=family_join['family_id'], updated_time=now_time,
  256. user_id=family_join['user_id'],
  257. created_time=now_time,
  258. permission_id=p_id,
  259. user_name=family_join['user__username'])
  260. elif confirm == 'refusal':
  261. msg_text = cls.get_confirm_text(nick_name, family_name, join_type, False, lang)
  262. else:
  263. ex = Exception("data is null")
  264. raise ex
  265. data['msg'] = msg_text
  266. data['uid'] = family_join['id']
  267. SysMsgModel.objects.create(**data)
  268. return response.json(0)
  269. except Exception as e:
  270. print(e)
  271. return response.json(177, repr(e))
  272. @classmethod
  273. def get_confirm_text(cls, nick_name, family_name, join_type, is_confirm, lang='en'):
  274. # join_type == 1等于扫码请求加u人
  275. if is_confirm:
  276. if join_type == 1:
  277. if lang == 'cn':
  278. msg_text = '{} 同意你的请求'.format(family_name)
  279. else:
  280. msg_text = '{} confirm to your request'.format(family_name)
  281. else:
  282. if lang == 'cn':
  283. msg_text = '{}同意加入{}'.format(nick_name, family_name)
  284. else:
  285. msg_text = '{} confirm to join {}'.format(nick_name, family_name)
  286. else:
  287. if join_type == 1:
  288. if lang == 'cn':
  289. msg_text = '{}拒绝你的请求'.format(family_name)
  290. else:
  291. msg_text = '{} refused your request'.format(family_name)
  292. else:
  293. if lang == 'cn':
  294. msg_text = '{}拒绝加入{}'.format(nick_name, family_name)
  295. else:
  296. msg_text = '{} refused to join '.format(family_name)
  297. return msg_text
  298. @classmethod
  299. def member_join_info(cls, request_dict, response):
  300. """
  301. 查询加入家庭信息
  302. @param request_dict:
  303. @param response:
  304. @return:
  305. """
  306. join_id = request_dict.get('joinId', None)
  307. if not join_id:
  308. return response.json(444)
  309. join_id = int(join_id)
  310. family_join_qs = FamilyMemberJoin.objects.filter(id=join_id)
  311. if not family_join_qs.exists():
  312. return response.json(173)
  313. family_join_qs = family_join_qs.values('type', 'user__NickName', 'family__name', 'status', 'id',
  314. 'family__user__NickName')
  315. family_join_qs = family_join_qs.first()
  316. nick_name = family_join_qs['user__NickName']
  317. if family_join_qs['type'] == 0:
  318. nick_name = family_join_qs['family__user__NickName']
  319. return response.json(0, {
  320. 'id': family_join_qs['id'],
  321. 'type': family_join_qs['type'],
  322. 'nickName': nick_name,
  323. 'familyName': family_join_qs['family__name'],
  324. 'status': family_join_qs['status'],
  325. })
  326. @classmethod
  327. def member_join(cls, app_user_id, request_dict, response):
  328. """
  329. 家庭成员加入
  330. @param app_user_id:
  331. @param request_dict:
  332. @param response:
  333. @return:
  334. """
  335. family_id = request_dict.get('familyId', None)
  336. invite = request_dict.get('QRCodeInvite', 0)
  337. user_id = request_dict.get('app_user_id', None)
  338. lang = request_dict.get('lang', 'en')
  339. if not all([family_id, invite]):
  340. return response.json(444)
  341. invite = int(invite)
  342. family_id = int(family_id)
  343. now_time = int(time.time())
  344. # 判断当前家庭是否已有该成员
  345. if invite == 1:
  346. family_qs = FamilyMember.objects.filter(family_id=family_id, user_id=app_user_id)
  347. elif user_id:
  348. family_qs = FamilyMember.objects.filter(family_id=family_id, user_id=user_id)
  349. else:
  350. return response.json(173)
  351. if family_qs.exists():
  352. return response.json(174)
  353. try:
  354. user_family_qs = UserFamily.objects.filter(id=family_id)
  355. if not user_family_qs:
  356. return response.json(173)
  357. user_family = user_family_qs.first()
  358. family_name = user_family.name
  359. data = {
  360. 'addTime': now_time,
  361. 'updTime': now_time,
  362. 'eventType': 705
  363. }
  364. # 请求加入家庭,用户信息
  365. user_qs = Device_User.objects.filter(userID=app_user_id)
  366. nick_name = user_qs.first().NickName
  367. if invite == 1:
  368. msg_text = cls.get_msg_text(nick_name, family_name, lang, True)
  369. # 通知对象 家庭所有者
  370. join_user_id = app_user_id
  371. data['userID_id'] = user_family.user_id
  372. elif app_user_id:
  373. msg_text = cls.get_msg_text(nick_name, family_name, lang, False)
  374. # 通知对象 被邀请人
  375. join_user_id = user_id
  376. data['userID_id'] = user_id
  377. else:
  378. return response.json(173)
  379. data['msg'] = msg_text
  380. with transaction.atomic():
  381. member_user_id = user_id if user_id else app_user_id
  382. member_join_qs = FamilyMemberJoin.objects.filter(family_id=family_id, user_id=member_user_id)
  383. if member_join_qs.exists():
  384. member_join_qs.update(status=0, updated_time=now_time)
  385. data['uid'] = member_join_qs.first().id
  386. SysMsgModel.objects.create(**data)
  387. return response.json(0)
  388. family_user_join = FamilyMemberJoin.objects.create(family_id=family_id, user_id=join_user_id,
  389. status=0,
  390. updated_time=now_time,
  391. created_time=now_time,
  392. type=invite)
  393. data['uid'] = family_user_join.id
  394. SysMsgModel.objects.create(**data)
  395. return response.json(0)
  396. except Exception as e:
  397. print(e)
  398. return response.json(177, repr(e))
  399. @classmethod
  400. def get_msg_text(cls, nick_name, family_name, lang, is_invite=False):
  401. """
  402. 系统消息通知内容,中英文判断
  403. @param nick_name:
  404. @param family_name:
  405. @param lang:
  406. @param is_invite:
  407. @return:
  408. """
  409. if lang and lang == 'cn':
  410. if is_invite:
  411. msg_text = '{}请求加入你的{}'.format(nick_name, family_name)
  412. else:
  413. msg_text = '{}邀请你加入{}'.format(nick_name, family_name)
  414. else:
  415. if is_invite:
  416. msg_text = '{} Request to join your Homegroup {}'.format(nick_name, family_name)
  417. else:
  418. msg_text = '{} invite you to join the Homegroup {}'.format(nick_name, family_name)
  419. return msg_text
  420. @classmethod
  421. def member_join_page(cls, request_dict, response):
  422. """
  423. 家庭成员邀请记录
  424. @param request_dict:
  425. @param response:
  426. @return:
  427. """
  428. page_no = request_dict.get('pageNo', None)
  429. page_size = request_dict.get('pageSize', None)
  430. family_id = request_dict.get('familyId', None)
  431. if not all([page_no, page_size, family_id]):
  432. return response.json(444)
  433. member_join = FamilyMemberJoin.objects.filter(family_id=family_id).values('id', 'status', 'user__username',
  434. 'user__userIconUrl', 'user__phone',
  435. 'user__userEmail', 'updated_time',
  436. 'created_time',
  437. 'user__NickName')
  438. page_no = int(page_no)
  439. page_size = int(page_size)
  440. member_join = member_join.order_by('-updated_time')[(page_no - 1) * page_size: page_no * page_size]
  441. if not member_join.exists():
  442. return response.json(0, [])
  443. result = []
  444. for item in member_join:
  445. result.append({
  446. 'joinId': item['id'],
  447. 'status': item['status'],
  448. 'userName': item['user__username'],
  449. 'userIconUrl': item['user__userIconUrl'],
  450. 'phone': item['user__phone'],
  451. 'nickName': item['user__NickName'],
  452. 'userEmail': item['user__userEmail'],
  453. 'updatedTime': item['updated_time'],
  454. 'createdTime': item['created_time']
  455. })
  456. return response.json(0, result)
  457. @classmethod
  458. def family_generate_token(cls, app_user_id, request_dict, response):
  459. """
  460. 获取家庭令牌信息
  461. @param app_user_id:
  462. @param request_dict:
  463. @param response:
  464. @return:
  465. """
  466. family_id = request_dict.get('familyId', None)
  467. if not family_id:
  468. return response.json(444)
  469. family_id = int(family_id)
  470. family_qs = UserFamily.objects.filter(id=family_id, user_id=app_user_id) \
  471. .values('name', 'user__userEmail',
  472. 'user__userIconUrl',
  473. 'user__phone', 'user__NickName',
  474. 'user__username')
  475. if not family_qs.exists():
  476. return response.json(173)
  477. family_qs = family_qs.first()
  478. data = {'sharer': app_user_id, 'familyId': family_id}
  479. # -----------------
  480. # share_token = jwt.encode(data, '.#^^&', algorithm='HS256').decode('utf-8')
  481. # +++++++++++++++++
  482. redisObj = RedisObject()
  483. share_token = str(int(time.time())) + CommonService.RandomStr(22)
  484. if not redisObj.set_data(key=share_token, val=json.dumps(data), expire=300):
  485. return response.json(10, '生成失败')
  486. return response.json(0, {
  487. 'shareToken': share_token,
  488. 'userPhone': family_qs['user__phone'],
  489. 'nickName': family_qs['user__NickName'],
  490. 'userIconUrl': family_qs['user__userIconUrl'],
  491. 'userName': family_qs['user__username'],
  492. 'familyName': family_qs['name'],
  493. 'userEmail': family_qs['user__userEmail'],
  494. })
  495. @classmethod
  496. def check_qrcode(cls, request_dict, response):
  497. """
  498. 检查二维码是否过期
  499. @param request_dict:
  500. @param response:
  501. @return:
  502. """
  503. share_token = request_dict.get('shareToken', None)
  504. if not share_token:
  505. return response.json(444)
  506. redisObj = RedisObject()
  507. share_data = redisObj.get_data(key=share_token)
  508. if not share_data:
  509. return response.json(119)
  510. data = json.loads(share_data)
  511. sharer = data.get('sharer', None)
  512. family_id = data.get('familyId', None)
  513. if not all([sharer, family_id]):
  514. return response.json(173)
  515. family_id = int(family_id)
  516. user_family_qs = UserFamily.objects.filter(id=family_id)
  517. if not user_family_qs.exists():
  518. return response.json(173)
  519. user_family_qs = user_family_qs.values('id', 'name', 'user__userEmail',
  520. 'user__userIconPath',
  521. 'user__phone', 'user__NickName',
  522. 'user__username')
  523. user_icon_url = ''
  524. userIconPath = str(user_family_qs[0]['user__userIconPath'])
  525. if userIconPath and userIconPath.find('static/') != -1:
  526. userIconPath = userIconPath.replace('static/', '').replace('\\', '/')
  527. user_icon_url = SERVER_DOMAIN + 'account/getAvatar/' + userIconPath
  528. return response.json(0, {
  529. 'familyId': user_family_qs[0]['id'],
  530. 'userPhone': user_family_qs[0]['user__phone'],
  531. 'nickName': user_family_qs[0]['user__NickName'],
  532. 'userIconUrl': user_icon_url,
  533. 'userName': user_family_qs[0]['user__username'],
  534. 'familyName': user_family_qs[0]['name'],
  535. 'userEmail': user_family_qs[0]['user__userEmail'],
  536. })