org.jeecg.common.system.vo.DictModel Java Examples

/**
 * 通过查询指定table的 text code 获取字典，包含text和value
 * dictTableCache采用redis缓存有效期10分钟
 * @param table
 * @param text
 * @param code
 * @param keyArray
 * @return
 */
@Override
@Cacheable(value = CacheConstant.SYS_DICT_TABLE_CACHE)
public List<String> queryTableDictByKeys(String table, String text, String code, String[] keyArray) {
	List<DictModel> dicts = sysDictMapper.queryTableDictByKeys(table, text, code, keyArray);
	List<String> texts = new ArrayList<>(dicts.size());
	// 查询出来的顺序可能是乱的，需要排个序
	for (String key : keyArray) {
		for (DictModel dict : dicts) {
			if (key.equals(dict.getValue())) {
				texts.add(dict.getText());
				break;
			}
		}
	}
	return texts;
}
 

/**
 * [列表页面]加载分类字典数据 用于值的替换
 * @param code
 * @return
 */
@RequestMapping(value = "/loadAllData", method = RequestMethod.GET)
public Result<List<DictModel>> loadAllData(@RequestParam(name="code",required = true) String code) {
 Result<List<DictModel>> result = new Result<List<DictModel>>();
 LambdaQueryWrapper<SysCategory> query = new LambdaQueryWrapper<SysCategory>();
 if(oConvertUtils.isNotEmpty(code) && !"0".equals(code)){
	 query.likeRight(SysCategory::getCode,code);
 }
 List<SysCategory> list = this.sysCategoryService.list(query);
 if(list==null || list.size()==0) {
	 result.setMessage("无数据,参数有误.[code]");
	 result.setSuccess(false);
	 return result;
 }
 List<DictModel> rdList = new ArrayList<DictModel>();
 for (SysCategory c : list) {
	 rdList.add(new DictModel(c.getId(),c.getName()));
 }
 result.setSuccess(true);
 result.setResult(rdList);
 return result;
}
 

/**
 * 通过字典查询easypoi，所需字典文本
 * 
 * @Author:scott 
 * @since：2019-04-09
 * @return
 */
@Override
public String[] queryDict(String dicTable, String dicCode, String dicText) {
	List<String> dictReplaces = new ArrayList<String>();
	List<DictModel> dictList = null;
	// step.1 如果没有字典表则使用系统字典表
	if (oConvertUtils.isEmpty(dicTable)) {
		dictList = sysDictMapper.queryDictItemsByCode(dicCode);
	} else {
		try {
			dicText = oConvertUtils.getString(dicText, dicCode);
			dictList = sysDictMapper.queryTableDictItemsByCode(dicTable, dicText, dicCode);
		} catch (Exception e) {
			log.error(e.getMessage(),e);
		}
	}
	for (DictModel t : dictList) {
		dictReplaces.add(t.getText() + "_" + t.getValue());
	}
	if (dictReplaces != null && dictReplaces.size() != 0) {
		log.info("---AutoPoi--Get_DB_Dict------"+ dictReplaces.toString());
		return dictReplaces.toArray(new String[dictReplaces.size()]);
	}
	return null;
}
 

/**
 * [列表页面]加载分类字典数据 用于值的替换
 * @param code
 * @return
 */
@RequestMapping(value = "/loadAllData", method = RequestMethod.GET)
public Result<List<DictModel>> loadAllData(@RequestParam(name="code",required = true) String code) {
 Result<List<DictModel>> result = new Result<List<DictModel>>();
 LambdaQueryWrapper<SysCategory> query = new LambdaQueryWrapper<SysCategory>();
 if(oConvertUtils.isNotEmpty(code) && !"0".equals(code)){
	 query.likeRight(SysCategory::getCode,code);
 }
 List<SysCategory> list = this.sysCategoryService.list(query);
 if(list==null || list.size()==0) {
	 result.setMessage("无数据,参数有误.[code]");
	 result.setSuccess(false);
	 return result;
 }
 List<DictModel> rdList = new ArrayList<DictModel>();
 for (SysCategory c : list) {
	 rdList.add(new DictModel(c.getId(),c.getName()));
 }
 result.setSuccess(true);
 result.setResult(rdList);
 return result;
}
 

/**
 * 通过查询指定table的 text code 获取字典，包含text和value
 * dictTableCache采用redis缓存有效期10分钟
 * @param table
 * @param text
 * @param code
 * @param keyArray
 * @return
 */
