hongze_yb/models/tables/voice_broadcast/query.go

package voice_broadcast

import "hongze/hongze_yb/global"

func GetBroadcastByCondition(pageIndex, pageSize, sectionId int) (list []*VoiceBroadcast, err error) {
	offset := (pageIndex - 1) * pageSize
	err = global.DEFAULT_MYSQL.Model(VoiceBroadcast{}).Where("section_id=?", sectionId).Offset(offset).Limit(pageSize).Order("create_time DESC").Scan(&list).Error
	return
}

func GetBroadcastByIdAndPage(pageIndex, pageSize, broadcastId int) (list []*VoiceBroadcast, err error) {
	offset := (pageIndex - 1) * pageSize
	err = global.DEFAULT_MYSQL.Model(VoiceBroadcast{}).Where("broadcast_id=?", broadcastId).Offset(offset).Limit(pageSize).Order("create_time DESC").Scan(&list).Error
	return
}

func GetBroadcast(pageIndex, pageSize int) (list []*VoiceBroadcast, err error) {
	offset := (pageIndex - 1) * pageSize
	err = global.DEFAULT_MYSQL.Model(VoiceBroadcast{}).Offset(offset).Limit(pageSize).Order("create_time DESC").Scan(&list).Error
	return
}

func GetBroadcastById(broadcastId int) (item *VoiceBroadcast, err error) {
	err = global.DEFAULT_MYSQL.Model(VoiceBroadcast{}).Where("broadcast_id=?", broadcastId).First(&item).Error
	return
}

func GetBroadcastList() (list []*VoiceBroadcast, err error) {
	err = global.DEFAULT_MYSQL.Model(VoiceBroadcast{}).Scan(&list).Error
	return
}