NN2022100801/app/Modes/UserWithdraw.php

<?php

namespace App\Modes;

use Illuminate\Database\Eloquent\Model;

/**
 * App\Modes\UserWithdraw
 *
 * @property int $id
 * @property int $uid 用户ID
 * @property int $money 提现金额
 * @property int $phone 预留联系号码
 * @property string $bank_name 银行名称
 * @property string $bank_number 银行账号
 * @property float $service_charge 手续费
 * @property int $status 类型 0-提交 1-审核通过 2-审核拒绝
 * @property string|null $remark 备注
 * @property int $audit_uid 审核用户
 * @property string|null $audit_at 审核时间
 * @property string|null $audit_remark 审核备注信息
 * @property \Illuminate\Support\Carbon $created_at
 * @property \Illuminate\Support\Carbon $updated_at
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserWithdraw newModelQuery()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserWithdraw newQuery()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserWithdraw query()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserWithdraw whereAuditAt($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserWithdraw whereAuditRemark($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserWithdraw whereAuditUid($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserWithdraw whereBankName($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserWithdraw whereBankNumber($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserWithdraw whereCreatedAt($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserWithdraw whereId($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserWithdraw whereMoney($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserWithdraw wherePhone($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserWithdraw whereRemark($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserWithdraw whereServiceCharge($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserWithdraw whereStatus($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserWithdraw whereUid($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserWithdraw whereUpdatedAt($value)
 * @mixin \Eloquent
 * @property-read \App\Modes\User $User
 */
class UserWithdraw extends Model
{
    protected $table = 'user_withdraw';

    public static function getList(array $where, $field = [], $userField = [])
    {
        $userField = array_merge(['u.id', 'u.mobile', 'u.nick_name', 'u.real_name'], $userField);
        $field = array_merge(['uw.id', 'uw.uid', 'uw.status', 'uw.created_at'], $field);

        $model = \DB::table('user_withdraw as uw')
            ->join('user as u', 'u.id', '=', 'uw.uid')
            ->where($where)
            ->groupBy('uw.id')
            ->select(array_merge($userField, $field));

        if (\Auth::user()->is_super == 3) {
            $model = $model->whereIn('uid', getIds());
        }

        $res = $model->paginate(perPage());

        return $res;
    }


    public function User()
    {
        return $this->hasOne('App\Modes\User', 'id', 'uid');
    }
}