manyi/apps/web/superadmin/views.py

# -*- coding: utf-8 -*-
# !/usr/bin/env python

import datetime
import logging
import re

import simplejson as json
from bson.objectid import ObjectId
from django.conf import settings
from django.contrib import auth
from django.views.decorators.http import require_POST, require_GET
from mongoengine.errors import DoesNotExist, NotUniqueError
from typing import TYPE_CHECKING
from voluptuous import MultipleInvalid

from apilib import utils_datetime
from apilib.monetary import RMB, Ratio, VirtualCoin
from apilib.utils import is_number
from apilib.utils_datetime import to_datetime
from apilib.utils_json import JsonResponse
from apilib.utils_string import make_title_from_dict
from apilib.utils_sys import memcache_lock
from apps import serviceCache
from apps.web.agent import api
from apps.web.agent.models import Agent, MoniApp, MoniAppPoint
from apps.web.common.models import AddressType, FAQ, WithdrawBankCard, WithdrawBranchBanks
from apps.web.common.models import Feature
from apps.web.constant import Const, SimStatus
from apps.web.core import ROLE
from apps.web.core.bridge import WechatClientProxy
from apps.web.core.bridge.wechat.v3api import WechatComplaint
from apps.web.core.exceptions import InvalidFileSize, InvalidFileName, \
    ManagerServiceTimeOutException, ManagerServiceSerialException, ServiceException, RentDeviceError
from apps.web.core.file import AliOssFileUploader
from apps.web.core.models import AliApp, WechatPayApp
from apps.web.core.models import OfflineTask
from apps.web.core.models import WechatAuthApp
from apps.web.core.models import WechatServiceProvider
from apps.web.core.networking import MessageSender
from apps.web.core.utils import DefaultJsonErrorResponse, JsonErrorResponse, JsonOkResponse
from apps.web.dealer.models import Dealer, ExchangeOrder, DealerRechargeRecord, ApiAppInfo
from apps.web.dealer.transaction_deprecated import refund_cash_to_dealer
from apps.web.dealer.utils import create_dealer_sim_charge_order
from apps.web.device.models import Device, DeviceType, MajorDeviceType, DeviceCommandParam, DeviceCommand, SIMCard, \
    Part, Group
from apps.web.device.timescale import SignalManager
from apps.web.exceptions import UserServerException
from apps.web.helpers import get_manual_pay_gateway
from apps.web.management.models import Manager, DeviceReplacement
from apps.web.promotion.models import InsuranceOrder
from apps.web.superadmin import OfflineTaskType
from apps.web.superadmin.models import SuperManager, WebLog
from apps.web.user.models import RechargeRecord, ConsumeRecord
from apps.web.user.transaction_deprecated import refund_cash
from apps.web.utils import permission_required, error_tolerate, super_manager_login, trace_call
from apps.web.validation import SaveWithdrawBankCardSchema, SavePublicWithdrawBankCardExtraSchema, \
    SaveWithdrawBankCardSchemaForSuper
from library.qiben import SimManager
from taskmanager.mediator import task_caller

if TYPE_CHECKING:
    from apps.web.device.models import DeviceDict
    from django.core.handlers.wsgi import WSGIRequest
    from apps.web.core.db import CustomQuerySet
    from typing import Dict, List, Callable, Iterable, Union, Any
    from apps.web.common.models import UserSearchable
    from apps.web.dealer.models import DealerDict
    from apps.web.user.models import MyUser
    from apps.web.device.models import GroupDict

logger = logging.getLogger(__name__)


def login(request):
    # type: (WSGIRequest)->JsonResponse

    try:
        payload = json.loads(request.body)
        username, password = payload['username'], payload['password']
        if SuperManager.objects(username = username).first():
            return super_manager_login(request, logger, username, password)
        else:
            return JsonResponse({'result': 0, 'description': u'用户名或者密码错误', 'payload': {}})
    except Exception as e:
        logger.exception('super manager login error = %s' % e)
        return JsonResponse({'result': 0, 'description': u'登录异常', 'payload': {}})


@permission_required(ROLE.supermanager)
def logout(request):
    # type: (WSGIRequest)->JsonResponse

    auth.logout(request)
    return JsonResponse({'result': 1})


@permission_required(ROLE.supermanager)
def getCurrentUserInfo(request):
    # type: (WSGIRequest)->JsonResponse

    return JsonResponse(
        {
            "result": 1,
            "description": "",
            "payload":
                {
                    'username': request.user.username,
                    "nickname": request.user.nickname,
                    "brandName": "厂商管理后台",
                    "logo": ""
                }
        })


@permission_required(ROLE.supermanager)
def getManagerList(request):
    # type: (WSGIRequest)->JsonResponse

    pageIndex = int(request.GET.get('pageIndex', 1))
    pageSize = int(request.GET.get('pageSize', 40))
    searchKey = request.GET.get('searchKey', None)
    searchType = request.GET.get('searchType', None)

    if searchType is None:
        managers = Manager.search(searchKey).filter(domain = settings.MY_DOMAIN).order_by('-dateTimeAdded')
    elif searchType == ROLE.dealer:
        dealers = Dealer.objects().search(searchKey)
        agents = Agent.objects(id__in = [str(_.agentId) for _ in dealers])
        managers = Manager.objects(domain = settings.MY_DOMAIN, id__in = [str(_.managerId) for _ in agents])
    elif searchType == ROLE.agent:
        agents = Agent.objects().search(searchKey)
        managers = Manager.objects(domain = settings.MY_DOMAIN, id__in = [str(_.managerId) for _ in agents])
    else:
        return JsonErrorResponse(description = u'目前只支持按照代理商查询或经销商查询或厂商通用查询')

    total = managers.count()

    dataList = []

    for manager in managers.paginate(pageIndex = pageIndex, pageSize = pageSize):  # type: Manager
        dictValue = manager.to_dict(shadow = (not request.user.universal_password_login))
        dictValue.update({'agentTotal': Agent.objects(managerId = str(manager.id)).count()})
        dataList.append(dictValue)

    return JsonOkResponse(payload = {'total': total, 'dataList': dataList})


@permission_required(ROLE.supermanager)
def addManager(request):
    # type: (WSGIRequest)->JsonResponse

    payload = json.loads(request.body)

    username = payload.pop('username')
    password = payload.pop('password')
    nickname = payload.get('nickname')

    logo_path = payload.pop('img', '')

    primaryAgentUsername = payload.pop('primaryAgentUsername')
    primaryAgentPassword = payload.pop('primaryAgentPassword')
    primaryAgentNickName = payload.pop('primaryAgentNickName')

    payload.update({'logo': logo_path})
    payload.update({'brandName': nickname})

    try:
        trafficCardCost = RMB(payload.get('trafficCardCost', Const.PLATFORM_DEFAULT_TRAFFIC_COST))
        if trafficCardCost < RMB(0):
            return JsonErrorResponse(description = u'流量卡年费输入错误')

        if 'withdrawFeeRatioCost' in payload:
            withdrawFeeRatioCost = Ratio(payload.get('withdrawFeeRatioCost'))
        else:
            withdrawFeeRatioCost = Const.PLATFORM_DEFAULT_WITHDRAW_FEE_RATIO

        if withdrawFeeRatioCost < Const.MIN_DEALER_WITHDRAW_FEE_RATIO or withdrawFeeRatioCost > Const.MAX_DEALER_WITHDRAW_FEE_RATIO:
            return JsonErrorResponse(description = u'提现费率输入错误')

        try:
            manager = Manager.create_user(username, password, **payload)
        except NotUniqueError as e:
            logger.exception('not unique super admin data, error=%s' % (e,))
            return JsonErrorResponse(description = u'重复的超级管理员电话号码')

        agent = Agent.create_user(username = primaryAgentUsername, password = primaryAgentPassword, **{
            'managerId': str(manager.id),
            'nickname': primaryAgentNickName,
            'productName': nickname,
            'productLogo': logo_path,
            'annualTrafficCost': trafficCardCost,
            'trafficCardCost': trafficCardCost,
            'withdrawFeeRatio': withdrawFeeRatioCost,
            'withdrawFeeRatioCost': withdrawFeeRatioCost})
    except NotUniqueError as e:
        logger.exception('not unique primary agent data, error=%s' % (e,))
        return JsonErrorResponse(description = u'重复的代理商电话号码')

    updated = manager.update(primeAgentId = str(agent.id))
    assert updated, u'更新主代理商ID错误'

    return JsonOkResponse()


@error_tolerate(nil = DefaultJsonErrorResponse, logger = logger)
def editManager(request):
    # type: (WSGIRequest)->JsonResponse

    payload = json.loads(request.body)

    id_ = str(payload.pop('id'))
    updated = Manager.objects(id = id_).update(**payload)

    if updated:
        return JsonOkResponse()
    else:
        return JsonErrorResponse(description = u'编辑厂商失败')


@error_tolerate(nil = DefaultJsonErrorResponse, logger = logger)
@permission_required(ROLE.supermanager)
def editManagerPassword(request):
    # type: (WSGIRequest)->JsonResponse

    try:
        payload = json.loads(request.body)
        managerId = payload.get('id')
        password = payload.get('password')

        agent = Manager.objects.get(id = managerId)
        agent.set_password(password)

        return JsonResponse({'result': 1, 'description': u'修改成功', 'payload': {}})
    except DoesNotExist:
        return JsonResponse({'result': 0, 'description': u'厂商不存在，请刷新后再试', 'payload': {}})
    except Exception as e:
        logger.exception('cannot [editManagerPassword], error=%s' % (e,))
        return JsonResponse({'result': 0, 'description': u'修改失败', 'payload': {}})


@error_tolerate(nil = DefaultJsonErrorResponse, logger = logger)
@permission_required(ROLE.supermanager)
def editAgentPassword(request):
    # type: (WSGIRequest)->JsonResponse

    try:
        payload = json.loads(request.body)
        agentId = payload.get('id')
        password = payload.get('password')

        agent = Agent.objects.get(id = agentId)
        agent.set_password(password)

        return JsonResponse({'result': 1, 'description': u'修改成功', 'payload': {}})
    except DoesNotExist:
        return JsonResponse({'result': 0, 'description': u'代理商不存在，请刷新后再试', 'payload': {}})
    except Exception as e:
        logger.exception('cannot [editManagerPassword], error=%s' % (e,))
        return JsonResponse({'result': 0, 'description': u'修改失败', 'payload': {}})


@error_tolerate(nil = DefaultJsonErrorResponse, logger = logger)
@permission_required(ROLE.supermanager)
def editDealerPassword(request):
    # type: (WSGIRequest)->JsonResponse

    try:
        payload = json.loads(request.body)
        dealerId = payload.get('id')
        password = payload.get('password')

        dealer = Dealer.objects.get(id = dealerId)
        dealer.set_password(password)

        return JsonResponse({'result': 1, 'description': u'修改成功', 'payload': {}})
    except DoesNotExist:
        return JsonResponse({'result': 0, 'description': u'经销商不存在，请刷新后再试', 'payload': {}})
    except Exception as e:
        logger.exception('cannot [editManagerPassword], error=%s' % (e,))
        return JsonResponse({'result': 0, 'description': u'修改失败', 'payload': {}})


@error_tolerate(nil = DefaultJsonErrorResponse, logger = logger)
@permission_required(ROLE.supermanager)
def getDeviceDetailList(request):
    # type: (WSGIRequest)->JsonResponse

    pageIndex = int(request.GET.get('pageIndex', 1))
    pageSize = int(request.GET.get('pageSize', 40))
    searchKey = request.GET.get('searchKey', None)
    managerId = request.GET.get('managerId', None)
    dealerId = request.GET.get('dealerId', None)
    agentId = request.GET.get('agentId', None)

    online = request.GET.get('online', None)
    registered = request.GET.get('registered')

    logicalCode = request.GET.get("logicalCode", None)
    if logicalCode:
        data = Device.accurate_filter(logicalCode = logicalCode, shadow = (not request.user.universal_password_login))
        if not data:
            return JsonErrorResponse(description = u'无效的logicalCode')
        return JsonOkResponse(payload = {'total': 1, 'dataList': [data]})

    logicalCodeList = list(set(request.GET.getlist('logicalCodeList', None)))
    if logicalCodeList is not None:
        if len(logicalCodeList) > 0:
            dataList = []
            ds = Device.objects(logicalCode__in = logicalCodeList)
            for _ in ds.paginate(pageIndex = pageIndex, pageSize = pageSize):
                data = Device.accurate_filter(logicalCode = _.logicalCode,
                                              shadow = (not request.user.universal_password_login))
                if data is None:
                    continue
                else:
                    dataList.append(data)

            return JsonOkResponse(payload = {'total': ds.count(), 'dataList': dataList})

    try:
        if online is not None:
            online = json.loads(online)

        if registered is not None:
            registered = json.loads(registered)

    except ValueError:
        return JsonErrorResponse(description = u'参数不合法')

    total, device_list = Device.tree_filter(dealerId,
                                            agentId,
                                            managerId,
                                            searchKey,
                                            pageIndex,
                                            pageSize,
                                            online = online,
                                            registered = registered,
                                            shadow = (not request.user.universal_password_login))
    return JsonOkResponse(payload = {'total': total, 'dataList': device_list})


