Subversion Repositories SmartDukaan

Rev

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

Rev 3137 Rev 3339
Line 43... Line 43...
43
43
44 
  <select id="getReportees" parameterType="long" resultType="agent">
 44 
  <select id="getReportees" parameterType="long" resultType="agent">
45 
    SELECT * FROM agent
 45 
    SELECT * FROM agent
46 
    WHERE managerId = #{agentId}
 46 
    WHERE managerId = #{agentId}
47 
  </select>
 47 
  </select>
- 
 
 48
- 
 
 49 
  <select id="getLastEmailProcessedTimestamp" resultType="java.util.Date">
- 
 
 50 
    SELECT lastUpdatedTimestamp from emailStatus
- 
 
 51 
  </select>
- 
 
 52 
 
- 
 
 53 
  <update id="updateLastEmailProcessedTimestamp" parameterType="java.util.Date">
- 
 
 54 
    UPDATE emailStatus
- 
 
 55 
    SET lastUpdatedTimestamp = #{timestamp}
- 
 
 56 
  </update>
48 
</mapper>
 57 
</mapper>
49 

            58