Subversion Repositories SmartDukaan

Rev

Rev 7636 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 7636 Rev 14882
Line 108... Line 108...
108
        AND priority = #{ticketPriority}
108
        AND priority = #{ticketPriority}
109
    </if>
109
    </if>
110
    <if test="ticketCategory != null">
110
    <if test="ticketCategory != null">
111
        AND category = #{ticketCategory}
111
        AND category = #{ticketCategory}
112
    </if>
112
    </if>
-
 
113
    <if test="ticketCategoryList != null">
-
 
114
    	AND category IN 
-
 
115
    	<foreach collection="ticketCategoryList" item="tkCategory" 
-
 
116
    			 index="index" open="(" close=")" separator=",">
-
 
117
    		#{tkCategory}
-
 
118
    	</foreach>
-
 
119
    </if>
113
    </where>
120
    </where>
114
    ORDER BY openDate
121
    ORDER BY openDate
115
  </select>
122
  </select>
116
  
123
  
117
  <select id="getOpenTicketsMap" resultType="map">
124
  <select id="getOpenTicketsMap" resultType="map">