From 8c75fbabe59e6d406e276736239afa3666ce4f0f Mon Sep 17 00:00:00 2001
From: Junjie <xjj@123>
Date: 星期一, 14 十月 2024 10:56:51 +0800
Subject: [PATCH] #控制同时出库解析数量
---
zy-asrs-wcs/src/main/java/com/zy/asrs/wcs/core/mapper/TaskMapper.java | 21 +++++++++++++++++++++
1 files changed, 21 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 ec0fd46..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;
@@ -36,6 +38,12 @@
List<Task> selectWaitAnalyzeMoveTask();
+ List<Task> selectWaitAnalyzeLadenMoveTask();
+
+ List<Task> selectLadenMoveByAnalyzeSts();
+
+ List<Task> selectLadenMoveByExecuteSts();
+
List<Task> hasChargeInLoc(String locNo);
Task selectMoveWorking(Integer shuttleNo);
@@ -48,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