사용자등급, 프로젝트 엑셀 다운로드 오류 해결

이민희

2021-12-14 d64ce641aa6985cf531abe819ea7991f4fd2ec94

 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) {