Ë
    
dýj97  ã                   ó¸   — 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m	Z	m
Z
 d dl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mZ d dlmZ d dlmZ  G d	„ d
«      Zy)é    N)ÚdatetimeÚtimezone)ÚAnyÚOptional)ÚfuncÚselectÚupdate)ÚAsyncSession)ÚPlanÚSubscriptionÚPaymentOrderÚPaymentWebhookEventÚInvoiceÚRefundÚWalletÚWalletTransactionÚCouponÚCouponRedemptionÚReferralÚTenantUsage)ÚBot)ÚCustomEmojic            #       ó¾  — e Zd Zdefd„Zdee   fd„Zdede	e   fd„Z
dedefd„Zd	ej                  de	e   fd
„Z	 	 	 	 dXd	ej                  dededededede	e   de	e   de	e   defd„Zdededefd„Z	 	 	 	 dYd	ej                  dedededededede	e   de	e   de	eeef      defd„Zd ej                  de	e   fd!„Zdede	e   fd"„Zdede	e   fd#„Zd$ededefd%„Zded&ede	e   fd'„Z	 	 dZded&ed(ed)eeef   ded*e	e   defd+„Z	 	 	 d[d	ej                  d,ed-ed.ededed/ed0ed1ed2eeeef      d3ed4ed5ed6e	ej                     d e	ej                     d7e	e   def"d8„Z d	ej                  dee   fd9„Z!d\d:ej                  d	e	ej                     de	e   fd;„Z"	 	 	 d]d	ej                  d ej                  deded<ededed=e	e   d:e	ej                     de#fd>„Z$d	ej                  de%fd?„Z&	 d\d	ej                  d@e%dAededBedCedDedEe	e   de'fdF„Z(dGej                  dee'   fdH„Z)dIede	e*   fdJ„Z+dKe*de*fdL„Z,d	ej                  dMej                  d ej                  dNede-f
dO„Z.dPej                  de	e/   fdQ„Z0dRej                  de1eef   fdS„Z2dRej                  dPej                  dTede/fdU„Z3d	ej                  defdV„Z4d\d	e	ej                     defdW„Z5y)^ÚBillingRepositoryÚdbc                 ó   — || _         y ©N)r   )Úselfr   s     ú1/root/telegram-saas/modules/billing/repository.pyÚ__init__zBillingRepository.__init__   s	   € Øˆ�ó    Úreturnc              ƒ   ój  K  — | j                   j                  t        t        «      j	                  t        j
                  j                  d«      «      j                  t        j                  j                  «       «      «      ƒ d {  –—† }t        |j                  «       j                  «       «      S 7 Œ+­w)NT)r   Úexecuter   r   ÚwhereÚ	is_activeÚis_Úorder_byÚprice_amountÚascÚlistÚscalarsÚall)r   Úress     r   Úlist_active_plansz#BillingRepository.list_active_plans   st   è ø€ Ø—G‘G—O‘O¤F¬4£L×$6Ñ$6´t·~±~×7IÑ7IÈ$Ó7OÓ$P×$YÑ$YÔZ^×ZkÑZk×ZoÑZoÓZqÓ$rÓs×sˆÜ�C—K‘K“M×%Ñ%Ó'Ó(Ð(ð tús   ‚BB3ÂB1Â,B3Úplan_idc              ƒ   óÎ   K  — | j                   j                  t        t        «      j	                  t        j
                  |k(  «      «      ƒ d {  –—† }|j                  «       S 7 Œ­wr   )r   r$   r   r   r%   ÚidÚscalar_one_or_none)r   r0   r.   s      r   Úget_plan_by_idz BillingRepository.get_plan_by_id"   sH   è ø€ Ø—G‘G—O‘O¤F¬4£L×$6Ñ$6´t·w±wÀ'Ñ7IÓ$JÓK×KˆØ×%Ñ%Ó'Ð'ð Lúó   ‚AA%ÁA#ÁA%Úplanc              ƒ   óH  K  — | j                  |j                  «      ƒ d {  –—† }|rŽ|j                  j                  «       D ]*  \  }}|j	                  d«      rŒ|dk7  sŒt        |||«       Œ, | j                  j                  «       ƒ d {  –—†  | j                  j                  |«      ƒ d {  –—†  |S | j                  j                  |«       | j                  j                  «       ƒ d {  –—†  | j                  j                  |«      ƒ d {  –—†  |S 7 Œö7 Œ�7 Œl7 Œ/7 Œ­w)NÚ_r2   )
