20210323 后台保留两位小数,(平台数据除外)
| | |
| | | */
|
| | | @TableField(exist = false)
|
| | | private String team;
|
| | | @TableField(exist = false)
|
| | | private String realName;
|
| | |
|
| | | }
|
| | |
| | | <mapper namespace="com.xcong.excoin.modules.member.mapper.AgentFriendRelationMapper">
|
| | |
|
| | | <select id="findAgentFriendRelationListInPage" resultType="com.xcong.excoin.modules.member.entity.AgentFriendRelationEntity">
|
| | | select * from agent_friend_relation s left join member m on m.id = s.member_id
|
| | | select *,
|
| | | CONCAT(b.first_name, b.second_name) realName
|
| | | from agent_friend_relation s
|
| | | left join member m on m.id = s.member_id
|
| | | LEFT JOIN member_authentication b ON m.id = b.member_id
|
| | | <where>
|
| | | <if test="record != null" >
|
| | | <if test="record.account!=null and record.account!=''">
|
| | |
| | | cols: [[
|
| | | {field: 'phone', title: '手机号码', minWidth: 120,align:'left',totalRowText: '合计'},
|
| | | {field: 'email', title: '邮箱', minWidth: 200,align:'left'},
|
| | | {field: 'realName', title: '姓名', minWidth: 200,align:'left'},
|
| | | {field: 'inviteId', title: '邀请码UID', minWidth: 80,align:'center'},
|
| | | {field: 'promotionNumber', title: '推广人数', minWidth: 200,align:'center'},
|
| | | {field: 'totalRecharge', title: '总充值', minWidth: 200,align:'center'},
|