方法Illuminate\Support\Collection::或Where不存在

Question

我正在尝试连接两个表，并在其中进行搜索，并在视图中的表中显示它们的结果。我在这条线上有一个错误：$query->orWhere($field, 'like', '%'.$search.'%');

在我的控制器的这个搜索方法中：

public function search3(Request $request)
{
$query = DB::table('users')
->join('proforms', 'users.id', '=', 'proforms.user_id')
->get();

$search = $request->get('search');
$requestData = ['showname'];

/* $query = Proform::query(); */
foreach ($requestData as $field){
$query->orWhere($field, 'like', '%'.$search.'%');
}
$data2=$query->paginate(5);
return view('proforms.index', ['proforms' => $data2])->with('i', ($request->input('page', 1) - 1) * 5);
}

此错误发生在单击此视图上的搜索按钮之后：

@extends('layouts.app')

@section('content')
<div class="row">
<div class="col-lg-12 margin-tb">
<div class="pull-left">
<h2>Zarządzanie proformami</h2>
</div>

<div class="col-md-4">
<form action="/search3" method="get">
<div class="input-group">
<input type="search" name="search" class="form-control">
<span class="input-group-prepend">
<button type="submit" class="btn btn-primary">Wyszukaj</button>
</span>
</div>
</form>
</div>           
<div class="pull-right">
@can('product-create')
<a class="btn btn-success" href="{{ route('proforms.create') }}"> Utwórz nową proformę</a>
@endcan
</div>
</div>
</div>

@if ($message = Session::get('success'))
<div class="alert alert-success">
<p>{{ $message }}</p>
</div>
@endif

<table class="table table-bordered">
<tr>
<th scope="col">@sortablelink('id', 'Numer')</th>
<th scope="col">@sortablelink('proformnumber', 'Numer proformy')</th>
<th scope="col">@sortablelink('user_id', 'Kontrachent')</th>
<th scope="col">@sortablelink('proformdate', 'Data wystawienia')</th>
<th scope="col">@sortablelink('selldate', 'Data sprzedaży')</th>
<th scope="col">@sortablelink('paymentdate', 'Termin płatności')</th> 
<th scope="col">@sortablelink('status', 'Status')</th> 
<th scope="col">@sortablelink('nettotal', 'Netto razem')</th>
<th scope="col">@sortablelink('grosstotal', 'Brutto razem')</th>              
<th width="280px">Akcja</th>
</tr>
@foreach ($proforms as $proform)
<tr>
<td>{{ ++$i }}</td>
<td>{{ $proform->proformnumber }}</td>
<td>{{ $proform->user->showname }}</td>
<td>{{ $proform->proformdate }}</td>
<td>{{ $proform->selldate }}</td>
<td>{{ $proform->paymentdate }}</td>
<td>{{ $proform->status }}</td>
<td>{{ $proform->nettotal }}</td>
<td>{{ $proform->grosstotal }}</td>
<td>
<form action="{{ route('proforms.destroy',$proform->id) }}" method="POST">
<a class="btn btn-info" href="{{ route('proforms.show',$proform->id) }}">Więcej</a>
@can('product-edit')
<a class="btn btn-primary" href="{{ route('proforms.edit',$proform->id) }}">Edytu</a>
@endcan

@csrf
@method('DELETE')
@can('product-delete')
<button type="submit" class="btn btn-danger">Usuń</button>
@endcan
</form>
</td>
</tr>
@endforeach
</table>
{!! $proforms ?? ''->appends(request()->except('page'))->render() !!}


<p class="text-center text-primary"><small>ARTplus 2020</small></p>
@endsection

这是我的路线：

Auth::routes();

Route::get('/home', 'HomeController@index')->name('home');

Route::group(['middleware' => ['auth']], function () {
Route::resource('roles', 'RoleController');
Route::resource('users', 'UserController');
Route::resource('permissions', 'PermissionController');
Route::resource('products', 'ProductController');
Route::resource('invoices', 'InvoiceController');
Route::resource('category', 'CategoryController');
Route::resource('invoices', 'InvoiceController');
Route::resource('proforms', 'ProformController');
Route::get('/search', 'UserController@search');
Route::get('/search2', 'ProductController@search2');
Route::get('/search3', 'ProformController@search3');
Route::get('data', 'UserController@index');
Route::get('posts', 'PostController@index');
Route::get('/prodview', 'TestController@prodfunct');

Answer 1

更改

$query = DB::table('users')
->join('proforms', 'users.id', '=', 'proforms.user_id')
->get();

至

$query = DB::table('users')
->join('proforms', 'users.id', '=', 'proforms.user_id');

当您对查询调用get((方法时，查询将被执行，并将返回一个Collection实例，而不是一个生成器实例。错误是因为Collection类没有orWhere方法。Builder具有该方法。因此，在查询完成时调用get((方法。