/** * Metodo para hacer la busqueda */ public static function search(Request $request) { $items = array(); $search = ''; if ($request->input('search')) { $search = $request->input('search'); $arrparam = explode(' ', $search); $items = Activity::whereNested(function ($q) use($arrparam) { $p = $arrparam[0]; $q->whereNested(function ($q) use($p) { $q->where('id', 'LIKE', '%' . $p . '%'); $q->orwhere('name', 'LIKE', '%' . $p . '%'); $q->orwhere('reference', 'LIKE', '%' . $p . '%'); $q->orwhere('enable', 'LIKE', '%' . $p . '%'); }); $c = count($arrparam); if ($c > 1) { for ($i = 1; $i < $c; $i++) { $p = $arrparam[$i]; $q->whereNested(function ($q) use($p) { $q->where('id', 'LIKE', '%' . $p . '%'); $q->orwhere('name', 'LIKE', '%' . $p . '%'); $q->orwhere('reference', 'LIKE', '%' . $p . '%'); $q->orwhere('enable', 'LIKE', '%' . $p . '%'); }, 'OR'); } } })->whereNull('deleted_at')->orderBy('name', 'ASC')->paginate(10); return View::make('admin.activity.view_activity', compact('items', 'search')); } }