From 39f10c1616fa5f2173c070c268b8aa77734c10bd Mon Sep 17 00:00:00 2001 From: Lius <Lius2225@163.com> Date: 星期四, 27 二月 2025 11:35:50 +0800 Subject: [PATCH] 大屏车间管理报错修复 --- lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/xml/MdcWorkshopInfoMapper.xml | 2 +- 1 files changed, 1 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 e286929..b41f8da 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 @@ -18,7 +18,7 @@ me.id equId FROM EquipmentLog a - INNER JOIN ( SELECT EquipmentID, MAX ( CollectTime ) 'maxgdtime' FROM EquipmentLog GROUP BY EquipmentID ) b ON a.EquipmentID= b.EquipmentID + INNER JOIN ( SELECT EquipmentID, MAX ( CollectTime ) maxgdtime FROM EquipmentLog GROUP BY EquipmentID ) b ON a.EquipmentID= b.EquipmentID 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 -- Gitblit v1.9.3