From 46e7cd9daeb5072eb562317520307a1d60b1446e Mon Sep 17 00:00:00 2001
From: huanghongfa <18228131219@163.com>
Date: 星期四, 25 二月 2021 13:15:47 +0800
Subject: [PATCH] all
---
springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/SysUserInputDAO.java | 57 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 57 insertions(+), 0 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/SysUserInputDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/SysUserInputDAO.java
new file mode 100644
index 0000000..2f62962
--- /dev/null
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_user/src/main/java/com/panzhihua/service_user/dao/SysUserInputDAO.java
@@ -0,0 +1,57 @@
+package com.panzhihua.service_user.dao;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.panzhihua.common.model.vos.community.ComMngStructAreaVO;
+import com.panzhihua.common.model.vos.community.ComMngStructHouseVO;
+import com.panzhihua.common.model.vos.user.ComMngFamilyInfoVO;
+import com.panzhihua.service_user.model.dos.SysUserInputDO;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
+
+import java.util.List;
+
+/**
+ * @program: springcloud_k8s_panzhihuazhihuishequ
+ * @description: 居民导入
+ * @author: huang.hongfa weixin hhf9596 qq 959656820
+ * @create: 2021-02-05 17:40
+ **/
+@Mapper
+public interface SysUserInputDAO extends BaseMapper<SysUserInputDO> {
+ // @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("select a.id,a.community_id from com_mng_struct_area a where a.area_name=#{areaName}")
+ ComMngStructAreaVO selectByAreaName(String areaName);
+ @Select("SELECT \n" +
+ "REPLACE(REPLACE(REPLACE(REPLACE(h.house_name,a.address_detail,''),'栋','-'),'单元','-'),'层','-')houseName,\n" +
+ "h.house_code\n" +
+ "FROM\n" +
+ "\tcom_mng_struct_area a \n" +
+ "\tjoin com_mng_struct_house h on h.house_name like CONCAT(a.address_detail,'%') and h.type=5\n" +
+ "WHERE\n" +
+ "\ta.area_name = #{areaName}")
+ List<ComMngStructHouseVO> selectHouserByareaName(String areaName);
+ @Select("SELECT \n" +
+ "p.name,\n" +
+ "p.id,\n" +
+ "if(p.is_rent=1,'合租','家人')relationship,\n" +
+ "p.id_card,\n" +
+ "p.phone,\n" +
+ "year(curdate())-if(length(p.id_card)=18,substring(p.id_card,7,4),if(length(p.id_card)=15,concat('19',substring(p.id_card,7,2)),null)) as age,\n" +
+ "p.create_at\n" +
+ "FROM\n" +
+ "\tsys_user_input p \n" +
+ "WHERE\n" +
+ "\tp.door_number = #{doorNumber} \n" +
+ "\tAND p.id !=#{userId}")
+ List<ComMngFamilyInfoVO> selectListFamily(@Param("doorNumber") String doorNumber, @Param("userId")Long userId);
+}
--
Gitblit v1.7.1