From 1c0d6aaa846c152b3832c7279d1083fde02089b7 Mon Sep 17 00:00:00 2001
From: zhouwx <1175765986@qq.com>
Date: 星期五, 22 八月 2025 15:32:46 +0800
Subject: [PATCH] 修改
---
src/views/work/qualityInfo/inventoryRecord/index.vue | 338 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 338 insertions(+), 0 deletions(-)
diff --git a/src/views/work/qualityInfo/inventoryRecord/index.vue b/src/views/work/qualityInfo/inventoryRecord/index.vue
new file mode 100644
index 0000000..b4edb91
--- /dev/null
+++ b/src/views/work/qualityInfo/inventoryRecord/index.vue
@@ -0,0 +1,338 @@
+<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 >
+ <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="recordName" align="center" label="记录名称" v-if="isAdmin"></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 {
+ delWarehousingRecord,
+ getWarehousingRecordDetail,
+ getWarehousingRecordList
+} from "@/api/outsourcingCooperate/outsourcingCooperate";
+
+
+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: [],
+ isAdmin: false,
+});
+
+const { queryParams, total, dataList,companyList, isAdmin } = 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 getWarehousingRecordList(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 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: 'remark' }
+ ];
+
+ // 样式定义
+ const headerStyle = {
+ font: { bold: true, sz: 12, color: { rgb: "000000" } },
+ fill: { fgColor: { rgb: "CCCCCC" } },
+ 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 subHeaderStyle = {
+ font: { bold: true, sz: 11, color: { rgb: "000000" } },
+ fill: { fgColor: { rgb: "CCCCCC" } },
+ 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 dataStyle = {
+ font: { sz: 11 },
+ alignment: { 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 titleStyle = {
+ font: { bold: true, sz: 16, color: { rgb: "2C3E50" } },
+ alignment: { horizontal: "center", vertical: "center" }
+ };
+
+ // 处理数据，添加序号
+ const processData = () => {
+ return jsonData.warehousingRecordDetails.map((item, index) => {
+ return {
+ index: index + 1,
+ ...item
+ };
+ });
+ };
+
+ // 创建工作簿
+ const wb = utils.book_new();
+ const wsData = [];
+
+ // 添加标题行（合并所有列）
+ const titleRow = [{
+ v: jsonData.recordName,
+ t: 's',
+ s: titleStyle
+ }];
+ // 填充空单元格以匹配列数
+ for (let i = 1; i < columns.length; i++) {
+ titleRow.push({ v: '', t: 's', s: titleStyle });
+ }
+ wsData.push(titleRow);
+
+ // 添加上层表头行（包含"入库"和"出库"合并标题）
+ const topHeaderRow = [
+ { v: '序号', t: 's', s: headerStyle }, // 序号
+ { v: '登记时间', t: 's', s: headerStyle }, // 登记时间
+ { v: '名称', t: 's', s: headerStyle }, // 名称
+ { v: '入库', t: 's', s: headerStyle }, // 入库（将合并3列）
+ { v: '', t: 's', s: headerStyle }, // 占位
+ { v: '', t: 's', s: headerStyle }, // 占位
+ { v: '出库', t: 's', s: headerStyle }, // 出库（将合并3列）
+ { v: '', t: 's', s: headerStyle }, // 占位
+ { v: '', t: 's', s: headerStyle }, // 占位
+ { v: '库存数量', t: 's', s: headerStyle }, // 库存数量
+ { v: '备注', t: 's', s: headerStyle } // 备注
+ ];
+ wsData.push(topHeaderRow);
+
+ // 添加下层表头行（具体字段名称）
+ const bottomHeaderRow = columns.map(col => ({
+ v: col.label,
+ t: 's',
+ s: subHeaderStyle
+ }));
+ wsData.push(bottomHeaderRow);
+
+ // 添加数据行
+ 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
+ }));
+ wsData.push(row);
+ });
+
+ // 创建工作表
+ const ws = utils.aoa_to_sheet(wsData);
+
+ // 设置合并单元格
+ const merges = [
+ // 标题行合并
+ { s: { r: 0, c: 0 }, e: { r: 0, c: columns.length - 1 } },
+ // 入库标题合并（第1行，第3-5列）
+ { s: { r: 1, c: 3 }, e: { r: 1, c: 5 } },
+ // 出库标题合并（第1行，第6-8列）
+ { s: { r: 1, c: 6 }, e: { r: 1, c: 8 } },
+ // 序号、登记时间、名称跨行合并（第1-2行）
+ { s: { r: 1, c: 0 }, e: { r: 2, c: 0 } },
+ { s: { r: 1, c: 1 }, e: { r: 2, c: 1 } },
+ { s: { r: 1, c: 2 }, e: { r: 2, c: 2 } },
+ // 库存数量、备注跨行合并（第1-2行）
+ { s: { r: 1, c: 9 }, e: { r: 2, c: 9 } },
+ { s: { r: 1, c: 10 }, e: { r: 2, c: 10 } }
+ ];
+
+ 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 } // 备注
+ ];
+ ws['!cols'] = colWidths;
+
+ // 添加工作表到工作簿
+ utils.book_append_sheet(wb, ws, jsonData.recordName);
+
+ // 生成Excel文件并下载
+ writeFile(wb, `${jsonData.recordName}.xlsx`);
+ } else {
+ ElMessage.warning('暂无数据')
+ }
+ } else {
+ ElMessage.warning(res.message)
+ }
+}
+
+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 delWarehousingRecord({id: val.id})
+ if(res.code == 200){
+ ElMessage.success('数据删除成功')
+ await getList()
+ }else{
+ ElMessage.warning(res.message)
+ }
+ })
+}
+
+</script>
--
Gitblit v1.9.2