r4   r2   Ú__dict__ÚitemsÚ
startswithÚsetattrr   ÚcommitÚrefreshÚadd)r   r6   ÚexistingÚkÚvs        r   Úupsert_planzBillingRepository.upsert_plan&   sç   è ø€ Ø×,Ñ,¨T¯W©WÓ5×5ˆÙØŸ™×+Ñ+Ó-ò ,‘��1Ø—|‘| CÕ(¨Q°$«YÜ˜H a¨Õ+ð,ð —'‘'—.‘.Ó"×"Ð"Ø—'‘'—/‘/ (Ó+×+Ð+ØˆOØ�‰�‰�DÔØ�g‰g�n‰nÓ×ÐØ�g‰g�o‰o˜dÓ#×#Ð#Øˆð 6øð
 #øØ+øð 	øØ#úsc   ‚D"¡D¢7D"ÁD"Á ,D"ÂDÂ"D"Â/DÂ0>D"Ã.DÃ/"D"ÄD ÄD"ÄD"ÄD"ÄD"Ä D"Ú	tenant_idc              ƒ   óÎ   K  — | j                   j                  t        t        «      j	                  t        j
                  |k(  «      «      ƒ d {  –—† }|j                  «       S 7 Œ­wr   )r   r$   r   r   r%   rD   r3   ©r   rD   r.   s      r   Úget_tenant_subscriptionz)BillingRepository.get_tenant_subscription5   sQ   è ø€ Ø—G‘G—O‘OÜ”<Ó ×&Ñ&¤|×'=Ñ'=ÀÑ'JÓKó
÷ 
ˆð ×%Ñ%Ó'Ð'ð
úr5   NÚstatusÚcurrent_period_startÚcurrent_period_endÚgateway_providerÚtrial_startÚ	trial_endÚgrace_period_ends_atc
              ƒ   ó$  K  — t        t        j                  «       |||||||||	¬«
      }
