laravel 7搜索分页
前端代码1:
<form method="get" class="text-c"> 输入想要搜索的角色名称:
<input type="text" class="input-text" style="width:250px" placeholder="角色" value="{{ $name }}" name="name" autocomplete="off">
<button type="submit" class="btn btn-success radius">
<i class="Hui-iconfont">&
</button>
</form>
<tbody>
@foreach($data as $item)
<tr class="text-c">
<td>{{ $item->id }}</td>
<td>{{ $item->name }}</td>
<td>
<a class="label label-success radius" href="{{ route('admin.role.node',$item) }}">权限</a>
</td>
<td>{{ $item->created_at }}</td>
<td class="td-manage">
<a href="{{ route('admin.role.edit',$item) }}" class="label label-secondary radius">修改</a>
<a href="{{ route('admin.role.destroy',['id'=>$item->id]) }}" class="label label-warning radius">删除</a>
</td>
</tr>
@endforeach
</tbody>
</table>
{{-- 分页 支持搜索功能 --}}
{{ $data->appends(request()->except('page'))->links() }}
前端代码2:
<div class="text-c"> 日期范围:
<input type="text" onfocus="WdatePicker({ maxDate:'#F{$dp.$D(\'datemax\')||\'%y-%M-%d\'}' })" id="datemin" class="input-text Wdate" style="width:120px;">
-
<input type="text" onfocus="WdatePicker({ minDate:'#F{$dp.$D(\'datemin\')}',maxDate:'%y-%M-%d' })" id="datemax" class="input-text Wdate" style="width:120px;">
<input type="text" class="input-text" style="width:250px" placeholder="输入会员名称、电话、邮箱" id="" name="">
<button type="submit" class="btn btn-success radius" id="" name=""><i class="Hui-iconfont">&
</div>
后台代码1:
public function index(Request $request) {
$name = $request->get('name', '');
$data = Role::when($name, function ($query) use ($name) {
$query->where('name', 'like', "%{$name}%");
})->paginate(10);
return view('admin.role.index', compact('data', 'name'));
}