search

rcom10002 / ccgclient

Automatically exported from code.google.com/p/ccgclient
0 stars 1 forks source link

业务分析报表 #14

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
查询条件：用户id(即user_id，非必填项)，查询的时间区间段(��
�填项)，状态(单选，必填项，全部、
胜、负、平)

显示结果：玩家id、游戏id、游戏类型、游戏日期、状态、得�
��、时间开始、时间结束

排序：玩家创建日期、游戏类型、游戏创建日期

Original issue reported on code.google.com by rcom10002 on 2 Aug 2009 at 2:12

GoogleCodeExporter commented 9 years ago 
over

Original comment by songjie8...@gmail.com on 3 Aug 2009 at 3:52

GoogleCodeExporter commented 9 years ago 
业务分析报表、积分结算报表

增加一个rls_path字段，即将原来的SQL改为 SELECT XXX FROM XXX WHERE 
XXX AND (? is null or 
rls_path like ? || '%')

rls_path 
指的是用户间上下级关系，如果用户id为user1，他所创建的直�
��用户rls_path就为
user1!user_created_by_user1，下级用户创建的下下级则为
user1!user_created_by_user1!third_level_user

根据新的SQL，就可以查询到某个用户下所有用户的相关情况��
�

Original comment by rcom10002 on 4 Aug 2009 at 12:33

GoogleCodeExporter commented 9 years ago 
已加上，等下级用户创建后再测测~

Original comment by songjie8...@gmail.com on 4 Aug 2009 at 3:12

GoogleCodeExporter commented 9 years ago 
我尽快把用户层次功能给做出来，那时候cc给你，你测一下哈

Original comment by rcom10002 on 4 Aug 2009 at 3:17