From ef5a518c3e2c1fe41aa60f56ca31ddafa0cb1561 Mon Sep 17 00:00:00 2001
From: guoyuji <guoyujie@ng.com>
Date: 星期四, 23 五月 2024 08:32:36 +0800
Subject: [PATCH] 添加产品汇总报表

---
 north-glass-erp/src/main/java/com/example/erp/mapper/sd/CustomerMapper.java |   36 ++++++++++++++++++++++++++++++++++++
 1 files changed, 36 insertions(+), 0 deletions(-)

diff --git a/north-glass-erp/src/main/java/com/example/erp/mapper/sd/CustomerMapper.java b/north-glass-erp/src/main/java/com/example/erp/mapper/sd/CustomerMapper.java
new file mode 100644
index 0000000..86622ca
--- /dev/null
+++ b/north-glass-erp/src/main/java/com/example/erp/mapper/sd/CustomerMapper.java
@@ -0,0 +1,36 @@
+package com.example.erp.mapper.sd;
+
+import com.example.erp.entity.sd.Customer;
+import com.example.erp.entity.sd.Delivery;
+import com.example.erp.entity.sd.DeliveryDetail;
+import com.example.erp.entity.sd.OrderDetail;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.springframework.data.repository.CrudRepository;
+
+import java.util.List;
+import java.util.Map;
+
+@Mapper
+public interface CustomerMapper extends CrudRepository<Customer,Long> {
+
+    List<Customer> getCustomerList();
+    List<Customer> getSelectCustomer(@Param("offset") Integer offset,
+                                         @Param("pageSize") Integer pageSize,
+                                         @Param("customer") Customer customer);
+
+
+    Map<String,Integer> getSelectCustomerPageTotal(Integer offset, Integer pageSize, Customer customer);
+
+    Boolean insertCustomer(@Param("customer") Customer customer);
+
+    Boolean updateCustomer(@Param("customer") Customer customer);
+
+    Boolean deleteCustomer(@Param("customer") Customer customer);
+
+    List<OrderDetail> getSelectCustomerOderDate(@Param("offset") Integer offset,
+                                                    @Param("pageSize") Integer pageSize, String startDate, String endDate,
+                                                    @Param("orderDetail") OrderDetail orderDetail);
+
+    Map<String,Integer> getSelectCustomerOderDatePageTotal(Integer offset, Integer pageSize,String startDate, String endDate, OrderDetail orderDetail);
+}

--
Gitblit v1.8.0