def get_table(search_start_date=None, search_end_date=None, server_id=-1, register_start_date=None, register_end_date=None): table_result = [] total_days = (search_end_date-search_start_date).days+1 for _day in xrange(total_days): # -------------总体----------------- total_line = [] new_user_line = [] add_line = [] rate_line = [] # 每行的日期 row_date = search_start_date + datetime.timedelta(days=_day) date_str = '_'+row_date.strftime('%Y%m%d') # 插入数据 total_line.append(row_date.strftime('%Y-%m-%d')) new_user_line.append(row_date.strftime('%Y-%m-%d')) add_line.append(row_date.strftime('%Y-%m-%d')) rate_line.append(row_date.strftime('%Y-%m-%d')) # 首冲 first_recharge = mysql_util.get_first_recharge_shop_index_uid_num('uid', 'EVENT_ACTION_RECHARGE_PLAYER'+str(date_str), row_date, 'shop_index', -1, -1, server_id, register_start_date, register_end_date) # 月卡 month_card_recharge = mysql_util.get_recharge_shop_index_uid_num('uid', 'EVENT_ACTION_RECHARGE_PLAYER'+str(date_str), row_date, 'shop_index', 1, -1, server_id, register_start_date, register_end_date) # vip总体登录 total_line.extend(['总体', first_recharge, month_card_recharge]) vip_level_lst = [0]*13 uid_level_lst = mysql_util.get_vip_distributed_uid('EVENT_ACTION_ROLE_LOGIN'+str(date_str), -1, server_id, register_start_date, register_end_date) for _uid_level in uid_level_lst: _vip_level = int(_uid_level['vip_level']) vip_level_lst[_vip_level] = int(_uid_level['count(uid)']) total_line.extend(vip_level_lst) # -------------新增----------------- new_install_num = mysql_util.get_today_new_num('uid', 'EVENT_ACTION_ROLE_LOGIN'+str(date_str), row_date, -1, server_id) add_line.extend(['今日新增用户']) add_line.extend([new_install_num] * 15) # 首冲 first_recharge = mysql_util.get_first_recharge_shop_index_uid_num('uid', 'EVENT_ACTION_RECHARGE_PLAYER'+str(date_str), row_date, 'shop_index', -1, -1, server_id, row_date, row_date) # 月卡 month_card_recharge = mysql_util.get_recharge_shop_index_uid_num('uid', 'EVENT_ACTION_RECHARGE_PLAYER'+str(date_str), row_date, 'shop_index', 1, -1, server_id, row_date, row_date) # vip 新增充值 new_user_line.extend(['新增', first_recharge, month_card_recharge]) new_vip_level_lst = [0]*13 new_uid_level_lst = mysql_util.get_vip_distributed_uid('EVENT_ACTION_ROLE_LOGIN'+str(date_str), -1, server_id, row_date, row_date) for _uid_level in new_uid_level_lst: _vip_level = int(_uid_level['vip_level']) new_vip_level_lst[_vip_level] = int(_uid_level['count(uid)']) new_user_line.extend(new_vip_level_lst) # -------------比率----------------- rate_line.extend(['比率']) for _index in xrange(2, 17): rate = division(new_user_line[_index], add_line[_index]) rate_line.append(str(rate*100)+'%') table_result.extend([total_line, new_user_line, add_line, rate_line]) return table_result
def get_table(search_start_date, search_end_date, channel_id=-1, server_id=-1): table_result = [] total_days = (search_end_date-search_start_date).days + 1 for _day in xrange(total_days): row = [] # 每行的日期 row_date = search_start_date + datetime.timedelta(days=_day) date_str = '_' + row_date.strftime('%Y%m%d') # 插入数据 row.append(row_date.strftime('%Y-%m-%d')) # 充值档 for shop_id in xrange(1, 9): user_num = mysql_util.get_recharge_shop_index_uid_num('uid', 'EVENT_ACTION_RECHARGE_PLAYER'+str(date_str), row_date, 'shop_index', shop_id, channel_id, server_id) # 插入数据 row.append(user_num) table_result.append(row) return table_result
def get_table(search_start_date, search_end_date, channel_id=-1, server_id=-1): table_result = [] total_days = (search_end_date - search_start_date).days + 1 for _day in xrange(total_days): row = [] # 每行的日期 row_date = search_start_date + datetime.timedelta(days=_day) date_str = '_' + row_date.strftime('%Y%m%d') # 插入数据 row.append(row_date.strftime('%Y-%m-%d')) # 充值档 for shop_id in xrange(1, 9): user_num = mysql_util.get_recharge_shop_index_uid_num( 'uid', 'EVENT_ACTION_RECHARGE_PLAYER' + str(date_str), row_date, 'shop_index', shop_id, channel_id, server_id) # 插入数据 row.append(user_num) table_result.append(row) return table_result
def get_table(search_start_date=None, search_end_date=None, server_id=-1, register_start_date=None, register_end_date=None): table_result = [] total_days = (search_end_date - search_start_date).days + 1 for _day in xrange(total_days): # -------------总体----------------- total_line = [] new_user_line = [] add_line = [] rate_line = [] # 每行的日期 row_date = search_start_date + datetime.timedelta(days=_day) date_str = '_' + row_date.strftime('%Y%m%d') # 插入数据 total_line.append(row_date.strftime('%Y-%m-%d')) new_user_line.append(row_date.strftime('%Y-%m-%d')) add_line.append(row_date.strftime('%Y-%m-%d')) rate_line.append(row_date.strftime('%Y-%m-%d')) # 首冲 first_recharge = mysql_util.get_first_recharge_shop_index_uid_num( 'uid', 'EVENT_ACTION_RECHARGE_PLAYER' + str(date_str), row_date, 'shop_index', -1, -1, server_id, register_start_date, register_end_date) # 月卡 month_card_recharge = mysql_util.get_recharge_shop_index_uid_num( 'uid', 'EVENT_ACTION_RECHARGE_PLAYER' + str(date_str), row_date, 'shop_index', 1, -1, server_id, register_start_date, register_end_date) # vip总体登录 total_line.extend(['总体', first_recharge, month_card_recharge]) vip_level_lst = [0] * 13 uid_level_lst = mysql_util.get_vip_distributed_uid( 'EVENT_ACTION_ROLE_LOGIN' + str(date_str), -1, server_id, register_start_date, register_end_date) for _uid_level in uid_level_lst: _vip_level = int(_uid_level['vip_level']) vip_level_lst[_vip_level] = int(_uid_level['count(uid)']) total_line.extend(vip_level_lst) # -------------新增----------------- new_install_num = mysql_util.get_today_new_num( 'uid', 'EVENT_ACTION_ROLE_LOGIN' + str(date_str), row_date, -1, server_id) add_line.extend(['今日新增用户']) add_line.extend([new_install_num] * 15) # 首冲 first_recharge = mysql_util.get_first_recharge_shop_index_uid_num( 'uid', 'EVENT_ACTION_RECHARGE_PLAYER' + str(date_str), row_date, 'shop_index', -1, -1, server_id, row_date, row_date) # 月卡 month_card_recharge = mysql_util.get_recharge_shop_index_uid_num( 'uid', 'EVENT_ACTION_RECHARGE_PLAYER' + str(date_str), row_date, 'shop_index', 1, -1, server_id, row_date, row_date) # vip 新增充值 new_user_line.extend(['新增', first_recharge, month_card_recharge]) new_vip_level_lst = [0] * 13 new_uid_level_lst = mysql_util.get_vip_distributed_uid( 'EVENT_ACTION_ROLE_LOGIN' + str(date_str), -1, server_id, row_date, row_date) for _uid_level in new_uid_level_lst: _vip_level = int(_uid_level['vip_level']) new_vip_level_lst[_vip_level] = int(_uid_level['count(uid)']) new_user_line.extend(new_vip_level_lst) # -------------比率----------------- rate_line.extend(['比率']) for _index in xrange(2, 17): rate = division(new_user_line[_index], add_line[_index]) rate_line.append(str(rate * 100) + '%') table_result.extend([total_line, new_user_line, add_line, rate_line]) return table_result