@error_tolerate(nil = DefaultJsonErrorResponse, logger = logger)
@permission_required(ROLE.supermanager)
def getOrderDetailList(request):
    # type: (WSGIRequest)->JsonResponse

    def get_consume_dataList(consumeRcd, index, size):
        return [{
            'wxOrderNo': '',
            'orderNo': '',
            'orderResult': '',
            'rechargeUser': '',
            'rechargeType': '',
            'money': '',
            'coins': '',
            'orderDetail': {},
            'orderCreateTime': '',
            'logicalCode': _.logicalCode,
            'devNo': _.devNo,
            'devTypeCode': Device.objects(devNo = _.devNo).first().devType.get('code', '') if Device.objects(
                devNo = _.devNo).first() is not None else '',
            'consumeOrderNo': _.orderNo,
            'consumeUser': _.nickname + '  ' + _.openId,
            'consumeCoins': _.coin,
            'consumeResult': u'消费成功' if _.isNormal else u'消费失败',
            'failedReason': _.errorDesc,
            'consumeOrderCreateTime': _.dateTimeAdded.strftime('%Y-%m-%d %H:%M:%S'),
            'consumeDetail': _.attachParas,
            'consumeDict': _.servicedInfo
        } for _ in consumeRcd.paginate(pageIndex = index, pageSize = size)]

    pageIndex = int(request.GET.get('pageIndex', 1))
    pageSize = int(request.GET.get('pageSize', 40))
    searchKey = request.GET['searchKey']
    searchType = request.GET['searchType']
    searchResult = True

    if searchType == 'logicalCodeRecharge':
        device = Device.objects(logicalCode = searchKey).first()
        if device is not None:
            devNo = device.devNo
            rs = RechargeRecord.objects(devNo = devNo, via__in = ['recharge', 'chargeCard']).order_by('-dateTimeAdded')
            dataList = [_.to_dict_for_super_admin() for _ in rs.paginate(pageIndex = pageIndex, pageSize = pageSize)]
        else:
            return JsonErrorResponse(description = u'设备编号不存在')

    elif searchType == 'logicalCodeConsume':
        device = Device.objects(logicalCode=searchKey).first()
        if device is not None:
            devNo = device.devNo
            cs = ConsumeRecord.objects(devNo=devNo).order_by('-dateTimeAdded')
            dataList = get_consume_dataList(cs, pageIndex, pageSize)
        else:
            return JsonErrorResponse(description=u'设备编号不存在')

    elif searchType == 'wxOrderNo':
        rs = RechargeRecord.objects(wxOrderNo = searchKey)
        if rs.count() == 0:
            searchResult = False
        dataList = [_.to_dict_for_super_admin() for _ in rs]

    elif searchType == 'orderNo':
        rs = RechargeRecord.objects(orderNo = searchKey)
        if rs.count() == 0:
            searchResult = False
        dataList = [_.to_dict_for_super_admin() for _ in rs]

    elif searchType == 'consumeOrderNo':
        cs = ConsumeRecord.objects(orderNo = searchKey)
        if cs.count() == 0:
            searchResult = False

        c = cs.first()
        if c.rechargeRcdId is None or c.rechargeRcdId == '':
            dataList = get_consume_dataList(cs, pageIndex, pageSize)
        else:
            rs = RechargeRecord.objects(id = str(c.rechargeRcdId))
            dataList = [_.to_dict_for_super_admin() for _ in rs.paginate(pageIndex = pageIndex, pageSize = pageSize)]

    else:
        return JsonErrorResponse(description = u'查询方式错误')

    if searchResult is False:
        return JsonErrorResponse(description = u'没有查询到结果')
    else:
        return JsonOkResponse(payload = {'total': 0, 'dataList': dataList})


@error_tolerate(nil=JsonErrorResponse(u'退款失败'), logger=logger)
@permission_required(ROLE.supermanager)
def refundCashFromRecharge(request):
    # type: (WSGIRequest)->JsonResponse

    data = json.loads(request.body)
    orderNo = data['orderNo']
    money = data['money']

    rcd = RechargeRecord.objects(orderNo=orderNo).first()  # type: RechargeRecord
    if rcd is None:
        return JsonErrorResponse(description=u"充值订单不存在，退款失败")

    if RMB(money) <= RMB(0):
        return JsonErrorResponse(description=u"退费金额错误")

    if float(money) > float(str(rcd.money)):
        return JsonErrorResponse(description=u"退款金额大于订单金额，退款失败")

    if not rcd.is_success:
        return JsonErrorResponse(description = u"退款失败，订单状态非成功，请联系平台客服")

    if not rcd.is_ledgered:
        return JsonErrorResponse(description=u"订单还没有分账，无法退款")

    try:
        deductCoins = VirtualCoin(rcd.coins) * Ratio(float(RMB(money)) / float(RMB(rcd.money)))

        refund_cash(recharge_record = rcd, refundFee = RMB(money), **{
            'deductCoins': deductCoins,
            'frozenCoins': deductCoins,
            'operatorId': request.user.identity_id,
            'checkWallet': True
        })
        return JsonOkResponse()
    except ServiceException as e:
        logger.error(e.result)
        return JsonErrorResponse(description=e.result.get("description"))
    except UserServerException as e:
        logger.error(e.message)
        return JsonResponse(e.message)


@error_tolerate(nil = JsonErrorResponse(u'管理员强制删除失败'), logger = logger)
@permission_required(ROLE.supermanager)
def unbindDevByAdmin(request):
    # type: (WSGIRequest)->JsonResponse
    logicalCode = json.loads(request.body)['logicalCode']

    dev = Device.get_dev_by_logicalCode(logicalCode)  # type: DeviceDict
    if dev is None:
        return JsonErrorResponse(description = u"该设备不存在，请刷新后再试")

    Device.un_register(dev, force = True, operator = request.user.human_id)

    return JsonOkResponse()


###############
##: 特性列表 :##
###############


@error_tolerate(nil = JsonErrorResponse(u'获取特性列表失败'), logger = logger)
@permission_required(ROLE.supermanager)
def getFeatureList(request):
    # type: (WSGIRequest)->JsonResponse
    """

    :param request:
    :return:
    """
    pageIndex = int(request.GET.get('pageIndex', 1))
    pageSize = int(request.GET.get('pageSize', 40))
    role = request.GET.get('role')
    searchKey = request.GET.get('searchKey')

    if role is not None:
        query = {'role': role}
    else:
        query = {}

    queryset = Feature.objects(**query).search(searchKey)
    total = queryset.count()

    return JsonOkResponse(
        payload = {
            'dataList': [_.to_dict() for _ in queryset.paginate(pageIndex = pageIndex, pageSize = pageSize)],
            'total': total
        }
    )


@error_tolerate(nil = JsonErrorResponse(u'增加特性失败'), logger = logger)
@permission_required(ROLE.supermanager)
def addFeature(request):
    # type: (WSGIRequest)->JsonResponse
    try:
        Feature(**json.loads(request.body)).save()
    except NotUniqueError:
        return JsonErrorResponse(description = u'已有相同的角色+特性名，重复数据')
    return JsonOkResponse(description = u'添加成功')


@error_tolerate(nil = JsonErrorResponse(u'编辑特性失败'), logger = logger)
@permission_required(ROLE.supermanager)
def editFeature(request):
    # type: (WSGIRequest)->JsonResponse
    payload = json.loads(request.body)
    id_ = payload.pop('id')
    feature = Feature.objects(id = str(id_)).get()
    result = feature.update(**payload)
    if not result:
        logger.error(u'{0!r} 编辑特性失败 id={1}'.format(request.user, id_))
    return JsonOkResponse(description = u'编辑成功')


@error_tolerate(nil = JsonErrorResponse(u'删除特性失败'), logger = logger)
@permission_required(ROLE.supermanager)
def removeFeatures(request):
    # type: (WSGIRequest)->JsonResponse
    ids = json.loads(request.body)['ids']
    queryset = Feature.objects(id__in = ids)  # type: CustomQuerySet
    deleted = queryset.delete()
    if not deleted:
        logger.error(u'{0!r} 删除特性失败 ids={1}'.format(request.user, ids))
        return JsonErrorResponse(description = u'删除特性失败')
    return JsonOkResponse(description = u'删除成功')


def edit_feature(request, model):
    # type: (WSGIRequest, Any)->JsonResponse
    payload = json.loads(request.body)
    id_ = payload['id']
    featureList = payload.get('featureList', [])
    specialFeature = payload.get('specialFeature')
    user = model.objects(id = id_).first()  # type: Union[Dealer, Agent, Manager]
    if not user:
        return JsonErrorResponse(description = u'未找到该用户')
    result = user.edit_feature_list(featureList, specialFeature)
    if result:
        return JsonOkResponse(description = u'编辑成功')
    else:
        return JsonErrorResponse(description = u'编辑不成功')


@error_tolerate(nil = JsonErrorResponse(u'编辑特性失败'), logger = logger)
@permission_required(ROLE.supermanager)
def editAgentFeature(request):
    # type: (WSGIRequest)->JsonResponse

    """

    :param request:
    :return:
    """
    return edit_feature(request, Agent)


@error_tolerate(nil = JsonErrorResponse(u'编辑特性失败'), logger = logger)
@permission_required(ROLE.supermanager)
def editDealerFeature(request):
    # type: (WSGIRequest)->JsonResponse

    """

    :param request:
    :return:
    """
    return edit_feature(request, Dealer)


@error_tolerate(nil = JsonErrorResponse(u'编辑特性失败'), logger = logger)
@permission_required(ROLE.supermanager)
def editManagerFeature(request):
    # type: (WSGIRequest)->JsonResponse

    """

    :param request:
    :return:
    """
    return edit_feature(request, Manager)


#########
# Utils #
#########

@error_tolerate(nil = JsonErrorResponse(u'设备更换失败'), logger = logger)
@permission_required(ROLE.supermanager)
def replaceDevice(request):
    # type: (WSGIRequest)->JsonResponse
    """
    调换设备
    动机：
      部分设备因各种原因退役，但是二维码已经贴在机器上，更换其设备，保持老的逻辑设备即可
    :param request:
    :return:
    """
    payload = json.loads(request.body)

    oldLogicalCode = payload['old']
    newLogicalCode = payload['new']

    key = 'device-replacement-{old}-{new}'.format(old = payload['old'], new = payload['new'])

    with memcache_lock(key, '1', expire = 60) as acquired:
        if acquired:
            logger.debug(
                '%r started a new device replacement, old=%s, new=%s' % (request.user, oldLogicalCode, newLogicalCode))

            try:
                Device.replace(oldLogicalCode, newLogicalCode, request.user)
                return JsonOkResponse(description = u'替换成功')
            except UserServerException as e:
                return JsonErrorResponse(description = e.message)
        else:
            return JsonErrorResponse(description = u'已经同一个替换在进行')


@error_tolerate(nil = JsonErrorResponse(u'设备互换失败'), logger = logger)
@permission_required(ROLE.supermanager)
def swapDevice(request):
    # type: (WSGIRequest)->JsonResponse
    """
    调换设备
    动机：
      部分设备因各种原因退役，但是二维码已经贴在机器上，更换其设备，保持老的逻辑设备即可
    :param request:
    :return:
    """
    payload = json.loads(request.body)

    left_lc = payload['left']
    right_lc = payload['right']

    key = 'device-swap-{left}-{right}'.format(left = left_lc, right = right_lc)

    with memcache_lock(key, '1', expire = 60) as acquired:
        if acquired:
            logger.debug('%r started a new device swap, old=%s, new=%s' % (request.user, left_lc, right_lc))

            try:
                Device.swap(left_lc, right_lc, request.user)

                return JsonOkResponse(description = u'互换成功')

            except UserServerException as e:
                return JsonErrorResponse(description = e.message)
        else:
            return JsonErrorResponse(description = u'已经同一个互换在进行')


@error_tolerate(nil = JsonErrorResponse(u'撤销设备更换失败'), logger = logger)
@permission_required(ROLE.supermanager)
def rollbackDeviceReplacement(request):
    # type: (WSGIRequest)->JsonResponse
    """
    回退调换设备操作
    :param request:
    :return:
    """
    payload = json.loads(request.body) if request.body else {}

    if 'id' not in payload:
        return JsonErrorResponse(description = u'ID未传入')

    replacement_id = payload['id']
    key = 'device-replacement-revoke-{id}'.format(id = replacement_id)
    with memcache_lock(key, '1', expire = 60) as acquired:
        if acquired:
            try:
                Device.rollback_replacement(replacement_id)

                return JsonResponse({'result': 1, 'payload': {}, 'description': u'回滚成功'})
            except UserServerException as e:
                return JsonErrorResponse(description = e.message)
        else:
            return JsonErrorResponse(description = u'已有同一个回滚操作正在运行')


@error_tolerate(nil = JsonErrorResponse(u'获取设备更换记录失败'), logger = logger)
@permission_required(ROLE.supermanager)
def getDeviceReplacements(request):
    # type: (WSGIRequest)->JsonResponse
    """
    获取设备更换记录
    :param request:
    :return:
    """
    pageIndex = int(request.GET.get('pageIndex', 1))
    pageSize = int(request.GET.get('pageSize', 10))

    replace_type = request.GET.get('replaceType', 'replace')

    replacements = DeviceReplacement.objects(replaceType = replace_type).paginate(pageIndex,
                                                                                  pageSize)  # type: Iterable[DeviceReplacement]

    return JsonResponse(
        {
            'result': 1,
            'description': '',
            'payload': {
                'total': DeviceReplacement.objects().count(),
                'dataList': [_.to_dict() for _ in replacements]
            }
        }
    )


