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

陈昶聿

4 天以前 291eb6b69cfe7f09efee63977ef7935543fd4e21

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

@@ -31,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);

    /**
     * 新增单一任务（随访）
@@ -97,8 +103,26 @@

    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);

}