Ë
    ã*ôjh  ã                   ó8  — d dl mZmZmZmZmZ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 d dlmZ d dlmZmZ d dlmZmZ d d	lmZmZmZmZmZm Z m!Z!m"Z"m#Z#m$Z$m%Z% d d
l&m'Z'  eddg¬«      Z(e(jS                  de#¬«       ee«      fdefd„«       Z*e(jS                  de%¬«       ee«      fdefd„«       Z+e(jS                  d«       ee«      fdefd„«       Z,e(jS                  de-e!   ¬«       ed«       ed«       ed«       ed«       ee«      fde.dz  de.dz  de.dz  de.dz  def
d„«       Z/e(jS                  de!¬«       ee«      fde0defd„«       Z1e(je                  de!d ¬!«       ee«      fd"e defd#„«       Z3d$ed%e4fd&„Z5ded'e-e6   d(e-e.   d)efd*„Z7e(je                  d+e¬«       ed,«       ee«      fd$edefd-„«       Z8e(je                  d.e¬«       ed,«       ee«      fd$edefd/„«       Z9e(ju                  de!¬«       ee«      fde0d"e"defd0„«       Z;e(jy                  dd1¬2«       ee«      fde0defd3„«       Z=e(ju                  d4e¬«       ee«      fde0d5e0d"edefd6„«       Z>e(je                  d7e$¬«       ed8«       ee«      fde0d5e0d9e?defd:„«       Z@y);é    )Ú	APIRouterÚDependsÚFileÚHTTPExceptionÚQueryÚ
UploadFile)ÚSession)Úcrud)ÚFOLLOW_UP_SCHEDULEÚFOLLOW_UP_STATUSESÚNOTE_QUICK_TAGSÚPIPELINE_STAGES)Úparse_leads_upload)Úget_db)Úannotate_duplicatesÚ	summarize)ÚEmailSendErrorÚsend_follow_up_email)ÚFollowUpOutÚFollowUpUpdateÚImportPreviewOutÚImportPreviewRowÚImportResultÚ
LeadCreateÚLeadOutÚ
LeadUpdateÚMetaOutÚSendFollowUpOutÚStatsOut)Únext_lead_codez/apiÚleads)ÚprefixÚtagsz/meta)Úresponse_modelÚdbc                 óD   — t         t        t        t        t	        | «      dœS )N)ÚstagesÚfollow_up_scheduleÚfollow_up_statusesÚnote_quick_tagsr    )r   r   r   r   r    ©r%   s    ú>/var/www/html/marketing_pipleline/backend/app/routers/leads.pyÚmetar-   !   s"   € ô "Ü0Ü0Ü*Ü(¨Ó,ñð ó    z/statsc                 ó,   — t        j                  | «      S ©N)r
   Ú	get_statsr+   s    r,   Ústatsr2   ,   s   € ä�>‰>˜"ÓÐr.   z/action-queuec                 ó,   — t        j                  | «      S r0   )r
   Úaction_queuer+   s    r,   r4   r4   1   s   € ä×Ñ˜RÓ Ð r.   z/leadsNÚqÚstageÚstatusÚsortc                 ó6   — t        j                  || |||¬«      S )N)r5   r6   r7   r8   )r
   Ú
list_leads)r5   r6   r7   r8   r%   s        r,   r:   r:   6   s   € ô �?‰?˜2 ¨%¸ÀTÔJÐJr.   z/leads/{lead_id}Úlead_idc                 óN   — t        j                  || «      }|st        dd«      ‚|S ©Né”  úLead not found)r
   Úget_leadr   ©r;   r%   Úleads      r,   r@   r@   A   s(   € ä�=‰=˜˜WÓ%€DÙÜ˜CÐ!1Ó2Ð2Ø€Kr.   éÉ   )r$   Ústatus_codeÚpayloadc                 ó~   — 	 t        j                  || «      S # t        $ r}t        dt	        |«      «      |‚d }~ww xY w)Né�  )r
   Úcreate_leadÚ
ValueErrorr   Ústr)rE   r%   Úexcs      r,   rH   rH   I   s=   € ð4Ü×Ñ  GÓ,Ð,øÜò 4Ü˜C¤ S£Ó*°Ð3ûð4ús   ‚ ˜	<¡7·<ÚfileÚcontentc                 óh  — | j                   xs dj                  «       }|r.|j                  d«      s|j                  d«      st        dd«      ‚|st        dd«      ‚	 t	        ||«      \  }}||fS # t
        $ r}t        dt        |«      «      |‚d }~wt        $ r}t        dd|› �«      |‚d }~ww xY w)NÚ z.csvz.xlsxrG   z"Please upload a .csv or .xlsx filezUploaded file is emptyzCould not read spreadsheet: )ÚfilenameÚlowerÚendswithr   r   rI   rJ   Ú	Exception)rL   rM   rP   ÚrowsÚparse_errorsrK   s         r,   Ú_read_import_filerV   Q   sÀ   € Ø—‘Ò# ×*Ñ*Ó,€HÙ˜×*Ñ*¨6Ô2°h×6GÑ6GÈÔ6PÜ˜CÐ!EÓFÐFÙÜ˜CÐ!9Ó:Ð:ðPÜ/°¸'ÓBÑˆˆlð
 �ÐÐøô	 ò 4Ü˜C¤ S£Ó*°Ð3ûÜò PÜ˜CÐ#?À¸uÐ!EÓFÈCÐOûðPús$   ÁA1 Á1	B1Á:BÂB1ÂB,Â,B1rT   rU   Úreturnc                 ó�  — t        | |«      }t        |«      }|D �cg c]Í  }t        |j                  d«      |j                  d«      |j                  d«      xs d|j                  d«      xs d|j                  d«      |j                  d«      |j                  d«      |j                  d	«      |j                  d
