Ë
    ã*ôjâ^  ã                  óÒ  — U d Z ddlmZ ddlZddlZddlmZmZmZ ddlm	Z	 ddl
mZ ddlmZ ddlmZ dd	lmZ dd
lmZ ddlmZmZmZmZmZmZ ddlmZmZ ddlmZm Z m!Z! ddl"m#Z#  ejH                  dejJ                  «      Z& ejH                  d«      Z' ejH                  d«      Z(g d¢Z)g d¢Z*g Z+de,d<   dgZ-da.de,d<   da/de,d<   d8d„Z0d9d„Z1d:d„Z2d;d„Z3d<d„Z4d=d „Z5d>d!„Z6 ejH                  d"ejJ                  «      Z7d?d#„Z8d$d$dd%œ	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 d@d&„Z9dAd'„Z:dBd(„Z;dCd)„Z<dDd*„Z=ddd+œ	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 dEd,„Z>dFd-„Z?d.d/œdGd0„Z@dHd1„ZAd2d3œdId4„ZBd5d6œdJd7„ZCy)KuE   Inbound Gmail â†’ filter â†’ classify â†’ auto-create Positive leads.é    )ÚannotationsN)ÚdateÚdatetimeÚtimezone)ÚAny)ÚSession)Úsettings)Úcreate_lead)ÚEmailMessage)Ú
_smtp_send)ÚGmailAuthErrorÚaccount_has_readonlyÚget_default_accountÚget_message_detailÚlist_accountsÚlist_recent_messages)Úai_classify_enabledÚclassify_interest_with_openai)ÚInboundEmailEventÚInboundEmailRulesÚLead)Ú
LeadCreatezhttps?://[^\s<>\"']+z)^(?=.*[A-Za-z])(?=.*\d)[A-Za-z0-9]{5,12}$z+^[A-Za-z0-9][A-Za-z0-9.-]*\.[A-Za-z0-9.-]+$)
Ú
interestedÚyeszsounds goodz
let's talkz	lets talkzschedule a callzbook a callzplease shareÚpricingÚdemo)znot interestedz	no thanksÚunsubscribez	remove mezstop emailingzdon't contactzdo not contactú	list[str]Ú_ALWAYS_NEGATIVEzazure.crystal.naturezdatetime | NoneÚ_last_run_atú
str | NoneÚ_last_run_summaryc                ó¦  — | sg S 	 t        j                  | «      }t        |t        «      rA|D �cg c]5  }t	        |«      j                  «       sŒt	        |«      j                  «       ‘Œ7 c}S 	 t        j                  d| «      D �cg c]#  }|j                  «       sŒ|j                  «       ‘Œ% c}S c c}w # t         j                  $ r Y Œ]w xY wc c}w )Nz[\n,]+)	ÚjsonÚloadsÚ
isinstanceÚlistÚstrÚstripÚJSONDecodeErrorÚreÚsplit)ÚrawÚdataÚxÚps       ú=/var/www/html/marketing_pipleline/backend/app/inbound_mail.pyÚ_parse_keywordsr2   N   s¨   € ÙØˆ	ðÜ�z‰z˜#‹ˆÜ�dœDÔ!Ù,0ÓC©D q´C¸³F·L±LµN”C˜“F—L‘L•N¨DÑCÐCð "ô  "Ÿx™x¨	°3Ô7ÓEÑ7˜!¸1¿7¹7½9ˆA�G‰G�IÐ7ÑEÐEùò DøÜ×Ñò ÙðüâEs4   †)B5 ¯B0ÁB0Á)B5 ÂCÂCÂ0B5 Â5CÃ
Cc                ó¶   — | D �cg c]5  }t        |«      j                  «       sŒt        |«      j                  «       ‘Œ7 }}t        j                  |«      S c c}w ©N)r(   r)   r$   Údumps)Úitemsr/   Úcleaneds      r1   Ú_dump_keywordsr8   Z   sA   € Ù',Ó?¡u !´°A³·±µŒs�1‹v�|‰|�~ u€GÐ?Ü�:‰:�gÓÐùò @s
   …A¤Ac                ó   — t        | j                  «      }t        D �ch c]  }|j                  «       ’Œ }}|D �cg c]  }|j                  «       |vsŒ|‘Œ }}|D �ch c]  }|j                  «       ’Œ }}t	        |«      t	        |«      k7  }t
        D ]G  }|j                  «       |vsŒ|j                  |«       |j                  |j                  «       «       d}ŒI |rt        |«      | _        |S c c}w c c}w c c}w )zENormalize negative list (add required / drop legacy outreach brands).T)	r2   Únegative_keywordsÚ_REMOVE_FROM_NEGATIVEÚcasefoldÚlenr   ÚappendÚaddr8   )ÚrowÚexistingr/   Ú	remove_cfr7   Úexisting_cfÚchangedÚkws           r1   Ú_ensure_always_negativerF   _   sØ   € ä˜s×4Ñ4Ó5€HÝ'<Ó=Ñ'< !�—‘•Ð'<€IÐ=Ù"ÓD™(�Q a§j¡j£l¸)Ò&CŠq˜(€GÐDÙ)0Ó1© A�1—:‘:•<¨€KÐ1Ü�'‹lœc (›mÑ+€GßˆØ�;‰;‹= Ò+Ø�N‰N˜2ÔØ�O‰O˜BŸK™K›MÔ*Ø‰Gð	 ñ
 Ü .¨wÓ 7ˆÔØ€Nùò >ùÚDùÚ1s   žC1»C6ÁC6ÁC;c                óä  — | j                  t        «      j                  t        j                  «      j	                  «       }|r?t        |«      r2| j                  |«       | j                  «        | j                  |«       |S t        ddt        t        «      t        t        «      t        j                  xs d¬«      }| j                  |«       | j                  «        | j                  |«       |S )NFz[]éx   ©ÚenabledÚfilter_keywordsÚpositive_keywordsr:   Úpoll_interval_seconds)Úqueryr   Úorder_byÚidÚfirstrF   r?   ÚcommitÚrefreshr8   Ú_DEFAULT_POSITIVEÚ_DEFAULT_NEGATIVEr	   Úinbound_mail_poll_seconds)Údbr@   s     r1   Úget_or_create_rulesrX   p   s±   € Ø
