Ë
    �{þjc(  ã                   óÜ   — d dl Z d dlZd dlmZmZ d dlmZmZ d dlm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mZ d dlmZ d dlmZmZmZmZ  ee«      Z  G d„ d«      Z!y)é    N)ÚdatetimeÚtimezone)ÚAnyÚOptional)ÚAsyncSession)ÚNotFoundErrorÚQuotaExceededErrorÚValidationError)Ú
get_logger)ÚTelegramApiService)ÚEntitlementService)ÚBot)ÚBroadcastCampaignÚBroadcastRecipient)ÚBroadcastRepository)ÚCampaignResponseÚCampaignStatsResponseÚCreateCampaignRequestÚUpdateCampaignRequestc                   óà  — e Zd ZdZdefd„Zdej                  dede	fd„Z
dej                  dee	   fd„Zdej                  d	ej                  de	fd
„Zdej                  d	ej                  dede	fd„Zdej                  d	ej                  de	fd„Zdej                  d	ej                  de	fd„Zedej                  d	ej                  ddfd„«       Zdej                  d	ej                  de	fd„Zdej                  d	ej                  de	fd„Zdej                  dededeeeeeef            deeef   f
d„Zdej                  d	ej                  defd„Zddej                  dededefd„Z y)ÚBroadcastServicezZManages high-volume broadcast campaigns, rate-limiting compliance, and recipient tracking.Údbc                 óR   — || _         t        |«      | _        t        |«      | _        y ©N)r   r   Úrepor   Úentitlements)Úselfr   s     ú1/root/telegram-saas/modules/broadcasts/service.pyÚ__init__zBroadcastService.__init__   s"   € ØˆŒÜ'¨Ó+ˆŒ	Ü.¨rÓ2ˆÕó    Ú	tenant_idÚreqÚreturnc              ƒ   ó®  K  — | j                   j                  t        |j                  «      ƒ d {  –—† }|r|j                  |k7  rt        d«      ‚| j                  j                  |«      ƒ d {  –—† \  }}|j                  dk7  r(|j                  dk  rt        d|j                  › d�«      ‚| j                  j                  ||j                  |j                  |j                  |j                  xs i |j                   |j"                  |j$                  |j&                  |j(                  ¬«
      ƒ d {  –—† }t+        j,                  |«      S 7 �Œ7 Œá7 Œ­w)NzBot not found for this tenantéÿÿÿÿr   z%Broadcasts are not permitted on the 'z' plan.)
r!   Úbot_idÚtitleÚmessage_textÚtarget_filterÚinline_keyboardÚ
media_typeÚ	media_urlÚscheduled_atÚrate_limit_per_second)r   Úgetr   r&   r!   r   r   Úget_tenant_plan_and_subÚmax_broadcasts_per_monthr	   Únamer   Úcreate_campaignr'   r(   r)   r*   r+   r,   r-   r.   r   Úmodel_validate)r   r!   r"   ÚbotÚplanÚ_Úcampaigns          r   r3   z BroadcastService.create_campaign   s(  è ø€ ð —G‘G—K‘K¤ S§Z¡ZÓ0×0ˆÙ�c—m‘m yÒ0ÜÐ ?Ó@Ð@ð ×)Ñ)×AÑAÀ)ÓL×L‰ˆˆaØ×(Ñ(¨BÒ.°4×3PÑ3PÐTUÒ3UÜ$Ð'LÈTÏYÉYÈKÐW^Ð%_Ó`Ð`ð Ÿ™×2Ñ2ØØ—:‘:Ø—)‘)Ø×)Ñ)Ø×+Ñ+Ò1¨rØ×/Ñ/Ø—~‘~Ø—m‘mØ×)Ñ)Ø"%×";Ñ";ð 3ó 
÷ 
ˆô  ×.Ñ.¨xÓ8Ð8ð/ 1ùð
 Møð

