From 1a2258c4eca2e7514b6096004fa1c3e0036b402b Mon Sep 17 00:00:00 2001 From: qushaowei <qushaowei@163.com> Date: 星期四, 28 三月 2024 14:04:24 +0800 Subject: [PATCH] Merge branch 'master' of http://117.34.109.166:18448/r/mdc_430 into develop --- lxzn-module-eam/src/main/java/org/jeecg/modules/eam/mapper/CalibrationOrderMapper.java | 122 ++++++++++++++++++++++++++++++++++++++++ 1 files changed, 122 insertions(+), 0 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 901baca..1d3b23b 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 @@ -23,4 +23,126 @@ */ 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 + */ + List<Map<String, Object>> getFactoryEquipmentTechnologyStatusList(); + + /** + *棣栭〉鍏徃绾� 璁惧鎶ヤ慨鎯呭喌缁熻 + * qsw 2024-3-13 + */ + List<Map<String, Object>> getFactoryReportRepairEquipmentList(); + + /** + *棣栭〉鍏徃绾� 鏈湀涓変繚璁″垝 + * qsw 2024-3-14 + */ + List<Map<String, Object>> getFactoryThisMonthMaintenanceList(); + + /** + *棣栭〉鍏徃绾� 涓嬫湀涓変繚璁″垝 + * qsw 2024-3-14 + */ + List<Map<String, Object>> getFactoryNextMonthMaintenanceList(); + + /** + *棣栭〉鍏徃绾� 涓嬩笅鏈堜笁淇濊鍒� + * qsw 2024-3-14 + */ + List<Map<String, Object>> getFactoryNextNextMonthMaintenanceList(); + + /** + *棣栭〉鍏徃绾� 鏈湀涓変繚瀹屾垚鏁伴噺 + * qsw 2024-3-14 + */ + List<Map<String, Object>> getFactoryThisMonthMaintenanceFinishList(); + + /** + *棣栭〉锛堜簩绾ч〉闈級鎶�鏈姸鎬佹暟閲忕粺璁� + * qsw 2024-3-13 + */ + List<Map<String, Object>> getEquipmentTechnologyStatusList(@Param("workCenterId")String workCenterId,@Param("areaId")String areaId); + + /** + *棣栭〉锛堜簩绾ч〉闈級璁惧鎶ヤ慨鎯呭喌缁熻 + * qsw 2024-3-13 + */ + List<Map<String, Object>> getReportRepairEquipmentList(@Param("workCenterId")String workCenterId,@Param("areaId")String areaId); + + /** + *棣栭〉锛堜簩绾ч〉闈級鏈湀涓変繚璁″垝 + * qsw 2024-3-14 + */ + List<Map<String, Object>> getThisMonthMaintenanceList(@Param("workCenterId")String workCenterId,@Param("areaId")String areaId); + + /** + *棣栭〉锛堜簩绾ч〉闈級涓嬫湀涓変繚璁″垝 + * qsw 2024-3-14 + */ + List<Map<String, Object>> getNextMonthMaintenanceList(@Param("workCenterId")String workCenterId,@Param("areaId")String areaId); + + /** + *棣栭〉锛堜簩绾ч〉闈級涓嬩笅鏈堜笁淇濊鍒� + * qsw 2024-3-14 + */ + List<Map<String, Object>> getNextNextMonthMaintenanceList(@Param("workCenterId")String workCenterId,@Param("areaId")String areaId); + + /** + *棣栭〉锛堜簩绾ч〉闈級鏈湀涓変繚瀹屾垚鏁伴噺 + * qsw 2024-3-14 + */ + List<Map<String, Object>> getThisMonthMaintenanceFinishList(@Param("workCenterId")String workCenterId,@Param("areaId")String areaId); + + /** + *宸ユ绾� 鏈湀涓変繚寤舵湡鏁伴噺 + * qsw 2024-3-20 + */ + List<Map<String, Object>> get3MaintenancePostponeCount(@Param("areaId")String areaId); + + /** + *宸ユ绾� 鏈湀涓変繚瓒呮湡鏁伴噺 + * qsw 2024-3-20 + */ + List<Map<String, Object>> get3MaintenanceOverdueCount(@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); + } -- Gitblit v1.9.3