陶杰
2025-01-08 ae1471f378f399f76518539ec8992e64a3673436
src/main/java/com/mzl/flower/mapper/payment/OrderItemMapper.java
@@ -6,8 +6,10 @@
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
@@ -17,4 +19,10 @@
    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);
}