OWL ITS + 탐지시스템(인터넷 진흥원)
blame | 히스토리 | 패치 | 커밋 | 커밋비교 | ignore whitespace
wyu
2021-12-28 a75bcc7c2b0fc98bd3a8abc100a4ad4ec11b9c26 
 src/main/java/kr/wisestone/owl/service/impl/QnaServiceImpl.java


@@ -1,5 +1,6 @@


package kr.wisestone.owl.service.impl;




import kr.wisestone.owl.common.ExcelConditionCheck;


import kr.wisestone.owl.config.kafka.KafkaSender;


import kr.wisestone.owl.constant.Constants;


import kr.wisestone.owl.constant.MsgConstants;


@@ -9,18 +10,25 @@


import kr.wisestone.owl.repository.QnaRepository;


import kr.wisestone.owl.service.QnaService;


import kr.wisestone.owl.service.UserService;


import kr.wisestone.owl.service.WorkspaceService;


import kr.wisestone.owl.util.ConvertUtil;


import kr.wisestone.owl.vo.QnaVo;


import kr.wisestone.owl.vo.ResPage;


import kr.wisestone.owl.vo.*;


import kr.wisestone.owl.web.condition.NoticeCondition;


import kr.wisestone.owl.web.condition.QnaCondition;


import kr.wisestone.owl.web.form.NoticeForm;


import kr.wisestone.owl.web.form.QnaForm;


import kr.wisestone.owl.web.view.ExcelView;


import org.apache.commons.lang3.StringUtils;


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.transaction.annotation.Transactional;


import org.springframework.ui.Model;


import org.springframework.web.servlet.ModelAndView;




import javax.servlet.http.HttpServletRequest;


import java.util.HashMap;


import java.util.List;


import java.util.Map;




@@ -38,6 +46,15 @@




    @Autowired


    private QnaMapper qnaMapper;




    @Autowired


    private WorkspaceService workspaceService;




    @Autowired


    private ExcelView excelView;




    @Autowired


    private ExcelConditionCheck excelConditionCheck;




    @Override


    protected JpaRepository<Qna, Long> getRepository() {


@@ -130,4 +147,47 @@




        resJsonData.put(Constants.RES_KEY_CONTENTS, qnaVo);


    }




    @Override


    public void remove(QnaForm qnaForm) {


        if (qnaForm.getRemoveIds().size() < 1) {


            throw new OwlRuntimeException(


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


        }


        for (Long id : qnaForm.getRemoveIds()) {


            this.qnaRepository.deleteById(id);


            this.qnaRepository.flush();


        }


    }




    @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;


        }




        QnaCondition qnaCondition = QnaCondition.make(conditions);


        List<Map<String, Object>> results = this.qnaMapper.find(qnaCondition);


        List<QnaVo> qnaVos = ConvertUtil.convertListToListClass(results, QnaVo.class);




        // code_ko_KR 에 code명 설정


        ExportExcelVo excelInfo = new ExportExcelVo();


        excelInfo.setFileName(this.messageAccessor.message("QNA 목록"));


        excelInfo.addAttrInfos(new ExportExcelAttrVo("title", this.messageAccessor.message("qna.title"), 6, ExportExcelAttrVo.ALIGN_CENTER));


        excelInfo.addAttrInfos(new ExportExcelAttrVo("registerDate", this.messageAccessor.message("qna.registerDate"), 10, ExportExcelAttrVo.ALIGN_CENTER));


        excelInfo.addAttrInfos(new ExportExcelAttrVo("writer", this.messageAccessor.message("qna.registerId"), 10, ExportExcelAttrVo.ALIGN_CENTER));




        excelInfo.setDatas(qnaVos);




        model.addAttribute(Constants.EXCEL, excelInfo);


        return new ModelAndView(this.excelView);


    }


}