package com.example.erp.mapper.sd;
|
|
import com.example.erp.dto.sd.CustomerDTO;
|
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<Map<String,Object>> getSelectCustomerOderDate(@Param("offset") Integer offset,
|
@Param("pageSize") Integer pageSize, String startDate, String endDate,
|
@Param("orderDetail") OrderDetail orderDetail);
|
|
List<Map<String,Object>> getSelectCustomerDeliveryDate(@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);
|
|
Map<String,Integer> getSelectCustomerDeliveryDatePageTotal(Integer offset, Integer pageSize,String startDate, String endDate, OrderDetail orderDetail);
|
|
List<CustomerDTO> exportSelectCustomerOderDate(String startDate, String endDate,
|
@Param("orderDetail") OrderDetail orderDetail);
|
|
List<CustomerDTO> exportSelectCustomerDeliveryDate(String startDate, String endDate,
|
@Param("orderDetail") OrderDetail orderDetail);
|
|
List<Map<String,Object>> getProjectList(Long id);
|
}
|
