1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859 |
- <?php
- namespace App\Models;
- use Illuminate\Database\Eloquent\Model;
- use Illuminate\Database\Eloquent\SoftDeletes;
- 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');
- }
-
- }
|