liusheng
8 天以前 34f78281cf395a24e1f3f1c3b861186ff8a03b7b
smartor/src/main/java/com/smartor/mapper/ServiceSubtaskDetailMapper.java
@@ -1,10 +1,14 @@
package com.smartor.mapper;
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接口
@@ -13,8 +17,7 @@
 * @date 2023-03-24
 */
@Mapper
public interface ServiceSubtaskDetailMapper
{
public interface ServiceSubtaskDetailMapper {
    /**
     * 查询语音任务呼叫明细
     *
@@ -23,6 +26,21 @@
     */
    public ServiceSubtaskDetail selectServiceSubtaskDetailByCalldetailid(String calldetailid);
    public List<ServiceSubtaskDetailDTO> queryFillCount(@Param("subids") List<Long> subids, @Param("questiontext") String questiontext);
    /**
     * 按 scriptid 批量统计填写记录数(一次 SQL 替代逐个 scriptid 查明细)
     * <p>
     * 口径与原来「query.setScriptid(scriptId) 后 selectServiceSubtaskDetailList(...).size()」一致:
     * 只按 scriptid 过滤,不带 del_flag(原 SQL 里并没有 del_flag 条件)。
     *
     * @param scriptIds 问题ID集合
     * @return 每行含 scriptid、cnt
     */
    public List<Map<String, Object>> countDetailByScriptIds(@Param("scriptIds") List<Long> scriptIds);
    public ServiceSubtaskDetailDTO isExistServiceSubtaskDetail(@Param("subid") Long subid, @Param("scriptid") Long scriptid);
    /**
     * 查询语音任务呼叫明细列表
     *
@@ -30,6 +48,11 @@
     * @return 语音任务呼叫明细集合
     */
    public List<ServiceSubtaskDetail> selectServiceSubtaskDetailList(ServiceSubtaskDetail serviceSubtaskDetail);
    /**
     * 查询随访详情-指标记录
     */
    public List<Map<String, Object>> getServiceSubtaskDetails(ServiceSubtaskDetailVO serviceSubtaskDetailVo);
    /**
     * 新增语音任务呼叫明细
@@ -46,6 +69,7 @@
     * @return 结果
     */
    public int updateServiceSubtaskDetail(ServiceSubtaskDetail serviceSubtaskDetail);
    public int updateSSDByCondition(ServiceSubtaskDetail serviceSubtaskDetail);
    /**
@@ -63,7 +87,6 @@
     * @return 结果
     */
    public int deleteServiceSubtaskDetailByCalldetailids(String[] calldetailids);
    /**
     * 指标统计