package com.ylx.order.mapper; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.ylx.massage.domain.vo.HomeBlock; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import com.ylx.order.domain.TOrder; import java.math.BigDecimal; import java.util.Date; import java.util.List; /** *

* 订单表 Mapper 接口 *

* * @author YJR * @since 2023-11-24 */ @Mapper public interface TOrderMapper extends BaseMapper { Page getAll(Pagepage, @Param("param") TOrder param); Integer getOrderNum(@Param("jsid") String jsid, @Param("startDate") Date startDate, @Param("endDate") Date endDate); Integer getAddNum(@Param("jsid") String jsid, @Param("startDate") Date startDate, @Param("endDate") Date endDate); Integer getUpgradeNum(@Param("jsid") String jsid, @Param("startDate") Date startDate, @Param("endDate") Date endDate); BigDecimal getTurnover(@Param("jsid") String jsid, @Param("startDate") Date startDate, @Param("endDate") Date endDate); List getBlock(@Param("start") Date start, @Param("end") Date end, @Param("deptId") String deptId); //执行存储过程 大于48小时 订单状态更新为 已结算 自动分账 订单总金额*佣金比例划入用户余额 void callAutoAccount(@Param("hCount")int hCount, @Param("percent")BigDecimal percent); List getAll(@Param("param") TOrder param); }