kmall-haikong/kmall-admin/src/main/java/com/kmall/admin/dao/OrderDao.java

package com.kmall.admin.dao;

import com.kmall.admin.dto.*;
import com.kmall.admin.entity.OrderEntity;
import com.kmall.admin.entity.PurchaseSalesInStockDetail;
import com.kmall.admin.entity.RealtimeSalesDetection;
import com.kmall.api.entity.OrderVo;
import com.kmall.common.utils.Query;
import org.apache.ibatis.annotations.Param;
import com.kmall.manager.dao.BaseDao;
import org.springframework.transaction.annotation.Isolation;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;

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

/**
 * @author Scott
 * @email
 * @date 2017-08-13 10:41:09
 */
public interface OrderDao extends BaseDao<OrderEntity> {
    void riderOrderUpdate(OrderEntity orderVo);

    /**
     * 获取活动Id
     *
     * @param activityId
     */
    List<OrderEntity> queryObjectByActivityId(@Param("activityId") Integer activityId);

    OrderEntity queryObjectBySysUser(Long id);
    /**
     * 已付款订单会员数
     *
     * @return
     */
    int getYfkOrderUserSum(Map<String, Object> map);

    /**
     * 有订单会员数
     *
     * @return
     */
    int getOderUserSum(Map<String, Object> map);

    /**
     * 今日订单数
     *
     * @return
     */
    int getTodayUserOrder(Map<String, Object> map);

    /**
     * 今日会员购物总额
     *
     * @return
     */
    int getTodayUserSales(Map<String, Object> map);

    /**
     * 总收入
     *
     * @return
     */
    int getIncomeSum(Map<String, Object> map);

    /**
     * 已支付订单数
     *
     * @return
     */
    int getPayedOrderCount(Map<String, Object> map);

    Double getTotalActualPrice(@Param("merchOrderSn")String merchOrderSn);

    List<OrderEntity> queryOffilineOrderList(Map<String, Object> map);

    List<OrderEntity> queryObjectByMerchOrderSn(@Param("merchOrderSn")String merchOrderSn);

    List<OrderEntity> queryExportList(Map<String, Object> map);

    OrderEntity queryObjectByOrderSn(@Param("orderSn")String orderSn);

    List<OrderEntity> promOrderList(Map<String, Object> map);

    int queryPromOrderTotal(Map<String, Object> map);

    List<OrderEntity> promOrderListExport(Map<String, Object> map);

    /**
     * 获取已排除不是推广订单的且已支付的实收金额
     * @param map
     * @return
     */
    Double getActualPriceByOutProm(Map<String, Object> map);

    List<OrderEntity> storeTopicOrderList(Map<String, Object> map);

    int queryStoreTopicOrderTotal(Map<String, Object> map);

    //查询与人脸识别认证表相关联的保税展示跨境商品订单
    List<OrderRecognitionDto> queryOrderListByRecognition(Map<String, Object> map);

    //根据订单id查询发送微信模板需要的订单信息
    SendTempDto queryOrderByRecogTemp(long orderId);

    int queryOrderListByRecognitionTotal(Map<String, Object> map);

    int saveOrderVo(OrderVo orderVo);

    //实时销售监测
    RealtimeSalesDetection queryRealtimeSales(Map realtimeSalesDetection);

    int queryOffilineOrderTotal(Query query);

    List<PurchaseSalesInStockDetail> purchaseSalesInStockDetailList(Query query);

    int purchaseSalesInStockDetailTotal(Query query);

    BigDecimal queryTopicPriceByOrderSnAndSku(@Param("orderSn") String orderSn,@Param("sku") String sku);

    /**
     * 线下订单导出
     * @param params
     * @return
     */
    List<OrderEntity> queryExportOffilineOrderList(Map<String, Object> params);

    /**
     * 线下订单明细导出
     * @param params
     * @return
     */
    List<OrderEntity> queryMasterExportOffilineOrderList(Map<String, Object> params);

    /**
     * 线上订单导出
     * @param params
     * @return
     */
    List<OrderEntity> queryMasterExportList(Map<String, Object> params);

    void updateOrderInfo(Map orderRaram);

    void updateOrderProcessRecord(Map processParam);

    List<OrderEntity> queryPickUpCodeList(Map<String, Object> map);

    /**
     * System Format导出
     * @param params
     * @return
     */
    List<SystemFormatDto> queryExportSystemFormatList(Map<String, Object> params);

    ExportExcelDto totalAmount(@Param("billDate") String billDate, @Param("storeId") String storeId);

    ExportExcelDto refundCurrentAmount(@Param("billDate") String billDate, @Param("storeId") String storeId);

    ExportExcelDto refundPreviousAmount(@Param("billDate") String billDate, @Param("storeId") String storeId);

    ExportExcelDto currentTax(@Param("billDate") String billDate, @Param("storeId") String storeId);

    ExportExcelDto refundPreviousTax(@Param("billDate") String billDate, @Param("storeId") String storeId);

    List<OrderEntity> queryRefundPreviousOrderList(@Param("billDate") String billDate, @Param("storeId") String storeId);

    List<OrderEntity> queryCurrentPreviousOrderList(@Param("billDate") String billDate, @Param("storeId") String storeId);

    List<TaxDetailDto> queryCurrentTaxDetailList(@Param("billDate") String billDate, @Param("storeId") String storeId);

    List<TaxDetailDto> queryRefundPreviousTaxDetailList(@Param("billDate") String billDate, @Param("storeId") String storeId);

    List<OrderEntity> queryAll201Order(@Param("date") String date);

    int updateOrderRefunding(Long id);

    /**
     * 根据订单号更新订单状态
     * @param orderSnList 订单号
     */
    void updateOrderStatusByOrderSnList(List<String> orderSnList);

    Integer queryObjectByMerchOrderSnHkMall(@Param("merchOrderSn")String merchOrderSn);

    /**
     * 支付单凭证回传更新 buyer_pay_check
     * @param wxMap 更新数据
     * @return      结果
     */
    int updateBuyerPayCheck(Map<String, Object> wxMap);
}