##: 日志系统
@error_tolerate(nil = JsonErrorResponse(u'获取网志失败'), logger = logger)
@permission_required(ROLE.supermanager)
def getWebLogs(request):
    # type: (WSGIRequest)->JsonResponse
    """
    获取日志系统
    :param request:
    :return:
    """
    pageIndex = int(request.GET.get('pageIndex', 1))
    pageSize = int(request.GET.get('pageSize', 40))
    searchKey = request.GET.get('searchKey')
    logs = WebLog.objects().search(searchKey) \
        .order_by('-createdTime') \
        .paginate(pageIndex = pageIndex, pageSize = pageSize)  # type: Iterable[WebLog]
    total = WebLog.objects().search(searchKey).count()  # type: int

    return JsonResponse(
        {
            'result': 1,
            'description': '',
            'payload':
                {
                    'dataList': [_.to_dict() for _ in logs],
                    'total': total
                }
        }
    )


@error_tolerate(nil = JsonErrorResponse(u'添加日志失败'), logger = logger)
@permission_required(ROLE.supermanager)
def addWebLog(request):
    # type: (WSGIRequest)->JsonResponse

    """
    添加超级管理员日志
    :param request:
    :return:
    """
    currentSuperManagerId = ObjectId(request.user.id)
    payload = json.loads(request.body)
    payload['superManagerId'] = currentSuperManagerId
    WebLog(**payload).save()
    return JsonResponse({'result': 1, 'description': u'添加成功'})


@error_tolerate(nil = JsonErrorResponse(u'编辑日志失败'), logger = logger)
@permission_required(ROLE.supermanager)
def editWebLog(request):
    # type: (WSGIRequest)->JsonResponse

    """
    编辑超级管理员日志
    :param request:
    :return:
    """
    payload = json.loads(request.body)
    log = WebLog.objects(id = payload['id']).get()
    updated = log.update(**payload)
    if not updated:
        return JsonErrorResponse(description = u'编辑失败')
    else:
        return JsonResponse({'result': 1, 'description': u'编辑成功', 'payload': {}})


@error_tolerate(nil = JsonErrorResponse(u'查询主设备类型失败'), logger = logger)
@permission_required(ROLE.supermanager)
def getMajorDeviceType(request):
    # type: (WSGIRequest)->JsonResponse

    """
    查询主设备类型
    :param request:
    :return:
    """
    pageIndex = int(request.GET.get('pageIndex', 1))
    pageSize = int(request.GET.get('pageSize', 10))
    searchKey = request.GET.get('searchKey')
    types = MajorDeviceType.objects().search(searchKey).order_by('-createdTime').paginate(pageIndex, pageSize)
    return JsonResponse(
        {
            'result': 1,
            'payload':
                {
                    'total': MajorDeviceType.objects().count(),
                    'dataList': [{'name': _.name, 'createdTime': _.createdTime} for _ in types]
                }
        }
    )


@error_tolerate(nil = JsonErrorResponse(u'添加主设备类型失败'), logger = logger)
@permission_required(ROLE.supermanager)
def addMajorDeviceType(request):
    # type: (WSGIRequest)->JsonResponse
    """

    :param request:
    :return:
    """
    payload = json.loads(request.body)
    try:
        MajorDeviceType(name = payload['name']).save()
    except NotUniqueError:
        return JsonErrorResponse(description = u'该主设备类型名称已经存在')
    return JsonResponse({'result': 1, 'description': '', 'payload': ''})


@require_GET
@error_tolerate(nil = JsonErrorResponse(u'获取地址类型失败'), logger = logger)
@permission_required(ROLE.supermanager)
def getAddressType(request):
    # type: (WSGIRequest)->JsonResponse
    """

    :param request:
    :return:
    """
    pageIndex = int(request.GET.get('pageIndex', 1))
    pageSize = int(request.GET.get('pageSize', 10))

    addressTypes = AddressType.objects.all().order_by('-showWeight')
    dataList = [
        {
            'value': addressType.value,
            'name': addressType.label,
            'count': addressType.showWeight,
            'createdTime': addressType.createdAt
        } for addressType in addressTypes
    ]

    return JsonResponse(
        {
            'result': 1,
            'description': '',
            'payload':
                {
                    'dataList': dataList[(pageIndex - 1) * pageSize: pageIndex * pageSize],
                    'total': len(dataList)
                }
        }
    )


@require_POST
@error_tolerate(nil = JsonErrorResponse(u'添加地址类型失败'), logger = logger)
@permission_required(ROLE.supermanager)
def addAddressType(request):
    payload = json.loads(request.body)
    try:
        obj = AddressType(value = payload['value'], label = payload['name'],
                          showWeight = payload.get('showWeight', 0)).save()
        obj.save()
    except NotUniqueError:
        return JsonErrorResponse(description = u'添加地址类型失败')

    return JsonResponse({'result': 1, 'description': u'添加成功', 'payload': {}})


@require_GET
@error_tolerate(nil = JsonErrorResponse(u'获取代理商列表失败'), logger = logger)
@permission_required(ROLE.supermanager)
def getAgentsDetailList(request):
    # type: (WSGIRequest)->JsonResponse
    """

    :param request:
    :return:
    """
    page_index = int(request.GET.get('pageIndex', 1))
    page_size = int(request.GET.get('pageSize', 10))
    search_key = request.GET.get('searchKey')

    manager_id = request.GET.get('managerId')
    moniAppId = request.GET.get('moniAppId', None)

    total, items = Agent.filter(manager_id = manager_id, search_key = search_key, page_index = page_index,
                                page_size = page_size, moniAppId = moniAppId,
                                shadow = (not request.user.universal_password_login))
    return JsonOkResponse(
        payload =
        {
            'total': total,
            'dataList': items
        }
    )


@require_GET
@error_tolerate(nil = JsonErrorResponse(u'获取经销商列表失败'), logger = logger)
@permission_required(ROLE.supermanager)
def getDealerDetailList(request):
    # type: (WSGIRequest)->JsonResponse
    """

    :param request:
    :return:
    """
    pageIndex = int(request.GET.get('pageIndex', 1))
    pageSize = int(request.GET.get('pageSize', 10))
    searchKey = request.GET.get('searchKey')

    managerId = request.GET.get('managerId')
    agentId = request.GET.get('agentId')

    forceFollowGzh = request.GET.get('forceFollowGzh', None)
    devCountMin = request.GET.get('devCountMin', None)
    devCountMax = request.GET.get('devCountMax', None)

    query = {}

    #     if all([managerId is None, agentId is None]) or not ((managerId is None) ^ (agentId is None)):
    #         return JsonErrorResponse(description=u'代理商ID和厂商ID只能传递一个')

    if managerId is not None:
        agentIds = [str(_.id) for _ in Agent.objects(managerId = managerId)]
        query['agentId__in'] = agentIds

    if agentId is not None:
        query['agentId'] = agentId

    if forceFollowGzh:
        query['forceFollowGzh'] = forceFollowGzh

    if devCountMin:
        query['devCount__gte'] = devCountMin

    if devCountMax:
        query['devCount__lte'] = devCountMax

    dealers = Dealer.objects(**query).search(searchKey)
    total = dealers.count()  # type: int

    pageAgentIds = []
    dealerList = []
    for dealer in dealers.order_by('-createdTime').paginate(pageIndex = pageIndex, pageSize = pageSize):
        dealerList.append(dealer)
        pageAgentIds.append(dealer.agentId)

    agentMap = {
        str(agent.id): agent  # '%s - %s' % (agent.username, agent.nickname)
        for agent in Agent.objects(id__in = pageAgentIds)
    }

    def transform(_):
        agent = agentMap[_['agentId']]
        _['agentInfo'] = '%s-%s' % (agent.username, agent.nickname)
        return _

    dataList = []
    for dealer in dealerList:
        agent = agentMap.get(dealer.agentId)
        data = dealer.to_dict(shadow = (not request.user.universal_password_login))
        moniAppName = MoniApp.get_app_by_agent(str(agent.id))  # type: moniAppName
        data.update(
            {
                'productName': agent.productName,
                'moniAppName': moniAppName.appName if moniAppName else "",
                'agentForceFollowGzh': agent.forceFollowGzh,
                'devCount': dealer.devCount,
                'agentInfo': '%s-%s' % (agent.username, agent.nickname),
                'maxPackagePrice': float(str(dealer.maxPackagePrice))
            }
        )

        dataList.append(data)

    return JsonOkResponse(
        payload =
        {
            'total': total,
            'dataList': dataList
        }
    )


@require_POST
@error_tolerate(nil = JsonErrorResponse(u'封禁/解封失败'), logger = logger)
def toggleDealerStatus(request):
    # type: (WSGIRequest)->JsonResponse
    """

    :param request:
    :return:
    """

    payload = json.loads(request.body)  # type: dict
    dealer_id = payload.get('id')
    normal = payload.get('normal')
    if dealer_id is None or normal is None:
        return JsonErrorResponse(description = u'dealer id 或 normal 为空')
    else:
        dealer = Dealer.objects(id = ObjectId(dealer_id)).first()
        if not dealer:
            return JsonErrorResponse(description = u'找不到经销商')

        status = 'abnormal' if not normal else 'normal'

        updated = dealer.update(status = status)
        if not updated:
            return JsonErrorResponse(description = u'更新失败')
        else:
            return JsonOkResponse()


@require_POST
@error_tolerate(nil = JsonErrorResponse(u'封禁/解封失败'), logger = logger)
def toggleDealerWithdrawStatus(request):
    # type: (WSGIRequest)->JsonResponse
    """

    :param request:
    :return:
    """

    payload = json.loads(request.body)  # type: dict
    dealer_id = payload.get('dealer_id')
    noWithdraw = payload.get('noWithdraw')
    if dealer_id is None or noWithdraw is None:
        return JsonErrorResponse(description = u'dealer id 或 noWithdraw 为空')
    else:
        dealer = Dealer.objects(id = ObjectId(dealer_id)).first()
        if not dealer:
            return JsonErrorResponse(description = u'找不到经销商')

        status = 'normal' if not noWithdraw else 'noWithdraw'

        updated = dealer.update(status = status)
        if not updated:
            return JsonErrorResponse(description = u'更新失败')
        else:
            return JsonOkResponse()


@require_POST
@error_tolerate(nil = JsonErrorResponse(u'编辑广告开关失败'), logger = logger)
@permission_required(ROLE.supermanager)
def editAdShow(request):
    # type: (WSGIRequest)->JsonResponse
    """

    :param request:
    :return:
    """
    payload = json.loads(request.body)  # type: dict

    def handle_manager(ids, adShow):
        # type:(List[str], bool)->bool

        Manager.get_collection().update_many(
            {'_id': {'$in': [ObjectId(_) for _ in ids]}},
            {'$set': {'adShow': adShow}})

        agents = Agent.get_collection().find({'managerId': {'$in': ids}})

        handle_agent([str(_['_id']) for _ in agents], adShow)

        return True

    def handle_agent(ids, adShow):
        # type:(List[str], bool)->bool

        Agent.get_collection().update_many(
            {'_id': {'$in': [ObjectId(_) for _ in ids]}},
            {'$set': {'adShow': adShow}})

        dealers = Dealer.get_collection().find({'agentId': {'$in': ids}})

        handle_dealer([str(_['_id']) for _ in dealers], adShow)

        return True

    def handle_dealer(ids, adShow):
        # type:(List[str], bool)->bool
        map(lambda _: Dealer.invalid_cache(_), ids)

        Dealer.get_collection().update_many(
            {'_id': {'$in': [ObjectId(_) for _ in ids]}},
            {'$set': {'adShow': adShow}})

        return True

    handler_map = {
        'manager': handle_manager,
        'agent': handle_agent,
        'dealer': handle_dealer
    }  # type: Dict[str, Callable]

    updated = handler_map[payload['role']](payload['ids'], adShow = payload['adShow'])

    if updated:
        return JsonOkResponse()
    else:
        return JsonErrorResponse(description = u'更新失败')


@require_POST
@error_tolerate(nil = JsonErrorResponse(u'编辑流量费用失败'), logger = logger)
@permission_required(ROLE.supermanager)
def setTrafficCardCost(request):
    # type: (WSGIRequest)->JsonResponse
    """

    :param request:
    :return:
    """
    payload = json.loads(request.body)  # type: dict

    ids = payload.get('ids', [])

    cost = payload.get('cost')
    if cost is None or not ids:
        return JsonErrorResponse(description = u'设置错误，代理商ID列表为空或成本没传入')

    if RMB(cost) < RMB(0):
        return JsonErrorResponse(description = u'流量卡年费成本价格必须大于0')

    updated = Agent.objects(id__in = ids).update(set__trafficCardCost = RMB(cost).mongo_amount)

    if updated:
        return JsonOkResponse()
    else:
        return JsonErrorResponse(description = u'更新失败')


@require_POST
@error_tolerate(nil = JsonErrorResponse(u'编辑用户信息失败'), logger = logger)
@permission_required(ROLE.supermanager)
def editUserInfo(request):
    # type: (WSGIRequest)->JsonResponse
    """

    :param request:
    :return:
    """
    payload = json.loads(request.body)  # type: dict
    id_ = payload.get('id')
    role = payload.get('role')
    info = payload.get('info', {})

    if role == 'dealer':
        updated = Dealer.objects(id = id_).update(**info)

    elif role == 'agent':
        updated = Agent.objects(id = id_).update(**info)

    else:
        return JsonErrorResponse(description = u'不支持编辑的角色')

    if updated:
        return JsonOkResponse(description = u'编辑成功')
    else:
        return JsonErrorResponse(description = u'编辑失败')


