Subversion Repositories SmartDukaan

Rev

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

Rev 3106 Rev 3137
Line 46... Line 46...
46
46
47 
  <select id="getTicket" parameterType="long" resultType="ticket">
 47 
  <select id="getTicket" parameterType="long" resultType="ticket">
48 
    SELECT * FROM ticket
 48 
    SELECT * FROM ticket
49 
    WHERE id = #{ticketId}
 49 
    WHERE id = #{ticketId}
50 
  </select>
 50 
  </select>
51 
</mapper>
 - 
 
52 

            51
            
  

          

          

            -
            
 

            52
            
  <select id="getAssignedTickets" parameterType="long" resultType="ticket">

          

          

            -
            
 

            53
            
    SELECT * FROM ticket

          

          

            -
            
 

            54
            
    WHERE assigneeId = #{agentId}

          

          

            -
            
 

            55
            
    ORDER BY openDate DESC

          

          

            -
            
 

            56
            
  </select>

          

          

            -
            
 

            57
            
 

          

          

            -
            
 

            58
            
  <select id="getUnassignedTickets" resultType="ticket">

          

          

            -
            
 

            59
            
    SELECT * FROM ticket

          

          

            -
            
 

            60
            
    WHERE assigneeId IS NULL

          

          

            -
            
 

            61
            
    ORDER BY openDate DESC

          

          

            -
            
 

            62
            
  </select>

          

          

            -
            
 

            63
            
</mapper>

          

          

            -
            
 

            64