iao_team/app/Models/Record.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class Record extends Model
{
    use HasFactory;

    protected $fillable = [
        'member_id',
        'supplier_id',
        // 'causal_id',
        'payment_method_id',
        'date',
        //'month',
        //'year',
        'type',
        //'amount',
        //'note',
        //'commercial',
    ];

    public function member()
    {
        return $this->belongsTo(Member::class);
    }

    public function supplier()
    {
        return $this->belongsTo(Supplier::class);
    }

    public function payment_method()
    {
        return $this->belongsTo(PaymentMethod::class);
    }

    public function rows()
    {
        return $this->hasMany(RecordRow::class);
    }

    public function getTotal()
    {
        return $this->rows->sum('amount');
    }

}