chance_data.go 1.4 KB
package models

import (
	"time"

	"github.com/astaxie/beego/orm"
)

type ChanceData struct {
	Id       int64     `orm:"column(id);pk" description:"唯一编号"`
	ChanceId int64     `orm:"column(chance_id);null" description:"表chance.id 机会编号"`
	Images   string    `orm:"column(images);null" description:"图片 json"`
	Speechs  string    `orm:"column(speechs);null" description:"语音 json"`
	Videos   string    `orm:"column(videos);null" description:"视频 json"`
	CreateAt time.Time `orm:"column(create_at);type(timestamp);null" description:"创建时间"`
	UpdateAt time.Time `orm:"column(update_at);type(timestamp);null" description:"更新时间"`
}

func (t *ChanceData) TableName() string {
	return "chance_data"
}

func init() {
	orm.RegisterModel(new(ChanceData))
}

type ChanceDataImage struct {
	Path string `json:"path"`
	W    int    `json:"w"`
	H    int    `json:"h"`
}

type ChanceDataSpeechs struct {
	Path     string `json:"path"`
	Duration int    `json:"duration"`
}

type ChanceDataVideos struct {
	Path     string          `json:"path"`
	Cover    ChanceDataImage `json:"cover"`
	Duration int             `json:"duration"`
}

func GetChanceDataByChanceId(chanceid int64) (v *ChanceData, err error) {
	o := orm.NewOrm()
	v = &ChanceData{}
	err = o.QueryTable(v).Filter("chance_id", chanceid).One(v)
	if err == nil {
		return v, nil
	}
	return nil, err
}