150 lines
2.8 KiB
PHP
150 lines
2.8 KiB
PHP
<?php
|
|
declare(strict_types=1);
|
|
/**
|
|
*+------------------
|
|
* madong
|
|
*+------------------
|
|
* Copyright (c) https://gitee.com/motion-code All rights reserved.
|
|
*+------------------
|
|
* Author: Mr. April (405784684@qq.com)
|
|
*+------------------
|
|
* Official Website: http://www.madong.cn
|
|
*/
|
|
|
|
namespace app\model\dict;
|
|
|
|
use core\base\BaseModel;
|
|
|
|
/**
|
|
* 字典数据
|
|
*
|
|
* @author Mr.April
|
|
* @since 1.0
|
|
*/
|
|
class DictItem extends BaseModel
|
|
{
|
|
|
|
/**
|
|
* 数据表主键
|
|
*
|
|
* @var string
|
|
*/
|
|
protected $primaryKey = 'id';
|
|
|
|
protected $table = 'sys_dict_item';
|
|
|
|
protected $appends = ['created_date', 'updated_date'];
|
|
|
|
protected $fillable = [
|
|
'id',
|
|
'dict_id',
|
|
'label',
|
|
'value',
|
|
'code',
|
|
'sort',
|
|
'enabled',
|
|
'color',
|
|
'other_class',
|
|
'created_by',
|
|
'updated_by',
|
|
'created_at',
|
|
'updated_at',
|
|
'remark',
|
|
'deleted_at',
|
|
];
|
|
|
|
/**
|
|
* 关键字搜索
|
|
*/
|
|
public function scopeKeywords($query, $value)
|
|
{
|
|
if (!empty($value)) {
|
|
$query->where('label|code', 'LIKE', "%$value%");
|
|
}
|
|
}
|
|
|
|
/**
|
|
* 状态-搜索器
|
|
*
|
|
* @param $query
|
|
* @param $value
|
|
*/
|
|
public function scopeStatus($query, $value)
|
|
{
|
|
if ($value !== '') {
|
|
$queryMethod = is_array($value) ? 'whereIn' : 'where';
|
|
$query->$queryMethod('status', $value);
|
|
}
|
|
}
|
|
|
|
/**
|
|
* 字典ID-搜索器
|
|
*
|
|
* @param $query
|
|
* @param $value
|
|
*/
|
|
public function scopeDictId($query, $value)
|
|
{
|
|
if (!empty($value)) {
|
|
$queryMethod = is_array($value) ? 'whereIn' : 'where';
|
|
$query->$queryMethod('dict_id', $value);
|
|
}
|
|
}
|
|
|
|
/**
|
|
* 字典标识-搜索器
|
|
*
|
|
* @param $query
|
|
* @param $value
|
|
*/
|
|
public function scopeCode($query, $value)
|
|
{
|
|
if (!empty($value)) {
|
|
$queryMethod = is_array($value) ? 'whereIn' : 'where';
|
|
$query->$queryMethod('code', $value);
|
|
}
|
|
}
|
|
|
|
/**
|
|
* Value- 搜索器
|
|
*
|
|
* @param $query
|
|
* @param $value
|
|
*/
|
|
public function scopeValue($query, $value)
|
|
{
|
|
if (!empty($value)) {
|
|
$query->where('value', 'LIKE', "%$value%");
|
|
}
|
|
}
|
|
|
|
/**
|
|
* Label-搜索器
|
|
*
|
|
* @param $query
|
|
* @param $value
|
|
*/
|
|
public function scopeLabel($query, $value)
|
|
{
|
|
if (!empty($value)) {
|
|
$query->where('label', 'LIKE', "%$value%");
|
|
}
|
|
}
|
|
|
|
/**
|
|
* 获取器-扩展属性
|
|
*
|
|
* @param $value
|
|
*
|
|
* @return mixed|object
|
|
*/
|
|
public function getExt($value): mixed
|
|
{
|
|
if (is_null($value) || $value === '') {
|
|
return (object)[];
|
|
}
|
|
return json_decode($value, 1);
|
|
}
|
|
|
|
}
|