<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class CPSDoctor extends Model
{
    protected $table = 'cps_doctors';

    public function specialities()
    {
        return $this->belongsToMany(
            Speciality::class,
            'cps_doctors__specialities',
            'cps_doctor_id',
            'speciality_id'
        )->select('specialities.id', 'SpecialityName', 'Slug');
    }

    public function cpsLocation()
    {
        return $this->belongsTo(CPSLocation::class, 'CPSLocationID');
    }

    public function seoComponent()
    {
        return $this->hasOneThrough(
            SEOComponent::class,
            CPSDoctorComponent::class,
            'cps_doctor_id',
            'id',
            'id',
            'component_id'
        )->where('field', 'SEO')
            ->where('component_type', 'components_seo_seos');
    }
}