From 774eae4b6ec65670a36ad74e561b09aca59a45c7 Mon Sep 17 00:00:00 2001
From: 廖井涛 <2265517004@qq.com>
Date: 星期三, 17 九月 2025 09:18:45 +0800
Subject: [PATCH] 修改物料修改问题
---
north-glass-erp/src/main/java/com/example/erp/mapper/mm/FinishedGlassShelfMapper.java | 53 +++++++++++++++++++++++++++++++++++++++++++++++------
1 files changed, 47 insertions(+), 6 deletions(-)
diff --git a/north-glass-erp/src/main/java/com/example/erp/mapper/mm/FinishedGlassShelfMapper.java b/north-glass-erp/src/main/java/com/example/erp/mapper/mm/FinishedGlassShelfMapper.java
index 6875b38..4d11413 100644
--- a/north-glass-erp/src/main/java/com/example/erp/mapper/mm/FinishedGlassShelfMapper.java
+++ b/north-glass-erp/src/main/java/com/example/erp/mapper/mm/FinishedGlassShelfMapper.java
@@ -1,9 +1,6 @@
package com.example.erp.mapper.mm;
-import com.example.erp.entity.mm.FinishedGlassShelfEmit;
-import com.example.erp.entity.mm.FinishedGlassShelfEmitDetails;
-import com.example.erp.entity.mm.FinishedGlassShelfInformation;
-import com.example.erp.entity.mm.MaterialInventory;
+import com.example.erp.entity.mm.*;
import com.example.erp.entity.sd.Delivery;
import com.example.erp.entity.sd.OrderDetail;
import com.example.erp.entity.sd.OrderOtherMoney;
@@ -11,6 +8,7 @@
import org.apache.ibatis.annotations.Param;
import org.springframework.data.repository.CrudRepository;
+import java.time.LocalDate;
import java.util.List;
import java.util.Map;
@@ -33,6 +31,8 @@
Map<String,Integer> getSelectFinishedGlassShelfInformationDatePageTotal(Integer offset, Integer pageSize);
FinishedGlassShelfInformation getSelectFinishedGlassShelfInformationById(Long id);
+
+ FinishedGlassShelfInformation getSelectFinishedGlassShelfInformationByGlassShelfnumber(String glassShelfnumber);
List<Map<String, Object>> getSelectFinishedGlassShelfInformationInId(@Param("ids") List<Long> ids);
@@ -59,8 +59,8 @@
boolean updateInformationAvailableQuantityInt(@Param("finishedGlassShelfEmitDetails") FinishedGlassShelfEmitDetails finishedGlassShelfEmitDetails);
- boolean insertFinishedGlassShelfEmitDetailsLog(String emitId,Integer emitNumber,
- @Param("finishedGlassShelfEmitDetails") FinishedGlassShelfEmitDetails finishedGlassShelfEmitDetails);
+ boolean insertFinishedGlassShelfEmitDetailsLog(String emitId,Integer emitNumber,Integer type,String glassShelfNumber,String glassShelfName,Integer quantity,
+ Double price,Double money,String unit,String remarks,Double maxWeight,Double maxWidth,Double maxHeight);
List<FinishedGlassShelfEmit> getSelectFinishedGlassShelfEmit(@Param("offset") Integer offset,
@Param("pageSize") Integer pageSize, String startDate, String endDate,
@@ -78,4 +78,45 @@
boolean updateFinishedGlassShelfEmitDetailsLog(@Param("emitId") String emitId);
+ FinishedGlassShelfWithdraw getSelectFinishedGlassShelfWithdrawByemitId(@Param("withdrawId") String withdrawId);
+
+ List<FinishedGlassShelfWithdrawDetails> getSelectFinishedGlassShelfWithdrawDetailsBywithdrawId1(@Param("withdrawId") String withdrawId);
+
+ List<Map<String, Object>> getSelectFinishedGlassShelfWithdrawDetailsBywithdrawId(@Param("withdrawId") String withdrawId);
+
+ boolean updateEmitDetailsWithdrawQuantityOut(@Param("finishedGlassShelfWithdrawDetails") FinishedGlassShelfWithdrawDetails finishedGlassShelfWithdrawDetails);
+
+ boolean updateEmitDetailsWithdrawQuantityInt(@Param("finishedGlassShelfWithdrawDetails") FinishedGlassShelfWithdrawDetails finishedGlassShelfWithdrawDetails);
+
+ boolean deleteFinishedGlassShelfWithdrawDetails(@Param("withdrawId") String withdrawId);
+
+ boolean deleteFinishedGlassShelfWithdraw(@Param("withdrawId") String withdrawId);
+
+ boolean updateFinishedGlassShelfWithdraw(@Param("finishedGlassShelfWithdraw") FinishedGlassShelfWithdraw finishedGlassShelfWithdraw,String withdrawId);
+
+ boolean insertFinishedGlassShelfWithdraw(@Param("finishedGlassShelfWithdraw") FinishedGlassShelfWithdraw finishedGlassShelfWithdraw,String withdrawId);
+
+ boolean insertFinishedGlassShelfWithdrawDetails(String withdrawId,Integer withdrawNumber,
+ @Param("finishedGlassShelfWithdrawDetails") FinishedGlassShelfWithdrawDetails finishedGlassShelfWithdrawDetails);
+
+ boolean updateFinishedGlassShelfEmitState(Integer state,@Param("emitId") String emitId);
+
+ List<FinishedGlassShelfWithdraw> getSelectFinishedGlassShelfWithdraw(@Param("offset") Integer offset,
+ @Param("pageSize") Integer pageSize, String startDate, String endDate,
+ @Param("withdraw") FinishedGlassShelfWithdraw finishedGlassShelfWithdraw);
+
+ Map<String,Integer> getSelectFinishedGlassShelfWithdrawPageTotal(Integer offset, Integer pageSize, String startDate, String endDate,
+ @Param("withdraw") FinishedGlassShelfWithdraw finishedGlassShelfWithdraw);
+
+
+ List<FinishedGlassShelfLog> getFinishedGlassShelfLogReport(@Param("offset") Integer offset,
+ @Param("pageSize") Integer pageSize,String startDate, String endDate,
+ @Param("finishedGlassShelfLog") FinishedGlassShelfLog finishedGlassShelfLog,Integer type);
+
+ Map<String,Integer> getFinishedGlassShelfLogReportTotal(@Param("offset") Integer offset,
+ @Param("pageSize") Integer pageSize,String startDate, String endDate,
+ @Param("finishedGlassShelfLog") FinishedGlassShelfLog finishedGlassShelfLog,Integer type);
+
+ List<FinishedGlassShelfLog> exportFinishedGlassShelfLogReport(List<LocalDate> dates, Integer type);
+
}
--
Gitblit v1.8.0