From c24bb5c5abdba213aaf490b4061b41608fa843bb Mon Sep 17 00:00:00 2001
From: 陈昶聿 <chychen@nbjetron.com>
Date: 星期二, 19 五月 2026 17:29:50 +0800
Subject: [PATCH] 【丽水】获取随访详情-指标详情(超链接) 接口

---
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/ServiceSubtaskDetailController.java |   17 ++++++--
 smartor/src/main/java/com/smartor/service/IServiceSubtaskDetailService.java                    |    3 +
 smartor/src/main/java/com/smartor/domain/ServiceSubtaskDetailVO.java                           |   16 ++++++++
 smartor/src/main/resources/mapper/smartor/ServiceSubtaskDetailMapper.xml                       |   53 ++++++++++++++++++++++++++
 smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskDetailServiceImpl.java            |   17 +++++---
 smartor/src/main/java/com/smartor/mapper/ServiceSubtaskDetailMapper.java                       |    6 +++
 6 files changed, 102 insertions(+), 10 deletions(-)

diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/ServiceSubtaskDetailController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/ServiceSubtaskDetailController.java
index 2379e43..5daa549 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/ServiceSubtaskDetailController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/ServiceSubtaskDetailController.java
@@ -6,10 +6,8 @@
 import com.ruoyi.common.core.domain.entity.SysUser;
 import com.ruoyi.common.enums.BusinessType;
 import com.ruoyi.common.utils.StringUtils;
-import com.smartor.domain.ServiceSubTaskCacheReq;
-import com.smartor.domain.ServiceSubTaskDetailReq;
-import com.smartor.domain.ServiceSubtask;
-import com.smartor.domain.ServiceSubtaskDetail;
+import com.smartor.domain.*;
+import com.smartor.domain.DTO.ServiceSubtaskDetailDTO;
 import com.smartor.service.IServiceSubtaskDetailService;
 import com.smartor.service.IServiceSubtaskService;
 import io.swagger.annotations.Api;
@@ -154,4 +152,15 @@
         return success(ServiceSubtaskDetailService.countPatByTarget(targetid));
     }
 
+
+    /**
+     * 鑾峰彇闅忚璇︽儏-鎸囨爣璇︽儏(瓒呴摼鎺�)
+     */
+    @ApiOperation("鑾峰彇闅忚璇︽儏-鎸囨爣璇︽儏(瓒呴摼鎺�)")
+    @PostMapping("/getServiceSubtaskDetails")
+    public List<Map<String, Object>> getServiceSubtaskDetails(@RequestBody ServiceSubtaskDetailVO serviceSubtaskDetailVO) {
+        List<Map<String, Object>> map = new ArrayList<>();
+        map = ServiceSubtaskDetailService.getServiceSubtaskDetails(serviceSubtaskDetailVO);
+        return map;
+    }
 }
diff --git a/smartor/src/main/java/com/smartor/domain/ServiceSubtaskDetailVO.java b/smartor/src/main/java/com/smartor/domain/ServiceSubtaskDetailVO.java
index 46f3fd7..4d9d56d 100644
--- a/smartor/src/main/java/com/smartor/domain/ServiceSubtaskDetailVO.java
+++ b/smartor/src/main/java/com/smartor/domain/ServiceSubtaskDetailVO.java
@@ -178,5 +178,21 @@
     @ApiModelProperty(value = "绫诲埆ID")
     private Long categoryid;
 
+    /**
+     * 閮ㄩ棬code
+     */
+    @Excel(name = "  閮ㄩ棬code")
+    @ApiModelProperty(value = "閮ㄩ棬code闆嗗悎")
+    private List<String> leaveldeptcodes;
+
+    @ApiModelProperty("闂ID")
+    @Excel(name = "闂ID闆嗗悎")
+    private List<Long> scriptIds;
+    /**
+     * 鍑洪櫌鐥呭尯缂栧彿
+     */
+    @ApiModelProperty(value = "鍑洪櫌鐥呭尯缂栧彿闆嗗悎")
+    private List<String> leavehospitaldistrictcodes;
+
     private List<SvyTaskTemplateTargetoption> svyTaskTemplateTargetoptions;
 }
