<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

/**
 * App\Models\CategoryJobs
 *
 * @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
 * @method static bool|null forceDelete()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryJobs list()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryJobs newModelQuery()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryJobs newQuery()
 * @method static \Illuminate\Database\Query\Builder|\App\Models\CategoryJobs onlyTrashed()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryJobs query()
 * @method static bool|null restore()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryJobs whereCreatedAt($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryJobs whereDeletedAt($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryJobs whereId($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryJobs whereName($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryJobs whereOrder($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryJobs whereParentId($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryJobs whereSpell($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Models\CategoryJobs whereUpdatedAt($value)
 * @method static \Illuminate\Database\Query\Builder|\App\Models\CategoryJobs withTrashed()
 * @method static \Illuminate\Database\Query\Builder|\App\Models\CategoryJobs withoutTrashed()
 * @mixin \Eloquent
 */
class CategoryJobs extends Model
{
    use SoftDeletes;

    protected $table = 'category_jobs';
    protected $guarded = [];
    public function scopeList()
    {
        return $this->where(['parent_id'=>0])->select(['id','name']);
    }

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