From f026b03b7b02a0e00ba2a0cb3d93bf61cf07f9e0 Mon Sep 17 00:00:00 2001 From: xiaoyong931011 <15274802129@163.com> Date: Tue, 23 Mar 2021 15:28:26 +0800 Subject: [PATCH] 20210323 后台保留两位小数,(平台数据除外) --- src/main/java/com/xcong/excoin/modules/member/entity/AgentFriendRelationEntity.java | 2 ++ src/main/resources/mapper/modules/AgentFriendRelationMapper.xml | 6 +++++- src/main/resources/templates/febs/views/modules/member/agentInfo.html | 1 + 3 files changed, 8 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/xcong/excoin/modules/member/entity/AgentFriendRelationEntity.java b/src/main/java/com/xcong/excoin/modules/member/entity/AgentFriendRelationEntity.java index f7e42ee..8f23f9c 100644 --- a/src/main/java/com/xcong/excoin/modules/member/entity/AgentFriendRelationEntity.java +++ b/src/main/java/com/xcong/excoin/modules/member/entity/AgentFriendRelationEntity.java @@ -92,5 +92,7 @@ */ @TableField(exist = false) private String team; + @TableField(exist = false) + private String realName; } diff --git a/src/main/resources/mapper/modules/AgentFriendRelationMapper.xml b/src/main/resources/mapper/modules/AgentFriendRelationMapper.xml index e08a891..8a3bee5 100644 --- a/src/main/resources/mapper/modules/AgentFriendRelationMapper.xml +++ b/src/main/resources/mapper/modules/AgentFriendRelationMapper.xml @@ -3,7 +3,11 @@ <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!=''"> diff --git a/src/main/resources/templates/febs/views/modules/member/agentInfo.html b/src/main/resources/templates/febs/views/modules/member/agentInfo.html index 38d04ea..6bf66ef 100644 --- a/src/main/resources/templates/febs/views/modules/member/agentInfo.html +++ b/src/main/resources/templates/febs/views/modules/member/agentInfo.html @@ -74,6 +74,7 @@ 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'}, -- Gitblit v1.9.1