&6j<SrSSKJr SSKJr SSKJrJrJrJrJ r SSK J r J r J r Jr SSKJr SSKJrJrJrJrJr SSKJr S S jr"S S 5rg )u KPI de asignaciones de documentos a especialistas: conteos por curso y por profesional. Filtro temporal: mes/año calendario sobre `added_date` de professional_document_assignments. - asignados: filas con added_date en el rango - cargados: mismas filas con status_id == 1 ) annotationsdatetime)AnyDictListOptionalTuple)and_casefuncliteral)Session) CourseModel DocumentModelDocumentTypeModel#ProfessionalDocumentAssignmentModel SchoolModel)#map_professional_id_to_display_namec[XSSSS5nUS:Xa[US-SSSSS5nX#4$[XS-SSSS5nX#4$)z>Rango [start, end) sobre added_date (mes calendario completo).r r)yearmonthstartend_excls dC:\Users\jesus\Desktop\proyecto_pie360\backend\app\backend\classes\kpi_document_assignments_class.py _month_boundsrs] T!Q1 -E {D1HaAq!4 ?D!)Q1a8 ?c\rSrSrS SjrSSS.S SjjrSS.S SjjrSS.SSjjrSS.SS jjrS r g)KpiDocumentAssignmentsClass#cXlg)Ndb)selfr%s r__init__$KpiDocumentAssignmentsClass.__init__$srN)professional_id_filterschool_id_filterc 0[U5n[U5nUS:dUS:aSS/S.$[Xg5up[R"[ [ R S:HS4SS95RS5n [ RRS5[ RU:[ RU :/n Ub+U R[ R[U5:H5 Ub,U RS[ R[U5:H5 URR[ R RS 5[R""[ R$5RS 5U 5R&"U 6n UbyU R)[*[-[*R$[ R :H[*R.S:H55R'[*R0[U5:H5n U R3[ R 5n U R55nUVs/sH&oR cM[UR 5PM( nn0nU(aURR[*5R'[*R$R7U5[*R.S:H5R55HRnUR8=(d S R;5=(d S UR$3U[UR$5'MT /nUHn[UR 5n[UR<=(d S5n[UR>=(d S5nUS:a[AS U-U- S5OSnURUURCUS U35UUUS.5 M URESS9 SUS.$s snf![FanS[IU5/S.sSnA$SnAff=f)Nrrerror Mes inválidostatusmessagedatarelse_loaded course_idassignedzCurso #Y@)r5 course_namer6r4 rate_percentc(USR5$)Nr:lowerxs r7KpiDocumentAssignmentsClass.by_course..r1]#3#9#9#;rkeysuccessr/r1)%intrr sumr r status_idlabel added_dateisnotappendprofessional_idinsert period_yearr%queryr5countidfilterjoinrr deleted_status_id school_idgroup_byallin_r:stripr6r4roundgetsort Exceptionstr)r&rQrrr)r*ymrr loaded_exprfiltersbase_qqrowsr course_idsnamescoutcidr6r4pctes r by_course%KpiDocumentAssignmentsClass.by_course'smE FD AE A1uB")orRR+A1OE((9CCqH!LTUVeHo  4>>DDTJ3>>%G3>>IG &17GG3OeKff&q"E"Q"QUXYdUe"efWW]]3==CCKP >AABHHTf  F  +#*M*W*WW#55: &..#6F2GGH  C M MNA557D48TDqKK*#akk*DJT$&EGGMM+.VKNN..z:KAgrega asignaciones por establecimiento (school_id del curso).rrr,r-r.rr2r4NrXr6r7z Colegio #r8r9zSin establecimiento)rX school_namer6r4r;c(USR5$)Nrtr=r?s rrA7KpiDocumentAssignmentsClass.by_school..rCrrDrFrG)'rHrr rIr rrJrKrLrMrNrOrPrQr%rRrrXrSrT select_fromrVr r5rWrUrYrZrr[rtr\r6r4r]r^r_r`ra)r&rQrrr)rbrcrrrdrergrh school_idsrisidrksrmsid_rawr6r4rorKrps r by_school%KpiDocumentAssignmentsClass.by_schoolws[H FD AE A1uB")orRR+A1OE((9CCqH!LTUVeHo  4>>DDTJ3>>%G3>>IG &17GG3OeKff&q"E"Q"QUXYdUe"ef ))// <JJBEEFLLZX @A#*M*W*WW#55: ! "+//0 $557DJkk?%%c#h/%'E{3::;>>;M;Mj;YZ^^`A() (;'B'B'D'Z)TUTXTXSYHZE#add)$a)+C++&-&9c'lqqzzQ/QXX]+=E\eEFNX5q9s=@1W #3%'89J_ %(',$,"((+  HH;H <'5 5 F%#a&"E E Fs*'OHO6FO O5O0*O50O5c [U5n[U5n[U5nUS:dUS:aSS/S.$[Xx5up[R"[ [ R S:HS4SS95RS5n [ RU:H[ RRS5[ RU :[ RU :/n Ub+U R[ R[U5:H5 Ub,U RS[ R[U5:H5 URR![ RRS 5[R""[ R$5RS 5U 5R&"U 6R)[ R5n U R+5nUVs/sH&oRcM[UR5PM( nnU(a[-URU5O0n/nUHn[UR5n[UR.=(d S5n[UR0=(d S5nUS:a[3S U-U- S5OS nURUUR5US U35UUUS.5 M UR7SS9 SUS.$s snf![8anS[;U5/S.sSnA$SnAff=f)Nrrr,r-r.rr2r4rOr6r8r9z Profesional #)rOprofessional_namer6r4r;c(USR5$)Nrr=r?s rrA=KpiDocumentAssignmentsClass.by_professional.. s1%8#9#?#?#ArrDrFrG)rHrr rIr rrJrKr5rLrMrNrOrPrQr%rRrSrTrUrYrZrr6r4r]r^r_r`ra)r&rQr5rrr)rnrbrcrrrdrergrhripids prof_namesrmpidr6r4rorps rby_professional+KpiDocumentAssignmentsClass.by_professionals9 Fi.CD AE A1uB")orRR+A1OE((9CCqH!LTUVeHo  4==D3>>DDTJ3>>%G3>>I G &17GG3OeKff&q"E"Q"QUXYdUe"ef 7GGMMN_`JJBEEFLLZX   ! " =MMN 557D48ZDqL L c l [U5n[U5n[U5nUS:dUS:aSS/S.$[Xx5up[[RS:[R4[ S5S9n [[RS:[ S54[R S9n [R"[[RS:HS4SS95RS5n [RU:H[RRS 5[RU :[RU :/nUb+UR[R[U5:H5 Ub,UR!S[R"[U5:H5 UR$R'U RS 5U RS 5[R("[R*5RS 5U 5R,"U6R/X5nUR15n[3UVs1sHEn[UR4=(d S5S:dM'[UR4=(d S5iMG sn5n[3UVs1sHin[UR4=(d S5S:XdM'[UR6=(d S5S:dMK[UR6=(d S5iMk sn5n0nU(aUR$R'[85R-[8R*R;U55R15HRnUR<=(d S R?5=(d SUR*3U[UR*5'MT 0nU(aUR$R'[@5R-[@R*R;U55R15HRnUR<=(d S R?5=(d SUR*3U[UR*5'MT /nUHn[UR4=(d S5n[UR6=(d S5n[URB=(d S5n[URD=(d S5nUS:a[GSU-U- S5OSnUS:aURIUSU35nOUS:aURIUSU35nOSnURUUUUUUS.5 M URKSS9 SUS.$s snfs snf![LanS[OU5/S.sS nA$S nAff=f)u Por tipo de documento (catálogo `documents` o `document_types` si no hay catálogo). Agrupa por document_catalog_id cuando es > 0; si no, por document_type_id. rrr,r-r.rr2r4Nbucket_catalog_idbucket_type_idr6r7z Documento #zTipo #r8r9zTipo de documento #uDocumento (sin catálogo))document_catalog_iddocument_type_id document_namer6r4r;c(USR5$)Nrr=r?s rrA9KpiDocumentAssignmentsClass.by_document..s1_#5#;#;#=rrDrFrG)(rHrr rrrrr rIrJrKr5rLrMrNrOrPrQr%rRrSrTrUrYrZlistrrrr[documentr\rr6r4r]r^r_r`ra) r&rQr5rrr)rnrbrcrrbucket_catalog bucket_typerdrergrhri catalog_idstype_ids doc_namesd type_namestrmbcbtr6r4rodnamerps r by_document'KpiDocumentAssignmentsClass.by_documentsj Fi.CD AE A1uB")orRR+A1OE"7KKaO7KKaj N4HH1LgVWjY9JJK ((9CCqH!LTUVeHo  4==D3>>DDTJ3>>%G3>>I G &17GG123&7CCs;GWW  "(()<=%%&67JJBEEFLLZX    ! ".6 557D8<b1ADWDWD\[\@]`a@a.Q((-A.bK"!1..3!49/>A!BRBRBWVW>X[\>\/C((-A.!H)+IGGMM-077 8H8H8L8L[8YZ^^`-.JJ,<"+C+C+E+];WXW[W[V\I]Ic!$$i(a*,JGGMM"34;;'5 5cc^ F%#a&"E E FsT2VH V?&V)"V V&V  V )"V  I:V V V3V.(V3.V3r$)r%r) rQ Optional[int]rrHrrHr)rr*rreturnDict[str, Any]) rQrrrHrrHr)rrr) rQrr5rHrrHrrHr)rrr) __name__ __module__ __qualname____firstlineno__r'rqr|rr__static_attributes__rrr!r!#sX15*.NF#NF NF  NF !. NF(NF NFl15 QF#QF QF  QF !. QF QFt15BF#BF BF  BF  BF!.BF BFV15wF#wF wF  wF  wF!.wF wFwFrr!N)rrHrrHrzTuple[datetime, datetime])__doc__ __future__rrtypingrrrr r sqlalchemyr r r rsqlalchemy.ormrapp.backend.db.modelsrrrrr&app.backend.utils.professional_displayrrr!rrrrsD #3300"WbFbFr