package manage import ( "demo/configs" "demo/data/domain" "demo/data/domain/vo" ) func GetGoodsIndexBannerById(id int64) (domain.GoodsIndexBanner, error) { var goodsIndexBanner domain.GoodsIndexBanner _, err := configs.Engine.Table("goods_index_banner").Where("id = ?", id).Get(&goodsIndexBanner) if err != nil { return goodsIndexBanner, err } return goodsIndexBanner, nil } func GetGoodsIndexBannerListInId(ids []int64) ([]domain.GoodsIndexBanner, error) { rows, err := configs.Engine.Table("goods_index_banner").In("id", ids).Rows(&domain.GoodsIndexBanner{}) if err != nil { return make([]domain.GoodsIndexBanner, 0), err } defer rows.Close() var list []domain.GoodsIndexBanner for rows.Next() { var u domain.GoodsIndexBanner list = append(list, u) } return list, nil } func GetGoodsIndexBannerList(goodsIndexBanner domain.GoodsIndexBanner, pageNum, pageSize int) (vo.BaseListVo, error) { var arr []domain.GoodsIndexBanner Count, err := configs.Engine.Table("goods_index_banner").Limit(pageSize, (pageNum-1)*pageSize).FindAndCount(&arr, &goodsIndexBanner) var vo vo.BaseListVo if err != nil { return vo, err } if err != nil { return vo, err } vo.PageNum = pageNum vo.PageSize = pageSize vo.List = make([]any, len(arr)) for i, v := range arr { vo.List[i] = v } vo.Total = int(Count) return vo, nil } func SaveGoodsIndexBanner(goodsIndexBanner *domain.GoodsIndexBanner) (domain.GoodsIndexBanner, error) { _, err := configs.Engine.Table("goods_index_banner").Insert(&goodsIndexBanner) if err != nil { return *goodsIndexBanner, err } return *goodsIndexBanner, nil } func SetGoodsIndexBanner(goodsIndexBannerMap map[string]interface{}, id int64) (domain.GoodsIndexBanner, bool, error) { var goodsIndexBanner domain.GoodsIndexBanner _, err := configs.Engine.Table("goods_index_banner").Where("id = ?", id).Update(goodsIndexBannerMap) if err != nil { return goodsIndexBanner, false, err } return goodsIndexBanner, true, nil } func DeleteGoodsIndexBanner(id int64) bool { var goodsIndexBanner domain.GoodsIndexBanner i, err := configs.Engine.Table("goods_index_banner").Where("id = ?", id).Delete(&goodsIndexBanner) if err != nil { return false } return i > 0 }