项目库分类bug

fuliqi

2024-11-29 334197c2f176795e78c46baa1271bb9a3c3bf302

项目库分类bug

 business/src/main/java/com/ycl/service/impl/ProjectInfoServiceImpl.java

@@ -156,6 +156,7 @@
            query.setProjectEndTime(DateUtils.getDayEnd(query.getProjectEndTime()));
        }
        String projectCategory = query.getProjectCategory();
        //实施阶段有两个值放在sql处理
        if (ProjectCategoryEnum.RESERVE.getType().equals(projectCategory)) {
            query.setProjectStatus(ProjectCategoryEnum.RESERVE.getStatus());
            query.setReserveOrPrevious(ProjectCategoryEnum.RESERVE.getCode());

 business/src/main/resources/mapper/ProjectInfoMapper.xml

@@ -149,6 +149,9 @@
            <if test="query.reserveOrPrevious != null and query.reserveOrPrevious == 'previous'">
                and TPP.process_instance_id is not null
            </if>
            <if test="query.projectCategory == 3">
                and (TPI.project_status = 'working' or TPI.project_status = 'stop')
            </if>
        </where>
        order by TPI.gmt_create
    </select>