hackerESQ
36 lines
1.1 KiB
PHP
36 lines
1.1 KiB
PHP
<?php
|
|
|
|
declare(strict_types=1);
|
|
|
|
namespace App\Actions;
|
|
|
|
use App\Models\Transaction;
|
|
use Illuminate\Database\Eloquent\Model;
|
|
|
|
class EnsureCostBasisAddedToSale
|
|
{
|
|
public function __invoke(Model $model, callable $next)
|
|
{
|
|
// cost basis is required for sales to calculate realized gains
|
|
if ($model->transaction_type == 'SELL') {
|
|
|
|
$cost_basis = Transaction::where([
|
|
'portfolio_id' => $model->portfolio_id,
|
|
'symbol' => $model->symbol,
|
|
'transaction_type' => 'BUY',
|
|
])->whereDate('date', '<=', $model->date)
|
|
->selectRaw('SUM(transactions.cost_basis * transactions.quantity) as total_cost_basis')
|
|
->selectRaw('SUM(transactions.quantity) as total_quantity')
|
|
->first();
|
|
|
|
$average_cost_basis = empty($cost_basis->total_quantity)
|
|
? 0
|
|
: $cost_basis->total_cost_basis / $cost_basis->total_quantity;
|
|
|
|
$model->cost_basis = $average_cost_basis ?? 0;
|
|
}
|
|
|
|
return $next($model);
|
|
}
|
|
}
|