wo.create - Them moi lenh san xuat

1. Thong tin co ban

Muc	Mo ta
Ten API tieng Viet	Them moi lenh san xuat
Ten API tieng Anh	Work Order Create
Ma API	`wo.create`
So an	0189142
REST Endpoint	`POST /ESB/API/upModetail`
Huong goi	ERP → MES
Thoi diem goi	Sau khi ERP tao lenh san xuat moi, dong bo den MES
Tinh huong nghiep vu chinh	ERP tao lenh san xuat, day thong tin den MES, MES tao ban ghi lenh, lo va quy trinh tuong ung
Dinh dang Request	JSON (Content-Type: application/json)
Dong bo/Bat dong bo	Goi dong bo
Quan ly giao dich	Can thiet (setAutoCommit(false) + transactionCommit())

Giai thich huong goi
API nay la ERP → MES day mot chieu, ERP chu dong goi giao dien MES de them du lieu lenh san xuat.

2. Quy trinh nghiep vu

Anh xa ma nguon

Diem vao API: WoCreate.java (SFT_ERPIntegrate)
Logic chinh: RegularESB.upModetail() (SFT_dataImport)
Thuc thi SQL: ESBapi.java:975-1007 (KMI_Restful)
Khoi tao quy trinh: dataMantain.initOpRealRun_SftBommf()

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 (1=Them moi)
content	array	Y	Mang du lieu lenh san xuat

3.2 Noi dung mang content

Truong	Kieu	Do dai	Bat buoc	Mo ta	Truong MES
wo_no	string	40	Y	So lenh san xuat (Loai-So)	CMOID
item_no	string	40	Y	Ma san pham	ITEMID
unit_no	string	10	Y	Ma don vi	UNIT
plan_date_s	string	19	Y	Ngay bat dau du kien (yyyy-MM-dd HH:mm:ss)	PLANPROCESSST
plan_date_e	string	19	Y	Ngay hoan thanh du kien (yyyy-MM-dd HH:mm:ss)	DUEDATETIME
wo_qty	decimal	-	Y	San luong du kien	QTY / PLANRELEASEQTY
so_no	string	40	N	So don hang	DOID
so_seq	string	10	N	Muc don hang	SEQUENCE
factory_no	string	10	Y	Ma nha may	FACTORYID
warehouse_no	string	10	N	Ma kho	WAREHOUSEID
remark	string	500	N	Ghi chu	DESCRIPTION
priority	string	1	N	Muc uu tien (1=Gap, 0=Khong)	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 (khi thanh cong tra ve so lenh)
query	array	Ket qua truy van (thuong la mang rong)

Hanh vi khi thanh cong

INSERT MODETAIL (Bang chinh lenh san xuat)
INSERT LOT (Ban ghi lo)
Khoi tao SFT_OP_REALRUN (Ban ghi thuc te quy trinh)
Tinh toan thoi gian quy trinh (initProcessTime)

5. Quy tac kiem tra

#	Muc kiem tra	Quy tac	Ma loi
1	Trung so lenh	CMOID khong duoc trung trong MODETAIL	JS_0126_00061
2	Ma san pham ton tai	ITEMID phai ton tai trong bang ITEM	JS_0096_00058
3	Don vi ton tai	unit_no phai ton tai trong UnitBasis	JS_0016_00134
4	Nha may ton tai	factory_no phai ton tai trong FACTORY	JS_0016_00115
5	Kho ton tai	warehouse_no (neu co) phai ton tai trong WAREHOUSE	JS_0135_00036
6	Kiem tra so luong	wo_qty phai lon hon 0	-

6. Ma loi

Ma	Thong bao	Mo ta
JS_0126_00061	So lenh da ton tai, khong the them moi	CMOID trung
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_001	Du lieu da ton tai	Them moi trung

7. Vi du JSON

Request

{
  "CompanyID": "COMP01",
  "OperationType": 1,
  "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": 1000,
    "so_no": "SO20260301001",
    "so_seq": "001",
    "factory_no": "P001",
    "warehouse_no": "FG01",
    "remark": "Don gap",
    "priority": "1"
  }]
}

Response (Thanh cong)

{
  "code": "200",
  "msg": "[\"5101-20260319001\"]",
  "query": []
}

Response (That bai - Lenh da ton tai)

{
  "code": "500",
  "msg": "JS_0126_00061",
  "query": []
}

8. Bang du lieu lien quan

8.1 MODETAIL (Bang chinh lenh san xuat)

Truong	Kieu	Mo ta
CMOID	NVARCHAR(40)	PK: So lenh san xuat (Loai-So)
MO004	NVARCHAR(10)	Loai lenh
MO005	NVARCHAR(20)	So lenh
ITEMID	NVARCHAR(40)	Ma san pham
QTY	FLOAT	San luong du kien
PLANRELEASEQTY	FLOAT	So luong phat hanh du kien
RELEASEDQTY	FLOAT	So luong da phat hanh
STATUS	INT	Trang thai (1=Chua san xuat 2=Dang san xuat 99=Ket thuc 100=Huy)
PLANPROCESSST	DATETIME	Ngay bat dau du kien
DUEDATETIME	DATETIME	Ngay hoan thanh du kien
FLAG	INT	So phien ban

8.2 LOT (Ban ghi lo)

Truong	Kieu	Mo ta
ID	NVARCHAR(40)	PK: So lo (thuong = CMOID)
MOID	NVARCHAR(40)	FK: So lenh san xuat
TYPE	INT	Loai lo (1=Lo ke hoach)
LOTSIZE	FLOAT	So luong lo (So luong cho phat hanh)
STATUS	INT	Trang thai (0=Cho phat hanh 1=Da phat hanh)
LOCATION	NVARCHAR(20)	Vi tri (thuong='release')