From 1f455e5cda9016054c531bbae6b1639fe646628f Mon Sep 17 00:00:00 2001
From: czt <czt18638530771@163.com>
Date: 星期四, 27 十一月 2025 19:36:37 +0800
Subject: [PATCH] 框架调整，及库区切换
---
fzzy-igdss-core/src/main/java/com/fzzy/igds/repository/DepotRepository.java | 87 +++++++++++++++++++++++++++++++++++++++++++
1 files changed, 87 insertions(+), 0 deletions(-)
diff --git a/fzzy-igdss-core/src/main/java/com/fzzy/igds/repository/DepotRepository.java b/fzzy-igdss-core/src/main/java/com/fzzy/igds/repository/DepotRepository.java
new file mode 100644
index 0000000..1d06005
--- /dev/null
+++ b/fzzy-igdss-core/src/main/java/com/fzzy/igds/repository/DepotRepository.java
@@ -0,0 +1,87 @@
+package com.fzzy.igds.repository;
+
+import com.fzzy.igds.domain.Depot;
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.jpa.repository.Modifying;
+import org.springframework.data.jpa.repository.Query;
+import org.springframework.data.repository.query.Param;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+
+import java.util.List;
+
+/**
+ * @Description
+ * @Author CZT
+ * @Date 2025/11/27 13:39
+ */
+@Service
+public interface DepotRepository extends JpaRepository<Depot, String> {
+
+ /**
+ * 鏍规嵁缁勭粐缂栫爜鑾峰彇浠撳簱璐т綅淇℃伅
+ *
+ * @param companyId
+ * @return
+ */
+ @Query("from Depot where companyId =:companyId order by orderNum")
+ List<Depot> getDepotByCompanyId(@Param("companyId") String companyId);
+
+ /**
+ * 鏍规嵁缁勭粐缂栫爜鍜屽簱鍖虹紪鐮佽幏鍙栦粨搴撹揣浣嶄俊鎭�
+ *
+ * @param companyId
+ * @param deptId
+ * @return
+ */
+ @Query("from Depot where companyId =:companyId and deptId =:deptId order by orderNum")
+ List<Depot> getDepot(@Param("companyId") String companyId, @Param("deptId") String deptId);
+
+ /**
+ * 鏍规嵁缁勭粐缂栫爜鍜屼粨搴撶紪鐮佽幏鍙栦粨搴撹揣浣嶄俊鎭�
+ * @param companyId
+ * @param id
+ * @return
+ */
+ @Query("from Depot where companyId =:companyId and id =:id")
+ Depot getDepotById(@Param("companyId") String companyId, @Param("id") String id);
+
+
+ /**
+ * 鏇存柊浠撳簱鐘舵��
+ * @param status
+ * @param depotId
+ */
+ @Transactional
+ @Modifying
+ @Query("update Depot set depotStatus =:status where id =:depotId")
+ void updateDepotStatus(@Param("status") String status, @Param("depotId") String depotId);
+
+ /**
+ * 鏍规嵁ids鑾峰彇浠撳簱
+ *
+ * @param list
+ * @return
+ */
+ @Query("from Depot where id IN :list order by orderNum")
+ List<Depot> getDepotByIds(@Param("list") List<String> list);
+
+ /**
+ * 鏇存柊浠撳簱鍌ㄩ噺
+ * @param weight
+ * @param depotId
+ */
+ @Transactional
+ @Modifying
+ @Query("update Depot set storageReal =:weight where id =:depotId")
+ void updateDepotStorage(@Param("weight") Double weight, @Param("depotId") String depotId);
+
+ /**
+ * 鑾峰彇搴撳尯涓嬫渶澶т粨搴撶紪鐮�
+ *
+ * @param deptId
+ * @return
+ */
+ @Query("from Depot where deptId =:deptId order by id")
+ List<Depot> getDepotMaxId(@Param("deptId") String deptId);
+}
--
Gitblit v1.9.3