| | |
| | | or find_in_set(m.invite_id, e.referrer_ids) |
| | | ),0) amount |
| | | FROM mall_member m |
| | | left join data_dictionary_custom a on a.code = m.level |
| | | left join data_dictionary_custom a on a.description = m.level |
| | | <where> |
| | | <if test="record != null" > |
| | | <if test="record.name!=null and record.name!=''"> |
| | |
| | | |
| | | <select id="getAgentLevelListInPage" resultType="cc.mrbird.febs.mall.vo.AdminAgentLevelVo"> |
| | | SELECT |
| | | a.id,b.description name |
| | | a.id,a.description name |
| | | FROM |
| | | data_dictionary_custom a |
| | | left JOIN data_dictionary_custom b on a.code = b.code |
| | | where a.type = 'AGENT_LEVEL_REQUIRE' |
| | | GROUP BY a.id |
| | | where a.type = 'MEMBER_AGENT_LEVEL' |
| | | ORDER BY |
| | | a.CREATED_TIME DESC |
| | | </select> |