Ë
    idýj¢  ã                   óL  — d dl Z d dlZd dlZd dlmZmZmZ d dlmZmZ d dl	m
Z
 d dlmZ d dlmZ d dlmZ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 d dlmZ 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)m*Z*m+Z+m,Z,m-Z-m.Z.m/Z/m0Z0m1Z1 d dl2m3Z3 d dl4m5Z5  ee6«      Z7 G d„ d«      Z8y)é    N)ÚdatetimeÚ	timedeltaÚtimezone)ÚAnyÚOptional)Úselect)ÚAsyncSession)Úget_settings)ÚConflictErrorÚForbiddenErrorÚNotFoundErrorÚPaymentErrorÚQuotaExceededErrorÚUnauthorizedErrorÚValidationError)Ú
get_logger)ÚGatewayFactory)ÚCouponService)ÚEntitlementService)ÚInvoiceÚPaymentOrderÚPaymentWebhookEventÚPlanÚRefundÚSubscription)ÚBillingRepository)	ÚCheckoutOrderRequestÚCheckoutOrderResponseÚInvoiceResponseÚPaymentVerificationRequestÚPaymentVerificationResponseÚPlanResponseÚRefundRequestÚRefundResponseÚSubscriptionResponse)ÚWalletService)ÚTenantc                   óÎ  — e Zd ZdZdefd„Zd%d„Zdee   fd„Z	de
j                  defd	„Zde
j                  d
edefd„Zde
j                  d
edefd„Z	 d&de
j                  dedee   defd„Z	 	 d'de
j                  dededee   def
d„Z	 d(de
j                  dededefd„Z	 d(de
j                  dedefd„Zde
j                  defd„Z	 d&dedededeeeef      deeef   f
d„Zdedeeef   ddfd„Z dedeeef   ddfd„Z!dedeeef   dd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)defd$„Z*y))ÚBillingServicezTCore enterprise billing, subscriptions, invoices, and payment orchestration service.Údbc                 ó’   — || _         t        |«      | _        t        |«      | _        t        |«      | _        t        |«      | _        y ©N)	r*   r   Úrepor   Úentitlementsr&   Úwalletsr   Úcoupons)Úselfr*   s     ú./root/telegram-saas/modules/billing/service.pyÚ__init__zBillingService.__init__3   s:   € ØˆŒÜ% bÓ)ˆŒ	Ü.¨rÓ2ˆÔÜ$ RÓ(ˆŒÜ$ RÓ(ˆ�ó    ÚreturnNc           	   ƒ   ó(  K  — t        d4i dd“dd“dd“dd“d	d
“dd“dd“dd“dd“dd“dd“dd“dd“dd“dd“dd“Žt        d4i dd“dd“dd“dd“d	d
“dd“dd “dd“dd!“dd"“dd#“dd“dd“dd“dd“dd$“Žt        d4i dd%“dd&“dd'“dd(“d	d
“dd“dd)“dd“dd“dd*“dd+“dd“dd“dd“dd“dd,“Žt        d4i dd-“dd.“dd/“dd0“d	d
“dd“dd)“dd“dd1“dd1“dd1“dd“dd“dd“dd“dd2“Žg}|D ]%  }| j                  j                  |«      ƒ d3{  –—†  Œ' y37 Œ­w)5z?Seeds the 4 standard commercial tiers if not already populated.ÚidÚfreeÚnamez	Free TierÚdescriptionz;Essential features to test and run your first Telegram bot.Úprice_amountr   ÚcurrencyÚINRÚbilling_intervalÚmonthlyÚ
trial_daysÚ	is_activeTÚmax_botsé   Úmax_broadcasts_per_monthéd   Úmax_custom_emojisé
   Ú
ai_enabledFÚadvanced_studioÚcustom_domainÚpriority_supportÚwebhook_rate_limitÚstarterzStarter Planz?Designed for creators running up to 3 bots with custom styling.i<† é   é   iÄ	  é2   é   ÚprozPro Superchargedz@Full AI integration, advanced Message Studio, and up to 10 bots.i|“ é   i¨a  iô  é<   Ú
enterprisezEnterprise Maxz=Unlimited scale, custom domain, and dedicated infrastructure.iÜA éÿÿÿÿéx   N© )r   r-   Úupsert_plan)r1   Údefault_plansÚplans      r2   Úseed_default_plansz!BillingService.seed_default_plans;   sØ  è ø€ ô ò Ùðá ðñ Zðñ ð	ñ
 ðñ "+ðñ ðñ ðñ ðñ *-ðñ #%ðñ !ðñ !&ðñ $ðñ "'ðñ  $&ð!ô$ ò Ùðá#ðñ ^ðñ #ð	ñ
 ðñ "+ðñ ðñ ðñ ðñ *.ðñ #%ðñ !ðñ !%ðñ $ðñ "'ðñ  $&ð!ô$ ò Ùðá'ðñ _ðñ $ð	ñ
 ðñ "+ðñ ðñ ðñ ðñ */ðñ #&ðñ  ðñ !%ðñ $ðñ "&ðñ  $&ð!ô$ ò Ùðá%ðñ \ðñ $ð	ñ
 ðñ "+ðñ ðñ ðñ ðñ *,ðñ #%ðñ  ðñ !%ðñ #ðñ "&ðñ  $'ð!ðoI
ˆðT "ò 	.ˆDØ—)‘)×'Ñ'¨Ó-×-Ñ-ñ	.Ø-ús   ‚DDÄDÄ	Dc              ƒ   ó   K  — | j                   j                  «       ƒ d {  –—† }|s:| j                  «       ƒ d {  –—†  | j                   j                  «       ƒ d {  –—† }|D �cg c�]  }t        di d|j                  “d|j
                  “d|j                  “d|j                  “d|j                  dk(  rd|j                  dz  d	›�nd
|j                  dz  d	›�“d|j                  “d|j                  “d|j                  “d|j                  “d|j                  “d|j                  “d|j                  “d|j                  “d|j                   “d|j"                  “d|j$                  “d|j&                  “Ž‘�Œ c}S 7 �Œ`7 �ŒI7 �Œ*c c}w ­w)Nr7   r9   r:   r;   Úprice_formattedr=   õ   â‚¹rE   ú.2fú$r<   r>   r@   rA   rB   rD   rF   rH   rI   rJ   rK   rL   rX   )r-   Úlist_active_plansr\   r"   r7   r9   r:   r;   r<   r>   r@   rA   rB   rD   rF   rH   rI   rJ   rK   rL   )r1   ÚplansÚps      r2   Ú
list_planszBillingService.list_plans‹   sª  è ø€ Ø—i‘i×1Ñ1Ó3×3ˆÙØ×)Ñ)Ó+×+Ð+ØŸ)™)×5Ñ5Ó7×7ˆEð, ÷)
ð( ô' ò Ø—4’4ðà—V’Vðð ŸMšMðð Ÿ^š^ð	ð
 EFÇJÁJÐRWÒDW # a§n¡n°sÑ&:¸3Ð%?Ñ @Ð_`Ðab×aoÑaoÐruÑauÐvyÐ`zÐ]{øðð Ÿšðð "#×!3Ò!3ðð Ÿ<š<ðð Ÿ+š+ðð Ÿšðð *+×)CÒ)Cðð #$×"5Ò"5ðð Ÿ<š<ðð !"× 1Ò 1ðð  Ÿošoðð  "#×!3Ò!3ð!ð" $%×#7Ò#7ó#ò
ð 	
ð 4ùà+ùØ7ûò
ùsD   ‚F F ¡FºF»!FÁFÁFÁ%DF	Å=FÆFÆFÆ	FÚ	tenant_idc              ƒ   óŽ  K  — | j                   j                  |«      ƒ d {  –—† \  }}t        |j                  |j                  |j
                  |j                  |j                  |j                  |j                  |j                  |j                  |j                  |j                  |j                  |j                  ¬«      S 7 Œ¡­w)N)r7   rf   Úplan_idÚ	plan_nameÚstatusÚcurrent_period_startÚcurrent_period_endÚcancel_at_period_endÚcanceled_atÚtrial_startÚ	trial_endÚgrace_period_ends_atÚgateway_provider)r.   Úget_tenant_plan_and_subr%   r7   rf   rh   r9   rj   rk   rl   rm   rn   ro   rp   rq   rr   )r1   rf   r[   Úsubs       r2   Úget_tenant_subscriptionz&BillingService.get_tenant_subscription©   s›   è ø€ Ø×+Ñ+×CÑCÀIÓN×N‰	ˆˆcÜ#Ø�v‰vØ—m‘mØ—K‘KØ—i‘iØ—:‘:Ø!$×!9Ñ!9Ø"×5Ñ5Ø!$×!9Ñ!9ØŸ™ØŸ™Ø—m‘mØ!$×!9Ñ!9Ø ×1Ñ1ô
ð 	
ð Oús   ‚C¡C¢B"CÚreqc              ƒ   ó®  K  — | j                   j                  |j                  «      ƒ d{  –—† }|st        d|j                  › d�«      ‚|j                  xs4 d|› d|j                  › dt        j                  «       j                  dd › �}| j                   j                  |«      ƒ d{  –—† }|ry|j                  dk(  rjt        |j                  |j                  |j                  d|j                  d	z  d
›�|j                  |j                  |j                   |j                  ¬«      S |j"                  }d}d}|j$                  r|| j&                  j)                  |j$                  |j                  |j"                  «      ƒ d{  –—† \  }	}
}}|	r2|
r0|}t+        d|j"                  |z
  «      }t-        |
