From 08b86cccfc8227ab065ee913f809609ef708486d Mon Sep 17 00:00:00 2001
From: liu <2021943741@qq.com>
Date: 星期五, 21 八月 2026 09:59:21 +0800
Subject: [PATCH] 物料管理/物料分类/计量单位增加 Excel 导入功能

---
 src/views/basicData/mdm/data.ts |  142 +++++++++++++++++++++++++++++++++++-----------
 1 files changed, 107 insertions(+), 35 deletions(-)

diff --git a/src/views/basicData/mdm/data.ts b/src/views/basicData/mdm/data.ts
index c77d66f..ca625c3 100644
--- a/src/views/basicData/mdm/data.ts
+++ b/src/views/basicData/mdm/data.ts
@@ -11,6 +11,7 @@
 import { MesAutoCodeRuleCode } from '@vben/constants';
 import { getItemTypeSimpleList } from '#/api/mes/md/item/type';
 import { getUnitPage } from '#/api/mdm/unit';
+import { getWarehouseSimpleList } from '#/api/mes/wm/warehouse';
 
 import { Button } from 'ant-design-vue';
 
@@ -18,8 +19,12 @@
 let unitListCache: any[] | null = null;
 let unitListPromise: Promise<any[]> | null = null;
 
+// 缂撳瓨浠撳簱鍒楄〃
+let warehouseListCache: any[] | null = null;
+let warehouseListPromise: Promise<any[]> | null = null;
+
 /** 灏嗘墎骞冲垎绫诲垪琛ㄨ浆涓� TreeSelect 鎵�闇�鐨勬爲褰㈢粨鏋� */
