^9jz fdZddlZddlZddlZddlZddlZddlZddlZddlm Z m Z ddl m Z m Z m Z ddlmZddlmZddlZeej)j*Zej*Zej0j3deeddlmZmZmZdZd ed d d d Z ed Z!edZ"dddddddddZ#gdZ$dddddddd dZ%dEd!edzd"e&e e effd#Z'dEd$edzd"e(e)fd%Z*d&ed"e dzfd'Z+d(ed"e(e)fd)Z,d(ed"e)fd*Z-ej\d+Z/ej\d,Z0d&ed"efd-Z1dFd&ed.e2d"efd/Z3d0e d1e d"e)fd2Z4d3e)d0e d1e d"e)fd4Z5d5e)d6ed7e d8e d"ef d9Z6d:ed;edzd5e)d6edZ8d?Z9d@e(ed5e)d6ed;edzfdAZ:d:ed;edzd5e)d6efdBZ;dCZ I1- -L YA..11EE f F%%f-J'G!!"234CHX8Y7ZZe fE wy& 88 status_filtercg}d}d}d} |dz }ttdd}|r |dk7r||d<|r |r ||d<||d <td D]c} tjt d t |d }|jdk(rtjd|dzzS|jnj} | j dg} |j| | j di} | j d}| j d }| j dr| s |S|dkDr |Stjd:#t$r&}|dk(rtjdYd}~,d}~wwxYw)zRBusca todas as oportunidades paginando. status_filter: open|won|lost|abandoned|allNrrd) location_id pipeline_idlimitallstatus startAfter startAfterIdz/opportunities/search)headersparamstimeoutr opportunitiesmeta nextPageUrl2g333333?)r r rangerequestsgetGHL_BASEHEADERS status_codetimesleepraise_for_status Exceptionjsonextend) rItodas start_afterstart_after_idpaginasrV tentativaredataoppsrZs rFbuscar_oportunidadesrrs EKNG 1 *.  ]e3,F8  >#.F< %3F> "q I LLj 56#!  ==C'JJqIM23""$ $vvxxx, Txx#hh|, .1xx &d  L R<  L 4S 4 > 1  sAEE E3 E..E3sc|sy |jdr|dddz}tj|jtS#t $rYywxYw)NZz+00:00)endswithr fromisoformatr7r8rf)rss rF parse_iso_utcrysV  ::c?#2!A%%a(33F;; sAA AA contact_idctdD]} tjtd|dtd}|j dk(rt jd|dzzU|j d k(rgcS|j|jjd gxsgcSgS#t$r#|dk(rgcYcSt jd YwxYw) z:Busca notas de um contato. Retorna lista (pode ser vazia).rS /contacts/z/notesrUrWrXrrnotes? r]r^r_r`rarbrcrdrergrfrzrmrns rF buscar_notasrs1X   *Jzl&9A }}# 1 A ./}}#   668<<,2 2$ I  A~ JJsO s$AB-!B-43B--CCCctdD]} tjtd|td}|j dk(rt jd|dzzT|j dk(ricS|j|jjd ixsicSiS#t$r#|dk(ricYcSt jd YwxYw) z0Busca dados detalhados do contato (phone, name).rSr|r}r~rXrrrcontactrrrs rFbuscar_contators1X   *Jzl3A }}# 1 A ./}}#   668<< 2.4" 4$ I  A~ JJsO s$AB, B,33B,,CCCz<[^>]+>z\s+c|sytjd|}tj|}tjd|j S)N )RE_TAGsubhtmlunescapeRE_WSstrip)rstxts rF strip_htmlrs@  **S! C -- C 99S#  $ $ &&rHnct|j}t||kr|S|d|dz jdzS)Nru…)rlenrstrip)rsrs rFtruncarrs;  A 1v{ Wq1u:    &&rHrCrDctddtd}tdt|dg}g}|D]}t|j dd}t|j d dxst|j d d}|r1||cxkr|kr&nn#|j ||j ||s||cxkr|ksn|j |td t|d t|d dt |Dchc]}|j ds|dc}}tdt|ddi} d} td5} |D cgc]} | j| | } } t| D]}|j\} }|| | < dddtddi}d}td5} |D cgc]} | j|| } } t| D]}|j\} }||| < ddd|||| |dScc}wcc} w#1swYxYwcc} w#1swY,xYw)Nz'[*] Coletando oportunidades (todas) ...TflushrO)rIz[*] Total bruto pipeline: createdAtrlastStageChangeAtlastStatusChangeAtz+[*] Oportunidades com atividade na janela: z (novos: ) contactIdz[*] Buscando notas de z contatos ...cFtjd|t|fSNg?)rcrdrcids rF_fetchzcoletar_dados.._fetch's 4L%%%rHr ) max_workersz![*] Buscando dados de contato ...cFtjd|t|fSr)rcrdrrs rF_fetch_czcoletar_dados.._fetch_c5s 4N3'''rH)ridentronovos_na_semananotas_por_contato contatos_full) printrrrryr_appendlistrsubmitrresult)rCrDrirropcreated last_change contact_idsrrexrfutsfutnotasrrcts rF coletar_dadosrsk 3DA u 5E &s5zl 34@FO {B 78#BFF+>$CD FF' ,I  zW77  " "2 & MM"  Z;A'A MM"   5c&k]C'( +&PBBFF;3 &#&>>% +CJC%* c " ++ -d;M(  *$b4?@S (C(@@% $CjjlGC!#M#  $$*.&  9Q?++A$$sHH.-H.&H8+H3*H8I I3*I 3H88II  Idadosc !|d}|d}|d}|d}tDcic]}|d}}|D]l} tj| jdd}| jdd k(rd }n| jdd k(rd }|j|dd z||<nt|} t|} |jdd|jddz|jddz|jd dz} |jd d} |jd d}| r| | z dznd}| r| | z dznd}g}|D]H} | jd}|j|ixsi}|jdxsdj xsT|jddxsdd|jddxsdj xs| jdxsd}|jdxsd}|j|gxsg}g}|D]B}t |jdd}|s!||cxkr|ks-n0|j ||fD|jdd|rJ|dd }t|jdxs|jd xsd}|r t|d!nd"}nd"}tj| jdd}| jdd k(rd }n| jdd k(rd }t | jd#d}|r$|jtjd$nd%}|j | jd&|||||r|jnd|d'KttD cic]\}} | | c} }!|j!fd()|| | | | ||||d* Scc}wcc} }w)+NrrrrrpipelineStageId DESCONHECIDOrPlostrwonrrrrrrKr contactNamer firstNamerlastNamenamezSem nomephone dateAddedc |dS)Nr)xs rFzagregar..}s 1Q4rHT)keyreversebodyTextbodyzSem observacao no periodorr+-id)rnometelefonestage data_entradadata_entrada_sortobsc:j|dd|d fS)Nrcr)r_)r stage_idxs rFrzagregar..s$y}}QwZ4q9L7M6MNrH)r) contagem_stagetotal novos_total qualificados fechamentosperdidos taxa_qual taxa_fechlinhas) STAGE_ORDERSTAGESr_rrryrsortrrr7r4r9 timestamp enumerate)"rrCrDrnovosrrrrrrrrrrrrrrcontatorrnotas_na_janelardultimoobs_txtr stage_nomerdata_entrada_brirsrs" @rFagregarrKs 8_F # $E12/*M+66$dAg6N6?zz"&&!23^D 66( v %D VVH  &D-11$:Q>t? KEe*K=!,   _a 0 1   Z + ,   Z + , !$$Z3K!!)Q/H6A +c1qI5@{*S0aIF/ ff[!##C,2 [[ ' -2 4 4 6 ++k"-34Agkk*R6P6VTV5WX^^` vvf~  ;;w'-2!%%c2.4" /AaeeK45AZ1//&&1v. / > $Q'*F J!7!S6::f;M!SQSTG+2''3'8SC-CZZ'8 9>J 66( v %"J VVH  &#J{B 78DKG  u % . ./? @QT   ffTl$# /r?ctjtjd}|jdd|jd}t |dj xsd}g}t D]t}|dj|d} | |z dz} tj|d } |jd | d | d | d tj|d| d| dd| d| ddvg} t|ddD]\} }tj|dd } tjdd|dxsd}|rd|dtj|ddnd}| jd| dtj|dd |d!| d | d | d tj|dd"tj|d#d$tj|d%d&| s| jd'd(|d)|d*|d+|d,d-|d.d/|d0d1|d2d3|d4dd5|d6d7dj|d8dj| d9}|S):Nr+z%d/%mr,z%d/%m/%YrrrrKz#64748bzP z- z|
zX%
rrz\Drrzzz-z8 z" rz# zD rz& rz$ zxNenhum lead com atividade no periodo.u Relatorio Semanal PX3 Lab — u��
📊 PX3 LAB · CRM PADRAO PX3

