142 lines
4.8 KiB
PHP
142 lines
4.8 KiB
PHP
<?php
|
||
// +----------------------------------------------------------------------
|
||
// | CRMEB [ CRMEB赋能开发者，助力企业发展 ]
|
||
// +----------------------------------------------------------------------
|
||
// | Copyright (c) 2016~2020 https://www.crmeb.com All rights reserved.
|
||
// +----------------------------------------------------------------------
|
||
// | Licensed CRMEB并不是自由软件，未经许可不能去掉CRMEB相关版权
|
||
// +----------------------------------------------------------------------
|
||
// | Author: CRMEB Team <admin@crmeb.com>
|
||
// +----------------------------------------------------------------------
|
||
|
||
namespace app\dao\system\config;
|
||
|
||
use app\dao\BaseDao;
|
||
use app\model\system\config\SystemConfig;
|
||
|
||
/**
|
||
* 系统配置
|
||
* Class SystemConfigDao
|
||
* @package app\dao\system\config
|
||
*/
|
||
class SystemConfigDao extends BaseDao
|
||
{
|
||
/**
|
||
* 设置模型
|
||
* @return string
|
||
*/
|
||
protected function setModel(): string
|
||
{
|
||
return SystemConfig::class;
|
||
}
|
||
|
||
/**
|
||
* 获取某个系统配置
|
||
* @param string $configNmae
|
||
* @param int $storeId
|
||
* @return mixed
|
||
*/
|
||
public function getConfigValue(string $configNmae, int $storeId = 0)
|
||
{
|
||
return $this->withSearchSelect(['menu_name', 'store_id'], ['menu_name' => $configNmae, 'store_id' => $storeId])->value('value');
|
||
}
|
||
|
||
/**
|
||
* 获取所有配置
|
||
* @param array $configName
|
||
* @param int $storeId
|
||
* @return array
|
||
*/
|
||
public function getConfigAll(array $configName = [], int $storeId = 0)
|
||
{
|
||
if ($configName) {
|
||
return $this->withSearchSelect(['menu_name', 'store_id'], ['menu_name' => $configName, 'store_id' => $storeId])->column('value', 'menu_name');
|
||
} else {
|
||
return $this->getModel()->column('value', 'menu_name');
|
||
}
|
||
}
|
||
|
||
/**
|
||
* @param array $configName
|
||
* @param int $storeId
|
||
* @param array $field
|
||
* @return array
|
||
*/
|
||
public function getConfigAllField(array $configName = [], int $storeId = 0, array $field = [])
|
||
{
|
||
return $this->withSearchSelect(['menu_name', 'store_id'], ['menu_name' => $configName, 'store_id' => $storeId])->column(implode(',', $field), 'menu_name');
|
||
}
|
||
|
||
/**
|
||
* 获取配置列表分页
|
||
* @param array $where
|
||
* @param int $page
|
||
* @param int $limit
|
||
* @return array
|
||
* @throws \think\db\exception\DataNotFoundException
|
||
* @throws \think\db\exception\DbException
|
||
* @throws \think\db\exception\ModelNotFoundException
|
||
*/
|
||
public function getConfigList(array $where, int $page, int $limit)
|
||
{
|
||
return $this->search($where)->page($page, $limit)->order('sort desc,id desc')->select()->toArray();
|
||
}
|
||
|
||
/**
|
||
* 获取某些分类配置下的配置列表
|
||
* @param int $tabId
|
||
* @param int $status
|
||
* @param int $store_id
|
||
* @return array
|
||
* @throws \think\db\exception\DataNotFoundException
|
||
* @throws \think\db\exception\DbException
|
||
* @throws \think\db\exception\ModelNotFoundException
|
||
*/
|
||
public function getConfigTabAllList(int $tabId, int $status = 1, int $type = 1, int $relation_id = 0)
|
||
{
|
||
$where['tab_id'] = $tabId;
|
||
if ($status == 1) $where['status'] = $status;
|
||
if ($relation_id != 0) $where['is_store'] = 1;
|
||
return $this->search($where)
|
||
->when(isset($relation_id) && $relation_id != 0, function ($query) use ($type, $relation_id) {
|
||
$query->with(['storeConfig' => function ($querys) use ($type, $relation_id) {
|
||
$querys->where('type', $type)->where('relation_id', $relation_id);
|
||
}]);
|
||
})
|
||
->order('sort desc')->select()->toArray();
|
||
}
|
||
|
||
/**
|
||
* 根据条件获取配置
|
||
* @param array $where
|
||
* @param int $type
|
||
* @param int $relation_id
|
||
* @param array $field
|
||
* @return array
|
||
* @throws \think\db\exception\DataNotFoundException
|
||
* @throws \think\db\exception\DbException
|
||
* @throws \think\db\exception\ModelNotFoundException
|
||
*/
|
||
public function getConfigAllListByWhere(array $where, int $type = 1, int $relation_id = 0, array $field = ['*'])
|
||
{
|
||
if ($relation_id != 0) $where['is_store'] = 1;
|
||
return $this->search($where)->field($field)
|
||
->when(isset($relation_id) && $relation_id != 0, function ($query) use ($type, $relation_id) {
|
||
$query->with(['storeConfig' => function ($querys) use ($type, $relation_id) {
|
||
$querys->where('type', $type)->where('relation_id', $relation_id);
|
||
}]);
|
||
})
|
||
->order('sort desc')->select()->toArray();
|
||
}
|
||
|
||
/**
|
||
* 获取上传配置中的上传类型
|
||
* @param string $configName
|
||
* @return array
|
||
*/
|
||
public function getUploadTypeList(string $configName)
|
||
{
|
||
return $this->search(['menu_name' => $configName])->column('upload_type', 'type');
|
||
}
|
||
}
|