提交工艺路线的表格触底加载

CD配唱片

2025-04-24 b0e84af3dafe8984b69858c4420b5611c9b58f30

 src/views/basicData/processRoute/index.vue

@@ -1,9 +1,14 @@
<template>
  <div class="app-container">
    <el-form :model="queryParams" ref="queryRef" :inline="true" v-show="showSearch" label-width="90px">
    <el-form
      :model="queryParams"
      ref="queryRef"
      :inline="true"
      v-show="showSearch"
      label-width="90px"
    >
      <el-row :gutter="20">
        <el-col
        :span="6">
        <el-col :span="6">
      <el-form-item label="集成日期" style="width: 308px">
        <el-date-picker
          v-model="daterangeIntegrationDay"
@@ -15,8 +20,7 @@
        ></el-date-picker>
      </el-form-item>
        </el-col>
        <el-col
        :span="6">
        <el-col :span="6">
      <el-form-item label="料号" prop="itemNo">
            <el-input
              v-model="queryParams.itemNo"
@@ -26,11 +30,11 @@
            />
          </el-form-item>
        </el-col>
        <el-col
          :span="12"
          style="text-align: right;">
        <el-col :span="12" style="text-align: right">
      <el-form-item>
        <el-button type="primary" icon="Search" @click="handleQuery">搜索</el-button>
            <el-button type="primary" icon="Search" @click="handleQuery"
              >搜索</el-button
            >
        <el-button icon="Refresh" @click="resetQuery">重置</el-button>
      </el-form-item>
        </el-col>
@@ -45,7 +49,8 @@
          icon="Upload" 
          @click="handleImport" 
          v-hasPermi="['processRoute:processRoute:importData']"
          >导入</el-button>
          >导入</el-button
        >
      </el-col>
      <el-col :span="1.5">
        <el-button
@@ -54,25 +59,39 @@
          icon="Download"
          @click="handleExport"
          v-hasPermi="['processRoute:processRoute:export']"
        >导出</el-button>
          >导出</el-button
        >
      </el-col>
      <right-toolbar v-model:showSearch="showSearch" @queryTable="getList"></right-toolbar>
      <right-toolbar
        v-model:showSearch="showSearch"
        @queryTable="getList"
      ></right-toolbar>
    </el-row>
    <HxlhTable
        style="width: 100%"
        :columns="columns"
      :virtualYConfig="virtualYConfig"
        :data="processRouteList"
        :loading="loading"
        :height="height"
      @bottomAutoLoadMore="handleAutoLoadMore"
        @on-checkbox="handleCheckboxChange"
    >
    </HxlhTable>
  <!-- 用户导入对话框 -->
  <el-dialog :title="upload.title" v-model="upload.open" width="90%" append-to-body @close="dialogCancel">
    <el-dialog
      :title="upload.title"
      v-model="upload.open"
      width="90%"
      append-to-body
      @close="dialogCancel"
    >
      <el-row :gutter="10">
        <el-col>
          <div style="border-bottom: 1px solid #ccc;" >
            <p>上传Excel文件，包含工艺路线信息。系统将解析数据并保存到本地，用于关联到零件计划中。</p>
          <div style="border-bottom: 1px solid #ccc">
            <p>
              上传Excel文件，包含工艺路线信息。系统将解析数据并保存到本地，用于关联到零件计划中。
            </p>
          </div>
        </el-col>
        <el-col >
@@ -80,13 +99,25 @@
        </el-col>
      </el-row>

      <el-row :gutter="10" style="margin-top: 20px;">
      </el-row>
      <el-row :gutter="10" style="margin-top: 20px"> </el-row>
      <el-row>
        <el-col>
          <el-upload ref="uploadRef" :limit="1" accept=".xlsx, .xls" :headers="upload.headers" :action="upload.url + '?updateSupport=' + upload.updateSupport" :disabled="upload.isUploading" :on-progress="handleFileUploadProgress" :on-success="handleFileSuccess" :auto-upload="true" drag>
          <el-upload
            ref="uploadRef"
            :limit="1"
            accept=".xlsx, .xls"
            :headers="upload.headers"
            :action="upload.url + '?updateSupport=' + upload.updateSupport"
            :disabled="upload.isUploading"
            :on-progress="handleFileUploadProgress"
            :on-success="handleFileSuccess"
            :auto-upload="true"
            drag
          >
            <el-icon class="el-icon--upload"><upload-filled /></el-icon>
            <div class="el-upload__text">将文件拖到此处，或<em>点击上传</em></div>
            <div class="el-upload__text">
              将文件拖到此处，或<em>点击上传</em>
            </div>
            <template #tip>
              <div class="el-upload__tip">
                <span>仅允许导入xls、xlsx格式文件。</span>
