ixUdZddlmZddlZddlZddlZddlZddlZddlm Z ddl m Z m Z m Z mZmZgdZded<gd Zded <d Zd Zd0d Zd1dZd2dZd3dZd4dZd5dZd6dZd7dZd7dZd7dZd8dZd9dZ d:dZ!d;dZ"e GddZ#ddZ&d?d Z'd@dAd!Z(dBdCd"Z)dDdEd#Z*d$d%d$d& dFd'Z+dGd(Z,d)d* dHd+Z-dId,Z.dJd-Z/efdKd.Z0efdLd/Z1y)Mu Evaluación psicopedagógica (doc 27): matriz cuantitativa tipo EVALÚA (PD/X/DT/E.T.M/PT × RE..RP) e índices generales (IGC–IGM). Parseo flexible del JSON en BD y gráfico PT en PNG (Pillow). ) annotationsN) dataclass)AnyDictListOptionalTuple) REPAOPMACLPPMEFORGROFCNRPz List[str] INDICATORSIGCIGLIGEIGMGENERAL_LABELSz[[PSYCHOPED_PT_CHART]]uc0|yt|tryt|ttfr t|St |j j dd}|dk(s|jdvry t|S#ttf$rYywxYw)N,.)nullnonezn/ana-) isinstanceboolintfloatstrstripreplacelower ValueError TypeError)rawtxts [/var/www/pie360backend.cl/public_html/app/backend/utils/psychoped_cognitive_quantitative.py _safe_floatr2s {#t#U|$Sz c(..  " "3 ,C byCIIK#EESz  "s8 BBBc|yt|ttfr|St|j }|sy t j |}t|trH|j }|jds|jdr t j |S|S#t j$r|cYSwxYw#t j$rYywxYw)N{[) r%dictlistr)r*jsonloads startswithJSONDecodeError)r/svs2s r1_loads_json_flexr?)s {#d|$  CA   JJqM a B}}S!R]]3%7::b>)++H   s6ACB(&C(C=C?CCCCc|xsdjj}djdtjd|D}t j dd|}|S)Nr c3RK|]}tj|dk7s|!yw)MnN) unicodedatacategory).0cs r1 z_norm_key..As$_a{?S?STU?VZ^?^_s''NFKDz [^a-z0-9]+)r*r,joinrC normalizeresub)r<ts r1 _norm_keyrN?sS b!A _;00;__A }b!$A Hc t|tr|sy|jDcic]\}}tt ||}}}|D]}t|}||vs||cSycc}}wN)r%r6itemsrNr))m candidateskr=norm_maprFnks r1_get_from_mappingrXFso a a12;A #a&!1$;H;   q\ >B<    . BcBq}B}B)rzr%r7r6r)r*rrrrtrXr2anyvalues) rrarritemrrFrrrr=s r1_parse_tests_arrayrs .. ! [Z^^I%> [*..QZB[C c4 $%  HHV  "xx! "xx "xx & "xx  " xx!  <  IOO  # # % J  q!0 B2ws|'%b) ',}DHHUO:KDRW:X=#.q>CGCL   #2 B B BBrOc |jd}t|tsyd}dD]}t|D]}|j|}|d}t|trAt t dt|D]}||| t|||||<!nit|trYttD]G\}}|||tt|||j|j|||<I|S)NrowsFrvTrw)rzr%r6rtr7r{r|r}r2r~rrXr,r) rrrows_objany_hitrrnestedrrs r1_parse_rows_containerrs~~f%H h %G,!"% E\\%(F~G&$'s2s6{34#r)R4Z : xx!aTXXi%8aDHHV.s2o182os)rrrFrvquant__rh quant_E_T_M_z quant_E.T.M_TrwrnrZr^rdg-q=c32K|]}|D]}|du ywrQrrrs r1rGz$_normalize_matrix..6rrc32K|]}|D]}|du ywrQrrrs r1rGz$_normalize_matrix..8rrc32K|]}|D]}|du ywrQrrrs r1rGz$_normalize_matrix..:rr)rxr?r%r7rr6rzrr_normalize_matrixr~r,rXr2r{absrrrrr) matrix_rawrinnerflat_hitrrr key_variantsvalrUrpdvxvdtvrs @r1rrsn -C : &C { #t c* c4  GGH  `!2 `cggn6M `QTQXQXY_Q`E%$&s2oZRnEn2o/o '' #t + $FAs4 $RD#'RXXZL#))+7RD#))+/RXXZL#/   ; &se,&syy{m4&se,&syy{m4 %L %ACx!ggaj;+C?,?C %>!#CGAJ#H1 $ $4 2Y 8t9Q<'#&t9Q<S!c$ilSC2>coRUVYRZ]bRb(+bC'7D !  8 J,*BS)* B B Bc3' B B BsC( B B B3$2Y0 t9Q< t9Q<S!c$ilSC2>co#c(UZJZ #bC/D ! 0 JrOc ~tDcic]}|d}}t|}||St|tr|D]}t|ts|j dxs7|j dxs$|j dxs|j d}|j dxs7|j dxs$|j dxs|j d}|t |jj}||vst|||<|St|trtD]~}|j |xs-|j |jxs t||}t|trtt|dd dd dd||<qt|||<|S|Scc}w) Nkeyclaverrvaluevalorrorprnrq) rr?r%r7r6rzr)r*rr2r,rX) r/rUrrrr=kklabrs r1_parse_general_rawrGs8F&G1q$w&GC&G 3 C { #t )DdD)]488G#4]8H]DHHU\L]A!iTXXg%6i$((4.iDHHUhLiAyQ%%'BSy%a.B ) #t! -C773<V377399;#7V;LSRU;VD$%&%dD$8KMbdkmtuC't,C - J5'Hs F:cdd}ddddd}t|}|jD](\}\}}|j|||||||<*|S)Ncv|Dcgc]}|t|}}|syt|t|z Scc}wrQ)r(sumr})rr=xss r1_meanz$_fill_general_from_pt.._meanfs; $ 61 eAh 6 62wR  7s6 6)r)r)r )rrwr)rList[Optional[float]]returnOptional[float])r6rRrz)rogenrslicesrrabs r1_fill_general_from_ptresl! F s)C||~& Va 773< R!W~CH& JrOc:eZdZUded<ded<d dZd dZd dZy) CognitiveQuantitativeParsed Dict[str, List[Optional[float]]]rDict[str, Optional[float]]generalcVtd|jjDS)Nc32K|]}|D]}|du ywrQrrrs r1rGzACognitiveQuantitativeParsed.has_matrix_numbers..s LSL11D=L=Lr)rrrselfs r1has_matrix_numbersz.CognitiveQuantitativeParsed.has_matrix_numbers~s LDII,<,<,>LLLrOctd|jdDxs*td|jjDS)Nc3$K|]}|du ywrQrrrEr=s r1rGz@CognitiveQuantitativeParsed.has_chart_numbers..s:Q1D=:rnc3$K|]}|du ywrQrrrs r1rGz@CognitiveQuantitativeParsed.has_chart_numbers..sB ATMB r)rrrrrs r1has_chart_numbersz-CognitiveQuantitativeParsed.has_chart_numberssE:$))D/:: cB #'<<#6#6#8B ?  rOctd|jjDrydD]#}td|j|Ds#yy)Nc3$K|]}|du ywrQrrrs r1rGz@CognitiveQuantitativeParsed.has_table_numbers..s<q}.s8Q1D=8rF)rrrr)rrs r1has_table_numbersz-CognitiveQuantitativeParsed.has_table_numberssM .s2[Q1D=2[r) r%r6rrzrrrrrr) eval_datarrparseds r1parse_evalua_psychoped_matricesrs{ i & Y]]+JK LD /I!JKG#DJ8G (dG DF  $ $ &s2['..JZ2[/[ MrOc&|yt|}tj|rEt|t |z dkr+t|dkrt t t |S|d}d|vr |jdjd}|S)Nr$& .>g.Az.2fr0)r(mathisfiniterroundr)r'rstrip)r=rr<s r1_fmt_table_cellrs}y qB }}RSeBi047CGcM3uRy>"" c(A ax HHSM  % HrOcg}|jd|jddjtzdD]@\}}djdj|D}|j|d|B|jd|jddjfd tDz|jd|jd d j|j S) Nz.sG!?1-Gr: r zESCALAS GENERALES: c3pK|]-}|dtjj|/yw)rN)rrrz)rErUrs r1rGz:build_cognitive_quantitative_table_text..s1^!s"_V^^-?-?-BCDE^s36uNGráfico: Puntuación típica (PT) — pruebas e índices generales (EVALÚA). )appendrIrrrr*)rlinesrrrs` r1'build_cognitive_quantitative_table_textrsE LLOP LLuzz*556* E Gv{{2GG wb()* LL LL **^~^ ^ _ LL LLab 99U  ! ! ##rOc ddlm}|xsdjj }|j |dD]v}|j |d}||j |d}|7|j|dxsdjj }||k(st|cSy#t$rYywxYw) uNBusca el primer w:sdt cuyo w:tag @w:val coincide (sin distinguir mayúsculas).rqnNr zw:sdtzw:sdtPrzw:tagw:val) docx.oxml.nsr ImportErrorr*r,iterfindrz)root_eltagrwantsdtsdt_prtag_elrs r1_find_sdt_element_by_tagr+s# I2    $ $ &D||BwK( "Y-( > R[) > zz"W+&,"335;;= $;J   sB;; CCc(ddlm}ddlm}|j}|j }||d}|j d|t|j|dD]}|j||d}dD]~}|d|}|j|dd |j|d d |j|d d |j|d||j||j|y)Nr OxmlElementrw:tblPrz w:tblBorders)topleftbottomrightinsideHinsideVzw:r singlezw:sz8zw:spacer zw:color) docx.oxmlr.r!r_tbltblPrinsertr7findallremovesetr) table color_hexr.rtbltbl_prelbordersedges r1_set_table_bordersrFs% **C YYF ~Y' 1f6>>"^"456 b.)GH 2dV % r'{H% r&z3 r)}c" r)}i(r  MM'rOcddlm}ddlm}|j}|j }||d}|j d|t|j|dD]}|j||d}|j|dt||j|dd|j|y) Nrr-rr/zw:tblWzw:wzw:typepct) r8r.r!rr9r:r;r7r<r=r>r)r)r?rHr.rrArBrCtws r1_tbl_set_pct_widthrJs% **C YYF ~Y' 1f6>>"X,/0 b X BFF2e9c#hFF2h< MM"rOcNddlm}ddlm}|jj }t |j|dD]}|j||d}|j|d||j|dd|j|y)Nrr-rzw:shdzw:fillr clear) r8r.r!r_tcget_or_add_tcPrr7r<r=r>r)cellfill_hexr.rtc_prrCshds r1_set_cell_shadingrSs% HH $ $ &E5==G-. R g CGGBxL(#GGBwK! LLrOF boldsize_pt align_centercddlm}ddlm}|jD]D}|r|j |_|jD] }||_|||j_ "Fy)NrWD_ALIGN_PARAGRAPHPt) docx.enum.textr[ docx.sharedr] paragraphsCENTER alignmentrunsrVfontsize)rOrVrWrXr[r]pararuns r1_style_cell_textrhsV2( /66DN99 (CCHwKCHHM ((rOc |r|jsy ddlm}ddlm}ddlm}ddlm}ddl m }||}t|jjd}|y|j|d } | yt!| D]} | j#| d } d } |j%| | } | j&}|j)}||j#|| j+|t-| d t/| dd}d}d}d}d}ddddd}| j0dj2}d|d_|dj7|dd|d_|j8|dj:d_t?|dd|d|dj7|dd|d_|j8|dj:d_t?|dd|dtA|dtA|d| j0dj2}d|d_tCtDD]\\}}||d|z_|j8|d|zj:d_t?|d|zd|dtA|d|z^tCtFD]L\}}|d|z}||_|j8|j:d_t?|d|dtA|Ngd }tC|d!"D]1\}\}} | j0|j2}!| |!d_t?|!dd|#tIdD]`}tK|j0|||!d|z_|j8|!d|zj:d_t?|!d|z|d$b|d%k(stCtFD]n\}}|!d|z}tK|jLjO||_|j8|j:d_t?||d$tA|d&p4tCtFD]\}}| jQd!d|z}"| jQd'd|z}#|"j7|#|jR|"_*tA|"d&d|"_|"j:d}$|j8|$_|$jW||}%d|%_,|||%jZ_.|"j_}&|j8|&_|&jWd(}'|||'jZ_.|ja|y#t$rYywxYw))u Sustituye el contenido del control de contenido `ac` por una tabla Word nativa (12 pruebas + 4 índices), estilo similar a EVALÚA (cabeceras y bordes azules). FrDocument)WD_CELL_VERTICAL_ALIGNMENTrZrr\ac w:sdtContentr)rcols4F81BDg @g@g@zRE, PA, OP, MAz CL, PPM, EFz OR, GR, OFzCN, RPrr rwPRUEBASTrU zESCALAS GENERALES*)rrr)rhrjr)start)rVrW)rWrXE7EDF7r$)1rdocxrkdocx.enum.tablerlr^r[r!rr_r]r"r+elementbodyr$r7r= add_tabler9 getparentrrJrFrrtextmergerar`rbrhrSr~rrr{rrrzrOTOPvertical_alignmentadd_runrVrdre add_paragraphsave)( docx_pathrrkrlr[rr]docr( sdt_contentchildn_rowsn_colsr?tbl_elparentsz_bandsz_headsz_labelsz_valsz_comp comp_textr0r1rrjrrFrow_defsr_idxrrrr0r2p0run_compp_dashrrs( r1inject_evalua_matrix_word_tablers+ 113!>5#" 9 C "3;;#3#3T :C {((2n-.Kk""5!"F F MMvFM 3E ZZF    F  fvud#uh'GGH FG  I A  BBqEJqEKK2BqEJ$6$=$=BqEQ!RUwTJrFLLB&BrFK%7%>%>BrFa"RV$dKbebf A  BBqEJZ(%41q5 ,>,E,E1q5 Q)AEwTR"QU)$ % N+3 rAvJ$6$=$= Q!wTJ! 'H(:/{Ejj%%A QdH=r LA-fkk"oa.@ACAJO1C1J1JCAJ ! !! $ . SQZd K L A:#N3 /3QK(););C)@A,>,E,E Q) FF!!X.  // N+"3jjBF#ArAv& &!;!?!?#x( ^^A )00 ::in- [ ""$-44 ^^C &z ""HHY _ sU U&%U&@) width_inchescj|rtjj|sy ddlm}ddlm}ddlm}ddl m }ddl m }ddl m} ||} t!| j"j$|} | y| j'|d } | yt)| D]} | j+| |d }| j-|| || j.}|j0|_|j5}|j7||| | j9|y #t$rYywxYw) u Vacía el primer SDT con w:tag @w:val == `tag` e inserta una imagen centrada. Sustituye la tabla EVALÚA generada en el control `ac` del doc 27 cuando el usuario sube una captura en lugar de usar la matriz en el Word. FrrjrZr-rInches Paragraphrnw:pwidthT)ospathisfiler|rkr^r[r8r.r!rr_rdocx.text.paragraphrr"r+r~rr$r7r=r_bodyrarbr add_picturer)rr& image_pathrrkr[r.rrrrr(rrnew_p paragraphrgs r1(inject_image_into_content_control_by_tagrs RWW^^J7!5)#&1 9 C "3;;#3#3S 9C {((2n-.Kk""5!"  Eu%+I,33I    COOJf\&:O;HHY + s$D&& D21D2cj|\}}|||z f||z|f|||zf||z |fg}|j|||y)N)outlinefill)polygon)drawxyrrr_yptss r1_diamondrsK DAq q1u:AqzAq1u:Aqz :CLLdL.rOc0 89|jsy ddlm}m}m}d\}}|j d||fd}|j|}tjjtjjddd d } |j| d } |j| d } |j| d } d} |j!d| d| dd|dz |dz f\}9}}||z |9z c}8d=89fd }d}|dkr9d|z dz 8zz}|j#||f||fgddt%|t'|z dkrt)t+|n|dj-dd }|j!|dz |d!z f|d"| |d#z }|dkr|j#|9f||f||f|9fgd$d|d%z}|d&z}|d'z}t/d(Dcgc] }|||d)z zz}}||z|d*z z}|j#|9f||fgd+d,t/d-Dcgc]}||d*z z||dz zz}}||z}t1|j2d.t4Dcgc]}|j6j|c}z} t8t4z}!d/}"t/t;| dz D]H}| || |dz}$}#||#||$}&}%|%#|&&|j#|||%f||dz|&fg|"d0Jt=| D]#\}}'||'}(|(t?||||(fd1|"%|d!z})d}*|!D]+}+|jAd2|+| 3},tC|*|,d0|,dz }*-t=|!D]D\}}+|jAd2|+| 3}-|-d,|-dz }.|j!|||.d,z z |)f|+d4| Fd5}/d6}0|jAd2|0| 3}1|1d,|1dz }2|)|*z|/z}3|j!||z|2z d,z |3f|0d7| d8}4|jAd2|4| 3}5|5d,|5dz }6|3|1d0|1dz zd9z}7|j!||z|6z d,z |7f|4|"| |jE|d:;y<#t $rYywxYw#t$r|j} | } | } YwxYwcc}wcc}wcc}w)>NFr)Image ImageDraw ImageFont)iiRGB)rrWINDIRz C:\WindowsFontsz arial.ttfrvu<Análisis cuantitativo — PT (pruebas e índices generales))P)rrr)rrdXHc |tjt|sytdt dt|}d|z dz zzS)N@r)r r r(maxr|)rvcplot_hy0s r1vyz+render_evalua_pt_line_chart_png..vysJ ;dmmE#J7 s3c + ,S2X$v---rOrg5^I @rr)rs)rrr z.1frrr)<rrg?)(rrg ףp= ?gGz?g)\(?rwg&@g@)rwrrn)rfr)rr)rd)rr Puntuaciones)2rruPuntuación típica (PT)PNG)formatT)rrrr)#rPILrrrr"newDrawrrrIenvironrztruetypeOSError load_defaultrlinerrr)r'r+r{r7rrrrr}r~rtextbboxrr):r out_png_pathrrrWHimgr font_pathrd font_title font_smalltitlex0x1y1plot_wrgyyyrMgap w_tests_span w_gen_spanrxs_testsdividerrxs_genrrUrlabelsbluev0v1y_ay_br=ypy_catcat_hrlb0lblwgap_below_categories axis_titletbrI y_axis_titleleglb2lw2y_legrrs: @@r1render_evalua_pt_line_chart_pngrsk  # # %33 DAq ))EAq6? 3C >># D RZZ^^HmDg{[I!!)R0'' 26 '' 26 KEIIhLzIBQVQW,NBB"Wb2gNFF. B + 38s"V+ + B8b"X&_A FU2Y/$6CBLr#h5)3\ MN J vz  ;B AAB5=#77LIIR" !<0*._replace_in_paragraph_element..=D! " Dw:tg@rT)rIr#rrLrr) p_elfullprrrrmarkerpng_pathrreplaceds r1_replace_in_paragraph_elementzOinsert_chart_placeholder_paragraph_image.._replace_in_paragraph_element;slwwDtyyE/CDD    dCII &  IIK hfSk 2rOrr#rrNone)rrrr|rkr!rrrr_rr"r~rr#tablesrrr`_elementr)rr' placeholderrkr)r#rArrOrfrrrr&rr(s ` @@@@@@r1(insert_chart_placeholder_paragraph_imager/,s% 77>>( #!#1& 9 C FH     %%bi0%d+   :: Cxx IID $"5dmmD#!"      OS sD DDc ddlm}ddlm ddlm || d d  fd } jjj dD] }||  jD]G}|jD]6}|jD]%}|jD]}||j'8I r j|yy#t $rYywxYw) NrrjrrFc.djd|jdD}|vry|j}|jj dj }|j |r|j|dy)Nr c3<K|]}|jxsdywrrrs r1rGzIstrip_chart_placeholder_from_docx.._strip_p_el..mr r!r"T)rIr#rrr+r*rLr) r#r$r%r0rchangedrr.rs r1 _strip_p_elz6strip_chart_placeholder_from_docx.._strip_p_elksxwwDtyyE/CDD d "  dCII &ffnn["-335   IIcNrOrr*)r|rkr!rrrr"r~rr#r,rrr`r-r) rr.rkr4r#rArrOrfrr3rrs ` @@@@r1!strip_chart_placeholder_from_docxr5`s!#1 9 CG     %%bi0Dzz/88 /C  / OO/D ./ / //  3 sC CC)r/rrr)r/rrr)r<r)rr))rSDict[str, Any]rTr)rr)rsr)rzTuple[str, ...])rr)rr)rr6rrrr+)rr6rrrr&)rz List[Any]rrrr&)rrrr)r/rrr)rorrrrr)rr6rz%Optional[CognitiveQuantitativeParsed])r=rrr))rrrr))r%rr&r)rz Optional[Any])rr)r?rr@r)rr+)rq)r?rrHr'rr+)D9E2F3)rOrrPr)rr+) rOrrVr&rWr(rXr&rr+)rr)rrrr&) rr)r&r)rr)rr(rr&) rrrzTuple[float, float]rr(rzTuple[int, int, int]rr+)rrrr)rr&)rr)r'r)r.r)rr&)rr)r.r)rr+)2__doc__ __future__rr8r rrKrC dataclassesrtypingrrrrr rrrCHART_PLACEHOLDERAC_CONTENT_CONTROL_HOLDr2r?rNrXrtrxrrrrrrrrrrrrr+rFrJrSrhrrrrr/r5rrrOr1r>sx# !33a Ia8 8-#  ,  D,&C@24nHV<(  *   $.(,"   ( ( ( (  (  ($|H ** **  *  *Z/ _D`q1hJ[rO