org.jeecg.modules.system.entity.SysCategory Java Examples

/**
 * [列表页面]加载分类字典数据 用于值的替换
 * @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;
}
 

/**
 * 校验编码
 * @param pid
 * @param code
 * @return
 */
@GetMapping(value = "/checkCode")
public Result<?> checkCode(@RequestParam(name="pid",required = false) String pid,@RequestParam(name="code",required = false) String code) {
if(oConvertUtils.isEmpty(code)){
	return Result.error("错误,类型编码为空!");
}
if(oConvertUtils.isEmpty(pid)){
	return Result.ok();
}
SysCategory parent = this.sysCategoryService.getById(pid);
if(code.startsWith(parent.getCode())){
	return Result.ok();
}else{
	return Result.error("编码不符合规范,须以\""+parent.getCode()+"\"开头!");
}

}
 

/**
 * 校验编码
 * @param pid
 * @param code
 * @return
 */
@GetMapping(value = "/checkCode")
public Result<?> checkCode(@RequestParam(name="pid",required = false) String pid,@RequestParam(name="code",required = false) String code) {
if(oConvertUtils.isEmpty(code)){
	return Result.error("错误,类型编码为空!");
}
if(oConvertUtils.isEmpty(pid)){
	return Result.ok();
}
SysCategory parent = this.sysCategoryService.getById(pid);
if(code.startsWith(parent.getCode())){
	return Result.ok();
}else{
	return Result.error("编码不符合规范,须以\""+parent.getCode()+"\"开头!");
}

}
 

/**
 * [列表页面]加载分类字典数据 用于值的替换
 * @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;
}
 

/**
   * 加载单个数据 用于回显
 */
  @RequestMapping(value = "/loadOne", method = RequestMethod.GET)
public Result<SysCategory> loadOne(@RequestParam(name="field") String field,@RequestParam(name="val") String val) {
	Result<SysCategory> result = new Result<SysCategory>();
	try {
		
		QueryWrapper<SysCategory> query = new QueryWrapper<SysCategory>();
		query.eq(field, val);
		List<SysCategory> ls = this.sysCategoryService.list(query);
		if(ls==null || ls.size()==0) {
			result.setMessage("查询无果");
 			result.setSuccess(false);
		}else if(ls.size()>1) {
			result.setMessage("查询数据异常,["+field+"]存在多个值:"+val);
 			result.setSuccess(false);
		}else {
			result.setSuccess(true);
			result.setResult(ls.get(0));
		}
	} catch (Exception e) {
		e.printStackTrace();
		result.setMessage(e.getMessage());
		result.setSuccess(false);
	}
	return result;
}
 

/**
    * 导出excel
 *
 * @param request
 * @param response
 */
@RequestMapping(value = "/exportXls")
public ModelAndView exportXls(HttpServletRequest request, SysCategory sysCategory) {
    // Step.1 组装查询条件查询数据
    QueryWrapper<SysCategory> queryWrapper = QueryGenerator.initQueryWrapper(sysCategory, request.getParameterMap());
    List<SysCategory> pageList = sysCategoryService.list(queryWrapper);
    // Step.2 AutoPoi 导出Excel
    ModelAndView mv = new ModelAndView(new JeecgEntityExcelView());
    // 过滤选中数据
    String selections = request.getParameter("selections");
    if(oConvertUtils.isEmpty(selections)) {
  	  mv.addObject(NormalExcelConstants.DATA_LIST, pageList);
    }else {
  	  List<String> selectionList = Arrays.asList(selections.split(","));
  	  List<SysCategory> exportList = pageList.stream().filter(item -> selectionList.contains(item.getId())).collect(Collectors.toList());
  	  mv.addObject(NormalExcelConstants.DATA_LIST, exportList);
    }
    //导出文件名称
    mv.addObject(NormalExcelConstants.FILE_NAME, "分类字典列表");
    mv.addObject(NormalExcelConstants.CLASS, SysCategory.class);
    LoginUser user = (LoginUser) SecurityUtils.getSubject().getPrincipal();
    mv.addObject(NormalExcelConstants.PARAMS, new ExportParams("分类字典列表数据", "导出人:"+user.getRealname(), "导出信息"));
    return mv;
}
 

/**
 * 分类字典控件数据回显[表单页面]
 * @param key
 * @return
 */
