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.TrackMapper">
<resultMap type="tracker" id="trackerResult">
                <id property="id" column="id"/>
</resultMap>
<resultMap type="tracklog" id="tracklogResult">
                <id property="id" column="id"/>
</resultMap>

<select id="getTrackLogById" parameterType="long" resultType="tracklog">
    SELECT *
    FROM tracklog
    <where>
        id = #{id}
        </where>
</select>

<select id="getTrackerById" parameterType="long" resultType="tracker">
    SELECT *
    FROM tracker
    <where>
        id = #{id}
        </where>
</select>

<select id="getTrackLogsByUser" parameterType="long" resultType="tracklog">
    SELECT *
    FROM tracklog
    <where>
        user_id = #{userId}
        </where>
</select>

<select id="getTrackLogs" parameterType="map" resultType="tracklog">
    SELECT *
    FROM tracklog
    <where>
        user_id = #{userId}
        AND event = #{event}
        AND url = #{url}
        </where>
</select>

<select id="getTrackLogsByAffiliate" parameterType="map" resultType="tracklog">
    SELECT *
    FROM tracklog
    <where>
        affiliate_id = #{affiliateId}
        AND added_on &gt;= #{startDate}
        AND added_on &lt;= #{endDate}
        </where>
</select>

<insert id="addTrackLog" parameterType="tracklog" useGeneratedKeys="true" keyProperty="id">
    INSERT INTO activity
      (added_on, user_id, event, url, data, event_id)
    VALUES
      (#{added_on}, #{user_id}, #{event}, #{url}, #{data}, #{event_id})
</insert>

</mapper>