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
