123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143 |
- <?php
- namespace app\model\user;
- use crmeb\basic\BaseModel;
- use crmeb\traits\ModelTrait;
- use think\model;
- class UserExtract extends BaseModel
- {
- use ModelTrait;
-
- protected $pk = 'id';
-
- protected $name = 'user_extract';
-
- const AUDIT_STATUS = 0;
-
- const FAIL_STATUS = -1;
-
- const SUCCESS_STATUS = 1;
-
- protected static $status = [
- -1 => '未通过',
- 0 => '审核中',
- 1 => '已提现',
- 2 => '待二次审核',
- ];
-
- 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 searchExtractTypeAttr($query, $value)
- {
- if ($value != '') $query->where('extract_type', $value);
- }
-
- public function searchTradeNumberAttr($query, $value)
- {
- if ($value != '') $query->where('trade_number', $value);
- }
-
- public function searchEnterpriseOrderIdAttr($query, $value)
- {
- if ($value != '') $query->where('enterprise_order_id', $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|alipay_code', 'LIKE', "%$value%")->whereOr('uid', 'in', function ($query) use ($value) {
- $query->name('user')->whereLike('nickname', '%' . $value . '%')->field('uid')->select();
- });
- });
- }
- }
- }
|