package cn.lili.modules.distribution.mapper; import cn.lili.modules.distribution.entity.dos.Distribution; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import org.apache.ibatis.annotations.Update; /** * 分销员数据处理层 * * @author pikachu * @since 2020-03-14 23:04:56 */ public interface DistributionMapper extends BaseMapper { @Update("UPDATE li_distribution set commission_frozen = (IFNULL(commission_frozen,0) - #{commissionFrozen}) " + ", rebate_total=(IFNULL(rebate_total,0) - #{commissionFrozen}) " + ", distribution_order_count=(IFNULL(distribution_order_count,0)-1) " + " WHERE id = #{distributionId}") void subRebate(Double commissionFrozen, String distributionId, Double distributionOrderPrice); @Update("UPDATE li_distribution set commission_frozen = (IFNULL(commission_frozen,0)+#{commissionFrozen}) " + ", rebate_total=(IFNULL(rebate_total,0)+#{commissionFrozen}) " + ", distribution_order_price=(IFNULL(distribution_order_price,0)+#{distributionOrderPrice}) " + ", distribution_order_count=(IFNULL(distribution_order_count,0)+1) " + " WHERE id = #{distributionId}") void addRebate(Double commissionFrozen, String distributionId, Double distributionOrderPrice); @Update("UPDATE li_distribution SET commission_frozen = (IFNULL(commission_frozen,0) - #{rebate}) " + ",can_rebate=(IFNULL(can_rebate,0) + #{rebate}) " + " WHERE id = #{distributionId}") void addCanRebate(Double rebate, String distributionId); @Update("UPDATE li_distribution SET can_rebate=(IFNULL(can_rebate,0) - #{rebate}),cash_rebate=(IFNULL(cash_rebate,0) + #{rebate}) " + " WHERE id = #{distributionId}") void addCashRebate(Double rebate, String distributionId); @Update("UPDATE li_distribution SET cash_rebate=(IFNULL(cash_rebate,0) - #{rebate}) " + " WHERE id = #{distributionId}") void subCashRebate(Double rebate, String distributionId); }