+
     …Õj{  ã                   ó  € ^ RI H t  ^ RIHtHtHtHtHtHtHtH	t	H
t
 ^ RIHt ^ RIHt ^ RIt^ RIHt  ! R R]]P                  4      t ! R	 R
]]P                  4      t ! R R]4      t ! R R]]P                  4      t ! R R]]P                  4      t ! R R]4      t ! R R]4      t ! R R]4      t ! R R]4      t ! R R]4      t ! R R]4      t ! R R]4      t ! R R ]4      t ! R! R"]4      t  ! R# R$]4      t! ! R% R&]4      t" ! R' R(]4      t# ! R) R*]4      t$ ! R+ R,]4      t% ! R- R.]4      t& ! R/ R0]4      t'^ RIt ! R1 R2]]P                  4      t( ! R3 R4]4      t) ! R5 R6]4      t* ! R7 R8]4      t+ ! R9 R:]4      t, ! R; R<]4      t- ! R= R>]4      t. ! R? R@]4      t/ ! RA RB]4      t0 ! RC RD]4      t1 ! RE RF]4      t2 ! RG RH]4      t3 ! RI RJ]4      t4 ! RK RL]4      t5 ! RM RN]4      t6 ! RO RP]4      t7R# )Qé    )Údatetime)	ÚColumnÚIntegerÚStringÚBooleanÚ
ForeignKeyÚDateTimeÚEnumÚTextÚUniqueConstraint)Úrelationship)ÚfuncN)ÚBasec                   ó&   € ] tR t^tRtRtRtRtRtR# )ÚUserRoleÚsuper_adminÚadmin_csÚteknisiÚagen_voucher© N)	Ú__name__Ú
__module__Ú__qualname__Ú__firstlineno__ÚSUPER_ADMINÚADMIN_CSÚTEKNISIÚAGEN_VOUCHERÚ__static_attributes__r   ó    Ú#/var/www/html/bestweb/app/models.pyr   r      s   † Ø€KØ€HØ€GØ!„Lr    r   c                   ó   € ] tR t^tRtRtRtR# )ÚCustomerTypeÚbulanan_pppÚhotspot_voucherr   N)r   r   r   r   ÚBULANAN_PPPÚHOTSPOT_VOUCHERr   r   r    r!   r#   r#      s   † Ø€KØ'„Or    r#   c                   ób  € ] tR t^tRtRt]! ]RRR7      t]! ]	RRRR7      t
]! ]	RR7      t]! ]	RRR	7      t]! ]	RR
R	7      t]! ]R^ R	7      t]! ]	4      t]! ]	RR7      t]! ]^¯R7      t]! ]^dR7      t]! ]^–R7      t]! ]^ÈR7      t]! ]]! R4      RR7      t]! ]RR7      t]! R].R7      tRtR# )ÚServicePackagezHAdmin-maintained commercial/service options shown in installation forms.Úservice_packagesT©Úprimary_keyÚindexF©ÚuniqueÚnullabler-   ©r0   r$   ©r0   ÚdefaultÚprivate_pppoeÚbnbv1009©r3   úservice_profiles.idÚServiceProfile©Úforeign_keysr   N)r   r   r   r   Ú__doc__Ú__tablename__r   r   Úidr   ÚcodeÚnameÚservice_typeÚservice_modeÚpriceÚmikrotik_profileÚolt_vlan_profileÚservice_vlanÚ
pppoe_vlanÚhotspot_vlanÚ	iptv_vlanr   Úservice_profile_idr   Ú	is_activer   Úservice_profiler   r   r    r!   r)   r)      sØ   † ÙRØ&€MÙ	� T°Ô	6€BÙ�& °¸TÔB€DÙ�& 5Ô)€DÙ˜&¨5¸-ÔH€LÙ˜&¨5¸/ÔJ€LÙ�7 U°AÔ6€EÙ˜f“~ÐÙ˜f¨jÔ9ÐÙ˜'¨3Ô/€LÙ˜¨Ô-€JÙ˜'¨3Ô/€LÙ�w¨Ô,€IÙ ©Ð4IÓ)JÐUYÔZÐÙ�w¨Ô-€IÙ"Ð#3ÐCUÐBVÔW„Or    r)   c                   ó*   € ] tR t^%tRtRtRtRtRtRt	R# )ÚCustomerStatusÚrequestÚ
installingÚconfiguringÚactiveÚ	suspendedr   N)
r   r   r   r   ÚREQUESTÚ
INSTALLINGÚCONFIGURINGÚACTIVEÚ	SUSPENDEDr   r   r    r!   rM   rM   %   s   † Ø€GØ€JØ€KØ€FØ„Ir    rM   c                   ó   € ] tR t^,tRtRtRtR# )ÚServiceModeÚhotspotr4   r   N)r   r   r   r   ÚHOTSPOTÚPRIVATE_PPPOEr   r   r    r!   rY   rY   ,   s   † Ø€GØ#„Mr    rY   c                   ó¢   € ] tR t^0tRt]! ]RRR7      t]! ]RRR7      t	]! ]4      t
]! ]4      t]! ]]P                  R7      t]! ]RR7      tRtR# )ÚUserÚusersTr+   )r/   r-   r6   r   N)r   r   r   r   r<   r   r   r=   r   ÚusernameÚ	full_nameÚhashed_passwordr   r   Úroler   rJ   r   r   r    r!   r^   r^   0   sS   † Ø€Má	� T°Ô	6€BÙ�f T°Ô6€HÙ�v“€IÙ˜V“n€OÙ�& (×"2Ñ"2Ô3€DÙ�w¨Ô-„Ir    r^   c                   ór   € ] tR t^:tRt]! ]RR7      t]! ]4      t	]! ]4      t
]! ]4      t]! ]RR7      tRtR# )ÚMikrotikConfigÚmikrotik_configsT©r,   é"  r6   r   N)r   r   r   r   r<   r   r   r=   r   Úhostr`   ÚpasswordÚapi_portr   r   r    r!   re   re   :   s:   † Ø&€MÙ	� TÔ	*€BÙ�&‹>€DÙ�f‹~€HÙ�f‹~€HÙ�g tÔ,„Hr    re   c                   ó˜  € ] tR t^BtRt]! ]RRR7      t]! ]RR7      t	]! ]RRRR7      t
]! ]RRRR7      t]! ]4      t]! ]4      t]! ]4      t]! ]RR7      t]! ]]P$                  R7      t]! ]^ R7      t]! ]]! R4      RR	7      t]! ]]! R
4      RR	7      t]! ]RR7      t]! ]RR7      t]! ]! RR7      RR	7      t]! ]4      t]! ]4      t]! ]4      t]! ]4      t ]! ]4      t!]! ]]! R4      RR	7      t"]! ]]! R4      RR	7      t#]! ]RR7      t$]! ]RR7      t%]! ]4      t&]! ]4      t']! ]4      t(]! ]RR7      t)]! ]RR7      t*]! ]RR7      t+]! ]RR7      t,]! ]RR7      t-]! ]4      t.]! ]4      t/]! ]4      t0]! ]4      t1]! ]4      t2]! ]4      t3]! ]4      t4]! ]4      t5]! ]4      t6]! ]4      t7]! ]RR7      t8]! ]! RR7      4      t9]! ]RR7      t:]! ]! RR7      4      t;]! ]4      t<]! ]4      t=]! ]4      t>]! ]4      t?]! ]4      t@]! ]! RR7      RR	7      tA]! ]^R7      tB]! ]]CPˆ                  PŠ                  R7      tF]! ]4      tG]! ]4      tH]! ]RR	7      tI]! ]4      tJ]! ]RR7      tK]! ]RR7      tL]! ]RR7      tM]! ]4      tN]! ]^¯R7      tO]! ]^¯R7      tP]! ]^dR7      tQ]! ]^–R7      tR]! ]^ÈR7      tS]! ]RR7      tT]! ]4      tU]! ]! RR7      ]VP®                  ! 4       R7      tX]! ]! RR7      ]VP®                  ! 4       R7      tY]! ]]! R4      4      tZ]! ]]! R4      RR	7      t[]! ]RR	7      t\]]! R]Z.R7      t^]]! R][.R7      t_]]! R ]".R7      t`]]! R!]#.R7      ta]]! R"].R7      tb]]! R#].R7      tc]! ]R$R7      td]! ]R%R7      te]! ]R%R7      tf]! ]4      tg]! ]! RR7      RR	7      th]! ]! RR7      RR	7      tiR&tjR'# )(ÚCustomerÚ	customersTr+   ©r-   ©r/   r-   r0   Ú1playr6   zservice_packages.idr1   r7   F©Útimezoneúolt_devices.idúmikrotik_devices.idÚZTEÚC320ÚmanualÚunavailableÚnot_configuredÚ
unverifiedr4   z	["pppoe"]Únoner5   ©Úserver_default©Úonupdateúusers.idzodps.idr^   r9   ÚODPÚ	OLTDeviceÚMikrotikDevicer)   r8   Únot_startedÚpendingr   N)kr   r   r   r   r<   r   r   r=   r   r?   Úcustomer_codeÚnikr   ÚaddressÚphoneÚtypeÚ	play_typerM   rS   ÚstatusÚharga_paketr   Úservice_package_idrI   r   Úis_paidÚis_archivedr	   Újatuh_tempoÚodp_infoÚont_snÚ	ont_brandÚont_rx_powerÚont_tx_powerÚolt_device_idÚmikrotik_device_idÚ
olt_vendorÚ	olt_modelÚolt_adapter_keyÚolt_fields_jsonÚolt_portÚont_sn_modeÚonu_id_modeÚolt_port_modeÚont_brand_modeÚhardware_discovery_statusÚodp_latitudeÚodp_longitudeÚcustomer_latitudeÚcustomer_longitudeÚwifi_ssid_24Úwifi_password_24_encÚwifi_ssid_5Úwifi_password_5_encÚwifi_ssid_hotspotÚwifi_password_hotspot_encÚacs_wifi_statusÚacs_last_syncÚinternet_check_statusÚinternet_checked_atÚinternet_checked_byÚmikrotik_userÚmikrotik_passÚpppoe_usernameÚpppoe_passwordÚpppoe_secret_revealed_atÚpppoe_secret_versionrY   r\   ÚvaluerA   Úmanagement_pppoe_usernameÚmanagement_pppoe_passwordÚmanagement_pppoe_vlanrK   Úprovisioning_modeÚservice_modes_jsonÚont_management_modeÚonu_idÚwan_vlanrE   rF   rG   rH   rD   Úvlan_idr   ÚnowÚ
created_atÚ
updated_atÚassigned_teknisi_idÚodp_idÚodp_portr   Úassigned_teknisiÚodpÚ
olt_deviceÚmikrotik_deviceÚservice_packageÚservice_catalog_profileÚprovisioning_statusÚmikrotik_provisioning_statusÚolt_provisioning_statusÚprovisioning_messageÚprovisioned_atÚ wan_recovery_reboot_attempted_atr   r   r    r!   rm   rm   B   se  † Ø€Má	� T°Ô	6€BÙ�& Ô%€DÙ˜6¨$°dÀTÔJ€MÙ
� ¨D¸4Ô
@€CÙ�T‹l€GÙ�6‹N€Eá�&‹>€DÙ�v wÔ/€IÙ�F N×$:Ñ$:Ô;€Fñ ˜¨!Ô,€KÙ ©Ð4IÓ)JÐUYÔZÐÙ ©Ð4IÓ)JÐUYÔZÐÙ�W eÔ,€GÙ˜¨%Ô0€KÙ™¨4Ô0¸4Ô@€Ká�f‹~€HÙ�F‹^€FÙ�v“€IÙ˜&“>€LÙ˜&“>€Lá˜7¡JÐ/?Ó$@È4ÔP€MÙ ©Ð4IÓ)JÐUYÔZÐÙ˜¨Ô.€JÙ�v vÔ.€IÙ˜V“n€OÙ˜T“l€OÙ�f‹~€HÙ˜¨Ô2€KÙ˜¨Ô2€KÙ˜6¨8Ô4€MÙ˜F¨HÔ5€NÙ & v°}Ô EÐÙ˜&“>€LÙ˜6“N€MÙ˜v›ÐÙ ›ÐÙ˜&“>€LÙ! &›>ÐÙ˜“.€KÙ  ›.ÐÙ˜v›ÐÙ & v£ÐÙ˜VÐ-=Ô>€OÙ™8¨TÔ2Ó3€MÙ" 6°<Ô@ÐÙ ¡°4Ô!8Ó9ÐÙ  ›.Ðá˜6“N€MÙ˜6“N€MÙ˜F“^€NÙ˜F“^€NÙ%¡h¸Ô&=ÈÔMÐÙ! '°1Ô5ÐÙ˜&¨+×*CÑ*C×*IÑ*IÔJ€LÙ & v£ÐÙ & v£ÐÙ" 7°TÔ:ÐÙ˜V“n€OÙ˜v¨Ô?ÐÙ ¨kÔ:ÐÙ  °Ô8ÐÙ�G‹_€FÙ�g sÔ+€HÙ˜'¨3Ô/€LÙ˜¨Ô-€JÙ˜'¨3Ô/€LÙ�w¨Ô,€IÙ˜f¨jÔ9ÐÙ�W‹o€Gá™¨$Ô/ÀÇÂÃ
ÔK€JÙ™¨$Ô/¸$¿(º(»*ÔE€Já  ©*°ZÓ*@ÓAÐÙ�G™Z¨	Ó2¸TÔB€FÙ�g¨Ô-€HÙ# FÐ:MÐ9NÔOÐÙ
�u¨F¨8Ô
4€CÙ˜k¸¸ÔH€JÙ"Ð#3ÐCUÐBVÔW€OÙ"Ð#3ÐCUÐBVÔW€OÙ*Ð+;ÐK]ÐJ^Ô_Ðñ ! °Ô?ÐÙ#)¨&¸)Ô#DÐ Ù$ V°YÔ?ÐÙ! $›<ÐÙ™H¨dÔ3¸dÔC€NÙ'-©hÀÔ.EÐPTÔ'UÔ$r    rm   c                   óÜ  € ] tR t^¦tRt]! ]RRR7      t]! ]RR7      t	]! ]4      t
]! ]RR7      t]! ]^ R7      t]! ]]! R4      RR7      t]! ]R	R7      t]! ]]! R
4      RR7      t]! ]^ R7      t]! ]RR7      t]! ]RR7      t]! ]RRRR7      t]! ]RR7      t]! ]RR7      t]! ]RR7      t]! ]RR7      t]! ]RR7      t]! ]RR7      t]! ]]P<                  R7      t]! ]RR7      t Rt!R# )ÚVoucherAgentÚvoucher_agentsTr+   Fr1   ro   r6   úsites.idÚsuper_agentúvoucher_agents.idÚ0)r0   r3   r~   r   N)"r   r   r   r   r<   r   r   r=   r   r?   rŠ   ÚareaÚcommission_rater   Úsite_idÚ
agent_typeÚparent_super_agent_idÚoverride_commission_rateÚlogin_phoneÚpassword_hashr   Úportal_enabledÚnama_ispÚ
domain_ispÚprefixr>   ÚcommentrJ   r	   r   rÃ   rÄ   rÅ   r   r   r    r!   rÖ   rÖ   ¦   s  † Ø$€MÙ	� T°Ô	6€BÙ�& 5Ô)€DÙ�6‹N€EÙ�& Ô%€DÙ˜W¨aÔ0€OÙ�W™j¨Ó4¸tÔD€GÙ˜¨Ô6€JÙ" 7©JÐ7JÓ,KÐVZÔ[ÐÙ% g°qÔ9Ðá˜¨$Ô/€KÙ˜6¨DÔ1€MÙ˜G¨e¸UÐSVÔW€Nñ �f tÔ,€HÙ˜¨Ô.€JÙ�F TÔ*€FÙ�& 4Ô(€DÙ�V dÔ+€GÙ�w¨Ô-€IÙ˜¨(¯,©,Ô7€JÙ˜¨4Ô0„Jr    rÖ   c                   ó,  € ] tR t^ÀtRt]! ]RRR7      t]! ]RRRR7      t	]! ]RRR7      t
]! ]RR7      t]! ]RR	7      t]! ]RR7      t]! ]RR7      t]! ]RR7      t]! ]]! R
4      RR7      t]! ]^ R	7      t]! ]RR	7      t]! ]]! R4      RR7      t]! ]RR7      t]! ]RR7      t]! ]RR7      t]! ]! RR7      RR7      t]! ]! RR7      RR7      t]! ]^ RR7      t]! ]^ RR7      t]! ]! RR7      RR7      t]! ]RR	7      t]! ]RR7      t ]! ]]! R4      RR7      t!]! ]]! R4      RR7      t"]! ]]! R4      RR7      t#]! ]]$PJ                  R	7      t&]! ]]! R4      RR7      t']! ]RR7      t(])! R].R7      t*])! R]!.RR7      t+])! R].R7      t,Rt-R# )ÚVoucherÚvouchersTr+   Frp   ©r0   r-   r1   Úlegacy_samer6   úhotspot_profiles.idÚ	availablerÚ   rr   ©r3   r0   r†   úvoucher_batches.idru   rØ   r�   rÖ   r9   ÚVoucherBatch©r:   Úback_populatesÚHotspotProfiler   N).r   r   r   r   r<   r   r   r=   r   r>   r`   r   Úpassword_ciphertextÚcredential_modeÚcredential_lengthÚcharacter_modeÚprofiler   Ú
profile_idrB   r�   Úagent_idrè   Úlimit_uptimeÚlimit_idle_timer	   Úsold_atÚused_atÚused_secondsÚlast_poll_uptimeÚ
expires_atÚsync_statusÚsync_updated_atÚbatch_idÚ	device_idrÞ   r   rÃ   rÄ   Ú
created_byÚ
sold_pricer   ÚagentÚbatchÚhotspot_profiler   r   r    r!   rê   rê   À   s×  † Ø€MÙ	� T°Ô	6€Bá�& ¨T¸EÔB€DÙ�f t°4Ô8€HÙ  °Ô5ÐÙ˜V¨]Ô;€OÙ˜w°Ô6ÐÙ˜F¨TÔ2€NÙ�V eÔ,€GÙ˜¡Ð,AÓ!BÈTÔR€JÙ�7 AÔ&€EÙ�F KÔ0€FÙ�g™zÐ*=Ó>ÈÔN€HÙ�V dÔ+€GÙ˜&¨4Ô0€LÙ˜V¨dÔ3€OÙ‘X tÔ,°tÔ<€GÙ‘X tÔ,°tÔ<€Gñ ˜'¨1°uÔ=€Lá˜g¨q¸5ÔAÐÙ™¨$Ô/¸$Ô?€JÙ˜¨Ô3€KÙ˜X°Ô5€OÙ�g™zÐ*>Ó?È$ÔO€HÙ�w¡
Ð+@Ó AÈDÔQ€IÙ�W™j¨Ó4¸tÔD€GÙ˜¨(¯,©,Ô7€JÙ˜¡¨JÓ!7À$ÔG€JÙ˜¨$Ô/€JÙ˜°x°jÔA€EÙ˜°x°jÐQ[Ô\€EÙ"Ð#3À:À,ÔO„Or    rê   c                   ó„  € ] tR t^çtRt]! ]RRR7      t]! ]]! R4      RRR7      t	]! ]RR7      t
]! ]RR7      t]! ]RR	7      t]! ]R
R	7      t]! ]4      t]! ]! RR7      ]P$                  ! 4       R7      t]! ]]! R4      RR7      t]! ]RR7      t]! ]]! R4      RR7      t]! ]]! R4      RR7      t]! R]	.R7      tRtR# )ÚPaymentÚpaymentsTr+   úcustomers.idFrì   r1   Úcashr6   Úpaidrr   r}   úvouchers.idru   rØ   rm   r9   r   N)r   r   r   r   r<   r   r   r=   r   Úcustomer_idÚamountr   ÚperiodÚmethodr�   Ú	referencer	   r   rÃ   Úpaid_atÚ
voucher_idÚreference_typer  rÞ   r   Úcustomerr   r   r    r!   r  r  ç   sÏ   † Ø€MÙ	� T°Ô	6€BÙ˜¡*¨^Ó"<ÀuÐTXÔY€KÙ�G eÔ,€FÙ�F UÔ+€FÙ�F FÔ+€FÙ�F FÔ+€FÙ�v“€IÙ‘X tÔ,¸T¿XºX»ZÔH€GÙ˜¡¨MÓ!:ÀTÔJ€JÙ˜F¨TÔ2€NÙ�w¡
Ð+@Ó AÈDÔQ€IÙ�W™j¨Ó4¸tÔD€GÙ˜J°k°]ÔC„Hr    r  c                   óî   € ] tR t^÷tRt]! ]RRR7      t]! ]]! R4      RRR7      t	]! ]
RRR7      t]! ]RR7      t]! ]! RR7      RR7      t]! ]
R	RR
7      t]! ]! RR7      RR7      t]! R]	.R7      tRtR# )ÚInvoiceÚinvoicesTr+   r  Frì   r1   rr   Úunpaid©r3   r-   rm   r9   r   N)r   r   r   r   r<   r   r   r=   r   r  r   r  r  r	   Údue_dater�   r  r   r  r   r   r    r!   r  r  ÷   sƒ   † Ø€MÙ	� T°Ô	6€BÙ˜¡*¨^Ó"<ÀuÐTXÔY€KÙ�F U°$Ô7€FÙ�G eÔ,€FÙ‘h¨Ô-¸Ô>€HÙ�F H°DÔ9€FÙ‘X tÔ,°tÔ<€GÙ˜J°k°]ÔC„Hr    r  c                   óò   € ] tR tRtRtRt]! ]RRR7      t]! ]	RRRR7      t
]! ]	RR7      t]! ]	RR7      t]! ]RR7      t]! ]RRR	7      t]! ]! RR
7      ]P&                  ! 4       R7      t]! ]	RR7      tRtR# )ÚDeviceCredentiali  zKEncrypted login material referenced by a device; plaintext is never stored.Údevice_credentialsTr+   Fr.   r1   r2   rr   r}   r   N)r   r   r   r   r;   r<   r   r   r=   r   r?   Úprotocolr`   r   Úencrypted_secretr   rJ   r	   r   rÃ   rÄ   Ú	cred_typer   r   r    r!   r$  r$    s~   † ÙUØ(€MÙ	� T°Ô	6€BÙ�& °¸TÔB€DÙ�f uÔ-€HÙ�f uÔ-€HÙ˜d¨UÔ3ÐÙ�w¨¸Ô=€IÙ™¨$Ô/ÀÇÂÃ
ÔK€JÙ�v¨Ô-„Ir    r$  c                   ó>  € ] tR tRtRt]! ]RRR7      t]! ]RR7      t	]! ]RR7      t
]! ]RR7      t]! ]RR	7      t]! ]R
R7      t]! ]RR7      t]! ]]! R4      RR7      t]! ]RR7      t]! ]]! R4      RR7      t]! ]RR7      t]! ]RR7      t]! R].R7      tRtR# )r„   i  Úmikrotik_devicesTr+   Fr1   rh   r6   ro   Ú
registeredúdevice_credentials.idrØ   r$  r9   r   N)r   r   r   r   r<   r   r   r=   r   r?   ri   rk   rÜ   r�   r   rJ   r   Úcredential_idÚhotspot_namerÞ   r	   Úlast_sync_atÚoffline_moder   Ú
credentialr   r   r    r!   r„   r„     s¸   † Ø&€MÙ	� T°Ô	6€BÙ�& 5Ô)€DÙ�& 5Ô)€DÙ�g tÔ,€HÙ�& Ô%€DÙ�F LÔ1€FÙ�w¨Ô-€IÙ˜7¡JÐ/FÓ$GÐRVÔW€MÙ˜&¨4Ô0€LÙ�W™j¨Ó4¸tÔD€GÙ˜(¨TÔ2€LÙ˜'¨5Ô1€LÙÐ0À¸ÔO„Jr    r„   c                   ó8  € ] tR tRtRt]! ]RRR7      t]! ]RR7      t	]! ]RR7      t
]! ]RR7      t]! ]RR7      t]! ]4      t]! ]4      t]! ]RR7      t]! ]4      t]! ]R	R7      t]! ]RR7      t]! ]]! R
4      RR7      t]! ]RR7      t]! R].R7      tRtR# )rƒ   i  Úolt_devicesTr+   Fr1   Ússhr6   r+  r,  r$  r9   r   N)r   r   r   r   r<   r   r   r=   r   r?   ri   ÚvendorÚmodelÚlocationÚpop_nameÚmanagement_protocolrk   r�   r   rJ   r   r-  r.  r   r1  r   r   r    r!   rƒ   rƒ     sµ   † Ø!€MÙ	� T°Ô	6€BÙ�& 5Ô)€DÙ�& 5Ô)€DÙ�F UÔ+€FÙ�6 EÔ*€EÙ�f‹~€HÙ�f‹~€HÙ  °Ô7ÐÙ�g‹€HÙ�F LÔ1€FÙ�w¨Ô-€IÙ˜7¡JÐ/FÓ$GÐRVÔW€MÙ˜&¨4Ô0€LÙÐ0À¸ÔO„Jr    rƒ   c                   óÚ   € ] tR tRtRt]! ]RRR7      t]! ]RRR7      t	]! ]RR7      t
]! ]4      t]! ]4      t]! ]^R7      t]! ]]! R	4      RR7      t]! R
].R7      t]! ]RR7      tRtR# )r‚   i0  ÚodpsTr+   F©r/   r0   r1   r6   ru   r„   r9   r   N)r   r   r   r   r<   r   r   r=   r   r>   r?   ÚlatitudeÚ	longitudeÚ
port_countr   r™   r   rÌ   r   rJ   r   r   r    r!   r‚   r‚   0  s€   † Ø€MÙ	� T°Ô	6€BÙ�& °Ô6€DÙ�& 5Ô)€DÙ�f‹~€HÙ�v“€IÙ˜¨Ô+€JÙ ©Ð4IÓ)JÐUYÔZÐÙ"Ð#3ÐCUÐBVÔW€OÙ�w¨Ô-„Ir    r‚   c                   ó²   € ] tR tRtRtRt]! ]RRR7      t]! ]	RRRR7      t
]! ]	RR7      t]! ]	RR7      t]! ]RR7      t]! ]RR7      t]! ]RRR	7      tR
tR# )r8   i<  z;Admin-managed technical profile used by installation forms.Úservice_profilesTr+   Fr.   r1   r2   r   N)r   r   r   r   r;   r<   r   r   r=   r   r>   r?   rD   Údownload_kbpsÚupload_kbpsr   rJ   r   r   r    r!   r8   r8   <  sg   † ÙEØ&€MÙ	� T°Ô	6€BÙ�& °¸TÔB€DÙ�& 5Ô)€DÙ˜f¨tÔ4ÐÙ˜7¨TÔ2€MÙ˜¨4Ô0€KÙ�w¨¸Ô=„Ir    r8   c                   óž   € ] tR tRtRt]! ]RRR7      t]! ]RRR7      t]! ]RR7      t	]! ]
RRR	7      t]! ]RRR	7      t]! R
RRR7      3tRtR# )ÚVlanMappingRuleiG  Úvlan_mapping_rulesTr+   Frì   r1   Úservicer2   Úsource_vlanÚpurposeÚuq_vlan_mapping_source_purpose)r?   r   N)r   r   r   r   r<   r   r   r=   rH  Útarget_vlanr   rI  r   rJ   r   Ú__table_args__r   r   r    r!   rE  rE  G  s]   † Ø(€MÙ	� T°Ô	6€BÙ˜¨5¸Ô=€KÙ˜¨5Ô1€KÙ�V e°YÔ?€GÙ�w¨¸Ô=€IÙ& }°iÐFfÔgÐi„Nr    rE  c                   óì   € ] tR tRtRt]! ]RRR7      t]! ]]! R4      RR7      t	]! ]
RR7      t]! ]
4      t]! ]4      t]! ]4      t]! ]! RR7      ]P$                  ! 4       R	7      t]! R
]	.R7      tRtR# )ÚAuditLogiP  Ú
audit_logsTr+   r�   r1   Frr   r}   r^   r9   r   N)r   r   r   r   r<   r   r   r=   r   Úuser_idr   ÚactionÚentityÚ	entity_idr   Údetailr	   r   rÃ   rÄ   r   Úuserr   r   r    r!   rN  rN  P  st   † Ø €MÙ	� T°Ô	6€BÙ�W™j¨Ó4¸tÔD€GÙ�F UÔ+€FÙ�F‹^€FÙ�w“€IÙ�D‹\€FÙ™¨$Ô/ÀÇÂÃ
ÔK€JÙ˜¨g¨YÔ7„Dr    rN  c                   ó`  € ] tR tRtRt]! ]RRR7      t]! ]]! R4      RRR7      t	]! ]
RR7      t]! ]
R	RR
7      t]! ]
4      t]! ]
4      t]! ]]! R4      RR7      t]! ]]! R4      RR7      t]! ]4      t]! ]^ R7      t]! ]4      t]! ]! RR7      RR7      t]! ]! RR7      ]P0                  ! 4       R7      t]! ]! RR7      ]P0                  ! 4       R7      t]! ]
RRRR7      t]! ]R^ R7      t]! ]
4      t]! ]4      t]! ]! RR7      RR7      t]! ]! RR7      RR7      t ]!! R]	.R7      t"Rt#R# )ÚProvisioningJobi[  Úprovisioning_jobsTr+   r  Frì   r1   Úqueuedr!  rt   ru   r6   rr   r}   r   r.   r2   rm   r9   r   N)$r   r   r   r   r<   r   r   r=   r   r  r   Útargetr�   r5  Úadapter_keyr˜   r™   r   Úpayload_summaryÚattemptsÚ
last_errorr	   Úexecuted_atr   rÃ   rÄ   rÅ   Úsubmission_keyÚprogress_percentÚcurrent_activityÚresult_messageÚ
started_atÚfinished_atr   r  r   r   r    r!   rW  rW  [  s@  † Ø'€MÙ	� T°Ô	6€BÙ˜¡*¨^Ó"<ÀuÐTXÔY€KÙ�F UÔ+€FÙ�F H°DÔ9€FÙ�F‹^€FÙ˜“.€KÙ˜7¡JÐ/?Ó$@È4ÔP€MÙ ©Ð4IÓ)JÐUYÔZÐÙ˜T“l€OÙ�g qÔ)€HÙ˜“€JÙ™¨4Ô0¸4Ô@€KÙ™¨$Ô/ÀÇÂÃ
ÔK€JÙ™¨$Ô/¸$¿(º(»*ÔE€JÙ˜F¨4¸$ÀdÔK€NÙ˜g°¸qÔAÐÙ˜f“~ÐÙ˜D“\€NÙ™¨$Ô/¸$Ô?€JÙ™¨4Ô0¸4Ô@€KÙ˜J°k°]ÔC„Hr    rW  c                   ó¢  € ] tR tRtRtRt]! ]RRR7      t]! ]]	! R4      RRR7      t
]! ]RR	7      t]! ]RRR7      t]! ]4      t]! ]]	! R
4      RR	7      t]! ]]	! R4      RR	7      t]! ]4      t]! ]4      t]! ]4      t]! ]]	! R4      RRR7      t]! ]4      t]! ]4      t]! ]! RR7      ]P4                  ! 4       RR7      t]! R]
.R7      tRtR# )ÚProvisioningEventis  zPImmutable, sanitized audit trail for preview, queue, and device acknowledgement.Úprovisioning_eventsTr+   r  Frì   r1   rt   ru   zprovisioning_jobs.idrr   )r~   r0   rm   r9   r   N)r   r   r   r   r;   r<   r   r   r=   r   r  r   rZ  r�   r5  r˜   r™   r[  r   r\  ÚmessageÚjob_idÚactivity_namera  r	   r   rÃ   r_  r   r  r   r   r    r!   rg  rg  s  sè   † ÙZØ)€MÙ	� T°Ô	6€BÙ˜¡*¨^Ó"<ÀuÐTXÔY€KÙ�F UÔ+€FÙ�F U°$Ô7€FÙ�F‹^€FÙ˜7¡JÐ/?Ó$@È4ÔP€MÙ ©Ð4IÓ)JÐUYÔZÐÙ˜“.€KÙ˜T“l€OÙ�T‹l€GÙ�G™ZÐ(>Ó?È$ÐVZÔ[€FÙ˜6“N€MÙ˜g“ÐÙ™¨4Ô0ÀÇÂÃÐV[Ô\€KÙ˜J°k°]ÔC„Hr    rg  c                   ó&   € ] tR tRtRtRtRtRtRtR# )ÚEntityStatusi‰  rï   ÚsoldÚusedÚexpiredr   N)	r   r   r   r   rï   rn  ro  rp  r   r   r    r!   rm  rm  ‰  s   † Ø€IØ€DØ€DØ„Gr    rm  c                   óÞ   € ] tR tRtRt]! ]RRR7      t]! ]RRR7      t	]! ]RR7      t
]! ]4      t]! ]4      t]! ]RR	7      t]! ]RR	7      t]! ]]P&                  R	7      t]! R
RR7      tRtR# )ÚSitei�  ÚsitesTr+   Fr<  r1   zAsia/Jakartar6   r„   zMikrotikDevice.site_idr9   r   N)r   r   r   r   r<   r   r   r=   r   r>   r?   rÜ   r   r7  rs   r   rJ   r	   r   rÃ   rÄ   r   Údevicesr   r   r    r!   rr  rr  �  sw   † Ø€MÙ	� T°Ô	6€BÙ�& °Ô6€DÙ�& 5Ô)€DÙ�&‹>€DÙ�d‹|€HÙ�f nÔ5€HÙ�w¨Ô-€IÙ˜¨(¯,©,Ô7€JáÐ+Ð:RÔS„Gr    rr  c                   óX  € ] tR tRtRt]! ]RRR7      t]! ]RRR7      t	]! ]RR7      t
]! ]]! R4      RR7      t]! ]RR7      t]! ]^ R	7      t]! ]RR7      t]! ]RR7      t]! ]RR7      t]! ]RR7      t]! ]RR7      t]! ]RR7      t]! ]RR7      t]! ]RR7      t]! ]R
R	7      t]! ]]! R4      RR7      t]! ]]! R4      RR7      t]! ]]! R4      RR7      t]! ]]! R4      RR7      t]! ]4      t]! ]RR	7      t]! ]] PB                  R	7      t"]#! RRRR7      t$]#! R].R7      t%Rt&R# )rò   iœ  Úvoucher_batchesTr+   Fr<  r1   rî   r6   Ú	generatedrÚ   rØ   ru   r�   r†   rê   zVoucher.batch_idr  ró   rõ   r9   r   N)'r   r   r   r   r<   r   r   r=   r   Ú
batch_coderú   r   rû   ÚquantityÚgenerated_countrB   Úduration_daysÚduration_secondsrý   rþ   Ú	user_modeÚcharacter_lengthrù   r�   rü   rÞ   r  r  r   rè   r  r	   r   rÃ   rÄ   r   rë   r  r   r   r    r!   rò   rò   œ  s]  † Ø%€MÙ	� T°Ô	6€BÙ˜ t°eÔ<€JÙ�V eÔ,€GÙ˜¡Ð,AÓ!BÈTÔR€JÙ�g¨Ô.€HÙ˜W¨aÔ0€OÙ�7 UÔ+€EÙ˜7¨TÔ2€Mñ ˜g°Ô5ÐÙ˜&¨4Ô0€LÙ˜V¨dÔ3€OÙ�v¨Ô-€IÙ˜g°Ô5ÐÙ˜F¨TÔ2€NÙ�F KÔ0€FÙ�g™zÐ*=Ó>ÈÔN€HÙ�W™j¨Ó4¸tÔD€GÙ�w¡
Ð+@Ó AÈDÔQ€IÙ˜¡¨JÓ!7À$ÔG€JÙ�T‹l€GÙ˜¨Ô3€KÙ˜¨(¯,©,Ô7€JÙ˜IÐ4FÐW^Ô_€HÙ"Ð#3À:À,ÔO„Or    rò   c                   ó~  € ] tR tRtRt]! ]RRR7      t]! ]RR7      t	]! ]RR7      t
]! ]RR7      t]! ]RR7      t]! ]RR7      t]! ]RR7      t]! ]^R7      t]! ]^ R7      t]! ]^R7      t]! ]RR7      t]! ]RR7      t]! ]]! R	4      RR7      t]! ]R
R7      t]! ]]P4                  R7      t]! ]RR7      tRtR# )rõ   i¹  Úhotspot_profilesTr+   Fr1   Ú12hr6   rØ   r†   r   N)r   r   r   r   r<   r   r   r=   r   r?   Úlocal_profileÚ	rate_downÚrate_upÚsession_timeoutÚidle_timeoutÚsharedrB   Úvoucher_expiry_daysÚvoucher_expiry_secondsr   rJ   r   rÞ   r  r	   r   rÃ   rÄ   rÅ   r   r   r    r!   rõ   rõ   ¹  sÖ   † Ø&€MÙ	� T°Ô	6€BÙ�& 5Ô)€DÙ˜6¨DÔ1€MÙ�w¨Ô.€IÙ�W tÔ,€GÙ˜V¨UÔ3€OÙ˜&¨4Ô0€LÙ�G QÔ'€FÙ�7 AÔ&€Eá  °"Ô5ÐÙ# G°dÔ;ÐÙ�w¨Ô-€IÙ�W™j¨Ó4¸tÔD€GÙ˜¨Ô3€KÙ˜¨(¯,©,Ô7€JÙ˜¨4Ô0„Jr    rõ   c                   óD  € ] tR tRtRt]! ]RRR7      t]! ]4      t]! ]	4      t
]! ]	4      t]! ]	4      t]! ]4      t]! ]	4      t]! ]4      t]! ]4      t]! ]^ R7      t]! ]]P(                  R7      t]! ]	4      t]! ]4      t]! ]4      t]! ]]P(                  R7      tRtR# )ÚVoucherArchiveiÍ  Úvoucher_archivesTr+   r6   r   N)r   r   r   r   r<   r   r   r=   r  r   r>   r`   rú   rB   r�   r	   rÿ   r   r  r   rÃ   Ú
deleted_atÚreasonr  rü   rÄ   r   r   r    r!   r‹  r‹  Í  s¦   † Ø&€MÙ	� T°Ô	6€BÙ˜“€JÙ�&‹>€DÙ�f‹~€HÙ�V‹n€GÙ�7‹O€EÙ�F‹^€FÙ�XÓ€GÙ�XÓ€Gá˜'¨1Ô-€LÙ˜¨(¯,©,Ô7€JÙ�F‹^€FÙ�g‹€HÙ�g‹€HÙ˜¨(¯,©,Ô7„Jr    r‹  c                   ó@  € ] tR tRtRt]! ]RRR7      t]! ]]! R4      RR7      t	]! ]]! R4      RR7      t
]! ]]! R	4      RR7      t]! ]RR7      t]! ]RR7      t]! ]RR7      t]! ]]! R
4      RR7      t]! ]4      t]! ]RR7      t]! ]]P*                  R7      tRtR# )ÚAgentCommissionià  Úagent_commissionsTr+   rÚ   Fr1   r  rñ   zpayments.idr†   r6   r   N)r   r   r   r   r<   r   r   r=   r   rü   r  r  r  ÚrateÚvoucher_priceÚtransaction_idr   r  r�   r	   r   rÃ   rÄ   r   r   r    r!   r�  r�  à  s¬   † Ø'€MÙ	� T°Ô	6€BÙ�g™zÐ*=Ó>ÈÔO€HÙ˜¡¨MÓ!:ÀTÔJ€JÙ�g™zÐ*>Ó?È$ÔO€HÙ�G eÔ,€FÙ�' EÔ*€DÙ˜7¨UÔ3€MÙ˜G¡Z°Ó%>ÈÔN€NÙ�F‹^€FÙ�F IÔ.€FÙ˜¨(¯,©,Ô7„Jr    r�  c                   óP  € ] tR tRtRt]! ]RRR7      t]! ]]! R4      RR7      t	]! ]]! R4      RR7      t
]! ]RR7      t]! ]R	R
7      t]! ]4      t]! ]RR7      t]! ]4      t]! ]RR7      t]! ]]! R4      RR7      t]! ]]! R4      RR7      t]! ]]P,                  R
7      tRtR# )ÚWalletTransactioniî  Úwallet_transactionsTr+   r�   r1   r  FÚwalletr6   ru   rØ   r   N)r   r   r   r   r<   r   r   r=   r   rP  r  r  r   r  Úwallet_typer�   r  r	   r   r  rÞ   r   rÃ   rÄ   r   r   r    r!   r–  r–  î  s´   † Ø)€MÙ	� T°Ô	6€BÙ�W™j¨Ó4¸tÔD€GÙ˜¡¨MÓ!:ÀTÔJ€JÙ�G eÔ,€FÙ�F HÔ-€FÙ˜“.€KÙ�F UÔ+€FÙ�v“€IÙ�X¨Ô-€GÙ�w¡
Ð+@Ó AÈDÔQ€IÙ�W™j¨Ó4¸tÔD€GÙ˜¨(¯,©,Ô7„Jr    r–  c                   óò   € ] tR tRtRt]! ]RRR7      t]! ]RR7      t	]! ]RR7      t
]! ]RR7      t]! ]RR7      t]! ]RR7      t]! ]RR7      t]! ]]! R	4      RR7      t]! ]]P(                  R7      tR
tR# )ÚRadiusServeriý  Úradius_serversTr+   Fr1   i  r6   rØ   r   N)r   r   r   r   r<   r   r   r=   r   r?   ri   ÚportÚsecretr   Ú
is_primaryrJ   r   rÞ   r	   r   rÃ   rÄ   r   r   r    r!   r›  r›  ý  s€   † Ø$€MÙ	� T°Ô	6€BÙ�& 5Ô)€DÙ�& 5Ô)€DÙ�' 4Ô(€DÙ�F UÔ+€FÙ˜¨Ô/€JÙ�w¨Ô-€IÙ�W™j¨Ó4¸tÔD€GÙ˜¨(¯,©,Ô7„Jr    r›  c                   ó   € ] tR tRtRt]! ]RRR7      t]! ]RR7      t	]! ]RR7      t
]! ]]! R4      RR7      t]! ]]! R4      RR7      t]! ]R	R
7      t]! ]^ R
7      t]! ]4      t]! ]4      t]! ]]P*                  R
7      t]! ]RR7      tRtR# )Ú	SyncQueuei	  Ú
sync_queueTr+   Fr1   rØ   ru   r†   r6   r   N)r   r   r   r   r<   r   r   r=   r   Úentity_typerS  r   Útarget_site_idÚtarget_device_idr�   r]  r   r^  Úpayloadr	   r   rÃ   rÄ   Ú	synced_atr   r   r    r!   r¡  r¡  	  sœ   † Ø €MÙ	� T°Ô	6€BÙ˜¨%Ô0€KÙ�w¨Ô/€IÙ˜G¡Z°
Ó%;ÀdÔK€NÙ˜g¡zÐ2GÓ'HÐSWÔXÐÙ�F IÔ.€FÙ�g qÔ)€HÙ˜“€JÙ�T‹l€GÙ˜¨(¯,©,Ô7€JÙ�x¨$Ô/„Ir    r¡  c                   óü   € ] tR tRtRt]! ]RRR7      t]! ]]! R4      RR7      t	]! ]]! R4      RR7      t
]! ]RR7      t]! ]RR7      t]! ]RR7      t]! ]4      t]! ]R	R
7      t]! ]]P(                  R
7      tRtR# )Ú
OfflineLogi  Úoffline_logsTr+   ru   r1   rØ   Fr†   r6   r   N)r   r   r   r   r<   r   r   r=   r   r  rÞ   r   r£  rS  rQ  r   r¦  r�   r	   r   rÃ   rÄ   r   r   r    r!   r©  r©    s…   † Ø"€MÙ	� T°Ô	6€BÙ�w¡
Ð+@Ó AÈDÔQ€IÙ�W™j¨Ó4¸tÔD€GÙ˜¨%Ô0€KÙ�w¨Ô/€IÙ�F UÔ+€FÙ�T‹l€GÙ�F IÔ.€FÙ˜¨(¯,©,Ô7„Jr    r©  c                   óZ  € ] tR tRtRtRt]! ]RRR7      t]! ]	RRRR7      t
]! ]	RR7      t]! ]	RR7      t]! ]	RR7      t]! ]	RR7      t]! ]]! R	4      RR7      t]! ]	RR7      t]! ]^RR
7      t]! ]RR7      t]! ]	RRRR7      t]! ]RR7      t]! ]	RR7      t]! ]	RR7      t]! ]	RR7      t]! ]! RR7      RR7      t]! ]! RR7      RR7      t]! ]! RR7      RR7      t]! ]RR7      t]! ]	RR7      t]! ]] PB                  RR
7      t"]! ]] PB                  ] PB                  R7      t#Rt$R# )ÚOnlineOrderi$  u²  
Pesanan voucher dari katalog publik. Berbeda dari Invoice, tabel ini
tidak terkait pelanggan existing: pembeli boleh orang luar sistem.

