package kr.wisestone.owl.service.impl;
|
|
import kr.wisestone.owl.domain.*;
|
import kr.wisestone.owl.mapper.DepartmentMapper;
|
import kr.wisestone.owl.repository.UserDepartmentRepository;
|
import kr.wisestone.owl.service.*;
|
import kr.wisestone.owl.web.condition.DepartmentCondition;
|
import kr.wisestone.owl.web.condition.UserCondition;
|
import kr.wisestone.owl.web.form.DepartmentForm;
|
import org.jsoup.Jsoup;
|
import org.slf4j.Logger;
|
import org.slf4j.LoggerFactory;
|
import org.springframework.transaction.annotation.Transactional;
|
import org.springframework.ui.Model;
|
import com.google.common.collect.Lists;
|
import kr.wisestone.owl.common.ExcelConditionCheck;
|
import kr.wisestone.owl.constant.Constants;
|
import kr.wisestone.owl.constant.MsgConstants;
|
import kr.wisestone.owl.exception.OwlRuntimeException;
|
import kr.wisestone.owl.repository.DepartmentRepository;
|
import kr.wisestone.owl.util.ConvertUtil;
|
import kr.wisestone.owl.vo.*;
|
import kr.wisestone.owl.web.view.ExcelView;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.data.domain.Pageable;
|
import org.springframework.data.jpa.repository.JpaRepository;
|
import org.springframework.stereotype.Service;
|
import org.springframework.web.servlet.ModelAndView;
|
|
import javax.servlet.http.HttpServletRequest;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
@Service
|
public class DepartmentServiceImpl extends AbstractServiceImpl<Department, Long, JpaRepository<Department, Long>> implements DepartmentService {
|
|
private static final Logger log = LoggerFactory.getLogger(IssueServiceImpl.class);
|
|
@Autowired
|
private DepartmentRepository departmentRepository;
|
|
@Autowired
|
private UserDepartmentService userDepartmentService;
|
|
@Autowired
|
private DepartmentMapper departmentMapper;
|
|
@Autowired
|
private DepartmentService departmentService;
|
|
@Autowired
|
private WorkflowDepartmentService workflowDepartmentService;
|
|
@Autowired
|
private ProjectRoleDepartmentService projectRoleDepartmentService;
|
|
@Autowired
|
private IssueDepartmentService issueDepartmentService;
|
|
@Autowired
|
private ProjectRoleService projectRoleService;
|
|
@Autowired
|
private IssueTypeService issueTypeService;
|
|
@Autowired
|
private WorkspaceService workspaceService;
|
|
@Autowired
|
private ExcelView excelView;
|
|
@Autowired
|
private ExcelConditionCheck excelConditionCheck;
|
|
@Override
|
protected JpaRepository<Department, Long> getRepository() {
|
return this.departmentRepository;
|
}
|
|
// 부서 추가
|
@Override
|
public Department add(DepartmentForm departmentForm) {
|
Department department = ConvertUtil.copyProperties(departmentForm, Department.class);
|
departmentRepository.saveAndFlush(department);
|
return department;
|
}
|
|
// 부서 목록을 가져온다.
|
@Override
|
public List<DepartmentVo>find(Map<String, Object> resJsonData,
|
DepartmentCondition condition, Pageable pageable) {
|
condition.setPage(pageable.getPageNumber() * pageable.getPageSize());
|
condition.setPageSize(pageable.getPageSize());
|
|
List<Map<String, Object>> results = this.departmentMapper.find(condition);
|
Long totalDepartmentCount = this.departmentMapper.count(condition);
|
|
return this.convertDepartmentVoToMap(results, totalDepartmentCount, pageable, resJsonData);
|
}
|
|
// 부서 상세 조회한다.
|
@Override
|
public void detail(Map<String, Object> resJsonData, DepartmentCondition departmentCondition) {
|
DepartmentVo departmentVo = new DepartmentVo();
|
|
Long departmentId = departmentCondition.getId();
|
if (departmentId != null) {
|
Department department = this.getDepartment(departmentId);
|
departmentVo = ConvertUtil.copyProperties(department, DepartmentVo.class);
|
}
|
resJsonData.put(Constants.RES_KEY_CONTENTS, departmentVo);
|
}
|
|
// 부서 정보를 수정한다.
|
@Override
|
public void modify(DepartmentForm departmentForm) {
|
Department department = ConvertUtil.copyProperties(departmentForm, Department.class);
|
departmentRepository.saveAndFlush(department);
|
}
|
|
// 부서를 삭제한다.
|
@Override
|
public void remove(DepartmentForm departmentForm) {
|
if (departmentForm.getRemoveIds().size() < 1) {
|
throw new OwlRuntimeException(
|
this.messageAccessor.getMessage(MsgConstants.DEPARTMENT_REMOVE_NOT_SELECT));
|
}
|
|
for (Long id : departmentForm.getRemoveIds()) {
|
if (this.departmentService.countInDepartment(id)) {
|
// 사용자가 부서에 속해 있는지 체크
|
throw new OwlRuntimeException(
|
this.messageAccessor.getMessage(MsgConstants.DEPARTMENT_ALREADY_IN_USE));
|
|
} else if (this.workflowDepartmentService.usingDepartment(id)) {
|
// 워크플로우에서 해당 부서를 사용하고 있는지 체크
|
throw new OwlRuntimeException(
|
this.messageAccessor.getMessage(MsgConstants.DEPARTMENT_ALREADY_IN_USE_IN_WORKFLOW));
|
|
} else if (this.projectRoleDepartmentService.usingDepartment(id)) {
|
// 프로젝트의 담당부서인지 체크
|
throw new OwlRuntimeException(
|
this.messageAccessor.getMessage(MsgConstants.DEPARTMENT_ALREADY_IN_USE_IN_PROJECT));
|
|
} else if (this.issueDepartmentService.usingDepartment(id)) {
|
// 이슈의 담당부서로 되어있는지 체크
|
throw new OwlRuntimeException(
|
this.messageAccessor.getMessage(MsgConstants.DEPARTMENT_ALREADY_IN_USE_IN_ISSUE));
|
|
} else {
|
this.departmentRepository.deleteById(id);
|
}
|
}
|
this.departmentRepository.flush();
|
}
|
|
// 프로젝트에 참여하는 부서 정보를 조회한다.
|
@Override
|
@Transactional(readOnly = true)
|
public List<Map<String, Object>> findProjectDepartment(Project project) {
|
DepartmentCondition departmentCondition = new DepartmentCondition();
|
departmentCondition.setProjectId(project.getId());
|
return this.departmentMapper.findProjectDepartment(departmentCondition);
|
}
|
|
// 프로젝트에 참여하는 부서 목록을 가져온다.
|
@Override
|
@Transactional(readOnly = true)
|
public void findProjectDepartment(Map<String, Object> resJsonData, DepartmentCondition departmentCondition) {
|
ProjectRole projectRole = this.projectRoleService.findByProjectIdAndRoleType(departmentCondition.getProjectId(), ProjectRole.TYPE_DEFAULT);
|
List<ProjectRoleDepartment> projectRoleDepartments = this.projectRoleDepartmentService.findByProjectRoleId(projectRole.getId());
|
List<DepartmentVo> departmentVos = Lists.newArrayList();
|
|
for (ProjectRoleDepartment projectRoleDepartment : projectRoleDepartments) {
|
DepartmentVo departmentVo = ConvertUtil.copyProperties(projectRoleDepartment.getDepartment(), DepartmentVo.class);
|
departmentVo.setByName(departmentVo.getDepartmentName());
|
departmentVos.add(departmentVo);
|
}
|
|
resJsonData.put(Constants.RES_KEY_CONTENTS, departmentVos);
|
}
|
|
// 워크플로우에 속해있는 부서 목록 조회
|
@Override
|
@Transactional(readOnly = true)
|
public void findWorkflowDepartment(Map<String, Object> resJsonData, DepartmentCondition departmentCondition) {
|
List<DepartmentVo> departmentVos = findWorkflowDepartment(departmentCondition.getIssueTypeId());
|
resJsonData.put(Constants.RES_KEY_CONTENTS, departmentVos);
|
}
|
|
// 워크플로우에 속해있는 부서 목록 조회
|
@Override
|
@Transactional(readOnly = true)
|
public List<DepartmentVo> findWorkflowDepartment(Long issueTypeId) {
|
List<WorkflowDepartment> workflowDepartmentList = this.findWorkflowDepartmentByIssueTypeId(issueTypeId);
|
List<DepartmentVo> departmentVos = Lists.newArrayList();
|
|
if(workflowDepartmentList != null && workflowDepartmentList.size()>0){
|
for(WorkflowDepartment workflowDepartment : workflowDepartmentList){
|
DepartmentVo departmentVo = ConvertUtil.copyProperties(workflowDepartment.getDepartment(), DepartmentVo.class);
|
departmentVo.setByName(departmentVo.getDepartmentName());
|
departmentVos.add(departmentVo);
|
}
|
}
|
return departmentVos;
|
}
|
|
// 이슈 유형(워크플로우)에 있는 담당부서 조회
|
private List<WorkflowDepartment> findWorkflowDepartmentByIssueTypeId(Long issueTypeId) {
|
Long workflowId = this.getWorkflowId(issueTypeId);
|
return this.workflowDepartmentService.find(workflowId);
|
}
|
|
private Long getWorkflowId(Long issueTypeId) {
|
IssueType issueType = this.issueTypeService.getIssueType(issueTypeId);
|
return issueType.getWorkflow().getId();
|
}
|
|
// 부서 목록을 엑셀로 다운로드 한다.
|
@Override
|
public ModelAndView downloadExcel(HttpServletRequest request, Model model) {
|
|
ModelAndView modelAndView = this.workspaceService.checkUseExcelDownload(model);
|
if (modelAndView != null) {
|
return modelAndView;
|
}
|
|
Map<String, Object> conditions = new HashMap<>();
|
// 엑셀 다운로드에 필요한 검색 조건 정보를 추출하고 검색 조건 추출에 오류가 발생하면 경고를 표시해준다.
|
modelAndView = this.excelConditionCheck.checkCondition(conditions, request, model);
|
if (modelAndView != null) {
|
return modelAndView;
|
}
|
|
DepartmentCondition departmentCondition = DepartmentCondition.make(conditions);
|
|
|
List<Map<String, Object>> results = this.departmentMapper.find(departmentCondition);
|
List<DepartmentVo> departmentVos = ConvertUtil.convertListToListClass(results, DepartmentVo.class);
|
// code_ko_KR 에 code명 설정
|
ExportExcelVo excelInfo = new ExportExcelVo();
|
excelInfo.setFileName(this.messageAccessor.message("부서 목록"));
|
excelInfo.addAttrInfos(new ExportExcelAttrVo("departmentName", this.messageAccessor.message("department.departmentName"), 6, ExportExcelAttrVo.ALIGN_CENTER));
|
excelInfo.addAttrInfos(new ExportExcelAttrVo("departmentDescription", this.messageAccessor.message("department.departmentDescription"), 20, ExportExcelAttrVo.ALIGN_CENTER));
|
excelInfo.addAttrInfos(new ExportExcelAttrVo("departmentCount", this.messageAccessor.message("department.departmentCount"), 3, ExportExcelAttrVo.ALIGN_CENTER));
|
|
// DepartmentVos 데이터를 엑셀에서 표시할 수 있는 데이터로 변경한다.
|
List<Map<String, Object>> convertExcelViewToDepartmentMaps = this.convertExcelViewToDepartmentVos(departmentVos);
|
|
excelInfo.setDatas(convertExcelViewToDepartmentMaps);
|
|
model.addAttribute(Constants.EXCEL, excelInfo);
|
return new ModelAndView(this.excelView);
|
|
}
|
|
@Override
|
public boolean countInDepartment(Long id) {
|
boolean result = false;
|
List<UserDepartment> usingDepartments = this.userDepartmentService.findByDepartmentId(id);
|
if(usingDepartments != null && usingDepartments.size() > 0){
|
result = true;
|
}
|
return result;
|
}
|
|
// DepartmentVos 데이터를 엑셀에서 표시할 수 있는 데이터로 변경한다.
|
private List<Map<String, Object>> convertExcelViewToDepartmentVos(List<DepartmentVo> departmentVos) {
|
List<Map<String, Object>> results = Lists.newArrayList();
|
|
for (DepartmentVo departmentVo : departmentVos){
|
try {
|
Map<String, Object> result = new HashMap<>();
|
result.put("departmentName", departmentVo.getDepartmentName());
|
result.put("departmentCount", departmentVo.getDepartmentCount());
|
|
String description= "";
|
|
if(departmentVo.getDepartmentDescription() != null){
|
description = Jsoup.parse(departmentVo.getDepartmentDescription()).text(); //HTML 태그 제거
|
description = description.replaceAll("\\<.*?>", ""); //공백 제거
|
}
|
result.put("departmentDescription", description);
|
results.add(result);
|
} catch (Exception e) {
|
log.error("엑셀 다운로드 오류 발생");
|
}
|
}
|
return results;
|
}
|
|
// 사용자 부서 ID로 조회한다.
|
@Override
|
public Department getDepartment(Long id) {
|
if (id == null) {
|
throw new OwlRuntimeException(
|
this.messageAccessor.getMessage(MsgConstants.DEPARTMENT_NOT_EXIST));
|
}
|
|
Department department = this.findOne(id);
|
|
if (department == null) {
|
throw new OwlRuntimeException(
|
this.messageAccessor.getMessage(MsgConstants.DEPARTMENT_NOT_EXIST));
|
}
|
|
return department;
|
}
|
|
@Override
|
public List<Map<String, Object>> findByDepartmentIds(UserCondition condition) {
|
return this.departmentMapper.findByDepartmentIds(condition);
|
}
|
|
// 검색 결과를 DepartmentVo 로 변환한다.
|
private List<DepartmentVo> convertDepartmentVoToMap(List<Map<String, Object>> results, Long totalDepartmentsCount, Pageable pageable, Map<String, Object> resJsonData) {
|
List<DepartmentVo> departmentVos = Lists.newArrayList();
|
|
for (Map<String, Object> result : results) {
|
DepartmentVo departmentVo = ConvertUtil.convertMapToClass(result, DepartmentVo.class);
|
departmentVo.setByName(departmentVo.getDepartmentName());
|
departmentVos.add(departmentVo);
|
}
|
|
int totalPage = (int) Math.ceil((totalDepartmentsCount - 1) / pageable.getPageSize()) + 1;
|
|
resJsonData.put(Constants.RES_KEY_CONTENTS, departmentVos);
|
resJsonData.put(Constants.REQ_KEY_PAGE_VO, new ResPage(pageable.getPageNumber(), pageable.getPageSize(),
|
totalPage, totalDepartmentsCount));
|
|
return departmentVos;
|
}
|
}
|
