Ë
    ã*ôjÛ+  ã                  ó~  — d Z ddlmZ ddlmZ ddlmZmZ ddlm	Z	 ddl
mZ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dœdddœdœZddddddide	dœddidœdœdœdœddddi e¥dddii¥dœdœdœddd di e¥dddii¥dœdœdœdd!d"di e¥d#de	dœi¥d#gd$œdœdœdd%d&di e¥d'ddii¥d'gd$œdœdœgZ G d(„ d)e«      Zd<d*„Zd=d+„Zd,d,d-dœ	 	 	 	 	 	 	 	 	 d>d.„Zd?d/„Zd,d0d,d1œ	 	 	 	 	 	 	 	 	 	 	 d@d2„Zd,d0d3œ	 	 	 	 	 	 	 	 	 dAd4„Z d0d5œ	 	 	 	 	 	 	 	 	 dBd6„Z!d0d5œ	 	 	 	 	 	 	 	 	 dCd7„Z"dDd8„Z#d0d,d9œ	 	 	 	 	 	 	 	 	 	 	 dEd:„Z$h d;£Z%y,)Fz5Agent tool implementations (plan dry-run vs execute).é    )Úannotations)Úor_)ÚSessionÚ
joinedload)ÚPIPELINE_STAGES)ÚEmailSendErrorÚnext_pending_follow_upÚpreview_follow_up_emailÚsend_follow_up_email)ÚLead)Ú
LeadUpdate)Úcrud)Úmark_follow_upÚstringz8Person name, email or lead code (e.g. 'Sarah', 'L-012').)ÚtypeÚdescriptionÚintegerz!Only if known from resolve_leads.)ÚleadÚlead_idÚfunctionÚresolve_leadszkList/find leads by name, email, code, website, stage or overdue. Use for lookups and stage/overdue batches.Úobjectr   )r   ÚenumÚboolean©ÚqueryÚstageÚoverdue_only)r   Ú
properties)Únamer   Ú
parameters)r   r   r   z;Send the next pending (or given) follow-up email to a lead.Ú	fu_numberÚmark_follow_up_donezSMark a follow-up done WITHOUT sending email (next pending FU if fu_number omitted).Úupdate_lead_stagezSet a lead's pipeline stage.r   )r   r   ÚrequiredÚappend_lead_notezAppend text to a lead's notes.Útextc                  ó$   ‡ — e Zd ZdZdˆ fd„Zˆ xZS )ÚAmbiguousLeadErroruL   ``lead`` text matched more than one lead â€” the user must be more specific.c           	     óœ   •— || _         || _        dj                  d„ |d d D «       «      }t        ‰| �  d|› dt        |«      › d|› d�«       y )Nz, c              3  ó6   K  — | ]  }|d    › d|d   › �–— Œ y­w)Ú	lead_codeÚ Úcontact_nameN© )Ú.0Úms     ú</var/www/html/marketing_pipleline/backend/app/agent/tools.pyÚ	<genexpr>z.AmbiguousLeadError.__init__.<locals>.<genexpr>l   s'   è ø€ ÐWÉ;Àa˜Q˜{™^Ð,¨A¨a°Ñ.?Ð-@ÔAÉ;ùs   ‚é   Ú'z
' matches z leads: z. Be more specific.)r   ÚmatchesÚjoinÚsuperÚ__init__Úlen)Úselfr   r6   ÚnamesÚ	__class__s       €r2   r9   zAmbiguousLeadError.__init__i   sT   ø€ ØˆŒ
ØˆŒØ—	‘	ÑWÈ7ÐSUÐTUÉ;ÓWÓWˆÜ‰Ñ˜1˜U˜G :¬c°'«l¨^¸8ÀEÀ7ÐJ]Ð^Õ_ó    )r   Ústrr6   z
list[dict])Ú__name__Ú
__module__Ú__qualname__Ú__doc__r9   Ú__classcell__)r=   s   @r2   r)   r)   f   s   ø„ ÙV÷`ñ `r>   r)   c                ó6  — |j                  d«      �t        |d   «      S t        |j                  d«      xs |j                  d«      xs d«      j                  «       }|st	        d«      ‚t        | |¬«      d   }|st	        d|› d	�«      ‚t        |«      d
kD  rs|D �cg c]L  }|j                  «       |d   j                  «       |d   j                  «       |d   j                  «       fv r|‘ŒN }}t        |«      d
k7  rt        ||«      ‚|}|d   d   S c c}w )z@Turn ``lead_id`` or free-text ``lead`` into exactly one lead id.r   r   r   Ú z+Which lead? Say a name, email or lead code.)r   ÚleadszNo lead matches 'r5   é   r.   Úclient_emailr,   r   )	ÚgetÚintr?   ÚstripÚ
ValueErrorr   r:   Úcasefoldr)   )ÚdbÚargsÚrefÚfoundr1   Úexacts         r2   Ú_resolve_lead_idrT   p   s)  € à‡x�x�	ÓÐ&Ü�4˜	‘?Ó#Ð#Ü
ˆd�h‰h�vÓÒ9 $§(¡(¨7Ó"3Ò9°rÓ
:×
@Ñ
@Ó
B€CÙÜÐFÓGÐGÜ˜" CÔ(¨Ñ1€EÙÜÐ,¨S¨E°Ð3Ó4Ð4Ü
ˆ5ƒz�A‚~ñ ó
á�Ø�|‰|‹~Ø�.Ñ!×*Ñ*Ó,¨a°Ñ.?×.HÑ.HÓ.JÈAÈkÉN×LcÑLcÓLeÐfñgò Øð 	ð 
ô ˆu‹:˜Š?Ü$ S¨%Ó0Ð0ØˆØ�‰8�IÑÐùò
s   ÂADc                óÌ   — t        | «      }| j                  | j                  | j                  | j                  | j
                  |r|j                  nd |r|j                  dœS d dœS )N)r   r,   r.   rI   r   Únext_pending_fuÚnext_pending_day)r	   Úidr,   r.   rI   r   ÚnumberÚ	day_label)r   Úpendings     r2   Ú_lead_summaryr\   ˆ   sc   € Ü$ TÓ*€Gà—7‘7Ø—^‘^Ø×)Ñ)Ø×)Ñ)Ø—‘Ù-4˜7Ÿ>š>¸$Ù18˜G×-Ñ-ñð ð ?Cñð r>   NFc               ó  — ddl m} ddlm} | j	                  t
        «      j                  t        t
        j                  «      «      }|rÓ|j                  «       rÃd|j                  «       › d�}|j                  t        t
        j                  j                  |«      t
        j                  j                  |«      t
        j                  j                  |«      t
        j                   j                  |«      t
        j"                  j                  |«      «      «      }|r@|j                  «       r0|j                  t
        j$                  |j                  «       k(  «      }|j'                  t
        j(                  t
        j*                  «      j-                  d«      j/                  «       }|j1                  «       }	g }
