钣金计划上传页面

bluejay

2025-04-14 a07bd2102524d610589c174a33c34e03b79deae2

钣金计划上传页面

 src/api/ApsPlatePlan/ApsPlatePlan.js

@@ -3,7 +3,7 @@
// 查询钣金计划管理列表
export function listPlan(query) {
  return request({
    url: '/aps/ApsPlatePlan/list',
    url: '/aps/apsPlatePlan/list',
    method: 'get',
    params: query
  })
@@ -51,3 +51,20 @@
    data: data
  })
}
// 查询零件计划管理列表
export function examplePlan(query) {
  return request({
    url: '/aps/apsPlatePlanTemp/list',
    method: 'get',
    params: query
  })
}

// 查询零件计划管理列表
export function confirmPart(data) {
  return request({
    url: '/aps/apsPlatePlan/confirmPart',
    method: 'post',
    data: data
  })
}

 src/views/ApsPlatePlan/index.vue

@@ -2,7 +2,9 @@
  <div class="app-container">
    <el-row :gutter="20"> <el-col>
    <el-form :model="queryParams" ref="queryRef" :inline="true" v-show="showSearch" label-width="90px">
        <el-form-item label="计划开工日" style="width: 350px">
      <el-row :gutter="20">
        <el-col :span="6">
          <el-form-item label="计划开工日" style="width: 100%;">
          <el-date-picker
              v-model="daterangePlanStartDay"
              value-format="YYYY-MM-DD"
@@ -12,7 +14,9 @@
              end-placeholder="结束日期"
          ></el-date-picker>
        </el-form-item>
        <el-form-item label="计划完工日" style="width: 350px">
        </el-col>
        <el-col :span="6">
        <el-form-item label="计划完工日" style="width: 100%;">
          <el-date-picker
              v-model="daterangePlanEndDay"
              value-format="YYYY-MM-DD"
@@ -22,7 +26,9 @@
              end-placeholder="结束日期"
          ></el-date-picker>
        </el-form-item>
        <el-form-item label="单据号" prop="documentNumber">
        </el-col>
        <el-col :span="6">
        <el-form-item label="单据号" prop="documentNumber" style="width: 100%;">
          <el-input
              v-model="queryParams.documentNumber"
              placeholder="请输入单据号"
@@ -30,7 +36,9 @@
              @keyup.enter="handleQuery"
          />
        </el-form-item>
        <el-form-item label="客户名称" prop="customer">
        </el-col>
        <el-col :span="6">
        <el-form-item label="客户名称" prop="customer" style="width: 100%;">
          <el-input
              v-model="queryParams.customer"
              placeholder="请输入客户名称"
@@ -38,10 +46,14 @@
              @keyup.enter="handleQuery"
          />
        </el-form-item>
        </el-col>
        <el-col  :span="24"  style="text-align: right;">
        <el-form-item>
          <el-button type="primary" icon="Search" @click="handleQuery">搜索</el-button>
          <el-button icon="Refresh" @click="resetQuery">重置</el-button>
        </el-form-item>
        </el-col>
      </el-row>
      </el-form>
    </el-col> </el-row>
    <el-row :gutter="10" class="mb8">
@@ -52,7 +64,7 @@
            icon="Plus"
            :disabled="single"
            @click="handleUpdate"
            v-hasPermi="['ApsPlatePlan:ApsPlatePlan:edit']"
            v-hasPermi="['apsPlatePlan:edit']"
        >批量修改计划开工日</el-button>
      </el-col>
      <el-col :span="1.5">
@@ -62,7 +74,7 @@
            icon="Edit"
            :disabled="single"
            @click="handleUpdate"
            v-hasPermi="['ApsPlatePlan:ApsPlatePlan:edit']"
            v-hasPermi="['apsPlatePlan:edit']"
        >批量修改计划完工日</el-button>
      </el-col>
      <el-col :span="1.5">
