eta_mini_api/models/msg_code.go

package models

import (
	"time"

	"github.com/beego/beego/v2/client/orm"
)

// MsgCode 验证码列表
type MsgCode struct {
	MsgCodeId  int64     `orm:"pk"`
	OpenId     string    `description:"用户open_id"`
	Mobile     string    `description:"手机号"`
	Code       string    `description:"验证码"`
	ApiResult  string    `description:"短信API请求结果"`
	ExpiredIn  int64     `description:"过期时间"`
	CreateTime time.Time `description:"创建时间"`
}

func (m *MsgCode) Insert() (err error) {
	o := orm.NewOrm()
	_, err = o.Insert(m)
	return
}

func GetMsgCode(mobile, code string) (item *MsgCode, err error) {
	o := orm.NewOrm()
	sql := `SELECT * FROM msg_code WHERE mobile = ? AND code = ? AND FROM_UNIXTIME(expired_in)>=NOW() `
	err = o.Raw(sql, mobile, code).QueryRow(&item)
	return
}