ús4   ‚.E°E±>EÁ/EÁ0CEÄ4EÄ5EÅEÅEc              ƒ   ó¤   K  — | j                   j                  |«      ƒ d {  –—† }|D �cg c]  }t        j                  |«      ‘Œ c}S 7 Œ'c c}w ­wr   )r   Úlist_campaignsr   r4   )r   r!   Ú	campaignsÚcs       r   r:   zBroadcastService.list_campaigns>   sB   è ø€ ØŸ)™)×2Ñ2°9Ó=×=ˆ	Ø<EÖF°qÔ ×/Ñ/°Õ2ÒFÐFð >úÚFùs    ‚A¡A	¢AªAÁAÁAÚcampaign_idc              ƒ   óš   K  — | j                   j                  ||«      ƒ d {  –—† }|st        d«      ‚t        j                  |«      S 7 Œ&­w)NúCampaign not found)r   Úget_campaign_by_idr   r   r4   )r   r!   r=   r<   s       r   Úget_campaignzBroadcastService.get_campaignB   sE   è ø€ Ø—)‘)×.Ñ.¨{¸IÓF×FˆÙÜÐ 4Ó5Ð5Ü×.Ñ.¨qÓ1Ð1ð Gús   ‚ A¢A	£'Ac              ƒ   óZ  K  — | j                   j                  ||«      ƒ d {  –—† }|st        d«      ‚|j                  dvrt	        d|j                  › d�«      ‚|j                  d¬«      } | j                   j                  |fi |¤Žƒ d {  –—† }t        j                  |«      S 7 Œ„7 Œ­w)Nr?   ©ÚdraftÚ	scheduledz Cannot edit campaign in status 'ú'T)Úexclude_unset)	r   r@   r   Ústatusr
   Ú
model_dumpÚupdate_campaignr   r4   )r   r!   r=   r"   r<   ÚupdatesÚupdateds          r   rJ   z BroadcastService.update_campaignH   s¢   è ø€ ð —)‘)×.Ñ.¨{¸IÓF×FˆÙÜÐ 4Ó5Ð5Ø�8‰8Ð1Ñ1Ü!Ð$DÀQÇXÁXÀJÈaÐ"PÓQÐQà—.‘.¨t�.Ó4ˆØ1˜Ÿ	™	×1Ñ1°!Ñ?°wÑ?×?ˆÜ×.Ñ.¨wÓ7Ð7ð Gøð @ús"   ‚ B+¢B'£A*B+ÂB)ÂB+Â)B+c              ƒ   ó  K  — | j                   j                  ||«      ƒ d {  –—† }|st        d«      ‚|j                  dk7  rt	        d«      ‚| j                   j                  |d¬«      ƒ d {  –—† }t        j                  |«      S 7 Œe7 Œ­w)Nr?   Úrunningz$Only running campaigns can be pausedÚpaused©rH   )r   r@   r   rH   r
   rJ   r   r4   ©r   r!   r=   r<   rL   s        r   Úpause_campaignzBroadcastService.pause_campaignX   s€   è ø€ Ø—)‘)×.Ñ.¨{¸IÓF×FˆÙÜÐ 4Ó5Ð5Ø�8‰8�yÒ Ü!Ð"HÓIÐIàŸ	™	×1Ñ1°!¸HÐ1ÓE×EˆÜ×.Ñ.¨wÓ7Ð7ð Gøð Fús"   ‚ B¢B£ABÁ.B
Á/BÂ
Bc              ƒ   óÚ  K  — | j                   j                  ||«      ƒ d {  –—† }|st        d«      ‚|j                  dk7  rt	        d«      ‚| j                   j                  |d¬«      ƒ d {  –—† }	 ddlm} |j                  t        |«      t        |«      «       t        j                  |«      S 7 Œ�7 ŒF# t        $ r( t        j                  | j                  ||«      «       Y ŒIw xY w­w)Nr?   rO   z$Only paused campaigns can be resumedrN   rP   r   )Ú dispatch_broadcast_campaign_task)r   r@   r   rH   r
   rJ   Úapps.worker.tasks.broadcastsrT   ÚdelayÚstrÚ	ExceptionÚasyncioÚcreate_taskÚ_run_dispatch_isolatedr   r4   )r   r!   r=   r<   rL   rT   s         r   Úresume_campaignz BroadcastService.resume_campaignb   sÑ   è ø€ Ø—)‘)×.Ñ.¨{¸IÓF×FˆÙÜÐ 4Ó5Ð5Ø�8‰8�xÒÜ!Ð"HÓIÐIàŸ	™	×1Ñ1°!¸IÐ1ÓF×Fˆð	UÝUØ,×2Ñ2´3°y³>Ä3À{ÓCSÔTô  ×.Ñ.¨wÓ7Ð7ð Gøð Gùô
 ò 	UÜ×Ñ × ;Ñ ;¸IÀ{Ó SÖTð	UüsF   ‚ C+¢B3£AC+Á.B5Á/C+Á4*B7 ÂC+Â5C+Â7.C(Ã%C+Ã'C(Ã(C+Nc              ƒ   óÒ   K  — ddl m}  |«       4 ƒd {  –—† } | |«      }|j                  ||«      ƒ d {  –—†  d d d «      ƒd {  –—†  y 7 Œ77 Œ7 Œ	# 1 ƒd {  –—†7  sw Y   y xY w­w)Nr   )Úget_db_session)Úinfrastructure.database.sessionr^   Údispatch_campaign)Úclsr!   r=   r^   r   Úsvcs         r   r[   z'BroadcastService._run_dispatch_isolatedr   sl   è ø€ åBÙ!Ó#÷ 	@ð 	@ rÙ�b“'ˆCØ×'Ñ'¨	°;Ó?×?Ð?÷	@÷ 	@ñ 	@øà?øð	@ø÷ 	@÷ 	@ñ 	@üsS   ‚A'”A•A'˜A¶A·A»A'ÁAÁA'ÁAÁA'ÁA$ÁAÁA$Á A'c              ƒ   óè   K  — | j                   j                  ||«      ƒ d {  –—† }|st        d«      ‚| j                   j                  |d¬«      ƒ d {  –—† }t	        j
                  |«      S 7 ŒK7 Œ­w)Nr?   ÚcanceledrP   )r   r@   r   rJ   r   r4   rQ   s        r   Úcancel_campaignz BroadcastService.cancel_campaigny   sh   è ø€ Ø—)‘)×.Ñ.¨{¸IÓF×FˆÙÜÐ 4Ó5Ð5àŸ	™	×1Ñ1°!¸JÐ1ÓG×GˆÜ×.Ñ.¨wÓ7Ð7ð Gøð Hús!   ‚ A2¢A.£1A2ÁA0ÁA2Á0A2c              ƒ   óJ  K  — | j                   j                  ||«      ƒ d{  –—† }|st        d«      ‚|j                  dv r¹| j                   j	                  |j
                  |j                  «      ƒ d{  –—† }| j                   j                  |j                  |«      ƒ d{  –—†  t        j                  t        j                  «      }| j                   j                  |d|t        |«      ¬«      ƒ d{  –—†  dt        d|j                   «      z  }	 | j"                  j%                  |«      ƒ d{  –—†  |j                  d	v r�nw| j                   j'                  |j                  d
¬«      ƒ d{  –—† }|sKt        j                  t        j                  «      }| j                   j                  |d|¬«      ƒ d{  –—†  �nû|D �]ó  }| j"                  j%                  |«      ƒ d{  –—†  |j                  d	v r �n¿| j)                  |j
                  |j*                  |j,                  |j.                  ¬«      ƒ d{  –—† \  }	}
