Subversion Repositories SmartDukaan

Rev

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

Rev 3390 Rev 3499
Line 57... Line 57...
57 
      customerName = #{customerName},
 57 
      customerName = #{customerName},
58 
    </if>
 58 
    </if>
59 
    <if test="customerMobileNumber != null">
 59 
    <if test="customerMobileNumber != null">
60 
      customerMobileNumber = #{customerMobileNumber},
 60 
      customerMobileNumber = #{customerMobileNumber},
61 
    </if>
 61 
    </if>
- 
 
 62 
    <if test="status != null">
- 
 
 63 
      status = #{status},
- 
 
 64 
    </if>
- 
 
 65 
    <if test="priority != null">
- 
 
 66 
      priority = #{priority},
- 
 
 67 
    </if>
- 
 
 68 
    <if test="category != null">
- 
 
 69 
      category = #{category},
- 
 
 70 
    </if>
62 
    closeDate = #{closeDate}
 71 
    closeDate = #{closeDate}
63 
    WHERE id = #{id}
 72 
    WHERE id = #{id}
64 
  </update>
 73 
  </update>
65 
 
 74 
 
66 
  <select id="getUnassignedTickets" resultType="ticket">
 75 
  <select id="getUnassignedTickets" resultType="ticket">
Line 110... Line 119...
110 
        AND t.customerEmailId = #{customerEmailId}
 119 
        AND t.customerEmailId = #{customerEmailId}
111 
    </if>
 120 
    </if>
112 
    <if test="customerMobileNumber != null">
 121 
    <if test="customerMobileNumber != null">
113 
        AND t.customerMobileNumber = #{customerMobileNumber}
 122 
        AND t.customerMobileNumber = #{customerMobileNumber}
114 
    </if>
 123 
    </if>
- 
 
 124 
    <if test="ticketStatus != null">
- 
 
 125 
        AND status = #{ticketStatus}
- 
 
 126 
    </if>
- 
 
 127 
    <if test="ticketPriority != null">
- 
 
 128 
        AND priority = #{ticketPriority}
- 
 
 129 
    </if>
- 
 
 130 
    <if test="ticketCategory != null">
- 
 
 131 
        AND category = #{ticketCategory}
- 
 
 132 
    </if>
115 
    </where>
 133 
    </where>
116 
    ORDER BY t.openDate DESC
 134 
    ORDER BY t.openDate DESC
117 
  </select>
 135 
  </select>
118 
</mapper>
 136 
</mapper>