laravel中的查找功能

index:

  <form class="layui-form">
        <div class="layui-input-inline">
            <input type="text" class="layui-input" name="name" autocomplete="off" placeholder="物料名称"/>
        </div>
        <div class="layui-input-inline">
            <input type="text" class="layui-input" name="serial_no" autocomplete="off" placeholder="物料编号"/>
        </div>
        <div class="layui-input-inline">
            <button onclick="return filter()" class="layui-btn" lay-submit="" lay-filter="sreach">
                <span class="iconfont">&#xe60c;</span> 搜索
            </button>
        </div>
    </form>

<script>
     window.filter = function () {

                options.where.name = $('input[name=name]').val();
                options.where.serial_no = $('input[name=serial_no]').val();
                tableIns.reload(options);
                return false;

            }
</script>

控制层方法Controller:

    public function ajax_index(Request $request){

        $handle = Material::when($request->name, function ($query) use ($request) {
            return $query->where('name', 'like', "%$request->name%");
        })->when($request->serial_no, function ($query) use ($request) {
            return $query->where('serial_no', 'like', "%$request->serial_no%");
        });//模糊查询物料名称和物料编号
}