Si<dZddlmZddlmZddlmZmZmZmZm Z ddl m Z m Z m Z mZddlmZddlmZmZmZmZmZddlmZd d ZGd d Zy )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_namect||dddd}|dk(rt|dzddddd}||fSt||dzdddd}||fS)z>Rango [start, end) sobre added_date (mes calendario completo).r r)yearmonthstartend_excls [/var/www/pie360backend.cl/public_html/app/backend/classes/kpi_document_assignments_class.py _month_boundsrse T5!Q1 -E {D1HaAq!4 (?D%!)Q1a8 (?ceZdZd dZddd d dZdd d dZdd d dZdd d dZy) KpiDocumentAssignmentsClassc||_y)N)db)selfr#s r__init__z$KpiDocumentAssignmentsClass.__init__$s rN)professional_id_filterschool_id_filterc  t|}t|}|dks|dkDrddgdSt||\}} tjt t j dk(dfdjd} t jjdt j|k\t j| kg} |+| jt jt|k(|,| jdt jt|k(|jjt j jd tj"t j$jd | j&| } |y| j)t*t-t*j$t j k(t*j.dk(j't*j0t|k(} | j3t j } | j5}|Dcgc]$}|j t|j &}}i}|r|jjt*j't*j$j7|t*j.dk(j5D]G}|j8xsd j;xsd |j$|t|j$<Ig}|D]}t|j }t|j<xsd}t|j>xsd}|dkDrtAd |z|z dnd}|j||jC|d ||||d|jEdd|dScc}w#tF$r}dtI|gdcYd}~Sd}~wwxYw)Nrrerror Mes inválidostatusmessagedatarelse_loaded course_idassignedzCurso #Y@)r2 course_namer3r1 rate_percentc(|djS)Nr7lowerxs rz7KpiDocumentAssignmentsClass.by_course..r1]#3#9#9#;rkeysuccessr,r.)%intrr sumr r status_idlabel added_dateisnotappendprofessional_idinsert period_yearr#queryr2countidfilterjoinrr deleted_status_id school_idgroup_byallin_r7stripr3r1roundgetsort Exceptionstr)r$rMrrr&r'ymrr loaded_exprfiltersbase_qqrowsr course_idsnamescoutcidr3r1pctes r by_coursez%KpiDocumentAssignmentsClass.by_course'srE FD AE A1uB")orRR+Aq1OE8((9CCqH!LTUVeHo  4>>DDTJ3>>%G3>>IG &17GG3OeKff&q"E"Q"QUXYdUe"efTWW]]3==CCKP >AABHHTfg F  +#*M*W*WW#55: &..#6F2GGH  C M MNA557D48TqAKKAgrega asignaciones por establecimiento (school_id del curso).rrr)r*r+rr/r1NrTr3r4z Colegio #r5r6zSin establecimiento)rT school_namer3r1r8c(|djS)Nror:r<s rr>z7KpiDocumentAssignmentsClass.by_school..r?rr@rBrC)'rDrr rEr rrFrGrHrIrJrKrLrMr#rNrrTrOrP select_fromrRr r2rSrQrUrVrrWrorXr3r1rYrZr[r\r])r$rMrrr&r^r_rrr`rarcrd school_idsresidrgsrisid_rawr3r1rkrGrls r by_schoolz%KpiDocumentAssignmentsClass.by_schoolwsiH FD AE A1uB")orRR+Aq1OE8((9CCqH!LTUVeHo  4>>DDTJ3>>%G3>>IG &17GG3OeKff&q"E"Q"QUXYdUe"ef  ))// <JJBEEFLLZX @A#*M*W*WW#55: "+//0 $557DJ 0kk?%%c#h/ 0%'E{3::;>>;M;Mj;YZ^^`[A() (;'B'B'D'Z)TUTXTXSYHZE#add)$[)+C ++&-&9c'lqqzzQ/QXX]+=E\eEFNX5q9s=@1W #3%'89J_ %(',$,"((+   HH;H <'5 5 F%#a&"E E Fs*%N0H N03Ez=KpiDocumentAssignmentsClass.by_professional.. s1%8#9#?#?#Arr@rBrC)rDrr rEr rrFrGr2rHrIrJrKrLrMr#rNrOrPrQrUrVrr3r1rYrZr[r\r])r$rMr2rrr&rjr^r_rrr`rarcrdrepids prof_namesripidr3r1rkrls rby_professionalz+KpiDocumentAssignmentsClass.by_professionals9 Fi.CD AE A1uB")orRR+Aq1OE8((9CCqH!LTUVeHo  4==D3>>DDTJ3>>%G3>>I G &17GG3OeKff&q"E"Q"QUXYdUe"ef 7GGMMN_`JJBEEFLLZX  " =MMN 557D48ZqA 0; si no, por document_type_id. rrr)r*r+rr/r1Nbucket_catalog_idbucket_type_idr3r4z Documento #zTipo #r5r6zTipo de documento #uDocumento (sin catálogo))document_catalog_iddocument_type_id document_namer3r1r8c(|djS)Nrr:r<s rr>z9KpiDocumentAssignmentsClass.by_document..s1_#5#;#;#=rr@rBrC)(rDrr rrrrr rErFrGr2rHrIrJrKrLrMr#rNrOrPrQrUrVlistrrrrWdocumentrXrr3r1rYrZr[r\r]) r$rMr2rrr&rjr^r_rrbucket_catalog bucket_typer`rarcrdre catalog_idstype_ids doc_namesd type_namestribcbtr3r1rkdnamerls r by_documentz'KpiDocumentAssignmentsClass.by_documentsj Fi.CD AE A1uB")orRR+Aq1OE8"7KKaO7KKaj N4HH1LgVWjY9JJK ((9CCqH!LTUVeHo  4==D3>>DDTJ3>>%G3>>I G &17GG123&7CCs;GWW  "(()<=%%&67JJBEEFLLZX   ".+6 557D8<b1ADWDWD\[\@]`a@aQ((-A.bK"1..3!49c!BRBRBWVW>X[\>\((-A.H)+IGGMM-077 8H8H8L8L[8YZ^^`^A-.JJ,<"+C+C+E+];WXW[W[V\I]Ic!$$i(^ *,JGGMM"34;;'5 5cc^ F%#a&"E E FsI0T7HT7!T-'T-T7AT2*IT7- T77 UUUU)r#r) rM Optional[int]rrDrrDr&rr'rreturnDict[str, Any]) rMrrrDrrDr&rrr) rMrr2rDrrDrrDr&rrr)__name__ __module__ __qualname__r%rmrvr}rrrr!r!#sQ15*.NF#NF NF  NF !. NF(NF NFl15 QF#QF QF  QF !. QF QFt15BF#BF BF  BF  BF!.BF BFV15wF#wF wF  wF  wF!.wF wFrr!N)rrDrrDrzTuple[datetime, datetime])__doc__ __future__rrtypingrrrr r sqlalchemyr r r rsqlalchemy.ormrapp.backend.db.modelsrrrrr&app.backend.utils.professional_displayrrr!rrrrsD #3300"WbFbFr