<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Investor extends Model
{
    protected $table = 'investors';

    protected $with = ['investorDocument'];

    public function getTypeAttribute($value) {
        if ($value) {
            return str_replace('_', ' ', $value);
        }

        return false;
    }

    public function investorDocument()
    {
        return $this->hasOneThrough(
            Media::class,
            MediaMorph::class,
            'related_id',
            'id',
            'id',
            'upload_file_id'
        )
            ->where('related_type', 'investors')
            ->where('field', 'ReportFile')
            ->orderBy('order')
            ->select('upload_file_morph.id', 'name', 'url');
    }
}