@@ -96,12 +127,24 @@
        </el-col>
      </el-row>
      <el-row>
        <el-col style="margin-top: 20px;">
        <el-col style="margin-top: 20px">
          <div v-show="isVisible">
            <el-alert icon="Check" :show-icon="true" title="工艺路线数据已成功解析" type="success" :closable="false"/>
            <el-alert
              icon="Check"
              :show-icon="true"
              title="工艺路线数据已成功解析"
              type="success"
              :closable="false"
            />
          </div>
          <div v-show="isError">
            <el-alert icon="Close" :show-icon="true" title="工艺路线数据已解析失败" type="error" :closable="false"/>
            <el-alert
              icon="Close"
              :show-icon="true"
              title="工艺路线数据已解析失败"
              type="error"
              :closable="false"
            />
          </div>
        </el-col>
      </el-row>
@@ -121,8 +164,11 @@
          </HxlhTable>
        </el-col>
        <el-col>
          <div style="text-align: right;">
            <h4>共上传<span style="color: blue;">{{ total }}</span>条工艺路线数据</h4>
          <div style="text-align: right">
            <h4>
              共上传<span style="color: blue">{{ total }}</span
              >条工艺路线数据
            </h4>
          </div>
        </el-col>
      </el-row>
@@ -135,7 +181,8 @@
            :disabled="planned"
            @click="uploadParse"
            v-hasPermi="['processRoute:processRoute:confirmProcessRoute']"
          >确认上传</el-button>
            >确认上传</el-button
          >
          <el-button @click="dialogCancel">取 消</el-button>
        </div>
      </template>
@@ -144,11 +191,19 @@
</template>

<script setup name="ProcessRoute">
import { listProcessRoute, getProcessRoute, delProcessRoute, addProcessRoute, updateProcessRoute,processRouteTempList,confirmProcessRoute } from "@/api/basicData/processRoute";
import HxlhTable from '@/components/HxlhTable'
import {
  listProcessRoute,
  getProcessRoute,
  delProcessRoute,
  addProcessRoute,
  updateProcessRoute,
  processRouteTempList,
  confirmProcessRoute,
} from "@/api/basicData/processRoute";
import HxlhTable from "@/components/HxlhTable";
import { getToken } from "@/utils/auth";
import { ref } from "vue";
import { ElMessage } from 'element-plus'
import { ElMessage } from "element-plus";
const { proxy } = getCurrentInstance();

const processRouteList = ref([]);
@@ -162,7 +217,7 @@
const title = ref("");
const daterangeIntegrationDay = ref([]);
//弹窗相关
const height = ref(document.documentElement.clientHeight - 260 + "px;")
const height = ref(document.documentElement.clientHeight - 260 + "px;");
const isVisible = ref(false);
const isError = ref(false);
const planned = ref(true);
@@ -170,6 +225,11 @@
const exampleHeight = ref("500px");
const uploadRef = ref();
const exampleList = ref([]);
const virtualYConfig = {
  enabled: true,
  gt: 0,
  threshold: 50,
};
/*** 用户导入参数 */
const upload = reactive({
  // 是否显示弹出层（用户导入）
@@ -183,152 +243,152 @@
  // 设置上传的请求头部
  headers: { Authorization: "Bearer " + getToken() },
  // 上传的地址
  url: import.meta.env.VITE_APP_BASE_API + "/aps/processRoute/importData"
  url: import.meta.env.VITE_APP_BASE_API + "/aps/processRoute/importData",
});
// 表格配置-列表 
const columns = ref([
  { type: 'checkbox', width: 60, align:"center"},
  { type: 'seq', title: '序号', width: 60 },
  { type: "checkbox", width: 60, align: "center" },
  { type: "seq", title: "序号", width: 60 },
  {
    title: '料号',
    field: 'itemNo',
    title: "料号",
    field: "itemNo",
    width: 150,
    align:"center",
  },
  {
    title: '工单号',
    field: 'workOrderNo',
    title: "工单号",
    field: "workOrderNo",
    width: 150,
    align:"center",
  },
  {
    title: '工序序号',
    field: 'processNumber',
    title: "工序序号",
    field: "processNumber",
    width: 100,
    align:"center",
  },
  {
    title: '工序名称',
    field: 'processName',
    title: "工序名称",
    field: "processName",
    width: 150,
    align:"center",
  },
  {
    title: '工序计划开始日期',
    field: 'processPlanStartDay',
    title: "工序计划开始日期",
    field: "processPlanStartDay",
    width: 200,
    align:"center",
  },
  {
    title: '工序计划结束日期',
    field: 'processPlanEndDay',
    title: "工序计划结束日期",
    field: "processPlanEndDay",
    width: 200,
    align:"center",
  },
  {
    title: '未开工数量',
    field: 'notStartWorkCount',
    title: "未开工数量",
    field: "notStartWorkCount",
    width: 90,
    align:"center",
  },
  {
    title: '已完成数量',
    field: 'completedCount',
    title: "已完成数量",
    field: "completedCount",
    width: 90,
    align:"center",
  },
  {
    title: '废弃数量',
    field: 'discardCount',
    title: "废弃数量",
    field: "discardCount",
    width: 90,
    align:"center",
  },
  {
    title: '标准工时',
    field: 'standardTime',
    title: "标准工时",
    field: "standardTime",
    width: 90,
    align:"center",
  },
  {
    title: '工序排序',
    field: 'processOrder',
    title: "工序排序",
    field: "processOrder",
    width: 90,
    align:"center",
  },
  {
    title: '集成日期',
    field: 'integrationDay',
    title: "集成日期",
    field: "integrationDay",
    width: 160,
    align:"center",
  }
  },
]);

