package com.smartor.mapper;
|
|
import com.smartor.domain.*;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* 单一任务（随访）Mapper接口
|
*
|
* @author ruoyi
|
* @date 2024-02-02
|
*/
|
@Mapper
|
public interface ServiceSubtaskMapper {
|
/**
|
* 查询单一任务（随访）
|
*
|
* @param id 单一任务（随访）主键
|
* @return 单一任务（随访）
|
*/
|
public ServiceSubtask selectServiceSubtaskById(Long id);
|
|
/**
|
* 查询单一任务（随访）列表
|
*
|
* @param serviceSubtaskVO 单一任务（随访）
|
* @return 单一任务（随访）集合
|
*/
|
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 List<Integer> selectSendstateByCondition(ServiceSubtask serviceSubtask);
|
|
/**
|
* 新增单一任务（随访）
|
*
|
* @param ServiceSubtask 单一任务（随访）
|
* @return 结果
|
*/
|
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);
|
|
public Boolean updateServiceSubtaskByTaskGuid(ServiceSubtask ServiceSubtask);
|
|
/**
|
* 删除单一任务（随访）
|
*
|
* @param id 单一任务（随访）主键
|
* @return 结果
|
*/
|
public int deleteServiceSubtaskById(Long id);
|
|
public int deleteServiceSubtaskByCondition(@Param("taskid") Long id, @Param("patid") Long patid);
|
|
/**
|
* 删除单一任务（随访）
|
*
|
* @return 结果
|
*/
|
public List<ServiceSubtask> getDataByTime(@Param("beganTime") String beganTime, @Param("endTime") String endTime);
|
|
public List<ServiceSubtaskCount> getSfFzInfoEveryMonth(ServiceSubtaskCountReq serviceSubtaskCountReq);
|
|
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);
|
|
}
|
