From 2e64c232ab6b51b2cecf1ee96e1e9b709234f326 Mon Sep 17 00:00:00 2001
From: huanghongfa <huanghongfa123456>
Date: 星期六, 21 八月 2021 16:35:14 +0800
Subject: [PATCH] 随手拍改版接口开发
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngStructHouseDAO.java | 57 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 57 insertions(+), 0 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngStructHouseDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngStructHouseDAO.java
new file mode 100644
index 0000000..346fb03
--- /dev/null
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngStructHouseDAO.java
@@ -0,0 +1,57 @@
+package com.panzhihua.service_community.dao;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.panzhihua.common.model.dtos.community.ExcelHouseDTO;
+import com.panzhihua.service_community.model.dos.ComMngStructHouseDO;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Options;
+import org.apache.ibatis.annotations.Select;
+import org.apache.ibatis.mapping.StatementType;
+
+import java.util.List;
+
+/**
+ * @program: springcloud_k8s_panzhihuazhihuishequ
+ * @description: 房屋
+ * @author: huang.hongfa weixin hhf9596 qq 959656820
+ * @create: 2020-12-14 17:09
+ **/
+@Mapper
+public interface ComMngStructHouseDAO extends BaseMapper<ComMngStructHouseDO> {
+ @Select("{call smart_life.removeByParentCode(#{areaCode,jdbcType=VARCHAR,mode=IN})}")
+ @Options(statementType = StatementType.CALLABLE)
+ int batchDeleteHouse(String areaCode);
+
+ @Select("<script> " +
+ " SELECT REPLACE " +
+ " ( h3.house_name, h4.house_name, '' ) build, " +
+ " REPLACE ( h2.house_name, h3.house_name, '' ) unit, " +
+ " REPLACE ( h1.house_name, h2.house_name, '' ) floor, " +
+ " REPLACE ( h.house_name, h1.house_name, '' ) room, " +
+ " h.square, " +
+ "CASE " +
+ " h.state " +
+ " WHEN 1 THEN " +
+ " '自住' " +
+ " WHEN 2 THEN " +
+ " '租住' " +
+ " WHEN 3 THEN " +
+ " '商用' ELSE '未知' " +
+ " END AS state, " +
+ " su.NAME username, " +
+ " su.phone " +
+ "FROM " +
+ " com_mng_struct_house h " +
+ " LEFT JOIN com_mng_struct_house h1 ON h.parent_code = h1.house_code " +
+ " LEFT JOIN com_mng_struct_house h2 ON h1.parent_code = h2.house_code " +
+ " LEFT JOIN com_mng_struct_house h3 ON h2.parent_code = h3.house_code " +
+ " LEFT JOIN com_mng_struct_house h4 ON h3.parent_code = h4.house_code " +
+ " LEFT JOIN com_mng_struct_house_user hu ON h.house_code = hu.house_code " +
+ " LEFT JOIN sys_user su ON hu.user_id = su.user_id " +
+ "WHERE " +
+ " h.house_code LIKE concat(#{houseCode},'%') " +
+ " AND h.type = 5" +
+ " ORDER BY h.house_code ASC " +
+ "</script> ")
+ List<ExcelHouseDTO> houseExport(String houseCode);
+}
--
Gitblit v1.7.1