1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121
| <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.example.mapper.ExaminationOrderMapper">
<select id="selectAll" resultType="com.example.entity.ExaminationOrder"> select examination_order.*, user.name as userName, doctor.name as doctorName, physical_examination.name as examinationName from `examination_order` left join user on examination_order.user_id = user.id left join doctor on examination_order.doctor_id = doctor.id left join physical_examination on examination_order.examination_id = physical_examination.id <where> <if test="orderNo != null"> and examination_order.order_no = #{orderNo}</if> <if test="orderType != null"> and examination_order.order_type = #{orderType}</if> <if test="status != null"> and examination_order.status = #{status}</if> <if test="userId != null"> and examination_order.user_id = #{userId}</if> <if test="doctorId != null"> and examination_order.doctor_id = #{doctorId}</if> <if test="reserveDate != null"> and examination_order.reserve_date = #{reserveDate}</if> </where> order by examination_order.id desc </select>
<delete id="deleteById"> delete from `examination_order` where id = #{id} </delete>
<insert id="insert" parameterType="com.example.entity.ExaminationOrder" useGeneratedKeys="true"> insert into `examination_order` <trim prefix="(" suffix=")" suffixOverrides=","> <if test="id != null">id,</if> <if test="orderNo != null">order_no,</if> <if test="userId != null">user_id,</if> <if test="doctorId != null">doctor_id,</if> <if test="examinationId != null">examination_id,</if> <if test="orderType != null">order_type,</if> <if test="reserveDate != null">reserve_date,</if> <if test="startTime != null">start_time,</if> <if test="endTime != null">end_time,</if> <if test="file != null">file,</if> <if test="comment != null">comment,</if> <if test="money != null">money,</if> <if test="status != null">status,</if> <if test="createTime != null">create_time,</if> <if test="checkTime != null">check_time,</if> <if test="feedback != null">feedback,</if> </trim> <trim prefix="values (" suffix=")" suffixOverrides=","> <if test="id != null">#{id},</if> <if test="orderNo != null">#{orderNo},</if> <if test="userId != null">#{userId},</if> <if test="doctorId != null">#{doctorId},</if> <if test="examinationId != null">#{examinationId},</if> <if test="orderType != null">#{orderType},</if> <if test="reserveDate != null">#{reserveDate},</if> <if test="startTime != null">#{startTime},</if> <if test="endTime != null">#{endTime},</if> <if test="file != null">#{file},</if> <if test="comment != null">#{comment},</if> <if test="money != null">#{money},</if> <if test="status != null">#{status},</if> <if test="createTime != null">#{createTime},</if> <if test="checkTime != null">#{checkTime},</if> <if test="feedback != null">#{feedback},</if> </trim> </insert>
<update id="updateById" parameterType="com.example.entity.ExaminationOrder"> update `examination_order` <set> <if test="orderNo != null"> order_no = #{orderNo}, </if> <if test="userId != null"> user_id = #{userId}, </if> <if test="doctorId != null"> doctor_id = #{doctorId}, </if> <if test="examinationId != null"> examination_id = #{examinationId}, </if> <if test="orderType != null"> order_type = #{orderType}, </if> <if test="reserveDate != null"> reserve_date = #{reserveDate}, </if> <if test="startTime != null"> start_time = #{startTime}, </if> <if test="endTime != null"> end_time = #{endTime}, </if> <if test="file != null"> file = #{file}, </if> <if test="comment != null"> comment = #{comment}, </if> <if test="money != null"> money = #{money}, </if> <if test="status != null"> status = #{status}, </if> <if test="createTime != null"> create_time = #{createTime}, </if> <if test="checkTime != null"> check_time = #{checkTime}, </if> <if test="feedback != null"> feedback = #{feedback}, </if> </set> where id = #{id} </update>
</mapper>
|