j                  «      }t/        j0                  t2        j4                  «      j7                  d«      }d|› dt        j                  «       j                  dd j9                  «       › �}d}d}d}|j                  dv r¡|dkD  rœt;        j<                  |j                  «      }|j?                  ||j                  |t-        |«      |j                  |j@                  |dœ|¬«      ƒ d{  –—† }|jC                  d«      }|jC                  d«      }|jC                  d«      }| j                   j?                  ||||j                  |j                  |d|j                  ||||j"                  |j@                  dœ¬«
      ƒ d{  –—† }t        |j                  |j                  |j                  |j                  dk(  rd|j                  d	z  d
›�nd|j                  d	z  d
›�|j                  |j                  ||||j                  ¬«
      S 7 �Œœ7 �Œ7 �ŒH7 �Œ)7 Œ”­w)z]
        Creates a payment order with idempotency guarantee and gateway integration.
        NúPlan 'ú' does not existÚidem_Ú_é   Úcreatedr_   rE   r`   )Úorder_idÚorder_numberÚamountÚamount_formattedr<   ÚproviderÚgateway_order_idrj   r   ú%Y%m%dúORD-ú-é   ©ÚrazorpayÚstripe)rf   rh   ri   r   )r€   r<   ÚreceiptÚnotesÚidempotency_keyr7   Úkey_idÚurlÚsubscription)Ú	coupon_idÚdiscount_appliedÚoriginal_amountri   ©
rf   r   r€   r<   r‚   r�   Úpurposerh   rƒ   Úmetadata_jsonr=   ra   )
r~   r   r€   r�   r<   r‚   rƒ   Úgateway_key_idÚcheckout_urlrj   )"r-   Úget_plan_by_idrh   r   r�   ÚuuidÚuuid4ÚhexÚget_order_by_idempotency_keyrj   r   r7   r   r€   r<   r‚   rƒ   r;   Úcoupon_coder0   Úvalidate_couponÚmaxÚstrr   Únowr   ÚutcÚstrftimeÚupperr   Úget_gatewayÚcreate_orderr9   Úget)r1   rf   rv   r[   r�   Úexisting_orderÚfinal_amountr‘   r’   Úis_validÚcouponÚdiscountr{   Únow_strr   rƒ   r—   r˜   ÚgatewayÚgw_respÚorders                        r2   Úcreate_checkout_orderz$BillingService.create_checkout_order¼   s�  è ø€ ð —Y‘Y×-Ñ-¨c¯k©kÓ:×:ˆÙÜ &¨¯©¨Ð5EÐ FÓGÐGà×-Ñ-Òj°5¸¸À1ÀSÇ[Á[ÀMÐQRÔSW×S]ÑS]ÓS_×ScÑScÐdgÐegÐShÐRiÐ1jˆØ#Ÿy™y×EÑEÀoÓV×VˆÙ˜n×3Ñ3°yÒ@Ü(Ø'×*Ñ*Ø+×8Ñ8Ø%×,Ñ,Ø#& ~×'<Ñ'<¸sÑ'BÀ3Ð&GÐ!HØ'×0Ñ0Ø'×0Ñ0Ø!/×!@Ñ!@Ø%×,Ñ,ô	ð 	ð ×(Ñ(ˆØˆ	ØÐØ�?Š?Ø26·,±,×2NÑ2NØ—‘ §¡¨$×*;Ñ*;ó3÷ -Ñ)ˆH�f˜h¨ñ ™FØ#+Ð Ü" 1 d×&7Ñ&7¸(Ñ&BÓC�Ü §	¡	›N�	ä—,‘,œxŸ|™|Ó,×5Ñ5°hÓ?ˆØ˜g˜Y a¬¯
©
«×(8Ñ(8¸¸!Ð(<×(BÑ(BÓ(DÐ'EÐFˆàÐØˆØˆà�<‰<Ð1Ñ1°lÀQÒ6FÜ$×0Ñ0°·±Ó>ˆGØ#×0Ñ0Ø#ØŸ™Ø$ä!$ Y£Ø#Ÿw™wØ!%§¡Ø$0ñ	ð !0ð 1ó ÷ ˆGð  'Ÿ{™{¨4Ó0ÐØ$Ÿ[™[¨Ó2ˆNØ"Ÿ;™; uÓ-ˆLà—i‘i×,Ñ,ØØ%ØØ—]‘]Ø—\‘\Ø+Ø"Ø—G‘GØ-à&Ø$4Ø#'×#4Ñ#4Ø!ŸY™Yñ	ð -ó 
÷ 
ˆô$ %Ø—X‘XØ×+Ñ+Ø—<‘<Ø?D¿~¹~ÐQVÒ?V˜s 5§<¡<°#Ñ#5°cÐ":Ñ;Ð^_Ð`e×`lÑ`lÐorÑ`rÐsvÐ_wÐ\xØ—^‘^Ø—^‘^Ø-Ø)Ø%Ø—<‘<ô
ð 	
ðU ;ùð
 Wùð$-ùð"ùð 
ús\   ‚)O«O¬A?OÂ+O
Â,COÆOÆD!OÊ'OÊ(BOÌ>OÌ?B	OÏ
OÏOÏOÏOc              ƒ   óØ  K  — | j                   j                  |j                  «      ƒ d{  –—† }|st        d«      ‚|j                  |k7  rt        d«      ‚|j                  dk(  rb| j                   j                  |«      ƒ d{  –—† }t        dd|j                  d|r|j                  ¬«      S t        j                  «       ¬«      S t        j                  |j                  «      }|j                  xs t!        |j                  «      }|j#                  ||j$                  |j&                  xs d¬	«      }|sp| j                   j)                  |d
|j$                  ¬«      ƒ d{  –—†  t*        j-                  dt!        |j                  «      |j$                  ¬«       t/        d«      ‚| j                   j)                  |d|j$                  |j&                  ¬«      ƒ d{  –—†  t1        j2                  t4        j6                  «      }|t9        d¬«      z   }	| j                   j                  |«      ƒ d{  –—† }|rO| j                   j;                  ||j<                  xs dd||	dd|j                  |j$                  ¬«	      ƒ d{  –—†  nA| j                   j?                  ||j<                  xs dd||	|j                  ¬«      ƒ d{  –—† }| j@                  jC                  tE        tF        «      jI                  tF        j                  |k(  «      «      ƒ d{  –—†  | j@                  jK                  tF        |«      ƒ d{  –—† }
|
r3|j<                  |
_        | j@                  jM                  «       ƒ d{  –—†  d|jO                  d«      › dt        j                  «       jP                  dd jS                  «       › �}| j                   jU                  |j<                  xs d«      ƒ d{  –—† }|jV                  }tY        |dz  «      }|jZ                  xs i jK                  dd«      }| j                   j]                  |||jV                  |jV                  |j^                  d||d|› d�|
r|
j`                  nd d!|r|j`                  n|j<                  › d"�d#|jV                  |jV                  d$œg||||j                  |j                  ¬%«      ƒ d{  –—† }|jZ                  xs i jK                  d&«      }|rI|dkD  rD| jb                  je                  |t        jf                  |«      |j                  |¬'«      ƒ d{  –—†  | j                   ji                  |«      ƒ d{  –—† }|r«|j                  d(k(  rœd)|_        ||_5        | j@                  jM                  «       ƒ d{  –—†  | jl                  jo                  |jp                  |jr                  d*d+|
r|
j`                  nt!        |«      dd, › �t!        |j                  «      ¬-«      ƒ d{  –—†  t        dd.|j                  d|j                  |j                  ¬/«      S 7 �Œ7 �Œ»7 �Œß7 �Œg7 �Œ7 �ŒÈ7 �Œ‰7 �Œ<7 �Œ7 �Œå7 �Œs7 �Œ�7 �Œ(7 �Œ7 ŒÉ7 Œ_­w)0z¤
        Server-side cryptographic verification of payment completion.
        Never trusts client-reported success without gateway signature confirmation.
        NúOrder not foundz)Cross-tenant order verification forbiddenÚpaidTz0Payment already verified and subscription active)ÚsuccessÚmessager~   rj   Úsubscription_idÚ )r~   Ú
