WXL (wul)
8 天以前 b4fe2c16274a91fee4fb26d91374f95fbe2dbcec
src/views/sfstatistics/percentage/components/FirstFollowUp.vue
@@ -156,6 +156,7 @@
                  </template>
                </el-table-column>
                <el-table-column
                  v-if="!isTargetHospital"
                  label="待随访"
                  align="center"
                  key="pendingFollowUp"
@@ -179,6 +180,62 @@
                      }}</span>
                    </el-button>
                  </template>
                </el-table-column>
                <el-table-column
                  v-if="isTargetHospital"
                  label="待随访"
                  align="center"
                >
                  <el-table-column
                    label="待发送"
                    align="center"
                    key="pendingFollowUpWaitSend"
                    prop="pendingFollowUpWaitSend"
                  >
                    <template slot-scope="scope">
                      <el-button
                        size="medium"
                        type="text"
                        @click="
                          handleViewDetails(
                            scope.row,
                            'pendingFollowUpWaitSendInfo',
                            '待发送列表',
                            '1'
                          )
                        "
                      >
                        <span class="button-zx">{{
                          scope.row.pendingFollowUpWaitSend
                        }}</span>
                      </el-button>
                    </template>
                  </el-table-column>
                  <el-table-column
                    label="已发送"
                    align="center"
                    key="pendingFollowUpSent"
                    prop="pendingFollowUpSent"
                  >
                    <template slot-scope="scope">
                      <el-button
                        size="medium"
                        type="text"
                        @click="
                          handleViewDetails(
                            scope.row,
                            'pendingFollowUpSentInfo',
                            '已发送列表',
                            '1'
                          )
                        "
                      >
                        <span class="button-zx">{{
                          scope.row.pendingFollowUpSent
                        }}</span>
                      </el-button>
                    </template>
                  </el-table-column>
                </el-table-column>
                <el-table-column
                  label="随访成功"
@@ -206,6 +263,7 @@
                  </template>
                </el-table-column>
                <el-table-column
                  v-if="!isTargetHospital"
                  label="随访失败"
                  align="center"
                  key="followUpFail"
@@ -272,9 +330,9 @@
                      type="text"
                      @click="handleSeeDetails(scope.row)"
                    >
                      <span class="button-zx"
                        >{{ (Number(scope.row.rate) * 100).toFixed(2) }}%</span
                      >
                      <span class="button-zx">{{
                        getTimelyRateText(scope.row)
                      }}</span>
                    </el-button>
                  </template>
                </el-table-column>
@@ -476,6 +534,7 @@
            </template>
          </el-table-column>
          <el-table-column
            v-if="!isTargetHospital"
            label="待随访"
            align="center"
            key="pendingFollowUp"
@@ -496,6 +555,60 @@
                <span class="button-zx">{{ scope.row.pendingFollowUp }}</span>
              </el-button>
            </template>
          </el-table-column>
          <el-table-column
            v-if="isTargetHospital"
            label="待随访"
            align="center"
          >
            <el-table-column
              label="待发送"
              align="center"
              key="pendingFollowUpWaitSend"
              prop="pendingFollowUpWaitSend"
            >
              <template slot-scope="scope">
                <el-button
                  size="medium"
                  type="text"
                  @click="
                    handleViewDetails(
                      scope.row,
                      'pendingFollowUpWaitSendInfo',
                      '待发送列表'
                    )
                  "
                >
                  <span class="button-zx">{{
                    scope.row.pendingFollowUpWaitSend
                  }}</span>
                </el-button>
              </template>
            </el-table-column>
            <el-table-column
              label="已发送"
              align="center"
              key="pendingFollowUpSent"
              prop="pendingFollowUpSent"
            >
              <template slot-scope="scope">
                <el-button
                  size="medium"
                  type="text"
                  @click="
                    handleViewDetails(
                      scope.row,
                      'pendingFollowUpSentInfo',
                      '已发送列表'
                    )
                  "
                >
                  <span class="button-zx">{{
                    scope.row.pendingFollowUpSent
                  }}</span>
                </el-button>
              </template>
            </el-table-column>
          </el-table-column>
          <el-table-column
            label="随访成功"
@@ -520,6 +633,7 @@
            </template>
          </el-table-column>
          <el-table-column
            v-if="!isTargetHospital"
            label="随访失败"
            align="center"
            key="followUpFail"
