From 30406b83fbc9d66a018b2f7941fed20ee0952f8b Mon Sep 17 00:00:00 2001
From: tuqin <tuqin@tuqin.cn>
Date: 星期三, 28 十月 2026 10:12:08 +0800
Subject: [PATCH] fix(无人值守): 远程控制加真实TCP探测+通讯日志+执行耗时+模拟模式标注；门禁点下拉status过滤写反(写死0导致5个门禁点查不到)；报表总净重多除1000
---
src/main/java/com/ruoyi/wrzs/report/mapper/ReportCenterMapper.java | 6 +++---
1 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/ruoyi/wrzs/report/mapper/ReportCenterMapper.java b/src/main/java/com/ruoyi/wrzs/report/mapper/ReportCenterMapper.java
index bcd629b..cc76f29 100644
--- a/src/main/java/com/ruoyi/wrzs/report/mapper/ReportCenterMapper.java
+++ b/src/main/java/com/ruoyi/wrzs/report/mapper/ReportCenterMapper.java
@@ -19,7 +19,7 @@
/** 姣忔棩杩囩缁熻(鑷姩绉伴噸璁板綍) */
@Select("select date_format(first_weight_time, '%Y-%m-%d') as statDate, "
+ "count(*) as tripCount, "
- + "ifnull(sum(net_weight), 0) / 1000 as cargoVolume, "
+ + "ifnull(sum(net_weight), 0) as cargoVolume, "
+ "ifnull(avg(order_deviation), 0) as deviationRate, "
+ "sum(case when cheat_flag = '1' then 1 else 0 end) as cheatCount "
+ "from wrzs_weighbridge_record "
@@ -45,7 +45,7 @@
+ "sum(case when appointment_time is not null and first_weight_time > appointment_time then 1 else 0 end) as lateTrips, "
+ "sum(case when cheat_flag = '1' then 1 else 0 end) as cheatCount, "
+ "ifnull(avg(order_deviation), 0) as avgDeviation, "
- + "ifnull(sum(net_weight), 0) / 1000 as totalNetWeight "
+ + "ifnull(sum(net_weight), 0) as totalNetWeight "
+ "from wrzs_weighbridge_record "
+ "where weigh_status = '2' and first_weight_time between #{start} and #{end} "
+ "and carrier_name is not null and carrier_name <> '' "
@@ -54,7 +54,7 @@
/** 鍖洪棿鎬昏 */
@Select("select count(*) as totalTrips, "
- + "ifnull(sum(net_weight), 0) / 1000 as totalNetWeight, "
+ + "ifnull(sum(net_weight), 0) as totalNetWeight, "
+ "ifnull(avg(order_deviation), 0) as avgDeviation, "
+ "sum(case when cheat_flag = '1' then 1 else 0 end) as cheatCount, "
+ "sum(case when appointment_time is not null and first_weight_time <= appointment_time then 1 else 0 end) as onTimeTrips, "
--
Gitblit v1.9.3