payment_idÚ	signatureÚfailed©rj   Úgateway_payment_idÚ%payment_signature_verification_failed)r~   rº   z3Cryptographic payment signature verification failed)rj   r¾   Úgateway_signaturerQ   ©ÚdaysrM   ÚactiveF)rh   rj   rk   rl   rm   rq   rr   Úgateway_subscription_id©rf   rh   rj   rk   rl   rr   úINV-ú%Yr†   é   g
×£p=
Ç?r’   r   úbilling@ú.saasúTenant OrganizationúSubscription Plan: z
 (1 Month)rC   ©r:   ÚquantityÚ
unit_priceÚtotal©rf   Úinvoice_numberÚ
amount_dueÚamount_paidr<   rj   Údue_dateÚpaid_atÚbilling_emailÚbilling_nameÚitemsÚsubtotalÚ
tax_amountÚdiscount_amountr¸   r~   r‘   )rf   r‘   r~   r’   ÚpendingÚrewardedÚreferralz$Referral reward for inviting tenant r‡   ©rf   r€   Úreference_typer:   Úreference_idz8Payment successfully verified and subscription activated©r¶   r·   r~   rj   r¸   Ú
invoice_id):r-   Úget_order_by_idr~   r   rf   r   rj   ru   r!   r7   rš   r›   r   r¦   r‚   rƒ   r¡   Úverify_payment_signaturerº   r»   Úupdate_orderÚloggerÚwarningr   r   r¢   r   r£   r   Úupdate_subscriptionrh   Úcreate_subscriptionr*   Úexecuter   r'   Úwherer¨   Úcommitr¤   rœ   r¥   r™   r€   Úintr–   Úcreate_invoicer<   r9   r0   Úrecord_redemptionÚUUIDÚget_referral_by_referred_tenantÚrewarded_atr/   ÚcreditÚreferrer_tenant_idÚreward_amount)r1   rf   rv   r±   rt   r¯   rƒ   r«   r¢   Ú
period_endÚ
tenant_resrÒ   r[   rÚ   Útaxr­   ÚinvoiceÚcoupon_id_strrß   s                      r2   Úverify_and_activate_paymentz*BillingService.verify_and_activate_payment  s«  è ø€ ð —i‘i×/Ñ/°·±Ó=×=ˆÙÜÐ 1Ó2Ð2à�?‰?˜iÒ'Ü Ð!LÓMÐMà�<‰<˜6Ò!àŸ	™	×9Ñ9¸)ÓD×DˆCÜ.ØØJØŸ™ØÙ*- §¡ôð ô
 48·:±:³<ôð ô !×,Ñ,¨S¯\©\Ó:ˆØ ×1Ñ1ÒB´S¸¿¹³]ÐØ×3Ñ3Ø%Ø—~‘~Ø—m‘mÒ) rð 4ó 
ˆñ Ø—)‘)×(Ñ(¨°xÐTW×TbÑTbÐ(Óc×cÐcÜ�N‰NÐBÌSÐQV×QYÑQYË]Ðgj×guÑguˆNÔvÜÐTÓUÐUð �i‰i×$Ñ$ØØØ"Ÿ~™~Ø!Ÿm™mð	 %ó 
÷ 	
ð 	
ô �l‰lœ8Ÿ<™<Ó(ˆØœ9¨"Ô-Ñ-ˆ
Ø—I‘I×5Ñ5°iÓ@×@ˆÙØ—)‘)×/Ñ/ØØŸ™Ò2¨ØØ%(Ø#-Ø%*Ø%)Ø!$§¡Ø(+¯©ð 0ó 
÷ 
ñ 
ð Ÿ	™	×5Ñ5Ø#ØŸ™Ò2¨ØØ%(Ø#-Ø!$§¡ð 6ó ÷ ˆCð �g‰g�o‰oÜ”6‹N× Ñ ¤§¡¨iÑ!7Ó8ó
÷ 	
ð 	
ð  Ÿ7™7Ÿ;™;¤v¨yÓ9×9ˆ
ÙØ!&§¡ˆJÔØ—'‘'—.‘.Ó"×"Ð"ð   §¡¨TÓ 2Ð3°1´T·Z±Z³\×5EÑ5EÀbÀqÐ5I×5OÑ5OÓ5QÐ4RÐSˆØ—Y‘Y×-Ñ-¨e¯m©mÒ.H¸yÓI×IˆØ—<‘<ˆÜ�(˜T‘/Ó"ˆØ×'Ñ'Ò-¨2×2Ñ2Ð3EÀqÓIˆàŸ	™	×0Ñ0ØØ)Ø—|‘|ØŸ™Ø—^‘^ØØØØ$ Y K¨uÐ5Ù,6˜ŸšÐ<Qà!4Á$°T·Y²YÈEÏMÉMÐ4ZÐZdÐeØØ#Ÿl™lØŸ™ñ	ð ð ØØ$ØŸF™FØ—X‘Xð+ 1ó 
÷ 
ˆð2 ×,Ñ,Ò2°×7Ñ7¸ÓDˆÙ˜X¨š\Ø—,‘,×0Ñ0Ø#ÜŸ)™) MÓ2ØŸ™Ø!)ð	 1ó ÷ ð ð Ÿ™×BÑBÀ9ÓM×MˆÙ˜Ÿ™¨9Ò4Ø(ˆHŒOØ#&ˆHÔ Ø—'‘'—.‘.Ó"×"Ð"à—,‘,×%Ñ%Ø"×5Ñ5Ø×-Ñ-Ø)ØBÑV`À:Ç?Â?ÔfiÐjsÓftÐuwÐvwÐfxÐByÐzÜ  §¡Ó-ð &ó ÷ ð ô +ØØNØ—X‘XØØŸF™FØ—z‘zô
ð 	
ðG >ùð Eùð& dùð
	
ùð Aùð
ùðùð	
ùð :ùð #ùð Jùð

ùð6ùð Nùð #øðús)  ‚)Y*«X<¬AY*ÂX?ÂCY*Å#YÅ$A:Y*ÇYÇAY*È3YÈ4AY*ÊYÊAY*ËYËAY*ÌYÌ'Y*Ì=YÌ>4Y*Í2YÍ3A4Y*Ï'YÏ(C&Y*ÓYÓA)Y*Ô8Y Ô9"Y*ÕY#ÕA Y*ÖY&ÖA+Y*ØY(Ø	4Y*Ø?Y*ÙY*ÙY*ÙY*ÙY*ÙY*ÙY*ÙY*ÙY*ÙY*ÙY*Ù Y*Ù#Y*Ù&Y*Ù(Y*rh   rž   c              ƒ   ó  K  — | j                   j                  |«      ƒ d{  –—† }|st        d|› d�«      ‚|j                  }d}d}|rr| j                  j                  ||j                  |j                  «      ƒ d{  –—† \  }}	}
}|r2|	r0|
}t        d|j                  |
z
  «      }t        |	j                  «      }| j                  j                  ||dd|j                  › �¬«      ƒ d{  –—† }t        j                  t        j                  «      }d|j!                  d	«      › d
