如何在Laravel中获取表中每条记录的多列两个单元格的总和

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class ExampleModel extends Model
{
    // 定义表名
    protected $table = 'your_table_name';

    // 定义方法来计算两个单元格的总和
    public function calculateSum()
    {
        // 使用Laravel的查询构建器来获取表中每条记录的两个单元格的总和
        $sum = $this->selectRaw('column1 + column2 as total')->get();

        return $sum;
    }
}

<?php

namespace App\Http\Controllers;

use App\ExampleModel;

class ExampleController extends Controller
{
    public function getSum()
    {
        // 创建模型实例
        $model = new ExampleModel();

        // 调用模型方法获取总和
        $sum = $model->calculateSum();

        return $sum;
    }
}

Route::get('/sum', 'ExampleController@getSum');