Subversion Repositories SmartDukaan

<?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="in.shop2020.user.persistence.UserWidgetMapper">

<resultMap type="userwidgetitem" id="userwidgetitemResult">
                <id property="id" column="id"/>
</resultMap>

<select id="getUserWidget" parameterType="String" resultType="userwidgetitem">
    SELECT *
    FROM userwidgetitem
    <where>
        userId = #{userId}
        AND itemId = #{itemId}
        </where>
</select>

<insert id="updateBrowseHistory" parameterType="userwidgetitem" useGeneratedKeys="true" keyProperty="id">
    INSERT INTO userwidgetitem
    (userId, widgetId, itemId, addedOn)
    VALUES
    (#{userId}, #{widgetId}, #{itemId}, #{addedOn})
</insert>

<select id="getMyResearchItems" parameterType="long" resultType="long">
    SELECT itemId
    FROM userwidgetitem
    <where>
        userId = #{userId}
                AND widgetId=0
        ORDER BY addedOn DESC
        limit 10
        </where>
</select>

<select id="getBrowseHistoryItems" parameterType="long" resultType="long">
    SELECT itemId
    FROM userwidgetitem
    <where>
        userId = #{userId}
                AND widgetId=1
        ORDER BY addedOn DESC
        limit 10
        </where>
</select>

<delete id="deleteItemFromMyResearch" parameterType="map">
   delete from userwidgetitem
   <where>
        userId = #{userId}
                AND itemId = #{itemId}
                AND widgetId = 0
   </where>
</delete>

<select id="getResearchWidget" parameterType="map" resultType="userwidgetitem">
    SELECT *
    FROM userwidgetitem
    <where>
        userId = #{userId}
                AND widgetId=0
                AND itemId=#{itemId}
        </where>
</select>

<insert id="addUserWidgetItem" parameterType="userwidgetitem" useGeneratedKeys="true" keyProperty="id">
    INSERT INTO userwidgetitem
    (userId, widgetId, itemId, addedOn)
    VALUES
    (#{userId}, #{widgetId}, #{itemId}, #{addedOn})
</insert>

</mapper>