【丽水】查询患者随访信息接口优化调试

陈昶聿

4 天以前 291eb6b69cfe7f09efee63977ef7935543fd4e21

 smartor/src/main/java/com/smartor/mapper/ServiceSubtaskMapper.java

@@ -5,6 +5,7 @@
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * 单一任务（随访）Mapper接口
@@ -30,11 +31,17 @@
     */
    public List<ServiceSubtask> selectServiceSubtaskList(ServiceSubtaskVO serviceSubtaskVO);

    public List<ServiceSubtask> selectServiceSubtaskByDiagname(ServiceSubtask serviceSubtask);

    public List<ServiceSubtask> queryServiceSubtaskList(ServiceSubtaskVO serviceSubtaskVO);

    public List<ServiceSubtask> selectServiceSubtaskBySendstate(ServiceSubtaskVO serviceSubtaskVO);

    public List<ServiceSubtask> selectServiceSubtaskListByCreateTime(ServiceSubtaskVO serviceSubtaskVO);

    public List<ServiceSubtask> selectServiceSubtaskListAgain(ServiceSubtaskVO serviceSubtaskVO);

    public Integer selectSendstateByCondition(ServiceSubtask serviceSubtask);
    public List<Integer> selectSendstateByCondition(ServiceSubtask serviceSubtask);

    /**
     * 新增单一任务（随访）
@@ -45,11 +52,28 @@
    public int insertServiceSubtask(ServiceSubtask ServiceSubtask);

    /**
     * 随访及时率：应随访时间<实际随访时间
     *
     * @param ServiceSubtask
     * @return
     */
    public Double selectTimelyRate(ServiceSubtask ServiceSubtask);

    /**
     * 随访及时率详情
     *
     * @param ServiceSubtask
     * @return
     */
    public List<ServiceSubtask> selectTimelyRateDetail(ServiceSubtask ServiceSubtask);

    /**
     * 修改单一任务（随访）
     *
     * @return 结果
     */
    public Boolean updateServiceSubtask(ServiceSubtask ServiceSubtask);

    public Boolean updateServiceSubtaskByPatId(ServiceSubtask ServiceSubtask);

    public Boolean updateServiceSubtaskByCondition(ServiceSubtask ServiceSubtask);
@@ -77,6 +101,28 @@

    public List<ServiceSubtask> getSfStatistics(ServiceSubtaskCountReq serviceSubtaskCountReq);

    public List<ServiceSubtaskCount> getSfStatisticsJoy(ServiceSubtaskCountReq serviceSubtaskCountReq);

    public List<ServiceSubtaskCount> getSfStatisticsJoydetails(ServiceSubtaskCountReq serviceSubtaskCountReq);

    public List<PatMedRes> getDeptRanking(PatMedReq patMedReq);

    public List<ServiceStatisticsResponse> getServiceStatistics(ServiceStatisticsRequest serviceStatisticsRequest);

    /**
     * 统计任务各种状态的数量（优化版）
     * 用于替代应用层的循环统计，直接在数据库层进行聚合计算
     *
     * @param serviceSubtaskVO 查询条件
     * @return Map<String, Object> 包含各状态统计数据
     *         wzx: 未执行数量
     *         ysf: 已随访数量
     *         fssb: 发送失败数量
     *         yfs: 已发送数量
     *         dsf: 待随访数量
     *         blq: 不理睬数量
     *         yc: 异常数量
     */
    public Map<String, Object> countByCondition(ServiceSubtaskVO serviceSubtaskVO);

}