VerifyCode.php 1.5 KB

12345678910111213141516171819202122232425262728293031323334353637
  1. <?php
  2. namespace App\Models;
  3. use Illuminate\Database\Eloquent\Model;
  4. /**
  5. * 注册时的激活验证码
  6. *
  7. * @property int $id
  8. * @property string $address 用户邮箱
  9. * @property string $code 验证码
  10. * @property int $status 状态:0-未使用、1-已使用、2-已失效
  11. * @property \Illuminate\Support\Carbon $created_at 创建时间
  12. * @property \Illuminate\Support\Carbon $updated_at 最后更新时间
  13. * @method static \Illuminate\Database\Eloquent\Builder|VerifyCode newModelQuery()
  14. * @method static \Illuminate\Database\Eloquent\Builder|VerifyCode newQuery()
  15. * @method static \Illuminate\Database\Eloquent\Builder|VerifyCode query()
  16. * @method static \Illuminate\Database\Eloquent\Builder|VerifyCode recentUnused()
  17. * @method static \Illuminate\Database\Eloquent\Builder|VerifyCode whereAddress($value)
  18. * @method static \Illuminate\Database\Eloquent\Builder|VerifyCode whereCode($value)
  19. * @method static \Illuminate\Database\Eloquent\Builder|VerifyCode whereCreatedAt($value)
  20. * @method static \Illuminate\Database\Eloquent\Builder|VerifyCode whereId($value)
  21. * @method static \Illuminate\Database\Eloquent\Builder|VerifyCode whereStatus($value)
  22. * @method static \Illuminate\Database\Eloquent\Builder|VerifyCode whereUpdatedAt($value)
  23. * @mixin \Eloquent
  24. */
  25. class VerifyCode extends Model
  26. {
  27. protected $table = 'verify_code';
  28. protected $guarded = [];
  29. public function scopeRecentUnused($query)
  30. {
  31. return $query->whereStatus(0)->where('created_at', '<=', date('Y-m-d H:i:s', strtotime('-15 minutes')));
  32. }
  33. }