jO< UdZddlZddlZddlZddlmZddlmZmZddl m Z ddl m Z m Z ddlmZddlmZej$d ZGd d eZid d ddddddddddddddddddddddd ddddd dddddd dd!dd"dd#dd"dd$dd dd%d&ee j.d'd(dd)d dddd*d dd+dd,d dddd-d.ddd/d0ddd1d2ddd"dd&d3d'd4ddd"ddd dd&d5dd6dd7Zeeeeeffed8<e j6j9D]E\ZZdd9eevr&eej?dj?d9needd:dee<Ge e j6jCZ"ejFd;Z$dZ&d?ed@ed=efdAZ'dgdBZ(dCed=efdDZ)dEed=efdFZ* dhdCedGeedHeedIeed=ef dJZ+d=efdKZ,dLed=eefdMZ-dLed=eefdNZ.didOe/d=e efdPZ0ddddQdLedCeedRee/dHeed=ef dSZ1djdLed=eeeffdTZ2dLedUed=eeeffdVZ3dWed=eee%ffdXZ4dYdZd[d\d]d^d_d`Z5hdaZ6hdbZ7dced=eefddZ8dced=e9fdeZ:dLed=efdfZ;y)ku school_service.py — multi-colegio (multitenant). Un « colegio » (school) agrupa familias, alumnos, pedidos, precios y configuración. Todo lo que antes estaba fijo en el código (nombre, fechas, precios, retención RGPD, reparto, fotógrafo…) vive ahora en `school_settings` y se edita desde el panel de admin. - `schools.id` es el slug (inmutable, ej. "sainte-marie"): se envía en la cabecera X-School y se guarda en families.school_id / orders.school_id. - El código de familia sigue siendo único globalmente (PK de families), así que el QR de la tarjeta identifica de forma inequívoca familia → colegio. - Contraseña de director: una por colegio (hash scrypt). El operador Meeconic (ADMIN_PASSWORD) administra todos los colegios. N)date)AnyOptional)config)get_db TABLE_OPTIONS) hash_password) utcnow_isozmeeconic.schoolsc eZdZy) SettingsErrorN)__name__ __module__ __qualname__2/var/www/photos/backend/services/school_service.pyr r srr school_namestrx)typedefaultmax shoot_dater)rr closure_date delivery_weekrevenue_share_pctfloat0d)rrminr partner_name portal_urlonline_paymentbooltrueonsite_paymentfalsepostal_deliveryschool_delivery rgpd_daysintimphotographer_namephotographer_id(ftp_urlnotification_emailemailqr_code_prefixprefixcolorz#0A1F443 52) brand_color shoot_modeshoot_max_per_childshoot_test_camera ai_enabledai_max_per_family SETTINGS_SPEC.iz^[^@\s]+@[^@\s]+\.[^@\s]+$ hex_colorreturnc|jdfddDDcgc] }|dz dkr|dz dz n |dz dzdz d z"}}d |d zd |d zzd|dzz}d|dzz Scc}w)z0WCAG contrast ratio between `#RRGGBB` and white.#c3BK|]}t||dzdyw)N)r-).0ihs r z&contrast_with_white..Os"!"C7 2AGeO1s7e:Ku9TY\8\ \ >C > 3q6/FSVO +fs1vo =C 3:  >s%A)keyrawct|}|d}|dnt|j}|dk(rJt|tr|rdSdS|j dvry|j dvryt |d|d k(r*|dk(ry tj|jS|d vr |d k(r t|nt|jd d}||dks||dkDrt |d|dd|dd|d k(r t|S|t|k(rtt|St|S|dk(r8|j}|r$tj d|st |d|S|dk(rPtj d|st |dt#|dkrt |d|jS|dk(r'|r#t$j!|st |d|St'||j)ddkDr!t |d|j)ddd |S#t$rt |d wxYw#t$rt |dwxYw)!Nrrr&r'r))r'1yeson)r)rnooffrz: invalid boolean value.rz#: invalid date (format YYYY-MM-DD).)r-rr-,rCz: invalid number.r!rz: must be between z and r6z ^[A-Z]{2,6}$z: 2 to 6 letters (A-Z).r7z^#[0-9a-fA-F]{6}$z: use a #RRGGBB colour.g@u<: colour too light — white text on it would be unreadable.r4z: invalid e-mail address.r$z: too long (max z).)rBrstrip isinstancer&lowerr r fromisoformat isoformat ValueErrorr-rreplaceupperrematchrU _EMAIL_RElenget)rVrWspectsnums r _normalizerpTs  D V Aks3x~~/AF{ c4  6 -g - 7792 2 7797 7se#;<==F{ 7 M%%a(224 4  ;J#a&E!))C2E,FC e d5k 13%'9$u+eDQVK=XY Z[ [:s3x[SCH_CCM[RUVYRZ[H} GGI RXXoq13%'> ?@ @G|xx,a03%'> ?@ @ q !C '3%'c de ewwyG| Y__Q'3%'@ AB B 1v$$se#3DHHUC4H3ILMM H9 M3%'J KL L M  ;3%'8 9: : ;s"I/+III3ct5}|jdt|jdt|jdddy#1swYyxYw)Naa CREATE TABLE IF NOT EXISTS schools ( id VARCHAR(64) NOT NULL PRIMARY KEY, name VARCHAR(200) NOT NULL, director_password_hash VARCHAR(255), active TINYINT NOT NULL DEFAULT 1, created_at VARCHAR(40) NOT NULL ) z CREATE TABLE IF NOT EXISTS school_settings ( school_id VARCHAR(64) NOT NULL, `key` VARCHAR(64) NOT NULL, value MEDIUMTEXT, PRIMARY KEY (school_id, `key`) ) )rexecutercommit)conns rinit_school_tablesruse T   /   /   !s AAAnamecdjdtjd|D}tjdd|j dj }|xsdddS)Nrc3RK|]}tj|dk7s|!yw)MnN) unicodedatacategory)rKrRs rrNzslugify..s$dKDXDXYZD[_cDc1ds''NFDz [^a-zA-Z0-9]+-ecoler1)joinrz normalizergsubr_ra)rvbases rslugifyrs[ 77dk33E4@d dD 66"C . 4 4S 9 ? ? AD OGSb !!rwantedc|d}}|jd|fjr.|d|}|dz }|jd|fjr.|S)NrI SELECT 1 FROM schools WHERE id=?r}r.)rrfetchone)rtrslugrLs r _unique_slugrs`a!D ,,9D7 C L L N1# Q ,,9D7 C L L N Krrdirector_passwordinitial_settingsc d|xsdj}|s td||dk7rt|dkr tdt5}|r7t |}|j d|fj r tdt|t |}|j d|||r t|ndtftjDcic] \}}||d }}}||d <|xsijD]\}}|tvs t||||< |jD]\}}|j d |||f|jdddtjd ||t!|Scc}}w#t$rYwxYw#1swY@xYw) NrThe school name is required.8The head teacher password must be at least 8 characters.rz This school code already exists.z]INSERT INTO schools (id, name, director_password_hash, active, created_at) VALUES (?,?,?,1,?)rrzBINSERT INTO school_settings (school_id, key, value) VALUES (?,?,?)zSchool created: %s (%s))r_r rjrrrrrrr r rBitemsrprsloginfo get_school) rvrrrrtkrlvaluesvs r create_schoolrs JB   D :;;$):b)@SIZE[^_E_VWW T 4=D||>HQQS#$FGGgdm4D k 4=N'89TXZdZf g 5B4G4G4IJD!T)_$JJ $}%+224 DAqM! *1a 0F1I  LLN mDAq LL]`dfgij_k l m +,HH &d3 d K %#sC BF&F-*F&F(?F&F& F# F&"F##F&&F/cT|d|dt|dt|d|ddS)Nidrvactivedirector_password_hash created_at)rrvrhas_director_passwordr)r&)rs r_rowrs;gqyD84E!%a(@&A!BRST`Ra r school_idct5}|jd|fj}dddr t|SdS#1swYxYwNz SELECT * FROM schools WHERE id=?)rrrrrrrtrs rrrO VT LL;i\ J S S UV47!T!VV "AA ct5}|jd|fj}dddr t|SdS#1swYxYwr)rrrrdictrs rget_school_with_hashrrrinclude_inactivect5}d|rdndzdz}|j|jDcgc] }t|c}cdddScc}w#1swYyxYw)NzSELECT * FROM schoolsrz WHERE active=1z ORDER BY name COLLATE NOCASE)rrrfetchallr)rrtqrs r list_schoolsrs_ =T #-=rCT UXw w!%a!9!9!; JL %& i  '& i  s CC88D ctjDcic] \}}||d c}}fd}| ||St5}||dddScc}}w#1swYSxYw)z;Ajustes del colegio fusionados con los valores por defecto.rcp|jdfD]}|dtvs|d|d|d<!y)Nz8SELECT key, value FROM school_settings WHERE school_id=?rVvalue)rrrB)rRroutrs r_loadzget_settings.._loadsHUXaWcd +Ax=(QwZ-C !' AeH  +rN)rBrr)rrtrrlrrRrs` @r get_settingsrst-:-@-@-B C'!T1d9o  CC+  d  JX  !H  J D  JsA A##A-rct|s tdi}|jD]*\}}|tvrtd|t ||||<,d|vr|ds tdt 5}|jD]\}}|j d|||fd|vr|j d|d|f|jdddt|S#1swYt|SxYw)uIValida y guarda. Claves desconocidas → error (nada se guarda a medias).rzUnknown setting: rrrrN) rr rrBrprrrrsr)rrcleanrrrts rupdate_settingsrs  i /00E $1 M !"3A3 78 8a#a$eM&::;; TKKM ,DAq LLh#Q* , , E ! LL?% BVXaAb c   ""  ""s 4AC  C3settingscftDcic]}|tddt||c}Scc}w)uKMismas claves que el antiguo PRICING (print_10x15, digital, magic_pack…).price_N) PRICE_KEYSrjr)rrs rpricing_from_settingsr%s/;E FaAc(mn uXa[1 1 FF Fs".price_print_10x15price_print_20x30 price_digital price_packprice_magic_printprice_magic_digitalprice_magic_pack)z print-10x15z print-20x30digitalpack magic-print magic-digital magic-pack>rrrr>rrrcodect5}|jd|fj}dddr|dSdS#1swYxYw)Nz+SELECT school_id FROM families WHERE code=?r)rrrr)rrtrs rschool_id_for_familyr9sO \T LLF P Y Y [\1[>(D(\\s ">Act|}|r tt|dStj S#t$rYtj SwxYw)Nr,)rr-r ExceptionrPHOTO_RETENTION_DAYS)rsids rretention_days_for_familyr?sW t $C  |C(56 6  & &&    & && s6 AAcddlm}t|}t|j dd}|xs||r|dndS)uWPrefijo de los códigos de familia: el configurado, o las 3 primeras letras del nombre.r)prefix_from_namer5rrv)utils.code_generatorrrrrk)rrschool configureds rcode_prefix_forrIs@5  "Fi(,,-=rBJ  K)F&.KKr)rEN)NNN)T)N)<__doc__loggingrgrzdatetimertypingrrcorercore.dbrr core.securityr core.timeutilr getLoggerrrdr rrrBr__annotations__DEFAULT_PRICESr_k_vrstriplistkeysrcompilerirrUrprurrrrrrr&rrrrrFORMAT_PRICE_KEYDIGITAL_FORMATS MAGIC_FORMATSrr-rrrrrrsu  )'$g*+ J ,%b#F,&b9,&b9,&b9 , 'c!CP , %b#F ,%b#F,&f=,&g>,&g>,&f=,%c&:U:U6V_`ilm,%b#F,%b"E,%b#F, 7r:!,$(r:%,(#*i@%+w?$)sAbQ%+w?"(f="'c!BO;, tCc3h'(>##))+0FB!(X[_bce_fXfSW^^C5H5O5OPS5Tloprls !$0M"0&'',,. / BJJ4 5 35- C- c- c- d,"#"#" ss]a598C=HUXM$,TN>BBt"#"(4." "C"HTN" =4=4:= <@Z^59!S!8C=!RV!%-c]!>B!8 C tCH~  #s#D#T#s(^#*GDGT#u*-=G)($!(*'E> )s)x}) 'C'C'LsLsLr