<!-- 未提交纸质病历 -->
```{r}
#| results: asis
day_of_week <- weekdays(Sys.Date(), abbreviate = TRUE)
if (day_of_week %in% c("Fri", "Mon", "Tue")) {
cat("## 未提交纸质病历\n")
}
```
```{r}
if (day_of_week %in% c("Fri", "Mon", "Tue")) {
submission_data <- readxl::read_xlsx('data/临床质控.xls') |>
filter(审核日期 == "未审核") |>
select("病案号", "患者姓名", "出院日期", "主管医生" ) |>
arrange(主管医生, desc(出院日期))
submission_data
}
```
<!-- 按月份汇总未提交纸质病历 -->
```{r}
#| results: asis
if (day_of_week %in% c("Fri", "Mon", "Tue")) {
cat("### 按月份汇总未提交纸质病历\n")
}
```
```{r}
if (day_of_week %in% c("Fri", "Mon", "Tue")) {
monthly_data <- submission_data |>
mutate(年份=year(出院日期),
月份=month(出院日期)) |>
group_by(年份, 月份) |>
summarise(汇总 = n())
monthly_data
}
```
<!-- 按主管医生汇总未提交纸质病历 -->
```{r}
#| results: asis
if (day_of_week %in% c("Fri", "Mon", "Tue")) {
cat("### 按主管医生汇总未提交纸质病历\n")
}
```
```{r}
if (day_of_week %in% c("Fri", "Mon", "Tue")) {
submission_data |>
group_by(主管医生) |>
summarise(汇总 = n()) |>
arrange(desc(汇总))
}
```
```{r}
#| results: asis
day_of_week <- weekdays(Sys.Date(), abbreviate = TRUE)
if (day_of_week %in% c("Fri", "Mon", "Tue")) {
cat("## 未提交纸质病历\n")
submission_data <- readxl::read_xlsx('data/临床质控.xls') |>
filter(审核日期 == "未审核") |>
select("病案号", "患者姓名", "出院日期", "主管医生" ) |>
arrange(主管医生, desc(出院日期))
submission_data
cat("### 按月份汇总未提交纸质病历\n")
monthly_data <- submission_data |>
mutate(年份=year(出院日期),
月份=month(出院日期)) |>
group_by(年份, 月份) |>
summarise(汇总 = n())
monthly_data
cat("### 按主管医生汇总未提交纸质病历\n")
submission_data |>
group_by(主管医生) |>
summarise(汇总 = n()) |>
arrange(desc(汇总))
}
```