<?php

namespace App\Models;

use App\Traits\SyncModelBoot;
use Illuminate\Database\Eloquent\Model;

class UnitPriceCategory extends Model
{
    protected $connection = 'mysql_proj';
    
    use SyncModelBoot;

    protected $guarded = ['id'];

    protected static function withRoleLevel()
    {
        return false;
    }

    public function invoices()
    {
        return $this->belongsTo(Invoice::class);
    }

    public function unitPriceSubcategories()
    {
        return $this->hasMany(UnitPriceSubcategory::class)->orderBy('sequence_number', 'asc')->orderBy('id', 'desc');
    }
    
    public function budgetPlans()
    {
        return $this->belongsToMany(BudgetPlan::class, 'budget_plan_prices')
            ->using(BudgetPlanPrice::class)
            ->withPivot('id', 'price', 'qty', 'subtotal', 'images');
    }
}