wo.status.process - Thay doi trang thai lenh san xuat

1. Thong tin co ban

Muc	Mo ta
Ten API tieng Viet	Thay doi trang thai lenh san xuat (Xoa/Ket thuc/Huy ket thuc)
Ten API tieng Anh	Work Order Status Process
Ma API	`wo.status.process`
So an	0189142
REST Endpoint	`POST /ESB/API/upModetailStatus`
Huong goi	ERP → MES
Thoi diem goi	Khi ERP xoa, ket thuc hoac huy ket thuc lenh san xuat
Tinh huong nghiep vu chinh	ERP thay doi trang thai lenh, dong bo cap nhat trang thai hoac xoa du lieu lenh trong MES
Dinh dang Request	JSON (Content-Type: application/json)
Dong bo/Bat dong bo	Goi dong bo

Giai thich huong goi
API nay la ERP → MES day mot chieu.
Thuc hien cac thao tac khac nhau dua tren tham so status: Xoa(1), Ket thuc(2), Huy ket thuc(3).

2. Bang doi chieu trang thai

status	Thao tac	Mo ta	Hanh vi MES
1	Xoa lenh san xuat	Xoa lenh va lo lien quan	DELETE MODETAIL / LOT
2	Ket thuc	Hoan thanh/Ket thuc lenh chi dinh	Kiem tra quy trinh chua hoan thanh, thay doi trang thai
3	Huy ket thuc	Khoi phuc lenh da ket thuc	Khoi phuc STATUS (99/100 → trang thai ban dau)

Dinh nghia MODETAIL.STATUS

STATUS	Mo ta
1	Chua san xuat
2	Dang san xuat
3	Cho ket thuc
99	Ket thuc
100	Huy

3. Quy cach Request

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

Truong	Kieu	Bat buoc	Mo ta	Vi du
CompanyId	string	Y	Ma cong ty	"COMP01"
lang	string	N	Ngon ngu	"vi_VN"
wo_no	string	Y	So lenh san xuat (Loai-So)	"5101-20260319001"
status	string	Y	Loai thao tac (1/2/3)	"1"

4. Quy cach Response

Truong	Kieu	Mo ta
code	string	200=Thanh cong, 500=That bai
msg	string	Thong bao ket qua xu ly hoac ma loi

5. Logic xu ly

5.1 status=1 Xoa lenh san xuat

Han che xoa
Neu lenh san xuat da phat hanh (SFT_WS_RUN co ban ghi EXECUTETYPE='release'), khong the xoa, se tra ve loi JS_0126_00062.

5.2 status=2 Ket thuc

Kiem tra ket thuc

Kiem tra SFT_HOLD_REC: Lenh co dang tam dung khong
Kiem tra SFT_OP_REALRUN: Co quy trinh chua hoan thanh khong

5.3 status=3 Huy ket thuc

Dieu kien huy ket thuc
Chi co lenh STATUS=99 (Ket thuc) hoac STATUS=100 (Huy) moi co the thuc hien thao tac huy ket thuc.

6. Ma loi

Ma	Thong bao	Dieu kien kich hoat	Tuong ung status
JS_0126_00062	Lenh da phat hanh, khong the xoa	SFT_WS_RUN co ban ghi phat hanh	status=1
JS_0115_00014	Lenh dang tam dung, vui long giai phong tam dung truoc khi hoan thanh chi dinh	SFT_HOLD_REC co ban ghi tam dung	status=2
JS_0115_00017	Chung tu nay co quy trinh chua hoan thanh, vui long hoan thanh quy trinh truoc khi hoan thanh lenh	SFT_OP_REALRUN co quy trinh chua hoan thanh	status=2
JS_0126_00059	Lenh eMES chua ket thuc, khong the huy	MODETAIL.STATUS khong trong (99,100)	status=3
remind_002	Du lieu khong ton tai	So lenh khong ton tai	tat ca

7. Vi du JSON

Request - Xoa lenh san xuat (status=1)

{
  "CompanyId": "COMP01",
  "lang": "vi_VN",
  "wo_no": "5101-20260319001",
  "status": "1"  // Xoa
}

Request - Ket thuc (status=2)

{
  "CompanyId": "COMP01",
  "lang": "vi_VN",
  "wo_no": "5101-20260319001",
  "status": "2"  // Ket thuc
}

Request - Huy ket thuc (status=3)

{
  "CompanyId": "COMP01",
  "lang": "vi_VN",
  "wo_no": "5101-20260319001",
  "status": "3"  // Huy ket thuc
}

Response (Thanh cong)

{
  "code": "200",
  "msg": "success"
}

Response (That bai - Da phat hanh khong the xoa)

{
  "code": "500",
  "msg": "JS_0126_00062"
}

Response (That bai - Dang tam dung khong the ket thuc)

