From c9b04383c77f91ac309e37e70783edcf8a9298b5 Mon Sep 17 00:00:00 2001
From: yangys <y_ys79@sina.com>
Date: 星期六, 18 五月 2024 23:24:12 +0800
Subject: [PATCH] websocket代码整理
---
smart-man-boot/src/main/java/com/qianwen/smartman/modules/fms/mapper/FmsOrderMapper.java | 1 -
1 files changed, 0 insertions(+), 1 deletions(-)
diff --git a/smart-man-boot/src/main/java/com/qianwen/smartman/modules/fms/mapper/FmsOrderMapper.java b/smart-man-boot/src/main/java/com/qianwen/smartman/modules/fms/mapper/FmsOrderMapper.java
index 7273281..cbe79b1 100644
--- a/smart-man-boot/src/main/java/com/qianwen/smartman/modules/fms/mapper/FmsOrderMapper.java
+++ b/smart-man-boot/src/main/java/com/qianwen/smartman/modules/fms/mapper/FmsOrderMapper.java
@@ -8,7 +8,6 @@
import com.qianwen.smartman.common.constant.CommonConstant;
import com.qianwen.smartman.modules.fms.entity.FmsOrder;
-/* loaded from: blade-api.jar:BOOT-INF/classes/org/springblade/modules/fms/mapper/FmsOrderMapper.class */
public interface FmsOrderMapper extends BaseMapper<FmsOrder> {
@Select.List({@Select({"select count(qualify_num) as qualify_num, left(end_time, 16) as end_time ", "from blade_fms_work_station_record where qualify_num > 0 and order_id = #{orderId} and end_time is not null ", "and order_process_id = (select id from blade_fms_order_process where order_id = #{orderId} ORDER BY sort desc limit 1) ", "GROUP BY qualify_num, left(end_time, 16) ", "ORDER BY left(end_time, 16) asc "}), @Select(databaseId = CommonConstant.ORACLE, value = {"SELECT count( qualify_num ) AS qualify_num,", " substr(to_char(end_time,'yyyy-mm-dd hh24:mi:ss'),1, 16) AS end_time ", "FROM blade_fms_work_station_record ", "WHERE qualify_num > 0", " AND order_id = #{orderId} ", " AND end_time IS NOT NULL ", " AND order_process_id in (select id from ( SELECT id,ROW_NUMBER() over(order by sort desc) rank FROM blade_fms_order_process WHERE order_id = #{orderId} ) t where t.rank=1)", " GROUP BY qualify_num,substr(to_char(end_time,'yyyy-mm-dd hh24:mi:ss'),1, 16)", "ORDER BY substr(to_char(end_time,'yyyy-mm-dd hh24:mi:ss'),1, 16) asc"})})
List<Map<String, Object>> productionStatistics(String orderId);
--
Gitblit v1.9.3