
    f                     \    d dl Zd dlmZ d dlZd dlZd dlmZ d dlm	Z	 d Z
 G d de      Zy)    N)Path)HydraHeadApp)interactive_tablec                 ~    t        |       j                         }t        j                  |      j	                         }|S N)r   
read_bytesbase64	b64encodedecode)img_path	img_bytesencodeds      H/Users/putuwistika/Documents/TRILAK/dashboard-catalog-gnss/apps/titik.pyimg_to_bytesr   	   s2    X))+Iy)002GN    c                   &    e Zd ZddZd Zd Zd Zy)TitikAppc                 H    | j                   j                  |       || _        y r   )__dict__updatetitle)selfr   kwargss      r   __init__zTitikApp.__init__   s    V$
r   c                 D    | j                          | j                          y r   )_cs_sidebar_cs_body)r   s    r   runzTitikApp.run   s    r   c                    t         j                  5  t        j                  dd       t         j                  j                  dt        j                  dd       dd       t        j
                  d      }t        j
                  d	      }t        j                  d
d      }t        j                  dd      }t        j                  dd       t        j                  d      }|r|r|st        j                  d       n||kD  rt        j                  d       n|j                  d      }|j                  d      }|j                  }d|cxk  rdk  r	n nd| }	nt        j                  d       	 d d d        y d|	 d| d| d}
|
d|dz
   d|dz    d|dz
   d|dz    d	z  }
t        j                  |
      }|t         j                  d<   d d d        y # 1 sw Y   y xY w) 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Latitudez%.2f)format	Longitudez<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latlonsubmitstart_date_strend_date_strr4   tablequerydfs               r   r   zTitikApp._cs_sidebar   s   ZZ <	2KK #'  JJ"001FOPPik"&    '9:J}}%56H//*V<C//+f=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<	2 <	2j -UG3RSaRbbijviwwxyE3CE7'#a%H^_bcd_d^eelmpqrmrlssuvvE /B 02B$$V,y<	2 <	2 <	2s   E$G>AGG"c                     dt         j                  v rEt         j                  d   }|j                  rt        j                  d       y t	        |g d       y t        j
                  d       y )Nr)   zTidak ada data yang ditemukan.)	copyHtml5csvHtml5
excelHtml5)buttonszHSilakan isi parameter di sidebar dan klik Submit untuk menampilkan data.)r*   r6   emptyr2   r   info)r   r@   s     r   r   zTitikApp._cs_bodyX   sN    R%%%!!&)Bxx9: "".UVGG^_r   N) )__name__
__module____qualname__r   r   r   r    r   r   r   r      s    
=2~
`r   r   )	streamlitr*   pathlibr   r	   r-   hydralitr   itables.streamlitr   r   r   rL   r   r   <module>rQ      s,        ! /
T`| T`r   