<?php

namespace App;

class Consultation extends BaseModel
{
    protected $table = 'consultations';

    protected $appends = ['fortuneCount'];

    protected $fillable = ['id', 'name', 'slug', 'description', 'is_activated', 'is_deleted', 'created_at', 'updated_at'];

    public function detail()
    {
        return $this->hasMany(ConsultationDetail::class, 'consultation_id', 'id')
            ->select('consultation_details.*')
            ->join('fortune_tellers', 'fortune_tellers.id', '=', 'consultation_details.fortune_teller_id')
            ->where('fortune_tellers.is_activated', 1)
            ->where('fortune_tellers.is_deleted', 0)
            ->get();
    }

    public function getFortuneCountAttribute() {
        return $this->detail()->count();
    }
}