Ë
    ã*ôj¾   ã                  ó  — d Z ddlmZ ddlZddl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 dd
lmZmZmZ ddlmZ  G d„ de«      Zdd„Zdd„Zdd„Zdd„Z ddddœ	 	 	 	 	 	 	 	 	 	 	 	 	 dd„Z!dd„Z"ddœd d„Z#y)!zEOutbound follow-up email: Gmail API (OAuth) preferred, SMTP fallback.é    )ÚannotationsN)ÚEmailMessage)Ú
formataddr)ÚSession)Úrender_follow_up_email)Úsettings)ÚGmailAuthErrorÚGmailSendErrorÚresolve_send_accountÚsend_message)ÚEmailLogÚFollowUpÚLead)Úmark_follow_upc                  ó   — e Zd ZdZy)ÚEmailSendErrorz Raised when outbound send fails.N)Ú__name__Ú
__module__Ú__qualname__Ú__doc__© ó    ú>/var/www/html/marketing_pipleline/backend/app/email_service.pyr   r      s   „ Ú*r   r   c                ó†   — | j                   xs& t        j                  xs t        j                  xs dj	                  «       S )NÚ )Ú	our_emailr   Ú	smtp_fromÚ	smtp_userÚstrip)Úleads    r   Ú_from_addressr!      s0   € Ø�N‰NÒLœh×0Ñ0ÒL´H×4FÑ4FÒLÈ"×SÑSÓUÐUr   c                óÀ   — t        | |«      }| j                  | j                  | j                  || j                  t        | «      |d   |d   |d   |d   |d   |d   ddœS )	NÚsubjectÚtextÚhtmlÚ	day_labelÚgoalÚ
email_typeT)Úlead_idÚ	lead_codeÚcontact_nameÚfollow_up_numberÚtoÚfrom_addressr#   r$   r%   r&   r'   r(   Úwill_mark_done)r   Úidr*   r+   Úclient_emailr!   )r    Ú	fu_numberÚrendereds      r   Úpreview_follow_up_emailr4       sv   € Ü% d¨IÓ6€Hà—7‘7Ø—^‘^Ø×)Ñ)Ø%Ø×ÑÜ% dÓ+Ø˜IÑ&Ø˜Ñ Ø˜Ñ Ø˜kÑ*Ø˜Ñ Ø˜|Ñ,Øñð r   c                ó  — t         j                  st        d«      ‚t         j                  }t         j                  }t         j
                  xs d }t         j                  xs d }	 t         j                  r�t        j                  «       }t        j                  ||d¬«      5 }|j                  «        |j                  |¬«       |j                  «        |r|r|j                  ||«       |j                  | «       d d d «       y t        j                  ||d¬«      5 }|r|r|j                  ||«       |j                  | «       d d d «       y # 1 sw Y   y xY w# 1 sw Y   y xY w# t         $ r}t        t#        |«      «      |‚d }~ww xY w)NzJSMTP is not configured. Set SMTP_HOST and SMTP_FROM (or SMTP_USER) in .envé   )Útimeout)Úcontext)r   Úsmtp_configuredr   Ú	smtp_hostÚ	smtp_portr   Úsmtp_passwordÚsmtp_use_tlsÚsslÚcreate_default_contextÚsmtplibÚSMTPÚehloÚstarttlsÚloginr   Ú	ExceptionÚstr)ÚmsgÚhostÚportÚuserÚpasswordr8   ÚserverÚexcs           r   Ú
