| ¶Ô±ÈÐÂÎļþ |
| | |
| | | # MDM ç©æä¸»æ°æ®æ¨¡åæ¹é - åç«¯åæ´ææ¡£ |
| | | |
| | | ## æ¦è¿° |
| | | |
| | | æ¬æ¬¡æ¹é å° ERPãMESãWMS ä¸ä¸ªæ¨¡åçç©æ/äº§åæ°æ®ç»ä¸å° MDMï¼ä¸»æ°æ®ç®¡çï¼æ¨¡åï¼æ¶é¤æ°æ®å¤å²ã |
| | | |
| | | ## 模ååæ´ |
| | | |
| | | ### 1. MDM 模åï¼æ°å¢ï¼ |
| | | |
| | | æ°å¢ MDM ç©æä¸»æ°æ®ç®¡ç模åï¼å
å«ä»¥ä¸é¡µé¢ï¼ |
| | | |
| | | | é¡µé¢ | è·¯å¾ | 说æ | |
| | | |------|------|------| |
| | | | ç©æç®¡ç | /mdm/item | ç©æä¸»æ°æ®ç®¡ç | |
| | | | ç©æåç±» | /mdm/category | ç©æå类管ç | |
| | | | 计éåä½ | /mdm/unit | 计éåä½ç®¡ç | |
| | | | åç管ç | /mdm/brand | åç管ç | |
| | | | ä»åºç®¡ç | /mdm/warehouse | ä»åºä¸»æ°æ®ç®¡ç | |
| | | |
| | | ### 2. ERP 模å |
| | | |
| | | ERP äº§åæ°æ®æ¥æºäº MDMï¼åæ´å¦ä¸ï¼ |
| | | |
| | | | åé¡µé¢ | åå | |
| | | |--------|------| |
| | | | /erp/product | äº§åæ°æ®ä» MDM è·åï¼é¡µé¢ä¿ç使°æ®æºåæ´ | |
| | | |
| | | ### 3. MES 模å |
| | | |
| | | MES ç©ææ°æ®æ¥æºäº MDMï¼åæ´å¦ä¸ï¼ |
| | | |
| | | | åé¡µé¢ | åå | |
| | | |--------|------| |
| | | | /mes/md/item | ç©ææ°æ®ä» MDM è·åï¼é¡µé¢ä¿ç使°æ®æºåæ´ | |
| | | |
| | | ### 4. WMS 模å |
| | | |
| | | WMS ååå SKU æ°æ®æ¥æºäº MDMï¼åæ´å¦ä¸ï¼ |
| | | |
| | | | åé¡µé¢ | åå | |
| | | |--------|------| |
| | | | /wms/item | ååæ°æ®ä» MDM è·åï¼é¡µé¢ä¿ç使°æ®æºåæ´ | |
| | | | /wms/item-sku | SKU æ°æ®ä» MDM è·åï¼é¡µé¢ä¿ç使°æ®æºåæ´ | |
| | | |
| | | --- |
| | | |
| | | ## API åæ´è¯´æ |
| | | |
| | | ### MDM ç©æ API |
| | | |
| | | | æ¹æ³ | è·¯å¾ | 说æ | |
| | | |------|------|------| |
| | | | POST | /mdm/item/create | åå»ºç©æ | |
| | | | PUT | /mdm/item/update | æ´æ°ç©æ | |
| | | | PUT | /mdm/item/update-status | æ´æ°ç©æç¶æ | |
| | | | DELETE | /mdm/item/delete | å é¤ç©æï¼å®é
为ç¦ç¨ï¼ | |
| | | | GET | /mdm/item/get | è·åç©æ | |
| | | | GET | /mdm/item/page | è·åç©æå页 | |
| | | | GET | /mdm/item/list-by-ids | è·åç©æå表 | |
| | | |
| | | **请æ±åæ°ï¼å建ï¼ï¼** |
| | | |
| | | | åæ° | ç±»å | å¿
å¡« | 说æ | |
| | | |------|------|------|------| |
| | | | code | String | æ¯ | ç©æç¼ç | |
| | | | name | String | æ¯ | ç©æåç§° | |
| | | | barCode | String | å¦ | ç©ææ¡ç | |
| | | | specification | String | å¦ | è§æ ¼åå· | |
| | | | categoryId | Long | æ¯ | ç©æåç±»ç¼å· | |
| | | | unitMeasureId | Long | æ¯ | 计éåä½ç¼å· | |
| | | | brandId | Long | å¦ | åçç¼å· | |
| | | | itemType | Integer | æ¯ | ç©æç±»åï¼1:ç©æ, 2:产å, 3:åæåï¼ | |
| | | | status | Integer | å¦ | ç¶æï¼0:å¯ç¨, 1:ç¦ç¨ï¼ | |
| | | | purchasePrice | BigDecimal | å¦ | éè´ä»·æ ¼ | |
| | | | salesPrice | BigDecimal | å¦ | éå®ä»·æ ¼ | |
| | | | costPrice | BigDecimal | å¦ | ææ¬ä»·æ ¼ | |
| | | | safetyStock | BigDecimal | å¦ | å®å
¨åºå | |
| | | | expiryDays | Integer | å¦ | ä¿è´¨æå¤©æ° | |
| | | | isBatchManaged | Boolean | å¦ | æ¯å¦æ¹æ¬¡ç®¡ç | |
| | | | remark | String | å¦ | 夿³¨ | |
| | | |
| | | **ååºï¼** |
| | | |
| | | ```json |
| | | { |
| | | "code": 0, |
| | | "data": 1, |
| | | "msg": "æä½æå" |
| | | } |
| | | ``` |
| | | |
| | | ### MDM ç©æåç±» API |
| | | |
| | | | æ¹æ³ | è·¯å¾ | 说æ | |
| | | |------|------|------| |
| | | | POST | /mdm/category/create | å建åç±» | |
| | | | PUT | /mdm/category/update | æ´æ°åç±» | |
| | | | DELETE | /mdm/category/delete | å é¤åç±» | |
| | | | GET | /mdm/category/get | è·ååç±» | |
| | | | GET | /mdm/category/list | è·ååç±»å表 | |
| | | | GET | /mdm/category/list-all-simple | è·åå¯ç¨çåç±»å表 | |
| | | |
| | | ### MDM 计éåä½ API |
| | | |
| | | | æ¹æ³ | è·¯å¾ | 说æ | |
| | | |------|------|------| |
| | | | POST | /mdm/unit/create | å建åä½ | |
| | | | PUT | /mdm/unit/update | æ´æ°åä½ | |
| | | | DELETE | /mdm/unit/delete | å é¤åä½ | |
| | | | GET | /mdm/unit/get | è·ååä½ | |
| | | | GET | /mdm/unit/page | è·ååä½å页 | |
| | | | GET | /mdm/unit/list-by-ids | è·ååä½å表 | |
| | | |
| | | ### MDM åç API |
| | | |
| | | | æ¹æ³ | è·¯å¾ | 说æ | |
| | | |------|------|------| |
| | | | POST | /mdm/brand/create | å建åç | |
| | | | PUT | /mdm/brand/update | æ´æ°åç | |
| | | | DELETE | /mdm/brand/delete | å é¤åç | |
| | | | GET | /mdm/brand/get | è·ååç | |
| | | | GET | /mdm/brand/page | è·ååçå页 | |
| | | | GET | /mdm/brand/list-by-ids | è·ååçå表 | |
| | | |
| | | ### MDM ä»åº API |
| | | |
| | | | æ¹æ³ | è·¯å¾ | 说æ | |
| | | |------|------|------| |
| | | | POST | /mdm/warehouse/create | å建ä»åº | |
| | | | PUT | /mdm/warehouse/update | æ´æ°ä»åº | |
| | | | PUT | /mdm/warehouse/update-status | æ´æ°ä»åºç¶æ | |
| | | | DELETE | /mdm/warehouse/delete | å é¤ä»åº | |
| | | | GET | /mdm/warehouse/get | è·åä»åº | |
| | | | GET | /mdm/warehouse/page | è·åä»åºå页 | |
| | | | GET | /mdm/warehouse/list-by-ids | è·åä»åºå表 | |
| | | |
| | | --- |
| | | |
| | | ## å端修æ¹ç¹ |
| | | |
| | | ### 1. ERP 产åé¡µé¢ |
| | | |
| | | ERP 产å页颿¹ä¸ºä» MDM è·åæ°æ®ï¼å端éè¦ä¿®æ¹ï¼ |
| | | |
| | | **API è°ç¨åæ´ï¼** |
| | | |
| | | ```js |
| | | // åè°ç¨ ERP 产å API |
| | | import { getProductPage, getProduct } from '@/api/erp/product' |
| | | |
| | | // æ¹ä¸ºè°ç¨ MDM ç©æ APIï¼itemType=2 产åï¼ |
| | | import { getItemPage, getItem } from '@/api/mdm/item' |
| | | |
| | | // æ¥è¯¢æ¶éè¦ä¼ å
¥ itemType=2ï¼äº§åç±»åï¼ |
| | | getItemPage({ itemType: 2, pageNo: 1, pageSize: 10 }) |
| | | ``` |
| | | |
| | | **åæ®µæ å°ï¼** |
| | | |
| | | | ERP åæ®µ | MDM åæ®µ | 说æ | |
| | | |----------|----------|------| |
| | | | id | id | ç¼å· | |
| | | | barCode | code | ç¼ç ï¼åæ¡ç æ¹ä¸ºç¼ç ï¼ | |
| | | | name | name | åç§° | |
| | | | spec | specification | è§æ ¼åå· | |
| | | | categoryId | categoryId | åç±»ç¼å· | |
| | | | unitId | unitMeasureId | åä½ç¼å· | |
| | | | brandId | brandId | åçç¼å· | |
| | | | status | status | ç¶æ | |
| | | | purchasePrice | purchasePrice | éè´ä»·æ ¼ | |
| | | | salePrice | salesPrice | éå®ä»·æ ¼ | |
| | | | minPrice | costPrice | æä½ä»·æ ¼æ¹ä¸ºææ¬ä»· | |
| | | |
| | | ### 2. MES ç©æé¡µé¢ |
| | | |
| | | MES ç©æé¡µé¢æ¹ä¸ºä» MDM è·åæ°æ®ï¼ |
| | | |
| | | **API è°ç¨åæ´ï¼** |
| | | |
| | | ```js |
| | | // åè°ç¨ MES ç©æ API |
| | | import { getItemPage, getItem } from '@/api/mes/md/item' |
| | | |
| | | // æ¹ä¸ºè°ç¨ MDM ç©æ APIï¼itemType=1 ç©æï¼ |
| | | import { getItemPage, getItem } from '@/api/mdm/item' |
| | | |
| | | // æ¥è¯¢æ¶éè¦ä¼ å
¥ itemType=1ï¼ç©æç±»åï¼ |
| | | getItemPage({ itemType: 1, pageNo: 1, pageSize: 10 }) |
| | | ``` |
| | | |
| | | **MES ç¹æåè½ä¿çï¼** |
| | | - æ¹æ¬¡å±æ§é
ç½®ï¼ä»ç± MES 模å管ç |
| | | - BOM é
ç½®ï¼ä»ç± MES 模å管ç |
| | | - SOP/SIP é
ç½®ï¼ä»ç± MES 模å管ç |
| | | |
| | | ### 3. WMS åå/SKU é¡µé¢ |
| | | |
| | | WMS ååå SKU 页颿¹ä¸ºä» MDM è·åæ°æ®ï¼ |
| | | |
| | | **API è°ç¨åæ´ï¼** |
| | | |
| | | ```js |
| | | // åè°ç¨ WMS åå API |
| | | import { getItemPage, getItem } from '@/api/wms/item' |
| | | |
| | | // æ¹ä¸ºè°ç¨ MDM ç©æ API |
| | | import { getItemPage, getItem } from '@/api/mdm/item' |
| | | |
| | | // SKU æ°æ® |
| | | import { getItemSkuList } from '@/api/mdm/item-sku' |
| | | ``` |
| | | |
| | | --- |
| | | |
| | | ## 注æäºé¡¹ |
| | | |
| | | 1. **ç©æç±»ååºå**ï¼ |
| | | - itemType=1ï¼ç©æï¼MES 使ç¨ï¼ |
| | | - itemType=2ï¼äº§åï¼ERP 使ç¨ï¼ |
| | | - itemType=3ï¼åæå |
| | | |
| | | 2. **å 餿ä½**ï¼MDM ç©æå é¤å®é
为ç¦ç¨æä½ï¼ä¸åç©çå é¤ |
| | | |
| | | 3. **SKU 模å¼**ï¼ææç©æå¿
é¡»é
ç½® SKUï¼ERP/MES æ°æ®è¿ç§»æ¶èªå¨å建é»è®¤ SKU |
| | | |
| | | 4. **ååå
¼å®¹**ï¼å模åç API æ¥å£ä¿çï¼å
é¨è°ç¨ MDM API |
| | | |
| | | --- |
| | | |
| | | ## æ°æ®åºè¡¨ |
| | | |
| | | | 表å | 说æ | |
| | | |------|------| |
| | | | mdm_item | ç©æä¸»æ°æ®è¡¨ | |
| | | | mdm_item_sku | ç©æ SKU 表 | |
| | | | mdm_item_category | ç©æå类表 | |
| | | | mdm_unit_measure | 计éåä½è¡¨ | |
| | | | mdm_brand | åç表 | |
| | | | mdm_warehouse | ä»åºè¡¨ | |
| | | | mdm_item_batch_config | æ¹æ¬¡å±æ§é
置表 | |