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"></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%");
});//模糊查询物料名称和物料编号
}