// 表格配置-弹窗
const exampleColumns = ref([
  { type: 'seq', title: '序号', width: 60 },
  { type: "seq", title: "序号", width: 60 },
  {
    title: '料号',
    field: 'itemNo',
    title: "料号",
    field: "itemNo",
    width: 150,
    align:"center",
  },
  {
    title: '工单号',
    field: 'workOrderNo',
    title: "工单号",
    field: "workOrderNo",
    width: 150,
    align:"center",
  },
  {
    title: '工序序号',
    field: 'processNumber',
    title: "工序序号",
    field: "processNumber",
    width: 85,
    align:"center",
  },
  {
    title: '工序名称',
    field: 'processName',
    title: "工序名称",
    field: "processName",
    width: 150,
    align:"center",
  },
  {
    title: '工序计划开始日期',
    field: 'processPlanStartDay',
    title: "工序计划开始日期",
    field: "processPlanStartDay",
    width: 200,
    align:"center",
  },
  {
    title: '工序计划结束日期',
    field: 'processPlanEndDay',
    title: "工序计划结束日期",
    field: "processPlanEndDay",
    width: 200,
    align:"center",
  },
  {
    title: '未开工数量',
    field: 'notStartWorkCount',
    title: "未开工数量",
    field: "notStartWorkCount",
    width: 140,
    align:"center",
  },
  {
    title: '已完成数量',
    field: 'completedCount',
    title: "已完成数量",
    field: "completedCount",
    width: 140,
    align:"center",
  },
  {
    title: '废弃数量',
    field: 'discardCount',
    title: "废弃数量",
    field: "discardCount",
    width: 140,
    align:"center",
  },
  {
    title: '标准工时',
    field: 'standardTime',
    title: "标准工时",
    field: "standardTime",
    width: 140,
    align:"center",
  },
  {
    title: '工序排序',
    field: 'processOrder',
    title: "工序排序",
    field: "processOrder",
    width: 140,
    align:"center",
  },
@@ -343,12 +403,11 @@
  form: {},
  queryParams: {
    pageNum: 1,
    pageSize: 10,
    pageSize: 10000,
    itemNo: null,
    integrationDay: null,
  },
  rules: {
  }
  rules: {},
});

