<?php

namespace App;

class Area extends BaseModel
{
    protected $table = 'areas';

    protected $fillable = ['id', 'name', 'slug', 'description', 'logo', 'title', 'sub_title', 'link', 'show_top', 'show_search', 'parent_id', 'position', 'is_activated', 'is_deleted', 'created_at', 'updated_at'];

    public function shop()
    {
        return $this->hasMany(Shop::class, 'area_id', 'id')->select('id', 'area_id')->where('is_deleted', false)->where('is_activated', true);
    }

    public function parent() {
        return $this->belongsTo(Area::class, 'parent_id', 'id')->select('id', 'name', 'slug', 'parent_id')->where('is_deleted', false)->where('is_activated', true);
    }

    public function item() {
        return $this->hasMany(Area::class, 'parent_id', 'id')->select('id', 'name', 'slug', 'parent_id')->where('is_deleted', false)->where('is_activated', true)->orderBy('position');
    }
}