/** * @return \Illuminate\Http\JsonResponse */ public function stock() { $products = Product::all(); $stock = Stock::orderBy('quality', 'DESC')->get(); if ($products->count()) { $stock_count = 0; foreach ($stock as $stok) { $stock_product = Product::where('id', '=', $stok->product_id); if ($stock_product->count()) { $stock_name = $stock_product->first()->name; $stock_type = $stock_product->first()->type; $stock[$stock_count]->stock_name = $stock_name; $stock[$stock_count]->type = $stock_type; } $stock_count++; } $prod_count = 0; foreach ($products as $product) { $distributor = Distributor::where('id', '=', $product->distributor_id); if ($distributor->count()) { $distributor = $distributor->first(); $distributor_name = $distributor->name; $products[$prod_count]->distributor_name = $distributor_name; } $prod_count++; } return response()->json(['products' => $product, 'stock' => $stock]); } else { return response()->json(['products' => [], 'stock' => []]); } }