From 49fea21571a4060aa8570cbf220088352e2ccf15 Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期三, 16 九月 2026 17:33:01 +0800 Subject: [PATCH] docs(工作日结): 补记 2026-09-16 收工记录（origin 已推 80e0879、gitea 仍不通、未提交项与明日计划） --- docs/功能测试报告/功能测试报告_H2031模板新增列适配_2026-09-16.md | 53 +++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 53 insertions(+), 0 deletions(-) diff --git "a/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_H2031\346\250\241\346\235\277\346\226\260\345\242\236\345\210\227\351\200\202\351\205\215_2026-09-16.md" "b/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_H2031\346\250\241\346\235\277\346\226\260\345\242\236\345\210\227\351\200\202\351\205\215_2026-09-16.md" new file mode 100644 index 0000000..dc24353 --- /dev/null +++ "b/docs/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212/\345\212\237\350\203\275\346\265\213\350\257\225\346\212\245\345\221\212_H2031\346\250\241\346\235\277\346\226\260\345\242\236\345\210\227\351\200\202\351\205\215_2026-09-16.md" @@ -0,0 +1,53 @@ +# 鍔熻兘娴嬭瘯鎶ュ憡锛欻203-1 妯℃澘鏂板銆岀粺涓�绀句細淇＄敤浠ｇ爜 / 濉姤鍗曚綅銆嶄袱鍒楅�傞厤 + +- 鏃ユ湡锛�2026-09-16 +- 妯″潡锛氭暟鎹鍏� / 鏁版嵁鏌ョ湅 / 鏁版嵁搴撹〃缁撴瀯 +- 缁撹锛�**閫氳繃**锛堟鍚� 4 鏉°�佽礋鍚� 2 鏉°�佸吋瀹� 2 鏉°�佸叆搴撴娊鏌� 814脳2 椤瑰叏閮ㄥ榻愶級 + +## 涓�銆佸姛鑳借鏄� + +鐢ㄦ埛淇敼浜嗐�婃ā鏉縚浜や紒缁烪203-1琛╛鍏矾鏃呭杩愯緭鏈堝害鐢熶骇鎯呭喌銆嬫ā鏉匡紝鍦ㄣ�屼紒涓氬悕绉般�嶄箣鍚�**鎻掑叆涓ゅ垪**锛歚缁熶竴绀句細淇＄敤浠ｇ爜`銆乣濉姤鍗曚綅`锛屽叾浣� 48 鍒楁暣浣撳彸绉伙紝鎬诲垪鏁扮敱 50 鈫� 52銆傛湰娆℃敼鍔ㄨ鍚庣鑳借鍙栧苟鍏ュ簱杩欎袱鍒楋紝鍚屾椂淇濊瘉鑰佹牸寮忔枃浠跺吋瀹广�� + +鏀瑰姩娓呭崟锛� +| 灞� | 鏂囦欢 | 鏀瑰姩 | +|----|------|------| +| 鏁版嵁搴� | `h2031_enterprise_monthly` | `ADD COLUMN unified_credit_code VARCHAR(50) NULL AFTER enterprise_name`銆乣ADD COLUMN report_unit VARCHAR(200) NULL AFTER unified_credit_code` | +| 寤鸿〃鑴氭湰 | `docs/init.sql` | 鍚屾琛ヤ袱鍒� | +| 鏁版嵁瀛楀吀 | `docs/database.md` | 鍚屾琛ヤ袱鍒楄鏄� | +| 瀹炰綋 | `PassengerEnterpriseMonthly.java` | 鏂板 `unifiedCreditCode`銆乣reportUnit` | +| 瀵煎叆瑙ｆ瀽 | `DataImportService.java` | `importPassengerMonthly` 鍐呮寜琛ㄥご鍚嶅彇鍊� | +| 鍓嶇鍒楅厤缃� | `DataViewController.java` | `H2031_COLUMNS` 鏂板涓ゅ垪锛堟暟鎹煡鐪嬮〉鍙锛� | + +## 浜屻�佹祴璇曠幆澧� + +- 鍚庣锛歚Started TrafficAuditApplication` / `Tomcat started on port(s): 8090`锛堥噸鍚悗鏂扮紪璇戯紝13:30锛� +- 鍓嶇锛�8080 宸插氨缁紙鏈鏈敼鍓嶇锛屾湭閲嶅惎锛� +- 鏁版嵁搴擄細`traffic_audit` @ 127.0.0.1:3308 +- 鏂版ā鏉匡細`docs\鍏矾鏃呭\妯℃澘_浜や紒缁烪203-1琛╛鍏矾鏃呭杩愯緭鏈堝害鐢熶骇鎯呭喌.xlsx`锛圫heet1锛�816脳52锛� +- 鑰佹牸寮忥細`D:\妗岄潰\娴嬭瘯鏁版嵁\鍏矾鏃呭\鍏湀\鍏矾鏃呭杩愯緭鏈堝害鐢熶骇鎯呭喌锛�2026锛塤2026-09-09 09_18_45.xls`锛圫heet0锛�769脳52锛� + +## 涓夈�佺敤渚嬭〃 + +| # | 鍦烘櫙 | 杈撳叆 | 棰勬湡 | 瀹為檯 | 缁撹 | +|---|------|------|------|------|------| +| 1 | 姝ｅ悜-鏂版ā鏉垮鍏� | 鏂版ā鏉� 鈫� `POST /api/import/passengerMonthly?period=2099-07` | 鎴愬姛涓旀潯鏁颁笌婧愭枃浠朵竴鑷� | `鎴愬姛 814 鏉★紝澶辫触 0 鏉 | 閫氳繃 | +| 2 | 姝ｅ悜-鏂板垪鍏ュ簱 | 鏌� `unified_credit_code` / `report_unit` | 814 琛屽叏閮ㄦ湁鍊� | `count=814, c1=814, c2=814` | 閫氳繃 | +| 3 | 鍏ュ簱鎶芥煡-棣栬 | 婧愮 1 琛� vs 搴撶 1 琛� | 閫愬瓧娈典竴鑷� | 搴擄細`enterprise_code=91420105MA4F5Q3R68`銆乣unified_credit_code=91420105MA4F5Q3R68`銆乣report_unit=姝︽眽甯傚畯骞茬嚎鍏矾瀹㈣繍鏈夐檺鍏徃閲戝湴鍒嗗叕鍙竊銆乣vehicle_total=26`銆乣passenger_total=12835`锛屼笌 Excel 瀹屽叏涓�鑷� | 閫氳繃 | +| 4 | 鍏ュ簱鎶芥煡-姹囨�诲垪 | 婧愭枃浠舵眹鎬� vs 搴撴眹鎬� | 涓�鑷� | 瀹㈣繍杞﹁締 24584銆佹牳瀹氳浇瀹綅 711018銆佸杩愰噺 16371625銆佸懆杞噺 1023386179锛屽洓椤瑰叏绛� | 閫氳繃 | +| 5 | 鍏煎-鑰佹牸寮忓鍏� | 鑰� `.xls` 鈫� `period=2099-09` | 鎴愬姛涓旀柊鍒楁湁鍊硷紙鑰佹枃浠朵篃鍚繖涓ゅ垪锛� | `鎴愬姛 767 鏉★紝澶辫触 0 鏉锛沗c1=767, c2=767` | 閫氳繃 | +| 6 | 鍏煎-鑰佹牸寮忔暟鍊间笉鍙� | 2099-09 vs 鏃㈡湁 2026-08锛堝悓婧愬悓鍐呭锛� | 瀹屽叏涓�鑷� | n=767 / v=22091 / p=16286506 / t=1158473501锛屽洓椤瑰叏绛� | 閫氳繃 | +| 7 | 鍏煎-鑰佹牸寮忛琛屾娊鏌� | Excel COM 璇� `.xls` 绗� 2 琛� vs 搴� | 涓�鑷� | 婧愶細`914201005519761659 / 914201005519761659 / 姝︽眽鎹峰畨椤鸿揪姹借溅鏈嶅姟鏈夐檺鍏徃 / 24 / 54330`锛涘簱鍚� | 閫氳繃 | +| 8 | 璐熷悜-閫夐敊鏁版嵁绫诲瀷 | `H203_1_2026-鍏矾鏃呭杩愯緭鏈堝害鐢熶骇鎯呭喌锛�2026锛�.xlsx` 鈫� passengerMonthly | 鏄庣‘鎶ラ敊銆佷笉鍐欏簱 | `瀵煎叆澶辫触: 鎵�閫夋暟鎹被鍨嬨�愬叕璺梾瀹㈣繍杈撴湀搴︾敓浜ф儏鍐点�戜笌鏂囦欢鍐呭涓嶇锛氳〃澶寸己灏戝繀闇�鍒椼�愪紒涓氬悕绉般�戙�愬杩愰噺_鎬昏銆慲 | 閫氳繃 | +| 9 | 璐熷悜-鍒楀彸绉讳笉褰卞搷鏃у瓧娈� | 鏂版ā鏉匡紙鏁翠綋鍙崇Щ 2 鍒楋級 | 浼佷笟浠ｇ爜/浼佷笟鍚嶇О/杞﹁締/瀹㈣繍閲忕瓑鏃у瓧娈靛彇鍊间笉鍙� | 瑙ｆ瀽鎸夎〃澶村悕 `buildHeaderMap` 鍙栧�硷紝814 鏉� 0 澶辫触锛屾眹鎬诲洓椤逛笌婧愭枃浠朵竴鑷达紙瑙佺敤渚� 4锛� | 閫氳繃 | + +## 鍥涖�佸彂鐜扮殑闂涓庡缃� + +1. **鑰佹牸寮忔枃浠跺叾瀹炰篃甯﹁繖涓ゅ垪**锛坄缁熶竴绀句細淇＄敤浠ｇ爜`銆乣濉姤鍗曚綅`锛夛紝姝ゅ墠浠ｇ爜鏈鍙� 鈫� 鏈湡涓�骞跺紑濮嬪叆搴撱�傝繖涔熸剰鍛崇潃 2026-01 ~ 2026-08 鐨勫瓨閲忔暟鎹繖涓ゅ垪涓虹┖锛�**闇�瑕侀噸瀵煎搴旀枃浠舵墠鑳藉洖濉�**锛堝凡鍒楀叆寰呭姙锛岀瓑鐢ㄦ埛纭锛夈�� +2. **琛ㄧ粨鏋勫彉鏇村繀椤诲悓姝ヤ笁澶�**锛氭湰娆￠娆″彧鏀逛簡搴撲笌瀹炰綋锛屾紡浜� `docs/init.sql` / `docs/database.md`锛屽凡琛ラ綈銆� +3. **鏇挎崲閿氱偣涓嶅敮涓�瀵艰嚧鏀归敊鏂囨。**锛歚docs/database.md` 涓� `| enterprise_name | varchar(200) | 浼佷笟鍚嶇О |` 鍑虹幇 4 娆★紝棣栨鎵归噺鏇挎崲璇敼浜� H203-2 绛� 3 寮犺〃锛屽凡 `git checkout` 鍥為��骞舵敼涓恒�屽厛鎴彇 h2031 绔犺妭鍐嶆浛鎹€�嶃�� + +## 浜斻�佺粨璁� + +- 鏂版ā鏉夸笌鑰佹牸寮�**鍙屽悜鍏煎**锛屽鍏� 0 澶辫触锛屾娊鏌ュ垪閫愰」瀵归綈锛涙棫瀛楁鏈彈鍒楀彸绉诲奖鍝嶃�� +- 鏁版嵁搴撱�佸缓琛ㄨ剼鏈�佹暟鎹瓧鍏搞�佸疄浣撱�佸鍏ヨВ鏋愩�佸墠绔垪閰嶇疆**鍏涓�鑷�**銆� +- 閬楃暀锛氬瓨閲忔湀浠斤紙2026-01 ~ 2026-08锛夌殑涓ゅ垪寰呭洖濉紝绛夌敤鎴风‘璁ゅ悗閲嶅銆� -- Gitblit v1.9.1