处理数据查询慢的问题

liusheng

3 天以前 a77bf9fb4718d1b657f8ef8c6edfaffa1a53683f

处理数据查询慢的问题

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

@@ -89,8 +89,8 @@
    //@PreAuthorize("@ss.hasPermi('system:taskcall:list')")
//    @Cacheable(value = "patItem", key = "T(org.springframework.util.DigestUtils).md5DigestAsHex(#serviceSubtaskVO.toString().getBytes())", unless = "#result == null or #result.isEmpty()")
    @PostMapping("/patItem")
    public TableDataInfo patItem(@RequestBody ServiceSubtaskVO serviceSubtaskVO) {
        PageUtils.startPageByPost(serviceSubtaskVO.getPageNum(), serviceSubtaskVO.getPageSize());
    public Map<String, Object> patItem(@RequestBody ServiceSubtaskVO serviceSubtaskVO) {
        serviceSubtaskVO.setPageNum(PageUtils.getOffset(serviceSubtaskVO.getPageNum(), serviceSubtaskVO.getPageSize()));
        List<ServiceSubtask> serviceSubtaskList = null;
        LoginUser loginUser = getLoginUser();
        SysUser user = loginUser.getUser();
@@ -111,21 +111,16 @@
        }

//      patItemCount 调用redisCache记录统计数据
//      Map<String, Object> map = patItemCount(serviceSubtaskVO);
        Map<String, Object> map = serviceSubtaskService.patItemCount(serviceSubtaskVO);
        map.put("serviceSubtaskList", serviceSubtaskList);
        List<Map<String, Object>> list = new ArrayList<>();
        list.add(map);
        //获取total
        long total = PageUtils.count(new ISelect() {
            @Override
            public void doSelect() {

                serviceSubtaskVO.setPageNum(null);
                serviceSubtaskVO.setPageSize(null);
                serviceSubtaskService.patItem(serviceSubtaskVO);
            }
        });
        return getDataTable2(total, list);
        List<ServiceSubtask> serviceSubtasks = serviceSubtaskService.patItem(serviceSubtaskVO);

        return getDataTable3(CollectionUtils.isNotEmpty(serviceSubtasks) ? serviceSubtasks.size() : 0L, list);
    }

    /**
@@ -490,8 +485,7 @@
        if (CollectionUtils.isEmpty(serviceSubtaskCountReq.getServiceType())) {
            return error("服务类型不能为空");
        }
        String followUpCountStyle = configService.selectConfigByKey("followUpCountStyle",
                serviceSubtaskCountReq.getOrgid());
        String followUpCountStyle = configService.selectConfigByKey("followUpCountStyle", serviceSubtaskCountReq.getOrgid());
        if (ObjectUtils.isNotEmpty(followUpCountStyle)){
            serviceSubtaskCountReq.setFollowUpCountStyle(followUpCountStyle);
        }else {

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

@@ -386,6 +386,7 @@
        result.putIfAbsent("wzx", 0);
        result.putIfAbsent("ysf", 0);
        result.putIfAbsent("yc", 0);
        result.putIfAbsent("jg", 0);
        result.putIfAbsent("fssb", 0);
        result.putIfAbsent("yfs", 0);
        result.putIfAbsent("blq", 0);

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

@@ -2017,7 +2017,8 @@
        SUM(CASE WHEN sendstate >= 3 OR sendstate = 1 THEN 1 ELSE 0 END) AS yfs,
        SUM(CASE WHEN sendstate = 2 THEN 1 ELSE 0 END) AS dsf,
        SUM(CASE WHEN sendstate = 1 THEN 1 ELSE 0 END) AS blq,
        SUM(CASE WHEN excep IS NOT NULL AND excep != '0' THEN 1 ELSE 0 END) AS yc
        SUM(CASE WHEN excep IS NOT NULL AND excep != '0' THEN 1 ELSE 0 END) AS yc,
        SUM(CASE WHEN isabnormal IS NOT NULL AND isabnormal = 2 THEN 1 ELSE 0 END) AS jg
        FROM service_subtask
        where 1=1
        and del_flag = 0

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

@@ -19,6 +19,7 @@
        <result property="updateBy" column="update_by"/>
        <result property="sort" column="sort"/>
        <result property="compensateTime" column="compensate_time"/>
        <result property="currentSendTime" column="current_send_time"/>
    </resultMap>

    <sql id="selectServiceSubtaskPreachformVo">
@@ -27,6 +28,7 @@
               taskid,
               preachform,
               sendstate,
               current_send_time,
               remark,
               orgid,
               del_flag,
@@ -49,6 +51,9 @@
            </if>
            <if test="taskid != null ">
                and taskid = #{taskid}
        </if>
        <if test="currentSendTime != null ">
            and current_send_time = #{currentSendTime}
            </if>
            <if test="preachform != null  and preachform != ''">
                and preachform = #{preachform}
@@ -106,6 +111,9 @@
            </if>
            <if test="compensateTime != null">compensate_time,
            </if>
            <if test="currentSendTime != null ">
                current_send_time,
            </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">#{id},
@@ -135,6 +143,9 @@
            <if test="sort != null">#{sort},
            </if>
            <if test="compensateTime != null">#{compensateTime},
            </if>
            <if test="currentSendTime != null ">
                #{currentSendTime},
            </if>
        </trim>
    </insert>
@@ -180,6 +191,9 @@
            </if>
            <if test="compensateTime != null">compensate_time =
                #{compensateTime},
            </if>
            <if test="currentSendTime != null ">
                current_send_time = #{currentSendTime},
            </if>
        </trim>
        where id = #{id}
@@ -227,22 +241,25 @@
            <if test="compensateTime != null">compensate_time =
                #{compensateTime},
            </if>
            <if test="currentSendTime != null ">
                current_send_time = #{currentSendTime},
            </if>
        </trim>
        where 1=1
            <if test="subid != null">and subid =
                #{subid}
                #{subid},
            </if>
            <if test="taskid != null">and taskid =
                #{taskid}
                #{taskid},
            </if>
            <if test="preachform != null">and preachform =
                #{preachform}
                #{preachform},
            </if>
            <if test="remark != null">and remark =
                #{remark}
                #{remark},
            </if>
            <if test="orgid != null">and orgid =
                #{orgid}
                #{orgid},
            </if>
    </update>

@@ -274,7 +291,8 @@
        </foreach>
    </update>

    <select id="selectBySubtask" parameterType="com.smartor.domain.ServiceSubtask" resultMap="ServiceSubtaskPreachformResult">
    <select id="selectBySubtask" parameterType="com.smartor.domain.ServiceSubtask"
            resultMap="ServiceSubtaskPreachformResult">
        <include refid="selectServiceSubtaskPreachformVo"/>
        WHERE del_flag = 0
        <!-- 其他条件 -->