#

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,104 +183,101 @@
    @ManagerAuth(memo = "甲方单位Excel导入")
    @Transactional
    public R cstmrExcelImport(MultipartFile file) throws IOException {
        try (InputStream inStream = file.getInputStream()) {
            String fileMime = file.getContentType();
            int excelVersion = 2007;
            if ("application/vnd.ms-excel".equals(fileMime)) {
                excelVersion = 2003;
            }
            Workbook book = null;
            if (excelVersion == 2003) {
                book = new HSSFWorkbook(inStream);
            }
            else {  // å½“ excel æ˜¯ 2007 æ—¶
                book = new XSSFWorkbook(inStream);
            }
            Sheet sheet = book.getSheetAt(0);
            int totalRows = sheet.getPhysicalNumberOfRows() - 1;    // æ€»
            Long userId = getUserId();
            Long hostId = getHostId();
            Long deptId = getDeptId();
            Date now = new Date();
            for (int i = 2; i < totalRows; i++) {
                Cstmr cstmr = new Cstmr();
                Row row = sheet.getRow(i);
                // å®¢æˆ·ä»£å·
                String uuid = row.getCell(0).getStringCellValue();
                if (!Cools.isEmpty(uuid)) {
                    if (cstmrService.selectByUuid(hostId, uuid) != null) {
                        throw new CoolException(uuid + "客户代号已存在，请重新导入");
                    } else {
                        cstmr.setUuid(uuid);
                    }
                } else {
                    cstmr.setUuid(cstmrService.getUuid(hostId));
                }
                // å®¢æˆ·ä»£å·
                String name = row.getCell(1).getStringCellValue();
                if (Cools.isEmpty(name)) {
                    throw new CoolException("第" + i + "行客户名称不能为空，请重新导入");
                }
                cstmr.setName(name);
                // å®¢æˆ·ç±»åˆ«
                String type = row.getCell(2).getStringCellValue();
                if (Cools.isEmpty(type)) {
                    throw new CoolException("第" + i + "行客户类别不能为空，请重新导入");
                }
                CstmrType cstmrType = cstmrTypeService.selectByName(hostId, type);
                if (null == cstmrType) {
                    throw new CoolException("第" + i + "行客户类别不合法，请重新导入");
                }
                cstmr.setCstmrType(cstmrType.getId());
                // å®¢æˆ·ç±»åˆ«
                cstmr.setRela(row.getCell(3).getStringCellValue());
                // ç”µè¯
                cstmr.setTel(row.getCell(4).getStringCellValue());
                // å®¢æˆ·è”系人
                cstmr.setContacts(row.getCell(5).getStringCellValue());
                // å¤‡æ³¨
                cstmr.setRemarks(row.getCell(6).getStringCellValue());
                // çœ
                String province = row.getCell(7).getStringCellValue();
                Dic dicProvince = dicService.selectByName(province);
                if (Cools.isEmpty(dicProvince)) {
                    throw new CoolException("第" + i + "行省名不合法，请重新导入");
                }
                cstmr.setProvince(dicProvince.getCode());
                // å¸‚
                String city = row.getCell(8).getStringCellValue();
                Dic dicCity = dicService.selectByName(city);
                if (Cools.isEmpty(dicCity)) {
                    throw new CoolException("第" + i + "行市名不合法，请重新导入");
                }
                cstmr.setCity(dicCity.getCode());
                // åŒº
                String district = row.getCell(9).getStringCellValue();
                Dic dicDistrict = dicService.selectByName(district);
                if (Cools.isEmpty(dicDistrict)) {
                    throw new CoolException("第" + i + "行县名不合法，请重新导入");
                }
                cstmr.setDistrict(dicDistrict.getCode());
                // è¯¦ç»†åœ°å€
                cstmr.setAddr(row.getCell(10).getStringCellValue());
                // åŒºåˆ†
                cstmr.setType0(row.getCell(11).getStringCellValue());
                cstmr.setHostId(hostId);
                cstmr.setDeptId(deptId);
                cstmr.setUserId(userId);
                cstmr.setStatus(1);
                cstmr.setCreateBy(userId);
                cstmr.setCreateTime(now);
                cstmr.setUpdateBy(userId);
                cstmr.setUpdateTime(now);
                if (!cstmrService.insert(cstmr)) {
                    throw new CoolException("保存失败，请重新导入");
                }
            }
        }  catch (Exception e) {
            e.printStackTrace();
        InputStream inStream = file.getInputStream();
        String fileMime = file.getContentType();
        int excelVersion = 2007;
        if ("application/vnd.ms-excel".equals(fileMime)) {
            excelVersion = 2003;
        }

        Workbook book = null;
        if (excelVersion == 2003) {
            book = new HSSFWorkbook(inStream);
        }
        else {  // å½“ excel æ˜¯ 2007 æ—¶
            book = new XSSFWorkbook(inStream);
        }
        Sheet sheet = book.getSheetAt(0);
        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 = dataFormatter.formatCellValue(row.getCell(0));
            if (!Cools.isEmpty(uuid)) {
                if (cstmrService.selectByUuid(hostId, uuid) != null) {
                    throw new CoolException(uuid + "客户代号已存在，请重新导入");
                } else {
                    cstmr.setUuid(uuid);
                }
            } else {
                cstmr.setUuid(cstmrService.getUuid(hostId));
            }
            // å®¢æˆ·ä»£å·
            String name = dataFormatter.formatCellValue(row.getCell(1));
            if (Cools.isEmpty(name)) {
                throw new CoolException("第" + i + "行客户名称不能为空，请重新导入");
            }
            cstmr.setName(name);
            // å®¢æˆ·ç±»åˆ«
            String type = dataFormatter.formatCellValue(row.getCell(2));
            if (Cools.isEmpty(type)) {
                throw new CoolException("第" + i + "行客户类别不能为空，请重新导入");
            }
            CstmrType cstmrType = cstmrTypeService.selectByName(hostId, type);
            if (null == cstmrType) {
                throw new CoolException("第" + i + "行客户类别不合法，请重新导入");
            }
            cstmr.setCstmrType(cstmrType.getId());
            // å®¢æˆ·å…³ç³»
            cstmr.setRela(dataFormatter.formatCellValue(row.getCell(3)));
            // ç”µè¯
            cstmr.setTel(dataFormatter.formatCellValue(row.getCell(4)));
            // å®¢æˆ·è”系人
            cstmr.setContacts(dataFormatter.formatCellValue(row.getCell(5)));
            // å¤‡æ³¨
            cstmr.setRemarks(dataFormatter.formatCellValue(row.getCell(6)));
            // çœ
            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 = dataFormatter.formatCellValue(row.getCell(8));
            Dic dicCity = dicService.selectByName(city);
            if (Cools.isEmpty(dicCity)) {
                throw new CoolException("第" + i + "行市名不合法，请重新导入");
            }
            cstmr.setCity(dicCity.getCode());
            // åŒº
            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(dataFormatter.formatCellValue(row.getCell(10)));
            // åŒºåˆ†
            cstmr.setType0(dataFormatter.formatCellValue(row.getCell(11)));
            cstmr.setHostId(hostId);
            cstmr.setDeptId(deptId);
            cstmr.setUserId(userId);
            cstmr.setStatus(1);
            cstmr.setCreateBy(userId);
            cstmr.setCreateTime(now);
            cstmr.setUpdateBy(userId);
            cstmr.setUpdateTime(now);
            if (!cstmrService.insert(cstmr)) {
                throw new CoolException("保存失败，请重新导入");
            }
        }
        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});
}