feat(mall): 添加会员公司信息展示功能
- 在MallMember实体类中增加companyName和companyCode字段
- 在会员列表页面展示公司名称和公司码
- 修改Mapper文件关联查询公司信息
- 调整会员列表表格字段显示顺序
| | |
| | | private String memberUuid; |
| | | |
| | | private String companyId; |
| | | @TableField(exist = false) |
| | | private String companyName; |
| | | @TableField(exist = false) |
| | | private String companyCode; |
| | | |
| | | /** |
| | | * 姓名 |
| | |
| | | d.prize_score prizeScore, |
| | | d.commission commission, |
| | | d.total_score totalScore, |
| | | e.name companyName, |
| | | e.code companyCode, |
| | | b.name storeMasterName, |
| | | c.name directorName |
| | | FROM mall_member a |
| | | left join happy_sale_level b on b.code = a.store_master |
| | | left join happy_member_level c on c.code = a.director |
| | | left join mall_member_wallet d on d.member_id = a.id |
| | | left join ai_company e on e.id = a.company_id |
| | | <where> |
| | | and a.phone is not null |
| | | <if test="record != null" > |
| | |
| | | {field: 'name', title: '用户名', minWidth: 100,align:'center'}, |
| | | {field: 'realName', title: '真实姓名', minWidth: 100,align:'center'}, |
| | | {field: 'phone', title: '联系方式', minWidth: 150,align:'center'}, |
| | | {field: 'companyName', title: '公司', minWidth: 150,align:'center'}, |
| | | // {field: 'balance', title: '余额', minWidth: 150,align:'center'}, |
| | | // {field: 'score', title: '会员经验', minWidth: 150,align:'center'}, |
| | | // {field: 'prizeScore', title: '积分', minWidth: 150,align:'center'}, |
| | |
| | | // {field: 'totalScore', title: '总佣金', minWidth: 150,align:'center'}, |
| | | // {field: 'directorName', title: '会员等级', minWidth: 150,align:'center'}, |
| | | // {field: 'storeMasterName', title: '分销等级', minWidth: 150,align:'center'}, |
| | | {field: 'inviteId', title: '邀请码', minWidth: 100,align:'center'}, |
| | | {field: 'companyCode', title: '公司码', minWidth: 100,align:'center'}, |
| | | {field: 'createdTime', title: '注册时间', minWidth: 180,align:'center'}, |
| | | ]] |
| | | }); |