t#        j$                  «       j&                  dd j)                  «       › �}| j                   j+                  ||||j,                  dd|j                  › �d|j                  t        |j                  «      t        |j                  «      |dœ¬«
      ƒ d{  –—† }| j                   j/                  |dt        |j                  «      ¬«      ƒ d{  –—†  |t1        d¬«      z   }| j                   j3                  |«      ƒ d{  –—† }|r6| j                   j5                  ||j                  d||ddd¬«      ƒ d{  –—†  n3| j                   j7                  ||j                  d||d¬«      ƒ d{  –—† }| j8                  j;                  t<        |«      ƒ d{  –—† }|r3|j                  |_        | j8                  jA                  «       ƒ d{  –—†  d|j!                  d«      › d
t#        j$                  «       j&                  dd j)                  «       › �}| j                   jC                  |||||j,                  d||d|› d�|r|j                  ndd|j                  › d�d ||d!œg|d||j                  |j                  ¬"«      ƒ d{  –—† }tE        d#d$|j                  d|j                  |j                  ¬%«      S 7 �ŒÉ7 �Œp7 �Œ7 �Œ+7 �Œõ7 �ŒÆ7 �Œ’7 �Œa7 �Œ<7 �Œ
7 ŒQ­w)&zLAllows tenants to subscribe or renew instantly using prepaid wallet credits.Nrx   ry   r   r�   zWallet payment for plan: )rf   r€   rá   r:   r…   r„   r†   r‡   ÚwalletÚwallet_)Úwallet_tx_idr’   r”   rµ   r½   rQ   rÁ   rÃ   F)rh   rj   rk   rl   rm   rq   rr   rÅ   rÆ   rÇ   rÈ   rÉ   rÊ   rË   rÌ   z (Paid via Wallet)rC   rÍ   rÑ   Tz2Payment completed successfully with wallet balancerã   )#r-   r™   r   r;   r0   rŸ   r7   r    r¡   r/   Údebitr9   r   r¢   r   r£   r¤   rš   r›   rœ   r¥   r§   r<   rç   r   ru   rê   rë   r*   r¨   r'   rh   rî   rð   r!   )r1   rf   rh   rž   r[   Úamount_to_payr’   r‘   r«   r¬   r­   r{   Útxr¢   r   r±   rø   rt   rù   Úinvoice_numrû   s                        r2   Úpay_with_walletzBillingService.pay_with_wallet²  sÞ  è ø€ ð —Y‘Y×-Ñ-¨gÓ6×6ˆÙÜ &¨¨	Ð1AÐ BÓCÐCà×)Ñ)ˆØÐØˆ	ÙØ26·,±,×2NÑ2NØ˜TŸW™W d×&7Ñ&7ó3÷ -Ñ)ˆH�f˜h¨ñ ™FØ#+Ð Ü # A t×'8Ñ'8¸8Ñ'CÓ D�Ü §	¡	›N�	ð —<‘<×%Ñ%ØØ Ø)Ø3°D·I±I°;Ð?ð	 &ó 
÷ 
ˆô �l‰lœ8Ÿ<™<Ó(ˆØ˜cŸl™l¨8Ó4Ð5°Q´t·z±z³|×7GÑ7GÈÈÐ7K×7QÑ7QÓ7SÐ6TÐUˆØ—i‘i×,Ñ,ØØ%Ø Ø—]‘]ØØ% b§e¡e WÐ-Ø"Ø—G‘GÜ  §¡›ZÜ+.¨r¯u©u«:ÐK[Ñ\ð -ó 
÷ 
ˆð �i‰i×$Ñ$ U°6ÌcÐRT×RWÑRWËjÐ$ÓY×YÐYð œ9¨"Ô-Ñ-ˆ
Ø—I‘I×5Ñ5°iÓ@×@ˆÙØ—)‘)×/Ñ/ØØŸ™ØØ%(Ø#-Ø%*Ø%)Ø!)ð 0ó 	÷ 	ñ 	ð Ÿ	™	×5Ñ5Ø#ØŸ™ØØ%(Ø#-Ø!)ð 6ó ÷ ˆCð  Ÿ7™7Ÿ;™;¤v¨yÓ9×9ˆ
ÙØ!%§¡ˆJÔØ—'‘'—.‘.Ó"×"Ð"ð ˜SŸ\™\¨$Ó/Ð0°´$·*±*³,×2BÑ2BÀ2ÀAÐ2F×2LÑ2LÓ2NÐ1OÐPˆØŸ	™	×0Ñ0ØØ&Ø$Ø%Ø—]‘]ØØØØ$ Y K¨uÐ5Ù,6˜ŸšÐ<Qà!4°T·Y±Y°KÐ?QÐRØØ+Ø&ñ	ð ð #ØØ,ØŸF™FØ—X‘Xð+ 1ó 
÷ 
ˆô0 +ØØHØ—X‘XØØŸF™FØ—z‘zô
ð 	
ðA 7ùð-ùð
ùð
ùð 	Zùð Aùð	ùðùð :ùð #ùð
úsÇ   ‚P
¡O*¢AP
Á=O-Á>A,P
Ã*O0Ã+CP
ÇO3Ç	8P
ÈO6È1P
È3O9È46P
É*O<É+3P
ÊO?Ê'P
ËPË4P
Ë;PË<B:P
Î6PÎ74P
Ï-P
Ï0P
Ï3P
Ï6P
Ï9P
Ï<P
Ï?P
ÐP
ÐP
ÐP
Únew_plan_idr‚   c              ƒ   óÌ  K  — | j                   j                  |«      ƒ d{  –—† }|st        d|› d�«      ‚| j                  j	                  |«      ƒ d{  –—† \  }}t        j                  t        j                  «      }d}	|j                  dk(  r˜|j                  |kD  r‰|j                  dkD  rz|j                  |j                  z
  j                  «       }
|j                  |z
  j                  «       }|
dkD  r1t        dt        d||
z  «      «      }t!        |j                  |z  «      }	t        d|j                  |	z
  «      }d}|rG| j"                  j%                  ||j&                  |«      ƒ d{  –—† \  }}}}|r|}t        d||z
  «      }d|› d	|› d	|j)                  d
