Subversion Repositories SmartDukaan

Rev

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

Rev 5168 Rev 5286
Line 30... Line 30...
30 
        </if>
 30 
        </if>
31 
        <if test="agentEmailId != null">
 31 
        <if test="agentEmailId != null">
32 
            AND a.emailId = #{agentEmailId}
 32 
            AND a.emailId = #{agentEmailId}
33 
        </if>
 33 
        </if>
34 
  </select>
 34 
  </select>
- 
 
 35
- 
 
 36 
  <select id="getInactiveAgents" parameterType="searchFilter" resultType="agent">
- 
 
 37 
    SELECT *
- 
 
 38 
    FROM agent a
- 
 
 39 
    WHERE is_active = 0
- 
 
 40 
        <if test="agentId != null">
- 
 
 41 
            AND a.id = #{agentId}
- 
 
 42 
        </if>
- 
 
 43 
        <if test="agentEmailId != null">
- 
 
 44 
            AND a.emailId = #{agentEmailId}
- 
 
 45 
        </if>
- 
 
 46 
  </select>
35 
 
 47 
 
36 
  <select id="getRoleNamesForAgent" parameterType="String" resultType="String">
 48 
  <select id="getRoleNamesForAgent" parameterType="String" resultType="String">
37 
    SELECT role_name
49 
    SELECT role_name
38 
    FROM user_roles a
 50 
    FROM user_roles a
39 
    JOIN agent b
 51 
    JOIN agent b