import streamlit as st
import pandas as pd

df = pd.read_csv('last_results.csv')

image1 = 'images/rs_pmpa.png'

title_html = """
    <style>
        @font-face {
            font-family: 'Quicksand';
            src: url('font/Quicksand-VariableFont_wght.ttf') format('truetype');
        }
        body {
            font-family: 'Quicksand', sans-serif;
        }
        .custom-title {
            color: darkgreen;
            font-size: 30px;
            font-weight: bold;
        }
    </style>
    <span class='custom-title'>PREVISÕES DE RECEITAS</span>
"""

# Set a fixed width for the sidebar
st.markdown(
    """
    <style>
        .sidebar .sidebar-content {
            width: 300px;
        }
    </style>
    """,
    unsafe_allow_html=True
)

with st.sidebar:
    st.image(image1, caption='Image 1', use_column_width=True)
    st.markdown(title_html, unsafe_allow_html=True)
    selected_instituicao = st.selectbox('Select Instituição', df['Instituição'].unique())
    selected_conta = st.selectbox('Select Conta', df['Conta'].unique())

# Filter the DataFrame based on selected values
filtered_df = df[(df['Instituição'] == selected_instituicao) & (df['Conta'] == selected_conta)]

# Display the filtered DataFrame
st.write('Filtered DataFrame:')
st.write(filtered_df)

# Display the Forecasts values
if not filtered_df.empty:
    forecasts_values = filtered_df['Forecasts'].values
    st.write('Forecasts Values:', forecasts_values)
else:
    st.warning('No data available for the selected filters.')