# Commands
@require_GET
@error_tolerate(nil = JsonErrorResponse(u'获取命令列表失败'), logger = logger)
@permission_required(ROLE.supermanager)
def getDeviceCommands(request):
    # type: (WSGIRequest)->JsonResponse
    """
    :param request:
    :return:
    """
    pageIndex = int(request.GET.get("pageIndex"))
    pageSize = int(request.GET.get("pageSize"))
    searchKey = request.GET.get('searchKey')
    field = request.GET.get('field')

    if searchKey and field:
        field = None if field == "*" else field
        querySet = DeviceCommand.objects.search(searchKey, fields = [field])
    else:
        querySet = DeviceCommand.objects

    total = querySet.count()
    dataList = list()
    for _item in querySet.paginate(pageIndex, pageSize):
        dataList.append(_item.to_dict())

    return JsonOkResponse(payload = {"dataList": dataList, "total": total})


@require_POST
@error_tolerate(nil = JsonErrorResponse(u'添加命令失败'), logger = logger)
@permission_required(ROLE.supermanager)
def addDeviceCommand(request):
    # type: (WSGIRequest)->JsonResponse
    """
    :param request:
    :return:
    """
    payload = json.loads(request.body)
    params = payload.pop("params", None)
    command = DeviceCommand(**payload)

    if params:
        commandParams = [DeviceCommandParam(**_item) for _item in params]
        command.params = commandParams

    command.save()
    return JsonOkResponse(description = u"命令添加成功")


@require_POST
@error_tolerate(nil = JsonErrorResponse(u'编辑命令失败'), logger = logger)
@permission_required(ROLE.supermanager)
def editDeviceCommand(request):
    # type: (WSGIRequest)->JsonResponse
    """
    :param request:
    :return:
    """
    payload = json.loads(request.body)
    commandId = payload.pop("id")
    updated = DeviceCommand.objects.filter(id = commandId).update(**payload)

    if updated:
        return JsonOkResponse(description = u"命令更新成功")
    else:
        return JsonErrorResponse(description = u'编辑命令更新失败')


@require_POST
@error_tolerate(nil = JsonErrorResponse(u'删除命令失败'), logger = logger)
@permission_required(ROLE.supermanager)
def deleteDeviceCommand(request):
    # type: (WSGIRequest)->JsonResponse
    """
    :param request:
    :return:
    """
    payload = json.loads(request.body) if request.body else {}
    result = DeviceCommand.objects(id__in = payload['ids']).delete()
    if result:
        return JsonOkResponse()
    else:
        return JsonErrorResponse(description = u'删除失败')


@error_tolerate(nil = JsonErrorResponse(u'获取地图失败'), logger = logger)
@permission_required(ROLE.supermanager)
def getDevMapChart(request):
    # type: (WSGIRequest)->JsonResponse
    return JsonOkResponse(payload = {'dataList': []})


@error_tolerate(nil = JsonErrorResponse(u'获取收入趋势失败'), logger = logger)
@permission_required(ROLE.supermanager)
def getIncomeTrend(request):
    return JsonOkResponse(payload = {'dataList': []})


@error_tolerate(nil = JsonErrorResponse(u'获取设备类型统计失败'), logger = logger)
@permission_required(ROLE.supermanager)
def getDeviceTypeStatistics(request):
    return JsonOkResponse(payload = {'dataList': []})


@error_tolerate(nil = JsonErrorResponse(u'获取经销商收入和失败'), logger = logger)
@permission_required(ROLE.supermanager)
def getDealerIncomeTotalTop(request):
    return JsonOkResponse(payload = {'dataList': []})


@error_tolerate(nil = JsonErrorResponse(u'获取用户趋势失败'), logger = logger)
@permission_required(ROLE.supermanager)
def getAllUserTrend(request):
    return JsonOkResponse(payload = {'dataList': []})


@error_tolerate(nil = JsonErrorResponse(u'获取设备注册趋势失败'), logger = logger)
@permission_required(ROLE.supermanager)
def getDeviceRegTrend(request):
    return JsonOkResponse(payload = {'dataList': []})


@error_tolerate(nil = JsonErrorResponse(u'获取反馈趋势失败'), logger = logger)
@permission_required(ROLE.supermanager)
def getAllFeedbackTrend(request):
    return JsonOkResponse(payload = {'dataList': []})


@error_tolerate(nil = JsonErrorResponse(u'获取提现记录失败'), logger = logger)
@permission_required(ROLE.supermanager)
def getWithdrawTrend(request):
    return JsonOkResponse(payload = {'dataList': []})


# noinspection PyUnresolvedReferences
@error_tolerate(nil = JsonErrorResponse(u'导入sim卡数据失败'), logger = logger)
@permission_required(ROLE.supermanager)
def importSim(request):
    current_user = request.user  # type: SuperManager

    def get_offline_task_name(task_type, user, source):
        # type: (basestring, SuperManager, str)->basestring
        now_time = datetime.datetime.now()

        tmp_list = [task_type, user.username, source, now_time.strftime('%Y-%m-%d %H:%M:%S'),
                    str(utils_datetime.generate_timestamp_ex())]

        return '-'.join(tmp_list)

    payload = json.loads(request.body)

    excel_file = payload.get('file')
    source = payload.get('source')

    offline_task_name = get_offline_task_name(
        task_type = OfflineTaskType.IMPORT_SIM_CARD,
        user = current_user,
        source = source)

    offline_task = OfflineTask.issue(offline_task_name = offline_task_name,
                                     process_func_name = 'import_simcard_excel_to_db',
                                     task_type = OfflineTaskType.IMPORT_SIM_CARD,
                                     userid = str(current_user.id),
                                     role = ROLE.supermanager)

    task_caller(offline_task.process_func_name,
                offline_task_id = str(offline_task.id),
                excelFile = excel_file,
                source = source)

    return JsonResponse({
        'result': 1,
        'description': u'成功创建任务，请您在sim卡任务管理中，查看任务执行情况',
        'payload': {
            'offline_task_id': str(offline_task.id)
        }})


@error_tolerate(nil = JsonErrorResponse(u'查询sim卡数据失败'), logger = logger)
@permission_required(ROLE.supermanager)
def getSimCardList(request):
    pageIndex = int(request.GET.get('pageIndex', 1))
    pageSize = int(request.GET.get('pageSize', 10))
    startTimeStr = request.GET.get('startTime', None)
    endTimeStr = request.GET.get('endTime', None)
    searchType = request.GET.get('searchType', '')
    searchKey = request.GET.get('searchKey', '')
    simCardSource = request.GET.get('simCardSource', '')

    startTime = datetime.datetime.strptime(startTimeStr + ' 00:00:00', "%Y-%m-%d %H:%M:%S")
    endTime = datetime.datetime.strptime(endTimeStr + ' 23:59:59', "%Y-%m-%d %H:%M:%S")

    queryArr = ['expireTime__gte=startTime', 'expireTime__lte=endTime']
    if searchType == 'IMSI' and searchKey != '':
        queryArr.append('imsi=searchKey')
    elif searchType == 'ICCID' and searchKey != '':
        queryArr.append('iccid=searchKey')
    else:
        pass

    if simCardSource != '':
        queryArr.append('supplier=searchKey')

    query = ','.join(queryArr)
    ss = eval('SIMCard.objects({})'.format(query))

    dataList = []
    for _ in ss.paginate(pageIndex, pageSize):
        device = Device.objects(iccid = _.iccid).first()
        if device is not None:
            dealer = Dealer.objects(id = device.ownerId).first()
            logicalCode = device.logicalCode
            if dealer is not None:
                dealerStr = dealer.nickname + '_' + dealer.username + '_' + device.ownerId
                agent = Agent.objects(id = dealer.agentId).first()
                if agent is not None:
                    agentStr = agent.nickname + '_' + agent.username + '_' + dealer.agentId
                    manager = Manager.objects(id = agent.managerId).first()
                    if manager is not None:
                        managerStr = manager.nickname + '_' + manager.username + '_' + agent.managerId
                    else:
                        managerStr = ''
                else:
                    agentStr = ''
                    managerStr = ''
            else:
                dealerStr = ''
                agentStr = ''
                managerStr = ''
        else:
            logicalCode = ''
            dealerStr = ''
            agentStr = ''
            managerStr = ''

        dataList.append({
            'imsi': _.imsi,
            'iccid': _.iccid,
            'simCardBrand': _.supplier,
            'expireDate': _.expireTime,
            'logicalCode': logicalCode,
            'dealerStr': dealerStr,
            'agentStr': agentStr,
            'managerStr': managerStr
        })

    return JsonResponse({'result': 1, 'description': '', 'payload': {'total': ss.count(), 'dataList': dataList}})


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def getOfflineTaskList(request):
    # type: (WSGIRequest)->JsonResponse
    """
    获取离线任务列表
    :param request:
    :return:
    """
    current_user = request.user  # type: SuperManager

    page_index = int(request.GET.get('pageIndex', 1))
    page_size = int(request.GET.get('pageSize', 10))
    search_key = request.GET.get('searchKey', None)

    tasks = OfflineTask.objects(ownerId = current_user.id,
                                role = current_user.role).search(search_key).order_by('-dateTimeAdded')
    total = tasks.count()

    return JsonOkResponse(
        payload = {
            'dataList': [t.to_dict() for t in tasks.paginate(pageSize = page_size, pageIndex = page_index)],
            'total': total
        })


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def getOfflineTaskStatus(request):
    # type: (WSGIRequest)->JsonResponse
    task_id = request.GET.get('id')
    if not task_id:
        return JsonErrorResponse(description = u'查询ID为空')

    task = OfflineTask.objects(id = str(task_id)).get()  # type: OfflineTask

    return JsonOkResponse(payload = task.status)


# noinspection PyUnresolvedReferences
@error_tolerate(nil = JsonErrorResponse(u'导入sim卡数据失败'), logger = logger)
@permission_required(ROLE.supermanager)
def exportExcel(request):
    super_manager = request.user  # type: SuperManager

    def get_offline_task_name(task_type, user, **kwargs):
        # type: (basestring, SuperManager, Dict)->basestring

        tmp_list = [task_type, user.username]

        if kwargs['simCardSource'] and kwargs['simCardSource']:
            tmp_list.append(kwargs['simCardSource'])

        tmp_list.append(u'%s至%s' % (kwargs['startTimeStr'], kwargs['endTimeStr']))
        tmp_list.append(str(utils_datetime.generate_timestamp_ex()))

        return '-'.join(tmp_list).replace("/", "_")

    query_dict = {
        'startTimeStr': request.GET.get('startTime', None),
        'endTimeStr': request.GET.get('endTime', None),
        'searchKey': request.GET.get('searchKey', ''),
        'searchType': request.GET.get('searchType', ''),
        'simCardSource': request.GET.get('simCardSource', '')
    }

    offline_task_name = get_offline_task_name(
        task_type = OfflineTaskType.EXPORT_SIM_CARD,
        user = super_manager,
        **query_dict)

    file_path, offline_task = OfflineTask.issue_export_report(offline_task_name = offline_task_name,
                                                              process_func_name = 'export_simcard_excel_from_db',
                                                              task_type = OfflineTaskType.EXPORT_SIM_CARD,
                                                              userid = str(super_manager.id),
                                                              role = ROLE.supermanager)

    task_caller(func_name = str(offline_task.process_func_name),
                offline_task_id = str(offline_task.id),
                filepath = file_path,
                queryDict = query_dict)
    return JsonResponse({
        'result': 1,
        'description': u"请前往离线任务查看任务处理情况",
        'payload': str(offline_task.id)
    })


@error_tolerate(nil = JsonErrorResponse(u'导出设备数据失败'), logger = logger)
@permission_required(ROLE.supermanager)
def exportDevice(request):
    super_manager = request.user  # type: SuperManager

    def get_offline_task_name(task_type, user, **kwargs):
        # type: (basestring, SuperManager, Dict)->basestring

        tmp_list = [task_type, user.username]
        tmp_list.append(u'设备信息')
        tmp_list.append(str(utils_datetime.generate_timestamp_ex()))

        return '-'.join(tmp_list).replace("/", "_")

    query_dict = {
        'logicalCodeList': list(set(request.GET.getlist('logicalCodeList', None)))
    }

    offline_task_name = get_offline_task_name(
        task_type = OfflineTaskType.EXPORT_DEVICE,
        user = super_manager,
        **query_dict)

    file_path, offline_task = OfflineTask.issue_export_report(offline_task_name = offline_task_name,
                                                              process_func_name = 'export_device_excel_from_db',
                                                              task_type = OfflineTaskType.EXPORT_DEVICE,
                                                              userid = str(super_manager.id),
                                                              role = ROLE.supermanager)

    task_caller(func_name = str(offline_task.process_func_name),
                offline_task_id = str(offline_task.id),
                filepath = file_path,
                queryDict = query_dict)
    return JsonResponse({
        'result': 1,
        'description': u"请前往离线任务查看任务处理情况",
        'payload': str(offline_task.id)
    })


