1.表单统一验证方式,验证提交时显示不能为空
<form name="form" action="" data-validator-option="{theme:'yellow_right'}"></form>
<input type="text" style="width: 320px;" maxlength="150" value="${pd.CASE_NAME }" id="caseName" name="caseName" data-rule="required;length[1~50];">
2.sql
<!-- 列表 (数字转换为别名,时间转换,左查询,高级查询,截取20个字)-->
<select id="datalistPage" parameterType="page" resultType="pd">
select
a.P_ID,
b.TITLE,
c.COLUMN_NAME,
cm.USER_NAME INSERT_NAME,
a.CONTENT_ID,
a.WEBSITE_ID,
to_char(b.INSERT_TIME,'yyyy-mm-dd hh24:mi:ss') INSERT_TIME,
to_char(a.AUDIT_TIME,'yyyy-mm-dd hh24:mi:ss') AUDIT_TIME,
s.USER_NAME AUDITPERNAME,
a.SUGGESTION,
decode(a.STATE,2,'待审核',3,'已发布',4,'退回','') STATE_NAME
from CMS_CONTENT_PUSH_RECORD a
left join CMS_CONTENT b
on a.CONTENT_ID = b.CONTENT_ID
left join CMS_COLUMN c
on a.COLUMN_ID = c.COLUMN_ID
left join CMS_CONTENT_PUSH p
on a.CONTENT_ID = p.CONTENT_ID
left join CMS_WEBSITE_MANAGER s
on a.AUDIT_PER = s.USER_ID
left join CMS_WEBSITE_MANAGER cm
on(cm.USER_ID=p.INSERT_USER_ID)
where a.COLUMN_ID=p.COLUMN_ID
and a.AUDIT_PER =#{pd.auditPer,jdbcType=VARCHAR}
<if test="pd.title != null and pd.title != ''">
and b.TITLE LIKE '%'||#{pd.title,jdbcType=VARCHAR}||'%'
</if>
<if test="pd.insertName != null and pd.insertName != ''">
and cm.USER_NAME LIKE '%'||#{pd.insertName,jdbcType=VARCHAR}||'%'
</if>
<if test="pd.insertStartTime != null and pd.insertStartTime != ''">
and to_char(b.INSERT_TIME,'yyyy-mm-dd hh24:mi:ss') >=#{pd.insertStartTime,jdbcType=VARCHAR}
</if>
<if test="pd.insertEndTime != null and pd.insertEndTime != ''">
and to_char(b.INSERT_TIME,'yyyy-mm-dd hh24:mi:ss') <=#{pd.insertEndTime,jdbcType=VARCHAR}
</if>
<if test="pd.auditStartTime != null and pd.auditStartTime != ''">
and to_char(a.AUDIT_TIME,'yyyy-mm-dd hh24:mi:ss') >=#{pd.auditStartTime,jdbcType=VARCHAR}
</if>
<if test="pd.auditEndTime != null and pd.auditEndTime != ''">
and to_char(a.AUDIT_TIME,'yyyy-mm-dd hh24:mi:ss') <=#{pd.auditEndTime,jdbcType=VARCHAR}
</if>
<if test="pd.stateName != null and pd.stateName != ''">
and a.STATE =#{pd.stateName,jdbcType=VARCHAR}
</if>
order by a.INSERT_TIME DESC
</select>
<!--审核 -->
<update id="report" parameterType="pd">
update CMS_CONTENT_PUSH_RECORD a
<set>
<if test="auditPer != null">
a.AUDIT_PER = #{auditPer,jdbcType=VARCHAR} ,
</if>
a.AUDIT_TIME = to_date(#{auditTime,jdbcType=DATE},'yyyy-mm-dd hh24:mi:ss'),
<!-- <if test="columnId != null"> -->
<!-- column_Id = #{columnId,jdbcType=VARCHAR} , -->
<!-- </if> -->
<if test="state != null">
a.state = #{state,jdbcType=VARCHAR} ,
</if>
<if test="suggestion != null">
a.suggestion = #{suggestion,jdbcType=VARCHAR} ,
</if>
</set>
where a.P_ID = #{pId,jdbcType=VARCHAR}
</update>
<!-- 新增推送站点(时间的获取)-->
<insert id="saveSendWebSite" parameterType="pd">
insert into CMS_CONTENT_SEND_WEBSITE(
SEND_WEBSITE_ID,
SEND_ID,
WEBSITE_ID,
COLUMN_ID,
INSERT_TIME,
INSERT_USER_ID,
UPDATE_TIME,
UPDATE_USER_ID
) values (
#{sendWebsiteId,jdbcType=VARCHAR} ,
#{sendId,jdbcType=VARCHAR} ,
#{websiteId,jdbcType=VARCHAR} ,
#{columnId,jdbcType=VARCHAR} ,
SYSDATE,
#{insertUserId} ,
SYSDATE,
#{updateUserId}
)
</insert>
<!-- 通过id获取数据 -->
<select id="findIdstate" parameterType="pd" resultType="pd">
select
count(a.STATE) state
from CMS_TEMPLATE_SET a
where
a.CASE_ID ! = #{caseId,jdbcType=VARCHAR}
and a.STATE = #{state,jdbcType=INTEGER}
and a.WEBSITE_ID = #{websiteId,jdbcType=VARCHAR}
</select>
<!--截取20个字)-->
case when length(c.title)>20 then substr(c.title,0,19)||'...' else c.title end shotTitle,
3.ajax(只要进入这个页面就开始执行这个函数)
<a href="###" οnclick="clumnDay('1');"
class="text-danger btn month">今日</a>
$(function(){
clumnDay('1');
});
4.点击选择时间
<span>上报时间: <input type="text" name="reportStartTime" class="Wdate" id="reportStartTime" onClick="WdatePicker({dateFmt:'yyyy-MM-dd'});" /></span>
<span>至 <input type="text" name="reportEndTime" class="Wdate" id="reportEndTime" onClick="WdatePicker({dateFmt:'yyyy-MM-dd'});" /></span>
5.LUOYI!JIAYOU,JIU SUAN QUANSHIJIE BULIJIE NI WO YEHUI DENGNI
NI BINGBU RONGYI WO YOU HECHANG BUSHI