From 43322d13c1876b1705f8ba1eb2ef32e7a433cacc Mon Sep 17 00:00:00 2001
From: chenlu <1320612696@qq.com>
Date: 星期四, 25 十二月 2025 16:57:06 +0800
Subject: [PATCH] Merge branch 'master' of http://10.153.19.25:10105/r/ERP_override
---
north-glass-erp/src/main/java/com/example/erp/mapper/mm/FinishedGlassShelfMapper.java | 136 +++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 136 insertions(+), 0 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
new file mode 100644
index 0000000..1b86d52
--- /dev/null
+++ b/north-glass-erp/src/main/java/com/example/erp/mapper/mm/FinishedGlassShelfMapper.java
@@ -0,0 +1,136 @@
+package com.example.erp.mapper.mm;
+
+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;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.springframework.data.repository.CrudRepository;
+
+import java.time.LocalDate;
+import java.util.List;
+import java.util.Map;
+
+@Mapper
+public interface FinishedGlassShelfMapper extends CrudRepository<FinishedGlassShelfInformation,Long> {
+
+ List<FinishedGlassShelfInformation> getSelectFinishedGlassShelfInformation(@Param("finishedGlassShelfInformation") FinishedGlassShelfInformation finishedGlassShelfInformation);
+
+ Integer getSelectFinishedGlassShelfInformationInventoryArea(@Param("inventoryArea")String inventoryArea);
+
+ boolean insetFinishedGlassShelfInformation(@Param("finishedGlassShelfInformation") FinishedGlassShelfInformation finishedGlassShelfInformation,String inventoryAreaNumber);
+
+ boolean insetFinishedGlassShelfLog(@Param("finishedGlassShelfInformation") FinishedGlassShelfInformation finishedGlassShelfInformation,Integer quantity);
+
+ boolean updateFinishedGlassShelfInformationQuantity(Integer quantity,Long id);
+
+ boolean updateFinishedGlassShelfInformation(@Param("finishedGlassShelfInformation") FinishedGlassShelfInformation finishedGlassShelfInformation,Long id);
+
+ List<Map<String, Object>> getSelectFinishedGlassShelfInformationDate(@Param("offset") Integer offset,@Param("pageSize") Integer pageSize);
+
+
+ Map<String,Integer> getSelectFinishedGlassShelfInformationDatePageTotal(Integer offset, Integer pageSize);
+
+ List<FinishedGlassShelfInformation> getSelectFinishedGlassShelfInformationDateDetail(@Param("offset") Integer offset,@Param("pageSize") Integer pageSize);
+
+
+ Map<String,Integer> getSelectFinishedGlassShelfInformationDateDetailPageTotal(Integer offset, Integer pageSize);
+
+ FinishedGlassShelfInformation getSelectFinishedGlassShelfInformationById(Long id);
+
+
+ Map<String, Object> getSelectFinishedGlassShelfInformationInId(@Param("glassShelfName") String glassShelfName,
+ @Param("price") Double price,
+ @Param("unit") String unit,
+ @Param("weight") Double weight,
+ @Param("width") Double width,
+ @Param("height") Double height);
+
+ boolean deleteFinishedGlassShelfInformationById(Long id);
+
+ FinishedGlassShelfEmit getSelectFinishedGlassShelfEmitByemitId(@Param("emitId") String emitId);
+
+ List<FinishedGlassShelfEmitDetails> getSelectFinishedGlassShelfEmitDetailsByemitId1(@Param("emitId") String emitId);
+
+ List<Map<String, Object>> getSelectFinishedGlassShelfEmitDetailsByemitId(@Param("emitId") String emitId);
+
+ Integer getmaximumWithdraw();
+
+ Integer getmaximumEmit();
+
+ boolean insertFinishedGlassShelfEmit(@Param("finishedGlassShelfEmit") FinishedGlassShelfEmit finishedGlassShelfEmit,String emitId);
+
+ boolean updateFinishedGlassShelfEmit(@Param("finishedGlassShelfEmit") FinishedGlassShelfEmit finishedGlassShelfEmit,String emitId);
+
+ boolean insertFinishedGlassShelfEmitDetails(String emitId,Integer emitNumber,
+ @Param("finishedGlassShelfEmitDetails") FinishedGlassShelfEmitDetails finishedGlassShelfEmitDetails);
+
+ boolean updateInformationAvailableQuantityOut(Double maxWeight,Double maxWidth,Double maxHeight,Integer quantity,
+ Double price,String unit,String glassShelfName);
+
+ boolean updateInformationAvailableQuantityInt(Double maxWeight,Double maxWidth,Double maxHeight,Integer quantity,
+ Double price,String unit,String glassShelfName);
+
+ boolean insertFinishedGlassShelfEmitDetailsLog(String emitId,Integer emitNumber,Integer type,Integer quantity,
+ Double price,Double money,String unit,String remarks,
+ Double maxWeight,Double maxWidth,Double maxHeight,String glassShelfName,String operator);
+
+ List<FinishedGlassShelfEmit> getSelectFinishedGlassShelfEmit(@Param("offset") Integer offset,
+ @Param("pageSize") Integer pageSize, String startDate, String endDate,
+ @Param("emit") FinishedGlassShelfEmit finishedGlassShelfEmit);
+
+ Map<String,Integer> getSelectFinishedGlassShelfEmitPageTotal(Integer offset, Integer pageSize, String startDate, String endDate,
+ @Param("emit") FinishedGlassShelfEmit finishedGlassShelfEmit);
+
+
+ boolean deleteFinishedGlassShelfEmitDetails(@Param("emitId") String emitId);
+
+ boolean deleteFinishedGlassShelfEmit(@Param("emitId") String emitId);
+
+ boolean deleteFinishedGlassShelfEmitDetailsLog(@Param("emitId") String emitId);
+
+ 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