From 8544968a63fcb8ae2c5275b3b96acdaba704f6e0 Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期三, 16 九月 2026 15:24:43 +0800 Subject: [PATCH] docs(工作日结): 补记本轮 git 结果（origin 已推 27574bc；gitea HTTP 无响应待补推） --- docs/工作日结/工作日结_2026-09-16.md | 69 ++++++++++++++++++++++++++++++++++ 1 files changed, 69 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-16.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-16.md" index eecf5c7..5092143 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-16.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-16.md" @@ -172,3 +172,72 @@ - 鎻愪氦 `e7cddc4`锛歚fix(report): 棰勮寮圭獥琛屾暟鏂囨鎸夋姤琛ㄧ被鍨嬪尯鍒哷锛�4 涓枃浠讹紝+25/-1锛夈�� - 鎺ㄤ釜浜轰粨搴� `origin`锛歚git push origin main:master` 鎴愬姛锛坄b0c8b4f..e7cddc4`锛夈�� - 鎺ㄥ叕鍙� `gitea`锛歚git fetch gitea` 浠嶅け璐ワ紝鎶� `fatal: unable to access ... Recv failure: Connection was reset`锛坄fetch_exit=128`锛夛紝鏈**鏈帹閫佹垚鍔�**锛岀户缁垪涓洪仐鐣欓棶棰橈紱琛ユ帹鍓嶅厛 `git fetch gitea` 涓庤繙绔� `main` 鍚堝苟锛�**绂佸己鎺�**銆� + +## 鍗佷竷銆佺敤鎴风 5 鏉★細姹囨�诲ぇ琛ㄤ笌 8 鏈堝畾绋块�愯〃姣斿 + +**姣斿瀵硅薄**锛歚D:\妗岄潰\鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃.xlsx`锛堢敤鎴� 14:39 瀵煎嚭锛� vs `D:\05_鏁版嵁鍒嗙被\姹囨�昏〃\8鏈堟眹鎬诲畾绋縗2026骞�8鏈堝杩愰噺銆佽揣杩愰噺瀹氱.xlsx`銆傞噸鏂板鍑轰竴娆★紙`GET /api/report/export/summaryWorkbook?period=2026-08&mode=month`锛夊緱鍒扮殑鏂囦欢涓庢闈㈤偅浠�**瀛楄妭鏁板畬鍏ㄤ竴鑷达紙950,186锛�**锛屾帓闄も�滄枃浠惰繃鏈熲�濄�� + +**韪╃殑鍧戯紙閲嶈锛�**锛� +1. 涓よ竟**琛屽潡楂樺害涓嶅悓**锛堝鍑烘瘡甯傚窞 6 琛屻�佸畾绋� 4 琛岋紱瀵煎嚭 118 琛� vs 瀹氱 84 琛岋級锛岀洿鎺ユ寜鍗曞厓鏍煎潗鏍囨瘮浼氬緱鍑� 4.6 涓囦釜鈥滃樊寮傗�濓紝鍏ㄦ槸閿欎綅鍣０ 鈫� 鏀圭敤銆屽湴鍖�+鎸囨爣+鍒楁爣棰樸��**璇箟閿�**瀵归綈銆� +2. 瀵煎嚭绔湁 **39,939 涓叕寮忔牸**锛坄=C7+C9`銆乣=C5/V5-1`銆乣RANK(...)`锛夛紝`openpyxl(data_only=True)` 璇诲嚭鏉ュ叏鏄� None 鈫� 璇垽鎴愨�滄暣琛ㄦ病鏁版嵁鈥濄�侲xcel COM 鎵撲笉寮�锛堢敤鎴峰凡寮�鐫� Excel锛屼笉鑳戒贡鍔級锛屾渶鍚�**鑷繁鍐欏叕寮忔眰鍊煎櫒**锛圫UM/RANK/ROUND+鍥涘垯+璺ㄨ〃寮曠敤锛夌畻鍑� 61,972 涓暟鍊兼牸鍐嶆瘮銆� + +**缁撹**锛氳涔夐敭涓�鑷� 28,567 涓紝涓嶄竴鑷� 4,742 涓�� +* ` 璐ц繍` 琛細瀵煎嚭姣忓競宸炴瘮瀹氱**澶氫袱琛�**锛堛�岃涓�+瑙勪笅璐ц繍閲忋�嶃�岃涓嬭揣杩愰噺銆嶏級锛屽悓鎸囨爣鏁板��**闆跺樊寮�**锛涘畾绋胯繕鏈夈�岃涓�+瑙勪笅鍛ㄨ浆閲忋�嶈鑰屽鍑鸿琛屼负绌恒�� +* **鏈�澶у樊寮傛潵婧�**锛歚city_bus_monthly / city_taxi_monthly / wyc_order_monthly / wyc_total_monthly` **鍙湁 2026-01~08锛屾病鏈� 2025 骞�** 鈫� 鍏氦/鍑虹/缃戠害杞�/涓彛寰勫嚑寮犺〃鐨勩�屼笌鍘诲勾鍚屾瘮銆嶈绠楁垚 `0`/`-1`銆�2025 骞寸疮璁″亸灏忋�� +* `h2031_enterprise_monthly` 缂� `2025-01`锛堟簮鏂囦欢鏈韩娌℃湁 1 鏈堬級銆� +* 瀵煎嚭绔�屼腑鍙ｅ緞鍒嗘瀽銆嶅涓�娈靛綋鏈堝潡銆佺己 4 琛屸�滃崰姣斺�濄�� +璇﹁銆婂姛鑳芥祴璇曟姤鍛�/姹囨�诲ぇ琛ㄤ笌瀹氱姣斿_2026-09-16.md銆嬨�� + +## 鍗佸叓銆佺敤鎴风 2 鏉★細2024 骞存暟鎹噸瀵硷紙鍥炲～涓婂勾鍚屾湡锛� + +**鑳屾櫙**锛歚last_*`锛堜笂骞村悓鏈燂級鍙粠**鍚屼竴涓伐浣滅翱鐨勪笂涓�骞� Sheet** 鍙栵紝8 鏈堟枃浠舵病鏈� `2023` Sheet锛屾墍浠� `2024-12` 鐨� `last_*` 涓�鐩存槸 NULL銆� + +**杩囩▼**锛氬厛鐢� 7 鏈堟枃浠讹紙鍚� `2023` Sheet锛夊彟瀛樺彧鐣� 4 涓勾搴� Sheet 鐨勪复鏃舵枃浠跺鍏� 鈫� `2024-12` 鐨� `last_*` 濉笂浜嗭紝浣� **`2021-12` 鐨勩�屾箹鍖楃渷銆嶈 1 鏈堝�间粠 14945.34 鍙樻垚浜� 0**銆傛帓鏌ュ彂鐜般�屾箹鍖楃渷銆嶈鏄� `=SUM()` **鍏紡**锛宱penpyxl 鍙﹀瓨浼�**涓㈡帀鍏紡鐨勭紦瀛樺��**锛孭OI 璇诲埌绌哄叕寮忓氨鍐� 0銆� + +**淇**锛氭敼鐢�**鍘熷 7 鏈堟枃浠�**鏁翠唤閲嶅锛坄POST /api/import/freightTurnover?period=2026-07`锛岃繑鍥炪�屽叡 108 鏉¤褰曘��= 6 鏈� 脳 18 琛岋級銆� + +**澶嶆牳**锛�7 鏈�/8 鏈堜袱涓枃浠剁殑 11 涓勾搴� Sheet 涓庡簱閫愭牸姣斿 **4,752 鏍煎叏閮� 0 涓嶄竴鑷�**锛涗笂骞村悓鏈熼摼鏉� 2022鈫�2021銆�2023鈫�2022銆�2024鈫�2023銆�2025鈫�2024銆�2026-07/08鈫�2025 **鍏ㄩ儴 0 涓嶄竴鑷�**銆� + +**鏁欒**锛氫互鍚庝笉鑳界敤 openpyxl 鍙﹀瓨 Excel 鍐嶅杺缁欏悗绔紝鍏紡缂撳瓨浼氫涪锛涜涔堢敤鍘熷鏂囦欢锛岃涔堢敤 Excel COM 鍙﹀瓨銆� + + +## 鍗佷節銆佺敤鎴风 3 杞彁闂細璐ц繍椤电銆岀疮璁°�嶄负浠�涔堝彧鏈夊墠鍥涗釜瀵瑰緱涓� + 鏂板鍏ユ暟鎹綋妫� + +### 19.1 瀹氫綅杩囩▼ +1. 瑙ｅ墫瀵煎嚭浠躲�� 璐ц繍銆嶉〉绛撅細鍏� 6 涓疮璁″垪 鈥斺�� `S`(2026 1-8鏈�)銆乣AT`(2025)銆乣BV`(2024)銆乣CW`(2023)銆乣DZ`(2022)銆乣EO`(2021)銆� +2. 璇绘瘝鐗� `docs/鐢熸垚姹囨�诲ぇ琛�/鐢熸垚_閬撹矾杩愯緭閲忔眹鎬昏〃.xlsx` 鐨勫悓鍚嶉〉锛歚S5/AT5/BV5/CW5` 鏄� **危鍏紡**锛宍DZ5` 鏄� **鏁板�煎父閲� 144979.285376043**锛宍EO5/EP5` **涓虹┖**銆�2021 骞� `EC5:EN5` 鍗佷簩涓湀閮芥湁鍊硷紙鍚堣 161309.5316锛夛紝鍙槸绱鍒楁紡浜嗐�� +3. 鐢ㄦ簮鏂囦欢锛坄D:\05_鏁版嵁鍒嗙被\楂橀�焅瀹氱-婀栧寳鐪佸悇甯傚窞杩愯緭閲忔暟鎹紙2026骞�1-8鏈堬級.xlsx`锛屽彟鏈� 7 鏈堟枃浠跺惈 2023 椤碉級澶嶇畻鍏ㄧ渷琛岋細 + +| 骞村害 | 鍒� | 姹囨�昏〃 | 婧愭枃浠舵牳绠� | 宸紓 | +|---|---|---|---|---| +| 2026(1-8鏈�) | S | 130311.8927 | 130311.8927 | 0 | +| 2025 | AT | 195433.2232 | 195433.2232 | 0 | +| 2024 | BV | 184938.5780 | 184938.5780 | 0 | +| 2023 | CW | 173045.2932 | 173045.2964 | 鈭�0.0033 | +| 2022 | DZ | 144979.2854 | 144979.2825 | +0.0029 | +| 2021 | EO | 绌� | 161309.5316 | 鏁村垪缂哄け | + +鍛ㄨ浆閲忚鍚岀悊锛�2023 鈭�0.0017銆�2022 +0.0025銆�2021 绌猴級銆傚競宸炶 2026~2022 閫愭牸涓�鑷达紝宸紓鍙湪銆屽叏鐪併�嶈鍜� 2021 鍒椼�� + +### 19.2 鍘熷洜 +* **2021 绱鍒楋紙EO锛夊湪姣嶇増閲屽氨鏄┖鐨�** 鈥斺�� 婕忓～绱鍏紡锛�8 鏈堝畾绋垮悓鏍蜂负绌猴紝灞炲巻鍙查仐鐣欍�� +* **2022 绱鍒楋紙DZ锛夋槸鍐欐甯搁噺**锛屼笉浼氶殢瀵煎叆鏁版嵁鍒锋柊锛涘叾鍚勬湀鍊间篃鏄綋骞存墜宸ュ綍鍏ョ殑鏃х簿搴︼紙1 鏈� 10709.5265 vs 婧愭枃浠� 10709.5234锛夈�� +* **2023 绱鍒楋紙CW锛夋槸鍏紡锛屼絾杈撳叆鏉ヨ嚜姣嶇増**锛氭瘝鐗� 2023 鍏ㄧ渷琛� = 瑙勪笂+瑙勪笅涓よ鐩稿姞锛屼笌婧愭枃浠� `2023` 椤垫箹鍖楃渷琛岀簿搴︿笉鍚岋紝宸� 0.0033銆� +* 浠ｇ爜姣忔瀵煎嚭鍙洖濉�岀洰鏍囧綋鏈堛�嶄竴鍒楋紙`SummaryWorkbookFiller.fillFreightSheet`锛夛紝鍘嗗彶鏈堜唤鍏ㄩ儴娌跨敤姣嶇増 鈫� 姣嶇増瀵逛笉涓婂氨鏁翠綋瀵逛笉涓娿�� + +### 19.3 鏂板鍏ユ暟鎹綋妫�锛堥棶棰樻竻鍗曪級 +| # | 涓ラ噸搴� | 闂 | +|---|---|---| +| 1 | 楂� | `h2032_enterprise_monthly` 澶氬嚭涓�涓� **2026-09 鏈�**锛屾簮鏂囦欢鍚嶆槸銆岄亾璺揣鐗╄繍杈撴湀搴︾敓浜ф儏鍐碉紙2026骞�8鏈堬級.xls銆嶏紙batch 302锛夈�備笌 2026-08 鏈熼�愪紒涓氭瘮锛�636 鏉′紒涓氬畬鍏ㄥ悓闆嗐��90 涓尯鍒掞紝浠� 38 瀹朵紒涓氭暟鍊间笉鍚� 鈫� 鏄� 8 鏈堟暟鎹殑鍙︿竴鐗堟湰琚瓨鎴� 9 鏈� | +| 2 | 楂� | `h2031_enterprise_monthly` **缂� 2025-01**锛堜粖澶╁彧瀵间簡 02~12锛夛紝2025 骞寸疮璁′細灏� 1 涓湀 | +| 3 | 涓� | `passenger_individual_monthly` 2026-08 **缂洪粍鍐堝競**锛�7 鏉″彉 6 鏉★級 | +| 4 | 浣� | PASSENGER_AUTH 11 鏈熷叏 0 琛岋紝闇�纭鏄惁姝ｅ父 | +| 5 | 鎻愮ず | 2025-04 鐨� H2032 姝ゅ墠缂哄け锛屾湰娆″凡琛ラ綈锛坆atch 382锛�664 琛岋級锛沨2032 鍖哄垝鏁� 2025=87 / 2026=90锛屽睘浼佷笟杩涢��瑙勬甯稿彉鍔� | + +鍏ュ簱鎶芥煡锛欻2032 2025 鍏ㄥ勾瑙勪笂 50117.0940 涓囧惃 / 7435040.9971 涓囧惃鍏噷銆�2026 骞� 1-8 鏈堣涓� 31399.8248 涓囧惃锛岄�愬競宸� 17/17 涓庡鍑轰欢銆岃揣杩愰噺鎺掑悕銆嶇疮璁¤〃涓�鑷淬�� + +璇﹁銆婂姛鑳芥祴璇曟姤鍛�/璐ц繍绱鍒楁牳瀵逛笌瀵煎叆鏁版嵁浣撴_2026-09-16.md銆嬨�� + +### 19.4 git 缁撴灉锛堟湰杞級 +- 鎻愪氦 `27574bc`锛堝姛鑳芥祴璇曟姤鍛� + 鏈妭 + .gitignore 琛� `_pylibs/`銆佷慨姝� `~$*` 鍓嶅绌烘牸锛夆啋 **宸叉帹 origin锛坓itee master锛�**锛歚559e937..27574bc`銆� +- **鍏徃 gitea 浠嶄笉鍙敤**锛歚Test-NetConnection 61.183.254.94:3000` 杩斿洖 True锛圱CP 閫氾級锛屼絾 `GET /r/trafficAudit.git/info/refs?service=git-upload-pack` 25 绉掓棤浠讳綍鍝嶅簲锛圚TTP 000锛夛紝`git fetch gitea` 鎶� `Operation too slow. Less than 1000 bytes/sec`銆傚垽鏂负鏈嶅姟绔湭姝ｅ父鎻愪緵 HTTP 鍝嶅簲锛屽緟鎭㈠鍚庤ˉ鎺紝**绂佸己鎺�**銆� -- Gitblit v1.9.1