diff --git a/smartor/src/main/java/com/smartor/mapper/ServiceSubtaskDetailMapper.java b/smartor/src/main/java/com/smartor/mapper/ServiceSubtaskDetailMapper.java
index 8814884..5b2105d 100644
--- a/smartor/src/main/java/com/smartor/mapper/ServiceSubtaskDetailMapper.java
+++ b/smartor/src/main/java/com/smartor/mapper/ServiceSubtaskDetailMapper.java
@@ -3,10 +3,12 @@
 import com.smartor.domain.DTO.ServiceSubtaskDetailDTO;
 import com.smartor.domain.ServiceSubtaskDetail;
 import com.smartor.domain.ServiceSubtaskDetailTarget;
+import com.smartor.domain.ServiceSubtaskDetailVO;
 import org.apache.ibatis.annotations.Mapper;
 import org.apache.ibatis.annotations.Param;
 
 import java.util.List;
+import java.util.Map;
 
 /**
  * 璇煶浠诲姟鍛煎彨鏄庣粏Mapper鎺ュ彛
@@ -37,6 +39,10 @@
     public List<ServiceSubtaskDetail> selectServiceSubtaskDetailList(ServiceSubtaskDetail serviceSubtaskDetail);
 
     /**
+     * 鏌ヨ闅忚璇︽儏-鎸囨爣璁板綍
+     */
+    public List<Map<String, Object>> getServiceSubtaskDetails(ServiceSubtaskDetailVO serviceSubtaskDetailVo);
+    /**
      * 鏂板璇煶浠诲姟鍛煎彨鏄庣粏
      *
      * @param serviceSubtaskDetail 璇煶浠诲姟鍛煎彨鏄庣粏
diff --git a/smartor/src/main/java/com/smartor/service/IServiceSubtaskDetailService.java b/smartor/src/main/java/com/smartor/service/IServiceSubtaskDetailService.java
index fc859f9..c917f84 100644
--- a/smartor/src/main/java/com/smartor/service/IServiceSubtaskDetailService.java
+++ b/smartor/src/main/java/com/smartor/service/IServiceSubtaskDetailService.java
@@ -2,6 +2,7 @@
 
 import com.smartor.domain.ServiceSubtaskDetail;
 import com.smartor.domain.ServiceSubtaskDetailTarget;
+import com.smartor.domain.ServiceSubtaskDetailVO;
 
 import java.util.List;
 import java.util.Map;
@@ -29,6 +30,8 @@
      */
     public Map<String, Object> selectServiceSubtaskDetailList(ServiceSubtaskDetail serviceSubtaskDetail);
 
