def get_table(search_date, channel_id=-1, server_id=-1):
new_log_lst = daily_log_dat.get_new_log_lst(search_date, search_date)
if channel_id >= 0:
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda x: x['platform_id'] == channel_id)
if server_id >= 0:
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda x: x['server_id'] == server_id)
#获取全部新手引导日志
all_guide_log_lst = daily_log_dat.filter_logs(new_log_lst, action=game_define.EVENT_ACTION_FINISH_GUIDE)
# 总共5个引导步骤 （1-6）
total_user = daily_log_dat.get_set_num_with_key(all_guide_log_lst, 'uid')
complete_user_dict = dict()
guide_name = [u'宠物升级',u'宠物突破',u'宠物进化',u'宠物技能',u'宠物洗练',u'宠物装备',u'新队伍位置']
for i in xrange(1, 8):
# 当前引导的所有日志
guide_index_log_lst = daily_log_dat.filter_logs(all_guide_log_lst, function=lambda x: x['guide_id'] == i)
complete_user_num = daily_log_dat.get_set_num_with_key(guide_index_log_lst, 'uid')
complete_user_dict[i] = complete_user_num
table_result = []
for i in xrange(1, 8):
next_num = complete_user_dict.get(i+1,0)
row = [
i,
guide_name[i-1],
complete_user_dict[i], # 完成人数
]
table_result.append(row)
return table_result
def get_table(search_date, channel_id=-1, server_id=-1):
new_log_lst = daily_log_dat.get_new_log_lst(search_date, search_date)
if channel_id >= 0:
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda x: x['platform_id'] == channel_id)
if server_id >= 0:
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda x: x['server_id'] == server_id)
#获取全部新手引导日志
all_newbie_log_lst = daily_log_dat.filter_logs(new_log_lst, action=game_define.EVENT_ACTION_FINISH_NEWBIE)
# 总共5个引导步骤 （1-6）
total_user = daily_log_dat.get_set_num_with_key(all_newbie_log_lst, 'uid')
complete_user_dict = dict()
newbie_name = [u'第一场战斗', u'抽取宝贝球', u'加入队伍', u'自动战斗', u'每日任务']
for i in xrange(1, 6):
# 当前引导的所有日志
guide_index_log_lst = daily_log_dat.filter_logs(all_newbie_log_lst, function=lambda x: x['newbie_id'] == i)
complete_user_num = daily_log_dat.get_set_num_with_key(guide_index_log_lst, 'uid')
complete_user_dict[i] = complete_user_num
table_result = []
for i in xrange(1, 6):
next_num = complete_user_dict.get(i+1,0)
row = [
i,
newbie_name[i-1],
complete_user_dict[i], # 完成人数
]
table_result.append(row)
return table_result
def get_table(search_start_date, search_end_date, register_start_date=None, register_end_date=None, channel_id=-1, server_id=-1):
"""
获取展示表格
register_start_date 注册开始时间
register_end_date 注册结束时间
search_start_date 查询开始时间
search_end_date 查询结束时间
"""
# 获取搜索区间日志
new_log_lst = daily_log_dat.get_new_log_lst(search_start_date, search_end_date)
if channel_id >= 0:
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda x: x['platform_id'] == channel_id)
if server_id >= 0:
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda x: x['server_id'] == server_id)
#获取符合条件的日志
if register_start_date and register_end_date:
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda log: register_start_date <= log['install'] <= register_end_date)
# 截取日志到 副本事件
stage_action_lst = [
game_define.EVENT_ACTION_FISHING_ONCE,
game_define.EVENT_ACTION_FISHING_LOOP,
]
table_lst = []
search_days = (search_end_date - search_start_date).days+1
for _day in xrange(search_days):
row_date = search_start_date + datetime.timedelta(days=_day)
# print("-------------------" + str(row_date) + "-------------------")
# 获取当天的日志
row_logs = daily_log_dat.filter_logs(new_log_lst, function=lambda log: log['log_time'].date() == row_date)
# 过滤出钓鱼日志
stage_action_log_lst = daily_log_dat.filter_logs(row_logs,
function=lambda log: log['action'] in stage_action_lst)
# print("钓鱼日志 " + str(stage_action_log_lst))
# 日期
row_date_str = row_date.strftime('%m/%d/%Y')
# 参与人数
join_user_num = daily_log_dat.get_set_num_with_key(stage_action_log_lst, 'uid')
# 总钓鱼次数
total_finish_num = daily_log_dat.get_sum_int_with_key(stage_action_log_lst, 'cost_fishing_count')
# 行日期之前的 日志
until_row_day_logs = daily_log_dat.filter_logs(new_log_lst, function=lambda log: log['log_time'].date() <= row_date)
# 到达要求人数
can_join_user_num = daily_log_dat.get_set_num_with_key(until_row_day_logs, 'uid', function=lambda log:log['level'] >= 15)
# 参与率
join_rate = 0
if can_join_user_num:
join_rate = round(float(join_user_num)/float(can_join_user_num), 2) * 100
row_lst = [
row_date_str, # 日期
join_user_num, # 参与人数
total_finish_num, # 总钓鱼次数
can_join_user_num, # 到达要求人数
str(join_rate) + "%" # 参与率
]
table_lst.append(row_lst)
return table_lst
def get_cost_stone_table(search_start_date, search_end_date, register_start_date=None, register_end_date=None, channel_id=-1, server_id=-1):
"""
获取展示表格
register_start_date 注册开始时间
register_end_date 注册结束时间
search_start_date 查询开始时间
search_end_date 查询结束时间
"""
# 获取搜索区间日志
search_log_lst = daily_log_dat.get_new_log_lst(search_start_date, search_end_date)
if channel_id >= 0:
search_log_lst = daily_log_dat.filter_logs(search_log_lst, function=lambda x: x['platform_id'] == channel_id)
if server_id >= 0:
search_log_lst = daily_log_dat.filter_logs(search_log_lst, function=lambda x: x['server_id'] == server_id)
#获取符合条件的日志
if register_start_date and register_end_date:
search_log_lst = daily_log_dat.filter_logs(search_log_lst, function=lambda log: register_start_date <= log['install'] <= register_end_date)
table_lst = []
# 全部消耗钻石日志
all_login_log_lst = daily_log_dat.filter_logs(search_log_lst, action=game_define.EVENT_ACTION_ROLE_LOGIN)
all_cost_stone_log_lst = daily_log_dat.filter_logs(search_log_lst, function=lambda log: 'cost_stone' in log)
# 获取所有消耗钻石玩家UID
uid_num = daily_log_dat.get_set_num_with_key(all_cost_stone_log_lst, 'uid')
# 获取所有消耗钻石玩家设备lst
device_num = daily_log_dat.get_set_num_with_key(all_login_log_lst, 'dev_id')
# 消耗钻石总数
total_cost_stone = daily_log_dat.get_sum_int_with_key(all_cost_stone_log_lst, 'cost_stone')
# 根据ID拆分日志
action_logs_dict = dict()
for _log in all_cost_stone_log_lst:
_action = _log['action']
if _action in action_logs_dict:
action_logs_dict[_action].append(_log)
else:
lst = [_log]
action_logs_dict[_action]=lst
for _action, _logs in action_logs_dict.items():
user_num = daily_log_dat.get_set_num_with_key(_logs, 'uid')
action_total_cost_stone = daily_log_dat.get_sum_int_with_key(_logs, 'cost_stone')
action_name = game_define.EVENT_LOG_ACTION_DICT[_action]
action_cost_num = len(_logs)
# 参与率
# print("参与率 " + str(user_num) + " " + str(device_num))
take_part_rate = str(_get_rate(user_num, device_num)) + "%"
# 人数比率
# print("人数比率 " + str(user_num) + " " + str(uid_num))
cur_user_num_rate = str(_get_rate(user_num, uid_num)) + "%"
# 钻石比率
first_cost_stone_rate = str(_get_rate(action_total_cost_stone, total_cost_stone)) + "%"
row = [action_name, action_total_cost_stone, user_num, action_cost_num, take_part_rate, first_cost_stone_rate, cur_user_num_rate]
table_lst.append(row)
return table_lst
def get_table(search_start_date, search_end_date, register_start_date=None, register_end_date=None, channel_id=-1, server_id=-1):
"""
获取展示表格
register_start_date 注册开始时间
register_end_date 注册结束时间
search_start_date 查询开始时间
search_end_date 查询结束时间
"""
# 获取搜索区间日志
new_log_lst = daily_log_dat.get_new_log_lst(search_start_date, search_end_date)
if channel_id >= 0:
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda x: x['platform_id'] == channel_id)
if server_id >= 0:
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda x: x['server_id'] == server_id)
#获取符合条件的日志
if register_start_date and register_end_date:
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda log: register_start_date <= log['install'] <= register_end_date)
# 截取日志到 副本事件
stage_action_lst = [
game_define.EVENT_ACTION_FINGER_GUESS_EXCHANGE,
]
table_lst = []
search_days = (search_end_date - search_start_date).days+1
for _day in xrange(search_days):
row_date = search_start_date + datetime.timedelta(days=_day)
# print("-------------------" + str(row_date) + "-------------------")
# 获取当天的日志
row_logs = daily_log_dat.filter_logs(new_log_lst, function=lambda log:log['log_time'].date() == row_date)
# 过滤出日志
stage_action_log_lst = daily_log_dat.filter_logs(row_logs,
function=lambda log: log['action'] in stage_action_lst)
# print("猜拳日志 " + str(stage_action_log_lst))
# 日期
row_date_str = row_date.strftime('%m/%d/%Y')
# 参与人数
join_user_num = daily_log_dat.get_set_num_with_key(stage_action_log_lst, 'uid')
# 总次数
total_active_num = len(stage_action_log_lst)
# 行日期之前的 日志
until_row_day_logs = daily_log_dat.filter_logs(new_log_lst, function=lambda log: log['log_time'].date() <= row_date)
# 到达要求人数
can_join_user_num = daily_log_dat.get_set_num_with_key(until_row_day_logs, 'uid', function=lambda log:log['level'] >= 13)
# 参与率
join_rate = 0
if can_join_user_num:
join_rate = round(float(join_user_num)/float(can_join_user_num), 2) * 100
row_lst = [
row_date_str, # 日期
join_user_num, # 参与人数
total_active_num, # 总钓鱼次数
can_join_user_num, # 到达要求人数
str(join_rate) + "%" # 参与率
]
table_lst.append(row_lst)
return table_lst
def get_table(search_start_date, search_end_date, channel_id=-1, server_id=-1, player_min_level=1,
player_max_level=999):
# 获取搜索区间日志
search_log_lst = daily_log_dat.get_new_log_lst(search_start_date, search_end_date)
if channel_id >= 0:
search_log_lst = daily_log_dat.filter_logs(search_log_lst, function=lambda x: x['platform_id'] == channel_id)
if server_id >= 0:
search_log_lst = daily_log_dat.filter_logs(search_log_lst, function=lambda x: x['server_id'] == server_id)
# 适配等级
search_log_lst = daily_log_dat.filter_logs(search_log_lst, function=lambda x: player_min_level <= x['level'] <= player_max_level)
# 所有的消耗钻石的日志
all_cost_stone_log_lst = daily_log_dat.filter_logs(search_log_lst, function=lambda log: 'cost_stone' in log)
# 根据事件拆分消耗日志
action_cost_stone_dict = daily_log_dat.split_log_action_logs(all_cost_stone_log_lst)
table_lst = []
# 遍历所有事件
for _action, _logs in action_cost_stone_dict.items():
row_lst = []
# 事件名称
action_name = game_define.EVENT_LOG_ACTION_DICT[_action]
# 充值用户消耗的部分日志
vip1_up_user_log = daily_log_dat.filter_logs(_logs, function=lambda log:log['vip_level'] != 0)
# 非充值用户的部分日志
vip0_user_log = daily_log_dat.filter_logs(_logs, function=lambda log:log['vip_level'] == 0)
# 充值用户消耗人数
recharge_user_num = daily_log_dat.get_set_num_with_key(vip1_up_user_log, 'uid')
# 充值用户消耗次数
recharge_user_log_num = len(vip1_up_user_log)
# 非充值用户的人数
vip0_user_num = daily_log_dat.get_set_num_with_key(vip0_user_log, 'uid')
# 非充值用户消耗次数
vip0_user_log_num = len(vip0_user_log)
# vip0 消耗钻石
vip0_cost_stone_num = daily_log_dat.get_sum_int_with_key(vip0_user_log, 'cost_stone')
# 消耗钻石数量
total_cost_stone_num = daily_log_dat.get_sum_int_with_key(_logs, 'cost_stone')
#事件名称 充值用户消耗人数 充值用户消耗次数 非充值用户消耗人数 非充值用户消耗次数 消耗钻石数量 VIP0消耗金额 VIP0消耗人数
row_lst = [action_name, recharge_user_num, recharge_user_log_num, vip0_user_num, vip0_user_log_num, total_cost_stone_num, vip0_cost_stone_num, vip0_user_num]
# 遍历VIP
for i in xrange(1, 13):
vip_x_log = daily_log_dat.filter_logs(vip1_up_user_log, function=lambda log:log['vip_level'] == i)
vip_x_cost_stone_num = daily_log_dat.get_sum_int_with_key(vip_x_log, 'cost_stone')
vip_x_cost_stone_user_num = daily_log_dat.get_set_num_with_key(vip_x_log, 'uid')
row_lst.append(vip_x_cost_stone_num)
row_lst.append(vip_x_cost_stone_user_num)
table_lst.append(row_lst)
return table_lst
def get_cost_stone_table(search_start_date, search_end_date, channel_id=-1, server_id=-1):
"""
获取表格
"""
table_lst = []
search_log_lst = daily_log_dat.get_new_log_lst(search_start_date, search_end_date)
if channel_id >= 0:
search_log_lst = daily_log_dat.filter_logs(search_log_lst, function=lambda x: x['platform_id'] == channel_id)
if server_id >= 0:
search_log_lst = daily_log_dat.filter_logs(search_log_lst, function=lambda x: x['server_id'] == server_id)
# 获取排除新手引导的日志列表
search_log_lst = daily_log_dat.filter_logs(search_log_lst, function=lambda log: log['action'] != game_define.EVENT_ACTION_FINISH_NEWBIE)
search_log_lst = daily_log_dat.filter_logs(search_log_lst, function=lambda log: log['action'] != game_define.EVENT_ACTION_FINISH_GUIDE)
# 获取首次消耗钻石的日志列表
first_cost_stone_log_lst = daily_log_dat.filter_logs(search_log_lst, function=lambda log: 'total_cost_stone' in log and log['total_cost_stone'] == log['cost_stone'])
# 获取首次消耗钻石的所有用户
first_cost_stone_user_num = daily_log_dat.get_set_num_with_key(first_cost_stone_log_lst, 'uid')
# 总钻石数
first_cost_stone_total_num = daily_log_dat.get_sum_int_with_key(first_cost_stone_log_lst, 'total_cost_stone')
# 根据ID拆分日志
action_logs_dict = dict()
for _log in first_cost_stone_log_lst:
# print("_log:"+str(_log))
_action = _log['action']
if _action in action_logs_dict:
action_logs_dict[_action].append(_log)
else:
lst = [_log]
action_logs_dict[_action] = lst
for _action, _logs in action_logs_dict.items():
user_num = daily_log_dat.get_set_num_with_key(_logs, 'uid')
action_total_cost_stone = daily_log_dat.get_sum_int_with_key(_logs, 'cost_stone')
action_name = game_define.EVENT_LOG_ACTION_DICT[_action]
# 人数比率
cur_user_num_rate = str(_get_rate(user_num, first_cost_stone_user_num)) + "%"
# print("action_total_cost_stone: "+str(action_total_cost_stone)+"first_cost_stone_total_num: "+str(first_cost_stone_total_num))
# 钻石比率
first_cost_stone_rate = str(_get_rate(action_total_cost_stone, first_cost_stone_total_num)) + "%"
row = [action_name, action_total_cost_stone, user_num, cur_user_num_rate, first_cost_stone_rate]
table_lst.append(row)
return table_lst
def get_table(search_start_date, search_end_date, channel_id=-1, server_id=-1):
# 搜索日期到今天的所有日志
all_log_lst = daily_log_dat.get_new_log_lst(search_start_date, search_end_date)
if channel_id >= 0:
all_log_lst = daily_log_dat.filter_logs(all_log_lst, function=lambda x: x['platform_id'] == channel_id)
if server_id >= 0:
all_log_lst = daily_log_dat.filter_logs(all_log_lst, function=lambda x: x['server_id'] == server_id)
# 获取充值列表
recharge_log_lst = daily_log_dat.filter_logs(all_log_lst, action=game_define.EVENT_ACTION_RECHARGE_PLAYER)
# 获取日期数
search_days = (search_end_date - search_start_date).days
table_result = []
for i in xrange(search_days+1):
row = []
cur_date = search_start_date + datetime.timedelta(days=i)
this_day_recharge_log = daily_log_dat.filter_logs(recharge_log_lst, function=lambda log:log['log_time'].date() == cur_date)
# 插入数据
row.append(cur_date.strftime('%m/%d/%Y'))
for shop_id in xrange(1, 9):
user_num = daily_log_dat.get_set_num_with_key(this_day_recharge_log, 'uid',function=lambda log:log['shop_index'] == shop_id)
# 插入数据
row.append(user_num)
table_result.append(row)
return table_result
def get_table(from_date, to_date, channel_id=-1, server_id=-1):
"""
获取在线表数据
"""
dis_minute = 5 # 5分钟间隔
from_datetime = datetime.datetime.strptime(str(from_date), '%Y-%m-%d')
to_datetime = datetime.datetime.strptime(str(to_date), '%Y-%m-%d')
new_log_lst = daily_log_dat.get_new_log_lst(from_datetime.date(), to_datetime.date())
if channel_id >= 0:
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda x: x['platform_id'] == channel_id)
if server_id >= 0:
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda x: x['server_id'] == server_id)
total_line = int((to_datetime - from_datetime).total_seconds() / (dis_minute * 60))
row_lst = []
for line in xrange(total_line):
row = []
get_start_datetime = from_datetime + datetime.timedelta(minutes=dis_minute * line)
get_end_datetime = get_start_datetime + datetime.timedelta(minutes=dis_minute)
cur_user_num = daily_log_dat.get_set_num_with_key(new_log_lst, 'uid', function=lambda log: get_start_datetime <= log['log_time'] <= get_end_datetime)
row.append(get_end_datetime.strftime("%Y-%m-%d %H:%M:%S"))
row.append(cur_user_num)
row_lst.append(row)
return row_lst
def get_table(search_start_date, search_end_date, channel_id=-1, server_id=-1, player_min_level=1,
player_max_level=999):
# 获取搜索区间日志
new_log_lst = daily_log_dat.get_new_log_lst(search_start_date, search_end_date)
if channel_id >= 0:
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda x: x['platform_id'] == channel_id)
if server_id >= 0:
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda x: x['server_id'] == server_id)
# 适配等级
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda x: player_min_level <= x['level'] <= player_max_level)
# 获取用户表
# uid_lst = daily_log_dat.get_set_with_key(new_log_lst, 'uid')
search_days = (search_end_date - search_start_date).days
table_lst = []
for _day in xrange(search_days + 1):
row_date = search_start_date + datetime.timedelta(days=_day)
row_logs = daily_log_dat.filter_logs(new_log_lst, function=lambda log: log['log_time'].date() == row_date)
#拆分玩家金币日志
user_gold_dict = daily_log_dat.split_log_users_last_gold(row_logs)
# 获取玩家总金币数
total_gold = sum([val for val in user_gold_dict.values()])
total_user = len(user_gold_dict)
active_user = daily_log_dat.get_set_num_with_key(row_logs, 'uid', function=lambda log:log['install'] != row_date)
row_lst = [row_date.strftime('%m/%d/%Y'), total_gold, total_user, active_user]
table_lst.append(row_lst)
return table_lst
def get_table(search_start_date, search_end_date, register_start_date=None, register_end_date=None, channel_id=-1, server_id=-1):
"""
获取展示表格
register_start_date 注册开始时间
register_end_date 注册结束时间
search_start_date 查询开始时间
search_end_date 查询结束时间
"""
# 获取搜索区间日志
new_log_lst = daily_log_dat.get_new_log_lst(search_start_date, search_end_date)
if channel_id >= 0:
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda x: x['platform_id'] == channel_id)
if server_id >= 0:
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda x: x['server_id'] == server_id)
#获取符合条件的日志
if register_start_date and register_end_date:
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda log: register_start_date <= log['install'] <= register_end_date)
# 获取所有钻石消耗的日志
cost_stone_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda log: 'cost_stone' in log)
level_log_dict = get_user_level_dict(cost_stone_log_lst)
table_result = []
for _lv in xrange(1, 121):
# print("--------------------"+str(_lv) + "--------------------")
row = []
lv_logs = level_log_dict[_lv]
uid_lst = daily_log_dat.get_set_with_key(lv_logs, 'uid')
sum_cost_stone = daily_log_dat.get_sum_int_with_key(lv_logs, 'cost_stone')
cur_lv_num = len(uid_lst)
#到达人数
arrive_user_num = daily_log_dat.get_set_num_with_key(new_log_lst, 'uid', function=lambda log: log['level'] >= _lv)
# 等级
row.append(str(_lv))
# 消耗人数
row.append(str(cur_lv_num))
# 消耗数量
row.append(str(sum_cost_stone))
# 到达人数
row.append(arrive_user_num)
# 等级消耗ARPPU
if cur_lv_num == 0:
row.append(str(0))
else:
row.append(str(round(float(sum_cost_stone) / float(cur_lv_num), 2)))
# 等级消耗率
if arrive_user_num == 0:
row.append(str(0) + "%")
else:
row.append(str(round(float(cur_lv_num) / float(arrive_user_num), 2) * 100) + "%")
# row = [_lv, action_total_cost_stone, user_num, action_cost_num, take_part_rate, first_cost_stone_rate, cur_user_num_rate]
# print("row: "+str(row))
table_result.append(row)
return table_result
def _get_day_distance_result(desc, recharge_log, first_recharge_log, from_day, to_day=99999):
"""
获取行数据
"""
#获取 第N天就充值的玩家UID列表
days_recharge_log_lst = daily_log_dat.filter_logs(recharge_log, function=lambda log: from_day <= (log['log_time'].date() - log['install']).days < to_day)
days_first_recharge_log_lst = daily_log_dat.filter_logs(first_recharge_log, function=lambda log: from_day <= (log['log_time'].date() - log['install']).days < to_day)
# 获取人数
total_user_num = daily_log_dat.get_set_num_with_key(days_recharge_log_lst, 'uid')
first_total_user_num = daily_log_dat.get_set_num_with_key(days_first_recharge_log_lst, 'uid')
# 获取充值总金额
total_money = daily_log_dat.get_sum_int_with_key(days_recharge_log_lst, 'add_rmb')
first_total_money = daily_log_dat.get_sum_int_with_key(days_first_recharge_log_lst, 'add_rmb')
# 获取比率
money_rate = _get_money_rate(first_total_money, total_money)
user_rate = _get_user_rate(first_total_user_num, total_user_num)
return [desc, first_total_user_num, first_total_money, total_user_num, total_money, money_rate, user_rate]
def get_table(search_start_date, search_end_date, channel_id=-1, server_id=-1):
# 搜索日期到今天的所有日志
retained_day = search_start_date - datetime.timedelta(days=4)
all_log_lst = daily_log_dat.get_new_log_lst(retained_day, search_end_date)
if channel_id >= 0:
all_log_lst = daily_log_dat.filter_logs(
all_log_lst, function=lambda x: x['platform_id'] == channel_id)
if server_id >= 0:
all_log_lst = daily_log_dat.filter_logs(
all_log_lst, function=lambda x: x['server_id'] == server_id)
#获取所有登录事件
all_login_lst = daily_log_dat.filter_logs(
all_log_lst, action=game_define.EVENT_ACTION_ROLE_LOGIN)
# 获取日期数
search_days = (search_end_date - search_start_date).days
table_result = []
for i in xrange(search_days + 1):
cur_date = search_start_date + datetime.timedelta(days=i)
# 今日全部日志
today_login_lst = daily_log_dat.get_new_log_lst_with_log(
all_login_lst, cur_date, cur_date)
# 获取登录日志列表
today_login_uid_lst = daily_log_dat.get_set_with_key(
today_login_lst, 'uid')
today_new_user_login_lst = daily_log_dat.filter_logs(
today_login_lst, function=lambda log: log['install'] == cur_date)
today_new_user_uid_num = daily_log_dat.get_set_num_with_key(
today_new_user_login_lst, 'uid')
# 登录用户数
today_login_uid_num = len(today_login_uid_lst)
# 活跃用户数
today_active_uid_num = today_new_user_uid_num
# 流失用户（3天内没登录）
today_lost_uid_num = len(
daily_log_dat.get_lost_user_set(all_login_lst, cur_date))
# 回流用户（3天内没登录 但今天登录）
login_back_num = len(
daily_log_dat.get_lost_back_user_set(all_login_lst, cur_date))
row = [
cur_date.strftime("%m/%d/%Y"), today_login_uid_num,
today_active_uid_num, today_lost_uid_num, login_back_num
]
table_result.append(row)
return table_result
def get_table(search_date, channel_id=-1, server_id=-1):
new_log_lst = daily_log_dat.get_new_log_lst(search_date, search_date)
if channel_id >= 0:
new_log_lst = daily_log_dat.filter_logs(
new_log_lst, function=lambda x: x['platform_id'] == channel_id)
if server_id >= 0:
new_log_lst = daily_log_dat.filter_logs(
new_log_lst, function=lambda x: x['server_id'] == server_id)
#获取全部新手引导日志
all_guide_log_lst = daily_log_dat.filter_logs(
new_log_lst, action=game_define.EVENT_ACTION_FINISH_GUIDE)
# 总共5个引导步骤 （1-6）
total_user = daily_log_dat.get_set_num_with_key(all_guide_log_lst, 'uid')
complete_user_dict = dict()
guide_name = [
u'宠物升级', u'宠物突破', u'宠物进化', u'宠物技能', u'宠物洗练', u'宠物装备', u'新队伍位置'
]
for i in xrange(1, 8):
# 当前引导的所有日志
guide_index_log_lst = daily_log_dat.filter_logs(
all_guide_log_lst, function=lambda x: x['guide_id'] == i)
complete_user_num = daily_log_dat.get_set_num_with_key(
guide_index_log_lst, 'uid')
complete_user_dict[i] = complete_user_num
table_result = []
for i in xrange(1, 8):
next_num = complete_user_dict.get(i + 1, 0)
row = [
i,
guide_name[i - 1],
complete_user_dict[i], # 完成人数
]
table_result.append(row)
return table_result
def _get_day_distance_result(desc,
recharge_log,
first_recharge_log,
from_day,
to_day=99999):
"""
获取行数据
"""
#获取 第N天就充值的玩家UID列表
days_recharge_log_lst = daily_log_dat.filter_logs(
recharge_log,
function=lambda log: from_day <=
(log['log_time'].date() - log['install']).days < to_day)
days_first_recharge_log_lst = daily_log_dat.filter_logs(
first_recharge_log,
function=lambda log: from_day <=
(log['log_time'].date() - log['install']).days < to_day)
# 获取人数
total_user_num = daily_log_dat.get_set_num_with_key(
days_recharge_log_lst, 'uid')
first_total_user_num = daily_log_dat.get_set_num_with_key(
days_first_recharge_log_lst, 'uid')
# 获取充值总金额
total_money = daily_log_dat.get_sum_int_with_key(days_recharge_log_lst,
'add_rmb')
first_total_money = daily_log_dat.get_sum_int_with_key(
days_first_recharge_log_lst, 'add_rmb')
# 获取比率
money_rate = _get_money_rate(first_total_money, total_money)
user_rate = _get_user_rate(first_total_user_num, total_user_num)
return [
desc, first_total_user_num, first_total_money, total_user_num,
total_money, money_rate, user_rate
]
def get_table(search_start_date, search_end_date, channel_id=-1, server_id=-1):
# 搜索日期到今天的所有日志
retained_day = search_start_date - datetime.timedelta(days=4)
all_log_lst = daily_log_dat.get_new_log_lst(retained_day, search_end_date)
if channel_id >= 0:
all_log_lst = daily_log_dat.filter_logs(all_log_lst, function=lambda x: x["platform_id"] == channel_id)
if server_id >= 0:
all_log_lst = daily_log_dat.filter_logs(all_log_lst, function=lambda x: x["server_id"] == server_id)
# 获取所有登录事件
all_login_lst = daily_log_dat.filter_logs(all_log_lst, action=game_define.EVENT_ACTION_ROLE_LOGIN)
# 获取日期数
search_days = (search_end_date - search_start_date).days
table_result = []
for i in xrange(search_days + 1):
cur_date = search_start_date + datetime.timedelta(days=i)
# 今日全部日志
today_login_lst = daily_log_dat.get_new_log_lst_with_log(all_login_lst, cur_date, cur_date)
# 获取登录日志列表
today_login_uid_lst = daily_log_dat.get_set_with_key(today_login_lst, "uid")
today_new_user_login_lst = daily_log_dat.filter_logs(
today_login_lst, function=lambda log: log["install"] == cur_date
)
today_new_user_uid_num = daily_log_dat.get_set_num_with_key(today_new_user_login_lst, "uid")
# 登录用户数
today_login_uid_num = len(today_login_uid_lst)
# 活跃用户数
today_active_uid_num = today_new_user_uid_num
# 流失用户（3天内没登录）
today_lost_uid_num = len(daily_log_dat.get_lost_user_set(all_login_lst, cur_date))
# 回流用户（3天内没登录 但今天登录）
login_back_num = len(daily_log_dat.get_lost_back_user_set(all_login_lst, cur_date))
row = [
cur_date.strftime("%m/%d/%Y"),
today_login_uid_num,
today_active_uid_num,
today_lost_uid_num,
login_back_num,
]
table_result.append(row)
return table_result
def get_table(search_start_date,
search_end_date,
channel_id=-1,
server_id=-1,
player_min_level=1,
player_max_level=999):
# 获取搜索区间日志
new_log_lst = daily_log_dat.get_new_log_lst(search_start_date,
search_end_date)
if channel_id >= 0:
new_log_lst = daily_log_dat.filter_logs(
new_log_lst, function=lambda x: x['platform_id'] == channel_id)
if server_id >= 0:
new_log_lst = daily_log_dat.filter_logs(
new_log_lst, function=lambda x: x['server_id'] == server_id)
# 适配等级
new_log_lst = daily_log_dat.filter_logs(
new_log_lst,
function=lambda x: player_min_level <= x['level'] <= player_max_level)
# 获取用户表
# uid_lst = daily_log_dat.get_set_with_key(new_log_lst, 'uid')
search_days = (search_end_date - search_start_date).days
table_lst = []
for _day in xrange(search_days + 1):
row_date = search_start_date + datetime.timedelta(days=_day)
row_logs = daily_log_dat.filter_logs(
new_log_lst,
function=lambda log: log['log_time'].date() == row_date)
#拆分玩家金币日志
user_key_dict = daily_log_dat.split_log_users_last_stone(row_logs)
# 获取玩家总金币数
total_stone = sum([val for val in user_key_dict.values()])
total_user = len(user_key_dict)
active_user = daily_log_dat.get_set_num_with_key(
row_logs, 'uid', function=lambda log: log['install'] != row_date)
row_lst = [
row_date.strftime('%m/%d/%Y'), total_stone, total_user, active_user
]
table_lst.append(row_lst)
return table_lst
def get_table(search_date, server_id):
# 搜索日期到今天的所有日志
retained_day = search_date - datetime.timedelta(days=4)
all_login_lst = []
total_days = (search_date - retained_day).days + 1
for i in xrange(total_days):
search_date = retained_day + datetime.timedelta(days=i)
date_str = "_" + search_date.strftime('%Y%m%d')
login_lst = mysql_util.get_role_action_lst(
'EVENT_ACTION_ROLE_LOGIN' + str(date_str), search_date,
search_date, -1, server_id, None, None)
all_login_lst.extend(login_lst)
table_result = []
cur_date = search_date
# 今日全部日志
today_login_lst = daily_log_dat.get_new_log_lst_with_log(
all_login_lst, cur_date, cur_date)
# 获取登录日志列表
today_login_uid_lst = daily_log_dat.get_set_with_key(
today_login_lst, 'uid')
today_new_user_login_lst = daily_log_dat.filter_logs(
today_login_lst, function=lambda log: log['install'] == cur_date)
today_new_user_uid_num = daily_log_dat.get_set_num_with_key(
today_new_user_login_lst, 'uid')
# 登录用户数
today_login_uid_num = len(today_login_uid_lst)
# 活跃用户数
today_active_uid_num = today_new_user_uid_num
# 流失用户（3天内没登录）
today_lost_uid_num = len(
daily_log_dat.get_lost_user_set(all_login_lst, cur_date))
# 回流用户（3天内没登录 但今天登录）
login_back_num = len(
daily_log_dat.get_lost_back_user_set(all_login_lst, cur_date))
row = [
cur_date.strftime("%m/%d/%Y"), today_login_uid_num,
today_active_uid_num, today_lost_uid_num, login_back_num
]
table_result.append(row)
return table_result
def get_table(search_date, server_id):
# 搜索日期到今天的所有日志
retained_day = search_date - datetime.timedelta(days=4)
all_login_lst = []
total_days = (search_date - retained_day).days + 1
for i in xrange(total_days):
search_date = retained_day + datetime.timedelta(days=i)
date_str = "_" + search_date.strftime("%Y%m%d")
login_lst = mysql_util.get_role_action_lst(
"EVENT_ACTION_ROLE_LOGIN" + str(date_str), search_date, search_date, -1, server_id, None, None
)
all_login_lst.extend(login_lst)
table_result = []
cur_date = search_date
# 今日全部日志
today_login_lst = daily_log_dat.get_new_log_lst_with_log(all_login_lst, cur_date, cur_date)
# 获取登录日志列表
today_login_uid_lst = daily_log_dat.get_set_with_key(today_login_lst, "uid")
today_new_user_login_lst = daily_log_dat.filter_logs(
today_login_lst, function=lambda log: log["install"] == cur_date
)
today_new_user_uid_num = daily_log_dat.get_set_num_with_key(today_new_user_login_lst, "uid")
# 登录用户数
today_login_uid_num = len(today_login_uid_lst)
# 活跃用户数
today_active_uid_num = today_new_user_uid_num
# 流失用户（3天内没登录）
today_lost_uid_num = len(daily_log_dat.get_lost_user_set(all_login_lst, cur_date))
# 回流用户（3天内没登录 但今天登录）
login_back_num = len(daily_log_dat.get_lost_back_user_set(all_login_lst, cur_date))
row = [cur_date.strftime("%m/%d/%Y"), today_login_uid_num, today_active_uid_num, today_lost_uid_num, login_back_num]
table_result.append(row)
return table_result
def get_table(search_start_date,
search_end_date,
channel_id=-1,
server_id=-1,
player_min_level=1,
player_max_level=999):
# 获取搜索区间日志
search_log_lst = daily_log_dat.get_new_log_lst(search_start_date,
search_end_date)
if channel_id >= 0:
search_log_lst = daily_log_dat.filter_logs(
search_log_lst, function=lambda x: x['platform_id'] == channel_id)
if server_id >= 0:
search_log_lst = daily_log_dat.filter_logs(
search_log_lst, function=lambda x: x['server_id'] == server_id)
# 适配等级
search_log_lst = daily_log_dat.filter_logs(
search_log_lst,
function=lambda x: player_min_level <= x['level'] <= player_max_level)
# 所有的消耗钻石的日志
all_cost_stone_log_lst = daily_log_dat.filter_logs(
search_log_lst, function=lambda log: 'cost_stone' in log)
# 根据事件拆分消耗日志
action_cost_stone_dict = daily_log_dat.split_log_action_logs(
all_cost_stone_log_lst)
table_lst = []
# 遍历所有事件
for _action, _logs in action_cost_stone_dict.items():
row_lst = []
# 事件名称
action_name = game_define.EVENT_LOG_ACTION_DICT[_action]
# 充值用户消耗的部分日志
vip1_up_user_log = daily_log_dat.filter_logs(
_logs, function=lambda log: log['vip_level'] != 0)
# 非充值用户的部分日志
vip0_user_log = daily_log_dat.filter_logs(
_logs, function=lambda log: log['vip_level'] == 0)
# 充值用户消耗人数
recharge_user_num = daily_log_dat.get_set_num_with_key(
vip1_up_user_log, 'uid')
# 充值用户消耗次数
recharge_user_log_num = len(vip1_up_user_log)
# 非充值用户的人数
vip0_user_num = daily_log_dat.get_set_num_with_key(
vip0_user_log, 'uid')
# 非充值用户消耗次数
vip0_user_log_num = len(vip0_user_log)
# vip0 消耗钻石
vip0_cost_stone_num = daily_log_dat.get_sum_int_with_key(
vip0_user_log, 'cost_stone')
# 消耗钻石数量
total_cost_stone_num = daily_log_dat.get_sum_int_with_key(
_logs, 'cost_stone')
#事件名称 充值用户消耗人数 充值用户消耗次数 非充值用户消耗人数 非充值用户消耗次数 消耗钻石数量 VIP0消耗金额 VIP0消耗人数
row_lst = [
action_name, recharge_user_num, recharge_user_log_num,
vip0_user_num, vip0_user_log_num, total_cost_stone_num,
vip0_cost_stone_num, vip0_user_num
]
# 遍历VIP
for i in xrange(1, 13):
vip_x_log = daily_log_dat.filter_logs(
vip1_up_user_log, function=lambda log: log['vip_level'] == i)
vip_x_cost_stone_num = daily_log_dat.get_sum_int_with_key(
vip_x_log, 'cost_stone')
vip_x_cost_stone_user_num = daily_log_dat.get_set_num_with_key(
vip_x_log, 'uid')
row_lst.append(vip_x_cost_stone_num)
row_lst.append(vip_x_cost_stone_user_num)
table_lst.append(row_lst)
return table_lst
def get_table(register_star_date, register_end_date, channel_id=-1, server_id=-1):
"""
新增K日收益统计
"""
# 搜索日期到今天的所有日志
all_log_lst = daily_log_dat.get_new_log_lst(register_star_date, datetime.date.today())
if channel_id >= 0:
all_log_lst = daily_log_dat.filter_logs(all_log_lst, function=lambda x: x['platform_id'] == channel_id)
if server_id >= 0:
all_log_lst = daily_log_dat.filter_logs(all_log_lst, function=lambda x: x['server_id'] == server_id)
# 全部充值日志
all_recharge_log_lst = daily_log_dat.filter_logs(all_log_lst, action=game_define.EVENT_ACTION_RECHARGE_PLAYER)
row_days = (register_end_date - register_star_date).days
table_lst = []
for _day in xrange(row_days):
row_date = register_star_date + datetime.timedelta(days=_day)
# 获取新用户
row_new_user_uid_lst = daily_log_dat.get_set_with_key(all_log_lst, 'uid',action=game_define.EVENT_ACTION_ROLE_LOGIN, function=lambda log:log['install'] == row_date)
# 获取新增设备
new_device_num = daily_log_dat.get_set_num_with_key(all_log_lst, 'dev_id',action=game_define.EVENT_ACTION_ROLE_LOGIN, function=lambda log:log['install'] == row_date)
# 获取充值总额
recharge_date = row_date + datetime.timedelta(days=1)
total_rmb_1 = daily_log_dat.get_sum_int_with_key(all_recharge_log_lst, 'add_rmb', function=lambda log:log['log_time'].date() == recharge_date and log['uid'] in row_new_user_uid_lst)
recharge_date = row_date + datetime.timedelta(days=2)
total_rmb_2 = daily_log_dat.get_sum_int_with_key(all_recharge_log_lst, 'add_rmb', function=lambda log:log['log_time'].date() == recharge_date and log['uid'] in row_new_user_uid_lst)
recharge_date = row_date + datetime.timedelta(days=3)
total_rmb_3 = daily_log_dat.get_sum_int_with_key(all_recharge_log_lst, 'add_rmb', function=lambda log:log['log_time'].date() == recharge_date and log['uid'] in row_new_user_uid_lst)
recharge_date = row_date + datetime.timedelta(days=4)
total_rmb_4 = daily_log_dat.get_sum_int_with_key(all_recharge_log_lst, 'add_rmb', function=lambda log:log['log_time'].date() == recharge_date and log['uid'] in row_new_user_uid_lst)
recharge_date = row_date + datetime.timedelta(days=5)
total_rmb_5 = daily_log_dat.get_sum_int_with_key(all_recharge_log_lst, 'add_rmb', function=lambda log:log['log_time'].date() == recharge_date and log['uid'] in row_new_user_uid_lst)
recharge_date = row_date + datetime.timedelta(days=6)
total_rmb_6 = daily_log_dat.get_sum_int_with_key(all_recharge_log_lst, 'add_rmb', function=lambda log:log['log_time'].date() == recharge_date and log['uid'] in row_new_user_uid_lst)
recharge_date_7 = row_date + datetime.timedelta(days=7)
total_rmb_7 = daily_log_dat.get_sum_int_with_key(all_recharge_log_lst, 'add_rmb', function=lambda log:log['log_time'].date() == recharge_date_7 and log['uid'] in row_new_user_uid_lst)
recharge_date_15 = row_date + datetime.timedelta(days=15)
total_rmb_7_15 = daily_log_dat.get_sum_int_with_key(all_recharge_log_lst, 'add_rmb', function=lambda log:recharge_date_7 < log['log_time'].date() <= recharge_date_15 and log['uid'] in row_new_user_uid_lst)
recharge_date_30 = row_date + datetime.timedelta(days=30)
total_rmb_15_30 = daily_log_dat.get_sum_int_with_key(all_recharge_log_lst, 'add_rmb', function=lambda log:recharge_date_15 < log['log_time'].date() <= recharge_date_30 and log['uid'] in row_new_user_uid_lst)
total_rmb_30_up = daily_log_dat.get_sum_int_with_key(all_recharge_log_lst, 'add_rmb', function=lambda log:recharge_date_30 < log['log_time'].date() and log['uid'] in row_new_user_uid_lst)
row = []
row.append(row_date.strftime('%Y-%m-%d'))
row.append(new_device_num)
row.append(total_rmb_1)
row.append(total_rmb_2)
row.append(total_rmb_3)
row.append(total_rmb_4)
row.append(total_rmb_5)
row.append(total_rmb_6)
row.append(total_rmb_7)
row.append(total_rmb_7_15)
row.append(total_rmb_15_30)
row.append(total_rmb_30_up)
table_lst.append(row)
return table_lst
def get_table(search_start_date, search_end_date, register_start_date=None, register_end_date=None, channel_id=-1, server_id=-1):
"""
获取展示表格
register_start_date 注册开始时间
register_end_date 注册结束时间
search_start_date 查询开始时间
search_end_date 查询结束时间
"""
new_log_lst = daily_log_dat.get_new_log_lst(search_start_date, search_end_date)
if channel_id >= 0:
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda x: x['platform_id'] == channel_id)
if server_id >= 0:
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda x: x['server_id'] == server_id)
#获取符合条件的日志
if register_start_date and register_end_date:
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda log: register_start_date <= log['install'] <= register_end_date)
# print("new_log_lst111: "+str(new_log_lst))
# 全部钻石商城物品购买日志
all_stone_shop_log_lst = daily_log_dat.filter_logs(new_log_lst, action=game_define.EVENT_ACTION_STONE_SHOP_BUY)
# print("all_stone_shop_log_lst: "+str(all_stone_shop_log_lst))
# 获取所有钻石商城物品玩家设备
device_lst = daily_log_dat.get_set_with_key(all_stone_shop_log_lst, 'dev_id')
# 获取所有钻石商城物品购买日志玩家UID
all_uid_lst = daily_log_dat.get_set_with_key(all_stone_shop_log_lst, 'uid')
# 消耗钻石总数
total_cost_stone = daily_log_dat.get_sum_int_with_key(all_stone_shop_log_lst, 'cost_stone')
# 根据ID拆分日志
item_logs_dict = dict()
for _log in all_stone_shop_log_lst:
_item_info = _log['add_item_list']
_item_tid = _item_info[0]
if _item_tid in item_logs_dict:
item_logs_dict[_item_tid].append(_log)
else:
lst = [_log]
item_logs_dict[_item_tid] = lst
table_lst = []
for _item_tid, _log in item_logs_dict.items():
user_num = daily_log_dat.get_set_num_with_key(_log, 'uid')
# 购买物品
# item_config = game_config.get_item_config(int(_item_tid))
event_log_act = _item_tid
# 钻石数
cost_stone = daily_log_dat.get_sum_int_with_key(_log, 'cost_stone')
# 次数
cost_num = len(_log)
# 参与率
take_part_rate = _get_rate(user_num, len(device_lst))
# 钻石比率
first_cost_stone_rate = _get_rate(cost_stone, total_cost_stone)
# 人数比率
cur_user_num_rate = _get_rate(user_num, len(all_uid_lst))
row = [event_log_act, cost_stone, user_num, cost_num, take_part_rate, first_cost_stone_rate, cur_user_num_rate]
table_lst.append(row)
return table_lst
def get_table(search_start_date, search_end_date, channel_id=-1, server_id=-1):
"""
获取统计总表
search_start_date 查询开始时间
search_end_date 查询结束时间
"""
start_log_time = datetime.datetime.strptime(game_define.LOCAL_LOG_START_DATE, '%Y-%m-%d').date()
# 获取搜索区间日志
new_log_lst = daily_log_dat.get_new_log_lst(search_start_date, search_end_date)
if channel_id >= 0:
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda x: x['platform_id'] == channel_id)
if server_id >= 0:
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda x: x['server_id'] == server_id)
# pay_code_log_lst = daily_log_dat.filter_logs(new_log_lst, action=game_define.EVENT_ACTION_RECHARGE_PLAYER)
# pay_code_res = dict()
# for log in pay_code_log_lst:
# plat = game_define.PLAT_FORM_NAME_DICT[log['platform_id']]
# if plat in pay_code_res:
# pay_code_res[plat].append(log['order_id'])
# else:
# pay_code_res[plat] = [log['order_id']]
# print("订单 " + str(pay_code_res))
# 总天数
table_lst = []
total_days = (search_end_date - search_start_date).days + 1
for i in xrange(total_days):
row_lst = []
# 每行的日期
row_date = search_start_date + datetime.timedelta(days=i)
row_yesterday_date = row_date - datetime.timedelta(days=1)
# print("-------------------------------"+str(row_date)+"---------------------------------------------")
# 获取到昨天的全部日志
until_yesterday_all_log_lst = daily_log_dat.get_new_log_lst(start_log_time, row_yesterday_date)
# # 获取上一天开始的所有设备数
until_yesterday_all_device = daily_log_dat.get_set_with_key(until_yesterday_all_log_lst, 'dev_id')
# # 到昨天为止登录用户数
# # yesterday_all_user_num = daily_log_dat.get_set_num_with_key(yesterday_all_log_lst, 'uid')
# # # 到昨天为止的登录账户
# # yesterday_all_account_num = daily_log_dat.get_set_num_with_key(yesterday_all_log_lst, 'account_id')
# # # 到昨天为止充值人数
# # yesterday_all_recharge_user_num = daily_log_dat.get_set_num_with_key(yesterday_all_log_lst, 'uid', game_define.EVENT_ACTION_RECHARGE_PLAYER)
#
# # 获取到今天的所有日志
# until_today_all_log_lst = daily_log_dat.get_new_log_lst(start_log_time, row_date)
# # 到今天为止所有设备数
# until_today_all_device_num = daily_log_dat.get_set_num_with_key(until_today_all_log_lst, 'dev_id')
# # # 到今天为止的登录用户数
# # today_all_user_num = daily_log_dat.get_set_num_with_key(today_all_log_lst, 'uid')
# # # 到今天为止的登录账户
# # today_all_account_num = daily_log_dat.get_set_num_with_key(today_all_log_lst, 'account_id')
# # # 到今天为止充值人数
# # # today_all_recharge_user_num = daily_log_dat.get_set_num_with_key(today_all_log_lst, 'uid', game_define.EVENT_ACTION_RECHARGE_PLAYER)
# 今天的日志
today_log_lst = daily_log_dat.get_new_log_lst_with_log(new_log_lst, row_date, row_date)
# 今天登录设备数
today_device_num = daily_log_dat.get_set_num_with_key(today_log_lst, 'dev_id')
# 今天的登录用户数
today_user_num = daily_log_dat.get_set_num_with_key(today_log_lst, 'uid')
# 今天新增用户数
today_new_user_num = daily_log_dat.get_set_num_with_key(today_log_lst, 'uid', function=lambda log:log['install'] == row_date)
#新设备数
today_new_device_num = daily_log_dat.get_set_num_with_key(today_log_lst, 'dev_id', action=game_define.EVENT_ACTION_ROLE_LOGIN, function=lambda log:log['dev_id'] not in until_yesterday_all_device)
# 新账户数
today_new_account_num = daily_log_dat.get_set_num_with_key(today_log_lst, 'account_id', action=game_define.EVENT_ACTION_ROLE_LOGIN, function=lambda log:log['install'] == row_date)
# 今天的登录账户
today_account_num = daily_log_dat.get_set_num_with_key(today_log_lst, 'account_id')
# 今天充值人数
today_recharge_user_num = daily_log_dat.get_set_num_with_key(today_log_lst, 'uid', game_define.EVENT_ACTION_RECHARGE_PLAYER)
# 今天新增充值人数
today_new_recharge_user_num = daily_log_dat.get_set_num_with_key(today_log_lst, 'uid', game_define.EVENT_ACTION_RECHARGE_PLAYER, lambda log:log['cur_rmb']== log['add_rmb'])
# 充值金额
today_recharge_rmb = daily_log_dat.get_sum_int_with_key(today_log_lst, 'add_rmb', game_define.EVENT_ACTION_RECHARGE_PLAYER)
# 新增充值金额
today_new_recharge_rmb = daily_log_dat.get_sum_int_with_key(today_log_lst, 'add_rmb', game_define.EVENT_ACTION_RECHARGE_PLAYER, lambda log:log['cur_rmb']== log['add_rmb'])
# 今天登录事件次数
today_login_action_num = daily_log_dat.get_list_num_with_key(today_log_lst, 'uid', game_define.EVENT_ACTION_ROLE_LOGIN)
# 活跃设备数
today_active_device_num = today_device_num - today_new_device_num
# 活跃用户数
today_active_user_num = today_user_num - today_new_user_num
# 登录用户数
today_login_user_num = today_user_num
# 登录设备数
today_login_device_num = today_device_num
# 活跃账户数
today_active_account_num = today_account_num - today_new_account_num
# print("-------------------------------"+str(row_date)+"---------------------------------------------")
# print("充值玩家 " + str(daily_log_dat.get_set_with_key(today_log_lst, 'uid', game_define.EVENT_ACTION_RECHARGE_PLAYER)))
# print("新增充值玩家 " + str(daily_log_dat.get_set_with_key(today_log_lst, 'uid', game_define.EVENT_ACTION_RECHARGE_PLAYER, lambda log:log['cur_rmb']== log['add_rmb'])))
# print("充值金额列表 " + str(daily_log_dat.get_list_with_key(today_log_lst, 'add_rmb', game_define.EVENT_ACTION_RECHARGE_PLAYER)))
# print("新增充值金额列表 " + str(daily_log_dat.get_list_with_key(today_log_lst, 'add_rmb', game_define.EVENT_ACTION_RECHARGE_PLAYER, lambda log:log['cur_rmb']== log['add_rmb'])))
# 付费率=充值人数/登录设备
pay_rate = Division(today_recharge_user_num, today_login_device_num)
# 付费arppu 充值金额/充值人数
pay_arppu = Division(today_recharge_rmb, today_recharge_user_num)
# 登录arpu 充值金额/登陆设备
login_arpu = Division(today_recharge_rmb, today_login_device_num)
# 半小时精度在线人数列表
online_user_num_lst = daily_log_dat.get_online_user_len_lst(row_date, today_log_lst)
# 平均在线人数 acu
acu = _get_acu(online_user_num_lst)
# 最高在线人数
pcu = _get_pcu(online_user_num_lst)
# 平均在线时长
avg_online_time = _get_avg_online_time(online_user_num_lst, today_login_user_num)
# 人均登入次数
avg_login_count = _get_avg_login_count(today_login_action_num, today_login_user_num)
# 获取玩家安装游戏日期
install_date = row_date - datetime.timedelta(days=1)
retained_1_num = daily_log_dat.get_set_num_with_key(today_log_lst, 'uid', game_define.EVENT_ACTION_ROLE_LOGIN, lambda log:log['install'] == install_date)
install_date = row_date - datetime.timedelta(days=3)
retained_3_num = daily_log_dat.get_set_num_with_key(today_log_lst, 'uid', game_define.EVENT_ACTION_ROLE_LOGIN, lambda log:log['install'] == install_date)
install_date = row_date - datetime.timedelta(days=7)
retained_7_num = daily_log_dat.get_set_num_with_key(today_log_lst, 'uid', game_define.EVENT_ACTION_ROLE_LOGIN, lambda log:log['install'] == install_date)
install_date = row_date - datetime.timedelta(days=15)
retained_15_num = daily_log_dat.get_set_num_with_key(today_log_lst, 'uid', game_define.EVENT_ACTION_ROLE_LOGIN, lambda log:log['install'] == install_date)
install_date = row_date - datetime.timedelta(days=30)
retained_30_num = daily_log_dat.get_set_num_with_key(today_log_lst, 'uid', game_define.EVENT_ACTION_ROLE_LOGIN, lambda log:log['install'] == install_date)
row_lst.append(row_date.strftime('%Y-%m-%d'))
row_lst.append(today_active_device_num)
row_lst.append(today_active_user_num)
row_lst.append(today_new_device_num)
row_lst.append(today_new_user_num)
row_lst.append(today_login_device_num)
row_lst.append(today_login_user_num)
row_lst.append(today_active_account_num)
row_lst.append(today_new_account_num)
row_lst.append(today_recharge_user_num)
row_lst.append(today_new_recharge_user_num)
row_lst.append(today_recharge_rmb)
row_lst.append(today_new_recharge_rmb)
row_lst.append(pay_rate)
row_lst.append(pay_arppu)
row_lst.append(login_arpu)
row_lst.append(acu)
row_lst.append(pcu)
row_lst.append(avg_online_time)
row_lst.append(avg_login_count)
row_lst.append(retained_1_num)
row_lst.append(retained_3_num)
row_lst.append(retained_7_num)
row_lst.append(retained_15_num)
row_lst.append(retained_30_num)
table_lst.append(row_lst)
# print("table_lst " + str(table_lst))
return table_lst
def get_cost_stone_table(search_start_date,
search_end_date,
register_start_date=None,
register_end_date=None,
channel_id=-1,
server_id=-1):
"""
获取展示表格
register_start_date 注册开始时间
register_end_date 注册结束时间
search_start_date 查询开始时间
search_end_date 查询结束时间
"""
# 获取搜索区间日志
search_log_lst = daily_log_dat.get_new_log_lst(search_start_date,
search_end_date)
if channel_id >= 0:
search_log_lst = daily_log_dat.filter_logs(
search_log_lst, function=lambda x: x['platform_id'] == channel_id)
if server_id >= 0:
search_log_lst = daily_log_dat.filter_logs(
search_log_lst, function=lambda x: x['server_id'] == server_id)
#获取符合条件的日志
if register_start_date and register_end_date:
search_log_lst = daily_log_dat.filter_logs(
search_log_lst,
function=lambda log: register_start_date <= log[
'install'] <= register_end_date)
table_lst = []
# 全部消耗钻石日志
all_login_log_lst = daily_log_dat.filter_logs(
search_log_lst, action=game_define.EVENT_ACTION_ROLE_LOGIN)
all_cost_stone_log_lst = daily_log_dat.filter_logs(
search_log_lst, function=lambda log: 'cost_stone' in log)
# 获取所有消耗钻石玩家UID
uid_num = daily_log_dat.get_set_num_with_key(all_cost_stone_log_lst, 'uid')
# 获取所有消耗钻石玩家设备lst
device_num = daily_log_dat.get_set_num_with_key(all_login_log_lst,
'dev_id')
# 消耗钻石总数
total_cost_stone = daily_log_dat.get_sum_int_with_key(
all_cost_stone_log_lst, 'cost_stone')
# 根据ID拆分日志
action_logs_dict = dict()
for _log in all_cost_stone_log_lst:
_action = _log['action']
if _action in action_logs_dict:
action_logs_dict[_action].append(_log)
else:
lst = [_log]
action_logs_dict[_action] = lst
for _action, _logs in action_logs_dict.items():
user_num = daily_log_dat.get_set_num_with_key(_logs, 'uid')
action_total_cost_stone = daily_log_dat.get_sum_int_with_key(
_logs, 'cost_stone')
action_name = game_define.EVENT_LOG_ACTION_DICT[_action]
action_cost_num = len(_logs)
# 参与率
# print("参与率 " + str(user_num) + " " + str(device_num))
take_part_rate = str(_get_rate(user_num, device_num)) + "%"
# 人数比率
# print("人数比率 " + str(user_num) + " " + str(uid_num))
cur_user_num_rate = str(_get_rate(user_num, uid_num)) + "%"
# 钻石比率
first_cost_stone_rate = str(
_get_rate(action_total_cost_stone, total_cost_stone)) + "%"
row = [
action_name, action_total_cost_stone, user_num, action_cost_num,
take_part_rate, first_cost_stone_rate, cur_user_num_rate
]
table_lst.append(row)
return table_lst
def get_table(search_start_date, search_end_date, channel_id=-1, server_id=-1):
"""
获取展示表格
register_start_date 注册开始时间
register_end_date 注册结束时间
search_start_date 查询开始时间
search_end_date 查询结束时间
"""
# 获取搜索区间日志
new_log_lst = daily_log_dat.get_new_log_lst(search_start_date, search_end_date)
if channel_id >= 0:
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda x: x['platform_id'] == channel_id)
if server_id >= 0:
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda x: x['server_id'] == server_id)
new_user_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda log: search_start_date <= log['install'] <= search_end_date)
# 新用户数量
new_user_num = daily_log_dat.get_set_num_with_key(new_user_log_lst, 'uid')
# 获取首冲日志列表
first_recharge_log_lst = daily_log_dat.filter_logs(new_log_lst, action=game_define.EVENT_ACTION_RECHARGE_PLAYER, function=lambda log: log['old_rmb'] == 0)
first_recharge_uid_lst = daily_log_dat.get_set_with_key(first_recharge_log_lst, 'uid')
# 新用户首冲
new_user_first_recharge_log_lst = daily_log_dat.filter_logs(new_user_log_lst, action=game_define.EVENT_ACTION_RECHARGE_PLAYER, function=lambda log: log['old_rmb'] == 0)
new_user_first_recharge_uid_lst = daily_log_dat.get_set_with_key(new_user_first_recharge_log_lst, 'uid')
# 获取所有登录日志
all_login_log_lst = daily_log_dat.filter_logs(new_log_lst, action=game_define.EVENT_ACTION_ROLE_LOGIN)
all_login_uid_lst = daily_log_dat.get_set_with_key(all_login_log_lst, 'uid')
# 新用户登录日志
all_new_user_login_log_lst = daily_log_dat.filter_logs(new_user_log_lst, action=game_define.EVENT_ACTION_ROLE_LOGIN)
all_new_user_login_uid_lst = daily_log_dat.get_set_with_key(all_new_user_login_log_lst, 'uid')
# 获取用户的所有VIP字典
uid_vip_dict = dict()
uid_month_days_dict = dict()
new_user_uid_vip_dict = dict()
new_user_uid_month_days_dict = dict()
for _uid in all_login_uid_lst:
_vip_lv = daily_log_dat.get_max_int_with_key(all_login_log_lst, 'vip_level', function=lambda log: log['uid'] == _uid)
_month_card_days = daily_log_dat.get_max_int_with_key(all_login_log_lst, 'month_card_days', function=lambda log: log['uid'] == _uid)
uid_vip_dict[_uid] = _vip_lv
uid_month_days_dict[_uid] = _month_card_days
if _uid in all_new_user_login_uid_lst:
new_user_uid_vip_dict[_uid] = _vip_lv
new_user_uid_month_days_dict[_uid] = _month_card_days
table_lst = []
# 首冲人数
first_recharge_uid_num = len(first_recharge_uid_lst)
month_card_num = get_month_user_num(uid_month_days_dict)
vip_lst = []
for vip in xrange(13):
vip_num = get_vip_user_num(uid_vip_dict, vip)
vip_lst.append(vip_num)
row = ['总体', first_recharge_uid_num, month_card_num]
row.extend(vip_lst)
table_lst.append(row)
# 新增部分数据
new_user_first_recharge_uid_num = len(new_user_first_recharge_uid_lst)
new_user_month_card_num = get_month_user_num(new_user_uid_month_days_dict)
new_vip_lst = []
for vip in xrange(13):
vip_num = get_vip_user_num(new_user_uid_vip_dict, vip)
new_vip_lst.append(vip_num)
new_row = ['新增',new_user_first_recharge_uid_num, new_user_month_card_num]
new_row.extend(new_vip_lst)
table_lst.append(new_row)
# 区间新增用户数
new_user_num_row = ['新增角色数']
new_user_num_row.extend([new_user_num] * 15)
table_lst.append(new_user_num_row)
rate_row = ['比率', get_rate(new_user_first_recharge_uid_num, new_user_num), get_rate(new_user_month_card_num, new_user_num) ]
for _vip_num in new_row[3:]:
rate_row.append(get_rate(_vip_num, new_user_num))
table_lst.append(rate_row)
return table_lst
def get_table(search_start_date,
search_end_date,
register_start_date=None,
register_end_date=None,
channel_id=-1,
server_id=-1):
"""
获取展示表格
register_start_date 注册开始时间
register_end_date 注册结束时间
search_start_date 查询开始时间
search_end_date 查询结束时间
"""
# 获取搜索区间日志
new_log_lst = daily_log_dat.get_new_log_lst(search_start_date,
search_end_date)
if channel_id >= 0:
new_log_lst = daily_log_dat.filter_logs(
new_log_lst, function=lambda x: x['platform_id'] == channel_id)
if server_id >= 0:
new_log_lst = daily_log_dat.filter_logs(
new_log_lst, function=lambda x: x['server_id'] == server_id)
#获取符合条件的日志
if register_start_date and register_end_date:
new_log_lst = daily_log_dat.filter_logs(
new_log_lst,
function=lambda log: register_start_date <= log[
'install'] <= register_end_date)
# 获取所有钻石消耗的日志
cost_stone_log_lst = daily_log_dat.filter_logs(
new_log_lst, function=lambda log: 'cost_stone' in log)
level_log_dict = get_user_level_dict(cost_stone_log_lst)
table_result = []
for _lv in xrange(1, 121):
# print("--------------------"+str(_lv) + "--------------------")
row = []
lv_logs = level_log_dict[_lv]
uid_lst = daily_log_dat.get_set_with_key(lv_logs, 'uid')
sum_cost_stone = daily_log_dat.get_sum_int_with_key(
lv_logs, 'cost_stone')
cur_lv_num = len(uid_lst)
#到达人数
arrive_user_num = daily_log_dat.get_set_num_with_key(
new_log_lst, 'uid', function=lambda log: log['level'] >= _lv)
# 等级
row.append(str(_lv))
# 消耗人数
row.append(str(cur_lv_num))
# 消耗数量
row.append(str(sum_cost_stone))
# 到达人数
row.append(arrive_user_num)
# 等级消耗ARPPU
if cur_lv_num == 0:
row.append(str(0))
else:
row.append(str(round(float(sum_cost_stone) / float(cur_lv_num),
2)))
# 等级消耗率
if arrive_user_num == 0:
row.append(str(0) + "%")
else:
row.append(
str(
round(float(cur_lv_num) / float(arrive_user_num), 2) *
100) + "%")
# row = [_lv, action_total_cost_stone, user_num, action_cost_num, take_part_rate, first_cost_stone_rate, cur_user_num_rate]
# print("row: "+str(row))
table_result.append(row)
return table_result
def get_table(search_start_date, search_end_date, channel_id=-1, server_id=-1):
"""
获取展示表格
register_start_date 注册开始时间
register_end_date 注册结束时间
search_start_date 查询开始时间
search_end_date 查询结束时间
"""
# 获取搜索区间日志
new_log_lst = daily_log_dat.get_new_log_lst(search_start_date,
search_end_date)
if channel_id >= 0:
new_log_lst = daily_log_dat.filter_logs(
new_log_lst, function=lambda x: x['platform_id'] == channel_id)
if server_id >= 0:
new_log_lst = daily_log_dat.filter_logs(
new_log_lst, function=lambda x: x['server_id'] == server_id)
new_user_log_lst = daily_log_dat.filter_logs(
new_log_lst,
function=lambda log: search_start_date <= log['install'
] <= search_end_date)
# 新用户数量
new_user_num = daily_log_dat.get_set_num_with_key(new_user_log_lst, 'uid')
# 获取首冲日志列表
first_recharge_log_lst = daily_log_dat.filter_logs(
new_log_lst,
action=game_define.EVENT_ACTION_RECHARGE_PLAYER,
function=lambda log: log['old_rmb'] == 0)
first_recharge_uid_lst = daily_log_dat.get_set_with_key(
first_recharge_log_lst, 'uid')
# 新用户首冲
new_user_first_recharge_log_lst = daily_log_dat.filter_logs(
new_user_log_lst,
action=game_define.EVENT_ACTION_RECHARGE_PLAYER,
function=lambda log: log['old_rmb'] == 0)
new_user_first_recharge_uid_lst = daily_log_dat.get_set_with_key(
new_user_first_recharge_log_lst, 'uid')
# 获取所有登录日志
all_login_log_lst = daily_log_dat.filter_logs(
new_log_lst, action=game_define.EVENT_ACTION_ROLE_LOGIN)
all_login_uid_lst = daily_log_dat.get_set_with_key(all_login_log_lst,
'uid')
# 新用户登录日志
all_new_user_login_log_lst = daily_log_dat.filter_logs(
new_user_log_lst, action=game_define.EVENT_ACTION_ROLE_LOGIN)
all_new_user_login_uid_lst = daily_log_dat.get_set_with_key(
all_new_user_login_log_lst, 'uid')
# 获取用户的所有VIP字典
uid_vip_dict = dict()
uid_month_days_dict = dict()
new_user_uid_vip_dict = dict()
new_user_uid_month_days_dict = dict()
for _uid in all_login_uid_lst:
_vip_lv = daily_log_dat.get_max_int_with_key(
all_login_log_lst,
'vip_level',
function=lambda log: log['uid'] == _uid)
_month_card_days = daily_log_dat.get_max_int_with_key(
all_login_log_lst,
'month_card_days',
function=lambda log: log['uid'] == _uid)
uid_vip_dict[_uid] = _vip_lv
uid_month_days_dict[_uid] = _month_card_days
if _uid in all_new_user_login_uid_lst:
new_user_uid_vip_dict[_uid] = _vip_lv
new_user_uid_month_days_dict[_uid] = _month_card_days
table_lst = []
# 首冲人数
first_recharge_uid_num = len(first_recharge_uid_lst)
month_card_num = get_month_user_num(uid_month_days_dict)
vip_lst = []
for vip in xrange(13):
vip_num = get_vip_user_num(uid_vip_dict, vip)
vip_lst.append(vip_num)
row = ['总体', first_recharge_uid_num, month_card_num]
row.extend(vip_lst)
table_lst.append(row)
# 新增部分数据
new_user_first_recharge_uid_num = len(new_user_first_recharge_uid_lst)
new_user_month_card_num = get_month_user_num(new_user_uid_month_days_dict)
new_vip_lst = []
for vip in xrange(13):
vip_num = get_vip_user_num(new_user_uid_vip_dict, vip)
new_vip_lst.append(vip_num)
new_row = ['新增', new_user_first_recharge_uid_num, new_user_month_card_num]
new_row.extend(new_vip_lst)
table_lst.append(new_row)
# 区间新增用户数
new_user_num_row = ['新增角色数']
new_user_num_row.extend([new_user_num] * 15)
table_lst.append(new_user_num_row)
rate_row = [
'比率',
get_rate(new_user_first_recharge_uid_num, new_user_num),
get_rate(new_user_month_card_num, new_user_num)
]
for _vip_num in new_row[3:]:
rate_row.append(get_rate(_vip_num, new_user_num))
table_lst.append(rate_row)
return table_lst
def get_table(search_start_date, search_end_date, register_start_date=None, register_end_date=None, channel_id=-1, server_id=-1):
"""
获取展示表格
register_start_date 注册开始时间
register_end_date 注册结束时间
search_start_date 查询开始时间
search_end_date 查询结束时间
"""
# 获取搜索区间日志
new_log_lst = daily_log_dat.get_new_log_lst(search_start_date, search_end_date)
if channel_id >= 0:
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda x: x['platform_id'] == channel_id)
if server_id >= 0:
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda x: x['server_id'] == server_id)
#获取符合条件的日志
if register_start_date and register_end_date:
new_log_lst = daily_log_dat.filter_logs(new_log_lst, function=lambda log: register_start_date <= log['install'] <= register_end_date)
# 截取日志到 副本事件
stage_action_lst = [
game_define.EVENT_ACTION_TRIAL_BATTLE_WIN,
game_define.EVENT_ACTION_TRIAL_BATTLE_FAIL
]
stage_action_log_lst = daily_log_dat.filter_logs(new_log_lst,
function=lambda log: log['action'] in stage_action_lst)
table_lst = []
search_days = (search_end_date - search_start_date).days+1
for _day in xrange(search_days):
row_date = search_start_date + datetime.timedelta(days=_day)
# 获取当天的日志
row_logs = daily_log_dat.filter_logs(stage_action_log_lst, function=lambda log:log['log_time'].date() == row_date)
# 拆分日志
catch_action_log_dict = daily_log_dat.split_log_action_logs(row_logs)
# 获取可以参与人数
all_user_num = daily_log_dat.get_set_num_with_key(new_log_lst, 'uid')
# 获取实际参与人数
join_user_num = daily_log_dat.get_set_num_with_key(row_logs, 'uid')
# 参与次数
join_num = len(row_logs)
# 胜利日志
win_logs = catch_action_log_dict.get(game_define.EVENT_ACTION_GET_CATCH_MONSTER_RESULT,[])
win_user_num = daily_log_dat.get_set_num_with_key(win_logs, 'uid')
#失败日志
# fail_logs = []
# 完成次数
complete_count = len(win_logs)
# 参与率
join_rate = 0
if all_user_num:
join_rate = round(float(join_user_num)/float(all_user_num), 2)
# 胜率
win_rate = 0
if join_num:
win_rate = round(float(len(win_logs))/float(join_num), 2)
row_lst = [
row_date.strftime('%m/%d/%Y'), # 日期
join_user_num, # 参与人数
join_num, # 总参与次数
win_user_num, # 完成人数
complete_count, # 总完成次数
all_user_num, # 到达要求人数
join_rate, # 参与率
win_rate # 成功率
]
table_lst.append(row_lst)
return table_lst
def get_cost_stone_table(search_start_date,
search_end_date,
channel_id=-1,
server_id=-1):
"""
获取表格
"""
table_lst = []
search_log_lst = daily_log_dat.get_new_log_lst(search_start_date,
search_end_date)
if channel_id >= 0:
search_log_lst = daily_log_dat.filter_logs(
search_log_lst, function=lambda x: x['platform_id'] == channel_id)
if server_id >= 0:
search_log_lst = daily_log_dat.filter_logs(
search_log_lst, function=lambda x: x['server_id'] == server_id)
# 获取排除新手引导的日志列表
search_log_lst = daily_log_dat.filter_logs(
search_log_lst,
function=lambda log: log['action'
] != game_define.EVENT_ACTION_FINISH_NEWBIE)
search_log_lst = daily_log_dat.filter_logs(
search_log_lst,
function=lambda log: log['action'
] != game_define.EVENT_ACTION_FINISH_GUIDE)
# 获取首次消耗钻石的日志列表
first_cost_stone_log_lst = daily_log_dat.filter_logs(
search_log_lst,
function=lambda log: 'total_cost_stone' in log and log[
'total_cost_stone'] == log['cost_stone'])
# 获取首次消耗钻石的所有用户
first_cost_stone_user_num = daily_log_dat.get_set_num_with_key(
first_cost_stone_log_lst, 'uid')
# 总钻石数
first_cost_stone_total_num = daily_log_dat.get_sum_int_with_key(
first_cost_stone_log_lst, 'total_cost_stone')
# 根据ID拆分日志
action_logs_dict = dict()
for _log in first_cost_stone_log_lst:
# print("_log:"+str(_log))
_action = _log['action']
if _action in action_logs_dict:
action_logs_dict[_action].append(_log)
else:
lst = [_log]
action_logs_dict[_action] = lst
for _action, _logs in action_logs_dict.items():
user_num = daily_log_dat.get_set_num_with_key(_logs, 'uid')
action_total_cost_stone = daily_log_dat.get_sum_int_with_key(
_logs, 'cost_stone')
action_name = game_define.EVENT_LOG_ACTION_DICT[_action]
# 人数比率
cur_user_num_rate = str(_get_rate(user_num,
first_cost_stone_user_num)) + "%"
# print("action_total_cost_stone: "+str(action_total_cost_stone)+"first_cost_stone_total_num: "+str(first_cost_stone_total_num))
# 钻石比率
first_cost_stone_rate = str(
_get_rate(action_total_cost_stone,
first_cost_stone_total_num)) + "%"
row = [
action_name, action_total_cost_stone, user_num, cur_user_num_rate,
first_cost_stone_rate
]
table_lst.append(row)
return table_lst
