hemall.terabimsoft.com.cn/app/common/models/SearchFiltering.php

<?php

namespace app\common\models;

use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\SoftDeletes;
use Illuminate\Support\Collection;


/**
 *
 */
class SearchFiltering extends \app\common\models\BaseModel
{
    use SoftDeletes;

    public $table = 'yz_search_filtering';

    protected $guarded = [];

    protected $hidden = [
        'deleted_at',
    ];


    public function scopeGetFilterGroup($query, $parent_id = 0)
    {
        return $query->where('parent_id', $parent_id)->where('is_show', 0);
    }

    public function scopeCategoryLabel($query, $ids = [])
    {

        if ($ids && is_array($ids)) {
            return $query->whereIn('id', $ids);
        }

        return $query;

    }


    //获取全部标签
    public static function getAllFiltering()
    {
        $filtering = self::select('id', 'parent_id', 'name', 'is_front_show')->getFilterGroup()->get()->toArray();

        foreach ($filtering as $key => &$value) {
            $value['value'] = self::select('id', 'parent_id', 'name', 'is_front_show')->getFilterGroup($value['id'])->get()->toArray();
        }
        return $filtering;
    }

    // 获取所有可显示的标签
    public static function getAllEnableFiltering()
    {
        static $list;
        if ($list instanceof Collection) {
            return $list;
        }

        $filtering = SearchFiltering::getAllFiltering();
        $list = collect(array());
        foreach ($filtering as $v) {
            $list = $list->merge($v['value']);
        }

        return $list;
    }

    public static function boot()
    {
        parent::boot();

        static::addGlobalScope(function (Builder $builder) {
            $builder->uniacid();
        });
    }
}