t        j                  t        j                  «      }|	r<| j                   j1                  |d|¬«      ƒ d{  –—†  |xj2                  dz  c_        n®d|
j5                  «       v ra| j                   j1                  |d|
¬«      ƒ d{  –—†  | j                   j7                  |j
                  |j*                  d¬«      ƒ d{  –—†  n&| j                   j1                  |d|
¬«      ƒ d{  –—†  |xj8                  dz  c_        |xj:                  dz  c_        | j"                  j=                  «       ƒ d{  –—†  |dkD  s�ŒÍt?        j@                  tC        |d«      «      ƒ d{  –—†  �Œö �Œª| j"                  j%                  |«      ƒ d{  –—†  tE        jF                  |«      S 7 �ŒÕ7 �Œ…7 �ŒZ7 �Œ
7 �ŒÐ7 �Œ”7 �ŒL7 �Œ$7 �ŒÑ7 �Œ†7 �Œ;7 �Œ7 Œß7 Œ•7 Œi7 ŒC­w)z™
        Gathers audience (excluding opted-out/blocked), batches dispatch adhering to rate limits,
        and tracks delivery stats and errors.
        Nr?   rC   rN   )rH   Ú
started_atÚtotal_recipientsg      ð?é   T)rO   rd   é2   )ÚlimitÚ	completed)rH   Úcompleted_at)r&   Úchat_idÚtextr*   Ú	delivered)rH   Údelivered_atÚblocked)rH   Úerror_message©Úopt_outÚfailedr   gš™™™™™©?)$r   r@   r   rH   Úget_eligible_audiencer&   r)   Úcreate_recipientsÚidr   Únowr   ÚutcrJ   ÚlenÚmaxr.   r   ÚrefreshÚget_pending_recipientsÚ _send_telegram_broadcast_messageÚtelegram_chat_idr(   r*   Úupdate_recipientÚdelivered_countÚlowerÚset_user_opt_outÚfailed_countÚ
sent_countÚcommitrY   ÚsleepÚminr   r4   )r   r!   r=   r<   Úeligible_usersrz   Údelay_between_messagesÚpending_batchÚ	recipientÚdelivery_successÚ	error_msgs              r   r`   z"BroadcastService.dispatch_campaign‚   sz  è ø€ ð —)‘)×.Ñ.¨{¸IÓF×FˆÙÜÐ 4Ó5Ð5ð �8‰8Ð-Ñ-Ø#'§9¡9×#BÑ#BÀ1Ç8Á8ÈQÏ_É_Ó#]×]ˆNØ—)‘)×-Ñ-¨a¯d©d°NÓC×CÐCÜ—,‘,œxŸ|™|Ó,ˆCØ—)‘)×+Ñ+ØØ ØÜ!$ ^Ó!4ð	 ,ó ÷ ð ð "%¤s¨1¨a×.EÑ.EÓ'FÑ!FÐàà—'‘'—/‘/ !Ó$×$Ð$Ø�x‰xÐ1Ñ1Ùà"&§)¡)×"BÑ"BÀ1Ç4Á4ÈrÐ"BÓ"R×RˆMÙ ä—l‘l¤8§<¡<Ó0�Ø—i‘i×/Ñ/°¸+ÐTWÐ/ÓX×XÐXÙà*ó K�	Ø—g‘g—o‘o aÓ(×(Ð(Ø—8‘8Ð5Ñ5Úð 59×4YÑ4YØŸ8™8Ø%×6Ñ6ØŸ™Ø$%×$5Ñ$5ð	 5Zó 5÷ /Ñ+Ð  )ô —l‘l¤8§<¡<Ó0�Ù#ØŸ)™)×4Ñ4°YÀ{ÐadÐ4Óe×eÐeØ×%Ò%¨Ñ*Ö%à  I§O¡OÓ$5Ñ5Ø"Ÿi™i×8Ñ8¸È9ÐdmÐ8Ón×nÐnà"Ÿi™i×8Ñ8¸¿¹À9×C]ÑC]ÐgkÐ8Ól×lÑlà"Ÿi™i×8Ñ8¸È8ÐclÐ8Óm×mÐmØ—N’N aÑ'•Nà—’ Ñ!•Ø—g‘g—n‘nÓ&×&Ð&ð *¨AÔ-Ü!Ÿ-™-¬Ð,BÀDÓ(IÓJ×JÒJð?Kñ ð\ �g‰g�o‰o˜aÓ × Ð Ü×.Ñ.¨qÓ1Ð1ðE Gùð ^ùØCùðùð %ùð Sùð Yùð )ùð
/ùð fùð oùàlùàmøð 'øð Køà ús*  ‚ P#¢O7£AP#Á5O:Á6-P#Â#O=Â$AP#Ã6P Ã7<P#Ä3PÄ4>P#Å2PÅ3A
P#Æ=P	Æ>*P#Ç(PÇ)AP#È>PÈ?AP#ÊPÊAP#ËPË9P#ÌPÌ&P#Ì;PÌ<AP#ÎPÎ	P#Î"P#Î5PÎ6'P#ÏP!ÏP#Ï:P#Ï=P#Ð P#ÐP#ÐP#Ð	P#ÐP#ÐP#ÐP#ÐP#ÐP#ÐP#ÐP#ÐP#Ð!P#r&   rn   ro   r*   c              ƒ   óˆ   K  — 	 y# t         $ r1}t        |«      }t        j                  d||¬«       d|fcY d}~S d}~ww xY w­w)zn
        Sends message to individual chat with error handling for blocked users or 429 flood control.
        )TÚ Úbroadcast_send_failed)rn   ÚerrorFN)rX   rW   ÚloggerÚwarning)r   r&   rn   ro   r*   ÚexcÚerrs          r   r€   z1BroadcastService._send_telegram_broadcast_messageÏ   sE   è ø€ ð	ð øÜò 	Ü�c“(ˆCÜ�N‰NÐ2¸GÈ3ˆNÔOØ˜#�:Õûð	üs$   ‚A„A…	?Ž&:´?µAº?¿Ac              ƒ   óÎ  K  — | j                   j                  ||«      ƒ d {  –—† }|st        d«      ‚| j                   j                  |j                  «      ƒ d {  –—† }|j
                  xs d}t        |j                  |z  dz  d«      }t        |j                  |j                  |j
                  |j                  |j                  ||j                  di «      ¬«      S 7 Œ¾7 Œ†­w)Nr?   ri   éd   é   Úerrors)r=   rH   rh   rƒ   r†   Údelivery_rate_pctÚerror_summary)r   r@   r   Úget_recipient_statsry   rh   Úroundrƒ   r   rH   r†   r/   )r   r!   r=   r<   ÚstatsÚtotalÚpcts          r   Úget_campaign_statsz#BroadcastService.get_campaign_statsâ   sÆ   è ø€ Ø—)‘)×.Ñ.¨{¸IÓF×FˆÙÜÐ 4Ó5Ð5à—i‘i×3Ñ3°A·D±DÓ9×9ˆØ×"Ñ"Ò' aˆÜ�Q×&Ñ&¨Ñ.°#Ñ5°qÓ9ˆä$ØŸ™Ø—8‘8Ø×/Ñ/Ø×-Ñ-ØŸ™Ø!ØŸ)™) H¨bÓ1ô
ð 	
ð Gøð :ús"   ‚ C%¢C!£9C%ÁC#ÁBC%Ã#C%Útelegram_user_idru   c              ƒ   óZ   K  — | j                   j                  |||¬«      ƒ d {  –—† S 7 Œ­w)Nrt   )r   r…   )r   r&   r¥   ru   s       r   Úhandle_user_opt_outz$BroadcastService.handle_user_opt_outõ   s*   è ø€ Ø—Y‘Y×/Ñ/°Ð8HÐRYÐ/ÓZ×ZÐZÐZús   ‚"+¤)¥+)T)!Ú__name__Ú
__module__Ú__qualname__Ú__doc__r   r   ÚuuidÚUUIDr   r   r3   Úlistr:   rA   r   rJ   rR   r\   Úclassmethodr[   re   r`   ÚintrW   r   Údictr   ÚtupleÚboolr€   r   r¤   r§   © r    r   r   r      s"  „ Ùdð3˜<ó 3ð
9à—9‘9ð9ð #ð9ð 
ó	9ð>G¨d¯i©ið G¸DÐAQÑ<Ró Gð2¨D¯I©Ið 2ÀDÇIÁIð 2ÐRbó 2ð8à—9‘9ð8ð —Y‘Yð8ð #ð	8ð
 
