이슈관리 엑셀 다운로드 완료

이민희

2021-11-17 f1188ad883af2d5f27744686b91b197bcdb9fd8c

이슈관리 엑셀 다운로드 완료

 src/main/java/kr/wisestone/owl/service/impl/IssueServiceImpl.java

@@ -1519,7 +1519,7 @@
        excelInfo.addAttrInfos(new ExportExcelAttrVo("title", this.messageAccessor.message("common.issueTitle"), 40, ExportExcelAttrVo.ALIGN_LEFT)); // 이슈 제목
        excelInfo.addAttrInfos(new ExportExcelAttrVo("description", this.messageAccessor.message("common.content"), 60, ExportExcelAttrVo.ALIGN_LEFT)); // 내용
        excelInfo.addAttrInfos(new ExportExcelAttrVo("issueTypeName", this.messageAccessor.message("common.issueType"), 10, ExportExcelAttrVo.ALIGN_CENTER)); // 이슈 타입
        excelInfo.addAttrInfos(new ExportExcelAttrVo("department", this.messageAccessor.message("common.department"), 20, ExportExcelAttrVo.ALIGN_CENTER)); // 담당부서
        excelInfo.addAttrInfos(new ExportExcelAttrVo("departments", this.messageAccessor.message("common.department"), 20, ExportExcelAttrVo.ALIGN_CENTER)); // 담당부서
        excelInfo.addAttrInfos(new ExportExcelAttrVo("priorityName", this.messageAccessor.message("common.priority"), 6, ExportExcelAttrVo.ALIGN_CENTER)); // 우선순위
        excelInfo.addAttrInfos(new ExportExcelAttrVo("severityName", this.messageAccessor.message("common.importance"), 6, ExportExcelAttrVo.ALIGN_CENTER)); // 중요도
        excelInfo.addAttrInfos(new ExportExcelAttrVo("register", this.messageAccessor.message("common.register"), 20, ExportExcelAttrVo.ALIGN_CENTER)); // 등록자
@@ -1624,6 +1624,7 @@
                result.put("description", description);
                result.put("issueTypeName", issueVo.getIssueTypeName());
                result.put("assignees", CommonUtil.convertUserVosToString(issueVo.getUserVos()));
                result.put("departments", CommonUtil.convertDepartmentVosToString(issueVo.getDepartmentVos()));
                result.put("priorityName", issueVo.getPriorityName());
                result.put("severityName", issueVo.getSeverityName());


 src/main/java/kr/wisestone/owl/util/CommonUtil.java

@@ -6,6 +6,7 @@
import com.google.gson.Gson;
import kr.wisestone.owl.domain.enumType.FileType;
import kr.wisestone.owl.type.LikeType;
import kr.wisestone.owl.vo.DepartmentVo;
import kr.wisestone.owl.vo.UserVo;
import org.apache.commons.codec.binary.*;
import org.apache.commons.codec.binary.Base64;
@@ -690,6 +691,22 @@
        return stringBuilder.toString();
    }

    //  DepartmentVos 에서 부서 정보를 추출해서 문자열로 리턴해준다. - 주로 엑셀 download 에서 사용된다.
    public static String convertDepartmentVosToString(List<DepartmentVo> departmentVos) {
        StringBuilder stringBuilder = new StringBuilder();
        int count = 0;

        for (DepartmentVo departmentVo : departmentVos) {
            if (count > 0) {
                stringBuilder.append("\n");
            }

            stringBuilder.append(departmentVo.getDepartmentName());
            count++;
        }
        return stringBuilder.toString();
    }

    //  검색 일자를 구한다.
    public static List<Date> findSearchPeriod(String searchPeriod) {
        List<Date> searchDates = Lists.newArrayList();

 src/main/resources/mybatis/query-template/issue-template.xml

@@ -433,7 +433,7 @@
        SELECT
        i.id AS issueId,
        d.id AS id,
        d.department_name AS name
        d.department_name AS departmentName
        FROM issue i
        INNER JOIN issue_department issued ON issued.issue_id = i.id
        INNER JOIN department d ON d.id = issued.department_id