From 9b015b51b72ba050b4c38a6ba79eb45b7065e67d Mon Sep 17 00:00:00 2001
From: Lius <Lius2225@163.com>
Date: 星期四, 25 七月 2024 10:11:52 +0800
Subject: [PATCH] 调整sql
---
lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/CalibrationOrderMapper.java | 132 ++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 126 insertions(+), 6 deletions(-)
diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/CalibrationOrderMapper.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/CalibrationOrderMapper.java
index b985950..c828a63 100644
--- a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/CalibrationOrderMapper.java
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/CalibrationOrderMapper.java
@@ -24,6 +24,30 @@
List<Map<String, Object>> getPrecisionParameterList(@Param("equipmentId")String equipmentId);
/**
+ * 鑾峰彇褰撳墠鐧诲綍浜烘槸涓績鍙婂搴旂殑缂栫爜
+ * qsw 2024-3-18
+ */
+ String findProductionCode(@Param("userId") String userId);
+
+ /**
+ * 鑾峰彇褰撳墠鐧诲綍浜哄伐娈电骇瀵瑰簲鐨勭紪鐮�
+ * qsw 2024-3-18
+ */
+ String findAreaProductionCode(@Param("userId") String userId);
+
+ /**
+ * 閫氳繃褰撳墠鐧诲綍浜虹殑宸ユ缂栫爜 鑾峰垎鍘傜紪鐮�
+ * qsw 2024-3-18
+ */
+ String findSiteProductionCode(@Param("productionCode") String productionCode);
+
+ /**
+ * 鏍规嵁妯″瀷浼犲叆鐨勭紪鐮� 鍒ゆ柇鏀圭紪鐮佸叕鍙�/涓績/宸ユ鐨勫摢涓�绾�
+ * qsw 2024-3-18
+ */
+ String findOrgType(@Param("productionCode") String productionCode);
+
+ /**
*棣栭〉鍏徃绾� 鎶�鏈姸鎬佹暟閲忕粺璁�
* qsw 2024-3-13
*/
@@ -63,36 +87,132 @@
*棣栭〉锛堜簩绾ч〉闈級鎶�鏈姸鎬佹暟閲忕粺璁�
* qsw 2024-3-13
*/
- List<Map<String, Object>> getEquipmentTechnologyStatusList(@Param("factoryModelId")String factoryModelId);
+ List<Map<String, Object>> getEquipmentTechnologyStatusList(@Param("workCenterId")String workCenterId,@Param("areaId")String areaId);
+
+ /**
+ *棣栭〉 鎶�鏈姸鎬佺偣鍑诲脊鍑哄搴旀槑缁�
+ * qsw 2024-5-25
+ */
+ IPage<Map<String, Object>> getEquipmentByTechnologyStatus(IPage<Map> pageData,@Param("workCenterId")String workCenterId,@Param("areaId")String areaId,@Param("technologyStatus")String technologyStatus);
/**
*棣栭〉锛堜簩绾ч〉闈級璁惧鎶ヤ慨鎯呭喌缁熻
* qsw 2024-3-13
*/
- List<Map<String, Object>> getReportRepairEquipmentList(@Param("factoryModelId")String factoryModelId);
+ List<Map<String, Object>> getReportRepairEquipmentList(@Param("workCenterId")String workCenterId,@Param("areaId")String areaId);
+
+ /**
+ *棣栭〉 璁惧鎶ヤ慨鎯呭喌缁熻鏄庣粏灞曠ず
+ * qsw 2024-5-25
+ */
+ IPage<Map<String, Object>> getEquipmentByReportRepair(IPage<Map> pageData,@Param("workCenterId")String workCenterId,@Param("areaId")String areaId,@Param("isStop")String isStop);
/**
*棣栭〉锛堜簩绾ч〉闈級鏈湀涓変繚璁″垝
* qsw 2024-3-14
*/
- List<Map<String, Object>> getThisMonthMaintenanceList(@Param("factoryModelId")String factoryModelId);
+ List<Map<String, Object>> getThisMonthMaintenanceList(@Param("workCenterId")String workCenterId,@Param("areaId")String areaId);
+
+ /**
+ *棣栭〉鏈湀涓変繚璁″垝鏄庣粏
+ * qsw 2024-5-25
+ */
+ IPage<Map<String, Object>> showThisMonthMaintenanceList(IPage<Map> pageData,@Param("workCenterId")String workCenterId,@Param("areaId")String areaId);
/**
*棣栭〉锛堜簩绾ч〉闈級涓嬫湀涓変繚璁″垝
* qsw 2024-3-14
*/
- List<Map<String, Object>> getNextMonthMaintenanceList(@Param("factoryModelId")String factoryModelId);
+ List<Map<String, Object>> getNextMonthMaintenanceList(@Param("workCenterId")String workCenterId,@Param("areaId")String areaId);
+
+ /**
+ *棣栭〉涓嬫湀涓変繚璁″垝鏄庣粏
+ * qsw 2024-5-25
+ */
+ IPage<Map<String, Object>> showNextMonthMaintenanceList(IPage<Map> pageData,@Param("workCenterId")String workCenterId,@Param("areaId")String areaId);
/**
*棣栭〉锛堜簩绾ч〉闈級涓嬩笅鏈堜笁淇濊鍒�
* qsw 2024-3-14
*/
- List<Map<String, Object>> getNextNextMonthMaintenanceList(@Param("factoryModelId")String factoryModelId);
+ List<Map<String, Object>> getNextNextMonthMaintenanceList(@Param("workCenterId")String workCenterId,@Param("areaId")String areaId);
+
+ /**
+ *棣栭〉涓嬩笅鏈堜笁淇濊鍒掓槑缁�
+ * qsw 2024-5-25
+ */
+ IPage<Map<String, Object>> showNextNextMonthMaintenanceList(IPage<Map> pageData,@Param("workCenterId")String workCenterId,@Param("areaId")String areaId);
/**
*棣栭〉锛堜簩绾ч〉闈級鏈湀涓変繚瀹屾垚鏁伴噺
* qsw 2024-3-14
*/
- List<Map<String, Object>> getThisMonthMaintenanceFinishList(@Param("factoryModelId")String factoryModelId);
+ List<Map<String, Object>> getThisMonthMaintenanceFinishList(@Param("workCenterId")String workCenterId,@Param("areaId")String areaId);
+
+
+ /**
+ *棣栭〉锛堜簩绾ч〉闈級鏈湀涓変繚瀹屾垚璁惧鏄庣粏
+ * qsw 2024-5-25
+ */
+ IPage<Map<String, Object>> showThisMonthMaintenanceFinishList(IPage<Map> pageData,@Param("workCenterId")String workCenterId,@Param("areaId")String areaId);
+
+ /**
+ *宸ユ绾� 鏈湀涓変繚寤舵湡鏁伴噺
+ * qsw 2024-3-20
+ */
+ List<Map<String, Object>> get3MaintenancePostponeCount(@Param("areaId")String areaId);
+
+ /**
+ *宸ユ绾� 涓変繚寤舵湡鏁伴噺鏄庣粏
+ * qsw 2024-5-25
+ */
+ IPage<Map<String, Object>> show3MaintenancePostponeCount(IPage<Map> pageData,@Param("areaId")String areaId);
+
+
+ /**
+ *宸ユ绾� 鏈湀涓変繚瓒呮湡鏁伴噺
+ * qsw 2024-3-20
+ */
+ List<Map<String, Object>> get3MaintenanceOverdueCount(@Param("areaId")String areaId);
+
+ /**
+ *宸ユ绾� 涓変繚瓒呮湡鏁伴噺鏄庣粏
+ * qsw 2024-5-25
+ */
+ IPage<Map<String, Object>> show3MaintenanceOverdueCount(IPage<Map> pageData,@Param("areaId")String areaId);
+
+ /**
+ *棣栭〉浜岀骇淇濆吇灞曠ず椤甸潰 鑾峰彇姣忎竴涓腑蹇冧笅浜岀骇淇濆吇璁″垝
+ * qsw 2024-3-15
+ */
+ List<Map<String, Object>> getCenterTwoMaintenancePlanList(@Param("workCenterId")String workCenterId);
+
+
+ /**
+ *宸ユ涓� 浜岀骇淇濆吇璁″垝鏄庣粏
+ * qsw 2024-3-19
+ */
+ String findMaintenanceDate(@Param("workCenterId")String workCenterId);
+ List<Map<String, Object>> getAreTwoMaintenancePlanDetails(@Param("areaId")String areaId,@Param("maintenanceDate")String maintenanceDate);
+
+ /**
+ *棣栭〉 绗洓绾� 瀵瑰簲宸ュ尯涓嬶紝璁惧鍙拌处淇℃伅灞曠ず锛�
+ * qsw 2024-4-22
+ */
+ List<Map<String, Object>> getAreaEquipmentList(@Param("equipmentNum")String equipmentNum,@Param("areaId")String areaId, @Param("equipmentIds")List<String> equipmentIds);
+
+
+ /**
+ *棣栭〉 绗洓绾� 瀵瑰簲宸ュ尯涓嬶紝璁惧鍙拌处淇℃伅灞曠ず锛�
+ * qsw 2024-4-22
+ */
+ List<Map<String, Object>> getOperationCertificate(@Param("username")String username);
+
+
+ /**
+ *棣栭〉鍏徃绾� 鎶�鏈姸鎬佹暟閲忕粺璁�
+ * qsw 2024-4-22
+ */
+ List<Map<String, Object>> getEquipmentReportRepairCount(@Param("equipmentId")String equipmentId);
}
--
Gitblit v1.9.3