ó8ð 8¨d¯i©ið 8ÀdÇiÁið 8ÐTdó 8ð8¨t¯y©yð 8ÀtÇyÁyð 8ÐUeó 8ð  ð@°T·Y±Yð @ÈTÏYÉYð @Ð[_ò @ó ð@ð8¨t¯y©yð 8ÀtÇyÁyð 8ÐUeó 8ðK2à—9‘9ðK2ð —Y‘YðK2ð 
ó	K2ðZà—	‘	ðð ðð ð	ð
 " $ t¨D°°c°©NÑ';Ñ"<Ñ=ðð 
ˆt�SˆyÑ	óð&
°$·)±)ð 
È$Ï)É)ð 
ÐXmó 
ñ&[°·	±	ð [ÈSð [Ð[_ð [Ðkoô [r    r   )"rY   r¬   r   r   Útypingr   r   Úsqlalchemy.ext.asyncior   Úcore.exceptionsr   r	   r
   Úcore.loggingr   Úinfrastructure.telegram.servicer   Ú#modules.billing.entitlement_servicer   Úmodules.bots.modelsr   Úmodules.broadcasts.modelsr   r   Úmodules.broadcasts.repositoryr   Úmodules.broadcasts.schemasr   r   r   r   r¨   r•   r   r´   r    r   ú<module>r¿      sP   ðÛ Û ß 'ß  Ý /ß NÑ NÝ #Ý >Ý BÝ #ß KÝ =÷ó ñ 
�HÓ	€÷_[ò _[r    