_smtp_sendrN   3   s;  € Ü×#Ò#ÜØXó
ð 	
ô ×Ñ€DÜ×Ñ€DÜ×ÑÒ% €DÜ×%Ñ%Ò-¨€Hð0Ü× Ò Ü×0Ñ0Ó2ˆGÜ—‘˜d D°"Õ5¸Ø—‘”Ø—‘¨�Ô0Ø—‘”Ù™HØ—L‘L  xÔ0Ø×#Ñ# CÔ(÷ 6Ð5ô —‘˜d D°"Õ5¸Ù™HØ—L‘L  xÔ0Ø×#Ñ# CÔ(÷ 6Ð5÷ 6Ð5ú÷ 6Ð5ûô ò 0ÜœS ›XÓ&¨CÐ/ûð0ús[   Á%<E% Â!AEÃ;E% ÄE% Ä(EÅE% ÅEÅE% ÅE% ÅE"ÅE% Å"E% Å%	FÅ.FÆFc                ó  — t         j                  xs dj                  «       j                  «       }|dvrt	        d|›d�«      ‚|dv rÁt        | |«      }|r£|r?|j                  j                  «       |j                  «       k7  r|dk(  r�t	        d|› d�«      ‚|sC|j                  d	t        |j                  j                  d
«      d   |j                  f«      «       	 t        | ||«       d|j                  › �S |dk(  rt	        d«      ‚|dv r,t         j                  rt        |«       y|dk(  rt	        d«      ‚t	        d|xs d› d�«      ‚# t        t        f$ r$}|dk(  rt	        t        |«      «      |‚Y d}~Œqd}~ww xY w)zLSend via Gmail OAuth and/or SMTP per EMAIL_PROVIDER. Returns provider label.Úauto>   rP   ÚsmtpÚgmailzInvalid EMAIL_PROVIDER=z; use auto, gmail, or smtp>   rP   rR   rR   zNo Gmail OAuth connection for ze. Connect that mailbox under Gmail accounts, or clear Our Email to use the default connected account.ÚFromÚ@r   zgmail:Nuk   No Gmail accounts connected. Open Gmail accounts â†’ Connect Gmail, or set EMAIL_PROVIDER=smtp to use SMTP.>   rP   rQ   rQ   zDSMTP is not configured. Set SMTP_* in .env or switch to Gmail OAuth.zCannot send from z	(default)zH: connect that Gmail account via OAuth, or configure SMTP as a fallback.)r   Úemail_providerr   Úlowerr   r   ÚemailÚreplace_headerr   ÚsplitÚgmail_send_messager
   r	   rF   r9   rN   )ÚdbÚ	from_addrrG   ÚproviderÚaccountrM   s         r   Ú_deliverr_   Q   s²  € ä×'Ñ'Ò1¨6×8Ñ8Ó:×@Ñ@ÓB€HàÐ0Ñ0ÜØ% h \Ð1KÐLó
ð 	
ð Ð$Ñ$Ü& r¨9Ó5ˆÙñ ˜WŸ]™]×0Ñ0Ó2°i·o±oÓ6GÒGØ˜wÒ&Ü(Ø8¸¸ð D@ð @óð ñ !Ø×&Ñ& v¬z¸7¿=¹=×;NÑ;NÈsÓ;SÐTUÑ;VÐX_×XeÑXeÐ:fÓ/gÔhðÜ& r¨7°CÔ8Ø# G§M¡M ?Ð3Ð3ð ˜Ò Ü ð:óð ð
 Ð#Ñ#Ü×#Ò#Ü�sŒOØØ�vÒÜ ØVóð ô Ø
˜IÒ4¨Ð5ð 66ð 	6óð øô) '¬Ð7ò Ø 7Ò*Ü,¬S°«XÓ6¸CÐ?äûð	ús   ÃE ÅE?ÅE:Å:E?FT)Údry_runÚtranscript_snippetÚ	mark_donec               ó~  ‡— t        ˆfd„|j                  D «       d«      }|st        d‰› d|j                  › �«      ‚t	        |‰«      }|r	i |¥dddœ¥S |d   }|st        | d«      st        d	«      ‚|j                  st        d
«      ‚|}	|	st        | d«      }
|
r|
j                  nd}	t        «       }|d   |d<   t        |	j                  d«      d   |	f«      |d<   |j                  |d<   |j                  |d   «       |j                  |d   d¬«       	 t        | |	|«      }t        |j                   ‰|j                  |	xs ||d   dd|xs ddd xs d¬«      }| j%                  |«       |r€| j)                  t*        «      j-                  t*        j.                  |j                   k(  t*        j0                  ‰k(  «      j3                  «       xs |}|j4                  dk7  rt7        |d«       |}| j'                  «        | j9                  |«       i |¥|	xs |dd||j                   |j4                  d|xr |j4                  dk(  dœ¥S # t        $ ri}t        |j                   ‰|j                  |	xs ||d   dt#        |«      |xs ddd xs d¬«      }| j%                  |«       | j'                  «        ‚ d}~ww xY w)zESend FU email (or preview). Marks FU done only after successful send.c              3  óB   •K  — | ]  }|j                   ‰k(  sŒ|–— Œ y ­w©N©Únumber)Ú.0Úfr2   s     €r   Ú	<genexpr>z'send_follow_up_email.<locals>.<genexpr>’   s   øè ø€ ÐC™/�Q¨Q¯X©X¸Ó-BŒq™/ùs   ƒ˜Nz
Follow-up z not found for lead TÚplanned)r`   Ústatusr.   zVNo from address: set lead Our Email, connect a default Gmail account, or set SMTP_FROMzLead has no client_emailr   r#   ÚSubjectrT   r   rS   ÚTor$   r%   )ÚsubtypeÚfailediô  )r)   r,   Ú
to_addressr.   r#   rl   Úerrorra   ÚsentÚdoneF)r.   r`   rl   r]   Úemail_log_idÚfollow_up_statusr/   Úmarked_done)ÚnextÚ
follow_upsÚ
ValueErrorr*   r4   r   r   r1   rW   r   r   rY   Úset_contentÚadd_alternativer_   r   r0   rF   ÚaddÚcommitÚqueryr   Úfilterr)   rg   Úone_or_nonerl   r   Úrefresh)r[   r    r2   r`   ra   rb   ÚfuÚpreviewr\   Ú	send_fromr^   rG   r]   rM   ÚlogÚfu_rows     `             r   Úsend_follow_up_emailrˆ   ˆ   sÒ  ø€ ô 
ÓC˜$Ÿ/š/ÓCÀTÓ	J€BÙÜ˜: i [Ð0DÀTÇ^Á^ÐDTÐUÓVÐVä% d¨IÓ6€GÙØ@�'Ð@ d°iÒ@Ð@à˜Ñ'€IáÔ1°"°dÔ;Üðó
ð 	
ð ×ÒÜÐ7Ó8Ð8ð €IÙÜ& r¨4Ó0ˆÙ%,�G—M’M°"ˆ	ä
‹.€CØ˜YÑ'€Cˆ	�NÜ˜iŸo™o¨cÓ2°1Ñ5°yÐAÓB€Cˆ�KØ×!Ñ!€Cˆ�IØ‡O�O�G˜F‘OÔ$Ø×Ñ˜ ™°ÐÔ8ðÜ˜B 	¨3Ó/ˆô  Ø—‘Ø"Ø×$Ñ$ØÒ+ )Ø˜	Ñ"ØØØ.Ò4°"°d°sÐ;ÒC¸tô	€Cð ‡F�Fˆ3„Kñ à�H‰H”XÓß‰V”H×$Ñ$¨¯©Ñ/´·±ÀIÑ1MÓNß‰[‹]òð ð	 	ð
 �=‰=˜FÒ"Ü˜6 6Ô*Øˆà‡I�I„KØ‡J�Jˆr„Nð
Ø
ð
à!Ò. YØØØØŸ™ØŸI™IØØ Ò8 R§Y¡Y°&Ñ%8ò
ð 
øôS ò ÜØ—G‘GØ&Ø×(Ñ(Ø"Ò/ iØ˜IÑ&ØÜ�c“(Ø 2Ò 8°b¸$¸3Ð?ÒGÀ4ô	
ˆð 	�‰ˆsŒØ
�	‰	ŒØûðús   ÄI
 É
	J<ÉA$J7Ê7J<c                óŠ   — t        | j                  D �cg c]  }|j                  dk(  sŒ|‘Œ c}d„ ¬«      }|r|d   S d S c c}w )NÚpendingc                ó   — | j                   S re   rf   )ri   s    r   Ú<lambda>z(next_pending_follow_up.<locals>.<lambda>ì   s   € �a—h’hr   )Úkeyr   )Úsortedry   rl   )r    rƒ   rŠ   s      r   Únext_pending_follow_upr�   é   sI   € ÜØ—o’oÓ@‘o�¨¯©°iÓ)?Š�oÑ@Ùô€Gñ !ˆ7�1‰:Ð* dÐ*ùò 	As
   ”A ©A é2   )Úlimitc               ó¼   — | j                  t        «      j                  t        j                  j	                  «       «      j                  |«      j                  «       S re   )r   r   Úorder_byÚ
