From e1b28ee09836787555448083bf9a6b59477ad330 Mon Sep 17 00:00:00 2001
From: Junjie <540245094@qq.com>
Date: 星期六, 21 九月 2024 08:18:58 +0800
Subject: [PATCH] #
---
zy-asrs-wcs/src/main/java/com/zy/asrs/wcs/core/mapper/TaskMapper.java | 25 +++++++++++++++++++++++--
1 files changed, 23 insertions(+), 2 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 0601b8d..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,16 +38,35 @@
List<Task> selectWaitAnalyzeMoveTask();
+ List<Task> selectWaitAnalyzeLadenMoveTask();
+
+ List<Task> selectLadenMoveByAnalyzeSts();
+
+ List<Task> selectLadenMoveByExecuteSts();
+
List<Task> hasChargeInLoc(String locNo);
Task selectMoveWorking(Integer shuttleNo);
Task selectManualWorking(Integer shuttleNo);
- List<Task> selectWorkingByShuttle(Integer shuttleNo);
+ List<Task> selectWorkingByShuttle(Integer shuttleNo, String taskNo);
- List<Task> selectWorkingByLift(Integer liftNo);
+ List<Task> selectWorkingByLift(Integer liftNo, String taskNo);
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