wo.update - Cap nhat lenh san xuat

1. Thong tin co ban

Muc	Mo ta
Ten API tieng Viet	Cap nhat lenh san xuat (Dieu chinh so luong/Ngay)
Ten API tieng Anh	Work Order Update
Ma API	`wo.update`
So an	0189142
REST Endpoint	`POST /ESB/API/upModetail`
Huong goi	ERP → MES
Thoi diem goi	Sau khi ERP sua so luong hoac ngay lenh, dong bo den MES
Tinh huong nghiep vu chinh	ERP dieu chinh san luong hoac ngay lich trinh, dong bo cap nhat du lieu lenh va lo trong MES
Dinh dang Request	JSON (Content-Type: application/json)
Dong bo/Bat dong bo	Goi dong bo
Quan ly giao dich	Can thiet

Giai thich huong goi
API nay la ERP → MES day mot chieu.
OperationType = 2 bieu thi thao tac sua doi.

2. Quy trinh nghiep vu

Anh xa ma nguon

Diem vao API: WoUpdate.java:59-100
Kiem tra so luong: RegularESB.java:1234-1319
Cap nhat LOT: RegularESB.java:1243-1472
Tinh lai quy trinh: SFT_OP_REALRUN.sqlUpdate_RecalculateAll()

3. Quy cach Request

Dinh dang truyen: JSON
Content-Type: application/json

3.1 Cau truc ngoai

Truong	Kieu	Bat buoc	Mo ta
CompanyID	string	Y	Ma cong ty
OperationType	int	Y	Loai thao tac (2=Sua doi)
content	array	Y	Mang du lieu lenh san xuat

3.2 Noi dung mang content

Truong	Kieu	Bat buoc	Mo ta	Truong thay doi
wo_no	string	Y	So lenh san xuat (Loai-So)	Truong dieu kien
item_no	string	Y	Ma san pham	ITEMID
unit_no	string	Y	Ma don vi	UNIT
plan_date_s	string	Y	Ngay bat dau du kien	PLANPROCESSST
plan_date_e	string	Y	Ngay hoan thanh du kien	DUEDATETIME
wo_qty	decimal	Y	San luong moi du kien	QTY / PLANRELEASEQTY / LOT.LOTSIZE
so_no	string	N	So don hang	DOID
so_seq	string	N	Muc don hang	SEQUENCE
factory_no	string	Y	Ma nha may	FACTORYID
warehouse_no	string	N	Ma kho	WAREHOUSEID
remark	string	N	Ghi chu	DESCRIPTION
priority	string	N	Muc uu tien	MO032

4. Quy cach Response

Truong	Kieu	Mo ta
code	string	200=Thanh cong, 500=That bai
msg	string	Thong bao ket qua xu ly
query	array	Ket qua truy van

Hanh vi khi thanh cong

UPDATE MODETAIL (Bang chinh lenh: QTY, DOID, ngay v.v.)
UPDATE/INSERT/DELETE LOT (Dieu chinh so luong lo)
SFT_OP_REALRUN.sqlUpdate_RecalculateAll() (Tinh lai quy trinh)

5. Logic kiem tra so luong

Dinh nghia bien quan trong

MOQTY: MODETAIL.PLANRELEASEQTY (So luong phat hanh du kien ban dau)
MOREQTY: MODETAIL.RELEASEDQTY (So luong da phat hanh)
LOTQTY: LOT.LOTSIZE (So luong cho phat hanh)
newQTY: San luong moi tu ERP truyen vao
MODIQTY: Tong SFT_MO_MODI (So luong phat hanh bo sung)
BATQTY: Tong SFT_BATCH_REC (So luong tach lo)

5.1 Truong hop tang so luong

newQTY > (MOQTY - MODIQTY)

// Tang so luong - Tang truc tiep
So luong tang = newQTY - (MOQTY - MODIQTY)

IF LOT ton tai THEN
    UPDATE LOT SET LOTSIZE += So luong tang
ELSE
    INSERT LOT (Tao ban ghi lo moi)
END IF

UPDATE MODETAIL SET PLANRELEASEQTY += So luong tang

5.2 Truong hop giam so luong

newQTY < (MOQTY - MODIQTY)

// Giam so luong - Can kiem tra han muc thay doi
Han muc thay doi toi da = MOQTY - MOREQTY - BATQTY
So luong thay doi lan nay = MOQTY - newQTY - MODIQTY

IF Han muc thay doi toi da >= So luong thay doi lan nay THEN
    // Co the giam
    IF LOTQTY - So luong thay doi lan nay > 0 THEN
        UPDATE LOT SET LOTSIZE -= So luong thay doi lan nay
    ELSE
        DELETE FROM LOT  // So luong sau khi giam bang khong hoac am
    END IF
    UPDATE MODETAIL SET PLANRELEASEQTY -= So luong thay doi lan nay
ELSE
    // Khong the giam - Da phat hanh hoac tach lo vuot qua han muc thay doi
    Throw Exception("JS_0126_00060")
END IF

Gioi han quan trong
Neu so luong da phat hanh + so luong tach lo cua MES > san luong moi, khong the giam, se tra ve loi JS_0126_00060.

6. Ma loi

