package com.example.erp.mapper.sd;
|
|
import com.example.erp.dto.sd.DeliveryDetailDTO;
|
import com.example.erp.dto.sd.DeliveryDetailProductDTO;
|
import com.example.erp.entity.sd.Delivery;
|
import com.example.erp.entity.sd.DeliveryDetail;
|
import com.example.erp.entity.sd.Order;
|
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.time.LocalDate;
|
import java.util.List;
|
import java.util.Map;
|
|
@Mapper
|
public interface DeliveryDetailMapper extends CrudRepository<DeliveryDetail,Long> {
|
|
List<DeliveryDetail> getSelectShippingOrderDetail(@Param("offset") Integer offset,
|
@Param("pageSize") Integer pageSize,
|
@Param("orderDetail") OrderDetail orderDetail);
|
|
|
|
Integer getSelectShippingOrderDetailPageTotal(Integer offset, Integer pageSize,OrderDetail orderDetail);
|
|
List<DeliveryDetail> getSelectDeliveryPrinting(@Param("deliveryDetail") DeliveryDetail deliveryDetail);
|
|
List <Map<String, Object>> getSelectDeliveryDetailPrinting(@Param("deliveryId") String deliveryId,
|
@Param("productId") Integer productId,@Param("orderId") String orderId);
|
|
List<DeliveryDetail> getSelectDeliveryDetailReport(@Param("offset") Integer offset,
|
@Param("pageSize") Integer pageSize,String startDate, String endDate,
|
@Param("deliveryDetail") DeliveryDetail deliveryDetail);
|
|
Map<String,Integer> getSelectDeliveryDetailReportPageTotal(Integer offset, Integer pageSize,String startDate, String endDate, DeliveryDetail deliveryDetail);
|
|
List<DeliveryDetail> getSelectDeliveryDetailProductReport(@Param("offset") Integer offset,
|
@Param("pageSize") Integer pageSize,String startDate, String endDate,
|
@Param("deliveryDetail") DeliveryDetail deliveryDetail);
|
|
Map<String,Integer> getSelectDeliveryDetailProductReportPageTotal(Integer offset, Integer pageSize,String startDate, String endDate, DeliveryDetail deliveryDetail);
|
|
List<DeliveryDetail> getSelectShippingOrderDetails(@Param("offset") Integer offset,
|
@Param("pageSize") Integer pageSize,
|
@Param("orderDetail") OrderDetail orderDetail);
|
|
List<DeliveryDetail> getIsNotDeliveryDetail(@Param("deliveryDetailNumber") String deliveryDetailNumber,@Param("deliveryId") String deliveryId);
|
|
|
|
Integer getSelectShippingOrderDetailsPageTotal(Integer offset, Integer pageSize,OrderDetail orderDetail);
|
|
Boolean insertDeliveryDetail(@Param("orderDetail") OrderDetail orderDetail, @Param("number") String number,@Param("deliveryNumber") Integer deliveryNumber);
|
|
Integer getdeliveryDetailmaximum(@Param("deliveryId") String deliveryId);
|
|
Integer getSelectDetailNum(@Param("orderId") String orderId);
|
|
Integer getSelectDetailQuantity(@Param("orderId") String orderId);
|
|
Boolean updateOrderDetailDeliveryNum(OrderDetail orderDetail);
|
|
Boolean updateOrderDelivery(@Param("orderDetail") OrderDetail orderDetail,@Param("state") Integer state);
|
|
Boolean updateIsNotOrderDetailDeliveryNum(@Param("orderId") String orderId,
|
@Param("orderNumber") Integer orderNumber,
|
@Param("quantity") Integer quantity);
|
|
Boolean deleteDeliveryDetail(@Param("deliveryId") String deliveryId);
|
|
List<DeliveryDetailDTO> exportDeliveryDetailReport(List<LocalDate> dates);
|
|
List<DeliveryDetailProductDTO> exportDeliveryDetailProductReport(List<LocalDate> dates);
|
|
}
|