Relatorio Semanal

z0
Gerado em z
Novos leads
rz
criados na semana
Qualificados
rz
qual+teste+prop+ganhamos
Ganhamos
rz
fechamentos
Perdidos
rz
no periodo
Taxa Qualificacao
rz%
qualificados/novos
Atividade Total
ra
opps c/ movimento

Distribuicao por Stage

Distribuicao das oportunidades com atividade na semana, agrupadas pelo stage ATUAL.

am
StageQtd% do total

Leads Individuais

Todos os leads com criacao ou movimentacao no periodo, ordenados pelo funil. Clique no telefone para abrir o WhatsApp.

u
# Nome Telefone Stage atual Entrada Observacao mais recente
Relatorio gerado automaticamente pelo agente Mia · Agencia Climb Digital
Pipeline: PADRAO PX3 · Fuso: America/Sao_Paulo
)rr5r4r9sumvaluesrr_ STAGE_COLORSrrescaperr-rjoin)rrr>r? gerado_em periodo_curto total_stages linhas_stagerqtdpctcor linhas_leadsrl tel_cleantel_linkhtml_outs rF render_htmlrsS U#,,-=>I ))'233vz7R6STMs+,3356;!LL "#''a0L 3&tY/??Be9SEQcdgchhlmqmxmxy}m~l@!!$&78;3i}SER114S :    &L#h-+ 1qz95FF5"a m&9r: &i[0PQUQ\Q\]^_i]jQkPllp q/  ''(c*![[6345J??Be9SEQcdgchhlmqmxmxyz|CzDnEmFF##';;q/@#A"BC!!%QuX!6 78    *  G & '4_V5l -o.**35 !$M 234 !$N 345 !$M 234 !$J01 !$K 056 !$G ~ .&'((&' (yhHR OrH html_path link_publico destinatariosc ~ddl}ddlm}ddlm}t j jdd}t j jddjdd} | std } | jrh| jjD]G} | jd s| jd d d jjdd} I| st!d dy|jd} |d} d|| d<d|d| d<dj#|| d<d|d}|r |d|dz }|d|dd|d d!|d"d#|d$z }| j%||d%| j%|| d& |j'd'd(}|j)|j+|| |j-||| j/|j1t!d)dj#|dy#t2$r}t!d*|dYd}~yd}~wwxYw)+Nr) MIMEMultipart)MIMEText GMAIL_USERzremoraes09@gmail.comGMAIL_APP_PASSWORDrrz /opt/mia/.envzGMAIL_APP_PASSWORD==ru6[!] GMAIL_APP_PASSWORD não configurado, pulando emailTrutf-8encoding alternativeu$📊 Relatório Semanal PX3 Lab — SubjectzMia - Climb Digital <>From, TouRelatório semanal PX3 Lab —  z Acesse online: z Total: rz | Qualificados: rz | Fechamentos: rz | Perdidos: rplainrzsmtp.gmail.comiKz[ok] Email enviado para: z[!] Erro ao enviar email: )smtplibemail.mime.multipartr email.mime.textrosenvironr_r3rexists read_text splitlines startswithsplitrrrattachSMTPstarttlsloginsendmail as_stringquitrf)r r rrr rr r gmail_user app_passwordenv_pathline html_contentmsg texto_plainserverros rF enviar_emailr6sK2( .DEJ::>>"6;CCCLL ( ??  **,779 R??#89#'::c1#5a#8#>#>#@#H#Hb#QL R  FdS&&&8L  &C;M?KC N)*Q7CK -(CI3M?"EK*<.;; Ys7|n,=c.>Q=RRbcfgtcubvwDEHISETDUVVKJJx W-.JJx f-.<.4 Z. M3==?C  )$))M*B)CDDQ < *1#.d;;d K K LsBC C& C!!C&c dtd}|jstddyd|d|dd|d d |d d |d d|ddd }|r|d|z }tt jdz}||dz }t |d5}t jd|i|ddd|dz} || dz } t | d5}t jt|dd|dddtd|jd| jdy#1swYuxYw#1swY=xYw)Nz/opt/mia-bot/outboxz-[!] outbox nao existe, pulando envio TelegramTru'📊 *Relatorio Semanal PX3 Lab* 📅 u 👥 Novos leads: *rr:ru* 🏆 Ganhamos: *rr;ru* 📈 Taxa qualificacao: *rrz%* u 🔗 geAz.jsonwrEru📎 Relatorio HTML completo)documentcaptionz"[ok] mensagens criadas no outbox: r) rr"rr0rcopenrgdumpstrr) r r rroutboxrFtsmsg_pathfts2doc_paths rFenviar_telegramrVgst ' (F ==? =TJ !-012!.123}-./j/*+$$' $4S#9  ?  7<.)) TYY[3  B2$e $H h & 65/1%& q&C3%u %H h   Y4R SUV   .x}}oR  OW[\&&   s D#D&D#&D/c btj}|jdd|jddd|jdd |jd d d d |jdd dd|jdttdz d|j }t |j\}}}}}td|dtd|jd|jdt||}t|||}t||||} t|j} | jj!dd| j#| dtd| dtd|d d!|d"d#|d$d%|d&d'|d( d|j$rt'| |j(|||j*r#t-| |j(|||j*|j.r#t1|j.|||j(yy))Nz--semanaz9Semana ISO (YYYY-WW), ex: 2026-25. Default: semana atual.)helpz--enviar store_truez%Envia via Telegram outbox apos gerar.)actionrXz--linkz7Link publico do HTML (para incluir na msg do Telegram).z--email+ADDRz-Envia por email para os enderecos informados.)nargsmetavarrXz --whatsappPHONEzAEnvia por WhatsApp (via Dinastia API) para os numeros informados.z--saidazrelatorio_atual.htmlzPath do HTML de saida.)defaultrXz [*] Janela: Trz UTC: z -> )parentsexist_okrrz[ok] HTML salvo em: z[stats] total=rz novos=rz qualif=rz ganhamos=rz perdidos=r)argparseArgumentParser add_argumentrO SCRIPT_DIR parse_argsrGr<r isoformatrrrrsaidaparentmkdir write_textenviarrVlinkemailr6whatsapprH) parserargsrCrDrEr>r?rrhtml_strout_paths rFmainrusT  $ $ &F  H  4   F  <    P   J!778 %    D4CDKK4P1J 6 L - Jz++-.d73D3D3F2G HPTU *g .E %W -C3y&9HDJJH OO$6 73  +48 Wgc-.@-ABn%&j]1C0DJsS]N_ a  {{$))S%8 zzXtyy#udjjA }} sE499=rH__main__)N)r)>__doc__rcrrgr r-sysrcconcurrent.futuresrrrrrpathlibrzoneinfor r^__file__resolverjrf PX3LAB_DIRpathinsertrO config_ghlr r r r`rar4r8rrrtuplerGrdictrrryrrcompilerrrr0rrrrr6rBrCrHrVru__name__rrHrFrs  ?22 (^ # # % , ,    3z?#FF 1yk* &   $% %-3,?,9,;,6,6,5,:    "  (9d (9eHhPSz zFrH