업체 임포트 시 연락처 null 체크 코드 수정

이민희

2022-01-28 bbe66a15ffe8fba4ccb2b7746f85bb7ec7e92d7e

 src/main/java/kr/wisestone/owl/service/impl/CompanyFieldServiceImpl.java

@@ -443,7 +443,10 @@
     * @return boolean
     */
    private Boolean cellNullCheck (Cell cell) {
        return cell != null && cell.getStringCellValue() != null && cell.getCellType() != Cell.CELL_TYPE_BLANK;
        if (cell != null && cell.getStringCellValue() != null) {
            cell.setCellValue(cell.getStringCellValue().trim());//셀 값 공백 제거
        }
        return cell != null && cell.getStringCellValue() != null && !cell.getStringCellValue().equals("") && cell.getCellType() != Cell.CELL_TYPE_BLANK;
    }

    private void telTypeCheck (Cell cell, int rowIndex) {
@@ -492,9 +495,8 @@

                case 4:
                    // 연락처
                    this.telTypeCheck(cell, rowIndex); // 텍스트 형식 체크
                    
                    if (cellNullCheck(cell)) {
                        this.telTypeCheck(cell, rowIndex); // 텍스트 형식 체크
                        this.setCompanyFormTel(cell, companyFieldForm, rowIndex);
                    }
                    break;