src/api/basicData/product.js

@@ -56,3 +56,11 @@
        params: query
    })
}
// 下载产品导入模板
export function downloadTemplate() {
    return request({
        url: '/basic/product/downloadTemplate',
        method: 'get',
        responseType: 'blob'
    })
}

 src/views/basicData/product/index.vue

@@ -1,7 +1,7 @@
<template>
  <div class="app-container product-view">
    <div class="left">
      <div>
      <div class="left-header">
        <el-input
          v-model="search"
          style="width: 210px"
@@ -11,12 +11,17 @@
          clearable
          prefix-icon="Search"
        />
        <el-button
          type="primary"
          @click="openProDia('addOne')"
          style="margin-left: 10px"
          >新增产品大类</el-button
        >
        <div class="button-group">
          <el-button
            type="primary"
            @click="openProDia('addOne')"
          >新增产品大类</el-button>
          <el-button
            type="success"
            @click="handleImport"
            icon="Upload"
          >导入</el-button>
        </div>
      </div>
      <div ref="containerRef">
        <el-tree
@@ -124,8 +129,7 @@
        </div>
      </template>
    </el-dialog>
    <el-dialog
      v-model="modelDia"
    <el-dialog v-model="modelDia"
      title="规格型号"
      width="400px"
      @close="closeModelDia"
@@ -152,7 +156,7 @@
        </el-row>
        <el-row>
          <el-col :span="24">
            <el-form-item label="图纸编号：" prop="unit">
            <el-form-item label="图纸编号：" prop="drawingNumber">
              <el-input
                  v-model="modelForm.drawingNumber"
                  placeholder="请输入图纸编号"
@@ -174,11 +178,59 @@
            </el-form-item>
          </el-col>
        </el-row>
        <el-row>
          <el-col :span="24">
            <el-form-item label="产品类型：" prop="productType">
              <el-select
                v-model="modelForm.productType"
                placeholder="请选择产品类型"
                clearable
                style="width: 100%"
              >
                <el-option label="物料" :value="1" />
                <el-option label="产品" :value="2" />
              </el-select>
            </el-form-item>
          </el-col>
        </el-row>
      </el-form>
      <template #footer>
        <div class="dialog-footer">
          <el-button type="primary" @click="submitModelForm">确认</el-button>
          <el-button @click="closeModelDia">取消</el-button>
        </div>
      </template>
    </el-dialog>
    <el-dialog v-model="importDia" title="产品导入" width="600px">
      <el-upload
        ref="importUploadRef"
        :limit="1"
        accept=".xlsx,.xls"
        :action="importUpload.url"
        :headers="importUpload.headers"
        :before-upload="importUpload.beforeUpload"
        :on-success="importUpload.onSuccess"
        :on-error="importUpload.onError"
        :on-progress="importUpload.onProgress"
        :on-change="importUpload.onChange"
        :auto-upload="false"
        drag
      >
        <i class="el-icon-upload"></i>
        <div class="el-upload__text">
          将文件拖到此处，或<em>点击上传</em>
        </div>
        <template #tip>
          <div class="el-upload__tip">
            仅支持 xls/xlsx，大小不超过 10MB。
            <el-button link type="primary" @click="importTemplate">下载导入模板</el-button>
          </div>
        </template>
      </el-upload>
      <template #footer>
        <div class="dialog-footer">
          <el-button type="primary" @click="submitImport">确认导入</el-button>
          <el-button @click="importDia = false">取消</el-button>
        </div>
      </template>
    </el-dialog>
@@ -188,6 +240,8 @@
<script setup>
import { ref } from "vue";
import { ElMessageBox } from "element-plus";
import { getToken } from "@/utils/auth.js";
import { FileUpload } from "@/components/Upload";
import {
  addOrEditProduct,
  addOrEditProductModel,
@@ -195,15 +249,18 @@
  delProductModel,
  modelListPage,
  productTreeList,
  downloadTemplate,
} from "@/api/basicData/product.js";
import ImportExcel from "./ImportExcel/index.vue";

