OWL ITS + 탐지시스템(인터넷 진흥원)
blame | 히스토리 | 패치 | 커밋 | 커밋비교 | ignore whitespace
이민희
2022-02-07 11e27ddf54f5b4e2310591f74e8dd446e65a18ac 
 src/main/java/kr/wisestone/owl/service/impl/IssueServiceImpl.java


@@ -46,7 +46,11 @@




import javax.servlet.http.HttpServletRequest;


import java.io.IOException;


import java.text.SimpleDateFormat;


import java.util.*;




import static kr.wisestone.owl.domain.enumType.CustomFieldType.DATETIME;


import static kr.wisestone.owl.domain.enumType.CustomFieldType.INPUT;




@Service


public class IssueServiceImpl extends AbstractServiceImpl<Issue, Long, JpaRepository<Issue, Long>> implements IssueService {


@@ -85,6 +89,9 @@




    @Autowired


    private CompanyFieldService companyFieldService;




    @Autowired


    private CompanyFieldCategoryService companyFieldCategoryService;




    @Autowired


    private IspFieldService ispFieldService;


@@ -209,6 +216,9 @@


    @Autowired


    private IssueRelationMapper issueRelationMapper;




    @Autowired


    private WorkflowTransitionService workflowTransitionService;




    @Override


    protected JpaRepository<Issue, Long> getRepository() {


        return this.issueRepository;


@@ -259,6 +269,9 @@


            }


        } else if (issueApiForm.getIssueStatusId() == null){


            throw new ApiParameterException(this.messageAccessor.getMessage(MsgConstants.API_ISSUE_STATUS_NOT_EXIST));


        } else if (!this.workflowTransitionService.contains(issueApiForm.getIssueStatusId(), workflow.getId())) {


            //이슈 상태 유효성 확인


            throw new ApiParameterException(this.messageAccessor.getMessage(MsgConstants.API_ISSUE_STATUS_NOT_EXIST_IN_WORKFLOW));


        }




        // 프로젝트 입력


