File size: 2,705 Bytes
2691456
 
 
 
 
 
 
6d3a243
2691456
 
 
 
359a85c
 
 
 
2691456
efd0257
 
 
2691456
6d3a243
2691456
 
 
 
 
6d3a243
 
359a85c
2691456
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
359a85c
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
# --- global.R ---
library(shiny)
library(shinydashboard)
library(tidyverse)
library(lubridate)
library(plotly)
library(DBI)
library(duckdb)
library(scales)
library(DT)
library(shinyWidgets)
library(cluster)
library(openxlsx)       # Tier 1 Excel report
library(strucchange)    # ITS breakpoint detection
library(lmtest)         # ITS coefficient testing
library(pool)           # Connection pooling

# --- LOAD MODULES ---
source("mod_cohort_analysis.R") # <--- THIS IS THE MISSING LINE!

# 1. ESTABLISH DATABASE CONNECTION POOL
db_pool <- dbPool(drv = duckdb::duckdb(), dbdir = ":memory:")

onStop(function() {
  poolClose(db_pool)
})

source("seed_data.R")

# 2. GLOBAL SPC LIMITS FUNCTION (Restored to prevent app crash)
spc_limits <- function(df, metric_col, is_quarterly, by_person = FALSE, bl_start, bl_end) {
  grp_date <- function(d) if (is_quarterly) floor_date(d, "quarter") else floor_date(d, "month")
  
  if (by_person) {
    baseline_stats <- df %>%
      filter(report_date >= bl_start, report_date <= bl_end) %>%
      mutate(date_group = grp_date(report_date)) %>%
      group_by(primary_name, date_group) %>%
      summarise(Val = sum(.data[[metric_col]], na.rm = TRUE), .groups = "drop") %>%
      group_by(primary_name) %>%
      summarise(BL_Mean = mean(Val, na.rm = TRUE),
                BL_SD   = replace_na(sd(Val, na.rm = TRUE), 0),
                .groups = "drop")
    
    trend <- df %>%
      mutate(date_group = grp_date(report_date)) %>%
      group_by(primary_name, date_group) %>%
      summarise(Val = sum(.data[[metric_col]], na.rm = TRUE), .groups = "drop")
    
    trend %>%
      left_join(baseline_stats, by = "primary_name") %>%
      mutate(UCL     = BL_Mean + 3 * BL_SD,
             LCL     = pmax(0, BL_Mean - 3 * BL_SD),
             Anomaly = ifelse(Val > UCL | Val < LCL, "Anomaly", "Normal"))
  } else {
    baseline_stats <- df %>%
      filter(report_date >= bl_start, report_date <= bl_end) %>%
      mutate(date_group = grp_date(report_date)) %>%
      group_by(date_group) %>%
      summarise(Val = sum(.data[[metric_col]], na.rm = TRUE), .groups = "drop") %>%
      summarise(BL_Mean = mean(Val, na.rm = TRUE),
                BL_SD   = replace_na(sd(Val, na.rm = TRUE), 0))
    
    bl_mean <- baseline_stats$BL_Mean
    bl_sd   <- baseline_stats$BL_SD
    
    df %>%
      mutate(date_group = grp_date(report_date)) %>%
      group_by(date_group) %>%
      summarise(Val = sum(.data[[metric_col]], na.rm = TRUE), .groups = "drop") %>%
      mutate(BL_Mean = bl_mean,
             UCL     = bl_mean + 3 * bl_sd,
             LCL     = pmax(0, bl_mean - 3 * bl_sd),
             Anomaly = ifelse(Val > UCL | Val < LCL, "Anomaly", "Normal"))
  }
}