From 61d67d3049e378bf247d80b5d1bbd54b9509b6ca Mon Sep 17 00:00:00 2001
From: 101captain <237651143@qq.com>
Date: 星期一, 30 八月 2021 14:15:18 +0800
Subject: [PATCH] 城管端随手拍修改
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActEasyPhotoDOMapper.xml | 4 ++--
springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/easyPhoto/ExportEasyPhotoVO.java | 2 --
2 files changed, 2 insertions(+), 4 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/easyPhoto/ExportEasyPhotoVO.java b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/easyPhoto/ExportEasyPhotoVO.java
index b0d042f..e7ca92d 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/easyPhoto/ExportEasyPhotoVO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/easyPhoto/ExportEasyPhotoVO.java
@@ -19,8 +19,6 @@
private String photoType="其他";
@ExcelProperty("联系电话")
private String phone;
- @ExcelProperty("处理人名字")
- private String handlerName;
@ExcelProperty("创建时间")
private Date createAt;
}
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActEasyPhotoDOMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActEasyPhotoDOMapper.xml
index de1da02..1e2d08f 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActEasyPhotoDOMapper.xml
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActEasyPhotoDOMapper.xml
@@ -99,7 +99,7 @@
AND (u.`name` like concat(#{comActEasyPhotoVO.keyWord},'%') or
p.happen_addr like concat(#{comActEasyPhotoVO.keyWord},'%') or
su.`name` like concat(#{comActEasyPhotoVO.keyWord},'%') or
- p.detail like concat(#{comActEasyPhotoVO.keyWord},'%')
+ p.detail like concat(#{comActEasyPhotoVO.keyWord},'%') or u.phone like concat(#{comActEasyPhotoVO.keyWord},'%')
)
</if>
GROUP BY
@@ -194,7 +194,7 @@
AND (u.`name` like concat(#{keyWord},'%') or
p.happen_addr like concat(#{keyWord},'%') or
su.`name` like concat(#{keyWord},'%') or
- p.detail like concat(#{keyWord},'%')
+ p.detail like concat(#{keyWord},'%') or u.phone like concat(#{comActEasyPhotoVO.keyWord},'%')
)
</if>
GROUP BY
--
Gitblit v1.7.1