From a227dd7df7f84a5cfb7218042a6f844991dcfb96 Mon Sep 17 00:00:00 2001
From: 이민희 <mhlee@maprex.co.kr>
Date: 수, 09 2월 2022 14:53:41 +0900
Subject: [PATCH] - isp, 호스팅 엑셀 import 기능 추가

---
 src/main/java/kr/wisestone/owl/web/controller/IspFieldController.java |   30 +++++++++++++++++++++++-------
 1 files changed, 23 insertions(+), 7 deletions(-)

diff --git a/src/main/java/kr/wisestone/owl/web/controller/IspFieldController.java b/src/main/java/kr/wisestone/owl/web/controller/IspFieldController.java
index 539fb5e..450be62 100644
--- a/src/main/java/kr/wisestone/owl/web/controller/IspFieldController.java
+++ b/src/main/java/kr/wisestone/owl/web/controller/IspFieldController.java
@@ -13,6 +13,7 @@
 import org.springframework.web.bind.annotation.RequestMapping;
 import org.springframework.web.bind.annotation.RequestMethod;
 import org.springframework.web.bind.annotation.ResponseBody;
+import org.springframework.web.multipart.MultipartHttpServletRequest;
 import org.springframework.web.servlet.ModelAndView;
 
 import javax.servlet.http.HttpServletRequest;
@@ -25,7 +26,7 @@
     @Autowired
     private IspFieldService IspFieldService;
 
-    // �뾽泥� �깮�꽦
+    // ISP �깮�꽦
     @RequestMapping(value = "/ispField/add", method = RequestMethod.POST)
     public
     @ResponseBody
@@ -37,7 +38,7 @@
         return this.setSuccessMessage(resJsonData);
     }
 
-    // �뾽泥� 議고쉶
+    // ISP 議고쉶
     @RequestMapping(value = "/ispField/find", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
     public
     @ResponseBody
@@ -50,7 +51,7 @@
         return this.setSuccessMessage(resJsonData);
     }
 
-    // �뾽泥� �긽�꽭 議고쉶
+    // ISP �긽�꽭 議고쉶
     @RequestMapping(value = "/ispField/detail", produces = MediaType.APPLICATION_JSON_VALUE)
     public
     @ResponseBody
@@ -61,7 +62,7 @@
         return this.setSuccessMessage(resJsonData);
     }
 
-    // �뾽泥� �닔�젙
+    // ISP �닔�젙
     @RequestMapping(value = "/ispField/modify", produces = MediaType.APPLICATION_JSON_VALUE)
     public
     @ResponseBody
@@ -73,7 +74,7 @@
         return this.setSuccessMessage(resJsonData);
     }
 
-    // �뾽泥� �궘�젣
+    // ISP �궘�젣
     @RequestMapping(value = "/ispField/remove", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
     public
     @ResponseBody
@@ -86,11 +87,26 @@
         return this.setSuccessMessage(resJsonData);
     }
 
-
-    // �뾽泥� �뿊�� �떎�슫濡쒕뱶
+    // ISP �뿊�� �떎�슫濡쒕뱶
     @RequestMapping(value = "/ispField/downloadExcel", method = RequestMethod.POST)
     public ModelAndView downloadExcel(HttpServletRequest request, Model model) {
         return this.IspFieldService.downloadExcel(request, model);
     }
+
+    //  ISP Import �슜 �뿊�� �뀥�뵆由� �떎�슫濡쒕뱶
+    @RequestMapping(value = "/ispField/downloadExcelTemplate", method = RequestMethod.POST)
+    public ModelAndView downloadExcelImport(HttpServletRequest request, Model model) {
+        return this.IspFieldService.downloadExcelTemplate(request, model);
+    }
+
+    //  ISP �뿊�� �벑濡�
+    @RequestMapping(value = "/ispField/importExcel", method = RequestMethod.POST)
+    public @ResponseBody Map<String, Object> importExcel(MultipartHttpServletRequest request) throws Exception {
+        Map<String, Object> resJsonData = new HashMap<>();
+
+        this.IspFieldService.importExcel(request.getFile("file"));
+
+        return this.setSuccessMessage(resJsonData);
+    }
 }
 

--
Gitblit v1.8.0