+ Oj :^RIHtHtHtHtHt^RIHt^RIH t ^RI H t ^RI t ^RI t ^RIt^RIt^RIt^RIt^RIt^RIt^RIt^RIt^RIt^RIHt^RIHt]!]4t]!]RR R R .R .ROR.RORR//R7] !] ]R.RR7t] P<P?] P<PA]!4R4t"] P<P?] P<PA]!4R4t#] P<P?] P<PA]!4R4t$0Rmt%Rt&]$]PNR&]&]PNR&/t(])!R]" 24])!R]# 24]PTR4t+]PXR 4t-]P]]/4R!4t0R"t1R#t2R$t3R%t4R&t5R't6RR)lt7R*t8RR+lt9RR,lt:R-t;R.tR1t?R2t@]PR3R .R47R54tB]PR6R .R47R74tC]PR8R .R47R94tDR:tE]PR3R.R47R;4tF]PR8R.R47R<4tG]PR8R.R47R=4tH]PR>R .R47R?4tI]PR>R.R47R@4tJ]PRAR.R47RB4tK]PRAR.R47RC4tL]PRDR .R47RE4tM]PRFR .R47RG4tN]PRHR .R47RI4tO]PRDR.R47RJ4tP]PRFR.R47RK4tQ]PRFR.R47RL4tR]PRMR .R47RN4tS]PROR .R47RP4tT]PRQR .R47RR4tU]PRSR .R47RT4tV]PRSR.R47RU4tW]PRVR.R47]PRW4RX44tY]PRYR.R47RZ4tZ]PR[R .R47R\4t[]PR]R.R47R^4t\]PR_R.R47R`4t]]PRaR .R47Rb4t^]PRcR .R47Rd4t_]PRcR.R47Re4t`RftaRRgltb]PRhR.R47]PRi4Rj44tc]PRk4Rl4tdRmteRntfRotgRpth]PRqR .R47Rr4ti]PRsR.R47]PRi4Rt44tjRutk]PRvR .R47Rw4tl]PRxR.R47Ry4tm]PRzR.R47R{4tn]PR|R .R47R}4to]PR~R .R47R4tp]PR~R.R47R4tq]PRR .R47R4tr]PRR .R47R4ts]PRR .R47R4tt]PRR .R47R4tu]PRR.R47R4tv]PRR.R47R4tw]PRR.R47R4tx]R8XdB])!R4]2!4]y!];!RR44tz])!R]z R24]PR]zRR(R7R#R#))Flaskrequestjsonifysend_from_directory make_response)CORS)Limiter)get_remote_addressN)secure_filename)Imagez/*originshttp://localhost:8080http://127.0.0.1:8080methodsGETPOSTPUTDELETE allow_headerssupports_credentialsT) resourcesz100 per minutez memory://)appdefault_limits storage_uriz../database/app.dbz../database/schema.sqlz ../uploads UPLOAD_FOLDERMAX_CONTENT_LENGTHzDatabase path: z Schema path: c\PR8Xd]\P4pVPp\PP R4pV'dW!R&RVR&RVR&RVR&V#R #) OPTIONSOriginAccess-Control-Allow-OriginGET, POST, PUT, DELETE, OPTIONSAccess-Control-Allow-Methods;Content-Type, Authorization, Cache-Control, Pragma, ExpiresAccess-Control-Allow-Headers3600zAccess-Control-Max-AgeN)rmethodrmake_default_options_responseheadersget)responser(origins app.pyhandle_optionsr-2sr~~"446""$$X. 5;1 22S./2o./,2()#c\PPR4pV'dCVR9d<WPR&RVPR&RVPR&RVPR&V#) rr r!r"r#r$true Access-Control-Allow-Credentialsrr)rr(r))r*r+s& r,add_cors_headersr3?sh __  *F &NN:@67;\78;x78?E;< Or.c\R\V4/4pRVn\PP R4pV'dCVR 9d<W!PR&RVPR&RVPR&RVPR &V#) errorrr r!r"r#r$r0r1r2)rstr status_coderr(r))er*r+s& r,handle_exceptionr:IsQ()HH __  *F &NN:@67;\78;x78?E;< Or.cd\P!\4p\PVnV#N)sqlite3connect DATABASE_PATHRow row_factory)conns r,get_dbrCUs! ??= )D{{D Kr.c\R4\PP\4p\PP V4'g%\P !V4\RV 24\PP \4'g\R4\4p\\RRR7;_uu_4pVP4pRRR4VPX4VP4VP4\R4R#\R4R# +'giL[;i) Initializing database...zCreated directory: u'数据库不存在，创建新数据库rutf-8)encodingNu数据库初始化成功u$数据库已存在，跳过初始化)printospathdirnamer?existsmakedirsrCopen SCHEMA_PATHread executescriptcommitclose)db_dirrBfschemas r,init_dbrXZs $% WW__] +F 77>>& ! ! F #F8,- 77>>- ( ( 78x +sW 5 5VVXF6 6"   () 456 5s D44 E c.\P!^ 4#) )secrets token_urlsafer.r,generate_tokenr^ms   $$r.cV'gR#\4pVP4pVPRV34VP4pVP 4V'gR#\ V4p\ V4VR&V#)Nz SELECT u.* FROM users u JOIN sessions s ON u.id = s.user_id WHERE s.token = ? AND s.expires_at > datetime('now') location)rCcursorexecutefetchonerTdictbuild_location)tokenrBrarowusers& r,get_user_from_tokenripsl  8D [[]F NN   // CJJL  9D%d+D Kr.cV'gR#\4pVP4pVPRV34VP4pVP 4V'd VR,#R#)Nz SELECT u.id FROM users u JOIN sessions s ON u.id = s.user_id WHERE s.token = ? AND s.expires_at > datetime('now') idrCrarbrcrTrfrBrargs& r,get_user_id_from_tokenrnsZ  8D [[]F NN   // CJJL3t9%%r.cvV'gR#^RIpVPRRV4pVP4pVR,#)Nz[%_\\]:NdN)resubstrip)termrrs& r,sanitize_search_termrvs2  66)R &D ::*build_search_conditions..s'Fv!#W vs)%)rvrlen)fields search_term sanitized conditionsvaluess&& r,build_search_conditionsrsY$[1I 2v FKK'Fv'FFFLJ)A #f+ -F  r.c$\RRRV/4V3#)successFr5r)messager8s&&r,error_responsers Iugw7 8+ EEr.c4RRRV/pVeWR&\V4#)rTrrr)rrr*s&& r,success_responsers)4G4H  8 r.c\4pVP4pVPRV34VP4pVP 4V'd VR,#V#)z;SELECT config_value FROM system_config WHERE config_key = ? config_valuerl) config_key default_valuerBrargs&& r,get_config_valuersP 8D [[]F NNPS]R_` // CJJL >"" r.c\4pVP4pVPRV34VP4^,pVP 4V#)z SELECT COUNT(*) FROM tasks WHERE publisher_id = ? AND status IN ('pending', 'in_progress') AND deleted_at IS NULL rluser_idrBracounts& r,get_user_pending_tasks_countrM 8D [[]F NN  OO a EJJL Lr.c\4pVP4pVPRV34VP4^,pVP 4V#)zy SELECT COUNT(*) FROM tasks WHERE acceptor_id = ? AND status = 'in_progress' AND deleted_at IS NULL rlrs& r,get_user_accepted_tasks_countrrr.c\4pVP4pVPRV34VP4^,pVP 4V#)zISELECT COUNT(*) FROM skills WHERE publisher_id = ? AND deleted_at IS NULLrlrs& r,get_user_skills_countrsF 8D [[]F NN^ah`jk OO a EJJL Lr.c$\4pVP4pVPRV34VP4pVP 4V'd;VR,^8d-\ VR,VR,, ^d,4pV R2#R#)z SELECT COUNT(*) as total, SUM(CASE WHEN rating = 'good' THEN 1 ELSE 0 END) as positive_count FROM task_ratings WHERE acceptor_id = ? totalpositive_countr-)rCrarbrcrTround)rrBrargrates& r,get_user_rating_raters~ 8D [[]F NN   // CJJL s7|ac*+c'l:cABqz r.cV'g/#\4pVP4pRPR.\V4,4pVP RV R2V4VP 4pVP 4/pVFSpVR,^8d8\VR,VR,, ^d,4pV R2WVR,&KHRWVR,&KU VFpW9gK RWX&K V#) ,?z SELECT acceptor_id, COUNT(*) as total, SUM(CASE WHEN rating = 'good' THEN 1 ELSE 0 END) as positive_count FROM task_ratings WHERE acceptor_id IN (z#) GROUP BY acceptor_id rrr acceptor_idr)rCrarrrbfetchallrTr) user_idsrBra placeholdersrows rating_maprgrrs & r,get_bulk_user_rating_ratesrs  8D [[]F88SECM12L NN ,n-   ?? DJJLJ w#EFD04vQZJ=) *-0J=) *   $"%J  r.z /api/tasks)rc 6\PPR4p\PPR4p\PPR4p\\PPR^44p\\PPR^ 44pV^, V,p\ 4pVP 4pRpRp .p .p V'd<VR8wd5VR, pV R, p V P V4V P V4\PPR 4p V'dV 'dV PR 4'dV PR 4^,p \V 4pV'dVR 8Xd6VR , pV R , p V P V4V P V4MsVR8XdmVR, pV R, p V P V4V P V4VR, pV R, p V PRR.4V PRR.4V'dO.ROp\W4wppV'd5VV, pV V, p V PV4V PV4VPW4VP4^,pVR, pV PWE.4VPW4VP4p\!\#RV444p\%V4p.pVFKp\'V4pVPVR,R4VR&\)VRR7VR&VP V4KM VP+4\-RVRVRVRV/4#)statustypesearchpagelimitz SELECT t.*, u.phone as publisher_phone FROM tasks t LEFT JOIN users u ON t.publisher_id = u.id WHERE t.deleted_at IS NULL z3SELECT COUNT(*) FROM tasks WHERE deleted_at IS NULLallz AND status = ? AuthorizationBearer  publishedz AND publisher_id = ?acceptedz AND acceptor_id = ?z AND status IN (?, ?) in_progress completed* ORDER BY created_at DESC LIMIT ? OFFSET ?c3T"TFqR,'gKVR,xK R#5i publisher_idNr]rrgs& r,rget_tasks..T#XDSDWDW0S00D((rrpublisher_rating_rateTrr`itemsrtitle descriptionrxryrzr{)rargsr)intrCrar~r( startswithsplitrnextendrrbrcrlistsetrrdrerTr)r type_paramrrroffsetrBraquery count_queryparams count_params auth_headerrfcurrent_user_id search_fields search_cond search_paramsrr publisher_idsrrrgtasks r, get_tasksrs \\  h 'F!!&)J \\  h 'F w||* +D    "- .EQh% F 8D [[]F E HK FL &E/ ""((  fF#//%%o6Kkk&<&7JC(P $%)$tDZ T   JJL   r.z/api/tasks/countcb\PPR4pV'dVPR4'g \ RR4#VP R4^,p\ V4pV'g \ RR4#\\RR44p\V4p\RVR V/4#) rr 未登录r登录已过期max_publish_tasks3rmax) rr(r)rrrrnrrrr)rrfr max_publish current_counts r,get_task_countrgs//%%o6K k44Y??k3//   c "1 %E$U+G /55&':C@AK09M G]E;? @@r.z/api/tasks/c\4pVP4pVPRV34VP4pVP 4V'g \ R4#\ V4p\VRR7VR&\V4#)a SELECT t.*, u.nickname as acceptor_name, u.phone as acceptor_phone, u.avatar as acceptor_avatar, r.rating as task_rating, r.comment as task_rating_comment, r.created_at as rating_created_at FROM tasks t LEFT JOIN users u ON t.acceptor_id = u.id LEFT JOIN task_ratings r ON t.id = r.task_id WHERE t.id = ? AND t.deleted_at IS NULL 任务不存在Trr` rCrarbrcrTrrdrer)task_idrBrargresults& r,get_taskrxsv 8D [[]F NN  // CJJL /00 #YF'tDF: 6?r.c\PPVR4p\PP4pW8# \dp\ RT 24Rp?R#Rp?ii;i)z%Y-%m-%d %H:%Mu时间验证失败: NF)datetimestrptimenow ExceptionrI) task_time_str task_time current_timer9s& r,validate_task_timers`%%..}>NO ((,,. ''  $QC()sAA A(A##A(cf\Pp\4pVP4pVP R4pV'd-\ V4'gVP 4\R4#\PP R4pRpV'dVPR4'dVPR4^,pVPRV34VP4pV'dyVR,^8wdVP 4\RR 4#VR ,p\\R R 44p\V4p W8d VP 4\R V R24#VPRVP R4VP R4VP R4VP R4VP R4VP R4VP R4VP R4VP R4VVP R4VP R4VP RR4VP RR434VP p VP#4VPRV 34VP4p VP 4\%\'V 44#)time$任务时间必须晚于当前时间rNrrz SELECT u.id, u.enabled FROM users u JOIN sessions s ON u.id = s.user_id WHERE s.token = ? AND s.expires_at > datetime('now') enabledu'账户已被禁用，无法发布任务rkrru(待处理+进行中的任务数最多为个，暂时无法发布z INSERT INTO tasks (title, description, province, city, district, street, detail_location, time, reward, publisher_id, publisher_name, contact, status, type) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) rrrxryrzr{r|rewardpublisher_namecontactrpendingrrz SELECT * FROM tasks WHERE id = ?)rjsonrCrar)rrTrr(rrrbrcrrr lastrowidrSrrd) rrBrarrrrfrhrrr created_tasks r, create_taskrs4 <9d#VPR4VPR4VR,R8XdRV9d{VR,pV'g5VP R V34VP 4pV'd VR,pVP R!VVR",VVR,VPR#R$434VR,R%8XEd\PPR&4p V 'EdV PR'4'EdjV PR(4^,p VP R)V 34VP 4p V 'Ed&V R*,^8wdVP 4\R+R,4#V R-,pV R.,p V R/,p V R0,p\\R1R244p\!V4pVV8d VP 4\R3V R424#VPR4VPV4VPR54VPV 4VPR64VP\"P"P%4P'R744R8V9d*VPR94VPVR8,4V'dIVPV4R:R;P)V4 R<2pVP VV4VP+4VP RV34VP 4pVP 4V'g \R=4#\-\/V44#)?z7SELECT * FROM tasks WHERE id = ? AND deleted_at IS NULLrrrrtitle=?r description=?rx province=?rycity=?rz district=?r{street=?r|zdetail_location=?ztime=?rzreward=?r publisher_name=?r  contact=?rzstatus=?z acceptor_id=?Nrratingrz6SELECT acceptor_id FROM task_ratings WHERE task_id = ?z INSERT OR REPLACE INTO task_ratings (task_id, publisher_id, acceptor_id, rating, comment) VALUES (?, ?, ?, ?, ?) rrating_commentrprrrrz SELECT u.id, u.enabled, u.nickname, u.phone, u.avatar FROM users u JOIN sessions s ON u.id = s.user_id WHERE s.token = ? AND s.expires_at > datetime('now') ru'账户已被禁用，无法承接任务rrknicknamephoneavatarmax_accept_tasksru已承接的任务数最多为u个，暂时无法承接zacceptor_name=?z accept_time=?%Y-%m-%d %H:%M:%Srztype=?zUPDATE tasks SET , WHERE id=?任务不存在或已删除)r  cancelled)rr rCrarbrcrTrrr~r)r(rrrrrrrstrftimerrSrrd)rrrBra existing_task update_fields update_valuesrexisting_ratingrrfrh acceptor_nameacceptor_phoneacceptor_avatar max_acceptrr updated_tasks& r, update_taskr.s? <5 5   1   & >[ (4+M: "NN#[^e]gh&,oo&7O&&5m&D   !.1NHH-r2   >] *!//--o>K{{55i@@#))#.q1 X  (4I!+ -.WY\]]"&t*K$($4M%)']N&*8nO!$%56H#%N!OJ$A+$NM$ 2 -0NzlZr.stt!((9!((5!(():;!((7!((9!(():):)>)>)@)I)IJ])^_ ~X&T&\*W%#DIIm$<#=[Ium,  NNLwjY??$LJJL ;<< 4 % &&r.c \4pVP4pVPRV34VP4VP^8XdVP 4\ R4#VP 4\R4#)zQUPDATE tasks SET deleted_at = datetime("now") WHERE id = ? AND deleted_at IS NULLr" 删除成功rCrarbrSrowcountrTrr)rrBras& r, delete_taskr3cse 8D [[]F NNfiphrsKKM ! ;<<JJL N ++r.z/api/carouselsc\4pVP4pVPR4VP4pVP 4\ VUu.uFp\ V4NK up4#uupi)z+SELECT * FROM carousels ORDER BY sort_orderrCrarbrrTrrdrBrarrgs r, get_carouselsr7qsW 8D [[]F NN@A ?? DJJL .#DI. //.A0c \Pp\4pVP4pVP RVP RR4VP R4VP R4VP R4VP R^434VP pVP4VP4\RV/VC4#)z| INSERT INTO carousels (page_type, image_url, image_color, link_url, sort_order) VALUES (?, ?, ?, ?, ?) page_type task_list image_url image_colorlink_url sort_orderrk rr rCrarbr)r rSrTr)rrBra carousel_ids r,create_carouselrB{s <c \Pp\4pVP4pVP RVP RR4VP R4VP R4VP R4VP R^4V34VP 4VP4VP^8Xd \R4#\RV/VC4#) z UPDATE carousels SET page_type=?, image_url=?, image_color=?, link_url=?, sort_order=? WHERE id=? r:r;r<r=r>r?轮播图不存在rk) rr rCrarbr)rSrTr2rr)rArrBras& r,update_carouselrEs <.rrrrrr`rrr)rrr)rrCrarrbrcrrrrrdrer~rTr)rrrrrBrarrrrrrrrrgskills r, get_skillsrLs \\  h +F w||* +D    "- .EQh% F 8D [[]FVM!8!OKMk][]jk!!$'(3m4  -} ,e ,V ,  . MN!!$ _   ?? DXDXXYM+M:J ES )3N8KS)Q%&*51j U   JJL   r.z/api/skills/c \4pVP4pVPRV34VP4pVP 4V'g \ R4#\ V4p\V4VR&\V4#)8SELECT * FROM skills WHERE id = ? AND deleted_at IS NULLu技能不存在r`r)skill_idrBrargrs& r, get_skillrPsl 8D [[]F NNMPX{[ // CJJL /00 #YF'/F: 6?r.z/api/skills/countcb\PPR4pV'dVPR4'g \ RR4#VP R4^,p\ V4pV'g \ RR4#\\RR44p\V4p\RVR V/4#) rrrrrrmax_publish_skills1rr) rr(r)rrrrnrrrr)rrfr max_skillsrs r,get_skill_countrUs//%%o6K k44Y??k3//   c "1 %E$U+G /55%&:C@AJ)'2M G]E:> ??r.c\Pp\4pVP4pRp\PP RR4P RR4pV'dVPRV34VP4pV'dVPRVR,34VP4pV'dyVR,^8wdVP4\RR 4#VR ,p\\R R 44p\V4pW8d VP4\R V R24#VPRVP R4VP R4VP R4VP R4VP R4VP R4VVP R4VP R43 4VPp VP4VP4\!R V /VC4#)Nrrprz,SELECT user_id FROM sessions WHERE token = ? SELECT * FROM users WHERE id = ?rru'账户已被禁用，无法发布技能rrkrRrSu已发布的技能数最多为rz INSERT INTO skills (title, description, province, city, district, street, publisher_id, publisher_name, contact) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) rrrxryrzr{r r )rr rCrar(r)replacerbrcrTrrrrr rSr) rrBrar auth_tokensessionrhrTrrOs r, create_skillr[s <kJu,  NNMPX{[OO%MJJL ;<< 4 & ''r.c \4pVP4pVPRV34VP4VP^8XdVP 4\ R4#VP 4\R4#)zRUPDATE skills SET deleted_at = datetime("now") WHERE id = ? AND deleted_at IS NULLr]r0r1)rOrBras& r, delete_skillrause 8D [[]F NNgjrituKKM ! ;<<JJL N ++r.z/api/skills/myc\PPR4pV'dVPR4'g \ RR4#VP R4^,p\ V4pV'g \ RR4#\4pVP4pVPRV34VP4pVP4\VUu.uFp\V4NK up4#uupi)rrrrrrz[SELECT * FROM skills WHERE publisher_id = ? AND deleted_at IS NULL ORDER BY created_at DESC)rr(r)rrrrnrCrarbrrTrrd)rrfrrBrarrgs r, get_my_skillsrcs//%%o6K k44Y??k3//   c "1 %E$U+G /55 8D [[]F NNpszr|} ?? DJJL .#DI. //.sC3z /api/usersc L\PPRR4p\\PPR^44p\\PPR^ 44pV^, V,p\ 4pVP 4pV'dvVP RR\V4 R2R\V4 R234VP4^,pVP RR\V4 R2R\V4 R2W#34M;VP R4VP4^,pVP RW#34VP4pVP4\R VUu.uFp\V4NK upR VRVRV/4#uupi) rrprrzc SELECT COUNT(*) FROM users WHERE phone LIKE ? OR nickname LIKE ? rz SELECT * FROM users WHERE phone LIKE ? OR nickname LIKE ? ORDER BY created_at DESC LIMIT ? OFFSET ? zSELECT COUNT(*) FROM usersz=SELECT * FROM users ORDER BY created_at DESC LIMIT ? OFFSET ?rr) rrr)rrCrarbrvrcrrTrrd) rrrrrBrarrrgs r, get_usersres \\  h +F w||* +D    "- .EQh% F 8D [[]F  &v./q1Q7KF7S6TTU3V W Y!!$ &v./q1Q7KF7S6TTU3VX] f  h 34!!$VY^Xgh ?? DJJL t,t$s)t,  ,s?F! z/api/users//tasksc a a a a \4pVP4o S PRV34S P4pV'g VP 4\ RR/4R3#\ \PPR^44p\ \PPR^ 44o \PPRR4o V^, S ,o RV V V V 3RllpV!R V..RO4wrVV!R V..RO4wrxVP 4\ R \V4R VR VRVRV/4#)rWr5用户不存在rrrrpc<VPR4^,PR4^,P4pS'd6V'd.\VS4wrEW,pRV,V,p.VOVOpM TpRV,pTpSPWx4SP 4^,p S'dV'd .VOXOSNSNp M.VOSNSNp SPVR,V 4SP 4p .p V EFhp \ V 4p.pVPR4'dVPVR,4VPR4'dVPVR,4VPR4'dVPVR,4VPR4'dVPVR,4VPR4;'gR pV'dR PV4MR pV'dV'dVR ,V,VR &M0V'dVVR &M"V'dVVR &MVPR 4VR &V PV4EKk W3#)WHEREORDERz!SELECT COUNT(*) FROM tasks WHERE rrxryrzr{r|rpr}N r`) rrtrrbrcrrdr)r~r) query_baserrquery_conditionrr full_queryrrr full_paramsrtasks_with_locationrg task_dictrdetail_address base_locationrarrrs&&& r,get_paginated_tasks+get_user_tasks..get_paginated_taskss$**73A6<c\4pVP4pVPRV34VP4pVP 4V'g\ RR/4R3#\ \ V44#)rWr5rgrhrCrarbrcrTrrd)rrBrargs& r,get_userr~sb 8D [[]F NN5zB // CJJL !234c99 49 r.c\Pp\4pVP4p.p.pRV9d*VP R4VP VR,4RV9d*VP R4VP VR,4RV9d*VP R4VP VR,4RV9d*VP R4VP VR,4RV9d*VP R 4VP VR,4R V9d*VP R 4VP VR ,4R V9d*VP R 4VP VR ,4RV9d*VP R4VP VR,4V'g VP 4\ RR/4R3#RRPV4 R2pVP V4VPWe4VP4VP 4VP^8Xd\ RR/4R3#\ RV/VC4#)rz nickname=?genderzgender=?rxrryrrzrr{rrzphone=?rz enabled=?r5u没有需要更新的字段zUPDATE users SET r r!rgrhrk) rr rCrar~rTrrrbrSr2)rrrBrar&r'rs& r, update_userr&s <?@#EE - 89 EE! NN5(KKMJJL !!234c99 D'*T* ++r.z/api/auth/loginz 10 per minutecVRp\PpVPR4pVPR4pV'd V'g*\RR/4R3V'dVP 4##VP 4'd\ V4^ 8wd*\RR/4R3V'dVP 4##VP 4'd\ V4^8wd*\RR/4R3V'dVP 4##\4pVP4pVPRV34VP4pV'g5VPR V^34VPpVP4R pM VR ,pR pVPR V34VP4R,pV^8wd7VP 4\!RR4V'dVP 4##\#4p \$P$P'4\$P(!^R7,P+R4p VPRV34VPRWiV 34VP4VPRV34VP4pVP 4RT RR VR ,RVR,RVR,RVR,RVR,RVR,RVR,/RTRVR,;'d VR,'*/p \V 4V'dVP 4## #;i #;i #;i \PdCTP4TPRT34TP4pTR ,pR pELi;i #;i #;i \,d;p \RR/4R 3uRp ? T'dTP 4# #;i#Rp ? ii;i T'dTP 4i i;ii;i)!Nrcoder5u!手机号和验证码不能为空ru 请输入正确的11位手机号u请输入4位验证码z#SELECT * FROM users WHERE phone = ?z0INSERT INTO users (phone, enabled) VALUES (?, ?)TrkFz&SELECT enabled FROM users WHERE id = ?ru!账户已被禁用，无法登录r)hoursrz&DELETE FROM sessions WHERE user_id = ?zBINSERT INTO sessions (user_id, token, expires_at) VALUES (?, ?, ?)zXSELECT id, phone, nickname, avatar, gender, location, created_at FROM users WHERE id = ?rfrhrrrr` created_at is_new_user need_profileu!服务器错误，请稍后重试r6)rr r)rrTisdigitrrCrarbrcr rSr=IntegrityErrorrollbackrr^rr timedeltar$r) rBrrrrarhrr user_enabledrf expires_atrr9s r,loginrYs DM||!xxDG%HIJCOD    A}}#e*"2G%GHI3N~    {||~~TaG%=>?Dx    uxN=N=;M AN=2MAN=&N/8DN= N=.N6MM MAN,(N=+N,,N=/N36N:= PO=PP$O55O9=PP P(P P( P$"P(z/api/auth/logoutc^\PPR4pV'd}VPR4'dfVP R4^,p\ 4pVP 4pVPRV34VP4VP4\R4#)rrrz$DELETE FROM sessions WHERE token = ? 登出成功 rr(r)rrrCrarbrSrTrrrfrBras r,logoutrs~//%%o6K{--i88!!#&q)x=xH  N ++r.z /api/auth/mec \PPR4pV'dVPR4'g\ RR/4R3#VP R4^,p\ V4pV'g \RR4#\ V4#)rrr5rrr!登录已过期，请重新登录)rr(r)rrrrir)rrfrhs r,get_current_userrsx//%%o6K k44Y??-.33   c "1 %E u %D A3GG 4=r.z /api/userc \PPR4pV'dVPR4'g\ RR/4R3#VP R4^,p\ V4pV'g\ RR/4R3#\PpVPR4'g\ RR/4R 3#\4pVP4pVPR VPR4VPR 4VPR 4VPR 4VPR4VPR4VPR4VR,34VP4VPRVR,34VP4pVP4\ \V44#)rrr5rrrrru昵称不能为空rz UPDATE users SET nickname=?, avatar=?, gender=?, province=?, city=?, district=?, street=? WHERE id=? rrrxryrzr{rkrW)rr(r)rrrrir rCrarbrSrcrTrd)rrfrhrrBra updated_users r,update_profilersp//%%o6K k44Y??-.33   c "1 %E u %D !DEFKK <c\4pVP4pVPRV34VP4pVP 4V'g\ RR/4R3#\ \ V44#)0SELECT * FROM system_config WHERE config_key = ?r5配置不存在rhr})rrBrargs& r, get_configrsb 8D [[]F NNE }U // CJJL !234c99 49 r.c\Pp\4pVP4pVP RV34VP 4pV'g VP 4\RR/4R3#VP RVPR4V34VP4VP RV34VP 4pVP 4\\V44#)rr5rrhz{ UPDATE system_config SET config_value = ?, updated_at = datetime('now') WHERE config_key = ? r rr rCrarbrcrTrr)rSrd)rrrBraexistingupdated_configs& r, update_configr s <!kk% HHME 5M)E 22 & ( jj)0%2B2B2J2JK ZZ\FHHVFGH4 ++-( "w|1  8 KKN Mr.z /api/uploadz 5 per minutec R\P9d\RR/4R3#\PR,pVPR8Xd\RR/4R3#\ VP4'g\RR/4R3#VP 4p\ V4\^,8d\RR/4R3#\P!V4p\P!V4pVP4VP^4TP^4\T4p\!TP4pTP#R ^4p\ T4^8d.\$P&!4P( R T^, R2pM%\$P&!4P( R T R2p\*P,P/\0P2R,T4p \T R4;_uu_4p T P5TP744R R R 4\ T4p TP94p ^Y, , ^d,p RT 2p\RTRTRT RT RT R R2/4# \dp\RR/4R3uR p?#R p?ii;i \dp\RR /4R 3uR p?#R p?ii;i +'giL;i)filer5u没有上传文件rrpu没有选择文件u不支持的文件格式u文件大小不能超过5MBu无效的图片文件Nu图片处理失败r6r_z.jpgrwbz /uploads/urlr original_sizecompressed_sizecompression_ratioz.1fr)rfilesrrrrQr MAX_FILE_SIZErrr rOverifyrrrr ruuiduuid4hexrJrKrrconfigwritegetvaluer)r file_contentrrr9compressed_bufferr name_partsunique_filename save_pathrVrrrfile_urls r, upload_filerCsW]]"!567<< == D }}!567<<  & &!;<=sBB99;L <=1,,!>?@#EE**\*K@jj% Q=*;7t}}-Ha(J :!ZZ\--.a 1 dC!ZZ\--.az> SZZ8/JI i  ! !**,-  %M',,.O_<<C?+,H  xO? 1#6a8  5 @!89:C??@ =!567<<=  sH7I4 J= K4 J?J JJ J?&J:4J?:J? K z/uploads/cD\\PR,V4#)r)rrrrs&r, uploaded_filer}s szz/:H EEr.c\P!4p\P!VPR4V4P R4#rG)bcryptgensalthashpwencodedecode)passwordsalts& r, hash_passwordrs3 >> D ==14 8 ? ? HHr.cl\P!VPR4VPR44#r)rcheckpwr)rhashed_passwords&&r,verify_passwordrs' >>(//'2O4J4J74S TTr.ch\\P!44p\P!^^4p\P!^^4p.R Op\P !V4pVR8XdW,pV RV R2pMdVR8Xd W8dW3MW!3wrW, pV RV R2pM>\P!^^ 4p\P!^^ 4pW,pV RV R2pR\V4R\ P P4\ P!^R 7,/\V&W3#) +rz + z = ?z - u × textrminutes)rr×) r7rrrandomrandintchoicerrr captcha_store) captcha_idnum1num2 operatorsoprdisplays r,generate_captcharsTZZ\"J >>!R D >>!R D I y !B SyF#dV4( s%)\d\| F#dV4(~~a$~~a$F$tfD) F h''++-0B0B10MM!M*  r.c L^^2r!.pVPRV RV R24VPR4\^24Fp\P!^V4p\P!^V4p\P!^^4pR\P!^^4 R\P!^^4 R\P!^^4 R2pVPRV R V R V R V R 2 4K VPR V R24VPR4RP V4#)z/z1zrgb(r ��r���z zwzzrp)r~rangerrr) display_textrr svg_partsrxyrFcolors & r,create_svg_captchars56I FugZX^W__abc HJ 2Y NN1e $ NN1f % NN1a v~~c3/06>>#s3K2LBv~~^acfOgNhhij<s&58E7#NO OP\O]]def X 779 r.z/api/admin/captchacZ\4wr\RVRV/4pRVPR&V#)rquestionz.no-store, no-cache, must-revalidate, max-age=0 Cache-Control)rrr()rr r*s r, get_captchars>/1JjLH)YH_% Or.z/api/admin/loginc B\PpVPR4pVPR4pVPR4pVPR4pV'd V'g\RR/4R3#V'd V'g\RR/4R3#\PV4pV'g\RR/4R3#\ P P 4VR ,8d\V\RR/4R3#VP4VR ,8wd\RR /4R3#\V\4pVP4pVPR V34VP4pV'g VP4\RR /4R3#\W(R,4'g VP4\RR /4R3#\P!^ 4p \ P P 4\ P !^R7,P#R4p VPRVR,34VPRVR,W34VP%4VP4\RV RRVR,RVR,//4#)usernamerrcaptchar5u用户名和密码不能为空ru验证码不能为空u验证码已过期rru验证码错误z,SELECT * FROM admin_users WHERE username = ?u用户名或密码错误rrrz-DELETE FROM admin_sessions WHERE admin_id = ?rkzIINSERT INTO admin_sessions (admin_id, token, expires_at) VALUES (?, ?, ?)rfadmin)rr r)rrrrupperrCrarbrcrTrr[r\rr$rS) rrrr captcha_input captcha_datarBra admin_userrfrs r, admin_loginrsK <,>r,JJTTUhiJ NNBZPTEUDWX NN^t$e8:KKMJJL  *T"  :.  r.cV'gR#\4pVP4pVPRV34VP4pVP 4V'd \ V4#R#)Nz SELECT u.* FROM admin_users u JOIN admin_sessions s ON u.id = s.admin_id WHERE s.token = ? AND s.expires_at > datetime('now') )rCrarbrcrTrdrms& r,get_admin_from_tokenrsZ  8D [[]F NN   // CJJL49%%r.z /api/admin/mec>\PPR4pV'dVPR4'g \ RR4#VP R4^,p\ V4pV'g \ RR4#\RVR,RVR,/4#)rrrrrrrkr)rr(r)rrrrr)rrfrs r,get_current_adminr s//%%o6K k44Y??k3//   c "1 %E  'E A3GG D%+z53DE FFr.z/api/admin/passwordc2\PPR4pV'dVPR4'g \ RR4#VP R4^,p\ V4pV'g \ RR4#\PpVPR4pVPR4pV'd V'g \ R4#\4pVP4pVPR VR ,34VP4R ,p\WH4'g VP4\R R /4R3#VPR\V4VR ,34VP!4VP4\#R4#)rrrrrr old_password new_passwordu!旧密码和新密码不能为空z-SELECT password FROM admin_users WHERE id = ?rkrr5u旧密码错误rzm UPDATE admin_users SET password = ?, updated_at = datetime('now') WHERE id = ? u密码修改成功)rr(r)rrrrr rCrarbrcrrTrrrSr) rrfrrr"r#rBracurrent_passwords r,change_admin_passwordr%sC//%%o6K k44Y??k3//   c "1 %E  'E A3GG <c\4pVP4pVPRV34VP4pVP 4V'g \ R4#\ \V44#)a SELECT r.*, t.title as task_title, t.description as task_description, u.nickname as acceptor_name, u.phone as acceptor_phone, p.nickname as publisher_name, p.phone as publisher_phone FROM task_ratings r LEFT JOIN tasks t ON r.task_id = t.id LEFT JOIN users u ON r.acceptor_id = u.id LEFT JOIN users p ON r.publisher_id = p.id WHERE r.id = ? 评价不存在)rCrarbrcrTrrrd) rating_idrBrargs& r,get_admin_ratingr.}sa 8D [[]F NN    // CJJL /00 49 r.c \4pVP4pVPRV34VP4VP^8XdVP 4\ R4#VP 4\R4#)z%DELETE FROM task_ratings WHERE id = ?r,r0r1)r-rBras& r,delete_admin_ratingr0sc 8D [[]F NN:YLIKKM ! /00JJL N ++r.z /api/newsc\4pVP4pVPR4VP4pVP 4\ VUu.uFp\ V4NK up4#uupi)zVSELECT * FROM news WHERE status = "published" ORDER BY sort_order ASC, created_at DESCr5r6s r,get_newsr2sW 8D [[]F NNkl ?? DJJL .#DI. //.r8z/api/admin/newsc\4pVP4pVPR4VP4pVP 4\ VUu.uFp\ V4NK up4#uupi)z;SELECT * FROM news ORDER BY sort_order ASC, created_at DESCr5r6s r, get_all_newsr4sW 8D [[]F NNPQ ?? DJJL .#DI. //.r8z/api/news/c\4pVP4pVPRV34VP4pVP 4V'g\ RR/4R3#\ \ V44#)z8SELECT * FROM news WHERE id = ? AND status = "published"r5资讯不存在rhr}news_idrBrargs& r,get_news_by_idr9sc 8D [[]F NNMPWzZ // CJJL !234c99 49 r.z/api/admin/news/c\4pVP4pVPRV34VP4pVP 4V'g\ RR/4R3#\ \ V44#)SELECT * FROM news WHERE id = ?r5r6rhr}r7s& r,get_admin_news_by_idr<sb 8D [[]F NN4wjA // CJJL !234c99 49 r.c \Pp\4pVP4pVP RVP R4VP R4VP R4VP R4VP RR4VP R^434VP pVP4VP4\RV/VC4#) zy INSERT INTO news (title, summary, content, image_url, status, sort_order) VALUES (?, ?, ?, ?, ?, ?) rsummarycontentr<rrr?rkr@)rrBrar8s r, create_newsr@s <r?r<rr?r)r8rrBrar updated_newss& r, update_newsrCs <gifjpgpngjpegwebpi)F)r)u 操作成功N)iPi)|flaskrrrrr flask_corsr flask_limiterr flask_limiter.utilr r=rJsysrrr[rstringhashlibrrwerkzeug.utilsr PILr __name__rlimiterrKrrL__file__r?rPrrrrrrIbefore_requestr- after_requestr3 errorhandlerrr:rCrXr^rirnrvrerrrrrrrrrrouterrrrrr.r3r7rBrErGrLrPrUr[r_rarcrer{r~rrrrrrrrrrrrrrrrrrrrrr r%r'r*r.r0r2r4r9r<r@rCrErrJrunr]r.r,rfs( MM!1   * HoS +-DE>`    $%   RWW__X68LM ggll277??846NO  RWW__X6 E : + ?#0    '( k]#$  )   6&%$ & @F   $B<%)R*Rh w/A0A  %w78,<&*A'+A'F %w7D'8D'L %z: ,; , eW-0.0 fX.0/0, -w?0@04 -zB 0C 0=5'*5+5n '%9 :  0@1@ =6(+.-,.-` '%9.(:.(` '(< ,= , eW-0.0&<%)#*#J +eW=Y>Yv %w7 8  %w70,80,d vh/O 0Ob x0 ,1 ,>E7+ , ;((')('T 01=5'*0+0 %w78 %w7)8):D0=6(+~6,6p !F"FIU4$ %12 x0~616p &?UG, G- G 5'2$23$2L 1 ,2 , %1222h /%AB. /(D ,E ,;(0)0 ug.0/0 $ug6 7  *UG< = ;),*,. $ug6 '7 'D $xj9 0: 0 z $% I 7 8D *4& 45GG$T GF r.