Subversion Repositories SmartDukaan

Rev

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

Rev 3024 Rev 3088
Line 4... Line 4...
4 
 
 4 
 
5 
<mapper namespace="in.shop2020.crm.persistence.AgentMapper">
 5 
<mapper namespace="in.shop2020.crm.persistence.AgentMapper">
6 
  <resultMap type="agent" id="agentResult">
 6 
  <resultMap type="agent" id="agentResult">
7 
    <id property="id" column="id"/>
 7 
    <id property="id" column="id"/>
8 
  </resultMap>
 8 
  </resultMap>
- 
 
 9 
 
- 
 
 10 
  <select id="getAllAgents" resultType="agent">
- 
 
 11 
    SELECT * FROM agent
- 
 
 12 
  </select>
9
13 
 
10 
  <select id="getAgent" parameterType="long" resultType="agent">
 14 
  <select id="getAgent" parameterType="long" resultType="agent">
11 
    SELECT * FROM agent
 15 
    SELECT * FROM agent
12 
    WHERE id = #{agentId}
 16 
    WHERE id = #{agentId}
13 
  </select>
 17 
  </select>
14 
 
 18 
 
15 
  <select id="getAgentByEmailId" parameterType="String" resultType="agent">
 19 
  <select id="getAgentByEmailId" parameterType="String" resultType="agent">
16 
    SELECT * FROM agent
 20 
    SELECT * FROM agent
17 
    WHERE emailId = #{emailId}
 21 
    WHERE emailId = #{emailId}
18 
  </select>
 22 
  </select>
- 
 
 23
- 
 
 24 
  <select id="getRoleNamesForAgent" parameterType="String" resultType="String">
- 
 
 25 
    SELECT role_name
- 
 
 26 
    FROM user_roles a
- 
 
 27 
    JOIN agent b
- 
 
 28 
        ON (b.id = a.agentId)
- 
 
 29 
    WHERE b.emailId = #{emailId}
- 
 
 30 
  </select>
- 
 
 31 
 
- 
 
 32 
  <select id="getPermissionsForRoleName" parameterType="String" resultType="String">
- 
 
 33 
    SELECT permission
- 
 
 34 
    FROM roles_permissions
- 
 
 35 
    WHERE role_name = #{role_name}
- 
 
 36 
  </select>
- 
 
 37
- 
 
 38 
  <update id="updatePasswordForAgent" parameterType="map">
- 
 
 39 
    UPDATE agent
- 
 
 40 
    SET password = #{password}
- 
 
 41 
    WHERE emailId = #{emailId}
- 
 
 42 
  </update>
19 
</mapper>
 43 
</mapper>
20 

            44