Lifecycle status:
    pending  â†’ order dibuat, voucher belum direservasi (checkout masih jalan)
    reserved â†’ voucher sudah dipegang order ini, menunggu pembayaran
    paid     â†’ Midtrans mengonfirmasi pembayaran
    deliveredâ†’ voucher sudah diserahkan ke pembeli
    expired  â†’ batas bayar habis, voucher dilepas kembali ke stok
    cancelledâ†’ dibatalkan manual oleh admin

Aturan penting: hanya `reserved` yang memegang voucher. Menjalankan
expired harus mengembalikan voucher ke status 'available' supaya stok
tidak berkurang permanen.
Úonline_ordersTr+   Fr.   r1   rî   rð   r†   )r3   r0   r-   rr   )r3   r€   r   N)%r   r   r   r   r;   r<   r   r   r=   r   Ú
order_codeÚcustomer_nameÚcustomer_phoneÚcustomer_emailÚprofile_namer   rû   Úduration_labelry  Útotal_pricer�   r   Úreserved_voucher_idsÚmidtrans_order_idÚ
snap_tokenÚpayment_methodr	   r  Údelivered_atr  Ú
admin_noteÚ	client_ipr   rÃ   rÄ   rÅ   r   r   r    r!   r¬  r¬  $  sM  † ñð  $€MÙ	� T°Ô	6€BÙ˜ t°eÀ4ÔH€JÙ˜6¨EÔ2€MÙ˜F¨UÔ3€NÙ˜F¨TÔ2€Nñ ˜&¨4Ô0€LÙ˜¡Ð,AÓ!BÈTÔR€JÙ˜F¨TÔ2€NÙ�g q°5Ô9€HÙ˜¨5Ô1€KÙ�F I¸ÀTÔJ€Fá! $°Ô6ÐÙ˜v°Ô5ÐÙ˜¨Ô.€JÙ˜F¨TÔ2€Ná‘X tÔ,°tÔ<€GÙ™(¨DÔ1¸DÔA€LÙ™¨$Ô/¸$Ô?€JÙ˜ tÔ,€JÙ�v¨Ô-€IÙ˜¨(¯,©,ÀÔG€JÙ˜¨(¯,©,ÀÇÁÔN„Jr    r¬  c                   ó¤   € ] tR tRtRtRt]! ]RRR7      t]! ]	RR7      t
]! ]	RR7      t]! ]4      t]! ]	4      t]! ]]P"                  R	7      tR
tR# )ÚPaymentAuditiQ  z3Log untuk semua webhook pembayaran (Midtrans, etc).Úpayment_auditsTr+   Fr1   ro   r6   r   N)r   r   r   r   r;   r<   r   r   r=   r   Úproviderr®  r   Úraw_payloadr�   r	   r   rÃ   rÄ   r   r   r    r!   r½  r½  Q  sR   † Ù=Ø$€MÙ	� T°Ô	6€BÙ�f uÔ-€HÙ˜ dÔ+€JÙ˜“,€KÙ�F‹^€FÙ˜¨(¯,©,Ô7„Jr    r½  c                   ó   € ] tR tRtRtRt]! ]RRR7      t]! ]]	! R4      RR7      t
]! ]]	! R4      RR7      t]! ]R	R7      t]! ]4      t]! ]4      t]! ]]P&                  R
7      t]! R]
.R7      t]! R].R7      tRtR# )ÚAdminActionLogi[  z*Log aksi manual admin (Lunas, Batal, etc).Úadmin_action_logsTr+   r�   r1   zonline_orders.idFr6   r^   r9   r¬  r   N)r   r   r   r   r;   r<   r   r   r=   r   rP  Úorder_idr   rQ  r   rT  Ú
ip_addressr	   r   rÃ   rÄ   r   rU  Úorderr   r   r    r!   rÂ  rÂ  [  s‰   † Ù4Ø'€MÙ	� T°Ô	6€BÙ�W™j¨Ó4¸tÔD€GÙ�g™zÐ*<Ó=ÈÔM€HÙ�F UÔ+€FÙ�D‹\€FÙ˜“€JÙ˜¨(¯,©,Ô7€JÙ˜¨g¨YÔ7€DÙ˜°h°ZÔ@„Er    rÂ  c                   óì   € ] tR tRtRt]! ]RRR7      t]! ]! ^@4      RRRR7      t	]! ]! ^€4      RR7      t
]! ]]! R4      RRR	7      t]! ]R]P                  R
7      t]! ]RRR	7      t]! ]RR7      tRtR# )ÚSuperAgentSessionih  Úsuper_agent_sessionsTr+   F)r0   r/   r-   r1   rÚ   rì   r2   r   N)r   r   r   r   r<   r   r   r=   r   Ú
token_hashÚ
csrf_tokenr   rü   r	   r   rÃ   rÄ   r  Ú
revoked_atr   r   r    r!   rÈ  rÈ  h  s|   † Ø*€MÙ	� T°Ô	6€BÙ™˜r›
¨U¸4ÀtÔL€JÙ™˜s›¨eÔ4€JÙ�g™zÐ*=Ó>ÈÐVZÔ[€HÙ˜¨5¸(¿,¹,ÔG€JÙ˜¨5¸Ô=€JÙ˜¨4Ô0„Jr    rÈ  c                   óŽ   € ] tR tRtRt]! ]! ^4      RR7      t]! ]R^ R7      t	]! ]
R]P                  R7      t]! ]
RR7      tRtR	# )
ÚSuperAgentLoginAttemptis  Úsuper_agent_login_attemptsTrg   Fr2   r1   r   N)r   r   r   r   r<   r   r   râ   r   Úfailure_countr	   r   rÃ   Úwindow_started_atÚlocked_untilr   r   r    r!   rÎ  rÎ  s  sD   † Ø0€MÙ™ ›°Ô6€KÙ˜7¨U¸AÔ>€MÙ˜x°%ÀÇÁÔNÐÙ˜(¨TÔ2„Lr    rÎ  c                   óü   € ] tR tRtRtRt]! ]RRR7      t]! ]	RR7      t
]! ]	RR7      t]! ]R^ R7      t]! ]	RRR	7      t]! ]]! R
4      RR7      t]! ]RR7      t]! ]]P(                  R7      t]! R].R7      tRtR# )ÚOperationalExpensei{  zIPencatatan biaya operasional (OpEx) / pengeluaran ISP per site / periode.Úoperational_expensesTr+   Fr1   r2   rì   rØ   r6   rr  r9   r   N)r   r   r   r   r;   r<   r   r   r=   r   ÚtitleÚcategoryr  r  r   rÞ   r   Údescriptionr	   r   rÃ   rÄ   r   Úsiter   r   r    r!   rÔ  rÔ  {  s‰   † ÙSØ*€MÙ	� T°Ô	6€BÙ�6 EÔ*€EÙ�f uÔ-€HÙ�G e°QÔ7€FÙ�F U°$Ô7€FÙ�W™j¨Ó4¸tÔD€GÙ˜¨Ô-€KÙ˜¨(¯,©,Ô7€JÙ˜¨g¨YÔ7„Dr    rÔ  )8r   Ú
sqlalchemyr   r   r   r   r   r	   r
   r   r   Úsqlalchemy.ormr   Úsqlalchemy.sqlr   ÚenumÚapp.core.databaser   Ústrr   r#   r)   rM   rY   r^   re   rm   rÖ   rê   r  r  r$  r„   rƒ   r‚   r8   rE  rN  rW  rg  rm  rr  rò   rõ   r‹  r�  r–  r›  r¡  r©  r¬  r½  rÂ  rÈ  rÎ  rÔ  r   r    r!   Ú<module>rà     s  ðÝ ß k× kÕ kÝ 'Ý Û Ý "ô"ˆs�D—I‘Iô "ô(�3˜Ÿ	™	ô (ôX�Tô Xô&�S˜$Ÿ)™)ô ô$�#�t—y‘yô $ô.ˆ4ô .ô-�Tô -ôbVˆtô bVôH1�4ô 1ô4%Pˆdô %PôNDˆdô Dô 	Dˆdô 	Dô
.�tô 
.ôP�Tô Pô P�ô Pô"
.ˆ$ô 
.ô	>�Tô 	>ôj�dô jô	8ˆtô 	8ôD�dô Dô0D˜ô Dó( ô�3˜Ÿ	™	ô ôTˆ4ô TôP�4ô Pô:1�Tô 1ô(8�Tô 8ô&8�dô 8ô8˜ô 8ô
8�4ô 
8ô0�ô 0ô
8�ô 
8ô+O�$ô +OôZ8�4ô 8ôA�Tô Aô1˜ô 1ô3˜Tô 3ô8˜ö 8r    