/** * Search all in Pembelian List * * @return Response * @author Y. Brahmantyo A.K **/ public function getShow($id) { $s = str_replace('-', '/', $id); $beli = beli::leftJoin('msupplier AS s', 's.idsupp', '=', 'beli.idsupp')->where('idbeli', 'like', '%' . $s . '%')->orWhere('idpo', 'like', '%' . $s . '%')->orWhere('tglbeli', 'like', '%' . $s . '%')->orWhere('s.nama', 'like', '%' . $s . '%')->get(); return view('admin.report.pembelian')->with('beli', $beli); }
/** * Search all in Pembelian List * * @return Response * @author Y. Brahmantyo A.K **/ public function getSearch(Request $request) { $s = $request->input('s'); $beli = beli::leftJoin('msupplier AS s', 's.idsupp', '=', 'beli.idsupp')->where('idbeli', 'like', '%' . $s . '%')->orWhere('idpo', 'like', '%' . $s . '%')->orWhere('tglbeli', 'like', '%' . $s . '%')->orWhere('s.nama', 'like', '%' . $s . '%')->paginate(\Config::get('pages'))->appends('s', $s); return view('admin.transaction.pembelian.pembelian')->with('beli', $beli); }