const { proxy } = getCurrentInstance();
const tree = ref(null);
const containerRef = ref(null);
const importUploadRef = ref(null);

const productDia = ref(false);
const modelDia = ref(false);
const importDia = ref(false);
const modelOperationType = ref("");
const search = ref("");
const currentId = ref("");
@@ -224,6 +281,12 @@
  {
    label: "单位",
    prop: "unit",
  },
  {
    label: "产品类型",
    prop: "productType",
    width: 100,
    formatData: (v) => ({ "1": "物料", "2": "产品" }[String(v)] ?? v),
  },
  {
    dataType: "action",
@@ -263,14 +326,63 @@
    model: "",
    unit: "",
    drawingNumber: "",
    productType: "",
  },
  modelRules: {
    model: [{ required: true, message: "请输入", trigger: "blur" }],
    unit: [{ required: true, message: "请输入", trigger: "blur" }],
    drawingNumber: [{ required: true, message: "请输入", trigger: "blur" }],
    productType: [{ required: true, message: "请选择", trigger: "change" }],
  },
});
const { form, rules, modelForm, modelRules } = toRefs(data);

const importUpload = reactive({
  title: "产品导入",
  open: false,
  url: import.meta.env.VITE_APP_BASE_API + "/basic/product/import",
  headers: { Authorization: "Bearer " + getToken() },
  isUploading: false,
  beforeUpload: (file) => {
    const isExcel = file.name.endsWith('.xlsx') || file.name.endsWith('.xls');
    const isLt10M = file.size / 1024 / 1024 < 10;
    if (!isExcel) {
      proxy.$modal.msgError("上传文件只能是 xlsx/xls 格式!");
      return false;
    }
    if (!isLt10M) {
      proxy.$modal.msgError("上传文件大小不能超过 10MB!");
      return false;
    }
    return true;
  },
  onChange: (file, fileList) => {
    console.log('文件状态改变', file, fileList);
  },
  onProgress: (event, file, fileList) => {
    console.log('上传中...', event.percent);
  },
  onSuccess: (response, file, fileList) => {
    console.log('上传成功', response, file, fileList);
    importUpload.isUploading = false;
    if (response.code === 200) {
      proxy.$modal.msgSuccess("导入成功");
      importDia.value = false;
      if (importUploadRef.value) {
        importUploadRef.value.clearFiles();
      }
      getProductTreeList();
    } else {
      proxy.$modal.msgError(response.msg || "导入失败");
    }
  },
  onError: (error, file, fileList) => {
    console.log('上传失败', error, file, fileList);
    importUpload.isUploading = false;
    proxy.$modal.msgError("导入失败");
  }
});

// 查询产品树
const getProductTreeList = () => {
  treeLoad.value = true;
@@ -305,6 +417,7 @@
  modelDia.value = true;
  modelForm.value.model = "";
  modelForm.value.id = "";
  modelForm.value.productType = "";
  if (type === "edit") {
    modelForm.value = { ...data };
  }
@@ -478,6 +591,22 @@
  // 没匹配到返回false
  return false;
};

const handleImport = () => {
  importDia.value = true;
  if (importUploadRef.value) {
    importUploadRef.value.clearFiles();
  }
};

const submitImport = () => {
  importUploadRef.value.submit();
};

const importTemplate = () => {
  proxy.download("/basic/product/downloadTemplate", {}, "产品导入模板.xlsx");
};

getProductTreeList();
</script>

@@ -491,6 +620,16 @@
  padding: 16px;
  background: #ffffff;
}
.left-header {
  display: flex;
  align-items: center;
  justify-content: space-between;
  margin-bottom: 16px;
}
.button-group {
  display: flex;
  gap: 10px;
}
.right {
  flex: 1;
  min-width: 0;