yhlxj/netflix-dao/src/main/java/com/cyksj/mapper/GoodsDonMapper.java

package com.cyksj.mapper;

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

import java.math.BigDecimal;

/**
 * @author chan
 * @date 2022/9/27 5:31 PM
 */
public interface GoodsDonMapper extends BaseMapper<GoodsDon> {

	@Select("select gdk.price from goods_don gd left join goods_don_sku gdk on gdk.goods_id = gd.id" +
			" where gd.id = #{goodsId} and gd.deleted is true" +
			" and gd.status is true and gd.type = 2" +
			" order by gdk.price limit 1")
	BigDecimal selectMinPriceSkuByGoodsId(Long goodsId);
}