@error_tolerate(nil = JsonErrorResponse(u'查询管理日志失败'), logger = logger)
@permission_required(ROLE.supermanager)
def getAdminLog(request):
    pageIndex = int(request.GET.get('pageIndex', 1))
    pageSize = int(request.GET.get('pageSize', 10))
    startTime = request.GET.get('startTime', None)
    endTime = request.GET.get('endTime', None)
    searchKey = request.GET.get('searchKey', '')

    return JsonResponse({'result': 1, 'description': '', 'payload': {'total': 0, 'dataList': []}})


@error_tolerate(nil = DefaultJsonErrorResponse, logger = logger)
@permission_required(ROLE.supermanager)
def getAliApp(request):
    # type: (WSGIRequest)->JsonResponse
    """
    更改微信资金平台APP信息
    :param request:
    :return:
    """
    appid = str(request.GET.get('appid'))

    app = AliApp.objects(appid = appid).first()  # type: AliApp
    if not app:
        return JsonOkResponse(payload = {})
    else:
        return JsonOkResponse(payload = app.to_dict())


@error_tolerate(nil = DefaultJsonErrorResponse, logger = logger)
@permission_required(ROLE.supermanager)
def bindAliApp(request):
    # type: (WSGIRequest)->JsonResponse
    """
    绑定自定义支付宝
    :param request:
    :return:
    """
    payload = json.loads(request.body)  # type: dict

    return api.bindAliApp(payload)


@error_tolerate(nil = DefaultJsonErrorResponse, logger = logger)
@permission_required(ROLE.supermanager)
def bindWechatFund(request):
    # type: (WSGIRequest)->JsonResponse
    """
    绑定自定义微信公众号
    :param request:
    :return:
    """
    payload = json.loads(request.body)  # type: dict

    return api.bindWechatFund(payload)


@error_tolerate(nil = DefaultJsonErrorResponse, logger = logger)
@permission_required(ROLE.supermanager)
def bindWechatCust(request):
    # type: (WSGIRequest)->JsonResponse
    """
    绑定自定义微信公众号
    :param request:
    :return:
    """
    payload = json.loads(request.body)  # type: dict

    return api.bindWechatCust(payload)


@error_tolerate(nil = DefaultJsonErrorResponse, logger = logger)
@permission_required(ROLE.supermanager)
def getWechatFundApp(request):
    # type: (WSGIRequest)->JsonResponse
    """
    更改微信资金平台APP信息
    :param request:
    :return:
    """
    appid = request.GET.get('appid')
    mchid = request.GET.get('mchid')

    app = WechatPayApp.objects(appid = appid, mchid = mchid).first()  # type: WechatPayApp
    if not app:
        return JsonOkResponse(payload = {})
    else:
        return JsonOkResponse(payload = app.to_dict())


@error_tolerate(nil = DefaultJsonErrorResponse, logger = logger)
@permission_required(ROLE.supermanager)
def sendCommand(request):
    # type: (WSGIRequest)->JsonResponse
    """
    :param request:
    :return:
    """
    payload = json.loads(request.body)
    devNo = payload.get("devNo")
    cmdID = payload.get("id")
    params = payload.get("params", list())

    dev = Device.get_dev(devNo)
    if not dev:
        return JsonErrorResponse(u"设备获取失败，请尝试重新发送指令")

    command = DeviceCommand.objects.filter(id = cmdID, role = request.user.role).first()
    if not command:
        return JsonErrorResponse(u"命令获取失败，请尝试重新发送指令")

    try:
        commandDict = command.package_command(dev, params)
    except Exception as e:
        logger.exception(u"dev <{}>, command <{}> , package command error <{}>".format(devNo, cmdID, e))
        return JsonErrorResponse(u"命令发送失败，请尝试重新发送指令")

    cmd = commandDict.get("cmd")
    try:
        result = MessageSender.send(dev, cmd = cmd, payload = commandDict, timeout = 20)
        if result.get("rst") == -1:
            raise ManagerServiceTimeOutException()
        if result.get("rst") == 1:
            raise ManagerServiceSerialException()
    except ServiceException as se:
        return JsonErrorResponse(description = se.result.get("description"))
    except Exception as e:
        logger.exception('failed to send command, error = %s where command was %s' % (e, str(command)))
        return JsonErrorResponse(description = u"指令发送异常")

    return JsonResponse({'result': 1, 'description': u'发送成功', 'payload': json.dumps(result)})


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def getCommandByDevice(request):
    # type: (WSGIRequest)->JsonResponse
    """
    :param request:
    :return:
    """
    logicalCode = request.GET.get('logicalCode')
    commands = DeviceCommand.common_and_type_specific(
        logicalCode = logicalCode,
        commander = request.user
    )
    return JsonResponse({
        'result': 1,
        'description': '',
        'payload': {"dataList": commands}
    })


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def getSimDetail(request):
    # type: (WSGIRequest)->JsonResponse
    """
    :param request:
    :return:
    """
    iccid = request.GET.get('iccid')
    if not iccid:
        return JsonResponse({'result': 0, 'description': u'ICCID不合法', 'payload': ''})

    sim = SIMCard.objects().filter(iccid = iccid).first()  # type: SIMCard
    if not sim:
        payload = {
        }
    else:
        payload = {
            'iccid': sim.iccid,
            'imsi': sim.imsi,
            'supplier': sim.supplier,
            'activeTime': sim.activeTime,
            'expireTime': sim.expireTime,
            'chargeTime': sim.chargeTime
        }

    if (not payload) or (payload['supplier'] == 'qiben'):
        try:
            response = SimManager().get_card_list(begin_iccid = iccid, end_iccid = iccid, card_type = 2)
            if len(response['records']) > 0:
                record = response['records'][0]
                payload.update({
                    'qiben_openCardTime': record['openCardTime'],
                    'qiben_activateTime': record['activateTime'],
                    'qiben_packageTime': record['packageTime'],

                    'qiben_totalFlow': record['totalFlow'],
                    'qiben_cardFlow': record['cardFlow'],
                    'qiben_leftFlow': record['leftFlow'],
                    'qiben_cardStatus': record['cardStatus']
                })
        except Exception as e:
            logger.exception(e)

    return JsonResponse({
        'result': 1,
        'description': '',
        'payload': payload
    })


@error_tolerate(logger = logger, nil = JsonErrorResponse(u'二维码文件存储失败，请重新试试'))
@permission_required(ROLE.supermanager)
def uploadMoniQrcode(request):
    # type: (WSGIRequest)->JsonResponse

    files = request.FILES.getlist('file')
    if not len(files):
        return JsonResponse({'result': 0, 'description': u'未找到上传的二维码文件，请重新试试', 'payload': ''})

    uploader = AliOssFileUploader(inputFile = request.FILES.getlist('file')[0], uploadType = 'qrcode')

    logger.info('[uploadMoniQrcode] %s is being used' % (repr(uploader),))

    try:
        outputUrl = uploader.upload()
        return JsonResponse({'result': 1, 'description': '', 'payload': outputUrl})

    except InvalidFileSize, e:
        logger.info(
            '%s(id=%s)\'s uploaded file reached limit' % (request.user.__class__.__name__, str(request.user.id),))
        return JsonResponse({'result': 0, 'description': e.message, 'payload': {}})

    except InvalidFileName, e:
        logger.info(
            '%s(id=%s)\'s uploaded file name is not legal' % (request.user.__class__.__name__, str(request.user.id),))
        return JsonResponse({'result': 0, 'description': e.message, 'payload': {}})


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def getMoniApps(request):
    pageIndex = int(request.GET.get('pageIndex', 1))
    pageSize = int(request.GET.get('pageSize', 40))
    objs = MoniApp.objects.all()
    dataList = []
    total = objs.count()
    for obj in objs.paginate(pageIndex = pageIndex, pageSize = pageSize):
        dataList.append({
            'appName': obj.appName,
            'appId': obj.appId,
            'rawAppId': obj.rawAppId,
            'secret': obj.secret,
            'appType': obj.appType,
            'priority': obj.priority,
            'status': obj.status,
            'desc': obj.desc,
            'title': obj.title,
            'maxDayAddingCount': obj.maxDayAddingCount
        })

    return JsonOkResponse(payload = {'total': total, 'dataList': dataList})


def createMenu(appId, secret):
    grzx = {
        'type': 'view',
        'name': u'个人中心',
        'url': "http://www.washpayer.com/user/moniUserAccess?moniAppId=%s&redirect=%s" % (appId, 'gerenzhongxin')
    }

    dangqianfuwu = {
        'type': 'view',
        'name': u'当前服务',
        'url': "http://www.washpayer.com/user/moniUserAccess?moniAppId=%s&redirect=%s" % (appId, 'dangqianfuwu')
    }

    changjianwenti = {
        'type': 'view',
        'name': u'常见问题',
        'url': "http://www.washpayer.com/user/moniUserAccess?moniAppId=%s&redirect=%s" % (appId, 'changjianwenti')
    }

    baogaolaoban = {
        'type': 'view',
        'name': u'报告老板',
        'url': "http://www.washpayer.com/user/moniUserAccess?moniAppId=%s&redirect=%s" % (appId, 'baogaolaoban')
    }

    toushushouli = {
        'type': 'view',
        'name': u'投诉受理',
        'url': "http://www.washpayer.com/user/moniUserAccess?moniAppId=%s&redirect=%s" % (appId, 'toushushouli')
    }

    menu = {
        "button":
            [

                {
                    "name": u"服务&投诉",
                    "sub_button": [dangqianfuwu, changjianwenti, baogaolaoban, toushushouli]
                },

                {
                    "type": "scancode_push",
                    "name": u"扫一扫",
                    "key": "rselfmenu_0_1",
                    "sub_button": []
                },
                grzx
            ]
    }

    app = WechatAuthApp(appid = appId, secret = secret)
    proxy = WechatClientProxy(app)
    proxy.client.menu.create(menu)


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def editMoniApp(request):
    payload = json.loads(request.body)
    appId = payload.get('appId', None)
    if appId is None:
        MoniApp.get_collection().insert(payload)
        # 如果是新增加，需要生成菜单
        createMenu(appId, payload['secret'])
    else:
        MoniApp.get_collection().update({'appId': appId}, {'$set': payload}, upsert = True)
    return JsonOkResponse()


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def deleteMoniApp(request):
    payload = json.loads(request.body)
    appIds = payload.get('ids', None)
    MoniApp.get_collection().remove({'appId': {'$in': appIds}})
    return JsonOkResponse()


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def addMoniAppToAgents(request):
    payload = json.loads(request.body)
    agentIds = [ObjectId(_) for _ in payload.get('agentIds', [])]
    moniAppIds = payload.get('moniAppIds', [])
    agents = Agent.objects.filter(id__in = agentIds)
    for agent in agents:
        for appId in moniAppIds:
            if appId not in agent.moniAppList:
                agent.moniAppList.append(appId)
        agent.save()

    return JsonOkResponse()


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def removeMoniAppFromAgents(request):
    payload = json.loads(request.body)
    agentIds = [ObjectId(_) for _ in payload.get('agentIds', [])]
    moniAppId = payload.get('moniAppId', None)
    if moniAppId is None:
        return JsonErrorResponse(description = u'未传入moni appId')
    agents = Agent.objects.filter(id__in = agentIds)
    for agent in agents:
        if moniAppId in agent.moniAppList:
            agent.moniAppList.remove(moniAppId)
        agent.save()

    return JsonOkResponse()


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def queryAgentsForMoniApp(request):
    page_index = int(request.GET.get('pageIndex', 1))
    page_size = int(request.GET.get('pageSize', 10))
    moniAppId = request.GET.get('moniAppId', None)
    if moniAppId is None:
        return JsonErrorResponse(description = u'未传入moni appId')

    total, items = Agent.filter(moniAppList = moniAppId, page_index = page_index,
                                page_size = page_size)
    return JsonOkResponse(
        payload =
        {
            'total': total,
            'dataList': items
        }
    )


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def getCheckPointForAgent(request):
    agentId = request.GET.get('agentId')
    agent = Agent.objects.get(id = agentId)
    pointDict = agent.moniAppCheckPointDict
    return JsonOkResponse(payload = {'data': pointDict})


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def getCheckPointForDealer(request):
    dealerId = request.GET.get('dealerId')
    dealer = Dealer.objects.get(id = dealerId)
    agent = Agent.objects.get(id = dealer.agentId)
    return JsonOkResponse(
        payload = {'dealerData': dealer.moniAppCheckPointDict, 'agentData': agent.moniAppCheckPointDict})


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def setCheckPointForAgents(request):
    payload = json.loads(request.body)
    agentIds = [ObjectId(_) for _ in payload.get('agentIds', [])]
    pointDict = payload.get('pointDict')
    agents = Agent.objects.filter(id__in = agentIds)
    for agent in agents:
        agent.moniAppCheckPointDict = pointDict
        agent.save()
    return JsonOkResponse()


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def setCheckPointForDealers(request):
    payload = json.loads(request.body)
    dealerIds = [ObjectId(_) for _ in payload.get('dealerIds', [])]
    pointDict = payload.get('pointDict')
    dealers = Dealer.objects.filter(id__in = dealerIds)
    for dealer in dealers:
        dealer.moniAppCheckPointDict = pointDict
        dealer.save()
    return JsonOkResponse()


def getMoniPointList(request):
    pageIndex = int(request.GET.get('pageIndex', 1))
    pageSize = int(request.GET.get('pageSize', 10))
    objs = MoniAppPoint.objects.all()
    dataList = [{'id': str(obj.id), 'key': obj.key, 'desc': obj.desc, 'name': obj.name} for obj in
                objs.paginate(pageIndex = pageIndex, pageSize = pageSize)]
    return JsonOkResponse(payload = {'dataList': dataList, 'total': objs.count()})


