item.supplier.get - Du lieu nha cung cap vat lieu

Thong tin co ban

Ten API

item.supplier.get

Ten phuong thuc

upItemSupplierCROSS

Bang du lieu dich

material_catalog

Node JSON

item_supplier_data

Khoa chinh

material_id (item_no)

Vi tri chuong trinh

RegularESB.java:4225

Truong phan hoi

Truong ERP	Truong MES	Mo ta
`item_no`	material_id	Ma hang (khoa chinh)
`modify_no`	-	Nguoi thay doi
`tran_status`	TRAN_STATUS	Trang thai giao dich

Vi du phan hoi

{
  "item_supplier_data": [
    {
      "item_no": "MAT001",
      "modify_no": "USER001",
      "tran_status": "AU"
    }
  ]
}

Logic xu ly

Phu thuoc vao bang ITEM

API nay se truy van bang ITEM truoc de lay thong tin ten hang (NAME), quy cach (DESCRIPTION), don vi (UNIT). Neu ma hang khong ton tai trong bang ITEM, se bo qua ban ghi do (continue).

SQL cap nhat co so du lieu

Truy van truoc bang ITEM

-- Lay thong tin co ban ma hang truoc
SELECT NAME, DESCRIPTION, UNIT FROM ITEM WHERE ID = :item_no

-- Neu ITEM khong ton tai thi bo qua (continue)

Xac dinh them moi hoac cap nhat

SELECT COUNT(1) FROM material_catalog WHERE material_id = N'{item_no}'
-- count > 0 → UPDATE, count = 0 → INSERT

INSERT (Them moi nha cung cap vat lieu)

INSERT INTO material_catalog (
    material_id, material_name, norm, unit_no,
    operation_id, operation_name, oper_date, oper_id,
    mc01, mc02, mc03, mc04
) VALUES (
    :material_id,
    :material_name,        -- Lay tu ITEM.NAME
    :norm,                 -- Lay tu ITEM.DESCRIPTION
    :unit_no,              -- Lay tu ITEM.UNIT
    :operation_id,
    :operation_name,
    N'{thoi gian hien tai}',
    :oper_id,
    :mc01, :mc02, :mc03, :mc04
)

UPDATE (Cap nhat nha cung cap vat lieu)

UPDATE material_catalog SET
    material_name = :material_name,
    norm = :norm,
    unit_no = :unit_no,
    operation_id = :operation_id,
    operation_name = :operation_name,
    mc01 = :mc01,
    mc02 = :mc02,
    mc03 = :mc03,
    mc04 = :mc04
WHERE material_id = :material_id