@@ -71,7 +83,7 @@
            plain
            icon="Upload"
            @click="handleImport"
            v-hasPermi="['ApsPlatePlan:ApsPlatePlan:edit']"
            v-hasPermi="['apsPlatePlan:import']"
        >导入</el-button>
      </el-col>
      <el-col :span="1.5">
@@ -80,7 +92,7 @@
          plain
          icon="Download"
          @click="handleExport"
          v-hasPermi="['ApsPlatePlan:ApsPlatePlan:export']"
          v-hasPermi="['apsPlatePlan:export']"
        >导出</el-button>
      </el-col>
      <right-toolbar v-model:showSearch="showSearch" @queryTable="getList"></right-toolbar>
@@ -97,167 +109,84 @@
    </HxlhTable>

    <!-- 添加或修改钣金计划管理对话框 -->
    <el-dialog :title="title" v-model="open" width="500px" append-to-body>
<!--    <el-dialog :title="title" width="500px" append-to-body>-->
      <el-form ref="ApsPlatePlanRef" :model="form" :rules="rules" label-width="80px">
        <el-form-item label="主键id" prop="id">
          <el-input v-model="form.id" placeholder="请输入主键id" />
        </el-form-item>
        <el-form-item label="主计划员" prop="masterPlanner">
          <el-input v-model="form.masterPlanner" placeholder="请输入主计划员" />
        </el-form-item>
        <el-form-item label="周日" prop="weekDay">
          <el-date-picker clearable
            v-model="form.weekDay"
            type="date"
            value-format="YYYY-MM-DD"
            placeholder="请选择周日">
          </el-date-picker>
        </el-form-item>
        <el-form-item label="周度" prop="weekCycle">
          <el-input v-model="form.weekCycle" placeholder="请输入周度" />
        </el-form-item>
        <el-form-item label="主件料号" prop="mainPartNumber">
          <el-input v-model="form.mainPartNumber" placeholder="请输入主件料号" />
        </el-form-item>
        <el-form-item label="主件图号" prop="mainPartDrawingNumber">
          <el-input v-model="form.mainPartDrawingNumber" placeholder="请输入主件图号" />
        </el-form-item>
        <el-form-item label="客户名称" prop="customer">
          <el-input v-model="form.customer" placeholder="请输入客户名称" />
        </el-form-item>
        <el-form-item label="业务类型" prop="businessType">
          <el-select v-model="form.businessType" placeholder="请选择业务类型">
            <el-option
              v-for="dict in aps_business_type"
              :key="dict.value"
              :label="dict.label"
              :value="dict.value"
            ></el-option>
          </el-select>
        </el-form-item>
        <el-form-item label="单据号" prop="documentNumber">
          <el-input v-model="form.documentNumber" placeholder="请输入单据号" />
        </el-form-item>
        <el-form-item label="需求分类" prop="requirementType">
          <el-input v-model="form.requirementType" placeholder="请输入需求分类" />
        </el-form-item>
        <el-form-item label="单据状态" prop="documentStatus">
          <el-select v-model="form.documentStatus" placeholder="请选择单据状态">
            <el-option
              v-for="dict in aps_document_status"
              :key="dict.value"
              :label="dict.label"
              :value="dict.value"
            ></el-option>
          </el-select>
        </el-form-item>
        <el-form-item label="料号" prop="itemNumber">
          <el-input v-model="form.itemNumber" placeholder="请输入料号" />
        </el-form-item>
        <el-form-item label="图号" prop="drawingNo">
          <el-input v-model="form.drawingNo" placeholder="请输入图号" />
        </el-form-item>
        <el-form-item label="版本号" prop="versionNumber">
          <el-input v-model="form.versionNumber" placeholder="请输入版本号" />
        </el-form-item>
        <el-form-item label="生产数量" prop="productionQuantity">
          <el-input v-model="form.productionQuantity" placeholder="请输入生产数量" />
        </el-form-item>
        <el-form-item label="良品数量" prop="goodProductsQuantity">
          <el-input v-model="form.goodProductsQuantity" placeholder="请输入良品数量" />
        </el-form-item>
        <el-form-item label="工序号" prop="processNumber">
          <el-input v-model="form.processNumber" placeholder="请输入工序号" />
        </el-form-item>
        <el-form-item label="工作中心" prop="workCenter">
          <el-input v-model="form.workCenter" placeholder="请输入工作中心" />
        </el-form-item>
        <el-form-item label="所属部门" prop="department">
          <el-input v-model="form.department" placeholder="请输入所属部门" />
        </el-form-item>
        <el-form-item label="计划开工日" prop="planStartDay">
          <el-date-picker clearable
            v-model="form.planStartDay"
            type="date"
            value-format="YYYY-MM-DD"
            placeholder="请选择计划开工日">
          </el-date-picker>
        </el-form-item>
        <el-form-item label="计划完工日" prop="planEndDay">
          <el-date-picker clearable
            v-model="form.planEndDay"
            type="date"
            value-format="YYYY-MM-DD"
            placeholder="请选择计划完工日">
          </el-date-picker>
        </el-form-item>
        <el-form-item label="备料料号" prop="standbyNumber">
          <el-input v-model="form.standbyNumber" placeholder="请输入备料料号" />
        </el-form-item>
        <el-form-item label="备料名称" prop="standbyName">
          <el-input v-model="form.standbyName" placeholder="请输入备料名称" />
        </el-form-item>
        <el-form-item label="备料库存" prop="standbyStock">
          <el-input v-model="form.standbyStock" placeholder="请输入备料库存" />
        </el-form-item>
        <el-form-item label="下道工序所属部门" prop="nextProcessDeparment">
          <el-input v-model="form.nextProcessDeparment" placeholder="请输入下道工序所属部门" />
        </el-form-item>
        <el-form-item label="是否挂起" prop="isSuspended">
          <el-select v-model="form.isSuspended" placeholder="请选择是否挂起">
            <el-option
              v-for="dict in aps_is_suspended"
              :key="dict.value"
              :label="dict.label"
              :value="dict.value"
            ></el-option>
          </el-select>
        </el-form-item>
        <el-form-item label="外协标识" prop="isOutsourcing">
          <el-input v-model="form.isOutsourcing" placeholder="请输入外协标识" />
        </el-form-item>
        <el-form-item label="账套" prop="account">
          <el-select v-model="form.account" placeholder="请选择账套">
            <el-option
              v-for="dict in aps_account"
              :key="dict.value"
              :label="dict.label"
              :value="dict.value"
            ></el-option>
          </el-select>
        </el-form-item>
        <el-form-item label="上阶物料" prop="advancedMaterials">
          <el-input v-model="form.advancedMaterials" placeholder="请输入上阶物料" />
        </el-form-item>
        <el-form-item label="上阶单据号" prop="advancedDocumentNumber">
          <el-input v-model="form.advancedDocumentNumber" placeholder="请输入上阶单据号" />
        </el-form-item>
        <el-form-item label="上阶需求日期" prop="advancedRequirementDay">
          <el-date-picker clearable
            v-model="form.advancedRequirementDay"
            type="date"
            value-format="YYYY-MM-DD"
            placeholder="请选择上阶需求日期">
          </el-date-picker>
        </el-form-item>
        <el-form-item label="计划齐套" prop="isPlanComplete">
          <el-input v-model="form.isPlanComplete" placeholder="请输入计划齐套" />
        </el-form-item>
        <el-form-item label="库存齐套" prop="isStockComplete">
          <el-input v-model="form.isStockComplete" placeholder="请输入库存齐套" />
        </el-form-item>
        <el-form-item label="是否有折返工序" prop="hasTurnback">
          <el-input v-model="form.hasTurnback" placeholder="请输入是否有折返工序" />
        </el-form-item>
        <el-form-item label="风险标识" prop="hasRisk">
          <el-input v-model="form.hasRisk" placeholder="请输入风险标识" />
        </el-form-item>
      </el-form>
    <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>
        </el-col>
        <el-col >
          <div></div>
        </el-col>
      </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-icon class="el-icon--upload"><upload-filled /></el-icon>
            <div class="el-upload__text">将文件拖到此处，或<em>点击上传</em></div>
            <template #tip>
              <div class="el-upload__tip">
                <!-- <div class="el-upload__tip">
                  <el-checkbox v-model="upload.updateSupport" />是否更新已经存在的用户数据
                </div> -->
                <span>仅允许导入xls、xlsx格式文件。</span>
                <!-- <el-link type="primary" :underline="false" style="font-size: 12px; vertical-align: baseline" @click="importTemplate">下载模板</el-link> -->
              </div>
            </template>
          </el-upload>
        </el-col>
      </el-row>
      <el-row style="margin-top: 20px;">
        <el-col>
          <div>
            <el-button
                type="success"
                plain
                icon="Check"
                :disabled="planned"
                @click="uploadParse"
                v-hasPermi="['partPlan:confirmPart']"
            >上传并解析</el-button>
          </div>
        </el-col>
      </el-row>
      <el-row>
        <el-col style="margin-top: 20px;">
          <div v-show="isVisible">
            <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"/>
          </div>
        </el-col>
      </el-row>
      <el-row v-show="isVisible">
        <el-col>
          <div>
            <h2>数据预览</h2>
          </div>
          <HxlhTable
              style="width: 100%"
              :columns="exampleColumns"
              :data="exampleList"
              :loading="loading"
              :maxHeight="exampleHeight"
              @on-checkbox="handleCheckboxChange"
          >
          </HxlhTable>
        </el-col>
        <el-col>
          <div style="text-align: right;">
            <h4>共上传<span style="color: blue;">{{ total }}</span>条零件工单数据</h4>
          </div>
        </el-col>
      </el-row>
      <template #footer>
        <div class="dialog-footer">
          <el-button type="primary" @click="submitForm">确 定</el-button>
          <el-button @click="cancel">取 消</el-button>
          <!-- <el-button type="primary" @click="submitFileForm">确 定</el-button> -->
          <el-button @click="dialogCancel">取 消</el-button>
        </div>
      </template>
    </el-dialog>
