def get_table(search_start_date, search_end_date, channel_id=-1, server_id=-1): """ 获取用户留存情况 search_start_date 查询开始时间 search_end_date 查询结束时间 """ new_log_lst = [] now_date = datetime.date.today() if server_id != -1: if search_start_date < now_date: new_log_lst = dat_log_util.read_file_with_filename( "USER_RETAIN", search_start_date, search_end_date, server_id, "tables") if search_end_date == now_date: row_lst, rate_row_lst = get_row_lst(now_date, channel_id, server_id) new_log_lst.append(row_lst) new_log_lst.append(rate_row_lst) else: total_days = (search_end_date - search_start_date).days + 1 for i in xrange(total_days): search_date = search_start_date + datetime.timedelta(days=i) row_lst, rate_row_lst = get_row_lst(search_date, channel_id, server_id) new_log_lst.append(row_lst) new_log_lst.append(rate_row_lst) return new_log_lst
def get_table(search_start_date, search_end_date, server_id): table_lst = dat_log_util.read_file_with_filename("STAMINA_COST", search_start_date, search_end_date, server_id, 'tables') return table_lst
def get_cost_gold_table(search_start_date, server_id): """ 获取表格 """ table_lst = [] # 获取首次消耗钻石的日志列表 first_cost_gold_log_lst = dat_log_util.read_file_with_filename( "USER_FIRST_GOLD_CONSUME", search_start_date, search_start_date, server_id) for _log in first_cost_gold_log_lst: _action = _log['action'] action_name = game_define.EVENT_LOG_ACTION_DICT[_action] action_total_cost_gold = _log['gold_num'] user_num = _log['user_num'] cur_user_num_rate = _log['user_rate'] first_cost_gold_rate = _log['gold_rate'] row = [ action_name, action_total_cost_gold, user_num, str(cur_user_num_rate * 100) + "%", str(first_cost_gold_rate * 100) + "%" ] table_lst.append(row) return table_lst
def get_consume_table(search_start_date, search_end_date, server_id): #获取搜索区间日志 new_log_lst = dat_log_util.read_file_with_filename("REMOVE_MONSTER",search_start_date,search_end_date, server_id, "tables") search_monster_log_list = [] create_monster_action = set() head_name_lst = [] for monster_log in new_log_lst: search_monster_log_list.append(monster_log) for action,num in monster_log[2].items(): create_monster_action.add(action) for _act in create_monster_action: head_name_lst.append(game_define.EVENT_LOG_ACTION_DICT[_act]) table_lst = [] for create_monster_log in search_monster_log_list: monster_config = game_config.get_monster_config(create_monster_log[0]) _name = monster_config['name'] row_lst = [_name, str(create_monster_log[1]), ] for _act in create_monster_action: row_lst.append(int(math.fabs(create_monster_log[2].get(_act, 0)))) table_lst.append(row_lst) return table_lst, head_name_lst
def get_table(search_start_date,server_id): # 获取搜索区间日志 new_log_lst = dat_log_util.read_file_with_filename("USER_COST_STONE_WITH_VIP",search_start_date,search_start_date, server_id, 'tables') print new_log_lst table_lst = [] # 遍历所有事件 for new_log_dict in new_log_lst: action = new_log_dict.get('action',0) # 事件名称 action_name = game_define.EVENT_LOG_ACTION_DICT[action] # 充值用户消耗人数 recharge_user_num = str(new_log_dict.get('recharge_user_num',0)) # 充值用户消耗次数 recharge_user_log_num = str(new_log_dict.get('recharge_user_log_num',0)) # 非充值用户的人数 vip0_user_num = str(new_log_dict.get('vip0_user_num',0)) # 非充值用户消耗次数 vip0_user_log_num = str(new_log_dict.get('vip0_user_log_num',0)) # vip0 消耗钻石 vip0_cost_stone_num = str(-new_log_dict.get('vip0_cost_stone_num',0)) # 消耗钻石数量 total_cost_stone_num = str(-new_log_dict.get('total_cost_stone_num',0)) #事件名称 充值用户消耗人数 充值用户消耗次数 非充值用户消耗人数 非充值用户消耗次数 消耗钻石数量 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_cost_stone_num = str(-new_log_dict.get('vip_%s_cost_stone_num'%i,0)) vip_x_cost_stone_user_num = str(new_log_dict.get('vip_%s_cost_stone_user_num'%i,0)) 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_consume_table(search_start_date, search_end_date, server_id): #获取搜索区间日志 new_log_lst = dat_log_util.read_file_with_filename("CONSUME_EQUIP", search_start_date, search_end_date, server_id, 'tables') search_monster_log_list = [] create_monster_action = set() head_name_lst = [] for monster_log in new_log_lst: search_monster_log_list.append(monster_log) for action, num in monster_log[1].items(): create_monster_action.add(action) for _act in create_monster_action: head_name_lst.append(game_define.EVENT_LOG_ACTION_DICT[_act]) table_lst = [] for create_monster_log in search_monster_log_list: item_config = game_config.get_item_config(create_monster_log[0]) _name = item_config['name'] row_lst = [ _name, ] for _act in create_monster_action: row_lst.append(int(math.fabs(create_monster_log[1].get(_act, 0)))) table_lst.append(row_lst) return table_lst, head_name_lst
def get_create_table(search_start_date, search_end_date, server_id): #获取搜索区间日志 new_log_lst = dat_log_util.read_file_with_filename("CREATE_MONSTER", search_start_date, search_end_date, server_id, "tables") search_monster_log_list = [] create_monster_action = set() head_name_lst = [] for monster_log in new_log_lst: search_monster_log_list.append(monster_log) for action, num in monster_log[2].items(): create_monster_action.add(action) for _act in create_monster_action: head_name_lst.append(game_define.EVENT_LOG_ACTION_DICT[_act]) table_lst = [] for create_monster_log in search_monster_log_list: monster_config = game_config.get_monster_config(create_monster_log[0]) _name = monster_config['name'] row_lst = [ _name, str(create_monster_log[1]), ] for _act in create_monster_action: row_lst.append(str(create_monster_log[2].get(_act, 0))) table_lst.append(row_lst) return table_lst, head_name_lst
def get_create_table(search_start_date, search_end_date, server_id): #获取搜索区间日志 new_log_lst = dat_log_util.read_file_with_filename("CREATE_EQUIP",search_start_date,search_end_date,server_id,'tables') search_monster_log_list = [] create_monster_action = set() head_name_lst = [] for monster_log in new_log_lst: search_monster_log_list.append(monster_log) for action,num in monster_log[1].items(): create_monster_action.add(action) for _act in create_monster_action: head_name_lst.append(game_define.EVENT_LOG_ACTION_DICT[_act]) table_lst = [] for create_monster_log in search_monster_log_list: item_config = game_config.get_item_config(create_monster_log[0]) _name = item_config['name'] row_lst = [ _name, ] for _act in create_monster_action: row_lst.append(str(create_monster_log[1].get(_act, 0))) table_lst.append(row_lst) return table_lst, head_name_lst
def get_cost_gold_table(search_start_date, server_id): """ 获取表格 """ table_lst = [] # 获取首次消耗钻石的日志列表 first_cost_gold_log_lst = dat_log_util.read_file_with_filename( "USER_FIRST_GOLD_CONSUME", search_start_date, search_start_date, server_id ) for _log in first_cost_gold_log_lst: _action = _log["action"] action_name = game_define.EVENT_LOG_ACTION_DICT[_action] action_total_cost_gold = _log["gold_num"] user_num = _log["user_num"] cur_user_num_rate = _log["user_rate"] first_cost_gold_rate = _log["gold_rate"] row = [ action_name, action_total_cost_gold, user_num, str(cur_user_num_rate * 100) + "%", str(first_cost_gold_rate * 100) + "%", ] 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 = [] if not search_start_date or not search_end_date: return new_log_lst now_date = datetime.date.today() if server_id != -1: if search_start_date < now_date: new_log_lst = dat_log_util.read_file_with_filename("USER_STRUCTURE", search_start_date, search_end_date, server_id, "tables") return new_log_lst
def get_table(search_start_date, search_end_date,server_id): """ 获取展示表格 register_start_date 注册开始时间 register_end_date 注册结束时间 search_start_date 查询开始时间 search_end_date 查询结束时间 """ new_log_lst = dat_log_util.read_file_with_filename("NORMAL_STAGE_CHALLENGE", search_start_date, search_end_date,server_id,'tables') return new_log_lst
def get_table(search_start_date, search_end_date,server_id): """ 获取展示表格 register_start_date 注册开始时间 register_end_date 注册结束时间 search_start_date 查询开始时间 search_end_date 查询结束时间 """ # 获取搜索区间日志 new_log_lst = dat_log_util.read_file_with_filename("CATCH_MONSTER_STAGE_CHALLENGE", search_start_date, search_end_date,server_id,'tables') return new_log_lst
def get_table(search_start_date,server_id): """ 获取等级排行表 search_start_date 查询开始时间 search_end_date 查询结束时间 """ new_log_lst = [] new_log_lst = dat_log_util.read_file_with_filename("LEVEL_RANK_LIST",search_start_date,search_start_date,server_id) return new_log_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 = dat_log_util.read_file_with_filename("WORLD_BOSS_STAGE_CHALLENGE", search_start_date, search_end_date,server_id,'tables') return new_log_lst
def get_table(search_start_date, search_end_date, channel_id=-1, server_id=-1): new_log_lst = [] if not search_start_date or not search_end_date: return new_log_lst now_date = datetime.date.today() if server_id != -1: if search_start_date < now_date: new_log_lst = dat_log_util.read_file_with_filename( "USER_STRUCTURE", search_start_date, search_end_date, server_id, "tables" ) return new_log_lst
def get_table(search_start_date, search_end_date, server_id): """ 获取展示表格 register_start_date 注册开始时间 register_end_date 注册结束时间 search_start_date 查询开始时间 search_end_date 查询结束时间 """ # 获取搜索区间日志 new_log_lst = dat_log_util.read_file_with_filename( "GOLD_STAGE_CHALLENGE", search_start_date, search_end_date, server_id, "tables" ) return new_log_lst
def get_table(search_start_date, search_end_date, server_id): # 获取搜索区间日志 new_log_lst = dat_log_util.read_file_with_filename("MONSTER_RESET_INDIVIDUAL", search_start_date, search_end_date, server_id, "tables") # print new_log_lst table_lst = [] for new_log in new_log_lst: monster_config = game_config.get_monster_config(new_log[0]) _name = monster_config['name'] row_lst = [_name] row_lst.extend(new_log[1:]) table_lst.append(row_lst) return table_lst
def get_table(search_start_date, search_end_date, server_id): # 获取搜索区间日志 new_log_lst = dat_log_util.read_file_with_filename( "MONSTER_RESET_INDIVIDUAL", search_start_date, search_end_date, server_id, "tables") # print new_log_lst table_lst = [] for new_log in new_log_lst: monster_config = game_config.get_monster_config(new_log[0]) _name = monster_config['name'] row_lst = [_name] row_lst.extend(new_log[1:]) table_lst.append(row_lst) return table_lst
def get_table(search_start_date, server_id): """ 获取等级排行表 search_start_date 查询开始时间 search_end_date 查询结束时间 """ new_log_lst = [] new_log_lst = dat_log_util.read_file_with_filename("LEVEL_RANK_LIST", search_start_date, search_start_date, server_id) return new_log_lst
def get_table(search_start_date, server_id): # 获取搜索区间日志 new_log_lst = dat_log_util.read_file_with_filename( "USER_COST_GOLD_WITH_VIP", search_start_date, search_start_date, server_id, 'tables') print new_log_lst table_lst = [] # 遍历所有事件 for new_log_dict in new_log_lst: action = new_log_dict.get('action', 0) # 事件名称 action_name = game_define.EVENT_LOG_ACTION_DICT[action] # 充值用户消耗人数 recharge_user_num = str(new_log_dict.get('recharge_user_num', 0)) # 充值用户消耗次数 recharge_user_log_num = str( new_log_dict.get('recharge_user_log_num', 0)) # 非充值用户的人数 vip0_user_num = str(new_log_dict.get('vip0_user_num', 0)) # 非充值用户消耗次数 vip0_user_log_num = str(new_log_dict.get('vip0_user_log_num', 0)) # vip0 消耗钻石 vip0_cost_gold_num = str(-new_log_dict.get('vip0_cost_gold_num', 0)) # 消耗钻石数量 total_cost_gold_num = str(-new_log_dict.get('total_cost_gold_num', 0)) #事件名称 充值用户消耗人数 充值用户消耗次数 非充值用户消耗人数 非充值用户消耗次数 消耗钻石数量 VIP0消耗金额 VIP0消耗人数 row_lst = [ action_name, recharge_user_num, recharge_user_log_num, vip0_user_num, vip0_user_log_num, total_cost_gold_num, vip0_cost_gold_num, vip0_user_num ] # 遍历VIP for i in xrange(1, 13): vip_x_cost_gold_num = str( -new_log_dict.get('vip_%s_cost_gold_num' % i, 0)) vip_x_cost_gold_user_num = str( new_log_dict.get('vip_%s_cost_gold_user_num' % i, 0)) row_lst.append(vip_x_cost_gold_num) row_lst.append(vip_x_cost_gold_user_num) table_lst.append(row_lst) return table_lst
def get_table(search_start_date, search_end_date, server_id=-1, uid=-1): if 'li' == uid: temp_lst = [] new_log_lst = [] #用户uid表 测试使用 new_log_lst = dat_log_util.read_file_with_filename('GM_COST_SEARCH_LST', search_start_date, search_end_date, server_id, READ_FILE_FLODER) if new_log_lst: log_lst = set(new_log_lst) result = [[elem] for elem in log_lst] temp_lst.extend(result) new_log_head = [ {'width': 50 ,'name': u'存在消费的用户UID'}, ] return temp_lst, new_log_head elif uid: new_log_lst, new_log_head = dat_log_util.read_file_double_lst(str(uid), search_start_date, search_end_date, server_id, READ_FILE_FLODER) max_lst_len = 0 max_lst = [] for each_lst in new_log_head: if len(each_lst) > max_lst_len: max_lst = each_lst max_lst_len = len(each_lst) return new_log_lst, max_lst else: head_lst = [ {'width':50,'name':u'消费时间'}, {'width':50,'name':u'账号UID'}, {'width':50,'name':u'服务器ID'}, {'width':50,'name':u'平台ID'}, {'width':50,'name':u'用户事件'}, {'width':50,'name':u'消耗金币'}, {'width':50,'name':u'消耗钻石'}, ] temp_lst = [[u'请输入uid',u'请输入uid',u'请输入uid',u'请输入uid',u'请输入uid',u'请输入uid',u'请输入uid']] return temp_lst, head_lst # import datetime # get_table(datetime.date(2015,05,21),datetime.date(2015,05,21),-1,-1,-1) # if datetime.date(2015,05,21) < datetime.date(2015,05,22): # print "ok"
def get_table(search_start_date, search_end_date, channel_id=-1, server_id=-1): """ 获取用户留存情况 search_start_date 查询开始时间 search_end_date 查询结束时间 """ new_log_lst = [] now_date = datetime.date.today() if server_id != -1: if search_start_date < now_date: new_log_lst = dat_log_util.read_file_with_filename("USER_RETAIN", search_start_date, search_end_date, server_id, "tables") if search_end_date == now_date: row_lst, rate_row_lst = get_row_lst(now_date, channel_id, server_id) new_log_lst.append(row_lst) new_log_lst.append(rate_row_lst) else: total_days = (search_end_date-search_start_date).days+1 for i in xrange(total_days): search_date = search_start_date+datetime.timedelta(days=i) row_lst, rate_row_lst = get_row_lst(search_date, channel_id, server_id) new_log_lst.append(row_lst) new_log_lst.append(rate_row_lst) return new_log_lst
def get_table(search_start_date, search_end_date, channel_id=-1, server_id=-1): """ 获取统计总表 search_start_date 查询开始时间 search_end_date 查询结束时间 """ new_log_lst = [] if not search_start_date or not search_end_date: return new_log_lst now_date = datetime.date.today() if server_id != -1: if search_start_date < now_date: new_log_lst = dat_log_util.read_file_with_filename("STATISTICS_TOTAL", search_start_date, search_end_date, server_id, "tables") if search_end_date == now_date: row_lst = get_row_lst(now_date, channel_id, server_id) new_log_lst.append(row_lst) else: total_days = (search_end_date-search_start_date).days+1 for i in xrange(total_days): search_date = search_start_date+datetime.timedelta(days=i) row_lst = get_row_lst(search_date, channel_id, server_id) new_log_lst.append(row_lst) return new_log_lst
def get_table(search_start_date, search_end_date,server_id): table_lst = dat_log_util.read_file_with_filename("STAMINA_COST",search_start_date,search_end_date,server_id,'tables') return table_lst
def get_table(search_start_date, search_end_date, channel_id=-1, server_id=-1): """ """ start_log_time = datetime.datetime.strptime(game_define.LOCAL_LOG_START_DATE, '%Y-%m-%d').date() # 总天数 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) # 获取今天全部日志 today_log_lst = mysql_util.get_role_action_lst('EVENT_ACTION_ROLE_LOGIN',start_log_time,row_date, channel_id, server_id,None, None) # 今日游戏玩家列表 today_login_user = daily_log_dat.get_user_uid_lst(today_log_lst) # 获取玩家时间段分布(5分钟) online_user_uid_lst = daily_log_dat.get_online_user_uid_lst(row_date, today_log_lst, 5) # 当前时间段Index now = datetime.datetime.now() minutes = now.hour * 60 + now.minute cur_online_lst_index = minutes / 5 online_time_result = dat_log_util.read_file_with_filename("USER_ONLINE_TIME",row_date,row_date) print online_time_result # 日期 show_date_str= row_date.strftime('%Y-%m-%d') # 今日总登录用户数 today_login_user_num = daily_log_dat.get_set_num_with_key(today_log_lst, 'uid') # 当前实时在线 cur_online_num = len(online_user_uid_lst[cur_online_lst_index]) # 当日峰值在线 today_max_online_num = _max_online_num_today(online_user_uid_lst) # 5分钟以内 online_5 = _get_online_user_num(online_time_result, 0, 5) # 5-10分钟 online_5_10 = _get_online_user_num(online_time_result, 5, 10) # 10-15分钟 online_10_15 = _get_online_user_num(online_time_result, 10, 15) # 15-20分钟 online_15_20 = _get_online_user_num(online_time_result, 15, 20) # 20-25分钟 online_20_25 = _get_online_user_num(online_time_result, 20, 25) # 25-30分钟 online_25_30 = _get_online_user_num(online_time_result, 25, 30) # 30-35分钟 online_30_35 = _get_online_user_num(online_time_result, 30, 35) # 35-40分钟 online_35_40 = _get_online_user_num(online_time_result, 35, 40) # 40-45分钟 online_40_45 = _get_online_user_num(online_time_result, 40, 45) # 45-50分钟 online_45_50 = _get_online_user_num(online_time_result, 45, 50) # 50-55分钟 online_50_55 = _get_online_user_num(online_time_result, 50, 55) # 55-60分钟 online_55_60 = _get_online_user_num(online_time_result, 55, 60) # 60-90分钟 online_60_90 = _get_online_user_num(online_time_result, 60,90) # 90-120分钟 online_90_120 = _get_online_user_num(online_time_result, 90,120) # 120分钟以上 online_120_99999 = _get_online_user_num(online_time_result, 120, 99999) row_lst.append(show_date_str) row_lst.append(today_login_user_num) row_lst.append(cur_online_num) row_lst.append(today_max_online_num) row_lst.append(online_5) row_lst.append(online_5_10) row_lst.append(online_10_15) row_lst.append(online_15_20) row_lst.append(online_20_25) row_lst.append(online_25_30) row_lst.append(online_30_35) row_lst.append(online_35_40) row_lst.append(online_40_45) row_lst.append(online_45_50) row_lst.append(online_50_55) row_lst.append(online_55_60) row_lst.append(online_60_90) row_lst.append(online_90_120) row_lst.append(online_120_99999) table_lst.append(row_lst) return table_lst
def get_table(search_start_date, search_end_date, server_id=-1, uid=-1): if 'li' == uid: temp_lst = [] new_log_lst = [] #用户uid表 测试使用 new_log_lst = dat_log_util.read_file_with_filename( 'GM_COST_SEARCH_LST', search_start_date, search_end_date, server_id, READ_FILE_FLODER) if new_log_lst: log_lst = set(new_log_lst) result = [[elem] for elem in log_lst] temp_lst.extend(result) new_log_head = [ { 'width': 50, 'name': u'存在消费的用户UID' }, ] return temp_lst, new_log_head elif uid: new_log_lst, new_log_head = dat_log_util.read_file_double_lst( str(uid), search_start_date, search_end_date, server_id, READ_FILE_FLODER) max_lst_len = 0 max_lst = [] for each_lst in new_log_head: if len(each_lst) > max_lst_len: max_lst = each_lst max_lst_len = len(each_lst) return new_log_lst, max_lst else: head_lst = [ { 'width': 50, 'name': u'消费时间' }, { 'width': 50, 'name': u'账号UID' }, { 'width': 50, 'name': u'服务器ID' }, { 'width': 50, 'name': u'平台ID' }, { 'width': 50, 'name': u'用户事件' }, { 'width': 50, 'name': u'消耗金币' }, { 'width': 50, 'name': u'消耗钻石' }, ] temp_lst = [[ u'请输入uid', u'请输入uid', u'请输入uid', u'请输入uid', u'请输入uid', u'请输入uid', u'请输入uid' ]] return temp_lst, head_lst # import datetime # get_table(datetime.date(2015,05,21),datetime.date(2015,05,21),-1,-1,-1) # if datetime.date(2015,05,21) < datetime.date(2015,05,22): # print "ok"
def get_table(search_start_date, search_end_date, channel_id=-1, server_id=-1): """ """ start_log_time = datetime.datetime.strptime( game_define.LOCAL_LOG_START_DATE, '%Y-%m-%d').date() # 总天数 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) # 获取今天全部日志 today_log_lst = mysql_util.get_role_action_lst( 'EVENT_ACTION_ROLE_LOGIN', start_log_time, row_date, channel_id, server_id, None, None) # 今日游戏玩家列表 today_login_user = daily_log_dat.get_user_uid_lst(today_log_lst) # 获取玩家时间段分布(5分钟) online_user_uid_lst = daily_log_dat.get_online_user_uid_lst( row_date, today_log_lst, 5) # 当前时间段Index now = datetime.datetime.now() minutes = now.hour * 60 + now.minute cur_online_lst_index = minutes / 5 online_time_result = dat_log_util.read_file_with_filename( "USER_ONLINE_TIME", row_date, row_date) print online_time_result # 日期 show_date_str = row_date.strftime('%Y-%m-%d') # 今日总登录用户数 today_login_user_num = daily_log_dat.get_set_num_with_key( today_log_lst, 'uid') # 当前实时在线 cur_online_num = len(online_user_uid_lst[cur_online_lst_index]) # 当日峰值在线 today_max_online_num = _max_online_num_today(online_user_uid_lst) # 5分钟以内 online_5 = _get_online_user_num(online_time_result, 0, 5) # 5-10分钟 online_5_10 = _get_online_user_num(online_time_result, 5, 10) # 10-15分钟 online_10_15 = _get_online_user_num(online_time_result, 10, 15) # 15-20分钟 online_15_20 = _get_online_user_num(online_time_result, 15, 20) # 20-25分钟 online_20_25 = _get_online_user_num(online_time_result, 20, 25) # 25-30分钟 online_25_30 = _get_online_user_num(online_time_result, 25, 30) # 30-35分钟 online_30_35 = _get_online_user_num(online_time_result, 30, 35) # 35-40分钟 online_35_40 = _get_online_user_num(online_time_result, 35, 40) # 40-45分钟 online_40_45 = _get_online_user_num(online_time_result, 40, 45) # 45-50分钟 online_45_50 = _get_online_user_num(online_time_result, 45, 50) # 50-55分钟 online_50_55 = _get_online_user_num(online_time_result, 50, 55) # 55-60分钟 online_55_60 = _get_online_user_num(online_time_result, 55, 60) # 60-90分钟 online_60_90 = _get_online_user_num(online_time_result, 60, 90) # 90-120分钟 online_90_120 = _get_online_user_num(online_time_result, 90, 120) # 120分钟以上 online_120_99999 = _get_online_user_num(online_time_result, 120, 99999) row_lst.append(show_date_str) row_lst.append(today_login_user_num) row_lst.append(cur_online_num) row_lst.append(today_max_online_num) row_lst.append(online_5) row_lst.append(online_5_10) row_lst.append(online_10_15) row_lst.append(online_15_20) row_lst.append(online_20_25) row_lst.append(online_25_30) row_lst.append(online_30_35) row_lst.append(online_35_40) row_lst.append(online_40_45) row_lst.append(online_45_50) row_lst.append(online_50_55) row_lst.append(online_55_60) row_lst.append(online_60_90) row_lst.append(online_90_120) row_lst.append(online_120_99999) table_lst.append(row_lst) return table_lst
def get_table(search_start_date, search_end_date, server_id=-1): # 豪华签到 new_sign_lst = dat_log_util.read_file_with_filename("LUXURY_SIGN", search_start_date, search_end_date, server_id, 'tables') # print new_sign_lst return new_sign_lst
def get_table(search_start_date, server_id): tmp_list = dat_log_util.read_file_with_filename(READ_FILE_NMAE, search_start_date, search_start_date, server_id, READ_FILE_FLODER) return tmp_list