«      › �}t+        |j&                  |||¬«      }| j-                  ||«      ƒ d{  –—† S 7 �Œ¹7 �Œˆ7 Œo7 Œ­w)zv
        Calculates proration credit for unused time on existing plan, creating checkout order for the delta.
        NúTarget plan 'ú' not foundr   rÃ   g        g      ð?Úupgrade_r{   z
%Y%m%d%H%M)rh   r‚   rž   r�   )r-   r™   r   r.   rs   r   r¢   r   r£   rj   rl   r;   rk   Útotal_secondsr    Úminrï   r0   rŸ   r7   r¤   r   r²   )r1   rf   r  r‚   rž   Únew_planÚold_planrt   r¢   Úprorated_creditr  Úremaining_secondsÚunused_ratioÚ
net_amountr­   r«   r¬   Úd_amtr{   r�   rv   s                        r2   Úupgrade_subscriptionz#BillingService.upgrade_subscription#  s×  è ø€ ð Ÿ™×1Ñ1°+Ó>×>ˆÙÜ -°¨}¸KÐ HÓIÐIà"×/Ñ/×GÑGÈ	ÓR×R‰ˆ�#Ü�l‰lœ8Ÿ<™<Ó(ˆð ˆØ�:‰:˜Ò! c×&<Ñ&<¸sÒ&BÀx×G\ÑG\Ð_`ÒG`Ø ×3Ñ3°c×6NÑ6NÑN×]Ñ]Ó_ˆMØ!$×!7Ñ!7¸#Ñ!=× LÑ LÓ NÐØ˜qÒ Ü" 3¬¨CÐ1BÀ]Ñ1RÓ(SÓT�Ü"% h×&;Ñ&;¸lÑ&JÓ"K�ä˜˜H×1Ñ1°OÑCÓDˆ
ð ˆÙØ/3¯|©|×/KÑ/KÈKÐYa×YdÑYdÐfpÓ/q×)qÑ&ˆH�f˜e QÙØ �Ü   J°Ñ$9Ó:�
à$ Y K¨q°°¸Q¸s¿|¹|ÈLÓ?YÐ>ZÐ[ˆÜ"Ø—K‘KØØ#Ø+ô	
ˆð ×/Ñ/°	¸3Ó?×?Ð?ðC ?ùð Sùð" *røð @úsG   ‚G$¡G¢3G$ÁGÁDG$Å0G Å1A$G$ÇG"ÇG$ÇG$Ç G$Ç"G$Ú	immediatec           	   ƒ   ód  K  — | j                   j                  |«      ƒ d{  –—† }|st        d|› d�«      ‚|j                  dk7  r[| j                   j	                  |«      ƒ d{  –—† }||j                  kD  r)t        d|j                  › d|› d|j                  › d�«      ‚| j                   j                  |«      ƒ d{  –—† }|st        d	«      ‚|r�| j                   j                  ||j                  ¬
«      ƒ d{  –—†  | j                  j                  t        |«      ƒ d{  –—† }|rY|j                  |_        | j                  j                  «       ƒ d{  –—†  n%| j                   j                  |d¬«      ƒ d{  –—†  | j                  |«      ƒ d{  –—† S 7 �Œ}7 �Œ=7 Œä7 Œ¨7 Œ‚7 ŒO7 Œ+7 Œ­w)z
        Verifies usage against new plan limits. If within limits, downgrades immediately or schedules for period end.
        Nr	  r
  rV   zCannot downgrade to 'z'. You currently have z0 active bot(s), which exceeds the plan limit of z.. Please delete extra bots before downgrading.úSubscription not found)rh   T)rm   )r-   r™   r   rB   Úcount_active_botsr   r9   ru   rê   r7   r*   r¨   r'   rh   rî   )r1   rf   r  r  r  Úactive_botsrt   rù   s           r2   Údowngrade_subscriptionz%BillingService.downgrade_subscriptionP  s�  è ø€ ð Ÿ™×1Ñ1°+Ó>×>ˆÙÜ -°¨}¸KÐ HÓIÐIð ×Ñ Ò"Ø $§	¡	× ;Ñ ;¸IÓ F×FˆKØ˜X×.Ñ.Ò.Ü%Ø+¨H¯M©M¨?Ð:PÐQ\ÐP]ð ^7Ø7?×7HÑ7HÐ6IÐIwðyóð ð
 —I‘I×5Ñ5°iÓ@×@ˆÙÜÐ 8Ó9Ð9áØ—)‘)×/Ñ/°¸X¿[¹[Ð/ÓI×IÐIØ#Ÿw™wŸ{™{¬6°9Ó=×=ˆJÙØ%-§[¡[�
Ô"Ø—g‘g—n‘nÓ&×&Ñ&ð —)‘)×/Ñ/°È$Ð/ÓO×OÐOà×1Ñ1°)Ó<×<Ð<ð7 ?ùð Gùð Aøð
 JøØ=øð 'øð Pøà<ús�   ‚F0¡F¢AF0Á$F!Á%AF0Â?F$Ã =F0Ã=F&Ã>'F0Ä%F(Ä&4F0ÅF*Å%F0Æ F,ÆF0ÆF.ÆF0Æ!F0Æ$F0Æ&F0Æ(F0Æ*F0Æ,F0Æ.F0c              ƒ   ó@  K  — | j                   j                  |«      ƒ d {  –—† }|st        d«      ‚t        j                  t
        j                  «      }|r{| j                   j                  |d|d¬«      ƒ d {  –—†  | j                  j                  t        |«      ƒ d {  –—† }|rPd|_        | j                  j                  «       ƒ d {  –—†  n&| j                   j                  |d|¬«      ƒ d {  –—†  | j                  |«      ƒ d {  –—† S 7 Œð7 Œ™7 Œs7 ŒJ7 Œ%7 Œ­w)Nr  Úcanceledr8   )rj   rn   rh   T)rm   rn   )r-   ru   r   r   r¢   r   r£   rê   r*   r¨   r'   rh   rî   )r1   rf   r  rt   r¢   rù   s         r2   Úcancel_subscriptionz"BillingService.cancel_subscriptionw  s  è ø€ ð
 —I‘I×5Ñ5°iÓ@×@ˆÙÜÐ 8Ó9Ð9ä�l‰lœ8Ÿ<™<Ó(ˆÙØ—)‘)×/Ñ/ØØ!ØØð	 0ó ÷ ð ð  $Ÿw™wŸ{™{¬6°9Ó=×=ˆJÙØ%+�
Ô"Ø—g‘g—n‘nÓ&×&Ñ&à—)‘)×/Ñ/ØØ%)Øð 0ó ÷ ð ð ×1Ñ1°)Ó<×<Ð<ð/ Aøðøð >øð 'øðøð =úsj   ‚D¡D¢ADÁ:DÁ;'DÂ"DÂ#*DÃDÃ&DÃ4DÃ5DÄDÄDÄDÄDÄDÄDÄDc              ƒ   óÂ  K  — | j                   j                  |«      ƒ d{  –—† }|st        d«      ‚t        j                  t
        j                  «      }||j                  kD  rÔ|j                  €@|j                  t        d¬«      z   }| j                   j                  |d|¬«      ƒ d{  –—†  nˆ||j                  kD  ry| j                   j                  |dd¬	«      ƒ d{  –—†  | j                  j                  t        |«      ƒ d{  –—† }|r)d|_        | j                  j                  «       ƒ d{  –—†  | j                  |«      ƒ d{  –—† S 7 �Œ17 Œ©7 Œu7 ŒO7 Œ&7 Œ­w)
z~
        Checks current_period_end. If expired, transitions through grace_period (3 days) before downgrading to free.
        Nr  rO   rÁ   Úgrace_period©rj   rq   Úexpiredr8   )rj   rh   )r-   ru   r   r   r¢   r   r£   rl   rq   r   rê   r*   r¨   r'   rh   rî   )r1   rf   rt   r¢   Ú	grace_endrù   s         r2   Úprocess_subscription_expiryz*BillingService.process_subscription_expiry•  sB  è ø€ ð —I‘I×5Ñ5°iÓ@×@ˆÙÜÐ 8Ó9Ð9ä�l‰lœ8Ÿ<™<Ó(ˆØ�×'Ñ'Ò'à×'Ñ'Ð/à×2Ñ2´YÀAÔ5FÑF�	Ø—i‘i×3Ñ3ØØ)Ø)2ð 4ó ÷ ñ ð
 �s×/Ñ/Ò/à—i‘i×3Ñ3ØØ$Ø"ð 4ó ÷ ð ð
 $(§7¡7§;¡;¬v°yÓ#A×A�
ÙØ)/�JÔ&ØŸ'™'Ÿ.™.Ó*×*Ð*à×1Ñ1°)Ó<×<Ð<ð7 Aùðøðøð
 Bøð +øà<úsj   ‚E¡E¢B	EÂ+EÂ,5EÃ!EÃ"'EÄ	EÄ
*EÄ4EÄ5EÅEÅEÅEÅEÅEÅEÅEÚpayload_bytesr»   Úheadersc              ƒ   óx  K  — t        j                  |«      }|j                  |||«      s4t        j	                  d|¬«       t        d|j                  «       › d�«      ‚	 t        j                  |j                  d«      «      }d}d}|dk(  rv|xs i j                  d	«      xs$ |j                  d
«      xs |j                  d«      }|j                  dd«      }|sOt        j                  |«      j                  «       dd }n(|dk(  r#|j                  d«      }|j                  dd«      }|st!        t#        j$                  «       «      }| j&                  j)                  ||«      ƒ d{  –—† }	|	rt        j+                  d||¬«       d|ddœS | j&                  j-                  ||||d¬«      ƒ d{  –—†  |dv r| j/                  ||«      ƒ d{  –—†  n=|dv r| j1                  ||«      ƒ d{  –—†  n|dv r| j3                  ||«      ƒ d{  –—†  d|ddœS # t        $ r t        d«      ‚w xY w7 ŒÆ7 Œ€7 Œd7 ŒG7 Œ*­w)zk
        Handles incoming webhook with HMAC signature verification and duplicate event protection.
        Ú%webhook_signature_verification_failed)r‚   zInvalid z webhook signaturezutf-8z!Malformed JSON payload in webhookNr‰   zx-razorpay-event-idÚevent_idr7   ÚeventÚunknowné   rŠ   ÚtypeÚwebhook_duplicate_event_ignored)r‚   r)  Úduplicate_event_acknowledgedF)rj   r)  Ú	processedr0  )rr   r)  Ú
