<?php

namespace App\Models;

use App\Models\traits\SetConnectionUser;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsTo;

class Review extends Model
{
    use SetConnectionUser;

    protected $fillable = [
        'id', 'facility_id', 'r_photo', 'r_date', 'r_name', 'r_title', 'r_comment'
    ];

    public static function getDataByFacility($id) {
        $review = Review::query();
        $result = $review->where('facility_id', '=', $id)->orderByDesc('r_date')->get();
        return $result;
    }

    public function facility(): BelongsTo
    {
        return $this->belongsTo(Facility::class);
    }
}