Ë
    gýjÁ  ã                   ó|   — d dl Z d dlmZmZ d dlmZ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mZ  G d„ d	«      Zy)
é    N)ÚdatetimeÚtimezone)ÚAnyÚOptional)ÚfuncÚselectÚupdate)ÚAsyncSession)ÚBotUser)ÚBroadcastCampaignÚBroadcastRecipientc                   óf  — e Zd Zdefd„Z	 	 	 	 	 d$dej                  dej                  dededeee	f   d	e
eeeee	f            d
ede
e   de
e   dedefd„Z	 d%dej                  de
ej                     de
e   fd„Zdej                  dee   fd„Zdede	defd„Zdej                  deee	f   dee   fd„Zdej                  dee   dee   fd„Z	 d&dej                  dedee   fd„Z	 	 d'dedede
e   de
e   def
d„Zdej                  deee	f   fd „Z	 d(dej                  d!ed"edefd#„Zy))ÚBroadcastRepositoryÚdbc                 ó   — || _         y ©N)r   )Úselfr   s     ú4/root/telegram-saas/modules/broadcasts/repository.pyÚ__init__zBroadcastRepository.__init__   s	   € Øˆ�ó    NÚ	tenant_idÚbot_idÚtitleÚmessage_textÚtarget_filterÚinline_keyboardÚ
media_typeÚ	media_urlÚscheduled_atÚrate_limit_per_secondÚreturnc              ƒ   ól  K  — t        di dt        j                  «       “d|“d|“d|“dd“d|“d|“d	|“d
|“d|“d|	“d|
“dd“dd“dd“dd“Ž}| j                  j	                  |«       | j                  j                  «       ƒ d {  –—†  | j                  j                  |«      ƒ d {  –—†  |S 7 Œ)7 Œ­w)NÚidr   r   r   ÚstatusÚdraftr   r   r   r   r   r   r    Útotal_recipientsr   Ú
sent_countÚdelivered_countÚfailed_count© )r   ÚuuidÚuuid4r   ÚaddÚcommitÚrefresh)r   r   r   r   r   r   r   r   r   r   r    Úcampaigns               r   Úcreate_campaignz#BroadcastRepository.create_campaign   sþ   è ø€ ô %ò 
Ü�z‰zŒ|ð
áð
ñ ð
ñ ð	
ñ
 ð
ñ (ð
ñ &ð
ñ ,ð
ñ "ð
ñ  ð
ñ &ð
ñ #8ð
ñ ð
ñ ð
ñ ð
ñ  ð!
ˆð$ 	�‰�‰�HÔØ�g‰g�n‰nÓ×ÐØ�g‰g�o‰o˜hÓ'×'Ð'Øˆð 	øØ'ús$   ‚BB4ÂB0Â"B4Â)B2Â*B4Â2B4Úcampaign_idc              ƒ   ó  K  — t        t        «      j                  t        j                  |k(  «      }|r"|j                  t        j                  |k(  «      }| j
                  j                  |«      ƒ d {  –—† }|j                  «       S 7 Œ­wr   )r   r   Úwherer#   r   r   ÚexecuteÚscalar_one_or_none)r   r2   r   ÚstmtÚress        r   Úget_campaign_by_idz&BroadcastRepository.get_campaign_by_id2   sp   è ø€ ô
 Ô'Ó(×.Ñ.Ô/@×/CÑ/CÀ{Ñ/RÓSˆÙØ—:‘:Ô/×9Ñ9¸YÑFÓGˆDØ—G‘G—O‘O DÓ)×)ˆØ×%Ñ%Ó'Ð'ð *ús   ‚A2BÁ4B	Á5Bc              ƒ   óR  K  — | j                   j                  t        t        «      j	                  t        j
                  |k(  «      j                  t        j                  j                  «       «      «      ƒ d {  –—† }t        |j                  «       j                  «       «      S 7 Œ+­wr   )r   r5   r   r   r4   r   Úorder_byÚ
created_atÚdescÚlistÚscalarsÚall)r   r   r8   s      r   Úlist_campaignsz"BroadcastRepository.list_campaigns=   sw   è ø€ Ø—G‘G—O‘OÜÔ$Ó%ß‰UÔ$×.Ñ.°)Ñ;Ó<ß‰XÔ'×2Ñ2×7Ñ7Ó9Ó:ó
÷ 
ˆô
 �C—K‘K“M×%Ñ%Ó'Ó(Ð(ð
