PointQueueLog.php 1.7 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768
  1. <?php
  2. /**
  3. * Author: 芸众商城 www.yunzshop.com
  4. * Date: 2019/3/31
  5. * Time: 9:04 PM
  6. */
  7. namespace app\common\models\finance;
  8. use app\common\models\BaseModel;
  9. use Illuminate\Database\Eloquent\Builder;
  10. use app\common\models\Member;
  11. class PointQueueLog extends BaseModel
  12. {
  13. public $table = 'yz_point_queue_log';
  14. public $timestamps = true;
  15. protected $guarded = [''];
  16. public static function getList($search)
  17. {
  18. return self::select()
  19. ->with([
  20. 'member' => function ($member) {
  21. $member->select(['uid', 'nickname', 'realname', 'avatar', 'mobile']);
  22. }
  23. ])
  24. ->search($search);
  25. }
  26. public function scopeSearch($query, $search)
  27. {
  28. if ($search['uid']) {
  29. $query->where('uid', $search['uid']);
  30. }
  31. if ($search['member']) {
  32. $query->whereHas('member', function ($member) use ($search) {
  33. $member->select('uid', 'nickname', 'realname', 'mobile', 'avatar')
  34. ->where('realname', 'like', '%' . $search['member'] . '%')
  35. ->orWhere('mobile', 'like', '%' . $search['member'] . '%')
  36. ->orWhere('nickname', 'like', '%' . $search['member'] . '%');
  37. });
  38. }
  39. return $query;
  40. }
  41. public function member()
  42. {
  43. return $this->hasOne(Member::class, 'uid', 'uid');
  44. }
  45. public static function store($data)
  46. {
  47. $model = new self();
  48. $model->fill($data);
  49. $model->save();
  50. // 消息通知 暂无
  51. }
  52. public static function boot()
  53. {
  54. parent::boot();
  55. static::addGlobalScope(function (Builder $builder) {
  56. $builder->uniacid();
  57. });
  58. }
  59. }