bill/app/Models/Category.php

<?php

namespace App\Models;

use Dcat\Admin\Traits\ModelTree;

class Category extends BaseModel
{
    use ModelTree;

    protected $guarded = [];

    // 父级ID字段名称，默认值为 parent_id
    protected $parentColumn = 'pid';

    // 排序字段名称，默认值为 order
    protected $orderColumn = 'sort';

    // 标题字段名称，默认值为 title
    protected $titleColumn = 'name';

    const PLATFORM_TYPE = 'PLATFORM_TYPE';
    const BUY_ACCOUNT = 'BUY_ACCOUNT';
    const ORDER_STATUS = 'ORDER_STATUS';
    const BILL_TYPE = 'BILL_TYPE';

    public static function byKeyGetOptions($key)
    {
        return self::query()->where('pid', self::query()->where('key', $key)->value('id'))->pluck('name', 'id');
    }

    public static function byIdGetName($id)
    {
        return self::query()->where('id', $id)->where('pid', '>', 0)->value('name');
    }
}