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