From 8aa74635a762bbb5a49253b055eb69db5ebaab2d Mon Sep 17 00:00:00 2001
From: “linengliang” <vanSuperEnergy@163.com>
Date: 星期二, 19 九月 2023 10:20:58 +0800
Subject: [PATCH] 预测性维护方案生成工单bug修改
---
lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/PredictiveWorkPlanParameterServiceImpl.java | 28 +++++++++++++++++++++-------
1 files changed, 21 insertions(+), 7 deletions(-)
diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/PredictiveWorkPlanParameterServiceImpl.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/PredictiveWorkPlanParameterServiceImpl.java
index 0ed5a3a..c927c54 100644
--- a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/PredictiveWorkPlanParameterServiceImpl.java
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/service/impl/PredictiveWorkPlanParameterServiceImpl.java
@@ -80,8 +80,8 @@
if (needCreateFlag) {
//鐢熸垚宸ュ崟 ,灏嗗弬鏁颁俊鎭浠�
PredictiveWorkOrder predictiveWorkOrder = this.createOrder(predictiveWorkPlan.getId(), predictiveWorkPlan.getEquipmentId());
- if(predictiveWorkOrder != null){
- this.backInfo(predictiveWorkPlan.getId(), predictiveWorkOrder.getId(),predictiveWorkPlanParameterList);
+ if (predictiveWorkOrder != null) {
+ this.backInfo(predictiveWorkPlan.getId(), predictiveWorkOrder.getId(), predictiveWorkPlanParameterList);
}
}
@@ -91,16 +91,16 @@
@Override
public void removeByWorkPlanId(String predictiveWorkPlanId) {
LambdaUpdateChainWrapper<PredictiveWorkPlanParameter> lambdaUpdate = this.lambdaUpdate();
- lambdaUpdate.eq(PredictiveWorkPlanParameter::getWorkPlanId,predictiveWorkPlanId);
+ lambdaUpdate.eq(PredictiveWorkPlanParameter::getWorkPlanId, predictiveWorkPlanId);
lambdaUpdate.remove();
}
@Override
public void revise(String oldWorkPlanId, String workPlanId) {
LambdaQueryChainWrapper<PredictiveWorkPlanParameter> lambdaQuery = this.lambdaQuery();
- lambdaQuery.eq(PredictiveWorkPlanParameter::getWorkPlanId,oldWorkPlanId).eq(PredictiveWorkPlanParameter::getDelFlag,0);
+ lambdaQuery.eq(PredictiveWorkPlanParameter::getWorkPlanId, oldWorkPlanId).eq(PredictiveWorkPlanParameter::getDelFlag, 0);
List<PredictiveWorkPlanParameter> insertList = lambdaQuery.list();
- for(PredictiveWorkPlanParameter predictiveWorkPlanParameter:insertList){
+ for (PredictiveWorkPlanParameter predictiveWorkPlanParameter : insertList) {
predictiveWorkPlanParameter.setWorkPlanId(workPlanId);
predictiveWorkPlanParameter.setId(UUIDGenerator.generate());
}
@@ -116,7 +116,7 @@
return predictiveWorkOrder;
}
- private void backInfo(String workPlanId,String workOrderId, List<PredictiveWorkPlanParameter> predictiveWorkPlanParameterList) {
+ private void backInfo(String workPlanId, String workOrderId, List<PredictiveWorkPlanParameter> predictiveWorkPlanParameterList) {
List<PredictiveWorkPlanParameterHistory> list = new ArrayList<>();
for (PredictiveWorkPlanParameter predictiveWorkPlanParameter : predictiveWorkPlanParameterList) {
PredictiveWorkPlanParameterHistory predictiveWorkPlanParameterHistory = new PredictiveWorkPlanParameterHistory();
@@ -150,7 +150,21 @@
}
private ParameterVo findParameterInfo(String saveTableName, float lowerLimitValue, float upperLimitValue, String parameterCode) {
- return this.getBaseMapper().findParameterInfo(saveTableName, lowerLimitValue, upperLimitValue, parameterCode);
+// String temp = "[" + saveTableName + "]";
+// return this.getBaseMapper().findParameterInfo(temp, lowerLimitValue, upperLimitValue, parameterCode);
+ Integer lowerLimitValueInt = (int) lowerLimitValue;
+ Integer upperLimitValueInt = (int)upperLimitValue;
+ String sql = "SELECT TOP 1 " +
+ " t1.CollectTime collectTime, " +
+ " t1." + parameterCode + " actualValue " +
+ " FROM " +
+ " [" + saveTableName + "] t1 " +
+ " WHERE " +
+ " t1." + parameterCode + " < " + lowerLimitValueInt +
+ " OR t1." + parameterCode + " > " + upperLimitValueInt +
+ " ORDER BY " +
+ " t1.CollectTime DESC";
+ return this.getBaseMapper().findCommonParameterInfo(sql);
}
private List<PredictiveWorkPlanParameter> listParameter(String predictiveWorkPlanId) {
--
Gitblit v1.9.3