【丽水】getSpecialSfStatistics 获取专病随访统计比例

陈昶聿

3 小时以前 1b88746f85ed05f571d0ef0307f6b68db4157ee2

【丽水】getSpecialSfStatistics 获取专病随访统计比例

 smartor/src/main/java/com/smartor/domain/ServiceSubtaskCountReq.java

@@ -182,6 +182,24 @@
    @ApiModelProperty(value = "超链接统计列表类型")
    private String hyperLinkInfoType;

    @ApiModelProperty(value = "任务ID", required = true)
    private Long taskId;

    @ApiModelProperty(value = "taskIds集合")
    private List<Long> taskIds;

    @ApiModelProperty(value = "任务名称")
    private String taskName;

    @ApiModelProperty(value = "taskNamee集合")
    private List<String> taskNames;

    @ApiModelProperty(value = "疾病病种")
    private String diagType;

    @ApiModelProperty(value = "diagType集合")
    private List<String> diagTypes;

    /**
     * pageNum
     */

 smartor/src/main/resources/mapper/smartor/ServiceSubtaskMapper.xml

@@ -1508,6 +1508,7 @@
    <select id="getSpecialSfStatistics" parameterType="com.smartor.domain.ServiceSubtaskCountReq"
            resultMap="ServiceSubtaskStatisticResult">
        select
        a.task_name,
        COUNT(1) AS discharge_count,
        SUM(CASE WHEN b.sendstate = 4 THEN 1 ELSE 0 END) AS non_follow_up,
        SUM(CASE WHEN b.sendstate = 4 and b.task_situation = 6 THEN 1 ELSE 0 END) AS filter_count,
@@ -1542,6 +1543,27 @@
        </if>
        <if test="diagType != null and diagType != ''">
            and a.diag_type = #{diagType}
        </if>
        <if test="taskIds != null and taskIds.size() > 0">
            AND a.task_id IN
            <foreach collection="taskIds" item="taskIdItem" open="(" separator=","
                     close=")">
                #{taskIdItem}
            </foreach>
        </if>
        <if test="taskNames != null and taskNames.size() > 0">
            AND a.task_name IN
            <foreach collection="taskNames" item="taskNameItem" open="(" separator=","
                     close=")">
                #{taskNameItem}
            </foreach>
        </if>
        <if test="diagTypes != null and diagTypes.size() > 0">
            AND a.diag_type IN
            <foreach collection="diagTypes" item="diagTypeItem" open="(" separator=","
                     close=")">
                #{diagTypeItem}
            </foreach>
        </if>
        <if test="leavehospitaldistrictcodes != null and leavehospitaldistrictcodes.size() > 0">
            AND b.leavehospitaldistrictcode IN
@@ -1585,9 +1607,7 @@
        <if test="visitCount != null and visitCount > 1">
            AND b.visit_count > 1
        </if>
        <if test="groupKey != null and groupKey != ''">
            GROUP BY ${groupKey}
        </if>
        GROUP BY a.task_name
    </select>

    <select id="getSfStatisticsGroupKey" parameterType="com.smartor.domain.ServiceSubtaskCountReq"