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

이민희

2022-02-09 a227dd7df7f84a5cfb7218042a6f844991dcfb96

 src/main/webapp/scripts/app/hostingField/hostingFieldList.controller.js

@@ -15,10 +15,12 @@
                $scope.fn = {
                    getPageList : getPageList, // 호스팅 관리 리스트
                    makeTableConfigs : makeTableConfigs, //  테이블 설정
                    changePageRowCount : changePageRowCount,    //  페이지 변경
                    initSearch : initSearch, //검색 조건 초기화
                    add : add, //호스팅 생성
                    removes : removes, //호스팅 삭제
                    makeSearchConditions : makeSearchConditions //엑셀 다운로드
                    makeSearchConditions : makeSearchConditions, //엑셀 다운로드
                    importExcel : importExcel,  //  엑셀 import 기능 팝업 호출
                };

                //  변수
@@ -48,9 +50,19 @@
                    $scope.fn.getPageList(0);
                });

                //  호스팅 목록 데이터 갱신
                $scope.$on("getHostingFieldList", function () {
                    $scope.fn.getPageList(0);
                });

                //  검색 조건 초기화
                function initSearch() {
                    $scope.vm.search.name = "";
                    $scope.fn.getPageList(0);
                }

                //  페이지 변경
                function changePageRowCount() {
                    $scope.fn.getPageList(0);
                }

@@ -82,12 +94,19 @@
                    $scope.vm.tableConfigs.push($tableProvider.config()
                        .setHName("hostingField.tel")
                        .setHWidth("bold")
                        .setHWidth("width-200-p bold")
                        .setDName("tel")
                        .setDAlign("text-center"));
                    $scope.vm.tableConfigs.push($tableProvider.config()
                        .setHName("hostingField.email")
                        .setHWidth("bold")
                        .setHWidth("width-200-p bold")
                        .setDName("email")
                        .setDAlign("text-center"));
                    $scope.vm.tableConfigs.push($tableProvider.config()
                        .setHName("companyField.url")
                        .setHWidth("bold")
                        .setDName("url")
                        .setDAlign("text-center"));
                    $scope.vm.tableConfigs.push($tableProvider.config()
                        .setHName("hostingField.memo")
@@ -122,8 +141,42 @@

                        if (result.data.message.status === "success") {
                            $scope.vm.page.selectedPage = currentPage + 1;
                            $scope.vm.responseData = result.data;

                            result.data.data.forEach(function (data) {
                                // 전화번호 조회시 하이픈 추가, 배열 형태 제거, 콤마 기준 줄바꿈
                                if (data.tel != null && data.tel !== "") {
                                    var tels = data.tel;
                                    if (data.tel.indexOf("[") !== -1){
                                        tels = data.tel.substr(1, data.tel.indexOf("]")-1);
                                    }
                                    var telArr = tels.split(",");

                                    for (var i = 0; i < telArr.length; i++) {
                                        let hyphen = telArr[i].trim();
                                        if (hyphen.length < 9) {
                                            telArr[i] = hyphen.replace(/^(\d{3,4})(\d{4})$/, "$1-$2");
                                        } else {
                                            telArr[i] = hyphen.replace(/(^02.{0}|^01.{1}|[0-9]{3})([0-9]+)([0-9]{4})/, "$1-$2-$3");
                                        }
                                        if (telArr[i] === "") {
                                            telArr.splice(i,1);
                                        }
                                    }
                                    data.tel = telArr.join();
                                    data.tel = data.tel.replace(/\,/g,"</br>");
                                }
                                // 이메일 조회시 배열 형태 제거 및 콤마 기준으로 줄바꿈
                                if ($rootScope.isDefined(data.email)) {
                                    if (data.email.indexOf("[") !== -1){
                                        data.email = data.email.substr(1, data.email.indexOf("]")-1);
                                    }
                                    if (data.email.indexOf(",") !== -1) {
                                        data.email = data.email.replace(/\,/g,"</br>");
                                    }
                                }
                            });

                            $scope.vm.responseData = result.data;
                        }
                        else {
                            SweetAlert.error($filter("translate")("hostingField.failedToSelectHostingFieldFullList"), result.data.message.message); // 호스팅 관리 목록 조회 실패
@@ -224,6 +277,16 @@
                        });
                }

                //  엑셀 import 팝업 호출
                function importExcel() {
                    $uibModal.open({
                        templateUrl : 'views/hostingField/hostingFieldExcelImport.html',
                        size : "lg",
                        controller : 'hostingFieldImportExcelController',
                        backdrop : 'static'
                    });
                }

                function makeSearchConditions() {
                    var conditions = {
                        name: $scope.vm.search.name