ús   ‚A7B'Á9B%Á:,B'r0   Úupdatesc              ‹   óð   K  — |j                  «       D ]  \  }}|€Œ	t        |||«       Œ | j                  j                  «       ƒ d {  –—†  | j                  j	                  |«      ƒ d {  –—†  |S 7 Œ)7 Œ­wr   )ÚitemsÚsetattrr   r.   r/   )r   r0   rB   ÚkÚvs        r   Úupdate_campaignz#BroadcastRepository.update_campaignE   sj   è ø€ Ø—M‘M“Oò 	(‰DˆAˆqØ‰}Ü˜ ! QÕ'ð	(ð �g‰g�n‰nÓ×ÐØ�g‰g�o‰o˜hÓ'×'Ð'Øˆð 	øØ'ús(   ‚A6œ,A6ÁA2Á	"A6Á+A4Á,A6Á4A6c              ƒ   óâ  K  — t        t        «      j                  t        j                  |k(  t        j                  j                  d«      t        j                  j                  d«      «      }|j                  d«      }|r"|j                  t        j                  |k(  «      }| j                  j                  |«      ƒ d{  –—† }t        |j                  «       j                  «       «      S 7 Œ+­w)zg
        Retrieves eligible recipient bot users, strictly enforcing opt-out and blocked flags.
        FÚlocaleN)r   r   r4   r   Ú
is_blockedÚis_Úis_opted_outÚgetÚpreferred_localer   r5   r>   r?   r@   )r   r   r   r7   Útarget_localer8   s         r   Úget_eligible_audiencez)BroadcastRepository.get_eligible_audienceN   s²   è ø€ ô ”g‹×$Ñ$Ü�N‰N˜fÑ$Ü×Ñ×"Ñ" 5Ó)Ü× Ñ ×$Ñ$ UÓ+ó
ˆð &×)Ñ)¨(Ó3ˆÙØ—:‘:œg×6Ñ6¸-ÑGÓHˆDà—G‘G—O‘O DÓ)×)ˆÜ�C—K‘K“M×%Ñ%Ó'Ó(Ð(ð *ús   ‚B?C/ÃC-Ã,C/Úusersc              ƒ   ó  K  — |D �cg c]9  }t        t        j                  «       ||j                  |j                  dd¬«      ‘Œ; }}| j
                  j                  |«       | j
                  j                  «       ƒ d {  –—†  |S c c}w 7 Œ­w)NÚpendingr   )r#   r2   Úbot_user_idÚtelegram_chat_idr$   Úattempts)r   r+   r,   r#   Útelegram_user_idr   Úadd_allr.   )r   r2   rR   ÚuÚ
recipientss        r   Úcreate_recipientsz%BroadcastRepository.create_recipientsd   s„   è ø€ ð ö

ð ô Ü—:‘:“<Ø'ØŸD™DØ!"×!3Ñ!3Ø Øöð

ˆ
ð 

ð 	�‰�‰˜
Ô#Ø�g‰g�n‰nÓ×ÐØÐùò

ð 	ús   ‚B‡>BÁ:BÁ?BÂ BÚlimitc              ƒ   ó>  K  — | j                   j                  t        t        «      j	                  t        j
                  |k(  t        j                  dk(  «      j                  |«      «      ƒ d {  –—† }t        |j                  «       j                  «       «      S 7 Œ+­w)NrT   )r   r5   r   r   r4   r2   r$   r]   r>   r?   r@   )r   r2   r]   r8   s       r   Úget_pending_recipientsz*BroadcastRepository.get_pending_recipientsx   sz   è ø€ ð
 —G‘G—O‘OÜÔ%Ó&ß‰UÜ"×.Ñ.°+Ñ=Ü"×)Ñ)¨YÑ6ó÷ ‰U�5‹\ó