@@ -266,14 +195,17 @@
</template>

<script setup name="ApsPlatePlan">
import { listPlan, getApsPlatePlan, delApsPlatePlan, addApsPlatePlan, updateApsPlatePlan ,uploadApsPlatePlan} from "@/api/ApsPlatePlan/ApsPlatePlan";
import { listPlan, examplePlan, confirmPart} from "@/api/ApsPlatePlan/ApsPlatePlan";
import HxlhTable from '@/components/HxlhTable'
import { ref } from "vue";
import { getToken } from "@/utils/auth";
import {ElMessage} from "element-plus";

const { proxy } = getCurrentInstance();

const { aps_is_suspended, aps_document_status, aps_account, aps_business_type } = proxy.useDict('aps_is_suspended', 'aps_document_status', 'aps_account', 'aps_business_type');

const exampleList = ref([]);
const planList = ref([]);
const loading = ref(true);
const showSearch = ref(true);
@@ -281,8 +213,13 @@
const total = ref(0);
const daterangePlanStartDay = ref([]);
const daterangePlanEndDay = ref([]);
const vxeTable = ref(null);
const height = ref(document.documentElement.clientHeight - 260 + "px;")
const height = ref(document.documentElement.clientHeight - 210 + "px;")
const isVisible = ref(false);
const isError = ref(false);
const planned = ref(true);
const batchNumber = ref(null);
const exampleHeight = ref("500px");
const uploadRef = ref();


