From 218ab860ed4708f6f70a519775c56c9554000fe7 Mon Sep 17 00:00:00 2001 From: lyh <925863403@qq.com> Date: 星期五, 27 六月 2025 13:42:41 +0800 Subject: [PATCH] 去除多余引用 --- 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