如何在Shiny应用的日历控件中隐藏早于date1的月份选项
解决方案
你只需要调整server部分中output$date的渲染逻辑,过滤掉早于date1的日期即可,修改后的完整可运行代码如下:
library(shiny) library(shinythemes) library(dplyr) library(tidyverse) library(lubridate) library(stringr) function.test<-function(){ df1 <- structure( list(date1= c("2021-06-28","2021-06-28","2021-06-28","2021-06-28","2021-06-28","2021-06-28"), date2 = c("2021-04-30","2021-05-17","2021-06-30","2021-06-30","2021-07-01","2021-07-01"), Category = c("FDE","ABC","FDE","ABC","FDE","ABC"), Week= c("Friday","Monday","Wednesday","Wednesday","Friday","Friday"), DR1 = c(4,1,6,3,1,3), DR01 = c(4,1,4,3,1,3), DR02= c(4,2,6,2,2,4),DR03= c(9,5,4,7,5,2), DR04 = c(5,4,3,2,3,4),DR05 = c(5,4,5,4,2,4), DR06 = c(2,4,3,2,2,4),DR07 = c(2,5,4,4,4,2), DR08 = c(3,4,5,4,2,4),DR09 = c(2,3,4,4,4,2)), class = "data.frame", row.names = c(NA, -6L)) return(df1) } f1 <- function(df1, dmda, CategoryChosse) { x<-df1 %>% select(starts_with("DR0")) x<-cbind(df1, setNames(df1$DR1 - x, paste0(names(x), "_PV"))) PV<-select(x, date2,Week, Category, DR1, ends_with("_PV")) med<-PV %>% group_by(Category,Week) %>% summarize(across(ends_with("_PV"), median)) SPV<-df1%>% inner_join(med, by = c('Category', 'Week')) %>% mutate(across(matches("^DR0\\d+$"), ~.x + get(paste0(cur_column(), '_PV')), .names = '{col}_{col}_PV')) %>% select(date1:Category, DR01_DR01_PV:last_col()) SPV<-data.frame(SPV) mat1 <- df1 %>% filter(date2 == dmda, Category == CategoryChosse) %>% select(starts_with("DR0")) %>% pivot_longer(cols = everything()) %>% arrange(desc(row_number())) %>% mutate(cs = cumsum(value)) %>% filter(cs == 0) %>% pull(name) (dropnames <- paste0(mat1,"_",mat1, "_PV")) SPV <- SPV %>% filter(date2 == dmda, Category == CategoryChosse) %>% select(-any_of(dropnames)) datas<-SPV %>% filter(date2 == ymd(dmda)) %>% group_by(Category) %>% summarize(across(starts_with("DR0"), sum)) %>% pivot_longer(cols= -Category, names_pattern = "DR0(.+)", values_to = "val") %>% mutate(name = readr::parse_number(name)) colnames(datas)[-1]<-c("Days","Numbers") if(as.Date(dmda) < min(as.Date(df1$date1))){ datas <- datas %>% group_by(Category) %>% slice(1:max(Days)+1) %>% ungroup }else{ datas <- datas %>% group_by(Category) %>% slice((as.Date(dmda) - min(as.Date(df1$date1) [ df1$Category == first(Category)])):max(Days)+1) %>% ungroup } plot(Numbers ~ Days, xlim= c(0,45), ylim= c(0,30), xaxs='i',data = datas,main = paste0(dmda, "-", CategoryChosse)) model <- nls(Numbers ~ b1*Days^2+b2,start = list(b1 = 0,b2 = 0),data = datas, algorithm = "port") new.data <- data.frame(Days = with(datas, seq(min(Days),max(Days),len = 45))) new.data <- rbind(0, new.data) lines(new.data$Days,predict(model,newdata = new.data),lwd=2) coef<-coef(model)[2] points(0, coef, col="red",pch=19,cex = 2,xpd=TRUE) text(.99,coef + 1,max(0, round(coef,1)), cex=1.1,pos=4,offset =1,col="black") } ui <- fluidPage( ui <- shiny::navbarPage(theme = shinytheme("flatly"), collapsible = TRUE, br(), tabPanel("", sidebarLayout( sidebarPanel( uiOutput("date"), uiOutput("mycode"), br(), ), mainPanel( tabsetPanel( tabPanel("", plotOutput("graph",width = "100%", height = "600") ) ), )) ))) server <- function(input, output,session) { data <- reactive(function.test()) output$date <- renderUI({ req(data()) # 提取基准过滤日期date1 base_date <- as.Date(unique(data()$date1)) # 过滤出所有晚于date1的有效date2 valid_dates <- as.Date(unique(data()$date2)) %>% .[. > base_date] all_dates <- seq(min(valid_dates), max(valid_dates), by = "day") # 禁用不在有效列表的日期 disabled <- as.Date(setdiff(all_dates, valid_dates), origin = "1970-01-01") dateInput(input = "date2", label = h4("Data"), min = min(valid_dates), max = max(valid_dates), value = min(valid_dates), format = "dd-mm-yyyy", datesdisabled = disabled) }) output$mycode <- renderUI({ req(input$date2) df1 <- data() df2 <- df1[as.Date(df1$date2) %in% input$date2,] selectInput("code", label = h4("Code"),choices=unique(df2$Category)) }) output$graph <- renderPlot({ req(input$date2,input$code) f1(data(),as.character(input$date2),as.character(input$code)) }) } shinyApp(ui = ui, server = server)
核心修改说明
- 新增基准日期提取逻辑,统一取
date1字段的唯一值作为过滤阈值 - 过滤出所有晚于基准日期的
date2作为有效可选日期 - 将日历控件的可选范围(min、max参数)限制在有效日期范围内,从根源上屏蔽了4月、5月的可选选项
- 禁用了有效日期范围之外的所有日期,避免误选不符合要求的日期
内容的提问来源于stack exchange,提问作者user16774617
相关产品推荐
相关产品推荐