@RequestMapping(value = "/loadDictItem", method = RequestMethod.GET)
public Result<List<String>> loadDictItem(@RequestParam(name="ids") String ids) {
 Result<List<String>> result = new Result<>();
 LambdaQueryWrapper<SysCategory> query = new LambdaQueryWrapper<SysCategory>().in(SysCategory::getId,ids);
 List<SysCategory> list = this.sysCategoryService.list(query);
 List<String> textList = new ArrayList<String>();
 for (String id : ids.split(",")) {
	 for (SysCategory c : list) {
		if(id.equals(c.getId())){
			textList.add(c.getName());
			break;
		}
	 }
 }
 result.setSuccess(true);
 result.setResult(textList);
 return result;
}
 

/**
   * 加载单个数据 用于回显
 */
  @RequestMapping(value = "/loadOne", method = RequestMethod.GET)
public Result<SysCategory> loadOne(@RequestParam(name="field") String field,@RequestParam(name="val") String val) {
	Result<SysCategory> result = new Result<SysCategory>();
	try {
		
		QueryWrapper<SysCategory> query = new QueryWrapper<SysCategory>();
		query.eq(field, val);
		List<SysCategory> ls = this.sysCategoryService.list(query);
		if(ls==null || ls.size()==0) {
			result.setMessage("查询无果");
 			result.setSuccess(false);
		}else if(ls.size()>1) {
			result.setMessage("查询数据异常,["+field+"]存在多个值:"+val);
 			result.setSuccess(false);
		}else {
			result.setSuccess(true);
			result.setResult(ls.get(0));
		}
	} catch (Exception e) {
		e.printStackTrace();
		result.setMessage(e.getMessage());
		result.setSuccess(false);
	}
	return result;
}
 

/**
    * 导出excel
 *
 * @param request
 */
@RequestMapping(value = "/exportXls")
public ModelAndView exportXls(HttpServletRequest request, SysCategory sysCategory) {
    // Step.1 组装查询条件查询数据
    QueryWrapper<SysCategory> queryWrapper = QueryGenerator.initQueryWrapper(sysCategory, request.getParameterMap());
    List<SysCategory> pageList = sysCategoryService.list(queryWrapper);
    // Step.2 AutoPoi 导出Excel
    ModelAndView mv = new ModelAndView(new JeecgEntityExcelView());
    // 过滤选中数据
    String selections = request.getParameter("selections");
    if(oConvertUtils.isEmpty(selections)) {
  	  mv.addObject(NormalExcelConstants.DATA_LIST, pageList);
    }else {
  	  List<String> selectionList = Arrays.asList(selections.split(","));
  	  List<SysCategory> exportList = pageList.stream().filter(item -> selectionList.contains(item.getId())).collect(Collectors.toList());
  	  mv.addObject(NormalExcelConstants.DATA_LIST, exportList);
    }
    //导出文件名称
    mv.addObject(NormalExcelConstants.FILE_NAME, "分类字典列表");
    mv.addObject(NormalExcelConstants.CLASS, SysCategory.class);
    LoginUser user = (LoginUser) SecurityUtils.getSubject().getPrincipal();
    mv.addObject(NormalExcelConstants.PARAMS, new ExportParams("分类字典列表数据", "导出人:"+user.getRealname(), "导出信息"));
    return mv;
}
 

/**
 * 分类字典控件数据回显[表单页面]
 * @param key
 * @return
 */
@RequestMapping(value = "/loadDictItem", method = RequestMethod.GET)
public Result<List<String>> loadDictItem(@RequestParam(name="ids") String ids) {
 Result<List<String>> result = new Result<>();
 LambdaQueryWrapper<SysCategory> query = new LambdaQueryWrapper<SysCategory>().in(SysCategory::getId,ids);
 List<SysCategory> list = this.sysCategoryService.list(query);
 List<String> textList = new ArrayList<String>();
 for (String id : ids.split(",")) {
	 for (SysCategory c : list) {
		if(id.equals(c.getId())){
			textList.add(c.getName());
			break;
		}
	 }
 }
 result.setSuccess(true);
 result.setResult(textList);
 return result;
}
 

/**
 * [列表页面]加载分类字典数据 用于值的替换
 * @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;
}
 

/**
  *   通过id删除
 * @param id
 * @return
 */