@@ -343,17 +356,17 @@


                    if(companyFields != null && companyFields.size() > 0) {


                        for (Map<String, Object> companyField : companyFields) {


                            CompanyFieldVo companyFieldVo = ConvertUtil.convertMapToClass(companyField, CompanyFieldVo.class);


                            if(useValue.equals(companyFieldVo.getUrl())) {


                            if(companyFieldVo.getUrl() != null && useValue.equals(companyFieldVo.getUrl())) {


                                companyField.put("companyId", companyField.get("id"));


                                issueCompanyFields.add(companyField);


                                if(companyFieldVo.getIspId() != null) {


                                if(companyFieldVo.getIspId() != null && companyFieldVo.getIspId() != -1) {


                                    Map<String, Object> ispField = this.ispFieldService.find(companyFieldVo.getIspId());


                                    if (ispField != null) {


                                        ispField.put("ispId", ispField.get("id"));


                                        issueIspFields.add(ispField);


                                    }


                                }


                                if(companyFieldVo.getHostingId() != null) {


                                if(companyFieldVo.getHostingId() != null && companyFieldVo.getHostingId() != -1) {


                                    Map<String, Object> hostingField = this.hostingFieldService.find(companyFieldVo.getHostingId());


                                    if (hostingField != null) {


                                        hostingField.put("hostingId", hostingField.get("id"));


@@ -477,6 +490,8 @@


    @Override


    @Transactional


    public Issue addIssue(User user, IssueForm issueForm, List<MultipartFile> multipartFiles) {


        StringBuilder detectIssueChange = new StringBuilder();




        //  사용하고 있는 업무 공간이 활성 상태인지 확인한다. 사용 공간에서 로그인한 사용자가 비활성인지 확인한다.


        Workspace workspace = this.workspaceService.checkUseWorkspace(user, user.getLastWorkspaceId());


        //  프로젝트 유효성 체크


@@ -519,11 +534,11 @@


        //  담당부서 지정


        this.issueDepartmentService.modifyIssueDepartment(issue, user, project.getWorkspace(), issueForm.getDepartmentIds());


        //  업체 정보 저장


        this.issueCompanyService.modifyIssueCompanyField(issue, issueForm);


        this.issueCompanyService.modifyIssueCompanyField(issue, issueForm, detectIssueChange);


        //  ISP 정보 저장


        this.issueIspService.modifyIssueIspField(issue, issueForm);


        this.issueIspService.modifyIssueIspField(issue, issueForm, detectIssueChange);


        //  HOSTING 정보 저장


        this.issueHostingService.modifyIssueHostingField(issue, issueForm);


        this.issueHostingService.modifyIssueHostingField(issue, issueForm, detectIssueChange);




        //  첨부 파일 저장


        //  multipartFile 을 file Map List 객체로 변경한다.


@@ -570,6 +585,8 @@


    @Override


    @Transactional


    public Issue addDownIssue(User user, IssueForm issueForm, List<MultipartFile> multipartFiles) {


        StringBuilder detectIssueChange = new StringBuilder();




        //  사용하고 있는 업무 공간이 활성 상태인지 확인한다. 사용 공간에서 로그인한 사용자가 비활성인지 확인한다.


        Workspace workspace = this.workspaceService.checkUseWorkspace(user, user.getLastWorkspaceId());


        //  프로젝트 유효성 체크


@@ -612,11 +629,11 @@


        //  담당부서 지정


        this.issueDepartmentService.modifyIssueDepartment(issue, user, project.getWorkspace(), issueForm.getDepartmentIds());


        //  업체 정보 저장


        this.issueCompanyService.modifyIssueCompanyField(issue, issueForm);


        this.issueCompanyService.modifyIssueCompanyField(issue, issueForm, detectIssueChange);


        //  ISP 정보 저장


        this.issueIspService.modifyIssueIspField(issue, issueForm);


        this.issueIspService.modifyIssueIspField(issue, issueForm, detectIssueChange);


        //  HOSTING 정보 저장


        this.issueHostingService.modifyIssueHostingField(issue, issueForm);


        this.issueHostingService.modifyIssueHostingField(issue, issueForm, detectIssueChange);




        //  첨부 파일 저장


        //  multipartFile 을 file Map List 객체로 변경한다.


@@ -647,6 +664,7 @@


    @Override


    @Transactional


    public Issue addRelIssue(User user, IssueForm issueForm, List<MultipartFile> multipartFiles) {


        StringBuilder detectIssueChange = new StringBuilder();


        //  사용하고 있는 업무 공간이 활성 상태인지 확인한다. 사용 공간에서 로그인한 사용자가 비활성인지 확인한다.


        Workspace workspace = this.workspaceService.checkUseWorkspace(user, user.getLastWorkspaceId());


        //  프로젝트 유효성 체크


@@ -689,11 +707,11 @@


        //  담당부서 지정


        this.issueDepartmentService.modifyIssueDepartment(issue, user, project.getWorkspace(), issueForm.getDepartmentIds());


        //  업체 정보 저장


        this.issueCompanyService.modifyIssueCompanyField(issue, issueForm);


        this.issueCompanyService.modifyIssueCompanyField(issue, issueForm, detectIssueChange);


        //  ISP 정보 저장


        this.issueIspService.modifyIssueIspField(issue, issueForm);


        this.issueIspService.modifyIssueIspField(issue, issueForm, detectIssueChange);


        //  HOSTING 정보 저장


        this.issueHostingService.modifyIssueHostingField(issue, issueForm);


        this.issueHostingService.modifyIssueHostingField(issue, issueForm, detectIssueChange);




        //  첨부 파일 저장


        //  multipartFile 을 file Map List 객체로 변경한다.


@@ -795,7 +813,7 @@


                useValues.add(issueCustomFieldValueVo.getUseValue());


                customField.put(issueCustomFieldValueVo.getCustomFieldVo().getName(), useValues);


            } else {


                if (issueCustomFieldValueVo.getCustomFieldVo().getCustomFieldType().equals(CustomFieldType.INPUT.toString())) {


                if (issueCustomFieldValueVo.getCustomFieldVo().getCustomFieldType().equals(INPUT.toString())) {


                    customField.put(issueCustomFieldValueVo.getCustomFieldVo().getName(), issueCustomFieldValueVo.getUseValue());


                } else {


                    customField.put(issueCustomFieldValueVo.getCustomFieldVo().getName(), Lists.newArrayList(issueCustomFieldValueVo.getUseValue()));


@@ -933,22 +951,19 @@


            return Lists.newArrayList();


        }




        //  튜닝 전 - 1.3 / 1.2 / 1.1


        //  튜닝 후 (단일/다중 검색 조건 3개 기준) - 0.49 / 0.41 / 0.47 / 0.41




        List<IssueVo> issueVos = Lists.newArrayList();  //  이슈 목록 데이터 저장 컬렉션


        //  사용자 정의 필드로 검색한 이슈 아이디 값


        List<String> issueKeys = Lists.newArrayList(issueIds);


        issueCondition.setIssueIds(issueKeys);




        issueCondition.setLoginUserId(this.webAppUtil.getLoginId());


        issueCondition.setWorkspaceId(this.userService.getUser(this.webAppUtil.getLoginId()).getLastWorkspaceId());


        User user = this.webAppUtil.getLoginUserObject();




        issueCondition.setLoginUserId(user.getId());


        issueCondition.setWorkspaceId(user.getLastWorkspaceId());






        List<Map<String, Object>> results = Lists.newArrayList();


        Long totalCount = 0L;


        UserLevel userLevel = this.userLevelService.getUserLevel(user.getUserLevel().getId());


//        UserLevel userLevel = this.userLevelService.getUserLevel(user.getUserLevel().getId());




//        if (!this.userWorkspaceService.checkWorkspaceManager(user)


//                && !MngPermission.checkMngPermission(userLevel.getPermission(), MngPermission.USER_PERMISSION_MNG_ISSUE)) { //최고관리자 & 프로젝트,이슈 관리자 일 경우 모든 이슈 보기


@@ -958,17 +973,18 @@


//            results = this.issueMapper.findByDepartment(issueCondition);


//            totalCount = this.issueMapper.countByDepartment(issueCondition);


//        }*/


//        StopWatch serviceStart = new StopWatch();


//        serviceStart.start();


        results = this.issueMapper.find(issueCondition);


//         serviceStart.stop();


//        log.error("result : " + serviceStart.toString());




//        serviceStart = new StopWatch();


//        serviceStart.start();


        totalCount = this.issueMapper.count(issueCondition);






        //  튜닝 전 - 0.8, 0.9, 0.9, 0.9, 0.9


        /*StopWatch serviceStart = new StopWatch();


        serviceStart.start();*/


        //  튜닝 전 - 1.1, 1.1, 1.3, 1.2




        /*serviceStart.stop();


        log.debug("serviceENd1 : " + serviceStart.getTime());*/


//        serviceStart.stop();


//        log.error("totalCount : " + serviceStart.toString());




        int totalPage = (int) Math.ceil((totalCount - 1) / pageable.getPageSize()) + 1;


        //  이슈 아이디 초기화


@@ -984,8 +1000,8 @@


            this.setDownIssues(user, issueVos);


            this.setRelationIssues(issueVos);


        }


        this.setCountDownIssues(issueVos);




        this.setCountDownIssues(issueVos);


        this.SetWorkflowDepartment(issueVos); //워크플로우에 설정한 담당부서 가져오기




        resJsonData.put(Constants.RES_KEY_CONTENTS, issueVos);


@@ -1520,7 +1536,7 @@




                case "02": //  프로젝트, 이슈 유형, 이슈 상태,  우선순위, 중요도, 담당자, 첨부파일, 사용자 정의 필드 정보, 댓글, 기록을 셋팅한다.


                    this.setIssueDetail(issueVo, issue, user);    //  이슈 상세 정보를 셋팅한다.


                    this.setIssueTableConfigs(issue, issueVo);


                    this.setIssueTableConfigs(issue, issueVo, issueCondition);


                    issueVo.setProjectVo(ConvertUtil.copyProperties(issue.getProject(), ProjectVo.class));


                    break;


            }


@@ -1532,8 +1548,9 @@


    }




    // 테이블 설정 셋팅


    private void setIssueTableConfigs(Issue issue, IssueVo issueVo) {


        Long IssueTypeId = issue.getIssueType().getId();


    private void setIssueTableConfigs(Issue issue, IssueVo issueVo, IssueCondition issueCondition) {


        //Long IssueTypeId = issue.getIssueType().getId();


        Long IssueTypeId = issueCondition.getIssueTypeId();




        for (int tableConfigType : IssueTableConfig.IssueTableTypes) {


            if (tableConfigType != IssueTableConfig.ISSUE_TABLE_TYPE_MAIN) {


@@ -1557,7 +1574,10 @@




        List<Issue> downIssueList = this.issueRepository.findByParentIssueId(issue.getId());


        if(downIssueList != null && downIssueList.size() > 0) {


            int startPage = (int) Math.floor(issueVo.getDownPage()/issueVo.getDownPageSize());


            int startPage = 0;


            if (issueVo.getDownPage() != 0) {


                startPage = (int) Math.floor(issueVo.getDownPage()/issueVo.getDownPageSize());


            }


            Pageable pageable = PageRequest.of(startPage, issueVo.getDownPageSize());


            downIssues = this.issueRepository.findByParentIssueId(issue.getId(), pageable);


        }


@@ -1581,6 +1601,9 @@


                this.setIssueCustomFields(downIssue, downIssueVo);   // 사용자정의필드 정보 세팅


                this.setIssueHistory(downIssue, downIssueVo);   //  이슈 기록 정보 셋팅


                this.setIssueComments(downIssue, downIssueVo);  //  댓글 정보 셋팅


                this.setIssueCompanyField(downIssue, downIssueVo);  //업체 정보 세팅


                this.setIssueIspField(downIssue, downIssueVo);  //ISP 정보 세팅


                this.setIssueHostingField(downIssue, downIssueVo);  //HOSTING 정보 세팅




                downIssueVo.setModifyPermissionCheck(issueVo.getModifyPermissionCheck());




@@ -1594,6 +1617,11 @@


    @Override


    @Transactional(readOnly = true)


    public void setIssueDetail(IssueVo issueVo, Issue issue, User user) {


        //  이슈 수정 권한을 갖고 있는지 확인


        if (this.checkHasPermission(issueVo, issueVo.getUserVos(), user, issueVo.getDepartmentVos())) {


            issueVo.setModifyPermissionCheck(Boolean.TRUE);


        }




        issueVo.setProjectVo(ConvertUtil.copyProperties(issue.getProject(), ProjectVo.class));


        issueVo.setIssueTypeVo(ConvertUtil.copyProperties(issue.getIssueType(), IssueTypeVo.class));


        IssueStatusVo issueStatusVo = ConvertUtil.copyProperties(issue.getIssueStatus(), IssueStatusVo.class, "issueStatusType");


@@ -1629,11 +1657,6 @@


        this.setIssueIspField(issue, issueVo);  //ISP 정보 세팅


        this.setIssueHostingField(issue, issueVo);  //HOSTING 정보 세팅


        this.setParentIssue(issue,issueVo); //상위 이슈 정보 세팅




        //  이슈 수정 권한을 갖고 있는지 확인


        if (this.checkHasPermission(issueVo, issueVo.getUserVos(), user, issueVo.getDepartmentVos())) {


            issueVo.setModifyPermissionCheck(Boolean.TRUE);


        }


    }




    //  상위일감 정보 추가


@@ -1675,7 +1698,7 @@


            issueVo.setRelTotalCount(totalCount);


            for (Map<String, Object> result : results) {


                IssueRelationVo issueRelationVo = ConvertUtil.convertMapToClass(result, IssueRelationVo.class);


                Issue relationIssue = this.findOne(issueRelationVo.getId());


                Issue relationIssue = this.findOne(MapUtil.getLong(result, "relationIssueId"));


                IssueVo relIssueVo = ConvertUtil.copyProperties(relationIssue, IssueVo.class);


                Project project = this.projectService.getProject(relationIssue.getProject().getId());


                relIssueVo.setProjectId(project.getId());


@@ -1697,6 +1720,25 @@


                this.setRegister(relationIssue, relIssueVo); // 등록자


                this.setIssueDepartment(relationIssue, relIssueVo);  //  담당부서 정보 셋팅


                this.setIssueCustomFields(relationIssue, relIssueVo);   // 사용자정의필드 정보 세팅




                Set<IssueCompany> issueCompanies = relationIssue.getIssueCompanies();


                Iterator<IssueCompany> itrCompany = issueCompanies.iterator();


                while (itrCompany.hasNext()) {


                    issueRelationVo.addIssueCompanyVo(ConvertUtil.copyProperties(itrCompany.next(), IssueCompanyVo.class));


                }




                Set<IssueIsp> issueIsps = relationIssue.getIssueIspFields();


                Iterator<IssueIsp> itrIsp = issueIsps.iterator();


                while (itrIsp.hasNext()) {


                    issueRelationVo.addIssueIspVo(ConvertUtil.copyProperties(itrIsp.next(), IssueIspVo.class));


                }




                Set<IssueHosting> issueHostings = relationIssue.getIssueHostingFields();


                Iterator<IssueHosting> itrHosting = issueHostings.iterator();


                while (itrHosting.hasNext()) {


                    issueRelationVo.addIssueHostingVo(ConvertUtil.copyProperties(itrHosting.next(), IssueHostingVo.class));


                }




                issueVo.addIssueRelationVo(issueRelationVo);


            }


        } else {


@@ -1829,6 +1871,7 @@


            issueCustomFieldValueCondition.setUseValue(concatUseValue);


            issueCustomFieldValueCondition.setUseValues(userValues);


            issueCustomFieldValueCondition.setIssueTypeId(issueApiform.getIssueTypeId());


            issueCustomFieldValueCondition.setIssueStatusType("CLOSE");


            List<Map<String, Object>> results = this.issueMapper.findByCustomFieldValue(issueCustomFieldValueCondition);


            if (results != null && results.size() > 0) {


                for (Map<String, Object> result : results) {


@@ -2053,20 +2096,21 @@


        this.checkNotHaveIssueIdAttachedFile(issue, issueForm);


        //  사용자 정의 필드 저장


        this.issueCustomFieldValueService.modifyIssueCustomFieldValue(issue, issueForm.getIssueCustomFields());


        //  이슈 이력 등록


        if (!StringUtils.isEmpty(detectIssueChange.toString())) {


            this.issueHistoryService.addIssueHistory(issue, user, IssueHistoryType.MODIFY, detectIssueChange.toString());


        }


        //  사용자 시스템 기능 사용 정보 수집


        UserVo userVo = ConvertUtil.copyProperties(user, UserVo.class);


        log.info(ElasticSearchUtil.makeUserActiveHistoryMessage(userVo, ElasticSearchConstants.ISSUE_MODIFY));




        //  업체 정보 저장


        this.issueCompanyService.modifyIssueCompanyField(issue, issueForm);


        this.issueCompanyService.modifyIssueCompanyField(issue, issueForm, detectIssueChange);


        //  ISP 정보 저장


        this.issueIspService.modifyIssueIspField(issue, issueForm);


        this.issueIspService.modifyIssueIspField(issue, issueForm, detectIssueChange);


        //  HOSTING 정보 저장


        this.issueHostingService.modifyIssueHostingField(issue, issueForm);


        this.issueHostingService.modifyIssueHostingField(issue, issueForm, detectIssueChange);




        //  이슈 이력 등록


        if (!StringUtils.isEmpty(detectIssueChange.toString())) {


            this.issueHistoryService.addIssueHistory(issue, user, IssueHistoryType.MODIFY, detectIssueChange.toString());


        }




        return issue;


    }


@@ -2711,6 +2755,9 @@


        excelInfo.addAttrInfos(new ExportExcelAttrVo("register", this.messageAccessor.message("common.register"), 20, ExportExcelAttrVo.ALIGN_CENTER)); // 등록자


        excelInfo.addAttrInfos(new ExportExcelAttrVo("period", this.messageAccessor.message("common.period"), 20, ExportExcelAttrVo.ALIGN_CENTER)); // 기간


        excelInfo.addAttrInfos(new ExportExcelAttrVo("modifyDate", this.messageAccessor.message("common.modifyDate"), 20, ExportExcelAttrVo.ALIGN_CENTER)); // 최종 변경일


        excelInfo.addAttrInfos(new ExportExcelAttrVo("companyName", this.messageAccessor.message("common.company"), 20, ExportExcelAttrVo.ALIGN_CENTER)); // 업체


        excelInfo.addAttrInfos(new ExportExcelAttrVo("ispName", this.messageAccessor.message("common.isp"), 20, ExportExcelAttrVo.ALIGN_CENTER)); // ISP


        excelInfo.addAttrInfos(new ExportExcelAttrVo("hostingName", this.messageAccessor.message("common.hosting"), 20, ExportExcelAttrVo.ALIGN_CENTER)); // 호스팅






        //  사용자 정의 필드를 사용한 이슈를 찾는다. 만약 이슈가 없다면 여기서 이슈 조회가 끝난다.


@@ -2794,6 +2841,30 @@


            CompanyField companyField = issueCompany.getCompanyField();


            if (companyField != null) {


                issueCompanyVo.setCompanyId(issueCompany.getCompanyField().getId());


                if (issueCompany.getCompanyTypeId() != null && issueCompany.getCompanyTypeId() != -1) {


                    CompanyFieldCategory companyType = this.companyFieldCategoryService.find(issueCompany.getCompanyTypeId());


                    issueCompanyVo.setCompanyTypeName(companyType.getUseValue());


                }


                if (issueCompany.getParentSectorId() != null && issueCompany.getParentSectorId() != -1) {


                    CompanyFieldCategory parentSector = this.companyFieldCategoryService.find(issueCompany.getParentSectorId());


                    issueCompanyVo.setParentSectorName(parentSector.getUseValue());


                }


                if (issueCompany.getChildSectorId() != null && issueCompany.getChildSectorId() != -1) {


                    CompanyFieldCategory childSector = this.companyFieldCategoryService.find(issueCompany.getChildSectorId());


                    issueCompanyVo.setChildSectorName(childSector.getUseValue());


                }


                if (issueCompany.getRegionId() != null && issueCompany.getRegionId() != -1) {


                    CompanyFieldCategory region = this.companyFieldCategoryService.find(issueCompany.getRegionId());


                    issueCompanyVo.setRegionName(region.getUseValue());


                }


                if (issueCompany.getStatusId() != null && issueCompany.getStatusId() != -1) {


                    if (issueCompany.getStatusName() != null && !issueCompany.getStatusName().equals("")) {


                        issueCompanyVo.setStatusName(issueCompany.getStatusName());


                    } else {


                        CompanyFieldCategory status = this.companyFieldCategoryService.find(issueCompany.getStatusId());


                        issueCompanyVo.setStatusName(status.getUseValue());


                    }


                }


            }


            issueCompanyVos.add(issueCompanyVo);


        }


@@ -2863,6 +2934,9 @@


                result.put("departments", CommonUtil.convertDepartmentVosToString(issueVo.getDepartmentVos()));


                result.put("priorityName", issueVo.getPriorityName());


                result.put("severityName", issueVo.getSeverityName());


                result.put("companyName", issueVo.getCompanyName());


                result.put("ispName", issueVo.getIspName());


                result.put("hostingName", issueVo.getHostingName());




                UserVo register = this.userService.removeSensitiveUser(issueVo.getRegisterId());


                //  등록자


@@ -2940,6 +3014,9 @@


        excelInfo.addAttrInfos(new ExportExcelAttrVo("id", this.messageAccessor.message("common.importance"), 5, ExportExcelAttrVo.ALIGN_CENTER)); // 중요도


        excelInfo.addAttrInfos(new ExportExcelAttrVo("id", this.messageAccessor.message("common.startDate"), 10, ExportExcelAttrVo.ALIGN_CENTER)); // 시작일


        excelInfo.addAttrInfos(new ExportExcelAttrVo("id", this.messageAccessor.message("common.endDate"), 10, ExportExcelAttrVo.ALIGN_CENTER)); // 종료일


        excelInfo.addAttrInfos(new ExportExcelAttrVo("id", this.messageAccessor.message("common.company"), 10, ExportExcelAttrVo.ALIGN_CENTER)); // 업체


        excelInfo.addAttrInfos(new ExportExcelAttrVo("id", this.messageAccessor.message("common.isp"), 10, ExportExcelAttrVo.ALIGN_CENTER)); // ISP


        excelInfo.addAttrInfos(new ExportExcelAttrVo("id", this.messageAccessor.message("common.hosting"), 10, ExportExcelAttrVo.ALIGN_CENTER)); // 호스팅


        //  프로젝트에 연결된 사용자 정의 필드 정보를 추출하여 엑셀 download 템플릿을 만든다.


        this.makeIssueExcelTemplateCustomFields(excelInfo, conditions);


        //  엑셀에 넣을 데이터 - IssueVos 데이터를 엑셀에서 표시할 수 있는 데이터로 변경한다.


@@ -2979,9 +3056,14 @@


            Map<Long, Long> issueNumberMaps = new HashMap<>();  //  이슈 번호 모음


            Map<String, Long> issueTypeCustomFieldMaps = new HashMap<>(); //  이슈 타입 + 사용자 정의 필드 연결 정보




            Map<String, CompanyField> companyFieldMaps = new HashMap<>();   //업체 모음


            Map<String, IspField> ispFieldMaps = new HashMap<>();   //isp 모음


            Map<String, HostingField> hostingFieldMaps = new HashMap<>();   //호스팅 모음




            Workspace workspace = this.workspaceService.getWorkspace(this.userService.getUser(this.webAppUtil.getLoginId()).getLastWorkspaceId());  //  이슈를 넣으려는 업무 공간


            //  이슈의 주요 속성을 map 에 저장하여 엑셀 import 에서 지정한 대상(이슈 속성)을 빠르게 찾을 수 있게 한다.


            this.IssueAttributeMapToList(issueForm, priorityMaps, severityMaps, departmentMaps, customFieldMaps, issueTypeCustomFieldMaps);


            this.IssueAttributeMapToList(issueForm, priorityMaps, severityMaps, departmentMaps, customFieldMaps,


                    issueTypeCustomFieldMaps, companyFieldMaps, ispFieldMaps, hostingFieldMaps);


            //  0.237 - 0.230




            List<IssueForm> issueForms = Lists.newArrayList();


@@ -3024,14 +3106,11 @@


                //  1번 헤더부터 데이터 영역


                if (rowIndex > 1) {


                    //  이슈로 등록하기 위해 IssueForm 에 데이터를 셋팅한다.


                    IssueForm newIssueForm = this.setIssueFormToExcelField(row, (rowIndex + 1), priorityMaps, severityMaps, departmentMaps, customFieldMaps, headers);


                    IssueForm newIssueForm = this.setIssueFormToExcelField(row, (rowIndex + 1), priorityMaps, severityMaps, departmentMaps, customFieldMaps,


                            companyFieldMaps, ispFieldMaps, hostingFieldMaps, headers);


                    ConvertUtil.copyProperties(issueForm, newIssueForm);








                    issueForms.add(newIssueForm);






                }


            }




@@ -3083,6 +3162,8 @@


                }




                saveIssueForm.setIssueStatusId(issueStatus.getId());




                this.setIssuePartners(saveIssueForm, issue);


            }






@@ -3096,7 +3177,7 @@


            //  이슈 담당자 벌크 등록


            this.bulkInsertIssueAssignee(issueForms, workspace);


            //  0.361 - 0.705




            


            //  1.816


            /*StopWatch serviceStart = new StopWatch();


            serviceStart.start();*/


@@ -3115,6 +3196,69 @@


            //  증가된 이슈 번호를 업데이트 한다.


//            issueNumberMaps.put(issueForm.getProjectId(), issueForm.getProjectId());


//            this.issueNumberGeneratorService.updateIssueNumber(issueNumberMaps);


        }


    }




    /**


     * 엑셀로 입력한 파트너 정보 저장


     * @param issueForm IssueForm


     */


    private void setIssuePartners(IssueForm issueForm, Issue issue) {


        IssueCompany issueCompany = new IssueCompany();


        IssueIsp issueIsp = new IssueIsp();


        IssueHosting issueHosting = new IssueHosting();


        //issueCompany 등록


        if (issueForm.getIssueCompanyFields() != null && issueForm.getIssueCompanyFields().size() > 0) {


            for (Map<String, Object> issueCompanyMap : issueForm.getIssueCompanyFields()) {


                CompanyField companyField =  ConvertUtil.convertMapToClass(issueCompanyMap, CompanyField.class);


                issueCompany = ConvertUtil.convertMapToClass(issueCompanyMap, IssueCompany.class, "id");


                issueCompany.setCompanyField(companyField);


                issueCompany.setIssue(issue);


                this.issueCompanyRepository.saveAndFlush(issueCompany);


                


                //  사용자가 ISP를 직접 입력하지 않았을 경우 업체에 등록되어있는 ISP 설정 


                if (issueForm.getIssueIspFields() == null || issueForm.getIssueIspFields().size() < 1) {


                    //  업체의 ISP가 있는 경우 issueISP 등록


                    if (companyField.getIspId() != null && companyField.getIspId() != -1) {


                        IspField ispField = this.ispFieldService.getIsp(companyField.getIspId());


                        issueIsp = ConvertUtil.copyProperties(ispField, IssueIsp.class, "id");


                        issueIsp.setIspField(ispField);


                        issueIsp.setIssue(issue);


                        this.issueIspRepository.saveAndFlush(issueIsp);


                    }


                }


                //  사용자가 호스팅을 직접 입력하지 않았을 경우 업체에 등록되어있는 호스팅 설정


                if (issueForm.getIssueHostingFields() == null || issueForm.getIssueHostingFields().size() < 1) {


                    //  업체의 호스팅이 있는 경우 issueHosting 등록


                    if (companyField.getHostingId() != null && companyField.getHostingId() != -1) {


                        HostingField hostingField = this.hostingFieldService.getHosting(companyField.getHostingId());


                        issueHosting = ConvertUtil.copyProperties(hostingField, IssueHosting.class, "id");


                        issueHosting.setHostingField(hostingField);


                        issueHosting.setIssue(issue);


                        this.issueHostingRepository.saveAndFlush(issueHosting);


                    }


                }


            }


        }


        //issueIsp 등록


        if (issueForm.getIssueIspFields() != null && issueForm.getIssueIspFields().size() > 0) {


            for (Map<String, Object> issueIspMap : issueForm.getIssueIspFields()) {


                issueIsp = ConvertUtil.convertMapToClass(issueIspMap, IssueIsp.class, "id");


                IspField ispField = ConvertUtil.convertMapToClass(issueIspMap, IspField.class);


                issueIsp.setIspField(ispField);


                issueIsp.setIssue(issue);


                this.issueIspRepository.saveAndFlush(issueIsp);


            }


        }


        //issueHosting 등록


        if (issueForm.getIssueHostingFields() != null && issueForm.getIssueHostingFields().size() > 0) {


            for (Map<String, Object> issueHostingMap : issueForm.getIssueHostingFields()) {


                issueHosting = ConvertUtil.convertMapToClass(issueHostingMap, IssueHosting.class, "id");


                HostingField hostingField = ConvertUtil.convertMapToClass(issueHostingMap, HostingField.class);


                issueHosting.setHostingField(hostingField);


                issueHosting.setIssue(issue);


                this.issueHostingRepository.saveAndFlush(issueHosting);


            }


        }


    }




@@ -3215,27 +3359,39 @@


                issueCustomField.put("registerId", this.webAppUtil.getLoginId());


                issueCustomFieldValueMaps.add(issueCustomField);


            }


            IssueForm partners = this.findCompanyField(issueForm); // 같은 도메인 업체 찾기


            Issue issue = this.findOne(issueForm.getId());


            if (partners.getIssueCompanyFields() != null && partners.getIssueCompanyFields().size() > 0) {


                for (Map<String, Object> company : partners.getIssueCompanyFields()) {


                    IssueCompany issueCompany = ConvertUtil.convertMapToClass(company, IssueCompany.class);


                    issueCompany.setIssue(issue);


                    this.issueCompanyRepository.saveAndFlush(issueCompany);


            


            //  엑셀에 업체명을 입력하지 않았을 경우 같은 도메인 업체 찾기


            if (issueForm.getIssueCompanyFields() == null || issueForm.getIssueCompanyFields().size() < 1) {


                // 같은 도메인 업체 찾기


                IssueForm partners = this.findCompanyField(issueForm);


                Issue issue = this.findOne(issueForm.getId());


                if (partners.getIssueCompanyFields() != null && partners.getIssueCompanyFields().size() > 0) {


                    for (Map<String, Object> company : partners.getIssueCompanyFields()) {


                        IssueCompany issueCompany = ConvertUtil.convertMapToClass(company, IssueCompany.class);


                        CompanyField companyField = ConvertUtil.convertMapToClass(company, CompanyField.class);


                        issueCompany.setCompanyField(companyField);


                        issueCompany.setIssue(issue);




                        this.issueCompanyRepository.saveAndFlush(issueCompany);


                    }


                }


            }


            if (partners.getIssueIspFields() != null && partners.getIssueIspFields().size() > 0) {


                for (Map<String, Object> isp : partners.getIssueIspFields()) {


                    IssueIsp issueIsp = ConvertUtil.convertMapToClass(isp, IssueIsp.class);


                    issueIsp.setIssue(issue);


                    this.issueIspRepository.saveAndFlush(issueIsp);


                if (partners.getIssueIspFields() != null && partners.getIssueIspFields().size() > 0) {


                    for (Map<String, Object> isp : partners.getIssueIspFields()) {


                        IssueIsp issueIsp = ConvertUtil.convertMapToClass(isp, IssueIsp.class);


                        IspField ispField = ConvertUtil.convertMapToClass(isp, IspField.class);


                        issueIsp.setIspField(ispField);


                        issueIsp.setIssue(issue);


                        this.issueIspRepository.saveAndFlush(issueIsp);


                    }


                }


            }


            if (partners.getIssueHostingFields() != null && partners.getIssueHostingFields().size() > 0) {


                for (Map<String, Object> hosting : partners.getIssueHostingFields()) {


                    IssueHosting issueHosting = ConvertUtil.convertMapToClass(hosting, IssueHosting.class);


                    issueHosting.setIssue(issue);


                    this.issueHostingRepository.saveAndFlush(issueHosting);


                if (partners.getIssueHostingFields() != null && partners.getIssueHostingFields().size() > 0) {


                    for (Map<String, Object> hosting : partners.getIssueHostingFields()) {


                        IssueHosting issueHosting = ConvertUtil.convertMapToClass(hosting, IssueHosting.class);


                        HostingField hostingField = ConvertUtil.convertMapToClass(hosting, HostingField.class);


                        issueHosting.setHostingField(hostingField);


                        issueHosting.setIssue(issue);


                        this.issueHostingRepository.saveAndFlush(issueHosting);


                    }


                }


            }


        }


@@ -3247,7 +3403,8 @@




    //  이슈의 주요 속성을 map 에 저장하여 엑셀 import 에서 지정한 대상(이슈 속성)을 빠르게 찾을 수 있게 한다.


    private void IssueAttributeMapToList(IssueForm issueForm, Map<String, Priority> priorityMaps, Map<String, Severity> severityMaps,


                                         Map<String, DepartmentVo> departmentMaps, Map<String, CustomField> customFieldMaps,Map<String, Long> issueTypeCustomFieldMaps) {


                                         Map<String, DepartmentVo> departmentMaps, Map<String, CustomField> customFieldMaps,Map<String, Long> issueTypeCustomFieldMaps,


                                         Map<String, CompanyField> companyFieldMaps, Map<String, IspField> ispFieldMaps, Map<String, HostingField> hostingFieldMaps) {




        Project project = this.projectService.getProject(issueForm.getProjectId());




@@ -3274,12 +3431,46 @@


        for (CustomField customField : customFields) {


            customFieldMaps.put(customField.getName(), customField);


        }




        //  업체 정보를 바로 찾을 수 있게 준비


        List<CompanyField> companyFields = this.companyFieldService.findAll();


        for (CompanyField companyField : companyFields) {


            companyFieldMaps.put(companyField.getName(), companyField);


        }


        //  ISP 정보를 바로 찾을 수 있게 준비


        List<IspField> ispFields = this.ispFieldService.findAll();


        for (IspField ispField : ispFields) {


            ispFieldMaps.put(ispField.getName(), ispField);


        }


        //  호스팅 정보를 바로 찾을 수 있게 준비


        List<HostingField> hostingFields = this.hostingFieldService.findAll();


        for (HostingField hostingField : hostingFields) {


            hostingFieldMaps.put(hostingField.getName(), hostingField);


        }


    }




    /**


     * cell NULL 체크 함수


     * @param cell Cell


     * @return boolean


     */


    private Boolean cellNullCheck (Cell cell) {


        if (cell != null && cell.getCellType() != Cell.CELL_TYPE_BLANK && cell.getCellType() != Cell.CELL_TYPE_STRING) {


            throw new OwlRuntimeException(


                    this.messageAccessor.getMessage(MsgConstants.EXCEL_IMPORT_NOT_STRING_TYPE));


        }


        if (cell != null && cell.getStringCellValue() != null) {


            cell.setCellValue(cell.getStringCellValue().trim());//셀 값 공백 제거


        }


        return cell != null && cell.getStringCellValue() != null && !cell.getStringCellValue().equals("") && cell.getCellType() != Cell.CELL_TYPE_BLANK;


    }




    //  엑셀 필드에 있는 정보를 이슈 form 으로 옮긴다.


    private IssueForm setIssueFormToExcelField(Row row, int rowIndex, Map<String, Priority> priorityMaps,


                                               Map<String, Severity> severityMaps, Map<String, DepartmentVo> departmentMaps,


                                               Map<String, CustomField> customFieldMaps, List<String> headers) {


                                               Map<String, CustomField> customFieldMaps, Map<String, CompanyField> companyFieldMaps,


                                               Map<String, IspField> ispFieldMaps, Map<String, HostingField> hostingFieldMaps,


                                               List<String> headers) {


        IssueForm issueForm = new IssueForm();


        issueForm.setRegisterId(this.webAppUtil.getLoginId());


        Project project = null;


@@ -3294,7 +3485,7 @@


                    break;




                case 1:    //  내용


                    if (cell != null) {


                    if (cellNullCheck(cell)) {


                        issueForm.setDescription(CommonUtil.convertExcelStringToCell(cell));


                    } else {


                        //  null 입력 방지


@@ -3328,6 +3519,24 @@


                        this.setIssueFormPeriod(cell, issueForm, false, rowIndex);


                    }


                    break;


                case 6:


                    //  업체를 IssueForm 에 저장한다.


                    if (cellNullCheck(cell)) {


                        this.setIssueFormCompanyField(cell, companyFieldMaps, issueForm, rowIndex);


                    }


                    break;


                case 7:


                    //  ISP를 IssueForm 에 저장한다.


                    if (cellNullCheck(cell)) {


                        this.setIssueFormIspField(cell, ispFieldMaps, issueForm, rowIndex);


                    }


                    break;


                case 8:


                    //  호스팅을 IssueForm 에 저장한다.


                    if (cellNullCheck(cell)) {


                        this.setIssueFormHostingField(cell, hostingFieldMaps, issueForm, rowIndex);


                    }


                    break;


                default:


                    //  9번 부터는 사용자 정의 필드. 사용자 정의 필드 정보를 IssueForm 에 저장한다.


                    this.setIssueFormCustomFieldValue(cell, customFieldMaps, issueForm, headers.get(cellIndex), rowIndex);


@@ -3337,9 +3546,48 @@


        return issueForm;


    }




    private void setIssueFormHostingField(Cell cell, Map<String, HostingField> hostingFieldMaps, IssueForm issueForm, int rowIndex) {


        if (cell != null) {


            Map<String, Object> issueHostingFields = new HashMap<>();


            HostingField hostingFieldMap = hostingFieldMaps.get(CommonUtil.convertExcelStringToCell(cell));


            if (hostingFieldMap == null) {


                throw new OwlRuntimeException(


                        this.messageAccessor.getMessage(MsgConstants.EXCEL_IMPORT_HOSTING_NOT_EXIST, rowIndex));


            }


            ConvertUtil.copyProperties(hostingFieldMap, issueHostingFields);


            issueForm.addIssueHostingField(issueHostingFields);


        }


    }




    private void setIssueFormIspField(Cell cell, Map<String, IspField> ispFieldMaps, IssueForm issueForm, int rowIndex) {


        if (cell != null) {


            Map<String, Object> issueIspFields = new HashMap<>();


            IspField ispFieldMap = ispFieldMaps.get(CommonUtil.convertExcelStringToCell(cell));


            if (ispFieldMap == null) {


                throw new OwlRuntimeException(


                        this.messageAccessor.getMessage(MsgConstants.EXCEL_IMPORT_ISP_NOT_EXIST, rowIndex));


            }


            ConvertUtil.copyProperties(ispFieldMap, issueIspFields);


            issueForm.addIssueIspField(issueIspFields);


        }


    }




    private void setIssueFormCompanyField(Cell cell, Map<String, CompanyField> companyFieldMaps, IssueForm issueForm, int rowIndex) {


        if (cell != null) {


            Map<String, Object> issueCompanyFields = new HashMap<>();


            CompanyField companyFieldMap = companyFieldMaps.get(CommonUtil.convertExcelStringToCell(cell));


            if (companyFieldMap == null) {


                throw new OwlRuntimeException(


                        this.messageAccessor.getMessage(MsgConstants.EXCEL_IMPORT_COMPANY_NOT_EXIST, rowIndex));


            }


            ConvertUtil.copyProperties(companyFieldMap, issueCompanyFields);


            issueForm.addissueCompanyField(issueCompanyFields);


        }


    }




    //  이슈 제목을 IssueForm 에 저장한다.


    private void setIssueFormTitle(Cell cell, IssueForm issueForm, int rowIndex) {


        if (cell == null) {


        if (!cellNullCheck(cell)) {


            throw new OwlRuntimeException(


                    this.messageAccessor.getMessage(MsgConstants.EXCEL_IMPORT_ISSUE_TITLE_IS_NULL, rowIndex));


        }


@@ -3387,7 +3635,7 @@




    //  우선순위를 IssueForm 에 저장한다.


    private void setIssueFormPriority(Cell cell, Map<String, Priority> priorityMaps, IssueForm issueForm, int rowIndex) {


        if (cell == null) {


        if (!cellNullCheck(cell)) {


            throw new OwlRuntimeException(


                    this.messageAccessor.getMessage(MsgConstants.EXCEL_IMPORT_PRIORITY_IS_NULL, rowIndex));


        }


@@ -3404,7 +3652,7 @@




    //  중요도를 IssueForm 에 저장한다.


    private void setIssueFormSeverity(Cell cell, Map<String, Severity> severityMaps, IssueForm issueForm, int rowIndex) {


        if (cell == null) {


        if (!cellNullCheck(cell)) {


            throw new OwlRuntimeException(


                    this.messageAccessor.getMessage(MsgConstants.EXCEL_IMPORT_SEVERITY_IS_NULL, rowIndex));


        }


@@ -3440,8 +3688,13 @@




            //  값이 공백이면 중지


            String cellValue = CommonUtil.convertExcelStringToCell(cell);


            if (StringUtils.isEmpty(cellValue) || !cell.toString().equals("null")) {


            if (StringUtils.isEmpty(cellValue) || cell.toString().equals("null")) {


                return;


            }




            if (cell.toString().length() < 10 && cell.toString().contains("-")) { //날짜 형식 체크


                throw new OwlRuntimeException(


                        this.messageAccessor.getMessage(MsgConstants.EXCEL_IMPORT_PERIOD_NOT_DASH, rowIndex));


            }




            Date startDate;


@@ -3495,9 +3748,18 @@


                case EMAIL:


                case SITE:


                case TEL:


                    if (cellValue.length() > 100) {


                    if (customField.getCustomFieldType() != INPUT && cellValue.length() > 100) { //INPUT 타입은 100자 제한 없음


                        throw new OwlRuntimeException(


                                this.messageAccessor.getMessage(MsgConstants.CUSTOM_FIELD_TEXT_TYPE_MAX_LENGTH_OUT));


                    }




                    if (customField.getCustomFieldType() == DATETIME) { //DATETIME일 경우 format 변경


                        if (cell.toString().length() < 10 && cell.toString().contains("-")) { //날짜 형식 체크


                            throw new OwlRuntimeException(


                                    this.messageAccessor.getMessage(MsgConstants.EXCEL_IMPORT_DATETIME_NOT_DASH, rowIndex));


                        }


                        Date date = cell.getDateCellValue();


                        cellValue = new SimpleDateFormat("yyyy-MM-dd H:mm:ss").format(date);


                    }




                    issueCustomFieldMap.put("customFieldId", customField.getId());


@@ -3605,7 +3867,7 @@


    //  이슈를 템플릿에 따라 파트너 담당자에게 메일로 발송한다.


    @Override


    @Transactional(readOnly = true)


    public void sendIssueEmailPartners(EmailTemplateForm emailTemplateForm) {


    public void sendIssueEmailPartners(EmailTemplateForm emailTemplateForm, List<MultipartFile> multipartFiles) {


        if (emailTemplateForm.getSendEmails().size() < 1) {


            throw new OwlRuntimeException(


                    this.messageAccessor.getMessage(MsgConstants.ISSUE_NOT_SEND_USER));


@@ -3632,23 +3894,23 @@


        for(int i=0; i < sendMails.length; i++) {


            sendMails[i] = CommonUtil.decryptAES128(sendMails[i]);


        }


        this.systemEmailService.sendEmail(emailTemplateForm.getTitle(), emailTemplateForm.getTemplate(), sendMails, null);


        this.systemEmailService.sendEmail(emailTemplateForm.getTitle(), emailTemplateForm.getTemplate(), sendMails, null, multipartFiles);




        this.issueHistoryService.detectSendIssueMail(IssueHistoryType.SEND, emailTemplateForm.getSendEmails(), sb);


        this.issueHistoryService.addIssueHistory(issue, IssueHistoryType.SEND, sb.toString());


    }




    @Override


    public void sendCommonEmail(EmailCommonForm emailCommonForm) {


    public void sendCommonEmail(EmailCommonForm emailCommonForm, List<MultipartFile> multipartFiles) {


        if (emailCommonForm.getSendEmails().size() < 1) {


            throw new OwlRuntimeException(


                    this.messageAccessor.getMessage(MsgConstants.ISSUE_NOT_SEND_USER));


        } else if (emailCommonForm.getIssueId() == null) {


            throw new OwlRuntimeException(


                    this.messageAccessor.getMessage(MsgConstants.ISSUE_NOT_EXIST));


        }




        Issue issue = this.getIssue(emailCommonForm.getIssueId());


        Issue issue = null;


        if(emailCommonForm.getIssueId() != null) {


            issue = this.getIssue(emailCommonForm.getIssueId());


        }




        //  발신자 표시


        User user = this.webAppUtil.getLoginUserObject();


@@ -3663,10 +3925,12 @@


        for(int i=0; i < sendMails.length; i++) {


            sendMails[i] = CommonUtil.decryptAES128(sendMails[i]);


        }


        this.systemEmailService.sendEmail(emailCommonForm.getTitle(), emailCommonForm.getDescription(), sendMails, null);


        this.systemEmailService.sendEmail(emailCommonForm.getTitle(), emailCommonForm.getDescription(), sendMails, null, multipartFiles);




        this.issueHistoryService.detectSendIssueMail(IssueHistoryType.SEND, emailCommonForm.getSendEmails(), sb);


        this.issueHistoryService.addIssueHistory(issue, IssueHistoryType.SEND, sb.toString());


        if (issue != null) {


            this.issueHistoryService.detectSendIssueMail(IssueHistoryType.SEND, emailCommonForm.getSendEmails(), sb);


            this.issueHistoryService.addIssueHistory(issue, IssueHistoryType.SEND, sb.toString());


        }


    }




    //  예약 발생 이슈를 실행한다