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