@@ -583,73 +697,39 @@
                type="text"
                @click="handleSeeDetails(scope.row)"
              >
                <span class="button-zx"
                  >{{ (Number(scope.row.rate) * 100).toFixed(2) }}%</span
                >
                <span class="button-zx">{{
                  getTimelyRateText(scope.row)
                }}</span>
              </el-button>
            </template>
          </el-table-column>
          <el-table-column
            v-if="isTargetHospital"
            label="人工"
            v-if="orgname == '缙云县人民医院'"
            label="及时随访人次"
            align="center"
            key="timelyFollowUp"
            prop="timelyFollowUp"
            width="138"
          >
            <el-table-column
              label="发送完成"
              align="center"
              key="manual"
              prop="manual"
              :render-header="Tooltipfswc"
            >
              <template slot-scope="scope">
                <el-button
                  size="medium"
                  type="text"
                  @click="
                    handleViewDetails(
                      scope.row,
                      'manualInfo',
                      '发送完成人工随访列表'
                    )
                  "
                >
                  <span class="button-zx">{{ scope.row.manual }}</span>
                </el-button>
              </template>
            </el-table-column>
            <el-table-column
              label="最终完成"
              align="center"
              key="manualSuccess"
              prop="manualSuccess"
              :render-header="Tooltipzzwc"
            >
              <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>
            <template slot-scope="scope">
              <el-button
                size="medium"
                type="text"
                @click="
                  handleViewDetails(
                    scope.row,
                    'timelyFollowUpInfo',
                    '及时随访列表'
                  )
                "
              >
                <span class="button-zx">{{ scope.row.timelyFollowUp }}</span>
              </el-button>
            </template>
          </el-table-column>
          <el-table-column
            v-if="isTargetHospital"
            label="语音"
            align="center"
          >
          <el-table-column v-if="isTargetHospital" label="语音" align="center">
            <el-table-column
              label="发送完成"
              label="发送数"
              align="center"
              key="voice"
              prop="voice"
@@ -672,7 +752,7 @@
              </template>
            </el-table-column>
            <el-table-column
              label="最终完成"
              label="成功数"
              align="center"
              key="voiceSuccess"
              prop="voiceSuccess"
@@ -690,74 +770,14 @@
                    )
                  "
                >
                  <span class="button-zx">{{
                    scope.row.voiceSuccess
                  }}</span>
                  <span class="button-zx">{{ scope.row.voiceSuccess }}</span>
                </el-button>
              </template>
            </el-table-column>
          </el-table-column>
          <el-table-column
            v-if="isTargetHospital"
            label="短信"
            align="center"
          >
          <el-table-column v-if="isTargetHospital" label="微信" align="center">
            <el-table-column
              label="发送完成"
              align="center"
              key="sms"
              prop="sms"
              :render-header="Tooltipfswc"
            >
              <template slot-scope="scope">
                <el-button
                  size="medium"
                  type="text"
                  @click="
                    handleViewDetails(
                      scope.row,
                      'smsInfo',
                      '发送完成短信随访列表'
                    )
                  "
                >
                  <span class="button-zx">{{ scope.row.sms }}</span>
                </el-button>
              </template>
            </el-table-column>
            <el-table-column
              label="最终完成"
              align="center"
              key="smsSuccess"
              prop="smsSuccess"
              :render-header="Tooltipzzwc"
            >
              <template slot-scope="scope">
                <el-button
                  size="medium"
                  type="text"
                  @click="
                    handleViewDetails(
                      scope.row,
                      'smsSuccessInfo',
                      '最终完成短信随访列表'
                    )
                  "
                >
                  <span class="button-zx">{{
                    scope.row.smsSuccess
                  }}</span>
                </el-button>
              </template>
            </el-table-column>
          </el-table-column>
          <el-table-column
            v-if="isTargetHospital"
            label="微信"
            align="center"
          >
            <el-table-column
              label="发送完成"
              label="发送数"
              align="center"
              key="weChat"
              prop="weChat"
@@ -780,7 +800,7 @@
              </template>
            </el-table-column>
            <el-table-column
              label="最终完成"
              label="成功数"
              align="center"
              key="weChatSuccess"
              prop="weChatSuccess"
