From 62b8f41aced0c0772f4d4eb1aba9d9697c0f8f61 Mon Sep 17 00:00:00 2001
From: 张磊磊 <201175954@qq.com>
Date: 星期一, 11 十二月 2023 17:14:00 +0800
Subject: [PATCH] thing.js钢筋消耗月排序
---
hd/pipe/screen/src/main/resources/mapping/BigScreenMapper.xml | 1 +
1 files changed, 1 insertions(+), 0 deletions(-)
diff --git a/hd/pipe/screen/src/main/resources/mapping/BigScreenMapper.xml b/hd/pipe/screen/src/main/resources/mapping/BigScreenMapper.xml
index 84c1f09..b394089 100644
--- a/hd/pipe/screen/src/main/resources/mapping/BigScreenMapper.xml
+++ b/hd/pipe/screen/src/main/resources/mapping/BigScreenMapper.xml
@@ -269,6 +269,7 @@
where ssr.stock_type = 2 and YEAR(SYSDATE()) = YEAR(ssr.create_time) and MONTH(SYSDATE()) = MONTH(ssr.create_time)
group by ssr.steel_id
) c on steel.steel_id = c.steel_id
+ ORDER BY c.monthStock desc
</select>
<!--获取静养区-->
--
Gitblit v1.9.3