Subversion Repositories SmartDukaan

Rev

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

Rev 14910 Rev 16208
Line 64... Line 64...
64 
        <foreach collection="ticketAssigneeIds" item="ticketAssigneeId"
 64 
        <foreach collection="ticketAssigneeIds" item="ticketAssigneeId"
65 
                 index="index" open="(" close=")" separator=",">
 65 
                 index="index" open="(" close=")" separator=",">
66 
            #{ticketAssigneeId}
 66 
            #{ticketAssigneeId}
67 
        </foreach>
 67 
        </foreach>
68 
    </if>
 68 
    </if>
69 
    <if test="notShowPmTickets != null">
 69 
    <if test="notShowPmTickets != null and notShowPmTickets == true">
70 
        AND ticketCategory not IN
70 
        AND ticketCategory not IN
71 
    	<foreach collection="ticketCategoryList" item="tkCategory"
71 
    	<foreach collection="ticketCategoryList" item="tkCategory"
72 
    			 index="index" open="(" close=")" separator=",">
 72 
    			 index="index" open="(" close=")" separator=",">
73 
    		#{tkCategory}
 73 
    		#{tkCategory}
74 
    	</foreach>
 74 
    	</foreach>
75 
    </if>
 75 
    </if>
- 
 
 76 
    <if test="notShowPmTickets != null and notShowPmTickets == false">
- 
 
 77 
        AND ticketCategory IN
- 
 
 78 
    	<foreach collection="ticketCategoryList" item="tkCategory"
- 
 
 79 
    			 index="index" open="(" close=")" separator=",">
- 
 
 80 
    		#{tkCategory}
- 
 
 81 
    	</foreach>
- 
 
 82 
    </if>
76 
    </where>
 83 
    </where>
77 
    ORDER BY creationTimestamp DESC
 84 
    ORDER BY creationTimestamp DESC
78 
  </select>
 85 
  </select>
79 
 
 86 
 
80 
  <update id="markAsRead" parameterType="long">
 87 
  <update id="markAsRead" parameterType="long">