From 0d04bc5d8080b82338302fba0a59fccff2eaedfc Mon Sep 17 00:00:00 2001
From: Junjie <fallin.jie@qq.com>
Date: 星期日, 06 七月 2025 11:28:29 +0800
Subject: [PATCH] #
---
zy-asrs-wcs/src/main/java/com/zy/asrs/wcs/core/mapper/TaskMapper.java | 37 ++++++++++++++++++++++++++++++++++++-
1 files changed, 36 insertions(+), 1 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 5c2c38c..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;
@@ -18,20 +20,53 @@
List<Task> selectByExecuteSts();
+ List<Task> selectChargeByAnalyzeSts();
+
+ List<Task> selectChargeByExecuteSts();
+
List<Task> selectManualByAnalyzeSts();
List<Task> selectManualByExecuteSts();
+
+ List<Task> selectMoveByAnalyzeSts();
+
+ List<Task> selectMoveByExecuteSts();
List<Task> selectWaitAnalyzeInBoundTask();
List<Task> selectPakOut();
+ List<Task> selectWaitAnalyzeMoveTask();
+
+ List<Task> selectWaitAnalyzeLadenMoveTask();
+
+ List<Task> selectLadenMoveByAnalyzeSts();
+
+ List<Task> selectLadenMoveByExecuteSts();
+
List<Task> hasChargeInLoc(String locNo);
Task selectMoveWorking(Integer shuttleNo);
- List<Task> selectWorkingByShuttle(Integer shuttleNo);
+ Task selectManualWorking(Integer shuttleNo);
+
+ List<Task> selectWorkingByShuttle(Integer shuttleNo, String taskNo);
+
+ 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