public function getAdjustmentAmounts(Request $request) { $workspace_id = Auth::user()->workspace_id; $account = $request->input('account'); $year_str = strtotime(date('Y')); if ($account == 25000) { $purchaseDetail = PurchaseDetail::where(['status' => 1], ['created_at', '>', $year_str])->get(['unit_price', 'quantity']); $total_amount = 0; $total_quantity = 0; foreach ($purchaseDetail as $detail) { $total_amount += $detail->quantity * $detail->unit_price; $total_quantity += $detail->quantity; } $unit_price = $total_amount / $total_quantity; $stocks = RawStock::where('status', 1)->sum('quantity'); $remaining_amount = $stocks * $unit_price; $return = new stdClass(); $return->total_amount = $total_amount; $return->remaining_amount = $remaining_amount; return response()->json($return); } elseif ($account == 27000) { $supply_amount = TransactionRecorder::where(['workspace_id' => $workspace_id, 'account_code' => $account, 'status' => 1, 'year' => date('Y')])->sum('total_amount'); return response()->json($supply_amount); } }