/** * Display a listing of the resource. * * @param Request $request * @return $this */ public function index(Request $request) { $recipes = new Recipe(); if ($request->exists('ingredient')) { foreach ($request->get('ingredient') as $ingredientId) { $recipes = $recipes->leftJoin('recipe_ingredients AS ri' . $ingredientId, '.recipes.id', '=', 'ri' . $ingredientId . '.recipe_id'); $recipes = $recipes->where('ri' . $ingredientId . '.ingredient_id', '=', $ingredientId); } } $recipes = $recipes->groupBy('recipes.id')->orderBy('created_at', 'DESC')->get(); $ingredients = Ingredient::orderBy('name')->get(); return view('recipes.index')->with(compact('recipes', 'ingredients')); }
public function getTest() { $ingredients = \App\Ingredient::orderBy('name')->get(); return view('test')->with('ingredients', $ingredients); }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { $ingredient = Auth::user()->ingredients->find($id); $ingredients = Ingredient::orderBy('name')->get(); return view('supplies.edit')->with(['the_ingredient' => $ingredient, 'ingredients' => $ingredients]); }