op.get - Du lieu co ban quy trinh

Thong tin co ban

Ten API

op.get

Ten phuong thuc

upOperationCROSS

Bang du lieu dich

OPERATION

Node JSON

op_data

Khoa chinh

ERP_OPID + ERP_WSID (phuc hop)

Vi tri chuong trinh

RegularESB.java:2230

Truong phan hoi

Truong ERP	Truong MES	Mo ta
`op_no`	ERP_OPID	Ma quy trinh
`workstation_no`	ERP_WSID	Ma tram lam viec
`op_no + "---" + workstation_no`	ID	ID phuc hop
`op_name`	NAME	Ten quy trinh
`description`	DESCRIPTION	Mo ta quy trinh
`outsourcing_type`	COMPLEXION	Y→2(gia cong ngoai), N→1(tu lam)
`tran_status`	TRAN_STATUS	Trang thai giao dich

Vi du phan hoi

{
  "op_data": [
    {
      "op_no": "OP001",
      "workstation_no": "WS001",
      "op_name": "Cong viec lap rap",
      "description": "Lap rap bo mach chinh",
      "outsourcing_type": "N",
      "modify_no": "USER001",
      "tran_status": "AU"
    }
  ]
}

Logic xu ly

Quy tac to hop ID

OPERATION.ID = op_no + "---" + workstation_no
Vi du: OP001---WS001

Chuyen doi nhan hieu gia cong ngoai

outsourcing_type = "Y" → COMPLEXION = 2 (quy trinh gia cong ngoai)
outsourcing_type = "N" → COMPLEXION = 1 (quy trinh tu lam)

SQL cap nhat co so du lieu

Xac dinh them moi hoac cap nhat

SELECT COUNT(1) FROM OPERATION
WHERE ERP_OPID = N'{op_no}' AND ERP_WSID = N'{workstation_no}'
-- count > 0 → UPDATE, count = 0 → INSERT

INSERT (Them moi quy trinh)

INSERT INTO OPERATION (
    ID, NAME, DESCRIPTION, COMPLEXION,
    ERP_OPID, WORKSTATIONID, ERP_WSID,
    LASTMAINTAINUSER, LASTMAINTAINDATETIME, FLAG
) VALUES (
    :Opid---:Wsid,          -- ID phuc hop
    :Opname,
    :Opdescription,
    :Opcomplexion,          -- 1=tu lam, 2=gia cong ngoai
    :Opid,
    :Wsid,
    :Wsid,
    :userid,
    N'{thoi gian hien tai}',
    0
)

UPDATE (Cap nhat quy trinh)

UPDATE OPERATION SET
    ID = :newid,
    NAME = :Opname,
    DESCRIPTION = :Opdescription,
    COMPLEXION = :Opcomplexion,
    ERP_OPID = :Opid,
    WORKSTATIONID = :Wsid,
    ERP_WSID = :Wsid,
    LASTMAINTAINUSER = :userid,
    LASTMAINTAINDATETIME = N'{thoi gian hien tai}',
    FLAG = (SELECT MAX(FLAG)+1 FROM OPERATION
            WHERE ERP_OPID = :Opid AND ERP_WSID = :Wsid)
WHERE ID IN (:id)