online_sql.properties

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

#########################################################
# 在线互动信息
#########################################################



# 添加一个在线互动信息
add.online = \
	insert into SITE_FORM (id,post_type,resv_user,uname,umail,utel,uzipcode,uaddr,title,content,send_time,form_type) values \
	(?,?,?,?,?,?,?,?,?,?,?,?)
#delete一个在线互动信息
delete.online=delete from SITE_FORM where id=? and form_type=?
#
getmaxid.online = \
    select max(id) as id from site_form where form_type=?
#################################################################
#   online标签中用到的SQL
#################################################################
# 根据不同的条件，取得不同用户的SQL模板
get.online.templet = \
	select * FROM SITE_FORM \
	where $WHERE order by $ORDER \
	limit $POSITION,$COUNTER


# 取得符合相关条件数据的条数
get.online.count.templet = \
	select count(*) as count FROM SITE_FORM \
	where $WHERE
#取本月的统计数
get.online.month.stat=\
	select count(*) from site_form WHERE YEAR(send_time)=YEAR(current_date()) \
	AND MONTH(send_time)=MONTH(current_date()) and form_type=?
#取本周的统计数
get.online.week.stat=\
	select count(*) from site_form WHERE YEAR(send_time)=YEAR(current_date()) \
	and MONTH(send_time)=MONTH(current_date()) and WEEK(send_time)=WEEK(current_date()) \
        and form_type=?
#取本日的统计数
get.online.today.stat=\
	select count(*) from site_form WHERE YEAR(send_time)=YEAR(current_date()) \
	 and MONTH(send_time)=MONTH(current_date()) and DAY(send_time)=DAY(current_date()) \
	 and form_type=?
#取所的的统计数
get.online.total.stat=select count(*) from site_form where form_type=?