From a875e977d88ce6918e29fa9ddefa040fa81aee32 Mon Sep 17 00:00:00 2001 From: findyguo <12205921@qq.com> Date: 星期四, 04 三月 2021 16:27:18 +0800 Subject: [PATCH] 留言新增 --- springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java | 5 +++++ springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/service/impl/UserServiceImpl.java | 8 ++++++-- 2 files changed, 11 insertions(+), 2 deletions(-) diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java b/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java index 28c3899..6036cff 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java +++ b/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java @@ -393,4 +393,9 @@ " </if> " + "</script>") List<EexcelUserDTO> selectExport(@Param("exportUserDTO") ExportUserDTO exportUserDTO); + + @Update("update com_pb_member_role u set u.phone=#{newphone},is_reg=1 where u.phone=#{oldphone}") + void updateMemberRole(@Param("newphone")String newphone,@Param("oldphone")String oldphone); + @Update("update com_pb_service_team u set u.phone=#{newphone},is_reg=1 where u.phone=#{oldphone}") + void updateServiceTeam(@Param("newphone")String newphone,@Param("oldphone")String oldphone); } diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/service/impl/UserServiceImpl.java b/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/service/impl/UserServiceImpl.java index c1acd02..e111781 100644 --- a/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/service/impl/UserServiceImpl.java +++ b/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/service/impl/UserServiceImpl.java @@ -156,6 +156,8 @@ SysUserDO sysUserDO = new SysUserDO(); sysUserDO.setPhone(purePhoneNumber); sysUserDO.setUserId(userId); + userDao.updateMemberRole(purePhoneNumber, purePhoneNumber); + userDao.updateServiceTeam(purePhoneNumber, purePhoneNumber); int i = userDao.updateById(sysUserDO); if (i > 0) { return R.ok(); @@ -590,8 +592,11 @@ SysUserDO sysUserDO=new SysUserDO(); sysUserDO.setUserId(userPhoneVO.getUserId()); sysUserDO.setPhone(newPhone); + userDao.updateMemberRole(newPhone, oldPhone); + userDao.updateServiceTeam(newPhone, oldPhone); int update = userDao.updateById(sysUserDO); if (update>0) { + return R.ok(); } return R.fail(); @@ -1485,8 +1490,7 @@ List<EexcelUserDTO> eexcelUserDTOS=userDao.selectExport(exportUserDTO); return R.ok(eexcelUserDTOS); } - - + public static void main(String[] args) { // String encode = new BCryptPasswordEncoder().encode("lbsq123456"); // System.out.println(encode); -- Gitblit v1.7.1