test_app/app/Http/Controllers/UserPayController.php

<?php

namespace App\Http\Controllers;

use App\Models\User;
use App\Models\Userpay;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Log;

class UserPayController extends Controller
{
    public function get_crown(){
        $data=User::where('level',3)->get();
        foreach ($data as $k=>$v){
            $re[$k]['nickname']=$v->nickanme.'--'.$v->mobile;
            $re[$k]['id']=$v->id;
        }
        return $this->success_list($re);
    }

    /*
     * 充值
     * */
    public function add_money(Request $request){
        $input=$request->all();
        foreach ($input['mobile'] as $k=>$v){
            $user=User::where('mobile',$v)->first();
            if (!$user){
                return $this->error(40013,'用户'.$v.'不存在');
            }
        }
        DB::beginTransaction();
        try{
            foreach ($input['mobile'] as $k=>$v){
                $user=User::where('mobile',$v)->first();
                $user->money=$user->money+$input['money'][$k];
                if (!$user->save()){
                    Log::error('充值失败'.$v);
                    throw new \Exception('1');
                }
                $userpay=new Userpay();
                $userpay->pay_money=$input['money'][$k];
                $userpay->type=0;
                $userpay->op_name=Auth::user()->name;
                $userpay->user_id=$user->id;
                $userpay->pay_num=$this->pay_num($user->id);
                if (!$userpay->save()){
                    throw new \Exception('3');
                }
                DB::commit();
                return $this->success([],'充值完成');
            }
        }catch (\Exception $exception){
            DB::rollBack();
            return $this->error(40013,'充值失败，出错用户手机号为'.$v);
        }
    }

    /*
     * */
    public function pay_num($id){
        $num=date('Ymd',time()).'100000'.str_pad($id,6,0,STR_PAD_LEFT).rand(11111,99999);
        $count=UserPay::where('pay_num',$num)->count();
        if ($count>0){
            $num=$this->pay_num($id);
            return $num;
        }
        return $num;
    }
    /*
     * 搜索
     * */

    public function search(Request $request){
//        if ($request->start==null || $request->end==null){
//            $where_time=null;
//        }else{
////            $where_time=
//        }
        $user=User::where('mobile',$request->mobile)->first();
        if ($user){
            return $this->error(40013,'查无此人');
        }
        $userpay=Userpay::where('user_id',$user->id)->orderByDesc('created_at')->paginate(15);
        return $this->success_list($userpay->items(),'',$userpay->total());
    }

    /*
     * 代理账户金额
     * */

    public function user_account(Request $request){
        $user=User::where('level',3)->paginate(15);
        return $this->success_list($user->items(),'',$user->total());
    }

    /*
     * 详情
     * */
    public function user_pay_log(Request $request){
        $userpay=Userpay::where('user_id',$request->id)->orderByDesc('created_at')->paginate(15);
        return $this->success_list($userpay->items(),'',$userpay->total());
    }
}