+    public List<Map<String, Object>> getServiceSubtaskDetails(ServiceSubtaskDetailVO serviceSubtaskDetailVo);
+
     /**
      * 鏂板璇煶浠诲姟鍛煎彨鏄庣粏
      *
diff --git a/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskDetailServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskDetailServiceImpl.java
index 599d1ef..f96a3d0 100644
--- a/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskDetailServiceImpl.java
+++ b/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskDetailServiceImpl.java
@@ -130,12 +130,17 @@
         return map;
     }
 
-    /**
-     * 鏂板璇煶浠诲姟鍛煎彨鏄庣粏
-     *
-     * @param serviceSubtaskDetail 璇煶浠诲姟鍛煎彨鏄庣粏
-     * @return 缁撴灉
-     */
+    @Override
+    public List<Map<String, Object>> getServiceSubtaskDetails(ServiceSubtaskDetailVO serviceSubtaskDetailVO) {
+        List<Map<String, Object>> serviceSubtaskDetails = ServiceSubtaskDetailMapper.getServiceSubtaskDetails(serviceSubtaskDetailVO);
+        return serviceSubtaskDetails;
+    }
+        /**
+         * 鏂板璇煶浠诲姟鍛煎彨鏄庣粏
+         *
+         * @param serviceSubtaskDetail 璇煶浠诲姟鍛煎彨鏄庣粏
+         * @return 缁撴灉
+         */
     @Override
     public int insertServiceSubtaskDetail(ServiceSubtaskDetail serviceSubtaskDetail) {
         serviceSubtaskDetail.setCreateTime(DateUtils.getNowDate());
diff --git a/smartor/src/main/resources/mapper/smartor/ServiceSubtaskDetailMapper.xml b/smartor/src/main/resources/mapper/smartor/ServiceSubtaskDetailMapper.xml
index 1a09422..0591b17 100644
--- a/smartor/src/main/resources/mapper/smartor/ServiceSubtaskDetailMapper.xml
+++ b/smartor/src/main/resources/mapper/smartor/ServiceSubtaskDetailMapper.xml
@@ -179,6 +179,59 @@
 
     </select>
 
+    <select id="getServiceSubtaskDetails" parameterType="com.smartor.domain.ServiceSubtaskDetailVO"
+            resultType="java.util.HashMap">
+        select
+            ssd.sub_id,
+            ssd.taskid,
+            ssd.patid,
+            sd.sendname,
+            ssd.questiontext,
+            ssd.matchedtext,
+            ssd.asrtext,
+            ssd.scriptid,
+            ssd.targetid,
+            ssd.template_type,
+            ssd.lib_templateid,
+            sd.deptcode,
+            sd.deptname,
+            sd.leavehospitaldistrictcode,
+            sd.leavehospitaldistrictname
+        from service_subtask_detail ssd
+        inner join service_subtask sd on ssd.sub_id = sd.id
+        where ssd.del_flag = '0'
+        and sd.del_flag = '0'
+        <if test="orgid != null and orgid != ''">and ssd.orgid = #{orgid}</if>
+        <if test="subId != null">and ssd.sub_id = #{subId}</if>
+        <if test="taskid != null">and ssd.taskid = #{taskid}</if>
+        <if test="questiontext != null and questiontext != ''">and ssd.questiontext = #{questiontext}</if>
+        <if test="matchedtext != null and matchedtext != ''">and ssd.matchedtext = #{matchedtext}</if>
+        <if test="asrtext != null and asrtext != ''">and ssd.asrtext = #{asrtext}</if>
+        <if test="scriptid != null">and ssd.scriptid = #{scriptid}</if>
+        <if test="patid != null">and ssd.patid = #{patid}</if>
+        <if test="templateType != null">and ssd.template_type = #{templateType}</if>
+        <if test="libTemplateid != null">and ssd.lib_templateid = #{libTemplateid}</if>
+        <if test="targetid != null">and ssd.targetid = #{targetid}</if>
+        <if test="leavehospitaldistrictcodes != null and leavehospitaldistrictcodes.size() > 0">
+            and sd.leavehospitaldistrictcode in
+            <foreach collection="leavehospitaldistrictcodes" item="leavehospitaldistrictcode" open="(" separator="," close=")">
+                #{leavehospitaldistrictcode}
+            </foreach>
+        </if>
+        <if test="leaveldeptcodes != null and leaveldeptcodes.size() > 0">
+            and sd.deptcode in
+            <foreach collection="leaveldeptcodes" item="leaveldeptcode" open="(" separator="," close=")">
+                #{leaveldeptcode}
+            </foreach>
+        </if>
+        <if test="scriptIds != null and scriptIds.size() > 0">
+            and ssd.scriptid in
+            <foreach collection="scriptIds" item="scriptId" open="(" separator="," close=")">
+                #{scriptId}
+            </foreach>
+        </if>
+        order by ssd.sub_id desc, ssd.id desc
+    </select>
     <select id="selectServiceSubtaskDetailByCalldetailid" parameterType="String" resultMap="ServiceSubtaskDetailResult">
         <include refid="selectServiceSubtaskDetailVo"/>
         where id = #{id}

--
Gitblit v1.9.3