From fb34ba28cb908bd328cf6690ab0b19a56428f4e2 Mon Sep 17 00:00:00 2001
From: WXL (wul) <wl_5969728@163.com>
Date: 星期五, 13 十一月 2026 10:56:55 +0800
Subject: [PATCH] 测试完成

---
 src/views/sfstatistics/percentage/components/SecondFollowUp.vue |  806 +++++++++++++++++++++++++++++++++++++++------------------
 1 files changed, 550 insertions(+), 256 deletions(-)

diff --git a/src/views/sfstatistics/percentage/components/SecondFollowUp.vue b/src/views/sfstatistics/percentage/components/SecondFollowUp.vue
index d3abd40..1002c4c 100644
--- a/src/views/sfstatistics/percentage/components/SecondFollowUp.vue
+++ b/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]);
       });
 

--
Gitblit v1.9.3