{
  "code": "500",
  "msg": "JS_0115_00014"
}

Response (That bai - Chua ket thuc khong the huy)

{
  "code": "500",
  "msg": "JS_0126_00059"
}

8. SQL cap nhat co so du lieu

8.1 status=1 Xoa lenh san xuat

-- Kiem tra da phat hanh chua (da phat hanh thi khong the xoa)
SELECT COUNT(*) FROM SFT_WS_RUN WITH (NOLOCK)
WHERE ID = N'{wo_no}'
  AND EXECUTETYPE = 'release'
  AND PLUSINDEX = '0'
-- Neu COUNT > 0, tra ve JS_0126_00062

-- Kiem tra co ban ghi tach lo khong
SELECT COUNT(*) FROM SFT_BATCH_REC WHERE BR001 = N'{wo_no}'
-- Neu COUNT > 0, tra ve remind_004

-- Xoa du lieu lien quan (thuc thi tuan tu)
DELETE FROM SFT_OP_REALRUN WHERE ID = :CMOID
DELETE FROM LOT WHERE MOID = :CMOID
DELETE FROM MODETAIL WHERE CMOID = :CMOID
DELETE FROM SFT_SPEC_MODIREC WHERE MD001 = :CMOID
DELETE FROM SFT_BATCH_REC WHERE BR002 = :CMOID
DELETE FROM EQUIPMENT_RUN WHERE LOTID = :CMOID
DELETE FROM SFT_WS_RUN WHERE ID = :CMOID
DELETE FROM SFT_SPLITOUT_REC WHERE SSR001 = :CMOID
DELETE FROM SFT_ASSEMBLY_REC WHERE SAR001 = :CMOID
DELETE FROM SFT_HOLD_REC WHERE HR001 = :CMOID
DELETE FROM SFT_MO_MODI WHERE MODI002 = :CMOID

8.2 status=2 Ket thuc

-- Kiem tra lenh co dang tam dung khong
jsonQueryFactory.sqlQuery_checkMoidIsHold(dataObject)
-- Neu dang tam dung, tra ve JS_0115_00014

-- Kiem tra co quy trinh chua hoan thanh khong
jsonQueryFactory.checkHaveUndoneOp(dataObject)
-- Neu co quy trinh chua hoan thanh, tra ve JS_0115_00017

-- Thuc hien quy trinh ket thuc (xu ly boi JsonQueryFactory)
-- Cap nhat MODETAIL.STATUS = 99
UPDATE MODETAIL SET
    STATUS = 99,
    LASTMAINTAINUSER = :userid,
    LASTMAINTAINDATETIME = N'{thoi gian hien tai}'
WHERE CMOID = :CMOID

8.3 status=3 Huy ket thuc

-- Kiem tra lenh da ket thuc chua
SELECT COUNT(*) FROM MODETAIL WITH (NOLOCK)
WHERE CMOID = N'{wo_no}'
  AND STATUS NOT IN ('99', '100')
-- Neu COUNT > 0, bieu thi chua ket thuc, tra ve JS_0126_00059

-- Khoi phuc trang thai ket thuc (thuc hien nguoc lai quy trinh ket thuc)
-- Xac dinh trang thai khoi phuc dua tren ban ghi nhap tram SFT_WS_RUN
UPDATE MODETAIL SET
    STATUS = CASE
        WHEN (SELECT COUNT(1) FROM SFT_WS_RUN WITH (NOLOCK)
              WHERE ID = N'{wo_no}' AND EXECUTETYPE = 'checkIn') > 0
        THEN 2  -- Co ban ghi nhap tram → Dang san xuat
        ELSE 1  -- Khong co ban ghi nhap tram → Chua san xuat
    END,
    LASTMAINTAINUSER = :userid,
    LASTMAINTAINDATETIME = N'{thoi gian hien tai}'
WHERE CMOID = :CMOID

Mo ta bang du lieu lien quan bi xoa

Bang du lieu	Mo ta
SFT_OP_REALRUN	Ban ghi thuc te quy trinh
LOT	Ban ghi lo
MODETAIL	Bang chinh lenh san xuat
SFT_SPEC_MODIREC	Ban ghi sua doi dac biet
SFT_BATCH_REC	Ban ghi tach lo
EQUIPMENT_RUN	Ban ghi van hanh thiet bi
SFT_WS_RUN	Ban ghi van hanh tram lam viec
SFT_SPLITOUT_REC	Ban ghi tach ra
SFT_ASSEMBLY_REC	Ban ghi lap rap
SFT_HOLD_REC	Ban ghi tam dung
SFT_MO_MODI	Ban ghi so luong phat hanh bo sung

Vi tri chuong trinh
Diem vao API: ESBapi.java:1400-1493
Kiem tra trang thai: WoStatusProcess.java:66-108