From d64ce641aa6985cf531abe819ea7991f4fd2ec94 Mon Sep 17 00:00:00 2001 From: 이민희 <mhlee@maprex.co.kr> Date: 화, 14 12월 2021 20:20:13 +0900 Subject: [PATCH] 사용자등급, 프로젝트 엑셀 다운로드 오류 해결 --- src/main/java/kr/wisestone/owl/service/impl/UserLevelServiceImpl.java | 38 ++++++++++++++++++++++++++++++++++++-- 1 files changed, 36 insertions(+), 2 deletions(-) diff --git a/src/main/java/kr/wisestone/owl/service/impl/UserLevelServiceImpl.java b/src/main/java/kr/wisestone/owl/service/impl/UserLevelServiceImpl.java index eae1020..18831c2 100644 --- a/src/main/java/kr/wisestone/owl/service/impl/UserLevelServiceImpl.java +++ b/src/main/java/kr/wisestone/owl/service/impl/UserLevelServiceImpl.java @@ -24,6 +24,9 @@ import kr.wisestone.owl.web.form.ProjectForm; import kr.wisestone.owl.web.form.UserLevelForm; import kr.wisestone.owl.web.view.ExcelView; +import org.jsoup.Jsoup; +import org.slf4j.Logger; +import org.slf4j.LoggerFactory; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.data.domain.Pageable; import org.springframework.data.jpa.repository.JpaRepository; @@ -40,6 +43,8 @@ @Service public class UserLevelServiceImpl extends AbstractServiceImpl<UserLevel, Long, JpaRepository<UserLevel, Long>> implements UserLevelService { + + private static final Logger log = LoggerFactory.getLogger(IssueServiceImpl.class); @Autowired private UserLevelRepository userLevelRepository; @@ -238,7 +243,7 @@ // code_ko_KR �뿉 code紐� �꽕�젙 ExportExcelVo excelInfo = new ExportExcelVo(); - excelInfo.setFileName(this.messageAccessor.message("�궗�슜�옄 紐⑸줉")); + excelInfo.setFileName(this.messageAccessor.message("�궗�슜�옄 �벑湲� 紐⑸줉")); excelInfo.addAttrInfos(new ExportExcelAttrVo("levelName", this.messageAccessor.message("managementWorkspace.levelName"), 6, ExportExcelAttrVo.ALIGN_CENTER)); excelInfo.addAttrInfos(new ExportExcelAttrVo("permAllIssueAndProjectSetting", this.messageAccessor.message("manageUser.manageAllIssueAndProjectPerm"), 3, ExportExcelAttrVo.ALIGN_CENTER)); excelInfo.addAttrInfos(new ExportExcelAttrVo("permPartnerSetting", this.messageAccessor.message("manageUser.managePartnerPerm"), 3, ExportExcelAttrVo.ALIGN_CENTER)); @@ -251,12 +256,41 @@ excelInfo.addAttrInfos(new ExportExcelAttrVo("permQnA", this.messageAccessor.message("manageUser.manageQnAPerm"), 3, ExportExcelAttrVo.ALIGN_CENTER)); excelInfo.addAttrInfos(new ExportExcelAttrVo("permGuide", this.messageAccessor.message("manageUser.manageGuidePerm"), 3, ExportExcelAttrVo.ALIGN_CENTER)); - excelInfo.setDatas(userLevelVos); + // userLevelVos �뜲�씠�꽣瑜� �뿊���뿉�꽌 �몴�떆�븷 �닔 �엳�뒗 �뜲�씠�꽣濡� 蹂�寃쏀븳�떎. + List<Map<String, Object>> convertExcelViewToUserLevelMaps = this.convertExcelViewToUserLevelVos(userLevelVos); + excelInfo.setDatas(convertExcelViewToUserLevelMaps); model.addAttribute(Constants.EXCEL, excelInfo); return new ModelAndView(this.excelView); } + // userLevelVos �뜲�씠�꽣瑜� �뿊���뿉�꽌 �몴�떆�븷 �닔 �엳�뒗 �뜲�씠�꽣濡� 蹂�寃쏀븳�떎. + private List<Map<String, Object>> convertExcelViewToUserLevelVos(List<UserLevelVo> userLevelVos) { + List<Map<String, Object>> results = Lists.newArrayList(); + + for (UserLevelVo userLevelVo : userLevelVos){ + try { + Map<String, Object> result = new HashMap<>(); + result.put("levelName", userLevelVo.getLevelName()); + result.put("permAllIssueAndProjectSetting", userLevelVo.getPermAllIssueAndProjectSetting()); + result.put("permPartnerSetting", userLevelVo.getPermPartnerSetting()); + result.put("permWorkSpaceSetting", userLevelVo.getPermWorkSpaceSetting()); + result.put("permProjectSetting", userLevelVo.getPermProjectSetting()); + result.put("permIssueSetting", userLevelVo.getPermIssueSetting()); + result.put("permApi", userLevelVo.getPermApi()); + result.put("permNotice", userLevelVo.getPermNotice()); + result.put("permFAQ", userLevelVo.getPermFAQ()); + result.put("permQnA", userLevelVo.getPermQnA()); + result.put("permGuide", userLevelVo.getPermGuide()); + + results.add(result); + } catch (Exception e) { + log.error("�뿊�� �떎�슫濡쒕뱶 �삤瑜� 諛쒖깮"); + } + } + return results; + } + // �궗�슜�옄 �벑湲� �긽�깭瑜� 蹂�寃쏀븳�떎. @Override public void modifyLevelPermission(UserLevelForm userLevelForm) { -- Gitblit v1.8.0