From 4feaef5e35f0dad7cc3f05e32fc7e3e52fa9396d Mon Sep 17 00:00:00 2001
From: puhanshu <a9236326>
Date: 星期四, 10 三月 2022 17:17:14 +0800
Subject: [PATCH] 随手拍/微心愿/志愿者修改

---
 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngVolunteerMngDAO.java |   18 +++++++-----------
 1 files changed, 7 insertions(+), 11 deletions(-)

diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngVolunteerMngDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngVolunteerMngDAO.java
index 139f9b4..73b5873 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngVolunteerMngDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComMngVolunteerMngDAO.java
@@ -33,17 +33,6 @@
     IPage<ComMngVolunteerMngVO> pageVolunteer(Page page,
         @Param("comMngVolunteerMngVO") ComMngVolunteerMngVO comMngVolunteerMngVO);
 
-    @Select("<script> " + "SELECT\n" + "t.id,\n" + "t.`name`,\n" + "t.state,\n" + "t.phone,\n" + "t.apply_reson,\n"
-        + "t.create_at, " + "t.submit_user_id \n" + "FROM\n" + "com_mng_volunteer_mng t\n" + " RIGHT JOIN \n"
-        + "(select submit_user_id, MAX(create_at)create_at  from com_mng_volunteer_mng where state IN ( 1, 3 ) GROUP BY submit_user_id ) tmp \n"
-        + "on t.create_at = tmp.create_at and t.submit_user_id=tmp.submit_user_id " + "WHERE\n"
-        + "state in (1,3)  and community_id = ${comMngVolunteerMngVO.communityId} \n"
-        + "<if test='comMngVolunteerMngVO.name != null and comMngVolunteerMngVO.name.trim() != &quot;&quot;'>"
-        + "and t.name like concat(#{comMngVolunteerMngVO.name},'%')  \n" + " </if> "
-        + "<if test='comMngVolunteerMngVO.phone != null and comMngVolunteerMngVO.phone.trim() != &quot;&quot;'>"
-        + "AND t.phone like concat(#{comMngVolunteerMngVO.phone},'%')\n" + " </if> "
-        + "<if test='comMngVolunteerMngVO.state != null and comMngVolunteerMngVO.state != 0'>"
-        + "and t.state=#{comMngVolunteerMngVO.state}\n" + " </if> " + " \tORDER BY t.state asc  " + "</script>")
     IPage<ComMngVolunteerMngVO> pageVolunteerExamine(Page page,
         @Param("comMngVolunteerMngVO") ComMngVolunteerMngVO comMngVolunteerMngVO);
 
@@ -98,4 +87,11 @@
      * @return
      */
     List<ComMngVolunteerMngVO> selectVolunteerByCommunityId(@Param("communityId") Long communityId);
+
+    /**
+     * 志愿者审核详情
+     * @param id
+     * @return
+     */
+    ComMngVolunteerMngVO detailVolunteerExamine(@Param("communityId") Long id);
 }

--
Gitblit v1.7.1