| | |
| | | private Integer isForce; |
| | | |
| | | @TableField(exist = false) |
| | | private String account; |
| | | private String firstName; |
| | | |
| | | @TableField(exist = false) |
| | | private String secondName; |
| | | |
| | | @TableField(exist = false) |
| | | private String realName; |
| | | |
| | | @TableField(exist = false) |
| | | private BigDecimal coinNumber; |
| | |
| | | @Override |
| | | public IPage<MemberEntity> findMemberListInPage(MemberEntity memberEntity, QueryRequest request) { |
| | | Page<MemberEntity> page = new Page<>(request.getPageNum(), request.getPageSize()); |
| | | return this.baseMapper.selectMemberListInPage(page, memberEntity); |
| | | IPage<MemberEntity> selectMemberListInPage = this.baseMapper.selectMemberListInPage(page, memberEntity); |
| | | List<MemberEntity> records = selectMemberListInPage.getRecords(); |
| | | if(records != null && records.size() > 0) { |
| | | for(MemberEntity memberEntitys : records) { |
| | | String firstName = memberEntitys.getFirstName(); |
| | | String secondName = memberEntitys.getSecondName(); |
| | | memberEntitys.setRealName(firstName+secondName); |
| | | } |
| | | } |
| | | return selectMemberListInPage; |
| | | } |
| | | |
| | | @Override |
| | |
| | | <mapper namespace="com.xcong.excoin.modules.member.mapper.MemberMapper"> |
| | | |
| | | <select id="selectMemberListInPage" resultType="com.xcong.excoin.modules.member.entity.MemberEntity"> |
| | | select * from member |
| | | SELECT |
| | | * |
| | | FROM |
| | | member m |
| | | LEFT JOIN member_authentication a ON m.id = a.member_id |
| | | <where> |
| | | <if test="record != null" > |
| | | <if test="record.startTime!=null"> |
| | | and create_time >=#{record.startTime} |
| | | and m.create_time >=#{record.startTime} |
| | | </if> |
| | | <if test="record.endTime!=null"> |
| | | and #{record.endTime} >= create_time |
| | | and #{record.endTime} >= m.create_time |
| | | </if> |
| | | <if test="record.account!=null and record.account!=''"> |
| | | and (phone = #{record.account} or email = #{record.account} or invite_id=#{record.account}) |
| | | and (m.phone = #{record.account} or m.email = #{record.account} or m.invite_id=#{record.account}) |
| | | </if> |
| | | <if test="record.accountStatus!=null"> |
| | | and account_status = #{record.accountStatus} |
| | | and m.account_status = #{record.accountStatus} |
| | | </if> |
| | | <if test="record.accountType != null" > |
| | | and account_type = #{record.accountType} |
| | | and m.account_type = #{record.accountType} |
| | | </if> |
| | | <if test="record.certifyStatus != null"> |
| | | and certify_status = #{record.certifyStatus} |
| | | and m.certify_status = #{record.certifyStatus} |
| | | </if> |
| | | </if> |
| | | </where> |
| | |
| | | cols: [[ |
| | | {field: 'phone', title: '手机号', minWidth: 100,align:'left'}, |
| | | {field: 'email', title: '邮箱', minWidth: 200,align:'left'}, |
| | | {field: 'realName', title: '姓名', minWidth: 200,align:'left'}, |
| | | {field: 'inviteId', title: '邀请码UID', minWidth: 80,align:'center'}, |
| | | {field: 'refererId', title: '上级邀请码UID', minWidth: 80,align:'center'}, |
| | | {field: 'accountType', title: '账号类型', |
| | |
| | | cols: [[
|
| | | {field: 'phone', title: '手机号', minWidth: 100,align:'left'},
|
| | | {field: 'email', title: '邮箱', minWidth: 200,align:'left'},
|
| | | {field: 'realName', title: '姓名', minWidth: 200,align:'left'},
|
| | | {field: 'inviteId', title: '邀请码UID', minWidth: 80,align:'center'},
|
| | | {field: 'refererId', title: '上级邀请码UID', minWidth: 80,align:'center'},
|
| | | {field: 'refererId', title: '账号状态',
|