+ (jP^RIHtHt^RIHt^RIHt^RIHtH t ^RI H t Rt R#))requestjsonify)get_db)admin_required)error_responsebuild_search_conditions)get_config_valuec@VPRR.R7\R44pVPRR.R7\R44pVPRR.R7\R44pVPRR.R7R 4pVPR R .R7R 4pR #)z/api/admin/suggestionsGET)methodsc f\PPR4p\\PPR^44p\\PPR^ 44pV^, V,p\ 4pVP 4pRpRp.p.p V'dL.ROp \ W4wrV 'd3Wk, pW{, pVPV 4V PV 4VPWy4VP4^,p VR, pVPW#.4VPWh4VP4pVUu.uFp\V4NK pp\RVRV RVRV/4VP4#uupi TP4i;i) searchpagelimitz2SELECT * FROM suggestions WHERE deleted_at IS NULLz9SELECT COUNT(*) FROM suggestions WHERE deleted_at IS NULLz* ORDER BY created_at DESC LIMIT ? OFFSET ?itemstotal)phonenicknamecontent)rargsgetintrcursorrextendexecutefetchonefetchalldictrclose)rrroffsetconnrquery count_queryparams count_params search_fields search_cond search_paramsrrowsrowrs HE:\Work\靠谱人脉\软件相关\BangBang\backend\routes\suggestions.pyget_admin_suggestions9register_suggestion_routes..get_admin_suggestionssd!!(+7<<##FA./GLL$$Wb12(e#x HEUKFL @ -D]-[* (E.KMM-0 '' 6 NN; 5OO%a(E A AE MM5/ * NN5 )??$D*./$3T#Y$E/GUGUFD'SXYZ JJL 0 JJLsCF F4FFF0z*/api/admin/suggestions/c6\4pVP4pVPRV34VP4pV'g\ R4VP 4#\ \V44VP 4# TP 4i;i)z=SELECT * FROM suggestions WHERE id = ? AND deleted_at IS NULLu建议不存在)rrrrrrrr) suggestion_idr!rr*s& r+get_admin_suggestion8register_suggestion_routes..get_admin_suggestion0srx  NNZ]j\l m//#C%&78 JJL49% JJLDJJLs5B"BBDELETEc\4pVP4pVPRV34VP4VP^8d \ RRRR/4VP 4#\ RRRR/4VP 4# \dpTP4ThRp?ii;i TP 4i;i)zWUPDATE suggestions SET deleted_at = datetime('now') WHERE id = ? AND deleted_at IS NULLsuccessTmessageu 删除成功Fu建议不存在或已被删除N) rrrcommitrowcountrr Exceptionrollback)r/r!res& r+delete_admin_suggestion;register_suggestion_routes..delete_admin_suggestion@sx  NNvzGyI J KKM" 4NKL JJL  5)=]^_ JJL   MMOG  JJLs*AB/B B0B++B00B33Cz/api/suggestions/can-submitc \PPR4pV'dVPR4'g\ RRRR/4#VP R4^,p\ 4pVP4pVPRV34VP4pV'g \ RRRR/4VP4#VPR VR ,34VP4pV'g \ RRRR /4VP4#\\R R 44pVPRVR,34VP4^,pWv8d+\ RRRRV RV R2RVRV/4VP4#\ RRRRRVRV/4VP4# TP4i;i) AuthorizationzBearer can_submitFr5u 请先登录 zMSELECT user_id FROM sessions WHERE token = ? AND expires_at > datetime("now")u!登录已过期，请重新登录zESELECT phone, nickname FROM users WHERE id = ? AND deleted_at IS NULLuser_idu用户不存在max_suggestions_per_day1SSELECT COUNT(*) FROM suggestions WHERE phone = ? AND date(created_at) = date('now')r您今天已提交!条建议，每天最多可提交u条 today_count max_countTu可以提交建议) rheadersr startswithrsplitrrrrrrr ) auth_headertokenr!rsessionusermax_suggestionscounts r+can_submit_suggestion9register_suggestion_routes..can_submit_suggestionSsoo))/: +"8"8"C"CL%NKL L!!#&q)x$  NNjmrlt uoo'G eY@cde> JJL; NNbelmvewdy z??$D eY@QRS2 JJL/""23Lc"RSO NNeg  OO%a(E' %!3E7:[\k[llop!5   JJLd/u_  JJLDJJLs%9F5 1F5=F5A%F5F55Gz/api/suggestionsPOSTc \PpVPR4pVPR4pVPR4pV'd V'g \R4#\ \ RR44p\ 4pVP4pVPRV34VP4^,pWt8d)\RRR R V R V R 2R R/4VP4#VPRWV34VP4WG, ^, pRp V^8dV RV R2, p \RRR V /4VP4# \dp TP4T hRp ? ii;i TP4i;i)rrru$手机号和建议内容不能为空rBrCrDr4Tr5rErFu条，感谢您的关注！already_submittedzCINSERT INTO suggestions (phone, nickname, content) VALUES (?, ?, ?)u*建议提交成功，感谢您的反馈！u（今天还可提交u条）N)rjsonrrrr rrrrrrr6r8r9) datarrrrPr!rrQ remainingr5r:s r+create_suggestion5register_suggestion_routes..create_suggestionsz||!88J'((9%G!"HI I./H#NOx  NNe OO%a(E't!3E7:[\k[lmH I' , JJL! NNU'*  KKM'/!3IBG1}29+VDDItY@A JJL   MMOG  JJLs,AE'AE E1E,,E11E44FN)router)appr,r0r;rRrZs& r+register_suggestion_routesr^sYY'%Y9$:$L YY;eWYM N  YY;hZYPQ" YY,ugY>-?-^ YY!F8Y4-5-N) flaskrrutils.databaser utils.authr utils.helpersrr utils.configr r^r_r+rfs"!%A)jr_