skjcmanager/skjcmanager-service-api/skjcmanager-sm-api/src/main/java/cn/gistack/sm/sg/DTO/ProjectSearchDTO.java
@@ -160,6 +160,7 @@ * 部门ID */ private String deptId; private String othRegCd; /** * 是否单位过滤 1不过滤 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sg/mapper/SgProjectInfoMapper.xml
@@ -91,6 +91,9 @@ <if test="dto.adCode != null and dto.adCode !=''"> and dria."county_cd" = #{dto.adCode} </if> <if test="dto.othRegCd != null and dto.othRegCd !=''"> and dria."oth_reg_cd" = #{dto.othRegCd} </if> <if test="dto.projectSort == null"> ORDER BY TO_NUMBER(info.project_progress) desc NULLS LAST,info.status desc </if>
