WXL (wul)
6 天以前 fb34ba28cb908bd328cf6690ab0b19a56428f4e2
src/views/sfstatistics/percentage/components/SecondFollowUp.vue
@@ -154,6 +154,7 @@
                  </template>
                </el-table-column>
                <el-table-column
                  v-if="!isTargetHospital"
                  label="待随访"
                  align="center"
                  key="pendingFollowUpAgain"
@@ -177,6 +178,62 @@
                      }}</span>
                    </el-button>
                  </template>
                </el-table-column>
                <el-table-column
                  v-if="isTargetHospital"
                  label="待随访"
                  align="center"
                >
                  <el-table-column
                    label="待发送"
                    align="center"
                    key="pendingFollowUpWaitSendAgain"
                    prop="pendingFollowUpWaitSendAgain"
                  >
                    <template slot-scope="scope">
                      <el-button
                        size="medium"
                        type="text"
                        @click="
                          handleViewDetails(
                            scope.row,
                            'pendingFollowUpWaitSendAgainInfo',
                            '待发送列表',
                            '1'
                          )
                        "
                      >
                        <span class="button-zx">{{
                          scope.row.pendingFollowUpWaitSendAgain
                        }}</span>
                      </el-button>
                    </template>
                  </el-table-column>
                  <el-table-column
                    label="已发送"
                    align="center"
                    key="pendingFollowUpSentAgain"
                    prop="pendingFollowUpSentAgain"
                  >
                    <template slot-scope="scope">
                      <el-button
                        size="medium"
                        type="text"
                        @click="
                          handleViewDetails(
                            scope.row,
                            'pendingFollowUpSentAgainInfo',
                            '已发送列表',
                            '1'
                          )
                        "
                      >
                        <span class="button-zx">{{
                          scope.row.pendingFollowUpSentAgain
                        }}</span>
                      </el-button>
                    </template>
                  </el-table-column>
                </el-table-column>
                <el-table-column
                  label="随访成功"
@@ -204,6 +261,7 @@
                  </template>
                </el-table-column>
                <el-table-column
                  v-if="!isTargetHospital"
                  label="随访失败"
                  align="center"
                  key="followUpFailAgain"
@@ -457,6 +515,7 @@
            </template>
          </el-table-column>
          <el-table-column
            v-if="!isTargetHospital"
            label="待随访"
            align="center"
            key="pendingFollowUpAgain"
@@ -479,6 +538,60 @@
                }}</span>
              </el-button>
            </template>
          </el-table-column>
          <el-table-column
            v-if="isTargetHospital"
            label="待随访"
            align="center"
          >
            <el-table-column
              label="待发送"
              align="center"
              key="pendingFollowUpWaitSendAgain"
              prop="pendingFollowUpWaitSendAgain"
            >
              <template slot-scope="scope">
                <el-button
                  size="medium"
                  type="text"
                  @click="
                    handleViewDetails(
                      scope.row,
                      'pendingFollowUpWaitSendAgainInfo',
                      '再次随访待发送列表'
                    )
                  "
                >
                  <span class="button-zx">{{
                    scope.row.pendingFollowUpWaitSendAgain
                  }}</span>
                </el-button>
              </template>
            </el-table-column>
            <el-table-column
              label="已发送"
              align="center"
              key="pendingFollowUpSentAgain"
              prop="pendingFollowUpSentAgain"
            >
              <template slot-scope="scope">
                <el-button
                  size="medium"
                  type="text"
                  @click="
                    handleViewDetails(
                      scope.row,
                      'pendingFollowUpSentAgainInfo',
                      '再次随访已发送列表'
                    )
                  "
                >
                  <span class="button-zx">{{
                    scope.row.pendingFollowUpSentAgain
                  }}</span>
                </el-button>
              </template>
            </el-table-column>
          </el-table-column>
          <el-table-column
            label="随访成功"
@@ -505,6 +618,7 @@
            </template>
          </el-table-column>
          <el-table-column
            v-if="!isTargetHospital"
            label="随访失败"
            align="center"
            key="followUpFailAgain"
