CloudPhotoController.py 6.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167
  1. # -*- encoding: utf-8 -*-
  2. """
  3. @File : CronCloudPhotoController.py
  4. @Time : 2022/11/3 10:16
  5. @Author : stephen
  6. @Email : zhangdongming@asj6.wecom.work
  7. @Software: PyCharm
  8. """
  9. import logging
  10. import time
  11. from django.db import transaction
  12. from django.views import View
  13. from Ansjer.cn_config.config_test import PUSH_CLOUD_PHOTO
  14. from Ansjer.config import ACCESS_KEY_ID, SECRET_ACCESS_KEY, REGION_NAME
  15. from Model.models import DeviceCloudPhotoInfo, Device_Info, CloudPhotoBGM, DevicePicturePushInfo
  16. from Object.AWS.AmazonS3Util import AmazonS3Util
  17. from Object.ResponseObject import ResponseObject
  18. from Object.TokenObject import TokenObject
  19. LOGGER = logging.getLogger('info')
  20. class CronCloudPhotoView(View):
  21. def get(self, request, *args, **kwargs):
  22. request.encoding = 'utf-8'
  23. operation = kwargs.get('operation')
  24. return self.validation(request.GET, request, operation)
  25. def post(self, request, *args, **kwargs):
  26. request.encoding = 'utf-8'
  27. operation = kwargs.get('operation')
  28. return self.validation(request.POST, request, operation)
  29. def validation(self, request_dict, request, operation):
  30. token = TokenObject(request.META.get('HTTP_AUTHORIZATION'))
  31. lang = request_dict.get('lang', token.lang)
  32. response = ResponseObject(lang)
  33. if token.code != 0:
  34. return response.json(token.code)
  35. user_id = token.userID
  36. if operation == 'save-photo':
  37. return self.save_cloud_photo(user_id, request_dict, response)
  38. elif operation == 'bgm-list':
  39. return self.get_bgm_list(response)
  40. elif operation == 'video-list':
  41. return self.query_cloud_photo_page(user_id, request_dict, response)
  42. elif operation == 'video-del':
  43. return self.del_cloud_photo(request_dict, response)
  44. else:
  45. return response.json(404)
  46. @classmethod
  47. def save_cloud_photo(cls, user_id, request_dict, response):
  48. """
  49. 保存云相册
  50. """
  51. try:
  52. with transaction.atomic():
  53. status = request_dict.get('status', None)
  54. uid = request_dict.get('uid', None)
  55. if not all([status, user_id]):
  56. return response(444)
  57. status = int(status)
  58. device_info_qs = Device_Info.objects.filter(userID_id=user_id)
  59. if uid:
  60. device_info_qs = device_info_qs.filter(UID=uid)
  61. device_info_qs = device_info_qs.values('vodPrimaryUserID', 'UID')
  62. if not device_info_qs.exists():
  63. return response.json(14)
  64. for item in device_info_qs:
  65. master_user_id = item['vodPrimaryUserID']
  66. uid = item['UID']
  67. if master_user_id == '' or master_user_id != user_id:
  68. continue
  69. now_time = int(time.time())
  70. cloud_photo_qs = DeviceCloudPhotoInfo.objects.filter(uid=uid)
  71. if not cloud_photo_qs.exists():
  72. data = {'status': status, 'user_id': user_id, 'uid': uid, 'created_time': now_time,
  73. 'updated_time': now_time}
  74. DeviceCloudPhotoInfo.objects.create(**data)
  75. continue
  76. cloud_photo_qs.update(status=status, updated_time=now_time)
  77. return response.json(0)
  78. except Exception as e:
  79. LOGGER.info('异常详情,errLine:{}, errMsg:{}'.format(e.__traceback__.tb_lineno, repr(e)))
  80. return response.json(500)
  81. @classmethod
  82. def get_bgm_list(cls, response):
  83. """
  84. 获取背景音乐列表
  85. """
  86. photo_bgm = CloudPhotoBGM.objects.filter(is_show=1).values('name', 'link').order_by('sort')
  87. if not photo_bgm.exists():
  88. return response.json(0, [])
  89. return response.json(0, list(photo_bgm))
  90. @classmethod
  91. def query_cloud_photo_page(cls, user_id, request_dict, response):
  92. """
  93. 分页查询云相册视频
  94. @param user_id: 用户id
  95. @param request_dict: 请求参数
  96. @param response: 响应对象
  97. @return: []
  98. """
  99. try:
  100. device_name = request_dict.get('deviceName', None)
  101. start_time = request_dict.get('startTime', None)
  102. end_time = request_dict.get('endTime', None)
  103. page = request_dict.get('page', None)
  104. size = request_dict.get('size', None)
  105. if not all([page, size]):
  106. return response.json(444)
  107. page = int(page)
  108. size = int(size)
  109. video_qs = DevicePicturePushInfo.objects.filter(user_id=user_id, type=1)
  110. if device_name:
  111. video_qs = video_qs.filter(device_nick_name__icontains=device_name)
  112. if start_time:
  113. video_qs = video_qs.filter(event_time__gte=int(start_time))
  114. if end_time:
  115. video_qs = video_qs.filter(event_time__lte=int(end_time))
  116. video_qs = video_qs.values('id', 'uid', 'device_nick_name', 'event_time').order_by('-event_time')[
  117. (page - 1) * size:page * size]
  118. if not video_qs.exists():
  119. return response.json(0, [])
  120. s3 = AmazonS3Util(ACCESS_KEY_ID, SECRET_ACCESS_KEY, REGION_NAME)
  121. res_data = []
  122. for item in video_qs:
  123. data = {'id': item['id'], 'deviceNickname': item['device_nick_name']}
  124. key = '{}/video/{}.mp4'.format(item['uid'], str(item['event_time']))
  125. obj_url = s3.generate_file_obj_url(PUSH_CLOUD_PHOTO, key)
  126. data['videoLink'] = obj_url
  127. res_data.append(data)
  128. return response.json(0, res_data)
  129. except Exception as e:
  130. LOGGER.info('异常详情,errLine:{}, errMsg:{}'.format(e.__traceback__.tb_lineno, repr(e)))
  131. return response.json(500)
  132. @classmethod
  133. def del_cloud_photo(cls, request_dict, response):
  134. """
  135. 根据id删除视频列表
  136. @param request_dict:
  137. @param response:
  138. @return:
  139. """
  140. try:
  141. ids = request_dict.get('ids', None)
  142. if not ids:
  143. return response.json(444)
  144. cloud_photo_qs = DevicePicturePushInfo.objects.filter(id__in=ids.split(','))
  145. if not cloud_photo_qs.exists():
  146. return response.json(173)
  147. s3 = AmazonS3Util(ACCESS_KEY_ID, SECRET_ACCESS_KEY, REGION_NAME)
  148. for item in cloud_photo_qs:
  149. key = '{}/video/{}.mp4'.format(item.uid, str(item.event_time))
  150. s3.delete_obj(PUSH_CLOUD_PHOTO, key)
  151. cloud_photo_qs.delete()
  152. return response.json(0)
  153. except Exception as e:
  154. LOGGER.info('异常详情,errLine:{}, errMsg:{}'.format(e.__traceback__.tb_lineno, repr(e)))
  155. return response.json(500)