token.go 6.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218
  1. package model
  2. import (
  3. "errors"
  4. "fmt"
  5. _ "gorm.io/driver/sqlite"
  6. "gorm.io/gorm"
  7. "one-api/common"
  8. )
  9. type Token struct {
  10. Id int `json:"id"`
  11. UserId int `json:"user_id"`
  12. Key string `json:"key" gorm:"type:char(48);uniqueIndex"`
  13. Status int `json:"status" gorm:"default:1"`
  14. Name string `json:"name" gorm:"index" `
  15. CreatedTime int64 `json:"created_time" gorm:"bigint"`
  16. AccessedTime int64 `json:"accessed_time" gorm:"bigint"`
  17. ExpiredTime int64 `json:"expired_time" gorm:"bigint;default:-1"` // -1 means never expired
  18. RemainQuota int `json:"remain_quota" gorm:"default:0"`
  19. UnlimitedQuota bool `json:"unlimited_quota" gorm:"default:false"`
  20. }
  21. func GetAllUserTokens(userId int, startIdx int, num int) ([]*Token, error) {
  22. var tokens []*Token
  23. var err error
  24. err = DB.Where("user_id = ?", userId).Order("id desc").Limit(num).Offset(startIdx).Find(&tokens).Error
  25. return tokens, err
  26. }
  27. func SearchUserTokens(userId int, keyword string) (tokens []*Token, err error) {
  28. err = DB.Where("user_id = ?", userId).Where("id = ? or name LIKE ?", keyword, keyword+"%").Find(&tokens).Error
  29. return tokens, err
  30. }
  31. func ValidateUserToken(key string) (token *Token, err error) {
  32. if key == "" {
  33. return nil, errors.New("未提供 token")
  34. }
  35. token = &Token{}
  36. err = DB.Where("`key` = ?", key).First(token).Error
  37. if err == nil {
  38. if token.Status != common.TokenStatusEnabled {
  39. return nil, errors.New("该 token 状态不可用")
  40. }
  41. if token.ExpiredTime != -1 && token.ExpiredTime < common.GetTimestamp() {
  42. token.Status = common.TokenStatusExpired
  43. err := token.SelectUpdate()
  44. if err != nil {
  45. common.SysError("更新 token 状态失败:" + err.Error())
  46. }
  47. return nil, errors.New("该 token 已过期")
  48. }
  49. if !token.UnlimitedQuota && token.RemainQuota <= 0 {
  50. token.Status = common.TokenStatusExhausted
  51. err := token.SelectUpdate()
  52. if err != nil {
  53. common.SysError("更新 token 状态失败:" + err.Error())
  54. }
  55. return nil, errors.New("该 token 额度已用尽")
  56. }
  57. go func() {
  58. token.AccessedTime = common.GetTimestamp()
  59. err := token.SelectUpdate()
  60. if err != nil {
  61. common.SysError("更新 token 失败:" + err.Error())
  62. }
  63. }()
  64. return token, nil
  65. }
  66. return nil, errors.New("无效的 token")
  67. }
  68. func GetTokenByIds(id int, userId int) (*Token, error) {
  69. if id == 0 || userId == 0 {
  70. return nil, errors.New("id 或 userId 为空!")
  71. }
  72. token := Token{Id: id, UserId: userId}
  73. var err error = nil
  74. err = DB.First(&token, "id = ? and user_id = ?", id, userId).Error
  75. return &token, err
  76. }
  77. func GetTokenById(id int) (*Token, error) {
  78. if id == 0 {
  79. return nil, errors.New("id 为空!")
  80. }
  81. token := Token{Id: id}
  82. var err error = nil
  83. err = DB.First(&token, "id = ?", id).Error
  84. return &token, err
  85. }
  86. func (token *Token) Insert() error {
  87. var err error
  88. err = DB.Create(token).Error
  89. return err
  90. }
  91. // Update Make sure your token's fields is completed, because this will update non-zero values
  92. func (token *Token) Update() error {
  93. var err error
  94. err = DB.Model(token).Select("name", "status", "expired_time", "remain_quota", "unlimited_quota").Updates(token).Error
  95. return err
  96. }
  97. func (token *Token) SelectUpdate() error {
  98. // This can update zero values
  99. return DB.Model(token).Select("accessed_time", "status").Updates(token).Error
  100. }
  101. func (token *Token) Delete() error {
  102. var err error
  103. err = DB.Delete(token).Error
  104. return err
  105. }
  106. func DeleteTokenById(id int, userId int) (err error) {
  107. // Why we need userId here? In case user want to delete other's token.
  108. if id == 0 || userId == 0 {
  109. return errors.New("id 或 userId 为空!")
  110. }
  111. token := Token{Id: id, UserId: userId}
  112. err = DB.Where(token).First(&token).Error
  113. if err != nil {
  114. return err
  115. }
  116. return token.Delete()
  117. }
  118. func IncreaseTokenQuota(id int, quota int) (err error) {
  119. if quota < 0 {
  120. return errors.New("quota 不能为负数!")
  121. }
  122. err = DB.Model(&Token{}).Where("id = ?", id).Update("remain_quota", gorm.Expr("remain_quota + ?", quota)).Error
  123. return err
  124. }
  125. func DecreaseTokenQuota(id int, quota int) (err error) {
  126. if quota < 0 {
  127. return errors.New("quota 不能为负数!")
  128. }
  129. err = DB.Model(&Token{}).Where("id = ?", id).Update("remain_quota", gorm.Expr("remain_quota - ?", quota)).Error
  130. return err
  131. }
  132. func PreConsumeTokenQuota(tokenId int, quota int) (err error) {
  133. if quota < 0 {
  134. return errors.New("quota 不能为负数!")
  135. }
  136. token, err := GetTokenById(tokenId)
  137. if err != nil {
  138. return err
  139. }
  140. if !token.UnlimitedQuota && token.RemainQuota < quota {
  141. return errors.New("令牌额度不足")
  142. }
  143. userQuota, err := GetUserQuota(token.UserId)
  144. if err != nil {
  145. return err
  146. }
  147. if userQuota < quota {
  148. return errors.New("用户额度不足")
  149. }
  150. quotaTooLow := userQuota >= common.QuotaRemindThreshold && userQuota-quota < common.QuotaRemindThreshold
  151. noMoreQuota := userQuota-quota <= 0
  152. if quotaTooLow || noMoreQuota {
  153. go func() {
  154. email, err := GetUserEmail(token.UserId)
  155. if err != nil {
  156. common.SysError("获取用户邮箱失败:" + err.Error())
  157. }
  158. prompt := "您的额度即将用尽"
  159. if noMoreQuota {
  160. prompt = "您的额度已用尽"
  161. }
  162. if email != "" {
  163. topUpLink := fmt.Sprintf("%s/topup", common.ServerAddress)
  164. err = common.SendEmail(prompt, email,
  165. fmt.Sprintf("%s,当前剩余额度为 %d,为了不影响您的使用,请及时充值。<br/>充值链接:<a href='%s'>%s</a>", prompt, userQuota, topUpLink, topUpLink))
  166. if err != nil {
  167. common.SysError("发送邮件失败:" + err.Error())
  168. }
  169. }
  170. }()
  171. }
  172. if !token.UnlimitedQuota {
  173. err = DecreaseTokenQuota(tokenId, quota)
  174. if err != nil {
  175. return err
  176. }
  177. }
  178. err = DecreaseUserQuota(token.UserId, quota)
  179. return err
  180. }
  181. func PostConsumeTokenQuota(tokenId int, quota int) (err error) {
  182. token, err := GetTokenById(tokenId)
  183. if quota > 0 {
  184. err = DecreaseUserQuota(token.UserId, quota)
  185. } else {
  186. err = IncreaseUserQuota(token.UserId, -quota)
  187. }
  188. if err != nil {
  189. return err
  190. }
  191. if !token.UnlimitedQuota {
  192. if quota > 0 {
  193. err = DecreaseTokenQuota(tokenId, quota)
  194. } else {
  195. err = IncreaseTokenQuota(tokenId, -quota)
  196. }
  197. if err != nil {
  198. return err
  199. }
  200. }
  201. return nil
  202. }