#

luxiaotao1123

2022-09-18 9236c9d1512b57f78755747bdabcd8adf4685ade

 src/main/java/com/zy/crm/manager/controller/CstmrController.java

@@ -19,6 +19,7 @@
import com.zy.crm.system.service.DicService;
import lombok.extern.slf4j.Slf4j;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.DataFormatter;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
@@ -182,7 +183,7 @@
    @ManagerAuth(memo = "甲方单位Excel导入")
    @Transactional
    public R cstmrExcelImport(MultipartFile file) throws IOException {
        try (InputStream inStream = file.getInputStream()) {
        InputStream inStream = file.getInputStream();
            String fileMime = file.getContentType();
            int excelVersion = 2007;
            if ("application/vnd.ms-excel".equals(fileMime)) {
@@ -196,16 +197,17 @@
                book = new XSSFWorkbook(inStream);
            }
            Sheet sheet = book.getSheetAt(0);
            int totalRows = sheet.getPhysicalNumberOfRows() - 1;    // 总
        int totalRows = sheet.getLastRowNum() + 1;    // 总
            Long userId = getUserId();
            Long hostId = getHostId();
            Long deptId = getDeptId();
            Date now = new Date();
        DataFormatter dataFormatter = new DataFormatter();
            for (int i = 2; i < totalRows; i++) {
                Cstmr cstmr = new Cstmr();
                Row row = sheet.getRow(i);
                // 客户代号
                String uuid = row.getCell(0).getStringCellValue();
            String uuid = dataFormatter.formatCellValue(row.getCell(0));
                if (!Cools.isEmpty(uuid)) {
                    if (cstmrService.selectByUuid(hostId, uuid) != null) {
                        throw new CoolException(uuid + "客户代号已存在，请重新导入");
@@ -216,13 +218,13 @@
                    cstmr.setUuid(cstmrService.getUuid(hostId));
                }
                // 客户代号
                String name = row.getCell(1).getStringCellValue();
            String name = dataFormatter.formatCellValue(row.getCell(1));
                if (Cools.isEmpty(name)) {
                    throw new CoolException("第" + i + "行客户名称不能为空，请重新导入");
                }
                cstmr.setName(name);
                // 客户类别
                String type = row.getCell(2).getStringCellValue();
            String type = dataFormatter.formatCellValue(row.getCell(2));
                if (Cools.isEmpty(type)) {
                    throw new CoolException("第" + i + "行客户类别不能为空，请重新导入");
                }
@@ -231,39 +233,39 @@
                    throw new CoolException("第" + i + "行客户类别不合法，请重新导入");
                }
                cstmr.setCstmrType(cstmrType.getId());
                // 客户类别
                cstmr.setRela(row.getCell(3).getStringCellValue());
            // 客户关系
            cstmr.setRela(dataFormatter.formatCellValue(row.getCell(3)));
                // 电话
                cstmr.setTel(row.getCell(4).getStringCellValue());
            cstmr.setTel(dataFormatter.formatCellValue(row.getCell(4)));
                // 客户联系人
                cstmr.setContacts(row.getCell(5).getStringCellValue());
            cstmr.setContacts(dataFormatter.formatCellValue(row.getCell(5)));
                // 备注
                cstmr.setRemarks(row.getCell(6).getStringCellValue());
            cstmr.setRemarks(dataFormatter.formatCellValue(row.getCell(6)));
                // 省
                String province = row.getCell(7).getStringCellValue();
            String province = dataFormatter.formatCellValue(row.getCell(7));
                Dic dicProvince = dicService.selectByName(province);
                if (Cools.isEmpty(dicProvince)) {
                    throw new CoolException("第" + i + "行省名不合法，请重新导入");
                }
                cstmr.setProvince(dicProvince.getCode());
                // 市
                String city = row.getCell(8).getStringCellValue();
            String city = dataFormatter.formatCellValue(row.getCell(8));
                Dic dicCity = dicService.selectByName(city);
                if (Cools.isEmpty(dicCity)) {
                    throw new CoolException("第" + i + "行市名不合法，请重新导入");
                }
                cstmr.setCity(dicCity.getCode());
                // 区
                String district = row.getCell(9).getStringCellValue();
            String district = dataFormatter.formatCellValue(row.getCell(9));
                Dic dicDistrict = dicService.selectByName(district);
                if (Cools.isEmpty(dicDistrict)) {
                    throw new CoolException("第" + i + "行县名不合法，请重新导入");
                }
                cstmr.setDistrict(dicDistrict.getCode());
                // 详细地址
                cstmr.setAddr(row.getCell(10).getStringCellValue());
            cstmr.setAddr(dataFormatter.formatCellValue(row.getCell(10)));
                // 区分
                cstmr.setType0(row.getCell(11).getStringCellValue());
            cstmr.setType0(dataFormatter.formatCellValue(row.getCell(11)));
                cstmr.setHostId(hostId);
                cstmr.setDeptId(deptId);
                cstmr.setUserId(userId);
@@ -276,10 +278,6 @@
                    throw new CoolException("保存失败，请重新导入");
                }
            }
        }  catch (Exception e) {
            e.printStackTrace();
        }

        return R.ok();
    }