| | |
| | | package com.ruoyi.system.service.impl;
|
| | |
|
| | | import java.util.Comparator;
|
| | | import java.util.List;
|
| | | import java.util.Map;
|
| | | import java.util.stream.Collectors;
|
| | | import javax.annotation.PostConstruct;
|
| | | import org.springframework.beans.factory.annotation.Autowired;
|
| | | import org.springframework.stereotype.Service;
|
| | | import org.springframework.transaction.annotation.Transactional;
|
| | | import com.ruoyi.common.constant.UserConstants;
|
| | | import com.ruoyi.common.core.domain.entity.SysDictData;
|
| | | import com.ruoyi.common.core.domain.entity.SysDictType;
|
| | | import com.ruoyi.common.exception.ServiceException;
|
| | | import com.ruoyi.common.utils.DictUtils;
|
| | | import com.ruoyi.common.utils.StringUtils;
|
| | | import com.ruoyi.system.mapper.SysDictDataMapper;
|
| | | import com.ruoyi.system.mapper.SysDictTypeMapper;
|
| | | import com.ruoyi.system.service.ISysDictTypeService;
|
| | |
|
| | | /**
|
| | | * 字典 业务层处理
|
| | | * |
| | | * @author ruoyi
|
| | | */
|
| | | @Service
|
| | | public class SysDictTypeServiceImpl implements ISysDictTypeService
|
| | | {
|
| | | @Autowired
|
| | | private SysDictTypeMapper dictTypeMapper;
|
| | |
|
| | | @Autowired
|
| | | private SysDictDataMapper dictDataMapper;
|
| | |
|
| | | /**
|
| | | * 项目启动时,初始化字典到缓存
|
| | | */
|
| | | @PostConstruct
|
| | | public void init()
|
| | | {
|
| | | loadingDictCache();
|
| | | }
|
| | |
|
| | | /**
|
| | | * 根据条件分页查询字典类型
|
| | | * |
| | | * @param dictType 字典类型信息
|
| | | * @return 字典类型集合信息
|
| | | */
|
| | | @Override
|
| | | public List<SysDictType> selectDictTypeList(SysDictType dictType)
|
| | | {
|
| | | return dictTypeMapper.selectDictTypeList(dictType);
|
| | | }
|
| | |
|
| | | /**
|
| | | * 根据所有字典类型
|
| | | * |
| | | * @return 字典类型集合信息
|
| | | */
|
| | | @Override
|
| | | public List<SysDictType> selectDictTypeAll()
|
| | | {
|
| | | return dictTypeMapper.selectDictTypeAll();
|
| | | }
|
| | |
|
| | | /**
|
| | | * 根据字典类型查询字典数据
|
| | | * |
| | | * @param dictType 字典类型
|
| | | * @return 字典数据集合信息
|
| | | */
|
| | | @Override
|
| | | public List<SysDictData> selectDictDataByType(String dictType)
|
| | | {
|
| | | List<SysDictData> dictDatas = DictUtils.getDictCache(dictType);
|
| | | if (StringUtils.isNotEmpty(dictDatas))
|
| | | {
|
| | | return dictDatas;
|
| | | }
|
| | | dictDatas = dictDataMapper.selectDictDataByType(dictType);
|
| | | if (StringUtils.isNotEmpty(dictDatas))
|
| | | {
|
| | | DictUtils.setDictCache(dictType, dictDatas);
|
| | | return dictDatas;
|
| | | }
|
| | | return null;
|
| | | }
|
| | |
|
| | | /**
|
| | | * 根据字典类型ID查询信息
|
| | | * |
| | | * @param dictId 字典类型ID
|
| | | * @return 字典类型
|
| | | */
|
| | | @Override
|
| | | public SysDictType selectDictTypeById(Long dictId)
|
| | | {
|
| | | return dictTypeMapper.selectDictTypeById(dictId);
|
| | | }
|
| | |
|
| | | /**
|
| | | * 根据字典类型查询信息
|
| | | * |
| | | * @param dictType 字典类型
|
| | | * @return 字典类型
|
| | | */
|
| | | @Override
|
| | | public SysDictType selectDictTypeByType(String dictType)
|
| | | {
|
| | | return dictTypeMapper.selectDictTypeByType(dictType);
|
| | | }
|
| | |
|
| | | /**
|
| | | * 批量删除字典类型信息
|
| | | * |
| | | * @param dictIds 需要删除的字典ID
|
| | | */
|
| | | @Override
|
| | | public void deleteDictTypeByIds(Long[] dictIds)
|
| | | {
|
| | | for (Long dictId : dictIds)
|
| | | {
|
| | | SysDictType dictType = selectDictTypeById(dictId);
|
| | | if (dictDataMapper.countDictDataByType(dictType.getDictType()) > 0)
|
| | | {
|
| | | throw new ServiceException(String.format("%1$s已分配,不能删除", dictType.getDictName()));
|
| | | }
|
| | | dictTypeMapper.deleteDictTypeById(dictId);
|
| | | DictUtils.removeDictCache(dictType.getDictType());
|
| | | }
|
| | | }
|
| | |
|
| | | /**
|
| | | * 加载字典缓存数据
|
| | | */
|
| | | @Override
|
| | | public void loadingDictCache()
|
| | | {
|
| | | SysDictData dictData = new SysDictData();
|
| | | dictData.setStatus("0");
|
| | | Map<String, List<SysDictData>> dictDataMap = dictDataMapper.selectDictDataList(dictData).stream().collect(Collectors.groupingBy(SysDictData::getDictType));
|
| | | for (Map.Entry<String, List<SysDictData>> entry : dictDataMap.entrySet())
|
| | | {
|
| | | DictUtils.setDictCache(entry.getKey(), entry.getValue().stream().sorted(Comparator.comparing(SysDictData::getDictSort)).collect(Collectors.toList()));
|
| | | }
|
| | | }
|
| | |
|
| | | /**
|
| | | * 清空字典缓存数据
|
| | | */
|
| | | @Override
|
| | | public void clearDictCache()
|
| | | {
|
| | | DictUtils.clearDictCache();
|
| | | }
|
| | |
|
| | | /**
|
| | | * 重置字典缓存数据
|
| | | */
|
| | | @Override
|
| | | public void resetDictCache()
|
| | | {
|
| | | clearDictCache();
|
| | | loadingDictCache();
|
| | | }
|
| | |
|
| | | /**
|
| | | * 新增保存字典类型信息
|
| | | * |
| | | * @param dict 字典类型信息
|
| | | * @return 结果
|
| | | */
|
| | | @Override
|
| | | public int insertDictType(SysDictType dict)
|
| | | {
|
| | | int row = dictTypeMapper.insertDictType(dict);
|
| | | if (row > 0)
|
| | | {
|
| | | DictUtils.setDictCache(dict.getDictType(), null);
|
| | | }
|
| | | return row;
|
| | | }
|
| | |
|
| | | /**
|
| | | * 修改保存字典类型信息
|
| | | * |
| | | * @param dict 字典类型信息
|
| | | * @return 结果
|
| | | */
|
| | | @Override
|
| | | @Transactional
|
| | | public int updateDictType(SysDictType dict)
|
| | | {
|
| | | SysDictType oldDict = dictTypeMapper.selectDictTypeById(dict.getDictId());
|
| | | dictDataMapper.updateDictDataType(oldDict.getDictType(), dict.getDictType());
|
| | | int row = dictTypeMapper.updateDictType(dict);
|
| | | if (row > 0)
|
| | | {
|
| | | List<SysDictData> dictDatas = dictDataMapper.selectDictDataByType(dict.getDictType());
|
| | | DictUtils.setDictCache(dict.getDictType(), dictDatas);
|
| | | }
|
| | | return row;
|
| | | }
|
| | |
|
| | | /**
|
| | | * 校验字典类型称是否唯一
|
| | | * |
| | | * @param dict 字典类型
|
| | | * @return 结果
|
| | | */
|
| | | @Override
|
| | | public String checkDictTypeUnique(SysDictType dict)
|
| | | {
|
| | | Long dictId = StringUtils.isNull(dict.getDictId()) ? -1L : dict.getDictId();
|
| | | SysDictType dictType = dictTypeMapper.checkDictTypeUnique(dict.getDictType());
|
| | | if (StringUtils.isNotNull(dictType) && dictType.getDictId().longValue() != dictId.longValue())
|
| | | {
|
| | | return UserConstants.NOT_UNIQUE;
|
| | | }
|
| | | return UserConstants.UNIQUE;
|
| | | }
|
| | | }
|
| | | package com.ruoyi.system.service.impl; |
| | | |
| | | import cn.dev33.satoken.context.SaHolder; |
| | | import cn.hutool.core.collection.CollUtil; |
| | | import cn.hutool.core.util.ObjectUtil; |
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
| | | import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.ruoyi.common.core.constant.CacheConstants; |
| | | import com.ruoyi.common.core.constant.CacheNames; |
| | | import com.ruoyi.common.core.constant.UserConstants; |
| | | import com.ruoyi.common.mybatis.core.page.PageQuery; |
| | | import com.ruoyi.common.core.service.DictService; |
| | | import com.ruoyi.system.domain.SysDictData; |
| | | import com.ruoyi.system.domain.SysDictType; |
| | | import com.ruoyi.common.mybatis.core.page.TableDataInfo; |
| | | import com.ruoyi.common.core.exception.ServiceException; |
| | | import com.ruoyi.common.core.utils.StreamUtils; |
| | | import com.ruoyi.common.core.utils.StringUtils; |
| | | import com.ruoyi.common.redis.utils.CacheUtils; |
| | | import com.ruoyi.common.core.utils.SpringUtils; |
| | | import com.ruoyi.system.mapper.SysDictDataMapper; |
| | | import com.ruoyi.system.mapper.SysDictTypeMapper; |
| | | import com.ruoyi.system.service.ISysDictTypeService; |
| | | import lombok.RequiredArgsConstructor; |
| | | import org.springframework.cache.annotation.CachePut; |
| | | import org.springframework.cache.annotation.Cacheable; |
| | | import org.springframework.stereotype.Service; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | import java.util.*; |
| | | import java.util.stream.Collectors; |
| | | |
| | | /** |
| | | * 字典 业务层处理 |
| | | * |
| | | * @author Lion Li |
| | | */ |
| | | @RequiredArgsConstructor |
| | | @Service |
| | | public class SysDictTypeServiceImpl implements ISysDictTypeService, DictService { |
| | | |
| | | private final SysDictTypeMapper baseMapper; |
| | | private final SysDictDataMapper dictDataMapper; |
| | | |
| | | @Override |
| | | public TableDataInfo<SysDictType> selectPageDictTypeList(SysDictType dictType, PageQuery pageQuery) { |
| | | Map<String, Object> params = dictType.getParams(); |
| | | LambdaQueryWrapper<SysDictType> lqw = new LambdaQueryWrapper<SysDictType>() |
| | | .like(StringUtils.isNotBlank(dictType.getDictName()), SysDictType::getDictName, dictType.getDictName()) |
| | | .eq(StringUtils.isNotBlank(dictType.getStatus()), SysDictType::getStatus, dictType.getStatus()) |
| | | .like(StringUtils.isNotBlank(dictType.getDictType()), SysDictType::getDictType, dictType.getDictType()) |
| | | .between(params.get("beginTime") != null && params.get("endTime") != null, |
| | | SysDictType::getCreateTime, params.get("beginTime"), params.get("endTime")); |
| | | Page<SysDictType> page = baseMapper.selectPage(pageQuery.build(), lqw); |
| | | return TableDataInfo.build(page); |
| | | } |
| | | |
| | | /** |
| | | * 根据条件分页查询字典类型 |
| | | * |
| | | * @param dictType 字典类型信息 |
| | | * @return 字典类型集合信息 |
| | | */ |
| | | @Override |
| | | public List<SysDictType> selectDictTypeList(SysDictType dictType) { |
| | | Map<String, Object> params = dictType.getParams(); |
| | | return baseMapper.selectList(new LambdaQueryWrapper<SysDictType>() |
| | | .like(StringUtils.isNotBlank(dictType.getDictName()), SysDictType::getDictName, dictType.getDictName()) |
| | | .eq(StringUtils.isNotBlank(dictType.getStatus()), SysDictType::getStatus, dictType.getStatus()) |
| | | .like(StringUtils.isNotBlank(dictType.getDictType()), SysDictType::getDictType, dictType.getDictType()) |
| | | .between(params.get("beginTime") != null && params.get("endTime") != null, |
| | | SysDictType::getCreateTime, params.get("beginTime"), params.get("endTime"))); |
| | | } |
| | | |
| | | /** |
| | | * 根据所有字典类型 |
| | | * |
| | | * @return 字典类型集合信息 |
| | | */ |
| | | @Override |
| | | public List<SysDictType> selectDictTypeAll() { |
| | | return baseMapper.selectList(); |
| | | } |
| | | |
| | | /** |
| | | * 根据字典类型查询字典数据 |
| | | * |
| | | * @param dictType 字典类型 |
| | | * @return 字典数据集合信息 |
| | | */ |
| | | @Cacheable(cacheNames = CacheNames.SYS_DICT, key = "#dictType") |
| | | @Override |
| | | public List<SysDictData> selectDictDataByType(String dictType) { |
| | | List<SysDictData> dictDatas = dictDataMapper.selectDictDataByType(dictType); |
| | | if (CollUtil.isNotEmpty(dictDatas)) { |
| | | return dictDatas; |
| | | } |
| | | return null; |
| | | } |
| | | |
| | | /** |
| | | * 根据字典类型ID查询信息 |
| | | * |
| | | * @param dictId 字典类型ID |
| | | * @return 字典类型 |
| | | */ |
| | | @Override |
| | | public SysDictType selectDictTypeById(Long dictId) { |
| | | return baseMapper.selectById(dictId); |
| | | } |
| | | |
| | | /** |
| | | * 根据字典类型查询信息 |
| | | * |
| | | * @param dictType 字典类型 |
| | | * @return 字典类型 |
| | | */ |
| | | @Cacheable(cacheNames = CacheNames.SYS_DICT, key = "#dictType") |
| | | @Override |
| | | public SysDictType selectDictTypeByType(String dictType) { |
| | | return baseMapper.selectById(new LambdaQueryWrapper<SysDictType>().eq(SysDictType::getDictType, dictType)); |
| | | } |
| | | |
| | | /** |
| | | * 批量删除字典类型信息 |
| | | * |
| | | * @param dictIds 需要删除的字典ID |
| | | */ |
| | | @Override |
| | | public void deleteDictTypeByIds(Long[] dictIds) { |
| | | for (Long dictId : dictIds) { |
| | | SysDictType dictType = selectDictTypeById(dictId); |
| | | if (dictDataMapper.exists(new LambdaQueryWrapper<SysDictData>() |
| | | .eq(SysDictData::getDictType, dictType.getDictType()))) { |
| | | throw new ServiceException(String.format("%1$s已分配,不能删除", dictType.getDictName())); |
| | | } |
| | | CacheUtils.evict(CacheNames.SYS_DICT, dictType.getDictType()); |
| | | } |
| | | baseMapper.deleteBatchIds(Arrays.asList(dictIds)); |
| | | } |
| | | |
| | | /** |
| | | * 加载字典缓存数据 |
| | | */ |
| | | @Override |
| | | public void loadingDictCache() { |
| | | List<SysDictData> dictDataList = dictDataMapper.selectList( |
| | | new LambdaQueryWrapper<SysDictData>().eq(SysDictData::getStatus, UserConstants.DICT_NORMAL)); |
| | | Map<String, List<SysDictData>> dictDataMap = StreamUtils.groupByKey(dictDataList, SysDictData::getDictType); |
| | | dictDataMap.forEach((k,v) -> { |
| | | List<SysDictData> dictList = StreamUtils.sorted(v, Comparator.comparing(SysDictData::getDictSort)); |
| | | CacheUtils.put(CacheNames.SYS_DICT, k, dictList); |
| | | }); |
| | | } |
| | | |
| | | /** |
| | | * 清空字典缓存数据 |
| | | */ |
| | | @Override |
| | | public void clearDictCache() { |
| | | CacheUtils.clear(CacheNames.SYS_DICT); |
| | | } |
| | | |
| | | /** |
| | | * 重置字典缓存数据 |
| | | */ |
| | | @Override |
| | | public void resetDictCache() { |
| | | clearDictCache(); |
| | | loadingDictCache(); |
| | | } |
| | | |
| | | /** |
| | | * 新增保存字典类型信息 |
| | | * |
| | | * @param dict 字典类型信息 |
| | | * @return 结果 |
| | | */ |
| | | @CachePut(cacheNames = CacheNames.SYS_DICT, key = "#dict.dictType") |
| | | @Override |
| | | public List<SysDictData> insertDictType(SysDictType dict) { |
| | | int row = baseMapper.insert(dict); |
| | | if (row > 0) { |
| | | return new ArrayList<>(); |
| | | } |
| | | throw new ServiceException("操作失败"); |
| | | } |
| | | |
| | | /** |
| | | * 修改保存字典类型信息 |
| | | * |
| | | * @param dict 字典类型信息 |
| | | * @return 结果 |
| | | */ |
| | | @CachePut(cacheNames = CacheNames.SYS_DICT, key = "#dict.dictType") |
| | | @Override |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public List<SysDictData> updateDictType(SysDictType dict) { |
| | | SysDictType oldDict = baseMapper.selectById(dict.getDictId()); |
| | | dictDataMapper.update(null, new LambdaUpdateWrapper<SysDictData>() |
| | | .set(SysDictData::getDictType, dict.getDictType()) |
| | | .eq(SysDictData::getDictType, oldDict.getDictType())); |
| | | int row = baseMapper.updateById(dict); |
| | | if (row > 0) { |
| | | CacheUtils.evict(CacheNames.SYS_DICT, oldDict.getDictType()); |
| | | return dictDataMapper.selectDictDataByType(dict.getDictType()); |
| | | } |
| | | throw new ServiceException("操作失败"); |
| | | } |
| | | |
| | | /** |
| | | * 校验字典类型称是否唯一 |
| | | * |
| | | * @param dict 字典类型 |
| | | * @return 结果 |
| | | */ |
| | | @Override |
| | | public String checkDictTypeUnique(SysDictType dict) { |
| | | boolean exist = baseMapper.exists(new LambdaQueryWrapper<SysDictType>() |
| | | .eq(SysDictType::getDictType, dict.getDictType()) |
| | | .ne(ObjectUtil.isNotNull(dict.getDictId()), SysDictType::getDictId, dict.getDictId())); |
| | | if (exist) { |
| | | return UserConstants.NOT_UNIQUE; |
| | | } |
| | | return UserConstants.UNIQUE; |
| | | } |
| | | |
| | | /** |
| | | * 根据字典类型和字典值获取字典标签 |
| | | * |
| | | * @param dictType 字典类型 |
| | | * @param dictValue 字典值 |
| | | * @param separator 分隔符 |
| | | * @return 字典标签 |
| | | */ |
| | | @SuppressWarnings("unchecked cast") |
| | | @Override |
| | | public String getDictLabel(String dictType, String dictValue, String separator) { |
| | | // 优先从本地缓存获取 |
| | | List<SysDictData> datas = (List<SysDictData>) SaHolder.getStorage().get(CacheConstants.SYS_DICT_KEY + dictType); |
| | | if (ObjectUtil.isNull(datas)) { |
| | | datas = SpringUtils.getAopProxy(this).selectDictDataByType(dictType); |
| | | SaHolder.getStorage().set(CacheConstants.SYS_DICT_KEY + dictType, datas); |
| | | } |
| | | |
| | | Map<String, String> map = StreamUtils.toMap(datas, SysDictData::getDictValue, SysDictData::getDictLabel); |
| | | if (StringUtils.containsAny(dictValue, separator)) { |
| | | return Arrays.stream(dictValue.split(separator)) |
| | | .map(v -> map.getOrDefault(v, StringUtils.EMPTY)) |
| | | .collect(Collectors.joining(separator)); |
| | | } else { |
| | | return map.getOrDefault(dictValue, StringUtils.EMPTY); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * 根据字典类型和字典标签获取字典值 |
| | | * |
| | | * @param dictType 字典类型 |
| | | * @param dictLabel 字典标签 |
| | | * @param separator 分隔符 |
| | | * @return 字典值 |
| | | */ |
| | | @SuppressWarnings("unchecked cast") |
| | | @Override |
| | | public String getDictValue(String dictType, String dictLabel, String separator) { |
| | | // 优先从本地缓存获取 |
| | | List<SysDictData> datas = (List<SysDictData>) SaHolder.getStorage().get(CacheConstants.SYS_DICT_KEY + dictType); |
| | | if (ObjectUtil.isNull(datas)) { |
| | | datas = SpringUtils.getAopProxy(this).selectDictDataByType(dictType); |
| | | SaHolder.getStorage().set(CacheConstants.SYS_DICT_KEY + dictType, datas); |
| | | } |
| | | |
| | | Map<String, String> map = StreamUtils.toMap(datas, SysDictData::getDictLabel, SysDictData::getDictValue); |
| | | if (StringUtils.containsAny(dictLabel, separator)) { |
| | | return Arrays.stream(dictLabel.split(separator)) |
| | | .map(l -> map.getOrDefault(l, StringUtils.EMPTY)) |
| | | .collect(Collectors.joining(separator)); |
| | | } else { |
| | | return map.getOrDefault(dictLabel, StringUtils.EMPTY); |
| | | } |
| | | } |
| | | |
| | | } |