public function search()
{
$input = Request::all();
$query = $input['query'];
$item = Item::where('name', 'LIKE', "%{$query}%")->get();
$supplier = Supplier::where('name', 'LIKE', "%{$query}%")->get();
$price_logs = PriceLog::join('suppliers', 'price_logs.supplier_id', '=', 'suppliers.id')->join('items', 'price_logs.item_id', '=', 'items.id')->where('suppliers.name', 'LIKE', "%{$query}%")->orWhere('items.name', 'LIKE', "%{$query}%")->orderBy('price_logs.id', 'desc')->paginate(10);
if ($price_logs == "[]") {
//flash()->error('There are no clients that match your query.');
return redirect()->action('PriceLogsController@index');
}
$price_logs->appends(Request::only('query'));
return view('price_logs.index', compact('price_logs'));
}
