연관 ,하위 이슈 요청 횟수 수정

wyu

2021-12-08 257766aa7e8a88b2b371fc6f8f52751af7d84eda

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

@@ -16,6 +16,7 @@
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;
import java.util.Map;

@Service
@@ -37,14 +38,13 @@
        return this.issueTableConfigRepository;
    }

    Long issueId;
    Long issueTypeId;
    int issueTableType = 0; //issueTableType 초기값 설정

    //  add 중복코드 제거
    public IssueTableConfig addMultipleCode(Map<String, Object> params, Long issueId, int issueTableType) {
    public IssueTableConfig addIssueTableConfig(Map<String, Object> params, Long issueTypeId, int issueTableType) {
        String issueTableConfigs = MapUtil.getString(params, "issueTableConfigs");
        IssueTableConfig issueTableConfig = this.findByUserIdAndWorkspaceIdAndIssueIdAndIssueTableType(issueId, issueTableType);
        //IssueTableConfig saveIssueTableType = this.findByIssueIdAndIssueTableType(issueId,issueTableType);
        IssueTableConfig issueTableConfig = this.findByUserIdAndWorkspaceIdAndIssueTypeIdAndIssueTableType(issueTypeId, issueTableType);

        //  아직 테이블 컬럼 설정을 하지 않았을 경우
        if (issueTableConfig == null) {
@@ -53,18 +53,9 @@
            User user = this.userService.getUser(this.webAppUtil.getLoginId());
            issueTableConfig.setWorkspace(workspace);
            issueTableConfig.setUser(user);
            issueTableConfig.setIssueId(issueId);
            issueTableConfig.setIssueTypeId(issueTypeId);
            issueTableConfig.setIssueTableType(issueTableType);
            issueTableConfig.setIssueTableConfigs(issueTableConfigs);
        /*}else if(saveIssueTableType == null){
            issueTableConfig = new IssueTableConfig();
            Workspace workspace = this.workspaceService.getWorkspace(this.userService.getUser(this.webAppUtil.getLoginId()).getLastWorkspaceId());
            User user = this.userService.getUser(this.webAppUtil.getLoginId());
            issueTableConfig.setWorkspace(workspace);
            issueTableConfig.setUser(user);
            issueTableConfig.setIssueId(issueId);
            issueTableConfig.setIssueTableType(issueTableType);
            issueTableConfig.setIssueTableConfigs(issueTableConfigs);*/
        }else {
            issueTableConfig.setIssueTableConfigs(issueTableConfigs);
        }
@@ -75,44 +66,56 @@
    @Override
    @Transactional
    public IssueTableConfig addIssueTableConfig(Map<String, Object> params) {
        issueId = (long) -1;
        issueTableType = 1;
        return this.addMultipleCode(params, issueId, issueTableType);
        issueTypeId = MapUtil.getLong(params, "issueTypeId");
        issueTableType = 1; //메인
        return this.addIssueTableConfig(params, issueTypeId, issueTableType);
    }
    // 연관 이슈 테이블 설정 정보 저장
    @Override
    public IssueTableConfig addRelationIssueTableConfig(Map<String, Object> params) {
        issueId = MapUtil.getLong(params, "issueId");
        issueTableType = 2;
        return this.addMultipleCode(params, issueId, issueTableType);
        issueTypeId = MapUtil.getLong(params, "issueTypeId");
        issueTableType = 2; //연관
        return this.addIssueTableConfig(params, issueTypeId, issueTableType);
    }
    // 하위 이슈 테이블 설정 정보 저장
    @Override
    public IssueTableConfig addDownIssueTableConfig(Map<String, Object> params) {
        issueId = MapUtil.getLong(params, "issueId");
        issueTableType = 3;
        return this.addMultipleCode(params, issueId, issueTableType);
        issueTypeId = MapUtil.getLong(params, "issueTypeId");
        issueTableType = 3; //하위
        return this.addIssueTableConfig(params, issueTypeId, issueTableType);
    }


    //  해당 업무 공간에서 사용자의 이슈 테이블 설정을 조회한다.
    @Override
    @Transactional(readOnly = true)
    public IssueTableConfig findByUserIdAndWorkspaceIdAndIssueIdAndIssueTableType(Long issueId, int issueTableType) {
        return this.issueTableConfigRepository.findByUserIdAndWorkspaceIdAndIssueIdAndIssueTableType(this.webAppUtil.getLoginId(),
                this.userService.getUser(this.webAppUtil.getLoginId()).getLastWorkspaceId(), issueId, issueTableType);
    public IssueTableConfig findByUserIdAndWorkspaceIdAndIssueTypeIdAndIssueTableType(Long issueTypeId, int issueTableType) {
        List<IssueTableConfig> issueTableConfigList = this.issueTableConfigRepository.findByUserIdAndWorkspaceIdAndIssueTypeIdAndIssueTableType(this.webAppUtil.getLoginId(),
                this.userService.getUser(this.webAppUtil.getLoginId()).getLastWorkspaceId(), issueTypeId, issueTableType);

        if (issueTableConfigList != null && issueTableConfigList.size() > 0) {
            return  issueTableConfigList.get(0);
        }
        return null;
    }

    //이슈 Id와 IssueTableType 조회
    //이슈타입 Id와 IssueTableType 조회
    @Override
    @Transactional(readOnly = true)
    public IssueTableConfig findByIssueIdAndIssueTableType(Long issueId, int issueTableType) {
        return this.issueTableConfigRepository.findByIssueIdAndIssueTableType(issueId, issueTableType);
    public IssueTableConfig findByIssueTypeIdAndIssueTableType(Long issueTypeId, int issueTableType) {
        List<IssueTableConfig> issueTableConfigs = this.issueTableConfigRepository.findByIssueTypeIdAndIssueTableType(issueTypeId, issueTableType);
        if (issueTableConfigs != null && issueTableConfigs.size() > 0){
            return issueTableConfigs.get(0);
        }
        return  null;
    }

    // detail 중복 코드 제거
    private void detailMultipleCode(Map<String, Object> resJsonData, Long issueId, int issueTableType) {
        //  해당 업무 공간에서 사용자의 이슈 검색 조건을 조회한다.
        IssueTableConfig issueTableConfig = this.findByUserIdAndWorkspaceIdAndIssueIdAndIssueTableType(issueId, issueTableType);
    @Override
    public void detailIssueTableConfig(Map<String, Object> params, Map<String, Object> resJsonData) {
        Long issueTypeId = MapUtil.getLong(params,"issueTypeId");
        int issueTableType = MapUtil.getInteger(params,"issueTableType");

        IssueTableConfig issueTableConfig = this.findByUserIdAndWorkspaceIdAndIssueTypeIdAndIssueTableType(issueTypeId, issueTableType);

        if (issueTableConfig != null) {
            resJsonData.put(Constants.RES_KEY_CONTENTS, issueTableConfig.getIssueTableConfigs());
@@ -121,38 +124,4 @@
            resJsonData.put(Constants.RES_KEY_CONTENTS, "");
        }
    }

    //  저장된 이슈 테이블 설정을 조회한다.
    @Override
    @Transactional(readOnly = true)
    public void detailIssueTableConfig(Map<String, Object> resJsonData) {
        issueId = (long) -1;
        issueTableType = 1;
        //  해당 업무 공간에서 사용자의 이슈 검색 조건을 조회한다.
        IssueTableConfig issueTableConfig = this.findByUserIdAndWorkspaceIdAndIssueIdAndIssueTableType(issueId, issueTableType);

        if (issueTableConfig != null) {
            resJsonData.put(Constants.RES_KEY_CONTENTS, issueTableConfig.getIssueTableConfigs());
        }
        else {
            resJsonData.put(Constants.RES_KEY_CONTENTS, "");
        }
    }
    //  저장된 연관 이슈 테이블 설정 조회
    @Override
    public void detailRelationIssueTableConfig(Map<String, Object> params, Map<String, Object> resJsonData) {
        issueTableType = 2;
        issueId = MapUtil.getLong(params, "issueId");
        this.detailMultipleCode(resJsonData, issueId, issueTableType);
    }
    //  저장된 하위 이슈 테이블 설정 조회
    @Override
    public void detailDownIssueTableConfig(Map<String, Object> params, Map<String, Object> resJsonData) {
        issueTableType = 3;
        issueId = MapUtil.getLong(params, "issueId");
        this.detailMultipleCode(resJsonData, issueId, issueTableType);
    }



}