Subversion Repositories SmartDukaan

Rev

Rev 3024 | Rev 3206 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 3024 Rev 3106
Line 7... Line 7...
7 
    <id property="id" column="id"/>
 7 
    <id property="id" column="id"/>
8 
  </resultMap>
 8 
  </resultMap>
9 
 
 9 
 
10 
  <insert id="insertActivity" parameterType="activity" useGeneratedKeys="true" keyProperty="id">
 10 
  <insert id="insertActivity" parameterType="activity" useGeneratedKeys="true" keyProperty="id">
11 
    INSERT INTO activity
 11 
    INSERT INTO activity
12 
      (customerId, ticketAssigneeId, description, ticketId, creatorId, contactMedium, contactTimestamp,
 12 
      (customerId, ticketAssigneeId, description, ticketId, creatorId, type, creationTimestamp,
13 
      ticketPriority, ticketStatus, contactingAgentId, ticketCategory)
 13 
       ticketPriority, ticketStatus, ticketCategory, ticketDescription)
14 
    VALUES
 14 
    VALUES
15 
      (#{customerId}, #{ticketAssigneeId}, #{description}, #{ticketId}, #{creatorId}, #{contactMedium}, #{contactTimestamp},
 15 
      (#{customerId}, #{ticketAssigneeId}, #{description}, #{ticketId}, #{creatorId}, #{type}, NOW(),
16 
       #{ticketPriority}, #{ticketStatus}, #{contactingAgentId}, #{ticketCategory})
 16 
       #{ticketPriority}, #{ticketStatus}, #{ticketCategory}, #{ticketDescription})
17 
  </insert>
 17 
  </insert>
18
18
19 
  <select id="getActivities" parameterType="long" resultType="activity">
 19 
  <select id="getActivities" parameterType="long" resultType="activity">
20 
    SELECT * FROM activity
 20 
    SELECT * FROM activity
21 
    WHERE customerId = #{customerId}
 21 
    WHERE customerId = #{customerId}
22 
    ORDER BY contactTimestamp DESC
 22 
    ORDER BY creationTimestamp DESC
23 
  </select>
 23 
  </select>
24 
 
 24 
 
25 
  <select id="getActivitiesForTicket" parameterType="long" resultType="activity">
 25 
  <select id="getActivitiesForTicket" parameterType="long" resultType="activity">
26 
    SELECT * FROM activity
 26 
    SELECT * FROM activity
27 
    WHERE ticketId = #{ticketId}
 27 
    WHERE ticketId = #{ticketId}
28 
    ORDER BY contactTimestamp DESC
 28 
    ORDER BY creationTimestamp DESC
29 
  </select>
 29 
  </select>
30 
 
 30 
 
31 
  <select id="getActivity" parameterType="long" resultType="activity">
 31 
  <select id="getActivity" parameterType="long" resultType="activity">
32 
    SELECT * FROM activity
 32 
    SELECT * FROM activity
33 
    WHERE id = #{activityId}
 33 
    WHERE id = #{activityId}
34 
  </select>
 34 
  </select>
35
35
36 
  <select id="getLastActivity" parameterType="long" resultType="activity">
 36 
  <select id="getLastActivity" parameterType="long" resultType="activity">
37 
    SELECT * FROM activity
 37 
    SELECT * FROM activity
38 
    WHERE ticketId = #{ticketId}
 38 
    WHERE ticketId = #{ticketId}
39 
    ORDER BY contactTimestamp DESC
 39 
    ORDER BY creationTimestamp DESC
40 
    LIMIT 1
 40 
    LIMIT 1
41 
  </select>
 41 
  </select>
42 
</mapper>
 42 
</mapper>
43 

            43