【丽水】随访异常导出

陈昶聿

2026-04-28 2dc0e508dacff4acd61bec58c3549db0e673bcbe

【丽水】随访异常导出

 ruoyi-admin/src/main/java/com/ruoyi/web/controller/smartor/ServiceSubtaskController.java

@@ -20,6 +20,7 @@
import com.ruoyi.common.utils.StringUtils;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.common.utils.reflect.ReflectUtils;
import com.ruoyi.quartz.task.RyTask;
import com.ruoyi.system.service.ISysConfigService;
import com.ruoyi.system.service.ISysUserDeptService;
import com.smartor.domain.*;
@@ -77,6 +78,9 @@

    @Autowired
    private ISysConfigService configService;

    @Autowired
    private RyTask ryTask;

    @Value("${spring.profiles.active}")
    private String active;
@@ -580,6 +584,25 @@
        return success(serviceStatistics);
    }

    /**
     * éšè®¿å¼‚常统计导出
     */
    //@PreAuthorize("@ss.hasPermi('system:taskcall:export')")
    @Log(title = "随访统计导出", businessType = BusinessType.EXPORT)
    @PostMapping("/getSfStatisticsIsAbnormalExport")
    public void getSfStatisticsIsAbnormalExport(HttpServletResponse response, ServiceSubtaskCountReq serviceSubtaskCountReq) {
        List<ServiceSubtaskIsAbnormalStatistic> sfStatistics = serviceSubtaskService.getSfStatisticsIsAbnormalExport(serviceSubtaskCountReq);
        ExcelUtil<ServiceSubtaskIsAbnormalStatistic> util = new ExcelUtil<ServiceSubtaskIsAbnormalStatistic>(ServiceSubtaskIsAbnormalStatistic.class);
        String sheetName = "";
        String fileName = "";
        if (active.equals("ls") || active.equals("druid")) {
            fileName = sheetName = LocalDate.now().getMonthValue() + "月出院随访异常统计表";
            util.exportExcelWithFileName(response, sfStatistics, sheetName, fileName);
        } else {
            sheetName = "随访异常统计导出";
            util.exportExcel(response, sfStatistics, sheetName);
        }
    }

    /**
     * èŽ·å–随访统计比例
@@ -737,4 +760,9 @@
        return serviceSubtaskService.getHeLibraryCount(heLibraryCountVO);
    }


    @PostMapping("/test")
    public void test() {
        ryTask.longTaskSend();
    }
}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,71 @@
package com.smartor.domain;

import com.ruoyi.common.annotation.Excel;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.io.Serializable;
import java.util.List;

/**
 * å„病区随访统计比例
 *
 * @author ruoyi
 * @date 2024-12-11
 */
@ApiModel(value = "ServiceSubtaskStatistic", description = "各病区随访统计比例")
@Data
public class ServiceSubtaskIsAbnormalStatistic implements Serializable {
    private static final long serialVersionUID = 1L;

    @ApiModelProperty(value = "科室病区")
    private Integer statisticaltype;

    @ApiModelProperty(value = "出院病区编号")
    private String leavehospitaldistrictcode;

    @ApiModelProperty(value = "出院病区名称")
    @Excel(name = " å‡ºé™¢ç—…区名称 ")
    private String leavehospitaldistrictname;

    @ApiModelProperty(value = "出院科室编号")
    private String deptcode;

    @ApiModelProperty(value = "出院科室名称")
    @Excel(name = " å‡ºé™¢ç—…区名称 ")
    private String deptname;

    /**
     * æ€§åˆ«
     */
    @ApiModelProperty(value = "性别 1男  2女")
    private Long sex;

    @ApiModelProperty(value = "异常人数0-10岁")
    private Long abnormalCount010 = 0L;

    @ApiModelProperty(value = "异常人数10-20岁")
    private Long abnormalCount1020 = 0L;

    @ApiModelProperty(value = "异常人数20-30岁")
    private Long abnormalCount2030 = 0L;

