From 04f0802ba0a0e65334ad77e3d17718f53fdd7bc0 Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期六, 26 九月 2026 12:17:26 +0800 Subject: [PATCH] chore(配置安全): 进 jar 的配置改为纯占位符/环境变量，本机真实值移至 gitignore 的 config/application.yml；部署说明补密钥分层与轮换步骤 + 测试报告与日结 --- docs/工作日结/工作日结_2026-09-22.md | 58 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 58 insertions(+), 0 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-22.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-22.md" index 6b34442..8b9182b 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-22.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-22.md" @@ -140,3 +140,61 @@ - 鎬ц兘锛氫富娓叉煋杩涚▼锛圥ID 7044锛夎繛缁� 10 绉掗噰鏍风害 `13.28%` 鍗曟牳锛涗慨澶嶅墠绾� `115%` 鍗曟牳銆� - 瀹堝崼锛氳皟璇曠鍙� 9229 璇诲彇 `window.__codexPlusRetryTimerGuardInstalled=true`锛屾湰娆′細璇� `window.__codexPlusRetryTimerGuardDropped=16`銆� - 缁撹锛氳緭鍏ュ崱椤夸慨澶嶅湪閲嶅惎鍚庝粛鐢熸晥锛岄棶棰樺凡瑙ｅ喅銆� + + +## 鍏�佹姇璧勬槑缁嗚〃銆岃蒋浠剁敓鎴� vs 浜哄伐鐗堛�嶆暟鎹瘮瀵癸紙2026-08锛� + +鐢ㄦ埛瑕佹眰锛氭妸杞欢鐢熸垚鐨勩�婂杩愮珯鎶曡祫鏄庣粏琛ㄣ�嬨�婄墿娴佺珯鍦烘姇璧勬槑缁嗐�嬩笌浜哄伐缁存姢鐨勪袱浠藉畾绋块�愭牸姣斿锛屽垪鍑烘墍鏈変笉鍚屻�� + +- **姣斿鏂囦欢**锛氫汉宸ョ増 `D:\05_鏁版嵁鍒嗙被\鎶曡祫\8鏈圽8鏈堝杩愮珯鎶曡祫鏄庣粏琛�.xlsx`銆乣8鏈堢墿娴佺珯鍦烘姇璧勬槑缁�.xls` + vs 杞欢鐗� `D:\妗岄潰\鐢熸垚鏁版嵁\鐢熸垚_鎵�閫夋姤琛╛2026-08 (1)\鐢熸垚_瀹㈣繍绔欐姇璧勬槑缁嗚〃.xlsx`銆乣鐢熸垚_鐗╂祦绔欏満鎶曡祫鏄庣粏.xls`銆� +- **姣斿鏂规硶**锛氳剼鏈�愰〉绛鹃�愭牸姣斿锛坄_tmp_diff_invest_0922.py`锛夛紱鍏堟牳瀵� B 鍒楅」鐩悕閫愯瀵归綈锛�192/121 琛屽叏閮ㄤ竴鑷达紝鏃犻敊浣嶏級锛屽啀缁熻宸紓锛屾渶鍚庡洖婧簮鏂囦欢 / 鏁版嵁搴� / 搴曠妯℃澘瀹氫綅鏍瑰洜銆� +- **缁撴灉**锛氬叡 **156 鏍煎樊寮�** 鈥斺�� 瀹㈣繍銆婃槑缁嗐��12 +銆婃眹鎬汇��4锛涚墿娴併�婂垎椤圭洰鎶曡祫瀹屾垚鎯呭喌銆�108 +銆婂垎甯傚窞瑙勫垝鍐呭銆�15 +銆婂競宸炴眹鎬汇��17锛屻�婃湀2銆嬫棤宸紓銆� +- **鏍瑰洜锛堜笁鏂硅瘉鎹攣瀹氾級**锛� + 1. 杞欢瀵煎嚭 = 鍦ㄥ簳绋裤�婃ā鏉縚X鏈堚�︽姇璧勬槑缁嗐�嬩笂锛屾妸搴撳唴褰撴湀鏁版嵁**鎸夐」鐩悕绉板尮閰�**瑕嗙洊 H/J/K 涓� M锛�**鍖归厤涓嶄笂鎴栧簱鍐呮棤褰撴湀鏁板氨闈欓粯娌跨敤涓婃湡鍊�** 鈥斺�� 姝︽眽甯傜墿娴侊紙搴撳唴 0 鏉℃湀搴﹁褰曪級鏁存淇濈暀 7 鏈堝�硷紱鑽嗗窞銆屼腑鍥戒緵閿�鍏畨鍟嗚锤鐗╂祦鍥�嶏紙搴撳唴鍚嶅涓�涓偣锛屽尮閰嶅け璐ワ級淇濈暀 7 鏈堝�� 7758.5/1600.1锛堝簱鍐�/婧愯〃瀹為檯 15986/8227.5锛夈�� + 2. 搴撳唴**鍚屽悕鍙屾。**锛氬崄鍫般�屽揩閫掔墿娴佷骇涓氬洯浜屾湡銆嶆湁 `id=154`锛堢宸� 2026锛変笌 `id=181`锛堢宸� 2029锛変袱妗ｏ紝瀵煎嚭鍙栧埌鏃ф。锛屽啓浜� 7 鏈堝�� 20081/2900/214锛堝簲 20377/3196/296锛夈�� + 3. **瀵煎叆涓㈡暟**锛氬ぉ闂ㄣ�屽ぉ闂ㄥ競鐗╂祦涓績寤鸿椤圭洰銆嶅簱鍐� 2026-08 鐨勭疮璁�/鑷勾鍒�/鏈湀鍏ㄦ槸 0锛屾簮鏂囦欢鏄� 16677.7/16677.7/500锛圥1-5 鍘熻褰曘�屾簮鏂囦欢 H/J/K 鍒椾负绌恒�嶄笌鐜版枃浠朵笉绗︼級銆� + 4. 瀵煎嚭**涓嶈鐩� L锛堝缓璁鹃樁娈碉級绛夐潪閲戦鍒�** 鈫� 榛勭煶澶у喍婀栧喎閾� L=鏆傚仠銆佸崄鍫版灑绾� L=鍓嶆湡銆佽闃冲喎閾句腑蹇� L=鍦ㄥ缓銆侀殢宸炴皯鐢熺墿璧� M 鐨� 7 鏈堟枃瀛楋紝閮芥槸搴曠娈嬬暀銆� + 5. 鍗曟笭閬撳競宸炵殑**鍒嗙粍灏忚琛�**锛氳蒋浠跺～=甯傚窞鍚堣锛屼汉宸ョ増涓嶅～锛�0 涓庣┖鐧界殑鍐欐硶涓よ竟涓嶅悓锛堜笉褰卞搷閲戦锛夈�� + 6. 瀹㈣繍閮ㄥ垎宸紓涓昏鏄�**浜哄伐鐗堟墜鍐欏洓鑸嶄簲鍏�**锛�203 / 2531 / 43225.9 绛夛級锛屼互鍙� 3 澶勫舰璞¤繘搴�/寤鸿闃舵锛歁26銆丮85 浜哄伐鐗堢┖锛堣蒋浠剁増鍙栬嚜婧愯〃涓庡簱鍐呫�佹槸瀵圭殑锛夛紝L91 浜哄伐鐗堛�屽湪寤恒�嶆纭�佽蒋浠剁増鏄簳绋挎棫鍊笺�屾殏鍋滄柦宸ャ�嶃�� +- **褰卞搷閲戦**锛氳蒋浠剁増鐗╂祦銆岃嚜寮�濮嬬疮璁°�嶃�岃嚜骞村垵绱銆嶅悇灏� **34399.2 涓囧厓**銆併�屾湰鏈堝畬鎴愩�嶅皯 **6291.4 涓囧厓**銆� +- **鎶ュ憡**锛歚docs/鍔熻兘娴嬭瘯鎶ュ憡/鏁版嵁姣斿鎶ュ憡_鎶曡祫鏄庣粏琛ㄨ蒋浠剁敓鎴愪笌浜哄伐鐗坃2026-09-22.md`锛堝惈 156 鏍煎叏閲忔竻鍗� + 閫愭潯鏍稿缁撹 + 澶勭疆寤鸿锛夈�� +- **涓存椂鑴氭湰锛堜繚鐣欙級**锛歚_tmp_diff_invest_0922.py`銆乣_tmp_dump_invest_full_0922.py`銆乣_tmp_diff_invest_annot_0922.py`銆乣_tmp_diff_tables_0922.py`銆乣_tmp_src_spotcheck_0922.py`銆乣_tmp_src_spotcheck2_0922.py`銆乣_tmp_db_probe*_0922.py`銆乣_tmp_tpl_*_0922.py` 鍙婂搴� `_*.txt` 杈撳嚭銆� + + + +## 涓冦�佹姇璧勬槑缁嗚〃鍙栨暟淇锛堢涓�杞紝宸茬紪璇�/閲嶅惎/绔埌绔獙璇侊級 + +鎸夌鍏妭姣斿缁撹鍔ㄦ墜淇簡涓夊"浼氶潤榛樺嚭鏁�"鐨勫彇鏁扮己闄凤紝骞堕『甯︾鍒扮鏆撮湶+淇浜嗘綔姹熷鍏ラ�夐敊鍘嗗彶椤电銆� + +- **瀵煎嚭**锛坄ReportExportService.java`锛夛細 + 1. `normInvestName()` 褰掍竴鍖栬ˉ鏍囩偣锛堝崐/鍏ㄨ鍙ョ偣銆侀】鍙枫�佸垎鍙风瓑锛夆啋 鑽嗗窞銆屼腑鍥戒緵閿�.鍏畨鍟嗚锤鐗╂祦鍥�嶅彲鍖归厤锛屽啓鍏ュ簱鍐� 15986/15986/8227.5锛� + 2. 鏂板 `preferMonthlyCandidate()`锛氬悓鍚嶅妗ｄ紭鍏堝彇銆屽綋鏈堟湁鏁版嵁銆嶇殑妗� 鈫� 鍗佸牥銆屽揩閫掔墿娴佷骇涓氬洯浜屾湡銆嶆敼鍙� id=181锛屽啓鍏� 20377/3196/296銆佺宸� 2029锛� + 3. 鏂板 `logSkippedRows()`锛氭湭瑕嗙洊琛岄�愯 WARN锛坄[鏈鐩朷 绗琋琛� 甯傚窞 椤圭洰鍚� 鈫� 鍘熷洜` + 鎸夊競宸炵粺璁★級锛屼笉鍐嶉潤榛樼粨杞笂鏈熷�笺�� +- **瀵煎叆**锛坄DataImportService.java`锛夛細 + 1. `investHeaderKey()` 鍏堝幓鍏ㄩ儴绌虹櫧锛堝惈鎹㈣/鍏ㄨ绌烘牸锛夊啀鍒ゅ畾鍏抽敭璇� 鈫� 澶╅棬 H/J/K 涓夊垪鎭㈠璇嗗埆锛�2026-08 鍏ュ簱 16677.7/16677.7/500锛堝師涓� 0/0/0锛夛紱 + 2. 鏂板 `investSheetPeriodCellHit()` + 璇勫垎鍔犳潈 2000000锛氭寜琛ㄥ唴鎶ヨ〃鏈燂紙`2026.08.24`锛夐�� sheet锛屼紭鍏堜簬銆宻heet 鍚嶅惈鍚屾湀銆嶁啋 娼滄睙涓嶅啀鎶� **2018 骞�**銆屾綔姹燂紙8鏈堬級銆嶅綋 2026-08锛岄噸瀵煎悗 2026-08 鍏ュ簱銆屼腑鍥借櫨璋峰喎閾句粨鍌ㄧ墿娴佸洯銆�11947.9/1135/0銆� +- **楠岃瘉**锛歚mvn -o compile` 閫氳繃锛涘仠鏃ц捣鏂板悗绔紙8090 灏辩华锛夛紱鎺ュ彛閲嶅 + 閲嶈窇 2026-08 瀵煎嚭锛涢�愭牸姣斿**156 鏍� 鈫� 129 鏍�**锛堥檷 27 鏍硷細鐗╂祦鍒嗛」鐩� 108鈫�91銆佸垎甯傚窞 15鈫�11銆佸競宸炴眹鎬� 17鈫�11锛夛紝鏃犳柊澧炲樊寮傘�� +- **鏈鐩栨竻鍗曪紙鏂板鑳藉姏锛屾潵鑷棩蹇楋級**锛氱墿娴� 6 琛岋紙鍏ㄩ儴姝︽眽锛屽簱鍐呮棤褰撴湀鏁版嵁锛夛紱瀹㈣繍 12 琛岋紙榛勭煶 1銆岄槼鏂扮患鍚堝杩愭灑绾界珯銆嶃�侀粍鍐� 9銆佹仼鏂� 1銆屽捀涓板幙鍧潩钀ユ梾娓稿杩愮珯銆嶃�佷粰妗� 1銆屼粰妗冨競姣涘槾瀹㈣繍绔欍�嶏級銆� +- **鎶ュ憡**锛歚docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_鎶曡祫鏄庣粏琛ㄥ彇鏁颁慨澶峗2026-09-22.md`銆� +- **閬楃暀锛堥渶鎷嶆澘/琛ユ暟锛�**锛氣憼 L/D/E/F 鏄惁鎸夊綋鏈堣鐩栵紙闇�銆婂缓璁鹃樁娈靛綊涓�琛ㄣ�嬶級锛涒憽 姝︽眽鐗╂祦銆侀粍鍐堝杩� 8 鏈堟簮鏁版嵁缂哄け锛涒憿 娼滄睙 2026-06/07 鏈堝害浠嶆槸鍘嗗彶 sheet 閿欏�硷紝闇�鐢� 6/7 鏈堟簮琛ㄩ噸瀵硷紙**涓嶈**鐢� 8 鏈堟枃浠堕噸瀵硷級锛涒懀 鏈鐩栨竻鍗曠洰鍓嶅彧杩涙棩蹇楋紝寤鸿鎸� P1-9 鍑恒�婃牎楠屾姤閿檁<骞存湀>.xlsx銆嬫垨椤甸潰鎻愮ず銆� +- **鏁版嵁鍙樻洿**锛氫粎閲嶅淇浜嗗ぉ闂ㄣ�佹綔姹熶袱澶� 2026-08 鏈堝害鍊硷紝鏈垹闄や换浣曢」鐩富妗ｃ�佹湭鍔ㄥ叾浠栧競宸�/鏈熼棿锛涗复鏃惰剼鏈笌浜х墿淇濈暀锛坄_tmp_*_0922.*`銆乣_tmp/gen_new_0922/`锛夈�� + + +## 鍏�佹眹鎬诲ぇ琛ㄨ蒋浠惰緭鍑轰笌鎵嬪伐瀹氱宸紓澶嶆牳锛�2026-08锛� + +- 姣斿鏂囦欢锛氳蒋浠惰緭鍑� `鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃_2026-08 (5).xlsx`锛屾墜宸ュ畾绋� `2026骞�8鏈堝杩愰噺銆佽揣杩愰噺瀹氱.xlsx`銆� +- 鏂规硶锛氬厛鐢� Excel COM 瀵逛袱浠藉壇鏈叏閲忛噸绠楋紝鍐嶆寜椤电銆佹暟鎹潡銆佽鏍囩銆佸垪澶村仛璇箟瀵归綈鍚庨�愭牸姣斿锛岄伩鍏嶈鍙� XLSX 鏃х紦瀛橀�犳垚 `#VALUE!` 鍋囧樊寮傘�� +- 缁撴灉锛�930 鏉￠�愭牸宸紓涓紝瀹炶川鏁板�煎樊寮� 314 鏉°�傚叾涓� 304 鏉℃槸鍏氦/鍑虹/缃戠害杞�/涓彛寰勬槑缁嗙殑 2025 绱鍒楀皯鍔� 7銆�8 鏈堬紝涓氬姟宸茬‘璁よ鍒楀彲娓呯┖锛涘彟 10 鏉℃槸 ` 璐ц繍` 2022 骞寸疮璁″悓姣旓紝涓氬姟宸茬‘璁よ蒋浠舵纭�� +- 鍏朵綑宸紓锛氭枃鏈瀷鏁板瓧 286 鏉°�佸彇鏁村熬宸� 194 鏉°�佷粎杞欢鏈夊�� 129 鏉°�佷粎鎵嬪伐鏈夊�� 2 鏉°�侀敊璇�� 2 鏉°�佹枃鏈笉鍚� 2 鏉°�佺被鍨嬩笉鍚� 1 鏉°�� +- 缁撴瀯宸紓锛氬煄甯傛眹鎬�/鍩庡競鍒嗗競宸�/涓彛寰勫垎鏋�/涓彛寰勬帓鍚嶅瓨鍦ㄨ蒋浠跺鍑虹殑 8 鏈堝潡鎴栦笉鍚屽竷灞�锛涗袱涓揣杩愭帓鍚嶉〉绛惧潡椤哄簭鐩稿弽锛涘煄甯傚杩愭墜宸ュ涓�鍒� AJ锛涢亾璺繍杈撳懆杞噺鎵嬪伐澶� AA/AB 绌哄垪銆傚彲姣斾笟鍔℃暟鎹潎宸查�愬潡瀵归綈鏍稿銆� +- 涓婄増鎶ュ憡涓殑 `鐝嚎鍖呰溅` 2019銆�2020 骞村巻鍙插潡 `#VALUE!` 缁忛噸绠楃‘璁ゆ槸缂撳瓨鍋囧樊寮傦紝鏈宸插墧闄ゃ�� +- 浜や粯锛歚docs/闂姹囨��/姹囨�诲ぇ琛╛杞欢杈撳嚭涓庢墜宸ュ畾绋垮樊寮傛竻鍗昣2026-08_20260922.md`锛岄�愭牸鏄庣粏 `docs/闂姹囨��/姹囨�诲ぇ琛╛宸紓鏄庣粏_2026-08_20260922.csv`銆� + +## 涔濄�佸叧鏈轰氦鎺ュ揩鐓э紙2026-09-22 17:20锛� + +- **git**锛氭媺鍙栧苟鍚堝苟鍏徃浠撳簱鏈�鏂� `db0ee92`锛堟姇璧勬槑缁嗗彇鏁�/瀵煎叆淇 + 鏃ョ粨绗竷/鍏妭锛夛紱鍚堝苟鍚庢湰鍦扮紪璇� `mvn -q -DskipTests compile` 閫氳繃銆傚叧鏈哄墠灏� HANDOFF銆佹湰鏃ョ粨蹇収鎻愪氦骞舵帹閫� `origin/main`銆� +- **杩愯鐘舵��**锛歞ev 鍚庣 `8090`銆佸墠绔� `8080` 鍧囨湭杩愯锛屾湭鍙戠幇瀵瑰簲 Java/Node 杩涚▼锛沗backend.log` 鏈�鍚庡啓鍏� 09-21 17:29锛宍frontend.log` 鏈�鍚庡啓鍏� 09-21 17:36銆侻ySQL80(`3305`)銆丮ySQL57(`3306`) Running锛屽叧鏈哄悗鑷姩鍋滄锛屾棤闇�鎵嬪伐澶勭悊銆� +- **涓嬫鍚姩**锛氶」鐩牴鐩綍鎵ц `powershell -NoProfile -ExecutionPolicy Bypass -File start-dev.ps1`锛涙暟鎹簱鍜岀敓鎴愮紦瀛樺凡鎸佷箙鍖栥�� +- **淇濈暀浜х墿**锛氭眹鎬诲ぇ琛ㄥ樊寮傛姤鍛�/CSV銆佹姇璧� 156鈫�129 鏍兼姤鍛娿�乣_tmp*_0922.*` 涓� `_tmp/gen_new_0922/` 绛夊潎淇濈暀锛屾湭缁忕‘璁や笉鍒犻櫎銆� +- **涓嬫浼樺厛**锛歅0-2銆婁嚎鍏冩姇璧勯」鐩�嬫寜 Q7 杩藉垪銆丳0-3 瀵煎嚭鍓嶅熀鏁颁綋妫�銆丳0-4 2026-09 姣嶇増锛涙姇璧勯仐鐣欓渶琛ユ姹夌墿娴�/榛勫唸瀹㈣繍 8 鏈堟簮鏁版嵁銆侀噸瀵兼綔姹� 2026-06/07 鍘嗗彶閿欏�笺�佸皢鏈鐩栨竻鍗曡惤鏂囦欢鎴栭〉闈€�� -- Gitblit v1.9.1