From e6a2b78ffe066d2f32a878df5eb6588d0e8ebff2 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期日, 18 九月 2022 20:11:49 +0800
Subject: [PATCH] #
---
src/main/java/com/zy/crm/manager/controller/CstmrController.java | 71 ++++++++++++++++++++++++++++++++++-
1 files changed, 68 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/zy/crm/manager/controller/CstmrController.java b/src/main/java/com/zy/crm/manager/controller/CstmrController.java
index f86f7a7..b56f090 100644
--- a/src/main/java/com/zy/crm/manager/controller/CstmrController.java
+++ b/src/main/java/com/zy/crm/manager/controller/CstmrController.java
@@ -12,7 +12,11 @@
import com.core.exception.CoolException;
import com.zy.crm.common.web.BaseController;
import com.zy.crm.manager.entity.Cstmr;
+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;
@@ -35,6 +39,10 @@
@Autowired
private CstmrService cstmrService;
+ @Autowired
+ private CstmrTypeService cstmrTypeService;
+ @Autowired
+ private DicService dicService;
@RequestMapping(value = "/cstmr/{id}/auth")
@ManagerAuth
@@ -195,10 +203,67 @@
Date now = new Date();
for (int i = 2; i < totalRows; i++) {
Cstmr cstmr = new Cstmr();
-
Row row = sheet.getRow(i);
- System.out.println(row.getCell(0).getStringCellValue());
-
+ // 瀹㈡埛浠ｅ彿
+ 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);
--
Gitblit v1.9.1