�(‰(Ô$Ó
%×
.Ñ
.Ô/@×/CÑ/CÓ
D×
JÑ
JÓ
L€CÙ
Ü" 3Ô'Ø�F‰F�3ŒKØ�I‰IŒKØ�J‰J�sŒOØˆ
Ü
ØØÜ(Ô):Ó;Ü(Ô):Ó;Ü&×@Ñ@ÒGÀCô€Cð ‡F�Fˆ3„KØ‡I�I„KØ‡J�Jˆs„OØ€Jó    c                óØ   — t        | j                  «      t        | j                  «      t        | j                  «      t        | j
                  «      t        | j                  xs d«      dœS )NrH   rI   )ÚboolrJ   r2   rK   rL   r:   ÚintrM   )r@   s    r1   Úrules_to_dictr]   …   sU   € ä˜Ÿ™Ó$Ü*¨3×+>Ñ+>Ó?Ü,¨S×-BÑ-BÓCÜ,¨S×-BÑ-BÓCÜ!$ S×%>Ñ%>Ò%EÀ#Ó!Fñð rY   c                ó¬  — t        | «      }d|v r|d   �t        |d   «      |_        d|v r|d   �t        |d   «      |_        d|v r|d   �t        |d   «      |_        d|v r|d   �t        |d   «      |_        d|v r"|d   �t        dt        |d   «      «      |_	        | j                  |«       | j                  «        | j                  |«       |S )NrJ   rK   rL   r:   rM   é   )rX   r[   rJ   r8   rK   rL   r:   Úmaxr\   rM   r?   rR   rS   )rW   Úfieldsr@   s      r1   Úupdate_rulesrb   �   sò   € Ü
