GatewayFamilyMemberController.py 24 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557
  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_member_qs = FamilyMember.objects.filter(family_id=family_id, identity=0)
  106. if family_member_qs.exists():
  107. return response.json(10057)
  108. family_room_dev_qs = FamilyRoomDevice.objects.filter(family_id=family_id)
  109. if family_room_dev_qs.exists():
  110. return response.json(10057)
  111. family_room_qs = FamilyRoom.objects.filter(family_id=family_id)
  112. if family_room_qs.exists():
  113. family_room_qs.delete()
  114. FamilyMember.objects.filter(family_id=family_id).delete()
  115. user_family_qs = UserFamily.objects.filter(id=family_id)
  116. if user_family_qs.exists():
  117. user_family_qs.delete()
  118. return response.json(0)
  119. return response.json(176)
  120. except Exception as e:
  121. print(e)
  122. return response.json(177, repr(e))
  123. @classmethod
  124. def family_created(cls, app_user_id, request_dict, response):
  125. """
  126. 创建家庭
  127. @param app_user_id:
  128. @param request_dict:
  129. @param response:
  130. @return:
  131. """
  132. family_name = request_dict.get('familyName', None)
  133. if not family_name:
  134. return response.json(444)
  135. n_time = int(time.time())
  136. location = request_dict.get('location', '')
  137. room_names = request_dict.get('roomNames', None)
  138. user_family_qs = UserFamily.objects.filter(name=family_name, user_id=app_user_id)
  139. if user_family_qs.exists():
  140. return response.json(174)
  141. try:
  142. with transaction.atomic():
  143. member_permission_qs = FamilyMemberPermission.objects.filter(no='001').values('id')
  144. user_family = UserFamily.objects.create(user_id=app_user_id, name=family_name,
  145. location=location,
  146. updated_time=n_time,
  147. created_time=n_time)
  148. if user_family.id:
  149. device_user = Device_User.objects.get(userID=app_user_id)
  150. permission_id = member_permission_qs.first()['id']
  151. FamilyMember.objects.create(family_id=user_family.id, user_id=app_user_id,
  152. user_name=device_user.username, identity=1,
  153. permission_id=int(permission_id), sort=1, updated_time=n_time,
  154. created_time=n_time)
  155. if room_names:
  156. names = room_names.split(',')
  157. rooms = []
  158. for index, item in enumerate(names):
  159. rooms.append(FamilyRoom(
  160. name=item,
  161. family_id=user_family.id,
  162. sort=index,
  163. updated_time=n_time,
  164. created_time=n_time
  165. ))
  166. FamilyRoom.objects.bulk_create(rooms)
  167. return response.json(0)
  168. except Exception as e:
  169. print(e)
  170. return response.json(177, repr(e))
  171. @classmethod
  172. def member_del(cls, app_user_id, request_dict, response):
  173. """
  174. 成员删除或退出
  175. @param app_user_id:
  176. @param request_dict:
  177. @param response:
  178. @return:
  179. """
  180. member_id = request_dict.get('memberId', None)
  181. family_id = request_dict.get('familyId', None)
  182. if not family_id:
  183. return response.json(444)
  184. try:
  185. family_id = int(family_id)
  186. with transaction.atomic():
  187. # 家庭所有者删除成员
  188. if member_id:
  189. is_owner = EquipmentFamilyView.get_family_owner(app_user_id, family_id)
  190. if not is_owner:
  191. return response.json(404)
  192. member_id = int(member_id)
  193. family_member_qs = FamilyMember.objects.filter(id=member_id)
  194. if not family_member_qs.exists():
  195. return response.json(173)
  196. family_member_qs.delete()
  197. return response.json(0)
  198. else:
  199. # 成员退出当前家庭
  200. family_member = FamilyMember.objects.filter(family_id=family_id, user_id=app_user_id, identity=1)
  201. if family_member.exists():
  202. return response.json(173)
  203. family_member_qs = FamilyMember.objects.filter(family_id=family_id, user_id=app_user_id)
  204. if not family_member_qs.exists():
  205. return response.json(173)
  206. family_member_qs.delete()
  207. return response.json(0)
  208. except Exception as e:
  209. return response.json(177, repr(e))
  210. @classmethod
  211. def user_join_confirm(cls, request_dict, response):
  212. """
  213. 用户加入家庭确认
  214. @param request_dict:
  215. @param response:
  216. @return:
  217. """
  218. join_id = request_dict.get('joinId', None)
  219. confirm = request_dict.get('confirm', None)
  220. lang = request_dict.get('lang', 'en')
  221. if not all([join_id, confirm]):
  222. return response.json(444)
  223. join_id = int(join_id)
  224. family_join = FamilyMemberJoin.objects.filter(id=join_id, status=0)
  225. if not family_join.exists():
  226. return response.json(173)
  227. family_member = FamilyMember.objects.filter(family_id=family_join.first().family_id,
  228. user_id=family_join.first().user_id)
  229. if family_member.exists():
  230. return response.json(174)
  231. try:
  232. now_time = int(time.time())
  233. with transaction.atomic():
  234. family_join.update(status=2 if confirm == 'confirm' else 1)
  235. family_join = FamilyMemberJoin.objects.filter(id=join_id)
  236. family_join = family_join.values('id', 'user_id', 'user__username', 'user__NickName', 'family__name',
  237. 'family_id', 'family__user_id', 'status', 'type', 'updated_time')
  238. family_join = family_join.first()
  239. nick_name = family_join['user__NickName']
  240. family_name = family_join['family__name']
  241. join_type = family_join['type']
  242. data = {
  243. 'addTime': now_time,
  244. 'updTime': now_time,
  245. 'userID_id': family_join['user_id'] if join_type == 1 else family_join['family__user_id'],
  246. 'eventType': 0
  247. }
  248. if confirm == 'confirm':
  249. msg_text = cls.get_confirm_text(nick_name, family_name, join_type, True, lang)
  250. p_id = FamilyMemberPermission.objects.filter(no='002').values('id').first()
  251. p_id = p_id['id']
  252. FamilyMember.objects.create(family_id=family_join['family_id'], updated_time=now_time,
  253. user_id=family_join['user_id'],
  254. created_time=now_time,
  255. permission_id=p_id,
  256. user_name=family_join['user__username'])
  257. elif confirm == 'refusal':
  258. msg_text = cls.get_confirm_text(nick_name, family_name, join_type, False, lang)
  259. else:
  260. ex = Exception("data is null")
  261. raise ex
  262. data['msg'] = msg_text
  263. data['uid'] = family_join['id']
  264. SysMsgModel.objects.create(**data)
  265. return response.json(0)
  266. except Exception as e:
  267. print(e)
  268. return response.json(177, repr(e))
  269. @classmethod
  270. def get_confirm_text(cls, nick_name, family_name, join_type, is_confirm, lang='en'):
  271. # join_type == 1等于扫码请求加u人
  272. if is_confirm:
  273. if join_type == 1:
  274. if lang == 'cn':
  275. msg_text = '{} 同意你的请求'.format(family_name)
  276. else:
  277. msg_text = '{} confirm to your request'.format(family_name)
  278. else:
  279. if lang == 'cn':
  280. msg_text = '{}同意加入{}'.format(nick_name, family_name)
  281. else:
  282. msg_text = '{} confirm to join {}'.format(nick_name, family_name)
  283. else:
  284. if join_type == 1:
  285. if lang == 'cn':
  286. msg_text = '{}拒绝你的请求'.format(family_name)
  287. else:
  288. msg_text = '{} refused your request'.format(family_name)
  289. else:
  290. if lang == 'cn':
  291. msg_text = '{}拒绝加入{}'.format(nick_name, family_name)
  292. else:
  293. msg_text = '{} refused to join '.format(family_name)
  294. return msg_text
  295. @classmethod
  296. def member_join_info(cls, request_dict, response):
  297. """
  298. 查询加入家庭信息
  299. @param request_dict:
  300. @param response:
  301. @return:
  302. """
  303. join_id = request_dict.get('joinId', None)
  304. if not join_id:
  305. return response.json(444)
  306. join_id = int(join_id)
  307. family_join_qs = FamilyMemberJoin.objects.filter(id=join_id)
  308. if not family_join_qs.exists():
  309. return response.json(173)
  310. family_join_qs = family_join_qs.values('type', 'user__NickName', 'family__name', 'status', 'id',
  311. 'family__user__NickName')
  312. family_join_qs = family_join_qs.first()
  313. nick_name = family_join_qs['user__NickName']
  314. if family_join_qs['type'] == 0:
  315. nick_name = family_join_qs['family__user__NickName']
  316. return response.json(0, {
  317. 'id': family_join_qs['id'],
  318. 'type': family_join_qs['type'],
  319. 'nickName': nick_name,
  320. 'familyName': family_join_qs['family__name'],
  321. 'status': family_join_qs['status'],
  322. })
  323. @classmethod
  324. def member_join(cls, app_user_id, request_dict, response):
  325. """
  326. 家庭成员加入
  327. @param app_user_id:
  328. @param request_dict:
  329. @param response:
  330. @return:
  331. """
  332. family_id = request_dict.get('familyId', None)
  333. invite = request_dict.get('QRCodeInvite', 0)
  334. user_id = request_dict.get('app_user_id', None)
  335. lang = request_dict.get('lang', 'en')
  336. if not all([family_id, invite]):
  337. return response.json(444)
  338. invite = int(invite)
  339. family_id = int(family_id)
  340. now_time = int(time.time())
  341. # 判断当前家庭是否已有该成员
  342. if invite == 1:
  343. family_qs = FamilyMember.objects.filter(family_id=family_id, user_id=app_user_id)
  344. elif user_id:
  345. family_qs = FamilyMember.objects.filter(family_id=family_id, user_id=user_id)
  346. else:
  347. return response.json(173)
  348. if family_qs.exists():
  349. return response.json(174)
  350. try:
  351. user_family_qs = UserFamily.objects.filter(id=family_id)
  352. if not user_family_qs:
  353. return response.json(173)
  354. user_family = user_family_qs.first()
  355. family_name = user_family.name
  356. data = {
  357. 'addTime': now_time,
  358. 'updTime': now_time,
  359. 'eventType': 705
  360. }
  361. # 请求加入家庭,用户信息
  362. user_qs = Device_User.objects.filter(userID=app_user_id)
  363. nick_name = user_qs.first().NickName
  364. if invite == 1:
  365. msg_text = cls.get_msg_text(nick_name, family_name, lang, True)
  366. # 通知对象 家庭所有者
  367. join_user_id = app_user_id
  368. data['userID_id'] = user_family.user_id
  369. elif app_user_id:
  370. msg_text = cls.get_msg_text(nick_name, family_name, lang, False)
  371. # 通知对象 被邀请人
  372. join_user_id = user_id
  373. data['userID_id'] = user_id
  374. else:
  375. return response.json(173)
  376. data['msg'] = msg_text
  377. with transaction.atomic():
  378. member_user_id = user_id if user_id else app_user_id
  379. member_join_qs = FamilyMemberJoin.objects.filter(family_id=family_id, user_id=member_user_id)
  380. if member_join_qs.exists():
  381. member_join_qs.update(status=0, updated_time=now_time)
  382. data['uid'] = member_join_qs.first().id
  383. SysMsgModel.objects.create(**data)
  384. return response.json(0)
  385. family_user_join = FamilyMemberJoin.objects.create(family_id=family_id, user_id=join_user_id,
  386. status=0,
  387. updated_time=now_time,
  388. created_time=now_time,
  389. type=invite)
  390. data['uid'] = family_user_join.id
  391. SysMsgModel.objects.create(**data)
  392. return response.json(0)
  393. except Exception as e:
  394. print(e)
  395. return response.json(177, repr(e))
  396. @classmethod
  397. def get_msg_text(cls, nick_name, family_name, lang, is_invite=False):
  398. """
  399. 系统消息通知内容,中英文判断
  400. @param nick_name:
  401. @param family_name:
  402. @param lang:
  403. @param is_invite:
  404. @return:
  405. """
  406. if lang and lang == 'cn':
  407. if is_invite:
  408. msg_text = '{}请求加入你的{}'.format(nick_name, family_name)
  409. else:
  410. msg_text = '{}邀请你加入{}'.format(nick_name, family_name)
  411. else:
  412. if is_invite:
  413. msg_text = '{} Request to join your Homegroup {}'.format(nick_name, family_name)
  414. else:
  415. msg_text = '{} invite you to join the Homegroup {}'.format(nick_name, family_name)
  416. return msg_text
  417. @classmethod
  418. def member_join_page(cls, request_dict, response):
  419. """
  420. 家庭成员邀请记录
  421. @param request_dict:
  422. @param response:
  423. @return:
  424. """
  425. page_no = request_dict.get('pageNo', None)
  426. page_size = request_dict.get('pageSize', None)
  427. family_id = request_dict.get('familyId', None)
  428. if not all([page_no, page_size, family_id]):
  429. return response.json(444)
  430. member_join = FamilyMemberJoin.objects.filter(family_id=family_id).values('id', 'status', 'user__username',
  431. 'user__userIconUrl', 'user__phone',
  432. 'user__userEmail', 'updated_time',
  433. 'created_time',
  434. 'user__NickName')
  435. page_no = int(page_no)
  436. page_size = int(page_size)
  437. member_join = member_join.order_by('-updated_time')[(page_no - 1) * page_size: page_no * page_size]
  438. if not member_join.exists():
  439. return response.json(0, [])
  440. result = []
  441. for item in member_join:
  442. result.append({
  443. 'joinId': item['id'],
  444. 'status': item['status'],
  445. 'userName': item['user__username'],
  446. 'userIconUrl': item['user__userIconUrl'],
  447. 'phone': item['user__phone'],
  448. 'nickName': item['user__NickName'],
  449. 'userEmail': item['user__userEmail'],
  450. 'updatedTime': item['updated_time'],
  451. 'createdTime': item['created_time']
  452. })
  453. return response.json(0, result)
  454. @classmethod
  455. def family_generate_token(cls, app_user_id, request_dict, response):
  456. """
  457. 获取家庭令牌信息
  458. @param app_user_id:
  459. @param request_dict:
  460. @param response:
  461. @return:
  462. """
  463. family_id = request_dict.get('familyId', None)
  464. if not family_id:
  465. return response.json(444)
  466. family_id = int(family_id)
  467. family_qs = UserFamily.objects.filter(id=family_id, user_id=app_user_id) \
  468. .values('name', 'user__userEmail',
  469. 'user__userIconUrl',
  470. 'user__phone', 'user__NickName',
  471. 'user__username')
  472. if not family_qs.exists():
  473. return response.json(173)
  474. family_qs = family_qs.first()
  475. data = {'sharer': app_user_id, 'familyId': family_id}
  476. # -----------------
  477. # share_token = jwt.encode(data, '.#^^&', algorithm='HS256').decode('utf-8')
  478. # +++++++++++++++++
  479. redisObj = RedisObject()
  480. share_token = str(int(time.time())) + CommonService.RandomStr(22)
  481. if not redisObj.set_data(key=share_token, val=json.dumps(data), expire=300):
  482. return response.json(10, '生成失败')
  483. return response.json(0, {
  484. 'shareToken': share_token,
  485. 'userPhone': family_qs['user__phone'],
  486. 'nickName': family_qs['user__NickName'],
  487. 'userIconUrl': family_qs['user__userIconUrl'],
  488. 'userName': family_qs['user__username'],
  489. 'familyName': family_qs['name'],
  490. 'userEmail': family_qs['user__userEmail'],
  491. })
  492. @classmethod
  493. def check_qrcode(cls, request_dict, response):
  494. """
  495. 检查二维码是否过期
  496. @param request_dict:
  497. @param response:
  498. @return:
  499. """
  500. share_token = request_dict.get('shareToken', None)
  501. if not share_token:
  502. return response.json(444)
  503. redisObj = RedisObject()
  504. share_data = redisObj.get_data(key=share_token)
  505. if not share_data:
  506. return response.json(119)
  507. data = json.loads(share_data)
  508. sharer = data.get('sharer', None)
  509. family_id = data.get('familyId', None)
  510. if not all([sharer, family_id]):
  511. return response.json(173)
  512. family_id = int(family_id)
  513. user_family_qs = UserFamily.objects.filter(id=family_id)
  514. if not user_family_qs.exists():
  515. return response.json(173)
  516. user_family_qs = user_family_qs.values('id', 'name', 'user__userEmail',
  517. 'user__userIconPath',
  518. 'user__phone', 'user__NickName',
  519. 'user__username')
  520. user_icon_url = ''
  521. userIconPath = str(user_family_qs[0]['user__userIconPath'])
  522. if userIconPath and userIconPath.find('static/') != -1:
  523. userIconPath = userIconPath.replace('static/', '').replace('\\', '/')
  524. user_icon_url = SERVER_DOMAIN + 'account/getAvatar/' + userIconPath
  525. return response.json(0, {
  526. 'familyId': user_family_qs[0]['id'],
  527. 'userPhone': user_family_qs[0]['user__phone'],
  528. 'nickName': user_family_qs[0]['user__NickName'],
  529. 'userIconUrl': user_icon_url,
  530. 'userName': user_family_qs[0]['user__username'],
  531. 'familyName': user_family_qs[0]['name'],
  532. 'userEmail': user_family_qs[0]['user__userEmail'],
  533. })