Ë
    ã*ôj*  ã                   ó®  — d dl mZm Z 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 d dlmZmZmZmZmZmZmZ ddddd	d
d
d
ddœ	Zdddddœdededz  dedz  dedz  dedz  dee
   fd„Zdedede
dz  fd„Zdedede
fd„Zdedee   dee
   fd„Zdede
dede
fd„Zdede
ddfd„Z dddœdeded ededz  d!edz  de	dz  fd"„Z!dedefd#„Z"dedefd$„Z#y)%é    )ÚdateÚdatetimeÚtimezone)Úor_)ÚSessionÚ
joinedload)ÚFollowUpÚLead)Ú
LeadCreateÚ
LeadUpdate)Úbuild_follow_upsÚcompute_fu_stateÚenrich_leadÚlead_sequence_statusÚmark_follow_upÚnext_lead_codeÚreschedule_follow_upsÚ	due_todayÚoverdueÚin_progressÚ	completedÚnot_started)	z	Due Todayu   Due Today âš¡ÚOverdueu   Overdue ðŸš¨zIn ProgresszAll Completedu   All Completed âœ“Ú	CompletedzNot StartedN)ÚqÚstageÚstatusÚsortÚdbr   r   r   r   Úreturnc                óÄ  — | j                  t        «      j                  t        t        j                  «      «      }|rád|j                  «       › d�}|j                  t        t        j                  j                  |«      t        j                  j                  |«      t        j                  j                  |«      t        j                  j                  |«      t        j                  j                  |«      t        j                  j                  |«      «      «      }|r'|dk7  r"|j                  t        j                  |k(  «      }|j!                  «       }t#        j$                  «       }|D �	cg c]  }	t'        |	|«      ‘Œ }
}	|r[|dvrWt(        j+                  ||j-                  «       j/                  dd«      «      }|
D �cg c]  }|j0                  xs d|k(  sŒ|‘Œ }
}|xs dj-                  «       }d|v r|
j3                  d	„ ¬
«       |
S d|v r|
j3                  d„ d¬«       |
S d|v r|
j3                  d„ d¬«       |
S |
j3                  d„ ¬
«       |
S c c}	w c c}w )NÚ%z
All Stages)zAll StatusesÚ NÚ Ú_r#   zSheet Order (Default)Úidc                 ó   — | j                   S ©N)Ú	lead_code©Úls    ú5/var/www/html/marketing_pipleline/backend/app/crud.pyÚ<lambda>zlist_leads.<locals>.<lambda>B   s   €  A§K¢Kó    ©Úkeyr   c                 ó   — | j                   S r(   )Ú
date_addedr*   s    r,   r-   zlist_leads.<locals>.<lambda>D   s   €  A§L¢Lr.   T)r0   ÚreverseÚprogressc                 ó"   — | j                   xs dS )Nr   )Úprogress_pctr*   s    r,   r-   zlist_leads.<locals>.<lambda>F   s   €  A§N¡NÒ$7°aÐ$7r.   c                 ó2   — | j                   | j                  fS r(   )Ú
sort_orderr&   r*   s    r,   r-   zlist_leads.<locals>.<lambda>H   s   €  Q§\¡\°1·4±4Ñ$8r.   )Úqueryr
   Úoptionsr   Ú
follow_upsÚstripÚfilterr   Úcontact_nameÚilikeÚclient_emailÚ	our_emailÚwebsiter)   Únotesr   Úallr   Útodayr   ÚSTATUS_FILTER_MAPÚgetÚlowerÚreplaceÚsequence_statusr   )r   r   r   r   r   r9   ÚlikeÚleadsrE   ÚleadÚenrichedr0   r+   Úsort_keys                 r,   Ú
list_leadsrP       s  € ð �H‰H”T‹N×"Ñ"¤:¬d¯o©oÓ#>Ó?€EÙØ�1—7‘7“9�+˜QÐˆØ—‘ÜÜ×!Ñ!×'Ñ'¨Ó-Ü×!Ñ!×'Ñ'¨Ó-Ü—‘×$Ñ$ TÓ*Ü—‘×"Ñ" 4Ó(Ü—‘×$Ñ$ TÓ*Ü—
‘
× Ñ  Ó&óó	
ˆñ �˜,Ò&Ø—‘œTŸZ™Z¨5Ñ0Ó1ˆà�I‰I‹K€EÜ�J‰J‹L€EÙ5:Ó;±U¨T”˜D %Õ(°U€HÐ;á�&Ð :Ñ:Ü×#Ñ# F¨F¯L©L«N×,BÑ,BÀ3ÈÓ,LÓMˆÙ'ÓL™x˜!¨A×,=Ñ,=Ò,CÀÈÓ+K’A˜xˆÐLàÒ/Ð/×6Ñ6Ó8€HØˆxÑØ�‰Ñ/ˆÔ0ð €Oð 
�8Ñ	Ø�‰Ñ0¸$ˆÔ?ð €Oð 
�xÑ	Ø�‰Ñ7ÀˆÔFð €Oð 	�‰Ñ8ˆÔ9à€Oùò! <ùò Ms   Å0IÇIÇIÚlead_idc                 óò   — | j                  t        «      j                  t        t        j                  «      «      j                  t        j                  |k(  «      j                  «       }|rt        |«      S d S r(   )	r9   r
   r:   r   r;   r=   r&   Úfirstr   )r   rQ   rM   s      r,   Úget_leadrT   M   sS   € à
