SystemConfigItem.php 2.6 KB
<?php
/**
+-----------------------------------------------------------------------------------------------------------------------
 * 模型层:系统-参数配置 模型类
+-----------------------------------------------------------------------------------------------------------------------
 *
 * PHP version 7
 *
 * @category  App\Models\System
 * @package   App\Models\System
 * @author    Richer <yangzi1028@163.com>
 * @date      2021年7月28日13:35:44
 * @copyright 2020-2022 Richer (http://www.Richer.com/)
 * @license   http://www.Richer.com/ License
 * @link      http://www.Richer.com/
 */
namespace App\Models\System;

use App\Models\BaseModel;
use Illuminate\Database\Eloquent\Relations\BelongsTo;

/**
 * Class SystemConfigItem
 *
 * @category  App\Models\System
 * @package   App\Models\System
 * @author    Richer <yangzi1028@163.com>
 * @date      2021年7月28日13:35:44
 * @copyright 2020-2022 Richer (http://www.Richer.com/)
 * @license   http://www.Richer.com/ License
 * @link      http://www.Richer.com/
 */
class SystemConfigItem extends BaseModel
{
    // 指定数据库表
    const TABLE = 'system_config_items';
    protected $table = self::TABLE ;

    // 指定对象显示名称:方便系统统一查询和做其他处理
    const OBJ_NAME      = 'config-item';
    const OBJ_NAME_ZH   = '系统参数配置明细';

    protected $casts = [
        'supplement' => 'json',
    ];

    /**
     * @return BelongsTo
     */
    public function config(): BelongsTo
    {
        return $this->belongsTo(SystemConfig::class);
    }

    /**
     * 根据区域的code获取区域的的代码集:主要为laravel-admin select组件使用
     *
     * @param string $key
     * @return array
     */
    public static function getSelectOptions($key = '')
    {
        $query = self::where('status', config('constants.STATUS_OK'));
        if ($key) {
            $query->where('key', $key);
        }
        $list = $query->get(['id','name']);
        $options = [];
        foreach ($list as $vo) {
            $options[$vo->id] = $vo->name;
        }
        return $options;
    }

    /**
     * 根据区域的code获取区域的的代码集:主要为laravel-admin select组件使用
     *
     * @param string $key
     * @return array
     */
    public static function getSwitchOptions($key = '')
    {
        $query = self::where('status', config('constants.STATUS_OK'));
        if ($key) {
            $query->where('key', $key);
        }
        $list = $query->get(['id','name']);
        $options = [];
        foreach ($list as $vo) {
            $options[$vo->id] = $vo->name;
        }
        return $options;
    }
}