From c83480ec468accd3fd86ec778a53973d7b6b68a4 Mon Sep 17 00:00:00 2001
From: xyc <jc_xiong@hotmail.com>
Date: 星期六, 03 十月 2026 13:52:56 +0800
Subject: [PATCH] docs(交接): 记录服务已成功安装到 Windows 服务器及待确认项

---
 HANDOFF.md |  108 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 108 insertions(+), 0 deletions(-)

diff --git a/HANDOFF.md b/HANDOFF.md
index 2da0b05..a305c9f 100644
--- a/HANDOFF.md
+++ b/HANDOFF.md
@@ -4,6 +4,114 @@
 > **姣忓ぉ缁撴潫鏃�**锛氭妸褰撳ぉ杩涘睍銆佽俯杩囩殑鍧戙�佹柊闇�姹傘�佹湭瀹屾垚浜嬮」鏇存柊鍒版湰鏂囦欢锛岀劧鍚庡彲浠ユ斁蹇冨紑鏂板璇濄��
 > **鍗忎綔绾﹀畾锛�2026-08-31锛�**锛氳銆屾彁浜ゃ��= 鏈湴 commit + 鎺ㄩ�佸埌杩滅 git锛坥rigin main锛孏itblit锛夛紝涓嶅啀鍙仛鏈湴 commit銆�
 
