From d331c5475f0b07f36161a4464d92e32b6913b4e9 Mon Sep 17 00:00:00 2001 From: lidongdong <1459917685@qq.com> Date: 星期五, 24 十一月 2023 14:50:43 +0800 Subject: [PATCH] 后台增加用户搜索列表 --- springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/service/impl/NewFightConvenientMerchantServiceImpl.java | 5 +++++ springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/NewFightComConvenientMerchantsMapper.xml | 21 +++++++++++++++++++++ springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/service/NewFightConvenientMerchantService.java | 2 ++ springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/NewStriveApi.java | 2 +- springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/NewFightConvenientMerchantDao.java | 4 ++++ springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/api/NewFightConvenientMerchantApi.java | 8 ++++++++ springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/partybuilding/NewStriveForFeign.java | 7 +++++++ 7 files changed, 48 insertions(+), 1 deletions(-) diff --git a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/partybuilding/NewStriveForFeign.java b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/partybuilding/NewStriveForFeign.java index bb162d8..b0e3976 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/partybuilding/NewStriveForFeign.java +++ b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/partybuilding/NewStriveForFeign.java @@ -383,6 +383,13 @@ @RequestParam("phoneOrname") String phoneOrname); + + @GetMapping("/selectUserListB") + public R selectUserListB(@RequestParam("communityId") String communityId, + @RequestParam("phoneOrname") String phoneOrname); + + + @GetMapping("/FightConvenient/selectUserBind") public R selectUserBind(@RequestParam("communityId") String communityId, @RequestParam("userId") String userId); diff --git a/springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/NewStriveApi.java b/springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/NewStriveApi.java index 8a917c3..ea0c69a 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/NewStriveApi.java +++ b/springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/NewStriveApi.java @@ -340,7 +340,7 @@ @GetMapping("/selectUserList") public R selectUserList(@RequestParam("phoneOrname") String phoneOrname) { - return newStriveForFeign.selectUserList(getCommunityId()+"",phoneOrname); + return newStriveForFeign.selectUserListB(getCommunityId()+"",phoneOrname); } diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/api/NewFightConvenientMerchantApi.java b/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/api/NewFightConvenientMerchantApi.java index 39b3361..0e2be9c 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/api/NewFightConvenientMerchantApi.java +++ b/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/api/NewFightConvenientMerchantApi.java @@ -87,6 +87,14 @@ return merchantService.selectUserList(communityId,phoneOrname); } + @GetMapping("/selectUserListB") + public R selectUserListB(@RequestParam("communityId") String communityId, + @RequestParam("phoneOrname") String phoneOrname) + { + return merchantService.selectUserListB(communityId,phoneOrname); + } + + @GetMapping("/selectUserBind") public R selectUserBind(@RequestParam("communityId") String communityId, @RequestParam("userId") String userId) diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/NewFightConvenientMerchantDao.java b/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/NewFightConvenientMerchantDao.java index 3886609..4e68a18 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/NewFightConvenientMerchantDao.java +++ b/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/dao/NewFightConvenientMerchantDao.java @@ -70,6 +70,10 @@ @Param("phoneOrname") String phoneOrname); + List<SysUserVO> selectUserListB(@Param("communityId") String communityId, + @Param("phoneOrname") String phoneOrname); + + String selectUserBind(@Param("communityId") String communityId, @Param("userId") String userId); diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/service/NewFightConvenientMerchantService.java b/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/service/NewFightConvenientMerchantService.java index 7981182..67aa25b 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/service/NewFightConvenientMerchantService.java +++ b/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/service/NewFightConvenientMerchantService.java @@ -60,6 +60,8 @@ R selectUserList(String communityId,String phoneOrname); + R selectUserListB(String communityId,String phoneOrname); + R selectUserBind(String communityId, String userId); } diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/service/impl/NewFightConvenientMerchantServiceImpl.java b/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/service/impl/NewFightConvenientMerchantServiceImpl.java index bbeb515..db13a75 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/service/impl/NewFightConvenientMerchantServiceImpl.java +++ b/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/service/impl/NewFightConvenientMerchantServiceImpl.java @@ -81,6 +81,11 @@ } @Override + public R selectUserListB(String communityId, String phoneOrname) { + return R.ok(baseMapper.selectUserListB(communityId,phoneOrname)); + } + + @Override public R selectUserBind(String communityId, String userId) { return R.ok(baseMapper.selectUserBind(communityId,userId)); } diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/NewFightComConvenientMerchantsMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/NewFightComConvenientMerchantsMapper.xml index 014ea12..b8ee823 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/NewFightComConvenientMerchantsMapper.xml +++ b/springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/NewFightComConvenientMerchantsMapper.xml @@ -302,6 +302,27 @@ </select> + <select id="selectUserListB" resultType="com.panzhihua.common.model.vos.user.SysUserVO"> + select su.user_id,su.phone,su.nick_name,su.name,su.community_id + from sys_user as su + <where> + 1=1 + and su.app_id='wx118de8a734d269f0' + <if test="communityId!=null and communityId !='' "> + and su.community_id=#{communityId} + </if> + <if test="phoneOrname!=null and phoneOrname !=''"> + and (su.name like concat ('%',#{phoneOrname},'%') or + su.phone like concat ('%',#{phoneOrname},'%') or + su.nick_name like concat ('%',#{phoneOrname},'%') + ) + </if> + + </where> + </select> + + + <select id="selectUserBind" resultType="String"> select id from new_fight_com_convenient_merchants <where> -- Gitblit v1.7.1