yhlxj/netflix-dao/src/main/java/com/cyksj/mapper/manage/distribute/DistributeMoneyApplyMapper.java

package com.cyksj.mapper.manage.distribute;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.cyksj.model.entity.DistributeMoneyApply;
import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;

/*
 *项目名: netflix
 *文件名: DistributeMoneyApplyMapper
 *创建者: JavaZou
 *创建时间:2022/11/14 14:00
 */
public interface DistributeMoneyApplyMapper extends BaseMapper<DistributeMoneyApply> {

	@Select("select sum(money) from distribute_money_apply where user_id = #{cpsUserId} and verify_status = 'success' and m_type = 'sub'")
	BigDecimal getSubGotAppyMoney(long cpsUserId);
}