From 65dcb16e025e2e7e155c9ea494a815935826d75f Mon Sep 17 00:00:00 2001
From: gongchunyi <deslre0381@gmail.com>
Date: 星期六, 08 八月 2026 17:55:19 +0800
Subject: [PATCH] fix: 根据编号倒序
---
src/main/resources/mapper/production/ProductWorkOrderMapper.xml | 1 +
src/main/resources/mapper/production/ProcessRouteMapper.xml | 2 +-
src/main/resources/mapper/production/ProductOrderMapper.xml | 1 +
src/main/resources/mapper/production/ProductBomMapper.xml | 1 +
4 files changed, 4 insertions(+), 1 deletions(-)
diff --git a/src/main/resources/mapper/production/ProcessRouteMapper.xml b/src/main/resources/mapper/production/ProcessRouteMapper.xml
index 51c11b4..3cf1322 100644
--- a/src/main/resources/mapper/production/ProcessRouteMapper.xml
+++ b/src/main/resources/mapper/production/ProcessRouteMapper.xml
@@ -23,6 +23,6 @@
and pm.model like concat('%',#{c.model},'%')
</if>
</where>
- order by ps.id asc
+ order by ps.process_route_code desc
</select>
</mapper>
diff --git a/src/main/resources/mapper/production/ProductBomMapper.xml b/src/main/resources/mapper/production/ProductBomMapper.xml
index ec06cd3..d28fa0a 100644
--- a/src/main/resources/mapper/production/ProductBomMapper.xml
+++ b/src/main/resources/mapper/production/ProductBomMapper.xml
@@ -35,6 +35,7 @@
<if test="c.version != null">
and version = #{c.version}
</if>
+ order by pb.bom_no desc
</select>
<select id="getById" resultType="com.ruoyi.production.dto.ProductBomDto">
select pb.*,
diff --git a/src/main/resources/mapper/production/ProductOrderMapper.xml b/src/main/resources/mapper/production/ProductOrderMapper.xml
index 6b993bf..33c2506 100644
--- a/src/main/resources/mapper/production/ProductOrderMapper.xml
+++ b/src/main/resources/mapper/production/ProductOrderMapper.xml
@@ -64,6 +64,7 @@
and po.create_time between #{c.startTime} and #{c.endTime}
</if>
</where>
+ order by po.nps_no desc
</select>
<select id="listProcessRoute" resultType="com.ruoyi.production.pojo.ProcessRoute">
select pr.*
diff --git a/src/main/resources/mapper/production/ProductWorkOrderMapper.xml b/src/main/resources/mapper/production/ProductWorkOrderMapper.xml
index 60257a2..9fd4794 100644
--- a/src/main/resources/mapper/production/ProductWorkOrderMapper.xml
+++ b/src/main/resources/mapper/production/ProductWorkOrderMapper.xml
@@ -61,6 +61,7 @@
<if test="c.productOrderId != null and c.productOrderId != ''">
and pwo.product_order_id = #{c.productOrderId}
</if>
+ order by pwo.work_order_no desc
</select>
<select id="getProductWorkOrderFlowCard" resultType="com.ruoyi.production.dto.ProductWorkOrderDto">
--
Gitblit v1.9.3