@@ -553,70 +667,43 @@
            prop="followUpRateAgain"
            :render-header="Tooltipsfl"
          />
          <el-table-column
            v-if="isTargetHospital"
            label="人工"
            v-if="orgname == '缙云县人民医院'"
            label="复诊复查数量"
            align="center"
            key="suggest7CountAgain"
            prop="suggest7CountAgain"
          >
            <el-table-column
              label="发送完成"
              align="center"
              key="manualSuccess"
              prop="manualSuccess"
              :render-header="Tooltipfswc"
            >
              <template slot-scope="scope">
                <el-button
                  size="medium"
                  type="text"
                  @click="
                    handleViewDetails(
                      scope.row,
                      'manualSuccessInfo',
                      '发送完成人工随访列表'
                    )
                  "
                >
                  <span class="button-zx">{{ scope.row.manualSuccess }}</span>
                </el-button>
              </template>
            </el-table-column>
            <el-table-column
              label="最终完成"
              align="center"
              key="manualAgainSuccess"
              prop="manualAgainSuccess"
              :render-header="Tooltipzzwc"
            >
              <template slot-scope="scope">
                <el-button
                  size="medium"
                  type="text"
                  @click="
                    handleViewDetails(
                      scope.row,
                      'manualAgainSuccessInfo',
                      '最终完成人工随访列表'
                    )
                  "
                >
                  <span class="button-zx">{{
                    scope.row.manualAgainSuccess
                  }}</span>
                </el-button>
              </template>
            </el-table-column>
            <template slot-scope="scope">
              <el-button
                size="medium"
                type="text"
                @click="
                  handleViewDetails(
                    scope.row,
                    'suggest7CountAgainInfo',
                    '再次随访复诊复查列表'
                  )
                "
              >
                <span class="button-zx">{{
                  scope.row.suggest7CountAgain
                }}</span>
              </el-button>
            </template>
          </el-table-column>
          <el-table-column
            v-if="isTargetHospital"
            label="语音"
            align="center"
          >
            <el-table-column
              label="发送完成"
              label="发送数"
              align="center"
              key="voiceSuccess"
              prop="voiceSuccess"
              key="voiceAgain"
              prop="voiceAgain"
              :render-header="Tooltipfswc"
            >
              <template slot-scope="scope">
@@ -626,17 +713,17 @@
                  @click="
                    handleViewDetails(
                      scope.row,
                      'voiceSuccessInfo',
                      'voiceAgainInfo',
                      '发送完成语音随访列表'
                    )
                  "
                >
                  <span class="button-zx">{{ scope.row.voiceSuccess }}</span>
                  <span class="button-zx">{{ scope.row.voiceAgain }}</span>
                </el-button>
              </template>
            </el-table-column>
            <el-table-column
              label="最终完成"
              label="成功数"
              align="center"
              key="voiceAgainSuccess"
              prop="voiceAgainSuccess"
@@ -661,16 +748,16 @@
              </template>
            </el-table-column>
          </el-table-column>
          <el-table-column
                  <el-table-column
            v-if="isTargetHospital"
            label="短信"
            label="微信"
            align="center"
          >
            <el-table-column
              label="发送完成"
              label="发送数"
              align="center"
              key="smsSuccess"
              prop="smsSuccess"
              key="weChatAgain"
              prop="weChatAgain"
              :render-header="Tooltipfswc"
            >
              <template slot-scope="scope">
@@ -680,17 +767,71 @@
                  @click="
                    handleViewDetails(
                      scope.row,
                      'smsSuccessInfo',
                      '发送完成短信随访列表'
                      'weChatAgainInfo',
                      '发送完成微信随访列表'
                    )
                  "
                >
                  <span class="button-zx">{{ scope.row.smsSuccess }}</span>
                  <span class="button-zx">{{ scope.row.weChatAgain }}</span>
                </el-button>
              </template>
            </el-table-column>
            <el-table-column
              label="最终完成"
              label="成功数"
              align="center"
              key="weChatAgainSuccess"
              prop="weChatAgainSuccess"
              :render-header="Tooltipzzwc"
            >
              <template slot-scope="scope">
                <el-button
                  size="medium"
                  type="text"
                  @click="
                    handleViewDetails(
                      scope.row,
                      'wechatAgainSuccessInfo',
                      '最终完成微信随访列表'
                    )
                  "
                >
                  <span class="button-zx">{{
                    scope.row.weChatAgainSuccess
                  }}</span>
                </el-button>
              </template>
            </el-table-column>
          </el-table-column>
          <el-table-column
            v-if="isTargetHospital"
            label="短信"
            align="center"
          >
            <el-table-column
              label="发送数"
              align="center"
              key="smsAgain"
              prop="smsAgain"
              :render-header="Tooltipfswc"
            >
              <template slot-scope="scope">
                <el-button
                  size="medium"
                  type="text"
                  @click="
                    handleViewDetails(
                      scope.row,
                      'smsAgainInfo',
                      '发送完成短信随访列表'
                    )
                  "
                >
                  <span class="button-zx">{{ scope.row.smsAgain }}</span>
                </el-button>
              </template>
            </el-table-column>
            <el-table-column
              label="成功数"
              align="center"
              key="smsAgainSuccess"
              prop="smsAgainSuccess"
