From 797f03be4fe1bd1f83072f5ca25909f4d2bd4b56 Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期一, 12 十月 2026 13:18:53 +0800
Subject: [PATCH] fix(城市客运): 公交/出租导入改按表头名定位列，兼容同事版少列模板 待验收
---
HANDOFF.md | 8 ++
traffic-audit-server/src/main/java/com/trafficaudit/dataimport/service/DataImportService.java | 209 ++++++++++++++++++++++++++++++---------------------
2 files changed, 131 insertions(+), 86 deletions(-)
diff --git a/HANDOFF.md b/HANDOFF.md
index d007c6b..1f0b58d 100644
--- a/HANDOFF.md
+++ b/HANDOFF.md
@@ -29,6 +29,14 @@
- 鍏氦锛�8 鏈� 12315.37銆佺疮璁� 110776.34 鉁撱��
- **閬楃暀**锛氣憼 鎵╁垪浜х墿琚噸鍐欑殑鍏紡鏃犵紦瀛樺�硷紙寤鸿琛�"鏁存湰閲嶇畻鍐欑紦瀛�"锛夛紱鈶� `涓彛寰勬槑缁哷 琛ㄥご琛岃瘑鍒繑鍥� `[2,4]` 寰呮牳鏌ワ紱鈶� 鈶¤〃锛堝叏鍙ｅ緞锛�9 鏈堟湭瀵煎叆鍓嶏紝"鍏ㄥ彛寰�"琛屾樉绀虹瓑浜庤涓婏紙鍏紡 =瑙勪笂+瑙勪笅銆佽涓嬩负绌猴級锛屼綋妫�宸叉彁绀猴紝瀵兼暟鎹悗鑷姩姝ｅ父銆�
- **鎶ュ憡锛堟湰鍦般�佷笉鍏ュ簱锛�**锛歚docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_鎵╁垪鍏紡鍏嬮殕淇涓�9鏈堥獙璇乢2026-10-12.md`銆傜姸鎬侊細**銆愬緟楠屾敹銆�**銆�
+### 10-12锛�5锛夛細淇��9 鏈堝叕浜�/鍑虹鏈堟姤瀵间笉杩涘幓銆嶁�斺�斿鍏ユ敼鎸夎〃澶村悕瀹氫綅鍒椼�愬緟楠屾敹銆�
+
+- **鐜拌薄**锛氱敤鎴峰鍏� 9 鏈堝叕浜�/鍑虹鏈堟姤鍙嶅澶辫触锛沗import_batch` 鏃犺褰曘�乣city_bus_monthly`/`city_taxi_monthly` 鏃� 2026-09 琛� 鈫� **瑙ｆ瀽闃舵鍗虫姏閿�**锛堟病杩涘啓搴擄級銆�
+- **鏍瑰洜锛堝疄娴嬩笁浠芥枃浠讹級**锛�9 鏈堟ā鏉挎瘮 7 鏈�**灏戝垪瀵艰嚧鏁翠綋宸︾Щ**鈥斺�斿叕浜� 68鈫�**66** 鍒楋紙灏� `缁熶竴绀句細淇＄敤浠ｇ爜`銆乣濉姤鍗曚綅`锛岀 3 鍒楄捣宸︾Щ 2锛夛紱鍑虹 41鈫�**40** 鍒楋紙灏� `濉姤鍗曚綅`锛屽乏绉� 1锛夈�傚鍏ュ櫒鍘熸槸**鎸夊浐瀹氬垪鍙峰彇鍊� + 鍥哄畾鍒椾綅鏍￠獙** 鈫� 鏍￠獙鐩存帴鎶涖�屼笌鏂囦欢鍐呭涓嶇銆嶃�傚繀闇�鍒楁寜鍚嶉兘鍦紝鏄垪浣嶄笉鍖归厤锛涗笖鍙栧�间篃鎸夊浐瀹氬垪鍙凤紝涓嶆敼浼氭暣浣撹閿欏垪銆�
+- **鏀瑰姩锛堟寜 I4 鍙ｅ緞鍏煎妯℃澘宸紓锛�**锛氭柊澧� `colByName(hdr, fallback, name[, occurrence])`锛堟寜琛ㄥご鍚嶅彇鍒楋紝鏈懡涓洖閫�鍘熷浐瀹氬垪鍙凤級涓� `requireHeaderColsByName(...)`锛堝彧鏍￠獙蹇呴渶鍒楁寜鍚嶅瓨鍦ㄣ�佷笉鏍￠獙鍒椾綅锛夛紱`importCityBus`/`importCityTaxi` 鎵�鏈夊瓧娈垫敼涓烘寜鍚嶅彇鍊硷紱鍏氦閲嶅琛ㄥご銆屽叾涓細鍩庡競鍐呫�嶏紙2 娆★級鐢ㄥ嚭鐜板簭鍙峰尯鍒嗭紙`stopCity`=1銆乣passengerCity`=2锛夈�傛槧灏勫彇鑷疄娴嬭〃澶达紙鍏氦 42 瀛楁銆佸嚭绉� 37 瀛楁鍏ㄩ儴鍛戒腑锛夈��
+- **楠岃瘉**锛氬垪浣嶅樊寮傚凡瀹氫綅锛涘悕绉版槧灏勫畬澶囷紙42/42銆�37/37锛夛紱鏍￠獙鏀惧浠嶄繚鐣�"鐪熺己鍒�"鐨勮礋鍚戞嫤鎴紱缂栬瘧閫氳繃銆佸悗绔凡閲嶅惎锛圥ID 40592锛�13:17:38锛夈��
+- **寰呭姙**锛�**璇风敤鎴峰湪椤甸潰閲嶅杩欎袱涓� 9 鏈堟枃浠�**锛堝姪鎵嬩笉浠ｅ锛夛紱瀵煎叆鍚庡姪鎵嬪仛鍙鎶芥煡锛堣鏁�/甯傚窞/涓庢簮鏂囦欢閫愬垪瀵归綈锛屽挨鍏�"鍩庡競鍐�/鍩庨檯鍩庝埂"鍙ｅ緞瀛楁锛夈��
+- **鎶ュ憡锛堟湰鍦般�佷笉鍏ュ簱锛�**锛歚docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_鍏氦鍑虹瀵煎叆鎸夎〃澶村悕瀹氫綅_2026-10-12.md`銆傜姸鎬侊細**銆愬緟楠屾敹銆�**銆�
## 鏈�鏂帮紙2026-10-12锛寊yj 绾匡級
### 10-12锛氭墿鍒楀櫒琛ャ�屾爣棰樻寜姣嶇増鏈熸閲嶅啓銆�+ 淇 8 鏈堟瘝鐗堟爣棰樸�愬緟楠屾敹銆�
diff --git a/traffic-audit-server/src/main/java/com/trafficaudit/dataimport/service/DataImportService.java b/traffic-audit-server/src/main/java/com/trafficaudit/dataimport/service/DataImportService.java
index da66293..23d340e 100644
--- a/traffic-audit-server/src/main/java/com/trafficaudit/dataimport/service/DataImportService.java
+++ b/traffic-audit-server/src/main/java/com/trafficaudit/dataimport/service/DataImportService.java
@@ -1808,6 +1808,43 @@
}
}
+ /** 鍙牎楠屻�屽繀闇�鍒楁寜鍚嶅瓨鍦ㄣ�嶏紙涓嶆牎楠屽垪浣嶏級锛氱敤浜庡吋瀹瑰悓浜嬬増妯℃澘鐨勫垪浣嶅樊寮� */
+ private void requireHeaderColsByName(Sheet sheet, String typeLabel, String templateHint, String[] keywords) {
+ Row header = sheet == null ? null : sheet.getRow(0);
+ if (header == null) {
+ throw new RuntimeException("鎵�閫夋暟鎹被鍨嬨��" + typeLabel + "銆戞枃浠惰〃澶寸己澶憋紝璇蜂娇鐢ㄧ郴缁熸ā鏉裤��" + templateHint + "銆嬫暣鐞嗗悗鍐嶅鍏�");
+ }
+ List<String> missing = new ArrayList<>();
+ for (String keyword : keywords) {
+ if (findColByKeywords(header, keyword) < 0) missing.add(keyword);
+ }
+ if (!missing.isEmpty()) {
+ throw new RuntimeException("鎵�閫夋暟鎹被鍨嬨��" + typeLabel + "銆戜笌鏂囦欢鍐呭涓嶇锛氳〃澶寸己灏戝繀闇�鍒椼��"
+ + String.join("銆戙��", missing) + "銆戯紝璇风‘璁ゆ槸鍚﹂�夐敊浜嗘暟鎹被鍨嬶紙妯℃澘锛�" + templateHint + "锛�");
+ }
+ }
+
+ /** 琛ㄥご鍚� 鈫� 鍒楀彿锛堥娆″嚭鐜帮級锛涙湭鍛戒腑鏃跺洖閫� fallback锛屼繚鎸佸鏃фā鏉垮吋瀹� */
+ private int colByName(Row header, int fallback, String name) {
+ return colByName(header, fallback, name, 1);
+ }
+
+ /** 琛ㄥご鍚� 鈫� 鍒楀彿锛堢 occurrence 娆″嚭鐜帮級锛涙湭鍛戒腑鏃跺洖閫� fallback */
+ private int colByName(Row header, int fallback, String name, int occurrence) {
+ if (header == null) return fallback;
+ int hit = 0;
+ for (int c = 0; c <= header.getLastCellNum(); c++) {
+ Cell cell = header.getCell(c);
+ if (cell == null) continue;
+ String v = FORMATTER.formatCellValue(cell).trim();
+ if (v.contains(name)) {
+ hit++;
+ if (hit == occurrence) return c;
+ }
+ }
+ return fallback;
+ }
+
/** 鎸夎〃澶村叧閿瓧瀹氫綅鍒楀彿锛氫粠绗� 1 鍒楀悜鍙虫壂锛屽懡涓换涓�鍏抽敭瀛楀嵆杩斿洖璇ュ垪锛涙湭鍛戒腑杩斿洖 -1 */
private int findColByKeywords(Row header, String... keywords) {
if (header == null) return -1;
@@ -3071,59 +3108,59 @@
List<CityBusRow> rows = new ArrayList<>();
try (Workbook wb = WorkbookFactory.create(file.getInputStream())) {
Sheet sheet = wb.getSheetAt(0);
- requireHeaderLayout(sheet, "鍩庡競鍏氦", "妯℃澘_浜や紒缁烾203琛╛鍩庡競鍏叡浜ら�氭湀搴﹁繍钀ユ儏鍐碉紙2026骞�7鏈堬級.xls",
- CITY_BUS_HEADER_COLS, CITY_BUS_HEADER_KEYWORDS);
+ Row hdr = sheet.getRow(0);
+ requireHeaderColsByName(sheet, "鍩庡競鍏氦", "妯℃澘_浜や紒缁烾203琛╛鍩庡競鍏叡浜ら�氭湀搴﹁繍钀ユ儏鍐碉紙2026骞�7鏈堬級.xls", CITY_BUS_HEADER_KEYWORDS);
for (int r = 1; r <= sheet.getLastRowNum(); r++) {
Row row = sheet.getRow(r);
if (row == null) continue;
- String name = getString(row, 2);
+ String name = getString(row, colByName(hdr, 2, "浼佷笟鍚嶇О"));
if (name == null || name.trim().isEmpty()) continue;
CityBusMonthly item = new CityBusMonthly();
item.setReportPeriod(period);
- item.setRegionCode(getString(row, 0));
- item.setCity(RegionUtil.cityByCode(getString(row, 0)));
- item.setEnterpriseCode(getString(row, 1));
+ item.setRegionCode(getString(row, colByName(hdr, 0, "鎵�灞炲湴鍖�")));
+ item.setCity(RegionUtil.cityByCode(getString(row, colByName(hdr, 0, "鎵�灞炲湴鍖�"))));
+ item.setEnterpriseCode(getString(row, colByName(hdr, 1, "浼佷笟浠ｇ爜")));
item.setEnterpriseName(name.trim());
- item.setOpVehicles(getDecimal(row, 5));
- item.setStopTotal(getDecimal(row, 6));
- item.setStopCity(getDecimal(row, 7));
- item.setPassengerVolume(getDecimal(row, 8));
- item.setPassengerCity(getDecimal(row, 9));
- item.setTurnover(getDecimal(row, 10));
- item.setTurnoverCity(getDecimal(row, 11));
- item.setRailPassengerVolume(getDecimal(row, 13));
- item.setRailTurnover(getDecimal(row, 14));
- item.setFerryPassengerVolume(getDecimal(row, 17));
- item.setFerryTurnover(getDecimal(row, 18));
- item.setAvgDistance(getDecimal(row, 19));
- item.setAvgDistanceCity(getDecimal(row, 20));
- item.setContactPerson(getString(row, 24));
- item.setContactPhone(getString(row, 25));
- item.setReportDate(getDateString(row, 26));
- item.setRateOpVehiclesMom(getDecimal(row, 29));
- item.setRatePassengerMom(getDecimal(row, 30));
- item.setRatePassengerCityMom(getDecimal(row, 31));
- item.setRateChengxiangMom(getDecimal(row, 32));
- item.setRateChengxiangTurnoverMom(getDecimal(row, 33));
- item.setAvgDistanceMomChange(getDecimal(row, 34));
- item.setAvgDistanceCityMomChange(getDecimal(row, 35));
- item.setDailyPassengerPerVehicle(getDecimal(row, 36));
- item.setRateOpVehiclesYoy(getDecimal(row, 39));
- item.setRatePassengerYoy(getDecimal(row, 40));
- item.setRatePassengerCityYoy(getDecimal(row, 41));
- item.setRateChengxiangYoy(getDecimal(row, 42));
- item.setRateChengxiangTurnoverYoy(getDecimal(row, 43));
- item.setStopCityRatio(getDecimal(row, 44));
- item.setPassengerCityRatio(getDecimal(row, 45));
- item.setChengxiangRatio(getDecimal(row, 46));
- item.setRateTurnoverYoy(getDecimal(row, 47));
- item.setRateTurnoverMom(getDecimal(row, 48));
- item.setPassengerChengxiang(getDecimal(row, 49));
- item.setTurnoverChengxiang(getDecimal(row, 50));
- item.setAvgDistanceChengxiang(getDecimal(row, 51));
- item.setVerifyExplanation(getString(row, 65));
- item.setReportNote(getString(row, 66));
- item.setModifyRecord(getString(row, 67));
+ item.setOpVehicles(getDecimal(row, colByName(hdr, 5, "鍏叡姹界數杞杩愯惀杞︽暟")));
+ item.setStopTotal(getDecimal(row, colByName(hdr, 6, "杩愯惀绔欑偣鎬讳釜鏁�")));
+ item.setStopCity(getDecimal(row, colByName(hdr, 7, "鍏朵腑锛氬煄甯傚唴")));
+ item.setPassengerVolume(getDecimal(row, colByName(hdr, 8, "鍏叡姹界數杞瀹㈣繍閲�")));
+ item.setPassengerCity(getDecimal(row, colByName(hdr, 9, "鍏朵腑锛氬煄甯傚唴", 2)));
+ item.setTurnover(getDecimal(row, colByName(hdr, 10, "鏂板鍏叡姹界數杞︽梾瀹㈠懆杞噺")));
+ item.setTurnoverCity(getDecimal(row, colByName(hdr, 11, "鏂板鍏叡姹界數杞︽梾瀹㈠懆杞噺_鍏朵腑鍩庡競鍐�")));
+ item.setRailPassengerVolume(getDecimal(row, colByName(hdr, 13, "杞ㄩ亾浜ら�歘瀹㈣繍閲�")));
+ item.setRailTurnover(getDecimal(row, colByName(hdr, 14, "杞ㄩ亾浜ら�歘鏃呭鍛ㄨ浆閲�")));
+ item.setFerryPassengerVolume(getDecimal(row, colByName(hdr, 17, "鍩庡競瀹㈣繍杞浮_瀹㈣繍閲�")));
+ item.setFerryTurnover(getDecimal(row, colByName(hdr, 18, "鍩庡競瀹㈣繍杞浮鏃呭鍛ㄨ浆閲�")));
+ item.setAvgDistance(getDecimal(row, colByName(hdr, 19, "鍏叡姹界數杞﹀钩鍧囪繍璺�")));
+ item.setAvgDistanceCity(getDecimal(row, colByName(hdr, 20, "鍏叡姹界數杞﹀煄甯傚唴骞冲潎杩愯窛")));
+ item.setContactPerson(getString(row, colByName(hdr, 24, "濉〃浜�")));
+ item.setContactPhone(getString(row, colByName(hdr, 25, "鑱旂郴鐢佃瘽")));
+ item.setReportDate(getDateString(row, colByName(hdr, 26, "鎶ュ嚭鏃ユ湡")));
+ item.setRateOpVehiclesMom(getDecimal(row, colByName(hdr, 29, "鍏叡姹界數杞杩愯惀杞︽暟鐜瘮澧為��")));
+ item.setRatePassengerMom(getDecimal(row, colByName(hdr, 30, "鍏叡姹界數杞瀹㈣繍閲忕幆姣斿閫�")));
+ item.setRatePassengerCityMom(getDecimal(row, colByName(hdr, 31, "鍩庡競鍐呭杩愰噺鐜瘮")));
+ item.setRateChengxiangMom(getDecimal(row, colByName(hdr, 32, "鍩庨檯鍩庝埂瀹㈣繍閲忕幆姣斿閫�")));
+ item.setRateChengxiangTurnoverMom(getDecimal(row, colByName(hdr, 33, "鍩庨檯鍩庝埂鏃呭鍛ㄨ浆閲忕幆姣斿閫�")));
+ item.setAvgDistanceMomChange(getDecimal(row, colByName(hdr, 34, "骞冲潎杩愯窛鐜瘮澧炲噺锛堝叕閲岋級")));
+ item.setAvgDistanceCityMomChange(getDecimal(row, colByName(hdr, 35, "骞冲潎杩愯窛_鍩庡競鍐呯幆姣斿鍑忥紙鍏噷锛�")));
+ item.setDailyPassengerPerVehicle(getDecimal(row, colByName(hdr, 36, "鍏叡姹界數杞鍗曡溅鏃ュ潎瀹㈣繍閲�")));
+ item.setRateOpVehiclesYoy(getDecimal(row, colByName(hdr, 39, "鍏叡姹界數杞杩愯惀杞︽暟鍚屾瘮澧為��")));
+ item.setRatePassengerYoy(getDecimal(row, colByName(hdr, 40, "鍏叡姹界數杞瀹㈣繍閲忓悓姣斿閫�")));
+ item.setRatePassengerCityYoy(getDecimal(row, colByName(hdr, 41, "瀹㈣繍閲廮鍩庡競鍐呭悓姣斿閫�")));
+ item.setRateChengxiangYoy(getDecimal(row, colByName(hdr, 42, "鍩庨檯鍩庝埂瀹㈣繍閲忓悓姣斿閫�")));
+ item.setRateChengxiangTurnoverYoy(getDecimal(row, colByName(hdr, 43, "鍩庨檯鍩庝埂鏃呭鍛ㄨ浆閲忓悓姣斿閫�")));
+ item.setStopCityRatio(getDecimal(row, colByName(hdr, 44, "鍩庡競鍐呰繍钀ョ珯鐐瑰崰姣�")));
+ item.setPassengerCityRatio(getDecimal(row, colByName(hdr, 45, "鍩庡競鍐呭杩愰噺鍗犳瘮")));
+ item.setChengxiangRatio(getDecimal(row, colByName(hdr, 46, "鍩庨檯鍩庝埂瀹㈣繍閲忓崰姣�")));
+ item.setRateTurnoverYoy(getDecimal(row, colByName(hdr, 47, "鏃呭鍛ㄨ浆閲忓悓姣斿閫�")));
+ item.setRateTurnoverMom(getDecimal(row, colByName(hdr, 48, "鏃呭鍛ㄨ浆閲忕幆姣斿閫�")));
+ item.setPassengerChengxiang(getDecimal(row, colByName(hdr, 49, "鍩庨檯鍩庝埂瀹㈣繍閲�")));
+ item.setTurnoverChengxiang(getDecimal(row, colByName(hdr, 50, "鍩庨檯鍩庝埂鏃呭鍛ㄨ浆閲�")));
+ item.setAvgDistanceChengxiang(getDecimal(row, colByName(hdr, 51, "鍩庨檯鍩庝埂骞冲潎杩愯窛")));
+ item.setVerifyExplanation(getString(row, colByName(hdr, 65, "鏍稿疄鎬у師鍥犺В閲�")));
+ item.setReportNote(getString(row, colByName(hdr, 66, "涓婃姤璇存槑")));
+ item.setModifyRecord(getString(row, colByName(hdr, 67, "淇敼璁板綍")));
rows.add(new CityBusRow(r + 1, item));
}
} catch (Exception e) {
@@ -3186,52 +3223,52 @@
List<TaxiRow> rows = new ArrayList<>();
try (Workbook wb = WorkbookFactory.create(file.getInputStream())) {
Sheet sheet = wb.getSheetAt(0);
- requireHeaderLayout(sheet, "宸℃父鍑虹", "妯℃澘_浜よ缁烾402琛�-宸℃父鍑虹姹借溅杩愯惀鏈嶅姟鎯呭喌鏈堟姤(2026).xls",
- CITY_TAXI_HEADER_COLS, CITY_TAXI_HEADER_KEYWORDS);
+ Row hdr = sheet.getRow(0);
+ requireHeaderColsByName(sheet, "宸℃父鍑虹", "妯℃澘_浜よ缁烾402琛�-宸℃父鍑虹姹借溅杩愯惀鏈嶅姟鎯呭喌鏈堟姤(2026).xls", CITY_TAXI_HEADER_KEYWORDS);
for (int r = 1; r <= sheet.getLastRowNum(); r++) {
Row row = sheet.getRow(r);
if (row == null) continue;
- String name = getString(row, 2);
+ String name = getString(row, colByName(hdr, 2, "浼佷笟鍚嶇О"));
if (name == null || name.trim().isEmpty()) continue;
CityTaxiMonthly item = new CityTaxiMonthly();
item.setReportPeriod(period);
- item.setRegionCode(getString(row, 0));
- item.setCity(cityOf(getString(row, 0), name));
- item.setTripTotal(getDecimal(row, 4));
- item.setTripCity(getDecimal(row, 5));
- item.setPassengerVolume(getDecimal(row, 6));
- item.setPassengerCity(getDecimal(row, 7));
- item.setTurnover(getDecimal(row, 8));
- item.setTurnoverCity(getDecimal(row, 9));
- item.setOpVehicles(getDecimal(row, 10));
- item.setAvgDistance(getDecimal(row, 11));
- item.setAvgDistanceCity(getDecimal(row, 12));
- item.setContactPerson(getString(row, 15));
- item.setContactPhone(getString(row, 16));
- item.setReportDate(getDateString(row, 17));
- item.setDailyTripsPerVehicle(getDecimal(row, 18));
- item.setDailyPassengerPerVehicle(getDecimal(row, 19));
- item.setPassengersPerTrip(getDecimal(row, 20));
- item.setRateOpVehiclesMom(getDecimal(row, 21));
- item.setRateOpVehiclesYoy(getDecimal(row, 22));
- item.setRateTripMom(getDecimal(row, 23));
- item.setRateTripYoy(getDecimal(row, 24));
- item.setRatePassengerMom(getDecimal(row, 25));
- item.setRatePassengerYoy(getDecimal(row, 26));
- item.setAvgDistanceMomChange(getDecimal(row, 27));
- item.setPassengersPerTripCity(getDecimal(row, 28));
- item.setRateTripCityMom(getDecimal(row, 29));
- item.setRatePassengerCityMom(getDecimal(row, 30));
- item.setAvgDistanceCityMomChange(getDecimal(row, 31));
- item.setTripCityRatio(getDecimal(row, 32));
- item.setPassengerCityRatio(getDecimal(row, 33));
- item.setPassengersPerTripChengxiang(getDecimal(row, 34));
- item.setRateTripChengxiangMom(getDecimal(row, 35));
- item.setRatePassengerChengxiangMom(getDecimal(row, 36));
- item.setAvgDistanceChengxiang(getDecimal(row, 37));
- item.setVerifyExplanation(getString(row, 38));
- item.setReportNote(getString(row, 39));
- item.setModifyRecord(getString(row, 40));
+ item.setRegionCode(getString(row, colByName(hdr, 0, "鎵�灞炲湴鍖�")));
+ item.setCity(cityOf(getString(row, colByName(hdr, 0, "鎵�灞炲湴鍖�")), name));
+ item.setTripTotal(getDecimal(row, colByName(hdr, 4, "杞藉杞︽鎬绘暟")));
+ item.setTripCity(getDecimal(row, colByName(hdr, 5, "杞藉杞︽鎬绘暟_鍩庡競鍐�")));
+ item.setPassengerVolume(getDecimal(row, colByName(hdr, 6, "瀹㈣繍閲�")));
+ item.setPassengerCity(getDecimal(row, colByName(hdr, 7, "瀹㈣繍閲廮鍏朵腑鍩庡競鍐�")));
+ item.setTurnover(getDecimal(row, colByName(hdr, 8, "鏃呭鍛ㄨ浆閲�")));
+ item.setTurnoverCity(getDecimal(row, colByName(hdr, 9, "鏃呭鍛ㄨ浆閲廮鍩庡競鍐�")));
+ item.setOpVehicles(getDecimal(row, colByName(hdr, 10, "杩愯惀杞﹁締鏁�")));
+ item.setAvgDistance(getDecimal(row, colByName(hdr, 11, "宸℃父鍑虹姹借溅骞冲潎杩愯窛")));
+ item.setAvgDistanceCity(getDecimal(row, colByName(hdr, 12, "鍩庡競鍐呭钩鍧囪繍璺�")));
+ item.setContactPerson(getString(row, colByName(hdr, 15, "濉〃浜�")));
+ item.setContactPhone(getString(row, colByName(hdr, 16, "鑱旂郴鐢佃瘽")));
+ item.setReportDate(getDateString(row, colByName(hdr, 17, "鎶ュ嚭鏃ユ湡")));
+ item.setDailyTripsPerVehicle(getDecimal(row, colByName(hdr, 18, "鍗曡溅鏃ュ潎杞藉杞︽")));
+ item.setDailyPassengerPerVehicle(getDecimal(row, colByName(hdr, 19, "鍗曡溅鏃ュ潎瀹㈣繍閲�")));
+ item.setPassengersPerTrip(getDecimal(row, colByName(hdr, 20, "鍗曡溅娆¤浇瀹汉鏁�")));
+ item.setRateOpVehiclesMom(getDecimal(row, colByName(hdr, 21, "杩愯惀杞︽暟鐜瘮澧為��")));
+ item.setRateOpVehiclesYoy(getDecimal(row, colByName(hdr, 22, "杩愯惀杞︽暟鍚屾瘮澧為��")));
+ item.setRateTripMom(getDecimal(row, colByName(hdr, 23, "杞藉杞︽鎬绘暟鐜瘮澧為��")));
+ item.setRateTripYoy(getDecimal(row, colByName(hdr, 24, "杞藉杞︽鍚屾瘮澧為��")));
+ item.setRatePassengerMom(getDecimal(row, colByName(hdr, 25, "瀹㈣繍閲忕幆姣斿閫�")));
+ item.setRatePassengerYoy(getDecimal(row, colByName(hdr, 26, "瀹㈣繍閲忓悓姣斿閫�")));
+ item.setAvgDistanceMomChange(getDecimal(row, colByName(hdr, 27, "骞冲潎杩愯窛鐜瘮澧炲噺")));
+ item.setPassengersPerTripCity(getDecimal(row, colByName(hdr, 28, "鍗曡溅娆¤浇瀹汉鏁癬鍩庡競鍐�")));
+ item.setRateTripCityMom(getDecimal(row, colByName(hdr, 29, "杞藉杞︽鎬绘暟鐜瘮澧為�焈鍩庡競鍐�")));
+ item.setRatePassengerCityMom(getDecimal(row, colByName(hdr, 30, "瀹㈣繍閲忕幆姣斿閫焈鍩庡競鍐�")));
+ item.setAvgDistanceCityMomChange(getDecimal(row, colByName(hdr, 31, "骞冲潎杩愯窛_鍩庡競鍐呯幆姣斿鍑�")));
+ item.setTripCityRatio(getDecimal(row, colByName(hdr, 32, "杞藉杞︽鎬绘暟_鍩庡競鍐呭崰姣�")));
+ item.setPassengerCityRatio(getDecimal(row, colByName(hdr, 33, "瀹㈣繍閲廮鍩庡競鍐呭崰姣�")));
+ item.setPassengersPerTripChengxiang(getDecimal(row, colByName(hdr, 34, "鍗曡溅娆¤浇瀹汉鏁癬鍩庨檯鍩庝埂")));
+ item.setRateTripChengxiangMom(getDecimal(row, colByName(hdr, 35, "杞藉杞︽鎬绘暟_鍩庨檯鍩庝埂鐜瘮澧為��")));
+ item.setRatePassengerChengxiangMom(getDecimal(row, colByName(hdr, 36, "瀹㈣繍閲廮鍩庨檯鍩庝埂鐜瘮澧為��")));
+ item.setAvgDistanceChengxiang(getDecimal(row, colByName(hdr, 37, "骞冲潎杩愯窛_鍩庨檯鍩庝埂")));
+ item.setVerifyExplanation(getString(row, colByName(hdr, 38, "鏍稿疄鎬у師鍥犺В閲�")));
+ item.setReportNote(getString(row, colByName(hdr, 39, "涓婃姤璇存槑")));
+ item.setModifyRecord(getString(row, colByName(hdr, 40, "淇敼璁板綍")));
rows.add(new TaxiRow(r + 1, item));
}
} catch (Exception e) {
--
Gitblit v1.9.1