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/GuideServiceImpl.java |   91 +++++++++++++++++++++++++++++++++++++++++++--
 1 files changed, 86 insertions(+), 5 deletions(-)

diff --git a/src/main/java/kr/wisestone/owl/service/impl/GuideServiceImpl.java b/src/main/java/kr/wisestone/owl/service/impl/GuideServiceImpl.java
index 4cb9a19..2c9b7d3 100644
--- a/src/main/java/kr/wisestone/owl/service/impl/GuideServiceImpl.java
+++ b/src/main/java/kr/wisestone/owl/service/impl/GuideServiceImpl.java
@@ -1,26 +1,38 @@
 package kr.wisestone.owl.service.impl;
 
+import com.google.common.collect.Lists;
+import kr.wisestone.owl.common.ExcelConditionCheck;
 import kr.wisestone.owl.constant.Constants;
+import kr.wisestone.owl.constant.MngPermission;
 import kr.wisestone.owl.constant.MsgConstants;
 import kr.wisestone.owl.domain.Guide;
+import kr.wisestone.owl.domain.User;
+import kr.wisestone.owl.domain.UserLevel;
 import kr.wisestone.owl.exception.OwlRuntimeException;
 import kr.wisestone.owl.mapper.GuideMapper;
 import kr.wisestone.owl.repository.GuideRepository;
 import kr.wisestone.owl.service.GuideService;
+import kr.wisestone.owl.service.UserLevelService;
+import kr.wisestone.owl.service.UserWorkspaceService;
+import kr.wisestone.owl.service.WorkspaceService;
 import kr.wisestone.owl.util.CommonUtil;
 import kr.wisestone.owl.util.ConvertUtil;
-import kr.wisestone.owl.vo.GuideVo;
-import kr.wisestone.owl.vo.ManageUserVo;
-import kr.wisestone.owl.vo.ResPage;
+import kr.wisestone.owl.vo.*;
 import kr.wisestone.owl.web.condition.GuideCondition;
+import kr.wisestone.owl.web.condition.NoticeCondition;
 import kr.wisestone.owl.web.form.GuideForm;
+import kr.wisestone.owl.web.form.NoticeForm;
+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;
@@ -33,6 +45,21 @@
 
     @Autowired
     private GuideMapper guideMapper;
+
+    @Autowired
+    private WorkspaceService workspaceService;
+
+    @Autowired
+    private ExcelView excelView;
+
+    @Autowired
+    private ExcelConditionCheck excelConditionCheck;
+
+    @Autowired
+    private UserLevelService userLevelService;
+
+    @Autowired
+    private UserWorkspaceService userWorkspaceService;
 
     @Override
     protected JpaRepository<Guide, Long> getRepository() {
@@ -69,8 +96,19 @@
         guideCondition.setPageSize(pageable.getPageSize());
         guideCondition.setTitle(guideCondition.getTitle());
 
-        List<Map<String, Object>> results = this.guideMapper.find(guideCondition);
-        Long totalCount = this.guideMapper.count(guideCondition);
+        User user = this.webAppUtil.getLoginUserObject();
+        UserLevel userLevel = this.userLevelService.getUserLevel(user.getUserLevel().getId());
+
+        List<Map<String, Object>> results = Lists.newArrayList();
+        Long totalCount = 0L;
+        if (this.userWorkspaceService.checkWorkspaceManager(user)
+                || MngPermission.checkMngPermission(userLevel.getPermission(), MngPermission.USER_PERMISSION_MNG_GUIDE)) {
+            results = this.guideMapper.find(guideCondition);
+            totalCount = this.guideMapper.count(guideCondition);
+        } else {
+            results = this.guideMapper.findNotActivation(guideCondition);
+            totalCount = this.guideMapper.countNotActivation(guideCondition);
+        }
         int totalPage = (int) Math.ceil((totalCount - 1) / pageable.getPageSize()) + 1;
         List<GuideVo> guideVos = ConvertUtil.convertListToListClass(results, GuideVo.class);
 
@@ -158,4 +196,47 @@
 
         resJsonData.put(Constants.RES_KEY_CONTENTS, guideVo);
     }
+
+    @Override
+    public void remove(GuideForm guideForm) {
+        if (guideForm.getRemoveIds().size() < 1) {
+            throw new OwlRuntimeException(
+                    this.messageAccessor.getMessage(MsgConstants.COMPANY_REMOVE_NOT_SELECT));
+        }
+        for (Long id : guideForm.getRemoveIds()) {
+            this.guideRepository.deleteById(id);
+            this.guideRepository.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;
+        }
+
+        GuideCondition guideCondition = GuideCondition.make(conditions);
+        List<Map<String, Object>> results = this.guideMapper.find(guideCondition);
+        List<GuideVo> guideVos = ConvertUtil.convertListToListClass(results, GuideVo.class);
+
+        // code_ko_KR �뿉 code紐� �꽕�젙
+        ExportExcelVo excelInfo = new ExportExcelVo();
+        excelInfo.setFileName(this.messageAccessor.message("媛��씠�뱶 紐⑸줉"));
+        excelInfo.addAttrInfos(new ExportExcelAttrVo("title", this.messageAccessor.message("guide.title"), 6, ExportExcelAttrVo.ALIGN_CENTER));
+        excelInfo.addAttrInfos(new ExportExcelAttrVo("registerDate", this.messageAccessor.message("guide.registerDate"), 10, ExportExcelAttrVo.ALIGN_CENTER));
+        excelInfo.addAttrInfos(new ExportExcelAttrVo("writer", this.messageAccessor.message("guide.registerId"), 10, ExportExcelAttrVo.ALIGN_CENTER));
+
+        excelInfo.setDatas(guideVos);
+
+        model.addAttribute(Constants.EXCEL, excelInfo);
+        return new ModelAndView(this.excelView);
+    }
 }

--
Gitblit v1.8.0