articleclass_sql.properties

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

# 添加栏目
add.class = insert into ARTICLE_CLASS \						(ARTICLE_CLASS_ID,CLASS_NAME,CLASS_REMARK,CLASS_TYPE, \
			CLASS_STATE,PARENT_ID,DEPTH,RESTRICT_ID,ACTION_ID, \
			REVIEW_RESTRICT_ID,OUTSIDE_URL,ORDER_NUM,ROOT_ID, \
			PREV_ID,NEXT_ID,PATH,CLASS_NAME2,CUSTOM_LINK,IS_SHOW) \
			values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

# 修改栏目
modify.class = update ARTICLE_CLASS set \
		CLASS_NAME = ? , CLASS_REMARK = ? ,CLASS_TYPE = ? , \
		PARENT_ID = ? ,DEPTH = ? ,RESTRICT_ID = ? ,ACTION_ID = ? , \
		REVIEW_RESTRICT_ID = ? ,OUTSIDE_URL = ? ,ROOT_ID = ? , \
		PREV_ID = ? ,NEXT_ID = ? ,PATH = ? , CLASS_NAME2 = ?, \
		CUSTOM_LINK = ? , IS_SHOW = ? \
		where ARTICLE_CLASS_ID = ?

# 取得子栏目(只取一级)
get.class = select * from ARTICLE_CLASS \
		where PARENT_ID = ? order by ORDER_NUM

# 取得子栏目数(只取一级)
get.class.count = select count(*) as COUNT from ARTICLE_CLASS \
		where PARENT_ID = ?

# 取得所有栏目（按ORDER_NUM排序）
get.all.class = select * from ARTICLE_CLASS order by PARENT_ID,ORDER_NUM

# 取得后台用户可管理的所有栏目
get.all.class.for.user = \
		select * from \
		(ARTICLE_CLASS t2 left join MAP_CLASS_USER t3 \
		on t2.ARTICLE_CLASS_ID = t3.ARTICLE_CLASS_ID) \
		where t3.UID = ? and t3.PURVIEW_TYPE = ? \
		order by t2.PARENT_ID,t2.ORDER_NUM

# 取得子栏目(一直至最低端)
# 第一个PATH like ?代表着精确匹配
# 第二个PATH like ?代表着子匹配(模糊匹配)
get.all.depth.class = select * from ARTICLE_CLASS \
			where PATH like ? or PATH like ?

# 根据栏目ID，取得栏目完整信息
get.class.info = select * from ARTICLE_CLASS \
			where ARTICLE_CLASS_ID = ?

# 取得新的栏目排序编号
get.class.ordernum = select ORDER_NUM from ARTICLE_CLASS \
			where PARENT_ID = ? order by ORDER_NUM desc

# 检测栏目ID是否已经存在
has.class.id = select COUNT(*) AS COUNT from ARTICLE_CLASS \
			where ARTICLE_CLASS_ID = ?

# 添加栏目的栏目编辑
add_class_users = insert into MAP_CLASS_USER \
				(ARTICLE_CLASS_ID,UID,PURVIEW_TYPE) \
				values (?,?,?)

# 取得某栏目拥有某权限的所有用户
get_class_users = select UID from MAP_CLASS_USER \
				where ARTICLE_CLASS_ID = ? AND PURVIEW_TYPE = ? order by ID

# 停用/启用某栏目
set_class_state = update ARTICLE_CLASS set CLASS_STATE = ? \
				where ARTICLE_CLASS_ID = ?

# 删除指定栏目(包括所有子栏目)
# 第一个PATH like ?代表着精确匹配
# 第二个PATH like ?代表着子匹配(模糊匹配)
del_class = delete from ARTICLE_CLASS \
			where PATH like ? or PATH like ?

# 删除指定栏目中的用户
del_class_users = delete from MAP_CLASS_USER \
			where ARTICLE_CLASS_ID = ?

# 栏目排序：取得上一栏目的排序编号
get_prev_class_order = select * from ARTICLE_CLASS \
			where PARENT_ID = ? and ORDER_NUM < ? \
			order by ORDER_NUM desc LIMIT 0,1

# 栏目排序：取得下一栏目的排序编号
get_next_class_order = select * from ARTICLE_CLASS \
			where PARENT_ID = ? and ORDER_NUM > ? \
			order by ORDER_NUM LIMIT 0,1

# 栏目排序：保存
set_class_order = update ARTICLE_CLASS set ORDER_NUM = ? \
			where ARTICLE_CLASS_ID = ?