From e0c8b1913123939b5adcff3da4a81cadff95e002 Mon Sep 17 00:00:00 2001
From: zjj <3272660260@qq.com>
Date: 星期四, 11 七月 2024 11:00:20 +0800
Subject: [PATCH] #
---
zy-asrs-wcs/src/main/java/com/zy/asrs/wcs/core/mapper/TaskMapper.java | 15 +++++++++++++++
1 files changed, 15 insertions(+), 0 deletions(-)
diff --git a/zy-asrs-wcs/src/main/java/com/zy/asrs/wcs/core/mapper/TaskMapper.java b/zy-asrs-wcs/src/main/java/com/zy/asrs/wcs/core/mapper/TaskMapper.java
index af9aabf..1a99b14 100644
--- a/zy-asrs-wcs/src/main/java/com/zy/asrs/wcs/core/mapper/TaskMapper.java
+++ b/zy-asrs-wcs/src/main/java/com/zy/asrs/wcs/core/mapper/TaskMapper.java
@@ -1,9 +1,11 @@
package com.zy.asrs.wcs.core.mapper;
+import com.zy.asrs.wcs.core.domain.dto.WorkChartAxis;
import com.zy.asrs.wcs.core.entity.Task;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import java.util.List;
@@ -54,4 +56,17 @@
Task selectChargeWorking(Integer shuttleNo);
+ @Select("SELECT\n" +
+ " ymd,\n" +
+ " SUM(sto_qty) AS inqty,\n" +
+ " SUM(ret_qty) AS outqty\n" +
+ "FROM\n" +
+ " asr_sta_inout_view\n" +
+ "WHERE\n" +
+ " ymd >= DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 12 DAY), '%Y-%m-%d')\n" +
+ "GROUP BY\n" +
+ " ymd\n" +
+ "ORDER BY\n" +
+ " ymd;")
+ List<WorkChartAxis> selectByLineCharts();
}
--
Gitblit v1.9.1