From a29387d17c69d3eb8eb6ee879e8e0bfa72662c0a Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期日, 13 九月 2026 17:46:11 +0800
Subject: [PATCH] docs: 部署说明新增 Navicat .nb3 备份/还原路线（含格式解析与步骤），并标注 8/27 旧备份已过期

---
 docs/工作日结/工作日结_2026-09-13.md |   41 +++++++++++++++++++++++++++++++++++++++--
 1 files changed, 39 insertions(+), 2 deletions(-)

diff --git "a/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-13.md" "b/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-13.md"
index 7824b7b..a02a4f0 100644
--- "a/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-13.md"
+++ "b/docs/\345\267\245\344\275\234\346\227\245\347\273\223/\345\267\245\344\275\234\346\227\245\347\273\223_2026-09-13.md"
@@ -33,6 +33,43 @@
 - 銆婂姛鑳芥祴璇曟姤鍛奯姹囨�诲ぇ琛ㄥ洓椤垫暟鎹┍鍔╛2026-09-13.md銆嬪啓鍏� `docs/鍔熻兘娴嬭瘯鎶ュ憡/`銆�
 - 鏈�婂伐浣滄棩缁撱�嬨��
 
+
+### 7. 鎻愪氦涓庡彂甯�
+- 鎻愪氦 `ea7cc07`锛坄ReportExportService.java` + 銆婂姛鑳芥祴璇曟姤鍛奯姹囨�诲ぇ琛ㄥ洓椤垫暟鎹┍鍔╛2026-09-13.md銆� + 鏈�婂伐浣滄棩缁撱�嬶紝3 鏂囦欢 +689 鈭�2锛夊凡鎺ㄩ�佸弻浠撳簱锛歚git push gitea main`锛坄09e612a..ea7cc07`锛夈�乣git push origin main:master`锛坄09e612a..ea7cc07`锛夛紝骞� `git branch -f master main`銆�
+- 鎺ㄩ�佸墠 `git fetch gitea` / `git fetch origin` 鍧囨棤鏂版彁浜わ紙`rev-list --left-right --count` = `0 0`锛夛紝鏈鐩栧悓浜嬩唬鐮併��
+- 鍙戝竷鍚庡璺� 2026-08 瀵煎嚭锛圚TTP 200 / 950,783 瀛楄妭 / 29.2 绉掞級锛屽鍙戝竷鍚庝骇鐗� `_t4_2026-08.xlsx` 鍐嶅仛 586 鏍肩嫭绔嬪鏍� = 宸紓 0 鏍硷紱涓庡彂甯冨墠浜х墿閫� zip 鏉＄洰姣斿锛屽唴閮ㄦ潯鐩瓧鑺傚畬鍏ㄤ竴鑷达紙MD5 宸紓浠呮潵鑷� zip 澶存椂闂存埑锛夈��
+
+
+### 8. 鎵撳寘閮ㄧ讲鏀寔锛堢敤鎴锋柊闇�姹傦細閮ㄧ讲鍒板彟涓�鍙版満鍣級
+- 鏂板涓�閿墦鍖呰剼鏈� `package-deploy.py`锛氬墠绔� `npm run build` 鈫� `dist` 鍐呭祵杩涘悗绔� jar锛堟嫹鍏� `resources/static`锛夆啋 `mvn clean package` 鈫� 娓呯┖ static 鈫� 缁勮 `deploy/traffic-audit-deploy-YYYYMMDD/` 鈫� 鍘嬬缉 `traffic-audit-deploy-YYYYMMDD.zip`锛堟湰娆� 69.9 MB / 246 鏂囦欢锛宩ar 55.5 MB锛夈��
+- 閮ㄧ讲鍖呯粨鏋勶細`backend/`锛坖ar + docs + application.yml + start-backend.cmd/.sh锛夈�乣frontend/`锛坉ist + nginx 绀轰緥锛夈�乣db/`锛坕nit.sql + sql_city_bus/taxi/wyc.sql锛夈�丷EADME銆�
+- **淇閮ㄧ讲闄烽槺**锛歚jwt.secret` 濉垚闈炴硶 Base64锛堝涓枃锛変細璁╃櫥褰曟帴鍙� 500锛坖jwt 0.9.1 鎸� Base64 瑙ｇ爜 secret锛夆啋 `JwtUtils` 鏂板 `secretKeyBytes()` 鍏滃簳锛圔ase64 浼樺厛銆佸惁鍒� UTF-8 瀛楄妭 + WARN锛夈��
+- 鏇存 `docs/鎵撳寘閮ㄧ讲璇存槑.md` 涓夊涓嶅疄锛氣憼 涓嶉渶瑕� Redis锛坧om 鏃犱緷璧栥�佷唬鐮佹湭鐢級锛涒憽 鍓嶇鏀逛负鍐呭祵杩� jar锛堟棫璇存槑绉般�屽凡鍐呯疆 file:./web/銆嶏紝瀹為檯 jar 鍐呮棤闈欐�佹枃浠讹級锛涒憿 琛� `sql_wyc.sql` 涓� `summary.template-dir`銆�
+- 鐙珛楠岃瘉锛氭妸閮ㄧ讲鍖� backend 鎷峰埌 `_deploytest/` 鐢� 8091 绔彛鐙珛鍚姩 鈫� 鍚姩鎴愬姛銆乣GET /` 200 鏈� `#app`銆侀潤鎬� js 200銆佺櫥褰� 200 鎷垮埌 token銆佸鍑烘眹鎬诲ぇ琛� 200 / 950,783 瀛楄妭锛堜笌寮�鍙戞満浜х墿鍚屽昂瀵革級锛涘彟娴嬩腑鏂� secret 鍏滃簳璺緞鍚屾牱 200銆�
+- 寮�鍙戞満鍚庣宸叉寜鏂颁唬鐮侀噸鍚紙鏃� PID 27840 宸插仠锛夛紝閲嶅惎鍚庣櫥褰� 200銆佸鍑� 950,783 瀛楄妭锛屾棤鍥炲綊銆�
+- 鎶ュ憡锛歚docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_閮ㄧ讲鍖呮墦鍖呬笌鐙珛鍚姩_2026-09-13.md`銆�
+
+
+### 9. 鏁版嵁搴撴惉杩佹敮鎸侊紙鍥炵瓟銆岃兘涓嶈兘鐩存帴澶囦唤鏁版嵁搴撹繃鍘汇�嶏級
+- 缁撹锛氬彲浠ワ紝涓旀瘮璺� 4 涓缓琛ㄨ剼鏈洿鐪佷簨銆傚凡鍦ㄣ�婃墦鍖呴儴缃茶鏄庛�嬮噷琛ャ�岃矾绾� A 绌哄簱 4 鑴氭湰 / 璺嚎 B 鏁村澶囦唤杩樺師銆嶄簩閫変竴璇存槑锛屽苟鏍囨敞 **init.sql 鏄牬鍧忔�х殑锛堝熀纭�琛ㄩ兘甯� DROP TABLE锛�**锛屽凡鏈夋暟鎹殑搴撲笂涓嶈兘閲嶅鎵ц銆�
+- 鐢熸垚澶囦唤 `traffic_audit_full_20260913.sql`锛�45.5 MB锛宮ysqldump --databases锛屽惈寤哄簱璇彞涓庡叏閮� 29 寮犺〃鏁版嵁锛夈��
+- 杩樺師楠岃瘉锛氭妸澶囦唤閲岀殑搴撳悕鏀规垚涓存椂搴� `traffic_audit_vfy` 瀵煎叆锛岄�愯〃 `COUNT(*)` 涓庢簮搴撴瘮瀵� 鈥斺�� **29 寮犺〃 0 宸紓**锛屾娊鏌� `wyc_order_monthly` 2026-08 琛屾暟姝ｇ‘锛岄獙璇佸悗鍒犻櫎涓存椂搴撱��
+- 椤哄甫纭锛氬彟澶� 3 涓剼鏈紙sql_city_bus/taxi/wyc锛夋病鏈� `USE` 璇彞锛屽繀椤� `-D traffic_audit` 鎵ц锛沬nit.sql 鑷甫寤哄簱璇彞鍙嫭绔嬫墽琛屻��
+
+
+### 10. 澶囦唤杩樺師鐨勭増鏈牳鏌ヤ笌寮洪獙璇侊紙澶嶆煡鍙戠幇鐨勯棶棰橈級
+- 澶嶆煡鍙戠幇涓や釜姝ゅ墠琛ㄨ堪涓嶅噯鐨勭偣锛氣憼 鏈満 **MySQL 鏈嶅姟绔槸 8.0.29**锛坄D:\mysql\mysql-5.7.41-winx64` 鍙槸 5.7 瀹㈡埛绔伐鍏凤級锛屾槰鏅氭寜銆屾湰鏈烘槸 5.7銆嶅啓鐨勮鏄庝笉鍑嗙‘锛涒憽 29 寮犺〃鐨勬帓搴忚鍒欑粺涓�涓� `utf8mb4_0900_ai_ci`锛�**鐩爣鏈哄繀椤昏 MySQL 8.0锛�5.7 浼氬鍏ュけ璐�**銆�
+- 鍥犳鏀圭敤涓庢湇鍔＄鍚岀増鏈殑 `C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqldump.exe` 閲嶆柊瀵煎嚭澶囦唤 `traffic_audit_full_20260913.sql`锛�45.5 MB锛夈��
+- 寮洪獙璇侊紙8.0 瀹㈡埛绔級锛氬浠芥敼搴撳悕瀵煎叆涓存椂搴� `traffic_audit_vfy` 鈫� 琛ㄦ暟閲� 29=29銆佽〃鍚嶄竴鑷淬��**閫愯〃 `SHOW CREATE TABLE` 缁撴瀯宸紓 0**銆�**閫愯〃 `COUNT(*)` 琛屾暟宸紓 0**銆佹娊鏌� `wyc_order_monthly` 2026-08 `order_sum` 涓�鑷� 鈫� 楠岃瘉鍚庡垹闄や复鏃跺簱銆�
+- 閮ㄧ讲璇存槑宸插悓姝ユ洿姝ｏ紙鐜瑕佹眰琛ㄣ�佽矾绾� B 鍛戒护涓庣増鏈鏄庛�乣DROP TABLE` 瑕嗙洊璀﹀憡锛夈��
+
+
+### 11. 鏌ヨ瘉 Navicat .nb3 澶囦唤鏍煎紡锛堝洖绛斻�屼笉鏄彲浠ユ墦鍖呮垚涓�涓枃浠剁洿鎺ヨ繕鍘熷悧銆嶏級
+- 鐢ㄦ埛璁板繂涓殑銆屼竴涓枃浠剁洿鎺ヨ繕鍘熷浠姐��= Navicat 绉佹湁鏍煎紡 **`.nb3`**锛涙湰鏈哄凡鏈� 8/27 閭ｄ唤锛歚D:\鏂囨。\Navicat\MySQL\Servers\mysql80\traffic_audit\20260827152017.nb3`锛�**宸茶繃鏈�**锛�27 寮犺〃銆佺己缃戠害杞︿袱寮犮�佹暟鎹仠鍦� 8/27锛夈��
+- 瑙ｆ瀽鍑烘牸寮忥細`tar` 瀹瑰櫒 = 姣忓紶琛� `<uuid>.meta.json.gz`锛圖DL/瀛楁锛�+ `<uuid>.data.000NN.sql.gz`锛坓z 鏁版嵁鍒嗙墖锛�+ 鏈熬鏈帇缂� `meta.json`锛圖atabaseType/Schema/Objects[UUID,Type,Name,Rows,Metadata{Filename,Checksum}]锛夛紱`Checksum` 缁忓疄娴嬪氨鏄 meta 鏂囦欢鐨� **SHA1锛堝ぇ鍐欙級**銆�
+- 缁撹涓庡缓璁細`.nb3` 鍙兘鐢� Navicat 鑷韩鐢熸垚銆佷篃鍙兘鐢ㄣ�岃繕鍘熷浠姐�嶈繕鍘燂紝**鐢� .sql 鐐广�岃繕鍘熷浠姐�嶅繀鐒跺け璐�**锛涙垜鏃犳硶鍦ㄥ懡浠よ渚у彲闈犲悎鎴愬苟楠岃瘉 Navicat 鏄惁鎺ュ彈锛屾墍浠ヤ笉鎻愪緵鎵嬪伐鎷肩殑 .nb3锛屾敼涓哄湪鏂囨。閲屽啓娓呫�屾湰鏈� Navicat 鐐逛竴娆″浠� 鈫� 鎷峰埌鐩爣鏈哄悓璺緞 鈫� 杩樺師澶囦唤銆嶇殑鍌荤摐姝ラ銆�
+- `docs/鎵撳寘閮ㄧ讲璇存槑.md` 5.1 鑺傛柊澧炪�岃矾绾� B2锛歂avicat 澶囦唤/杩樺師锛�.nb3锛夈�嶏紝骞舵敞鏄庝笁绉嶆柟寮忎换閫夊叾涓�銆佷笉鍙彔鍔犮��
+
 ## 浜屻�佹祴璇曠粨鏋滄憳瑕侊紙璇﹁銆婂姛鑳芥祴璇曟姤鍛娿�嬶級
 
 | 椤� | 缁撴灉 |
