fix(mall): 修复管理员禁用会员时未同步更新小程序登录状态
- 在禁用会员后,删除小程序登录相关的 Redis 缓存
- 调整商城会员列表中"推销员设置"列的位置,解决显示顺序问题
| | |
| | | .eq(MallMember::getAccountStatus, MallMember.ACCOUNT_STATUS_ENABLE) |
| | | .eq(MallMember::getAccountType, MallMember.ACCOUNT_TYPE_NORMAL) |
| | | .ne(MallMember::getStoreMaster, 0) |
| | | .orderByAsc(MallMember::getStoreMaster) |
| | | .orderByDesc(MallMember::getId) |
| | | .last("limit 1") |
| | | ); |
| | | // 如果没有找到符合条件的团长,则记录日志并返回 |
| | |
| | | |
| | | <select id="getAgentListInPage" resultType="cc.mrbird.febs.mall.vo.AdminAgentVo"> |
| | | |
| | | SELECT m.*,a.description levelName, |
| | | SELECT m.*,a.name levelName, |
| | | ifnull(( |
| | | SELECT |
| | | sum(b.amount) |
| | |
| | | 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 happy_sale_level a on a.code = m.store_master |
| | | <where> |
| | | and m.store_master != 0 |
| | | <if test="record != null" > |
| | | <if test="record.name!=null and record.name!=''"> |
| | | and m.name like concat('%', #{record.name},'%') |
| | |
| | | </select> |
| | | |
| | | <select id="getAgentChildInPage" resultType="cc.mrbird.febs.mall.vo.AdminAgentMemberVo"> |
| | | select m.*,a.description levelName from mall_member m |
| | | left join data_dictionary_custom a on a.code = m.level |
| | | select m.*,a.name levelName from mall_member m |
| | | left join happy_sale_level a on a.code = m.store_master |
| | | where find_in_set(#{record.inviteId}, m.referrer_ids) |
| | | GROUP BY m.id |
| | | ORDER BY |
| | |
| | | id: 'userAgentTable', |
| | | url: ctx + 'admin/mallMember/getAgentList', |
| | | cols: [[ |
| | | {field: 'bindPhone', title: '手机号', minWidth: 150,align:'left'}, |
| | | // {field: 'bindPhone', title: '手机号', minWidth: 150,align:'left'}, |
| | | {field: 'phone', title: '账号', minWidth: 150,align:'left'}, |
| | | {field: 'name', title: '名称', minWidth: 100,align:'left'}, |
| | | {field: 'inviteId', title: '邀请码', minWidth: 100,align:'left'}, |