<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class OrderService extends Model
{
    protected $connection = 'mysql_proj';
    protected $guarded = [''];
    protected $appends = ['total_price'];

    public $timestamps = false;

    public function service()
    {
        return $this->belongsTo(Service::class);
    }

    public function orderServicePrices()
    {
        return $this->hasMany(OrderServicePrice::class);
    }

    public function getTotalPriceAttribute()
    {
        return $this->orderServicePrices->sum('subtotal');
    }
}