BabyController.py 7.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178
  1. # -*- encoding: utf-8 -*-
  2. """
  3. @File : BabyController.py
  4. @Time : 2024-10-7 14:37:30
  5. @Author : peng
  6. @Email :
  7. @Software: PyCharm
  8. """
  9. import json
  10. import time
  11. from django.db import transaction
  12. from django.db.models import F, Q, Count
  13. from django.views import View
  14. from Ansjer.cn_config.config_formal import SECRET_ACCESS_KEY, ACCESS_KEY_ID, REGION_NAME
  15. from Object.AWS.AmazonS3Util import AmazonS3Util
  16. from Roomumy.models import BabyUser, BabyGrowthStandard
  17. from Object.ResponseObject import ResponseObject
  18. from Service.CommonService import CommonService
  19. class BabyView(View):
  20. def get(self, request, *args, **kwargs):
  21. request.encoding = 'utf-8'
  22. operation = kwargs.get('operation')
  23. return self.validation(request.GET, request, operation)
  24. def post(self, request, *args, **kwargs):
  25. request.encoding = 'utf-8'
  26. operation = kwargs.get('operation')
  27. return self.validation(request.POST, request, operation)
  28. def validation(self, request_dict, request, operation):
  29. token_code, user_id, response = CommonService.verify_token_get_user_id(request_dict, request)
  30. if token_code != 0:
  31. return response.json(token_code)
  32. if operation == 'addOrEdit': # 添加修改宝宝信息
  33. return self.add_or_edit_baby(request, request_dict, user_id, ResponseObject('cn'))
  34. elif operation == 'query': # 获取宝宝信息
  35. return self.query_baby_info(request_dict, user_id, ResponseObject('cn'))
  36. elif operation == 'delete': # 删除宝宝信息
  37. return self.delete_baby(request_dict, user_id, ResponseObject('cn'))
  38. else:
  39. return response.json(414)
  40. @classmethod
  41. def add_or_edit_baby(cls, request, request_dict, user_id, response):
  42. """
  43. 添加或修改宝宝信息
  44. @param request_dict: 请求参数
  45. @param request: 请求
  46. @param user_id: 用户id
  47. @request_dict device_id: 设备id
  48. @request_dict baby_id: 宝宝id
  49. @request_dict nick_name: 昵称
  50. @request_dict sex: 性别
  51. @request_dict birthday: 生日
  52. @request_dict icon: 头像
  53. @request_dict is_default: 是否默认
  54. @param response: 响应对象
  55. @return: response
  56. """
  57. device_id = request_dict.get('device_id', None)
  58. baby_id = request_dict.get('baby_id', None)
  59. nick_name = request_dict.get('nick_name', None)
  60. sex = request_dict.get('sex', None)
  61. birthday = request_dict.get('birthday', None)
  62. icon = request.FILES.get('icon', None)
  63. is_default = request_dict.get('is_default', 0)
  64. if not all([nick_name, sex, birthday]):
  65. return response.json(404)
  66. now_time = int(time.time())
  67. bucket = "ansjerfilemanager"
  68. s3_url = 'https://{}.s3.{}.amazonaws.com.cn/'.format(bucket, REGION_NAME)
  69. try:
  70. with transaction.atomic():
  71. if baby_id:
  72. BabyUser.objects.filter(id=baby_id, user_id=user_id).update(is_default=is_default,
  73. birthday=birthday,
  74. nick_name=nick_name, sex=sex,
  75. device_id=device_id,
  76. updated_time=now_time)
  77. else:
  78. if sex == '1':
  79. icon_url = s3_url + 'Roomumy/boy.jpg'
  80. else:
  81. icon_url = s3_url + 'Roomumy/girl.jpg'
  82. baby_qs = BabyUser.objects.create(user_id=user_id, is_default=is_default, birthday=birthday,
  83. nick_name=nick_name, sex=sex, device_id=device_id,
  84. created_time=now_time, updated_time=now_time, icon_url=icon_url)
  85. baby_id = baby_qs.id
  86. if icon:
  87. s3_obj = AmazonS3Util(ACCESS_KEY_ID, SECRET_ACCESS_KEY, REGION_NAME)
  88. icon_path = 'Roomumy/icon_{}.jpg'.format(baby_id)
  89. s3_obj.upload_file_obj(
  90. bucket,
  91. icon_path,
  92. icon,
  93. {"ContentType": icon.content_type, "ACL": "public-read"},
  94. )
  95. icon_url = s3_url + icon_path
  96. BabyUser.objects.filter(id=baby_id, user_id=user_id).update(icon_url=icon_url)
  97. if is_default == '1':
  98. BabyUser.objects.filter(user_id=user_id).exclude(id=baby_id).update(is_default=False)
  99. return response.json(0)
  100. except Exception as e:
  101. return response.json(500, 'error_line:{}, error_msg:{}'.format(e.__traceback__.tb_lineno, repr(e)))
  102. @classmethod
  103. def query_baby_info(cls, request_dict, user_id, response):
  104. """
  105. 获取宝宝信息
  106. """
  107. baby_id = request_dict.get('baby_id', None)
  108. try:
  109. baby_qs = BabyUser.objects.filter(user_id=user_id)
  110. if baby_id:
  111. baby_qs = baby_qs.filter(id=baby_id)
  112. count = baby_qs.count()
  113. baby_list = list(
  114. baby_qs.values('id', 'nick_name', 'sex', 'birthday', 'icon_url', 'device_id', 'is_default'))
  115. current_time = int(time.time()) # 获取当前时间戳
  116. for baby in baby_list:
  117. birthday = baby.get('birthday', 0)
  118. baby['growth_standard'] = None # 初始化字段
  119. # 仅处理有效生日数据
  120. if birthday > 0:
  121. age_days = (current_time - birthday) // 86400 # 计算年龄天数
  122. # 查询成长标准数据
  123. standards = BabyGrowthStandard.objects.filter(
  124. age_min__lte=age_days,
  125. age_max__gte=age_days,
  126. gender=baby.get('sex', 0) # 默认性别为女
  127. ).first() # 直接获取第一条匹配记录
  128. if standards:
  129. baby['growth_standard'] = {
  130. 'height': {'min': standards.height_min, 'max': standards.height_max},
  131. 'weight': {'min': standards.weight_min, 'max': standards.weight_max},
  132. 'head_circumference': {
  133. 'min': standards.head_circumference_min,
  134. 'max': standards.head_circumference_max
  135. }
  136. }
  137. else:
  138. baby['growth_standard'] = {
  139. 'height': {'min': None, 'max': None},
  140. 'weight': {'min': None, 'max': None},
  141. 'head_circumference': {'min': None, 'max': None}
  142. }
  143. return response.json(0, {'total': count, 'baby_list': baby_list})
  144. except Exception as e:
  145. return response.json(500, f'error_line:{e.__traceback__.tb_lineno}, error_msg:{repr(e)}')
  146. @classmethod
  147. def delete_baby(cls, request_dict, user_id, response):
  148. """
  149. 删除宝宝信息
  150. @param request_dict: 请求参数
  151. @param user_id: 用户id
  152. @request_dict baby_id: 宝宝id
  153. @param response: 响应对象
  154. @return: response
  155. """
  156. baby_id = request_dict.get('baby_id', None)
  157. try:
  158. BabyUser.objects.filter(user_id=user_id, id=baby_id).delete()
  159. return response.json(0)
  160. except Exception as e:
  161. return response.json(500, 'error_line:{}, error_msg:{}'.format(e.__traceback__.tb_lineno, repr(e)))