@Override
@Cacheable(value = CacheConstant.SYS_DICT_TABLE_CACHE)
public List<String> queryTableDictByKeys(String table, String text, String code, String[] keyArray) {
	List<DictModel> dicts = sysDictMapper.queryTableDictByKeys(table, text, code, keyArray);
	List<String> texts = new ArrayList<>(dicts.size());
	// 查询出来的顺序可能是乱的，需要排个序
	for (String key : keyArray) {
		for (DictModel dict : dicts) {
			if (key.equals(dict.getValue())) {
				texts.add(dict.getText());
				break;
			}
		}
	}
	return texts;
}
 

@Override
public Map<String, List<DictModel>> queryAllDictItems() {
	Map<String, List<DictModel>> res = new HashMap<String, List<DictModel>>();
	List<SysDict> ls = sysDictMapper.selectList(null);
	LambdaQueryWrapper<SysDictItem> queryWrapper = new LambdaQueryWrapper<SysDictItem>();
	queryWrapper.eq(SysDictItem::getStatus, 1);
	queryWrapper.orderByAsc(SysDictItem::getSortOrder);
	List<SysDictItem> sysDictItemList = sysDictItemMapper.selectList(queryWrapper);

	for (SysDict d : ls) {
		List<DictModel> dictModelList = sysDictItemList.stream().filter(s -> d.getId().equals(s.getDictId())).map(item -> {
			DictModel dictModel = new DictModel();
			dictModel.setText(item.getItemText());
			dictModel.setValue(item.getItemValue());
			return dictModel;
		}).collect(Collectors.toList());
		res.put(d.getDictCode(), dictModelList);
	}
	log.debug("-------登录加载系统字典-----" + res.toString());
	return res;
}
 

/**
 * 通过查询指定code 获取字典
 * @param code
 * @return
 */
@Override
@Cacheable(value = CacheConstant.SYS_DICT_CACHE,key = "#code")
public List<DictModel> queryDictItemsByCode(String code) {
	log.info("无缓存dictCache的时候调用这里！");
	return sysDictMapper.queryDictItemsByCode(code);
}
 

/**
 * 【APP接口】根据字典配置查询表字典数据
 * @param query
 * @param pageNo
 * @param pageSize
 * @return
 */
@GetMapping("/queryTableData")
public Result<List<DictModel>> queryTableData(DictQuery query,
											  @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo,
											  @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize,
											  @RequestParam(value = "sign",required = false) String sign,HttpServletRequest request){
	Result<List<DictModel>> res = new Result<List<DictModel>>();
	// SQL注入漏洞 sign签名校验
	String dictCode = query.getTable()+","+query.getText()+","+query.getCode();
	List<DictModel> ls = this.sysDictService.queryDictTablePageList(query,pageSize,pageNo);
	res.setResult(ls);
	res.setSuccess(true);
	return res;
}
 

/**
        *  列表类型的走这个构造器  
 * @param key 字段名
 * @param title 字段备注 
 * @param view 展示控件 list-checkbox-radio
 * @param maxLength 数据库字段最大长度
 * @param include 数据字典
 */
public StringProperty(String key,String title,String view,Integer maxLength,List<DictModel> include) {
	this.maxLength = maxLength;
	this.key = key;
	this.view = view;
	this.title = title;
	this.type = "string";
	this.include = include;
}
 

/**
        *  列表类型的走这个构造器  
 * @param key 字段名
 * @param title 字段备注 
 * @param view 展示控件 list-checkbox-radio
 * @param maxLength 数据库字段最大长度
 * @param include 数据字典
 */
public StringProperty(String key,String title,String view,Integer maxLength,List<DictModel> include) {
	this.maxLength = maxLength;
	this.key = key;
	this.view = view;
	this.title = title;
	this.type = "string";
	this.include = include;
}
 

/**
 * 大数据量的字典表 走异步加载  即前端输入内容过滤数据
 * @param dictCode
 * @return
 */
@RequestMapping(value = "/loadDict/{dictCode}", method = RequestMethod.GET)
public Result<List<DictModel>> loadDict(@PathVariable String dictCode,@RequestParam(name="keyword") String keyword, @RequestParam(value = "sign",required = false) String sign,HttpServletRequest request) {
	log.info(" 加载字典表数据,加载关键字: "+ keyword);
	Result<List<DictModel>> result = new Result<List<DictModel>>();
	List<DictModel> ls = null;
	try {
		if(dictCode.indexOf(",")!=-1) {
			String[] params = dictCode.split(",");
			if(params.length!=3) {
				result.error500("字典Code格式不正确！");
				return result;
			}
			ls = sysDictService.queryTableDictItems(params[0],params[1],params[2],keyword);
			result.setSuccess(true);
			result.setResult(ls);
			log.info(result.toString());
		}else {
			result.error500("字典Code格式不正确！");
		}
	} catch (Exception e) {
		log.error(e.getMessage(),e);
		result.error500("操作失败");
		return result;
	}

	return result;
}
 