event_typeÚpayloadrj   )z
order.paidzpayment.capturedzpayment_intent.succeededzcheckout.session.completed)zpayment.failedzpayment_intent.payment_failed)zrefund.processedzcharge.refundedr¶   T)r   r¦   Úverify_webhook_signaturerè   ré   r   ÚtitleÚjsonÚloadsÚdecodeÚ	Exceptionr   r¨   ÚhashlibÚsha256Ú	hexdigestr¡   rš   r›   r-   Úget_webhook_eventÚinfoÚrecord_webhook_eventÚ_handle_order_paid_eventÚ_handle_payment_failed_eventÚ_handle_refund_event)
r1   r‚   r%  r»   r&  r¯   r2  r)  r1  Úexistings
             r2   Úhandle_webhookzBillingService.handle_webhook·  sD  è ø€ ô !×,Ñ,¨XÓ6ˆØ×/Ñ/°¸yÈ'ÔRÜ�N‰NÐBÈXˆNÔVÜ# h¨x¯~©~Ó/?Ð.@Ð@RÐ$SÓTÐTð	GÜ—j‘j ×!5Ñ!5°gÓ!>Ó?ˆGð
 ˆØˆ
à�zÒ!Øš 2×*Ñ*Ð+@ÓAÒqÀWÇ[Á[ÐQ[ÓE\ÒqÐ`g×`kÑ`kÐlpÓ`qˆHØ Ÿ™ W¨iÓ8ˆJÙÜ"Ÿ>™>¨-Ó8×BÑBÓDÀSÀbÐI‘Ø˜Ò!Ø—{‘{ 4Ó(ˆHØ Ÿ™ V¨YÓ7ˆJáÜœ4Ÿ:™:›<Ó(ˆHð Ÿ™×4Ñ4°X¸xÓH×HˆÙÜ�K‰KÐ9ÀHÐW_ˆKÔ`Ø<È(ÐafÑgÐgð �i‰i×,Ñ,Ø%ØØ!ØØð -ó 
÷ 	
ð 	
ð ÐuÑuØ×/Ñ/°¸'ÓB×BÑBØÐNÑNØ×3Ñ3°H¸gÓF×FÑFØÐBÑBØ×+Ñ+¨H°gÓ>×>Ð>à#°ÈÑMÐMøôU ò 	GÜ!Ð"EÓFÐFð	Gúð( Iøð	
øð CøàFøà>úst   ‚AH:Á $H ÂC%H:Å)H0Å*AH:Æ1H2Æ2H:ÇH4ÇH:Ç.H6Ç/H:ÈH8È
H:ÈH-È-H:È2H:È4H:È6H:È8H:r2  c           
   ƒ   ó  K  — d }|dk(  rD|j                  di «      j                  di «      j                  di «      }|j                  d«      }n8|dk(  r3|j                  di «      j                  di «      }|j                  d	«      }|ró| j                  j                  |«      ƒ d {  –—† }|rÍ|j                  d
k7  r½| j                  j	                  |d
¬«      ƒ d {  –—†  | j                  j                  |j                  «      ƒ d {  –—† }t        j                  t        j                  «      }|rE| j                  j                  |d|j                  xs d||t        d¬«      z   d ¬«      ƒ d {  –—†  y y y y y 7 ŒÕ7 Œ¡7 Œv7 Œ­w)Nr‰   r2  ÚpaymentÚentityr~   rŠ   ÚdataÚobjectr7   rµ   ©rj   rÃ   rM   rQ   rÁ   )rj   rh   rk   rl   rq   )r¨   r-   Úget_order_by_gateway_order_idrj   rç   ru   rf   r   r¢   r   r£   rê   rh   r   ©	r1   r‚   r2  rƒ   rF  Údata_objr±   rt   r¢   s	            r2   r?  z'BillingService._handle_order_paid_eventô  s`  è ø€ ØÐØ�zÒ!Ø—[‘[ ¨BÓ/×3Ñ3°I¸rÓB×FÑFÀxÐQSÓTˆFØ%Ÿz™z¨*Ó5ÑØ˜Ò!Ø—{‘{ 6¨2Ó.×2Ñ2°8¸RÓ@ˆHØ'Ÿ|™|¨DÓ1ÐáØŸ)™)×AÑAÐBRÓS×SˆEÙ˜Ÿ™¨Ò/Ø—i‘i×,Ñ,¨U¸6Ð,ÓB×BÐBØ ŸI™I×=Ñ=¸e¿o¹oÓN×N�Ü—l‘l¤8§<¡<Ó0�ÙØŸ)™)×7Ñ7ØØ'Ø %§¡Ò :°Ø-0Ø+.´ÀÔ1CÑ+CØ-1ð 8ó ÷ ñ ð ð	 0ˆuð ØSøàBøØNøðúsI   ‚B$FÂ&E<Â'5FÃE>Ã,FÄ	F Ä
A(FÅ2FÅ3
FÅ>FÆ FÆFc              ƒ   óê  K  — d }|dk(  rD|j                  di «      j                  di «      j                  di «      }|j                  d«      }n8|dk(  r3|j                  di «      j                  di «      }|j                  d	«      }|râ| j                  j                  |«      ƒ d {  –—† }|r¼| j                  j                  |d
¬«      ƒ d {  –—†  | j                  j	                  |j
                  «      ƒ d {  –—† }|rg|j                  dk(  rWt        j                  t        j                  «      }| j                  j                  |d|t        d¬«      z   ¬«      ƒ d {  –—†  y y y y y 7 ŒÄ7 ŒŸ7 Œt7 Œ­w)Nr‰   r2  rE  rF  r~   rŠ   rG  rH  r7   r¼   rI  rÃ   Úpast_duerO   rÁ   r!  )r¨   r-   rJ  rç   ru   rf   rj   r   r¢   r   r£   rê   r   rK  s	            r2   r@  z+BillingService._handle_payment_failed_event  sN  è ø€ ØÐØ�zÒ!Ø—[‘[ ¨BÓ/×3Ñ3°I¸rÓB×FÑFÀxÐQSÓTˆFØ%Ÿz™z¨*Ó5ÑØ˜Ò!Ø—{‘{ 6¨2Ó.×2Ñ2°8¸RÓ@ˆHØ'Ÿ|™|¨DÓ1ÐáØŸ)™)×AÑAÐBRÓS×SˆEÙØ—i‘i×,Ñ,¨U¸8Ð,ÓD×DÐDØ ŸI™I×=Ñ=¸e¿o¹oÓN×N�Ù˜3Ÿ:™:¨Ò1ä"Ÿ,™,¤x§|¡|Ó4�CØŸ)™)×7Ñ7ØØ)Ø-0´9À!Ô3DÑ-Dð 8ó ÷ ñ ð 2�3ð ð ØSøàDøØNøðúsI   ‚B$E3Â&E+Â'&E3ÃE-Ã,E3Ã:E/Ã;A&E3Å!E1Å"
E3Å-E3Å/E3Å1E3c              ƒ   ó   K  — y ­wr,   rX   )r1   r‚   r2  s      r2   rA  z#BillingService._handle_refund_event$  s	   è ø€ Øùs   ‚c           
   ƒ   ó„  K  — | j                   j                  |j                  «      ƒ d {  –—† }|st        d«      ‚|j                  |k7  rt        d«      ‚|j                  dvrt        d|j                  › d�«      ‚|j                  xs |j                  }|dk  s||j                  kD  rt        d|› �«      ‚d }|j                  dv r~t        j                  |j                  «      }|j                  |j                  xs |j                  xs d	||j                  |j                   ¬