def editMoniPoint(request):
    payload = json.loads(request.body)
    objId = payload.get('id', None)
    if objId is None:
        MoniAppPoint.get_collection().insert(payload)
    else:
        MoniAppPoint.get_collection().update({'_id': ObjectId(objId)}, {
            '$set': {'name': payload['name'], 'key': payload['key'], 'desc': payload['desc']}}, upsert = True)
    return JsonOkResponse()


def deleteMoniPoint(request):
    payload = json.loads(request.body)
    ids = [ObjectId(_) for _ in payload.get('ids', [])]
    MoniAppPoint.get_collection().remove({'_id': {'$in': ids}})
    return JsonOkResponse()


def editMoniAppForAgents(request):
    payload = json.loads(request.body)
    agentIds = [ObjectId(_) for _ in payload.get('agentIds', [])]
    moniApps = payload.get('moniApp')
    agents = Agent.objects.filter(id__in = agentIds)
    for agent in agents:
        for moniApp in moniApps:
            if moniApp['switch'] and (moniApp['appId'] not in agent.moniAppList):
                agent.moniAppList.append(moniApp['appId'])
            elif (not moniApp['switch']) and (moniApp['appId'] in agent.moniAppList):
                agent.moniAppList.remove(moniApp['appId'])
        agent.save()

    return JsonOkResponse()


def editMoniPointForAgents(request):
    payload = json.loads(request.body)
    agentIds = [ObjectId(_) for _ in payload.get('agentIds', [])]
    points = payload.get('moniPoint')
    agents = Agent.objects.filter(id__in = agentIds)
    for agent in agents:
        for point in points:
            agent.moniAppCheckPointDict.update({point['key']: point['switch']})
        agent.save()

    return JsonOkResponse()


def editMoniPointForDealers(request):
    payload = json.loads(request.body)
    dealerIds = [ObjectId(_) for _ in payload.get('dealerIds', [])]
    points = payload.get('moniPoint')
    dealers = Dealer.objects.filter(id__in = dealerIds)
    for dealer in dealers:
        for point in points:
            dealer.moniAppCheckPointDict.update({point['key']: point['switch']})
        dealer.save()

    return JsonOkResponse()


def editDealerFollowGzh(request):
    payload = json.loads(request.body)
    dealerIds = [ObjectId(_) for _ in payload.get('ids', [])]

    forceFollowGzh = payload.get('forceFollowGzh', 'agent')

    if forceFollowGzh != 'never':
        dealers = Dealer.objects.filter(id__in = dealerIds, forceFollowGzh__ne = 'never')
    else:
        dealers = Dealer.objects.filter(id__in = dealerIds)

    needDealerIds = []
    for dealer in dealers:
        # 如果代理商已经never了，这里不允许更新
        agent = Agent.objects.get(id = dealer.agentId)
        if agent.forceFollowGzhForDealer == 'never':
            continue

        needDealerIds.append(dealer.id)

    Dealer.get_collection().update({'_id': {'$in': needDealerIds}}, {'$set': {'forceFollowGzh': forceFollowGzh}},
                                   multi = True)

    return JsonOkResponse()


# def editDealerFollowGzh(request):
#     payload = json.loads(request.body)
#     dealerIds = [ObjectId(_) for _ in payload.get('ids',[])]
#     forceFollowGzh = payload.get('forceFollowGzh','agent')
#     Dealer.get_collection().update({'_id':{'$in':dealerIds}},{'$set':{'forceFollowGzh':forceFollowGzh}},multi = True)
#     return JsonOkResponse()

#### FAQ
@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def getFAQDetailList(request):
    # type: (WSGIRequest)->JsonResponse
    """
    超级管理员获取FAQ列表
    :param request:
    :return:
    """
    faqs = FAQ.objects(managerId = '')
    return JsonResponse(
        {
            'result': 1,
            'description': None,
            'payload': {
                'dataList': [faq.to_dict() for faq in faqs]
            }
        }
    )


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def addFAQ(request):
    # type: (WSGIRequest)->JsonResponse
    payload = json.loads(request.body)
    payload.update({'managerId': ''})
    faq = FAQ(**payload).save()
    return JsonResponse(
        {
            'result': 1 if faq else 0,
            'description': None,
            'payload': {}
        }
    )


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def editFAQ(request):
    # type: (WSGIRequest)->JsonResponse
    payload = json.loads(request.body)
    updated = FAQ.objects(id = str(payload['id'])).update(**payload)
    return JsonResponse(
        {
            'result': 1 if updated else 0,
            'description': None,
            'payload': {}
        }
    )


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def deleteFAQ(request):
    # type: (WSGIRequest)->JsonResponse
    ids = json.loads(request.body)['ids']
    map(lambda _: _.delete(), FAQ.objects(id__in = ids))
    return JsonResponse({'result': 1, 'description': '', 'payload': {}})


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def editAgentForceFollowGzh(request):
    payload = json.loads(request.body)
    agentStrIds = payload.get('ids', [])
    ids = [ObjectId(_) for _ in agentStrIds]
    forceFollowGzhForDealer = payload.get('forceFollowGzhForDealer', 'free')
    forceFollowGzh = True if payload.get('forceFollowGzh', 'no') == 'yes' else False

    # 先把代理商的统一修改掉
    Agent.get_collection().update({'id': {'$in': ids}}, {'$set': {'forceFollowGzh': forceFollowGzh}}, multi = True)

    # 经销商的，仅仅是把锁住的，全部解锁。或者全部加锁
    if forceFollowGzhForDealer == 'free':
        Dealer.get_collection().update({'agentId': {'$in': agentStrIds}, 'forceFollowGzh': 'never'},
                                       {'$set': {'forceFollowGzh': 'free'}}, multi = True)
    else:
        Dealer.get_collection().update({'agentId': {'$in': agentStrIds}}, {'$set': {'forceFollowGzh': 'never'}},
                                       multi = True)

    if forceFollowGzh:
        return JsonOkResponse(description = u'注意，如果打开代理商的强制关注，一定要在代理商系统把代理商的公众号相关信息，比如二维码、appId、secret相关信息配置OK')

    return JsonOkResponse()


@error_tolerate(nil = DefaultJsonErrorResponse)
@trace_call(logger = logger)
@permission_required(ROLE.supermanager)
def getSignalTrendByDevice(request):
    strStartTime = request.GET.get('startTime')
    strEndTime = request.GET.get('endTime')
    startTime = to_datetime(strStartTime)
    endTime = to_datetime(strEndTime)

    logicalCode = request.GET.get('logicalCode')
    devNo = Device.get_devNo_by_logicalCode(logicalCode)

    dataList = []
    # 把redis的数据也补上去，然后重新排序，为的是防止数据库没有解析记录
    nowTime = datetime.datetime.now()
    tempStartTime = nowTime - datetime.timedelta(days = 7)
    values = SignalManager.instence().get(devNo, tempStartTime, nowTime)
    if values is not None:
        for value in values:
            timePoint = to_datetime(value['time'])
            if timePoint >= startTime and timePoint <= endTime:
                dataList.append('%s=%s' % (value['time'], value['signal']))

    resultList = []
    for data in dataList:
        tempList = data.split('=')
        resultList.append({
            'dateStr': tempList[0],
            'signal': tempList[1]
        })

    return JsonOkResponse(payload = {'dataList': resultList})


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def unLoginLock(request):
    payload = json.loads(request.body)
    role = payload['role']
    if role == ROLE.dealer:
        user = Dealer.objects(id = payload['id']).first()  # type: UserSearchable
    elif role == ROLE.agent:
        user = Agent.objects(id = payload['id']).first()  # type: UserSearchable
    elif role == ROLE.manager or ROLE.manufacturer:  # 传过来的字段不一样 constant里面加了一个字段manufacturer 做容错
        user = Manager.objects(id = payload['id']).first()  # type: UserSearchable
    else:
        return JsonErrorResponse(description = u'无效的用户类型')

    if not user:
        return JsonErrorResponse(description = u'找不到该用户，请刷新后再试')

    user.unlock_login()

    return JsonOkResponse(description = u'解锁成功')


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def unlockRegisterLimit(request):
    payload = json.loads(request.body)
    dealer = Dealer.objects(id = payload['id']).first()
    if dealer is None:
        return JsonErrorResponse(description = u'不存在的经销商')

    serviceCache.delete('dealer_{}_registerEquipment_{}'.format(str(dealer.id), datetime.datetime.now().strftime(Const.DATE_FMT)))

    return JsonOkResponse(description = u'解锁成功')


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def queryExchangeOrder(request):
    pageIndex = int(request.GET.get('pageIndex', 1))
    pageSize = int(request.GET.get('pageSize', 10))
    searchKey = request.GET.get('searchKey', '')

    managerId = request.GET.get('managerId')
    agentId = request.GET.get('agentId')
    dealerId = request.GET.get('dealerId')

    query = {}

    if managerId is not None:
        query['factoryId'] = ObjectId(managerId)

    if agentId is not None:
        query['agentId'] = ObjectId(agentId)

    if dealerId is not None:
        query['ownerId'] = ObjectId(dealerId)

    orders = ExchangeOrder.objects(**query).search(searchKey).order_by('-dateTimeAdded')
    total = orders.count()  # type: int

    dataList = []
    for order in orders.paginate(pageIndex = pageIndex, pageSize = pageSize):
        data = {}

        dealer = Dealer.objects.get(id = order.ownerId)
        agent = Agent.objects.get(id = order.agentId)
        factory = Manager.objects.get(id = order.factoryId)
        data['dealerInfo'] = u'%s:%s' % (dealer.username, dealer.nickname)
        data['agentInfo'] = u'%s:%s' % (agent.productName, agent.nickname)
        data['factoryInfo'] = u'%s' % (factory.brandName)
        data['logicalCode'] = order.logicalCode
        objs = Part.objects.filter(id__in = order.parts)
        data['parts'] = [{'partName': obj.partName, 'registerTime': obj.dateTimeAdded.strftime(Const.DATETIME_FMT),
                          'expiredTime': obj.expiredTime.strftime(Const.DATETIME_FMT), 'SN': obj.partNo} for obj in
                         objs]

        data['statusInfo'] = order.make_status_info()
        data['pics'] = order.pics
        data['id'] = str(order.id)
        data['dateTimeAdded'] = order.dateTimeAdded.strftime(Const.DATETIME_FMT)
        data['factoryOrderNo'] = order.factoryOrderNo
        data['dealerOrderNo'] = order.dealerOrderNo
        data['factoryAddr'] = order.factoryAddr
        data['dealerAddr'] = order.dealerAddr
        data['dealerWords'] = order.dealerWords
        data['factoryWords'] = order.factoryWords
        data['more'] = order.more

        dataList.append(data)

    return JsonOkResponse(payload = {'total': total, 'dataList': dataList})


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def operateOrder(request):
    payload = json.loads(request.body)
    orderId = payload['id']
    cmd = payload['status']
    factoryOrderNo = payload.get('factoryOrderNo', '')
    order = ExchangeOrder.objects.get(id = orderId)
    logicalCode = order.logicalCode
    dev = Device.get_dev_by_l(logicalCode)
    group = Group.get_group(groupId = dev['groupId'])

    if cmd == 'agree':
        if order.factoryStatus in ['sended', 'closed']:
            return JsonErrorResponse(description = u'当前维护单已经走下去了，不需要再同意了')
        else:
            order.factoryStatus = 'agreed'
            order.save()
    elif cmd == 'disagree':
        if order.factoryStatus in ['sended', 'closed']:
            return JsonErrorResponse(description = u'当前维护单已经走下去了，不需要再同意了')
        else:
            order.factoryStatus = 'disagreed'
            order.save()
    elif cmd == 'close':
        if order.factoryStatus == 'closed':
            pass
        elif order.dealerStatus == 'created' or order.factoryStatus != 'sended':
            return JsonErrorResponse(description = u'经销商必须把有问题的产品寄回来，厂家必须把置换货发出去后，才允许关闭')
    elif cmd == 'send':
        if order.factoryStatus != 'agreed':
            return JsonOkResponse(description = u'必须同意之后，才能够发货哦')
        if not factoryOrderNo:
            return JsonErrorResponse(description = u'需要输入发货快递单号')
        order.factoryOrderNo = factoryOrderNo
        order.save()

    cmdDescDict = {'agree': u'同意换货', 'disagree': u'不同意换货', 'close': u'成功关闭', 'send': u'已经发货'}

    titleDictList = [
        {u'售后中心': cmdDescDict.get(cmd)},
        {u'设备编号': logicalCode},
        {u'地址名称': group["groupName"]}
    ]

    if cmd == 'send':
        titleDictList.append({u'发货单号': factoryOrderNo})

    dealer = Dealer.objects.get(id = order.ownerId)
    partNames = [_.partName for _ in Part.objects.filter(id__in = order.parts)]

    args = {
        'title': make_title_from_dict(titleDictList),
        'customer': u'%s\\n' % (dealer.nickname),
        'detail': u'质保换货，%s\\n' % u'，'.join(partNames),
        'person': u'售后中心\\n',
        'notifyTime': u'%s\\n' % datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S'),
        'remark': u'您可以在设备管理中，查看详细情况\\n' if cmd != 'send' else u'售后中心已经给您寄货，请您尽快把问题组件寄回给我们\\n'
    }

    if dealer.managerialOpenId:
        task_caller('report_to_dealer_via_wechat', openId = dealer.managerialOpenId,
                    dealerId = str(dealer.id),
                    templateName = 'exchange_order_notify',
                    **args)
    return JsonOkResponse()


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def updateMaintenanceInfo(request):
    payload = json.loads(request.body)
    orderId = payload['id']
    factoryWords = payload['factoryWords']
    more = payload['more']
    factoryAddr = payload['factoryAddr']
    order = ExchangeOrder.objects.get(id = orderId)
    order.more = more
    order.factoryWords = factoryWords
    order.factoryAddr = factoryAddr
    order.save()
    return JsonOkResponse()


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def saveFactoryAddress(request):
    payload = json.loads(request.body)
    name = payload.get('name', None)
    addr = payload.get('addr', None)
    tel = payload.get('tel', None)
    managerId = payload.get('managerId', None)

    if (not name) or (not addr) or (not tel):
        return JsonErrorResponse(description = u'名称、地址、电话都不允许为空')

    manager = Manager.objects(id = managerId).get()
    manager.expressAddr = {'name': name, 'addr': addr, 'tel': tel}
    manager.save()

    return JsonOkResponse()


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def clearDeviceCache(request):
    payload = json.loads(request.body)
    devNo = payload.get('devNo')

    Device.invalid_all_cache(Device.get_dev(devNo))

    return JsonOkResponse()


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def setDeviceDebug(request):
    payload = json.loads(request.body)
    devNo = payload.get('devNo')
    debugFlag = payload.get('debugFlag', '')

    device = Device.objects(devNo = devNo).first()  # type: Device
    device.debug = debugFlag
    device.save()

    Device.invalid_device_cache(devNo)

    return JsonOkResponse()


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def changeDealerAnnualTrafficCost(request):
    payload = json.loads(request.body)
    ownerId = payload['ids'][0]
    annualTrafficCost = payload['annualTrafficCost']

    # todo 先单独给德力西改流量费做特殊处理
    if annualTrafficCost < 15:
        return JsonErrorResponse(description = u'DLX改流量费, 经销商最低流量费价格不能小于15')

    dealer = Dealer.objects(id = ownerId).first()
    dealer.annualTrafficCost = RMB(str(annualTrafficCost))
    dealer.trafficCardCost = RMB(str(annualTrafficCost))
    dealer.save()
    ds = Device.objects(ownerId = ownerId)
    for _ in ds:
        _.trafficCardCost = None
        _.annualTrafficCost = None
        _.save()
        Device.invalid_device_cache(_.devNo)

    return JsonOkResponse(description = u'修改成功')


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def getDealerRechargeRecord(request):
    searchType = request.GET['searchType']
    searchKey = request.GET.get('searchKey')
    pageIndex = int(request.GET.get('pageIndex', 1))
    pageSize = int(request.GET.get('pageSize', 40))
    if searchType == u'logicalCode':
        orderNo = ''
        logicalCode = searchKey
    elif searchType == u'orderNo':
        orderNo = searchKey
        logicalCode = ''
    else:
        return JsonErrorResponse(description = u'请输入正确的查询条件')

    dataList = []

    if orderNo != '':
        dealerRechargeRcds = DealerRechargeRecord.objects(orderNo = orderNo, status = 'Paid')
        if dealerRechargeRcds.count() == 0:
            return JsonErrorResponse(description = u'未付款或不存在的订单号')


    elif logicalCode != '':
        dealerRechargeRcds = DealerRechargeRecord.objects(name__contains = ' ' + logicalCode, status = 'Paid')
        if dealerRechargeRcds.count() == 0:
            return JsonErrorResponse(description = u'未付款或不存在的订单号')
    else:
        return JsonErrorResponse(description = u'请输入查询条件')

    for _ in dealerRechargeRcds.paginate(pageIndex = pageIndex, pageSize = pageSize):
        dealer = Dealer.objects(id = _.dealerId).first()
        if dealer is None:
            dealerStr = ''
        else:
            dealerStr = dealer.nickname + '  ' + dealer.username

        dataList.append({
            'orderNo': _.orderNo,
            'dealerStr': dealerStr,
            'orderParams': _.attachParas,
            'simOrderDict': {
                'name': _.name
            },
            'totalFee': str(float(_.totalFee) / 100),
            'dateTimeAdded': _.finishedTime.strftime('%Y-%m-%d %H:%M:%S')
        })

    return JsonOkResponse(payload = {'dataList': dataList})


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def refundDealerRecharge(request):
    payload = json.loads(request.body)
    refundMoney = RMB(payload.get('refundMoney', '0.0'))
    if refundMoney <= RMB('0.0'):
        return JsonErrorResponse(description = u'未知错误')

    dealerRechargeRecord = DealerRechargeRecord.objects(orderNo = payload.get('orderNo', '')).first()
    if dealerRechargeRecord is None:
        return JsonErrorResponse(description = u'订单编号错误')

    try:
        refund_cash_to_dealer(dealerRechargeRecord, refundMoney)
    except UserServerException as e:
        return JsonErrorResponse(description = e.message)
    except Exception as e:
        return JsonErrorResponse(description = u'系统错误')

    return JsonOkResponse()


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def manualRechargeSimCard(request):
    payload = json.loads(request.body)

    lList = payload['logicalCode']

    if len(lList) == 0:
        return JsonErrorResponse(description = u'没有选择设备编号')

    dealerMap = {}

    for device in Device.objects(logicalCode__in = lList):
        if device.simStatus == SimStatus.Charged:
            logger.debug('sim status of {} is charged.'.format(str(device)))
            continue

        if str(device.ownerId) in dealerMap:
            dealer = dealerMap[str(device.ownerId)]
        else:
            dealer = Dealer.objects(id = device.ownerId).first()
            dealerMap[str(device.ownerId)] = dealer

        payment_gateway = get_manual_pay_gateway(dealer)

        rcd = create_dealer_sim_charge_order(payment_gateway, dealer, [device], payType = "manual")
        if not rcd:
            return JsonErrorResponse(
                description = u'创建订单失败，部分设备线下续费失败，请检查后重试(设备号{})。'.format(device.logicalCode))

        rcd.succeed(wxOrderNo = rcd.orderNo)

        device.simStatus = u'chargedUnupdated'
        device.save()
        Device.invalid_device_cache(device.devNo)

    return JsonOkResponse()


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def querySupporters(request):
    return JsonOkResponse()


