From a3ca445facfebbe65d7133928eae1f9662451f6f Mon Sep 17 00:00:00 2001
From: Lius <Lius2225@163.com>
Date: 星期一, 03 三月 2025 17:07:34 +0800
Subject: [PATCH] update
---
lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/xml/MdcWorkshopInfoMapper.xml | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diff --git a/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/xml/MdcWorkshopInfoMapper.xml b/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/xml/MdcWorkshopInfoMapper.xml
index 61a43c1..1473670 100644
--- a/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/xml/MdcWorkshopInfoMapper.xml
+++ b/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/xml/MdcWorkshopInfoMapper.xml
@@ -22,8 +22,9 @@
INNER JOIN mdc_workshop_equipment mew ON mew.equipment_id = a.EquipmentID
INNER JOIN mdc_equipment me ON me.equipment_id = a.EquipmentID
INNER JOIN mdc_equipment_type met ON me.equipment_type = met.equipment_type_name
+ INNER JOIN mdc_workshop_info mwi ON mew.workshop_id = mwi.id
AND a.CollectTime= b.maxgdtime
- AND mew.production_id = #{ productionId }
+ AND mwi.production_id = #{ productionId }
</select>
<select id="listByUser" resultType="org.jeecg.modules.mdc.entity.MdcWorkshopInfo">
--
Gitblit v1.9.3