@@ -47,8 +84,8 @@
 ## 涓夈�侀仐鐣欓棶棰樹笌寰呭姙
 
 1. **涓彛寰勬帓鍚嶉〉銆屽悓姣斿閫熴�嶅垪浠嶆槸姣嶇増鏃у��**锛氬簱涓彧鏈� 2026 骞存暟鎹�佹病鏈� 2025 骞翠腑鍙ｅ緞瀹氱鏁版嵁锛岀畻涓嶅嚭 8 鏈堝悓姣旓紱绛� 2025 鏁版嵁鍏ュ簱鍚庤嚜鍔ㄥ埛鏂般��
-2. **缃戠害杞� 8 鏈堣鍗曟暟鐤戜技鏈洿鏂�**锛氬簱涓� `wyc_order_monthly` 鐨� 2026-07 涓� 2026-08 `order_sum` 閮芥槸 29,730,791锛�7銆�8 鏈堢浉鍚岋級锛岃鐢ㄦ埛鏍稿鏄惁閲嶄紶杩囩湡瀹� 8 鏈堣繍琛岀洃娴嬫姤鍛娿��
-3. **鏍圭洰褰曚复鏃舵枃浠�**锛歚_*.py` / `_*.sql` / `_*.xlsx` / `_*.txt` / `_bak_*.java` 绛� 100+ 涓湭璺熻釜鏂囦欢锛堢敤鎴锋湭鍚屾剰鍓嶄笉娓呯悊銆佷笉鎻愪氦锛夈��
+2. **缃戠害杞� 8 鏈堣鍗曟暟浠嶆槸 7 鏈堝壇鏈�**锛堝凡鏌ヨ瘉锛夛細`wyc_order_monthly` 鐨� 2026-08 琛� `created_at=2026-09-11 16:35:10`锛屽搴� `import_batch` **#317**銆佹枃浠跺悕 `_t_wyc_aug.docx`锛�09-11 鑷祴鏃剁敤 7 鏈堟姤鍛婃敼鏍囬鐨勪复鏃跺壇鏈級锛涗綘鐪熷疄鐨� `妯℃澘_缃戠害杞﹁鍗�.docx` 鍙鍏ヨ繃 2026-07 鏈燂紙#314/#318/#319锛夈�傝琛屽彧鏈� 4 涓叏鐪� pin 鏄湡瀹� 8 鏈堟暟鎹紙鏉ヨ嚜銆婄綉绾﹁溅鎬绘暟銆�#306锛夛紝17 甯傚窞璁㈠崟鏁颁笌 7 鏈堝畬鍏ㄧ浉鍚屻��**寰呯敤鎴烽噸浼犵湡瀹� 8 鏈堣繍琛岀洃娴嬫姤鍛婏紙鎶ヨ〃鏈� 2026-08锛夎鐩栥��**
+3. **鏍圭洰褰曚复鏃舵枃浠�**锛堟湰娆＄粡鐢ㄦ埛鍚屾剰鍒犻櫎鑷祴鍓湰 `_t_wyc_aug.docx`锛涘叾浣� 100+ 涓� `_*` 涓存椂鏂囦欢鏈姩锛夛細`_*.py` / `_*.sql` / `_*.xlsx` / `_*.txt` / `_bak_*.java` 绛� 100+ 涓湭璺熻釜鏂囦欢锛堢敤鎴锋湭鍚屾剰鍓嶄笉娓呯悊銆佷笉鎻愪氦锛夈��
 4. `docs/鐢熸垚姹囨�诲ぇ琛�/鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃.xlsx`锛堢増寮忓弬鐓т欢锛変笌 `docs/鐢熸垚姹囨�诲ぇ琛�/杈撳嚭/` 涓嬬殑鍘嗗彶浜х墿鍧囦负鏈窡韪枃浠讹紝鏆傛寜鎯緥涓嶇撼鍏ユ彁浜ゃ��
 5. 2026-08 瀵煎嚭鐨勩�屾湭鎵惧埌鍚屾湡澶囦唤姣嶇増銆嶅憡璀﹀睘鏃犲鎻愮ず锛屾槸鍚︽秷闄ゅ緟鐢ㄦ埛瀹氥��
 

--
Gitblit v1.9.1