/**
 * 大数据量的字典表 走异步加载  即前端输入内容过滤数据 
 * @param dictCode
 * @return
 */
@RequestMapping(value = "/loadDict/{dictCode}", method = RequestMethod.GET)
public Result<List<DictModel>> loadDict(@PathVariable String dictCode,@RequestParam(name="keyword") String keyword) {
	log.info(" 加载字典表数据,加载关键字: "+ keyword);
	Result<List<DictModel>> result = new Result<List<DictModel>>();
	List<DictModel> ls = null;
	try {
		if(dictCode.indexOf(",")!=-1) {
			String[] params = dictCode.split(",");
			if(params.length!=3) {
				result.error500("字典Code格式不正确！");
				return result;
			}
			ls = sysDictService.queryTableDictItems(params[0],params[1],params[2],keyword);
			result.setSuccess(true);
			result.setResult(ls);
			log.info(result.toString());
		}else {
			result.error500("字典Code格式不正确！");
		}
	} catch (Exception e) {
		log.error(e.getMessage(),e);
		result.error500("操作失败");
		return result;
	}

	return result;
}
 

/**
 * 通过查询指定code 获取字典
 * @param code
 * @return
 */
@Override
@Cacheable(value = CacheConstant.SYS_DICT_CACHE,key = "#code")
public List<DictModel> queryDictItemsByCode(String code) {
	log.info("无缓存dictCache的时候调用这里！");
	return sysDictMapper.queryDictItemsByCode(code);
}
 

/**
 * 通过查询指定code 获取字典
 * @param code
 * @return
 */
@Override
@Cacheable(value = CacheConstant.SYS_DICT_CACHE,key = "#code")
public List<DictModel> queryDictItemsByCode(String code) {
	log.info("无缓存dictCache的时候调用这里！");
	return sysDictMapper.queryDictItemsByCode(code);
}
 

/**
 * 通过字典查询easypoi，所需字典文本
 * 
 * @Author:scott 
 * @since：2019-04-09
 * @return
 */
@Override
public String[] queryDict(String dicTable, String dicCode, String dicText) {
	List<String> dictReplaces = new ArrayList<String>();
	List<DictModel> dictList = null;
	// step.1 如果没有字典表则使用系统字典表
	if (oConvertUtils.isEmpty(dicTable)) {
		dictList = sysDictMapper.queryDictItemsByCode(dicCode);
	} else {
		try {
			dicText = oConvertUtils.getString(dicText, dicCode);
			dictList = sysDictMapper.queryTableDictItemsByCode(dicTable, dicText, dicCode);
		} catch (Exception e) {
			log.error(e.getMessage(),e);
		}
	}
	for (DictModel t : dictList) {
		if(t!=null){
			dictReplaces.add(t.getText() + "_" + t.getValue());
		}
	}
	if (dictReplaces != null && dictReplaces.size() != 0) {
		log.info("---AutoPoi--Get_DB_Dict------"+ dictReplaces.toString());
		return dictReplaces.toArray(new String[dictReplaces.size()]);
	}
	return null;
}
 

/**
        *  列表类型的走这个构造器  
 * @param key 字段名
 * @param title 字段备注 
 * @param view 展示控件 list-checkbox-radio
 * @param maxLength 数据库字段最大长度
 * @param include 数据字典
 */
public StringProperty(String key,String title,String view,Integer maxLength,List<DictModel> include) {
	this.maxLength = maxLength;
	this.key = key;
	this.view = view;
	this.title = title;
	this.type = "string";
	this.include = include;
}
 

/**
 * 获取全部字典数据
 *
 * @return
 */
@RequestMapping(value = "/queryAllDictItems", method = RequestMethod.GET)
public Result<?> queryAllDictItems(HttpServletRequest request) {
	Map<String, List<DictModel>> res = new HashMap<String, List<DictModel>>();
	res = sysDictService.queryAllDictItems();
	return Result.ok(res);
}
 

public void setInclude(List<DictModel> include) {
	this.include = include;
}
 

@Override
public List<DictModel> queryTableDictItems(String table, String text, String code, String keyword) {
	return baseMapper.queryTableDictItems(table, text, code, "%"+keyword+"%");
}
 

@Override
public List<DictModel> queryTableDictItems(String table, String text, String code, String keyword) {
	return baseMapper.queryTableDictItems(table, text, code, "%"+keyword+"%");
}
 

