123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111 |
- <?php
- namespace app\model\user;
- use crmeb\basic\BaseModel;
- use crmeb\traits\ModelTrait;
- use think\model;
- class UserExchange extends BaseModel
- {
- use ModelTrait;
-
- protected $pk = 'id';
-
- protected $name = 'user_exchange';
-
- const AUDIT_STATUS = 0;
-
- const FAIL_STATUS = -1;
-
- const SUCCESS_STATUS = 1;
-
- protected static $status = [
- -1 => '未通过',
- 0 => '审核中',
- 1 => '已提现',
- ];
-
- public function user()
- {
- return $this->hasOne(User::class, 'uid', 'uid');
- }
-
- public function searchUidAttr($query, $value)
- {
- if (is_array($value))
- $query->whereIn('uid', $value);
- else
- $query->where('uid', $value);
- }
-
- public function searchStatusAttr($query, $value)
- {
- if (is_array($value)) {
- if ($value) {
- $query->whereIn('status', $value);
- }
- }else {
- if ($value !== '') {
- $query->where('status', $value);
- }
- }
- }
-
- public function searchLikeAttr($query, $value)
- {
- if ($value) {
- $query->where(function ($query) use ($value) {
- $query->where('real_name|id|bank_code', 'LIKE', "%$value%")->whereOr('uid', 'in', function ($query) use ($value) {
- $query->name('user')->whereLike('nickname', '%' . $value . '%')->field('uid')->select();
- });
- });
- }
- }
- }
|