<!-- 查询 访问量 统计的 条件 公用 保持数据一致性-->
<sql id="recordStateWhere">
<if test="startDate != null"> and sys_browse_record.create_at <![CDATA[>=]]> #{startDate} </if>
<if test="endDate != null"> and sys_browse_record.create_at <![CDATA[<]]> #{endDate} </if>
<if test="menuName != null and menuName !=''"> and sys_browse_record.page_name like concat('%',#{menuName},'%') </if>
<if test="userName != null and userName !=''"> and sys_browse_record.user_name =#{userName} </if>
</sql>
<select id="selectSysBrowseRecordList" parameterType="SysBrowseRecordStatisticQuery" resultMap="SysBrowseRecordResult">
<include refid="selectSysBrowseRecordVo"/>
where deleted = false
<include refid="recordStateWhere"/>
order by create_at desc
</select>
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交