Exemplo n.º 1
0
def subAccountConsumptionList(account_id,
                              started_at,
                              ended_at,
                              condition,
                              page_no=1,
                              page_size=15):
    '''子账户消费列表'''
    try:
        account = Account()
        account.account_id = account_id
        accountDao = AccountDao(account)
        accountDao.detail()
        rows, count = accountDao.subAccountList(accountDao.account.user_id,
                                                condition, page_no, page_size)
        result = []
        if datetime2Str(started_at) == change2UTC(
                datetime.datetime.strftime(datetime.datetime.now(), '%Y-%m') +
                '-01',
                format='%Y-%m-%d') and datetime2Str(
                    datetime2Str(ended_at, outformat='%Y-%m-%d %H'),
                    informat='%Y-%m-%d %H') == change2UTC(
                        datetime.datetime.strftime(datetime.datetime.now(),
                                                   '%Y-%m-%d %H'),
                        format='%Y-%m-%d %H'):
            if rows:
                accountDao = AccountDao()
                for row in rows:
                    account = Account()
                    account.account_id = row['account_id']
                    accountDao.account = account
                    accountDao.detail()
                    row['amount_total'] = accountDao.account.current_month_amount
                    row['standard_amount_total'] = accountDao.account.current_month_standard_amount
                    result.append(row)
        else:
            if rows:
                consumptionDao = ConsumptionDao()
                for row in rows:
                    total = consumptionDao.getAmountSummary(
                        row['account_id'], started_at, ended_at)
                    result.append(dict(row, **total))
        return outSuccess(
            'subAccountConsumptionList',
            pagePackage("accounts",
                        result,
                        page_no=page_no,
                        page_size=page_size,
                        total=count))
    except Exception as e:
        LOG.error(str(e))
        LOG.error(traceback.format_exc())
        return outError("取得子账户消费列表失败!")
Exemplo n.º 2
0
def detail(account_id):
    '''账号详情'''
    try:
        account = Account()
        account.account_id = account_id
        accountDao = AccountDao(account)
        accountDao.detail()
        return outSuccess(
            "account", getJsonFromObj(accountDao.account, ACCOUNT_OBJECT_KEY))
    except Exception as e:
        LOG.error(str(e))
        LOG.error(traceback.format_exc())
        return outError("取得账号详情失败!")
Exemplo n.º 3
0
def subAccountAmountSum(account_id, started_at, ended_at):
    try:
        account = Account()
        account.account_id = account_id
        accountDao = AccountDao(account)
        accountDao.detail()
        return outSuccess(
            "sunAccountAmountSum",
            accountDao.subAccountAmountSum(accountDao.account.user_id,
                                           started_at, ended_at))
    except Exception as e:
        LOG.error(str(e))
        LOG.error(traceback.format_exc())
        return outError("取得子账户列表失败!")
Exemplo n.º 4
0
def getSubAccountSum(account_id, headers=None, **kwargs):
    '''子账户数目统计'''
    try:
        account = Account()
        account.account_id = account_id
        accountDao = AccountDao(account)
        accountDao.detail()
        return outSuccess(
            "subAccountSum",
            accountDao.getSubAccountComsump(accountDao.account.user_id))
    except Exception as e:
        LOG.error(str(e))
        LOG.error(traceback.format_exc())
        return outError("取得子账户统计失败!")
Exemplo n.º 5
0
def ProjectAdminsubAccountList(account_id, condition=None):
    try:
        account = Account()
        account.account_id = account_id
        accountDao = AccountDao(account)
        accountDao.detail()
        result, count = accountDao.ProjectAdminsubAccountList(
            accountDao.account.user_id, condition)
        print result
        return outSuccess('subAccountList',
                          pagePackage('accounts', result, total=count))
    except Exception as e:
        LOG.error(str(e))
        LOG.error(traceback.format_exc())
        return outError("取得子账户列表失败!")
Exemplo n.º 6
0
def checkProjectAdmin(account_id):
    '''判断是否是分销商用户'''
    try:
        account = Account()
        account.account_id = account_id
        accountDao = AccountDao(account)
        accountDao.detail()
        commonDao = CommonDao()
        return outSuccess(
            'isProjectAdmin',
            commonDao.checkProjectAdmin(accountDao.account.user_id))
    except Exception as e:
        LOG.error(str(e))
        LOG.error(traceback.format_exc())
        return outError("服务器错误")
Exemplo n.º 7
0
def subAccountList(account_id, condition=None, page_no=1, page_size=15):
    try:
        account = Account()
        account.account_id = account_id
        accountDao = AccountDao(account)
        accountDao.detail()
        result, count = accountDao.subAccountList(accountDao.account.user_id,
                                                  condition, page_no,
                                                  page_size)
        return outSuccess(
            "subAccountList",
            pagePackage("accounts",
                        result,
                        page_no=page_no,
                        page_size=page_size,
                        total=count))
    except Exception as e:
        LOG.error(str(e))
        LOG.error(traceback.format_exc())
        return outError("取得子账户列表失败!")