@@ -798,13 +818,108 @@
                    )
                  "
                >
                  <span class="button-zx">{{
                    scope.row.weChatSuccess
                  }}</span>
                  <span class="button-zx">{{ scope.row.weChatSuccess }}</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="sms"
              prop="sms"
              :render-header="Tooltipfswc"
            >
              <template slot-scope="scope">
                <el-button
                  size="medium"
                  type="text"
                  @click="
                    handleViewDetails(
                      scope.row,
                      'smsInfo',
                      '发送完成短信随访列表'
                    )
                  "
                >
                  <span class="button-zx">{{ scope.row.sms }}</span>
                </el-button>
              </template>
            </el-table-column>
            <el-table-column
              label="成功数"
              align="center"
              key="smsSuccess"
              prop="smsSuccess"
              :render-header="Tooltipzzwc"
            >
              <template slot-scope="scope">
                <el-button
                  size="medium"
                  type="text"
                  @click="
                    handleViewDetails(
                      scope.row,
                      'smsSuccessInfo',
                      '最终完成短信随访列表'
                    )
                  "
                >
                  <span class="button-zx">{{ scope.row.smsSuccess }}</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="manual"
              prop="manual"
              :render-header="Tooltipfswc"
            >
              <template slot-scope="scope">
                <el-button
                  size="medium"
                  type="text"
                  @click="
                    handleViewDetails(
                      scope.row,
                      'manualInfo',
                      '发送完成人工随访列表'
                    )
                  "
                >
                  <span class="button-zx">{{ scope.row.manual }}</span>
                </el-button>
              </template>
            </el-table-column>
            <el-table-column
              label="成功数"
              align="center"
              key="manualSuccess"
              prop="manualSuccess"
              :render-header="Tooltipzzwc"
            >
              <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>
          <el-table-column
            v-if="!isTargetHospital"
            label="人工"
@@ -881,11 +996,9 @@
          </el-table-column>
        </el-table-column>
        <!-- 随访情况列(仅丽水市中医院显示) -->
        <!-- 随访情况列(丽水市中医院已移到综合统计,此处仅景宁畲族自治县人民医院显示) -->
        <el-table-column
          v-if="
            orgname == '丽水市中医院' || orgname == '景宁畲族自治县人民医院'
          "
          v-if="orgname == '景宁畲族自治县人民医院'"
          align="center"
          label="随访情况"
        >
