Subversion Repositories SmartDukaan

Rev

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

Rev 3137 Rev 3269
Line 8... Line 8...
8 
  </resultMap>
 8 
  </resultMap>
9 
 
 9 
 
10 
  <insert id="insertTicket" parameterType="ticket" useGeneratedKeys="true" keyProperty="id">
 10 
  <insert id="insertTicket" parameterType="ticket" useGeneratedKeys="true" keyProperty="id">
11 
    INSERT INTO ticket
 11 
    INSERT INTO ticket
12 
      (customerId, openDate, closeDate, creatorId, description, assigneeId, status,
 12 
      (customerId, openDate, closeDate, creatorId, description, assigneeId, status,
13 
       priority, category, productName, airwayBillNo, orderId)
 13 
       priority, category, productName, airwayBillNo, orderId, customerEmailId)
14 
    VALUES
 14 
    VALUES
15 
      (#{customerId}, NOW(),  #{closeDate},  #{creatorId}, #{description}, #{assigneeId}, #{status},
 15 
      (#{customerId}, NOW(),  #{closeDate},  #{creatorId}, #{description}, #{assigneeId}, #{status},
16 
       #{priority}, #{category}, #{productName}, #{airwayBillNo}, #{orderId})
 16 
       #{priority}, #{category}, #{productName}, #{airwayBillNo}, #{orderId}, #{customerEmailId})
17 
  </insert>
 17 
  </insert>
18
18
19 
  <update id="updateTicket" parameterType="ticket">
 19 
  <update id="updateTicket" parameterType="ticket">
20 
    UPDATE ticket
 20 
    UPDATE ticket
21 
    SET
 21 
    SET