<?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.ruoyi.reservation.mapper.ReservationSlaveMapper">

	<insert id="saveSlaveReservation" parameterType="Reservation">
		insert into lbl.tb_reservation(id, car_number, examine_state, message, third_flag, create_time)
        values (#{id}, #{carNumber}, #{examineState}, #{message}, #{thirdFlag}, sysdate())
	</insert>

	<resultMap type="Reservation" id="ReservationResult">
		<result property="id"    column="id"    />
		<result property="carNumber"    column="car_number"    />
		<result property="examineState"    column="examine_state"    />
		<result property="message"    column="message"    />
		<result property="thirdFlag"    column="third_flag"    />
		<result property="createBy"    column="create_by"    />
		<result property="createTime"    column="create_time"    />
		<result property="updateBy"    column="update_by"    />
		<result property="updateTime"    column="update_time"    />
	</resultMap>

	<sql id="selectReservationVo">
		select id, car_number, examine_state, message, third_flag, create_by, create_time, update_by, update_time from lbl.tb_reservation
	</sql>

	<select id="selectSlaveReservationList" parameterType="Reservation" resultMap="ReservationResult">
		<include refid="selectReservationVo"/>
		<where>
			<if test="carNumber != null  and carNumber != ''"> and car_number like concat('%', #{carNumber}, '%')</if>
			<if test="examineState != null  and examineState != ''"> and examine_state = #{examineState}</if>
			<if test="message != null  and message != ''"> and message like concat('%', #{message}, '%')</if>
			<if test="thirdFlag != null  and thirdFlag != ''"> and third_flag = #{thirdFlag}</if>
		</where>
	</select>

</mapper>