const { queryParams, form, rules } = toRefs(data);
@@ -357,17 +416,23 @@
function getList() {
  loading.value = true;
  queryParams.value.params = {};
  if (null != daterangeIntegrationDay && '' != daterangeIntegrationDay) {
    queryParams.value.params["beginIntegrationDay"] = daterangeIntegrationDay.value[0];
    queryParams.value.params["endIntegrationDay"] = daterangeIntegrationDay.value[1];
  if (null != daterangeIntegrationDay && "" != daterangeIntegrationDay) {
    queryParams.value.params["beginIntegrationDay"] =
      daterangeIntegrationDay.value[0];
    queryParams.value.params["endIntegrationDay"] =
      daterangeIntegrationDay.value[1];
  }
  listProcessRoute(queryParams.value).then(response => {
  listProcessRoute(queryParams.value).then((response) => {
    processRouteList.value = response.rows;
    total.value = response.total;
    loading.value = false;
  });
}

function handleAutoLoadMore(){
  queryParams.value.pageNum++;
  getList();
}
// 取消按钮
function cancel() {
  open.value = false;
@@ -396,7 +461,7 @@
    createBy: null,
    createTime: null,
    updateBy: null,
    updateTime: null
    updateTime: null,
  };
  proxy.resetForm("processRouteRef");
}
@@ -416,7 +481,7 @@

// 多选框选中数据
function handleSelectionChange(selection) {
  ids.value = selection.map(item => item.id);
  ids.value = selection.map((item) => item.id);
  single.value = selection.length != 1;
  multiple.value = !selection.length;
}
@@ -431,8 +496,8 @@
/** 修改按钮操作 */
function handleUpdate(row) {
  reset();
  const _id = row.id || ids.value
  getProcessRoute(_id).then(response => {
  const _id = row.id || ids.value;
  getProcessRoute(_id).then((response) => {
    form.value = response.data;
    open.value = true;
    title.value = "修改工艺路线";
@@ -441,16 +506,16 @@

/** 提交按钮 */
function submitForm() {
  proxy.$refs["processRouteRef"].validate(valid => {
  proxy.$refs["processRouteRef"].validate((valid) => {
    if (valid) {
      if (form.value.id != null) {
        updateProcessRoute(form.value).then(response => {
        updateProcessRoute(form.value).then((response) => {
          proxy.$modal.msgSuccess("修改成功");
          open.value = false;
          getList();
        });
      } else {
        addProcessRoute(form.value).then(response => {
        addProcessRoute(form.value).then((response) => {
          proxy.$modal.msgSuccess("新增成功");
          open.value = false;
          getList();
@@ -463,25 +528,32 @@
/** 删除按钮操作 */
function handleDelete(row) {
  const _ids = row.id || ids.value;
  proxy.$modal.confirm('是否确认删除工艺路线编号为"' + _ids + '"的数据项？').then(function() {
  proxy.$modal
    .confirm('是否确认删除工艺路线编号为"' + _ids + '"的数据项？')
    .then(function () {
    return delProcessRoute(_ids);
  }).then(() => {
    })
    .then(() => {
    getList();
    proxy.$modal.msgSuccess("删除成功");
  }).catch(() => {});
    })
    .catch(() => {});
}
/** 导入按钮操作 */
function handleImport() {
  upload.title = "工艺路线数据上传";
  upload.open = true;
};
}
/** 导出按钮操作 */
function handleExport() {
  proxy.download('aps/processRoute/export', {
    ...queryParams.value
  }, `processRoute_${new Date().getTime()}.xlsx`)
  proxy.download(
    "aps/processRoute/export",
    {
      ...queryParams.value,
    },
    `processRoute_${new Date().getTime()}.xlsx`
  );
}


/**文件上传中处理 */
const handleFileUploadProgress = (event, file, fileList) => {
@@ -490,7 +562,7 @@

/** 文件上传成功处理 */
const handleFileSuccess = (response, file, fileList) => {
  if(response.code == '200'){
  if (response.code == "200") {
    batchNumber.value = response.data;
    isVisible.value = true;
    planned.value = false;
@@ -498,7 +570,13 @@
    getExampleList();
  }else{
    isError.value = true;
    proxy.$alert("<div style='overflow: auto;overflow-x: hidden;max-height: 70vh;padding: 10px 20px 0;'>" + response.msg + "</div>", "导入结果", { dangerouslyUseHTMLString: true });
    proxy.$alert(
      "<div style='overflow: auto;overflow-x: hidden;max-height: 70vh;padding: 10px 20px 0;'>" +
        response.msg +
        "</div>",
      "导入结果",
      { dangerouslyUseHTMLString: true }
    );
  }
  proxy.$refs["uploadRef"].handleRemove(file);
  upload.isUploading = false;
@@ -508,7 +586,7 @@
  loading.value = true;
  queryParams.value = {};
  queryParams.value.batchNumber = batchNumber.value;
  processRouteTempList(queryParams.value).then(response => {
  processRouteTempList(queryParams.value).then((response) => {
    exampleList.value = response.rows;
    total.value = response.total;
    loading.value = false;
@@ -518,7 +596,7 @@
function uploadParse() {
  queryParams.value.params = {};
  queryParams.value.params["batchNumber"] = batchNumber.value;
  confirmProcessRoute(queryParams.value).then(response => {
  confirmProcessRoute(queryParams.value).then((response) => {
    exampleList.value = response.rows;
    loading.value = false;
    isVisible.value = false;
@@ -526,9 +604,9 @@
    planned.value = true;
    upload.open = false;
    ElMessage({
      message: '工艺路线数据已成功上传和解析',
      type: 'success',
    })
      message: "工艺路线数据已成功上传和解析",
      type: "success",
    });
    getList();
  });
}