Subversion Repositories SmartDukaan

Rev

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

Rev 3578 Rev 4142
Line 43... Line 43...
43 
      customerName = #{customerName},
 43 
      customerName = #{customerName},
44 
    </if>
 44 
    </if>
45 
    <if test="customerMobileNumber != null">
 45 
    <if test="customerMobileNumber != null">
46 
      customerMobileNumber = #{customerMobileNumber},
 46 
      customerMobileNumber = #{customerMobileNumber},
47 
    </if>
 47 
    </if>
48 
    <if test="status != null">
 - 
 
49 
      status = #{status},
 - 
 
50 
    </if>
 - 
 
51 
    <if test="priority != null">
 - 
 
52 
      priority = #{priority},
 - 
 
53 
    </if>
 - 
 
54 
    <if test="category != null">
 - 
 
55 
      category = #{category},
 - 
 
56 
    </if>
 - 
 
57 
    closeDate = #{closeDate}
 48 
    closeDate = #{closeDate}
58 
    WHERE id = #{id}
 49 
    WHERE id = #{id}
59 
  </update>
 50 
  </update>
60 
 
 51 
 
61 
  <select id="getUnassignedTickets" resultType="ticket">
 52 
  <select id="getUnassignedTickets" resultType="ticket">
Line 105... Line 96...
105 
    </if>
 96 
    </if>
106 
    <if test="ticketCategory != null">
 97 
    <if test="ticketCategory != null">
107 
        AND category = #{ticketCategory}
 98 
        AND category = #{ticketCategory}
108 
    </if>
 99 
    </if>
109 
    </where>
 100 
    </where>
110 
    ORDER BY openDate DESC
 101 
    ORDER BY openDate
111 
  </select>
 102 
  </select>
112 
</mapper>
 103 
</mapper>