업체 정보 일괄 import 기능

이민희

2022-01-12 836af5be0ec8b59171d7c7ffa392a6bd234f0af7

 src/main/webapp/scripts/app/companyField/companyFieldList.controller.js

@@ -19,6 +19,7 @@
                    add : add, //업체 생성
                    makeSearchConditions : makeSearchConditions, //엑셀 다운로드
                    removes : removes, //업체 삭제
                    importExcel : importExcel,  //  엑셀 import 기능 팝업 호출
                };

                //  변수
@@ -45,6 +46,11 @@

                //  업체 관리 리스트 불러오기
                $scope.$on("getPageList", function () {
                    $scope.fn.getPageList(0);
                });

                //  업체 목록 데이터 갱신
                $scope.$on("getCompanyFieldList", function () {
                    $scope.fn.getPageList(0);
                });

@@ -157,24 +163,28 @@
                            // 전화번호 조회시 하이픈 추가 해서 조회
                            result.data.data.forEach(function (data) {
                                if (data.tel != null && data.tel !== "") {
                                    var tels = data.tel.substr(1, data.tel.indexOf("]")-1);
                                    var telArr = tels.split(",");
                                    if (data.tel.indexOf("[") !== -1){
                                        var 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();
                                        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);
                                        for (var i = 0; i < telArr.length; i++) {
                                            let hyphen = telArr[i].trim();
                                            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 = telArr.join();
                                }
                            });

                            // 이메일 조회시 배열 형태 제거
                            result.data.data.forEach(function (data) {
                                if (data.email != null && data.email !== "") {
                                    data.email = data.email.substr(1, data.email.indexOf("]")-1);
                                    if (data.email.indexOf("[") !== -1){
                                        data.email = data.email.substr(1, data.email.indexOf("]")-1);
                                    }
                                }
                            });

@@ -219,6 +229,16 @@
                    });
                }

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

                //  업체 삭제
                function removes() {
                    var removeIds = [];