@@ -715,16 +856,17 @@
              </template>
            </el-table-column>
          </el-table-column>
          <el-table-column
                    <el-table-column
            v-if="isTargetHospital"
            label="微信"
            label="人工"
            align="center"
          >
            <el-table-column
              label="发送完成"
              label="发送数"
              align="center"
              key="weChatSuccess"
              prop="weChatSuccess"
              key="manualAgain"
              prop="manualAgain"
              :render-header="Tooltipfswc"
            >
              <template slot-scope="scope">
@@ -734,20 +876,20 @@
                  @click="
                    handleViewDetails(
                      scope.row,
                      'wechatSuccessInfo',
                      '发送完成微信随访列表'
                      'manualAgainInfo',
                      '发送完成人工随访列表'
                    )
                  "
                >
                  <span class="button-zx">{{ scope.row.weChatSuccess }}</span>
                  <span class="button-zx">{{ scope.row.manualAgain }}</span>
                </el-button>
              </template>
            </el-table-column>
            <el-table-column
              label="最终完成"
              label="成功数"
              align="center"
              key="weChatAgainSuccess"
              prop="weChatAgainSuccess"
              key="manualAgainSuccess"
              prop="manualAgainSuccess"
              :render-header="Tooltipzzwc"
            >
              <template slot-scope="scope">
@@ -757,13 +899,13 @@
                  @click="
                    handleViewDetails(
                      scope.row,
                      'wechatAgainSuccessInfo',
                      '最终完成微信随访列表'
                      'manualAgainSuccessInfo',
                      '最终完成人工随访列表'
                    )
                  "
                >
                  <span class="button-zx">{{
                    scope.row.weChatAgainSuccess
                    scope.row.manualAgainSuccess
                  }}</span>
                </el-button>
              </template>
@@ -929,7 +1071,7 @@
      delete params.deptcodes.all;
      params.rateDay = this.orgname == "龙泉市人民医院" ? 21 : 7;
      getSfStatistics(params)
      return getSfStatistics(params)
        .then((response) => {
          this.tableData = this.customSort(response.data);
        })
@@ -946,7 +1088,9 @@
        "el-tooltip",
        {
          props: {
            content: "随访成功/(需随访-待随访)",
            content: this.isTargetHospital
              ? "随访成功/需随访"
              : "随访成功/(需随访-待随访)",
            placement: "top",
            effect: "dark",
          },
@@ -1036,7 +1180,7 @@
    },
    getRowKey(row) {
      return row.statisticaltype === 1
      return this.queryParams.statisticaltype === 1
        ? row.leavehospitaldistrictcode
        : row.deptcode;
    },
