| | |
| | | <!--分页列表查询--> |
| | | <select id="pageList" resultType="org.jeecg.modules.quartz.dto.SysQuartzLogDto"> |
| | | SELECT |
| | | t2.job_name jobName, |
| | | t2.job_class_name jobClassName, |
| | | t2.cron_expression cronExpression, |
| | | t1.params params, |
| | |
| | | <if test="sysQuartzLogVo.startTime != null and sysQuartzLogVo.startTime != '' and sysQuartzLogVo.endTime != null and sysQuartzLogVo.endTime != ''"> |
| | | AND t1.create_time BETWEEN #{ sysQuartzLogVo.startTime } AND #{ sysQuartzLogVo.endTime } |
| | | </if> |
| | | <if test="sysQuartzLogVo.jobClassName != null and sysQuartzLogVo.jobClassName != ''"> |
| | | AND t2.job_class_name LIKE CONCAT(CONCAT('%',#{ sysQuartzLogVo.jobClassName }),'%') |
| | | <if test="sysQuartzLogVo.jobName != null and sysQuartzLogVo.jobName != ''"> |
| | | AND t2.job_name LIKE CONCAT(CONCAT('%',#{ sysQuartzLogVo.jobName }),'%') |
| | | </if> |
| | | <if test="sysQuartzLogVo.description != null and sysQuartzLogVo.description != ''"> |
| | | AND t2.description LIKE CONCAT(CONCAT('%',#{ sysQuartzLogVo.description }),'%') |
| | |
| | | |
| | | <select id="list" resultType="org.jeecg.modules.quartz.dto.SysQuartzLogDto"> |
| | | SELECT |
| | | t2.job_name jobName, |
| | | t2.job_class_name jobClassName, |
| | | t2.cron_expression cronExpression, |
| | | t1.params params, |
| | |
| | | <if test="sysQuartzLogVo.startTime != null and sysQuartzLogVo.startTime != '' and sysQuartzLogVo.endTime != null and sysQuartzLogVo.endTime != ''"> |
| | | AND t1.create_time BETWEEN #{ sysQuartzLogVo.startTime } AND #{ sysQuartzLogVo.endTime } |
| | | </if> |
| | | <if test="sysQuartzLogVo.jobClassName != null and sysQuartzLogVo.jobClassName != ''"> |
| | | AND t2.job_class_name LIKE CONCAT(CONCAT('%',#{ sysQuartzLogVo.jobClassName }),'%') |
| | | <if test="sysQuartzLogVo.jobName != null and sysQuartzLogVo.jobName != ''"> |
| | | AND t2.job_name LIKE CONCAT(CONCAT('%',#{ sysQuartzLogVo.jobName }),'%') |
| | | </if> |
| | | <if test="sysQuartzLogVo.description != null and sysQuartzLogVo.description != ''"> |
| | | AND t2.description LIKE CONCAT(CONCAT('%',#{ sysQuartzLogVo.description }),'%') |