package cygx

import (
	"github.com/beego/beego/v2/client/orm"
	"time"
)

// ActivityVoice 活动语音表结构体
type CygxActivityVoice struct {
	ActivityVoiceId  int       `orm:"column(activity_voice_id);pk" description:"活动音频ID"`
	ActivityId       int       ` description:"活动ID"`
	VoiceUrl         string    `description:"音频地址"`
	VoiceName        string    `description:"音频名称"`
	VoicePlaySeconds string    `description:"音频时长"`
	CreateTime       time.Time `description:"创建时间"`
}

// ActivityVoiceReq 音频数据
type CygxActivityVoiceReq struct {
	Url             string `description:"音频资源url地址"`
	Name            string `description:"音频名称"`
	PlaySeconds     string `description:"音频时长"`
	ActivityVoiceId int    `description:"活动音频ID"`
}

// 列表
func GetCygxActivityVoiceReqList(activityId int) (items []*CygxActivityVoiceReq, err error) {
	o := orm.NewOrm()
	sql := `SELECT 
			activity_voice_id,
			voice_url AS url,
			voice_name AS name,
			voice_play_seconds AS play_seconds  FROM cygx_activity_voice  WHERE activity_id= ? `
	_, err = o.Raw(sql, activityId).QueryRows(&items)
	return
}

// 列表
func GetActivityVoiceList(condition string, pars []interface{}) (items []*CygxActivityVoice, err error) {
	o := orm.NewOrm()
	sql := ` SELECT  * FROM  cygx_activity_voice  WHERE  1=1  `
	if condition != "" {
		sql += condition
	}
	_, err = o.Raw(sql, pars).QueryRows(&items)
	return
}

func GetCygxActivityVoiceReqDetail(activityId int) (item *CygxActivityVoice, err error) {
	o := orm.NewOrm()
	sql := `SELECT *  FROM cygx_activity_voice  WHERE activity_id= ? `
	err = o.Raw(sql, activityId).QueryRow(&item)
	return
}