Vi du phan hoi
{
"Conversionunit": [
{
"item_no": "ITEM-001",
"conversion_unit": "BOX",
"molecular": "1",
"denominator": "500",
"remark": "500 cai moi thung",
"tran_status": "AU"
}
]
}
Logic xu ly
Thiet ke khoa chinh phuc hop
Su dung ITEM_NO (ma hang) +
CONVERSION_UNIT (don vi quy doi) lam khoa chinh phuc hop.
Cung mot ma hang co the thiet lap nhieu don vi quy doi, vi du:
• ITEM-001 + BOX (thung)
• ITEM-001 + CTN (thung carton)
• ITEM-001 + PAL (pallet)
Xu ly chong loi mau so
Mau so ty le quy doi (DENOMINATOR) khong duoc bang 0, chuong trinh se tu dong dat thanh 1:
IF denominator = 0 THEN denominator = 1
Ban ghi EAI_PARAMETER
Sau khi dong bo thanh cong lan dau, he thong se tao ban ghi trong bang EAI_PARAMETER,
cac lan thuc hien sau se tu dong su dung LAST_SUCCESS_TIME lam tham so data_time.
SQL cap nhat co so du lieu
Xac dinh them moi hoac cap nhat
SELECT COUNT(1) FROM ITEM_CONVERSION_UNIT
WHERE ITEM_NO = N'{item_no}' AND CONVERSION_UNIT = N'{conversion_unit}'
-- count > 0 → UPDATE, count = 0 → INSERT
INSERT (Them moi don vi quy doi)
INSERT INTO ITEM_CONVERSION_UNIT (
ITEM_NO, CONVERSION_UNIT,
CONVERSION_RATE_MOLECULAR, CONVERSION_RATE_DENOMINATOR,
REMARK, TRAN_STATUS, SYNC_TIME, CREATE_TIME, UPDATE_TIME
) VALUES (
:ITEM_NO,
:CONVERSION_UNIT,
:molecular,
:denominator,
:remark,
:tran_status,
N'{thoi gian hien tai}',
N'{thoi gian hien tai}',
N'{thoi gian hien tai}'
)
UPDATE (Cap nhat don vi quy doi)
UPDATE ITEM_CONVERSION_UNIT SET
CONVERSION_RATE_MOLECULAR = :molecular,
CONVERSION_RATE_DENOMINATOR = :denominator,
REMARK = :remark,
TRAN_STATUS = :tran_status,
UPDATE_TIME = N'{thoi gian hien tai}'
WHERE ITEM_NO = :ITEM_NO AND CONVERSION_UNIT = :CONVERSION_UNIT
Gia tri mac dinh cua truong
Neu ERP khong tra ve cac truong sau, tu dong dien gia tri mac dinh:
• CONVERSION_RATE_MOLECULAR = 1
• CONVERSION_RATE_DENOMINATOR = 1 (khong duoc bang 0)
• REMARK = '' (chuoi rong)
• TRAN_STATUS = '' (chuoi rong)