Ë
    u)Ðj´D  ã                   ód  — d Z ddlZddlZddlZddlZ ej
                  d«      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mZmZmZmZ dd	lmZmZmZmZ dd
lmZ ddlmZmZ defd„Zdefd„Zdedz  defd„Z de	dz  de	dz  fd„Z!de"eef   fd„Z#defd„Z$dd„Z%dd„Z&dd„Z'de"fd„Z(y)a¬  Periodic live-status reconciliation for Billing, customers and hotspot vouchers.

Voucher lifecycle rules (independent triggers, either one is enough):
  1. Duration/jatah habis  -> hapus dari RouterOS + database.
  2. Masa berlaku habis   -> hapus dari RouterOS + database.
Status juga disinkronkan LIVE dari RouterOS (uptime / limit-uptime / active /
disabled) supaya DataTables voucher selalu mencerminkan kondisi perangkat.
é    Nzbestweb.voucher_monitor)Úselect)ÚdatetimeÚtimezoneÚ	timedelta©ÚAsyncSessionLocal)Úrefresh_customer_online_status)ÚVoucherÚVoucherBatchÚCustomerÚMikrotikDeviceÚHotspotProfile)r   ÚDeviceCredentialr   r
   )ÚRealMikrotikAdapter)Údecrypt_secret_strictÚSecretDecryptionErrorÚreturnc            	      ót   — 	 t        dt        t        j                  dd«      «      «      S # t        $ r Y yw xY w)Né
   ÚBESTWEB_STATUS_POLL_SECONDSÚ30é   ©ÚmaxÚintÚosÚgetenvÚ
ValueError© ó    úapp/core/status_monitor.pyÚpoll_intervalr"   !   s7   € ðÜ�2”sœ2Ÿ9™9Ð%BÀDÓIÓJÓKÐKøÜò Ùðúó   ‚(+ «	7¶7c            	      ót   — 	 t        dt        t        j                  dd«      «      «      S # t        $ r Y yw xY w)Né   ÚBESTWEB_VOUCHER_POLL_SECONDSÚ10r   r   r   r    r!   Úvoucher_poll_intervalr(   (   s7   € ðÜ�1”cœ"Ÿ)™)Ð$BÀDÓIÓJÓKÐKøÜò Ùðúr#   Úvaluec                 óh  — t        | xs d«      j                  «       j                  «       }|syd|v rád}|}t        j                  d|«      }|r+t        |j                  d«      «      }|j                  d«      }|j                  d«      }	 |D �cg c]  }t        t        |«      «      ‘Œ }}t        |«      dk  r!|j                  dd«       t        |«      dk  rŒ!t        |«      dk\  r||d   z  }|d	d
 }|dz  |d   dz  z   |d   dz  z   |d   z   S t        j                  d|«      }|rPt        |j                  «       «      r7d„ |j                  «       D «       \  }	}
}}}|	dz  |
dz  z   |dz  z   |dz  z   |z   S 	 t        t        |«      «      S c c}w # t        $ r Y yw xY w# t        $ r Y yw xY w)z|Parse RouterOS uptime/limit-uptime into seconds.

    Accepts 1d02:03:04, 02:03:04, 3h04m, 2w, 5m, 45s and bare digits.
    Ú r   ú:z^(\d+)d(.*)$é   é   é   é   éýÿÿÿNi€Q i  é<   z7(?:(\d+)w)?(?:(\d+)d)?(?:(\d+)h)?(?:(\d+)m)?(?:(\d+)s)?c              3   ó:   K  — | ]  }|rt        |«      nd –— Œ y­w)r   N)r   )Ú.0Úgs     r!   ú	<genexpr>z'parse_uptime_seconds.<locals>.<genexpr>P   s   è ø€ ÒD°¡1œ˜Qœ¨!Ó+ÑDùs   ‚i€:	 )ÚstrÚstripÚlowerÚreÚmatchr   ÚgroupÚsplitÚfloatr   ÚlenÚinsertÚ	fullmatchÚanyÚgroups)r)   ÚrawÚdaysÚbodyÚ	day_matchÚpartsÚpÚnumsr;   ÚwÚdÚhÚmÚss                 r!   Úparse_uptime_secondsrP   /   s¼  € ô
 ˆeŠk�rÓ
