From 2dab3f149c6245e80f0c0991264d01cbcd2f91e5 Mon Sep 17 00:00:00 2001
From: lidongdong <1459917685@qq.com>
Date: 星期二, 01 八月 2023 14:13:36 +0800
Subject: [PATCH] 修改三说专家级别与单位范围报错
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngRealAssetsDAO.java | 1 +
1 files changed, 1 insertions(+), 0 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngRealAssetsDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngRealAssetsDAO.java
index d91546c..7a0c4f6 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngRealAssetsDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngRealAssetsDAO.java
@@ -43,6 +43,7 @@
+ " case t.floor_type when 1 then '高层' when 2 then '中层' when 3 then '低层' else '/' end floorType, "
+ " t.num, " + " t.square, " + " t.address " + "FROM " + " com_mng_real_assets t "
+ " LEFT JOIN com_mng_struct_build_type t2 ON t.build_type_id = t2.id"
+ + " WHERE 1= 1 "
+ "<if test='exportRealAssetsExcelDTO.name != null and exportRealAssetsExcelDTO.name.trim() != ""'>"
+ " and t.name LIKE concat( #{exportRealAssetsExcelDTO.name}, '%' ) " + " </if> "
+ "<if test='exportRealAssetsExcelDTO.communityId != null and exportRealAssetsExcelDTO.communityId != 0'>"
--
Gitblit v1.7.1