Subversion Repositories SmartDukaan

Rev

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

Rev 4142 Rev 4793
Line 15... Line 15...
15 
    VALUES
 15 
    VALUES
16 
      (#{customerId}, NOW(),  #{closeDate},  #{creatorId}, #{description}, #{assigneeId}, #{status},
 16 
      (#{customerId}, NOW(),  #{closeDate},  #{creatorId}, #{description}, #{assigneeId}, #{status},
17 
       #{priority}, #{category}, #{productName}, #{airwayBillNo}, #{orderId}, #{customerEmailId},
 17 
       #{priority}, #{category}, #{productName}, #{airwayBillNo}, #{orderId}, #{customerEmailId},
18 
       #{customerMobileNumber}, #{customerName})
 18 
       #{customerMobileNumber}, #{customerName})
19 
  </insert>
 19 
  </insert>
20 
 
 20
- 
 
 21 
  <update id="unassignAgentTickets" parameterType="int">
- 
 
 22 
  	UPDATE ticket
- 
 
 23 
  	SET assigneeId = NULL
- 
 
 24 
  	WHERE	assigneeId = #{assigneeId}
- 
 
 25 
  		AND status != 2
- 
 
 26
- 
 
 27 
  </update>
- 
 
 28
21 
  <update id="updateTicket" parameterType="ticket">
 29 
  <update id="updateTicket" parameterType="ticket">
22 
    UPDATE ticket
 30 
    UPDATE ticket
23 
    SET
 31 
    SET
24 
    <if test="assigneeId != null">
 32 
    <if test="assigneeId != null">
25 
      assigneeId = #{assigneeId},
 33 
      assigneeId = #{assigneeId},