/*** 用户导入参数 */
@@ -296,10 +233,195 @@
  // 是否更新已经存在的用户数据
  updateSupport: 0,
  // 设置上传的请求头部
  headers: { Authorization: "Bearer " + getToken() },
  headers: { Authorization: "Bearer " + getToken() ,local: 'zhl'},
  // 上传的地址
  url: import.meta.env.VITE_APP_BASE_API + "/system/user/importData"
  url: import.meta.env.VITE_APP_BASE_API + "/aps/apsPlatePlan/importData"
});

// 表格配置
const exampleColumns = ref([
  { type: 'seq', title: '序号', width: 60 },
  {
    title: '主计划员',
    field: 'masterPlanner',
    width: 100,
  },
  {
    title: '周日',
    field: 'weekDay',
    width: 100,
    formatter: (({ cellValue, row, column }) => {
      if (cellValue) {
        const weekDay = new Date(cellValue);
        const year = weekDay.getFullYear();
        const month = String(weekDay.getMonth() + 1).padStart(2, '0');
        const day = String(weekDay.getDate()).padStart(2, '0');
        return `${month}-${day}`;
      }
      return '';
    })
  },
  {
    title: '周度',
    field: 'weekCycle',
    width: 80,
  },
  {
    title: '主件料号',
    field: 'mainPartNumber',
    width: 150,
  },
  {
    title: '主件图号',
    field: 'mainPartDrawingNumber',
    width: 150,
  },
  {
    title: '客户名称',
    field: 'customer',
    width: 200,
  },
  {
    title: '业务类型',
    field: 'businessType',
    width: 150,
  },
  {
    title: '单据号',
    field: 'documentNumber',
    width: 150,
  },
  {
    title: '需求分类',
    field: 'requirementType',
    width: 150,
  },
  {
    title: '单据状态',
    field: 'documentStatus',
    width: 100,
  },
  {
    title: '料号',
    field: 'itemNumber',
    width: 150,
  },
  {
    title: '图号',
    field: 'drawingNo',
    width: 150,
  },
  {
    title: '版本号',
    field: 'versionNumber',
    width: 100,
  },
  {
    title: '生产数量',
    field: 'productionQuantity',
    width: 100,
  },
  {
    title: '良品数量',
    field: 'goodProductsQuantity',
    width: 100,
  },
  {
    title: '工序号',
    field: 'processNumber',
    width: 150,
  },
  {
    title: '工作中心',
    field: 'workCenter',
    width: 150,
  },
  {
    title: '所属部门',
    field: 'department',
    width: 100,
  },
  {
    title: '计划开工日',
    field: 'planStartDay',
    width: 100,
  },
  {
    title: '计划完工日',
    field: 'planEndDay',
    width: 100,
  },
  {
    title: '备料料号',
    field: 'standbyNumber',
    width: 100,
  },
  {
    title: '备料名称',
    field: 'standbyName',
    width: 200,
  },
  {
    title: '备料库存',
    field: 'standbyStock',
    width: 100,
  },
  {
    title: '下道工序所属部门',
    field: 'nextProcessDeparment',
    width: 150,
  },
  {
    title: '是否挂起',
    field: 'isSuspended',
    width: 100,
  },
  {
    title: '外协标识',
    field: 'isOutsourcing',
    width: 100,
  },
  {
    title: '账套',
    field: 'account',
    width: 100,
  },
  // {
  //   title: '上阶物料',
  //   field: 'advancedMaterials',
  //   width: 100,
  // },
  // {
  //   title: '上阶单据号',
  //   field: 'advancedDocumentNumber',
  //   width: 100,
  // },
  // {
  //   title: '上阶需求日期',
  //   field: 'advancedRequirementDay',
  //   width: 150,
  // },
  // {
  //   title: '计划齐套',
  //   field: 'isPlanComplete',
  //   width: 100,
  // },
  // {
  //   title: '库存齐套',
  //   field: 'isStockComplete',
  //   width: 100,
  // },
  // {
  //   title: '是否有折返工序',
  //   field: 'hasTurnback',
  //   width: 150,
  // },
  // {
  //   title: '风险标识',
  //   field: 'hasRisk',
  //   width: 100,
  // },
]);