@DeleteMapping(value = "/delete")
public Result<SysCategory> delete(@RequestParam(name="id",required=true) String id) {
	Result<SysCategory> result = new Result<SysCategory>();
	SysCategory sysCategory = sysCategoryService.getById(id);
	if(sysCategory==null) {
		result.error500("未找到对应实体");
	}else {
		boolean ok = sysCategoryService.removeById(id);
		if(ok) {
			result.success("删除成功!");
		}
	}
	
	return result;
}
 

/**
  *   通过id删除
 * @param id
 * @return
 */
@DeleteMapping(value = "/delete")
public Result<SysCategory> delete(@RequestParam(name="id",required=true) String id) {
	Result<SysCategory> result = new Result<SysCategory>();
	SysCategory sysCategory = sysCategoryService.getById(id);
	if(sysCategory==null) {
		result.error500("未找到对应实体");
	}else {
		boolean ok = sysCategoryService.removeById(id);
		if(ok) {
			result.success("删除成功!");
		}
	}
	
	return result;
}
 

/**
    * 导出excel
 *
 * @param request
 */
@RequestMapping(value = "/exportXls")
public ModelAndView exportXls(HttpServletRequest request, SysCategory sysCategory) {
    // Step.1 组装查询条件查询数据
    QueryWrapper<SysCategory> queryWrapper = QueryGenerator.initQueryWrapper(sysCategory, request.getParameterMap());
    List<SysCategory> pageList = sysCategoryService.list(queryWrapper);
    // Step.2 AutoPoi 导出Excel
    ModelAndView mv = new ModelAndView(new JeecgEntityExcelView());
    // 过滤选中数据
    String selections = request.getParameter("selections");
    if(oConvertUtils.isEmpty(selections)) {
  	  mv.addObject(NormalExcelConstants.DATA_LIST, pageList);
    }else {
  	  List<String> selectionList = Arrays.asList(selections.split(","));
  	  List<SysCategory> exportList = pageList.stream().filter(item -> selectionList.contains(item.getId())).collect(Collectors.toList());
  	  mv.addObject(NormalExcelConstants.DATA_LIST, exportList);
    }
    //导出文件名称
    mv.addObject(NormalExcelConstants.FILE_NAME, "分类字典列表");
    mv.addObject(NormalExcelConstants.CLASS, SysCategory.class);
    LoginUser user = (LoginUser) SecurityUtils.getSubject().getPrincipal();
    mv.addObject(NormalExcelConstants.PARAMS, new ExportParams("分类字典列表数据", "导出人:"+user.getRealname(), "导出信息"));
    return mv;
}
 

/**
   * 加载单个数据 用于回显
 */
  @RequestMapping(value = "/loadOne", method = RequestMethod.GET)
public Result<SysCategory> loadOne(@RequestParam(name="field") String field,@RequestParam(name="val") String val) {
	Result<SysCategory> result = new Result<SysCategory>();
	try {
		
		QueryWrapper<SysCategory> query = new QueryWrapper<SysCategory>();
		query.eq(field, val);
		List<SysCategory> ls = this.sysCategoryService.list(query);
		if(ls==null || ls.size()==0) {
			result.setMessage("查询无果");
 			result.setSuccess(false);
		}else if(ls.size()>1) {
			result.setMessage("查询数据异常,["+field+"]存在多个值:"+val);
 			result.setSuccess(false);
		}else {
			result.setSuccess(true);
			result.setResult(ls.get(0));
		}
	} catch (Exception e) {
		e.printStackTrace();
		result.setMessage(e.getMessage());
		result.setSuccess(false);
	}
	return result;
}
 

/**
  * 分页列表查询
 * @param sysCategory
 * @param pageNo
 * @param pageSize
 * @param req
 * @return
 */
@GetMapping(value = "/rootList")
public Result<IPage<SysCategory>> queryPageList(SysCategory sysCategory,
								  @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
								  @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
								  HttpServletRequest req) {
	if(oConvertUtils.isEmpty(sysCategory.getPid())){
		sysCategory.setPid("0");
	}
	Result<IPage<SysCategory>> result = new Result<IPage<SysCategory>>();
	
	//--author:os_chengtgen---date:20190804 -----for: 分类字典页面显示错误,issues:377--------start
	//QueryWrapper<SysCategory> queryWrapper = QueryGenerator.initQueryWrapper(sysCategory, req.getParameterMap());
	QueryWrapper<SysCategory> queryWrapper = new QueryWrapper<SysCategory>();
	queryWrapper.eq("pid", sysCategory.getPid());
	//--author:os_chengtgen---date:20190804 -----for: 分类字典页面显示错误,issues:377--------end
	
	Page<SysCategory> page = new Page<SysCategory>(pageNo, pageSize);
	IPage<SysCategory> pageList = sysCategoryService.page(page, queryWrapper);
	result.setSuccess(true);
	result.setResult(pageList);
	return result;
}
 

