def get_table(search_start_date, search_end_date, channel_id=-1, server_id=-1):
"""
获取表格
"""
# 获取搜索区间日志
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)
search_days = (search_end_date - search_start_date).days
table_lst = []
head_lst = []
head_name_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)
# 获取不同事件的获取金币
action_logs_dict = daily_log_dat.split_log_action_logs(row_logs)
# print("action_logs_dict: "+str(action_logs_dict))
cost_stone_dict = dict()
for _action,_logs in action_logs_dict.items():
sum_add_stone = daily_log_dat.get_sum_int_with_key(_logs, 'cost_stone')
cost_stone_dict[_action] = sum_add_stone
if sum_add_stone and _action not in head_lst:
head_lst.append(_action)
head_name_lst.append(game_define.EVENT_LOG_ACTION_DICT[_action])
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)
# 总产出金币数
total_get_stone = daily_log_dat.get_sum_int_with_key(row_logs, 'add_stone')
# 总消耗金币数
total_cost_stone = daily_log_dat.get_sum_int_with_key(row_logs, 'cost_stone')
# 获取不同事件的获取金币
action_logs_dict = daily_log_dat.split_log_action_logs(row_logs)
cost_stone_dict = dict()
for _action,_logs in action_logs_dict.items():
sum_add_stone = daily_log_dat.get_sum_int_with_key(_logs, 'cost_stone')
cost_stone_dict[_action] = sum_add_stone
# 获取消耗
row_lst = [
row_date.strftime('%m/%d/%Y'),
total_get_stone,
total_cost_stone,
]
for _act_id in head_lst:
if _act_id in cost_stone_dict:
row_lst.append(cost_stone_dict.get(_act_id, 0))
else:
row_lst.append(0)
table_lst.append(row_lst)
return table_lst,head_name_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, 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, 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_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_date, channel_id=-1, server_id=-1):
"""
角色首次充值等级
"""
start_log_time = datetime.datetime.strptime(game_define.LOCAL_LOG_START_DATE, '%Y-%m-%d').date()
# 全部日志
all_log_lst = daily_log_dat.get_new_log_lst(start_log_time, search_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_recharge_log_lst = daily_log_dat.filter_logs(all_log_lst, action=game_define.EVENT_ACTION_RECHARGE_PLAYER)
all_first_recharge_log_lst = daily_log_dat.filter_logs(all_recharge_log_lst, function=lambda log:log['old_rmb'] == 0)
table_lst = []
for _table_lv in xrange(1, 121):
# 全部当前等级充值日志
recharge_lv_log_lst = daily_log_dat.filter_logs(all_recharge_log_lst, function=lambda log: log['level'] == _table_lv)
# 全部当前等级充值 用户ID列表
recharge_lv_user_lst = daily_log_dat.get_set_with_key(recharge_lv_log_lst, 'uid')
# 全部当前等级首次充值日志
first_recharge_lv_log_lst = daily_log_dat.filter_logs(all_first_recharge_log_lst, function=lambda log: log['level'] == _table_lv)
# 全部当前等级首次充值 用户ID列表
first_recharge_lv_user_lst = daily_log_dat.get_set_with_key(first_recharge_lv_log_lst, 'uid')
# 首次充值人数
first_recharge_user_num = len(first_recharge_lv_user_lst)
# 首次充值总金额
first_recharge_total_money = daily_log_dat.get_sum_int_with_key(first_recharge_lv_log_lst, "add_rmb")
# 总体充值人数
recharge_user_num = len(recharge_lv_user_lst)
# 总体充值金额
recharge_total_money = daily_log_dat.get_sum_int_with_key(recharge_lv_log_lst, "add_rmb")
# 首次金额占比
first_recharge_money_rate = get_first_recharge_money_rate(first_recharge_total_money,recharge_total_money)
# 首次人数占比
first_recharge_user_rate = get_first_recharge_user_rate(first_recharge_user_num,recharge_user_num)
row = [_table_lv, first_recharge_user_num, first_recharge_total_money, recharge_user_num, recharge_total_money, first_recharge_money_rate, first_recharge_user_rate]
table_lst.append(row)
return table_lst
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):
"""
获取表格
"""
# 获取搜索区间日志
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_total_day = (search_end_date - search_start_date).days
table_lst = []
for i in xrange(search_total_day + 1):
_search_date = search_start_date + datetime.timedelta(days=1 * i)
#获取当天日志
_row_log_lst = daily_log_dat.filter_logs(
search_log_lst,
function=lambda log: log['log_time'].date() == _search_date)
# 获取新用户日志
new_user_lst = daily_log_dat.get_set_with_key(
_row_log_lst,
'uid',
action=game_define.EVENT_ACTION_ROLE_LOGIN,
function=lambda log: log['install'] == _search_date)
new_user_num = len(new_user_lst)
ltv_day_lst = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 15, 30, 60]
ltv_val_lst = []
for ltv_days in ltv_day_lst:
start_date = _search_date
end_date = _search_date + datetime.timedelta(days=ltv_days)
ltv_logs = daily_log_dat.get_new_log_lst(start_date, end_date)
ltv_recharge_log_lst = daily_log_dat.filter_logs(
ltv_logs,
action=game_define.EVENT_ACTION_RECHARGE_PLAYER,
function=lambda log: log['uid'] in new_user_lst)
total_recharge_money = daily_log_dat.get_sum_int_with_key(
ltv_recharge_log_lst, 'add_rmb')
ltv_val = _get_ltv_value(new_user_num, total_recharge_money)
ltv_val_lst.append(ltv_val)
row_lst = [_search_date, new_user_num]
row_lst.extend(ltv_val_lst)
table_lst.append(row_lst)
return table_lst
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):
"""
获取表格
"""
# 获取搜索区间日志
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_total_day = (search_end_date - search_start_date).days
table_lst = []
for i in xrange(search_total_day + 1):
_search_date = search_start_date + datetime.timedelta(days=1 * i)
#获取当天日志
_row_log_lst = daily_log_dat.filter_logs(search_log_lst, function=lambda log:log['log_time'].date() == _search_date)
# 获取新用户日志
new_user_lst = daily_log_dat.get_set_with_key(_row_log_lst, 'uid', action=game_define.EVENT_ACTION_ROLE_LOGIN, function=lambda log:log['install'] == _search_date)
new_user_num = len(new_user_lst)
ltv_day_lst = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 15, 30, 60]
ltv_val_lst = []
for ltv_days in ltv_day_lst:
start_date =_search_date
end_date = _search_date + datetime.timedelta(days=ltv_days)
ltv_logs = daily_log_dat.get_new_log_lst(start_date, end_date)
ltv_recharge_log_lst = daily_log_dat.filter_logs(ltv_logs, action=game_define.EVENT_ACTION_RECHARGE_PLAYER, function=lambda log:log['uid'] in new_user_lst)
total_recharge_money = daily_log_dat.get_sum_int_with_key(ltv_recharge_log_lst, 'add_rmb')
ltv_val = _get_ltv_value(new_user_num, total_recharge_money)
ltv_val_lst.append(ltv_val)
row_lst = [_search_date, new_user_num]
row_lst.extend(ltv_val_lst)
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)
# 截取日志到 副本事件
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,
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,
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(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(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, 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):
"""
获取表格
"""
# 获取搜索区间日志
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)
search_days = (search_end_date - search_start_date).days
table_lst = []
head_lst = []
head_name_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)
# 获取不同事件的获取金币
action_logs_dict = daily_log_dat.split_log_action_logs(row_logs)
# print("action_logs_dict: "+str(action_logs_dict))
add_stone_dict = dict()
for _action, _logs in action_logs_dict.items():
sum_add_stone = daily_log_dat.get_sum_int_with_key(
_logs, 'add_stone')
add_stone_dict[_action] = sum_add_stone
if sum_add_stone and _action not in head_lst:
head_lst.append(_action)
head_name_lst.append(
game_define.EVENT_LOG_ACTION_DICT[_action])
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)
# 总产出金币数
total_get_stone = daily_log_dat.get_sum_int_with_key(
row_logs, 'add_stone')
# 总消耗金币数
total_cost_stone = daily_log_dat.get_sum_int_with_key(
row_logs, 'cost_stone')
# 获取不同事件的获取金币
action_logs_dict = daily_log_dat.split_log_action_logs(row_logs)
add_stone_dict = dict()
for _action, _logs in action_logs_dict.items():
sum_add_stone = daily_log_dat.get_sum_int_with_key(
_logs, 'add_stone')
add_stone_dict[_action] = sum_add_stone
# 获取消耗
row_lst = [
row_date.strftime('%m/%d/%Y'),
total_get_stone,
total_cost_stone,
]
for _act_id in head_lst:
# print("_act_id: "+str(_act_id)+"add_gold_dict: "+str(add_gold_dict))
if _act_id in add_stone_dict:
row_lst.append(add_stone_dict.get(_act_id, 0))
else:
row_lst.append(0)
# print("_day: "+str(_day)+"row_lst: "+str(row_lst))
table_lst.append(row_lst)
return table_lst, head_name_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
