/** * @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' => []]); } }
/** * @param $dist_id * @param Request $request * @return \Illuminate\Http\JsonResponse */ public function deleteDistributor($dist_id) { $dist = Distributor::where('id', $dist_id); $products = Product::where('distributor_id', '=', $dist_id); if ($products->count()) { return response()->json(['deleted' => false, 'products' => true]); } else { if ($dist->delete()) { return response()->json(['deleted' => true, 'products' => false]); } return response()->json(['deleted' => false]); } }
/** * @param Request $request * @return \Illuminate\Http\JsonResponse */ public function updateProduct($id, Request $request) { $name = $request->input('name'); $type = $request->input('type'); $dist_id = $request->input('dist_id'); $update = Product::where('id', $id)->update(['name' => $name, 'type' => $type, 'distributor_id' => $dist_id]); $dist_name = Distributor::where('id', '=', $dist_id)->get(); if ($dist_name->count()) { $dist_name = $dist_name->first()->name; } if ($update) { return response()->json(['updated' => true, 'dist_name' => $dist_name]); } }