library(shiny)
library(readxl)
library(dlookr)
library(rpivotTable)

ui <- fluidPage(
  titlePanel("EDA no Browser – rpivotTable + dlookr"),

  sidebarLayout(
    sidebarPanel(
      h4("Dataset"),
      p("Arquivo: STATUS1.xlsx"),
      actionButton("diag", "Gerar diagnóstico dlookr")
    ),

    mainPanel(
      tabsetPanel(
        tabPanel("Pivot Table",
                 rpivotTableOutput("pivot")),
        tabPanel("Diagnóstico",
                 uiOutput("diag_ui"))
      )
    )
  )
)

server <- function(input, output, session) {

  STATUS <- reactive({
    read_excel("STATUS1.xlsx")
  })

  output$pivot <- renderRpivotTable({
    rpivotTable(STATUS())
  })

  observeEvent(input$diag, {

    dir.create("www", showWarnings = FALSE)

    diagnose_web_report(
      STATUS(),
      output_dir = "www",
      output_file = "diagnostico.html"
    )

    output$diag_ui <- renderUI({
      tags$iframe(
        src = "diagnostico.html",
        width = "100%",
        height = "800px",
        style = "border:none;"
      )
    })
  })
}

shinyApp(ui, server)