×
 Ñ
 Ó
"×
(Ñ
(Ó
*€CÙØð ˆc�zØˆØˆÜ—H‘H˜_¨cÓ2ˆ	ÙÜ�y—‘ qÓ)Ó*ˆDØ—?‘? 1Ó%ˆDØ—
‘
˜3“ˆð	Ø+0Ö1 a”Cœ˜a›•MÐ1ˆDÐ1ô �$‹i˜!ŠmØ�K‰K˜˜1Ôô �$‹i˜!‹mäˆt‹9˜Š>Ø�D˜‘G‰OˆDØ˜˜�9ˆDØ�e‰|˜d 1™g¨™nÑ,¨t°A©w¸©|Ñ;¸dÀ1¹gÑEÐEä�L‰LØBÀCó€Eñ ”�U—\‘\“^Ô$ÙD°U·\±\³^ÔD‰ˆˆ1ˆa��AØ�6‰z˜A ™IÑ%¨¨D©Ñ0°1°r±6Ñ9¸AÑ=Ð=ðÜ”5˜“:‹Ðùò% 2øÜò 	Ùð	ûô$ ò Ùðús6   ÂF ÂFÂ+F Å=F% ÆF Æ	F"Æ!F"Æ%	F1Æ0F1c                 óž   — | €y| j                   € | j                  t        j                  ¬«      S | j	                  t        j                  «      S )zGSQLite drops tzinfo, so treat naive timestamps as UTC before comparing.N)Útzinfo)rR   Úreplacer   ÚutcÚ
astimezone)r)   s    r!   Úas_utcrV   Y   s>   € à€}ØØ‡|�|ÐØ�}‰}¤H§L¡Lˆ}Ó1Ð1Ø×ÑœHŸL™LÓ)Ð)r    c              ƒ   ó˜  K  — | j                  t        t        «      j                  t        j                  dk(  «      «      ƒ d{  –—† j                  «       j                  «       }i }|D ]©  }|j                  sŒ| j                  t        |j                  «      ƒ d{  –—† }|r|j                  sŒG	 t        |j                  d|j                  › �¬«      }t!        |j"                  |j$                  ||j&                  xs d¬«      ||j(                  <   Œ« |S 7 ŒÒ7 Œ|# t        $ r# t        j                  d|j                  «       Y ŒÝw xY w­w)a  Build one adapter per active MikroTik device that has valid credentials.

    Raises SecretDecryptionError when a stored secret cannot be decrypted with
    the active encryption key, so the caller can surface it instead of silently
    pushing ciphertext to the device.
    TNzKredensial )Úlabelz?voucher monitor skipped router %s: credential decryption failedé"  )ÚhostÚusernameÚpasswordÚapi_port)Úexecuter   r   ÚwhereÚ	is_activeÚscalarsÚallÚcredential_idÚgetr   r   Úencrypted_secretÚnamer   Ú_logÚ	exceptionr   rZ   r[   r]   Úid)ÚdbÚdevicesÚadaptersÚmkÚcredr\   s         r!   Ú_device_adaptersro   b   s%  è ø€ ð —Z‘ZÜŒ~Ó×$Ñ$¤^×%=Ñ%=ÀÑ%EÓFó÷ ç�wƒy—‘“ð ð 02€HØò 
