
    i                     \    S SK rS SKJr  S SKrS SKrS SKJr  S SKJ	r	  S r
 " S S\5      rg)    N)Path)HydraHeadApp)interactive_tablec                     [        U 5      R                  5       n[        R                  " U5      R	                  5       nU$ N)r   
read_bytesbase64	b64encodedecode)img_path	img_bytesencodeds      ,/srv/www/htdocs/dashboard-gnss/apps/titik.pyimg_to_bytesr   	   s2    X))+Iy)002GN    c                   0    \ rS rSrSS jrS rS rS rSrg)	TitikApp   c                 F    U R                   R                  U5        Xl        g r   )__dict__updatetitle)selfr   kwargss      r   __init__TitikApp.__init__   s    V$
r   c                 D    U R                  5         U R                  5         g r   )_cs_sidebar_cs_body)r   s    r   runTitikApp.run   s    r   c                    [         R                     [         R                  " SSS9  [         R                  R                  S[        R                  " SS5       S3SS9  [         R
                  " S5      n[         R
                  " S	5      n[         R                  " S
SS9n[         R                  " SSS9n[         R                  " SSS9  [         R                  " S5      nU(       a  U(       a  U(       d  [         R                  " S5        OX:  a  [         R                  " S5        OUR                  S5      nUR                  S5      nUR                  nSUs=::  a  S::  a	  O  OSU 3n	O [         R                  " S5         S S S 5        g SU	 SU SU S3n
U
SUS-
   SUS-    SUS-
   SUS-    S3	-  n
[        R                  " U
5      nU[         R                  S'   S S S 5        g ! , (       d  f       g = f) Na  
                <style>
                    div[data-testid="stVerticalBlock"] div:has(div.select-bar) {
                        position: sticky;
                        top: 0;
                        background-color: white;
                        z-index: 999;
                    }
                    .select-bar {
                        border-bottom: 0 solid black;
                    }
                </style>
                T)unsafe_allow_htmlzO<div style='padding-top: 0px; margin-top: -60px; margin-left: 40px;'><img src='zresources/titik.pnglogoz' alt='Logo' width='200'>zPilih Start DatezPilih End Date	Longitudez%.2f)formatLatitudez<div class='select-bar'></div>Submitz&Silakan pilih start date dan end date.z1Start date tidak boleh lebih besar dari end date.z%Y-%m-%di  i  catalog_z$Data untuk tahun ini tidak tersedia.zSELECT * FROM z WHERE formatted_date BETWEEN 'z' AND ''z AND (CLAT BETWEEN '   z') AND (CLON BETWEEN 'z')data)stsidebarmarkdownutilsreplace_image
date_inputnumber_inputbuttonerrorstrftimeyear	load_datasession_state)r   
start_dateend_datelonlatsubmitstart_date_strend_date_strr7   tablequerydfs               r   r   TitikApp._cs_sidebar   s   ZZKK #'  JJ"001FOPPik"&    '9:J}}%56H//+f=C//*V<CKK8DQ YYx(F!HHEF*HHPQ &0%8%8%DN#+#4#4Z#@L%??D t+t+"*4& 1!GHe Zj -UG3RSaRbbijviwwxyE3CE7'#a%H^_bcd_d^eelmpqrmrlssuvvE /B 02B$$V,y ZZs   E1G'AG''
G5c                     S[         R                  ;   aH  [         R                  S   nUR                  (       a  [         R                  " S5        g [	        U/ SQS9  g [         R
                  " S5        g )Nr,   zTidak ada data yang ditemukan.)	copyHtml5csvHtml5
excelHtml5)buttonszHSilakan isi parameter di sidebar dan klik Submit untuk menampilkan data.)r-   r9   emptyr5   r   info)r   rC   s     r   r   TitikApp._cs_bodyX   sN    R%%%!!&)Bxx9: "".UVGG^_r   )r   N) )	__name__
__module____qualname____firstlineno__r   r    r   r   __static_attributes__ r   r   r   r      s    
=2~
`r   r   )	streamlitr-   pathlibr   r	   r0   hydralitr   itables.streamlitr   r   r   rS   r   r   <module>rX      s,        ! /
T`| T`r   