/**
  *   通过id删除
 * @param id
 * @return
 */
@DeleteMapping(value = "/delete")
public Result<SysCategory> delete(@RequestParam(name="id",required=true) String id) {
	Result<SysCategory> result = new Result<SysCategory>();
	SysCategory sysCategory = sysCategoryService.getById(id);
	if(sysCategory==null) {
		result.error500("未找到对应实体");
	}else {
		boolean ok = sysCategoryService.removeById(id);
		if(ok) {
			result.success("删除成功!");
		}
	}
	
	return result;
}
 

/**
 * 校验编码
 * @param pid
 * @param code
 * @return
 */
@GetMapping(value = "/checkCode")
public Result<?> checkCode(@RequestParam(name="pid",required = false) String pid,@RequestParam(name="code",required = false) String code) {
if(oConvertUtils.isEmpty(code)){
	return Result.error("错误,类型编码为空!");
}
if(oConvertUtils.isEmpty(pid)){
	return Result.ok();
}
SysCategory parent = this.sysCategoryService.getById(pid);
if(code.startsWith(parent.getCode())){
	return Result.ok();
}else{
	return Result.error("编码不符合规范,须以\""+parent.getCode()+"\"开头!");
}

}
 

/**
  * 分页列表查询
 * @param sysCategory
 * @param pageNo
 * @param pageSize
 * @param req
 * @return
 */
@GetMapping(value = "/rootList")
public Result<IPage<SysCategory>> queryPageList(SysCategory sysCategory,
								  @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
								  @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
								  HttpServletRequest req) {
	if(oConvertUtils.isEmpty(sysCategory.getPid())){
		sysCategory.setPid("0");
	}
	Result<IPage<SysCategory>> result = new Result<IPage<SysCategory>>();
	
	//--author:os_chengtgen---date:20190804 -----for: 分类字典页面显示错误,issues:377--------start
	//QueryWrapper<SysCategory> queryWrapper = QueryGenerator.initQueryWrapper(sysCategory, req.getParameterMap());
	QueryWrapper<SysCategory> queryWrapper = new QueryWrapper<SysCategory>();
	queryWrapper.eq("pid", sysCategory.getPid());
	//--author:os_chengtgen---date:20190804 -----for: 分类字典页面显示错误,issues:377--------end
	
	Page<SysCategory> page = new Page<SysCategory>(pageNo, pageSize);
	IPage<SysCategory> pageList = sysCategoryService.page(page, queryWrapper);
	result.setSuccess(true);
	result.setResult(pageList);
	return result;
}
 

/**
  *   通过id删除
 * @param id
 * @return
 */
@DeleteMapping(value = "/delete")
public Result<SysCategory> delete(@RequestParam(name="id",required=true) String id) {
	Result<SysCategory> result = new Result<SysCategory>();
	SysCategory sysCategory = sysCategoryService.getById(id);
	if(sysCategory==null) {
		result.error500("未找到对应实体");
	}else {
		boolean ok = sysCategoryService.removeById(id);
		if(ok) {
			result.success("删除成功!");
		}
	}
	
	return result;
}
 

/**
 * 分类字典控件数据回显[表单页面]
 * @param key
 * @return
 */
@RequestMapping(value = "/loadDictItem", method = RequestMethod.GET)
public Result<List<String>> loadDictItem(@RequestParam(name="ids") String ids) {
 Result<List<String>> result = new Result<>();
 LambdaQueryWrapper<SysCategory> query = new LambdaQueryWrapper<SysCategory>().in(SysCategory::getId,ids);
 List<SysCategory> list = this.sysCategoryService.list(query);
 List<String> textList = new ArrayList<String>();
 for (String id : ids.split(",")) {
	 for (SysCategory c : list) {
		if(id.equals(c.getId())){
			textList.add(c.getName());
			break;
		}
	 }
 }
 result.setSuccess(true);
 result.setResult(textList);
 return result;
}
 

