<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Encore\Admin\Traits\AdminBuilder;
use Encore\Admin\Traits\ModelTree;

/**
 * App\Models\CategoryDistrict
 *
 * @property int $id
 * @property int $parent_id 地区父类ID
 * @property string $name 地区分类名称
 * @property int $order 排序
 * @property string $spell 拼音
 * @property \Illuminate\Support\Carbon|null $created_at
 * @property \Illuminate\Support\Carbon|null $updated_at
 * @property string|null $deleted_at
 * @property-read \Illuminate\Database\Eloquent\Collection|\App\Models\CategoryDistrict[] $children
 * @property-read \App\Models\CategoryDistrict $parent
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryDistrict list()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryDistrict newModelQuery()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryDistrict newQuery()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryDistrict query()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryDistrict whereCreatedAt($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryDistrict whereDeletedAt($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryDistrict whereId($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryDistrict whereName($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryDistrict whereOrder($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryDistrict whereParentId($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryDistrict whereSpell($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryDistrict whereUpdatedAt($value)
 * @mixin \Eloquent
 */
class CategoryDistrict extends Model
{
    use ModelTree, AdminBuilder;
    protected $table = 'category_districts';
    protected $guarded = [];
    public function scopeList()
    {
        return $this->where(['parent_id'=>0])->select(['id','name']);
    }

    public static function categoryDis($id)
    {
        return array_column(CategoryDistrict::where('parent_id', $id)->get(['id', 'name'])->toArray(), 'name', 'id');
    }
    
    public function children()
    {
        return $this->hasMany(CategoryDistrict::class, 'parent_id')->orderBy('order','desc');
    }
    
}