UserSign.php 940 B

123456789101112131415161718192021222324252627282930313233343536373839
  1. <?php
  2. namespace App\Modules\User\Models;
  3. use Illuminate\Database\Eloquent\Model;
  4. class UserSign extends Model
  5. {
  6. protected $table = 'user_sign';
  7. protected $fillable = ['uid','price','day','sign_time'];
  8. /**
  9. * 用户是否已签到
  10. * @param $uid
  11. * @param $day
  12. * @return mixed
  13. */
  14. public static function isSign($uid,$day){
  15. return self::where('uid',$uid)->where('day',$day)->first();
  16. }
  17. /**
  18. * 签到
  19. * @param $uid
  20. * @param $day
  21. * @return mixed
  22. */
  23. public static function sign($uid,$day,$fee){
  24. $data = ['uid'=>$uid,'price'=>$fee,'day'=>$day,'sign_time'=>time()];
  25. return self::create($data);
  26. }
  27. /**
  28. * 用户签到记录
  29. */
  30. public static function getUserSignRecord($uid){
  31. return self::where('uid',$uid)->where('day','<',date('Y-m-d'))->select('price','sign_time')->orderBy('sign_time','desc')->paginate();
  32. }
  33. }