<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class HospitalAndDoctor extends Model
{
    protected $table = 'hospital_and_doctors';

    public function hospitals() {
        return $this->belongsToMany(Hospital::class, 'hospital_and_doctors__hospitals', 'hospital_and_doctor_id', 'hospital_id');
    }

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

    public function interlinkModules()
    {
        return $this

           ->hasManyThrough(
               InterlinkModule::class,
               HospitalAndDoctorComponent::class,
               'hospital_and_doctor_id',
               'id',
               'id',
               'component_id'
           )

           ->where('component_type', 'components_interlink_section_cps_interlinks')

           ->where('field', 'Interlink')->orderBy('order');
    }

    public function faqs()
    {
        return $this->hasManyThrough(
            FAQ::class,
            HospitalAndDoctorComponent::class,
            'hospital_and_doctor_id',
            'id',
            'id',
            'component_id'
        )->where("field", "FAQ")
            ->where("component_type", "components_faq_faqs")
            ->orderBy('order');
    }

}