@@ -1090,8 +1203,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%";
@@ -1099,6 +1212,26 @@
      const rate = (success / denominator) * 100;
      return rate.toFixed(2) + "%";
    },
    // 计算及时率(目标医院):(需随访 - 人工规定时间内没打过电话) / 需随访
    calculateTimelyRate(needFollowUp, manualCallTimeout) {
      const need = Number(needFollowUp) || 0;
      const timeout = Number(manualCallTimeout) || 0;
      if (need <= 0) {
        return "0.00%";
      }
      const rate = ((need - timeout) / need) * 100;
      return (rate < 0 ? 0 : rate).toFixed(2) + "%";
    },
    // 及时率展示文案:目标医院前端计算,其他用后端 rate 字段
    getTimelyRateText(row) {
      if (this.isTargetHospital) {
        return this.calculateTimelyRate(
          row.needFollowUp,
          row.manualCallTimeout
        );
      }
      return (Number(row.rate) * 100).toFixed(2) + "%";
    },
    // 在统计汇总方法中处理成功率
    getSummaries(param) {
@@ -1129,17 +1262,51 @@
            return sum + (Number(item.pendingFollowUp) || 0);
          }, 0);
          const denominator = totalNeed - totalPending;
          const denominator = this.isTargetHospital
            ? totalNeed
            : totalNeed - totalPending;
          if (denominator > 0) {
            sums[index] = ((totalSuccess / denominator) * 100).toFixed(2) + "%";
          } else {
            sums[index] = "0.00%";
          }
        } else if (
          column.property === "followUpRate" ||
          column.property === "rate"
        ) {
        } else if (column.property === "rate") {
          if (this.isTargetHospital) {
            const totalNeed = data.reduce(
              (sum, item) => sum + (Number(item.needFollowUp) || 0),
              0
            );
            const totalTimeout = data.reduce(
              (sum, item) => sum + (Number(item.manualCallTimeout) || 0),
              0
            );
            sums[index] = this.calculateTimelyRate(totalNeed, totalTimeout);
          } else {
            const percentageValues = data
              .map((item) => {
                const value = item[column.property];
                if (!value || value === "-" || value === "0%") return null;
                if (typeof value === "string" && value.includes("%")) {
                  const numValue = parseFloat(value.replace("%", "")) / 100;
                  return isNaN(numValue) ? null : numValue;
                } else {
                  const numValue = parseFloat(value);
                  return isNaN(numValue) ? null : numValue;
                }
              })
              .filter((value) => value !== null && value !== 0);
            if (percentageValues.length > 0) {
              const average =
                percentageValues.reduce((sum, value) => sum + value, 0) /
                percentageValues.length;
              sums[index] = (average * 100).toFixed(2) + "%";
            } else {
              sums[index] = "0.00%";
            }
          }
        } else if (column.property === "followUpRate") {
          const percentageValues = data
            .map((item) => {
              const value = item[column.property];
@@ -1185,7 +1352,9 @@
        "el-tooltip",
        {
          props: {
            content: "随访成功/(需随访-待随访)",
            content: this.isTargetHospital
              ? "随访成功/需随访"
              : "随访成功/(需随访-待随访)",
            placement: "top",
            effect: "dark",
          },
@@ -1198,8 +1367,9 @@
        "el-tooltip",
        {
          props: {
            content:
              "(出院时间+任务周期)小于完成时间即为超时;(需随访-超时)/需随访",
            content: this.isTargetHospital
              ? "及时率=(需随访-人工规定时间内没打过电话)/需随访"
              : "(出院时间+任务周期)小于完成时间即为超时;(需随访-超时)/需随访",
            placement: "top",
            effect: "dark",
          },
@@ -1275,17 +1445,51 @@
            return sum + (Number(item.pendingFollowUp) || 0);
          }, 0);
          const denominator = totalNeed - totalPending;
          const denominator = this.isTargetHospital
            ? totalNeed
            : totalNeed - totalPending;
          if (denominator > 0) {
            sums[index] = ((totalSuccess / denominator) * 100).toFixed(2) + "%";
          } else {
            sums[index] = "0.00%";
          }
        } else if (
          column.property === "followUpRate" ||
          column.property === "rate"
        ) {
        } else if (column.property === "rate") {
          if (this.isTargetHospital) {
            const totalNeed = data.reduce(
              (sum, item) => sum + (Number(item.needFollowUp) || 0),
              0
            );
            const totalTimeout = data.reduce(
              (sum, item) => sum + (Number(item.manualCallTimeout) || 0),
              0
            );
            sums[index] = this.calculateTimelyRate(totalNeed, totalTimeout);
          } else {
            const percentageValues = data
              .map((item) => {
                const value = item[column.property];
                if (!value || value === "-" || value === "0%") return null;
                if (typeof value === "string" && value.includes("%")) {
                  const numValue = parseFloat(value.replace("%", "")) / 100;
                  return isNaN(numValue) ? null : numValue;
                } else {
                  const numValue = parseFloat(value);
                  return isNaN(numValue) ? null : numValue;
                }
              })
              .filter((value) => value !== null && value !== 0);
            if (percentageValues.length > 0) {
              const average =
                percentageValues.reduce((sum, value) => sum + value, 0) /
                percentageValues.length;
              sums[index] = (average * 100).toFixed(2) + "%";
            } else {
              sums[index] = "0.00%";
            }
          }
        } else if (column.property === "followUpRate") {
          const percentageValues = data
            .map((item) => {
              const value = item[column.property];
@@ -1629,13 +1833,12 @@
        },
      };
      // 标题
      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 showTimelyRate = this.orgname != "丽水市中医院";
      // 表头
      // 列定义(与展开的医生子表保持一致)
      const headers = [
        "医生姓名",
        "科室",
@@ -1643,13 +1846,26 @@
        "无需随访",
        "应随访",
        "需随访",
        "待随访",
        ...(graded ? ["待发送", "已发送"] : ["待随访"]),
        "随访成功",
        "随访失败",
        "成功率", // 新增
        "随访率", // 原来在成功率位置
        ...(graded ? [] : ["随访失败"]),
        ...(showSuccessRate ? ["成功率"] : []),
        "随访率",
        ...(showTimelyRate ? ["及时率"] : []),
        "人工",
        "语音",
        "短信",
        "微信",
      ];
      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;
@@ -1665,15 +1881,26 @@
          item.nonFollowUp,
          item.followUpNeeded,
          item.needFollowUp,
          item.pendingFollowUp,
          ...(graded
            ? [item.pendingFollowUpWaitSend || 0, item.pendingFollowUpSent || 0]
            : [item.pendingFollowUp || 0]),
          item.followUpSuccess,
          item.followUpFail,
          this.calculateSuccessRate(
            item.followUpSuccess,
            item.needFollowUp,
            item.pendingFollowUp
          ),
          ...(graded ? [] : [item.followUpFail || 0]),
          ...(showSuccessRate
            ? [
                this.calculateSuccessRate(
                  item.followUpSuccess,
                  item.needFollowUp,
                  item.pendingFollowUp
                ),
              ]
            : []),
          item.followUpRate,
          ...(showTimelyRate ? [this.getTimelyRateText(item)] : []),
          item.manual || 0,
          item.voice || 0,
          item.sms || 0,
          item.weChat || 0,
        ]);
        row.eachCell((cell) => {
          cell.style = cellStyle;
@@ -1691,58 +1918,66 @@
        };
      });
      // 列宽
      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 }));
    },
    getDoctorExportSummary(data) {
      const sums = ["小计"];
      const graded = this.isTargetHospital;
      const showSuccessRate = this.orgname != "景宁畲族自治县人民医院";
      const showTimelyRate = this.orgname != "丽水市中医院";
      const keys = [
        "dischargeCount",
        "nonFollowUp",
        "followUpNeeded",
        "needFollowUp",
        "pendingFollowUp",
        "followUpSuccess",
        "followUpFail",
      ];
      const sums = ["小计", "-"];
      // 数值列求和
      const keys = graded
        ? [
            "dischargeCount",
            "nonFollowUp",
            "followUpNeeded",
            "needFollowUp",
            "pendingFollowUpWaitSend",
            "pendingFollowUpSent",
            "followUpSuccess",
          ]
        : [
            "dischargeCount",
            "nonFollowUp",
            "followUpNeeded",
            "needFollowUp",
            "pendingFollowUp",
            "followUpSuccess",
            "followUpFail",
          ];
      keys.forEach((key) => {
        sums.push(data.reduce((t, r) => t + (Number(r[key]) || 0), 0));
      });
      // 成功率(平均值)
      const successRates = data
        .map((item) => {
          const success = Number(item.followUpSuccess) || 0;
          const need = Number(item.needFollowUp) || 0;
          const pending = Number(item.pendingFollowUp) || 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.followUpSuccess) || 0;
            const need = Number(item.needFollowUp) || 0;
            const pending = Number(item.pendingFollowUp) || 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
@@ -1758,6 +1993,38 @@
            ).toFixed(2) + "%"
          : "0.00%"
      );
      // 及时率(目标医院计算,其他取 rate 平均)
      if (showTimelyRate) {
        if (graded) {
          const totalNeed = data.reduce(
            (s, r) => s + (Number(r.needFollowUp) || 0),
            0
          );
          const totalTimeout = data.reduce(
            (s, r) => s + (Number(r.manualCallTimeout) || 0),
            0
          );
          sums.push(this.calculateTimelyRate(totalNeed, totalTimeout));
        } else {
          const rateValues = data
            .map((i) => this.extractPercentageValue(i.rate))
            .filter(Boolean);
          sums.push(
            rateValues.length
              ? (
                  (rateValues.reduce((a, b) => a + b, 0) / rateValues.length) *
                  100
                ).toFixed(2) + "%"
              : "0.00%"
          );
        }
      }
      // 人工/语音/短信/微信
      ["manual", "voice", "sms", "weChat"].forEach((key) => {
        sums.push(data.reduce((t, r) => t + (Number(r[key]) || 0), 0));
      });
      return sums;
    },
