From 9f8395fab13ca4b230a0f7d62636e209745c91d4 Mon Sep 17 00:00:00 2001 From: lrj <owen.stl@gmail.com> Date: 星期日, 28 九月 2025 14:16:18 +0800 Subject: [PATCH] feat: 完善注册流程的文件上传功能 --- project.md | 263 +++++++++++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 257 insertions(+), 6 deletions(-) diff --git a/project.md b/project.md index 4e079d5..b901c1f 100644 --- a/project.md +++ b/project.md @@ -186,7 +186,7 @@ 鏁版嵁鏉ユ簮涓庡叧鑱旓細 * 涓昏〃锛歵\_activity\_player锛屽叧鑱斿鍛樿〃 t\_player锛坧layer\_id锛夛紝鍏宠仈姣旇禌琛� t\_activity锛坅ctivity\_id锛� -* 娉ㄦ剰锛歵\_activity\_player.activity\_id 濮嬬粓鍏宠仈鈥滄瘮璧涒�濓紱t\_activity\_player.stage\_id 蹇呴』鍏宠仈璇ユ瘮璧涚殑鈥滈樁娈碘�滻D銆傝嫢璇ユ瘮璧涙湭瀹氫箟闃舵锛坱\_activity 鏃犲瓙璁板綍 pid=activity\_id锛夛紝鍒欏皢 stage\_id 璁句负 activity\_id锛堟寚鍚戞瘮璧涜嚜韬級銆� +* 娉ㄦ剰锛歵\_activity\_player.activity\_id 濮嬬粓鍏宠仈"姣旇禌"锛泃\_activity\_player.stage\_id 蹇呴』鍏宠仈璇ユ瘮璧涚殑"闃舵"ID銆傝嫢璇ユ瘮璧涙湭瀹氫箟闃舵锛坱\_activity 鏃犲瓙璁板綍 pid=activity\_id锛夛紝鍒欏皢 stage\_id 璁句负 activity\_id锛堟寚鍚戞瘮璧涜嚜韬級銆� GraphQL 瑙勮寖锛� @@ -198,11 +198,242 @@ * 0锛堟姤鍚嶆湭瀹℃牳锛夛細鏄剧ず鎸夐挳銆愬鏍搁�氳繃銆� * 1锛堣繘琛屼腑锛屽凡閫氳繃锛夛細鏄剧ず鎸夐挳銆愬彇娑堣祫鏍笺�� * 2锛堝鏍告湭閫氳繃锛夛細鏄剧ず銆愬鏍告湭閫氳繃銆戯紝鏃犳搷浣滄寜閽� + +3.12 澶氳瘎濮旇瘎鍒嗙郴缁� + +3.12.1 绯荤粺姒傝堪 + +澶氳瘎濮旇瘎鍒嗙郴缁熸敮鎸佸涓瘎濮斿鍚屼竴閫夋墜杩涜鐙珛璇勫垎锛岀郴缁熻嚜鍔ㄨ绠楀钩鍧囧垎锛岀‘淇濊瘎鍒嗙殑鍏鎬у拰閫忔槑搴︺�� + +3.12.2 鏍稿績鍔熻兘 + +璇勫垎椤甸潰澧炲己锛� + +* 鏄剧ず褰撳墠璇勫淇℃伅锛堝鍚嶏級 +* 灞曠ず鎵�鏈夎瘎濮旂殑璇勫垎鐘舵�侊紙宸茶瘎鍒�/鏈瘎鍒嗭級 +* 鏄剧ず閫夋墜鐨勫钩鍧囧垎 +* 鏀寔璇勫鏌ョ湅鍜屼慨鏀硅嚜宸辩殑璇勫垎 + +璇勫垎鐘舵�佺鐞嗭細 + +* 瀹炴椂鏄剧ず鍚勮瘎濮旂殑璇勫垎杩涘害 +* 鍖哄垎褰撳墠璇勫鍜屽叾浠栬瘎濮� +* 鏄剧ず姣忎釜璇勫鐨勬�诲垎锛堝凡璇勫垎鐨勬儏鍐典笅锛� + +鏁版嵁璁＄畻锛� + +* 鑷姩璁＄畻閫夋墜鐨勫钩鍧囧垎 +* 鏀寔璇勫淇敼璇勫垎鍚庨噸鏂拌绠� +* 淇濇寔璇勫垎鍘嗗彶璁板綍 + +3.12.3 鎶�鏈疄鐜� + +鍓嶇瀹炵幇锛圴ue.js锛夛細 + +* 缁勪欢锛歊atingForm.vue - 澧炲己璇勫垎琛ㄥ崟缁勪欢 +* 椤甸潰锛歳ating.vue - 璇勫垎椤甸潰 +* API锛歛ctivityPlayer.js - 鏂板澶氳瘎濮旂浉鍏虫帴鍙� + +鍚庣瀹炵幇锛圫pring Boot + GraphQL锛夛細 + +* API锛歅layerGraphqlApi.java - 鏂板GraphQL鏌ヨ鏂规硶 +* 鏈嶅姟锛欰ctivityPlayerRatingService.java - 璇勫垎涓氬姟閫昏緫 +* DTO锛氭柊澧炲搷搴旂被鍨嬫敮鎸佸璇勫鏁版嵁 + +鏂板GraphQL鏌ヨ锛� + +* judgeRatingsForPlayer - 鑾峰彇閫夋墜鐨勬墍鏈夎瘎濮旇瘎鍒嗙姸鎬� +* currentJudgeRating - 鑾峰彇褰撳墠璇勫鐨勮瘎鍒嗚鎯� +* averageScoreForPlayer - 鑾峰彇閫夋墜骞冲潎鍒� +* currentJudgeInfo - 鑾峰彇褰撳墠璇勫淇℃伅 + +3.12.4 鏁版嵁缁撴瀯 + +璇勫璇勫垎鐘舵�佸搷搴旓紙JudgeRatingStatusResponse锛夛細 + +* judgeId - 璇勫ID +* judgeName - 璇勫濮撳悕 +* totalScore - 鎬诲垎 +* status - 璇勫垎鐘舵�侊紙0-鏈瘎鍒嗭紝1-宸茶瘎鍒嗭級 +* isCurrentJudge - 鏄惁涓哄綋鍓嶈瘎濮� + +褰撳墠璇勫璇勫垎鍝嶅簲锛圕urrentJudgeRatingResponse锛夛細 + +* id - 璇勫垎璁板綍ID +* totalScore - 鎬诲垎 +* status - 璇勫垎鐘舵�� +* remark - 璇勫垎澶囨敞 +* items - 璇勫垎椤圭洰璇︽儏鍒楄〃 + +褰撳墠璇勫淇℃伅鍝嶅簲锛圕urrentJudgeInfoResponse锛夛細 + +* id - 璇勫ID +* name - 璇勫濮撳悕 +* phone - 鑱旂郴鐢佃瘽 +* description - 璇勫鎻忚堪 + +3.12.5 涓氬姟瑙勫垯 + +璇勫垎鏉冮檺锛� + +* 璇勫鍙兘鏌ョ湅鍜屼慨鏀硅嚜宸辩殑璇勫垎 +* 璇勫鍙互鏌ョ湅鍏朵粬璇勫鐨勮瘎鍒嗙姸鎬侊紙宸茶瘎鍒�/鏈瘎鍒嗭級 +* 璇勫鍙互鏌ョ湅閫夋墜鐨勫钩鍧囧垎 + +璇勫垎娴佺▼锛� + +* 璇勫杩涘叆璇勫垎椤甸潰锛岀郴缁熸樉绀哄綋鍓嶈瘎濮斾俊鎭� +* 鏄剧ず鎵�鏈夎瘎濮旂殑璇勫垎鐘舵�� +* 濡傛灉褰撳墠璇勫宸茶瘎鍒嗭紝鍔犺浇鍏跺巻鍙茶瘎鍒嗘暟鎹� +* 璇勫鎻愪氦璇勫垎鍚庯紝绯荤粺閲嶆柊璁＄畻骞冲潎鍒� +* 瀹炴椂鏇存柊璇勫垎鐘舵�佹樉绀� + +鏁版嵁涓�鑷存�э細 + +* 璇勫垎鎻愪氦鍚庣珛鍗虫洿鏂版暟鎹簱 +* 閲嶆柊鍔犺浇椤甸潰鏁版嵁纭繚鐘舵�佸悓姝� +* 鏀寔璇勫澶氭淇敼璇勫垎 * 3锛堢粨鏉燂級锛氭樉绀恒�愬凡缁撴潫銆戯紝鏃犳搷浣滄寜閽� 鍥涖�佸井淇＄闇�姹� -鏆傛椂鐣欑┖ +鑱氱劍鈥滃鍛樻姤鍚嶁�濃�滆瘎濮旇瘎瀹♀�濃�滃钩鍙扮敤鎴锋煡璇㈡瘮璧涜繘绋嬪拰鎶ュ悕浜烘暟绛夌瓑淇℃伅鈥濇牳蹇冨満鏅紝绠�鍖栦氦浜掞紝閬垮厤鍐椾綑鎿嶄綔銆� + + + +\#### 鐧诲綍 + +聽 灏忕▼搴忕櫥褰曪紝浣跨敤寰俊鏍囧噯灏忕▼搴忕櫥褰曟祦绋嬶紝 + +聽 鍚庡彴瀵瑰簲 wxLogin 鏂规硶銆傦紙涓嶆槸webLogin) + + 鐧诲綍閫昏緫锛� + + 1. 濡傛灉t\_user 閲岄潰 娌℃湁瀵瑰簲鐨� openid ,閭ｄ箞鏂板涓�涓猽ser 璁板綍 + + 2. 濡傛灉瀛樺湪user 璁板綍锛� 鍒欏垎鍒叧鑱� t\_player ,t\_judge ,t\_employee 琛ㄩ噷闈㈢殑 user\_id, 杩斿洖鍓嶇鐨剈serDto 搴旇鍖呭惈 player, judge, employee 鐨勪俊鎭紙濡傛灉鏈夌殑璇濓級 + + 3. 鐢佃瘽鍙风爜鍏宠仈锛堥潪甯搁噸瑕侊級 + + 鍚庡彴鏈変釜 saveUserPhone 鐨勬柟娉曪紝灏忕▼搴忕鎴栬�厀eb绔洿鏂扮數璇濆悗閮藉繀椤昏皟鐢ㄨ繖涓柟娉曪紝浠栫殑鏍稿績閫昏緫鏄細 + + 1锛屾煡璇㈠綋鍓峵\_user 閲岄潰鐨勬槸鍚﹀瓨鍦ㄧ浉鍚岀殑鐢佃瘽鍙风爜锛屽鏋滄病鏈夛紝灏辨洿鏂板埌褰撳墠user閲岄潰 + + 2. 濡傛灉瀛樺湪鐩稿悓鐨勭數璇濆彿鐮侊紝骞朵笖瀵瑰簲user鐨刼penid 鏄痭ull ,閭ｄ箞 娓呯┖鍘熸潵user 鐨刾hone 璁剧疆涓簄ull, 鎶婃柊鐨勭數璇濆彿鐮佹洿鏂板埌 褰撳墠鐢ㄦ埛鐨刾hone瀛楁锛岋紙鍥犱负鐢佃瘽鍙风爜涓嶅彲閲嶅锛夛紝 鍚屾椂鏇存柊t\_player, t\_judge, t\_employee 鍏宠仈鐨剈ser\_id 鍒� 鏂扮殑user\_id + + + +\#### 2.3.1 棣栭〉 + +\- 椤堕儴锛氬睍绀衡�滃惎鐢ㄢ�濈姸鎬佺殑杞挱鍥撅紙鎸夋帓搴忓彿鎾斁锛夈�� + +\- 璧涗簨鍒楄〃锛氭樉绀衡�滃皝闈㈠浘+姣旇禌鍚嶇О+宸叉姤鍚嶄汉鏁�+鎴鍊掕鏃垛�濓紝宸叉埅姝㈡爣绾紱鏈埅姝㈣禌浜嬪甫鈥滆鎯呪�濇寜閽紝璺宠浆璇︽儏椤甸潰銆� + +\- toolbar鏄剧ず棣栭〉锛屾秷鎭紝鎴戠殑銆備笁涓ā鍧椼�� + + 绗竴娆℃墦寮�灏忕▼搴忥紝 寮瑰嚭鎵嬫満鍙风爜鎺堟潈锛屼絾鏄鏈夋槑鏄剧殑銆愬彇娑堛�戞寜閽紝鐢ㄦ埛鍙互涓嶆巿鏉冿紝濡傛灉鐢ㄦ埛鍙栨秷鎺堟潈锛屾妸 rejectPhone 璁板綍鍒皐x.setstorage 閲岄潰銆� 涓嬫鐧诲綍涓嶅湪鎻愰啋鎺堟潈鎵嬫満鍙风爜銆� + + + +\#### 2.3.2 璇︽儏椤甸潰 + +聽 椤堕儴鏄瘮璧涚殑鍥剧墖鍜岃棰� + +聽 涓嬮潰鏄瘮璧涘悕绉� + +聽 姣旇禌寮�濮嬫椂闂� + +聽 鎶ュ悕鎴嚦鏃堕棿銆� + +聽 姣旇禌绠�浠� + +聽 鏈�涓嬮潰鏄姤鍚嶆寜閽� + +聽 濡傛灉褰撳墠鐢ㄦ埛宸茬粡鍦ㄨ繖涓瘮璧涙姤杩囧悕锛屾湭瀹℃牳, 閭ｄ箞鏄剧ず銆愬凡鎶ュ悕-寰呭鏍搞�� + +聽 濡傛灉褰撳墠鐢ㄦ埛宸茬粡鍦ㄨ繖涓瘮璧涙姤杩囧悕锛屽凡缁忓鏍�, 閭ｄ箞鏄剧ず銆愬凡鎶ュ悕-杩涜涓�� + +聽 濡傛灉褰撳墠鐢ㄦ埛宸茬粡鍦ㄨ繖涓瘮璧涙姤杩囧悕锛屽凡缁忓鏍�, 閭ｄ箞鏄剧ず銆愬凡缁撴潫銆� + +聽 鈥滃綋鍓嶆椂闂村ぇ浜庢埅鑷虫椂闂粹�� 鐏拌壊鏄剧ず鈥滄姤鍚嶅凡缁撴潫鈥濓紝 涓嶅彲鎶ュ悕 + +聽 鈥滃綋鍓嶆椂闂村ぇ浜庢瘮璧涙椂闂�+24 灏忔椂锛� 閭ｄ箞鏄剧ず銆愬凡缁撴潫銆� + +聽 褰撳墠鏈姤鍚嶇姸鎬侊紝骞朵笖鏃堕棿鐘舵�佺鍚堣姹傦紝閭ｄ箞鏄剧ず 鎸夐挳銆愭垜瑕佹姤鍚嶃�� + + + + + + + +\### 鎶ュ悕椤甸潰 + +聽 澶村儚 + +聽 濮撳悕 + +聽 鐢佃瘽锛氬繀濉紝骞朵笖涓嶅彲褰曚笉鍙紪杈戯紙闃叉鏈変汉鎭舵剰娉ㄥ唽浠栦汉鐢佃瘽鍙风爜锛夛紝濡傛灉褰撳墠user锛坱\_user 鏈夌數璇濆彿鐮侊紝灏卞甫鍑猴級 鍙兘鍦ㄦ梺杈规湁涓寜閽�愯幏鍙栫數璇濄�戯紝璋冪敤寰俊灏忕▼搴忔巿鏉冭幏鍙栫數璇濄�� + +聽 浠ヤ笂淇℃伅濡傛灉t\_user 閲岄潰鏈夊氨鑷姩甯﹁繃鏉ワ紝娌℃湁鏄繀濉」銆� + +聽 鍖哄煙閫夋嫨:鏉ヨ嚦浜巘\_region ,蹇呭～ + +聽 姣旇禌鍚嶇О锛氭潵鑷簬涓婁釜姣旇禌璇︽儏椤甸潰锛� 缂栬緫鏃跺悗鍙癲to闇�瑕佸悗鍙板甫鍑哄寘鍚繖涓瓧娈电殑activity. + +聽 涓汉绠�浠嬶細蹇呭～ + +聽 椤圭洰鍚嶇О锛氬繀濉� + +聽 椤圭洰浠嬬粛锛氬繀濉� + +聽 鏂囨。璧勬枡锛氬繀濉紙鏈�灏戜竴涓級锛屾渶澶�5涓紝鏀寔瑙嗛锛屽浘鐗囷紝word锛宲df 鏂囦欢銆� + +聽 + +聽 鎻愪氦鎸夐挳 + + + +\#### 2.3.3 鎴戠殑 + +\- 椤堕儴鏄ご鍍忥紝涓嬮潰鏄鍚嶏紝鏃佽竟鏄缃寜閽�傜偣鍑昏繘鍏ヨ缃�� + +\- 濡傛灉鐢ㄦ埛鍏宠仈瀛﹀憳锛屽氨鏄剧ず銆愭垜鐨勬瘮璧涖�戙�� + +\- 濡傛灉鐢ㄦ埛鍏宠仈璇勫锛屽氨鏄剧ず銆愭垜鐨勮瘎瀹°�戙�� + +\- 濡傛灉鐢ㄦ埛鍏宠仈鍛樺伐锛屽氨鏄剧ず銆愭垜鐨勫伐浣溿�戙�� + +\- 鍒楄〃灞曠ず锛氭瘡涓瘮璧涙樉绀衡�滃皝闈㈠浘+鍚嶇О+杩涘害鏉★紙寰呭鏍糕啋瀹℃牳閫氳繃鈫掕瘎瀹′腑鈫掑凡鍑虹粨鏋滐級+鏈�缁堝緱鍒嗭紙璇勫鍚庢樉绀猴級鈥濄�� + +\- 璇︽儏鏌ョ湅锛氱偣鍑烩�滆鎯呪�濆彲鐪嬫彁浜よ祫鏂欍�佸鏍哥粨鏋滐紙鎷掔粷鏄惧師鍥狅級銆佽瘎瀹¤瘎璇紙璇勫鍚庢樉锛夈�� + + + +\#### 2.3.4 娑堟伅 + +\- 浠呭睍绀虹郴缁熸帹閫侊紙瀹℃牳缁撴灉銆佽瘎瀹″畬鎴愭彁绀猴級锛屾寜鏃堕棿鍊掑簭锛屼笉鏀寔鍥炲銆� + + + +\#### 2.3.5 璇勫韬唤鍔熻兘 + +\- \*\*鎴戠殑璇勫\*\*锛� + +聽 - 鍒嗙被灞曠ず锛氬垎鈥滄湭璇勫鈥濃�滃凡璇勫鈥漷ab椤碉紝鏄剧ず鈥滄瘮璧涘悕绉�+瀛﹀憳濮撳悕+璇勫鐘舵�佲�濄�� + +聽 - 绛涢�夋敮鎸侊細鎸夋瘮璧涘悕绉扮瓫閫変换鍔°�� + +\- \*\*璇勫鎿嶄綔\*\*锛� + +聽 - 璧勬枡鏌ョ湅锛氱偣鍑烩�滄湭璇勫鈥濆鍛橈紝鏌ョ湅鍏舵姤鍚嶈祫鏂欍�� + +聽 - 璇勫垎鎻愪氦锛氬睍绀鸿瘎鍒嗘ā鏉匡紙璇勫垎椤�+婊″垎鍊硷級锛屽繀濉緱鍒嗭紙鏍￠獙涓嶈秴婊″垎锛夛紝鍙�夊～璇勮锛涙彁浜ゅ悗涓嶅彲淇敼銆� + +\- \*\*娑堟伅\*\*锛氫粎灞曠ず绯荤粺閫氱煡锛堟柊璇勫浠诲姟銆佽瘎瀹″畬鎴愮‘璁わ級锛屾寜鏃堕棿鍊掑簭锛屼笉鏀寔鍥炲銆� + + 浜斻�佽璁¤鐐� @@ -309,12 +540,14 @@ 璇存槑锛氫互鍚庣 application.yml 涓哄噯锛岄伩鍏嶇幆澧冧笉涓�鑷淬�� 褰撳墠閰嶇疆锛堟憳鑷� backend/src/main/resources/application.yml锛夛細 -- URL锛歫dbc:mysql://139.155.104.10:3306/ryc?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai -- 鐢ㄦ埛鍚嶏細ryc -- 瀵嗙爜锛欿iYap3E8X8RLcM6T + +* URL锛歫dbc:mysql://139.155.104.10:3306/ryc?useUnicode=true\&characterEncoding=utf8\&useSSL=false\&serverTimezone=Asia/Shanghai +* 鐢ㄦ埛鍚嶏細ryc +* 瀵嗙爜锛欿iYap3E8X8RLcM6T 瓒呮椂寤鸿锛� -- 鍦ㄦ祴璇曟垨鎵归噺鎿嶄綔鍦烘櫙涓嬶紝杩藉姞 connectTimeout=60000銆乻ocketTimeout=60000 浠ユ彁楂樼ǔ瀹氭�с�� + +* 鍦ㄦ祴璇曟垨鎵归噺鎿嶄綔鍦烘櫙涓嬶紝杩藉姞 connectTimeout=60000銆乻ocketTimeout=60000 浠ユ彁楂樼ǔ瀹氭�с�� 8.2 RabbitMQ 杩炴帴 @@ -344,3 +577,21 @@ Region锛歛p-chengdu + + +Git 鏈嶅姟: + +IP: http://42.193.1.25:9521/ + +鐢ㄦ埛鍚�:ai + +瀵嗙爜:ai@ycl2025 + +搴擄細 + + + +寰俊灏忕▼搴忓紑鍙戣�呭伐鍏� + +璺緞锛欳:\\Program Files (x86)\\Tencent\\寰俊web寮�鍙戣�呭伐鍏� + -- Gitblit v1.8.0