如何使用laravel/php手动映射采集并获取总金额

php artisan make:model Transaction

use App\Models\Transaction;

class TransactionController extends Controller
{
    public function getTotalAmount()
    {
        // 获取所有交易记录
        $transactions = Transaction::all();

        // 计算总金额
        $totalAmount = $transactions->sum('amount');

        return response()->json([
            'total_amount' => $totalAmount,
        ]);
    }
}

use Illuminate\Support\Facades\DB;

class TransactionController extends Controller
{
    public function getTotalAmount()
    {
        // 获取所有交易记录
        $transactions = DB::table('transactions')->get();

        // 计算总金额
        $totalAmount = $transactions->sum('amount');

        return response()->json([
            'total_amount' => $totalAmount,
        ]);
    }
}

use Illuminate\Support\Facades\DB;

class TransactionController extends Controller
{
    public function getTotalAmount()
    {
        // 直接在数据库中计算总金额
        $totalAmount = DB::table('transactions')->sum('amount');

        return response()->json([
            'total_amount' => $totalAmount,
        ]);
    }
}

use App\Http\Controllers\TransactionController;

Route::get('/total-amount', [TransactionController::class, 'getTotalAmount']);

php artisan make:controller TransactionController

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

class TransactionController extends Controller
{
    public function getTotalAmount()
    {
        // 直接在数据库中计算总金额
        $totalAmount = DB::table('transactions')->sum('amount');

        return response()->json([
            'total_amount' => $totalAmount,
        ]);
    }
}

http://your-domain.com/total-amount

{
    "total_amount": 150.00
}