package com.vci.frameworkcore.controller; import com.vci.dto.SmUserDTO; import com.vci.corba.common.PLException; import com.vci.frameworkcore.compatibility.SmUserQueryServiceI; import com.vci.constant.FrameWorkLangCodeConstant; import com.vci.pagemodel.SmUserVO; import com.vci.starter.web.annotation.controller.VciUnCheckRight; import com.vci.starter.web.exception.VciBaseException; import com.vci.starter.web.pagemodel.*; import com.vci.starter.web.util.ControllerUtil; import com.vci.starter.web.util.LangBaseUtil; import com.vci.starter.web.util.LocalFileUtil; import com.vci.starter.web.util.VciBaseUtil; import com.vci.web.util.Func; import org.apache.commons.lang3.StringUtils; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import org.springframework.web.multipart.MultipartFile; import javax.servlet.http.HttpServletResponse; import java.io.File; import java.io.IOException; import java.util.Date; import java.util.List; /** * 用户的查询控制器 * @author weidy * @date 2020/3/4 */ @RestController @RequestMapping("/userQueryController") public class SmUserQueryController { /** * 用户查询服务 */ @Autowired private SmUserQueryServiceI userQueryService; /** * 日志 */ private Logger logger = LoggerFactory.getLogger(getClass()); /** * 用户的列表参照, * @param queryObject 查询对象,包含了查询条件,分页,排序等,即允许使用SmUserVO里的所有属性作为查询条件,也可以使用pkRole.xxx,pkDepartment.xxx,pkDuty.xxx这样来查询 * @return 普通用户(不包含三员,也不包含停用的)的显示对象列表数据,请获取其中的data属性 * @throws VciBaseException 查询出错的时候会抛出异常,如果是老的项目里不抛出异常 */ @RequestMapping(value = "/refDataGrid",method = RequestMethod.GET) public BaseResult refDataGrid(BaseQueryObject queryObject) throws VciBaseException { //代码示例 if(queryObject == null){ queryObject = new BaseQueryObject(); } DataGrid userVODataGrid = userQueryService.refGridUsers(queryObject.getConditionMap(),queryObject.getPageHelper()); return BaseResult.dataGrid(userVODataGrid); //如果是老的项目,应该在refGridUsers上添加try,catch,然后catch里应该使用下面的代码 //BaseResult.fail("这里返回前端的错误信息"); } /** * 用户的树形参照 * @param treeQueryObject 树形数据的查询对象,包括查询条件,上级主键,是否多选等,即允许使用SmUserVO里的所有属性作为查询条件,也可以使用pkRole.xxx,pkDepartment.xxx,pkDuty.xxx这样来查询 * @return 普通用户(不包含三员,也不包含停用的)的树形数据,已经转换过上下级关系,请获取其中的treeData属性 * @throws VciBaseException 查询出错的时候会抛出异常,如果是老的项目里不抛出异常 */ @RequestMapping(value = "/refTree",method = RequestMethod.GET) public BaseResult refTree(TreeQueryObject treeQueryObject) throws VciBaseException{ List userTreeList = userQueryService.refTreeUsers(treeQueryObject); return BaseResult.tree(userTreeList); //老的项目依然是添加try catch,方法里不抛出异常 //BaseResult.fail("这里返回前端的错误信息"); } /** * 部门管理统计按钮,查询接口 * @param pkDepartment * @param queryObject * @return 包含子部门下的用户 * @throws VciBaseException */ @RequestMapping(value = "/countSmUserByDeptOid",method = RequestMethod.GET) public BaseResult> countSmUserByDeptOid(String pkDepartment,BaseQueryObject queryObject) throws VciBaseException{ //VciBaseUtil.alertNotNull(pkDepartment,"部门主键");允许为空因为会出现统计所有部门这个节点的情况 try { if(queryObject == null){ queryObject = new BaseQueryObject(); } List userVODataGrid = userQueryService.countSmUserByDeptOid(pkDepartment, queryObject.getConditionMap()); return BaseResult.dataList(userVODataGrid); }catch (Exception e){ e.printStackTrace(); String exceptionMessage = "通过部门主键获取在该部门下的,用户参照列表时出现错误,原因:" + VciBaseUtil.getExceptionMessage(e); logger.error(exceptionMessage); return BaseResult.fail(exceptionMessage); } } /** * 使用部门主键获取,在该部门下的用户用户参照列表 * @param pkDepartment 部门的主键,不能为空 * @param queryObject 查询对象,包含查询条件,分页,排序等,即允许使用SmUserVO里的所有属性作为查询条件,也可以使用pkRole.xxx,pkDepartment.xxx,pkDuty.xxx这样来查询 * @return 普通用户(不包含三员,也不包含停用的)的显示对象列表数据,请获取其中的data属性 * @throws VciBaseException 部门主键为空、查询出错的时候会抛出异常,如果是老的项目里不抛出异常 */ @RequestMapping(value = "/listUserByDeptOid",method = RequestMethod.GET) public BaseResult> listUserByDeptOid(String pkDepartment,BaseQueryObject queryObject) throws VciBaseException{ VciBaseUtil.alertNotNull(pkDepartment,"部门主键"); try { if(queryObject == null){ queryObject = new BaseQueryObject(); } List userVODataGrid = userQueryService.listUserByDeptOid(pkDepartment, queryObject.getConditionMap()); return BaseResult.dataList(userVODataGrid); }catch (Exception e){ e.printStackTrace(); String exceptionMessage = "通过部门主键获取在该部门下的,用户参照列表时出现错误,原因:" + VciBaseUtil.getExceptionMessage(e); logger.error(exceptionMessage); return BaseResult.fail(exceptionMessage); } } /** * 使用部门主键获取,不在该部门下的用户用户参照列表 * @param pkDepartment 部门的主键,不能为空 * @param queryObject 查询对象,包含查询条件,分页,排序等,即允许使用SmUserVO里的所有属性作为查询条件,也可以使用pkRole.xxx,pkDepartment.xxx,pkDuty.xxx这样来查询 * @return 根据当前登录的用户决定查那些用户出来,的显示对象列表数据,请获取其中的data属性 * @throws VciBaseException 部门主键为空、查询出错的时候会抛出异常,如果是老的项目里不抛出异常 */ @RequestMapping(value = "/listUserUnInDeptOid",method = RequestMethod.GET) public BaseResult> listUserUnInDeptOid(String pkDepartment,BaseQueryObject queryObject) throws VciBaseException{ VciBaseUtil.alertNotNull(pkDepartment,"部门主键"); try { if(queryObject == null){ queryObject = new BaseQueryObject(); } List userVODataGrid = userQueryService.listUserUnInDeptOid(pkDepartment, queryObject.getConditionMap()); return BaseResult.dataList(userVODataGrid); }catch (Exception e){ e.printStackTrace(); String exceptionMessage = "通过部门主键获取不在该部门下的,用户参照列表时出现错误,原因:" + VciBaseUtil.getExceptionMessage(e); logger.error(exceptionMessage); return BaseResult.fail(exceptionMessage); } } /** * 使用角色获取关联的用户参照列表:被停用的用户也会查出来 * @param pkRole 角色的主键,不能为空 * @param queryObject 查询对象,包含查询条件,分页,排序等 * @return * @throws VciBaseException */ @RequestMapping(value = "/listUserByRoleOid",method = RequestMethod.GET) public BaseResult> listUserByRoleOid(String pkRole,BaseQueryObject queryObject) throws VciBaseException{ VciBaseUtil.alertNotNull(pkRole,"角色主键"); try { if(queryObject == null){ queryObject = new BaseQueryObject(); } List smUserVOList = userQueryService.listUserByRoleOid(pkRole, queryObject.getConditionMap()); return BaseResult.dataList(smUserVOList); }catch (Exception e){ e.printStackTrace(); String exceptionMessage = "通过角色来获取用户的参照列表时出现错误,原因:" + VciBaseUtil.getExceptionMessage(e); logger.error(exceptionMessage); return BaseResult.fail(exceptionMessage); } } /** * 使用当前用户的类型查询用户 * @return * @throws VciBaseException */ @RequestMapping(value = "/listUserByUserType",method = RequestMethod.GET) public BaseResult> listUserByUserType() throws VciBaseException{ try { List smUserVOList = userQueryService.listUserByUserType(); return BaseResult.dataList(smUserVOList); }catch (Exception e){ e.printStackTrace(); String exceptionMessage = "通过当前用户的类型来获取用户数据时出现错误,原因:" + VciBaseUtil.getExceptionMessage(e); logger.error(exceptionMessage); return BaseResult.fail(exceptionMessage); } } /** * 使用角色获取不在某个角色下的用户参照列表 * @param pkRole 角色的主键,不能为空 * @param queryObject 查询对象,包含查询条件,分页,排序等 * @return * @throws VciBaseException */ @RequestMapping(value = "/listUserUnInRoleOid",method = RequestMethod.GET) public BaseResult> listUserUnInRoleOid(String pkRole,BaseQueryObject queryObject) throws VciBaseException{ VciBaseUtil.alertNotNull(pkRole,"角色主键"); try { if(queryObject == null){ queryObject = new BaseQueryObject(); } List smUserVOList = userQueryService.listUserUnInRoleOid(pkRole, queryObject.getConditionMap()); return BaseResult.dataList(smUserVOList); }catch (Exception e){ e.printStackTrace(); String exceptionMessage = "获取不在当前角色下的,用户参照列表时出现错误,原因:" + VciBaseUtil.getExceptionMessage(e); logger.error(exceptionMessage); return BaseResult.fail(exceptionMessage); } } /** * 修改密码 * @param userName 用户名 * @param password 新密码 * @param confirmPassword 确认密码 */ @RequestMapping(value = "/changePassword",method = RequestMethod.POST) @VciUnCheckRight public BaseResult changePassword(String userName,String oldPassword, String password, String confirmPassword) throws PLException { try { return userQueryService.changePassword(userName, oldPassword, password, confirmPassword) ? BaseResult.success(true,"用户修改成功!"):BaseResult.fail("用户修改失败!"); }catch (Exception e){ e.printStackTrace(); String exceptionMessage = "修改密码时出现错误,原因:" + VciBaseUtil.getExceptionMessage(e); logger.error(exceptionMessage); return BaseResult.fail(exceptionMessage); } } /** * 用户管理列表分页查询,平台是不查plusertype=0的成员,也就是developer和admin之类的账号 * @param queryObject 查询对象,包含了查询条件,分页,排序等,即允许使用SmUserVO里的所有属性作为查询条件,也可以使用pkRole.xxx,pkDepartment.xxx,pkDuty.xxx这样来查询 * @return 全部用户显示对象列表数据,请获取其中的data属性 * @throws VciBaseException 查询出错的时候会抛出异常,如果是老的项目里不抛出异常 */ @RequestMapping(value = "/getDataGridUsers",method = RequestMethod.GET) public BaseResult getDataGridUsers(BaseQueryObject queryObject) throws VciBaseException { try { DataGrid userVODataGrid = userQueryService.getDataGridUsers(queryObject.getConditionMap(),queryObject.getPageHelper()); return BaseResult.dataGrid(userVODataGrid); }catch (Exception e) { e.printStackTrace(); String exceptionMessage = "用户管理列表查询时出现错误,原因:" + VciBaseUtil.getExceptionMessage(e); logger.error(exceptionMessage); return BaseResult.fail(exceptionMessage); } } /** * 添加用户 * @param smUserDTO * @return */ @RequestMapping(value = "/addUser",method = RequestMethod.POST) public BaseResult addUser(@RequestBody SmUserDTO smUserDTO){ try { return userQueryService.addUser(smUserDTO) ? BaseResult.success("用户添加成功!"):BaseResult.fail("用户添加失败!"); }catch (Exception e){ e.printStackTrace(); String exceptionMessage = "添加用户时出现错误,原因:" + VciBaseUtil.getExceptionMessage(e); logger.error(exceptionMessage); return BaseResult.fail(exceptionMessage); } } /** * 修改用户信息 * @param smUserDTO * @return */ @RequestMapping(value = "/updateUser",method = RequestMethod.PUT) public BaseResult updateUser(@RequestBody SmUserDTO smUserDTO){ try { return userQueryService.updateUser(smUserDTO) ? BaseResult.success("用户修改成功!"):BaseResult.fail("用户修改失败!"); }catch (Exception e){ e.printStackTrace(); String exceptionMessage = "修改用户时出现错误,原因:" + VciBaseUtil.getExceptionMessage(e); logger.error(exceptionMessage); return BaseResult.fail(exceptionMessage); } } /** * 删除用户 * @param ids * @return */ @RequestMapping(value = "/deleteUser",method = RequestMethod.DELETE) public BaseResult deleteUser(String[] ids){ try { return userQueryService.deleteUser(ids) ? BaseResult.success("删除用户成功!"):BaseResult.fail("删除用户失败!"); }catch (Exception e){ e.printStackTrace(); String exceptionMessage = "添加用户时出现错误,原因:" + VciBaseUtil.getExceptionMessage(e); logger.error(exceptionMessage); return BaseResult.fail(exceptionMessage); } } /** * 用户停用/启用 * @param ids * @param flag * @return */ @RequestMapping(value = "/stopUsers",method = RequestMethod.POST) public BaseResult stopUsers(String[] ids,boolean flag){ try { userQueryService.stopUsers(ids,flag); return BaseResult.success("用户【停用/启用】成功!"); }catch (Exception e){ e.printStackTrace(); String exceptionMessage = "用户【停用/启用】时出现错误,原因:" + VciBaseUtil.getExceptionMessage(e); logger.error(exceptionMessage); return BaseResult.fail(exceptionMessage); } } /** * 下载人员导入模板 * @param downloadFileName * @param response */ @RequestMapping(value = "/downloadImportTemplate",method = RequestMethod.GET) public void downloadImportTemplate(String downloadFileName, HttpServletResponse response){ try { String excelPath = userQueryService.downloadImportTemplate(downloadFileName); ControllerUtil.writeFileToResponse(response,excelPath); } catch (Exception e) { String msg = "下载用户导入模板时出现错误,原因:" + LangBaseUtil.getErrorMsg(e); try { e.printStackTrace(); ControllerUtil.writeDataToResponse(response,"error_" + Func.format(new Date(),"yyyy-MM-dd HHmmss.sss") + ".txt", StringUtils.isNotBlank(msg)?msg.getBytes():new byte[0],null); } catch (IOException ioException) { ioException.printStackTrace(); } } } /** * 人员导入 * @param file * @return */ @RequestMapping(value = "/importUser",method = RequestMethod.POST) public BaseResult importUser(MultipartFile file){ String excelFileName = LocalFileUtil.getDefaultTempFolder() + File.separator + LocalFileUtil.getFileNameForIE(file.getOriginalFilename()); File file1 = new File(excelFileName); try { file.transferTo(new File(excelFileName)); if (file != null) { return userQueryService.importUser(file1); } else { return BaseResult.fail(FrameWorkLangCodeConstant.IMPORT_FAIL, new String[]{"无导入的文件"}); } }catch (Throwable e) { throw new VciBaseException(e.getMessage(),new String[0],e); }finally { file1.delete(); } } /** * 用户权限选择树 * @param treeQueryObject 树形数据的查询对象,包括查询条件,上级主键,是否多选等,即允许使用SmUserVO里的所有属性作为查询条件,也可以使用pkRole.xxx,pkDepartment.xxx,pkDuty.xxx这样来查询 * @return 普通用户(不包含三员,也不包含停用的)的树形数据,已经转换过上下级关系,请获取其中的treeData属性 * @throws VciBaseException 查询出错的时候会抛出异常,如果是老的项目里不抛出异常 */ @RequestMapping(value = "/refPersonOrgTree",method = RequestMethod.GET) public BaseResult refPersonOrgTree(TreeQueryObject treeQueryObject) throws VciBaseException{ List userTreeList = userQueryService.refPersonOrgTree(treeQueryObject); return BaseResult.tree(userTreeList); //老的项目依然是添加try catch,方法里不抛出异常 //BaseResult.fail("这里返回前端的错误信息"); } }