sange-bridge-admin/app/Http/Controllers/Api/Withdraws.php

<?php

namespace App\Http\Controllers\Api;

use App\Http\Controllers\Controller;
use App\Models\User;
use App\Models\UserWithdraw;
use Illuminate\Http\Request;

class Withdraws extends Controller
{
    public function apply()
    {
        $req = request()->post();
        $this->validate(request(), [
            'name|姓名'      => 'required',
            'account|账号'      => 'required',
        ]);

        \DB::beginTransaction();
        try
        {
            $user = auth('api')->user();

            $user = User::where('user_id',$user['id'])->first()->toArray();

            $userWithdraw = new UserWithdraw();
            UserWithdraw::create([
                'name' => $req['name'],
                'account' => $req['account'],
                'price' => $user['overage'],
                'desc' => $req['desc'],
            ]);
            $userWithdraw->save();


            $user = User::find($user['id']);
            $user->overage = 0;
            $user->save();
            // 提交事务
            \DB::commit();
        }catch (\Exception $e) {
            \DB::rollBack();
            return out(null, 10001, '提现失败!' . $e->getMessage());
        }
        return out();
    }


    // 0-待审核 1-已通过 2-已驳回 -1 全部
    public function lists()
    {
        $req = request()->all();

        $builder = UserWithdraw::orderBy('id','desc');
        if(isset($req['status']) && $req['status'] != -1){
            $builder->where('status', $req['status']);
        }
        $data = $builder->paginate($req['per_page'] ?? 15);
        $total_num = $builder->sum('id');
        $custom = collect([
            'total_num'   => $total_num,
        ]);
        $data = $custom->merge($data);
        return out($data);
    }
}