<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

class AgreementType extends Model
{
    use SoftDeletes;

    protected $table = 'agreement_types';

    protected $fillable = [
        'name',
        'is_active',
        'created_by'
    ];

    protected $dates = ['deleted_at'];

    /**
     * Relationship with user who created this type
     */
    public function creator()
    {
        return $this->belongsTo(User::class, 'created_by');
    }

    /**
     * Relationship with loan agreement deletion logs
     */
    public function logs()
    {
        return $this->hasMany(LoanAgreementLog::class, 'agreement_type_id');
    }

    /**
     * Scope to fetch only active agreement types
     */
    public function scopeActive($query)
    {
        return $query->where('is_active', 1);
    }
}