@@ -1835,7 +2102,7 @@
          right: { style: "thin", color: { argb: "FFD0D0D0" } },
        },
      };
      // 是否为目标医院(人工/语音/短信/微信 按 发送完成/最终完成 分级展示)
      // 是否为目标医院(人工/语音/短信/微信 按 发送数/成功数 分级展示)
      const graded = this.isTargetHospital;
      const baseHeaders = [
@@ -1846,15 +2113,25 @@
        "无需随访人次",
        "应随访人次",
      ];
      const coreHeaders = [
        "需随访",
        "待随访",
        "随访成功",
        "随访失败",
        "成功率",
        "随访率",
        "及时率",
      ];
      const coreHeaders = this.isTargetHospital
        ? [
            "需随访",
            "待发送",
            "已发送",
            "随访成功",
            "成功率",
            "随访率",
            "及时率",
          ]
        : [
            "需随访",
            "待随访",
            "随访成功",
            "随访失败",
            "成功率",
            "随访率",
            "及时率",
          ];
      const methodGroups = this.getMethodColumns();
      const baseCount = baseHeaders.length; // 6
@@ -1890,14 +2167,37 @@
        worksheet.getCell(2, coreStartCol).value = serviceTypeName;
        worksheet.getCell(2, coreStartCol).style = headerStyle;
        // 第3行:随访核心列纵向合并 + 随访方式分组横向合并
        for (let k = 0; k < coreCount; k++) {
          const col = coreStartCol + k;
        // 第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);
          const cell = worksheet.getCell(3, col);
          cell.value = coreHeaders[k];
          cell.style = headerStyle;
        }
          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) {
@@ -1909,7 +2209,7 @@
          mc += g.fields.length;
        });
        // 第4行:随访方式子列(发送完成/最终完成)
        // 第4行:随访方式子列(发送数/成功数)
        mc = methodStartCol;
        methodGroups.forEach((g) => {
          g.fields.forEach((field, idx) => {
@@ -1966,9 +2266,13 @@
          item.nonFollowUp || 0,
          item.followUpNeeded || 0,
          item.needFollowUp || 0,
          item.pendingFollowUp || 0,
          // 待随访:目标医院拆为待发送/已发送,其他用待随访
          ...(this.isTargetHospital
            ? [item.pendingFollowUpWaitSend || 0, item.pendingFollowUpSent || 0]
            : [item.pendingFollowUp || 0]),
          item.followUpSuccess || 0,
          item.followUpFail || 0,
          // 随访失败:目标医院不显示
          ...(this.isTargetHospital ? [] : [item.followUpFail || 0]),
          // 成功率 - 需要动态计算
          this.calculateSuccessRate(
            item.followUpSuccess,
@@ -1976,7 +2280,7 @@
            item.pendingFollowUp
          ),
          item.followUpRate || "0%", // 随访率
          item.rate ? (Number(item.rate) * 100).toFixed(2) + "%" : "0%", // 及时率
          this.getTimelyRateText(item), // 及时率
        ];
        methodGroups.forEach((g) => {
          g.fields.forEach((field) => {
@@ -2010,13 +2314,29 @@
      worksheet.columns = widths.map((width) => ({ width }));
    },
    getMethodColumns() {
      // 随访方式列配置:目标医院按“发送完成/最终完成”分级展示
      // 随访方式列配置:目标医院按“发送数/成功数”分级展示
      if (this.isTargetHospital) {
        return [
          { label: "人工", fields: ["manual", "manualSuccess"], sub: ["发送完成", "最终完成"] },
          { label: "语音", fields: ["voice", "voiceSuccess"], sub: ["发送完成", "最终完成"] },
          { label: "短信", fields: ["sms", "smsSuccess"], sub: ["发送完成", "最终完成"] },
          { label: "微信", fields: ["weChat", "weChatSuccess"], sub: ["发送完成", "最终完成"] },
          {
            label: "人工",
            fields: ["manual", "manualSuccess"],
            sub: ["发送数", "成功数"],
          },
          {
            label: "语音",
            fields: ["voice", "voiceSuccess"],
            sub: ["发送数", "成功数"],
          },
          {
            label: "短信",
            fields: ["sms", "smsSuccess"],
            sub: ["发送数", "成功数"],
          },
          {
            label: "微信",
            fields: ["weChat", "weChatSuccess"],
            sub: ["发送数", "成功数"],
          },
        ];
      }
      return [
@@ -2036,9 +2356,9 @@
        0, // 4: nonFollowUp
        0, // 5: followUpNeeded
        0, // 6: needFollowUp
        0, // 7: pendingFollowUp
        0, // 8: followUpSuccess
        0, // 9: followUpFail
        0, // 7: 待发送/待随访
        0, // 8: 已发送/随访成功
        0, // 9: 随访成功/随访失败
        "0%", // 10: 成功率
        "0%", // 11: 随访率
        "0%", // 12: 及时率
@@ -2056,19 +2376,27 @@
        summaries[4] += Number(item.nonFollowUp) || 0;
        summaries[5] += Number(item.followUpNeeded) || 0;
        summaries[6] += Number(item.needFollowUp) || 0;
        summaries[7] += Number(item.pendingFollowUp) || 0;
        summaries[8] += Number(item.followUpSuccess) || 0;
        summaries[9] += Number(item.followUpFail) || 0;
        if (this.isTargetHospital) {
          summaries[7] += Number(item.pendingFollowUpWaitSend) || 0;
          summaries[8] += Number(item.pendingFollowUpSent) || 0;
          summaries[9] += Number(item.followUpSuccess) || 0;
        } else {
          summaries[7] += Number(item.pendingFollowUp) || 0;
          summaries[8] += Number(item.followUpSuccess) || 0;
          summaries[9] += Number(item.followUpFail) || 0;
        }
        methodFields.forEach((field, i) => {
          summaries[methodStartIndex + i] += Number(item[field]) || 0;
        });
      });
      // 成功率计算
      const totalSuccess = summaries[8]; // followUpSuccess的总和
      // 成功率计算:随访成功 / 需随访(目标医院),否则 随访成功 / (需随访-待随访)
      const totalSuccess = this.isTargetHospital ? summaries[9] : summaries[8];
      const totalNeed = summaries[6]; // needFollowUp的总和
      const totalPending = summaries[7]; // pendingFollowUp的总和
      const denominator = totalNeed - totalPending;
      const totalPending = summaries[7]; // 待发送/待随访的总和
      const denominator = this.isTargetHospital
        ? totalNeed
        : totalNeed - totalPending;
      if (denominator > 0) {
        summaries[10] = ((totalSuccess / denominator) * 100).toFixed(2) + "%";
@@ -2088,15 +2416,23 @@
        summaries[11] = (avgFollowUpRate * 100).toFixed(2) + "%";
      }
      // 及时率计算
      const rateValues = this.tableData
        .map((item) => this.extractPercentageValue(item.rate))
        .filter((value) => value !== null);
      // 及时率计算:目标医院 (需随访-人工超时)/需随访,其他取后端 rate 平均
      if (this.isTargetHospital) {
        const totalTimeout = this.tableData.reduce(
          (sum, item) => sum + (Number(item.manualCallTimeout) || 0),
          0
        );
        summaries[12] = this.calculateTimelyRate(totalNeed, totalTimeout);
      } else {
        const rateValues = this.tableData
          .map((item) => this.extractPercentageValue(item.rate))
          .filter((value) => value !== null);
      if (rateValues.length > 0) {
        const avgRate =
          rateValues.reduce((sum, val) => sum + val, 0) / rateValues.length;
        summaries[12] = (avgRate * 100).toFixed(2) + "%";
        if (rateValues.length > 0) {
          const avgRate =
            rateValues.reduce((sum, val) => sum + val, 0) / rateValues.length;
          summaries[12] = (avgRate * 100).toFixed(2) + "%";
        }
      }
      // 格式化数字
@@ -2137,14 +2473,14 @@
      }
      // 出院时间范围
      if (queryParams.hospitalEndTime) {
        this.patientqueryParams.hospitalStartTime =
        this.patientqueryParams.startOutHospTime =
          queryParams.hospitalStartTime;
        this.patientqueryParams.hospitalEndTime = queryParams.hospitalEndTime;
        this.patientqueryParams.endOutHospTime = queryParams.hospitalEndTime;
      } else {
        this.patientqueryParams.hospitalStartTime = this.parseTime(
        this.patientqueryParams.startOutHospTime = this.parseTime(
          queryParams.dateRangecy[0]
        );
        this.patientqueryParams.hospitalEndTime = this.parseTime(
        this.patientqueryParams.endOutHospTime = this.parseTime(
          queryParams.dateRangecy[1]
        );
      }