�‰”‹ß	‰”œDŸO™OÓ,Ó	-ß	‰”—‘˜7Ñ"Ó	#ß	‰‹ð	 	ñ !%Œ;�tÓÐ.¨$Ð.r.   Úpayloadc                 ó  — |j                   xs dj                  «       xs t        | «      }| j                  t        «      j                  t        j                   |k(  «      j                  «       }|rt        d|› d�«      ‚t	        ||j                  |j                  |j                  |j                  |j                  |j                  xs d|j                  |j                  |j                   xs |j                  dk(  | j                  t        «      j#                  «       t%        |j                  «      ¬«      }| j'                  |«       | j)                  «        | j+                  |«       t-        t/        | |j0                  «      «      S )Nr#   ú
Lead code ú already existsúNew LeadúCall Scheduled©r)   r>   r@   rA   rB   r2   r   Ú
deal_valuerC   Úcall_scheduledr8   r;   )r)   r<   r   r9   r
   r=   rS   Ú
ValueErrorr>   r@   rA   rB   r2   r   r\   rC   r]   Úcountr   ÚaddÚcommitÚrefreshr   rT   r&   )r   rU   ÚcodeÚexistingrM   s        r,   Úcreate_leadre   W   s,  € Ø×ÑÒ# ×*Ñ*Ó,ÒB´¸rÓ0B€DØ�x‰xœ‹~×$Ñ$¤T§^¡^°tÑ%;Ó<×BÑBÓD€HÙÜ˜: d V¨?Ð;Ó<Ð<äØØ×)Ñ)Ø×)Ñ)Ø×#Ñ#Ø—‘Ø×%Ñ%Ø�m‰mÒ)˜zØ×%Ñ%Ø�m‰mØ×-Ñ-ÒR°·±ÐBRÑ1RØ—8‘8œD“>×'Ñ'Ó)Ü# G×$6Ñ$6Ó7ô€Dð ‡F�Fˆ4„LØ‡I�I„KØ‡J�JˆtÔÜ”x  D§G¡GÓ,Ó-Ð-r.   Úrowsc                 ój  ‡— |sg S | j                  t        j                  «      j                  «       D �ch c]	  \  }|sŒ|’Œ c}Š| j                  t        «      j	                  «       }g }dt
        dz  dt
        fˆfd„}t        |«      D �]_  \  }}t        |d   «      }|j                  d«      xs i }	t        j                  t        j                  «      }
