hongze_yb/models/tables/sandbox/query.go

package sandbox

import (
	"hongze/hongze_yb/global"
)

// GetBySandboxId 根据沙盘ID查询详情
func GetBySandboxId(id uint32) (item *Sandbox, err error) {
	err = global.DEFAULT_MYSQL.Where("sandbox_id = ? and is_delete=0 ", id).Order("sandbox_id desc").First(&item).Error
	return
}

// GetPageListByWhere 分页获取活动列表
func GetPageListByWhere(condition string, pars []interface{}, startSize, pageSize int) (total int64, list []*Sandbox, err error) {
	// 获取查询总数量
	err = global.DEFAULT_MYSQL.Model(Sandbox{}).Where(condition, pars...).Count(&total).Error
	if err != nil {
		return
	}

	// 获取列表数据
	err = global.DEFAULT_MYSQL.Model(Sandbox{}).Where(condition, pars...).Order("modify_time desc,sandbox_id desc").Offset(startSize).Limit(pageSize).Find(&list).Error
	return
}