// 表格配置
const columns = ref([
@@ -503,23 +625,33 @@
  }
});

const { queryParams, form, rules } = toRefs(data);
const { queryParams } = toRefs(data);
/** 查询钣金计划临时管理列表 */
function getExampleList() {
  loading.value = true;
  queryParams.value = {};
  queryParams.value.batchNumber = batchNumber.value;
  examplePlan(queryParams.value).then(response => {
    exampleList.value = response.rows;
    total.value = response.total;
    loading.value = false;
  });
}

/** 查询钣金计划管理列表 */
/** 查询零件计划管理列表 */
function getList() {
  loading.value = true;
  queryParams.value.params = {};
  if (null != daterangePlanStartDay && '' != daterangePlanStartDay) {
  if (null != daterangePlanStartDay && '' !== daterangePlanStartDay) {
    queryParams.value.params["beginPlanStartDay"] = daterangePlanStartDay.value[0];
    queryParams.value.params["endPlanStartDay"] = daterangePlanStartDay.value[1];
  }
  if (null != daterangePlanEndDay && '' != daterangePlanEndDay) {
  if (null != daterangePlanEndDay && '' !== daterangePlanEndDay) {
    queryParams.value.params["beginPlanEndDay"] = daterangePlanEndDay.value[0];
    queryParams.value.params["endPlanEndDay"] = daterangePlanEndDay.value[1];
  }
  listPlan(queryParams.value).then(response => {
    planList.value = response.rows;
    total.value = response.total;
    loading.value = false;
  });
}
@@ -534,7 +666,6 @@
function resetQuery() {
  daterangePlanStartDay.value = [];
  daterangePlanEndDay.value = [];
  daterangeAdvancedRequirementDay.value = [];
  proxy.resetForm("queryRef");
  handleQuery();
}
@@ -545,25 +676,95 @@
};

/** 批量修改计划开工日按钮操作 */
function plannedStart(row) {
function plannedStart() {

}

/** 批量修改计划完工日按钮操作 */
function plannedEnd(row) {
function plannedEnd() {

}

/** 导入按钮操作 */
function handleImport() {
  upload.title = "导入";
  upload.title = "钣金计划数据上传";
  upload.open = true;
};

/** 导出按钮操作 */
function handleExport() {
  proxy.download('aps/partPlan/export', {
  proxy.download('aps/apsPlatePlan/export', {
    ...queryParams.value
  }, `plan_${new Date().getTime()}.xlsx`)
}

/** 下载模板操作 */
function importTemplate() {
  proxy.download("system/user/importTemplate", {
  }, `user_template_${new Date().getTime()}.xlsx`);
};

/** buildEexample */
function buildEexample() {
  proxy.$refs["uploadRef"].submit();
};

/**文件上传中处理 */
const handleFileUploadProgress = (event, file, fileList) => {
  upload.isUploading = true;
};

/** 文件上传成功处理 */
const handleFileSuccess = (response, file, fileList) => {
  if(response.code == '200'){
    batchNumber.value = response.data;
    isVisible.value = true;
    planned.value = false;
    isError.value = false;
    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.$refs["uploadRef"].handleRemove(file);
  upload.isUploading = false;
};

/** 上传并解析按钮操作 */
function uploadParse() {
  queryParams.value.params = {};
  queryParams.value.params["batchNumber"] = batchNumber.value;
  confirmPart(queryParams.value).then(response => {
    exampleList.value = response.rows;
    loading.value = false;
    isVisible.value = false;
    isError.value = false;
    planned.value = true;
    upload.open = false;
    ElMessage({
      message: '钣金计划数据已成功上传和解析',
      type: 'success',
    })
    getList();
  });
}

/** dialog取消 */
function dialogCancel(){
  if (uploadRef.value) {
    uploadRef.value.clearFiles();
  }
  isVisible.value = false;
  isError.value = false;
  planned.value = true;
  upload.open = false;
  upload.isUploading = false;
}

getList();
</script>
<style lang="css" scoped>
h4 {
  font-weight: bold;
}
</style>