src/main/java/cc/mrbird/febs/mall/mapper/MallMemberWithdrawMapper.java
@@ -2,6 +2,13 @@ import cc.mrbird.febs.mall.entity.MallMemberWithdraw; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import org.apache.ibatis.annotations.Param; import java.util.Date; import java.util.List; public interface MallMemberWithdrawMapper extends BaseMapper<MallMemberWithdraw> { List<MallMemberWithdraw> selectListByMemberIdAndDate(@Param("memberId")Long memberId, @Param("date")Date date); } src/main/java/cc/mrbird/febs/mall/service/impl/MallMemberWithdrawServiceImpl.java
@@ -16,6 +16,7 @@ import cc.mrbird.febs.mall.service.IMallMemberWithdrawService; import cc.mrbird.febs.mall.service.MallMemberService; import cc.mrbird.febs.mall.vo.CashOutSettingVo; import cn.hutool.core.collection.CollUtil; import cn.hutool.core.util.ObjectUtil; import cn.hutool.core.util.StrUtil; import cn.hutool.crypto.SecureUtil; @@ -27,6 +28,8 @@ import org.springframework.transaction.annotation.Transactional; import java.math.BigDecimal; import java.util.Date; import java.util.List; /** * @author wzy @@ -64,6 +67,15 @@ cashOutSettingVo = JSONObject.parseObject(dic.getValue(), CashOutSettingVo.class); } //每日提现额度上限 BigDecimal allCashOut = cashOutSettingVo.getAllCashOut(); List<MallMemberWithdraw> mallMemberWithdrawListDone = this.baseMapper.selectListByMemberIdAndDate(memberId,new Date()); if(CollUtil.isNotEmpty(mallMemberWithdrawListDone)){ if (withdrawalDto.getAmount().compareTo(allCashOut) >= 0) { throw new FebsException("每日限额为"+cashOutSettingVo.getAllCashOut().setScale(2,BigDecimal.ROUND_DOWN)); } } if (withdrawalDto.getAmount().compareTo(cashOutSettingVo.getMinCashOut()) < 0) { throw new FebsException("最小提现金额为"+cashOutSettingVo.getMinCashOut().setScale(2,BigDecimal.ROUND_DOWN)); } src/main/resources/mapper/modules/MallMemberWithdrawMapper.xml
@@ -2,4 +2,12 @@ <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="cc.mrbird.febs.mall.mapper.MallMemberWithdrawMapper"> <select id="selectListByMemberIdAndDate" resultType="cc.mrbird.febs.mall.entity.MallMemberWithdraw"> select a.* from mall_member_withdraw a where a.member_id = #{memberId} and date_format(a.CREATED_TIME, '%Y-%m-%d') = date_format(#{date}, '%Y-%m-%d') </select> </mapper>