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 { List findVoucherVoOrderID(@Param("shopOrderId") Integer shopOrderId); List findCmVoucherImageoOrderID(@Param("id") Integer id); Integer updateClauseContent(NewOrder newOrder); NewOrder findByOrderID(@Param("orderID") Integer orderID); void updateStatus(NewOrder order); NewOrder getOrderByShopOrderID(@Param("shopOrderID") String shopOrderID); void updatePayStatus(@Param("payStatus") String payStatus, @Param("orderID") Integer orderID); List findOrderList(NewOrder newOrder); Double findPaidOrderID(@Param("orderID") Integer orderID); List 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 findServiceProviderList(); /** * 修改订单返佣标识 * * @param orderId */ void updateByRebateFlag(Integer orderId); /** * 查询商品资质文件 * * @param recordId * @return */ List findQualificationFile(String recordId); /** * 查询资质图片 * * @param recordId * @return */ List 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 getUndividedPaidReceipt(@Param("currentTime")String currentTime,@Param("shopOrderIds")String shopOrderIds); List getOrderProductByOrderId(Integer orderId); Double getOrderProductPaidAmount(Integer orderProductId); ShopOrderVo getShopOrderListByOrderId(Integer shopOrderId); List 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 getOrderProductByShopOrderId(Integer shopOrderId); List 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 findSettleRecord(Integer orderID); Double findSettleAmount(Integer orderID); Integer findShopOrderSize(Integer orderID); Integer findSplitCount(Integer orderID); List getSplitRecord(Integer orderID); Integer getSplitTime(Integer shopOrderId); }