-function buildCategoryTree(list: any[]): any[] {
+export function buildCategoryTree(list: any[]): any[] {
   const map = new Map<number, any>();
   const roots: any[] = [];
   for (const item of list) {
@@ -53,13 +58,31 @@
   return unitListPromise;
 }
 
+/** 鑾峰彇浠撳簱鍒楄〃锛堝甫缂撳瓨锛� */
+async function getWarehouseListCached() {
+  if (warehouseListCache) {
+    return warehouseListCache;
+  }
+  if (warehouseListPromise) {
+    return warehouseListPromise;
+  }
+  warehouseListPromise = getWarehouseSimpleList().then((res) => {
+    warehouseListCache = res || [];
+    return warehouseListCache;
+  }).finally(() => {
+    warehouseListPromise = null;
+  });
+  return warehouseListPromise;
+}
+
 /** 娓呴櫎鍗曚綅鍒楄〃缂撳瓨 */
 export function clearUnitListCache() {
   unitListCache = null;
+  warehouseListCache = null;
 }
 
 /** 鏂板/淇敼鐨勮〃鍗� */
-export function useFormSchema(formApi?: VbenFormApi): VbenFormSchema[] {
+export function useFormSchema(formApi?: VbenFormApi, categoryTreeData: any[] = []): VbenFormSchema[] {
   return [
     {
       component: "Input",
@@ -103,7 +126,7 @@
       rules: "required",
     },
     {
-      component: "ApiTreeSelect",
+      component: "TreeSelect",
       fieldName: "categoryId",
       label: "鐗╂枡鍒嗙被",
       rules: "selectRequired",
@@ -111,10 +134,8 @@
         placeholder: "璇烽�夋嫨鐗╂枡鍒嗙被",
         allowClear: true,
         treeDefaultExpandAll: true,
-        api: async () => {
-          const res = await getItemTypeSimpleList();
-          return buildCategoryTree(res || []);
-        },
+        treeData: categoryTreeData,
+        fieldNames: { label: 'label', value: 'value', children: 'children' },
       },
     },
     {
@@ -190,11 +211,29 @@
       },
     },
     {
-      component: 'Input',
+      component: 'ApiSelect',
       fieldName: 'warehouseId',
       label: '榛樿浠撳簱',
       componentProps: {
-        placeholder: '璇疯緭鍏ラ粯璁や粨搴揑D',
+        placeholder: '璇烽�夋嫨榛樿浠撳簱',
+        allowClear: true,
+        api: getWarehouseListCached,
+        labelField: 'name',
+        valueField: 'id',
+        onChange: async (value: number | undefined) => {
+          const code = value
+            ? ((await getWarehouseListCached()).find((w: any) => w.id === value)?.code || '')
+            : '';
+          formApi?.setFieldValue('warehouseCode', code);
+        },
+      },
+    },
+    {
+      component: 'Input',
+      fieldName: 'warehouseCode',
+      dependencies: {
+        triggerFields: [''],
+        show: () => false,
       },
     },
     {
@@ -284,17 +323,6 @@
       rules: z.boolean().default(false),
     },
     {
-      component: "Switch",
-      fieldName: "syncMes",
-      label: "鍚屾鍒� MES",
-      componentProps: {
-        class: "w-auto",
-        checkedChildren: "鏄�",
-        unCheckedChildren: "鍚�",
-      },
-      rules: z.boolean().default(false),
-    },
-    {
       component: "InputNumber",
       fieldName: "expiryDay",
       label: "鏈夋晥鏈�(澶�)",
@@ -303,6 +331,17 @@
         min: 0,
         placeholder: "璇疯緭鍏ユ湁鏁堟湡",
       },
+    },
+    {
+      component: 'Switch',
+      fieldName: 'syncMes',
+      label: '鍚屾鍒癕ES',
+      defaultValue: true,
+      componentProps: {
+        checkedChildren: '鏄�',
+        unCheckedChildren: '鍚�',
+      },
+      rules: z.boolean().default(true),
     },
     {
       component: "RadioGroup",
@@ -554,27 +593,36 @@
       },
     },
     {
-      field: "isBatchManaged",
-      title: "鎵规绠$悊",
-      minWidth: 80,
-      slots: { default: "isBatchManaged" },
-    },
-    {
-      field: "status",
-      title: "鐘舵��",
-      minWidth: 80,
-      cellRender: {
-        name: "CellDict",
-        props: { type: DICT_TYPE.COMMON_STATUS },
-      },
-    },
-    {
       field: "createTime",
       title: "鍒涘缓鏃堕棿",
       minWidth: 180,
       formatter: "formatDateTime",
     },
     {
+      field: "isBatchManaged",
+      title: "鎵规绠$悊",
+      width: 80,
+      fixed: "right",
+      slots: { default: "isBatchManaged" },
+    },
+    {
+      field: "syncedMes",
+      title: "鍚屾鐘舵��",
+      width: 100,
+      fixed: "right",
+      slots: { default: "syncedMes" },
+    },
+    {
+      field: "status",
+      title: "鐘舵��",
+      width: 80,
+      fixed: "right",
+      cellRender: {
+        name: "CellDict",
+        props: { type: DICT_TYPE.COMMON_STATUS },
+      },
+    },
+    {
       title: "鎿嶄綔",
       width: 180,
       fixed: "right",
@@ -582,3 +630,27 @@
     },
   ];
 }
+
+/** 鐗╂枡瀵煎叆鐨勮〃鍗� */
+export function useImportFormSchema(): VbenFormSchema[] {
+  return [
+    {
+      fieldName: 'file',
+      label: '鐗╂枡鏁版嵁',
+      component: 'Upload',
+      rules: 'required',
+      help: '浠呭厑璁稿鍏� xls銆亁lsx 鏍煎紡鏂囦欢',
+    },
+    {
+      fieldName: 'updateSupport',
+      label: '鏄惁瑕嗙洊',
+      component: 'Switch',
+      componentProps: {
+        checkedChildren: '鏄�',
+        unCheckedChildren: '鍚�',
+      },
+      rules: z.boolean().default(false),
+      help: '鏄惁鏇存柊宸茬粡瀛樺湪鐨勭墿鏂欐暟鎹�',
+    },
+  ];
+}

--
Gitblit v1.9.3