˜bÓ
!€CØ�FÑ˜v iÑ0Ð<Ü˜6 )Ñ,Ó-ˆŒØ˜FÑ" vÐ.?Ñ'@Ð'LÜ,¨VÐ4EÑ-FÓGˆÔØ˜fÑ$¨Ð0CÑ)DÐ)PÜ .¨vÐ6IÑ/JÓ KˆÔØ˜fÑ$¨Ð0CÑ)DÐ)PÜ .¨vÐ6IÑ/JÓ KˆÔØ &Ñ(¨VÐ4KÑ-LÐ-XÜ$'¨¬C°Ð7NÑ0OÓ,PÓ$QˆÔ!Ø‡F�Fˆ3„KØ‡I�I„KØ‡J�Jˆs„OØ€JrY   c                ó¶   — | xs dj                  «       }g }|D ]=  }|xs dj                  «       }|sŒ|j                  «       |v sŒ-|j                  |«       Œ? |S )NÚ )r<   r)   r>   )ÚtextÚkeywordsÚhayÚhitsrE   Úterms         r1   Ú_match_termsrj   ¡   sX   € ØŠ:�2×
Ñ
Ó
!€CØ€DÛˆØ’�b×ÑÓ!ˆÚ�D—M‘M“O sÒ*Ø�K‰K˜Õð ð €KrY   u:   ^((re|fw|fwd|aw|sv|antw|rif|å›žå¤�|è½‰å¯„|è½¬å�‘)\s*:\s*)+c                óÚ  — | xs dj                  «       }d|vryt        j                  |«      ry|j                  dd«      d   j                  «       }|syt	        j
                  d|«      D �cg c]  }|sŒ|‘Œ	 }}|rt        |«      dkD  ryt        d„ |D «       «      }|syt        |«      dk(  ry	t        d
„ |D «       «      }|ry	t        |«      dk(  xr t        d„ |D «       «      S c c}w )u–  True for *new* cold subjects like 'Hi Name | QRV7G00 brand.name'.

    Requires a `|` and, after the last pipe, a mixed alphanumeric tracking code.
    Does NOT treat bare `|` alone as spam (avoids normal subjects like 'Notes | John').

    Replies/forwards (`Re: â€¦ | CODE â€¦`) are allowed through â€” those are often
    prospect replies to *our* outreach and should be AI-classified for interest.
    rd   Ú|Fé   éÿÿÿÿz\s+é   c              3  óF   K  — | ]  }t         j                  |«      –— Œ y ­wr4   )Ú_TRACK_CODE_REÚmatch©Ú.0Úts     r1   Ú	<genexpr>z0is_pipe_tracking_spam_subject.<locals>.<genexpr>Æ   s   è ø€ Ð<±V°”N×(Ñ(¨×+±Vùó   ‚!Tc              3  óF   K  — | ]  }t         j                  |«      –— Œ y ­wr4   )Ú_DOTTED_BRAND_RErr   rs   s     r1   rv   z0is_pipe_tracking_spam_subject.<locals>.<genexpr>Ì   s   è ø€ Ð>±v°!Ô$×*Ñ*¨1×-±vùrw   é   c              3  ó8   K  — | ]  }t        |«      d k  –— Œ y­w)é0   N)r=   rs   s     r1   rv   z0is_pipe_tracking_spam_subject.<locals>.<genexpr>Ð   s   è ø€ Ð#A¹&°Q¤C¨£F¨b¥L¹&ùs   ‚)	r)   Ú_REPLY_PREFIX_RErr   Úrsplitr+   r,   r=   ÚanyÚall)ÚsubjectÚsubjÚtailru   ÚtokensÚ	has_trackÚ	has_brands          r1   Úis_pipe_tracking_spam_subjectr‡   ±   sç   € ð ŠM�r× Ñ Ó"€DØ
�$�Øä×Ñ˜dÔ#ØØ�;‰;�s˜AÓ˜rÑ"×(Ñ(Ó*€DÙØÜŸ™ &¨$Ô/Ó5Ñ/�A²1ŠaÐ/€FÐ5Ù”S˜“[ 1’_ØÜÑ<±VÓ<Ó<€IÙØä
ˆ6ƒ{�aÒØÜÑ>±vÓ>Ó>€IÙØäˆv‹;˜!ÑÒA¤Ñ#A¹&Ó#AÓ AÐAùò 6s   Á.C(Á6C(rd   )Ú
from_emailÚ	from_nameÚuse_aic                óx  — | xs d› d|xs d› �}t        ||«      }	|sdn
t        |	«      }
|
sddg g dœS t        | «      rdd|	dgdœS t        D �ch c]  }|j	                  «       ’Œ }}|D �cg c]  }|j	                  «       |vsŒ|‘Œ }}t        ||«      }|rdd|	|dœS |€
t        «       n
t        |«      }|r^t        | |||¬	«      }|j                  d
«      xs d}d|j                  d«      xs |› �}|dk(  rdd|	|gdœS |dk(  rdd|	|gdœS dd|	|gdœS t        ||«      }|rdd|	|dœS dd|	g dœS c c}w c c}w )uQ  Filter gate + hard negatives, then OpenAI (or keyword) interest detect.

    Order:
    1) filter keywords (empty = all)
    2) pipe-tracking spam / negative keywords â†’ negative (never create lead)
    3) OpenAI interest classify when enabled â†’ positive creates lead
    4) fallback: positive keywords â†’ positive; else skipped
    rd   Ú
