<template>
|
<div class="app-container">
|
<div style="display: flex;justify-content: space-between">
|
<el-form :inline="true" style="display: flex;align-items: center;flex-wrap: wrap;" >
|
<el-form-item>
|
<el-button
|
type="primary"
|
plain
|
icon="Plus"
|
@click="openDialog('add',{})"
|
>新增</el-button>
|
</el-form-item>
|
<el-form-item v-if="isAdmin" label="企业：" >
|
<el-select v-model="data.queryParams.companyId" placeholder="请选择" clearable>
|
<el-option
|
v-for="item in companyList"
|
:key="item.id"
|
:label="item.name"
|
:value="item.id">
|
</el-option>
|
</el-select>
|
</el-form-item>
|
<el-form-item v-if="isAdmin" label="年份:">
|
<el-date-picker
|
v-model="data.queryParams.year"
|
type="year"
|
value-format="YYYY"
|
placeholder="请选择年份"
|
/>
|
</el-form-item>
|
<el-form-item >
|
<el-button v-if="isAdmin" type="primary" @click="getList">查询</el-button>
|
<el-button v-if="isAdmin" type="primary" plain @click="reset">重置</el-button>
|
<!-- <el-button type="primary">导出</el-button>-->
|
</el-form-item>
|
</el-form>
|
</div>
|
<!-- 表格数据 -->
|
<el-table v-loading="loading" :data="dataList" :border="true">
|
<el-table-column type="index" label="序号"></el-table-column>
|
<el-table-column prop="name" align="center" label="名称"></el-table-column>
|
<el-table-column prop="year" align="center" label="年份"></el-table-column>
|
<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="downloadFile(scope.row)">导出</el-button>
|
<el-button link type="danger" @click="handleDelete(scope.row)">删除</el-button>
|
</template>
|
</el-table-column>
|
</el-table>
|
|
<pagination
|
v-show="total > 0"
|
:total="total"
|
v-model:page="queryParams.pageNum"
|
v-model:limit="queryParams.pageSize"
|
@pagination="getList"
|
/>
|
|
<edit-dialog ref="dialogRef" @getList=getList></edit-dialog>
|
</div>
|
</template>
|
|
<script setup>
|
import {getCurrentInstance, onMounted, onUnmounted, reactive, ref, toRefs} from "vue";
|
import {ElMessage, ElMessageBox} from "element-plus";
|
import {delCompany, getCompany} from "@/api/onlineEducation/company";
|
import Cookies from "js-cookie";
|
import editDialog from './components/editDialog.vue'
|
import useUserStore from "@/store/modules/user";
|
import { utils, writeFile } from 'xlsx-js-style';
|
import {generateWordDocument} from "@/utils/exportWord";
|
import {
|
delMaintenancePlan,
|
getMaintenanceEvaluateDetail,
|
getMaintenancePlanDetail,
|
getMaintenancePlanList
|
} from "@/api/infrastructureMng/ledger";
|
|
|
const userStore = useUserStore()
|
const { proxy } = getCurrentInstance();
|
const loading = ref(false);
|
const dialogRef = ref();
|
const data = reactive({
|
queryParams: {
|
pageNum: 1,
|
pageSize: 10,
|
companyId: null
|
},
|
total: 0,
|
dataList: [],
|
companyList: [],
|
expertData: [],
|
isAdmin: false
|
});
|
const fields = ref({
|
'序号':'index',
|
'名称型号':'username',
|
'部门':'idCard',
|
'责任人/使用人':'entryTime',
|
'编号':'deptName',
|
'使用地点':'duty',
|
'使用情况':'phone'
|
});
|
const { queryParams, total, dataList,companyList, isAdmin, expertData } = toRefs(data);
|
const userInfo = ref()
|
onMounted(async ()=>{
|
if(userStore.roles.includes('admin')){
|
data.isAdmin = true
|
await getCompanyList()
|
}else{
|
data.isAdmin = false
|
data.queryParams.companyId = userStore.companyId
|
}
|
await getList()
|
})
|
|
onUnmounted(()=>{
|
|
})
|
|
const getList = async () => {
|
loading.value = true
|
const res = await getMaintenancePlanList(data.queryParams)
|
if(res.code == 200){
|
data.dataList = res.data.list || []
|
data.total = res.data.total
|
}else{
|
ElMessage.warning(res.message)
|
}
|
loading.value = false
|
}
|
|
const getCompanyList = async ()=>{
|
const queryParams = {
|
pageNum: 1,
|
pageSize: 999
|
}
|
const res = await getCompany(queryParams)
|
if (res.code == 200) {
|
data.companyList = res.data.list?res.data.list:[]
|
// data.queryParams.companyId = data.companyList[0].id
|
} else {
|
ElMessage.warning(res.message)
|
}
|
}
|
|
// const downloadFile = async (val)=>{
|
// const res = await getMaintenancePlanDetail({id: val.id})
|
// if(res.code == 200){
|
// if(res.data){
|
// let tableData = res.data
|
// tableData.content = res.data.caluseNum.split('、').map((i,index)=>i + res.data.caluseContent.split('；\n')[index]).join('\n')
|
// tableData.interPeople = res.data.internalAuditCheckPeople.map(i=>i.auditUserName)
|
// try {
|
// generateWordDocument('/interCheck.docx', tableData, tableData.deptName +'内审检查表.docx');
|
// } catch (error){
|
// ElMessage({
|
// type: 'warning',
|
// message: '导出失败'
|
// });
|
// }
|
// }else{
|
// ElMessage.warning('暂无数据')
|
// }
|
// }else{
|
// ElMessage.warning(res.message)
|
// }
|
// }
|
|
|
|
const downloadFile = async (val)=>{
|
const res = await getMaintenancePlanDetail({id: val.id})
|
if(res.code == 200){
|
if(res.data){
|
let tableData = res.data
|
if(data.isAdmin){
|
tableData.companyName = data.companyList.find(i=>i.id == val.companyId)?.name
|
}else{
|
tableData.companyName = userStore.companyName
|
}
|
const wb = utils.book_new();
|
const wsData = [];
|
|
// 第一行：企业名称（合并A1-T1）
|
wsData.push([{ v: tableData.companyName, t: 's', s: { font: { bold: true, sz: 16 }, alignment: { horizontal: 'center' } } }]);
|
|
// 第二行：标题（合并A2-T2）
|
wsData.push([{ v: tableData.name || '年度基础设施维护计划', t: 's', s: { font: { bold: true, sz: 14 }, alignment: { horizontal: 'center' } } }]);
|
|
// 第三行：表头上半部分
|
const row3 = [
|
// A-F列（将在下方与row4合并）
|
{ v: '序号', t: 's', s: headerStyle },
|
{ v: '设备名称', t: 's', s: headerStyle },
|
{ v: '型号', t: 's', s: headerStyle },
|
{ v: '厂内编号', t: 's', s: headerStyle },
|
{ v: '用途', t: 's', s: headerStyle },
|
{ v: '使用部门', t: 's', s: headerStyle },
|
// G-H列合并（维修保养）
|
{ v: '维修保养', t: 's', s: mergedHeaderStyle },
|
null, // 合并单元格占位
|
// I-T列合并（年度）
|
{ v: `${tableData.year}年度`, t: 's', s: mergedHeaderStyle },
|
...Array(11).fill(null) // 合并单元格占位
|
];
|
|
// 第四行：表头下半部分
|
const row4 = [
|
// A-F列留空（与row3合并）
|
...Array(6).fill(null),
|
// G列：项目
|
{ v: '项目', t: 's', s: subHeaderStyle },
|
// H列：频度
|
{ v: '频度', t: 's', s: subHeaderStyle },
|
// I-T列：月份
|
{ v: '一月', t: 's', s: subHeaderStyle },
|
{ v: '二月', t: 's', s: subHeaderStyle },
|
{ v: '三月', t: 's', s: subHeaderStyle },
|
{ v: '四月', t: 's', s: subHeaderStyle },
|
{ v: '五月', t: 's', s: subHeaderStyle },
|
{ v: '六月', t: 's', s: subHeaderStyle },
|
{ v: '七月', t: 's', s: subHeaderStyle },
|
{ v: '八月', t: 's', s: subHeaderStyle },
|
{ v: '九月', t: 's', s: subHeaderStyle },
|
{ v: '十月', t: 's', s: subHeaderStyle },
|
{ v: '十一月', t: 's', s: subHeaderStyle },
|
{ v: '十二月', t: 's', s: subHeaderStyle }
|
];
|
|
// 添加表头行
|
wsData.push(row3);
|
wsData.push(row4);
|
|
// 添加数据行
|
tableData.annualMaintenanceDeviceList.forEach((device, deviceIndex) => {
|
const rowBase = 4 + deviceIndex * 3; // 计算起始行号
|
|
// 获取三种类型的维护数据
|
const maintenanceTypes = device.annualMaintenanceDeviceTypeList || [];
|
const dailyData = maintenanceTypes.find(item => item.projectType === 1) || {};
|
const level1Data = maintenanceTypes.find(item => item.projectType === 2) || {};
|
const level2Data = maintenanceTypes.find(item => item.projectType === 3) || {};
|
|
// 主数据行（日常例行点检）
|
const mainRow = [
|
{ v: deviceIndex + 1, t: 'n', s: dataStyle }, // A列：序号
|
{ v: device.deviceName || '', t: 's', s: dataStyle }, // B列：设备名称
|
{ v: device.model || '', t: 's', s: dataStyle }, // C列：型号
|
{ v: device.factoryNumber || '', t: 's', s: dataStyle }, // D列：厂内编号
|
{ v: device.purpose || '', t: 's', s: dataStyle }, // E列：用途
|
{ v: device.deptName || '', t: 's', s: dataStyle }, // F列：使用部门
|
{ v: '日常例行点检', t: 's', s: subDataStyle }, // G列
|
{ v: getFrequencyText(dailyData.frequency), t: 's', s: subDataStyle }, // H列
|
// I-T列：月份数据（日常例行点检）
|
{ v: dailyData.jan || '', t: 's', s: monthStyle },
|
{ v: dailyData.feb || '', t: 's', s: monthStyle },
|
{ v: dailyData.mar || '', t: 's', s: monthStyle },
|
{ v: dailyData.apr || '', t: 's', s: monthStyle },
|
{ v: dailyData.may || '', t: 's', s: monthStyle },
|
{ v: dailyData.jun || '', t: 's', s: monthStyle },
|
{ v: dailyData.jul || '', t: 's', s: monthStyle },
|
{ v: dailyData.aug || '', t: 's', s: monthStyle },
|
{ v: dailyData.sep || '', t: 's', s: monthStyle },
|
{ v: dailyData.oct || '', t: 's', s: monthStyle },
|
{ v: dailyData.nov || '', t: 's', s: monthStyle },
|
{ v: dailyData.decm || '', t: 's', s: monthStyle }
|
];
|
|
// 一级保养行
|
const subRow1 = [
|
...Array(6).fill(null), // A-F列留空（与主行合并）
|
{ v: '一级保养', t: 's', s: subDataStyle }, // G列
|
{ v: getFrequencyText(level1Data.frequency), t: 's', s: subDataStyle }, // H列
|
// I-T列：月份数据（一级保养）
|
{ v: level1Data.jan || '', t: 's', s: monthStyle },
|
{ v: level1Data.feb || '', t: 's', s: monthStyle },
|
{ v: level1Data.mar || '', t: 's', s: monthStyle },
|
{ v: level1Data.apr || '', t: 's', s: monthStyle },
|
{ v: level1Data.may || '', t: 's', s: monthStyle },
|
{ v: level1Data.jun || '', t: 's', s: monthStyle },
|
{ v: level1Data.jul || '', t: 's', s: monthStyle },
|
{ v: level1Data.aug || '', t: 's', s: monthStyle },
|
{ v: level1Data.sep || '', t: 's', s: monthStyle },
|
{ v: level1Data.oct || '', t: 's', s: monthStyle },
|
{ v: level1Data.nov || '', t: 's', s: monthStyle },
|
{ v: level1Data.decm || '', t: 's', s: monthStyle }
|
];
|
// 二级保养行
|
const subRow2 = [
|
...Array(6).fill(null), // A-F列留空（与主行合并）
|
{ v: '二级保养', t: 's', s: subDataStyle }, // G列
|
{ v: getFrequencyText(level2Data.frequency), t: 's', s: subDataStyle }, // H列
|
// I-T列：月份数据（二级保养）
|
{ v: level2Data.jan || '', t: 's', s: monthStyle },
|
{ v: level2Data.feb || '', t: 's', s: monthStyle },
|
{ v: level2Data.mar || '', t: 's', s: monthStyle },
|
{ v: level2Data.apr || '', t: 's', s: monthStyle },
|
{ v: level2Data.may || '', t: 's', s: monthStyle },
|
{ v: level2Data.jun || '', t: 's', s: monthStyle },
|
{ v: level2Data.jul || '', t: 's', s: monthStyle },
|
{ v: level2Data.aug || '', t: 's', s: monthStyle },
|
{ v: level2Data.sep || '', t: 's', s: monthStyle },
|
{ v: level2Data.oct || '', t: 's', s: monthStyle },
|
{ v: level2Data.nov || '', t: 's', s: monthStyle },
|
{ v: level2Data.decm || '', t: 's', s: monthStyle }
|
];
|
wsData.push(mainRow);
|
wsData.push(subRow1);
|
wsData.push(subRow2);
|
});
|
// 6. 说明行（合并A-T）
|
const noteRowIndex = wsData.length;
|
wsData.push([{
|
v: "说明：" + '\n' + "1、日常例行点检项目依设备日常点检表项目进行。" + '\n' + "2、一级保养：以操作工为主，维修工辅导，按计划对设备进行检查，清洗规定部位，疏通油管，更换和清洗油管、油毡、滤油器。调整设备各配合间隙，紧固设备各固定螺，对传动件进行润滑加油。频度为每季度/次。" + '\n' + "3、二级保养：以维修工为主，对设备进行部分解体检查修理。更换或修复磨损件、清洗、换油，检查修理电器部分。频度为半年/次。" + '\n' + "4、以上计划为设备在正常使用状态进行的计划，如设备处于暂停使用时不需做相关保养。",
|
t: 's',
|
s: noteStyle
|
}]);
|
// 7. 核准/审核/做成标题行
|
const approvalTitleRow = Array(20).fill({ v: '', t: 's', s: dataStyle });
|
approvalTitleRow[0] = { v: '核准', t: 's', s: footerHeaderStyle };
|
approvalTitleRow[7] = { v: '审核', t: 's', s: footerHeaderStyle };
|
approvalTitleRow[14] = { v: '做成', t: 's', s: footerHeaderStyle };
|
wsData.push(approvalTitleRow);
|
// 8. 人员信息行
|
const approvalDataRow = Array(20).fill({ v: '', t: 's', s: dataStyle });
|
approvalDataRow[0] = { v: tableData.approvalName || '', t: 's', s: footerDataStyle };
|
approvalDataRow[7] = { v: tableData.processName || '', t: 's', s: footerDataStyle };
|
approvalDataRow[14] = { v: tableData.finishName || '', t: 's', s: footerDataStyle };
|
wsData.push(approvalDataRow);
|
// 9. 表单编号行
|
const lastRow = wsData.length;
|
const noteText = "表单编号:" + tableData.number;
|
wsData.push([{
|
v: noteText,
|
t: 's',
|
s: {
|
font: { sz: 11 },
|
alignment: { horizontal: 'right', vertical: 'center', wrapText: true },
|
|
}
|
}]);
|
|
const ws = utils.aoa_to_sheet(wsData);
|
|
// 设置合并单元格
|
|
const merges = [
|
// 第一行合并（A1-T1）
|
{ s: { r: 0, c: 0 }, e: { r: 0, c: 19 } },
|
// 第二行合并（A2-T2）
|
{ s: { r: 1, c: 0 }, e: { r: 1, c: 19 } },
|
|
// A-F列在第三行和第四行合并
|
...Array.from({ length: 6 }, (_, c) => ({
|
s: { r: 2, c }, e: { r: 3, c }
|
})),
|
|
// 第三行的维修保养合并（G3-H3）
|
{ s: { r: 2, c: 6 }, e: { r: 2, c: 7 } },
|
// 第三行的年度合并（I3-T3）
|
{ s: { r: 2, c: 8 }, e: { r: 2, c: 19 } },
|
// 说明行合并
|
{ s: { r: noteRowIndex, c: 0 }, e: { r: noteRowIndex, c: 19 } },
|
|
// 核准/审核/做成标题合并
|
{ s: { r: noteRowIndex + 1, c: 0 }, e: { r: noteRowIndex + 1, c: 6 } },
|
{ s: { r: noteRowIndex + 1, c: 7 }, e: { r: noteRowIndex + 1, c: 13 } },
|
{ s: { r: noteRowIndex + 1, c: 14 }, e: { r: noteRowIndex + 1, c: 19 } },
|
|
// 人员信息合并
|
{ s: { r: noteRowIndex + 2, c: 0 }, e: { r: noteRowIndex + 2, c: 6 } },
|
{ s: { r: noteRowIndex + 2, c: 7 }, e: { r: noteRowIndex + 2, c: 13 } },
|
{ s: { r: noteRowIndex + 2, c: 14 }, e: { r: noteRowIndex + 2, c: 19 } },
|
|
{ s: { r: lastRow, c: 0 }, e: { r: lastRow, c: 19 } }
|
];
|
|
// 添加每个设备的三行合并
|
tableData.annualMaintenanceDeviceList.forEach((_, index) => {
|
const rowBase = 4 + index * 3;
|
// A-F列在三行中合并
|
for (let c = 0; c < 6; c++) {
|
merges.push({ s: { r: rowBase, c }, e: { r: rowBase + 2, c } });
|
}
|
});
|
|
ws['!merges'] = merges;
|
|
merges.forEach(merge => {
|
const { s, e } = merge; // 合并区域的起止位置
|
// 设置合并区域四个边的边框
|
for (let r = s.r; r <= e.r; r++) {
|
for (let c = s.c; c <= e.c; c++) {
|
const cellRef = utils.encode_cell({ r, c });
|
// 保留原有样式，只覆盖边框
|
ws[cellRef] = ws[cellRef] || { t: 's', v: '' };
|
ws[cellRef].s = {
|
...(ws[cellRef].s || {}),
|
border: {
|
top: { style: 'thin', color: { rgb: '000000' } },
|
left: { style: 'thin', color: { rgb: '000000' } },
|
bottom: { style: 'thin', color: { rgb: '000000' } },
|
right: { style: 'thin', color: { rgb: '000000' } }
|
}
|
};
|
}
|
}
|
});
|
|
const totalRows = wsData.length;
|
if (!ws['!rows']) {
|
ws['!rows'] = Array(totalRows).fill(null);
|
}
|
ws['!rows'][noteRowIndex] = { hpx: 100 };
|
// 设置列宽
|
ws['!cols'] = [
|
{ wch: 8 }, { wch: 15 }, { wch: 12 }, { wch: 12 },
|
{ wch: 12 }, { wch: 12 }, { wch: 12 }, { wch: 10 },
|
...Array(12).fill({ wch: 8 })
|
];
|
|
// 添加工作表到工作簿
|
utils.book_append_sheet(wb, ws, '维护计划');
|
|
// 导出Excel文件
|
writeFile(wb, `${tableData.companyName}${tableData.year}年度基础设施维护计划.xlsx`);
|
|
|
}else{
|
ElMessage.warning('暂无数据')
|
}
|
}else{
|
ElMessage.warning(res.message)
|
}
|
}
|
|
// 频度文本转换
|
function getFrequencyText(frequency) {
|
switch(frequency) {
|
case 1: return '工作日';
|
case 2: return '1次/3月';
|
case 3: return '1次/6月';
|
default: return '';
|
}
|
}
|
|
// 样式定义
|
const headerStyle = {
|
font: { bold: true, color: { rgb: 'FFFFFF' } },
|
fill: { fgColor: { rgb: '4472C4' } },
|
alignment: { horizontal: 'center', 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' } }
|
}
|
};
|
|
const mergedHeaderStyle = {
|
...headerStyle,
|
fill: { fgColor: { rgb: '70AD47' } }
|
};
|
|
const subHeaderStyle = {
|
font: { bold: true },
|
fill: { fgColor: { rgb: 'B4C6E7' } },
|
alignment: { horizontal: 'center', vertical: 'center' },
|
border: headerStyle.border
|
};
|
|
const dataStyle = {
|
alignment: { horizontal: 'center', vertical: 'center' },
|
border: headerStyle.border
|
};
|
|
const subDataStyle = {
|
font: { bold: true },
|
fill: { fgColor: { rgb: 'E2EFDA' } },
|
alignment: { horizontal: 'center', vertical: 'center' },
|
border: headerStyle.border
|
};
|
|
const monthStyle = {
|
alignment: { horizontal: 'center', vertical: 'center' },
|
border: headerStyle.border
|
};
|
|
const noteStyle = {
|
font: { italic: true, sz: 11 },
|
alignment: { horizontal: 'left', vertical: 'center', wrapText: true },
|
border: {
|
top: { style: 'thin', color: { rgb: '000000' } },
|
bottom: { style: 'thin', color: { rgb: '000000' } }
|
}
|
};
|
|
const footerHeaderStyle = {
|
...headerStyle,
|
fill: { fgColor: { rgb: 'D9D9D9' } },
|
font: { bold: true, color: { rgb: '000000' } }
|
};
|
|
const footerDataStyle = {
|
...dataStyle,
|
font: { bold: true },
|
alignment: { horizontal: 'center' }
|
};
|
|
|
const openDialog = (type, value) => {
|
dialogRef.value.openDialog(type, value, data.queryParams.companyId, data.isAdmin, data.companyList);
|
}
|
|
/** 重置新增的表单以及其他数据 */
|
const reset= async()=> {
|
data.queryParams = {
|
pageNum: 1,
|
pageSize: 10,
|
companyId: null
|
}
|
await getCompanyList()
|
await getList()
|
}
|
const handleDelete = (val) => {
|
ElMessageBox.confirm(
|
'确定删除此条数据？',
|
'提示',
|
{
|
confirmButtonText: '确定',
|
cancelButtonText: '取消',
|
type: 'warning',
|
})
|
.then( async() => {
|
const res = await delMaintenancePlan({id: val.id})
|
if(res.code == 200){
|
ElMessage.success('数据删除成功')
|
await getList()
|
}else{
|
ElMessage.warning(res.message)
|
}
|
})
|
}
|
|
</script>
|