    @ApiModelProperty(value = "异常人数30-40岁")
    private Long abnormalCount3040 = 0L;

    @ApiModelProperty(value = "异常人数40-50岁")
    private Long abnormalCount4050 = 0L;

    @ApiModelProperty(value = "异常人数50-60岁")
    private Long abnormalCount5060 = 0L;

    @ApiModelProperty(value = "异常人数60-70岁")
    private Long abnormalCount6070 = 0L;

    @ApiModelProperty(value = "异常人数70-80岁")
    private Long abnormalCount7090 = 0L;

    @ApiModelProperty(value = "异常人数80岁以上")
    private Long abnormalCount80More = 0L;
}

 smartor/src/main/java/com/smartor/service/IServiceSubtaskService.java

@@ -137,6 +137,9 @@
    //导出随访
    public List<ServiceSubtaskStatistic> getSfStatisticsExport(ServiceSubtaskCountReq serviceSubtaskCountReq);

    //导出随访-异常
    public List<ServiceSubtaskIsAbnormalStatistic> getSfStatisticsIsAbnormalExport(ServiceSubtaskCountReq serviceSubtaskCountReq);

    public List<ServiceSubtaskStatistic> getSfStatisticsJoy(ServiceSubtaskCountReq serviceSubtaskCountReq);

    public List<ServiceSubtaskCount> getSfStatisticsJoydetails(ServiceSubtaskCountReq serviceSubtaskCountReq);

 smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskAnswerServiceImpl.java

@@ -457,7 +457,9 @@

            //将当前发送状态改成9完成
            ServiceSubtaskPreachform serviceSubtaskPreachform = new ServiceSubtaskPreachform();
            serviceSubtaskPreachform.setPreachform(serviceSubtaskList.get(0).getCurrentPreachform());
            if (CollectionUtils.isNotEmpty(serviceSubtaskList)) {
                serviceSubtaskPreachform.setPreachform(serviceSubtaskList.get(0).getCurrentPreachform());
            }
            serviceSubtaskPreachform.setSubid(serviceSubtask.getId());
            serviceSubtaskPreachform.setTaskid(serviceSubtask.getTaskid());
            List<ServiceSubtaskPreachform> serviceSubtaskPreachforms = serviceSubtaskPreachformMapper.selectServiceSubtaskPreachformList(serviceSubtaskPreachform);
@@ -900,7 +902,7 @@
        }

        //判断一下当前的问题是不是满意度问题，并且dutyDeptCode是否有值，并且选项是不是异常选项，如果全符合，则往满意度问题异常表新增
        if (StringUtils.isNotEmpty(svyTaskTemplateScriptVO.getDutyDeptCode()) && 1 == stt.getIsabnormal()) {
        if (StringUtils.isNotEmpty(svyTaskTemplateScriptVO.getDutyDeptCode()) && stt != null && 1 == stt.getIsabnormal()) {
            isabnormalFlag = 1L;
            ServiceSubtaskDetailTrace subtaskDetailTrace = new ServiceSubtaskDetailTrace();
            subtaskDetailTrace.setDetailId(serviceSubtaskDetail.getId());

 smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskServiceImpl.java

@@ -2477,7 +2477,7 @@
        return jsRates;
    }

    @Override

    public List<ServiceSubtaskStatistic> getSfStatisticsExport(ServiceSubtaskCountReq serviceSubtaskCountReq) {
        List<ServiceSubtaskStatistic> sfStatistics = getSfStatistics(serviceSubtaskCountReq);
        // æ·»åŠ æ€»è®¡è¡Œ
@@ -2491,6 +2491,12 @@
        return sfStatistics;
    }

    @Override
    public List<ServiceSubtaskIsAbnormalStatistic> getSfStatisticsIsAbnormalExport(ServiceSubtaskCountReq serviceSubtaskCountReq){

        return null;
    }

    /**
     * èŽ·å–随访统计比例
     *