From 425daed225844521327f0913f7e28304db492c82 Mon Sep 17 00:00:00 2001
From: huanghongfa <18228131219@163.com>
Date: 星期五, 18 十二月 2020 16:44:43 +0800
Subject: [PATCH] 社区管理房屋管理志愿者接口完成
---
springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/UserDao.java | 73 ++++++++++++++++++++++++++++++++++++
1 files changed, 73 insertions(+), 0 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 0407ccd..5629c9f 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
@@ -2,8 +2,13 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.panzhihua.common.model.vos.LoginUserInfoVO;
import com.panzhihua.service_user.model.dos.SysUserDO;
import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
/**
* @program: springcloud_k8s_panzhihuazhihuishequ
@@ -13,4 +18,72 @@
**/
@Mapper
public interface UserDao extends BaseMapper<SysUserDO> {
+ // @Select("<script> " +
+// " <where>" +
+// "<if test='nameCn != null and nameCn.trim() != ""'>" +
+// " </if> " +
+// "<if test='nameCn != null and nameCn.trim() != ""'>" +
+// " </if> " +
+// "<if test='nameCn != null and nameCn.trim() != ""'>" +
+// " </if> " +
+// " </where>" +
+// "</script>")
+
+ @Select("<script> " +
+ "SELECT\n" +
+ "u.user_id,\n" +
+ "u.face_url,\n" +
+ "u.nick_name,\n" +
+ "u.`name`,\n" +
+ "u.phone,\n" +
+ "u.id_card,\n" +
+ "u.face_state,\n" +
+ "c.NAME,\n" +
+ "is_tanant,\n" +
+ "u.create_at \n" +
+ "FROM\n" +
+ "sys_user u\n" +
+ "JOIN com_act c ON u.community_id = c.community_id \n" +
+ "<if test='loginUserInfoVO.name != null and loginUserInfoVO.name.trim() != ""'>" +
+ "AND c.`name` = #{loginUserInfoVO.name} \n" +
+ " </if> " +
+ " <where>" +
+ "<if test='loginUserInfoVO.communityName != null and loginUserInfoVO.communityName.trim() != ""'>" +
+ "and u.`name` = #{loginUserInfoVO.communityName} \n" +
+ " </if> " +
+ "<if test='loginUserInfoVO.phone != null and loginUserInfoVO.phone.trim() != ""'>" +
+ "AND u.phone = #{loginUserInfoVO.phone}"+
+ " </if> " +
+ " </where>" +
+ " order by u.face_state asc,u.create_at asc "+
+ "</script>")
+ IPage<LoginUserInfoVO> pageUserFace(Page page, @Param("loginUserInfoVO") LoginUserInfoVO loginUserInfoVO);
+ @Select("<script> " +
+ "SELECT\n" +
+ "u.user_id,\n" +
+ "u.`name`,\n" +
+ "u.nick_name,\n" +
+ "u.phone,\n" +
+ "u.id_card,\n" +
+ "u.job,\n" +
+ "c.NAME,\n" +
+ "u.is_tanant,\n" +
+ "u.tags,\n" +
+ "u.create_at \n" +
+ "FROM\n" +
+ "sys_user u\n" +
+ "LEFT JOIN com_act c ON u.community_id = c.community_id \n" +
+ "<if test='loginUserInfoVO.communityName != null and loginUserInfoVO.communityName.trim() != ""'>" +
+ "AND c.`name` = #{loginUserInfoVO.communityName} \n" +
+ " </if> " +
+ " <where>" +
+ "<if test='loginUserInfoVO.name != null and loginUserInfoVO.name.trim() != ""'>" +
+ " and u.`name` = #{loginUserInfoVO.name} \n" +
+ " </if> " +
+ "<if test='loginUserInfoVO.phone != null and loginUserInfoVO.phone.trim() != ""'>" +
+ "AND u.phone = #{loginUserInfoVO.phone}"+
+ " </if> " +
+ " </where>" +
+ "</script>")
+ IPage<LoginUserInfoVO> pageUser(Page page, @Param("loginUserInfoVO")LoginUserInfoVO loginUserInfoVO);
}
--
Gitblit v1.7.1