TFÚignored)Úfilter_matchedÚclassificationÚmatched_filter_termsÚmatched_sentiment_termsÚnegativezpipe-tracking-subject)r�   Úbodyrˆ   r‰   ÚlabelÚneutralzai:ÚreasonÚpositiveÚskipped)rj   r[   r‡   r;   r<   r   r   Úget)r�   r“   rK   rL   r:   rˆ   r‰   rŠ   ÚblobÚfilter_hitsrŽ   r/   rB   rE   Úneg_keywords_effectiveÚneg_hitsÚrun_aiÚair”   ri   Úpos_hitss                        r1   Úclassify_messager¡   Ó   sæ  € ð& Šm˜ˆ_˜B˜tšz r˜lÐ+€DÜ˜t _Ó5€Ká!0‘T´d¸;Ó6G€NÙà#Ø'Ø$&Ø')ñ	
ð 	
ô % WÔ-à"Ø(Ø$/Ø(?Ð'@ñ	
ð 	
õ (=Ó=Ñ'< !�—‘•Ð'<€IÐ=á&óÙ&ˆr¨"¯+©+«-¸yÒ*HŠÐ&ð ð ô ˜DÐ"8Ó9€HÙà"Ø(Ø$/Ø'/ñ	
ð 	
ð '- nÔ Ô"¼$¸v»,€FÙä*ØØØ!Øô	
ˆð —‘�w“Ò, 9ˆØ�R—V‘V˜HÓ%Ò.¨Ð/Ð0ˆØ�JÒà"&Ø",Ø(3Ø,0¨6ñ	ð ð �JÒà"&Ø",Ø(3Ø,0¨6ñ	ð ð #Ø'Ø$/Ø(, vñ	
ð 	
ô ˜DÐ"3Ó4€HÙà"Ø(Ø$/Ø'/ñ	
ð 	
ð Ø#Ø +Ø#%ñ	ð ùòm >ùòs   ÁD2Á,D7ÂD7c                ó„   — t         j                  | xs d«      }|sy |j                  d«      j                  d«      }|d d S )Nrd   r   z).,;]é   )Ú_URL_REÚsearchÚgroupÚrstrip)re   ÚmÚurls      r1   Úextract_websiterª   :  s>   € Ü�‰�t’z˜rÓ"€AÙØØ
�'‰'�!‹*×
Ñ
˜GÓ
$€CØˆt�ˆ9ÐrY   c                ó  — | xs dj                  «       j                  d«      }|r	d|vr|d d S |xs dj                  dd«      d   j                  dd«      j                  d	d«      j                  «       }|xs d
j                  «       d d S )Nrd   Ú"Ú@éÿ   rm   r   Ú.Ú Ú_ÚUnknown)r)   r,   ÚreplaceÚtitle)r‰   rˆ   ÚnameÚlocals       r1   Úextract_contact_namer·   B  sŽ   € ØŠO˜×"Ñ"Ó$×*Ñ*¨3Ó/€DÙ�˜4‘Ø�D�SˆzÐØÒ˜2×$Ñ$ S¨!Ó,¨QÑ/×7Ñ7¸¸SÓA×IÑIÈ#ÈsÓS×YÑYÓ[€EØÒ�Y×%Ñ%Ó'¨¨Ð-Ð-rY   c                óØ   — d}| s|S g }| d d D ]@  }|j                  «       }|sŒd|v r|j                  d|› d�«       Œ0|j                  |«       ŒB |s|S |› ddj                  |«      › d�S )Nzin:inbox newer_than:1dé   r°   r¬   z (z OR Ú))r)   r>   Újoin)rK   ÚbaseÚpartsrE   ri   s        r1   Ú_gmail_search_queryr¾   J  s„   € Ø#€DÙØˆà€EØ˜c˜rÓ"ˆØ�x‰x‹zˆÙØØ�$‰;Ø�L‰L˜1˜T˜F !˜Õ%à�L‰L˜Õð #ñ ØˆØˆV�2�f—k‘k %Ó(Ð)¨Ð+Ð+rY   c                óÄ   — | j                  t        j                  «      j                  t        j                  |k(  t        j
                  |k(  «      j                  «       d uS r4   )rN   r   rP   ÚfilterÚgmail_account_emailÚgmail_message_idrQ   )rW   Úaccount_emailÚ
message_ids      r1   Ú_already_processedrÅ   ]  sQ   € à
�‰Ô"×%Ñ%Ó&ß	‰Ü×1Ñ1°]ÑBÜ×.Ñ.°*Ñ<ó

