| | |
| | | </template> |
| | | </el-table-column> |
| | | <el-table-column |
| | | v-if="!isTargetHospital" |
| | | label="待随访" |
| | | align="center" |
| | | key="pendingFollowUpAgain" |
| | |
| | | }}</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="随访成功" |
| | |
| | | </template> |
| | | </el-table-column> |
| | | <el-table-column |
| | | v-if="!isTargetHospital" |
| | | label="随访失败" |
| | | align="center" |
| | | key="followUpFailAgain" |
| | |
| | | </template> |
| | | </el-table-column> |
| | | <el-table-column |
| | | v-if="!isTargetHospital" |
| | | label="待随访" |
| | | align="center" |
| | | key="pendingFollowUpAgain" |
| | |
| | | }}</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="随访成功" |
| | |
| | | </template> |
| | | </el-table-column> |
| | | <el-table-column |
| | | v-if="!isTargetHospital" |
| | | label="随访失败" |
| | | align="center" |
| | | key="followUpFailAgain" |
| | |
| | | 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"> |
| | |
| | | @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" |
| | |
| | | </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"> |
| | |
| | | @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" |
| | |
| | | </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"> |
| | |
| | | @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"> |
| | |
| | | @click=" |
| | | handleViewDetails( |
| | | scope.row, |
| | | 'wechatAgainSuccessInfo', |
| | | '最终完成微信随访列表' |
| | | 'manualAgainSuccessInfo', |
| | | '最终完成人工随访列表' |
| | | ) |
| | | " |
| | | > |
| | | <span class="button-zx">{{ |
| | | scope.row.weChatAgainSuccess |
| | | scope.row.manualAgainSuccess |
| | | }}</span> |
| | | </el-button> |
| | | </template> |
| | |
| | | delete params.deptcodes.all; |
| | | params.rateDay = this.orgname == "龙泉市人民医院" ? 21 : 7; |
| | | |
| | | getSfStatistics(params) |
| | | return getSfStatistics(params) |
| | | .then((response) => { |
| | | this.tableData = this.customSort(response.data); |
| | | }) |
| | |
| | | "el-tooltip", |
| | | { |
| | | props: { |
| | | content: "随访成功/(需随访-待随访)", |
| | | content: this.isTargetHospital |
| | | ? "随访成功/需随访" |
| | | : "随访成功/(需随访-待随访)", |
| | | placement: "top", |
| | | effect: "dark", |
| | | }, |
| | |
| | | }, |
| | | |
| | | getRowKey(row) { |
| | | return row.statisticaltype === 1 |
| | | return this.queryParams.statisticaltype === 1 |
| | | ? row.leavehospitaldistrictcode |
| | | : row.deptcode; |
| | | }, |
| | |
| | | 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) + "%"; |
| | |
| | | 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) + "%"; |
| | |
| | | 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%"; |
| | |
| | | }, |
| | | }; |
| | | |
| | | // 标题 |
| | | 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 = [ |
| | | "医生姓名", |
| | | "科室", |
| | |
| | | "无需随访", |
| | | "应随访", |
| | | "需随访", |
| | | "待随访", |
| | | ...(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; |
| | |
| | | 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; |
| | |
| | | }; |
| | | }); |
| | | |
| | | // 列宽 |
| | | 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) => { |
| | |
| | | }); |
| | | |
| | | // 成功率(平均值) |
| | | 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 |
| | |
| | | 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; |
| | |
| | | }, |
| | | }; |
| | | |
| | | 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; |
| | | }); |
| | |
| | | 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) + "%"; |
| | |
| | | } |
| | | |
| | | // 格式化数字 |
| | | [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]); |
| | | }); |
| | | |