package com.example.erp.mapper.sd;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.example.erp.dto.sd.OrderDTO;
|
import com.example.erp.dto.sd.OrderDetailProductDTO;
|
import com.example.erp.entity.sd.Order;
|
import com.example.erp.entity.sd.OrderDetail;
|
import org.apache.ibatis.annotations.Mapper;
|
|
import java.time.LocalDate;
|
import java.util.List;
|
import java.util.Map;
|
|
@Mapper
|
public interface OrderDetailMapper extends BaseMapper<OrderDetail> {
|
|
boolean insertBatch(List<OrderDetail> orderDetails);
|
|
boolean updateOrderMoney( List<OrderDetail> orderDetails);
|
|
List<OrderDetail> getOrderReport(Integer offset, Integer pageSize, String startDate, String endDate, OrderDetail orderDetail);
|
|
//type为了区别需不需要根据产品分类
|
Map<String,Integer> getOrderReportTotal(Integer offset, Integer pageSize, String startDate, String endDate, OrderDetail orderDetail, String type);
|
|
List<OrderDTO> exportOrderReport(List<LocalDate> dates);
|
|
List<OrderDetail> getOrderProductSummary(Integer offset, Integer pageSize, String startDate, String endDate, OrderDetail orderDetail);
|
|
Map<String,Integer> getOrderProductSummaryTotal(Integer offset, Integer pageSize, String startDate, String endDate, OrderDetail orderDetail, String product);
|
|
List<OrderDTO> exportOrderProductSummary(List<LocalDate> dates);
|
|
List<OrderDetailProductDTO> exportOrderReportProduct(List<LocalDate> dates);
|
|
Map<String, String> getOrderProductDetailTag(String orderId);
|
|
List<Map<String,Object>> getOrderProductDistinctById(String orderId);
|
|
List<Map<String,Object>> getOrderProductDistinctByIds(String orderId,List<String> productId);
|
|
List<OrderDetail> getOrderProductByProductId(Object productId, String orderId);
|
|
List<Map<String,Object>> getOrderProductByProductIds(Object productId, String orderId);
|
|
List<Order> getOrderSummaryReport(Integer offset, Integer pageSize, String startDate, String endDate, Order order);
|
|
Map<String,Integer> getOrderSummaryReportTotal(Integer offset, Integer pageSize, String startDate, String endDate, Order order, String type);
|
|
List<Order> exportOrderSummary(List<LocalDate> dates);
|
|
|
}
|
