def __init__(self):
self.data_access = file_access()
def inicializar_filtro(self):
id = self.get_num_filtros()
data_access = file_access()
data_produccion = data_access.get_df_produccion()
list_variedades = data_produccion['variedad'].unique()
list_fincas = data_produccion['finca'].unique()
list_colors = data_produccion['Color'].unique()
list_colors = list_colors
list_colors_without_nan=np.delete(list_colors,22)
data_estaciones = data_access.get_df_estacion()
list_dates = np.sort(data_produccion['anosemana'].unique())
list_dates_converted = pd.to_datetime(list_dates)
initial_value = list_dates_converted[0]
last_value = list_dates_converted[len(list_dates_converted)-1]
temperatura = data_access.get_df_temperatura()
estaciones = temperatura.columns[2:-2]
estacion = data_access.get_filtros_clima()['estacion']
type_flowers = ["All ", "Claveles", "Miniclaveles"]
filtro = dbc.Card(
[
dbc.FormGroup(
[
html.P("Date",className="control_label"),
dcc.DatePickerRange(
id="date_filter"+str(id),
start_date_placeholder_text="Start Date",
end_date_placeholder_text="End Date",
#clearable=True,
#with_portal=True,
calendar_orientation='vertical',)
]
),
dbc.FormGroup(
[
html.P("Farms:", className="control_label"),
#dbc.RadioItems(id="radio-fincas"+str(id),options=[{"label": "All", "value": 1},],),
dcc.Dropdown(id="categoria"+str(id),options=[{"label": col, "value": col} for col in list_fincas],multi=True,value=list_fincas,className="dcc_control",),
]
),
dbc.FormGroup(
[
html.P("Colors:", className="control_label"),
#dbc.RadioItems(id="radio-color"+str(id),options=[{"label": "All", "value": 1},],),
dcc.Dropdown(id="categoria-color"+str(id),options=[{"label": col, "value": col} for col in list_colors_without_nan],multi=True,value=list_colors_without_nan,className="dcc_control",),
]
),
dbc.FormGroup(
[
dbc.Label(u"Varieties"),
dbc.RadioItems(
id="radio-variedades"+str(id),
options=[
{"label": "All", "value": 1},
{"label": "Carnations", "value": 2},
{"label": "Mini Carnations", "value": 3},
],
),
dcc.Dropdown(
id="nivelCritica"+str(id),
options=[
{"label": col, "value": col} for col in list_variedades
],
multi=True,
value=list_variedades,
className="dcc_control",
),
]
),
dbc.FormGroup(
[
html.P("Weather Stations:", className="control_label"),
dbc.RadioItems(id="radio-estaciones"+str(id),options=[{"label": "Day", "value": 1},{"label": "Month", "value": 2}],),
dcc.Dropdown(id="categoria-estaciones"+str(id),options=[{"label": col, "value": col} for col in estaciones],multi=False,value=estacion,className="dcc_control",),
]
)
],
body=True,
)
self.filtros.append(filtro)