package dao

import (
	"demo/configs"
	"demo/data/domain"
	"demo/data/domain/vo"
)

func GetAdviceData() (vo.ShopAdviceVo, error) {
	var carousels []domain.ShopAdviceCarousel
	err := configs.Engine.Table("shop_advice_carousel").
		Where("state = 1 and show_type = 'carousel'").
		Asc("sort").
		Limit(10).Find(&carousels)
	if err != nil {
		return vo.ShopAdviceVo{}, err
	}
	sku := make([]vo.AdviceSku, 0)
	err = configs.Engine.Table("shop_advice_carousel").
		Where("state = 1 and show_type = 'package'").
		Join("INNER", "goods_sku", "shop_advice_carousel.to_id = goods_sku.id").
		Limit(6).Find(&sku)
	if err != nil {
		return vo.ShopAdviceVo{}, err
	}
	vo := vo.ShopAdviceVo{
		Carousels:   carousels,
		PackageList: sku,
	}
	return vo, err
}