+ 7 R?R&7]!R@4]!R43RARBll4tRRCRDltSRERFltTER)RGRHlltU]2PRI] R+7RJRKl4tV]2PRL] R+7RMRNl4tW]2PRO] R+7RPRQl4tX]2PRR]YRS7RTRUl4tZ]2PRV4]!^^RWRX7]!^ ^^dRYRZ7]!R4]!R4]!R43R[R\ll4t[R]t\ER*R^R_llt]R`Ralt^Rbt_RcRdlt`ReRfltaRgRhltb]2PRiRjR&7]!R@4]!R4]!R4]!R43RkRlll4tc]2PRm] R+7RnRol4td]2PRp] R+7RqRrl4te]2PRs] R+7RtRul4tf]2PRvRw] Rx7RyRzl4tg]2PRvR{] Rx7]!R@4]!R@43R|R}ll4th]2PR~R] Rx7RRl4ti]2PRR] Rx7RRl4tj]2PR] RR7RRl4tk]2PRR] Rx7RRl4tl]2PRR] Rx7]!R@4]!R@4]!R@43RRll4tm]2PRR] Rx7RRl4tn]7R%, R, R, to]2PRRR&7RRl4tp]2PR] R+7RRl4tq]2PR] RR7RRl4tr]2PRR] Rx7RRl4ts]2PR] R+7RRl4tt]2PRR] Rx7ER+RRll4tu^RIH%t%]2PR]%]Y,RS7ER,RRll4tv!RR]4tw]2PR]YRS7RRl4tx]2PR]YRS7RRl4tz]2PRRR&7]!R@4]!R@4]!R@4]!R4]!R4]!R43RRll4t{]2PR] RR7RRl4t|0ER-mt}0ER.mt~!RR]4t!RR]4tRRlt0ER.mt~!RR]4t]2PRRR&7RRl4t]2PR] RR7]!R4]!R43RRll4t]2PRRR&7RRl4t]!]]#!RR73,t]!]]#!RR73,t!RR]4t!RR]4t!RR]4tRt]2EPRO]YRS7RRl4t]2PR]YRS7RRl4t0ER/mt]2PR]YRS7RRl4t]2PR]%]Y,RS7ER0RRll4t]2PR] R+7RRl4t]2PR] R+7RRl4t]2PR] R+7]!R@4]!R@4]!R4]!R4]!R4]!R4]!R4]!R4]!R@43 RRll4t]2PR] R+7RRl4t^RIHtRtRRltRRlt]2PR] R+7]!R@4]!R@4]!R@4]!R@43RRll4t!RR]4t]2EPR]YRS7]!R@43RRll4t^RIH3t30ER-mt]2EPR]YRS7]3!R@4]!R@43RERll4t]2PER] ERR7ERERl4t]2PER] ERR7]!R43ERERll4t]2PER4ER ER l4t]2PER 4ER 4t^ER IHtH"t"^ERIH%t%Ht^RI(t(!ERER]4t!ERER]4t]2PER]]Y,RS7]!R@43ERERll4t]2PR]YRS7ERERl4t^ERIHtHt^ERIHtHt^RItERERltERERlt]2PER]YRS7ERERl4t^RIHt^ERIHtHt]2EPe]4ER ER!l4tER"ER#lt]2EPkER$4ER%4tR# ]dRtELOi;i(1)FastAPIRequestForm UploadFileFileBody HTTPException) HTMLResponseRedirectResponse JSONResponse) StaticFiles)Jinja2Templates)SessionMiddleware) CryptContext) BaseModelN)Optional)Query)datetime timedelta)rDictAny Annotated)r )rFieldStringConstraints)rList)r )r)urlparse TheL4FPRO)titlez db.sqlite3APP_ENVdevAPP_SECRET_KEYlaxTthelfpro_session) secret_key same_site https_onlymax_agesession_cookiebcryptauto)schemes deprecatedc(V^8dQhR\RR/#)requestreturnNr)formats"(C:\Users\mario\Desktop\furbo\app\main.py __annotate__r40s55G55cVPP4\P!^ 4VPR&\P!^ 4VPR&\ \ P !44VPR&R#) sidcsrf created_atN)sessionclearsecrets token_urlsafeinttimer/s&r3rotate_sessionrB0s] OO$2226GOOE%33B7GOOF$' $4GOOL!r5z/staticz app/static) directorystatic)namez app/templatesc>V^8dQhR\R\R,/#)r.r/tokenNrstr)r2s"r3r4r49s"LL'L#*Lr5cVPPR4pV'dBV'd:\P!\ V4\ T;'gR44'g\ RRR7hR#)r9uCSRF token inválido status_codedetailN)r;gethmaccompare_digestrIr )r/rGsesss&& r3 require_csrfrT9sQ ??  v &D uD$7$7D 3u{{PRCS$T$T4JKK%Ur5z /contabilidad)response_classc$V^8dQhR\/#r.r/r1)r2s"r3r4r4@s___r5cj"\V4\V4p\PRRVRV/4#5i)zcontabilidad.htmlr/user) require_admin current_user templatesTemplateResponser/rYs& r3 contabilidadr_?s6'  D  % %&9IwPVX\;] ^^s13c$V^8dQhR\/#rWr1)r2s"r3r4r4Hs%%W%r5cVP\9d)VPPR4p\ W4R#R#) X-CSRF-TokenN)methodUNSAFE_METHODSheadersrPrTr/rGs& r3_enforce_csrf_if_unsafergHs/~~'##N3W$(r5c$V^8dQhR\/#rWr1)r2s"r3r4r4Ms7r5cN\V4pV'g\RRR7h\V4\V\P 4'd VR,M\ VPRR44;'gRp\ V4P4R8wd\RRR7hV#)No autenticadorMrolerKadminrLzSolo administradores r[r rg isinstancesqlite3RowrIrPlowerr/merls& r3rZrZMs g B 4DEEG$$R55BvJ3rvvfb?Q;R Y YWYD 4yG#4JKK Ir5c$V^8dQhR\/#rWr1)r2s"r3r4r4Wsgr5cN\V4pV'g\RRR7h\V4\V\P 4'd VR,M\ VPRR44;'gRp\ V4P4R9d\RRR7hV#)rjrkrMrlrKrLSolo docentes o admindocentermrnrss& r3require_docente_or_adminrzWs g B 4DEEG$$R55BvJ3rvvfb?Q;R Y YWYD 4y 444KLL Ir5c~\P!\RRR7p\PVnVP R4VP R4VP R4VP R4VP R4VP R4VP R 4V# \ dT#i;i) NF)isolation_levelcheck_same_threadzPRAGMA foreign_keys = ON;zPRAGMA journal_mode = WAL;zPRAGMA synchronous = NORMAL;zPRAGMA busy_timeout = 5000;zPRAGMA cache_size = -20000;zPRAGMA temp_store = MEMORY;zPRAGMA mmap_size = 268435456;)rpconnectDB_PATHrq row_factoryexecute Exceptionconns r3get_connras ??7DE RD{{DLL,-LL-.LL/0LL./LL./LL./  45 K   K sB-- B<;B<c\4#N)rr5r3_connrps :r5cVPRV R24P4Uu0uF q"^,kK up#uupi \d\4u#i;i)zPRAGMA table_info())rfetchallrset)rtablers&& r3_table_columnsrssW"ll-?wa+HIRRTUT!TUUU u s%A;AAAAcv\4;_uu_4pVP4pVPR4VPR4VPR4P4Uu0uF q"^,kK ppRV9dVPR4RV9dVPR4RV9dVPR4VPR 4VPR 4VPR 4VPR 4VPR 4VPR4VPR4VPR4VPR4P4Uu0uF q"^,kK ppRV9d#VPR4VPR4RV9dVPR4RV9dVPR4RV9dVPR4RV9dVPR4RV9dVPR4RV9dVPR4R V9dVPR!4R"V9dVPR#4R$V9dVPR%4R&V9dVPR'4R(V9dVPR)4VPR*4VPR+4VPR,4VPR-4VPR.4VPR/4VPR04VPR14VPR24VPR34VPR44VPR54VPR64VPR74VPR84VPR94VPR:4VPR;4VPR<4VPR=4VP 4R>R>R>4R>#uupiuupi +'giR>#;i)?zPRAGMA foreign_keys=ONa CREATE TABLE IF NOT EXISTS users ( id INTEGER PRIMARY KEY AUTOINCREMENT, email TEXT NOT NULL UNIQUE, name TEXT NOT NULL, first_name TEXT, last_name TEXT, phone TEXT, password_hash TEXT NOT NULL, role TEXT NOT NULL DEFAULT 'alumno', created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%S','now','localtime')) ) zPRAGMA table_info(users) first_namez,ALTER TABLE users ADD COLUMN first_name TEXT last_namez+ALTER TABLE users ADD COLUMN last_name TEXTphonez'ALTER TABLE users ADD COLUMN phone TEXTa1 CREATE TABLE IF NOT EXISTS user_profile ( user_id INTEGER PRIMARY KEY, phone TEXT, avatar TEXT, city TEXT, dni TEXT, birth_date TEXT, FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE ) a CREATE TABLE IF NOT EXISTS user_sports ( user_id INTEGER PRIMARY KEY, team TEXT, category TEXT, position TEXT, dominant_foot TEXT, strengths TEXT, weaknesses TEXT, injury_history TEXT, training_type TEXT, FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE ) a CREATE TABLE IF NOT EXISTS user_health ( user_id INTEGER PRIMARY KEY, physical_work INTEGER, physical_work_details TEXT, smoking INTEGER, alcohol INTEGER, recovery TEXT, chest_pain INTEGER, discomfort INTEGER, FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE ) ap CREATE TABLE IF NOT EXISTS user_consent ( user_id INTEGER PRIMARY KEY, whatsapp_content INTEGER, video_permission INTEGER, privacy_acceptance INTEGER, data_confirmation INTEGER, agreement INTEGER, FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE ) a0 CREATE TABLE IF NOT EXISTS user_guardians ( user_id INTEGER PRIMARY KEY, occupation TEXT, study_place TEXT, parent_name TEXT, parent_email TEXT, FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE ) a9 CREATE TABLE IF NOT EXISTS user_marketing ( user_id INTEGER PRIMARY KEY, found_us TEXT, enjoyment TEXT, nerves_confidence TEXT, additional_comments TEXT, FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE ) z CREATE TABLE IF NOT EXISTS user_finance ( user_id INTEGER PRIMARY KEY, matricula_eur REAL NOT NULL DEFAULT 0, FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE ) a CREATE TABLE IF NOT EXISTS reservations ( id INTEGER PRIMARY KEY AUTOINCREMENT, created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%S','now','localtime')), date TEXT NOT NULL, time TEXT, duration_minutes INTEGER, price_cents INTEGER NOT NULL DEFAULT 0, name TEXT, email TEXT, phone TEXT, notes TEXT, user_id INTEGER, status TEXT NOT NULL DEFAULT 'confirmada', docente_id INTEGER NOT NULL, paid INTEGER NOT NULL DEFAULT 0, FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE SET NULL, FOREIGN KEY(docente_id) REFERENCES users(id) ON DELETE CASCADE ) zPRAGMA table_info(reservations)r:z3ALTER TABLE reservations ADD COLUMN created_at TEXTzmUPDATE reservations SET created_at = strftime('%Y-%m-%dT%H:%M:%S','now','localtime') WHERE created_at IS NULLr@z-ALTER TABLE reservations ADD COLUMN time TEXTduration_minutesz> B<<4\]] G $F 4LMM 2d8}F4L))4Z[[ D  << <<[^e]o p <<Lwj Y <<Dwj Q <<87* E ;;=  X  88r>ahh"n#cB B c :: ==?  s8B%F!'F)A-E.F!'AF!.F  F F F!c$V^8dQhR\/#)r.rr)r2s"r3r4r4sSr5c\4;_uu_4pVPRV34pVP4uuRRR4# +'giR#;i)a" SELECT u.id,u.name,u.email,u.password_hash,u.created_at,u.role,u.first_name,u.last_name, p.phone,p.avatar,p.city,p.dni,p.birth_date, s.team,s.category,s.position,s.dominant_foot,s.strengths,s.weaknesses,s.injury_history,s.training_type, h.physical_work,h.physical_work_details,h.smoking,h.alcohol,h.recovery,h.chest_pain,h.discomfort, c.whatsapp_content,c.video_permission,c.privacy_acceptance,c.data_confirmation,c.agreement, g.occupation,g.study_place,g.parent_name,g.parent_email, m.found_us,m.enjoyment,m.nerves_confidence,m.additional_comments, COALESCE(f.matricula_eur,0.0) AS matricula_eur, CAST(ROUND(COALESCE(f.matricula_eur,0.0)*100) AS INTEGER) AS matricula_cents FROM users u LEFT JOIN user_profile p ON p.user_id=u.id LEFT JOIN user_sports s ON s.user_id=u.id LEFT JOIN user_health h ON h.user_id=u.id LEFT JOIN user_consent c ON c.user_id=u.id LEFT JOIN user_guardians g ON g.user_id=u.id LEFT JOIN user_marketing m ON m.user_id=u.id LEFT JOIN user_finance f ON f.user_id=u.id WHERE LOWER(u.email)=LOWER(?) Nrrr)rrcurs& r3get_user_by_emailrs< Dll &X'(||~+  #A A c$V^8dQhR\/#rr)r2s"r3r4r4sCr5c\4;_uu_4pVPRV34pVP4uuRRR4# +'giR#;i)a SELECT u.id,u.name,u.email,u.password_hash,u.created_at,u.role,u.first_name,u.last_name, p.phone,p.avatar,p.city,p.dni,p.birth_date, s.team,s.category,s.position,s.dominant_foot,s.strengths,s.weaknesses,s.injury_history,s.training_type, h.physical_work,h.physical_work_details,h.smoking,h.alcohol,h.recovery,h.chest_pain,h.discomfort, c.whatsapp_content,c.video_permission,c.privacy_acceptance,c.data_confirmation,c.agreement, g.occupation,g.study_place,g.parent_name,g.parent_email, m.found_us,m.enjoyment,m.nerves_confidence,m.additional_comments, COALESCE(f.matricula_eur,0.0) AS matricula_eur, CAST(ROUND(COALESCE(f.matricula_eur,0.0)*100) AS INTEGER) AS matricula_cents FROM users u LEFT JOIN user_profile p ON p.user_id=u.id LEFT JOIN user_sports s ON s.user_id=u.id LEFT JOIN user_health h ON h.user_id=u.id LEFT JOIN user_consent c ON c.user_id=u.id LEFT JOIN user_guardians g ON g.user_id=u.id LEFT JOIN user_marketing m ON m.user_id=u.id LEFT JOIN user_finance f ON f.user_id=u.id WHERE u.id=? Nrrrrs& r3rrs< Dll &Z'(||~+ rc |V^8dQhR\R\R\R\R\R,R\R,/#)r.rErpasswordrlrNrr)r2s"r3r4r4s@c#C$J:=*r5c \PV4p\4;_uu_4p\VR4p\P P 4P4p RV9dRV9dVPRWWiW4V34p MVPRWWiV34p V Pp \W{4VP4RRR4R# +'giR#;i)usersrrznINSERT INTO users (name, email, password_hash, created_at, role, first_name, last_name) VALUES (?,?,?,?,?,?,?)zSINSERT INTO users (name, email, password_hash, created_at, role) VALUES (?,?,?,?,?)N) pwd_contexthashrrdtrutcnow isoformatr lastrowidrr) rErrrlrr password_hashrcolsr:ruids &&&&&& r3 create_userrs$$X.M DdG,[['')335 4 K4$7,,)m9UC ,,em>Cmm + ! s BC  C z/api/notifications/unreadc$V^8dQhR\/#rWr1)r2s"r3r4r4s&&G&r5c"\V4pV'g\RRR7h\\VR,44pRpVUu.uF qC!V4NK up#uupi5i)rjrkrMrcXVP4Uu/uF qW,bK up#uupir)keysrks& r3to_dict)api_notifications_unread..to_dicts#QVVX6XqtGX666s')r[r !get_unread_notifications_for_userr?)r/rtrowsrrs& r3api_notifications_unreadrsQ g B 4DEE ,SD] ;D6 $ %1GAJ %% %sAAAAz./api/notifications/{notification_id}/mark-readc0V^8dQhR\R\/#)r.r/notification_idrr?)r2s"r3r4r4swr5c h"\V4pV'g\RRR7hVPPR4p\ W4\ 4;_uu_4pVP RV\VR,434VP4RRR4RR/# +'giRR/#;i5i) rjrkrMrbzx UPDATE notifications SET is_read = 1 WHERE id = ? AND recipient_id = ? rNokT) r[r rerPrTrrr?r)r/rrtrGrs&& r3api_notifications_mark_readrs g B 4DEE OO   /E D   c"T(m ,     $<  $<sAB25B B2 B/ ' B2z/api/reservations/{res_id}c0V^8dQhR\R\/#r.r/res_idr)r2s"r3r4r4s!&!&w!&!&r5c@"\V4pV'g\RRR7h\4;_uu_4pVPRV34P 4pRRR4X'g\RRR7h\ V4p\ VR7# +'giL<;i5i)rjrkrMa SELECT id, created_at, date, time, duration_minutes, price_cents, name, email, phone, notes, user_id, status, docente_id, paid FROM reservations WHERE id = ? Nrz No encontrada)content)r[r rrr_reservation_row_to_dictr )r/rrtrrdatas&& r3api_reservation_getrs g B 4DEE Dll &I) * (*+  0 ODD #C (D  %%9 s"3B"B B'$B B Bz#/api/reservations/{res_id}/students)response_modelc0V^8dQhR\R\/#rr)r2s"r3r4r4:sTTGTSTr5c "\V4pV'g\RRR7h\4;_uu_4p\PVnVP RV34P4pV'glVP RV34P4pV'dCVR,'d4VP RVR,34P4pV'dV.pRRR4XUu.uF)pR\VR,4R VR ,R VR ,/NK+ ppR VR \V4R V/# +'giLV;iuupi5i)rjrkrMz SELECT u.id, u.name, u.email FROM reservation_students rs JOIN users u ON u.id = rs.user_id WHERE rs.reservation_id = ? ORDER BY COALESCE(u.name, u.email) z-SELECT user_id FROM reservations WHERE id = ?r.SELECT id, name, email FROM users WHERE id = ?NrrErreservation_idcountstudents) r[r rrprqrrrrr?len)r/rrtrrrurs&& r3api_reservation_studentsr9s g B 4DEE D";;|| Y  !  LviXaacAQy\\LL!QTUV_T`Sbclln3D W[[VZQRs1T7|VQvY7LVZH[ fgs8}j( SS! \s;3EA'D-D-,/D-D- E+/EE- D= 8 Ez /api/reservations/list/paginateduP�gina (1-based))ge descriptionuTama�o de p�gina)rler c V^8dQhR\R\R\\,R\\,R\\,/#)r.pagesizerrrr?rrI)r2s"r3r4r4QsT@W@W @W @Wc]@W @W SM @Wr5c V^, V,pR.p.pVe#VPR4VPV4Ve#VPR4VPV4Ve#VPR4VPV4RRPV4,p\4;_uu_4p V PRV 2\ V44P 4p \ V R ,;'g^4p V PR V R 2\ V4W3,4P4p RRR4X U u.uFp \V 4NK pp X 'd'\^\P!W, 44M^pR VR RVRVRV RV//# +'giLh;iuup i \dh\d\RRR7hi;i)z1=1N user_id = ?docente_id = ?z status = ?zWHERE  AND z'SELECT COUNT(*) AS c FROM reservations ra SELECT id, created_at, date, time, duration_minutes, price_cents, name, email, phone, notes, user_id, status, docente_id FROM reservations zn ORDER BY datetime(created_at) DESC, id DESC LIMIT ? OFFSET ? itemsmetar r totalpagesizError interno listando reservasrM)appendjoinrrtuplerr?rrmaxmathceilr r)r r rrroffset where_clausesparams where_sqlr total_rowrrrrrs&&&&& r3reservations_paginatedr#Ps9W(d"      / MM' "  !  !1 2 MM* %     . MM& !w||M:: WW 9)Ef hj  #++!,E<<  !(f .+,hj-  :7;;d)!,d;38Atyy./a U    ?W:<  W4UVVWs7B1F)3A>F1 F)=F$?F) F!  F))G >G c\4;_uu_4pVPR\PP 4P 434VP 4RRR4R# +'giR#;i)zADELETE FROM "formulario-registro" WHERE used=0 AND expires_at < ?N)rr_dtrrrrrs r3purge_expired_temp_regsr&sK D X[^[g[g[n[n[p[z[z[|Z~  s AA++ A< c0V^8dQhR\R\/#)r.lengthr0r?rI)r2s"r3r4r4s   C r5ca\PoRPV3Rl\V444p\ 4;_uu_4pVP RV\ PP4P434P4pV'g VuuRRR4#RRR4K +'giK;i)TrKc3P<"TFp\P!S4xK R#5ir)_secretschoice).0_digitss& r3 &generate_unique_pin..sE}!hoof--}s#&zQSELECT 1 FROM "formulario-registro" WHERE pin = ? AND used = 0 AND expires_at > ?N) stringr0rrangerrr%rrrr)r(pinrrr0s& @r3generate_unique_pinr6s ]]F ggEuV}EE WW,,ccll))+5578hj  W  WWWs AB55 C c$V^8dQhR\/#rWr1)r2s"r3r4r4s(('(r5ctVPPR4pV'gR#\\V44#)rN)r;rPrr?)r/rs& r3r[r[s+oo!!),G  #g, ''r5c\4;_uu_4pVPR4pVP4uuRRR4# +'giR#;i)zCSELECT id, name, email FROM users WHERE role='alumno' ORDER BY nameNrrr)rrs r3 get_studentsr;s/ Dll`a||~ s !? A c$V^8dQhR\/#rr)r2s"r3r4r4s   r5c\4;_uu_4pVPRV34pVP4uuRRR4# +'giR#;i)a SELECT n.id, n.created_at, n.title, n.body, s.name AS sender_name, n.sender_id, n.recipient_id, n.reservation_id FROM notifications n LEFT JOIN users s ON s.id = n.sender_id WHERE n.recipient_id = ? AND COALESCE(n.deleted_by_recipient, 0) = 0 ORDER BY n.created_at DESC Nr:rs& r3get_notifications_for_userr>s< Dll  Z ||~ rc$V^8dQhR\/#)r. sender_idr)r2s"r3r4r4s  c r5c\4;_uu_4pVPRV34pVP4uuRRR4# +'giR#;i)a SELECT n.id, n.created_at, n.title, n.body, r.name AS recipient_name, n.sender_id, n.recipient_id, n.reservation_id FROM notifications n LEFT JOIN users r ON r.id = n.recipient_id WHERE n.sender_id = ? AND COALESCE(n.deleted_by_sender, 0) = 0 ORDER BY n.created_at DESC Nr:)r@rrs& r3get_notifications_sent_by_userrBs< Dll  \ ||~ rc0V^8dQhR\R\/#)r.r@ recipient_idr)r2s"r3r4r4scr5c\4;_uu_4pVPRW34pVP4uuRRR4# +'giR#;i)a SELECT n.id, n.created_at, n.title, n.body, r.name AS recipient_name, n.sender_id, n.recipient_id, n.reservation_id FROM notifications n LEFT JOIN users r ON r.id = n.recipient_id WHERE n.sender_id = ? AND n.recipient_id = ? AND COALESCE(n.deleted_by_sender, 0) = 0 AND COALESCE(n.deleted_by_recipient, 0) = 0 ORDER BY n.created_at DESC Nr:)r@rDrrs&& r3&get_notifications_sent_by_user_to_userrFs= Dll   & (||~ rz/notificaciones/eliminardelete_notificationc ~V^8dQhR\R\R\R,R\R,R\R,/#)r.r/rrNtarget_recipient_idr9r)r2s"r3r4r4sM'D'D 'D'DDj'Dt 'D * 'Dr5c"\V4pV'g\RRR7#\W4\4;_uu_4pVP RV34P 4pV'g\ RRR7h\VR,4pVR,e\VR,4MR p \VR ,4p W8Xd%VP R V34VP4MV eSW8XdMVe%\V4V 8XdVP R V34MVP R V34VP4MSVR,R9d9Ve5\V4V 8Xd%VP R V34VP4M \ RRR7hR R R 4V'd;\V4p V PR8XdV PR8Xd\VRR7#\RRR7# +'giL_;i5i)rrrzBSELECT id, sender_id, recipient_id FROM notifications WHERE id = ?ruNotificaci�n no encontrada.rMrr@NrDz>UPDATE notifications SET deleted_by_recipient = 1 WHERE id = ?zUUPDATE notifications SET deleted_by_sender = 1, deleted_by_recipient = 1 WHERE id = ?z;UPDATE notifications SET deleted_by_sender = 1 WHERE id = ?rlrLu'No puedes eliminar esta notificaci�n.rK/notificacionesrx) r[r rTrrrr r?rrrr) r/rrrIr9rtrrme_idr@rDparseds &&&&& r3rGrGs g B H#>> Dll P    (* C8WX XBtH -0-=-ICK()t 3~./  LLY\k[m n KKM  "u'9".37J3K|3[ txGwIJ Z]l\no KKM Z/ /4G4SX[\oXpuAYA LLY\k[m n KKMC8ab b/ 0(# ==B 6==B#6#cB B  1s CC9 s%>G7E G$ G7AG7$ G4 /G7/c$V^8dQhR\/#rWr1)r2s"r3r4r4sVVVr5cT"\V4p\PRRVRV/4#5i)z index.htmlr/rYr[r\r]r/rts& r3homerS, g B  % %lYQS4T UU&(z/aboutc$V^8dQhR\/#rWr1)r2s"r3r4r4 sVVVr5cT"\V4p\PRRVRV/4#5i)z about.htmlr/rYrQrRs& r3aboutrX rTrUz /ticketingc$V^8dQhR\/#rWr1)r2s"r3r4r4smmWmr5c P"\PRRVR\V4/4#5i)zticketing.htmlr/rY)r\r]r[rAs&r3 ticketingr[s)  % %&6GVUabiUj8k lls$&rlogin)rErUc$V^8dQhR\/#rWr1)r2s"r3r4r4sYYWYr5c>"\PRRVRR/4#5i) login.htmlr/errorN)r\r]rAs&r3 login_getras"  % %lYRV4W XXs login_postc<V^8dQhR\R\R\/#)r.r/rrrH)r2s"r3r4r4s& S Sg Sc S Sr5cR"VP4P4p\V4pV'd#\P W$R,4'g\ P RRVRR/4#\V4\VR,4VPR&VR,VPR&VR,R8XgVR 8Xd\VPR4R R 7#VR,R 8Xd\VPR 4R R 7#\VPR 4R R 7#5i)rr_r/r`uCredenciales inv�lidasrrrlrmadmin@admin.esrrry dashboard) striprrrrverifyr\r]rBr?r;r url_for)r/rr email_normrYs&&& r3rbrbs$$&J Z (D {))(4IJJ)),GWVp8qrr7!$T$ZGOOI"6lGOOF F|w*0@"@GOOG$<#NN f "GOOI$>CPPGOOK$@cRRsD%D'z/docenteryc$V^8dQhR\/#rWr1)r2s"r3r4r4(sWr5c "\V4pV'g\VPR4RR7#.pVR,R9d \4p\ P RRTRTRT/4# \d.pL+i;i5i) r\rrrlz docente.htmlr/rYrrx)r[r rir;rr\r])r/rtrs& r3docente_dashboardrm's g B GOOG$<#NNH f:- -#~H  % % w B    s(2A<A) A<) A96A<8A99A<z /valoraciones valoracionesc$V^8dQhR\/#rWr1)r2s"r3r4r4<s]]W]r5cP"\V4pV'g\VPR4RR7#RVP49d!\ VR,4P 4MRpVR 9d\VPR4RR7#\ PRRVRV/4#5i) r\rrrlrKrfzvaloraciones.htmlr/rYrx)r[r rirrIrrr\r]rss& r3valoraciones_pagerq;s g B GOOG$<#NN&, &93r&z? "rD ''GOOK$@cRR  % %&9IwPVXZ;[ \\sB$B&z/api/users/{user_id}api_user_detail)rUrEc0V^8dQhR\R\/#)r.rr/)r?r)r2s"r3r4r4Fs3r5c^"\V4pV'g\RRR7#VR,R 9d\RRR7h\4;_uu_4pVP RV34P 4pRRR4X'g\R R R7h\ V4# +'giL0;i5i) rrrrlrLrwrMa SELECT u.id,u.name,u.email,u.created_at,u.role, p.phone,p.avatar,p.dni,p.birth_date,p.city, s.dominant_foot,s.team,s.category,s.position,s.injury_history,s.strengths,s.weaknesses,s.training_type, h.physical_work,h.physical_work_details,h.smoking,h.alcohol,h.recovery,h.chest_pain,h.discomfort, c.whatsapp_content,c.video_permission,c.privacy_acceptance,c.data_confirmation, COALESCE(f.matricula_eur,0.0) AS matricula_eur, CAST(ROUND(COALESCE(f.matricula_eur,0.0)*100) AS INTEGER) AS matricula_cents, c.agreement, g.occupation,g.study_place,g.parent_name,g.parent_email, m.found_us,m.enjoyment,m.nerves_confidence,m.additional_comments FROM users u LEFT JOIN user_profile p ON p.user_id=u.id LEFT JOIN user_sports s ON s.user_id=u.id LEFT JOIN user_health h ON h.user_id=u.id LEFT JOIN user_consent c ON c.user_id=u.id LEFT JOIN user_guardians g ON g.user_id=u.id LEFT JOIN user_marketing m ON m.user_id=u.id LEFT JOIN user_finance f ON f.user_id=u.id WHERE u.id = ? NrUsuario no encontradorx)r[r r rrrdict)rr/rtrrs&& r3rrrrEs g B H#>> &z--4KLL Dll *Z+*"+  . 4KLL 93 s$AB-"B2B-B- B* %B-z /registerregisterc$V^8dQhR\/#rWr1)r2s"r3r4r4hsnnnr5c |"\V4pT;'g RRRRRR/p\PRRVRRRV/4#5i) rErKrr register.htmlr/r`NrYrQ)r/rtctx_users& r3 register_getr|gsL g B;;fb'2w;H  % %o 7GUY[ack7l mms:< register_postcHV^8dQhR\R\R\R\/#)r.r/rErrrH)r2s"r3r4r4ns/SSSSScfSr5c"VP4P4p\V4'd1\P RRVRRRRVP4RVRR//4#\ V4^8d1\P RRVRR RRVP4RVRR//4#\ VP4WCR R 7\V4p\VR ,4VPR &VR,VPR&VR,R8XgVR8Xd\VPR4RR7#\VPR4RR7#5i)rzr/r`zEse email ya existerYrErrrKu(La contrase�a debe tener 6+ caracteresalumno)rlrrrlrmrerrrf) rgrrrr\r]rrr?r;r ri)r/rErrrjrYs&&&& r3r}r}ms\$$&J$$))  *?&RVR\R\R^`gisu|AJB C   8}q))  *TV\_egkgqgqgsu|IKRTV_W X   jB Z (D!$T$ZGOOI"6lGOOF F|w*0@"@GOOG$<#NNGOOK$@cRRsE E z/academy-registeracademy_register_getc$V^8dQhR\/#rWr1)r2s"r3r4r4sr5cT"\V4p\PRRVRV/4#5i)zacademy-register.htmlr/rYrQrRs& r3rrs1 g B  % % GVR( rUuploadsacademyacademy_register_postc$V^8dQhR\/#rWr1)r2s"r3r4r4sX<X<XR<4R?V!R@4RAV!RA4RBV!RB4RCV!RD4REV!RFRGRE4/pRHV!RI4RJV!RK4RLV!RL4RMV!RM4RNV!RN4ROV!RP4RQV!RQ4/pRRV!RS4RTV!RU4RVV!RW4RXV!RY4RZV!RZ4/pR[V!R[4R\V!R]R\4R^V!R_R^4R`V!RaR`4/pRbV!RcRb4RdV!Rd4ReV!RfRe4RgV!RhRg4/p\=4;_uu_4p\?VV4\@;QJd*RiVPC44F 'gK R'M RjM!RiVPC444'd_RkPEVP4Uu.uF pV RlV Rm2NK up4pVPGRnV Ro2.VPC4OVN54\@;QJd*RpVPC44F 'gK R'M RjM!RpVPC444'd_RkPEVP4Uu.uF pV RlV Rm2NK up4pVPGRqV Ro2.VPC4OVN54\@;QJd*RrVPC44F 'gK R'M RjM!RrVPC444'd_RkPEVP4Uu.uF pV RlV Rm2NK up4pVPGRsV Ro2.VPC4OVN54\@;QJd*RtVPC44F 'gK R'M RjM!RtVPC444'd_RkPEVP4Uu.uF pV RlV Rm2NK up4pVPGRuV Ro2.VPC4OVN54\@;QJd*RvVPC44F 'gK R'M RjM!RvVPC444'd_RkPEVP4Uu.uF pV RlV Rm2NK up4pVPGRwV Ro2.VPC4OVN54\@;QJd*RxVPC44F 'gK R'M RjM!RxVPC444'd_RkPEVP4Uu.uF pV RlV Rm2NK up4pVPGRyV Ro2.VPC4OVN54VPI4RRR4\R~4\Rz4\R~4\KR{R'R|R}/4#E LEL \"d.p \R!T 24^RIp T P'4Rp ? EL7Rp ? ii;i +'giEL;i \"d.p \R/T 24^RIp T P'4Rp ? ELRp ? ii;iuupiuupiuupiuupiuupiuupi +'giL;i5i)=z,DEBUG: academy_register_post function calledNzDEBUG: Form keys: zDEBUG: Form has playerPhoto: playerPhotorrKrEr firstNamelastNamez DEBUG: email=z, name=z , first_name=z , last_name=rzEl email es obligatorio.rMzIndica tu nombre.zIndica tus apellidos.u(Indica tu nombre (mínimo 2 caracteres).u0La contraseña debe tener al menos 6 caracteres.u3Ya existe un usuario con ese email. Inicia sesión.zDEBUG: player_photo type: filenamereadz"DEBUG: is_upload (hasattr check): zDEBUG: player_photo.filename: zDEBUG: content length: .jpgz.picks-A((1+C,, r5rwhatsappdni birth_date birthDatecityavatarteam currentTeamclubcategorypositioncurrentPositionpreferredPosition dominant_foot dominantFoot strengths weaknesses training_type trainingTypeinjury_historyinjuries injuryHistory physical_work physicalWorkphysical_work_detailsphysicalWorkDetailssmokingalcoholrecovery chest_pain chestPain discomfortwhatsapp_contentwhatsappContentvideo_permissionvideoPermissionprivacy_acceptanceprivacyAcceptancedata_confirmationdataConfirmation agreement occupation study_place studyPlace parent_name parentName parent_email parentEmailfound_usfoundUs enjoymentnerves_confidencenervesConfidenceadditional_commentsadditionalCommentsc3("TFqRJxK R#5irrr.vs& r3r1(academy_register_post..<&;}&;F, z =COALESCE(?, rzUPDATE user_profile SET z WHERE user_id=?c3("TFqRJxK R#5irrrs& r3r1r;&:}&:rzUPDATE user_sports SET c3("TFqRJxK R#5irrrs& r3r1rrrzUPDATE user_health SET c3("TFqRJxK R#5irrrs& r3r1rrrzUPDATE user_consent SET c3("TFqRJxK R#5irrrs& r3r1r>&=}&=rzUPDATE user_guardians SET c3("TFqRJxK R#5irrrs& r3r1rrrzUPDATE user_marketing SET zHDEBUG: About to return JSON response: {'ok': True, 'redirect': '/login'}rredirectrzP================================================================================r)&printformlistrrPrgrrr rrtypehasattrrrospathsplitextr traceback print_excrr?BASE_DIRmkdiropenwriterrorrIrranyvaluesrrrr )!r/rrrErrrexisting photo_content photo_ext player_photo is_uploaderrYr avatar_path uploads_dirr file_pathfrrr profile_vals sports_vals health_vals consent_valsguardians_valsmarketing_valsrsetsrs!& @r3rrs  &M 89 &M D tDIIK01 23 )-4*?)@ AB XXg  $ $" + + - 3 3 5E XXf  $ $" + + -D$**H((;'--2446J*%++224I M%v]:,lS\R] ^_ 4NOO Z1,4GHH I*4KLL 3t9q=4^__ s8}q(4fgg 'H4ijjMI88M*L &tL'9&: ;< j1SSglF6SI .yk :; .|/D/D.EFG\*** ""."3"3"55M +-C ,>UV+WX YGG,,\-B-BCAFLLNXXRX TV eHi U #D$t*oGK ""X- 9K   dT  :wi {3H#h.I ,YK8 9i&&! &' 7 {C D,XJ7K ( 6 7 D 1 a $ $  & &!fDG   gz* tE{d; 5V +>>mX!> L ]FF3D$D*,?Ln-T+&d<(n-$z?n&;&;&=>333>n&;&;&=> > >99~?R?R?TU?T!=15?TUVD LL5dV;KLNqP^PePePgNqipNq r 3>n&;&;&=>333>n&;&;&=> > >99~?R?R?TU?T!=15?TUVD LL5dV;KLNqP^PePePgNqipNq r ) * &M TU &M tZ: ;;i B6  " 1!5 6     ! ! "&'&&  " 9!= >     ! ! "BTSSTVV% s5liBl(l+l(l/Al4$l$l>$l#B>l"l5i i  ,i 6Ai ;i A lAj/j)j*4l#Al'Dl:7k54(k5k5:k :k5k5((k5k5.k ?:k5:k5(k5k5"k! 3:k5.k5(k59k5k& ':k5"k5(k5-k5 k+ :k5k58(k5!k5>k0 Ak59l i j"j:ljl j  j k'"k lklk55 l lz/info-usuariosc$V^8dQhR\/#rWr1)r2s"r3r4r4+sr5c"\V4pV'g\VPR4RR7#\P RRVRV/4#5i)r\rrzinfo-usuarios.htmlr/rY)r[r rir\r]rRs& r3 info_usuarior*sM g B GOOG$<#NN  % %&:7= sA A z/gestion-usuariosgestion_usuariosc$V^8dQhR\/#rWr1)r2s"r3r4r45s  G r5c "\V4pV'g\VPR4RR7#\V\P 4'd \ V4p\\V\ 4'dVPR4MVR,;'gR4P4pVR8wd\VPR4RR7#\4;_uu_4pVPR4pVP4Uu.uFp\ V4NK ppRRR4\PR R VR VR X/4#uupi +'giL1;i5i) r\rrrlrKrmrfaX SELECT u.id, u.name, u.email, u.role, u.created_at, LOWER(COALESCE(s.category, '')) AS category FROM users u LEFT JOIN user_sports s ON s.user_id = u.id ORDER BY u.created_at DESC, u.id DESC Nzgestion-usuarios.htmlr/rYr)r[r rirorprqrvrIrPrrrrrr\r])r/rtrlrrrrs& r3rr4s  g B GOOG$<#NN"gkk"" "X *R"6"6vBvJMM2 N T T VD wGOOK$@cRR Dll   #&,,.1.Qa.1   % % w B U  2 s7BEA E#$EEE$EE E Ez /dashboardrfc$V^8dQhR\/#rWr1)r2s"r3r4r4ZsWr5c "\V4pV'g\VPR4RR7#\V\P 4'd\ VR,4M\ VPR44p\V\P 4'd VR,MVPR4;'gRP4p\4;_uu_4pVPRW"V34P4p\ V'dVR,e VR,M^4pRRR4\PR R VR VR X/4# +'giL,;i5i) r\rrrrrKa SELECT COUNT(DISTINCT r.id) AS c FROM reservations r LEFT JOIN reservation_students rs ON rs.reservation_id = r.id WHERE rs.user_id = ? OR r.user_id = ? OR LOWER(COALESCE(r.email,'')) = LOWER(?) rNzdashboard.htmlr/rYreservation_count)r[r rirorprqr?rPrgrrrr\r]r/rtrLme_emailrrr s& r3rfrfYs g B GOOG$<#NN'GKK88C4Mc"&&,>OE)"gkk::7 w@U@USU\\^H Dll H %'(0xz  CCH4HCaP   % % w B !2   s%B>  % %lYQU4V WWs;=rKnotificacionesc>V^8dQhR\R\R,/#)r.r/rNr)r2s"r3r4r4s::':C$J:r5cV"\V4pV'g\RRR7#\VR,4pRpVeH\V4pV'd4VR,R9d&\ V4pV'd\VR,4p\ V4p.pVR,R9dAV'd\ \VR,4V4pM\\VR,44p.pVR,R9d \4pRpT;'g.U u.uF q!V 4NK p p .p /p .p V'd\4;_uu_4pVPRV34P4p RRR4T ;'g.Uu.uF q!V4NK p pT ;'g.Uu/uFp\VR,4V!V4bK p p\PRR TR TR V'd \V4MRR VR VRVRV RV RV RV / 4# \dRpELi;iuup i +'giL;iuupiuupi5i)rrrrNrlcVP4Uu/uF qW,bK up#uupi \d\T4u#i;ir)rrrvrs& r3 _row_to_dict$notificaciones.._row_to_dictsA %&VVX.XqtGX. .. 7N s-(--AAz SELECT id, user_id, date, time, duration_minutes, status, created_at, name, email, phone, notes, price_cents FROM reservations WHERE user_id = ? ORDER BY date ASC, time ASC znotificaciones.htmlr/rY view_user notificationssent_notificationsrnotifications_json appointmentsappointments_jsonappointments_maprx)r[r r?rrr>rFrBr;rrrr\r]rv)r/rrttarget_user_idrinboxsentrrnrrrrras&& r3rrs! g B H#>>D]NI 'lG r&z%99&w/I!$Yt_!5 &~ 6E D &z)) 9#bh-XD1#bh-@DH &z))> 5:KKRKAKa,q/KAL WW<<) !" $ %-HJ 8D7I7Ir7IK7I\!_7IKDPDVDVTVDVXDVaC$L,q/9DVX  % % w B Ii4 U $  "4 L !2  0  G G *B WLXs9H) G3H)AH)%AH)H)H"H):"H H)-H)2H H) H)"H$4H) H)3 HH)HH) H H)z /api/expensesc V^8dQhR\R\\,R\\,R\\,/#)r.r/ date_fromdate_torrrrIr?)r2s"r3r4r4s<<< <}<c]<c] <r5c"\V4RRlp.p.pV'd+V!V4VPR4VPV4V'd+V!V4VPR4VPV4Ve,VPR4VP\V44RpV'd VRRPV4,, pVR , p\ 4;_uu_4p\ P VnVPV\V44P4p .p V Fp T PR V R ,R V R ,R V R ,R V R ,RV R,RV R,RV R,R\V R,;'g^4RV R,RV R,RV R,/ 4K V uuRRR4# +'giR#;i5i)c$V^8dQhR\/#)r.sr)r2s"r3r4'api_expenses_list..__annotate__s__C_r5cv\P!VR4R# \d\RRT R2R7hi;i)%Y-%m-%druFecha inv�lida: z (YYYY-MM-DD)rMNrstrptimerr r(s&r3_ok_date#api_expenses_list.._ok_dates@ _   a , _C:LQC}8]^ ^ _8z jg.date >= ?z jg.date <= ?Nzjg.user_id = ?a SELECT jg.id, jg.created_at, jg.date, jg.user_id, jg.reservation_id, jg.amount_cents, jg.category, jg.concept, jg.notes, u.name AS user_name, u.email AS user_email FROM jugadores_gastos jg LEFT JOIN users u ON u.id = jg.user_id  WHERE rz ORDER BY jg.date ASC, jg.id ASCrr:dater user_name user_emailr amount_centsrconceptr) rZrr?rrrprqrrrr) r/r#r$rr/wherer sqlrroutrs &&&& r3api_expenses_listr;s'_ EFU\\.96==;S5<<7w9O %& c'l(C C   y7<<... --C D";;||Cv/88:A JJaga o& 1Y<Q{^a o !$4"5An$5$:$: ;AjM1Y<7  % s2AG A"G 5:G /B%G ,G  G  G  G cRa]tRtRto]!^R7tRtRtRtRt Rt V3Rlt Rt Vt R#) ExpenseInirNc<V^8dQh/S[;R&S[;R&S[S[,;R&S[S[,;R&S[S[,;R&S[S[,;R&S[S[,;R&#)r.r3r6rr7rrrrIr?r)r2 __classdict__s"r3r4ExpenseIn.__annotate__so I#sm"c]!  C=  c]! SM(r5r)__name__ __module__ __qualname____firstlineno__rr6rr7rrr__annotate_func____static_attributes____classdictcell__rAs@r3r=r=s. L"H!GE!G$(Nr5r=c0V^8dQhR\R\/#r.r/payload)rr=)r2s"r3r4r4!s##w##r5c"\V4\P!VPR4\P !4PR4p\4;_uu_4pTPRTTPP4TPe\TP4MRTP'd\TP4MR\TP;'g^4TP;'gRP4;'gRTP ;'gRP4;'gRTP";'gRP4;'gR34pTP$pRRR4RR R X/# \d\ RRR7hi;i +'giL2;i5i) r+ruFecha inválida (YYYY-MM-DD).rM%Y-%m-%d %H:%M:%Sz INSERT INTO jugadores_gastos (created_at, date, user_id, reservation_id, amount_cents, category, concept, notes) VALUES (?, ?, ?, ?, ?, ?, ?, ?) NrKrTr)rZrr-r3rr nowstrftimerrrgrr?rr6rr7rr)r/rMr:rrgids&& r3api_expenses_createrS si'U',, 3(()<=J Dll   LL   $+OO$?C T+2+A+A+AC&& 't $$)) *    # # * * , 4 4 __ " " ) ) + 3 3t ]] b ' ' ) 1 1T    mm  $c ""% U4STTU sd G !F6G &AF:-F:1F: F:"F:7F:F:$F:<F:G F77G : G G z/api/expenses/{gid}c0V^8dQhR\R\/#)r.r/rRr)r2s"r3r4r4:swSr5c"\V4\4;_uu_4pVPRV34RRR4RR/# +'giRR/#;i5i)z)DELETE FROM jugadores_gastos WHERE id = ?NrT)rZrr)r/rRrs&& r3api_expenses_deleterV9sG' D @3&I  $<  $<sAA A A Acreate_notificationcV^8dQhR\R\R\R\R\R,R\R,R\R,/#) r.r/rDrbodyrNrr9r)r2s"r3r4r4Bsc3D3D 3D3D 3D  3D Dj 3D $J 3D *3Dr5c "\V4pV'g\RRR7#VR,R9d\RRR7h\W4T;'gRP 4pT;'gRP 4pV'd V'g\RR R7h\ V4pR pTe\T4P 4R8wd\ T4p\4;_uu_4p T PR T34P4p T 'g\RRR7h\ T R,;'g^4T8wd\RRR7hR R R 4\4;_uu_4p T PR\PP4P4\ TR,4YY834T P4R R R 4T'd;\!T4p T P"R8XdT P$R8Xd\TRR7#\RRR7# \ d\RR R7hi;i \ d\RR R7hi;i +'giEL;i +'giL;i5i)rrrrlrLz3Solo docentes o admin pueden enviar notificaciones.rMrKru$T�tulo y mensaje son obligatorios.uDestinatario inv�lido.NuReserva inv�lida.z1SELECT id, user_id FROM reservations WHERE id = ?rReserva no encontrada.rz/La reserva no pertenece al alumno seleccionado.z INSERT INTO notifications (created_at, sender_id, recipient_id, title, body, is_read, reservation_id) VALUES (?, ?, ?, ?, ?, 0, ?) rrKrx)r[r r rTrgr?rrIrrrrrrrrrrr) r/rDrrYrrr9rtres_id_to_saverresrMs &&&&&&& r3rWrWAs g B H#>> &z--4ijj [[b   !E JJB   D 4Z[[P<( N!c.&9&?&?&AR&G O 0NWW,,C!hj #&&Q'<7#> Dll j "%0AQ0  K1  Ks.3B$A>A9-A>/ B9A>> B Bc0a]tRtRtoRtV3RltRtVtR#)CategoryUpdateiNc6<V^8dQh/S[S[,;R&#r.rrrI)r2rAs"r3r4CategoryUpdate.__annotate__sm"r5rrCrDrErFrrGrHrIrJs@r3rbrb"Hr5rbc,a]tRtRtoV3RltRtVtR#) RoleUpdateic&<V^8dQh/S[;R&#)r.rlr)r2rAs"r3r4RoleUpdate.__annotate__s Ir5rNrCrDrErFrGrHrIrJs@r3rkrkr5rkc0V^8dQhR\R\/#)r.rrlr))r2s"r3r4r4s3cr5c\4;_uu_4pVPRW34VP4RRR4R# +'giR#;i)&UPDATE users SET role = ? WHERE id = ?N)rrr)rrlrs&& r3 set_user_rolerss1 D =O  s $A A c0a]tRtRtoRtV3RltRtVtR#)rbiNc6<V^8dQh/S[S[,;R&#rdre)r2rAs"r3r4rfrgr5rrhrJs@r3rbrbrir5z/api/users/{user_id}/categoryapi_users_set_categoryc<V^8dQhR\R\R\/#r.rrMr/)r?rbr)r2s"r3r4r4s" = =# = =QX =r5c"\V4\V4pV'g\RRR7hVP;'gRP 4P 4pV'dV\ 9d\RRR7h\4;_uu_4pVPRV34TPRV'dTMRV34VP4RRR4R R R VR V/# +'giL;i5i) rrurMrKruCategoría no válidarz5UPDATE user_sports SET category = ? WHERE user_id = ?NrTrr) rZrr rrgrrALLOWED_CATEGORIESrrr)rrMr/rcatrs&&& r3rvrvs' G $F 4KLL    ! !r ( ( * 0 0 2C s,,4KLL D LwjY LVYs_celNmn   $ 7J << s*>C7&C7(*C7AC$C7$ C4 /C7z /api/users api_userschV^8dQhR\R\\,R\\,/#)r.r/rolesrl)rrrI)r2s"r3r4r4s... . C=. 3-.r5c"\V4pV'g\RRR7#.pV'dUVPR4Uu.uF8qUP4'gKVP4P 4NK: ppM'V'd VP4P 4.pRp.pV'd9RP R\ V4,4pRV R2pVPV4\4;_uu_4p V PRV R 2V4p V P4Uu.uFp\V4NK p pR R R 4V #uupiuupi +'giX #;i5i) rrr,rK?zWHERE lower(u.role) IN (ra SELECT u.id,u.name,u.email,u.created_at,u.role,u.first_name,u.last_name, p.phone,p.avatar, s.team,s.category,s.position,s.injury_history, p.dni,p.birth_date,p.city, s.dominant_foot,s.strengths,s.weaknesses,s.training_type, h.physical_work,h.physical_work_details,h.smoking,h.alcohol,h.recovery,h.chest_pain,h.discomfort, c.whatsapp_content,c.video_permission,c.privacy_acceptance,c.data_confirmation, COALESCE(f.matricula_eur,0.0) AS matricula_eur, CAST(ROUND(COALESCE(f.matricula_eur,0.0)*100) AS INTEGER) AS matricula_cents, c.agreement, g.occupation,g.study_place,g.parent_name,g.parent_email, m.found_us,m.enjoyment,m.nerves_confidence,m.additional_comments FROM users u LEFT JOIN user_profile p ON p.user_id=u.id LEFT JOIN user_sports s ON s.user_id=u.id LEFT JOIN user_health h ON h.user_id=u.id LEFT JOIN user_consent c ON c.user_id=u.id LEFT JOIN user_guardians g ON g.user_id=u.id LEFT JOIN user_marketing m ON m.user_id=u.id LEFT JOIN user_finance f ON f.user_id=u.id z( ORDER BY u.id DESC N) r[r splitrgrrrrextendrrrrv) r/r~rlrY roles_listrr8r  placeholdersrrrs &&& r3r|r|s1  D H#>>J 16S1AO1AAWWY'aggioo'1A O jjl((*+ EFxxc*o 56 *<.: j! Dll ,G - 012"%0AQ05 6 KIPF15 6 KsS*E%E%E"E> E% *E%4A E%>)E'E ;E=E% E E"  E%z/api/users/{user_id}/roleapi_users_set_rolec<V^8dQhR\R\R\/#rx)r?rkr)r2s"r3r4r4s&OOcOJOOr5c"\V4\V4pV'g\RRR7hVP;'gRP 4P 4pV\ 9d\RRR7h\VR,4P 4pVR8HpT;'dVR8gpWT8Xd RR R VRVR R /#V'd\4pV^8:d\RR R7h\W4RR R VRVR R /#5i)rrurMrKruRol inv�lidorlrmrTrchangedFuUDebe existir al menos un usuario con rol admin. No puedes degradar al �ltimo admin.) rZrr rlrgrr ALLOWED_ROLESrIrrs) rrMr/rnew_role current_role was_adminis_demoting_admin admins_counts &&& r3rrs' G $F 4KLL ""))+113H}$4DEEvf~&,,.L'I!99h'&9dIw)USS#~ 1 n '$ $ 7FHi NNs>C7A$C7&C73C7z^\d{4}-\d{2}-\d{2}$)patternz ^\d{2}:\d{2}$ca]tRtRto]!^<^R R7t]!^^R7t]!]R7tRt Rt Rt Rt Rt RtRtRtV3RltR tVtR#) ReservationInirr r>)default_factoryN confirmadaFc6<V^8dQh/S[;R&S[;R&S[;R&S[;R&S[S[,;R&S[S[,;R&S[S[,;R&S[S[,;R&S[S[,;R &S[S[,;R &S[S[,;R &S[S[,;R &S[;R &#r.r3r@rruser_idsrrErrrrrr)DateStrTimeStrr?rrrIr)r2rAs"r3r4ReservationIn.__annotate__s M M5%  3i5  c]!  3- C= C= SM( C= $ r5r)rCrDrErFrrrrrrrErrrrrrrGrHrIrJs@r3rrsZ""u5Q1~K5H!GDEE(FE $JDr5rca]tRtRtoRtRt]!R^RR7t]!R^R7tRt Rt Rt Rt Rt RtRtRtRtV3RltRtVtR#)ReservationUpdateiNrr>c<V^8dQh/S[S[,;R&S[S[,;R&S[S[,;R&S[S[,;R&S[S[S[,,;R&S[S[,;R&S[S[,;R&S[S[,;R&S[S[,;R &S[S[,;R &S[S[,;R &S[S[,;R &S[S[,;R &#r)rrrr?rrIr)r2rAs"r3r4ReservationUpdate.__annotate__s 7 " 7 "smA#2  tCy!(  c]!  3- C= C= SM  C= $ 4.r5rr)rCrDrErFr3r@rrrrrrErrrrrrrGrHrIrJs@r3rrs^"D"D&+DQ5&A!&t!2K$(H!GDEE FE $JDr5rcDa]tRtRto]!^^R7tRtV3RltRtVt R#)RatingInirNcN<V^8dQh/S[;R&S[;R&S[S[,;R&#)r. player_idscorecommentr)r2rAs"r3r4RatingIn.__annotate__s+N "c]!r5r) rCrDrErFrrrrGrHrIrJs@r3rrs!"E!Gr5rc!rRVR,RVR,RVR,RVR,RVR,R\VR,;'g^4R\VR,;'g^4R, RVR,R VR ,R VR ,R VR ,R VR ,R VR ,RRVP49d VR,MRRRVP49dVR,e\VR,4MR/p\4;_uu_4pVP RVR,34P 4pRRR4XUu.uFp\VR,4NK upVR&VUu.uF)pR\VR,4RVR,R VR ,/NK+ upVR&V# +'giLp;iuupiuupi)rr:r3r@rr price_eurY@rErrrrrrNrFz SELECT u.id, u.name, u.email FROM reservation_students rs JOIN users u ON u.id = rs.user_id WHERE rs.reservation_id = ? ORDER BY u.name student_idsr)r?rrrrr)rbasersrowsrs& r3rrs c$ic,'F F C 23s3}-223c#m,112U:F WWW3y>#h-<388:+Ec,'4Vsxxz%9c&k>US[![` D" A  $i\  $8:  277A3qw<7D^cd^cYZs1T7|VQvY7T^cdD K 8ds )FF/%/F4 F, c<V^8dQhR\R\R\/#)r.r/rrM)rr?r)r2s"r3r4r4;s'S&S&7S&CS&J[S&r5c "\V4\VR4'dVPRR7M T;'g/pVP4GRjxL pRV9d0RV9d)\ VP R4;'g^4VR&RV9dRV9dVP R4VR&RV9dPR V9dI\ \\\VR,4PR R 44^d,44VR &R V9dPR V9dI\ \\\VR ,4PR R 44^d,44VR &\V4p\4;_uu_4p\PVnVP!R V34P#4pRRR4X'g\%RRR7h\VR,4pTp RV9dVR,e\VR,4p MVP RVP R44p V ep\'V \4'dT p MV\'V \ \34'd;\V 4P)4P+4p V R:9dRp M V R;9dRp V'gW8Xd\%RRR7hV 'd^M^VR&RV9d4VR,e)\,P.P1VR,R4RV9dVR,e\VR,4P)4R,p \3\ V P5R44wr^T u;8:d^8dMM^Tu;8:d^<8gM\%RRR7hT ^8XdT^8Xd\%RRR7h^T u;8:d^8gM\%RRR7hT R RTR 2TR&RV9d9VR,e.\ VR,4pV^8:gVR<8d\%RR!R7hR"V9dZVR",eO\VR",4P)4P+4pV\69d\%RR#V 2R7hVVR"&RV9dgVR,e\VR,p\4;_uu_4pVP!R$V34P#4pV'g\%RR%R7hRRR4RV9dPR V9dI\ \\\VR,4PR R 44^d,44VR &R V9d<\ VR ,;'g^4VR &VR ,^8d\%RR&R7h0R=mp.p.pVP94F4wppVV9gKVP;V R(24VP;V4K6 V'g\%RR)R7h\ R V9dVP R 4MVR ,;'g^4pV'*;'dT pVP;V4\4;_uu_4p\PVnV'EdV^8EdVP!R*V34P=4pVUu.uF"pVR',fK\ VR',4NK$ ppV'g$VR','d\ VR',4.p/pVP R+4;'g/p\'V\4'dq/pVP94FXwpp\'V\4'd \ V4M \ V4p \ T;'g^4p!\?^T!4TT &KZ TpT'EdTPAR,TU"u.uFp"T"3NK up"4/p#T'd=TF5p"\?^\ TP T"T4;'g^44T#T"&K7 M+TF%p"\?^\ T;'g^44T#T"&K' \,P.PC4PER-4p$TP R4;'g TR,p%TP R4;'gTR,;'gR.R,p&R/T% R0T& 2p'.p(T#P94FXwp"p)\T)R1, ^4p*TP!R2T*T"34T)^8gK6T(P;T$T%T"T\ T)4R3T'R34KZ T('dTPAR4T(4VP!R5R6PGV4 R72\IV44VPK4RRR4R8RR9V/#E L. \d/pE LrvT) exclude_unsetNdurationr teacher_idrrrr.price'SELECT * FROM reservations WHERE id = ?rzReserva no encontradarMrFhas_paidrzNada que actualizarr3r+u(Fecha inválida. Usa formato YYYY-MM-DD.r@NN:u"Hora inválida. Usa formato HH:MM.Hora inválida.,No se admiten reservas a medianoche (00:00).u&Hora fuera de horario (08:00–22:00).02dDuración inválida.rEstado no permitido: FSELECT id FROM users WHERE id=? AND LOWER(COALESCE(role,''))='docente'/docente_id no corresponde a un docente válido.Precio inválido.rz = ?u'Ningún campo permitido para actualizarzASELECT user_id FROM reservation_students WHERE reservation_id = ?per_student_centsrz%Y-%m-%dT%H:%M:%Sz00:00Reserva  rcUPDATE user_finance SET matricula_eur = ROUND(COALESCE(matricula_eur,0.0) - ?, 2) WHERE user_id = ?reservaz INSERT INTO jugadores_gastos (created_at, date, user_id, reservation_id, amount_cents, category, concept, notes) VALUES (?, ?, ?, ?, ?, ?, ?, ?) zUPDATE reservations SET rz WHERE id = ?rr1trueusísion)0falsenooffr> r3rErr@rrrrrrrr)&rzrrvjsonrr?rProundfloatrIreplacerrrprqrrrr rorgrrrrr-maprALLOWED_STATUSESrrrr executemanyrPrQrrr)+r/rrMupdatesrawhas_other_updatesrprev_row prev_paidnew_paidrr(thhmmdmin status_normrdallowed set_partsargsrreffective_price_cents do_charge_nowrrrrpsctmpkkvvr8sharesnow_txtdate_txttime_txt concept_baseto_insshare share_eurs+&&& r3api_reservations_updater:s W%29'62J2Jglll.QXQ^Q^\^GLLN"S/w> *-cggj.A.F.FQ*GG& 's|7: # 5 cm7: %(uS[9I5J5R5RSVX[5\/]`c/c)d%eGM "#~-w6 %(uSW5F5N5NsTW5X/Y\_/_)`%aGM "W  D";;<< IF9U^^`  4KLL&)* H WV_8(ggfcggj12 ?#t$$C#s,,HNN$**,88#H55$H !64IJJ#aGFO WV_8 d KK * =WV_8 ^GFO$**,R0Aaggcl+FBR " b2C8IJ J 7rQwC8fg gR " C8`a aHAbX.W$1C)D)P7-./ 19u C8NO O7wx0<'(+,224::< . .C:OP[}8]^ ^'w7<#8#D\* WW X hj # '%(uS9M5N5V5VWZ\_5`/adg/g)h%iGM " '%()?)D)D1%EGM " = !A %C8KL LGI D 1 <   s$Z ( KKN  4]^^" #-SZBZGKK $>aijwaxa}a}|} #]00MKK D";; =2Q6<<S hj 7;Wda l,3q|,dKW8I#6#6%#&x ':#;"Af)k0Af;k087g /k0? k0 g!Ck0"k0=k0'g5>k0AhEk07h-k0)Ai0k08i i=k00k0 k0,i/i/ k0&k0A k jj4kj!k$k<1k.,j j/)j/0kkk k*k;B+k'!k kAk4-k"Ak2k0f fk0fk0 f&"k0%f&&k0) f84k07f88k0; g k0 g  k0 g  k0! g2.k01g22k05hk0h**k0- h> 8 k0ik0ik0i,(k0+i,,k0/ j<k0?jk0k jkjk j, 'k+j, ,k/ k <k?k k kkkk k- ' k0z/api/reservations/{rid}c0V^8dQhR\R\/#)r.r/ridr)r2s"r3r4r4sgg7ggr5c $a"\V4RRloRV3Rllp\4;_uu_4p\PVnVP RV34P 4pV'g\RRR7hRp\VR ,4pV'Ed\VP44pR V9d\VR ,;'g^4M^p.pR V9dQVR ,'dB\P!VR ,4;'g.U u.uFp \V 4NK pp M*R V9d$VR ,'d\VR ,4.pV'g V!W14p\VU u0uFp \!V \4'gKV kK up 4p/p R V9dVR ,'du\P!VR ,4;'g/p V P#4F8wr\V 4pV'dW9d\T;'g^4W&K8K: V 'gTp\%V4pV^8d\'\)V4V4wppVUu/uFqVbK ppVRVFpVV;;,^, uu&K V^8d.\+VP44Fp VV ,)VV &K Tp V P#4FlwppT;'g^R, pVP RV34P 4pV'dVP RVV34KXVP RVV34Kn VP RV34VP RV34VP-4RRR4RR/# \dRpELi;iuup i \d.pELVi;i \d.pELji;iuup i \dEKi;i \d/p ELi;iuupi +'giRR/#;i5i)c0V^8dQhR\R\/#)r.rEr0rIr)r2s"r3r4-api_reservations_delete..__annotate__s#$r5cZVPRV34P4p\V4#)z>SELECT name FROM sqlite_master WHERE type='table' AND name = ?)rrr)rrErs&& r3 _table_exists.api_reservations_delete.._table_existss0ll L G  (* Cyr5cFV^8dQhR\R\\,/#)r.rr0)r?r)r2s"r3r4rs   c r5c$<RFqpS!W4'gKVPRV R2V34P4pV'd1VUu.uF!qD^,fK\V^,4NK# upu#Ks .#uupi \dKi;i)reservation_userszSELECT user_id FROM z WHERE reservation_id = ?)rreservation_studentsreservation_alumnos)rrr?r)rrrrrrs&& r3_get_uids_from_bridge6api_reservations_delete.._get_uids_from_bridgesUAT%%<<.qc1JKhj37L4aQ4 AaD 4LLV  M s/,BB A;A;0B;B BBrrr[rMFrr user_ids_jsonrper_student_cents_jsonNrz2SELECT user_id FROM user_finance WHERE user_id = ?zWUPDATE user_finance SET matricula_eur = COALESCE(matricula_eur,0) + ? WHERE user_id = ??INSERT INTO user_finance (user_id, matricula_eur) VALUES (?, ?)z5DELETE FROM jugadores_gastos WHERE reservation_id = ?z%DELETE FROM reservations WHERE id = ?rT)rzrrprqrrrr rrrrr?rloadssortedrorrdivmodabsrr)r/rrrr paid_flagrruidsxrper_mapjrrr8sidsr rremrcentseurrrs&& @r3api_reservations_deletersW%   D";;llDsfMVVXC8PQ Q  S[)I 9sxxz?D:G4:O#c-055A6UVK D$&3+?+?,0JJs?7K,L,R,RPR,RS,RqCF,RDSDd"s9~~I/0D,T7dAdjC.@11dABD&(G'4/C8P4Q4Q ! 3'?#@AGGRA ! %"%a&C#'3;/2166{ ,7!*Iq5 &s;'7 ;ID#0459C5#DSzCA  *"Q!%chhj!1A&)!fWCF"2!G%mmo UzzU*llHF(*LLqc  LLYc ." LLPSVRX Y ;'g.4pTP@'dTPCTP@4\E\GRT444pT'Ed$\I4;_uu_4pTPKRRPMR\OT4,4 R2\QT44PS4pRRR4XUu/uFp\TR,4TbK ppTUu.uF#pTT9gTT,R,R8wgK!TNK% ppT'd\!RR T 2R7h\OT4^8XdDTT^,,pT'g TR!,pT'g TR",pT'g TR#,pTPTe TPTMRpTfR$T9dTP R$4pTei\T4pT^8dT\I4;_uu_4pTPKR&T34PW4pT'g\!RR'R7hRRR4MRp\OT4^8Xd T^,MRp\PXP[4P]R(4p/pTP R)4;'g/p\T\^4'dq/pTPa4FXwp p!\T \4'd \T 4M \T 4p"\T!;'g^4p#\c^T#4TT"&KZ TpT'd/p$T'd=TF5p\c^\TP TT 4;'g^44T$T&K7 M+TF%p\c^\T ;'g^44T$T&K' \eT$Pg44p%M/p$\T ;'g^4p%\I4;_uu_4pTPKR*TYgT T%YTTPhTT TT'd^M^3 4p&T&Pjp'T'EdTPmR+TUu.uFpT'T3NK up4TPmR,TUu.uFpT3NK up4T'dT$Pa4F-wpp(\-T(R-, ^4p)TPKR.T)T34K/ .p*R/T R0T 2p+T$Pa4F:wpp(\T(4^8gKT*PCTTTT'\T(4R1T+R34K< T*'dTPmR2T*4TPo4RRR4X'p,\I4;_uu_4p3T3PKR8X,34PW4p-T3PKR9T,34PS4p4T4'd \=T44M.p5T5'gRp6T-R7,'d)T3PKR:T-R7,34PW4p6T6'g8T-R",'d)T3PKR;T-R",34PW4p6T6'dT6.p5Rp7T-R<,e<T3PKR=T-R<,34PW4pT'd TR!,MRp7T5'dR>p8R?T-R@, RAT-RB, 2T7'dRCT7 2MR,R,p9\\uT4R,4p:\PXPw4PyRDRE7p;T3PmRFT5Uu.uFpT;T:\TR,4T8T9T,3NK up4T3Po4RRR4RGRRX,/#E L \d/pE Li;i \d\!RRR7hi;i \d\!RR R7hi;i \d^p EL_i;i \d\!RRR7hi;i +'giEL;iuupiuupi \d\!RR%R7hi;i +'giEL;i \dEKsi;i \d^p#EL>i;i \d/pEL=i;iuupiuupi +'giEL>;i \pPrEd%\I4;_uu_4pTPKR3YgT34PW4p-T-'g\!R4R5R7h\T-R,4p.TPKR6T.34PS4p/T/Uu.uFp\TR7,4NK Muupip0pTUu.uFpTT09gK TNK Muupip1pT1'gT.p,EM2TPmR+T1Uu.uFpT.T3NK Muupiup4TPmR,T1Uu.uFpT3NK Muupiup4.p*R/T R0T 2p+T'dT1FpTP TT 4p2\T2;'g^4p2M \d^p2Mi;i\-\c^T24R-, ^4p)TPKR.T)T34T2^8gKyT*PCTTTT.\T24R1T+R34K T*'dTPmR2T*4TPo4T.p,RRR4EKc +'giELu;ii;i \d^p:ELi;iuupi +'giEL;i \dELi;i5i)JNFrrTrru!Fecha inválida (usa YYYY-MM-DD).rMruHora inválida (usa HH:MM).rrz$Hora fuera de horario (08:00-22:00).rrrrrKrrrrrc3B"TFqfK\V4xK R#5irr)r.rs& r3r1*api_reservations_create..s NAQsuIDs de alumnos inválidos.zXSELECT id, LOWER(COALESCE(role,'')) AS role, name, email, phone FROM users WHERE id IN (rrrrlruIDs no v�lidos o no alumnos: rErrrudocente_id inválido.rrrOrz INSERT INTO reservations (created_at, date, time, duration_minutes, price_cents, name, email, phone, notes, user_id, status, docente_id, paid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) zQINSERT OR IGNORE INTO reservation_students(reservation_id, user_id) VALUES (?, ?)rrrrrrz INSERT INTO jugadores_gastos (created_at, date, user_id, reservation_id, amount_cents, category, concept, notes) VALUES (?, ?, ?, ?, ?, ?, ?, ?) z\SELECT id FROM reservations WHERE date=? AND time=? AND COALESCE(docente_id,0)=COALESCE(?,0)rz%Ya existe una reserva en ese horario.z?SELECT user_id FROM reservation_students WHERE reservation_id=?rrz SELECT u.id, u.name, u.email FROM reservation_students rs JOIN users u ON u.id = rs.user_id WHERE rs.reservation_id = ? ORDER BY u.name rz?SELECT id, name, email FROM users WHERE lower(email) = lower(?)rz#SELECT name FROM users WHERE id = ?zReserva creadaz!Se ha creado una reserva para el r3z a las r@z con secondstimespecz INSERT INTO notifications (created_at, sender_id, recipient_id, title, body, is_read, reservation_id) VALUES (?, ?, ?, ?, ?, 0, ?) rrr)=rzrrrrrrPror?rIrgrrr3r@r fromisoformatr rrrrgetattrrrrrrrErrrrrrr rrrrrrrrrrrPrQrvrrsumrrrrrrpIntegrityErrorr[rr) m7C >11\88:@@BK**6KK=4YZZ LL DD ]] " "dE ]] " "dEw''--2.K7??+RS N NNO { WW<<jknkskstwx{}HyIuIlJkKKLMk"hj  +//$QQtWq$/)`ksS-=sFASW_A_ssk` C:\]`\a8bc c { q {1~&B&z7 7 '.'9'9'E##4Jlc1WW\*  QZJ >DLL\M(*'C@qrr J'*;'71'<[^$Nkkoo(()<=Ggg)*00b c4 C 1#-a#5#5Q3q6BQVV!Ba*B$!$  "!!S):)>)>sK)P)U)UTU%VWs ##!!S)9)9%:;s # 0 0 0q1h5 WW,, 8t5FUZ\c\i\iky|GISZcUVijk lC ]]F{  g.9:ksfc]k:  `'23{cV{3&,lln U$)%%-$;  B&,'5  F%-hZq #CL&,lln Uu:>"MM ' ( # & #E ) , $ + '5((*$ % KKMWX"(x3 WW-- ILbKdennpCMM# )* , -5HJ ).e2Jy>>!MMF9~'hjW!MMW7|ohj"'JL< ,MM"G#lJ[I]^ggi,-qy4 )5c&k]'#f+W/;u\N+E " #L$9$$? @I++,,.88)8L!!# &%aIs1T7|VVE[\%  af $4 55w# " Y4WXXY S4QRRS& K  R4PQQRWW 0`" QC8OP P Q&!!B 2;4WWZ  ! !:5 WW,,l:.hj #>g3q|,g>K>%0K[cC{4Jcc[KFK)4&  e178#K%8  ^%+,VcC6V,!)(1XJ? % 1 5 5c; G&$' OE(&$%E&$)#a-%*?$C  $c*!19"MM ' ( # + #E ) , $ +  &,((*$ %  )4&sWWW:5B!" !I"YWWb    s yj2j/j2C9y!k!k""B9yAyy2=k>/&yA y#y9yy*yyl:yyA l." y.m ym3m9Ay;y yAy# m .y7m(?Ayn#-1n#,m< nn!n#6y> yByy!o3Ao:o n7o. n<:o A.o<-o*"o ox?)Ax+ x+/x+ x+/x+ ?x+ x+x+;x+x+>x+)!x& x+!x?)y/j22 k?ykyky"k;;y> l ylyl++y. l? 9y m%%y( m9 3 y< n n# n  n# n n#n  n## n40y3n44y7 o o o(x=A/w9,r  w9 r( !r( '$w9 sw95 tw9 w98 uu w9 u w9u 8w9-w9 $w9-x5y9 x xy xy x#x+"x##x++ x< 6x?:y<x?? y y yyc V^8dQhR\R\\,R\\,R\\,R\\,R\\,/#)r.r/r#r$rrrr%)r2s"r3r4r4s`M7M7 M7}M7c]M7c] M7 SM M7  M7r5c ""\V4RRlpV'd V!V4V'd V!V4V'dV'd W8dY!r!RpV'dWVP4P4pV\9d.\ RRRP \ \44 R2R7h.p.p V'd#VPR4V PV4V'd#VPR 4V PV4Ve#VPR 4V PV4V'd#VPR 4V PV4Ve#VPR 4V PV4V'dR RP V4,MRp RV R2p \4;_uu_4p V PW4P4p RRR4X Uu.uFp\V4NK up# +'giL+;iuupi5i)c(V^8dQhR\RR/#)r.r(r0Nr)r2s"r3r4+api_reservations_list..__annotate__sjjsjtjr5cv\P!VR4R# \d\RRT R2R7hi;i)r+ruFecha inválida: z. Usa formato YYYY-MM-DD.rMNr,r.s&r3 _check_date*api_reservations_list.._check_datesA j   a , jC:KA3Ng8hi i jr1NruEstado inválido. Usa uno de: rrrMz date >= ?z date <= ?rzLOWER(status) = ?rr2rrKaR SELECT id, created_at, date, time, duration_minutes, price_cents, name, email, phone, notes, user_id, status, docente_id, paid FROM reservations z1 ORDER BY date ASC, time ASC, id ASC ) rzrgrrrr rr rrrrr)r/r#r$rrrr:rr8r clauser9rrrs&&&&&& r3api_reservations_listr=sW%j IGW!4$7!%K lln**, . .7 &IYBZ8[7\\]^  EF [! i  [! g ]# g () k" %& j!27i',,u--RF " # C* D||C(113 26 6A $Q ' 66  7sZ)HHHHA!H8)H"AH2AH2H4 G7 H H 4H7 H  H/perfilc$V^8dQhR\/#rWr1)r2s"r3r4r4s'r5c "\V4pV'g\RRR7#\V\P4'd\ VR,4M\ VP R44p\V\P4'd VR,MVP R4;'gRP4p\4;_uu_4pVPRW#34P4pV'd VR,M^pRRR4\PR R VR VR X/4# +'giL,;i5i) rrrrrrKz SELECT COUNT(*) AS c FROM reservations r WHERE r.user_id = ? OR LOWER(COALESCE(r.email,'')) = LOWER(?) rNz profile.htmlr/rYr ) r[r rorprqr?rPrgrrrr\r]r s& r3perfilrAs g B H#>>'GKK88C4Mc"&&,>OE)"gkk::7 w@U@USU\\^H Dll     (* ),CH   % % w B !2   s$B-D?0#D?5D,$D?, D< 7D?/ajustesc$V^8dQhR\/#rWr1)r2s"r3r4r4 swr5c "\V4pV'g\RRR7#\4;_uu_4pVPRVR,34P 4pVPRVR,34P 4pVPRVR,34P 4pRRR4X'd \ V4M/pX'dVP \ V44X'dVP \ V44\PRR VR VR VPPR 4/4# +'giL;i5i) rrrz8SELECT id, name, email, created_at FROM users WHERE id=?rz6SELECT phone, avatar FROM user_profile WHERE user_id=?zPSELECT team, category, position, injury_history FROM user_sports WHERE user_id=?N settings.htmlr/rYr9) r[r rrrrvupdater\r]r;rP)r/rtrrow_core row_profile row_sportsctxs& r3 ajustes_getrK s  g B H#>> D<< Z]_`d]e\ghqqsll#[^`ae^f]hirrt \\"twyz~wwBCLLN  %$x."C 4 $% 4 #$  % % w C GOO''/   s03EA9E.E>E!E5AE E EcV^8dQhR\R\R\R\R\R\R\R\R \R \/ #) r.r/rErrrrrrrr9)rrIr)r2s"r3r4r4, sl9<9< 9< 9< 9<  9<  9<  9<9<9<9< 9V R,34V P RV R,34V P RWVWxV R,34V P-4RRR4\RRR7# +'giEL;iL +'giL;i +'giLF;i \.P0d;\PR R TR T R RRTPP!R4/4u#i;i5i)rrrrKNz1SELECT avatar FROM user_profile WHERE user_id = ?rrrrEr/rYr`z:Formato de imagen no permitido. Usa PNG, JPG, JPEG o WebP.r9rDrTrrrz/static/uploads/user_z+UPDATE users SET name=?, email=? WHERE id=?rz9UPDATE user_profile SET phone=?, avatar=? WHERE user_id=?rzWUPDATE user_sports SET team=?, category=?, position=?, injury_history=? WHERE user_id=?u+El correo ya est� en uso por otra cuenta.r>)z.pngrz.jpegz.webp)r[r rTrgrrrrrrrrrrr\r]r;rPrrrrrrrpr )r/rErrrrrrrr9rtrrcurrent_avatarrextrrrs&&&&&&&&&& r3 ajustes_postrP+ s^ g B H#>> JJB   D [[b   !Ekkr " * *dE ZZR   ( (DDR&&(00DHR&&(00DH%++224<<N DllNQSTXQYP[\eeg*-X4 !K v'&*d33ggv/288: 8 8--o7U++F3 @  )I5 $6E"T(C5"99 )T " "a GG&++-' (#-bhZu=  WW LLFVXY]V^H_ ` LLQTVW[T\S^ _ LLTW\kmnrksVt u LLPSUVZS[R] ^ LLruyFN`bcg`hui j KKM   s ;;E "(# "W  ! ! ))/ w B B GOO''/ <    s4O"O"O"+O" O"O"' O"3O" O"O"/ O";O"O"( '' rlNrKrmryz AND r.docente_id = ?rz AND r.user_id = ?z& ORDER BY r.created_at DESC, r.id DESCcLWP49# \dR#i;i)F)rr)rkeys&&r3hasnotes..has s( ((*$ $  s  ##c<VFCpS!W4'gKW,pVfK!\V4P4R8wgKAVu# R#)NrK)rIrg)rnamesr rrUs&* r3rnotes..pick s>A3{{f?s3x~~'72'=J  r5cn<S!VR4;'g%S!VR4;'gS!VR4;'gR#) student_namerEr—rrrs&r3 student_labelnotes..student_label s7C(__Df,=__c7AS__W__r5cL<S!VR4;'gS!VR4;'gR#)r0 docente_emailr\rr]s&r3 docente_labelnotes..docente_label s'C(RRDo,FRR(Rr5r3fechar@hourhorar:r dt_displayrstudentz notes.htmlr/rYr)r[r rrIrr?rrrrrrgr\r])r/rtr9r rlrrr^rbrrrrpartsrgrUrs& @@r3rrh sh g B H#>> CF$ 1bj6L3r&z?RTD w   && c"T(m$ ## c"T(m$ 33C D||C(113  `S EVW-33VVV4::C\22s<7H7HL)*002E5zQ 85zQ 8;Cx !H:.557knoruAlBlBVYZfVgHJ  s3~~#d)4 H H * s3 /E/E#l+4 S\ }S) }S)  (  % % w B U  O s\CJ J<5J2J JJ!J0AJ J#J6%JJ> D  D z/ajustes/passwordc TV^8dQhR\R\R\R\R\/#)r.r/current_password new_passwordconfirm_passwordr9rH)r2s"r3r4r4 s:$=$= $=$=$= $=  $=r5c "\V4pV'g\RRR7#\W4T;'gRP4pT;'gRP4pW#8wd\P RRVRVRR/4#\ V4^8d\P RRVRVRR /4#\V\4'dVPR 4MVR ,p\W4'g\P RRVRVRR /4#\V4p\4;_uu_4pVPR WuR ,34VP4RRR4\RRR7# +'giL;i5i)rrrrKrEr/rYr`uLas contrase�as no coinciden.u7La nueva contrase�a debe tener al menos 8 caracteres.ru&La contrase�a actual no es correcta.z+UPDATE users SET password_hash=? WHERE id=?rNrB)r[r rTrgr\r]rrorvrPr{rtrrr) r/r}r~rr9rtrvnew_hashrs &&&&& r3ajustes_passwordr sh g B H#>> &&B--/L(..B557'))/ w B 6<    <1))/ w B N<   .8D-A-A"&&)r/GZK + 9 9))/ w B =<   \*H D BXRVxDXY     << s)4E=E=CE=*+E*E=* E: 5E=cBa]tRtRto]!^R7tRtV3RltRtVt R#)MatriculaPayloadi r>addcB<V^8dQh/S[;R&S[S[,;R&#)r.matricula_centsmoder)r2rAs"r3r4MatriculaPayload.__annotate__ s& 3-r5rN) rCrDrErFrrrrGrHrIrJs@r3rr s A;ODr5rz/api/users/{user_id}/matriculac<V^8dQhR\R\R\/#r.r/rrMrr?rv)r2s"r3r4r4 s!, , g, , d, r5c "\V4\VPRR44P4pVR9d\ RRR7hRV9pRV9pV'gV'g\ RRR7hV'd8\ \ \VR,4PRR 44^4pM&\VR,4p\ TR , ^4p\4;_uu_4pVPR V34P4p V 'gVPRVR34Rp M\ V ^,;'gR4p VR8XdTp M\ W,^4p VPRW34RRRV R\\ V ^d,44/uuRRR4# \d\ RR R7hi;i \d\ RR R7hi;i +'giR#;i5i)rrrzmode debe ser 'set' o 'add'.rM matricula_eurrzFalta matricula_eur.rrumatricula_eur inv�lido.umatricula_cents inv�lido.rz8SELECT matricula_eur FROM user_finance WHERE user_id = ?rgz;UPDATE user_finance SET matricula_eur = ? WHERE user_id = ?rTN>rr) rZrIrPrrr rrrrr?rrr) r/rrMrhas_eur has_centseurosrrrr*new_vals &&& r3api_users_update_matricular s' w{{65) * 0 0 2D >!4RSS(G!W,I 94JKK U%GO$< = E Ec3 OPRSTE W 123EeemQ' DllUX_Wabkkm LLZ]dfi\j kGCFMMc*G 5=GGOQ/G RU\Tfg $ W s53#78   UC8ST T U  WC8UV V W sbAG,G,%G,;5F 0G,2F<%G,)AG?AG G, F99G,<GG, G) # G,)Pathc<V^8dQhR\R\R\/#rr)r2s"r3r4r4/ s"///3/UY/r5c,"\V4VPR4;'gRP4P4pV\9d\ RRR7h\ 4;_uu_4pVPRV34P4pV'g\ RRR7hVPRW134VP4VPR V34P4pR R R 4R R R \X4/# +'giL;i5i)rlrKru Rol inválidorMz'SELECT id, role FROM users WHERE id = ?rrurrz@SELECT id, name, email, role, created_at FROM users WHERE id = ?NrTrY) rZrPrgrr VALID_ROLESr rrrrrv)r/rrM target_rolerrupdateds&&& r3api_users_update_roler. s';;v&,,"335;;=K+%ODD DllDwjQZZ\C8OP P = ?UV ,,adkcmnwwy  $W .. sA-D/A;D*D D Dz /api/ratingsapi_ratings_createc0V^8dQhR\R\/#rL)rr)r2s"r3r4r4@ sgr5c p"\V4p\VP4pV'g\RRR7h\ VR,4P 4R8wd\RRR7h\ VP4pVP;'gRP4p\P!4PRR 7p\4;_uu_4pVPR \ VP4\ VR ,4WEV34R R R 4R R/# +'giR R/#;i5i)rzJugador no encontradorMrlrrzSolo se pueden valorar alumnosrKrrzaINSERT INTO player_ratings (player_id, docente_id, score, comment, created_at) VALUES (?,?,?,?,?)rNrT)rzrrr rIrrr?rrrgrrrrr)r/rMrtplayerrrrPrs&& r3rr? s !' *B G-- .F 4KLL 6&>  "h.4TUU  E$$"++-G //  % %y % 9C D o "" #SD]EC H   $<  $<s%BD6AD6:D  D6 D3 + D6api_ratings_listcFV^8dQhR\R\\,/#r.r/r)rrr?)r2s"r3r4r4R sG r5cX"\V4p.pRpV'dRpVP\V44\4;_uu_4pVP RV R2V4pVP 4Uu.uFp\ V4NK ppRRR4V#uupi +'giX#;i5i)rKzWHERE r.player_id = ?a% SELECT r.id, r.player_id, r.docente_id, r.score, r.comment, r.created_at, p.name AS player_name, d.name AS docente_name FROM player_ratings r JOIN users p ON p.id = r.player_id JOIN users d ON d.id = r.docente_id z( ORDER BY r.id DESC N)rzrr?rrrrv) r/rrtr r8rrrrs && r3rrQ s !' *B F E' c)n% Dll G  "%0AQ0  K1  Ks0AB*)B1BB B*B B' ! B*z/logoutc$V^8dQhR\/#rWr1)r2s"r3r4r4g s66'6r5cX"VPP4\RRR7#5i)rNrr)r;r<r rAs&r3logoutrf s" OO  55s(*z /api/healthc"RR/#5i)rrrrr5r3healthrk s d s)rr)rrcDa]tRtRto]!^^R7tRtV3RltRtVt R#)ValoracionItemis rNcf<V^8dQh/S[;R&S[;R&S[;R&S[;R&S[S[,;R&#)r.area subescala indicadorr observacionesr@)r2rAs"r3r4ValoracionItem.__annotate__s sC INN "  C=' r5r) rCrDrErFrrrrGrHrIrJs@r3rrs s!"E#'M r5rc,a]tRtRtoV3RltRtVtR#)ValoracionJugadorIniz cB<V^8dQh/S[;R&S[S[,;R&#)r.rr)r?rr)r2rAs"r3r4 ValoracionJugadorIn.__annotate__z sN  r5rNrnrJs@r3rrz ror5rz/api/valoraciones_jugadorc0V^8dQhR\R\/#rr)r2s"r3r4r4 s ' ' 'S 'r5c"\V4\4;_uu_4pVPRV34P4pVUu.uFp\ V4NK upuuRRR4#uupi +'giR#;i5i)a SELECT eval_id, created_at, docente_id, area, subescala, indicador, score, COALESCE(observaciones,'') AS observaciones, (SELECT name FROM users WHERE id = docente_id) AS docente_name FROM valoraciones_jugador WHERE player_id = ? ORDER BY created_at DESC, eval_id, area, subescala, indicador N)require_docenterrrrv)r/rrrrs&& r3api_valoraciones_jugador_listr siG D|| \$8: "&&AQ& ' s.B&A,A'A, B'A,, A= 7 Bc0V^8dQhR\R\/#)r.r/rr)r2s"r3r4r4 s+1+1G+1c+1r5c4"\V4\V4pRp\VR,4pTeT\T48Xd\ RRR7h\4;_uu_4p\PTn TPRT34P4pT'g\ RRR7hTPRT34TPR Y34TPR T34TPR T34TPR T34TPR T34TPRT34TPRT34TPRT34TPRT34RRR4RRR\T4/# \d>\\ T4P R44pEL \dRpELi;ii;i \dELi;i \dELi;i \dLi;i +'giL;i5i)Nrrz%No puedes eliminar tu propio usuario.rMz!SELECT id FROM users WHERE id = ?rrrrz*DELETE FROM user_profile WHERE user_id = ?z*DELETE FROM user_sports WHERE user_id = ?z*DELETE FROM user_health WHERE user_id = ?z*DELETE FROM user_consent WHERE user_id = ?z,DELETE FROM user_guardians WHERE user_id = ?z,DELETE FROM user_marketing WHERE user_id = ?z,DELETE FROM user_finance WHERE user_id = ?rrTdeleted) rZr[r?rrvrPr rrprqrrr)r/rrtrLrrs&& r3api_users_deleter s' g B EBtH  Uc'l24[\\ D";;ll> KTTVC8PQ Q  LLMPWz Z  LL\_f^p q  LLEz R LLEz R LLEz R LLEz R LLG' T LLG' T LLG' T 5zB3 6 $ 3w< 00I  R T*+E E "         - sHF3H!A H.GG"BG4H.H G #F74H7 G G HG  G  H GHGH" G1-H0G11H4 H?HHH H H)r rc$V^8dQhR\/#rWr1)r2s"r3r4r4 s  W r5c\V4pV'g\RRR7hVR,pVR9d\RRR7hV# \d\TRR4pL0i;i)rLzSe requiere rol docente.rMrlNrx)r[r rrrss& r3rr sh g B 4NOO)&z ''4NOO I )r64()s AAAc$V^8dQhR\/#rWr1)r2s"r3r4r4 s!!!r5cVPPR4;'g&VPPR4;'gRp\W4R#)rbz X-Csrf-TokenrKN)rerPrTrfs& r3require_csrf_headerr s> OO   / \ \7??3F3F~3V \ \Z\E r5c0V^8dQhR\R\/#rL)rr)r2s"r3r4r4 s,,7,EX,r5c"\V4p\V4VP'g\RRR7h\P !^4p\ 4;_uu_4pVP4pVPFpTPRY1PVR,VPP4VPP4VPP4\VP4VP ;'gRP4;'gR34K VP#4RRR4RRR V/# +'giL;i5i) ruSin �tems en la evaluaci�n.rMz INSERT INTO valoraciones_jugador (eval_id, player_id, docente_id, area, subescala, indicador, score, observaciones) VALUES (?, ?, ?, ?, ?, ?, ?, ?) rrKNrTeval_id)rrrr r= token_hexrrrrrrgrrr?rrr)r/rMrtrrrits&& r3api_valoraciones_jugador_creater s  !B ===4UVV"G Dkkm--B KK **BtH !3!3!5r||7I7I7KBHH  0 0 6 6B==?GG4      $ 7 ++ s%AE& CE)EE& E# E&)HTTP_403_FORBIDDENHTTP_404_NOT_FOUNDc0V^8dQhR\R\/#)r.r/exc)rStarletteHTTPException)r2s"r3r4r4 s M M' M8N Mr5cb"\V4pVP\8Xd!\P RRVRV/\R7#VP\ 8Xd!\P RRVRV/\ R7#\RVP/VPR7# \dRpLi;i5i)Nz404.htmlr/rY)rNz403.htmlrO) r[rrNrr\r]rr rO)r/ruser_ctxs&& r3http_exception_handlerr s( ,,))*y'6S[6\j|)}} ,,))*y'6S[6\j|)}} 3::.COO LL s(B/ BB B/ B,)B/+B,,B/c$V^8dQhR\/#rr)r2s"r3r4r4 ssr5c\4;_uu_4pVPRV34P4pVuuRRR4# +'giR#;i)a SELECT id, created_at, title, body, sender_id, recipient_id, reservation_id FROM notifications WHERE recipient_id=? AND COALESCE(is_read,0)=0 AND COALESCE(deleted_by_recipient,0)=0 ORDER BY created_at DESC Nr:)rrrs& r3rr sB D|| Z  "  rstartupc\4;_uu_4pVPR4VP4RRR4\ 4\4;_uu_4pTPR4TPR4RRR4\ 4R# +'giLd;i \dLti;i +'giL@;i \dLPi;i)z UPDATE reservations SET name = (SELECT name FROM users WHERE users.id = reservations.user_id) WHERE (name IS NULL OR name='') AND user_id IS NOT NULL NzPRAGMA optimize;z PRAGMA wal_checkpoint(TRUNCATE);)rrrrrr&rs r3 on_startupr s  WW LL  KKM  I WW LL+ , LL; < !W    W    s]B%"BB% C #B6>C  B" B%"B%% B32B36 C C C CC)prod productioni: >PUTPOSTPATCHDELETE)rNN)r)NNN>rmrry>seniorcadetesjuvenilalevinesbenjamin infantiles prebenjamin> cancelada pendienter)NNNNN)fastapirrrrrrr fastapi.responsesr r r fastapi.staticfilesr fastapi.templatingrstarlette.middleware.sessionsrpasslib.contextrpydanticrrppathlibrretypingrrrrrrrrrrrrprQr=r@rrr,r3 urllib.parseurllibr%rappr__file__resolveparentrrgetenvrrIS_PRODr> SECRET_KEYadd_middlewarerrBmountr\rTrPr_rdrgrZrzrrrrrrrpostrrrrrrrrvrr#r&r6r[r;r>rBrFrGrSrXr[rarbrmrqrrr|r}r UPLOADS_DIRrrrrfrmrr;r=rSdeleterVrWr^rrzrbrkrsrvr|rrIrrrrrrpatchrrrr4r=rArKrPr passlib.hashr)rorrtr{rrrrrrrrrrrrrrrrrstarlette.exceptionsrstarlette.statusrrexception_handlerrron_eventrrr5r3rs QQQJJ+.;( (11*88!!  66! K  << ! ) ) + 2 2 \ ! ))Iu % + + -1G G YY' ( E EG,A,A",E  % H:&A 5  )[<8x H o 6 L 6_7_ 4%   AJ" &k &9:9:;;;@00, $\B&C& :<XY$ %lC!&D!&J .tDTET, +,aA+?@bQ34JK"4[ %d !$K @W-@WD  (     $+@A 9:&*4jDz 'DB'DR\*V+V,/V0Vl3m4m =Y>Y(lC48ItTWy SD S)LAB&~lK]L]  CTUVB:lCnDn +OLI6:3idSViimnqirSJS* #9,WX!I- 9  $;<X<=XS&l %d;g<gZ< d3^64^6F  T$Z8M79M7b<014L12.*\2S cddT JJt*S 9<39