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

package com.cyksj.mapper.vip;

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

import java.util.List;

/**
 * 项目名: yhlxj2
 * 文件名: VipGoodsSkuMapper
 * 创建者: JavaZou
 * 创建时间:2025/5/13 11:06
 */
public interface VipGoodsSkuMapper extends BaseMapper<VipGoodsSku> {

	@Select("select vgs.* from vip_goods_sku vgs inner join goods_don_sku sku inner join goods_don g on g.id = sku.goods_id on sku.id = vgs.sku_id where g.status and sku.status")
	List<VipGoodsSku> selectUpSkus();
}