all(); $page_size=$input['page_size']; $page_index=$input['page_index']; $num = ($page_index - 1) * $page_size; $search_name=$input['search_name']; $where=[]; switch($input['type']){ case '0': $where['status']=0; break; case '1': $where['status']=1; break; case '2': $where['status']=2; break; } $count=Audit::with(['user:id,nickname,level,mobile']) ->whereHas('user', function (Builder $query) use ($search_name){ $query->where('nickname', 'like', '%' . $search_name . '%') ->orWhere('mobile', 'like', '%' . $search_name . '%'); }) ->where($where) ->count(); if($count==0){ $this->error('400001','没有数据'); } $list=Audit::with(['user:id,nickname,level,mobile']) ->whereHas('user', function (Builder $query) use ($search_name){ $query->where('nickname', 'like', '%' . $search_name . '%') ->orWhere('mobile', 'like', '%' . $search_name . '%'); }) ->where($where) ->orderBy('id','desc') ->skip($num)->take($page_size) ->get(); if(empty($list)){ return $this->error('400002','没有获取到数据'); } return $this->success_list($list,'success',$count); } /*升级审核*/ public function updateAgentStatus(Request $request){ $input=$request->all(); $audit=Audit::find($input['id']); $user=User::find($audit->user_id); DB::beginTransaction(); try{ if($input['type']==1){ if($user->level==3){ return $this->error('400004','皇冠不能升级'); } if($user->recom_id==1){ return $this->error('400116','邀请人为公司的代理不能变更等级'); } $recom = User::find($user->recom_id);//邀请人信息 if (empty($recom)) { return $this->error('400115', '代理邀请人信息不存在,升降级失败'); } $level=$user->level+1; $audit->status=1; $uuu=new User(); $row=$audit->save(); $result=$uuu->changeAgentLevel($user,$level); }elseif($input['type']==2){ $audit->status=2; $row=$audit->save(); }else{ return $this->error('400004','状态码有误'); } DB::commit(); Log::info('管理员:'.Auth::user()->name.'(id='.Auth::user()->id.')完成用户升级审核,用户id='.$audit->user_id); return $this->success([]); }catch(Exception $e){ DB::rollBack(); return $this->error(); } } }