@@ -1103,7 +1247,7 @@
            return sum + (Number(item.pendingFollowUpAgain) || 0);
          }, 0);
          const denominator = totalNeed - totalPending;
          const denominator = this.isTargetHospital ? totalNeed : totalNeed - totalPending;
          if (denominator > 0) {
            sums[index] = ((totalSuccess / denominator) * 100).toFixed(2) + "%";
@@ -1181,7 +1325,7 @@
            return sum + (Number(item.pendingFollowUpAgain) || 0);
          }, 0);
          const denominator = totalNeed - totalPending;
          const denominator = this.isTargetHospital ? totalNeed : totalNeed - totalPending;
          if (denominator > 0) {
            sums[index] = ((totalSuccess / denominator) * 100).toFixed(2) + "%";
@@ -1312,8 +1456,8 @@
      const need = Number(needFollowUp) || 0;
      const pending = Number(pendingFollowUp) || 0;
      // 分母 = 需随访 - 待随访
      const denominator = need - pending;
      // 分母 = 需随访(目标医院)/ 需随访 - 待随访(其他)
      const denominator = this.isTargetHospital ? need : need - pending;
      if (denominator <= 0) {
        return "0.00%";
@@ -1535,13 +1679,11 @@
        },
      };
      // 标题
      worksheet.mergeCells(1, 1, 1, 10);
      worksheet.getCell(1, 1).value = `${areaName}医生再次随访列表`;
      worksheet.getCell(1, 1).style = titleStyle;
      worksheet.getRow(1).height = 30;
      const graded = this.isTargetHospital;
      // 成功率:景宁畲族自治县人民医院不展示
      const showSuccessRate = this.orgname != "景宁畲族自治县人民医院";
      // 表头
      // 列定义(与展开的医生子表保持一致)
      const headers = [
        "医生姓名",
        "科室",
@@ -1549,13 +1691,25 @@
        "无需随访",
        "应随访",
        "需随访",
        "待随访",
        ...(graded ? ["待发送", "已发送"] : ["待随访"]),
        "随访成功",
        "随访失败",
        "成功率", // 新增
        "随访率", // 原来在成功率位置
        ...(graded ? [] : ["随访失败"]),
        ...(showSuccessRate ? ["成功率"] : []),
        "随访率",
        "人工",
        "语音",
        "短信",
        "微信",
      ];
      const totalCols = headers.length;
      // 标题
      worksheet.mergeCells(1, 1, 1, totalCols);
      worksheet.getCell(1, 1).value = `${areaName}医生再次随访列表`;
      worksheet.getCell(1, 1).style = titleStyle;
      worksheet.getRow(1).height = 30;
      // 表头
      const headerRow = worksheet.addRow(headers);
      headerRow.eachCell((cell) => {
        cell.style = headerStyle;
@@ -1571,15 +1725,28 @@
          item.nonFollowUp,
          item.followUpNeeded,
          item.needFollowUpAgain,
          item.pendingFollowUpAgain,
          ...(graded
            ? [
                item.pendingFollowUpWaitSendAgain || 0,
                item.pendingFollowUpSentAgain || 0,
              ]
            : [item.pendingFollowUpAgain || 0]),
          item.followUpSuccessAgain,
          item.followUpFailAgain,
          this.calculateSuccessRate(
            item.followUpSuccessAgain,
            item.needFollowUpAgain,
            item.pendingFollowUpAgain
          ),
          ...(graded ? [] : [item.followUpFailAgain || 0]),
          ...(showSuccessRate
            ? [
                this.calculateSuccessRate(
                  item.followUpSuccessAgain,
                  item.needFollowUpAgain,
                  item.pendingFollowUpAgain
                ),
              ]
            : []),
          item.followUpRateAgain,
          item.manualAgain || 0,
          item.voiceAgain || 0,
          item.smsAgain || 0,
          item.weChatAgain || 0,
        ]);
        row.eachCell((cell) => {
          cell.style = cellStyle;
@@ -1599,33 +1766,28 @@
        };
      });
      // 列宽
      worksheet.columns = [
        { width: 15 },
        { width: 15 },
        { width: 12 },
        { width: 12 },
        { width: 12 },
        { width: 12 },
        { width: 12 },
        { width: 12 },
        { width: 12 },
        { width: 12 }, // 成功率
        { width: 12 }, // 随访率
      ];
      // 列宽(前两列姓名/科室较宽,其余统一)
      const widths = [15, 15];
      headers.slice(2).forEach(() => widths.push(12));
      worksheet.columns = widths.map((width) => ({ width }));
    },
    /** 再次随访 - 医生子表导出小计 */
    getDoctorAgainExportSummary(data) {
      const sums = ["小计"];
      const graded = this.isTargetHospital;
      const showSuccessRate = this.orgname != "景宁畲族自治县人民医院";
      const sums = ["小计", "-"];
      const keys = [
        "dischargeCount",
        "nonFollowUp",
        "followUpNeeded",
        "needFollowUpAgain",
        "pendingFollowUpAgain",
        ...(graded
          ? ["pendingFollowUpWaitSendAgain", "pendingFollowUpSentAgain"]
          : ["pendingFollowUpAgain"]),
        "followUpSuccessAgain",
        "followUpFailAgain",
        ...(graded ? [] : ["followUpFailAgain"]),
      ];
      keys.forEach((key) => {
@@ -1633,25 +1795,28 @@
      });
      // 成功率(平均值)
      const successRates = data
        .map((item) => {
          const success = Number(item.followUpSuccessAgain) || 0;
          const need = Number(item.needFollowUpAgain) || 0;
          const pending = Number(item.pendingFollowUpAgain) || 0;
          const denominator = need - pending;
          if (denominator <= 0) return 0;
          return success / denominator;
        })
        .filter((rate) => !isNaN(rate));
      if (showSuccessRate) {
        const successRates = data
          .map((item) => {
            const success = Number(item.followUpSuccessAgain) || 0;
            const need = Number(item.needFollowUpAgain) || 0;
            const pending = Number(item.pendingFollowUpAgain) || 0;
            const denominator = graded ? need : need - pending;
            if (denominator <= 0) return 0;
            return success / denominator;
          })
          .filter((rate) => !isNaN(rate));
      sums.push(
        successRates.length
          ? (
              (successRates.reduce((a, b) => a + b, 0) / successRates.length) *
              100
            ).toFixed(2) + "%"
          : "0.00%"
      );
        sums.push(
          successRates.length
            ? (
                (successRates.reduce((a, b) => a + b, 0) /
                  successRates.length) *
                100
              ).toFixed(2) + "%"
            : "0.00%"
        );
      }
      // 随访率(平均值)
      const followUpRates = data
@@ -1666,6 +1831,13 @@
              100
            ).toFixed(2) + "%"
          : "0.00%"
      );
      // 人工/语音/短信/微信
      ["manualAgain", "voiceAgain", "smsAgain", "weChatAgain"].forEach(
        (key) => {
          sums.push(data.reduce((t, r) => t + (Number(r[key]) || 0), 0));
        }
      );
      return sums;
