From b88a288f4f787b509463678e3cd9ccfa3f37014b Mon Sep 17 00:00:00 2001
From: chengf <cgf12138@163.com>
Date: 星期三, 11 三月 2026 12:01:05 +0800
Subject: [PATCH] 导入测试
---
service-api/src/main/java/com/java110/api/importData/adapt/ImportOwnerCarV2DataCleaningAdapt.java | 69 +++++++++++++++++++++++-----------
1 files changed, 46 insertions(+), 23 deletions(-)
diff --git a/service-api/src/main/java/com/java110/api/importData/adapt/ImportOwnerCarV2DataCleaningAdapt.java b/service-api/src/main/java/com/java110/api/importData/adapt/ImportOwnerCarV2DataCleaningAdapt.java
index 9fdc277..28f51be 100644
--- a/service-api/src/main/java/com/java110/api/importData/adapt/ImportOwnerCarV2DataCleaningAdapt.java
+++ b/service-api/src/main/java/com/java110/api/importData/adapt/ImportOwnerCarV2DataCleaningAdapt.java
@@ -3,6 +3,7 @@
import com.alibaba.fastjson.JSONObject;
import com.java110.api.importData.DefaultImportDataAdapt;
import com.java110.api.importData.IImportDataCleaningAdapt;
+import com.java110.dto.importData.Vtil;
import com.java110.dto.owner.OwnerCarDto;
import com.java110.dto.system.ComponentValidateResult;
import com.java110.intf.user.IOwnerV1InnerServiceSMO;
@@ -36,6 +37,9 @@
return ownerCars;
}
+ public String defaultValue(Object o) {
+ return o == null ? "" : o.toString();
+ }
/**
* 鑾峰彇涓氫富杞﹁締淇℃伅
@@ -45,20 +49,25 @@
*/
private void getOwnerCars(Workbook workbook, List<OwnerCarDto> ownerCars, ComponentValidateResult result) throws ParseException {
Sheet sheet = null;
- sheet = ImportExcelUtils.getSheet(workbook, "鍦伴潰鍋滆溅璐� 瀵煎叆鏂版ā鏉� ");
+ sheet = ImportExcelUtils.getSheet(workbook, "鍦伴潰鍋滆溅璐� 瀵煎叆鏂版ā鏉�");
List<Object[]> oList = ImportExcelUtils.listFromSheet(sheet);
OwnerCarDto importOwnerCar = null;
for (int osIndex = 0; osIndex < oList.size(); osIndex++) {
Object[] os = oList.get(osIndex);
- if (osIndex <= 6) { // 绗竴琛屾槸 澶撮儴淇℃伅 鐩存帴璺宠繃
+ if (osIndex < 3) { // 绗竴琛屾槸 澶撮儴淇℃伅 鐩存帴璺宠繃
continue;
}
if (StringUtil.isNullOrNone(os[0])) {
continue;
}
- Assert.hasValue(os[8], (osIndex + 1) + "杞︾墝鍙蜂笉鑳戒负绌�");
- Assert.hasValue(os[1], (osIndex + 1) + "椤圭洰缂栫爜涓嶈兘涓虹┖");
- Assert.hasValue(os[10], (osIndex + 1) + "涓氫富涓嶈兘涓虹┖");
+// Assert.hasValue(os[8], (osIndex + 1) + "琛岃溅鐗屽彿涓嶈兘涓虹┖");
+ if (os[8] == null || os[8].equals("")) {
+ os[8] = "绌�";
+ }
+ if (defaultValue(os[1]).isEmpty() && defaultValue(os[2]).isEmpty()) {
+ throw new IllegalArgumentException((osIndex + 1) + "琛屽皬鍖虹紪鐮佸拰灏忓尯鍚嶇О蹇呭～鍏朵竴");
+ }
+// Assert.hasValue(os[10], (osIndex + 1) + "琛屼笟涓讳笉鑳戒负绌�");
// Assert.hasValue(os[2], (osIndex + 1) + "鎵嬫満鍙蜂笉鑳戒负绌�");
// Assert.hasValue(os[3], (osIndex + 1) + "杞﹁締鍝佺墝涓嶈兘涓虹┖");
// Assert.hasValue(os[4], (osIndex + 1) + "杞﹁締绫诲瀷涓嶈兘涓虹┖");
@@ -66,17 +75,17 @@
// Assert.hasValue(os[6], (osIndex + 1) + "棰滆壊涓嶈兘涓虹┖");
// Assert.hasValue(os[7], (osIndex + 1) + "鍋滆溅鍦轰笉鑳戒负绌�");
// Assert.hasValue(os[8], (osIndex + 1) + "杞︿綅涓嶈兘涓虹┖");
- Assert.hasValue(os[14], (osIndex + 1) + "璧风鏃堕棿涓嶈兘涓虹┖");
- Assert.hasValue(os[15], (osIndex + 1) + "鎴鏃堕棿涓嶈兘涓虹┖");
- Assert.hasValue(os[12], (osIndex + 1) + "鍋滆溅绫诲瀷涓嶈兘涓虹┖");
+// Assert.hasValue(os[14], (osIndex + 1) + "琛岃捣绉熸椂闂翠笉鑳戒负绌�");
+// Assert.hasValue(os[15], (osIndex + 1) + "鎴鏃堕棿涓嶈兘涓虹┖");
+ Assert.hasValue(os[12], (osIndex + 1) + "琛屽仠杞︾被鍨嬩笉鑳戒负绌�");
// Assert.hasValue(os[11], (osIndex + 1) + "鍋滆溅鍦虹被鍨嬩笉鑳戒负绌�");
- String startTime = os.length >= 14 && os[14] != null ? excelDoubleToDate(os[14].toString()):"";
- String endTime = os.length >= 15 && os[15] != null ? excelDoubleToDate(os[15].toString()):"";
+ String startTime = os.length > 14 && os[14] != null ? Vtil.defaultValueToDate(os[14], "start") : null;
+ String endTime = os.length > 15 && os[15] != null ? Vtil.defaultValueToDate(os[15], "end") : null;
// Assert.isDate(startTime, DateUtil.DATE_FORMATE_STRING_B, (osIndex + 1) + "琛屽紑濮嬫椂闂存牸寮忛敊璇� 璇峰～鍐橸YYY-MM-DD鏂囨湰鏍煎紡");
// Assert.isDate(endTime, DateUtil.DATE_FORMATE_STRING_B, (osIndex + 1) + "琛岀粨鏉熸椂闂存牸寮忛敊璇� 璇峰～鍐橸YYY-MM-DD鏂囨湰鏍煎紡");
importOwnerCar = new OwnerCarDto();
- importOwnerCar.setCarNum(os[8].toString().trim());
- importOwnerCar.setOwnerName(os[10].toString().trim());
+ importOwnerCar.setCarNum(defaultValue(os[8]).trim());
+ importOwnerCar.setOwnerName(defaultValue(os[10]).trim());
importOwnerCar.setLink(os.length <= 11 || os[11] == null ? "" : os[11].toString().trim());
// importOwnerCar.setCarBrand(os.length <= 3 || os[3] == null ? "" : os[3].toString().trim());
importOwnerCar.setCarType("9901");
@@ -94,6 +103,10 @@
importOwnerCar.setCommunityId(result.getCommunityId());
importOwnerCar.setUserId(result.getUserId());
importOwnerCar.setOtherItem(os);
+ importOwnerCar.setRoadName(defaultValue(os[3]));
+ importOwnerCar.setFloorNum(defaultValue(os[4]));
+ importOwnerCar.setUnitNum(defaultValue(os[5]));
+ importOwnerCar.setRoomNum(defaultValue(os[6]));
ownerCars.add(importOwnerCar);
}
@@ -103,15 +116,20 @@
importOwnerCar = null;
for (int osIndex = 0; osIndex < oList.size(); osIndex++) {
Object[] os = oList.get(osIndex);
- if (osIndex <= 6) { // 绗竴琛屾槸 澶撮儴淇℃伅 鐩存帴璺宠繃
+ if (osIndex < 3) { // 绗竴琛屾槸 澶撮儴淇℃伅 鐩存帴璺宠繃
continue;
}
if (StringUtil.isNullOrNone(os[0])) {
continue;
}
- Assert.hasValue(os[8], (osIndex + 1) + "杞︾墝鍙蜂笉鑳戒负绌�");
- Assert.hasValue(os[1], (osIndex + 1) + "椤圭洰缂栫爜涓嶈兘涓虹┖");
- Assert.hasValue(os[10], (osIndex + 1) + "涓氫富涓嶈兘涓虹┖");
+// Assert.hasValue(os[8], (osIndex + 1) + "琛岃溅鐗屽彿涓嶈兘涓虹┖");
+ if (os[8] == null || os[8].equals("")) {
+ os[8] = "绌�";
+ }
+ if (defaultValue(os[1]).isEmpty() && defaultValue(os[2]).isEmpty()) {
+ throw new IllegalArgumentException((osIndex + 1) + "琛屽皬鍖虹紪鐮佸拰灏忓尯鍚嶇О蹇呭～鍏朵竴");
+ }
+// Assert.hasValue(os[10], (osIndex + 1) + "琛屼笟涓讳笉鑳戒负绌�");
// Assert.hasValue(os[2], (osIndex + 1) + "鎵嬫満鍙蜂笉鑳戒负绌�");
// Assert.hasValue(os[3], (osIndex + 1) + "杞﹁締鍝佺墝涓嶈兘涓虹┖");
// Assert.hasValue(os[4], (osIndex + 1) + "杞﹁締绫诲瀷涓嶈兘涓虹┖");
@@ -119,17 +137,17 @@
// Assert.hasValue(os[6], (osIndex + 1) + "棰滆壊涓嶈兘涓虹┖");
// Assert.hasValue(os[7], (osIndex + 1) + "鍋滆溅鍦轰笉鑳戒负绌�");
// Assert.hasValue(os[8], (osIndex + 1) + "杞︿綅涓嶈兘涓虹┖");
- Assert.hasValue(os[14], (osIndex + 1) + "璧风鏃堕棿涓嶈兘涓虹┖");
- Assert.hasValue(os[15], (osIndex + 1) + "鎴鏃堕棿涓嶈兘涓虹┖");
- Assert.hasValue(os[12], (osIndex + 1) + "鍋滆溅绫诲瀷涓嶈兘涓虹┖");
+// Assert.hasValue(os[14], (osIndex + 1) + "琛岃捣绉熸椂闂翠笉鑳戒负绌�");
+// Assert.hasValue(os[15], (osIndex + 1) + "鎴鏃堕棿涓嶈兘涓虹┖");
+ Assert.hasValue(os[12], (osIndex + 1) + "琛屽仠杞︾被鍨嬩笉鑳戒负绌�");
// Assert.hasValue(os[11], (osIndex + 1) + "鍋滆溅鍦虹被鍨嬩笉鑳戒负绌�");
- String startTime = os.length >= 14 && os[14] != null ? excelDoubleToDate(os[14].toString()):"";
- String endTime = os.length >= 15 && os[15] != null ? excelDoubleToDate(os[15].toString()):"";
+ String startTime = os.length > 14 && os[14] != null ? Vtil.defaultValueToDate(os[14], "start") : null;
+ String endTime = os.length > 15 && os[15] != null ? Vtil.defaultValueToDate(os[15], "end") : null;
// Assert.isDate(startTime, DateUtil.DATE_FORMATE_STRING_B, (osIndex + 1) + "琛屽紑濮嬫椂闂存牸寮忛敊璇� 璇峰～鍐橸YYY-MM-DD鏂囨湰鏍煎紡");
// Assert.isDate(endTime, DateUtil.DATE_FORMATE_STRING_B, (osIndex + 1) + "琛岀粨鏉熸椂闂存牸寮忛敊璇� 璇峰～鍐橸YYY-MM-DD鏂囨湰鏍煎紡");
importOwnerCar = new OwnerCarDto();
- importOwnerCar.setCarNum(os[8].toString().trim());
- importOwnerCar.setOwnerName(os[10].toString().trim());
+ importOwnerCar.setCarNum(defaultValue(os[8]).trim());
+ importOwnerCar.setOwnerName(defaultValue(os[10]).trim());
importOwnerCar.setLink(os.length <= 11 || os[11] == null ? "" : os[11].toString().trim());
// importOwnerCar.setCarBrand(os.length <= 3 || os[3] == null ? "" : os[3].toString().trim());
importOwnerCar.setCarType("9901");
@@ -146,6 +164,11 @@
importOwnerCar.setCommunityId(result.getCommunityId());
importOwnerCar.setUserId(result.getUserId());
importOwnerCar.setOtherItem(os);
+ importOwnerCar.setRoadName(defaultValue(os[3]));
+ importOwnerCar.setFloorNum(defaultValue(os[4]));
+ importOwnerCar.setUnitNum(defaultValue(os[5]));
+ importOwnerCar.setRoomNum(defaultValue(os[6]));
+ importOwnerCar.setParkingType(defaultValue(os[12]));
ownerCars.add(importOwnerCar);
}
}
--
Gitblit v1.8.0