blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
chenlu
2024-06-07 2f640b1038fa331954f78ed1f4317212cf5bb34d 
 north-glass-erp/src/main/java/com/example/erp/mapper/sd/DeliveryDetailMapper.java


New file


@@ -0,0 +1,78 @@


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("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,@Param("deliveryDetailMoney") Double deliveryDetailMoney);




    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);




}