|D ]8  }|rt3        |«      }|r |||	«      dk7  rŒ|
j5                  t7        |«      «       Œ: t9        |
«      |
dœS )Nr   )Údate)Úcompute_fu_stateÚ%é   Úoverdue)ÚcountrG   )Údatetimer^   Úapp.servicesr_   r   r   Úoptionsr   Ú
follow_upsrL   Úfilterr   r.   ÚilikerI   r,   ÚwebsiteÚnotesr   Úorder_byÚ
sort_orderrX   ÚlimitÚallÚtodayr	   Úappendr\   r:   )rO   r   r   r   r^   r_   ÚqÚlikerG   rp   Úresultsr   r[   s                r2   r   r   •   sr  € õ å-à
�‰”‹×Ñœz¬$¯/©/Ó:Ó;€AÙ�—‘”Ø�5—;‘;“=�/ Ð#ˆØ�H‰HÜÜ×!Ñ!×'Ñ'¨Ó-Ü×!Ñ!×'Ñ'¨Ó-Ü—‘×$Ñ$ TÓ*Ü—‘×"Ñ" 4Ó(Ü—
‘
× Ñ  Ó&óó
ˆñ �—‘”Ø�H‰H”T—Z‘Z 5§;¡;£=Ñ0Ó1ˆà�J‰J”t—‘¬¯©Ó0×6Ñ6°rÓ:×>Ñ>Ó@€EØ�J‰J‹L€EØ€GÛˆÙÜ,¨TÓ2ˆGÙÑ.¨w¸Ó>À)ÒKØØ�‰”} TÓ*Õ+ð ô ˜“\¨GÑ4Ð4r>   c                óú   — | j                  t        «      j                  t        t        j                  «      «      j                  t        j                  |k(  «      j                  «       }|st        d|› d�«      ‚|S )NzLead id z
 not found)	r   r   rf   r   rg   rh   rX   ÚfirstrM   )rO   r   r   s      r2   Ú	_get_leadrw   »   s]   € à
