| 5432 |
amar.kumar |
1 |
<?xml version="1.0" encoding="UTF-8"?>
|
|
|
2 |
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
|
|
|
3 |
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
|
|
|
4 |
|
|
|
5 |
<mapper namespace="in.shop2020.user.persistence.MiscellaneousMapper">
|
|
|
6 |
|
|
|
7 |
<resultMap type="usernote" id="usernoteResult">
|
|
|
8 |
<id property="id" column="id"/>
|
|
|
9 |
</resultMap>
|
|
|
10 |
|
|
|
11 |
<insert id="insertUserNote" parameterType="usernote" useGeneratedKeys="true" keyProperty="id">
|
|
|
12 |
INSERT INTO usercommunication
|
|
|
13 |
(user_id, entity_id, slide, note)
|
|
|
14 |
VALUES
|
|
|
15 |
(#{user_id}, #{entity_id}, #{slide}, #{note})
|
|
|
16 |
</insert>
|
|
|
17 |
|
|
|
18 |
<update id="updateUserNote" parameterType="map">
|
|
|
19 |
UPDATE usernote
|
|
|
20 |
SET note=#{note},
|
|
|
21 |
<where>
|
|
|
22 |
user_id = #{user_id}
|
|
|
23 |
AND entity_id = #{entity_id}
|
|
|
24 |
</where>
|
|
|
25 |
</update>
|
|
|
26 |
|
|
|
27 |
<select id="getUserNotes" parameterType="map" resultType="usernote">
|
|
|
28 |
SELECT *
|
|
|
29 |
FROM usernote
|
|
|
30 |
<where>
|
|
|
31 |
user_id = #{user_id}
|
|
|
32 |
AND entity_id = #{entity_id}
|
|
|
33 |
</where>
|
|
|
34 |
</select>
|
|
|
35 |
|
|
|
36 |
</mapper>
|