WXL (wul)
昨天 d3c60e18b95b50751f8088fa2d23cd8ff7f173bc
src/views/sfstatistics/percentage/components/FirstFollowUp.vue
@@ -236,6 +236,7 @@
                  width="120"
                  key="successRate"
                  prop="successRate"
                  :render-header="Tooltipcgl"
                >
                  <template slot-scope="scope">
                    <span class="success-rate">{{
@@ -253,6 +254,7 @@
                  width="120"
                  key="followUpRate"
                  prop="followUpRate"
                  :render-header="Tooltipsfl"
                />
                <el-table-column
                  v-if="orgname != '丽水市中医院'"
@@ -261,6 +263,7 @@
                  width="120"
                  key="rate"
                  prop="rate"
                  :render-header="Tooltipjsl"
                >
                  <template slot-scope="scope">
                    <el-button
@@ -275,7 +278,6 @@
                  </template>
                </el-table-column>
                <el-table-column
                  v-if="orgname != '丽水市中医院'"
                  label="人工"
                  align="center"
                  key="manual"
@@ -299,7 +301,6 @@
                  </template>
                </el-table-column>
                <el-table-column
                  v-if="orgname != '丽水市中医院'"
                  label="语音"
                  align="center"
                  key="voice"
@@ -323,7 +324,6 @@
                  </template>
                </el-table-column>
                <el-table-column
                  v-if="orgname != '丽水市中医院'"
                  label="短信"
                  align="center"
                  key="sms"
@@ -347,7 +347,6 @@
                  </template>
                </el-table-column>
                <el-table-column
                  v-if="orgname != '丽水市中医院'"
                  label="微信"
                  align="center"
                  key="weChat"
@@ -547,6 +546,7 @@
            width="120"
            key="successRate"
            prop="successRate"
            :render-header="Tooltipcgl"
          >
            <template slot-scope="scope">
              <span class="success-rate">{{
@@ -564,6 +564,7 @@
            width="120"
            key="followUpRate"
            prop="followUpRate"
            :render-header="Tooltipsfl"
          />
          <el-table-column
            v-if="orgname != '丽水市中医院'"
@@ -572,6 +573,7 @@
            width="120"
            key="rate"
            prop="rate"
            :render-header="Tooltipjsl"
          >
            <template slot-scope="scope">
              <el-button
@@ -586,7 +588,6 @@
            </template>
          </el-table-column>
          <el-table-column
            v-if="orgname != '丽水市中医院'"
            label="人工"
            align="center"
            key="manual"
@@ -604,13 +605,7 @@
              </el-button>
            </template>
          </el-table-column>
          <el-table-column
            v-if="orgname != '丽水市中医院'"
            label="语音"
            align="center"
            key="voice"
            prop="voice"
          >
          <el-table-column label="语音" align="center" key="voice" prop="voice">
            <template slot-scope="scope">
              <el-button
                size="medium"
@@ -623,13 +618,7 @@
              </el-button>
            </template>
          </el-table-column>
          <el-table-column
            v-if="orgname != '丽水市中医院'"
            label="短信"
            align="center"
            key="sms"
            prop="sms"
          >
          <el-table-column label="短信" align="center" key="sms" prop="sms">
            <template slot-scope="scope">
              <el-button
                size="medium"
@@ -641,7 +630,6 @@
            </template>
          </el-table-column>
          <el-table-column
            v-if="orgname != '丽水市中医院'"
            label="微信"
            align="center"
            key="weChat"
@@ -719,6 +707,7 @@
<script>
import { getSfStatisticsHyperlink } from "@/api/AiCentre/index";
import store from "@/store";
import { getSfStatistics, selectTimelyRate } from "@/api/system/user";
import ExcelJS from "exceljs";
@@ -755,6 +744,7 @@
      expands: [],
      ids: [],
      patientqueryParams: { pn: 1, ps: 10 },
      tasktypes: store.getters.tasktypes,
    };
  },
  methods: {
@@ -879,7 +869,45 @@
        return indexA - indexB;
      });
    },
    Tooltipcgl(h, { column }) {
      return h(
        "el-tooltip",
        {
          props: {
            content: "随访成功/(需随访-待随访)",
            placement: "top",
            effect: "dark",
          },
        },
        [h("span", column.label)]
      );
    },
    Tooltipjsl(h, { column }) {
      return h(
        "el-tooltip",
        {
          props: {
            content: "(应随访时间+任务周期)小于完成时间即为超时;(需随访-超时)/需随访",
            placement: "top",
            effect: "dark",
          },
        },
        [h("span", column.label)]
      );
    },
    Tooltipsfl(h, { column }) {
      return h(
        "el-tooltip",
        {
          props: {
            content: "(随访成功+首次随访失败)/首次应随访",
            placement: "top",
            effect: "dark",
          },
        },
        [h("span", column.label)]
      );
    },
    sortChineseNumber(aRow, bRow) {
      const a = aRow.leavehospitaldistrictname;
      const b = bRow.leavehospitaldistrictname;
@@ -1201,31 +1229,117 @@
        let dateRangeString = "";
        let sheetNameSuffix = "";
        // 判断是否是丽水市中医院
        const isLishuiHospital = this.orgname == "丽水市中医院";
        if (
          this.queryParams.dateRange &&
          this.queryParams.dateRange.length === 2
        ) {
          const startDateStr = this.queryParams.dateRange[0];
          const endDateStr = this.queryParams.dateRange[1];
          const formatDateForDisplay = (dateTimeStr) => {
            return dateTimeStr.split(" ")[0];
          };
          const startDateFormatted = formatDateForDisplay(startDateStr);
          const endDateFormatted = formatDateForDisplay(endDateStr);
          dateRangeString = `${startDateFormatted}至${endDateFormatted}`;
          sheetNameSuffix = `${startDateFormatted}至${endDateFormatted}`;
          if (isLishuiHospital) {
            // 丽水市中医院:只显示年月
            const formatMonthOnly = (dateTimeStr) => {
              const date = new Date(dateTimeStr);
              const year = date.getFullYear();
              const month = date.getMonth() + 1;
              return `${year}年${month}月`;
            };
            const startDateFormatted = formatMonthOnly(startDateStr);
            const endDateFormatted = formatMonthOnly(endDateStr);
            dateRangeString = `${startDateFormatted}至${endDateFormatted}`;
            sheetNameSuffix = `${startDateFormatted}至${endDateFormatted}`;
          } else {
            // 其他医院:显示年月日
            const formatDateForDisplay = (dateTimeStr) => {
              return dateTimeStr.split(" ")[0];
            };
            const startDateFormatted = formatDateForDisplay(startDateStr);
            const endDateFormatted = formatDateForDisplay(endDateStr);
            dateRangeString = `${startDateFormatted}至${endDateFormatted}`;
            sheetNameSuffix = `${startDateFormatted}至${endDateFormatted}`;
          }
        } else {
          const now = new Date();
          const currentMonth = now.getMonth() + 1;
          dateRangeString = `${currentMonth}月`;
          sheetNameSuffix = `${currentMonth}月`;
          const currentYear = now.getFullYear();
          if (isLishuiHospital) {
            // 丽水市中医院:显示年月
            dateRangeString = `${currentYear}年${currentMonth}月`;
            sheetNameSuffix = `${currentYear}年${currentMonth}月`;
          } else {
            // 其他医院:显示月份
            dateRangeString = `${currentMonth}月`;
            sheetNameSuffix = `${currentMonth}月`;
          }
        }
        const excelName = `首次出院随访统计表_${dateRangeString}.xlsx`;
        const worksheetName = `首次随访统计_${sheetNameSuffix}`;
        // 根据 serviceType 生成随访类型名称
        let serviceTypeName = "首次出院随访"; // 文件名使用的名称
        let sheetTypeName = "首次随访"; // 工作表使用的名称(简化版)
        if (
          this.queryParams.serviceType &&
          Array.isArray(this.queryParams.serviceType) &&
          this.queryParams.serviceType.length > 0
        ) {
          if (this.tasktypes && Array.isArray(this.tasktypes)) {
            // 过滤出匹配的随访类型
            const matchedTypes = this.tasktypes.filter((task) =>
              this.queryParams.serviceType.includes(task.value)
            );
            if (matchedTypes.length === 1) {
              // 单个类型
              const label = matchedTypes[0].label;
              serviceTypeName = `首次${label}`;
              sheetTypeName = `首次${label}`;
            } else if (matchedTypes.length > 1) {
              // 多个类型
              const typeNames = matchedTypes.map((task) => task.label);
              // 文件名:用斜杠分隔
              serviceTypeName = `首次${typeNames.join("/")}`;
              // 工作表名:使用第一个类型或简化名称
              if (matchedTypes.length <= 2) {
                // 如果只有2个类型,都显示
                sheetTypeName = `首次${typeNames[0]}等`;
              } else {
                // 如果超过2个类型,只显示第一个
                sheetTypeName = `首次${typeNames[0]}等`;
              }
            } else if (this.queryParams.serviceType.length > 0) {
              // 如果没有匹配的,使用原始值
              const typeStr = this.queryParams.serviceType.join("/");
              serviceTypeName = `首次${typeStr}`;
              sheetTypeName = "首次随访";
            }
          } else if (this.queryParams.serviceType.length > 0) {
            // 如果没有 tasktypes,使用原始值
            const typeStr = this.queryParams.serviceType.join("/");
            serviceTypeName = `首次${typeStr}`;
            sheetTypeName = "首次随访";
          }
        }
        const excelName = `${serviceTypeName}统计表_${dateRangeString}.xlsx`;
        // 清理工作表名称,移除非法字符
        const cleanSheetName = (name) => {
          // Excel工作表名不能包含的字符: * ? : \ / [ ]
          return name.replace(/[*?:\\/[\]]/g, " ");
        };
        const worksheetName = cleanSheetName(
          `${sheetTypeName}统计_${sheetNameSuffix}`
        );
        if (!this.tableData || this.tableData.length === 0) {
          this.$message.warning("暂无首次随访数据可导出");
          this.$message.warning(`暂无${serviceTypeName}数据可导出`);
          return false;
        }
@@ -1769,7 +1883,6 @@
      this.patientqueryParams.serviceTypes = queryParams.serviceType
        ? queryParams.serviceType.join(",")
        : null;
      console.log(2);
      return selectTimelyRate(this.patientqueryParams);
    },