From 9e40c63ecc04d9d7b3dd98cd2f396c0ff2a79e13 Mon Sep 17 00:00:00 2001
From: zhangc <zc@123>
Date: 星期二, 03 十二月 2024 16:11:00 +0800
Subject: [PATCH] 添加订单电话更新功能及优化查询
---
src/main/java/com/zy/asrs/service/AgvLocDetlService.java | 21 ++++++++++++++++++++-
1 files changed, 20 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/zy/asrs/service/AgvLocDetlService.java b/src/main/java/com/zy/asrs/service/AgvLocDetlService.java
index 76dc097..759d93d 100644
--- a/src/main/java/com/zy/asrs/service/AgvLocDetlService.java
+++ b/src/main/java/com/zy/asrs/service/AgvLocDetlService.java
@@ -3,6 +3,7 @@
import com.baomidou.mybatisplus.plugins.Page;
import com.baomidou.mybatisplus.service.IService;
import com.zy.asrs.entity.AgvLocDetl;
+import com.zy.asrs.entity.LocDetl;
import com.zy.common.model.LocDto;
import com.zy.common.model.TaskDto;
import org.springframework.web.multipart.MultipartFile;
@@ -14,11 +15,23 @@
public void addLocDetlInfo(String locNo, int taskCode);
- public double queryStockAndSetLocDto(String matnr, String batch, String orderNo, List<LocDto> locDtoList, double issued, String csocode, String isoseq);
+ AgvLocDetl selectItem(String locNo, String matnr, String batch, String csocode, String isoCode);
+
+ public double queryStockAndSetLocDto(String matnr, String batch, String orderNo, List<LocDto> locDtoList, double issued, String csocode, String isoseq, String type);
public void updateStock(String sourceLoc, String targetLoc);
Page<AgvLocDetl> getStockStatis(Page<AgvLocDetl> page);
+
+ Double getSumAnfme(String matnr, String threeCode);
+
+ Double getSumAnfmeProcess(String matnr, String threeCode);
+
+ Double getSumAnfmeProcessed(String matnr, String threeCode);
+
+ Double getSumAnfmeDb(String matnr, String threeCode, Integer floor);
+
+ Double getSumAnfmeback(String matnr, String threeCode, Integer floor);
Integer sum();
@@ -31,11 +44,15 @@
*/
boolean updateAnfme(Double anfme, String locNo, String matnr, String batch, String csocode, String isocode);
+ boolean updateAnfmeProcess(Double anfme, String locNo, String matnr, String batch, String csocode, String isocode,Integer process);
+
public AgvLocDetl selectByLocNo(String locNo);
public List<AgvLocDetl> selectByTaskDto(TaskDto taskDto);
public AgvLocDetl selectByMatnrAndBatchAndCsocodeAndisoCode(String locNo, String matnr, String batch, String csocode, String isocode);
+
+ public AgvLocDetl selectByMatnrAndBatchAndCsocodeAndisoCode2(String locNo, String matnr, String orderNo, String batch, String csocode, String isocode);
public Double selectSumAnfmeByLocNo(String locNo);
@@ -45,4 +62,6 @@
public void compareToEss(MultipartFile file) throws IOException;
+ public void updateLocNo(String locNo, String sourceLoc,AgvLocDetl agvLocDetl);
+
}
--
Gitblit v1.9.1