From 398007a3e6815bd9543a22fbfe53b1db882abbe9 Mon Sep 17 00:00:00 2001
From: liurunyu <lry9898@163.com>
Date: 星期二, 27 五月 2025 11:02:44 +0800
Subject: [PATCH] 排班设置时，关联查询生产任务，修改其中的排序算法，任务是倒序，流程结点是升序
---
pms-parent/pms-global/src/main/resources/mapper/PrAssemblyPlanMapper.xml | 8 +++++++-
1 files changed, 7 insertions(+), 1 deletions(-)
diff --git a/pms-parent/pms-global/src/main/resources/mapper/PrAssemblyPlanMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/PrAssemblyPlanMapper.xml
index 0fbe098..a57b77b 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/PrAssemblyPlanMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/PrAssemblyPlanMapper.xml
@@ -423,12 +423,18 @@
</select>
<select id="selectByPlanName" resultType="cn.hutool.json.JSONObject">
- select ap.id planId,ap.name planName,ap.`status`,pn.id nodeId,pn.content from pr_assembly_plan ap
+ select ap.id planId,
+ ap.name planName,
+ ap.`status`,
+ pn.id nodeId,
+ pn.content
+ from pr_assembly_plan ap
left join pr_production_node pn on ap.process_id = pn.process_id
where status != -1
<if test="planName != null and planName!= ''">
and ap.name like concat('%', #{planName}, '%')
</if>
+ order by ap.id desc, pn.id asc
</select>
<select id="queryPlanList" resultType="cn.hutool.json.JSONObject">
--
Gitblit v1.8.0