From 1b679d0941f2e2b61b9c4b007aa8bc3b6e555e9c Mon Sep 17 00:00:00 2001
From: TQS <56479841@qq.com>
Date: 星期一, 28 十一月 2022 08:22:29 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/bfwcs_tqs' into bfwcs_tqs

---
 src/main/java/com/zy/asrs/mapper/ReportQueryMapper.java |    6 ++++++
 1 files changed, 6 insertions(+), 0 deletions(-)

diff --git a/src/main/java/com/zy/asrs/mapper/ReportQueryMapper.java b/src/main/java/com/zy/asrs/mapper/ReportQueryMapper.java
index 1b84325..bd14d54 100644
--- a/src/main/java/com/zy/asrs/mapper/ReportQueryMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/ReportQueryMapper.java
@@ -1,5 +1,6 @@
 package com.zy.asrs.mapper;
 
+import com.zy.asrs.domain.dto.WorkChartAxis;
 import com.zy.asrs.domain.vo.LocChartPie;
 import org.apache.ibatis.annotations.Mapper;
 import org.apache.ibatis.annotations.Select;
@@ -35,6 +36,11 @@
             "order by Min(wm.io_time) asc")
     List<Map<String, Object>> queryPakOutRep();
 
+    //鏇茬嚎鍥�
+    @Select("select ymd,SUM(sto_qty) inqty,SUM(ret_qty) outqty from asr_sta_inout_view "
+            + "where ymd>CONVERT(char(10), DATEADD(DAY,-12,GETDATE()), 120) group by ymd order by ymd")
+    public List<WorkChartAxis> getChartAxis();
+
     @Select("select * from asr_loc_use_view")
     LocChartPie getLocUseRate();
 

--
Gitblit v1.9.1