÷ 
‰‹Øð	ðrY   )Úlead_idÚerrorc               óü  — t        ||j                  d«      xs d|j                  d«      xs d |j                  d«      xs d |j                  d«      xs d |j                  d«      xs dd d xs d ||dj                  |«      xs d dj                  |«      xs d ||j                  d	«      xs dd d
 xs d |xs dd d
 xs d ¬«      }	| j                  |	«       | j	                  «        | j                  |	«       |	S )NrP   rd   Ú	thread_idrˆ   r‰   r�   r£   z, Úsnippetiè  )rÁ   rÂ   rÉ   rˆ   r‰   r�   rŽ   r�   r�   r‘   rÆ   Úraw_snippetrÇ   )r   r™   r»   r?   rR   rS   )
rW   rÃ   Údetailr�   rŽ   r�   r‘   rÆ   rÇ   Úevents
             r1   Ú_record_eventrÎ   i  sö   € ô Ø)ØŸ™ DÓ)Ò/¨RØ—*‘*˜[Ó)Ò1¨TØ—:‘:˜lÓ+Ò3¨tØ—*‘*˜[Ó)Ò1¨TØ—‘˜IÓ&Ò,¨"¨d¨sÐ3Ò;°tØ%Ø%Ø!ŸY™YÐ';Ó<ÒDÀØ $§	¡	Ð*AÓ BÒ JÀdØØ—Z‘Z 	Ó*Ò0¨b°%°4Ð8Ò@¸DØŠ{˜˜E˜TÐ"Ò* dô€Eð ‡F�Fˆ5„MØ‡I�I„KØ‡J�JˆuÔØ€LrY   c                óF  — ddddddddœ}t        |«      s|dxx   dz  cc<   |S t        |d   «      }|j                  }| j                  «        	 t	        | ||d¬«      }|D �]  }|j                  d«      xs d	}|rt        | ||«      rŒ)|d
xx   dz  cc<   | j                  «        	 t        | ||«      }	t        |	j                  d«      xs d	|	j                  d«      xs d	|d   |d   |d   |	j                  d«      xs d	|	j                  d«      xs d	¬«      }|d   }|dk(  r#|dxx   dz  cc<   t        | ||	dd|d   g ¬«       Œè|dk(  r'|dxx   dz  cc<   t        | ||	dd|d   |d   ¬«       �Œ|dk(  r$|dxx   dz  cc<   t        | ||	dd|d   g ¬«       �Œ=|	j                  d«      xs d	j                  «       j                  «       }|s(|dxx   dz  cc<   t        | ||	dd|d   |d   d¬«       �Œ˜| j                  t        j                   «      j#                  t        j$                  j'                  |«      «      j)                  «       }|r+|d xx   dz  cc<   t        | ||	d d|d   |d   |d   ¬!«       �Œ|	j                  d«      xs d	}|	j                  d«      xs d	}|	j                  d"«      xs |d d# j                  «       }d$|› d%|› d&|› �d d' }	 t+        | t-        t/        |	j                  d«      xs d	|«      ||t1        |«      t3        j4                  «       d(|d d¬)«	      «      }|d+xx   dz  cc<   t        | ||	d,d|d   |d   |j                   ¬!«       �Œ |S # t
        $ r |dxx   dz  cc<   |cY S w xY w# t
        $ rG}
