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)