multiSystemPlatformWeb.git

			@@ -8,9 +8,10 @@
			plain
			icon="Plus"
			@click="openDialog('add',{})"
			v-hasPermi="['inventoryRecord:add']"
			>新增</el-button>
			</el-form-item>
			<el-form-item v-if="isAdmin" label="企业：" >
			<el-form-item v-if="isAdmin" label="单位：" >
			<el-select v-model="data.queryParams.companyId" placeholder="请选择" clearable>
			<el-option
			v-for="item in companyList"
			@@ -29,14 +30,15 @@
			</div>
			<!-- 表格数据 -->
			<el-table v-loading="loading" :data="dataList" :border="true">
			<el-table-column type="index" label="序号"></el-table-column>
			<el-table-column prop="recordName" align="center" label="记录名称" v-if="isAdmin"></el-table-column>
			<el-table-column type="index" label="序号" width="80"/>
			<el-table-column prop="recordName" align="center" label="材料名称"/>
			<el-table-column prop="inventory" align="center" label="当前库存"/>
			<el-table-column label="操作" align="center">
			<template #default="scope">
			<el-button link type="primary" @click="openDialog('view',scope.row)">查看</el-button>
			<el-button link type="primary" @click="openDialog('edit',scope.row)">编辑</el-button>
			<el-button link type="primary" @click="openDialog('edit',scope.row)" v-hasPermi="['inventoryRecord:edit']">编辑</el-button>
			<el-button link type="primary" @click="downloadFile(scope.row)">导出</el-button>
			<el-button link type="danger" @click="handleDelete(scope.row)">删除</el-button>
			<el-button link type="danger" @click="handleDelete(scope.row)" v-hasPermi="['inventoryRecord:del']">删除</el-button>
			</template>
			</el-table-column>
			</el-table>
			@@ -64,7 +66,7 @@
			import {
			delWarehousingRecord,
			getWarehousingRecordDetail,
			getWarehousingRecordList
			getWarehousingRecordDetailList
			} from "@/api/outsourcingCooperate/outsourcingCooperate";


			@@ -103,7 +105,7 @@

			const getList = async () => {
			loading.value = true
			const res = await getWarehousingRecordList(data.queryParams)
			const res = await getWarehousingRecordDetailList(data.queryParams)
			if(res.code == 200){
			data.dataList = res.data.list \|\| []
			data.total = res.data.total
			@@ -127,29 +129,28 @@
			}
			}

			const downloadFile = async (val)=>{
			const res = await getWarehousingRecordDetail({id: val.id})
			if(res.code == 200){
			if(res.data){
			const downloadFile = async (val) => {
			const res = await getWarehousingRecordDetail({ id: val.id })
			if (res.code == 200) {
			if (res.data) {
			const jsonData = res.data

			// 列定义
			const columns = [
			{ label: '序号', key: 'index' },
			{ label: '登记时间', key: 'boardingTime' },
			{ label: '名称', key: 'name' },
			{ label: '入库单位', key: 'enterCompany' },
			{ label: '入库数量', key: 'enterNum' },
			{ label: '入库经手人', key: 'enterPerson' },
			{ label: '出库单位', key: 'outboundCompany' },
			{ label: '出库数量', key: 'outboundNum' },
			{ label: '出库经手人', key: 'outboundPerson' },
			{ label: '库存数量', key: 'amount' },
			{ label: '出入库', key: 'recordType' },
			{ label: '规格', key: 'specification' },
			{ label: '单位', key: 'materialUnit' },
			{ label: '数量', key: 'num' },
			{ label: '经手人', key: 'createBy' },
			{ label: '备注', key: 'remark' }
			];

			// 样式定义
			const headerStyle = {
			font: { bold: true, sz: 12, color: { rgb: "FFFFFF" } },
			fill: { fgColor: { rgb: "3498DB" } },
			font: { bold: true, sz: 12, color: { rgb: "000000" } },
			fill: { fgColor: { rgb: "CCCCCC" } },
			alignment: { horizontal: "center", vertical: "center" },
			border: {
			top: { style: "thin", color: { rgb: "000000" } },
			@@ -175,15 +176,36 @@
			alignment: { horizontal: "center", vertical: "center" }
			};

			// 处理数据，添加序号
			const summaryStyle = {
			font: { bold: true, sz: 12, color: { rgb: "000000" } },
			alignment: { horizontal: "left", vertical: "center" },
			border: {
			top: { style: "thin", color: { rgb: "000000" } },
			bottom: { style: "thin", color: { rgb: "000000" } },
			left: { style: "thin", color: { rgb: "000000" } },
			right: { style: "thin", color: { rgb: "000000" } }
			}
			};

			// 处理数据，添加序号和转换recordType
			const processData = () => {
			return jsonData.warehousingRecordDetails.map((item, index) => {
			// 转换recordType：1->入库，2->出库
			const recordTypeText = item.recordType === 1 ? '入库' : item.recordType === 2 ? '出库' : '';

			return {
			index: index + 1,
			...item
			boardingTime: item.boardingTime,
			recordType: recordTypeText,
			specification: item.specification,
			materialUnit: item.materialUnit,
			num: item.num,
			createBy: item.createBy,
			remark: item.remark
			};
			});
			};

			// 创建工作簿
			const wb = utils.book_new();
			const wsData = [];
			@@ -200,7 +222,7 @@
			}
			wsData.push(titleRow);

			// 添加表头
			// 添加表头行
			const headerRow = columns.map(col => ({
			v: col.label,
			t: 's',
			@@ -211,35 +233,45 @@
			// 添加数据行
			const processedData = processData();
			processedData.forEach(item => {
			const row = columns.map(col => ({
			v: item[col.key],
			t: typeof item[col.key] === 'number' ? 'n' : 's',
			s: dataStyle
			}));
			const row = columns.map(col => {
			const value = item[col.key];
			return {
			v: value,
			t: typeof value === 'number' ? 'n' : 's',
			s: dataStyle
			};
			});
			wsData.push(row);
			});

			// 添加汇总行（当前库存）
			const summaryRow = [
			{ v: `当前库存：${jsonData.inventory}`, t: 's', s: summaryStyle }
			];
			wsData.push(summaryRow);

			// 创建工作表
			const ws = utils.aoa_to_sheet(wsData);

			// 设置合并单元格（标题行）
			ws['!merges'] = [
			{ s: { r: 0, c: 0 }, e: { r: 0, c: columns.length - 1 } }
			// 设置合并单元格（只保留标题行合并）
			const merges = [
			// 标题行合并
			{ s: { r: 0, c: 0 }, e: { r: 0, c: columns.length - 1 } },
			//库存行合并
			{ s: { r: wsData.length - 1, c: 0 }, e: { r: wsData.length - 1, c: columns.length - 1 } }
			];
			ws['!merges'] = merges;

			// 设置列宽
			const colWidths = [
			{ wch: 8 }, // 序号
			{ wch: 20 }, // 登记时间
			{ wch: 15 }, // 名称
			{ wch: 15 }, // 入库单位
			{ wch: 12 }, // 入库数量
			{ wch: 15 }, // 入库经手人
			{ wch: 15 }, // 出库单位
			{ wch: 12 }, // 出库数量
			{ wch: 15 }, // 出库经手人
			{ wch: 12 }, // 库存数量
			{ wch: 20 } // 备注
			{ wch: 8 }, // 序号
			{ wch: 20 }, // 登记时间
			{ wch: 10 }, // 出入库
			{ wch: 15 }, // 规格
			{ wch: 10 }, // 单位
			{ wch: 12 }, // 数量
			{ wch: 15 }, // 经手人
			{ wch: 20 } // 备注
			];
			ws['!cols'] = colWidths;

			@@ -248,10 +280,10 @@

			// 生成Excel文件并下载
			writeFile(wb, `${jsonData.recordName}.xlsx`);
			}else{
			} else {
			ElMessage.warning('暂无数据')
			}
			}else{
			} else {
			ElMessage.warning(res.message)
			}
			}