/**
  * 分页列表查询
 * @param sysCategory
 * @param pageNo
 * @param pageSize
 * @param req
 * @return
 */
@GetMapping(value = "/rootList")
public Result<IPage<SysCategory>> queryPageList(SysCategory sysCategory,
								  @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
								  @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
								  HttpServletRequest req) {
	if(oConvertUtils.isEmpty(sysCategory.getPid())){
		sysCategory.setPid("0");
	}
	Result<IPage<SysCategory>> result = new Result<IPage<SysCategory>>();
	
	//--author:os_chengtgen---date:20190804 -----for: 分类字典页面显示错误,issues:377--------start
	//QueryWrapper<SysCategory> queryWrapper = QueryGenerator.initQueryWrapper(sysCategory, req.getParameterMap());
	QueryWrapper<SysCategory> queryWrapper = new QueryWrapper<SysCategory>();
	queryWrapper.eq("pid", sysCategory.getPid());
	//--author:os_chengtgen---date:20190804 -----for: 分类字典页面显示错误,issues:377--------end
	
	Page<SysCategory> page = new Page<SysCategory>(pageNo, pageSize);
	IPage<SysCategory> pageList = sysCategoryService.page(page, queryWrapper);
	result.setSuccess(true);
	result.setResult(pageList);
	return result;
}
 

/**
    * 导出excel
 *
 * @param request
 * @param response
 */
@RequestMapping(value = "/exportXls")
public ModelAndView exportXls(HttpServletRequest request, SysCategory sysCategory) {
    // Step.1 组装查询条件查询数据
    QueryWrapper<SysCategory> queryWrapper = QueryGenerator.initQueryWrapper(sysCategory, request.getParameterMap());
    List<SysCategory> pageList = sysCategoryService.list(queryWrapper);
    // Step.2 AutoPoi 导出Excel
    ModelAndView mv = new ModelAndView(new JeecgEntityExcelView());
    // 过滤选中数据
    String selections = request.getParameter("selections");
    if(oConvertUtils.isEmpty(selections)) {
  	  mv.addObject(NormalExcelConstants.DATA_LIST, pageList);
    }else {
  	  List<String> selectionList = Arrays.asList(selections.split(","));
  	  List<SysCategory> exportList = pageList.stream().filter(item -> selectionList.contains(item.getId())).collect(Collectors.toList());
  	  mv.addObject(NormalExcelConstants.DATA_LIST, exportList);
    }
    //导出文件名称
    mv.addObject(NormalExcelConstants.FILE_NAME, "分类字典列表");
    mv.addObject(NormalExcelConstants.CLASS, SysCategory.class);
    LoginUser user = (LoginUser) SecurityUtils.getSubject().getPrincipal();
    mv.addObject(NormalExcelConstants.PARAMS, new ExportParams("分类字典列表数据", "导出人:"+user.getRealname(), "导出信息"));
    return mv;
}
 

/**
   * 加载单个数据 用于回显
 */
  @RequestMapping(value = "/loadOne", method = RequestMethod.GET)
public Result<SysCategory> loadOne(@RequestParam(name="field") String field,@RequestParam(name="val") String val) {
	Result<SysCategory> result = new Result<SysCategory>();
	try {
		
		QueryWrapper<SysCategory> query = new QueryWrapper<SysCategory>();
		query.eq(field, val);
		List<SysCategory> ls = this.sysCategoryService.list(query);
		if(ls==null || ls.size()==0) {
			result.setMessage("查询无果");
 			result.setSuccess(false);
		}else if(ls.size()>1) {
			result.setMessage("查询数据异常,["+field+"]存在多个值:"+val);
 			result.setSuccess(false);
		}else {
			result.setSuccess(true);
			result.setResult(ls.get(0));
		}
	} catch (Exception e) {
		e.printStackTrace();
		result.setMessage(e.getMessage());
		result.setSuccess(false);
	}
	return result;
}
 

/**
 * 校验编码
 * @param pid
 * @param code
 * @return
 */
