package models

import (
	"time"

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

type AchievementProvider struct {
	Id             int64     `orm:"column(id);pk" description:"主键id"`
	AchievementId  int64     `orm:"column(achievement_id);null" description:"表achievement.id"`
	UserCompanyId  int64     `orm:"column(user_company_id);null" description:"user_company.id"`
	UserGraspScore float64   `orm:"column(user_grasp_score);null;digits(4);decimals(1)" description:"把握人得分"`
	CreateAt       time.Time `orm:"column(create_at);type(timestamp);null" description:"创建时间"`
}

func (t *AchievementProvider) TableName() string {
	return "achievement_provider"
}

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

// GetAchievementProviderById retrieves AchievementProvider by Id. Returns error if
// Id doesn't exist
func GetAchievementProviderById(id int64) (v *AchievementProvider, err error) {
	o := orm.NewOrm()
	v = &AchievementProvider{Id: id}
	if err = o.Read(v); err == nil {
		return v, nil
	}
	return nil, err
}

//查询成果提供者列表
func GetAchievementProviders(achievementId int64) (v []*AchievementProvider, err error) {
	o := orm.NewOrm()
	sql := "select * from achievement_provider where achievement_id=?"
	if _, err = o.Raw(sql, achievementId).QueryRows(&v); err == nil {
		return v, nil
	}
	return nil, err
}