«      ƒ d {  –—† }|j#                  d«      }nˆ|j                  dk(  ry| j$                  j'                  ||dd|j(                  › d|j                   › �t+        |j,                  «      ¬«      ƒ d {  –—†  dt/        j0                  «       j2                  d d › �}||j                  k(  rdnd}| j                   j5                  ||¬«      ƒ d {  –—†  | j                   j                  ||j,                  ||j                  |j                   |j                  d|¬«      ƒ d {  –—† }	t7        |	j,                  |	j                  |	j                  |	j                  |	j                  |	j8                  |	j                   ¬«      S 7 �Œˆ7 �Œ…7 �Œ7 Œ¸7 Œg­w)Nr´   zCross-tenant refund forbidden)rµ   Úpartially_refundedzCannot refund order in status 'ú'r   zInvalid refund amount: rˆ   Úpay_mock)rº   r€   r<   Úreasonr7   rÿ   ÚrefundzRefund for order #z: rà   Úwallet_rfnd_r|   ÚrefundedrQ  rI  r0  )rf   r~   r€   r<   rT  r‚   rj   Úgateway_refund_id)r7   r~   r€   r<   rj   rX  rT  )r-   rå   r~   r   rf   r   rj   r   r€   r‚   r   r¦   Úcreate_refundr¾   rƒ   r<   rT  r¨   r/   rõ   r   r¡   r7   rš   r›   rœ   rç   r$   rX  )
r1   rf   rv   r±   Úrefund_amountrX  r¯   r°   Ú
new_statusrU  s
             r2   Úprocess_refundzBillingService.process_refund(  s{  è ø€ ð
 —i‘i×/Ñ/°·±Ó=×=ˆÙÜÐ 1Ó2Ð2Ø�?‰?˜iÒ'Ü Ð!@ÓAÐAØ�<‰<Ð=Ñ=Ü!Ð$CÀEÇLÁLÀ>ÐQRÐ"SÓTÐTàŸ
™
Ò2 e§l¡lˆØ˜AÒ °·±Ò!=Ü!Ð$;¸M¸?Ð"KÓLÐLà ÐØ�>‰>Ð3Ñ3Ü$×0Ñ0°·±Ó@ˆGØ#×1Ñ1Ø ×3Ñ3Ò[°u×7MÑ7MÒ[ÐQ[Ø$ØŸ™Ø—z‘zð	 2ó ÷ ˆGð !(§¡¨DÓ 1ÑØ�^‰^˜xÒ'à—,‘,×%Ñ%Ø#Ø$Ø'Ø0°×1CÑ1CÐ0DÀBÀsÇzÁzÀlÐSÜ  §¡›]ð &ó ÷ ð ð #/¬t¯z©z«|×/?Ñ/?ÀÀÐ/DÐ.EÐ FÐà#0°E·L±LÒ#@‘ZÐFZˆ
Ø�i‰i×$Ñ$ U°:Ð$Ó>×>Ð>à—y‘y×.Ñ.ØØ—X‘XØ Ø—^‘^Ø—:‘:Ø—^‘^ØØ/ð /ó 	
÷ 	
ˆô Ø�y‰yØ—_‘_Ø—=‘=Ø—_‘_Ø—=‘=Ø$×6Ñ6Ø—=‘=ô
ð 	
ð_ >ùðùðùð 	?øð	
ús\   ‚)K «J3¬DK Ä1J6Ä2A5K Æ'J9Æ(AK ÈJ<ÈAK ÉJ>ÉAK Ê6K Ê9K Ê<K Ê>K c           	   ƒ   ób  K  — | j                   j                  |«      ƒ d {  –—† }|D �cg c]õ  }t        di d|j                  “d|j                  “d|j
                  “d|j                  “d|j                  “d|j                  “d|j                  “d|j                  “d	|j                  “d
|j                  “d|j                  “d|j                  “d|j                  “d|j                   “d|j"                  “d|j$                  “d|j&                  “d|j(                  “Ž‘Œ÷ c}S 7 �Œc c}w ­w)Nr7   rÒ   r¸   r~   rÓ   rÔ   Úamount_remainingr<   rj   rÕ   rÖ   r×   rØ   rÙ   rÚ   rÛ   rÜ   Úpdf_urlrX   )r-   Úlist_tenant_invoicesr   r7   rÒ   r¸   r~   rÓ   rÔ   r^  r<   rj   rÕ   rÖ   r×   rØ   rÙ   rÚ   rÛ   rÜ   r_  )r1   rf   ÚinvoicesÚinvs       r2   Úlist_invoiceszBillingService.list_invoicesg  sP  è ø€ ØŸ™×7Ñ7¸	ÓB×Bˆð,  ö+
ð* ô) ò Ø—6’6ðà"×1Ò1ðð !$× 3Ò 3ðð Ÿšð	ð
 Ÿ>š>ðð  ŸOšOðð "%×!5Ò!5ðð Ÿšðð —z’zðð Ÿšðð Ÿšðð "×/Ò/ðð !×-Ò-ðð —i’iðð Ÿšðð  Ÿ>š>ð!ð" !$× 3Ò 3ð#ð$ Ÿšò%ò
ð 	
ð Cûò
ùs!   ‚D/¡D'¢D/ªC:D*Ä$D/Ä*D/rä   c              ƒ   óX  K  — | j                   j                  ||«      ƒ d {  –—† }|st        d«      ‚t        di d|j                  “d|j
                  “d|j                  “d|j                  “d|j                  “d|j                  “d|j                  “d	|j                  “d
|j                  “d|j                  “d|j                  “d|j                  “d|j                   “d|j"                  “d|j$                  “d|j&                  “d|j(                  “d|j*                  “ŽS 7 �Œ­w)NzInvoice not foundr7   rÒ   r¸   r~   rÓ   rÔ   r^  r<   rj   rÕ   rÖ   r×   rØ   rÙ   rÚ   rÛ   rÜ   r_  rX   )r-   Úget_invoice_by_idr   r   r7   rÒ   r¸   r~   rÓ   rÔ   r^  r<   rj   rÕ   rÖ   r×   rØ   rÙ   rÚ   rÛ   rÜ   r_  )r1   rf   rä   rb  s       r2   Úget_invoicezBillingService.get_invoice�  sE  è ø€ Ø—I‘I×/Ñ/°
¸IÓF×FˆÙÜÐ 3Ó4Ð4Üò 
Ø�vŠvð
à×-Ò-ð
ð  ×/Ò/ð
ð —\’\ð	
ð
 —~’~ð
