74 lines
4.8 KiB
Plaintext
74 lines
4.8 KiB
Plaintext
async def revenue_analysis(ns={}):
|
|
"""
|
|
收入分析
|
|
:param ns:
|
|
:return:
|
|
"""
|
|
use_type = ns.get('time')
|
|
|
|
if use_type == 'total':
|
|
# 收入客户贡献TOP10
|
|
customer_filter = [{'甘曼蔓': 2243}, {'傅湘云': 3214}, {'富美玲': 3237}, {'邓如曼': 4900}, {'须凤歌': 7098}, {'慕艾玲': 7200}, {'薛青寒': 10684}, {'勾迎曼': 14492}, {'瞿幼柏': 17974}, {'于莺韵': 19530}]
|
|
|
|
# 收入产品贡献TOP10
|
|
product_filter = [{'product8': 40771}, {'product3': 68455}, {'product5': 87400}, {'product1': 108562}, {'product9': 121656}, {'product6': 122339}, {'product2': 160835}, {'product4': 189349}, {'product7': 189435}, {'product0': 197421}]
|
|
|
|
# 收入销售贡献TOP10
|
|
saler_filter = [{'销售8': 39335}, {'销售0': 43783}, {'销售1': 49300}, {'销售5': 65572}, {'销售6': 94224}, {'销售2': 116781}, {'销售9': 117257}, {'销售4': 117279}, {'销售3': 140242}, {'销售7': 198299}]
|
|
|
|
# 收入分销商贡献TOP10
|
|
reseller_filter = [{'分销商5': 68789}, {'分销商4': 80512}, {'分销商8': 83126}, {'分销商1': 92314}, {'分销商9': 93245}, {'分销商2': 95666}, {'分销商0': 170798}, {'分销商7': 264210}, {'分销商6': 273289}, {'分销商3': 281382}]
|
|
|
|
# 收入供应商贡献TOP10
|
|
provider_filter = [{'供应商8': 117586}, {'供应商5': 146763}, {'供应商1': 163715}, {'供应商2': 281236}, {'供应商4': 301530}, {'供应商6': 303358}, {'供应商0': 324926}, {'供应商9': 372192}, {'供应商7': 482176}, {'供应商3': 505249}]
|
|
elif use_type == 'month':
|
|
# 收入客户贡献TOP10
|
|
customer_filter = [{'曼蔓': 243}, {'傅云': 314}, {'富玲': 437}, {'邓曼': 500}, {'须歌': 698}, {'慕玲': 700},
|
|
{'薛寒': 884}, {'勾曼': 992}, {'瞿柏': 1074}, {'于韵': 1130}]
|
|
|
|
# 收入产品贡献TOP10
|
|
product_filter = [{'product8': 1771}, {'product3': 2455}, {'product5': 3400}, {'product1': 3562},
|
|
{'product9': 4656}, {'product6': 5339}, {'product2': 6835}, {'product4': 7349},
|
|
{'product7': 89435}, {'product0': 97421}]
|
|
|
|
# 收入销售贡献TOP10
|
|
saler_filter = [{'销售8': 1335}, {'销售0': 2783}, {'销售1': 3300}, {'销售5': 4572}, {'销售6': 5224}, {'销售2': 6781},
|
|
{'销售9': 7257}, {'销售4': 8279}, {'销售3': 140242}, {'销售7': 198299}]
|
|
|
|
# 收入分销商贡献TOP10
|
|
reseller_filter = [{'分销商3': 95294}, {'分销商4': 136740}, {'分销商6': 146426}, {'分销商9': 242342}, {'分销商1': 343503}, {'分销商0': 353984}, {'分销商8': 379048}, {'分销商2': 428907}, {'分销商5': 543138}, {'分销商7': 575466}]
|
|
|
|
# 收入供应商贡献TOP10
|
|
provider_filter = [{'供应商9': 152398}, {'供应商6': 162324}, {'供应商5': 265996}, {'供应商1': 311509}, {'供应商2': 331525}, {'供应商7': 442458}, {'供应商3': 488528}, {'供应商4': 568126}, {'供应商0': 570370}, {'供应商8': 589015}]
|
|
else:
|
|
# 收入客户贡献TOP10
|
|
customer_filter = [{'邓如曼9': 2416}, {'须凤歌4': 3486}, {'于莺韵3': 4018}, {'甘曼蔓0': 4078}, {'瞿幼柏8': 4115}, {'薛青寒6': 4129}, {'傅湘云2': 6502}, {'勾迎曼1': 6847}, {'慕艾玲7': 8406}, {'富美玲5': 8648}]
|
|
|
|
# 收入产品贡献TOP10
|
|
product_filter = [{'product1': 2026}, {'product3': 2446}, {'product6': 2638}, {'product9': 2645}, {'product0': 2707}, {'product7': 2736}, {'product2': 2792}, {'product5': 2895}, {'product8': 2924}, {'product4': 2985}]
|
|
|
|
# 收入销售贡献TOP10
|
|
saler_filter = [{'销售9': 2148}, {'销售6': 2204}, {'销售8': 3675}, {'销售1': 4151}, {'销售0': 4470}, {'销售4': 4783}, {'销售2': 5595}, {'销售3': 6542}, {'销售5': 6789}, {'销售7': 7469}]
|
|
|
|
# 收入分销商贡献TOP10
|
|
reseller_filter = [{'分销商4': 13157}, {'分销商8': 16102}, {'分销商0': 36519}, {'分销商5': 37099}, {'分销商2': 43437}, {'分销商1': 43966}, {'分销商9': 47948}, {'分销商6': 52943}, {'分销商3': 53793}, {'分销商7': 57453}]
|
|
|
|
# 收入供应商贡献TOP10
|
|
provider_filter = [{'供应商4': 20645}, {'供应商7': 21567}, {'供应商9': 22314}, {'供应商5': 28103}, {'供应商3': 28600}, {'供应商2': 33063}, {'供应商0': 43690}, {'供应商1': 45111}, {'供应商8': 46151}, {'供应商6': 54639}]
|
|
|
|
|
|
return {
|
|
'status': True,
|
|
'msg': 'revenueanalysis kpi get success',
|
|
'bind_name': '收入分析',
|
|
'data': {
|
|
'customer': customer_filter,
|
|
'product': product_filter,
|
|
'saler': saler_filter,
|
|
'reseller': reseller_filter,
|
|
'provider': provider_filter
|
|
}
|
|
}
|
|
|
|
ret = await revenue_analysis(params_kw)
|
|
return ret |