caimei365-manager/src/main/java/com/caimei/modules/order/dao/NewOrderDao.java

package com.caimei.modules.order.dao;

import com.caimei.modules.coupon.entity.CmCoupon;
import com.caimei.modules.coupon.entity.CmCouponOrderRecord;
import com.caimei.modules.order.entity.*;
import com.caimei.modules.product.entity.CmPromotion;
import com.caimei.modules.user.entity.NewCmSp;
import com.thinkgem.jeesite.common.persistence.CrudDao;
import com.thinkgem.jeesite.common.persistence.annotation.MyBatisDao;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;
import java.util.Set;

@MyBatisDao
public interface NewOrderDao extends CrudDao<NewOrder> {

    List<CmOrderPaymentVoucherVo> findVoucherVoOrderID(@Param("orderId") Integer orderID);

    List<CmVoucherImage> findCmVoucherImageoOrderID(@Param("id") Integer id);

    Integer updateClauseContent(NewOrder newOrder);

    NewOrder findByOrderID(@Param("orderID") Integer orderID);

    int confirmOrder(Integer orderID);

    void updateStatus(NewOrder order);

    NewOrder getOrderByShopOrderID(@Param("shopOrderID") String shopOrderID);

    void updatePayStatus(@Param("payStatus") String payStatus, @Param("orderID") Integer orderID);

    List<NewOrder> findOrderList(NewOrder newOrder);

    Double findPaidOrderID(@Param("orderID") Integer orderID);

    List<CmPromotion> findPromotionsByIds(@Param("promotionsIds") Set promotionsIds);

    CmPromotion getDbPromotionsByOrderId(@Param("orderId") Integer orderId, @Param("promotionsId") Integer promotionsId);

    int insertPromotionsRecord(CmPromotion promotion);

    int updatePromotionsRecord(CmPromotion promotion);

    /**
     * 置为已收款已付款
     * @param orderId
     */
    void updatePayAndReceipt(Integer orderId);
    /**
     * 子订单置为已收款已付款
     * @param orderId
     */
    void updatePayStatusSon(Integer orderId);
    /**
     * 删除此订单下订单促销
     *
     * @param orderId
     */
    void deleterPomotionsOrder(Integer orderId);

    /**
     * 更新订单付款状态和0成本标识
     *
     * @param newOrder
     */
    void updateOrderStatus(NewOrder newOrder);

    /**
     * 获取上线协销人员，排除采美默认协销经理
     *
     * @return ServiceProvider
     */
    List<NewCmSp> findServiceProviderList();

    /**
     * 修改订单返佣标识
     *
     * @param orderId
     */
    void updateByRebateFlag(Integer orderId);

    /**
     * 查询商品资质文件
     *
     * @param recordId
     * @return
     */
    List<CmFile> findQualificationFile(String recordId);

    /**
     * 查询资质图片
     *
     * @param recordId
     * @return
     */
    List<String> findQualificationImage(Integer recordId);

    /**
     * 删除所有的资质图片
     *
     * @param recordId
     */
    void deleteQualificationImage(Integer recordId);

    /**
     * 保存资质图片
     *
     * @param recordId
     * @param image
     */
    void insertQualificationImage(@Param("recordId") Integer recordId, @Param("image") String image);

    /**
     * 删除商品资质文件
     *
     * @param recordId
     */
    void deleteQualificationFile(Integer recordId);

    /**
     * 保存商品资质文件
     *
     * @param recordId
     * @param fileName
     * @param ossName
     */
    void insertQualificationFile(@Param("recordId") Integer recordId, @Param("fileName") String fileName, @Param("ossName") String ossName);

    /**
     * 查询短链接是否存在
     *
     * @param shortLink
     * @return
     */
    Integer findBYShortLink(String shortLink);

    /**
     * 保存短链接信息
     *
     * @param markId    短信类型
     * @param shortLink 短链接
     * @param url       跳转地址
     */
    void insertShortLink(@Param("markId") int markId, @Param("shortLink") String shortLink, @Param("url") String url);

