feat(db/dao): new productSlot dao

2 files changed, 27 insertions, 0 deletions

diff --git a/src/main/java/ru/mrfoxygmfr/warehouse_accounting/db/dao/ProductSlotDAO.java b/src/main/java/ru/mrfoxygmfr/warehouse_accounting/db/dao/ProductSlotDAO.java
new file mode 100644
index 0000000..469bf2a
--- /dev/null
+++ b/src/main/java/ru/mrfoxygmfr/warehouse_accounting/db/dao/ProductSlotDAO.java
@@ -0,0 +1,8 @@
+package ru.mrfoxygmfr.warehouse_accounting.db.dao;
+
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
+import ru.mrfoxygmfr.warehouse_accounting.db.models.ProductSlot;
+
+public interface ProductSlotDAO extends JpaRepository<ProductSlot, Integer>, JpaSpecificationExecutor<ProductSlot> {
+}
diff --git a/src/main/java/ru/mrfoxygmfr/warehouse_accounting/db/dao/specs/ProductSlotSpecs.java b/src/main/java/ru/mrfoxygmfr/warehouse_accounting/db/dao/specs/ProductSlotSpecs.java
new file mode 100644
index 0000000..2a8e448
--- /dev/null
+++ b/src/main/java/ru/mrfoxygmfr/warehouse_accounting/db/dao/specs/ProductSlotSpecs.java
@@ -0,0 +1,19 @@
+package ru.mrfoxygmfr.warehouse_accounting.db.dao.specs;
+
+import jakarta.persistence.criteria.Join;
+import org.springframework.data.jpa.domain.Specification;
+import ru.mrfoxygmfr.warehouse_accounting.db.models.*;
+
+public class ProductSlotSpecs {
+    public static Specification<ProductSlot> productStorageStatusEqual(ProductStorageStatus status) {
+        return (root, _, builder)
+                -> builder.equal(root.get(ProductSlot_.status), status) ;
+    }
+
+    public static Specification<ProductSlot> productSlotContainsLike(String productName) {
+        return (root, _, builder) -> {
+            Join<ProductSlot, Product> withProduct = root.join(ProductSlot_.product);
+            return builder.like(withProduct.get(Product_.name), "%" + productName + "%");
+        };
+    }
+}