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;
}