@error_tolerate(logger = logger, nil = JsonErrorResponse(u"获取免责声明失败"))
@permission_required(ROLE.supermanager)
def getAgentDisclaimer(request):
    """
    获取代理商的免责声明 内容
    :param request:
    :return:
    """
    agentId = request.GET.get("agentId", "")

    agent = Agent.objects.get(id = agentId)

    payload = {
        "content": agent.disclaimerContent,
        "version": agent.disclaimerVersion.split("_")[1],
        "needDisclaimer": agent.needDisclaimer
    }
    return JsonOkResponse(payload = payload)


@error_tolerate(logger = logger, nil = JsonErrorResponse(u"设置免责声明失败"))
@permission_required(ROLE.supermanager)
def setAgentDisclaimer(request):
    """
    设置代理商的免责声明 内容
    :param request:
    :return:
    """
    payload = json.loads(request.body)
    agentId = payload.get("agentId")
    needDisclaimer = payload.get("needDisclaimer")
    disclaimerContent = payload.get("content")
    version = payload.get("version")

    agent = Agent.objects.get(id = agentId)
    agent.update(needDisclaimer = needDisclaimer)

    agent.disclaimerVersion = version
    agent.disclaimerContent = disclaimerContent

    return JsonOkResponse()


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def modifyDeviceCode(request):
    payload = json.loads(request.body)

    logicalCodes = payload.get('logicalCodeList', [])
    code = payload.get('code')

    if not logicalCodes:
        return JsonErrorResponse(description='没有选中的设备')

    if not code:
        return JsonErrorResponse(description='code输入有误')

    mark = None
    deviceOwner = Device.get_dev_by_l(logicalCodes[0]).owner
    model_device = Device.objects.filter(ownerId=str(deviceOwner.id), devType__code=code).order_by('-id').first()

    if model_device:
        devType = model_device.devType
        washConfig = model_device.washConfig
        otherConf = model_device.otherConf

        logger.info(
            'washConfig=<{}> otherConf=<{}> devType=<{}> sync params tar=<{}>'.format(washConfig, otherConf, devType,
                                                                                         logicalCodes))
        mark = 1

    else:
        devType = DeviceType.objects.filter(agentId=deviceOwner.agentId, code=code).first()  # type: DeviceType
        if devType:
            package = deviceOwner.defaultWashConfig.get(str(devType.id))
            if not package:
                package = devType.package
            washConfig = dict(map(lambda _: (str(package.index(_) + 1), _), package))

            otherConf = {}
            devType = devType.to_dict()

            logger.info('washConfig=<{}> otherConf=<{}> devType=<{}> sync params!! tar=<{}>'.format(washConfig, otherConf, devType,logicalCodes))

            mark = 2

        else:
            devType = DeviceType.objects.filter(code=code).first()  # type: DeviceType
            if devType:
                devType = DeviceType.objects.create(**{
                    "role": "manager",
                    "online": devType.online,
                    "unit": devType.unit,
                    "stock": devType.stock,
                    "payableWhileBusy": devType.payableWhileBusy,
                    "displayCoinsSwitch": True,
                    "displayPriceSwitch": True,
                    "displayTimeSwitch": True,
                    "name": devType.name,
                    "package": devType.package,
                    "code": code,
                    "majorDeviceType": devType.majorDeviceType,
                    "devFeatures": getattr(devType, 'devFeatures', []),
                    "agentId": deviceOwner.agentId
                })

            else:
                return JsonErrorResponse(description='没有这个code, 去手动添加操作')

            washConfig = dict(map(lambda _: (str(package.index(_)+1), _), devType.package))
            otherConf = {}
            devType = devType.to_dict()

            logger.info('washConfig=<{}> otherConf=<{}> devType=<{}> sync params!!! tar=<{}>'.format(washConfig, otherConf, devType,logicalCodes))

            mark = 3


    devNos = []
    for _ in logicalCodes:
        devNos.append(Device.get_dev_by_logicalCode(_).devNo)

    Device.get_collection().update_one({'devNo': {'$in': devNos}}, {
        '$set': {'devType': devType, 'washConfig': washConfig, 'otherConf': otherConf}})

    Device.invalid_many_device_cache(devNos)

    payload = {'devType': devType, 'washConfig': washConfig, 'otherConf': otherConf, 'logicalCodes': logicalCodes}

    if mark == 1:
        return JsonOkResponse(description='修改成功并与设备:{} 同步参数'.format(model_device.logicalCode), payload=payload)

    elif mark == 2:
        return JsonOkResponse(description='修改成功', payload=payload)

    elif mark == 3:
        return JsonOkResponse(description='修改成功, 并新增一个设备类型<devType: {}>'.format(devType['code']), payload=payload)

    else:
        return JsonErrorResponse(description='修改失败!, 去手动添加操作')


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def getUserComplaintList(request):
    pageIndex = int(request.GET.get('pageIndex', 1)) - 1
    pageSize = int(request.GET.get('pageSize', 10))
    startTime = request.GET.get('startTime', None)
    endTime = request.GET.get('endTime', None)
    complaintId = request.GET.get('complaintId', None)
    stateFilter = request.GET.get('stateFilter', None)

    dataList = []
    total = 0
    if startTime is None and endTime is None and complaintId is None:
        return JsonOkResponse(payload = {'total': total, 'dataList': dataList})

    elif startTime is not None and endTime is not None and complaintId is None:
        wxProvider = WechatServiceProvider.objects(mchid = '398254625').first()  # type: WechatServiceProvider
        wechatComplaintUtil = WechatComplaint(
            mchid = wxProvider.mchid,
            asn = wxProvider.apiclient_serial_number,
            slk = wxProvider.sslKey)

        try:
            dataList = wechatComplaintUtil.query_complaint_list(dateStart = startTime, dateEnd = endTime,
                                                                pageIndex = pageIndex, pageSize = pageSize)
        except Exception as e:
            return JsonErrorResponse(description = u'查询条件错误, 不支持大于30天的间隔时间, 或是未知错误。')

        if stateFilter is not None:
            dataList1 = []
            for _ in dataList:
                if _['complaint_state'] == stateFilter:
                    dataList1.append(_)

            return JsonOkResponse(payload = {'total': len(dataList1), 'dataList': dataList1})

        return JsonOkResponse(payload = {'total': len(dataList), 'dataList': dataList})

    elif complaintId is not None:
        wxProvider = WechatServiceProvider.objects(mchid = '398254625').first()  # type: WechatServiceProvider
        wechatComplaintUtil = WechatComplaint(
            mchid = wxProvider.mchid,
            asn = wxProvider.apiclient_serial_number,
            slk = wxProvider.sslKey)
        dataList = [wechatComplaintUtil.query_complaint_details_from_id(complaintId)]
        return JsonOkResponse(payload = {'total': 1, 'dataList': dataList})

    else:
        return JsonErrorResponse(description = u'查询条件不在业务范围内')


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def replyComplaint(request):
    payload = json.loads(request.body)
    complaintId = payload.get('complaint_id', '')
    remark = payload.get('remark', '')

    wxProvider = WechatServiceProvider.objects(mchid = '398254625').first()  # type: WechatServiceProvider
    wechatComplaintUtil = WechatComplaint(
        mchid = wxProvider.mchid,
        asn = wxProvider.apiclient_serial_number,
        slk = wxProvider.sslKey)
    result = wechatComplaintUtil.submit_complaint_reply(complaintId, remark)

    if result == 204:
        return JsonOkResponse(description = u'成功')
    else:
        return JsonErrorResponse(description = u'接口回复失败')


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def submitComplaint(request):
    payload = json.loads(request.body)
    complaintId = payload.get('complaint_id', '')

    wxProvider = WechatServiceProvider.objects(mchid = '398254625').first()  # type: WechatServiceProvider
    wechatComplaintUtil = WechatComplaint(
        mchid = wxProvider.mchid,
        asn = wxProvider.apiclient_serial_number,
        slk = wxProvider.sslKey)
    result = wechatComplaintUtil.feedback_complaint_completed(complaintId)

    if result == 204:
        return JsonOkResponse(description = u'成功')
    else:
        return JsonErrorResponse(description = u'接口回复失败')


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def rentDevice(request):
    """
    出租设备
    :param request:
    :return:
    """
    payload = json.loads(request.body)
    logicalCode = payload.get("logicalCode")

    device = Device.objects.get(logicalCode = logicalCode)
    try:
        device.rent()
    except RentDeviceError as renError:
        return JsonErrorResponse(description = renError.message)

    Device.invalid_device_cache(device.devNo)
    return JsonOkResponse()


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def getInsuranceOrder(request):
    """
    获取
    :param request:
    :return:
    """
    wxOrderNo = request.GET.get("outTradeNo")
    if not wxOrderNo:
        return JsonErrorResponse(u"请输入交易单号查询")
    # 根据外部支付单号 找到唯一的支付订单
    orders = RechargeRecord.objects.filter(wxOrderNo = wxOrderNo, via = 'insurance')  # type: RechargeRecord

    dataList = list()
    for _order in orders:
        _insuranceOrder = InsuranceOrder.objects.get(rechargeRcdId = _order.id)

        _dealer = _insuranceOrder.dealer  # type: DealerDict
        _user = _insuranceOrder.user  # type: MyUser
        _group = _insuranceOrder.group  # type: GroupDict

        data = {
            "id": _insuranceOrder.id,
            "price": _insuranceOrder.money,
            "dealerName": "{}".format(_dealer["nickname"], _dealer["username"]),
            "devNo": _insuranceOrder.devNo,
            "groupName": _group.groupName,
            "logicalCode": _insuranceOrder.logicalCode,

            "openId": _insuranceOrder.openId,
            "userNickname": _user.nickname,

            "startTime": _insuranceOrder.startTime,
            "endTime": _insuranceOrder.endTime,
            "via": _order.via,

            "dateTimeAdded": _insuranceOrder.dateTimeAdded,

            "refunded": not bool(_insuranceOrder.effective)
        }

        dataList.append(data)

    return JsonOkResponse(payload = {"total": len(dataList), "dataList": dataList})


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def refundInsuranceOrder(request):
    return JsonErrorResponse(u"保险产品已经下架")


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def setDealerMaxPackagePrice(request):
    payload = json.loads(request.body)
    dealerIds = payload.get('ids', [])
    maxPackagePrice = payload.get('maxPackagePrice', 1)

    if maxPackagePrice > 200:
        return JsonErrorResponse(description = u'套餐金额过大')

    if dealerIds == []:
        return JsonErrorResponse(description = u'未选择经销商')

    try:
        for _ in dealerIds:
            dealer = Dealer.objects(id = _).first()
            if dealer is None:
                continue
            dealer.maxPackagePrice = RMB(int(maxPackagePrice))
            dealer.save()
    except Exception as e:
        return JsonErrorResponse(description = u'未知错误')

    return JsonOkResponse()


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def lockDeviceSimStatus(request):
    payload = json.loads(request.body)
    logicalCodes = payload.get('logicalCode', [])

    if logicalCodes == []:
        return JsonErrorResponse(description = u'未选择设备')

    try:
        for _ in logicalCodes:
            device = Device.objects(logicalCode = _).first()
            if device is None:
                continue
            device.simStatus = u'updated'
            device.save()
            Device.invalid_device_cache(device.devNo)
    except Exception as e:
        return JsonErrorResponse(description = u'未知错误')

    return JsonOkResponse()


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def unlockDeviceSimStatus(request):
    payload = json.loads(request.body)
    logicalCodes = payload.get('logicalCode', [])

    if logicalCodes == []:
        return JsonErrorResponse(description = u'未选择设备')

    try:
        for _ in logicalCodes:
            device = Device.objects(logicalCode = _).first()
            if device is None:
                continue
            device.simStatus = u'chargedUnupdated'
            device.save()
            Device.invalid_device_cache(device.devNo)
    except Exception as e:
        return JsonErrorResponse(description = u'未知错误')

    return JsonOkResponse()


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def showDeviceDevTypes(request):
    payload = json.loads(request.body)
    logicalCodes = payload.get('logicalCode', [])

    if len(logicalCodes) != 1:
        return JsonErrorResponse(description = u'设备选择有误')
    logicalCode = logicalCodes[0]

    device = Device.objects(logicalCode = logicalCode).first()
    if device.ownerId == '':
        return JsonErrorResponse(description = u'设备未注册')

    dealer = Dealer.objects(id = device.ownerId).first()
    if dealer is None:
        return JsonErrorResponse(description = u'经销商不存在')

    agentId = dealer.agentId
    if agentId == '':
        return JsonErrorResponse(description = u'代理商不存在, 系统异常')

    dataList = [{
        'devTypeCode': _.code,
        'devTypeName': _.name,
        'devTypeId': str(_.id)
    } for _ in DeviceType.objects(agentId = agentId)]

    return JsonOkResponse(payload = {"total": len(dataList), "dataList": dataList})