ð Ÿšð
ð !×1Ò1ð
ð —\’\ð
ð —:’:ð
ð —\’\ð
ð —K’Kð
ð ×+Ò+ð
ð ×)Ò)ð
ð —)’)ð
ð —\’\ð
ð  —~’~ð!
ð"  ×/Ò/ð#
ð$ —K’Kð%
ð 	
ð Gûs   ‚ D*¢D'£DD*rû   c                 óf  — |j                   j                  d«      }|j                  r|j                  j                  d«      nd}|j                  dk(  rdnd}d}|j                  D ]h  }|› |j                  dd«      d	z  d
›�}|› |j                  dd«      d	z  d
›�}|d|j                  dd«      › d|j                  dd«      › d|› d|› d�	z  }Œj |j                  dk(  rdnd}	dj                  g d‘|j                  › ‘d‘|	› ‘d‘|	› ‘d‘|j                  › ‘d‘|j                  › ‘d‘|j                  › ‘d‘|j                  › ‘d‘|› ‘d‘|› ‘d ‘|› ‘d!‘|› ‘|j                  d	z  d
›‘d"‘|› ‘|j                  d	z  d
›‘d#‘|› ‘|j                  d	z  d
›‘d$‘|› ‘|j                  d	z  d
›‘d%‘«      S )&z*Renders a clean, print-ready HTML invoice.z	%B %d, %YÚPendingr=   r_   ra   r¹   rÏ   r   rE   r`   rÐ   z_
            <tr>
                <td style="padding: 12px; border-bottom: 1px solid #e2e8f0;">r:   zg</td>
                <td style="padding: 12px; border-bottom: 1px solid #e2e8f0; text-align: center;">rÎ   rC   zf</td>
                <td style="padding: 12px; border-bottom: 1px solid #e2e8f0; text-align: right;">zx</td>
                <td style="padding: 12px; border-bottom: 1px solid #e2e8f0; text-align: right; font-weight: 600;">z$</td>
            </tr>
            rµ   z#16a34az#ea580czL<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title>Invoice aý  </title>
    <style>
        body { font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Helvetica, Arial, sans-serif; color: #1e293b; margin: 0; padding: 40px; background-color: #f8fafc; }
        .invoice-card { max-width: 800px; margin: 0 auto; background: #ffffff; border-radius: 12px; box-shadow: 0 4px 6px -1px rgba(0, 0, 0, 0.1); padding: 48px; border: 1px solid #e2e8f0; }
        .header { display: flex; justify-content: space-between; align-items: flex-start; margin-bottom: 36px; }
        .brand { font-size: 24px; font-weight: 800; color: #0f172a; letter-spacing: -0.5px; }
        .badge { display: inline-block; padding: 4px 12px; border-radius: 9999px; font-size: 13px; font-weight: 700; text-transform: uppercase; background-color: z20; color: uH  ; }
        .meta-grid { display: grid; grid-template-columns: 1fr 1fr; gap: 24px; margin-bottom: 36px; padding: 24px; background: #f8fafc; border-radius: 8px; }
        table { width: 100%; border-collapse: collapse; margin-bottom: 36px; }
        th { text-align: left; padding: 12px; border-bottom: 2px solid #cbd5e1; font-size: 13px; text-transform: uppercase; color: #64748b; letter-spacing: 0.5px; }
        .totals { margin-left: auto; width: 300px; }
        .total-row { display: flex; justify-content: space-between; padding: 8px 0; font-size: 14px; color: #64748b; }
        .total-row.grand { font-size: 18px; font-weight: 800; color: #0f172a; border-top: 2px solid #e2e8f0; padding-top: 12px; }
    </style>
</head>
<body>
    <div class="invoice-card">
        <div class="header">
            <div>
                <div class="brand">âš¡ Telegram SaaS Platform</div>
                <div style="color: #64748b; margin-top: 4px; font-size: 14px;">Enterprise Bot Infrastructure</div>
            </div>
            <div style="text-align: right;">
                <div class="badge">zX</div>
                <div style="font-size: 20px; font-weight: 700; margin-top: 8px;">a(  </div>
            </div>
        </div>

        <div class="meta-grid">
            <div>
                <div style="font-size: 12px; text-transform: uppercase; color: #94a3b8; font-weight: 700;">Billed To</div>
                <div style="font-size: 16px; font-weight: 600; margin-top: 4px;">zE</div>
                <div style="color: #64748b; font-size: 14px;">a  </div>
            </div>
            <div style="text-align: right;">
                <div style="font-size: 12px; text-transform: uppercase; color: #94a3b8; font-weight: 700;">Invoice Date</div>
                <div style="font-size: 14px; font-weight: 500; margin-top: 4px;">zç</div>
                <div style="font-size: 12px; text-transform: uppercase; color: #94a3b8; font-weight: 700; margin-top: 8px;">Payment Date</div>
                <div style="font-size: 14px; font-weight: 500; margin-top: 4px;">aŸ  </div>
            </div>
        </div>

        <table>
            <thead>
                <tr>
                    <th>Item Description</th>
                    <th style="text-align: center;">Qty</th>
                    <th style="text-align: right;">Unit Price</th>
                    <th style="text-align: right;">Amount</th>
                </tr>
            </thead>
            <tbody>
                z¦
            </tbody>
        </table>

        <div class="totals">
            <div class="total-row">
                <span>Subtotal:</span>
                <span>z}</span>
            </div>
            <div class="total-row">
                <span>Discount:</span>
                <span>-z�</span>
            </div>
            <div class="total-row">
                <span>Tax (GST/VAT):</span>
                <span>z„</span>
            </div>
            <div class="total-row grand">
                <span>Total Paid:</span>
                <span>zD</span>
            </div>
        </div>
    </div>
</body>
</html>)rÕ   r¤   rÖ   r<   rÙ   r¨   rj   ÚjoinrÒ   rØ   r×   rÚ   rÜ   rÛ   rÔ   )
r1   rû   Údate_strÚpaid_strÚcurrency_symÚ	rows_htmlÚitemÚunit_valÚtot_valÚstatus_colors
             r2   Úrender_invoice_htmlz"BillingService.render_invoice_htmlš  sl  € à×#Ñ#×,Ñ,¨[Ó9ˆØ<C¿OºO�7—?‘?×+Ñ+¨KÔ8ÐQZˆØ '× 0Ñ 0°EÒ 9‘u¸sˆàˆ	Ø—M‘Mò 
	ˆDØ&˜¨¯©°¸qÓ(AÀCÑ(GÈÐ'LÐMˆHØ%˜ t§x¡x°¸Ó';¸cÑ'AÀ#Ð&FÐGˆGØð NàNRÏhÉhÐWdÐfhÓNiÐMjð kbØbf×bjÑbjÐkuÐwxÓbyÐazð {aØaiÐ`jð ksØszÐr{ð |ðñ ‰Ið
	ð %,§N¡N°fÒ$<‘yÀ)ˆ÷Pó Pð ð Pð ×*Ñ*Ð+ð	Pð,dð	Pð eqð  drðPð r}ðPð ~Jð  }KðPðK$ðPð6 %,§N¡NÐ#3ð7Pð64Rð7Pð8 SZ×RhÑRhÐQið9Pð8jRð9PðF SZ×RfÑRfÐQgðGPðFh?ðGPðH @G×?TÑ?TÐ>UðIPðHVRðIPðP S[ÐQ[ðQPðP\RðQPðT S[ÐQ[ðUPðT\ðUPðp �ðqPðpðqPð~ $�nðPð~ &-×%5Ñ%5¸Ñ%;¸CÐ$@ðPð~AðPðF %�~ðGPðF '.×&=Ñ&=ÀÑ&CÀCÐ%HðGPðFIðGPðN $�nðOPðN &-×%7Ñ%7¸#Ñ%=¸cÐ$BðOPðNCðOPðV $�nðWPðV &-×%8Ñ%8¸3Ñ%>¸sÐ$CðWPðVDôWPð P	r4   )r5   Nr,   )r‰   N)F)+Ú__name__Ú
__module__Ú__qualname__Ú__doc__r	   r3   r\   Úlistr"   re   rš   rò   r%   ru   r   r   r²   r    r!   rý   r¡   r   r  r  Úboolr  r  r$  ÚbytesÚdictr   rC  r?  r@  rA  r#   r$   r\  r   rc  rf  r   rr  rX   r4   r2   r)   r)   0   sÒ  „ Ù^ð)˜<ó )óM.ð`
 $ |Ñ"4ó 
ð<
°t·y±yð 
ÐEYó 
ð&]
à—9‘9ð]
ð "ð]
ð 
ó	]
ð@S
à—9‘9ðS
ð (ðS
ð 
%ó	S
ðt &*ñ	n
à—9‘9ðn
ð ðn
ð ˜c‘]ð	n
ð
 
%ón
ðj #Ø%)ñ+@à—9‘9ð+@ð ð+@ð ð	+@ð
 ˜c‘]ð+@ð 
ó+@ðb  ñ	$=à—9‘9ð$=ð ð$=ð ð	$=ð
 
ó$=ðT  ñ=à—9‘9ð=ð ð=ð 
ó	=ð<=¸4¿9¹9ð =ÐI]ó =ðN -1ñ;Nàð;Nð ð;Nð ð	;Nð
 ˜$˜s C˜x™.Ñ)ð;Nð 
ˆc�3ˆh‰ó;Nðz°sð ÀTÈ#ÈsÈ(Á^ð ÐX\ó ð2¸3ð ÈÈcÐSVÈhÉð Ð\`ó ð.°3ð ÀÀcÈ3ÀhÁð ÐTXó ð<
à—9‘9ð<
ð ð<
ð 
ó	<
ð~
¨T¯Y©Yð 
¸4ÀÑ;Pó 
ð4
¨4¯9©9ð 
À$Ç)Á)ð 
ÐP_ó 
ð2e¨7ð e°sô er4   r)   )9r9  r5  rš   r   r   r   Útypingr   r   Ú
sqlalchemyr   Úsqlalchemy.ext.asyncior	   Úcore.configr
   Úcore.exceptionsr   r   r   r   r   r   r   Úcore.loggingr   Ú'infrastructure.payments.gateway_factoryr   Úmodules.billing.coupon_servicer   Ú#modules.billing.entitlement_servicer   Úmodules.billing.modelsr   r   r   r   r   r   Úmodules.billing.repositoryr   Úmodules.billing.schemasr   r   r   r    r!   r"   r#   r$   r%   Úmodules.billing.wallet_servicer&   Úmodules.tenants.modelsr'   rs  rè   r)   rX   r4   r2   ú<module>r‰     sy   ðÛ Û Û ß 2Ñ 2ß  Ý Ý /Ý $÷÷ ñ õ $Ý BÝ 8Ý B÷÷ õ 9÷
÷ 
õ 
õ 9Ý )á	�HÓ	€÷Oò Or4   