Ma	Thong bao	Mo ta
JS_0126_00060	So luong thay doi nho hon so luong cho phat hanh, khong cho phep thay doi	So luong giam vuot qua han muc thay doi
JS_0096_00058	Ma san pham nay khong ton tai	Khong co ma san pham trong bang ITEM
JS_0016_00134	Don vi khong ton tai, vui long kiem tra	Khong co don vi trong UnitBasis
JS_0016_00115	Ma nha may khong ton tai	Khong co nha may trong FACTORY
JS_0135_00036	Ma kho nay khong ton tai	Khong co kho trong WAREHOUSE
remind_002	Du lieu khong ton tai	So lenh khong ton tai

7. Vi du JSON

Request (Tang so luong)

{
  "CompanyID": "COMP01",
  "OperationType": 2,  // 2=Sua doi
  "content": [{
    "wo_no": "5101-20260319001",
    "item_no": "FG-A001-001",
    "unit_no": "PCS",
    "plan_date_s": "2026-03-19 08:00:00",
    "plan_date_e": "2026-03-21 17:00:00",
    "wo_qty": 1500,  // Ban dau 1000, tang 500
    "factory_no": "P001",
    "remark": "Them don hang"
  }]
}

Request (Giam so luong)

{
  "CompanyID": "COMP01",
  "OperationType": 2,
  "content": [{
    "wo_no": "5101-20260319001",
    "item_no": "FG-A001-001",
    "unit_no": "PCS",
    "plan_date_s": "2026-03-19 08:00:00",
    "plan_date_e": "2026-03-20 17:00:00",
    "wo_qty": 800,  // Ban dau 1000, giam 200
    "factory_no": "P001",
    "remark": "Khach hang giam don hang"
  }]
}

Response (Thanh cong)

{
  "code": "200",
  "msg": "success",
  "query": []
}

Response (That bai - Khong the giam)

{
  "code": "500",
  "msg": "JS_0126_00060",  // So luong da phat hanh vuot qua so luong moi
  "query": []
}

8. SQL cap nhat co so du lieu

8.1 UPDATE MODETAIL (Cap nhat bang chinh lenh)

UPDATE MODETAIL SET
    PLANPROCESSST = :PLANPROCESSST,      -- Ngay bat dau du kien
    DUEDATETIME = :DUEDATETIME,          -- Ngay hoan thanh du kien
    DOID = :DOID,                        -- So don hang
    SEQUENCE = :SEQUENCE,                -- Muc don hang
    FACTORYID = :FACTORYID,              -- Ma nha may
    WAREHOUSEID = :WAREHOUSEID,          -- Ma kho
    DESCRIPTION = :DESCRIPTION,          -- Ghi chu
    MO032 = :MO032,                      -- Muc uu tien
    LASTMAINTAINUSER = :userid,
    LASTMAINTAINDATETIME = N'{thoi gian hien tai}',
    FLAG = (SELECT MAX(FLAG)+1 FROM MODETAIL WHERE CMOID = :CMOID)
WHERE CMOID = :CMOID

8.2 Khi tang so luong (UPDATE LOT)

-- So luong tang = newQTY - (MOQTY - MODIQTY)
UPDATE LOT SET
    LOTSIZE = LOTSIZE + {so luong tang}
WHERE MOID = :CMOID

-- Dong thoi cap nhat so luong phat hanh du kien MODETAIL
UPDATE MODETAIL SET
    PLANRELEASEQTY = PLANRELEASEQTY + {so luong tang},
    QTY = :newQTY
WHERE CMOID = :CMOID

8.3 Khi giam so luong (UPDATE/DELETE LOT)

-- So luong giam = MOQTY - newQTY - MODIQTY
-- Kiem tra han muc thay doi truoc
Han muc thay doi toi da = MOQTY - MOREQTY - BATQTY

IF LOTQTY - So luong giam > 0 THEN
    -- Van con so du sau khi giam
    UPDATE LOT SET
        LOTSIZE = LOTSIZE - {so luong giam}
    WHERE MOID = :CMOID
ELSE
    -- So luong sau khi giam bang khong hoac am, xoa lo
    DELETE FROM LOT WHERE MOID = :CMOID
END IF

-- Dong thoi cap nhat so luong phat hanh du kien MODETAIL
UPDATE MODETAIL SET
    PLANRELEASEQTY = PLANRELEASEQTY - {so luong giam},
    QTY = :newQTY
WHERE CMOID = :CMOID

8.4 Tinh lai quy trinh

-- Tinh lai tat ca quy trinh sau khi cap nhat xong
SFT_OP_REALRUN.sqlUpdate_RecalculateAll("updateMODETAIL")

Bang du lieu lien quan kiem tra so luong

MODETAIL.PLANRELEASEQTY: So luong phat hanh du kien (MOQTY)
MODETAIL.RELEASEDQTY: So luong da phat hanh (MOREQTY)
LOT.LOTSIZE: So luong cho phat hanh (LOTQTY)
SFT_MO_MODI: So luong phat hanh bo sung (MODIQTY)
SFT_BATCH_REC: So luong tach lo (BATQTY)

Vi tri chuong trinh
Kiem tra so luong: RegularESB.java:1234-1319
Cap nhat LOT: RegularESB.java:1243-1472

Cap nhat lenh san xuat (Dieu chinh so luong/Ngay)