- isp, 호스팅 엑셀 import 기능 추가

이민희

2022-02-09 a227dd7df7f84a5cfb7218042a6f844991dcfb96

 src/main/java/kr/wisestone/owl/web/controller/HostingFieldController.java

@@ -14,6 +14,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;
@@ -26,7 +27,7 @@
    @Autowired
    private HostingFieldService HostingFieldService;

    // 업체 생성
    // 호스팅 생성
    @RequestMapping(value = "/hostingField/add", method = RequestMethod.POST)
    public
    @ResponseBody
@@ -38,7 +39,7 @@
        return this.setSuccessMessage(resJsonData);
    }

    // 업체 조회
    // 호스팅 조회
    @RequestMapping(value = "/hostingField/find", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
    public
    @ResponseBody
@@ -51,7 +52,7 @@
        return this.setSuccessMessage(resJsonData);
    }

    // 업체 상세 조회
    // 호스팅 상세 조회
    @RequestMapping(value = "/hostingField/detail", produces = MediaType.APPLICATION_JSON_VALUE)
    public
    @ResponseBody
@@ -62,7 +63,7 @@
        return this.setSuccessMessage(resJsonData);
    }

    // 업체 수정
    // 호스팅 수정
    @RequestMapping(value = "/hostingField/modify", produces = MediaType.APPLICATION_JSON_VALUE)
    public
    @ResponseBody
@@ -74,7 +75,7 @@
        return this.setSuccessMessage(resJsonData);
    }

    // 업체 삭제
    // 호스팅 삭제
    @RequestMapping(value = "/hostingField/remove", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
    public
    @ResponseBody
@@ -98,11 +99,26 @@
        return this.setSuccessMessage(resJsonData);
    }


    // 업체 엑셀 다운로드
    // 호스팅 엑셀 다운로드
    @RequestMapping(value = "/hostingField/downloadExcel", method = RequestMethod.POST)
    public ModelAndView downloadExcel(HttpServletRequest request, Model model) {
        return this.HostingFieldService.downloadExcel(request, model);
    }

    //  호스팅 Import 용 엑셀 템플릿 다운로드
    @RequestMapping(value = "/hostingField/downloadExcelTemplate", method = RequestMethod.POST)
    public ModelAndView downloadExcelImport(HttpServletRequest request, Model model) {
        return this.HostingFieldService.downloadExcelTemplate(request, model);
    }

    //  호스팅 엑셀 등록
    @RequestMapping(value = "/hostingField/importExcel", method = RequestMethod.POST)
    public @ResponseBody Map<String, Object> importExcel(MultipartHttpServletRequest request) throws Exception {
        Map<String, Object> resJsonData = new HashMap<>();

        this.HostingFieldService.importExcel(request.getFile("file"));

        return this.setSuccessMessage(resJsonData);
    }
}