#

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();
    }


 src/main/webapp/mould/¼×·½µ¥Î»µ¼ÈëÄ£°å.xls

Binary files differ

 src/main/webapp/static/js/cstmr/cstmr.js

@@ -415,12 +415,14 @@
    let res = JSON.parse(evt.target.responseText);
    if(res.code === 200) {
        layer.msg(res.msg, {icon: 1});
        tableIns.refresh();
        tableReload();
    } else {
        layer.msg(res.msg, {icon: 2});
        alert(res.msg);
        // layer.msg(res.msg, {icon: 2});
    }
}
function uploadFailed(evt) {
    let res = JSON.parse(evt.target.responseText);
    layer.msg(res.msg, {icon: 2});
    alert(res.msg);
    // layer.msg(res.msg, {icon: 2});
}