«      |j                  d«      xs d|j                  d«      xs g ¬«      ‘ŒÏ }}t	        |d   «      }|D ]  }|j                  dd|d d d d d dœ«       Œ t        |d   |d   |d   |d   |d   ||d d ¬«      S c c}w )NÚ
row_numberÚ	lead_codeÚcontact_namerO   Úclient_emailÚ	our_emailÚwebsiteÚ
date_addedr6   Ú
deal_valuer7   ÚreadyÚissues)rY   rZ   r[   r\   r]   r^   r_   r6   r`   r7   rb   ÚwarningÚparse_notice)ÚseverityÚcodeÚmessageÚfieldrY   rZ   r[   r\   ÚtotalÚ
duplicatesÚinvalidÚwarningséd   )ri   ra   rj   rk   rl   rT   rb   )r   r   r   ÚgetÚlistÚappendr   )	r%   rT   rU   Ú	annotatedÚsummaryÚrÚpreview_rowsrb   Úmsgs	            r,   Ú_preview_payloadrv   `   sd  € Ü# B¨Ó-€IÜ˜	Ó"€Gñ óñ ˆAô 	Ø—u‘u˜\Ó*Ø—e‘e˜KÓ(ØŸ™˜~Ó.Ò4°"ØŸ™˜~Ó.Ò4°"Ø—e‘e˜KÓ(Ø—E‘E˜)Ó$Ø—u‘u˜\Ó*Ø—%‘%˜“.Ø—u‘u˜\Ó*Ø—5‘5˜“?Ò- gØ—5‘5˜“?Ò( bö	
ð ð ð ô  �'˜(Ñ#Ó$€FÛˆØ�‰à%Ø&ØØØ"Ø!Ø $Ø $ñ	õ	
ð ô Ø�gÑØ�gÑØ˜<Ñ(Ø˜	Ñ"Ø˜Ñ$ØØ�d�sˆ|ôð ùò=s   œCEz/leads/import/preview.c              ƒ   óÂ   K  — | j                  «       ƒ d {  –—† }t        | |«      \  }}|s$|rdj                  |d d «      nd}t        d|«      ‚t	        |||«      S 7 ŒF­w)Nú; é   úNo lead rows found in the filerG   )ÚreadrV   Újoinr   rv   )rL   r%   rM   rT   rU   Údetails         r,   Úpreview_leads_importr~   Œ   se   è ø€ ð
 —I‘I“K×€GÜ*¨4°Ó9Ñ€Dˆ,ÙÙ0<�—‘˜<¨¨Ð+Ô,ÐBbˆÜ˜C Ó(Ð(Ü˜B  lÓ3Ð3ð  ús   ‚A–A—AAz/leads/importc           
   ƒ   óŽ  K  — | j                  «       ƒ d {  –—† }t        | |«      \  }}|s$|rdj                  |d d «      nd}t        d|«      ‚t	        ||«      }t        |«      }|d   }|st        dd«      ‚t        j                  ||«      }	t        t        |	«      |d   |d   z   |d   |d   |d d	 |d
   d d |	¬«      S 7 Œ¬­w)Nrx   ry   rz   rG   Ú
ready_rowszRNo rows ready to import. Fix validation errors or remove duplicates and try again.rj   rk   é2   rb   rm   )ÚimportedÚskippedÚduplicates_skippedÚinvalid_skippedÚerrorsrb   r!   )
r{   rV   r|   r   r   r   r
   Úimport_leadsr   Úlen)
