WXL (wul)
8 天以前 a99e82da2b087d7019cdce015c25befc620b9d61
src/views/Satisfaction/sfstatistics/components/FollowupStatistics.vue
@@ -149,6 +149,8 @@
        style="width: 100%"
        @selection-change="handleSelectionChange"
        :row-key="getRowKey"
        show-summary
        :summary-method="getSummaries"
      >
        <!-- 病区统计:在院病区 + 离院病区 -->
        <el-table-column
@@ -389,6 +391,7 @@
} from "@/api/system/user";
import ExcelJS from "exceljs";
import { saveAs } from "file-saver";
import { getTaskservelist } from "@/api/AiCentre/SingleTask";
import SeedetailsDialog from "./components/SeedetailsDialog.vue";
import TopicDialog from "./components/TopicDialog.vue";
@@ -398,11 +401,18 @@
    SeedetailsDialog,
    TopicDialog,
  },
  props: {
    // 是否在顶部生成患者表单 / 问题详情分析 tab(仅满意度统计主页开启)
    showAnalysisTabs: {
      type: Boolean,
      default: false,
    },
  },
  data() {
    return {
      // 满意度类型:leave=离院满意度(按出院病区统计),hospital=在院满意度(按在院病区统计)
      // 默认在院满意度
      satisfactionScope: "hospital",
      // 默认离院满意度
      satisfactionScope: "leave",
      // 查询参数
      queryParams: {
@@ -432,7 +442,7 @@
      options: [
        {
          value: 6,
          label: "住院满意度",
          label: "出入院满意度",
          raw: {
            cssClass: "",
            listClass: "",
@@ -458,6 +468,10 @@
      // 加载状态
      loading: false,
      orgname: "",
      // 已完成明细请求序号,避免快速切换筛选时旧请求覆盖新结果
      completedRequestSeq: 0,
      // 问题详情请求序号
      questionRequestSeq: 0,
      // 选中的行
      ids: [],
@@ -522,12 +536,21 @@
    isInHospitalSatisfaction() {
      return this.satisfactionScope !== "leave";
    },
    // patItem 接口的 serviceType 只接收单个值,多选时取第一个
    currentServiceType() {
      const value = this.queryParams.serviceType;
      const first = Array.isArray(value) ? value[0] : value;
      return first || 6;
    },
  },
  created() {
    this.orgname = localStorage.getItem("orgname");
    this.initData();
    // 顶部患者表单 / 问题详情分析 tab:默认按当前统计口径加载一次
    this.maybeRefreshCompletedGroups();
    this.maybeRefreshQuestionDetails();
  },
  methods: {
@@ -539,8 +562,12 @@
    // 获取科室树
    getDeptTree() {
      // 获取服务类型
      this.options = this.$store.getters.tasktypes || [];
      // 获取服务类型(字典里的「住院满意度」在本页显示为「出入院满意度」)
      const labelFix = { 住院满意度: "出入院满意度" };
      this.options = (this.$store.getters.tasktypes || []).map((o) =>
        labelFix[o.label] ? { ...o, label: labelFix[o.label] } : o
      );
      console.log(11, this.options);
      // 获取科室列表
      this.flatArraydept = (this.$store.getters.belongDepts || []).map(
@@ -592,41 +619,41 @@
          // 病区统计
          let wardCodes = params.leavehospitaldistrictcodes || [];
          if (wardCodes.includes("all")) {
            // 如果选择了"全部",则使用当前用户所属的全部病区
            wardCodes = (this.$store.getters.belongWards || []).map(
              (ward) => ward.districtCode
            );
            // 选择"全部"时不加病区限制,查全部病区
            wardCodes = [];
          }
          delete params.leavehospitaldistrictcodes;
          delete params.hospitaldistrictcodes;
          delete params.deptcodes;
          delete params.leaveldeptcodes;
          delete params.hospitaldeptcodes;
          if (this.isInHospitalSatisfaction) {
            params.hospitaldistrictcodes = wardCodes;
          } else {
            params.leavehospitaldistrictcodes = wardCodes;
          if (wardCodes.length) {
            if (this.isInHospitalSatisfaction) {
              params.hospitaldistrictcodes = wardCodes;
            } else {
              params.leavehospitaldistrictcodes = wardCodes;
            }
          }
        } else if (params.statisticaltype == 2) {
          // 科室统计
          let deptCodes = params.deptcodes || [];
          if (deptCodes.includes("all")) {
            // 如果选择了"全部",则移除"all"值
            // 选择"全部"时不加科室限制,查全部科室
            deptCodes = [];
          } else {
            deptCodes = deptCodes.filter((item) => item !== "all");
            // 如果需要传所有科室代码,可以从store中获取
            deptCodes = (this.$store.getters.belongDepts || []).map(
              (dept) => dept.deptCode
            );
          }
          delete params.deptcodes;
          delete params.leaveldeptcodes;
          delete params.hospitaldeptcodes;
          delete params.leavehospitaldistrictcodes;
          delete params.hospitaldistrictcodes;
          if (this.isInHospitalSatisfaction) {
            params.hospitaldeptcodes = deptCodes;
          } else {
            params.leaveldeptcodes = deptCodes;
          if (deptCodes.length) {
            if (this.isInHospitalSatisfaction) {
              params.hospitaldeptcodes = deptCodes;
            } else {
              params.leaveldeptcodes = deptCodes;
            }
          }
        }
@@ -645,7 +672,10 @@
      }
    },
    sortChineseNumber(aRow, bRow) {
      return this.compareWardNames(this.getWardName(aRow), this.getWardName(bRow));
      return this.compareWardNames(
        this.getWardName(aRow),
        this.getWardName(bRow)
      );
    },
    sortHospitalWard(aRow, bRow) {
      return this.compareWardNames(
@@ -840,23 +870,368 @@
      }
      this.queryParams.pageNum = 1;
      this.getList();
      this.maybeRefreshCompletedGroups();
      this.maybeRefreshQuestionDetails();
    },
    // 处理查询
    handleQuery() {
      this.queryParams.pageNum = 1;
      this.getList();
      this.maybeRefreshCompletedGroups();
      this.maybeRefreshQuestionDetails();
    },
    // 切换满意度类型(离院/在院)后重新查询
    handleSatisfactionScopeChange() {
      this.queryParams.pageNum = 1;
      this.getList();
      this.maybeRefreshCompletedGroups();
      this.maybeRefreshQuestionDetails();
    },
    // 重置查询(恢复默认:在院满意度 + 服务类型 6)
    /**
     * 顶部「已完成患者明细」tab 数据
     * 维度沿用下方「统计类型」:病区统计 -> 按病区分组;科室统计 -> 按科室分组
     * 时间沿用下方「随访时间」,状态固定为已完成
     */
    maybeRefreshCompletedGroups() {
      if (this.showAnalysisTabs) {
        this.refreshCompletedGroups();
      }
    },
    async refreshCompletedGroups() {
      const seq = ++this.completedRequestSeq;
      const payload = this.buildCompletedPayload();
      // 没有科室/病区权限时不发起请求,避免把全量数据查出来
      if (!payload) {
        this.emitCompletedGroups([], seq);
        return;
      }
      this.$emit("completed-rows-change", {
        ...this.buildCompletedMeta(),
        loading: true,
      });
      try {
        const res = await getTaskservelist(payload);
        if (seq !== this.completedRequestSeq) return;
        const rows = this.pickCompletedRows(res);
        this.emitCompletedGroups(rows, seq);
      } catch (error) {
        if (seq !== this.completedRequestSeq) return;
        console.error("获取已完成患者明细失败:", error);
        this.emitCompletedGroups([], seq);
      }
    },
    // 组装第一张「满意度状态查询」页同款查询条件
    buildCompletedPayload() {
      const scope = this.buildCompletedScope();
      if (!scope.all && !scope.depts.length && !scope.wards.length) {
        return null;
      }
      const payload = {
        pageNum: null,
        pageSize: null,
        sendstate: null,
        sendstateView: 2, // 2 = 已完成
        sort: 2,
        serviceType: this.currentServiceType,
        searchscope: scope.searchscope,
        visitCount: 1,
        scopetype: [],
        // 与第一张图一致:选了具体科室/病区时只传对应维度;「全部」时两个维度都传
        deptOrDistrict: scope.deptOrDistrict,
      };
      // 在院满意度用 hospital*,离院满意度用 leave*
      if (this.satisfactionScope === "hospital") {
        if (scope.depts.length) {
          payload.deptcodes = scope.depts;
        }
        if (scope.wards.length) {
          payload.hospitaldistrictcodes = scope.wards;
        }
      } else {
        if (scope.depts.length) {
          payload.leaveldeptcodes = scope.depts;
        }
        if (scope.wards.length) {
          payload.leavehospitaldistrictcodes = scope.wards;
        }
      }
      const range = this.queryParams.dateRange || [];
      if (range.length === 2 && range[0] && range[1]) {
        payload.finishtimeStart = range[0];
        payload.finishtimeEnd = range[1];
      }
      return payload;
    },
    // 组装查询范围:统计类型决定按病区还是科室过滤
    buildCompletedScope() {
      const allDepts = (this.$store.getters.belongDepts || [])
        .map((dept) => dept.deptCode)
        .filter(Boolean);
      const allWards = (this.$store.getters.belongWards || [])
        .map((ward) => ward.districtCode)
        .filter(Boolean);
      // 病区统计(含统计类型为空的情况)
      if (this.queryParams.statisticaltype != 2) {
        const rawSelected = this.queryParams.leavehospitaldistrictcodes || [];
        const selected = rawSelected.filter((code) => code && code !== "all");
        const useAll = !rawSelected.length || rawSelected.includes("all");
        if (!useAll && selected.length) {
          return {
            depts: [],
            wards: selected,
            deptOrDistrict: 1,
            searchscope: 2,
          };
        }
        // 全部:不传病区/科室编码,由后端返回当前机构全部数据
        return {
          depts: [],
          wards: [],
          deptOrDistrict: 2,
          searchscope: 3,
          all: true,
        };
      }
      // 科室统计
      const rawSelected = this.queryParams.deptcodes || [];
      const selected = rawSelected.filter((code) => code && code !== "all");
      const useAll = !rawSelected.length || rawSelected.includes("all");
      if (!useAll && selected.length) {
        return {
          depts: selected,
          wards: [],
          deptOrDistrict: 1,
          searchscope: 1,
        };
      }
      return {
        depts: [],
        wards: [],
        deptOrDistrict: 2,
        searchscope: 3,
        all: true,
      };
    },
    // 问题详情占比 / 图表 / 饼图 共用数据
    maybeRefreshQuestionDetails() {
      if (this.showAnalysisTabs) {
        this.refreshQuestionDetails();
      }
    },
    async refreshQuestionDetails() {
      const seq = ++this.questionRequestSeq;
      const payload = this.buildQuestionPayload();
      if (!payload) {
        this.$emit("question-details-change", { loading: false, list: [] });
        return;
      }
      this.$emit("question-details-change", { loading: true });
      try {
        const res = await getSfStatisticsJoyInfo(payload);
        if (seq !== this.questionRequestSeq) return;
        this.$emit("question-details-change", {
          loading: false,
          list: res.data || [],
        });
      } catch (error) {
        if (seq !== this.questionRequestSeq) return;
        console.error("获取问题详情占比失败:", error);
        this.$emit("question-details-change", { loading: false, list: [] });
      }
    },
    buildQuestionPayload() {
      const scope = this.buildCompletedScope();
      if (!scope.all && !scope.depts.length && !scope.wards.length) {
        return null;
      }
      const params = {
        configKey: "joyCount",
        statisticaltype: this.queryParams.statisticaltype,
        serviceType: this.queryParams.serviceType,
        searchscope: scope.searchscope,
        pageNum: 1,
        pageSize: 999,
      };
      const range = this.queryParams.dateRange || [];
      if (range.length === 2 && range[0] && range[1]) {
        params.startTime = range[0];
        params.endTime = range[1];
      }
      if (this.queryParams.statisticaltype == 2) {
        if (scope.depts.length) {
          if (this.isInHospitalSatisfaction) {
            params.hospitaldeptcodes = scope.depts;
          } else {
            params.leaveldeptcodes = scope.depts;
          }
        }
      } else if (scope.wards.length) {
        if (this.isInHospitalSatisfaction) {
          params.hospitaldistrictcodes = scope.wards;
        } else {
          params.leavehospitaldistrictcodes = scope.wards;
        }
      }
      return params;
    },
    // 兼容接口不同的返回层级
    pickCompletedRows(res) {
      if (!res) return [];
      const rowsWrap = res.rows || (res.data && res.data.rows);
      let list = [];
      if (Array.isArray(rowsWrap) && rowsWrap[0]) {
        list =
          rowsWrap[0].serviceSubtaskList ||
          (rowsWrap[0].sendname ? rowsWrap : []);
      } else if (res.data && Array.isArray(res.data.serviceSubtaskList)) {
        list = res.data.serviceSubtaskList;
      } else if (Array.isArray(res.data)) {
        list = res.data;
      }
      return (list || [])
        .filter(Boolean)
        .map((row) => this.normalizeCompletedRow(row));
    },
    normalizeCompletedRow(row) {
      const item = { ...row };
      if (item.endtime) {
        item.endDay = this.daysBetween(item.endtime);
      }
      return item;
    },
    emitCompletedGroups(rows, seq) {
      if (seq !== this.completedRequestSeq) return;
      this.$emit("completed-rows-change", {
        ...this.buildCompletedMeta(),
        loading: false,
        total: rows.length,
        rows,
      });
    },
    buildCompletedMeta() {
      return {
        dimension: this.queryParams.statisticaltype == 2 ? "dept" : "ward",
        scope: this.satisfactionScope,
        dateRange: [...(this.queryParams.dateRange || [])],
      };
    },
    // 按当前统计类型分组:病区统计 -> 病区,科室统计 -> 科室
    groupCompletedRows(rows) {
      const dimension = this.queryParams.statisticaltype == 2 ? "dept" : "ward";
      const groupMap = new Map();
      (rows || []).forEach((row) => {
        const name =
          dimension === "ward" ? this.wardNameOf(row) : this.deptNameOf(row);
        const code =
          dimension === "ward" ? this.wardCodeOf(row) : this.deptCodeOf(row);
        const key = String(code || name || "unknown");
        if (!groupMap.has(key)) {
          groupMap.set(key, {
            key,
            label: name || (dimension === "ward" ? "未分病区" : "未分科室"),
            rows: [],
          });
        }
        groupMap.get(key).rows.push(row);
      });
      const orderMap = this.buildGroupOrder(dimension);
      return Array.from(groupMap.values()).sort((a, b) => {
        const aIndex = orderMap.has(a.key) ? orderMap.get(a.key) : 99999;
        const bIndex = orderMap.has(b.key) ? orderMap.get(b.key) : 99999;
        if (aIndex !== bIndex) return aIndex - bIndex;
        return a.label.localeCompare(b.label, "zh-Hans-CN");
      });
    },
    // tab 顺序按页面左侧科室/病区权限列表的顺序,保证「一病区、二病区…」的自然顺序
    buildGroupOrder(dimension) {
      const list =
        dimension === "ward"
          ? this.$store.getters.belongWards
          : this.$store.getters.belongDepts;
      const orderMap = new Map();
      (list || []).forEach((item, index) => {
        const code = dimension === "ward" ? item.districtCode : item.deptCode;
        if (code) orderMap.set(String(code), index);
      });
      return orderMap;
    },
    wardNameOf(row) {
      if (!row) return "";
      const name =
        this.satisfactionScope === "hospital"
          ? row.hospitaldistrictname || row.leavehospitaldistrictname
          : row.leavehospitaldistrictname || row.hospitaldistrictname;
      return name === "-" ? "" : name;
    },
    wardCodeOf(row) {
      if (!row) return "";
      return this.satisfactionScope === "hospital"
        ? row.hospitaldistrictcode || row.leavehospitaldistrictcode
        : row.leavehospitaldistrictcode || row.hospitaldistrictcode;
    },
    deptNameOf(row) {
      if (!row) return "";
      const name =
        this.satisfactionScope === "hospital"
          ? row.deptname || row.leaveldeptname
          : row.leaveldeptname || row.deptname;
      return name === "-" ? "" : name;
    },
    deptCodeOf(row) {
      if (!row) return "";
      return this.satisfactionScope === "hospital"
        ? row.hospitaldeptcode || row.deptcode
        : row.deptcode || row.hospitaldeptcode;
    },
    // 重置查询(恢复默认:离院满意度 + 服务类型 6)
    resetQuery() {
      this.satisfactionScope = "hospital";
      this.satisfactionScope = "leave";
      this.queryParams = {
        statisticaltype: 1,
        leavehospitaldistrictcodes: [],
@@ -867,6 +1242,8 @@
        pageSize: 20,
      };
      this.getList();
      this.maybeRefreshCompletedGroups();
      this.maybeRefreshQuestionDetails();
    },
    // 处理分页大小变化
@@ -910,6 +1287,92 @@
      const num = parseFloat(value);
      if (isNaN(num)) return "-";
      return `${(num * 100).toFixed(2)}%`;
    },
    // 表格合计行
    getSummaries(param) {
      const { columns, data } = param;
      const sums = [];
      columns.forEach((column, index) => {
        if (index === 0) {
          sums[index] = "合计";
          return;
        }
        const prop = column.property;
        // 数值列求和
        if (
          [
            "dischargeCount",
            "nonFollowUp",
            "followUpNeeded",
            "joyAllCount",
            "joyCount",
          ].includes(prop)
        ) {
          sums[index] = data.reduce(
            (sum, item) => sum + (Number(item[prop]) || 0),
            0
          );
          return;
        }
        // 完成比率:满意度填报量 / 满意度题目总量
        if (prop === "joyTotal") {
          const totalJoyAllCount = data.reduce(
            (sum, item) => sum + (Number(item.joyAllCount) || 0),
            0
          );
          const totalJoyCount = data.reduce(
            (sum, item) => sum + (Number(item.joyCount) || 0),
            0
          );
          sums[index] =
            totalJoyAllCount > 0
              ? ((totalJoyCount / totalJoyAllCount) * 100).toFixed(2) + "%"
              : "0.00%";
          return;
        }
        // 百分比列(随访率/及时率):取平均值(0 值也参与平均)
        if (prop === "followUpRate" || prop === "rate") {
          const percentageValues = data
            .map((item) => {
              const value = item[prop];
              if (
                value === null ||
                value === undefined ||
                value === "" ||
                value === "-"
              ) {
                return null;
              }
              if (typeof value === "string" && value.includes("%")) {
                const num = parseFloat(value.replace("%", "")) / 100;
                return isNaN(num) ? null : num;
              }
              const num = parseFloat(value);
              return isNaN(num) ? null : num;
            })
            .filter((value) => value !== null);
          sums[index] =
            percentageValues.length > 0
              ? (
                  (percentageValues.reduce((sum, value) => sum + value, 0) /
                    percentageValues.length) *
                  100
                ).toFixed(2) + "%"
              : "0.00%";
          return;
        }
        sums[index] = "";
      });
      return sums;
    },
    // 查看未及时随访详情
@@ -974,6 +1437,113 @@
        console.error("获取满意度详情失败:", error);
        this.$message.error("获取详情失败");
      }
    },
    // 获取指定病区/科室的题目详情
    async fetchTopicDetail(row) {
      const params = {
        configKey: "joyCount",
        ...this.queryParams,
      };
      // 导出需要该病区/科室的全部题目,覆盖主表分页参数
      params.pageNum = 1;
      params.pageSize = 1000;
      if (
        this.queryParams.dateRange &&
        this.queryParams.dateRange.length === 2
      ) {
        params.startTime = this.queryParams.dateRange[0];
        params.endTime = this.queryParams.dateRange[1];
      }
      if (this.queryParams.statisticaltype == 1) {
        params.leavehospitaldistrictcodes = [row.leavehospitaldistrictcode];
      } else {
        params.deptcodes = [row.deptcode];
      }
      const response = await getSfStatisticsJoyInfo(params);
      return response.data || {};
    },
    // 主表导出行数据
    getMainExportRow(item) {
      return [
        this.queryParams.statisticaltype == 1
          ? item.leavehospitaldistrictname
          : item.deptname,
        item.dischargeCount || 0,
        item.nonFollowUp || 0,
        item.followUpNeeded || 0,
        item.followUpRate || "0%",
        item.rate ? this.formatPercent(item.rate) : "0%",
        item.joyAllCount || 0,
        item.joyCount || 0,
        item.joyTotal ? this.formatPercent(item.joyTotal) : "0%",
      ];
    },
    // 计算文本显示宽度(中文按 2、英文/数字按 1)
    textWidth(str) {
      if (!str) return 0;
      let width = 0;
      for (const ch of String(str)) {
        width += ch.charCodeAt(0) > 255 ? 2 : 1;
      }
      return width;
    },
    // 丽水市中医院:拉取所有科室题目明细,扁平化为「题目选项」列结构
    async buildLishuiTopicColumns() {
      const topicMap = new Map();
      const rowQuantities = [];
      for (const item of this.userList) {
        const topiclist = await this.fetchTopicDetail(item);
        const qMap = new Map();
        if (topiclist && Object.keys(topiclist).length) {
          Object.keys(topiclist).forEach((key) => {
            const topic = topiclist[key];
            if (!topic || !topic.scriptContent) return;
            const tKey =
              topic.scriptid != null && topic.scriptid !== ""
                ? String(topic.scriptid)
                : topic.scriptContent;
            if (!topicMap.has(tKey)) {
              topicMap.set(tKey, {
                key: tKey,
                scriptContent: topic.scriptContent,
                options: [],
                optionSet: new Set(),
              });
            }
            const t = topicMap.get(tKey);
            const topicQ = new Map();
            (topic.details || []).forEach((detail) => {
              if (!detail || !detail.optionText) return;
              if (!t.optionSet.has(detail.optionText)) {
                t.optionSet.add(detail.optionText);
                t.options.push(detail.optionText);
              }
              topicQ.set(detail.optionText, Number(detail.chosenQuantity) || 0);
            });
            qMap.set(tKey, topicQ);
          });
        }
        rowQuantities.push(qMap);
      }
      const topics = Array.from(topicMap.values());
      // 没有选项的题目默认填充一个空选项列,避免表头/数据错位
      topics.forEach((t) => {
        if (!t.options.length) {
          t.options = [""];
        }
      });
      return { topics, rowQuantities };
    },
    // 导出数据
@@ -1067,7 +1637,11 @@
            pattern: "solid",
            fgColor: { argb: "FFF5F7FA" },
          },
          alignment: { vertical: "middle", horizontal: "center" },
          alignment: {
            vertical: "middle",
            horizontal: "center",
            wrapText: true,
          },
          border: {
            top: { style: "thin", color: { argb: "FFD0D0D0" } },
            left: { style: "thin", color: { argb: "FFD0D0D0" } },
@@ -1087,18 +1661,18 @@
          },
        };
        // 添加总标题(两列维度 + 八个指标列,共 10 列)
        worksheet.mergeCells(1, 1, 1, 10);
        const titleCell = worksheet.getCell(1, 1);
        titleCell.value = `满意度随访统计表(${sheetNameSuffix})`;
        titleCell.style = titleStyle;
        worksheet.getRow(1).height = 35;
        // 丽水市中医院:预先拉取题目明细,扁平化为「题目选项」列
        let lishuiTopics = [];
        let lishuiRowQuantities = [];
        if (isLishuiHospital) {
          const built = await this.buildLishuiTopicColumns();
          lishuiTopics = built.topics;
          lishuiRowQuantities = built.rowQuantities;
        }
        // 添加表头(科室统计导出在院科室+离院科室,病区统计导出在院病区+离院病区)
        const isWardStatistics = this.queryParams.statisticaltype == 1;
        const headers = [
          isWardStatistics ? "在院病区" : "在院科室",
          isWardStatistics ? "离院病区" : "离院科室",
        // 主表列
        const mainHeaders = [
          this.queryParams.statisticaltype == 1 ? "出院病区" : "科室",
          "出院人次",
          "无需随访人次",
          "应随访人次",
@@ -1108,51 +1682,161 @@
          "满意度填报量",
          "完成比率",
        ];
        const mainColumnCount = mainHeaders.length;
        const headerRow = worksheet.addRow(headers);
        headerRow.eachCell((cell) => {
          cell.style = headerStyle;
        });
        headerRow.height = 25;
        // 总列数(丽水市中医院在末尾追加题目选项列)
        const topicColumnCount = lishuiTopics.reduce(
          (sum, t) => sum + (t.options.length || 1),
          0
        );
        const totalColumns = mainColumnCount + topicColumnCount;
        // 添加数据行
        this.userList.forEach((item) => {
          const dataRow = worksheet.addRow([
            isWardStatistics
              ? item.hospitaldistrictname || "-"
              : item.hospitaldeptname || "-",
            isWardStatistics
              ? item.leavehospitaldistrictname || "-"
              : item.deptname || "-",
            item.dischargeCount || 0,
            item.nonFollowUp || 0,
            item.followUpNeeded || 0,
            item.followUpRate || "0%",
            item.rate ? this.formatPercent(item.rate) : "0%",
            item.joyAllCount || 0,
            item.joyCount || 0,
            item.joyTotal ? this.formatPercent(item.joyTotal) : "0%",
          ]);
        // 添加总标题
        worksheet.mergeCells(1, 1, 1, totalColumns);
        const titleCell = worksheet.getCell(1, 1);
        titleCell.value = `满意度随访统计表(${sheetNameSuffix})`;
        titleCell.style = titleStyle;
        worksheet.getRow(1).height = 35;
          dataRow.eachCell((cell) => {
            cell.style = cellStyle;
        if (isLishuiHospital && lishuiTopics.length) {
          // 计算每个题目的选项列宽(选项文字自适应,题干过长时摊宽列、必要时换行)
          const topicColumns = lishuiTopics.map((topic) => {
            const n = topic.options.length || 1;
            const baseWidths = topic.options.map((opt) =>
              opt === "" ? 10 : Math.max(10, this.textWidth(opt) + 4)
            );
            const sumWidth = baseWidths.reduce((s, w) => s + w, 0);
            const topicWidth = this.textWidth(topic.scriptContent) + 4;
            const groupWidth = Math.max(sumWidth, topicWidth);
            const extra = (groupWidth - sumWidth) / n;
            const widths = baseWidths.map((w) => w + extra);
            const lines = Math.max(1, Math.ceil(topicWidth / groupWidth));
            return { widths, lines };
          });
          dataRow.height = 22;
        });
          const maxHeaderLines = topicColumns.reduce(
            (m, t) => Math.max(m, t.lines),
            1
          );
        // 设置列宽
        worksheet.columns = [
          { width: 20 },
          { width: 20 },
          { width: 12 },
          { width: 12 },
          { width: 12 },
          { width: 12 },
          { width: 12 },
          { width: 15 },
          { width: 15 },
          { width: 12 },
        ];
          // 两行表头:第一行 = 主表列 + 题目名;第二行 = 选项名
          const headerRow1 = worksheet.addRow([]);
          const headerRow2 = worksheet.addRow([]);
          mainHeaders.forEach((h, i) => {
            const col = i + 1;
            headerRow1.getCell(col).value = h;
            headerRow1.getCell(col).style = headerStyle;
            headerRow2.getCell(col).style = headerStyle;
            worksheet.mergeCells(
              headerRow1.number,
              col,
              headerRow2.number,
              col
            );
          });
          let colIndex = mainColumnCount + 1;
          lishuiTopics.forEach((topic) => {
            const optCount = topic.options.length || 1;
            for (let k = 0; k < optCount; k++) {
              headerRow1.getCell(colIndex + k).style = headerStyle;
            }
            headerRow1.getCell(colIndex).value = topic.scriptContent;
            if (optCount > 1) {
              worksheet.mergeCells(
                headerRow1.number,
                colIndex,
                headerRow1.number,
                colIndex + optCount - 1
              );
            }
            topic.options.forEach((opt, k) => {
              headerRow2.getCell(colIndex + k).value = opt;
              headerRow2.getCell(colIndex + k).style = headerStyle;
            });
            colIndex += optCount;
          });
          // 表头高度:题干换行时按最长题目预留
          headerRow1.height = Math.max(30, 15 * maxHeaderLines + 8);
          headerRow2.height = 25;
          // 数据行
          this.userList.forEach((item, idx) => {
            const row = worksheet.addRow([]);
            const main = this.getMainExportRow(item);
            main.forEach((v, i) => {
              const cell = row.getCell(i + 1);
              cell.value = v;
              cell.style = cellStyle;
            });
            const qMap = lishuiRowQuantities[idx] || new Map();
            let cIndex = mainColumnCount + 1;
            for (const topic of lishuiTopics) {
              const topicQ = qMap.get(topic.key);
              topic.options.forEach((opt) => {
                const cell = row.getCell(cIndex);
                if (opt === "") {
                  // 空选项占位列不填数字
                  cell.value = "";
                } else {
                  const val = topicQ ? topicQ.get(opt) : undefined;
                  cell.value = val === undefined || val === null ? 0 : val;
                }
                cell.style = cellStyle;
                cIndex++;
              });
            }
            row.height = 22;
          });
          // 列宽:主表列 + 题目选项列
          const columns = [
            { width: 20 },
            { width: 12 },
            { width: 12 },
            { width: 12 },
            { width: 12 },
            { width: 12 },
            { width: 15 },
            { width: 15 },
            { width: 12 },
          ];
          lishuiTopics.forEach((topic, ti) => {
            topicColumns[ti].widths.forEach((w) => {
              columns.push({ width: w });
            });
          });
          worksheet.columns = columns;
        } else {
          // 其他医院:单行表头
          const headerRow = worksheet.addRow(mainHeaders);
          headerRow.eachCell((cell) => {
            cell.style = headerStyle;
          });
          headerRow.height = 25;
          this.userList.forEach((item) => {
            const dataRow = worksheet.addRow(this.getMainExportRow(item));
            dataRow.eachCell((cell) => {
              cell.style = cellStyle;
            });
            dataRow.height = 22;
          });
          worksheet.columns = [
            { width: 20 },
            { width: 12 },
            { width: 12 },
            { width: 12 },
            { width: 12 },
            { width: 12 },
            { width: 15 },
            { width: 15 },
            { width: 12 },
          ];
        }
        // 生成并下载文件
        const buffer = await workbook.xlsx.writeBuffer();