123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271 |
- 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("shopOrderId") Integer shopOrderId);
- List<CmVoucherImage> 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<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<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);
- }
|