rL   r%   rM   rT   rU   r}   rq   rr   ra   Úcreateds
             r,   Úimport_leads_filerŠ   ™   sò   è ø€ ð
 —I‘I“K×€GÜ*¨4°Ó9Ñ€Dˆ,ÙÙ0<�—‘˜<¨¨Ð+Ô,ÐBbˆÜ˜C Ó(Ð(ä# B¨Ó-€IÜ˜	Ó"€GØ�LÑ!€EÙÜØØ`ó
ð 	
ô
 ×Ñ  EÓ*€GÜÜ�W“Ø˜Ñ%¨°	Ñ(:Ñ:Ø" <Ñ0Ø 	Ñ*Ø˜C˜RÐ Ø�xÑ   #Ð&Øôð ð!  ús   ‚C–C—B-Cc                 óÈ   — t        j                  || «      }|st        dd«      ‚	 t        j                  |||«      S # t        $ r}t        dt        |«      «      |‚d }~ww xY w)Nr>   r?   rG   )r
   r@   r   Úupdate_leadrI   rJ   )r;   rE   r%   rB   rK   s        r,   rŒ   rŒ   ¹   s`   € ä�=‰=˜˜WÓ%€DÙÜ˜CÐ!1Ó2Ð2ð4Ü×Ñ  D¨'Ó2Ð2øÜò 4Ü˜C¤ S£Ó*°Ð3ûð4ús   ¦= ½	A!ÁAÁA!éÌ   )rD   c                 óx   — t        j                  || «      }|st        dd«      ‚t        j                  ||«       y r=   )r
   r@   r   Údelete_leadrA   s      r,   r�   r�   Ä   s3   € ä�=‰=˜˜WÓ%€DÙÜ˜CÐ!1Ó2Ð2Ü×Ñ�R˜Õr.   z$/leads/{lead_id}/follow-ups/{number}Únumberc                 óª   — |dk  s|dkD  rt        dd«      ‚t        j                  || ||j                  |j                  ¬«      }|st        dd«      ‚|S )Né   é   rG   úFollow-up number must be 1-7)r7   Úscheduled_dater>   zFollow-up not found)r   r
   Úupdate_follow_upr7   r•   )r;   r�   rE   r%   Úfus        r,   r–   r–   Ì   s`   € ð �‚z�V˜a’ZÜ˜CÐ!?Ó@Ð@Ü	×	Ñ	Ø
ØØØ�~‰~Ø×-Ñ-ô
€Bñ Ü˜CÐ!6Ó7Ð7Ø€Ir.   z)/leads/{lead_id}/follow-ups/{number}/sendFÚdry_runc                 ó,  — |dk  s|dkD  rt        dd«      ‚t        j                  || «      }|st        dd«      ‚	 t        ||||¬«      }|S # t        $ r}t        dt        |«      «      |‚d	}~wt        $ r}t        dt        |«      «      |‚d	}~ww xY w)
zISend the FU email via Gmail API (OAuth) or SMTP and mark Done on success.r’   r“   rG   r”   r>   r?   )r˜   iö  N)r   r
   r@   r   r   rJ   rI   )r;   r�   r˜   r%   rB   ÚresultrK   s          r,   Úsend_follow_upr›   á   s™   € ð �‚z�V˜a’ZÜ˜CÐ!?Ó@Ð@Ü�=‰=˜˜WÓ%€DÙÜ˜CÐ!1Ó2Ð2ð4Ü% b¨$°ÀÔHˆØˆøÜò 4Ü˜C¤ S£Ó*°Ð3ûÜò 4Ü˜C¤ S£Ó*°Ð3ûð4ús#   ¼A Á	BÁA,Á,BÁ8BÂB)AÚfastapir   r   r   r   r   r   Úsqlalchemy.ormr	   Úappr
   Ú
app.configr   r   r   r   Úapp.csv_importr   Úapp.databaser   Úapp.import_validater   r   Úapp.email_servicer   r   Úapp.schemasr   r   r   r   r   r   r   r   r   r   r   Úapp.servicesr    Úrouterrn   r-   r2   r4   ro   rJ   r:   Úintr@   ÚpostrH   ÚbytesrV   Údictrv   r~   rŠ   ÚpatchrŒ   Údeleter�   r–   Úboolr›   © r.   r,   Ú<module>r¯      s¶  ðß N× NÝ "å ÷ó õ .Ý ß >ß B÷÷ ÷ ñ õ (á	˜&¨ yÔ	1€ð ‡�ˆG G€Ó,Ù˜v“ñ ˆWò ó -ðð ‡�ˆH X€Ó.Ù ›ñ ˆgò ó /ðð ‡�ˆOÓÙ& v›ñ !�Wò !ó ð!ð ‡�ˆH T¨'¡]€Ó3á˜$“KÙ˜d›Ù˜t›Ù˜T“{Ù˜&“/ñKØ
ˆT�zðKà�‰:ðKð �$‰JðKð �‰*ð	Kð
 	òKó 4ðKð ‡�Ð¨w€Ó7Ù)0°«ñ �cð ˜wò ó 8ðð ‡�ˆX g¸3€Ó?Ù3:¸6³?ñ 4˜ð 4¨ò 4ó @ð4ð˜Jð °ó ð)˜ð )¨¨T©
ð )À$ÀsÁ)ð )ÐP`ó )ðX ‡�Ð$Ð5E€ÓFá˜C“yÙ˜&“/ñ	4Ø
ð	4àò	4ó Gð	4ð ‡�ˆ_¨\€Ó:á˜C“yÙ˜&“/ñØ
ðàòó ;ðð> ‡�Ð °€Ó9ÙAHÈÃñ 4˜ð 4 zð 4°wò 4ó :ð4ð ‡�Ð!¨s€Ó3Ù,3°F«Oñ ˜ð  'ò ó 4ðð ‡�Ð4À[€ÓQñ
 ˜&“/ñ	Øðàðð ðð 	ò	ó Rðð( ‡�Ø/Ø"ð ó ñ ˜%“LÙ˜&“/ñ	4Øð4àð4ð ð4ð 	ò	4ó	ñ4r.   