+ kej" Rt^RIHtHt^RIHtHtHtHtH t ^RI H t ^RI H t ^RIHt^RIHt^RIHt]!RR .R 7t^tR R lt]P/R 4]P0!R4]!RR73RRll44tR#)u Dossiê consolidado de uma entidade, por NIF (v1 public API). Alimenta a tab "Intel" da ficha de cliente do Sabichão. A ideia é que o Intel Grid continue a ser a plataforma de monitorização, mas que a informação apareça onde o cliente é gerido — quem atende um cliente não vai a outro portal. É composição de dados que já existem (empresa, processos, insolvências, publicações, contratos), não lógica nova: uma única chamada em vez de cinco, porque a tab carrega em lazy-load e não pode ser lenta. ) AnnotatedAny) APIRouterDepends HTTPExceptionQueryRequest)text) AsyncSession)require_api_key) get_session)limiterz/dossierz public-api)prefixtagscLV^8dQhR\R,R\R,/#)rawNreturn)str)formats"app/api/v1/dossier.py __annotate__rs"003:0#*0cnV'gR#RPRV44p\V4^ 8XdV#R#)Nc3T"TFqP4'gKVxK R#5i)N)isdigit).0chs& r _norm_nif..s6#BRR#s( ()joinlen)rdigitss& r _norm_nifr$s2  WW6#6 6F[A%6/4/rrz 120/minuteu'NIF/NIPC; aceita espaços e pontuação) descriptionc V^8dQhR\R\\\\43,R\\ \ \3,\\43,R\ R\ \ \3,/#)rrequestsession_keynifr) rrr rr dictrrr )rs"rrr#soff f |W[%99 :f DcNGO$<< =f f  #s(^ frc"\V4pV'g\RRR7hVP\R4RV/4GRjxL P 4P 4pVP\R4RVR\ /4GRjxL P 4P4pVP\R4RVR\ /4GRjxL P 4P4p.p.p .p /p /p V'EdVR ,p VP\R 4R V R\ /4GRjxL P 4P4Uu.uFp\V4NK ppVP\R 4R V R\ /4GRjxL P 4P4Uu.uFp\V4NK p pVP\R 4R V R\ /4GRjxL P 4P4Uu.uFp\V4NK p pVP\R4R V /4GRjxL P 4P 4pV'd \V4M/p VP\R4R V /4GRjxL P 4P 4pV'd \V4M/p RTRVRJRV'd \V4MRRVUu.uFp\V4NK upRVUu.uFp\V4NK upRVRV RV RV RV / #ELELELiEL uupiELuupiEL[uupiEL Luupiuupi5i)iu NIF inválido) status_codedetaila SELECT c.id::text, c.nif, c.legal_name, c.cae, c.address, c.natureza_juridica, c.distrito, c.concelho, c.freguesia, c.codigo_postal, c.localidade, c.objeto_social, c.capital_social, c.registry_complete, c.risk_score, c.monitoring_type, c.active, (SELECT ac.alvara_number FROM alvara_companies ac WHERE ac.nipc = c.nif AND ac.alvara_type = 'A' AND ac.removed_at IS NULL LIMIT 1) AS alvara FROM companies c WHERE c.nif = :nif r*Naa SELECT h.claim_deadline, (h.claim_deadline - CURRENT_DATE) AS days_left, h.matched_role, h.acknowledged_at, a.process_number, a.tribunal, a.ato, a.pub_date, a.claim_days, a.claim_deadline_estimated, a.admin_name, a.admin_email FROM insolvency_hits h JOIN cire_announcements a ON a.id = h.announcement_id WHERE h.matched_nif = :nif AND a.opens_claim_window ORDER BY h.claim_deadline NULLS LAST LIMIT :lim limau SELECT DISTINCT a.id::text, a.pub_date, a.ato, a.process_number, a.tribunal, p.role FROM cire_announcement_parties p JOIN cire_announcements a ON a.id = p.announcement_id WHERE p.nif = :nif ORDER BY a.pub_date DESC NULLS LAST LIMIT :lim ida  SELECT process_number, tribunal, juizo, species, source, role_in_process, date_filed FROM processes WHERE company_id = :cid ORDER BY date_filed DESC LIMIT :lim cidz SELECT title, date, type, source FROM dre_publications WHERE company_id = :cid ORDER BY date DESC NULLS LAST LIMIT :lim aM SELECT DISTINCT ON (person_nif, cargo) person_name, person_nif, cargo, act_date FROM publication_people WHERE company_id = :cid ORDER BY person_nif, cargo, act_date DESC LIMIT :lim z SELECT count(*) AS total, COALESCE(sum(value),0) AS valor FROM public_contracts WHERE company_id = :cid a! SELECT count(*) FILTER (WHERE source='cire') AS cire, count(*) FILTER (WHERE source='distribuicao') AS distribuicao, count(*) AS total FROM processes WHERE company_id = :cid monitorizadaempresaprazos_reclamacaoanuncios_insolvencia processosprocessos_contagem publicacoespessoascontratos_publicos) r$rexecuter mappingsfirst MAX_ITEMSallr+)r'r(r)r*nif_normcompany deadlines announcements processes publicationspeople contractscountsr1rrows&&&& rdossierrK!s~H ODDoo   H   hj# ,oo   HeY /  "hj%*oo  HeY /  hj"')I)+L#%F "IFwdmooC 2  hj    G   &ooC 2  hj    G   $ooC 2  hj    G   $//    (*UUW "%DI" //    (*UUW "cr x t+G4=y9y!d1gy9- @-Qa- @Yf|6i Y * ( 6  &  $  $  ,: @sAM$L4AM$ L7 AM$L:2M$/M$4L=5"M$M+(M$M"M$6M (M$2M 3"M$M)"M$ M 'M$4-M$!M"'M$ M$&M$7M M$M&M$7M$:M$=M$M$M$M$M$ M$N)__doc__typingrrfastapirrrrr sqlalchemyr sqlalchemy.ext.asyncior app.auth.api_key_authr app.dbr app.rate_limitr routerr>r$getlimitrKrrrXsv "EE/1" *L> :  0B| !JK ffr