| | |
| | | <div style="font-size: 12px;color: red">系统自动计算金额仅供参考,请注意核对。</div> |
| | | </el-form-item> |
| | | </el-col> |
| | | <el-col :span="12"> |
| | | <el-form-item label="税后金额"> |
| | | <el-input v-model="state.form.afterTaxAmount" type="number" :readonly="state.disable"> |
| | | <template #append>元</template> |
| | | </el-input> |
| | | </el-form-item> |
| | | </el-col> |
| | | <!-- <el-col :span="12">--> |
| | | <!-- <el-form-item label="税后金额">--> |
| | | <!-- <el-input v-model="state.form.afterTaxAmount" type="number" :readonly="state.disable">--> |
| | | <!-- <template #append>元</template>--> |
| | | <!-- </el-input>--> |
| | | <!-- </el-form-item>--> |
| | | <!-- </el-col>--> |
| | | </el-row> |
| | | |
| | | <el-row> |
| | |
| | | const title = [["自治区应急管理厅外聘专家劳务费发放表"]] |
| | | // 固定一行:填报处室和单位 |
| | | const fixedHeader = [ |
| | | ["填报处室:" + row.deptName, "", "", "", "", "单位:元", "", "", "", "","",""] |
| | | ["填报处室:" + row.deptName, "", "", "", "", "单位:元", "", "", "", "",""] |
| | | ] |
| | | if(res.data && res.data[0] && Array.isArray(res.data[0].projectExpertExportResps) && res.data[0].projectExpertExportResps.length>0){ |
| | | let mainData = res.data[0].projectExpertExportResps |
| | | const data = mainData.map((item,index)=>{ |
| | | return [index+1,item.name,item.companyName,item.title,item.idCard,item.freightBasis,item.billingDuration,item.taxExpertFee,item.incomeTaxPayable,item.afterTaxAmount,item.openBank,item.bankCard] |
| | | return [index+1,item.name,item.companyName,item.title,item.idCard,item.freightBasis,item.billingDuration,item.taxExpertFee,item.incomeTaxPayable,item.openBank,item.bankCard] |
| | | }) |
| | | |
| | | console.log(data,'data') |
| | | // 定义表头 |
| | | const headers = [ |
| | | ["序号", "姓名", "工作单位", "职称", "身份证号", "计费标准", "计费时长", "专家费", "应缴税费", "税后金额", "开户银行", "卡号"] |
| | | ["序号", "姓名", "工作单位", "职称", "身份证号", "计费标准", "计费时长", "专家费", "应缴税费", "开户银行", "卡号"] |
| | | ] |
| | | // 固定一行:经办人和负责人 |
| | | const footer = [ |
| | | ["经办人:", "", "", "", "", "处室负责人:", "", "", "", "","",""] |
| | | ["经办人:", "", "", "", "", "处室负责人:", "", `合计:${data.reduce((accumulator, currentValue) => { |
| | | return accumulator + currentValue[7] |
| | | }, 0).toFixed(2)}`,`合计:${data.reduce((accumulator, currentValue) => { |
| | | return accumulator + currentValue[8] |
| | | }, 0).toFixed(2)}`,"",""] |
| | | ] |
| | | // 创建工作表 |
| | | const ws = XLSX.utils.aoa_to_sheet([ |
| | |
| | | const dataRowCount = data.length; |
| | | // 合并单元格的范围 |
| | | ws['!merges'] = [ |
| | | { s: { r: 0, c: 0 }, e: { r: 0, c: 11 } }, // 合并标题:第1行 0列到12列 |
| | | { s: { r: 0, c: 0 }, e: { r: 0, c: 10 } }, // 合并标题:第1行 0列到12列 |
| | | { s: { r: 1, c: 0 }, e: { r: 1, c: 4 } }, // 合并填报处室:第2行 第0列到4列 |
| | | { s: { r: 1, c: 5 }, e: { r: 1, c: 11 } }, // 合并单位:第2行 第5列到12列 |
| | | { s: { r: 1, c: 5 }, e: { r: 1, c: 10 } }, // 合并单位:第2行 第5列到12列 |
| | | { s: { r: 3 + dataRowCount, c: 0 }, e: { r: 3 + dataRowCount, c: 4 } }, // 合并经办人:最后一行的第0列到4列 |
| | | { s: { r: 3 + dataRowCount, c: 5 }, e: { r: 3 + dataRowCount, c: 11 } }, // 合并负责人:最后一行的第5列到12列 |
| | | { s: { r: 3 + dataRowCount, c: 5 }, e: { r: 3 + dataRowCount, c: 6} }, // 合并负责人:最后一行的第5列到+6列 |
| | | ] |
| | | // 设置标题 |
| | | if (!ws['A1']) ws['A1'] = {}; // 确保 A1 单元格存在 |
| | |
| | | // 设置数据区(包括填报处室、单位、数据行和最后一行)为左对齐 |
| | | const totalRows = 3 + dataRowCount + 1; // 标题、固定行和数据行的总数 |
| | | for (let r = 3; r <= totalRows; r++) { // 遍历每一行 |
| | | for (let c = 0; c < 13; c++) { // 遍历每一列 |
| | | for (let c = 0; c < 11; c++) { // 遍历每一列 |
| | | const cellRef = `${String.fromCharCode(65 + c)}${r}`; |
| | | if (!ws[cellRef]) ws[cellRef] = {}; // 确保单元格存在 |
| | | ws[cellRef].s = { |
| | |
| | | } |
| | | // 设置最后一行(经办人、负责人)左对齐 |
| | | const lastRowStart = 3 + dataRowCount; |
| | | for (let c = 0; c < 13; c++) { |
| | | for (let c = 0; c < 11; c++) { |
| | | const cellRef = `${String.fromCharCode(65 + c)}${lastRowStart + 1}`; |
| | | console.log(cellRef,'ref') |
| | | if (!ws[cellRef]) ws[cellRef] = {}; // 确保单元格存在 |
| | | ws[cellRef].s = { |
| | | alignment: { horizontal: 'left', vertical: 'center' } // 设置为左对齐 |
| | | }; |
| | | if(cellRef == 'H'+ (4 + dataRowCount) || cellRef == 'I'+ (4 + dataRowCount)){ |
| | | ws[cellRef].s = { |
| | | alignment: { horizontal: 'center', vertical: 'center' } // 设置居中对齐 |
| | | } |
| | | }else{ |
| | | ws[cellRef].s = { |
| | | alignment: { horizontal: 'left', vertical: 'center' } // 设置为左对齐 |
| | | } |
| | | } |
| | | } |
| | | // 设置列宽,计算每列的最大宽度 |
| | | const MIN_COL_WIDTH = 60; |