sa_sql.properties

CMS4J 是 JAVA / JSP 版网站管理系统 （Content Manage System For Java）的简称

#########################################################
# 用户信息
#########################################################

# 某一用户是否存在
exist.user = \
	select COUNT(*) as COUNT from SA_USER where UID = ?

# 添加一个新用户
add.user = \
	insert into SA_USER \
	(UID,NAME,PWD,SEX,AGE,JOIN_DATE,LOGINS,BIRTH,OICQ,ICQ,MAIL,MSN,HOMEPAGE, \
	LAST_LOGIN_DATE,LAST_LOGIN_IP,QUESTION,ANSWER,TEL,FRONT_GROUP_ID,BACK_GROUP_ID, \
	STATE,ENABLE_MULTI_LOGIN,ADMIN_LEVEL_ARTICLE,REMARK,POINT,AUDIT_LEVEL) \
	values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

# 修改用户信息
modify.user = \
	update SA_USER set \
	NAME=?,SEX=?,AGE=?,BIRTH=?,OICQ=?,ICQ=?,MAIL=?,MSN=?,HOMEPAGE=?, \
	QUESTION=?,ANSWER=?,TEL=?,FRONT_GROUP_ID=?,BACK_GROUP_ID=?, \
	ENABLE_MULTI_LOGIN=?,ADMIN_LEVEL_ARTICLE=?,REMARK=?,POINT=?,AUDIT_LEVEL=? \
	where UID = ?

# 取得用户可管理的栏目
get.class.purview = \
	select * from MAP_CLASS_USER \
	where UID = ? and PURVIEW_TYPE = ?

# 取得用户可管理的模块
get.module.purview = \
	select * from MAP_USER_MODULE where UID = ?

# 设置用户与可管理的栏目映射
set.class.purview = \
	insert into MAP_CLASS_USER \
	(UID,ARTICLE_CLASS_ID,PURVIEW_TYPE) \
	values (?,?,?)

# 设置用户与模块权限映射
set.module.purview = \
	insert into MAP_USER_MODULE \
	(UID,MODULE_ID,MODULE_TYPE) \
	values (?,?,?)

# 删除某用户:用户表 SA_USER
# 相关表 SA_USER | MAP_USER_MODULE | MAP_CLASS_USER
del.user.sa_user = \
	delete from SA_USER where UID = ?

# 删除某用户:模块映射表 MAP_USER_MODULE
del.user.map_user_module = \
	delete from MAP_USER_MODULE \
	where UID = ?

# 删除某用户:栏目映射表 MAP_CLASS_USER
del.user.map_class_user = \
	delete from MAP_CLASS_USER \
	where UID = ?

# 移动用户至另一个组
move.user = \
	update SA_USER set \
	FRONT_GROUP_ID = ? \
	where UID = ?

# 修改用户状态
modify.user.state = \
	update SA_USER set \
	STATE = ? \
	where UID = ?

# 修改用户密码
modify.user.pwd = \
	update SA_USER set \
	PWD = ? \
	where UID = ?

# 取得某一用户
get.user = \
	select * from SA_USER where UID = ?

# 取得用户的数量
get.user.count = select count(*) as count from SA_USER

# 取得前台用户而不是管理员用户的数量
get.user.count.front = \
	select count(*) as count from SA_USER \
	where BACK_GROUP_ID = '901'

# 取得管理员数量
get.user.count.back = \
	select count(*) as count from SA_USER \
	where BACK_GROUP_ID <> '901'


#########################################################
# 组信息
#########################################################
get.front.group.name = \
	select NAME from SA_GROUP \
	where $WHERE



#################################################################
#   User标签中用到的SQL
#################################################################
# 根据不同的条件，取得不同用户的SQL模板
get.user.templet = \
	select * FROM SA_USER \
	where $WHERE order by $ORDER \
	limit $POSITION,$COUNTER


# 取得符合相关条件数据的条数
get.user.count.templet = \
	select count(*) as count FROM SA_USER \
	where $WHERE

# 用户范围SQL模板
user.scope.templet = \
	UID IN($SCOPE)

# 前台用户组范围SQL模板
front.group.scope.templet = \
	FRONT_GROUP_ID IN($SCOPE)

# 后台用户组范围SQL模板
back.group.scope.templet = \
	BACK_GROUP_ID IN($SCOPE)


#################################################################
#   Module标签中用到的SQL
#################################################################
# 根据不同的条件，取得不同模块的SQL模板
get.module.templet = \
	select * FROM SYS_MODULE \
	where $WHERE order by $ORDER

#更新用户登录信息
#20060109 add by ypfan
set.user.login_info= \
	insert into LOGIN_INFO (UID,LOGIN_IP,LOGIN_HOST,LOGIN_DATE) values (?,?,?,?)

update.user.login_info= \
	update SA_USER set LAST_LOGIN_IP=?,LAST_LOGIN_DATE=?,LOGINS=LOGINS+1 where UID = ?