From c1a9747777ea9aee817f306475c94031e5559cc4 Mon Sep 17 00:00:00 2001 From: xiangpei <xiangpei@timesnew.cn> Date: 星期三, 23 四月 2025 20:04:12 +0800 Subject: [PATCH] 项目、工程按照录入时间升序排列 --- business/src/main/resources/mapper/ProjectInfoMapper.xml | 2 +- business/src/main/resources/mapper/ProjectProcessMapper.xml | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/business/src/main/resources/mapper/ProjectInfoMapper.xml b/business/src/main/resources/mapper/ProjectInfoMapper.xml index 8791fc5..2c6acca 100644 --- a/business/src/main/resources/mapper/ProjectInfoMapper.xml +++ b/business/src/main/resources/mapper/ProjectInfoMapper.xml @@ -178,7 +178,7 @@ ${query.params.dataScope} </if> </where> - ORDER BY FIELD(TPI.used_status, 1, -1, 0, 2), TPI.gmt_create DESC + ORDER BY FIELD(TPI.used_status, 1, -1, 0, 2), TPI.gmt_create ASC </select> <select id="homeCount" parameterType="com.ycl.common.core.domain.BaseEntity" resultType="com.ycl.domain.vo.ProjectVO"> diff --git a/business/src/main/resources/mapper/ProjectProcessMapper.xml b/business/src/main/resources/mapper/ProjectProcessMapper.xml index b938fa6..53e153c 100644 --- a/business/src/main/resources/mapper/ProjectProcessMapper.xml +++ b/business/src/main/resources/mapper/ProjectProcessMapper.xml @@ -160,7 +160,7 @@ </if> ${query.params.dataScope} </where> - + ORDER BY PI.gmt_create ASC </select> -- Gitblit v1.8.0