|dxx   dz  cc<   t        | |||j                  d«      d	dœddg g t        |
«      ¬«       Y d }
~
�Œqd }
~
ww xY w# t6        $ r=}
|dxx   dz  cc<   t        | ||	dd|d   |d   t        |
«      d d* ¬«       Y d }
~
�Œºd }
~
ww xY w)-Nr   ©Ú	processedÚcreatedr˜   r’   Ú	duplicateÚerrorsr�   rÔ   rm   rK   é2   )rN   Úmax_resultsrP   rd   rÑ   ÚthreadId)rP   rÉ   rÊ   rÇ   F)rÃ   rÌ   r�   rŽ   r�   r‘   rÇ   r�   r“   rL   r:   rˆ   r‰   )r�   r“   rK   rL   r:   rˆ   r‰   r�   r�   r�   )rÃ   rÌ   r�   rŽ   r�   r‘   r’   Tr‘   r˜   zMissing from emailrÓ   )rÃ   rÌ   r�   rŽ   r�   r‘   rÆ   rÊ   i,  zInbound email
Subject: rŒ   z
source: inbound email i   zPositive lead)	Úcontact_nameÚclient_emailÚ	our_emailÚwebsiteÚ
date_addedÚstageÚnotesÚ
deal_valueÚcall_schedulediô  rÒ   r—   )r   r¾   ÚemailrR   r   r   r™   rÅ   r   rÎ   r(   r¡   r)   ÚlowerrN   r   rP   rÀ   rÙ   ÚilikerQ   r
   r   r·   rª   r   ÚtodayÚ	Exception)rW   ÚaccountÚrulesÚstatsrN   rÃ   ÚstubsÚstubÚmidrÌ   ÚexcÚresultr�   rˆ   Úexistsr“   r�   rÊ   rÞ   Úleads                       r1   Úprocess_accountrð   Š  sé  € àØØØØØØñ€Eô   Ô(Øˆh‹˜1Ñ‹Øˆä Ð&7Ñ 8Ó9€EØ—M‘M€Mà‡I�I„KðÜ$ R¨¸È2ÔNˆô
 ˆØ�h‰h�t‹nÒ" ˆÙÔ(¨¨]¸CÔ@ØØˆkÓ˜aÑÓØ
�	‰	Œð	Ü'¨¨G°SÓ9ˆFô "Ø—J‘J˜yÓ)Ò/¨RØ—‘˜FÓ#Ò) rØ!Ð"3Ñ4Ø#Ð$7Ñ8Ø#Ð$7Ñ8Ø—z‘z ,Ó/Ò5°2Ø—j‘j Ó-Ò3°ô
ˆð  Ð 0Ñ1ˆà˜YÒ&Ø�)Ó Ñ!ÓÜØØ+ØØ(Ø$Ø%+Ð,BÑ%CØ(*õð à˜ZÒ'Ø�*Ó Ñ"ÓÜØØ+ØØ)Ø#Ø%+Ð,BÑ%CØ(.Ð/HÑ(Iõñ à˜YÒ&Ø�)Ó Ñ!ÓÜØØ+ØØ(Ø#Ø%+Ð,BÑ%CØ(*õñ ð —j‘j Ó.Ò4°"×;Ñ;Ó=×CÑCÓEˆ
ÙØ�(‹O˜qÑ ‹OÜØØ+ØØ&Ø#Ø%+Ð,BÑ%CØ(.Ð/HÑ(IØ*õ	ñ ð �H‰H”T—W‘WÓß‰V”D×%Ñ%×+Ñ+¨JÓ7Ó8ß‰U‹Wð 	ñ
 Ø�+Ó !Ñ#ÓÜØØ+ØØ*Ø#Ø%+Ð,BÑ%CØ(.Ð/HÑ(IØ˜q™	õ	ñ à�z‰z˜&Ó!Ò' RˆØ—*‘*˜YÓ'Ò-¨2ˆØ—:‘:˜iÓ(Ò6¨D°°#¨J×=Ñ=Ó?ˆà& w i¨rØˆið %Ø%( Eð+ð ˆ4ð	ˆð
	ÜØÜÜ!5ØŸ
™
 ;Ó/Ò5°2°zó"ð ",Ø+Ü+¨DÓ1Ü#Ÿz™z›|Ø)ØØ#Ø#(ôóˆDð< 	ˆiÓ˜AÑÓÜØØ'ØØ%ØØ!'Ð(>Ñ!?Ø$*Ð+DÑ$EØ—G‘G÷		
ðg ð| €LøôE ò Øˆh‹˜1Ñ‹ØŠðûô ò 	Ø�(‹O˜qÑ ‹OÜØØ+Ø!°·±¸Ó0DÐQSÑTØ&Ø$Ø%'Ø(*Ü˜#“hõ	õ ûð	ûôx ò 	Ø�(‹O˜qÑ ‹OÜØØ+ØØ&Ø#Ø%+Ð,BÑ%CØ(.Ð/HÑ(IÜ˜#“h˜t �nõ	õ ûð	úsC   ÁM) Â(NËAOÍ)NÎNÎ	OÎ<OÏOÏ	P Ï#2PÐP F©Úforcec               ó¨  — t        | «      }t        |«      }|s6|d   s1d}t        j                  t        j
                  «      a|adddddd|dœS ddddddddœ}t        | «      }|s>d}t        j                  t        j
                  «      a|ai dD �ci c]  }|d“Œ c}¥d|i¥S |D ]?  }t        | ||«      }	|	j                  «       D ]  \  }}
|j                  |d«      |
z   ||<   Œ ŒA d	|d
   › d|d   › d|d   › d|d   › d|d   › d|d   › �}t        j                  t        j
                  «      a|a|d
   |d   |d   |d   |d   |d   |dœS c c}w )zOProcess all connected accounts. force=True runs even if rules.enabled is False.rJ   z$Inbound mail automation is disabled.r   )rÑ   rÒ   r˜   r’   rÓ   rÔ   ÚmessagerÐ   zNo Gmail accounts connected.)rÑ   rÒ   r˜   r’   rÓ   rÔ   rô   z
