public function get($id = null) { $search = Input::get('search'); if (!is_null($search)) { $adjustments = Adjustment::select('adjustments.*')->join('products', 'products.id', '=', 'adjustments.products_id')->where('products.name', 'like', '%' . $search . '%')->orwhere('products.code', 'like', '%' . $search . '%')->orderBy('adjustments.created_at')->paginate(15); } else { $adjustments = Adjustment::latest()->paginate(15); } $selectedAdjustment = self::__checkExistence($id); if (!$selectedAdjustment) { $selectedAdjustment = new Adjustment(); } $products = Product::all()->lists('name', 'id'); return View::make('adjustments.main')->with('id', $id)->with('products', $products)->with('search', $search)->with('selectedAdjustment', $selectedAdjustment)->with('adjustments', $adjustments); }