ASJPush/Controller/DetectController.py

#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
@Copyright (C) ansjer cop Video Technology Co.,Ltd.All rights reserved.
@AUTHOR: ASJRD018
@NAME: AnsjerFormal
@software: PyCharm
@DATE: 2019/1/14 15:57
@Version: python3.6
@MODIFY DECORD:ansjer dev
@file: DetectController.py
@Contact: chanjunkai@163.com
"""
import os
import time

import apns2
import jpush as jpush
import oss2
from django.http import JsonResponse
from django.views.generic.base import View
from pyfcm import FCMNotification

from AnsjerPush.config import OSS_STS_ACCESS_KEY, OSS_STS_ACCESS_SECRET, DETECT_PUSH_DOMAIN, JPUSH_CONFIG, \
    FCM_CONFIG, APNS_CONFIG, BASE_DIR, APNS_MODE
from Model.models import Equipment_Info, UidPushModel, SysMsgModel
from Object.ETkObject import ETkObject
from Object.RedisObject import RedisObject
from Object.UidTokenObject import UidTokenObject
from Service.CommonService import CommonService

'''
http://push.dvema.com/notify/push?etk=Y2lTRXhMTjBWS01sWlpURTVJU0ZWTlJ6RXhNVUU9T3o=&n_time=1526845794&channel=1&event_type=704&is_st=0
http://push.dvema.com/deviceShadow/generateUTK?username=debug_user&password=debug_password&uid=VVDHCVBYDKFMJRWA111A
'''


# 移动侦测接口
class NotificationView(View):

    def get(self, request, *args, **kwargs):
        request.encoding = 'utf-8'
        return self.validation(request.GET)

    def post(self, request, *args, **kwargs):
        request.encoding = 'utf-8'
        return self.validation(request.POST)

    def validation(self, request_dict):
        uidToken = request_dict.get('uidToken', None)
        etk = request_dict.get('etk', None)
        channel = request_dict.get('channel', '1')
        n_time = request_dict.get('n_time', None)
        event_type = request_dict.get('event_type', None)
        is_st = request_dict.get('is_st', None)
        # print("aaa")
        # return JsonResponse(0,safe=False)
        if not all([channel, n_time]):
            return JsonResponse(status=200, data={
                'code': 444,
                'msg': 'param is wrong'})
        if etk:
            eto = ETkObject(etk)
            uid = eto.uid
            # uid += channel
            if len(uid) != 20:
                return JsonResponse(status=200, data={'code': 404, 'msg': 'data is not exist'})
        else:
            utko = UidTokenObject(uidToken)
            uid = utko.UID
            uid = 'HLK7EJ2VYLNHHUMG111A'

        redisObj = RedisObject(db=6)
        pkey = '{uid}_{channel}_ptl'.format(uid=uid, channel=channel)
        ykey = '{uid}_redis_qs'.format(uid=uid)
        dkey = '{uid}_{event_type}_redis_qs'.format(uid=uid, event_type=event_type)
        # 第二次，一分钟内不推，不存
        if redisObj.get_data(key=pkey):
            res_data = {'code': 0, 'msg': 'success!'}
            return JsonResponse(status=200, data=res_data)
        # 第一次，没有,没有dkey，也没有ykey
        if not redisObj.get_data(key=dkey) and not redisObj.get_data(key=ykey):
                print("第一次进来，设置dkey和pkey为interval秒")
                # 设置推送时间为60秒一次
                redisObj.set_data(key=pkey, val=1, expire=60)
                print("从数据库查到数据")
                # 从数据库查询出来
                uid_push_qs = UidPushModel.objects.filter(uid_set__uid='HLK7EJ2VYLNHHUMG111A'). \
                    values('token_val', 'app_type', 'appBundleId',
                           'push_type', 'userID_id', 'lang',
                           'tz', 'uid_set__nickname', 'uid_set__detect_interval', 'uid_set__detect_group')
                print(uid_push_qs)
                first_redis_list = []
                # 把数据库数据追加进redis_list
                for qs in uid_push_qs:
                    first_redis_list.append(qs)
                redis_list = first_redis_list
                detect_interval = redis_list[0]['uid_set__detect_interval']
                detect_group = redis_list[0]['uid_set__detect_group']
                if detect_group:
                    detect_group_list = detect_group.split(',')
                    if event_type in detect_group_list:
                        redisObj.set_data(key=dkey, val=1, expire=detect_interval)
                # 把ykey的时间也设置成跟dkey一样
                redisObj.set_data(key=ykey, val=str(redis_list), expire=600)
                if redis_list:
                    nickname = redis_list[0]['uid_set__nickname']
                    now_time = int(time.time())
                    if not nickname:
                        nickname = uid
                    # 判断是否为系统类通知
                    is_sys_msg = self.is_sys_msg(int(event_type))
                    auth = oss2.Auth(OSS_STS_ACCESS_KEY, OSS_STS_ACCESS_SECRET)
                    bucket = oss2.Bucket(auth, 'oss-cn-shenzhen.aliyuncs.com', 'apg')
                    kwag_args = {
                        'uid': uid,
                        'channel': channel,
                        'event_type': event_type,
                        'n_time': n_time,
                        # 'appBundleId': appBundleId,
                        # 'token_val': token_val,
                        # 'msg_title': msg_title,
                        # 'msg_text': msg_text
                    }
                    eq_list = []
                    sys_msg_list = []
                    userID_ids = []
                    for up in redis_list:
                        push_type = up['push_type']
                        appBundleId = up['appBundleId']
                        token_val = up['token_val']
                        lang = up['lang']
                        tz = up['tz']
                        # 发送标题
                        msg_title = self.get_msg_title(appBundleId=appBundleId, nickname=nickname)
                        # 发送内容
                        msg_text = self.get_msg_text(channel=channel, n_time=n_time, lang=lang, tz=tz,
                                                     event_type=event_type)
                        kwag_args['appBundleId'] = appBundleId
                        kwag_args['token_val'] = token_val
                        kwag_args['msg_title'] = msg_title
                        kwag_args['msg_text'] = msg_text
                        #第一次进来，才推送
                        if first_redis_list:
                            print("第一次进来推送")
                            if push_type == 0:  # ios apns
                                self.do_apns(**kwag_args)
                            elif push_type == 1:  # android gcm
                                self.do_fcm(**kwag_args)
                            elif push_type == 2:  # android jpush
                                self.do_jpush(**kwag_args)
                        userID_id = up["userID_id"]
                        int_is_st = int(is_st)
                        if userID_id not in userID_ids:
                            eq_list.append(Equipment_Info(
                                userID_id=userID_id,
                                eventTime=n_time,
                                eventType=event_type,
                                devUid=uid,
                                devNickName=nickname,
                                Channel=channel,
                                alarm='Motion \tChannel:{channel}'.format(channel=channel),
                                is_st=int_is_st,
                                receiveTime=n_time,
                                addTime=now_time
                            ))
                            if is_sys_msg:
                                sys_msg_text = self.get_msg_text(channel=channel, n_time=n_time, lang=lang, tz=tz,
                                                                 event_type=event_type, is_sys=1)
                                sys_msg_list.append(SysMsgModel(
                                    userID_id=userID_id,
                                    msg=sys_msg_text,
                                    addTime=now_time,
                                    updTime=now_time,
                                    uid=uid,
                                    eventType=event_type))
                            userID_ids.append(userID_id)

                    if is_sys_msg:
                        SysMsgModel.objects.bulk_create(sys_msg_list)
                    Equipment_Info.objects.bulk_create(eq_list)
                    # 以下是存库
                    if is_st == '0' or is_st == '2':
                        return JsonResponse(status=200, data={'code': 0, 'msg': 'success'})
                    elif is_st == '1':
                        # Endpoint以杭州为例，其它Region请按实际情况填写。
                        obj = '{uid}/{channel}/{filename}.jpeg'.format(uid=uid, channel=channel, filename=n_time)
                        # 设置此签名URL在60秒内有效。
                        url = bucket.sign_url('PUT', obj, 7200)
                        res_data = {'code': 0, 'img_push': url, 'msg': 'success'}
                        return JsonResponse(status=200, data=res_data)
                    elif is_st == '3':
                        # 人形检测带动图
                        # Endpoint以杭州为例，其它Region请按实际情况填写。
                        img_url_list = []
                        for i in range(int(is_st)):
                            obj = '{uid}/{channel}/{filename}_{st}.jpeg'. \
                                format(uid=uid, channel=channel, filename=n_time, st=i)
                            # 设置此签名URL在60秒内有效。
                            url = bucket.sign_url('PUT', obj, 7200)
                            img_url_list.append(url)
                        res_data = {'code': 0, 'img_url_list': img_url_list, 'msg': 'success'}
                        return JsonResponse(status=200, data=res_data)
        # 第三次，有dkey,也有ykey（一分钟外，10分钟内）
        if redisObj.get_data(key=dkey) and  redisObj.get_data(key=ykey):
            redis_data = redisObj.get_data(key=ykey)
            if redis_data:
                first_redis_list = ''
                redis_list = eval(redis_data)
            if redis_list:
                nickname = redis_list[0]['uid_set__nickname']
                now_time = int(time.time())
                if not nickname:
                    nickname = uid
                # 判断是否为系统类通知
                is_sys_msg = self.is_sys_msg(int(event_type))
                auth = oss2.Auth(OSS_STS_ACCESS_KEY, OSS_STS_ACCESS_SECRET)
                bucket = oss2.Bucket(auth, 'oss-cn-shenzhen.aliyuncs.com', 'apg')
                kwag_args = {
                    'uid': uid,
                    'channel': channel,
                    'event_type': event_type,
                    'n_time': n_time,
                    # 'appBundleId': appBundleId,
                    # 'token_val': token_val,
                    # 'msg_title': msg_title,
                    # 'msg_text': msg_text
                }
                eq_list = []
                sys_msg_list = []
                userID_ids = []
                for up in redis_list:
                    push_type = up['push_type']
                    appBundleId = up['appBundleId']
                    token_val = up['token_val']
                    lang = up['lang']
                    tz = up['tz']
                    # 发送标题
                    msg_title = self.get_msg_title(appBundleId=appBundleId, nickname=nickname)
                    # 发送内容
                    msg_text = self.get_msg_text(channel=channel, n_time=n_time, lang=lang, tz=tz,
                                                 event_type=event_type)
                    kwag_args['appBundleId'] = appBundleId
                    kwag_args['token_val'] = token_val
                    kwag_args['msg_title'] = msg_title
                    kwag_args['msg_text'] = msg_text
                    # 第一次进来，才推送
                    if first_redis_list:
                        print("第一次进来推送")
                        if push_type == 0:  # ios apns
                            self.do_apns(**kwag_args)
                        elif push_type == 1:  # android gcm
                            self.do_fcm(**kwag_args)
                        elif push_type == 2:  # android jpush
                            self.do_jpush(**kwag_args)
                    userID_id = up["userID_id"]
                    int_is_st = int(is_st)
                    if userID_id not in userID_ids:
                        eq_list.append(Equipment_Info(
                            userID_id=userID_id,
                            eventTime=n_time,
                            eventType=event_type,
                            devUid=uid,
                            devNickName=nickname,
                            Channel=channel,
                            alarm='Motion \tChannel:{channel}'.format(channel=channel),
                            is_st=int_is_st,
                            receiveTime=n_time,
                            addTime=now_time
                        ))
                        if is_sys_msg:
                            sys_msg_text = self.get_msg_text(channel=channel, n_time=n_time, lang=lang, tz=tz,
                                                             event_type=event_type, is_sys=1)
                            sys_msg_list.append(SysMsgModel(
                                userID_id=userID_id,
                                msg=sys_msg_text,
                                addTime=now_time,
                                updTime=now_time,
                                uid=uid,
                                eventType=event_type))
                        userID_ids.append(userID_id)

                if is_sys_msg:
                    SysMsgModel.objects.bulk_create(sys_msg_list)
                Equipment_Info.objects.bulk_create(eq_list)
                # 以下是存库
                if is_st == '0' or is_st == '2':
                    return JsonResponse(status=200, data={'code': 0, 'msg': 'success'})
                elif is_st == '1':
                    # Endpoint以杭州为例，其它Region请按实际情况填写。
                    obj = '{uid}/{channel}/{filename}.jpeg'.format(uid=uid, channel=channel, filename=n_time)
                    # 设置此签名URL在60秒内有效。
                    url = bucket.sign_url('PUT', obj, 7200)
                    res_data = {'code': 0, 'img_push': url, 'msg': 'success'}
                    return JsonResponse(status=200, data=res_data)
                elif is_st == '3':
                    # 人形检测带动图
                    # Endpoint以杭州为例，其它Region请按实际情况填写。
                    img_url_list = []
                    for i in range(int(is_st)):
                        obj = '{uid}/{channel}/{filename}_{st}.jpeg'. \
                            format(uid=uid, channel=channel, filename=n_time, st=i)
                        # 设置此签名URL在60秒内有效。
                        url = bucket.sign_url('PUT', obj, 7200)
                        img_url_list.append(url)
                    res_data = {'code': 0, 'img_url_list': img_url_list, 'msg': 'success'}
                    return JsonResponse(status=200, data=res_data)
        #第四次，没有dkey，有ykey（1分钟外，10分钟内   ）
        if not redisObj.get_data(key=dkey) and  redisObj.get_data(key=ykey):
            redis_data = redisObj.get_data(key=ykey)
            if redis_data:
                first_redis_list = ''
                redis_list = eval(redis_data)
            if redis_list:
                nickname = redis_list[0]['uid_set__nickname']
                now_time = int(time.time())
                if not nickname:
                    nickname = uid
                # 判断是否为系统类通知
                is_sys_msg = self.is_sys_msg(int(event_type))
                auth = oss2.Auth(OSS_STS_ACCESS_KEY, OSS_STS_ACCESS_SECRET)
                bucket = oss2.Bucket(auth, 'oss-cn-shenzhen.aliyuncs.com', 'apg')
                kwag_args = {
                    'uid': uid,
                    'channel': channel,
                    'event_type': event_type,
                    'n_time': n_time,
                    # 'appBundleId': appBundleId,
                    # 'token_val': token_val,
                    # 'msg_title': msg_title,
                    # 'msg_text': msg_text
                }
                eq_list = []
                sys_msg_list = []
                userID_ids = []
                for up in redis_list:
                    push_type = up['push_type']
                    appBundleId = up['appBundleId']
                    token_val = up['token_val']
                    lang = up['lang']
                    tz = up['tz']
                    # 发送标题
                    msg_title = self.get_msg_title(appBundleId=appBundleId, nickname=nickname)
                    # 发送内容
                    msg_text = self.get_msg_text(channel=channel, n_time=n_time, lang=lang, tz=tz,
                                                 event_type=event_type)
                    kwag_args['appBundleId'] = appBundleId
                    kwag_args['token_val'] = token_val
                    kwag_args['msg_title'] = msg_title
                    kwag_args['msg_text'] = msg_text
                    if first_redis_list:
                        if push_type == 0:  # ios apns
                            self.do_apns(**kwag_args)
                        elif push_type == 1:  # android gcm
                            self.do_fcm(**kwag_args)
                        elif push_type == 2:  # android jpush
                            self.do_jpush(**kwag_args)
                    userID_id = up["userID_id"]
                    int_is_st = int(is_st)
                    if userID_id not in userID_ids:
                        eq_list.append(Equipment_Info(
                            userID_id=userID_id,
                            eventTime=n_time,
                            eventType=event_type,
                            devUid=uid,
                            devNickName=nickname,
                            Channel=channel,
                            alarm='Motion \tChannel:{channel}'.format(channel=channel),
                            is_st=int_is_st,
                            receiveTime=n_time,
                            addTime=now_time
                        ))
                        if is_sys_msg:
                            sys_msg_text = self.get_msg_text(channel=channel, n_time=n_time, lang=lang, tz=tz,
                                                             event_type=event_type, is_sys=1)
                            sys_msg_list.append(SysMsgModel(
                                userID_id=userID_id,
                                msg=sys_msg_text,
                                addTime=now_time,
                                updTime=now_time,
                                uid=uid,
                                eventType=event_type))
                        userID_ids.append(userID_id)

                if is_sys_msg:
                    SysMsgModel.objects.bulk_create(sys_msg_list)
                Equipment_Info.objects.bulk_create(eq_list)
                # 以下是存库
                if is_st == '0' or is_st == '2':
                    return JsonResponse(status=200, data={'code': 0, 'msg': 'success'})
                elif is_st == '1':
                    # Endpoint以杭州为例，其它Region请按实际情况填写。
                    obj = '{uid}/{channel}/{filename}.jpeg'.format(uid=uid, channel=channel, filename=n_time)
                    # 设置此签名URL在60秒内有效。
                    url = bucket.sign_url('PUT', obj, 7200)
                    res_data = {'code': 0, 'img_push': url, 'msg': 'success'}
                    return JsonResponse(status=200, data=res_data)
                elif is_st == '3':
                    # 人形检测带动图
                    # Endpoint以杭州为例，其它Region请按实际情况填写。
                    img_url_list = []
                    for i in range(int(is_st)):
                        obj = '{uid}/{channel}/{filename}_{st}.jpeg'. \
                            format(uid=uid, channel=channel, filename=n_time, st=i)
                        # 设置此签名URL在60秒内有效。
                        url = bucket.sign_url('PUT', obj, 7200)
                        img_url_list.append(url)
                    res_data = {'code': 0, 'img_url_list': img_url_list, 'msg': 'success'}
                    return JsonResponse(status=200, data=res_data)



    def get_msg_title(self, appBundleId, nickname):
        package_title_config = {
            'com.ansjer.customizedd_a': 'DVS',
            'com.ansjer.zccloud_a': 'ZosiSmart',
            'com.ansjer.zccloud_ab': '周视',
            'com.ansjer.adcloud_a': 'ADCloud',
            'com.ansjer.adcloud_ab': 'ADCloud',
            'com.ansjer.accloud_a': 'ACCloud',
            'com.ansjer.loocamccloud_a': 'Loocam',
            'com.ansjer.loocamdcloud_a': 'Anlapus',
            'com.ansjer.customizedb_a': 'COCOONHD',
            'com.ansjer.customizeda_a': 'Guardian365',
            'com.ansjer.customizedc_a': 'PatrolSecure',
        }
        if appBundleId in package_title_config.keys():
            return package_title_config[appBundleId] + '(' + nickname + ')'
        else:
            return nickname

    def is_sys_msg(self, event_type):
        event_type_list = [702, 703, 704]
        if event_type in event_type_list:
            return True
        return False

    def get_msg_text(self, channel, n_time, lang, tz, event_type, is_sys=0):
        n_date = CommonService.get_now_time_str(n_time=n_time, tz=tz)
        etype = int(event_type)
        if lang == 'cn':
            if etype == 704:
                msg_type = '电量过低'
            elif etype == 702:
                msg_type = '摄像头休眠'
            elif etype == 703:
                msg_type = '摄像头唤醒'
            else:
                msg_type = ''
            if is_sys:
                send_text = '{msg_type} 通道:{channel}'.format(msg_type=msg_type, channel=channel)
            else:
                send_text = '{msg_type} 通道:{channel} 日期:{date}'.format(msg_type=msg_type, channel=channel, date=n_date)
                # send_text = '{msg_type} 通道:{channel} 日期:{date}'.format(msg_type=msg_type, channel=channel, date=n_date)
        else:
            if etype == 704:
                msg_type = 'Low battery'
            elif etype == 702:
                msg_type = 'Camera sleep'
            elif etype == 703:
                msg_type = 'Camera wake'
            else:
                msg_type = ''
            if is_sys:
                send_text = '{msg_type} channel:{channel}'. \
                    format(msg_type=msg_type, channel=channel)
            else:
                send_text = '{msg_type} channel:{channel} date:{date}'. \
                    format(msg_type=msg_type, channel=channel, date=n_date)
        return send_text

    def do_jpush(self, uid, channel, appBundleId, token_val, event_type, n_time,
                 msg_title, msg_text):
        app_key = JPUSH_CONFIG[appBundleId]['Key']
        master_secret = JPUSH_CONFIG[appBundleId]['Secret']
        # 此处换成各自的app_key和master_secre
        _jpush = jpush.JPush(app_key, master_secret)
        push = _jpush.create_push()
        # if you set the logging level to "DEBUG",it will show the debug logging.
        # _jpush.set_logging("DEBUG")
        # push.audience = jpush.all_
        push.audience = jpush.registration_id(token_val)
        push_data = {"alert": "Motion ", "event_time": n_time, "event_type": event_type, "msg": "",
                     "received_at": n_time, "sound": "sound.aif", "uid": uid, "zpush": "1", "channel": channel}
        android = jpush.android(alert=msg_text, priority=1, style=1, alert_type=7,
                                big_text=msg_text, title=msg_title,
                                extras=push_data)
        push.notification = jpush.notification(android=android)
        push.platform = jpush.all_
        try:
            res = push.send()
            print(res)
        except Exception as e:
            print("jpush fail")
            print("Exception")
            print(repr(e))
            return
        else:
            print("jpush success")
            return

    def do_fcm(self, uid, channel, appBundleId, token_val, event_type, n_time, msg_title, msg_text):
        try:
            serverKey = FCM_CONFIG[appBundleId]
        except Exception as e:
            return
        push_service = FCMNotification(api_key=serverKey)
        data = {"alert": "Motion ", "event_time": n_time, "event_type": event_type, "msg": "",
                "received_at": n_time, "sound": "sound.aif", "uid": uid, "zpush": "1", "channel": channel}
        result = push_service.notify_single_device(registration_id=token_val, message_title=msg_title,
                                                   message_body=msg_text, data_message=data,
                                                   extra_kwargs={
                                                       'default_vibrate_timings': True,
                                                       'default_sound': True,
                                                       'default_light_settings': True
                                                   })
        print('fcm push ing')
        print(result)
        return

    def do_apns(self, uid, channel, appBundleId, token_val, event_type, n_time, msg_title,
                msg_text):
        try:
            cli = apns2.APNSClient(mode=APNS_MODE,
                                   client_cert=os.path.join(BASE_DIR, APNS_CONFIG[appBundleId]['pem_path']))
            push_data = {"alert": "Motion ", "event_time": n_time, "event_type": event_type, "msg": "",
                         "received_at": n_time, "sound": "sound.aif", "uid": uid, "zpush": "1", "channel": channel}
            alert = apns2.PayloadAlert(body=msg_text, title=msg_title)
            payload = apns2.Payload(alert=alert, custom=push_data)
            n = apns2.Notification(payload=payload, priority=apns2.PRIORITY_LOW)
            res = cli.push(n=n, device_token=token_val, topic=appBundleId)
            print(res.status_code)
            if res.status_code == 200:
                print('apns push success')
                return
            else:
                print('apns push fail')
                print(res.reason)
                return
        except Exception as e:
            print(repr(e))
            return


# http://test.dvema.com/detect/add?uidToken=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1aWQiOiJQMldOR0pSRDJFSEE1RVU5MTExQSJ9.xOCI5lerk8JOs5OcAzunrKCfCrtuPIZ3AnkMmnd-bPY&n_time=1526845794&channel=1&event_type=51&is_st=0
# 移动侦测接口
class PushNotificationView(View):

    def get(self, request, *args, **kwargs):
        request.encoding = 'utf-8'
        # operation = kwargs.get('operation')
        return self.validation(request.GET)

    def post(self, request, *args, **kwargs):
        request.encoding = 'utf-8'
        # operation = kwargs.get('operation')
        return self.validation(request.POST)

    def validation(self, request_dict):
        etk = request_dict.get('etk', None)
        channel = request_dict.get('channel', '1')
        n_time = request_dict.get('n_time', None)
        event_type = request_dict.get('event_type', None)
        is_st = request_dict.get('is_st', None)
        eto = ETkObject(etk)
        uid = eto.uid
        if len(uid) == 20:
            redisObj = RedisObject(db=6)
            # pkey = '{uid}_{channel}_ptl'.format(uid=uid, channel=channel)
            pkey = '{uid}_ptl'.format(uid=uid)
            ykey = '{uid}_redis_qs'.format(uid=uid)
            if redisObj.get_data(key=pkey):
                res_data = {'code': 0, 'msg': 'success,!'}
                return JsonResponse(status=200, data=res_data)
            else:
                redisObj.set_data(key=pkey, val=1, expire=60)
            ##############
            redis_data = redisObj.get_data(key=ykey)
            if redis_data:
                redis_list = eval(redis_data)
            else:
                # 设置推送时间为60秒一次
                redisObj.set_data(key=pkey, val=1, expire=60)
                print("从数据库查到数据")
                # 从数据库查询出来
                uid_push_qs = UidPushModel.objects.filter(uid_set__uid=uid, uid_set__detect_status=1). \
                    values('token_val', 'app_type', 'appBundleId',
                           'push_type', 'userID_id', 'lang',
                           'tz', 'uid_set__nickname')
                # 新建一个list接收数据
                redis_list = []
                # 把数据库数据追加进redis_list
                for qs in uid_push_qs:
                    redis_list.append(qs)
                # 修改redis数据，并设置过期时间为10分钟
            if redis_list:
                redisObj.set_data(key=ykey, val=str(redis_list), expire=600)
                auth = oss2.Auth(OSS_STS_ACCESS_KEY, OSS_STS_ACCESS_SECRET)
                bucket = oss2.Bucket(auth, 'oss-cn-shenzhen.aliyuncs.com', 'apg')
                self.do_bulk_create_info(redis_list, n_time, channel, event_type, is_st, uid)
                if is_st == '0' or is_st == '2':
                    return JsonResponse(status=200, data={'code': 0, 'msg': 'success'})
                elif is_st == '1':
                    # Endpoint以杭州为例，其它Region请按实际情况填写。
                    obj = '{uid}/{channel}/{filename}.jpeg'.format(uid=uid, channel=channel, filename=n_time)
                    # 设置此签名URL在60秒内有效。
                    url = bucket.sign_url('PUT', obj, 7200)
                    res_data = {'code': 0, 'img_push': url, 'msg': 'success'}
                    return JsonResponse(status=200, data=res_data)
                elif is_st == '3':
                    # 人形检测带动图
                    img_url_list = []
                    for i in range(int(is_st)):
                        obj = '{uid}/{channel}/{filename}_{st}.jpeg'. \
                            format(uid=uid, channel=channel, filename=n_time, st=i)
                        # 设置此签名URL在60秒内有效。
                        url = bucket.sign_url('PUT', obj, 7200)
                        img_url_list.append(url)
                    res_data = {'code': 0, 'img_url_list': img_url_list, 'msg': 'success'}
                    return JsonResponse(status=200, data=res_data)
            else:
                return JsonResponse(status=200, data={'code': 404, 'msg': 'data is not exist'})
        else:
            return JsonResponse(status=200, data={'code': 404, 'msg': 'wrong etk'})

    def do_bulk_create_info(self, uaqs, n_time, channel, event_type, is_st, uid):
        now_time = int(time.time())
        # 设备昵称
        userID_ids = []
        sys_msg_list = []
        is_sys_msg = self.is_sys_msg(int(event_type))
        is_st = int(is_st)
        eq_list = []
        nickname = uaqs[0]['uid_set__nickname']
        if not nickname:
            nickname = uid
        for ua in uaqs:
            lang = ua['lang']
            tz = ua['tz']
            userID_id = ua["userID_id"]
            if userID_id not in userID_ids:
                eq_list.append(Equipment_Info(
                    userID_id=userID_id,
                    eventTime=n_time,
                    eventType=event_type,
                    devUid=uid,
                    devNickName=nickname,
                    Channel=channel,
                    alarm='Motion \tChannel:{channel}'.format(channel=channel),
                    is_st=is_st,
                    receiveTime=n_time,
                    addTime=now_time
                ))
                if is_sys_msg:
                    sys_msg_text = self.get_msg_text(channel=channel, n_time=n_time, lang=lang, tz=tz,
                                                     event_type=event_type, is_sys=1)
                    sys_msg_list.append(SysMsgModel(
                        userID_id=userID_id,
                        msg=sys_msg_text,
                        addTime=now_time,
                        updTime=now_time,
                        uid=uid,
                        eventType=event_type))
        if eq_list:
            print('eq_list')
            Equipment_Info.objects.bulk_create(eq_list)
        if is_sys_msg:
            print('sys_msg')
            SysMsgModel.objects.bulk_create(sys_msg_list)
        return True

    def is_sys_msg(self, event_type):
        event_type_list = [702, 703, 704]
        if event_type in event_type_list:
            return True
        return False

    def get_msg_text(self, channel, n_time, lang, tz, event_type, is_sys=0):
        n_date = CommonService.get_now_time_str(n_time=n_time, tz=tz)
        etype = int(event_type)
        if lang == 'cn':
            if etype == 704:
                msg_type = '电量过低'
            elif etype == 702:
                msg_type = '摄像头休眠'
            elif etype == 703:
                msg_type = '摄像头唤醒'
            else:
                msg_type = ''
            if is_sys:
                send_text = '{msg_type} 通道:{channel}'.format(msg_type=msg_type, channel=channel)
            else:
                send_text = '{msg_type} 通道:{channel} 日期:{date}'.format(msg_type=msg_type, channel=channel, date=n_date)
        else:
            if etype == 704:
                msg_type = 'Low battery'
            elif etype == 702:
                msg_type = 'Camera sleep'
            elif etype == 703:
                msg_type = 'Camera wake'
            else:
                msg_type = ''
            if is_sys:
                send_text = '{msg_type} channel:{channel}'. \
                    format(msg_type=msg_type, channel=channel)
            else:
                send_text = '{msg_type} channel:{channel} date:{date}'. \
                    format(msg_type=msg_type, channel=channel, date=n_date)
        return send_text