测试完成

WXL (wul)

5 天以前 ba1ad6cff887cecb836a9fff87d84c146c820ad7

 src/views/sfstatistics/percentage/satisfaction.vue

@@ -531,11 +531,13 @@
                <el-table-column prop="chosenQuantity" label="选择人数">
                </el-table-column>
                <el-table-column prop="chosenPercentage" label="比例">
                   <template slot-scope="scope">
                  <span class="button-zx"
                    >{{ (Number(scope.row.chosenPercentage) * 100).toFixed(2) }}%</span
                  >
                </template>
                  <template slot-scope="scope">
                    <span class="button-zx"
                      >{{
                        (Number(scope.row.chosenPercentage) * 100).toFixed(2)
                      }}%</span
                    >
                  </template>
                </el-table-column>
              </el-table>
            </div>
@@ -562,7 +564,8 @@
  getSfStatisticsJoyInfo,
  selectTimelyRate,
} from "@/api/system/user";

import ExcelJS from "exceljs";
import { saveAs } from "file-saver";
import Treeselect from "@riophae/vue-treeselect";
import "@riophae/vue-treeselect/dist/vue-treeselect.css";
const shortcuts = [
@@ -730,7 +733,6 @@
      },
      // 查询标签列表参数
      queryParams: {

        serviceType: [2],
        dateRange: [],
        statisticaltype: 1,
@@ -1037,14 +1039,191 @@
        .catch(() => {});
    },
    /** 导出按钮操作 */
    handleExport() {
      this.download(
        "smartor/serviceSubtask/getSfStatisticsExport",
        {
          ...this.queryParams,
        },
        `user_${new Date().getTime()}.xlsx`
      );
    /** 导出按钮操作 */
    async handleExport() {
      try {
        // 获取并格式化日期范围
        let dateRangeString = "";
        let sheetNameSuffix = "";

        // 检查是否存在选中的日期范围
        if (
          this.queryParams.dateRange &&
          this.queryParams.dateRange.length === 2
        ) {
          const startDateStr = this.queryParams.dateRange[0]; // 开始日期，格式 "yyyy-MM-dd"
          const endDateStr = this.queryParams.dateRange[1]; // 结束日期

          // 直接使用日期部分（已经是 yyyy-MM-dd 格式）
          const startDateFormatted = startDateStr;
          const endDateFormatted = endDateStr;

          // 构建日期范围字符串
          dateRangeString = `${startDateFormatted}至${endDateFormatted}`;
          sheetNameSuffix = `${startDateFormatted}至${endDateFormatted}`;
        } else {
          // 如果没有选择日期范围，则使用当前月份作为备选方案
          const now = new Date();
          const currentMonth = now.getMonth() + 1;
          dateRangeString = `${currentMonth}月`;
          sheetNameSuffix = `${currentMonth}月`;
        }

        // 构建文件名和工作表名
        const excelName = `满意度统计表_${dateRangeString}.xlsx`;
        const worksheetName = `满意度统计_${sheetNameSuffix}`;

        // 创建工作簿和工作表
        const workbook = new ExcelJS.Workbook();
        const worksheet = workbook.addWorksheet(worksheetName);

        // 定义样式
        const titleStyle = {
          font: {
            name: "微软雅黑",
            size: 16,
            bold: true,
            color: { argb: "FF000000" },
          },
          fill: {
            type: "pattern",
            pattern: "solid",
            fgColor: { argb: "FFE6F3FF" },
          },
          alignment: {
            vertical: "middle",
            horizontal: "center",
            wrapText: true,
          },
          border: {
            top: { style: "thin", color: { argb: "FFD0D0D0" } },
            left: { style: "thin", color: { argb: "FFD0D0D0" } },
            bottom: { style: "thin", color: { argb: "FFD0D0D0" } },
            right: { style: "thin", color: { argb: "FFD0D0D0" } },
          },
        };

        const headerStyle = {
          font: {
            name: "微软雅黑",
            size: 11,
            bold: true,
            color: { argb: "FF000000" },
          },
          fill: {
            type: "pattern",
            pattern: "solid",
            fgColor: { argb: "FFF5F7FA" },
          },
          alignment: {
            vertical: "middle",
            horizontal: "center",
            wrapText: true,
          },
          border: {
            top: { style: "thin", color: { argb: "FFD0D0D0" } },
            left: { style: "thin", color: { argb: "FFD0D0D0" } },
            bottom: { style: "thin", color: { argb: "FFD0D0D0" } },
            right: { style: "thin", color: { argb: "FFD0D0D0" } },
          },
        };

        const cellStyle = {
          font: {
            name: "宋体",
            size: 10,
            color: { argb: "FF000000" },
          },
          alignment: {
            vertical: "middle",
            horizontal: "center",
          },
          border: {
            top: { style: "thin", color: { argb: "FFD0D0D0" } },
            left: { style: "thin", color: { argb: "FFD0D0D0" } },
            bottom: { style: "thin", color: { argb: "FFD0D0D0" } },
            right: { style: "thin", color: { argb: "FFD0D0D0" } },
          },
        };

        // 添加总标题
        worksheet.mergeCells(1, 1, 1, 10);
        const titleCell = worksheet.getCell(1, 1);
        titleCell.value = `满意度统计表（${sheetNameSuffix}）`;
        titleCell.style = titleStyle;
        worksheet.getRow(1).height = 35;

        // 添加表头
        const headers = [
          "出院病区",
          "科室",
          "出院人次",
          "无需随访人次",
          "应随访人次",
          "随访率",
          "及时率",
          "满意度题目总量",
          "满意度填报量",
          "完成比率",
        ];

        const headerRow = worksheet.addRow(headers);
        headerRow.eachCell((cell) => {
          cell.style = headerStyle;
        });
        headerRow.height = 25;

        // 添加数据行
        this.userList.forEach((item) => {
          const dataRow = worksheet.addRow([
            item.leavehospitaldistrictname || "",
            item.deptname || "",
            item.dischargeCount || 0,
            item.nonFollowUp || 0,
            item.followUpNeeded || 0,
            item.followUpRate || "0%",
            item.rate ? (Number(item.rate) * 100).toFixed(2) + "%" : "0%",
            item.joyAllCount || 0,
            item.joyCount || 0,
            item.joyTotal
              ? (Number(item.joyTotal) * 100).toFixed(2) + "%"
              : "0%",
          ]);

          dataRow.eachCell((cell) => {
            cell.style = cellStyle;
          });
          dataRow.height = 22;
        });

        // 设置列宽
        worksheet.columns = [
          { width: 20 }, // 出院病区
          { width: 15 }, // 科室
          { width: 12 }, // 出院人次
          { width: 12 }, // 无需随访人次
          { width: 12 }, // 应随访人次
          { width: 12 }, // 随访率
          { width: 12 }, // 及时率
          { width: 15 }, // 满意度题目总量
          { width: 15 }, // 满意度填报量
          { width: 12 }, // 完成比率
        ];

        // 生成并下载文件
        const buffer = await workbook.xlsx.writeBuffer();
        const blob = new Blob([buffer], {
          type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
        });

        // 使用FileSaver.js保存文件[2,3](@ref)
        saveAs(blob, excelName);

        this.$message.success("导出成功");
      } catch (error) {
        console.error("导出失败:", error);
        this.$message.error(`导出失败: ${error.message}`);
      }
    },
    // 显示图表弹窗

@@ -1460,7 +1639,8 @@
  }
}
.topicdia {
  font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, sans-serif;
  font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto,
    "Helvetica Neue", Arial, sans-serif;
  color: #333; /* 主文字色 */
}