processed=rÑ   z	 created=rÒ   z
 negative=r’   z	 skipped=r˜   z duplicate=rÓ   z errors=rÔ   )rX   r]   r   Únowr   Úutcr    r"   r   rð   r6   r™   )rW   rò   r@   rç   ÚsummaryÚtotalsÚaccountsÚkræ   ÚpartÚvs              r1   Úrun_inbound_pollrý   C  sÔ  € ô ˜bÓ
!€CÜ˜#Ó€EÙ˜˜yÒ)Ø8ˆÜ—|‘|¤H§L¡LÓ1ˆØ#ÐàØØØØØØñ
ð 	
ð ØØØØØØñ€Fô ˜RÓ €HÙØ0ˆÜ—|‘|¤H§L¡LÓ1ˆØ#ÐØ}Ñ!gÓhÑ!g˜A�1�a‘4Ð!gÑhÐ}ÐjsÐu|Ñ}Ð}ãˆÜ˜r 7¨EÓ2ˆØ—J‘J–L‰DˆAˆqØŸ
™
 1 aÓ(¨1Ñ,ˆF�1ŠIñ !ð ð �V˜KÑ(Ð)¨°6¸)Ñ3DÐ2Eð FØ˜:Ñ&Ð' y°¸	Ñ1BÐ0Cð DØ˜KÑ(Ð)¨°&¸Ñ2BÐ1Cð	Eð ô
 —<‘<¤§¡Ó-€LØÐà˜KÑ(Ø˜)Ñ$Ø˜)Ñ$Ø˜:Ñ&Ø˜KÑ(Ø˜Ñ"Øñð ùò is   Â
Ec                ó"  — t        | «      }t        | «      D �cg c]  }t        |«      rŒ|j                  ‘Œ }}t	        |j
                  «      t        |j                  xs d«      t        t        |t        j                  t        «       dœS c c}w )NrH   )rJ   rM   Úlast_run_atÚlast_run_summaryÚaccounts_missing_readonlyÚoauth_configuredr   )rX   r   r   rá   r[   rJ   r\   rM   r    r"   r	   Úgmail_oauth_configuredr   )rW   r@   ÚaÚmissings       r1   Úget_poll_statusr  ~  sz   € Ü
˜bÓ
!€CÜ -¨bÔ 1ÓQÑ 1˜1Ô9MÈaÕ9Pˆq�w‹wÐ 1€GÐQä˜Ÿ™Ó$Ü!$ S×%>Ñ%>Ò%EÀ#Ó!FÜ#Ü-Ø%,Ü$×;Ñ;Ü2Ó4ñð ùò Rs
   ™BªBrÕ   ©Úlimitc               ó¼   — | j                  t        «      j                  t        j                  j	                  «       «      j                  |«      j                  «       S r4   )rN   r   rO   Úprocessed_atÚdescr  r€   )rW   r  s     r1   Úlist_eventsr  Œ  s>   € à
�‰Ô"Ó#ß	‰Ô#×0Ñ0×5Ñ5Ó7Ó	8ß	‰ˆu‹ß	‰‹ð	rY   g       @)Úwait_secondsc               óš  — ddl }t        j                  st        d«      ‚t	        | «      }|st        d«      ‚t        |«      st        |j                  › d�«      ‚|j                  }t        j                  xs t        j                  xs |j                  «       }| j                  «        t        j                  t        j                  «      j                  d«      }dd|d	d › d
�ddœdd|› d�ddœg}g }|D ]Z  }	t!        «       }
||
d<   ||
d<   |	d   |
d<   |
j#                  |	d   «       t%        |
«       |j'                  |	d   |	d   d|ddœ«       Œ\ |j)                  t+        dt-        |«      «      «       t/        | d¬«      }t1        | d¬«      }|||dt3        |«      › d|› d |j5                  d!«      xs d"› �j                  «       d#œS )$zMSend 2 self-emails (spam + positive) via SMTP, then poll inbox via Gmail API.r   NzoSMTP is required for live self-test send. Configure SMTP_* in .env (Gmail API is still used to read the inbox).zNo Gmail account connected.u5    needs gmail.readonly â€” reconnect before live test.z%H%M%SÚspamzCeline, pick your brain? | QRVéüÿÿÿz7 azure.crystal.naturezAAutomated inbound filter live test (spam pattern). Please ignore.)Úkindr�   r“   r—   z[Pipeline live test z] Re: proposalu…   Yes I'm interested â€” let's talk and please share pricing for a demo.

