public function overview() { $compositions = Composition::all(); return view('cms/composition/overview')->with('items', $compositions); }
public function search() { $searchNeedle = Input::get("search"); $foundProducts = Product::where('title', 'LIKE', "%{$searchNeedle}%")->get(); $productIds = []; foreach ($foundProducts as $item) { $productIds[] = $item->id; } $pivotResults = DB::table('comp_product')->whereIn("product_id", $productIds)->get(); $compositionIds = []; foreach ($pivotResults as $item) { $compositionIds[] = $item->composition_id; } $foundCompositions = Composition::whereIn("id", $compositionIds)->get(); $response = ["products" => $foundProducts, "compositions" => $foundCompositions]; return $response; }