|D ]7  }|	j                  |j                  «      }|dv sŒ#||_        |dk(  r|
nd|_        Œ9 t         ||j                  d	«      «      |d
   |d   |j                  d«      |j                  d«      |d   |j                  d«      xs d|j                  d«      |j                  d«      t!        |j                  d«      «      xs |j                  d«      dk(  ||z   |¬«      }| j#                  |«       |j%                  |«       �Œb | j'                  «        |D �cg c]!  }t)        t+        | |j,                  «      «      ‘Œ# c}S c c}w c c}w )uH   Bulk-create leads from normalized CSV rows. Generates FU 1â€“7 for each.Ú	preferredNr    c           	      ó@  •— | xs dj                  «       xs d }|r|‰vr‰j                  |«       |S d}‰D ]3  }	 t        |t        t	        |«      j                  d«      d   «      «      }Œ5 	 |dz  }d|d›�}|‰vr‰j                  |«       |S Œ## t        $ r Y Œew xY w)Nr#   r   Ú-éÿÿÿÿé   zL-Ú03d)r<   r`   ÚmaxÚintÚstrÚsplitr^   )rh   rc   Úmax_nÚcÚ	candidateÚexisting_codess        €r,   Úallocate_codez#import_leads.<locals>.allocate_codez   s¿   ø€ Ø’˜R×&Ñ&Ó(Ò0¨DˆÙ�D Ñ.Ø×Ñ˜tÔ$ØˆKØˆÛˆAðÜ˜E¤3¤s¨1£v§|¡|°CÓ'8¸Ñ'<Ó#=Ó>‘ð  ð
 Ø�Q‰JˆEØ˜U 3˜KÐ(ˆIØ Ñ.Ø×"Ñ" 9Ô-Ø Ð ð øô ò Ùðús   »0BÂ	BÂBr2   r;   )ÚdoneÚskippedÚpendingrw   r)   r>   r@   rA   rB   r   rY   r\   rC   r]   rZ   r[   )r9   r
   r)   rD   r_   rp   Ú	enumerater   rG   r   Únowr   ÚutcÚnumberr   Úcompleted_atÚboolr`   Úappendra   r   rT   r&   )r   rf   rc   Ú	sort_baseÚcreatedrv   ÚiÚrowr;   Úfu_status_mapr{   Úfur   rM   ru   s                 @r,   Úimport_leadsr‡   q   só  ø€ áØˆ	à*,¯(©(´4·>±>Ó*B×*FÑ*FÔ*HÓQÑ*H™w ÊD’dÐ*HÑQ€NØ—‘œ“×$Ñ$Ó&€IØ€Gð!¤ t¡ð !´õ !ô$ ˜D—/‰ˆˆ3Ü% c¨,Ñ&7Ó8ˆ
ØŸ™ Ó-Ò3°ˆÜ�l‰lœ8Ÿ<™<Ó(ˆÛˆBØ"×&Ñ& r§y¡yÓ1ˆFØÐ7Ò7Ø"�”	Ø)/°6Ò)9¡#¸t�•ð	 ô Ù# C§G¡G¨KÓ$8Ó9Ø˜^Ñ,Ø˜^Ñ,Ø—g‘g˜kÓ*Ø—G‘G˜IÓ&Ø˜<Ñ(Ø—'‘'˜'Ó"Ò0 jØ—w‘w˜|Ó,Ø—'‘'˜'Ó"Ü §¡Ð(8Ó 9Ó:ò 4Ø�w‰w�wÓÐ#3Ñ3Ø  1‘}Ø!ô
ˆð 	�‰ˆtŒØ�‰�tÖð5 "ð8 ‡I�I„KÙ;BÓC¹7°4ŒKœ  T§W¡WÓ-Õ.¸7ÑCÐCùòg Rùòf Ds   µ	H+¿H+È&H0rM   c                 ó@  — |j                  d¬«      }d|v xr |d   |j                  k7  }d|v r{|d   rv| j                  t        «      j	                  t        j
                  |d   k(  t        j                  |j                  k7  «      j                  «       }|rt        d|d   › d�«      ‚|j                  «       D ]  \  }}t        |||«       Œ d|v rd|vr|d   d	k(  |_        |rt        |«       | j                  «        t        t        | |j                  «      «      S )
NT)Úexclude_unsetr2   r)   rW   rX   r   r]   rZ   )Ú
model_dumpr2   r9   r
   r=   r)   r&   rS   r^   ÚitemsÚsetattrr]   r   ra   r   rT   )r   rM   rU   ÚdataÚdate_changedÚclashr0   Úvalues           r,   Úupdate_leadr‘   ¬   s	  € Ø×Ñ¨DÐÓ1€DØ 4Ð'ÒQ¨D°Ñ,>À$Ç/Á/Ñ,Q€LØ�dÑ˜t KÒ0à�H‰H”T‹Nß‰V”D—N‘N d¨;Ñ&7Ñ7¼¿¹ÀDÇGÁGÑ9KÓLß‰U‹Wð 	ñ
 Ü˜z¨$¨{Ñ*;Ð)<¸OÐLÓMÐMØ—j‘j–l‰
ˆˆUÜ��c˜5Õ!ð #à�$�Ð+°4Ñ7Ø" 7™mÐ/?Ñ?ˆÔÙÜ˜dÔ#Ø‡I�I„KÜ”x  D§G¡GÓ,Ó-Ð-r.   c                 óF   — | j                  |«       | j                  «        y r(   )Údeletera   )r   rM   s     r,   Údelete_leadr”   Á   s   € Ø‡I�Iˆd„OØ‡I�I…Kr.   )r   Úscheduled_dater}   r•   c                óF  — | j                  t        «      j                  t        j                  |k(  t        j                  |k(  «      j                  «       }|sy |�t        ||«       |�||_        | j                  «        | j                  |«       t        |«      |_        |S r(   )r9   r	   r=   rQ   r}   rS   r   r•   ra   rb   r   Úcomputed_state)r   rQ   r}   r   r•   r†   s         r,   Úupdate_follow_upr˜   Æ   sˆ   € ð 	�‰”Óß	‰”× Ñ  GÑ+¬X¯_©_ÀÑ-FÓ	Gß	‰‹ð ñ
 ØØÐÜ�r˜6Ô"ØÐ!Ø*ˆÔØ‡I�I„KØ‡J�Jˆr„NÜ(¨Ó,€BÔØ€Ir.   c                 ó¶  — | j                  t        «      j                  t        t        j                  «      «      j                  «       }t        j                  «       }t        |«      }dx}x}x}x}}|D ]Z  }	t        |	|«      }
|
dk(  r|dz  }n |
dk(  r|dz  }n|
dk(  r|dz  }n
|
dk(  r|dz  }|	j                  s|	j                  dk(  sŒV|dz  }Œ\ ||||||dœS )	Nr   r   rl   r   r   r   rZ   )Útotal_leadsr   r   r   r   r]   )r9   r
   r:   r   r;   rD   r   rE   Úlenr   r]   r   )r   rL   rE   Útotalr   r   r   r   r]   rM   Úseqs              r,   Ú	get_statsrž   ß   sñ   € Ø�H‰H”T‹N×"Ñ"¤:¬d¯o©oÓ#>Ó?×CÑCÓE€EÜ�J‰J‹L€EÜ�‹J€EØEFÐF€IÐF�ÐF˜+ÐF¨	°NãˆÜ" 4¨Ó/ˆØ�+ÒØ˜‰N‰IØ�IÒØ�q‰L‰GØ�MÒ!Ø˜1Ñ‰KØ�KÒØ˜‰NˆIØ×Ò $§*¡*Ð0@Ó"@Ø˜aÑ‰Nð ð ØØØ"ØØ(ñð r.   c                 ó¬  ‡— ddl mŠm} | j                  t        «      j                  t        t        j                  «      «      j                  «       }t        j                  «       }g }g }g }dt        dt        dt        dt        fˆfd„}|D ]º  }|j                  dv rŒt        |j                  D �	cg c]  }	|	j                   d	k(  sŒ|	‘Œ c}	d
„ ¬«      }
|
sŒK|
d   }	t#        |	|«      } |||	|«      }|dk(  r|j%                  |«       Œ}|dk(  r|j%                  |«       Œ”|d	k(  sŒš|	j&                  |kD  sŒª|j%                  |«       Œ¼ |j)                  d„ ¬«       |j)                  d„ ¬«       |j)                  d„ ¬«       |||dd t+        |«      t+        |«      |D �cg c]!  }|d   |d   |d   |d   |d   |d   |d   dœ‘Œ# c}dœS c c}	w c c}w )uÆ   Build the daily worklist from the Follow-up Guide.

    For each lead, only the next incomplete FU (lowest number still pending)
    appears â€” matching the sheet guide sequence FU 1 â†’ FU 7.
    r   )ÚFOLLOW_UP_GUIDEÚFOLLOW_UP_SCHEDULErM   r†   Ústater    c                 óô  •— ‰j                  |j                  i «      }| j                  | j                  | j                  | j
                  | j                  | j                  |j                  |j                  xs |j                  d«      xs d|j                  d«      xs |j                  |j                  d«      |j                  d«      |j                  d«      |j                  d«      |j                  |dœS )	NÚ	day_labelzDay ?Ú
email_typeÚgoalÚkey_ctaÚstatus_optionÚcolor)rQ   r)   r>   r@   rB   r   Úfollow_up_numberr¤   r¥   r¦   r§   r¨   Úguide_colorr•   r—   )
rG   r}   r&   r)   r>   r@   rB   r   r¤   r•   )rM   r†   r¢   Úguider    s       €r,   Úenrichzaction_queue.<locals>.enrich
  sÃ   ø€ Ø×#Ñ# B§I¡I¨rÓ2ˆà—w‘wØŸ™Ø ×-Ñ-Ø ×-Ñ-Ø—|‘|Ø—Z‘ZØ "§	¡	ØŸ™ÒJ¨¯©°;Ó)?ÒJÀ7ØŸ)™) LÓ1ÒA°R·\±\Ø—I‘I˜fÓ%Ø—y‘y Ó+Ø"ŸY™Y Ó7Ø Ÿ9™9 WÓ-Ø ×/Ñ/Ø#ñ
ð 	
r.   )ÚWonÚLostry   c                 ó   — | j                   S r(   )r}   )Úfs    r,   r-   zaction_queue.<locals>.<lambda>%  s   € ˜!Ÿ(š(r.   r/   r   Úduec                 ó   — | d   | d   fS ©Nr•   rª   © ©Úxs    r,   r-   zaction_queue.<locals>.<lambda>6  s   €  Ð"2Ñ 3°QÐ7IÑ5JÑKr.   c                 ó   — | d   | d   fS r´   rµ   r¶   s    r,   r-   zaction_queue.<locals>.<lambda>7  s   €  AÐ&6Ñ$7¸Ð;MÑ9NÑ#Or.   c                 ó   — | d   | d   fS r´   rµ   r¶   s    r,   r-   zaction_queue.<locals>.<lambda>8  s   €  Ð#3Ñ!4°aÐ8JÑ6KÑ Lr.   Né   r}   r¤   r¥   r¦   r§   r¨   r©   )r}   r¤   r¥   r¦   r§   r¨   r©   )r   rE   ÚupcomingÚoverdue_countÚtoday_countr¬   )Ú
app.configr    r¡   r9   r
   r:   r   r;   rD   r   rE   r	   rp   Údictr   Úsortedr   r   r€   r•   r   r›   )r   r¡   rL   rE   r   Útoday_itemsr»   r­   rM   r†   ry   r¢   ÚitemÚgr    s                 @r,   Úaction_queuerÄ   ü   sç  ø€ ÷ ?à�H‰H”T‹N×"Ñ"¤:¬d¯o©oÓ#>Ó?×CÑCÓE€EÜ�J‰J‹L€EØ€GØ €KØ€Hð
”Tð 
œxð 
´ð 
¼õ 
ó( ˆà�:‰:˜Ñ(ØäØŸ/š/ÓD™/�B¨R¯Y©Y¸)Ó-CŠR˜/ÑDÙ"ô
ˆñ Øð �Q‰ZˆÜ   UÓ+ˆÙ�d˜B Ó&ˆà�IÒØ�N‰N˜4Õ Ø�eŠ^Ø×Ñ˜tÕ$Ø�iÓ B×$5Ñ$5¸Ó$=Ø�O‰O˜DÕ!ð- ð0 ‡L�LÑK€LÔLØ×ÑÑOÐÔPØ‡M�MÑL€MÔMàØØ˜S˜b�MÜ˜W›Ü˜;Ó'ñ (ó
ñ (�ð ˜H™+Ø˜{™^Ø ™oØ˜&™	Ø˜Y™<Ø!" ?Ñ!3Ø˜7™óð (ñ
ñð ùò+ Eùò6
s   Â2G
ÃG
Æ!&G)$r   r   r   Ú
sqlalchemyr   Úsqlalchemy.ormr   r   Ú
app.modelsr	   r
   Úapp.schemasr   r   Úapp.servicesr   r   r   r   r   r   r   rF   rp   ÚlistrP   ro   rT   re   r¿   r‡   r‘   r”   r˜   rž   rÄ   rµ   r.   r,   Ú<module>rË      sÁ  ðß -Ñ -å ß .ç %ß .÷÷ ñ ð Ø ØØØ Ø Ø$ØØ ñ
Ð ð  ØØØò*Øð*ð ˆT�zð*ð �‰:ð	*ð
 �$‰Jð*ð �‰*ð*ð 
ˆ$�Zó*ðZ/�ð / 3ð /¨4°$©;ó /ð.�Gð . jð .°Tó .ð48D�Wð 8D D¨¡Jð 8D°4¸±:ó 8Dðv.�Gð . 4ð .°*ð .Àó .ð*�Gð  4ð ¨Dó ð Ø"&òØðàðð ðð
 �$‰Jðð ˜4‘Kðð ��_óð2�'ð ˜dó ð:O�Wð O ô Or.   