| j                  j	                  |
«       | j                  j                  «       ƒ d {  –—†  | j                  j                  |
«      ƒ d {  –—†  |
S 7 Œ)7 Œ­w)N)
r2   rD   r0   rH   rI   rJ   rK   rL   rM   rN   )r   ÚuuidÚuuid4r   r?   r=   r>   )r   rD   r0   rH   rI   rJ   rK   rL   rM   rN   Úsubs              r   Úcreate_subscriptionz%BillingRepository.create_subscription;   s€   è ø€ ô Ü�z‰z‹|ØØØØ!5Ø1Ø-Ø#ØØ!5ô
ˆð 	�‰�‰�CÔØ�g‰g�n‰nÓ×ÐØ�g‰g�o‰o˜cÓ"×"Ð"Øˆ
ð 	øØ"úó$   ‚A BÁ"BÁ#"BÂBÂBÂBÚsubscriptionÚupdatesc              ‹   óê   K  — |j                  «       D ]  \  }}t        |||«       Œ | j                  j                  «       ƒ d {  –—†  | j                  j	                  |«      ƒ d {  –—†  |S 7 Œ)7 Œ­wr   ©r:   r<   r   r=   r>   )r   rU   rV   rA   rB   s        r   Úupdate_subscriptionz%BillingRepository.update_subscriptionX   sf   è ø€ ð
 —M‘M“Oò 	(‰DˆAˆqÜ�L ! QÕ'ð	(à�g‰g�n‰nÓ×ÐØ�g‰g�o‰o˜lÓ+×+Ð+ØÐð 	øØ+úó$   ‚AA3ÁA/Á"A3Á(A1Á)A3Á1A3Úorder_numberÚamountÚcurrencyÚproviderÚidempotency_keyÚpurposeÚgateway_order_idÚmetadata_jsonc              ƒ   ó0  K  — t        t        j                  «       ||||d|||||	|
xs i ¬«      }| j                  j	                  |«       | j                  j                  «       ƒ d {  –—†  | j                  j                  |«      ƒ d {  –—†  |S 7 Œ)7 Œ­w)NÚcreated)r2   rD   r[   r\   r]   rH   r^   r_   r`   r0   ra   rb   )r   rP   rQ   r   r?   r=   r>   )r   rD   r[   r\   r]   r^   r_   r`   r0   ra   rb   Úorders               r   Úcreate_orderzBillingRepository.create_orderd   s‹   è ø€ ô Ü�z‰z‹|ØØ%ØØØØØ+ØØØ-Ø'Ò-¨2ô
ˆð 	�‰�‰�EÔØ�g‰g�n‰nÓ×ÐØ�g‰g�o‰o˜eÓ$×$Ð$Øˆð 	øØ$ús$   ‚A&BÁ(BÁ)"BÂBÂBÂBÚorder_idc              ƒ   óÎ   K  — | j                   j                  t        t        «      j	                  t        j
                  |k(  «      «      ƒ d {  –—† }|j                  «       S 7 Œ­wr   )r   r$   r   r   r%   r2   r3   )r   rg   r.   s      r   Úget_order_by_idz!BillingRepository.get_order_by_id„   sJ   è ø€ Ø—G‘G—O‘O¤F¬<Ó$8×$>Ñ$>¼|¿¹ÐRZÑ?ZÓ$[Ó\×\ˆØ×%Ñ%Ó'Ð'ð ]úr5   c              ƒ   óÎ   K  — | j                   j                  t        t        «      j	                  t        j
                  |k(  «      «      ƒ d {  –—† }|j                  «       S 7 Œ­wr   )r   r$   r   r   r%   r_   r3   )r   r_   r.   s      r   Úget_order_by_idempotency_keyz.BillingRepository.get_order_by_idempotency_keyˆ   sL   è ø€ Ø—G‘G—O‘O¤F¬<Ó$8×$>Ñ$>¼|×?[Ñ?[Ð_nÑ?nÓ$oÓp×pˆØ×%Ñ%Ó'Ð'ð qúr5   c              ƒ   óÎ   K  — | j                   j                  t        t        «      j	                  t        j
                  |k(  «      «      ƒ d {  –—† }|j                  «       S 7 Œ­wr   )r   r$   r   r   r%   ra   r3   )r   ra   r.   s      r   Úget_order_by_gateway_order_idz/BillingRepository.get_order_by_gateway_order_idŒ   sL   è ø€ Ø—G‘G—O‘O¤F¬<Ó$8×$>Ñ$>¼|×?\Ñ?\Ð`pÑ?pÓ$qÓr×rˆØ×%Ñ%Ó'Ð'ð súr5   re   c              ‹   óê   K  — |j                  «       D ]  \  }}t        |||«       Œ | j                  j                  «       ƒ d {  –—†  | j                  j	                  |«      ƒ d {  –—†  |S 7 Œ)7 Œ­wr   rX   )r   re   rV   rA   rB   s        r   Úupdate_orderzBillingRepository.update_order�   se   è ø€ ð
 —M‘M“Oò 	!‰DˆAˆqÜ�E˜1˜aÕ ð	!à�g‰g�n‰nÓ×ÐØ�g‰g�o‰o˜eÓ$×$Ð$Øˆð 	øØ$úrZ   Úevent_idc              ƒ   óò   K  — | j                   j                  t        t        «      j	                  t        j
                  |k(  t        j                  |k(  «      «      ƒ d {  –—† }|j                  «       S 7 Œ­wr   )r   r$   r   r   r%   rK   rp   r3   )r   rK   rp   r.   s       r   Úget_webhook_eventz#BillingRepository.get_webhook_eventœ   sd   è ø€ Ø—G‘G—O‘OÜÔ&Ó'×-Ñ-Ü#×4Ñ4Ð8HÑHÜ#×,Ñ,°Ñ8óó
÷ 
ˆð ×%Ñ%Ó'Ð'ð
ús   ‚AA7Á A5Á!A7Ú
event_typeÚpayloadÚerror_messagec           	   ƒ   ó  K  — t        t        j                  «       ||||||¬«      }| j                  j	                  |«       | j                  j                  «       ƒ d {  –—†  | j                  j                  |«      ƒ d {  –—†  |S 7 Œ)7 Œ­w)N)r2   rK   rp   rs   rt   rH   ru   )r   rP   rQ   r   r?   r=   r>   )r   rK   rp   rs   rt   rH   ru   Úevents           r   Úrecord_webhook_eventz&BillingRepository.record_webhook_event¥   sw   è ø€ ô $Ü�z‰z‹|Ø-ØØ!ØØØ'ô
ˆð 	�‰�‰�EÔØ�g‰g�n‰nÓ×ÐØ�g‰g�o‰o˜eÓ$×$Ð$Øˆð 	øØ$ús$   ‚ABÁB	Á "BÂBÂBÂBÚinvoice_numberÚ
amount_dueÚamount_paidÚdue_dateÚbilling_emailÚbilling_namer:   ÚsubtotalÚ
tax_amountÚdiscount_amountÚsubscription_idÚpaid_atc              ƒ   ó~  K  — t        di dt        j                  «       “d|“d|“d|“d|“d||z
  “d|“d|“d	|“d
|“d|“d|	“d|
“d|“d|“d|“d|“d|“Ž}| j                  j	                  |«       | j                  j                  «       ƒ d {  –—†  | j                  j                  |«      ƒ d {  –—†  |S 7 Œ)7 Œ­w)Nr2   rD   ry   rz   r{   Úamount_remainingr]   rH   r|   rƒ   r}   r~   r:   r   r€   r�   r‚   rg   © )r   rP   rQ   r   r?   r=   r>   )r   rD   ry   rz   r{   r]   rH   r|   r}   r~   r:   r   r€   r�   r‚   rg   rƒ   Úinvoices                     r   Úcreate_invoicez BillingRepository.create_invoice½   s  è ø€ ô& ò 
Ü�z‰zŒ|ð
áð
ñ *ð
ñ "ð	
ñ
 $ð
ð (¨+Ò5ð
ñ ð
ñ ð
ñ ð
ñ ð
ñ (ð
ñ &ð
ñ ð
ñ ð
ñ "ð
ñ  ,ð!
ñ" ,ð#
ñ$ ð%
ˆð( 	�‰�‰�GÔØ�g‰g�n‰nÓ×ÐØ�g‰g�o‰o˜gÓ&×&Ð&Øˆð 	øØ&ús$   ‚BB=ÂB9Â"B=Â2B;Â3B=Â;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   r$   r   r   r%   rD   r(   Ú
created_atÚdescr+   r,   r-   rF   s      r   Úlist_tenant_invoicesz&BillingRepository.list_tenant_invoicesé   su   è ø€ Ø—G‘G—O‘OÜ”7‹O×!Ñ!¤'×"3Ñ"3°yÑ"@ÓA×JÑJÌ7×K]ÑK]×KbÑKbÓKdÓeó
÷ 
ˆô �C—K‘K“M×%Ñ%Ó'Ó(Ð(ð
úó   ‚A7B'Á9B%Á:,B'Ú
invoice_idc              ƒ   ó  K  — t        t        «      j                  t        j                  |k(  «      }|r"|j                  t        j                  |k(  «      }| j
                  j                  |«      ƒ d {  –—† }|j                  «       S 7 Œ­wr   )r   r   r%   r2   rD   r   r$   r3   )r   rŽ   rD   Ústmtr.   s        r   Úget_invoice_by_idz#BillingRepository.get_invoice_by_idï   sh   è ø€ Ü”g‹×$Ñ$¤W§Z¡Z°:Ñ%=Ó>ˆÙØ—:‘:œg×/Ñ/°9Ñ<Ó=ˆDØ—G‘G—O‘O DÓ)×)ˆØ×%Ñ%Ó'Ð'ð *ús   ‚A2BÁ4B	Á5BÚreasonÚgateway_refund_idc
              ƒ   ó$  K  — t        t        j                  «       |||	||||||¬«
      }
| j                  j	                  |
«       | j                  j                  «       ƒ d {  –—†  | j                  j                  |
«      ƒ d {  –—†  |
S 7 Œ)7 Œ­w)N)
r2   rD   rg   rŽ   r\   r]   r’   rH   r^   r“   )r   rP   rQ   r   r?   r=   r>   )r   rD   rg   r\   r]   r’   r^   rH   r“   rŽ   Úrefunds              r   Úcreate_refundzBillingRepository.create_refund÷   s€   è ø€ ô Ü�z‰z‹|ØØØ!ØØØØØØ/ô
ˆð 	�‰�‰�FÔØ�g‰g�n‰nÓ×ÐØ�g‰g�o‰o˜fÓ%×%Ð%Øˆð 	øØ%úrT   c              ƒ   óü  K  — | j                   j                  t        t        «      j	                  t        j
                  |k(  «      j                  «       «      ƒ d {  –—† }|j                  «       }|s�t        t        j                  «       |dd¬«      }| j                   j                  |«       | j                   j                  «       ƒ d {  –—†  | j                   j                  |«      ƒ d {  –—†  |S 7 Œ™7 Œ+7 Œ
­w)Nr   ÚINR)r2   rD   Úbalancer]   )r   r$   r   r   r%   rD   Úwith_for_updater3   rP   rQ   r?   r=   r>   )r   rD   r.   Úwallets       r   Úget_or_create_walletz&BillingRepository.get_or_create_wallet  sµ   è ø€ Ø—G‘G—O‘O¤F¬6£N×$8Ñ$8¼×9IÑ9IÈYÑ9VÓ$W×$gÑ$gÓ$iÓj×jˆØ×'Ñ'Ó)ˆÙÜœtŸz™z›|°yÈ!ÐV[Ô\ˆFØ�G‰G�K‰K˜ÔØ—'‘'—.‘.Ó"×"Ð"Ø—'‘'—/‘/ &Ó)×)Ð)Øˆð køð
 #øØ)ús7   ‚AC<ÁC6ÁA/C<ÃC8Ã"C<Ã/C:Ã0C<Ã8C<Ã:C<r›   Útransaction_typeÚbalance_afterÚreference_typeÚdescriptionÚreference_idc	              ƒ   ó@  K  — t        j                  t        j                  «      j	                  «       }	|j
                  › d|› d|› d|› d|	› �	}
t        j                  |
j                  d«      «      j                  «       }t        t        j                  «       ||j
                  |||||||¬«
      }||_        | j                  j                  |«       | j                  j!                  «       ƒ d {  –—†  | j                  j#                  |«      ƒ d {  –—†  |S 7 Œ)7 Œ­w)Nú:zutf-8)
r2   rD   Ú	wallet_idr�   r\   rž   rŸ   r¡   r    Úchecksum)r   Únowr   ÚutcÚ	isoformatr2   ÚhashlibÚsha256ÚencodeÚ	hexdigestr   rP   rQ   r™   r   r?   r=   r>   )r   rD   r›   r�   r\   rž   rŸ   r    r¡   Únow_utcÚchecksum_payloadr¥   Útxs                r   Úrecord_wallet_transactionz+BillingRepository.record_wallet_transaction  sô   è ø€ ô —,‘,œxŸ|™|Ó,×6Ñ6Ó8ˆØ$Ÿi™i˜[¨Ð*:Ð);¸1¸V¸HÀAÀmÀ_ÐTUÐV]ÐU^Ð_ÐÜ—>‘>Ð"2×"9Ñ"9¸'Ó"BÓC×MÑMÓOˆäÜ�z‰z‹|ØØ—i‘iØ-ØØ'Ø)Ø%Ø#Øô
ˆð 'ˆŒØ�‰�‰�BŒØ�g‰g�n‰nÓ×ÐØ�g‰g�o‰o˜bÓ!×!Ð!Øˆ	ð 	øØ!ús$   ‚C.DÃ0DÃ1"DÄDÄDÄDr¤   c              ƒ   óR  K  — | j                   j                  t        t        «      j	                  t        j
                  |k(  «      j                  t        j                  j                  «       «      «      ƒ d {  –—† }t        |j                  «       j                  «       «      S 7 Œ+­wr   )r   r$   r   r   r%   r¤   r(   rŠ   r‹   r+   r,   r-   )r   r¤   r.   s      r   Úget_wallet_transactionsz)BillingRepository.get_wallet_transactions@  sw   è ø€ Ø—G‘G—O‘OÜÔ$Ó%ß‰UÔ$×.Ñ.°)Ñ;Ó<ß‰XÔ'×2Ñ2×7Ñ7Ó9Ó:ó
÷ 
ˆô
 �C—K‘K“M×%Ñ%Ó'Ó(Ð(ð
úr�   Úcodec              ƒ   óê   K  — | j                   j                  t        t        «      j	                  t        j
                  |j                  «       k(  «      «      ƒ d {  –—† }|j                  «       S 7 Œ­wr   )r   r$   r   r   r%   r³   Úupperr3   )r   r³   r.   s      r   Úget_coupon_by_codez$BillingRepository.get_coupon_by_codeI  sN   è ø€ Ø—G‘G—O‘O¤F¬6£N×$8Ñ$8¼¿¹ÈÏ
É
ËÑ9TÓ$UÓV×VˆØ×%Ñ%Ó'Ð'ð Wús   ‚AA3ÁA1ÁA3Úcouponc              ƒ   óÖ   K  — | j                   j                  |«       | j                   j                  «       ƒ d {  –—†  | j                   j                  |«      ƒ d {  –—†  |S 7 Œ)7 Œ­wr   )r   r?   r=   r>   )r   r·   s     r   Úcreate_couponzBillingRepository.create_couponM  sN   è ø€ Ø�‰�‰�FÔØ�g‰g�n‰nÓ×ÐØ�g‰g�o‰o˜fÓ%×%Ð%Øˆð 	øØ%ús!   ‚9A)»A%¼"A)ÁA'ÁA)Á'A)Ú	coupon_idÚdiscount_appliedc              ƒ   ó   K  — t        t        j                  «       ||||¬«      }| j                  j	                  |«       | j                  j                  t        t        «      j                  t        j                  |k(  «      j                  t        j                  dz   ¬«      «      ƒ d {  –—†  | j                  j                  «       ƒ d {  –—†  | j                  j                  |«      ƒ d {  –—†  |S 7 ŒK7 Œ+7 Œ
­w)N)r2   rD   rº   rg   r»   é   )Útimes_redeemed)r   rP   rQ   r   r?   r$   r	   r   r%   r2   Úvaluesr¾   r=   r>   )r   rD   rº   rg   r»   Ú
redemptions         r   Úrecord_coupon_redemptionz*BillingRepository.record_coupon_redemptionS  sÅ   è ø€ ô &Ü�z‰z‹|ØØØØ-ô
ˆ
ð 	�‰�‰�JÔà�g‰g�o‰oÜ”6‹Nß‰U”6—9‘9 	Ñ)Ó*ß‰V¤6×#8Ñ#8¸1Ñ#<ˆVÓ=ó
÷ 	
ð 	
ð
 �g‰g�n‰nÓ×ÐØ�g‰g�o‰o˜jÓ)×)Ð)ØÐð	
øð
 	øØ)ús6   ‚B*C>Â,C8Â-!C>ÃC:Ã"C>Ã1C<Ã2C>Ã:C>Ã<C>Úreferred_tenant_idc              ƒ   óÎ   K  — | j                   j                  t        t        «      j	                  t        j
                  |k(  «      «      ƒ d {  –—† }|j                  «       S 7 Œ­wr   )r   r$   r   r   r%   rÂ   r3   )r   rÂ   r.   s      r   Úget_referral_by_referred_tenantz1BillingRepository.get_referral_by_referred_tenantm  sR   è ø€ Ø—G‘G—O‘OÜ”8Ó×"Ñ"¤8×#>Ñ#>ÐBTÑ#TÓUó
÷ 
ˆð ×%Ñ%Ó'Ð'ð
úr5   Úreferrer_tenant_idc           	   ƒ   ój  K  — | j                   j                  t        t        j                  t
        j                  «      «      j                  t
        j                  |k(  «      «      ƒ d {  –—† }|j                  «       xs d}| j                   j                  t        t        j                  t        j                  t
        j                  «      d«      «      j                  t
        j                  |k(  t
        j                  dk(  «      «      ƒ d {  –—† }|j                  «       xs d}||fS 7 ŒÃ7 Œ­w)Nr   Úrewarded)r   r$   r   r   Úcountr   r2   r%   rÅ   ÚscalarÚcoalesceÚsumÚreward_amountrH   )r   rÅ   Ú	total_resÚtotalÚrewarded_resrÇ   s         r   Úcount_tenant_referralsz(BillingRepository.count_tenant_referralss  sç   è ø€ ØŸ'™'Ÿ/™/Ü”4—:‘:œhŸk™kÓ*Ó+×1Ñ1´(×2MÑ2MÐQcÑ2cÓdó
÷ 
ˆ	ð × Ñ Ó"Ò' aˆà!ŸW™WŸ_™_Ü”4—=‘=¤§¡¬(×*@Ñ*@Ó!AÀ1ÓEÓF×LÑLÜ×+Ñ+Ð/AÑAÜ—‘ :Ñ-óó
÷ 
ˆð  ×&Ñ&Ó(Ò-¨AˆØ�hˆÐð
øð

ús%   ‚A)D3Á+D/Á,B&D3ÄD1ÄD3Ä1D3Úreferral_codec              ƒ   ó  K  — t        t        j                  «       |||d¬«      }| j                  j	                  |«       | j                  j                  «       ƒ d {  –—†  | j                  j                  |«      ƒ d {  –—†  |S 7 Œ)7 Œ­w)NÚpending)r2   rÅ   rÂ   rÑ   rH   )r   rP   rQ   r   r?   r=   r>   )r   rÅ   rÂ   rÑ   Úrefs        r   Úcreate_referralz!BillingRepository.create_referral‚  sq   è ø€ ô Ü�z‰z‹|Ø1Ø1Ø'Øô
ˆð 	�‰�‰�CÔØ�g‰g�n‰nÓ×ÐØ�g‰g�o‰o˜cÓ"×"Ð"Øˆ
ð 	øØ"ús$   ‚ABÁBÁ"BÂ B	ÂBÂ	Bc              ƒ   ó4  K  — | j                   j                  t        t        j                  t
        j                  «      «      j                  t
        j                  |k(  t
        j                  dk7  «      «      ƒ d {  –—† }|j                  «       xs dS 7 Œ­w)NÚdeletedr   )r   r$   r   r   rÈ   r   r2   r%   rD   rH   rÉ   rF   s      r   Úcount_active_botsz#BillingRepository.count_active_bots•  sm   è ø€ Ø—G‘G—O‘OÜ”4—:‘:œcŸf™fÓ%Ó&×,Ñ,Ü—‘ Ñ*Ü—
‘
˜iÑ'óó
÷ 
ˆð �z‰z‹|Ò ˜qÐ ð
ús   ‚A;BÁ=BÁ>Bc              ƒ   óÐ   K  — | j                   j                  t        t        j                  t
        j                  «      «      «      ƒ d {  –—† }|j                  «       xs dS 7 Œ­w)Nr   )r   r$   r   r   rÈ   r   r2   rÉ   rF   s      r   Úcount_custom_emojisz%BillingRepository.count_custom_emojisž  sD   è ø€ Ø—G‘G—O‘O¤F¬4¯:©:´k·n±nÓ+EÓ$FÓG×GˆØ�z‰z‹|Ò ˜qÐ ð Hús   ‚A	A&ÁA$ÁA&)ÚmanualNNN)rU   NNN)Ú	processedN)NNNr   )rÜ   NN)6Ú__name__Ú
__module__Ú__qualname__r
   r    r+   r   r/   Ústrr   r4   rC   rP   ÚUUIDr   rG   r   rS   r   rY   ÚintÚdictr   rf   ri   rk   rm   ro   r   rr   rx   r   rˆ   rŒ   r‘   r   r–   r   rœ   r   r°   r²   r   r¶   r¹   r   rÁ   r   rÄ   ÚtuplerÐ   rÕ   rØ   rÚ   r†   r!   r   r   r      sù  „ ð˜<ó ð)¨¨d©ó )ð(¨Cð (°H¸T±Nó (ð dð ¨tó ð(°t·y±yð (ÀXÈlÑE[ó (ð !)Ø*.Ø(,Ø37ñà—9‘9ðð ðð ð	ð
 'ðð %ðð ðð ˜hÑ'ðð ˜HÑ%ðð ' xÑ0ðð 
óð:	à"ð	ð ð	ð 
ó		ð( &Ø!%Ø*.Ø26ñà—9‘9ðð ðð ð	ð
 ðð ðð ðð ðð ˜#‘ðð # 3™-ðð    S¨# X¡Ñ/ðð 
óð@(¨d¯i©ið (¸HÀ\Ñ<Ró (ð(À#ð (È(ÐS_ÑJ`ó (ð(ÀCð (ÈHÐUaÑLbó (ð	àð	ð ð	ð 
ó		ð(¸ð (Àsð (ÈxÐXkÑOló (ð "Ø'+ñàðð ðð ð	ð
 �c˜3�h‘ðð ðð   ‘}ðð 
óðN 04Ø(,Ø&*ñ#*à—9‘9ð*ð ð*ð ð	*ð
 ð*ð ð*ð ð*ð ð*ð ð*ð ð*ð �D˜˜c˜‘NÑ#ð*ð ð*ð ð*ð ð*ð " $§)¡)Ñ,ð*ð  ˜4Ÿ9™9Ñ%ð!*ð" ˜(Ñ#ð#*ð$ 
ó%*ðX)°D·I±Ið )À$ÀwÁ-ó )ñ(°$·)±)ð (ÈÐQU×QZÑQZÑH[ð (ÐgoÐpwÑgxó (ð  "Ø+/Ø*.ñà—9‘9ðð —)‘)ðð ð	ð
 ðð ðð ðð ðð $ C™=ðð ˜TŸY™YÑ'ðð 
óð<°D·I±Ið À&ó ð& '+ñà—9‘9ðð ðð ð	ð
 ðð ðð ðð ðð ˜s‘mðð 
óðB)°t·y±yð )ÀTÐJ[ÑE\ó )ð(¨Sð (°X¸fÑ5Eó (ð¨&ð °Vó ðà—9‘9ðð —9‘9ðð —)‘)ð	ð
 ðð 
óð4(ÈÏ	É	ð (ÐV^Ð_gÑVhó (ð¸t¿y¹yð ÈUÐSVÐX[ÐS[É_ó ðà ŸI™Iðð !ŸI™Iðð ð	ð
 
óð&!°·±ð !¸só !ñ!°8¸D¿I¹IÑ3Fð !ÐRUô !r!   r   )r©   rP   r   r   Útypingr   r   Ú
sqlalchemyr   r   r	   Úsqlalchemy.ext.asyncior
   Úmodules.billing.modelsr   r   r   r   r   r   r   r   r   r   r   r   Úmodules.bots.modelsr   Úmodules.emojis.modelsr   r   r†   r!   r   ú<module>rë      sB   ðÛ Û ß 'ß  ß +Ñ +Ý /÷÷ ÷ ó õ $Ý -÷G!ò G!r!   