ˆØ×ÒØØ—V‘VÔ,¨b×.>Ñ.>Ó?×?ˆÙ˜ŸšØð	Ü,Ø×%Ñ%¨{¸4¿9¹9¸+Ð-FôˆHô .Ø—‘Ø—]‘]ØØ—[‘[Ò( Dô	
ˆ�—‘Šð
ð* €Oð3øð @ùô %ò 	ô �N‰NÐ\Ð^`×^eÑ^eÔfÙð		üsJ   ‚AE
ÁDÁAE
ÂDÂE
Â1$DÃAE
ÄE
Ä)EÅE
ÅEÅE
c           
      óÎ  — | dv ryt        | «      j                  «       }|j                  «       rt        |«      S ddddddd	œ}|j	                  «       j                  d
d«      }|j                  «       D ]=  \  }}|j                  |«      sŒ	 t        t        |dt        |«        «      |z  «      c S  	 t        t        |«      «      S # t        $ r Y  yw xY w# t        $ r Y yw xY w)zDParse RouterOS byte counters like '123456' or '1.2MiB' -> int bytes.)Nr+   r    r   i   i   i   @iè  i@B i Êš;)ÚkibÚmibÚgibÚkbÚmbÚgbú r+   N)r7   r8   Úisdigitr   r9   rS   ÚitemsÚendswithr>   r?   r   )r)   ÚtextÚunitsÚloweredÚsuffixÚmults         r!   Ú_routeros_bytesr€   …   sè   € à�ÑØÜˆu‹:×ÑÓ€DØ‡|�|„~Ü�4‹yÐØ °9Ø˜y°	ñ;€Eà�j‰j‹l×"Ñ" 3¨Ó+€GØŸ™›ò ‰ˆ�Ø×Ñ˜FÕ#ðÜœ5 ¨¬C°«K¨<Ð!8Ó9¸DÑ@ÓAÒAððÜ”5˜“>Ó"Ð"øô ò Úðûô ò Ùðús$   Â#CÂ4C Ã	CÃCÃ	C$Ã#C$c               ƒ   ó”  K  — t        «       4 ƒd{  –—† } t        j                  t        j                  «      }| j                  t        t        «      j                  t        j                  dk7  «      «      ƒ d{  –—† j                  «       j                  «       }|s	 ddd«      ƒd{  –—†  y	 t        | «      ƒ d{  –—† }i }i }d}|j#                  «       D ]ƒ  \  }}		 t%        j&                  |	j(                  «      ƒ d{  –—† }
|
D �ci c]  }|d   |“Œ
 c}||<   d||<   | j+                  t,        |«      ƒ d{  –—† }|€Œk|j.                  |k7  sŒ{||_        d}Œ… |D �]½  }|j2                  xs |j4                  xs dj7                  «       }|j8                  }| j+                  t:        |j<                  «      ƒ d{  –—† }|r!|j+                  |i «      j+                  |«      nd}|j+                  |d«      }t?        |j@                  «      }tC        |xr ||k  «      }|r|j                  d	k7  r	d	|_	        d}d}|rÊtE        |j+                  d
«      «      }tE        |j+                  d«      «      xs tE        |jF                  «      }||jH                  xs dk  rd|_$        ||jH                  xs dz
  }|dkD  r*tK        |jL                  xs d«      |z   |_&        ||_$        d}|dkD  rtK        |jL                  xs d«      |k\  rd}|xr |du xr |j                  dk(  }tO        |xr |j+                  d«      «      xs tO        |xr |j+                  d«      «      }|rä|j+                  d«      stE        |j+                  d
«      «      dkD  s|r´|j                  dv r¦d|_	        |jP                  xs ||_(        |r+|jR                  rtU        tK        |jR                  «      ¬«      n.|r+|jV                  rtU        tK        |jV                  «      ¬«      nd}|r|jP                  |z   |_         d}t        jY                  d|«       |s|s|s�Œï|rÔ|j+                  |«      }	|s`|	r|st        j1                  d||«       �Œ!	 t%        j&                  |	jZ                  |«      ƒ d{  –—† }|s‘t        j1                  d|«       �Œd|�w|	r|st        j1                  d|«       �Œ‚	 t%        j&                  |	jZ                  |«      ƒ d{  –—† }|s0t        j1                  d|«       �ŒÅt        j                  d|«       �ŒÝddl/m0} |rd	n|rdnd}| jc                   ||jd                  |j4                  |j2                  |jf                  |jh                  |j                  |jj                  |jP                  tK        |jL                  xs d«      |||j<                  |jl                  ¬«      «       t        jY                  d||«       | jo                  |«      ƒ d{  –—†  d}�ŒÀ |r| jq                  «       ƒ d{  –—†  ddd«      ƒd{  –—†  y7 �Œ<7 �ŒÖ7 �Œª7 �Œ˜# t        $ r}t        j                  d|«       ‚ d}~wt         $ r Y ddd«      ƒd{  –—†7   yw xY w7 �Œšc c}w 7 �Œh# t         $ r$ i ||<   d||<   t        j1                  d|«       Y �Œúw xY w7 �Œ7 �Œ4# t         $ r t        j]                  d|«       Y �Œžw xY w7 �Œü# t         $ r t        j]                  d|«       Y �ŒÇw xY w7 �Œ7 Œ÷7 Œé# 1 ƒd{  –—†7  sw Y   yxY w­w)z9Sync voucher status/deletion against live RouterOS state.NÚreservedzvoucher reconcile stopped: %sFrf   Tz5voucher reconcile: RouterOS read failed for device %sr+   ÚexpiredÚuptimeÚlimit_uptimer   ÚusedÚbytes_inÚ	bytes_outÚactive)ÚsoldÚ	available)Úseconds)rE   z/voucher %s marked used (live RouterOS activity)zJvoucher %s: expiry cleanup deferred; router %s is not reachable/configuredz+voucher %s: RouterOS expiry deletion failedz6voucher %s: RouterOS expiry deletion was not confirmedz6voucher %s: expiry cleanup deferred; no router adapterz:voucher %s: expiry cleanup deferred; no router is assigned)ÚVoucherArchiveÚduration_exhaustedÚgone_from_device)Ú
voucher_idÚcoder[   ÚprofileÚpriceÚstatusÚsold_atÚused_atÚused_secondsÚ
deleted_atÚreasonÚbatch_idÚagent_idz*voucher %s removed (%s) from DB and device)9r   r   Únowr   rT   r^   r   r
   r_   r”   ra   rb   ro   r   rg   ÚerrorÚ	Exceptionry   ÚasyncioÚ	to_threadÚlist_hotspot_usersrd   r   Úlast_sync_atÚwarningr[   r‘   r8   Ú	device_idr   rš   rV   Ú
expires_atÚboolrP   r…   Úlast_poll_uptimer   r—   r€   r–   Úduration_secondsr   Úduration_daysÚinfoÚdelete_hotspot_userrh   Úapp.models.modelsr�   Úaddri   r’   r“   r•   r›   ÚdeleteÚcommit)rj   rœ   Úvouchersrl   ÚexcÚremote_by_deviceÚdevice_syncedÚchangedr¤   ÚadapterÚremote_rowsÚrowÚdeviceÚvr[   ÚbatchÚremoteÚ	is_syncedr¥   rƒ   rŽ   Úsession_secondsÚlimit_secondsÚdeltar�   Úhas_trafficÚvalidityÚdeletedr�   r™   s                                 r!   Úreconcile_vouchersrÃ   ›   sÃ  è ø€ ä Ó"÷ uð u bÜ�l‰lœ8Ÿ<™<Ó(ˆð —*‘*œV¤G›_×2Ñ2´7·>±>ÀZÑ3OÓPÓQ×Qß
‰'‹)—C‘C“Eð 	ñ Ø÷u÷ uð uð	Ü-¨bÓ1×1ˆHð 8:ÐØ)+ˆØˆØ"*§.¡.Ó"2ò 	#ÑˆI�wð#Ü$+×$5Ñ$5°g×6PÑ6PÓ$Q×Q�ØKVÖ.WÀC¨s°6©{¸CÑ/?Ò.WÐ  Ñ+Ø+/�˜iÑ(ð  "Ÿv™v¤n°iÓ@×@�ØÑ%¨&×*=Ñ*=ÀÓ*DØ*-�FÔ'Ø"‘Gð#	#ð& ó D	ˆAØŸ
™
Ò2 a§f¡fÒ2°×9Ñ9Ó;ˆHØŸ™ˆIØŸ&™&¤¨q¯z©zÓ:×:ˆEÙJSÐ%×)Ñ)¨)°RÓ8×<Ñ<¸XÔFÐY]ˆFØ%×)Ñ)¨)°UÓ;ˆIô   §¡Ó-ˆJÜ˜:Ò;¨*¸Ñ*;Ó<ˆGÙ˜1Ÿ8™8 yÒ0Ø$�”Ø�ð "'ÐÙÜ"6°v·z±zÀ(Ó7KÓ"L�Ü 4°V·Z±ZÀÓ5OÓ PÒ xÔThÐij×iwÑiwÓTx�à" a×&8Ñ&8Ò&=¸AÒ>ð *+�AÔ&à'¨1×+=Ñ+=Ò+BÀÑC�Ø˜1’9Ü%(¨¯©Ò)<¸1Ó%=ÀÑ%E�A”NØ)8�AÔ&Ø"�Gà  1Ò$¬¨Q¯^©^Ò-@¸qÓ)AÀ]Ò)RØ)-Ð&ð  )ÒR¨V°t¨^ÒRÀÇÁÈFÑ@RÐô *¨&Ò*K°V·Z±ZÀ
Ó5KÓLò ÔP_ØÒ2˜6Ÿ:™: kÓ2óQˆKñ Ø—:‘:˜hÔ'Ô+?ÀÇ
Á
È8Ó@TÓ+UÐXYÒ+YÑ]hØ—x‘xÐ#8Ñ8Ø#)˜œØ$%§I¡IÒ$4°˜œ	ñ # u×'=Ò'=ô $-Ü$'¨×(>Ñ(>Ó$?õ$ñ # u×':Ò':ô DMÜ!$ U×%8Ñ%8Ó!9õDà@Dð	 !ñ
 $Ø+,¯9©9°xÑ+?˜AœLØ"&˜ÜŸ	™	ØMÈxôñ Ñ1Ñ5EÙñ Ø"Ÿ,™, yÓ1�Ù Ù"©(ÜŸ™ØhØ$ iôñ !ð!Ü(/×(9Ñ(9¸'×:UÑ:UÐW_Ó(`×"`˜ñ #ÜŸ™Ð%]Ð_gÔhÙ ØÐ'Ù"©(ÜŸ™Ð%]Ð_gÔhÙ ð!Ü(/×(9Ñ(9¸'×:UÑ:UÐW_Ó(`×"`˜ñ #ÜŸ™Ð%]Ð_gÔhÙ ô —