public List<DictModel> getInclude() {
	return include;
}
 

@Override
public List<DictModel> queryAllUserBackDictModel() {
	return baseMapper.queryAllUserBackDictModel();
}
 

@Override
public List<DictModel> queryAllDepartBackDictModel() {
	return baseMapper.queryAllDepartBackDictModel();
}
 

public void setInclude(List<DictModel> include) {
	this.include = include;
}
 

/**
 * 获取字典数据
 * @param dictCode 字典code
 * @param dictCode 表名,文本字段,code字段  | 举例：sys_user,realname,id
 * @return
 */
@RequestMapping(value = "/getDictItems/{dictCode}", method = RequestMethod.GET)
public Result<List<DictModel>> getDictItems(@PathVariable String dictCode) {
	log.info(" dictCode : "+ dictCode);
	Result<List<DictModel>> result = new Result<List<DictModel>>();
	List<DictModel> ls = null;
	try {
		if(dictCode.indexOf(",")!=-1) {
			//关联表字典（举例：sys_user,realname,id）
			String[] params = dictCode.split(",");
			
			if(params.length<3) {
				result.error500("字典Code格式不正确！");
				return result;
			}
			//SQL注入校验（只限制非法串改数据库）
			final String[] sqlInjCheck = {params[0],params[1],params[2]};
			SqlInjectionUtil.filterContent(sqlInjCheck);
			
			if(params.length==4) {
				//SQL注入校验（查询条件SQL 特殊check，此方法仅供此处使用）
				SqlInjectionUtil.specialFilterContent(params[3]);
				ls = sysDictService.queryTableDictItemsByCodeAndFilter(params[0],params[1],params[2],params[3]);
			}else if (params.length==3) {
				ls = sysDictService.queryTableDictItemsByCode(params[0],params[1],params[2]);
			}else{
				result.error500("字典Code格式不正确！");
				return result;
			}
		}else {
			//字典表
			 ls = sysDictService.queryDictItemsByCode(dictCode);
		}

		 result.setSuccess(true);
		 result.setResult(ls);
		 log.info(result.toString());
	} catch (Exception e) {
		log.error(e.getMessage(),e);
		result.error500("操作失败");
		return result;
	}

	return result;
}
 

@Override
public DictModel getParentDepartId(String departId) {
	SysDepart depart = departMapper.getParentDepartId(departId);
	DictModel model = new DictModel(depart.getId(),depart.getParentId());
	return model;
}
 

/**
 * 获取字典数据
 * @param dictCode 字典code
 * @param dictCode 表名,文本字段,code字段  | 举例：sys_user,realname,id
 * @return
 */
@RequestMapping(value = "/getDictItems/{dictCode}", method = RequestMethod.GET)
public Result<List<DictModel>> getDictItems(@PathVariable String dictCode) {
	log.info(" dictCode : "+ dictCode);
	Result<List<DictModel>> result = new Result<List<DictModel>>();
	List<DictModel> ls = null;
	try {
		if(dictCode.indexOf(",")!=-1) {
			//关联表字典（举例：sys_user,realname,id）
			String[] params = dictCode.split(",");
			
			if(params.length<3) {
				result.error500("字典Code格式不正确！");
				return result;
			}
			//SQL注入校验（只限制非法串改数据库）
			final String[] sqlInjCheck = {params[0],params[1],params[2]};
			SqlInjectionUtil.filterContent(sqlInjCheck);
			
			if(params.length==4) {
				//SQL注入校验（查询条件SQL 特殊check，此方法仅供此处使用）
				SqlInjectionUtil.specialFilterContent(params[3]);
				ls = sysDictService.queryTableDictItemsByCodeAndFilter(params[0],params[1],params[2],params[3]);
			}else if (params.length==3) {
				ls = sysDictService.queryTableDictItemsByCode(params[0],params[1],params[2]);
			}else{
				result.error500("字典Code格式不正确！");
				return result;
			}
		}else {
			//字典表
			 ls = sysDictService.queryDictItemsByCode(dictCode);
		}

		 result.setSuccess(true);
		 result.setResult(ls);
		 log.info(result.toString());
	} catch (Exception e) {
		log.error(e.getMessage(),e);
		result.error500("操作失败");
		return result;
	}

	return result;
}
 

public void setInclude(List<DictModel> include) {
	this.include = include;
}
 

public List<DictModel> getInclude() {
	return include;
}
 

/** 查询所有的父级字典，按照create_time排序 */
public List<DictModel> queryAllDict();