~jhpark/owl-kisa.git - maprexDevGit

			@@ -2,20 +2,23 @@

			import com.google.common.collect.Lists;
			import kr.wisestone.owl.common.ExcelConditionCheck;
			import kr.wisestone.owl.common.IssueCustomFieldValueFormComparator;
			import kr.wisestone.owl.config.CommonConfiguration;
			import kr.wisestone.owl.constant.Constants;
			import kr.wisestone.owl.constant.ElasticSearchConstants;
			import kr.wisestone.owl.constant.MsgConstants;
			import kr.wisestone.owl.constant.UsePartner;
			import kr.wisestone.owl.constant.*;
			import kr.wisestone.owl.data.CheckIssueData;
			import kr.wisestone.owl.domain.*;
			import kr.wisestone.owl.domain.enumType.CustomFieldType;
			import kr.wisestone.owl.domain.enumType.EmailType;
			import kr.wisestone.owl.domain.enumType.IssueHistoryType;
			import kr.wisestone.owl.domain.enumType.IssueStatusType;
			import kr.wisestone.owl.exception.ApiAuthException;
			import kr.wisestone.owl.exception.ApiParameterException;
			import kr.wisestone.owl.exception.OwlRuntimeException;
			import kr.wisestone.owl.mapper.DepartmentMapper;
			import kr.wisestone.owl.mapper.IssueMapper;
			import kr.wisestone.owl.mapper.IssueRelationMapper;
			import kr.wisestone.owl.mapper.ProjectMapper;
			import kr.wisestone.owl.repository.IssueRepository;
			import kr.wisestone.owl.repository.*;
			import kr.wisestone.owl.service.*;
			import kr.wisestone.owl.util.*;
			import kr.wisestone.owl.util.DateUtil;
			@@ -30,6 +33,8 @@
			import org.slf4j.Logger;
			import org.slf4j.LoggerFactory;
			import org.springframework.beans.factory.annotation.Autowired;
			import org.springframework.data.domain.Page;
			import org.springframework.data.domain.PageRequest;
			import org.springframework.data.domain.Pageable;
			import org.springframework.data.jpa.repository.JpaRepository;
			import org.springframework.messaging.simp.SimpMessagingTemplate;
			@@ -52,10 +57,10 @@
			private IssueRepository issueRepository;

			@Autowired
			private IssueTableConfigService issueTableConfigService;
			private ProjectService projectService;

			@Autowired
			private ProjectService projectService;
			private IssueTableConfigService issueTableConfigService;

			@Autowired
			private IssueStatusService issueStatusService;
			@@ -80,6 +85,9 @@

			@Autowired
			private CompanyFieldService companyFieldService;

			@Autowired
			private CompanyFieldCategoryService companyFieldCategoryService;

			@Autowired
			private IspFieldService ispFieldService;
			@@ -157,10 +165,16 @@
			private UserWorkspaceService userWorkspaceService;

			@Autowired
			private UserLevelService userLevelService;

			@Autowired
			private WorkflowDepartmentService workflowDepartmentService;

			@Autowired
			private IssueRelationService issueRelationService;

			@Autowired
			private IssueRelationRepository issueRelationRepository;

			@Autowired
			private ExcelView excelView;
			@@ -169,10 +183,37 @@
			private IssueMapper issueMapper;

			@Autowired
			private IssueCompanyRepository issueCompanyRepository;

			@Autowired
			private IssueIspRepository issueIspRepository;

			@Autowired
			private IssueHostingRepository issueHostingRepository;

			@Autowired
			private ExcelConditionCheck excelConditionCheck;

			@Autowired
			private SimpMessagingTemplate simpMessagingTemplate;

			@Autowired
			private UserDepartmentService userDepartmentService;

			@Autowired
			private UserDepartmentRepository userDepartmentRepository;

			@Autowired
			private DepartmentMapper departmentMapper;

			@Autowired
			private WorkflowDepartmentRepository workflowDepartmentRepository;

			@Autowired
			private IssueRelationMapper issueRelationMapper;

			@Autowired
			private WorkflowTransitionService workflowTransitionService;

			@Override
			protected JpaRepository<Issue, Long> getRepository() {
			@@ -190,45 +231,49 @@
			this.issueVersionService.addIssueVersion(issue);
			}

			@Override
			@Transactional
			public void addIssueVersion(Long id, Long userId) {
			Issue issue = this.getIssue(id);
			User user = this.userService.getUser(userId);
			// 이슈 버전 생성
			this.issueVersionService.addIssueVersion(issue, user);
			}


			private IssueForm convertToIssueForm(IssueApiForm issueApiForm, User user) {
			if (issueApiForm.getIssueTypeId() == null) {
			throw new OwlRuntimeException(this.messageAccessor.getMessage(MsgConstants.API_PARAMETER_ISSUE_TYPE_ERROR));
			throw new ApiParameterException(this.messageAccessor.getMessage(MsgConstants.API_PARAMETER_ISSUE_TYPE_ERROR));
			}

			IssueForm issueForm = ConvertUtil.copyProperties(issueApiForm, IssueForm.class);
			// issueForm.setFiles(issueApiForm.getFiles());
			IssueType issueType = this.issueTypeService.getIssueType(issueApiForm.getIssueTypeId());
			if (issueType == null){
			throw new OwlRuntimeException(this.messageAccessor.getMessage(MsgConstants.API_PARAMETER_ISSUE_TYPE_ERROR));
			throw new ApiParameterException(this.messageAccessor.getMessage(MsgConstants.API_PARAMETER_ISSUE_TYPE_ERROR));
			}

			Workflow workflow = issueType.getWorkflow();

			// 이슈 상태가 지정되어 있지 않을 경우 초기값으로 지정
			if (issueApiForm.getIssueStatusId() == null) {
			List<IssueStatusVo> issueStatusVos = issueStatusService.findByWorkflowId(workflow.getId());
			IssueStatusVo issueStatusVo = issueStatusVos.get(0);
			issueApiForm.setIssueStatusId(issueStatusVo.getId());
			}

			// 워크플로우 상태에 따른 담당부서 가져오기
			if (issueApiForm.getIssueStatusId() != null) {
			WorkflowDepartmentCondition workflowDepartmentCondition = new WorkflowDepartmentCondition();
			workflowDepartmentCondition.setIssueStatusId(issueApiForm.getIssueStatusId());
			workflowDepartmentCondition.setWorkflowId(workflow.getId());
			List<WorkflowDepartmentVo> workflowDepartmentVos = this.workflowDepartmentService.find(workflowDepartmentCondition);

			for (WorkflowDepartmentVo workflowDepartmentVo : workflowDepartmentVos) {
			issueForm.addDepartmentId(workflowDepartmentVo.getDepartmentVo().getId());
			if (issueApiForm.getApiType().equals(IssueApiForm.ApiType.add)) {
			// 이슈 상태가 지정되어 있지 않을 경우 워크플로우 대기 상태 값으로 지정
			List<Long> departmentIds = this.workflowDepartmentService.findFirstDepartmentIds(workflow);
			if (departmentIds != null && departmentIds.size() > 0) {
			for (Long departmentId : departmentIds) {
			issueForm.addDepartmentId(departmentId);
			}
			}
			} 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));
			}


			// 프로젝트 입력
			Project project = issueType.getProject();
			if (project == null){
			throw new OwlRuntimeException(this.messageAccessor.getMessage(MsgConstants.API_PARAMETER_PROJECT_ERROR));
			throw new ApiParameterException(this.messageAccessor.getMessage(MsgConstants.API_PARAMETER_PROJECT_ERROR));
			}
			issueForm.setProjectId(project.getId());

			@@ -245,20 +290,41 @@
			issueForm.setSeverityId(issueApiDefault.getSeverity().getId());
			}

			// 중복 값 하위 이슈로 처리하기
			// 중복 값 상위 이슈의 하위 이슈로 처리하기
			CustomFieldApiOverlapForm customFieldApiOverlapForm = new CustomFieldApiOverlapForm();
			customFieldApiOverlapForm.setUserId(user.getId());
			customFieldApiOverlapForm.setIssueTypeId(issueForm.getIssueTypeId());

			IssueVo issueVo = this.findIssue(issueApiForm, user.getId());
			if (issueVo != null) {
			issueForm.setParentIssueId(issueVo.getId());
			// 상위일감에 사용할 중복값 설정
			List<CustomFieldApiOverlap> customFieldApiOverlaps = this.customFieldApiOverlapService.find(user.getId(), issueApiForm.getIssueTypeId());
			// if (customFieldApiOverlaps == null \|\| customFieldApiOverlaps.size() == 0){
			// throw new OwlRuntimeException(this.messageAccessor.getMessage(MsgConstants.API_OVERLAP_SETTING_NOT_EXIST));
			// }
			if (customFieldApiOverlaps != null && customFieldApiOverlaps.size() > 0) {
			for (int i = 0; i < customFieldApiOverlaps.size(); i++) {
			CustomFieldApiOverlap customFieldApiOverlap = customFieldApiOverlaps.get(i);
			issueApiForm.addUseIssueCustomFieldId(customFieldApiOverlap.getCustomField().getId());
			}

			// 종료상태가 아닌 중복된 상위 이슈검색
			List<Issue> issues = this.findIssue(issueApiForm, customFieldApiOverlaps, user.getId());
			int size = issues.size();
			if (size > 0) {
			Issue targetIssue = issues.get(0);
			if (targetIssue.getParentIssue() != null) {
			issueForm.setParentIssueId(targetIssue.getParentIssue().getId());
			} else {
			issueForm.setParentIssueId(targetIssue.getId());
			}
			}
			}

			issueForm.setIsApi(Issue.IS_API_YES);

			// 사용자 정의 필드 설정
			issueForm.setIssueCustomFields(issueApiForm.getCustomFieldValues());
			// 같은 도메인 업체 찾기
			this.findCompanyField(issueForm);

			// api 입력값 적용
			ConvertUtil.copyProperties(issueApiForm, issueForm);
			@@ -266,8 +332,54 @@
			return issueForm;

			} else {
			throw new OwlRuntimeException(this.messageAccessor.getMessage(MsgConstants.API_USER_ERROR));
			throw new ApiAuthException(this.messageAccessor.getMessage(MsgConstants.API_USER_ERROR));
			}
			}

			private IssueForm findCompanyField(IssueForm issueForm) {
			if(issueForm.getIssueCustomFields() != null && issueForm.getIssueCustomFields().size() > 0) {
			CompanyFieldCondition condition = new CompanyFieldCondition();
			List<Map<String, Object>> companyFields = this.companyFieldService.find(condition);
			List<Map<String, Object>> issueCompanyFields = Lists.newArrayList();
			List<Map<String, Object>> issueIspFields = Lists.newArrayList();
			List<Map<String, Object>> issueHostingFields = Lists.newArrayList();

			for (Map<String, Object> issueCustomField : issueForm.getIssueCustomFields()) {
			Long customFieldId = MapUtil.getLong(issueCustomField, "customFieldId");
			CustomField customField = this.customFieldService.getCustomField(customFieldId);
			if(customField != null && customField.getCustomFieldType().toString().equals("SITE") && customField.getName().equals("도메인")) {
			String useValue = issueCustomField.get("useValue").toString();
			if(companyFields != null && companyFields.size() > 0) {
			for (Map<String, Object> companyField : companyFields) {
			CompanyFieldVo companyFieldVo = ConvertUtil.convertMapToClass(companyField, CompanyFieldVo.class);
			if(useValue.equals(companyFieldVo.getUrl())) {
			companyField.put("companyId", companyField.get("id"));
			issueCompanyFields.add(companyField);
			if(companyFieldVo.getIspId() != null) {
			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) {
			Map<String, Object> hostingField = this.hostingFieldService.find(companyFieldVo.getHostingId());
			if (hostingField != null) {
			hostingField.put("hostingId", hostingField.get("id"));
			issueHostingFields.add(hostingField);
			}
			}
			}
			}
			}
			}
			issueForm.setIssueCompanyFields(issueCompanyFields);
			issueForm.setIssueIspFields(issueIspFields);
			issueForm.setIssueHostingFields(issueHostingFields);
			}
			}

			return issueForm;
			}

			private User convertToUser(String token) {
			@@ -282,36 +394,84 @@
			// API 를 통해 이슈 추가.
			@Override
			@Transactional
			public Issue addApiIssue(IssueApiForm issueApiForm) {
			public List<Issue> addApiIssue(IssueApiForm issueApiForm) throws CloneNotSupportedException {
			User user = convertToUser(issueApiForm.getToken());
			IssueForm issueForm = this.convertToIssueForm(issueApiForm, user);

			return addIssue(user, issueForm, issueApiForm.getMultipartFiles());
			List<Issue> issues = Lists.newArrayList();
			if (issueForm.getParentIssueId() != null // 기존 추가된 상위 일감이 없거나 설정된 중복 이슈 id가 없을때
			\|\| issueApiForm.getUseIssueCustomFieldIds().size() == 0) {
			issues.add(addIssue(user, issueForm, issueApiForm.getMultipartFiles()));
			} else {
			// 가상 상위 이슈 추가
			IssueForm parentIssueForm = issueForm.clone();
			// 가상 상위 이슈 추가
			parentIssueForm.setUseIssueCustomFields(issueApiForm.getUseIssueCustomFieldIds());
			// 같은 도메인 업체 찾기
			IssueForm partners = this.findCompanyField(parentIssueForm);
			parentIssueForm.setIssueCompanyFields(partners.getIssueCompanyFields());
			parentIssueForm.setIssueIspFields(partners.getIssueIspFields());
			parentIssueForm.setIssueHostingFields(partners.getIssueHostingFields());

			Issue issue = addIssue(user, parentIssueForm, null);
			issues.add(issue);
			// 하위 이슈 추가
			issueForm.setParentIssueId(issue.getId());
			issues.add(addIssue(user, issueForm, issueApiForm.getMultipartFiles()));
			}

			return issues;
			}


			// 상위 이슈 가져오기
			private IssueVo getParentIssueVo(Long parentIssueId) {
			if (parentIssueId != null) {
			Issue parentIssue = this.getIssue(parentIssueId);
			return ConvertUtil.copyProperties(parentIssue, IssueVo.class);
			}
			return null;
			}

			// 중복된 상위 이슈 검색
			private IssueVo findIssue(IssueApiForm issueApiForm, Long userId) {
			IssueCustomFieldValueCondition issueCustomFieldValueCondition = new IssueCustomFieldValueCondition();
			private List<Issue> findIssue(IssueApiForm issueApiform, List<CustomFieldApiOverlap> customFieldApiOverlaps, Long userId) {
			List<IssueCustomFieldValueForm> issueCustomFieldValueForms = issueApiform.getIssueCustomFieldValues();
			List<Issue> resultIssueVos = Lists.newArrayList();
			String comma = ",";

			List<CustomFieldApiOverlap> customFieldApiOverlaps = this.customFieldApiOverlapService.find(userId, issueApiForm.getIssueTypeId());
			if (customFieldApiOverlaps != null && customFieldApiOverlaps.size() > 0) {
			for (CustomFieldApiOverlap customFieldApiOverlap : customFieldApiOverlaps) {
			for (IssueCustomFieldValueForm issueCustomFieldValue : issueApiForm.getIssueCustomFieldValues()) {
			if (customFieldApiOverlap.getCustomField().getId().equals(issueCustomFieldValue.getCustomFieldId())) {
			issueCustomFieldValueCondition.addUseValues(issueCustomFieldValue.getUseValue());
			if (issueCustomFieldValueForms.size() > 0) {
			String concatUseValue = "";
			int useIdx = 0;

			IssueCustomFieldValueFormComparator comp = new IssueCustomFieldValueFormComparator();
			Collections.sort(issueCustomFieldValueForms, comp);

			List<String> userValues = Lists.newArrayList();
			for (IssueCustomFieldValueForm issueCustomFieldValueForm : issueCustomFieldValueForms) {
			userValues.add(issueCustomFieldValueForm.getUseValue());
			for(CustomFieldApiOverlap customFieldApiOverlap : customFieldApiOverlaps) {
			if (customFieldApiOverlap.getCustomField().getId().equals(issueCustomFieldValueForm.getCustomFieldId())) {
			if (useIdx > 0) {
			concatUseValue = concatUseValue.concat(comma);
			}
			concatUseValue = concatUseValue.concat(issueCustomFieldValueForm.getUseValue());
			useIdx++;
			}
			}
			}

			IssueCustomFieldValueCondition issueCustomFieldValueCondition = new IssueCustomFieldValueCondition();
			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) {
			IssueVo issueVo = new IssueVo();
			ConvertUtil.convertMapToObject(results.get(0), issueVo);
			return issueVo;
			for (Map<String, Object> result : results) {
			resultIssueVos.add(this.getIssue(MapUtil.getLong(result, "id")));
			}
			}
			}
			return null;
			return resultIssueVos;
			}

			// 이슈를 생성한다.
			@@ -342,7 +502,7 @@
			// 날짜 유효성 체크
			this.checkStartCompleteDate(issueForm.getStartDate(), issueForm.getCompleteDate());
			// 담당 부서 유효성 체크
			this.verifyIssueDepartment(project, issueForm);
			//this.verifyIssueDepartment(project, issueForm);

			// 이슈 상태 유형이 '대기' 인 이슈 상태 가져오기
			IssueStatus issueStatus = this.issueStatusService.findByIssueStatusTypeIsReady(issueType.getWorkflow());
			@@ -368,12 +528,181 @@
			// 담당부서 지정
			this.issueDepartmentService.modifyIssueDepartment(issue, user, project.getWorkspace(), issueForm.getDepartmentIds());
			// 업체 정보 저장
			this.issueCompanyService.modifyIssueCompanyField(issue, issueForm.getIssueCompanyFields());
			this.issueCompanyService.modifyIssueCompanyField(issue, issueForm);
			// ISP 정보 저장
			this.issueIspService.modifyIssueIspField(issue, issueForm.getIssueIspFields());
			this.issueIspService.modifyIssueIspField(issue, issueForm);
			// HOSTING 정보 저장
			this.issueHostingService.modifyIssueHostingField(issue, issueForm.getIssueHostingFields());
			this.issueHostingService.modifyIssueHostingField(issue, issueForm);

			// 첨부 파일 저장
			// multipartFile 을 file Map List 객체로 변경한다.
			List<Map<String, Object>> convertFileMaps = this.convertMultipartFileToFile(multipartFiles);
			this.attachedFileService.addAttachedFile(convertFileMaps, issue, user.getAccount());

			// 텍스트 에디터에 첨부한 파일을 이슈와 연결
			this.checkNotHaveIssueIdAttachedFile(issue, issueForm);
			// 사용자 정의 필드 저장
			this.issueCustomFieldValueService.modifyIssueCustomFieldValue(issue, issueForm.getIssueCustomFields());
			// 이슈 이력 생성
			this.issueHistoryService.addIssueHistory(issue, user, IssueHistoryType.ADD, null);
			// 이슈 위험 관리 생성
			this.issueRiskService.addIssueRisk(issue, project.getWorkspace());
			// 영속성 컨텍스트 비우기
			this.clear();
			// 이슈 생성, 삭제시 예약 이메일에 등록해놓는다.
			this.reservationIssueEmail(issue, EmailType.ISSUE_ADD);
			// 사용자 시스템 기능 사용 정보 수집

			UserVo userVo = ConvertUtil.copyProperties(user, UserVo.class);
			log.info(ElasticSearchUtil.makeUserActiveHistoryMessage(userVo, ElasticSearchConstants.ISSUE_ADD));

			return issue;
			}

			// 연관이슈를 생성한다.
			@Override
			@Transactional
			public Issue addRelIssue(IssueForm issueForm, List<MultipartFile> multipartFiles) {
			User user = this.webAppUtil.getLoginUserObject();
			return addRelIssue(user, issueForm, multipartFiles);
			}

			// 하위이슈를 생성한다.
			@Override
			@Transactional
			public Issue addDownIssue(IssueForm issueForm, List<MultipartFile> multipartFiles) {
			User user = this.webAppUtil.getLoginUserObject();
			return addDownIssue(user, issueForm, multipartFiles);
			}

			// 하위이슈를 생성한다.
			@Override
			@Transactional
			public Issue addDownIssue(User user, IssueForm issueForm, List<MultipartFile> multipartFiles) {
			// 사용하고 있는 업무 공간이 활성 상태인지 확인한다. 사용 공간에서 로그인한 사용자가 비활성인지 확인한다.
			Workspace workspace = this.workspaceService.checkUseWorkspace(user, user.getLastWorkspaceId());
			// 프로젝트 유효성 체크
			Project project = this.projectService.getProject(issueForm.getProjectId());
			// 이슈 유형 유효성 체크
			IssueType issueType = this.issueTypeService.getIssueType(issueForm.getIssueTypeId());
			// 우선순위 유효성 체크
			Priority priority = this.priorityService.getPriority(issueForm.getPriorityId());
			// 중요도 유효성 체크
			Severity severity = this.severityService.getSeverity(issueForm.getSeverityId());

			// 제목 유효성 체크
			this.verifyTitle(issueForm.getTitle());
			// 날짜 유효성 체크
			this.checkStartCompleteDate(issueForm.getStartDate(), issueForm.getCompleteDate());
			// 담당 부서 유효성 체크
			//this.verifyIssueDepartment(project, issueForm);

			// 이슈 상태 유형이 '대기' 인 이슈 상태 가져오기
			IssueStatus issueStatus = this.issueStatusService.findByIssueStatusTypeIsReady(issueType.getWorkflow());

			Issue issue = ConvertUtil.copyProperties(issueForm, Issue.class);
			issue.setProject(project);
			issue.setIssueStatus(issueStatus);
			issue.setIssueType(issueType);
			issue.setPriority(priority);
			issue.setSeverity(severity);
			if (issueForm.getParentIssueId() != null){
			Issue parentIssue = this.getIssue(issueForm.getParentIssueId());
			issue.setParentIssue(parentIssue);
			}

			issue.setIssueNumber(this.issueNumberGeneratorService.generateIssueNumber(project)); // 각 프로젝트의 고유 이슈 번호 생성

			issue = this.issueRepository.saveAndFlush(issue);

			issue.setReverseIndex(issue.getId() * -1); // 쿼리 속도 개선을 위해 리버스 인덱스 생성
			// 담당자 지정
			//this.issueUserService.modifyIssueUser(issue, project.getWorkspace(), issueForm.getUserIds());
			// 담당부서 지정
			this.issueDepartmentService.modifyIssueDepartment(issue, user, project.getWorkspace(), issueForm.getDepartmentIds());
			// 업체 정보 저장
			this.issueCompanyService.modifyIssueCompanyField(issue, issueForm);
			// ISP 정보 저장
			this.issueIspService.modifyIssueIspField(issue, issueForm);
			// HOSTING 정보 저장
			this.issueHostingService.modifyIssueHostingField(issue, issueForm);

			// 첨부 파일 저장
			// multipartFile 을 file Map List 객체로 변경한다.
			List<Map<String, Object>> convertFileMaps = this.convertMultipartFileToFile(multipartFiles);
			this.attachedFileService.addAttachedFile(convertFileMaps, issue, user.getAccount());

			// 텍스트 에디터에 첨부한 파일을 이슈와 연결
			this.checkNotHaveIssueIdAttachedFile(issue, issueForm);
			// 사용자 정의 필드 저장
			this.issueCustomFieldValueService.modifyIssueCustomFieldValue(issue, issueForm.getIssueCustomFields());
			// 이슈 이력 생성
			this.issueHistoryService.addIssueHistory(issue, user, IssueHistoryType.ADD, null);
			// 이슈 위험 관리 생성
			this.issueRiskService.addIssueRisk(issue, project.getWorkspace());
			// 영속성 컨텍스트 비우기
			this.clear();
			// 이슈 생성, 삭제시 예약 이메일에 등록해놓는다.
			this.reservationIssueEmail(issue, EmailType.ISSUE_ADD);
			// 사용자 시스템 기능 사용 정보 수집

			UserVo userVo = ConvertUtil.copyProperties(user, UserVo.class);
			log.info(ElasticSearchUtil.makeUserActiveHistoryMessage(userVo, ElasticSearchConstants.ISSUE_ADD));

			return issue;
			}

			// 연관이슈를 생성한다.
			@Override
			@Transactional
			public Issue addRelIssue(User user, IssueForm issueForm, List<MultipartFile> multipartFiles) {
			// 사용하고 있는 업무 공간이 활성 상태인지 확인한다. 사용 공간에서 로그인한 사용자가 비활성인지 확인한다.
			Workspace workspace = this.workspaceService.checkUseWorkspace(user, user.getLastWorkspaceId());
			// 프로젝트 유효성 체크
			Project project = this.projectService.getProject(issueForm.getProjectId());
			// 이슈 유형 유효성 체크
			IssueType issueType = this.issueTypeService.getIssueType(issueForm.getIssueTypeId());
			// 우선순위 유효성 체크
			Priority priority = this.priorityService.getPriority(issueForm.getPriorityId());
			// 중요도 유효성 체크
			Severity severity = this.severityService.getSeverity(issueForm.getSeverityId());

			// 제목 유효성 체크
			this.verifyTitle(issueForm.getTitle());
			// 날짜 유효성 체크
			this.checkStartCompleteDate(issueForm.getStartDate(), issueForm.getCompleteDate());
			// 담당 부서 유효성 체크
			//this.verifyIssueDepartment(project, issueForm);

			// 이슈 상태 유형이 '대기' 인 이슈 상태 가져오기
			IssueStatus issueStatus = this.issueStatusService.findByIssueStatusTypeIsReady(issueType.getWorkflow());

			Issue issue = ConvertUtil.copyProperties(issueForm, Issue.class);
			issue.setProject(project);
			issue.setIssueStatus(issueStatus);
			issue.setIssueType(issueType);
			issue.setPriority(priority);
			issue.setSeverity(severity);
			if (issueForm.getParentIssueId() != null){
			Issue parentIssue = this.getIssue(issueForm.getParentIssueId());
			issue.setParentIssue(parentIssue);
			}

			issue.setIssueNumber(this.issueNumberGeneratorService.generateIssueNumber(project)); // 각 프로젝트의 고유 이슈 번호 생성

			issue = this.issueRepository.saveAndFlush(issue);

			issue.setReverseIndex(issue.getId() * -1); // 쿼리 속도 개선을 위해 리버스 인덱스 생성
			// 담당자 지정
			//this.issueUserService.modifyIssueUser(issue, project.getWorkspace(), issueForm.getUserIds());
			// 담당부서 지정
			this.issueDepartmentService.modifyIssueDepartment(issue, user, project.getWorkspace(), issueForm.getDepartmentIds());
			// 업체 정보 저장
			this.issueCompanyService.modifyIssueCompanyField(issue, issueForm);
			// ISP 정보 저장
			this.issueIspService.modifyIssueIspField(issue, issueForm);
			// HOSTING 정보 저장
			this.issueHostingService.modifyIssueHostingField(issue, issueForm);

			// 첨부 파일 저장
			// multipartFile 을 file Map List 객체로 변경한다.
			@@ -421,7 +750,7 @@
			}

			// 이슈 정보를 이메일 전송에 사용하기 위해 Map 형태로 변환한다.
			private void makeIssueMapToIssue(Issue issue, Map<String, Object> issueMap) {
			public void makeIssueMapToIssue(Issue issue, Map<String, Object> issueMap) {
			issueMap.put("title", issue.getTitle());
			issueMap.put("issueNumber", issue.getIssueNumber());
			issueMap.put("issueTypeName", issue.getIssueType().getName());
			@@ -548,12 +877,55 @@
			}
			}

			void SetMyDepartmentId(IssueCondition issueCondition){
			Long loginId = issueCondition.getLoginUserId();
			List<Long> myDepartmentIds = Lists.newArrayList();
			List<UserDepartment> myDepartments = this.userDepartmentRepository.findByUserId(loginId);

			if(myDepartments != null && myDepartments.size() > 0){
			for(UserDepartment myDepartment : myDepartments){
			myDepartmentIds.add(myDepartment.getDepartmentId());
			}
			} else {
			myDepartmentIds.add(-1L);
			}
			issueCondition.setMyDepartmentIds(myDepartmentIds);
			}

			void SetAllDepartmentId(IssueCondition issueCondition){
			List<Long> departmentIds = Lists.newArrayList();
			List<Map<String, Object>> departmentList = this.departmentMapper.find(null);

			if(departmentList != null && departmentList.size() > 0){
			for(Map<String, Object> department : departmentList){
			departmentIds.add((Long) department.get("id"));
			}
			}
			issueCondition.setMyDepartmentIds(departmentIds);
			}

			void SetWorkflowDepartment(List<IssueVo> issueVos){
			for(IssueVo issueVo : issueVos){
			Long issueTypeId = issueVo.getIssueTypeId();
			IssueType issueType = this.issueTypeService.getIssueType(issueTypeId);
			Long workflowId = issueType.getWorkflow().getId();
			List<WorkflowDepartment> workflowDepartmentList = this.workflowDepartmentRepository.findByWorkflowId(workflowId);
			List<Long> workflowDepartmentIds = Lists.newArrayList();
			if(workflowDepartmentList != null && workflowDepartmentList.size()>0){
			for(WorkflowDepartment workflowDepartment : workflowDepartmentList){
			workflowDepartmentIds.add(workflowDepartment.getDepartment().getId());
			}
			}
			if(issueVo.getIssueTypeId().equals(issueTypeId)){
			issueVo.setWorkflowDepartmentIds(workflowDepartmentIds);
			}
			}
			}

			// 이슈 목록을 조회한다.
			@Override
			@Transactional(readOnly = true)
			public List<IssueVo> findIssue(Map<String, Object> resJsonData,
			IssueCondition issueCondition, Pageable pageable) {

			public List<IssueVo> findIssue(Map<String, Object> resJsonData, IssueCondition issueCondition, Pageable pageable) {
			// 검색 조건을 만든다
			if (!this.makeIssueSearchCondition(issueCondition, Lists.newArrayList("01", "02", "03"), pageable)) {
			// 이슈 목록을 찾지 못할 경우 기본 정보로 리턴한다.
			@@ -570,32 +942,58 @@
			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);
			User user = this.webAppUtil.getLoginUserObject();

			List<Map<String, Object>> results = this.issueMapper.find(issueCondition);
			issueCondition.setLoginUserId(user.getId());
			issueCondition.setWorkspaceId(user.getLastWorkspaceId());

			// 튜닝 전 - 0.8, 0.9, 0.9, 0.9, 0.9
			/*StopWatch serviceStart = new StopWatch();
			serviceStart.start();*/
			Long totalCount = this.issueMapper.count(issueCondition);
			// 튜닝 전 - 1.1, 1.1, 1.3, 1.2

			/*serviceStart.stop();
			log.debug("serviceENd1 : " + serviceStart.getTime());*/
			List<Map<String, Object>> results = Lists.newArrayList();
			Long totalCount = 0L;
			// UserLevel userLevel = this.userLevelService.getUserLevel(user.getUserLevel().getId());

			// if (!this.userWorkspaceService.checkWorkspaceManager(user)
			// && !MngPermission.checkMngPermission(userLevel.getPermission(), MngPermission.USER_PERMISSION_MNG_ISSUE)) { //최고관리자 & 프로젝트,이슈 관리자 일 경우 모든 이슈 보기
			// this.SetMyDepartmentId(issueCondition);
			//this.SetAllDepartmentId(issueCondition);
			// } /*else{
			// 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);

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

			int totalPage = (int) Math.ceil((totalCount - 1) / pageable.getPageSize()) + 1;
			// 이슈 아이디 초기화

			issueCondition.setIsApi(issueCondition.getIsApi());

			issueCondition.setIssueIds(Lists.newArrayList());
			// Map 에 있는 데이터를 IssueVo 데이터로 변환한다.
			this.setMapToIssueVo(results, issueVos, issueCondition);
			this.setMapToIssueVo(results, issueVos, issueCondition, user);

			this.setCountDownIssues(results, issueVos);
			if (issueCondition.getTree()) {
			this.setParentIssue(issueVos);
			this.setDownIssues(user, issueVos);
			this.setRelationIssues(issueVos);
			}

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

			resJsonData.put(Constants.RES_KEY_CONTENTS, issueVos);
			resJsonData.put(Constants.REQ_KEY_PAGE_VO, new ResPage(pageable.getPageNumber(), pageable.getPageSize(),
			@@ -606,23 +1004,87 @@
			return issueVos;
			}

			private void setCountDownIssues(List<Map<String, Object>> results, List<IssueVo> issueVos) {
			for (Map<String, Object> result : results){
			List<Issue> downIssues = this.issueRepository.findByParentIssueId((Long) result.get("id")); //하위이슈 가져오기

			// 하위 이슈 세팅(재귀)
			private void setDownIssues(User user, List<IssueVo> issueVos) {
			for(IssueVo issueVo : issueVos) {
			List<Issue> downIssues = this.issueRepository.findByParentIssueId(issueVo.getId());
			List<IssueVo> downIssueVos = Lists.newArrayList();
			IssueCondition issueCondition = new IssueCondition();
			issueCondition.addIssueIds(String.valueOf(issueVo.getId()));

			for(Issue downIssue : downIssues){
			IssueVo addIssueVo = ConvertUtil.copyProperties(downIssue, IssueVo.class);
			addIssueVo.setIssueTypeId(downIssue.getIssueType().getId());
			downIssueVos.add(addIssueVo);
			}
			issueVo.setIssueDownVos(downIssueVos);

			if (downIssueVos.size() > 0) {
			this.setDownIssues(user, downIssueVos);
			}

			// 이슈 사용자 정보 추가
			//this.setIssueUserList(issueVos, issueCondition);
			this.setIssueDepartmentList(issueVos, issueCondition, user);
			// 등록자 정보 추가
			this.setRegister(issueVos); // 담당자 정보 셋팅
			// 사용자 정의 필드 정보 추가
			this.setIssueCustomFieldValue(issueVos, issueCondition);
			//워크플로우에 설정한 담당부서 가져오기
			this.SetWorkflowDepartment(issueVos);
			}
			}

			// 연관 이슈 세팅
			private void setRelationIssues(List<IssueVo> issueVos) {
			for(IssueVo issueVo : issueVos) {
			List<IssueVo> relationIssues = this.issueRelationService.findRelationIssue(issueVo.getId());
			for(IssueVo relationIssue : relationIssues){
			issueVo.addRelationIssueVo(ConvertUtil.copyProperties(relationIssue, IssueVo.class));
			}
			}
			}

			// 상위 이슈 체크
			private void setParentIssue(List<IssueVo> issueVos) {
			for(IssueVo issueVo : issueVos) {
			if(issueVo.getParentIssueId() != null) {
			Issue parentIssue = this.getIssue(issueVo.getParentIssueId());
			//issueVo.setParentIssueVo(ConvertUtil.copyProperties(parentIssue, IssueVo.class));
			if(parentIssue.getIssueCustomFieldValues() == null \|\| parentIssue.getIssueCustomFieldValues().size() == 0){
			issueVo.setIssueCustomFieldValueVos(null);
			}
			ConvertUtil.copyProperties(parentIssue, issueVo);
			}
			}
			}

			@Override
			@Transactional(readOnly = true)
			public void setCountDownIssues(List<IssueVo> issueVos) {
			for (IssueVo issueVo : issueVos){
			List<Issue> downIssues = this.issueRepository.findByParentIssueId(issueVo.getId()); //하위이슈 가져오기
			if(downIssues != null && downIssues.size() > 0){ //상위이슈 가지고 있는 애들이 있으면
			int downIssueCount = 0;
			int downIssueAllCount = 0;// 하위이슈 전체 카운트
			int downIssueCount = 0;// 하위이슈 미완료 카운트
			for(Issue downIssue : downIssues){
			downIssueCount ++;
			downIssueAllCount ++;
			Long parentIssueId = downIssue.getParentIssue().getId();
			Issue parentIssue = this.getIssue(parentIssueId);
			IssueVo parentIssueVo = ConvertUtil.copyProperties(parentIssue, IssueVo.class);
			parentIssueVo.setDownIssueCount(downIssueCount);
			parentIssueVo.setDownIssueAllCount(downIssueAllCount);

			for(IssueVo issueVo : issueVos){
			if(issueVo.getId().equals(parentIssueVo.getId())){
			issueVo.setDownIssueCount(parentIssueVo.getDownIssueCount());
			}
			IssueStatus downIssueStatus = this.issueStatusService.getIssueStatus(downIssue.getIssueStatus().getId());
			IssueVo downIssueVo = ConvertUtil.copyProperties(downIssue, IssueVo.class);
			downIssueVo.setIssueStatusType(downIssueStatus.getIssueStatusType().toString());

			if(!downIssueVo.getIssueStatusType().equals("CLOSE")){ //미완료 하위이슈 체크
			downIssueCount ++;
			}

			issueVo.setDownIssueCount(downIssueCount);
			issueVo.setDownIssueAllCount(parentIssueVo.getDownIssueAllCount());
			}
			}
			}
			@@ -635,15 +1097,19 @@
			public void findApiIssue(ApiMonitorCondition apiMonitorCondition, Map<String, Object> resJsonData) {

			IssueTypeCondition issueTypeCondition = new IssueTypeCondition();
			issueTypeCondition.setIsApi(Issue.IS_API_YES);
			List<IssueTypeVo> issueTypes = this.issueTypeService.findIssueType(issueTypeCondition);

			// 값이 없을 경우 초기값 입력
			if (StringUtils.isEmpty(apiMonitorCondition.getSearchPeriod())) {
			apiMonitorCondition.setSearchPeriod(DateUtil.LAST_SEVEN_DAYS);
			}

			// 검색 일자를 구한다.
			List<Date> searchDates = CommonUtil.findSearchPeriod(apiMonitorCondition.getSearchPeriod());
			List<Date> searchDates = Lists.newArrayList();
			if (apiMonitorCondition.getSearchPeriod().equals(DateUtil.CUSTOM_INPUT)) {
			Date startDate = DateUtil.convertStrToDate(apiMonitorCondition.getSearchStartDate(), "yyyy-MM-dd");
			Date endDate = DateUtil.addDays(DateUtil.convertStrToDate(apiMonitorCondition.getSearchEndDate(), "yyyy-MM-dd"), 1);

			searchDates = CommonUtil.findSearchPeriod(startDate, endDate);
			} else {
			searchDates = CommonUtil.findSearchPeriod(apiMonitorCondition.getSearchPeriod());
			}

			// 날짜가 검색되지 않았으면 오류
			if (searchDates.size() < 1) {
			@@ -732,7 +1198,9 @@

			IssueCondition issueCondition = new IssueCondition();
			// 검색 조건을 만든다
			if (!this.makeIssueSearchCondition(issueCondition, projectCondition, pageable)) {

			User user = this.webAppUtil.getLoginUserObject();
			if (!this.makeIssueSearchCondition(user, issueCondition, projectCondition, pageable)) {
			// 이슈 목록을 찾지 못할 경우 기본 정보로 리턴한다.
			this.notFoundIssueList(resJsonData, pageable);
			return Lists.newArrayList();
			@@ -776,7 +1244,7 @@
			}

			// Map 에 있는 데이터를 IssueVo 데이터로 변환한다.
			private void setMapToIssueVo(List<Map<String, Object>> results, List<IssueVo> issueVos, IssueCondition issueCondition) {
			private void setMapToIssueVo(List<Map<String, Object>> results, List<IssueVo> issueVos, IssueCondition issueCondition, User user) {
			for (Map<String, Object> result : results) {
			IssueVo issueVo = ConvertUtil.convertMapToClass(result, IssueVo.class);
			issueVos.add(issueVo);
			@@ -785,7 +1253,7 @@

			// 이슈 사용자 정보 추가
			//this.setIssueUserList(issueVos, issueCondition);
			this.setIssueDepartmentList(issueVos, issueCondition);
			this.setIssueDepartmentList(issueVos, issueCondition, user);
			// 등록자 정보 추가
			this.setRegister(issueVos); // 담당자 정보 셋팅

			@@ -803,6 +1271,9 @@
			condition.setLoginUserId(this.webAppUtil.getLoginId());
			condition.setWorkspaceId(this.userService.getUser(this.webAppUtil.getLoginId()).getLastWorkspaceId());

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

			// 프로젝트 키가 존재할 경우 프로젝트 키에 해당하는 프로젝트를 조회하고 검색 조건에 셋팅한다.
			if (!this.getProjectByProjectKey(condition.getProjectKey(), condition)) {
			return false;
			@@ -810,9 +1281,17 @@

			// 프로젝트를 선택하지 않았으면 해당 업무 공간에서 참여하고 있는 프로젝트를 찾는다.
			if (condition.getProjectIds().size() < 1) {
			List<Map<String, Object>> projects = this.projectService.findByWorkspaceIdAndIncludeProjectAll(projectStatues, condition.getProjectType());
			List<Long> projectIds = Lists.newArrayList();
			List<Map<String, Object>> projects = Lists.newArrayList();
			if (this.userWorkspaceService.checkWorkspaceManager(user) \|\| MngPermission.checkMngPermission(userLevel.getPermission(), MngPermission.USER_PERMISSION_MNG_PROJECT)){
			return true;
			}/*else if (MngPermission.checkMngPermission(userLevel.getPermission(), MngPermission.USER_PERMISSION_MNG_ISSUE)){
			projects = this.projectService.findByWorkspaceIdAndIncludeProjectAll(projectStatues, condition.getProjectType());
			}*/
			else {
			projects = this.projectService.findByWorkspaceIdAndIncludeProject(projectStatues, condition.getProjectType());
			}

			List<Long> projectIds = Lists.newArrayList();
			for (Map<String, Object> result : projects) {
			Long projectId = MapUtil.getLong(result, "id");

			@@ -832,7 +1311,7 @@
			}

			// 검색 조건을 만든다
			private boolean makeIssueSearchCondition(IssueCondition condition, ProjectCondition projectCondition, Pageable pageable) {
			private boolean makeIssueSearchCondition(User user, IssueCondition condition, ProjectCondition projectCondition, Pageable pageable) {
			if (pageable != null) {
			condition.setPage(pageable.getPageNumber() * pageable.getPageSize());
			condition.setPageSize(pageable.getPageSize());
			@@ -850,7 +1329,10 @@
			// 프로젝트를 선택하지 않았으면 해당 업무 공간에서 참여하고 있는 프로젝트를 찾는다.
			if (condition.getProjectIds().size() < 1) {
			List<Map<String, Object>> projects = null;
			if (this.userWorkspaceService.checkWorkspaceManager()) {
			UserLevel userLevel = this.userLevelService.getUserLevel(user.getUserLevel().getId());
			if (this.userWorkspaceService.checkWorkspaceManager(user)
			\|\| (MngPermission.checkMngPermission(userLevel.getPermission(), MngPermission.USER_PERMISSION_MNG_PROJECT) &&
			MngPermission.checkMngPermission(userLevel.getPermission(), MngPermission.USER_PERMISSION_MNG_ISSUE))) {
			projects = this.projectMapper.findByWorkspaceManagerAll(projectCondition);
			} else {
			projects = this.projectService.findByWorkspaceIdAndIncludeProjectAll(projectCondition);
			@@ -928,7 +1410,7 @@
			}

			// 이슈 담당자 정보를 셋팅한다.
			private void setIssueUserList(List<IssueVo> issueVos, IssueCondition issueCondition) {
			private void setIssueUserList(List<IssueVo> issueVos, IssueCondition issueCondition, User user) {
			if (issueVos.size() < 1) {
			return;
			}
			@@ -959,14 +1441,14 @@
			}

			// 이슈 수정 권한을 갖고 있는지 확인
			if (this.checkHasPermission(issueVo, issueVo.getUserVos())) {
			if (this.checkHasPermission(issueVo, issueVo.getUserVos(), user, null)) {
			issueVo.setModifyPermissionCheck(Boolean.TRUE);
			}
			}
			}

			// 이슈 담당부서 정보를 셋팅한다.
			private void setIssueDepartmentList(List<IssueVo> issueVos, IssueCondition issueCondition) {
			private void setIssueDepartmentList(List<IssueVo> issueVos, IssueCondition issueCondition, User user) {
			if (issueVos.size() < 1) {
			return;
			}
			@@ -996,7 +1478,7 @@
			}

			// 이슈 수정 권한을 갖고 있는지 확인
			if (this.checkHasPermission(issueVo, issueVo.getUserVos())) {
			if (this.checkHasPermission(issueVo, issueVo.getUserVos(), user, issueVo.getDepartmentVos())) {
			issueVo.setModifyPermissionCheck(Boolean.TRUE);
			}
			}
			@@ -1007,10 +1489,24 @@
			@Transactional(readOnly = true)
			public void detailIssue(Map<String, Object> resJsonData, IssueCondition issueCondition) {
			IssueVo issueVo = new IssueVo();
			Pageable relPageable = issueCondition.getRelPageable();
			Pageable downPageable = issueCondition.getDownPageable();

			if (issueCondition.getId() != null) {
			Issue issue = this.getIssue(issueCondition.getId());
			issueVo = ConvertUtil.copyProperties(issue, IssueVo.class);
			User user = this.webAppUtil.getLoginUserObject();

			if (relPageable != null) {
			issueVo.setRelPageNumber(relPageable.getPageNumber());
			issueVo.setRelPageSize(relPageable.getPageSize());
			issueVo.setRelPage(relPageable.getPageNumber() * relPageable.getPageSize());
			}
			if (downPageable != null) {
			issueVo.setDownPageNumber(downPageable.getPageNumber());
			issueVo.setDownPage(downPageable.getPageNumber() * downPageable.getPageSize());
			issueVo.setDownPageSize(downPageable.getPageSize());
			}

			switch (issueCondition.getDeep()) {
			case "01": // 프로젝트, 이슈 유형, 이슈 상태, 우선순위, 중요도, 담당부서, 첨부파일, 사용자 정의 필드 정보를 셋팅한다.
			@@ -1027,53 +1523,78 @@
			this.setIssueCustomFields(issue, issueVo); // 사용자 정의 필드 값 정보 셋팅
			this.setRelationIssue(issue, issueVo); //연관 일감 셋팅
			this.setDownIssues(issue, issueVo); //하위 이슈 세팅

			break;

			case "02": // 프로젝트, 이슈 유형, 이슈 상태, 우선순위, 중요도, 담당자, 첨부파일, 사용자 정의 필드 정보, 댓글, 기록을 셋팅한다.
			this.setIssueDetail(issueVo, issue); // 이슈 상세 정보를 셋팅한다.
			this.setIssueDetail(issueVo, issue, user); // 이슈 상세 정보를 셋팅한다.
			this.setIssueTableConfigs(issue, issueVo, issueCondition);
			issueVo.setProjectVo(ConvertUtil.copyProperties(issue.getProject(), ProjectVo.class));
			break;
			}
			}

			// 사용자 시스템 기능 사용 정보 수집
			log.info(ElasticSearchUtil.makeUserActiveHistoryMessage(this.webAppUtil.getLoginUser(), ElasticSearchConstants.ISSUE_DETAIL));

			resJsonData.put(Constants.RES_KEY_CONTENTS, issueVo);
			}

			// 테이블 설정 셋팅
			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) {
			issueVo.addIssueTableConfigVo(createIssueTableConfigVo(IssueTypeId, tableConfigType));
			}
			}
			}

			private IssueTableConfigVo createIssueTableConfigVo(Long issueTypeId, int tableConfigType) {
			IssueTableConfig issueTableConfig = this.issueTableConfigService.findByUserIdAndWorkspaceIdAndIssueTypeIdAndIssueTableType(issueTypeId, tableConfigType);
			if (issueTableConfig != null) {
			return ConvertUtil.copyProperties(issueTableConfig, IssueTableConfigVo.class);
			}
			return new IssueTableConfigVo();
			}


			// 하위 이슈 정보를 셋팅한다
			private void setDownIssues(Issue issue, IssueVo issueVo) {
			List<Issue> downIssues = this.issueRepository.findByParentIssueId(issue.getId());
			/*if(issueVo != null && downIssues.size()>0){
			Page<Issue> downIssues = null;

			List<Issue> downIssueList = this.issueRepository.findByParentIssueId(issue.getId());
			if(downIssueList != null && downIssueList.size() > 0) {
			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);
			}
			if(downIssues != null){
			issueVo.setDownTotalPage(downIssues.getTotalPages());
			issueVo.setDownTotalCount(downIssues.getTotalElements());

			List<IssueVo> resultList = new ArrayList<>();
			for(Issue downIssue : downIssues){
			IssueVo downIssueVo = ConvertUtil.copyProperties(downIssue, IssueVo.class);
			IssueDownVo issueDownVo = ConvertUtil.copyProperties(downIssueVo, IssueDownVo.class);
			issueDownVo.setIssueDown(downIssueVo);
			issueDownVo.setTitle(downIssue.getTitle());
			issueDownVo.setIssueTypeVo(ConvertUtil.copyProperties(downIssue.getIssueType(), IssueTypeVo.class));
			issueDownVo.setPriorityVo(ConvertUtil.copyProperties(downIssue.getPriority(), PriorityVo.class));
			issueDownVo.setSeverityVo(ConvertUtil.copyProperties(downIssue.getSeverity(), SeverityVo.class));
			downIssueVo.setIssueTypeVo(ConvertUtil.copyProperties(downIssue.getIssueType(), IssueTypeVo.class));
			downIssueVo.setPriorityVo(ConvertUtil.copyProperties(downIssue.getPriority(), PriorityVo.class));
			downIssueVo.setSeverityVo(ConvertUtil.copyProperties(downIssue.getSeverity(), SeverityVo.class));
			//이슈 상태 추가
			IssueStatusVo issueStatusVo = ConvertUtil.copyProperties(downIssue.getIssueStatus(), IssueStatusVo.class, "issueStatusType");
			issueStatusVo.setIssueStatusType(downIssue.getIssueStatus().getIssueStatusType().toString());
			downIssueVo.setIssueStatusVo(issueStatusVo);

			this.setRegister(downIssue, downIssueVo); // 등록자
			this.setIssueDepartment(downIssue, downIssueVo); // 담당부서 정보 셋팅
			this.setIssueCustomFields(downIssue, downIssueVo); // 사용자정의필드 정보 세팅
			issueVo.addIssueDownVo(issueDownVo);
			}
			}*/
			this.setIssueHistory(downIssue, downIssueVo); // 이슈 기록 정보 셋팅
			this.setIssueComments(downIssue, downIssueVo); // 댓글 정보 셋팅

			List<IssueVo> downIssueVos = ConvertUtil.convertObjectsToClasses(downIssues, IssueVo.class);
			List<IssueVo> resultList = new ArrayList<>();
			if(downIssueVos != null && downIssueVos.size()>0){
			for(IssueVo downIssueVo : downIssueVos){
			for(Issue downIssue : downIssues){
			downIssueVo.setIssueTypeVo(ConvertUtil.copyProperties(downIssue.getIssueType(), IssueTypeVo.class));
			downIssueVo.setPriorityVo(ConvertUtil.copyProperties(downIssue.getPriority(), PriorityVo.class));
			downIssueVo.setSeverityVo(ConvertUtil.copyProperties(downIssue.getSeverity(), SeverityVo.class));
			this.setRegister(downIssue, downIssueVo); // 등록자
			this.setIssueDepartment(downIssue, downIssueVo); // 담당부서 정보 셋팅
			this.setIssueCustomFields(downIssue, downIssueVo); // 사용자정의필드 정보 세팅
			}
			downIssueVo.setModifyPermissionCheck(issueVo.getModifyPermissionCheck());

			resultList.add(downIssueVo);
			}
			issueVo.setIssueDownVos(resultList);
			@@ -1083,7 +1604,7 @@
			// 이슈 상세 정보를 셋팅한다.
			@Override
			@Transactional(readOnly = true)
			public void setIssueDetail(IssueVo issueVo, Issue issue) {
			public void setIssueDetail(IssueVo issueVo, Issue issue, User user) {
			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");
			@@ -1096,10 +1617,10 @@
			this.setIssueDepartment(issue, issueVo); // 담당부서 정보 셋팅
			this.setAttachedFiles(issue, issueVo); // 첨부 파일 정보 셋팅
			this.setIssueCustomFields(issue, issueVo); // 사용자 정의 필드 값 정보 셋팅
			this.setIssueComments(issue, issueVo); // 댓글 정보 셋팅
			this.setIssueHistory(issue, issueVo); // 이슈 기록 정보 셋팅
			this.setRelationIssue(issue, issueVo); //연관 일감 셋팅
			this.setDownIssues(issue, issueVo); //하위 일감 세팅
			this.setIssueComments(issue, issueVo); // 댓글 정보 셋팅
			this.setIssueHistory(issue, issueVo); // 이슈 기록 정보 셋팅

			IssueType issueType = this.issueTypeService.getIssueType(issueVo.getIssueTypeVo().getId()); // 이슈의 이슈유형 객체
			Integer using = issueType.getUsePartner() != null ? issueType.getUsePartner().intValue() : 0; // 이슈유형별로 사용중인 업체/ISP/호스팅 값
			@@ -1118,8 +1639,12 @@
			this.setIssueCompanyField(issue, issueVo); //업체 정보 세팅
			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);
			}
			}

			// 상위일감 정보 추가
			@@ -1150,13 +1675,18 @@

			// 연관 이슈 정보를 셋팅한다
			private void setRelationIssue(Issue issue, IssueVo issueVo) {
			Set<IssueRelation> issueRelations = issue.getIssueRelations();
			if (issue != null && issueVo != null && issueRelations.size() > 0) {
			for (IssueRelation issueRelation : issueRelations) {
			IssueRelationVo issueRelationVo = ConvertUtil.copyProperties(issueRelation, IssueRelationVo.class);
			//Set<IssueRelation> issueRelations = issue.getIssueRelations();

			Issue relationIssue = issueRelation.getRelationIssue();
			List<Map<String, Object>> results = this.issueRelationMapper.findByIssueId(issueVo);
			Long totalCount = this.issueRelationMapper.count(issueVo);

			if (issue != null && issueVo != null && results.size() > 0) {
			int totalPage = (int) Math.ceil((totalCount - 1) / issueVo.getRelPageSize()) + 1;
			issueVo.setRelTotalPage(totalPage);
			issueVo.setRelTotalCount(totalCount);
			for (Map<String, Object> result : results) {
			IssueRelationVo issueRelationVo = ConvertUtil.convertMapToClass(result, IssueRelationVo.class);
			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());
			@@ -1168,6 +1698,13 @@
			issueRelationVo.setIssueTypeVo(ConvertUtil.copyProperties(relationIssue.getIssueType(), IssueTypeVo.class));
			issueRelationVo.setPriorityVo(ConvertUtil.copyProperties(relationIssue.getPriority(), PriorityVo.class));
			issueRelationVo.setSeverityVo(ConvertUtil.copyProperties(relationIssue.getSeverity(), SeverityVo.class));
			//이슈 상태 추가
			IssueStatusVo issueStatusVo = ConvertUtil.copyProperties(relationIssue.getIssueStatus(), IssueStatusVo.class, "issueStatusType");
			issueStatusVo.setIssueStatusType(relationIssue.getIssueStatus().getIssueStatusType().toString());
			issueRelationVo.setIssueStatusVo(issueStatusVo);

			issueRelationVo.setModifyPermissionCheck(issueVo.getModifyPermissionCheck());

			this.setRegister(relationIssue, relIssueVo); // 등록자
			this.setIssueDepartment(relationIssue, relIssueVo); // 담당부서 정보 셋팅
			this.setIssueCustomFields(relationIssue, relIssueVo); // 사용자정의필드 정보 세팅
			@@ -1222,6 +1759,15 @@
			DepartmentVo departmentVo = ConvertUtil.copyProperties(issueDepartment.getDepartment(), DepartmentVo.class);
			departmentVo.setByName(departmentVo.getDepartmentName());
			departmentVos.add(departmentVo);

			List<UserDepartment> userDepartments = this.userDepartmentRepository.findByDepartmentId(departmentVo.getId());
			if (userDepartments != null && userDepartments.size() > 0) {
			for (UserDepartment userDepartment : userDepartments) {
			if (userDepartment.getUserId().equals(this.webAppUtil.getLoginId())){
			issueVo.setModifyPermissionCheck(Boolean.TRUE);
			}
			}
			}
			}
			issueVo.setDepartmentVos(departmentVos);
			}
			@@ -1240,7 +1786,7 @@
			}

			// 이슈(이슈 유형)에 연결된 사용자 정의 필드 정보를 셋팅한다.
			private void setIssueCustomFields(Issue issue, IssueVo issueVo) {
			private IssueVo setIssueCustomFields(Issue issue, IssueVo issueVo) {

			// 해당 프로젝트의 이슈 유형에 연결된 사용자 정의 필드 정보를 가져온다.
			IssueTypeCustomFieldCondition issueTypeCustomFieldCondition = new IssueTypeCustomFieldCondition();
			@@ -1252,6 +1798,8 @@
			// 이슈에서 사용된 사용자 정의 필드 값을 가져온다.
			List<IssueCustomFieldValueVo> issueCustomFieldValueVos = this.issueCustomFieldValueService.findByIssueId(issue.getId());
			issueVo.setIssueCustomFieldValueVos(issueCustomFieldValueVos);

			return issueVo;
			}

			// 이슈에 등록된 댓글 정보를 셋팅한다.
			@@ -1261,16 +1809,104 @@

			// 이슈 기록 정보를 셋팅한다.
			private void setIssueHistory(Issue issue, IssueVo issueVo) {
			issueVo.setIssueHistoryVos(this.issueHistoryService.findIssueHistory(issue.getId()));
			issueVo.setIssueHistoryVos(this.issueHistoryService.findIssueHistory(issue));
			}

			// 이슈를 수정한다
			// 사용자 정의 필드 값이 같은 이슈 찾기
			@Override
			public Issue modifyIssue(IssueApiForm issueApiForm, List<MultipartFile> files) {
			@Transactional
			public List<Issue> findIssue(IssueApiForm issueApiform) {

			List<IssueCustomFieldValueForm> issueCustomFieldValueForms = issueApiform.getIssueCustomFieldValues();
			List<Issue> resultIssueVos = Lists.newArrayList();
			String comma = ",";

			List<String> userValues = Lists.newArrayList();
			if (issueCustomFieldValueForms.size() > 0) {
			IssueCustomFieldValueFormComparator comp = new IssueCustomFieldValueFormComparator();
			Collections.sort(issueCustomFieldValueForms, comp);

			String concatUseValue = "";
			for (int i = 0; i < issueCustomFieldValueForms.size(); i++) {
			IssueCustomFieldValueForm issueCustomFieldValueForm = issueCustomFieldValueForms.get(i);
			userValues.add(issueCustomFieldValueForm.getUseValue());
			if (i > 0) {
			concatUseValue = concatUseValue.concat(comma);
			}
			concatUseValue = concatUseValue.concat(issueCustomFieldValueForm.getUseValue());
			}

			IssueCustomFieldValueCondition issueCustomFieldValueCondition = new IssueCustomFieldValueCondition();
			issueCustomFieldValueCondition.setUseValue(concatUseValue);
			issueCustomFieldValueCondition.setUseValues(userValues);
			issueCustomFieldValueCondition.setIssueTypeId(issueApiform.getIssueTypeId());
			List<Map<String, Object>> results = this.issueMapper.findByCustomFieldValue(issueCustomFieldValueCondition);
			if (results != null && results.size() > 0) {
			for (Map<String, Object> result : results) {
			resultIssueVos.add(this.getIssue(MapUtil.getLong(result, "id")));
			}
			}
			}

			return resultIssueVos;
			}

			// 리스트에서 해당 아이디를 가지고 있는 이슈 검색
			private IssueVo findIssueVo(List<IssueVo> list, Long id) {
			for (IssueVo issueVo : list) {
			if (id.equals(issueVo.getId())) {
			return issueVo;
			}
			}
			return null;
			}


			// 이슈를 수정한다(api용)
			@Override
			@Transactional
			public List<Issue> modifyIssue(IssueApiForm issueApiForm, List<MultipartFile> files) {
			User user = this.convertToUser(issueApiForm.getToken());
			IssueForm issueForm = this.convertToIssueForm(issueApiForm, user);

			return this.modifyIssue(user, issueForm, files);
			List<Issue> issue = this.findIssue(issueApiForm);
			if (issue != null && issue.size() > 0) {
			List<Issue> issues = Lists.newArrayList();
			for (Issue issueVo : issue) {
			issueForm.setId(issueVo.getId());
			issueForm.setTitle(issueVo.getTitle());

			// 자동 종료 상태 설정이 되어 있지 않으면 오류발생
			Issue modifyIssue = this.modifyIssueForApi(user, issueForm, files);
			Issue parentIssue = modifyIssue.getParentIssue();
			IssueType issueType = modifyIssue.getIssueType();

			Set<IssueTypeApiEndStatus> issueTypeApiEndStatuses = issueType.getIssueTypeApiEndStatuses();
			IssueTypeApiEndStatus issueStatus = null;
			if (issueTypeApiEndStatuses != null && issueTypeApiEndStatuses.size() > 0) {
			issueStatus = issueTypeApiEndStatuses.iterator().next();
			} else {
			throw new OwlRuntimeException(this.messageAccessor.getMessage(MsgConstants.API_COMPLETE_ISSUE_STATUS_NOT_EXIST));
			}

			if (parentIssue != null) {

			IssueCondition issueCondition = new IssueCondition(issueVo.getId(), parentIssue.getId());
			List<Map<String, Object>> results = this.issueMapper.findNotCompleteByParentIssueId(issueCondition);
			// 하위 일감이 모두 종료 상태일때 상위 일감도 종료 처리
			if (results == null \|\| results.size() == 0) {
			parentIssue.setIssueStatus(issueStatus.getIssueStatus());
			this.issueRepository.saveAndFlush(parentIssue);
			}
			}

			issues.add(modifyIssue);
			}
			return issues;
			} else {
			throw new OwlRuntimeException(
			this.messageAccessor.getMessage(MsgConstants.API_ISSUE_NOT_EXIST));
			}
			}

			// 이슈를 수정한다.
			@@ -1281,14 +1917,16 @@
			return modifyIssue(user, issueForm, multipartFiles);
			}

			// 이슈를 수정한다.
			@Override
			@Transactional
			public Issue modifyIssue(User user, IssueForm issueForm, List<MultipartFile> multipartFiles) {
			// 수정 데이터가 유효한지 확인
			private CheckIssueData checkIssue(User user, IssueForm issueForm) {

			// 사용하고 있는 업무 공간이 활성 상태인지 확인한다. 사용 공간에서 로그인한 사용자가 비활성인지 확인한다.
			this.workspaceService.checkUseWorkspace(user, user.getLastWorkspaceId());

			Issue issue = this.getIssue(issueForm.getId());
			IssueStatus oldIssueStatus = issue.getIssueStatus();
			// 이슈 수정 권한 체크
			this.verifyIssueModifyPermission(issueForm.getId());
			this.verifyIssueModifyPermission(issue, user);
			// 프로젝트 유효성 체크
			Project project = this.projectService.getProject(issueForm.getProjectId());
			// 이슈 상태 유효성 체크
			@@ -1307,12 +1945,95 @@
			// 담당자 유효성 체크
			//this.verifyIssueAssignee(project, issueForm);
			// 담당부서 유효성 체크
			this.verifyIssueDepartment(project, issueForm);
			//this.verifyIssueDepartment(project, issueForm);

			Issue issue = this.getIssue(issueForm.getId());
			CheckIssueData checkIssueData = new CheckIssueData();
			checkIssueData.setIssue(issue);
			checkIssueData.setProject(project);
			checkIssueData.setOldIssueStatus(oldIssueStatus);
			checkIssueData.setNewIssueStatus(issueStatus);
			checkIssueData.setIssueType(issueType);
			checkIssueData.setPriority(priority);
			checkIssueData.setSeverity(severity);

			return checkIssueData;
			}

			// 이슈 수정(API용)
			private Issue modifyIssueForApi(User user, IssueForm issueForm, List<MultipartFile> multipartFiles) {
			CheckIssueData checkIssueData = this.checkIssue(user, issueForm);

			if (issueForm.getComment() != null && !issueForm.getComment().equals("")) { //댓글 추가
			IssueCommentForm issueCommentForm = new IssueCommentForm();
			issueCommentForm.setDescription(issueForm.getComment());
			issueCommentForm.setIssueId(issueForm.getId());
			this.issueCommentService.addIssueComment(issueCommentForm, user);
			}

			// 이슈 이력 남기기
			this.addIssueHistoryModify(user, issueForm, checkIssueData, multipartFiles);

			// db에 저장
			return this.saveIssue(issueForm, checkIssueData);
			}

			private void addIssueHistoryModify(User user, IssueForm issueForm, CheckIssueData checkIssueData, List<MultipartFile> multipartFiles) {
			// 변경 이력 정보 추출
			StringBuilder detectIssueChange = this.issueHistoryService.detectIssueChange(issueForm, checkIssueData, multipartFiles);

			// 프로젝트가 변경되면 이슈 넘버를 새로 따야 한다.
			this.checkChangeProject(checkIssueData.getProject(), checkIssueData.getIssue());

			// 이슈 유형이 변경되었는지 확인하고 변경되었다면 이슈 상태 속성이 '대기' 인 이슈 상태로 교체한다.
			if (this.checkChangeIssueType(checkIssueData.getIssueType(), checkIssueData.getNewIssueStatus(), checkIssueData.getIssue())) {
			checkIssueData.setNewIssueStatus(this.issueStatusService.findByIssueStatusTypeIsReady(checkIssueData.getIssueType().getWorkflow()));
			// 이슈 상태 변경 이력 남기기 - 이력을 남기기 위해 issueForm 에 issueStatus Id 값을 저장.
			issueForm.setIssueStatusId(checkIssueData.getNewIssueStatus().getId());
			this.issueHistoryService.detectIssueStatus(checkIssueData.getIssue(), issueForm, detectIssueChange, checkIssueData.getOldIssueStatus(), checkIssueData.getNewIssueStatus());
			}

			// db에 저장
			// checkIssueData.setIssue(this.saveIssue(issueForm, checkIssueData));

			// 이슈 이력 등록
			if (!StringUtils.isEmpty(detectIssueChange.toString())) {
			this.issueHistoryService.addIssueHistory(checkIssueData.getIssue(), user, IssueHistoryType.MODIFY, detectIssueChange.toString());
			}
			// 사용자 시스템 기능 사용 정보 수집
			UserVo userVo = ConvertUtil.copyProperties(user, UserVo.class);
			log.info(ElasticSearchUtil.makeUserActiveHistoryMessage(userVo, ElasticSearchConstants.ISSUE_MODIFY));
			}



			private Issue saveIssue(IssueForm issueForm, CheckIssueData checkIssueData) {
			Issue issue = checkIssueData.getIssue();
			ConvertUtil.copyProperties(issueForm, issue, "id");
			issue.setProject(checkIssueData.getProject());
			issue.setIssueStatus(checkIssueData.getNewIssueStatus());
			issue.setIssueType(checkIssueData.getIssueType());
			issue.setPriority(checkIssueData.getPriority());
			issue.setSeverity(checkIssueData.getSeverity());
			issue.setStartDate(issueForm.getStartDate());
			issue.setCompleteDate(issueForm.getCompleteDate());

			return this.issueRepository.saveAndFlush(issue);
			}

			// 이슈를 수정한다.
			@Override
			@Transactional
			public Issue modifyIssue(User user, IssueForm issueForm, List<MultipartFile> multipartFiles) {
			CheckIssueData checkIssueData = this.checkIssue(user, issueForm);

			Issue issue = checkIssueData.getIssue();
			IssueStatus oldIssueStatus = checkIssueData.getOldIssueStatus();
			Project project = checkIssueData.getProject();
			IssueStatus issueStatus = checkIssueData.getNewIssueStatus();
			IssueType issueType = checkIssueData.getIssueType();

			// 변경 이력 정보 추출
			StringBuilder detectIssueChange = this.issueHistoryService.detectIssueChange(issue, issueForm, project, issueStatus, issueType, priority, severity, multipartFiles);
			StringBuilder detectIssueChange = this.issueHistoryService.detectIssueChange(issueForm, checkIssueData, multipartFiles);

			// 프로젝트가 변경되면 이슈 넘버를 새로 따야 한다.
			this.checkChangeProject(project, issue);
			@@ -1322,19 +2043,10 @@
			issueStatus = this.issueStatusService.findByIssueStatusTypeIsReady(issueType.getWorkflow());
			// 이슈 상태 변경 이력 남기기 - 이력을 남기기 위해 issueForm 에 issueStatus Id 값을 저장.
			issueForm.setIssueStatusId(issueStatus.getId());
			this.issueHistoryService.detectIssueStatus(issue, issueForm, detectIssueChange, issueStatus);
			this.issueHistoryService.detectIssueStatus(issue, issueForm, detectIssueChange, oldIssueStatus, issueStatus);
			}

			ConvertUtil.copyProperties(issueForm, issue, "id");
			issue.setProject(project);
			issue.setIssueStatus(issueStatus);
			issue.setIssueType(issueType);
			issue.setPriority(priority);
			issue.setSeverity(severity);
			issue.setStartDate(issueForm.getStartDate());
			issue.setCompleteDate(issueForm.getCompleteDate());

			this.issueRepository.saveAndFlush(issue);
			issue = this.saveIssue(issueForm, checkIssueData);
			//this.issueUserService.modifyIssueUser(issue, project.getWorkspace(), issueForm.getUserIds());
			// 담당부서 지정
			if(issueForm.getDepartmentIds().size()>0){
			@@ -1357,14 +2069,15 @@
			this.issueHistoryService.addIssueHistory(issue, user, IssueHistoryType.MODIFY, detectIssueChange.toString());
			}
			// 사용자 시스템 기능 사용 정보 수집
			log.info(ElasticSearchUtil.makeUserActiveHistoryMessage(this.webAppUtil.getLoginUser(), ElasticSearchConstants.ISSUE_MODIFY));
			UserVo userVo = ConvertUtil.copyProperties(user, UserVo.class);
			log.info(ElasticSearchUtil.makeUserActiveHistoryMessage(userVo, ElasticSearchConstants.ISSUE_MODIFY));

			// 업체 정보 저장
			this.issueCompanyService.modifyIssueCompanyField(issue, issueForm.getIssueCompanyFields());
			this.issueCompanyService.modifyIssueCompanyField(issue, issueForm);
			// ISP 정보 저장
			this.issueIspService.modifyIssueIspField(issue, issueForm.getIssueIspFields());
			this.issueIspService.modifyIssueIspField(issue, issueForm);
			// HOSTING 정보 저장
			this.issueHostingService.modifyIssueHostingField(issue, issueForm.getIssueHostingFields());
			this.issueHostingService.modifyIssueHostingField(issue, issueForm);

			return issue;
			}
			@@ -1479,11 +2192,9 @@
			}

			// 이슈 수정 권한 체크
			private void verifyIssueModifyPermission(Long issueId) {
			Issue issue = this.getIssue(issueId);

			private void verifyIssueModifyPermission(Issue issue, User user) {
			// 이슈 수정 권한을 갖고 있는지 확인
			if (!this.checkHasPermission(ConvertUtil.copyProperties(issue, IssueVo.class), this.getIssueUserVos(issue))) {
			if (!this.checkHasPermission(ConvertUtil.copyProperties(issue, IssueVo.class), this.getIssueUserVos(issue), user, this.getIssueDepartmentVos(issue))) {
			throw new OwlRuntimeException(
			this.messageAccessor.getMessage(MsgConstants.ISSUE_NOT_MODIFY_PERMISSION));
			}
			@@ -1493,48 +2204,86 @@
			private List<UserVo> getIssueUserVos(Issue issue) {
			List<UserVo> userVos = Lists.newArrayList();

			for (IssueUser issueUser : issue.getIssueUsers()) {
			UserVo userVo = ConvertUtil.copyProperties(issueUser.getUser(), UserVo.class, "password");
			userVos.add(userVo);
			Set<IssueUser> issueUsers = issue.getIssueUsers();

			try {
			for (IssueUser issueUser : issueUsers) {
			User user = issueUser.getUser();
			UserVo userVo = ConvertUtil.copyProperties(user, UserVo.class, "password");
			userVos.add(userVo);
			}
			} catch (Exception ex) {

			}

			return userVos;
			}

			// 이슈에서 담당자 정보를 추출한다.
			private List<DepartmentVo> getIssueDepartmentVos(Issue issue) {
			List<DepartmentVo> departmentVos = Lists.newArrayList();

			Set<IssueDepartment> issueDepartments = issue.getIssueDepartments();

			try {
			for (IssueDepartment issueDepartment : issueDepartments) {
			Department department = issueDepartment.getDepartment();
			DepartmentVo departmentVo = ConvertUtil.copyProperties(department, DepartmentVo.class);
			departmentVos.add(departmentVo);
			}
			} catch (Exception ex) {

			}

			return departmentVos;
			}

			// 이슈 수정 권한을 갖고 있는지 확인
			private boolean checkHasPermission(IssueVo issueVo, List<UserVo> issueUserVos) {
			private boolean checkHasPermission(IssueVo issueVo, List<UserVo> issueUserVos, User user, List<DepartmentVo> departmentVos) {
			boolean hasPermission = false;

			// 업무 공간 관리자일 경우 수정 권한을 갖는다.
			hasPermission = this.checkIssueModifyPermission(hasPermission, Issue.WORKSPACE_MANAGER, issueVo, null, null);
			hasPermission = this.checkIssueModifyPermission(hasPermission, Issue.WORKSPACE_MANAGER, issueVo, null, null, user);
			// 프로젝트 관리자일 경우 해당 프로젝트에 등록된 이슈는 수정 권한을 갖는다.
			hasPermission = this.checkIssueModifyPermission(hasPermission, Issue.PROJECT_MANAGER, issueVo, null, null);
			hasPermission = this.checkIssueModifyPermission(hasPermission, Issue.PROJECT_MANAGER, issueVo, null, null, user);
			// 이슈 관리자일 경우 수정 권한을 갖는다.
			hasPermission = this.checkIssueModifyPermission(hasPermission, Issue.ISSUE_MANAGER, issueVo, null, null, user);
			// 이슈 등록자일 경우 수정 권한을 갖는다.
			hasPermission = this.checkIssueModifyPermission(hasPermission, Issue.REGISTER, issueVo, null, null);
			// 이슈 담당자일 경우 수정 권한을 갖는다. => 담당부서로 수정 - 체크
			hasPermission = this.checkIssueModifyPermission(hasPermission, Issue.REGISTER, issueVo, null, null, user);
			// 이슈 담당자일 경우 수정 권한을 갖는다.
			//hasPermission = this.checkIssueModifyPermission(hasPermission, Issue.ASSIGNEE, issueVo, issueUserVos);
			// 이슈 담당부서일 경우 수정 권한을 갖는다.
			hasPermission = this.checkIssueModifyPermission(hasPermission, Issue.DEPARTMENT, issueVo, null, departmentVos, user);
			// 담당자가 없으면 모든 사용자가 수정 권한을 갖는다.

			//hasPermission = this.checkIssueModifyPermission(hasPermission, Issue.ALL_ISSUE_MANAGER, issueVo, null, null, user);
			//hasPermission = this.checkIssueModifyPermission(hasPermission, Issue.ALL_PROJECT_MANAGER, issueVo, null, null, user);

			return hasPermission;
			}

			// 이슈 수정 권한을 확인한다.
			private boolean checkIssueModifyPermission(Boolean hasPermission, String checkType, IssueVo issueVo, List<UserVo> issueUserVos, List<DepartmentVo> issueDepartmentVos) {
			private boolean checkIssueModifyPermission(Boolean hasPermission, String checkType, IssueVo issueVo, List<UserVo> issueUserVos, List<DepartmentVo> departmentVos, User user) {
			if (!hasPermission) {
			switch (checkType) {
			case Issue.WORKSPACE_MANAGER: // 업무 공간 관리자
			// 업무 공간 관리자일 경우 수정 권한을 갖는다.
			hasPermission = this.userWorkspaceService.checkWorkspaceManager();
			hasPermission = this.userWorkspaceService.checkWorkspaceManager(user);
			break;

			case Issue.PROJECT_MANAGER: // 프로젝트 관리자
			Issue issue = this.getIssue(issueVo.getId());
			// 프로젝트 관리자일 경우 해당 프로젝트에 등록된 이슈는 수정 권한을 갖는다.
			hasPermission = this.projectRoleUserService.checkProjectManager(issue.getProject());
			hasPermission = this.projectRoleUserService.checkProjectManager(issue.getProject(), user);
			break;

			case Issue.ISSUE_MANAGER: // 이슈 관리자
			UserLevel userLevel = this.userLevelService.getUserLevel(user.getUserLevel().getId());
			hasPermission = MngPermission.checkMngPermission(userLevel.getPermission(), MngPermission.USER_PERMISSION_MNG_ISSUE);
			break;

			case Issue.REGISTER: // 이슈 등록자
			hasPermission = issueVo.getRegisterId().equals(this.webAppUtil.getLoginId());
			hasPermission = issueVo.getRegisterId().equals(user.getId());
			break;

			case Issue.ASSIGNEE:
			@@ -1545,7 +2294,7 @@
			}
			// 이슈 담당자 여부 확인
			for (UserVo issueUserVo : issueUserVos) {
			if (issueUserVo.getId().equals(this.webAppUtil.getLoginId())) {
			if (issueUserVo.getId().equals(user.getId())) {
			hasPermission = true;
			break;
			}
			@@ -1554,17 +2303,22 @@

			case Issue.DEPARTMENT:
			// 담당부서가 없으면 모든 사용자가 수정 권한을 갖는다.
			if (issueDepartmentVos.size() < 1) {
			/*if (userDepartmentVos.size() < 1) {
			hasPermission = true;
			break;
			}
			// 이슈 담당부서 여부 확인
			/*for (DepartmentVo issueDepartmentVo : issueDepartmentVos) {
			if (issueDepartmentVo.getId().equals()) {
			hasPermission = true;
			break;
			}
			}*/
			// 이슈 담당부서 여부 확인
			for (DepartmentVo departmentVo : departmentVos) {
			List<UserDepartment> userDepartments = this.userDepartmentService.findByDepartmentId(departmentVo.getId());
			if(userDepartments != null && userDepartments.size() > 0) {
			for (UserDepartment userDepartment : userDepartments) {
			if (userDepartment.getUserId().equals(user.getId())){
			hasPermission = true;
			break;
			}
			}
			}
			}
			break;
			}
			}
			@@ -1575,20 +2329,35 @@
			// 이슈 상태 변경
			@Override
			@Transactional
			public void modifyIssueStatus(IssueForm issueForm) {
			public void modifyIssueStatus(IssueForm issueForm, User user) {
			// 사용하고 있는 업무 공간이 활성 상태인지 확인한다. 사용 공간에서 로그인한 사용자가 비활성인지 확인한다.
			this.workspaceService.checkUseWorkspace();
			// 변경 이력 정보 추출
			StringBuilder detectIssueChange = new StringBuilder();
			// 이슈 수정 권한 체크
			this.verifyIssueModifyPermission(issueForm.getId());
			Issue issue = this.getIssue(issueForm.getId());
			IssueStatus oldIssueStatus = issue.getIssueStatus();

			this.verifyIssueModifyPermission(issue, user);

			IssueStatus issueStatus = this.issueStatusService.getIssueStatus(issueForm.getIssueStatusId());

			if (issueStatus.getIssueStatusType().toString().equals("CLOSE")) {
			List<String> downIssuesStatus = issueForm.getDownIssuesStatus();
			if (downIssuesStatus != null && downIssuesStatus.size() > 0) {
			for (String downIssueStatus : downIssuesStatus) {
			if (!downIssueStatus.equals("CLOSE")) {
			throw new OwlRuntimeException(
			this.messageAccessor.getMessage(MsgConstants.ISSUE_NOT_MODIFY_STATUS));
			}
			}
			}
			}

			// 이슈 상태를 변경할 때 선택한 이슈 상태로 변경할 수 있는지 확인한다.
			this.issueStatusService.checkNextIssueStatus(issue, issueStatus);
			// 변경 이력 정보 추출
			this.issueHistoryService.detectIssueStatus(issue, issueForm, detectIssueChange, issueStatus);
			this.issueHistoryService.detectIssueStatus(issue, issueForm, detectIssueChange, oldIssueStatus, issueStatus);

			issue.setIssueStatus(issueStatus);
			this.issueRepository.saveAndFlush(issue);
			@@ -1622,13 +2391,15 @@
			@Override
			@Transactional
			public void modifyIssueUser(IssueForm issueForm) {
			User user = this.webAppUtil.getLoginUserObject();

			// 사용하고 있는 업무 공간이 활성 상태인지 확인한다. 사용 공간에서 로그인한 사용자가 비활성인지 확인한다.
			this.workspaceService.checkUseWorkspace();
			// 변경 이력 정보 추출
			StringBuilder detectIssueChange = new StringBuilder();
			// 이슈 수정 권한 체크
			this.verifyIssueModifyPermission(issueForm.getId());
			Issue issue = this.getIssue(issueForm.getId());
			this.verifyIssueModifyPermission(issue, user);
			issue.setProject(this.projectService.getProject(issueForm.getProjectId()));

			// 변경 이력 정보 추출
			@@ -1657,13 +2428,14 @@
			@Override
			@Transactional
			public void modifyIssueDepartment(IssueForm issueForm) {
			User user = this.webAppUtil.getLoginUserObject();
			// 사용하고 있는 업무 공간이 활성 상태인지 확인한다. 사용 공간에서 로그인한 사용자가 비활성인지 확인한다.
			this.workspaceService.checkUseWorkspace();
			// 변경 이력 정보 추출
			StringBuilder detectIssueChange = new StringBuilder();
			// 이슈 수정 권한 체크
			this.verifyIssueModifyPermission(issueForm.getId());
			Issue issue = this.getIssue(issueForm.getId());
			this.verifyIssueModifyPermission(issue, user);
			issue.setProject(this.projectService.getProject(issueForm.getProjectId()));

			// 변경 이력 정보 추출
			@@ -1695,6 +2467,7 @@
			@Transactional
			public void removeIssues(IssueForm issueForm) {
			// 사용하고 있는 업무 공간이 활성 상태인지 확인한다. 사용 공간에서 로그인한 사용자가 비활성인지 확인한다.
			User user = this.webAppUtil.getLoginUserObject();
			this.workspaceService.checkUseWorkspace();

			if (issueForm.getRemoveIds().size() < 1) {
			@@ -1705,22 +2478,97 @@
			List<Issue> removeIssues = Lists.newArrayList();

			for (Long issueId : issueForm.getRemoveIds()) {
			Issue issue = this.issueRemoves(issueId);
			//하위이슈 체크
			List<Issue> downIssues = this.issueRepository.findByParentIssueId(issueId);
			if(downIssues != null && downIssues.size() > 0){
			for(Issue downIssue : downIssues){
			if(downIssue.getParentIssue() != null){
			downIssue.setParentIssue(null);
			}
			}
			}

			Issue issue = this.issueRemoves(issueId, user);
			removeIssues.add(issue);
			}

			if (removeIssues.size() > 0) {
			//this.issueRepository.deleteAll(removeIssues);
			}
			/*if (removeIssues.size() > 0) {
			this.issueRepository.deleteAll(removeIssues);
			}*/

			// 사용자 시스템 기능 사용 정보 수집
			log.info(ElasticSearchUtil.makeUserActiveHistoryMessage(this.webAppUtil.getLoginUser(), ElasticSearchConstants.ISSUE_REMOVE));
			}

			private Issue issueRemoves(Long issueId) {
			Issue issue = this.getIssue(issueId);
			// 이슈를 삭제한다.
			@Override
			@Transactional
			public void removeAllIssues(IssueForm issueForm) {
			// 사용하고 있는 업무 공간이 활성 상태인지 확인한다. 사용 공간에서 로그인한 사용자가 비활성인지 확인한다.
			User user = this.webAppUtil.getLoginUserObject();
			this.workspaceService.checkUseWorkspace();

			if (issueForm.getRemoveIds().size() < 1) {
			throw new OwlRuntimeException(
			this.messageAccessor.getMessage(MsgConstants.ISSUE_REMOVE_NOT_SELECT));
			}

			List<Issue> removeIssues = Lists.newArrayList();

			for (Long issueId : issueForm.getRemoveIds()) {
			//하위이슈 체크
			List<Issue> downIssues = this.issueRepository.findByParentIssueId(issueId);
			if(downIssues != null && downIssues.size() > 0){
			for(Issue downIssue : downIssues){
			Long downIssueId = downIssue.getId();
			downIssue = this.issueRemoves(downIssueId, user);
			removeIssues.add(downIssue);
			}
			}
			Issue issue = this.issueRemoves(issueId, user);
			removeIssues.add(issue);
			}
			// 사용자 시스템 기능 사용 정보 수집
			log.info(ElasticSearchUtil.makeUserActiveHistoryMessage(this.webAppUtil.getLoginUser(), ElasticSearchConstants.ISSUE_REMOVE));
			}

			// 하위이슈를 삭제한다.
			@Override
			@Transactional
			public void removeDownIssues(IssueForm issueForm) {
			// 사용하고 있는 업무 공간이 활성 상태인지 확인한다. 사용 공간에서 로그인한 사용자가 비활성인지 확인한다.
			User user = this.webAppUtil.getLoginUserObject();
			this.workspaceService.checkUseWorkspace();

			if (issueForm.getRemoveIds().size() < 1) {
			throw new OwlRuntimeException(
			this.messageAccessor.getMessage(MsgConstants.ISSUE_REMOVE_NOT_SELECT));
			}

			List<Issue> removeIssues = Lists.newArrayList();
			Long downIssueId = 0L;
			for (Long issueId : issueForm.getRemoveIds()) {
			//삭제 할 이슈의 하위이슈 체크
			List<Issue> downIssues = this.issueRepository.findByParentIssueId(issueId);
			if(downIssues != null && downIssues.size() > 0){
			for(Issue downIssue : downIssues){
			downIssueId = downIssue.getId();
			}
			}
			Issue issue = this.issueRemoves(downIssueId, user);
			removeIssues.add(issue);
			}
			// 사용자 시스템 기능 사용 정보 수집
			log.info(ElasticSearchUtil.makeUserActiveHistoryMessage(this.webAppUtil.getLoginUser(), ElasticSearchConstants.ISSUE_REMOVE));
			}

			private Issue issueRemoves(Long issueId, User user) {
			Issue issue = null;
			if(issueId != null){
			issue = this.getIssue(issueId);
			}
			// 이슈 수정 권한을 갖고 있는지 확인
			this.verifyIssueModifyPermission(issueId);
			this.verifyIssueModifyPermission(issue, user);

			// 이슈 첨부 파일을 삭제한다.
			if (issue.getAttachedFiles().size() > 0) {
			@@ -1731,6 +2579,17 @@
			}
			// 첨부파일 삭제
			this.attachedFileService.removeAttachedFiles(attachedFileIds);
			}

			// 지울 이슈가 연관이슈인지 체크 후 연관이슈 테이블에서도 삭제한다.
			List<IssueRelation> issueRelationList = this.issueRelationRepository.findByRelationIssueId(issueId);
			if (issueRelationList != null && issueRelationList.size() > 0) {
			for(IssueRelation issueRelation : issueRelationList){
			StringBuilder sb = new StringBuilder();
			issueHistoryService.detectRelationIssue(IssueHistoryType.DELETE, issueRelation, sb);
			issueHistoryService.addIssueHistory(issueRelation.getIssue(), IssueHistoryType.MODIFY, sb.toString());
			this.issueRelationRepository.delete(issueRelation);
			}
			}

			// 이슈 생성, 삭제시 예약 이메일에 등록해놓는다.
			@@ -1884,7 +2743,8 @@
			issueCondition.setIssueIds(Lists.newArrayList());

			// Map 에 있는 데이터를 IssueVo 데이터로 변환한다.
			this.setMapToIssueVo(results, issueVos, issueCondition);
			User user = this.webAppUtil.getLoginUserObject();
			this.setMapToIssueVo(results, issueVos, issueCondition, user);

			// IssueVos 데이터를 엑셀에서 표시할 수 있는 데이터로 변경한다.
			List<Map<String, String>> convertExcelViewToIssueMaps = this.convertExcelViewToIssueVos(issueVos);
			@@ -1945,6 +2805,26 @@
			CompanyField companyField = issueCompany.getCompanyField();
			if (companyField != null) {
			issueCompanyVo.setCompanyId(issueCompany.getCompanyField().getId());
			if (issueCompany.getCompanyTypeId() != null) {
			CompanyFieldCategory companyType = this.companyFieldCategoryService.find(issueCompany.getCompanyTypeId());
			issueCompanyVo.setCompanyTypeName(companyType.getUseValue());
			}
			if (issueCompany.getParentSectorId() != null) {
			CompanyFieldCategory parentSector = this.companyFieldCategoryService.find(issueCompany.getParentSectorId());
			issueCompanyVo.setParentSectorName(parentSector.getUseValue());
			}
			if (issueCompany.getChildSectorId() != null) {
			CompanyFieldCategory childSector = this.companyFieldCategoryService.find(issueCompany.getChildSectorId());
			issueCompanyVo.setChildSectorName(childSector.getUseValue());
			}
			if (issueCompany.getRegionId() != null) {
			CompanyFieldCategory region = this.companyFieldCategoryService.find(issueCompany.getRegionId());
			issueCompanyVo.setRegionName(region.getUseValue());
			}
			if (issueCompany.getStatusId() != null) {
			CompanyFieldCategory status = this.companyFieldCategoryService.find(issueCompany.getStatusId());
			issueCompanyVo.setStatusName(status.getUseValue());
			}
			}
			issueCompanyVos.add(issueCompanyVo);
			}
			@@ -2052,10 +2932,12 @@
			// 사용하고 있는 업무 공간이 활성 상태인지 확인한다. 사용 공간에서 로그인한 사용자가 비활성인지 확인한다.
			this.workspaceService.checkUseWorkspace();

			User user = this.webAppUtil.getLoginUserObject();

			for (Long issueId : issueForm.getIds()) {
			issueForm.setId(issueId);
			// 이슈 상태 변경
			this.modifyIssueStatus(issueForm);
			this.modifyIssueStatus(issueForm, user);
			}

			// 담당 부서 수정
			@@ -2085,11 +2967,8 @@
			excelInfo.setFileName(this.messageAccessor.message("common.registerExcelIssue")); // 엑셀로 이슈 등록하기
			excelInfo.addAttrInfos(new ExportExcelAttrVo("id", this.messageAccessor.message("common.title"), 20, ExportExcelAttrVo.ALIGN_CENTER)); // 제목
			excelInfo.addAttrInfos(new ExportExcelAttrVo("id", this.messageAccessor.message("common.content"), 40, ExportExcelAttrVo.ALIGN_CENTER)); // 내용
			excelInfo.addAttrInfos(new ExportExcelAttrVo("id", this.messageAccessor.message("common.projectKey"), 10, ExportExcelAttrVo.ALIGN_LEFT)); // 프로젝트 키
			excelInfo.addAttrInfos(new ExportExcelAttrVo("id", this.messageAccessor.message("common.issueType"), 10, ExportExcelAttrVo.ALIGN_CENTER)); // 이슈 타입
			excelInfo.addAttrInfos(new ExportExcelAttrVo("id", this.messageAccessor.message("common.priority"), 5, ExportExcelAttrVo.ALIGN_CENTER)); // 우선순위
			excelInfo.addAttrInfos(new ExportExcelAttrVo("id", this.messageAccessor.message("common.importance"), 5, ExportExcelAttrVo.ALIGN_CENTER)); // 중요도
			excelInfo.addAttrInfos(new ExportExcelAttrVo("id", this.messageAccessor.message("common.department"), 10, 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)); // 종료일
			// 프로젝트에 연결된 사용자 정의 필드 정보를 추출하여 엑셀 download 템플릿을 만든다.
			@@ -2113,7 +2992,7 @@
			// 엑셀 import 로 이슈를 등록한다.
			@Override
			@Transactional
			public void importExcel(MultipartFile multipartFile) throws Exception {
			public void importExcel(IssueForm issueForm, MultipartFile multipartFile) throws Exception {
			/*StopWatch serviceStart = new StopWatch();
			serviceStart.start();*/

			@@ -2124,19 +3003,16 @@
			// 업로드 파일 확장자 체크
			this.verifyMultipartFileExtension(multipartFile);

			Map<String, Project> projectMaps = new HashMap<>(); // 프로젝트 모음
			Map<String, IssueType> issueTypeMaps = new HashMap<>(); // 이슈 타입 모음
			Map<String, Priority> priorityMaps = new HashMap<>(); // 우선 순위 모음
			Map<String, Severity> severityMaps = new HashMap<>(); // 중요도 모음
			Map<String, Object> userMaps = new HashMap<>(); // 사용자 모음
			Map<String, Object> departmentMaps = new HashMap<>(); // 부서 모음
			Map<String, DepartmentVo> departmentMaps = new HashMap<>(); // 부서 모음
			Map<String, CustomField> customFieldMaps = new HashMap<>();
			Map<String, IssueStatus> issueStatusReadyMaps = new HashMap<>(); // 상태 속성 '대기'인 이슈 상태
			Map<Long, Long> issueNumberMaps = new HashMap<>(); // 이슈 번호 모음
			Map<String, Long> issueTypeCustomFieldMaps = new HashMap<>(); // 이슈 타입 + 사용자 정의 필드 연결 정보

			Workspace workspace = this.workspaceService.getWorkspace(this.userService.getUser(this.webAppUtil.getLoginId()).getLastWorkspaceId()); // 이슈를 넣으려는 업무 공간
			// 이슈의 주요 속성을 map 에 저장하여 엑셀 import 에서 지정한 대상(이슈 속성)을 빠르게 찾을 수 있게 한다.
			this.IssueAttributeMapToList(projectMaps, issueTypeMaps, priorityMaps, severityMaps, userMaps, departmentMaps, customFieldMaps, issueNumberMaps, issueTypeCustomFieldMaps, issueStatusReadyMaps);
			this.IssueAttributeMapToList(issueForm, priorityMaps, severityMaps, departmentMaps, customFieldMaps, issueTypeCustomFieldMaps);
			// 0.237 - 0.230

			List<IssueForm> issueForms = Lists.newArrayList();
			@@ -2179,7 +3055,14 @@
			// 1번 헤더부터 데이터 영역
			if (rowIndex > 1) {
			// 이슈로 등록하기 위해 IssueForm 에 데이터를 셋팅한다.
			issueForms.add(this.setIssueFormToExcelField(row, (rowIndex + 1), issueStatusReadyMaps, projectMaps, issueTypeMaps, priorityMaps, severityMaps, userMaps, customFieldMaps, issueNumberMaps, headers));
			IssueForm newIssueForm = this.setIssueFormToExcelField(row, (rowIndex + 1), priorityMaps, severityMaps, departmentMaps, customFieldMaps, headers);
			ConvertUtil.copyProperties(issueForm, newIssueForm);



			issueForms.add(newIssueForm);


			}
			}

			@@ -2190,7 +3073,50 @@


			// 이슈 등록
			this.issueMapper.insertBatch(issueForms);
			// this.issueMapper.insertBatch(issueForms);

			for (IssueForm saveIssueForm : issueForms) {
			Issue issue = new Issue();
			ConvertUtil.copyProperties(saveIssueForm, issue);

			IssueType issueType = this.issueTypeService.getIssueType(saveIssueForm.getIssueTypeId());
			Workflow workflow = issueType.getWorkflow();

			Project project = this.projectService.getProject(saveIssueForm.getProjectId());
			Long issueNumber = this.issueNumberGeneratorService.generateIssueNumber(project);

			IssueStatus issueStatus = this.issueStatusService.findByIssueStatusTypeIsReady(workflow);

			issue.setPriority(this.priorityService.getPriority(saveIssueForm.getPriorityId()));
			issue.setSeverity(this.severityService.getSeverity(saveIssueForm.getSeverityId()));
			issue.setIssueStatus(issueStatus);
			issue.setIssueType(issueType);
			issue.setProject(project);
			issue.setIssueNumber(issueNumber);
			if (saveIssueForm.getParentIssueId() != null && saveIssueForm.getParentIssueId() > -1) {
			issue.setParentIssue(this.getIssue(saveIssueForm.getParentIssueId()));
			}

			issue = this.issueRepository.saveAndFlush(issue);

			saveIssueForm.setId(issue.getId());

			IssueDepartment issueDepartment = new IssueDepartment();
			issueDepartment.setIssue(issue);
			issueDepartment.setWorkspace(workspace);

			List<Long> departmentsIds = this.workflowDepartmentService.findFirstDepartmentIds(workflow);
			if (departmentsIds != null && departmentsIds.size() > 0) {
			for (Long departmentId : departmentsIds) {
			issueDepartment.setDepartment(this.departmentService.getDepartment(departmentId));
			}
			issue.addIssueDepartment(issueDepartment);
			}

			saveIssueForm.setIssueStatusId(issueStatus.getId());
			}


			// 0.416 - 0.439

			// 1.373 ~ 1.394
			@@ -2209,8 +3135,6 @@
			this.bulkInsertIssueCustomFieldValue(issueForms, issueTypeCustomFieldMaps);
			// 3.628 - 3.445

			// 업체,ISP,호스팅 추가

			/*serviceStart.stop();
			log.debug("2차 저장 시간 : " + serviceStart.getTime());*/

			@@ -2220,7 +3144,8 @@
			// reverse index 업데이트
			this.issueMapper.updateBatch(issueForms);
			// 증가된 이슈 번호를 업데이트 한다.
			this.issueNumberGeneratorService.updateIssueNumber(issueNumberMaps);
			// issueNumberMaps.put(issueForm.getProjectId(), issueForm.getProjectId());
			// this.issueNumberGeneratorService.updateIssueNumber(issueNumberMaps);
			}
			}

			@@ -2321,6 +3246,29 @@
			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 (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.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 (issueCustomFieldValueMaps.size() > 0) {
			@@ -2329,50 +3277,15 @@
			}

			// 이슈의 주요 속성을 map 에 저장하여 엑셀 import 에서 지정한 대상(이슈 속성)을 빠르게 찾을 수 있게 한다.
			private void IssueAttributeMapToList(Map<String, Project> projectMaps, Map<String, IssueType> issueTypeMaps, Map<String, Priority> priorityMaps, Map<String, Severity> severityMaps,
			Map<String, Object> userMaps, Map<String, Object> departmentMaps, Map<String, CustomField> customFieldMaps, Map<Long, Long> issueNumberMaps, Map<String, Long> issueTypeCustomFieldMaps, Map<String, IssueStatus> issueStatusReadyMaps) {
			// 프로젝트 키로 바로 찾을 수 있게 준비
			List<Project> projects = this.projectService.findByWorkspaceId();
			List<Long> projectIds = Lists.newArrayList();
			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) {

			for (Project project : projects) {
			projectIds.add(project.getId());
			// 해당 프로젝트에서 생성되는 다음 이슈 번호를 생성해온다.
			issueNumberMaps.put(project.getId(), this.issueNumberGeneratorService.generateIssueNumber(project));
			projectMaps.put(project.getProjectKey(), project);
			Project project = this.projectService.getProject(issueForm.getProjectId());

			for (IssueTypeCustomField issueTypeCustomField : project.getIssueTypeCustomFields()) {
			// 빠르게 찾기 위해 이슈 타입 아이디 + 사용자 정의 필드 아이디를 키로 한다.
			String makeKey = issueTypeCustomField.getIssueType().getId().toString() + issueTypeCustomField.getCustomField().getId().toString();
			issueTypeCustomFieldMaps.put(makeKey, issueTypeCustomField.getId());
			}

			// 프로젝트에 참여하는 사용자 정보
			List<Map<String, Object>> users = this.userService.findProjectMember(project);
			Map<String, Object> userMap = new HashMap<>();
			// 사용자 정보를 Map 에 저장
			for (Map<String, Object> user : users) {
			userMap.put(CommonUtil.decryptAES128(MapUtil.getString(user, "account")), MapUtil.getLong(user, "userId"));
			}

			userMaps.put(project.getProjectKey(), userMap);

			// 프로젝트에 참여하는 부서 정보
			List<Map<String, Object>> departments = this.departmentService.findProjectDepartment(project);
			List<Long> departmentList = Lists.newArrayList();
			// 부서 정보를 저장
			for (Map<String, Object> department : departments) {
			departmentList.add(MapUtil.getLong(department, "departmentId"));
			}
			}

			// 이슈 유형을 바로 찾을 수 있게 준비
			List<IssueType> issueTypes = this.issueTypeService.findByWorkspaceId();
			for (IssueType issueType : issueTypes) {
			issueTypeMaps.put(issueType.getName(), issueType);

			IssueStatus issueStatus = this.issueStatusService.findByIssueStatusTypeIsReady(issueType.getWorkflow());
			issueStatusReadyMaps.put(issueType.getId().toString(), issueStatus);
			for (IssueTypeCustomField issueTypeCustomField : project.getIssueTypeCustomFields()) {
			// 빠르게 찾기 위해 이슈 타입 아이디 + 사용자 정의 필드 아이디를 키로 한다.
			String makeKey = issueTypeCustomField.getIssueType().getId().toString() + issueTypeCustomField.getCustomField().getId().toString();
			issueTypeCustomFieldMaps.put(makeKey, issueTypeCustomField.getId());
			}

			// 우선순위를 바로 찾을 수 있게 준비
			@@ -2395,8 +3308,9 @@
			}

			// 엑셀 필드에 있는 정보를 이슈 form 으로 옮긴다.
			private IssueForm setIssueFormToExcelField(Row row, int rowIndex, Map<String, IssueStatus> issueStatusReadyMaps, Map<String, Project> projectMaps, Map<String, IssueType> issueTypeMaps, Map<String,
			Priority> priorityMaps, Map<String, Severity> severityMaps, Map<String, Object> userMaps, Map<String, CustomField> customFieldMaps, Map<Long, Long> issueNumberMaps, List<String> headers) {
			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) {
			IssueForm issueForm = new IssueForm();
			issueForm.setRegisterId(this.webAppUtil.getLoginId());
			Project project = null;
			@@ -2420,40 +3334,33 @@

			break;

			case 2: // 프로젝트 키와 이슈 번호
			project = this.setIssueFormProjectKeyAndIssueNumber(cell, issueForm, projectMaps, issueNumberMaps, rowIndex);
			break;

			case 3:
			// 이슈 타입을 IssueForm 에 저장한다.
			this.setIssueFormIssueType(cell, issueTypeMaps, issueForm, rowIndex);
			// 이슈 타입에 연결된 워크플로우의 상태 속성 '대기' 인 상태를 issueForm 에 저장한다.
			this.setIssueFormIssueStatus(issueStatusReadyMaps, issueForm, rowIndex);
			break;

			case 4:
			case 2:
			// 우선순위를 IssueForm 에 저장한다.
			this.setIssueFormPriority(cell, priorityMaps, issueForm, rowIndex);
			break;

			case 5:
			case 3:
			// 중요도를 IssueForm 에 저장한다.
			this.setIssueFormSeverity(cell, severityMaps, issueForm, rowIndex);
			break;
			case 6:
			// 담당부서를 IssueForm 에 저장한다.
			/*case 6:
			// 담당자를 IssueForm 에 저장한다.
			this.setIssueFormAssignee(cell, userMaps, issueForm, project);
			break;
			case 7:
			break;*/
			case 4:
			// 시작일을 IssueForm 에 저장한다.
			this.setIssueFormPeriod(cell, issueForm, true, rowIndex);
			if (cell != null && cell.getCellType() != Cell.CELL_TYPE_BLANK) {
			this.setIssueFormPeriod(cell, issueForm, true, rowIndex);
			}
			break;
			case 8:
			case 5:
			// 종료일을 IssueForm 에 저장한다.
			this.setIssueFormPeriod(cell, issueForm, false, rowIndex);
			if (cell != null && cell.getCellType() != Cell.CELL_TYPE_BLANK) {
			this.setIssueFormPeriod(cell, issueForm, false, rowIndex);
			}
			break;
			default:
			// 8번 이상부터는 사용자 정의 필드. 사용자 정의 필드 정보를 IssueForm 에 저장한다.
			// 9번 부터는 사용자 정의 필드. 사용자 정의 필드 정보를 IssueForm 에 저장한다.
			this.setIssueFormCustomFieldValue(cell, customFieldMaps, issueForm, headers.get(cellIndex), rowIndex);
			}
			}
			@@ -2473,17 +3380,6 @@
			// 제목 유효성 체크
			this.verifyTitle(title);
			issueForm.setTitle(title);
			}

			// 프로젝트 키, 이슈 고유 번호, 담당자를 IssueForm 에 저장한다.
			private Project setIssueFormProjectKeyAndIssueNumber(Cell cell, IssueForm issueForm, Map<String, Project> projectMaps, Map<Long, Long> issueNumberMaps, int rowIndex) {
			// 프로젝트 아이디를 IssueForm 에 저장한다.
			Project project = this.setIssueFormProject(cell, projectMaps, issueForm, rowIndex);

			// 이슈 고유 번호를 IssueForm 에 저장한다.
			this.setIssueFormIssueNumber(issueForm, issueNumberMaps, project, rowIndex);

			return project;
			}

			// 프로젝트 아이디를 IssueForm 에 저장한다.
			@@ -2519,34 +3415,6 @@
			issueNumberMaps.put(project.getId(), ++issueNumber); // 이슈 번호를 1씩 증가 시킨다.
			}

			// 이슈 타입을 IssueForm 에 저장한다.
			private void setIssueFormIssueType(Cell cell, Map<String, IssueType> issueTypeMaps, IssueForm issueForm, int rowIndex) {
			if (cell == null) {
			throw new OwlRuntimeException(
			this.messageAccessor.getMessage(MsgConstants.EXCEL_IMPORT_ISSUE_TYPE_IS_NULL, rowIndex));
			}

			IssueType issueType = issueTypeMaps.get(CommonUtil.convertExcelStringToCell(cell));

			if (issueType == null) {
			throw new OwlRuntimeException(
			this.messageAccessor.getMessage(MsgConstants.EXCEL_IMPORT_ISSUE_TYPE_NOT_EXIST, rowIndex));
			}

			issueForm.setIssueTypeId(issueType.getId());
			}

			// 이슈 타입에 연결된 워크플로우의 상태 속성 '대기' 인 상태를 issueForm 에 저장한다.
			private void setIssueFormIssueStatus(Map<String, IssueStatus> issueStatusReadyMaps, IssueForm issueForm, int rowIndex) {
			IssueStatus issueStatus = issueStatusReadyMaps.get(issueForm.getIssueTypeId().toString());

			if (issueStatus == null) {
			throw new OwlRuntimeException(
			this.messageAccessor.getMessage(MsgConstants.EXCEL_IMPORT_ISSUE_STATUS_READY_NOT_EXIST, rowIndex));
			}

			issueForm.setIssueStatusId(issueStatus.getId());
			}

			// 우선순위를 IssueForm 에 저장한다.
			private void setIssueFormPriority(Cell cell, Map<String, Priority> priorityMaps, IssueForm issueForm, int rowIndex) {
			@@ -2582,27 +3450,30 @@
			issueForm.setSeverityId(severity.getId());
			}

			// 담당부서를 IssueForm 에 저장한다.
			private void setIssueFormAssignee(Cell cell, Map<String, Object> userMaps, IssueForm issueForm, Project project) {
			if (cell != null) {
			String[] splitAssignee = CommonUtil.convertExcelStringToCell(cell).split("#");
			Map<String, Object> userMap = (Map<String, Object>) MapUtil.getObject(userMaps, project.getProjectKey());

			List<Long> departmentIds = Lists.newArrayList();
			List<Long> userIds = Lists.newArrayList();

			for (String account : splitAssignee) {
			if (MapUtil.getLong(userMap, account) != null) {
			departmentIds.add(MapUtil.getLong(userMap, account));
			userIds.add(MapUtil.getLong(userMap, account));
			}
			}

			issueForm.setDepartmentIds(departmentIds);
			issueForm.setUserIds(userIds);
			}
			}

			// 시작일, 종료일을 IssueForm 에 저장한다.
			private void setIssueFormPeriod(Cell cell, IssueForm issueForm, Boolean checkStartDate, int rowIndex) {
			if (cell != null && !cell.toString().equals("")) {

			// 값이 공백이면 중지
			String cellValue = CommonUtil.convertExcelStringToCell(cell);
			if (StringUtils.isEmpty(cellValue) \|\| !cell.toString().equals("null")) {
			return;
			}

			Date startDate;

			@@ -2629,7 +3500,7 @@
			}
			}

			// 사용자 정의 필드 정보를 IssueForm 에 저장한다.
			// 사용자 정의 필드 정보를 IssueForm 에 저장한다.-
			private void setIssueFormCustomFieldValue(Cell cell, Map<String, CustomField> customFieldMaps, IssueForm issueForm, String customFieldName, int rowIndex) {
			if (cell != null) {
			String cellValue = CommonUtil.convertExcelStringToCell(cell);
			@@ -2765,45 +3636,67 @@
			// 이슈를 템플릿에 따라 파트너 담당자에게 메일로 발송한다.
			@Override
			@Transactional(readOnly = true)
			public void sendIssueEmailPartners(IssueForm issueForm) {
			if (issueForm.getSendEmails().size() < 1) {
			public void sendIssueEmailPartners(EmailTemplateForm emailTemplateForm) {
			if (emailTemplateForm.getSendEmails().size() < 1) {
			throw new OwlRuntimeException(
			this.messageAccessor.getMessage(MsgConstants.ISSUE_NOT_SEND_USER));
			}else if (issueForm.getTemplate() == null){
			}else if (emailTemplateForm.getTemplate() == null){
			throw new OwlRuntimeException(
			this.messageAccessor.getMessage(MsgConstants.ISSUE_NOT_SELECT_TEMPLATE));
			} else if (emailTemplateForm.getIssueId() == null) {
			throw new OwlRuntimeException(
			this.messageAccessor.getMessage(MsgConstants.ISSUE_NOT_EXIST));
			}

			Issue issue = this.getIssue(issueForm.getId());
			Issue issue = this.getIssue(emailTemplateForm.getIssueId());

			Map<String, Object> issueMap = new HashMap<>();
			// 이슈 정보를 이메일 전송에 사용하기 위해 Map 형태로 변환한다.
			this.makeIssueMapToIssue(issue, issueMap);
			// 발신자 표시
			User user = this.webAppUtil.getLoginUserObject();
			UserVo toUser = this.webAppUtil.getLoginUser();
			issueMap.put("toUser", toUser.getName() + "(" + CommonUtil.decryptAES128(toUser.getAccount()) + ")");

			// 이슈 링크
			String projectKey = issue.getProject().getProjectKey();
			Long IssueNumber = issue.getIssueNumber();
			String link = this.configuration.getEmailSendUrl() + "/#/issues/issueList?projectKey=" + projectKey + "&issueNumber=" + IssueNumber.toString();

			issueMap.put("issueLink", link);
			issueMap.put("projectLink", link);

			// 사용자 시스템 기능 사용 정보 수집
			log.info(ElasticSearchUtil.makeUserActiveHistoryMessage(this.webAppUtil.getLoginUser(), ElasticSearchConstants.ISSUE_ANOTHER_USER_SEND_EMAIL));
			StringBuilder sb = new StringBuilder();

			if(issueForm.getTemplate().equals(EmailType.ISSUE_SEND_1.toString())){
			this.systemEmailService.directEmail(ConvertUtil.ToArray(issueForm.getSendEmails()), EmailType.ISSUE_SEND_1, issueMap, null);
			}else if(issueForm.getTemplate().equals(EmailType.ISSUE_SEND_2.toString())){
			this.systemEmailService.directEmail(ConvertUtil.ToArray(issueForm.getSendEmails()), EmailType.ISSUE_SEND_2, issueMap, null);
			}else if(issueForm.getTemplate().equals(EmailType.ISSUE_SEND_3.toString())){
			this.systemEmailService.directEmail(ConvertUtil.ToArray(issueForm.getSendEmails()), EmailType.ISSUE_SEND_3, issueMap, null);
			Locale locale = CommonUtil.getUserLanguage(user.getLanguage());
			String[] sendMails = ConvertUtil.ToArray(emailTemplateForm.getSendEmails());
			for(int i=0; i < sendMails.length; i++) {
			sendMails[i] = CommonUtil.decryptAES128(sendMails[i]);
			}
			//메일 전송 이력 남기기
			this.issueHistoryService.detectSendIssueMail(IssueHistoryType.SEND, issueForm, sb);
			this.systemEmailService.sendEmail(emailTemplateForm.getTitle(), emailTemplateForm.getTemplate(), sendMails, null);

			this.issueHistoryService.detectSendIssueMail(IssueHistoryType.SEND, emailTemplateForm.getSendEmails(), sb);
			this.issueHistoryService.addIssueHistory(issue, IssueHistoryType.SEND, sb.toString());
			}

			@Override
			public void sendCommonEmail(EmailCommonForm emailCommonForm) {
			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());

			// 발신자 표시
			User user = this.webAppUtil.getLoginUserObject();
			UserVo toUser = this.webAppUtil.getLoginUser();

			// 사용자 시스템 기능 사용 정보 수집
			log.info(ElasticSearchUtil.makeUserActiveHistoryMessage(this.webAppUtil.getLoginUser(), ElasticSearchConstants.ISSUE_ANOTHER_USER_SEND_EMAIL));
			StringBuilder sb = new StringBuilder();

			Locale locale = CommonUtil.getUserLanguage(user.getLanguage());
			String[] sendMails = ConvertUtil.ToArray(emailCommonForm.getSendEmails());
			for(int i=0; i < sendMails.length; i++) {
			sendMails[i] = CommonUtil.decryptAES128(sendMails[i]);
			}
			this.systemEmailService.sendEmail(emailCommonForm.getTitle(), emailCommonForm.getDescription(), sendMails, null);

			this.issueHistoryService.detectSendIssueMail(IssueHistoryType.SEND, emailCommonForm.getSendEmails(), sb);
			this.issueHistoryService.addIssueHistory(issue, IssueHistoryType.SEND, sb.toString());
			}

			@@ -2975,44 +3868,68 @@
			@Transactional
			@Override
			public void modifyParentIssue(IssueForm issueDownForm) {
			Issue issue = this.getIssue(issueDownForm.getId()); //하위 이슈
			//Issue issue = this.getIssue(issueDownForm.getId()); //하위 이슈
			Long newParentIssueId = issueDownForm.getParentIssueId(); //변경할 하위이슈의 상위이슈

			StringBuilder sb = new StringBuilder();

			Issue parentIssue = issue.getParentIssue(); //변경 전 하위이슈의 상위이슈
			if(parentIssue != null && parentIssue.getId().equals(newParentIssueId)){ //변경 전 하위이슈의 상위이슈가 존재 할 경우
			this.issueHistoryService.detectDownIssues(IssueHistoryType.DELETE, issue, sb);
			this.issueHistoryService.addIssueHistory(parentIssue, IssueHistoryType.MODIFY, sb.toString());
			}
			for (Long downId : issueDownForm.getIds()) {
			Issue issue = this.getIssue(downId);

			if (newParentIssueId != null) { // 추가 할 경우
			parentIssue = this.getIssue(newParentIssueId); //상위이슈(myIssue)
			issue.setParentIssue(parentIssue); //myIssue를 하위이슈의 상위이슈로 set
			this.issueHistoryService.detectDownIssues(IssueHistoryType.ADD, issue, sb); //issue = 하위이슈
			} else{
			// 삭제 할 경우
			this.issueHistoryService.detectDownIssues(IssueHistoryType.DELETE, issue, sb);
			issue.setParentIssue(null);
			}
			this.issueHistoryService.addIssueHistory(parentIssue, IssueHistoryType.MODIFY, sb.toString()); //parentIssue = myIssue(기록은 현재 상세페이지에 해야하니까)
			this.issueRepository.saveAndFlush(issue);
			Issue parentIssue = issue.getParentIssue(); //변경 전 하위이슈의 상위이슈
			if(parentIssue != null && parentIssue.getId().equals(newParentIssueId)){ //변경 전 하위이슈의 상위이슈가 존재 할 경우
			this.issueHistoryService.detectDownIssues(IssueHistoryType.DELETE, issue, sb);
			this.issueHistoryService.addIssueHistory(parentIssue, IssueHistoryType.MODIFY, sb.toString());
			}

			if (newParentIssueId != null) { // 추가 할 경우
			parentIssue = this.getIssue(newParentIssueId); //상위이슈(myIssue)
			issue.setParentIssue(parentIssue); //myIssue를 하위이슈의 상위이슈로 set
			this.issueHistoryService.detectDownIssues(IssueHistoryType.ADD, issue, sb); //issue = 하위이슈
			} else{
			// 삭제 할 경우
			this.issueHistoryService.detectDownIssues(IssueHistoryType.DELETE, issue, sb);
			issue.setParentIssue(null);
			}
			this.issueHistoryService.addIssueHistory(parentIssue, IssueHistoryType.MODIFY, sb.toString()); //parentIssue = myIssue(기록은 현재 상세페이지에 해야하니까)
			this.issueRepository.saveAndFlush(issue);
			}
			}

			@Override
			public void findPartner(Map<String, Object> resJsonData, Map<String, Object> params) {
			Long issueTypeId = MapUtil.getLong(params, "issueTypeId");
			IssueType issueType = this.issueTypeService.getIssueType(issueTypeId); // 이슈의 이슈유형 객체
			Integer using = issueType.getUsePartner() != null ? issueType.getUsePartner().intValue() : 0; // 이슈유형별로 사용중인 업체/ISP/호스팅 값

			List<UsePartnerVo> usePartnerVos = Lists.newArrayList();
			Integer using = 0;

			if (issueTypeId != null) {
			IssueType issueType = this.issueTypeService.getIssueType(issueTypeId); // 이슈의 이슈유형 객체
			using = issueType.getUsePartner() != null ? issueType.getUsePartner().intValue() : 0; // 이슈유형별로 사용중인 업체/ISP/호스팅 값
			} else {
			for (int partner : UsePartner.partners) {
			using += partner;
			}
			}

			for (Integer usePartner : UsePartner.partners) { //1(업체), 2(ISP), 4(호스팅)
			UsePartnerVo usePartnerVo = UsePartner.checkUsePartner(using, usePartner);
			if (usePartnerVo != null) {
			usePartnerVos.add(usePartnerVo);
			}
			resJsonData.put(Constants.RES_KEY_CONTENTS, usePartnerVos);
			}

			resJsonData.put(Constants.RES_KEY_CONTENTS, usePartnerVos);
			}

			@Override
			public void findReadyDepartments(Map<String, Object> resJsonData, DepartmentCondition condition, Pageable pageable) {
			IssueType issueType = this.issueTypeService.getIssueType(condition.getIssueTypeId());
			if (issueType != null) {
			// 이슈 상태 유형이 '대기' 인 이슈 상태 가져오기
			IssueStatus issueStatus = this.issueStatusService.findByIssueStatusTypeIsReady(issueType.getWorkflow());
			condition.setIssueStatusId(issueStatus.getId());
			condition.setWorkflowId(issueType.getWorkflow().getId());
			}
			List<Map<String, Object>> departmentVos = this.departmentMapper.findByIssueStatusId(condition);
			resJsonData.put(Constants.RES_KEY_CONTENTS, departmentVos);
			}
			}