+## 鏈�鏂帮紙2026-10-03锛�
+
+### 琛ュ厖锛�10-03 涓嬪崍锛夛細鏈嶅姟鍣ㄩ儴缃叉姤 鈥淎ccess denied ... (using password: NO)鈥� 鈥斺�� 鏍瑰洜涓庝慨澶�
+- **鐜拌薄**锛氭妸 `deploy/traffic-audit-release-20261002/` 閮ㄧ讲鍒� `61.183.254.94` 鍚庯紝鍚庣鍚姩鎶� `java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO)`銆�
+- **鏍瑰洜**锛歫ar 鍐呯疆閰嶇疆閲屽簱鍙ｄ护鏄崰浣嶇 `${TRAFFIC_DB_PASSWORD:}`锛堥粯璁ょ┖涓诧級锛岃�� 10-02 閭ｄ釜鍖�**鍙惈 jar + web + dist**锛屾病鏈夊缃� `application.yml`銆佹病鏈� `docs/`銆乣db/`銆佸惎鍔ㄨ剼鏈�傞儴缃叉満娌℃湁浠讳綍澶栭儴閰嶇疆瑕嗙洊锛孲pring 灏辨嬁绌哄瘑鐮佽繛鏈満 MySQL 鈫� `using password: NO`锛堟敞鎰忥細杩欐槸鈥滄湯浼犲瘑鐮佲�濓紝涓嶆槸瀵嗙爜閿欙級銆�
+- **鏈嶅姟鍣ㄤ晶涓�姝ヤ慨澶嶏紙鏃犻渶閲嶆墦鍖咃級**锛氬湪 jar 鍚岀骇鏀� `application.yml`锛屾妸 `spring.datasource.url/username/password` 鏀规垚鐜板満鐪熷疄鍊煎悗閲嶅惎鍗冲彲锛涗篃鍙敤鐜鍙橀噺 `TRAFFIC_DB_PASSWORD` 浠ｆ浛銆傚惎鍔ㄨ剼鏈凡鍔犻妫�鎻愰啋锛堢己 `application.yml` / password 浠嶆槸鍗犱綅鏂囧瓧閮戒細 WARN锛夈�備慨澶嶅悗鑻ユ姤鈥滄湭鎵惧埌鏁版嵁鐩綍 docs鈥濆垯璇存槑鍖呭唴缂� `backend/docs`锛屼粠鏂板寘鎴栨簮鏈哄櫒鎷枫��
+- **鎵撳寘宸ュ叿宸蹭慨锛堝師 鈥滄墦鍖呭伐鍏峰緟淇�� 涓ら」鍧囧凡钀藉疄锛�**锛歚pack-deploy.ps1` 閲嶅啓涓轰簲姝ワ細鈶� 鐢ㄦ柊澧炴ā鏉� `deploy-templates/jar-application.yml`锛�**鍏ㄥ崰浣嶇**锛変复鏃舵浛鎹㈡簮鐮侀厤缃悗 `mvn clean package`锛屾棤璁烘垚璐ラ兘杩樺師鐪熷疄閰嶇疆锛涒憽 瑙ｅ帇 jar 鍘诲瘑鑷锛涒憿 鍓嶇鏋勫缓锛涒懀 缁勮**瀹屾暣鍖�**锛歚backend/{jar, application.yml, start-backend.cmd/.sh, docs/, web/}` + `frontend/dist` + `db/*.sql` + README锛坄backend/web` 浠� dist 鑷姩鍚屾锛岄�愭枃浠朵竴鑷达級锛涒懁 鏁村寘鏄庢枃瀵嗛挜鎵弿銆傛柊澧� `-SkipBackend` 鍙鐢ㄧ幇鏈� jar 蹇�熼噸缁勫寘銆�
+- **妯℃澘鍚屾淇**锛歚deploy-templates/backend/application.yml` 鐨� `server.port` 鐢� 8080 鏀瑰洖 8090锛堝師鍊间細瀵艰嚧鍚庣璧峰湪 8080锛夈�佽ˉ `static-locations: file:./web/` 涓� password 闄烽槺娉ㄩ噴锛沗README-閮ㄧ讲璇存槑.txt` 甯歌闂鏂板璇ユ姤閿欏缃紱`docs/鎵撳寘閮ㄧ讲璇存槑.md` 鎺掗敊琛ㄦ柊澧炶琛岋紱`application.yml.example` 鐜鍙橀噺鍚嶇粺涓�涓� `TRAFFIC_DB_USER/TRAFFIC_DB_PASSWORD/TRAFFIC_JWT_SECRET`锛堝師鏉ヨ鐢� `MYSQL_PASSWORD`/`JWT_SECRET`锛屼笌 `start-dev.ps1` 涓嶄竴鑷达級銆�
+- **鏂板寘锛堟湰鍦帮紝涓嶅叆搴擄級**锛歚deploy/traffic-audit-deploy-20261003/`锛�388 鏂囦欢 / 93.07 MB锛寊ip 76.37 MB锛夛紝宸查獙璇侊細jar 鍐呯疆閰嶇疆鍏ㄥ崰浣嶇锛堝幓瀵嗚嚜妫�閫氳繃锛夈�乣backend/web` 涓� `frontend/dist` 閫愭枃浠朵竴鑷达紙鍚� 44 涓級銆乣backend/docs/鐢熸垚姹囨�诲ぇ琛╜ 姣嶇増瀛樺湪銆乣鍔熻兘娴嬭瘯鎶ュ憡/宸ヤ綔鏃ョ粨/闂姹囨��/_cache` 宸叉帓闄ゃ��
+- **韪╁潙锛堥噸瑕侊級**锛氭湰鏈� PowerShell 5.1 鎶婃棤 BOM 鐨� `.ps1` 褰� ANSI 璇伙紝涓枃娉ㄩ噴浼氬彉鎴愪贡鐮佸苟瀵艰嚧鑴氭湰瑙ｆ瀽澶辫触銆俙pack-deploy.ps1` 蹇呴』淇濆瓨涓� **UTF-8 with BOM**锛堜粨搴撳叾浠� `*.ps1` 涔熼兘鏄� BOM锛夛紱鎺掓煡涓浘瀹為檯韪╁埌銆�
+
+- **杩愯鐘舵�侊紙鍐欎氦鎺ユ椂锛�**锛氬悗绔� 8090銆佸墠绔� 8080 鍧囨湭鐩戝惉锛涙柊瀵硅瘽濡傜户缁紑鍙戞垨娴嬭瘯锛屽厛鎵ц `powershell -NoProfile -ExecutionPolicy Bypass -File start-dev.ps1`銆傛暟鎹簱浠嶄负 `127.0.0.1:3305/traffic_audit`锛孧ySQL 鏈嶅姟鏈仠銆�
+- **鍙戝竷鏋勫缓锛堝凡瀹屾垚锛�**锛氬簲鈥滃彂甯冪紪璇戔�濊姹傦紝宸插畬鎴愬悗绔� `mvn clean package -DskipTests` 鍜屽墠绔� `npm run build`銆俲ar 鍐呭凡鍋氬幓瀵嗚嚜妫�锛屽彧淇濈暀鐜鍙橀噺鍗犱綅绗︼紱鏋勫缓鍚庢湰鏈虹湡瀹� `src/main/resources/application.yml` 宸插師鏍锋仮澶嶃��
+- **鍙戝竷浜х墿锛堟湰鍦帮紝鏈叆搴擄級**锛�
+  - 鍚庣 jar锛歚traffic-audit-server/target/traffic-audit-server-1.0.0-SNAPSHOT.jar`锛堢害 54.6 MB锛�
+  - 鍓嶇锛歚traffic-audit-web/dist`锛�44 涓枃浠躲�佺害 3.55 MB锛�
+  - 鍙戝竷鐩綍锛歚deploy/traffic-audit-release-20261002/`锛堝惈 `backend/`銆乣frontend/dist/`锛�
+  - 鍙戝竷鍘嬬缉鍖咃細`deploy/traffic-audit-release-20261002.zip`锛堢害 51.11 MB锛�
+- **鍙戝竷鍖呯粨鏋勮鏄�**锛歚frontend/dist` 鏄爣鍑嗗墠绔彂甯冪洰褰曪紱`backend/web` 鏄悓涓�浠� dist 鐨勫壇鏈紝鐢ㄤ簬鍚庣 8090 鍗曠鍙ｆā寮忥紙褰撳墠闈欐�佽祫婧愯矾寰勪负 `file:./web/,classpath:/static/`锛夈�備袱澶勫凡閫愭枃浠舵瘮瀵癸紝鏂囦欢鍒楄〃涓� SHA-256 瀹屽叏涓�鑷淬��
+- **瀹夊叏鐘舵��**锛氭湰鏈虹湡瀹為厤缃凡淇濆瓨鍦ㄨ蹇界暐鐨� `traffic-audit-server/config/application.yml`锛涘彂甯� jar 涓嶅惈鐪熷疄鏁版嵁搴撳彛浠ゃ�丣WT secret 鎴� DeepSeek key銆傚彂甯冨寘涓嶅寘鍚儴缃叉満鐨勭湡瀹炲閮ㄩ厤缃紝閮ㄧ讲鏃堕渶瑕佺户缁娇鐢ㄧ幇鍦� `application.yml` 鎴栨寜妯℃澘濉啓銆�
+- **鎵撳寘宸ュ叿寰呬慨锛堥噸瑕侊級**锛歚pack-deploy.ps1` 鐩墠鐩存帴娑堣垂 `src/main/resources/application.yml`锛岃嫢璇ユ枃浠惰鏈満鐪熷疄閰嶇疆瑕嗙洊锛屼細鍦ㄥ幓瀵嗚嚜妫�闃舵涓锛涗笖瀹冨彧鎶� dist 鏀惧埌 `frontend/dist`锛屾病鏈夊悓姝ュ埌 `backend/web`锛岄粯璁ゅ寘鏃犳硶鐩存帴鐢ㄤ簬 8090 鍗曠鍙ｆā寮忋�傛湰娆′娇鐢ㄢ�滀复鏃跺崰浣嶇閰嶇疆 鈫� 鏋勫缓鑷 鈫� 鎭㈠鐪熷疄閰嶇疆鈥濈殑鏂瑰紡瀹屾垚銆備笅娆″彂甯冨墠寤鸿鏀逛负浠� `application.yml.example` 鐢熸垚涓存椂璧勬簮锛屽苟鍦ㄧ粍瑁呴樁娈靛悓鏃跺鍒� `backend/web`銆�
+- **Git/宸ヤ綔鍖猴紙鏈鏇存柊鍓嶏級**锛歚HEAD = origin/main = 37f5209`锛涘綋鍓嶆棤宸茶窡韪枃浠舵敼鍔ㄣ�傛湭璺熻釜椤规湁 `_tmp_holiday_verify/`锛堝巻鍙查獙璇佷骇鐗╋級鍜� `docs.zip`锛堢害 31.6 MB锛岀敤鎴锋湰鍦颁骇鐗╋級锛涗簩鑰呭潎淇濈暀锛屾柊瀵硅瘽涓嶈璇垹鎴栬鎻愪氦銆�
+- **涓嬩竴姝�**锛氬闇�閮ㄧ讲锛岀洿鎺ヤ娇鐢ㄤ笂闈㈠彂甯冪洰褰曟垨 zip锛涘闇�缁х画淇鍙戝竷宸ュ叿锛屽厛瀹炵幇鈥滃崰浣嶇妯℃澘鑷姩鍒囨崲 + `backend/web` 鑷姩缁勮 + jar 鍘诲瘑鑷鈥濆悗鍐嶉噸鏂颁骇鍑哄彂甯冨寘銆�
+
+### Windows 寮�鏈鸿嚜鍚紙10-03 杩藉姞锛岀敤鎴烽�夆�滄柟妗� B鈥濓細娉ㄥ唽鎴� Windows 鏈嶅姟锛�
+- **鍏堝洖绛旇繃鐨勯棶棰�**锛歚start-backend.cmd` **涓嶈兘**鐩存帴鍋氬紑鏈鸿嚜鍚紙鏈熬鏈� `pause`銆佹棤鏃ュ織閲嶅畾鍚戙�佷緷璧� PATH锛夈�傜粰鍑� A锛堣鍒掍换鍔★級/B锛圵indows 鏈嶅姟锛�/C 涓夋柟妗堝悗锛岀敤鎴烽�� **B**銆�
+- **鏂板妯℃澘锛堝凡鍏ュ簱锛�**锛�
+  - `deploy-templates/backend/trafficAudit.xml`锛歐inSW 鏈嶅姟閰嶇疆鈥斺�攊d `TrafficAuditBackend`銆乣startmode=Automatic` + `delayedAutoStart=true`锛堢瓑 MySQL 鍏堝氨缁級銆乣onfailure restart 10s/30s/60s` + `resetfailure 1 hour`銆乣workingdirectory=%BASE%`銆佹棩蹇� `logs\trafficAudit.out.log|err.log`锛�10MB 脳 10 婊氬姩锛夈��
+  - `deploy-templates/backend/install-service.ps1`锛氱鐞嗗憳瀹夎/鏌ョ湅/閲嶅惎/鍒犻櫎锛坄-Status/-Restart/-Remove/-NoStart/-JavaPath`锛夛紱鑷姩瀹氫綅 java锛圝AVA_HOME 鈫� PATH 鈫� JavaSoft 娉ㄥ唽琛� 鈫� Program Files锛夊苟鎶婄粷瀵硅矾寰勫啓杩� XML 鐨� `executable` 鍏冪礌锛涢噸澶嶆墽琛屽箓绛夛紱闈炵鐞嗗憳鐩存帴鎷掔粷銆�
+  - `start-backend-service.cmd` + `install-autostart.ps1`锛堣鍒掍换鍔℃柟寮忥級淇濈暀涓�**澶囬��**锛涙敞鎰� `New-ScheduledTask*` 闇� Win8/Server 2012+锛屼笖**涓嶅彲涓庢湇鍔℃柟寮忓悓鏃跺惎鐢�**锛堜細鎶� 8090锛夈��
+  - `pack-deploy.ps1`锛氭柊澧� WinSW 鑾峰彇锛堢紦瀛� `deploy-templates/tools/winsw.exe` 骞舵牎 SHA-256锛岀己鍒欎粠 GitHub 涓嬭浇 v2.12.0 x64锛変笌 `-SkipServiceWrapper`锛涘寘鍐呰緭鍑� `backend\trafficAudit.exe`锛堟敼鍚嶄互鍖归厤 XML 鏂囦欢鍚嶏級銆俙.gitignore` 鏂板 `deploy-templates/tools/`锛�17.4MB 浜岃繘鍒朵笉鍏ュ簱锛夈��
+- **WinSW = Windows Service Wrapper**锛氭妸鏅�氱▼搴忓寘鎴� Windows 鏈嶅姟銆俲ava.exe 鑷繁涓嶆槸鏈嶅姟绋嬪簭锛岀洿鎺� `sc create` 浼氭姤鈥滄湇鍔℃病鏈夊強鏃跺搷搴斿惎鍔ㄦ垨鎺у埗璇锋眰鈥濓紱WinSW 瀹炵幇浜嗘湇鍔℃帶鍒跺崗璁啀鎷夎捣 `java -jar`锛屽苟绠￠噸鍚笌鏃ュ織銆�
+- **瀹炴祴楠岃瘉锛堟湰鏈猴紝鏈湡姝ｅ畨瑁呮湇鍔★級**锛歚trafficAudit.exe status` 鑳借鎵撳寘 XML 骞惰緭鍑� `NonExistent`锛堣В鏋愰�氳繃锛夛紱鏁呮剰鍐欏潖 XML 鈫� `FATAL - The configuration file cound not be loaded`锛堣瘉鏄庤鏍￠獙璺緞鐪熷疄鏈夋晥锛夛紱`install-service.ps1 -Status` 姝ｅ父杈撳嚭鈥滄湭瀹夎鈥濓紝鏃犲弬鏁� / `-Remove` 鍦ㄩ潪绠＄悊鍛樹笅鎶涒�滃繀椤荤鐞嗗憳鈥濅笖涓嶄骇鐢熸敞鍐岄」銆�
+- **韪╁潙锛堥噸瑕侊級**锛歑ML 鏀瑰啓鏈�鍒濈敤姝ｅ垯 `(?s)<executable>.*?</executable>`锛屼細**鍏堝懡涓敞閲婇噷鐨� `<executable>` 瀛楁牱**锛屾妸娉ㄩ噴澶翠笌 service 寮�澶存暣娈靛悶鎺� 鈫� XML 闈炴硶銆傚凡鏀逛负 DOM锛坄SelectSingleNode('/service/executable')`锛夊苟鎶婃敞閲婇噷鐨勮８鏍囩鏀规帀銆傚彟锛氭柊澧炴墦鍖呬唬鐮佹浘澶氫竴涓� `}` 瀵艰嚧璇硶閿欙紝宸茬敤 `Parser::ParseFile` AST 澶嶆牳锛屼袱涓� ps1 鐜板湪璇硶 OK 涓斿潎涓� UTF-8 with BOM銆�
+- **鍏煎鎬э紙鐢ㄦ埛闂�淲in7/Win10/Win11/Server 鏄笉鏄兘鍙互鈥濓級**锛氭湇鍔℃満鍒跺畬鍏ㄤ竴鏍凤紙鑷姩鍚姩/寤惰繜鍚姩/澶辫触閲嶅惎閮芥槸绯荤粺鑳藉姏锛夛紝宸埆鍙湪鍖呰鍣ㄤ緷璧栦粈涔堣繍琛屾椂銆傚疄娴嬩簩杩涘埗锛歚WinSW-x64.exe` 2.12.0 鏄�**鑷寘鍚� .NET 6 鍗曟枃浠�**锛堝惈 `singlefilehost`/`System.Private.CoreLib`/`Microsoft.NETCore.App 6.0.13`/`net6.0`锛夛紝**涓嶉渶瑕佽 .NET Framework**锛涜�佺郴缁燂紙Win7 SP1/2008R2/2012R2锛夎嫢鎶� `api-ms-win-*.dll` 缂哄け锛屽彲鎹㈠畼鏂� `WinSW.NET461.exe`锛�0.6MB锛岄渶 .NET 4.6.1+锛屾敼鍚嶆垚 `trafficAudit.exe` 鍗冲彲锛孹ML 涓嶅姩锛夛紱32 浣嶇郴缁熸崲 `WinSW-x86.exe`銆�
+- **瀹夊叏鎻愮ず**锛歐inSW 瀹樻柟浜х墿**鏈仛 Authenticode 绛惧悕**锛堟湰鏈� `Get-AuthenticodeSignature` = NotSigned锛夛紝鍥犳浠ュ浐瀹� SHA-256 浣滃畬鏁存�ф牎楠岋細`05B82D46AD331CC16BDC00DE5C6332C1EF818DF8CEEFCD49C726553209B3A0DA`锛堜笌 GitHub 鍙戝竷璧勪骇 18,243,033 瀛楄妭涓�鑷达級銆�
+- **鏈獙璇侀」锛堥渶鍦ㄧ洰鏍囨満鍋氫竴娆★級**锛氭湰鏈哄綋鍓嶄笉鏄鐞嗗憳锛�**娌＄湡姝� install 杩囨湇鍔�**锛涘紑鏈鸿嚜鍚�佸け璐ラ噸鍚�佹棩蹇楁粴鍔ㄨ鍦ㄦ湇鍔″櫒涓婃寜 README 3.1 鎵ц涓�娆＄‘璁ゃ��
+- **鏂板寘锛堟湰鍦帮紝涓嶅叆搴擄級**锛歚deploy/traffic-audit-deploy-20261003-3/`锛�393 鏂囦欢 / 110.49 MB锛寊ip 83.77 MB锛夈�傚凡楠岃瘉锛氭湇鍔′笁浠跺鍦� `backend\`銆佸寘鍐� `trafficAudit.exe` SHA-256 涓庡浐瀹氬�间竴鑷淬�乣backend\web` 涓� `frontend/dist` 鍚� 44 鏂囦欢銆乯ar 鍘诲瘑鑷閫氳繃銆佹棤鏄庢枃 key銆�**鏃х殑 `traffic-audit-deploy-20261003/` 涓� `-2/` 宸茶鍙栦唬**锛岄儴缃茶鐢� `-3`锛堟棫鍖呭緟鐢ㄦ埛纭鍚庡啀鍒狅級銆�
+- **杩愯鐘舵�侊紙鍐欐湰鏉℃椂锛�**锛氬紑鍙戠敤鍚庣 8090锛圥ID 43040锛夈�佸墠绔� 8080锛圥ID 43152锛夊潎鍦ㄨ窇锛涙暟鎹簱 `127.0.0.1:3305/traffic_audit`銆�
+- **琛ュ厖鍙搷浣滄�э紙鐢ㄦ埛鍙嶉鈥渂ackend 涓嬫枃浠跺お澶氾紝涓嶇煡閬撴�庝箞鎿嶄綔鈥濓級**锛�
+  - 鏂板鍙屽嚮鍏ュ彛 `deploy-templates/backend/install-service.cmd`锛氳嚜鍔� UAC 鎻愭潈 鈫� 璋� `install-service.ps1`锛涜嫢鎵句笉鍒� `trafficAudit.exe` 鍒欐彁绀衡�滃繀椤绘暣涓� backend 涓�璧锋嫹鈥濄��
+  - `install-service.ps1` 瑁呭畬浼氳嚜宸辨帰娴嬬鍙ｏ紙TCP 鎺㈡祴锛屽吋瀹� PowerShell 2.0锛夛紝鎵撳嵃 OK + 鏈満/瀵瑰缃戝潃锛涜捣涓嶆潵鏃剁洿鎺ユ墦鍗� `logs\*.log` 鏈�鍚� 15 琛岋紱鑻� `application.yml` 鍙ｄ护浠嶅儚鍗犱綅绗︼紝鏈�鍚庡啀鎵撲竴娆￠啋鐩彁绀恒��
+  - `README-閮ㄧ讲璇存槑.txt` 椤堕儴鏂板銆愭湇鍔″櫒涓婂彧瑕佸仛杩� 3 姝ャ��+鈥滃摢浜涜鎷�/鍝簺涓嶇敤鎷封�濓紱`docs/鎵撳寘閮ㄧ讲璇存槑.md` 鐨� 5.4 鏀逛负鈥滃彸閿� `install-service.cmd` 鈫掍互绠＄悊鍛樿繍琛屸�濄��
+  - 涓変釜 `.cmd` 妯℃澘缁熶竴涓� CRLF锛堟柊澧炵殑涓や釜鍘熸潵鏄� LF锛屾壒澶勭悊鍦� Windows 涓婂簲鐢� CRLF锛夈��
+  - 瀹炴祴锛氬己鍒惰蛋鈥滃凡鎻愭潈鈥濆垎鏀椂 `cmd 鈫� install-service.ps1 -Status` 閾捐矾璺戦�氥�乣%*` 浼犲弬姝ｅ父锛沗Test-LocalPort` 瀵� 8090 杩斿洖 True銆佸 8099 杩斿洖 False銆�
+  - 鏂板寘锛歚deploy/traffic-audit-deploy-20261003-4/`锛�394 鏂囦欢 / 110.50 MB锛寊ip 83.78 MB锛夆�斺��**褰撳墠鍞竴鍙敤鍖�**銆�
+- **鍙戝竷鍖呮竻鐞嗭紙10-03 鏅氾紝鐢ㄦ埛纭鈥滃彧鐣� -4鈥濓級**锛氬凡鍒犻櫎 `traffic-audit-release-20261002/`(+zip)銆乣traffic-audit-deploy-20261003/`(+zip)銆乣-2/`(+zip)銆乣-3/`(+zip) 鍙婄┖鐨� `server-fix/`锛宍deploy\` 鐜板湪鍙湁 `traffic-audit-deploy-20261003-4/` 鍜屽畠鐨� zip锛堥噴鏀剧害 671MB锛夈��
+  > 鍥犳鏈枃浠朵笂闈㈡彁鍒扮殑 `deploy/traffic-audit-deploy-20261003/`锛�388 鏂囦欢锛変笌 `deploy/traffic-audit-release-20261002/` 鍧囦负**鍘嗗彶璁板綍**锛岀鐩樹笂宸蹭笉瀛樺湪锛屽埆鍐嶅幓鎵俱��
+- **绱ф�ヤ慨澶嶏紙10-03 鏅氾級锛歚install-service.ps1` 瀵嗙爜瑙ｆ瀽宕╂簝锛屾湇鍔℃牴鏈病瑁呬笂**
+  - 鐜拌薄锛氱敤鎴峰湪鏈嶅姟鍣紙`D:\trafficAudit`锛夊弻鍑� `install-service.cmd`锛屾姤 `鏃犳硶灏嗏�淭rim鈥濈殑鍙傛暟鈥渢rimChars鈥濊浆鎹负绫诲瀷鈥淪ystem.Char鈥漙锛屼綅缃� `install-service.ps1:210`銆�
+  - 鏍瑰洜锛氶偅琛屾槸 `.Trim(' ''', '"')`锛屽叾涓� `' '''` 琚� PowerShell 瑙ｆ瀽鎴愪竴涓�**闀垮害 2 鐨勫瓧绗︿覆**锛堢┖鏍� + 鍗曞紩鍙凤級锛宍Trim(char[])` 鏃犳硶鎶� 2 瀛楃涓茶浆鎴愬崟涓� char 鈫� 鏁磋鎶涘紓甯革紙`MethodArgumentConversionInvalidCastArgument`锛夈��
+  - 淇锛氭妸杩欐鎶芥垚绾嚱鏁� `Test-AppConfigPassword`锛屾敼鍐欎负 `Trim()` 鈫� `Trim("'")` 鈫� `Trim('"')`锛涘苟鍔犺剼鏈骇 `trap`锛屼换浣曞紓甯稿彧鎵撳嵃涓�琛岃鏄� + 琛屽彿锛屼笉鍐嶇敥绾㈠瓧鍫嗘爤銆�
+  - 楠岃瘉锛�8 涓牱鏈紙缂烘枃浠� / 绌哄�� / 涓枃鍗犱綅绗� / 瑁稿�� / 鍙屽紩鍙� / 鍗曞紩鍙� / 鍚┖鏍肩壒娈婂瓧绗� / 鐪熷疄妯℃澘鏂囦欢锛夊叏閮ㄧ鍚堥鏈燂紱鎵撳寘鍐呰剼鏈娉曡В鏋愰�氳繃銆乣-Status` 瀹炶窇姝ｅ父銆侀潪绠＄悊鍛樻椂 trap 杈撳嚭骞插噣閿欒骞� exit 1銆�
+  - 鏁欒锛氳繖鏉″垎鏀箣鍓嶆病琚换浣曟祴璇曡鐩栵紙`-Status` 鎻愬墠 exit銆侀潪绠＄悊鍛樺湪 `Assert-Admin` 灏遍��鍑猴級锛屾墍浠ヨВ鏋愮被閫昏緫瑕佹娊鎴愮函鍑芥暟骞剁敤鏍锋湰娴嬨��
+  - 鍖呭悕锛氫慨澶嶇増閲嶆墦鍖呮椂鑴氭湰澶嶇敤浜嗗凡閲婃斁鐨勫熀纭�鍚嶏紝鏈�缁堝凡鍒犳帀鏃у潖鍖呭苟鏀瑰悕锛宍deploy\` 浠嶇劧鏄�**鍞竴**鐨� `traffic-audit-deploy-20261003-4\`锛堝惈淇鍚庣殑 install-service.ps1锛変笌鍚屽悕 zip銆�
+  - 鐢ㄦ埛渚ф渶灏忎慨澶嶏細鍙渶鐢ㄦ柊鍖呴噷鐨� `backend\install-service.ps1` 瑕嗙洊鏈嶅姟鍣� `D:\trafficAudit\install-service.ps1`锛屽啀閲嶈窇 `install-service.cmd`锛堜笉蹇呴噸鎷� 110MB锛夈��
+- **鏈嶅姟鍣ㄩ儴缃叉垚鍔燂紙10-03 鏅氾紝鐢ㄦ埛纭锛�**锛氭湇鍔″櫒锛堥儴缃茬洰褰� `D:\trafficAudit`锛屾妸 backend 閲岀殑鍐呭鐩存帴閾哄湪璇ョ洰褰曚笅锛夌敤淇鍚庣殑 `install-service.cmd` 瀹夎鏈嶅姟 `TrafficAuditBackend` 鎴愬姛銆�
+  - **寰呯‘璁わ紙灏氭湭楠岃瘉锛�**锛氣憼 閲嶅惎鏈嶅姟鍣ㄥ悗鏄惁鑷姩鍚姩锛堝簲鍚屾椂鐪嬪埌鈥滆嚜鍔� + 寤惰繜鍚姩鈥濓級锛涒憽 8090 鏄惁宸插鍏跺畠鏈哄櫒鏀捐锛圵indows 闃茬伀澧欓粯璁や細鎷﹀叆绔欙級锛涒憿 涓氬姟椤甸潰/瀵煎叆瀵煎嚭楠屾敹銆�
+  - 闃茬伀澧欐斁琛岋紙鑰佺郴缁熶篃鑳界敤锛夛細`netsh advfirewall firewall add rule name="TrafficAudit 8090" dir=in action=allow protocol=TCP localport=8090`
+  - 瑁呭畬鍚庡父鐢細`install-service.ps1 -Status / -Restart / -Remove`锛涙棩蹇楀湪 `D:\trafficAudit\logs\trafficAudit.out.log`锛堥敊璇湅 `trafficAudit.err.log`锛夈��
+
+## 鏈�鏂帮紙2026-10-02锛�
+
+- **鏂版ā鍧楋紙鐢ㄦ埛宸查獙鏀讹紝鏈鎻愪氦/鎺ㄩ�侊級**锛氭柊澧炩�滀笓椤圭粺璁�-閲嶈鑺傚亣鏃モ�濇ā鍧楋紝鍚妭鍋囨棩閰嶇疆銆佽惀涓氭�у娴併�侀潪钀ヤ笟鎬ц溅娴併�佸杩愮郴鏁� 4 寮犺〃锛涚郴缁熼厤缃彍鍗曚粎 admin 鍙淮鎶わ紝涓撻」缁熻-鑺傚亣鏃ユ敮鎸佸鍏ャ�佸鍑恒�佹ā鏉夸笅杞藉拰 Word 蹇姤涓嬭浇銆�
+- **鏁版嵁鍒濆鍖�**锛氫粠 `docs/涓撻」缁熻/閲嶈鑺傚亣鏃�/2026骞村崄涓�鏁版嵁.xlsx` 鍒濆鍖� 2024/2025 骞村崄涓�瀹㈡祦銆佽溅娴佸拰 2024-2026 骞村杩愮郴鏁帮紱婧愯〃 90 涓暟鎹崟鍏冩牸鍏ュ簱閫愰」姣斿宸紓 0銆�
+- **鏃ュ父瀵煎叆鍙ｅ緞**锛氬彧璇诲彇鎵�閫夊勾浠界殑褰撳勾鍒楋紙2026 骞翠负鍚勫娴佸伐浣滆〃 C 鍒椼�佹櫘閫氬浗鐪侀亾 D 鍒楋級锛涘巻鍙插勾浠戒笉瑕佹眰鏃ュ父閲嶅銆�
+- **鍘嗗彶鏁版嵁淇濇姢**锛氬鍏ユ椂鍏堟鏌ユ洿鏃╁巻鍙叉棩鏈熸槸鍚﹁淇敼銆傛湁鍙樺寲鍒欏厛涓嶅啓搴擄紝杩斿洖宸紓娓呭崟锛屽墠绔脊绐楄鐢ㄦ埛閫夋嫨鈥滃厑璁稿鍏�/涓嶅厑璁糕�濓紱纭鍚庢墠瑕嗙洊銆傛帴鍙ｅ弬鏁� `allowHistoricalOverwrite=true`銆�
+- **蹇姤**锛氶粯璁や笅杞界郴缁熸棩鏈熷墠涓�澶╃殑銆婃箹鍖楃渷鍥藉簡鍋囨湡缁煎悎杩愯緭瀹㈡祦蹇姤锛�10鏈圶鏃ワ級.docx銆嬶紝鐢ㄦ埛鍙嚜閫夋棩鏈燂紱鐜瘮/鍚屾瘮鎸夊闀裤�佷笅闄嶃�佹寔骞宠緭鍑恒��
+- **Excel 娴偣绮惧害锛�2026-10-02 杩藉姞锛�**锛氬弬鑰� `docs/Excel娴偣鏁板瓨鍌�.txt`锛屾柊澧� `HolidayNumberUtils`锛坄NumberToTextConverter.toText` + `BigDecimal`锛宍MathContext(15, HALF_UP)`锛夛紱鑺傚亣鏃ユā鍧楃敱 `Double` 鍏ㄩ潰鏀� `BigDecimal`锛涗笁寮犺〃鏁板�煎垪鏀� `DECIMAL(30,15)`锛涘簱鍐� 6 鏉″杩愮郴鏁扮敱 2.3999999999999995 鏍℃涓� 2.4銆傝縼绉昏剼鏈� `docs/sql_holiday_decimal_migration.sql`銆�
+- **鑿滃崟椤哄簭**锛氣�滀笓椤圭粺璁♀�濆凡绉诲埌鈥滄姤琛ㄧ敓鎴愨�濅箣鍚庯紝褰撳墠涓� 鎶ヨ〃鐢熸垚 -> 涓撻」缁熻 -> 瑙勫垯绠＄悊 -> 鐢ㄦ埛绠＄悊 -> 绯荤粺閰嶇疆銆�
+- **鑺傚亣鏃ュ垹闄ゅ娲讳慨澶嶏紙2026-10-02 杩藉姞锛�**锛氬師鍒濆鍖栭�昏緫姣忔鍚姩琛ラ綈缂哄け鐨勭 N 鏃ワ紝瀵艰嚧 admin 鍒犻櫎 2026-10-08 鍚庤閲嶆柊鎻掑叆锛涚幇鏀逛负浠� `holiday_calendar` 鏁磋〃涓虹┖鏃堕娆″垵濮嬪寲銆傞噸鍚悗 2026 骞村崄涓�淇濇寔 10-01 鑷� 10-07 鍏� 7 澶┿��
+- **鏅�氬浗鐪侀亾鐜瘮鍩烘湡锛�2026-10-02 杩藉姞锛�**锛氭櫘閫氬浗鐪侀亾 C 鍒椾负鍙�夌幆姣斿熀鏈燂紝浠� 2026 骞村惎鐢紱濉啓鍚庡彧褰卞搷鏅�氬浗鐪侀亾杞︽祦閲忚嚜韬幆姣� `褰撴棩 / 鍩烘湡 - 1`锛屾湭濉啓鎸夊墠涓�鏃ャ�俙holiday_vehicle_flow.comparison_base` 宸插叆搴擄紝瀵煎叆瀵煎嚭涓庡巻鍙插彉鏇寸‘璁ゅ潎宸叉帴鍏ワ紱鎶樼畻浜哄憳娴佸姩閲忋�佹�讳汉鍛樻祦鍔ㄩ噺鍜� Word 蹇姤缁х画鎸� Excel 鍘熷叕寮忥紝涓嶅彈鍩烘湡褰卞搷銆�2024/2025 涓嶄娇鐢ㄣ��
+- **蹇姤棣栨棩鍙ｅ緞锛�2026-10-02 杩藉姞锛�**锛氬亣鏈熺1澶╂病鏈夊墠涓�鏃ョ幆姣斿熀鏁帮紝姝ｆ枃涓嶈緭鍑衡�滅幆姣斿闀�/涓嬮檷/鎸佸钩鈥濈煭璇紝琛ㄦ牸褰撴棩鐜瘮鍒椾负鈥溾�斺�濓紱绗�2澶╄捣浠嶆寜瀹為檯鍓嶄竴鏃ヨ緭鍑虹幆姣斻�傚凡鐢� 2025-10-01/02 蹇姤鍥炲綊楠岃瘉銆�
+- **蹇姤鐧惧垎姣旂簿搴︼紙2026-10-02 杩藉姞锛�**锛歐ord 蹇姤涓悓姣�/鐜瘮鐧惧垎姣旂粺涓�淇濈暀1浣嶅皬鏁帮紙濡�6.79%鏄剧ず6.8%銆�11.46%鏄剧ず11.5%锛夛紱浜烘銆佽溅娴佺瓑涓氬姟鏁板�间粛淇濈暀2浣嶅皬鏁般��
+- **楠岃瘉缁撴灉**锛氬悗绔紪璇戙�佸墠绔瀯寤恒�佹潈闄�/CRUD/璐熷悜瀵煎叆銆佸巻鍙插彉鏇翠袱闃舵瀵煎叆銆丒xcel 瀵煎嚭銆乄ord 蹇姤銆佸墠绔� admin/闈� admin 鐑熸祴鍧囬�氳繃锛涜彍鍗曢『搴忋�佸杩愮郴鏁� 2.4 灞曠ず锛堢郴缁熼厤缃〉 + 鑺傚亣鏃ョ粺璁￠〉锛夈�乣decimal(30,15)` 鍒楀瀷銆佸巻鍙插彉鏇翠袱闃舵瀵煎叆鍥炲綊鍧囧凡瀹炴祴锛涘姛鑳芥祴璇曟姤鍛婁笌宸ヤ綔鏃ョ粨鎸� 2026-09-27 鎻愪氦瑙勮寖浠呮湰鍦扮暀瀛橈紙涓嶅叆搴擄級锛歚docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_閲嶈鑺傚亣鏃ヤ笓椤圭粺璁2026-10-02.md`銆乣docs/宸ヤ綔鏃ョ粨/宸ヤ綔鏃ョ粨_2026-10-02.md`銆�
+- **杩愯鐘舵��**锛氬悗绔� 8090銆佸墠绔� 8080 宸插惎鍔紱鏁版嵁搴� `127.0.0.1:3305/traffic_audit`銆傛祴璇曚骇鐢熺殑 2026 涓存椂鏁版嵁鍜屽鍏ユ壒娆″凡娓呯悊銆�
+- **鍏虫満鏀跺熬锛�2026-10-02锛�**锛氬凡鍋滄帀鏈寮�鍙戠敤鍚庣 8090銆佸墠绔� 8080 鍙婂悇鑷繘绋嬫爲锛岀鍙ｅ潎宸查噴鏀撅紱MySQL 鏈嶅姟淇濈暀銆傚綋鍓嶅彲瀹夊叏鍏虫満銆�
+- **Git**锛氱敤鎴峰凡浜� 2026-10-02 鏄庣‘楠屾敹閫氳繃锛涙湰娆℃寜瑕佹眰鍚堝苟杩滅 `origin/main` 鍚庢彁浜ゅ苟鎺ㄩ�侊紝涓嶈鐩栬繙绔悓浜嬫彁浜ゃ��
+- **閮ㄧ讲妯℃澘鍚屾**锛氳妭鍋囨棩 4 寮犺〃宸插悓姝ュ埌 `deploy-templates/db/init.sql`锛沗sql_holiday.sql` 鍙婁袱涓棫搴撹縼绉昏剼鏈殢閮ㄧ讲鍖呭彂甯冿紝閬垮厤鏂板寘缂鸿〃銆�
+
+## 鏈�鏂帮紙2026-09-28锛�
+
+- **鐢ㄦ埛鐢� WPS 缂栬緫姣嶇増**锛氭敼銆婄彮绾垮寘杞︺�嬭竟妗嗐�併�婇亾璺繍杈撳懆杞噺銆嬪瓧鍙凤紝骞跺垹闄ゃ�婁腑鍙ｅ緞鏄庣粏銆媊AW` 鍒楋紙鎵嬪伐瀹氱鍚屽垹锛夈�傚凡楠岃瘉鐢熸垚绔甯革細涓彛寰勬槑缁� 2024 鍙婃洿鏃╁潡鏁翠綋宸︾Щ锛堣法椤�/鍚岄〉鍏紡鑷姩鏀瑰紩鐢紝`#REF!` 2鈫�0锛夈�佷腑鍙ｅ緞鎺掑悕鍧� J..R 鈫� A..I 鍧囨纭甫鍏ヤ骇鐗┿��
+- **鈿狅笍 WPS 淇濆瓨鐨勮繛甯︽崯鍧忥紙寰呭洖琛ワ級**锛氥�婄彮绾垮寘杞︺��2019/2020 鍧楃害 **590 鏍�**鍐呭涓㈠け锛坄FN/FO/FM`銆乣FP:FT`銆乣GE` 鍙樼┖锛沗EO/EQ/ES/EU/EW/EY/DT/DW...EM` 鍏� **144 鏍�**鍙� `#DIV/0!`锛夈�傜敓鎴愪欢宸插甫鍑猴紙璇ラ〉 `#DIV/0!` 228鈫�372锛夈��**寰呯敤鎴风‘璁ゅ悗鎸夊浠�/瀹氱鍥炶ˉ锛堝彧琛ュ�间笌鍏紡锛屼繚鐣欏叾杈规涓庡瓧鍙凤級銆�**
+- **鍙ｅ緞钀藉湴銆岀己鏁扮暀绌恒��**锛氭瘝鐗堛�� 璐ц繍銆嬭 90/93锛堜粰妗� 瑙勪笂涓よ锛夈��108/111锛堟灄鍖猴級鍦� 2021銆�2022 骞村潡鐨� 78 涓� `0` 鍊煎凡娓呯┖锛堜笌鎵嬪伐瀹氱鎸夎〃澶村榻愰�愭牸鏍稿锛氭瘝鐗�=0 涓斿畾绋�=绌� 78 鏍笺�佸啿绐� 0 鏍硷級锛涗唬鐮� `FreightCalc.buildMetrics` 褰撴湀鍒嗘敮鏀逛负銆岃鏈堟棤瑙勪笂璁板綍 鈫� 鐣欑┖銆嶏紝涓嶅啀鍐� 0锛堢疮璁″垎鏀笉鍙橈級銆�
+- **绾犳涓�鏉￠敊鍒�**锛氭鍓嶃�岀▼搴忓皯涓�鍒� 11 鏈堢幆姣斻�嶄笉鎴愮珛鈥斺�旂敓鎴愪欢涓庢墜宸ュ畾绋跨殑鐜瘮鏈熼棿闆嗗悎瀹屽叏涓�鑷达紙12鏈堚��1鏈� 鍏� 12 鍒楋級锛涘樊寮傛牴鍥犳槸鎵嬪伐瀹氱銆� 璐ц繍銆嬪湪 2025 骞村潡澶氫竴鍒�**鏃犺〃澶磋緟鍔╁垪**锛坄U`锛�74 鏍硷級锛岃嚜璇ュ垪璧锋墜宸ユ暣浣撳彸绉� 1 鍒椼��**姣斿蹇呴』鎸夎〃澶存湡闂村榻愶紝涓嶈兘鎸夊垪浣嶇疆姣斻��**
+- **楠岃瘉**锛氱敓鎴愪袱娆★紙绾� 15 绉�/娆★級锛岀浜屾鐩稿绗竴娆�**浠� 78 鏍� 0鈫掔┖**锛岄敊璇�兼暟閲忎笉鍙橈紱`鍏氦!S5=98460.97` 绛夌紦瀛樺�兼娊鏌ヤ繚鐣欍��
+- **杩愯鐘舵��**锛氬悗绔凡鎸� `start-dev.ps1` 閲嶅惎锛堟柊 PID锛�8090/8080 鍦ㄨ窇锛夛紱鏈満搴撲粛涓� `localhost:3308/traffic_audit`銆�
+- **鉁� 鐝嚎鍖呰溅鍥炶ˉ瀹屾垚锛�09-28 涓嬪崍锛�**锛氱敤鎴风‘璁ゅ悗鎸� 09-27 姣嶇増澶囦唤锛坄_bak_202608姣嶇増鏂囨湰鏁板瓧杞暟鍊煎墠_20260927.xlsx`锛塜ML 绮惧噯鍥炶ˉ銆婄彮绾垮寘杞︺��2019/2020 鍧� 鈥斺�� **璇ラ〉涓� 09-27 姣嶇増閫愭牸涓�鑷达紙0 宸紓锛�**锛岄敊璇�煎洖鍒� `#REF!` 8 / `#DIV/0!` 228锛涙瘝鐗堝叾瀹冮〉鏈彈褰卞搷銆傞獙鏀剁敓鎴愶細涓� 09-27 鐢熸垚浠� (6) 姣斿閿欒鍊奸�愰〉涓�鑷达紝宸紓浠呭墿鏃㈠畾鏀瑰姩锛坄 璐ц繍` 78 鏍兼竻 0銆佷腑鍙ｅ緞鏄庣粏 4915 鏍煎垹鍒椾綅绉汇�佷腑鍙ｅ緞鎺掑悕 672 鏍煎潡浣嶇Щ銆佺彮绾垮寘杞� 82 鏍兼诞鐐瑰熬宸�/0-绌猴級銆�
+- **宸紓娓呭崟鍙ｅ緞鏇存柊锛�09-28锛岀敤鎴风‘璁わ級**锛氣憼 ` 璐ц繍` 鏂板鐨勩�岃涓�+瑙勪笅璐ц繍閲忋�嶃�岃涓嬭揣杩愰噺銆嶅悇 17 琛岋紙姣嶇増璁捐锛屽叡 34 琛岋級涓嶈宸紓锛涒憽 ` 璐ц繍!U5:U112` 鏃犺〃澶磋崏绋垮垪涓嶈锛涒憿 鎺掑悕琛ㄣ�屽綋鏈堝潡銆嶄负姣嶇増璁捐涓嶈锛涒懀 甯傚窞鐭悕/鍏ㄥ悕涓嶅奖鍝嶏紙宸ュ叿褰掍竴鍖栵級锛涒懁 灏忓樊寮傦紙鍙栨暣灏惧樊/鏂囨湰鍨嬫暟瀛楋級鍙鏁帮紝鍙垪宸紓澶х殑骞堕檮鍘熷洜銆傚伐鍏� `docs/宸ュ叿/姹囨�诲ぇ琛ㄥ樊寮傛瘮瀵�.py` 宸叉寜姝ゆ洿鏂帮紝涓や唤娓呭崟宸查噸鐢熸垚銆�
+- **鏂板彂鐜帮紙寰呮牳瀵癸級**锛歚鐝嚎鍖呰溅!EO36/FN36/FO36`锛堣崋闂� 瀹㈣繍閲� 2020 绱/绱鍚屾瘮锛�**绋嬪簭鐢熸垚鏃堕噸绠椾负 -2731.41 / -1.0008 / -1.0002**锛岃�屾瘝鐗堜笌鎵嬪伐瀹氱鍧囦负 0.181777 / 2312.2199 / -0.586419 鈫� 鐤戞瘝鐗� 2020 骞村潡鍒嗘瘝涓� 0锛岄渶鏍稿鍏紡涓庢暟鎹��
+- **姹囨�诲ぇ琛ㄥ樊寮傛瘮瀵癸紙09-28锛屽伐鍏峰凡鍥哄寲鍙ｅ緞锛�**锛歚docs/宸ュ叿/姹囨�诲ぇ琛ㄥ樊寮傛瘮瀵�.py`锛堥�愰〉鎸夎/鍒楁爣绛惧簭鍒楀榻愶紝鍙鐞嗗鍒�/澶氳/閲嶅琛ㄥご锛夈��**娓呭崟灞炶繃绋嬩骇鐗╁彧鐣欐湰鍦�**锛坄docs/闂姹囨��/_娓呭崟_*.md/.csv`锛屽凡 gitignore 涓嶅叆搴擄級銆�
+  - 宸茬‘璁ゅ彛寰勶紙涓嶅啀閲嶅纭/涓婃姤锛夛細鈶� 璐ц繍姣忓競宸� 6 琛� vs 鎵嬪伐 4 琛岋紙鏂板銆岃涓�+瑙勪笅璐ц繍閲忋�嶃�岃涓嬭揣杩愰噺銆嶅悇 17 琛岋級灞炴瘝鐗堣璁★紝琛屽彿鍋忕Щ鎸�"鍦板尯+鎸囨爣"瀵归綈鍚庝竴鑷达紱鈶� ` 璐ц繍` U 鍒楋紙U2:U118锛変负浜哄伐鑽夌锛涒憿 浠呮墜宸ユ湁涓�**鏃犺〃澶�**鐨勫垪 = 鑽夌锛涒懀 娴偣灏惧樊銆佹枃鏈瀷鏁板瓧蹇界暐锛涒懁 鎺掑悕琛ㄣ�屽綋鏈堝潡銆嶄负姣嶇増璁捐锛涒懃 甯傚窞鐭悕/鍏ㄥ悕涓嶅奖鍝嶃��
+  - **闇�澶勭悊锛堟暟鍊硷級**锛歚鐝嚎鍖呰溅!EO36/FN36/FO36`锛堣崋闂� 瀹㈣繍閲� 2020 绱/绱鍚屾瘮锛夆�斺�旂▼搴忕敓鎴愭椂閲嶇畻涓� -2731.41 / -1.0008 / -1.0002锛屾瘝鐗堜笌鎵嬪伐瀹氱鍧囦负 0.181777 / 2312.2199 / -0.586419锛堢枒姣嶇増 2020 骞村潡鍒嗘瘝涓� 0锛夛紝寰呮牳瀵癸紱` 璐ц繍` 2022 骞村悇甯傚窞銆岀疮璁″悓姣斻��10 鏉★紙涓氬姟宸茬‘璁�**杞欢瀵�**锛屼笉鏀癸級銆�
+  - 鍏朵綑寰呭姙锛氭墜宸ヤ晶 4 澶勮剰鏁版嵁锛坄鐝嚎鍖呰溅!IL4/IL5` 鏂摼銆乣IL50` 鍙嶅紩鍙枫�乣 璐ц繍!EA93/EA111` 鐨� `#DIV/0!`锛夈��286 鏍兼枃鏈瀷鏁板瓧銆�304 鏍艰崏绋垮垪锛涙瘝鐗� 11 涓� `#REF!` + 356 涓� `#DIV/0!`锛沗鍩庡競瀹㈣繍` 绗� 2 琛岀 3 涓湀璧疯〃澶翠负鏃ユ湡搴忓垪鍙凤紱缂� 2026-09 姣嶇増锛涘鍑哄墠鍩烘暟浣撴锛圥0-3锛夈��
+- **09-28 鏀跺熬锛歚鐝嚎鍖呰溅` 3 鏍奸噸绠楅棶棰樺凡淇�**锛歚EO36`/`FN36`/`FO36` 鍦ㄦ瘝鐗堥噷鏀逛负**闈欐�佸��**锛�0.181777001400256 / 2312.2199 / -0.586418964965219锛屼笌鎵嬪伐瀹氱涓�鑷达級锛屽苟鎶婂彈褰卞搷鐨勫叡浜叕寮忕粍瀛ゅ効瀛愭牸锛�35 鏍硷級涓�骞堕潤鎬佸寲锛堝�奸浂鍙樺寲锛夈�傞噸鏂扮敓鎴愰獙璇侊細鐢熸垚浠�/姣嶇増/瀹氱涓夎竟涓�鑷达紝涓庝笂涓�鐗堢敓鎴愪欢浠� 34 鏍间负绮惧害琛ㄧず宸紓銆佹棤鏁板�煎彉鍖栥��
+- **褰撳墠"闇�澶勭悊"浠呭墿 16 鏉�**锛堝潎灞炴墜宸ヤ晶/涓氬姟宸茬‘璁わ紝闈炵▼搴忛棶棰橈級锛歚 璐ц繍` EA92~EA112 鍏� 12 鏉★紙2022 鍚勫競宸炵疮璁″悓姣旓紝2021 骞村熀鏁板彛寰勪笉鍚岋紝涓氬姟宸茬‘璁よ蒋浠跺锛涘惈鎵嬪伐 `#DIV/0!` 2 鏉★級銆乣鐝嚎鍖呰溅` IL4/IL5锛堟墜宸� `#REF!`锛�/IL50锛堟墜宸ュ弽寮曞彿锛�3 鏉°�乣鍩庡競姹囨��!G20` 琛ㄥご鎺緸 1 鏉°�傚叾浣欏叏閮ㄦ寜鍙ｅ緞蹇界暐锛堣崏绋垮垪/琛屽彿鍋忕Щ/褰撴湀鍧�/娴偣灏惧樊/鏂囨湰鍨嬫暟瀛楋級銆�
+- **鏈竻椤癸紙鏈夋剰淇濈暀锛�**锛氭瘝鐗� 11 涓� `#REF!` + 356 涓� `#DIV/0!` 鍘嗗彶閿欒鍊兼湭娓呪�斺�旀墜宸ュ畾绋垮悓绫荤害 15 + 358锛屽崟娓呬竴杈逛細鍑┖澶氬嚭鍗曡竟宸紓锛涜娓呴渶涓よ竟涓�璧枫��
+- **纭宸紓娓呭崟锛堟湰鍦帮級**锛歚docs/闂姹囨��/_宸茬‘璁ゅ樊寮傛竻鍗昣2026-08_20260928.md`锛堜笉鍏ュ簱锛夈��
+- **09-28 鍙ｅ緞鍏ㄩ儴钀藉湴锛屽樊寮傛竻鍗�"闇�澶勭悊"褰掗浂**锛�
+  - 鈶� 鎸夎蒋浠讹細鎵嬪伐瀹氱銆� 璐ц繍銆婨B64~EB78 绛� 12 鏍� 2022 绱鍚屾瘮 + 銆婄彮绾垮寘杞︺�婭L4/IL5/IL50 宸叉寜杞欢鍊煎悓姝ワ紙澶囦唤 `2026骞�8鏈堝杩愰噺銆佽揣杩愰噺瀹氱_鍚屾杞欢鍓峗20260928.xlsx`锛夈��
+  - 鈶� 鎸夋墜宸ョ粺涓�鎺緸锛氭瘝鐗堛�婂煄甯傛眹鎬�!G20銆嬫敼涓烘墜宸ュ啓娉�"2025骞�1-12鏈堝叏鐪佺疮璁″畬鎴愬煄甯傚杩愰噺鎯呭喌"锛堝浠� `_bak_202608姣嶇増_0928鎺緸鍓�.xlsx`锛夈��
+  - 鈶� 鍘嗗彶閿欒鍊肩暀鐧斤細姣嶇増 363 鏍硷紙`_bak_202608姣嶇増_0928鐣欑櫧鍓�.xlsx`锛夈�佹墜宸ュ畾绋� 379 + 灏惧垪 6 鏍硷紙`..._鐣欑櫧灏惧垪鍓峗20260928.xlsx`锛夆啋 涓よ竟鐜板潎涓� 0 涓� `#REF!`/`#DIV/0!`銆�
+  - 缁撴灉锛氭寜褰撳墠姣嶇増閲嶆柊鐢熸垚 2026-08 鍚庯紝涓庢墜宸ュ畾绋跨殑**闇�澶勭悊宸紓 = 0**锛屽叾浣欏叏閮ㄨ惤鍦�"宸插拷鐣ワ紙绾﹀畾宸紓锛�"銆傛竻鍗曪細`docs/闂姹囨��/_娓呭崟_姣嶇増鏈�鏂扮敓鎴愪欢_20260928.md/.csv`锛堟湰鍦帮紝涓嶅叆搴擄級銆�
+  - 娉ㄦ剰锛氭闈㈤偅浠� `鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃_2026-08.xlsx` 鏄棫瀵煎嚭锛堝惈鏃ч敊璇��/鏃у熀鏁帮級锛屼笌鏇存柊鍚庣殑瀹氱姣斿浼氭樉绀鸿緝澶氬樊寮傦紝浠�"姣嶇増閲嶆柊鐢熸垚浠�"涓哄噯銆�
+- **鏃犺〃澶磋崏绋垮垪娓呭崟锛�9 澶勶紝鍏� 539 鏍硷級**锛歚鍏氦/鍑虹/缃戠害杞�!U`锛堝悇 72锛夈�乣鍩庡競瀹㈣繍!U`锛�36锛夈�乣鐝嚎鍖呰溅!DU`锛�55锛岃〃澶�"1-3鏈堢疮璁�"锛夈�乣涓彛寰勬槑缁�!U`锛�90锛夈�乣涓彛寰勫杩愰噺!AB`锛�180锛夈�乣 璐ц繍!V` 涓� ` 璐ц繍!AX`锛堝悇 74锛岀敤鎴锋墍鎸� U 鍒楀湪鎵嬪伐閭ｄ唤鍙崇Щ涓�鍒楋級銆傛瘝鐗�/鐢熸垚浠�**宸插叏閮ㄦ竻绌�**锛屾墜宸ュ畾绋夸粛淇濈暀 鈫� 瀵规瘮鏃跺綊鍏ャ�屽凡鐭ヨ璁�(鏃犺〃澶磋崏绋垮垪)銆嶃�傚叾浣�"鏃犺〃澶村垪"鏄悎骞惰〃澶寸殑姝ｅ父鍒楋紙` 璐ц繍!C鈥` 鏈堜唤鍊煎垪銆佸悇骞村潡灏鹃儴绱/绱鍚屾瘮鍒椼�佹帓鍚嶉〉 R 鍒楃瓑锛夛紝涓よ竟閮芥湁銆侀潪鑽夌銆傛槑缁嗚 `docs/闂姹囨��/_宸茬‘璁ゅ樊寮傛竻鍗昣2026-08_20260928.md`銆�
+- **寰呭姙**锛氣憼 鎺掑悕椤电粨鏋勶紙鍧楅『搴忋�佹爣棰樻帾杈炪�佸競宸炲悕鐭悕/鍏ㄥ悕銆佸懆杞噺鎺掑悕澶� 7 琛岋級锛涒憽 鎺掑悕椤电粨鏋勶紙鍧楅『搴忋�佹爣棰樻帾杈炪�佸競宸炲悕鐭悕/鍏ㄥ悕銆佸懆杞噺鎺掑悕澶� 7 琛岋級锛涒憿 缂� 2026-09 姣嶇増銆佸鍑哄墠鍩烘暟浣撴锛圥0-3锛夈��
+
 ## 鏈�鏂帮紙2026-09-27锛�
 
 - **鎻愪氦瑙勮寖鏀逛负鍚屼簨鏂瑰紡锛堢敤鎴� 09-27 鍐冲畾锛屽凡鍐欏叆 AGENTS.md锛�**锛�

--
Gitblit v1.9.1