<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.kmall.schedule.dao.ScheduleJobLogDao">
	<select id="queryObject" resultType="com.kmall.schedule.entity.ScheduleJobLogEntity" >
		select * from schedule_job_log where log_id = #{value}
	</select> 

	<select id="queryList" resultType="com.kmall.schedule.entity.ScheduleJobLogEntity" >
		select * from schedule_job_log 
		<where>
			<if test="jobId != null and jobId != ''">
				and job_id = #{jobId}
			</if>
		</where>
		order by log_id desc 
		<if test="offset != null and limit != null ">
		limit #{offset}, #{limit}
		</if>
	</select>
	
 	<select id="queryTotal" resultType="int">
		select count(1) from schedule_job_log 
		<where>
			<if test="jobId != null and jobId != ''">
				and job_id = #{jobId}
			</if>
		</where>
	</select>
	 
	<insert id="save" parameterType="com.kmall.schedule.entity.ScheduleJobLogEntity">
		insert into schedule_job_log
		(
			`job_id`, 
			`bean_name`, 
			`method_name`, 
			`params`, 
			`status`, 
			`error`, 
			`times`, 
			`create_time`
		)
		values
		(
			#{jobId}, 
			#{beanName}, 
			#{methodName}, 
			#{params}, 
			#{status}, 
			#{error}, 
			#{times}, 
			#{createTime}
		)
	</insert>
	
</mapper>