�‰”‹ß	‰”œDŸO™OÓ,Ó	-ß	‰”—‘˜7Ñ"Ó	#ß	‰‹ð	 	ñ Ü˜8 G 9¨JÐ7Ó8Ð8Ø€Kr>   T)r"   Údry_runÚ
transcriptc               óØ   — t        | |«      }|}|€1t        |«      }|st        d|j                  › �«      ‚|j                  }|rt        ||«      }i |¥ddd|dœ¥S t        | ||d|d¬«      S )NúNo pending follow-ups for TÚplanned)rx   ÚstatusÚwill_mark_doneÚfollow_up_numberF)rx   Útranscript_snippetÚ	mark_done)rw   r	   rM   r,   rY   r
   r   )	rO   r   r"   rx   ry   r   rY   r[   Úpreviews	            r2   Útool_send_follow_up_emailrƒ   Ç   s›   € ô �R˜Ó!€DØ€FØ€~Ü(¨Ó.ˆÙÜÐ9¸$¿.¹.Ð9IÐJÓKÐKØ—‘ˆÙÜ)¨$°Ó7ˆð
Øð
àØØ"Ø &ò
ð 	
ô  Ø
ØØØØ%Øôð r>   )r"   rx   c               óÂ  ‡— t        | |«      }‰€2t        |«      }|st        d|j                  › �«      ‚|j                  Šnt        ˆfd„|j                  D «       d «      }|st        d‰› d|j                  › �«      ‚|j                  |j                  |j                  ‰|j                  dddœ}|r	i |¥ddd	œ¥S t        |d
«       | j                  «        i |¥dd
d
dœ¥S )Nr{   c              3  óB   •K  — | ]  }|j                   ‰k(  sŒ|–— Œ y ­w©N)rY   )r0   Úfr"   s     €r2   r3   z+tool_mark_follow_up_done.<locals>.<genexpr>ô   s   øè ø€ ÐG™o˜°·±¸YÓ1F”1™oùs   ƒ˜zFU z not found for r�   T)r   r,   r.   r   rZ   Úactionr~   r|   ©rx   r}   ÚdoneF)rx   r}   Úfollow_up_status)rw   r	   rM   r,   rY   Únextrg   rX   r.   rZ   r   Úcommit)rO   r   r"   rx   r   Úfur‚   s     `    r2   Útool_mark_follow_up_doner�   ê   sç   ø€ ô �R˜Ó!€DØÐÜ# DÓ)ˆÙÜÐ9¸$¿.¹.Ð9IÐJÓKÐKØ—I‘I‰	äÓG˜dŸošoÓGÈÓNˆÙÜ˜3˜y˜k¨¸¿¹Ð8HÐIÓJÐJà—7‘7Ø—^‘^Ø×)Ñ)Ø%Ø—\‘\ØØñ€Gñ Ø@�'Ð@ d°iÒ@Ð@Ü�2�vÔØ‡I�I„KØVˆgÐV %°6ÈvÒVÐVr>   )rx   c               ó&  — |t         vrt        d|› �«      ‚t        | |«      }|j                  |j                  |j
                  |j                  |dœ}|r	i |¥dddœ¥S t        j                  | |t        |¬«      «      }i |¥dd|j                  d	œ¥S )
NzInvalid stage: )r   r,   r.   Ú
from_stageÚto_stageTr|   r‰   )r   FÚupdated)rx   r}   r   )
r   rM   rw   rX   r,   r.   r   r   Úupdate_leadr   )rO   r   r   rx   r   r‚   r“   s          r2   Útool_update_lead_stager•     s¦   € ð ”OÑ#Ü˜?¨5¨'Ð2Ó3Ð3Ü�R˜Ó!€Dà—7‘7Ø—^‘^Ø×)Ñ)Ø—j‘jØñ€Gñ Ø@�'Ð@ d°iÒ@Ð@Ü×Ñ˜r 4¬¸%Ô)@ÓA€GðØ
ðàØØ—‘ò	ð r>   c               ó”  — t        | |«      }|xs dj                  «       }|st        d«      ‚|j                  |j                  |j
                  |dœ}|r	i |¥dddœ¥S |j                  xs dj                  «       }|r|› d|› �j                  «       n|}t        j                  | |t        |¬«      «      }	i |¥d	d
|	j                  dœ¥S )NrF   zNote text is empty)r   r,   r.   ÚnoteTr|   r‰   Ú
)rk   Fr“   )rx   r}   rk   )rw   rL   rM   rX   r,   r.   rk   Úrstripr   r”   r   )
rO   r   r'   rx   r   r—   r‚   ÚexistingÚ	new_notesr“   s
             r2   Útool_append_lead_noterœ     sÎ   € ô �R˜Ó!€DØŠJ�B×ÑÓ€DÙÜÐ-Ó.Ð.à—7‘7Ø—^‘^Ø×)Ñ)Øñ	€Gñ Ø@�'Ð@ d°iÒ@Ð@Ø—
‘
Ò ˜b×(Ñ(Ó*€HÙ19�8�*˜B˜t˜fÐ%×+Ñ+Ô-¸t€IÜ×Ñ˜r 4¬¸)Ô)DÓE€GØUˆgÐU %°9ÀwÇ}Á}ÒUÐUr>   c                ó    — | �t        | «      S d S r†   )rK   )Úvalues    r2   Ú_opt_intrŸ   4  s   € ØÐ*Œ3ˆu‹:Ð4°Ð4r>   )rx   ry   c          
     ó(  — |dk(  rEt        | |j                  d«      |j                  d«      t        |j                  d«      «      ¬«      S |t        vrt	        d|› �«      ‚t        | |«      }||d<   |dk(  r(t        | |t        |j                  d	«      «      ||¬
«      S |dk(  r't        | |t        |j                  d	«      «      |¬«      S |dk(  r"t        | ||j                  d«      xs d|¬«      S t        | ||j                  d«      xs d|¬«      S )Nr   r   r   r   r   zUnknown tool: r   r   r"   )r   r"   rx   ry   r#   )r   r"   rx   r$   rF   )r   r   rx   r'   )r   r'   rx   )r   rJ   ÚboolÚMUTATING_TOOLSrM   rT   rƒ   rŸ   r�   r•   rœ   )rO   r    rP   rx   ry   r   s         r2   Údispatch_toolr£   8  s.  € ð ˆÒÜØØ—(‘(˜7Ó#Ø—(‘(˜7Ó#Ü˜dŸh™h ~Ó6Ó7ô	
ð 	
ð ”>Ñ!Ü˜>¨$¨Ð0Ó1Ð1ä˜r 4Ó(€Gà€Dˆ�OØÐ%Ò%Ü(ØØÜ˜tŸx™x¨Ó4Ó5ØØ!ô
ð 	
ð Ð$Ò$Ü'Ø˜¬8°D·H±H¸[Ó4IÓ+JÐT[ô
ð 	
ð Ð"Ò"Ü%Ø˜ t§x¡x°Ó'8Ò'>¸BÈô
ð 	
ô !Ø
�G $§(¡(¨6Ó"2Ò"8°bÀ'ôð r>   >   r&   r$   r#   r   )rO   r   rP   ÚdictÚreturnrK   )r   r   r¥   r¤   )
rO   r   r   ú
str | Noner   r¦   r   r¡   r¥   r¤   )rO   r   r   rK   r¥   r   )rO   r   r   rK   r"   ú
int | Nonerx   r¡   ry   r¦   r¥   r¤   )
rO   r   r   rK   r"   r§   rx   r¡   r¥   r¤   )
rO   r   r   rK   r   r?   rx   r¡   r¥   r¤   )
rO   r   r   rK   r'   r?   rx   r¡   r¥   r¤   )r¥   r§   )rO   r   r    r?   rP   r¤   rx   r¡   ry   r¦   r¥   r¤   )&rC   Ú
__future__r   Ú
sqlalchemyr   Úsqlalchemy.ormr   r   Ú
app.configr   Úapp.email_servicer   r	   r
   r   Ú
app.modelsr   Úapp.schemasr   Úappr   re   r   Ú	_LEAD_REFÚTOOL_DEFINITIONSrM   r)   rT   r\   r   rw   rƒ   r�   r•   rœ   rŸ   r£   r¢   r/   r>   r2   Ú<module>r²      s  ðÙ ;å "å ß .å &÷ó õ Ý "Ý Ý 'ð ØQñð "Ð2UÑVñ€	ð à#ð9ð !à$ hÐ/Ø&.¸ÑHØ%+¨YÐ$7ñññ	
ñð" à*ØXà ØM ÐM¨K¸&À)Ð9LÑMññ
ñ
ð à)ð6ð !ØM ÐM¨K¸&À)Ð9LÑMññ	
ñð à'Ø9à ðØðà h¸ÑHñð %˜Iññ
ñð  à&Ø;à ØG ÐG¨F°V¸XÐ4FÑGØ#˜Hññ
ñðoCÐ ôL`˜ô `óó0
ð  ØØñ#5Øð#5ð ð#5ð ð	#5ð
 ð#5ð 
ó#5óL	ð  !ØØ!ñ Øð ð ð ð ð	 ð
 ð ð ð ð 
ó ðH ;?ÐPTñWØðWØ ðWØ-7ðWØIMðWà	óWð< ?CñØðØ ðØ),ðØ7;ðà	óð2 >BñVØðVØ ðVØ(+ðVØ6:ðVà	óVó*5ð Ø!ñ'Øð'à
ð'ð ð'ð
 ð'ð ð'ð 
ó'òV�r>   