cloudroam
2025-03-28 4e5c47ee19caf98810b4ee50661fc141c4d7478f
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
package com.mzl.flower.mapper.payment;
 
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.mzl.flower.dto.response.payment.AbnormalOrderItemDTO;
import com.mzl.flower.dto.response.payment.OrderItemListDTO;
import com.mzl.flower.dto.response.payment.OrderItemPlatformListDTO;
import com.mzl.flower.entity.payment.OrderItem;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
 
import java.time.LocalDateTime;
import java.util.List;
 
@Repository
public interface OrderItemMapper extends BaseMapper<OrderItem> {
    List<AbnormalOrderItemDTO> getAbnormalItems(@Param("orderId") String orderId);
 
    List<OrderItemPlatformListDTO> getPlatformOrderItems(@Param("orderId") String orderId);
 
    List<OrderItemListDTO> getOrderItems(@Param("orderIds") List<String> orderIds);
 
    Integer getFlowerSaleNum(@Param("startTime") LocalDateTime startTime
            , @Param("endTime") LocalDateTime endTime);
 
    @Select("select  sum(num) from t_order_item where deleted = '0' and order_id = #{orderId}")
    Integer getSumNumByOrderId(String orderId);
}