From de91c84954157bb9f8b6d938cbe0b1b51fb6e65d Mon Sep 17 00:00:00 2001
From: CeDo <cedoogle@gmail.com>
Date: 星期五, 07 五月 2021 15:23:57 +0800
Subject: [PATCH] bugfixed：新增便民服务商家 报错
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngStructHouseUserDAO.java | 11 ++++++++++-
1 files changed, 10 insertions(+), 1 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngStructHouseUserDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngStructHouseUserDAO.java
index ad53c12..befff30 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngStructHouseUserDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngStructHouseUserDAO.java
@@ -7,6 +7,7 @@
import org.apache.ibatis.annotations.Select;
import java.util.List;
+import java.util.Map;
/**
* @program: springcloud_k8s_panzhihuazhihuishequ
@@ -16,6 +17,14 @@
**/
@Mapper
public interface ComMngStructHouseUserDAO extends BaseMapper<ComMngStructHouseUserDO> {
- @Select("select u.name,u.phone from com_mng_struct_house_user h left join sys_user u on h.user_id=u.user_id")
+ @Select("select u.name,u.phone from com_mng_struct_house_user h join sys_user u on h.user_id=u.user_id and h.house_code=#{houseCode1}")
List<LoginUserInfoVO> selectListHouseUser(String houseCode1);
+ @Select("SELECT\n" +
+ "\tp.house_code ,\n" +
+ "\tp.is_rent\n" +
+ "FROM\n" +
+ "\tsys_user_input p \n" +
+ "WHERE\n" +
+ "\tp.id =#{userId}")
+ Map<String, Object> selectHouseCode(Long userId);
}
--
Gitblit v1.7.1