From 75f1ced619b49f354addc1cf8fa1ca320b25edd4 Mon Sep 17 00:00:00 2001
From: admin <15939171744@163.com>
Date: 星期二, 17 十二月 2024 14:21:58 +0800
Subject: [PATCH] 优化
---
jcdm-main/src/main/java/com/jcdm/main/bigScreen/controller/BigScreenController.java | 12 +++++++++++-
1 files changed, 11 insertions(+), 1 deletions(-)
diff --git a/jcdm-main/src/main/java/com/jcdm/main/bigScreen/controller/BigScreenController.java b/jcdm-main/src/main/java/com/jcdm/main/bigScreen/controller/BigScreenController.java
index f7b5905..8bcb9cf 100644
--- a/jcdm-main/src/main/java/com/jcdm/main/bigScreen/controller/BigScreenController.java
+++ b/jcdm-main/src/main/java/com/jcdm/main/bigScreen/controller/BigScreenController.java
@@ -85,7 +85,7 @@
" inbound_time,\n" +
" outbound_time,\n" +
" DATEDIFF(SECOND, inbound_time, outbound_time) AS beatTime");
- queryWrapper.eq("sfc_code","2408270000011");
+ queryWrapper.eq("sfc_code",getLatestCompletedWorkpiece());
queryWrapper.orderByDesc("location_code");
List<DaPassingStationCollection> list = daPassingStationCollectionService.list(queryWrapper);
for (DaPassingStationCollection daPassingStationCollection : list) {
@@ -173,6 +173,16 @@
return AjaxResult.success(resultList);
}
+ // 鑾峰緱鏈�鏂板畬鎴愬伐浠剁姸鎬佷负5
+ public String getLatestCompletedWorkpiece(){
+ QueryWrapper<OmProductionOrdeInfo> wrapper = new QueryWrapper<>();
+ wrapper.select("TOP 1 *");
+ wrapper.eq("order_status","5");
+ wrapper.orderByDesc("actual_end_time");
+ OmProductionOrdeInfo one = omProductionOrdeInfoService.getOne(wrapper);
+ return one.getProductNum();
+ }
+
public static int locationPassRate(int passRate,int total) {
double percentage = (double) passRate / total * 100;
long roundedNumber = Math.round(percentage);
--
Gitblit v1.9.3