Automated inbound filter live test (positive). Please ignore.ÚToÚFromr�   ÚSubjectr“   r  Úsmtp)r  r�   rÂ   ÚtoÚviag       @Trñ   é
   r  zSent z test emails to z via SMTP, then polled. rô   rd   )ÚsentÚpollÚeventsrô   )Útimer	   Úsmtp_configuredr   r   r   rá   Ú	smtp_fromÚ	smtp_userr)   rR   r   rõ   r   rö   Ústrftimer   Úset_contentr   r>   Úsleepr`   Úfloatrý   r  r=   r™   )rW   r  r  ræ   Úto_emailrˆ   ÚstampÚsamplesr  ÚsampleÚmsgr  r  s                r1   Úrun_live_self_testr)  •  sé  € ãä×#Ò#Üð;ó
ð 	
ô
 " "Ó%€GÙÜÐ:Ó;Ð;Ü Ô(ÜØ�}‰}ˆoÐRÐSó
ð 	
ð �}‰}€HÜ×$Ñ$ÒF¬×(:Ñ(:ÒF¸h×MÑMÓO€Jà‡I�I„Kä�L‰LœŸ™Ó&×/Ñ/°Ó9€Eð Ø7¸¸b¸c¸
°|ÐCYÐZØWñ	
ð Ø-¨e¨W°NÐCðPñ		
ð€Gð  "$€DÛˆÜ‹nˆØˆˆD‰	Ø ˆˆF‰Ø 	Ñ*ˆˆI‰Ø�‰˜˜v™Ô'Ü�3ŒØ�‰à˜v™Ø! )Ñ,Ø$(ØØñõ	
ð ð" 	‡J�JŒs�3œ˜lÓ+Ó,Ô-Ü˜B dÔ+€DÜ˜ 2Ô&€FàØØà”C˜“I�;Ð.¨x¨jÐ8PØ�x‰x˜	Ó"Ò( bÐ)ð+ç
‰%‹'ñð rY   )r-   r!   Úreturnr   )r6   r   r*  r(   )r@   r   r*  r[   )rW   r   r*  r   )r@   r   r*  údict[str, Any])rW   r   ra   r   r*  r   )re   r(   rf   r   r*  r   )r�   r(   r*  r[   )r�   r(   r“   r(   rK   r   rL   r   r:   r   rˆ   r(   r‰   r(   rŠ   zbool | Noner*  r+  )re   r(   r*  r!   )r‰   r(   rˆ   r(   r*  r(   )rK   r   r*  r(   )rW   r   rÃ   r(   rÄ   r(   r*  r[   )rW   r   rÃ   r(   rÌ   Údictr�   r(   rŽ   r[   r�   r   r‘   r   rÆ   z
int | NonerÇ   r!   r*  r   )rW   r   rç   r+  r*  zdict[str, int])rW   r   rò   r[   r*  r+  )rW   r   r*  r+  )rW   r   r  r\   r*  zlist[InboundEmailEvent])rW   r   r  r#  r*  r+  )DÚ__doc__Ú
__future__r   r$   r+   r   r   r   Útypingr   Úsqlalchemy.ormr   Ú
app.configr	   Úapp.crudr
   Úemail.messager   Úapp.email_servicer   Úapp.gmail_oauthr   r   r   r   r   r   Úapp.inbound_air   r   Ú
app.modelsr   r   r   Úapp.schemasr   ÚcompileÚIr¤   rq   ry   rT   rU   r   Ú__annotations__r;   r    r"   r2   r8   rF   rX   r]   rb   rj   r}   r‡   r¡   rª   r·   r¾   rÅ   rÎ   rð   rý   r  r  r)  © rY   r1   Ú<module>r=     s-  ðÚ Kå "ã Û 	ß -Ñ -Ý å "å Ý  Ý &å (÷÷ ÷÷ BÑ AÝ "à
ˆ"�*‰*Ð,¨b¯d©dÓ
3€ð
 �—‘ÐHÓI€Ø�2—:‘:ÐLÓMÐ òÐ òÐ ð !Ð �)Ó  ð ðÐ ð
 !%€ˆoÓ $Ø $Ð �:Ó $ó	Fóó
ó"ó*óó$ð �2—:‘:ØAØ‡D�DóÐ óBðR ØØñdàðdð ðdð ð	dð
 !ðdð !ðdð ðdð ðdð ðdð ódóNó.ó,ó&	ð* ØñØðð ðð ð	ð
 ðð ðð $ðð 'ðð ðð ðð óóBvðr 49õ 8óvð .0õ ð >Aö ErY   