Subversion Repositories SmartDukaan

Rev

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

Rev 4142 Rev 4241
Line 9... Line 9...
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, userEmailId, customerMobileNumber,
 13 
       ticketPriority, ticketStatus, ticketCategory, ticketDescription, userEmailId, customerMobileNumber,
14 
       isRead, customerEmailId, customerName)
 14 
       isRead, customerEmailId, customerName, attachments)
15 
    VALUES
 15 
    VALUES
16 
      (#{customerId}, #{ticketAssigneeId}, #{description}, #{ticketId}, #{creatorId}, #{type}, NOW(),
 16 
      (#{customerId}, #{ticketAssigneeId}, #{description}, #{ticketId}, #{creatorId}, #{type}, NOW(),
17 
       #{ticketPriority}, #{ticketStatus}, #{ticketCategory}, #{ticketDescription}, #{userEmailId},
 17 
       #{ticketPriority}, #{ticketStatus}, #{ticketCategory}, #{ticketDescription}, #{userEmailId},
18 
       #{customerMobileNumber}, #{isRead}, #{customerEmailId}, #{customerName})
 18 
       #{customerMobileNumber}, #{isRead}, #{customerEmailId}, #{customerName}, #{attachments})
19 
  </insert>
 19 
  </insert>
20
20
21 
  <select id="getActivities" parameterType="searchFilter" resultType="activity">
 21 
  <select id="getActivities" parameterType="searchFilter" resultType="activity">
22 
    SELECT *
 22 
    SELECT *
23 
    FROM activity
 23 
    FROM activity