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