From 70d2a5d0f9c6951b2d4cac954041ed73582ff7eb Mon Sep 17 00:00:00 2001
From: liujie <1793218484@qq.com>
Date: 星期一, 09 六月 2025 11:54:00 +0800
Subject: [PATCH] 6.9新增登录失败冻结逻辑
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngStructHouseDAO.java | 54 +++++++++++++++++++-----------------------------------
1 files changed, 19 insertions(+), 35 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
index 346fb03..1301772 100644
--- 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
@@ -1,14 +1,15 @@
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 java.util.List;
+
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;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.panzhihua.common.model.dtos.community.ExcelHouseDTO;
+import com.panzhihua.service_community.model.dos.ComMngStructHouseDO;
/**
* @program: springcloud_k8s_panzhihuazhihuishequ
@@ -22,36 +23,19 @@
@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> ")
+ @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