‘
ÐWÐYaÔbÙõ 9á$‘	Ù.@Ñ*ÐFXð ð �F‰FÙØ Ÿt™t¨!¯&©&¸1¿:¹:ÈqÏyÉyØŸ'™'¨!¯(©(¸A¿I¹IÈqÏyÉyÜ!$ Q§^¡^Ò%8°qÓ!9Ø"¨6ØŸZ™Z°!·*±*ôôô �I‰IÐBÀHÈfÔUØ—)‘)˜A“,×ÐØŠGðID	ñR Ø—)‘)“+×Ð÷ku÷ uñ uùð Rùðuùð 2úÜ$ò 	Ü�J‰JÐ6¸Ô<ØûÜò 	Ø÷%u÷ uñ uð"	úð RûÚ.Wð Aúô ò ð /1Ð  Ñ+Ø+0�˜iÑ(Ü—‘ØKÈY÷ðúð" ;ùðn #aúÜ$ò !ÜŸ™Ð'TÐV^Ô_Ú ð!úð #aúÜ$ò !ÜŸ™Ð'TÐV^Ô_Ú ð!úð8 ùð øðkuø÷ u÷ uñ uüsÂ  ‚]‘Y’]•A%\3Á:YÁ;#\3Â]Â)YÂ*]Â0YÂ>YÂ?YÃ\3Ã "Z'ÄZÄZ'ÄZÄZ'Ä#\3Ä<Z$Ä=\3Å\3ÅA,\3Ç [ÇK\3Ò#[Ò&[Ò'[Ò+8\3Ó$#\Ô\Ô\ÔD\3Ø\,Ø\3Ø7\/Ø8\3Ø<]Ù\1Ù]Ù\3Ù]ÙYÙ	ZÙ"Y9Ù9ZÚ\3Ú]ÚZÚ]ÚZÚ\3ÚZ'ÚZ'Ú$\3Ú')[Û\3Û[Û\3Û[Û\ Û<\3Û?\ Ü \3Ü\Ü\)Ü%\3Ü(\)Ü)\3Ü/\3Ü1]Ü3]Ü9\<Ü:]Ý]c               ƒ   ó&  K  — 	 	 t        «       4 ƒd{  –—† } | j                  t        t        «      j	                  t        j
                  dk(  t        j                  j                  d«      t        j                  j                  d«      t        j                  j                  d«      «      «      ƒ d{  –—† j                  «       j                  «       }|D ]  }	 t        || «      ƒ d{  –—†  Œ ddd«      ƒd{  –—†  t        j"                  t%        «       «      ƒ d{  –—†  �Œ#7 �Œ7 Œv7 ŒB# t        $ r | j                  «       ƒ d{  –—†7   Y Œ|w xY w7 ŒZ# 1 ƒd{  –—†7  sw Y   ŒjxY w# t        j                   $ r ‚ t        $ r Y Œ‹w xY w7 Œn­w)zMKeep billing status aligned with live OLT/MikroTik state and expire vouchers.NF)r   r^   r   r   r_   Úis_archivedÚpppoe_usernameÚis_notÚmikrotik_device_idÚolt_device_idra   rb   r	   rž   ÚrollbackrŸ   ÚCancelledErrorÚsleepr"   )rj   Ú	customersÚcustomers      r!   Úmonitor_looprÏ   U  sZ  è ø€ à
ð	Ü(Ó*÷ ,ð ,¨bØ#%§:¡:Üœ8Ó$×*Ñ*Ü ×,Ñ,°Ñ5Ü ×/Ñ/×6Ñ6°tÓ<Ü ×3Ñ3×:Ñ:¸4Ó@Ü ×.Ñ.×5Ñ5°dÓ;ó	ó$÷ ÷ ‘7“9ŸS™S›Uð ð !*ò ,�Hð,Ü<¸XÀrÓJ×JÑJð,÷,÷ ,ô$ �m‰mœM›OÓ,×,Ð,ñ) ð,ùðøð KùÜ$ò ,Ø Ÿk™k›m×+Ó+ð,úð,ø÷ ,÷ ,ñ ,ûô ×%Ñ%ò 	ØÜò 	Ùð	úà,úsÎ   ‚F…E- “D'”E- —BEÂ3D*Â4%EÃD.Ã)D,Ã*D.Ã.EÃ0E- Ã;EÃ<E- Ä  FÄ FÄ!FÄ'E- Ä*EÄ,D.Ä.EÅ
E
ÅEÅEÅEÅEÅE- ÅE*ÅE!ÅE*Å&E- Å-FÆ	FÆFÆFc               ƒ   óô   K  — 	 	 t        «       ƒ d{  –—†  t        j                  t        «       «      ƒ d{  –—†  Œ97 Œ*# t        j                  $ r ‚ t        $ r t        j                  d«       Y Œ[w xY w7 Œ>­w)zDFast lane voucher reconciliation so UI reflects RouterOS state live.Nzvoucher reconcile cycle failed)rÃ   rŸ   rË   rž   rg   rh   rÌ   r(   r   r    r!   Úvoucher_monitor_looprÑ   n  sj   è ø€ à
ð	=Ü$Ó&×&Ð&ô
 �m‰mÔ1Ó3Ó4×4Ð4ð à&ùÜ×%Ñ%ò 	ØÜò 	=Ü�N‰NÐ;Ö<ð	=úà4ús;   ‚A8…? ’=“? — A8·A6¸A8½? ¿1A3Á0A8Á2A3Á3A8c                  óÖ   ‡‡— ddl ŠddlmŠ ˆˆfd„} 	 ‰j                   | «       «      }|rt        d„ |D «       «      |dœS d|dœS # t        $ r}dt        |«      g dœcY d}~S d}~ww xY w)	zFReport whether live voucher reconciliation can actually reach devices.r   Nr   c            	   “   ó   •K  —  ‰	«       4 ƒd {  –—† } | j                  t        t        «      j                  t        j                  dk(  «      «      ƒ d {  –—† j                  «       j                  «       }g }|D ]º  }|j                  |j                  |j                  xs dd dd dœ}	 t        | «      ƒ d {  –—† }|j                  |j                  «      }|€d|d<   nE‰
j                  |j                  «      ƒ d {  –—† }|j                  |d<   d|d<   t!        |«      |d	<   |j'                  |«       Œ¼ |cd d d «      ƒd {  –—†  S 7 �Œ;7 Œ÷7 Œ—7 ŒS# t"        $ r}t%        |«      |d<   Y d }~ŒKd }~ww xY w7 Œ2# 1 ƒd {  –—†7  sw Y   y xY w­w)
NTrY   F)r¸   rZ   ÚportÚ
credentialÚokr�   z)Kredensial tidak aktif / belum ditugaskanr�   rÕ   rÖ   Úusers)r^   r   r   r_   r`   ra   rb   rf   rZ   r]   ro   rd   ri   r    r¡   r[   r?   rž   r7   Úappend)rj   rk   Úreportrm   Úitemrl   rµ   Úrowsr±   Ú_SessionÚ_asyncios            €€r!   Úprobez'voucher_reconcile_health.<locals>.probe  ss  øè ø€ Ù“:÷ 	ð 	 ØŸZ™ZÜ”~Ó&×,Ñ,¬^×-EÑ-EÈÑ-MÓNó÷ ç‰w‹yŸ™›ð ð ˆFØò $�à Ÿg™gØŸG™GØŸK™KÒ/¨4Ø"&ØØ!ñ�ð-Ü%5°bÓ%9×9�HØ&Ÿl™l¨2¯5©5Ó1�GØ�Ø(S˜˜Wšà%-×%7Ñ%7¸×8RÑ8RÓ%S×S˜Ø-4×-=Ñ-=˜˜\Ñ*Ø%)˜˜T™
Ü(+¨D«	˜˜W™ð —‘˜dÕ#ð+$ð, ÷7	÷ 	ò 	ùðøð  :øð
  Tùô !ò -Ü$'¨£H�D˜–Mûð-úð1	ø÷ 	÷ 	ñ 	üs§   ƒF�E
�F“AE9ÁEÁAE9Â)EÂ7EÂ8AEÃ=EÃ>&EÄ$E9Ä8FÅE7ÅFÅE9ÅEÅEÅ	E4ÅE/Å*E9Å/E4Å4E9Å7FÅ9FÅ?FÆ FÆFF)rÖ   r�   rk   c              3   ó&   K  — | ]	  }|d    –— Œ y­w)rÖ   Nr   )r4   rL   s     r!   r6   z+voucher_reconcile_health.<locals>.<genexpr>¢  s   è ø€ Ò+˜a�!�D•'Ñ+ùs   ‚)rÖ   rk   )rŸ   Úapp.core.databaser   Úrunrž   r7   rb   )rÞ   rk   r±   rÜ   rÝ   s      @@r!   Úvoucher_reconcile_healthrâ   z  su   ù€ ãÝ?õð<?Ø—,‘,™u›wÓ'ˆñ 07ŒcÑ+ 7Ô+Ó+Øñð Ø<AØñð øô ò ?Ø¤c¨#£h¸2Ñ>Õ>ûð?ús   ”A Á	A(ÁA#ÁA(Á#A()r   N))Ú__doc__rŸ   Úloggingr   r:   Ú	getLoggerrg   Ú
sqlalchemyr   r   r   r   rà   r   Úapp.core.onboardingr	   r¬   r
   r   r   r   r   r   Úapp.core.mikrotikr   Úapp.core.secretsr   r   r   r"   r(   r7   rP   rV   Údictro   r€   rÃ   rÏ   rÑ   râ   r   r    r!   ú<module>rë      sÞ   ðñó Û Û 	Û 	à€w×ÑÐ2Ó3€å ß 2Ñ 2å /Ý >ß ]Õ ]÷ó õ 2ß Ið�só ð˜só ð'  d¡
ð '¨só 'ðT*�(˜T‘/ð * h°¡oó *ð  $ sÐ,?Ð'?Ñ"@ó  ðF˜có ó,wót-ó2	5ð* $ô *r    