    /**
     * 保存短信发送条数
     *
     * @param markId
     * @param num
     */
    void updateSendNum(@Param("markId") int markId, @Param("num") int num);
    /**
     * 获取订单定金商品Id
     * @param orderID
     * @return
     */
    Integer getDepositOrderProductId(Integer orderID);
    /**
     * 定金商品撤销收款，用户余额扣除
     */
    void updateUserMoneyByUserId(@Param("payTotalFee")Double payTotalFee,@Param("userID") Integer userID);

    /**
     * 查询订单优惠券信息
     *
     * @param orderID
     * @return
     */
    CmCouponOrderRecord findOrderCouponRecord(Integer orderID);

    /**
     * 查询优惠券信息
     *
     * @param clubCouponId
     * @return
     */
    CmCoupon findClubCouponById(Integer clubCouponId);

    /**
     * 保存优惠券与订单关联信息
     *
     * @param orderRecord
     */
    void insertCouponOrderRecord(CmCouponOrderRecord orderRecord);

    /**
     * 更新优惠券与订单关联信息
     *
     * @param orderRecord
     */
    void updateCouponOrderRecord(CmCouponOrderRecord orderRecord);

    /**
     * 删除优惠券与订单关联信息
     *
     * @param id
     */
    void deleteCouponOrderRecord(Integer id);

    List<OrderReceiptRelationPo> getUndividedPaidReceipt(@Param("currentTime")String currentTime,@Param("shopOrderIds")String shopOrderIds);

    List<OrderReceiptRelationPo> getOnlineBalance(String currentTime);

    List<OrderProductVo> getOrderProductByOrderId(Integer orderId);

    Double getOrderProductPaidAmount(Integer orderProductId);

    ShopOrderVo getShopOrderListByOrderId(Integer shopOrderId);

    List<ShopOrderVo> getShopOrderByOrderId(Integer orderId);

    Double getPaidShipping(Integer orderId, Integer shopId);

    String getShopCommercialCode(Integer shopId);

    OrderVo getOrderByOrderId(Integer orderId);

    void insertSplitAccount(SplitAccountPo splitAccount);

    Date findSplitTime();

    void updateOnlinePayFlag(@Param("onlinePayFlag") Integer onlinePayFlag,@Param("orderId") Integer orderId);

    void updateBrokerage(@Param("shopOrderID")Integer shopOrderID ,@Param("brokerage")Double brokerage);

    Integer findSupport(Integer shopOrderId);

    List<OrderProductVo> getOrderProductByShopOrderId(Integer shopOrderId);

    List<SplitAccountPo> getSplitAccountList(String mbOrderId);

    Double getPaidShopAmount(Integer shopOrderId);

    void updateShopOrderByPayStatus(@Param("shopOrderId")Integer shopOrderId,@Param("paidShop") Double paidShop,@Param("payStatus") Integer payStatus);

    void insertPayShop(PayShopPo payShop);

    void insertPayShopRecord(PayShopRecordPo shopRecord);

    void updateOrderByPayStatus(@Param("orderId")Integer orderId, @Param("payStatus")Integer payStatus);

    void updateBySplitStatus(String mbOrderId);

    Integer findOnlinePay(Integer orderID);

    String findSplitCode(String shopOrderId);

    Double findPayAmount(String shopOrderId);

    Double findShouldPayShopAmount(String shopOrderId);

    void updateSettleStatus(@Param("shopOrderId")String shopOrderId,@Param("productType") Integer productType);

    void updateShopOrderSettleStatus(@Param("shopOrderId")String shopOrderId, @Param("settleStatus")Integer settleStatus);

    void insertSettleRecord(SettleRecord settleRecord);

    Double findSettleSum(String shopOrderId);

    List<SettleRecord> findSettleRecord(Integer orderID);

    Double findSettleAmount(Integer orderID);

    Integer findShopOrderSize(Integer orderID);

    Integer findSplitCount(Integer orderID);

    List<SplitAccountPo> getSplitRecord(Integer orderID);

    Integer getSplitTime(Integer shopOrderId);
}