@GetMapping(value = "/checkCode")
public Result<?> checkCode(@RequestParam(name="pid",required = false) String pid,@RequestParam(name="code",required = false) String code) {
if(oConvertUtils.isEmpty(code)){
	return Result.error("错误,类型编码为空!");
}
if(oConvertUtils.isEmpty(pid)){
	return Result.ok();
}
SysCategory parent = this.sysCategoryService.getById(pid);
if(code.startsWith(parent.getCode())){
	return Result.ok();
}else{
	return Result.error("编码不符合规范,须以\""+parent.getCode()+"\"开头!");
}

}
 

/**
 * 分类字典控件数据回显[表单页面]
 * @param key
 * @return
 */
@RequestMapping(value = "/loadDictItem", method = RequestMethod.GET)
public Result<List<String>> loadDictItem(@RequestParam(name="ids") String ids) {
 Result<List<String>> result = new Result<>();
 LambdaQueryWrapper<SysCategory> query = new LambdaQueryWrapper<SysCategory>().in(SysCategory::getId,ids);
 List<SysCategory> list = this.sysCategoryService.list(query);
 List<String> textList = new ArrayList<String>();
 for (String id : ids.split(",")) {
	 for (SysCategory c : list) {
		if(id.equals(c.getId())){
			textList.add(c.getName());
			break;
		}
	 }
 }
 result.setSuccess(true);
 result.setResult(textList);
 return result;
}
 

/**
 * [列表页面]加载分类字典数据 用于值的替换
 * @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;
}
 

/**
  * 分页列表查询
 * @param sysCategory
 * @param pageNo
 * @param pageSize
 * @param req
 * @return
 */
@GetMapping(value = "/rootList")
public Result<IPage<SysCategory>> queryPageList(SysCategory sysCategory,
								  @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
								  @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
								  HttpServletRequest req) {
	if(oConvertUtils.isEmpty(sysCategory.getPid())){
		sysCategory.setPid("0");
	}
	Result<IPage<SysCategory>> result = new Result<IPage<SysCategory>>();
	
	//--author:os_chengtgen---date:20190804 -----for: 分类字典页面显示错误,issues:377--------start
	//QueryWrapper<SysCategory> queryWrapper = QueryGenerator.initQueryWrapper(sysCategory, req.getParameterMap());
	QueryWrapper<SysCategory> queryWrapper = new QueryWrapper<SysCategory>();
	queryWrapper.eq("pid", sysCategory.getPid());
	//--author:os_chengtgen---date:20190804 -----for: 分类字典页面显示错误,issues:377--------end
	
	Page<SysCategory> page = new Page<SysCategory>(pageNo, pageSize);
	IPage<SysCategory> pageList = sysCategoryService.page(page, queryWrapper);
	result.setSuccess(true);
	result.setResult(pageList);
	return result;
}
 

@Override
public void addSysCategory(SysCategory sysCategory) {
	String categoryCode = "";
	String categoryPid = ISysCategoryService.ROOT_PID_VALUE;
	String parentCode = null;
	if(oConvertUtils.isNotEmpty(sysCategory.getPid())){
		categoryPid = sysCategory.getPid();

		//PID 不是根节点 说明需要设置父节点 hasChild 为1
		if(!ISysCategoryService.ROOT_PID_VALUE.equals(categoryPid)){
			SysCategory parent = baseMapper.selectById(categoryPid);
			parentCode = parent.getCode();
			if(parent!=null && !"1".equals(parent.getHasChild())){
				parent.setHasChild("1");
				baseMapper.updateById(parent);
			}
		}
	}
	//update-begin--Author:baihailong  Date:20191209 for：分类字典编码规则生成器做成公用配置
	JSONObject formData = new JSONObject();
	formData.put("pid",categoryPid);
	categoryCode = (String) FillRuleUtil.executeRule("category_code_rule",formData);
	//update-end--Author:baihailong  Date:20191209 for：分类字典编码规则生成器做成公用配置
	sysCategory.setCode(categoryCode);
	sysCategory.setPid(categoryPid);
	baseMapper.insert(sysCategory);
}
 

/**
  * 通过id查询
 * @param id
 * @return
 */
@GetMapping(value = "/queryById")
public Result<SysCategory> queryById(@RequestParam(name="id",required=true) String id) {
	Result<SysCategory> result = new Result<SysCategory>();
	SysCategory sysCategory = sysCategoryService.getById(id);
	if(sysCategory==null) {
		result.error500("未找到对应实体");
	}else {
		result.setResult(sysCategory);
		result.setSuccess(true);
	}
	return result;
}