a.id AS "id", a.job_info AS "jobInfo", a.job_name AS "jobName", a.job_group AS "jobGroup", a.job_cls AS "jobCls", a.time_format AS "timeFormat", a.last_execute_time AS "lastExecuteTime", a.state AS "state", a.execute_state AS "executeState", a.create_by AS "createBy.id", a.create_date AS "createDate", a.update_by AS "updateBy.id", a.update_date AS "updateDate", a.remarks AS "remarks", a.del_flag AS "delFlag" SELECT FROM task_trigger a WHERE a.id = #{id} SELECT FROM task_trigger a a.del_flag = #{DEL_FLAG_NORMAL} AND a.job_name = #{jobName} AND a.job_group = #{jobGroup} AND a.last_execute_time = #{lastExecuteTime} ORDER BY ${page.orderBy} ORDER BY a.create_date ASC SELECT FROM task_trigger a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO task_trigger( id, job_info, job_name, job_group, job_cls, time_format, last_execute_time, state, create_by, create_date, update_by, update_date, remarks, del_flag ) VALUES ( #{id}, #{jobInfo}, #{jobName}, #{jobGroup}, #{jobCls}, #{timeFormat}, #{lastExecuteTime}, #{state}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag} ) UPDATE task_trigger SET job_info = #{jobInfo}, job_name = #{jobName}, job_group = #{jobGroup}, job_cls = #{jobCls}, time_format = #{timeFormat}, last_execute_time = #{lastExecuteTime}, state = #{state}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks} WHERE id = #{id} UPDATE task_trigger SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} UPDATE task_trigger SET state = #{state} WHERE id = #{id} and state = '0' SELECT FROM task_trigger a a.del_flag = '0' UPDATE task_trigger SET last_execute_time = #{date} where job_name = #{jobName} and del_flag = '0' UPDATE task_trigger SET execute_state = #{executeState} where job_name = #{jobName} and del_flag = '0' and execute_state = '0' and execute_state = '1' SELECT FROM task_trigger a where job_name = #{jobName} and del_flag = '0'