From a3f50e5bd0d5ecbd0c5992da042fe4292dbb6911 Mon Sep 17 00:00:00 2001
From: fy36 <1046342473@qq.com>
Date: 星期二, 24 六月 2025 10:48:00 +0800
Subject: [PATCH] SKU_Sync.lua 模型字段调整到明细中
---
lua_code/Lua/SKU_Sync.lua | 402 ++++++++++++++++++++++++++++++++++++++++++--------------
1 files changed, 299 insertions(+), 103 deletions(-)
diff --git a/lua_code/Lua/SKU_Sync.lua b/lua_code/Lua/SKU_Sync.lua
index 6382c96..c1375f1 100644
--- a/lua_code/Lua/SKU_Sync.lua
+++ b/lua_code/Lua/SKU_Sync.lua
@@ -9,90 +9,171 @@
鍔熻兘璇存槑:
1. 鎺ユ敹鏉ヨ嚜涓婃父绯荤粺鐨�XML 鏍煎紡鏁版嵁锛屽苟瑙ｆ瀽璇ユ暟鎹� 鍒涘缓SKU鍙奡KU_UPC
-
- <soapenv:Envelope
- xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
- <soap:Header
- xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
- </soap:Header>
- <soapenv:Body>
- <v1:inCommodityReq
- xmlns:v1="http://www.gkht.com/Information/INV/Ebs/Schemas/InCommodity/V1.0">
- <v1:COMMODITY_Input>
- <v1:RESTHeader>
- <v1:Responsibility/>
- <v1:RespApplication/>
- <v1:SecurityGroup/>
- <v1:NLSLanguage>SIMPLIFIED CHINESE</v1:NLSLanguage>
- <v1:Org_Id>0</v1:Org_Id>
- </v1:RESTHeader>
- <v1:InputParameters>
- <v1:COMMODITY_TB>
- <!--1 or more repetitions:-->
- <v1:COMMODITY_TB_ITEM>
- <v1:skuId>KH32803017</v1:skuId>
- <v1:storerId>CGKHTY</v1:storerId>
- <v1:skuName>铻烘棆鍒�墖寮忛珦鍐呴拤</v1:skuName>
- <v1:skuDec>铻烘棆鍒�墖寮忚偂楠ㄨ繎绔珦鍐呴拤10脳170</v1:skuDec>
- <v1:spec>JGD鈪�蠁10脳170</v1:spec>
- <v1:packageCode>涓�/v1:packageCode>
- <v1:packageQty>1</v1:packageQty>
- <v1:goodsUnit>浠�/v1:goodsUnit>
- <v1:length>1</v1:length>
- <v1:width>2</v1:width>
- <v1:height>3</v1:height>
- <v1:abcType></v1:abcType>
- <v1:isBatchMgr>1</v1:isBatchMgr>
- <v1:isSnMgr>1</v1:isSnMgr>
- <v1:isSnStorageMgr>0</v1:isSnStorageMgr>
- <v1:imgUrl></v1:imgUrl>
- <v1:cidtype>A</v1:cidtype>
- <v1:productLine>KH-鍒涗激</v1:productLine>
- <v1:storageConditions>甯告俯</v1:storageConditions>
- <v1:skuType>small</v1:skuType>
- <v1:maxCount>50</v1:maxCount>
- <v1:sptm></v1:sptm>
- <v1:barcode1></v1:barcode1>
- <v1:barcode2></v1:barcode2>
- <v1:barcode3></v1:barcode3>
- <v1:barcode_pk></v1:barcode_pk>
- </v1:COMMODITY_TB_ITEM>
- </v1:COMMODITY_TB>
- </v1:InputParameters>
- </v1:COMMODITY_Input>
- </v1:inCommodityReq>
- </soapenv:Body>
- </soapenv:Envelope>
+ 鏇存柊锛�+ 2025/06/09 鏇存柊浜唘df01~udf04鐨勫睘鎬у彉鏇�
鏇存敼璁板綍:
V2.0 HAN 20250402 浠ｇ爜瑙勮寖
-
- V2.1 Yuanfeng
- 1. 缁熶竴浜嗚繑鍥炵粨鏋滄牸寮忥紝浣跨敤Create_result鍑芥暟鍒涘缓鏍囧噯鍖栫殑杩斿洖缁撴瀯
- 2. 浼樺寲浜嗕唬鐮佺粨鏋�+ V2.1 Yuanfeng 浼樺寲杩斿洖缁撴灉澶勭悊
+ V2.2 浼樺寲閿欒澶勭悊鍜岃繑鍥為�杈�+ V2.3 绉婚櫎error瀛楁锛屽悎骞跺埌message涓�+ V2.4 鏂板SKU_GRID_PARM瀛楁
+
+<?xml version="1.0" encoding="UTF-8"?>
+<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
+ <soap:Header xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"></soap:Header>
+ <soapenv:Body>
+ <v1:inCommodityReq xmlns:v1="http://www.gkht.com/Information/INV/Ebs/Schemas/InCommodity/V1.0">
+ <v1:COMMODITY_Input>
+ <v1:RESTHeader>
+ <v1:Responsibility/>
+ <v1:RespApplication/>
+ <v1:SecurityGroup/>
+ <v1:NLSLanguage>SIMPLIFIED CHINESE</v1:NLSLanguage>
+ <v1:Org_Id>0</v1:Org_Id>
+ </v1:RESTHeader>
+ <v1:InputParameters>
+ <v1:COMMODITY_TB>
+ <!--1 or more repetitions:-->
+ <v1:COMMODITY_TB_ITEM>
+ <v1:skuId>XR4121-3204A</v1:skuId>
+ <v1:storerId>CGKHTY</v1:storerId>
+ <v1:skuName>閲戝睘瑙ｅ墫鍨嬫帴楠ㄦ澘</v1:skuName>
+ <v1:skuDec>閲戝睘瑙ｅ墫鍨嬫帴楠ㄦ澘YSQ20 4瀛�/v1:skuDec>
+ <v1:spec>瑙勬牸娴嬭瘯</v1:spec>
+ <v1:packageCode>鍧�/v1:packageCode>
+ <v1:packageQty>1</v1:packageQty>
+ <v1:goodsUnit>鍧�/v1:goodsUnit>
+ <v1:length>3.5</v1:length>
+ <v1:width>3.5</v1:width>
+ <v1:height>3.5</v1:height>
+ <v1:abcType/>
+ <v1:isBatchMgr>0</v1:isBatchMgr>
+ <v1:isSnMgr>0</v1:isSnMgr>
+ <v1:isSnStorageMgr>0</v1:isSnStorageMgr>
+ <v1:imgUrl/>
+ <v1:cidtype>11111A</v1:cidtype>
+ <v1:productLine>XR-鍒涗激</v1:productLine>
+ <v1:storageConditions>鎭掓俯</v1:storageConditions>
+ <v1:skuType>small</v1:skuType>
+ <v1:maxCount/>
+ <v1:bMaxCount>10</v1:bMaxCount>
+ <v1:cMaxCount>11</v1:cMaxCount>
+ <v1:dMaxCount>12</v1:dMaxCount>
+ <v1:eMaxCount/>
+ <v1:fMaxCount/>
+ <v1:upc>1</v1:upc>
+ </v1:COMMODITY_TB_ITEM>
+ </v1:COMMODITY_TB>
+ </v1:InputParameters>
+ </v1:COMMODITY_Input>
+ </v1:inCommodityReq>
+ </soapenv:Body>
+</soapenv:Envelope>
+
--]] wms_base = require("wms_base")
xml = require("oi_base_xml")
mobox = require("OILua_JavelinExt")
m3 = require("oi_base_mobox")
--- 鍒涘缓缁熶竴杩斿洖缁撴灉
-function Create_result(flag, code, msg, error)
+-- 鍒涘缓缁熶竴杩斿洖缁撴灉锛堜慨鏀瑰悗鐗堟湰锛岀Щ闄rror瀛楁锛�+function Create_result(flag, code, msg)
return {
flag = flag or "success",
code = code or "0",
- message = msg or "",
- error = error or ""
+ message = msg or ""
}
end
+-- 鏂板sku_grid_parm JSON瀛楃涓诧紝鍦⊿KU 鍒涘缓鐨勬椂鍊欐彃鍏son鏁版嵁
+local function build_sku_grid_parm(ctd_code, sku_input_data)
+ -- 瀹氫箟鍩虹json妗嗘灦缁撴瀯锛堟斁鍦ㄦ暟缁勪腑锛�+ local grid_def = {{
+ ctd_code = ctd_code,
+ cell_def = {}
+ }}
-local function create_sku_upc(strLuaDEID, storer, item_code, upc_code)
+ -- 瀹氫箟鏂欑绫诲瀷涓庡搴斿瓧娈电殑鏄犲皠
+ local grid_mapping = {{
+ cell_type = "A",
+ loading_limit = sku_input_data.maxCount
+ }, {
+ cell_type = "B",
+ loading_limit = sku_input_data.bMaxCount
+ }, {
+ cell_type = "C",
+ loading_limit = sku_input_data.cMaxCount
+ }, {
+ cell_type = "D",
+ loading_limit = sku_input_data.dMaxCount
+ }, {
+ cell_type = "E",
+ loading_limit = sku_input_data.eMaxCount
+ }, {
+ cell_type = "F",
+ loading_limit = sku_input_data.fMaxCount
+ }}
+
+ -- 鏋勫缓cell_def鏁扮粍
+ for _, grid in ipairs(grid_mapping) do
+ local limit = lua.Get_NumAttrValue(grid.loading_limit) or 0
+ table.insert(grid_def[1].cell_def, { -- 娉ㄦ剰杩欓噷鏀逛负grid_def[1]
+ cell_type = grid.cell_type,
+ loading_limit = limit,
+ load_capacity = limit -- 杩欓噷鍋囪load_capacity鍜宭oading_limit鐩稿悓
+ })
+ end
+
+ -- 杞崲涓篔SON瀛楃涓�+ return lua.table2str(grid_def)
+end
+-- 鍒涘缓鎴栨洿鏂癎K_PROLINE鏁版嵁(鐢熶骇绾挎暟鎹�
+local function create_or_update_proline(strLuaDEID, proline_no, proline_name)
local nRet, strRetInfo
+ -- 鍒嗛厤GK_PROLINE瀵硅薄
+ local proline = m3.AllocObject(strLuaDEID, "GK_PROLINE")
+ proline.proline_no = proline_no
+ proline.proline_name = proline_name
+
+ -- 妫�煡鏄惁宸插瓨鍦�+ local strCondition = string.format("S_PROLINE_NO = '%s'", proline_no)
+ local nRet, id, strRetInfo = mobox.getDataObjAttrByKeyAttr(strLuaDEID, "GK_PROLINE", strCondition)
+
+ if nRet > 1 then
+ return 1, "妫�煡GK_PROLINE鏄惁瀛樺湪鏃跺け璐� " .. strRetInfo
+ end
+
+ if nRet == 1 then
+ -- 涓嶅瓨鍦紝鍒涘缓鏂拌褰�+ nRet, strRetInfo = m3.CreateDataObj(strLuaDEID, proline)
+ if nRet ~= 0 then
+ return 1, "鍒涘缓GK_PROLINE澶辫触: " .. strRetInfo
+ end
+ else
+ -- 宸插瓨鍦紝鏇存柊璁板綍
+ local update_proline_obj = {{
+ id = id,
+ attrs = {{
+ attr = "S_PROLINE_NAME",
+ value = proline_name
+ }}
+ }}
+
+ nRet, strRetInfo = mobox.updateDataObj(strLuaDEID, "GK_PROLINE", lua.table2str(update_proline_obj))
+ if nRet ~= 0 then
+ return 1, "鏇存柊GK_PROLINE澶辫触: " .. strRetInfo
+ end
+ end
+ return 0, strRetInfo
+end
+
+-- 鍒涘缓SKU_UPC
+local function create_sku_upc(strLuaDEID, storer, item_code, upc_code)
+ local nRet, strRetInfo
if (upc_code == '' or upc_code == nil) then
return 0
end
- -- 鍒涘缓SKU_UPC
local sku_upc = m3.AllocObject(strLuaDEID, "SKU_UPC")
sku_upc.storer = storer
sku_upc.item_code = item_code
@@ -102,53 +183,142 @@
return nRet, strRetInfo
end
+-- 鍒涘缓/鏇存柊SKU瀵瑰簲鐨勮揣鍝佹枡绠辨牸鍙傛暟
+local function create_or_update_sku_gridbox(strLuaDEID, skuModel, sku_input_data)
+ local nRet, strRetInfo
+ -- 鑾峰彇榛樿瀹瑰櫒绫诲瀷缂栫爜
+ local nConstRet, CONST_CTD_CODE = wms_base.Get_sConst2("WMS_Default_CNTR_Type")
+ if nConstRet ~= 0 then
+ return 1, "鑾峰彇榛樿瀹瑰櫒绫诲瀷瀹氫箟缂栫爜澶辫触: " .. CONST_CTD_CODE
+ end
+
+ -- 瀹氫箟鏂欑鏍肩被鍨嬩笌瀵瑰簲瀛楁鐨勬槧灏勫叧绯�+ local gridbox_types = {{
+ cell_type = "A",
+ loading_limit = sku_input_data.maxCount
+ }, {
+ cell_type = "B",
+ loading_limit = sku_input_data.bMaxCount
+ }, {
+ cell_type = "C",
+ loading_limit = sku_input_data.cMaxCount
+ }, {
+ cell_type = "D",
+ loading_limit = sku_input_data.dMaxCount
+ }, {
+ cell_type = "E",
+ loading_limit = sku_input_data.eMaxCount
+ }, {
+ cell_type = "F",
+ loading_limit = sku_input_data.fMaxCount
+ }}
+
+ -- 澶勭悊姣忕鏂欑鏍肩被鍨�+ for _, gridbox_type in ipairs(gridbox_types) do
+ -- 璁剧疆瑁呰浇涓婇檺锛屽鏋滄病鏈夊垯璁句负0
+ local loading_limit = 0
+ if gridbox_type.loading_limit and gridbox_type.loading_limit ~= "" then
+ loading_limit = lua.Get_NumAttrValue(gridbox_type.loading_limit) or 0
+ end
+
+ -- 绮剧‘鏌ヨ璇ョ被鍨嬬殑鏂欑鏍艰褰�+ local strCondition = string.format(
+ "S_ITEM_CODE = '%s' AND S_STORER = '%s' AND S_CTD_CODE='%s' AND S_CELL_TYPE='%s'", skuModel.item_code,
+ skuModel.storer, CONST_CTD_CODE, gridbox_type.cell_type)
+ local nRet, existing_records = m3.GetDataObjByCondition(strLuaDEID, "SKU_GridBox_Parm", strCondition)
+ if nRet == 0 then
+ -- 鏇存柊鐜版湁璁板綍
+ local update_gridbox_obj = {{
+ id = existing_records.id,
+ attrs = {{
+ attr = "N_LOADING_LIMIT",
+ value = loading_limit
+ }}
+ }}
+
+ nRet, strRetInfo = mobox.updateDataObj(strLuaDEID, "SKU_GridBox_Parm", lua.table2str(update_gridbox_obj))
+ if nRet ~= 0 then
+ return 1, string.format("鏇存柊%s绫诲瀷鏂欑鏍煎睘鎬уけ璐� %s", gridbox_type.cell_type, strRetInfo)
+ end
+ else
+ -- 鍒涘缓鏂拌褰�+ local gridbox = m3.AllocObject(strLuaDEID, "SKU_GridBox_Parm")
+ gridbox.item_code = skuModel.item_code
+ gridbox.storer = skuModel.storer
+ gridbox.ctd_code = CONST_CTD_CODE
+ gridbox.loading_limit = loading_limit
+ gridbox.cell_type = gridbox_type.cell_type
+
+ nRet, strRetInfo = m3.CreateDataObj(strLuaDEID, gridbox)
+ if nRet ~= 0 then
+ return 1, string.format("鍒涘缓%s绫诲瀷鏂欑鏍煎け璐� %s", gridbox_type.cell_type, strRetInfo)
+ end
+ end
+ end
+
+ return 0, "鏂欑鏍煎弬鏁板鐞嗗畬鎴�
+end
+
+-- 鍒涘缓鎴栨洿鏂癝KU涓绘暟鎹� local function create_sku(strLuaDEID, sku_input_data)
local nRet, strRetInfo
local err_msg = ''
+ -- 鑾峰彇绯荤粺甯搁噺
+ -- 鑾峰彇榛樿瀹瑰櫒绫诲瀷缂栫爜
+ local nConstRet, CONST_CTD_CODE = wms_base.Get_sConst2("WMS_Default_CNTR_Type")
+ if nConstRet ~= 0 then
+ return 1, "鑾峰彇榛樿瀹瑰櫒绫诲瀷瀹氫箟缂栫爜澶辫触: " .. CONST_CTD_CODE
+ end
+ -- 鏂板SKU_grid_param
+ local sku_grid_parm = build_sku_grid_parm(CONST_CTD_CODE, sku_input_data)
- -- 鍒嗛厤SKU瀵硅薄
+ -- 棣栧厛妫�煡SKU鏄惁宸插瓨鍦�+ local strCondition = string.format("S_ITEM_CODE = '%s' AND S_STORER = '%s'", sku_input_data.skuId,
+ sku_input_data.storerId)
+ local nRet, existing_sku = m3.GetDataObjByCondition(strLuaDEID, "SKU", strCondition)
+ lua.DebugEx(strLuaDEID, "鑾峰彇鏉′欢鏌ヨ锛�, existing_sku)
+ if nRet > 1 then
+ return 1, "妫�煡SKU鏄惁瀛樺湪鏃跺け璐� " .. (existing_sku or "鏈煡閿欒")
+ end
+
+ -- 鍒嗛厤SKU瀵硅薄骞惰缃睘鎬� local sku = m3.AllocObject(strLuaDEID, "SKU")
sku.item_code = sku_input_data.skuId
sku.storer = sku_input_data.storerId
sku.short_name = sku_input_data.skuName
sku.item_name = sku_input_data.skuDec
sku.spec = sku_input_data.spec
- sku.udf01 = sku_input_data.packageCode
- sku.udf02 = sku_input_data.packageQty
sku.unit = sku_input_data.goodsUnit
- sku.long = lua.Get_NumAttrValue(sku_input_data.length)
- sku.middle = lua.Get_NumAttrValue(sku_input_data.width)
- sku.short = lua.Get_NumAttrValue(sku_input_data.height)
- sku.abc_type = sku_input_data.abcType
+ sku.long = lua.Get_NumAttrValue(sku_input_data.length) or 0
+ sku.middle = lua.Get_NumAttrValue(sku_input_data.width) or 0
+ sku.short = lua.Get_NumAttrValue(sku_input_data.height) or 0
+ sku.count_method = "Limit"
+ sku.abc_type = sku_input_data.abcType or ""
sku.is_life_mgt = (sku_input_data.isBatchMgr == "1" and 'Y') or 'N'
sku.is_sn_mgt = (sku_input_data.isSnMgr == "1" and 'Y') or 'N'
- sku.udf03 = sku_input_data.isSnStorageMgr
- sku.img_url = sku_input_data.imgUrl
+ sku.img_url = sku_input_data.imgUrl or ""
+ lua.DebugEx(strLuaDEID, "cell_type", sku_input_data.cidtype)
sku.cell_type = sku_input_data.cidtype
- sku.prod_line = sku_input_data.productLine
- sku.udf04 = sku_input_data.storageConditions
sku.item_type = sku_input_data.skuType
- sku.loading_limit = lua.Get_NumAttrValue(sku_input_data.maxCount)
-
- -- 妫�煡SKU鏄惁宸插瓨鍦�- local id
- local strCondition = "S_ITEM_CODE = '" .. sku.item_code .. "' AND S_STORER = '" .. sku.storer .. "'"
- nRet, id, strRetInfo = mobox.getDataObjAttrByKeyAttr(strLuaDEID, "SKU", strCondition)
-
- if nRet > 1 then
- return 1, "妫�煡SKU鏄惁瀛樺湪鏃跺け璐� " .. strRetInfo
- end
-
+ sku.loading_limit = lua.Get_NumAttrValue(sku_input_data.maxCount) or 0
+ sku.udf01 = sku_input_data.productLine or ""
+ sku.udf03 = sku_input_data.isSnStorageMgr or ""
+ sku.udf02 = sku_input_data.storageConditions or ""
+ sku.udf04 = sku_input_data.packageCode or ""
+ sku.udf05 = lua.Get_NumAttrValue(sku_input_data.packageQty) or 0
+ sku.sku_grid_parm = sku_grid_parm;
+ lua.DebugEx(strLuaDEID, "鏇存柊/鍒涘缓鏁版嵁", sku)
+ lua.DebugEx(strLuaDEID, "鏇存柊/鍒涘缓鏁版嵁", sku.cell_type)
if nRet == 1 then
- -- SKU涓嶅瓨鍦紝鍒涘缓鏂癝KU
+ -- SKU涓嶅瓨鍦紝鍒涘缓鏂拌褰� nRet, strRetInfo = m3.CreateDataObj(strLuaDEID, sku)
if nRet ~= 0 then
return 1, "鍒涘缓SKU澶辫触: " .. strRetInfo .. " skuId = " .. sku_input_data.skuId
end
else
- -- SKU宸插瓨鍦紝鏇存柊灞炴�
+ -- SKU宸插瓨鍦紝鏇存柊璁板綍
local update_sku_obj = {{
- id = id,
+ id = existing_sku.id,
attrs = {{
attr = "S_ITEM_NAME",
value = sku.item_name
@@ -180,9 +350,6 @@
attr = "S_CELL_TYPE",
value = sku.cell_type
}, {
- attr = "S_PROD_LINE",
- value = sku.prod_line
- }, {
attr = "N_LOADING_LIMIT",
value = sku.loading_limit
}, {
@@ -206,18 +373,34 @@
}, {
attr = "S_UDF04",
value = sku.udf04
+ }, {
+ attr = "S_UDF05",
+ value = sku.udf05
+ }, {
+ attr = "S_SKU_GRID_PARM",
+ value = sku.sku_grid_parm
}}
}}
-
nRet, strRetInfo = mobox.updateDataObj(strLuaDEID, "SKU", lua.table2str(update_sku_obj))
+ lua.DebugEx(strLuaDEID, "鏇存柊杩斿洖鍊�, nRet)
if nRet ~= 0 then
return 1, "鏇存柊SKU灞炴�澶辫触: " .. strRetInfo
end
end
- -- 澶勭悊SKU_UPC
+ -- 澶勭悊浜у搧绾挎暟鎹�+ if sku_input_data.productLine and sku_input_data.productLine ~= "" then
+ local proline_no = sku_input_data.productLine
+ local proline_name = string.match(proline_no, "KH%-(.+)") or proline_no
+ nRet, strRetInfo = create_or_update_proline(strLuaDEID, proline_no, proline_name)
+ if nRet ~= 0 then
+ return 1, "澶勭悊浜у搧绾挎暟鎹け璐� " .. strRetInfo
+ end
+ end
+
+ -- 澶勭悊SKU_UPC鏉＄爜
local upc_codes = {sku_input_data.sptm, sku_input_data.barcode1, sku_input_data.barcode2, sku_input_data.barcode3,
- sku_input_data.barcode_pk}
+ sku_input_data.barcode_pk, sku_input_data.upc}
for _, upc_code in ipairs(upc_codes) do
if upc_code and upc_code ~= '' then
@@ -228,14 +411,26 @@
end
end
+ -- 澶勭悊SKU_GridBox_Parm鏂欑鏍煎弬鏁�+ nRet, strRetInfo = create_or_update_sku_gridbox(strLuaDEID, sku, sku_input_data)
+ if nRet ~= 0 then
+ return 1, "澶勭悊SKU_GridBox_Parm澶辫触: " .. strRetInfo
+ end
+
return 0
end
+-- Main鍑芥暟
function SKU_Sync(strLuaDEID)
+ -- 鍒濆鍖栨渶缁堢粨鏋�+ local FinalRes = Create_result()
+
-- 1. 鑾峰彇xml鏁版嵁鍖� local nRet, soap_xml = mobox.getCurEditDataPacket(strLuaDEID)
if nRet ~= 0 then
FinalRes = Create_result("failure", "201", "鏃犳硶鑾峰彇鏁版嵁鍖� " .. soap_xml)
+ local xml_result = xml.json_to_xml(FinalRes, "response")
+ mobox.returnValue(strLuaDEID, 0, xml_result, 0)
lua.Stop(strLuaDEID, "鑾峰彇鏁版嵁鍖呭け璐�, FinalRes)
return
end
@@ -244,6 +439,8 @@
local nRet, parsed_data = xml.parse(soap_xml)
if nRet ~= 0 then
FinalRes = Create_result("failure", "202", "xml鏍煎紡闈炴硶")
+ local xml_result = xml.json_to_xml(FinalRes, "response")
+ mobox.returnValue(strLuaDEID, 0, xml_result, 0)
lua.Stop(strLuaDEID, "xml鏍煎紡闈炴硶", FinalRes)
return
end
@@ -252,35 +449,34 @@
local sku_data = parsed_data.Envelope.Body.inCommodityReq.COMMODITY_Input.InputParameters.COMMODITY_TB
if not sku_data or not sku_data.COMMODITY_TB_ITEM then
FinalRes = Create_result("failure", "203", "xml鏁版嵁鏍煎紡閿欒锛岀己灏慍OMMODITY_TB_ITEM")
+ local xml_result = xml.json_to_xml(FinalRes, "response")
+ mobox.returnValue(strLuaDEID, 0, xml_result, 0)
lua.Stop(strLuaDEID, "xml鏁版嵁鏍煎紡閿欒", FinalRes)
return
end
- -- 4. 缁熶竴澶勭悊锛氱‘淇漵ku_items鏄暟缁勶紙鍗充娇鍙湁涓�釜SKU锛�+ -- 4. 缁熶竴澶勭悊锛氱‘淇漵ku_items鏄暟缁� local sku_items = sku_data.COMMODITY_TB_ITEM
if sku_items[1] == nil then
sku_items = {sku_items}
end
-- 5. 閬嶅巻鎵�湁SKU鏁版嵁
- local FinalRes = Create_result()
for i = 1, #sku_items do
local sku_item = sku_items[i]
-
-- 鍒涘缓SKU鍙婂叾UPC
local nRet, err_msg = create_sku(strLuaDEID, sku_item)
if nRet ~= 0 then
- -- 璁板綍璀﹀憡鏃ュ織
wms_base.Warning(strLuaDEID, 1, 601, err_msg, "浠嶨K-WMS绯荤粺鍚屾SKU淇℃伅")
-
- -- 璁剧疆閿欒缁撴灉骞跺仠姝㈠鐞�- FinalRes = Create_result("failure", "204", "SKU鍚屾澶辫触", err_msg)
+ FinalRes = Create_result("failure", "204", "SKU鍚屾澶辫触: " .. err_msg)
+ local xml_result = xml.json_to_xml(FinalRes, "response")
+ mobox.returnValue(strLuaDEID, 0, xml_result, 0)
lua.Stop(strLuaDEID, "SKU鍚屾澶辫触: " .. sku_item.skuId, FinalRes)
return
end
end
-
-- 6. 杩斿洖鎴愬姛
+ FinalRes = Create_result("success", "0", "SKU鍚屾鎴愬姛")
local xml_result = xml.json_to_xml(FinalRes, "response")
mobox.returnValue(strLuaDEID, 0, xml_result, 0)
end
--
Gitblit v1.9.1