From d0b19298e28a9b8b50c778704b77160f17e73950 Mon Sep 17 00:00:00 2001
From: jialh <1972868360@qq.com>
Date: 星期五, 17 四月 2026 18:20:38 +0800
Subject: [PATCH] 水电话费

---
 service-api/src/main/java/com/java110/api/importData/adapt/ImportOwnerCarV2DataCleaningAdapt.java |   32 ++++++++++++++++++++++----------
 1 files changed, 22 insertions(+), 10 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 18c67ba..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;
@@ -53,13 +54,16 @@
         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[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) + "琛屽皬鍖虹紪鐮佸拰灏忓尯鍚嶇О蹇呭~鍏朵竴");
             }
@@ -71,12 +75,12 @@
 //            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[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();
@@ -112,13 +116,16 @@
         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[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) + "琛屽皬鍖虹紪鐮佸拰灏忓尯鍚嶇О蹇呭~鍏朵竴");
             }
@@ -130,12 +137,12 @@
 //            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[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();
@@ -157,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