@@ -1745,92 +1917,182 @@
        },
      };
      const titleText = `再次${serviceTypeName}统计表_${sheetNameSuffix}`;
      // 添加标题行
      worksheet.mergeCells(1, 1, 1, 16);
      const titleCell = worksheet.getCell(1, 1);
      titleCell.value = titleText; // 使用动态标题
      titleCell.style = titleStyle;
      worksheet.getRow(1).height = 35;
      // 是否为目标医院(人工/语音/短信/微信 按 发送数/成功数 分级展示)
      const graded = this.isTargetHospital;
      // 表头
      // 表头需要增加成功率列
      const secondRowHeaders = [
      const baseHeaders = [
        "",
        "出院病区",
        "科室",
        "出院人次",
        "无需随访人次",
        "应随访人次",
        "需随访",
        "待随访",
        "随访成功",
        "随访失败",
        "成功率", // 成功率应该在随访失败后面
        "随访率", // 随访率在成功率后面
        "人工",
        "语音", // 修正:应该是语音,不是短信
        "短信", // 短信
        "微信", // 微信
      ];
      const coreHeaders = [
        "需随访",
        ...(this.isTargetHospital ? ["待发送", "已发送"] : ["待随访"]),
        "随访成功",
        ...(this.isTargetHospital ? [] : ["随访失败"]),
        "成功率",
        "随访率",
      ];
      const methodGroups = this.getMethodColumns();
      secondRowHeaders.forEach((header, index) => {
        const cell = worksheet.getCell(3, index + 1);
        cell.value = header;
        cell.style = headerStyle;
      });
      const baseCount = baseHeaders.length; // 6
      const coreCount = coreHeaders.length; // 6
      const methodLeafCount = methodGroups.reduce(
        (sum, g) => sum + g.fields.length,
        0
      ); // 8 或 4
      const totalCols = baseCount + coreCount + methodLeafCount; // 20 或 16
      const coreStartCol = baseCount + 1; // 7
      const methodStartCol = baseCount + coreCount + 1; // 13
      // 更新合并单元格的范围
      for (let i = 1; i <= 6; i++) {
        worksheet.mergeCells(2, i, 3, i);
        const cell = worksheet.getCell(2, i);
        cell.style = headerStyle;
      const titleText = `再次${serviceTypeName}统计表_${sheetNameSuffix}`;
      // 添加标题行
      worksheet.mergeCells(1, 1, 1, totalCols);
      const titleCell = worksheet.getCell(1, 1);
      titleCell.value = titleText;
      titleCell.style = titleStyle;
      worksheet.getRow(1).height = 35;
      if (graded) {
        // 表头占 3 行(第2/3/4行),数据从第5行开始
        const headerEndRow = 4;
        // 第2行:基础列纵向合并 + 随访分组横向合并
        for (let i = 1; i <= baseCount; i++) {
          worksheet.mergeCells(2, i, headerEndRow, i);
          const cell = worksheet.getCell(2, i);
          cell.value = baseHeaders[i - 1];
          cell.style = headerStyle;
        }
        worksheet.mergeCells(2, coreStartCol, 2, totalCols);
        worksheet.getCell(2, coreStartCol).value = "再次出院随访";
        worksheet.getCell(2, coreStartCol).style = headerStyle;
        // 第3行:随访核心列(目标医院“待随访”下嵌套“待发送/已发送”)
        worksheet.mergeCells(3, coreStartCol, headerEndRow, coreStartCol);
        worksheet.getCell(3, coreStartCol).value = "需随访";
        worksheet.getCell(3, coreStartCol).style = headerStyle;
        worksheet.mergeCells(3, coreStartCol + 1, 3, coreStartCol + 2);
        worksheet.getCell(3, coreStartCol + 1).value = "待随访";
        worksheet.getCell(3, coreStartCol + 1).style = headerStyle;
        worksheet.mergeCells(
          3,
          coreStartCol + 3,
          headerEndRow,
          coreStartCol + 3
        );
        worksheet.getCell(3, coreStartCol + 3).value = "随访成功";
        worksheet.getCell(3, coreStartCol + 3).style = headerStyle;
        ["成功率", "随访率"].forEach((label, i) => {
          const col = coreStartCol + 4 + i;
          worksheet.mergeCells(3, col, headerEndRow, col);
          worksheet.getCell(3, col).value = label;
          worksheet.getCell(3, col).style = headerStyle;
        });
        // 第4行:待发送/已发送 子列
        worksheet.getCell(4, coreStartCol + 1).value = "待发送";
        worksheet.getCell(4, coreStartCol + 1).style = headerStyle;
        worksheet.getCell(4, coreStartCol + 2).value = "已发送";
        worksheet.getCell(4, coreStartCol + 2).style = headerStyle;
        let mc = methodStartCol;
        methodGroups.forEach((g) => {
          if (g.fields.length > 1) {
            worksheet.mergeCells(3, mc, 3, mc + g.fields.length - 1);
          }
          const cell = worksheet.getCell(3, mc);
          cell.value = g.label;
          cell.style = headerStyle;
          mc += g.fields.length;
        });
        // 第4行:随访方式子列(发送数/成功数)
        mc = methodStartCol;
        methodGroups.forEach((g) => {
          g.fields.forEach((field, idx) => {
            const cell = worksheet.getCell(4, mc + idx);
            cell.value = g.sub[idx];
            cell.style = headerStyle;
          });
          mc += g.fields.length;
        });
        worksheet.getRow(2).height = 28;
        worksheet.getRow(3).height = 24;
        worksheet.getRow(4).height = 24;
      } else {
        // 表头占 2 行(第2/3行),数据从第4行开始
        const headerEndRow = 3;
        for (let i = 1; i <= baseCount; i++) {
          worksheet.mergeCells(2, i, headerEndRow, i);
          const cell = worksheet.getCell(2, i);
          cell.value = baseHeaders[i - 1];
          cell.style = headerStyle;
        }
        worksheet.mergeCells(2, coreStartCol, 2, totalCols);
        worksheet.getCell(2, coreStartCol).value = "再次出院随访";
        worksheet.getCell(2, coreStartCol).style = headerStyle;
        // 第3行:随访核心列 + 随访方式列
        for (let k = 0; k < coreCount; k++) {
          const cell = worksheet.getCell(3, coreStartCol + k);
          cell.value = coreHeaders[k];
          cell.style = headerStyle;
        }
        let mc = methodStartCol;
        methodGroups.forEach((g) => {
          const cell = worksheet.getCell(3, mc);
          cell.value = g.label;
          cell.style = headerStyle;
          mc += 1;
        });
        worksheet.getRow(2).height = 28;
        worksheet.getRow(3).height = 25;
      }
      worksheet.getCell(2, 1).value = "";
      worksheet.getCell(2, 2).value = "出院病区";
      worksheet.getCell(2, 3).value = "科室";
      worksheet.getCell(2, 4).value = "出院人次";
      worksheet.getCell(2, 5).value = "无需随访人次";
      worksheet.getCell(2, 6).value = "应随访人次";
      // 注意:由于增加了成功率列,合并列数要增加
      worksheet.mergeCells(2, 7, 2, 16); // 从7合并到16(原来是7-14)
      worksheet.getCell(2, 7).value = "再次出院随访";
      worksheet.getCell(2, 7).style = headerStyle;
      worksheet.getRow(2).height = 28;
      worksheet.getRow(3).height = 25;
      // 数据行
      const dataStartRow = graded ? 5 : 4;
      this.tableData.forEach((item, rowIndex) => {
        const dataRow = worksheet.addRow(
          [
            "",
            item.leavehospitaldistrictname || "",
            item.deptname || "",
            item.dischargeCount || 0,
            item.nonFollowUp || 0,
            item.followUpNeeded || 0,
            item.needFollowUpAgain || 0,
            item.pendingFollowUpAgain || 0,
            item.followUpSuccessAgain || 0,
            item.followUpFailAgain || 0,
            // 成功率 - 需要动态计算
            this.calculateSuccessRate(
              item.followUpSuccessAgain,
              item.needFollowUpAgain,
              item.pendingFollowUpAgain
            ),
            item.followUpRateAgain || "0%", // 随访率
            item.manualAgain || 0,
            item.voiceAgain || 0,
            item.smsAgain || 0,
            item.weChatAgain || 0,
          ],
          rowIndex + 4
        );
        const rowValues = [
          "",
          item.leavehospitaldistrictname || "",
          item.deptname || "",
          item.dischargeCount || 0,
          item.nonFollowUp || 0,
          item.followUpNeeded || 0,
          item.needFollowUpAgain || 0,
          ...(this.isTargetHospital
            ? [
                item.pendingFollowUpWaitSendAgain || 0,
                item.pendingFollowUpSentAgain || 0,
              ]
            : [item.pendingFollowUpAgain || 0]),
          item.followUpSuccessAgain || 0,
          ...(this.isTargetHospital ? [] : [item.followUpFailAgain || 0]),
          // 成功率 - 需要动态计算
          this.calculateSuccessRate(
            item.followUpSuccessAgain,
            item.needFollowUpAgain,
            item.pendingFollowUpAgain
          ),
          item.followUpRateAgain || "0%", // 随访率
        ];
        methodGroups.forEach((g) => {
          g.fields.forEach((field) => {
            rowValues.push(item[field] || 0);
          });
        });
        const dataRow = worksheet.addRow(rowValues, rowIndex + dataStartRow);
        dataRow.eachCell((cell) => {
          cell.style = cellStyle;
        });
@@ -1849,66 +2111,95 @@
      summaryRow.height = 28;
      // 列宽
      // 修正列宽
      worksheet.columns = [
        { width: 8 },
        { width: 20 },
        { width: 15 },
        { width: 12 },
        { width: 12 },
        { width: 12 },
        { width: 10 },
        { width: 10 },
        { width: 10 },
        { width: 10 },
        { width: 12 }, // 成功率
        { width: 12 }, // 随访率
        { width: 8 }, // 人工
        { width: 8 }, // 语音
        { width: 8 }, // 短信
        { width: 8 }, // 微信
      const widths = [8, 20, 15, 12, 12, 12, 10, 10, 10, 10, 12, 12];
      methodGroups.forEach((g) => {
        g.fields.forEach(() => widths.push(8));
      });
      worksheet.columns = widths.map((width) => ({ width }));
    },
    getMethodColumns() {
      // 随访方式列配置:目标医院按“发送数/成功数”分级展示
      if (this.isTargetHospital) {
        return [
          { label: "人工", fields: ["manualAgain", "manualAgainSuccess"], sub: ["发送数", "成功数"] },
          { label: "语音", fields: ["voiceAgain", "voiceAgainSuccess"], sub: ["发送数", "成功数"] },
          { label: "短信", fields: ["smsAgain", "smsAgainSuccess"], sub: ["发送数", "成功数"] },
          { label: "微信", fields: ["weChatAgain", "weChatAgainSuccess"], sub: ["发送数", "成功数"] },
        ];
      }
      return [
        { label: "人工", fields: ["manualAgain"], sub: ["人工"] },
        { label: "语音", fields: ["voiceAgain"], sub: ["语音"] },
        { label: "短信", fields: ["smsAgain"], sub: ["短信"] },
        { label: "微信", fields: ["weChatAgain"], sub: ["微信"] },
      ];
    },
    getExportSummaries() {
      const summaries = [
        "合计",
        "/",
        "/",
        0, // 3: dischargeCount
        0, // 4: nonFollowUp
        0, // 5: followUpNeeded
        0, // 6: needFollowUpAgain
        0, // 7: pendingFollowUpAgain
        0, // 8: followUpSuccessAgain
        0, // 9: followUpFailAgain
        "0%", // 10: 成功率
        "0%", // 11: 随访率
        0, // 12: manualAgain
        0, // 13: voiceAgain
        0, // 14: smsAgain
        0, // 15: weChatAgain
      ];
      const summaries = this.isTargetHospital
        ? [
            "合计",
            "/",
            "/",
            0, // 3: dischargeCount
            0, // 4: nonFollowUp
            0, // 5: followUpNeeded
            0, // 6: needFollowUpAgain
            0, // 7: pendingFollowUpWaitSendAgain
            0, // 8: pendingFollowUpSentAgain
            0, // 9: followUpSuccessAgain
            "0%", // 10: 成功率
            "0%", // 11: 随访率
          ]
        : [
            "合计",
            "/",
            "/",
            0, // 3: dischargeCount
            0, // 4: nonFollowUp
            0, // 5: followUpNeeded
            0, // 6: needFollowUpAgain
            0, // 7: pendingFollowUpAgain
            0, // 8: followUpSuccessAgain
            0, // 9: followUpFailAgain
            "0%", // 10: 成功率
            "0%", // 11: 随访率
          ];
      const methodFields = this.getMethodColumns().reduce(
        (arr, g) => arr.concat(g.fields),
        []
      );
      const methodStartIndex = 12;
      methodFields.forEach(() => summaries.push(0));
      this.tableData.forEach((item) => {
        summaries[3] += Number(item.dischargeCount) || 0;
        summaries[4] += Number(item.nonFollowUp) || 0;
        summaries[5] += Number(item.followUpNeeded) || 0;
        summaries[6] += Number(item.needFollowUpAgain) || 0;
        summaries[7] += Number(item.pendingFollowUpAgain) || 0;
        summaries[8] += Number(item.followUpSuccessAgain) || 0;
        summaries[9] += Number(item.followUpFailAgain) || 0;
        summaries[12] += Number(item.manualAgain) || 0;
        summaries[13] += Number(item.voiceAgain) || 0;
        summaries[14] += Number(item.smsAgain) || 0;
        summaries[15] += Number(item.weChatAgain) || 0;
        if (this.isTargetHospital) {
          summaries[7] += Number(item.pendingFollowUpWaitSendAgain) || 0;
          summaries[8] += Number(item.pendingFollowUpSentAgain) || 0;
          summaries[9] += Number(item.followUpSuccessAgain) || 0;
        } else {
          summaries[7] += Number(item.pendingFollowUpAgain) || 0;
          summaries[8] += Number(item.followUpSuccessAgain) || 0;
          summaries[9] += Number(item.followUpFailAgain) || 0;
        }
        methodFields.forEach((field, i) => {
          summaries[methodStartIndex + i] += Number(item[field]) || 0;
        });
      });
      // 成功率计算
      const totalSuccess = summaries[8]; // followUpSuccessAgain的总和
      const totalSuccess = this.isTargetHospital
        ? summaries[9] // followUpSuccessAgain的总和
        : summaries[8]; // followUpSuccessAgain的总和
      const totalNeed = summaries[6]; // needFollowUpAgain的总和
      const totalPending = summaries[7]; // pendingFollowUpAgain的总和
      const denominator = totalNeed - totalPending;
      const denominator = this.isTargetHospital
        ? totalNeed
        : totalNeed - summaries[7];
      if (denominator > 0) {
        summaries[10] = ((totalSuccess / denominator) * 100).toFixed(2) + "%";
@@ -1929,7 +2220,10 @@
      }
      // 格式化数字
      [3, 4, 5, 6, 7, 8, 9, 12, 13, 14, 15].forEach((index) => {
      const numericIndices = [3, 4, 5, 6, 7, 8, 9].concat(
        methodFields.map((_, i) => methodStartIndex + i)
      );
      numericIndices.forEach((index) => {
        summaries[index] = this.formatNumber(summaries[index]);
      });