Subversion Repositories SmartDukaan

Rev

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

Rev 4793 Rev 5168
Line 61... Line 61...
61 
    SELECT * FROM ticket
 61 
    SELECT * FROM ticket
62 
    WHERE assigneeId IS NULL
 62 
    WHERE assigneeId IS NULL
63 
    ORDER BY openDate DESC
 63 
    ORDER BY openDate DESC
64 
  </select>
 64 
  </select>
65 
 
 65 
 
- 
 
 66 
  <select id="getOpenTicketCountForAgent" parameterType="long" resultType="int">
- 
 
 67 
  	SELECT count(*) FROM ticket
- 
 
 68 
  	WHERE assigneeId = #{agentId}
- 
 
 69 
  		AND status != 2
- 
 
 70 
  </select>
66 
  <select id="getTickets" parameterType="searchFilter" resultType="ticket">
 71 
  <select id="getTickets" parameterType="searchFilter" resultType="ticket">
67 
    SELECT *
 72 
    SELECT *
68 
    FROM ticket
 73 
    FROM ticket
69 
    <where>
 74 
    <where>
70 
    <if test="ticketId != null">
 75 
    <if test="ticketId != null">