÷ 
ˆô �C—K‘K“M×%Ñ%Ó'Ó(Ð(ð
ús   ‚A-BÁ/BÁ0,BÚ	recipientr$   Úerror_messageÚdelivered_atc              ƒ   ó®   K  — ||_         |xj                  dz  c_        ||_        |r||_        | j                  j                  «       ƒ d {  –—†  |S 7 Œ­w)Né   )r$   rW   ra   rb   r   r.   )r   r`   r$   ra   rb   s        r   Úupdate_recipientz$BroadcastRepository.update_recipient‡   sS   è ø€ ð "ˆ	ÔØ×Ò˜aÑÕØ"/ˆ	ÔÙØ%1ˆIÔ"Ø�g‰g�n‰nÓ×ÐØÐð 	ús   ‚A
AÁAÁAc           	   ƒ   ón  K  — | j                   j                  t        t        j                  t        j                  t        j                  «      «      j                  t        j                  |k(  «      j                  t        j                  «      «      ƒ d {  –—† }|j                  «       D �ci c]  }|d   |d   “Œ }}| j                   j                  t        t        j                  t        j                  t        j                  «      «      j                  t        j                  |k(  t        j                  j                  ddg«      «      j                  t        j                  «      «      ƒ d {  –—† }|j                  «       D �ci c]  }|d   xs d|d   “Œ }}||dœS 7 �Œc c}w 7 Œ9c c}w ­w)Nr   rd   ÚfailedÚblockedzUnknown Error)ÚcountsÚerrors)r   r5   r   r   r$   r   Úcountr#   r4   r2   Úgroup_byÚfetchallra   Úin_)r   r2   r8   Úrowri   Ú
errors_resrj   s          r   Úget_recipient_statsz'BroadcastRepository.get_recipient_stats–   sa  è ø€ Ø—G‘G—O‘OÜÔ%×,Ñ,¬d¯j©jÔ9K×9NÑ9NÓ.OÓPß‰UÔ%×1Ñ1°[Ñ@ÓAß‰XÔ(×/Ñ/Ó0ó
÷ 
ˆð
 -0¯L©L«NÖ; S�#�a‘&˜#˜a™&‘.Ð;ˆÐ;àŸ7™7Ÿ?™?ÜÔ%×3Ñ3´T·Z±ZÔ@R×@UÑ@UÓ5VÓWß‰UÜ"×.Ñ.°+Ñ=Ü"×)Ñ)×-Ñ-¨x¸Ð.CÓDó÷ ‰XÔ(×6Ñ6Ó7ó
÷ 
ˆ
ð @J×?RÑ?RÓ?TÖU¸�#�a‘&Ò+˜O¨S°©VÑ3ÐUˆÐUð Øñ
ð 	
ð#
ûò
 <ð
úò VùsC   ‚BF5ÂF&ÂF5Â.F)Â>B6F5Å4F.Å5F5ÆF0ÆF5Æ)F5Æ0F5rX   Úopt_outc              ƒ   óP  K  — | j                   j                  t        t        «      j	                  t        j
                  |k(  t        j                  |k(  «      «      ƒ d {  –—† }|j                  «       }|r*||_        | j                   j                  «       ƒ d {  –—†  yy7 ŒA7 Œ­w)NTF)
r   r5   r   r   r4   r   rX   r6   rM   r.   )r   r   rX   rr   r8   Úusers         r   Úset_user_opt_outz$BroadcastRepository.set_user_opt_out­   sŒ   è ø€ ð —G‘G—O‘OÜ”7‹O×!Ñ!Ü—‘ &Ñ(Ü×(Ñ(Ð,<Ñ<óó
÷ 
ˆð ×%Ñ%Ó'ˆÙØ 'ˆDÔØ—'‘'—.‘.Ó"×"Ð"ØØð
øð #ús$   ‚AB&Á B"Á!:B&ÂB$ÂB&Â$B&)NÚnoneNNé   r   )éd   )NN)T)Ú__name__Ú
__module__Ú__qualname__r
   r   r+   ÚUUIDÚstrÚdictr   r   r>   r   Úintr   r1   r9   rA   rH   r   rQ   r   r\   r_   re   rq   Úboolru   r*   r   r   r   r   
   s^  „ ð˜<ó ð AEØ Ø#'Ø+/Ø%'ñ"à—9‘9ð"ð —	‘	ð"ð ð	"ð
 ð"ð ˜C ˜H‘~ð"ð " $ t¨D°°c°©NÑ';Ñ"<Ñ=ð"ð ð"ð ˜C‘=ð"ð ˜xÑ(ð"ð  #ð"ð 
ó"ðN *.ñ	(à—Y‘Yð	(ð ˜DŸI™IÑ&ð	(ð 
Ð#Ñ	$ó		(ð)¨d¯i©ið )¸DÐARÑ<Só )ðÐ.?ð ÈCð ÐTeó ð)à—	‘	ð)ð ˜C ˜H‘~ð)ð 
ˆg‰ó	)ð,à—Y‘Yðð �G‰}ðð 
Ð Ñ	!ó	ð. ñ)à—Y‘Yð)ð ð)ð 
Ð Ñ	!ó	)ð& (,Ø+/ñà%ðð ðð   ‘}ð	ð
 ˜xÑ(ðð 
óð
°T·Y±Yð 
À4ÈÈSÈÁ>ó 
ð6 ñ	à—	‘	ðð ðð ð	ð
 
ôr   r   )r+   r   r   Útypingr   r   Ú
sqlalchemyr   r   r	   Úsqlalchemy.ext.asyncior
   Úmodules.bots.modelsr   Úmodules.broadcasts.modelsr   r   r   r*   r   r   ú<module>r†      s)   ðÛ ß 'ß  ß +Ñ +Ý /Ý 'ß K÷tò tr   