@error_tolerate(nil = DefaultJsonErrorResponse)
@permission_required(ROLE.supermanager)
def changeDeviceDevType(request):
    payload = json.loads(request.body)
    logicalCodes = payload.get('logicalCode', [])
    devTypeId = payload.get('devTypeId', '')

    if len(logicalCodes) != 1:
        return JsonErrorResponse(description = u'设备选择有误')
    logicalCode = logicalCodes[0]
    device = Device.objects(logicalCode = logicalCode).first()
    devType = DeviceType.objects(id = devTypeId).first()

    try:
        Device.objects(logicalCode = logicalCode).update_one(upsert = False, **{'devType': devType.to_dict()})
    except Exception as e:
        return JsonErrorResponse(description = u'操作失败')
    finally:
        Device.invalid_device_cache(device.devNo)

    return JsonOkResponse()


@error_tolerate(logger=logger, nil=JsonErrorResponse(u"查询失败"))
@permission_required(ROLE.supermanager)
def getApiAppInfo(request):
    """
        获取经销上API注册信息
    """

    dealerId = request.GET.get("dealerId")

    dealer = Dealer.objects(id=dealerId).first()
    if not dealer:
        logger.error('dealer<id={}> is not exists.'.format(dealerId))
        return JsonErrorResponse(description='经销商不存在')

    apiInfo = dealer.api_app # type: ApiAppInfo

    return JsonOkResponse(payload={
        'people': apiInfo.people,
        'tel': apiInfo.tel,
        'callbackUrl': apiInfo.callbackUrl,
        'apiDeviceMax': apiInfo.apiDeviceMax,
        'apiDevicePerCost': float(apiInfo.apiDevicePerCost)
    })


@error_tolerate(logger=logger, nil=JsonErrorResponse(u"设置失败"))
@permission_required(ROLE.supermanager)
def editApiAppInfo(request):
    """
        编辑经销上API注册信息
    """

    def check_url(url):
        return re.match(r'^((https|http|ftp|rtsp|mms)?:\/\/)[^\s]+', url)

    payload = json.loads(request.body)

    dealerId = payload.get('dealerId')
    dealer = Dealer.objects(id=dealerId).first()
    if not dealer:
        logger.error('dealer<id={}> is not exists.'.format(dealerId))
        return JsonErrorResponse(description='经销商不存在')

    people = payload.get('people')
    tel = payload.get('tel')
    callbackUrl = payload.get('callbackUrl')
    apiDeviceMax = payload.get('apiDeviceMax')
    apiDevicePerCost = payload.get('apiDevicePerCost')

    if callbackUrl and not check_url(callbackUrl):
        return JsonErrorResponse(description='回调地址Url填写错误')

    if not isinstance(apiDeviceMax, int):
        return JsonErrorResponse(description='API配额参数错误')

    if not is_number(apiDevicePerCost):
        return JsonErrorResponse(description='配额单价参数错误')

    dealer.update_api_app(**{
        'people': people,
        'tel': tel,
        'callbackUrl': callbackUrl,
        'apiDeviceMax': apiDeviceMax,
        'apiDevicePerCost': apiDevicePerCost
    })

    return JsonOkResponse()


@error_tolerate(logger=logger, nil=JsonErrorResponse(u"设置失败"))
@permission_required(ROLE.supermanager)
def setServiceButtonStatus(request):
    """
        设置个人中心正在服务的功能按钮展示
    """

    payload = json.loads(request.body)

    logicalCodes = payload.get('logicalCode', [])
    if len(logicalCodes) != 1:
        return JsonErrorResponse(description='设备数量错误')
    stopUsing = payload.get('stopUsing', None)
    continueToUse = payload.get('continueToUse', None)

    device = Device.objects(logicalCode=logicalCodes[0]).first()
    if device is None:
        return JsonErrorResponse(description='未知错误')

    deviceType = DeviceType.objects(id=device.devType['id']).first()
    if deviceType is None:
        return JsonErrorResponse(description='未知错误')

    if stopUsing is not None:
        deviceType.servicesButtonDict['stopUsing'] = stopUsing
        deviceType.save()

    if continueToUse is not None:
        deviceType.servicesButtonDict['continueToUse'] = continueToUse
        deviceType.save()

    return JsonOkResponse()


@error_tolerate(logger = logger, nil = JsonErrorResponse(u"获取经销商银行卡失败"))
@permission_required(ROLE.supermanager)
def getDealerBanks(request):
    dealerId = request.GET.get('dealerId')

    if not dealerId:
        return JsonErrorResponse(description = u'参数错误')

    dealer = Dealer.objects(id = dealerId).first()
    if not dealer:
        return JsonErrorResponse(description = u'经销商不存在，请刷新后再试')

    return JsonOkResponse(payload = {
        'dataList': [
            card.to_dict() for card in
            WithdrawBankCard.objects(ownerId = str(dealer.id), role = dealer.role).all()
        ]
    })


@error_tolerate(logger = logger, nil = JsonErrorResponse(u"保存经销商银行卡失败"))
@permission_required(ROLE.supermanager)
def saveDealerBankAccount(request):
    payload = json.loads(request.body)

    dealerId = payload.pop('dealerId', None)

    if not dealerId:
        return JsonErrorResponse(description = u'参数错误')

    dealer = Dealer.objects(id = dealerId).first()
    if not dealer:
        return JsonErrorResponse(description = u'经销商不存在，请刷新后再试')

    bank_card_id = payload.pop('id', None)

    try:
        payload = SaveWithdrawBankCardSchemaForSuper(payload)
    except MultipleInvalid as e:
        logger.exception(e)
        return JsonErrorResponse(description = u"信息不完整(1001)")

    isPublic = payload.pop('isPublic')

    if isPublic:
        try:
            payload = SavePublicWithdrawBankCardExtraSchema(payload)
        except MultipleInvalid as e:
            logger.exception(e)
            return JsonErrorResponse(description = u"信息不完整(1002)")

        branchBank = WithdrawBranchBanks.objects(
            code = payload['branchBankCode']).first()  # type: WithdrawBranchBanks
        if not branchBank:
            return JsonErrorResponse(description = u"查询不到支行信息")

        WithdrawBankCard.new_public_withdraw_bank_card(
            id = bank_card_id,
            ownerId = dealerId,
            role = ROLE.dealer,
            bankCode = payload['bankCode'],
            bankName = payload['bankName'],
            accountName = payload['accountName'],
            accountCode = payload['accountCode'],
            phone = payload.get('phone', ''),
            provinceCode = payload['provinceCode'],
            province = payload['province'],
            cityCode = payload['cityCode'],
            city = payload['city'],
            branchBankCode = branchBank.code,
            branchBankName = branchBank.name,
            cnapsCode = branchBank.cnapsCode)
    else:
        WithdrawBankCard.new_personal_withdraw_bank_card(
            id = bank_card_id,
            ownerId = dealerId,
            role = ROLE.dealer,
            phone = payload.get('phone', ''),
            bankName = payload['bankName'],
            accountName = payload['accountName'],
            accountCode = payload['accountCode'])

    return JsonOkResponse()


@error_tolerate(logger = logger, nil = JsonErrorResponse(u"删除经销商银行卡失败"))
@permission_required(ROLE.supermanager)
def deleteDealerBankAccount(request):
    payload = json.loads(request.body)

    bank_card_id = payload.get('id', None)

    if not bank_card_id:
        return JsonErrorResponse(description = u'参数错误')

    WithdrawBankCard.objects(id = bank_card_id).delete()

    return JsonOkResponse()