created_atÚdescr‘   Úall)r[   r‘   s     r   Úlist_email_logsr—   ñ   s<   € à
�‰”Óß	‰”(×%Ñ%×*Ñ*Ó,Ó	-ß	‰ˆu‹ß	‰‹ð	r   )r    r   ÚreturnrF   )r    r   r2   Úintr˜   Údict)rG   r   r˜   ÚNone)r[   r   r\   rF   rG   r   r˜   rF   )r[   r   r    r   r2   r™   r`   Úboolra   z
str | Nonerb   rœ   r˜   rš   )r    r   r˜   zFollowUp | None)r[   r   r‘   r™   r˜   zlist[EmailLog])$r   Ú
__future__r   r@   r>   Úemail.messager   Úemail.utilsr   Úsqlalchemy.ormr   Úapp.agent.templatesr   Ú
app.configr   Úapp.gmail_oauthr	   r
   r   r   rZ   Ú
app.modelsr   r   r   Úapp.servicesr   rE   r   r!   r4   rN   r_   rˆ   r�   r—   r   r   r   Ú<module>r¦      sÁ   ðÙ Kå "ã Û 
Ý &Ý "å "å 6Ý ÷ó ÷ 0Ñ /Ý 'ô+�Yô +óVóó&0ó<4ðx Ø%)Øñ^Øð^à
ð^ð ð^ð
 ð^ð #ð^ð ð^ð 
ó^óB+ð 24ö r   