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 >= #{startDate}

        AND added_on <= #{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>