#

luxiaotao1123

2022-09-18 42fb81ed45edd0a2106f12e8aa6ce1c77babe18b

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

@@ -15,6 +15,8 @@
import com.zy.crm.manager.entity.CstmrType;
import com.zy.crm.manager.service.CstmrService;
import com.zy.crm.manager.service.CstmrTypeService;
import com.zy.crm.system.entity.Dic;
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.Row;
@@ -39,6 +41,8 @@
    private CstmrService cstmrService;
    @Autowired
    private CstmrTypeService cstmrTypeService;
    @Autowired
    private DicService dicService;

    @RequestMapping(value = "/cstmr/{id}/auth")
    @ManagerAuth
@@ -236,11 +240,26 @@
                // 备注
                cstmr.setRemarks(row.getCell(6).getStringCellValue());
                // 省
                cstmr.setProvince(row.getCell(7).getStringCellValue());
                String province = row.getCell(7).getStringCellValue();
                Dic dicProvince = dicService.selectByName(province);
                if (Cools.isEmpty(dicProvince)) {
                    throw new CoolException("第" + i + "行省名不合法，请重新导入");
                }
                cstmr.setProvince(dicProvince.getCode());
                // 市
                cstmr.setCity(row.getCell(8).getStringCellValue());
                String city = row.getCell(8).getStringCellValue();
                Dic dicCity = dicService.selectByName(city);
                if (Cools.isEmpty(dicCity)) {
                    throw new CoolException("第" + i + "行市名不合法，请重新导入");
                }
                cstmr.setCity(dicCity.getCode());
                // 区
                cstmr.setDistrict(row.getCell(9).getStringCellValue());
                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());
                // 区分