From a75bcc7c2b0fc98bd3a8abc100a4ad4ec11b9c26 Mon Sep 17 00:00:00 2001
From: wyu <kknd09321@nate.com>
Date: 화, 28 12월 2021 15:54:35 +0900
Subject: [PATCH] Merge branch 'master' of http://192.168.0.25:9001/r/owl-kisa

---
 src/main/java/kr/wisestone/owl/service/impl/QnaServiceImpl.java |   64 +++++++++++++++++++++++++++++++-
 1 files changed, 62 insertions(+), 2 deletions(-)

diff --git a/src/main/java/kr/wisestone/owl/service/impl/QnaServiceImpl.java b/src/main/java/kr/wisestone/owl/service/impl/QnaServiceImpl.java
index 92b538a..2c1aef7 100644
--- a/src/main/java/kr/wisestone/owl/service/impl/QnaServiceImpl.java
+++ b/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);
+    }
 }

--
Gitblit v1.8.0