From d9c38fdd6af4285e38cbd3917352ff3fea18ea2c Mon Sep 17 00:00:00 2001
From: houjie <714924425@qq.com>
Date: 星期一, 21 八月 2023 09:43:00 +0800
Subject: [PATCH] 设备使用 优化sql查询语句
---
lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EquipmentTransferrMapper.xml | 4 ----
lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EquipmentTransferInDetailMapper.xml | 10 ----------
lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EquipmentChangeDetailMapper.xml | 12 ------------
lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EquipmentTransferOutDetailMapper.xml | 3 ---
4 files changed, 0 insertions(+), 29 deletions(-)
diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EquipmentChangeDetailMapper.xml b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EquipmentChangeDetailMapper.xml
index 49723a9..c91d45a 100644
--- a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EquipmentChangeDetailMapper.xml
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EquipmentChangeDetailMapper.xml
@@ -27,10 +27,8 @@
t1.after_technology_status as afterTechnologyStatus,
t1.remark,
t1.equipment_id as equipmentId,
- t2.id AS equipmentId,
t2.num as equipmentNum,
t2.name as equipmentName,
- t2.id as equipmentId,
t2.model as model,
t2.specification as specification,
t1.update_by as updateBy,
@@ -71,29 +69,19 @@
t1.after_technology_status as afterTechnologyStatus,
t1.remark,
t1.equipment_id as equipmentId,
- t2.id AS equipmentId,
t2.num as equipmentNum,
t2.name as equipmentName,
- t2.id as equipmentId,
t2.model as model,
t2.specification as specification,
t1.update_by as updateBy,
t1.update_time as updateTime,
- t3.id AS beforeUsageDepartId,
t3.depart_name as beforeUsageDepartName,
- t4.id AS afterUsageDepartId,
t4.depart_name as afterUsageDepartName,
- t5.id AS beforeManager,
t5.realname as beforeManagerName,
- t6.id AS afterManager,
t6.realname as afterManagerName,
- t7.id AS beforeDepartId,
t7.depart_name as beforeDepartName,
- t8.id AS afterDepartId,
t8.depart_name as afterDepartName,
- t9.id AS beforeFunctionary,
t9.realname as beforeFunctionaryName,
- t10.id AS afterFunctionary,
t10.realname as afterFunctionaryName,
t11.item_text as afterEquipmentStatusName,
t12.item_text as afterTechnologyStatusName,
diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EquipmentTransferInDetailMapper.xml b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EquipmentTransferInDetailMapper.xml
index 61e2d1e..08d6b0c 100644
--- a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EquipmentTransferInDetailMapper.xml
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EquipmentTransferInDetailMapper.xml
@@ -16,18 +16,14 @@
t1.in_depart_id as inDepartId,
t1.in_manager_id as inManagerId,
t1.equipment_id as equipmentId,
- t2.id AS equipmentId,
t2.num as equipmentNum,
t2.name as equipmentName,
- t2.id as equipmentId,
t2.model as model,
t1.technical_status as technicalStatus,
t2.specification as specification,
t1.update_by as updateBy,
t1.update_time as updateTime,
- t6.id AS useDepartId,
t6.depart_name as useDepartName,
- t7.id AS responsibilityUserId,
t7.realname as responsibilityUserName
FROM
@@ -67,8 +63,6 @@
t1.actual_in_date as actualInDate,
t1.in_depart_id as inDepartId,
t1.in_manager_id as inManagerId,
- t1.use_depart_id as useDepartId,
- t1.position as position,
t1.equipment_id as equipmentId,
t1.technical_status as technicalStatus,
t2.num as equipmentNum,
@@ -77,15 +71,11 @@
t2.specification as specification,
t1.update_by as updateBy,
t1.update_time as updateTime,
- t3.id AS inManagerId,
t3.realname as inManagerName,
- t4.id AS inDepartId,
t4.depart_name as inDepartName,
t5.id AS transferMethodId,
t5.name as transferMethodName,
- t6.id AS useDepartId,
t6.depart_name as useDepartName,
- t7.id AS responsibilityUserId,
t7.realname as responsibilityUserName
FROM
mom_eam_equipment_transfer_in_detail t1
diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EquipmentTransferOutDetailMapper.xml b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EquipmentTransferOutDetailMapper.xml
index 57409e9..f9287df 100644
--- a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EquipmentTransferOutDetailMapper.xml
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EquipmentTransferOutDetailMapper.xml
@@ -57,11 +57,8 @@
t2.specification as specification,
t1.update_by as updateBy,
t1.update_time as updateTime,
- t3.id AS inManagerId,
t3.realname as inManagerName,
- t4.id AS inDepartId,
t4.depart_name as inDepartName,
- t5.id AS transferMethodId,
t5.name as transferMethodName
FROM
diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EquipmentTransferrMapper.xml b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EquipmentTransferrMapper.xml
index 608a810..a1f979c 100644
--- a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EquipmentTransferrMapper.xml
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/xml/EquipmentTransferrMapper.xml
@@ -17,9 +17,7 @@
t1.update_time as updateTime,
t1.create_time as createTime,
t2.item_text as audit_status,
- t3.id AS inEnterpriseId,
t3.name as inEnterpriseName,
- t4.id AS inEnterpriseId,
t4.name as outEnterpriseName
FROM
mom_eam_equipment_transfer t1
@@ -52,9 +50,7 @@
t1.update_time as updateTime,
t1.create_time as createTime,
t2.item_text as audit_status,
- t3.id AS inEnterpriseId,
t3.name as inEnterpriseName,
- t4.id AS inEnterpriseId,
t4.name as outEnterpriseName
FROM
mom_eam_equipment_transfer t1
--
Gitblit v1.9.3