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