Subversion Repositories SmartDukaan

Rev

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

Rev 3206 Rev 3269
Line 8... Line 8...
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, type, creationTimestamp,
 12 
      (customerId, ticketAssigneeId, description, ticketId, creatorId, type, creationTimestamp,
13 
       ticketPriority, ticketStatus, ticketCategory, ticketDescription, emailId)
 13 
       ticketPriority, ticketStatus, ticketCategory, ticketDescription, emailId, customerMobileNumber)
14 
    VALUES
 14 
    VALUES
15 
      (#{customerId}, #{ticketAssigneeId}, #{description}, #{ticketId}, #{creatorId}, #{type}, NOW(),
 15 
      (#{customerId}, #{ticketAssigneeId}, #{description}, #{ticketId}, #{creatorId}, #{type}, NOW(),
16 
       #{ticketPriority}, #{ticketStatus}, #{ticketCategory}, #{ticketDescription}, #{emailId})
 16 
       #{ticketPriority}, #{ticketStatus}, #{ticketCategory}, #{ticketDescription}, #{emailId}, #{customerMobileNumber})
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}