liebao-cloud/lb-module/src/main/java/com/ydd/module/mapper/OrderMapper.java

package com.ydd.module.mapper;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ydd.common.core.domain.entity.SysUser;
import com.ydd.module.domain.Order;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ydd.module.domain.ProfitsMerchant;
import com.ydd.module.dto.*;
import com.ydd.module.request.OrderListRequest;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.Date;
import java.util.List;

/**
 * 配送订单Mapper接口
 *
 * @author douya
 * @date 2021-02-01
 */
public interface OrderMapper extends BaseMapper<Order> {

    List<Order> queryPage(@Param("params") Order order, @Param("memberIds") List<Integer> memberIds);

    /**
     * 分页查询
     *
     * @param page
     * @param order
     * @return
     */
    List<SystemOrderDto> queryPageList(@Param("page") Page page, @Param("params") SystemOrderDto order, @Param("agentIds") List<Long> agentIds, @Param("aIds") List<Long> aIds);

    /**
     * 分页查询
     *
     * @param page
     * @param order
     * @return
     */
    List<SystemOrderDto> queryPageListNew(@Param("page") Page page, @Param("params") SystemOrderDto order);

    /**
     * 查询导出订单列表
     * @param order
     * @param agentIds
     * @param aIds
     * @return
     */
    List<OrderExportDto> selectExportOrder(@Param("params") SystemOrderDto order, @Param("agentIds") List<Long> agentIds, @Param("aIds") List<Long> aIds);

    // List<OrderDetailDto> findOneKeyList(@Param("memberId")Long loginId, @Param("status")Integer status,@Param("searchKey") String searchKey,@Param("waimaiId") Integer waimaiId, @Param("shopId")Integer shopId,@Param("spId")Integer spId);
    List<OrderDetailDto> findOneKeyList(@Param("memberId") Long loginId, @Param("status") Integer status, @Param("searchKey") String searchKey,
                                        @Param("waimaiId") Integer waimaiId, @Param("shopId") Integer shopId, @Param("shopIds") List<Long> shopIds,
                                        @Param("startDate") String startDate, @Param("endDate") String endDate,@Param("oldStatus") Integer oldStatus);

    List<Order> findList(@Param("memberId") List<Long> loginId, @Param("status") Integer status, @Param("searchKey") String searchKey,
                         @Param("shopId") Integer shopId, @Param("startDate") String startDate, @Param("endDate") String endDate,
                         @Param("city") String city, @Param("deliveryId")  Integer deliveryId, @Param("type")  Integer type);

    Order getDetail(@Param("memberId") List<Long> loginId, @Param("orderId") Integer orderId);

    Order getDetailByShopId(@Param("shopIds") List<Integer> shopIds, @Param("orderId") Integer orderId);

    Integer getOrderNum(@Param("shopIds") List<Long> shopIds, @Param("startDate") String startDate);

    BigDecimal getOrderAmount(@Param("shopIds") List<Long> shopIds, @Param("startDate") String startDate);

    List<Order> queryTimeOutOrder(@Param("time")Integer time);


    /**
     * 配送统计
     *
     * @param status
     * @param deliveryId
     * @param shopIds
     * @param timeType
     * @param startTime
     * @param endTime
     * @return
     */
    // OrderSumDto sumOrder(@Param("loginId")Long loginId,@Param("status")Integer status, @Param("deliveryId")Integer deliveryId, @Param("shopId")Long shopId, @Param("timeType")Integer timeType, @Param("startTime")String startTime, @Param("endTime")String endTime);
    List<Order> sumOrder(@Param("loginId") Long loginId, @Param("status") Integer status, @Param("deliveryId") Integer deliveryId, @Param("shopIds") List<Integer> shopIds, @Param("timeType") Integer timeType, @Param("startTime") String startTime, @Param("endTime") String endTime);

    /**
     * 配送统计
     *
     * @param status
     * @param deliveryId
     * @param shopId
     * @param timeType
     * @param startTime
     * @param endTime
     * @return
     */
    OrderSumDto sumOrder1(@Param("loginId") Long loginId, @Param("status") Integer status, @Param("deliveryId") Integer deliveryId, @Param("shopId") Long shopId, @Param("timeType") Integer timeType, @Param("startTime") String startTime, @Param("endTime") String endTime);

    List<Order> getByStatus();

    /**
     * 统计数量通过订单
     *
     * @param order
     * @return 订单数量
     */
    List<SystemOrderDto> selectCountByStatusNew(@Param("params") SystemOrderDto order);

    void autofinish();

    BigDecimal totalConsume(@Param("shopIds") List<Long> shopIds, @Param("params")ProfitsMerchant profitsMerchant);

    BigDecimal totalConsumeByMemberId(@Param("memberId")Long memberId);

    String selectOriginalOrderSn1(@Param("waimaiOrderId") Long waimaiOrderId);

    Page<OrderListDto> getOrderList(@Param("params") OrderListRequest request, IPage<OrderListDto> pageArt);

    List<OrderListDto> getOrderListByShopIdsAndMemberIds(@Param("shopIds") List<Long> shopIds, @Param("memberId") Long memberId, @Param("memberType") Integer memberType, @Param("hasPersonalOrder") boolean hasPersonalOrder);

    ProfitsSystemOrderDto selectOrderData(@Param("orderId")Long orderId);

    /**
     * 根据订单号查找订单
     * @param orderSn
     * @return
     */
    Order getByOrderSn(String orderSn);

    /**
     * 根据订单号查找订单(包括异常单)
     * @param orderSn
     * @return
     */
    List<Order> getAllOrderByOrderSn(String orderSn);

    /**
     * 根据订单id查找订单(包括异常单)
     * @param orderId
     * @return
     */
    Order getAllOrderByOrderId(Long orderId);

    List<DadaOrderListDto> queryDadaPageList(@Param("page") Page page, @Param("params") DadaOrderListQuery orderQuery);

    List<SystemOrderDto> selectDadaCountByStatus(@Param("params") DadaOrderListQuery orderQuery);

    List<SystemOrderDto> selectCountByStatus(SystemOrderDto order, List<Integer> agentIds, List<Long> aIds);

    OrderInfoDto getOrderInfoByOrderId(@Param("orderId") Long orderId);

    List<SubsidyStatisticsDto> getSubsidyList(Page page, @Param("params") SubsidyStatisticsQuery query);

    Integer countPersonalOrder(@Param("lastDayTime") String lastDayTime, @Param("memberId") Long memberId);

    Order selectOrderBySn(@Param("orderSn") String orderSn, @Param("outOrderSn") String outOrderSn);

}