| 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.UserWidgetMapper">
|
|
|
6 |
|
|
|
7 |
<resultMap type="userwidgetitem" id="userwidgetitemResult">
|
|
|
8 |
<id property="id" column="id"/>
|
|
|
9 |
</resultMap>
|
|
|
10 |
|
|
|
11 |
<select id="getUserWidget" parameterType="String" resultType="userwidgetitem">
|
|
|
12 |
SELECT *
|
|
|
13 |
FROM userwidgetitem
|
|
|
14 |
<where>
|
|
|
15 |
userId = #{userId}
|
|
|
16 |
AND itemId = #{itemId}
|
|
|
17 |
</where>
|
|
|
18 |
</select>
|
|
|
19 |
|
|
|
20 |
<insert id="updateBrowseHistory" parameterType="userwidgetitem" useGeneratedKeys="true" keyProperty="id">
|
|
|
21 |
INSERT INTO userwidgetitem
|
|
|
22 |
(userId, widgetId, itemId, addedOn)
|
|
|
23 |
VALUES
|
|
|
24 |
(#{userId}, #{widgetId}, #{itemId}, #{addedOn})
|
|
|
25 |
</insert>
|
|
|
26 |
|
|
|
27 |
<select id="getMyResearchItems" parameterType="long" resultType="long">
|
|
|
28 |
SELECT itemId
|
|
|
29 |
FROM userwidgetitem
|
|
|
30 |
<where>
|
|
|
31 |
userId = #{userId}
|
|
|
32 |
AND widgetId=0
|
|
|
33 |
ORDER BY addedOn DESC
|
|
|
34 |
limit 10
|
|
|
35 |
</where>
|
|
|
36 |
</select>
|
|
|
37 |
|
|
|
38 |
<select id="getBrowseHistoryItems" parameterType="long" resultType="long">
|
|
|
39 |
SELECT itemId
|
|
|
40 |
FROM userwidgetitem
|
|
|
41 |
<where>
|
|
|
42 |
userId = #{userId}
|
|
|
43 |
AND widgetId=1
|
|
|
44 |
ORDER BY addedOn DESC
|
|
|
45 |
limit 10
|
|
|
46 |
</where>
|
|
|
47 |
</select>
|
|
|
48 |
|
|
|
49 |
<delete id="deleteItemFromMyResearch" parameterType="map">
|
|
|
50 |
delete from userwidgetitem
|
|
|
51 |
<where>
|
|
|
52 |
userId = #{userId}
|
|
|
53 |
AND itemId = #{itemId}
|
|
|
54 |
AND widgetId = 0
|
|
|
55 |
</where>
|
|
|
56 |
</delete>
|
|
|
57 |
|
|
|
58 |
<select id="getResearchWidget" parameterType="map" resultType="userwidgetitem">
|
|
|
59 |
SELECT *
|
|
|
60 |
FROM userwidgetitem
|
|
|
61 |
<where>
|
|
|
62 |
userId = #{userId}
|
|
|
63 |
AND widgetId=0
|
|
|
64 |
AND itemId=#{itemId}
|
|
|
65 |
</where>
|
|
|
66 |
</select>
|
|
|
67 |
|
|
|
68 |
<insert id="addUserWidgetItem" parameterType="userwidgetitem" useGeneratedKeys="true" keyProperty="id">
|
|
|
69 |
INSERT INTO userwidgetitem
|
|
|
70 |
(userId, widgetId, itemId, addedOn)
|
|
|
71 |
VALUES
|
|
|
72 |
(#{userId}, #{widgetId}, #{itemId}, #{addedOn})
|
|
|
73 |
</insert>
|
|
|
74 |
|
|
|
75 |
</mapper>
|