refactor(workorder): 将已退回工单数量字段更改为处置中工单数量

linwei

4 days ago 381600b0f215c8f782131f3f4cf763d7a2e1b8ac

refactor(workorder): 将已退回工单数量字段更改为处置中工单数量

- 将GdClueEventCountVO中的returnedCount字段重命名为disposingCount
- 更新实体映射文件中的字段映射从returned_count到disposing_count
- 修改SQL查询逻辑从统计状态2改为统计状态1的工单数量
- 更新服务实现类中对应的字段初始化逻辑

 drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/mapper/GdClueEventMapper.xml

@@ -78,7 +78,7 @@
    <resultMap id="gdClueEventCountVoResultMap" type="org.sxkj.gd.workorder.vo.GdClueEventCountVO">
        <result column="total_count" property="totalCount"/>
        <result column="my_count" property="myCount"/>
        <result column="returned_count" property="returnedCount"/>
        <result column="disposing_count" property="disposingCount"/>
        <result column="disposed_count" property="disposedCount"/>
        <result column="completed_count" property="completedCount"/>
    </resultMap>
@@ -208,7 +208,7 @@
    <select id="selectGdClueEventCount" resultMap="gdClueEventCountVoResultMap">
        select count(1) as total_count,
        COALESCE(sum(case when ce.dispose_user = #{userId} then 1 else 0 end), 0) as my_count,
        COALESCE(sum(case when ce.event_status = 2 then 1 else 0 end), 0) as returned_count,
        COALESCE(sum(case when ce.event_status = 1 then 1 else 0 end), 0) as disposing_count,
        COALESCE(sum(case when ce.event_status = 3 then 1 else 0 end), 0) as disposed_count,
        COALESCE(sum(case when ce.event_status = 4 then 1 else 0 end), 0) as completed_count
        from ja_gd_clue_event ce

 drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/service/impl/GdClueEventServiceImpl.java

@@ -201,7 +201,7 @@
            GdClueEventCountVO empty = new GdClueEventCountVO();
            empty.setTotalCount(0L);
            empty.setMyCount(0L);
            empty.setReturnedCount(0L);
            empty.setDisposingCount(0L);
            empty.setDisposedCount(0L);
            empty.setCompletedCount(0L);
            return empty;

 drone-service/drone-gd/src/main/java/org/sxkj/gd/workorder/vo/GdClueEventCountVO.java

@@ -37,8 +37,8 @@
    @ApiModelProperty(value = "我的工单数量")
    private Long myCount;

    @ApiModelProperty(value = "已退回工单数量（状态2）")
    private Long returnedCount;
    @ApiModelProperty(value = "处置中工单数量（状态1）")
    private Long disposingCount;

    @ApiModelProperty(value = "已处置工单数量（状态3）")
    private Long disposedCount;